From ae1a0324fb51c8a357b24991c3627d5c2414a784 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Wed, 22 Jan 2020 22:09:26 +0100
Subject: Database: update to EPSG v9.8.6

Fixes #1867
---
 data/sql/grid_alternatives.sql | 51 +++++++++++++++++++++++++++++++++++++++++-
 1 file changed, 50 insertions(+), 1 deletion(-)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index f3854ba0..37a4d98a 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -2030,6 +2030,26 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'proj-datumgrid-oceania',
                               NULL, NULL, NULL, NULL);
 
+-- WARNING: this builds the new entries from the above deprecated ones
+-- A check has been added in commit.sql to verify that a mapping from
+-- auckht1946-nzvd2016.gtx exists in this table, due to the below insert
+INSERT INTO grid_alternatives(original_grid_name,
+                              proj_grid_name,
+                              proj_grid_format,
+                              proj_method,
+                              inverse_direction,
+                              package_name,
+                              url, direct_download, open_license, directory)
+                       SELECT proj_grid_name,
+                              proj_grid_name, 'GTX',
+                              'vgridshift',
+                              0,
+                              'proj-datumgrid-oceania',
+                              NULL, NULL, NULL, NULL
+                       FROM grid_alternatives
+                       WHERE proj_grid_name LIKE '%-nzvd2016.gtx';
+
+-- Superseded
 INSERT INTO grid_alternatives(original_grid_name,
                               proj_grid_name,
                               proj_grid_format,
@@ -2045,6 +2065,22 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'proj-datumgrid-oceania',
                               NULL, NULL, NULL, NULL);
 
+INSERT INTO grid_alternatives(original_grid_name,
+                              proj_grid_name,
+                              proj_grid_format,
+                              proj_method,
+                              inverse_direction,
+                              package_name,
+                              url, direct_download, open_license, directory)
+                      VALUES ('nzgeoid2016.gtx',
+                              'nzgeoid2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              1,
+                              'proj-datumgrid-oceania',
+                              NULL, NULL, NULL, NULL);
+
+-- Superseded
 INSERT INTO grid_alternatives(original_grid_name,
                               proj_grid_name,
                               proj_grid_format,
@@ -2060,4 +2096,17 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'proj-datumgrid-oceania',
                               NULL, NULL, NULL, NULL);
 
-
+INSERT INTO grid_alternatives(original_grid_name,
+                              proj_grid_name,
+                              proj_grid_format,
+                              proj_method,
+                              inverse_direction,
+                              package_name,
+                              url, direct_download, open_license, directory)
+                      VALUES ('nzgeoid2009.gtx',
+                              'nzgeoid2009.gtx',
+                              'GTX',
+                              'vgridshift',
+                              1,
+                              'proj-datumgrid-oceania',
+                              NULL, NULL, NULL, NULL);
-- 
cgit v1.2.3

