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:
upda
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 constructi