Database: fix ingestion from ESRI of alias names for deprecated objects

2 files changed, 117 insertions, 117 deletions

diff --git a/data/sql/esri.sql b/data/sql/esri.sql
index c01aaac9..53fb2c98 100644
--- a/data/sql/esri.sql
+++ b/data/sql/esri.sql
@@ -473,9 +473,9 @@ INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1137','D_Bekaa_Valley_192
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1138','D_South_East_Island_1943','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1139','D_Gambia','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1142','IG05_Intermediate_Datum','ESRI');
-INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1114','Israel_Geodetic_Datum_2005','ESRI');
+INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1143','Israel_Geodetic_Datum_2005','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1144','IG05(2012)_Intermediate_Datum','ESRI');
-INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1115','Israeli_Geodetic_Datum_2005(2012)','ESRI');
+INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1145','Israeli_Geodetic_Datum_2005(2012)','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1147','Oman_National_Geodetic_Datum_2014','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1152','World_Geodetic_System_1984_(G730)','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','1153','World_Geodetic_System_1984_(G873)','ESRI');
@@ -660,7 +660,7 @@ INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6230','D_European_1950','
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6231','D_European_1987','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6232','D_Fahud','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6233','D_Gandajika_1970','ESRI');
-INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6197','D_Garoua','ESRI');
+INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6234','D_Garoua','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6235','D_Guyane_Francaise','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6236','D_Hu_Tzu_Shan','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6237','D_Hungarian_1972','ESRI');
@@ -716,7 +716,7 @@ INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6286','D_Qatar_1948','ESR
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6287','D_Qornoq','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6288','D_Loma_Quintana','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6289','D_Amersfoort','ESRI');
-INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6618','D_South_American_1969','ESRI');
+INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6291','D_South_American_1969','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6292','D_Sapper_Hill_1943','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6293','D_Schwarzeck','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6294','D_Segora','ESRI');
@@ -777,7 +777,7 @@ INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6627','D_RGR_1992','ESRI'
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6628','D_Tahiti_1952','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6629','D_Tahaa_1954','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6630','D_IGN72_Nuku_Hiva','ESRI');
-INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6698','D_Kerguelen_Island_1949','ESRI');
+INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6631','D_Kerguelen_Island_1949','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6632','D_Combani_1950','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6633','D_IGN56_Lifou','ESRI');
 INSERT INTO alias_name VALUES('geodetic_datum','EPSG','6634','D_IGN72_Grande_Terre','ESRI');
@@ -965,7 +965,7 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4122','GCS_ATS_1977','ESRI'
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4123','GCS_KKJ','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4124','GCS_RT_1990','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4125','GCS_Samboja','ESRI');
-INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4669','GCS_LKS_1994','ESRI');
+INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4126','GCS_LKS_1994','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4127','GCS_Tete','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4128','GCS_Madzansua','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4129','GCS_Observatario','ESRI');
@@ -979,7 +979,7 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4136','GCS_St_Lawrence_Isla
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4137','GCS_St_Paul_Island','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4138','GCS_St_George_Island','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4139','GCS_Puerto_Rico','ESRI');
-INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4617','GCS_North_American_1983_CSRS','ESRI');
+INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4140','GCS_North_American_1983_CSRS','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4141','GCS_Israel','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4142','GCS_Locodjo_1965','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4143','GCS_Abidjan_1987','ESRI');
@@ -1069,7 +1069,7 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4230','GCS_European_1950','
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4231','GCS_European_1987','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4232','GCS_Fahud','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4233','GCS_Gandajika_1970','ESRI');
-INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4197','GCS_Garoua','ESRI');
+INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4234','GCS_Garoua','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4235','GCS_Guyane_Francaise','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4236','GCS_Hu_Tzu_Shan','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4237','GCS_Hungarian_1972','ESRI');
@@ -1125,7 +1125,7 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4286','GCS_Qatar_1948','ESR
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4287','GCS_Qornoq','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4288','GCS_Loma_Quintana','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4289','GCS_Amersfoort','ESRI');
-INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4618','GCS_South_American_1969','ESRI');
+INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4291','GCS_South_American_1969','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4292','GCS_Sapper_Hill_1943','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4293','GCS_Schwarzeck','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4294','GCS_Segora','ESRI');
@@ -1202,7 +1202,7 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4627','GCS_RGR_1992','ESRI'
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4628','GCS_Tahiti_1952','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4629','GCS_Tahaa_1954','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4630','GCS_IGN72_Nuku_Hiva','ESRI');
-INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4698','GCS_Kerguelen_Island_1949','ESRI');
+INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4631','GCS_Kerguelen_Island_1949','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4632','GCS_Combani_1950','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4633','GCS_IGN56_Lifou','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4636','GCS_Petrels_1972','ESRI');
@@ -1393,7 +1393,7 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','6883','GCS_Bioko','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','6892','GCS_South_East_Island_1943','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','6894','GCS_Gambia','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','6983','IG05_Intermediate_CRS','ESRI');
-INSERT INTO alias_name VALUES('geodetic_crs','EPSG','7139','IGD05(2012)','ESRI');
+INSERT INTO alias_name VALUES('geodetic_crs','EPSG','6987','IGD05(2012)','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','6990','IG05(2012)_Intermediate_CRS','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','7035','RGSPM06_(lon-lat)','ESRI');
 INSERT INTO alias_name VALUES('geodetic_crs','EPSG','7037','RGR92_(lon-lat)','ESRI');
