[postgis-tickets] [PostGIS] #4642: regress_proj test fails with PROJ 7.0.0

[PostGIS]

#4642: regress_proj test fails with PROJ 7.0.0
-----------------------------+---------------------------
  Reporter:  Bas Couwenberg  |      Owner:  pramsey
      Type:  defect          |     Status:  new
  Priority:  medium          |  Milestone:  PostGIS 3.0.1
 Component:  postgis         |    Version:  3.0.x
Resolution:                  |   Keywords:
-----------------------------+---------------------------

Comment (by Algunenano):

 Same for 4137:
 {{{
 template_postgis=# SELECT srid FROM spatial_ref_sys WHERE srid != 4138
 LIMIT 1 offset 69;
  srid
 ------
  4137
 (1 row)

 template_postgis=# Select * from spatial_ref_sys where srid = 4137;
  srid | auth_name | auth_srid |
                                              srtext
                                                                  |
 proj4text
 ------+-----------+-----------+----------------------------------------------------------------------------------------------
 -----------------------------------------------------------------------------------------------------------------------------
 -----------------------------------------------------------------+---------------------------------------
  4137 | EPSG      |      4137 | GEOGCS["St. Paul
 Island",DATUM["St_Paul_Island",SPHEROID["Clarke
 1866",6378206.4,294.97869821
 38982,AUTHORITY["EPSG","7008"]],AUTHORITY["EPSG","6137"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174
 532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4137"]] |
 +proj=longlat +ellps=clrk66 +no_defs

 }}}


 And 4136:
 template_postgis=# SELECT ST_AsEWKT(ST_Transform('SRID=4326; POINT(0
 0)'::geometry, 4136));
 ERROR:  transform: failed to load datum shift file (-38)
 template_postgis=# Select * from spatial_ref_sys where srid = 4136;
  srid | auth_name | auth_srid |
                                                  srtext
                                                                          |
 proj4text
 ------+-----------+-----------+----------------------------------------------------------------------------------------------
 -----------------------------------------------------------------------------------------------------------------------------
 -------------------------------------------------------------------------+---------------------------------------
  4136 | EPSG      |      4136 | GEOGCS["St. Lawrence
 Island",DATUM["St_Lawrence_Island",SPHEROID["Clarke 1866",6378206.4,294.
 9786982138982,AUTHORITY["EPSG","7008"]],AUTHORITY["EPSG","6136"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree
 ",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4136"]] |
 +proj=longlat +ellps=clrk66 +no_defs
 (1 row)

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