From 2a9d99607cd17bc79faeb16ba1b3be1f38ae4ff8 Mon Sep 17 00:00:00 2001
From: dalia2 <dalia@lmi.is>
Date: Sun, 1 Dec 2019 15:41:21 +0000
Subject: Update grid_alternatives.sql

Updated the grid_alternatives.sql
---
 data/sql/grid_alternatives.sql | 31 +++++++++++++++++++++++++++++++
 1 file changed, 31 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 20551581..86e01bca 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1468,3 +1468,34 @@ INSERT INTO grid_alternatives(original_grid_name,
                               0,
                               'proj-datumgrid-north-america',
                               NULL, NULL, NULL, NULL);
+ -- Iceland
+
+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 ('ISN93_ISN2016.gsb',
+                              'ISN93_ISN2016.gsb',
+                              'NTv2',
+                              'hgridshift',
+                              1,
+                              'proj-datumgrid-europe',
+                              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 ('ISN2004_ISN2016.gsb',
+                              'ISN2004_ISN2016.gsb',
+                              'NTv2',
+                              'hgridshift',
+                              1,
+                              'proj-datumgrid-europe',
+                              NULL, NULL, NULL, NULL);
\ No newline at end of file
-- 
cgit v1.2.3


From a6ff106dbc723bf685665a833fd3c2578a7d8993 Mon Sep 17 00:00:00 2001
From: dalia2 <57895979+dalia2@users.noreply.github.com>
Date: Sun, 1 Dec 2019 15:52:46 +0000
Subject: Update data/sql/grid_alternatives.sql

Co-Authored-By: Even Rouault <even.rouault@spatialys.com>
---
 data/sql/grid_alternatives.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 86e01bca..a12aad12 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1481,7 +1481,7 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'ISN93_ISN2016.gsb',
                               'NTv2',
                               'hgridshift',
-                              1,
+                              0,
                               'proj-datumgrid-europe',
                               NULL, NULL, NULL, NULL);
 
@@ -1498,4 +1498,4 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'hgridshift',
                               1,
                               'proj-datumgrid-europe',
-                              NULL, NULL, NULL, NULL);
\ No newline at end of file
+                              NULL, NULL, NULL, NULL);
-- 
cgit v1.2.3


From 10baba9fa4cac45c7d746281eacc4a403022087f Mon Sep 17 00:00:00 2001
From: dalia2 <57895979+dalia2@users.noreply.github.com>
Date: Sun, 1 Dec 2019 15:54:05 +0000
Subject: Update data/sql/grid_alternatives.sql

Co-Authored-By: Even Rouault <even.rouault@spatialys.com>
---
 data/sql/grid_alternatives.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index a12aad12..191f49cf 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1496,6 +1496,6 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'ISN2004_ISN2016.gsb',
                               'NTv2',
                               'hgridshift',
-                              1,
+                              0,
                               'proj-datumgrid-europe',
                               NULL, NULL, NULL, NULL);
-- 
cgit v1.2.3


From 71ae00a0509783f80f8c16929f321fd06e805f1e Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Fri, 6 Dec 2019 15:25:22 +0100
Subject: grid_alernatives.sql: point to specific revisions of the
 proj-datumgrid-XXXX packages

Due to potential future shift to GTiff format, we don't want users of PROJ 6.3
being pointed to grids they won't be able to use.
So point to
- proj-datumgrid-1.8: already existing, unlikely to change before 6.3
- proj-datumgrid-north-america-1.3: to be released
- proj-datumgrid-europe-1.5: to be released
- proj-datumgrid-oceania-1.1: to be released
- proj-datumgrid-world-1.0: already existing, unlikely to change before 6.3
---
 data/sql/grid_alternatives.sql | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 600446f5..a3d9c2c5 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -10,32 +10,32 @@
 
 INSERT INTO grid_packages VALUES ('proj-datumgrid',
                                   'Package with grids of general interest',
-                                  'https://download.osgeo.org/proj/proj-datumgrid-latest.zip',
+                                  'https://download.osgeo.org/proj/proj-datumgrid-1.8.zip',
                                   1,
                                   1);
 
 INSERT INTO grid_packages VALUES ('proj-datumgrid-north-america',
                                   'Package with grids of interest for North-America',
-                                  'https://download.osgeo.org/proj/proj-datumgrid-north-america-latest.zip',
+                                  'https://download.osgeo.org/proj/proj-datumgrid-north-america-1.3.zip',
                                   1,
                                   1);
 
 INSERT INTO grid_packages VALUES ('proj-datumgrid-europe',
                                   'Package with grids of interest for Europe',
-                                  'https://download.osgeo.org/proj/proj-datumgrid-europe-latest.zip',
+                                  'https://download.osgeo.org/proj/proj-datumgrid-europe-1.5.zip',
                                   1,
                                   1);
 
 INSERT INTO grid_packages VALUES ('proj-datumgrid-oceania',
                                   'Package with grids of interest for Oceania',
-                                  'https://download.osgeo.org/proj/proj-datumgrid-oceania-latest.zip',
+                                  'https://download.osgeo.org/proj/proj-datumgrid-oceania-1.1.zip',
                                   1,
                                   1);
 
  -- not released yet at the time of writing
 INSERT INTO grid_packages VALUES ('proj-datumgrid-world',
                                   'Package with grids of global extent (too large to be included in proj-datumgrid)',
-                                  'https://download.osgeo.org/proj/proj-datumgrid-world-latest.zip',
+                                  'https://download.osgeo.org/proj/proj-datumgrid-world-1.0.zip',
                                   1,
                                   1);
 
