[postgis-tickets] [PostGIS] #4922: Axis order wrong in PostGIS 3.1.2 (may relates to #4842)

[PostGIS]

#4922: Axis order wrong in PostGIS 3.1.2 (may relates to #4842)
----------------------+---------------------------
  Reporter:  tjay     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 3.1.3
 Component:  postgis  |    Version:  3.1.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by fnadler):

 I suspect this behaviour is introducted by #4842, which states, that in
 case first column does not include "Lat", the EPSG database order is
 chosen.

 In case of EPSG 31466, proj's internal database (sqlite) output the
 following order:


 {{{
 select axis.name, coordinate_system_order
 from projected_crs
          inner join axis on projected_crs.coordinate_system_code =
 axis.coordinate_system_code
 where projected_crs.code = 31466
 order by coordinate_system_order

 --------------------------------------------------------------------------------------------
 Northing
 Easting
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4922#comment:3>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.