diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-04-01 22:45:23 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2021-04-01 22:45:23 +0200 |
| commit | 17b42f68f3c1a492f72ccfdaa5add50d7573b47d (patch) | |
| tree | 65a80ec9042c463fb88b247c454864d63fba1a76 /data | |
| parent | dbf47894146e9206699dbb76739729482466aa5d (diff) | |
| download | PROJ-17b42f68f3c1a492f72ccfdaa5add50d7573b47d.tar.gz PROJ-17b42f68f3c1a492f72ccfdaa5add50d7573b47d.zip | |
Database: stronger checks on extent of grid_transformation regarding the extent of the source and target CRS
Diffstat (limited to 'data')
| -rw-r--r-- | data/sql/commit.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/data/sql/commit.sql b/data/sql/commit.sql index 53aea887..51533804 100644 --- a/data/sql/commit.sql +++ b/data/sql/commit.sql @@ -139,7 +139,7 @@ FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'The area of use of at least one coordinate_operation does not intersect the one of its source CRS') WHERE EXISTS (SELECT * FROM coordinate_operation_view v, crs_view c, usage vu, extent ve, usage cu, extent ce WHERE v.deprecated = 0 AND - v.auth_name NOT IN ('EPSG', 'ESRI', 'IGNF') AND + (v.table_name = 'grid_transformation' OR v.auth_name NOT IN ('EPSG', 'ESRI', 'IGNF')) AND v.source_crs_auth_name = c.auth_name AND v.source_crs_code = c.code AND vu.object_table_name = v.table_name AND @@ -156,7 +156,8 @@ FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'The area of use of at least one coordinate_operation does not intersect the one of its target CRS') WHERE EXISTS (SELECT * FROM coordinate_operation_view v, crs_view c, usage vu, extent ve, usage cu, extent ce WHERE v.deprecated = 0 AND - v.auth_name NOT IN ('EPSG', 'ESRI', 'IGNF') AND + ((v.table_name = 'grid_transformation' AND NOT (v.auth_name = 'IGNF' AND v.code = 'TSG1185')) + OR v.auth_name NOT IN ('EPSG', 'ESRI', 'IGNF')) AND v.target_crs_auth_name = c.auth_name AND v.target_crs_code = c.code AND vu.object_table_name = v.table_name AND |