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

Sandro Santilli strk at kbt.io
Fri Feb 4 09:46:00 PST 2022

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 ?


  Libre GIS consultant/developer

More information about the postgis-users mailing list