diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2022-01-04 15:44:53 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2022-01-04 22:39:59 +0100 |
| commit | c3cac01a9779a523ddf553df9c4ca2dc76ba2f95 (patch) | |
| tree | cc08a5ba1113d5fe89828dd4fcc5fe016e67f7c1 /data/sql/proj_db_table_defs.sql | |
| parent | cfd005b326864dcb4926db7e75c09a562bdf8f7b (diff) | |
| download | PROJ-c3cac01a9779a523ddf553df9c4ca2dc76ba2f95.tar.gz PROJ-c3cac01a9779a523ddf553df9c4ca2dc76ba2f95.zip | |
Database: update to EPSG 10.044
Diffstat (limited to 'data/sql/proj_db_table_defs.sql')
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index 20ce940e..9c5768e1 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -502,6 +502,7 @@ BEGIN 'EPSG_1069_Change of Vertical Unit', 'EPSG_1104_Change of Vertical Unit', 'EPSG_1078_Equal Earth', + 'EPSG_1111_Transverse Mercator 3D', 'EPSG_9602_Geographic/geocentric conversions', 'EPSG_9659_Geographic3D to 2D conversion', 'EPSG_9801_Lambert Conic Conformal (1SP)', @@ -731,9 +732,9 @@ FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'insert on projected_crs violates constraint: coordinate_system.type must be ''cartesian''') WHERE (SELECT type FROM coordinate_system WHERE coordinate_system.auth_name = NEW.coordinate_system_auth_name AND coordinate_system.code = NEW.coordinate_system_code) != 'Cartesian'; - SELECT RAISE(ABORT, 'insert on projected_crs violates constraint: coordinate_system.dimension must be 2') + SELECT RAISE(ABORT, 'insert on projected_crs violates constraint: coordinate_system.dimension must be 2 or 3') -- EPSG:4461 is topocentric - WHERE NOT(NEW.coordinate_system_auth_name = 'EPSG' AND NEW.coordinate_system_code = '4461') AND (SELECT dimension FROM coordinate_system WHERE coordinate_system.auth_name = NEW.coordinate_system_auth_name AND coordinate_system.code = NEW.coordinate_system_code) != 2; + WHERE NOT(NEW.coordinate_system_auth_name = 'EPSG' AND NEW.coordinate_system_code = '4461') AND (SELECT dimension FROM coordinate_system WHERE coordinate_system.auth_name = NEW.coordinate_system_auth_name AND coordinate_system.code = NEW.coordinate_system_code) NOT IN (2,3); END; CREATE TABLE compound_crs( |