Map ESRI Equidistant_Cylindrical method to EPSG:1029 during ESRI projection engine db ingestion

1 files changed, 52 insertions, 18 deletions

diff --git a/data/sql/esri.sql b/data/sql/esri.sql
index 7952f818..583e5be4 100644
--- a/data/sql/esri.sql
+++ b/data/sql/esri.sql
@@ -8523,7 +8523,9 @@ INSERT INTO alias_name VALUES('projected_crs','EPSG','32761','UPS_South','ESRI')
 INSERT INTO alias_name VALUES('projected_crs','EPSG','32766','WGS_1984_TM_36_SE','ESRI');
 INSERT INTO "projected_crs" VALUES('ESRI','53001','Sphere_Plate_Carree',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Plate_Carree",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Plate_Carree"],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_53001_USAGE','projected_crs','ESRI','53001','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','53002','Sphere_Equidistant_Cylindrical',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Equidistant_Cylindrical",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",60.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','53002','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',60.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_53002_USAGE','conversion','ESRI','53002','EPSG','1262','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','53002','Sphere_Equidistant_Cylindrical',NULL,'EPSG','4400','EPSG','4035','ESRI','53002',NULL,0);
 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');
@@ -8621,7 +8623,7 @@ INSERT INTO "projected_crs" VALUES('ESRI','53080','Sphere_Compact_Miller',NULL,N
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53080_USAGE','projected_crs','ESRI','53080','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','54001','World_Plate_Carree',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Plate_Carree",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Plate_Carree"],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_54001_USAGE','projected_crs','ESRI','54001','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','54002','World_Equidistant_Cylindrical',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Equidistant_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["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",60.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','54002','World_Equidistant_Cylindrical',NULL,'EPSG','4400','EPSG','4326','ESRI','53002',NULL,0);
 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');
@@ -10069,55 +10071,87 @@ INSERT INTO "usage" VALUES('ESRI', 'CONV_102420_USAGE','conversion','ESRI','1024
 INSERT INTO "projected_crs" VALUES('ESRI','102420','ISN_2004_Lambert_2004',NULL,'EPSG','4400','EPSG','5324','ESRI','102420',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102420_USAGE','projected_crs','ESRI','102420','EPSG','1120','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','24','ARC System - Zone 1','ARC System - Zone 1',0.0,32.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102421','WGS_1984_ARC_System_Zone_01',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_01",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",22.94791772],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102421','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',22.94791772,'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_102421_USAGE','conversion','ESRI','102421','ESRI','24','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102421','WGS_1984_ARC_System_Zone_01',NULL,'EPSG','4400','EPSG','4326','ESRI','102421',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102421_USAGE','projected_crs','ESRI','102421','ESRI','24','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','25','ARC System - Zone 2','ARC System - Zone 2',32.0,48.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102422','WGS_1984_ARC_System_Zone_02',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_02",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",41.12682127],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102422','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',41.12682127,'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_102422_USAGE','conversion','ESRI','102422','ESRI','25','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102422','WGS_1984_ARC_System_Zone_02',NULL,'EPSG','4400','EPSG','4326','ESRI','102422',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102422_USAGE','projected_crs','ESRI','102422','ESRI','25','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','26','ARC System - Zone 3','ARC System - Zone 3',48.0,56.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102423','WGS_1984_ARC_System_Zone_03',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_03",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",52.28859923],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102423','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',52.28859923,'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_102423_USAGE','conversion','ESRI','102423','ESRI','26','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102423','WGS_1984_ARC_System_Zone_03',NULL,'EPSG','4400','EPSG','4326','ESRI','102423',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102423_USAGE','projected_crs','ESRI','102423','ESRI','26','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','27','ARC System - Zone 4','ARC System - Zone 4',56.0,64.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102424','WGS_1984_ARC_System_Zone_04',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_04",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",60.32378942],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102424','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',60.32378942,'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_102424_USAGE','conversion','ESRI','102424','ESRI','27','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102424','WGS_1984_ARC_System_Zone_04',NULL,'EPSG','4400','EPSG','4326','ESRI','102424',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102424_USAGE','projected_crs','ESRI','102424','ESRI','27','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','28','ARC System - Zone 5','ARC System - Zone 5',64.0,68.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102425','WGS_1984_ARC_System_Zone_05',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_05",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",66.09421768],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102425','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',66.09421768,'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_102425_USAGE','conversion','ESRI','102425','ESRI','28','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102425','WGS_1984_ARC_System_Zone_05',NULL,'EPSG','4400','EPSG','4326','ESRI','102425',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102425_USAGE','projected_crs','ESRI','102425','ESRI','28','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','29','ARC System - Zone 6','ARC System - Zone 6',68.0,72.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102426','WGS_1984_ARC_System_Zone_06',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_06",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",70.10896259],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102426','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',70.10896259,'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_102426_USAGE','conversion','ESRI','102426','ESRI','29','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102426','WGS_1984_ARC_System_Zone_06',NULL,'EPSG','4400','EPSG','4326','ESRI','102426',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102426_USAGE','projected_crs','ESRI','102426','ESRI','29','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','30','ARC System - Zone 7','ARC System - Zone 7',72.0,76.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102427','WGS_1984_ARC_System_Zone_07',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_07",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",74.13230145],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102427','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',74.13230145,'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_102427_USAGE','conversion','ESRI','102427','ESRI','30','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102427','WGS_1984_ARC_System_Zone_07',NULL,'EPSG','4400','EPSG','4326','ESRI','102427',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102427_USAGE','projected_crs','ESRI','102427','ESRI','30','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','31','ARC System - Zone 8','ARC System - Zone 8',76.0,80.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102428','WGS_1984_ARC_System_Zone_08',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_08",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",78.1728375],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102428','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',78.1728375,'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_102428_USAGE','conversion','ESRI','102428','ESRI','31','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102428','WGS_1984_ARC_System_Zone_08',NULL,'EPSG','4400','EPSG','4326','ESRI','102428',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102428_USAGE','projected_crs','ESRI','102428','ESRI','31','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','32','ARC System - Zone 9','ARC System - Zone 9',80.0,90.0,-180.0,180.0,0);
 INSERT INTO "projected_crs" VALUES('ESRI','102429','WGS_1984_ARC_System_Zone_09',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_09",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Azimuthal_Equidistant"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Latitude_Of_Origin",90.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102429_USAGE','projected_crs','ESRI','102429','ESRI','32','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','33','ARC System - Zone 10','ARC System - Zone 10',-32.0,0.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102430','WGS_1984_ARC_System_Zone_10',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_10",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",-22.94791772],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102430','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',-22.94791772,'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_102430_USAGE','conversion','ESRI','102430','ESRI','33','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102430','WGS_1984_ARC_System_Zone_10',NULL,'EPSG','4400','EPSG','4326','ESRI','102430',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102430_USAGE','projected_crs','ESRI','102430','ESRI','33','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','34','ARC System - Zone 11','ARC System - Zone 11',-48.0,-32.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102431','WGS_1984_ARC_System_Zone_11',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_11",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",-41.12682127],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102431','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',-41.12682127,'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_102431_USAGE','conversion','ESRI','102431','ESRI','34','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102431','WGS_1984_ARC_System_Zone_11',NULL,'EPSG','4400','EPSG','4326','ESRI','102431',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102431_USAGE','projected_crs','ESRI','102431','ESRI','34','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','35','ARC System - Zone 12','ARC System - Zone 12',-56.0,-48.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102432','WGS_1984_ARC_System_Zone_12',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_12",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",-52.28859923],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102432','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',-52.28859923,'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_102432_USAGE','conversion','ESRI','102432','ESRI','35','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102432','WGS_1984_ARC_System_Zone_12',NULL,'EPSG','4400','EPSG','4326','ESRI','102432',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102432_USAGE','projected_crs','ESRI','102432','ESRI','35','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','36','ARC System - Zone 13','ARC System - Zone 13',-64.0,-56.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102433','WGS_1984_ARC_System_Zone_13',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_13",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",-60.32378942],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102433','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',-60.32378942,'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_102433_USAGE','conversion','ESRI','102433','ESRI','36','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102433','WGS_1984_ARC_System_Zone_13',NULL,'EPSG','4400','EPSG','4326','ESRI','102433',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102433_USAGE','projected_crs','ESRI','102433','ESRI','36','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','37','ARC System - Zone 14','ARC System - Zone 14',-68.0,-64.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102434','WGS_1984_ARC_System_Zone_14',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_14",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",-66.09421768],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102434','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',-66.09421768,'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_102434_USAGE','conversion','ESRI','102434','ESRI','37','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102434','WGS_1984_ARC_System_Zone_14',NULL,'EPSG','4400','EPSG','4326','ESRI','102434',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102434_USAGE','projected_crs','ESRI','102434','ESRI','37','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','38','ARC System - Zone 15','ARC System - Zone 15',-72.0,-68.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102435','WGS_1984_ARC_System_Zone_15',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_15",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",-70.10896259],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102435','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',-70.10896259,'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_102435_USAGE','conversion','ESRI','102435','ESRI','38','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102435','WGS_1984_ARC_System_Zone_15',NULL,'EPSG','4400','EPSG','4326','ESRI','102435',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102435_USAGE','projected_crs','ESRI','102435','ESRI','38','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','39','ARC System - Zone 16','ARC System - Zone 16',-76.0,-72.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102436','WGS_1984_ARC_System_Zone_16',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_16",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",-74.13230145],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102436','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',-74.13230145,'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_102436_USAGE','conversion','ESRI','102436','ESRI','39','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102436','WGS_1984_ARC_System_Zone_16',NULL,'EPSG','4400','EPSG','4326','ESRI','102436',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102436_USAGE','projected_crs','ESRI','102436','ESRI','39','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','40','ARC System - Zone 17','ARC System - Zone 17',-80.0,-76.0,-180.0,180.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102437','WGS_1984_ARC_System_Zone_17',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_17",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Cylindrical"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",-78.1728375],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102437','unnamed',NULL,'EPSG','1029','Equidistant Cylindrical (Spherical)','EPSG','8823','Latitude of 1st standard parallel',-78.1728375,'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_102437_USAGE','conversion','ESRI','102437','ESRI','40','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102437','WGS_1984_ARC_System_Zone_17',NULL,'EPSG','4400','EPSG','4326','ESRI','102437',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102437_USAGE','projected_crs','ESRI','102437','ESRI','40','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','41','ARC System - Zone 18','ARC System - Zone 18',-90.0,-80.0,-180.0,180.0,0);
 INSERT INTO "projected_crs" VALUES('ESRI','102438','WGS_1984_ARC_System_Zone_18',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_ARC_System_Zone_18",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Azimuthal_Equidistant"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Latitude_Of_Origin",-90.0],UNIT["Meter",1.0]]',0);