@@ -2222,9 +2222,9 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2032','NAD_1927_CGQ77_UTM_
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2033','NAD_1927_CGQ77_UTM_Zone_19N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2034','NAD_1927_CGQ77_UTM_Zone_20N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2035','NAD_1927_CGQ77_UTM_Zone_21N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2953','NAD_1983_CSRS_New_Brunswick_Stereographic','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2960','NAD_1983_CSRS_UTM_Zone_19N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2961','NAD_1983_CSRS_UTM_Zone_20N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2036','NAD_1983_CSRS_New_Brunswick_Stereographic','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2037','NAD_1983_CSRS_UTM_Zone_19N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2038','NAD_1983_CSRS_UTM_Zone_20N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2039','Israel_TM_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2040','Locodjo_1965_UTM_Zone_30N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2041','Abidjan_1987_UTM_Zone_30N','ESRI');
@@ -2239,8 +2239,8 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2059','ED_1950_ED77_UTM_Zo
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2060','ED_1950_ED77_UTM_Zone_40N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2061','ED_1950_ED77_UTM_Zone_41N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2062','Madrid_1870_Madrid_Spain','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3461','Dabola_1981_UTM_Zone_28N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3462','Dabola_1981_UTM_Zone_29N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2063','Dabola_1981_UTM_Zone_28N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2064','Dabola_1981_UTM_Zone_29N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2065','S-JTSK_Ferro_Krovak','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2066','Mount_Dillon_Tobago_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2067','Naparima_1955_UTM_Zone_20N','ESRI');
@@ -2267,8 +2267,8 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2087','ELD_1979_TM_12_NE',
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2088','Carthage_TM_11_NE','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2089','Yemen_NGN_1996_UTM_Zone_38N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2090','Yemen_NGN_1996_UTM_Zone_39N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2395','South_Yemen_GK_Zone_8','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2396','South_Yemen_GK_Zone_9','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2091','South_Yemen_GK_Zone_8','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2092','South_Yemen_GK_Zone_9','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2093','Hanoi_1972_GK_106_NE','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2094','WGS_1972_BE_TM_106_NE','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2095','Bissau_UTM_Zone_28N','ESRI');
@@ -2315,23 +2315,23 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2135','NZGD_2000_UTM_Zone_
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2136','Accra_Ghana_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2137','Accra_TM_1_NW','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2138','NAD_1927_CGQ77_Quebec_Lambert','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2944','NAD_1983_CSRS_MTM_2_SCoPQ','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2945','NAD_1983_CSRS_MTM_3','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2946','NAD_1983_CSRS_MTM_4','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2947','NAD_1983_CSRS_MTM_5','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2948','NAD_1983_CSRS_MTM_6','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2949','NAD_1983_CSRS_MTM_7','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2950','NAD_1983_CSRS_MTM_8','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2951','NAD_1983_CSRS_MTM_9','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2952','NAD_1983_CSRS_MTM_10','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2962','NAD_1983_CSRS_UTM_Zone_21N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2959','NAD_1983_CSRS_UTM_Zone_18N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2958','NAD_1983_CSRS_UTM_Zone_17N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2957','NAD_1983_CSRS_UTM_Zone_13N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2956','NAD_1983_CSRS_UTM_Zone_12N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2955','NAD_1983_CSRS_UTM_Zone_11N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2139','NAD_1983_CSRS_MTM_2_SCoPQ','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2140','NAD_1983_CSRS_MTM_3','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2141','NAD_1983_CSRS_MTM_4','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2142','NAD_1983_CSRS_MTM_5','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2143','NAD_1983_CSRS_MTM_6','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2144','NAD_1983_CSRS_MTM_7','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2145','NAD_1983_CSRS_MTM_8','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2146','NAD_1983_CSRS_MTM_9','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2147','NAD_1983_CSRS_MTM_10','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2148','NAD_1983_CSRS_UTM_Zone_21N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2149','NAD_1983_CSRS_UTM_Zone_18N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2150','NAD_1983_CSRS_UTM_Zone_17N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2151','NAD_1983_CSRS_UTM_Zone_13N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2152','NAD_1983_CSRS_UTM_Zone_12N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2153','NAD_1983_CSRS_UTM_Zone_11N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2154','RGF_1993_Lambert_93','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3102','Samoa_1962_Samoa_Lambert','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2155','Samoa_1962_Samoa_Lambert','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2157','IRENET95_Irish_Transverse_Mercator','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2158','IRENET95_UTM_Zone_29N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2159','Sierra_Leone_1924_New_Colony_Grid','ESRI');
@@ -2341,9 +2341,9 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2162','Sierra_Leone_1968_U
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2163','US_National_Atlas_Equal_Area','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2164','Locodjo_1965_TM_5_NW','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2165','Abidjan_1987_TM_5_NW','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2397','Pulkovo_1942_Adj_1983_3_Degree_GK_Zone_3','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2398','Pulkovo_1942_Adj_1983_3_Degree_GK_Zone_4','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2399','Pulkovo_1942_Adj_1983_3_Degree_GK_Zone_5','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2166','Pulkovo_1942_Adj_1983_3_Degree_GK_Zone_3','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2167','Pulkovo_1942_Adj_1983_3_Degree_GK_Zone_4','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2168','Pulkovo_1942_Adj_1983_3_Degree_GK_Zone_5','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2169','Luxembourg_1930_Gauss','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2170','MGI_Slovenia_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2172','Pulkovo_1942_Adj_1958_Poland_Zone_II','ESRI');
@@ -2386,7 +2386,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2210','ED_1950_3_Degree_GK
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2211','ED_1950_3_Degree_GK_Zone_14','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2212','ED_1950_3_Degree_GK_Zone_15','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2213','ETRS_1989_TM_30_NE','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3119','Douala_1948_AEF_West','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2214','Douala_1948_AEF_West','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2215','Manoca_1962_UTM_Zone_32N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2216','Qornoq_1927_UTM_Zone_22N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2217','Qornoq_1927_UTM_Zone_23N','ESRI');
@@ -2414,8 +2414,8 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2240','NAD_1983_StatePlane
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2241','NAD_1983_StatePlane_Idaho_East_FIPS_1101_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2242','NAD_1983_StatePlane_Idaho_Central_FIPS_1102_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2243','NAD_1983_StatePlane_Idaho_West_FIPS_1103_Feet','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2965','NAD_1983_StatePlane_Indiana_East_FIPS_1301_Feet','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2966','NAD_1983_StatePlane_Indiana_West_FIPS_1302_Feet','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2244','NAD_1983_StatePlane_Indiana_East_FIPS_1301_Feet','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2245','NAD_1983_StatePlane_Indiana_West_FIPS_1302_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2246','NAD_1983_StatePlane_Kentucky_North_FIPS_1601_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2247','NAD_1983_StatePlane_Kentucky_South_FIPS_1602_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2248','NAD_1983_StatePlane_Maryland_FIPS_1900_Feet','ESRI');
@@ -2461,8 +2461,8 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2287','NAD_1983_StatePlane
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2288','NAD_1983_StatePlane_Wisconsin_Central_FIPS_4802_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2289','NAD_1983_StatePlane_Wisconsin_South_FIPS_4803_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2290','Prince_Edward_Island_Stereographic','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2954','NAD_1983_CSRS_Prince_Edward_Island','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2954','NAD_1983_CSRS_Prince_Edward_Island','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2291','NAD_1983_CSRS_Prince_Edward_Island','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2292','NAD_1983_CSRS_Prince_Edward_Island','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2294','ATS_1977_MTM_4_Nova_Scotia','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2295','ATS_1977_MTM_5_Nova_Scotia','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2308','Batavia_TM_109_SE','ESRI');
@@ -2732,7 +2732,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2573','Pulkovo_1942_3_Degr
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2574','Pulkovo_1942_3_Degree_GK_Zone_57','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2575','Pulkovo_1942_3_Degree_GK_Zone_58','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2576','Pulkovo_1942_3_Degree_GK_Zone_59','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3389','Pulkovo_1942_3_Degree_GK_Zone_60','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2577','Pulkovo_1942_3_Degree_GK_Zone_60','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2578','Pulkovo_1942_3_Degree_GK_Zone_61','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2579','Pulkovo_1942_3_Degree_GK_Zone_62','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2580','Pulkovo_1942_3_Degree_GK_Zone_63','ESRI');
@@ -2755,7 +2755,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2596','Pulkovo_1942_3_Degr
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2597','Pulkovo_1942_3_Degree_GK_CM_66E','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2598','Pulkovo_1942_3_Degree_GK_CM_69E','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2599','Pulkovo_1942_3_Degree_GK_CM_72E','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3346','LKS_1994_Lithuania_TM','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2600','LKS_1994_Lithuania_TM','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2601','Pulkovo_1942_3_Degree_GK_CM_75E','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2602','Pulkovo_1942_3_Degree_GK_CM_78E','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2603','Pulkovo_1942_3_Degree_GK_CM_81E','ESRI');
@@ -2849,7 +2849,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2690','Pulkovo_1995_3_Degr
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2691','Pulkovo_1995_3_Degree_GK_Zone_57','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2692','Pulkovo_1995_3_Degree_GK_Zone_58','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2693','Pulkovo_1995_3_Degree_GK_Zone_59','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3390','Pulkovo_1995_3_Degree_GK_Zone_60','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2694','Pulkovo_1995_3_Degree_GK_Zone_60','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2695','Pulkovo_1995_3_Degree_GK_Zone_61','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2696','Pulkovo_1995_3_Degree_GK_Zone_62','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2697','Pulkovo_1995_3_Degree_GK_Zone_63','ESRI');
@@ -3087,7 +3087,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2930','NAD_1983_HARN_State
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2931','Beduaram_TM_13_NE','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2932','QND_1995_Qatar_National_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2933','Gunung_Segara_UTM_Zone_50S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','5329','Gunung_Segara_Jakarta_NEIEZ','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2934','Gunung_Segara_Jakarta_NEIEZ','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2935','Pulkovo_1942_CS63_Zone_A1','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2936','Pulkovo_1942_CS63_Zone_A2','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2937','Pulkovo_1942_CS63_Zone_A3','ESRI');
@@ -3130,10 +3130,10 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','2975','RGR_1992_UTM_40S','
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2976','Tahiti_1952_UTM_6S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2977','Tahaa_1954_UTM_5S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2978','IGN72_Nuku_Hiva_UTM_7S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3336','Kerguelen_Island_1949_UTM_42S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2979','Kerguelen_Island_1949_UTM_42S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2980','Combani_1950_UTM_38S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2981','IGN56_Lifou_UTM_58S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3060','IGN72_Grande_Terre_UTM_58S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','2982','IGN72_Grande_Terre_UTM_58S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2984','RGNC_1991_Lambert_New_Caledonia','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2985','Petrels_1972_Terre_Adelie_Polar_Stereographic','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','2986','Perroud_1950_Terre_Adelie_Polar_Stereographic','ESRI');
@@ -3219,10 +3219,10 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','3069','NAD_1927_Wisconsin_
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3070','NAD_1983_Wisconsin_TM','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3071','NAD_1983_HARN_Wisconsin_TM','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3072','NAD_1983_Maine_2000_East_Zone','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3463','NAD_1983_Maine_2000_Central_Zone','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','3073','NAD_1983_Maine_2000_Central_Zone','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3074','NAD_1983_Maine_2000_West_Zone','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3075','NAD_1983_HARN_Maine_2000_East_Zone','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3464','NAD_1983_HARN_Maine_2000_Central_Zone','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','3076','NAD_1983_HARN_Maine_2000_Central_Zone','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3077','NAD_1983_HARN_Maine_2000_West_Zone','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3078','NAD_1983_Michigan_GeoRef_Meters','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3079','NAD_1983_HARN_Michigan_GeoRef_Meters','ESRI');
@@ -3403,14 +3403,14 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','3355','Egypt_Gulf_of_Suez_
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3356','Grand_Cayman_1959_UTM_Zone_17N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3357','Little_Cayman_1961_UTM_Zone_17N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3358','NAD_1983_HARN_StatePlane_North_Carolina_FIPS_3200','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3404','NAD_1983_HARN_StatePlane_North_Carolina_FIPS_3200_Feet','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','3359','NAD_1983_HARN_StatePlane_North_Carolina_FIPS_3200_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3360','NAD_1983_HARN_StatePlane_South_Carolina_FIPS_3900','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3361','NAD_1983_HARN_StatePlane_South_Carolina_FIPS_3900_Feet_Intl','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3362','NAD_1983_HARN_StatePlane_Pennsylvania_North_FIPS_3701','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3363','NAD_1983_HARN_StatePlane_Pennsylvania_North_FIPS_3701_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3364','NAD_1983_HARN_StatePlane_Pennsylvania_South_FIPS_3702','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3365','NAD_1983_HARN_StatePlane_Pennsylvania_South_FIPS_3702_Feet','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','3407','Hong_Kong_1963_Grid_System','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','3366','Hong_Kong_1963_Grid_System','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3367','IGN_Astro_1960_UTM_Zone_28N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3368','IGN_Astro_1960_UTM_Zone_29N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3369','IGN_Astro_1960_UTM_Zone_30N','ESRI');
@@ -3498,7 +3498,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','3450','JAD_2001_UTM_Zone_1
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3451','NAD_1983_StatePlane_Louisiana_North_FIPS_1701_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3452','NAD_1983_StatePlane_Louisiana_South_FIPS_1702_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3453','NAD_1983_StatePlane_Louisiana_Offshore_FIPS_1703_Feet','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','4457','NAD_1983_StatePlane_South_Dakota_North_FIPS_4001_Feet','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','3454','NAD_1983_StatePlane_South_Dakota_North_FIPS_4001_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3455','NAD_1983_StatePlane_South_Dakota_South_FIPS_4002_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3456','NAD_1983_HARN_StatePlane_Louisiana_North_FIPS_1701_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','3457','NAD_1983_HARN_StatePlane_Louisiana_South_FIPS_1702_Feet','ESRI');
@@ -3998,7 +3998,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','4457','NAD_1983_StatePlane
 INSERT INTO alias_name VALUES('projected_crs','EPSG','4462','WGS_1984_Australian_Centre_for_Remote_Sensing_Lambert','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','4467','RGSPM_2006_UTM_Zone_21N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','4471','RGM_2004_UTM_Zone_38S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','5879','Cadastre_1997_UTM_Zone_38S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','4474','Cadastre_1997_UTM_Zone_38S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','4484','Mexican_Datum_1993_UTM_Zone_11N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','4485','Mexican_Datum_1993_UTM_Zone_12N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','4486','Mexican_Datum_1993_UTM_Zone_13N','ESRI');
