[QGIS-trac] Re: [Quantum GIS] #2730: Support PostGIS geography type

Quantum GIS qgis at qgis.org
Mon May 24 19:06:50 EDT 2010


#2730: Support PostGIS geography type
-----------------------------------------------------+----------------------
        Reporter:  nick                              |         Owner:  nobody
            Type:  enhancement                       |        Status:  new   
        Priority:  major: does not work as expected  |     Milestone:        
       Component:  Data Provider                     |       Version:  HEAD  
      Resolution:                                    |      Keywords:        
Platform_version:  1.5 unstable                      |      Platform:  All   
        Must_fix:  No                                |   Status_info:  0     
-----------------------------------------------------+----------------------
Changes (by mwtoews):

 * cc: mwtoews (added)
  * platform:  Windows => All
  * platform_version:  1.4 unstable => 1.5 unstable
  * component:  Build/Install => Data Provider
  * summary:  Support PostGIS GEOGRAPHY (not Geometry) types => Support
              PostGIS geography type

Comment:

 A simple workaround is to create views that cast the geography column(s)
 to geometry. This gets slightly more complicated if you want to have
 update/delete operations supported, since you need to write the rules for
 the views. Furthermore, this doesn't solve the IDL/pole geometry issues
 that geography resolves.

 General link to
 [http://postgis.refractions.net/documentation/manual-1.5/ch04.html#PostGIS_Geography
 PostGIS Geography Documentation (version 1.5)]

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/2730#comment:1>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats


More information about the QGIS-trac mailing list