sis-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From desruisse...@apache.org
Subject svn commit: r1831981 [2/2] - /sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql
Date Mon, 21 May 2018 17:28:02 GMT

Modified: sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql
URL: http://svn.apache.org/viewvc/sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql?rev=1831981&r1=1831980&r2=1831981&view=diff
==============================================================================
--- sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql [ISO-8859-1] (original)
+++ sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql [ISO-8859-1] Mon May 21 17:28:01 2018
@@ -237,7 +237,7 @@ INSERT INTO epsg_alias VALUES
 (246,'Datum',5102,7302,'NGVD29',''),
 (247,'Datum',5103,7302,'NAVD88',''),
 (248,'Datum',5104,7302,'Yellow Sea',''),
-(249,'Datum',5105,7302,'Baltic',''),
+(249,'Datum',5105,7301,'Baltic',''),
 (250,'Datum',5106,7302,'Caspian',''),
 (251,'Datum',5107,7302,'NGF',''),
 (252,'Datum',5109,7302,'NAP',''),
@@ -259,7 +259,7 @@ INSERT INTO epsg_alias VALUES
 (268,'Coordinate Reference System',5702,7301,'National Geodetic Vertical Datum of 1929 height (ftUS)',''),
 (269,'Coordinate Reference System',5703,7301,'North American Vertical Datum of 1988 height (m)',''),
 (270,'Coordinate Reference System',5709,7301,'Normaal Amsterdams Peil height',''),
-(271,'Coordinate Reference System',5711,7301,'Australian Height Datum height','Australian Height Datum height'),
+(271,'Coordinate Reference System',5711,7301,'Australian Height Datum height',''),
 (272,'Coordinate Reference System',5712,7301,'Australian Height Datum (Tasmania) height',''),
 (273,'Coordinate Reference System',5713,7301,'Canadian Geodetic Vertical Datum of 1928 height',''),
 (274,'Coordinate Reference System',5714,7301,'mean sea level height',''),
@@ -1144,6 +1144,8 @@ INSERT INTO epsg_alias VALUES
 (1161,'Coordinate Reference System',32153,7302,'NAD83 / Wisconsin Cen.',''),
 (1162,'Coordinate Reference System',32156,7302,'NAD83 / Wyoming E. Cen.',''),
 (1163,'Coordinate Reference System',32157,7302,'NAD83 / Wyoming W. Cen.',''),
+(1164,'Coordinate Reference System',5702,7301,'NGVD29 height',''),
+(1165,'Coordinate Reference System',6359,7301,'NGVD29 depth',''),
 (1166,'Unit of Measure',9003,7306,'ft[US]',''),
 (1167,'Unit of Measure',9005,7306,'ft[Cla]',''),
 (1168,'Unit of Measure',9014,7306,'fathom',''),
@@ -1215,7 +1217,7 @@ INSERT INTO epsg_alias VALUES
 (1234,'Coordinate Reference System',6697,7302,'JGD2011',''),
 (1235,'Coordinate_Operation Method',9807,7301,'Gauss-Kruger',''),
 (1236,'Coordinate_Operation Method',9807,7302,'TM',''),
-(1237,'Datum',6818,7300,'Systém Jednotné Trigonometrické Síte Katastrální (Ferro)',''),
+(1237,'Datum',6818,1042,'Systém Jednotné trigonometrické sít? katastrální (Ferro)',''),
 (1238,'Coordinate Reference System',2393,7301,'KKJ / Basic Coordinate System zone 3',''),
 (1239,'Coordinate Reference System',2391,7301,'KKJ / Basic Coordinate System zone 1',''),
 (1240,'Coordinate Reference System',2392,7301,'KKJ / Basic Coordinate System zone 2',''),
@@ -1231,6 +1233,7 @@ INSERT INTO epsg_alias VALUES
 (1250,'Coordinate Reference System',2167,7301,'Pulkovo 1942(83) / 3-degree Gauss-Kruger zone 4',''),
 (1251,'Coordinate Reference System',4181,7301,'LUREF',''),
 (1252,'Coordinate Reference System',6791,7302,'NAD83(2011) / OCRS_BKF (ft)',''),
+(1253,'Coordinate Reference System',8233,7301,'NAD83(CSRS98)',''),
 (1254,'Coordinate Reference System',2180,7301,'EUREF89 / CS92',''),
 (1255,'Coordinate Reference System',3906,7308,'HR1901',''),
 (1256,'Coordinate Reference System',6795,7302,'NAD83(2011) / OCRS_BRP (ft)',''),
@@ -1396,7 +1399,7 @@ INSERT INTO epsg_alias VALUES
 (1416,'Coordinate Reference System',27573,7317,'NTF (Paris) / France III',''),
 (1417,'Coordinate Reference System',27574,7317,'NTF (Paris) / France IV',''),
 (1418,'Coordinate Reference System',27572,7301,'NTF (Paris) / Lambert zone II etendu',''),
-(1419,'Datum',6156,7300,'Systém Jednotné Trigonometrické Síte Katastrální',''),
+(1419,'Datum',6156,1042,'Systém Jednotné trigonometrické sít? katastrální',''),
 (1420,'Coordinate Reference System',6815,7302,'NAD83(2011) / OCRS_CGC (ft)',''),
 (1421,'Coordinate_Operation',1751,7301,'Amersfoort to ETRF89 (1)',''),
 (1422,'Coordinate Reference System',2168,7301,'Pulkovo 1942(83) / 3-degree Gauss-Kruger zone 5',''),
@@ -1719,12 +1722,12 @@ INSERT INTO epsg_alias VALUES
 (1739,'Coordinate Reference System',21149,7301,'Genuk / UTM zone 49S',''),
 (1740,'Coordinate Reference System',2308,7301,'Genuk / TM 109 SE',''),
 (1741,'Datum',5133,7302,'AIOC95',''),
-(1742,'Coordinate Reference System',5705,7301,'Kronstadt height',''),
+(1742,'Coordinate Reference System',5705,7301,'Kronstadt 1977 height',''),
 (1743,'Datum',6199,7301,'New Egyptian','Old Egyptian is an alias for Egypt 1907 (code 6229).'),
 (1744,'Datum',6229,7301,'Old Egyptian','New Egyptian is an alias for Egypt 1930 (code 6199).'),
 (1745,'Coordinate Reference System',4199,7301,'New Egyptian','Old Egyptian is an alias for Egypt 1907 (code 4229).'),
 (1746,'Coordinate Reference System',4229,7301,'Old Egyptian','New Egyptian is an alias for Egypt 1930 (code 4199).'),
-(1747,'Coordinate_Operation',1516,7301,'PSAD56 to WGS 84 (1)',''),
+(1747,'Coordinate_Operation',1516,7301,'PSAD56 to WGS 84 (18)',''),
 (1748,'Coordinate_Operation',1813,7301,'Genuk to WGS 84 (ONWJ)',''),
 (1749,'Coordinate Reference System',32064,7301,'NAD27 / UTM zone 14N (ftUS)','Non-metric equivalent of NAD27 / UTM zone 14N (code 26714). UTM is a metric system so strictly this is not UTM.'),
 (1750,'Coordinate Reference System',32065,7301,'NAD27 / UTM zone 15N (ftUS)','Non-metric equivalent of NAD27 / UTM zone 15N (code 26715). UTM is a metric system so strictly this is not UTM.'),
@@ -2299,10 +2302,14 @@ INSERT INTO epsg_alias VALUES
 (2319,'Coordinate Reference System',3148,7301,'Indian (DMA Reduced) / UTM zone 48N',''),
 (2320,'Coordinate Reference System',3149,7301,'Indian (DMA Reduced) / UTM zone 49N',''),
 (2321,'Coordinate Reference System',4930,7302,'AAD98',''),
+(2322,'Datum',1192,7301,'NAD83(CSRS)v1',''),
+(2323,'Datum',1192,7302,'NAD83(CSRS96)',''),
 (2324,'Coordinate Reference System',6863,7301,'NAD83(2011) / Oregon Sweet Home-Sisters zone (ft)','Previous name.'),
 (2325,'Coordinate Reference System',6796,7302,'CORS96 / OCRS_BBU (m)',''),
 (2326,'Coordinate Reference System',4950,7301,'LKS94 (ETRS89)',''),
 (2327,'Coordinate Reference System',4931,7302,'AAD98',''),
+(2328,'Datum',1195,7302,'NAD83(CSRS)v4',''),
+(2329,'Coordinate Reference System',8235,7301,'NAD83(CSRS98)',''),
 (2330,'Coordinate Reference System',4951,7301,'LKS94 (ETRS89)',''),
 (2331,'Coordinate Reference System',6861,7301,'NAD83(CORS96) / Oregon Sweet Home-Sisters zone (ft)','Previous name.'),
 (2332,'Coordinate Reference System',6860,7302,'CORS96 / OCRS_SAN (m)',''),
@@ -2345,7 +2352,7 @@ INSERT INTO epsg_alias VALUES
 (2369,'Coordinate Reference System',6860,7301,'NAD83(CORS96) / Oregon Sweet Home-Sisters zone (m)','Previous name.'),
 (2370,'Coordinate Reference System',4173,7301,'ETRS89','In Northern Ireland usually called ETRS89, in Republic usually referred to as IRENET95.'),
 (2371,'Coordinate_Operation Method',9636,7301,'Molodenski-Badekas transformation','This alias is ambiguous as it gives no indication of the source and target CRS domain nor of the rotation convention used.'),
-(2372,'Coordinate_Operation Method',9607,7301,'Bursa-Wolf','This names is ambiguous as it is also applied to the Position Vector 7-param. Transformation method (code 9606).'),
+(2372,'Coordinate_Operation Method',9607,7301,'Bursa-Wolf','This names is ambiguous as it is also applied to the Position Vector transformation method (code 9606).'),
 (2373,'Coordinate_Operation Method',9606,7301,'Bursa-Wolf','This names is ambiguous as it is also applied to the Coordinate Frame rotation method (code 9607).'),
 (2374,'Coordinate_Operation',1071,7301,'Old Israeli to New Israeli (1)',''),
 (2375,'Coordinate_Operation',1072,7301,'Old Israel to New Israel (1)',''),
@@ -2841,9 +2848,9 @@ INSERT INTO epsg_alias VALUES
 (2865,'Coordinate Reference System',5733,7307,'DK_DK10 / OH',''),
 (2866,'Coordinate Reference System',3301,7307,'EE_L-EST97 / EST_LAMB',''),
 (2867,'Coordinate Reference System',5705,7307,'EE_KRON / NH',''),
-(2868,'Coordinate Reference System',5705,7301,'Baltic 1977 height',''),
-(2869,'Datum',5105,7301,'Baltic 1977',''),
-(2870,'Coordinate Reference System',5705,7302,'BHS77 height',''),
+(2868,'Coordinate Reference System',5705,7301,'Baltic height',''),
+(2869,'Datum',5105,7301,'Baltic Sea',''),
+(2870,'Coordinate_Operation',8440,7301,'Laborde Grid','The name Laborde Grid is also used for the conversion defined upon Tananarive (Paris).'),
 (2871,'Coordinate_Operation',5418,7307,'EE_KRON / NH to EVRF2000',''),
 (2872,'Coordinate Reference System',2393,7307,'FI_KKJ / FI_TM',''),
 (2873,'Coordinate Reference System',5717,7307,'FI_HELS / OH',''),
@@ -2943,7 +2950,7 @@ INSERT INTO epsg_alias VALUES
 (2967,'Coordinate Reference System',2190,7307,'(PT_AZO_ORIE / UTM - see alias remarks)','This EuroGeographics identifier is for a CRS similar to this but with CS axes in order north, east.'),
 (2968,'Coordinate Reference System',6884,7302,'CORS96 / OR N (m)',''),
 (2969,'Coordinate Reference System',2189,7307,'(PT_AZO_CENT / UTM - see alias remarks)','This EuroGeographics identifier is for a CRS similar to this but with CS axes in order north, east.'),
-(2970,'Coordinate Reference System',5705,7307,'SK_KRON / NH',''),
+(2970,'Coordinate_Operation',8504,7302,'KRCS zone 15',''),
 (2971,'Coordinate_Operation',5435,7307,'SK_KRON / NH to EVRF2000',''),
 (2972,'Coordinate_Operation',5428,7307,'SI_TRIE / NOH to EVRF2000',''),
 (2973,'Coordinate Reference System',5779,7307,'SI_TRIE / NOH',''),
@@ -3178,7 +3185,7 @@ INSERT INTO epsg_alias VALUES
 (3202,'Coordinate Reference System',3386,7301,'KKJ / Basic Coordinate System zone 0',''),
 (3203,'Coordinate Reference System',3387,7301,'KKJ / Basic Coordinate System zone 5',''),
 (3204,'Coordinate Reference System',4669,7301,'LKS94 (ETRS89)',''),
-(3205,'Coordinate_Operation',1283,7301,'LKS94 (ETRS89)  to WGS 84 (1)',''),
+(3205,'Coordinate_Operation',1283,7301,'LKS94 (ETRS89) to WGS 84 (1)',''),
 (3206,'Coordinate_Operation',1274,7301,'Pulkovo 1942 to LKS94(ETRS89) (1)',''),
 (3207,'Coordinate_Operation Method',1061,7301,'Molodenski-Badekas transformation','This alias is ambiguous as it gives no indication of the source and target CRS domain nor of the rotation convention used.'),
 (3208,'Coordinate_Operation Method',1061,7301,'Molodensky-Badekas 10-parameter transformation','This alias is ambiguous as it gives no indication of the source and target CRS domain nor of the rotation convention used.'),
@@ -3453,7 +3460,6 @@ INSERT INTO epsg_alias VALUES
 (3477,'Coordinate Reference System',4745,7301,'DHDN','RD/83 is the result of the transformation from Pulkovo 1942(83) to DHDN for Sachsen.'),
 (3478,'Coordinate Reference System',3398,7310,'RD/83 / Gauss-Kruger zone 4',''),
 (3479,'Coordinate Reference System',3399,7310,'RD/83 / Gauss-Kruger zone 5',''),
