<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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><img
src="cid:part1.01020805.09080108@yahoo.fr"></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><img
src="cid:part2.03000707.02040104@yahoo.fr"></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>
</body>
</html>