Add some additional method mapping during ESRI db import

2 files changed, 42 insertions, 9 deletions

diff --git a/data/sql/esri.sql b/data/sql/esri.sql
index 09d0bdc5..15a888ba 100644
--- a/data/sql/esri.sql
+++ b/data/sql/esri.sql
@@ -8529,7 +8529,9 @@ INSERT INTO "projected_crs" VALUES('ESRI','53002','Sphere_Equidistant_Cylindrica
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53002_USAGE','projected_crs','ESRI','53002','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','53003','Sphere_Miller_Cylindrical',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Miller_Cylindrical",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Miller_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53003_USAGE','projected_crs','ESRI','53003','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','53004','Sphere_Mercator',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Mercator",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','53004','unnamed',NULL,'EPSG','9805','Mercator (variant B)','EPSG','8823','Latitude of 1st standard parallel',0.0,'EPSG','9102','EPSG','8802','Longitude of natural origin',0.0,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9001','EPSG','8807','False northing',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_53004_USAGE','conversion','ESRI','53004','EPSG','1262','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','53004','Sphere_Mercator',NULL,'EPSG','4400','EPSG','4035','ESRI','53004',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53004_USAGE','projected_crs','ESRI','53004','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','53008','Sphere_Sinusoidal',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Sinusoidal",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Sinusoidal"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53008_USAGE','projected_crs','ESRI','53008','EPSG','1262','EPSG','1024');
@@ -8555,7 +8557,9 @@ INSERT INTO "projected_crs" VALUES('ESRI','53018','Sphere_Winkel_I',NULL,NULL,NU
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53018_USAGE','projected_crs','ESRI','53018','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','53019','Sphere_Winkel_II',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Winkel_II",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Winkel_II"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",50.45977625218981],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53019_USAGE','projected_crs','ESRI','53019','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','53021','Sphere_Polyconic',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Polyconic",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Polyconic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','53021','unnamed',NULL,'EPSG','9818','American Polyconic','EPSG','8801','Latitude of natural origin',0.0,'EPSG','9102','EPSG','8802','Longitude of natural origin',0.0,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9001','EPSG','8807','False northing',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_53021_USAGE','conversion','ESRI','53021','EPSG','1262','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','53021','Sphere_Polyconic',NULL,'EPSG','4400','EPSG','4035','ESRI','53021',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53021_USAGE','projected_crs','ESRI','53021','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','53022','Sphere_Quartic_Authalic',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Quartic_Authalic",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Quartic_Authalic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53022_USAGE','projected_crs','ESRI','53022','EPSG','1262','EPSG','1024');
@@ -8629,7 +8633,7 @@ INSERT INTO "projected_crs" VALUES('ESRI','54002','World_Equidistant_Cylindrical
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54002_USAGE','projected_crs','ESRI','54002','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','54003','World_Miller_Cylindrical',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Miller_Cylindrical",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Miller_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54003_USAGE','projected_crs','ESRI','54003','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','54004','World_Mercator',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Mercator",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','54004','World_Mercator',NULL,'EPSG','4400','EPSG','4326','ESRI','53004',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54004_USAGE','projected_crs','ESRI','54004','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','54008','World_Sinusoidal',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Sinusoidal",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Sinusoidal"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54008_USAGE','projected_crs','ESRI','54008','EPSG','1262','EPSG','1024');
@@ -8655,7 +8659,7 @@ INSERT INTO "projected_crs" VALUES('ESRI','54018','World_Winkel_I',NULL,NULL,NUL
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54018_USAGE','projected_crs','ESRI','54018','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','54019','World_Winkel_II',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Winkel_II",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Winkel_II"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",50.45977625218981],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54019_USAGE','projected_crs','ESRI','54019','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','54021','World_Polyconic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Polyconic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Polyconic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','54021','World_Polyconic',NULL,'EPSG','4400','EPSG','4326','ESRI','53021',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54021_USAGE','projected_crs','ESRI','54021','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','54022','World_Quartic_Authalic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Quartic_Authalic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Quartic_Authalic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54022_USAGE','projected_crs','ESRI','54022','EPSG','1262','EPSG','1024');
@@ -8741,13 +8745,17 @@ INSERT INTO "projected_crs" VALUES('ESRI','54100','WGS_1984_Tobler_Cylindrical_I
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54100_USAGE','projected_crs','ESRI','54100','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','54101','WGS_1984_Tobler_Cylindrical_II',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_Tobler_Cylindrical_II",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Tobler_Cylindrical_II"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54101_USAGE','projected_crs','ESRI','54101','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','65061','NAD_1927_StatePlane_Guam_FIPS_5400',NULL,NULL,NULL,'EPSG','4267',NULL,NULL,'PROJCS["NAD_1927_StatePlane_Guam_FIPS_5400",GEOGCS["GCS_North_American_1927",DATUM["D_North_American_1927",SPHEROID["Clarke_1866",6378206.4,294.9786982]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Polyconic"],PARAMETER["False_Easting",164041.6666666667],PARAMETER["False_Northing",164041.6666666667],PARAMETER["Central_Meridian",144.7487507055556],PARAMETER["Latitude_Of_Origin",13.47246635277778],UNIT["Foot_US",0.3048006096012192]]',0);
+INSERT INTO "conversion" VALUES('ESRI','65061','unnamed',NULL,'EPSG','9818','American Polyconic','EPSG','8801','Latitude of natural origin',13.47246635277778,'EPSG','9102','EPSG','8802','Longitude of natural origin',144.7487507055556,'EPSG','9102','EPSG','8806','False easting',164041.6666666667,'EPSG','9003','EPSG','8807','False northing',164041.6666666667,'EPSG','9003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_65061_USAGE','conversion','ESRI','65061','EPSG','1110','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','65061','NAD_1927_StatePlane_Guam_FIPS_5400',NULL,'EPSG','4497','EPSG','4267','ESRI','65061',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_65061_USAGE','projected_crs','ESRI','65061','EPSG','1110','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','65062','unnamed',NULL,'EPSG','9801','Lambert Conic Conformal (1SP)','EPSG','8801','Latitude of natural origin',-14.26666666666667,'EPSG','9102','EPSG','8802','Longitude of natural origin',-170.0,'EPSG','9102','EPSG','8805','Scale factor at natural origin',1.0,'EPSG','9201','EPSG','8806','False easting',500000.0,'EPSG','9003','EPSG','8807','False northing',312234.65,'EPSG','9003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_65062_USAGE','conversion','ESRI','65062','EPSG','1027','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','65062','American_Samoa_1962_StatePlane_American_Samoa_FIPS_5300',NULL,'EPSG','4497','EPSG','4169','ESRI','65062',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_65062_USAGE','projected_crs','ESRI','65062','EPSG','1027','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','65161','NAD_1983_StatePlane_Guam_FIPS_5400',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_StatePlane_Guam_FIPS_5400",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Polyconic"],PARAMETER["False_Easting",50000.0],PARAMETER["False_Northing",50000.0],PARAMETER["Central_Meridian",144.7487507055556],PARAMETER["Latitude_Of_Origin",13.47246635277778],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','65161','unnamed',NULL,'EPSG','9818','American Polyconic','EPSG','8801','Latitude of natural origin',13.47246635277778,'EPSG','9102','EPSG','8802','Longitude of natural origin',144.7487507055556,'EPSG','9102','EPSG','8806','False easting',50000.0,'EPSG','9001','EPSG','8807','False northing',50000.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_65161_USAGE','conversion','ESRI','65161','EPSG','1110','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','65161','NAD_1983_StatePlane_Guam_FIPS_5400',NULL,'EPSG','4400','EPSG','4269','ESRI','65161',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_65161_USAGE','projected_crs','ESRI','65161','EPSG','1110','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','65163','unnamed',NULL,'EPSG','9802','Lambert Conic Conformal (2SP)','EPSG','8821','Latitude of false origin',36.33333333333334,'EPSG','9102','EPSG','8822','Longitude of false origin',-85.75,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',37.08333333333334,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',38.66666666666666,'EPSG','9102','EPSG','8826','Easting at false origin',1500000.0,'EPSG','9001','EPSG','8827','Northing at false origin',1000000.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_65163_USAGE','conversion','ESRI','65163','EPSG','1386','EPSG','1024');
@@ -9094,7 +9102,9 @@ INSERT INTO "conversion" VALUES('ESRI','102112','unnamed',NULL,'EPSG','9807','Tr
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102112_USAGE','conversion','ESRI','102112','EPSG','2889','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102112','NZGD_2000_Chatham_Island_Circuit',NULL,'EPSG','4400','EPSG','4167','ESRI','102112',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102112_USAGE','projected_crs','ESRI','102112','EPSG','2889','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102113','WGS_1984_Web_Mercator',NULL,NULL,NULL,'EPSG','4055',NULL,NULL,'PROJCS["WGS_1984_Web_Mercator",GEOGCS["GCS_WGS_1984_Major_Auxiliary_Sphere",DATUM["D_WGS_1984_Major_Auxiliary_Sphere",SPHEROID["WGS_1984_Major_Auxiliary_Sphere",6378137.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102113','unnamed',NULL,'EPSG','9805','Mercator (variant B)','EPSG','8823','Latitude of 1st standard parallel',0.0,'EPSG','9102','EPSG','8802','Longitude of natural origin',0.0,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9001','EPSG','8807','False northing',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102113_USAGE','conversion','ESRI','102113','EPSG','3544','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102113','WGS_1984_Web_Mercator',NULL,'EPSG','4400','EPSG','4055','ESRI','102113',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102113_USAGE','projected_crs','ESRI','102113','EPSG','3544','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102114','Old_Hawaiian_UTM_Zone_4N',NULL,'EPSG','4400','EPSG','4135','EPSG','16004',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102114_USAGE','projected_crs','ESRI','102114','EPSG','3488','EPSG','1024');
@@ -11278,7 +11288,9 @@ INSERT INTO "projected_crs" VALUES('ESRI','102764','Pulkovo_1942_Adj_1983_3_Degr
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102764_USAGE','projected_crs','ESRI','102764','EPSG','3584','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102765','Pulkovo_1942_Adj_1983_3_Degree_GK_Zone_8',NULL,'EPSG','4400','EPSG','4178','EPSG','16268',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102765_USAGE','projected_crs','ESRI','102765','EPSG','3586','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102766','NAD_1983_StatePlane_Guam_FIPS_5400_Feet',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_StatePlane_Guam_FIPS_5400_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Polyconic"],PARAMETER["False_Easting",164041.6666666666],PARAMETER["False_Northing",164041.6666666666],PARAMETER["Central_Meridian",144.7487507055556],PARAMETER["Latitude_Of_Origin",13.47246635277778],UNIT["Foot_US",0.3048006096012192]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102766','unnamed',NULL,'EPSG','9818','American Polyconic','EPSG','8801','Latitude of natural origin',13.47246635277778,'EPSG','9102','EPSG','8802','Longitude of natural origin',144.7487507055556,'EPSG','9102','EPSG','8806','False easting',164041.6666666666,'EPSG','9003','EPSG','8807','False northing',164041.6666666666,'EPSG','9003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102766_USAGE','conversion','ESRI','102766','EPSG','1110','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102766','NAD_1983_StatePlane_Guam_FIPS_5400_Feet',NULL,'EPSG','4497','EPSG','4269','ESRI','102766',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102766_USAGE','projected_crs','ESRI','102766','EPSG','1110','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','56','Colombia - Leticia - Amazonas','Colombia - Leticia - Amazonas',-4.7,-3.683333333333334,-70.45,-69.43333333333334,0);
 INSERT INTO "conversion" VALUES('ESRI','102767','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',-4.197684047222222,'EPSG','9102','EPSG','8802','Longitude of natural origin',-69.94281105833333,'EPSG','9102','EPSG','8806','False easting',25978.217,'EPSG','9001','EPSG','8807','False northing',27501.365,'EPSG','9001','EPSG','1039','Projection plane origin height',89.7,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
diff --git a/scripts/build_db_from_esri.py b/scripts/build_db_from_esri.py
index 4a86ea1a..75b64fe0 100755
--- a/scripts/build_db_from_esri.py
+++ b/scripts/build_db_from_esri.py
@@ -1072,7 +1072,28 @@ MAPPED_PROJCS: Dict[str, ConversionMapping] = {
             8806: 'False_Easting',
             8807: 'False_Northing',
         }
-    )
+    ),
+    'Mercator': ConversionMapping(
+        epsg_code='9805',
+        epsg_name='Mercator (variant B)',
+        param_mapping={
+            8823: 'Standard_Parallel_1',
+            8802: 'Central_Meridian',
+            8806: 'False_Easting',
+            8807: 'False_Northing',
+        }
+    ),
+    'Polyconic': ConversionMapping(
+        epsg_code='9818',
+        epsg_name='American Polyconic',
+        param_mapping={
+            8801: 'Latitude_Of_Origin',
+            8802: 'Central_Meridian',
+            8806: 'False_Easting',
+            8807: 'False_Northing',
+        }
+    ),
+
 }
 
 MAPPED_PROJCS_WITH_EXTRA_LOGIC: Dict[str, Dict[str, ConversionMapping]] = {