<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Thanks for the Help Regina, below are some of the points I attempted.<BR>
<BR>
setsrid(MakePoint(834934.2263,26712690.6089, 32107) <BR>setsrid(MakePoint(834533.210694,26712881.1962, 32107) <BR>setsrid(MakePoint(834224.086891,26712318.3331, 32107) <BR><BR>
Is there a way to check if it is in the range of the projection? <BR><BR><BR>
<HR>
<BR>
From: lr@pcorp.us<BR>To: postgis-users@postgis.refractions.net<BR>Subject: RE: [postgis-users] Need Help with Transform<BR>Date: Fri, 5 Sep 2008 18:19:58 -0400<BR><BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
.ExternalClass .EC_hmmessage P
{padding:0px;}
.ExternalClass body.EC_hmmessage
{font-size:10pt;font-family:Tahoma;}
</STYLE>
<DIV dir=ltr align=left><SPAN class=EC_296351822-05092008><FONT face=Arial color=#0000ff>RH,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_296351822-05092008><FONT face=Arial color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=EC_296351822-05092008><FONT face=Arial color=#0000ff>This kind of thing happens if your input points are not actually in the projection you say they are with setsrid.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_296351822-05092008><FONT face=Arial color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=EC_296351822-05092008><FONT face=Arial color=#0000ff>Give us an example 32107 point you are using. I suspect it doesn't fall in the range of a valid 32107 point.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_296351822-05092008><FONT face=Arial color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=EC_296351822-05092008><FONT face=Arial color=#0000ff>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=EC_296351822-05092008><FONT face=Arial color=#0000ff>Regina</FONT></SPAN></DIV><BR>
<DIV class=EC_OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR>
<FONT face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>R H<BR><B>Sent:</B> Friday, September 05, 2008 1:13 PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Need Help with Transform<BR></FONT><BR></DIV>
<DIV></DIV><BR><BR>
<HR>
<BR>
<STYLE>
.ExternalClass .EC_hmmessage P
{padding:0px;}
.ExternalClass body.EC_hmmessage
{font-size:10pt;font-family:Tahoma;}
</STYLE>
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>