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=1804432&r1=1804431&r2=1804432&view=diff ============================================================================== --- sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql [ISO-8859-1] (original) +++ sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg/Data.sql [ISO-8859-1] Tue Aug 8 14:56:55 2017 @@ -7,7 +7,6 @@ --- INSERT INTO epsg_alias VALUES -(4,'Datum',6258,7300,'ETRF89',''), (5,'Ellipsoid',7013,7300,'Modified Clarke 1880 (South Africa)','The Clarke 1880 (Arc) figure is one of several modifications to the original definition. The name Clarke Modified is usually taken to be the RGS modification. But in southern Africa it is usually taken to be the Arc or Cape modification.'), (6,'Coordinate_Operation',8570,7300,'ED50 to EUREF89 (2)',''), (7,'Unit of Measure',9001,7300,'meter',''), @@ -46,7 +45,6 @@ INSERT INTO epsg_alias VALUES (43,'Coordinate Reference System',4211,7301,'Genuk',''), (44,'Coordinate Reference System',4218,7301,'Bogota',''), (45,'Coordinate Reference System',4227,7301,'Levant',''), -(46,'Coordinate Reference System',4258,7301,'ETRF89',''), (47,'Coordinate Reference System',4272,7301,'GD49',''), (48,'Coordinate Reference System',4813,7301,'Genuk (Jakarta)',''), (49,'Datum',5104,7301,'Huang Hai 1956',''), @@ -57,7 +55,6 @@ INSERT INTO epsg_alias VALUES (55,'Datum',6218,7301,'Bogota',''), (56,'Datum',6222,7301,'South Africa',''), (57,'Datum',6227,7301,'Levant',''), -(58,'Datum',6258,7301,'European Terrestrial Reference Frame 1989',''), (59,'Datum',6269,7301,'NAD83 (1986)',''), (60,'Datum',6272,7301,'GD49',''), (61,'Datum',6308,7301,'Rikets koordinatsystem 1938',''), @@ -1234,7 +1231,6 @@ INSERT INTO epsg_alias VALUES (1250,'Coordinate Reference System',2167,7301,'Pulkovo 1942(83) / 3-degree Gauss-Kruger zone 4',''), (1251,'Coordinate Reference System',4181,7301,'LUREF',''), (1252,'Coordinate Reference System',6791,7302,'NAD83(2011) / OCRS_BKF (ft)',''), -(1253,'Coordinate Reference System',4258,7301,'EUREF89',''), (1254,'Coordinate Reference System',2180,7301,'EUREF89 / CS92',''), (1255,'Coordinate Reference System',3906,7308,'HR1901',''), (1256,'Coordinate Reference System',6795,7302,'NAD83(2011) / OCRS_BRP (ft)',''), @@ -2303,14 +2299,10 @@ INSERT INTO epsg_alias VALUES (2319,'Coordinate Reference System',3148,7301,'Indian (DMA Reduced) / UTM zone 48N',''), (2320,'Coordinate Reference System',3149,7301,'Indian (DMA Reduced) / UTM zone 49N',''), (2321,'Coordinate Reference System',4930,7302,'AAD98',''), -(2322,'Coordinate Reference System',4936,7301,'ETRF89',''), -(2323,'Coordinate Reference System',4936,7301,'EUREF89',''), (2324,'Coordinate Reference System',6863,7301,'NAD83(2011) / Oregon Sweet Home-Sisters zone (ft)','Previous name.'), (2325,'Coordinate Reference System',6796,7302,'CORS96 / OCRS_BBU (m)',''), (2326,'Coordinate Reference System',4950,7301,'LKS94 (ETRS89)',''), (2327,'Coordinate Reference System',4931,7302,'AAD98',''), -(2328,'Coordinate Reference System',4937,7301,'ETRF89',''), -(2329,'Coordinate Reference System',4937,7301,'EUREF89',''), (2330,'Coordinate Reference System',4951,7301,'LKS94 (ETRS89)',''), (2331,'Coordinate Reference System',6861,7301,'NAD83(CORS96) / Oregon Sweet Home-Sisters zone (ft)','Previous name.'), (2332,'Coordinate Reference System',6860,7302,'CORS96 / OCRS_SAN (m)',''), @@ -6983,9 +6975,9 @@ INSERT INTO epsg_alias VALUES (6999,'Coordinate Reference System',7602,7302,'WISCRS Douglas (ftUS)',''), (7000,'Coordinate Reference System',7624,7302,'WISCRS Pepin-Pierce (ftUS)',''), (7001,'Coordinate Reference System',7610,7302,'WISCRS Iowa (ftUS)',''), -(7002,'Coordinate Reference System',7624,7301,'WISCRS Pepin (ftUS)',''), +(7002,'Coordinate Reference System',7624,7301,'NAD83(2011) / WISCRS Pepin (ftUS)',''), (7003,'Coordinate Reference System',7611,7302,'WISCRS Iron (ftUS)',''), -(7004,'Coordinate Reference System',7624,7301,'WISCRS Pierce (ftUS)',''), +(7004,'Coordinate Reference System',7624,7301,'NAD83(2011) / WISCRS Pierce (ftUS)',''), (7005,'Coordinate Reference System',7612,7302,'WISCRS Jackson (ftUS)',''), (7006,'Datum',1153,7302,'WGS 84 (G873)',''), (7007,'Coordinate Reference System',7625,7302,'WISCRS Polk (ftUS)',''), @@ -7121,9 +7113,11 @@ INSERT INTO epsg_alias VALUES (7139,'Coordinate_Operation',7742,7302,'Uttar Pradesh',''), (7140,'Coordinate Reference System',7791,7301,'RDN2008 / UTM zone 32N (E-N)',''), (7141,'Coordinate_Operation',7743,7302,'Uttaranchal',''), +(7142,'Coordinate_Operation',7993,7302,'ALB2020',''), (7143,'Coordinate_Operation',7744,7302,'Andaman and Nicobar',''), (7144,'Coordinate Reference System',7792,7301,'RDN2008 / TM33 (E-N)',''), (7145,'Coordinate_Operation',7745,7302,'Chhattisgarh',''), +(7146,'Coordinate_Operation',7994,7302,'BIO2020',''), (7147,'Coordinate_Operation',7746,7302,'Goa',''), (7148,'Coordinate Reference System',7792,7301,'RDN2008 / UTM zone 33N (E-N)',''), (7149,'Coordinate_Operation',7747,7302,'Karnataka',''), @@ -7191,13 +7185,24 @@ INSERT INTO epsg_alias VALUES (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.'), +(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.'), +(7219,'Datum',1181,7302,'ETRF92',''), (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.'), +(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.'), +(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.'), +(7229,'Datum',1186,7302,'ETRF2000',''), (7230,'Coordinate Reference System',7911,7301,'IGb08','Used by IGS from 2012-10-07. For most practical purposes IGb08 is equivalent to ITRF2008.'), +(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.'), @@ -7224,6 +7229,7 @@ INSERT INTO epsg_alias VALUES (7255,'Coordinate_Operation',7894,7301,'St. Helena 1971 to WGS 84 (2)',''), (7256,'Coordinate_Operation',7895,7301,'St. Helena 1971 to SHGD2015 (2)',''), (7257,'Coordinate_Operation',7896,7301,'SHGD2015 to St. Helena 1971 (2)',''), +(7258,'Coordinate_Operation',8064,7301,'PCCS zone 4 (ft)',''), (7259,'Coordinate Reference System',22196,7301,'C Inchauspe /Argentina 6',''), (7260,'Coordinate Reference System',22197,7301,'C Inchauspe /Argentina 7',''), (7261,'Coordinate Reference System',22195,7301,'C Inchauspe /Argentina 5',''), @@ -7233,12 +7239,209 @@ INSERT INTO epsg_alias VALUES (7265,'Coordinate Reference System',22191,7301,'C Inchauspe /Argentina 1',''), (7266,'Coordinate Reference System',2315,7301,'Campo Inchauspe /UTM 19S',''), (7267,'Coordinate Reference System',2316,7301,'Campo Inchauspe /UTM 20S',''), +(7268,'Coordinate Reference System',7992,7302,'Malongo 1987 / UTM 33S',''), (7270,'Coordinate_Operation',7958,7301,'ETRS89 to Belfast Lough height (2)',''), (7271,'Coordinate_Operation',7958,7301,'ETRF89 to Belfast height (2)',''), (7273,'Coordinate_Operation',7959,7301,'ETRF89 to Malin Head height (2)',''), +(7275,'Coordinate_Operation',8061,7302,'PCCS zone 1 (ft)',''), +(7277,'Coordinate_Operation',7995,7302,'BRO2020',''), +(7278,'Coordinate_Operation',7996,7302,'BCG2020',''), +(7279,'Coordinate_Operation',7997,7302,'CARN2020',''), +(7280,'Coordinate Reference System',8042,7302,'S-SC','This abbreviation was used for several systems collectively forming the 19th century cadastre of the Austro-Hungarian empire.'), +(7281,'Coordinate_Operation',7998,7302,'CIG2020',''), +(7282,'Coordinate_Operation',8010,7302,'MRCG2020',''), +(7283,'Coordinate_Operation',8033,7302,'TM Zone 20N (ftUS)',''), +(7284,'Coordinate_Operation',7999,7302,'CKIG2020',''), +(7285,'Coordinate_Operation',7999,7301,'Cocos (Keeling) Island Grid 2020',''), +(7286,'Coordinate_Operation',8011,7302,'PCG2020',''), +(7287,'Coordinate_Operation',8000,7302,'COL2020',''), +(7288,'Coordinate Reference System',8042,7301,'Stable Cadastre','This abbreviation was used for several systems collectively forming the 19th century cadastre of the Austro-Hungarian empire.'), +(7289,'Coordinate_Operation',8001,7302,'ESP2020',''), +(7290,'Coordinate_Operation',8012,7302,'PHG2020',''), +(7291,'Coordinate_Operation',8002,7302,'EXM2020',''), +(7292,'Coordinate_Operation',8034,7302,'TM Zone 21N (ftUS)',''), +(7293,'Coordinate_Operation',8003,7302,'GCG2020',''), +(7294,'Coordinate Reference System',8043,7301,'Stable cadastre','This alias was used for several systems collectively forming the 19th century cadastre of the Austro-Hungarian empire.'), +(7295,'Coordinate_Operation',8004,7302,'GOLD2020',''), +(7296,'Coordinate Reference System',8043,7302,'S-SC','This abbreviation was used for several systems collectively forming the 19th century cadastre of the Austro-Hungarian empire.'), +(7297,'Coordinate_Operation',8005,7302,'JCG2020',''), +(7298,'Coordinate_Operation',8062,7302,'PCCS zone 2 (ft)',''), +(7299,'Coordinate_Operation',8006,7302,'KALB2020',''), +(7301,'Coordinate_Operation',8007,7302,'KAR2020',''), +(7303,'Coordinate_Operation',8008,7302,'KUN2020',''), +(7305,'Coordinate_Operation',8009,7302,'LCG2020',''), +(7306,'Coordinate_Operation',8063,7302,'PCCS zone 3(ft)',''), +(7309,'Coordinate Reference System',8065,7301,'NAD83(2011) / PCCS east zone(ft)',''), +(7313,'Coordinate Reference System',8066,7301,'NAD83(2011) / PCCS central zone(ft)',''), +(7317,'Coordinate Reference System',8067,7301,'NAD83(2011) / PCCS west zone(ft)',''), +(7319,'Coordinate Reference System',8068,7301,'NAD83(2011) / PCCS Mt. Lemmon zone(ft)',''), +(7321,'Datum',1187,7302,'ISN2016',''), +(7322,'Coordinate Reference System',8090,7302,'WISCRS Florence (m)',''), +(7323,'Coordinate_Operation',8087,7302,'Lambert 2016',''), +(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)',''), +(7330,'Coordinate Reference System',8095,7302,'WISCRS Wood (m)',''), +(7331,'Coordinate Reference System',8109,7302,'WISCRS Vilas (m)',''), +(7332,'Coordinate Reference System',8097,7302,'WISCRS Waushara (m)',''), +(7333,'Coordinate Reference System',8105,7302,'WISCRS Washburn (m)',''), +(7334,'Coordinate Reference System',8098,7302,'WISCRS Waushara (ftUS)',''), +(7335,'Coordinate Reference System',8113,7302,'WISCRS Trempealeau (m)',''), +(7336,'Coordinate Reference System',8099,7302,'WISCRS Waupaca (m)',''), +(7337,'Coordinate Reference System',8106,7302,'WISCRS Washburn (ftUS)',''), +(7338,'Coordinate Reference System',8100,7302,'WISCRS Waupaca (ftUS)',''), +(7339,'Coordinate Reference System',8110,7302,'WISCRS Vilas (ftUS)',''), +(7340,'Coordinate Reference System',8101,7302,'WISCRS Waukesha (m)',''), +(7341,'Coordinate Reference System',8107,7302,'WISCRS Walworth (m)',''), +(7342,'Coordinate Reference System',8102,7302,'WISCRS Waukesha (ftUS)',''), +(7343,'Coordinate Reference System',8131,7302,'WISCRS Price (m)',''), +(7344,'Coordinate Reference System',8103,7302,'WISCRS Washington (m)',''), +(7345,'Coordinate Reference System',8108,7302,'WISCRS Walworth (ftUS)',''), +(7346,'Coordinate Reference System',8104,7302,'WISCRS Washington (ftUS)',''), +(7347,'Coordinate Reference System',8111,7302,'WISCRS Vernon (m)',''), +(7348,'Coordinate Reference System',8114,7302,'WISCRS Trempealeau (ftUS)',''), +(7349,'Coordinate Reference System',8112,7302,'WISCRS Vernon (ftUS)',''), +(7350,'Coordinate Reference System',8154,7302,'WISCRS Langlade (ftUS)',''), +(7351,'Coordinate Reference System',8115,7302,'WISCRS Taylor (m)',''), +(7352,'Coordinate Reference System',8132,7302,'WISCRS Price (ftUS)',''), +(7353,'Coordinate Reference System',8116,7302,'WISCRS Taylor (ftUS)',''), +(7354,'Coordinate Reference System',8161,7302,'WISCRS Jackson (m)',''), +(7355,'Coordinate Reference System',8117,7302,'WISCRS St. Croix (m)',''), +(7356,'Coordinate Reference System',8133,7302,'WISCRS Portage (m)',''), +(7357,'Coordinate Reference System',8118,7302,'WISCRS St. Croix (ftUS)',''), +(7358,'Coordinate Reference System',8155,7302,'WISCRS La Crosse (m)',''), +(7359,'Coordinate Reference System',8119,7302,'WISCRS Shawano (m)',''), +(7360,'Coordinate Reference System',8134,7302,'WISCRS Portage (ftUS)',''), +(7361,'Coordinate Reference System',8120,7302,'WISCRS Shawano (ftUS)',''), +(7362,'Coordinate Reference System',8165,7302,'WISCRS Iowa (m)',''), +(7363,'Coordinate Reference System',8121,7302,'WISCRS Sawyer (m)',''), +(7364,'Coordinate Reference System',8135,7302,'WISCRS Polk (m)',''), +(7365,'Coordinate Reference System',8122,7302,'WISCRS Sawyer (ftUS)',''), +(7366,'Coordinate Reference System',8156,7302,'WISCRS La Crosse (ftUS)',''), +(7367,'Coordinate Reference System',8123,7302,'WISCRS Sauk (m)',''), +(7368,'Coordinate Reference System',8136,7302,'WISCRS Polk (ftUS)',''), +(7369,'Coordinate Reference System',8124,7302,'WISCRS Sauk (ftUS)',''), +(7370,'Coordinate Reference System',8162,7302,'WISCRS Jackson (ftUS)',''), +(7371,'Coordinate Reference System',8125,7302,'WISCRS Rusk (m)',''), +(7372,'Coordinate Reference System',8092,7302,'WISCRS Eau Claire (m)',''), +(7373,'Coordinate Reference System',8126,7302,'WISCRS Rusk (ftUS)',''), +(7374,'Coordinate Reference System',8163,7302,'WISCRS Iron (m)',''), +(7375,'Coordinate Reference System',8127,7302,'WISCRS Rock (m)',''), +(7376,'Coordinate Reference System',8137,7302,'WISCRS Pepin-Pierce (m)',''), +(7377,'Coordinate Reference System',8128,7302,'WISCRS Rock (ftUS)',''), +(7378,'Coordinate Reference System',8137,7301,'NAD83(HARN) / WISCRS Pepin (m)',''), +(7379,'Coordinate Reference System',8129,7302,'WISCRS Richland (m)',''), +(7380,'Coordinate Reference System',8137,7301,'NAD83(HARN) / WISCRS Pierce (m)',''), +(7381,'Coordinate Reference System',8130,7302,'WISCRS Richland (ftUS)',''), +(7382,'Coordinate Reference System',8166,7302,'WISCRS Iowa (ftUS)',''), +(7383,'Coordinate Reference System',8157,7302,'WISCRS Kew-Manit-Sheb (m)',''), +(7384,'Coordinate Reference System',8157,7301,'NAD83(HARN) / WISCRS Kewaunee (m)',''), +(7385,'Coordinate Reference System',8138,7302,'WISCRS Pepin-Pierce (ftUS)',''), +(7386,'Coordinate Reference System',8138,7301,'NAD83(HARN) / WISCRS Pepin (ftUS)',''), +(7387,'Coordinate Reference System',8138,7301,'NAD83(HARN) / WISCRS Pierce (ftUS)',''), +(7388,'Coordinate Reference System',8157,7301,'NAD83(HARN) / WISCRS Manitowoc (m)',''), +(7389,'Coordinate Reference System',8139,7302,'WISCRS Oneida (m)',''), +(7390,'Coordinate Reference System',8157,7301,'NAD83(HARN) / WISCRS Sheboygan (m)',''), +(7391,'Coordinate Reference System',8140,7302,'WISCRS Oneida (ftUS)',''), +(7392,'Coordinate Reference System',8164,7302,'WISCRS Iron (ftUS)',''), +(7393,'Coordinate Reference System',8141,7302,'WISCRS Oconto (m)',''), +(7394,'Coordinate Reference System',8170,7302,'WISCRS Green-Lafayette (ftUS)',''), +(7395,'Coordinate Reference System',8142,7302,'WISCRS Oconto (ftUS)',''), +(7396,'Coordinate Reference System',8093,7302,'WISCRS Eau Claire (ftUS)',''), +(7397,'Coordinate Reference System',8143,7302,'WISCRS Monroe (m)',''), +(7398,'Coordinate Reference System',8170,7301,'NAD83(HARN) / WISCRS Green (ftUS)',''), +(7399,'Coordinate Reference System',8144,7302,'WISCRS Monroe (ftUS)',''), +(7400,'Coordinate Reference System',8158,7302,'WISCRS Kew-Manit-Sheb (ftUS)',''), +(7401,'Coordinate Reference System',8145,7302,'WISCRS Menominee (m)',''), +(7402,'Coordinate Reference System',8158,7301,'NAD83(HARN) / WISCRS Kewaunee (ftUS)',''), +(7403,'Coordinate Reference System',8146,7302,'WISCRS Menominee (ftUS)',''), +(7404,'Coordinate Reference System',8158,7301,'NAD83(HARN) / WISCRS Manitowoc (ftUS)',''), +(7405,'Coordinate Reference System',8147,7302,'WISCRS Marinette (m)',''), +(7406,'Coordinate Reference System',8158,7301,'NAD83(HARN) / WISCRS Sheboygan (ftUS)',''), +(7407,'Coordinate Reference System',8148,7302,'WISCRS Marinette (ftUS)',''), +(7408,'Coordinate Reference System',8167,7302,'WISCRS Green Lake-Marquette (m)',''), +(7409,'Coordinate Reference System',8149,7302,'WISCRS Marathon (m)',''), +(7410,'Coordinate Reference System',8167,7301,'NAD83(HARN) / WISCRS Green Lake (m)',''), +(7411,'Coordinate Reference System',8150,7302,'WISCRS Marathon (ftUS)',''), +(7412,'Coordinate Reference System',8167,7301,'NAD83(HARN) / WISCRS Marquette (m)',''), +(7413,'Coordinate Reference System',8151,7302,'WISCRS Lincoln (m)',''), +(7414,'Coordinate Reference System',8179,7302,'WISCRS Dunn (m)',''), +(7415,'Coordinate Reference System',8152,7302,'WISCRS Lincoln (ftUS)',''), +(7416,'Coordinate Reference System',8170,7301,'NAD83(HARN) / WISCRS Lafayette (ftUS)',''), +(7417,'Coordinate Reference System',8153,7302,'WISCRS Langlade (m)',''), +(7418,'Coordinate Reference System',8159,7302,'WISCRS Oz-Milw-Rac-Ken (m)',''), +(7419,'Coordinate Reference System',8159,7301,'NAD83(HARN) / WISCRS Kenosha(m)',''), +(7420,'Coordinate Reference System',8159,7301,'NAD83(HARN) / WISCRS Milwaukee (m)',''), +(7421,'Coordinate Reference System',8159,7301,'NAD83(HARN) / WISCRS Ozaukee (m)',''), +(7422,'Coordinate Reference System',8159,7301,'NAD83(HARN) / WISCRS Racine (m)',''), +(7423,'Coordinate Reference System',8180,7302,'WISCRS Dunn (ftUS)',''), +(7424,'Coordinate Reference System',8168,7302,'WISCRS GreenLake-Marqt (ftUS)',''), +(7425,'Coordinate Reference System',8168,7301,'NAD83(HARN) / WISCRS Green Lake (ftUS)',''), +(7426,'Coordinate Reference System',8168,7301,'NAD83(HARN) / WISCRS Marquette (ftUS)',''), +(7428,'Coordinate Reference System',8160,7302,'WISCRS Oz-Milw-Rac-Ken (ftUS)',''), +(7429,'Coordinate Reference System',8160,7301,'NAD83(HARN) / WISCRS Kenosha (ftUS)',''), +(7430,'Coordinate Reference System',8160,7301,'NAD83(HARN) / WISCRS Milwaukee (ftUS)',''), (7431,'Coordinate_Operation',1068,1026,'Guam 1963 to Guam Geodetic Network 1993 (1)',''), +(7432,'Coordinate Reference System',8160,7301,'NAD83(HARN) / WISCRS Ozaukee (ftUS)',''), +(7433,'Coordinate Reference System',8160,7301,'NAD83(HARN) / WISCRS Racine (ftUS)',''), +(7434,'Coordinate Reference System',8181,7302,'WISCRS Douglas (m)',''), +(7435,'Coordinate Reference System',8200,7302,'WISCRS Columbia (ftUS)',''), +(7436,'Coordinate Reference System',8169,7302,'WISCRS Green-Lafayette (m)',''), +(7437,'Coordinate Reference System',8169,7301,'NAD83(HARN) / WISCRS Green (m)',''), +(7438,'Coordinate Reference System',8169,7301,'NAD83(HARN) / WISCRS Lafayette (m)',''), +(7439,'Coordinate Reference System',8182,7302,'WISCRS Douglas (ftUS)',''), +(7441,'Coordinate Reference System',8203,7302,'WISCRS Chippewa (m)',''), (7442,'Coordinate Reference System',4152,1026,'Guam Geodetic Network 1993','This alias is used only in Guam, where NAD83(HARN) is realised through GGN93.'), +(7443,'Coordinate Reference System',8171,7302,'WISCRS Grant (m)',''), +(7444,'Coordinate Reference System',8184,7302,'WISCRS Door (m)',''), +(7445,'Coordinate Reference System',8172,7302,'WISCRS Grant (ftUS)',''), +(7447,'Coordinate Reference System',8173,7302,'WISCRS Forest (m)',''), (7448,'Coordinate Reference System',4152,1026,'GGN93','This abbreviation is used only in Guam, where NAD83(HARN) is realised through GGN93.'), +(7449,'Coordinate Reference System',8185,7302,'WISCRS Door (ftUS)',''), +(7450,'Coordinate Reference System',8177,7302,'WISCRS Forest (ftUS)',''), +(7451,'Coordinate Reference System',8204,7302,'WISCRS Chippewa (ftUS)',''), +(7454,'Coordinate Reference System',8187,7302,'WISCRS Dodge-Jefferson (m)',''), +(7455,'Coordinate Reference System',8187,7301,'NAD83(HARN) / WISCRS Dodge (m)',''), +(7456,'Coordinate Reference System',8187,7301,'NAD83(HARN) / WISCRS Jefferson (m)',''), +(7460,'Coordinate Reference System',8189,7302,'WISCRS Dodge-Jefferson (ftUS)',''), +(7461,'Coordinate Reference System',8189,7301,'NAD83(HARN) / WISCRS Dodge (ftUS)',''), +(7462,'Coordinate Reference System',8189,7301,'NAD83(HARN) / WISCRS Jefferson (ftUS)',''), +(7463,'Coordinate Reference System',8205,7302,'WISCRS Out-Cal-Win-FdL (m)',''), +(7464,'Coordinate Reference System',8191,7302,'WISCRS Dane (m)',''), +(7465,'Coordinate Reference System',8205,7301,'NAD83(HARN) / WISCRS Calumet (m)',''), +(7466,'Coordinate Reference System',8193,7302,'WISCRS Dane (ftUS)',''), +(7467,'Coordinate Reference System',8205,7301,'NAD83(HARN) / WISCRS Fond du Lac (m)',''), +(7468,'Coordinate Reference System',8196,7302,'WISCRS Crawford (m)',''), +(7469,'Coordinate Reference System',8205,7301,'NAD83(HARN) / WISCRS Outagamie (m)',''), +(7470,'Coordinate Reference System',8197,7302,'WISCRS Crawford (ftUS)',''), +(7471,'Coordinate Reference System',8205,7301,'NAD83(HARN) / WISCRS Winnebago (m)',''), +(7472,'Coordinate Reference System',8198,7302,'WISCRS Columbia (m)',''), +(7476,'Coordinate Reference System',8201,7302,'WISCRS Clark (m)',''), +(7478,'Coordinate Reference System',8202,7302,'WISCRS Clark (ftUS)',''), +(7480,'Coordinate Reference System',8206,7302,'WISCRS Out-Cal-Win-FdL (ftUS)',''), +(7481,'Coordinate Reference System',8206,7301,'NAD83(HARN) / WISCRS Calumet (ftUS)',''), +(7482,'Coordinate Reference System',8206,7301,'NAD83(HARN) / WISCRS Fond du Lac (ftUS)',''), +(7483,'Coordinate Reference System',8206,7301,'NAD83(HARN) / WISCRS Outagamie (ftUS)',''), +(7484,'Coordinate Reference System',8206,7301,'NAD83(HARN) / WISCRS Winnebago (ftUS)',''), +(7486,'Coordinate Reference System',8207,7302,'WISCRS Burnett (m)',''), +(7488,'Coordinate Reference System',8208,7302,'WISCRS Burnett (ftUS)',''), +(7490,'Coordinate Reference System',8209,7302,'WISCRS Buffalo (m)',''), +(7492,'Coordinate Reference System',8210,7302,'WISCRS Buffalo (ftUS)',''), +(7494,'Coordinate Reference System',8212,7302,'WISCRS Brown (m)',''), +(7496,'Coordinate Reference System',8213,7302,'WISCRS Brown (ftUS)',''), +(7498,'Coordinate Reference System',8214,7302,'WISCRS Bayfield (m)',''), +(7500,'Coordinate Reference System',8216,7302,'WISCRS Bayfield (ftUS)',''), +(7502,'Coordinate Reference System',8218,7302,'WISCRS Barron (m)',''), +(7504,'Coordinate Reference System',8220,7302,'WISCRS Barron (ftUS)',''), +(7506,'Coordinate Reference System',8222,7302,'WISCRS Ashland (m)',''), +(7508,'Coordinate Reference System',8224,7302,'WISCRS Ashland (ftUS)',''), +(7512,'Coordinate Reference System',8225,7302,'WISCRS Adams-Juneau (m)',''), +(7513,'Coordinate Reference System',8225,7301,'NAD83(HARN) / WISCRS Adams (m)',''), +(7514,'Coordinate Reference System',8225,7301,'NAD83(HARN) / WISCRS Juneau (m)',''), +(7518,'Coordinate Reference System',8226,7302,'WISCRS Adams-Juneau (ftUS)',''), +(7519,'Coordinate Reference System',8226,7301,'NAD83(HARN) / WISCRS Adams (ftUS)',''), +(7520,'Coordinate Reference System',8226,7301,'NAD83(HARN) / WISCRS Juneau (ftUS)',''), (7528,'Datum',6152,1026,'Guam Geodetic Network 1993','This alias is used only in Guam, where NAD83(HARN) is realised through GGN93.'), (7530,'Coordinate Reference System',4957,1026,'Guam Geodetic Network 1993','This alias is used only in Guam, where NAD83(HARN) is realised through GGN93.'), (7531,'Coordinate Reference System',4957,1026,'GGN93','This abbreviation is used only in Guam, where NAD83(HARN) is realised through GGN93.'), @@ -9498,14 +9701,14 @@ INSERT INTO epsg_area VALUES (1038,'Azerbaijan','Azerbaijan - onshore and offshore.',37.89,42.59,44.77,51.73,'urn:ogc:def:extent-polygon:EPSG::1038','AZ','AZE',31,'','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), (1039,'Bahamas','Bahamas - onshore and offshore.',20.36,30.36,-81.22,-70.63,'urn:ogc:def:extent-polygon:EPSG::1039','BS','BHS',44,'','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), (1040,'Bahrain','Bahrain - onshore and offshore.',25.53,27.17,50.26,51.13,'urn:ogc:def:extent-polygon:EPSG::1040','BH','BHR',48,'','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), -(1041,'Bangladesh','Bangladesh - onshore and offshore.',18.56,26.63,88.04,92.67,'urn:ogc:def:extent-polygon:EPSG::1041','BD','BGD',50,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.040 2012.062 2014.025',false), +(1041,'Bangladesh','Bangladesh - onshore and offshore.',18.56,26.64,88.01,92.67,'urn:ogc:def:extent-polygon:EPSG::1041','BD','BGD',50,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2017-03-19','2002.341 2005.890 2012.040 2012.062 2014.025 2017.008',false), (1042,'Barbados','Barbados - onshore and offshore.',10.68,16,-60.39,-55.99,'urn:ogc:def:extent-polygon:EPSG::1042','BB','BRB',52,'','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), (1043,'Belarus','Belarus.',51.25,56.17,23.16,32.75,'urn:ogc:def:extent-polygon:EPSG::1043','BY','BLR',112,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2011.095 2014.025',false), (1044,'Belgium','Belgium - onshore and offshore.',49.5,51.88,2.23,6.4,'urn:ogc:def:extent-polygon:EPSG::1044','BE','BEL',56,'','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), (1045,'Belize','Belize - onshore and offshore.',15.88,18.49,-89.22,-86.11,'urn:ogc:def:extent-polygon:EPSG::1045','BZ','BLZ',84,'','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), (1046,'Benin','Benin - onshore and offshore.',2.99,12.4,0.77,3.86,'urn:ogc:def:extent-polygon:EPSG::1046','BJ','BEN',204,'','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), (1047,'Bermuda','Bermuda - onshore and offshore.',28.91,35.73,-68.83,-60.7,'urn:ogc:def:extent-polygon:EPSG::1047','BM','BMU',60,'','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), -(1048,'Bhutan','Bhutan.',26.7,28.33,88.75,92.12,'urn:ogc:def:extent-polygon:EPSG::1048','BT','BTN',64,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2010.086 2012.060 2014.025',false), +(1048,'Bhutan','Bhutan.',26.7,28.33,88.74,92.13,'urn:ogc:def:extent-polygon:EPSG::1048','BT','BTN',64,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2017-03-19','2002.341 2010.086 2012.060 2014.025 2017.008',false), (1049,'Bolivia','Bolivia.',-22.91,-9.67,-69.66,-57.52,'urn:ogc:def:extent-polygon:EPSG::1049','BO','BOL',68,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2011.037 2014.025',false), (1050,'Bosnia and Herzegovina','Bosnia and Herzegovina.',42.56,45.27,15.74,19.62,'urn:ogc:def:extent-polygon:EPSG::1050','BA','BIH',70,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2008.045 2008.053 2008.054 2011.095 2014.025',false), (1051,'Botswana','Botswana.',-26.88,-17.78,19.99,29.38,'urn:ogc:def:extent-polygon:EPSG::1051','BW','BWA',72,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2014.025',false), @@ -9524,9 +9727,9 @@ INSERT INTO epsg_area VALUES (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), (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','OGP','2014-05-01','2002.341 2005.890 2012.050 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), -(1069,'Cocos (Keeling) Islands - onshore','Cocos (Keeling) Islands - onshore.',-12.25,-12.08,96.76,96.92,'urn:ogc:def:extent-polygon:EPSG::1069','','',Null,'','OGP','OGP','2014-05-01','2002.341 2005.890 2012.007 2012.027 2014.025',false), +(1069,'Cocos (Keeling) Islands - onshore','Cocos (Keeling) Islands - onshore.',-12.27,-11.76,96.76,96.99,'urn:ogc:def:extent-polygon:EPSG::1069','','',Null,'','OGP','IOGP','2017-03-19','2002.341 2005.890 2012.007 2012.027 2014.025 2017.004',false), (1070,'Colombia','Colombia - onshore and offshore. Includes San Andres y Providencia, Malpelo Islands, Roncador Bank, Serrana Bank and Serranilla Bank.',-4.23,15.51,-84.77,-66.87,'urn:ogc:def:extent-polygon:EPSG::1070','CO','COL',170,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.037 2012.044 2014.025',false), (1071,'Comoros','Comoros - onshore and offshore. Includes Anjouan, Grande Comore, Moheli and other islands.',-14.43,-8.01,41.93,45.79,'urn:ogc:def:extent-polygon:EPSG::1071','KM','COM',174,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.048 2014.025',false), (1072,'Congo','Congo - onshore and offshore.',-6.91,3.72,8.84,18.65,'urn:ogc:def:extent-polygon:EPSG::1072','CG','COG',178,'','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), @@ -9578,7 +9781,7 @@ INSERT INTO epsg_area VALUES (1118,'China - Hong Kong','China - Hong Kong - onshore and offshore.',22.13,22.58,113.76,114.51,'urn:ogc:def:extent-polygon:EPSG::1118','HK','HKG',344,'"Hong Kong" in ISO 3166.','OGP','OGP','2014-05-01','2002.160 2005.890 2012.057 2014.025',false), (1119,'Hungary','Hungary.',45.74,48.58,16.11,22.9,'urn:ogc:def:extent-polygon:EPSG::1119','HU','HUN',348,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2011.095 2014.025',false), (1120,'Iceland','Iceland - onshore and offshore.',59.96,69.59,-30.87,-5.55,'urn:ogc:def:extent-polygon:EPSG::1120','IS','ISL',352,'','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), -(1121,'India','India - onshore and offshore. Includes Amandivis, Laccadives, Minicoy, Andaman Islands, Nicobar Islands, and Sikkim.',3.87,35.51,65.6,97.39,'urn:ogc:def:extent-polygon:EPSG::1121','IN','IND',356,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.041 2014.025',false), +(1121,'India','India - onshore and offshore. Includes Amandivis, Laccadives, Minicoy, Andaman Islands, Nicobar Islands, and Sikkim.',3.87,35.51,65.6,97.42,'urn:ogc:def:extent-polygon:EPSG::1121','IN','IND',356,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2017-03-19','2002.341 2005.890 2012.041 2014.025 2017.008',false), (1122,'Indonesia','Indonesia - onshore and offshore.',-13.95,7.79,92.01,141.46,'urn:ogc:def:extent-polygon:EPSG::1122','ID','IDN',360,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2016-12-15','2002.341 2005.890 2012.040 2014.025 2016.054',false), (1123,'Iran','Iran - onshore and offshore.',23.34,39.78,44.03,63.34,'urn:ogc:def:extent-polygon:EPSG::1123','IR','IRN',364,'','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), (1124,'Iraq','Iraq - onshore and offshore.',29.06,37.39,38.79,48.75,'urn:ogc:def:extent-polygon:EPSG::1124','IQ','IRQ',368,'','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), @@ -9625,10 +9828,10 @@ INSERT INTO epsg_area VALUES (1165,'Montserrat','Montserrat - onshore and offshore.',15.84,17.04,-63.05,-61.82,'urn:ogc:def:extent-polygon:EPSG::1165','MS','MSR',500,'','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), (1166,'Morocco','Morocco - onshore and offshore.',27.66,36,-13.86,-1.01,'urn:ogc:def:extent-polygon:EPSG::1166','MA','MAR',504,'','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), (1167,'Mozambique','Mozambique - onshore and offshore.',-27.71,-10.09,30.21,43.03,'urn:ogc:def:extent-polygon:EPSG::1167','MZ','MOZ',508,'','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), -(1168,'Myanmar (Burma)','Myanmar (Burma) - onshore and offshore.',9.48,28.55,89.61,101.17,'urn:ogc:def:extent-polygon:EPSG::1168','MM','MMR',104,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/isoISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.040 2014.025',false), +(1168,'Myanmar (Burma)','Myanmar (Burma) - onshore and offshore.',9.48,28.55,89.61,101.17,'urn:ogc:def:extent-polygon:EPSG::1168','MM','MMR',104,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/isoISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2017-03-19','2002.341 2005.890 2012.040 2014.025 2017.008',false), (1169,'Namibia','Namibia - onshore and offshore.',-30.64,-16.95,8.24,25.27,'urn:ogc:def:extent-polygon:EPSG::1169','NA','NAM',516,'','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), (1170,'Nauru','Nauru - onshore and offshore.',-3.91,2.69,163.58,168.6,'urn:ogc:def:extent-polygon:EPSG::1170','NR','NRU',520,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.048 2014.025',false), -(1171,'Nepal','Nepal.',26.36,30.43,80.05,88.2,'urn:ogc:def:extent-polygon:EPSG::1171','NP','NPL',524,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2012.050 2014.025',false), +(1171,'Nepal','Nepal.',26.34,30.43,80.06,88.21,'urn:ogc:def:extent-polygon:EPSG::1171','NP','NPL',524,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2017-03-19','2002.341 2012.050 2014.025 2017.008',false), (1172,'Netherlands','Netherlands - onshore and offshore.',50.75,55.77,2.53,7.22,'urn:ogc:def:extent-polygon:EPSG::1172','NL','NLD',528,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.082 2014.025',false), (1173,'Netherlands Antilles','Netherlands Antilles - onshore and offshore. Includes Bonaire, Curacao, Saba, St Eustatius, and southern St Martin',11.67,18.07,-69.59,-62.82,'','AN','ANT',530,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2006-02-01','2002.341 2005.890 2011.015',true), (1174,'New Caledonia','New Caledonia - onshore and offshore. Isle de Pins, Loyalty Islands, Huon Islands, Belep archipelago, Chesterfield Islands, and Walpole.',-26.45,-14.83,156.25,174.28,'urn:ogc:def:extent-polygon:EPSG::1174','NC','NCL',540,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2016-12-15','2002.341 2005.890 2012.048 2014.025 2016.054',false), @@ -9641,7 +9844,7 @@ INSERT INTO epsg_area VALUES (1181,'Northern Mariana Islands','Northern Mariana Islands - onshore and offshore.',12.38,23.9,141.33,149.55,'urn:ogc:def:extent-polygon:EPSG::1181','MP','MNP',580,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.048 2014.025',false), (1182,'Norway','Norway including Svalbard - onshore and offshore.',56.08,84.17,-3.7,39.65,'urn:ogc:def:extent-polygon:EPSG::1182','NO','NOR',578,'','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), (1183,'Oman','Oman - onshore and offshore.',14.33,26.74,51.99,63.38,'urn:ogc:def:extent-polygon:EPSG::1183','OM','OMN',512,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2011.042 2012.051 2014.025',false), -(1184,'Pakistan','Pakistan - onshore and offshore.',21.05,37.07,60.86,77.83,'urn:ogc:def:extent-polygon:EPSG::1184','PK','PAK',586,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.040 2014.025',false), +(1184,'Pakistan','Pakistan - onshore and offshore.',21.05,37.07,60.86,77.83,'urn:ogc:def:extent-polygon:EPSG::1184','PK','PAK',586,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2017-03-19','2002.341 2005.890 2012.040 2014.025 2017.008',false), (1185,'Palau','Palau - onshore and offshore.',1.64,11.45,129.48,136.98,'urn:ogc:def:extent-polygon:EPSG::1185','PW','PLW',585,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','OGP','2014-05-01','2002.341 2005.890 2012.048 2014.025',false), (1186,'Panama','Panama - onshore and offshore.',5,12.51,-84.32,-77.04,'urn:ogc:def:extent-polygon:EPSG::1186','PA','PAN',591,'','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), (1187,'Papua New Guinea','Papua New Guinea - onshore and offshore. Includes Bismark archipelago, Louisade archipelago, Admiralty Islands, d''Entrecasteaux Islands, northern Solomon Islands, Trobriand Islands, New Britain, New Ireland, Woodlark, and associated islands.',-14.75,2.58,139.2,162.81,'urn:ogc:def:extent-polygon:EPSG::1187','PG','PNG',598,'','ISO 3166 Maintenance Agency. ftp://ftp.fu-berlin.de/pub/doc/iso','IOGP','2016-12-15','2002.341 2005.890 2011.059 2012.027 2014.025 2016.054',false), @@ -9761,11 +9964,11 @@ INSERT INTO epsg_area VALUES (1301,'Portugal - Azores C - onshore','Portugal - central Azores onshore - Faial, Graciosa, Pico, Sao Jorge, Terceira.',38.32,39.14,-28.9,-26.97,'urn:ogc:def:extent-polygon:EPSG::1301','','',Null,'Superset of areas 2872, 2873, 2874, 2875 and 3681.','OGP','OGP','2012-01-05','2010.006 2011.062 2011.113',false), (1302,'Asia - Cambodia and Vietnam - mainland','Cambodia - mainland onshore; Vietnam - mainland onshore.',8.5,23.33,102.14,109.52,'urn:ogc:def:extent-polygon:EPSG::1302','','',Null,'','OGP','OGP','2014-05-01','2012.046 2014.024',false), (1303,'South America - Tierra del Fuego','Argentina and Chile - Tierra del Fuego, onshore.',-55.96,-51.99,-74.83,-65.05,'urn:ogc:def:extent-polygon:EPSG::1303','','',Null,'','OGP','OGP','2014-11-19','2011.037 2014.024 2014.082',false), -(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','OGP','2011-01-25','2011.004',false), +(1304,'Asia - Myanmar and Thailand onshore','Myanmar (Burma) - onshore; Thailand - onshore.',5.63,28.55,92.2,105.64,'urn:ogc:def:extent-polygon:EPSG::1304','','',Null,'','OGP','IOGP','2017-03-19','2011.004 2017.008',false), (1305,'Europe - Ireland (Republic and Ulster) - onshore','Ireland - onshore. United Kingdom (UK) - Northern Ireland (Ulster) - onshore.',51.39,55.43,-10.56,-5.34,'urn:ogc:def:extent-polygon:EPSG::1305','','',Null,'','OGP','OGP','2014-05-01','2011.082 2014.024',false), (1306,'Europe - Czechoslovakia','Czech Republic; Slovakia.',47.73,51.06,12.09,22.56,'urn:ogc:def:extent-polygon:EPSG::1306','','',Null,'','OGP','OGP','2014-05-01','2014.024',false), -(1307,'Asia - Bangladesh; India; Myanmar; Pakistan - onshore','Bangladesh - onshore; India - mainland onshore; Myanmar (Burma) - onshore; Pakistan - onshore.',8.02,37.07,60.86,101.17,'urn:ogc:def:extent-polygon:EPSG::1307','','',Null,'','OGP','OGP','2014-05-01','2004.290 2012.041 2014.024',false), -(1308,'Asia - Bangladesh; India; Pakistan - onshore','Bangladesh - onshore; India - mainland onshore; Pakistan - onshore.',8.02,37.07,60.86,97.39,'urn:ogc:def:extent-polygon:EPSG::1308','','',Null,'','OGP','OGP','2014-05-01','2012.041 2014.024',false), +(1307,'Asia - Bangladesh; India; Myanmar; Pakistan - onshore','Bangladesh - onshore; India - mainland onshore; Myanmar (Burma) - onshore; Pakistan - onshore.',8.02,37.07,60.86,101.17,'urn:ogc:def:extent-polygon:EPSG::1307','','',Null,'','OGP','IOGP','2017-03-19','2004.290 2012.041 2014.024 2017.008',false), +(1308,'Asia - Bangladesh; India; Pakistan - onshore','Bangladesh - onshore; India - mainland onshore; Pakistan - onshore.',8.02,37.07,60.86,97.42,'urn:ogc:def:extent-polygon:EPSG::1308','','',Null,'','OGP','IOGP','2017-03-19','2012.041 2014.024 2017.008',false), (1309,'Asia - Malaysia (west) and Singapore','Malaysia - West Malaysia; Singapore.',1.13,6.72,99.59,104.6,'urn:ogc:def:extent-polygon:EPSG::1309','','',Null,'','OGP','OGP','2014-05-01','2012.040 2014.024',false), (1310,'Kuwait - Kuwait City','Kuwait - Kuwait City.',29.17,29.45,47.78,48.16,'urn:ogc:def:extent-polygon:EPSG::1310','','',Null,'','OGP','OGP','2014-05-01','2012.051 2014.024',false), (1311,'Venezuela - Cabimas','Venezuela - Cabimas area.',10.14,10.61,-71.55,-71.29,'urn:ogc:def:extent-polygon:EPSG::1311','','',Null,'','OGP','OGP','2014-05-01','2011.004 2014.024',false), @@ -9779,7 +9982,7 @@ INSERT INTO epsg_area VALUES (1319,'Venezuela - Maracaibo area','Venezuela - Maracaibo area, onshore and offshore in lake.',10,11,-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), -(1322,'Trinidad and Tobago - Tobago - onshore','Trinidad and Tobago - Tobago - onshore.',11.09,11.4,-60.9,-60.47,'urn:ogc:def:extent-polygon:EPSG::1322','','',Null,'','OGP','OGP','2014-05-01','2009.106 2011.037 2014.024',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), (1325,'North America - Canada and USA (CONUS, Alaska mainland)','North America - onshore and offshore: Canada - Alberta; British Columbia; Manitoba; New Brunswick; Newfoundland and Labrador; Northwest Territories; Nova Scotia; Nunavut; Ontario; Prince Edward Island; Quebec; Saskatchewan; Yukon. United States (USA) - Alabama; Alaska (mainland); 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.',23.81,86.46,-172.54,-47.74,'urn:ogc:def:extent-polygon:EPSG::1325','','',Null,'','OGP','OGP','2014-05-01','2006.462 2006.463 2007.028 2009.108 2011.043 2 014.024',false), @@ -9806,7 +10009,7 @@ INSERT INTO epsg_area VALUES (1346,'Qatar - onshore','Qatar - onshore.',24.55,26.2,50.69,51.68,'urn:ogc:def:extent-polygon:EPSG::1346','','',Null,'','OGP','OGP','2014-05-01','2012.051 2014.024',false), (1347,'Belgium - onshore','Belgium - onshore.',49.5,51.51,2.5,6.4,'urn:ogc:def:extent-polygon:EPSG::1347','','',Null,'','OGP','OGP','2014-05-01','2011.095 2014.024',false), (1348,'South America - PSAD56 by country','Aruba - onshore; Bolivia; Bonaire - onshore; Brazil - offshore - Amazon Cone shelf; Chile - onshore north of 43°30''S; Curacao - onshore; Ecuador - mainland onshore; Guyana - onshore; Peru - onshore; Venezuela - onshore.',-43.5,12.68,-81.41,-47.99,'urn:ogc:def:extent-polygon:EPSG::1348','','',Null,'','OGP','OGP','2014-11-21','2005.144 2006.480 2010.097 2011.037 2012.044 2014.024 2014.082 2014.083',false), -(1349,'North America - NAD27','North and central America: Antigua and Barbuda. Bahamas. Belize. British Virgin Islands. Canada - Alberta; British Columbia; Manitoba; New Brunswick; Newfoundland and Labrador; Northwest Territories; Nova Scotia; Nunavut; Ontario; Prince Edward Island; Quebec; Saskatchewan; Yukon. Cuba. El Salvador. Guatemala. Honduras. Puerto Rico. Mexico. Nicaragua. United States (USA) - 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. Usage shall be onshore only except that onshore and off shore shall apply to Canada east coast (New Brunswick; Newfoundland and Labrador; Prince Edward Island; Quebec). Cuba. Mexico (Gulf of Mexico and Caribbean coasts only). USA Alaska. USA Gulf of Mexico (Alabama; Florida; Louisiana; Mississippi; Texas). USA East Coast. Bahamas onshore plus offshore over internal continental shelf only.',7.98,83.17,167.65,-47.74,'urn:ogc:def:extent-polygon:EPSG::1349','','',Null,'Area crosses 180-degree meridian.','OGP','OGP','2014-05-01','2006.463 2007.028 2009.063 2010.088 2011.043 2014.024',false), +(1349,'North America - NAD27','North and central America: Antigua and Barbuda - onshore. Bahamas - onshore plus offshore over internal continental shelf only. Belize - onshore. British Virgin Islands - onshore. Canada onshore - Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland and Labrador, Northwest Territories, Nova Scotia, Nunavut, Ontario, Prince Edward Island, Quebec, Saskatchewan and Yukon - plus offshore east coast. Cuba - onshore and offshore. El Salvador - onshore. Guatemala - onshore. Honduras - onshore. Puerto Rico - onshore. Mexico - onshore plus offshore east coast. Nicaragua - onshore. United States (USA) onshore and offshore - Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, Nort h Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin and Wyoming - plus offshore . US Virgin Islands - onshore.',7.98,83.17,167.65,-47.74,'urn:ogc:def:extent-polygon:EPSG::1349','','',Null,'Area crosses 180-degree meridian.','OGP','IOGP','2017-03-19','2006.463 2007.028 2009.063 2010.088 2011.043 2014.024 2017.008',false), (1350,'North America - NAD83','North America - onshore and offshore: Canada - Alberta; British Columbia; Manitoba; New Brunswick; Newfoundland and Labrador; Northwest Territories; Nova Scotia; Nunavut; Ontario; Prince Edward Island; Quebec; Saskatchewan; Yukon. Puerto Rico. United States (USA) - Alabama; Alaska; Arizona; Arkansas; California; Colorado; Connecticut; Delaware; Florida; Georgia; Hawaii; Idaho; Illinois; Indiana; Iowa; Kansas; Kentucky; Louisiana; Maine; Maryland; Massachusetts; Michigan; Minnesota; Mississippi; Missouri; Montana; Nebraska; Nevada; New Hampshire; New Jersey; New Mexico; New York; North Carolina; North Dakota; Ohio; Oklahoma; Oregon; Pennsylvania; Rhode Island; South Carolina; South Dakota; Tennessee; Texas; Utah; Vermont; Virginia; Washington; West Virginia; Wisconsin; Wyoming. US Virgin Islands. British Virgin Islands.',14.92,86.46,167.65,-47.74,'urn:ogc:def:extent-polygon:EPSG::1350','','',Null,'Area crosses 180-degree meridian.','OGP','OGP','2014-05 -01','2006.462 2006.463 2006.464 2007.028 2009.064 2011.043 2014.024',false), (1351,'Asia - Middle East - Qatar offshore and UAE','Arabian Gulf; Qatar - offshore; United Arab Emirates (UAE) - Abu Dhabi; Dubai; Sharjah; Ajman; Fujairah; Ras Al Kaimah; Umm Al Qaiwain - onshore and offshore.',22.63,27.05,50.55,57.13,'urn:ogc:def:extent-polygon:EPSG::1351','','',Null,'Adjustment included Gulf coast area of Saudi Arabia but geodetic entities not in use there.','OGP','OGP','2015-02-12','2006.340 2012.004 2012.051 2014.024 2014.070',false), (1352,'Norway - onshore','Norway - onshore.',57.93,71.21,4.68,31.22,'urn:ogc:def:extent-polygon:EPSG::1352','','',Null,'','OGP','OGP','2014-05-01','2009.105 2011.112 2014.024',false), @@ -10044,11 +10247,11 @@ INSERT INTO epsg_area VALUES (1584,'Indonesia - Java and Java Sea - west of 108°E','Indonesia - onshore Java and offshore southern Java Sea west of 108°E.',-7.79,-4.07,105.06,108,'urn:ogc:def:extent-polygon:EPSG::1584','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.032 2012.040 2014.023',false), (1585,'Indonesia - Java and Java Sea - east of 114°E','Indonesia - onshore Java and Bali, offshore southern Java Sea, Madura Strait and western Bali Sea - east of 114°E.',-8.91,-5.33,114,117.01,'urn:ogc:def:extent-polygon:EPSG::1585','','',Null,'Subset of area 3666.','OGP','OGP','2014-05-01','2008.045 2012.032 2012.040 2014.023',false), (1586,'Indonesia - Java and Java Sea - 108°E to 114°E','Indonesia - onshore Java and Madura and offshore southern Java Sea and Madura Strait - between 108°E and 114°E.',-8.67,-4.27,108,114,'urn:ogc:def:extent-polygon:EPSG::1586','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.032 2012.040 2014.023',false), -(1587,'China - west of 78°E','China - west of 78°E.',35.43,41.07,73.62,78,'urn:ogc:def:extent-polygon:EPSG::1587','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.023',false), -(1588,'China - 78°E to 84°E','China - between 78°E and 84°E.',29.16,47.23,78,84,'urn:ogc:def:extent-polygon:EPSG::1588','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.023',false), -(1589,'China - 84°E to 90°E','China - between 84°E and 90°E.',27.32,49.18,84,90,'urn:ogc:def:extent-polygon:EPSG::1589','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.023',false), -(1590,'China - 90°E to 96°E','China - between 90°E and 96°E.',27.72,47.9,90,96,'urn:ogc:def:extent-polygon:EPSG::1590','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.023',false), -(1591,'China - 96°E to 102°E','China - between 96°E and 102°E.',21.13,43.18,96,102,'urn:ogc:def:extent-polygon:EPSG::1591','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.023',false), +(1587,'China - west of 78°E','China - west of 78°E.',35.42,41.07,73.62,78.01,'urn:ogc:def:extent-polygon:EPSG::1587','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.023 2017.008',false), +(1588,'China - 78°E to 84°E','China - between 78°E and 84°E.',29.16,47.23,77.98,84,'urn:ogc:def:extent-polygon:EPSG::1588','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.023 2017.008',false), +(1589,'China - 84°E to 90°E','China - between 84°E and 90°E.',27.32,49.18,84,90,'urn:ogc:def:extent-polygon:EPSG::1589','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.023 2017.008',false), +(1590,'China - 90°E to 96°E','China - between 90°E and 96°E.',27.71,47.9,90,96.01,'urn:ogc:def:extent-polygon:EPSG::1590','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.023 2017.008',false), +(1591,'China - 96°E to 102°E','China - between 96°E and 102°E.',21.13,43.18,96,102.01,'urn:ogc:def:extent-polygon:EPSG::1591','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.023 2017.008',false), (1592,'China - 102°E to 108°E onshore','China - onshore between 102°E and 108°E.',21.53,42.47,102,108,'urn:ogc:def:extent-polygon:EPSG::1592','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.103 2014.023',false), (1593,'China - 108°E to 114°E onshore','China - onshore between 108°E and 114°E.',18.11,45.11,108,114,'urn:ogc:def:extent-polygon:EPSG::1593','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.103 2012.050 2014.023',false), (1594,'China - 114°E to 120°E onshore','China - onshore between 114°E and 120°E.',22.14,51.52,114,120,'urn:ogc:def:extent-polygon:EPSG::1594','','',Null,'','OGP','OGP','2012-04-18','2008.045 2011.103 2012.050',false), @@ -10121,32 +10324,32 @@ INSERT INTO epsg_area VALUES (1661,'Indonesia - 132°E to 138°E, N hemisphere','Indonesia - north of equator and east of 132°E.',Null,Null,Null,Null,'','','',Null,'','OGP','OGP','2008-06-23','2008.045',true), (1662,'Indonesia - 132°E to 138°E, S hemisphere','Indonesia - south of equator and between 132°E and 138°E - onshore and offshore.',-10.06,0,132,138.01,'urn:ogc:def:extent-polygon:EPSG::1662','','',Null,'','OGP','IOGP','2016-12-15','2008.045 2011.006 2012.040 2016.054',false), (1663,'Indonesia - east of 138°E, S hemisphere','Indonesia - south of equator and east of 138°E - onshore and offshore.',-10.84,0,138,141.46,'urn:ogc:def:extent-polygon:EPSG::1663','','',Null,'','OGP','IOGP','2016-12-15','2007.053 2008.045 2011.006 2012.032 2012.040 2014.022 2016.054',false), -(1664,'Myanmar (Burma) - onshore west of 96°E','Myanmar (Burma) - onshore west of 96°E.',15.66,27.15,92.2,96.01,'urn:ogc:def:extent-polygon:EPSG::1664','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.040 2014.022',false), -(1665,'Asia - Myanmar and Thailand - 96°E to 102°E','Myanmar (Burma) - onshore east of 96°E; Thailand - onshore west of 102°E.',5.63,28.55,96,102.01,'urn:ogc:def:extent-polygon:EPSG::1665','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.004 2014.022',false), +(1664,'Myanmar (Burma) - onshore west of 96°E','Myanmar (Burma) - onshore west of 96°E.',15.66,27.14,92.2,96.01,'urn:ogc:def:extent-polygon:EPSG::1664','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.040 2014.022 2017.008',false), +(1665,'Asia - Myanmar and Thailand - 96°E to 102°E','Myanmar (Burma) - onshore east of 96°E; Thailand - onshore west of 102°E.',5.63,28.55,95.99,102.01,'urn:ogc:def:extent-polygon:EPSG::1665','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2011.004 2014.022 2017.008',false), (1666,'Thailand - east of 102°E','Thailand - onshore and offshore east of 102°E.',6.02,18.44,102,105.64,'urn:ogc:def:extent-polygon:EPSG::1666','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.004 2012.032 2012.040 2014.022',false), (1667,'Thailand - onshore and GoT 96°E to102°E','Thailand - onshore west of 102°E plus offshore Gulf of Thailand west of 102°E.',5.63,20.46,97.34,102.01,'urn:ogc:def:extent-polygon:EPSG::1667','','',Null,'Excludes offshore Indian Ocean.','OGP','OGP','2014-05-01','2008.045 2011.004 2012.032 2012.040 2014.022',false), (1668,'Pakistan - north of 35°35''N','Pakistan - north of 35°35''N.',35.58,37.07,71.18,77.01,'urn:ogc:def:extent-polygon:EPSG::1668','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.054 2012.040 2014.022',false), -(1669,'Asia - India; Pakistan - 28°N to 35°35''N','India - north of 28°N; Pakistan - between 28°N and 35°35''N.',28,35.59,60.86,81.65,'urn:ogc:def:extent-polygon:EPSG::1669','','',Null,'','OGP','OGP','2014-05-01','2008.045 2008.054 2012.032 2012.041 2014.022',false), -(1670,'Asia - India; Pakistan - onshore 21°N to 28°N and west of 82°E','India - onshore between 21°N and 28°N and west of 82°E; Pakistan - onshore south of 28°N.',21,28.01,61.59,82,'urn:ogc:def:extent-polygon:EPSG::1670','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.041 2014.022',false), -(1671,'Asia - Bangladesh; India; Myanmar; Pakistan - zone Ilb','Bangladesh - onshore north of 21°N; India - onshore north of 21°N and east of 82°E; Myanmar (Burma) - north of 21°N.',21,29.47,82,101.17,'urn:ogc:def:extent-polygon:EPSG::1671','','',Null,'','OGP','OGP','2014-05-01','2004.290 2008.045 2012.041 2014.022',false), -(1672,'India - onshore 15°N to 21°N','India - onshore between 15°N and 21°N.',15,21,70.15,87.08,'urn:ogc:def:extent-polygon:EPSG::1672','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.041 2014.022',false), -(1673,'India - mainland south of 15°N','India - mainland onshore south of 15°N.',8.02,15,73.94,80.41,'urn:ogc:def:extent-polygon:EPSG::1673','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.041 2014.022',false), -(1674,'Bangladesh - onshore west of 90°E','Bangladesh - onshore west of 90°E.',21.59,26.63,88.04,90,'urn:ogc:def:extent-polygon:EPSG::1674','','',Null,'','OGP','OGP','2012-04-18','2008.045 2012.040',false), -(1675,'Bangladesh - onshore east of 90°E','Bangladesh - onshore east of 90°E.',20.52,25.28,90,92.67,'urn:ogc:def:extent-polygon:EPSG::1675','','',Null,'','OGP','OGP','2012-06-01','2008.045 2012.040 2012.062',false), -(1676,'India - north of 28°N','India - north of 28°N.',28,35.51,70.34,81.65,'urn:ogc:def:extent-polygon:EPSG::1676','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.032 2012.041 2014.022',false), -(1677,'India - onshore 21°N to 28°N and west of 82°E','India - onshore between 21°N and 28°N and west of 82°E.',21,28,68.08,82,'urn:ogc:def:extent-polygon:EPSG::1677','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.041 2014.022',false), -(1678,'India - onshore north of 21°N and east of 82°E','India - onshore north of 21°N and east of 82°E.',21,29.47,82,97.39,'urn:ogc:def:extent-polygon:EPSG::1678','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.041 2014.022',false), -(1679,'India - onshore west of 72°E','India - onshore west of 72°E.',20.64,28.23,68.08,72,'urn:ogc:def:extent-polygon:EPSG::1679','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.041 2014.022',false), -(1680,'India - mainland 72°E to 78°E','India - mainland onshore between 72°E and 78°E.',8.02,35.51,72,78,'urn:ogc:def:extent-polygon:EPSG::1680','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.041 2014.022',false), -(1681,'India - onshore 78°E to 84°E','India - onshore between 78°E and 84°E.',8.28,35.51,78,84,'urn:ogc:def:extent-polygon:EPSG::1681','','',Null,'','OGP','OGP','2012-05-08','2008.045 2012.041',false), -(1682,'India - onshore 84°E to 90°E','India - onshore between 84°E and 90°E.',18.18,28.12,84,90,'urn:ogc:def:extent-polygon:EPSG::1682','','',Null,'','OGP','OGP','2012-05-08','2008.045 2012.041',false), -(1683,'India - mainland 90°E to 96°E','India - mainland onshore between 90°E and 96°E.',21.98,29.43,90,96,'urn:ogc:def:extent-polygon:EPSG::1683','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.041 2014.022',false), -(1684,'India - east of 96°E','India - east of 96°E.',27.08,29.47,96,97.39,'urn:ogc:def:extent-polygon:EPSG::1684','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.041 2014.022',false), -(1685,'Pakistan - 28°N to 35°35''N','Pakistan - between 28°N and 35°35''N.',28,35.59,60.86,77.83,'urn:ogc:def:extent-polygon:EPSG::1685','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.032 2012.040 2014.022',false), -(1686,'Pakistan - onshore south of 28°N','Pakistan - onshore south of 28°N.',23.64,28,61.59,71.91,'urn:ogc:def:extent-polygon:EPSG::1686','','',Null,'','OGP','OGP','2014-05-01','2007.047 2008.045 2012.040 2014.022',false), -(1687,'Pakistan - onshore west of 66°E','Pakistan - onshore west of 66°E.',24.98,29.87,60.86,66,'urn:ogc:def:extent-polygon:EPSG::1687','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.040 2014.022',false), -(1688,'Pakistan - onshore 66°E to 72°E','Pakistan - onshore between 66°E and 72°E.',23.64,36.56,66,72,'urn:ogc:def:extent-polygon:EPSG::1688','','',Null,'','OGP','OGP','2012-04-18','2008.045 2012.040',false), -(1689,'Pakistan - east of 72°E','Pakistan - east of 72°E.',28.22,37.07,72,77.83,'urn:ogc:def:extent-polygon:EPSG::1689','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.040 2014.022',false), +(1669,'Asia - India; Pakistan - 28°N to 35°35''N','India - north of 28°N; Pakistan - between 28°N and 35°35''N.',28,35.59,60.86,81.64,'urn:ogc:def:extent-polygon:EPSG::1669','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2008.054 2012.032 2012.041 2014.022 2017.008',false), +(1670,'Asia - India; Pakistan - onshore 21°N to 28°N and west of 82°E','India - onshore between 21°N and 28°N and west of 82°E; Pakistan - onshore south of 28°N.',21,28.01,61.59,82.01,'urn:ogc:def:extent-polygon:EPSG::1670','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2014.022 2017.008',false), +(1671,'Asia - Bangladesh; India; Myanmar; Pakistan - zone Ilb','Bangladesh - onshore north of 21°N; India - onshore north of 21°N and east of 82°E; Myanmar (Burma) - north of 21°N.',21,29.47,82,101.17,'urn:ogc:def:extent-polygon:EPSG::1671','','',Null,'','OGP','IOGP','2017-03-19','2004.290 2008.045 2012.041 2014.022 2017.008',false), +(1672,'India - onshore 15°N to 21°N','India - onshore between 15°N and 21°N.',15,21.01,70.14,87.15,'urn:ogc:def:extent-polygon:EPSG::1672','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2014.022 2017.008',false), +(1673,'India - mainland south of 15°N','India - mainland onshore south of 15°N.',8.02,15.01,73.94,80.4,'urn:ogc:def:extent-polygon:EPSG::1673','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2014.022 2017.008',false), +(1674,'Bangladesh - onshore west of 90°E','Bangladesh - onshore west of 90°E.',21.59,26.64,88.01,90,'urn:ogc:def:extent-polygon:EPSG::1674','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.040 2017.008',false), +(1675,'Bangladesh - onshore east of 90°E','Bangladesh - onshore east of 90°E.',20.52,25.29,90,92.67,'urn:ogc:def:extent-polygon:EPSG::1675','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.040 2012.062 2017.008',false), +(1676,'India - north of 28°N','India - north of 28°N.',28,35.51,70.35,81.64,'urn:ogc:def:extent-polygon:EPSG::1676','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.032 2012.041 2014.022 2017.008',false), +(1677,'India - onshore 21°N to 28°N and west of 82°E','India - onshore between 21°N and 28°N and west of 82°E.',21,28.01,68.13,82.01,'urn:ogc:def:extent-polygon:EPSG::1677','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2014.022 2017.008',false), +(1678,'India - onshore north of 21°N and east of 82°E','India - onshore north of 21°N and east of 82°E.',21,29.47,82,97.42,'urn:ogc:def:extent-polygon:EPSG::1678','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2014.022 2017.008',false), +(1679,'India - onshore west of 72°E','India - onshore west of 72°E.',20.64,28.22,68.13,72.01,'urn:ogc:def:extent-polygon:EPSG::1679','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2014.022 2017.008',false), +(1680,'India - mainland 72°E to 78°E','India - mainland onshore between 72°E and 78°E.',8.02,35.51,72,78.01,'urn:ogc:def:extent-polygon:EPSG::1680','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2014.022 2017.008',false), +(1681,'India - onshore 78°E to 84°E','India - onshore between 78°E and 84°E.',8.29,35.5,78,84.01,'urn:ogc:def:extent-polygon:EPSG::1681','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2017.008',false), +(1682,'India - onshore 84°E to 90°E','India - onshore between 84°E and 90°E.',18.18,28.14,84,90.01,'urn:ogc:def:extent-polygon:EPSG::1682','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2017.008',false), +(1683,'India - mainland 90°E to 96°E','India - mainland onshore between 90°E and 96°E.',21.94,29.42,90,96.01,'urn:ogc:def:extent-polygon:EPSG::1683','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2014.022 2017.008',false), +(1684,'India - east of 96°E','India - east of 96°E.',27.1,29.47,96,97.42,'urn:ogc:def:extent-polygon:EPSG::1684','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.041 2014.022 2017.008',false), +(1685,'Pakistan - 28°N to 35°35''N','Pakistan - between 28°N and 35°35''N.',28,35.59,60.86,77.83,'urn:ogc:def:extent-polygon:EPSG::1685','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.032 2012.040 2014.022 2017.008',false), +(1686,'Pakistan - onshore south of 28°N','Pakistan - onshore south of 28°N.',23.64,28.01,61.59,71.91,'urn:ogc:def:extent-polygon:EPSG::1686','','',Null,'','OGP','IOGP','2017-03-19','2007.047 2008.045 2012.040 2014.022 2017.008',false), +(1687,'Pakistan - onshore west of 66°E','Pakistan - onshore west of 66°E.',24.98,29.87,60.86,66.01,'urn:ogc:def:extent-polygon:EPSG::1687','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.040 2014.022 2017.008',false), +(1688,'Pakistan - onshore 66°E to 72°E','Pakistan - onshore between 66°E and 72°E.',23.64,36.56,66,72.01,'urn:ogc:def:extent-polygon:EPSG::1688','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.040 2017.008',false), +(1689,'Pakistan - east of 72°E','Pakistan - east of 72°E.',28.21,37.07,72,77.83,'urn:ogc:def:extent-polygon:EPSG::1689','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.040 2014.022 2017.008',false), (1690,'Malaysia - West Malaysia - onshore','Malaysia - West Malaysia onshore.',1.21,6.72,99.59,104.6,'urn:ogc:def:extent-polygon:EPSG::1690','','',Null,'','OGP','OGP','2014-05-01','2012.004 2012.032 2012.040 2014.022',false), (1691,'Malaysia - West Malaysia - onshore west of 102°E','Malaysia - West Malaysia onshore west of 102°E.',2.29,6.72,99.59,102.01,'urn:ogc:def:extent-polygon:EPSG::1691','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.032 2012.040 2014.022',false), (1692,'Malaysia - West Malaysia - east of 102°E','Malaysia - onshore West Malaysia east of 102°E and offshore east coast.',1.21,7.81,102,105.82,'urn:ogc:def:extent-polygon:EPSG::1692','','',Null,'','OGP','OGP','2014-11-21','2008.045 2012.032 2012.040 2014.022 2014.071',false), @@ -10587,7 +10790,7 @@ INSERT INTO epsg_area VALUES (2127,'Europe - 12°E to 18°E and ETRS89 by country','Europe between 12°E and 18°E: Austria; Denmark - offshore and offshore; Germany - onshore and offshore; Norway including Svalbard - onshore and offshore.',46.4,84.01,12,18.01,'urn:ogc:def:extent-polygon:EPSG::2127','','',Null,'','OGP','OGP','2014-05-01','2005.140 2008.045 2009.014 2011.082 2014.021',false), (2128,'Europe - 18°E to 24°E and ETRS89 by country','Europe between 18°E and 24°E: Finland - onshore and offshore; Norway including Svalbard - onshore and offshore.',58.84,84,18,24,'urn:ogc:def:extent-polygon:EPSG::2128','','',Null,'','OGP','OGP','2012-01-05','2005.140 2008.045 2011.082',false), (2129,'Europe - 24°E to 30°E and ETRS89 by country','Europe between 24°E and 30°E: Finland - onshore and offshore; Norway including Svalbard - onshore and offshore.',59.64,84.01,24,30,'urn:ogc:def:extent-polygon:EPSG::2129','','',Null,'','OGP','OGP','2014-05-01','2005.140 2008.045 2011.082 2014.021',false), -(2130,'Europe - 30°E to 36°E and ETRS89 by country','Europe between 30°E and 36°E: Finland - onshore and offshore; Norway including Svalbard - onshore and offshore.',69.46,83.89,30,36,'urn:ogc:def:extent-polygon:EPSG::2130','','',Null,'','OGP','OGP','2014-05-01','2005.140 2008.045 2009.056 2011.082 2014.021',false), +(2130,'Europe - 30°E to 36°E and ETRS89 by country','Europe between 30°E and 36°E: Finland - onshore and offshore; Norway including Svalbard - onshore and offshore.',61.73,83.89,30,36.01,'urn:ogc:def:extent-polygon:EPSG::2130','','',Null,'','OGP','IOGP','2017-06-13','2005.140 2008.045 2009.056 2011.082 2014.021 2016.052',false), (2131,'Europe - 36°E to 42°E and ETRS89 by country','Europe between 36°E and 42°E: Norway including Svalbard - offshore.',71.27,79.09,36,39.65,'urn:ogc:def:extent-polygon:EPSG::2131','','',Null,'','OGP','OGP','2014-05-01','2005.140 2008.045 2011.082 2014.021',false), (2132,'Europe - 42°E to 48°E and ETRS89 by country','Europe - between 42°E and 48°E.',37,41.65,42,48,'','','',Null,'','OGP','OGP','2008-06-23','2005.140 2008.045 2011.082',true), (2133,'USA - 168°W to 162°W - AK, OCS','United States (USA) - between 168°W and 162°W - Alaska and offshore continental shelf (OCS).',49.52,74.29,-168,-161.99,'urn:ogc:def:extent-polygon:EPSG::2133','','',Null,'','OGP','OGP','2014-05-01','2005.520 2007.037 2008.045 2008.070 2011.068 2014.021',false), @@ -10868,7 +11071,7 @@ INSERT INTO epsg_area VALUES (2408,'Japan - Okinawa','Japan - onshore Okinawa.',23.98,26.91,122.83,131.38,'urn:ogc:def:extent-polygon:EPSG::2408','','',Null,'','OGP','OGP','2014-05-01','2012.050 2014.020',false), (2409,'Asia - Japan and South Korea','Japan - onshore; South Korea - onshore.',20.37,45.54,122.83,145.87,'urn:ogc:def:extent-polygon:EPSG::2409','','',Null,'','OGP','OGP','2014-05-01','2012.032 2012.050 2014.020',false), (2410,'Canada - NWT; Nunavut; Saskatchewan','Canada - Northwest Territories; Nunavut; Saskatchewan.',49,83.17,-136.46,-60.72,'urn:ogc:def:extent-polygon:EPSG::2410','','',Null,'','OGP','OGP','2014-05-01','2011.067 2014.020',false), -(2411,'Asia - India mainland and Nepal','India - mainland onshore; Nepal.',8.02,35.51,68.08,97.39,'urn:ogc:def:extent-polygon:EPSG::2411','','',Null,'','OGP','OGP','2014-05-01','2012.041 2014.020',false), +(2411,'Asia - India mainland and Nepal','India - mainland onshore; Nepal.',8.02,35.51,68.13,97.42,'urn:ogc:def:extent-polygon:EPSG::2411','','',Null,'','OGP','IOGP','2017-03-19','2012.041 2014.020 2017.008',false), (2412,'USA - Alaska mainland','United States (USA) - Alaska mainland.',54.34,71.4,-168.26,-129.99,'urn:ogc:def:extent-polygon:EPSG::2412','','',Null,'','OGP','OGP','2014-05-01','2008.070 2011.067 2014.020',false), (2413,'Bahamas - main islands onshore','Bahamas - onshore southwest of a line from 27°30''N, 77°30''W through 23°15''N, 74°30''W to 22°30''N, 72°30''W.',20.86,27.29,-79.04,-72.68,'urn:ogc:def:extent-polygon:EPSG::2413','','',Null,'','OGP','OGP','2014-05-01','2011.051 2011.067 2014.020',false), (2414,'Bahamas (San Salvador Island) - onshore','Bahamas (San Salvador Island) - onshore.',23.9,24.19,-74.6,-74.37,'urn:ogc:def:extent-polygon:EPSG::2414','','',Null,'','OGP','OGP','2014-05-01','2011.051 2014.020',false), @@ -11169,13 +11372,13 @@ INSERT INTO epsg_area VALUES (2709,'Russia - 172.5°W to 169.5°W onshore','Russian Federation - onshore between 172°30''W and 169°30''W.',64.35,67.06,-172.5,-169.57,'urn:ogc:def:extent-polygon:EPSG::2709','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.087 2014.019',false), (2710,'Russia - east of 169.5°W onshore','Russian Federation - onshore between 169°30''W and 166°30''W.',65.7,65.86,-169.22,-168.97,'urn:ogc:def:extent-polygon:EPSG::2710','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.087 2012.013 2014.019',false), (2711,'China - west of 76.5°E','China - west of 76°30''E.',35.81,40.65,73.62,76.5,'urn:ogc:def:extent-polygon:EPSG::2711','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.032 2014.019',false), -(2712,'China - 76.5°E to 79.5°E','China - between 76°30''E and 79°30''E.',30.99,41.83,76.5,79.5,'urn:ogc:def:extent-polygon:EPSG::2712','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.019',false), -(2713,'China - 79.5°E to 82.5°E','China - between 79°30''E and 82°30''E.',29.95,45.88,79.5,82.5,'urn:ogc:def:extent-polygon:EPSG::2713','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.019',false), +(2712,'China - 76.5°E to 79.5°E','China - between 76°30''E and 79°30''E.',31.03,41.83,76.5,79.5,'urn:ogc:def:extent-polygon:EPSG::2712','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.019 2017.008',false), +(2713,'China - 79.5°E to 82.5°E','China - between 79°30''E and 82°30''E.',29.95,45.88,79.5,82.51,'urn:ogc:def:extent-polygon:EPSG::2713','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.019 2017.008',false), (2714,'China - 82.5°E to 85.5°E','China - between 82°30''E and 85°30''E.',28.26,47.23,82.5,85.5,'urn:ogc:def:extent-polygon:EPSG::2714','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.019',false), -(2715,'China - 85.5°E to 88.5°E','China - between 85°30''E and 88°30''E.',27.8,49.18,85.5,88.5,'urn:ogc:def:extent-polygon:EPSG::2715','','',Null,'','OGP','OGP','2014-05-01','2008.045 2012.050 2014.019',false), -(2716,'China - 88.5°E to 91.5°E','China - between 88°30''E and 91°30''E.',27.32,48.42,88.5,91.5,'urn:ogc:def:extent-polygon:EPSG::2716','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.019',false), -(2717,'China - 91.5°E to 94.5°E','China - between 91°30''E and 94°30''E.',27.72,45.13,91.5,94.5,'urn:ogc:def:extent-polygon:EPSG::2717','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.019',false), -(2718,'China - 94.5°E to 97.5°E','China - between 94°30''E and 97°30''E.',28.22,44.5,94.5,97.5,'urn:ogc:def:extent-polygon:EPSG::2718','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.019',false), +(2715,'China - 85.5°E to 88.5°E','China - between 85°30''E and 88°30''E.',27.8,49.18,85.5,88.5,'urn:ogc:def:extent-polygon:EPSG::2715','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2012.050 2014.019 2017.008',false), +(2716,'China - 88.5°E to 91.5°E','China - between 88°30''E and 91°30''E.',27.32,48.42,88.49,91.51,'urn:ogc:def:extent-polygon:EPSG::2716','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.019 2017.008',false), +(2717,'China - 91.5°E to 94.5°E','China - between 91°30''E and 94°30''E.',27.71,45.13,91.5,94.5,'urn:ogc:def:extent-polygon:EPSG::2717','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.019 2017.008',false), +(2718,'China - 94.5°E to 97.5°E','China - between 94°30''E and 97°30''E.',28.23,44.5,94.5,97.51,'urn:ogc:def:extent-polygon:EPSG::2718','','',Null,'','OGP','IOGP','2017-03-19','2008.045 2014.019 2017.008',false), (2719,'China - 97.5°E to 100.5°E','China - between 97°30''E and 100°30''E.',21.43,42.76,97.5,100.5,'urn:ogc:def:extent-polygon:EPSG::2719','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.019',false), (2720,'China - 100.5°E to 103.5°E','China - between 100°30''E and 103°30''E.',21.13,42.69,100.5,103.5,'urn:ogc:def:extent-polygon:EPSG::2720','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.019',false), (2721,'China - 103.5°E to 106.5°E','China - between 103°30''E and 106°30''E.',22.5,42.21,103.5,106.5,'urn:ogc:def:extent-polygon:EPSG::2721','','',Null,'','OGP','OGP','2014-05-01','2008.045 2014.019',false), @@ -11317,9 +11520,9 @@ INSERT INTO epsg_area VALUES (2857,'Europe - 18°W to 12°W','Europe - between 18°W and 12°W.',27.6,66.55,-18,-12,'','','',Null,'','OGP','OGP','2008-06-23','2008.045 2011.082',true), (2858,'Europe - 12°W to 6°W','Europe - between 12°W and 6°W.',36,62.33,-12,-6,'','','',Null,'','OGP','OGP','2008-06-23','2008.045 2011.082',true), (2859,'Europe - 6°W to 0°W','Europe - between 6°W and 0°W.',34.75,62.33,-6,0,'','','',Null,'','OGP','OGP','2008-06-23','2008.045 2011.082',true), -(2860,'Germany - west of 6°E','Germany - onshore and offshore west of 6°E.',50.97,55.92,3.34,6,'urn:ogc:def:extent-polygon:EPSG::2860','','',Null,'','OGP','OGP','2014-05-01','2008.045 2009.014 2011.011 2014.018',false), -(2861,'Germany - 6°E to 12°E','Germany - onshore and offshore between 6°E and 12°E, including Mecklenburg-Vorpommern west of 12°E and Schleswig-Holstein.',47.27,55.47,6,12,'urn:ogc:def:extent-polygon:EPSG::2861','','',Null,'','OGP','OGP','2014-05-01','2008.045 2009.014 2011.011 2014.018',false), -(2862,'Germany - east of 12°E','Germany - onshore and offshore east of 12°E, including Brandenburg (all state, including that part west of 12°E) and Mecklenburg-Vorpommern east of 12°E.',47.46,55.03,11.57,15.04,'urn:ogc:def:extent-polygon:EPSG::2862','','',Null,'','OGP','OGP','2014-05-01','2008.045 2009.014 2011.011 2014.018',false), +(2860,'Germany - west of 6°E','Europe between 0°E and 6°E: Germany - onshore and offshore west of 6°E.',50.97,55.92,3.34,6,'urn:ogc:def:extent-polygon:EPSG::2860','','',Null,'','OGP','IOGP','2017-06-13','2008.045 2009.014 2011.011 2014.018 2016.052',false), +(2861,'Germany - 6°E to 12°E','Europe between 0°E and 6°E: Germany - onshore and offshore between 6°E and 12°E, including Mecklenburg-Vorpommern west of 12°E and Schleswig-Holstein.',47.27,55.47,6,12,'urn:ogc:def:extent-polygon:EPSG::2861','','',Null,'','OGP','IOGP','2017-06-13','2008.045 2009.014 2011.011 2014.018 2016.052',false), +(2862,'Germany - east of 12°E','Europe between 0°E and 6°E: Germany - onshore and offshore east of 12°E, including Brandenburg (all state, including that part west of 12°E) and Mecklenburg-Vorpommern east of 12°E.',47.46,55.03,11.57,15.04,'urn:ogc:def:extent-polygon:EPSG::2862','','',Null,'','OGP','IOGP','2017-06-13','2008.045 2009.014 2011.011 2014.018 2016.052',false), (2863,'Europe - 18°E to 24°E','Europe - between 18°E and 24°E.',34.8,75,18,24,'','','',Null,'','OGP','OGP','2008-06-23','2008.045 2011.082',true), (2864,'Europe - 24°E to 30°E','Europe - between 24°E and 30°E.',34.8,75,24,30,'','','',Null,'','OGP','OGP','2008-06-23','2008.045 2011.082',true), (2865,'Europe - 30°E to 36°E','Europe - between 30°E and 36°E.',34.5,75,30,36,'','','',Null,'','OGP','OGP','2008-06-23','2008.045 2011.082',true), @@ -11440,7 +11643,7 @@ INSERT INTO epsg_area VALUES (2980,'USA - CONUS north of 41°N, east of 78°W - onshore','United States (USA) - CONUS north of 41°N and east of 78°W - onshore - Connecticut; Maine; Massachusetts; New Hampshire; New Jersey; New York; Pennsylvania; Rhode Island; Vermont.',41,47.47,-78,-66.91,'urn:ogc:def:extent-polygon:EPSG::2980','','',Null,'','OGP','IOGP','2016-12-15','2008.045 2008.070 2011.041 2014.018 2015.049 2016.056',false), (2981,'Nigeria - offshore','Nigeria - offshore.',1.92,6.38,2.66,8.49,'urn:ogc:def:extent-polygon:EPSG::2981','','',Null,'','','OGP','2014-05-01','2012.049 2014.018',false), (2982,'Pakistan - Karachi','Pakistan - Karachi licence area.',24.69,25.76,66.83,68,'urn:ogc:def:extent-polygon:EPSG::2982','','',Null,'','OGP','OGP','2014-05-01','2012.040 2014.018',false), -(2983,'Pakistan - East Sind','Pakistan - East Sind.',24.16,28.61,68.27,71.11,'urn:ogc:def:extent-polygon:EPSG::2983','','',Null,'','OGP','OGP','2014-05-01','2012.040 2014.018',false), +(2983,'Pakistan - East Sind','Pakistan - East Sind.',24.16,28.61,68.27,71.14,'urn:ogc:def:extent-polygon:EPSG::2983','','',Null,'','OGP','IOGP','2017-03-19','2012.040 2014.018 2017.008',false), (2984,'Pakistan - Badin and Mehran','Pakistan - Badin and Mehran blocks.',24,25.64,67.74,69.87,'urn:ogc:def:extent-polygon:EPSG::2984','','',Null,'','OGP','OGP','2014-05-01','2012.040 2014.018',false), (2985,'Pakistan - offshore Indus','Pakistan - offshore Indus fan.',21.05,25.39,64,68.24,'urn:ogc:def:extent-polygon:EPSG::2985','','',Null,'','OGP','OGP','2014-05-01','2012.040 2014.018',false), (2986,'Australia - SA','Australia - South Australia.',-38.13,-25.99,128.99,141.01,'urn:ogc:def:extent-polygon:EPSG::2986','','',Null,'','OGP','OGP','2014-05-01','2012.027 2014.018',false), @@ -11600,7 +11803,7 @@ INSERT INTO epsg_area VALUES (3140,'Iran - South Pars block 11','Iran - South Pars field phase 11.',26.46,26.64,52.22,52.41,'urn:ogc:def:extent-polygon:EPSG::3140','','',Null,'','OGP','OGP','2014-05-01','2012.051 2014.017',false), (3141,'Iran - Tombak LNG plant','Iran - Tombak LNG plant.',27.63,27.81,52.09,52.26,'urn:ogc:def:extent-polygon:EPSG::3141','','',Null,'','OGP','OGP','2014-05-01','2012.051 2014.017',false), (3142,'Libya - Sirte NC192','Libya - Sirte Basin licence NC192.',27.5,28.07,21.25,21.59,'urn:ogc:def:extent-polygon:EPSG::3142','','',Null,'','OGP','OGP','2014-05-01','2012.049 2014.017',false), -(3143,'Trinidad and Tobago - Trinidad - onshore','Trinidad and Tobago - Trinidad - onshore.',9.99,10.9,-61.97,-60.86,'urn:ogc:def:extent-polygon:EPSG::3143','','',Null,'','OGP','OGP','2014-05-01','2011.037 2014.017',false), +(3143,'Trinidad and Tobago - Trinidad - onshore','Trinidad and Tobago - Trinidad - onshore.',9.99,10.9,-61.98,-60.85,'urn:ogc:def:extent-polygon:EPSG::3143','','',Null,'','OGP','IOGP','2017-03-19','2011.037 2014.017 2017.003',false), (3144,'French Guiana - east of 54°W','French Guiana - east of 54°W, onshore and offshore.',2.17,8.88,-54,-49.45,'urn:ogc:def:extent-polygon:EPSG::3144','','',Null,'','OGP','OGP','2014-05-01','2008.045 2010.046 2011.037 2014.017',false), (3145,'French Guiana - west of 54°W','French Guiana - west of 54°W.',2.11,5.69,-54.61,-54,'urn:ogc:def:extent-polygon:EPSG::3145','','',Null,'','OGP','OGP','2014-05-01','2008.045 2011.037 2014.017',false), (3146,'French Guiana - onshore','French Guiana - onshore.',2.11,5.81,-54.61,-51.61,'urn:ogc:def:extent-polygon:EPSG::3146','','',Null,'','OGP','OGP','2014-05-01','2011.037 2014.017',false), @@ -11674,7 +11877,7 @@ INSERT INTO epsg_area VALUES (3214,'Anguilla - onshore','Anguilla - onshore.',18.11,18.33,-63.22,-62.92,'urn:ogc:def:extent-polygon:EPSG::3214','','',Null,'','OGP','OGP','2014-05-01','2011.064 2014.017',false), (3215,'Argentina - mainland onshore','Argentina - mainland onshore.',-52.43,-21.78,-73.59,-53.65,'urn:ogc:def:extent-polygon:EPSG::3215','','',Null,'','OGP','OGP','2014-05-01','2011.021 2011.037 2014.017',false), (3216,'Aruba - onshore','Aruba - onshore.',12.36,12.68,-70.11,-69.82,'urn:ogc:def:extent-polygon:EPSG::3216','','',Null,'','OGP','OGP','2014-05-01','2011.037 2014.017',false), -(3217,'Bangladesh - onshore','Bangladesh - onshore.',20.52,26.63,88.04,92.67,'urn:ogc:def:extent-polygon:EPSG::3217','','',Null,'','OGP','OGP','2012-06-01','2012.040 2012.062',false), +(3217,'Bangladesh - onshore','Bangladesh - onshore.',20.52,26.64,88.01,92.67,'urn:ogc:def:extent-polygon:EPSG::3217','','',Null,'','OGP','IOGP','2017-03-19','2012.040 2012.062 2017.008',false), (3218,'Barbados - onshore','Barbados - onshore.',13,13.39,-59.71,-59.37,'urn:ogc:def:extent-polygon:EPSG::3218','','',Null,'','OGP','OGP','2014-05-01','2007.032 2011.064 2014.017',false), (3219,'Belize - onshore','Belize - onshore.',15.88,18.49,-89.22,-87.72,'urn:ogc:def:extent-polygon:EPSG::3219','','',Null,'','OGP','OGP','2014-05-01','2011.064 2014.017',false), (3220,'Benin - onshore','Benin - onshore.',6.17,12.4,0.77,3.86,'urn:ogc:def:extent-polygon:EPSG::3220','','',Null,'','OGP','OGP','2014-05-01','2012.049 2014.017',false), @@ -11685,7 +11888,7 @@ INSERT INTO epsg_area VALUES (3225,'Cambodia - onshore','Cambodia - onshore.',10.39,14.71,102.34,107.64,'urn:ogc:def:extent-polygon:EPSG::3225','','',Null,'','OGP','OGP','2014-05-01','2012.040 2014.017',false), (3226,'Cameroon - onshore','Cameroon - onshore.',1.65,13.09,8.45,16.21,'urn:ogc:def:extent-polygon:EPSG::3226','','',Null,'','OGP','OGP','2014-05-01','2012.049 2014.017',false), (3227,'Chile - onshore north of 45°S','Chile - onshore north of 45°S.',-45,-17.5,-75.22,-67,'urn:ogc:def:extent-polygon:EPSG::3227','','',Null,'','OGP','OGP','2014-05-01','2011.021 2011.037 2014.017',false), -(3228,'China - onshore','China - onshore.',18.11,53.56,73.62,134.77,'urn:ogc:def:extent-polygon:EPSG::3228','','',Null,'','OGP','OGP','2014-05-01','2012.050 2014.017',false), +(3228,'China - onshore','China - onshore.',18.11,53.56,73.62,134.77,'urn:ogc:def:extent-polygon:EPSG::3228','','',Null,'','OGP','IOGP','2017-03-19','2012.050 2014.017 2017.008',false), (3229,'Colombia - mainland','Colombia - mainland onshore.',-4.23,12.52,-79.1,-66.87,'urn:ogc:def:extent-polygon:EPSG::3229','','',Null,'Excludes San Andres y Providencia, Malpelo Islands, Roncador Bank, Serrana Bank and Serranilla Bank.','OGP','OGP','2014-05-01','2011.004 2011.037 2012.044 2014.017',false), (3230,'Congo - onshore','Congo - onshore.',-5.06,3.72,11.11,18.65,'urn:ogc:def:extent-polygon:EPSG::3230','','',Null,'','OGP','OGP','2014-05-01','2012.049 2014.017',false), (3231,'Congo DR (Zaire) - onshore','The Democratic Republic of the Congo (Zaire) - onshore.',-13.46,5.39,12.17,31.31,'urn:ogc:def:extent-polygon:EPSG::3231','','',Null,'','OGP','OGP','2014-05-01','2012.042 2014.017',false), @@ -11739,14 +11942,14 @@ INSERT INTO epsg_area VALUES (3279,'Montserrat - onshore','Montserrat - onshore.',16.62,16.87,-62.29,-62.08,'urn:ogc:def:extent-polygon:EPSG::3279','','',Null,'','OGP','OGP','2014-05-01','2011.064 2014.016',false), (3280,'Morocco - onshore','Morocco - onshore.',27.66,35.97,-13.24,-1.01,'urn:ogc:def:extent-polygon:EPSG::3280','','',Null,'','OGP','OGP','2014-05-01','2012.049 2014.016',false), (3281,'Mozambique - onshore','Mozambique - onshore.',-26.87,-10.42,30.21,40.9,'urn:ogc:def:extent-polygon:EPSG::3281','','',Null,'','OGP','OGP','2014-05-01','2012.049 2014.016',false), -(3282,'Myanmar (Burma) - onshore','Myanmar (Burma) - onshore.',9.78,28.55,92.2,101.17,'urn:ogc:def:extent-polygon:EPSG::3282','','',Null,'','OGP','OGP','2014-05-01','2012.040 2014.016',false), +(3282,'Myanmar (Burma) - onshore','Myanmar (Burma) - onshore.',9.78,28.55,92.2,101.17,'urn:ogc:def:extent-polygon:EPSG::3282','','',Null,'','OGP','IOGP','2017-03-19','2012.040 2014.016 2017.008',false), (3283,'Namibia - onshore','Namibia - onshore.',-28.97,-16.95,11.66,25.27,'urn:ogc:def:extent-polygon:EPSG::3283','','',Null,'','OGP','OGP','2014-05-01','2012.049 2014.016',false), (3284,'Netherlands - onshore','Netherlands - onshore.',50.78,53.6,3.33,7.3,'','','',Null,'','OGP','OGP','2006-02-01','2009.045',true), (3285,'New Zealand - onshore and nearshore','New Zealand - North Island, South Island, Stewart Island - onshore and nearshore.',-47.65,-33.89,165.87,179.27,'urn:ogc:def:extent-polygon:EPSG::3285','','',Null,'','OGP','OGP','2014-05-01','2008.023 2012.007 2012.027 2014.016',false),
[... 1526 lines stripped ...]