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 <[email protected]>
To: [email protected]
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
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
