[postgis-tickets] [PostGIS] #5353: EPSG:5070 mismatch between spatial_ref_sys and PROJ

[PostGIS]

#5353: EPSG:5070 mismatch between spatial_ref_sys and PROJ
----------------------+---------------------------
  Reporter:  jbkoch   |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  high     |  Milestone:  PostGIS 3.1.9
 Component:  postgis  |    Version:  3.1.x
Resolution:           |   Keywords:
----------------------+---------------------------
Changes (by robe):

 * milestone:  PostGIS Packaging => PostGIS 3.1.9

Comment:

 jbkoch for proj 6 and above, the spatial_ref_sys proj4text is not used
 unless there is no corresponding auth/srid found in the PROJ proj.db.

 The proj I see currently defined in spatial_ref_sys is:


 {{{
 +proj=aea +lat_1=29.5 +lat_2=45.5 +lat_0=23 +lon_0=-96 +x_0=0 +y_0=0
 +datum=NAD83 +units=m +no_defs
 }}}

 Which agree is different from your proj 8

 That said this should only be an issue for older PROJs and I'm hesitant to
 mess with those because

 a) They are all essentially deprecated by proj project and I'm not sure
 the type=crs even works with older proj, so may cause damage.
 b) For PostGIS 3.1, we do not currently push updates, so even if we fixed
 for 3.1, you wouldn't get the updated change anyway without manual
 intervention.

 We didn't start shipping of allowing update for spatial_ref_sys until
 PostGIS 3.3.

 @pramsey you think this issue is worth fixing, or should we just let dead
 dogs rest.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5353#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.