<div dir="ltr">SELECT ST_AsText(coord_22523)<br>
FROM coordsformiga limit 2; <br>return:<br> st_astext <br>-------------------------<br> POINT(7650.676 500.29)<br> POINT(7624.401 592.751)<br>(2 rows)<br><br><br><br>SELECT ST_AsText(ST_Transform(coord_<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
22523, 4326))<br>
FROM coordsformiga limit 2;</blockquote>return:<br> st_astext <br>-------------------------------------------<br> POINT(140.139757378998 -89.9975973774248)<br> POINT(140.139757378998 -89.9975973774248)<br>
(2 rows)<br><br><br>SELECT postgis_full_version();<br> postgis_full_version <br>----------------------------------------------------------------------------------<br>
POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS<br>(1 row)<br><br><br><br><br><div class="gmail_quote">On Mon, Aug 4, 2008 at 10:20 AM, Obe, Regina <span dir="ltr"><<a href="mailto:robe.dnd@cityofboston.gov">robe.dnd@cityofboston.gov</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;">Felipe Fedel,<br>
<br>
Can you send a sample of your data - results of the 2 queries below<br>
<br>
SELECT ST_AsText(coord_22523)<br>
FROM coordsformiga limit 2;<br>
<br>
-- and result you get when you do<br>
SELECT ST_AsText(ST_Transform(coord_22523, 4326))<br>
FROM coordsformiga limit 2;<br>
<br>
Also what does<br>
<br>
SELECT postgis_full_version();<br>
<br>
give<br>
<br>
Only thought I have that could be wrong is your coordinates are not<br>
really 22523 or there is a problem with your proj 4 install. The above<br>
queries should pinpoint that.<br>
<div class="Ih2E3d"><br>
Hope that helps,<br>
Regina<br>
<br>
________________________________<br>
<br>
From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>
Felipe Fedel Pinto<br>
</div>Sent: Monday, August 04, 2008 9:27 AM<br>
To: PostGIS Users Discussion<br>
Subject: Re: [postgis-users] problem to transform coordinates<br>
<div><div></div><div class="Wj3C7c"><br>
<br>
it also happens when I use ST_Transform and return the same thing from<br>
SELECT proj4text FROM spatial_ref_sys WHERE srid = 22523;<br>
<br>
<br>
Do you have another idea??<br>
<br>
Thanks!!!!<br>
<br>
Felipe Fedel<br>
<br>
On Thu, Jul 31, 2008 at 1:13 AM, Paragon Corporation <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>><br>
wrote:<br>
<br>
<br>
Maybe there is something wrong with your entry in the<br>
spatial_ref_sys table for that SRID. Also provide two sample 22523<br>
points and what the ST_Transform looks like.<br>
<br>
Also please use ST_Transform if you are using a PostGIS install<br>
> 1.2<br>
<br>
What does<br>
<br>
SELECT proj4text<br>
FROM spatial_ref_sys<br>
WHERE srid = 22523<br>
<br>
give you?<br>
<br>
Mine gives<br>
+proj=utm +zone=23 +south +ellps=intl<br>
+towgs84=-206,172,-6,0,0,0,0 +units=m +no_defs<br>
<br>
Hope that helps,<br>
Regina<br>
<br>
________________________________<br>
<br>
From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of<br>
Felipe Fedel Pinto<br>
Sent: Wednesday, July 30, 2008 7:26 PM<br>
To: <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
Subject: [postgis-users] problem to transform coordinates<br>
<br>
<br>
To transform coordinates in PostGis I use the followed function:<br>
<br>
UPDATE <table> SET <new_geometry_column> =<br>
transform(<original_geometry_column>,<new_SRID>);<br>
<br>
I have been having a weird problem when I try to transform<br>
coordinates that are in a SRID=22523.<br>
Ex: I have to transform them to a SRID=4326<br>
<br>
UPDATE coordsformiga SET coord_4326 =<br>
transform(coord_22523,4326);<br>
<br>
where coordsformiga is the table,<br>
coord_22523 is the original geometry column with the<br>
coordinates in a SRID=22523<br>
coord_4326 I'd be the geometry column with the<br>
coordinates transformed in a SRID=4326<br>
<br>
the problem is:<br>
After the function, in the geometry column (coord_4326), all of<br>
the 97 coordinates have the same values.<br>
But it's happening only with a SRID=22523.<br>
<br>
Anybody knows what is happening??<br>
<br>
thanks<br>
<br>
<br>
<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>
<br>
<br>
<br>
</div></div>-----------------------------------------<br>
The substance of this message, including any attachments, may be<br>
confidential, legally privileged and/or exempt from disclosure<br>
pursuant to Massachusetts law. It is intended<br>
solely for the addressee. If you received this in error, please<br>
contact the sender and delete the material from any computer.<br>
<div><div></div><div class="Wj3C7c"><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>
</div></div></blockquote></div><br></div>