[postgis-tickets] [PostGIS] #3944: [PATCH] Update spatial_ref_sys.sql to EPSG v9.2

[PostGIS]

#3944: [PATCH] Update spatial_ref_sys.sql to EPSG v9.2
----------------------+---------------------------
  Reporter:  rouault  |      Owner:  pramsey
      Type:  patch    |     Status:  reopened
  Priority:  medium   |  Milestone:  PostGIS 2.5.0
 Component:  postgis  |    Version:  2.4.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by jpalmer):

 I did the orginal request on behalf of the NZ people(!): See
 https://trac.osgeo.org/postgis/ticket/631. I submitted the changes to
 ensure the higher accuracy NZ datum shift grids are used, because the
 geotiff/EPSG database that provided the SRS data didn't support this.

 > But the subject is non-trivial since proj4 4.x only support DatumA <-->
 WGS84 <---> DatumB conversions, whereas a lot of grids implement DatumA
 <--> DatumB conversions. proj 5 will better handle this

 Yes I remember this was exactly the reason why I didn't try to submit the
 changes upstream to geotiff/EPSG codebase.

 > proj 5 will better handle this

 Yes the option to define multiple pipeline seems the right time to fix
 this. The people in QGIS could also benefit from this upstream work with
 the latest datum shift work they are doing:
 https://github.com/qgis/QGIS/pull/5535

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3944#comment:10>
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.