[postgis-users] Help shaping the future: how do your use of spatial_ref_sys ?

Sandro Santilli strk at kbt.io
Fri Feb 4 09:04:51 PST 2022

Following earlier may from Regina, I'm writing this as a user
inquiry, to get help in shaping the future of PostGIS handling
of custom CRSs.

The question I have for you is: do you keep your custom CRSs
in the spatial_ref_sys table ? If so:

  - How many ?
  - Do you also keep the entries installed by spatial_ref_sys.sql ?
  - Do you ever update the table with entries from newer
    spatial_ref_sys.sql ?


The EXTENSION based installs are known to NEVER
automatically update the spatial_ref_sys table while the
spatial_ref_sys.sql file installed on PostgreSQL contrib dir
for each PostGIS version can currently be used to restore 
the "PostGIS-Standard" entries.

I've been working on a change which would allow keeping
user entries separated from system entries, with system
entries being always upgraded on PostGIS upgrade (automatically
when using EXTENSION based installs and manually when
using SCRIPT based installs).

Your experiences will be useful to decide whether or not
to merge such change in for the next PostGIS version.


More information about the postgis-users mailing list