sis-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From desruisse...@apache.org
Subject svn commit: r1866042 [2/2] - /sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql
Date Wed, 28 Aug 2019 17:19:14 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=1866042&r1=1866041&r2=1866042&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 Aug 28 17:19:14 2019
@@ -6813,6 +6813,7 @@ 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,'Coordinate Reference System',4974,1046,'278',''),
 (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',''),
@@ -8916,6 +8917,7 @@ 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,'Coordinate Reference System',4974,1047,'SIRGAS95 - XYZ',''),
 (7325,'Datum',1190,7302,'ISH2004',''),
 (7326,'Datum',1190,7301,'Landshæðarkerfi Islands 2004',''),
 (7327,'Coordinate Reference System',8091,7302,'WISCRS Florence (ftUS)',''),
@@ -9564,13 +9566,52 @@ INSERT INTO epsg_alias VALUES
 (7931,'Coordinate Reference System',8909,7301,'CR14 / UTM 16N',''),
 (7933,'Coordinate Reference System',8910,7301,'CR14 / UTM 17N',''),
 (7934,'Datum',1226,7302,'DACR52',''),
+(7935,'Datum',1230,7302,'SIRGAS-CON DGF02P01',''),
+(7936,'Datum',1227,7302,'SIRGAS-CON DGF00P01',''),
+(7937,'Datum',1227,7301,'SIRGAS Multi-Year Solution 2000',''),
 (7938,'Coordinate Reference System',8912,7301,'CR14 / CRTM05 + DACR52 height',''),
+(7939,'Datum',1230,7301,'SIRGAS Multi-Year Solution 2002',''),
 (794,'Coordinate Reference System',20005,7302,'S-95 zone 5',''),
+(7940,'Datum',1239,7302,'SIRGAS-CON SIR13P01',''),
+(7941,'Datum',1239,7301,'SIRGAS Multi-Year Solution 2013',''),
+(7942,'Datum',1228,7302,'SIRGAS-CON DGF01P01',''),
+(7943,'Datum',1228,7301,'SIRGAS Multi-Year Solution 2001',''),
 (7944,'Coordinate_Operation',8913,7301,'CR05 to CR14 (1)',''),
