[postgis-users] trouble with a postgis table in qgis

[Kirk Wythers]

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
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
> <mime-attachment.png>
> <mime-attachment.png>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070115/6c48be14/attachment.html>