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

[Moen, Paul T.]

      - How many ?  We have 54 custom entries that we store in spatial_ref_sys.sql.
      - Do you also keep the entries installed by spatial_ref_sys.sql ? Yes.
      - Do you ever update the table with entries from newer
        spatial_ref_sys.sql ? No.

On 2/4/22, 11:05 AM, "postgis-users on behalf of Sandro Santilli" <postgis-users-bounces at lists.osgeo.org on behalf of strk at kbt.io> wrote:

    ***** CAUTION: This email originated from an outside source. Do not click links or open attachments unless you know they are safe. *****

    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://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.osgeo.org%2Fmailman%2Flistinfo%2Fpostgis-users&data=04%7C01%7Cpmoen%40nd.gov%7C26e9b1819f69481f556e08d9e8007ea6%7C2dea0464da514a88bae2b3db94bc0c54%7C0%7C0%7C637795911221245802%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=kq0o5XkKo6MxcsAm%2BhMfJ2ejkJVSO27DZFiGW%2Fsy1L4%3D&reserved=0