+(7945,'Datum',1231,7302,'SIRGAS-CON DGF04P01',''),
+(7946,'Datum',1231,7301,'SIRGAS Multi-Year Solution 2004',''),
+(7947,'Datum',1229,7302,'SIRGAS-CON DGF01P02',''),
+(7948,'Datum',1229,7301,'SIRGAS Multi-Year Solution 2001 extended',''),
+(7949,'Coordinate_Operation',8956,1046,'536','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
 (795,'Coordinate Reference System',20006,7302,'S-95 zone 6',''),
+(7951,'Datum',1232,7302,'SIRGAS-CON DGF05P01',''),
+(7952,'Datum',1232,7301,'SIRGAS Multi-Year Solution 2005',''),
+(7953,'Datum',1240,7302,'SIRGAS-CON SIR14P01',''),
+(7954,'Datum',1240,7301,'SIRGAS Multi-Year Solution 2014',''),
+(7955,'Datum',1233,7302,'SIRGAS-CON DGF06P01',''),
+(7956,'Datum',1233,7301,'SIRGAS Multi-Year Solution 2006',''),
+(7957,'Coordinate_Operation',8956,1047,'ITRF2000 to SIRGAS-CON DGF04P01 [SIRv1]',''),
+(7958,'Coordinate_Operation',8955,1046,'634','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(7959,'Datum',1234,7302,'SIRGAS-CON DGF07P01',''),
 (796,'Coordinate Reference System',20007,7302,'S-95 zone 7',''),
+(7960,'Datum',1234,7301,'SIRGAS Multi-Year Solution 2007',''),
+(7961,'Datum',1241,7302,'SIRGAS-CON SIR15P01',''),
+(7962,'Datum',1241,7301,'SIRGAS Multi-Year Solution 2015',''),
+(7963,'Datum',1235,7302,'SIRGAS-CON DGF08P01',''),
 (7964,'Datum',1039,7317,'NZVD2009',''),
+(7965,'Datum',1235,7301,'SIRGAS Multi-Year Solution 2008',''),
+(7966,'Coordinate_Operation',8954,1046,'652','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(7967,'Coordinate_Operation',8953,1046,'496','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(7968,'Datum',1236,7302,'SIRGAS-CON SIR09P01',''),
+(7969,'Datum',1236,7301,'SIRGAS Multi-Year Solution 2009',''),
 (797,'Coordinate Reference System',20008,7302,'S-95 zone 8',''),
+(7970,'Datum',1242,7302,'SIRGAS-CON SIR17P01',''),
+(7971,'Datum',1242,7301,'SIRGAS Multi-Year Solution 2017',''),
+(7972,'Datum',1237,7302,'SIRGAS-CON SIR10P01',''),
+(7973,'Datum',1237,7301,'SIRGAS Multi-Year Solution 2010',''),
+(7974,'Coordinate_Operation',8953,1047,'ITRF2000 to SIRGAS-CON DGF01P01 [SIRv1]',''),
+(7975,'Coordinate_Operation',8952,1046,'613','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(7976,'Datum',1238,7302,'SIRGAS-CON SIR11P01',''),
+(7977,'Datum',1238,7301,'SIRGAS Multi-Year Solution 2011',''),
 (7978,'Area',1148,7301,'Macedonia',''),
 (7979,'Coordinate_Operation',8968,7301,'CR05 to CR14 (1)',''),
 (798,'Coordinate Reference System',20009,7302,'S-95 zone 9',''),
@@ -9814,8 +9855,10 @@ INSERT INTO epsg_alias VALUES
 (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',''),
+(8196,'Coordinate Reference System',3035,7301,'ETRS89 / LAEA Europe',''),
 (8197,'Coordinate Reference System',4509,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 117E',''),
 (8198,'Coordinate Reference System',4509,7302,'CGCS2000 / G-K CM 117E',''),
+(8199,'Coordinate Reference System',3034,7301,'ETRS89 / LCC Europe',''),
 (82,'Unit of Measure',9042,7301,'chain',''),
 (820,'Coordinate Reference System',20031,7302,'S-95 zone 31',''),
 (8200,'Coordinate Reference System',9019,1046,'406',''),
@@ -9926,51 +9969,196 @@ INSERT INTO epsg_alias VALUES
 (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]',''),
+(8299,'Coordinate Reference System',4975,1046,'306',''),
 (83,'Unit of Measure',9043,7301,'link',''),
 (830,'Coordinate Reference System',20072,7302,'Pulkovo 1995 / Gauss 12N',''),
+(8300,'Coordinate_Operation',9041,7301,'ISN2004 / LAEA EU to ETRS89 / LAEA EU (1)',''),
 (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]',''),
+(8303,'Coordinate_Operation',9042,7301,'ISN2004 / LCC EU to ETRS89 / LCC EU (1)',''),
+(8304,'Coordinate_Operation',9043,7301,'ISN2016 / LAEA EU to ETRS89 / LAEA EU (1)',''),
 (8305,'Coordinate_Operation',9038,1046,'611',''),
 (8306,'Coordinate_Operation',9038,1047,'IGb08 to IGS14 [IGS v1]',''),
+(8307,'Coordinate Reference System',4975,1047,'SIRGAS95 - LatLonEHt',''),
+(8308,'Coordinate_Operation',9044,7301,'ISN2016 / LCC EU to ETRS89 / LCC EU (1)',''),
+(8309,'Coordinate Reference System',4170,1046,'318',''),
 (831,'Coordinate Reference System',20073,7302,'Pulkovo 1995 / Gauss 13N',''),
+(8310,'Coordinate_Operation',9048,7301,'REGCAN95 / LCC EU to ETRS89 / LCC EU (1)',''),
+(8311,'Coordinate Reference System',4170,1047,'SIRGAS95 - LatLon',''),
+(8312,'Coordinate_Operation',9045,7301,'PTRA08 / LAEA EU to ETRS89 / LAEA EU (1)',''),
+(8313,'Coordinate_Operation',9049,7301,'TUREF / LAEA EU to ETRS89 / LAEA EU (1)',''),
+(8314,'Coordinate Reference System',4988,1046,'384',''),
+(8315,'Coordinate_Operation',9046,7301,'PTRA08 / LCC EU to ETRS89 / LCC EU (1)',''),
+(8316,'Coordinate_Operation',9050,7301,'TUREF / LCC EU to ETRS89 / LCC EU (1)',''),
+(8317,'Coordinate Reference System',4988,1046,'SIRGAS2000 - XYZ',''),
+(8318,'Coordinate Reference System',4989,1046,'313',''),
+(8319,'Coordinate_Operation',9047,7301,'REGCAN95 / LAEA EU to ETRS89 / LAEA EU (1)',''),
 (832,'Coordinate Reference System',20074,7302,'Pulkovo 1995 / Gauss 14N',''),
+(8320,'Coordinate Reference System',4989,1047,'SIRGAS2000 - LatLonEHt',''),
+(8321,'Coordinate Reference System',4674,1046,'398',''),
+(8322,'Coordinate Reference System',4674,1047,'SIRGAS2000 - LatLon',''),
+(8323,'Coordinate_Operation',8967,1046,'630','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8324,'Coordinate_Operation',8952,1047,'ITRF97 to SIRGAS-CON DGF00P01 [SIRv1]',''),
+(8325,'Coordinate_Operation',8967,1046,'IGS14 to SIRGAS-CON SIR17P01 [SIRv1]',''),
+(8326,'Coordinate_Operation',8966,1046,'549','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8327,'Coordinate_Operation',8966,1047,'IGb08 to SIRGAS-CON SIR15P01 [SIRv1]',''),
+(8328,'Coordinate_Operation',8965,1046,'706','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8329,'Coordinate_Operation',8965,1047,'IGb08 to SIRGAS-CON SIR14P01 [SIRv1]',''),
 (833,'Coordinate Reference System',20075,7302,'Pulkovo 1995 / Gauss 15N',''),
+(8330,'Coordinate_Operation',8964,1046,'684','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8331,'Coordinate_Operation',8964,1047,'IGb08 to SIRGAS-CON SIR13P01 [SIRv1]',''),
+(8332,'Coordinate_Operation',8963,1046,'513','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8333,'Coordinate_Operation',8963,1047,'ITRF2008 to SIRGAS-CON SIR11P01 [SIRv1]',''),
+(8334,'Coordinate_Operation',8962,1046,'723','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8335,'Coordinate_Operation',8962,1047,'ITRF2008 to SIRGAS-CON SIR10P01 [SIRv1]',''),
+(8336,'Coordinate_Operation',8954,1047,'ITRF2000 to SIRGAS-CON DGF01P02 [SIRv1]',''),
+(8337,'Coordinate_Operation',8961,1046,'512','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8338,'Coordinate_Operation',8961,1047,'IGS05 to SIRGAS-CON SIR09P01 [SIRv1]',''),
+(8339,'Coordinate_Operation',8960,1046,'626','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
 (834,'Coordinate Reference System',20076,7302,'Pulkovo 1995 / Gauss 16N',''),
+(8340,'Coordinate_Operation',8960,1047,'IGS05 to SIRGAS-CON DGF08P01 [SIRv1]',''),
+(8341,'Coordinate_Operation',8959,1046,'694','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8342,'Coordinate_Operation',8959,1047,'IGS05 to SIRGAS-CON DGF07P01 [SIRv1]',''),
+(8343,'Coordinate_Operation',8958,1046,'688','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8344,'Coordinate_Operation',8955,1047,'ITRF2000 to SIRGAS-CON DGF02P01 [SIRv1]',''),
+(8345,'Coordinate_Operation',8958,1047,'ITRF2000 to SIRGAS-CON DGF06P01 [SIRv1]',''),
+(8346,'Coordinate_Operation',8957,1046,'707','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8347,'Coordinate_Operation',8957,1047,'ITRF2000 to SIRGAS-CON DGF05P01 [SIRv1]',''),
+(8348,'Coordinate Reference System',8972,1046,'322',''),
+(8349,'Coordinate Reference System',8972,1047,'SIRGAS-CON DGF00P01 - LatLon',''),
 (835,'Coordinate Reference System',20077,7302,'Pulkovo 1995 / Gauss 17N',''),
+(8350,'Coordinate_Operation',9051,1046,'525','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8351,'Coordinate_Operation',9051,1047,'ITRF94 to SIRGAS95 [SIRv1]',''),
+(8352,'Coordinate Reference System',8916,1046,'454',''),
+(8353,'Coordinate Reference System',8916,1047,'SIRGAS-CON DGF00P01 - LatLonEHt',''),
+(8354,'Coordinate_Operation',9052,1046,'485','ISO register uses time-dependent method. As rates are zero this is equivalent to the method used here.'),
+(8355,'Coordinate_Operation',9052,1047,'ITRF2000 to SIRGAS2000 [SIRv1]',''),
+(8356,'Coordinate Reference System',8915,1046,'376',''),
+(8357,'Coordinate Reference System',8915,1047,'SIRGAS-CON DGF00P01 - XYZ',''),
+(8358,'Coordinate Reference System',8973,1046,'422',''),
+(8359,'Coordinate Reference System',8973,1047,'SIRGAS-CON DGF01P01 - LatLon',''),
 (836,'Coordinate Reference System',20078,7302,'Pulkovo 1995 / Gauss 18N',''),
+(8360,'Coordinate Reference System',8918,1046,'363',''),
+(8361,'Coordinate Reference System',8918,1047,'SIRGAS-CON DGF01P01 - LatLonEHt',''),
+(8362,'Coordinate Reference System',8917,1046,'411',''),
+(8363,'Coordinate Reference System',8917,1047,'SIRGAS-CON DGF01P01 - XYZ',''),
+(8364,'Coordinate Reference System',8974,1046,'321',''),
+(8365,'Coordinate Reference System',8974,1047,'SIRGAS-CON DGF01P02 - LatLon',''),
+(8366,'Coordinate Reference System',8920,1046,'348',''),
+(8367,'Coordinate Reference System',8920,1047,'SIRGAS-CON DGF01P02 - LatLonEHt',''),
+(8368,'Coordinate Reference System',8919,1046,'332',''),
+(8369,'Coordinate Reference System',8919,1047,'SIRGAS-CON DGF01P02 - XYZ',''),
 (837,'Coordinate Reference System',20079,7302,'Pulkovo 1995 / Gauss 19N',''),
+(8370,'Coordinate Reference System',8975,1046,'418',''),
+(8371,'Coordinate Reference System',8975,1047,'SIRGAS-CON DGF02P01 - LatLon',''),
+(8372,'Coordinate Reference System',8922,1046,'346',''),
+(8373,'Coordinate Reference System',8922,1047,'SIRGAS-CON DGF02P01 - LatLonEHt',''),
+(8374,'Coordinate Reference System',8921,1046,'283',''),
+(8375,'Coordinate Reference System',8921,1047,'SIRGAS-CON DGF02P01 - XYZ',''),
+(8376,'Coordinate Reference System',8976,1046,'366',''),
+(8377,'Coordinate Reference System',8976,1047,'SIRGAS-CON DGF04P01 - LatLon',''),
+(8378,'Coordinate Reference System',8924,1046,'212',''),
+(8379,'Coordinate Reference System',8924,1047,'SIRGAS-CON DGF04P01 - LatLonEHt',''),
 (838,'Coordinate Reference System',20080,7302,'Pulkovo 1995 / Gauss 20N',''),
+(8380,'Coordinate Reference System',8923,1046,'345',''),
+(8381,'Coordinate Reference System',8923,1047,'SIRGAS-CON DGF04P01 - XYZ',''),
+(8382,'Coordinate Reference System',8977,1046,'290',''),
+(8383,'Coordinate Reference System',8977,1047,'SIRGAS-CON DGF05P01 - LatLon',''),
+(8384,'Coordinate Reference System',8926,1046,'220',''),
+(8385,'Coordinate Reference System',8926,1046,'SIRGAS-CON DGF05P01 - LatLonEHt',''),
+(8386,'Coordinate Reference System',8925,1046,'373',''),
 (8387,'Coordinate Reference System',4541,7302,'CGCS2000 / 3GK CM 96E',''),
+(8388,'Coordinate Reference System',8925,1047,'SIRGAS-CON DGF05P01 - XYZ',''),
 (8389,'Coordinate Reference System',4534,7302,'CGCS2000 / 3GK CM 75E',''),
 (839,'Coordinate Reference System',20081,7302,'Pulkovo 1995 / Gauss 21N',''),
+(8390,'Coordinate Reference System',8978,1046,'223',''),
 (8391,'Coordinate Reference System',4535,7302,'CGCS2000 / 3GK CM 78E',''),
+(8392,'Coordinate Reference System',8978,1047,'SIRGAS-CON DGF06P01 - LatLon',''),
 (8393,'Coordinate Reference System',4536,7302,'CGCS2000 / 3GK CM 81E',''),
+(8394,'Coordinate Reference System',8928,1046,'250',''),
 (8395,'Coordinate Reference System',4537,7302,'CGCS2000 / 3GK CM 84E',''),
+(8396,'Coordinate Reference System',8928,1047,'SIRGAS-CON DGF06P01 - LatLonEHt',''),
+(8397,'Coordinate Reference System',8927,1046,'359',''),
+(8398,'Coordinate Reference System',8927,1047,'SIRGAS-CON DGF06P01 - XYZ',''),
 (8399,'Coordinate Reference System',4538,7302,'CGCS2000 / 3GK CM 87E',''),
 (84,'Unit of Measure',9050,7301,'yard',''),
 (840,'Coordinate Reference System',20082,7302,'Pulkovo 1995 / Gauss 22N',''),
+(8400,'Coordinate Reference System',8979,1046,'296',''),
 (8401,'Coordinate Reference System',4539,7302,'CGCS2000 / 3GK CM 90E',''),
+(8402,'Coordinate Reference System',8979,1047,'SIRGAS-CON DGF07P01 - LatLon',''),
 (8403,'Coordinate Reference System',4540,7302,'CGCS2000 / 3GK CM 93E',''),
+(8404,'Coordinate Reference System',8930,1046,'271',''),
+(8405,'Coordinate Reference System',8930,1047,'SIRGAS-CON DGF07P01 - LatLonEHt',''),
 (8406,'Coordinate Reference System',4542,7302,'CGCS2000 / 3GK CM 99E',''),
+(8407,'Coordinate Reference System',8929,1046,'324',''),
+(8408,'Coordinate Reference System',8929,1047,'SIRGAS-CON DGF07P01 - XYZ',''),
 (8409,'Coordinate Reference System',4543,7302,'CGCS2000 / 3GK CM 102E',''),
 (841,'Coordinate Reference System',20083,7302,'Pulkovo 1995 / Gauss 23N',''),
+(8410,'Coordinate Reference System',8980,1046,'276',''),
+(8411,'Coordinate Reference System',8980,1047,'SIRGAS-CON DGF08P01 - LatLon',''),
 (8412,'Coordinate Reference System',4544,7302,'CGCS2000 / 3GK CM 105E',''),
+(8413,'Coordinate Reference System',8932,1046,'232',''),
+(8414,'Coordinate Reference System',8932,1047,'SIRGAS-CON DGF08P01 - LatLonEHt',''),
 (8415,'Coordinate Reference System',4545,7302,'CGCS2000 / 3GK CM 108E',''),
+(8416,'Coordinate Reference System',8931,1046,'442',''),
+(8417,'Coordinate Reference System',8931,1047,'SIRGAS-CON DGF08P01 - XYZ',''),
 (8418,'Coordinate Reference System',4546,7302,'CGCS2000 / 3GK CM 111E',''),
+(8419,'Coordinate Reference System',8981,1046,'395',''),
 (842,'Coordinate Reference System',20084,7302,'Pulkovo 1995 / Gauss 24N',''),
+(8420,'Coordinate Reference System',8981,1047,'SIRGAS-CON SIR09P01 - LatLon',''),
 (8421,'Coordinate Reference System',4547,7302,'CGCS2000 / 3GK CM 114E',''),
+(8422,'Coordinate Reference System',8934,1046,'451',''),
+(8423,'Coordinate Reference System',8934,1047,'SIRGAS-CON SIR09P01 - LatLonEHt',''),
 (8424,'Coordinate Reference System',4548,7302,'CGCS2000 / 3GK CM 117E',''),
+(8425,'Coordinate Reference System',8933,1046,'319',''),
+(8426,'Coordinate Reference System',8933,1047,'SIRGAS-CON SIR09P01 - XYZ',''),
 (8427,'Coordinate Reference System',4549,7302,'CGCS2000 / 3GK CM 120E',''),
+(8428,'Coordinate Reference System',8982,1046,'456',''),
+(8429,'Coordinate Reference System',8982,1047,'SIRGAS-CON SIR10P01 - LatLon',''),
 (843,'Coordinate Reference System',20085,7302,'Pulkovo 1995 / Gauss 25N',''),
 (8430,'Coordinate Reference System',4550,7302,'CGCS2000 / 3GK CM 123E',''),
+(8431,'Coordinate Reference System',8936,1046,'211',''),
+(8432,'Coordinate Reference System',8936,1047,'SIRGAS-CON SIR10P01 - LatLonEHt',''),
 (8433,'Coordinate Reference System',4551,7302,'CGCS2000 / 3GK CM 126E',''),
+(8434,'Coordinate Reference System',8935,1046,'427',''),
+(8435,'Coordinate Reference System',8935,1047,'SIRGAS-CON SIR10P01 - XYZ',''),
 (8436,'Coordinate Reference System',4552,7302,'CGCS2000 / 3GK CM 129E',''),
+(8437,'Coordinate Reference System',8983,1046,'307',''),
+(8438,'Coordinate Reference System',8983,1047,'SIRGAS-CON SIR11P01 - LatLon',''),
 (8439,'Coordinate Reference System',4553,7302,'CGCS2000 / 3GK CM 132E',''),
 (844,'Coordinate Reference System',20086,7302,'Pulkovo 1995 / Gauss 26N',''),
+(8440,'Coordinate Reference System',8938,1046,'303',''),
+(8441,'Coordinate Reference System',8938,1047,'SIRGAS-CON SIR11P01 - LatLonEHt',''),
 (8442,'Coordinate Reference System',4554,7302,'CGCS2000 / 3GK CM 135E',''),
+(8443,'Coordinate Reference System',8937,1046,'218',''),
+(8444,'Coordinate Reference System',8937,1047,'SIRGAS-CON SIR11P01 - XYZ',''),
+(8445,'Coordinate Reference System',8984,1046,'240',''),
+(8446,'Coordinate Reference System',8984,1047,'SIRGAS-CON SIR13P01 - LatLon',''),
+(8447,'Coordinate Reference System',8940,1046,'399',''),
+(8448,'Coordinate Reference System',8940,1047,'SIRGAS-CON SIR13P01 - LatLonEHt',''),
+(8449,'Coordinate Reference System',8939,1046,'413',''),
 (845,'Coordinate Reference System',20087,7302,'Pulkovo 1995 / Gauss 27N',''),
+(8450,'Coordinate Reference System',8939,1047,'SIRGAS-CON SIR13P01 - XYZ',''),
+(8451,'Coordinate Reference System',8985,1046,'380',''),
+(8452,'Coordinate Reference System',8985,1047,'SIRGAS-CON SIR14P01 - LatLon',''),
+(8453,'Coordinate Reference System',8942,1046,'203',''),
+(8454,'Coordinate Reference System',8942,1047,'SIRGAS-CON SIR14P01 - LatLonEHt',''),
+(8455,'Coordinate Reference System',8941,1046,'257',''),
+(8456,'Coordinate Reference System',8941,1047,'SIRGAS-CON SIR14P01 - XYZ',''),
+(8457,'Coordinate Reference System',8986,1046,'249',''),
+(8458,'Coordinate Reference System',8986,1047,'SIRGAS-CON SIR15P01 - LatLon',''),
+(8459,'Coordinate Reference System',8944,1046,'235',''),
 (846,'Coordinate Reference System',20088,7302,'Pulkovo 1995 / Gauss 28N',''),
+(8460,'Coordinate Reference System',8944,1047,'SIRGAS-CON SIR15P01 - LatLonEHt',''),
+(8461,'Coordinate Reference System',8943,1046,'446',''),
+(8462,'Coordinate Reference System',8943,1047,'SIRGAS-CON SIR15P01 - XYZ',''),
 (8463,'Datum',1047,7302,'RRAF91',''),
+(8464,'Coordinate Reference System',8987,1046,'396',''),
+(8465,'Coordinate Reference System',8987,1047,'SIRGAS-CON SIR17P01 - LatLon',''),
+(8466,'Coordinate Reference System',8946,1046,'312',''),
+(8467,'Coordinate Reference System',8946,1047,'SIRGAS-CON SIR17P01 - LatLonEHt',''),
+(8468,'Coordinate Reference System',8945,1046,'273',''),
+(8469,'Coordinate Reference System',8945,1047,'SIRGAS-CON SIR17P01 - XYZ',''),
 (847,'Coordinate Reference System',20089,7302,'Pulkovo 1995 / Gauss 29N',''),
 (848,'Coordinate Reference System',20090,7302,'Pulkovo 1995 / Gauss 30N',''),
 (8480,'Coordinate_Operation',4561,7301,'RRAF 1991 to IGN 1987 (1)',''),
@@ -9981,39 +10169,82 @@ INSERT INTO epsg_alias VALUES
 (851,'Coordinate Reference System',20437,7302,'Ain el Abd / UTM 37N',''),
 (852,'Coordinate Reference System',20438,7302,'Ain el Abd / UTM 38N',''),
 (853,'Coordinate Reference System',20439,7302,'Ain el Abd / UTM 39N',''),
+(8534,'Coordinate Reference System',7663,1046,'216',''),
+(8535,'Coordinate Reference System',8888,7301,'WGS 84 (Original)',''),
+(8536,'Coordinate Reference System',9053,1046,'374',''),
+(8537,'Coordinate Reference System',9053,1047,'WGS 84 (G730) - LatLon',''),
 (854,'Coordinate Reference System',20790,7302,'Lisbon / Portuguese Nat',''),
+(8540,'Coordinate Reference System',8888,1046,'426',''),
+(8541,'Coordinate Reference System',8888,1047,'WGS 84 TRANSIT - LatLon',''),
+(8542,'Coordinate Reference System',9054,1046,'208',''),
+(8543,'Coordinate Reference System',9054,1047,'WGS 84 (G873) - LatLon',''),
+(8544,'Coordinate Reference System',9055,1046,'228',''),
+(8545,'Coordinate Reference System',9055,1047,'WGS 84 (G1150) - LatLon',''),
+(8546,'Coordinate Reference System',9056,1046,'237',''),
+(8547,'Coordinate Reference System',9056,1047,'WGS 84 (G1674) - LatLon',''),
+(8548,'Coordinate Reference System',9057,1046,'265',''),
 (8549,'Coordinate Reference System',4568,7301,'New Beijing / 6-degree Gauss-Kruger zone 13',''),
 (855,'Coordinate Reference System',21100,7302,'Batavia / NEIEZ',''),
+(8550,'Coordinate Reference System',9057,1047,'WGS 84 (G1762) - LatLon',''),
 (8551,'Coordinate Reference System',4568,7302,'New Beijing / G-K zone 13',''),
+(8552,'Coordinate Reference System',7663,1047,'WGS 84 (G1674) - LatLonEHt',''),
 (8553,'Coordinate Reference System',4569,7301,'New Beijing / 6-degree Gauss-Kruger zone 14',''),
+(8554,'Coordinate Reference System',7662,1046,'334',''),
 (8555,'Coordinate Reference System',4569,7302,'New Beijing / G-K zone 14',''),
+(8556,'Coordinate Reference System',7662,1047,'WGS 84 (G1674) - XYZ',''),
+(8557,'Coordinate Reference System',7816,1046,'342',''),
 (8558,'Coordinate Reference System',4570,7301,'New Beijing / 6-degree Gauss-Kruger zone 15',''),
 (8559,'Coordinate Reference System',4570,7302,'New Beijing / G-K zone 15',''),
 (856,'Coordinate Reference System',21291,7302,'Barbados 1938 / BWI Grid',''),
+(8560,'Coordinate Reference System',7816,1047,'WGS 84 TRANSIT - LatLonEHt',''),
+(8561,'Coordinate Reference System',7815,1046,'272',''),
+(8562,'Coordinate Reference System',7815,1047,'WGS 84 TRANSIT - XYZ',''),
+(8563,'Coordinate Reference System',7657,1046,'458',''),
+(8564,'Coordinate Reference System',7657,1047,'WGS 84 (G730) - LatLonEHt',''),
 (8565,'Coordinate Reference System',4571,7302,'New Beijing / G-K zone 16',''),
 (8566,'Coordinate Reference System',4571,7301,'New Beijing / 6-degree Gauss-Kruger zone 16',''),
+(8567,'Coordinate Reference System',7656,1046,'314',''),
 (8568,'Coordinate Reference System',4572,7301,'New Beijing / 6-degree Gauss-Kruger zone 17',''),
+(8569,'Coordinate Reference System',7656,1047,'WGS 84 (G730) - XYZ',''),
 (857,'Coordinate Reference System',21292,7302,'Barbados National Grid',''),
 (8570,'Coordinate Reference System',4572,7302,'New Beijing / G-K zone 17',''),
+(8571,'Coordinate Reference System',7659,1046,'344',''),
+(8572,'Coordinate Reference System',7659,1047,'WGS 84 (G873) - LatLonEHt',''),
 (8573,'Coordinate Reference System',4573,7301,'New Beijing / 6-degree Gauss-Kruger zone 18',''),
 (8574,'Coordinate Reference System',4573,7302,'New Beijing / G-K zone 18',''),
+(8575,'Coordinate Reference System',7658,1046,'325',''),
+(8576,'Coordinate Reference System',7658,1047,'WGS 84 (G873) - XYZ',''),
 (8577,'Coordinate Reference System',4574,7302,'New Beijing / G-K zone 19',''),
 (8578,'Coordinate Reference System',4574,7301,'New Beijing / 6-degree Gauss-Kruger zone 19',''),
+(8579,'Coordinate Reference System',7661,1046,'414',''),
 (858,'Coordinate Reference System',21413,7302,'Beijing / GK zone 13',''),
+(8580,'Coordinate Reference System',7661,1047,'WGS 84 (G1150) - LatLonEHt',''),
 (8581,'Coordinate Reference System',4575,7302,'New Beijing / G-K zone 20',''),
 (8582,'Coordinate Reference System',4575,7301,'New Beijing / 6-degree Gauss-Kruger zone 20',''),
+(8583,'Coordinate Reference System',7660,1046,'210',''),
 (8584,'Coordinate Reference System',4576,7301,'New Beijing / 6-degree Gauss-Kruger zone 21',''),
+(8585,'Coordinate Reference System',7660,1047,'WGS 84 (G1150) - XYZ',''),
 (8586,'Coordinate Reference System',4576,7302,'New Beijing / G-K zone 21',''),
+(8587,'Coordinate Reference System',7665,1046,'405',''),
 (8588,'Coordinate Reference System',4577,7301,'New Beijing / 6-degree Gauss-Kruger zone 22',''),
+(8589,'Coordinate Reference System',7665,1047,'WGS 84 (G1762) - LatLonEHt',''),
 (859,'Coordinate Reference System',21414,7302,'Beijing / GK zone 14',''),
 (8590,'Coordinate Reference System',4577,7302,'New Beijing / G-K zone 22',''),
+(8591,'Coordinate Reference System',7664,1046,'215',''),
+(8592,'Coordinate Reference System',7664,1047,'WGS 84 (G1762) - XYZ',''),
 (8593,'Coordinate Reference System',4578,7302,'New Beijing / G-K zone 23',''),
 (8594,'Coordinate Reference System',4578,7301,'New Beijing / 6-degree Gauss-Kruger zone 23',''),
+(8595,'Coordinate Reference System',3855,1046,'436',''),
 (8596,'Coordinate Reference System',2333,7302,'Xian 1980 / G-K zone 19',''),
+(8597,'Coordinate Reference System',3855,1047,'WGS 84 EGM2008 - OHt',''),
 (8598,'Coordinate Reference System',4497,7302,'CGCS2000 / G-K zone 19',''),
 (8599,'Coordinate Reference System',4497,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 19','Part of the China National Coordinate System of 2000.'),
 (86,'Unit of Measure',9052,7301,'chain',''),
 (860,'Coordinate Reference System',21415,7302,'Beijing / GK zone 15',''),
+(8600,'Coordinate Reference System',5798,1046,'383',''),
+(8601,'Coordinate Reference System',5798,1047,'WGS 84 EGM84 - OHt',''),
+(8602,'Coordinate Reference System',5773,1046,'444',''),
+(8603,'Coordinate Reference System',5773,1047,'WGS 84 EGM96 - OHt',''),
 (8605,'Coordinate Reference System',4579,7301,'New Beijing / 6-degree Gauss-Kruger CM 75E',''),
 (8606,'Coordinate Reference System',4579,7302,'New Beijing / G-K CM 75E',''),
 (861,'Coordinate Reference System',21416,7302,'Beijing / GK zone 16',''),
@@ -10042,19 +10273,113 @@ INSERT INTO epsg_alias VALUES
 (8655,'Coordinate Reference System',4589,7301,'New Beijing / 6-degree Gauss-Kruger CM 135E',''),
 (8656,'Coordinate Reference System',4589,7302,'New Beijing / G-K CM 135E',''),
 (866,'Coordinate Reference System',21421,7302,'Beijing / GK zone 21',''),
+(8664,'Datum',1251,7301,'KOSOVAREF12',''),
 (867,'Coordinate Reference System',21422,7302,'Beijing / GK zone 22',''),
 (868,'Coordinate Reference System',21423,7302,'Beijing / GK zone 23',''),
+(8683,'Coordinate Reference System',5621,1046,'409',''),
+(8684,'Coordinate Reference System',5621,1047,'EVRF2007 - NHt',''),
+(8685,'Coordinate Reference System',5730,1046,'238',''),
+(8686,'Coordinate Reference System',5730,1047,'EVRF2000 - NHt',''),
+(8687,'Coordinate Reference System',5621,7307,'EVRF2007_AMST / NH',''),
+(8688,'Coordinate Reference System',7928,1046,'433',''),
+(8689,'Coordinate Reference System',7928,1047,'ETRF97 - XYZ',''),
 (869,'Coordinate Reference System',21473,7302,'Beijing / Gauss 13N',''),
+(8690,'Coordinate Reference System',7929,1046,'330',''),
+(8691,'Coordinate Reference System',7929,1047,'ETRF97 - LatLonEHt',''),
+(8692,'Coordinate Reference System',7926,1046,'356',''),
+(8693,'Coordinate Reference System',7926,1047,'ETRF96 - XYZ',''),
+(8694,'Coordinate Reference System',7927,1046,'421',''),
+(8695,'Coordinate Reference System',7927,1047,'ETRF96 - LatLonEHt',''),
+(8696,'Coordinate Reference System',7924,1046,'206',''),
+(8697,'Coordinate Reference System',7924,1047,'ETRF94 - XYZ',''),
+(8698,'Coordinate Reference System',7925,1046,'407',''),
+(8699,'Coordinate Reference System',7925,1047,'ETRF94 - LatLonEHt',''),
 (87,'Unit of Measure',9053,7301,'link',''),
 (870,'Coordinate Reference System',21474,7302,'Beijing / Gauss 14N',''),
+(8700,'Coordinate Reference System',7922,1046,'244',''),
+(8701,'Coordinate Reference System',7922,1047,'ETRF93 - XYZ',''),
+(8702,'Coordinate Reference System',7923,1046,'358',''),
+(8703,'Coordinate Reference System',7923,1047,'ETRF93 - LatLonEHt',''),
+(8704,'Coordinate Reference System',7920,1046,'221',''),
+(8705,'Coordinate Reference System',7920,1047,'ETRF92 - XYZ',''),
+(8706,'Coordinate Reference System',7921,1046,'369',''),
+(8707,'Coordinate Reference System',7921,1047,'ETRF92 - LatLonEHt',''),
+(8708,'Coordinate Reference System',7918,1046,'213',''),
+(8709,'Coordinate Reference System',7918,1047,'ETRF91 - XYZ',''),
 (871,'Coordinate Reference System',21475,7302,'Beijing / Gauss 15N',''),
+(8710,'Coordinate Reference System',7919,1046,'371',''),
+(8711,'Coordinate Reference System',7919,1047,'ETRF91 - LatLonEHt',''),
+(8712,'Coordinate Reference System',7916,1046,'435',''),
+(8713,'Coordinate Reference System',7916,1047,'ETRF90 - XYZ',''),
+(8714,'Coordinate Reference System',7917,1046,'353',''),
+(8715,'Coordinate Reference System',7917,1047,'ETRF90 - LatLonEHt',''),
+(8716,'Coordinate Reference System',7914,1046,'308',''),
+(8717,'Coordinate Reference System',7914,1047,'ETRF89 - XYZ',''),
+(8718,'Coordinate Reference System',7915,1046,'217',''),
+(8719,'Coordinate Reference System',7915,1047,'ETRF89 - LatLonEHt',''),
 (872,'Coordinate Reference System',21476,7302,'Beijing / Gauss 16N',''),
+(8720,'Coordinate Reference System',8397,1046,'378',''),
+(8721,'Coordinate Reference System',8397,1047,'ETRF2005 - XYZ',''),
+(8722,'Coordinate Reference System',8399,1046,'317',''),
+(8723,'Coordinate Reference System',8399,1047,'ETRF2005 - LatLonEHt',''),
+(8724,'Coordinate Reference System',7930,1046,'260',''),
+(8725,'Coordinate Reference System',7930,1047,'ETRF2000 - XYZ',''),
+(8726,'Coordinate Reference System',7931,1046,'457',''),
+(8727,'Coordinate Reference System',7931,1047,'ETRF2000 - LatLonEHt',''),
+(8728,'Coordinate Reference System',4612,1046,'394',''),
+(8729,'Coordinate Reference System',4612,1047,'JGD2000 - LatLon',''),
 (873,'Coordinate Reference System',21477,7302,'Beijing / Gauss 17N',''),
+(8730,'Coordinate Reference System',9059,1046,'247',''),
+(8731,'Coordinate Reference System',9059,1047,'ETRF89 - LatLon',''),
+(8732,'Coordinate Reference System',9061,1046,'343',''),
+(8733,'Coordinate Reference System',9061,1047,'ETRF91 - LatLon',''),
+(8734,'Coordinate Reference System',9060,1046,'224',''),
+(8735,'Coordinate Reference System',9060,1047,'ETRF90 - LatLon',''),
+(8736,'Coordinate Reference System',9062,1046,'410',''),
+(8737,'Coordinate Reference System',9062,1047,'ETRF92 - LatLon',''),
+(8738,'Coordinate Reference System',9068,1046,'279',''),
+(8739,'Coordinate Reference System',9068,1047,'ETRF2005 - LatLon',''),
 (874,'Coordinate Reference System',21478,7302,'Beijing / Gauss 18N',''),
+(8740,'Coordinate Reference System',9063,1046,'430',''),
+(8741,'Coordinate Reference System',9063,1047,'ETRF93 - LatLon',''),
+(8742,'Coordinate Reference System',9064,1047,'ETRF94 - LatLon',''),
+(8743,'Coordinate Reference System',9064,1046,'255',''),
+(8744,'Coordinate Reference System',4947,1046,'281',''),
+(8745,'Coordinate Reference System',4947,1047,'JGD2000 - LatLonEHt',''),
+(8746,'Coordinate Reference System',9065,1046,'266',''),
+(8747,'Coordinate Reference System',9065,1047,'ETRF96 - LatLon',''),
+(8748,'Coordinate Reference System',4946,1046,'251',''),
+(8749,'Coordinate Reference System',4946,1047,'JGD2000 - XYZ',''),
 (875,'Coordinate Reference System',21479,7302,'Beijing / Gauss 19N',''),
+(8750,'Coordinate Reference System',9066,1046,'267',''),
+(8751,'Coordinate Reference System',9066,1047,'ETRF97 - LatLon',''),
+(8752,'Coordinate Reference System',6694,1046,'390',''),
+(8753,'Coordinate Reference System',6694,1047,'JGD2000 (vertical) - OHt',''),
+(8754,'Coordinate Reference System',9067,1046,'234',''),
+(8755,'Coordinate Reference System',9067,1047,'ETRF2000 - LatLon',''),
+(8756,'Coordinate Reference System',6695,1046,'428',''),
+(8757,'Coordinate Reference System',6695,1047,'JGD2011 (vertical) - OHt',''),
+(8758,'Coordinate Reference System',6666,1046,'229',''),
 (8759,'Coordinate_Operation Method',9603,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 1032 and 10xx.'),
 (876,'Coordinate Reference System',21480,7302,'Beijing / Gauss 20N',''),
+(8760,'Coordinate Reference System',6666,1047,'JGD2011 - XYZ',''),
+(8761,'Coordinate Reference System',6667,1046,'365',''),
+(8762,'Coordinate Reference System',6667,1047,'JGD2011 - LatLonEHt',''),
+(8763,'Coordinate Reference System',6668,1046,'416',''),
+(8764,'Coordinate Reference System',6668,1047,'JGD2011 - LatLon',''),
+(8765,'Coordinate Reference System',4272,1046,'443',''),
+(8766,'Coordinate Reference System',4272,1047,'NZGD1949 - LatLon',''),
+(8767,'Coordinate Reference System',4167,1046,'293',''),
+(8768,'Coordinate Reference System',4167,1047,'NZGD2000 - LatLon',''),
+(8769,'Coordinate Reference System',4959,1046,'287',''),
 (877,'Coordinate Reference System',21481,7302,'Beijing / Gauss 21N',''),
+(8770,'Coordinate Reference System',4959,1047,'NZGD2000 - LatLonEHt',''),
+(8771,'Coordinate Reference System',4958,1046,'222',''),
+(8772,'Coordinate Reference System',4958,1047,'NZGD2000 - XYZ',''),
+(8773,'Coordinate Reference System',4440,1046,'438',''),
+(8774,'Coordinate Reference System',4440,1047,'NZVD2009 - NOHt',''),
+(8775,'Coordinate Reference System',7839,1046,'328',''),
+(8776,'Coordinate Reference System',7839,1047,'NZVD2016 - NOHt',''),
 (878,'Coordinate Reference System',21482,7302,'Beijing / Gauss 22N',''),
 (879,'Coordinate Reference System',21483,7302,'Beijing / Gauss 23N',''),
 (88,'Unit of Measure',9060,7301,'yard',''),
@@ -10063,25 +10388,90 @@ INSERT INTO epsg_alias VALUES
 (882,'Coordinate Reference System',21781,7302,'LV03',''),
 (883,'Coordinate Reference System',21891,7302,'Bogota / Colombia 3W',''),
 (884,'Coordinate Reference System',21892,7302,'Bogota / Colombia Bogota',''),
+(8847,'Coordinate_Operation',7949,1046,'655',''),
 (885,'Coordinate Reference System',21893,7302,'Bogota / Colombia 3E',''),
+(8850,'Coordinate_Operation',7949,1047,'ITRF97 to ETRF2000 [EUREF v1]',''),
+(8851,'Coordinate_Operation',7939,1046,'679',''),
+(8856,'Coordinate_Operation',7939,1047,'ITRF97 to ETRF97 [EUREF v1]',''),
+(8857,'Coordinate_Operation',7948,1046,'631',''),
 (886,'Coordinate Reference System',21894,7302,'Bogota / Colombia 6E',''),
+(8860,'Coordinate_Operation',7948,1047,'ITRF96 to ETRF2000 [EUREF v1]',''),
+(8861,'Coordinate_Operation',7938,1046,'537',''),
+(8864,'Coordinate_Operation',7938,1047,'ITRF96 to ETRF96 [EUREF v1]',''),
+(8865,'Coordinate_Operation',7947,1046,'697',''),
 (887,'Coordinate Reference System',22191,7302,'C Inchauspe / Argentina 1',''),
+(8870,'Coordinate_Operation',7947,1047,'ITRF94 to ETRF2000 [EUREF v1]',''),
+(8871,'Coordinate_Operation',7937,1046,'676',''),
+(8872,'Coordinate_Operation',7937,1047,'ITRF94 to ETRF94 [EUREF v1]',''),
+(8873,'Coordinate_Operation',7946,1046,'703',''),
 (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.'),
+(8875,'Coordinate_Operation',7946,1047,'ITRF93 to ETRF2000 [EUREF v1]',''),
+(8876,'Coordinate_Operation',7936,1046,'555',''),
+(8877,'Coordinate_Operation',7936,1047,'ITRF93 to ETRF93 [EUREF v1]',''),
+(8878,'Coordinate_Operation',7945,1046,'612',''),
+(8879,'Coordinate_Operation',7945,1047,'ITRF92 to ETRF2000 [EUREF v1]',''),
 (888,'Coordinate Reference System',22192,7302,'C Inchauspe / Argentina 2',''),
+(8880,'Coordinate_Operation',7935,1046,'693',''),
+(8881,'Coordinate_Operation',7935,1047,'ITRF92 to ETRF92 [EUREF v1]',''),
+(8882,'Coordinate_Operation',7944,1046,'478',''),
+(8883,'Coordinate_Operation',7944,1047,'ITRF91 to ETRF2000 [EUREF v1]',''),
+(8884,'Coordinate_Operation',7934,1046,'479',''),
 (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',''),
+(8887,'Coordinate_Operation',7934,1047,'ITRF91 to ETRF91 [EUREF v1]',''),
+(8888,'Coordinate_Operation',7943,1046,'545',''),
+(8889,'Coordinate_Operation',7943,1047,'ITRF90 to ETRF2000 [EUREF v1]',''),
 (889,'Coordinate Reference System',22193,7302,'C Inchauspe / Argentina 3',''),
+(8890,'Coordinate_Operation',7933,1046,'650',''),
+(8891,'Coordinate_Operation',7933,1047,'ITRF90 to ETRF90 [EUREF v1]',''),
+(8892,'Coordinate_Operation',7942,1046,'615',''),
+(8893,'Coordinate_Operation',7942,1047,'ITRF89 to ETRF2000 [EUREF v1]',''),
+(8894,'Coordinate_Operation',7932,1046,'506',''),
+(8895,'Coordinate_Operation',7932,1047,'ITRF89 to ETRF89 [EUREF v1]',''),
+(8896,'Coordinate_Operation',7941,1046,'509',''),
+(8897,'Coordinate_Operation',7941,1047,'ITRF2000 to ETRF2000 [EUREF v1]',''),
+(8898,'Coordinate_Operation',7950,1046,'678',''),
+(8899,'Coordinate_Operation',7950,1047,'ITRF2005 to ETRF2000 [EUREF v1]',''),
 (89,'Unit of Measure',9061,7301,'foot',''),
 (890,'Coordinate Reference System',22194,7302,'C Inchauspe / Argentina 4',''),
+(8900,'Coordinate_Operation',5900,1046,'672',''),
+(8901,'Coordinate_Operation',5900,1047,'ITRF2005 to ETRF2005 [EUREF v1]',''),
+(8902,'Coordinate_Operation',7951,1046,'527',''),
+(8903,'Coordinate_Operation',7951,1047,'ITRF2008 to ETRF2000 [EUREF v1]',''),
+(8904,'Coordinate_Operation',7667,1046,'492',''),
+(8905,'Coordinate_Operation',7667,1047,'WGS 84 (G1674) to WGS 84 (G1762) [1]',''),
+(8906,'Coordinate_Operation',9076,1046,'712',''),
+(8907,'Coordinate_Operation',9076,1047,'WGS 84 (G873) to ITRF94 [1]',''),
+(8908,'Coordinate_Operation',7668,1046,'577',''),
+(8909,'Coordinate_Operation',7668,1047,'WGS 84 (G1150) to WGS 84 (G1762) [1]',''),
 (891,'Coordinate Reference System',22195,7302,'C Inchauspe / Argentina 5',''),
+(8910,'Coordinate_Operation',7666,1046,'709',''),
 (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.'),
+(8912,'Coordinate_Operation',7666,1047,'WGS 84 (G1762) to ITRF2008 [1]',''),
+(8913,'Coordinate_Operation',7669,1046,'708',''),
+(8914,'Coordinate_Operation',7669,1047,'WGS 84 (G1674) to ITRF2008 [1]',''),
+(8915,'Coordinate_Operation',7670,1046,'606',''),
+(8916,'Coordinate_Operation',7670,1047,'WGS 84 (G1150) to ITRF2000 [1]',''),
+(8917,'Coordinate_Operation',7672,1046,'661',''),
+(8918,'Coordinate_Operation',7672,1047,'WGS 84 (G730) to ITRF92 [1]',''),
+(8919,'Coordinate_Operation',10084,1046,'508',''),
 (892,'Coordinate Reference System',22196,7302,'C Inchauspe / Argentina 6',''),
+(8920,'Coordinate_Operation',10084,1047,'WGS 84 (G1150) to WGS 84 EGM96 - OHt [1]',''),
+(8921,'Coordinate_Operation',10084,1046,'608',''),
+(8922,'Coordinate_Operation',10084,1047,'WGS 84 (G1674) to WGS 84 EGM96 - OHt [1]',''),
+(8923,'Coordinate_Operation',3858,1046,'644',''),
+(8924,'Coordinate_Operation',3858,1047,'WGS 84 (G1762) to WGS 84 EGM2008 - OHt [1]',''),
 (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.'),
+(8926,'Coordinate_Operation',3859,1046,'470',''),
+(8927,'Coordinate_Operation',3859,1047,'WGS 84 (G1762) to WGS 84 EGM2008 - OHt [2]',''),
+(8928,'Coordinate_Operation',15781,1046,'585',''),
+(8929,'Coordinate_Operation',15781,1047,'WGS 84 (G730) to WGS 84 EGM84 - OHt [1]',''),
 (893,'Coordinate Reference System',22197,7302,'C Inchauspe / Argentina 7',''),
 (894,'Coordinate Reference System',22275,7302,'South African CS zone 15',''),
 (895,'Coordinate Reference System',22277,7302,'South African CS zone 17',''),
 (896,'Coordinate Reference System',22279,7302,'South African CS zone 19',''),
 (897,'Coordinate Reference System',22281,7302,'South African CS zone 21',''),
+(8976,'Coordinate_Operation',7675,7301,'MGI 1901 to SRB_ETRS89 (6)',''),
 (898,'Coordinate Reference System',22283,7302,'South African CS zone 23',''),
 (899,'Coordinate Reference System',22285,7302,'South African CS zone 25',''),
 (8999,'Coordinate Reference System',4511,7301,'CGCS2000 / 6-degree Gauss-Kruger CM 129E',''),
@@ -10091,32 +10481,64 @@ INSERT INTO epsg_alias VALUES
 (9000,'Coordinate Reference System',4511,7302,'CGCS2000 / G-K CM 129E',''),
 (9006,'Coordinate Reference System',4531,7302,'CGCS2000 / 3GK zone 43',''),
 (9007,'Coordinate Reference System',4533,7302,'CGCS2000 / 3GK zone 45',''),
+(9008,'Coordinate_Operation',1566,1046,'590',''),
+(9009,'Coordinate_Operation',1566,1047,'NZGD1949 to NZGD2000 [LINZv1]',''),
 (901,'Coordinate Reference System',22289,7302,'South African CS zone 29',''),
 (9010,'Coordinate Reference System',4532,7302,'CGCS2000 / 3GK zone 44',''),
+(9013,'Coordinate_Operation',1701,1046,'711',''),
 (9014,'Coordinate Reference System',4530,7302,'CGCS2000 / 3GK zone 42',''),
+(9015,'Coordinate_Operation',1701,1047,'NZGD1949 to NZGD2000 [LINZv2]',''),
+(9016,'Coordinate_Operation',1568,1046,'640',''),
+(9017,'Coordinate_Operation',1568,1047,'NZGD1949 to NZGD2000 [LINZv3]',''),
 (9018,'Coordinate Reference System',4528,7302,'CGCS2000 / 3GK zone 40',''),
+(9019,'Coordinate_Operation',4459,1046,'681',''),
 (902,'Coordinate Reference System',22291,7302,'South African CS zone 31',''),
+(9020,'Coordinate_Operation',4459,1047,'NZGD2000 to NZVD2009 - NOHt [LINZ]',''),
+(9021,'Coordinate_Operation',7840,1046,'483',''),
 (9022,'Coordinate Reference System',4526,7302,'CGCS2000 / 3GK zone 38',''),
+(9023,'Coordinate_Operation',7840,1047,'NZGD2000 to NZVD2016 - NOHt [LINZ]',''),
 (9024,'Coordinate Reference System',4494,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 16','Part of the China National Coordinate System of 2000.'),
 (9025,'Coordinate Reference System',4494,7302,'CGCS2000 / G-K zone 16',''),
+(9026,'Coordinate_Operation',9084,1046,'582',''),
+(9027,'Coordinate_Operation',9084,1047,'ITRF96 to NZGD2000 [LINZ v20000101]',''),
+(9028,'Coordinate_Operation',9079,1046,'542','Described by ISO with source and target transposed compared to this record.'),
 (9029,'Coordinate Reference System',4527,7302,'CGCS2000 / 3GK zone 39',''),
 (903,'Coordinate Reference System',22293,7302,'South African CS zone 33',''),
+(9030,'Coordinate_Operation',9079,1047,'ITRF96 to ITRF97 [LINZ v1]',''),
 (9031,'Coordinate Reference System',4525,7302,'CGCS2000 / 3GK zone 37',''),
+(9032,'Coordinate_Operation',9085,1046,'481',''),
+(9033,'Coordinate_Operation',9085,1047,'ITRF96 to NZGD2000 [LINZ v20130801]',''),
+(9034,'Coordinate_Operation',9080,1046,'682','Described by ISO with source and target transposed compared to this record.'),
 (9035,'Coordinate Reference System',4524,7302,'CGCS2000 / 3GK zone 36',''),
+(9036,'Coordinate_Operation',9080,1047,'ITRF96 to ITRF2000 [LINZ v1]',''),
 (9037,'Coordinate Reference System',4523,7302,'CGCS2000 / 3GK zone 35',''),
+(9038,'Coordinate_Operation',9086,1046,'687',''),
 (9039,'Coordinate Reference System',4522,7302,'CGCS2000 / 3GK zone 34',''),
 (904,'Coordinate Reference System',22300,7302,'Tunisia Mining Grid',''),
+(9040,'Coordinate_Operation',9086,1047,'ITRF96 to NZGD2000 [LINZ v20140201]',''),
 (9041,'Coordinate Reference System',4521,7302,'CGCS2000 / 3GK zone 33',''),
+(9042,'Coordinate_Operation',9081,1046,'520','Described by ISO with source and target transposed compared to this record.'),
 (9043,'Coordinate Reference System',4520,7302,'CGCS2000 / 3GK zone 32',''),
+(9044,'Coordinate_Operation',9081,1047,'ITRF96 to ITRF2005 [LINZ v1]',''),
 (9045,'Coordinate Reference System',4519,7302,'CGCS2000 / 3GK zone 31',''),
 (9047,'Coordinate Reference System',4518,7302,'CGCS2000 / 3GK zone 30',''),
 (9049,'Coordinate Reference System',4517,7302,'CGCS2000 / 3GK zone 29',''),
 (905,'Coordinate Reference System',22523,7302,'Corrego Alegre / UTM 23S',''),
+(9050,'Coordinate_Operation',9082,1046,'560','Described by ISO with source and target transposed compared to this record.'),
 (9051,'Coordinate Reference System',4516,7302,'CGCS2000 / 3GK zone 28',''),
+(9052,'Coordinate_Operation',9082,1047,'ITRF96 to ITRF2008 [LINZ v1]',''),
 (9053,'Coordinate Reference System',4515,7302,'CGCS2000 / 3GK zone 27',''),
+(9054,'Coordinate_Operation',9087,1046,'713',''),
+(9055,'Coordinate_Operation',9087,1047,'ITRF96 to NZGD2000 [LINZ v20150101]',''),
+(9056,'Coordinate_Operation',9083,1046,'651','Described by ISO with source and target transposed compared to this record.'),
 (9057,'Coordinate Reference System',4514,7302,'CGCS2000 / 3GK zone 26',''),
+(9058,'Coordinate_Operation',9083,1047,'ITRF96 to ITRF2014 [LINZ v1]',''),
 (9059,'Coordinate Reference System',4513,7302,'CGCS2000 / 3GK zone 25',''),
 (906,'Coordinate Reference System',22524,7302,'Corrego Alegre / UTM 24S',''),
+(9060,'Coordinate_Operation',9089,1046,'505',''),
+(9061,'Coordinate_Operation',9089,1047,'ITRF96 to NZGD2000 [LINZ v20171201]',''),
+(9062,'Coordinate_Operation',9088,1046,'689',''),
+(9063,'Coordinate_Operation',9088,1047,'ITRF96 to NZGD2000 [LINZ v20160701]',''),
 (907,'Coordinate Reference System',22994,7302,'Egypt 1907 / Ext. Purple',''),
 (908,'Coordinate Reference System',23946,7302,'Indian 1954 / UTM 46N',''),
 (909,'Coordinate Reference System',23947,7302,'Indian 1954 / UTM 47N',''),
@@ -10129,8 +10551,13 @@ INSERT INTO epsg_alias VALUES
 (914,'Coordinate Reference System',24200,7302,'JAD69 / Jamaica Grid',''),
 (915,'Coordinate Reference System',24305,7302,'Kalianpur 37 / UTM 45N',''),
 (916,'Coordinate Reference System',24306,7302,'Kalianpur 37 / UTM 46N',''),
+(9163,'Coordinate_Operation',9133,7301,'RGAF09 to IGN 1988 (1)',''),
 (917,'Coordinate Reference System',24311,7302,'Kalianpur 62 / UTM 41N',''),
+(9170,'Coordinate_Operation',9136,7301,'RGAF09 to IGN 1987 (2)',''),
+(9174,'Datum',1251,7302,'KOSOVAREF01',''),
+(9175,'Datum',1251,7301,'KOSOVAREF01 (2012)',''),
 (918,'Coordinate Reference System',24312,7302,'Kalianpur 62 / UTM 42N',''),
+(9181,'Coordinate Reference System',9141,7301,'KOSOVAREF01 / Transverse Mercator (TM)',''),
 (919,'Coordinate Reference System',24313,7302,'Kalianpur 62 / UTM 43N',''),
 (92,'Unit of Measure',9070,7301,'foot',''),
 (920,'Coordinate Reference System',24342,7302,'Kalianpur 75 / UTM 42N',''),
@@ -10581,7 +11008,7 @@ 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; 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),
+(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; Kosovo; 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-07-17','2005.890 2007.072 2011.004 2011.082 2014.024 2016.058 2019.030 2019.042',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),
@@ -10604,7 +11031,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. 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),
+(1321,'Europe - Austria and former Yugoslavia onshore','Austria. Bosnia and Herzegovina. Croatia - onshore. Kosovo. 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-07-17','2007.072 2008.045 2008.053 2008.054 2011.055 2011.082 2014.024 2019.030 2019.042',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),
@@ -10994,7 +11421,7 @@ INSERT INTO epsg_area VALUES
 (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','IOGP','2018-08-29','2008.045 2008.053 2008.054 2011.055 2011.112 2014.022 2018.024',false),
 (1710,'Europe - former Yugoslavia onshore 16.5°E to 19.5°E','Bosnia and Herzegovina - between 16°30''E and 19°30''E; Croatia - onshore east of 16°30''E; Montenegro - onshore west of 19°30''E; Serbia - west of 19°30''E.',41.79,46.55,16.5,19.51,'urn:ogc:def:extent-polygon:EPSG::1710','','',Null,'','OGP','IOGP','2018-08-29','2007.072 2008.045 2008.053 2008.054 2011.055 2011.112 2014.022 2018.024',false),
-(1711,'Europe - former Yugoslavia onshore 19.5°E to 22.5°E','Bosnia and Herzegovina - east of 19°30''E; Montenegro - east of 19°30''E; North Macedonia - west of 22°30''E; Serbia - between 19°30''E and 22°30''E.',40.85,46.19,19.5,22.51,'urn:ogc:def:extent-polygon:EPSG::1711','','',Null,'','OGP','IOGP','2019-05-17','2007.072 2008.045 2011.055 2014.022 2018.024 2019.030',false),
+(1711,'Europe - former Yugoslavia onshore 19.5°E to 22.5°E','Bosnia and Herzegovina - east of 19°30''E; Kosovo; Montenegro - east of 19°30''E; North Macedonia - west of 22°30''E; Serbia - between 19°30''E and 22°30''E.',40.85,46.19,19.5,22.51,'urn:ogc:def:extent-polygon:EPSG::1711','','',Null,'','OGP','IOGP','2019-07-17','2007.072 2008.045 2011.055 2014.022 2018.024 2019.030 2019.042',false),
 (1712,'Europe - former Yugoslavia onshore east of 22.5°E','North Macedonia - east of 22°30''E; Serbia - east of 22°30''E.',41.11,44.7,22.5,23.04,'urn:ogc:def:extent-polygon:EPSG::1712','','',Null,'','OGP','IOGP','2019-05-17','2007.072 2008.045 2011.055 2014.022 2018.024 2019.030',false),
 (1713,'Nigeria - east of 10.5°E','Nigeria east of 10°30''E.',6.43,13.72,10.49,14.65,'urn:ogc:def:extent-polygon:EPSG::1713','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.042 2014.022',false),
 (1714,'Nigeria - 6.5°E to 10.5°E','Nigeria between 6°30''E and 10°30''E, onshore and offshore shelf.',3.57,13.53,6.5,10.51,'urn:ogc:def:extent-polygon:EPSG::1714','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.054 2012.042 2014.022',false),
@@ -11349,7 +11776,7 @@ INSERT INTO epsg_area VALUES
 (2063,'World - S hemisphere - 6°E to 12°E - by country','Between 6°E and 12°E, southern hemisphere between 80°S and equator, onshore and offshore. Angola. Congo. Gabon. Namibia.',-80,0,6,12,'urn:ogc:def:extent-polygon:EPSG::2063','','',Null,'','OGP','OGP','2011-05-09','2005.144 2008.045 2011.022 2011.040',false),
 (2064,'World - N hemisphere - 12°E to 18°E - by country','Between 12°E and 18°E, northern hemisphere between equator and 84°N, onshore and offshore. Austria. Bosnia and Herzegovina. Cameroon. Central African Republic. Chad. Congo. Croatia. Czechia. Democratic Republic of the Congo (Zaire). Gabon. Germany. Hungary. Italy. Libya. Malta. Niger. Nigeria. Norway. Poland. San Marino. Slovakia. Slovenia. Svalbard. Sweden. Vatican City State.',0,84,12,18,'urn:ogc:def:extent-polygon:EPSG::2064','','',Null,'','OGP','IOGP','2019-05-17','2005.144 2005.890 2008.045 2008.053 2008.054 2011.022 2011.040 2019.030',false),
 (2065,'World - S hemisphere - 12°E to 18°E - by country','Between 12°E and 18°E, southern hemisphere between 80°S and equator, onshore and offshore. Angola. Congo. Democratic Republic of the Congo (Zaire). Gabon. Namibia. South Africa.',-80,0,12,18,'urn:ogc:def:extent-polygon:EPSG::2065','','',Null,'','OGP','OGP','2011-05-09','2005.144 2008.045 2011.022 2011.040',false),
-(2066,'World - N hemisphere - 18°E to 24°E - by country','Between 18°E and 24°E, northern hemisphere between equator and 84°N, onshore and offshore. Albania. Belarus. Bosnia and Herzegovina. Bulgaria. Central African Republic. Chad. Croatia. Democratic Republic of the Congo (Zaire). Estonia. Finland. Greece. Hungary. Italy. Latvia. Libya. Lithuania. Montenegro. North Macedonia. Norway, including Svalbard and Bjornoys. Poland. Romania. Russian Federation. Serbia. Slovakia. Sudan. Sweden. Ukraine.',0,84,18,24,'urn:ogc:def:extent-polygon:EPSG::2066','','',Null,'','OGP','IOGP','2019-05-17','2005.144 2007.072 2008.045 2008.053 2008.054 2011.022 2011.040 2019.030',false),
+(2066,'World - N hemisphere - 18°E to 24°E - by country','Between 18°E and 24°E, northern hemisphere between equator and 84°N, onshore and offshore. Albania. Belarus. Bosnia and Herzegovina. Bulgaria. Central African Republic. Chad. Croatia. Democratic Republic of the Congo (Zaire). Estonia. Finland. Greece. Hungary. Italy. Kosovo. Latvia. Libya. Lithuania. Montenegro. North Macedonia. Norway, including Svalbard and Bjornoys. Poland. Romania. Russian Federation. Serbia. Slovakia. Sudan. Sweden. Ukraine.',0,84,18,24,'urn:ogc:def:extent-polygon:EPSG::2066','','',Null,'','OGP','IOGP','2019-07-17','2005.144 2007.072 2008.045 2008.053 2008.054 2011.022 2011.040 2019.030 2019.042',false),
 (2067,'World - S hemisphere - 18°E to 24°E - by country','Between 18°E and 24°E, southern hemisphere between 80°S and equator, onshore and offshore. Angola. Botswana. Democratic Republic of the Congo (Zaire). Namibia. South Africa. Zambia.',-80,0,18,24,'urn:ogc:def:extent-polygon:EPSG::2067','','',Null,'','OGP','OGP','2011-05-09','2005.144 2008.045 2011.022 2011.040',false),
 (2068,'World - N hemisphere - 24°E to 30°E - by country','Between 24°E and 30°E, northern hemisphere between equator and 84°N, onshore and offshore. Belarus. Bulgaria. Central African Republic. Democratic Republic of the Congo (Zaire). Egypt. Estonia. Finland. Greece. Latvia. Lesotho. Libya. Lithuania. Moldova. Norway. Poland. Romania. Russian Federation. Sudan. Svalbard. Turkey. Uganda. Ukraine.',0,84,24,30,'urn:ogc:def:extent-polygon:EPSG::2068','','',Null,'','OGP','OGP','2011-05-09','2005.144 2008.045 2011.022 2011.040',false),
 (2069,'World - S hemisphere - 24°E to 30°E - by country','Between 24°E and 30°E, southern hemisphere between 80°S and equator, onshore and offshore. Botswana. Burundi. Democratic Republic of the Congo (Zaire). Rwanda. South Africa. Tanzania. Uganda. Zambia. Zimbabwe.',-80,0,24,30,'urn:ogc:def:extent-polygon:EPSG::2069','','',Null,'','OGP','OGP','2011-05-09','2005.144 2008.045 2011.022 2011.040',false),
@@ -11653,7 +12080,7 @@ INSERT INTO epsg_area VALUES
 (2367,'Spain - mainland northeast','Spain - onshore mainland north of the parallel of approximately 41°58''N from approximately 6°35''W to the meridian of 4°W of Greenwich and then a line from 41°58''N, 4°W through 40°N, 0°E of Greenwich.',39.96,43.82,-9.37,3.39,'urn:ogc:def:extent-polygon:EPSG::2367','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.035 2011.113 2014.020',false),
 (2368,'Spain - mainland southwest','Spain - onshore mainland south of the parallel of approximately 41°58''N from approximately 6°35''W to the meridian of 4°W of Greenwich and then a line from 41°58''N, 4°W through 40°N, 0°E of Greenwich.',35.95,41.98,-7.54,0.28,'urn:ogc:def:extent-polygon:EPSG::2368','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.035 2011.113 2014.020',false),
 (2369,'Seychelles - Mahe Island','Seychelles - Mahe Island.',-4.86,-4.5,55.3,55.59,'urn:ogc:def:extent-polygon:EPSG::2369','','',Null,'','OGP','OGP','2014-09-08','2012.048 2014.020 2014.037',false),
-(2370,'Europe - former Yugoslavia onshore','Boznia and Herzegovina; Croatia - onshore; Montenegro - onshore; North Macedonia; Serbia; Slovenia - onshore.',40.85,46.88,13.38,23.04,'urn:ogc:def:extent-polygon:EPSG::2370','','',Null,'','OGP','IOGP','2019-05-17','2011.055 2011.112 2014.020 2019.030',false),
+(2370,'Europe - former Yugoslavia onshore','Boznia and Herzegovina; Croatia - onshore; Kosovo; Montenegro - onshore; North Macedonia; Serbia; Slovenia - onshore.',40.85,46.88,13.38,23.04,'urn:ogc:def:extent-polygon:EPSG::2370','','',Null,'','OGP','IOGP','2019-07-17','2011.055 2011.112 2014.020 2019.030 2019.042',false),
 (2371,'Nigeria - south','Nigeria - onshore south.',4.22,6.95,4.35,9.45,'urn:ogc:def:extent-polygon:EPSG::2371','','',Null,'','OGP','OGP','2014-05-01','2012.049 2014.020',false),
 (2372,'Italy - mainland','Italy - mainland including San Marino and Vatican City State.',37.86,47.1,6.62,18.58,'urn:ogc:def:extent-polygon:EPSG::2372','','',Null,'','OGP','OGP','2014-05-01','2011.112 2014.020',false),
 (2373,'USA - Alaska including EEZ','United States (USA) - Alaska including EEZ.',47.88,74.71,167.65,-129.99,'urn:ogc:def:extent-polygon:EPSG::2373','','',Null,'Area crosses 180-degree meridian.','OGP','OGP','2011-08-17','2008.070 2011.067 2011.069',false),
@@ -12113,7 +12540,7 @@ INSERT INTO epsg_area VALUES
 (2827,'Africa - South Sudan and Sudan - 24°E to 30°E','South Sudan and Sudan - between 24°E and 30°E.',4.21,22.01,23.99,30.01,'urn:ogc:def:extent-polygon:EPSG::2827','','',Null,'','OGP','IOGP','2019-01-14','2002.810 2012.001 2012.049 2014.018 2018.064',false),
 (2828,'Guadeloupe - St Martin and St Barthelemy - onshore','Guadeloupe - onshore - St Martin and St Barthélemy islands.',17.82,18.17,-63.21,-62.73,'urn:ogc:def:extent-polygon:EPSG::2828','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.051 2014.018',false),
 (2829,'Guadeloupe - Grande-Terre and surrounding islands - onshore','Guadeloupe - onshore - Basse-Terre, Grande-Terre, La Desirade, Marie-Galante, Les Saintes.',15.80,16.55,-61.85,-60.97,'urn:ogc:def:extent-polygon:EPSG::2829','','',Null,'','OGP','OGP','2014-05-01','2008.087 2011.051 2014.018',false),
-(2830,'World (by country)','World: Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antarctica, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belgium, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bonaire, Saint Eustasius and Saba, Bosnia and Herzegovina, Botswana, Bouvet Island, Brazil, British Indian Ocean Territory, British Virgin Islands, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Cayman Islands, Central African Republic, Chad, Chile, China, Christmas Island, Cocos (Keeling) Islands, Comoros, Congo, Cook Islands, Costa Rica, Côte d''Ivoire (Ivory Coast), Croatia, Cuba, Curacao, Cyprus, Czechia, Denmark, Djibouti, Dominica, Dominican Republic, East Timor, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Eswatini (Swaziland), Ethiopia, Falkland Islands (Malvinas), Faroe Islands, Fiji, Finland, France, French Guian
 a, French Polynesia, French Southern Territories, Gabon, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guadeloupe, Guam, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Heard Island and McDonald Islands, Holy See (Vatican City State), Honduras, China - Hong Kong, Hungary, Iceland, India, Indonesia, Islamic Republic of Iran, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Democratic People''s Republic of Korea (North Korea), Republic of Korea (South Korea), Kuwait, Kyrgyzstan, Lao People''s Democratic Republic (Laos), Latvia, Lebanon, Lesotho, Liberia, Libyan Arab Jamahiriya, Liechtenstein, Lithuania, Luxembourg, China - Macao, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Martinique, Mauritania, Mauritius, Mayotte, Mexico, Federated States of Micronesia, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Myanmar (Burma), Namibia, Nauru, Nepal, Netherlands, New Caledonia, New Zealand, N
 icaragua, Niger, Nigeria, Niue, Norfolk Island, North Macedonia, Northern Mariana Islands, Norway, Oman, Pakistan, Palau, Panama, Papua New Guinea (PNG), Paraguay, Peru, Philippines, Pitcairn, Poland, Portugal, Puerto Rico, Qatar, Reunion, Romania, Russian Federation, Rwanda, Saint Kitts and Nevis, Saint Helena, Ascension and Tristan da Cunha, Saint Lucia, Saint Pierre and Miquelon, Saint Vincent and the Grenadines, Samoa, San Marino, Sao Tome and Principe, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia (Slovak Republic), Slovenia, Sint Maarten, Solomon Islands, Somalia, South Africa, South Georgia and the South Sandwich Islands, South Sudan, Spain, Sri Lanka, Sudan, Suriname, Svalbard and Jan Mayen, Sweden, Switzerland, Syrian Arab Republic, Taiwan, Tajikistan, United Republic of Tanzania, Thailand, The Democratic Republic of the Congo (Zaire), Togo, Tokelau, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Tuvalu, U
 ganda, Ukraine, United Arab Emirates (UAE), United Kingdom (UK), United States (USA), United States Minor Outlying Islands, Uruguay, Uzbekistan, Vanuatu, Venezuela, Vietnam, US Virgin Islands, Wallis and Futuna, Western Sahara, Yemen, Zambia, Zimbabwe.',-90,90,-180,180,'urn:ogc:def:extent-polygon:EPSG::2830','','',Null,'','OGP','IOGP','2019-05-17','2007.072 2008.053 2008.054 2011.015 2012.001 2018.060 2019.030',false),
+(2830,'World (by country)','World: Afghanistan, Albania, Algeria, American Samoa, Andorra, Angola, Anguilla, Antarctica, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan, Bahamas, Bahrain, Bangladesh, Barbados, Belgium, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bonaire, Saint Eustasius and Saba, Bosnia and Herzegovina, Botswana, Bouvet Island, Brazil, British Indian Ocean Territory, British Virgin Islands, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde, Cayman Islands, Central African Republic, Chad, Chile, China, Christmas Island, Cocos (Keeling) Islands, Comoros, Congo, Cook Islands, Costa Rica, Côte d''Ivoire (Ivory Coast), Croatia, Cuba, Curacao, Cyprus, Czechia, Denmark, Djibouti, Dominica, Dominican Republic, East Timor, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Eswatini (Swaziland), Ethiopia, Falkland Islands (Malvinas), Faroe Islands, Fiji, Finland, France, French Guian
 a, French Polynesia, French Southern Territories, Gabon, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guadeloupe, Guam, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Heard Island and McDonald Islands, Holy See (Vatican City State), Honduras, China - Hong Kong, Hungary, Iceland, India, Indonesia, Islamic Republic of Iran, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Democratic People''s Republic of Korea (North Korea), Republic of Korea (South Korea), Kosovo, Kuwait, Kyrgyzstan, Lao People''s Democratic Republic (Laos), Latvia, Lebanon, Lesotho, Liberia, Libyan Arab Jamahiriya, Liechtenstein, Lithuania, Luxembourg, China - Macao, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Marshall Islands, Martinique, Mauritania, Mauritius, Mayotte, Mexico, Federated States of Micronesia, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Myanmar (Burma), Namibia, Nauru, Nepal, Netherlands, New Caledonia, New Ze
 aland, Nicaragua, Niger, Nigeria, Niue, Norfolk Island, North Macedonia, Northern Mariana Islands, Norway, Oman, Pakistan, Palau, Panama, Papua New Guinea (PNG), Paraguay, Peru, Philippines, Pitcairn, Poland, Portugal, Puerto Rico, Qatar, Reunion, Romania, Russian Federation, Rwanda, Saint Kitts and Nevis, Saint Helena, Ascension and Tristan da Cunha, Saint Lucia, Saint Pierre and Miquelon, Saint Vincent and the Grenadines, Samoa, San Marino, Sao Tome and Principe, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia (Slovak Republic), Slovenia, Sint Maarten, Solomon Islands, Somalia, South Africa, South Georgia and the South Sandwich Islands, South Sudan, Spain, Sri Lanka, Sudan, Suriname, Svalbard and Jan Mayen, Sweden, Switzerland, Syrian Arab Republic, Taiwan, Tajikistan, United Republic of Tanzania, Thailand, The Democratic Republic of the Congo (Zaire), Togo, Tokelau, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, T
 uvalu, Uganda, Ukraine, United Arab Emirates (UAE), United Kingdom (UK), United States (USA), United States Minor Outlying Islands, Uruguay, Uzbekistan, Vanuatu, Venezuela, Vietnam, US Virgin Islands, Wallis and Futuna, Western Sahara, Yemen, Zambia, Zimbabwe.',-90,90,-180,180,'urn:ogc:def:extent-polygon:EPSG::2830','','',Null,'','OGP','IOGP','2019-07-17','2007.072 2008.053 2008.054 2011.015 2012.001 2018.060 2019.030 2019.042',false),
 (2831,'Canada - Atlantic offshore','Canada - offshore Newfoundland and Labrador, New Brunswick and Nova Scotia.',40.04,64.21,-67.75,-47.74,'urn:ogc:def:extent-polygon:EPSG::2831','','',Null,'','OGP','OGP','2014-05-01','2011.067 2014.018',false),
 (2832,'Canada - British Columbia','Canada - British Columbia.',48.25,60.01,-139.04,-114.08,'urn:ogc:def:extent-polygon:EPSG::2832','','',Null,'','OGP','OGP','2014-05-01','2011.067 2014.018',false),
 (2833,'Sweden - 12 00','Sweden - communes west of approximately 12°45''E and south of approximately 60°N. See information source for map.',56.74,60.13,10.93,13.11,'urn:ogc:def:extent-polygon:EPSG::2833','','',Null,'','Lantmateriet (National Land Survey of Sweden).  http://www.lantmateriet.se','OGP','2014-05-01','2005.460 2008.045 2011.112 2014.018',false),
@@ -12164,7 +12591,7 @@ INSERT INTO epsg_area VALUES
 (2878,'Slovenia - Slovenske Gorice','Slovenia - Slovenske Gorice (the Slovene Humpback) with the broad region of Ormoz.',46.29,46.76,15.9,16.3,'urn:ogc:def:extent-polygon:EPSG::2878','','',Null,'','Geodetska uprava Republike Slovenije, http://www.gu.gov.si','OGP','2014-05-01','2011.113 2014.018',false),
 (2879,'Germany - offshore North Sea','Germany - offshore North Sea.',53.6,55.92,3.34,8.88,'urn:ogc:def:extent-polygon:EPSG::2879','','',Null,'','OGP','OGP','2014-05-01','2011.095 2012.013 2014.018',false),
 (2880,'Antarctica - Australian sector north of 80°S','Antarctica - north of 80°S and between 45°E and 136°E and between 142°E and 160°E - Australian sector north of 80°S.',-80,-60,45,160,'urn:ogc:def:extent-polygon:EPSG::2880','','',Null,'','OGP','OGP','2012-05-26','2008.045 2012.023 2012.060',false),
-(2881,'Europe - LCC & LAEA','Europe - European Union (EU) countries and candidates. 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; Iceland; Ireland; Italy; Latvia; Liechtenstein; Lithuania; Luxembourg; Malta; Monaco; Montenegro; Netherlands; North Macedonia; Norway including Svalbard and Jan Mayen; Poland; Portugal including Madeira and Azores; Romania; San Marino; Serbia; Slovakia; Slovenia; Spain including Canary Islands; Sweden; Switzerland; Turkey; United Kingdom (UK) including Channel Islands and Isle of Man; Vatican City State.',24.60,84.17,-35.58,44.83,'urn:ogc:def:extent-polygon:EPSG::2881','','',Null,'','OGP','IOGP','2019-05-17','2011.082 2014.018 2019.030',false),
+(2881,'Europe - LCC & LAEA','Europe - European Union (EU) countries and candidates. 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; Iceland; Ireland; Italy; Kosovo; Latvia; Liechtenstein; Lithuania; Luxembourg; Malta; Monaco; Montenegro; Netherlands; North Macedonia; Norway including Svalbard and Jan Mayen; Poland; Portugal including Madeira and Azores; Romania; San Marino; Serbia; Slovakia; Slovenia; Spain including Canary Islands; Sweden; Switzerland; Turkey; United Kingdom (UK) including Channel Islands and Isle of Man; Vatican City State.',24.60,84.17,-35.58,44.83,'urn:ogc:def:extent-polygon:EPSG::2881','','',Null,'','OGP','IOGP','2019-07-17','2011.082 2014.018 2019.030 2019.042',false),
 (2882,'Italy - Adriatic - North Ancona','Italy - offshore - Adriatic Sea - North Ancona.',43.62,45.73,12.22,13.96,'urn:ogc:def:extent-polygon:EPSG::2882','','',Null,'','OGP','OGP','2014-05-01','2011.112 2014.018',false),
 (2883,'Italy - Adriatic - South Ancona / North Gargano','Italy - offshore - Adriatic Sea - South Ancona and North Gargano.',41.95,44.04,13.61,16.14,'urn:ogc:def:extent-polygon:EPSG::2883','','',Null,'','OGP','OGP','2014-05-01','2011.112 2014.018',false),
 (2884,'Italy - Adriatic - South Gargano','Italy - offshore - Adriatic Sea - South Gargano.',40.72,42.28,15.95,18.63,'urn:ogc:def:extent-polygon:EPSG::2884','','',Null,'','OGP','OGP','2014-05-01','2011.112 2014.018',false),
@@ -12701,17 +13128,17 @@ INSERT INTO epsg_area VALUES
 (3415,'Canada - 90°W to 84°W','Canada between 90°W and 84°W, onshore and offshore south of 84°N - Manitoba, Nunavut, Ontario.',46.11,84,-90,-84,'urn:ogc:def:extent-polygon:EPSG::3415','','',Null,'','OGP','OGP','2014-05-01','2007.026 2008.045 2011.064 2011.069 2014.015',false),
 (3416,'Canada - 84°W to 78°W','Canada between 84°W and 78°W, onshore and offshore south of 84°N - Nunavut, Ontario and Quebec.',41.67,84,-84,-78,'urn:ogc:def:extent-polygon:EPSG::3416','','',Null,'','OGP','OGP','2014-05-01','2007.026 2008.045 2011.064 2014.015',false),
 (3417,'Canada - 78°W to 72°W','Canada between 78°W and 72°W, onshore and offshore south of 84°N - Nunavut, Ontario and Quebec.',43.63,84,-78,-72,'urn:ogc:def:extent-polygon:EPSG::3417','','',Null,'','OGP','OGP','2011-07-27','2007.026 2008.045 2011.064',false),
-(3418,'Latin America - SIRGAS 2000 by country','Central America and South America, onshore and offshore. Brazil - onshore and offshore.',-59.87,32.72,-122.19,-25.28,'urn:ogc:def:extent-polygon:EPSG::3418','','',Null,'','OGP','OGP','2014-05-01','2010.090 2010.097 2011.037 2012.070 2014.015',false),
+(3418,'Latin America - SIRGAS 2000 by country','Latin America - Central America and South America - onshore and offshore. Brazil - onshore and offshore.',-59.87,32.72,-122.19,-25.28,'urn:ogc:def:extent-polygon:EPSG::3418','','',Null,'','OGP','IOGP','2019-07-17','2010.090 2010.097 2011.037 2012.070 2014.015 2019.020',false),
 (3419,'North America - 72°W to 66°W and NAD83 by country','North America - between 72°W and 66°W - onshore and offshore. Canada - Labrador; New Brunswick; Nova Scotia; Nunavut; Quebec. Puerto Rico. United States (USA) - Connecticut; Maine; Massachusetts; New Hampshire; New York (Long Island); Rhode Island; Vermont.',14.92,84.00,-72,-66,'urn:ogc:def:extent-polygon:EPSG::3419','','',Null,'','OGP','OGP','2014-05-01','2007.037 2008.045 2011.043 2014.015',false),
 (3420,'North America - 66°W to 60°W and NAD83 by country','North America - between 66°W and 60°W - onshore and offshore. British Virgin Islands. Canada - New Brunswick; Labrador; Nunavut; Prince Edward Island; Quebec. Puerto Rico. US Virgin Islands. United States (USA) offshore Atlantic.',15.63,84.00,-66,-60,'urn:ogc:def:extent-polygon:EPSG::3420','','',Null,'','OGP','OGP','2011-08-17','2008.045 2009.064 2011.043 2011.069',false),
-(3421,'Latin America - 84°W to 78°West; N hemisphere and SIRGAS by country','Central America and South America, between 84°W and 78°W, northern hemisphere, onshore and offshore.',0,19.54,-84,-78,'urn:ogc:def:extent-polygon:EPSG::3421','','',Null,'','OGP','OGP','2011-05-09','2008.045 2010.097 2011.037',false),
-(3422,'Latin America - 78°W to 72°West; N hemisphere and SIRGAS by country','Central America and South America, between 78°W and 72°W, northern hemisphere, onshore and offshore.',0,15.04,-78,-72,'urn:ogc:def:extent-polygon:EPSG::3422','','',Null,'','OGP','OGP','2014-05-01','2008.045 2010.097 2011.037 2014.015',false),
+(3421,'Latin America - 84°W to 78°West; N hemisphere and SIRGAS by country','Latin America - Central America and South America - between 84°W and 78°W, northern hemisphere, onshore and offshore.',0,19.54,-84,-78,'urn:ogc:def:extent-polygon:EPSG::3421','','',Null,'','OGP','IOGP','2019-07-17','2008.045 2010.097 2011.037 2019.020',false),
+(3422,'Latin America - 78°W to 72°West; N hemisphere and SIRGAS by country','Latin America - Central America and South America - between 78°W and 72°W, northern hemisphere, onshore and offshore.',0,15.04,-78,-72,'urn:ogc:def:extent-polygon:EPSG::3422','','',Null,'','OGP','IOGP','2019-07-17','2008.045 2010.097 2011.037 2014.015 2019.020',false),
 (3423,'Mexico - west of 114°W','Mexico west of 114°W, onshore and offshore.',15.01,32.72,-122.19,-114,'urn:ogc:def:extent-polygon:EPSG::3423','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.064 2014.015',false),
 (3424,'Mexico - 114°W to 108°W','Mexico between 114°W and 108°W, onshore and offshore.',15.09,32.27,-114,-108,'urn:ogc:def:extent-polygon:EPSG::3424','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.064 2014.015',false),
 (3425,'Mexico - 108°W to 102°W','Mexico between 108°W and 102°W, onshore and offshore.',14.05,31.79,-108,-102,'urn:ogc:def:extent-polygon:EPSG::3425','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.064 2014.015',false),
 (3426,'Mexico - 102°W to 96°W','Mexico between 102°W and 96°W, onshore and offshore.',12.3,29.81,-102,-96,'urn:ogc:def:extent-polygon:EPSG::3426','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.064 2014.015',false),
-(3427,'Latin America - 96°W to 90°W; N hemisphere and SIRGAS 2000 by country','Central America and South America, between 96°W and 90°W, northern hemisphere, onshore and offshore.',0,26,-96,-90,'urn:ogc:def:extent-polygon:EPSG::3427','','',Null,'','OGP','OGP','2011-05-09','2008.045 2010.090 2010.097 2011.037',false),
-(3428,'Latin America - 90°W to 84°W; N hemisphere and SIRGAS 2000 by country','Central America and South America, between 90°W and 84°W, northern hemisphere, onshore and offshore.',0,25.77,-90,-83.99,'urn:ogc:def:extent-polygon:EPSG::3428','','',Null,'','OGP','OGP','2014-05-01','2008.045 2010.090 2010.097 2011.037 2014.015',false),
+(3427,'Latin America - 96°W to 90°W; N hemisphere and SIRGAS 2000 by country','Latin America - Central and South America - between 96°W and 90°W, northern hemisphere, onshore and offshore.',0,26,-96,-90,'urn:ogc:def:extent-polygon:EPSG::3427','','',Null,'','OGP','IOGP','2019-07-17','2008.045 2010.090 2010.097 2011.037 2019.020',false),
+(3428,'Latin America - 90°W to 84°W; N hemisphere and SIRGAS 2000 by country','Latin America - Central America and South America - between 90°W and 84°W, northern hemisphere, onshore and offshore.',0,25.77,-90,-83.99,'urn:ogc:def:extent-polygon:EPSG::3428','','',Null,'','OGP','IOGP','2019-07-17','2008.045 2010.090 2010.097 2011.037 2014.015 2019.020',false),
 (3429,'Spain - mainland and Balearic Islands onshore','Spain - mainland, Balearic Islands, Ceuta and Melila - onshore.',35.26,43.82,-9.37,4.39,'urn:ogc:def:extent-polygon:EPSG::3429','','',Null,'','OGP','OGP','2014-05-01','2011.113 2014.015',false),
 (3430,'New Caledonia - Belep, Grande Terre, Ile des Pins, Loyalty Islands','New Caledonia - Belep, Grande Terre, Ile des Pins, Loyalty Islands (Lifou, Mare, Ouvea).',-22.73,-19.5,163.54,168.19,'urn:ogc:def:extent-polygon:EPSG::3430','','',Null,'','OGP','OGP','2014-05-01','2012.048 2014.015',false),
 (3431,'New Caledonia - west of 162°E','New Caledonia - west of 162°E onshore and offshore.',-26.03,-15.34,156.25,162.01,'urn:ogc:def:extent-polygon:EPSG::3431','','',Null,'','OGP','IOGP','2016-12-15','2008.045 2012.048 2016.054',false),
@@ -12817,7 +13244,7 @@ INSERT INTO epsg_area VALUES
 (3531,'UAE - Dubai municipality','United Arab Emirates (UAE) - Dubai municipality.',24.85,25.34,54.84,55.55,'urn:ogc:def:extent-polygon:EPSG::3531','','',Null,'','OGP','OGP','2014-05-01','2008.070 2008.094 2012.047 2014.015',false),
 (3532,'Channel Islands - Jersey','Channel Islands - Jersey.',48.93,49.34,-2.3,-1.98,'','JE','JEY',832,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2008-09-24','2008.070 2011.055',true),
 (3533,'Channel Islands - Guernsey','Channel Islands - Guernsey.',49.4,49.75,-2.75,-2.13,'','GG','GGY',831,'','ISO 3166 Maintenance Agency.  ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2008-09-24','2008.070 2011.055',true),
-(3534,'Serbia','Serbia.',41.85,46.19,18.81,23.01,'urn:ogc:def:extent-polygon:EPSG::3534','RS','SRB',688,'','ISO 3166 Maintenance Agency.','OGP','2014-05-01','2011.095 2014.015',false),
+(3534,'Serbia and Kosovo','Serbia including Vojvodina and Kosovo.',41.85,46.19,18.81,23.01,'urn:ogc:def:extent-polygon:EPSG::3534','RS','SRB',688,'','ISO 3166 Maintenance Agency.','IOGP','2019-07-17','2011.095 2014.015 2019.042',false),
 (3535,'Montenegro','Montenegro - onshore and offshore.',41.27,43.56,18.02,20.38,'urn:ogc:def:extent-polygon:EPSG::3535','ME','MNE',499,'','ISO 3166 Maintenance Agency.','OGP','2014-05-01','2008.045 2008.053 2008.054 2011.095 2014.015',false),
 (3536,'Montenegro - onshore','Montenegro - onshore.',41.79,43.56,18.45,20.38,'urn:ogc:def:extent-polygon:EPSG::3536','','',Null,'','OGP','OGP','2014-05-01','2011.095 2014.015',false),
 (3537,'Portugal - mainland - offshore','Portugal - mainland - offshore.',34.91,41.88,-13.87,-7.24,'urn:ogc:def:extent-polygon:EPSG::3537','','',Null,'','Direcção Geral de Energia e Geologia (DGEG)','OGP','2014-05-01','2011.113 2012.020 2014.015',false),
@@ -13031,7 +13458,7 @@ INSERT INTO epsg_area VALUES
 (3745,'Bhutan - Mongar district','Bhutan - Mongar district.',26.93,27.61,90.95,91.50,'urn:ogc:def:extent-polygon:EPSG::3745','','',Null,'','OGP','OGP','2010-09-17','2010.086',false),
 (3746,'Bhutan - Paro district','Bhutan - Paro district.',27.18,27.79,89.12,89.56,'urn:ogc:def:extent-polygon:EPSG::3746','','',Null,'','OGP','OGP','2010-09-17','2010.086',false),
 (3747,'Bhutan - Pemagatshel district','Bhutan - Pemagatshel district.',26.78,27.18,91.00,91.56,'urn:ogc:def:extent-polygon:EPSG::3747','','',Null,'','OGP','IOGP','2017-03-19','2010.086 2014.013 2017.008',false),
-(3748,'Latin America - 120°W to 114°W','Central America between 120°W and 114°W, northern hemisphere, onshore and offshore.',15.01,32.72,-120,-114,'urn:ogc:def:extent-polygon:EPSG::3748','','',Null,'','OGP','OGP','2011-05-09','2010.090 2010.097 2011.037',false),
+(3748,'Latin America - 120°W to 114°W','Latin America between 120°W and 114°W, northern hemisphere, onshore and offshore.',15.01,32.72,-120,-114,'urn:ogc:def:extent-polygon:EPSG::3748','','',Null,'','OGP','IOGP','2019-07-17','2010.090 2010.097 2011.037 2019.020',false),
 (3749,'Bhutan - Punakha district','Bhutan - Punakha district.',27.46,27.87,89.63,90.08,'urn:ogc:def:extent-polygon:EPSG::3749','','',Null,'','OGP','OGP','2014-05-01','2010.086 2014.013',false),
 (3750,'Bhutan - Samdrup Jongkhar district','Bhutan - Samdrup Jongkhar district.',26.79,27.25,91.39,92.13,'urn:ogc:def:extent-polygon:EPSG::3750','','',Null,'','OGP','IOGP','2017-03-19','2010.086 2014.013 2017.008',false),
 (3751,'Bhutan - Samtse district','Bhutan - Samtse district.',26.8,27.28,88.74,89.38,'urn:ogc:def:extent-polygon:EPSG::3751','','',Null,'','OGP','IOGP','2017-03-19','2010.086 2014.013 2017.008',false),
@@ -13039,14 +13466,14 @@ INSERT INTO epsg_area VALUES
 (3753,'Bhutan - Thimphu district','Bhutan - Thimphu district.',27.14,28.01,89.22,89.77,'urn:ogc:def:extent-polygon:EPSG::3753','','',Null,'','OGP','OGP','2010-09-17','2010.086',false),
 (3754,'Bhutan - Trashigang district','Bhutan - Trashigang district.',27.01,27.49,91.37,92.13,'urn:ogc:def:extent-polygon:EPSG::3754','','',Null,'','OGP','IOGP','2017-03-19','2010.086 2014.013 2017.008',false),
 (3755,'Bhutan - Trongsa district','Bhutan - Trongsa district.',27.13,27.79,90.26,90.76,'urn:ogc:def:extent-polygon:EPSG::3755','','',Null,'','OGP','OGP','2010-09-17','2010.086',false),
-(3756,'Latin America - 114°W to 108°W','Central America between 114°W and 108°W, northern hemisphere, onshore and offshore.',15.09,32.27,-114,-108,'urn:ogc:def:extent-polygon:EPSG::3756','','',Null,'','OGP','OGP','2014-05-01','2010.090 2010.097 2011.037 2014.013',false),
+(3756,'Latin America - 114°W to 108°W','Latin America between 114°W and 108°W, northern hemisphere, onshore and offshore.',15.09,32.27,-114,-108,'urn:ogc:def:extent-polygon:EPSG::3756','','',Null,'','OGP','IOGP','2019-07-17','2010.090 2010.097 2011.037 2014.013 2019.020',false),
 (3757,'Bhutan - Tsirang district','Bhutan - Tsirang district.',26.81,27.20,90.00,90.35,'urn:ogc:def:extent-polygon:EPSG::3757','','',Null,'','OGP','OGP','2010-09-17','2010.086',false),
 (3758,'Bhutan - Wangdue Phodrang district','Bhutan - Wangdue Phodrang district.',27.11,28.08,89.71,90.54,'urn:ogc:def:extent-polygon:EPSG::3758','','',Null,'','OGP','OGP','2014-05-01','2010.086 2014.013',false),
-(3759,'Latin America - 108°W to 102°W','Central America between 108°W and 102°W,  northern hemisphere, onshore and offshore.',14.05,31.79,-108,-102,'urn:ogc:def:extent-polygon:EPSG::3759','','',Null,'','OGP','OGP','2014-05-01','2010.090 2010.097 2011.037 2014.013',false),
+(3759,'Latin America - 108°W to 102°W','Latin America between 108°W and 102°W,  northern hemisphere, onshore and offshore.',14.05,31.79,-108,-102,'urn:ogc:def:extent-polygon:EPSG::3759','','',Null,'','OGP','IOGP','2019-07-17','2010.090 2010.097 2011.037 2014.013 2019.020',false),
 (3760,'Bhutan - Yangtse district','Bhutan - Yangtse district.',27.37,28,91.34,91.77,'urn:ogc:def:extent-polygon:EPSG::3760','','',Null,'','OGP','IOGP','2017-03-19','2010.086 2012.050 2014.013 2017.008',false),
 (3761,'Bhutan - Zhemgang district','Bhutan - Zhemgang district.',26.77,27.39,90.53,91.19,'urn:ogc:def:extent-polygon:EPSG::3761','','',Null,'','OGP','IOGP','2017-03-19','2010.086 2017.008',false),
 (3762,'New Zealand - North Island - One Tree vcrs','New Zealand - North Island - One Tree Point vertical CRS area.',-36.41,-34.36,172.61,174.83,'urn:ogc:def:extent-polygon:EPSG::3762','','',Null,'','OGP','OGP','2014-05-01','2011.005 2012.027 2014.013',false),

[... 1283 lines stripped ...]


Mime
View raw message