[postgis-users] Missing ESRI authority SRIDs in 'spatial_ref_sys'

[karsten]

Hi Marco,

while I don't know why it might be missing you can simply add it to your
table via SQL (got the insert from epsg.io as well) 

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext)
values ( 54044, 'ESRI', 54044, 'None',
'PROJCS["World_Hammer_Aitoff",GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS
84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]
],PRIMEM["Greenwich",0],UNIT["Degree",0.0174532925199433]],PROJECTION["Hamme
r_Aitoff"],PARAMETER["False_Easting",0],PARAMETER["False_Northing",0],PARAME
TER["Central_Meridian",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["Eas
ting",EAST],AXIS["Northing",NORTH],AUTHORITY["ESRI","54044"]]');


Karsten

-----Original Message-----
From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of Marco Boeringa
Sent: Wednesday, September 20, 2023 12:20 AM
To: postgis-users at lists.osgeo.org
Subject: [postgis-users] Missing ESRI authority SRIDs in 'spatial_ref_sys'

Hi,

I noticed there are missing ESRI authority SRIDs in the PostGIS
'spatial_ref_sys' table.

E.g. the Hammer-Aitof projection, SRID 54044 (https://epsg.io/54044) is
missing. Any technical reasons why this is the case, or is the table due for
an update?

Marco

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users