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

[Moen, Paul T.]

Sorry, we insert into the spatial_ref_sys table not the spatial_ref_sys.sql file.

We assign the SRIDs starting at 900000.  We have been setting the auth_name to 'EPSG' and the auth_srid to the same value as the srid.

Example. 

INSERT INTO spatial_ref_sys(srid, auth_name, auth_srid, srtext, proj4text) VALUES (6933, 'EPSG', 6933, '', '+proj=cea +lon_0=-100.5 +lat_ts=47.5 +x_0=2000000 +y_0=0 +ellps=WGS84 +towgs84=0,0,0,0,0,0,0 +to_meter=0.3048 +no_defs');

On 2/4/22, 12:04 PM, "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. *****

    Thanks for answering Paul, more question inline

    On Fri, Feb 04, 2022 at 05:21:23PM +0000, Moen, Paul T. wrote:

    > We have 54 custom entries that we store in spatial_ref_sys.sql.

    Do you mean in the "spatial_ref_sys" PostgreSQL table or in the
    "spatial_ref_sys.sql" file ?
    How do you decide what SRIDs to assign to your custom entries ?
    What auth_name and auth_srid do you use ?

    >> - 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.

    Would you expect (or like) PostGIS upgrade to also upgrade
    thse system entries ?

    How do you upgrade PostGIS ?


    --strk;

      Libre GIS consultant/developer
      https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fstrk.kbt.io%2Fservices.html&data=04%7C01%7Cpmoen%40nd.gov%7C5e07287c66da48db3cab08d9e8089d50%7C2dea0464da514a88bae2b3db94bc0c54%7C0%7C0%7C637795946696175261%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=9aeOy6nKhjz81ob15q8Qv%2BdnDfWgTdhcffS60%2F2lMec%3D&reserved=0
    _______________________________________________
    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%7C5e07287c66da48db3cab08d9e8089d50%7C2dea0464da514a88bae2b3db94bc0c54%7C0%7C0%7C637795946696175261%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=JtkUEVjMTtoJFkh7%2FElHhkZm3SDbIpCmMyYijfpB81I%3D&reserved=0