[fdo-trac] #750: PostgreSQL - WKT's contain axis assignments
FDO
trac_fdo at osgeo.org
Wed Mar 9 14:47:00 EST 2011
#750: PostgreSQL - WKT's contain axis assignments
-----------------------------------+----------------------------------------
Reporter: brentrobinson | Owner: brentrobinson
Type: defect | Status: new
Priority: major | Milestone:
Component: PostgreSQL Provider | Version: 3.5.0
Severity: 2 | Keywords: PostGIS PostgreSQL axis direction coordinate system
External_id: |
-----------------------------------+----------------------------------------
The PostgreSQL provider's FdoISpatialContextReader implementation
retrieves the Coordinate System WKT from the PostGIS catalog column
spatial_ref_sys.srtext. These WKT's can contain clauses to change the
direction of the X and Y axes from X-East, Y-North. For example EPSG:31254
sets X to North and Y to East.
However, PostGIS uses the proj4 library for coordinate system handling.
proj4 does not reassign the axes so PostGIS handles geometries for all
coordinate systems as X-East, Y-North.
Given the above, the PostgreSQL provider should remove the axis
assignments for the WKT's that it exposes to be consistent with the actual
geometry values.
--
Ticket URL: <http://trac.osgeo.org/fdo/ticket/750>
FDO <http://fdo.osgeo.org/>
Feature Data Objects
More information about the fdo-trac
mailing list