From f6abb7d75c647013dd83a82361b96c202e615d90 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Thu, 22 Apr 2021 22:51:31 +0200 Subject: Database: update to EPSG v10.019 Non-trivial updates: - some vertical CRS are now encoded as DerivedVerticalCRS. e.g EPSG:8228 "NAVD88 height (ft)", with base EPSG:5703 "NAVD88 height". As we don't have support in our PROJ db model for DerivedVerticalCRS, modify the import script to 'resolve' the derivation up to the original datum. - Method EPSG:1069 'Change of Vertical Unit' is no longer used. It is replaced by a generic-purpose EPSG:1104 method that doesn't take any conversion factor. And generic conversions EPSG:7812 and EPSG:7813 are now used in concatenated operations, which require code changes as well. --- data/sql/concatenated_operation_step.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) (limited to 'data/sql/concatenated_operation_step.sql') diff --git a/data/sql/concatenated_operation_step.sql b/data/sql/concatenated_operation_step.sql index 4f60032a..b3f6c945 100644 --- a/data/sql/concatenated_operation_step.sql +++ b/data/sql/concatenated_operation_step.sql @@ -28,23 +28,23 @@ INSERT INTO "concatenated_operation_step" VALUES('EPSG','6874',1,'EPSG','1265'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','6874',2,'EPSG','6873'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7811',1,'EPSG','1763'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7811',2,'EPSG','15958'); -INSERT INTO "concatenated_operation_step" VALUES('EPSG','7965',1,'EPSG','7963'); +INSERT INTO "concatenated_operation_step" VALUES('EPSG','7965',1,'EPSG','7813'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7965',2,'EPSG','7964'); -INSERT INTO "concatenated_operation_step" VALUES('EPSG','7967',1,'EPSG','7963'); +INSERT INTO "concatenated_operation_step" VALUES('EPSG','7967',1,'EPSG','7813'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7967',2,'EPSG','7966'); -INSERT INTO "concatenated_operation_step" VALUES('EPSG','7973',1,'EPSG','7972'); +INSERT INTO "concatenated_operation_step" VALUES('EPSG','7973',1,'EPSG','7813'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7973',2,'EPSG','7969'); -INSERT INTO "concatenated_operation_step" VALUES('EPSG','7974',1,'EPSG','7972'); +INSERT INTO "concatenated_operation_step" VALUES('EPSG','7974',1,'EPSG','7813'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7974',2,'EPSG','7970'); -INSERT INTO "concatenated_operation_step" VALUES('EPSG','7975',1,'EPSG','7972'); +INSERT INTO "concatenated_operation_step" VALUES('EPSG','7975',1,'EPSG','7813'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7975',2,'EPSG','7971'); -INSERT INTO "concatenated_operation_step" VALUES('EPSG','7983',1,'EPSG','7982'); +INSERT INTO "concatenated_operation_step" VALUES('EPSG','7983',1,'EPSG','7812'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7983',2,'EPSG','7977'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7986',1,'EPSG','7980'); -INSERT INTO "concatenated_operation_step" VALUES('EPSG','7986',2,'EPSG','7984'); +INSERT INTO "concatenated_operation_step" VALUES('EPSG','7986',2,'EPSG','7812'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','7987',1,'EPSG','7980'); -INSERT INTO "concatenated_operation_step" VALUES('EPSG','7987',2,'EPSG','7984'); -INSERT INTO "concatenated_operation_step" VALUES('EPSG','7987',3,'EPSG','7985'); +INSERT INTO "concatenated_operation_step" VALUES('EPSG','7987',2,'EPSG','7812'); +INSERT INTO "concatenated_operation_step" VALUES('EPSG','7987',3,'EPSG','7813'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','8047',1,'EPSG','1147'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','8047',2,'EPSG','1146'); INSERT INTO "concatenated_operation_step" VALUES('EPSG','8094',1,'EPSG','1763'); -- cgit v1.2.3