diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-03-30 11:33:59 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-03-30 12:57:03 +0200 |
| commit | da32ee9459cb08df87d5c02a83037158772d1047 (patch) | |
| tree | ceec9020c8e62af775168b62d2b89dd7c75f14e8 /data/sql/commit.sql | |
| parent | 64946ab103d66508bf56bf80417bb5d69876bd25 (diff) | |
| download | PROJ-da32ee9459cb08df87d5c02a83037158772d1047.tar.gz PROJ-da32ee9459cb08df87d5c02a83037158772d1047.zip | |
Database: fix registration of custom entries of grid_transformation_custom.sql for geoid grids (fixes #2112)
Diffstat (limited to 'data/sql/commit.sql')
| -rw-r--r-- | data/sql/commit.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/data/sql/commit.sql b/data/sql/commit.sql index a3028586..d090ccb2 100644 --- a/data/sql/commit.sql +++ b/data/sql/commit.sql @@ -63,19 +63,6 @@ FOR EACH ROW BEGIN (SELECT auth_name || code FROM geodetic_crs WHERE type = 'geographic 2D')); - -- check that grids with HEIGHT_TO_GEOGRAPHIC3D method are properly registered - SELECT RAISE(ABORT, 'One grid_transformation with HEIGHT_TO_GEOGRAPHIC3D has not its source_crs in vertical_crs table') - WHERE EXISTS (SELECT * FROM grid_transformation g WHERE - g.method_code = 'HEIGHT_TO_GEOGRAPHIC3D' AND - g.source_crs_auth_name || g.source_crs_code NOT IN - (SELECT auth_name || code FROM vertical_crs)); - SELECT RAISE(ABORT, 'One grid_transformation with HEIGHT_TO_GEOGRAPHIC3D has not its target_crs in geodetic_crs table with type = ''geographic 3D''') - WHERE EXISTS (SELECT * FROM grid_transformation g WHERE - g.method_code = 'HEIGHT_TO_GEOGRAPHIC3D' AND - g.target_crs_auth_name || g.target_crs_code NOT IN - (SELECT auth_name || code FROM geodetic_crs - WHERE type = 'geographic 3D')); - -- check that grids with Geographic3D to GravityRelatedHeight method are properly registered SELECT RAISE(ABORT, 'One grid_transformation with Geographic3D to GravityRelatedHeight has not its target_crs in vertical_crs table') WHERE EXISTS (SELECT * FROM grid_transformation g WHERE |
