[postgis-users] Need Help with Transform

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of R H
Sent: Friday, September 05, 2008 1:13 PM
To: postgis-users at postgis.refractions.net
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...
 
 
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080905/97a06088/attachment.html>