@@ -4254,7 +4254,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','5367','CRTM05','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5382','SIRGAS-ROU98_UTM_Zone_21S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5383','SIRGAS-ROU98_UTM_Zone_22S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5387','Peru96_UTM_Zone_18S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','5839','Peru96_UTM_Zone_17S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','5388','Peru96_UTM_Zone_17S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5389','Peru96_UTM_Zone_19S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5396','SIRGAS_2000_UTM_Zone_26S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5456','Ocotepeque_1935_Costa_Rica_Norte','ESRI');
@@ -4279,7 +4279,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','5520','DHDN_3_Degree_Gauss
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5523','WGS_1984_UTM_Gabon_TM_2011','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5530','SAD_1969_96_Brazil_Polyconic','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5531','SAD_1969_96_UTM_Zone_21S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','5858','SAD_1969_96_UTM_Zone_22S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','5532','SAD_1969_96_UTM_Zone_22S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5533','SAD_1969_96_UTM_Zone_23S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5534','SAD_1969_96_UTM_Zone_24S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','5535','SAD_1969_96_UTM_Zone_25S','ESRI');
@@ -4477,7 +4477,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','6124','WGS_1984_EPSG_Arcti
 INSERT INTO alias_name VALUES('projected_crs','EPSG','6125','ETRS_1989_EPSG_Arctic_zone_5-47','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','6128','Grand_Cayman_National_Grid_1959','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','6129','Sister_Islands_National_Grid_1961','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','6391','Cayman_Islands_National_Grid_2011','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','6141','Cayman_Islands_National_Grid_2011','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','6204','Macedonian_State_Coordinate_System','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','6210','SIRGAS_2000_UTM_Zone_23N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','6211','SIRGAS_2000_UTM_Zone_24N','ESRI');
