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:
Hi,
As you declared your input shapefile to be in 4326 (which is lat/lon),
Postgis doesn't transform anything in your coordinates when you ask for
lat/lon.
Try to set the proper SRID for Dubai Local Transverse Mercator using
SELECT setSRID(the_geom,the_srid) FROM ult.test2;
Note that you may
Hi Mehmet,
When you imported the shapefile, the SRID you are meant to specify is the
SRID of the data, not the SRID you want. Since the data is in Dubai Local
TM, the SRID is 3997. To get the transformation you want, try the
following:
select ST_AsText(
Discussion
Subject: Re: [postgis-users] Converting UTM to lat/lon using Postgis
Hi Mehmet,
When you imported the shapefile, the SRID you are meant to specify is
the SRID of the data, not the SRID you want. Since the data is in Dubai
Local TM, the SRID is 3997. To get the transformation you want, try
:
From: Mehmet Erkek mer...@reidin.com
Subject: Re: [postgis-users] Converting UTM to lat/lon using Postgis
To: PostGIS Users Discussion postgis-users@postgis.refractions.net
Date: Monday, May 3, 2010, 7:50 PM
Thank you for the fast answer!
Hmm. It looks I don’t have srid 3997