[Qgis-developer] Re: geometry with geography type column not displayed

Salvatore Larosa lrssvtml at gmail.com
Thu Apr 5 17:18:53 EDT 2012


Il giorno gio, 05/04/2012 alle 22.13 +0200, Salvatore Larosa ha scritto:
> Hi,
> I created the following table in PostGIS:
> 
> CREATE TABLE test.geogQGIS(gid serial,geog geography(Point,4326));
> 
> INSERT INTO test.geogQGIS (geog) VALUES
> (st_geographyFromText('SRID=4326;Point(-110 30)'));
> 
> ALTER TABLE test.geogQGIS ADD CONSTRAINT gid_pk PRIMARY KEY(gid);
> 
> but I can not see the table in QGIS! it is loaded but not displayed!
> 
> While, if I create a geography column as PointZ, in column "Type" of
> PostGIS provider, I see "Detecting...." grayed-out and can do nothing!
> 
> 
> QGIS version: master
> 
> Anyone confirms?
> 
> All the best
> 
> -SL
> 

In log messages also see:

ERROR:  Invalid geography. Antipodal (180 degrees long) edge (180
-90,180 90) detected, add a point between to make two edges that span
less than 180 degrees.


-SL




More information about the Qgis-developer mailing list