ST_SetSRID( ST_MakePoint(lon, lat), 4326)
http://postgis.refractions.net/docs/ch06.html
-- Kevin
John Cartwright wrote:
Hello All,
I'm trying to populate a newly-added geometry column in a table using
two existing columns: LON, LAT. The only way I see to do it seems a
little clumsy:
update grid_points set SHAPE = GeomFromText('POINT(' || lon ||' ' ||
lat || ')',4326);
Is there a better way than constructing a WKT string?
Thanks!
-- john
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users