aboutsummaryrefslogtreecommitdiff
path: root/data/sql/commit.sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2019-12-03 14:18:35 +0100
committerGitHub <noreply@github.com>2019-12-03 14:18:35 +0100
commita0de56228be06427c7870cbc1923b11dad11856e (patch)
treef7eef3160c08dfe6490119fcd2545c61516c4128 /data/sql/commit.sql
parentc3aa3fe4e9ba17737bb013ed6e7a647fdd5303fe (diff)
parentdc55b17d0c7ae180bb73add3581fac7e8f959c11 (diff)
downloadPROJ-a0de56228be06427c7870cbc1923b11dad11856e.tar.gz
PROJ-a0de56228be06427c7870cbc1923b11dad11856e.zip
Merge pull request #1759 from rouault/BWTA2017
Database: register the BWTA2017.gsb grid (DHDN->ETRS89 for Baden-Wurtemberg)
Diffstat (limited to 'data/sql/commit.sql')
-rw-r--r--data/sql/commit.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/data/sql/commit.sql b/data/sql/commit.sql
index a708df0f..0468032d 100644
--- a/data/sql/commit.sql
+++ b/data/sql/commit.sql
@@ -30,6 +30,12 @@ FOR EACH ROW BEGIN
SELECT RAISE(ABORT, 'corrupt definition of authority_list')
WHERE (SELECT 1 FROM authority_list LIMIT 1) = 0;
+ -- test to check that our custom grid transformation overrides are really needed
+ SELECT RAISE(ABORT, 'PROJ grid_transformation defined whereas EPSG has one')
+ WHERE EXISTS (SELECT 1 FROM grid_transformation g1, grid_transformation g2 WHERE
+ lower(g1.grid_name) = lower(g2.grid_name) AND
+ g1.auth_name = 'PROJ' AND g2.auth_name = 'EPSG');
+
-- check geoid_model table
SELECT RAISE(ABORT, 'missing GEOID99 in geoid_model')
WHERE NOT EXISTS(SELECT 1 FROM geoid_model WHERE name = 'GEOID99');