[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 rouault):

 > You say "manual hacking" with such distaste :)

 Yes, because otherwise we have inconsistent conversion rules in the stack,
 and people will not replicate the same results when using ST_Transform()
 in PostGIS vs in GDAL, proj commandlines or with QGIS.

 > Where would an upstream ticket go, geotiff or gdal?

 Likely GDAL. We should probably use data/coordinate_operation.csv and
 data/coordinate_operation_parameter_value.csv to find the appropriate
 grid. 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

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