[postgis-users] Convert from Lat/Long point to postGIS geometry
Brent Wood
pcreso at pcreso.com
Mon Feb 2 20:20:02 PST 2015
Hi.
Try something like:
update <table> set <geometry column> = ST_SetSRID(ST_MakePoint(Longitude, Latitude),4326);
Essentially create a point geometry from your numeric values, with the ST_MakePoint() function, the inform Postgis it is a standard lat/long CS (EPSG:4326 - which you should have specified when you created the column), & update the table with these values for each row. Make sure you use your table & column names....
What mapping/GIS program are you using?
Cheers,
Brent Wood
From: KhunSanAung <khunsanaung.gis at gmail.com>
To: postgis-users at lists.osgeo.org
Sent: Tuesday, February 3, 2015 5:11 PM
Subject: [postgis-users] Convert from Lat/Long point to postGIS geometry
Hi All,
I have one table (Town info) in postgres without Geometry field.I have Latitude and Longitude information for those points data separately (collecting & filling).
I created the postGIS extension and add the Geometry field in the above postgres table.Now, I'd like to add the location information into the postGIS geometry field so that I can immediately view those points on the map.
How can I convert the Latitude/Longitude value into postGIS geometry value?
Thank you very much in advance.
--
Have a nice day!
--
Mr. Khun San Aung
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150203/64af9f01/attachment.html>
More information about the postgis-users
mailing list