From 837857386bcf62e42cbde402385e81f727cc674a Mon Sep 17 00:00:00 2001
From: Nyall Dawson <nyall.dawson@gmail.com>
Date: Tue, 23 Nov 2021 08:44:39 +1000
Subject: Map ESRI Albers method to EPSG:9822 during ESRI projection engine db
 ingestion

---
 data/sql/esri.sql | 106 +++++++++++++++++++++++++++++++++++++++---------------
 1 file changed, 77 insertions(+), 29 deletions(-)

(limited to 'data/sql/esri.sql')

diff --git a/data/sql/esri.sql b/data/sql/esri.sql
index 23bcc91f..de949619 100644
--- a/data/sql/esri.sql
+++ b/data/sql/esri.sql
@@ -8749,13 +8749,17 @@ INSERT INTO "conversion" VALUES('ESRI','65163','unnamed',NULL,'EPSG','9802','Lam
 INSERT INTO "usage" VALUES('ESRI', 'CONV_65163_USAGE','conversion','ESRI','65163','EPSG','1386','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','65163','NAD_1983_StatePlane_Kentucky_FIPS_1600',NULL,'EPSG','4400','EPSG','4269','ESRI','65163',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_65163_USAGE','projected_crs','ESRI','65163','EPSG','1386','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102001','Canada_Albers_Equal_Area_Conic',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["Canada_Albers_Equal_Area_Conic",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",50.0],PARAMETER["Standard_Parallel_2",70.0],PARAMETER["Latitude_Of_Origin",40.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102001','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',40.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-96.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',50.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',70.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102001_USAGE','conversion','ESRI','102001','EPSG','1061','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102001','Canada_Albers_Equal_Area_Conic',NULL,'EPSG','4400','EPSG','4269','ESRI','102001',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102001_USAGE','projected_crs','ESRI','102001','EPSG','1061','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102002','unnamed',NULL,'EPSG','9802','Lambert Conic Conformal (2SP)','EPSG','8821','Latitude of false origin',40.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-96.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',50.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',70.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102002_USAGE','conversion','ESRI','102002','EPSG','1061','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102002','Canada_Lambert_Conformal_Conic',NULL,'EPSG','4400','EPSG','4269','ESRI','102002',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102002_USAGE','projected_crs','ESRI','102002','EPSG','1061','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102003','USA_Contiguous_Albers_Equal_Area_Conic',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["USA_Contiguous_Albers_Equal_Area_Conic",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",29.5],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",37.5],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102003','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',37.5,'EPSG','9102','EPSG','8822','Longitude of false origin',-96.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',29.5,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',45.5,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102003_USAGE','conversion','ESRI','102003','EPSG','1323','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102003','USA_Contiguous_Albers_Equal_Area_Conic',NULL,'EPSG','4400','EPSG','4269','ESRI','102003',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102003_USAGE','projected_crs','ESRI','102003','EPSG','1323','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102004','unnamed',NULL,'EPSG','9802','Lambert Conic Conformal (2SP)','EPSG','8821','Latitude of false origin',39.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-96.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',33.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',45.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102004_USAGE','conversion','ESRI','102004','EPSG','1323','EPSG','1024');
@@ -8763,11 +8767,17 @@ INSERT INTO "projected_crs" VALUES('ESRI','102004','USA_Contiguous_Lambert_Confo
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102004_USAGE','projected_crs','ESRI','102004','EPSG','1323','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102005','USA_Contiguous_Equidistant_Conic',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["USA_Contiguous_Equidistant_Conic",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["Equidistant_Conic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",33.0],PARAMETER["Standard_Parallel_2",45.0],PARAMETER["Latitude_Of_Origin",39.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102005_USAGE','projected_crs','ESRI','102005','EPSG','1323','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102006','NAD_1983_Alaska_Albers',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_Alaska_Albers",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-154.0],PARAMETER["Standard_Parallel_1",55.0],PARAMETER["Standard_Parallel_2",65.0],PARAMETER["Latitude_Of_Origin",50.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102006','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',50.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-154.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',55.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',65.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102006_USAGE','conversion','ESRI','102006','EPSG','1330','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102006','NAD_1983_Alaska_Albers',NULL,'EPSG','4400','EPSG','4269','ESRI','102006',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102006_USAGE','projected_crs','ESRI','102006','EPSG','1330','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102007','Hawaii_Albers_Equal_Area_Conic',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["Hawaii_Albers_Equal_Area_Conic",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-157.0],PARAMETER["Standard_Parallel_1",8.0],PARAMETER["Standard_Parallel_2",18.0],PARAMETER["Latitude_Of_Origin",13.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102007','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',13.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-157.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',8.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',18.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102007_USAGE','conversion','ESRI','102007','EPSG','1334','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102007','Hawaii_Albers_Equal_Area_Conic',NULL,'EPSG','4400','EPSG','4269','ESRI','102007',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102007_USAGE','projected_crs','ESRI','102007','EPSG','1334','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102008','North_America_Albers_Equal_Area_Conic',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["North_America_Albers_Equal_Area_Conic",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",20.0],PARAMETER["Standard_Parallel_2",60.0],PARAMETER["Latitude_Of_Origin",40.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102008','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',40.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-96.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',20.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',60.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102008_USAGE','conversion','ESRI','102008','EPSG','1325','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102008','North_America_Albers_Equal_Area_Conic',NULL,'EPSG','4400','EPSG','4269','ESRI','102008',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102008_USAGE','projected_crs','ESRI','102008','EPSG','1325','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102009','unnamed',NULL,'EPSG','9802','Lambert Conic Conformal (2SP)','EPSG','8821','Latitude of false origin',40.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-96.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',20.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',60.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102009_USAGE','conversion','ESRI','102009','EPSG','1325','EPSG','1024');
@@ -8784,7 +8794,9 @@ INSERT INTO "usage" VALUES('ESRI', 'CONV_102012_USAGE','conversion','ESRI','1020
 INSERT INTO "projected_crs" VALUES('ESRI','102012','Asia_Lambert_Conformal_Conic',NULL,'EPSG','4400','EPSG','4326','ESRI','102012',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102012_USAGE','projected_crs','ESRI','102012','ESRI','5','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','6','Europe','Europe',34.0,85.0,-30.0,50.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102013','Europe_Albers_Equal_Area_Conic',NULL,NULL,NULL,'EPSG','4230',NULL,NULL,'PROJCS["Europe_Albers_Equal_Area_Conic",GEOGCS["GCS_European_1950",DATUM["D_European_1950",SPHEROID["International_1924",6378388.0,297.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",10.0],PARAMETER["Standard_Parallel_1",43.0],PARAMETER["Standard_Parallel_2",62.0],PARAMETER["Latitude_Of_Origin",30.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102013','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',30.0,'EPSG','9102','EPSG','8822','Longitude of false origin',10.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',43.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',62.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102013_USAGE','conversion','ESRI','102013','ESRI','6','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102013','Europe_Albers_Equal_Area_Conic',NULL,'EPSG','4400','EPSG','4230','ESRI','102013',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102013_USAGE','projected_crs','ESRI','102013','ESRI','6','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102014','unnamed',NULL,'EPSG','9802','Lambert Conic Conformal (2SP)','EPSG','8821','Latitude of false origin',30.0,'EPSG','9102','EPSG','8822','Longitude of false origin',10.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',43.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',62.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102014_USAGE','conversion','ESRI','102014','ESRI','6','EPSG','1024');
@@ -8807,7 +8819,9 @@ INSERT INTO "projected_crs" VALUES('ESRI','102020','South_Pole_Lambert_Azimuthal
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102020_USAGE','projected_crs','ESRI','102020','EPSG','3474','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102021','South_Pole_Stereographic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["South_Pole_Stereographic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Stereographic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",-90.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102021_USAGE','projected_crs','ESRI','102021','EPSG','3474','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102022','Africa_Albers_Equal_Area_Conic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["Africa_Albers_Equal_Area_Conic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",25.0],PARAMETER["Standard_Parallel_1",20.0],PARAMETER["Standard_Parallel_2",-23.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102022','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',0.0,'EPSG','9102','EPSG','8822','Longitude of false origin',25.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',20.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',-23.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102022_USAGE','conversion','ESRI','102022','ESRI','4','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102022','Africa_Albers_Equal_Area_Conic',NULL,'EPSG','4400','EPSG','4326','ESRI','102022',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102022_USAGE','projected_crs','ESRI','102022','ESRI','4','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102023','Africa_Equidistant_Conic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["Africa_Equidistant_Conic",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_Conic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",25.0],PARAMETER["Standard_Parallel_1",20.0],PARAMETER["Standard_Parallel_2",-23.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102023_USAGE','projected_crs','ESRI','102023','ESRI','4','EPSG','1024');
@@ -8816,7 +8830,9 @@ INSERT INTO "usage" VALUES('ESRI', 'CONV_102024_USAGE','conversion','ESRI','1020
 INSERT INTO "projected_crs" VALUES('ESRI','102024','Africa_Lambert_Conformal_Conic',NULL,'EPSG','4400','EPSG','4326','ESRI','102024',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102024_USAGE','projected_crs','ESRI','102024','ESRI','4','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','8','Asia - North','Asia - North',10.0,85.0,25.0,-175.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102025','Asia_North_Albers_Equal_Area_Conic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["Asia_North_Albers_Equal_Area_Conic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",95.0],PARAMETER["Standard_Parallel_1",15.0],PARAMETER["Standard_Parallel_2",65.0],PARAMETER["Latitude_Of_Origin",30.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102025','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',30.0,'EPSG','9102','EPSG','8822','Longitude of false origin',95.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',15.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',65.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102025_USAGE','conversion','ESRI','102025','ESRI','8','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102025','Asia_North_Albers_Equal_Area_Conic',NULL,'EPSG','4400','EPSG','4326','ESRI','102025',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102025_USAGE','projected_crs','ESRI','102025','ESRI','8','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102026','Asia_North_Equidistant_Conic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["Asia_North_Equidistant_Conic",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_Conic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",95.0],PARAMETER["Standard_Parallel_1",15.0],PARAMETER["Standard_Parallel_2",65.0],PARAMETER["Latitude_Of_Origin",30.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102026_USAGE','projected_crs','ESRI','102026','ESRI','8','EPSG','1024');
@@ -8825,7 +8841,9 @@ INSERT INTO "usage" VALUES('ESRI', 'CONV_102027_USAGE','conversion','ESRI','1020
 INSERT INTO "projected_crs" VALUES('ESRI','102027','Asia_North_Lambert_Conformal_Conic',NULL,'EPSG','4400','EPSG','4326','ESRI','102027',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102027_USAGE','projected_crs','ESRI','102027','ESRI','8','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','9','Asia - South','Asia - South',-10.0,30.0,25.0,165.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102028','Asia_South_Albers_Equal_Area_Conic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["Asia_South_Albers_Equal_Area_Conic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",125.0],PARAMETER["Standard_Parallel_1",7.0],PARAMETER["Standard_Parallel_2",-32.0],PARAMETER["Latitude_Of_Origin",-15.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102028','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',-15.0,'EPSG','9102','EPSG','8822','Longitude of false origin',125.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',7.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',-32.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102028_USAGE','conversion','ESRI','102028','ESRI','9','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102028','Asia_South_Albers_Equal_Area_Conic',NULL,'EPSG','4400','EPSG','4326','ESRI','102028',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102028_USAGE','projected_crs','ESRI','102028','ESRI','9','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102029','Asia_South_Equidistant_Conic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["Asia_South_Equidistant_Conic",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_Conic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",125.0],PARAMETER["Standard_Parallel_1",7.0],PARAMETER["Standard_Parallel_2",-32.0],PARAMETER["Latitude_Of_Origin",-15.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102029_USAGE','projected_crs','ESRI','102029','ESRI','9','EPSG','1024');
@@ -8837,7 +8855,9 @@ INSERT INTO "projected_crs" VALUES('ESRI','102031','Europe_Equidistant_Conic',NU
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102031_USAGE','projected_crs','ESRI','102031','ESRI','6','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102032','South_America_Equidistant_Conic',NULL,NULL,NULL,'EPSG','4618',NULL,NULL,'PROJCS["South_America_Equidistant_Conic",GEOGCS["GCS_South_American_1969",DATUM["D_South_American_1969",SPHEROID["GRS_1967_Truncated",6378160.0,298.25]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Conic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-60.0],PARAMETER["Standard_Parallel_1",-5.0],PARAMETER["Standard_Parallel_2",-42.0],PARAMETER["Latitude_Of_Origin",-32.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102032_USAGE','projected_crs','ESRI','102032','ESRI','7','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102033','South_America_Albers_Equal_Area_Conic',NULL,NULL,NULL,'EPSG','4618',NULL,NULL,'PROJCS["South_America_Albers_Equal_Area_Conic",GEOGCS["GCS_South_American_1969",DATUM["D_South_American_1969",SPHEROID["GRS_1967_Truncated",6378160.0,298.25]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-60.0],PARAMETER["Standard_Parallel_1",-5.0],PARAMETER["Standard_Parallel_2",-42.0],PARAMETER["Latitude_Of_Origin",-32.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102033','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',-32.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-60.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',-5.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',-42.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102033_USAGE','conversion','ESRI','102033','ESRI','7','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102033','South_America_Albers_Equal_Area_Conic',NULL,'EPSG','4400','EPSG','4618','ESRI','102033',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102033_USAGE','projected_crs','ESRI','102033','ESRI','7','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102034','North_Pole_Gnomonic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["North_Pole_Gnomonic",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Gnomonic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Longitude_Of_Center",0.0],PARAMETER["Latitude_Of_Center",90.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102034_USAGE','projected_crs','ESRI','102034','EPSG','3475','EPSG','1024');
@@ -8849,7 +8869,9 @@ INSERT INTO "projected_crs" VALUES('ESRI','102037','South_Pole_Orthographic',NUL
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102037_USAGE','projected_crs','ESRI','102037','EPSG','3474','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102038','The_World_From_Space',NULL,NULL,NULL,'ESRI','37008',NULL,NULL,'PROJCS["The_World_From_Space",GEOGCS["GCS_Sphere_ARC_INFO",DATUM["D_Sphere_ARC_INFO",SPHEROID["Sphere_ARC_INFO",6370997.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Orthographic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Longitude_Of_Center",-72.5333333334],PARAMETER["Latitude_Of_Center",42.5333333333],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102038_USAGE','projected_crs','ESRI','102038','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102039','USA_Contiguous_Albers_Equal_Area_Conic_USGS_version',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["USA_Contiguous_Albers_Equal_Area_Conic_USGS_version",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",29.5],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",23.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102039','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',23.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-96.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',29.5,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',45.5,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102039_USAGE','conversion','ESRI','102039','EPSG','1323','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102039','USA_Contiguous_Albers_Equal_Area_Conic_USGS_version',NULL,'EPSG','4400','EPSG','4269','ESRI','102039',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102039_USAGE','projected_crs','ESRI','102039','EPSG','1323','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102040','unnamed',NULL,'EPSG','9807','Transverse Mercator','EPSG','8801','Latitude of natural origin',38.0,'EPSG','9102','EPSG','8802','Longitude of natural origin',127.5,'EPSG','9102','EPSG','8805','Scale factor at natural origin',0.9996,'EPSG','9201','EPSG','8806','False easting',1000000.0,'EPSG','9001','EPSG','8807','False northing',2000000.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102040_USAGE','conversion','ESRI','102040','EPSG','3266','EPSG','1024');
@@ -8861,7 +8883,9 @@ INSERT INTO "usage" VALUES('ESRI', 'CONV_102041_USAGE','conversion','ESRI','1020
 INSERT INTO "projected_crs" VALUES('ESRI','102041','COB_NAD83_2007',NULL,'EPSG','4497','EPSG','4152','ESRI','102041',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102041_USAGE','projected_crs','ESRI','102041','ESRI','10','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','11','USA - USFS - Eastern Region','USA - USFS - Eastern Region',35.9,49.5,-97.3,-66.8,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102042','NAD_1983_USFS_R9_Albers',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_USFS_R9_Albers",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.25],PARAMETER["Standard_Parallel_1",38.25],PARAMETER["Standard_Parallel_2",47.25],PARAMETER["Latitude_Of_Origin",35.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102042','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',35.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-82.25,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',38.25,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',47.25,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102042_USAGE','conversion','ESRI','102042','ESRI','11','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102042','NAD_1983_USFS_R9_Albers',NULL,'EPSG','4400','EPSG','4269','ESRI','102042',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102042_USAGE','projected_crs','ESRI','102042','ESRI','11','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102043','NAD_1983_CORS96_UTM_Zone_20N',NULL,'EPSG','4400','EPSG','6783','EPSG','16020',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102043_USAGE','projected_crs','ESRI','102043','EPSG','2251','EPSG','1024');
@@ -9074,9 +9098,13 @@ INSERT INTO "projected_crs" VALUES('ESRI','102115','Old_Hawaiian_UTM_Zone_5N',NU
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102115_USAGE','projected_crs','ESRI','102115','EPSG','3491','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102116','American_Samoa_1962_UTM_Zone_2S',NULL,'EPSG','4400','EPSG','4169','EPSG','16102',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102116_USAGE','projected_crs','ESRI','102116','EPSG','1027','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102117','NAD_1927_Alaska_Albers_Meters',NULL,NULL,NULL,'EPSG','4267',NULL,NULL,'PROJCS["NAD_1927_Alaska_Albers_Meters",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-154.0],PARAMETER["Standard_Parallel_1",55.0],PARAMETER["Standard_Parallel_2",65.0],PARAMETER["Latitude_Of_Origin",50.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102117','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',50.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-154.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',55.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',65.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102117_USAGE','conversion','ESRI','102117','EPSG','1330','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102117','NAD_1927_Alaska_Albers_Meters',NULL,'EPSG','4400','EPSG','4267','ESRI','102117',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102117_USAGE','projected_crs','ESRI','102117','EPSG','1330','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102118','NAD_1927_Georgia_Statewide_Albers',NULL,NULL,NULL,'EPSG','4267',NULL,NULL,'PROJCS["NAD_1927_Georgia_Statewide_Albers",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-83.5],PARAMETER["Standard_Parallel_1",29.5],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",23.0],UNIT["Foot_US",0.3048006096012192]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102118','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',23.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-83.5,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',29.5,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',45.5,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9003','EPSG','8827','Northing at false origin',0.0,'EPSG','9003',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102118_USAGE','conversion','ESRI','102118','EPSG','1380','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102118','NAD_1927_Georgia_Statewide_Albers',NULL,'EPSG','4497','EPSG','4267','ESRI','102118',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102118_USAGE','projected_crs','ESRI','102118','EPSG','1380','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102119','unnamed',NULL,'EPSG','9802','Lambert Conic Conformal (2SP)','EPSG','8821','Latitude of false origin',31.16666666666667,'EPSG','9102','EPSG','8822','Longitude of false origin',-100.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',27.41666666666667,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',34.91666666666666,'EPSG','9102','EPSG','8826','Easting at false origin',3000000.0,'EPSG','9002','EPSG','8827','Northing at false origin',3000000.0,'EPSG','9002',NULL,NULL,NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102119_USAGE','conversion','ESRI','102119','EPSG','1412','EPSG','1024');
@@ -9267,7 +9295,9 @@ INSERT INTO "projected_crs" VALUES('ESRI','102188','NAD_1983_3TM_117',NULL,'EPSG
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102188_USAGE','projected_crs','ESRI','102188','EPSG','3541','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102189','NAD_1983_3TM_120',NULL,'EPSG','4400','EPSG','4269','EPSG','17726',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102189_USAGE','projected_crs','ESRI','102189','EPSG','3540','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102190','NAD_1983_BC_Environment_Albers',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_BC_Environment_Albers",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["Albers"],PARAMETER["False_Easting",1000000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-126.0],PARAMETER["Standard_Parallel_1",50.0],PARAMETER["Standard_Parallel_2",58.5],PARAMETER["Latitude_Of_Origin",45.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102190','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',45.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-126.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',50.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',58.5,'EPSG','9102','EPSG','8826','Easting at false origin',1000000.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102190_USAGE','conversion','ESRI','102190','EPSG','2832','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102190','NAD_1983_BC_Environment_Albers',NULL,'EPSG','4400','EPSG','4269','ESRI','102190',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102190_USAGE','projected_crs','ESRI','102190','EPSG','2832','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102191','unnamed',NULL,'EPSG','9801','Lambert Conic Conformal (1SP)','EPSG','8801','Latitude of natural origin',33.3,'EPSG','9102','EPSG','8802','Longitude of natural origin',-5.4,'EPSG','9102','EPSG','8805','Scale factor at natural origin',0.999625769,'EPSG','9201','EPSG','8806','False easting',500000.0,'EPSG','9001','EPSG','8807','False northing',300000.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102191_USAGE','conversion','ESRI','102191','EPSG','1703','EPSG','1024');
@@ -9362,7 +9392,9 @@ INSERT INTO "conversion" VALUES('ESRI','102217','unnamed',NULL,'EPSG','9807','Tr
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102217_USAGE','conversion','ESRI','102217','EPSG','1418','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102217','NAD_1983_NSRS2007_Wisconsin_TM_US_Ft',NULL,'EPSG','4497','EPSG','4759','ESRI','102217',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102217_USAGE','projected_crs','ESRI','102217','EPSG','1418','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102218','NAD_1983_USFS_R6_Albers',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_USFS_R6_Albers",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["Albers"],PARAMETER["False_Easting",600000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-120.0],PARAMETER["Standard_Parallel_1",43.0],PARAMETER["Standard_Parallel_2",48.0],PARAMETER["Latitude_Of_Origin",34.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102218','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',34.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-120.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',43.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',48.0,'EPSG','9102','EPSG','8826','Easting at false origin',600000.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102218_USAGE','conversion','ESRI','102218','EPSG','2381','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102218','NAD_1983_USFS_R6_Albers',NULL,'EPSG','4400','EPSG','4269','ESRI','102218',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102218_USAGE','projected_crs','ESRI','102218','EPSG','2381','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102219','NAD_1983_Wisconsin_TM_US_Ft',NULL,'EPSG','4497','EPSG','4269','ESRI','102217',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102219_USAGE','projected_crs','ESRI','102219','EPSG','1418','EPSG','1024');
@@ -9455,7 +9487,7 @@ INSERT INTO "conversion" VALUES('ESRI','102246','unnamed',NULL,'EPSG','9802','La
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102246_USAGE','conversion','ESRI','102246','EPSG','2180','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102246','NAD_1983_HARN_StatePlane_California_VI_FIPS_0406',NULL,'EPSG','4400','EPSG','4152','ESRI','102246',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102246_USAGE','projected_crs','ESRI','102246','EPSG','2180','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102247','NAD_1983_CORS96_Alaska_Albers',NULL,NULL,NULL,'EPSG','6783',NULL,NULL,'PROJCS["NAD_1983_CORS96_Alaska_Albers",GEOGCS["GCS_NAD_1983_CORS96",DATUM["D_NAD_1983_CORS96",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-154.0],PARAMETER["Standard_Parallel_1",55.0],PARAMETER["Standard_Parallel_2",65.0],PARAMETER["Latitude_Of_Origin",50.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','102247','NAD_1983_CORS96_Alaska_Albers',NULL,'EPSG','4400','EPSG','6783','ESRI','102117',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102247_USAGE','projected_crs','ESRI','102247','EPSG','1330','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102248','unnamed',NULL,'EPSG','9807','Transverse Mercator','EPSG','8801','Latitude of natural origin',31.0,'EPSG','9102','EPSG','8802','Longitude of natural origin',-110.1666666666667,'EPSG','9102','EPSG','8805','Scale factor at natural origin',0.9999,'EPSG','9201','EPSG','8806','False easting',213360.0,'EPSG','9001','EPSG','8807','False northing',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102248_USAGE','conversion','ESRI','102248','EPSG','2167','EPSG','1024');
@@ -9986,7 +10018,9 @@ INSERT INTO "usage" VALUES('ESRI', 'CONV_102398_USAGE','conversion','ESRI','1023
 INSERT INTO "projected_crs" VALUES('ESRI','102398','NAD_1983_2011_StatePlane_Alaska_10_FIPS_5010_Feet',NULL,'EPSG','4497','EPSG','6318','ESRI','102398',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102398_USAGE','projected_crs','ESRI','102398','EPSG','2157','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','23','USA - Montana, North Dakota, and South Dakota','USA - Montana, North Dakota, and South Dakota',44.3,49.1,-116.1,-96.3,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102399','NAD_1983_Albers_BLM_MT_ND_SD',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_Albers_BLM_MT_ND_SD",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-106.0],PARAMETER["Standard_Parallel_1",43.5],PARAMETER["Standard_Parallel_2",48.0],PARAMETER["Latitude_Of_Origin",42.5],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102399','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',42.5,'EPSG','9102','EPSG','8822','Longitude of false origin',-106.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',43.5,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',48.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102399_USAGE','conversion','ESRI','102399','ESRI','23','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102399','NAD_1983_Albers_BLM_MT_ND_SD',NULL,'EPSG','4400','EPSG','4269','ESRI','102399',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102399_USAGE','projected_crs','ESRI','102399','ESRI','23','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102400','unnamed',NULL,'EPSG','9807','Transverse Mercator','EPSG','8801','Latitude of natural origin',51.1666666666667,'EPSG','9102','EPSG','8802','Longitude of natural origin',-0.158333333333333,'EPSG','9102','EPSG','8805','Scale factor at natural origin',0.9999999,'EPSG','9201','EPSG','8806','False easting',78250.0,'EPSG','9001','EPSG','8807','False northing',-2800.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102400_USAGE','conversion','ESRI','102400','ESRI','2','EPSG','1024');
@@ -10583,7 +10617,9 @@ INSERT INTO "usage" VALUES('ESRI', 'PCRS_102587_USAGE','projected_crs','ESRI','1
 INSERT INTO "projected_crs" VALUES('ESRI','102588','NTF_Lambert_Zone_IV',NULL,'EPSG','4400','EPSG','4275','ESRI','102584',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102588_USAGE','projected_crs','ESRI','102588','EPSG','1327','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','54','USA - Contiguous US','USA - Contiguous US',20.0,50.0,-125.0,-65.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102589','Panhandle_Energy_Albers',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["Panhandle_Energy_Albers",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-86.0],PARAMETER["Standard_Parallel_1",31.0],PARAMETER["Standard_Parallel_2",41.0],PARAMETER["Latitude_Of_Origin",25.0],UNIT["Foot_US",0.3048006096012192]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102589','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',25.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-86.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',31.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',41.0,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9003','EPSG','8827','Northing at false origin',0.0,'EPSG','9003',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102589_USAGE','conversion','ESRI','102589','ESRI','54','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102589','Panhandle_Energy_Albers',NULL,'EPSG','4497','EPSG','4269','ESRI','102589',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102589_USAGE','projected_crs','ESRI','102589','ESRI','54','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102590','Tananarive_1925_Laborde_Grid',NULL,NULL,NULL,'EPSG','4297',NULL,NULL,'PROJCS["Tananarive_1925_Laborde_Grid",GEOGCS["GCS_Tananarive_1925",DATUM["D_Tananarive_1925",SPHEROID["International_1924",6378388.0,297.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Laborde_Oblique_Mercator"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",800000.0],PARAMETER["Scale_Factor",0.9995],PARAMETER["Azimuth",18.9],PARAMETER["Longitude_Of_Center",46.43722916666667],PARAMETER["Latitude_Of_Center",-18.9],UNIT["Meter",1.0]]',1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102590_USAGE','projected_crs','ESRI','102590','EPSG','3273','EPSG','1024');
@@ -10607,11 +10643,15 @@ INSERT INTO "projected_crs" VALUES('ESRI','102597','JGD_2011_UTM_Zone_55N',NULL,
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102597_USAGE','projected_crs','ESRI','102597','EPSG','3963','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102598','JGD_2011_UTM_Zone_56N',NULL,'EPSG','4400','EPSG','6668','EPSG','16056',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102598_USAGE','projected_crs','ESRI','102598','EPSG','1983','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102599','WGS_1984_California_Teale_Albers_FtUS',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_California_Teale_Albers_FtUS",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",-4000000.0],PARAMETER["Central_Meridian",-120.0],PARAMETER["Standard_Parallel_1",34.0],PARAMETER["Standard_Parallel_2",40.5],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Foot_US",0.3048006096012192]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102599','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',0.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-120.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',34.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',40.5,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9003','EPSG','8827','Northing at false origin',-4000000.0,'EPSG','9003',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102599_USAGE','conversion','ESRI','102599','EPSG','1375','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102599','WGS_1984_California_Teale_Albers_FtUS',NULL,'EPSG','4497','EPSG','4326','ESRI','102599',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102599_USAGE','projected_crs','ESRI','102599','EPSG','1375','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102600','NAD_1983_California_Teale_Albers_FtUS',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_California_Teale_Albers_FtUS",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",-4000000.0],PARAMETER["Central_Meridian",-120.0],PARAMETER["Standard_Parallel_1",34.0],PARAMETER["Standard_Parallel_2",40.5],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Foot_US",0.3048006096012192]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','102600','NAD_1983_California_Teale_Albers_FtUS',NULL,'EPSG','4497','EPSG','4269','ESRI','102599',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102600_USAGE','projected_crs','ESRI','102600','EPSG','1375','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102601','NAD_1983_Texas_Centric_Mapping_System_Albers',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_Texas_Centric_Mapping_System_Albers",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["Albers"],PARAMETER["False_Easting",1500000.0],PARAMETER["False_Northing",6000000.0],PARAMETER["Central_Meridian",-100.0],PARAMETER["Standard_Parallel_1",27.5],PARAMETER["Standard_Parallel_2",35.0],PARAMETER["Latitude_Of_Origin",18.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102601','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',18.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-100.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',27.5,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',35.0,'EPSG','9102','EPSG','8826','Easting at false origin',1500000.0,'EPSG','9001','EPSG','8827','Northing at false origin',6000000.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102601_USAGE','conversion','ESRI','102601','EPSG','1412','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102601','NAD_1983_Texas_Centric_Mapping_System_Albers',NULL,'EPSG','4400','EPSG','4269','ESRI','102601',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102601_USAGE','projected_crs','ESRI','102601','EPSG','1412','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102602','unnamed',NULL,'EPSG','9802','Lambert Conic Conformal (2SP)','EPSG','8821','Latitude of false origin',18.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-100.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',27.5,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',35.0,'EPSG','9102','EPSG','8826','Easting at false origin',1500000.0,'EPSG','9001','EPSG','8827','Northing at false origin',5000000.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102602_USAGE','conversion','ESRI','102602','EPSG','1412','EPSG','1024');
@@ -11180,9 +11220,11 @@ INSERT INTO "conversion" VALUES('ESRI','102758','unnamed',NULL,'EPSG','9807','Tr
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102758_USAGE','conversion','ESRI','102758','EPSG','2271','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102758','NAD_1983_StatePlane_Wyoming_West_FIPS_4904_Feet',NULL,'EPSG','4497','EPSG','4269','ESRI','102758',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102758_USAGE','projected_crs','ESRI','102758','EPSG','2271','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102759','WGS_1984_California_Teale_Albers_Ft_Intl',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["WGS_1984_California_Teale_Albers_Ft_Intl",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",-4000000.0],PARAMETER["Central_Meridian",-120.0],PARAMETER["Standard_Parallel_1",34.0],PARAMETER["Standard_Parallel_2",40.5],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Foot",0.3048]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102759','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',0.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-120.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',34.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',40.5,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9002','EPSG','8827','Northing at false origin',-4000000.0,'EPSG','9002',NULL,NULL,NULL,NULL,NULL,NULL,0);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102759_USAGE','conversion','ESRI','102759','EPSG','1375','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102759','WGS_1984_California_Teale_Albers_Ft_Intl',NULL,'EPSG','4495','EPSG','4326','ESRI','102759',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102759_USAGE','projected_crs','ESRI','102759','EPSG','1375','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102760','NAD_1983_California_Teale_Albers_Ft_Intl',NULL,NULL,NULL,'EPSG','4269',NULL,NULL,'PROJCS["NAD_1983_California_Teale_Albers_Ft_Intl",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["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",-4000000.0],PARAMETER["Central_Meridian",-120.0],PARAMETER["Standard_Parallel_1",34.0],PARAMETER["Standard_Parallel_2",40.5],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Foot",0.3048]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','102760','NAD_1983_California_Teale_Albers_Ft_Intl',NULL,'EPSG','4495','EPSG','4269','ESRI','102759',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102760_USAGE','projected_crs','ESRI','102760','EPSG','1375','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102761','unnamed',NULL,'EPSG','9802','Lambert Conic Conformal (2SP)','EPSG','8821','Latitude of false origin',17.83333333333333,'EPSG','9102','EPSG','8822','Longitude of false origin',-66.43333333333334,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',18.03333333333333,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',18.43333333333333,'EPSG','9102','EPSG','8826','Easting at false origin',656166.6666666665,'EPSG','9003','EPSG','8827','Northing at false origin',656166.6666666665,'EPSG','9003',NULL,NULL,NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102761_USAGE','conversion','ESRI','102761','EPSG','2251','EPSG','1024');
@@ -11961,15 +12003,21 @@ INSERT INTO "projected_crs" VALUES('ESRI','102959','CH1903+_LV95_Shifted',NULL,N
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102959_USAGE','projected_crs','ESRI','102959','EPSG','1286','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102960','Hungarian_1972_EOV_Shifted',NULL,NULL,NULL,'EPSG','4237',NULL,NULL,'PROJCS["Hungarian_1972_EOV_Shifted",GEOGCS["GCS_Hungarian_1972",DATUM["D_Hungarian_1972",SPHEROID["GRS_1967",6378160.0,298.247167427]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Hotine_Oblique_Mercator_Azimuth_Center_Swiss"],PARAMETER["False_Easting",650000.0],PARAMETER["False_Northing",200000.0],PARAMETER["Scale_Factor",0.99993],PARAMETER["Azimuth",90.0],PARAMETER["Longitude_Of_Center",19.04857177777778],PARAMETER["Latitude_Of_Center",47.14439372222],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102960_USAGE','projected_crs','ESRI','102960','EPSG','1119','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102962','NAD_1983_2011_California_Teale_Albers',NULL,NULL,NULL,'EPSG','6318',NULL,NULL,'PROJCS["NAD_1983_2011_California_Teale_Albers",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",-4000000.0],PARAMETER["Central_Meridian",-120.0],PARAMETER["Standard_Parallel_1",34.0],PARAMETER["Standard_Parallel_2",40.5],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102962','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',0.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-120.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',34.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',40.5,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',-4000000.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102962_USAGE','conversion','ESRI','102962','EPSG','1375','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102962','NAD_1983_2011_California_Teale_Albers',NULL,'EPSG','4400','EPSG','6318','ESRI','102962',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102962_USAGE','projected_crs','ESRI','102962','EPSG','1375','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102963','NAD_1983_2011_Mississippi_TM',NULL,'EPSG','4400','EPSG','6318','ESRI','102469',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102963_USAGE','projected_crs','ESRI','102963','EPSG','1393','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102965','NAD_1983_2011_Contiguous_USA_Albers',NULL,NULL,NULL,'EPSG','6318',NULL,NULL,'PROJCS["NAD_1983_2011_Contiguous_USA_Albers",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-96.0],PARAMETER["Standard_Parallel_1",29.5],PARAMETER["Standard_Parallel_2",45.5],PARAMETER["Latitude_Of_Origin",23.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102965','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',23.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-96.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',29.5,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',45.5,'EPSG','9102','EPSG','8826','Easting at false origin',0.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102965_USAGE','conversion','ESRI','102965','EPSG','1323','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102965','NAD_1983_2011_Contiguous_USA_Albers',NULL,'EPSG','4400','EPSG','6318','ESRI','102965',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102965_USAGE','projected_crs','ESRI','102965','EPSG','1323','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102966','NAD_1983_2011_Alaska_Albers',NULL,NULL,NULL,'EPSG','6318',NULL,NULL,'PROJCS["NAD_1983_2011_Alaska_Albers",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-154.0],PARAMETER["Standard_Parallel_1",55.0],PARAMETER["Standard_Parallel_2",65.0],PARAMETER["Latitude_Of_Origin",50.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "projected_crs" VALUES('ESRI','102966','NAD_1983_2011_Alaska_Albers',NULL,'EPSG','4400','EPSG','6318','ESRI','102006',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102966_USAGE','projected_crs','ESRI','102966','EPSG','1330','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102967','NAD_1983_2011_Florida_GDL_Albers',NULL,NULL,NULL,'EPSG','6318',NULL,NULL,'PROJCS["NAD_1983_2011_Florida_GDL_Albers",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",400000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-84.0],PARAMETER["Standard_Parallel_1",24.0],PARAMETER["Standard_Parallel_2",31.5],PARAMETER["Latitude_Of_Origin",24.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102967','unnamed',NULL,'EPSG','9822','Albers Equal Area','EPSG','8821','Latitude of false origin',24.0,'EPSG','9102','EPSG','8822','Longitude of false origin',-84.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',24.0,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',31.5,'EPSG','9102','EPSG','8826','Easting at false origin',400000.0,'EPSG','9001','EPSG','8827','Northing at false origin',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102967_USAGE','conversion','ESRI','102967','EPSG','1379','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102967','NAD_1983_2011_Florida_GDL_Albers',NULL,'EPSG','4400','EPSG','6318','ESRI','102967',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102967_USAGE','projected_crs','ESRI','102967','EPSG','1379','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102968','NAD_1983_2011_Michigan_GeoRef_Meters',NULL,'EPSG','4400','EPSG','6318','ESRI','102123',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102968_USAGE','projected_crs','ESRI','102968','EPSG','1391','EPSG','1024');
@@ -11977,7 +12025,7 @@ INSERT INTO "projected_crs" VALUES('ESRI','102969','NAD_1983_2011_Oregon_Statewi
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102969_USAGE','projected_crs','ESRI','102969','EPSG','1406','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102970','NAD_1983_2011_Oregon_Statewide_Lambert_Ft_Intl',NULL,'EPSG','4495','EPSG','6318','ESRI','102381',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102970_USAGE','projected_crs','ESRI','102970','EPSG','1406','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','102971','NAD_1983_2011_Texas_Centric_Mapping_System_Albers',NULL,NULL,NULL,'EPSG','6318',NULL,NULL,'PROJCS["NAD_1983_2011_Texas_Centric_Mapping_System_Albers",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",1500000.0],PARAMETER["False_Northing",6000000.0],PARAMETER["Central_Meridian",-100.0],PARAMETER["Standard_Parallel_1",27.5],PARAMETER["Standard_Parallel_2",35.0],PARAMETER["Latitude_Of_Origin",18.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "projected_crs" VALUES('ESRI','102971','NAD_1983_2011_Texas_Centric_Mapping_System_Albers',NULL,'EPSG','4400','EPSG','6318','ESRI','102601',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102971_USAGE','projected_crs','ESRI','102971','EPSG','1412','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','102972','NAD_1983_2011_Texas_Centric_Mapping_System_Lambert',NULL,'EPSG','4400','EPSG','6318','ESRI','102602',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102972_USAGE','projected_crs','ESRI','102972','EPSG','1412','EPSG','1024');
-- 
cgit v1.2.3


From 5f2a9a574b2793393e326c67c10c3cbb79ec40ea Mon Sep 17 00:00:00 2001
From: Nyall Dawson <nyall.dawson@gmail.com>
Date: Tue, 23 Nov 2021 08:48:44 +1000
Subject: Map ESRI IGAC_Plano_Cartesiano method to EPSG:1052 during ESRI
 projection engine db ingestion

---
 data/sql/esri.sql | 128 ++++++++++++++++++++++++++++++++++++++++--------------
 1 file changed, 96 insertions(+), 32 deletions(-)

(limited to 'data/sql/esri.sql')

diff --git a/data/sql/esri.sql b/data/sql/esri.sql
index de949619..7952f818 100644
--- a/data/sql/esri.sql
+++ b/data/sql/esri.sql
@@ -11245,100 +11245,164 @@ INSERT INTO "usage" VALUES('ESRI', 'PCRS_102765_USAGE','projected_crs','ESRI','1
 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 "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 "projected_crs" VALUES('ESRI','102767','MAGNA_Leticia_Amazonas_1994',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Leticia_Amazonas_1994",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",25978.217],PARAMETER["False_Northing",27501.365],PARAMETER["Longitude_Of_Center",-69.94281105833333],PARAMETER["Latitude_Of_Center",-4.197684047222222],PARAMETER["Height",89.7],UNIT["Meter",1.0]]',1);
+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);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102767_USAGE','conversion','ESRI','102767','ESRI','56','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102767','MAGNA_Leticia_Amazonas_1994',NULL,'EPSG','4400','EPSG','4686','ESRI','102767',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102767_USAGE','projected_crs','ESRI','102767','ESRI','56','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','57','Colombia - Medellin - Antioquia','Colombia - Medellin - Antioquia',5.716666666666667,6.733333333333333,-76.06666666666666,-75.05,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102768','MAGNA_Medellin_Antioquia_2010',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Medellin_Antioquia_2010",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",835378.647],PARAMETER["False_Northing",1180816.875],PARAMETER["Longitude_Of_Center",-75.56488694444444],PARAMETER["Latitude_Of_Center",6.229208888888889],PARAMETER["Height",1510.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102768','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',6.229208888888889,'EPSG','9102','EPSG','8802','Longitude of natural origin',-75.56488694444444,'EPSG','9102','EPSG','8806','False easting',835378.647,'EPSG','9001','EPSG','8807','False northing',1180816.875,'EPSG','9001','EPSG','1039','Projection plane origin height',1510.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102768_USAGE','conversion','ESRI','102768','ESRI','57','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102768','MAGNA_Medellin_Antioquia_2010',NULL,'EPSG','4400','EPSG','4686','ESRI','102768',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102768_USAGE','projected_crs','ESRI','102768','ESRI','57','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','58','Colombia - Arauca - Arauca','Colombia - Arauca - Arauca',6.583333333333333,7.6,-71.26666666666667,-70.25,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102769','MAGNA_Arauca_2007',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Arauca_2007",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1035263.443],PARAMETER["False_Northing",1275526.621],PARAMETER["Longitude_Of_Center",-70.75830965555555],PARAMETER["Latitude_Of_Center",7.087606391666666],PARAMETER["Height",100.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102769','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',7.087606391666666,'EPSG','9102','EPSG','8802','Longitude of natural origin',-70.75830965555555,'EPSG','9102','EPSG','8806','False easting',1035263.443,'EPSG','9001','EPSG','8807','False northing',1275526.621,'EPSG','9001','EPSG','1039','Projection plane origin height',100.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102769_USAGE','conversion','ESRI','102769','ESRI','58','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102769','MAGNA_Arauca_2007',NULL,'EPSG','4400','EPSG','4686','ESRI','102769',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102769_USAGE','projected_crs','ESRI','102769','ESRI','58','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','59','Colombia - Barranquilla - Atlantico','Colombia - Barranquilla - Atlantico',10.41666666666667,11.43333333333333,-75.35,-74.33333333333333,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102770','MAGNA_Barranquilla_Atlantico_1997',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Barranquilla_Atlantico_1997",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",917264.406],PARAMETER["False_Northing",1699839.935],PARAMETER["Longitude_Of_Center",-74.83433133333332],PARAMETER["Latitude_Of_Center",10.92318308333333],PARAMETER["Height",100.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102770','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',10.92318308333333,'EPSG','9102','EPSG','8802','Longitude of natural origin',-74.83433133333332,'EPSG','9102','EPSG','8806','False easting',917264.406,'EPSG','9001','EPSG','8807','False northing',1699839.935,'EPSG','9001','EPSG','1039','Projection plane origin height',100.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102770_USAGE','conversion','ESRI','102770','ESRI','59','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102770','MAGNA_Barranquilla_Atlantico_1997',NULL,'EPSG','4400','EPSG','4686','ESRI','102770',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102770_USAGE','projected_crs','ESRI','102770','ESRI','59','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','60','Colombia - Bogota D.C. - Bogota D.C.','Colombia - Bogota D.C. - Bogota D.C.',4.166666666666667,5.183333333333334,-74.65,-73.63333333333334,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102771','MAGNA_Bogota_DC_2005',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Bogota_DC_2005",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",92334.879],PARAMETER["False_Northing",109320.965],PARAMETER["Longitude_Of_Center",-74.14659166666668],PARAMETER["Latitude_Of_Center",4.680486111111112],PARAMETER["Height",2550.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102771','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',4.680486111111112,'EPSG','9102','EPSG','8802','Longitude of natural origin',-74.14659166666668,'EPSG','9102','EPSG','8806','False easting',92334.879,'EPSG','9001','EPSG','8807','False northing',109320.965,'EPSG','9001','EPSG','1039','Projection plane origin height',2550.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102771_USAGE','conversion','ESRI','102771','ESRI','60','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102771','MAGNA_Bogota_DC_2005',NULL,'EPSG','4400','EPSG','4686','ESRI','102771',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102771_USAGE','projected_crs','ESRI','102771','ESRI','60','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','61','Colombia - Cartagena_Bolivar','Colombia - Cartagena_Bolivar',9.883333333333333,10.9,-76.01666666666667,-75.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102772','MAGNA_Cartagena_Bolivar_2005',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Cartagena_Bolivar_2005",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",842981.41],PARAMETER["False_Northing",1641887.09],PARAMETER["Longitude_Of_Center",-75.51120694444444],PARAMETER["Latitude_Of_Center",10.3970475],PARAMETER["Height",0.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102772','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',10.3970475,'EPSG','9102','EPSG','8802','Longitude of natural origin',-75.51120694444444,'EPSG','9102','EPSG','8806','False easting',842981.41,'EPSG','9001','EPSG','8807','False northing',1641887.09,'EPSG','9001','EPSG','1039','Projection plane origin height',0.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102772_USAGE','conversion','ESRI','102772','ESRI','61','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102772','MAGNA_Cartagena_Bolivar_2005',NULL,'EPSG','4400','EPSG','4686','ESRI','102772',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102772_USAGE','projected_crs','ESRI','102772','ESRI','61','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','62','Colombia - Tunja - Boyaca','Colombia - Tunja - Boyaca',5.033333333333333,6.05,-73.86666666666666,-72.85,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102773','MAGNA_Tunja_Boyaca_1997',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Tunja_Boyaca_1997",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1080514.91],PARAMETER["False_Northing",1103772.028],PARAMETER["Longitude_Of_Center",-73.3519389],PARAMETER["Latitude_Of_Center",5.534194738888889],PARAMETER["Height",2800.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102773','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',5.534194738888889,'EPSG','9102','EPSG','8802','Longitude of natural origin',-73.3519389,'EPSG','9102','EPSG','8806','False easting',1080514.91,'EPSG','9001','EPSG','8807','False northing',1103772.028,'EPSG','9001','EPSG','1039','Projection plane origin height',2800.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102773_USAGE','conversion','ESRI','102773','ESRI','62','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102773','MAGNA_Tunja_Boyaca_1997',NULL,'EPSG','4400','EPSG','4686','ESRI','102773',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102773_USAGE','projected_crs','ESRI','102773','ESRI','62','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','63','Colombia - Manizales - Caldas','Colombia - Manizales - Caldas',4.566666666666666,5.583333333333333,-76.01666666666667,-75.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102774','MAGNA_Manizales_Caldas_2011',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Manizales_Caldas_2011",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1173727.04],PARAMETER["False_Northing",1052391.13],PARAMETER["Longitude_Of_Center",-75.51109472222223],PARAMETER["Latitude_Of_Center",5.068153888888888],PARAMETER["Height",2100.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102774','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',5.068153888888888,'EPSG','9102','EPSG','8802','Longitude of natural origin',-75.51109472222223,'EPSG','9102','EPSG','8806','False easting',1173727.04,'EPSG','9001','EPSG','8807','False northing',1052391.13,'EPSG','9001','EPSG','1039','Projection plane origin height',2100.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102774_USAGE','conversion','ESRI','102774','ESRI','63','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102774','MAGNA_Manizales_Caldas_2011',NULL,'EPSG','4400','EPSG','4686','ESRI','102774',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102774_USAGE','projected_crs','ESRI','102774','ESRI','63','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','64','Colombia - Florencia - Caqueta','Colombia - Florencia - Caqueta',1.116666666666667,2.133333333333333,-76.13333333333334,-75.11666666666666,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102775','MAGNA_Florencia_Caqueta_2007',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Florencia_Caqueta_2007",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1162300.348],PARAMETER["False_Northing",671068.716],PARAMETER["Longitude_Of_Center",-75.61911760277778],PARAMETER["Latitude_Of_Center",1.621012294444445],PARAMETER["Height",300.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102775','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',1.621012294444445,'EPSG','9102','EPSG','8802','Longitude of natural origin',-75.61911760277778,'EPSG','9102','EPSG','8806','False easting',1162300.348,'EPSG','9001','EPSG','8807','False northing',671068.716,'EPSG','9001','EPSG','1039','Projection plane origin height',300.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102775_USAGE','conversion','ESRI','102775','ESRI','64','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102775','MAGNA_Florencia_Caqueta_2007',NULL,'EPSG','4400','EPSG','4686','ESRI','102775',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102775_USAGE','projected_crs','ESRI','102775','ESRI','64','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','65','Colombia - Yopal - Casanare','Colombia - Yopal - Casanare',4.85,5.866666666666667,-72.93333333333334,-71.91666666666667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102776','MAGNA_Yopal_Casanare_2006',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Yopal_Casanare_2006",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",851184.177],PARAMETER["False_Northing",1083954.137],PARAMETER["Longitude_Of_Center",-72.42004027777779],PARAMETER["Latitude_Of_Center",5.353927222222222],PARAMETER["Height",300.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102776','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',5.353927222222222,'EPSG','9102','EPSG','8802','Longitude of natural origin',-72.42004027777779,'EPSG','9102','EPSG','8806','False easting',851184.177,'EPSG','9001','EPSG','8807','False northing',1083954.137,'EPSG','9001','EPSG','1039','Projection plane origin height',300.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102776_USAGE','conversion','ESRI','102776','ESRI','65','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102776','MAGNA_Yopal_Casanare_2006',NULL,'EPSG','4400','EPSG','4686','ESRI','102776',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102776_USAGE','projected_crs','ESRI','102776','ESRI','65','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','66','Colombia - Popayan - Cauca','Colombia - Popayan - Cauca',2.95,2.966666666666667,-77.11666666666666,-76.1,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102777','MAGNA_Popayan_Cauca_2006',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Popayan_Cauca_2006",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1052430.525],PARAMETER["False_Northing",763366.548],PARAMETER["Longitude_Of_Center",-76.6060916361111],PARAMETER["Latitude_Of_Center",2.456159883333334],PARAMETER["Height",1740.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102777','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',2.456159883333334,'EPSG','9102','EPSG','8802','Longitude of natural origin',-76.6060916361111,'EPSG','9102','EPSG','8806','False easting',1052430.525,'EPSG','9001','EPSG','8807','False northing',763366.548,'EPSG','9001','EPSG','1039','Projection plane origin height',1740.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102777_USAGE','conversion','ESRI','102777','ESRI','66','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102777','MAGNA_Popayan_Cauca_2006',NULL,'EPSG','4400','EPSG','4686','ESRI','102777',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102777_USAGE','projected_crs','ESRI','102777','ESRI','66','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','67','Colombia - Valledupar - Cesar','Colombia - Valledupar - Cesar',9.933333333333334,10.95,-73.58333333333333,-73.56666666666666,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102778','MAGNA_Valledupar_Cesar_2011',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Valledupar_Cesar_2011",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1090979.66],PARAMETER["False_Northing",1647208.93],PARAMETER["Longitude_Of_Center",-73.2465713888889],PARAMETER["Latitude_Of_Center",10.44726111111111],PARAMETER["Height",200.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102778','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',10.44726111111111,'EPSG','9102','EPSG','8802','Longitude of natural origin',-73.2465713888889,'EPSG','9102','EPSG','8806','False easting',1090979.66,'EPSG','9001','EPSG','8807','False northing',1647208.93,'EPSG','9001','EPSG','1039','Projection plane origin height',200.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102778_USAGE','conversion','ESRI','102778','ESRI','67','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102778','MAGNA_Valledupar_Cesar_2011',NULL,'EPSG','4400','EPSG','4686','ESRI','102778',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102778_USAGE','projected_crs','ESRI','102778','ESRI','67','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','68','Colombia - Quibdo - Choco','Colombia - Quibdo - Choco',5.183333333333334,6.2,-77.16666666666667,-76.15,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102779','MAGNA_Quibdo_Choco_2011',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Quibdo_Choco_2011",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1047273.617],PARAMETER["False_Northing",1121443.09],PARAMETER["Longitude_Of_Center",-76.65075385833335],PARAMETER["Latitude_Of_Center",5.694247661111111],PARAMETER["Height",44.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102779','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',5.694247661111111,'EPSG','9102','EPSG','8802','Longitude of natural origin',-76.65075385833335,'EPSG','9102','EPSG','8806','False easting',1047273.617,'EPSG','9001','EPSG','8807','False northing',1121443.09,'EPSG','9001','EPSG','1039','Projection plane origin height',44.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102779_USAGE','conversion','ESRI','102779','ESRI','68','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102779','MAGNA_Quibdo_Choco_2011',NULL,'EPSG','4400','EPSG','4686','ESRI','102779',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102779_USAGE','projected_crs','ESRI','102779','ESRI','68','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','69','Colombia - Monteria - Cordoba','Colombia - Monteria - Cordoba',8.266666666666667,9.283333333333333,-76.38333333333334,-75.36666666666666,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102780','MAGNA_Monteria_Cordoba_2006',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Monteria_Cordoba_2006",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1131814.934],PARAMETER["False_Northing",1462131.119],PARAMETER["Longitude_Of_Center",-75.87955333055555],PARAMETER["Latitude_Of_Center",8.773085755555556],PARAMETER["Height",15.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102780','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',8.773085755555556,'EPSG','9102','EPSG','8802','Longitude of natural origin',-75.87955333055555,'EPSG','9102','EPSG','8806','False easting',1131814.934,'EPSG','9001','EPSG','8807','False northing',1462131.119,'EPSG','9001','EPSG','1039','Projection plane origin height',15.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102780_USAGE','conversion','ESRI','102780','ESRI','69','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102780','MAGNA_Monteria_Cordoba_2006',NULL,'EPSG','4400','EPSG','4686','ESRI','102780',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102780_USAGE','projected_crs','ESRI','102780','ESRI','69','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','70','Colombia - Inirida - Guainia','Colombia - Inirida - Guainia',3.333333333333333,4.35,-68.41666666666667,-67.4,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102781','MAGNA_Inirida_Guainia_2008',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Inirida_Guainia_2008",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1019177.687],PARAMETER["False_Northing",491791.326],PARAMETER["Longitude_Of_Center",-67.90523208888889],PARAMETER["Latitude_Of_Center",3.845438183333334],PARAMETER["Height",96.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102781','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',3.845438183333334,'EPSG','9102','EPSG','8802','Longitude of natural origin',-67.90523208888889,'EPSG','9102','EPSG','8806','False easting',1019177.687,'EPSG','9001','EPSG','8807','False northing',491791.326,'EPSG','9001','EPSG','1039','Projection plane origin height',96.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102781_USAGE','conversion','ESRI','102781','ESRI','70','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102781','MAGNA_Inirida_Guainia_2008',NULL,'EPSG','4400','EPSG','4686','ESRI','102781',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102781_USAGE','projected_crs','ESRI','102781','ESRI','70','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','71','Colombia - San Jose del Guaviare - Guaviare','Colombia - San Jose del Guaviare - Guaviare',2.05,3.066666666666667,-73.15,-72.13333333333334,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102782','MAGNA_San_Jose_del_Guaviare_2011',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_San_Jose_del_Guaviare_2011",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1159876.62],PARAMETER["False_Northing",775380.342],PARAMETER["Longitude_Of_Center",-72.640033325],PARAMETER["Latitude_Of_Center",2.564078941666666],PARAMETER["Height",185.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102782','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',2.564078941666666,'EPSG','9102','EPSG','8802','Longitude of natural origin',-72.640033325,'EPSG','9102','EPSG','8806','False easting',1159876.62,'EPSG','9001','EPSG','8807','False northing',775380.342,'EPSG','9001','EPSG','1039','Projection plane origin height',185.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102782_USAGE','conversion','ESRI','102782','ESRI','71','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102782','MAGNA_San_Jose_del_Guaviare_2011',NULL,'EPSG','4400','EPSG','4686','ESRI','102782',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102782_USAGE','projected_crs','ESRI','102782','ESRI','71','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','72','Colombia - Neiva - Huila','Colombia - Neiva - Huila',2.433333333333334,3.45,-75.8,-74.78333333333333,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102783','MAGNA_Neiva_Huila_2006',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Neiva_Huila_2006",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",864476.923],PARAMETER["False_Northing",817199.827],PARAMETER["Longitude_Of_Center",-75.29643672222223],PARAMETER["Latitude_Of_Center",2.942415055555556],PARAMETER["Height",430.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102783','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',2.942415055555556,'EPSG','9102','EPSG','8802','Longitude of natural origin',-75.29643672222223,'EPSG','9102','EPSG','8806','False easting',864476.923,'EPSG','9001','EPSG','8807','False northing',817199.827,'EPSG','9001','EPSG','1039','Projection plane origin height',430.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102783_USAGE','conversion','ESRI','102783','ESRI','72','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102783','MAGNA_Neiva_Huila_2006',NULL,'EPSG','4400','EPSG','4686','ESRI','102783',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102783_USAGE','projected_crs','ESRI','102783','ESRI','72','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','73','Colombia - Riohacha - La Guajira','Colombia - Riohacha - La Guajira',11.03333333333333,12.05,-73.41666666666667,-72.4,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102784','MAGNA_Riohacha_La_Guajira_2006',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Riohacha_La_Guajira_2006",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1128154.73],PARAMETER["False_Northing",1767887.914],PARAMETER["Longitude_Of_Center",-72.90276886944444],PARAMETER["Latitude_Of_Center",11.53691332777778],PARAMETER["Height",6.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102784','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',11.53691332777778,'EPSG','9102','EPSG','8802','Longitude of natural origin',-72.90276886944444,'EPSG','9102','EPSG','8806','False easting',1128154.73,'EPSG','9001','EPSG','8807','False northing',1767887.914,'EPSG','9001','EPSG','1039','Projection plane origin height',6.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102784_USAGE','conversion','ESRI','102784','ESRI','73','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102784','MAGNA_Riohacha_La_Guajira_2006',NULL,'EPSG','4400','EPSG','4686','ESRI','102784',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102784_USAGE','projected_crs','ESRI','102784','ESRI','73','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','74','Colombia - Santa Marta - Magdalena','Colombia - Santa Marta - Magdalena',10.71666666666667,11.73333333333333,-74.73333333333333,-73.71666666666667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102785','MAGNA_Santa_Marta_Magdalena_2007',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Santa_Marta_Magdalena_2007",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",983892.409],PARAMETER["False_Northing",1732533.518],PARAMETER["Longitude_Of_Center",-74.22500527777778],PARAMETER["Latitude_Of_Center",11.21964305555556],PARAMETER["Height",29.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102785','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',11.21964305555556,'EPSG','9102','EPSG','8802','Longitude of natural origin',-74.22500527777778,'EPSG','9102','EPSG','8806','False easting',983892.409,'EPSG','9001','EPSG','8807','False northing',1732533.518,'EPSG','9001','EPSG','1039','Projection plane origin height',29.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102785_USAGE','conversion','ESRI','102785','ESRI','74','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102785','MAGNA_Santa_Marta_Magdalena_2007',NULL,'EPSG','4400','EPSG','4686','ESRI','102785',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102785_USAGE','projected_crs','ESRI','102785','ESRI','74','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','75','Colombia - Villavicencio - Meta','Colombia - Villavicencio - Meta',3.65,4.666666666666667,-74.13333333333334,-73.11666666666666,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102786','MAGNA_Villavicencio_Meta_2011',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Villavicencio_Meta_2011",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1050678.757],PARAMETER["False_Northing",950952.124],PARAMETER["Longitude_Of_Center",-73.62448598611111],PARAMETER["Latitude_Of_Center",4.1553751],PARAMETER["Height",427.19],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102786','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',4.1553751,'EPSG','9102','EPSG','8802','Longitude of natural origin',-73.62448598611111,'EPSG','9102','EPSG','8806','False easting',1050678.757,'EPSG','9001','EPSG','8807','False northing',950952.124,'EPSG','9001','EPSG','1039','Projection plane origin height',427.19,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102786_USAGE','conversion','ESRI','102786','ESRI','75','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102786','MAGNA_Villavicencio_Meta_2011',NULL,'EPSG','4400','EPSG','4686','ESRI','102786',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102786_USAGE','projected_crs','ESRI','102786','ESRI','75','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','76','Colombia - Pasto - Narino','Colombia - Pasto - Narino',0.7,1.716666666666667,-77.76666666666667,-76.75,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102787','MAGNA_Pasto_Narino_2008',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Pasto_Narino_2008",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",980469.695],PARAMETER["False_Northing",624555.332],PARAMETER["Longitude_Of_Center",-77.25312563333334],PARAMETER["Latitude_Of_Center",1.200989513888889],PARAMETER["Height",2530.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102787','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',1.200989513888889,'EPSG','9102','EPSG','8802','Longitude of natural origin',-77.25312563333334,'EPSG','9102','EPSG','8806','False easting',980469.695,'EPSG','9001','EPSG','8807','False northing',624555.332,'EPSG','9001','EPSG','1039','Projection plane origin height',2530.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102787_USAGE','conversion','ESRI','102787','ESRI','76','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102787','MAGNA_Pasto_Narino_2008',NULL,'EPSG','4400','EPSG','4686','ESRI','102787',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102787_USAGE','projected_crs','ESRI','102787','ESRI','76','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','77','Colombia - Cucuta - Norte de Santander','Colombia - Cucuta - Norte de Santander',7.383333333333334,8.4,-73.01666666666667,-72.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102788','MAGNA_Cucuta_Norte_de_Santander_2011',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Cucuta_Norte_de_Santander_2011",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",842805.406],PARAMETER["False_Northing",1364404.57],PARAMETER["Longitude_Of_Center",-72.50287095],PARAMETER["Latitude_Of_Center",7.888936736111111],PARAMETER["Height",308.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102788','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',7.888936736111111,'EPSG','9102','EPSG','8802','Longitude of natural origin',-72.50287095,'EPSG','9102','EPSG','8806','False easting',842805.406,'EPSG','9001','EPSG','8807','False northing',1364404.57,'EPSG','9001','EPSG','1039','Projection plane origin height',308.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102788_USAGE','conversion','ESRI','102788','ESRI','77','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102788','MAGNA_Cucuta_Norte_de_Santander_2011',NULL,'EPSG','4400','EPSG','4686','ESRI','102788',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102788_USAGE','projected_crs','ESRI','102788','ESRI','77','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','78','Colombia - Mocoa - Putumayo','Colombia - Mocoa - Putumayo',0.6333333333333333,1.65,-77.16666666666667,-76.15,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102789','MAGNA_Mocoa_Putumayo_2011',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Mocoa_Putumayo_2011",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1047467.388],PARAMETER["False_Northing",617828.474],PARAMETER["Longitude_Of_Center",-76.65102121944444],PARAMETER["Latitude_Of_Center",1.140023358333333],PARAMETER["Height",655.2],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102789','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',1.140023358333333,'EPSG','9102','EPSG','8802','Longitude of natural origin',-76.65102121944444,'EPSG','9102','EPSG','8806','False easting',1047467.388,'EPSG','9001','EPSG','8807','False northing',617828.474,'EPSG','9001','EPSG','1039','Projection plane origin height',655.2,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102789_USAGE','conversion','ESRI','102789','ESRI','78','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102789','MAGNA_Mocoa_Putumayo_2011',NULL,'EPSG','4400','EPSG','4686','ESRI','102789',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102789_USAGE','projected_crs','ESRI','102789','ESRI','78','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','79','Colombia - Armenia - Quindio','Colombia - Armenia - Quindio',4.016666666666667,5.033333333333333,-76.18333333333334,-75.16666666666667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102790','MAGNA_Armenia_Quindio_2006',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Armenia_Quindio_2006",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1155824.666],PARAMETER["False_Northing",993087.465],PARAMETER["Longitude_Of_Center",-75.67348916666667],PARAMETER["Latitude_Of_Center",4.532325],PARAMETER["Height",1470.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102790','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',4.532325,'EPSG','9102','EPSG','8802','Longitude of natural origin',-75.67348916666667,'EPSG','9102','EPSG','8806','False easting',1155824.666,'EPSG','9001','EPSG','8807','False northing',993087.465,'EPSG','9001','EPSG','1039','Projection plane origin height',1470.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102790_USAGE','conversion','ESRI','102790','ESRI','79','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102790','MAGNA_Armenia_Quindio_2006',NULL,'EPSG','4400','EPSG','4686','ESRI','102790',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102790_USAGE','projected_crs','ESRI','102790','ESRI','79','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','80','Colombia - Pereira - Risaralda','Colombia - Pereira - Risaralda',4.3,5.316666666666666,-76.2,-75.18333333333334,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102791','MAGNA_Pereira_Risaralda_2007',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Pereira_Risaralda_2007",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1153492.012],PARAMETER["False_Northing",1024195.255],PARAMETER["Longitude_Of_Center",-75.69395138888889],PARAMETER["Latitude_Of_Center",4.813593611111111],PARAMETER["Height",1500.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102791','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',4.813593611111111,'EPSG','9102','EPSG','8802','Longitude of natural origin',-75.69395138888889,'EPSG','9102','EPSG','8806','False easting',1153492.012,'EPSG','9001','EPSG','8807','False northing',1024195.255,'EPSG','9001','EPSG','1039','Projection plane origin height',1500.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102791_USAGE','conversion','ESRI','102791','ESRI','80','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102791','MAGNA_Pereira_Risaralda_2007',NULL,'EPSG','4400','EPSG','4686','ESRI','102791',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102791_USAGE','projected_crs','ESRI','102791','ESRI','80','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','81','Colombia - San_Andres - San_Andres','Colombia - San_Andres - San_Andres',12.01666666666667,13.03333333333333,-82.23333333333333,-81.21666666666667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102792','MAGNA_San_Andres_2007',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_San_Andres_2007",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",820439.298],PARAMETER["False_Northing",1877357.828],PARAMETER["Longitude_Of_Center",-81.72937595],PARAMETER["Latitude_Of_Center",12.523794325],PARAMETER["Height",6.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102792','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',12.523794325,'EPSG','9102','EPSG','8802','Longitude of natural origin',-81.72937595,'EPSG','9102','EPSG','8806','False easting',820439.298,'EPSG','9001','EPSG','8807','False northing',1877357.828,'EPSG','9001','EPSG','1039','Projection plane origin height',6.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102792_USAGE','conversion','ESRI','102792','ESRI','81','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102792','MAGNA_San_Andres_2007',NULL,'EPSG','4400','EPSG','4686','ESRI','102792',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102792_USAGE','projected_crs','ESRI','102792','ESRI','81','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','82','Colombia - Bucaramanga - Santander','Colombia - Bucaramanga - Santander',6.566666666666666,7.583333333333333,-73.7,-72.68333333333334,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102793','MAGNA_Bucaramanga_Santander_2008',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Bucaramanga_Santander_2008",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1097241.305],PARAMETER["False_Northing",1274642.278],PARAMETER["Longitude_Of_Center",-73.19734322222223],PARAMETER["Latitude_Of_Center",7.078887141666667],PARAMETER["Height",931.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102793','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',7.078887141666667,'EPSG','9102','EPSG','8802','Longitude of natural origin',-73.19734322222223,'EPSG','9102','EPSG','8806','False easting',1097241.305,'EPSG','9001','EPSG','8807','False northing',1274642.278,'EPSG','9001','EPSG','1039','Projection plane origin height',931.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102793_USAGE','conversion','ESRI','102793','ESRI','82','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102793','MAGNA_Bucaramanga_Santander_2008',NULL,'EPSG','4400','EPSG','4686','ESRI','102793',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102793_USAGE','projected_crs','ESRI','102793','ESRI','82','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','83','Colombia - Sucre - Sucre','Colombia - Sucre - Sucre',8.3,9.316666666666666,-75.23333333333333,-74.21666666666667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102794','MAGNA_Sucre_2006',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Sucre_2006",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",929043.607],PARAMETER["False_Northing",1466125.658],PARAMETER["Longitude_Of_Center",-74.722466825],PARAMETER["Latitude_Of_Center",8.810550366666668],PARAMETER["Height",20.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102794','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',8.810550366666668,'EPSG','9102','EPSG','8802','Longitude of natural origin',-74.722466825,'EPSG','9102','EPSG','8806','False easting',929043.607,'EPSG','9001','EPSG','8807','False northing',1466125.658,'EPSG','9001','EPSG','1039','Projection plane origin height',20.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102794_USAGE','conversion','ESRI','102794','ESRI','83','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102794','MAGNA_Sucre_2006',NULL,'EPSG','4400','EPSG','4686','ESRI','102794',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102794_USAGE','projected_crs','ESRI','102794','ESRI','83','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','84','Colombia - Ibague - Tolima','Colombia - Ibague - Tolima',3.916666666666667,4.933333333333334,-75.68333333333334,-74.66666666666667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102795','MAGNA_Ibague_Tolima_2007',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Ibague_Tolima_2007",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",877634.33],PARAMETER["False_Northing",980541.348],PARAMETER["Longitude_Of_Center",-75.17992593333334],PARAMETER["Latitude_Of_Center",4.419412827777778],PARAMETER["Height",1100.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102795','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',4.419412827777778,'EPSG','9102','EPSG','8802','Longitude of natural origin',-75.17992593333334,'EPSG','9102','EPSG','8806','False easting',877634.33,'EPSG','9001','EPSG','8807','False northing',980541.348,'EPSG','9001','EPSG','1039','Projection plane origin height',1100.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102795_USAGE','conversion','ESRI','102795','ESRI','84','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102795','MAGNA_Ibague_Tolima_2007',NULL,'EPSG','4400','EPSG','4686','ESRI','102795',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102795_USAGE','projected_crs','ESRI','102795','ESRI','84','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','85','Colombia - Cali - Valle del Cauca','Colombia - Cali - Valle del Cauca',2.933333333333334,3.95,-77.03333333333333,-76.01666666666667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102796','MAGNA_Cali_Valle_del_Cauca_2009',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Cali_Valle_del_Cauca_2009",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1061900.18],PARAMETER["False_Northing",872364.63],PARAMETER["Longitude_Of_Center",-76.5205625],PARAMETER["Latitude_Of_Center",3.441883333333334],PARAMETER["Height",1000.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102796','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',3.441883333333334,'EPSG','9102','EPSG','8802','Longitude of natural origin',-76.5205625,'EPSG','9102','EPSG','8806','False easting',1061900.18,'EPSG','9001','EPSG','8807','False northing',872364.63,'EPSG','9001','EPSG','1039','Projection plane origin height',1000.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102796_USAGE','conversion','ESRI','102796','ESRI','85','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102796','MAGNA_Cali_Valle_del_Cauca_2009',NULL,'EPSG','4400','EPSG','4686','ESRI','102796',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102796_USAGE','projected_crs','ESRI','102796','ESRI','85','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','86','Colombia - Mitu - Vaupes','Colombia - Mitu - Vaupes',0.7333333333333333,1.75,-70.75,-69.73333333333333,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102797','MAGNA_Mitu_Vaupes_2011',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Mitu_Vaupes_2011",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1093717.398],PARAMETER["False_Northing",629997.236],PARAMETER["Longitude_Of_Center",-70.23546165555555],PARAMETER["Latitude_Of_Center",1.249969366666667],PARAMETER["Height",170.0],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102797','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',1.249969366666667,'EPSG','9102','EPSG','8802','Longitude of natural origin',-70.23546165555555,'EPSG','9102','EPSG','8806','False easting',1093717.398,'EPSG','9001','EPSG','8807','False northing',629997.236,'EPSG','9001','EPSG','1039','Projection plane origin height',170.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102797_USAGE','conversion','ESRI','102797','ESRI','86','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102797','MAGNA_Mitu_Vaupes_2011',NULL,'EPSG','4400','EPSG','4686','ESRI','102797',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102797_USAGE','projected_crs','ESRI','102797','ESRI','86','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','87','Colombia - Puerto - Carreno - Vichada','Colombia - Puerto - Carreno - Vichada',5.666666666666667,6.683333333333334,-68.01666666666667,-67.0,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102798','MAGNA_Puerto_Carreno_Vichada_2011',NULL,NULL,NULL,'EPSG','4686',NULL,NULL,'PROJCS["MAGNA_Puerto_Carreno_Vichada_2011",GEOGCS["GCS_MAGNA",DATUM["D_MAGNA",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["IGAC_Plano_Cartesiano"],PARAMETER["False_Easting",1063834.703],PARAMETER["False_Northing",1175257.481],PARAMETER["Longitude_Of_Center",-67.50075024722223],PARAMETER["Latitude_Of_Center",6.18072141388889],PARAMETER["Height",51.58],UNIT["Meter",1.0]]',1);
+INSERT INTO "conversion" VALUES('ESRI','102798','unnamed',NULL,'EPSG','1052','Colombia Urban','EPSG','8801','Latitude of natural origin',6.18072141388889,'EPSG','9102','EPSG','8802','Longitude of natural origin',-67.50075024722223,'EPSG','9102','EPSG','8806','False easting',1063834.703,'EPSG','9001','EPSG','8807','False northing',1175257.481,'EPSG','9001','EPSG','1039','Projection plane origin height',51.58,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
+INSERT INTO "usage" VALUES('ESRI', 'CONV_102798_USAGE','conversion','ESRI','102798','ESRI','87','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102798','MAGNA_Puerto_Carreno_Vichada_2011',NULL,'EPSG','4400','EPSG','4686','ESRI','102798',NULL,1);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102798_USAGE','projected_crs','ESRI','102798','ESRI','87','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','88','UK - Highways England - A1','UK - Highways England - A1',50.1068,50.4249,-5.5482,-5.3991,0);
 INSERT INTO "conversion" VALUES('ESRI','102799','unnamed',NULL,'EPSG','9807','Transverse Mercator','EPSG','8801','Latitude of natural origin',49.0,'EPSG','9102','EPSG','8802','Longitude of natural origin',-2.0,'EPSG','9102','EPSG','8805','Scale factor at natural origin',0.99926,'EPSG','9201','EPSG','8806','False easting',261910.5587,'EPSG','9001','EPSG','8807','False northing',70975.76209,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);
-- 
cgit v1.2.3


From a048c9e09e3bae5d75b122ca8dc8b54a479d01ba Mon Sep 17 00:00:00 2001
From: Nyall Dawson <nyall.dawson@gmail.com>
Date: Tue, 23 Nov 2021 08:51:44 +1000
Subject: Map ESRI Equidistant_Cylindrical method to EPSG:1029 during ESRI
 projection engine db ingestion

---
 data/sql/esri.sql | 70 +++++++++++++++++++++++++++++++++++++++++--------------
 1 file changed, 52 insertions(+), 18 deletions(-)

(limited to 'data/sql/esri.sql')

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);
-- 
cgit v1.2.3


From 2586c949c03475bfaab1174781e4ee2e5a7238d4 Mon Sep 17 00:00:00 2001
From: Nyall Dawson <nyall.dawson@gmail.com>
Date: Tue, 23 Nov 2021 09:06:16 +1000
Subject: Map ESRI Cassini method to EPSG:9806 during ESRI projection engine db
 ingestion

---
 data/sql/esri.sql | 69 ++++++++++++++++++++++++++++++++++++++++---------------
 1 file changed, 50 insertions(+), 19 deletions(-)

(limited to 'data/sql/esri.sql')

diff --git a/data/sql/esri.sql b/data/sql/esri.sql
index 583e5be4..09d0bdc5 100644
--- a/data/sql/esri.sql
+++ b/data/sql/esri.sql
@@ -8569,7 +8569,9 @@ INSERT INTO "projected_crs" VALUES('ESRI','53026','Sphere_Stereographic',NULL,NU
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53026_USAGE','projected_crs','ESRI','53026','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','53027','Sphere_Equidistant_Conic',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Equidistant_Conic",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Equidistant_Conic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",60.0],PARAMETER["Standard_Parallel_2",60.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53027_USAGE','projected_crs','ESRI','53027','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','53028','Sphere_Cassini',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Cassini",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "conversion" VALUES('ESRI','53028','unnamed',NULL,'EPSG','9806','Cassini-Soldner','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_53028_USAGE','conversion','ESRI','53028','EPSG','1262','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','53028','Sphere_Cassini',NULL,'EPSG','4400','EPSG','4035','ESRI','53028',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_53028_USAGE','projected_crs','ESRI','53028','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','53029','Sphere_Van_der_Grinten_I',NULL,NULL,NULL,'EPSG','4035',NULL,NULL,'PROJCS["Sphere_Van_der_Grinten_I",GEOGCS["GCS_Sphere",DATUM["D_Sphere",SPHEROID["Sphere",6371000.0,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Van_der_Grinten_I"],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_53029_USAGE','projected_crs','ESRI','53029','EPSG','1262','EPSG','1024');
@@ -8667,7 +8669,7 @@ INSERT INTO "projected_crs" VALUES('ESRI','54026','World_Stereographic',NULL,NUL
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54026_USAGE','projected_crs','ESRI','54026','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','54027','World_Equidistant_Conic',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Equidistant_Conic",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_Conic"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",60.0],PARAMETER["Standard_Parallel_2",60.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54027_USAGE','projected_crs','ESRI','54027','EPSG','1262','EPSG','1024');
-INSERT INTO "projected_crs" VALUES('ESRI','54028','World_Cassini',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Cassini",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','54028','World_Cassini',NULL,'EPSG','4400','EPSG','4326','ESRI','53028',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_54028_USAGE','projected_crs','ESRI','54028','EPSG','1262','EPSG','1024');
 INSERT INTO "projected_crs" VALUES('ESRI','54029','World_Van_der_Grinten_I',NULL,NULL,NULL,'EPSG','4326',NULL,NULL,'PROJCS["World_Van_der_Grinten_I",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Van_der_Grinten_I"],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_54029_USAGE','projected_crs','ESRI','54029','EPSG','1262','EPSG','1024');
@@ -12029,55 +12031,84 @@ INSERT INTO "extent" VALUES('ESRI','175','Illinois - Metropolis','Illinois - Met
 INSERT INTO "projected_crs" VALUES('ESRI','102933','NAD_1983_(2011)_ICS_Metropolis_(US_Feet)',NULL,NULL,NULL,'EPSG','6318',NULL,NULL,'PROJCS["NAD_1983_(2011)_ICS_Metropolis_(US_Feet)",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic_1SP"],PARAMETER["False_Easting",3642000.0],PARAMETER["False_Northing",3839000.0],PARAMETER["Central_Meridian",-88.9],PARAMETER["Scale_Factor",1.00001],PARAMETER["Latitude_Of_Origin",37.2],UNIT["Foot_US",0.3048006096012192]]',0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102933_USAGE','projected_crs','ESRI','102933','ESRI','175','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','176','Bangladesh - Dinajpur','Bangladesh - Dinajpur',25.2166,26.6334,88.0833,89.3,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102934','Cassini_Bangladesh_Zone_01_Dinajpur',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_01_Dinajpur",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",88.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",25.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "coordinate_system" VALUES('ESRI','Chain','Cartesian',2);
+INSERT INTO "axis" VALUES('ESRI','3','Easting','E','east','ESRI','Chain',1,'EPSG','9097');
+INSERT INTO "axis" VALUES('ESRI','4','Northing','N','north','ESRI','Chain',2,'EPSG','9097');
+INSERT INTO "conversion" VALUES('ESRI','102934','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',25.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',88.5,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102934_USAGE','conversion','ESRI','102934','ESRI','176','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102934','Cassini_Bangladesh_Zone_01_Dinajpur',NULL,'ESRI','Chain','EPSG','4042','ESRI','102934',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102934_USAGE','projected_crs','ESRI','102934','ESRI','176','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','177','Bangladesh - Rangpur','Bangladesh - Rangpur',25.0333,26.45,88.9,89.8834,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102935','Cassini_Bangladesh_Zone_02_Rangpur',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_02_Rangpur",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",89.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",25.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102935','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',25.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',89.5,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102935_USAGE','conversion','ESRI','102935','ESRI','177','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102935','Cassini_Bangladesh_Zone_02_Rangpur',NULL,'ESRI','Chain','EPSG','4042','ESRI','102935',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102935_USAGE','projected_crs','ESRI','102935','ESRI','177','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','178','Bangladesh - Rajshahi','Bangladesh - Rajshahi',24.1,25.2,88.0,89.3334,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102936','Cassini_Bangladesh_Zone_03_Rajshahi',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_03_Rajshahi",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",88.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",24.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102936','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',24.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',88.5,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102936_USAGE','conversion','ESRI','102936','ESRI','178','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102936','Cassini_Bangladesh_Zone_03_Rajshahi',NULL,'ESRI','Chain','EPSG','4042','ESRI','102936',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102936_USAGE','projected_crs','ESRI','102936','ESRI','178','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','179','Bangladesh - Bogura','Bangladesh - Bogura',24.5333,25.2667,88.9166,89.75,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102937','Cassini_Bangladesh_Zone_04_Bogura',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_04_Bogura",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",89.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",24.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102937','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',24.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',89.5,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102937_USAGE','conversion','ESRI','102937','ESRI','179','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102937','Cassini_Bangladesh_Zone_04_Bogura',NULL,'ESRI','Chain','EPSG','4042','ESRI','102937',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102937_USAGE','projected_crs','ESRI','102937','ESRI','179','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','180','Bangladesh - Pabna','Bangladesh - Pabna',23.8,24.7667,88.9833,89.8167,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102938','Cassini_Bangladesh_Zone_05_Pabna',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_05_Pabna",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",89.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",24.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','102938','Cassini_Bangladesh_Zone_05_Pabna',NULL,'ESRI','Chain','EPSG','4042','ESRI','102937',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102938_USAGE','projected_crs','ESRI','102938','ESRI','180','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','181','Bangladesh - Mymensingh','Bangladesh - Mymensingh',23.95,24.4334,89.6333,91.25,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102939','Cassini_Bangladesh_Zone_06_Mymensingh',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_06_Mymensingh",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",90.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",24.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102939','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',24.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',90.5,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102939_USAGE','conversion','ESRI','102939','ESRI','181','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102939','Cassini_Bangladesh_Zone_06_Mymensingh',NULL,'ESRI','Chain','EPSG','4042','ESRI','102939',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102939_USAGE','projected_crs','ESRI','102939','ESRI','181','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','182','Bangladesh - Dhaka','Bangladesh - Dhaka',23.3666,24.3334,89.6833,90.9834,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102940','Cassini_Bangladesh_Zone_07_Dhaka',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_07_Dhaka",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",90.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",24.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','102940','Cassini_Bangladesh_Zone_07_Dhaka',NULL,'ESRI','Chain','EPSG','4042','ESRI','102939',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102940_USAGE','projected_crs','ESRI','102940','ESRI','182','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','183','Bangladesh - Faridpur','Bangladesh - Faridpur',22.8333,23.9,89.2833,89.5834,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102941','Cassini_Bangladesh_Zone_08_Faridpur',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_08_Faridpur",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",90.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",23.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102941','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',23.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',90.0,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102941_USAGE','conversion','ESRI','102941','ESRI','183','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102941','Cassini_Bangladesh_Zone_08_Faridpur',NULL,'ESRI','Chain','EPSG','4042','ESRI','102941',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102941_USAGE','projected_crs','ESRI','102941','ESRI','183','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','184','Bangladesh - Sylhet','Bangladesh - Sylhet',23.9666,25.2,90.9166,92.4834,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102942','Cassini_Bangladesh_Zone_09_Sylhet',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_09_Sylhet",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",92.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",24.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102942','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',24.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',92.0,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102942_USAGE','conversion','ESRI','102942','ESRI','184','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102942','Cassini_Bangladesh_Zone_09_Sylhet',NULL,'ESRI','Chain','EPSG','4042','ESRI','102942',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102942_USAGE','projected_crs','ESRI','102942','ESRI','184','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','185','Bangladesh - Kushtia','Bangladesh - Kushtia',23.3666,24.2167,88.55,89.35,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102943','Cassini_Bangladesh_Zone_10_Kushtia',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_10_Kushtia",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",89.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",23.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102943','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',23.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',89.5,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102943_USAGE','conversion','ESRI','102943','ESRI','185','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102943','Cassini_Bangladesh_Zone_10_Kushtia',NULL,'ESRI','Chain','EPSG','4042','ESRI','102943',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102943_USAGE','projected_crs','ESRI','102943','ESRI','185','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','186','Bangladesh - Joshore','Bangladesh - Joshore',22.7833,23.7667,88.6833,89.8,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102944','Cassini_Bangladesh_Zone_11_Joshore',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_11_Joshore",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",89.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",23.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','102944','Cassini_Bangladesh_Zone_11_Joshore',NULL,'ESRI','Chain','EPSG','4042','ESRI','102943',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102944_USAGE','projected_crs','ESRI','102944','ESRI','186','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','187','Bangladesh - Khulna','Bangladesh - Khulna',21.6333,23.0,88.8833,89.95,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102945','Cassini_Bangladesh_Zone_12_Khulna',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_12_Khulna",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",89.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",22.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102945','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',22.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',89.5,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102945_USAGE','conversion','ESRI','102945','ESRI','187','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102945','Cassini_Bangladesh_Zone_12_Khulna',NULL,'ESRI','Chain','EPSG','4042','ESRI','102945',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102945_USAGE','projected_crs','ESRI','102945','ESRI','187','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','188','Bangladesh - Barishal','Bangladesh - Barishal',21.7833,23.0667,89.85,91.0334,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102946','Cassini_Bangladesh_Zone_13_Barishal',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_13_Barishal",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",90.5],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",22.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102946','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',22.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',90.5,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102946_USAGE','conversion','ESRI','102946','ESRI','188','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102946','Cassini_Bangladesh_Zone_13_Barishal',NULL,'ESRI','Chain','EPSG','4042','ESRI','102946',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102946_USAGE','projected_crs','ESRI','102946','ESRI','188','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','189','Bangladesh - Cumilla','Bangladesh - Cumilla',22.9666,24.2667,90.5166,91.3667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102947','Cassini_Bangladesh_Zone_14_Cumilla',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_14_Cumilla",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",91.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",23.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102947','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',23.5,'EPSG','9102','EPSG','8802','Longitude of natural origin',91.0,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102947_USAGE','conversion','ESRI','102947','ESRI','189','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102947','Cassini_Bangladesh_Zone_14_Cumilla',NULL,'ESRI','Chain','EPSG','4042','ESRI','102947',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102947_USAGE','projected_crs','ESRI','102947','ESRI','189','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','190','Bangladesh - Noakhali','Bangladesh - Noakhali',22.0166,23.2834,90.65,91.5667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102948','Cassini_Bangladesh_Zone_15_Noakhali',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_15_Noakhali",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",91.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",23.5],UNIT["Chain",20.1168]]',0);
+INSERT INTO "projected_crs" VALUES('ESRI','102948','Cassini_Bangladesh_Zone_15_Noakhali',NULL,'ESRI','Chain','EPSG','4042','ESRI','102947',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102948_USAGE','projected_crs','ESRI','102948','ESRI','190','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','191','Bangladesh - Chottogram','Bangladesh - Chottogram',20.5833,22.9834,91.3,92.3667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102949','Cassini_Bangladesh_Zone_16_Chottogram',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_16_Chottogram",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",92.0],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",22.0],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102949','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',22.0,'EPSG','9102','EPSG','8802','Longitude of natural origin',92.0,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102949_USAGE','conversion','ESRI','102949','ESRI','191','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102949','Cassini_Bangladesh_Zone_16_Chottogram',NULL,'ESRI','Chain','EPSG','4042','ESRI','102949',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102949_USAGE','projected_crs','ESRI','102949','ESRI','191','EPSG','1024');
 INSERT INTO "extent" VALUES('ESRI','192','Bangladesh - CHT','Bangladesh - CHT',21.1833,23.7334,91.7,92.6667,0);
-INSERT INTO "projected_crs" VALUES('ESRI','102950','Cassini_Bangladesh_Zone_17_CHT',NULL,NULL,NULL,'EPSG','4042',NULL,NULL,'PROJCS["Cassini_Bangladesh_Zone_17_CHT",GEOGCS["GCS_Everest_1830",DATUM["D_Everest_1830",SPHEROID["Everest_1830",6377299.36,300.8017]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Cassini"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",92.25],PARAMETER["Scale_Factor",1.0],PARAMETER["Latitude_Of_Origin",22.75],UNIT["Chain",20.1168]]',0);
+INSERT INTO "conversion" VALUES('ESRI','102950','unnamed',NULL,'EPSG','9806','Cassini-Soldner','EPSG','8801','Latitude of natural origin',22.75,'EPSG','9102','EPSG','8802','Longitude of natural origin',92.25,'EPSG','9102','EPSG','8806','False easting',0.0,'EPSG','9097','EPSG','8807','False northing',0.0,'EPSG','9097',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_102950_USAGE','conversion','ESRI','102950','ESRI','192','EPSG','1024');
+INSERT INTO "projected_crs" VALUES('ESRI','102950','Cassini_Bangladesh_Zone_17_CHT',NULL,'ESRI','Chain','EPSG','4042','ESRI','102950',NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'PCRS_102950_USAGE','projected_crs','ESRI','102950','ESRI','192','EPSG','1024');
 INSERT INTO "conversion" VALUES('ESRI','102951','unnamed',NULL,'EPSG','9802','Lambert Conic Conformal (2SP)','EPSG','8821','Latitude of false origin',26.0,'EPSG','9102','EPSG','8822','Longitude of false origin',90.0,'EPSG','9102','EPSG','8823','Latitude of 1st standard parallel',23.15,'EPSG','9102','EPSG','8824','Latitude of 2nd standard parallel',28.8,'EPSG','9102','EPSG','8826','Easting at false origin',2743183.6991,'EPSG','9001','EPSG','8827','Northing at false origin',914395.233,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,0);
 INSERT INTO "usage" VALUES('ESRI', 'CONV_102951_USAGE','conversion','ESRI','102951','EPSG','1041','EPSG','1024');
-- 
cgit v1.2.3


From b258bedfdfd0ff31d96c60d55e66452fd49cb4aa Mon Sep 17 00:00:00 2001
From: Nyall Dawson <nyall.dawson@gmail.com>
Date: Wed, 24 Nov 2021 11:50:55 +1000
Subject: Add some additional method mapping during ESRI db import

---
 data/sql/esri.sql | 28 ++++++++++++++++++++--------
 1 file changed, 20 insertions(+), 8 deletions(-)

(limited to 'data/sql/esri.sql')

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);
-- 
cgit v1.2.3


From 5946b282628d372f5558c320f14a1c1395344e9c Mon Sep 17 00:00:00 2001
From: Nyall Dawson <nyall.dawson@gmail.com>
Date: Mon, 24 Jan 2022 12:21:26 +1000
Subject: [esri] Add special case when importing ESRI:102113

See https://github.com/OSGeo/PROJ/pull/2954#issuecomment-977771912 for rationale
---
 data/sql/esri.sql | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

(limited to 'data/sql/esri.sql')

diff --git a/data/sql/esri.sql b/data/sql/esri.sql
index 15a888ba..e064aac2 100644
--- a/data/sql/esri.sql
+++ b/data/sql/esri.sql
@@ -9102,9 +9102,7 @@ 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 "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 "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 "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');
-- 
cgit v1.2.3