@@ -5509,10 +5509,10 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','21781','CH1903_LV03','ESRI
 INSERT INTO alias_name VALUES('projected_crs','EPSG','21782','CH1903_LV03C-G','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','21817','Bogota_UTM_Zone_17N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','21818','Bogota_UTM_Zone_18N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','21896','Colombia_West_Zone','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','21897','Colombia_Bogota_Zone','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','21898','Colombia_East_Central_Zone','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','21899','Colombia_East_Zone','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','21891','Colombia_West_Zone','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','21892','Colombia_Bogota_Zone','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','21893','Colombia_East_Central_Zone','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','21894','Colombia_East_Zone','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','21896','Colombia_West_Zone','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','21897','Colombia_Bogota_Zone','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','21898','Colombia_East_Central_Zone','ESRI');
@@ -5576,7 +5576,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','23090','ED_1950_TM_0_N','E
 INSERT INTO alias_name VALUES('projected_crs','EPSG','23095','ED_1950_TM_5_NE','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','23239','Fahud_UTM_Zone_39N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','23240','Fahud_UTM_Zone_40N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2312','Garoua_UTM_Zone_33N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','23433','Garoua_UTM_Zone_33N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','23700','Hungarian_1972_Egyseges_Orszagos_Vetuleti','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','23830','DGN_1995_Indonesia_TM-3_Zone_46.2','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','23831','DGN_1995_Indonesia_TM-3_Zone_47.1','ESRI');
@@ -5758,7 +5758,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','26743','NAD_1927_StatePlan
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26744','NAD_1927_StatePlane_California_IV_FIPS_0404','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26745','NAD_1927_StatePlane_California_V_FIPS_0405','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26746','NAD_1927_StatePlane_California_VI_FIPS_0406','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','26799','NAD_1927_StatePlane_California_VII_FIPS_0407','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','26747','NAD_1927_StatePlane_California_VII_FIPS_0407','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26748','NAD_1927_StatePlane_Arizona_East_FIPS_0201','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26749','NAD_1927_StatePlane_Arizona_Central_FIPS_0202','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26750','NAD_1927_StatePlane_Arizona_West_FIPS_0203','ESRI');
@@ -5922,7 +5922,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','26975','NAD_1983_StatePlan
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26976','NAD_1983_StatePlane_Iowa_South_FIPS_1402','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26977','NAD_1983_StatePlane_Kansas_North_FIPS_1501','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26978','NAD_1983_StatePlane_Kansas_South_FIPS_1502','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2205','NAD_1983_StatePlane_Kentucky_North_FIPS_1601','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','26979','NAD_1983_StatePlane_Kentucky_North_FIPS_1601','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26980','NAD_1983_StatePlane_Kentucky_South_FIPS_1602','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26981','NAD_1983_StatePlane_Louisiana_North_FIPS_1701','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','26982','NAD_1983_StatePlane_Louisiana_South_FIPS_1702','ESRI');
@@ -5990,7 +5990,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','27396','NGO_1948_Oslo_Norw
 INSERT INTO alias_name VALUES('projected_crs','EPSG','27397','NGO_1948_Oslo_Norway_Zone_7','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','27398','NGO_1948_Oslo_Norway_Zone_8','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','27429','Datum_73_UTM_Zone_29N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','27493','Datum_73_Modified_Portuguese_Grid','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','27492','Datum_73_Modified_Portuguese_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','27493','Datum_73_Modified_Portuguese_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','27500','Nord_de_Guerre','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','27561','NTF_Paris_Lambert_Nord_France','ESRI');
@@ -6090,27 +6090,27 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','28492','Pulkovo_1942_GK_Zo
 INSERT INTO alias_name VALUES('projected_crs','EPSG','28600','Qatar_National_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','28991','RD_Old','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','28992','RD_New','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29100','SAD_1969_Brazil_Polyconic','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29101','SAD_1969_Brazil_Polyconic','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29101','SAD_1969_Brazil_Polyconic','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29168','SAD_1969_UTM_Zone_18N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29169','SAD_1969_UTM_Zone_19N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29170','SAD_1969_UTM_Zone_20N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29171','SAD_1969_UTM_Zone_21N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29172','SAD_1969_UTM_Zone_22N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29118','SAD_1969_UTM_Zone_18N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29119','SAD_1969_UTM_Zone_19N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29120','SAD_1969_UTM_Zone_20N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29121','SAD_1969_UTM_Zone_21N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29122','SAD_1969_UTM_Zone_22N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29168','SAD_1969_UTM_Zone_18N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29169','SAD_1969_UTM_Zone_19N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29170','SAD_1969_UTM_Zone_20N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29171','SAD_1969_UTM_Zone_21N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29172','SAD_1969_UTM_Zone_22N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29187','SAD_1969_UTM_Zone_17S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29188','SAD_1969_UTM_Zone_18S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29189','SAD_1969_UTM_Zone_19S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29190','SAD_1969_UTM_Zone_20S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29191','SAD_1969_UTM_Zone_21S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29192','SAD_1969_UTM_Zone_22S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29193','SAD_1969_UTM_Zone_23S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29194','SAD_1969_UTM_Zone_24S','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29195','SAD_1969_UTM_Zone_25S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29177','SAD_1969_UTM_Zone_17S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29178','SAD_1969_UTM_Zone_18S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29179','SAD_1969_UTM_Zone_19S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29180','SAD_1969_UTM_Zone_20S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29181','SAD_1969_UTM_Zone_21S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29182','SAD_1969_UTM_Zone_22S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29183','SAD_1969_UTM_Zone_23S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29184','SAD_1969_UTM_Zone_24S','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29185','SAD_1969_UTM_Zone_25S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29187','SAD_1969_UTM_Zone_17S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29188','SAD_1969_UTM_Zone_18S','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29189','SAD_1969_UTM_Zone_19S','ESRI');
@@ -6133,7 +6133,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','29850','Timbalai_1948_UTM_
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29871','Timbalai_1948_RSO_Borneo_Chains','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29872','Timbalai_1948_RSO_Borneo_Feet','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29873','Timbalai_1948_RSO_Borneo_Meters','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','29902','TM65_Irish_Grid','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','29900','TM65_Irish_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29901','OSNI_1952_Irish_National_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29902','TM65_Irish_Grid','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','29903','TM75_Irish_Grid','ESRI');
@@ -6193,7 +6193,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','31268','MGI_3_Degree_Gauss
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31275','MGI_Balkans_5','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31276','MGI_Balkans_6','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31277','MGI_Balkans_7','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31279','MGI_Balkans_8','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31278','MGI_Balkans_8','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31279','MGI_Balkans_8','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31281','Austria_West_Zone','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31282','Austria_Central_Zone','ESRI');
@@ -6205,19 +6205,19 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','31287','MGI_Austria_Lamber
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31288','MGI_Ferro_M28','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31289','MGI_Ferro_M31','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31290','MGI_Ferro_M34','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31281','Austria_West_Zone','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31282','Austria_Central_Zone','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31283','Austria_East_Zone','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31284','MGI_M28','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31285','MGI_M31','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31286','MGI_M34','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31287','MGI_Austria_Lambert','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31291','Austria_West_Zone','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31292','Austria_Central_Zone','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31293','Austria_East_Zone','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31294','MGI_M28','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31295','MGI_M31','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31296','MGI_M34','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31297','MGI_Austria_Lambert','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31370','Belge_Lambert_1972','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','5520','DHDN_3_Degree_Gauss_Zone_1','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31466','DHDN_3_Degree_Gauss_Zone_2','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31467','DHDN_3_Degree_Gauss_Zone_3','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31468','DHDN_3_Degree_Gauss_Zone_4','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','31469','DHDN_3_Degree_Gauss_Zone_5','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31461','DHDN_3_Degree_Gauss_Zone_1','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31462','DHDN_3_Degree_Gauss_Zone_2','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31463','DHDN_3_Degree_Gauss_Zone_3','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31464','DHDN_3_Degree_Gauss_Zone_4','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','31465','DHDN_3_Degree_Gauss_Zone_5','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31466','DHDN_3_Degree_Gauss_Zone_2','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31467','DHDN_3_Degree_Gauss_Zone_3','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','31468','DHDN_3_Degree_Gauss_Zone_4','ESRI');
@@ -6292,7 +6292,7 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','32014','NAD_1927_StatePlan
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32015','NAD_1927_StatePlane_New_York_East_FIPS_3101','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32016','NAD_1927_StatePlane_New_York_Central_FIPS_3102','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32017','NAD_1927_StatePlane_New_York_West_FIPS_3103','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','4456','NAD_1927_StatePlane_New_York_Long_Island_FIPS_3104','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','32018','NAD_1927_StatePlane_New_York_Long_Island_FIPS_3104','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32019','NAD_1927_StatePlane_North_Carolina_FIPS_3200','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32020','NAD_1927_StatePlane_North_Dakota_North_FIPS_3301','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32021','NAD_1927_StatePlane_North_Dakota_South_FIPS_3302','ESRI');
@@ -6303,13 +6303,13 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','32025','NAD_1927_StatePlan
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32026','NAD_1927_StatePlane_Oregon_North_FIPS_3601','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32027','NAD_1927_StatePlane_Oregon_South_FIPS_3602','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32028','NAD_1927_StatePlane_Pennsylvania_North_FIPS_3701','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','4455','NAD_1927_StatePlane_Pennsylvania_South_FIPS_3702','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','32029','NAD_1927_StatePlane_Pennsylvania_South_FIPS_3702','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32030','NAD_1927_StatePlane_Rhode_Island_FIPS_3800','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32031','NAD_1927_StatePlane_South_Carolina_North_FIPS_3901','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32033','NAD_1927_StatePlane_South_Carolina_South_FIPS_3902','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32034','NAD_1927_StatePlane_South_Dakota_North_FIPS_4001','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32035','NAD_1927_StatePlane_South_Dakota_South_FIPS_4002','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','2204','NAD_1927_StatePlane_Tennessee_FIPS_4100','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','32036','NAD_1927_StatePlane_Tennessee_FIPS_4100','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32037','NAD_1927_StatePlane_Texas_North_FIPS_4201','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32038','NAD_1927_StatePlane_Texas_North_Central_FIPS_4202','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32039','NAD_1927_StatePlane_Texas_Central_FIPS_4203','ESRI');
@@ -6340,10 +6340,10 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','32064','NAD_1927_BLM_Zone_
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32065','NAD_1927_BLM_Zone_15N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32066','NAD_1927_BLM_Zone_16N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32067','NAD_1927_BLM_Zone_17N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','32064','NAD_1927_BLM_Zone_14N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','32065','NAD_1927_BLM_Zone_15N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','32066','NAD_1927_BLM_Zone_16N','ESRI');
-INSERT INTO alias_name VALUES('projected_crs','EPSG','32067','NAD_1927_BLM_Zone_17N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','32074','NAD_1927_BLM_Zone_14N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','32075','NAD_1927_BLM_Zone_15N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','32076','NAD_1927_BLM_Zone_16N','ESRI');
+INSERT INTO alias_name VALUES('projected_crs','EPSG','32077','NAD_1927_BLM_Zone_17N','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32081','NAD_1927_MTM_1','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32082','NAD_1927_MTM_2','ESRI');
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32083','NAD_1927_MTM_3','ESRI');
@@ -9671,7 +9671,7 @@ INSERT INTO alias_name VALUES('vertical_crs','EPSG','5621','EVRF_2007','ESRI');
 INSERT INTO alias_name VALUES('vertical_crs','EPSG','5701','Newlyn','ESRI');
 INSERT INTO alias_name VALUES('vertical_crs','EPSG','5702','NGVD_1929','ESRI');
 INSERT INTO alias_name VALUES('vertical_crs','EPSG','5703','NAVD_1988','ESRI');
-INSERT INTO alias_name VALUES('vertical_crs','EPSG','5736','Yellow_Sea_1956','ESRI');
+INSERT INTO alias_name VALUES('vertical_crs','EPSG','5704','Yellow_Sea_1956','ESRI');
 INSERT INTO alias_name VALUES('vertical_crs','EPSG','5705','Baltic','ESRI');
 INSERT INTO alias_name VALUES('vertical_crs','EPSG','5706','Caspian','ESRI');
 INSERT INTO alias_name VALUES('vertical_crs','EPSG','5709','NAP','ESRI');
diff --git a/scripts/build_db_from_esri.py b/scripts/build_db_from_esri.py
index bea48925..2bc4a528 100755
--- a/scripts/build_db_from_esri.py
+++ b/scripts/build_db_from_esri.py
@@ -212,6 +212,7 @@ def import_spheroid():
                 break
             assert len(row) == nfields, row
 
+            code = row[idx_wkid]
             latestWkid = row[idx_latestWkid]
             authority = row[idx_authority]
             esri_name = row[idx_name]
@@ -229,7 +230,7 @@ def import_spheroid():
 
                 if src_name != esri_name:
                     sql = """INSERT INTO alias_name VALUES('ellipsoid','EPSG','%s','%s','ESRI');""" % (
-                        latestWkid, escape_literal(esri_name))
+                        code, escape_literal(esri_name))
                     all_sql.append(sql)
 
             else:
@@ -309,6 +310,7 @@ def import_prime_meridian():
                 break
             assert len(row) == nfields, row
 
