Hi, Projections I use are all standard:
- EPSG:4326 for unprojected OpenStreetMap - EPSG:3857 for tiles and quick 2D calculations - EPSG:3395 for some legacy systems that can't go to 3857 - EPSG:4978 for 3D XYZ calculations like all-globe clustering On Fri, Feb 4, 2022 at 8:05 PM Sandro Santilli <s...@kbt.io> wrote: > 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 >
_______________________________________________ postgis-users mailing list postgis-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/postgis-users
