[postgis-users] Need Help with Transform

Paragon Corporation lr at pcorp.us
Fri Sep 5 15:19:58 PDT 2008


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>


More information about the postgis-users mailing list