[postgis-users] problem to transform coordinates

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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 <lr at pcorp.us>
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: 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
	
	

	_______________________________________________
	postgis-users mailing list
	postgis-users at postgis.refractions.net
	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.