diff options
| -rw-r--r-- | data/sql/esri.sql | 286 | ||||
| -rwxr-xr-x | scripts/build_db_from_esri.py | 12 |
2 files changed, 149 insertions, 149 deletions
diff --git a/data/sql/esri.sql b/data/sql/esri.sql index 41b2b152..aaf1ac91 100644 --- a/data/sql/esri.sql +++ b/data/sql/esri.sql @@ -105,14 +105,14 @@ INSERT INTO ellipsoid VALUES('ESRI','107001','WGS_1966','WGS 1966','PROJ','EARTH INSERT INTO ellipsoid VALUES('ESRI','107002','Fischer_1960','Fischer 1960','PROJ','EARTH',6378166.0,'EPSG','9001',298.3,NULL,0); INSERT INTO ellipsoid VALUES('ESRI','107003','Fischer_1968','Fischer 1968','PROJ','EARTH',6378150.0,'EPSG','9001',298.3,NULL,0); INSERT INTO ellipsoid VALUES('ESRI','107004','Fischer_Modified','Fischer modified','PROJ','EARTH',6378155.0,'EPSG','9001',298.3,NULL,0); -INSERT INTO ellipsoid VALUES('ESRI','7053','Hough_1960','Hough 1960','PROJ','EARTH',6378270.0,'EPSG','9001',297.0,NULL,1); -INSERT INTO ellipsoid VALUES('ESRI','7056','Everest_Modified_1969','Everest modified 1969 - 107006, called Everest 1830 (RSO 1969) in EPSG','PROJ','EARTH',6377295.664,'EPSG','9001',300.8017,NULL,1); +INSERT INTO ellipsoid VALUES('ESRI','107005','Hough_1960','Hough 1960','PROJ','EARTH',6378270.0,'EPSG','9001',297.0,NULL,1); +INSERT INTO ellipsoid VALUES('ESRI','107006','Everest_Modified_1969','Everest modified 1969 - 107006, called Everest 1830 (RSO 1969) in EPSG','PROJ','EARTH',6377295.664,'EPSG','9001',300.8017,NULL,1); INSERT INTO ellipsoid VALUES('ESRI','107007','Walbeck','Walbeck','PROJ','EARTH',6376896.0,'EPSG','9001',302.78,NULL,0); INSERT INTO ellipsoid VALUES('ESRI','107008','Sphere_ARC_INFO','Authalic sphere (ARC/INFO)','PROJ','EARTH',6370997.0,'EPSG','9001',0.0,NULL,0); INSERT INTO ellipsoid VALUES('ESRI','107009','Sphere_EMEP','EMEP Sphere of 6370000 m','PROJ','EARTH',6370000.0,'EPSG','9001',0.0,NULL,0); -INSERT INTO ellipsoid VALUES('ESRI','7050','GRS_1967_Truncated','GRS 1967 Truncated - was 107036, called GRS67 Modified in EPSG','PROJ','EARTH',6378160.0,'EPSG','9001',298.25,NULL,1); -INSERT INTO ellipsoid VALUES('ESRI','7059','WGS_1984_Major_Auxiliary_Sphere','Major auxiliary sphere based on WGS 1984','PROJ','EARTH',6378137.0,'EPSG','9001',0.0,NULL,1); -INSERT INTO ellipsoid VALUES('ESRI','1024','CGCS2000','China Geodetic Coordinate System 2000','PROJ','EARTH',6378137.0,'EPSG','9001',298.257222101,NULL,1); +INSERT INTO ellipsoid VALUES('ESRI','107036','GRS_1967_Truncated','GRS 1967 Truncated - was 107036, called GRS67 Modified in EPSG','PROJ','EARTH',6378160.0,'EPSG','9001',298.25,NULL,1); +INSERT INTO ellipsoid VALUES('ESRI','107037','WGS_1984_Major_Auxiliary_Sphere','Major auxiliary sphere based on WGS 1984','PROJ','EARTH',6378137.0,'EPSG','9001',0.0,NULL,1); +INSERT INTO ellipsoid VALUES('ESRI','107038','CGCS2000','China Geodetic Coordinate System 2000','PROJ','EARTH',6378137.0,'EPSG','9001',298.257222101,NULL,1); INSERT INTO ellipsoid VALUES('ESRI','107047','Sphere_GRS_1980_Mean_Radius','Sphere with mean radius based on GRS80','PROJ','EARTH',6371008.7714,'EPSG','9001',0.0,NULL,0); INSERT INTO ellipsoid VALUES('ESRI','107700','S_GRS_1980_Adj_MN_Anoka','GRS 1980 Adj. Minnesota Anoka','PROJ','EARTH',6378418.941,'EPSG','9001',298.2572221008827,NULL,0); INSERT INTO ellipsoid VALUES('ESRI','107701','S_GRS_1980_Adj_MN_Becker','GRS 1980 Adj. Minnesota Becker','PROJ','EARTH',6378586.581,'EPSG','9001',298.2572221008827,NULL,0); @@ -1159,11 +1159,11 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4322','GCS_WGS_1972','ESRI' INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4324','GCS_WGS_1972_BE','ESRI'); INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4326','GCS_WGS_1984','ESRI'); INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4463','GCS_RGSPM_2006','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1038','D_Reseau_Geodesique_de_St_Pierre_et_Miquelon_2006','Reseau Geodesique de St Pierre et Miquelon 2006',NULL,'EPSG','7019','EPSG','8901','EPSG','1220',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','4466','GCS_RGSPM_2006',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1038','EPSG','1220',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106997','D_Reseau_Geodesique_de_St_Pierre_et_Miquelon_2006','Reseau Geodesique de St Pierre et Miquelon 2006',NULL,'EPSG','7019','EPSG','8901','EPSG','1220',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','4466','GCS_RGSPM_2006',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106997','EPSG','1220',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','4466','geodetic_crs','EPSG','4463','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1036','D_Reseau_Geodesique_de_Mayotte_2004','Reseau Geodesique de Mayotte 2004',NULL,'EPSG','7019','EPSG','8901','EPSG','1159',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','4469','GCS_RGM_2004',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1036','EPSG','1159',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106998','D_Reseau_Geodesique_de_Mayotte_2004','Reseau Geodesique de Mayotte 2004',NULL,'EPSG','7019','EPSG','8901','EPSG','1159',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','4469','GCS_RGM_2004',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106998','EPSG','1159',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','4469','geodetic_crs','EPSG','4470','ESRI'); INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4470','GCS_RGM_2004','ESRI'); INSERT INTO alias_name VALUES('geodetic_crs','EPSG','4475','GCS_Cadastre_1997','ESRI'); @@ -1407,8 +1407,8 @@ INSERT INTO alias_name VALUES('geodetic_crs','EPSG','7139','IGD05(2012)','ESRI') INSERT INTO alias_name VALUES('geodetic_crs','EPSG','7881','St_Helena_Tritan','ESRI'); INSERT INTO alias_name VALUES('geodetic_crs','EPSG','8042','Gusterberg(Ferro)','ESRI'); INSERT INTO alias_name VALUES('geodetic_crs','EPSG','8043','St._Stephen(Ferro)','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6760','D_WGS_1966','WGS 1966',NULL,'ESRI','107001','EPSG','8901','EPSG','1262',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37001','GCS_WGS_1966',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6760','EPSG','1262',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106001','D_WGS_1966','WGS 1966',NULL,'ESRI','107001','EPSG','8901','EPSG','1262',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37001','GCS_WGS_1966',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106001','EPSG','1262',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37001','geodetic_crs','EPSG','4760','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106002','D_Fischer_1960','Fischer 1960',NULL,'ESRI','107002','EPSG','8901','EPSG','1262',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37002','GCS_Fischer_1960',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106002','EPSG','1262',NULL,0); @@ -1416,154 +1416,154 @@ INSERT INTO "geodetic_datum" VALUES('ESRI','106003','D_Fischer_1968','Fischer 19 INSERT INTO "geodetic_crs" VALUES('ESRI','37003','GCS_Fischer_1968',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106003','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106004','D_Fischer_Modified','Fischer modified',NULL,'ESRI','107004','EPSG','8901','EPSG','1262',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37004','GCS_Fischer_Modified',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106004','EPSG','1262',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','106005','D_Hough_1960','Hough 1960',NULL,'ESRI','7053','EPSG','8901','EPSG','1262',0); +INSERT INTO "geodetic_datum" VALUES('ESRI','106005','D_Hough_1960','Hough 1960',NULL,'ESRI','107005','EPSG','8901','EPSG','1262',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37005','GCS_Hough_1960',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106005','EPSG','1262',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','106006','D_Everest_Modified_1969','Everest modified 1969',NULL,'ESRI','7056','EPSG','8901','EPSG','1262',0); +INSERT INTO "geodetic_datum" VALUES('ESRI','106006','D_Everest_Modified_1969','Everest modified 1969',NULL,'ESRI','107006','EPSG','8901','EPSG','1262',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37006','GCS_Everest_Modified_1969',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106006','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106007','D_Walbeck','Walbeck',NULL,'ESRI','107007','EPSG','8901','EPSG','1262',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37007','GCS_Walbeck',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106007','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106008','D_Sphere_ARC_INFO','Authalic sphere (ARC/INFO)',NULL,'ESRI','107008','EPSG','8901','EPSG','1262',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37008','GCS_Sphere_ARC_INFO',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106008','EPSG','1262',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6668','D_European_1979','European 1979',NULL,'EPSG','7022','EPSG','8901','EPSG','1297',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37201','GCS_European_1979',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6668','EPSG','1297',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106201','D_European_1979','European 1979',NULL,'EPSG','7022','EPSG','8901','EPSG','1297',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37201','GCS_European_1979',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106201','EPSG','1297',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37201','geodetic_crs','EPSG','4668','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106202','D_Everest_Bangladesh','Everest - Bangladesh',NULL,'EPSG','7015','EPSG','8901','EPSG','1041',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37202','GCS_Everest_Bangladesh',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106202','EPSG','1041',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106203','D_Everest_India_Nepal','Everest - India and Nepal',NULL,'EPSG','7044','EPSG','8901','EPSG','1121',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37203','GCS_Everest_India_Nepal',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106203','EPSG','1121',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6658','D_Hjorsey_1955','Hjorsey 1955',NULL,'EPSG','7022','EPSG','8901','EPSG','3262',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37204','GCS_Hjorsey_1955',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6658','EPSG','3262',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106204','D_Hjorsey_1955','Hjorsey 1955',NULL,'EPSG','7022','EPSG','8901','EPSG','3262',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37204','GCS_Hjorsey_1955',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106204','EPSG','3262',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37204','geodetic_crs','EPSG','4658','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6739','D_Hong_Kong_1963_67','Hong Kong 1963(67)',NULL,'EPSG','7022','EPSG','8901','EPSG','1118',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37205','GCS_Hong_Kong_1963_67',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6739','EPSG','1118',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106205','D_Hong_Kong_1963_67','Hong Kong 1963(67)',NULL,'EPSG','7022','EPSG','8901','EPSG','1118',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37205','GCS_Hong_Kong_1963_67',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106205','EPSG','1118',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37205','geodetic_crs','EPSG','4739','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106206','D_Oman','Oman',NULL,'EPSG','7012','EPSG','8901','EPSG','1183',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37206','GCS_Oman',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106206','EPSG','1183',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106207','D_South_Asia_Singapore','South Asia Singapore',NULL,'ESRI','107004','EPSG','8901','EPSG','1210',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37207','GCS_South_Asia_Singapore',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106207','EPSG','1210',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6713','D_Ayabelle','Ayabelle Lighthouse',NULL,'EPSG','7012','EPSG','8901','EPSG','1081',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37208','GCS_Ayabelle',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6713','EPSG','1081',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106208','D_Ayabelle','Ayabelle Lighthouse',NULL,'EPSG','7012','EPSG','8901','EPSG','1081',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37208','GCS_Ayabelle',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106208','EPSG','1081',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37208','geodetic_crs','EPSG','4713','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6620','D_Point_58','Point 58',NULL,'EPSG','7012','EPSG','8901','EPSG','2790',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37211','GCS_Point_58',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6620','EPSG','2790',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106211','D_Point_58','Point 58',NULL,'EPSG','7012','EPSG','8901','EPSG','2790',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37211','GCS_Point_58',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106211','EPSG','2790',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37211','geodetic_crs','EPSG','4620','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6709','D_Beacon_E_1945','Astro Beacon E 1945 (Iwo Jima 1945)',NULL,'EPSG','7022','EPSG','8901','EPSG','3200',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37212','GCS_Beacon_E_1945',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6709','EPSG','3200',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106212','D_Beacon_E_1945','Astro Beacon E 1945 (Iwo Jima 1945)',NULL,'EPSG','7022','EPSG','8901','EPSG','3200',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37212','GCS_Beacon_E_1945',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106212','EPSG','3200',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37212','geodetic_crs','EPSG','4709','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6707','D_Tern_Island_1961','Tern Island Astro 1961',NULL,'EPSG','7022','EPSG','8901','EPSG','3181',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37213','GCS_Tern_Island_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6707','EPSG','3181',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106213','D_Tern_Island_1961','Tern Island Astro 1961',NULL,'EPSG','7022','EPSG','8901','EPSG','3181',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37213','GCS_Tern_Island_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106213','EPSG','3181',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37213','geodetic_crs','EPSG','4707','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6711','D_Astro_1952','Astronomical Station 1952 (Marcus Island 1952 )',NULL,'EPSG','7022','EPSG','8901','EPSG','1872',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37214','GCS_Astro_1952',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6711','EPSG','1872',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106214','D_Astro_1952','Astronomical Station 1952 (Marcus Island 1952 )',NULL,'EPSG','7022','EPSG','8901','EPSG','1872',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37214','GCS_Astro_1952',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106214','EPSG','1872',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37214','geodetic_crs','EPSG','4711','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6714','D_Bellevue_IGN','Bellevue IGN',NULL,'EPSG','7022','EPSG','8901','EPSG','3193',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37215','GCS_Bellevue_IGN',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6714','EPSG','3193',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106215','D_Bellevue_IGN','Bellevue IGN',NULL,'EPSG','7022','EPSG','8901','EPSG','3193',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37215','GCS_Bellevue_IGN',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106215','EPSG','3193',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37215','geodetic_crs','EPSG','4714','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6716','D_Canton_1966','Canton Astro 1966 (Phoenix Islands 1966)',NULL,'EPSG','7022','EPSG','8901','EPSG','3196',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37216','GCS_Canton_1966',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6716','EPSG','3196',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106216','D_Canton_1966','Canton Astro 1966 (Phoenix Islands 1966)',NULL,'EPSG','7022','EPSG','8901','EPSG','3196',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37216','GCS_Canton_1966',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106216','EPSG','3196',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37216','geodetic_crs','EPSG','4716','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6672','D_Chatham_Island_1971','Chatham Island Astro 1971',NULL,'EPSG','7022','EPSG','8901','EPSG','2889',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37217','GCS_Chatham_Island_1971',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6672','EPSG','2889',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106217','D_Chatham_Island_1971','Chatham Island Astro 1971',NULL,'EPSG','7022','EPSG','8901','EPSG','2889',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37217','GCS_Chatham_Island_1971',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106217','EPSG','2889',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37217','geodetic_crs','EPSG','4672','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106218','D_DOS_1968','DOS 1968',NULL,'EPSG','7022','EPSG','8901','EPSG','3198',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37218','GCS_DOS_1968',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106218','EPSG','3198',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6719','D_Easter_Island_1967','Easter Island 1967',NULL,'EPSG','7022','EPSG','8901','EPSG','3188',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37219','GCS_Easter_Island_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6719','EPSG','3188',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106219','D_Easter_Island_1967','Easter Island 1967',NULL,'EPSG','7022','EPSG','8901','EPSG','3188',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37219','GCS_Easter_Island_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106219','EPSG','3188',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37219','geodetic_crs','EPSG','4719','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6675','D_Guam_1963','Guam 1963',NULL,'EPSG','7008','EPSG','8901','EPSG','4167',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37220','GCS_Guam_1963',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6675','EPSG','4167',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106220','D_Guam_1963','Guam 1963',NULL,'EPSG','7008','EPSG','8901','EPSG','4167',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37220','GCS_Guam_1963',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106220','EPSG','4167',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37220','geodetic_crs','EPSG','4675','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106221','D_GUX_1','GUX 1 Astro',NULL,'EPSG','7022','EPSG','8901','EPSG','3197',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37221','GCS_GUX_1',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106221','EPSG','3197',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6725','D_Johnston_Island_1961','Johnston Island 1961',NULL,'EPSG','7022','EPSG','8901','EPSG','3201',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37222','GCS_Johnston_Island_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6725','EPSG','3201',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106222','D_Johnston_Island_1961','Johnston Island 1961',NULL,'EPSG','7022','EPSG','8901','EPSG','3201',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37222','GCS_Johnston_Island_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106222','EPSG','3201',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37222','geodetic_crs','EPSG','4725','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','37223','GCS_Carthage',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6223','EPSG','1236',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37223','geodetic_crs','EPSG','4223','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6727','D_Midway_1961','Midway Astro 1961',NULL,'EPSG','7022','EPSG','8901','EPSG','3202',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37224','GCS_Midway_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6727','EPSG','3202',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106224','D_Midway_1961','Midway Astro 1961',NULL,'EPSG','7022','EPSG','8901','EPSG','3202',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37224','GCS_Midway_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106224','EPSG','3202',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37224','geodetic_crs','EPSG','4727','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','37225','GCS_Carthage_Grad',NULL,NULL,'geographic 2D','EPSG','6403','EPSG','6223','EPSG','1236',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6729','D_Pitcairn_1967','Pitcairn Astro 1967',NULL,'EPSG','7022','EPSG','8901','EPSG','3208',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37226','GCS_Pitcairn_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6729','EPSG','3208',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106226','D_Pitcairn_1967','Pitcairn Astro 1967',NULL,'EPSG','7022','EPSG','8901','EPSG','3208',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37226','GCS_Pitcairn_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106226','EPSG','3208',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37226','geodetic_crs','EPSG','4729','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6730','D_Santo_DOS_1965','Santo DOS 1965',NULL,'EPSG','7022','EPSG','8901','EPSG','3194',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37227','GCS_Santo_DOS_1965',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6730','EPSG','3194',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106227','D_Santo_DOS_1965','Santo DOS 1965',NULL,'EPSG','7022','EPSG','8901','EPSG','3194',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37227','GCS_Santo_DOS_1965',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106227','EPSG','3194',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37227','geodetic_crs','EPSG','4730','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6731','D_Viti_Levu_1916','Viti Levu 1916',NULL,'EPSG','7012','EPSG','8901','EPSG','3195',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37228','GCS_Viti_Levu_1916',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6731','EPSG','3195',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106228','D_Viti_Levu_1916','Viti Levu 1916',NULL,'EPSG','7012','EPSG','8901','EPSG','3195',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37228','GCS_Viti_Levu_1916',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106228','EPSG','3195',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37228','geodetic_crs','EPSG','4731','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6732','D_Wake_Eniwetok_1960','Wake-Eniwetok 1960 (Marshall Islands 1960)',NULL,'ESRI','7053','EPSG','8901','EPSG','3191',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37229','GCS_Wake_Eniwetok_1960',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6732','EPSG','3191',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106229','D_Wake_Eniwetok_1960','Wake-Eniwetok 1960 (Marshall Islands 1960)',NULL,'ESRI','107005','EPSG','8901','EPSG','3191',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37229','GCS_Wake_Eniwetok_1960',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106229','EPSG','3191',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37229','geodetic_crs','EPSG','4732','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6733','D_Wake_Island_1952','Wake Island Astro 1952',NULL,'EPSG','7022','EPSG','8901','EPSG','3190',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37230','GCS_Wake_Island_1952',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6733','EPSG','3190',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106230','D_Wake_Island_1952','Wake Island Astro 1952',NULL,'EPSG','7022','EPSG','8901','EPSG','3190',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37230','GCS_Wake_Island_1952',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106230','EPSG','3190',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37230','geodetic_crs','EPSG','4733','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6708','D_Anna_1_1965','Anna 1 Astro 1965 (Cocos Islands 1965)',NULL,'EPSG','7003','EPSG','8901','EPSG','1069',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37231','GCS_Anna_1_1965',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6708','EPSG','1069',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106231','D_Anna_1_1965','Anna 1 Astro 1965 (Cocos Islands 1965)',NULL,'EPSG','7003','EPSG','8901','EPSG','1069',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37231','GCS_Anna_1_1965',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106231','EPSG','1069',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37231','geodetic_crs','EPSG','4708','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6684','D_Gan_1970','Gan 1970',NULL,'EPSG','7022','EPSG','8901','EPSG','3274',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37232','GCS_Gan_1970',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6684','EPSG','3274',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106232','D_Gan_1970','Gan 1970',NULL,'EPSG','7022','EPSG','8901','EPSG','3274',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37232','GCS_Gan_1970',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106232','EPSG','3274',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37232','geodetic_crs','EPSG','4684','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6724','D_ISTS_073_1969','ISTS 073 Astro 1969 (Diego Garcia 1969)',NULL,'EPSG','7022','EPSG','8901','EPSG','3189',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37233','GCS_ISTS_073_1969',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6724','EPSG','3189',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106233','D_ISTS_073_1969','ISTS 073 Astro 1969 (Diego Garcia 1969)',NULL,'EPSG','7022','EPSG','8901','EPSG','3189',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37233','GCS_ISTS_073_1969',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106233','EPSG','3189',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37233','geodetic_crs','EPSG','4724','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6698','D_Kerguelen_Island_1949','Kerguelen Island 1949',NULL,'EPSG','7022','EPSG','8901','EPSG','2816',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37234','GCS_Kerguelen_Island_1949',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6698','EPSG','2816',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106234','D_Kerguelen_Island_1949','Kerguelen Island 1949',NULL,'EPSG','7022','EPSG','8901','EPSG','2816',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37234','GCS_Kerguelen_Island_1949',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106234','EPSG','2816',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37234','geodetic_crs','EPSG','4698','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6626','D_Reunion_1947','Reunion 1947',NULL,'EPSG','7022','EPSG','8901','EPSG','3337',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37235','GCS_Reunion_1947',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6626','EPSG','3337',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106235','D_Reunion_1947','Reunion 1947',NULL,'EPSG','7022','EPSG','8901','EPSG','3337',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37235','GCS_Reunion_1947',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106235','EPSG','3337',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37235','geodetic_crs','EPSG','4626','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6712','D_Ascension_Island_1958','Ascension Island 1958',NULL,'EPSG','7022','EPSG','8901','EPSG','3182',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37237','GCS_Ascension_Island_1958',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6712','EPSG','3182',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106237','D_Ascension_Island_1958','Ascension Island 1958',NULL,'EPSG','7022','EPSG','8901','EPSG','3182',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37237','GCS_Ascension_Island_1958',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106237','EPSG','3182',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37237','geodetic_crs','EPSG','4712','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6710','D_DOS_71_4','Astro DOS 71/4 (St. Helena 1971)',NULL,'EPSG','7022','EPSG','8901','EPSG','3183',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37238','GCS_DOS_71_4',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6710','EPSG','3183',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106238','D_DOS_71_4','Astro DOS 71/4 (St. Helena 1971)',NULL,'EPSG','7022','EPSG','8901','EPSG','3183',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37238','GCS_DOS_71_4',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106238','EPSG','3183',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37238','geodetic_crs','EPSG','4710','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6717','D_Cape_Canaveral','Cape Canaveral',NULL,'EPSG','7008','EPSG','8901','EPSG','3206',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37239','GCS_Cape_Canaveral',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6717','EPSG','3206',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106239','D_Cape_Canaveral','Cape Canaveral',NULL,'EPSG','7008','EPSG','8901','EPSG','3206',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37239','GCS_Cape_Canaveral',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106239','EPSG','3206',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37239','geodetic_crs','EPSG','4717','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106240','D_Fort_Thomas_1955','Fort Thomas 1955',NULL,'EPSG','7012','EPSG','8901','EPSG','1200',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37240','GCS_Fort_Thomas_1955',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106240','EPSG','1200',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106241','D_Graciosa_Base_SW_1948','Graciosa Base SW 1948',NULL,'EPSG','7022','EPSG','8901','EPSG','1301',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37241','GCS_Graciosa_Base_SW_1948',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106241','EPSG','1301',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6722','D_ISTS_061_1968','ISTS 061 Astro 1968 (South Georgia 1968)',NULL,'EPSG','7022','EPSG','8901','EPSG','3529',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37242','GCS_ISTS_061_1968',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6722','EPSG','3529',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106242','D_ISTS_061_1968','ISTS 061 Astro 1968 (South Georgia 1968)',NULL,'EPSG','7022','EPSG','8901','EPSG','3529',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37242','GCS_ISTS_061_1968',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106242','EPSG','3529',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37242','geodetic_crs','EPSG','4722','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106243','D_LC5_1961','L.C. 5 Astro 1961',NULL,'EPSG','7008','EPSG','8901','EPSG','3207',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37243','GCS_LC5_1961',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106243','EPSG','3207',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106245','D_Observatorio_Meteorologico_1939','Observ. Meteorologico 1939',NULL,'EPSG','7022','EPSG','8901','EPSG','1344',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37245','GCS_Observatorio_Meteorologico_1939',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106245','EPSG','1344',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6728','D_Pico_de_Las_Nieves','Pico de Las Nieves',NULL,'EPSG','7022','EPSG','8901','EPSG','3873',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37246','GCS_Pico_de_Las_Nieves',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6728','EPSG','3873',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106246','D_Pico_de_Las_Nieves','Pico de Las Nieves',NULL,'EPSG','7022','EPSG','8901','EPSG','3873',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37246','GCS_Pico_de_Las_Nieves',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106246','EPSG','3873',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37246','geodetic_crs','EPSG','4728','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6615','D_Porto_Santo_1936','Porto Santo 1936',NULL,'EPSG','7022','EPSG','8901','EPSG','1314',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37247','GCS_Porto_Santo_1936',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6615','EPSG','1314',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106247','D_Porto_Santo_1936','Porto Santo 1936',NULL,'EPSG','7022','EPSG','8901','EPSG','1314',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37247','GCS_Porto_Santo_1936',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106247','EPSG','1314',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37247','geodetic_crs','EPSG','4615','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106249','D_Sao_Braz','Sao Braz',NULL,'EPSG','7022','EPSG','8901','EPSG','1345',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37249','GCS_Sao_Braz',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106249','EPSG','1345',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6616','D_Selvagem_Grande_1938','Selvagem Grande 1938',NULL,'EPSG','7022','EPSG','8901','EPSG','2779',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37250','GCS_Selvagem_Grande_1938',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6616','EPSG','2779',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106250','D_Selvagem_Grande_1938','Selvagem Grande 1938',NULL,'EPSG','7022','EPSG','8901','EPSG','2779',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37250','GCS_Selvagem_Grande_1938',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106250','EPSG','2779',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37250','geodetic_crs','EPSG','4616','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6734','D_Tristan_1968','Tristan Astro 1968',NULL,'EPSG','7022','EPSG','8901','EPSG','3184',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37251','GCS_Tristan_1968',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6734','EPSG','3184',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106251','D_Tristan_1968','Tristan Astro 1968',NULL,'EPSG','7022','EPSG','8901','EPSG','3184',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37251','GCS_Tristan_1968',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106251','EPSG','3184',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37251','geodetic_crs','EPSG','4734','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6169','D_American_Samoa_1962','American Samoa 1962',NULL,'EPSG','7008','EPSG','8901','EPSG','3109',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37252','GCS_American_Samoa_1962',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6169','EPSG','3109',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106252','D_American_Samoa_1962','American Samoa 1962',NULL,'EPSG','7008','EPSG','8901','EPSG','3109',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37252','GCS_American_Samoa_1962',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106252','EPSG','3109',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37252','geodetic_crs','EPSG','4169','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6715','D_Camp_Area','Camp Area Astro',NULL,'EPSG','7022','EPSG','8901','EPSG','3205',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37253','GCS_Camp_Area',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6715','EPSG','3205',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106253','D_Camp_Area','Camp Area Astro',NULL,'EPSG','7022','EPSG','8901','EPSG','3205',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37253','GCS_Camp_Area',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106253','EPSG','3205',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37253','geodetic_crs','EPSG','4715','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6736','D_Deception_Island','Deception Island',NULL,'EPSG','7012','EPSG','8901','EPSG','3204',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37254','GCS_Deception_Island',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6736','EPSG','3204',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106254','D_Deception_Island','Deception Island',NULL,'EPSG','7012','EPSG','8901','EPSG','3204',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37254','GCS_Deception_Island',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106254','EPSG','3204',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37254','geodetic_crs','EPSG','4736','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6613','D_Gunung_Segara','Gunung Segara',NULL,'EPSG','7004','EPSG','8901','EPSG','1360',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37255','GCS_Gunung_Segara',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6613','EPSG','1360',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106255','D_Gunung_Segara','Gunung Segara',NULL,'EPSG','7004','EPSG','8901','EPSG','1360',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37255','GCS_Gunung_Segara',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106255','EPSG','1360',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37255','geodetic_crs','EPSG','4613','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106257','D_S42_Hungary','S-42 Hungary',NULL,'EPSG','7024','EPSG','8901','EPSG','1119',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37257','GCS_S42_Hungary',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106257','EPSG','1119',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6735','D_Kusaie_1951','Kusaie Astro 1951',NULL,'EPSG','7022','EPSG','8901','EPSG','3192',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','37259','GCS_Kusaie_1951',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6735','EPSG','3192',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106259','D_Kusaie_1951','Kusaie Astro 1951',NULL,'EPSG','7022','EPSG','8901','EPSG','3192',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','37259','GCS_Kusaie_1951',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106259','EPSG','3192',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','37259','geodetic_crs','EPSG','4735','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106260','D_Alaskan_Islands','Alaskan Islands',NULL,'EPSG','7008','EPSG','8901','EPSG','1330',0); INSERT INTO "geodetic_crs" VALUES('ESRI','37260','GCS_Alaskan_Islands',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106260','EPSG','1330',NULL,0); @@ -1580,8 +1580,8 @@ INSERT INTO "geodetic_crs" VALUES('ESRI','104016','WGS_1984_(Transit)',NULL,NULL INSERT INTO "geodetic_crs" VALUES('ESRI','104017','PZ-90.02',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1157','EPSG','1262',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104018','PZ-90.11',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1158','EPSG','1262',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104019','ITRF2014',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1165','EPSG','1262',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','1128','D_JGD_2011','Japan Geodetic Datum 2011',NULL,'EPSG','7019','EPSG','8901','EPSG','1129',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104020','GCS_JGD_2011',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1128','EPSG','1129',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106020','D_JGD_2011','Japan Geodetic Datum 2011',NULL,'EPSG','7019','EPSG','8901','EPSG','1129',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104020','GCS_JGD_2011',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106020','EPSG','1129',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104020','geodetic_crs','EPSG','6668','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104021','IGS14',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1191','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','6023','D_International_1967','International 1967',NULL,'ESRI','7023','EPSG','8901','EPSG','1263',0); @@ -1591,8 +1591,8 @@ INSERT INTO "geodetic_crs" VALUES('ESRI','104047','GCS_Sphere_GRS_1980_Mean_Radi INSERT INTO "area" VALUES('ESRI','1','UK - London','UK - London',51.2,51.8,-0.7,0.6,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106050','D_Xrail84','Xrail84',NULL,'EPSG','7030','EPSG','8901','ESRI','1',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104050','GCS_Xrail84',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106050','ESRI','1',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','1056','D_GDBD2009','GDBD2009',NULL,'EPSG','7019','EPSG','8901','EPSG','1055',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104100','GCS_GDBD2009',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1056','EPSG','1055',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106100','D_GDBD2009','GDBD2009',NULL,'EPSG','7019','EPSG','8901','EPSG','1055',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104100','GCS_GDBD2009',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106100','EPSG','1055',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104100','geodetic_crs','EPSG','5246','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106101','D_Estonia_1937','Estonia 1937',NULL,'EPSG','7004','EPSG','8901','EPSG','1090',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104101','GCS_Estonia_1937',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106101','EPSG','1090',NULL,0); @@ -1600,33 +1600,33 @@ INSERT INTO "geodetic_datum" VALUES('ESRI','106102','D_Hermannskogel','Hermannsk INSERT INTO "geodetic_crs" VALUES('ESRI','104102','GCS_Hermannskogel',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106102','EPSG','1321',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106103','D_Sierra_Leone_1960','Sierra Leone 1960',NULL,'EPSG','7012','EPSG','8901','EPSG','1209',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104103','GCS_Sierra_Leone_1960',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106103','EPSG','1209',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6611','D_Hong_Kong_1980','Hong Kong 1980',NULL,'EPSG','7022','EPSG','8901','EPSG','1118',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104104','GCS_Hong_Kong_1980',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6611','EPSG','1118',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106261','D_Hong_Kong_1980','Hong Kong 1980',NULL,'EPSG','7022','EPSG','8901','EPSG','1118',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104104','GCS_Hong_Kong_1980',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106261','EPSG','1118',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104104','geodetic_crs','EPSG','4611','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106262','D_Datum_Lisboa_Bessel','Datum Lisboa Bessel',NULL,'EPSG','7004','EPSG','8901','EPSG','1193',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104105','GCS_Datum_Lisboa_Bessel',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106262','EPSG','1193',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106263','D_Datum_Lisboa_Hayford','Datum Lisboa Hayford',NULL,'EPSG','7022','EPSG','8901','EPSG','1193',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104106','GCS_Datum_Lisboa_Hayford',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106263','EPSG','1193',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6171','D_RGF_1993','Reseau Geodesique Francais 1993',NULL,'EPSG','7019','EPSG','8901','EPSG','1096',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104107','GCS_RGF_1993',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6171','EPSG','1096',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106264','D_RGF_1993','Reseau Geodesique Francais 1993',NULL,'EPSG','7019','EPSG','8901','EPSG','1096',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104107','GCS_RGF_1993',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106264','EPSG','1096',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104107','geodetic_crs','EPSG','4171','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6167','D_NZGD_2000','New Zealand Geodetic Datum 2000',NULL,'EPSG','7019','EPSG','8901','EPSG','1175',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104108','GCS_NZGD_2000',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6167','EPSG','1175',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106265','D_NZGD_2000','New Zealand Geodetic Datum 2000',NULL,'EPSG','7019','EPSG','8901','EPSG','1175',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104108','GCS_NZGD_2000',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106265','EPSG','1175',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104108','geodetic_crs','EPSG','4167','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106266','D_Pohnpei','Pohnpei - Fed. States Micronesia',NULL,'EPSG','7008','EPSG','8901','EPSG','1161',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104109','GCS_Pohnpei',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106266','EPSG','1161',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6189','D_REGVEN','REGVEN',NULL,'EPSG','7019','EPSG','8901','EPSG','1251',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104110','GCS_REGVEN',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6189','EPSG','1251',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106267','D_REGVEN','REGVEN',NULL,'EPSG','7019','EPSG','8901','EPSG','1251',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104110','GCS_REGVEN',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106267','EPSG','1251',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104110','geodetic_crs','EPSG','4189','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6612','D_JGD_2000','Japan Geodetic Datum 2000',NULL,'EPSG','7019','EPSG','8901','EPSG','1129',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104111','GCS_JGD_2000',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6612','EPSG','1129',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106268','D_JGD_2000','Japan Geodetic Datum 2000',NULL,'EPSG','7019','EPSG','8901','EPSG','1129',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104111','GCS_JGD_2000',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106268','EPSG','1129',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104111','geodetic_crs','EPSG','4612','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106269','D_Bab_South','Bab South Astro - Bablethuap Is - Republic of Palau',NULL,'EPSG','7008','EPSG','8901','EPSG','1185',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104112','GCS_Bab_South',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106269','EPSG','1185',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106270','D_Majuro','Majuro - Republic of Marshall Is.',NULL,'EPSG','7008','EPSG','8901','EPSG','1155',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104113','GCS_Majuro',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106270','EPSG','1155',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6762','D_Bermuda_2000','Bermuda 2000',NULL,'EPSG','7030','EPSG','8901','EPSG','1047',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104114','GCS_Bermuda_2000',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6762','EPSG','1047',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106271','D_Bermuda_2000','Bermuda 2000',NULL,'EPSG','7030','EPSG','8901','EPSG','1047',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104114','GCS_Bermuda_2000',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106271','EPSG','1047',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104114','geodetic_crs','EPSG','4762','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104115','GCS_ITRF_1988',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6647','EPSG','1262',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104116','GCS_ITRF_1989',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6648','EPSG','1262',NULL,0); @@ -1638,8 +1638,8 @@ INSERT INTO "geodetic_crs" VALUES('ESRI','104121','GCS_ITRF_1994',NULL,NULL,'geo INSERT INTO "geodetic_crs" VALUES('ESRI','104122','GCS_ITRF_1996',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6654','EPSG','1262',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104123','GCS_ITRF_1997',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6655','EPSG','1262',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104124','GCS_ITRF_2000',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6656','EPSG','1262',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6673','D_Chatham_Islands_1979','Chatham Islands 1979',NULL,'EPSG','7022','EPSG','8901','EPSG','2889',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104125','GCS_Chatham_Islands_1979',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6673','EPSG','2889',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106273','D_Chatham_Islands_1979','Chatham Islands 1979',NULL,'EPSG','7022','EPSG','8901','EPSG','2889',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104125','GCS_Chatham_Islands_1979',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106273','EPSG','2889',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104125','geodetic_crs','EPSG','4673','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106274','D_Observatorio_Meteorologico_1965','Observatorio Meteorologico 1965',NULL,'EPSG','7022','EPSG','8901','EPSG','1147',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104126','GCS_Observatorio_Meteorologico_1965',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106274','EPSG','1147',NULL,0); @@ -1652,38 +1652,38 @@ INSERT INTO "geodetic_datum" VALUES('ESRI','106277','D_Jordan','Jordan',NULL,'EP INSERT INTO "geodetic_crs" VALUES('ESRI','104130','GCS_Jordan',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106277','EPSG','1130',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106278','D_D48','D48 - Slovenia',NULL,'EPSG','7004','EPSG','8901','EPSG','1212',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104131','GCS_D48',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106278','EPSG','1212',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','1070','D_Ocotepeque_1935','Ocotepeque 1935',NULL,'EPSG','7008','EPSG','8901','EPSG','3876',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104132','GCS_Ocotepeque_1935',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1070','EPSG','3876',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106279','D_Ocotepeque_1935','Ocotepeque 1935',NULL,'EPSG','7008','EPSG','8901','EPSG','3876',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104132','GCS_Ocotepeque_1935',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106279','EPSG','3876',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104132','geodetic_crs','EPSG','5451','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','6758','D_Jamaica_2001','Jamaica 2001',NULL,'EPSG','7030','EPSG','8901','EPSG','1128',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104133','GCS_JAD_2001',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6758','EPSG','1128',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106280','D_Jamaica_2001','Jamaica 2001',NULL,'EPSG','7030','EPSG','8901','EPSG','1128',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104133','GCS_JAD_2001',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106280','EPSG','1128',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104133','geodetic_crs','EPSG','4758','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104134','GCS_MONREF_1997',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6656','EPSG','1164',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104135','GCS_MSK_1942',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6284','EPSG','1164',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','1025','D_TWD_1967','Taiwan 1967',NULL,'ESRI','7050','EPSG','8901','EPSG','3315',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104136','GCS_TWD_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1025','EPSG','3315',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106281','D_TWD_1967','Taiwan 1967',NULL,'ESRI','107036','EPSG','8901','EPSG','3315',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104136','GCS_TWD_1967',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106281','EPSG','3315',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104136','geodetic_crs','EPSG','3821','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1026','D_TWD_1997','Taiwan 1997',NULL,'EPSG','7019','EPSG','8901','EPSG','1228',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104137','GCS_TWD_1997',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1026','EPSG','1228',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106282','D_TWD_1997','Taiwan 1997',NULL,'EPSG','7019','EPSG','8901','EPSG','1228',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104137','GCS_TWD_1997',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106282','EPSG','1228',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104137','geodetic_crs','EPSG','3824','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106284','D_Old_Hawaiian_Intl_1924','Old Hawaiian on Intl_1924 spheroid (NGS)',NULL,'EPSG','7022','EPSG','8901','EPSG','1334',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104138','GCS_Old_Hawaiian_Intl_1924',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106284','EPSG','1334',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104139','GCS_Voirol_1875_Grad',NULL,NULL,'geographic 2D','EPSG','6403','EPSG','6304','EPSG','1365',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104140','GCS_Voirol_1879_Grad',NULL,NULL,'geographic 2D','EPSG','6403','EPSG','6671','EPSG','1365',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','1112','D_Cyprus_Geodetic_Reference_System_1993','Cyprus GRS 1993',NULL,'EPSG','7030','EPSG','8901','EPSG','3236',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104141','GCS_CGRS_1993',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1112','EPSG','3236',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106225','D_Cyprus_Geodetic_Reference_System_1993','Cyprus GRS 1993',NULL,'EPSG','7030','EPSG','8901','EPSG','3236',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104141','GCS_CGRS_1993',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106225','EPSG','3236',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104141','geodetic_crs','EPSG','6311','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1041','D_PTRA08','Portugal - Autonomous Regions (Madeira and Azores Archipelagos)',NULL,'EPSG','7019','EPSG','8901','EPSG','3670',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104142','GCS_PTRA08',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1041','EPSG','3670',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106236','D_PTRA08','Portugal - Autonomous Regions (Madeira and Azores Archipelagos)',NULL,'EPSG','7019','EPSG','8901','EPSG','3670',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104142','GCS_PTRA08',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106236','EPSG','3670',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104142','geodetic_crs','EPSG','5013','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1065','D_Costa_Rica_2005','Costa Rica 2005',NULL,'EPSG','7030','EPSG','8901','EPSG','1074',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104143','GCS_CR05',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1065','EPSG','1074',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106244','D_Costa_Rica_2005','Costa Rica 2005',NULL,'EPSG','7030','EPSG','8901','EPSG','1074',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104143','GCS_CR05',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106244','EPSG','1074',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104143','geodetic_crs','EPSG','5365','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1060','D_Islands_Network_2004','Islands Network 2004',NULL,'EPSG','7019','EPSG','8901','EPSG','1120',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104144','GCS_ISN_2004',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1060','EPSG','1120',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106144','D_Islands_Network_2004','Islands Network 2004',NULL,'EPSG','7019','EPSG','8901','EPSG','1120',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104144','GCS_ISN_2004',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106144','EPSG','1120',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104144','geodetic_crs','EPSG','5324','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1116','D_NAD_1983_2011','NAD 1983 (2011)',NULL,'EPSG','7019','EPSG','8901','EPSG','1511',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104145','GCS_NAD_1983_2011',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1116','EPSG','1511',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106285','D_NAD_1983_2011','NAD 1983 (2011)',NULL,'EPSG','7019','EPSG','8901','EPSG','1511',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104145','GCS_NAD_1983_2011',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106285','EPSG','1511',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104145','geodetic_crs','EPSG','6318','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104179','ETRF90',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1179','EPSG','1298',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104180','ETRF91',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1180','EPSG','1298',NULL,0); @@ -1693,30 +1693,30 @@ INSERT INTO "geodetic_crs" VALUES('ESRI','104183','ETRF94',NULL,NULL,'geographic INSERT INTO "geodetic_crs" VALUES('ESRI','104184','ETRF96',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1184','EPSG','1298',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104185','ETRF97',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1185','EPSG','1298',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104186','ETRF2000',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1186','EPSG','1298',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','6055','D_WGS_1984_Major_Auxiliary_Sphere','Major auxiliary sphere based on WGS 1984',NULL,'ESRI','7059','EPSG','8901','EPSG','1262',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104199','GCS_WGS_1984_Major_Auxiliary_Sphere',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','6055','EPSG','1262',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106283','D_WGS_1984_Major_Auxiliary_Sphere','Major auxiliary sphere based on WGS 1984',NULL,'ESRI','107037','EPSG','8901','EPSG','1262',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104199','GCS_WGS_1984_Major_Auxiliary_Sphere',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106283','EPSG','1262',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104199','geodetic_crs','EPSG','4055','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1133','D_NAD_1983_CORS96','NAD 1983 (CORS96)',NULL,'EPSG','7019','EPSG','8901','EPSG','1511',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104223','GCS_NAD_1983_CORS96',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1133','EPSG','1511',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106223','D_NAD_1983_CORS96','NAD 1983 (CORS96)',NULL,'EPSG','7019','EPSG','8901','EPSG','1511',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104223','GCS_NAD_1983_CORS96',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106223','EPSG','1511',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104223','geodetic_crs','EPSG','6783','ESRI'); INSERT INTO "geodetic_datum" VALUES('ESRI','106248','D_MACAO_2008','Macao 2008 (ITRF 2005)',NULL,'EPSG','7022','EPSG','8901','EPSG','1147',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104248','GCS_MACAO_2008',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106248','EPSG','1147',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','1111','D_Nepal_Nagarkot','Nepal Nagarkot',NULL,'EPSG','7015','EPSG','8901','EPSG','1171',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104256','GCS_Nepal_Nagarkot',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1111','EPSG','1171',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106256','D_Nepal_Nagarkot','Nepal Nagarkot',NULL,'EPSG','7015','EPSG','8901','EPSG','1171',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104256','GCS_Nepal_Nagarkot',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106256','EPSG','1171',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104256','geodetic_crs','EPSG','6207','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104257','GCS_ITRF_2008',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1061','EPSG','2830',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','1178','D_ETRF_1989','European Terrestrial Ref. Frame 1989',NULL,'EPSG','7030','EPSG','8901','EPSG','1298',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104258','GCS_ETRF_1989',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1178','EPSG','1298',NULL,0); +INSERT INTO "geodetic_datum" VALUES('ESRI','106258','D_ETRF_1989','European Terrestrial Ref. Frame 1989',NULL,'EPSG','7030','EPSG','8901','EPSG','1298',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104258','GCS_ETRF_1989',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106258','EPSG','1298',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106209','D_NAD_1983_PACP00','NAD 1983 PACP00',NULL,'EPSG','7019','EPSG','8901','EPSG','4162',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104259','GCS_NAD_1983_PACP00',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106209','EPSG','4162',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106210','D_NAD_1983_MARP00','NAD 1983 MARP00',NULL,'EPSG','7019','EPSG','8901','EPSG','4167',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104260','GCS_NAD_1983_MARP00',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106210','EPSG','4167',NULL,0); INSERT INTO "geodetic_crs" VALUES('ESRI','104261','GCS_Merchich_Degree',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6261','EPSG','3280',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','1118','D_NAD_1983_MA11','NAD 1983 (MA11) - Marianas Plate 2011',NULL,'EPSG','7019','EPSG','8901','EPSG','4167',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104286','GCS_NAD_1983_MA11',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1118','EPSG','4167',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106286','D_NAD_1983_MA11','NAD 1983 (MA11) - Marianas Plate 2011',NULL,'EPSG','7019','EPSG','8901','EPSG','4167',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104286','GCS_NAD_1983_MA11',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106286','EPSG','4167',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104286','geodetic_crs','EPSG','6325','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1117','D_NAD_1983_PA11','NAD 1983 (PA11) - Pacific Plate 2011',NULL,'EPSG','7019','EPSG','8901','EPSG','4162',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104287','GCS_NAD_1983_PA11',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1117','EPSG','4162',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106287','D_NAD_1983_PA11','NAD 1983 (PA11) - Pacific Plate 2011',NULL,'EPSG','7019','EPSG','8901','EPSG','4162',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104287','GCS_NAD_1983_PA11',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106287','EPSG','4162',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104287','geodetic_crs','EPSG','6322','ESRI'); INSERT INTO "geodetic_crs" VALUES('ESRI','104304','GCS_Voirol_1875',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6304','EPSG','1365',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104304','geodetic_crs','EPSG','4304','ESRI'); @@ -2177,14 +2177,14 @@ INSERT INTO "geodetic_datum" VALUES('ESRI','106973','4_Vesta_2015','4 Vesta 2015 INSERT INTO "geodetic_crs" VALUES('ESRI','104973','4_Vesta_2015',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106973','EPSG','1262',NULL,0); INSERT INTO "geodetic_datum" VALUES('ESRI','106974','Mercury_2015','Mercury 2015',NULL,'ESRI','107974','ESRI','108900','EPSG','1262',0); INSERT INTO "geodetic_crs" VALUES('ESRI','104974','Mercury_2015',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106974','EPSG','1262',NULL,0); -INSERT INTO "geodetic_datum" VALUES('ESRI','1024','D_Hungarian_Datum_1909','Hungarian Datum 1909',NULL,'EPSG','7004','EPSG','8901','EPSG','1119',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104990','GCS_HD1909',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1024','EPSG','1119',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106990','D_Hungarian_Datum_1909','Hungarian Datum 1909',NULL,'EPSG','7004','EPSG','8901','EPSG','1119',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104990','GCS_HD1909',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106990','EPSG','1119',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104990','geodetic_crs','EPSG','3819','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1029','D_Iraqi_Geospatial_Reference_System','Iraqi Geospatial Reference System',NULL,'EPSG','7019','EPSG','8901','EPSG','1124',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104991','GCS_IGRS',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1029','EPSG','1124',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106991','D_Iraqi_Geospatial_Reference_System','Iraqi Geospatial Reference System',NULL,'EPSG','7019','EPSG','8901','EPSG','1124',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104991','GCS_IGRS',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106991','EPSG','1124',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104991','geodetic_crs','EPSG','3889','ESRI'); -INSERT INTO "geodetic_datum" VALUES('ESRI','1031','D_MGI_1901','MGI 1901',NULL,'EPSG','7004','EPSG','8901','EPSG','2370',1); -INSERT INTO "geodetic_crs" VALUES('ESRI','104992','GCS_MGI_1901',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','1031','EPSG','2370',NULL,1); +INSERT INTO "geodetic_datum" VALUES('ESRI','106992','D_MGI_1901','MGI 1901',NULL,'EPSG','7004','EPSG','8901','EPSG','2370',1); +INSERT INTO "geodetic_crs" VALUES('ESRI','104992','GCS_MGI_1901',NULL,NULL,'geographic 2D','EPSG','6422','ESRI','106992','EPSG','2370',NULL,1); INSERT INTO "supersession" VALUES('geodetic_crs','ESRI','104992','geodetic_crs','EPSG','3906','ESRI'); INSERT INTO alias_name VALUES('projected_crs','EPSG','2000','Anguilla_1957_British_West_Indies_Grid','ESRI'); INSERT INTO alias_name VALUES('projected_crs','EPSG','2001','Antigua_1943_British_West_Indies_Grid','ESRI'); diff --git a/scripts/build_db_from_esri.py b/scripts/build_db_from_esri.py index 4f89f59f..eb02feb6 100755 --- a/scripts/build_db_from_esri.py +++ b/scripts/build_db_from_esri.py @@ -247,7 +247,7 @@ def import_spheroid(): deprecated = 1 if row[idx_deprecated] == 'yes' else 0 map_spheroid_esri_name_to_auth_code[esri_name] = [ - 'ESRI', latestWkid] + 'ESRI', code] if abs(float(a) - 6375000) > 0.01 * 6375000: pos = esri_name.find('_19') @@ -267,7 +267,7 @@ def import_spheroid(): body_code = 'EARTH' sql = """INSERT INTO ellipsoid VALUES('ESRI','%s','%s','%s','%s','%s',%s,'EPSG','9001',%s,NULL,%d);""" % ( - latestWkid, esri_name, description, body_auth, body_code, a, rf, deprecated) + code, esri_name, description, body_auth, body_code, a, rf, deprecated) all_sql.append(sql) ######################## @@ -341,10 +341,10 @@ def import_prime_meridian(): deprecated = 1 if row[idx_deprecated] == 'yes' else 0 - map_pm_esri_name_to_auth_code[esri_name] = ['ESRI', latestWkid] + map_pm_esri_name_to_auth_code[esri_name] = ['ESRI', code] sql = """INSERT INTO "prime_meridian" VALUES('ESRI','%s','%s',%s,'EPSG','9110',%d);""" % ( - latestWkid, esri_name, value, deprecated) + code, esri_name, value, deprecated) all_sql.append(sql) @@ -411,7 +411,7 @@ def import_datum(): assert authority.upper() == 'ESRI', row map_datum_esri_name_to_auth_code[esri_name] = [ - 'ESRI', latestWkid] + 'ESRI', code] wkt = row[idx_wkt] pos = wkt.find('SPHEROID["') @@ -429,7 +429,7 @@ def import_datum(): description = row[idx_description] deprecated = 1 if row[idx_deprecated] == 'yes' else 0 - map_datum_esri_to_parameters[latestWkid] = { + map_datum_esri_to_parameters[code] = { 'esri_name': esri_name, 'description': description, 'ellps_auth_name': ellps_auth_name, |