[OSM-dev] [OSM-Dev]Convert x, y co-ordinates in Lat,Lon
ailivac at gmail.com
Tue Jul 13 18:46:11 BST 2010
The actual transformation math depends on what projection the
coordinates are stored in, but there is a SQL function to transform
geometries between spatial reference systems. If the geometry column is
stored with SRID information, you can just call ST_Transform(geometry,
4326) to transform to WGS84 geodetic.
PARVEEN ARORA wrote:
> Hello Everyone,
> I have data in postgis database in x,y co-ordinates format.
> for e.g. in data
> lat =39623724
> lon =361580468
> But i want to convert these into ,
> lat= 75.2635
> Please tell me that
> How to convert it?
> If there any postGis Function to do this?
More information about the dev