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

[Moen, Paul T.]

No.  Pasted wrong line. Here is one of our custom entries.

INSERT INTO spatial_ref_sys(srid, auth_name, auth_srid, srtext, proj4text) VALUES (900001, 'EPSG', 900001, '', '+proj=lcc +lat_1=47.48333333333333 +lat_2=46.18333333333333 +lat_0=45.66666666666666 +lon_0=-102.53 +x_0=599999.9999976 +y_0=0 +ellps=GRS80 +datum=NAD83 +to_meter=0.3048 +no_defs');

On 2/4/22, 1:10 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. *****

    On Fri, Feb 04, 2022 at 06:56:58PM +0000, Moen, Paul T. wrote:
    > 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');

    Is the above an actual custom entry of yours ?
    Because the SRID is NOT higher than 900000 as you mentioned.

    What version of libproj are you using ?
    Are you aware that given a new enough libproj (>= 6.1)
    the proj4text in your record might not be used at all ?

    In the spatial_ref_sys.sql file in current PostGIS 3.3 the
    EPSG/6933 entry has a different proj4text:

      +proj=cea +lon_0=0 +lat_ts=30 +x_0=0 +y_0=0 +datum=WGS84 +units=m +no_defs

    You said you also keep the entries installed by spatial_ref_sys.sql,
    does it mean at the time you issued the above example INSERT your
    PostGIS version did NOT include an entry for SRID=6933?

    --strk;

    >
    > 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;
    _______________________________________________
    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%7C2bd1e57998464847281c08d9e81208d4%7C2dea0464da514a88bae2b3db94bc0c54%7C0%7C0%7C637795986424421139%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=E8Nrf%2F65QrX4H%2F0ZYw%2BNaIXj2zaCwgAhfSkJy53cA%2FA%3D&reserved=0