[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