From c3cac01a9779a523ddf553df9c4ca2dc76ba2f95 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Tue, 4 Jan 2022 15:44:53 +0100 Subject: Database: update to EPSG 10.044 --- data/sql/proj_db_table_defs.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'data/sql/proj_db_table_defs.sql') 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( -- cgit v1.2.3