-- 
cgit v1.2.3


From 864e9339163f182893b9e075a6f58de17147b9f7 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Wed, 11 Dec 2019 12:42:13 +0100
Subject: Database: register 100800401.gsb for Catalonia ED50 -> ETRS89

Refs https://github.com/OSGeo/proj-datumgrid/pull/88
---
 data/sql/grid_alternatives.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 600446f5..1d06de9e 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1193,6 +1193,23 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'proj-datumgrid-europe',
                               NULL, NULL, NULL, NULL);
 
+-- Spain
+
+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 ('100800401.gsb',
+                              '100800401.gsb',
+                              'NTv2',
+                              'hgridshift',
+                              0,
+                              'proj-datumgrid-europe',
+                              NULL, NULL, NULL, NULL);
+
 -- Portugal
 
 INSERT INTO grid_alternatives(original_grid_name,
-- 
cgit v1.2.3


From 0f7a93138f9652e920521d09e7c73790e0cae65f Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Sat, 14 Dec 2019 02:20:09 +0100
Subject: Database: add mappings to AUSGeoid98.gtx in grid_alternatives

---
 data/sql/grid_alternatives.sql | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 600446f5..b4effec1 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1106,6 +1106,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)
+    SELECT grid_name,
+           'AUSGeoid98.gtx',
+           'GTX',
+           'vgridshift',
+           1,
+           'proj-datumgrid-oceania',
+           NULL, NULL, NULL, NULL FROM grid_transformation WHERE
+                grid_name LIKE '%DAT.htm' AND name LIKE 'GDA94 to AHD height%';
+
 -- Netherlands / RDNAP (non-free grids)
 
 INSERT INTO grid_alternatives(original_grid_name,
-- 
cgit v1.2.3


From 216492df4358c552875d834365857ed3a3dd8d8c Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Tue, 17 Dec 2019 16:54:16 +0100
Subject: Database: register SeTa2016.gsb for DHDN to ETRS89 in Saarland (refs
 https://github.com/OSGeo/proj-datumgrid/pull/89) (#1791)

---
 data/sql/grid_alternatives.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index ee8760db..86d61ffa 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -133,6 +133,21 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'proj-datumgrid-europe',
                               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 ('SeTa2016.gsb',
+                              'SeTa2016.gsb', -- no change. Just document the package
+                              'NTv2',
+                              'hgridshift',
+                              0,
+                              'proj-datumgrid-europe',
+                              NULL, NULL, NULL, NULL);
+
 INSERT INTO grid_alternatives(original_grid_name,
                               proj_grid_name,
                               proj_grid_format,
-- 
cgit v1.2.3


From baf9c46795a1ad83a160f3a3f84951d2f49fb22b Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Tue, 17 Dec 2019 16:58:47 +0100
Subject: Database: register Canadian geoid models added per
 https://github.com/OSGeo/proj-datumgrid/pull/91 (#1796)

---
 data/sql/grid_alternatives.sql | 76 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 76 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 86d61ffa..55c3c013 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1591,6 +1591,82 @@ INSERT INTO grid_alternatives(original_grid_name,
                               0,
                               'proj-datumgrid-north-america',
                               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 ('HT2_0.byn',
+                              'HT2_2010v70.gtx',
+                              'GTX',
+                              'vgridshift',
+                              1,
+                              'proj-datumgrid-north-america',
+                              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 ('CGG2013i08a.byn',
+                              'CGG2013ai08.gtx',
+                              'GTX',
+                              'vgridshift',
+                              1,
+                              'proj-datumgrid-north-america',
+                              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 ('CGG2013n83a.byn',
+                              'CGG2013an83.gtx',
+                              'GTX',
+                              'vgridshift',
+                              1,
+                              'proj-datumgrid-north-america',
+                              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 ('CGG2013i83.byn',
+                              'CGG2013i08.gtx',
+                              'GTX',
+                              'vgridshift',
+                              1,
+                              'proj-datumgrid-north-america',
+                              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 ('CGG2013n83.byn',
+                              'CGG2013n83.gtx',
+                              'GTX',
+                              'vgridshift',
+                              1,
+                              'proj-datumgrid-north-america',
+                              NULL, NULL, NULL, NULL);
+
  -- Iceland
 
 INSERT INTO grid_alternatives(original_grid_name,
-- 
cgit v1.2.3


From 13dd313795ec37a810923c97327030b0f352d904 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Wed, 18 Dec 2019 19:25:50 +0100
Subject: Database: register MAY76V20.gsb

---
 data/sql/grid_alternatives.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 55c3c013..3a3df1d0 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -103,6 +103,21 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'proj-datumgrid-north-america',
                               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 ('May76v20.gsb',
+                              'MAY76V20.gsb', -- just a case change
+                              'NTv2',
+                              'hgridshift',
+                              0,
+                              'proj-datumgrid-north-america',
+                              NULL, NULL, NULL, NULL);
+
 INSERT INTO grid_alternatives(original_grid_name,
                               proj_grid_name,
                               proj_grid_format,
-- 
cgit v1.2.3


From 6c40887e4df041d6be40a54818d98000180e3b7a Mon Sep 17 00:00:00 2001
From: Chris Crook <ccrook@linz.govt.nz>
Date: Tue, 3 Dec 2019 15:10:12 +1300
Subject: Adding New Zealand grid alternative names

---
 data/sql/grid_alternatives.sql | 228 +++++++++++++++++++++++++++++++++++++++++
 1 file changed, 228 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 3a3df1d0..3422405b 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1713,3 +1713,231 @@ INSERT INTO grid_alternatives(original_grid_name,
                               0,
                               'proj-datumgrid-europe',
                               NULL, NULL, NULL, NULL);
+
+-- New Zealand grid shift models.  EPSG names are not for GTX files (at time of writing)
+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 ('auckland-1946-to-nzvd2016-conversion.csv',
+                              'auckht1946-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('bluff-1955-to-nzvd2016-conversion.csv',
+                              'blufht1955-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('dunedin-1958-to-nzvd2016-conversion.csv',
+                              'duneht1958-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('dunedin-bluff-1960-to-nzvd2016-conversion.csv',
+                              'dublht1960-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('gisborne-1926-to-nzvd2016-conversion.csv',
+                              'gisbht1926-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('lyttelton-1937-to-nzvd2016-conversion.csv',
+                              'lyttht1937-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('moturiki-1953-to-nzvd2016-conversion.csv',
+                              'motuht1953-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('napier-1962-to-nzvd2016-conversion.csv',
+                              'napiht1962-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('nelson-1955-to-nzvd2016-conversion.csv',
+                              'nelsht1955-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('onetreepoint-1964-to-nzvd2016-conversion.csv',
+                              'ontpht1964-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('stewartisland-1977-to-nzvd2016-conversion.csv',
+                              'stisht1977-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('taranaki-1970-to-nzvd2016-conversion.csv',
+                              'taraht1970-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('wellington-1953-to-nzvd2016-conversion.csv',
+                              'wellht1953-nzvd2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              '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 ('New_Zealand_Quasigeoid_2016.csv',
+                              'nzgeoid2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              1,
+                              '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 ('nzgeoid09.sid',
+                              'nzgeoid2009.gtx',
+                              'GTX',
+                              'vgridshift',
+                              1,
+                              'proj-datumgrid-oceania',
+                              NULL, NULL, NULL, NULL);
+
+
-- 
cgit v1.2.3


From 9051b19987733ec1114d0597c2074b1d45582144 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Fri, 20 Dec 2019 15:14:20 +0100
Subject: Database: add name mappings for na27na83.gsb and cq77na83.gsb; also
 fix the mapping between CGQ77-98.gsb and CQ77SCRS.GSB

---
 data/sql/grid_alternatives.sql | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 3422405b..9bc27ea8 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1500,6 +1500,21 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'proj-datumgrid-north-america',
                               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 ('NA27NA83.GSB',
+                              'na27na83.gsb',
+                              'NTv2',
+                              'hgridshift',
+                              0,
+                              'proj-datumgrid-north-america',
+                              NULL, NULL, NULL, NULL);
+
 -- two grid names in EPSG point to the same file distributed by NRCan
 INSERT INTO grid_alternatives(original_grid_name,
                               proj_grid_name,
@@ -1539,6 +1554,21 @@ INSERT INTO grid_alternatives(original_grid_name,
                               package_name,
                               url, direct_download, open_license, directory)
                       VALUES ('CQ77NA83.GSB',
+                              'cq77na83.gsb',
+                              'NTv2',
+                              'hgridshift',
+                              0,
+                              'proj-datumgrid-north-america',
+                              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 ('CGQ77-98.gsb',
                               'CQ77SCRS.GSB',
                               'NTv2',
                               'hgridshift',
-- 
cgit v1.2.3


From e7ef9b626ecabfe6bc5ff3793a9565426470a4a3 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Sat, 21 Dec 2019 02:13:07 +0100
Subject: Database: fix registration of Icegeoid_xxx.gtx files, and add
 corresponding entries in grid_alternatives.sql

---
 data/sql/grid_alternatives.sql | 45 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 45 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 9bc27ea8..087036de 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1744,6 +1744,51 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'proj-datumgrid-europe',
                               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 ('Icegeoid_ISN2004.gtx',
+                              'Icegeoid_ISN2004.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              'proj-datumgrid-europe',
+                              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 ('Icegeoid_ISN93.gtx',
+                              'Icegeoid_ISN93.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              'proj-datumgrid-europe',
+                              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 ('Icegeoid_ISN2016.gtx',
+                              'Icegeoid_ISN2016.gtx',
+                              'GTX',
+                              'vgridshift',
+                              0,
+                              'proj-datumgrid-europe',
+                              NULL, NULL, NULL, NULL);
+
 -- New Zealand grid shift models.  EPSG names are not for GTX files (at time of writing)
 INSERT INTO grid_alternatives(original_grid_name,
                               proj_grid_name,
-- 
cgit v1.2.3


From 906f47e250b3bdb6fd24954e9707edc52c9a6abf Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Sat, 28 Dec 2019 22:47:02 +0100
Subject: Database: add mapping for gg10_smv2.mnt and gg10_sbv2.mnt French
 grids

---
 data/sql/grid_alternatives.sql | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index 087036de..a8c21d8b 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -877,6 +877,21 @@ INSERT INTO grid_alternatives(original_grid_name,
                             'proj-datumgrid-europe',
                             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 ('gg10_smv2.mnt',
+                            'gg10_smv2.gtx',
+                            'GTX',
+                            'vgridshift',
+                            1,
+                            'proj-datumgrid-europe',
+                            NULL, NULL, NULL, NULL);
+
 INSERT INTO grid_alternatives(original_grid_name,
                             proj_grid_name,
                             proj_grid_format,
@@ -952,6 +967,21 @@ INSERT INTO grid_alternatives(original_grid_name,
                             'proj-datumgrid-europe',
                             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 ('gg10_sbv2.mnt',
+                            'gg10_sbv2.gtx',
+                            'GTX',
+                            'vgridshift',
+                            1,
+                            'proj-datumgrid-europe',
+                            NULL, NULL, NULL, NULL);
+
 INSERT INTO grid_alternatives(original_grid_name,
                             proj_grid_name,
                             proj_grid_format,
-- 
cgit v1.2.3


From b1bb0e619fa971fd701073eee54e00800bd3bcd3 Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Sat, 28 Dec 2019 23:14:53 +0100
Subject: Database: add mapping for TOR27CSv1.GSB

---
 data/sql/grid_alternatives.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

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

diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql
index a8c21d8b..f3854ba0 100644
--- a/data/sql/grid_alternatives.sql
+++ b/data/sql/grid_alternatives.sql
@@ -1515,6 +1515,21 @@ INSERT INTO grid_alternatives(original_grid_name,
                               'proj-datumgrid-north-america',
                               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 ('TOR27CSv1.GSB',
+                              'TO27CSv1.GSB',
+                              'NTv2',
+                              'hgridshift',
+                              0,
+                              'proj-datumgrid-north-america',
+                              NULL, NULL, NULL, NULL);
+
 INSERT INTO grid_alternatives(original_grid_name,
                               proj_grid_name,
                               proj_grid_format,
-- 
cgit v1.2.3

