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-22 22:31:44 +0100 |
| commit | ffcd6253bb6b275cfc8884eeb88aa2eeac75e3b6 (patch) | |
| tree | cd279a62afef8567235ee6ad37ff1d38c75db7b8 /data/sql/grid_alternatives.sql | |
| parent | db31b6dfa9c8fe37d5706d95ce81012b8db3c3b9 (diff) | |
| download | PROJ-ffcd6253bb6b275cfc8884eeb88aa2eeac75e3b6.tar.gz PROJ-ffcd6253bb6b275cfc8884eeb88aa2eeac75e3b6.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); |