Get Latitude and Longitude from Geometry Point in PostGres
How to get Longitude/Latitude from Geography Data in PostGIS
In the previous post I explained how to Convert Latitude, Longitude to Geography Point in PostGIS. Now I will show you how to get latitude, longitude form the geometry point data in PostGIS using simple query.
Select ST_Y(s."LatLng") as latitude, ST_X(s."LatLng") as longitude from "Site" s
For more documentation visit http://postgis.net/docs/manual-1.4/
Get Latitude and Longitude from Geometry Point in PostGres Reviewed by Ravi Kumar on 2:58:00 PM Rating: