sis-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From desruisse...@apache.org
Subject svn commit: r1795066 [2/3] - in /sis/data/non-free/sis-epsg/src/main/resources/org/apache/sis/referencing/factory/sql/epsg: Data.sql Tables.sql
Date Sat, 13 May 2017 14:14:03 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=1795066&r1=1795065&r2=1795066&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] Sat May 13 14:14:03 2017
@@ -3,7 +3,7 @@
 ---    See  http://www.epsg.org/TermsOfUse  (a copy is in ./LICENSE.txt).
 ---
 ---    This file has been reformatted (without any change in the data) for the needs of Apache SIS project.
----    See org.apache.sis.referencing.factory.sql.EPSGDataFormatter.
+---    See org.apache.sis.referencing.factory.sql.epsg.DataScriptFormatter.
 ---
 
 INSERT INTO epsg_alias VALUES
@@ -872,13 +872,13 @@ INSERT INTO epsg_alias VALUES
 (884,'Coordinate Reference System',21892,7302,'Bogota / Colombia Bogota',''),
 (885,'Coordinate Reference System',21893,7302,'Bogota / Colombia 3E',''),
 (886,'Coordinate Reference System',21894,7302,'Bogota / Colombia 6E',''),
-(887,'Coordinate Reference System',22191,7302,'C Inchauspe /Argentina 1',''),
-(888,'Coordinate Reference System',22192,7302,'C Inchauspe /Argentina 2',''),
-(889,'Coordinate Reference System',22193,7302,'C Inchauspe /Argentina 3',''),
-(890,'Coordinate Reference System',22194,7302,'C Inchauspe /Argentina 4',''),
-(891,'Coordinate Reference System',22195,7302,'C Inchauspe /Argentina 5',''),
-(892,'Coordinate Reference System',22196,7302,'C Inchauspe /Argentina 6',''),
-(893,'Coordinate Reference System',22197,7302,'C Inchauspe /Argentina 7',''),
+(887,'Coordinate Reference System',22191,7302,'C Inchauspe / Argentina 1',''),
+(888,'Coordinate Reference System',22192,7302,'C Inchauspe / Argentina 2',''),
+(889,'Coordinate Reference System',22193,7302,'C Inchauspe / Argentina 3',''),
+(890,'Coordinate Reference System',22194,7302,'C Inchauspe / Argentina 4',''),
+(891,'Coordinate Reference System',22195,7302,'C Inchauspe / Argentina 5',''),
+(892,'Coordinate Reference System',22196,7302,'C Inchauspe / Argentina 6',''),
+(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',''),
@@ -1070,7 +1070,7 @@ INSERT INTO epsg_alias VALUES
 (1084,'Coordinate Reference System',29849,7302,'Timbalai 1948 / UTM 49N',''),
 (1085,'Coordinate Reference System',29850,7302,'Timbalai 1948 / UTM 50N',''),
 (1086,'Coordinate Reference System',29871,7302,'Timbalai  / Borneo (ch)',''),
-(1087,'Coordinate Reference System',29872,7302,'Timbalai  / Borneo (ft)',''),
+(1087,'Coordinate Reference System',29872,7302,'Timbalai / Borneo (ftSe)',''),
 (1088,'Coordinate Reference System',29873,7302,'Timbalai / Borneo (m)',''),
 (1089,'Coordinate Reference System',29900,7302,'TM65 / Irish Nat Grid',''),
 (1090,'Coordinate Reference System',30161,7302,'Tokyo / Japan zone I',''),
@@ -1189,15 +1189,18 @@ INSERT INTO epsg_alias VALUES
 (1205,'Unit of Measure',9105,7306,'gon',''),
 (1206,'Unit of Measure',9106,7306,'gon',''),
 (1207,'Datum',1162,7302,'LAS-2000',''),
+(1208,'Datum',1159,7302,'GSK-2011',''),
 (1209,'Unit of Measure',9109,7306,'urad',''),
+(1210,'Datum',1159,7301,'GRS-2011',''),
+(1211,'Coordinate_Operation',7723,7302,'Andhra Pradesh',''),
 (1212,'Unit of Measure',9112,7306,'cgr',''),
 (1213,'Unit of Measure',9113,7306,'ccgr',''),
 (1214,'Unit of Measure',9114,7306,'mila',''),
 (1215,'Coordinate_Operation Method',9824,7302,'UTM grid system',''),
-(1216,'Coordinate Reference System',4143,7301,'Côte D''Ivoire','Same alias is ambiguous as also applied to Locodjo 1965 (code 4142).'),
+(1216,'Coordinate Reference System',4143,7301,'Côte d''Ivoire','Same alias is ambiguous as also applied to Locodjo 1965 (code 4142).'),
 (1217,'Coordinate Reference System',4143,7301,'Port Bouet','Same alias is ambiguous as also applied to Locodjo 1965 (code 4142).'),
 (1218,'Coordinate Reference System',4142,7301,'Port Bouet','Same alias is ambiguous as also applied to Abidjan 1987 (code 4143).'),
-(1219,'Coordinate Reference System',4142,7301,'Côte D''Ivoire','Same alias is ambiguous as also applied to Abidjan 1987 (code 4143).'),
+(1219,'Coordinate Reference System',4142,7301,'Côte d''Ivoire','Same alias is ambiguous as also applied to Abidjan 1987 (code 4143).'),
 (1220,'Coordinate Reference System',2164,7301,'Cote d''Ivoire / TM 5 NW','Same alias is ambiguous as used for Abidjan 1987 / TM 5 NW (code 2165).'),
 (1221,'Coordinate Reference System',2164,7301,'Port Bouet / TM 5 NW','Same alias is ambiguous as used for Abidjan 1987 / TM 5 NW (code 2165).'),
 (1222,'Coordinate Reference System',2165,7301,'Cote d''Ivoire / TM 5 NW','Same alias is ambiguous as used for Locodjo 1965 / TM 5 NW (code 2164).'),
@@ -1234,7 +1237,7 @@ INSERT INTO epsg_alias VALUES
 (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,7301,'NAD83(2011) / OCRS_BRP (ft)',''),
+(1256,'Coordinate Reference System',6795,7302,'NAD83(2011) / OCRS_BRP (ft)',''),
 (1257,'Coordinate Reference System',6794,7302,'NAD83(2011) / OCRS_BRP (m)',''),
 (1258,'Coordinate Reference System',6803,7302,'NAD83(2011) / OCRS_CGP (ft)',''),
 (1259,'Coordinate Reference System',31275,7308,'HDKS zone 5','HDKS = Hrvatski Drzavni Koordinatni Sustav'),
@@ -1260,7 +1263,7 @@ INSERT INTO epsg_alias VALUES
 (1279,'Coordinate_Operation',1640,7307,'IE_Ireland65 to ETRS89','IE_Ireland65 to ETRS89 applies to the Republic of Ireland. Also referred to in EuroGeographics as NI_Ireland65 to ETRS89 for Northern Ireland.'),
 (1280,'Coordinate_Operation',1642,7307,'LU_LUREF to ETRS89',''),
 (1281,'Coordinate_Operation',1644,7307,'PL_42/58 to ETRS89',''),
-(1282,'Coordinate_Operation',1646,7307,'CH_CH1903 to ETRS89',''),
+(1282,'Coordinate_Operation',1646,7307,'CH_CH1903 to ETRS89','EuroGeographics rounds the parameter values to decimetre resolution to reflect accuracy of CH1903 network.'),
 (1283,'Coordinate_Operation',1647,7307,'CH_CH1903+ to ETRS89',''),
 (1284,'Coordinate_Operation',1648,7307,'EE_L-EST97 to ETRS89',''),
 (1285,'Coordinate_Operation',1650,7307,'FR_ED50 to ETRS89',''),
@@ -1284,8 +1287,8 @@ INSERT INTO epsg_alias VALUES
 (1303,'Datum',5118,7301,'NGF','This alias is also used for other datum realisations: see NGF - IGN69 (code 5119) and NGF - IGN78 (code 5120).'),
 (1304,'Datum',5120,7301,'Nivellement general de la France','This alias is also used for other datum realisations: see NGF - Lallemand (code 5118) and NGF - IGN69 (code 5119).'),
 (1305,'Datum',5118,7301,'Nivellement general de la France','This alias is also used for other datum realisations: see NGF - IGN69 (code 5119) and NGF - IGN78 (code 5120).'),
-(1306,'Datum',6143,7301,'Côte D''Ivoire (Ivory Coast)','This alias is not unique: it is also used for code 6142.'),
-(1307,'Datum',6142,7301,'Côte D''Ivoire (Ivory Coast)','This alias is not unique: it is also used for code 6143.'),
+(1306,'Datum',6143,7301,'Côte d''Ivoire (Ivory Coast)','This alias is not unique: it is also used for code 6142.'),
+(1307,'Datum',6142,7301,'Côte d''Ivoire (Ivory Coast)','This alias is not unique: it is also used for code 6143.'),
 (1308,'Coordinate Reference System',4300,7301,'1975 Mapping Adjustment',''),
 (1309,'Coordinate Reference System',2196,7301,'EUREF89 / Kp2000 Jutland',''),
 (1310,'Coordinate Reference System',2196,7301,'System 2000 Jylland zoner',''),
@@ -1442,9 +1445,9 @@ INSERT INTO epsg_alias VALUES
 (1461,'Coordinate_Operation',18417,7302,'AEF east',''),
 (1462,'Coordinate Reference System',6819,7302,'NAD83(2011) / OCRS_DFM (ft)',''),
 (1463,'Coordinate Reference System',6818,7302,'NAD83(2011) / OCRS_DFM (m)',''),
-(1464,'Coordinate_Operation',1469,7301,'Côte D''Ivoire to WGS 84 (1)','Same alias also applied to Abidjan 1987 to WGS 84 (1) (code 1470).'),
+(1464,'Coordinate_Operation',1469,7301,'Côte d''Ivoire to WGS 84 (1)','Same alias also applied to Abidjan 1987 to WGS 84 (1) (code 1470).'),
 (1465,'Coordinate_Operation',1469,7301,'Port Bouet to WGS 84 (1)','Same alias also applied to Abidjan 1987 to WGS 84 (1) (code 1470).'),
-(1466,'Coordinate_Operation',1470,7301,'Côte D''Ivoire to WGS 84 (1)','Same alias also applied to Locodjo 1965 to WGS 84 (1) (code 1469).'),
+(1466,'Coordinate_Operation',1470,7301,'Côte d''Ivoire to WGS 84 (1)','Same alias also applied to Locodjo 1965 to WGS 84 (1) (code 1469).'),
 (1467,'Coordinate_Operation',1470,7301,'Port Bouet to WGS 84 (1)','Same alias also applied to Locodjo 1965 to WGS 84 (1) (code 1469).'),
 (1468,'Coordinate Reference System',2040,7301,'Port Bouet / UTM zone 30N','Same alias used for Abidjan 1987 / UTM zone 30N (code 2041).'),
 (1469,'Coordinate Reference System',2040,7301,'Côte d''Ivoire / UTM zone 30N','Same alias used for Abidjan 1987 / UTM zone 30N (code 2041).'),
@@ -1946,6 +1949,7 @@ INSERT INTO epsg_alias VALUES
 (1965,'Coordinate Reference System',2521,7301,'Pulkovo 1942 / 6-degree Gauss-Kruger CM 177W',''),
 (1966,'Coordinate Reference System',2522,7301,'Pulkovo 1942 / 6-degree Gauss-Kruger CM 171W',''),
 (1967,'Unit of Measure',9115,7302,'DM',''),
+(1968,'Datum',1164,7302,'ODN (Offshore)',''),
 (1969,'Coordinate Reference System',6792,7302,'CORS96 / OCRS_BRP (m)',''),
 (1970,'Coordinate Reference System',6801,7302,'CORS96 / OCRS_CGP (ft)',''),
 (1971,'Coordinate Reference System',6800,7302,'CORS96 / OCRS_CGP (m)',''),
@@ -1987,7 +1991,7 @@ INSERT INTO epsg_alias VALUES
 (2007,'Coordinate Reference System',6840,7302,'CORS96 / OCRS_ORC (m)',''),
 (2008,'Coordinate Reference System',2933,7301,'Samboja / UTM zone 50S',''),
 (2009,'Coordinate Reference System',2933,7301,'P2 Exc-T9 / UTM zone 50S',''),
-(2010,'Unit of Measure',9110,7301,'sexagesimal degree',''),
+(2010,'Unit of Measure',9110,7301,'sexagesimal degree DDD.MMSSsss',''),
 (2011,'Coordinate Reference System',2952,7301,'NAD83(CSRS) / SCoPQ zone 10',''),
 (2012,'Coordinate Reference System',2945,7301,'NAD83(CSRS) / SCoPQ zone 3',''),
 (2013,'Coordinate Reference System',2946,7301,'NAD83(CSRS) / SCoPQ zone 4',''),
@@ -2042,11 +2046,17 @@ INSERT INTO epsg_alias VALUES
 (2062,'Coordinate Reference System',6853,7302,'CORS96 / OCRS_PDX (ft)',''),
 (2063,'Coordinate Reference System',6854,7302,'NAD83(2011) / OCRS_PDX (m)',''),
 (2064,'Unit of Measure',9121,7302,'DDDMMSS.sss',''),
+(2065,'Coordinate_Operation',7712,7301,'ETRF89 to Newlyn (Orkney Isles) height (2)',''),
 (2066,'Unit of Measure',9120,7302,'HDMS',''),
+(2067,'Coordinate Reference System',7707,7301,'Newlyn (Offshore) height',''),
 (2068,'Unit of Measure',9119,7302,'HDM',''),
+(2069,'Coordinate_Operation',7709,7302,'OSTN15_NTv2',''),
 (2070,'Unit of Measure',9117,7302,'Hdeg',''),
+(2071,'Coordinate_Operation',7709,7301,'OSGB 1936 to ETRF2000 (1)',''),
 (2072,'Unit of Measure',9118,7302,'DMH',''),
+(2073,'Coordinate_Operation',7708,7302,'OSTN15',''),
 (2074,'Unit of Measure',9116,7302,'degH',''),
+(2075,'Coordinate_Operation',7708,7301,'OSGB 1936 / British National Grid to ETRF97 (3)',''),
 (2076,'Datum',6637,7302,'Perroud 1950',''),
 (2077,'Datum',6634,7301,'MHNC72',''),
 (2078,'Datum',6627,7302,'RGR92',''),
@@ -2258,6 +2268,7 @@ INSERT INTO epsg_alias VALUES
 (2284,'Coordinate Reference System',3025,7301,'RT38 2.5 gon V 0:-15',''),
 (2285,'Datum',6667,7301,'IKBD-92',''),
 (2286,'Unit of Measure',9122,7302,'deg',''),
+(2287,'Coordinate Reference System',7793,7301,'RDN2008 / TM34 (E-N)',''),
 (2288,'Coordinate Reference System',66656405,7301,'Base SW (deg)','The same name is also used for the 1948 adjustment (see CRS code 61836405).'),
 (2289,'Coordinate Reference System',61836405,7301,'Base SW (deg)','The same name is also used for the 1995 adjustment (see CRS code 66656405).'),
 (2290,'Coordinate Reference System',66656405,7301,'Graciosa (deg)','The same name is also used for the 1948 adjustment (see CRS code 61836405).'),
@@ -2386,7 +2397,7 @@ INSERT INTO epsg_alias VALUES
 (2413,'Datum',6678,7302,'Lao 1997',''),
 (2414,'Datum',5182,7302,'DHHN85',''),
 (2415,'Datum',5183,7302,'SNN76',''),
-(2416,'Coordinate Reference System',6875,7301,'RDN2008 / Fuso Italia',''),
+(2416,'Coordinate Reference System',6875,7301,'RDN2008 / Fuso Italia (N-E)',''),
 (2417,'Coordinate_Operation',5412,7302,'CD to PWD (1)',''),
 (2418,'Coordinate_Operation',5413,7302,'CD height to WD depth',''),
 (2419,'Coordinate_Operation',5414,7302,'WD to PWD',''),
@@ -2400,11 +2411,11 @@ INSERT INTO epsg_alias VALUES
 (2427,'Datum',5186,7302,'PWD',''),
 (2428,'Datum',5187,7302,'WD',''),
 (2429,'Datum',5188,7302,'CD',''),
-(2430,'Coordinate Reference System',6876,7301,'RDN2008 / Fuso 12',''),
+(2430,'Coordinate Reference System',6876,7301,'RDN2008 / Fuso 12 (N-E)',''),
 (2431,'Coordinate Reference System',5787,7301,'Baltic 1980 height',''),
 (2432,'Coordinate Reference System',5782,7301,'REDNAP height',''),
 (2433,'Coordinate_Operation',6878,7301,'Zone 12',''),
-(2434,'Coordinate_Operation',6872,7301,'Côte D''Ivoire to WGS 84 (2)',''),
+(2434,'Coordinate_Operation',6872,7301,'Côte d''Ivoire to WGS 84 (2)',''),
 (2435,'Coordinate Reference System',3072,7301,'Maine Coordinate System of 2000 East Zone','This alias is ambiguous as also used for other realisations of NAD83 datum with Maine CS2000 East zone projection.'),
 (2436,'Coordinate Reference System',3073,7301,'Maine Coordinate System of 2000 Central Zone','This alias also used for NAD83(HARN) / Maine CS2000 Central.'),
 (2437,'Coordinate Reference System',3074,7301,'Maine Coordinate System of 2000 West Zone','This alias is ambiguous as also used for other realisations of NAD83 datum with Maine CS2000 West zone projection.'),
@@ -2719,7 +2730,7 @@ INSERT INTO epsg_alias VALUES
 (2746,'Coordinate Reference System',3088,7301,'NAD83 / Kentucky Single Zone (m)',''),
 (2747,'Coordinate Reference System',6879,7301,'NAD83(2011) / Wisconsin Central (m)',''),
 (2748,'Coordinate Reference System',3089,7301,'KY1Z','This alias is ambiguous as it is also used for the same projection associated with different datums and coordinate systems.'),
-(2749,'Coordinate Reference System',3091,7302,'NAD83(HARN) / KY1Z ftUS',''),
+(2749,'Coordinate Reference System',3091,7302,'NAD83(HARN) / KY1Z (ftUS)',''),
 (2750,'Coordinate_Operation',11630,7301,'SPCS83 Kentucky Single Zone',''),
 (2751,'Datum',6625,7301,'Fort Desaix',''),
 (2752,'Datum',6622,7301,'Sainte Anne',''),
@@ -3072,7 +3083,7 @@ INSERT INTO epsg_alias VALUES
 (3099,'Coordinate Reference System',3348,7301,'NAD83 / STC Lambert','See CRS remarks.'),
 (3100,'Datum',6182,7313,'Observatorio Meteorologico 1939','As carried in NIMA 8350.2 3rd Edition Amendment 1 (January 2000).  Prior versions of TR8350.2 erroneously called this "Observatorio 1966".'),
 (3101,'Datum',6182,7313,'Observatorio 1966','As incorrectly carried in NIMA TR8350.2 original edition (September 1987), from which the name has widely adopted. Replaced in TR8350.2 3rd Edition Amendment 1 (January 2000) by "Observatorio Meteorologico 1939".'),
-(3102,'Coordinate Reference System',6885,7302,'NAD83(2011) / OR N (ft)',''),
+(3102,'Coordinate Reference System',6885,7302,'NAD83(CORS96) / OR N (ft)',''),
 (3103,'Coordinate Reference System',6887,7302,'CORS96 / OR S (ft)',''),
 (3104,'Coordinate_Operation Method',1034,7301,'Molodensky-Badekas (geocentric domain)',''),
 (3105,'Coordinate_Operation Method',1039,7301,'Molodensky-Badekas (geog3D domain)',''),
@@ -3513,7 +3524,7 @@ INSERT INTO epsg_alias VALUES
 (3540,'Coordinate Reference System',3075,7301,'NAD83(HARN) / Maine CS2000 East (m)',''),
 (3541,'Coordinate Reference System',3077,7301,'NAD83(HARN) / Maine CS2000 West (m)',''),
 (3542,'Coordinate Reference System',6867,7302,'CORS96 / OR LCC (m)',''),
-(3543,'Coordinate Reference System',6868,7302,'CORS96 / OR GIC Lam ft',''),
+(3543,'Coordinate Reference System',6868,7302,'CORS96 / OR GIC Lam (ft)',''),
 (3544,'Coordinate_Operation',6864,7301,'ITRF96 to NAD83(CSRS) (1)',''),
 (3545,'Coordinate Reference System',6785,7302,'CORS96 / OCRS_BKE (ft)',''),
 (3546,'Coordinate Reference System',6789,7302,'CORS96 / OCRS_BKF (ft)',''),
@@ -3860,7 +3871,7 @@ INSERT INTO epsg_alias VALUES
 (3887,'Coordinate Reference System',3760,7301,'NAD83(HPGN) / Hawaii zone 3 (ftUS)',''),
 (3888,'Coordinate_Operation',6910,7313,'Aden to WGS 84',''),
 (3889,'Coordinate Reference System',3546,7301,'KY1Z','This alias is ambiguous as it is also used for the same projection associated with different datums and coordinate systems.'),
-(3890,'Coordinate Reference System',3547,7302,'NAD83(NSRS) / KY1Z ftUS',''),
+(3890,'Coordinate Reference System',3547,7302,'NAD83(NSRS) / KY1Z (ftUS)',''),
 (3891,'Coordinate Reference System',3547,7301,'KY1Z','This alias is ambiguous as it is also used for the same projection associated with different datums and coordinate systems.'),
 (3892,'Coordinate_Operation',15950,7302,'Viti Levu Grid to FMG (1)',''),
 (3893,'Coordinate_Operation',6910,1039,'ADN',''),
@@ -4464,8 +4475,8 @@ INSERT INTO epsg_alias VALUES
 (4491,'Coordinate Reference System',2306,7302,'Qornoq 1927 / GRL 7 west',''),
 (4492,'Coordinate Reference System',2307,7302,'Qornoq 1927 / GRL 8 east',''),
 (4493,'Coordinate Reference System',2314,7302,'Trinidad 03 Grid (ftCla)',''),
-(4494,'Coordinate Reference System',2315,7302,'Campo Inchauspe /UTM 19S',''),
-(4495,'Coordinate Reference System',2316,7302,'Campo Inchauspe /UTM 20S',''),
+(4494,'Coordinate Reference System',2315,7302,'C Inchauspe / UTM 19S',''),
+(4495,'Coordinate Reference System',2316,7302,'C Inchauspe / UTM 20S',''),
 (4496,'Coordinate Reference System',2318,7302,'Ain el Abd / Aramco Lamb',''),
 (4497,'Coordinate Reference System',2327,7302,'Xian 1980 / G-K zone 13',''),
 (4498,'Coordinate Reference System',2328,7302,'Xian 1980 / G-K zone 14',''),
@@ -4985,67 +4996,67 @@ INSERT INTO epsg_alias VALUES
 (5012,'Coordinate Reference System',2867,7302,'NAD83(HARN) / AZ E (ft)',''),
 (5013,'Coordinate Reference System',2868,7302,'NAD83(HARN) / AZ C (ft)',''),
 (5014,'Coordinate Reference System',2869,7302,'NAD83(HARN) / AZ W (ft)',''),
-(5015,'Coordinate Reference System',2870,7302,'NAD83(HARN) / CA 1 ftUS',''),
-(5016,'Coordinate Reference System',2871,7302,'NAD83(HARN) / CA 2 ftUS',''),
-(5017,'Coordinate Reference System',2872,7302,'NAD83(HARN) / CA 3 ftUS',''),
-(5018,'Coordinate Reference System',2873,7302,'NAD83(HARN) / CA 4 ftUS',''),
-(5019,'Coordinate Reference System',2874,7302,'NAD83(HARN) / CA 5 ftUS',''),
-(5020,'Coordinate Reference System',2875,7302,'NAD83(HARN) / CA 6 ftUS',''),
-(5021,'Coordinate Reference System',2876,7302,'NAD83(HARN) / CO N ftUS',''),
-(5022,'Coordinate Reference System',2877,7302,'NAD83(HARN) / CO C ftUS',''),
-(5023,'Coordinate Reference System',2878,7302,'NAD83(HARN) / CO S ftUS',''),
+(5015,'Coordinate Reference System',2870,7302,'NAD83(HARN) / CA 1 (ftUS)',''),
+(5016,'Coordinate Reference System',2871,7302,'NAD83(HARN) / CA 2 (ftUS)',''),
+(5017,'Coordinate Reference System',2872,7302,'NAD83(HARN) / CA 3 (ftUS)',''),
+(5018,'Coordinate Reference System',2873,7302,'NAD83(HARN) / CA 4 (ftUS)',''),
+(5019,'Coordinate Reference System',2874,7302,'NAD83(HARN) / CA 5 (ftUS)',''),
+(5020,'Coordinate Reference System',2875,7302,'NAD83(HARN) / CA 6 (ftUS)',''),
+(5021,'Coordinate Reference System',2876,7302,'NAD83(HARN) / CO N (ftUS)',''),
+(5022,'Coordinate Reference System',2877,7302,'NAD83(HARN) / CO C (ftUS)',''),
+(5023,'Coordinate Reference System',2878,7302,'NAD83(HARN) / CO S (ftUS)',''),
 (5024,'Coordinate Reference System',2879,7302,'NAD83(HARN) / CT (ftUS)',''),
 (5025,'Coordinate Reference System',2880,7302,'NAD83(HARN) / DE (ftUS)',''),
-(5026,'Coordinate Reference System',2881,7302,'NAD83(HARN) / FL E ftUS',''),
-(5027,'Coordinate Reference System',2882,7302,'NAD83(HARN) / FL W ftUS',''),
-(5028,'Coordinate Reference System',2883,7302,'NAD83(HARN) / FL N ftUS',''),
-(5029,'Coordinate Reference System',2884,7302,'NAD83(HARN) / GA E ftUS',''),
-(5030,'Coordinate Reference System',2885,7302,'NAD83(HARN) / GA W ftUS',''),
-(5031,'Coordinate Reference System',2886,7302,'NAD83(HARN) / ID E ftUS',''),
-(5032,'Coordinate Reference System',2887,7302,'NAD83(HARN) / ID C ftUS',''),
-(5033,'Coordinate Reference System',2888,7302,'NAD83(HARN) / ID W ftUS',''),
-(5034,'Coordinate Reference System',2967,7302,'NAD83(HARN) / IN E ftUS',''),
-(5035,'Coordinate Reference System',2968,7302,'NAD83(HARN) / IN W ftUS',''),
-(5036,'Coordinate Reference System',2891,7302,'NAD83(HARN) / KY N ftUS',''),
-(5037,'Coordinate Reference System',2892,7302,'NAD83(HARN) / KY S ftUS',''),
+(5026,'Coordinate Reference System',2881,7302,'NAD83(HARN) / FL E (ftUS)',''),
+(5027,'Coordinate Reference System',2882,7302,'NAD83(HARN) / FL W (ftUS)',''),
+(5028,'Coordinate Reference System',2883,7302,'NAD83(HARN) / FL N (ftUS)',''),
+(5029,'Coordinate Reference System',2884,7302,'NAD83(HARN) / GA E (ftUS)',''),
+(5030,'Coordinate Reference System',2885,7302,'NAD83(HARN) / GA W (ftUS)',''),
+(5031,'Coordinate Reference System',2886,7302,'NAD83(HARN) / ID E (ftUS)',''),
+(5032,'Coordinate Reference System',2887,7302,'NAD83(HARN) / ID C (ftUS)',''),
+(5033,'Coordinate Reference System',2888,7302,'NAD83(HARN) / ID W (ftUS)',''),
+(5034,'Coordinate Reference System',2967,7302,'NAD83(HARN) / IN E (ftUS)',''),
+(5035,'Coordinate Reference System',2968,7302,'NAD83(HARN) / IN W (ftUS)',''),
+(5036,'Coordinate Reference System',2891,7302,'NAD83(HARN) / KY N (ftUS)',''),
+(5037,'Coordinate Reference System',2892,7302,'NAD83(HARN) / KY S (ftUS)',''),
 (5038,'Coordinate Reference System',2893,7302,'NAD83(HARN) / MD (ftUS)',''),
-(5039,'Coordinate Reference System',2894,7302,'NAD83(HARN) / MA md ftUS',''),
-(5040,'Coordinate Reference System',2895,7302,'NAD83(HARN) / MA Is ftUS',''),
+(5039,'Coordinate Reference System',2894,7302,'NAD83(HARN) / MA md (ftUS)',''),
+(5040,'Coordinate Reference System',2895,7302,'NAD83(HARN) / MA Is (ftUS)',''),
 (5041,'Coordinate Reference System',2896,7302,'NAD83(HARN) / MI N (ft)',''),
 (5042,'Coordinate Reference System',2897,7302,'NAD83(HARN) / MI C (ft)',''),
 (5043,'Coordinate Reference System',2898,7302,'NAD83(HARN) / MI S (ft)',''),
-(5044,'Coordinate Reference System',2899,7302,'NAD83(HARN) / MS E ftUS',''),
-(5045,'Coordinate Reference System',2900,7302,'NAD83(HARN) / MS W ftUS',''),
+(5044,'Coordinate Reference System',2899,7302,'NAD83(HARN) / MS E (ftUS)',''),
+(5045,'Coordinate Reference System',2900,7302,'NAD83(HARN) / MS W (ftUS)',''),
 (5046,'Coordinate Reference System',2901,7302,'NAD83(HARN) / MT (ft)',''),
-(5047,'Coordinate Reference System',2902,7302,'NAD83(HARN) / NM E ftUS',''),
-(5048,'Coordinate Reference System',2903,7302,'NAD83(HARN) / NM C ftUS',''),
-(5049,'Coordinate Reference System',2904,7302,'NAD83(HARN) / NM W ftUS',''),
-(5050,'Coordinate Reference System',2905,7302,'NAD83(HARN) / NY E ftUS',''),
-(5051,'Coordinate Reference System',2906,7302,'NAD83(HARN) / NY C ftUS',''),
-(5052,'Coordinate Reference System',2907,7302,'NAD83(HARN) / NY W ftUS',''),
-(5053,'Coordinate Reference System',2908,7302,'NAD83(HARN) / NY LI ftUS',''),
+(5047,'Coordinate Reference System',2902,7302,'NAD83(HARN) / NM E (ftUS)',''),
+(5048,'Coordinate Reference System',2903,7302,'NAD83(HARN) / NM C (ftUS)',''),
+(5049,'Coordinate Reference System',2904,7302,'NAD83(HARN) / NM W (ftUS)',''),
+(5050,'Coordinate Reference System',2905,7302,'NAD83(HARN) / NY E (ftUS)',''),
+(5051,'Coordinate Reference System',2906,7302,'NAD83(HARN) / NY C (ftUS)',''),
+(5052,'Coordinate Reference System',2907,7302,'NAD83(HARN) / NY W (ftUS)',''),
+(5053,'Coordinate Reference System',2908,7302,'NAD83(HARN) / NY LI (ftUS)',''),
 (5054,'Coordinate Reference System',2909,7302,'NAD83(HARN) / ND N (ft)',''),
 (5055,'Coordinate Reference System',2910,7302,'NAD83(HARN) / ND S (ft)',''),
-(5056,'Coordinate Reference System',2911,7302,'NAD83(HARN) / OK N ftUS',''),
-(5057,'Coordinate Reference System',2912,7302,'NAD83(HARN) / OK S ftUS',''),
+(5056,'Coordinate Reference System',2911,7302,'NAD83(HARN) / OK N (ftUS)',''),
+(5057,'Coordinate Reference System',2912,7302,'NAD83(HARN) / OK S (ftUS)',''),
 (5058,'Coordinate Reference System',2913,7302,'NAD83(HARN) / OR N (ft)',''),
 (5059,'Coordinate Reference System',2914,7302,'NAD83(HARN) / OR S (ft)',''),
 (5060,'Coordinate Reference System',2915,7302,'NAD83(HARN) / TN (ftUS)',''),
-(5061,'Coordinate Reference System',2916,7302,'NAD83(HARN) / TX N ftUS',''),
-(5062,'Coordinate Reference System',2917,7302,'NAD83(HARN) / TX NC ftUS',''),
-(5063,'Coordinate Reference System',2918,7302,'NAD83(HARN) / TX C ftUS',''),
-(5064,'Coordinate Reference System',2919,7302,'NAD83(HARN) / TX SC ftUS',''),
-(5065,'Coordinate Reference System',2920,7302,'NAD83(HARN) / TX S ftUS',''),
+(5061,'Coordinate Reference System',2916,7302,'NAD83(HARN) / TX N (ftUS)',''),
+(5062,'Coordinate Reference System',2917,7302,'NAD83(HARN) / TX NC (ftUS)',''),
+(5063,'Coordinate Reference System',2918,7302,'NAD83(HARN) / TX C (ftUS)',''),
+(5064,'Coordinate Reference System',2919,7302,'NAD83(HARN) / TX SC (ftUS)',''),
+(5065,'Coordinate Reference System',2920,7302,'NAD83(HARN) / TX S (ftUS)',''),
 (5066,'Coordinate Reference System',2921,7302,'NAD83(HARN) / UT N (ft)',''),
 (5067,'Coordinate Reference System',2922,7302,'NAD83(HARN) / UT C (ft)',''),
 (5068,'Coordinate Reference System',2923,7302,'NAD83(HARN) / UT S (ft)',''),
-(5069,'Coordinate Reference System',2924,7302,'NAD83(HARN) / VA N ftUS',''),
-(5070,'Coordinate Reference System',2925,7302,'NAD83(HARN) / VA S ftUS',''),
-(5071,'Coordinate Reference System',2926,7302,'NAD83(HARN) / WA N ftUS',''),
-(5072,'Coordinate Reference System',2927,7302,'NAD83(HARN) / WA S ftUS',''),
-(5073,'Coordinate Reference System',2928,7302,'NAD83(HARN) / WI N ftUS',''),
-(5074,'Coordinate Reference System',2929,7302,'NAD83(HARN) / WI C ftUS',''),
-(5075,'Coordinate Reference System',2930,7302,'NAD83(HARN) / WI S ftUS',''),
+(5069,'Coordinate Reference System',2924,7302,'NAD83(HARN) / VA N (ftUS)',''),
+(5070,'Coordinate Reference System',2925,7302,'NAD83(HARN) / VA S (ftUS)',''),
+(5071,'Coordinate Reference System',2926,7302,'NAD83(HARN) / WA N (ftUS)',''),
+(5072,'Coordinate Reference System',2927,7302,'NAD83(HARN) / WA S (ftUS)',''),
+(5073,'Coordinate Reference System',2928,7302,'NAD83(HARN) / WI N (ftUS)',''),
+(5074,'Coordinate Reference System',2929,7302,'NAD83(HARN) / WI C (ftUS)',''),
+(5075,'Coordinate Reference System',2930,7302,'NAD83(HARN) / WI S (ftUS)',''),
 (5076,'Coordinate Reference System',2932,7302,'QND95 / Qatar Nat Grid',''),
 (5077,'Coordinate Reference System',2935,7302,'Pulkovo 1942 / CS63 A1',''),
 (5078,'Coordinate Reference System',2936,7302,'Pulkovo 1942 / CS63 A2',''),
@@ -5078,9 +5089,9 @@ INSERT INTO epsg_alias VALUES
 (5105,'Coordinate Reference System',2985,7302,'Petrels 1972 / Adelie St',''),
 (5106,'Coordinate Reference System',2986,7302,'Perroud 1950 / Adelie St',''),
 (5107,'Coordinate Reference System',2987,7302,'St. Pierre Miq / UTM 21N',''),
-(5108,'Coordinate Reference System',2992,7302,'NAD83 / OR GIC Lam ft',''),
+(5108,'Coordinate Reference System',2992,7302,'NAD83 / OR GIC Lam (ft)',''),
 (5109,'Coordinate_Operation',6898,7302,'DLx to WGS 84 (5)',''),
-(5110,'Coordinate Reference System',2994,7302,'NAD83(HARN) / OR GIC Lam ft',''),
+(5110,'Coordinate Reference System',2994,7302,'NAD83(HARN) / OR GIC Lam (ft)',''),
 (5111,'Coordinate Reference System',2995,7302,'IGN53 Mare / UTM zn 58S',''),
 (5112,'Coordinate Reference System',2996,7302,'ST84 des Pins / UTM 58S',''),
 (5113,'Coordinate Reference System',2997,7302,'ST71 Belep / UTM zn 58S',''),
@@ -5312,45 +5323,45 @@ INSERT INTO epsg_alias VALUES
 (5339,'Coordinate Reference System',3581,7302,'NAD83(CSRS) / NWT LCC',''),
 (5340,'Coordinate Reference System',3761,7302,'NAD83(CSRS) / UTM 22N',''),
 (5341,'Coordinate Reference System',3579,7302,'NAD83(CSRS) / YT Albers',''),
-(5342,'Coordinate Reference System',3441,7302,'NAD83(HARN) / AR N ftUS',''),
-(5343,'Coordinate Reference System',3442,7302,'NAD83(HARN) / AR S ftUS',''),
-(5344,'Coordinate Reference System',3760,7302,'NAD83(HARN) / HI 3 ftUS',''),
-(5345,'Coordinate Reference System',3443,7302,'NAD83(HARN) / IL E ftUS',''),
-(5346,'Coordinate Reference System',3444,7302,'NAD83(HARN) / IL W ftUS',''),
-(5347,'Coordinate Reference System',3425,7302,'NAD83(HARN) / IA N ftUS',''),
-(5348,'Coordinate Reference System',3426,7302,'NAD83(HARN) / IA S ftUS',''),
-(5349,'Coordinate Reference System',3427,7302,'NAD83(HARN) / KS N ftUS',''),
-(5350,'Coordinate Reference System',3428,7302,'NAD83(HARN) / KS S ftUS',''),
-(5351,'Coordinate Reference System',3456,7302,'NAD83(HARN) / LA N ftUS',''),
-(5352,'Coordinate Reference System',3457,7302,'NAD83(HARN) / LA S ftUS',''),
-(5353,'Coordinate Reference System',26855,7302,'NAD83(HARN) / ME E ftUS',''),
-(5354,'Coordinate Reference System',26856,7302,'NAD83(HARN) / ME W ftUS',''),
+(5342,'Coordinate Reference System',3441,7302,'NAD83(HARN) / AR N (ftUS)',''),
+(5343,'Coordinate Reference System',3442,7302,'NAD83(HARN) / AR S (ftUS)',''),
+(5344,'Coordinate Reference System',3760,7302,'NAD83(HARN) / HI 3 (ftUS)',''),
+(5345,'Coordinate Reference System',3443,7302,'NAD83(HARN) / IL E (ftUS)',''),
+(5346,'Coordinate Reference System',3444,7302,'NAD83(HARN) / IL W (ftUS)',''),
+(5347,'Coordinate Reference System',3425,7302,'NAD83(HARN) / IA N (ftUS)',''),
+(5348,'Coordinate Reference System',3426,7302,'NAD83(HARN) / IA S (ftUS)',''),
+(5349,'Coordinate Reference System',3427,7302,'NAD83(HARN) / KS N (ftUS)',''),
+(5350,'Coordinate Reference System',3428,7302,'NAD83(HARN) / KS S (ftUS)',''),
+(5351,'Coordinate Reference System',3456,7302,'NAD83(HARN) / LA N (ftUS)',''),
+(5352,'Coordinate Reference System',3457,7302,'NAD83(HARN) / LA S (ftUS)',''),
+(5353,'Coordinate Reference System',26855,7302,'NAD83(HARN) / ME E (ftUS)',''),
+(5354,'Coordinate Reference System',26856,7302,'NAD83(HARN) / ME W (ftUS)',''),
 (5355,'Coordinate Reference System',3079,7302,'NAD83(HARN) / MI Georef',''),
-(5356,'Coordinate Reference System',26858,7302,'NAD83(HARN) / MN C ftUS',''),
-(5357,'Coordinate Reference System',26857,7302,'NAD83(HARN) / MN N ftUS',''),
-(5358,'Coordinate Reference System',26859,7302,'NAD83(HARN) / MN S ftUS',''),
+(5356,'Coordinate Reference System',26858,7302,'NAD83(HARN) / MN C (ftUS)',''),
+(5357,'Coordinate Reference System',26857,7302,'NAD83(HARN) / MN N (ftUS)',''),
+(5358,'Coordinate Reference System',26859,7302,'NAD83(HARN) / MN S (ftUS)',''),
 (5359,'Coordinate Reference System',26860,7302,'NAD83(HARN) / NE (ftUS)',''),
-(5360,'Coordinate Reference System',3430,7302,'NAD83(HARN) / NV C ftUS',''),
-(5361,'Coordinate Reference System',3429,7302,'NAD83(HARN) / NV E ftUS',''),
-(5362,'Coordinate Reference System',3431,7302,'NAD83(HARN) / NV W ftUS',''),
+(5360,'Coordinate Reference System',3430,7302,'NAD83(HARN) / NV C (ftUS)',''),
+(5361,'Coordinate Reference System',3429,7302,'NAD83(HARN) / NV E (ftUS)',''),
+(5362,'Coordinate Reference System',3431,7302,'NAD83(HARN) / NV W (ftUS)',''),
 (5363,'Coordinate Reference System',3445,7302,'NAD83(HARN) / NH (ftUS)',''),
 (5364,'Coordinate Reference System',3432,7302,'NAD83(HARN) / NJ (ftUS)',''),
 (5365,'Coordinate Reference System',3358,7302,'NAD83(HARN) / NC (m)',''),
 (5366,'Coordinate Reference System',3404,7302,'NAD83(HARN) / NC (ftUS)',''),
-(5367,'Coordinate Reference System',3753,7302,'NAD83(HARN) / OH N ftUS',''),
-(5368,'Coordinate Reference System',3754,7302,'NAD83(HARN) / OH S ftUS',''),
+(5367,'Coordinate Reference System',3753,7302,'NAD83(HARN) / OH N (ftUS)',''),
+(5368,'Coordinate Reference System',3754,7302,'NAD83(HARN) / OH S (ftUS)',''),
 (5369,'Coordinate Reference System',3362,7302,'NAD83(HARN) / PA N (m)',''),
-(5370,'Coordinate Reference System',3363,7302,'NAD83(HARN) / PA N ftUS',''),
+(5370,'Coordinate Reference System',3363,7302,'NAD83(HARN) / PA N (ftUS)',''),
 (5371,'Coordinate Reference System',3364,7302,'NAD83(HARN) / PA S (m)',''),
-(5372,'Coordinate Reference System',3365,7302,'NAD83(HARN) / PA S ftUS',''),
+(5372,'Coordinate Reference System',3365,7302,'NAD83(HARN) / PA S (ftUS)',''),
 (5373,'Coordinate Reference System',3446,7302,'NAD83(HARN) / RI (ftUS)',''),
 (5374,'Coordinate Reference System',3360,7302,'NAD83(HARN) / SC (m)',''),
 (5375,'Coordinate Reference System',3361,7302,'NAD83(HARN) / SC (ftUS)',''),
-(5376,'Coordinate Reference System',3458,7302,'NAD83(HARN) / SD N ftUS',''),
-(5377,'Coordinate Reference System',3459,7302,'NAD83(HARN) / SD S ftUS',''),
-(5378,'Coordinate Reference System',3569,7302,'NAD83(HARN) / UT C ftUS',''),
-(5379,'Coordinate Reference System',3568,7302,'NAD83(HARN) / UT N ftUS',''),
-(5380,'Coordinate Reference System',3570,7302,'NAD83(HARN) / UT S ftUS',''),
+(5376,'Coordinate Reference System',3458,7302,'NAD83(HARN) / SD N (ftUS)',''),
+(5377,'Coordinate Reference System',3459,7302,'NAD83(HARN) / SD S (ftUS)',''),
+(5378,'Coordinate Reference System',3569,7302,'NAD83(HARN) / UT C (ftUS)',''),
+(5379,'Coordinate Reference System',3568,7302,'NAD83(HARN) / UT N (ftUS)',''),
+(5380,'Coordinate Reference System',3570,7302,'NAD83(HARN) / UT S (ftUS)',''),
 (5381,'Coordinate Reference System',3740,7302,'NAD83(HARN) / UTM 10N',''),
 (5382,'Coordinate Reference System',3741,7302,'NAD83(HARN) / UTM 11N',''),
 (5383,'Coordinate Reference System',3742,7302,'NAD83(HARN) / UTM 12N',''),
@@ -5363,18 +5374,18 @@ INSERT INTO epsg_alias VALUES
 (5390,'Coordinate Reference System',3749,7302,'NAD83(HARN) / UTM 19N',''),
 (5391,'Coordinate Reference System',3750,7302,'NAD83(HARN) / UTM 4N',''),
 (5392,'Coordinate Reference System',3751,7302,'NAD83(HARN) / UTM 5N',''),
-(5393,'Coordinate Reference System',26861,7302,'NAD83(HARN) / WV N ftUS',''),
-(5394,'Coordinate Reference System',26862,7302,'NAD83(HARN) / WV S ftUS',''),
-(5395,'Coordinate Reference System',3755,7302,'NAD83(HARN) / WY E ftUS',''),
-(5396,'Coordinate Reference System',3756,7302,'NAD83(HARN) / WY EC ftUS',''),
-(5397,'Coordinate Reference System',3758,7302,'NAD83(HARN) / WY W ftUS',''),
-(5398,'Coordinate Reference System',3757,7302,'NAD83(HARN) / WY WC ftUS',''),
+(5393,'Coordinate Reference System',26861,7302,'NAD83(HARN) / WV N (ftUS)',''),
+(5394,'Coordinate Reference System',26862,7302,'NAD83(HARN) / WV S (ftUS)',''),
+(5395,'Coordinate Reference System',3755,7302,'NAD83(HARN) / WY E (ftUS)',''),
+(5396,'Coordinate Reference System',3756,7302,'NAD83(HARN) / WY EC (ftUS)',''),
+(5397,'Coordinate Reference System',3758,7302,'NAD83(HARN) / WY W (ftUS)',''),
+(5398,'Coordinate Reference System',3757,7302,'NAD83(HARN) / WY WC (ftUS)',''),
 (5399,'Coordinate Reference System',3757,7301,'NAD83(HPGN) / Wyoming West Central (ftUS)',''),
-(5400,'Coordinate Reference System',3758,7302,'NAD83(HPGN) / Wyoming West (ftUS)',''),
-(5401,'Coordinate Reference System',3756,7302,'NAD83(HPGN) / Wyoming East Central (ftUS)',''),
-(5402,'Coordinate Reference System',3755,7302,'NAD83(HPGN) / Wyoming East (ftUS)',''),
+(5400,'Coordinate Reference System',3758,7301,'NAD83(HPGN) / Wyoming West (ftUS)',''),
+(5401,'Coordinate Reference System',3756,7301,'NAD83(HPGN) / Wyoming East Central (ftUS)',''),
+(5402,'Coordinate Reference System',3755,7301,'NAD83(HPGN) / Wyoming East (ftUS)',''),
 (5403,'Coordinate Reference System',3754,7301,'NAD83(HPGN) / Ohio South (ftUS)',''),
-(5404,'Coordinate Reference System',3753,7302,'NAD83(HPGN) / Ohio North (ftUS)',''),
+(5404,'Coordinate Reference System',3753,7301,'NAD83(HPGN) / Ohio North (ftUS)',''),
 (5405,'Coordinate Reference System',3336,7302,'Kerguelen 62 / UTM 42S',''),
 (5406,'Coordinate Reference System',3337,7302,'Le Pouce 34 / Mauritius',''),
 (5407,'Coordinate Reference System',3339,7302,'IGCB 1955 / Congo TM 12',''),
@@ -5420,25 +5431,25 @@ INSERT INTO epsg_alias VALUES
 (5447,'Coordinate Reference System',3421,7302,'NAD83 / Nevada E (ftUS)',''),
 (5448,'Coordinate Reference System',3422,7302,'NAD83 / Nevada C (ftUS)',''),
 (5449,'Coordinate Reference System',3423,7302,'NAD83 / Nevada W (ftUS)',''),
-(5450,'Coordinate Reference System',3424,7302,'NAD83 / New Jersey ftUS',''),
-(5451,'Coordinate Reference System',3433,7302,'NAD83 / Arkansas N ftUS',''),
-(5452,'Coordinate Reference System',3434,7302,'NAD83 / Arkansas S ftUS',''),
-(5453,'Coordinate Reference System',3435,7302,'NAD83 / Illinois E ftUS',''),
-(5454,'Coordinate Reference System',3436,7302,'NAD83 / Illinois W ftUS',''),
+(5450,'Coordinate_Operation',7807,7301,'IGS08 to NAD83(2011) (1)',''),
+(5451,'Coordinate Reference System',3433,7302,'NAD83 / Arkansas N (ftUS)',''),
+(5452,'Coordinate Reference System',3434,7302,'NAD83 / Arkansas S (ftUS)',''),
+(5453,'Coordinate Reference System',3435,7302,'NAD83 / Illinois E (ftUS)',''),
+(5454,'Coordinate Reference System',3436,7302,'NAD83 / Illinois W (ftUS)',''),
 (5455,'Coordinate Reference System',3437,7302,'NAD83 / NH (ftUS)',''),
 (5456,'Coordinate Reference System',3438,7302,'NAD83 / RI (ftUS)',''),
 (5457,'Coordinate Reference System',3448,7302,'JAD2001 / JA Metric Grid',''),
-(5458,'Coordinate Reference System',3451,7302,'NAD83 / Louisiana N ftUS',''),
-(5459,'Coordinate Reference System',3452,7302,'NAD83 / Louisiana S ftUS',''),
-(5460,'Coordinate Reference System',3453,7302,'NAD83 / LA Offshore ftUS',''),
+(5458,'Coordinate Reference System',3451,7302,'NAD83 / Louisiana N (ftUS)',''),
+(5459,'Coordinate Reference System',3452,7302,'NAD83 / Louisiana S (ftUS)',''),
+(5460,'Coordinate Reference System',3453,7302,'NAD83 / LA Offshore (ftUS)',''),
 (5461,'Coordinate Reference System',3454,7302,'NAD83 / S Dakota N ftUS',''),
-(5462,'Coordinate Reference System',3455,7302,'NAD83 / S Dakota S ftUS',''),
+(5462,'Coordinate Reference System',3455,7302,'NAD83 / S Dakota S (ftUS)',''),
 (5463,'Coordinate Reference System',3460,7302,'Fiji 1986 / Map Grid',''),
 (5464,'Coordinate Reference System',3461,7302,'Dabola 1981 / UTM 28N',''),
 (5465,'Coordinate Reference System',3462,7302,'Dabola 1981 / UTM 29N',''),
-(5466,'Coordinate Reference System',3560,7302,'NAD83 / Utah North ftUS',''),
-(5467,'Coordinate Reference System',3566,7302,'NAD83 / Utah Cen ftUS',''),
-(5468,'Coordinate Reference System',3567,7302,'NAD83 / Utah South ftUS',''),
+(5466,'Coordinate Reference System',3560,7302,'NAD83 / Utah North (ftUS)',''),
+(5467,'Coordinate Reference System',3566,7302,'NAD83 / Utah Cen (ftUS)',''),
+(5468,'Coordinate Reference System',3567,7302,'NAD83 / Utah South (ftUS)',''),
 (5469,'Coordinate Reference System',3571,7302,'WGS 84 / LAEA Bering Sea',''),
 (5470,'Coordinate Reference System',3572,7302,'WGS 84 / LAEA Alaska',''),
 (5471,'Coordinate Reference System',3573,7302,'WGS 84 / LAEA Canada',''),
@@ -5470,8 +5481,8 @@ INSERT INTO epsg_alias VALUES
 (5497,'Coordinate Reference System',3734,7302,'NAD83 / Ohio N (ftUS)',''),
 (5498,'Coordinate Reference System',3735,7302,'NAD83 / Ohio S (ftUS)',''),
 (5499,'Coordinate Reference System',3736,7302,'NAD83 / Wyoming E (ftUS)',''),
-(5500,'Coordinate Reference System',3737,7302,'NAD83 / Wyoming EC ftUS',''),
-(5501,'Coordinate Reference System',3738,7302,'NAD83 / Wyoming WC ftUS',''),
+(5500,'Coordinate Reference System',3737,7302,'NAD83 / Wyoming EC (ftUS)',''),
+(5501,'Coordinate Reference System',3738,7302,'NAD83 / Wyoming WC (ftUS)',''),
 (5502,'Coordinate Reference System',3739,7302,'NAD83 / Wyoming W (ftUS)',''),
 (5503,'Coordinate Reference System',3759,7302,'NAD83 / Hawaii 3 (ftUS)',''),
 (5504,'Coordinate Reference System',3762,7302,'WGS 84 / S Georgia LCC',''),
@@ -5543,9 +5554,9 @@ INSERT INTO epsg_alias VALUES
 (5570,'Coordinate Reference System',23845,7302,'DGN95 / Indonesia 54.1',''),
 (5571,'Coordinate Reference System',26847,7302,'NAD83 / Maine E (ftUS)',''),
 (5572,'Coordinate Reference System',26848,7302,'NAD83 / Maine W (ftUS)',''),
-(5573,'Coordinate Reference System',26849,7302,'NAD83 / Minnesota N ftUS',''),
-(5574,'Coordinate Reference System',26850,7302,'NAD83 / Minnesota C ftUS',''),
-(5575,'Coordinate Reference System',26851,7302,'NAD83 / Minnesota S ftUS',''),
+(5573,'Coordinate Reference System',26849,7302,'NAD83 / Minnesota N (ftUS)',''),
+(5574,'Coordinate Reference System',26850,7302,'NAD83 / Minnesota C (ftUS)',''),
+(5575,'Coordinate Reference System',26851,7302,'NAD83 / Minnesota S (ftUS)',''),
 (5576,'Coordinate Reference System',26853,7302,'NAD83 / WV North (ftUS)',''),
 (5577,'Coordinate Reference System',26854,7302,'NAD83 / WV South (ftUS)',''),
 (5578,'Coordinate Reference System',27037,7302,'Nahrwan 1967 / UTM 37N',''),
@@ -5613,9 +5624,9 @@ INSERT INTO epsg_alias VALUES
 (5640,'Coordinate Reference System',3465,7302,'NAD83(NSRS) / AL E (m)',''),
 (5641,'Coordinate Reference System',3466,7302,'NAD83(NSRS) / AL W (m)',''),
 (5642,'Coordinate Reference System',3484,7302,'NAD83(NSRS) / AR N (m)',''),
-(5643,'Coordinate Reference System',3485,7302,'NAD83(NSRS) / AR N ftUS',''),
+(5643,'Coordinate Reference System',3485,7302,'NAD83(NSRS) / AR N (ftUS)',''),
 (5644,'Coordinate Reference System',3486,7302,'NAD83(NSRS) / AR S (m)',''),
-(5645,'Coordinate Reference System',3487,7302,'NAD83(NSRS) / AR S ftUS',''),
+(5645,'Coordinate Reference System',3487,7302,'NAD83(NSRS) / AR S (ftUS)',''),
 (5646,'Coordinate Reference System',3479,7302,'NAD83(NSRS) / AZ C (ft)',''),
 (5647,'Coordinate Reference System',3478,7302,'NAD83(NSRS) / AZ C (m)',''),
 (5648,'Coordinate Reference System',3481,7302,'NAD83(NSRS) / AZ E (ft)',''),
@@ -5623,78 +5634,78 @@ INSERT INTO epsg_alias VALUES
 (5650,'Coordinate Reference System',3483,7302,'NAD83(NSRS) / AZ W (ft)',''),
 (5651,'Coordinate Reference System',3482,7302,'NAD83(NSRS) / AZ W (m)',''),
 (5652,'Coordinate Reference System',3489,7302,'NAD83(NSRS) / CA 1 (m)',''),
-(5653,'Coordinate Reference System',3490,7302,'NAD83(NSRS) / CA 1 ftUS',''),
+(5653,'Coordinate Reference System',3490,7302,'NAD83(NSRS) / CA 1 (ftUS)',''),
 (5654,'Coordinate Reference System',3491,7302,'NAD83(NSRS) / CA 2 (m)',''),
-(5655,'Coordinate Reference System',3492,7302,'NAD83(NSRS) / CA 2 ftUS',''),
+(5655,'Coordinate Reference System',3492,7302,'NAD83(NSRS) / CA 2 (ftUS)',''),
 (5656,'Coordinate Reference System',3493,7302,'NAD83(NSRS) / CA 3 (m)',''),
-(5657,'Coordinate Reference System',3494,7302,'NAD83(NSRS) / CA 3 ftUS',''),
+(5657,'Coordinate Reference System',3494,7302,'NAD83(NSRS) / CA 3 (ftUS)',''),
 (5658,'Coordinate Reference System',3495,7302,'NAD83(NSRS) / CA 4 (m)',''),
-(5659,'Coordinate Reference System',3496,7302,'NAD83(NSRS) / CA 4 ftUS',''),
+(5659,'Coordinate Reference System',3496,7302,'NAD83(NSRS) / CA 4 (ftUS)',''),
 (5660,'Coordinate Reference System',3497,7302,'NAD83(NSRS) / CA 5 (m)',''),
-(5661,'Coordinate Reference System',3498,7302,'NAD83(NSRS) / CA 5 ftUS',''),
+(5661,'Coordinate Reference System',3498,7302,'NAD83(NSRS) / CA 5 (ftUS)',''),
 (5662,'Coordinate Reference System',3499,7302,'NAD83(NSRS) / CA 6 (m)',''),
-(5663,'Coordinate Reference System',3500,7302,'NAD83(NSRS) / CA 6 ftUS',''),
+(5663,'Coordinate Reference System',3500,7302,'NAD83(NSRS) / CA 6 (ftUS)',''),
 (5664,'Coordinate Reference System',3488,7302,'NAD83(NSRS) / CA Albers',''),
 (5665,'Coordinate Reference System',3501,7302,'NAD83(NSRS) / CO C (m)',''),
-(5666,'Coordinate Reference System',3502,7302,'NAD83(NSRS) / CO C ftUS',''),
+(5666,'Coordinate Reference System',3502,7302,'NAD83(NSRS) / CO C (ftUS)',''),
 (5667,'Coordinate Reference System',3503,7302,'NAD83(NSRS) / CO N (m)',''),
-(5668,'Coordinate Reference System',3504,7302,'NAD83(NSRS) / CO N ftUS',''),
+(5668,'Coordinate Reference System',3504,7302,'NAD83(NSRS) / CO N (ftUS)',''),
 (5669,'Coordinate Reference System',3505,7302,'NAD83(NSRS) / CO S (m)',''),
-(5670,'Coordinate Reference System',3506,7302,'NAD83(NSRS) / CO S ftUS',''),
+(5670,'Coordinate Reference System',3506,7302,'NAD83(NSRS) / CO S (ftUS)',''),
 (5671,'Coordinate Reference System',3508,7302,'NAD83(NSRS) / CT (ftUS)',''),
 (5672,'Coordinate Reference System',3507,7302,'NAD83(NSRS) / CT (m)',''),
 (5673,'Coordinate Reference System',3510,7302,'NAD83(NSRS) / DE (ftUS)',''),
 (5674,'Coordinate Reference System',3511,7302,'NAD83(NSRS) / FL E (m)',''),
-(5675,'Coordinate Reference System',3512,7302,'NAD83(NSRS) / FL E ftUS',''),
+(5675,'Coordinate Reference System',3512,7302,'NAD83(NSRS) / FL E (ftUS)',''),
 (5676,'Coordinate Reference System',3513,7302,'NAD83(NSRS) / FL GDL AEA',''),
 (5677,'Coordinate Reference System',3514,7302,'NAD83(NSRS) / FL N (m)',''),
-(5678,'Coordinate Reference System',3515,7302,'NAD83(NSRS) / FL N ftUS',''),
+(5678,'Coordinate Reference System',3515,7302,'NAD83(NSRS) / FL N (ftUS)',''),
 (5679,'Coordinate Reference System',3516,7302,'NAD83(NSRS) / FL W (m)',''),
-(5680,'Coordinate Reference System',3517,7302,'NAD83(NSRS) / FL W ftUS',''),
+(5680,'Coordinate Reference System',3517,7302,'NAD83(NSRS) / FL W (ftUS)',''),
 (5681,'Coordinate Reference System',3518,7302,'NAD83(NSRS) / GA E (m)',''),
-(5682,'Coordinate Reference System',3519,7302,'NAD83(NSRS) / GA E ftUS',''),
+(5682,'Coordinate Reference System',3519,7302,'NAD83(NSRS) / GA E (ftUS)',''),
 (5683,'Coordinate Reference System',3520,7302,'NAD83(NSRS) / GA W (m)',''),
-(5684,'Coordinate Reference System',3521,7302,'NAD83(NSRS) / GA W ftUS',''),
-(5685,'Coordinate Reference System',3537,7302,'NAD83(NSRS) / IA N ftUS',''),
-(5686,'Coordinate Reference System',3539,7302,'NAD83(NSRS) / IA S ftUS',''),
+(5684,'Coordinate Reference System',3521,7302,'NAD83(NSRS) / GA W (ftUS)',''),
+(5685,'Coordinate Reference System',3537,7302,'NAD83(NSRS) / IA N (ftUS)',''),
+(5686,'Coordinate Reference System',3539,7302,'NAD83(NSRS) / IA S (ftUS)',''),
 (5687,'Coordinate Reference System',3522,7302,'NAD83(NSRS) / ID C (m)',''),
-(5688,'Coordinate Reference System',3523,7302,'NAD83(NSRS) / ID C ftUS',''),
-(5689,'Coordinate Reference System',3525,7302,'NAD83(NSRS) / ID E ftUS',''),
-(5690,'Coordinate Reference System',3527,7302,'NAD83(NSRS) / ID W ftUS',''),
+(5688,'Coordinate Reference System',3523,7302,'NAD83(NSRS) / ID C (ftUS)',''),
+(5689,'Coordinate Reference System',3525,7302,'NAD83(NSRS) / ID E (ftUS)',''),
+(5690,'Coordinate Reference System',3527,7302,'NAD83(NSRS) / ID W (ftUS)',''),
 (5691,'Coordinate Reference System',3528,7302,'NAD83(NSRS) / IL E (m)',''),
-(5692,'Coordinate Reference System',3529,7302,'NAD83(NSRS) / IL E ftUS',''),
+(5692,'Coordinate Reference System',3529,7302,'NAD83(NSRS) / IL E (ftUS)',''),
 (5693,'Coordinate Reference System',3530,7302,'NAD83(NSRS) / IL W (m)',''),
-(5694,'Coordinate Reference System',3531,7302,'NAD83(NSRS) / IL W ftUS',''),
+(5694,'Coordinate Reference System',3531,7302,'NAD83(NSRS) / IL W (ftUS)',''),
 (5695,'Coordinate Reference System',3532,7302,'NAD83(NSRS) / IN E (m)',''),
-(5696,'Coordinate Reference System',3533,7302,'NAD83(NSRS) / IN E ftUS',''),
+(5696,'Coordinate Reference System',3533,7302,'NAD83(NSRS) / IN E (ftUS)',''),
 (5697,'Coordinate Reference System',3534,7302,'NAD83(NSRS) / IN W (m)',''),
-(5698,'Coordinate Reference System',3535,7302,'NAD83(NSRS) / IN W ftUS',''),
+(5698,'Coordinate Reference System',3535,7302,'NAD83(NSRS) / IN W (ftUS)',''),
 (5699,'Coordinate Reference System',3540,7302,'NAD83(NSRS) / KS N (m)',''),
-(5700,'Coordinate Reference System',3541,7302,'NAD83(NSRS) / KS N ftUS',''),
+(5700,'Coordinate Reference System',3541,7302,'NAD83(NSRS) / KS N (ftUS)',''),
 (5701,'Coordinate Reference System',3542,7302,'NAD83(NSRS) / KS S (m)',''),
-(5702,'Coordinate Reference System',3543,7302,'NAD83(NSRS) / KS S ftUS',''),
+(5702,'Coordinate Reference System',3543,7302,'NAD83(NSRS) / KS S (ftUS)',''),
 (5703,'Coordinate Reference System',3544,7302,'NAD83(NSRS) / KY N (m)',''),
-(5704,'Coordinate Reference System',3545,7302,'NAD83(NSRS) / KY N ftUS',''),
+(5704,'Coordinate Reference System',3545,7302,'NAD83(NSRS) / KY N (ftUS)',''),
 (5705,'Coordinate Reference System',3548,7302,'NAD83(NSRS) / KY S (m)',''),
-(5706,'Coordinate Reference System',3549,7302,'NAD83(NSRS) / KY S ftUS',''),
+(5706,'Coordinate Reference System',3549,7302,'NAD83(NSRS) / KY S (ftUS)',''),
 (5707,'Coordinate Reference System',3546,7302,'NAD83(NSRS) / KY1Z (m)',''),
 (5708,'Coordinate_Operation',4323,7302,'Kelantan Grid',''),
 (5709,'Coordinate Reference System',3550,7302,'NAD83(NSRS) / LA N (m)',''),
-(5710,'Coordinate Reference System',3551,7302,'NAD83(NSRS) / LA N ftUS',''),
+(5710,'Coordinate Reference System',3551,7302,'NAD83(NSRS) / LA N (ftUS)',''),
 (5711,'Coordinate Reference System',3552,7302,'NAD83(NSRS) / LA S (m)',''),
-(5712,'Coordinate Reference System',3553,7302,'NAD83(NSRS) / LA S ftUS',''),
+(5712,'Coordinate Reference System',3553,7302,'NAD83(NSRS) / LA S (ftUS)',''),
 (5713,'Coordinate Reference System',3583,7302,'NAD83(NSRS) / MA Is (m)',''),
-(5714,'Coordinate Reference System',3584,7302,'NAD83(NSRS) / MA Is ftUS',''),
+(5714,'Coordinate Reference System',3584,7302,'NAD83(NSRS) / MA Is (ftUS)',''),
 (5715,'Coordinate Reference System',3585,7302,'NAD83(NSRS) / MA md (m)',''),
-(5716,'Coordinate Reference System',3586,7302,'NAD83(NSRS) / MA md ftUS',''),
+(5716,'Coordinate Reference System',3586,7302,'NAD83(NSRS) / MA md (ftUS)',''),
 (5717,'Coordinate Reference System',3582,7302,'NAD83(NSRS) / MD (ftUS)',''),
 (5718,'Coordinate Reference System',3554,7302,'NAD83(NSRS) / ME 2000 C',''),
 (5719,'Coordinate Reference System',3555,7302,'NAD83(NSRS) / ME 2000 E',''),
 (5720,'Coordinate Reference System',3556,7302,'NAD83(NSRS) / ME 2000 W',''),
 (5721,'Coordinate Reference System',3557,7302,'NAD83(NSRS) / ME83 E (m)',''),
-(5722,'Coordinate Reference System',26863,7302,'NAD83(NSRS) / ME E ftUS',''),
+(5722,'Coordinate Reference System',26863,7302,'NAD83(NSRS) / ME E (ftUS)',''),
 (5723,'Coordinate Reference System',3558,7302,'NAD83(NSRS) / ME83 W (m)',''),
-(5724,'Coordinate Reference System',26864,7302,'NAD83(NSRS) / ME W ftUS',''),
+(5724,'Coordinate Reference System',26864,7302,'NAD83(NSRS) / ME W (ftUS)',''),
 (5725,'Coordinate Reference System',3588,7302,'NAD83(NSRS) / MI C (ft)',''),
 (5726,'Coordinate Reference System',3587,7302,'NAD83(NSRS) / MI C (m)',''),
 (5727,'Coordinate Reference System',3591,7302,'NAD83(NSRS) / MI Georef',''),
@@ -5703,18 +5714,18 @@ INSERT INTO epsg_alias VALUES
 (5730,'Coordinate Reference System',3593,7302,'NAD83(NSRS) / MI S (ft)',''),
 (5731,'Coordinate Reference System',3592,7302,'NAD83(NSRS) / MI S (m)',''),
 (5732,'Coordinate Reference System',3594,7302,'NAD83(NSRS) / MN C (m)',''),
-(5733,'Coordinate Reference System',26866,7302,'NAD83(NSRS) / MN C ftUS',''),
+(5733,'Coordinate Reference System',26866,7302,'NAD83(NSRS) / MN C (ftUS)',''),
 (5734,'Coordinate Reference System',3595,7302,'NAD83(NSRS) / MN N (m)',''),
-(5735,'Coordinate Reference System',26865,7302,'NAD83(NSRS) / MN N ftUS',''),
+(5735,'Coordinate Reference System',26865,7302,'NAD83(NSRS) / MN N (ftUS)',''),
 (5736,'Coordinate Reference System',3596,7302,'NAD83(NSRS) / MN S (m)',''),
-(5737,'Coordinate Reference System',26867,7302,'NAD83(NSRS) / MN S ftUS',''),
+(5737,'Coordinate Reference System',26867,7302,'NAD83(NSRS) / MN S (ftUS)',''),
 (5738,'Coordinate Reference System',3601,7302,'NAD83(NSRS) / MO C (m)',''),
 (5739,'Coordinate Reference System',3602,7302,'NAD83(NSRS) / MO E (m)',''),
 (5740,'Coordinate Reference System',3603,7302,'NAD83(NSRS) / MO W (m)',''),
 (5741,'Coordinate Reference System',3597,7302,'NAD83(NSRS) / MS E (m)',''),
-(5742,'Coordinate Reference System',3598,7302,'NAD83(NSRS) / MS E ftUS',''),
+(5742,'Coordinate Reference System',3598,7302,'NAD83(NSRS) / MS E (ftUS)',''),
 (5743,'Coordinate Reference System',3599,7302,'NAD83(NSRS) / MS W (m)',''),
-(5744,'Coordinate Reference System',3600,7302,'NAD83(NSRS) / MS W ftUS',''),
+(5744,'Coordinate Reference System',3600,7302,'NAD83(NSRS) / MS W (ftUS)',''),
 (5745,'Coordinate Reference System',3816,7302,'NAD83(NSRS) / MSTM',''),
 (5746,'Coordinate Reference System',3605,7302,'NAD83(NSRS) / MT (ft)',''),
 (5747,'Coordinate Reference System',3632,7302,'NAD83(NSRS) / NC (ftUS)',''),
@@ -5729,49 +5740,49 @@ INSERT INTO epsg_alias VALUES
 (5756,'Coordinate Reference System',3613,7302,'NAD83(NSRS) / NH (m)',''),
 (5757,'Coordinate Reference System',3616,7302,'NAD83(NSRS) / NJ (ftUS)',''),
 (5758,'Coordinate Reference System',3617,7302,'NAD83(NSRS) / NM C (m)',''),
-(5759,'Coordinate Reference System',3618,7302,'NAD83(NSRS) / NM C ftUS',''),
+(5759,'Coordinate Reference System',3618,7302,'NAD83(NSRS) / NM C (ftUS)',''),
 (5760,'Coordinate Reference System',3619,7302,'NAD83(NSRS) / NM E (m)',''),
-(5761,'Coordinate Reference System',3620,7302,'NAD83(NSRS) / NM E ftUS',''),
+(5761,'Coordinate Reference System',3620,7302,'NAD83(NSRS) / NM E (ftUS)',''),
 (5762,'Coordinate Reference System',3621,7302,'NAD83(NSRS) / NM W (m)',''),
-(5763,'Coordinate Reference System',3622,7302,'NAD83(NSRS) / NM W ftUS',''),
+(5763,'Coordinate Reference System',3622,7302,'NAD83(NSRS) / NM W (ftUS)',''),
 (5764,'Coordinate Reference System',3607,7302,'NAD83(NSRS) / NV C (m)',''),
-(5765,'Coordinate Reference System',3608,7302,'NAD83(NSRS) / NV C ftUS',''),
+(5765,'Coordinate Reference System',3608,7302,'NAD83(NSRS) / NV C (ftUS)',''),
 (5766,'Coordinate Reference System',3609,7302,'NAD83(NSRS) / NV E (m)',''),
-(5767,'Coordinate Reference System',3610,7302,'NAD83(NSRS) / NV E ftUS',''),
+(5767,'Coordinate Reference System',3610,7302,'NAD83(NSRS) / NV E (ftUS)',''),
 (5768,'Coordinate Reference System',3611,7302,'NAD83(NSRS) / NV W (m)',''),
-(5769,'Coordinate Reference System',3612,7302,'NAD83(NSRS) / NV W ftUS',''),
+(5769,'Coordinate Reference System',3612,7302,'NAD83(NSRS) / NV W (ftUS)',''),
 (5770,'Coordinate Reference System',3623,7302,'NAD83(NSRS) / NY C (m)',''),
-(5771,'Coordinate Reference System',3624,7302,'NAD83(NSRS) / NY C ftUS',''),
+(5771,'Coordinate Reference System',3624,7302,'NAD83(NSRS) / NY C (ftUS)',''),
 (5772,'Coordinate Reference System',3625,7302,'NAD83(NSRS) / NY E (m)',''),
-(5773,'Coordinate Reference System',3626,7302,'NAD83(NSRS) / NY E ftUS',''),
+(5773,'Coordinate Reference System',3626,7302,'NAD83(NSRS) / NY E (ftUS)',''),
 (5774,'Coordinate Reference System',3627,7302,'NAD83(NSRS) / NY LI (m)',''),
-(5775,'Coordinate Reference System',3628,7302,'NAD83(NSRS) / NY LI ftUS',''),
+(5775,'Coordinate Reference System',3628,7302,'NAD83(NSRS) / NY LI (ftUS)',''),
 (5776,'Coordinate Reference System',3629,7302,'NAD83(NSRS) / NY W (m)',''),
-(5777,'Coordinate Reference System',3630,7302,'NAD83(NSRS) / NY W ftUS',''),
-(5778,'Coordinate Reference System',3728,7302,'NAD83(NSRS) / OH N ftUS',''),
-(5779,'Coordinate Reference System',3729,7302,'NAD83(NSRS) / OH S ftUS',''),
+(5777,'Coordinate Reference System',3630,7302,'NAD83(NSRS) / NY W (ftUS)',''),
+(5778,'Coordinate Reference System',3728,7302,'NAD83(NSRS) / OH N (ftUS)',''),
+(5779,'Coordinate Reference System',3729,7302,'NAD83(NSRS) / OH S (ftUS)',''),
 (5780,'Coordinate Reference System',3639,7302,'NAD83(NSRS) / OK N (m)',''),
-(5781,'Coordinate Reference System',3640,7302,'NAD83(NSRS) / OK N ftUS',''),
+(5781,'Coordinate Reference System',3640,7302,'NAD83(NSRS) / OK N (ftUS)',''),
 (5782,'Coordinate Reference System',3641,7302,'NAD83(NSRS) / OK S (m)',''),
-(5783,'Coordinate Reference System',3642,7302,'NAD83(NSRS) / OK S ftUS',''),
+(5783,'Coordinate Reference System',3642,7302,'NAD83(NSRS) / OK S (ftUS)',''),
 (5784,'Coordinate Reference System',3646,7302,'NAD83(NSRS) / OR N (ft)',''),
 (5785,'Coordinate Reference System',3645,7302,'NAD83(NSRS) / OR N (m)',''),
 (5786,'Coordinate Reference System',3648,7302,'NAD83(NSRS) / OR S (ft)',''),
 (5787,'Coordinate Reference System',3647,7302,'NAD83(NSRS) / OR S (m)',''),
-(5788,'Coordinate Reference System',3644,7302,'NAD83(2007) / OR GIC Lam ft',''),
+(5788,'Coordinate Reference System',3644,7302,'NAD83(2007) / OR GIC Lam (ft)',''),
 (5789,'Coordinate_Operation',4116,7302,'Pahang Grid',''),
 (5790,'Coordinate Reference System',3649,7302,'NAD83(NSRS) / PA N (m)',''),
-(5791,'Coordinate Reference System',3650,7302,'NAD83(NSRS) / PA N ftUS',''),
+(5791,'Coordinate Reference System',3650,7302,'NAD83(NSRS) / PA N (ftUS)',''),
 (5792,'Coordinate Reference System',3651,7302,'NAD83(NSRS) / PA S (m)',''),
-(5793,'Coordinate Reference System',3652,7302,'NAD83(NSRS) / PA S ftUS',''),
+(5793,'Coordinate Reference System',3652,7302,'NAD83(NSRS) / PA S (ftUS)',''),
 (5794,'Coordinate Reference System',3654,7302,'NAD83(NSRS) / RI (ftUS)',''),
 (5795,'Coordinate Reference System',3653,7302,'NAD83(NSRS) / RI (m)',''),
 (5796,'Coordinate Reference System',3656,7302,'NAD83(NSRS) / SC (ft)',''),
 (5797,'Coordinate Reference System',3655,7302,'NAD83(NSRS) / SC (m)',''),
 (5798,'Coordinate Reference System',3657,7302,'NAD83(NSRS) / SD N (m)',''),
-(5799,'Coordinate Reference System',3658,7302,'NAD83(NSRS) / SD N ftUS',''),
+(5799,'Coordinate Reference System',3658,7302,'NAD83(NSRS) / SD N (ftUS)',''),
 (5800,'Coordinate Reference System',3659,7302,'NAD83(NSRS) / SD S (m)',''),
-(5801,'Coordinate Reference System',3660,7302,'NAD83(NSRS) / SD S ftUS',''),
+(5801,'Coordinate Reference System',3660,7302,'NAD83(NSRS) / SD S (ftUS)',''),
 (5802,'Coordinate Reference System',3662,7302,'NAD83(NSRS) / TN (ftUS)',''),
 (5803,'Coordinate Reference System',3663,7302,'NAD83(NSRS) / TX C (m)',''),
 (5804,'Coordinate Reference System',3664,7302,'NAD83(NSRS) / TX C ftUS',''),
@@ -5785,38 +5796,38 @@ INSERT INTO epsg_alias VALUES
 (5812,'Coordinate Reference System',3674,7302,'NAD83(NSRS) / TX SC ftUS',''),
 (5813,'Coordinate Reference System',3676,7302,'NAD83(NSRS) / UT C (ft)',''),
 (5814,'Coordinate Reference System',3675,7302,'NAD83(NSRS) / UT C (m)',''),
-(5815,'Coordinate Reference System',3677,7302,'NAD83(NSRS) / UT C ftUS',''),
+(5815,'Coordinate Reference System',3677,7302,'NAD83(NSRS) / UT C (ftUS)',''),
 (5816,'Coordinate Reference System',3679,7302,'NAD83(NSRS) / UT N (ft)',''),
-(5817,'Coordinate Reference System',3680,7302,'NAD83(NSRS) / UT N ftUS',''),
+(5817,'Coordinate Reference System',3680,7302,'NAD83(NSRS) / UT N (ftUS)',''),
 (5818,'Coordinate Reference System',3682,7302,'NAD83(NSRS) / UT S (ft)',''),
-(5819,'Coordinate Reference System',3683,7302,'NAD83(NSRS) / UT S ftUS',''),
+(5819,'Coordinate Reference System',3683,7302,'NAD83(NSRS) / UT S (ftUS)',''),
 (5820,'Coordinate Reference System',3685,7302,'NAD83(NSRS) / VA N (m)',''),
-(5821,'Coordinate Reference System',3686,7302,'NAD83(NSRS) / VA N ftUS',''),
+(5821,'Coordinate Reference System',3686,7302,'NAD83(NSRS) / VA N (ftUS)',''),
 (5822,'Coordinate Reference System',3687,7302,'NAD83(NSRS) / VA S (m)',''),
-(5823,'Coordinate Reference System',3688,7302,'NAD83(NSRS) / VA S ftUS',''),
+(5823,'Coordinate Reference System',3688,7302,'NAD83(NSRS) / VA S (ftUS)',''),
 (5824,'Coordinate Reference System',3689,7302,'NAD83(NSRS) / WA N (m)',''),
-(5825,'Coordinate Reference System',3690,7302,'NAD83(NSRS) / WA N ftUS',''),
+(5825,'Coordinate Reference System',3690,7302,'NAD83(NSRS) / WA N (ftUS)',''),
 (5826,'Coordinate Reference System',3691,7302,'NAD83(NSRS) / WA S (m)',''),
-(5827,'Coordinate Reference System',3692,7302,'NAD83(NSRS) / WA S ftUS',''),
+(5827,'Coordinate Reference System',3692,7302,'NAD83(NSRS) / WA S (ftUS)',''),
 (5828,'Coordinate Reference System',3695,7302,'NAD83(NSRS) / WI C (m)',''),
-(5829,'Coordinate Reference System',3696,7302,'NAD83(NSRS) / WI C ftUS',''),
+(5829,'Coordinate Reference System',3696,7302,'NAD83(NSRS) / WI C (ftUS)',''),
 (5830,'Coordinate Reference System',3697,7302,'NAD83(NSRS) / WI N (m)',''),
-(5831,'Coordinate Reference System',3698,7302,'NAD83(NSRS) / WI N ftUS',''),
+(5831,'Coordinate Reference System',3698,7302,'NAD83(NSRS) / WI N (ftUS)',''),
 (5832,'Coordinate Reference System',3699,7302,'NAD83(NSRS) / WI S (m)',''),
-(5833,'Coordinate Reference System',3700,7302,'NAD83(NSRS) / WI S ftUS',''),
+(5833,'Coordinate Reference System',3700,7302,'NAD83(NSRS) / WI S (ftUS)',''),
 (5834,'Coordinate Reference System',3701,7302,'NAD83(NSRS) / WTM 83',''),
 (5835,'Coordinate Reference System',3693,7302,'NAD83(NSRS) / WV N (m)',''),
-(5836,'Coordinate Reference System',26869,7302,'NAD83(NSRS) / WV N ftUS',''),
+(5836,'Coordinate Reference System',26869,7302,'NAD83(NSRS) / WV N (ftUS)',''),
 (5837,'Coordinate Reference System',3694,7302,'NAD83(NSRS) / WV S (m)',''),
-(5838,'Coordinate Reference System',26870,7302,'NAD83(NSRS) / WV S ftUS',''),
+(5838,'Coordinate Reference System',26870,7302,'NAD83(NSRS) / WV S (ftUS)',''),
 (5839,'Coordinate Reference System',3702,7302,'NAD83(NSRS) / WY E (m)',''),
-(5840,'Coordinate Reference System',3730,7302,'NAD83(NSRS) / WY E ftUS',''),
+(5840,'Coordinate Reference System',3730,7302,'NAD83(NSRS) / WY E (ftUS)',''),
 (5841,'Coordinate Reference System',3703,7302,'NAD83(NSRS) / WY EC (m)',''),
-(5842,'Coordinate Reference System',3731,7302,'NAD83(NSRS) / WY EC ftUS',''),
+(5842,'Coordinate Reference System',3731,7302,'NAD83(NSRS) / WY EC (ftUS)',''),
 (5843,'Coordinate Reference System',3705,7302,'NAD83(NSRS) / WY W (m)',''),
-(5844,'Coordinate Reference System',3733,7302,'NAD83(NSRS) / WY W ftUS',''),
+(5844,'Coordinate Reference System',3733,7302,'NAD83(NSRS) / WY W (ftUS)',''),
 (5845,'Coordinate Reference System',3704,7302,'NAD83(NSRS) / WY WC (m)',''),
-(5846,'Coordinate Reference System',3732,7302,'NAD83(NSRS) / WY WC ftUS',''),
+(5846,'Coordinate Reference System',3732,7302,'NAD83(NSRS) / WY WC (ftUS)',''),
 (5847,'Coordinate Reference System',3467,7302,'NAD83(NSRS) / AK Alb',''),
 (5848,'Coordinate Reference System',3468,7302,'NAD83(NSRS) / AK 1 (m)',''),
 (5849,'Coordinate Reference System',3469,7302,'NAD83(NSRS) / AK 2 (m)',''),
@@ -6958,6 +6969,7 @@ INSERT INTO epsg_alias VALUES
 (6985,'Coordinate Reference System',7608,7301,'NAD83(2011) / WISCRS Green (ftUS)',''),
 (6986,'Coordinate Reference System',7608,7301,'NAD83(2011) / WISCRS Lafayette (ftUS)',''),
 (6987,'Coordinate Reference System',7598,7302,'WISCRS Crawford (ftUS)',''),
+(6988,'Datum',1152,7302,'WGS 84 (G730)',''),
 (6989,'Coordinate Reference System',7599,7302,'WISCRS Dane (ftUS)',''),
 (6990,'Coordinate Reference System',7623,7302,'WISCRS Oneida (ftUS)',''),
 (6991,'Coordinate Reference System',7634,7302,'WISCRS St. Croix (ftUS)',''),
@@ -6975,6 +6987,7 @@ INSERT INTO epsg_alias VALUES
 (7003,'Coordinate Reference System',7611,7302,'WISCRS Iron (ftUS)',''),
 (7004,'Coordinate Reference System',7624,7301,'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)',''),
 (7008,'Coordinate Reference System',7635,7302,'WISCRS Taylor (ftUS)',''),
 (7009,'Coordinate Reference System',7626,7302,'WISCRS Portage (ftUS)',''),
@@ -6987,6 +7000,7 @@ INSERT INTO epsg_alias VALUES
 (7016,'Coordinate Reference System',7627,7302,'WISCRS Price (ftUS)',''),
 (7017,'Coordinate Reference System',7636,7302,'WISCRS Trempealeau (ftUS)',''),
 (7018,'Coordinate Reference System',7628,7302,'WISCRS Richland (ftUS)',''),
+(7019,'Datum',1154,7302,'WGS 84 (G1150)',''),
 (7020,'Coordinate Reference System',7629,7302,'WISCRS Rock (ftUS)',''),
 (7021,'Coordinate Reference System',7614,7302,'WISCRS Kew-Manit-Sheb (ftUS)',''),
 (7022,'Coordinate Reference System',7614,7301,'NAD83(2011) / WISCRS Kewaunee (ftUS)',''),
@@ -7001,6 +7015,7 @@ INSERT INTO epsg_alias VALUES
 (7031,'Coordinate Reference System',7617,7302,'WISCRS Lincoln (ftUS)',''),
 (7032,'Coordinate Reference System',7638,7302,'WISCRS Vilas (ftUS)',''),
 (7033,'Coordinate Reference System',7618,7302,'WISCRS Marathon (ftUS)',''),
+(7034,'Datum',1155,7302,'WGS 84 (G1674)',''),
 (7035,'Coordinate Reference System',4093,7301,'ETRF89 / DKTM1',''),
 (7036,'Coordinate Reference System',4093,7301,'EUREF89 / DKTM1',''),
 (7037,'Coordinate Reference System',7639,7302,'WISCRS Walworth (ftUS)',''),
@@ -7012,15 +7027,19 @@ INSERT INTO epsg_alias VALUES
 (7043,'Coordinate Reference System',4096,7301,'ETRF89 / DKTM4',''),
 (7044,'Coordinate Reference System',4096,7301,'EUREF89 / DKTM4',''),
 (7045,'Coordinate Reference System',7640,7302,'WISCRS Washburn (ftUS)',''),
+(7046,'Datum',1156,7302,'WGS 84 (G1762)',''),
 (7047,'Coordinate Reference System',7641,7302,'WISCRS Washington (ftUS)',''),
 (7048,'Coordinate_Operation',1753,7301,'GRANIT87-Parameters',''),
 (7049,'Coordinate Reference System',7642,7302,'WISCRS Waukesha (ftUS)',''),
 (7050,'Unit of Measure',9103,1040,'angular minute',''),
 (7051,'Coordinate Reference System',7643,7302,'WISCRS Waupaca (ftUS)',''),
+(7052,'Datum',1157,7302,'PZ-90.02',''),
 (7053,'Coordinate Reference System',7644,7302,'WISCRS Waushara (ftUS)',''),
 (7054,'Unit of Measure',9104,1040,'angular second',''),
 (7055,'Coordinate Reference System',7645,7302,'WISCRS Wood (ftUS)',''),
+(7056,'Datum',1158,7302,'PZ-90.11',''),
 (7057,'Unit of Measure',1031,1040,'angular millisecond',''),
+(7058,'Coordinate_Operation',7711,7302,'ETRS89 to ODN (2)',''),
 (7059,'Unit of Measure',9105,1040,'gon',''),
 (7060,'Unit of Measure',9014,1040,'international fathom',''),
 (7061,'Unit of Measure',9093,1040,'mile',''),
@@ -7057,15 +7076,166 @@ INSERT INTO epsg_alias VALUES
 (7092,'Datum',1160,7302,'Kyrg-06',''),
 (7093,'Coordinate Reference System',7692,7301,'Kyrg06-68',''),
 (7094,'Coordinate_Operation',7688,7301,'Kyrg06-71',''),
+(7095,'Coordinate_Operation',7713,7302,'ETRS89 to ODN (Offshore)(1)',''),
 (7096,'Coordinate_Operation',7689,7301,'Kyrg06-74',''),
 (7097,'Coordinate Reference System',7693,7301,'Kyrg06-71',''),
 (7098,'Coordinate_Operation',7690,7301,'Kyrg06-77',''),
+(7099,'Coordinate_Operation',7713,7301,'ETRF89 to Newlyn (Offshore) (1)',''),
 (7100,'Coordinate_Operation',7691,7301,'Kyrg06-80',''),
 (7101,'Coordinate Reference System',7694,7301,'Kyrg06-74',''),
+(7102,'Coordinate_Operation',7711,7301,'ETRF89 to Newlyn (2)',''),
 (7103,'Coordinate Reference System',7695,7301,'Kyrg06-77',''),
+(7104,'Coordinate_Operation',7718,7301,'ETRS89 to Belfast Lough height (2)',''),
 (7105,'Coordinate Reference System',7696,7301,'Kyrg06-80',''),
+(7106,'Coordinate_Operation',7714,7301,'ETRF89 to Lerwick height (2)',''),
+(7107,'Coordinate_Operation',7718,7301,'ETRF89 to Belfast height (2)',''),
 (7108,'Coordinate_Operation',7701,7307,'LV_AMST2000 / NH to EVRF2007',''),
 (7109,'Coordinate Reference System',7700,7301,'LAS-2000 height',''),
+(7110,'Coordinate_Operation',7715,7301,'ETRF89 to Stornoway height (2)',''),
+(7111,'Coordinate_Operation',7724,7302,'Arunachal Pradesh',''),
+(7112,'Coordinate_Operation',7716,7301,'ETRF89 to St. Marys height (2)',''),
+(7113,'Coordinate_Operation',7719,7301,'ETRF89 to Malin Head height (2)',''),
+(7114,'Coordinate_Operation',7717,7301,'ETRF89 to Douglas height (2)',''),
+(7115,'Coordinate_Operation',7727,7302,'Delhi',''),
+(7116,'Coordinate_Operation',7725,7302,'Assam',''),
+(7117,'Coordinate_Operation',7728,7302,'Gujarat',''),
+(7118,'Coordinate_Operation',7726,7302,'Bihar',''),
+(7119,'Coordinate_Operation',7735,7302,'Manipur',''),
+(7120,'Coordinate_Operation',7729,7302,'Haryana',''),
+(7121,'Coordinate_Operation',7752,7302,'Tamil Nadu',''),
+(7122,'Coordinate_Operation',7730,7302,'Himachal Pradesh',''),
+(7123,'Coordinate_Operation',7736,7302,'Meghalaya',''),
+(7124,'Coordinate_Operation',7731,7302,'Jammu and Kashmir',''),
+(7125,'Datum',1165,7302,'ITRF2014',''),
+(7126,'Coordinate_Operation',7732,7302,'Jharkhand',''),
+(7127,'Coordinate_Operation',7737,7302,'Nagaland',''),
+(7128,'Coordinate_Operation',7733,7302,'Madhya Pradesh',''),
+(7129,'Coordinate_Operation',7753,7302,'Tripura',''),
+(7130,'Coordinate_Operation',7734,7302,'Maharashtra',''),
+(7131,'Coordinate_Operation',7738,7302,'India Northeast',''),
+(7133,'Coordinate_Operation',7739,7302,'Orissa',''),
+(7134,'Coordinate_Operation',7754,7302,'West Bengal',''),
+(7135,'Coordinate_Operation',7740,7302,'Punjab',''),
+(7136,'Coordinate_Operation',7722,7301,'India NSF LCC',''),
+(7137,'Coordinate_Operation',7741,7302,'Rajasthan',''),
+(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',''),
+(7143,'Coordinate_Operation',7744,7302,'Andaman and Nicobar',''),
+(7144,'Coordinate Reference System',7792,7301,'RDN2008 / TM33 (E-N)',''),
+(7145,'Coordinate_Operation',7745,7302,'Chhattisgarh',''),
+(7147,'Coordinate_Operation',7746,7302,'Goa',''),
+(7148,'Coordinate Reference System',7792,7301,'RDN2008 / UTM zone 33N (E-N)',''),
+(7149,'Coordinate_Operation',7747,7302,'Karnataka',''),
+(7150,'Coordinate Reference System',7791,7301,'RDN2008 / TM32 (E-N)',''),
+(7151,'Coordinate_Operation',7748,7302,'Kerala',''),
+(7152,'Coordinate Reference System',7793,7301,'RDN2008 / UTM zone 34N (E-N)',''),
+(7153,'Coordinate_Operation',7749,7302,'Lakshadweep',''),
+(7154,'Coordinate Reference System',7800,7302,'CS2005 zone 35',''),
+(7155,'Coordinate_Operation',7750,7302,'Mizoram',''),
+(7156,'Coordinate Reference System',7794,7301,'RDN2008 / Fuso Italia (E-N)',''),
+(7157,'Coordinate_Operation',7751,7302,'Sikkim',''),
+(7158,'Datum',1167,7302,'BGS2005',''),
+(7159,'Coordinate Reference System',7795,7301,'RDN2008 / Fuso 12 (E-N)',''),
+(7160,'Coordinate Reference System',7799,7302,'CS2005 zone 34',''),
+(7161,'Coordinate Reference System',7799,7301,'Coordinate System 2005 zone 35',''),
+(7162,'Coordinate Reference System',7815,7301,'WGS 84 (Original)',''),
+(7163,'Coordinate Reference System',7800,7301,'Coordinate System 2005 zone 35',''),
+(7164,'Datum',1166,7302,'WGS 84 (Transit)',''),
+(7165,'Coordinate Reference System',7803,7301,'BGS2005 / UTM zone 34N (E-N)',''),
+(7166,'Coordinate_Operation',7802,7302,'CCS2005',''),
+(7167,'Coordinate Reference System',7816,7301,'WGS 84 (Original)',''),
+(7168,'Coordinate_Operation',7808,7301,'IGS08 to NAD83(PA11) (1)',''),
+(7169,'Coordinate Reference System',7804,7301,'BGS2005 / UTM zone 35 (E-N)',''),
+(7170,'Coordinate Reference System',7825,7302,'Pulkovo 1942 / CS63 X1',''),
+(7171,'Coordinate Reference System',7831,7302,'Pulkovo 1942 / CS63 X7',''),
+(7172,'Coordinate Reference System',7826,7302,'Pulkovo 1942 / CS63 X2',''),
+(7173,'Coordinate_Operation',7806,7301,'SC 1942/83 to SC2005(1)',''),
+(7174,'Coordinate_Operation',7809,7301,'IGS08 to NAD83(MA11) (1)',''),
+(7175,'Coordinate Reference System',7827,7302,'Pulkovo 1942 / CS63 X3',''),
+(7176,'Area',2589,7301,'Indonesia - Irian Jaya - Tangguh',''),
+(7177,'Coordinate Reference System',7828,7302,'Pulkovo 1942 / CS63 X4',''),
+(7178,'Datum',6710,7301,'ASTRO DOS 71/4',''),
+(7179,'Coordinate Reference System',7829,7302,'Pulkovo 1942 / CS63 X5',''),
+(7180,'Coordinate_Operation',7833,7301,'Albanian 1987 to KRGJSH-2010 (1)',''),
+(7181,'Coordinate Reference System',7830,7302,'Pulkovo 1942 / CS63 X6',''),
+(7182,'Coordinate_Operation',7833,1038,'ALB86 to KRGJSH-2010 (1)',''),
+(7183,'Datum',1168,7302,'GDA2020',''),
+(7184,'Coordinate_Operation',7834,1038,'ALB86 to WGS 84 (1)',''),
+(7185,'Datum',1169,7317,'NZVD2016',''),
+(7186,'Coordinate Reference System',7845,7302,'GDA2020 / Geoscience Australia Lambert',''),
+(7187,'Coordinate Reference System',4710,7301,'ASTRO DOS 71/4',''),
+(7188,'Coordinate Reference System',4710,7301,'St. Helena 1971',''),
+(7189,'Datum',6710,7301,'St. Helena 1971',''),
+(7190,'Datum',1170,7302,'DHHN2016',''),
+(7191,'Datum',1170,7301,'Deutsches Haupthöhennetz 2016',''),
+(7192,'Coordinate_Operation',15798,7301,'St. Helena 1971 to WGS 84 (1)',''),
+(7193,'Coordinate Reference System',7837,7307,'DE_AMST_2016 / NH',''),
+(7194,'Datum',1171,7302,'POM96',''),
+(7195,'Coordinate_Operation',7838,7307,'DE_AMST_2016 / NH to EVRF2007',''),
+(7196,'Coordinate_Operation',7875,7302,'SHLG71',''),
+(7197,'Datum',1172,7302,'POM08',''),
+(7198,'Datum',1174,7302,'SHGD2015',''),
+(7199,'Coordinate_Operation',7876,7302,'SHLG(Tritan)',''),
+(7200,'Datum',1173,7301,'WGS 84 Tritan St. Helena',''),
+(7201,'Coordinate Reference System',7879,7301,'WGS 84 Tritan St. Helena',''),
+(7202,'Coordinate Reference System',7878,7301,'St. Helena 1971 / UTM zone 30S',''),
+(7203,'Coordinate Reference System',7880,7301,'WGS 84 Tritan St. Helena',''),
+(7204,'Coordinate Reference System',7881,7301,'WGS 84 Tritan St. Helena',''),
+(7205,'Datum',1177,7302,'SHVD2015',''),
+(7206,'Coordinate Reference System',7882,7301,'WGS 84 Tritan St. Helena / SHLG(Tritan)',''),
+(7207,'Coordinate_Operation',17361,7301,'Vicgrid94',''),
+(7208,'Coordinate_Operation',17361,7301,'Vicgrid2020',''),
+(7209,'Coordinate_Operation',7897,7301,'WGS 84 Tritan St Helena to SHGD2015 (1)',''),
+(7210,'Coordinate_Operation',7898,7301,'WGS84 Tritan St. Helena to WGS 84 (1)',''),
+(7211,'Coordinate Reference System',7899,7301,'GDA2020 / Vicgrid2020',''),
+(7212,'Coordinate Reference System',3111,7301,'GDA94 / Vicgrid94',''),
+(7213,'Coordinate Reference System',7908,7301,'IGS97','Used by IGS from 2000-06-04 to 2001-12-01. For most practical purposes IGS97 is equivalent to ITRF97.'),
+(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.'),
+(7220,'Unit of Measure',9111,7301,'sexagesimal degree DDD.MMm',''),
+(7222,'Unit of Measure',9121,7301,'sexagesimal degree DDDMMSS.sss',''),
+(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.'),
+(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.'),
+(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.'),
+(7230,'Coordinate Reference System',7911,7301,'IGb08','Used by IGS from 2012-10-07. For most practical purposes IGb08 is equivalent to ITRF2008.'),
+(7232,'Coordinate Reference System',5332,7301,'IGS08','Used by IGS from 2011-04-17 to 2012-10-06. For most practical purposes IGS08 is equivalent to ITRF2008.'),
+(7233,'Coordinate Reference System',5332,7301,'IGb08','Used by IGS from 2012-10-07. For most practical purposes IGb08 is equivalent to ITRF2008.'),
+(7234,'Coordinate Reference System',4896,7301,'IGS2005','Used by IGS from 2006-11-05 to 2011-04-16. For most practical purposes IGS05 is equivalent to ITRF2005.'),
+(7235,'Coordinate Reference System',4919,7301,'IGS00','Used by IGS from 2001-01-02 to 2004-01-10. For most practical purposes IGS00 is equivalent to ITRF2000.'),
+(7236,'Coordinate Reference System',4919,7301,'IGb00','Used by IGS from 2004-01-11 to 2006-11-04. For most practical purposes IGb00 is equivalent to ITRF2000.'),
+(7237,'Coordinate Reference System',4918,7301,'IGS97','Used by IGS from 2000-06-04 to 2001-12-01. For most practical purposes IGS97 is equivalent to ITRF97.'),
+(7238,'Datum',1176,7301,'MSL Tritan',''),
+(7239,'Coordinate Reference System',7887,7301,'SHGD2015 / UTM zone 30S',''),
+(7240,'Coordinate_Operation',7913,7301,'OSTN97',''),
+(7241,'Coordinate_Operation',7913,7301,'ETRF89 to OSGB 1936 / British National Grid (1)',''),
+(7242,'Coordinate Reference System',7887,7301,'St. Helena Map Grid 2015',''),
+(7243,'Coordinate_Operation Method',9663,7301,'Geographic3D to GravityRelatedHeight (OSGM02-GB)','File format first introduced for OSGM02 geoid but subsequently also used for OSGM16.'),
+(7244,'Coordinate_Operation',7952,7302,'OSTN02',''),
+(7245,'Coordinate_Operation',7952,7301,'ETRF97 to OSGB 1936 / British National Grid (2)','At epoch 2001.553.'),
+(7246,'Coordinate Reference System',7888,7301,'MSL 1971 height',''),
+(7247,'Coordinate Reference System',7889,7301,'MSL Tritan height',''),
+(7248,'Coordinate_Operation',7953,7302,'OSTN15',''),
+(7249,'Coordinate_Operation',7953,7301,'ETRF97 to OSGB 1936 / British National Grid (3)','At epoch 2009.756.'),
+(7250,'Datum',1175,7301,'MSL 1971',''),
+(7251,'Datum',1176,7302,'St. Helena Tritan 2011',''),
+(7252,'Coordinate Reference System',7877,7301,'St. Helena 1971 / SHLG71',''),
+(7253,'Coordinate Reference System',7954,7301,'St. Helena 1971 / UTM zone 30S + Jamestown 1971 height',''),
+(7254,'Coordinate_Operation',7893,7301,'St. Helena 1971 to SHGD2015 (1)',''),
+(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)',''),
+(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',''),
+(7262,'Coordinate Reference System',22193,7301,'C Inchauspe /Argentina 3',''),
+(7263,'Coordinate Reference System',22194,7301,'C Inchauspe /Argentina 4',''),
+(7264,'Coordinate Reference System',22192,7301,'C Inchauspe /Argentina 2',''),
+(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',''),
+(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)',''),
 (7431,'Coordinate_Operation',1068,1026,'Guam 1963 to Guam Geodetic Network 1993 (1)',''),
 (7442,'Coordinate Reference System',4152,1026,'Guam Geodetic Network 1993','This alias is used only in Guam, where NAD83(HARN) is realised through GGN93.'),
 (7448,'Coordinate Reference System',4152,1026,'GGN93','This abbreviation is used only in Guam, where NAD83(HARN) is realised through GGN93.'),
@@ -7087,9 +7257,9 @@ INSERT INTO epsg_alias VALUES
 (7726,'Coordinate_Operation',4454,7302,'New York Long Island','This alias is ambiguous as also used for SPCS83 projection.'),
 (7728,'Coordinate Reference System',4455,7302,'NAD27 / Pennsylvania S',''),
 (7730,'Coordinate Reference System',4456,7302,'NAD27 / New York Long Is',''),
-(7732,'Coordinate Reference System',4457,7302,'NAD83 / S Dakota N ftUS',''),
+(7732,'Coordinate Reference System',4457,7302,'NAD83 / S Dakota N (ftUS)',''),
 (7739,'Coordinate_Operation',4461,7301,'NAD83(HPGN) to NAD83(NSRS2007) (1)',''),
-(7746,'Coordinate Reference System',3112,7302,'GDA94 / GALCC',''),
+(7746,'Coordinate Reference System',3112,7302,'GDA94 / GA LCC',''),
 (7747,'Coordinate Reference System',3112,7301,'GDA94 / Geoscience LCC',''),
 (7752,'Coordinate_Operation',4436,7302,'Pennsylvania South','This alias is ambiguous as also used for SPCS83 projection.'),
 (7757,'Coordinate_Operation',4464,7301,'Test alias 1','For testing Error #12 only'),
@@ -7101,7 +7271,7 @@ INSERT INTO epsg_alias VALUES
 (8029,'Coordinate Reference System',4458,7301,'Dunedin-Bluff height',''),
 (8041,'Coordinate_Operation',4460,7301,'ACRESLC',''),
 (8044,'Coordinate Reference System',4462,7317,'WGS 84 / ACRESLC',''),
-(8047,'Coordinate_Operation',17362,7302,'GALCC',''),
+(8047,'Coordinate_Operation',17362,7302,'GA LCC',''),
 (8081,'Coordinate Reference System',4479,7302,'CGCS2000',''),
 (8084,'Coordinate Reference System',4480,7302,'CGCS2000',''),
 (8115,'Coordinate Reference System',4495,7301,'CGCS2000 / 6-degree Gauss-Kruger zone 17','Part of the China National Coordinate System of 2000.'),
@@ -8905,38 +9075,38 @@ INSERT INTO epsg_alias VALUES
 (30397,'Coordinate Reference System',6409,7302,'NAD83(2011) / AZ W (ft)',''),
 (30401,'Coordinate Reference System',6410,7301,'NAD83(2011) / Arkansas North (m)',''),
 (30402,'Coordinate Reference System',6410,7302,'NAD83(2011) / AR N (m)',''),
-(30405,'Coordinate Reference System',6411,7302,'NAD83(2011) / AR N ftUS',''),
+(30405,'Coordinate Reference System',6411,7302,'NAD83(2011) / AR N (ftUS)',''),
 (30409,'Coordinate Reference System',6412,7301,'NAD83(2011) / Arkansas South (m)',''),
 (30410,'Coordinate Reference System',6412,7302,'NAD83(2011) / AR S (m)',''),
-(30413,'Coordinate Reference System',6413,7302,'NAD83(2011) / AR S ftUS',''),
+(30413,'Coordinate Reference System',6413,7302,'NAD83(2011) / AR S (ftUS)',''),
 (30416,'Coordinate Reference System',6414,7302,'NAD83(2011) / CA Albers',''),
-(30426,'Coordinate Reference System',6416,7302,'NAD83(2011) / CA 1 ftUS',''),
+(30426,'Coordinate Reference System',6416,7302,'NAD83(2011) / CA 1 (ftUS)',''),
 (30428,'Coordinate Reference System',6415,7301,'NAD83(2011) / California zone 1 (m)',''),
 (30429,'Coordinate Reference System',6415,7302,'NAD83(2011) / CA 1 (m)',''),
 (30436,'Coordinate Reference System',6417,7301,'NAD83(2011) / California zone 2 (m)',''),
 (30437,'Coordinate Reference System',6417,7302,'NAD83(2011) / CA 2 (m)',''),
-(30440,'Coordinate Reference System',6418,7302,'NAD83(2011) / CA 2 ftUS',''),
+(30440,'Coordinate Reference System',6418,7302,'NAD83(2011) / CA 2 (ftUS)',''),
 (30444,'Coordinate Reference System',6419,7301,'NAD83(2011) / California zone 3 (m)',''),
 (30445,'Coordinate Reference System',6419,7302,'NAD83(2011) / CA 3 (m)',''),
-(30448,'Coordinate Reference System',6420,7302,'NAD83(2011) / CA 3 ftUS',''),
+(30448,'Coordinate Reference System',6420,7302,'NAD83(2011) / CA 3 (ftUS)',''),
 (30452,'Coordinate Reference System',6421,7301,'NAD83(2011) / California zone 4 (m)',''),
 (30453,'Coordinate Reference System',6421,7302,'NAD83(2011) / CA 4 (m)',''),
-(30459,'Coordinate Reference System',6422,7302,'NAD83(2011) / CA 4 ftUS',''),
+(30459,'Coordinate Reference System',6422,7302,'NAD83(2011) / CA 4 (ftUS)',''),
 (30463,'Coordinate Reference System',6423,7301,'NAD83(2011) / California zone 5 (m)',''),
 (30464,'Coordinate Reference System',6423,7302,'NAD83(2011) / CA 5 (m)',''),
-(30467,'Coordinate Reference System',6424,7302,'NAD83(2011) / CA 5 ftUS',''),
+(30467,'Coordinate Reference System',6424,7302,'NAD83(2011) / CA 5 (ftUS)',''),
 (30476,'Coordinate Reference System',6425,7301,'NAD83(2011) / California zone 6 (m)',''),
 (30477,'Coordinate Reference System',6425,7302,'NAD83(2011) / CA 6 (m)',''),
-(30480,'Coordinate Reference System',6426,7302,'NAD83(2011) / CA 6 ftUS',''),
+(30480,'Coordinate Reference System',6426,7302,'NAD83(2011) / CA 6 (ftUS)',''),
 (30484,'Coordinate Reference System',6427,7301,'NAD83(2011) / Colorado Central (m)',''),
 (30485,'Coordinate Reference System',6427,7302,'NAD83(2011) / CO C (m)',''),
-(30488,'Coordinate Reference System',6428,7302,'NAD83(2011) / CO C ftUS',''),
+(30488,'Coordinate Reference System',6428,7302,'NAD83(2011) / CO C (ftUS)',''),
 (30492,'Coordinate Reference System',6429,7301,'NAD83(2011) / Colorado North (m)',''),
 (30493,'Coordinate Reference System',6429,7302,'NAD83(2011) / CO N (m)',''),
-(30496,'Coordinate Reference System',6430,7302,'NAD83(2011) / CO N ftUS',''),
+(30496,'Coordinate Reference System',6430,7302,'NAD83(2011) / CO N (ftUS)',''),
 (30500,'Coordinate Reference System',6431,7301,'NAD83(2011) / Colorado South (m)',''),
 (30501,'Coordinate Reference System',6431,7302,'NAD83(2011) / CO S (m)',''),
-(30504,'Coordinate Reference System',6432,7302,'NAD83(2011) / CO S ftUS',''),
+(30504,'Coordinate Reference System',6432,7302,'NAD83(2011) / CO S (ftUS)',''),
 (30511,'Coordinate Reference System',6433,7301,'NAD83(2011) / Connecticut (m)',''),
 (30512,'Coordinate Reference System',6433,7302,'NAD83(2011) / CT (m)',''),
 (30515,'Coordinate Reference System',6434,7302,'NAD83(2011) / CT (ftUS)',''),
@@ -8945,41 +9115,41 @@ INSERT INTO epsg_alias VALUES
 (30523,'Coordinate Reference System',6436,7302,'NAD83(2011) / DE (ftUS)',''),
 (30527,'Coordinate Reference System',6437,7301,'NAD83(2011) / Florida East (m)',''),
 (30528,'Coordinate Reference System',6437,7302,'NAD83(2011) / FL E (m)',''),
-(30531,'Coordinate Reference System',6438,7302,'NAD83(2011) / FL E ftUS',''),
+(30531,'Coordinate Reference System',6438,7302,'NAD83(2011) / FL E (ftUS)',''),
 (30534,'Coordinate Reference System',6439,7302,'NAD83(2011) / FL GDL AEA',''),
 (30538,'Coordinate Reference System',6440,7301,'NAD83(2011) / Florida North (m)',''),
 (30539,'Coordinate Reference System',6440,7302,'NAD83(2011) / FL N (m)',''),
-(30542,'Coordinate Reference System',6441,7302,'NAD83(2011) / FL N ftUS',''),
+(30542,'Coordinate Reference System',6441,7302,'NAD83(2011) / FL N (ftUS)',''),
 (30546,'Coordinate Reference System',6442,7301,'NAD83(2011) / Florida West (m)',''),
 (30547,'Coordinate Reference System',6442,7302,'NAD83(2011) / FL W (m)',''),
-(30550,'Coordinate Reference System',6443,7302,'NAD83(2011) / FL W ftUS',''),
+(30550,'Coordinate Reference System',6443,7302,'NAD83(2011) / FL W (ftUS)',''),
 (30554,'Coordinate Reference System',6444,7301,'NAD83(2011) / Georgia East (m)',''),
 (30555,'Coordinate Reference System',6444,7302,'NAD83(2011) / GA E (m)',''),
-(30558,'Coordinate Reference System',6445,7302,'NAD83(2011) / GA E ftUS',''),
+(30558,'Coordinate Reference System',6445,7302,'NAD83(2011) / GA E (ftUS)',''),
 (30562,'Coordinate Reference System',6446,7301,'NAD83(2011) / Georgia West (m)',''),
 (30563,'Coordinate Reference System',6446,7302,'NAD83(2011) / GA W (m)',''),
-(30566,'Coordinate Reference System',6447,7302,'NAD83(2011) / GA W ftUS',''),
+(30566,'Coordinate Reference System',6447,7302,'NAD83(2011) / GA W (ftUS)',''),
 (30570,'Coordinate Reference System',6448,7301,'NAD83(2011) / Idaho Central (m)',''),
 (30571,'Coordinate Reference System',6448,7302,'NAD83(2011) / ID C (m)',''),
-(30574,'Coordinate Reference System',6449,7302,'NAD83(2011) / ID C ftUS',''),
+(30574,'Coordinate Reference System',6449,7302,'NAD83(2011) / ID C (ftUS)',''),
 (30578,'Coordinate Reference System',6450,7301,'NAD83(2011) / Idaho East (m)',''),
 (30579,'Coordinate Reference System',6450,7302,'NAD83(2011) / ID E (m)',''),
-(30582,'Coordinate Reference System',6451,7302,'NAD83(2011) / ID E ftUS',''),
+(30582,'Coordinate Reference System',6451,7302,'NAD83(2011) / ID E (ftUS)',''),
 (30586,'Coordinate Reference System',6452,7301,'NAD83(2011) / Idaho West (m)',''),
 (30587,'Coordinate Reference System',6452,7302,'NAD83(2011) / ID W (m)',''),
-(30590,'Coordinate Reference System',6453,7302,'NAD83(2011) / ID W ftUS',''),
+(30590,'Coordinate Reference System',6453,7302,'NAD83(2011) / ID W (ftUS)',''),
 (30594,'Coordinate Reference System',6454,7301,'NAD83(2011) / Illinois East (m)',''),
 (30595,'Coordinate Reference System',6454,7302,'NAD83(2011) / IL E (m)',''),
-(30598,'Coordinate Reference System',6455,7302,'NAD83(2011) / IL E ftUS',''),
+(30598,'Coordinate Reference System',6455,7302,'NAD83(2011) / IL E (ftUS)',''),
 (30602,'Coordinate Reference System',6456,7301,'NAD83(2011) / Illinois West (m)',''),
 (30603,'Coordinate Reference System',6456,7302,'NAD83(2011) / IL W (m)',''),
-(30606,'Coordinate Reference System',6457,7302,'NAD83(2011) / IL W ftUS',''),
+(30606,'Coordinate Reference System',6457,7302,'NAD83(2011) / IL W (ftUS)',''),
 (30610,'Coordinate Reference System',6458,7301,'NAD83(2011) / Indiana East (m)',''),
 (30611,'Coordinate Reference System',6458,7302,'NAD83(2011) / IN E (m)',''),
-(30614,'Coordinate Reference System',6459,7302,'NAD83(2011) / IN E ftUS',''),
+(30614,'Coordinate Reference System',6459,7302,'NAD83(2011) / IN E (ftUS)',''),
 (30618,'Coordinate Reference System',6460,7301,'NAD83(2011) / Indiana West (m)',''),
 (30619,'Coordinate Reference System',6460,7302,'NAD83(2011) / IN W (m)',''),
-(30622,'Coordinate Reference System',6461,7302,'NAD83(2011) / IN W ftUS',''),
+(30622,'Coordinate Reference System',6461,7302,'NAD83(2011) / IN W (ftUS)',''),
 (30626,'Coordinate Reference System',6462,7301,'NAD83(2011) / Iowa North (m)',''),
 (30627,'Coordinate Reference System',6462,7302,'NAD83(2011) / IA N (m)',''),
 (30636,'Coordinate Reference System',6464,7301,'NAD83(2011) / Iowa South (m)',''),
@@ -8990,21 +9160,21 @@ INSERT INTO epsg_alias VALUES
 (30653,'Coordinate Reference System',6468,7302,'NAD83(2011) / KS S (m)',''),
 (30660,'Coordinate Reference System',6470,7301,'NAD83(2011) / Kentucky North (m)',''),
 (30661,'Coordinate Reference System',6470,7302,'NAD83(2011) / KY N (m)',''),
-(30671,'Coordinate Reference System',6471,7302,'NAD83(2011) / KY N ftUS',''),
+(30671,'Coordinate Reference System',6471,7302,'NAD83(2011) / KY N (ftUS)',''),
 (30676,'Coordinate Reference System',6472,7301,'NAD83(2011) / Kentucky Single Zone (m)',''),
 (30677,'Coordinate Reference System',6472,7301,'KY1Z','This alias is ambiguous as it is also used for the same projection associated with different datums and coordinate systems.'),
 (30678,'Coordinate Reference System',6472,7302,'NAD83(2011) / KY1Z (m)',''),
-(30682,'Coordinate Reference System',6473,7302,'NAD83(2011) / KY1Z ftUS',''),
+(30682,'Coordinate Reference System',6473,7302,'NAD83(2011) / KY1Z (ftUS)',''),
 (30683,'Coordinate Reference System',6473,7301,'KY1Z','This alias is ambiguous as it is also used for the same projection associated with different datums and coordinate systems.'),
 (30687,'Coordinate Reference System',6474,7301,'NAD83(2011) / Kentucky South (m)',''),
 (30688,'Coordinate Reference System',6474,7302,'NAD83(2011) / KY S (m)',''),
-(30691,'Coordinate Reference System',6475,7302,'NAD83(2011) / KY S ftUS',''),
+(30691,'Coordinate Reference System',6475,7302,'NAD83(2011) / KY S (ftUS)',''),

[... 4794 lines stripped ...]


Mime
View raw message