Opened 13 years ago
Closed 13 years ago
#750 closed defect (fixed)
PostgreSQL - WKT's contain axis assignments
| Reported by: | brentrobinson | Owned by: | brentrobinson |
|---|---|---|---|
| Priority: | major | Milestone: | |
| Component: | PostgreSQL Provider | Version: | 3.5.0 |
| Severity: | 2 | Keywords: | PostGIS PostgreSQL axis direction coordinate system |
| Cc: | External ID: |
Description
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.
Change History (2)
comment:1 by , 13 years ago
| Status: | new → assigned |
|---|
comment:2 by , 13 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
Note:
See TracTickets
for help on using tickets.
Revision: 5910 Author: brentrobinson Date: 2:50:29 PM, Wednesday, March 09, 2011 Message: Ticket#750: Removed axis assignments from Coordinate System WKT strings retrieved by the PostgreSQL provider's FdoISpatialContextReader implementation.
Modified : /trunk/Providers/GenericRdbms/Src/PostGis/SchemaMgr/Ph/Rd/SpatialContextReader.cpp Modified : /trunk/Providers/GenericRdbms/Src/PostGis/SchemaMgr/Ph/Rd/SpatialContextReader.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/PostGis/CMakeLists.txt Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/PostGis/Makefile.am Added : /trunk/Providers/GenericRdbms/Src/UnitTest/PostGis/PostGisFdoSpatialContextTest.cpp Added : /trunk/Providers/GenericRdbms/Src/UnitTest/PostGis/PostGisFdoSpatialContextTest.h Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/UnitTestPostGIS.vcproj Modified : /trunk/Providers/GenericRdbms/Src/UnitTest/UnitTestPostGIS.vcxproj Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/CoordinateSystem.h Modified : /trunk/Utilities/SchemaMgr/Inc/Sm/Ph/Owner.h Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/CoordinateSystem.cpp Modified : /trunk/Utilities/SchemaMgr/Src/Sm/Ph/Owner.cpp