[postgis-users] Converting UTM to lat/lon using Postgis

[Mehmet Erkek]

Hi All,

 

I havea a shape file which I imported it to a table called 'test2'
(using  SRID=4326).  I want to get centroids of geometries in lat/lon. 

 

Here is what I run:

 

select   ST_AsText( ST_Transform(centroid(the_geom),4326)) from
ult.test2 limit 5;

 

and what I get:

 

POINT(496597.996430787 2774798.21242881)

POINT(496332.629887436 2793339.61534586)

POINT(496302.627327975 2793317.82477318)

POINT(496305.255261594 2793353.29646291)

POINT(496241.538851096 2774826.65593589)

 

 

So far all is fine except coordinates which are not  latitude/longitude 

 

My question is : How can I convert/get these coordinates in lat/lon?

 

 

This what I have in my prj file: 

 

PROJCS["Dubai Local Transverse Mercator
(DLTM)",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",637
8137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.017453292
5199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",50
0000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",55.
33333333333334],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Ori
gin",0.0],UNIT["Meter",1.0]]

 

 

And this is my postgis version: POSTGIS="1.3.6" GEOS="2.2.3-CAPI-1.1.1"
PROJ="Rel. 4.7.1, 23 September 2009" USE_STATS

 

I appreciate any help. Thank you.

 

 

-------------------------------------------------------------------

Mehmet ERKEK

www.REIDIN.com <http://www.reidin.com/> 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100503/e6255743/attachment.html>