On Wed, May 08, 2024 at 05:53:48PM -0400, Regina Obe wrote: > On Wed, May 08, 2024 at 03:01:47PM -0500, Daryl Herzmann wrote: > > > > I stumbled into this issue today. The lack of 9311 in spatial_ref_sys. Is > > a fix > > for this coming or is the spatial_ref_sys just known to be stale and not > > getting > > updated with updated postgis releases? > > Paul and Sandro, > Any thoughts on this.
It looks like the latest upgrade of spatial_ref_sys was done in 2019, with commit 4d4891e120667bb137c5d292405938a92cb3e59d My thought is that an upgrade is due... As for HOW spatial_ref_sys should be upgraded, the discussion is still open. At the moment old records are always retained (never updated) and new records are added (based on SRID). Background: https://trac.osgeo.org/postgis/ticket/5024 My proposal was to always upgrade the "PostGIS official database" and allow users override. The presence of `postgis_srs_all()` and friends allow querying the "PROJ official database" but I think a "PostGIS official database" still has a role as PostGIS dumps reference SRS just by SRID number, which doens't have a direct match with PROJ SRS identifiers (lacks an "authority", being implicitly PostGIS itself). I still have the branch in which I've worked to give the PostGIS official database a stable place ( a spatial_ref_sys_postgis table ) if anyone is interested in reviving it. --strk;
signature.asc
Description: PGP signature