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 ? Background: 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. --strk; _______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users