- 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-boun...@lists.osgeo.org on behalf of s...@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@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
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
