diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-09-28 14:47:09 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2021-09-28 14:47:09 +0200 |
| commit | e6e6e4ca345e774910afa5bbe485c3d9f7851cd4 (patch) | |
| tree | dd1cd3df30565228b932bbfc1d8d97e142111344 /data | |
| parent | f982d9d3104731727c445930bf14008d1c572d0a (diff) | |
| download | PROJ-e6e6e4ca345e774910afa5bbe485c3d9f7851cd4.tar.gz PROJ-e6e6e4ca345e774910afa5bbe485c3d9f7851cd4.zip | |
Add a mapping for versioned authorities, so that one can use IAU:xxxx or IAU_2015:xxxx transparently
Diffstat (limited to 'data')
| -rw-r--r-- | data/sql/customizations_early.sql | 2 | ||||
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 11 |
2 files changed, 12 insertions, 1 deletions
diff --git a/data/sql/customizations_early.sql b/data/sql/customizations_early.sql index fceef235..08c44b37 100644 --- a/data/sql/customizations_early.sql +++ b/data/sql/customizations_early.sql @@ -5,7 +5,7 @@ INSERT INTO "scope" VALUES('PROJ','SCOPE_UNKNOWN','Not known.',0); INSERT INTO celestial_body VALUES('PROJ', 'EARTH', 'Earth', 6378137.0); - +INSERT INTO versioned_auth_name_mapping VALUES ('IAU_2015', 'IAU', '2015', 1); CREATE TRIGGER conversion_method_check_insert_trigger_orthographic INSTEAD OF INSERT ON conversion diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index bf7afca0..20ce940e 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -1515,3 +1515,14 @@ CREATE TABLE authority_to_authority_preference( allowed_authorities TEXT NOT NULL, -- for example 'PROJ,EPSG,any' CONSTRAINT unique_authority_to_authority_preference UNIQUE (source_auth_name, target_auth_name) ); + +-- Map 'IAU_2015' to auth_name=IAU and version=2015 +CREATE TABLE versioned_auth_name_mapping( + versioned_auth_name TEXT NOT NULL PRIMARY KEY, + auth_name TEXT NOT NULL, + version TEXT NOT NULL, + priority INTEGER NOT NULL, + CONSTRAINT unique_auth_name_version UNIQUE (auth_name, version), + CONSTRAINT unique_auth_name_priority UNIQUE (auth_name, priority) +); + |