From 6d6229ca7be13f8509889a502d9e6e5ce4cc7c46 Mon Sep 17 00:00:00 2001 From: jmckenna Date: Fri, 31 Jul 2020 17:53:22 -0300 Subject: Database: update to EPSG v9.8.15 database Co-authored-by: jmckenna Co-authored-by: Javier Jimenez Shaw Co-authored-by: Even Rouault --- data/sql/alias_name.sql | 58 ++++++++++++++++++++++++++++++++++++++++++++----- 1 file changed, 53 insertions(+), 5 deletions(-) (limited to 'data/sql/alias_name.sql') diff --git a/data/sql/alias_name.sql b/data/sql/alias_name.sql index 326c0745..7b5dd59d 100644 --- a/data/sql/alias_name.sql +++ b/data/sql/alias_name.sql @@ -347,7 +347,7 @@ INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1147','ONGD14','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1031','D48','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6805','MGI (Ferro)','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1033','RGRDC 2005','EPSG'); -INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6728','Pico de las Nieves','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','5207','HVRD71','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6728','PN84','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1027','EGM2008','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1152','WGS 84 (G730)','EPSG'); @@ -356,10 +356,19 @@ INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','5203','EGM84','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1154','WGS 84 (G1150)','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','5171','EGM96','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1155','WGS 84 (G1674)','EPSG'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1273','AbInvA96_2020-IRF','EPSG'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6903','Madrid','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1156','WGS 84 (G1762)','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1157','PZ-90.02','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1158','PZ-90.11','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1274','EVRF2019','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1275','REDNAP','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1276','REDNAP','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1277','REDNAP','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1160','Kyrg-06','EPSG'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1286','PN68','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1278','REDNAP','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1279','REDNAP','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1165','ITRF2014','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6818','Systém Jednotnej trigonometrickej siete katastrálnej (Ferro)','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1167','BGS2005','EPSG'); @@ -377,6 +386,7 @@ INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1173','WGS 84 Tritan St INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1177','SHVD2015','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1180','ETRF91','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1178','ETRF89','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1280','REDNAP','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1179','ETRF90','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1181','ETRF92','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1182','ETRF93','EPSG'); @@ -387,6 +397,7 @@ INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1186','ETRF2000','EPSG' INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1176','MSL Tritan','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1175','MSL 1971','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1176','St. Helena Tritan 2011','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1281','REDNAP','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1193','NAD83(CSRS)v2','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1187','ISN2016','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1190','ISH2004','EPSG'); @@ -464,6 +475,7 @@ INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1237','SIRGAS Multi-Yea INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1238','SIRGAS-CON SIR11P01','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1238','SIRGAS Multi-Year Solution 2011','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1035','REGCAN95','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1282','REDNAP','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6761','HTRS96','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1047','RRAF91','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1251','KOSOVAREF12','EPSG'); @@ -482,11 +494,19 @@ INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1260','SRVN16','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6160','Quiñi-Huao','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1261','EVRF2000 Austria','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1262','SA LLD','EPSG'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1264','HS2-IRF','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1263','ONGD17','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1269','KSA-VRF14','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1265','HS2-VRF','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','5207','Croatian Vertical Reference System 1971','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1255','NGNC08','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1268','KSA-GRF17','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1266','TPEN11-IRF','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1283','REDNAP','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1284','REDNAP','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1285','REDNAP','EPSG'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1243','SIRGAS-Chile 2010','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1287','EVRF2019mean','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1042','Red Geodesica Nacional 1992','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1046','Morro do Papagaio','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1046','Island of Principe datum','EPSG'); @@ -2761,7 +2781,7 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2058','ED50(ED77) / UTM INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2059','ED50(ED77) / UTM 39N','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2060','ED50(ED77) / UTM 40N','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2061','ED50(ED77) / UTM 41N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2062','Madrid (Madrid) / Spain','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2062','Madrid (Madrid) / Spain LCC','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2063','Dabola 1981 / UTM 28N','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2064','Dabola 1981 / UTM 29N','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2104','Lake / La Rosa Grid','EPSG'); @@ -4585,9 +4605,9 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7535','NAD83(2011) / WIS INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7535','NAD83(2011) / WISCRS Fond du Lac (m)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7561','WISCRS Menominee (m)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7548','WISCRS Grant (m)','EPSG'); -INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4728','Pico de las Nieves','EPSG'); -INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4728','PN84','EPSG'); +INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4728','Pico de las Nieves 1984','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7538','WISCRS Columbia (m)','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5610','HR_HRVD71 / NOH','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7580','WISCRS Walworth (m)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7562','WISCRS Monroe (m)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7564','WISCRS Oneida (m)','EPSG'); @@ -4719,6 +4739,9 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7617','WISCRS Lincoln (f INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7638','WISCRS Vilas (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7618','WISCRS Marathon (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7639','WISCRS Walworth (ftUS)','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9377','MAGNA-SIRGAS / CTM12','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9387','ETRS89 / AbInvA96_2020 SnakeGrid','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9388','ETRS89 / AbInvA96_2020 SnakeGrid + Newlyn height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7640','WISCRS Washburn (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7641','WISCRS Washington (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7642','WISCRS Waukesha (ftUS)','EPSG'); @@ -4727,12 +4750,19 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7644','WISCRS Waushara ( INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7645','WISCRS Wood (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6316','Macedonia State Coordinate System zone 7','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3857','Web Mercator','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9391','BGS2005 / UTM zone 35 (E-N)','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5634','REGCAN95 - LCC','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9400','REDNAP height','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9389','EVRF2019_AMST / NH','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9392','REDNAP height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7692','Kyrg06-68','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7693','Kyrg06-71','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7694','Kyrg06-74','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7695','Kyrg06-77','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7696','Kyrg06-80','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','7700','LAS-2000 height','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5635','REGCAN95 - LAEA','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9401','REDNAP height','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5754','Poolbeg height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7791','RDN2008 / UTM zone 32N (E-N)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7792','RDN2008 / TM33 (E-N)','EPSG'); @@ -4743,7 +4773,7 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7800','CS2005 zone 35',' INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7794','RDN2008 / Fuso Italia (E-N)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7795','RDN2008 / Fuso 12 (E-N)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7799','CS2005 zone 34','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7799','Coordinate System 2005 zone 35','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7799','Coordinate System 2005 zone 34','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','7815','WGS 84 (Original)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7800','Coordinate System 2005 zone 35','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7803','BGS2005 / UTM zone 34N (E-N)','EPSG'); @@ -4780,6 +4810,7 @@ INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4919','419','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4919','ITRF2000 - XYZ','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4918','349','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7887','SHGD2015 / UTM zone 30S','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9393','REDNAP height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7887','St. Helena Map Grid 2015','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','7888','MSL 1971 height','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','7889','MSL Tritan height','EPSG'); @@ -4796,6 +4827,7 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2315','Campo Inchauspe / INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2316','Campo Inchauspe /UTM 20S','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7992','Malongo 1987 / UTM 33S','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','7976','Hong Kong Principal Datum depth','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2062','Madrid - LCC','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8042','S-SC','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8042','Stable Cadastre','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8043','Stable cadastre','EPSG'); @@ -6019,14 +6051,30 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9285','Pampa del Castill INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9285','Pampa del Castillo / Argentina zone 3','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4289','RD-Bessel','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4776','New Beijing / 3GK zone 40','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9306','ETRS89 / HS2P1+14 Snake + HS2-VRF height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4777','New Beijing / 3GK zone 41','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9300','ETRS89 / HS2P1+14 Snake','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5753','NGNC height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9311','US National Atlas EA','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9354','WGS 84 / IBCSO PS','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9394','REDNAP height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','31289','MGI (Ferro) / M31','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','31290','MGI (Ferro) / M34','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','31288','MGI (Ferro) / M28','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9402','REDNAP height','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9395','REDNAP height','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9396','REDNAP height','EPSG'); +INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9403','Pico de las Nieves 1968','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9397','REDNAP height','EPSG'); +INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4903','Madrid','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9398','REDNAP height','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9399','REDNAP height','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','8690','SI_KOP / NH','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5195','SI_TRIE / NOH','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5195','MK_TRIE / NOH','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4826','WGS 84 / Cape Verde New','EPSG'); +INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9390','EVRF2019mean_AMST / NH','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9450','ETRS89 + Belfast Lough height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4647','ETRS89 / UTM zone 32N','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4824','Morro do Papagaio','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4824','Island of Principe datum','EPSG'); -- cgit v1.2.3