Feature request #2730
Support PostGIS geography type
| 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 
- preliminary patch to add geography support
(17.7 KB)
History
#1
Updated by Mike Taves over 14 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 14 years ago
- Status changed from Open to In Progress
#3
Updated by Jürgen Fischer over 14 years ago
- Resolution set to fixed
- Status changed from In Progress to Closed
applied in aedac631 (SVN r13923).