From dc55b17d0c7ae180bb73add3581fac7e8f959c11 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Sat, 30 Nov 2019 19:41:50 +0100
Subject: Database: register the BWTA2017.gsb grid (DHDN->ETRS89 for
 Baden-Wurtemberg)

Relates to https://github.com/OSGeo/proj-datumgrid/pull/65 ,
https://github.com/OSGeo/proj-datumgrid/issues/22

As EPSG has no entry for it, we create a grid_transformation, as well as a
dedicated area of use based on the extent of the grid, under the PROJ authority.
With the hope to be able to remove it once EPSG has an entry...
---
 data/sql/commit.sql | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'data/sql/commit.sql')

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');
-- 
cgit v1.2.3

