diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-01-30 14:14:12 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-01-30 14:14:12 +0100 |
| commit | a1b1c4312e1270b2f5dcb44e2ba2727711cbb80f (patch) | |
| tree | 55e0de5253a0baec10481e16cbfb7b9868f7d89a /data | |
| parent | 91c40b654bb2b07ae79367a683e45c86d29ba0a4 (diff) | |
| download | PROJ-a1b1c4312e1270b2f5dcb44e2ba2727711cbb80f.tar.gz PROJ-a1b1c4312e1270b2f5dcb44e2ba2727711cbb80f.zip | |
Database: add a custom concatenated_operation for NTF (Paris) to RGF93, using the non-deprecated EPSG:9327 for the geocentric translation
Diffstat (limited to 'data')
| -rw-r--r-- | data/sql/commit.sql | 4 | ||||
| -rw-r--r-- | data/sql/customizations.sql | 9 |
2 files changed, 13 insertions, 0 deletions
diff --git a/data/sql/commit.sql b/data/sql/commit.sql index a3028586..943bda78 100644 --- a/data/sql/commit.sql +++ b/data/sql/commit.sql @@ -137,6 +137,10 @@ FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'missing au_ga_AUSGeoid98.tif') WHERE NOT EXISTS(SELECT 1 FROM grid_alternatives WHERE proj_grid_name = 'au_ga_AUSGeoid98.tif'); + -- detect if PROJ:NTF_PARIS_TO_RGF93_GEOCENTRIC_TRANSLATION can be removed + SELECT RAISE(ABORT, 'PROJ:NTF_PARIS_TO_RGF93_GEOCENTRIC_TRANSLATION can probably be removed') + WHERE EXISTS(SELECT 1 FROM concatenated_operation_step WHERE operation_auth_name = 'EPSG' AND step_number = 2 AND step_auth_name = 'EPSG' AND step_code = '9327'); + END; INSERT INTO dummy DEFAULT VALUES; DROP TRIGGER final_checks; diff --git a/data/sql/customizations.sql b/data/sql/customizations.sql index 82328f3c..4067829c 100644 --- a/data/sql/customizations.sql +++ b/data/sql/customizations.sql @@ -135,3 +135,12 @@ INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6312','hermannskogel',' INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6299','ire65','PROJ'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6272','nzgd49','PROJ'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6277','OSGB36','PROJ'); + +---- NTF_PARIS_TO_RGF93_GEOCENTRIC_TRANSLATION ----- + +-- This is a copy of EPSG:7810 (NTF (Paris) to RGF93 (1)) which uses the deprecated EPSG:1053 operation as the second step. +-- We replace it by the non-deprecated EPSG:9327 +-- Issue raised to EPSG +INSERT INTO "concatenated_operation" VALUES('PROJ','NTF_PARIS_TO_RGF93_GEOCENTRIC_TRANSLATION','NTF (Paris) to RGF93 (1)','See transformation code 7811 for an alternative which uses the NTv2 method as an emulation of the geocentric interpolation in the second step.','Approximation to better than 1m of transformation of coordinates referenced to NTF (Paris) to RGF93.','EPSG','4807','EPSG','4171','EPSG','3694',NULL,'',0); +INSERT INTO "concatenated_operation_step" VALUES('PROJ','NTF_PARIS_TO_RGF93_GEOCENTRIC_TRANSLATION',1,'EPSG','1763'); +INSERT INTO "concatenated_operation_step" VALUES('PROJ','NTF_PARIS_TO_RGF93_GEOCENTRIC_TRANSLATION',2,'EPSG','9327'); |