diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-01-22 22:09:26 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-01-23 19:05:48 +0100 |
| commit | ae1a0324fb51c8a357b24991c3627d5c2414a784 (patch) | |
| tree | 15570cf7eb0fa9bd28ecbcd096b807f2a1b859a4 /data/sql/grid_alternatives.sql | |
| parent | a217239fa55b5c7002d37a5b17fb41117dfb4b64 (diff) | |
| download | PROJ-ae1a0324fb51c8a357b24991c3627d5c2414a784.tar.gz PROJ-ae1a0324fb51c8a357b24991c3627d5c2414a784.zip | |
Database: update to EPSG v9.8.6
Fixes #1867
Diffstat (limited to 'data/sql/grid_alternatives.sql')
| -rw-r--r-- | data/sql/grid_alternatives.sql | 51 |
1 files changed, 50 insertions, 1 deletions
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, @@ -2052,6 +2072,22 @@ INSERT INTO grid_alternatives(original_grid_name, 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, + proj_method, + inverse_direction, + package_name, + url, direct_download, open_license, directory) VALUES ('nzgeoid09.sid', 'nzgeoid2009.gtx', 'GTX', @@ -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); |