Feature request #2730

Support PostGIS geography type

Added by nick - over 10 years ago. Updated over 10 years ago.

Status:Closed
Priority:Low
Assignee:Jürgen Fischer
Category:Data Provider
Pull Request or Patch supplied: Resolution:fixed
Easy fix?:No Copied to github as #:12790

Description

Tables with geography columns (new in PostGIS 1.5.x) are not detected when adding new PostGIS layer. Geographies have been added for working in spherical (lat/lon) coords and respecting IDL and poles.

Operators and functions are the same for geometry, albeit restricted for geography being new. And schema definition is easier also with no AddGeometryColumn magic.

Can't use quantum GIS on PostGIS geography database without this support.

diff Magnifier - preliminary patch to add geography support (17.7 KB) Jürgen Fischer, 2010-06-25 01:01 PM

History

#1 Updated by Mike Taves over 10 years ago

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 PostGIS Geography Documentation

#2 Updated by Jürgen Fischer over 10 years ago

  • Status changed from Open to In Progress

#3 Updated by Jürgen Fischer over 10 years ago

  • Resolution set to fixed
  • Status changed from In Progress to Closed

applied in aedac631 (SVN r13923).

Also available in: Atom PDF