<div dir="ltr">it also happens when I use ST_Transform and return the same thing from <span><font color="#0000ff" face="Arial" size="2">SELECT proj4text FROM spatial_ref_sys WHERE srid = 22523; <br><br></font></span><div dir="ltr" align="left">
Do you have another idea??<br><br>Thanks!!!!<br><br>Felipe Fedel<br></div><div class="gmail_quote">On Thu, Jul 31, 2008 at 1:13 AM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</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>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Maybe there is something wrong with your entry in the
spatial_ref_sys table for that SRID. Also provide two sample 22523
points and what the ST_Transform looks like.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Also please use ST_Transform if you are using a PostGIS
install > 1.2</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">What does </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">SELECT proj4text </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">FROM spatial_ref_sys </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">WHERE srid = 22523</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">give you?</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Mine gives </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">+proj=utm +zone=23 +south +ellps=intl
+towgs84=-206,172,-6,0,0,0,0 +units=m +no_defs </font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Hope that helps,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial" size="2">Regina</font></span></div><br>
<div dir="ltr" align="left" lang="en-us">
<hr>
<font face="Tahoma" size="2"><b>From:</b>
<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>Felipe Fedel Pinto<br><b>Sent:</b> Wednesday, July 30, 2008 7:26
PM<br><b>To:</b> <a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><b>Subject:</b>
[postgis-users] problem to transform coordinates<br></font><br></div><div><div></div><div class="Wj3C7c">
<div></div>
<div dir="ltr">To transform coordinates in PostGis I use the followed
function:<br><br>UPDATE <table> SET <new_geometry_column> =
transform(<original_geometry_column>,<new_SRID>);<br><br>I have been
having a weird problem when I try to transform 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 = transform(coord_22523,4326);<br><br>where
coordsformiga is the
table,<br> coord_22523 is
the original geometry column with the coordinates in a
SRID=22523<br> coord_4326
I'd be the geometry column with the coordinates transformed in a
SRID=4326<br><br>the problem is:<br>After the function, in the geometry column
(coord_4326), all of 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></div></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></div>