+            code = row[idx_wkid]
             latestWkid = row[idx_latestWkid]
             authority = row[idx_authority]
             esri_name = row[idx_name]
@@ -325,7 +327,7 @@ def import_prime_meridian():
 
                 if src_name != esri_name:
                     sql = """INSERT INTO alias_name VALUES('prime_meridian','EPSG','%s','%s','ESRI');""" % (
-                        latestWkid, escape_literal(esri_name))
+                        code, escape_literal(esri_name))
                     all_sql.append(sql)
 
             else:
@@ -386,6 +388,7 @@ def import_datum():
                 break
             assert len(row) == nfields, row
 
+            code = row[idx_wkid]
             latestWkid = row[idx_latestWkid]
             authority = row[idx_authority]
             esri_name = row[idx_name]
@@ -400,10 +403,9 @@ def import_datum():
                 src_row = cursor.fetchone()
                 assert src_row, row
                 src_name = src_row[0]
-                esri_name = row[idx_name]
                 if src_name != esri_name:
                     sql = """INSERT INTO alias_name VALUES('geodetic_datum','EPSG','%s','%s','ESRI');""" % (
-                        latestWkid, escape_literal(esri_name))
+                        code, escape_literal(esri_name))
                     all_sql.append(sql)
             else:
                 assert authority.upper() == 'ESRI', row
@@ -494,6 +496,7 @@ def import_geogcs():
                 break
             assert len(row) == nfields, row
 
+            code = row[idx_wkid]
             latestWkid = row[idx_latestWkid]
             authority = row[idx_authority]
             esri_name = row[idx_name]
@@ -508,16 +511,13 @@ def import_geogcs():
                 src_row = cursor.fetchone()
                 assert src_row, row
                 src_name = src_row[0]
-                esri_name = row[idx_name]
                 if src_name != esri_name:
                     sql = """INSERT INTO alias_name VALUES('geodetic_crs','EPSG','%s','%s','ESRI');""" % (
-                        latestWkid, escape_literal(esri_name))
+                        code, escape_literal(esri_name))
                     all_sql.append(sql)
             else:
                 assert authority.upper() == 'ESRI', row
 
-                code = row[idx_wkid]
-
                 wkt = row[idx_wkt]
                 pos = wkt.find('DATUM["')
                 assert pos >= 0
@@ -671,6 +671,7 @@ def import_projcs():
                 break
             assert len(row) == nfields, row
 
+            code = row[idx_wkid]
             latestWkid = row[idx_latestWkid]
             authority = row[idx_authority]
             esri_name = row[idx_name]
@@ -688,12 +689,11 @@ def import_projcs():
                 esri_name = row[idx_name]
                 if src_name != esri_name:
                     sql = """INSERT INTO alias_name VALUES('projected_crs','EPSG','%s','%s','ESRI');""" % (
-                        latestWkid, escape_literal(esri_name))
+                        code, escape_literal(esri_name))
                     all_sql.append(sql)
             else:
                 assert authority.upper() == 'ESRI', row
 
-                code = row[idx_wkid]
                 wkid_set.add(code)
 
                 wkt = row[idx_wkt]
@@ -799,7 +799,7 @@ def import_vdatum():
                 esri_name = row[idx_name]
                 if src_name != esri_name:
                     sql = """INSERT INTO alias_name VALUES('vertical_datum','EPSG','%s','%s','ESRI');""" % (
-                        latestWkid, escape_literal(esri_name))
+                        wkid, escape_literal(esri_name))
                     all_sql.append(sql)
             else:
                 assert authority.upper() == 'ESRI', row
@@ -873,6 +873,7 @@ def import_vertcs():
                 break
             assert len(row) == nfields, row
 
+            code = row[idx_wkid]
             latestWkid = row[idx_latestWkid]
             authority = row[idx_authority]
             esri_name = row[idx_name]
@@ -890,13 +891,11 @@ def import_vertcs():
                 esri_name = row[idx_name]
                 if src_name != esri_name:
                     sql = """INSERT INTO alias_name VALUES('vertical_crs','EPSG','%s','%s','ESRI');""" % (
-                        latestWkid, escape_literal(esri_name))
+                        code, escape_literal(esri_name))
                     all_sql.append(sql)
             else:
                 assert authority.upper() == 'ESRI', row
 
-                code = row[idx_wkid]
-
                 wkt = row[idx_wkt]
 
                 if ',DATUM[' in wkt:
@@ -1022,6 +1021,7 @@ def import_hvcoordsys():
                 break
             assert len(row) == nfields, row
 
+            code = row[idx_wkid]
             latestWkid = row[idx_latestWkid]
             authority = row[idx_authority]
             esri_name = row[idx_name]
@@ -1039,7 +1039,7 @@ def import_hvcoordsys():
                 esri_name = row[idx_name]
                 if src_name != esri_name:
                     sql = """INSERT INTO alias_name VALUES('compound_crs','EPSG','%s','%s','ESRI');""" % (
-                        latestWkid, escape_literal(esri_name))
+                        code, escape_literal(esri_name))
                     all_sql.append(sql)
             else:
                 assert False, row  # no ESRI specific entries at that time !