<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16674" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff 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 class=312410905-31072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff 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 class=312410905-31072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2>What does </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2>SELECT proj4text </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2>FROM spatial_ref_sys </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2>WHERE srid = 22523</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2>give you?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2>Mine gives </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff 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 class=312410905-31072008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=312410905-31072008><FONT face=Arial
color=#0000ff size=2>Regina</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Felipe Fedel Pinto<BR><B>Sent:</B> Wednesday, July 30, 2008 7:26
PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] problem to transform coordinates<BR></FONT><BR></DIV>
<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></BODY></HTML>