Felipe Fedel, Can you send a sample of your data - results of the 2 queries below SELECT ST_AsText(coord_22523) FROM coordsformiga limit 2; -- and result you get when you do SELECT ST_AsText(ST_Transform(coord_22523, 4326)) FROM coordsformiga limit 2; Also what does
SELECT postgis_full_version(); give Only thought I have that could be wrong is your coordinates are not really 22523 or there is a problem with your proj 4 install. The above queries should pinpoint that. Hope that helps, Regina ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Felipe Fedel Pinto Sent: Monday, August 04, 2008 9:27 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] problem to transform coordinates it also happens when I use ST_Transform and return the same thing from SELECT proj4text FROM spatial_ref_sys WHERE srid = 22523; Do you have another idea?? Thanks!!!! Felipe Fedel On Thu, Jul 31, 2008 at 1:13 AM, Paragon Corporation <[EMAIL PROTECTED]> wrote: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Felipe Fedel Pinto Sent: Wednesday, July 30, 2008 7:26 PM To: [email protected] 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 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
