Opened 14 years ago
Closed 14 years ago
#2730 closed patch (fixed)
Support PostGIS geography type
Reported by: | nick | Owned by: | jef |
---|---|---|---|
Priority: | major: does not work as expected | Milestone: | Version 1.6.0 |
Component: | Data Provider | Version: | Trunk |
Keywords: | Cc: | mwtoews | |
Must Fix for Release: | No | Platform: | All |
Platform Version: | 1.5 unstable | Awaiting user input: | no |
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.
Attachments (1)
Change History (6)
comment:1 by , 14 years ago
Cc: | added |
---|---|
Component: | Build/Install → Data Provider |
Platform: | Windows → All |
Platform Version: | 1.4 unstable → 1.5 unstable |
Summary: | Support PostGIS GEOGRAPHY (not Geometry) types → Support PostGIS geography type |
comment:2 by , 14 years ago
Owner: | changed from | to
---|
comment:3 by , 14 years ago
Milestone: | → Version 1.6.0 |
---|
comment:4 by , 14 years ago
Status: | new → assigned |
---|---|
Type: | enhancement → patch |
Note:
See TracTickets
for help on using tickets.
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 (version 1.5)