[postgis-users] problem to transform coordinates

[Paragon Corporation]

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.
 
Also please use ST_Transform if you are using a PostGIS install > 1.2
 
What does 
 
SELECT proj4text 
FROM spatial_ref_sys 
WHERE srid = 22523
 
give you?
 
Mine gives 
+proj=utm +zone=23 +south +ellps=intl +towgs84=-206,172,-6,0,0,0,0 +units=m
+no_defs 
 
Hope that helps,
Regina

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Felipe
Fedel Pinto
Sent: Wednesday, July 30, 2008 7:26 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] problem to transform coordinates


To transform coordinates in PostGis I use the followed function:

UPDATE <table> SET <new_geometry_column> =
transform(<original_geometry_column>,<new_SRID>);

I have been having a weird problem when I try to transform coordinates that
are in a SRID=22523. 
Ex: I have to transform them to a SRID=4326

UPDATE coordsformiga SET coord_4326 = transform(coord_22523,4326);

where coordsformiga is the table,
          coord_22523 is the original geometry column with the coordinates
in a SRID=22523
          coord_4326 I'd be the geometry column with the coordinates
transformed in a SRID=4326

the problem is:
After the function, in the geometry column (coord_4326), all of the 97
coordinates have the same values.
But it's happening only with a SRID=22523.

Anybody knows what is happening??

thanks


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080731/214f113e/attachment.html>