RH, This kind of thing happens if your input points are not actually in the projection you say they are with setsrid. Give us an example 32107 point you are using. I suspect it doesn't fall in the range of a valid 32107 point. Hope that helps, Regina
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of R H Sent: Friday, September 05, 2008 1:13 PM To: [email protected] Subject: [postgis-users] Need Help with Transform _____ Transform is returning to the same value, for different inputs? Below is what I have done... select AddGeometryColumn('data_stage', 'table', 'geo4269', 4269, 'POINT', 2) select AddGeometryColumn('data_stage', 'table', 'geo32107', 32107, 'POINT', 2) update table set geo32107= setsrid(MakePoint(x, y), 32107) where .... update table set geo4269 = transfrom(geo32107, 4269) where .... column geo4269 all have the same vaule. select AsText(geo4269) returns 'POINT(-115.583333333333 90)' for all rows. And select AsText(geo32107) returns the point as input. Am I using transform wrong? Or any other problems? Any help many thanks...
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
