diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-01-29 14:44:04 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-01-29 14:44:04 +0100 |
| commit | 9f6ab28f1d26561a547802a18b3a2f7877834ca8 (patch) | |
| tree | 53236d732f21a81e63982394d96d95d7eaa64064 /data/sql | |
| parent | d9ad20a959fd313b31329fb7be0500c895111edf (diff) | |
| download | PROJ-9f6ab28f1d26561a547802a18b3a2f7877834ca8.tar.gz PROJ-9f6ab28f1d26561a547802a18b3a2f7877834ca8.zip | |
Make it possible to use grids from the CDN by their 'old name' even if not in the EPSG/grid_transformation table
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/grid_alternatives.sql | 2 | ||||
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 2 |
2 files changed, 3 insertions, 1 deletions
diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql index 281a60e6..b92dbaa0 100644 --- a/data/sql/grid_alternatives.sql +++ b/data/sql/grid_alternatives.sql @@ -123,6 +123,8 @@ VALUES -- Netherlands / RDNAP 2018 ('nlgeo2018.gtx','nl_nsgi_nlgeo2018.tif','nlgeo2018.gtx','GTiff','geoid_like',0,NULL,'https://cdn.proj.org/nl_nsgi_nlgeo2018.tif',1,1,NULL), ('rdtrans2018.gsb','nl_nsgi_rdtrans2018.tif','rdtrans2018.gsb','GTiff','hgridshift',0,NULL,'https://cdn.proj.org/nl_nsgi_rdtrans2018.tif',1,1,NULL), +('NOT-YET-IN-GRID-TRANSFORMATION-naptrans2018.gtx','nl_nsgi_naptrans2018.tif','naptrans2018.gtx','GTiff','geoid_like',0,NULL,'https://cdn.proj.org/nl_nsgi_naptrans2018.tif',1,1,NULL), +('NOT-YET-IN-GRID-TRANSFORMATION-rdcorr2018.gsb','nl_nsgi_rdcorr2018.tif','rdcorr2018.gsb','GTiff','hgridshift',0,NULL,'https://cdn.proj.org/nl_nsgi_rdcorr2018.tif',1,1,NULL), -- Belgium ('bd72lb72_etrs89lb08.gsb','be_ign_bd72lb72_etrs89lb08.tif','bd72lb72_etrs89lb08.gsb','GTiff','hgridshift',0,NULL,'https://cdn.proj.org/be_ign_bd72lb72_etrs89lb08.tif',1,1,NULL), -- Switzerland diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index cd545666..8de27a48 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1118,7 +1118,7 @@ CREATE TRIGGER grid_alternatives_insert_trigger BEFORE INSERT ON grid_alternatives FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on grid_alternatives violates constraint: original_grid_name must be referenced in grid_transformation.grid_name') - WHERE NEW.original_grid_name NOT IN ('null') AND NEW.original_grid_name NOT IN (SELECT grid_name FROM grid_transformation); + WHERE NEW.original_grid_name NOT LIKE 'NOT-YET-IN-GRID-TRANSFORMATION-%' AND NEW.original_grid_name NOT IN (SELECT grid_name FROM grid_transformation); END; CREATE TABLE other_transformation( |