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.
Kirk
On Jan 13, 2007, at 4:15 PM, TECHER David wrote:
Hi Kirk
Perhaps it is a stupid idea but did you try by inversing longitude
and latitude in your commands?
I mean
SELECT AddGeometryColumn( 'public', 'sites', 'the_point_lonlat',
4269, 'POINT', 2 );
UPDATE sites SET the_point_lonlat = PointFromText('POINT(' ||
latitude || ' ' || longitude || ')',4269)
SELECT AddGeometryColumn( 'public', 'sites', 'the_point_meter',
32661, 'POINT', 2 );
UPDATE sites SET the_point_meter = transform(PointFromText('POINT('
|| latitude || ' ' || longitude || ')',4269),32661);
Kirk Wythers a écrit :
Greetings all,
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.
Thanks,
Kirk
SELECT AddGeometryColumn( 'public', 'sites', 'the_point_lonlat',
4269, 'POINT', 2 );
UPDATE sites SET the_point_lonlat = PointFromText('POINT(' ||
longitude || ' ' || latitude || ')',4269)
SELECT AddGeometryColumn( 'public', 'sites', 'the_point_meter',
32661, 'POINT', 2 );
UPDATE sites SET the_point_meter = transform(PointFromText('POINT
(' || longitude || ' ' || latitude || ')',4269),32661);
<mime-attachment.png>
<mime-attachment.png>
_______________________________________________
postgis-users mailing list
[EMAIL PROTECTED]
http://postgis.refractions.net/mailman/listinfo/postgis-users
<mime-attachment.png>
<mime-attachment.png>
_______________________________________________
postgis-users mailing list
[EMAIL PROTECTED]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.qgis.org
http://lists.qgis.org/cgi-bin/mailman/listinfo/qgis-user