<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: rgb(239, 239, 239); "><SPAN><IMG src="cid:D0977A33-390B-4F28-9F08-7A462A63567D@fr.umn.edu"></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-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: rgb(239, 239, 239); "><BR class="khtml-block-placeholder"></DIV><DIV style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-color: rgb(239, 239, 239); "><SPAN><IMG src="cid:D2E532E1-0DFB-4772-80CE-91BC801844D0@fr.umn.edu"></SPAN></DIV></BODY></HTML>