-(3480,'Coordinate Reference System',29701,7302,'Tananarive  / Laborde',''),
 (3481,'Coordinate_Operation',19911,7301,'Laborde Grid',''),
 (3482,'Coordinate Reference System',29702,7302,'Tananarive / Laborde app',''),
 (3483,'Coordinate Reference System',3448,7301,'WGS 84 / Jamaica Metric Grid 2001',''),
@@ -3517,7 +3523,7 @@ INSERT INTO epsg_alias VALUES
 (3541,'Coordinate Reference System',3077,7301,'NAD83(HARN) / Maine CS2000 West (m)',''),
 (3542,'Coordinate Reference System',6867,7302,'CORS96 / OR LCC (m)',''),
 (3543,'Coordinate Reference System',6868,7302,'CORS96 / OR GIC Lam (ft)',''),
-(3544,'Coordinate_Operation',6864,7301,'ITRF96 to NAD83(CSRS) (1)',''),
+(3544,'Coordinate Reference System',8358,7301,'Bpv depth',''),
 (3545,'Coordinate Reference System',6785,7302,'CORS96 / OCRS_BKE (ft)',''),
 (3546,'Coordinate Reference System',6789,7302,'CORS96 / OCRS_BKF (ft)',''),
 (3547,'Coordinate Reference System',6784,7302,'CORS96 / OCRS_BKE (m)',''),
@@ -3999,9 +4005,9 @@ INSERT INTO epsg_alias VALUES
 (4023,'Coordinate Reference System',26837,7301,'NAD83(NSRS2007) / Maine CS83 West (ftUS)',''),
 (4024,'Coordinate Reference System',26836,7301,'NAD83(NSRS2007) / Maine CS83 East (ftUS)',''),
 (4025,'Coordinate_Operation',10502,7302,'Colorado Central','This alias is ambiguous as also used for SPCS83 projection.'),
-(4026,'Coordinate Reference System',5612,7301,'Baltic 1977 depth',''),
-(4027,'Coordinate Reference System',5612,7302,'BHS77 depth',''),
-(4028,'Coordinate Reference System',5612,7301,'Kronstadt depth',''),
+(4026,'Coordinate Reference System',5612,7301,'Baltic depth',''),
+(4027,'Coordinate Reference System',8518,7301,'NAD83(2011) / KS RCS zone 1 Goodland',''),
+(4028,'Coordinate Reference System',5612,7301,'Kronstadt 1977 depth',''),
 (4029,'Coordinate_Operation',5452,7301,'Belfast Lough height to Malin Head height',''),
 (4030,'Coordinate_Operation',5450,7301,'Construction Datum height to PWD height (1)',''),
 (4031,'Coordinate_Operation',5425,7301,'Normaal Amsterdams Peil height to EVRF2000 height (1)',''),
@@ -7105,11 +7111,13 @@ INSERT INTO epsg_alias VALUES
 (7129,'Coordinate_Operation',7753,7302,'Tripura',''),
 (7130,'Coordinate_Operation',7734,7302,'Maharashtra',''),
 (7131,'Coordinate_Operation',7738,7302,'India Northeast',''),
+(7132,'Datum',6818,1043,'Systém Jednotnej trigonometrickej siete katastrálnej (Ferro)',''),
 (7133,'Coordinate_Operation',7739,7302,'Orissa',''),
 (7134,'Coordinate_Operation',7754,7302,'West Bengal',''),
 (7135,'Coordinate_Operation',7740,7302,'Punjab',''),
 (7136,'Coordinate_Operation',7722,7301,'India NSF LCC',''),
 (7137,'Coordinate_Operation',7741,7302,'Rajasthan',''),
+(7138,'Coordinate Reference System',5754,7301,'Poolbeg height',''),
 (7139,'Coordinate_Operation',7742,7302,'Uttar Pradesh',''),
 (7140,'Coordinate Reference System',7791,7301,'RDN2008 / UTM zone 32N (E-N)',''),
 (7141,'Coordinate_Operation',7743,7302,'Uttaranchal',''),
@@ -7240,10 +7248,14 @@ INSERT INTO epsg_alias VALUES
 (7266,'Coordinate Reference System',2315,7301,'Campo Inchauspe /UTM 19S',''),
 (7267,'Coordinate Reference System',2316,7301,'Campo Inchauspe /UTM 20S',''),
 (7268,'Coordinate Reference System',7992,7302,'Malongo 1987 / UTM 33S',''),
+(7269,'Coordinate_Operation',7966,7301,'Poolbeg intermediate CRS to Belfast Lough height (1)',''),
 (7270,'Coordinate_Operation',7958,7301,'ETRS89 to Belfast Lough height (2)',''),
 (7271,'Coordinate_Operation',7958,7301,'ETRF89 to Belfast height (2)',''),
+(7272,'Coordinate Reference System',7976,7301,'Hong Kong Principal Datum depth',''),
 (7273,'Coordinate_Operation',7959,7301,'ETRF89 to Malin Head height (2)',''),
+(7274,'Coordinate_Operation',7967,7301,'Poolbeg height (ft) to Belfast Lough height',''),
 (7275,'Coordinate_Operation',8061,7302,'PCCS zone 1 (ft)',''),
+(7276,'Coordinate_Operation',7980,7302,'CD height to WD height',''),
 (7277,'Coordinate_Operation',7995,7302,'BRO2020',''),
 (7278,'Coordinate_Operation',7996,7302,'BCG2020',''),
 (7279,'Coordinate_Operation',7997,7302,'CARN2020',''),
@@ -7267,21 +7279,36 @@ INSERT INTO epsg_alias VALUES
 (7297,'Coordinate_Operation',8005,7302,'JCG2020',''),
 (7298,'Coordinate_Operation',8062,7302,'PCCS zone 2 (ft)',''),
 (7299,'Coordinate_Operation',8006,7302,'KALB2020',''),
+(7300,'Coordinate Reference System',8050,7301,'mean sea level height (ft)',''),
 (7301,'Coordinate_Operation',8007,7302,'KAR2020',''),
+(7302,'Coordinate Reference System',8050,7301,'msl height (ft)',''),
 (7303,'Coordinate_Operation',8008,7302,'KUN2020',''),
+(7304,'Coordinate_Operation',8080,7301,'MTM Nova Scotia zone 4',''),
 (7305,'Coordinate_Operation',8009,7302,'LCG2020',''),
 (7306,'Coordinate_Operation',8063,7302,'PCCS zone 3(ft)',''),
+(7307,'Coordinate Reference System',8051,7301,'mean sea level depth (ft)',''),
+(7308,'Coordinate Reference System',8051,7301,'msl depth (ft)',''),
 (7309,'Coordinate Reference System',8065,7301,'NAD83(2011) / PCCS east zone(ft)',''),
+(7310,'Coordinate_Operation',8081,7301,'MTM Nova Scotia zone 5',''),
+(7311,'Coordinate Reference System',8052,7301,'mean sea level height (ftUS)',''),
+(7312,'Coordinate Reference System',8052,7301,'msl height (ftUS)',''),
 (7313,'Coordinate Reference System',8066,7301,'NAD83(2011) / PCCS central zone(ft)',''),
+(7314,'Datum',1193,7302,'NAD83(CSRS)v2',''),
+(7315,'Coordinate Reference System',8053,7301,'mean sea level depth (ftUS)',''),
+(7316,'Coordinate Reference System',8053,7301,'msl depth (ftUS)',''),
 (7317,'Coordinate Reference System',8067,7301,'NAD83(2011) / PCCS west zone(ft)',''),
+(7318,'Coordinate Reference System',8082,7302,'NAD83(CSRS)v6 / MTM NS zone 4',''),
 (7319,'Coordinate Reference System',8068,7301,'NAD83(2011) / PCCS Mt. Lemmon zone(ft)',''),
+(7320,'Coordinate Reference System',8083,7302,'NAD83(CSRS)v6 / MTM NS zone 5',''),
 (7321,'Datum',1187,7302,'ISN2016',''),
 (7322,'Coordinate Reference System',8090,7302,'WISCRS Florence (m)',''),
 (7323,'Coordinate_Operation',8087,7302,'Lambert 2016',''),
+(7324,'Datum',1191,7302,'ITRF2014 (2010.0)',''),
 (7325,'Datum',1190,7302,'ISH2004',''),
 (7326,'Datum',1190,7301,'Landshæðarkerfi Islands 2004',''),
 (7327,'Coordinate Reference System',8091,7302,'WISCRS Florence (ftUS)',''),
 (7328,'Coordinate Reference System',8096,7302,'WISCRS Wood (ftUS)',''),
+(7329,'Coordinate Reference System',7789,7301,'IGS14','Used by IGS from 2017-01-29. For most practical purposes IGS14 is equivalent to ITRF2014.'),
 (7330,'Coordinate Reference System',8095,7302,'WISCRS Wood (m)',''),
 (7331,'Coordinate Reference System',8109,7302,'WISCRS Vilas (m)',''),
 (7332,'Coordinate Reference System',8097,7302,'WISCRS Waushara (m)',''),
@@ -7379,6 +7406,7 @@ INSERT INTO epsg_alias VALUES
 (7424,'Coordinate Reference System',8168,7302,'WISCRS GreenLake-Marqt (ftUS)',''),
 (7425,'Coordinate Reference System',8168,7301,'NAD83(HARN) / WISCRS Green Lake (ftUS)',''),
 (7426,'Coordinate Reference System',8168,7301,'NAD83(HARN) / WISCRS Marquette (ftUS)',''),
+(7427,'Coordinate Reference System',8228,7301,'North American Vertical Datum of 1988 height (ft)',''),
 (7428,'Coordinate Reference System',8160,7302,'WISCRS Oz-Milw-Rac-Ken (ftUS)',''),
 (7429,'Coordinate Reference System',8160,7301,'NAD83(HARN) / WISCRS Kenosha (ftUS)',''),
 (7430,'Coordinate Reference System',8160,7301,'NAD83(HARN) / WISCRS Milwaukee (ftUS)',''),
@@ -7391,19 +7419,26 @@ INSERT INTO epsg_alias VALUES
 (7437,'Coordinate Reference System',8169,7301,'NAD83(HARN) / WISCRS Green (m)',''),
 (7438,'Coordinate Reference System',8169,7301,'NAD83(HARN) / WISCRS Lafayette (m)',''),
 (7439,'Coordinate Reference System',8182,7302,'WISCRS Douglas (ftUS)',''),
+(7440,'Datum',6156,1043,'Systém Jednotnej trigonometrickej siete katastrálnej',''),
 (7441,'Coordinate Reference System',8203,7302,'WISCRS Chippewa (m)',''),
 (7442,'Coordinate Reference System',4152,1026,'Guam Geodetic Network 1993','This alias is used only in Guam, where NAD83(HARN) is realised through GGN93.'),
 (7443,'Coordinate Reference System',8171,7302,'WISCRS Grant (m)',''),
 (7444,'Coordinate Reference System',8184,7302,'WISCRS Door (m)',''),
 (7445,'Coordinate Reference System',8172,7302,'WISCRS Grant (ftUS)',''),
+(7446,'Datum',1196,7302,'NAD83(CSRS)v5',''),
 (7447,'Coordinate Reference System',8173,7302,'WISCRS Forest (m)',''),
 (7448,'Coordinate Reference System',4152,1026,'GGN93','This abbreviation is used only in Guam, where NAD83(HARN) is realised through GGN93.'),
 (7449,'Coordinate Reference System',8185,7302,'WISCRS Door (ftUS)',''),
 (7450,'Coordinate Reference System',8177,7302,'WISCRS Forest (ftUS)',''),
 (7451,'Coordinate Reference System',8204,7302,'WISCRS Chippewa (ftUS)',''),
+(7452,'Coordinate Reference System',8237,7301,'NAD83(CSRS98)',''),
+(7453,'Datum',1194,7302,'NAD83(CSRS)v3',''),
 (7454,'Coordinate Reference System',8187,7302,'WISCRS Dodge-Jefferson (m)',''),
 (7455,'Coordinate Reference System',8187,7301,'NAD83(HARN) / WISCRS Dodge (m)',''),
 (7456,'Coordinate Reference System',8187,7301,'NAD83(HARN) / WISCRS Jefferson (m)',''),
+(7457,'Datum',1197,7302,'NAD83(CSRS)v6',''),
+(7458,'Coordinate_Operation',8259,7301,'ITRF96 to NAD83(CSRS98) (1)',''),
+(7459,'Datum',1198,7302,'NAD83(CSRS)v7',''),
 (7460,'Coordinate Reference System',8189,7302,'WISCRS Dodge-Jefferson (ftUS)',''),
 (7461,'Coordinate Reference System',8189,7301,'NAD83(HARN) / WISCRS Dodge (ftUS)',''),
 (7462,'Coordinate Reference System',8189,7301,'NAD83(HARN) / WISCRS Jefferson (ftUS)',''),
@@ -7417,45 +7452,180 @@ INSERT INTO epsg_alias VALUES
 (7470,'Coordinate Reference System',8197,7302,'WISCRS Crawford (ftUS)',''),
 (7471,'Coordinate Reference System',8205,7301,'NAD83(HARN) / WISCRS Winnebago (m)',''),
 (7472,'Coordinate Reference System',8198,7302,'WISCRS Columbia (m)',''),
+(7473,'Datum',1193,7301,'NAD83(CSRS98)',''),
+(7474,'Datum',1199,7302,'GVR2000',''),
+(7475,'Coordinate Reference System',8313,7302,'NAD83(2011) / OCRS_CBU (m)',''),
 (7476,'Coordinate Reference System',8201,7302,'WISCRS Clark (m)',''),
+(7477,'Datum',1200,7302,'GVR2016',''),
 (7478,'Coordinate Reference System',8202,7302,'WISCRS Clark (ftUS)',''),
+(7479,'Coordinate_Operation',8270,7302,'St. Pierre et Miquelon 1950 to WGS 84 (2)',''),
 (7480,'Coordinate Reference System',8206,7302,'WISCRS Out-Cal-Win-FdL (ftUS)',''),
 (7481,'Coordinate Reference System',8206,7301,'NAD83(HARN) / WISCRS Calumet (ftUS)',''),
 (7482,'Coordinate Reference System',8206,7301,'NAD83(HARN) / WISCRS Fond du Lac (ftUS)',''),
 (7483,'Coordinate Reference System',8206,7301,'NAD83(HARN) / WISCRS Outagamie (ftUS)',''),
 (7484,'Coordinate Reference System',8206,7301,'NAD83(HARN) / WISCRS Winnebago (ftUS)',''),
