diff options
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/customizations.sql | 19 | ||||
| -rw-r--r-- | data/sql/grid_alternatives.sql | 38 |
2 files changed, 57 insertions, 0 deletions
diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index ee023700..0ce4a692 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -19,6 +19,25 @@ DELETE FROM "supersession" WHERE superseded_table_name = 'grid_transformation' A replacement_code = '8885' AND source = 'EPSG'; +-- ('EPSG','7001','ETRS89 to NAP height (1)') lacks an interpolationCRS with Amersfoort / EPSG:4289 +-- See https://salsa.debian.org/debian-gis-team/proj-rdnap/blob/debian/2008-8/Use%20of%20RDTRANS2008%20and%20NAPTRANS2008.pdf +-- "The naptrans2008 VDatum-grid is referenced to the Bessel-1841 ellipsoid" +CREATE TABLE dummy(foo); +CREATE TRIGGER check_grid_transformation_epsg_7001 +BEFORE INSERT ON dummy +FOR EACH ROW BEGIN + SELECT RAISE(ABORT, 'grid_transformation EPSG:7001 entry is not ETRS89 to NAP height (1)') + WHERE NOT EXISTS(SELECT 1 FROM grid_transformation WHERE auth_name = 'EPSG' AND code = '7001' AND name = 'ETRS89 to NAP height (1)'); + SELECT RAISE(ABORT, 'grid_transformation EPSG:7001 entry has already an interpolationCRS') + WHERE EXISTS(SELECT 1 FROM grid_transformation WHERE auth_name = 'EPSG' AND code = '7001' AND interpolation_crs_auth_name IS NOT NULL); +END; +INSERT INTO dummy DEFAULT VALUES; +DROP TRIGGER check_grid_transformation_epsg_7001; +DROP TABLE dummy; +UPDATE grid_transformation SET interpolation_crs_auth_name = 'EPSG', + interpolation_crs_code = '4289' + WHERE auth_name = 'EPSG' AND code = '7001'; + -- Define the allowed authorities, and their precedence, when researching a -- coordinate operation diff --git a/data/sql/grid_alternatives.sql b/data/sql/grid_alternatives.sql index df82ddd3..38560202 100644 --- a/data/sql/grid_alternatives.sql +++ b/data/sql/grid_alternatives.sql @@ -798,3 +798,41 @@ INSERT INTO grid_alternatives(original_grid_name, 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); |