<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; ">Mercie, David. I did try reversing the xy coords as you suggested when this problem first popped up. However, that solution only created an error about longitude values being out of range (or something like that). It just seems very odd to me that the points from the geometry column "thepoint_lonlat" would project correctly, but the points from the geometry column "thepoint_meter" would not.<DIV><BR class="khtml-block-placeholder"></DIV><DIV>Kirk<DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR><DIV><DIV>On Jan 13, 2007, at 4:15 PM, TECHER David wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"> Hi Kirk<BR> <BR> Perhaps it is a stupid idea but did you try by inversing longitude and latitude in your commands?<BR> <BR> I mean <BR> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">SELECT AddGeometryColumn( 'public', 'sites', 'the_point_lonlat', 4269, 'POINT', 2 );</SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"></SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">UPDATE sites SET the_point_lonlat = PointFromText('POINT(' || </SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">latitude</SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"> || ' ' || </SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">longitude</SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"> || ')',4269)</SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">SELECT AddGeometryColumn( 'public', 'sites', 'the_point_meter', 32661, 'POINT', 2 );</SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"></SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">UPDATE sites SET the_point_meter = transform(PointFromText('POINT(' || </SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">latitude</SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"> || ' ' || </SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">longitude</SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"> || ')',4269),32661);</SPAN></FONT></DIV> <BR> Kirk Wythers a écrit : <BLOCKQUOTE cite="mid07A0FB6E-1BC7-4CF1-BAA7-8A0D92EFD3E2@umn.edu" type="cite"> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">Greetings all, </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">I am trying to figure out why when I view a postgis table in qigs the long/lat geometry column projects properly with the north end of Minnesota pointing north, but the wgs84 meters geometry column projects oddly... on its side with the north end of Minnesota pointing to the right... west). I have included my commands that created the geometry columns, and I have attached two png files of the resultant maps. Any ideas of where I made the mistake would be most helpful.</SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">Thanks,</SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">Kirk</SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">SELECT AddGeometryColumn( 'public', 'sites', 'the_point_lonlat', 4269, 'POINT', 2 );</SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"></SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">UPDATE sites SET the_point_lonlat = PointFromText('POINT(' || longitude || ' ' || latitude || ')',4269)</SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">SELECT AddGeometryColumn( 'public', 'sites', 'the_point_meter', 32661, 'POINT', 2 );</SPAN></FONT><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"></SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;">UPDATE sites SET the_point_meter = transform(PointFromText('POINT(' || longitude || ' ' || latitude || ')',4269),32661);</SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"><BR class="khtml-block-placeholder"> </SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><SPAN><SPAN><DIV><mime-attachment.png></DIV></SPAN></SPAN><FONT class="Apple-style-span" color="#333333" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.3px;"></SPAN></FONT></DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><BR class="khtml-block-placeholder"> </DIV> <DIV style="margin: 0px; background-color: rgb(239, 239, 239);"><SPAN><SPAN><DIV><mime-attachment.png></DIV></SPAN></SPAN></DIV> <PRE wrap=""><HR size="4" width="90%">_______________________________________________
postgis-users mailing list
<A class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A>
<A class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A>
</PRE></BLOCKQUOTE> <BR> <SPAN><DIV><mime-attachment.png></DIV></SPAN><SPAN><DIV><mime-attachment.png></DIV></SPAN><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">_______________________________________________</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">postgis-users mailing list</DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV> </BLOCKQUOTE></DIV><BR></DIV></DIV></BODY></HTML>