Running clustering queries

['Sandro Santilli']

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;
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 659 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240509/3991452d/attachment.sig>