diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-10-05 19:21:05 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-10-05 19:21:05 +0200 |
| commit | c50ba1b1a7ecde946544c03ab0951727dd87264d (patch) | |
| tree | 2be4d809980ba1450d6e8a2af29c4e9822c9f2d1 /data/sql/proj_db_table_defs.sql | |
| parent | 6b58adb4b7396b9c2aff2fa26aae2340d5a62d21 (diff) | |
| parent | 5d6bdadfca419c1d54d455e240743791e6cea44e (diff) | |
| download | PROJ-c50ba1b1a7ecde946544c03ab0951727dd87264d.tar.gz PROJ-c50ba1b1a7ecde946544c03ab0951727dd87264d.zip | |
Merge pull request #2876 from rouault/iau
Add IAU_2015 CRS definitions
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 14 |
1 files changed, 12 insertions, 2 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index 9155fd8f..20ce940e 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -35,8 +35,6 @@ CREATE TABLE celestial_body ( CONSTRAINT pk_celestial_body PRIMARY KEY (auth_name, code) ) WITHOUT ROWID; -INSERT INTO celestial_body VALUES('PROJ', 'EARTH', 'Earth', 6378137.0); - CREATE TABLE ellipsoid ( auth_name TEXT NOT NULL CHECK (length(auth_name) >= 1), code INTEGER_OR_TEXT NOT NULL CHECK (length(code) >= 1), @@ -541,6 +539,7 @@ BEGIN 'EPSG_9836_Geocentric/topocentric conversions', 'EPSG_9837_Geographic/topocentric conversions', 'EPSG_9838_Vertical Perspective', + 'EPSG_9840_Orthographic', 'EPSG_9841_Mercator (1SP) (Spherical)', 'EPSG_9842_Equidistant Cylindrical', 'EPSG_9843_Axis Order Reversal (2D)', @@ -1516,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) +); + |