Try <a href="http://www.spatialreference.org/ref/esri/3997/postgis/">http://www.spatialreference.org/ref/esri/3997/postgis/</a> The site is down for me at the moment but should have the goods.<br><br>-Francis<br><br><div class="gmail_quote">
On 3 May 2010 17:50, Mehmet Erkek <span dir="ltr"><<a href="mailto:merkek@reidin.com">merkek@reidin.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Thank you for the fast answer!</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"><br></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Hmm. It looks I don’t have srid 3997 in the DB.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">=# select srid, srtext, proj4text from spatial_ref_sys where
srid=3997;</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> srid | srtext | proj4text</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">------+--------+-----------</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">(0 rows)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">select srid, srtext, proj4text from spatial_ref_sys where
srtext like '%Dubai%';</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> srid | srtext | proj4text</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">------+--------+-----------</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">(0 rows)</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Could this be related to my postgis installation? </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">I don’t see this srid in spatial_ref_sys.sql which came
with postgis installation either. </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Any idea how I can fix this?</span></p><div class="im">
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 8pt; color: rgb(15, 36, 62);">-------------------------------------------------------------------</span></p>
<p class="MsoNormal"><b><span style="font-size: 8pt; color: rgb(15, 36, 62);">Mehmet ERKEK</span></b><b><span style="font-size: 11pt; color: rgb(31, 73, 125);"></span></b></p>
<p class="MsoNormal"><span style="font-size: 8pt; color: rgb(15, 36, 62);"><a href="http://www.reidin.com/" target="_blank"><span style="color: rgb(15, 36, 62);">www.REIDIN.com</span></a></span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
</div><div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of </b>Francis
Markham<br>
<b>Sent:</b> Monday, May 03, 2010 11:09 AM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] Converting UTM to lat/lon using Postgis</span></p>
</div><div><div></div><div class="h5">
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">Hi Mehmet,<br>
<br>
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:</p>
<p class="MsoNormal">select
ST_AsText( ST_Transform(centroid(ST_SetSRID(the_geom, 3997)),4326)) from
ult.test2 limit 5;</p>
<p class="MsoNormal" style="margin-bottom: 12pt;">Hope that helps,<br>
<br>
-Francis</p>
<div>
<p class="MsoNormal">On 3 May 2010 17:03, Mehmet Erkek <<a href="mailto:merkek@reidin.com" target="_blank">merkek@reidin.com</a>> wrote:</p>
<div>
<div>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hi
All,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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. </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Here
is what I run:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">select
ST_AsText( ST_Transform(centroid(the_geom),4326)) from ult.test2 limit 5;</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">and
what I get:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">POINT(496597.996430787
2774798.21242881)</p>
<p class="MsoNormal">POINT(496332.629887436
2793339.61534586)</p>
<p class="MsoNormal">POINT(496302.627327975
2793317.82477318)</p>
<p class="MsoNormal">POINT(496305.255261594
2793353.29646291)</p>
<p class="MsoNormal">POINT(496241.538851096
2774826.65593589)</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">So
far all is fine except coordinates which are not latitude/longitude </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><b><u>My
question is : How can I convert/get these coordinates in lat/lon?</u></b></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">This
what I have in my prj file: </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">PROJCS["Dubai
Local Transverse Mercator
(DLTM)",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",55.33333333333334],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">I
appreciate any help. Thank you.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><span style="font-size: 8pt; color: rgb(15, 36, 62);">-------------------------------------------------------------------</span></p>
<p class="MsoNormal"><b><span style="font-size: 8pt; color: rgb(15, 36, 62);">Mehmet ERKEK</span></b></p>
<p class="MsoNormal"><span style="font-size: 8pt; color: rgb(15, 36, 62);"><a href="http://www.reidin.com/" target="_blank"><span style="color: rgb(15, 36, 62);">www.REIDIN.com</span></a></span></p>
<p class="MsoNormal"> </p>
</div>
<p class="MsoNormal"><br>
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information. If you have received it in
error, please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited. Please Consider the Environment Before
Printing This Email </p>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a></p>
</div>
<p class="MsoNormal"> </p>
</div></div></div><div><div></div><div class="h5">
<br>This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
Please Consider the Environment Before Printing This Email </div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br>