Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I tried to import in QGIS a layer from a PostgreSQL table with a geography type column created through the extension PostGIS.

I noticed that QGIS doesn't seem to like the geography column...

Here the step to create the column...

ALTER TABLE traffico ADD COLUMN geog geography(POINT,4326);

then to update the column...

UPDATE traffico SET geog = ST_GeogFromText('SRID=4326;POINT(' || lon || ' ' || lat || ')');

but then when I connect QGIS to my server I see this:

Import PostGIS layer to QGIS

There's no way I can find to tell QGIS to treat my column as a geography type instead of geometry type. Indeed if I try to upload the layer like this the point coordinates do not correspond to reality.

share|improve this question
    
Please go though following links which contains (difference between Geography and the geometry data type ,when to use this type) postgis.refractions.net/documentation/manual-1.5SVN/… ,gis.stackexchange.com/questions/6681/… –  Sunil Feb 5 '13 at 5:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.