diff options
| author | Andrew Bell <andrew.bell.ia@gmail.com> | 2019-05-15 10:47:03 -0400 |
|---|---|---|
| committer | Andrew Bell <andrew.bell.ia@gmail.com> | 2019-05-15 10:47:03 -0400 |
| commit | 8f268409d37cea329d263e177b83e42f8384d3c7 (patch) | |
| tree | c4d0f3dd19456600f718a6e0c8573577f433549b /data/sql/grid_alternatives.sql | |
| parent | 886ced02f0aaab5d66d16459435f7447cf976650 (diff) | |
| parent | d67203a6f76a74f5ac029ff052dbcc72e3b59624 (diff) | |
| download | PROJ-8f268409d37cea329d263e177b83e42f8384d3c7.tar.gz PROJ-8f268409d37cea329d263e177b83e42f8384d3c7.zip | |
Merge remote-tracking branch 'origin/master'
Diffstat (limited to 'data/sql/grid_alternatives.sql')
| -rw-r--r-- | data/sql/grid_alternatives.sql | 266 |
1 files changed, 261 insertions, 5 deletions
diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql index a45c43f1..cf1e559d 100644 --- a/data/sql/grid_alternatives.sql +++ b/data/sql/grid_alternatives.sql @@ -26,6 +26,12 @@ INSERT INTO grid_packages VALUES ('proj-datumgrid-europe', 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', + 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)', @@ -142,6 +148,53 @@ INSERT INTO grid_alternatives(original_grid_name, 'proj-datumgrid-europe', NULL, NULL, NULL, NULL); +-- Continental USA VERTCON: NGVD (19)29 height to NAVD (19)88 height + +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 ('vertconw.94', + 'vertconw.gtx', + 'GTX', + 'vgridshift', + 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 ('vertconc.94', + 'vertconc.gtx', + 'GTX', + 'vgridshift', + 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 ('vertcone.94', + 'vertcone.gtx', + 'GTX', + 'vgridshift', + 0, + 'proj-datumgrid-north-america', + NULL, NULL, NULL, NULL); + -- EGM models INSERT INTO grid_alternatives(original_grid_name, @@ -239,6 +292,74 @@ INSERT INTO grid_alternatives(original_grid_name, 'proj-datumgrid-europe', NULL, NULL, NULL, NULL); +-- Faroe islands height models + +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 ('fvr09.gtx', + 'fvr09.gtx', -- no change. Just document the package + 'GTX', + 'vgridshift', + 0, -- do not reverse here as grid_transformation_custom does reference from VerticalCRS height to Geographic height + 'proj-datumgrid-europe', + NULL, NULL, NULL, NULL); + +-- Sweden height models + +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 ('SWEN17_RH2000.gtx', + 'SWEN17_RH2000.gtx', -- no change. Just document the package + 'GTX', + 'vgridshift', + 0, -- do not reverse here as grid_transformation_custom does reference from VerticalCRS height to Geographic height + 'proj-datumgrid-europe', + NULL, NULL, NULL, NULL); + +-- Ireland: OSGM15 height, Malin head datum -> ETRS89 ellipsoidal heights + +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 ('OSGM15_Malin.gri', + 'OSGM15_Malin.gtx', + 'GTX', + 'vgridshift', + 1, + 'proj-datumgrid-europe', + NULL, NULL, NULL, NULL); + +-- Northern Ireland: OSGM15 height, Belfast height -> ETRS89 ellipsoidal heights + +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 ('OSGM15_Belfast.gri', + 'OSGM15_Belfast.gtx', + 'GTX', + 'vgridshift', + 1, + 'proj-datumgrid-europe', + NULL, NULL, NULL, NULL); + ---------------------------- -- US GEOID12B height models ---------------------------- @@ -255,7 +376,7 @@ INSERT INTO grid_alternatives(original_grid_name, 'g2012bu0.gtx', 'GTX', 'vgridshift', - 0, + 1, 'proj-datumgrid-north-america', NULL, NULL, NULL, NULL); @@ -271,7 +392,7 @@ INSERT INTO grid_alternatives(original_grid_name, 'g2012ba0.gtx', 'GTX', 'vgridshift', - 0, + 1, 'proj-datumgrid-north-america', NULL, NULL, NULL, NULL); @@ -287,7 +408,7 @@ INSERT INTO grid_alternatives(original_grid_name, 'g2012bp0.gtx', 'GTX', 'vgridshift', - 0, + 1, 'proj-datumgrid-north-america', NULL, NULL, NULL, NULL); @@ -303,7 +424,7 @@ INSERT INTO grid_alternatives(original_grid_name, 'g2012bg0.gtx', 'GTX', 'vgridshift', - 0, + 1, 'proj-datumgrid-north-america', NULL, NULL, NULL, NULL); @@ -319,7 +440,7 @@ INSERT INTO grid_alternatives(original_grid_name, 'g2012bs0.gtx', 'GTX', 'vgridshift', - 0, + 1, 'proj-datumgrid-north-america', NULL, NULL, NULL, NULL); @@ -350,6 +471,21 @@ INSERT INTO grid_alternatives(original_grid_name, inverse_direction, package_name, url, direct_download, open_license, directory) + VALUES ('RAF18.tac', + 'RAF18.gtx', + 'GTX', + 'vgridshift', + 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 ('RAC09.mnt', 'RAC09.gtx', 'GTX', @@ -597,3 +733,123 @@ INSERT INTO grid_alternatives(original_grid_name, 1, 'proj-datumgrid-europe', NULL, NULL, NULL, NULL); + + +---------------------------- +-- Australian grids +---------------------------- + +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 ('A66 National (13.09.01).gsb', + 'A66_National_13_09_01.gsb', + 'NTv2', + 'hgridshift', + 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 ('National 84 (02.07.01).gsb', + 'National_84_02_07_01.gsb', + 'NTv2', + 'hgridshift', + 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 ('GDA94_GDA2020_conformal.gsb', + 'GDA94_GDA2020_conformal.gsb', + 'NTv2', + 'hgridshift', + 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 ('GDA94_GDA2020_conformal_and_distortion.gsb', + 'GDA94_GDA2020_conformal_and_distortion.gsb', + 'NTv2', + 'hgridshift', + 0, + 'proj-datumgrid-oceania', + NULL, NULL, NULL, NULL); + +-- Netherlands / RDNAP (non-free grids) + +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 ('naptrans2008.gtx', + 'naptrans2008.gtx', + 'GTX', + 'vgridshift', + 0, + NULL, -- package name + 'https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/upstream/2008/naptrans2008.gtx', + 1, -- direct download + 0, -- non-freely licensed. See https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/master/debian/copyright + 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 ('rdtrans2008.gsb', + 'rdtrans2008.gsb', + 'NTv2', + 'hgridshift', + 0, + NULL, -- package name + 'https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/upstream/2008/rdtrans2008.gsb', + 1, -- direct download + 0, -- non-freely licensed. See https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/master/debian/copyright + NULL); + +-- Belgium + +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 ('bd72lb72_etrs89lb08.gsb', + 'bd72lb72_etrs89lb08.gsb', + 'NTv2', + 'hgridshift', + 0, + 'proj-datumgrid-europe', + NULL, NULL, NULL, NULL); |
