diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-06-18 11:48:25 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-06-18 11:48:25 +0200 |
| commit | 68725298801def1c74015184bdc8c4d27f970244 (patch) | |
| tree | 3bba14c186a9c2e31a7874af2341279c2021e7a6 /data/sql | |
| parent | c408466fde711a002f45282c427af4f953a9fd2f (diff) | |
| parent | 7e07589d2197663184b06824260f5908ba4f4870 (diff) | |
| download | PROJ-68725298801def1c74015184bdc8c4d27f970244.tar.gz PROJ-68725298801def1c74015184bdc8c4d27f970244.zip | |
Merge pull request #2250 from and-marsh/pr-add-main-uk-geoid
Database: register geoid file for UK added in OSGeo/PROJ-data#25
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/customizations.sql | 2 | ||||
| -rw-r--r-- | data/sql/grid_alternatives.sql | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 5bd5c7a5..fde530da 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -168,6 +168,8 @@ INSERT INTO "geoid_model" SELECT 'GEOID12B', auth_name, code FROM grid_transform INSERT INTO "geoid_model" SELECT 'GEOID18', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE 'g2018%' AND deprecated = 0; +INSERT INTO "geoid_model" SELECT 'OSGM15', auth_name, code FROM grid_transformation WHERE auth_name = 'EPSG' AND grid_name LIKE '%OSGM15%' AND deprecated = 0; + ---- PROJ historic +datum aliases ----- INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6326','WGS84','PROJ'); diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql index 0b8746fa..c0f3ff41 100644 --- a/data/sql/grid_alternatives.sql +++ b/data/sql/grid_alternatives.sql @@ -47,6 +47,8 @@ VALUES ('OSGM15_Malin.gri','uk_os_OSGM15_Malin.tif','OSGM15_Malin.gtx','GTiff','geoid_like',0,NULL,'https://cdn.proj.org/uk_os_OSGM15_Malin.tif',1,1,NULL), -- Northern Ireland: OSGM15 height, Belfast height -> ETRS89 ellipsoidal heights ('OSGM15_Belfast.gri','uk_os_OSGM15_Belfast.tif','OSGM15_Belfast.gtx','GTiff','geoid_like',0,NULL,'https://cdn.proj.org/uk_os_OSGM15_Belfast.tif',1,1,NULL), +-- United Kingdom: OSGM15 height, ODN height -> ETRS89 ellipsoidal heights +('OSTN15_OSGM15_GB.txt','uk_os_OSGM15_GB.tif',NULL,'GTiff','geoid_like',0,NULL,'https://cdn.proj.org/uk_os_OSGM15_GB.tif',1,1,NULL), -- US GEOID99 height models. Not mapped: Alaska: g1999a01.gtx to g1999a04.gtx. Hawaii: g1999h01.gtx, Puerto Rico: g1999p01.gtx ('g1999u01.bin','us_noaa_g1999u01.tif','g1999u01.gtx','GTiff','geoid_like',0,NULL,'https://cdn.proj.org/us_noaa_g1999u01.tif',1,1,NULL), ('g1999u02.bin','us_noaa_g1999u02.tif','g1999u02.gtx','GTiff','geoid_like',0,NULL,'https://cdn.proj.org/us_noaa_g1999u02.tif',1,1,NULL), |