aboutsummaryrefslogtreecommitdiff
path: root/data/sql/grid_alternatives.sql
diff options
context:
space:
mode:
authorAndrew Bell <andrew.bell.ia@gmail.com>2019-05-15 10:47:03 -0400
committerAndrew Bell <andrew.bell.ia@gmail.com>2019-05-15 10:47:03 -0400
commit8f268409d37cea329d263e177b83e42f8384d3c7 (patch)
treec4d0f3dd19456600f718a6e0c8573577f433549b /data/sql/grid_alternatives.sql
parent886ced02f0aaab5d66d16459435f7447cf976650 (diff)
parentd67203a6f76a74f5ac029ff052dbcc72e3b59624 (diff)
downloadPROJ-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.sql266
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);