From 9f6ab28f1d26561a547802a18b3a2f7877834ca8 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Wed, 29 Jan 2020 14:44:04 +0100 Subject: Make it possible to use grids from the CDN by their 'old name' even if not in the EPSG/grid_transformation table --- data/sql/grid_alternatives.sql | 2 ++ data/sql/proj_db_table_defs.sql | 2 +- 2 files changed, 3 insertions(+), 1 deletion(-) (limited to 'data/sql') 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( -- cgit v1.2.3