diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2020-10-06 17:49:14 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2020-10-08 17:31:56 +0200 |
| commit | fece8a6c6e2e5eebeac6f9b4fc47ca830f2e3a3a (patch) | |
| tree | 22bfeccc0dba39dae899473177ef74e5599cf5e9 /data/sql/commit.sql | |
| parent | e51a7db2bd5322463f8a7d345fb972bfd91ad921 (diff) | |
| download | PROJ-fece8a6c6e2e5eebeac6f9b4fc47ca830f2e3a3a.tar.gz PROJ-fece8a6c6e2e5eebeac6f9b4fc47ca830f2e3a3a.zip | |
Database: add aliases for 'old' names of WGS84 and ETRS89 datums, and remove one hack
Diffstat (limited to 'data/sql/commit.sql')
| -rw-r--r-- | data/sql/commit.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/data/sql/commit.sql b/data/sql/commit.sql index 53c571b6..5e1d69ff 100644 --- a/data/sql/commit.sql +++ b/data/sql/commit.sql @@ -58,6 +58,15 @@ FOR EACH ROW BEGIN d.auth_name = ensemble_auth_name AND d.code = ensemble_code) ); + SELECT RAISE(ABORT, 'PROJ defines an alias that exists in EPSG') + WHERE EXISTS ( + SELECT * FROM ( + SELECT count(*) AS count, table_name, auth_name, code, alt_name FROM alias_name + WHERE source in ('EPSG', 'PROJ') + AND NOT (source = 'PROJ' AND alt_name IN ('GGRS87', 'NAD27', 'NAD83')) + GROUP BY table_name, auth_name, code, alt_name) x WHERE count > 1 + ); + -- test to check that our custom grid transformation overrides are really needed SELECT RAISE(ABORT, 'PROJ grid_transformation defined whereas EPSG has one') WHERE EXISTS (SELECT 1 FROM grid_transformation g1 |