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

Darafei "Komяpa" Praliaskouski me at komzpa.net
Wed Feb 9 00:31:47 PST 2022


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 <strk at 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 at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220209/f643adfb/attachment.html>

More information about the postgis-users mailing list