+(7485,'Coordinate Reference System',8311,7302,'NAD83(2011) / OCRS_BHA (m)',''),
 (7486,'Coordinate Reference System',8207,7302,'WISCRS Burnett (m)',''),
+(7487,'Coordinate Reference System',8323,7302,'NAD83(2011) / OCRS_MDI (m)',''),
 (7488,'Coordinate Reference System',8208,7302,'WISCRS Burnett (ftUS)',''),
+(7489,'Coordinate Reference System',8314,7302,'NAD83(2011) / OCRS_CBU (ft)',''),
 (7490,'Coordinate Reference System',8209,7302,'WISCRS Buffalo (m)',''),
+(7491,'Coordinate Reference System',8312,7302,'NAD83(2011) / OCRS_BHA (ft)',''),
 (7492,'Coordinate Reference System',8210,7302,'WISCRS Buffalo (ftUS)',''),
+(7493,'Coordinate Reference System',8333,7302,'NAD83(2011) / OCRS_PRU (m)',''),
 (7494,'Coordinate Reference System',8212,7302,'WISCRS Brown (m)',''),
+(7495,'Coordinate Reference System',8315,7302,'NAD83(2011) / OCRS_CRN (m)',''),
 (7496,'Coordinate Reference System',8213,7302,'WISCRS Brown (ftUS)',''),
+(7497,'Coordinate Reference System',8324,7302,'NAD83(2011) / OCRS_MDI (ft)',''),
 (7498,'Coordinate Reference System',8214,7302,'WISCRS Bayfield (m)',''),
+(7499,'Coordinate Reference System',8316,7302,'NAD83(2011) / OCRS_CRN (ft)',''),
 (7500,'Coordinate Reference System',8216,7302,'WISCRS Bayfield (ftUS)',''),
+(7501,'Coordinate Reference System',8337,7302,'NAD83(2011) / OCRS_RLA (m)',''),
 (7502,'Coordinate Reference System',8218,7302,'WISCRS Barron (m)',''),
+(7503,'Coordinate Reference System',8317,7302,'NAD83(2011) / OCRS_DPR (m)',''),
 (7504,'Coordinate Reference System',8220,7302,'WISCRS Barron (ftUS)',''),
+(7505,'Coordinate Reference System',8325,7302,'NAD83(2011) / OCRS_MTC (m)',''),
 (7506,'Coordinate Reference System',8222,7302,'WISCRS Ashland (m)',''),
+(7507,'Coordinate Reference System',8318,7302,'NAD83(2011) / OCRS_DPR (ft)',''),
 (7508,'Coordinate Reference System',8224,7302,'WISCRS Ashland (ftUS)',''),
+(7509,'Coordinate Reference System',8334,7302,'NAD83(2011) / OCRS_PRU (ft)',''),
+(7510,'Coordinate Reference System',8319,7302,'NAD83(2011) / OCRS_DBU (m)',''),
+(7511,'Coordinate Reference System',8326,7302,'NAD83(2011) / OCRS_MTC (ft)',''),
 (7512,'Coordinate Reference System',8225,7302,'WISCRS Adams-Juneau (m)',''),
 (7513,'Coordinate Reference System',8225,7301,'NAD83(HARN) / WISCRS Adams (m)',''),
 (7514,'Coordinate Reference System',8225,7301,'NAD83(HARN) / WISCRS Juneau (m)',''),
+(7515,'Coordinate Reference System',8320,7302,'NAD83(2011) / OCRS_DBU (ft)',''),
+(7516,'Coordinate Reference System',8339,7302,'NAD83(2011) / OCRS_SKP (m)',''),
+(7517,'Coordinate Reference System',8321,7302,'NAD83(2011) / OCRS_HLF (m)',''),
 (7518,'Coordinate Reference System',8226,7302,'WISCRS Adams-Juneau (ftUS)',''),
 (7519,'Coordinate Reference System',8226,7301,'NAD83(HARN) / WISCRS Adams (ftUS)',''),
 (7520,'Coordinate Reference System',8226,7301,'NAD83(HARN) / WISCRS Juneau (ftUS)',''),
+(7521,'Coordinate Reference System',8327,7302,'NAD83(2011) / OCRS_NCE (m)',''),
+(7522,'Coordinate Reference System',8322,7302,'NAD83(2011) / OCRS_HLF (ft)',''),
+(7523,'Coordinate Reference System',8335,7302,'NAD83(2011) / OCRS_PCB (m)',''),
+(7524,'Coordinate Reference System',8328,7302,'NAD83(2011) / OCRS_NCE (ft)',''),
+(7525,'Coordinate Reference System',8338,7302,'NAD83(2011) / OCRS_RLA (ft)',''),
+(7526,'Coordinate Reference System',8329,7302,'NAD83(2011) / OCRS_OCH (m)',''),
+(7527,'Coordinate Reference System',8336,7302,'NAD83(2011) / OCRS_PCB (ft)',''),
 (7528,'Datum',6152,1026,'Guam Geodetic Network 1993','This alias is used only in Guam, where NAD83(HARN) is realised through GGN93.'),
+(7529,'Coordinate Reference System',8330,7302,'NAD83(2011) / OCRS_OCH (ft)',''),
 (7530,'Coordinate Reference System',4957,1026,'Guam Geodetic Network 1993','This alias is used only in Guam, where NAD83(HARN) is realised through GGN93.'),
 (7531,'Coordinate Reference System',4957,1026,'GGN93','This abbreviation is used only in Guam, where NAD83(HARN) is realised through GGN93.'),
+(7532,'Coordinate Reference System',8370,7301,'ETRS89 / Lambert 2008 + Oostende height',''),
+(7533,'Coordinate Reference System',8331,7302,'NAD83(2011) / OCRS_OWY (m)',''),
+(7534,'Coordinate Reference System',8340,7302,'NAD83(2011) / OCRS_SKP (ft)',''),
 (7535,'Coordinate Reference System',4956,1026,'Guam Geodetic Network 1993','This alias is used only in Guam, where NAD83(HARN) is realised through GGN93.'),
 (7536,'Coordinate Reference System',4956,1026,'GGN93','This abbreviation is used only in Guam, where NAD83(HARN) is realised through GGN93.'),
+(7537,'Coordinate Reference System',8332,7302,'NAD83(2011) / OCRS_OWY (ft)',''),
 (7538,'Coordinate_Operation',1068,1026,'Guam 1963 to GGN93',''),
+(7539,'Coordinate Reference System',8353,7302,'S-JTSK [JTSK03] / Krovak EN','Uses Greenwich meridian.'),
+(7540,'Coordinate Reference System',8341,7302,'NAD83(2011) / OCRS_UFX (m)',''),
+(7541,'Datum',1201,7302,'S-JTSK [JTSK03]',''),
+(7542,'Coordinate Reference System',8342,7302,'NAD83(2011) / OCRS_UFX (ft)',''),
+(7543,'Datum',1201,1043,'Systém Jednotnej trigonometrickej siete katastrálnej [JTSK03]',''),
+(7544,'Coordinate Reference System',8343,7302,'NAD83(2011) / OCRS_WAL (m)',''),
+(7545,'Coordinate Reference System',6130,7301,'GCVD54 height',''),
+(7546,'Coordinate Reference System',8344,7302,'NAD83(2011) / OCRS_WAL (ft)',''),
+(7547,'Coordinate Reference System',6131,7301,'LCVD61 height',''),
+(7548,'Coordinate Reference System',8345,7302,'NAD83(2011) / OCRS_WHI (m)',''),
+(7549,'Coordinate Reference System',6132,7301,'CBVD61 height',''),
+(7550,'Coordinate Reference System',8346,7302,'NAD83(2011) / OCRS_WHI (ft)',''),
+(7551,'Coordinate_Operation',6139,7301,'CIGD11 to LCVD61 height (1)',''),
+(7552,'Coordinate Reference System',8347,7302,'NAD83(2011) / OCRS_WPA (m)',''),
+(7553,'Coordinate_Operation',6138,7301,'CIGD11 to GCVD54 height (1)',''),
+(7554,'Coordinate Reference System',8348,7302,'NAD83(2011) / OCRS_WPA (ft)',''),
+(7555,'Coordinate_Operation',6140,7301,'CIGD11 to CBVD61 height (1)',''),
+(7556,'Coordinate Reference System',8360,1042,'ETRS89 [ETRF2000] + Bpv',''),
+(7557,'Coordinate_Operation',8060,7301,'Baltic height to Baltic depth',''),
+(7558,'Coordinate_Operation Method',9664,7301,'Geographic3D to GravityRelatedHeight (IGN)','This was the name for this method used by EPSG until the introduction of method code 1073.'),
 (7559,'Coordinate Reference System',4417,7302,'Pulkovo 42(83) / 3GK zn7',''),
+(7560,'Coordinate Reference System',8357,7301,'Bpv','Baltic Vertical System - After Adjustment. CZ: Výškový systém baltský - po vyrovnání. SK: Baltský výškový systém po vyrovnaní.'),
 (7561,'Coordinate Reference System',4434,7302,'Pulkovo 42(83) / 3GK zn8',''),
+(7562,'Coordinate_Operation',8374,7302,'NCRS Las Vegas (ftUS)',''),
+(7563,'Coordinate_Operation',8363,1043,'Bpv to EVRF2007',''),
+(7564,'Coordinate_Operation',8363,7301,'Baltic 1957 height to EVRF2007 height',''),
+(7565,'Coordinate Reference System',8360,1043,'ETRS89 [ETRF2000] + Bpv',''),
+(7566,'Coordinate Reference System',8351,1043,'S-JTSK (JTSK03)',''),
+(7567,'Coordinate Reference System',8352,1043,'S-JTSK (JTSK03) / Krovak',''),
+(7568,'Coordinate_Operation',8373,7302,'NCRS Las Vegas (m)',''),
+(7569,'Coordinate Reference System',8357,7307,'SK_KRON / NH',''),
+(7571,'Coordinate Reference System',8357,7307,'CZ_KRON / NH',''),
+(7572,'Coordinate_Operation',8376,7302,'NCRS Las Vegas high (ftUS)',''),
+(7573,'Coordinate Reference System',8384,7302,'NCRS Las Vegas (ftUS)',''),
+(7574,'Datum',5111,7301,'AHD71','Applies prior to 2018 to mainland only.'),
+(7575,'Coordinate Reference System',8353,1043,'S-JTSK (JTSK03) / Krovak East North',''),
 (7576,'Coordinate Reference System',4152,1026,'NAD83','This alias is used only in Guam. The name is that of a different system applicable only in North America (see CRS code 4269).'),
+(7577,'Coordinate Reference System',5513,1043,'S-JTSK [JTSK] / Krovak',''),
+(7578,'Coordinate Reference System',8385,7302,'NCRS Las Vegas high (m)',''),
+(7579,'Coordinate_Operation',8367,1043,'S-JTSK [JTSK03] to ETRS89 [ETRF2000] (1)',''),
+(7580,'Coordinate_Operation',8365,1043,'ETRS89 [ETRF2000] to S-JTSK [JTSK03] (1)',''),
+(7581,'Coordinate_Operation',8375,7302,'NCRS Las Vegas high (m)',''),
+(7582,'Coordinate_Operation',8364,1043,'S-JTSK [JTSK03] to S-JTSK [JTSK] (1)',''),
+(7583,'Coordinate Reference System',8383,7302,'NCRS Las Vegas (m)',''),
+(7584,'Coordinate Reference System',8387,7302,'NCRS Las Vegas high (ftUS)',''),
+(7585,'Coordinate_Operation',8361,1043,'ETRS89 [ETRF2000] to ETRS89 [ETRF2000] + Baltic 1957 height (1)',''),
+(7586,'Coordinate_Operation',8361,1043,'ETRS89 [ETRF2000] to ETRS89 [ETRF2000] + Bpv (1)',''),
+(7587,'Coordinate_Operation',8362,1043,'ETRS89 [ETRF2000] to ETRS89 [ETRF2000] + EVRF2007 height (1)',''),
+(7588,'Datum',1208,7302,'Macao 2008',''),
+(7589,'Coordinate_Operation',5892,7302,'TM-3 zone 481',''),
+(7590,'Datum',1204,7302,'ETRF2005',''),
+(7591,'Coordinate_Operation',5893,7302,'TM-3 zone 482',''),
+(7592,'Coordinate_Operation',8442,1043,'ETRS89 [ETRF2000] to S-JTSK [JTSK]',''),
+(7593,'Coordinate_Operation',5894,7302,'TM-3 zone 491',''),
+(7594,'Datum',1206,7302,'ETRF2014',''),
+(7595,'Coordinate Reference System',8433,7301,'Macao 1920 Grid System',''),
+(7596,'Datum',5111,7301,'AHD-TAS83','Applies prior to 2018 to Tasmania only.'),
+(7597,'Coordinate_Operation',8443,1043,'S-JTSK [JTSK] to ETRS89 [ETRF2000]',''),
+(7598,'Coordinate Reference System',5514,1043,'S-JTSK [JTSK] / Krovak East North',''),
+(7599,'Coordinate Reference System',5711,7301,'AHD71 height','Applies prior to 2018 to mainland only.'),
+(7600,'Coordinate Reference System',5711,7301,'AHD-TAS83 height','Applies prior to 2018 to Tasmania only.'),
+(7601,'Coordinate_Operation Method',1048,7301,'Geographic3D to GravityRelatedHeight (Ausgeoid09)','EPSG method name used up to dataset v9.2. Same file format used for Ausgeoid 2020.'),
 (7602,'Coordinate Reference System',4414,7302,'GGN93 / Guam Map Grid',''),
 (7603,'Coordinate Reference System',4414,7301,'Guam Geodetic Network 1993 / Guam Map Grid',''),
 (7604,'Coordinate Reference System',4414,1026,'NAD83 / Guam Map Grid','The base geographic CRS alias NAD83 is used only in Guam. The name is that of a different system applicable only in North America (see CRS code 4269).'),
 (7605,'Coordinate Reference System',4414,7301,'NAD83(HPGN) / Guam Map Grid',''),
