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

[Sandro Santilli]

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://strk.kbt.io/services.html