[OSM-dev] [OSM-Dev]Convert x, y co-ordinates in Lat,Lon

[Stephen Cavilia]

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.

http://postgis.refractions.net/documentation/manual-1.5/ST_Transform.html

Steve

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
>        lon=25.6585
> 
> Please tell me that
> How to convert it?
> If there any postGis Function to do this?
> 
> 
>