+(7606,'Coordinate_Operation',8505,7302,'KRCS zone 16',''),
+(7607,'Coordinate_Operation',8458,7302,'KRCS zone 1',''),
+(7608,'Coordinate Reference System',8538,7301,'NAD83(2011) / KS RCS zone 18 Arkansas City',''),
 (7609,'Datum',6152,1026,'NAD83','This alias is used only in Guam. The name is that of a different system applicable only in North America (see datum code 6269).'),
+(7610,'Coordinate_Operation',8452,1039,'BAT',''),
+(7611,'Coordinate_Operation',8459,7302,'KRCS zone 2',''),
+(7612,'Coordinate_Operation',8506,7302,'KRCS zone 17',''),
+(7613,'Coordinate_Operation',8490,7302,'KRCS zone 3',''),
+(7614,'Coordinate Reference System',8519,7301,'NAD83(2011) / KS RCS zone 2 Colby',''),
+(7615,'Coordinate_Operation',8491,7302,'KRCS zone 4',''),
+(7616,'Coordinate_Operation',8507,7302,'KRCS zone 18',''),
+(7617,'Coordinate_Operation',8492,7302,'KRCS zone 5',''),
+(7618,'Coordinate_Operation',1767,7301,'REGVEN to SIRGAS (1)',''),
+(7619,'Coordinate_Operation',8493,7302,'KRCS zone 6',''),
+(7620,'Coordinate_Operation',8515,7302,'KRCS zone 19',''),
+(7621,'Coordinate_Operation',8494,7302,'KRCS zone 7',''),
+(7622,'Coordinate Reference System',8520,7301,'NAD83(2011) / KS RCS zone 3 Oberlin',''),
+(7623,'Coordinate_Operation',8495,7302,'KRCS zone 8',''),
+(7624,'Coordinate_Operation',8516,7302,'KRCS zone 20',''),
+(7625,'Coordinate_Operation',8498,7302,'KRCS zone 9',''),
+(7626,'Coordinate Reference System',8539,7301,'NAD83(2011) / KS RCS zone 19 Coffeyville',''),
+(7627,'Coordinate_Operation',8499,7302,'KRCS zone 10',''),
+(7628,'Coordinate Reference System',8521,7301,'NAD83(2011) / KS RCS zone 4 Hays',''),
+(7629,'Coordinate_Operation',8500,7302,'KRCS zone 11',''),
+(7630,'Coordinate Reference System',8441,7301,'Tananarive / Laborde Grid (Greenwich)',''),
+(7631,'Coordinate_Operation',8501,7302,'KRCS zone 12',''),
+(7632,'Coordinate Reference System',8522,7301,'NAD83(2011) / KS RCS zone 5 Great Bend',''),
+(7633,'Coordinate_Operation',8502,7302,'KRCS zone 13',''),
+(7634,'Coordinate Reference System',8540,7301,'NAD83(2011) / KS RCS zone 20 Pittsburg',''),
+(7635,'Coordinate_Operation',8503,7302,'KRCS zone 14',''),
+(7636,'Coordinate Reference System',8523,7301,'NAD83(2011) / KS RCS zone 6 Beloit',''),
+(7638,'Coordinate Reference System',8524,7301,'NAD83(2011) / KS RCS zone 7 Salina',''),
+(7640,'Coordinate Reference System',8525,7301,'NAD83(2011) / KS RCS zone 8 Manhattan',''),
+(7642,'Coordinate Reference System',8526,7301,'NAD83(2011) / KS RCS zone 9 Emporia',''),
+(7644,'Coordinate Reference System',8527,7301,'NAD83(2011) / KS RCS zone 10 Atchison',''),
+(7646,'Coordinate Reference System',8528,7301,'NAD83(2011) / KS RCS zone 11 Kansas City',''),
+(7648,'Coordinate Reference System',8529,7301,'NAD83(2011) / KS RCS zone 12 Ulysses',''),
+(7650,'Coordinate Reference System',8531,7301,'NAD83(2011) / KS RCS zone 13 Garden City',''),
+(7652,'Coordinate Reference System',8533,7301,'NAD83(2011) / KS RCS zone 14 Dodge City',''),
+(7654,'Coordinate Reference System',8534,7301,'NAD83(2011) / KS RCS zone 15 Larned',''),
+(7656,'Coordinate Reference System',8535,7301,'NAD83(2011) / KS RCS zone 16 Pratt',''),
+(7658,'Coordinate Reference System',8536,7301,'NAD83(2011) / KS RCS zone 17 Wichita',''),
 (7701,'Coordinate Reference System',4437,7302,'NAD83(NSRS) / PR and VI',''),
 (7726,'Coordinate_Operation',4454,7302,'New York Long Island','This alias is ambiguous as also used for SPCS83 projection.'),
 (7728,'Coordinate Reference System',4455,7302,'NAD27 / Pennsylvania S',''),
