From 229bc49f7ad1bd024fc503f68d6705f3b0adcdf2 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Mon, 19 Nov 2018 12:38:10 +0100 Subject: Database: add mapping to GEOID12B height models added per https://github.com/OSGeo/proj-datumgrid/pull/39 --- data/sql/grid_alternatives.sql | 92 ++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 88 insertions(+), 4 deletions(-) (limited to 'data/sql') diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql index b0a050ed..6e3ba37d 100644 --- a/data/sql/grid_alternatives.sql +++ b/data/sql/grid_alternatives.sql @@ -10,26 +10,26 @@ INSERT INTO grid_packages VALUES ('proj-datumgrid', 'Package with grids of general interest', - 'https://download.osgeo.org/proj/proj-datumgrid-1.8.zip', + 'https://download.osgeo.org/proj/proj-datumgrid-latest.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-1.1.zip', + 'https://download.osgeo.org/proj/proj-datumgrid-north-america-latest.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-1.1.zip', + 'https://download.osgeo.org/proj/proj-datumgrid-europe-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)', - 'https://download.osgeo.org/proj/proj-datumgrid-world-1.0.zip', + 'https://download.osgeo.org/proj/proj-datumgrid-world-latest.zip', 1, 1); @@ -239,4 +239,88 @@ INSERT INTO grid_alternatives(original_grid_name, 'proj-datumgrid-europe', NULL, NULL, NULL, NULL); +---------------------------- +-- US GEOID12B height models +---------------------------- + +-- CONUS +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 ('g2012Bu0.bin', + 'g2012bu0.gtx', + 'GTX', + 'vgridshift', + 0, + 'proj-datumgrid-north-america', + NULL, NULL, NULL, NULL); + +-- Alaska +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 ('g2012Ba0.bin', + 'g2012ba0.gtx', + 'GTX', + 'vgridshift', + 0, + 'proj-datumgrid-north-america', + NULL, NULL, NULL, NULL); + +-- Puerto Rico +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 ('g2012Bp0.bin', + 'g2012bp0.gtx', + 'GTX', + 'vgridshift', + 0, + 'proj-datumgrid-north-america', + NULL, NULL, NULL, NULL); + +-- Guam +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 ('g2012Bg0.bin', + 'g2012bg0.gtx', + 'GTX', + 'vgridshift', + 0, + 'proj-datumgrid-north-america', + NULL, NULL, NULL, NULL); + +-- American Samoa +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 ('g2012Bs0.bin', + 'g2012bs0.gtx', + 'GTX', + 'vgridshift', + 0, + 'proj-datumgrid-north-america', + NULL, NULL, NULL, NULL); + -- cgit v1.2.3