sis-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From desruisse...@apache.org
Subject svn commit: r1861146 - /sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql
Date Wed, 12 Jun 2019 16:17:51 GMT
Author: desruisseaux
Date: Wed Jun 12 16:17:51 2019
New Revision: 1861146

URL: http://svn.apache.org/viewvc?rev=1861146&view=rev
Log:
Update EPSG database to 9.6.3.

Modified:
    sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql

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=1861146&r1=1861145&r2=1861146&view=diff
==============================================================================
--- sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql [UTF-8] (original)
+++ sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql [UTF-8] Wed Jun 12 16:17:51 2019
@@ -1,6 +1,6 @@
 ---
 ---    Copyright International Association of Oil and Gas Producers (IOGP)
----    See  http://www.epsg.org/TermsOfUse  (a copy is in ./LICENSE.txt).
+---    See  http://www.epsg.org/TermsOfUse.aspx  (a copy is in ./LICENSE.txt).
 ---
 ---    This file has been reformatted (without any change in the data) for the needs of Apache SIS project.
 ---    See org.apache.sis.referencing.factory.sql.epsg.DataScriptFormatter.
@@ -3550,8 +3550,7 @@ INSERT INTO epsg_alias VALUES
 (29430,'Coordinate Reference System',6204,7301,'MGI 1901 / Macedonia GK',''),
 (29431,'Coordinate Reference System',6204,7301,'MGI 1901 / Macedonia Gauss-Kruger',''),
 (29432,'Coordinate Reference System',6204,7302,'MSCS',''),
-(29434,'Coordinate Reference System',6316,7301,'Macedonia State Coordinate System','This is the name of a system with different easting values.'),
-(29435,'Coordinate Reference System',6316,7302,'MSCS zone 7',''),
+(29435,'Coordinate Reference System',6316,1045,'MSCS zone 7',''),
 (2944,'Coordinate Reference System',27394,7307,'NO_NGO1948 / NO_TM','This EuroGeographics identifier is used for all of zones 1 to 8.'),
 (2945,'Coordinate Reference System',27395,7307,'NO_NGO1948 / NO_TM','This EuroGeographics identifier is used for all of zones 1 to 8.'),
 (2946,'Coordinate Reference System',27396,7307,'NO_NGO1948 / NO_TM','This EuroGeographics identifier is used for all of zones 1 to 8.'),
@@ -4199,11 +4198,7 @@ INSERT INTO epsg_alias VALUES
 (31437,'Coordinate Reference System',6635,7302,'NAD83(PA11) / UTM 5N',''),
 (3144,'Datum',6725,7301,'Johnston Atoll 1961',''),
 (31442,'Coordinate Reference System',6636,7302,'NAD83(PA11) / UTM 2S',''),
-(31448,'Coordinate Reference System',6637,7302,'GGN93 / Guam Map Grid',''),
-(31449,'Coordinate Reference System',6637,7301,'Guam Geodetic Network 1993 / Guam Map Grid',''),
 (3145,'Coordinate_Operation Method',9636,7301,'Molodensky-Badekas (geog2D domain)',''),
-(31450,'Coordinate Reference System',6637,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).'),
-(31451,'Coordinate Reference System',6637,7301,'NAD83(MA11) / Guam Map Grid',''),
 (3146,'Coordinate Reference System',6798,7301,'NAD83(2011) / Oregon Bend-Vale zone (m)','Previous name.'),
 (31469,'Datum',1119,7302,'NMVD03',''),
 (3147,'Coordinate_Operation',15798,7313,'Astro DOS 71/4 to WGS 84',''),
@@ -5487,7 +5482,7 @@ INSERT INTO epsg_alias VALUES
 (4226,'Coordinate Reference System',4883,7309,'D96',''),
 (4227,'Coordinate Reference System',4882,7309,'D96',''),
 (4228,'Coordinate Reference System',4765,7309,'D96',''),
-(4229,'Coordinate Reference System',3794,7309,'D96 / TM',''),
+(4229,'Coordinate Reference System',3794,7309,'D96/TM',''),
 (423,'Coordinate_Operation',10403,7302,'California zone III',''),
 (4230,'Coordinate_Operation',15976,7301,'D96 to WGS 84 (1)',''),
 (4231,'Coordinate_Operation',15977,7301,'Slovenia 1996 to ETRF89 (1)',''),
@@ -6818,7 +6813,6 @@ INSERT INTO epsg_alias VALUES
 (5426,'Coordinate Reference System',3383,7302,'GDM2000 / Kedah Grid',''),
 (5427,'Coordinate Reference System',3388,7302,'Pulkovo 1942 / Caspian',''),
 (5428,'Coordinate_Operation',4114,7302,'Johor Grid',''),
-(5429,'Datum',1141,7302,'ITRF2008 (2005.0)',''),
 (543,'Coordinate_Operation',13131,7302,'New York East','This alias is ambiguous as also used for SPCS27 projection.'),
 (5430,'Coordinate_Operation',4321,7302,'Perak Revised Grid',''),
 (5431,'Coordinate Reference System',3396,7302,'PD/83 / 3GK zone 3',''),
@@ -8632,6 +8626,7 @@ INSERT INTO epsg_alias VALUES
 (706,'Coordinate_Operation',17525,7302,'S. African Grid zone 25',''),
 (7060,'Unit of Measure',9014,1040,'international fathom',''),
 (7061,'Unit of Measure',9093,1040,'mile',''),
+(7062,'Coordinate Reference System',6316,1045,'Macedonia State Coordinate System zone 7',''),
 (7063,'Unit of Measure',9102,1040,'angular degree',''),
 (7064,'Unit of Measure',9113,1040,'centesimal-second',''),
 (7065,'Unit of Measure',9114,1040,'angular mil',''),
@@ -8798,33 +8793,33 @@ INSERT INTO epsg_alias VALUES
 (7210,'Coordinate_Operation',7898,7301,'WGS84 Tritan St. Helena to WGS 84 (1)',''),
 (7211,'Coordinate Reference System',7899,7301,'GDA2020 / Vicgrid2020',''),
 (7212,'Coordinate Reference System',3111,7301,'GDA94 / Vicgrid94',''),
-(7213,'Coordinate Reference System',7908,7301,'IGS97','Used by IGS from 2000-06-04 to 2001-12-01. For most practical purposes IGS97 is equivalent to ITRF97.'),
+(7213,'Coordinate Reference System',7908,1046,'388',''),
 (7214,'Datum',1180,7302,'ETRF91',''),
 (7215,'Datum',1178,7302,'ETRF89',''),
 (7216,'Datum',1178,7301,'EUREF89',''),
 (7217,'Datum',1179,7302,'ETRF90',''),
-(7218,'Coordinate Reference System',7909,7301,'IGS00','Used by IGS from 2001-01-02 to 2004-01-10. For most practical purposes IGS00 is equivalent to ITRF2000.'),
+(7218,'Coordinate Reference System',7909,1046,'355',''),
 (7219,'Datum',1181,7302,'ETRF92',''),
 (722,'Coordinate_Operation',17803,7302,'Japan zone III',''),
 (7220,'Unit of Measure',9111,7301,'sexagesimal degree DDD.MMm',''),
 (7221,'Datum',1182,7302,'ETRF93',''),
 (7222,'Unit of Measure',9121,7301,'sexagesimal degree DDDMMSS.sss',''),
 (7223,'Datum',1183,7302,'ETRF94',''),
-(7224,'Coordinate Reference System',7909,7301,'IGb00','Used by IGS from 2004-01-11 to 2006-11-04. For most practical purposes IGb05 is equivalent to ITRF2000.'),
+(7224,'Coordinate Reference System',7909,1047,'ITRF2000 - LatLonEHt',''),
 (7225,'Datum',1184,7302,'ETRF96',''),
-(7226,'Coordinate Reference System',7910,7301,'IGS05','Used by IGS from 2006-11-05 to 2011-04-16. For most practical purposes IGS05 is equivalent to ITRF2005.'),
+(7226,'Coordinate Reference System',7910,1046,'209',''),
 (7227,'Datum',1185,7302,'ETRF97',''),
-(7228,'Coordinate Reference System',7911,7301,'IGS08','Used by IGS from 2011-04-17 to 2012-10-06. For most practical purposes IGS08 is equivalent to ITRF2008.'),
+(7228,'Coordinate Reference System',7911,1046,'277',''),
 (7229,'Datum',1186,7302,'ETRF2000',''),
 (723,'Coordinate_Operation',17804,7302,'Japan zone IV',''),
-(7230,'Coordinate Reference System',7911,7301,'IGb08','Used by IGS from 2012-10-07. For most practical purposes IGb08 is equivalent to ITRF2008.'),
+(7230,'Coordinate Reference System',7911,1047,'ITRF2008 - LatLonEHt',''),
 (7231,'Coordinate_Operation',17359,7302,'SA Lambert',''),
-(7232,'Coordinate Reference System',5332,7301,'IGS08','Used by IGS from 2011-04-17 to 2012-10-06. For most practical purposes IGS08 is equivalent to ITRF2008.'),
-(7233,'Coordinate Reference System',5332,7301,'IGb08','Used by IGS from 2012-10-07. For most practical purposes IGb08 is equivalent to ITRF2008.'),
-(7234,'Coordinate Reference System',4896,7301,'IGS2005','Used by IGS from 2006-11-05 to 2011-04-16. For most practical purposes IGS05 is equivalent to ITRF2005.'),
-(7235,'Coordinate Reference System',4919,7301,'IGS00','Used by IGS from 2001-01-02 to 2004-01-10. For most practical purposes IGS00 is equivalent to ITRF2000.'),
-(7236,'Coordinate Reference System',4919,7301,'IGb00','Used by IGS from 2004-01-11 to 2006-11-04. For most practical purposes IGb00 is equivalent to ITRF2000.'),
-(7237,'Coordinate Reference System',4918,7301,'IGS97','Used by IGS from 2000-06-04 to 2001-12-01. For most practical purposes IGS97 is equivalent to ITRF97.'),
+(7232,'Coordinate Reference System',5332,1046,'242',''),
+(7233,'Coordinate Reference System',5332,1047,'ITRF2008 - XYZ',''),
+(7234,'Coordinate Reference System',4896,1046,'269',''),
+(7235,'Coordinate Reference System',4919,1046,'419',''),
+(7236,'Coordinate Reference System',4919,1047,'ITRF2000 - XYZ',''),
+(7237,'Coordinate Reference System',4918,1046,'349',''),
 (7238,'Datum',1176,7301,'MSL Tritan',''),
 (7239,'Coordinate Reference System',7887,7301,'SHGD2015 / UTM zone 30S',''),
 (724,'Coordinate_Operation',17805,7302,'Japan zone V',''),
