From 410631e5a25ae88f81545393240da86722f289f9 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Fri, 22 Feb 2019 12:38:24 +0100
Subject: proj.db: tune so that 'NGF IGN69 height to RGF93' uses the RAF09.gtx
 grid

---
 data/sql/customizations.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

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

diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql
index 8e31c233..6e9bacbb 100644
--- a/data/sql/customizations.sql
+++ b/data/sql/customizations.sql
@@ -7,6 +7,18 @@ INSERT INTO "other_transformation" VALUES('PROJ','CRS84_TO_EPSG_4326','OGC:CRS84
 -- alias of EPSG:3857
 INSERT INTO "projected_crs" VALUES('EPSG','900913','Google Maps Global Mercator',NULL,NULL,'EPSG','4499','EPSG','4326','EPSG','3856','EPSG','3544',NULL,1);
 
+-- Remove supression entry of EPSG:8371 ("RGF93 to NGF IGN69 height (2)", using RAF09.mnt) by
+-- EPSG:8885 ("RGF93 to NGF IGN69 height (3)", using RAF18.tac), since
+-- we have only RAF09.mnt in proj-datumgrid-europe
+-- Our code to remove superseded operations should probably take into account grid availability
+DELETE FROM "supersession" WHERE superseded_table_name = 'grid_transformation' AND
+                                 superseded_auth_name = 'EPSG' AND
+                                 superseded_code = '8371' AND
+                                 replacement_table_name = 'grid_transformation' AND
+                                 replacement_auth_name = 'EPSG' AND
+                                 replacement_code = '8885' AND
+                                 source = 'EPSG';
+
 -- Define the allowed authorities, and their precedence, when researching a
 -- coordinate operation
 
-- 
cgit v1.2.3