@@ -7655,7 +7825,7 @@ INSERT INTO epsg_alias VALUES
 (8874,'Coordinate_Operation Method',9606,7301,'Position Vector 7-param. transformation','This name is ambiguous as it makes no distinction of the domain of the source and target CRSs to which it is applied. See also methods 1032 and 10xx.'),
 (8885,'Coordinate Reference System',4491,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 13','Part of the China National Coordinate System of 2000.'),
 (8886,'Coordinate Reference System',4491,7302,'CGCS2000 / G-K zone 13',''),
-(8911,'Coordinate_Operation Method',9607,7301,'Coordinate Frame Rotation','This names is ambiguous as it makes no distinction between the domain of the source and target CRSs. See also methods 1032 and 10xx.'),
+(8911,'Coordinate_Operation Method',9607,7301,'Coordinate Frame rotation','This names is ambiguous as it makes no distinction between the domain of the source and target CRSs. See also methods 1032 and 1038.'),
 (8925,'Coordinate_Operation Method',9636,7301,'Molodensky-Badekas 10-parameter transformation','This alias is ambiguous as it gives no indication of the source and target CRS domain nor of the rotation convention used.'),
 (8999,'Coordinate Reference System',4511,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 129E',''),
 (9000,'Coordinate Reference System',4511,7302,'CGCS2000 / G-K CM 129E',''),
@@ -7738,9 +7908,9 @@ INSERT INTO epsg_alias VALUES
 (9528,'Coordinate_Operation Method',1034,7301,'Molodensky-Badekas 10-parameter transformation','This alias is ambiguous as it gives no indication of the source and target CRS domain nor of the rotation convention used.'),
 (9530,'Coordinate_Operation Method',1035,7301,'Geocentric Translations','This name is ambiguous as it makes no distinction of the domain of the source and target CRSs to which it is applied. See also methods 1031 and 9603.'),
 (9532,'Coordinate_Operation Method',1031,7301,'Geocentric translations','This name is ambiguous as it makes no distinction between the domain of the source and target CRSs. See also methods 1035 and 9603.'),
-(9534,'Coordinate_Operation Method',1038,7301,'Bursa-Wolf','This names is ambiguous as it is also applied to the Position Vector 7-param. Transformation method (code 9606).'),
-(9535,'Coordinate_Operation Method',1038,7301,'Coordinate Frame Rotation','This names is ambiguous as it makes no distinction between the domain of the source and target CRSs. See also methods 1032 and 9607.'),
-(9537,'Coordinate_Operation Method',1032,7301,'Bursa-Wolf','This names is ambiguous as it is also applied to the Position Vector Transformation method (code 1033).'),
+(9534,'Coordinate_Operation Method',1038,7301,'Bursa-Wolf','This names is ambiguous as it is also applied to the Position Vector transformation method (code 9606).'),
+(9535,'Coordinate_Operation Method',1038,7301,'Coordinate Frame rotation','This names is ambiguous as it makes no distinction between the domain of the source and target CRSs. See also methods 1032 and 9607.'),
+(9537,'Coordinate_Operation Method',1032,7301,'Bursa-Wolf','This names is ambiguous as it is also applied to the Position Vector transformation method (code 1033).'),
 (9538,'Coordinate_Operation Method',1032,7301,'Coordinate Frame rotation','This names is ambiguous as it makes no distinction between the domain of the source and target CRSs. See also methods 1038 and 9607.'),
 (9543,'Coordinate Reference System',4647,7310,'ETRS89 / UTM zone 32N','This is the EPSG name for CRS code 25832.'),
 (9559,'Coordinate_Operation',4829,7307,'SK_S-JTSK to ETRS89','This identifier is also used for other transformations between S-JTSK and ERTS89.'),
@@ -8209,7 +8379,6 @@ INSERT INTO epsg_alias VALUES
 (13101,'Datum',6301,7301,'Tokyo 1918',''),
 (13277,'Coordinate Reference System',5781,7307,'RO_CONST / NH',''),
 (13279,'Coordinate Reference System',5705,7307,'LT_KRON / NH',''),
-(13280,'Coordinate Reference System',5705,7307,'CZ_KRON / NH',''),
 (13285,'Coordinate_Operation',18251,7302,'East Belt','Care! This same name is also used for the new (2010) projection.'),
 (13293,'Coordinate_Operation',5131,7302,'Central Belt Jeju',''),
 (13295,'Coordinate_Operation',5162,7302,'Modified Central Belt',''),
@@ -8360,11 +8529,11 @@ INSERT INTO epsg_alias VALUES
 (14805,'Coordinate Reference System',5316,7301,'ETRS89 / FOTM',''),
 (14806,'Coordinate Reference System',5316,7301,'ETRF89 / Faroe TM',''),
 (14812,'Datum',1052,7302,'S-JTSK/05',''),
-(14813,'Datum',1052,7300,'Systém Jednotné Trigonometrické Síte Katastrální/05',''),
+(14813,'Datum',1052,1042,'Systém Jednotné trigonometrické síte katastrální/05',''),
 (14815,'Datum',1055,7302,'S-JTSK/05 (Ferro)',''),
-(14816,'Datum',1055,7300,'Systém Jednotné Trigonometrické Síte Katastrální/05 (Ferro)',''),
-(14827,'Coordinate Reference System',5224,7302,'S-JTSK/05F / ModKrovak','Uses Ferro meridian.'),
-(14829,'Coordinate Reference System',5225,7302,'S-JTSK/05F / ModKrovakEN','Uses Ferro meridian.'),
+(14816,'Datum',1055,1042,'Systém Jednotné trigonometrické síte katastrální/05 (Ferro)',''),
+(14827,'Coordinate Reference System',5224,7302,'S-JTSK/05 (F) / ModKrovak','Uses Ferro meridian.'),
+(14829,'Coordinate Reference System',5225,7302,'S-JTSK/05 (F) / ModKrovakEN','Uses Ferro meridian.'),
 (14833,'Coordinate Reference System',5221,7302,'S-JTSK (F) / Krovak EN','Uses Greenwich meridian.'),
 (14851,'Coordinate_Operation Method',9812,7301,'Hotine Oblique Mercator','This was the method name used prior to October 2010.'),
 (14853,'Coordinate_Operation Method',9815,7301,'Rectified Skew Orthomorphic (RSO)','This same name is also used for variant A.'),
@@ -8464,7 +8633,6 @@ INSERT INTO epsg_alias VALUES
 (17437,'Coordinate_Operation',5503,7301,'RGAF09 to IGN 1988 (1)',''),
 (17476,'Coordinate_Operation',5491,7301,'Fort Desaix to RGAF09 (1)',''),
 (17482,'Coordinate_Operation',5492,7301,'Sainte Anne to RGAF09 (1)',''),
-(17483,'Coordinate_Operation',5493,7301,'Fort Marigot to RGAF09 (1)',''),
 (17793,'Coordinate Reference System',5515,7302,'S-JTSK/05 / ModKrovak','Uses Greenwich meridian.'),
 (17795,'Coordinate Reference System',5516,7302,'S-JTSK/05 / ModKrovakEN','Uses Greenwich meridian.'),
 (17802,'Coordinate Reference System',5514,7302,'S-JTSK / Krovak EN (G)','Uses Greenwich meridian.'),
@@ -8532,7 +8700,6 @@ INSERT INTO epsg_alias VALUES
 (19027,'Coordinate Reference System',31979,1035,'SIRGAS2000 / UTM zone 19S',''),
 (19029,'Coordinate Reference System',31978,1035,'SIRGAS2000 / UTM zone 18S',''),
 (19031,'Datum',6674,1035,'SIRGAS2000',''),
-(19033,'Coordinate_Operation',5058,1035,'Aratu to SIRGAS 2000 (5)',''),
 (19066,'Coordinate_Operation',5473,7302,'Ocotepeque to WGS 84 (2)',''),
 (19590,'Datum',5182,7301,'Deutsches Haupthöhennetz 1985',''),
 (19592,'Datum',5181,7301,'Deutsches Haupthöhennetz 1992',''),
@@ -9721,7 +9888,7 @@ INSERT INTO epsg_area VALUES
 (1058,'Burundi','Burundi.',-4.45,-2.3,28.98,30.86,'urn:ogc:def:extent-polygon:EPSG::1058','BI','BDI',108,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2012.049 2014.025',false),
 (1059,'Cambodia','Cambodia - onshore and offshore.',8.78,14.71,101.33,107.64,'urn:ogc:def:extent-polygon:EPSG::1059','KH','KHM',116,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2012-04-18','2002.341 2005.890 2012.040',false),
 (1060,'Cameroon','Cameroon - onshore and offshore.',1.65,13.09,8.32,16.21,'urn:ogc:def:extent-polygon:EPSG::1060','CM','CMR',120,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.049 2014.025',false),
-(1061,'Canada','Canada - onshore and offshore - Alberta; British Columbia (BC); Manitoba; New Brunswick (NB); Newfoundland and Labrador; Northwest Territories (NWT); Nova Scotia (NS); Nunavut; Ontario; Prince Edward Island (PEI); Quebec; Saskatchewan; Yukon.',40.04,86.46,-141.01,-47.74,'urn:ogc:def:extent-polygon:EPSG::1061','CA','CAN',124,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2006.463 2011.068 2014.025',false),
+(1061,'Canada','Canada - onshore and offshore - Alberta; British Columbia; Manitoba; New Brunswick; Newfoundland and Labrador; Northwest Territories; Nova Scotia; Nunavut; Ontario; Prince Edward Island; Quebec; Saskatchewan; Yukon.',40.04,86.46,-141.01,-47.74,'urn:ogc:def:extent-polygon:EPSG::1061','CA','CAN',124,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2018-04-20','2002.341 2005.890 2006.463 2011.068 2014.025 2018.007',false),
 (1062,'Cape Verde','Cape Verde - onshore and offshore. Includes Boa Vista, Brava, Fogo, Maio, Sal, Santo Antao, Sao Nicolau, Sao Tiago, Sao Vicente.',11.47,20.54,-28.85,-19.53,'urn:ogc:def:extent-polygon:EPSG::1062','CV','CPV',132,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.049 2014.025',false),
 (1063,'Cayman Islands','Cayman Islands - onshore and offshore. Includes Grand Cayman, Little Cayman and Cayman Brac.',17.58,20.68,-83.6,-78.72,'urn:ogc:def:extent-polygon:EPSG::1063','KY','CYM',136,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.068 2014.025',false),
 (1064,'Central African Republic','Central African Republic.',2.22,11.01,14.41,27.46,'urn:ogc:def:extent-polygon:EPSG::1064','CF','CAF',140,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2012.049 2014.025',false),
@@ -9937,11 +10104,11 @@ INSERT INTO epsg_area VALUES
 (1274,'Brazil - Aratu','Brazil - offshore south and east of a line intersecting the coast at 2°55''S; onshore Tucano basin.',-35.71,4.26,-53.38,-26,'urn:ogc:def:extent-polygon:EPSG::1274','','',Null,'','OGP','OGP','2014-05-01','2008.045 2010.039 2010.046 2011.037 2014.024',false),
 (1275,'Netherlands - onshore','Netherlands - onshore, including Waddenzee, Dutch Wadden Islands and 12-mile offshore coastal zone.',50.75,53.7,3.2,7.22,'urn:ogc:def:extent-polygon:EPSG::1275','','',Null,'','OGP','OGP','2014-05-01','2009.046 2011.082 2012.013 2014.024',false),
 (1276,'Africa - Botswana, Malawi, Zambia, Zimbabwe','Botswana; Malawi; Zambia; Zimbabwe.',-26.88,-8.19,19.99,35.93,'urn:ogc:def:extent-polygon:EPSG::1276','','',Null,'','OGP','OGP','2014-05-01','2014.024',false),
-(1277,'Africa - Kenya, Tanzania and Uganda','Kenya; Tanzania; Uganda.',-11.75,4.63,29.34,41.91,'urn:ogc:def:extent-polygon:EPSG::1277','','',Null,'','OGP','OGP','2014-05-01','2014.024',false),
+(1277,'Africa - Burundi, Kenya, Rwanda, Tanzania and Uganda','Burundi, Kenya, Rwanda, Tanzania and Uganda.',-11.75,4.63,28.85,41.91,'urn:ogc:def:extent-polygon:EPSG::1277','','',Null,'','OGP','IOGP','2018-04-20','2014.024 2018.007',false),
 (1278,'Antarctica - Australian sector','Antarctica between 45°E and 136°E and between 142°E and 160°E - Australian sector.',-90,-60,45,160,'urn:ogc:def:extent-polygon:EPSG::1278','','',Null,'','OGP','OGP','2012-05-26','2012.023 2012.060',false),
 (1279,'Australasia - Australia and PNG - AGD66','Australia - onshore and offshore. Papua New Guinea - onshore.',-47.2,-1.3,109.23,163.2,'urn:ogc:def:extent-polygon:EPSG::1279','','',Null,'This area is the union of areas 1036 and 3291.','OGP','IOGP','2016-12-15','2009.106 2012.015 2014.024 2016.054',false),
 (1280,'Australia - Western Australia','Australia - Western Australia.',-35.19,-13.67,112.85,129.01,'urn:ogc:def:extent-polygon:EPSG::1280','','',Null,'','OGP','OGP','2014-05-01','2012.027 2014.024',false),
-(1281,'Australia - mainland','Australia - Australian Capital Territory; New South Wales; Northern Territory; Queensland; South Australia; Western Australia; Victoria.',-39.2,-10.65,112.85,153.69,'urn:ogc:def:extent-polygon:EPSG::1281','','',Null,'','OGP','OGP','2014-05-01','2007.009 2012.027 2014.024',false),
+(1281,'Australia - mainland','Australia - Australian Capital Territory; New South Wales; Northern Territory; Queensland; South Australia; Western Australia; Victoria.',-39.2,-10.65,112.85,153.69,'urn:ogc:def:extent-polygon:EPSG::1281','','',Null,'','OGP','IOGP','2018-02-16','2007.009 2012.027 2014.024 2017.056',false),
 (1282,'Australia - Tasmania','Australia - Tasmania including islands - onshore.',-43.7,-39.52,143.77,148.55,'urn:ogc:def:extent-polygon:EPSG::1282','','',Null,'','OGP','OGP','2014-05-01','2007.052 2012.007 2012.027 2014.024',false),
 (1283,'Canada - Maritime Provinces','Canada - New Brunswick; Nova Scotia; Prince Edward Island.',43.41,48.07,-69.05,-59.73,'urn:ogc:def:extent-polygon:EPSG::1283','','',Null,'','OGP','OGP','2014-05-01','2011.068 2014.024',false),
 (1284,'Europe - FSU, Czechoslovakia - onshore','Armenia; Azerbaijan; Belarus; Czech Republic; Estonia - onshore; Georgia - onshore; Kazakhstan; Kyrgyzstan; Latvia - onshore; Lithuania - onshore; Moldova; Russian Federation - onshore; Slovakia; Tajikistan; Turkmenistan; Ukraine - onshore; Uzbekistan.',35.14,77.79,12.09,-169.57,'urn:ogc:def:extent-polygon:EPSG::1284','','',Null,'Area crosses 180-degree meridian.','OGP','OGP','2014-05-01','2006.380 2008.054 2010.064 2011.055 2011.082 2012.013 2014.024',false),
@@ -9957,18 +10124,18 @@ INSERT INTO epsg_area VALUES
 (1294,'Portugal - mainland - onshore','Portugal - mainland - onshore.',36.95,42.16,-9.56,-6.19,'urn:ogc:def:extent-polygon:EPSG::1294','','',Null,'','OGP','OGP','2014-05-01','2007.096 2011.113 2014.024',false),
 (1295,'Germany - DHDN','Germany - onshore - Baden-Wurtemberg, Bayern, Hessen, Niedersachsen, Nordrhein-Westfalen, Rheinland-Pfalz, Saarland, Schleswig-Holstein. Also former DDR states of Sachsen and Thuringen by transformation.',47.27,55.06,5.87,15.03,'','','',Null,'','OGP','OGP','2001-06-05','',true),
 (1296,'Europe - ED50 by country','Europe - west: Andorra; Cyprus; Denmark - onshore and offshore; Faroe Islands - onshore; France - offshore; Germany - offshore North Sea; Gibraltar; Greece - offshore; Israel - offshore; Italy including San Marino and Vatican City State; Ireland offshore; Malta; Netherlands - offshore; North Sea; Norway including Svalbard - onshore and offshore; Portugal - mainland - offshore; Spain - onshore; Turkey - onshore and offshore; United Kingdom UKCS offshore east of 6°W including Channel Islands (Guernsey and Jersey). Egypt - Western Desert; Iraq - onshore; Jordan.',25.71,84.17,-16.1,48.61,'urn:ogc:def:extent-polygon:EPSG::1296','','',Null,'','OGP','OGP','2014-05-01','2003.141 2004.150 2004.630 2005.460 2005.471 2005.890 2007.096 2009.033 2011.004 2011.055 2011.082 2014.024',false),
-(1297,'Europe - west','Europe - west.',34.88,71.21,-10.56,31.59,'urn:ogc:def:extent-polygon:EPSG::1297','','',Null,'','OGP','OGP','2014-05-01','2005.890 2011.082 2014.024',false),
+(1297,'Europe - west','Europe - west.',34.88,84.17,-10.56,39.65,'urn:ogc:def:extent-polygon:EPSG::1297','','',Null,'','OGP','IOGP','2018-04-20','2005.890 2011.082 2014.024 2018.007',false),
 (1298,'Europe - ETRS89','Europe - onshore and offshore: Albania; Andorra; Austria; Belgium; Bosnia and Herzegovina; Bulgaria; Croatia; Cyprus; Czech Republic; Denmark; Estonia; Faroe Islands; Finland; France; Germany; Gibraltar; Greece; Hungary; Ireland; Italy; Latvia; Liechtenstein; Lithuania; Luxembourg; Macedonia; Malta; Moldova; Monaco; Montenegro; Netherlands; Norway including Svalbard and Jan Mayen; Poland; Portugal; Romania; San Marino; Serbia; Slovakia; Slovenia; Spain; Sweden; Switzerland; Ukraine; United Kingdom (UK) including Channel Islands and Isle of Man; Vatican City State.',32.88,84.17,-16.1,40.18,'urn:ogc:def:extent-polygon:EPSG::1298','','',Null,'','OGP','IOGP','2016-12-15','2005.890 2007.072 2011.004 2011.082 2014.024 2016.058',false),
 (1299,'Europe - EVRF2000','Europe - onshore - Andorra; Austria; Belgium; Bosnia and Herzegovina; Croatia; Czech Republic; Denmark; Estonia; Finland; France - mainland; Germany; Gibraltar; Hungary; Italy - mainland and Sicily; Latvia; Liechtenstein; Lithuania; Luxembourg; Netherlands; Norway; Poland; Portugal; Romania; San Marino; Slovakia; Slovenia; Spain - mainland; Sweden; Switzerland; United Kingdom (UK) - Great Britain mainland; Vatican City State.',35.95,71.21,-9.56,31.59,'urn:ogc:def:extent-polygon:EPSG::1299','','',Null,'','OGP','OGP','2015-01-28','2005.890 2011.055 2011.082 2012.013 2014.024 2014.095',false),
-(1300,'Iran - FD58','Iran - Arwaz area and onshore Gulf coast west of 54°E.',26.74,33.22,47.13,53.61,'urn:ogc:def:extent-polygon:EPSG::1300','','',Null,'','OGP','OGP','2014-05-01','2012.032 2012.051 2014.024',false),
+(1300,'Iran - FD58','Iran - Arwaz area and onshore Gulf coast west of 54°E, Lavan Island, offshore Balal field and South Pars blocks 2 and 3.',26.21,33.22,47.13,53.61,'urn:ogc:def:extent-polygon:EPSG::1300','','',Null,'','OGP','IOGP','2018-04-20','2012.032 2012.051 2014.024 2018.007',false),
 (1301,'Portugal - Azores C - onshore','Portugal - central Azores onshore - Faial, Graciosa, Pico, Sao Jorge, Terceira.',38.32,39.14,-28.9,-26.97,'urn:ogc:def:extent-polygon:EPSG::1301','','',Null,'Superset of areas 2872, 2873, 2874, 2875 and 3681.','OGP','OGP','2012-01-05','2010.006 2011.062 2011.113',false),
 (1302,'Asia - Cambodia and Vietnam - mainland','Cambodia - mainland onshore; Vietnam - mainland onshore.',8.5,23.33,102.14,109.52,'urn:ogc:def:extent-polygon:EPSG::1302','','',Null,'','OGP','OGP','2014-05-01','2012.046 2014.024',false),
-(1303,'South America - Tierra del Fuego','Argentina and Chile - Tierra del Fuego, onshore.',-55.96,-51.99,-74.83,-65.05,'urn:ogc:def:extent-polygon:EPSG::1303','','',Null,'','OGP','OGP','2014-11-19','2011.037 2014.024 2014.082',false),
+(1303,'South America - Tierra del Fuego','Argentina and Chile - Tierra del Fuego, onshore.',-55.96,-51.99,-74.83,-63.73,'urn:ogc:def:extent-polygon:EPSG::1303','','',Null,'','OGP','IOGP','2018-04-20','2011.037 2014.024 2014.082 2018.007',false),
 (1304,'Asia - Myanmar and Thailand onshore','Myanmar (Burma) - onshore; Thailand - onshore.',5.63,28.55,92.2,105.64,'urn:ogc:def:extent-polygon:EPSG::1304','','',Null,'','OGP','IOGP','2017-03-19','2011.004 2017.008',false),
 (1305,'Europe - Ireland (Republic and Ulster) - onshore','Ireland - onshore. United Kingdom (UK) - Northern Ireland (Ulster) - onshore.',51.39,55.43,-10.56,-5.34,'urn:ogc:def:extent-polygon:EPSG::1305','','',Null,'','OGP','OGP','2014-05-01','2011.082 2014.024',false),
 (1306,'Europe - Czechoslovakia','Czech Republic; Slovakia.',47.73,51.06,12.09,22.56,'urn:ogc:def:extent-polygon:EPSG::1306','','',Null,'','OGP','OGP','2014-05-01','2014.024',false),
 (1307,'Asia - Bangladesh; India; Myanmar; Pakistan - onshore','Bangladesh - onshore; India - mainland onshore; Myanmar (Burma) - onshore; Pakistan - onshore.',8.02,37.07,60.86,101.17,'urn:ogc:def:extent-polygon:EPSG::1307','','',Null,'','OGP','IOGP','2017-03-19','2004.290 2012.041 2014.024 2017.008',false),
-(1308,'Asia - Bangladesh; India; Pakistan - onshore','Bangladesh - onshore; India - mainland onshore; Pakistan - onshore.',8.02,37.07,60.86,97.42,'urn:ogc:def:extent-polygon:EPSG::1308','','',Null,'','OGP','IOGP','2017-03-19','2012.041 2014.024 2017.008',false),
+(1308,'Asia - Bangladesh; India; Myanmar; Pakistan - onshore','Bangladesh - onshore; India - mainland onshore; Myanmar - onshore and Moattama area offshore; Pakistan - onshore.',8.02,37.07,60.86,101.17,'urn:ogc:def:extent-polygon:EPSG::1308','','',Null,'','OGP','IOGP','2018-04-20','2012.041 2014.024 2017.008 2018.007',false),
 (1309,'Asia - Malaysia (west) and Singapore','Malaysia - West Malaysia; Singapore.',1.13,6.72,99.59,104.6,'urn:ogc:def:extent-polygon:EPSG::1309','','',Null,'','OGP','OGP','2014-05-01','2012.040 2014.024',false),
 (1310,'Kuwait - Kuwait City','Kuwait - Kuwait City.',29.17,29.45,47.78,48.16,'urn:ogc:def:extent-polygon:EPSG::1310','','',Null,'','OGP','OGP','2014-05-01','2012.051 2014.024',false),
 (1311,'Venezuela - Cabimas','Venezuela - Cabimas area.',10.14,10.61,-71.55,-71.29,'urn:ogc:def:extent-polygon:EPSG::1311','','',Null,'','OGP','OGP','2014-05-01','2011.004 2014.024',false),
@@ -10009,7 +10176,7 @@ INSERT INTO epsg_area VALUES
 (1346,'Qatar - onshore','Qatar - onshore.',24.55,26.2,50.69,51.68,'urn:ogc:def:extent-polygon:EPSG::1346','','',Null,'','OGP','OGP','2014-05-01','2012.051 2014.024',false),
 (1347,'Belgium - onshore','Belgium - onshore.',49.5,51.51,2.5,6.4,'urn:ogc:def:extent-polygon:EPSG::1347','','',Null,'','OGP','OGP','2014-05-01','2011.095 2014.024',false),
 (1348,'South America - PSAD56 by country','Aruba - onshore; Bolivia; Bonaire - onshore; Brazil - offshore - Amazon Cone shelf; Chile - onshore north of 43°30''S; Curacao - onshore; Ecuador - mainland onshore; Guyana - onshore; Peru - onshore; Venezuela - onshore.',-43.5,12.68,-81.41,-47.99,'urn:ogc:def:extent-polygon:EPSG::1348','','',Null,'','OGP','OGP','2014-11-21','2005.144 2006.480 2010.097 2011.037 2012.044 2014.024 2014.082 2014.083',false),
-(1349,'North America - NAD27','North and central America: Antigua and Barbuda - onshore. Bahamas - onshore plus offshore over internal continental shelf only. Belize - onshore. British Virgin Islands - onshore. Canada onshore - Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Northwest Territories, Nova Scotia, Nunavut, Ontario, Prince Edward Island, Quebec, Saskatchewan and Yukon - plus offshore east coast. Cuba - onshore and offshore. El Salvador - onshore. Guatemala - onshore. Honduras - onshore. Puerto Rico - onshore. Mexico - onshore plus offshore east coast. Nicaragua - onshore. United States (USA) onshore and offshore - Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, Nort
 h Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin and Wyoming - plus offshore . US Virgin Islands - onshore.',7.98,83.17,167.65,-47.74,'urn:ogc:def:extent-polygon:EPSG::1349','','',Null,'Area crosses 180-degree meridian.','OGP','IOGP','2017-03-19','2006.463 2007.028 2009.063 2010.088 2011.043 2014.024 2017.008',false),
+(1349,'North America - NAD27','North and central America: Antigua and Barbuda - onshore. Bahamas - onshore plus offshore over internal continental shelf only. Belize - onshore. British Virgin Islands - onshore. Canada onshore - Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Northwest Territories, Nova Scotia, Nunavut, Ontario, Prince Edward Island, Quebec, Saskatchewan and Yukon - plus offshore east coast. Cuba - onshore and offshore. El Salvador - onshore. Guatemala - onshore. Honduras - onshore. Panama - onshore. Puerto Rico - onshore. Mexico - onshore plus offshore east coast. Nicaragua - onshore. United States (USA) onshore and offshore - Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, No
 rth Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin and Wyoming - plus offshore . US Virgin Islands - onshore.',7.15,83.17,167.65,-47.74,'urn:ogc:def:extent-polygon:EPSG::1349','','',Null,'Area crosses 180-degree meridian.','OGP','IOGP','2018-04-20','2006.463 2007.028 2009.063 2010.088 2011.043 2014.024 2017.008 2018.007',false),
 (1350,'North America - NAD83','North America - onshore and offshore: Canada - Alberta; British Columbia; Manitoba; New Brunswick; Newfoundland and Labrador; Northwest Territories; Nova Scotia; Nunavut; Ontario; Prince Edward Island; Quebec; Saskatchewan; Yukon. Puerto Rico. United States (USA) - Alabama; Alaska; Arizona; Arkansas; California; Colorado; Connecticut; Delaware; Florida; Georgia; Hawaii; Idaho; Illinois; Indiana; Iowa; Kansas; Kentucky; Louisiana; Maine; Maryland; Massachusetts; Michigan; Minnesota; Mississippi; Missouri; Montana; Nebraska; Nevada; New Hampshire; New Jersey; New Mexico; New York; North Carolina; North Dakota; Ohio; Oklahoma; Oregon; Pennsylvania; Rhode Island; South Carolina; South Dakota; Tennessee; Texas; Utah; Vermont; Virginia; Washington; West Virginia; Wisconsin; Wyoming. US Virgin Islands.  British Virgin Islands.',14.92,86.46,167.65,-47.74,'urn:ogc:def:extent-polygon:EPSG::1350','','',Null,'Area crosses 180-degree meridian.','OGP','OGP','2014-05
 -01','2006.462 2006.463 2006.464 2007.028 2009.064 2011.043 2014.024',false),
 (1351,'Asia - Middle East - Qatar offshore and UAE','Arabian Gulf; Qatar - offshore; United Arab Emirates (UAE) - Abu Dhabi; Dubai; Sharjah; Ajman; Fujairah; Ras Al Kaimah; Umm Al Qaiwain - onshore and offshore.',22.63,27.05,50.55,57.13,'urn:ogc:def:extent-polygon:EPSG::1351','','',Null,'Adjustment included Gulf coast area of Saudi Arabia but geodetic entities not in use there.','OGP','OGP','2015-02-12','2006.340 2012.004 2012.051 2014.024 2014.070',false),
 (1352,'Norway - onshore','Norway - onshore.',57.93,71.21,4.68,31.22,'urn:ogc:def:extent-polygon:EPSG::1352','','',Null,'','OGP','OGP','2014-05-01','2009.105 2011.112 2014.024',false),
@@ -10018,7 +10185,7 @@ INSERT INTO epsg_area VALUES
 (1355,'Indonesia - Sumatra','Indonesia - Sumatra.',-5.99,5.97,95.16,106.13,'urn:ogc:def:extent-polygon:EPSG::1355','','',Null,'','OGP','OGP','2014-05-01','2012.040 2014.024',false),
 (1356,'Asia - Middle East - Israel, Jordan and Palestine onshore','Israel - onshore; Jordan; Palestine Territory - onshore.',29.18,33.38,34.17,39.31,'urn:ogc:def:extent-polygon:EPSG::1356','','',Null,'','OGP','OGP','2014-05-01','2002.340 2011.004 2012.051 2014.024',false),
 (1357,'Europe - eastern and FSU','Albania; Bulgaria; Czech Republic; Germany (former DDR); Hungary; Poland; Romania; Slovakia. Armenia; Azerbaijan; Belarus; Estonia; Georgia; Kazakhstan; Kyrgyzstan; Latvia; Lithuania; Moldova; Russian Federation; Tajikistan; Turkmenistan; Ukraine; Uzbekistan.',35.1,78,9.87,-169.73,'','','',Null,'Countries forming the former Warsaw Pact and FSU. Area crosses 180-degree meridian.','OGP','OGP','2008-09-24','2006.380 2008.011 2009.060',true),
-(1358,'South America - SAD69 by country','Brazil - onshore and offshore. In rest of South America - onshore north of approximately 45°S and Tierra del Fuego.',-55.96,12.52,-81.41,-25.28,'urn:ogc:def:extent-polygon:EPSG::1358','','',Null,'','OGP','OGP','2014-11-21','2008.045 2010.097 2011.037 2011.053 2012.070 2014.024 2014.082 2014.083',false),
+(1358,'South America - SAD69 by country','Brazil - onshore and offshore. In rest of South America - onshore north of approximately 45°S and Tierra del Fuego.',-55.96,12.52,-91.72,-25.28,'urn:ogc:def:extent-polygon:EPSG::1358','','',Null,'','OGP','IOGP','2018-04-20','2008.045 2010.097 2011.037 2011.053 2012.070 2014.024 2014.082 2014.083 2018.007',false),
 (1359,'Indonesia - Kalimantan SE','Indonesia - Kalimantan - onshore southeast coastal area including Mahakam delta coastal and offshore shelf areas.',-4.24,0,114.55,117.99,'urn:ogc:def:extent-polygon:EPSG::1359','','',Null,'','OGP','OGP','2014-05-01','2012.032 2012.040 2014.024',false),
 (1360,'Indonesia - Kalimantan E','Indonesia - Kalimantan - onshore east coastal area including Mahakam delta coastal and offshore shelf areas.',-4.24,4.29,114.55,119.06,'urn:ogc:def:extent-polygon:EPSG::1360','','',Null,'','OGP','OGP','2014-05-01','2012.032 2012.040 2014.024',false),
 (1361,'Sudan - south','Sudan - south.',Null,Null,Null,Null,'','','',Null,'','OGP','OGP','1995-06-02','',true),
@@ -10036,7 +10203,7 @@ INSERT INTO epsg_area VALUES
 (1373,'USA - Arizona','United States (USA) - Arizona.',31.33,37.01,-114.81,-109.04,'urn:ogc:def:extent-polygon:EPSG::1373','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.069 2014.024',false),
 (1374,'USA - Arkansas','United States (USA) - Arkansas.',33.01,36.5,-94.62,-89.64,'urn:ogc:def:extent-polygon:EPSG::1374','','',Null,'','OGP','OGP','2014-05-01','2008.070 2014.024',false),
 (1375,'USA - California','United States (USA) - California.',32.53,42.01,-124.45,-114.12,'urn:ogc:def:extent-polygon:EPSG::1375','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.069 2014.024',false),
-(1376,'USA - Colorado','United States (USA) - Colorado.',36.98,41.01,-109.06,-102.03,'urn:ogc:def:extent-polygon:EPSG::1376','','',Null,'','OGP','OGP','2014-05-01','2008.070 2014.024',false),
+(1376,'USA - Colorado','United States (USA) - Colorado.',36.98,41.01,-109.06,-102.04,'urn:ogc:def:extent-polygon:EPSG::1376','','',Null,'','OGP','IOGP','2018-04-20','2008.070 2014.024 2018.016',false),
 (1377,'USA - Connecticut','United States (USA) - Connecticut - counties of Fairfield; Hartford; Litchfield; Middlesex; New Haven; New London; Tolland; Windham.',40.98,42.05,-73.73,-71.78,'urn:ogc:def:extent-polygon:EPSG::1377','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.069 2014.024',false),
 (1378,'USA - Delaware','United States (USA) - Delaware - counties of Kent; New Castle; Sussex.',38.44,39.85,-75.8,-74.97,'urn:ogc:def:extent-polygon:EPSG::1378','','',Null,'','OGP','OGP','2014-05-01','2008.070 2014.024',false),
 (1379,'USA - Florida','United States (USA) - Florida.',24.41,31.01,-87.63,-79.97,'urn:ogc:def:extent-polygon:EPSG::1379','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.069 2014.024',false),
@@ -10045,7 +10212,7 @@ INSERT INTO epsg_area VALUES
 (1382,'USA - Illinois','United States (USA) - Illinois.',36.98,42.51,-91.52,-87.02,'urn:ogc:def:extent-polygon:EPSG::1382','','',Null,'','OGP','IOGP','2015-09-21','2008.070 2011.069 2014.024 2015.029',false),
 (1383,'USA - Indiana','United States (USA) - Indiana.',37.77,41.77,-88.06,-84.78,'urn:ogc:def:extent-polygon:EPSG::1383','','',Null,'','OGP','IOGP','2015-09-21','2008.070 2012.060 2014.024 2015.029',false),
 (1384,'USA - Iowa','United States (USA) - Iowa.',40.37,43.51,-96.65,-90.14,'urn:ogc:def:extent-polygon:EPSG::1384','','',Null,'','OGP','IOGP','2015-09-21','2008.070 2014.024 2015.044',false),
-(1385,'USA - Kansas','United States (USA) - Kansas.',36.98,40.01,-102.06,-94.6,'urn:ogc:def:extent-polygon:EPSG::1385','','',Null,'','OGP','OGP','2014-05-01','2008.070 2014.024',false),
+(1385,'USA - Kansas','United States (USA) - Kansas.',36.99,40.01,-102.06,-94.58,'urn:ogc:def:extent-polygon:EPSG::1385','','',Null,'','OGP','IOGP','2018-04-20','2008.070 2014.024 2018.016',false),
 (1386,'USA - Kentucky','United States (USA) - Kentucky.',36.49,39.15,-89.57,-81.95,'urn:ogc:def:extent-polygon:EPSG::1386','','',Null,'','OGP','IOGP','2015-09-21','2008.070 2011.069 2014.024 2015.029',false),
 (1387,'USA - Louisiana','United States (USA) - Louisiana.',28.85,33.03,-94.05,-88.75,'urn:ogc:def:extent-polygon:EPSG::1387','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.069 2014.024',false),
 (1388,'USA - Maine','United States (USA) - Maine.',43.04,47.47,-71.09,-66.91,'urn:ogc:def:extent-polygon:EPSG::1388','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.069 2014.024',false),
@@ -10065,7 +10232,7 @@ INSERT INTO epsg_area VALUES
 (1402,'USA - North Carolina','United States (USA) - North Carolina - counties of Alamance; Alexander; Alleghany; Anson; Ashe; Avery; Beaufort; Bertie; Bladen; Brunswick; Buncombe; Burke; Cabarrus; Caldwell; Camden; Carteret; Caswell; Catawba; Chatham; Cherokee; Chowan; Clay; Cleveland; Columbus; Craven; Cumberland; Currituck; Dare; Davidson; Davie; Duplin; Durham; Edgecombe; Forsyth; Franklin; Gaston; Gates; Graham; Granville; Greene; Guilford; Halifax; Harnett; Haywood; Henderson; Hertford; Hoke; Hyde; Iredell; Jackson; Johnston; Jones; Lee; Lenoir; Lincoln; Macon; Madison; Martin; McDowell; Mecklenburg; Mitchell; Montgomery; Moore; Nash; New Hanover; Northampton; Onslow; Orange; Pamlico; Pasquotank; Pender; Perquimans; Person; Pitt; Polk; Randolph; Richmond; Robeson; Rockingham; Rowan; Rutherford; Sampson; Scotland; Stanly; Stokes; Surry; Swain; Transylvania; Tyrrell; Union; Vance; Wake; Warren; Washington; Watauga; Wayne; Wilkes; Wilson; Yadkin; Yancey.',33.83,36.59,-84.33,-75.38
 ,'urn:ogc:def:extent-polygon:EPSG::1402','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.069 2014.023',false),
 (1403,'USA - North Dakota','United States (USA) - North Dakota.',45.93,49.01,-104.07,-96.55,'urn:ogc:def:extent-polygon:EPSG::1403','','',Null,'','OGP','OGP','2014-05-01','2008.070 2014.023',false),
 (1404,'USA - Ohio','United States (USA) - Ohio.',38.4,42.33,-84.83,-80.51,'urn:ogc:def:extent-polygon:EPSG::1404','','',Null,'','OGP','IOGP','2015-09-21','2008.070 2014.023 2015.029',false),
-(1405,'USA - Oklahoma','United States (USA) - Oklahoma.',33.62,37.01,-103,-94.42,'urn:ogc:def:extent-polygon:EPSG::1405','','',Null,'','OGP','OGP','2014-05-01','2008.070 2014.023',false),
+(1405,'USA - Oklahoma','United States (USA) - Oklahoma.',33.62,37.01,-103,-94.42,'urn:ogc:def:extent-polygon:EPSG::1405','','',Null,'','OGP','IOGP','2018-04-20','2008.070 2014.023 2018.016',false),
 (1406,'USA - Oregon','United States (USA) - Oregon.',41.98,46.26,-124.6,-116.47,'urn:ogc:def:extent-polygon:EPSG::1406','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.069 2014.023',false),
 (1407,'USA - Pennsylvania','United States (USA) - Pennsylvania.',39.71,42.53,-80.53,-74.7,'urn:ogc:def:extent-polygon:EPSG::1407','','',Null,'','OGP','OGP','2014-05-01','2008.070 2014.023',false),
 (1408,'USA - Rhode Island','United States (USA) - Rhode Island - counties of Bristol; Kent; Newport; Providence; Washington.',41.13,42.02,-71.85,-71.08,'urn:ogc:def:extent-polygon:EPSG::1408','','',Null,'','OGP','IOGP','2016-12-15','2008.070 2011.069 2014.023 2016.056',false),
@@ -10843,9 +11010,9 @@ INSERT INTO epsg_area VALUES
 (2180,'USA - California - SPCS - 6','United States (USA) - California - counties Imperial; Orange; Riverside; San Diego.',32.53,34.08,-118.15,-114.42,'urn:ogc:def:extent-polygon:EPSG::2180','','',Null,'','OGP','OGP','2011-07-27','2008.045 2008.070 2011.068',false),
 (2181,'USA - California - SPCS27 - 7','United States (USA) - California - Los Angeles county.',33.66,34.83,-118.96,-117.63,'urn:ogc:def:extent-polygon:EPSG::2181','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.068 2014.021',false),
 (2182,'USA - California - SPCS83 - 5','United States (USA) - California - counties Kern; Los Angeles; San Bernardino; San Luis Obispo; Santa Barbara; Ventura.',32.76,35.81,-121.42,-114.12,'urn:ogc:def:extent-polygon:EPSG::2182','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.068 2014.021',false),
-(2183,'USA - Colorado - SPCS - C','United States (USA) - Colorado - counties Arapahoe; Chaffee; Cheyenne; Clear Creek; Delta; Denver; Douglas; Eagle; El Paso; Elbert; Fremont; Garfield; Gunnison; Jefferson; Kit Carson; Lake; Lincoln; Mesa; Park; Pitkin; Summit; Teller.',38.14,40.09,-109.06,-102.04,'urn:ogc:def:extent-polygon:EPSG::2183','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.068 2014.021',false),
-(2184,'USA - Colorado - SPCS - N','United States (USA) - Colorado - counties Adams; Boulder; Gilpin; Grand; Jackson; Larimer; Logan; Moffat; Morgan; Phillips; Rio Blanco; Routt; Sedgwick; Washington; Weld; Yuma.',39.56,41.01,-109.06,-102.04,'urn:ogc:def:extent-polygon:EPSG::2184','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.068 2014.021',false),
-(2185,'USA - Colorado - SPCS - S','United States (USA) - Colorado - counties Alamosa; Archuleta; Baca; Bent; Conejos; Costilla; Crowley; Custer; Dolores; Hinsdale; Huerfano; Kiowa; La Plata; Las Animas; Mineral; Montezuma; Montrose; Otero; Ouray; Prowers; Pueblo; Rio Grande; Saguache; San Juan; San Miguel.',36.98,38.68,-109.06,-102.03,'urn:ogc:def:extent-polygon:EPSG::2185','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.068 2014.021',false),
+(2183,'USA - Colorado - SPCS - C','United States (USA) - Colorado - counties Arapahoe; Chaffee; Cheyenne; Clear Creek; Delta; Denver; Douglas; Eagle; El Paso; Elbert; Fremont; Garfield; Gunnison; Jefferson; Kit Carson; Lake; Lincoln; Mesa; Park; Pitkin; Summit; Teller.',38.14,40.09,-109.06,-102.04,'urn:ogc:def:extent-polygon:EPSG::2183','','',Null,'','OGP','IOGP','2018-04-20','2008.045 2008.070 2011.068 2014.021 2018.016',false),
+(2184,'USA - Colorado - SPCS - N','United States (USA) - Colorado - counties Adams; Boulder; Gilpin; Grand; Jackson; Larimer; Logan; Moffat; Morgan; Phillips; Rio Blanco; Routt; Sedgwick; Washington; Weld; Yuma.',39.56,41.01,-109.06,-102.04,'urn:ogc:def:extent-polygon:EPSG::2184','','',Null,'','OGP','IOGP','2018-04-20','2008.045 2008.070 2011.068 2014.021 2018.016',false),
+(2185,'USA - Colorado - SPCS - S','United States (USA) - Colorado - counties Alamosa; Archuleta; Baca; Bent; Conejos; Costilla; Crowley; Custer; Dolores; Hinsdale; Huerfano; Kiowa; La Plata; Las Animas; Mineral; Montezuma; Montrose; Otero; Ouray; Prowers; Pueblo; Rio Grande; Saguache; San Juan; San Miguel.',36.98,38.68,-109.06,-102.04,'urn:ogc:def:extent-polygon:EPSG::2185','','',Null,'','OGP','IOGP','2018-04-20','2008.045 2008.070 2011.068 2014.021 2018.016',false),
 (2186,'USA - Florida - SPCS - E','United States (USA) - Florida - counties of Brevard; Broward; Clay; Collier; Dade; Duval; Flagler; Glades; Hendry; Highlands; Indian River; Lake; Martin; Monroe; Nassau; Okeechobee; Orange; Osceola; Palm Beach; Putnam; Seminole; St Johns; St Lucie; Volusia.',24.41,30.83,-82.33,-79.97,'urn:ogc:def:extent-polygon:EPSG::2186','','',Null,'','OGP','OGP','2011-08-17','2008.045 2008.070 2011.069',false),
 (2187,'USA - Florida - SPCS - N','United States (USA) - Florida - counties of Alachua; Baker; Bay; Bradford; Calhoun; Columbia; Dixie; Escambia; Franklin; Gadsden; Gilchrist; Gulf; Hamilton; Holmes; Jackson; Jefferson; Lafayette; Leon; Liberty; Madison; Okaloosa; Santa Rosa; Suwannee; Taylor; Union; Wakulla; Walton; Washington.',29.21,31.01,-87.63,-82.04,'urn:ogc:def:extent-polygon:EPSG::2187','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.069 2014.021',false),
 (2188,'USA - Florida - SPCS - W','United States (USA) - Florida - counties of Charlotte; Citrus; De Soto; Hardee; Hernando; Hillsborough; Lee; Levy; Manatee; Marion; Pasco; Pinellas; Polk; Sarasota; Sumter.',26.27,29.6,-83.34,-81.13,'urn:ogc:def:extent-polygon:EPSG::2188','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.069 2014.021',false),
@@ -10860,8 +11027,8 @@ INSERT INTO epsg_area VALUES
 (2197,'USA - Indiana - SPCS - W','United States (USA) - Indiana - counties of Benton; Boone; Carroll; Clay; Clinton; Crawford; Daviess; Dubois; Fountain; Gibson; Greene; Hendricks; Jasper; Knox; La Porte; Lake; Lawrence; Martin; Monroe; Montgomery; Morgan; Newton; Orange; Owen; Parke; Perry; Pike; Porter; Posey; Pulaski; Putnam; Spencer; Starke; Sullivan; Tippecanoe; Vanderburgh; Vermillion; Vigo; Warren; Warrick; White.',37.77,41.77,-88.06,-86.24,'urn:ogc:def:extent-polygon:EPSG::2197','','',Null,'','OGP','IOGP','2015-09-21','2008.045 2008.070 2011.068 2014.021 2015.029',false),
 (2198,'USA - Iowa - SPCS - N','United States (USA) - Iowa - counties of Allamakee; Benton; Black Hawk; Boone; Bremer; Buchanan; Buena Vista; Butler; Calhoun; Carroll; Cerro Gordo; Cherokee; Chickasaw; Clay; Clayton; Crawford; Delaware; Dickinson; Dubuque; Emmet; Fayette; Floyd; Franklin; Greene; Grundy; Hamilton; Hancock; Hardin; Howard; Humboldt; Ida; Jackson; Jones; Kossuth; Linn; Lyon; Marshall; Mitchell; Monona; O''Brien; Osceola; Palo Alto; Plymouth; Pocahontas; Sac; Sioux; Story; Tama; Webster; Winnebago; Winneshiek; Woodbury; Worth; Wright.',41.85,43.51,-96.65,-90.15,'urn:ogc:def:extent-polygon:EPSG::2198','','',Null,'','OGP','IOGP','2015-09-21','2008.045 2008.070 2011.068 2014.021 2015.044',false),
 (2199,'USA - Iowa - SPCS - S','United States (USA) - Iowa - counties of Adair; Adams; Appanoose; Audubon; Cass; Cedar; Clarke; Clinton; Dallas; Davis; Decatur; Des Moines; Fremont; Guthrie; Harrison; Henry; Iowa; Jasper; Jefferson; Johnson; Keokuk; Lee; Louisa; Lucas; Madison; Mahaska; Marion; Mills; Monroe; Montgomery; Muscatine; Page; Polk; Pottawattamie; Poweshiek; Ringgold; Scott; Shelby; Taylor; Union; Van Buren; Wapello; Warren; Washington; Wayne.',40.37,42.04,-96.14,-90.14,'urn:ogc:def:extent-polygon:EPSG::2199','','',Null,'','OGP','OGP','2011-07-27','2008.045 2008.070 2011.068',false),
-(2200,'USA - Kansas - SPCS - N','United States (USA) - Kansas - counties of Atchison; Brown; Cheyenne; Clay; Cloud; Decatur; Dickinson; Doniphan; Douglas; Ellis; Ellsworth; Geary; Gove; Graham; Jackson; Jefferson; Jewell; Johnson; Leavenworth; Lincoln; Logan; Marshall; Mitchell; Morris; Nemaha; Norton; Osborne; Ottawa; Phillips; Pottawatomie; Rawlins; Republic; Riley; Rooks; Russell; Saline; Shawnee; Sheridan; Sherman; Smith; Thomas; Trego; Wabaunsee; Wallace; Washington; Wyandotte.',38.51,40.01,-102.06,-94.6,'urn:ogc:def:extent-polygon:EPSG::2200','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.068 2014.021',false),
-(2201,'USA - Kansas - SPCS - S','United States (USA) - Kansas - counties of Allen; Anderson; Barber; Barton; Bourbon; Butler; Chase; Chautauqua; Cherokee; Clark; Coffey; Comanche; Cowley; Crawford; Edwards; Elk; Finney; Ford; Franklin; Grant; Gray; Greeley; Greenwood; Hamilton; Harper; Harvey; Haskell; Hodgeman; Kearny; Kingman; Kiowa; Labette; Lane; Linn; Lyon; Marion; McPherson; Meade; Miami; Montgomery; Morton; Neosho; Ness; Osage; Pawnee; Pratt; Reno; Rice; Rush; Scott; Sedgwick; Seward; Stafford; Stanton; Stevens; Sumner; Wichita; Wilson; Woodson.',36.98,38.87,-102.05,-94.61,'urn:ogc:def:extent-polygon:EPSG::2201','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.068 2014.021',false),
+(2200,'USA - Kansas - SPCS - N','United States (USA) - Kansas - counties of Atchison; Brown; Cheyenne; Clay; Cloud; Decatur; Dickinson; Doniphan; Douglas; Ellis; Ellsworth; Geary; Gove; Graham; Jackson; Jefferson; Jewell; Johnson; Leavenworth; Lincoln; Logan; Marshall; Mitchell; Morris; Nemaha; Norton; Osborne; Ottawa; Phillips; Pottawatomie; Rawlins; Republic; Riley; Rooks; Russell; Saline; Shawnee; Sheridan; Sherman; Smith; Thomas; Trego; Wabaunsee; Wallace; Washington; Wyandotte.',38.52,40.01,-102.06,-94.58,'urn:ogc:def:extent-polygon:EPSG::2200','','',Null,'','OGP','IOGP','2018-04-20','2008.045 2008.070 2011.068 2014.021 2018.016',false),
+(2201,'USA - Kansas - SPCS - S','United States (USA) - Kansas - counties of Allen; Anderson; Barber; Barton; Bourbon; Butler; Chase; Chautauqua; Cherokee; Clark; Coffey; Comanche; Cowley; Crawford; Edwards; Elk; Finney; Ford; Franklin; Grant; Gray; Greeley; Greenwood; Hamilton; Harper; Harvey; Haskell; Hodgeman; Kearny; Kingman; Kiowa; Labette; Lane; Linn; Lyon; Marion; McPherson; Meade; Miami; Montgomery; Morton; Neosho; Ness; Osage; Pawnee; Pratt; Reno; Rice; Rush; Scott; Sedgwick; Seward; Stafford; Stanton; Stevens; Sumner; Wichita; Wilson; Woodson.',36.99,38.88,-102.05,-94.6,'urn:ogc:def:extent-polygon:EPSG::2201','','',Null,'','OGP','IOGP','2018-04-20','2008.045 2008.070 2011.068 2014.021 2018.016',false),
 (2202,'USA - Kentucky - SPCS - N','United States (USA) - Kentucky - counties of Anderson; Bath; Boone; Bourbon; Boyd; Bracken; Bullitt; Campbell; Carroll; Carter; Clark; Elliott; Fayette; Fleming; Franklin; Gallatin; Grant; Greenup; Harrison; Henry; Jefferson; Jessamine; Kenton; Lawrence; Lewis; Mason; Menifee; Montgomery; Morgan; Nicholas; Oldham; Owen; Pendleton; Robertson; Rowan; Scott; Shelby; Spencer; Trimble; Woodford.',37.71,39.15,-85.96,-82.47,'urn:ogc:def:extent-polygon:EPSG::2202','','',Null,'','OGP','IOGP','2015-09-21','2008.045 2008.070 2011.068 2014.021 2015.029',false),
 (2203,'USA - Kentucky - SPCS - S','United States (USA) - Kentucky - counties of Adair; Allen; Ballard; Barren; Bell; Boyle; Breathitt; Breckinridge; Butler; Caldwell; Calloway; Carlisle; Casey; Christian; Clay; Clinton; Crittenden; Cumberland; Daviess; Edmonson; Estill; Floyd; Fulton; Garrard; Graves; Grayson; Green; Hancock; Hardin; Harlan; Hart; Henderson; Hickman; Hopkins; Jackson; Johnson; Knott; Knox; Larue; Laurel; Lee; Leslie; Letcher; Lincoln; Livingston; Logan; Lyon; Madison; Magoffin; Marion; Marshall; Martin; McCracken; McCreary; McLean; Meade; Mercer; Metcalfe; Monroe; Muhlenberg; Nelson; Ohio; Owsley; Perry; Pike; Powell; Pulaski; Rockcastle; Russell; Simpson; Taylor; Todd; Trigg; Union; Warren; Washington; Wayne; Webster; Whitley; Wolfe.',36.49,38.17,-89.57,-81.95,'urn:ogc:def:extent-polygon:EPSG::2203','','',Null,'','OGP','IOGP','2015-09-21','2008.045 2008.070 2011.068 2014.021 2015.029',false),
 (2204,'USA - Louisiana - SPCS - N','United States (USA) - Louisiana - counties of Avoyelles; Bienville; Bossier; Caddo; Caldwell; Catahoula; Claiborne; Concordia; De Soto; East Carroll; Franklin; Grant; Jackson; La Salle; Lincoln; Madison; Morehouse; Natchitoches; Ouachita; Rapides; Red River; Richland; Sabine; Tensas; Union; Vernon; Webster; West Carroll; Winn.',30.85,33.03,-94.05,-90.86,'urn:ogc:def:extent-polygon:EPSG::2204','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.068 2014.021',false),
@@ -10880,9 +11047,9 @@ INSERT INTO epsg_area VALUES
 (2217,'USA - Mississippi - SPCS - W','United States (USA) - Mississippi - counties of Adams; Amite; Bolivar; Carroll; Claiborne; Coahoma; Copiah; De Soto; Franklin; Grenada; Hinds; Holmes; Humphreys; Issaquena; Jefferson; Jefferson Davis; Lawrence; Leflore; Lincoln; Madison; Marion; Montgomery; Panola; Pike; Quitman; Rankin; Sharkey; Simpson; Sunflower; Tallahatchie; Tate; Tunica; Walthall; Warren; Washington; Wilkinson; Yalobusha; Yazoo.',31,35.01,-91.65,-89.37,'urn:ogc:def:extent-polygon:EPSG::2217','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
 (2218,'USA - Missouri - SPCS - C','United States (USA) - Missouri - counties of Adair; Audrain; Benton; Boone; Callaway; Camden; Carroll; Chariton; Christian; Cole; Cooper; Dallas; Douglas; Greene; Grundy; Hickory; Howard; Howell; Knox; Laclede; Linn; Livingston; Macon; Maries; Mercer; Miller; Moniteau; Monroe; Morgan; Osage; Ozark; Pettis; Phelps; Polk; Pulaski; Putnam; Randolph; Saline; Schuyler; Scotland; Shelby; Stone; Sullivan; Taney; Texas; Webster; Wright.',36.48,40.61,-93.79,-91.41,'urn:ogc:def:extent-polygon:EPSG::2218','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
 (2219,'USA - Missouri - SPCS - E','United States (USA) - Missouri - counties of Bollinger; Butler; Cape Girardeau; Carter; Clark; Crawford; Dent; Dunklin; Franklin; Gasconade; Iron; Jefferson; Lewis; Lincoln; Madison; Marion; Mississippi; Montgomery; New Madrid; Oregon; Pemiscot; Perry; Pike; Ralls; Reynolds; Ripley; Scott; Shannon; St Charles; St Francois; St Louis; Ste. Genevieve; Stoddard; Warren; Washington; Wayne.',35.98,40.61,-91.97,-89.1,'urn:ogc:def:extent-polygon:EPSG::2219','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
-(2220,'USA - Missouri - SPCS - W','United States (USA) - Missouri - counties of Andrew; Atchison; Barry; Barton; Bates; Buchanan; Caldwell; Cass; Cedar; Clay; Clinton; Dade; Daviess; De Kalb; Gentry; Harrison; Henry; Holt; Jackson; Jasper; Johnson; Lafayette; Lawrence; McDonald; Newton; Nodaway; Platte; Ray; St Clair; Vernon; Worth.',36.48,40.59,-95.77,-93.48,'urn:ogc:def:extent-polygon:EPSG::2220','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
+(2220,'USA - Missouri - SPCS - W','United States (USA) - Missouri - counties of Andrew; Atchison; Barry; Barton; Bates; Buchanan; Caldwell; Cass; Cedar; Clay; Clinton; Dade; Daviess; De Kalb; Gentry; Harrison; Henry; Holt; Jackson; Jasper; Johnson; Lafayette; Lawrence; McDonald; Newton; Nodaway; Platte; Ray; St Clair; Vernon; Worth.',36.48,40.59,-95.77,-93.48,'urn:ogc:def:extent-polygon:EPSG::2220','','',Null,'','OGP','IOGP','2018-04-20','2008.045 2008.070 2011.067 2014.021 2018.016',false),
 (2221,'USA - Nebraska - SPCS27 - N','United States (USA) - Nebraska - counties of Antelope; Blaine; Box Butte; Boyd; Brown; Burt; Cedar; Cherry; Cuming; Dakota; Dawes; Dixon; Garfield; Grant; Holt; Hooker; Keya Paha; Knox; Loup; Madison; Pierce; Rock; Sheridan; Sioux; Stanton; Thomas; Thurston; Wayne; Wheeler.',41.68,43.01,-104.06,-96.07,'urn:ogc:def:extent-polygon:EPSG::2221','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.067 2014.021',false),
-(2222,'USA - Nebraska - SPCS27 - S','United States (USA) - Nebraska - counties of Adams; Arthur; Banner; Boone; Buffalo; Butler; Cass; Chase; Cheyenne; Clay; Colfax; Custer; Dawson; Deuel; Dodge; Douglas; Dundy; Fillmore; Franklin; Frontier; Furnas; Gage; Garden; Gosper; Greeley; Hall; Hamilton; Harlan; Hayes; Hitchcock; Howard; Jefferson; Johnson; Kearney; Keith; Kimball; Lancaster; Lincoln; Logan; McPherson; Merrick; Morrill; Nance; Nemaha; Nuckolls; Otoe; Pawnee; Perkins; Phelps; Platte; Polk; Red Willow; Richardson; Saline; Sarpy; Saunders; Scotts Bluff; Seward; Sherman; Thayer; Valley; Washington; Webster; York.',39.99,42.01,-104.06,-95.3,'urn:ogc:def:extent-polygon:EPSG::2222','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.067 2014.021',false),
+(2222,'USA - Nebraska - SPCS27 - S','United States (USA) - Nebraska - counties of Adams; Arthur; Banner; Boone; Buffalo; Butler; Cass; Chase; Cheyenne; Clay; Colfax; Custer; Dawson; Deuel; Dodge; Douglas; Dundy; Fillmore; Franklin; Frontier; Furnas; Gage; Garden; Gosper; Greeley; Hall; Hamilton; Harlan; Hayes; Hitchcock; Howard; Jefferson; Johnson; Kearney; Keith; Kimball; Lancaster; Lincoln; Logan; McPherson; Merrick; Morrill; Nance; Nemaha; Nuckolls; Otoe; Pawnee; Perkins; Phelps; Platte; Polk; Red Willow; Richardson; Saline; Sarpy; Saunders; Scotts Bluff; Seward; Sherman; Thayer; Valley; Washington; Webster; York.',39.99,42.01,-104.06,-95.3,'urn:ogc:def:extent-polygon:EPSG::2222','','',Null,'','OGP','IOGP','2018-04-20','2008.070 2011.067 2014.021 2018.016',false),
 (2223,'USA - Nevada - SPCS - C','United States (USA) - Nevada - counties of Lander; Nye.',36,41,-118.19,-114.99,'urn:ogc:def:extent-polygon:EPSG::2223','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
 (2224,'USA - Nevada - SPCS - E','United States (USA) - Nevada - counties of Clark; Elko; Eureka; Lincoln; White Pine.',34.99,42,-117.01,-114.03,'urn:ogc:def:extent-polygon:EPSG::2224','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
 (2225,'USA - Nevada - SPCS - W','United States (USA) - Nevada - counties of Churchill; Douglas; Esmeralda; Humboldt; Lyon; Mineral; Pershing; Storey; Washoe.',36.95,42,-120,-116.99,'urn:ogc:def:extent-polygon:EPSG::2225','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
@@ -10895,13 +11062,13 @@ INSERT INTO epsg_area VALUES
 (2232,'USA - New Mexico - SPCS83 - W','United States (USA) - New Mexico - counties of Catron; Cibola; Grant; Hidalgo; Luna; McKinley; San Juan; Sierra.',31.33,37,-109.06,-106.32,'urn:ogc:def:extent-polygon:EPSG::2232','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
 (2233,'USA - New York - SPCS - C','United States (USA) - New York - counties of Broome; Cayuga; Chemung; Chenango; Cortland; Jefferson; Lewis; Madison; Oneida; Onondaga; Ontario; Oswego; Schuyler; Seneca; Steuben; Tioga; Tompkins; Wayne; Yates.',41.99,44.41,-77.75,-75.04,'urn:ogc:def:extent-polygon:EPSG::2233','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
 (2234,'USA - New York - SPCS - E','United States (USA) - New York mainland - counties of Albany; Clinton; Columbia; Delaware; Dutchess; Essex; Franklin; Fulton; Greene; Hamilton; Herkimer; Montgomery; Orange; Otsego; Putnam; Rensselaer; Rockland; Saratoga; Schenectady; Schoharie; St Lawrence; Sullivan; Ulster; Warren; Washington; Westchester.',40.88,45.02,-75.87,-73.23,'urn:ogc:def:extent-polygon:EPSG::2234','','',Null,'','OGP','IOGP','2016-12-15','2008.045 2008.070 2011.067 2014.021 2016.056',false),
-(2235,'USA - New York - SPCS - Long island','United States (USA) - New York - counties of Bronx; Kings; Nassau; New York; Queens; Richmond; Suffolk.',40.47,41.3,-74.26,-71.8,'urn:ogc:def:extent-polygon:EPSG::2235','','',Null,'','OGP','IOGP','2016-12-15','2008.070 2011.067 2014.021 2016.056',false),
+(2235,'USA - New York - SPCS - Long Island','United States (USA) - New York - counties of Bronx; Kings; Nassau; New York; Queens; Richmond; Suffolk.',40.47,41.3,-74.26,-71.8,'urn:ogc:def:extent-polygon:EPSG::2235','','',Null,'','OGP','IOGP','2018-01-19','2008.070 2011.067 2014.021 2016.056 2017.054',false),
 (2236,'USA - New York - SPCS - W','United States (USA) - New York - counties of Allegany; Cattaraugus; Chautauqua; Erie; Genesee; Livingston; Monroe; Niagara; Orleans; Wyoming.',41.99,43.64,-79.77,-77.36,'urn:ogc:def:extent-polygon:EPSG::2236','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
 (2237,'USA - North Dakota - SPCS - N','United States (USA) - North Dakota - counties of Benson; Bottineau; Burke; Cavalier; Divide; Eddy; Foster; Grand Forks; Griggs; McHenry; McKenzie; McLean; Mountrial; Nelson; Pembina; Pierce; Ramsey; Renville; Rolette; Sheridan; Steele; Towner; Traill; Walsh; Ward; Wells; Williams.',47.15,49.01,-104.07,-96.83,'urn:ogc:def:extent-polygon:EPSG::2237','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),
 (2238,'USA - North Dakota - SPCS - S','United States (USA) - North Dakota - counties of Adams; Barnes; Billings; Bowman; Burleigh; Cass; Dickey; Dunn; Emmons; Golden Valley; Grant; Hettinger; Kidder; La Moure; Logan; McIntosh; Mercer; Morton; Oliver; Ransom; Richland; Sargent; Sioux; Slope; Stark; Stutsman.',45.93,47.83,-104.05,-96.55,'urn:ogc:def:extent-polygon:EPSG::2238','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.070 2011.067 2014.021',false),

[... 4989 lines stripped ...]


Mime
View raw message