@@ -8921,12 +8916,11 @@ INSERT INTO epsg_alias VALUES
 (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.'),
+(7329,'Coordinate Reference System',7789,1046,'425',''),
 (733,'Coordinate_Operation',17814,7302,'Japan zone XIV',''),
 (7330,'Coordinate Reference System',8095,7302,'WISCRS Wood (m)',''),
 (7331,'Coordinate Reference System',8109,7302,'WISCRS Vilas (m)',''),
@@ -9194,6 +9188,7 @@ INSERT INTO epsg_alias VALUES
 (7568,'Coordinate_Operation',8373,7302,'NCRS Las Vegas (m)',''),
 (7569,'Coordinate Reference System',8357,7307,'SK_KRON / NH',''),
 (757,'Coordinate_Operation',18071,7302,'Blue Belt',''),
+(7570,'Coordinate Reference System',8378,7301,'TVD','In industry there is confusion about the zero level for term TVD whether below the Vertical Reference Surface or the wellbore Zero Depth Point and care should be taken.'),
 (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)',''),
@@ -9276,11 +9271,14 @@ INSERT INTO epsg_alias VALUES
 (7642,'Coordinate Reference System',8526,7301,'NAD83(2011) / KS RCS zone 9 Emporia',''),
 (7643,'Coordinate Reference System',8702,7302,'NAD83 / AZ_W+ NAVD88 ht (ft)',''),
 (7644,'Coordinate Reference System',8527,7301,'NAD83(2011) / KS RCS zone 10 Atchison',''),
+(7645,'Datum',1211,7302,'NAD83(FBN)',''),
 (7646,'Coordinate Reference System',8528,7301,'NAD83(2011) / KS RCS zone 11 Kansas City',''),
 (7647,'Coordinate Reference System',8703,7302,'NAD83 / MI_N + NAVD88 ht (ft)',''),
 (7648,'Coordinate Reference System',8529,7301,'NAD83(2011) / KS RCS zone 12 Ulysses',''),
+(7649,'Coordinate_Operation',8665,1026,'Guam 1963 to Guam Geodetic Network 1993 (2)',''),
 (765,'Coordinate_Operation',18204,7302,'ITM',''),
 (7650,'Coordinate Reference System',8531,7301,'NAD83(2011) / KS RCS zone 13 Garden City',''),
+(7651,'Coordinate_Operation',8665,1026,'Guam 1963 to GGN93',''),
 (7652,'Coordinate Reference System',8533,7301,'NAD83(2011) / KS RCS zone 14 Dodge City',''),
 (7653,'Coordinate Reference System',8704,7302,'NAD83 / MI_C + NAVD88 ht (ft)',''),
 (7654,'Coordinate Reference System',8534,7301,'NAD83(2011) / KS RCS zone 15 Larned',''),
@@ -9291,6 +9289,7 @@ INSERT INTO epsg_alias VALUES
 (7659,'Coordinate Reference System',8707,7302,'NAD83 / ND_N + NAVD88 ht (ft)',''),
 (766,'Coordinate_Operation',18231,7302,'India zone I',''),
 (7660,'Coordinate Reference System',8708,7302,'NAD83 / ND_S + NAVD88 ht (ft)',''),
+(7661,'Coordinate Reference System',8449,7301,'NAD83(2002 PRVI)',''),
 (7662,'Coordinate Reference System',8709,7302,'NAD83 / OR_N + NAVD88 ht (ft)',''),
 (7663,'Coordinate Reference System',8710,7302,'NAD83 / OR_S + NAVD88 ht (ft)',''),
 (7664,'Coordinate Reference System',8711,7302,'NAD83 / SC + NAVD88 ht (ft)',''),
@@ -9318,6 +9317,7 @@ INSERT INTO epsg_alias VALUES
 (7684,'Coordinate Reference System',8731,7302,'NAD83 / ID_C + NAVD88 ht (ftUS)',''),
 (7685,'Coordinate Reference System',8732,7302,'NAD83 / ID_W + NAVD88 ht (ftUS)',''),
 (7686,'Coordinate Reference System',8733,7302,'NAD83 / IL_E + NAVD88 ht (ftUS)',''),
+(7687,'Datum',1212,7302,'NAD83(HARN Corrected)',''),
 (7688,'Coordinate Reference System',8734,7302,'NAD83 / IL_W + NAVD88 ht (ftUS)',''),
 (7689,'Coordinate Reference System',8735,7302,'NAD83 / IN_E + NAVD88 ht (ftUS)',''),
 (769,'Coordinate_Operation',18234,7302,'India zone IVa',''),
@@ -9424,101 +9424,416 @@ INSERT INTO epsg_alias VALUES
 (7780,'Coordinate Reference System',8815,7302,'NAD83 / MO_W + NAVD88 ht (m)',''),
 (7781,'Coordinate Reference System',7406,7301,'NAD27 + NGVD29 height',''),
 (7782,'Datum',1213,7302,'N43',''),
+(7783,'Datum',1214,7302,'STRS00',''),
+(7784,'Coordinate Reference System',6316,1044,'B&H GK zone 7',''),
+(7785,'Coordinate Reference System',8677,7308,'HDKS zone 5','HDKS = Hrvatski Drzavni Koordinatni Sustav'),
 (7786,'Coordinate Reference System',8675,1030,'N43',''),
+(7787,'Coordinate Reference System',8677,7309,'D48 zone 5',''),
+(7788,'Coordinate Reference System',8677,7307,'HR_HDKS / HR_TM','This same identifier used for both of zones 5 and 6.'),
+(7789,'Datum',1214,7301,'SRB_ETRS89',''),
 (779,'Coordinate_Operation',19928,7302,'KTM',''),
+(7790,'Coordinate_Operation',8680,1044,'HR_HDKS to ETRS89',''),
+(7791,'Coordinate Reference System',8678,7308,'HDKS zone 6','HDKS = Hrvatski Drzavni Koordinatni Sustav'),
+(7792,'Coordinate Reference System',8678,7307,'HR_HDKS / HR_TM','This same identifier used for both of zones 5 and 6.'),
+(7793,'Coordinate Reference System',8677,1044,'B&H GK zone 5',''),
+(7794,'Coordinate_Operation',8688,7309,'D48 to WGS 84 (12)',''),
+(7795,'Coordinate Reference System',8686,7307,'SI_D48 / SI_TM',''),
+(7796,'Coordinate Reference System',8686,7309,'D48 / Slovenia Grid',''),
+(7797,'Coordinate_Operation',8689,7309,'D48 to D96 (12)',''),
+(7798,'Coordinate Reference System',8687,7309,'D96/UTM',''),
+(7799,'Coordinate Reference System',5779,7301,'NVN99 height','Name from EuroGeographics used by EPSG prior to 2018-07.'),
 (78,'Unit of Measure',9030,1040,'International nautical mile',''),
+(7800,'Datum',5177,7301,'National Vertical Network 1999','Name from EuroGeographics used by EPSG prior to 2018-07.'),
+(7801,'Coordinate Reference System',8678,1044,'B&H GK zone 6',''),
+(7802,'Datum',1215,7302,'SVS2010',''),
+(7803,'Coordinate Reference System',8544,7301,'NAD83(1997 PRVI)',''),
+(7804,'Coordinate Reference System',8545,7301,'NAD83(1997 PRVI)',''),
+(7805,'Coordinate_Operation',8670,7301,'NAD83(1993 PRVI) to NAD83(1997 PRVI)',''),
+(7806,'Coordinate_Operation',8550,7301,'NAD83(1986) to NAD83(1992)',''),
+(7807,'Coordinate_Operation',8660,7301,'NAD83(1986) to NAD83(1993 HI)',''),
+(7808,'Coordinate_Operation',8669,7301,'NAD83(1986) to NAD83(1993 PRVI)',''),
+(7809,'Coordinate_Operation',8555,7301,'NAD27 to NAD83(1986)',''),
 (781,'Coordinate_Operation',19931,7302,'EOV',''),
+(7810,'Coordinate_Operation',8549,7301,'NAD27 to NAD83(1986)',''),
+(7811,'Coordinate_Operation',8662,7301,'American Samoa 1962 to NAD83(1993 AS)',''),
 (7812,'Coordinate Reference System',4474,7302,'Cadastre 1997 / UTM 38S',''),
+(7813,'Coordinate Reference System',8541,7301,'NAD83(2002 AS)',''),
+(7814,'Coordinate Reference System',8541,7301,'NAD83(2002 GU)',''),
+(7815,'Coordinate Reference System',8542,7301,'NAD83(2002 AS)',''),
+(7816,'Coordinate Reference System',8542,7301,'NAD83(2002 GU)',''),
 (7817,'Datum',1036,7302,'RGM04',''),
+(7818,'Coordinate Reference System',8542,7301,'NAD83(2002 PRVI)',''),
 (7819,'Datum',1038,7302,'RGSPM06',''),
 (782,'Coordinate_Operation',19933,7302,'PEI Stereographic ATS77',''),
+(7820,'Coordinate Reference System',8449,7301,'NAD83(2002 AS)',''),
+(7821,'Coordinate Reference System',8449,7301,'NAD83(2002 GU)',''),
+(7822,'Coordinate Reference System',8541,7301,'NAD83(2002 PRVI)',''),
+(7823,'Coordinate Reference System',8543,7301,'NAD83(1997 PRVI)',''),
+(7824,'Coordinate_Operation',8672,7301,'NAD83(2002 PRVI) to NAD83(NSRS2007)',''),
+(7825,'Coordinate_Operation',8664,7301,'NAD83(2002 AS) to NAD83(PA11)',''),
+(7826,'Coordinate_Operation',8667,7301,'NAD83(2002 GU) to NAD83(MA11)',''),
+(7827,'Coordinate_Operation',8671,7301,'NAD83(1997 PRVI) to NAD83(2002 PRVI)',''),
+(7828,'Coordinate_Operation',8663,7301,'NAD83(1993 AS) to NAD83(2002 AS)',''),
+(7829,'Coordinate_Operation',8666,7301,'NAD83(1993 GU) to NAD83(2002 GU)',''),
 (783,'Coordinate_Operation',19935,7302,'R.S.O. Malaya',''),
+(7830,'Coordinate_Operation',8551,7301,'NAD83(1992 AK) to NAD83(NSRS2007)',''),
+(7831,'Coordinate_Operation',8661,7301,'NAD83(1993 HI) to NAD83(PA11)',''),
+(7832,'Coordinate_Operation',8561,7301,'Old Hawaiian to NAD83(1986)',''),
+(7833,'Coordinate_Operation',8668,7301,'Puerto Rico to NAD83(1986)',''),
+(7834,'Coordinate_Operation',8546,7301,'St. George Island to NAD83(1986)',''),
+(7835,'Coordinate_Operation',8547,7301,'St. Lawrence Island to NAD83(1986)',''),
+(7836,'Coordinate_Operation',8548,7301,'St. Paul Island to NAD83(1986)',''),
+(7837,'Coordinate Reference System',4956,7301,'NAD83(1992 AK)',''),
+(7838,'Coordinate Reference System',4956,7301,'NAD83(1993 HI)',''),
+(7839,'Coordinate Reference System',4956,7301,'NAD83(1993 AS)',''),
 (784,'Coordinate_Operation',19945,7302,'NB Stereographic ATS77',''),
+(7840,'Coordinate Reference System',4956,7301,'NAD83(1993 GU)',''),
+(7841,'Coordinate Reference System',4956,7301,'NAD83(1993 PRVI)',''),
+(7842,'Coordinate Reference System',4957,7301,'NAD83(1992 AK)',''),
+(7843,'Coordinate Reference System',4957,7301,'NAD83(1993 HI)',''),
+(7844,'Coordinate Reference System',4957,7301,'NAD83(1993 AS)',''),
+(7845,'Coordinate Reference System',4957,7301,'NAD83(1993 GU)',''),
+(7846,'Coordinate Reference System',4957,7301,'NAD83(1993 PRVI)',''),
+(7847,'Coordinate Reference System',4152,7301,'NAD83(1992 AK)',''),
+(7848,'Coordinate Reference System',4152,7301,'NAD83(1993 HI)',''),
+(7849,'Coordinate Reference System',4152,7301,'NAD83(1993 AS)',''),
 (785,'Coordinate_Operation',19946,7302,'NB Stereographic NAD83',''),
+(7850,'Coordinate Reference System',4152,7301,'NAD83(1993 GU)',''),
+(7851,'Coordinate Reference System',4152,7301,'NAD83(1993 PRVI)',''),
+(7852,'Coordinate Reference System',8683,7301,'STRS00',''),
+(7853,'Coordinate Reference System',8684,7301,'STRS00',''),
+(7854,'Coordinate Reference System',8685,7301,'STRS00',''),
+(7855,'Coordinate Reference System',8682,7301,'STRS00 / UTM',''),
+(7856,'Datum',1216,7301,'SRB_VRS12',''),
 (786,'Coordinate_Operation',19950,7302,'LV95',''),
+(7860,'Datum',1219,7302,'MVGC',''),
+(7861,'Datum',1218,7301,'MGD-2000',''),
+(7868,'Coordinate_Operation Parameter',8612,7301,'Scale factor for source coordinate reference system first axis',''),
 (787,'Coordinate_Operation',19951,7302,'Nakhl e Taqi',''),
+(7879,'Datum',1218,7302,'MTRF-2000',''),
 (788,'Coordinate_Operation',19956,7302,'RSO Borneo (chSe)',''),
+(7880,'Coordinate Reference System',8677,7301,'MGI 1901 / Gauss–Kruger zone 5',''),
+(7881,'Coordinate_Operation Parameter',8613,7301,'Scale factor for source coordinate reference system second axis',''),
+(7882,'Coordinate Reference System',8678,7301,'MGI 1901 / Gauss–Kruger zone 6',''),
+(7883,'Coordinate Reference System',8679,7301,'MGI 1901 / Gauss–Kruger zone 8',''),
+(7884,'Coordinate Reference System',6316,7301,'MGI 1901 / Gauss–Kruger zone 7',''),
+(7886,'Coordinate_Operation',8835,7301,'MHEFO 55 to RGPF (1)',''),
+(7887,'Coordinate_Operation',8825,7302,'IDTM83',''),
+(7888,'Coordinate_Operation',8863,7301,'NAD83(1993 AS) to NAD83(2002 AS)',''),
+(7889,'Coordinate_Operation',8842,7301,'MHEFO 55 to WGS 84 (2)',''),
 (789,'Coordinate_Operation',19957,7302,'RSO Borneo (ftSe)',''),
+(7892,'Coordinate Reference System',8826,7302,'NAD83 / IDTM',''),
+(7894,'Coordinate Reference System',8860,7301,'NAD83(2002 PRVI)',''),
+(7895,'Coordinate Reference System',8860,7301,'NAD83(2002 AS)',''),
+(7896,'Coordinate Reference System',8860,7301,'NAD83(2002 GU)',''),
+(7897,'Coordinate_Operation',8864,7301,'NAD83(2002 AS) to NAD83(PA11)',''),
+(7899,'Coordinate_Operation',8865,7301,'NAD83(1993 GU) to NAD83(2002 GU)',''),
 (79,'Unit of Measure',9039,7301,'link (Clarke''s ratio)',''),
 (790,'Coordinate_Operation',19958,7302,'RSO Borneo (m)',''),
+(7901,'Coordinate_Operation',8866,7301,'NAD83(2002 GU) to NAD83(MA11)',''),
+(7903,'Coordinate_Operation',8867,7301,'NAD83(1997 PRVI) to NAD83(2002 PRVI)',''),
+(7904,'Coordinate_Operation',8885,7301,'RAF18',''),
+(7905,'Coordinate_Operation',8868,7301,'NAD83(2002 PRVI) to NAD83(NSRS2007)',''),
+(7906,'Coordinate_Operation Parameter',8614,7301,'Rotation angle of source coordinate reference system axes',''),
+(7908,'Coordinate_Operation Parameter',8615,7301,'Rotation angle of source coordinate reference system first axis',''),
+(7909,'Coordinate_Operation Parameter',8616,7301,'Rotation angle of source coordinate reference system second axis',''),
 (791,'Coordinate_Operation',19960,7302,'PEI Stereographic NAD83',''),
+(7910,'Coordinate_Operation Parameter',1061,7302,'M',''),
+(7911,'Coordinate_Operation Parameter',8612,7302,'Mx',''),
+(7912,'Coordinate_Operation Parameter',8613,7302,'My',''),
+(7913,'Coordinate_Operation Method',1077,7301,'Grid North Local',''),
+(7914,'Coordinate_Operation Method',1076,7301,'Lee''s Modified Proposal',''),
+(7915,'Coordinate_Operation Parameter',1059,7302,'psf flag',''),
+(7916,'Datum',1205,7301,'Zero Depth Point (ZDP)',''),
+(7917,'Datum',1222,7301,'Well Reference Point (WRP)',''),
+(7918,'Datum',1203,7301,'Well Reference Point (WRP)',''),
+(7919,'Coordinate_Operation Method',1076,7302,'LMP',''),
 (792,'Coordinate_Operation',19962,7302,'ITM',''),
+(7920,'Coordinate Reference System',8897,7301,'TVD','In industry there is confusion about the zero level for term TVD whether below the Vertical Reference Surface or the wellbore Zero Depth Point and care should be taken.'),
+(7921,'Coordinate_Operation Method',1077,7302,'GNL',''),
+(7922,'Coordinate Reference System',8905,7301,'CR14',''),
+(7923,'Datum',1223,7302,'RGWF96',''),
+(7924,'Datum',1224,7302,'TWVD 2001',''),
+(7925,'Coordinate Reference System',8899,7301,'RGWF96 (lat-lon)',''),
+(7926,'Datum',1225,7301,'CR14',''),
+(7927,'Coordinate Reference System',8900,7301,'RGWF96 (lat-lon)',''),
+(7928,'Coordinate Reference System',8906,7302,'CR14',''),
+(7929,'Coordinate Reference System',8908,7301,'CR14 / CRTM05',''),
 (793,'Coordinate Reference System',20004,7302,'S-95 zone 4',''),
+(7930,'Coordinate Reference System',7912,1046,'226',''),
+(7931,'Coordinate Reference System',8909,7301,'CR14 / UTM 16N',''),
+(7933,'Coordinate Reference System',8910,7301,'CR14 / UTM 17N',''),
+(7934,'Datum',1226,7302,'DACR52',''),
+(7938,'Coordinate Reference System',8912,7301,'CR14 / CRTM05 + DACR52 height',''),
 (794,'Coordinate Reference System',20005,7302,'S-95 zone 5',''),
+(7944,'Coordinate_Operation',8913,7301,'CR05 to CR14 (1)',''),
 (795,'Coordinate Reference System',20006,7302,'S-95 zone 6',''),
 (796,'Coordinate Reference System',20007,7302,'S-95 zone 7',''),
 (7964,'Datum',1039,7317,'NZVD2009',''),
 (797,'Coordinate Reference System',20008,7302,'S-95 zone 8',''),
+(7978,'Area',1148,7301,'Macedonia',''),
+(7979,'Coordinate_Operation',8968,7301,'CR05 to CR14 (1)',''),
 (798,'Coordinate Reference System',20009,7302,'S-95 zone 9',''),
+(7980,'Area',1079,7301,'Czech Republic',''),
+(7981,'Coordinate Reference System',8988,1047,'ITRF88 - LatLon',''),
+(7982,'Coordinate_Operation',8971,7301,'NAD83(1986) to NAD83(2011) (1)',''),
+(7983,'Coordinate Reference System',8988,1046,'337',''),
+(7984,'Coordinate Reference System',7789,1047,'ITRF2014 - XYZ',''),
+(7985,'Coordinate Reference System',7912,1047,'ITRF2014 - LatLonEHt',''),
+(7986,'Coordinate Reference System',4896,1047,'ITRF2005 - XYZ',''),
+(7987,'Coordinate Reference System',7908,1047,'ITRF97 - LatLonEHt',''),
+(7988,'Coordinate Reference System',4918,1047,'ITRF97 - XYZ',''),
+(7989,'Coordinate Reference System',4917,1046,'275',''),
 (799,'Coordinate Reference System',20010,7302,'S-95 zone 10',''),
+(7990,'Coordinate Reference System',4917,1047,'ITRF96 - XYZ',''),
+(7991,'Coordinate Reference System',7907,1046,'233',''),
+(7992,'Coordinate Reference System',7907,1047,'ITRF96 - LatLonEHt',''),
+(7993,'Coordinate Reference System',4916,1046,'352',''),
+(7994,'Coordinate Reference System',4916,1047,'ITRF94 - XYZ',''),
+(7995,'Coordinate Reference System',7906,1046,'264',''),
+(7996,'Coordinate Reference System',7906,1047,'ITRF94 - LatLonEHt',''),
+(7997,'Coordinate Reference System',4915,1046,'263',''),
+(7998,'Coordinate Reference System',4915,1047,'ITRF93 - XYZ',''),
+(7999,'Coordinate Reference System',7905,1046,'227',''),
 (8,'Unit of Measure',9036,7300,'kilometer','Spelling used in US'),
 (80,'Unit of Measure',9040,7301,'yard',''),
 (800,'Coordinate Reference System',20011,7302,'S-95 zone 11',''),
+(8000,'Coordinate Reference System',7905,1047,'ITRF93 - LatLonEHt',''),
+(8001,'Coordinate Reference System',4914,1046,'261',''),
+(8002,'Coordinate Reference System',4914,1047,'ITRF92 - XYZ',''),
+(8003,'Coordinate Reference System',7904,1046,'286',''),
+(8004,'Coordinate Reference System',7904,1047,'ITRF92 - LatLonEHt',''),
+(8005,'Coordinate Reference System',8989,1047,'ITRF89 - LatLon',''),
+(8006,'Coordinate Reference System',8989,1046,'401',''),
+(8007,'Coordinate Reference System',4913,1046,'258',''),
+(8008,'Coordinate Reference System',4913,1047,'ITRF91 - XYZ',''),
+(8009,'Coordinate Reference System',7903,1046,'241',''),
 (801,'Coordinate Reference System',20012,7302,'S-95 zone 12',''),
+(8010,'Coordinate Reference System',7903,1047,'ITRF91 - LatLonEHt',''),
+(8011,'Coordinate Reference System',4912,1046,'301',''),
+(8012,'Coordinate Reference System',4912,1047,'ITRF90 - XYZ',''),
+(8013,'Coordinate Reference System',7902,1046,'282',''),
+(8014,'Coordinate Reference System',7902,1047,'ITRF90 - LatLonEHt',''),
+(8015,'Coordinate Reference System',4911,1046,'387',''),
+(8016,'Coordinate Reference System',4911,1047,'ITRF89 - XYZ',''),
+(8017,'Coordinate Reference System',7901,1046,'361',''),
+(8018,'Coordinate Reference System',7901,1047,'ITRF89 - LatLonEHt',''),
+(8019,'Coordinate Reference System',4910,1046,'439',''),
 (802,'Coordinate Reference System',20013,7302,'S-95 zone 13',''),
+(8020,'Coordinate Reference System',4910,1047,'ITRF88 - XYZ',''),
+(8021,'Coordinate Reference System',7900,1046,'400',''),
+(8022,'Coordinate Reference System',7900,1047,'ITRF88 - LatLonEHt',''),
+(8023,'Coordinate Reference System',8227,1046,'370',''),
+(8024,'Coordinate Reference System',8227,1047,'IGS14 - XYZ',''),
+(8025,'Coordinate Reference System',6934,1046,'417',''),
+(8026,'Coordinate Reference System',6934,1047,'IGS08 - XYZ',''),
+(8027,'Coordinate Reference System',7910,1047,'ITRF2005 - LatLonEHt',''),
+(8028,'Coordinate_Operation',7790,1046,'491',''),
 (8029,'Coordinate Reference System',4458,7301,'Dunedin-Bluff height',''),
 (803,'Coordinate Reference System',20014,7302,'S-95 zone 14',''),
+(8030,'Coordinate_Operation',7790,1047,'ITRF2008 to ITRF2014 [IERS v1]',''),
+(8031,'Coordinate_Operation',8079,1046,'552',''),
+(8032,'Coordinate_Operation',8079,1047,'ITRF2005 to ITRF2014 (IERS v1]',''),
+(8033,'Coordinate_Operation',6389,1046,'670',''),
+(8034,'Coordinate_Operation',6389,1047,'ITRF2005 to ITRF2008 [IERS v1]',''),
+(8035,'Coordinate_Operation',8078,1046,'591',''),
+(8036,'Coordinate_Operation',8078,1047,'ITRF2000 to ITRF2014 (IERS v1]',''),
+(8037,'Coordinate_Operation',6300,1046,'720',''),
+(8038,'Coordinate_Operation',6300,1047,'ITRF2000 to ITRF2008 [IERS v1]',''),
+(8039,'Coordinate_Operation',6302,1046,'690',''),
 (804,'Coordinate Reference System',20015,7302,'S-95 zone 15',''),
+(8040,'Coordinate_Operation',6302,1047,'ITRF2000 to ITRF2005 [IERS v1]',''),
 (8041,'Coordinate_Operation',4460,7301,'ACRESLC',''),
+(8042,'Coordinate_Operation',8077,1046,'578',''),
+(8043,'Coordinate_Operation',8077,1047,'ITRF97 to ITRF2014 (IERS v1]',''),
 (8044,'Coordinate Reference System',4462,7317,'WGS 84 / ACRESLC',''),
+(8045,'Coordinate_Operation',6299,1046,'468',''),
+(8046,'Coordinate_Operation',6299,1047,'ITRF97 to ITRF2008 [IERS v1]',''),
 (8047,'Coordinate_Operation',17362,7302,'GA LCC',''),
+(8048,'Coordinate_Operation',6289,1046,'623',''),
+(8049,'Coordinate_Operation',6289,1047,'ITRF97 to ITRF2000 [IERS v1]',''),
 (805,'Coordinate Reference System',20016,7302,'S-95 zone 16',''),
+(8050,'Coordinate_Operation',8076,1046,'660',''),
+(8051,'Coordinate_Operation',8076,1047,'ITRF96 to ITRF2014 (IERS v1]',''),
+(8052,'Coordinate_Operation',6298,1046,'553',''),
+(8053,'Coordinate_Operation',6298,1047,'ITRF96 to ITRF2008 [IERS v1]',''),
+(8054,'Coordinate_Operation',6288,1046,'715',''),
+(8055,'Coordinate_Operation',6288,1047,'ITRF96 to ITRF2000 [IERS v1]',''),
+(8056,'Coordinate_Operation',8075,1046,'691',''),
+(8057,'Coordinate_Operation',8075,1047,'ITRF94 to ITRF2014 (IERS v1]',''),
+(8058,'Coordinate_Operation',6297,1046,'680',''),
+(8059,'Coordinate_Operation',6297,1047,'ITRF94 to ITRF2008 [IERS v1]',''),
 (806,'Coordinate Reference System',20017,7302,'S-95 zone 17',''),
+(8060,'Coordinate_Operation',6287,1046,'646',''),
+(8061,'Coordinate_Operation',6287,1047,'ITRF94 to ITRF2000 [IERS v1]',''),
+(8062,'Coordinate_Operation',8074,1046,'533',''),
+(8063,'Coordinate_Operation',8074,1047,'ITRF93 to ITRF2014 (IERS v1]',''),
+(8064,'Coordinate_Operation',6296,1046,'544',''),
+(8065,'Coordinate_Operation',6296,1047,'ITRF93 to ITRF2008 [IERS v1]',''),
+(8066,'Coordinate Reference System',9001,1046,'367',''),
+(8067,'Coordinate_Operation',6286,1046,'526',''),
+(8068,'Coordinate_Operation',6286,1047,'ITRF93 to ITRF2000 [IERS v1]',''),
+(8069,'Coordinate_Operation',8073,1046,'593',''),
 (807,'Coordinate Reference System',20018,7302,'S-95 zone 18',''),
+(8070,'Coordinate_Operation',8073,1047,'ITRF92 to ITRF2014 (IERS v1]',''),
+(8071,'Coordinate_Operation',6295,1046,'507',''),
+(8072,'Coordinate_Operation',6295,1047,'ITRF92 to ITRF2008 [IERS v1]',''),
+(8073,'Coordinate_Operation',6285,1046,'548',''),
+(8074,'Coordinate_Operation',6285,1047,'ITRF92 to ITRF2000 [IERS v1]',''),
+(8075,'Coordinate_Operation',8072,1046,'653',''),
+(8076,'Coordinate_Operation',8072,1047,'ITRF91 to ITRF2014 (IERS v1]',''),
+(8077,'Coordinate_Operation',6294,1046,'665',''),
+(8078,'Coordinate_Operation',6294,1047,'ITRF91 to ITRF2008 [IERS v1]',''),
+(8079,'Coordinate_Operation',6284,1046,'494',''),
 (808,'Coordinate Reference System',20019,7302,'S-95 zone 19',''),
+(8080,'Coordinate_Operation',6284,1047,'ITRF91 to ITRF2000 [IERS v1]',''),
 (8081,'Coordinate Reference System',4479,7302,'CGCS2000',''),
+(8082,'Coordinate_Operation',8071,1046,'499',''),
+(8083,'Coordinate_Operation',8071,1047,'ITRF90 to ITRF2014 (IERS v1]',''),
 (8084,'Coordinate Reference System',4480,7302,'CGCS2000',''),
+(8085,'Coordinate_Operation',6293,1046,'627',''),
+(8086,'Coordinate_Operation',6293,1047,'ITRF90 to ITRF2008 [IERS v1]',''),
+(8087,'Coordinate_Operation',6283,1046,'645',''),
+(8088,'Coordinate_Operation',6283,1047,'ITRF90 to ITRF2000 [IERS v1]',''),
+(8089,'Coordinate_Operation',8070,1046,'662',''),
 (809,'Coordinate Reference System',20020,7302,'S-95 zone 20',''),
+(8090,'Coordinate Reference System',9001,1047,'IGS97 - XYZ',''),
+(8091,'Coordinate_Operation',8070,1047,'ITRF89 to ITRF2014 [IERS v1]',''),
+(8092,'Coordinate_Operation',6292,1046,'461',''),
+(8093,'Coordinate_Operation',6292,1047,'ITRF89 to ITRF2008 [IERS v1]',''),
+(8094,'Coordinate_Operation',7814,1046,'607',''),
+(8095,'Coordinate_Operation',7814,1047,'ITRF89 to ITRF2000 [IERS v1]',''),
+(8096,'Coordinate_Operation',8069,1046,'603',''),
+(8097,'Coordinate_Operation',8069,1047,'ITRF88 to ITRF2014 [IERS v1]',''),
+(8098,'Coordinate_Operation',6291,1046,'595',''),
+(8099,'Coordinate_Operation',6291,1047,'ITRF88 to ITRF2008 [IERS v1]',''),
 (81,'Unit of Measure',9041,7301,'foot',''),
 (810,'Coordinate Reference System',20021,7302,'S-95 zone 21',''),
+(8100,'Coordinate_Operation',6281,1046,'550',''),
+(8101,'Coordinate_Operation',6281,1047,'ITRF88 to ITRF2000 [IERS v1]',''),
+(8102,'Coordinate Reference System',8990,1047,'ITRF90 - LatLon',''),
+(8103,'Coordinate Reference System',8990,1046,'254',''),
+(8104,'Coordinate Reference System',8997,1047,'ITRF2000 - LatLon',''),
+(8105,'Coordinate Reference System',8997,1046,'300',''),
+(8106,'Coordinate Reference System',8991,1047,'ITRF91 - LatLon',''),
+(8107,'Coordinate Reference System',8991,1046,'259',''),
+(8108,'Coordinate Reference System',9002,1046,'274',''),
+(8109,'Coordinate Reference System',9002,1047,'IGS97 - LatLonEHt',''),
 (811,'Coordinate Reference System',20022,7302,'S-95 zone 22',''),
+(8110,'Coordinate Reference System',8992,1047,'ITRF92 - LatLon',''),
+(8111,'Coordinate Reference System',8992,1046,'326',''),
+(8112,'Coordinate Reference System',8998,1047,'ITRF2005 - LatLon',''),
+(8113,'Coordinate Reference System',8998,1046,'403',''),
+(8114,'Coordinate Reference System',8993,1047,'ITRF93 - LatLon',''),
 (8115,'Coordinate Reference System',4495,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 17','Part of the China National Coordinate System of 2000.'),
 (8116,'Coordinate Reference System',4495,7302,'CGCS2000 / G-K zone 17',''),
+(8117,'Coordinate Reference System',8993,1046,'450',''),
+(8118,'Coordinate Reference System',9003,1046,'440',''),
+(8119,'Coordinate Reference System',9003,1047,'IGS97 - LatLon',''),
 (812,'Coordinate Reference System',20023,7302,'S-95 zone 23',''),
+(8120,'Coordinate Reference System',8994,1047,'ITRF94 - LatLon',''),
 (8121,'Coordinate Reference System',4492,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 14','Part of the China National Coordinate System of 2000.'),
 (8122,'Coordinate Reference System',4492,7302,'CGCS2000 / G-K zone 14',''),
+(8123,'Coordinate Reference System',8994,1046,'434',''),
 (8124,'Coordinate Reference System',4493,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 15','Part of the China National Coordinate System of 2000.'),
 (8125,'Coordinate Reference System',4493,7302,'CGCS2000 / G-K zone 15',''),
+(8126,'Coordinate Reference System',8999,1047,'ITRF2008 - LatLon',''),
+(8127,'Coordinate Reference System',8999,1046,'392',''),
+(8128,'Coordinate Reference System',8995,1047,'ITRF96 - LatLon',''),
+(8129,'Coordinate Reference System',8995,1046,'389',''),
 (813,'Coordinate Reference System',20024,7302,'S-95 zone 24',''),
+(8130,'Coordinate_Operation',9020,1046,'669',''),
+(8131,'Coordinate_Operation',9020,1047,'ITRF88 to ITRF89 [IERS v1]',''),
 (8132,'Coordinate Reference System',4496,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 18','Part of the China National Coordinate System of 2000.'),
 (8133,'Coordinate Reference System',4496,7302,'CGCS2000 / G-K zone 18',''),
+(8134,'Coordinate Reference System',8996,1047,'ITRF97 - LatLon',''),
+(8135,'Coordinate Reference System',8996,1046,'268',''),
+(8136,'Coordinate Reference System',9000,1047,'ITRF2014 - LatLon',''),
+(8137,'Coordinate Reference System',9000,1046,'333',''),
+(8138,'Coordinate Reference System',9004,1046,'289',''),
+(8139,'Coordinate Reference System',9004,1047,'IGS00 - XYZ',''),
 (814,'Coordinate Reference System',20025,7302,'S-95 zone 25',''),
+(8140,'Coordinate Reference System',9007,1046,'309',''),
+(8141,'Coordinate Reference System',9007,1047,'IGb00 - XYZ',''),
 (8142,'Coordinate Reference System',4498,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 20','Part of the China National Coordinate System of 2000.'),
 (8143,'Coordinate Reference System',4498,7302,'CGCS2000 / G-K zone 20',''),
+(8144,'Coordinate Reference System',9005,1046,'459',''),
+(8145,'Coordinate Reference System',9005,1047,'IGS00 - LatLonEHt',''),
+(8146,'Coordinate Reference System',9015,1046,'382',''),
 (8147,'Coordinate Reference System',4499,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 21','Part of the China National Coordinate System of 2000.'),
 (8148,'Coordinate Reference System',4499,7302,'CGCS2000 / G-K zone 21',''),
+(8149,'Coordinate Reference System',9015,1047,'IGb08 - XYZ',''),
 (815,'Coordinate Reference System',20026,7302,'S-95 zone 26',''),
+(8150,'Coordinate Reference System',9006,1046,'364',''),
+(8151,'Coordinate Reference System',9006,1047,'IGS00 - LatLon',''),
 (8152,'Coordinate Reference System',4500,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 22','Part of the China National Coordinate System of 2000.'),
 (8153,'Coordinate Reference System',4500,7302,'CGCS2000 / G-K zone 22',''),
+(8154,'Coordinate Reference System',9008,1046,'420',''),
+(8155,'Coordinate Reference System',9008,1047,'IGb00 - LatLonEHt',''),
+(8156,'Coordinate_Operation',9024,1046,'540',''),
 (8157,'Coordinate Reference System',4501,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 23','Part of the China National Coordinate System of 2000.'),
 (8158,'Coordinate Reference System',4501,7302,'CGCS2000 / G-K zone 23',''),
+(8159,'Coordinate_Operation',9024,1047,'ITRF92 to ITRF93 [IERS v1]',''),
 (816,'Coordinate Reference System',20027,7302,'S-95 zone 27',''),
+(8160,'Coordinate Reference System',9009,1046,'336',''),
+(8161,'Coordinate Reference System',9009,1047,'IGb00 - LatLon',''),
 (8162,'Coordinate Reference System',4502,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 75E',''),
 (8163,'Coordinate Reference System',4502,7302,'CGCS2000 / G-K CM 75E',''),
+(8164,'Coordinate Reference System',9016,1046,'402',''),
+(8165,'Coordinate Reference System',9016,1047,'IGb08 - LatLonEHt',''),
+(8166,'Coordinate Reference System',9010,1046,'310',''),
 (8167,'Coordinate Reference System',4503,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 81E',''),
 (8168,'Coordinate Reference System',4503,7302,'CGCS2000 / G-K CM 81E',''),
+(8169,'Coordinate Reference System',9010,1047,'IGS05 - XYZ',''),
 (817,'Coordinate Reference System',20028,7302,'S-95 zone 28',''),
+(8170,'Coordinate_Operation',9021,1046,'673',''),
+(8171,'Coordinate_Operation',9021,1047,'ITRF89 to ITRF90 [IERS v1]',''),
 (8172,'Coordinate Reference System',4504,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 87E',''),
 (8173,'Coordinate Reference System',4504,7302,'CGCS2000 / G-K CM 87E',''),
+(8174,'Coordinate Reference System',9011,1046,'453',''),
+(8175,'Coordinate Reference System',9011,1047,'IGS05 - LatLonEHt',''),
+(8176,'Coordinate Reference System',9017,1046,'297',''),
 (8177,'Coordinate Reference System',4505,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 93E',''),
 (8178,'Coordinate Reference System',4505,7302,'CGCS2000 / G-K CM 93E',''),
+(8179,'Coordinate Reference System',9017,1047,'IGb08 - LatLon',''),
 (818,'Coordinate Reference System',20029,7302,'S-95 zone 29',''),
+(8180,'Coordinate Reference System',9012,1046,'441',''),
+(8181,'Coordinate Reference System',9012,1047,'IGS05 - LatLon',''),
 (8182,'Coordinate Reference System',4506,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 99E',''),
 (8183,'Coordinate Reference System',4506,7302,'CGCS2000 / G-K CM 99E',''),
+(8184,'Coordinate_Operation',9022,1046,'719',''),
+(8185,'Coordinate_Operation',9022,1047,'ITRF90 to ITRF91 [IERS v1]',''),
+(8186,'Coordinate Reference System',9013,1046,'205',''),
 (8187,'Coordinate Reference System',4507,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 105E',''),
 (8188,'Coordinate Reference System',4507,7302,'CGCS2000 / G-K CM 105E',''),
+(8189,'Coordinate Reference System',9013,1047,'IGS08 - LatLonEHt',''),
 (819,'Coordinate Reference System',20030,7302,'S-95 zone 30',''),
+(8190,'Coordinate Reference System',9018,1046,'299',''),
+(8191,'Coordinate Reference System',9018,1047,'IGS14 - LatLonEHt',''),
 (8192,'Coordinate Reference System',4508,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 111E',''),
 (8193,'Coordinate Reference System',4508,7302,'CGCS2000 / G-K CM 111E',''),
+(8194,'Coordinate Reference System',9014,1046,'424',''),
+(8195,'Coordinate Reference System',9014,1047,'IGS08 - LatLon',''),
 (8197,'Coordinate Reference System',4509,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 117E',''),
 (8198,'Coordinate Reference System',4509,7302,'CGCS2000 / G-K CM 117E',''),
 (82,'Unit of Measure',9042,7301,'chain',''),
 (820,'Coordinate Reference System',20031,7302,'S-95 zone 31',''),
+(8200,'Coordinate Reference System',9019,1046,'406',''),
+(8201,'Coordinate Reference System',9019,1047,'IGS14 - LatLon',''),
 (8202,'Coordinate Reference System',4510,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 123E',''),
 (8203,'Coordinate Reference System',4510,7302,'CGCS2000 / G-K CM 123E',''),
+(8204,'Coordinate_Operation',9023,1046,'490',''),
+(8205,'Coordinate_Operation',9023,1047,'ITRF91 to ITRF92 [IERS v1]',''),
+(8206,'Coordinate_Operation',9025,1046,'579',''),
+(8207,'Coordinate_Operation',9025,1047,'ITRF93 to ITRF94 [IERS v1]',''),
+(8208,'Coordinate_Operation',9027,1046,'600','IISO registry uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8209,'Coordinate_Operation',9027,1047,'ITRF96 to ITRF97 [IERS v1]',''),
 (821,'Coordinate Reference System',20032,7302,'S-95 zone 32',''),
+(8210,'Coordinate_Operation',9026,1046,'685','ISO registry uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8211,'Coordinate_Operation',9026,1047,'ITRF94 to ITRF96 [IERS v1]',''),
 (8212,'Coordinate Reference System',4512,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 135E',''),
 (8213,'Coordinate Reference System',4512,7302,'CGCS2000 / G-K CM 135E',''),
+(8214,'Coordinate_Operation',9032,1046,'557','ISO registry uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
 (8215,'Coordinate Reference System',4490,7302,'CGCS2000',''),
 (8216,'Coordinate Reference System',3907,7308,'HDKS zone 5','HDKS = Hrvatski Drzavni Koordinatni Sustav'),
 (8217,'Coordinate Reference System',3908,7308,'HDKS zone 6','HDKS = Hrvatski Drzavni Koordinatni Sustav'),
@@ -9539,7 +9854,7 @@ INSERT INTO epsg_alias VALUES
 (8230,'Coordinate_Operation',3898,7302,'NSIDC EASE-grid south projection',''),
 (8231,'Coordinate_Operation',3914,7301,'MGI 1901 to ETRF89 (3)',''),
 (8232,'Datum',6761,7308,'HTRS96',''),
-(8233,'Coordinate Reference System',3912,7309,'D48 / GK',''),
+(8233,'Coordinate Reference System',3912,7309,'D48/GK',''),
 (8234,'Coordinate_Operation',3929,7301,'MGI 1901 / Slovene National Grid to Slovenia 1996 / Slovene National Grid (1)',''),
 (8235,'Coordinate_Operation',3930,7301,'MGI 1901 / Slovene National Grid to Slovenia 1996 / Slovene National Grid (2)',''),
 (8236,'Coordinate_Operation',3931,7301,'MGI 1901 / Slovene National Grid to Slovenia 1996 / Slovene National Grid (3)',''),
@@ -9592,10 +9907,31 @@ INSERT INTO epsg_alias VALUES
 (8279,'Coordinate Reference System',4062,7302,'RGRDC 2005 / UTM 34S',''),
 (828,'Coordinate Reference System',20070,7302,'Pulkovo 1995 / Gauss 10N',''),
 (8280,'Coordinate Reference System',4063,7302,'RGRDC 2005 / UTM 35S',''),
+(8281,'Coordinate_Operation',9032,1047,'ITRF2014 to IGS14 [IGS v1]',''),
+(8282,'Coordinate_Operation',9028,1046,'586','ISO registry uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8283,'Coordinate_Operation',9028,1047,'ITRF97 to IGS97 [IGS v1]',''),
 (8284,'Ellipsoid',7049,7301,'Xian 1980',''),
+(8285,'Coordinate_Operation',9035,1046,'504',''),
+(8286,'Coordinate_Operation',9035,1047,'IGb00 to IGS05 [IGS v1]',''),
+(8287,'Coordinate_Operation',9029,1046,'639','ISO registry uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8288,'Coordinate_Operation',9029,1047,'ITRF2000 to IGS00 [IGS v1]',''),
+(8289,'Coordinate_Operation',9033,1046,'635',''),
 (829,'Coordinate Reference System',20071,7302,'Pulkovo 1995 / Gauss 11N',''),
+(8290,'Coordinate_Operation',9033,1047,'IGS97 to IGS00 [IGS v1]',''),
+(8291,'Coordinate_Operation',9030,1046,'614','ISO registry uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8292,'Coordinate_Operation',9030,1047,'ITRF2005 to IGS05 [IGS v1]',''),
+(8293,'Coordinate_Operation',9036,1046,'692',''),
+(8294,'Coordinate_Operation',9036,1047,'IGS05 to IGS08 [IGS v1]',''),
+(8295,'Coordinate_Operation',9031,1046,'641','ISO registry uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8296,'Coordinate_Operation',9031,1047,'ITRF2008 to IGS08 [IGS v1]',''),
+(8297,'Coordinate_Operation',9034,1046,'475','ISO registry uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8298,'Coordinate_Operation',9034,1047,'IGS00 to IGb00 [IGS v1]',''),
 (83,'Unit of Measure',9043,7301,'link',''),
 (830,'Coordinate Reference System',20072,7302,'Pulkovo 1995 / Gauss 12N',''),
+(8301,'Coordinate_Operation',9037,1046,'602','ISO registry uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8302,'Coordinate_Operation',9037,1047,'IGS08 to IGb08 [IGS v1]',''),
+(8305,'Coordinate_Operation',9038,1046,'611',''),
+(8306,'Coordinate_Operation',9038,1047,'IGb08 to IGS14 [IGS v1]',''),
 (831,'Coordinate Reference System',20073,7302,'Pulkovo 1995 / Gauss 13N',''),
 (832,'Coordinate Reference System',20074,7302,'Pulkovo 1995 / Gauss 14N',''),
 (833,'Coordinate Reference System',20075,7302,'Pulkovo 1995 / Gauss 15N',''),
@@ -10012,7 +10348,7 @@ INSERT INTO epsg_area VALUES
 (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),
-(1065,'Chad','Chad.',7.45,23.46,13.46,24.01,'urn:ogc:def:extent-polygon:EPSG::1065','TD','TCD',148,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2006.540 2012.049 2014.025',false),
+(1065,'Chad','Chad.',7.45,23.46,13.46,24.01,'urn:ogc:def:extent-polygon:EPSG::1065','TD','TCD',148,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2019-01-14','2002.341 2006.540 2012.049 2014.025 2018.064',false),
 (1066,'Chile','Chile - onshore and offshore. Includes Easter Island, Juan Fernandez Islands, San Felix, and Sala y Gomez.',-59.87,-17.5,-113.21,-65.72,'urn:ogc:def:extent-polygon:EPSG::1066','CL','CHL',152,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.037 2014.025',false),
 (1067,'China','China - onshore and offshore.',16.7,53.56,73.62,134.77,'urn:ogc:def:extent-polygon:EPSG::1067','CN','CHN',156,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2017-03-19','2002.341 2005.890 2012.050 2014.025 2017.008',false),
 (1068,'Christmas Island','Christmas Island - onshore and offshore.',-13.92,-8.87,102.14,109.03,'urn:ogc:def:extent-polygon:EPSG::1068','CX','CXR',162,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2016-12-15','2002.341 2005.890 2012.027 2014.025 2016.054',false),
@@ -10026,7 +10362,7 @@ INSERT INTO epsg_area VALUES
 (1076,'Croatia','Croatia - onshore and offshore.',41.62,46.54,13,19.43,'urn:ogc:def:extent-polygon:EPSG::1076','HR','HRV',191,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2007.077 2011.095 2014.025',false),
 (1077,'Cuba','Cuba - onshore and offshore.',18.83,25.51,-87.01,-73.57,'urn:ogc:def:extent-polygon:EPSG::1077','CU','CUB',192,'','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),
 (1078,'Cyprus','Cyprus - onshore and offshore.',32.88,36.21,29.95,35.2,'urn:ogc:def:extent-polygon:EPSG::1078','CY','CYP',196,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.095 2014.025',false),
-(1079,'Czech Republic','Czech Republic.',48.58,51.06,12.09,18.86,'urn:ogc:def:extent-polygon:EPSG::1079','CZ','CZE',203,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2011.095 2014.025',false),
+(1079,'Czechia','Czechia.',48.58,51.06,12.09,18.86,'urn:ogc:def:extent-polygon:EPSG::1079','CZ','CZE',203,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2019-05-17','2002.341 2011.095 2014.025 2019.030',false),
 (1080,'Denmark','Denmark - onshore and offshore.',54.36,58.27,3.24,16.51,'urn:ogc:def:extent-polygon:EPSG::1080','DK','DNK',208,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.095 2014.025',false),
 (1081,'Djibouti','Djibouti - onshore and offshore.',10.94,12.72,41.75,44.15,'urn:ogc:def:extent-polygon:EPSG::1081','DJ','DJI',262,'','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),
 (1082,'Dominica','Dominica - onshore and offshore.',14.48,16.62,-62.82,-57.52,'urn:ogc:def:extent-polygon:EPSG::1082','DM','DMA',212,'','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),
@@ -10090,12 +10426,12 @@ INSERT INTO epsg_area VALUES
 (1140,'Lebanon','Lebanon - onshore and offshore.',33.06,34.84,33.75,36.63,'urn:ogc:def:extent-polygon:EPSG::1140','LB','LBN',422,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.051 2014.025',false),
 (1141,'Lesotho','Lesotho.',-30.66,-28.57,27.01,29.46,'urn:ogc:def:extent-polygon:EPSG::1141','LS','LSO',426,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2012.049 2014.025',false),
 (1142,'Liberia','Liberia - onshore and offshore.',1.02,8.52,-13.59,-7.36,'urn:ogc:def:extent-polygon:EPSG::1142','LR','LBR',430,'','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),
-(1143,'Libya','Libya - onshore and offshore.',19.5,35.23,9.31,26.21,'urn:ogc:def:extent-polygon:EPSG::1143','LY','LBY',434,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2012-04-18','2002.341 2005.890 2012.049',false),
+(1143,'Libya','Libya - onshore and offshore.',19.5,35.23,9.31,26.21,'urn:ogc:def:extent-polygon:EPSG::1143','LY','LBY',434,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2019-01-14','2002.341 2005.890 2012.049 2018.064',false),
 (1144,'Liechtenstein','Liechtenstein.',47.05,47.28,9.47,9.64,'urn:ogc:def:extent-polygon:EPSG::1144','LI','LIE',438,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2011.112 2014.025',false),
 (1145,'Lithuania','Lithuania - onshore and offshore.',53.89,56.45,19.02,26.82,'urn:ogc:def:extent-polygon:EPSG::1145','LT','LTU',440,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.112 2014.025',false),
 (1146,'Luxembourg','Luxembourg.',49.44,50.19,5.73,6.53,'urn:ogc:def:extent-polygon:EPSG::1146','LU','LUX',442,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2011.112 2014.025',false),
 (1147,'China - Macao','China - Macao - onshore and offshore.',22.06,22.23,113.52,113.68,'urn:ogc:def:extent-polygon:EPSG::1147','MO','MAC',446,'"Macao" in ISO 3166.','OGP','OGP','2014-05-01','2002.341 2005.890 2007.072 2012.050 2014.025',false),
-(1148,'Macedonia','The Former Yugoslav Republic of Macedonia.',40.85,42.36,20.45,23.04,'urn:ogc:def:extent-polygon:EPSG::1148','MK','MKD',807,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2008.070 2011.112 2014.025',false),
+(1148,'North Macedonia','North Macedonia.',40.85,42.36,20.45,23.04,'urn:ogc:def:extent-polygon:EPSG::1148','MK','MKD',807,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2019-05-17','2002.341 2008.070 2011.112 2014.025 2019.030',false),
 (1149,'Madagascar - onshore and nearshore','Madagascar - onshore and nearshore.',-26.59,-11.69,42.53,51.03,'urn:ogc:def:extent-polygon:EPSG::1149','','',Null,'','OGP','OGP','2012-04-18','2002.341 2005.890 2012.025 2012.048',false),
 (1150,'Malawi','Malawi.',-17.14,-9.37,32.68,35.93,'urn:ogc:def:extent-polygon:EPSG::1150','MW','MWI',454,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2012.049 2014.025',false),
 (1151,'Malaysia','Malaysia - onshore and offshore. Includes peninsular Malayasia, Sabah and Sarawak.',0.85,7.81,98.02,119.61,'urn:ogc:def:extent-polygon:EPSG::1151','MY','MYS',458,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2006.253 2012.040 2014.025',false),
@@ -10168,10 +10504,10 @@ INSERT INTO epsg_area VALUES
 (1218,'Sri Lanka','Sri Lanka - onshore and offshore.',2.58,11.45,77.02,85.24,'urn:ogc:def:extent-polygon:EPSG::1218','LK','LKA',144,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.040 2014.024',false),
 (1219,'St Helena, Ascension and Tristan da Cunha','St Helena, Ascension and Tristan da Cunha archipelago (Gough, Inaccessible, Nightingale and Stoltenhoff Islands) - onshore and offshore.',-43.71,-4.55,-17.79,-2.16,'urn:ogc:def:extent-polygon:EPSG::1219','SH','SHN',654,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2008.070 2011.015 2012.023 2014.024',false),
 (1220,'St Pierre and Miquelon','St Pierre and Miquelon - onshore and offshore.',43.41,47.37,-57.1,-55.9,'urn:ogc:def:extent-polygon:EPSG::1220','PM','SPM',666,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2008.070 2011.068 2014.024',false),
-(1221,'Sudan','Sudan - onshore and offshore.',8.64,22.24,21.82,39.76,'urn:ogc:def:extent-polygon:EPSG::1221','SD','SDN',729,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.001 2012.049 2014.024',false),
+(1221,'Sudan','Sudan - onshore and offshore.',8.64,22.24,21.82,39.76,'urn:ogc:def:extent-polygon:EPSG::1221','SD','SDN',729,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2019-01-14','2002.341 2005.890 2012.001 2012.049 2014.024 2018.064',false),
 (1222,'Suriname','Suriname - onshore and offshore.',1.83,9.35,-58.08,-52.66,'urn:ogc:def:extent-polygon:EPSG::1222','SR','SUR',740,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.037 2014.024',false),
 (1223,'Svalbard and Jan Mayen','Svalbard and Jan Mayen - onshore and offshore. Includes Bear Island.',66.24,85.05,-16.22,35.02,'','SJ','SJM',744,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2006-02-01','2002.341 2005.890 2011.112',true),
-(1224,'Swaziland','Swaziland',-27.32,-25.72,30.79,32.14,'urn:ogc:def:extent-polygon:EPSG::1224','SZ','SWZ',748,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2012.049 2014.024',false),
+(1224,'Eswatini','Eswatini (Swaziland).',-27.32,-25.72,30.79,32.14,'urn:ogc:def:extent-polygon:EPSG::1224','SZ','SWZ',748,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2019-01-14','2002.341 2012.049 2014.024 2018.060',false),
 (1225,'Sweden','Sweden - onshore and offshore.',54.96,69.07,10.03,24.17,'urn:ogc:def:extent-polygon:EPSG::1225','SE','SWE',752,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.112 2014.024',false),
 (1226,'Switzerland','Switzerland.',45.82,47.81,5.96,10.49,'urn:ogc:def:extent-polygon:EPSG::1226','CH','CHE',756,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2011.113 2014.024',false),
 (1227,'Syria','Syria - onshore and offshore.',32.31,37.3,34.96,42.38,'urn:ogc:def:extent-polygon:EPSG::1227','SY','SYR',760,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.051 2014.024',false),
@@ -10218,7 +10554,7 @@ INSERT INTO epsg_area VALUES
 (1268,'Venezuela - Falcon state','Venezuela - Falcon state.',10.3,12.25,-71.3,-68.19,'urn:ogc:def:extent-polygon:EPSG::1268','','',Null,'','OGP','OGP','2011-05-09','2011.037',false),
 (1269,'Venezuela - Pedregal area of Falcon state','Venezuela - Pedregal area of Falcon state.',10.8,11.26,-70.4,-69.69,'urn:ogc:def:extent-polygon:EPSG::1269','','',Null,'','OGP','OGP','2014-05-01','2014.024',false),
 (1270,'Venezuela - Maracaibo south','Venezuela - south Maracaibo area.',8.72,10.01,-72.4,-70.78,'urn:ogc:def:extent-polygon:EPSG::1270','','',Null,'','OGP','OGP','2014-05-01','2011.037 2014.024',false),
-(1271,'Africa - Eritrea, Ethiopia, South Sudan and Sudan','Eritrea; Ethiopia; South Sudan; Sudan.',3.4,22.24,21.82,47.99,'urn:ogc:def:extent-polygon:EPSG::1271','','',Null,'','OGP','OGP','2014-05-01','2002.810 2012.001 2014.024',false),
+(1271,'Africa - Eritrea, Ethiopia, South Sudan and Sudan','Eritrea; Ethiopia; South Sudan; Sudan.',3.4,22.24,21.82,47.99,'urn:ogc:def:extent-polygon:EPSG::1271','','',Null,'','OGP','IOGP','2019-01-14','2002.810 2012.001 2014.024 2018.064',false),
 (1272,'Asia - Middle East - Bahrain, Kuwait and Saudi Arabia','Bahrain, Kuwait and Saudi Arabia - onshore.',15.61,32.16,34.51,55.67,'urn:ogc:def:extent-polygon:EPSG::1272','','',Null,'','OGP','OGP','2014-05-01','2006.090 2012.051 2014.024',false),
 (1273,'Antigua - onshore','Antigua island - onshore.',16.94,17.22,-61.95,-61.61,'urn:ogc:def:extent-polygon:EPSG::1273','','',Null,'','OGP','OGP','2014-05-01','2011.068 2011.069 2014.024',false),
 (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),
@@ -10231,13 +10567,13 @@ INSERT INTO epsg_area VALUES
 (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),
+(1284,'Europe - FSU, Czechoslovakia - onshore','Armenia; Azerbaijan; Belarus; Czechia; 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','IOGP','2019-05-17','2006.380 2008.054 2010.064 2011.055 2011.082 2012.013 2014.024 2019.030',false),
 (1285,'Indonesia - Java and Bali onshore','Indonesia - onshore Java and Bali.',-8.91,-5.83,105.06,115.77,'urn:ogc:def:extent-polygon:EPSG::1285','','',Null,'','OGP','OGP','2014-05-01','2012.032 2012.057 2014.024',false),
 (1286,'Europe - Liechtenstein and Switzerland','Liechtenstein; Switzerland.',45.82,47.81,5.96,10.49,'urn:ogc:def:extent-polygon:EPSG::1286','','',Null,'','OGP','OGP','2014-05-01','2014.024',false),
 (1287,'Indonesia - Banga & Belitung Islands','Indonesia - Banga and Belitung Islands.',-3.3,-1.44,105.07,108.35,'urn:ogc:def:extent-polygon:EPSG::1287','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.040 2014.024',false),
 (1288,'Angola - Angola proper','Angola - Angola proper - onshore and offshore.',-18.02,-5.82,8.2,24.09,'urn:ogc:def:extent-polygon:EPSG::1288','','',Null,'','OGP','OGP','2014-05-01','2012.042 2014.024',false),
 (1289,'Canada - CGVD28','Canada - onshore - Alberta; British Columbia; Manitoba south of 57°N; New Brunswick; Northwest Territories south west of a line between 60°N, 110°W and the coast at 132°W; Nova Scotia; Ontario south of 52°N; Prince Edward Island; Quebec - mainland west of 66°W and south of 55°N; Saskatchewan south of 55°N; Yukon.',41.67,69.8,-141.01,-59.73,'urn:ogc:def:extent-polygon:EPSG::1289','','',Null,'','OGP','OGP','2014-05-01','2011.051 2011.069 2012.091 2013.064 2014.024',false),
-(1290,'Africa - Botswana, Lesotho, South Africa and Swaziland','Botswana; Lesotho; South Africa - mainland; Swaziland.',-34.88,-17.78,16.45,32.95,'urn:ogc:def:extent-polygon:EPSG::1290','','',Null,'','OGP','OGP','2014-05-01','2011.078 2012.042 2014.024',false),
+(1290,'Africa - Botswana, Eswatini, Lesotho and South Africa','Botswana; Eswatini (Swaziland); Lesotho; South Africa - mainland.',-34.88,-17.78,16.45,32.95,'urn:ogc:def:extent-polygon:EPSG::1290','','',Null,'','OGP','IOGP','2019-01-14','2011.078 2012.042 2014.024 2018.060',false),
 (1291,'Asia - FSU - Caspian Sea','Azerbaijan - offshore; Kazakhstan - offshore; Russian Federation - Caspian Sea; Turkmenistan - offshore.',37.35,46.97,46.95,53.93,'urn:ogc:def:extent-polygon:EPSG::1291','','',Null,'','OGP','OGP','2014-05-01','2011.082 2014.024',false),
 (1292,'Argentina - Neuquen province','Argentina - Neuquen province.',-41.1,-36.14,-71.96,-68.01,'urn:ogc:def:extent-polygon:EPSG::1292','','',Null,'','OGP','OGP','2014-05-01','2011.037 2014.024',false),
 (1293,'Brazil - Corrego Alegre 1970-1972','Brazil - onshore - west of 54°W and south of 18°S; also south of 15°S between 54°W and 42°W; also east of 42°W.',-33.78,-2.68,-58.16,-34.74,'urn:ogc:def:extent-polygon:EPSG::1293','','',Null,'','Ajustamento da Rede Planimetrica do SGB, IBGE.','OGP','2011-07-27','2005.841 2008.045 2010.046 2011.037 2011.053',false),
@@ -10245,15 +10581,15 @@ INSERT INTO epsg_area VALUES
 (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.10,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,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),
+(1298,'Europe - ETRS89','Europe - onshore and offshore: Albania; Andorra; Austria; Belgium; Bosnia and Herzegovina; Bulgaria; Croatia; Cyprus; Czechia; Denmark; Estonia; Faroe Islands; Finland; France; Germany; Gibraltar; Greece; Hungary; Ireland; Italy; Latvia; Liechtenstein; Lithuania; Luxembourg; Malta; Moldova; Monaco; Montenegro; Netherlands; North Macedonia; Norway including Svalbard and Jan Mayen; Poland; Portugal; Romania; San Marino; Serbia; Slovakia; Slovenia; Spain; Sweden; Switzerland; 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','2019-05-17','2005.890 2007.072 2011.004 2011.082 2014.024 2016.058 2019.030',false),
+(1299,'Europe - EVRF2000','Europe - onshore - Andorra; Austria; Belgium; Bosnia and Herzegovina; Croatia; Czechia; Denmark; Estonia; Finland; France - mainland; Germany; Gibraltar; Hungary; Italy - mainland and Sicily; Latvia; Liechtenstein; Lithuania; Luxembourg; Netherlands; Norway; Poland; Portugal - mainland; 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','IOGP','2019-05-17','2005.890 2011.055 2011.082 2012.013 2014.024 2014.095 2019.030',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,-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),
+(1306,'Europe - Czechoslovakia','Czechia; Slovakia.',47.73,51.06,12.09,22.56,'urn:ogc:def:extent-polygon:EPSG::1306','','',Null,'','OGP','IOGP','2019-05-17','2014.024 2019.030',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; 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),
@@ -10268,7 +10604,7 @@ INSERT INTO epsg_area VALUES
 (1318,'Angola - Cabinda','Angola - Cabinda.',-6.04,-4.38,10.53,13.1,'urn:ogc:def:extent-polygon:EPSG::1318','','',Null,'','OGP','OGP','2014-05-01','2012.042 2014.024',false),
 (1319,'Venezuela - Maracaibo area','Venezuela - Maracaibo area, onshore and offshore in lake.',10,11.0,-72.25,-71.5,'urn:ogc:def:extent-polygon:EPSG::1319','','',Null,'','OGP','OGP','2011-05-09','2011.037',false),
 (1320,'Venezuela - Maturin','Venezuela - Maturin area.',9.1,10.13,-64.3,-63,'urn:ogc:def:extent-polygon:EPSG::1320','','',Null,'','OGP','OGP','2000-03-07','',false),
-(1321,'Europe - Austria and former Yugoslavia onshore','Austria. Bosnia and Herzegovina. Croatia - onshore. FYR Macedonia. Montenegro - onshore. Serbia. Slovenia - onshore.',40.85,49.02,9.53,23.04,'urn:ogc:def:extent-polygon:EPSG::1321','','',Null,'','OGP','OGP','2014-05-01','2007.072 2008.045 2008.053 2008.054 2011.055 2011.082 2014.024',false),
+(1321,'Europe - Austria and former Yugoslavia onshore','Austria. Bosnia and Herzegovina. Croatia - onshore. Montenegro - onshore. North Macedonia. Serbia. Slovenia - onshore.',40.85,49.02,9.53,23.04,'urn:ogc:def:extent-polygon:EPSG::1321','','',Null,'','OGP','IOGP','2019-05-17','2007.072 2008.045 2008.053 2008.054 2011.055 2011.082 2014.024 2019.030',false),
 (1322,'Trinidad and Tobago - Tobago - onshore','Trinidad and Tobago - Tobago - onshore.',11.08,11.41,-60.9,-60.44,'urn:ogc:def:extent-polygon:EPSG::1322','','',Null,'','OGP','IOGP','2017-03-19','2009.106 2011.037 2014.024 2017.003',false),
 (1323,'USA - CONUS - onshore','United States (USA) - onshore - Alabama; 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; North Dakota; Ohio; Oklahoma; Oregon; Pennsylvania; Rhode Island; South Carolina; South Dakota; Tennessee; Texas; Utah; Vermont; Virginia; Washington; West Virginia; Wisconsin; Wyoming.',24.41,49.38,-124.79,-66.91,'urn:ogc:def:extent-polygon:EPSG::1323','','',Null,'','OGP','IOGP','2016-12-15','2008.070 2011.043 2011.069 2014.024 2016.056',false),
 (1324,'USA (all states)','United States (USA) - onshore and offshore - 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.',15.56,74.71,167.65,-65.69,'urn:ogc:def:extent-polygon:EPSG::1324','','',Null,'Area crosses 180-degree meridian.','OGP','OGP','2014-05-01','2008.070 2011.043 2014.024',false),
@@ -10284,7 +10620,7 @@ INSERT INTO epsg_area VALUES
 (1334,'USA - Hawaii - onshore','United States (USA) - Hawaii - main islands onshore.',18.87,22.29,-160.3,-154.74,'urn:ogc:def:extent-polygon:EPSG::1334','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.043 2014.024',false),
 (1335,'Caribbean - Puerto Rico and Virgin Islands - onshore','Puerto Rico, US Virgin Islands and British Virgin Islands - onshore.',17.62,18.78,-67.97,-64.25,'urn:ogc:def:extent-polygon:EPSG::1335','','',Null,'This area is an aggregation of discontinuous areas codes 3294, 3329 and 3330.','OGP','OGP','2014-05-01','2009.063 2011.068 2014.024',false),
 (1336,'Canada - CSRS98','Canada - Alberta; New Brunswick; Saskatchewan; Prince Edward Island; and Quebec.',44.61,62.56,-120,-57.1,'','','',Null,'','OGP','OGP','2000-10-19','',true),
-(1337,'USA - HARN','Onshore only: American Samoa - Tutuila, Aunu''u, Ofu, Olesega, Ta''u and Rose islands. Guam. Puerto Rico.  United States (USA) - Alabama; 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.',-14.59,49.38,144.58,-64.51,'urn:ogc:def:extent-polygon:EPSG::1337','','',Null,'Area crosses 180-degree meridian. This area is an aggregation of discontinuous areas codes 3110, 3255, 3294, 3330, 1323 and 1334.','National Geodetic Survey','IOGP','2016-12-15','2001.600 2004.230 2004.750 2005.230 2005.891 2008.070 20
 09.044 2011.043 2014.024 2016.056',false),
+(1337,'USA - HARN','American Samoa - onshore - Tutuila, Aunu''u, Ofu, Olesega, Ta''u and Rose islands. Guam - onshore. Northern Mariana Islands - onshore. Puerto Rico - onshore. United States (USA) - onshore 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 and Wyoming; offshore Gulf of Mexico continental shelf (GoM OCS). US Virgin Islands - onshore.',-14.59,71.4,144.58,-64.51,'urn:ogc:def:extent-polygon:EPSG::1337','','',Null,'Area crosses 180-degree meridian. This area is an aggregation of discontinuous areas codes 3110, 3255, 
 4521, 1334, 1330, 1323, 3357, 3294 and 3330.','National Geodetic Survey','IOGP','2018-08-29','2001.600 2004.230 2004.750 2005.230 2005.891 2008.070 2009.044 2011.043 2014.024 2016.056 2018.017',false),
 (1338,'Iran - Taheri refinery','Iran - Taheri refinery site.',27.39,27.61,52.5,52.71,'urn:ogc:def:extent-polygon:EPSG::1338','','',Null,'','OGP','OGP','2014-05-01','2014.024',false),
 (1339,'Trinidad and Tobago - Trinidad','Trinidad and Tobago - Trinidad - onshore and offshore.',9.83,11.51,-62.09,-60,'urn:ogc:def:extent-polygon:EPSG::1339','','',Null,'','OGP','OGP','2014-05-01','2011.037 2014.024',false),
 (1340,'Yemen - South Yemen - mainland','Yemen - South Yemen onshore mainland.',12.54,19,43.37,53.14,'urn:ogc:def:extent-polygon:EPSG::1340','','',Null,'','OGP','OGP','2014-05-01','2012.022 2012.051 2014.024',false),
@@ -10409,7 +10745,7 @@ INSERT INTO epsg_area VALUES
 (1459,'South Africa - 24°E to 26°E','South Africa - onshore between 24°E and 26°E.',-34.26,-24.71,24,26.01,'urn:ogc:def:extent-polygon:EPSG::1459','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.054 2012.035 2012.049 2014.023',false),
 (1460,'South Africa - 26°E to 28°E','Lesotho - west of 28°E. South Africa - onshore between 26°E and 28°E.',-33.83,-22.92,26,28,'urn:ogc:def:extent-polygon:EPSG::1460','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.054 2012.035 2012.049 2014.023',false),
 (1461,'South Africa - 28°E to 30°E','Lesotho - east of 28°E. South Africa - onshore between 28°E and 30°E.',-33.03,-22.13,27.99,30,'urn:ogc:def:extent-polygon:EPSG::1461','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.035 2012.049 2014.023',false),
-(1462,'South Africa - 30°E to 32°E','South Africa - onshore between 30°E and 32°E. Swaziland.',-31.38,-22.22,29.99,32.02,'urn:ogc:def:extent-polygon:EPSG::1462','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.049 2014.023',false),
+(1462,'South Africa - 30°E to 32°E','South Africa - onshore between 30°E and 32°E. Eswatini (Swaziland).',-31.38,-22.22,29.99,32.02,'urn:ogc:def:extent-polygon:EPSG::1462','','',Null,'','OGP','IOGP','2019-01-14','2008.045 2012.049 2014.023 2018.060',false),
 (1463,'South Africa - east of 32°E','South Africa - east of 32°E.',-28.94,-26.8,31.95,32.95,'urn:ogc:def:extent-polygon:EPSG::1463','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.049 2014.023',false),
 (1464,'Iran - west of 48°E','Iran - west of 48°E.',30.99,39.78,44.03,48,'urn:ogc:def:extent-polygon:EPSG::1464','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.051 2014.023',false),
 (1465,'Iran - 48°E to 54°E','Iran - onshore and offshore between 48°E and 54°E.',25.47,39.71,48,54,'urn:ogc:def:extent-polygon:EPSG::1465','','',Null,'','OGP','OGP','2012-04-18','2008.045 2011.004 2012.051',false),
@@ -10424,11 +10760,11 @@ INSERT INTO epsg_area VALUES
 (1474,'Libya - 16°E to 18°E onshore','Libya - onshore between 16°E and 18°E.',22.51,31.34,16,18.01,'urn:ogc:def:extent-polygon:EPSG::1474','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.049 2014.023',false),
 (1475,'Libya - 18°E to 20°E onshore','Libya - onshore between 18°E and 20°E.',21.54,32.17,18,20,'urn:ogc:def:extent-polygon:EPSG::1475','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.049 2014.023',false),
 (1476,'Libya - 20°E to 22°E onshore','Libya - onshore between 20°E and 22°E.',20.54,33,20,22,'urn:ogc:def:extent-polygon:EPSG::1476','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.049 2014.023',false),
-(1477,'Libya - 22°E to 24°E onshore','Libya - onshore between 22°E and 24°E.',19.5,32.97,22,24,'urn:ogc:def:extent-polygon:EPSG::1477','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.049 2014.023',false),
+(1477,'Libya - 22°E to 24°E onshore','Libya - onshore between 22°E and 24°E.',19.5,32.97,22,24,'urn:ogc:def:extent-polygon:EPSG::1477','','',Null,'','OGP','IOGP','2019-01-14','2008.045 2012.049 2014.023 2018.064',false),
 (1478,'Libya - east of 24°E onshore','Libya - onshore east of 24°E.',19.99,32.15,24,25.21,'urn:ogc:def:extent-polygon:EPSG::1478','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.005 2012.049 2012.062 2014.023',false),
 (1479,'Libya - west of 12°E onshore','Libya - onshore west of 12°E.',23.51,33.23,9.31,12,'urn:ogc:def:extent-polygon:EPSG::1479','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.005 2012.049 2014.023',false),
 (1480,'Libya - 12°E to 18°E onshore','Libya - onshore between 12°E and 18°E.',22.51,33.06,12,18.01,'urn:ogc:def:extent-polygon:EPSG::1480','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.005 2012.049 2014.023',false),
-(1481,'Libya - 18°E to 24°E onshore','Libya - onshore between 18°E and 24°E.',19.5,33,18,24,'urn:ogc:def:extent-polygon:EPSG::1481','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.005 2012.049 2014.023',false),
+(1481,'Libya - 18°E to 24°E onshore','Libya - onshore between 18°E and 24°E.',19.5,33,17.99,24,'urn:ogc:def:extent-polygon:EPSG::1481','','',Null,'','OGP','IOGP','2019-01-14','2008.045 2012.005 2012.049 2014.023 2018.064',false),
 (1482,'Libya - west of 15°E onshore','Libya - onshore west of 15°E.',22.61,33.23,9.31,15,'urn:ogc:def:extent-polygon:EPSG::1482','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.049 2014.023',false),
 (1483,'Argentina - Neuquen province east of 70.5°W','Argentina - Neuquen province east of 70°30''W.',-40.54,-36.14,-70.51,-68.01,'urn:ogc:def:extent-polygon:EPSG::1483','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.004 2011.037 2014.023',false),
 (1484,'Argentina - Comodoro Rivadavia - west of 67.5°W','Argentina - Comodoro Rivadavia area west of 67°30''W.',-46.7,-45.19,-69.5,-67.5,'urn:ogc:def:extent-polygon:EPSG::1484','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.037 2014.023',false),
@@ -10460,8 +10796,8 @@ INSERT INTO epsg_area VALUES
 (1510,'Sierra Leone - east of 12°W','Sierra Leone - onshore east of 12°W.',6.88,10,-12,-10.26,'urn:ogc:def:extent-polygon:EPSG::1510','','',Null,'','OGP','OGP','2012-04-18','2008.045 2012.049',false),
 (1511,'USA - CONUS and Alaska; PRVI','Puerto Rico - onshore and offshore. 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; 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 - onshore and offshore.',14.92,74.71,167.65,-63.88,'urn:ogc:def:extent-polygon:EPSG::1511','','',Null,'Area crosses 180-degree meridian.','OGP','OGP','2014-05-01','2008.070 2009.064 2010.007 2011.043 2014.023',false),
 (1512,'Germany - East Germany - west of 10.5°E','Germany - states of former East Germany - west of 10°30''E - Thuringen.',50.35,51.56,9.92,10.5,'urn:ogc:def:extent-polygon:EPSG::1512','','',Null,'','OGP','OGP','2012-01-05','2008.045 2011.082',false),
-(1513,'Europe - 10.5°E to 13.5°E onshore by country','Czech Republic - west of 13°30''E. Germany - states of former East Germany onshore - between 10°30''E and 13°30''E - Brandenburg; Mecklenburg-Vorpommern; Sachsen; Sachsen-Anhalt; Thuringen.',48.97,54.74,10.5,13.5,'urn:ogc:def:extent-polygon:EPSG::1513','','',Null,'','OGP','OGP','2014-05-01','2008.011 2008.045 2011.055 2011.082 2014.023',false),
-(1514,'Europe - 13.5°E to 16.5°E onshore and S-42(83) by country','Czech Republic - between 13°30''E and 16°30''E. Germany - states of former East Germany onshore east of 13°30''E - Brandenburg; Mecklenburg-Vorpommern; Sachsen. Hungary - west of 16°30''E.',46.54,54.72,13.5,16.5,'urn:ogc:def:extent-polygon:EPSG::1514','','',Null,'','OGP','OGP','2014-05-01','2008.011 2008.045 2011.055 2011.082 2014.023',false),
+(1513,'Europe - 10.5°E to 13.5°E onshore by country','Czechia - west of 13°30''E. Germany - states of former East Germany onshore - between 10°30''E and 13°30''E - Brandenburg; Mecklenburg-Vorpommern; Sachsen; Sachsen-Anhalt; Thuringen.',48.97,54.74,10.5,13.5,'urn:ogc:def:extent-polygon:EPSG::1513','','',Null,'','OGP','IOGP','2019-05-17','2008.011 2008.045 2011.055 2011.082 2014.023 2019.030',false),
+(1514,'Europe - 13.5°E to 16.5°E onshore and S-42(83) by country','Czechia - between 13°30''E and 16°30''E. Germany - states of former East Germany onshore east of 13°30''E - Brandenburg; Mecklenburg-Vorpommern; Sachsen. Hungary - west of 16°30''E.',46.54,54.72,13.5,16.5,'urn:ogc:def:extent-polygon:EPSG::1514','','',Null,'','OGP','IOGP','2019-05-17','2008.011 2008.045 2011.055 2011.082 2014.023 2019.030',false),
 (1515,'Poland - zone I','Poland - southeast - south of 52°20''N and east of 18°E.',49,52.34,18,24.15,'urn:ogc:def:extent-polygon:EPSG::1515','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.112 2014.023',false),
 (1516,'Poland - zone II','Poland - northeast - onshore north of 51°20''N and east of 19°E.',51.33,54.51,19,23.95,'urn:ogc:def:extent-polygon:EPSG::1516','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.112 2014.023',false),
 (1517,'Poland - zone III','Poland - northwest - onshore north of 52°10''N and west of 20°E.',52.16,54.89,14.14,20,'urn:ogc:def:extent-polygon:EPSG::1517','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.112 2014.023',false),
@@ -10516,7 +10852,7 @@ INSERT INTO epsg_area VALUES
 (1566,'Australia - EEZ east of 162°E','Australia - offshore east of 162°E to 200 nautical mile EEZ boundary.',-34.22,-27.25,162,163.2,'urn:ogc:def:extent-polygon:EPSG::1566','','',Null,'','OGP','OGP','2014-02-15','2008.045 2012.027 2014.005',false),
 (1567,'Australasia - Australia and PNG - 138°E to 144°E','Australia - onshore and offshore between 138°E and 144°E. Papua New Guinea - onshore west of 144°E.',-46.63,-2.53,138,144.01,'urn:ogc:def:extent-polygon:EPSG::1567','','',Null,'','OGP','IOGP','2016-12-15','2008.045 2012.027 2012.060 2014.023 2016.054',false),
 (1568,'Australasia - Australia and PNG - 144°E to 150°E','Australia - onshore and offshore between 144°E and 150°E. Papua New Guinea (PNG) - onshore between 144°E and 150°E.',-47.2,-1.3,144,150.01,'urn:ogc:def:extent-polygon:EPSG::1568','','',Null,'','OGP','IOGP','2016-12-15','2008.045 2012.027 2014.023 2016.054',false),
-(1569,'Saudi Arabia - 36°E to 42°E','Saudi Arabia - onshore between 36°E and 42°E.',16.59,32.16,36,42,'urn:ogc:def:extent-polygon:EPSG::1569','','',Null,'','OGP','OGP','2014-05-01','2005.110 2008.045 2012.051 2014.023',false),
+(1569,'Saudi Arabia - onshore 36°E to 42°E','Saudi Arabia - onshore between 36°E and 42°E.',16.59,32.16,36,42,'urn:ogc:def:extent-polygon:EPSG::1569','','',Null,'','OGP','IOGP','2018-08-29','2005.110 2008.045 2012.051 2014.023 2018.045',false),
 (1570,'Asia - Middle East - Kuwait and Saudi - 48°E to 54°E','Kuwait - onshore east of 48°E. Saudi Arabia - onshore between 48°E and 54°E.',17.43,30.04,48,54.01,'urn:ogc:def:extent-polygon:EPSG::1570','','',Null,'','OGP','OGP','2014-05-01','2005.110 2008.045 2012.051 2014.023',false),
 (1571,'Asia - Middle East - Kuwait and Saudi - 42°E to 48°E','Kuwait - west of 48°E. Saudi Arabia - between of 42°E and 48°E.',15.61,31.15,42,48,'urn:ogc:def:extent-polygon:EPSG::1571','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.051 2014.023',false),
 (1572,'Brazil - 54°W to 48°W and Aratu','Brazil - offshore between 54°W and 48°W, including Pelotas basin.',-35.71,-25.01,-53.38,-47.99,'urn:ogc:def:extent-polygon:EPSG::1572','','',Null,'','OGP','OGP','2014-05-01','2008.045 2010.097 2011.037 2011.053 2014.023',false),
@@ -10656,10 +10992,10 @@ INSERT INTO epsg_area VALUES
 (1706,'Austria - west of 11°50''E','Austria west of 11°50''E of Greenwich (29°30''E of Ferro).',46.77,47.61,9.53,11.84,'urn:ogc:def:extent-polygon:EPSG::1706','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.095 2014.022',false),
 (1707,'Austria - 11°50''E to 14°50''E','Austria between 11°50''E and 14°50''E of Greenwich (29°30''E and 32°30''E of Ferro).',46.4,48.79,11.83,14.84,'urn:ogc:def:extent-polygon:EPSG::1707','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.095 2014.022',false),
 (1708,'Austria - east of 14°50''E','Austria east of 14°50''E of Greenwich (32°30''E of Ferro).',46.56,49.02,14.83,17.17,'urn:ogc:def:extent-polygon:EPSG::1708','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.095 2014.022',false),
-(1709,'Europe - former Yugoslavia onshore west of 16.5°E','Bosnia and Herzegovina west of 16°30''E; Croatia - onshore west of 16°30''E; Slovenia - onshore.',42.95,46.88,13.38,16.5,'urn:ogc:def:extent-polygon:EPSG::1709','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.053 2008.054 2011.055 2011.112 2014.022',false),
-(1710,'Europe - former Yugoslavia onshore 16.5°E to 19.5°E','Bosnia and Herzegovina east of 16°30''E; Croatia - onshore east of 16°30''E; Montenegro - onshore west of 19°30''E and Serbia - west of 19°30''E.',41.79,46.55,16.5,19.51,'urn:ogc:def:extent-polygon:EPSG::1710','','',Null,'','OGP','OGP','2014-05-01','2007.072 2008.045 2008.053 2008.054 2011.055 2011.112 2014.022',false),

[... 2664 lines stripped ...]


Mime
View raw message