From d72a09d2c39e03e3955983f709420d9bf8ff7098 Mon Sep 17 00:00:00 2001 From: Nyall Dawson Date: Tue, 16 Nov 2021 16:16:10 +1000 Subject: When matching conversions from ESRI db, keep searching if we find a deprecated conversion for a non-deprecated CRS --- data/sql/esri.sql | 24 ++++++++++++------------ 1 file changed, 12 insertions(+), 12 deletions(-) (limited to 'data/sql/esri.sql') diff --git a/data/sql/esri.sql b/data/sql/esri.sql index 3506ce63..6323f7ef 100644 --- a/data/sql/esri.sql +++ b/data/sql/esri.sql @@ -7001,29 +7001,29 @@ INSERT INTO "projected_crs" VALUES('ESRI','21019','GSK-2011_Gauss-Kruger_CM_111E INSERT INTO "usage" VALUES('ESRI', 'PCRS_21019_USAGE','projected_crs','ESRI','21019','EPSG','1778','EPSG','1024'); INSERT INTO "projected_crs" VALUES('ESRI','21020','GSK-2011_Gauss-Kruger_CM_117E',NULL,'EPSG','4400','EPSG','7683','EPSG','16320',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21020_USAGE','projected_crs','ESRI','21020','EPSG','1779','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21021','GSK-2011_Gauss-Kruger_CM_123E',NULL,'EPSG','4400','EPSG','7683','EPSG','16171',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21021','GSK-2011_Gauss-Kruger_CM_123E',NULL,'EPSG','4400','EPSG','7683','EPSG','16321',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21021_USAGE','projected_crs','ESRI','21021','EPSG','1780','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21022','GSK-2011_Gauss-Kruger_CM_129E',NULL,'EPSG','4400','EPSG','7683','EPSG','16173',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21022','GSK-2011_Gauss-Kruger_CM_129E',NULL,'EPSG','4400','EPSG','7683','EPSG','16322',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21022_USAGE','projected_crs','ESRI','21022','EPSG','1781','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21023','GSK-2011_Gauss-Kruger_CM_135E',NULL,'EPSG','4400','EPSG','7683','EPSG','16175',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21023','GSK-2011_Gauss-Kruger_CM_135E',NULL,'EPSG','4400','EPSG','7683','EPSG','16323',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21023_USAGE','projected_crs','ESRI','21023','EPSG','1782','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21024','GSK-2011_Gauss-Kruger_CM_141E',NULL,'EPSG','4400','EPSG','7683','EPSG','16177',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21024','GSK-2011_Gauss-Kruger_CM_141E',NULL,'EPSG','4400','EPSG','7683','EPSG','16324',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21024_USAGE','projected_crs','ESRI','21024','EPSG','1783','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21025','GSK-2011_Gauss-Kruger_CM_147E',NULL,'EPSG','4400','EPSG','7683','EPSG','16179',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21025','GSK-2011_Gauss-Kruger_CM_147E',NULL,'EPSG','4400','EPSG','7683','EPSG','16325',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21025_USAGE','projected_crs','ESRI','21025','EPSG','1784','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21026','GSK-2011_Gauss-Kruger_CM_153E',NULL,'EPSG','4400','EPSG','7683','EPSG','16181',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21026','GSK-2011_Gauss-Kruger_CM_153E',NULL,'EPSG','4400','EPSG','7683','EPSG','16326',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21026_USAGE','projected_crs','ESRI','21026','EPSG','1785','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21027','GSK-2011_Gauss-Kruger_CM_159E',NULL,'EPSG','4400','EPSG','7683','EPSG','16183',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21027','GSK-2011_Gauss-Kruger_CM_159E',NULL,'EPSG','4400','EPSG','7683','EPSG','16327',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21027_USAGE','projected_crs','ESRI','21027','EPSG','1786','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21028','GSK-2011_Gauss-Kruger_CM_165E',NULL,'EPSG','4400','EPSG','7683','EPSG','16185',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21028','GSK-2011_Gauss-Kruger_CM_165E',NULL,'EPSG','4400','EPSG','7683','EPSG','16328',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21028_USAGE','projected_crs','ESRI','21028','EPSG','1787','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21029','GSK-2011_Gauss-Kruger_CM_171E',NULL,'EPSG','4400','EPSG','7683','EPSG','16187',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21029','GSK-2011_Gauss-Kruger_CM_171E',NULL,'EPSG','4400','EPSG','7683','EPSG','16329',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21029_USAGE','projected_crs','ESRI','21029','EPSG','1788','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21030','GSK-2011_Gauss-Kruger_CM_177E',NULL,'EPSG','4400','EPSG','7683','EPSG','16189',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21030','GSK-2011_Gauss-Kruger_CM_177E',NULL,'EPSG','4400','EPSG','7683','EPSG','16330',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21030_USAGE','projected_crs','ESRI','21030','EPSG','1789','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21031','GSK-2011_Gauss-Kruger_CM_177W',NULL,'EPSG','4400','EPSG','7683','EPSG','16191',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21031','GSK-2011_Gauss-Kruger_CM_177W',NULL,'EPSG','4400','EPSG','7683','EPSG','16331',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21031_USAGE','projected_crs','ESRI','21031','EPSG','1790','EPSG','1024'); -INSERT INTO "projected_crs" VALUES('ESRI','21032','GSK-2011_Gauss-Kruger_CM_171W',NULL,'EPSG','4400','EPSG','7683','EPSG','16193',NULL,0); +INSERT INTO "projected_crs" VALUES('ESRI','21032','GSK-2011_Gauss-Kruger_CM_171W',NULL,'EPSG','4400','EPSG','7683','EPSG','16332',NULL,0); INSERT INTO "usage" VALUES('ESRI', 'PCRS_21032_USAGE','projected_crs','ESRI','21032','EPSG','1791','EPSG','1024'); INSERT INTO alias_name VALUES('projected_crs','EPSG','21035','Arc_1960_UTM_Zone_35S','ESRI'); INSERT INTO alias_name VALUES('projected_crs','EPSG','21036','Arc_1960_UTM_Zone_36S','ESRI'); -- cgit v1.2.3