diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2018-12-06 13:45:24 +0100 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2018-12-06 13:45:24 +0100 |
| commit | 25fa18055f43d0881a1a2bf9990c99fecfcbdbb7 (patch) | |
| tree | 8643f1f767cfda8becd58f47edae60dd8af11246 | |
| parent | dccf4658ac4cf9194682350ec292a086a2bb24a1 (diff) | |
| download | PROJ-25fa18055f43d0881a1a2bf9990c99fecfcbdbb7.tar.gz PROJ-25fa18055f43d0881a1a2bf9990c99fecfcbdbb7.zip | |
Take into account supersession information to filter out irrelevant transformations
| -rw-r--r-- | data/Makefile.am | 1 | ||||
| -rw-r--r-- | data/sql/esri.sql | 1580 | ||||
| -rw-r--r-- | data/sql/proj_db_table_defs.sql | 30 | ||||
| -rw-r--r-- | data/sql/supersession.sql | 191 | ||||
| -rw-r--r-- | data/sql_filelist.cmake | 1 | ||||
| -rw-r--r-- | include/proj/coordinateoperation.hpp | 4 | ||||
| -rw-r--r-- | include/proj/io.hpp | 4 | ||||
| -rwxr-xr-x | scripts/build_db.py | 28 | ||||
| -rwxr-xr-x | scripts/build_db_from_esri.py | 8 | ||||
| -rw-r--r-- | src/coordinateoperation.cpp | 28 | ||||
| -rw-r--r-- | src/factory.cpp | 179 | ||||
| -rw-r--r-- | src/projinfo.cpp | 17 | ||||
| -rw-r--r-- | test/unit/test_factory.cpp | 53 |
13 files changed, 1267 insertions, 857 deletions
diff --git a/data/Makefile.am b/data/Makefile.am index df635f7e..a85047c6 100644 --- a/data/Makefile.am +++ b/data/Makefile.am @@ -27,6 +27,7 @@ SQL_ORDERED_LIST = sql/begin.sql \ sql/other_transformation.sql \ sql/concatenated_operation.sql \ sql/alias_name.sql \ + sql/supersession.sql \ sql/esri.sql \ sql/ignf.sql \ sql/grid_alternatives.sql \ diff --git a/data/sql/esri.sql b/data/sql/esri.sql index 53fb2c98..41b2b152 100644 --- a/data/sql/esri.sql +++ b/data/sql/esri.sql @@ -1161,10 +1161,10 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4326','GCS_WGS_1984','ESRI' INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4463','GCS_RGSPM_2006','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1038','D_Reseau_Geodesique_de_St_Pierre_et_Miquelon_2006','Reseau Geodesique de St Pierre et Miquelon 2006',NULL,'EPSG','7019','EPSG','8901','EPSG','1220',1); INSERT INTO "geodetic_crs" VALUES('ESRI','4466','GCS_RGSPM_2006',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1038','EPSG','1220',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','4466','EPSG','4463','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','4466','geodetic_crs','EPSG','4463','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1036','D_Reseau_Geodesique_de_Mayotte_2004','Reseau Geodesique de Mayotte 2004',NULL,'EPSG','7019','EPSG','8901','EPSG','1159',1); INSERT INTO "geodetic_crs" VALUES('ESRI','4469','GCS_RGM_2004',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1036','EPSG','1159',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','4469','EPSG','4470','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','4469','geodetic_crs','EPSG','4470','ESRI'); INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4470','GCS_RGM_2004','ESRI'); INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4475','GCS_Cadastre_1997','ESRI'); INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4483','GCS_Mexican_Datum_of_1993','ESRI'); @@ -1409,7 +1409,7 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','8042','Gusterberg(Ferro)',' INSERT INTO alias_name VALUES('geodetic_crs','EPSG','8043','St._Stephen(Ferro)','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6760','D_WGS_1966','WGS 1966',NULL,'ESRI','107001','EPSG','8901','EPSG','1262',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37001','GCS_WGS_1966',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6760','EPSG','1262',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37001','EPSG','4760','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37001','geodetic_crs','EPSG','4760','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106002','D_Fischer_1960','Fischer 1960',NULL,'ESRI','107002','EPSG','8901','EPSG','1262',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37002','GCS_Fischer_1960',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106002','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106003','D_Fischer_1968','Fischer 1968',NULL,'ESRI','107003','EPSG','8901','EPSG','1262',0); @@ -1426,145 +1426,145 @@ INSERT INTO "geodetic_datum" VALUES('ESRI','106008','D_Sphere_ARC_INFO','Authali INSERT INTO "geodetic_crs" VALUES('ESRI','37008','GCS_Sphere_ARC_INFO',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106008','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6668','D_European_1979','European 1979',NULL,'EPSG','7022','EPSG','8901','EPSG','1297',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37201','GCS_European_1979',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6668','EPSG','1297',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37201','EPSG','4668','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37201','geodetic_crs','EPSG','4668','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106202','D_Everest_Bangladesh','Everest - Bangladesh',NULL,'EPSG','7015','EPSG','8901','EPSG','1041',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37202','GCS_Everest_Bangladesh',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106202','EPSG','1041',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106203','D_Everest_India_Nepal','Everest - India and Nepal',NULL,'EPSG','7044','EPSG','8901','EPSG','1121',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37203','GCS_Everest_India_Nepal',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106203','EPSG','1121',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6658','D_Hjorsey_1955','Hjorsey 1955',NULL,'EPSG','7022','EPSG','8901','EPSG','3262',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37204','GCS_Hjorsey_1955',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6658','EPSG','3262',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37204','EPSG','4658','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37204','geodetic_crs','EPSG','4658','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6739','D_Hong_Kong_1963_67','Hong Kong 1963(67)',NULL,'EPSG','7022','EPSG','8901','EPSG','1118',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37205','GCS_Hong_Kong_1963_67',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6739','EPSG','1118',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37205','EPSG','4739','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37205','geodetic_crs','EPSG','4739','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106206','D_Oman','Oman',NULL,'EPSG','7012','EPSG','8901','EPSG','1183',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37206','GCS_Oman',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106206','EPSG','1183',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106207','D_South_Asia_Singapore','South Asia Singapore',NULL,'ESRI','107004','EPSG','8901','EPSG','1210',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37207','GCS_South_Asia_Singapore',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106207','EPSG','1210',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6713','D_Ayabelle','Ayabelle Lighthouse',NULL,'EPSG','7012','EPSG','8901','EPSG','1081',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37208','GCS_Ayabelle',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6713','EPSG','1081',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37208','EPSG','4713','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37208','geodetic_crs','EPSG','4713','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6620','D_Point_58','Point 58',NULL,'EPSG','7012','EPSG','8901','EPSG','2790',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37211','GCS_Point_58',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6620','EPSG','2790',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37211','EPSG','4620','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37211','geodetic_crs','EPSG','4620','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6709','D_Beacon_E_1945','Astro Beacon E 1945 (Iwo Jima 1945)',NULL,'EPSG','7022','EPSG','8901','EPSG','3200',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37212','GCS_Beacon_E_1945',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6709','EPSG','3200',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37212','EPSG','4709','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37212','geodetic_crs','EPSG','4709','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6707','D_Tern_Island_1961','Tern Island Astro 1961',NULL,'EPSG','7022','EPSG','8901','EPSG','3181',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37213','GCS_Tern_Island_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6707','EPSG','3181',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37213','EPSG','4707','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37213','geodetic_crs','EPSG','4707','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6711','D_Astro_1952','Astronomical Station 1952 (Marcus Island 1952 )',NULL,'EPSG','7022','EPSG','8901','EPSG','1872',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37214','GCS_Astro_1952',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6711','EPSG','1872',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37214','EPSG','4711','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37214','geodetic_crs','EPSG','4711','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6714','D_Bellevue_IGN','Bellevue IGN',NULL,'EPSG','7022','EPSG','8901','EPSG','3193',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37215','GCS_Bellevue_IGN',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6714','EPSG','3193',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37215','EPSG','4714','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37215','geodetic_crs','EPSG','4714','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6716','D_Canton_1966','Canton Astro 1966 (Phoenix Islands 1966)',NULL,'EPSG','7022','EPSG','8901','EPSG','3196',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37216','GCS_Canton_1966',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6716','EPSG','3196',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37216','EPSG','4716','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37216','geodetic_crs','EPSG','4716','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6672','D_Chatham_Island_1971','Chatham Island Astro 1971',NULL,'EPSG','7022','EPSG','8901','EPSG','2889',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37217','GCS_Chatham_Island_1971',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6672','EPSG','2889',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37217','EPSG','4672','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37217','geodetic_crs','EPSG','4672','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106218','D_DOS_1968','DOS 1968',NULL,'EPSG','7022','EPSG','8901','EPSG','3198',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37218','GCS_DOS_1968',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106218','EPSG','3198',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6719','D_Easter_Island_1967','Easter Island 1967',NULL,'EPSG','7022','EPSG','8901','EPSG','3188',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37219','GCS_Easter_Island_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6719','EPSG','3188',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37219','EPSG','4719','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37219','geodetic_crs','EPSG','4719','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6675','D_Guam_1963','Guam 1963',NULL,'EPSG','7008','EPSG','8901','EPSG','4167',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37220','GCS_Guam_1963',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6675','EPSG','4167',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37220','EPSG','4675','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37220','geodetic_crs','EPSG','4675','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106221','D_GUX_1','GUX 1 Astro',NULL,'EPSG','7022','EPSG','8901','EPSG','3197',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37221','GCS_GUX_1',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106221','EPSG','3197',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6725','D_Johnston_Island_1961','Johnston Island 1961',NULL,'EPSG','7022','EPSG','8901','EPSG','3201',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37222','GCS_Johnston_Island_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6725','EPSG','3201',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37222','EPSG','4725','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37222','geodetic_crs','EPSG','4725','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','37223','GCS_Carthage',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6223','EPSG','1236',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37223','EPSG','4223','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37223','geodetic_crs','EPSG','4223','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6727','D_Midway_1961','Midway Astro 1961',NULL,'EPSG','7022','EPSG','8901','EPSG','3202',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37224','GCS_Midway_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6727','EPSG','3202',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37224','EPSG','4727','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37224','geodetic_crs','EPSG','4727','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','37225','GCS_Carthage_Grad',NULL,NULL,'geographic 2D','EPSG','6403','EPSG','6223','EPSG','1236',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6729','D_Pitcairn_1967','Pitcairn Astro 1967',NULL,'EPSG','7022','EPSG','8901','EPSG','3208',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37226','GCS_Pitcairn_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6729','EPSG','3208',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37226','EPSG','4729','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37226','geodetic_crs','EPSG','4729','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6730','D_Santo_DOS_1965','Santo DOS 1965',NULL,'EPSG','7022','EPSG','8901','EPSG','3194',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37227','GCS_Santo_DOS_1965',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6730','EPSG','3194',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37227','EPSG','4730','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37227','geodetic_crs','EPSG','4730','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6731','D_Viti_Levu_1916','Viti Levu 1916',NULL,'EPSG','7012','EPSG','8901','EPSG','3195',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37228','GCS_Viti_Levu_1916',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6731','EPSG','3195',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37228','EPSG','4731','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37228','geodetic_crs','EPSG','4731','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6732','D_Wake_Eniwetok_1960','Wake-Eniwetok 1960 (Marshall Islands 1960)',NULL,'ESRI','7053','EPSG','8901','EPSG','3191',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37229','GCS_Wake_Eniwetok_1960',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6732','EPSG','3191',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37229','EPSG','4732','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37229','geodetic_crs','EPSG','4732','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6733','D_Wake_Island_1952','Wake Island Astro 1952',NULL,'EPSG','7022','EPSG','8901','EPSG','3190',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37230','GCS_Wake_Island_1952',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6733','EPSG','3190',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37230','EPSG','4733','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37230','geodetic_crs','EPSG','4733','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6708','D_Anna_1_1965','Anna 1 Astro 1965 (Cocos Islands 1965)',NULL,'EPSG','7003','EPSG','8901','EPSG','1069',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37231','GCS_Anna_1_1965',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6708','EPSG','1069',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37231','EPSG','4708','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37231','geodetic_crs','EPSG','4708','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6684','D_Gan_1970','Gan 1970',NULL,'EPSG','7022','EPSG','8901','EPSG','3274',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37232','GCS_Gan_1970',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6684','EPSG','3274',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37232','EPSG','4684','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37232','geodetic_crs','EPSG','4684','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6724','D_ISTS_073_1969','ISTS 073 Astro 1969 (Diego Garcia 1969)',NULL,'EPSG','7022','EPSG','8901','EPSG','3189',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37233','GCS_ISTS_073_1969',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6724','EPSG','3189',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37233','EPSG','4724','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37233','geodetic_crs','EPSG','4724','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6698','D_Kerguelen_Island_1949','Kerguelen Island 1949',NULL,'EPSG','7022','EPSG','8901','EPSG','2816',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37234','GCS_Kerguelen_Island_1949',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6698','EPSG','2816',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37234','EPSG','4698','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37234','geodetic_crs','EPSG','4698','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6626','D_Reunion_1947','Reunion 1947',NULL,'EPSG','7022','EPSG','8901','EPSG','3337',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37235','GCS_Reunion_1947',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6626','EPSG','3337',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37235','EPSG','4626','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37235','geodetic_crs','EPSG','4626','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6712','D_Ascension_Island_1958','Ascension Island 1958',NULL,'EPSG','7022','EPSG','8901','EPSG','3182',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37237','GCS_Ascension_Island_1958',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6712','EPSG','3182',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37237','EPSG','4712','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37237','geodetic_crs','EPSG','4712','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6710','D_DOS_71_4','Astro DOS 71/4 (St. Helena 1971)',NULL,'EPSG','7022','EPSG','8901','EPSG','3183',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37238','GCS_DOS_71_4',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6710','EPSG','3183',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37238','EPSG','4710','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37238','geodetic_crs','EPSG','4710','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6717','D_Cape_Canaveral','Cape Canaveral',NULL,'EPSG','7008','EPSG','8901','EPSG','3206',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37239','GCS_Cape_Canaveral',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6717','EPSG','3206',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37239','EPSG','4717','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37239','geodetic_crs','EPSG','4717','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106240','D_Fort_Thomas_1955','Fort Thomas 1955',NULL,'EPSG','7012','EPSG','8901','EPSG','1200',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37240','GCS_Fort_Thomas_1955',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106240','EPSG','1200',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106241','D_Graciosa_Base_SW_1948','Graciosa Base SW 1948',NULL,'EPSG','7022','EPSG','8901','EPSG','1301',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37241','GCS_Graciosa_Base_SW_1948',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106241','EPSG','1301',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6722','D_ISTS_061_1968','ISTS 061 Astro 1968 (South Georgia 1968)',NULL,'EPSG','7022','EPSG','8901','EPSG','3529',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37242','GCS_ISTS_061_1968',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6722','EPSG','3529',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37242','EPSG','4722','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37242','geodetic_crs','EPSG','4722','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106243','D_LC5_1961','L.C. 5 Astro 1961',NULL,'EPSG','7008','EPSG','8901','EPSG','3207',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37243','GCS_LC5_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106243','EPSG','3207',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106245','D_Observatorio_Meteorologico_1939','Observ. Meteorologico 1939',NULL,'EPSG','7022','EPSG','8901','EPSG','1344',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37245','GCS_Observatorio_Meteorologico_1939',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106245','EPSG','1344',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6728','D_Pico_de_Las_Nieves','Pico de Las Nieves',NULL,'EPSG','7022','EPSG','8901','EPSG','3873',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37246','GCS_Pico_de_Las_Nieves',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6728','EPSG','3873',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37246','EPSG','4728','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37246','geodetic_crs','EPSG','4728','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6615','D_Porto_Santo_1936','Porto Santo 1936',NULL,'EPSG','7022','EPSG','8901','EPSG','1314',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37247','GCS_Porto_Santo_1936',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6615','EPSG','1314',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37247','EPSG','4615','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37247','geodetic_crs','EPSG','4615','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106249','D_Sao_Braz','Sao Braz',NULL,'EPSG','7022','EPSG','8901','EPSG','1345',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37249','GCS_Sao_Braz',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106249','EPSG','1345',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6616','D_Selvagem_Grande_1938','Selvagem Grande 1938',NULL,'EPSG','7022','EPSG','8901','EPSG','2779',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37250','GCS_Selvagem_Grande_1938',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6616','EPSG','2779',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37250','EPSG','4616','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37250','geodetic_crs','EPSG','4616','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6734','D_Tristan_1968','Tristan Astro 1968',NULL,'EPSG','7022','EPSG','8901','EPSG','3184',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37251','GCS_Tristan_1968',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6734','EPSG','3184',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37251','EPSG','4734','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37251','geodetic_crs','EPSG','4734','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6169','D_American_Samoa_1962','American Samoa 1962',NULL,'EPSG','7008','EPSG','8901','EPSG','3109',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37252','GCS_American_Samoa_1962',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6169','EPSG','3109',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37252','EPSG','4169','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37252','geodetic_crs','EPSG','4169','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6715','D_Camp_Area','Camp Area Astro',NULL,'EPSG','7022','EPSG','8901','EPSG','3205',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37253','GCS_Camp_Area',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6715','EPSG','3205',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37253','EPSG','4715','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37253','geodetic_crs','EPSG','4715','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6736','D_Deception_Island','Deception Island',NULL,'EPSG','7012','EPSG','8901','EPSG','3204',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37254','GCS_Deception_Island',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6736','EPSG','3204',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37254','EPSG','4736','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37254','geodetic_crs','EPSG','4736','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6613','D_Gunung_Segara','Gunung Segara',NULL,'EPSG','7004','EPSG','8901','EPSG','1360',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37255','GCS_Gunung_Segara',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6613','EPSG','1360',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37255','EPSG','4613','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37255','geodetic_crs','EPSG','4613','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106257','D_S42_Hungary','S-42 Hungary',NULL,'EPSG','7024','EPSG','8901','EPSG','1119',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37257','GCS_S42_Hungary',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106257','EPSG','1119',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6735','D_Kusaie_1951','Kusaie Astro 1951',NULL,'EPSG','7022','EPSG','8901','EPSG','3192',1); INSERT INTO "geodetic_crs" VALUES('ESRI','37259','GCS_Kusaie_1951',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6735','EPSG','3192',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','37259','EPSG','4735','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37259','geodetic_crs','EPSG','4735','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106260','D_Alaskan_Islands','Alaskan Islands',NULL,'EPSG','7008','EPSG','8901','EPSG','1330',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37260','GCS_Alaskan_Islands',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106260','EPSG','1330',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104000','GCS_Assumed_Geographic_1',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6267','EPSG','1263',NULL,1); @@ -1582,7 +1582,7 @@ INSERT INTO "geodetic_crs" VALUES('ESRI','104018','PZ-90.11',NULL,NULL,'geograph INSERT INTO "geodetic_crs" VALUES('ESRI','104019','ITRF2014',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1165','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','1128','D_JGD_2011','Japan Geodetic Datum 2011',NULL,'EPSG','7019','EPSG','8901','EPSG','1129',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104020','GCS_JGD_2011',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1128','EPSG','1129',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104020','EPSG','6668','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104020','geodetic_crs','EPSG','6668','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104021','IGS14',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1191','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6023','D_International_1967','International 1967',NULL,'ESRI','7023','EPSG','8901','EPSG','1263',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104023','GCS_International_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6023','EPSG','1263',NULL,1); @@ -1593,7 +1593,7 @@ INSERT INTO "geodetic_datum" VALUES('ESRI','106050','D_Xrail84','Xrail84',NULL,' INSERT INTO "geodetic_crs" VALUES('ESRI','104050','GCS_Xrail84',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106050','ESRI','1',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','1056','D_GDBD2009','GDBD2009',NULL,'EPSG','7019','EPSG','8901','EPSG','1055',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104100','GCS_GDBD2009',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1056','EPSG','1055',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104100','EPSG','5246','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104100','geodetic_crs','EPSG','5246','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106101','D_Estonia_1937','Estonia 1937',NULL,'EPSG','7004','EPSG','8901','EPSG','1090',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104101','GCS_Estonia_1937',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106101','EPSG','1090',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106102','D_Hermannskogel','Hermannskogel',NULL,'EPSG','7004','EPSG','8901','EPSG','1321',0); @@ -1602,32 +1602,32 @@ INSERT INTO "geodetic_datum" VALUES('ESRI','106103','D_Sierra_Leone_1960','Sierr INSERT INTO "geodetic_crs" VALUES('ESRI','104103','GCS_Sierra_Leone_1960',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106103','EPSG','1209',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6611','D_Hong_Kong_1980','Hong Kong 1980',NULL,'EPSG','7022','EPSG','8901','EPSG','1118',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104104','GCS_Hong_Kong_1980',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6611','EPSG','1118',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104104','EPSG','4611','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104104','geodetic_crs','EPSG','4611','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106262','D_Datum_Lisboa_Bessel','Datum Lisboa Bessel',NULL,'EPSG','7004','EPSG','8901','EPSG','1193',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104105','GCS_Datum_Lisboa_Bessel',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106262','EPSG','1193',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106263','D_Datum_Lisboa_Hayford','Datum Lisboa Hayford',NULL,'EPSG','7022','EPSG','8901','EPSG','1193',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104106','GCS_Datum_Lisboa_Hayford',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106263','EPSG','1193',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6171','D_RGF_1993','Reseau Geodesique Francais 1993',NULL,'EPSG','7019','EPSG','8901','EPSG','1096',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104107','GCS_RGF_1993',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6171','EPSG','1096',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104107','EPSG','4171','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104107','geodetic_crs','EPSG','4171','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6167','D_NZGD_2000','New Zealand Geodetic Datum 2000',NULL,'EPSG','7019','EPSG','8901','EPSG','1175',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104108','GCS_NZGD_2000',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6167','EPSG','1175',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104108','EPSG','4167','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104108','geodetic_crs','EPSG','4167','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106266','D_Pohnpei','Pohnpei - Fed. States Micronesia',NULL,'EPSG','7008','EPSG','8901','EPSG','1161',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104109','GCS_Pohnpei',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106266','EPSG','1161',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6189','D_REGVEN','REGVEN',NULL,'EPSG','7019','EPSG','8901','EPSG','1251',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104110','GCS_REGVEN',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6189','EPSG','1251',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104110','EPSG','4189','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104110','geodetic_crs','EPSG','4189','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6612','D_JGD_2000','Japan Geodetic Datum 2000',NULL,'EPSG','7019','EPSG','8901','EPSG','1129',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104111','GCS_JGD_2000',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6612','EPSG','1129',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104111','EPSG','4612','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104111','geodetic_crs','EPSG','4612','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106269','D_Bab_South','Bab South Astro - Bablethuap Is - Republic of Palau',NULL,'EPSG','7008','EPSG','8901','EPSG','1185',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104112','GCS_Bab_South',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106269','EPSG','1185',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106270','D_Majuro','Majuro - Republic of Marshall Is.',NULL,'EPSG','7008','EPSG','8901','EPSG','1155',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104113','GCS_Majuro',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106270','EPSG','1155',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6762','D_Bermuda_2000','Bermuda 2000',NULL,'EPSG','7030','EPSG','8901','EPSG','1047',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104114','GCS_Bermuda_2000',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6762','EPSG','1047',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104114','EPSG','4762','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104114','geodetic_crs','EPSG','4762','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104115','GCS_ITRF_1988',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6647','EPSG','1262',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104116','GCS_ITRF_1989',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6648','EPSG','1262',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104117','GCS_ITRF_1990',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6649','EPSG','1262',NULL,0); @@ -1640,7 +1640,7 @@ INSERT INTO "geodetic_crs" VALUES('ESRI','104123','GCS_ITRF_1997',NULL,NULL,'geo INSERT INTO "geodetic_crs" VALUES('ESRI','104124','GCS_ITRF_2000',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6656','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6673','D_Chatham_Islands_1979','Chatham Islands 1979',NULL,'EPSG','7022','EPSG','8901','EPSG','2889',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104125','GCS_Chatham_Islands_1979',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6673','EPSG','2889',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104125','EPSG','4673','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104125','geodetic_crs','EPSG','4673','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106274','D_Observatorio_Meteorologico_1965','Observatorio Meteorologico 1965',NULL,'EPSG','7022','EPSG','8901','EPSG','1147',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104126','GCS_Observatorio_Meteorologico_1965',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106274','EPSG','1147',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106275','D_Roma_1940','Roma 1940',NULL,'EPSG','7022','EPSG','8901','EPSG','3343',0); @@ -1654,37 +1654,37 @@ INSERT INTO "geodetic_datum" VALUES('ESRI','106278','D_D48','D48 - Slovenia',NUL INSERT INTO "geodetic_crs" VALUES('ESRI','104131','GCS_D48',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106278','EPSG','1212',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','1070','D_Ocotepeque_1935','Ocotepeque 1935',NULL,'EPSG','7008','EPSG','8901','EPSG','3876',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104132','GCS_Ocotepeque_1935',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1070','EPSG','3876',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104132','EPSG','5451','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104132','geodetic_crs','EPSG','5451','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','6758','D_Jamaica_2001','Jamaica 2001',NULL,'EPSG','7030','EPSG','8901','EPSG','1128',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104133','GCS_JAD_2001',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6758','EPSG','1128',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104133','EPSG','4758','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104133','geodetic_crs','EPSG','4758','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104134','GCS_MONREF_1997',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6656','EPSG','1164',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104135','GCS_MSK_1942',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6284','EPSG','1164',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','1025','D_TWD_1967','Taiwan 1967',NULL,'ESRI','7050','EPSG','8901','EPSG','3315',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104136','GCS_TWD_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1025','EPSG','3315',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104136','EPSG','3821','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104136','geodetic_crs','EPSG','3821','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1026','D_TWD_1997','Taiwan 1997',NULL,'EPSG','7019','EPSG','8901','EPSG','1228',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104137','GCS_TWD_1997',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1026','EPSG','1228',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104137','EPSG','3824','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104137','geodetic_crs','EPSG','3824','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106284','D_Old_Hawaiian_Intl_1924','Old Hawaiian on Intl_1924 spheroid (NGS)',NULL,'EPSG','7022','EPSG','8901','EPSG','1334',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104138','GCS_Old_Hawaiian_Intl_1924',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106284','EPSG','1334',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104139','GCS_Voirol_1875_Grad',NULL,NULL,'geographic 2D','EPSG','6403','EPSG','6304','EPSG','1365',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104140','GCS_Voirol_1879_Grad',NULL,NULL,'geographic 2D','EPSG','6403','EPSG','6671','EPSG','1365',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','1112','D_Cyprus_Geodetic_Reference_System_1993','Cyprus GRS 1993',NULL,'EPSG','7030','EPSG','8901','EPSG','3236',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104141','GCS_CGRS_1993',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1112','EPSG','3236',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104141','EPSG','6311','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104141','geodetic_crs','EPSG','6311','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1041','D_PTRA08','Portugal - Autonomous Regions (Madeira and Azores Archipelagos)',NULL,'EPSG','7019','EPSG','8901','EPSG','3670',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104142','GCS_PTRA08',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1041','EPSG','3670',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104142','EPSG','5013','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104142','geodetic_crs','EPSG','5013','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1065','D_Costa_Rica_2005','Costa Rica 2005',NULL,'EPSG','7030','EPSG','8901','EPSG','1074',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104143','GCS_CR05',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1065','EPSG','1074',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104143','EPSG','5365','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104143','geodetic_crs','EPSG','5365','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1060','D_Islands_Network_2004','Islands Network 2004',NULL,'EPSG','7019','EPSG','8901','EPSG','1120',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104144','GCS_ISN_2004',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1060','EPSG','1120',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104144','EPSG','5324','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104144','geodetic_crs','EPSG','5324','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1116','D_NAD_1983_2011','NAD 1983 (2011)',NULL,'EPSG','7019','EPSG','8901','EPSG','1511',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104145','GCS_NAD_1983_2011',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1116','EPSG','1511',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104145','EPSG','6318','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104145','geodetic_crs','EPSG','6318','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104179','ETRF90',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1179','EPSG','1298',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104180','ETRF91',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1180','EPSG','1298',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104181','ETRF92',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1181','EPSG','1298',NULL,0); @@ -1695,15 +1695,15 @@ INSERT INTO "geodetic_crs" VALUES('ESRI','104185','ETRF97',NULL,NULL,'geographic INSERT INTO "geodetic_crs" VALUES('ESRI','104186','ETRF2000',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1186','EPSG','1298',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6055','D_WGS_1984_Major_Auxiliary_Sphere','Major auxiliary sphere based on WGS 1984',NULL,'ESRI','7059','EPSG','8901','EPSG','1262',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104199','GCS_WGS_1984_Major_Auxiliary_Sphere',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6055','EPSG','1262',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104199','EPSG','4055','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104199','geodetic_crs','EPSG','4055','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1133','D_NAD_1983_CORS96','NAD 1983 (CORS96)',NULL,'EPSG','7019','EPSG','8901','EPSG','1511',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104223','GCS_NAD_1983_CORS96',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1133','EPSG','1511',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104223','EPSG','6783','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104223','geodetic_crs','EPSG','6783','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106248','D_MACAO_2008','Macao 2008 (ITRF 2005)',NULL,'EPSG','7022','EPSG','8901','EPSG','1147',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104248','GCS_MACAO_2008',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106248','EPSG','1147',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','1111','D_Nepal_Nagarkot','Nepal Nagarkot',NULL,'EPSG','7015','EPSG','8901','EPSG','1171',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104256','GCS_Nepal_Nagarkot',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1111','EPSG','1171',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104256','EPSG','6207','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104256','geodetic_crs','EPSG','6207','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104257','GCS_ITRF_2008',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1061','EPSG','2830',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','1178','D_ETRF_1989','European Terrestrial Ref. Frame 1989',NULL,'EPSG','7030','EPSG','8901','EPSG','1298',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104258','GCS_ETRF_1989',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1178','EPSG','1298',NULL,0); @@ -1714,12 +1714,12 @@ INSERT INTO "geodetic_crs" VALUES('ESRI','104260','GCS_NAD_1983_MARP00',NULL,NUL INSERT INTO "geodetic_crs" VALUES('ESRI','104261','GCS_Merchich_Degree',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6261','EPSG','3280',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','1118','D_NAD_1983_MA11','NAD 1983 (MA11) - Marianas Plate 2011',NULL,'EPSG','7019','EPSG','8901','EPSG','4167',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104286','GCS_NAD_1983_MA11',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1118','EPSG','4167',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104286','EPSG','6325','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104286','geodetic_crs','EPSG','6325','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1117','D_NAD_1983_PA11','NAD 1983 (PA11) - Pacific Plate 2011',NULL,'EPSG','7019','EPSG','8901','EPSG','4162',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104287','GCS_NAD_1983_PA11',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1117','EPSG','4162',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104287','EPSG','6322','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104287','geodetic_crs','EPSG','6322','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104304','GCS_Voirol_1875',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6304','EPSG','1365',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104304','EPSG','4304','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104304','geodetic_crs','EPSG','4304','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104305','GCS_Voirol_Unifie_1960_Degree',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6305','EPSG','2784',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106700','D_NAD_1983_HARN_Adj_MN_Anoka','NAD 1983 HARN Adj. Minnesota Anoka',NULL,'ESRI','107700','EPSG','8901','EPSG','1392',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104700','GCS_NAD_1983_HARN_Adj_MN_Anoka',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106700','EPSG','1392',NULL,0); @@ -2179,13 +2179,13 @@ INSERT INTO "geodetic_datum" VALUES('ESRI','106974','Mercury_2015','Mercury 2015 INSERT INTO "geodetic_crs" VALUES('ESRI','104974','Mercury_2015',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106974','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','1024','D_Hungarian_Datum_1909','Hungarian Datum 1909',NULL,'EPSG','7004','EPSG','8901','EPSG','1119',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104990','GCS_HD1909',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1024','EPSG','1119',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104990','EPSG','3819','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104990','geodetic_crs','EPSG','3819','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1029','D_Iraqi_Geospatial_Reference_System','Iraqi Geospatial Reference System',NULL,'EPSG','7019','EPSG','8901','EPSG','1124',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104991','GCS_IGRS',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1029','EPSG','1124',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104991','EPSG','3889','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104991','geodetic_crs','EPSG','3889','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','1031','D_MGI_1901','MGI 1901',NULL,'EPSG','7004','EPSG','8901','EPSG','2370',1); INSERT INTO "geodetic_crs" VALUES('ESRI','104992','GCS_MGI_1901',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1031','EPSG','2370',NULL,1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','104992','EPSG','3906','ESRI'); +INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104992','geodetic_crs','EPSG','3906','ESRI'); INSERT INTO alias_name VALUES('projected_crs','EPSG','2000','Anguilla_1957_British_West_Indies_Grid','ESRI'); INSERT INTO alias_name VALUES('projected_crs','EPSG','2001','Antigua_1943_British_West_Indies_Grid','ESRI'); INSERT INTO alias_name VALUES('projected_crs','EPSG','2002','Dominica_1945_British_West_Indies_Grid','ESRI'); @@ -8758,719 +8758,719 @@ INSERT INTO "projected_crs" VALUES('ESRI','103968','NAD_1983_HARN_Adj_WI_Walwort INSERT INTO "projected_crs" VALUES('ESRI','103969','NAD_1983_HARN_Adj_WI_Washburn_Feet',NULL,NULL,NULL,NULL,'ESRI','104865',NULL,NULL,'EPSG','1418','PROJCS["NAD_1983_HARN_Adj_WI_Washburn_Feet",GEOGCS["GCS_NAD_1983_HARN_Adj_WI_Washburn",DATUM["D_NAD_1983_HARN_Adj_WI_WB",SPHEROID["GRS_1980_Adj_WI_WB",6378474.591,298.273008677695]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",768000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-91.78333333333333],PARAMETER["Standard_Parallel_1",45.77222222222222],PARAMETER["Standard_Parallel_2",46.15],PARAMETER["Latitude_Of_Origin",44.26666666666667],UNIT["Foot_US",0.3048006096012192]]',1); INSERT INTO "projected_crs" VALUES('ESRI','103970','NAD_1983_HARN_Adj_WI_Waushara_Feet',NULL,NULL,NULL,NULL,'ESRI','104869',NULL,NULL,'EPSG','1418','PROJCS["NAD_1983_HARN_Adj_WI_Waushara_Feet",GEOGCS["GCS_NAD_1983_HARN_Adj_WI_Waushara",DATUM["D_NAD_1983_HARN_Adj_WI_WS",SPHEROID["GRS_1980_Adj_WI_WS",6378405.971,298.269799839349]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",394000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-89.24166666666667],PARAMETER["Standard_Parallel_1",43.975],PARAMETER["Standard_Parallel_2",44.25277777777778],PARAMETER["Latitude_Of_Origin",43.70833333333334],UNIT["Foot_US",0.3048006096012192]]',1); INSERT INTO "projected_crs" VALUES('ESRI','103971','NAD_1983_HARN_Adj_WI_Wood_Feet',NULL,NULL,NULL,NULL,'ESRI','104871',NULL,NULL,'EPSG','1418','PROJCS["NAD_1983_HARN_Adj_WI_Wood_Feet",GEOGCS["GCS_NAD_1983_HARN_Adj_WI_Wood",DATUM["D_NAD_1983_HARN_Adj_WI_WD",SPHEROID["GRS_1980_Adj_WI_WD",6378437.651,298.271281273316]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",684000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-90.0],PARAMETER["Standard_Parallel_1",44.18055555555555],PARAMETER["Standard_Parallel_2",44.54444444444444],PARAMETER["Latitude_Of_Origin",43.15138888888889],UNIT["Foot_US",0.3048006096012192]]',1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102340','EPSG','2847','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102341','EPSG','2848','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102342','EPSG','2849','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102343','EPSG','2850','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102344','EPSG','2851','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102345','EPSG','2852','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102346','EPSG','2853','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102347','EPSG','2854','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102348','EPSG','2855','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102349','EPSG','2856','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102065','EPSG','5513','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102067','EPSG','5514','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102066','EPSG','5221','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102744','EPSG','3567','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102745','EPSG','5646','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102746','EPSG','2283','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102747','EPSG','2284','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102740','EPSG','2278','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102741','EPSG','2279','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102742','EPSG','3560','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102743','EPSG','3566','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102748','EPSG','2285','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102724','EPSG','2267','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102986','EPSG','6403','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102987','EPSG','6406','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102984','EPSG','6401','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102725','EPSG','2268','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102982','EPSG','6399','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102983','EPSG','6400','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102669','EPSG','2242','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102668','EPSG','2241','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102667','EPSG','2240','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102050','EPSG','6332','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102663','EPSG','3759','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102988','EPSG','6404','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102660','EPSG','2238','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102111','EPSG','5519','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102110','EPSG','2154','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102113','EPSG','3785','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102112','EPSG','3764','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102119','EPSG','3080','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102966','EPSG','6393','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102788','EPSG','6251','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103214','EPSG','4082','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','31917','EPSG','31986','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','31919','EPSG','31988','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','31918','EPSG','31987','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102059','EPSG','6341','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102989','EPSG','6408','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102188','EPSG','3777','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102189','EPSG','3801','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102186','EPSG','3775','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102187','EPSG','3776','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102184','EPSG','3400','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102185','EPSG','3401','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102182','EPSG','3773','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102183','EPSG','3800','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102180','EPSG','3771','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102181','EPSG','3772','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103165','EPSG','6621','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103164','EPSG','6619','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103048','EPSG','6468','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103049','EPSG','6467','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103161','EPSG','6588','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103160','EPSG','6578','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103044','EPSG','6464','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103045','EPSG','6463','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103046','EPSG','6465','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103047','EPSG','6466','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103040','EPSG','6460','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103041','EPSG','6459','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103042','EPSG','6461','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103043','EPSG','6462','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102304','EPSG','2819','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103163','EPSG','6620','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102657','EPSG','2235','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102307','EPSG','2820','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102300','EPSG','2818','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103162','EPSG','6586','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102718','EPSG','2263','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103082','EPSG','6504','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103148','EPSG','6573','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102444','EPSG','3825','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102443','EPSG','3826','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102442','EPSG','3827','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102441','EPSG','3828','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102524','EPSG','6632','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102713','EPSG','2258','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102527','EPSG','6633','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102520','EPSG','6628','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102521','EPSG','6629','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102522','EPSG','6630','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102523','EPSG','6631','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103198','EPSG','6618','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103111','EPSG','6529','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102711','EPSG','3424','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103192','EPSG','6611','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103193','EPSG','6613','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103190','EPSG','6605','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102710','EPSG','3437','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103196','EPSG','6612','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103197','EPSG','6614','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103194','EPSG','6617','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102768','EPSG','6257','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102749','EPSG','2286','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102769','EPSG','6244','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102623','EPSG','6682','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102622','EPSG','6681','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102621','EPSG','6680','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102620','EPSG','6679','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102627','EPSG','6686','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102626','EPSG','6685','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102625','EPSG','6684','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102624','EPSG','6683','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102780','EPSG','6260','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102781','EPSG','6254','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102782','EPSG','6269','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102628','EPSG','6687','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102784','EPSG','6267','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102785','EPSG','6270','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102786','EPSG','6274','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102607','EPSG','3463','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102985','EPSG','6402','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102230','EPSG','2760','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102234','EPSG','3158','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102235','EPSG','3159','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102236','EPSG','3160','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102980','EPSG','6397','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102151','EPSG','3092','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102153','EPSG','3094','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102152','EPSG','3093','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102155','EPSG','3096','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102154','EPSG','3095','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102666','EPSG','2239','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103087','EPSG','6509','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103025','EPSG','6444','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102656','EPSG','2234','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102305','EPSG','5367','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102654','EPSG','2232','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102655','EPSG','2233','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102652','EPSG','3434','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102653','EPSG','2231','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102719','EPSG','2264','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102651','EPSG','3433','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102717','EPSG','2262','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102716','EPSG','2261','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102715','EPSG','2260','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102714','EPSG','2259','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102308','EPSG','2821','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102309','EPSG','2822','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102658','EPSG','2236','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102659','EPSG','2237','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103129','EPSG','6549','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103128','EPSG','6550','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103122','EPSG','6543','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103123','EPSG','6544','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102783','EPSG','6261','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103121','EPSG','6542','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103120','EPSG','6539','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103127','EPSG','6548','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103126','EPSG','6547','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103125','EPSG','6545','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103124','EPSG','6546','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103169','EPSG','6626','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103017','EPSG','6435','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103016','EPSG','6434','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102979','EPSG','6396','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102978','EPSG','6395','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103013','EPSG','6428','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103012','EPSG','6430','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103011','EPSG','6431','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103010','EPSG','6427','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102973','EPSG','6610','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102972','EPSG','6580','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102971','EPSG','6579','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102970','EPSG','6557','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102977','EPSG','6394','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102976','EPSG','6356','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102975','EPSG','6355','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103018','EPSG','6436','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103212','EPSG','4063','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102500','EPSG','6785','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103158','EPSG','6582','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103159','EPSG','6584','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103156','EPSG','6587','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103157','EPSG','6585','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103154','EPSG','6583','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103155','EPSG','6577','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103152','EPSG','6576','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103153','EPSG','6581','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103150','EPSG','6574','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103151','EPSG','6575','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103217','EPSG','4094','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103216','EPSG','4093','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102259','EPSG','2778','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103080','EPSG','6502','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102278','EPSG','2797','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102279','EPSG','2798','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103081','EPSG','6500','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102274','EPSG','2793','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102275','EPSG','2794','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102276','EPSG','2795','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102277','EPSG','2796','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102270','EPSG','2789','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102271','EPSG','2790','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102272','EPSG','2791','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102273','EPSG','2792','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103083','EPSG','6503','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103070','EPSG','6491','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103084','EPSG','6501','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103202','EPSG','4049','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102296','EPSG','2815','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102297','EPSG','2816','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102294','EPSG','2813','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102295','EPSG','2814','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102292','EPSG','2811','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102293','EPSG','2812','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102290','EPSG','2809','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102358','EPSG','2865','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','65163','EPSG','3088','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102356','EPSG','2863','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102355','EPSG','2862','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102354','EPSG','2861','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102353','EPSG','2860','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102352','EPSG','2859','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102298','EPSG','2817','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102350','EPSG','2857','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102268','EPSG','2787','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103089','EPSG','6510','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102753','EPSG','2288','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102752','EPSG','2287','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102751','EPSG','26854','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102750','EPSG','26853','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102757','EPSG','3738','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102756','EPSG','3737','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102755','EPSG','3736','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102754','EPSG','2289','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102758','EPSG','3739','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102995','EPSG','6411','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102994','EPSG','6412','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102618','EPSG','6677','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102619','EPSG','6678','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102991','EPSG','6405','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102990','EPSG','6407','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102993','EPSG','6410','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102992','EPSG','6409','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102612','EPSG','6671','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102613','EPSG','6672','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102610','EPSG','6669','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102611','EPSG','6670','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102616','EPSG','6675','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102617','EPSG','6676','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102614','EPSG','6673','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102615','EPSG','6674','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102260','EPSG','2779','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102124','EPSG','26701','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102125','EPSG','26702','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102126','EPSG','3370','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102127','EPSG','3371','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102128','EPSG','26901','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102129','EPSG','26902','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103201','EPSG','4048','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102054','EPSG','6336','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102055','EPSG','6337','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102056','EPSG','6338','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102057','EPSG','6339','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102199','EPSG','3812','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102051','EPSG','6333','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102052','EPSG','6334','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102053','EPSG','6335','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102058','EPSG','6340','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102190','EPSG','3005','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102728','EPSG','2271','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102729','EPSG','2272','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102357','EPSG','2864','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103112','EPSG','6533','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103113','EPSG','6536','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103059','EPSG','6477','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103058','EPSG','6478','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103116','EPSG','6538','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102508','EPSG','6817','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103114','EPSG','6534','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103115','EPSG','6540','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103053','EPSG','6472','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103052','EPSG','6471','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103051','EPSG','6470','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103050','EPSG','6469','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103057','EPSG','6476','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103056','EPSG','6475','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103055','EPSG','6474','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103054','EPSG','6473','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102466','EPSG','26857','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103015','EPSG','6433','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103204','EPSG','4051','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103026','EPSG','6446','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102722','EPSG','3734','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103027','EPSG','6445','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103024','EPSG','6441','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102439','EPSG','4462','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103022','EPSG','6438','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103205','EPSG','4056','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103023','EPSG','6443','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102723','EPSG','3735','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103020','EPSG','6442','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103021','EPSG','6440','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102539','EPSG','6820','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102538','EPSG','6816','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103028','EPSG','6447','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103029','EPSG','6450','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102533','EPSG','6792','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102532','EPSG','6788','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102531','EPSG','6796','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102530','EPSG','6784','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102537','EPSG','6812','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102536','EPSG','6808','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102535','EPSG','6804','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102534','EPSG','6800','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103189','EPSG','6607','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103188','EPSG','6608','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103019','EPSG','6437','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103181','EPSG','6599','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103180','EPSG','6597','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103183','EPSG','6602','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103182','EPSG','6600','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103185','EPSG','6603','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103184','EPSG','6601','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103187','EPSG','6879','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103186','EPSG','6606','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102326','EPSG','2838','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102327','EPSG','2839','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102797','EPSG','6258','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102796','EPSG','6249','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102795','EPSG','6253','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102794','EPSG','6271','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102793','EPSG','6248','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102792','EPSG','6268','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102791','EPSG','6263','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102790','EPSG','6245','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102798','EPSG','6265','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102388','EPSG','6348','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102384','EPSG','6344','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102385','EPSG','6345','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102386','EPSG','6346','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102387','EPSG','6347','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102380','EPSG','6867','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102381','EPSG','6868','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102382','EPSG','6342','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102383','EPSG','6343','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102548','EPSG','6856','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102549','EPSG','6860','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102546','EPSG','6844','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102547','EPSG','6852','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102544','EPSG','6840','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102545','EPSG','6848','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102542','EPSG','6832','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102543','EPSG','6836','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102540','EPSG','6824','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102541','EPSG','6828','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102362','EPSG','4647','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102363','EPSG','3090','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102361','EPSG','2866','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102006','EPSG','3338','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102779','EPSG','6266','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102778','EPSG','6273','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102645','EPSG','2229','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102644','EPSG','2228','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102311','EPSG','2824','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102646','EPSG','2230','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102317','EPSG','2830','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102316','EPSG','2829','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102315','EPSG','2828','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102314','EPSG','2827','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102090','EPSG','3770','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102091','EPSG','3003','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102092','EPSG','3004','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102318','EPSG','2831','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102095','EPSG','3448','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102764','EPSG','4417','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102765','EPSG','4434','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102771','EPSG','6247','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102770','EPSG','6246','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103213','EPSG','4071','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102167','EPSG','2942','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103138','EPSG','6561','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102169','EPSG','2943','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103139','EPSG','6562','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103062','EPSG','6485','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103063','EPSG','6484','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103060','EPSG','6479','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103061','EPSG','6483','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103066','EPSG','6480','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103067','EPSG','6482','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103064','EPSG','6486','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103065','EPSG','6481','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103068','EPSG','6487','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103069','EPSG','6488','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103149','EPSG','6572','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103117','EPSG','6537','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103145','EPSG','6569','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103144','EPSG','6568','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103147','EPSG','6571','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103146','EPSG','6570','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103141','EPSG','6564','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103140','EPSG','6563','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103143','EPSG','6567','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103142','EPSG','6565','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103200','EPSG','6566','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102593','EPSG','6688','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102595','EPSG','6690','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102594','EPSG','6689','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102597','EPSG','6692','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102596','EPSG','6691','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102692','EPSG','26850','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102693','EPSG','26851','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102691','EPSG','26849','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102694','EPSG','2254','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102695','EPSG','2255','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102214','EPSG','4826','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102502','EPSG','6789','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102503','EPSG','6793','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102269','EPSG','2788','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102501','EPSG','6797','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102506','EPSG','6809','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102507','EPSG','6813','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102504','EPSG','6801','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102505','EPSG','6805','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102263','EPSG','2784','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102262','EPSG','2783','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102261','EPSG','2782','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102509','EPSG','6821','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102267','EPSG','2781','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102266','EPSG','2780','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102265','EPSG','2786','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102264','EPSG','2785','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102469','EPSG','3815','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102468','EPSG','26859','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102467','EPSG','26858','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102211','EPSG','3748','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102463','EPSG','3760','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102285','EPSG','2804','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102284','EPSG','2803','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102287','EPSG','2806','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102286','EPSG','2805','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102281','EPSG','2800','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102280','EPSG','2799','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102283','EPSG','2802','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102282','EPSG','2801','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102322','EPSG','2834','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102323','EPSG','2835','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102320','EPSG','2832','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102321','EPSG','2833','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102289','EPSG','2808','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102288','EPSG','2807','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102324','EPSG','2836','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102325','EPSG','2837','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102229','EPSG','2759','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102609','EPSG','3814','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102608','EPSG','3074','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103208','EPSG','4059','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103209','EPSG','4060','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102712','EPSG','2257','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102601','EPSG','3083','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103203','EPSG','4050','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102603','EPSG','3081','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102602','EPSG','3082','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103206','EPSG','4057','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103207','EPSG','4058','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102210','EPSG','3077','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102606','EPSG','3072','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102139','EPSG','3067','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102131','EPSG','3373','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102130','EPSG','3372','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102735','EPSG','3455','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102734','EPSG','4457','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102737','EPSG','2275','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102040','EPSG','5178','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102047','EPSG','6329','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102046','EPSG','6328','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102049','EPSG','6331','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102048','EPSG','6330','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102739','EPSG','2277','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102738','EPSG','2276','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103215','EPSG','4083','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103101','EPSG','6519','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103100','EPSG','6521','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103103','EPSG','6524','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103102','EPSG','6523','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103105','EPSG','6526','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103104','EPSG','6525','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103107','EPSG','6530','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103106','EPSG','6527','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103109','EPSG','6532','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103108','EPSG','6528','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103199','EPSG','6616','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102420','EPSG','5325','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103039','EPSG','6458','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103038','EPSG','6457','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103035','EPSG','6454','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103034','EPSG','6453','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103037','EPSG','6455','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103036','EPSG','6456','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103031','EPSG','6452','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103030','EPSG','6448','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103033','EPSG','6449','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103032','EPSG','6451','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102310','EPSG','2823','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102252','EPSG','2765','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102253','EPSG','2772','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102250','EPSG','2763','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102251','EPSG','2764','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102256','EPSG','2775','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102257','EPSG','2776','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102254','EPSG','2773','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102255','EPSG','2774','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102258','EPSG','2777','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102291','EPSG','2810','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102494','EPSG','6635','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102495','EPSG','6637','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102496','EPSG','6636','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102736','EPSG','2274','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102490','EPSG','5247','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103085','EPSG','6505','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103086','EPSG','6506','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102493','EPSG','6634','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103088','EPSG','6507','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102981','EPSG','6398','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102730','EPSG','3438','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102377','EPSG','6886','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102376','EPSG','6884','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102379','EPSG','6887','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102378','EPSG','6885','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102351','EPSG','2858','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102087','EPSG','5175','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102086','EPSG','5174','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102085','EPSG','5173','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102084','EPSG','5188','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102083','EPSG','5187','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102082','EPSG','5186','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102081','EPSG','5185','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102080','EPSG','5179','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102089','EPSG','5177','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102088','EPSG','5176','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102670','EPSG','2243','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102671','EPSG','3435','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102672','EPSG','3436','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102673','EPSG','2965','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102674','EPSG','2966','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102675','EPSG','3417','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102676','EPSG','3418','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102677','EPSG','3419','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102678','EPSG','3420','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102679','EPSG','2246','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102773','EPSG','6272','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102772','EPSG','6250','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102775','EPSG','6252','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102774','EPSG','6256','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102777','EPSG','6264','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102776','EPSG','6275','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102100','EPSG','3857','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103076','EPSG','6498','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102313','EPSG','2826','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','31922','EPSG','31991','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','31920','EPSG','31989','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','31921','EPSG','31990','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102647','EPSG','4437','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102172','EPSG','3107','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102171','EPSG','3111','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102170','EPSG','3110','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103191','EPSG','6609','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102641','EPSG','2225','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102643','EPSG','2227','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102642','EPSG','2226','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103071','EPSG','6489','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102762','EPSG','4415','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103073','EPSG','6490','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103072','EPSG','6492','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103075','EPSG','6493','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103074','EPSG','6495','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103077','EPSG','6496','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102763','EPSG','3089','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103079','EPSG','6499','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103078','EPSG','6494','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103178','EPSG','6596','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103179','EPSG','6598','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103170','EPSG','6625','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103171','EPSG','6627','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103172','EPSG','6589','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103173','EPSG','6590','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103174','EPSG','6592','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103175','EPSG','6594','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103176','EPSG','6593','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102767','EPSG','6255','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102681','EPSG','3451','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102680','EPSG','2247','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102683','EPSG','26847','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102682','EPSG','3452','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102685','EPSG','2248','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102684','EPSG','26848','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102687','EPSG','2250','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102686','EPSG','2249','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103177','EPSG','6595','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102511','EPSG','6829','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102510','EPSG','6825','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102513','EPSG','6837','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102512','EPSG','6833','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102515','EPSG','6849','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102514','EPSG','6841','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102517','EPSG','6853','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102516','EPSG','6845','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102519','EPSG','6861','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102518','EPSG','6857','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102997','EPSG','6415','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103195','EPSG','6615','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102996','EPSG','6413','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102339','EPSG','2846','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102338','EPSG','2845','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102789','EPSG','6259','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102331','EPSG','5014','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102330','EPSG','2840','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102333','EPSG','5016','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102332','EPSG','5015','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102335','EPSG','2842','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102334','EPSG','2841','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102337','EPSG','2844','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102336','EPSG','2843','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103118','EPSG','6535','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102999','EPSG','6419','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102998','EPSG','6417','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103219','EPSG','4096','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103218','EPSG','4095','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102209','EPSG','3464','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102208','EPSG','3075','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102205','EPSG','3741','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103210','EPSG','4061','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102207','EPSG','3743','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102206','EPSG','3742','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102201','EPSG','4414','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102200','EPSG','2195','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102203','EPSG','3751','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102202','EPSG','3750','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102148','EPSG','3100','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102149','EPSG','3101','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103119','EPSG','6541','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102140','EPSG','2326','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102146','EPSG','3098','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102147','EPSG','3099','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102145','EPSG','3097','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102123','EPSG','3078','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103110','EPSG','6531','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102787','EPSG','6262','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102704','EPSG','26852','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102706','EPSG','7142','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102707','EPSG','3421','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102708','EPSG','3422','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102709','EPSG','3423','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103014','EPSG','6432','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','2183','ESRI','102552','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','2182','ESRI','102551','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','2181','ESRI','102550','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','2187','ESRI','102556','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','2186','ESRI','102555','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','2185','ESRI','102554','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','2184','ESRI','102553','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103134','EPSG','6555','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103135','EPSG','6558','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103136','EPSG','6560','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103137','EPSG','6559','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103130','EPSG','6551','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103131','EPSG','6552','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103132','EPSG','6554','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103133','EPSG','6553','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102968','EPSG','6497','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102969','EPSG','6556','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102965','EPSG','6350','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102312','EPSG','2825','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102967','EPSG','6439','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102962','EPSG','6414','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102963','EPSG','6508','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103008','EPSG','6426','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103009','EPSG','6429','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103000','EPSG','6421','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103001','EPSG','6423','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103002','EPSG','6425','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103003','EPSG','6416','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103004','EPSG','6418','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103005','EPSG','6420','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103006','EPSG','6422','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103007','EPSG','6424','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103794','EPSG','4484','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103795','EPSG','4485','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103796','EPSG','4486','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103797','EPSG','4487','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103798','EPSG','4488','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103799','EPSG','4489','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103211','EPSG','4062','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102241','EPSG','2766','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102243','EPSG','2768','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102242','EPSG','2767','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102245','EPSG','2770','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102244','EPSG','2769','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102246','EPSG','2771','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102249','EPSG','2762','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','102248','EPSG','2761','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103099','EPSG','6522','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103098','EPSG','6518','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103097','EPSG','6520','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103096','EPSG','6880','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103095','EPSG','6516','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103094','EPSG','6515','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103093','EPSG','6514','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103092','EPSG','6513','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103091','EPSG','6511','ESRI'); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','103090','EPSG','6512','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102340','projected_crs','EPSG','2847','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102341','projected_crs','EPSG','2848','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102342','projected_crs','EPSG','2849','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102343','projected_crs','EPSG','2850','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102344','projected_crs','EPSG','2851','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102345','projected_crs','EPSG','2852','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102346','projected_crs','EPSG','2853','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102347','projected_crs','EPSG','2854','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102348','projected_crs','EPSG','2855','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102349','projected_crs','EPSG','2856','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102065','projected_crs','EPSG','5513','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102067','projected_crs','EPSG','5514','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102066','projected_crs','EPSG','5221','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102744','projected_crs','EPSG','3567','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102745','projected_crs','EPSG','5646','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102746','projected_crs','EPSG','2283','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102747','projected_crs','EPSG','2284','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102740','projected_crs','EPSG','2278','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102741','projected_crs','EPSG','2279','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102742','projected_crs','EPSG','3560','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102743','projected_crs','EPSG','3566','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102748','projected_crs','EPSG','2285','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102724','projected_crs','EPSG','2267','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102986','projected_crs','EPSG','6403','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102987','projected_crs','EPSG','6406','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102984','projected_crs','EPSG','6401','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102725','projected_crs','EPSG','2268','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102982','projected_crs','EPSG','6399','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102983','projected_crs','EPSG','6400','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102669','projected_crs','EPSG','2242','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102668','projected_crs','EPSG','2241','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102667','projected_crs','EPSG','2240','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102050','projected_crs','EPSG','6332','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102663','projected_crs','EPSG','3759','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102988','projected_crs','EPSG','6404','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102660','projected_crs','EPSG','2238','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102111','projected_crs','EPSG','5519','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102110','projected_crs','EPSG','2154','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102113','projected_crs','EPSG','3785','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102112','projected_crs','EPSG','3764','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102119','projected_crs','EPSG','3080','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102966','projected_crs','EPSG','6393','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102788','projected_crs','EPSG','6251','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103214','projected_crs','EPSG','4082','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','31917','projected_crs','EPSG','31986','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','31919','projected_crs','EPSG','31988','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','31918','projected_crs','EPSG','31987','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102059','projected_crs','EPSG','6341','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102989','projected_crs','EPSG','6408','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102188','projected_crs','EPSG','3777','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102189','projected_crs','EPSG','3801','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102186','projected_crs','EPSG','3775','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102187','projected_crs','EPSG','3776','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102184','projected_crs','EPSG','3400','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102185','projected_crs','EPSG','3401','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102182','projected_crs','EPSG','3773','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102183','projected_crs','EPSG','3800','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102180','projected_crs','EPSG','3771','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102181','projected_crs','EPSG','3772','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103165','projected_crs','EPSG','6621','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103164','projected_crs','EPSG','6619','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103048','projected_crs','EPSG','6468','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103049','projected_crs','EPSG','6467','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103161','projected_crs','EPSG','6588','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103160','projected_crs','EPSG','6578','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103044','projected_crs','EPSG','6464','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103045','projected_crs','EPSG','6463','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103046','projected_crs','EPSG','6465','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103047','projected_crs','EPSG','6466','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103040','projected_crs','EPSG','6460','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103041','projected_crs','EPSG','6459','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103042','projected_crs','EPSG','6461','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103043','projected_crs','EPSG','6462','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102304','projected_crs','EPSG','2819','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103163','projected_crs','EPSG','6620','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102657','projected_crs','EPSG','2235','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102307','projected_crs','EPSG','2820','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102300','projected_crs','EPSG','2818','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103162','projected_crs','EPSG','6586','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102718','projected_crs','EPSG','2263','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103082','projected_crs','EPSG','6504','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103148','projected_crs','EPSG','6573','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102444','projected_crs','EPSG','3825','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102443','projected_crs','EPSG','3826','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102442','projected_crs','EPSG','3827','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102441','projected_crs','EPSG','3828','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102524','projected_crs','EPSG','6632','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102713','projected_crs','EPSG','2258','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102527','projected_crs','EPSG','6633','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102520','projected_crs','EPSG','6628','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102521','projected_crs','EPSG','6629','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102522','projected_crs','EPSG','6630','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102523','projected_crs','EPSG','6631','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103198','projected_crs','EPSG','6618','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103111','projected_crs','EPSG','6529','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102711','projected_crs','EPSG','3424','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103192','projected_crs','EPSG','6611','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103193','projected_crs','EPSG','6613','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103190','projected_crs','EPSG','6605','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102710','projected_crs','EPSG','3437','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103196','projected_crs','EPSG','6612','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103197','projected_crs','EPSG','6614','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103194','projected_crs','EPSG','6617','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102768','projected_crs','EPSG','6257','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102749','projected_crs','EPSG','2286','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102769','projected_crs','EPSG','6244','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102623','projected_crs','EPSG','6682','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102622','projected_crs','EPSG','6681','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102621','projected_crs','EPSG','6680','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102620','projected_crs','EPSG','6679','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102627','projected_crs','EPSG','6686','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102626','projected_crs','EPSG','6685','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102625','projected_crs','EPSG','6684','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102624','projected_crs','EPSG','6683','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102780','projected_crs','EPSG','6260','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102781','projected_crs','EPSG','6254','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102782','projected_crs','EPSG','6269','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102628','projected_crs','EPSG','6687','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102784','projected_crs','EPSG','6267','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102785','projected_crs','EPSG','6270','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102786','projected_crs','EPSG','6274','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102607','projected_crs','EPSG','3463','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102985','projected_crs','EPSG','6402','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102230','projected_crs','EPSG','2760','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102234','projected_crs','EPSG','3158','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102235','projected_crs','EPSG','3159','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102236','projected_crs','EPSG','3160','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102980','projected_crs','EPSG','6397','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102151','projected_crs','EPSG','3092','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102153','projected_crs','EPSG','3094','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102152','projected_crs','EPSG','3093','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102155','projected_crs','EPSG','3096','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102154','projected_crs','EPSG','3095','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102666','projected_crs','EPSG','2239','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103087','projected_crs','EPSG','6509','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103025','projected_crs','EPSG','6444','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102656','projected_crs','EPSG','2234','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102305','projected_crs','EPSG','5367','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102654','projected_crs','EPSG','2232','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102655','projected_crs','EPSG','2233','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102652','projected_crs','EPSG','3434','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102653','projected_crs','EPSG','2231','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102719','projected_crs','EPSG','2264','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102651','projected_crs','EPSG','3433','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102717','projected_crs','EPSG','2262','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102716','projected_crs','EPSG','2261','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102715','projected_crs','EPSG','2260','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102714','projected_crs','EPSG','2259','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102308','projected_crs','EPSG','2821','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102309','projected_crs','EPSG','2822','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102658','projected_crs','EPSG','2236','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102659','projected_crs','EPSG','2237','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103129','projected_crs','EPSG','6549','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103128','projected_crs','EPSG','6550','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103122','projected_crs','EPSG','6543','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103123','projected_crs','EPSG','6544','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102783','projected_crs','EPSG','6261','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103121','projected_crs','EPSG','6542','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103120','projected_crs','EPSG','6539','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103127','projected_crs','EPSG','6548','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103126','projected_crs','EPSG','6547','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103125','projected_crs','EPSG','6545','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103124','projected_crs','EPSG','6546','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103169','projected_crs','EPSG','6626','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103017','projected_crs','EPSG','6435','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103016','projected_crs','EPSG','6434','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102979','projected_crs','EPSG','6396','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102978','projected_crs','EPSG','6395','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103013','projected_crs','EPSG','6428','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103012','projected_crs','EPSG','6430','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103011','projected_crs','EPSG','6431','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103010','projected_crs','EPSG','6427','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102973','projected_crs','EPSG','6610','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102972','projected_crs','EPSG','6580','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102971','projected_crs','EPSG','6579','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102970','projected_crs','EPSG','6557','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102977','projected_crs','EPSG','6394','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102976','projected_crs','EPSG','6356','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102975','projected_crs','EPSG','6355','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103018','projected_crs','EPSG','6436','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103212','projected_crs','EPSG','4063','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102500','projected_crs','EPSG','6785','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103158','projected_crs','EPSG','6582','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103159','projected_crs','EPSG','6584','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103156','projected_crs','EPSG','6587','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103157','projected_crs','EPSG','6585','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103154','projected_crs','EPSG','6583','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103155','projected_crs','EPSG','6577','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103152','projected_crs','EPSG','6576','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103153','projected_crs','EPSG','6581','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103150','projected_crs','EPSG','6574','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103151','projected_crs','EPSG','6575','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103217','projected_crs','EPSG','4094','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103216','projected_crs','EPSG','4093','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102259','projected_crs','EPSG','2778','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103080','projected_crs','EPSG','6502','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102278','projected_crs','EPSG','2797','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102279','projected_crs','EPSG','2798','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103081','projected_crs','EPSG','6500','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102274','projected_crs','EPSG','2793','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102275','projected_crs','EPSG','2794','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102276','projected_crs','EPSG','2795','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102277','projected_crs','EPSG','2796','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102270','projected_crs','EPSG','2789','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102271','projected_crs','EPSG','2790','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102272','projected_crs','EPSG','2791','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102273','projected_crs','EPSG','2792','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103083','projected_crs','EPSG','6503','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103070','projected_crs','EPSG','6491','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103084','projected_crs','EPSG','6501','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103202','projected_crs','EPSG','4049','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102296','projected_crs','EPSG','2815','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102297','projected_crs','EPSG','2816','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102294','projected_crs','EPSG','2813','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102295','projected_crs','EPSG','2814','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102292','projected_crs','EPSG','2811','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102293','projected_crs','EPSG','2812','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102290','projected_crs','EPSG','2809','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102358','projected_crs','EPSG','2865','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','65163','projected_crs','EPSG','3088','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102356','projected_crs','EPSG','2863','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102355','projected_crs','EPSG','2862','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102354','projected_crs','EPSG','2861','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102353','projected_crs','EPSG','2860','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102352','projected_crs','EPSG','2859','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102298','projected_crs','EPSG','2817','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102350','projected_crs','EPSG','2857','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102268','projected_crs','EPSG','2787','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103089','projected_crs','EPSG','6510','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102753','projected_crs','EPSG','2288','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102752','projected_crs','EPSG','2287','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102751','projected_crs','EPSG','26854','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102750','projected_crs','EPSG','26853','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102757','projected_crs','EPSG','3738','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102756','projected_crs','EPSG','3737','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102755','projected_crs','EPSG','3736','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102754','projected_crs','EPSG','2289','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102758','projected_crs','EPSG','3739','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102995','projected_crs','EPSG','6411','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102994','projected_crs','EPSG','6412','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102618','projected_crs','EPSG','6677','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102619','projected_crs','EPSG','6678','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102991','projected_crs','EPSG','6405','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102990','projected_crs','EPSG','6407','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102993','projected_crs','EPSG','6410','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102992','projected_crs','EPSG','6409','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102612','projected_crs','EPSG','6671','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102613','projected_crs','EPSG','6672','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102610','projected_crs','EPSG','6669','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102611','projected_crs','EPSG','6670','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102616','projected_crs','EPSG','6675','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102617','projected_crs','EPSG','6676','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102614','projected_crs','EPSG','6673','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102615','projected_crs','EPSG','6674','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102260','projected_crs','EPSG','2779','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102124','projected_crs','EPSG','26701','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102125','projected_crs','EPSG','26702','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102126','projected_crs','EPSG','3370','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102127','projected_crs','EPSG','3371','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102128','projected_crs','EPSG','26901','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102129','projected_crs','EPSG','26902','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103201','projected_crs','EPSG','4048','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102054','projected_crs','EPSG','6336','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102055','projected_crs','EPSG','6337','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102056','projected_crs','EPSG','6338','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102057','projected_crs','EPSG','6339','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102199','projected_crs','EPSG','3812','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102051','projected_crs','EPSG','6333','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102052','projected_crs','EPSG','6334','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102053','projected_crs','EPSG','6335','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102058','projected_crs','EPSG','6340','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102190','projected_crs','EPSG','3005','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102728','projected_crs','EPSG','2271','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102729','projected_crs','EPSG','2272','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102357','projected_crs','EPSG','2864','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103112','projected_crs','EPSG','6533','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103113','projected_crs','EPSG','6536','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103059','projected_crs','EPSG','6477','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103058','projected_crs','EPSG','6478','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103116','projected_crs','EPSG','6538','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102508','projected_crs','EPSG','6817','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103114','projected_crs','EPSG','6534','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103115','projected_crs','EPSG','6540','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103053','projected_crs','EPSG','6472','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103052','projected_crs','EPSG','6471','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103051','projected_crs','EPSG','6470','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103050','projected_crs','EPSG','6469','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103057','projected_crs','EPSG','6476','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103056','projected_crs','EPSG','6475','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103055','projected_crs','EPSG','6474','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103054','projected_crs','EPSG','6473','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102466','projected_crs','EPSG','26857','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103015','projected_crs','EPSG','6433','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103204','projected_crs','EPSG','4051','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103026','projected_crs','EPSG','6446','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102722','projected_crs','EPSG','3734','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103027','projected_crs','EPSG','6445','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103024','projected_crs','EPSG','6441','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102439','projected_crs','EPSG','4462','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103022','projected_crs','EPSG','6438','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103205','projected_crs','EPSG','4056','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103023','projected_crs','EPSG','6443','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102723','projected_crs','EPSG','3735','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103020','projected_crs','EPSG','6442','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103021','projected_crs','EPSG','6440','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102539','projected_crs','EPSG','6820','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102538','projected_crs','EPSG','6816','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103028','projected_crs','EPSG','6447','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103029','projected_crs','EPSG','6450','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102533','projected_crs','EPSG','6792','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102532','projected_crs','EPSG','6788','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102531','projected_crs','EPSG','6796','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102530','projected_crs','EPSG','6784','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102537','projected_crs','EPSG','6812','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102536','projected_crs','EPSG','6808','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102535','projected_crs','EPSG','6804','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102534','projected_crs','EPSG','6800','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103189','projected_crs','EPSG','6607','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103188','projected_crs','EPSG','6608','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103019','projected_crs','EPSG','6437','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103181','projected_crs','EPSG','6599','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103180','projected_crs','EPSG','6597','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103183','projected_crs','EPSG','6602','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103182','projected_crs','EPSG','6600','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103185','projected_crs','EPSG','6603','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103184','projected_crs','EPSG','6601','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103187','projected_crs','EPSG','6879','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103186','projected_crs','EPSG','6606','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102326','projected_crs','EPSG','2838','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102327','projected_crs','EPSG','2839','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102797','projected_crs','EPSG','6258','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102796','projected_crs','EPSG','6249','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102795','projected_crs','EPSG','6253','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102794','projected_crs','EPSG','6271','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102793','projected_crs','EPSG','6248','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102792','projected_crs','EPSG','6268','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102791','projected_crs','EPSG','6263','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102790','projected_crs','EPSG','6245','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102798','projected_crs','EPSG','6265','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102388','projected_crs','EPSG','6348','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102384','projected_crs','EPSG','6344','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102385','projected_crs','EPSG','6345','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102386','projected_crs','EPSG','6346','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102387','projected_crs','EPSG','6347','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102380','projected_crs','EPSG','6867','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102381','projected_crs','EPSG','6868','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102382','projected_crs','EPSG','6342','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102383','projected_crs','EPSG','6343','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102548','projected_crs','EPSG','6856','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102549','projected_crs','EPSG','6860','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102546','projected_crs','EPSG','6844','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102547','projected_crs','EPSG','6852','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102544','projected_crs','EPSG','6840','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102545','projected_crs','EPSG','6848','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102542','projected_crs','EPSG','6832','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102543','projected_crs','EPSG','6836','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102540','projected_crs','EPSG','6824','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102541','projected_crs','EPSG','6828','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102362','projected_crs','EPSG','4647','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102363','projected_crs','EPSG','3090','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102361','projected_crs','EPSG','2866','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102006','projected_crs','EPSG','3338','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102779','projected_crs','EPSG','6266','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102778','projected_crs','EPSG','6273','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102645','projected_crs','EPSG','2229','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102644','projected_crs','EPSG','2228','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102311','projected_crs','EPSG','2824','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102646','projected_crs','EPSG','2230','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102317','projected_crs','EPSG','2830','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102316','projected_crs','EPSG','2829','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102315','projected_crs','EPSG','2828','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102314','projected_crs','EPSG','2827','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102090','projected_crs','EPSG','3770','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102091','projected_crs','EPSG','3003','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102092','projected_crs','EPSG','3004','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102318','projected_crs','EPSG','2831','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102095','projected_crs','EPSG','3448','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102764','projected_crs','EPSG','4417','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102765','projected_crs','EPSG','4434','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102771','projected_crs','EPSG','6247','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102770','projected_crs','EPSG','6246','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103213','projected_crs','EPSG','4071','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102167','projected_crs','EPSG','2942','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103138','projected_crs','EPSG','6561','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102169','projected_crs','EPSG','2943','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103139','projected_crs','EPSG','6562','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103062','projected_crs','EPSG','6485','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103063','projected_crs','EPSG','6484','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103060','projected_crs','EPSG','6479','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103061','projected_crs','EPSG','6483','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103066','projected_crs','EPSG','6480','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103067','projected_crs','EPSG','6482','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103064','projected_crs','EPSG','6486','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103065','projected_crs','EPSG','6481','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103068','projected_crs','EPSG','6487','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103069','projected_crs','EPSG','6488','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103149','projected_crs','EPSG','6572','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103117','projected_crs','EPSG','6537','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103145','projected_crs','EPSG','6569','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103144','projected_crs','EPSG','6568','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103147','projected_crs','EPSG','6571','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103146','projected_crs','EPSG','6570','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103141','projected_crs','EPSG','6564','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103140','projected_crs','EPSG','6563','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103143','projected_crs','EPSG','6567','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103142','projected_crs','EPSG','6565','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103200','projected_crs','EPSG','6566','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102593','projected_crs','EPSG','6688','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102595','projected_crs','EPSG','6690','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102594','projected_crs','EPSG','6689','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102597','projected_crs','EPSG','6692','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102596','projected_crs','EPSG','6691','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102692','projected_crs','EPSG','26850','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102693','projected_crs','EPSG','26851','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102691','projected_crs','EPSG','26849','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102694','projected_crs','EPSG','2254','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102695','projected_crs','EPSG','2255','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102214','projected_crs','EPSG','4826','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102502','projected_crs','EPSG','6789','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102503','projected_crs','EPSG','6793','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102269','projected_crs','EPSG','2788','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102501','projected_crs','EPSG','6797','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102506','projected_crs','EPSG','6809','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102507','projected_crs','EPSG','6813','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102504','projected_crs','EPSG','6801','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102505','projected_crs','EPSG','6805','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102263','projected_crs','EPSG','2784','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102262','projected_crs','EPSG','2783','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102261','projected_crs','EPSG','2782','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102509','projected_crs','EPSG','6821','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102267','projected_crs','EPSG','2781','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102266','projected_crs','EPSG','2780','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102265','projected_crs','EPSG','2786','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102264','projected_crs','EPSG','2785','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102469','projected_crs','EPSG','3815','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102468','projected_crs','EPSG','26859','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102467','projected_crs','EPSG','26858','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102211','projected_crs','EPSG','3748','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102463','projected_crs','EPSG','3760','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102285','projected_crs','EPSG','2804','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102284','projected_crs','EPSG','2803','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102287','projected_crs','EPSG','2806','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102286','projected_crs','EPSG','2805','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102281','projected_crs','EPSG','2800','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102280','projected_crs','EPSG','2799','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102283','projected_crs','EPSG','2802','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102282','projected_crs','EPSG','2801','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102322','projected_crs','EPSG','2834','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102323','projected_crs','EPSG','2835','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102320','projected_crs','EPSG','2832','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102321','projected_crs','EPSG','2833','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102289','projected_crs','EPSG','2808','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102288','projected_crs','EPSG','2807','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102324','projected_crs','EPSG','2836','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102325','projected_crs','EPSG','2837','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102229','projected_crs','EPSG','2759','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102609','projected_crs','EPSG','3814','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102608','projected_crs','EPSG','3074','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103208','projected_crs','EPSG','4059','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103209','projected_crs','EPSG','4060','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102712','projected_crs','EPSG','2257','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102601','projected_crs','EPSG','3083','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103203','projected_crs','EPSG','4050','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102603','projected_crs','EPSG','3081','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102602','projected_crs','EPSG','3082','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103206','projected_crs','EPSG','4057','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103207','projected_crs','EPSG','4058','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102210','projected_crs','EPSG','3077','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102606','projected_crs','EPSG','3072','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102139','projected_crs','EPSG','3067','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102131','projected_crs','EPSG','3373','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102130','projected_crs','EPSG','3372','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102735','projected_crs','EPSG','3455','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102734','projected_crs','EPSG','4457','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102737','projected_crs','EPSG','2275','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102040','projected_crs','EPSG','5178','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102047','projected_crs','EPSG','6329','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102046','projected_crs','EPSG','6328','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102049','projected_crs','EPSG','6331','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102048','projected_crs','EPSG','6330','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102739','projected_crs','EPSG','2277','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102738','projected_crs','EPSG','2276','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103215','projected_crs','EPSG','4083','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103101','projected_crs','EPSG','6519','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103100','projected_crs','EPSG','6521','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103103','projected_crs','EPSG','6524','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103102','projected_crs','EPSG','6523','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103105','projected_crs','EPSG','6526','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103104','projected_crs','EPSG','6525','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103107','projected_crs','EPSG','6530','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103106','projected_crs','EPSG','6527','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103109','projected_crs','EPSG','6532','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103108','projected_crs','EPSG','6528','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103199','projected_crs','EPSG','6616','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102420','projected_crs','EPSG','5325','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103039','projected_crs','EPSG','6458','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103038','projected_crs','EPSG','6457','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103035','projected_crs','EPSG','6454','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103034','projected_crs','EPSG','6453','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103037','projected_crs','EPSG','6455','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103036','projected_crs','EPSG','6456','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103031','projected_crs','EPSG','6452','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103030','projected_crs','EPSG','6448','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103033','projected_crs','EPSG','6449','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103032','projected_crs','EPSG','6451','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102310','projected_crs','EPSG','2823','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102252','projected_crs','EPSG','2765','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102253','projected_crs','EPSG','2772','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102250','projected_crs','EPSG','2763','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102251','projected_crs','EPSG','2764','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102256','projected_crs','EPSG','2775','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102257','projected_crs','EPSG','2776','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102254','projected_crs','EPSG','2773','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102255','projected_crs','EPSG','2774','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102258','projected_crs','EPSG','2777','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102291','projected_crs','EPSG','2810','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102494','projected_crs','EPSG','6635','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102495','projected_crs','EPSG','6637','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102496','projected_crs','EPSG','6636','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102736','projected_crs','EPSG','2274','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102490','projected_crs','EPSG','5247','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103085','projected_crs','EPSG','6505','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103086','projected_crs','EPSG','6506','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102493','projected_crs','EPSG','6634','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103088','projected_crs','EPSG','6507','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102981','projected_crs','EPSG','6398','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102730','projected_crs','EPSG','3438','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102377','projected_crs','EPSG','6886','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102376','projected_crs','EPSG','6884','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102379','projected_crs','EPSG','6887','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102378','projected_crs','EPSG','6885','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102351','projected_crs','EPSG','2858','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102087','projected_crs','EPSG','5175','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102086','projected_crs','EPSG','5174','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102085','projected_crs','EPSG','5173','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102084','projected_crs','EPSG','5188','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102083','projected_crs','EPSG','5187','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102082','projected_crs','EPSG','5186','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102081','projected_crs','EPSG','5185','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102080','projected_crs','EPSG','5179','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102089','projected_crs','EPSG','5177','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102088','projected_crs','EPSG','5176','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102670','projected_crs','EPSG','2243','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102671','projected_crs','EPSG','3435','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102672','projected_crs','EPSG','3436','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102673','projected_crs','EPSG','2965','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102674','projected_crs','EPSG','2966','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102675','projected_crs','EPSG','3417','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102676','projected_crs','EPSG','3418','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102677','projected_crs','EPSG','3419','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102678','projected_crs','EPSG','3420','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102679','projected_crs','EPSG','2246','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102773','projected_crs','EPSG','6272','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102772','projected_crs','EPSG','6250','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102775','projected_crs','EPSG','6252','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102774','projected_crs','EPSG','6256','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102777','projected_crs','EPSG','6264','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102776','projected_crs','EPSG','6275','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102100','projected_crs','EPSG','3857','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103076','projected_crs','EPSG','6498','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102313','projected_crs','EPSG','2826','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','31922','projected_crs','EPSG','31991','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','31920','projected_crs','EPSG','31989','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','31921','projected_crs','EPSG','31990','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102647','projected_crs','EPSG','4437','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102172','projected_crs','EPSG','3107','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102171','projected_crs','EPSG','3111','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102170','projected_crs','EPSG','3110','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103191','projected_crs','EPSG','6609','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102641','projected_crs','EPSG','2225','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102643','projected_crs','EPSG','2227','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102642','projected_crs','EPSG','2226','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103071','projected_crs','EPSG','6489','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102762','projected_crs','EPSG','4415','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103073','projected_crs','EPSG','6490','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103072','projected_crs','EPSG','6492','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103075','projected_crs','EPSG','6493','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103074','projected_crs','EPSG','6495','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103077','projected_crs','EPSG','6496','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102763','projected_crs','EPSG','3089','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103079','projected_crs','EPSG','6499','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103078','projected_crs','EPSG','6494','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103178','projected_crs','EPSG','6596','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103179','projected_crs','EPSG','6598','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103170','projected_crs','EPSG','6625','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103171','projected_crs','EPSG','6627','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103172','projected_crs','EPSG','6589','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103173','projected_crs','EPSG','6590','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103174','projected_crs','EPSG','6592','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103175','projected_crs','EPSG','6594','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103176','projected_crs','EPSG','6593','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102767','projected_crs','EPSG','6255','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102681','projected_crs','EPSG','3451','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102680','projected_crs','EPSG','2247','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102683','projected_crs','EPSG','26847','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102682','projected_crs','EPSG','3452','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102685','projected_crs','EPSG','2248','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102684','projected_crs','EPSG','26848','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102687','projected_crs','EPSG','2250','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102686','projected_crs','EPSG','2249','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103177','projected_crs','EPSG','6595','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102511','projected_crs','EPSG','6829','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102510','projected_crs','EPSG','6825','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102513','projected_crs','EPSG','6837','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102512','projected_crs','EPSG','6833','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102515','projected_crs','EPSG','6849','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102514','projected_crs','EPSG','6841','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102517','projected_crs','EPSG','6853','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102516','projected_crs','EPSG','6845','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102519','projected_crs','EPSG','6861','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102518','projected_crs','EPSG','6857','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102997','projected_crs','EPSG','6415','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103195','projected_crs','EPSG','6615','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102996','projected_crs','EPSG','6413','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102339','projected_crs','EPSG','2846','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102338','projected_crs','EPSG','2845','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102789','projected_crs','EPSG','6259','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102331','projected_crs','EPSG','5014','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102330','projected_crs','EPSG','2840','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102333','projected_crs','EPSG','5016','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102332','projected_crs','EPSG','5015','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102335','projected_crs','EPSG','2842','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102334','projected_crs','EPSG','2841','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102337','projected_crs','EPSG','2844','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102336','projected_crs','EPSG','2843','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103118','projected_crs','EPSG','6535','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102999','projected_crs','EPSG','6419','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102998','projected_crs','EPSG','6417','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103219','projected_crs','EPSG','4096','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103218','projected_crs','EPSG','4095','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102209','projected_crs','EPSG','3464','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102208','projected_crs','EPSG','3075','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102205','projected_crs','EPSG','3741','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103210','projected_crs','EPSG','4061','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102207','projected_crs','EPSG','3743','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102206','projected_crs','EPSG','3742','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102201','projected_crs','EPSG','4414','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102200','projected_crs','EPSG','2195','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102203','projected_crs','EPSG','3751','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102202','projected_crs','EPSG','3750','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102148','projected_crs','EPSG','3100','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102149','projected_crs','EPSG','3101','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103119','projected_crs','EPSG','6541','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102140','projected_crs','EPSG','2326','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102146','projected_crs','EPSG','3098','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102147','projected_crs','EPSG','3099','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102145','projected_crs','EPSG','3097','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102123','projected_crs','EPSG','3078','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103110','projected_crs','EPSG','6531','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102787','projected_crs','EPSG','6262','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102704','projected_crs','EPSG','26852','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102706','projected_crs','EPSG','7142','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102707','projected_crs','EPSG','3421','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102708','projected_crs','EPSG','3422','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102709','projected_crs','EPSG','3423','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103014','projected_crs','EPSG','6432','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','2183','projected_crs','ESRI','102552','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','2182','projected_crs','ESRI','102551','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','2181','projected_crs','ESRI','102550','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','2187','projected_crs','ESRI','102556','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','2186','projected_crs','ESRI','102555','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','2185','projected_crs','ESRI','102554','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','2184','projected_crs','ESRI','102553','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103134','projected_crs','EPSG','6555','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103135','projected_crs','EPSG','6558','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103136','projected_crs','EPSG','6560','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103137','projected_crs','EPSG','6559','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103130','projected_crs','EPSG','6551','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103131','projected_crs','EPSG','6552','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103132','projected_crs','EPSG','6554','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103133','projected_crs','EPSG','6553','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102968','projected_crs','EPSG','6497','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102969','projected_crs','EPSG','6556','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102965','projected_crs','EPSG','6350','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102312','projected_crs','EPSG','2825','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102967','projected_crs','EPSG','6439','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102962','projected_crs','EPSG','6414','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102963','projected_crs','EPSG','6508','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103008','projected_crs','EPSG','6426','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103009','projected_crs','EPSG','6429','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103000','projected_crs','EPSG','6421','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103001','projected_crs','EPSG','6423','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103002','projected_crs','EPSG','6425','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103003','projected_crs','EPSG','6416','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103004','projected_crs','EPSG','6418','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103005','projected_crs','EPSG','6420','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103006','projected_crs','EPSG','6422','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103007','projected_crs','EPSG','6424','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103794','projected_crs','EPSG','4484','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103795','projected_crs','EPSG','4485','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103796','projected_crs','EPSG','4486','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103797','projected_crs','EPSG','4487','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103798','projected_crs','EPSG','4488','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103799','projected_crs','EPSG','4489','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103211','projected_crs','EPSG','4062','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102241','projected_crs','EPSG','2766','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102243','projected_crs','EPSG','2768','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102242','projected_crs','EPSG','2767','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102245','projected_crs','EPSG','2770','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102244','projected_crs','EPSG','2769','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102246','projected_crs','EPSG','2771','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102249','projected_crs','EPSG','2762','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','102248','projected_crs','EPSG','2761','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103099','projected_crs','EPSG','6522','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103098','projected_crs','EPSG','6518','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103097','projected_crs','EPSG','6520','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103096','projected_crs','EPSG','6880','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103095','projected_crs','EPSG','6516','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103094','projected_crs','EPSG','6515','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103093','projected_crs','EPSG','6514','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103092','projected_crs','EPSG','6513','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103091','projected_crs','EPSG','6511','ESRI'); +INSERT INTO "supersession" VALUES('projected_crs','ESRI','103090','projected_crs','EPSG','6512','ESRI'); INSERT INTO alias_name VALUES('vertical_datum','EPSG','1027','EGM2008_Geoid','ESRI'); INSERT INTO alias_name VALUES('vertical_datum','EPSG','1028','Fao_1979','ESRI'); INSERT INTO alias_name VALUES('vertical_datum','EPSG','1039','New_Zealand_Vertical_Datum_2009','ESRI'); @@ -9833,29 +9833,29 @@ INSERT INTO "vertical_datum" VALUES('ESRI','105100','WGS_1984_Geoid',NULL,NULL,' INSERT INTO "vertical_crs" VALUES('ESRI','105700','WGS_1984_Geoid',NULL,NULL,'EPSG','6499','ESRI','105100','EPSG','1262',0); INSERT INTO "vertical_datum" VALUES('ESRI','105101','Dansk_Vertikal_Reference_1990',NULL,NULL,'EPSG','3237',1); INSERT INTO "vertical_crs" VALUES('ESRI','105701','DVR90',NULL,NULL,'EPSG','6499','ESRI','105101','EPSG','3237',1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('vertical_crs','ESRI','105701','EPSG','5799','ESRI'); +INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105701','vertical_crs','EPSG','5799','ESRI'); INSERT INTO "vertical_datum" VALUES('ESRI','105102','Rikets_Hojdsystem_2000',NULL,NULL,'EPSG','3313',1); INSERT INTO "vertical_crs" VALUES('ESRI','105702','RH2000',NULL,NULL,'EPSG','6499','ESRI','105102','EPSG','3313',1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('vertical_crs','ESRI','105702','EPSG','5613','ESRI'); +INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105702','vertical_crs','EPSG','5613','ESRI'); INSERT INTO "vertical_crs" VALUES('ESRI','105703','NAVD88_height_(ftUS)',NULL,NULL,'EPSG','6497','EPSG','5103','EPSG','3664',1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('vertical_crs','ESRI','105703','EPSG','6360','ESRI'); +INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105703','vertical_crs','EPSG','6360','ESRI'); INSERT INTO "vertical_datum" VALUES('ESRI','105104','LAS07',NULL,NULL,'EPSG','3272',0); INSERT INTO "vertical_crs" VALUES('ESRI','105704','LAS07_height',NULL,NULL,'EPSG','6499','ESRI','105104','EPSG','3272',0); INSERT INTO "vertical_datum" VALUES('ESRI','105290','EGM2008_Geoid',NULL,NULL,'EPSG','1262',1); INSERT INTO "vertical_crs" VALUES('ESRI','105790','EGM2008_Geoid',NULL,NULL,'EPSG','6499','ESRI','105290','EPSG','1262',1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('vertical_crs','ESRI','105790','EPSG','3855','ESRI'); +INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105790','vertical_crs','EPSG','3855','ESRI'); INSERT INTO "vertical_datum" VALUES('ESRI','105291','Fao_1979',NULL,NULL,'EPSG','3625',1); INSERT INTO "vertical_crs" VALUES('ESRI','105791','Fao_1979',NULL,NULL,'EPSG','6499','ESRI','105291','EPSG','3625',1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('vertical_crs','ESRI','105791','EPSG','3886','ESRI'); +INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105791','vertical_crs','EPSG','3886','ESRI'); INSERT INTO "vertical_datum" VALUES('ESRI','105292','New_Zealand_Vertical_Datum_2009',NULL,NULL,'EPSG','1175',1); INSERT INTO "vertical_crs" VALUES('ESRI','105792','NZVD2009_height',NULL,NULL,'EPSG','6499','ESRI','105292','EPSG','1175',1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('vertical_crs','ESRI','105792','EPSG','4440','ESRI'); +INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105792','vertical_crs','EPSG','4440','ESRI'); INSERT INTO "vertical_datum" VALUES('ESRI','105293','N2000',NULL,NULL,'EPSG','3333',1); INSERT INTO "vertical_crs" VALUES('ESRI','105793','N2000_height',NULL,NULL,'EPSG','6499','ESRI','105293','EPSG','3333',1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('vertical_crs','ESRI','105793','EPSG','3900','ESRI'); +INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105793','vertical_crs','EPSG','3900','ESRI'); INSERT INTO "vertical_datum" VALUES('ESRI','105294','Dunedin_Bluff_1960',NULL,NULL,'EPSG','3806',1); INSERT INTO "vertical_crs" VALUES('ESRI','105794','Dunedin_Bluff_1960_height',NULL,NULL,'EPSG','6499','ESRI','105294','EPSG','3806',1); -INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('vertical_crs','ESRI','105794','EPSG','4458','ESRI'); +INSERT INTO "supersession" VALUES('vertical_crs','ESRI','105794','vertical_crs','EPSG','4458','ESRI'); -- Skipping WGS_1984. Should be a CompoundCRS -- Skipping ETRS_1989. Should be a CompoundCRS -- Skipping NAD_1983. Should be a CompoundCRS diff --git a/data/sql/proj_db_table_defs.sql b/data/sql/proj_db_table_defs.sql index 126ad375..553dab38 100644 --- a/data/sql/proj_db_table_defs.sql +++ b/data/sql/proj_db_table_defs.sql @@ -916,27 +916,33 @@ END; -- For ESRI stuff -- typically deprecated is the 'wkid' column of deprecated = 'yes' entries in the .csv files, and non_deprecates is the 'latestWkid' column -CREATE TABLE link_from_deprecated_to_non_deprecated( - table_name TEXT NOT NULL CHECK (table_name IN ( +-- For EPSG, used to track superseded coordinate operations. +CREATE TABLE supersession( + superseded_table_name TEXT NOT NULL CHECK (superseded_table_name IN ( + 'unit_of_measure', 'celestial_body', 'ellipsoid', + 'area', 'prime_meridian', 'geodetic_datum', 'vertical_datum', 'geodetic_crs', + 'projected_crs', 'vertical_crs', 'compound_crs', 'conversion', 'grid_transformation', + 'helmert_transformation', 'other_transformation', 'concatenated_operation')), + superseded_auth_name TEXT NOT NULL, + superseded_code TEXT NOT NULL, + replacement_table_name TEXT NOT NULL CHECK (replacement_table_name IN ( 'unit_of_measure', 'celestial_body', 'ellipsoid', 'area', 'prime_meridian', 'geodetic_datum', 'vertical_datum', 'geodetic_crs', 'projected_crs', 'vertical_crs', 'compound_crs', 'conversion', 'grid_transformation', 'helmert_transformation', 'other_transformation', 'concatenated_operation')), - deprecated_auth_name TEXT NOT NULL, - deprecated_code TEXT NOT NULL, - non_deprecated_auth_name TEXT NOT NULL, - non_deprecated_code TEXT NOT NULL, + replacement_auth_name TEXT NOT NULL, + replacement_code TEXT NOT NULL, source TEXT ); -CREATE TRIGGER link_from_deprecated_to_non_deprecated_insert_trigger -BEFORE INSERT ON link_from_deprecated_to_non_deprecated +CREATE TRIGGER supersession_insert_trigger +BEFORE INSERT ON supersession FOR EACH ROW BEGIN - SELECT RAISE(ABORT, 'insert on link_from_deprecated_to_non_deprecated violates constraint: deprecated entry refers to unexisting code') - WHERE NOT EXISTS (SELECT 1 FROM object_view o WHERE o.table_name = NEW.table_name AND o.auth_name = NEW.deprecated_auth_name AND o.code = NEW.deprecated_code); + SELECT RAISE(ABORT, 'insert on supersession violates constraint: superseded entry refers to unexisting code') + WHERE NOT EXISTS (SELECT 1 FROM object_view o WHERE o.table_name = NEW.superseded_table_name AND o.auth_name = NEW.superseded_auth_name AND o.code = NEW.superseded_code); - SELECT RAISE(ABORT, 'insert on link_from_deprecated_to_non_deprecated violates constraint: non_deprecated entry refers to unexisting code') - WHERE NOT EXISTS (SELECT 1 FROM object_view o WHERE o.table_name = NEW.table_name AND o.auth_name = NEW.non_deprecated_auth_name AND o.code = NEW.non_deprecated_code); + SELECT RAISE(ABORT, 'insert on supersession violates constraint: replacement entry refers to unexisting code') + WHERE NOT EXISTS (SELECT 1 FROM object_view o WHERE o.table_name = NEW.replacement_table_name AND o.auth_name = NEW.replacement_auth_name AND o.code = NEW.replacement_code); END; diff --git a/data/sql/supersession.sql b/data/sql/supersession.sql new file mode 100644 index 00000000..83049e11 --- /dev/null +++ b/data/sql/supersession.sql @@ -0,0 +1,191 @@ +--- This file has been generated by scripts/build_db.py. DO NOT EDIT ! + +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1112','helmert_transformation','EPSG','1672','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1154','helmert_transformation','EPSG','1304','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1232','helmert_transformation','EPSG','1305','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1236','helmert_transformation','EPSG','1280','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1236','helmert_transformation','EPSG','1669','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1297','helmert_transformation','EPSG','1298','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1297','helmert_transformation','EPSG','1299','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1297','helmert_transformation','EPSG','1300','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1297','helmert_transformation','EPSG','1301','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1320','helmert_transformation','EPSG','1326','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1321','helmert_transformation','EPSG','1324','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1322','helmert_transformation','EPSG','1324','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1324','helmert_transformation','EPSG','1327','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1325','helmert_transformation','EPSG','1327','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1330','helmert_transformation','EPSG','1557','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1437','helmert_transformation','EPSG','1895','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','1451','grid_transformation','EPSG','1575','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1459','helmert_transformation','EPSG','1594','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','1464','grid_transformation','EPSG','1596','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','1506','grid_transformation','EPSG','1803','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','1507','grid_transformation','EPSG','1803','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','1559','grid_transformation','EPSG','1593','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','1593','grid_transformation','EPSG','1804','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','1596','grid_transformation','EPSG','1803','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1655','helmert_transformation','EPSG','1997','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1657','helmert_transformation','EPSG','1992','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1674','helmert_transformation','EPSG','1775','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1680','helmert_transformation','EPSG','1896','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1683','helmert_transformation','EPSG','1684','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1683','helmert_transformation','EPSG','1685','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1683','helmert_transformation','EPSG','1686','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1683','helmert_transformation','EPSG','1687','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1807','helmert_transformation','EPSG','1808','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1900','helmert_transformation','EPSG','1901','EPSG'); +INSERT INTO "supersession" VALUES('concatenated_operation','EPSG','8047','concatenated_operation','EPSG','8569','EPSG'); +INSERT INTO "supersession" VALUES('concatenated_operation','EPSG','8047','helmert_transformation','EPSG','1612','EPSG'); +INSERT INTO "supersession" VALUES('concatenated_operation','EPSG','8569','helmert_transformation','EPSG','1612','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1638','helmert_transformation','EPSG','10098','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1639','helmert_transformation','EPSG','10099','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1751','helmert_transformation','EPSG','15739','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1066','helmert_transformation','EPSG','15740','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','15781','grid_transformation','EPSG','10084','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15791','helmert_transformation','EPSG','1330','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15817','helmert_transformation','EPSG','15818','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15852','grid_transformation','EPSG','15851','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15853','grid_transformation','EPSG','15851','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15854','grid_transformation','EPSG','15851','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15856','grid_transformation','EPSG','15851','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1309','helmert_transformation','EPSG','1776','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1673','helmert_transformation','EPSG','1777','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1753','helmert_transformation','EPSG','1766','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','15895','grid_transformation','EPSG','15932','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','15907','grid_transformation','EPSG','15933','EPSG'); +INSERT INTO "supersession" VALUES('concatenated_operation','EPSG','8581','helmert_transformation','EPSG','1439','EPSG'); +INSERT INTO "supersession" VALUES('concatenated_operation','EPSG','8657','helmert_transformation','EPSG','15846','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1672','helmert_transformation','EPSG','15934','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1829','helmert_transformation','EPSG','1449','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1830','helmert_transformation','EPSG','1448','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1831','helmert_transformation','EPSG','1242','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15993','helmert_transformation','EPSG','15994','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1656','helmert_transformation','EPSG','1988','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1658','helmert_transformation','EPSG','1987','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1928','helmert_transformation','EPSG','15901','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15783','helmert_transformation','EPSG','15901','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1917','helmert_transformation','EPSG','15902','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1927','helmert_transformation','EPSG','15902','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1962','helmert_transformation','EPSG','15903','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1963','helmert_transformation','EPSG','15903','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','3972','helmert_transformation','EPSG','4834','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','10092','helmert_transformation','EPSG','5051','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1992','helmert_transformation','EPSG','5037','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1281','helmert_transformation','EPSG','5043','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1267','helmert_transformation','EPSG','5044','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1997','helmert_transformation','EPSG','5038','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1550','helmert_transformation','EPSG','5061','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1551','helmert_transformation','EPSG','5061','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1552','helmert_transformation','EPSG','5061','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15710','helmert_transformation','EPSG','5053','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15711','helmert_transformation','EPSG','5051','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15712','helmert_transformation','EPSG','5055','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','10091','helmert_transformation','EPSG','5055','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','10089','helmert_transformation','EPSG','5051','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','10090','helmert_transformation','EPSG','5053','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15872','helmert_transformation','EPSG','5078','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1642','helmert_transformation','EPSG','5485','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1643','helmert_transformation','EPSG','5486','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15754','helmert_transformation','EPSG','5055','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15754','helmert_transformation','EPSG','5053','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15754','helmert_transformation','EPSG','5051','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','10093','helmert_transformation','EPSG','5055','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','10093','helmert_transformation','EPSG','5053','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','10093','helmert_transformation','EPSG','5051','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1079','helmert_transformation','EPSG','5484','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1078','helmert_transformation','EPSG','5483','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10082','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1108','helmert_transformation','EPSG','6905','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10081','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10078','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10039','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10040','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10041','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10042','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10043','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','6392','helmert_transformation','EPSG','6279','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1121','helmert_transformation','EPSG','6906','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10083','grid_transformation','EPSG','5657','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','6315','helmert_transformation','EPSG','6278','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','6313','helmert_transformation','EPSG','6280','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1256','helmert_transformation','EPSG','6908','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1951','helmert_transformation','EPSG','6909','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','5662','helmert_transformation','EPSG','6939','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15938','helmert_transformation','EPSG','6998','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10000','grid_transformation','EPSG','8271','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15800','helmert_transformation','EPSG','6907','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','15897','helmert_transformation','EPSG','6895','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1868','helmert_transformation','EPSG','6976','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1868','helmert_transformation','EPSG','6975','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1868','helmert_transformation','EPSG','6974','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1203','helmert_transformation','EPSG','6971','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1204','helmert_transformation','EPSG','6973','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10063','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10037','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10064','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10066','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10067','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10068','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10069','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','5334','grid_transformation','EPSG','7718','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','5335','grid_transformation','EPSG','7719','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10001','grid_transformation','EPSG','8271','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10058','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10059','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10060','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10061','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10062','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1646','grid_transformation','EPSG','7674','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10034','grid_transformation','EPSG','7713','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10070','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10031','grid_transformation','EPSG','7713','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10030','grid_transformation','EPSG','7713','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10026','grid_transformation','EPSG','7713','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10071','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10025','grid_transformation','EPSG','7713','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10024','grid_transformation','EPSG','7713','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10072','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10033','grid_transformation','EPSG','7715','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10032','grid_transformation','EPSG','7716','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10021','grid_transformation','EPSG','7711','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10029','grid_transformation','EPSG','7712','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1766','grid_transformation','EPSG','7788','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10027','grid_transformation','EPSG','7714','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10023','grid_transformation','EPSG','7717','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10002','grid_transformation','EPSG','8272','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10073','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10038','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10074','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10035','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10044','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10045','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10046','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10047','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10048','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10049','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10050','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10051','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10052','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10053','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10036','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10054','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10055','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10056','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10057','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10075','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10076','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','5338','grid_transformation','EPSG','7709','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','5339','grid_transformation','EPSG','7710','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10077','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10079','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10080','grid_transformation','EPSG','5656','EPSG'); +INSERT INTO "supersession" VALUES('grid_transformation','EPSG','10003','grid_transformation','EPSG','8272','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','1923','helmert_transformation','EPSG','8270','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','4829','concatenated_operation','EPSG','8443','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','4827','concatenated_operation','EPSG','8443','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','4827','concatenated_operation','EPSG','8442','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','4829','concatenated_operation','EPSG','8442','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','3917','helmert_transformation','EPSG','8688','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','3915','helmert_transformation','EPSG','8688','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','3916','helmert_transformation','EPSG','8689','EPSG'); +INSERT INTO "supersession" VALUES('helmert_transformation','EPSG','3914','helmert_transformation','EPSG','8689','EPSG'); diff --git a/data/sql_filelist.cmake b/data/sql_filelist.cmake index 6353949f..09e45716 100644 --- a/data/sql_filelist.cmake +++ b/data/sql_filelist.cmake @@ -22,6 +22,7 @@ set(SQL_FILES "${SQL_DIR}/begin.sql" "${SQL_DIR}/other_transformation.sql" "${SQL_DIR}/concatenated_operation.sql" "${SQL_DIR}/alias_name.sql" + "${SQL_DIR}/supersession.sql" "${SQL_DIR}/esri.sql" "${SQL_DIR}/ignf.sql" "${SQL_DIR}/grid_alternatives.sql" diff --git a/include/proj/coordinateoperation.hpp b/include/proj/coordinateoperation.hpp index 4dd85e96..f5cdbba0 100644 --- a/include/proj/coordinateoperation.hpp +++ b/include/proj/coordinateoperation.hpp @@ -1680,6 +1680,10 @@ class PROJ_GCC_DLL CoordinateOperationContext { PROJ_DLL bool getUsePROJAlternativeGridNames() const; + PROJ_DLL void setDiscardSuperseded(bool discard); + + PROJ_DLL bool getDiscardSuperseded() const; + /** Describe how grid availability is used. */ enum class GridAvailabilityUse { /** Grid availability is only used for sorting results. Operations diff --git a/include/proj/io.hpp b/include/proj/io.hpp index 77ca1d2d..26420150 100644 --- a/include/proj/io.hpp +++ b/include/proj/io.hpp @@ -887,13 +887,15 @@ class PROJ_GCC_DLL AuthorityFactory { createFromCoordinateReferenceSystemCodes( const std::string &sourceCRSAuthName, const std::string &sourceCRSCode, const std::string &targetCRSAuthName, const std::string &targetCRSCode, - bool usePROJAlternativeGridNames, bool discardIfMissingGrid) const; + bool usePROJAlternativeGridNames, bool discardIfMissingGrid, + bool discardSuperseded) const; PROJ_DLL std::vector<operation::CoordinateOperationNNPtr> createFromCRSCodesWithIntermediates( const std::string &sourceCRSAuthName, const std::string &sourceCRSCode, const std::string &targetCRSAuthName, const std::string &targetCRSCode, bool usePROJAlternativeGridNames, bool discardIfMissingGrid, + bool discardSuperseded, const std::vector<std::pair<std::string, std::string>> &intermediateCRSAuthCodes) const; diff --git a/scripts/build_db.py b/scripts/build_db.py index 77f53fd9..46bef8c8 100755 --- a/scripts/build_db.py +++ b/scripts/build_db.py @@ -518,6 +518,33 @@ def fill_alias(proj_db_cursor): else: print('Cannot find datum %s in geodetic_datum or vertical_datum' % (code)) + +def find_table(proj_db_cursor, code): + for table_name in ('helmert_transformation', 'grid_transformation', 'concatenated_operation'): + proj_db_cursor.execute('SELECT name FROM %s WHERE code = ?' % table_name, (code,)) + row = proj_db_cursor.fetchone() + if row is not None: + return row[0], table_name + return None + +def fill_supersession(proj_db_cursor): + proj_db_cursor.execute("SELECT object_code, superseded_by FROM epsg.epsg_supersession WHERE object_table_name = 'epsg_coordoperation' AND object_code != superseded_by") + for row in proj_db_cursor.fetchall(): + code, superseded_by = row + proj_db_cursor.execute('SELECT 1 FROM coordinate_operation_view WHERE code = ?', (code,)) + if proj_db_cursor.fetchone() is None: + print('Skipping supersession of %d since it has not been imported' % code) + continue + + src_name, superseded_table_name = find_table(proj_db_cursor, code) + dst_name, replacement_table_name = find_table(proj_db_cursor, superseded_by) + assert superseded_table_name, row + assert replacement_table_name, row + if superseded_table_name == 'grid_transformation' and replacement_table_name == 'grid_transformation' and src_name.startswith('NAD27 to NAD83'): + print('Skipping supersession of %d (%s) by %d (%s)' % (code, src_name, superseded_by, dst_name)) + continue + proj_db_cursor.execute("INSERT INTO supersession VALUES (?,'EPSG',?,?,'EPSG',?,'EPSG')", (superseded_table_name, code, replacement_table_name, superseded_by)) + def report_non_imported_operations(proj_db_cursor): proj_db_cursor.execute("SELECT coord_op_code, coord_op_type, coord_op_name, coord_op_method_code, coord_op_method_name, source_crs_code, target_crs_code, area_of_use_code, coord_op_accuracy, epsg_coordoperation.deprecated FROM epsg.epsg_coordoperation LEFT JOIN epsg.epsg_coordoperationmethod USING (coord_op_method_code) WHERE coord_op_code NOT IN (SELECT code FROM coordinate_operation_with_conversion_view)") rows = [] @@ -563,6 +590,7 @@ fill_grid_transformation(proj_db_cursor) fill_other_transformation(proj_db_cursor) fill_concatenated_operation(proj_db_cursor) fill_alias(proj_db_cursor) +fill_supersession(proj_db_cursor) non_imported_operations = report_non_imported_operations(proj_db_cursor) proj_db_cursor.close() diff --git a/scripts/build_db_from_esri.py b/scripts/build_db_from_esri.py index 2bc4a528..4f89f59f 100755 --- a/scripts/build_db_from_esri.py +++ b/scripts/build_db_from_esri.py @@ -609,7 +609,7 @@ def import_geogcs(): src_row = cursor.fetchone() assert src_row - sql = """INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('geodetic_crs','ESRI','%s','EPSG','%s','ESRI');""" % ( + sql = """INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','%s','geodetic_crs','EPSG','%s','ESRI');""" % ( code, latestWkid) all_sql.append(sql) @@ -728,7 +728,7 @@ def import_projcs(): latestWkid = mapDeprecatedToNonDeprecated[deprecated] if latestWkid in wkid_set: - sql = """INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','%s','ESRI','%s','ESRI');""" % ( + sql = """INSERT INTO "supersession" VALUES('projected_crs','ESRI','%s','projected_crs','ESRI','%s','ESRI');""" % ( code, latestWkid) all_sql.append(sql) else: @@ -736,7 +736,7 @@ def import_projcs(): "SELECT name FROM projected_crs WHERE auth_name = 'EPSG' AND code = ?", (latestWkid,)) src_row = cursor.fetchone() assert src_row, row - sql = """INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('projected_crs','ESRI','%s','EPSG','%s','ESRI');""" % ( + sql = """INSERT INTO "supersession" VALUES('projected_crs','ESRI','%s','projected_crs','EPSG','%s','ESRI');""" % ( code, latestWkid) all_sql.append(sql) @@ -962,7 +962,7 @@ def import_vertcs(): src_row = cursor.fetchone() assert src_row - sql = """INSERT INTO "link_from_deprecated_to_non_deprecated" VALUES('vertical_crs','ESRI','%s','EPSG','%s','ESRI');""" % ( + sql = """INSERT INTO "supersession" VALUES('vertical_crs','ESRI','%s','vertical_crs','EPSG','%s','ESRI');""" % ( code, latestWkid) all_sql.append(sql) diff --git a/src/coordinateoperation.cpp b/src/coordinateoperation.cpp index a58cfdbe..04f9bc9a 100644 --- a/src/coordinateoperation.cpp +++ b/src/coordinateoperation.cpp @@ -8683,6 +8683,7 @@ struct CoordinateOperationContext::Private { bool allowUseIntermediateCRS_ = true; std::vector<std::pair<std::string, std::string>> intermediateCRSAuthCodes_{}; + bool discardSuperseded_ = true; }; //! @endcond @@ -8823,6 +8824,29 @@ bool CoordinateOperationContext::getUsePROJAlternativeGridNames() const { // --------------------------------------------------------------------------- +/** \brief Return whether transformations that are superseded (but not + * deprecated) + * should be discarded. + * + * The default is true. + */ +bool CoordinateOperationContext::getDiscardSuperseded() const { + return d->discardSuperseded_; +} + +// --------------------------------------------------------------------------- + +/** \brief Set whether transformations that are superseded (but not deprecated) + * should be discarded. + * + * The default is true. + */ +void CoordinateOperationContext::setDiscardSuperseded(bool discard) { + d->discardSuperseded_ = discard; +} + +// --------------------------------------------------------------------------- + /** \brief Set how grid availability is used. * * The default is USE_FOR_SORTING. @@ -9654,7 +9678,8 @@ findOpsInRegistryDirect(const crs::CRSNNPtr &sourceCRS, context->getGridAvailabilityUse() == CoordinateOperationContext:: GridAvailabilityUse:: - DISCARD_OPERATION_IF_MISSING_GRID); + DISCARD_OPERATION_IF_MISSING_GRID, + context->getDiscardSuperseded()); if (!res.empty()) { return res; } @@ -9695,6 +9720,7 @@ static std::vector<CoordinateOperationNNPtr> findsOpsInRegistryWithIntermediate( context->getGridAvailabilityUse() == CoordinateOperationContext::GridAvailabilityUse:: DISCARD_OPERATION_IF_MISSING_GRID, + context->getDiscardSuperseded(), context->getIntermediateCRS()); if (!res.empty()) { return res; diff --git a/src/factory.cpp b/src/factory.cpp index 96cf9bec..e24cee58 100644 --- a/src/factory.cpp +++ b/src/factory.cpp @@ -3046,7 +3046,7 @@ AuthorityFactory::createFromCoordinateReferenceSystemCodes( const std::string &sourceCRSCode, const std::string &targetCRSCode) const { return createFromCoordinateReferenceSystemCodes( getAuthority(), sourceCRSCode, getAuthority(), targetCRSCode, false, - false); + false, false); } // --------------------------------------------------------------------------- @@ -3075,6 +3075,8 @@ AuthorityFactory::createFromCoordinateReferenceSystemCodes( * should be substituted to the official grid names. * @param discardIfMissingGrid Whether coordinate operations that reference * missing grids should be removed from the result set. + * @param discardSuperseded Whether cordinate operations that are superseded + * (but not deprecated) should be removed from the result set. * @return list of coordinate operations * @throw NoSuchAuthorityCodeException * @throw FactoryException @@ -3084,7 +3086,8 @@ std::vector<operation::CoordinateOperationNNPtr> AuthorityFactory::createFromCoordinateReferenceSystemCodes( const std::string &sourceCRSAuthName, const std::string &sourceCRSCode, const std::string &targetCRSAuthName, const std::string &targetCRSCode, - bool usePROJAlternativeGridNames, bool discardIfMissingGrid) const { + bool usePROJAlternativeGridNames, bool discardIfMissingGrid, + bool discardSuperseded) const { std::vector<operation::CoordinateOperationNNPtr> list; // Look-up first for conversion which is the most precise. @@ -3106,13 +3109,29 @@ AuthorityFactory::createFromCoordinateReferenceSystemCodes( list.emplace_back(conv); return list; } - sql = - "SELECT cov.auth_name, cov.code FROM " - "coordinate_operation_view cov JOIN area ON cov.area_of_use_auth_name " - "= area.auth_name AND cov.area_of_use_code = area.code WHERE " - "source_crs_auth_name = ? AND source_crs_code = ? AND " - "target_crs_auth_name = ? AND target_crs_code = ? AND " - "cov.deprecated != 1"; + if (discardSuperseded) { + sql = "SELECT cov.auth_name, cov.code, " + "ss.replacement_auth_name, ss.replacement_code FROM " + "coordinate_operation_view cov JOIN area " + "ON cov.area_of_use_auth_name = area.auth_name AND " + "cov.area_of_use_code = area.code " + "LEFT JOIN supersession ss ON " + "ss.superseded_table_name = cov.table_name AND " + "ss.superseded_auth_name = cov.auth_name AND " + "ss.superseded_code = cov.code AND " + "ss.superseded_table_name = ss.replacement_table_name " + "WHERE source_crs_auth_name = ? AND source_crs_code = ? AND " + "target_crs_auth_name = ? AND target_crs_code = ? AND " + "cov.deprecated != 1"; + } else { + sql = "SELECT cov.auth_name, cov.code FROM " + "coordinate_operation_view cov JOIN area " + "ON cov.area_of_use_auth_name = area.auth_name AND " + "cov.area_of_use_code = area.code " + "WHERE source_crs_auth_name = ? AND source_crs_code = ? AND " + "target_crs_auth_name = ? AND target_crs_code = ? AND " + "cov.deprecated != 1"; + } params = {sourceCRSAuthName, sourceCRSCode, targetCRSAuthName, targetCRSCode}; if (!getAuthority().empty()) { @@ -3123,7 +3142,29 @@ AuthorityFactory::createFromCoordinateReferenceSystemCodes( "east_lon) DESC, " "(CASE WHEN accuracy is NULL THEN 1 ELSE 0 END), accuracy"; res = d->run(sql, params); + std::set<std::pair<std::string, std::string>> setTransf; + if (discardSuperseded) { + for (const auto &row : res) { + const auto &auth_name = row[0]; + const auto &code = row[1]; + setTransf.insert( + std::pair<std::string, std::string>(auth_name, code)); + } + } for (const auto &row : res) { + if (discardSuperseded) { + const auto &replacement_auth_name = row[2]; + const auto &replacement_code = row[3]; + if (!replacement_auth_name.empty() && + setTransf.find(std::pair<std::string, std::string>( + replacement_auth_name, replacement_code)) != + setTransf.end()) { + // Skip transformations that are superseded by others that got + // returned in the result set. + continue; + } + } + const auto &auth_name = row[0]; const auto &code = row[1]; auto op = d->createFactory(auth_name)->createCoordinateOperation( @@ -3218,6 +3259,8 @@ static bool useIrrelevantPivot(const operation::CoordinateOperationNNPtr &op, * should be substituted to the official grid names. * @param discardIfMissingGrid Whether coordinate operations that reference * missing grids should be removed from the result set. + * @param discardSuperseded Whether cordinate operations that are superseded + * (but not deprecated) should be removed from the result set. * @param intermediateCRSAuthCodes List of (auth_name, code) of CRS that can be * used as potential intermediate CRS. If the list is empty, the database will * be used to find common CRS in operations involving both the source and @@ -3232,6 +3275,7 @@ AuthorityFactory::createFromCRSCodesWithIntermediates( const std::string &sourceCRSAuthName, const std::string &sourceCRSCode, const std::string &targetCRSAuthName, const std::string &targetCRSCode, bool usePROJAlternativeGridNames, bool discardIfMissingGrid, + bool discardSuperseded, const std::vector<std::pair<std::string, std::string>> &intermediateCRSAuthCodes) const { @@ -3243,21 +3287,57 @@ AuthorityFactory::createFromCRSCodesWithIntermediates( } const std::string sqlProlog( - "SELECT v1.auth_name AS auth_name1, v1.code AS code1, " - "v1.accuracy AS accuracy1, " - "v2.auth_name AS auth_name2, v2.code AS code2, " - "v2.accuracy as accuracy2, " - "a1.south_lat AS south_lat1, " - "a1.west_lon AS west_lon1, " - "a1.north_lat AS north_lat1, " - "a1.east_lon AS east_lon1, " - "a2.south_lat AS south_lat2, " - "a2.west_lon AS west_lon2, " - "a2.north_lat AS north_lat2, " - "a2.east_lon AS east_lon2 " - "FROM coordinate_operation_view v1 " - "JOIN coordinate_operation_view v2 "); + discardSuperseded + ? + + "SELECT v1.auth_name AS auth_name1, v1.code AS code1, " + "v1.accuracy AS accuracy1, " + "v2.auth_name AS auth_name2, v2.code AS code2, " + "v2.accuracy as accuracy2, " + "a1.south_lat AS south_lat1, " + "a1.west_lon AS west_lon1, " + "a1.north_lat AS north_lat1, " + "a1.east_lon AS east_lon1, " + "a2.south_lat AS south_lat2, " + "a2.west_lon AS west_lon2, " + "a2.north_lat AS north_lat2, " + "a2.east_lon AS east_lon2, " + "ss1.replacement_auth_name AS replacement_auth_name1, " + "ss1.replacement_code AS replacement_code1, " + "ss2.replacement_auth_name AS replacement_auth_name2, " + "ss2.replacement_code AS replacement_code2 " + "FROM coordinate_operation_view v1 " + "JOIN coordinate_operation_view v2 " + : + + "SELECT v1.auth_name AS auth_name1, v1.code AS code1, " + "v1.accuracy AS accuracy1, " + "v2.auth_name AS auth_name2, v2.code AS code2, " + "v2.accuracy as accuracy2, " + "a1.south_lat AS south_lat1, " + "a1.west_lon AS west_lon1, " + "a1.north_lat AS north_lat1, " + "a1.east_lon AS east_lon1, " + "a2.south_lat AS south_lat2, " + "a2.west_lon AS west_lon2, " + "a2.north_lat AS north_lat2, " + "a2.east_lon AS east_lon2 " + "FROM coordinate_operation_view v1 " + "JOIN coordinate_operation_view v2 "); + + const std::string joinSupersession( + "LEFT JOIN supersession ss1 ON " + "ss1.superseded_table_name = v1.table_name AND " + "ss1.superseded_auth_name = v1.auth_name AND " + "ss1.superseded_code = v1.code AND " + "ss1.superseded_table_name = ss1.replacement_table_name " + "LEFT JOIN supersession ss2 ON " + "ss2.superseded_table_name = v2.table_name AND " + "ss2.superseded_auth_name = v2.auth_name AND " + "ss2.superseded_code = v2.code AND " + "ss2.superseded_table_name = ss2.replacement_table_name "); const std::string joinArea( + (discardSuperseded ? joinSupersession : std::string()) + "JOIN area a1 ON v1.area_of_use_auth_name = a1.auth_name " "AND v1.area_of_use_code = a1.code " "JOIN area a2 ON v2.area_of_use_auth_name = a2.auth_name " @@ -3297,6 +3377,50 @@ AuthorityFactory::createFromCRSCodesWithIntermediates( auto res = d->run(sql + additionalWhere + intermediateWhere + orderBy, params); + const auto filterOutSuperseded = [](SQLResultSet &&resultSet) { + std::set<std::pair<std::string, std::string>> setTransf1; + std::set<std::pair<std::string, std::string>> setTransf2; + for (const auto &row : resultSet) { + const auto &auth_name1 = row[0]; + const auto &code1 = row[1]; + // const auto &accuracy1 = row[2]; + const auto &auth_name2 = row[3]; + const auto &code2 = row[4]; + setTransf1.insert( + std::pair<std::string, std::string>(auth_name1, code1)); + setTransf2.insert( + std::pair<std::string, std::string>(auth_name2, code2)); + } + SQLResultSet filteredResultSet; + for (const auto &row : resultSet) { + const auto &replacement_auth_name1 = row[14]; + const auto &replacement_code1 = row[15]; + const auto &replacement_auth_name2 = row[16]; + const auto &replacement_code2 = row[17]; + if (!replacement_auth_name1.empty() && + setTransf1.find(std::pair<std::string, std::string>( + replacement_auth_name1, replacement_code1)) != + setTransf1.end()) { + // Skip transformations that are superseded by others that got + // returned in the result set. + continue; + } + if (!replacement_auth_name2.empty() && + setTransf2.find(std::pair<std::string, std::string>( + replacement_auth_name2, replacement_code2)) != + setTransf2.end()) { + // Skip transformations that are superseded by others that got + // returned in the result set. + continue; + } + filteredResultSet.emplace_back(row); + } + return filteredResultSet; + }; + + if (discardSuperseded) { + res = filterOutSuperseded(std::move(res)); + } for (const auto &row : res) { const auto &auth_name1 = row[0]; const auto &code1 = row[1]; @@ -3333,6 +3457,9 @@ AuthorityFactory::createFromCRSCodesWithIntermediates( intermediateWhere = buildIntermediateWhere(intermediateCRSAuthCodes, "target", "target"); res = d->run(sql + additionalWhere + intermediateWhere + orderBy, params); + if (discardSuperseded) { + res = filterOutSuperseded(std::move(res)); + } for (const auto &row : res) { const auto &auth_name1 = row[0]; const auto &code1 = row[1]; @@ -3369,6 +3496,9 @@ AuthorityFactory::createFromCRSCodesWithIntermediates( intermediateWhere = buildIntermediateWhere(intermediateCRSAuthCodes, "source", "source"); res = d->run(sql + additionalWhere + intermediateWhere + orderBy, params); + if (discardSuperseded) { + res = filterOutSuperseded(std::move(res)); + } for (const auto &row : res) { const auto &auth_name1 = row[0]; const auto &code1 = row[1]; @@ -3405,6 +3535,9 @@ AuthorityFactory::createFromCRSCodesWithIntermediates( intermediateWhere = buildIntermediateWhere(intermediateCRSAuthCodes, "source", "target"); res = d->run(sql + additionalWhere + intermediateWhere + orderBy, params); + if (discardSuperseded) { + res = filterOutSuperseded(std::move(res)); + } for (const auto &row : res) { const auto &auth_name1 = row[0]; const auto &code1 = row[1]; diff --git a/src/projinfo.cpp b/src/projinfo.cpp index d13b5ee5..ddcc09da 100644 --- a/src/projinfo.cpp +++ b/src/projinfo.cpp @@ -80,7 +80,8 @@ static void usage() { << " [--spatial-test contains|intersects]" << std::endl << " [--crs-extent-use none|both|intersection|smallest]" << std::endl - << " [--grid-check none|discard_missing|sort]" + << " [--grid-check none|discard_missing|sort] " + "[--show-superseded]" << std::endl << " [--pivot-crs none|{auth:code[,auth:code]*}]" << std::endl @@ -477,7 +478,7 @@ static void outputOperations( bool allowPivots, const std::vector<std::pair<std::string, std::string>> &pivots, const std::string &authority, bool usePROJGridAlternatives, - const OutputOptions &outputOpt, bool summary) { + bool showSuperseded, const OutputOptions &outputOpt, bool summary) { auto sourceObj = buildObject(dbContext, sourceCRSStr, true, "source CRS", false); auto sourceCRS = nn_dynamic_pointer_cast<CRS>(sourceObj); @@ -509,6 +510,7 @@ static void outputOperations( ctxt->setAllowUseIntermediateCRS(allowPivots); ctxt->setIntermediateCRS(pivots); ctxt->setUsePROJAlternativeGridNames(usePROJGridAlternatives); + ctxt->setDiscardSuperseded(!showSuperseded); list = CoordinateOperationFactory::create()->createOperations( NN_NO_CHECK(sourceCRS), NN_NO_CHECK(targetCRS), ctxt); } catch (const std::exception &e) { @@ -582,6 +584,7 @@ int main(int argc, char **argv) { bool guessDialect = false; std::string authority; bool identify = false; + bool showSuperseded = false; for (int i = 1; i < argc; i++) { std::string arg(argv[i]); @@ -807,6 +810,8 @@ int main(int argc, char **argv) { authority = argv[i]; } else if (arg == "--identify") { identify = true; + } else if (arg == "--show-superseded") { + showSuperseded = true; } else if (arg == "-?" || arg == "--help") { usage(); } else if (arg[0] == '-') { @@ -1000,10 +1005,10 @@ int main(int argc, char **argv) { } } - outputOperations(dbContext, sourceCRSStr, targetCRSStr, bboxFilter, - spatialCriterion, crsExtentUse, gridAvailabilityUse, - allowPivots, pivots, authority, - usePROJGridAlternatives, outputOpt, summary); + outputOperations( + dbContext, sourceCRSStr, targetCRSStr, bboxFilter, spatialCriterion, + crsExtentUse, gridAvailabilityUse, allowPivots, pivots, authority, + usePROJGridAlternatives, showSuperseded, outputOpt, summary); } return 0; diff --git a/test/unit/test_factory.cpp b/test/unit/test_factory.cpp index d3976688..9ca844b1 100644 --- a/test/unit/test_factory.cpp +++ b/test/unit/test_factory.cpp @@ -1511,32 +1511,35 @@ class FactoryWithTmpDatabase : public ::testing::Test { auto factoryOTHER = AuthorityFactory::create( DatabaseContext::create(m_ctxt), "OTHER"); auto res = factoryOTHER->createFromCRSCodesWithIntermediates( - "NS_SOURCE", "SOURCE", "NS_TARGET", "TARGET", false, false, {}); + "NS_SOURCE", "SOURCE", "NS_TARGET", "TARGET", false, false, + false, {}); EXPECT_EQ(res.size(), 1); EXPECT_TRUE(res.empty() || nn_dynamic_pointer_cast<ConcatenatedOperation>(res[0])); res = factoryOTHER->createFromCRSCodesWithIntermediates( "NS_SOURCE", "SOURCE", "NS_TARGET", "TARGET", false, false, - {std::make_pair(std::string("NS_PIVOT"), - std::string("PIVOT"))}); + false, {std::make_pair(std::string("NS_PIVOT"), + std::string("PIVOT"))}); EXPECT_EQ(res.size(), 1); EXPECT_TRUE(res.empty() || nn_dynamic_pointer_cast<ConcatenatedOperation>(res[0])); res = factoryOTHER->createFromCRSCodesWithIntermediates( "NS_SOURCE", "SOURCE", "NS_TARGET", "TARGET", false, false, - {std::make_pair(std::string("NS_PIVOT"), - std::string("NOT_EXISTING"))}); + false, {std::make_pair(std::string("NS_PIVOT"), + std::string("NOT_EXISTING"))}); EXPECT_EQ(res.size(), 0); res = factoryOTHER->createFromCRSCodesWithIntermediates( "NS_SOURCE", "SOURCE", "NS_TARGET", "TARGET", false, false, + false, {std::make_pair(std::string("BAD_NS"), std::string("PIVOT"))}); EXPECT_EQ(res.size(), 0); res = factoryOTHER->createFromCRSCodesWithIntermediates( - "NS_TARGET", "TARGET", "NS_SOURCE", "SOURCE", false, false, {}); + "NS_TARGET", "TARGET", "NS_SOURCE", "SOURCE", false, false, + false, {}); EXPECT_EQ(res.size(), 1); EXPECT_TRUE(res.empty() || nn_dynamic_pointer_cast<ConcatenatedOperation>(res[0])); @@ -1545,7 +1548,8 @@ class FactoryWithTmpDatabase : public ::testing::Test { auto factory = AuthorityFactory::create( DatabaseContext::create(m_ctxt), std::string()); auto res = factory->createFromCRSCodesWithIntermediates( - "NS_SOURCE", "SOURCE", "NS_TARGET", "TARGET", false, false, {}); + "NS_SOURCE", "SOURCE", "NS_TARGET", "TARGET", false, false, + false, {}); EXPECT_EQ(res.size(), 1); EXPECT_TRUE(res.empty() || nn_dynamic_pointer_cast<ConcatenatedOperation>(res[0])); @@ -1720,6 +1724,15 @@ TEST(factory, AuthorityFactory_createFromCoordinateReferenceSystemCodes) { EXPECT_EQ(list[1]->getEPSGCode(), 15993); // Romania - 10m EXPECT_EQ(list[2]->getEPSGCode(), 1644); // Poland - 1m } + { + // Test removal of superseded transform + auto list = factory->createFromCoordinateReferenceSystemCodes( + "EPSG", "4179", "EPSG", "4258", false, false, true); + ASSERT_EQ(list.size(), 2); + // Romania has a larger area than Poland (given our approx formula) + EXPECT_EQ(list[0]->getEPSGCode(), 15994); // Romania - 3m + EXPECT_EQ(list[1]->getEPSGCode(), 1644); // Poland - 1m + } } // --------------------------------------------------------------------------- @@ -1732,12 +1745,12 @@ TEST( { auto res = factory->createFromCoordinateReferenceSystemCodes( - "EPSG", "4326", "EPSG", "32631", false, false); + "EPSG", "4326", "EPSG", "32631", false, false, false); ASSERT_EQ(res.size(), 1); } { auto res = factory->createFromCoordinateReferenceSystemCodes( - "EPSG", "4209", "EPSG", "4326", false, false); + "EPSG", "4209", "EPSG", "4326", false, false, false); EXPECT_TRUE(!res.empty()); for (const auto &conv : res) { EXPECT_TRUE(conv->sourceCRS()->getEPSGCode() == 4209); @@ -1770,7 +1783,7 @@ TEST_F(FactoryWithTmpDatabase, DatabaseContext::create(m_ctxt), std::string()); { auto res = factoryGeneral->createFromCoordinateReferenceSystemCodes( - "OTHER", "OTHER_4326", "OTHER", "OTHER_32631", false, false); + "OTHER", "OTHER_4326", "OTHER", "OTHER_32631", false, false, false); ASSERT_EQ(res.size(), 1); } @@ -1778,7 +1791,7 @@ TEST_F(FactoryWithTmpDatabase, AuthorityFactory::create(DatabaseContext::create(m_ctxt), "EPSG"); { auto res = factoryEPSG->createFromCoordinateReferenceSystemCodes( - "OTHER", "OTHER_4326", "OTHER", "OTHER_32631", false, false); + "OTHER", "OTHER_4326", "OTHER", "OTHER_32631", false, false, false); ASSERT_EQ(res.size(), 1); } @@ -1800,17 +1813,17 @@ TEST_F(FactoryWithTmpDatabase, << last_error(); { auto res = factoryGeneral->createFromCoordinateReferenceSystemCodes( - "EPSG", "4326", "OTHER", "OTHER_4326", false, false); + "EPSG", "4326", "OTHER", "OTHER_4326", false, false, false); ASSERT_EQ(res.size(), 1); } { auto res = factoryEPSG->createFromCoordinateReferenceSystemCodes( - "EPSG", "4326", "OTHER", "OTHER_4326", false, false); + "EPSG", "4326", "OTHER", "OTHER_4326", false, false, false); ASSERT_EQ(res.size(), 0); } { auto res = factoryOTHER->createFromCoordinateReferenceSystemCodes( - "EPSG", "4326", "OTHER", "OTHER_4326", false, false); + "EPSG", "4326", "OTHER", "OTHER_4326", false, false, false); ASSERT_EQ(res.size(), 1); } } @@ -1861,7 +1874,7 @@ TEST_F(FactoryWithTmpDatabase, auto factoryOTHER = AuthorityFactory::create(DatabaseContext::create(m_ctxt), "OTHER"); auto res = factoryOTHER->createFromCoordinateReferenceSystemCodes( - "EPSG", "4326", "EPSG", "4326", false, false); + "EPSG", "4326", "EPSG", "4326", false, false, false); ASSERT_EQ(res.size(), 3); EXPECT_EQ(*(res[0]->name()->description()), "TRANSFORMATION_1M"); EXPECT_EQ(*(res[1]->name()->description()), "TRANSFORMATION_10M"); @@ -1880,7 +1893,7 @@ TEST_F( auto factory = AuthorityFactory::create(DatabaseContext::create(m_ctxt), std::string()); auto res = factory->createFromCRSCodesWithIntermediates( - "EPSG", "4326", "EPSG", "4326", false, false, {}); + "EPSG", "4326", "EPSG", "4326", false, false, false, {}); EXPECT_EQ(res.size(), 0); } @@ -1964,7 +1977,7 @@ TEST_F(FactoryWithTmpDatabase, AuthorityFactory_proj_based_transformation) { auto factoryOTHER = AuthorityFactory::create(DatabaseContext::create(m_ctxt), "OTHER"); auto res = factoryOTHER->createFromCoordinateReferenceSystemCodes( - "EPSG", "4326", "EPSG", "4326", false, false); + "EPSG", "4326", "EPSG", "4326", false, false, false); ASSERT_EQ(res.size(), 1); EXPECT_EQ(res[0]->nameStr(), "My PROJ string based op"); EXPECT_EQ(res[0]->exportToPROJString(PROJStringFormatter::create().get()), @@ -2025,7 +2038,7 @@ TEST_F(FactoryWithTmpDatabase, AuthorityFactory_wkt_based_transformation) { auto factoryOTHER = AuthorityFactory::create(DatabaseContext::create(m_ctxt), "OTHER"); auto res = factoryOTHER->createFromCoordinateReferenceSystemCodes( - "EPSG", "4326", "EPSG", "4326", false, false); + "EPSG", "4326", "EPSG", "4326", false, false, false); ASSERT_EQ(res.size(), 1); EXPECT_EQ(res[0]->nameStr(), "My WKT string based op"); EXPECT_EQ(res[0]->exportToPROJString(PROJStringFormatter::create().get()), @@ -2059,7 +2072,7 @@ TEST_F(FactoryWithTmpDatabase, auto factoryOTHER = AuthorityFactory::create(DatabaseContext::create(m_ctxt), "OTHER"); EXPECT_THROW(factoryOTHER->createFromCoordinateReferenceSystemCodes( - "EPSG", "4326", "EPSG", "4326", false, false), + "EPSG", "4326", "EPSG", "4326", false, false, false), FactoryException); } @@ -2086,7 +2099,7 @@ TEST_F(FactoryWithTmpDatabase, auto factoryOTHER = AuthorityFactory::create(DatabaseContext::create(m_ctxt), "OTHER"); EXPECT_THROW(factoryOTHER->createFromCoordinateReferenceSystemCodes( - "EPSG", "4326", "EPSG", "4326", false, false), + "EPSG", "4326", "EPSG", "4326", false, false, false), FactoryException); } |