[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [postgis-users] Transform is returning the same value,
From: R H <enoop () hotmail ! com>
Date: 2008-08-27 15:45:51
Message-ID: BLU138-W31DD5A2B3A52A8F455155B4610 () phx ! gbl
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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 tableset 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...
[Attachment #5 (text/html)]
<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Transform is returning to the same value, for different inputs? Below is \
what I have done...<BR> <BR>
select AddGeometryColumn('data_stage', 'table', 'geo4269', 4269, 'POINT', 2)<BR>
select AddGeometryColumn('data_stage', 'table', 'geo32107', 32107, 'POINT', 2)<BR>
<BR>
update table<BR>set geo32107= setsrid(MakePoint(x, y), 32107) <BR>
where ....<BR>
<BR>
update table set geo4269 = transfrom(geo32107, 4269)<BR>
where ....<BR><BR>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.<BR> <BR>
Am I using transform wrong? Or any other problems? Any help many \
thanks...<BR> <BR>
<BR>
<BR></body>
</html>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic