diff options
Diffstat (limited to 'data/sql')
| -rw-r--r-- | data/sql/alias_name.sql | 321 | ||||
| -rw-r--r-- | data/sql/area.sql | 46 | ||||
| -rw-r--r-- | data/sql/compound_crs.sql | 24 | ||||
| -rw-r--r-- | data/sql/deprecation.sql | 7 | ||||
| -rw-r--r-- | data/sql/geodetic_crs.sql | 5 | ||||
| -rw-r--r-- | data/sql/geodetic_datum.sql | 1 | ||||
| -rw-r--r-- | data/sql/grid_transformation.sql | 13 | ||||
| -rw-r--r-- | data/sql/grid_transformation_custom.sql | 10 | ||||
| -rw-r--r-- | data/sql/helmert_transformation.sql | 3 | ||||
| -rw-r--r-- | data/sql/metadata.sql | 4 | ||||
| -rw-r--r-- | data/sql/projected_crs.sql | 32 | ||||
| -rw-r--r-- | data/sql/vertical_crs.sql | 4 | ||||
| -rw-r--r-- | data/sql/vertical_datum.sql | 4 |
13 files changed, 101 insertions, 373 deletions
diff --git a/data/sql/alias_name.sql b/data/sql/alias_name.sql index 74002e04..362be71b 100644 --- a/data/sql/alias_name.sql +++ b/data/sql/alias_name.sql @@ -482,6 +482,7 @@ INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1260','SRVN16','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6160','Quiñi-Huao','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1261','EVRF2000 Austria','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1262','SA LLD','EPSG'); +INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1263','ONGD17','EPSG'); INSERT INTO "alias_name" VALUES('vertical_datum','EPSG','1269','KSA-VRF14','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1268','KSA-GRF17','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1042','Red Geodesica Nacional 1992','EPSG'); @@ -600,18 +601,7 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','21150','Genuk / UTM zone INSERT INTO "alias_name" VALUES('projected_crs','EPSG','22700','Levant / Levant Zone','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','22770','Levant / Syria Lambert','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','22780','Levant / Levant Stereo','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25828','ETRF89 / UTM zone 28N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25829','ETRF89 / UTM zone 29N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25830','ETRF89 / UTM zone 30N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25831','ETRF89 / UTM zone 31N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25832','ETRF89 / UTM zone 32N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25833','ETRF89 / UTM zone 33N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25834','ETRF89 / UTM zone 34N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25835','ETRF89 / UTM zone 35N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25836','ETRF89 / UTM zone 36N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25837','ETRF89 / UTM zone 37N','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25838','ETRF89 / UTM zone 38N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','25884','ETRF89 / TM Baltic93','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','27258','GD49 / UTM zone 58','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','27259','GD49 / UTM zone 59','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','27260','GD49 / UTM zone 60','EPSG'); @@ -1107,7 +1097,6 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2167','Pulkovo 1942(83) INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4181','LUREF','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6791','NAD83(2011) / OCRS_BKF (ft)','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8233','NAD83(CSRS98)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2180','EUREF89 / CS92','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','3906','HR1901','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6795','NAD83(2011) / OCRS_BRP (ft)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6794','NAD83(2011) / OCRS_BRP (m)','EPSG'); @@ -1127,11 +1116,8 @@ INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4176','AAD98','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2193','NZGD2000 / NZTM','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6802','NAD83(2011) / OCRS_CGP (m)','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4300','1975 Mapping Adjustment','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2196','EUREF89 / Kp2000 Jutland','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2196','System 2000 Jylland zoner','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2197','EUREF89 / Kp2000 Zealand','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2197','System 2000 Sjaelland zoner','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2198','EUREF89 / Kp2000 Bornholm','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2198','System 2000 Bornholm zoner','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6807','NAD83(2011) / OCRS_CRE (ft)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6810','NAD83(2011) / OCRS_CRW (m)','EPSG'); @@ -1920,12 +1906,9 @@ INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5794','IGN 1955 height',' INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5795','IGN 1951 height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3106','Gulshan / Bangladesh TM','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3108','ETRS89 / New Guernsey Grid','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3109','ETRF89 / Jersey Transverse Mercator','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3109','ETRS89 / JTM','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3109','ETRF89 / JTM','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5713','CVD28 height','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5713','Canadian Vertical Datum of 1928 height','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3108','ETRF89 / Guernsey Grid','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6879','NAD83(2011) / WI C (m)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3110','Vicgrid','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4994','New Luzon','EPSG'); @@ -2241,11 +2224,6 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3404','NAD83(HPGN) / Nor INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3414','SVY21 plane coordinate system','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3174','NAD83 / GLGIS Albers (basin)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3175','NAD83 / GLGIS Albers (basin+SLS)','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7416','EUREF89 / UTM zone 32N + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7417','EUREF89 / UTM zone 33N + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7418','EUREF89 / Kp2000 Jutland + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7419','EUREF89 / Kp2000 Zealand + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7420','EUREF89 / Kp2000 Bornholm + DVR90 height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3415','WGS 72BE / SCS Lambert','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3425','NAD83(HPGN) / Iowa North (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3426','NAD83(HPGN) / Iowa South (ftUS)','EPSG'); @@ -2403,55 +2381,11 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3568','NAD83(HPGN) / Uta INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3569','NAD83(HPGN) / Utah Central (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3570','NAD83(HPGN) / Utah South (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3448','JAD2001 / Jamaica Metric Grid 2001','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3416','ETRF89 / Austria Lambert','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2176','ETRF89 / Poland CS2000 zone 5','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2177','ETRF89 / Poland CS2000 zone 6','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2178','ETRF89 / Poland CS2000 zone 7','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2179','ETRF89 / Poland CS2000 zone 8','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2180','ETRF89 / Poland CS92','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2196','ETRF89 / Kp2000 Jutland','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2197','ETRF89 / Kp2000 Zealand','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2198','ETRF89 / Kp2000 Bornholm','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2213','ETRF89 / TM 30 NE','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3034','ETRF89 / LCC','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3035','ETRF89 / LAEA','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3038','ETRF89 / TM26','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3039','ETRF89 / TM27','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3040','ETRF89 / UTM zone 28N (N-E)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3041','ETRF89 / UTM zone 29N (N-E)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3042','ETRF89 / UTM zone 30N (N-E)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3043','ETRF89 / UTM zone 31N (N-E)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3044','ETRF89 / UTM zone 32N (N-E)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3045','ETRF89 / UTM zone 33N (N-E)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3046','ETRF89 / UTM zone 34N (N-E)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3047','ETRF89 / UTM zone 35N (N-E)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3048','ETRF89 / UTM zone 36N (N-E)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3049','ETRF89 / UTM zone 37N (N-E)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3050','ETRF89 / TM38','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3051','ETRF89 / TM39','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3067','ETRF89 / TM35FIN(E,N)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3126','ETRF89 / ETRS-GK19FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3127','ETRF89 / ETRS-GK20FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3128','ETRF89 / ETRS-GK21FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3129','ETRF89 / ETRS-GK22FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3130','ETRF89 / ETRS-GK23FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3131','ETRF89 / ETRS-GK24FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3132','ETRF89 / ETRS-GK25FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3133','ETRF89 / ETRS-GK26FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3134','ETRF89 / ETRS-GK27FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3135','ETRF89 / ETRS-GK28FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3136','ETRF89 / ETRS-GK29FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3137','ETRF89 / ETRS-GK30FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3138','ETRF89 / ETRS-GK31FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3145','ETRF89 / Faroe Lambert','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3447','ETRF89 / Belgian Lambert 2005','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7409','ETRF89 + EVRF2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7416','ETRF89 / UTM zone 32N + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7417','ETRF89 / UTM zone 33N + DVR90 height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6922','NAD83 / Kansas LCC (m)','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7418','ETRF89 / Kp2000 Jutland + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7419','ETRF89 / Kp2000 Zealand + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7420','ETRF89 / Kp2000 Bornholm + DVR90 height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6924','NAD83(2011) / Kansas LCC (m)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3396','PD/83 / Gauss-Kruger zone 3','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3463','Maine Coordinate System of 2000 Central Zone','EPSG'); @@ -2616,7 +2550,6 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3546','KY1Z','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3547','NAD83(NSRS) / KY1Z (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3547','KY1Z','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3447','BE_ETRS89 / LB05','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3763','ETRF89 / Portugal TM06','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3765','HTRS96 / TM','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3766','HTRS96 / LCC','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3770','BNG2000','EPSG'); @@ -2761,7 +2694,6 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','26862','NAD83(HPGN) / We INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3800','NAD27 / Alberta 3TM ref merid 120','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3801','NAD83 / Alberta 3TM ref merid 120','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3802','NAD83(CSRS) / Alberta 3TM ref merid 120','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3812','ETRF89 / Belgian Lambert 2008','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3812','ETRS89 / Lambert 2008','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3814','NAD83 / MSTM','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3815','NAD83(HARN) / MSTM','EPSG'); @@ -4270,7 +4202,6 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3085','NAD83(HARN) / TX INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3091','KY1Z','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3090','NAD83(HARN) / KY1Z','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3088','NAD83 / KY1Z (m)','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7423','ETRF89 + EVRF2007 height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3857','WGS 84 / Popular Visualisation Pseudo-Mercator','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','3886','National Elevation Network height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3893','ED50 / Iraq Nat. Grid','EPSG'); @@ -4774,15 +4705,7 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7631','WISCRS Sauk (ftUS INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7617','WISCRS Lincoln (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7638','WISCRS Vilas (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7618','WISCRS Marathon (ftUS)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4093','ETRF89 / DKTM1','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4093','EUREF89 / DKTM1','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7639','WISCRS Walworth (ftUS)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4094','ETRF89 / DKTM2','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4094','EUREF89 / DKTM2','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4095','ETRF89 / DKTM3','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4095','EUREF89 / DKTM3','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4096','ETRF89 / DKTM4','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4096','EUREF89 / DKTM4','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7640','WISCRS Washburn (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7641','WISCRS Washington (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7642','WISCRS Waukesha (ftUS)','EPSG'); @@ -4791,14 +4714,6 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7644','WISCRS Waushara ( INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7645','WISCRS Wood (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6316','Macedonia State Coordinate System zone 7','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3857','Web Mercator','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','4099','ETRF89 / DKTM3 + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','4099','EUREF89 / DKTM3 + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','4097','ETRF89 / DKTM1 + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','4097','EUREF89 / DKTM1 + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','4098','ETRF89 / DKTM2 + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','4098','EUREF89 / DKTM2 + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','4100','ETRF89 / DKTM4 + DVR90 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','4100','EUREF89 / DKTM4 + DVR90 height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7692','Kyrg06-68','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7693','Kyrg06-71','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7694','Kyrg06-74','EPSG'); @@ -6092,6 +6007,7 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9285','Pampa del Castill INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4289','RD-Bessel','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4776','New Beijing / 3GK zone 40','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4777','New Beijing / 3GK zone 41','EPSG'); +INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9311','US National Atlas EA','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','31289','MGI (Ferro) / M31','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','31290','MGI (Ferro) / M34','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','31288','MGI (Ferro) / M28','EPSG'); @@ -6250,48 +6166,35 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5018','Lisbon 1937 / Por INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2083','Hito XVIII / Argentina 2','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2081','Chos Malal / Argentina 2','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2393','YKG','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7405','OSGB36 / British National Grid + ODN height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','7405','OSGB 1936 / British National Grid + Newlyn height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3067','ETRS89 / TM35FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3067','ETRS89-TM35FIN(E,N)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3067','ETRS-TM35FIN(E,N)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3873','ETRF89 / GK19FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3873','ETRS89-GK19FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3873','ETRS-GK19FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3874','ETRF89 / GK20FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3874','ETRS89-GK20FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3874','ETRS-GK20FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3875','ETRS89-GK21FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3875','ETRF89 / GK21FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3875','ETRS-GK21FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3876','ETRF89 / GK22FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3876','ETRS89-GK22FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3876','ETRS-GK22FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3877','ETRF89 / GK23FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3877','ETRS89-GK23FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3877','ETRS-GK23FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3878','ETRF89 / GK24FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3878','ETRS89-GK24FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3878','ETRS-GK24FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3879','ETRS89-GK25FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3879','ETRF89 / GK25FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3879','ETRS-GK25FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3880','ETRF89 / GK26FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3880','ETRS89-GK26FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3880','ETRS-GK26FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3881','ETRF89 / GK27FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3881','ETRS89-GK27FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3881','ETRS-GK27FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3882','ETRF89 / GK28FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3882','ETRS89-GK28FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3882','ETRS-GK28FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3883','ETRF89 / GK29FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3883','ETRS89-GK29FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3883','ETRS-GK29FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3884','ETRF89 / GK30FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3884','ETRS89-GK30FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3884','ETRS-GK30FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3885','ETRS-GK31FIN','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3885','ETRF89 / GK31FIN','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3885','ETRS89-GK31FIN','EPSG'); INSERT INTO "alias_name" VALUES('compound_crs','EPSG','3903','ETRS-TM35FIN(N,E)/N2000','EPSG'); INSERT INTO "alias_name" VALUES('compound_crs','EPSG','3903','ETRS89-TM35FIN(N,E)/N2000','EPSG'); @@ -6299,63 +6202,10 @@ INSERT INTO "alias_name" VALUES('compound_crs','EPSG','3901','YKJ/N60','EPSG'); INSERT INTO "alias_name" VALUES('compound_crs','EPSG','3901','YKJ + N60 height','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','3900','N2000','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5717','N60','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5048','ETRF89 / TM35FIN(N,E)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5048','ETRS89-TM35FIN(N,E)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5048','ETRS-TM35FIN(N,E)','EPSG'); INSERT INTO "alias_name" VALUES('compound_crs','EPSG','3902','ETRS89-TM35FIN(N,E)/N60','EPSG'); INSERT INTO "alias_name" VALUES('compound_crs','EPSG','3902','ETRS-TM35FIN(N,E)/N60','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5120','ETRF89 / NTM zone 20','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5120','EUREF89 / NTM zone 20','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5123','ETRF89 / NTM zone 23','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5123','EUREF89 / NTM zone 23','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5124','ETRF89 / NTM zone 24','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5124','EUREF89 / NTM zone 24','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5125','ETRF89 / NTM zone 25','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5125','EUREF89 / NTM zone 25','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5126','ETRF89 / NTM zone 26','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5126','EUREF89 / NTM zone 26','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5129','ETRF89 / NTM zone 29','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5129','EUREF89 / NTM zone 29','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5130','ETRF89 / NTM zone 30','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5130','EUREF89 / NTM zone 30','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5105','ETRF89 / NTM zone 5','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5105','EUREF89 / NTM zone 5','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5106','ETRF89 / NTM zone 6','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5106','EUREF89 / NTM zone 6','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5107','ETRF89 / NTM zone 7','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5107','EUREF89 / NTM zone 7','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5108','ETRF89 / NTM zone 8','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5108','EUREF89 / NTM zone 8','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5109','ETRF89 / NTM zone 9','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5109','EUREF89 / NTM zone 9','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5110','ETRF89 / NTM zone 10','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5110','EUREF89 / NTM zone 10','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5111','ETRF89 / NTM zone 11','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5111','EUREF89 / NTM zone 11','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5112','ETRF89 / NTM zone 12','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5112','EUREF89 / NTM zone 12','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5113','ETRF89 / NTM zone 13','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5113','EUREF89 / NTM zone 13','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5114','ETRF89 / NTM zone 14','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5114','EUREF89 / NTM zone 14','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5115','ETRF89 / NTM zone 15','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5115','EUREF89 / NTM zone 15','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5116','ETRF89 / NTM zone 16','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5116','EUREF89 / NTM zone 16','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5117','ETRF89 / NTM zone 17','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5117','EUREF89 / NTM zone 17','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5118','ETRF89 / NTM zone 18','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5118','EUREF89 / NTM zone 18','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5119','ETRF89 / NTM zone 19','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5119','EUREF89 / NTM zone 19','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5121','ETRF89 / NTM zone 21','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5121','EUREF89 / NTM zone 21','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5122','ETRF89 / NTM zone 22','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5122','EUREF89 / NTM zone 22','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5127','ETRF89 / NTM zone 27','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5127','EUREF89 / NTM zone 27','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5128','ETRF89 / NTM zone 28','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5128','EUREF89 / NTM zone 28','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5781','RO_CONST / NH','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5705','LT_KRON / NH','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5181','Korea 2000 / Central','EPSG'); @@ -6554,7 +6404,6 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5596','FCS','EPSG'); INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5598','FCS + FCSVR10 height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5624','NAD27 / Michigan Old Cen','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3040','ETRS89 / TM28','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4647','ETRF89 / UTM zone 32N (zE-N)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5646','NAD83 / VT (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5654','NAD83(HPGN) / Vermont (ftUS)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5654','NAD83(HARN) / VT (ftUS)','EPSG'); @@ -6649,16 +6498,10 @@ INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5862','Lower Low Water La INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5874','High Tide height','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5873','Low Tide depth','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5649','ETRS89 / UTM zone 31','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5649','ETRF89 / UTM zone 31N (zE-N)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5651','ETRS89 / UTM zone 31','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5651','ETRF89 / UTM zone 31N (N-zE)','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5652','ETRF89 / UTM zone 32N (N-zE)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5652','ETRS89 / UTM zone 32N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5650','ETRF89 / UTM zone 33N (zE-N)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5650','ETRS89 / UTM zone 33N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5653','ETRF89 / UTM zone 33N (N-zE)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5653','ETRS89 / UTM zone 33N','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','4839','ETRF89 / LCC Germany (N-E)','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5879','Cadastre 1997 / UTM 38S','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5887','TGD2005 / TMG','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5890','JAXA Snow Depth PS North','EPSG'); @@ -6682,68 +6525,12 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5938','WGS 84 / EPSG Gre INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5939','WGS 84 / EPSG Norway PS','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5940','WGS 84 / EPSG Russia PS','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','5930','WGS 84 / EPSG Arctic B5','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5945','ETRF89 / NTM zone 5 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5945','EUREF89 / NTM zone 5 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5946','ETRF89 / NTM zone 6 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5946','EUREF89 / NTM zone 6 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5947','ETRF89 / NTM zone 7 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5947','EUREF89 / NTM zone 7 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5949','ETRF89 / NTM zone 9 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5949','EUREF89 / NTM zone 9 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5950','ETRF89 / NTM zone 10 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5950','EUREF89 / NTM zone 10 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5951','ETRF89 / NTM zone 11 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5951','EUREF89 / NTM zone 11 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5952','ETRF89 / NTM zone 12 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5952','EUREF89 / NTM zone 12 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5953','ETRF89 / NTM zone 13 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5953','EUREF89 / NTM zone 13 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5954','ETRF89 / NTM zone 14 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5954','EUREF89 / NTM zone 14 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5955','ETRF89 / NTM zone 15 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5955','EUREF89 / NTM zone 15 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5956','ETRF89 / NTM zone 16 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5956','EUREF89 / NTM zone 16 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5957','ETRF89 / NTM zone 17 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5957','EUREF89 / NTM zone 17 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5958','ETRF89 / NTM zone 18 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5958','EUREF89 / NTM zone 18 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5959','ETRF89 / NTM zone 19 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5959','EUREF89 / NTM zone 19 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5960','ETRF89 / NTM zone 20 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5960','EUREF89 / NTM zone 20 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5961','ETRF89 / NTM zone 21 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5961','EUREF89 / NTM zone 21 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5962','ETRF89 / NTM zone 22 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5962','EUREF89 / NTM zone 22 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5963','ETRF89 / NTM zone 23 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5963','EUREF89 / NTM zone 23 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5964','ETRF89 / NTM zone 24 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5964','EUREF89 / NTM zone 24 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5965','ETRF89 / NTM zone 25 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5965','EUREF89 / NTM zone 25 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5967','ETRF89 / NTM zone 27 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5967','EUREF89 / NTM zone 27 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5966','ETRF89 / NTM zone 26 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5966','EUREF89 / NTM zone 26 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5968','ETRF89 / NTM zone 28 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5968','EUREF89 / NTM zone 28 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5969','ETRF89 / NTM zone 29 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5969','EUREF89 / NTM zone 29 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5970','ETRF89 / NTM zone 30 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5970','EUREF89 / NTM zone 30 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5973','ETRF89 / UTM zone 33 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5973','EUREF89 / UTM zone 33 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5975','ETRF89 / UTM zone 35 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5975','EUREF89 / UTM zone 35 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5974','ETRF89 / UTM zone 34 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5974','EUREF89 / UTM zone 34 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5976','ETRF89 / UTM zone 36 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5976','EUREF89 / UTM zone 36 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5972','ETRF89 / UTM zone 32 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5972','EUREF89 / UTM zone 32 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5971','ETRF89 / UTM zone 31 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5971','EUREF89 / UTM zone 31 + NN2000 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5973','ETRS89 / UTM zone 33 + NN2000 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5975','ETRS89 / UTM zone 35 + NN2000 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5974','ETRS89 / UTM zone 34 + NN2000 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5976','ETRS89 / UTM zone 36 + NN2000 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5972','ETRS89 / UTM zone 32 + NN2000 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5971','ETRS89 / UTM zone 31 + NN2000 height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6050','GR96 / EPSG Arctic 1-25','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6051','GR96 / EPSG Arctic 2-18','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6052','GR96 / EPSG Arctic 2-20','EPSG'); @@ -6759,25 +6546,15 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6063','GR96 / EPSG Arcti INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6067','GR96 / EPSG Arctic 8-20','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6068','GR96 / EPSG Arctic 8-22','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6070','ETRS89 / EPSG Arctic 3-11','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6070','EUREF89 / EPSG Arctic zone 3-11','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6070','ETRF89 / EPSG Arctic zone 3-11','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6071','ETRS89 / EPSG Arctic 4-26','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6071','EUREF89 / EPSG Arctic zone 4-26','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6071','ETRF89 / EPSG Arctic zone 4-26','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6073','ETRS89 / EPSG Arctic 5-11','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6073','EUREF89 / EPSG Arctic zone 5-11','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6073','ETRF89 / EPSG Arctic zone 5-11','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6074','ETRS89 / EPSG Arctic 5-13','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6074','EUREF89 / EPSG Arctic zone 5-13','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6074','ETRF89 / EPSG Arctic zone 5-13','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6075','WGS 84 / EPSG Arctic 2-24','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6076','WGS 84 / EPSG Arctic 2-26','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6077','WGS 84 / EPSG Arctic 3-13','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6078','WGS 84 / EPSG Arctic 3-15','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6079','WGS 84 / EPSG Arctic 3-17','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6069','ETRS89 / EPSG Arctic 2-22','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6069','EUREF89 / EPSG Arctic zone 2-22','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6069','ETRF89 / EPSG Arctic zone 2-22','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6080','WGS 84 / EPSG Arctic 3-19','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6087','WGS 84 / EPSG Arctic 5-15','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6088','WGS 84 / EPSG Arctic 5-17','EPSG'); @@ -6826,86 +6603,18 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6083','WGS 84 / EPSG Arc INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6082','WGS 84 / EPSG Arctic 4-32','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6081','WGS 84 / EPSG Arctic 4-30','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6124','WGS 84 / EPSG Arctic 4-12','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5948','ETRF89 / NTM zone 8 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5948','EUREF89 / NTM zone 8 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6125','ETRF89 / EPSG Arctic zone 5-47','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6125','ETRS89 / EPSG Arctic 5-47','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6125','EUREF89 / EPSG Arctic zone 5-47','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6072','ETRS89 / EPSG Arctic 4-28','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6072','EUREF89 / EPSG Arctic zone 4-28','EPSG'); -INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6072','ETRF89 / EPSG Arctic zone 4-28','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6104','NAD83(CSRS) / EPSG Arctic 4-14','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6141','CING11','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4723','Grand Cayman 1959','EPSG'); INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4726','Little Cayman 1961','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5942','ETRF89 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5942','EUREF89 + NN2000 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6147','ETRF89 / NTM zone 7 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6147','EUREF89 / NTM zone 7 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6148','ETRF89 / NTM zone 8 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6148','EUREF89 / NTM zone 8 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6149','ETRF89 / NTM zone 9 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6149','EUREF89 / NTM zone 9 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6146','ETRF89 / NTM zone 6 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6146','EUREF89 / NTM zone 6 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6145','ETRF89 / NTM zone 5 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6145','EUREF89 / NTM zone 5 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6170','ETRF89 / NTM zone 30 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6170','EUREF89 / NTM zone 30 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6169','ETRF89 / NTM zone 29 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6169','EUREF89 / NTM zone 29 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6168','ETRF89 / NTM zone 28 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6168','EUREF89 / NTM zone 28 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6167','ETRF89 / NTM zone 27 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6167','EUREF89 / NTM zone 27 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6166','ETRF89 / NTM zone 26 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6166','EUREF89 / NTM zone 26 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6165','ETRF89 / NTM zone 25 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6165','EUREF89 / NTM zone 25 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6164','ETRF89 / NTM zone 24 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6164','EUREF89 / NTM zone 24 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6163','ETRF89 / NTM zone 23 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6163','EUREF89 / NTM zone 23 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6162','ETRF89 / NTM zone 22 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6162','EUREF89 / NTM zone 22 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6161','ETRF89 / NTM zone 21 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6161','EUREF89 / NTM zone 21 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6160','ETRF89 / NTM zone 20 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6160','EUREF89 / NTM zone 20 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6159','ETRF89 / NTM zone 19 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6159','EUREF89 / NTM zone 19 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6158','ETRF89 / NTM zone 18 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6158','EUREF89 / NTM zone 18 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6157','ETRF89 / NTM zone 17 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6157','EUREF89 / NTM zone 17 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6156','ETRF89 / NTM zone 16 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6156','EUREF89 / NTM zone 16 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6155','ETRF89 / NTM zone 15 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6155','EUREF89 / NTM zone 15 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6154','ETRF89 / NTM zone 14 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6154','EUREF89 / NTM zone 14 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6153','ETRF89 / NTM zone 13 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6153','EUREF89 / NTM zone 13 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6152','ETRF89 / NTM zone 12 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6152','EUREF89 / NTM zone 12 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6151','ETRF89 / NTM zone 11 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6151','EUREF89 / NTM zone 11 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6150','ETRF89 / NTM zone 10 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6150','EUREF89 / NTM zone 10 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6171','ETRF89 / UTM zone 31 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6171','EUREF89 / UTM zone 31 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6172','ETRF89 / UTM zone 32 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6172','EUREF89 / UTM zone 32 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6173','ETRF89 / UTM zone 33 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6173','EUREF89 / UTM zone 33 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6174','ETRF89 / UTM zone 34 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6174','EUREF89 / UTM zone 34 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6175','ETRF89 / UTM zone 35 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6175','EUREF89 / UTM zone 35 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6176','ETRF89 / UTM zone 36 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6176','EUREF89 / UTM zone 36 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6144','ETRF89 + NN54 height','EPSG'); -INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6144','EUREF89 + NN54 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6171','ETRS89 / UTM zone 31 + NN54 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6172','ETRS89 / UTM zone 32 + NN54 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6173','ETRS89 / UTM zone 33 + NN54 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6174','ETRS89 / UTM zone 34 + NN54 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6175','ETRS89 / UTM zone 35 + NN54 height','EPSG'); +INSERT INTO "alias_name" VALUES('compound_crs','EPSG','6176','ETRS89 / UTM zone 36 + NN54 height','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5710','BE_OOST / UNCOR','EPSG'); INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','5710','Oostende height','EPSG'); INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6057','GR96 / EPSG Arctic 4-22','EPSG'); diff --git a/data/sql/area.sql b/data/sql/area.sql index 0e4f7ce5..40ead5de 100644 --- a/data/sql/area.sql +++ b/data/sql/area.sql @@ -73,7 +73,7 @@ INSERT INTO "area" VALUES('EPSG','1093','Faroe Islands','Faroe Islands - onshore INSERT INTO "area" VALUES('EPSG','1094','Fiji - onshore','Fiji - onshore. Includes Viti Levu, Vanua Levu, Taveuni, the Yasawa Group, the Kadavu Group, the Lau Islands and Rotuma Islands.',-20.81,-12.42,176.81,-178.15,0); INSERT INTO "area" VALUES('EPSG','1095','Finland','Finland - onshore and offshore.',58.84,70.09,19.08,31.59,0); INSERT INTO "area" VALUES('EPSG','1096','France','France - onshore and offshore, mainland and Corsica.',41.15,51.56,-9.86,10.38,0); -INSERT INTO "area" VALUES('EPSG','1097','French Guiana','French Guiana - onshore and offshore.',2.11,8.88,-54.6,-49.46,0); +INSERT INTO "area" VALUES('EPSG','1097','French Guiana','French Guiana - onshore and offshore.',2.11,8.88,-54.61,-49.45,0); INSERT INTO "area" VALUES('EPSG','1098','French Polynesia','French Polynesia - onshore and offshore. Includes Society archipelago, Tuamotu archipelago, Marquesas Islands, Gambier Islands and Austral Islands.',-31.24,-4.52,-158.13,-131.97,0); INSERT INTO "area" VALUES('EPSG','1099','French Southern Territories','French Southern Territories - onshore and offshore. Includes Amsterdam and St Paul, Bassas da India, Crozet, Europa, Glorieuses, Juan de Nova, Kerguelen and Tromelin.',-53.24,-10.65,37.55,81.83,0); INSERT INTO "area" VALUES('EPSG','1100','Gabon','Gabon - onshore and offshore.',-6.37,2.32,7.03,14.52,0); @@ -182,7 +182,7 @@ INSERT INTO "area" VALUES('EPSG','1202','St Vincent and the Grenadines','St Vinc INSERT INTO "area" VALUES('EPSG','1203','Samoa','Samoa - onshore and offshore.',-15.84,-10.94,-174.54,-170.51,0); INSERT INTO "area" VALUES('EPSG','1204','San Marino','San Marino.',43.89,43.99,12.4,12.52,0); INSERT INTO "area" VALUES('EPSG','1205','Sao Tome and Principe','Sao Tome and Principe - onshore and offshore.',-1.49,2.72,3.2,8.56,0); -INSERT INTO "area" VALUES('EPSG','1206','Saudi Arabia','Saudi Arabia - onshore and offshore.',15.61,32.16,34.44,55.67,0); +INSERT INTO "area" VALUES('EPSG','1206','Saudi Arabia','Saudi Arabia - onshore and offshore.',16.29,32.16,34.44,55.67,0); INSERT INTO "area" VALUES('EPSG','1207','Senegal','Senegal - onshore and offshore.',10.64,16.7,-20.22,-11.36,0); INSERT INTO "area" VALUES('EPSG','1208','Seychelles','Seychelles - onshore and offshore - Alphonse, Bijoutier, St Francois Islands, St Pierre islet, Cosmoledo Islands, Amirantes, Aldabra, Farquhar, and Desroches.',-12.72,-0.37,43.19,59.66,0); INSERT INTO "area" VALUES('EPSG','1209','Sierra Leone','Sierra Leone - onshore and offshore.',4.22,10.0,-16.57,-10.26,0); @@ -248,7 +248,7 @@ INSERT INTO "area" VALUES('EPSG','1268','Venezuela - Falcon state','Venezuela - INSERT INTO "area" VALUES('EPSG','1269','Venezuela - Pedregal area of Falcon state','Venezuela - Pedregal area of Falcon state.',10.8,11.26,-70.4,-69.69,0); INSERT INTO "area" VALUES('EPSG','1270','Venezuela - Maracaibo south','Venezuela - south Maracaibo area.',8.72,10.01,-72.4,-70.78,0); INSERT INTO "area" VALUES('EPSG','1271','Africa - Eritrea, Ethiopia, South Sudan and Sudan','Eritrea; Ethiopia; South Sudan; Sudan.',3.4,22.24,21.82,47.99,0); -INSERT INTO "area" VALUES('EPSG','1272','Asia - Middle East - Bahrain, Kuwait and Saudi Arabia','Bahrain, Kuwait and Saudi Arabia - onshore.',15.61,32.16,34.51,55.67,0); +INSERT INTO "area" VALUES('EPSG','1272','Asia - Middle East - Bahrain, Kuwait and Saudi Arabia','Bahrain, Kuwait and Saudi Arabia - onshore.',16.37,32.16,34.51,55.67,0); INSERT INTO "area" VALUES('EPSG','1273','Antigua - onshore','Antigua island - onshore.',16.94,17.22,-61.95,-61.61,0); INSERT INTO "area" VALUES('EPSG','1274','Brazil - Aratu','Brazil - offshore south and east of a line intersecting the coast at 2°55''S; onshore Tucano basin.',-35.71,4.26,-53.38,-26.0,0); INSERT INTO "area" VALUES('EPSG','1275','Netherlands - onshore','Netherlands - onshore, including Waddenzee, Dutch Wadden Islands and 12-mile offshore coastal zone.',50.75,53.7,3.2,7.22,0); @@ -274,7 +274,7 @@ INSERT INTO "area" VALUES('EPSG','1294','Portugal - mainland - onshore','Portuga INSERT INTO "area" VALUES('EPSG','1295','Germany - DHDN','Germany - onshore - Baden-Wurtemberg, Bayern, Hessen, Niedersachsen, Nordrhein-Westfalen, Rheinland-Pfalz, Saarland, Schleswig-Holstein. Also former DDR states of Sachsen and Thuringen by transformation.',47.27,55.06,5.87,15.03,1); INSERT INTO "area" VALUES('EPSG','1296','Europe - ED50 by country','Europe - west: Andorra; Cyprus; Denmark - onshore and offshore; Faroe Islands - onshore; France - offshore; Germany - offshore North Sea; Gibraltar; Greece - offshore; Israel - offshore; Italy including San Marino and Vatican City State; Ireland offshore; Malta; Netherlands - offshore; North Sea; Norway including Svalbard - onshore and offshore; Portugal - mainland - offshore; Spain - onshore; Turkey - onshore and offshore; United Kingdom UKCS offshore east of 6°W including Channel Islands (Guernsey and Jersey). Egypt - Western Desert; Iraq - onshore; Jordan.',25.71,84.17,-16.1,48.61,0); INSERT INTO "area" VALUES('EPSG','1297','Europe - west','Europe - west.',34.88,84.17,-10.56,39.65,0); -INSERT INTO "area" VALUES('EPSG','1298','Europe - ETRS89','Europe - onshore and offshore: Albania; Andorra; Austria; Belgium; Bosnia and Herzegovina; Bulgaria; Croatia; Cyprus; Czechia; Denmark; Estonia; Faroe Islands; Finland; France; Germany; Gibraltar; Greece; Hungary; Ireland; Italy; Kosovo; Latvia; Liechtenstein; Lithuania; Luxembourg; Malta; Moldova; Monaco; Montenegro; Netherlands; North Macedonia; Norway including Svalbard and Jan Mayen; Poland; Portugal; Romania; San Marino; Serbia; Slovakia; Slovenia; Spain; Sweden; Switzerland; United Kingdom (UK) including Channel Islands and Isle of Man; Vatican City State.',32.88,84.17,-16.1,40.18,0); +INSERT INTO "area" VALUES('EPSG','1298','Europe - ETRF by country','Europe - onshore and offshore: Albania; Andorra; Austria; Belgium; Bosnia and Herzegovina; Bulgaria; Croatia; Cyprus; Czechia; Denmark; Estonia; Faroe Islands; Finland; France; Germany; Gibraltar; Greece; Hungary; Ireland; Italy; Kosovo; Latvia; Liechtenstein; Lithuania; Luxembourg; Malta; Moldova; Monaco; Montenegro; Netherlands; North Macedonia; Norway including Svalbard and Jan Mayen; Poland; Portugal; Romania; San Marino; Serbia; Slovakia; Slovenia; Spain; Sweden; Switzerland; United Kingdom (UK) including Channel Islands and Isle of Man; Vatican City State.',32.88,84.17,-16.1,40.18,0); INSERT INTO "area" VALUES('EPSG','1299','Europe - EVRF2000','Europe - onshore - Andorra; Austria; Belgium; Bosnia and Herzegovina; Croatia; Czechia; Denmark; Estonia; Finland; France - mainland; Germany; Gibraltar; Hungary; Italy - mainland and Sicily; Latvia; Liechtenstein; Lithuania; Luxembourg; Netherlands; Norway; Poland; Portugal - mainland; Romania; San Marino; Slovakia; Slovenia; Spain - mainland; Sweden; Switzerland; United Kingdom (UK) - Great Britain mainland; Vatican City State.',35.95,71.21,-9.56,31.59,0); INSERT INTO "area" VALUES('EPSG','1300','Iran - FD58','Iran - Arwaz area and onshore Gulf coast west of 54°E, Lavan Island, offshore Balal field and South Pars blocks 2 and 3.',26.21,33.22,47.13,53.61,0); INSERT INTO "area" VALUES('EPSG','1301','Portugal - Azores C - onshore','Portugal - central Azores onshore - Faial, Graciosa, Pico, Sao Jorge, Terceira.',38.32,39.14,-28.9,-26.97,0); @@ -415,7 +415,7 @@ INSERT INTO "area" VALUES('EPSG','1435','Canada - Ontario - 88.5°W to 85.5°W', INSERT INTO "area" VALUES('EPSG','1436','Canada - Ontario - 91.5°W to 88.5°W','Canada - Ontario - between 91°30''W and 88°30''W.',47.97,56.9,-91.5,-88.5,0); INSERT INTO "area" VALUES('EPSG','1437','Canada - Ontario - 94.5°W to 91.5°W','Canada - Ontario - between 94°30''W and 91°30''W.',48.06,55.2,-94.5,-91.5,0); INSERT INTO "area" VALUES('EPSG','1438','Canada - Ontario - west of 94.5°W','Canada - Ontario - west of 94°30''W.',48.69,53.24,-95.16,-94.5,0); -INSERT INTO "area" VALUES('EPSG','1439','Canada - Ontario - west of 90°W','Canada - Ontario - west of 90°W.',48.03,56.2,-95.17,-90.0,0); +INSERT INTO "area" VALUES('EPSG','1439','Canada - Ontario - west of 90°W','Canada - Ontario - west of 90°W.',48.03,56.2,-95.16,-90.0,0); INSERT INTO "area" VALUES('EPSG','1440','Canada - Ontario - 90°W to 84°W','Canada - Ontario - between 90°W and 84°W.',46.11,56.9,-90.0,-84.0,0); INSERT INTO "area" VALUES('EPSG','1441','Canada - Ontario - 84°W to 78°W','Canada - Ontario - between 84°W and 78°W.',41.67,55.37,-84.0,-78.0,0); INSERT INTO "area" VALUES('EPSG','1442','Canada - Ontario - east of 78°W','Canada - Ontario - east of 78°W.',43.63,46.25,-78.0,-74.35,0); @@ -466,9 +466,9 @@ INSERT INTO "area" VALUES('EPSG','1486','Argentina - Tierra del Fuego offshore', INSERT INTO "area" VALUES('EPSG','1487','Cuba - onshore north of 21°30''N','Cuba - onshore north of 21°30''N but also including all of Isla de la Juventud.',21.38,23.25,-85.01,-76.91,0); INSERT INTO "area" VALUES('EPSG','1488','Cuba - onshore south of 21°30''N','Cuba - onshore south of 21°30''N and east of 80°W .',19.77,21.5,-78.69,-74.07,0); INSERT INTO "area" VALUES('EPSG','1489','Tunisia - offshore','Tunisia - offshore.',33.22,38.41,7.81,13.67,0); -INSERT INTO "area" VALUES('EPSG','1490','Yemen - 42°E to 48°E','Yemen - between 42°E and 48°E, onshore and offshore.',11.57,17.53,42.0,48.0,0); -INSERT INTO "area" VALUES('EPSG','1491','Yemen - 48°E to 54°E','Yemen - between 48°E and 54°E, onshore and offshore.',9.45,19.0,48.0,54.0,0); -INSERT INTO "area" VALUES('EPSG','1492','Yemen - South Yemen - mainland west of 48°E','Yemen - South Yemen onshore mainland west of 48°E.',12.54,17.44,43.37,48.0,0); +INSERT INTO "area" VALUES('EPSG','1490','Yemen - 42°E to 48°E','Yemen - between 42°E and 48°E, onshore and offshore.',11.57,17.95,42.0,48.01,0); +INSERT INTO "area" VALUES('EPSG','1491','Yemen - 48°E to 54°E','Yemen - between 48°E and 54°E, onshore and offshore.',9.45,19.0,48.0,54.01,0); +INSERT INTO "area" VALUES('EPSG','1492','Yemen - South Yemen - mainland west of 48°E','Yemen - South Yemen onshore mainland west of 48°E.',12.54,17.95,43.37,48.01,0); INSERT INTO "area" VALUES('EPSG','1493','Yemen - South Yemen - mainland east of 48°E','Yemen - South Yemen onshore mainland east of 48°E.',13.94,19.0,48.0,53.14,0); INSERT INTO "area" VALUES('EPSG','1494','Vietnam - onshore Vung Tau area','Vietnam - onshore Vung Tau area.',9.03,11.04,105.49,107.58,0); INSERT INTO "area" VALUES('EPSG','1495','Vietnam - offshore Cuu Long basin','Vietnam - offshore - Cuu Long basin and northwestern part of Nam Con Son basin.',7.99,11.15,106.54,110.0,0); @@ -546,8 +546,8 @@ INSERT INTO "area" VALUES('EPSG','1566','Australia - EEZ east of 162°E','Austra INSERT INTO "area" VALUES('EPSG','1567','Australasia - Australia and PNG - 138°E to 144°E','Australia - onshore and offshore between 138°E and 144°E. Papua New Guinea - onshore west of 144°E.',-46.63,-2.53,138.0,144.01,0); INSERT INTO "area" VALUES('EPSG','1568','Australasia - Australia and PNG - 144°E to 150°E','Australia - onshore and offshore between 144°E and 150°E. Papua New Guinea (PNG) - onshore between 144°E and 150°E.',-47.2,-1.3,144.0,150.01,0); INSERT INTO "area" VALUES('EPSG','1569','Saudi Arabia - onshore 36°E to 42°E','Saudi Arabia - onshore between 36°E and 42°E.',16.59,32.16,36.0,42.0,0); -INSERT INTO "area" VALUES('EPSG','1570','Asia - Middle East - Kuwait and Saudi - 48°E to 54°E','Kuwait - onshore east of 48°E. Saudi Arabia - onshore between 48°E and 54°E.',17.43,30.04,48.0,54.01,0); -INSERT INTO "area" VALUES('EPSG','1571','Asia - Middle East - Kuwait and Saudi - 42°E to 48°E','Kuwait - west of 48°E. Saudi Arabia - between of 42°E and 48°E.',15.61,31.15,42.0,48.0,0); +INSERT INTO "area" VALUES('EPSG','1570','Asia - Middle East - Kuwait and Saudi - 48°E to 54°E','Kuwait - onshore east of 48°E. Saudi Arabia - onshore between 48°E and 54°E.',17.94,30.04,47.99,54.01,0); +INSERT INTO "area" VALUES('EPSG','1571','Asia - Middle East - Kuwait and Saudi - 42°E to 48°E','Kuwait - west of 48°E. Saudi Arabia - between of 42°E and 48°E.',16.37,31.15,42.0,48.01,0); INSERT INTO "area" VALUES('EPSG','1572','Brazil - 54°W to 48°W and Aratu','Brazil - offshore between 54°W and 48°W, including Pelotas basin.',-35.71,-25.01,-53.38,-47.99,0); INSERT INTO "area" VALUES('EPSG','1573','Brazil - 48°W to 42°W and Aratu','Brazil - offshore areas south of intersection of parallel of 2°55''S with coast and between 48°W and 42°W including Santos basin.',-33.5,0.0,-48.01,-41.99,0); INSERT INTO "area" VALUES('EPSG','1574','Brazil - 42°W to 36°W and Aratu','Brazil - between 42°W and 36°W, southern hemisphere offshore including Campos and Espirito Santo basins; onshore Tucano basin area.',-26.35,0.01,-42.01,-36.0,0); @@ -733,9 +733,9 @@ INSERT INTO "area" VALUES('EPSG','1753','Peru - west of 79°W','Peru - west of 7 INSERT INTO "area" VALUES('EPSG','1754','Brazil - Amazon cone shelf','Brazil - offshore shelf - Amazon cone.',-1.05,5.6,-51.64,-48.0,0); INSERT INTO "area" VALUES('EPSG','1755','South America - 84°W to 78°W, S hemisphere and PSAD56 by country','South America (Ecuador and Peru) between 84°W and 78°W, southern hemisphere, onshore.',-10.53,0.0,-81.41,-78.0,0); INSERT INTO "area" VALUES('EPSG','1756','South America - 78°W to 72°W, N hemisphere and PSAD56 by country','South America (Ecuador; Venezuela) between 78°W and 72°W, northern hemisphere, onshore.',0.0,11.62,-78.0,-71.99,0); -INSERT INTO "area" VALUES('EPSG','1757','South America - 78°W to 72°W, S hemisphere and PSAD56 by country','South America (Chile - north of 45°S; Ecuador; Peru) between 78°W and 72°W, southern hemisphere, onshore.',-45.0,0.0,-78.0,-72.0,0); +INSERT INTO "area" VALUES('EPSG','1757','South America - 78°W to 72°W, S hemisphere and PSAD56 by country','South America (Chile - north of 45°S; Ecuador; Peru) between 78°W and 72°W, southern hemisphere, onshore.',-43.5,0.0,-78.0,-71.99,0); INSERT INTO "area" VALUES('EPSG','1758','South America - 72°W to 66°W, N hemisphere and PSAD56 by country','South America (Aruba; Bonaire; Curacao; Venezuela) between 72°W and 66°W, northern hemisphere, onshore.',0.73,12.68,-72.0,-66.0,0); -INSERT INTO "area" VALUES('EPSG','1759','South America - 72°W to 66°W, S hemisphere and PSAD56 by country','South America (Bolivia; Chile - north of 45°S; Peru) between 72°W and 66°W, southern hemisphere, onshore.',-45.0,-2.14,-72.0,-66.0,0); +INSERT INTO "area" VALUES('EPSG','1759','South America - 72°W to 66°W, S hemisphere and PSAD56 by country','South America (Bolivia; Chile - north of 45°S; Peru) between 72°W and 66°W, southern hemisphere, onshore.',-43.5,-2.14,-72.0,-66.0,0); INSERT INTO "area" VALUES('EPSG','1760','South America - 66°W to 60°W, N hemisphere and PSAD56 by country','South America (Guyana; Venezuela) onshore between 66°W and 60°W, northern hemisphere.',0.64,11.23,-66.0,-59.99,0); INSERT INTO "area" VALUES('EPSG','1761','Bolivia - 66°W to 60°W','Bolivia between 66°W and 60°W.',-22.87,-9.67,-66.0,-60.0,0); INSERT INTO "area" VALUES('EPSG','1762','South America - 60°W to 54°W, N hemisphere and PSAD56 by country','South America (Guyana) onshore between 60°W and 54°W, northern hemisphere.',1.18,8.58,-60.0,-56.47,0); @@ -1321,7 +1321,7 @@ INSERT INTO "area" VALUES('EPSG','2341','Egypt - Gulf of Suez','Egypt - Gulf of INSERT INTO "area" VALUES('EPSG','2342','Europe - common offshore','Denmark - offshore North Sea; Ireland - offshore; Netherlands - offshore; United Kingdom - UKCS offshore.',47.42,63.89,-16.1,10.86,0); INSERT INTO "area" VALUES('EPSG','2343','Europe - British Isles and Channel Islands onshore','Channel islands - onshore. Ireland - onshore. Isle of Man - onshore. United Kingdom (UK) - onshore - England; Scotland; Wales; Northern Ireland.',49.11,60.9,-10.56,1.84,0); INSERT INTO "area" VALUES('EPSG','2344','Europe - Finland and Norway - onshore','Finland and Norway - onshore.',57.93,71.21,4.68,31.59,0); -INSERT INTO "area" VALUES('EPSG','2345','Asia - Middle East - Iraq; Israel; Jordan; Lebanon; Kuwait; Saudi Arabia; Syria','Iraq, Israel, Jordan, Lebanon, Kuwait, Saudi Arabia and Syria - onshore.',15.61,37.39,34.17,55.67,0); +INSERT INTO "area" VALUES('EPSG','2345','Asia - Middle East - Iraq; Israel; Jordan; Lebanon; Kuwait; Saudi Arabia; Syria','Iraq, Israel, Jordan, Lebanon, Kuwait, Saudi Arabia and Syria - onshore.',16.37,37.39,34.17,55.67,0); INSERT INTO "area" VALUES('EPSG','2346','World - WGS72 BE to WGS 84 - by country','World. Vietnam - offshore.',-90.0,90.0,-180.0,180.0,0); INSERT INTO "area" VALUES('EPSG','2347','Algeria - north of 31.5°N','Algeria - onshore north of 35 grads North (31°30''N).',31.5,37.14,-3.85,9.22,0); INSERT INTO "area" VALUES('EPSG','2348','Brunei - offshore','Brunei Darussalam - offshore.',4.58,6.37,112.5,115.24,1); @@ -2223,7 +2223,7 @@ INSERT INTO "area" VALUES('EPSG','3243','El Salvador - onshore','El Salvador - o INSERT INTO "area" VALUES('EPSG','3244','Equatorial Guinea - onshore','Equatorial Guinea - onshore.',0.93,3.82,8.37,11.36,0); INSERT INTO "area" VALUES('EPSG','3245','Eritrea - onshore','Eritrea - onshore.',12.36,18.01,36.44,43.18,0); INSERT INTO "area" VALUES('EPSG','3246','Estonia - onshore','Estonia - onshore.',57.52,59.75,21.74,28.2,0); -INSERT INTO "area" VALUES('EPSG','3247','Falkland Islands - onshore','Falkland Islands (Malvinas) - onshore.',-52.51,-50.96,-61.54,-57.61,0); +INSERT INTO "area" VALUES('EPSG','3247','Falkland Islands - onshore','Falkland Islands (Malvinas) - onshore.',-52.51,-50.96,-61.55,-57.6,0); INSERT INTO "area" VALUES('EPSG','3248','Faroe Islands - onshore','Faroe Islands - onshore.',61.33,62.41,-7.49,-6.33,0); INSERT INTO "area" VALUES('EPSG','3249','Gabon - onshore','Gabon - onshore.',-3.98,2.32,8.65,14.52,0); INSERT INTO "area" VALUES('EPSG','3250','Gambia - onshore','Gambia - onshore.',13.05,13.83,-16.88,-13.79,0); @@ -2279,7 +2279,7 @@ INSERT INTO "area" VALUES('EPSG','3299','St Pierre and Miquelon - onshore','St P INSERT INTO "area" VALUES('EPSG','3300','St Vincent and the Grenadines - onshore','St Vincent and the northern Grenadine Islands - onshore.',12.54,13.44,-61.52,-61.07,0); INSERT INTO "area" VALUES('EPSG','3301','Samoa - onshore','Samoa - onshore.',-14.11,-13.41,-172.84,-171.37,0); INSERT INTO "area" VALUES('EPSG','3302','Sao Tome and Principe - onshore','Sao Tome and Principe - onshore.',-0.04,1.76,6.41,7.52,0); -INSERT INTO "area" VALUES('EPSG','3303','Saudi Arabia - onshore','Saudi Arabia - onshore.',15.61,32.16,34.51,55.67,0); +INSERT INTO "area" VALUES('EPSG','3303','Saudi Arabia - onshore','Saudi Arabia - onshore.',16.37,32.16,34.51,55.67,0); INSERT INTO "area" VALUES('EPSG','3304','Senegal - onshore','Senegal - onshore.',12.29,16.7,-17.59,-11.36,0); INSERT INTO "area" VALUES('EPSG','3305','Serbia and Montenegro - onshore','Serbia and Montenegro - onshore.',41.82,46.23,18.44,23.05,1); INSERT INTO "area" VALUES('EPSG','3306','Sierra Leone - onshore','Sierra Leone - onshore.',6.88,10.0,-13.35,-10.26,0); @@ -2331,7 +2331,7 @@ INSERT INTO "area" VALUES('EPSG','3351','Slovenia - Kocevje','Slovenia - Kocevje INSERT INTO "area" VALUES('EPSG','3352','Slovenia - Koroska','Slovenia - Koroska Region (Slovene Carinthia).',46.46,46.66,14.83,15.51,0); INSERT INTO "area" VALUES('EPSG','3353','Slovenia - Velenje','Slovenia - Velenje with part of Koroska Region (Slovene Carinthia).',46.28,46.51,14.9,15.26,0); INSERT INTO "area" VALUES('EPSG','3354','Slovenia - Zasavje','Slovenia - Zasavje (the Sava Valley) with the broad region of Celje.',46.0,46.32,14.84,15.35,0); -INSERT INTO "area" VALUES('EPSG','3355','Brazil - south of 18°S and west of 54°W','Brazil - onshore south of 18°S and west of 54°W.',-31.91,-17.99,-58.16,-54.0,0); +INSERT INTO "area" VALUES('EPSG','3355','Brazil - west of 54°W and south of 18°S','Brazil - west of 54°W and south of 18°S.',-31.91,-17.99,-58.16,-54.0,0); INSERT INTO "area" VALUES('EPSG','3356','South America - Brazil - south of 18°S and west of 54°W + DF; N Paraguay','Brazil - south of 18°S and west of 54°W, plus Distrito Federal. Paraguay - north.',-31.91,-15.37,-62.57,-47.1,0); INSERT INTO "area" VALUES('EPSG','3357','USA - GoM OCS','United States (USA) - offshore Gulf of Mexico outer continental shelf (GoM OCS) - protraction areas South Padre Island; North Padre Island; Mustang Island; Matagorda Island; Brazos; Galveston; High Island; Sabine Pass; West Cameron; East Cameron; Vermilion; South Marsh Island; Eugene Island; Ship Shoal; South Pelto; Bay Marchand; South Timbalier; Grand Isle; West Delta; South Pass; Main Pass; Breton Sound; Chandeleur; Corpus Christi; Port Isabel; East Breaks; Alaminos Canyon; Garden Banks; Keathley Canyon; Sigsbee Escarpment; Ewing Bank; Green Canyon; Walker Ridge; Amery Terrace; Mobile; Viosca Knoll; Mississippi Canyon; Atwater Valley; Lund; Lund South; Pensacola; Destin Dome; De Soto Canyon; Lloyd Ridge; Henderson; Florida Plain; Campeche Escarpment; Apalachicola; Florida Middle Ground; The Elbow; Vernon Basin; Howell Hook; Rankin; Gainesville; Tarpon Springs; St Petersburg; Charlotte Harbor; Pulley Ridge; Dry Tortugas; Tortugas Valley; Miami; Key West.',23.82,30.25,-97.22,-81.17,0); INSERT INTO "area" VALUES('EPSG','3358','USA - GoM - east of 87.25°W','United States (USA) - offshore Gulf of Mexico (GoM) east of approximately 87°15''W - protraction areas Gainesville, Tarpon Springs, St Petersburg, Charlotte Harbor, Pulley Ridge, Dry Tortugas, Tortugas Valley, Miami, Key West, Apalachicola, Florida Middle Ground, The Elbow, Vernon Basin, Howell Hook, Rankin and Campeche Escarpment. Also for protraction areas Pensacola, Destin Dome, Desoto Canyon, Lloyd Ridge, Henderson and Florida Plain - east of 87°15''W.',23.82,30.25,-87.25,-81.17,0); @@ -2585,7 +2585,7 @@ INSERT INTO "area" VALUES('EPSG','3605','Finland - 28.5°E to 29.5°E nominal',' INSERT INTO "area" VALUES('EPSG','3606','Finland - 29.5°E to 30.5°E nominal','Finland - nominally between 29°30''E and 30°30''E but may be used in adjacent areas if a municipality chooses to use one zone over its whole extent.',61.43,67.98,29.5,30.5,0); INSERT INTO "area" VALUES('EPSG','3607','Finland - east of 30.5°E nominal','Finland - nominally east of 30°30''E but may be used in adjacent areas to west if a municipality chooses to use one zone over its whole extent.',62.08,64.27,30.5,31.59,0); INSERT INTO "area" VALUES('EPSG','3608','Sweden - Stockholm county','Sweden - Stockholm county. Municipalities of Botkyrka, Danderyd, Ekerö, Haninge, Huddinge, Järfälla, Lidingö, Nacka, Nynäshamn, Salem, Sigtuna, Sollentuna, Solna, Stockholm and Sundbyberg.',58.69,60.27,17.25,19.61,0); -INSERT INTO "area" VALUES('EPSG','3609','Congo DR (Zaire) - Katanga west of 25.5°E','The Democratic Republic of the Congo (Zaire) - Katanga west of 25°30''E.',-11.72,-6.32,21.74,25.5,0); +INSERT INTO "area" VALUES('EPSG','3609','Congo DR (Zaire) - Katanga west of 25.5°E','The Democratic Republic of the Congo (Zaire) - Katanga west of 25°30''E.',-11.72,-6.32,21.74,25.51,0); INSERT INTO "area" VALUES('EPSG','3610','Congo DR (Zaire) - Katanga 24.5°E to 27.5°E','The Democratic Republic of the Congo (Zaire) - Katanga between 24°30''E and 27°30''E.',-12.08,-4.99,24.5,27.5,0); INSERT INTO "area" VALUES('EPSG','3611','Congo DR (Zaire) - Katanga 26.5°E to 29.5°E','The Democratic Republic of the Congo (Zaire) - Katanga between 26°30''E and 29°30''E.',-13.44,-4.99,26.5,29.5,0); INSERT INTO "area" VALUES('EPSG','3612','Congo DR (Zaire) - Katanga east of 28.5°E','The Democratic Republic of the Congo (Zaire) - Katanga east of 28°30''E.',-13.46,-4.99,28.5,30.78,0); @@ -3503,8 +3503,8 @@ INSERT INTO "area" VALUES('EPSG','4523','World centred on 150°E','World centred INSERT INTO "area" VALUES('EPSG','4524','Saudi Arabia - west of 36°E','Saudi Arabia - onshore and offshore - west of 36°E.',24.92,29.38,34.44,36.01,0); INSERT INTO "area" VALUES('EPSG','4525','Pacific - Guam and NMI - onshore','Guam - onshore. Northern Mariana Islands - onshore.',13.18,20.61,144.58,146.12,0); INSERT INTO "area" VALUES('EPSG','4526','Saudi Arabia - 36°E to 42°E','Saudi Arabia - onshore and offshore - between 36°E and 42°E.',16.29,32.16,36.0,42.0,0); -INSERT INTO "area" VALUES('EPSG','4527','Saudi Arabia - 42°E to 48°E','Saudi Arabia - onshore and offshore - between of 42°E and 48°E.',15.61,31.15,41.99,48.0,0); -INSERT INTO "area" VALUES('EPSG','4528','Saudi Arabia - 48°E to 54°E','Saudi Arabia - onshore and offshore - between 48°E and 54°E.',17.43,28.94,48.0,54.01,0); +INSERT INTO "area" VALUES('EPSG','4527','Saudi Arabia - 42°E to 48°E','Saudi Arabia - onshore and offshore - between of 42°E and 48°E.',16.35,31.15,41.99,48.0,0); +INSERT INTO "area" VALUES('EPSG','4528','Saudi Arabia - 48°E to 54°E','Saudi Arabia - onshore and offshore - between 48°E and 54°E.',17.94,28.94,47.99,54.01,0); INSERT INTO "area" VALUES('EPSG','4530','Latin America - Central America and South America','Latin America - Central America and South America, onshore and offshore.',-59.87,32.72,-122.19,-25.28,0); INSERT INTO "area" VALUES('EPSG','4531','Costa Rica - offshore Caribbean','Costa Rica - offshore - Caribbean sea.',9.6,11.77,-83.6,-81.43,0); INSERT INTO "area" VALUES('EPSG','4532','Costa Rica - offshore Pacific','Costa Rica - offshore Pacific ocean and onshore Coco Island.',2.15,11.11,-90.45,-82.92,0); @@ -3549,5 +3549,13 @@ INSERT INTO "area" VALUES('EPSG','4570','Argentina - south Santa Cruz west of 70 INSERT INTO "area" VALUES('EPSG','4571','Argentina - south Santa Cruz east of 70.5°W','Argentina - Santa Cruz province south of approximately 50°20''S and east of 70°30''W.',-52.43,-50.33,-70.5,-68.3,0); INSERT INTO "area" VALUES('EPSG','4572','Argentina - 44°S to 47.5°S','Argentina - Chubut province south of approximately 44°S and Santa Cruz province north of approximately 47°30''S - Golfo San Jorge basin onshore and offshore.',-47.5,-43.99,-72.36,-63.24,0); INSERT INTO "area" VALUES('EPSG','4573','Argentina - onshore','Argentina - onshore.',-55.11,-21.78,-73.59,-53.65,0); +INSERT INTO "area" VALUES('EPSG','4574','Brazil - west of 54°W and between 18°S and 27°30''S','Brazil - west of 54°W and between 18°S and 27°30''S.',-27.5,-17.99,-58.16,-54.0,0); INSERT INTO "area" VALUES('EPSG','4575','Denmark - onshore Jutland, Funen, Zealand and Lolland','Denmark - onshore Jutland, Funen, Zealand and Lolland.',54.51,57.8,8.0,12.69,0); +INSERT INTO "area" VALUES('EPSG','4576','Brazil - 54°W to 48°W and 15°S to 27°30''S','Brazil - onshore between 54°W and 48°W and between 15°S and 27°30''S.',-27.5,-14.99,-54.0,-47.99,0); +INSERT INTO "area" VALUES('EPSG','4577','Argentina - 70.5°W to 67.5°W mainland onshore','Argentina - between 70°30''W and 67°30''W, onshore mainland.',-52.43,-24.08,-70.5,-67.49,0); +INSERT INTO "area" VALUES('EPSG','4578','Argentina - 67.5°W to 64.5°W mainland onshore','Argentina - between 67°30''W and 64°30''W, onshore mainland.',-49.05,-21.78,-67.5,-64.49,0); +INSERT INTO "area" VALUES('EPSG','4579','Argentina - 64.5°W to 61.5°W mainland onshore','Argentina - between 64°30''W and 61°30''W, onshore mainland.',-43.14,-21.99,-64.5,-61.49,0); INSERT INTO "area" VALUES('EPSG','4580','Germany - Baden-Wurttemberg','Germany - Baden-Wurttemberg.',47.54,49.8,7.51,10.5,0); +INSERT INTO "area" VALUES('EPSG','4581','Africa - Morocco and Western Sahara - onshore','Africa - Morocco and Western Sahara - onshore.',20.71,35.97,-17.16,-1.01,0); +INSERT INTO "area" VALUES('EPSG','4584','Germany - Saarland','Germany - Saarland.',49.11,49.64,6.35,7.41,0); +INSERT INTO "area" VALUES('EPSG','4587','Congo DR (Zaire) - 6th parallel south 21.5°E to 23°E','The Democratic Republic of the Congo (Zaire) - adjacent to 6th parallel south traverse between 21°30''E and 23°E.',-7.31,-5.31,21.5,23.01,0); diff --git a/data/sql/compound_crs.sql b/data/sql/compound_crs.sql index 4f838b5d..fd8262fd 100644 --- a/data/sql/compound_crs.sql +++ b/data/sql/compound_crs.sql @@ -64,12 +64,12 @@ INSERT INTO "compound_crs" VALUES('EPSG','5967','ETRS89 / NTM zone 27 + NN2000 h INSERT INTO "compound_crs" VALUES('EPSG','5968','ETRS89 / NTM zone 28 + NN2000 height',NULL,NULL,'EPSG','5128','EPSG','5941','EPSG','3673',0); INSERT INTO "compound_crs" VALUES('EPSG','5969','ETRS89 / NTM zone 29 + NN2000 height',NULL,NULL,'EPSG','5129','EPSG','5941','EPSG','3674',0); INSERT INTO "compound_crs" VALUES('EPSG','5970','ETRS89 / NTM zone 30 + NN2000 height',NULL,NULL,'EPSG','5130','EPSG','5941','EPSG','3676',0); -INSERT INTO "compound_crs" VALUES('EPSG','5971','ETRS89 / UTM zone 31 + NN2000 height',NULL,NULL,'EPSG','25831','EPSG','5941','EPSG','3636',0); -INSERT INTO "compound_crs" VALUES('EPSG','5972','ETRS89 / UTM zone 32 + NN2000 height',NULL,NULL,'EPSG','25832','EPSG','5941','EPSG','4066',0); -INSERT INTO "compound_crs" VALUES('EPSG','5973','ETRS89 / UTM zone 33 + NN2000 height',NULL,NULL,'EPSG','25833','EPSG','5941','EPSG','4067',0); -INSERT INTO "compound_crs" VALUES('EPSG','5974','ETRS89 / UTM zone 34 + NN2000 height',NULL,NULL,'EPSG','25834','EPSG','5941','EPSG','4068',0); -INSERT INTO "compound_crs" VALUES('EPSG','5975','ETRS89 / UTM zone 35 + NN2000 height',NULL,NULL,'EPSG','25835','EPSG','5941','EPSG','4069',0); -INSERT INTO "compound_crs" VALUES('EPSG','5976','ETRS89 / UTM zone 36 + NN2000 height',NULL,NULL,'EPSG','25836','EPSG','5941','EPSG','3676',0); +INSERT INTO "compound_crs" VALUES('EPSG','5971','ETRS89 / UTM zone 31N + NN2000 height',NULL,NULL,'EPSG','25831','EPSG','5941','EPSG','3636',0); +INSERT INTO "compound_crs" VALUES('EPSG','5972','ETRS89 / UTM zone 32N + NN2000 height',NULL,NULL,'EPSG','25832','EPSG','5941','EPSG','4066',0); +INSERT INTO "compound_crs" VALUES('EPSG','5973','ETRS89 / UTM zone 33N + NN2000 height',NULL,NULL,'EPSG','25833','EPSG','5941','EPSG','4067',0); +INSERT INTO "compound_crs" VALUES('EPSG','5974','ETRS89 / UTM zone 34N + NN2000 height',NULL,NULL,'EPSG','25834','EPSG','5941','EPSG','4068',0); +INSERT INTO "compound_crs" VALUES('EPSG','5975','ETRS89 / UTM zone 35N + NN2000 height',NULL,NULL,'EPSG','25835','EPSG','5941','EPSG','4069',0); +INSERT INTO "compound_crs" VALUES('EPSG','5976','ETRS89 / UTM zone 36N + NN2000 height',NULL,NULL,'EPSG','25836','EPSG','5941','EPSG','3676',0); INSERT INTO "compound_crs" VALUES('EPSG','6144','ETRS89 + NN54 height',NULL,NULL,'EPSG','4258','EPSG','5776','EPSG','1352',0); INSERT INTO "compound_crs" VALUES('EPSG','6145','ETRS89 / NTM zone 5 + NN54 height',NULL,NULL,'EPSG','5105','EPSG','5776','EPSG','3636',0); INSERT INTO "compound_crs" VALUES('EPSG','6146','ETRS89 / NTM zone 6 + NN54 height',NULL,NULL,'EPSG','5106','EPSG','5776','EPSG','3639',0); @@ -97,12 +97,12 @@ INSERT INTO "compound_crs" VALUES('EPSG','6167','ETRS89 / NTM zone 27 + NN54 hei INSERT INTO "compound_crs" VALUES('EPSG','6168','ETRS89 / NTM zone 28 + NN54 height',NULL,NULL,'EPSG','5128','EPSG','5776','EPSG','3673',0); INSERT INTO "compound_crs" VALUES('EPSG','6169','ETRS89 / NTM zone 29 + NN54 height',NULL,NULL,'EPSG','5129','EPSG','5776','EPSG','3674',0); INSERT INTO "compound_crs" VALUES('EPSG','6170','ETRS89 / NTM zone 30 + NN54 height',NULL,NULL,'EPSG','5130','EPSG','5776','EPSG','3676',0); -INSERT INTO "compound_crs" VALUES('EPSG','6171','ETRS89 / UTM zone 31 + NN54 height',NULL,NULL,'EPSG','25831','EPSG','5776','EPSG','3636',0); -INSERT INTO "compound_crs" VALUES('EPSG','6172','ETRS89 / UTM zone 32 + NN54 height',NULL,NULL,'EPSG','25832','EPSG','5776','EPSG','4066',0); -INSERT INTO "compound_crs" VALUES('EPSG','6173','ETRS89 / UTM zone 33 + NN54 height',NULL,NULL,'EPSG','25833','EPSG','5776','EPSG','4067',0); -INSERT INTO "compound_crs" VALUES('EPSG','6174','ETRS89 / UTM zone 34 + NN54 height',NULL,NULL,'EPSG','25834','EPSG','5776','EPSG','4068',0); -INSERT INTO "compound_crs" VALUES('EPSG','6175','ETRS89 / UTM zone 35 + NN54 height',NULL,NULL,'EPSG','25835','EPSG','5776','EPSG','4069',0); -INSERT INTO "compound_crs" VALUES('EPSG','6176','ETRS89 / UTM zone 36 + NN54 height',NULL,NULL,'EPSG','25836','EPSG','5776','EPSG','3676',0); +INSERT INTO "compound_crs" VALUES('EPSG','6171','ETRS89 / UTM zone 31N + NN54 height',NULL,NULL,'EPSG','25831','EPSG','5776','EPSG','3636',0); +INSERT INTO "compound_crs" VALUES('EPSG','6172','ETRS89 / UTM zone 32N + NN54 height',NULL,NULL,'EPSG','25832','EPSG','5776','EPSG','4066',0); +INSERT INTO "compound_crs" VALUES('EPSG','6173','ETRS89 / UTM zone 33N + NN54 height',NULL,NULL,'EPSG','25833','EPSG','5776','EPSG','4067',0); +INSERT INTO "compound_crs" VALUES('EPSG','6174','ETRS89 / UTM zone 34N + NN54 height',NULL,NULL,'EPSG','25834','EPSG','5776','EPSG','4068',0); +INSERT INTO "compound_crs" VALUES('EPSG','6175','ETRS89 / UTM zone 35N + NN54 height',NULL,NULL,'EPSG','25835','EPSG','5776','EPSG','4069',0); +INSERT INTO "compound_crs" VALUES('EPSG','6176','ETRS89 / UTM zone 36N + NN54 height',NULL,NULL,'EPSG','25836','EPSG','5776','EPSG','3676',0); INSERT INTO "compound_crs" VALUES('EPSG','6190','Belge 1972 / Belgian Lambert 72 + Ostend height',NULL,NULL,'EPSG','31370','EPSG','5710','EPSG','1347',0); INSERT INTO "compound_crs" VALUES('EPSG','6349','NAD83(2011) + NAVD88 height',NULL,NULL,'EPSG','6318','EPSG','5703','EPSG','3664',0); INSERT INTO "compound_crs" VALUES('EPSG','6649','NAD83(CSRS) + CGVD2013 height',NULL,NULL,'EPSG','4617','EPSG','6647','EPSG','1061',0); diff --git a/data/sql/deprecation.sql b/data/sql/deprecation.sql index e364141d..cee8a5c3 100644 --- a/data/sql/deprecation.sql +++ b/data/sql/deprecation.sql @@ -456,3 +456,10 @@ INSERT INTO "deprecation" VALUES('projected_crs','EPSG','3911','EPSG','8686','EP INSERT INTO "deprecation" VALUES('geodetic_crs','EPSG','8449','EPSG','8860','EPSG'); INSERT INTO "deprecation" VALUES('geodetic_crs','EPSG','4280','EPSG','4211','EPSG'); INSERT INTO "deprecation" VALUES('geodetic_crs','EPSG','4808','EPSG','4813','EPSG'); +INSERT INTO "deprecation" VALUES('projected_crs','EPSG','2163','EPSG','9311','EPSG'); +INSERT INTO "deprecation" VALUES('projected_crs','EPSG','3408','EPSG','6931','EPSG'); +INSERT INTO "deprecation" VALUES('projected_crs','EPSG','3409','EPSG','6932','EPSG'); +INSERT INTO "deprecation" VALUES('projected_crs','EPSG','3410','EPSG','6933','EPSG'); +INSERT INTO "deprecation" VALUES('projected_crs','EPSG','3411','EPSG','3413','EPSG'); +INSERT INTO "deprecation" VALUES('projected_crs','EPSG','3412','EPSG','3976','EPSG'); +INSERT INTO "deprecation" VALUES('projected_crs','EPSG','4088','EPSG','4087','EPSG'); diff --git a/data/sql/geodetic_crs.sql b/data/sql/geodetic_crs.sql index 99b16312..c6fcc66e 100644 --- a/data/sql/geodetic_crs.sql +++ b/data/sql/geodetic_crs.sql @@ -201,7 +201,7 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','4257','Makassar',NULL,NULL,'geographic INSERT INTO "geodetic_crs" VALUES('EPSG','4258','ETRS89',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6258','EPSG','1298',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4259','Malongo 1987',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6259','EPSG','3180',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4260','Manoca',NULL,NULL,'geographic 2D','EPSG','6402','EPSG','6260','EPSG','1060',NULL,1); -INSERT INTO "geodetic_crs" VALUES('EPSG','4261','Merchich',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6261','EPSG','3280',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','4261','Merchich',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6261','EPSG','4581',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4262','Massawa',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6262','EPSG','1089',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4263','Minna',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6263','EPSG','1178',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','4264','Mhast',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','6264','EPSG','1318',NULL,1); @@ -1031,6 +1031,9 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','9251','MMN',NULL,NULL,'geographic 2D', INSERT INTO "geodetic_crs" VALUES('EPSG','9253','MMS',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1259','EPSG','2357',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','9266','MGI',NULL,NULL,'geocentric','EPSG','6500','EPSG','6312','EPSG','1037',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','9267','MGI',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','6312','EPSG','1037',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','9292','ONGD17',NULL,NULL,'geocentric','EPSG','6500','EPSG','1263','EPSG','1183',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','9293','ONGD17',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1263','EPSG','1183',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','9294','ONGD17',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1263','EPSG','1183',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','9331','KSA-GRF17',NULL,NULL,'geocentric','EPSG','6500','EPSG','1268','EPSG','1206',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','9332','KSA-GRF17',NULL,NULL,'geographic 3D','EPSG','6423','EPSG','1268','EPSG','1206',NULL,0); INSERT INTO "geodetic_crs" VALUES('EPSG','9333','KSA-GRF17',NULL,NULL,'geographic 2D','EPSG','6422','EPSG','1268','EPSG','1206',NULL,0); diff --git a/data/sql/geodetic_datum.sql b/data/sql/geodetic_datum.sql index 0ea4c200..34d91ab0 100644 --- a/data/sql/geodetic_datum.sql +++ b/data/sql/geodetic_datum.sql @@ -151,6 +151,7 @@ INSERT INTO "geodetic_datum" VALUES('EPSG','1254','SIRGAS-Chile',NULL,NULL,'EPSG INSERT INTO "geodetic_datum" VALUES('EPSG','1257','Tapi Aike',NULL,NULL,'EPSG','7022','EPSG','8901','EPSG','4569','1945-01-01',0); INSERT INTO "geodetic_datum" VALUES('EPSG','1258','Ministerio de Marina Norte',NULL,NULL,'EPSG','7022','EPSG','8901','EPSG','2357',NULL,0); INSERT INTO "geodetic_datum" VALUES('EPSG','1259','Ministerio de Marina Sur',NULL,NULL,'EPSG','7022','EPSG','8901','EPSG','2357',NULL,0); +INSERT INTO "geodetic_datum" VALUES('EPSG','1263','Oman National Geodetic Datum 2017',NULL,NULL,'EPSG','7019','EPSG','8901','EPSG','1183','2017-11-01',0); INSERT INTO "geodetic_datum" VALUES('EPSG','1268','Kingdom of Saudi Arabia Geodetic Reference Frame 2017',NULL,NULL,'EPSG','7019','EPSG','8901','EPSG','1206','2017-12-01',0); INSERT INTO "geodetic_datum" VALUES('EPSG','6001','Not specified (based on Airy 1830 ellipsoid)',NULL,NULL,'EPSG','7001','EPSG','8901','EPSG','1263',NULL,0); INSERT INTO "geodetic_datum" VALUES('EPSG','6002','Not specified (based on Airy Modified 1849 ellipsoid)',NULL,NULL,'EPSG','7002','EPSG','8901','EPSG','1263',NULL,0); diff --git a/data/sql/grid_transformation.sql b/data/sql/grid_transformation.sql index 021a731a..d8e43276 100644 --- a/data/sql/grid_transformation.sql +++ b/data/sql/grid_transformation.sql @@ -214,12 +214,12 @@ INSERT INTO "grid_transformation" VALUES('EPSG','7673','CH1903 to CHTRF95 (1)',' INSERT INTO "grid_transformation" VALUES('EPSG','7674','CH1903 to ETRS89 (2)','Replaces tfm code 1646. Equivalent to concatenation of transformations 15486 and 1647 to within 2cm. Also used as transformation between CH1903 and CHTRF95 (see code 7673). May be used as approximate tfm CH1903 to WGS 84 - see code 7788.','Approximation (to better than 2cm) using NTv2 method of results of FINELTRA programme concatenated with LV-95 parameters.','EPSG','9615','NTv2','EPSG','4149','EPSG','4258','EPSG','1286',0.25,'EPSG','8656','Latitude and longitude difference file','CHENyx06_ETRS.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'BfL-Che NTv2',0); INSERT INTO "grid_transformation" VALUES('EPSG','7709','OSGB 1936 to ETRS89 (2)','Approximate alternative to official OSTN15 method (tfm code 7953). May be taken as approximate transformation OSGB 1936 to WGS 84 - see code 7710. Replaces OSGB 1936 to ETRS89 (1) (tfm code 5338).','Accuracy at 2000 test points compared to official OSTN15 (tfm code 7708): latitude 0.5mm average, 17mm maximum; longitude 0.8mm average, 23mm maximum.','EPSG','9615','NTv2','EPSG','4277','EPSG','4258','EPSG','4390',0.03,'EPSG','8656','Latitude and longitude difference file','OSTN15_NTv2_OSGBtoETRS.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'OSGB-UK Gbr15 NT',0); INSERT INTO "grid_transformation" VALUES('EPSG','7710','OSGB 1936 to WGS 84 (9)','Parameter values taken from OSGB 1936 to ETRS89 (3) (tfm code 7709) assuming that ETRS89 is coincident with WGS 84 within the accuracy of the tfm. Replaces OSGB 1936 to WGS 84 (7) (tfm code 5339).','Accuracy 1m.','EPSG','9615','NTv2','EPSG','4277','EPSG','4326','EPSG','4390',1.0,'EPSG','8656','Latitude and longitude difference file','OSTN15_NTv2_OSGBtoETRS.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'OGP-UK Gbr15 NT',0); -INSERT INTO "grid_transformation" VALUES('EPSG','7711','ETRS89 to Newlyn height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to Newlyn height (1) (tfm code 10021).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5701','EPSG','2792',0.008,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Gbr 2015',0); -INSERT INTO "grid_transformation" VALUES('EPSG','7712','ETRS89 to Newlyn (Orkney Isles) height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to Newlyn (Orkney Isles) height (1) (tfm code 10029).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5740','EPSG','2793',0.017,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Ork 2015',0); -INSERT INTO "grid_transformation" VALUES('EPSG','7713','ETRS89 to Newlyn (Offshore) height (1)','Replaces ETRS89 to Fair Isle/Flannan Isles/Foula/North Rona/St Kilda/Sule Skerry height (1) (tfm codes 10024-26, 10030-31 and 10034).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','7707','EPSG','4391',0.02,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Off 2015',0); +INSERT INTO "grid_transformation" VALUES('EPSG','7711','ETRS89 to ODN height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to Newlyn height (1) (tfm code 10021).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5701','EPSG','2792',0.008,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Gbr 2015',0); +INSERT INTO "grid_transformation" VALUES('EPSG','7712','ETRS89 to ODN Orkney height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to ODN Orkney height (1) (tfm code 10029).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5740','EPSG','2793',0.017,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Ork 2015',0); +INSERT INTO "grid_transformation" VALUES('EPSG','7713','ETRS89 to ODN (Offshore) height (1)','Replaces ETRS89 to Fair Isle/Flannan Isles/Foula/North Rona/St Kilda/Sule Skerry height (1) (tfm codes 10024-26, 10030-31 and 10034).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','7707','EPSG','4391',0.02,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Off 2015',0); INSERT INTO "grid_transformation" VALUES('EPSG','7714','ETRS89 to Lerwick height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to Lerwick height (1) (tfm code 10027).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5742','EPSG','2795',0.018,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS -UK Shet 2015',0); INSERT INTO "grid_transformation" VALUES('EPSG','7715','ETRS89 to Stornoway height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to Stornaway height (1) (tfm code 10033).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5746','EPSG','2799',0.011,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Heb 2015',0); -INSERT INTO "grid_transformation" VALUES('EPSG','7716','ETRS89 to St. Marys height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to St Marys height (1) (tfm code 10032).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5749','EPSG','2802',0.01,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Scilly 2015',0); +INSERT INTO "grid_transformation" VALUES('EPSG','7716','ETRS89 to St. Marys height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to St. Marys height (1) (tfm code 10032).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5749','EPSG','2802',0.01,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Scilly 2015',0); INSERT INTO "grid_transformation" VALUES('EPSG','7717','ETRS89 to Douglas height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to Douglas height (1) (tfm code 10023).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5750','EPSG','2803',0.03,'EPSG','8666','Geoid (height correction) model file','OSTN15_OSGM15_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Man 2015',0); INSERT INTO "grid_transformation" VALUES('EPSG','7718','ETRS89 to Belfast height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to Belfast height (1) (tfm code 5334).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','1045','Geographic3D to GravityRelatedHeight (OSGM02-Ire)','EPSG','4937','EPSG','5732','EPSG','2530',0.014,'EPSG','8666','Geoid (height correction) model file','OSGM15_Belfast.gri',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK NI 2015',1); INSERT INTO "grid_transformation" VALUES('EPSG','7719','ETRS89 to Malin Head height (2)','OSGM15 supersedes OSGM02 geoid model. Replaces ETRS89 to Malin Head height (1) (tfm code 5335).','Derivation of gravity-related heights from OSGM15 geoid model.','EPSG','1045','Geographic3D to GravityRelatedHeight (OSGM02-Ire)','EPSG','4937','EPSG','5731','EPSG','1305',0.023,'EPSG','8666','Geoid (height correction) model file','OSGM15_Malin.gri',NULL,NULL,NULL,NULL,NULL,NULL,'OS-Ire 2015',1); @@ -349,6 +349,7 @@ INSERT INTO "grid_transformation" VALUES('EPSG','9278','ETRS89 to GHA Austria he INSERT INTO "grid_transformation" VALUES('EPSG','9280','ITRF2005 to SA LLD height (1)','Hybrid geoid referenced to ITRF2005@2010.02. Accuracy 7cm at 1 sigma.','Derivation of gravity-related heights from GNSS observations.','EPSG','1082','Geographic3D to GravityRelatedHeight (SA 2010)','EPSG','7910','EPSG','9279','EPSG','3309',0.07,'EPSG','8666','Geoid (height correction) model file','SAGEOID2010.dat',NULL,NULL,NULL,NULL,NULL,NULL,'NGI-Zaf',0); INSERT INTO "grid_transformation" VALUES('EPSG','9282','Amersfoort to ETRS89 (9)','Consistent to within 1mm with official RNAPTRANS(TM)2018 at ground level onshore and at MSL offshore. The horizontal deviation using this NTv2 grid is approximately 1mm per 50m height difference from ground level or MSL.','Approximation of horizontal component of official 3D RDNAPTRANS(TM) transformation, which since 1st October 2000 has defined Amersfoort geodetic datum.','EPSG','9615','NTv2','EPSG','4289','EPSG','4258','EPSG','1275',0.001,'EPSG','8656','Latitude and longitude difference file','rdtrans2018.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'NSGI-Nld 2018',0); INSERT INTO "grid_transformation" VALUES('EPSG','9283','ETRS89 to NAP height (2)','Vertical component of official RDNAPTRANS(TM)2018 procedure. Replaces previous versions of RDNAPTRANS.','Derivation of gravity-related heights from GPS observations.','EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)','EPSG','4937','EPSG','5709','EPSG','1275',0.001,'EPSG','8666','Geoid (height correction) model file','nlgeo2018.gtx',NULL,NULL,NULL,NULL,NULL,NULL,'NSGI-Nld 2018',0); +INSERT INTO "grid_transformation" VALUES('EPSG','9310','DHDN to ETRS89 (10)','Replaces SeTa2009 from 2018-01-15. Derived using the 2016 implementation of ETRS89 / DREF91 and DHHN2016. Coincident with the transformation of cadastral data from DHDN to ETRS89 used by LVGL at a level of 1-2 mm.','Cadastre, engineering survey, topographic mapping (large scale).','EPSG','9615','NTv2','EPSG','4314','EPSG','4258','EPSG','4584',0.01,'EPSG','8656','Latitude and longitude difference file','SeTa2016.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'LVGL-Deu SL 2016',0); INSERT INTO "grid_transformation" VALUES('EPSG','9312','NZVD2016 height to Auckland 1946 height (2)','Derived at 260 control points. Mean offset 0.292m, standard deviation 0.029m, maximum difference from mean 0.075m. Supersedes NZVD2016 height to Auckland 1946 height (1) (code 7860) after change of grid file format.','Transformation between national and local height systems.','EPSG','1084','Vertical Offset by Grid Interpolation (gtx)','EPSG','7839','EPSG','5759','EPSG','3764',0.02,'EPSG','8732','Vertical offset file','auckht1946-nzvd2016.gtx',NULL,NULL,NULL,NULL,'EPSG','4167','LINZ-NZ AUCK gtx',0); INSERT INTO "grid_transformation" VALUES('EPSG','9313','NZVD2016 height to Bluff 1955 height (2)','Derived at 71 control points. Mean offset 0.273m, standard deviation 0.034m, maximum difference from mean 0.079m. Supersedes NZVD2016 height to Bluff 1955 height (1) (code 7861) after change of grid file format.','Transformation between national and local height systems.','EPSG','1084','Vertical Offset by Grid Interpolation (gtx)','EPSG','7839','EPSG','5760','EPSG','3801',0.02,'EPSG','8732','Vertical offset file','blufht1955-nzvd2016.gtx',NULL,NULL,NULL,NULL,'EPSG','4167','LINZ-NZ BLUF gtx',0); INSERT INTO "grid_transformation" VALUES('EPSG','9314','NZVD2016 height to Dunedin 1958 height (2)','Derived at 197 control points. Mean offset 0.326m, standard deviation 0.043m, maximum difference from mean 0.152m. Supersedes NZVD2016 height to Dunedin 1958 height (1) (code 7862) after change of grid file format.','Transformation between national and local height systems.','EPSG','1084','Vertical Offset by Grid Interpolation (gtx)','EPSG','7839','EPSG','5761','EPSG','3803',0.02,'EPSG','8732','Vertical offset file','duneht1958-nzvd2016.gtx',NULL,NULL,NULL,NULL,'EPSG','4167','LINZ-NZ DUNE gtx',0); @@ -390,7 +391,7 @@ INSERT INTO "grid_transformation" VALUES('EPSG','10017','NAD83 to NAVD88 height INSERT INTO "grid_transformation" VALUES('EPSG','10018','NAD83 to NAVD88 height (6)','Uses Geoid03 hybrid model. See information source for further information. Note: Source CRS is 2D, used in this application of the method as a pseudo-3D CRS.','Derivation of approximate gravity-related heights from GPS observations.','EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)','EPSG','4269','EPSG','5703','EPSG','2974',0.05,'EPSG','8666','Geoid (height correction) model file','g2003u06.bin',NULL,NULL,NULL,NULL,NULL,NULL,'NGS-US Conus CSW',1); INSERT INTO "grid_transformation" VALUES('EPSG','10019','NAD83 to NAVD88 height (7)','Uses Geoid03 hybrid model. See information source for further information. Note: Source CRS is 2D, used in this application of the method as a pseudo-3D CRS.','Derivation of approximate gravity-related heights from GPS observations.','EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)','EPSG','4269','EPSG','5703','EPSG','2975',0.05,'EPSG','8666','Geoid (height correction) model file','g2003u07.bin',NULL,NULL,NULL,NULL,NULL,NULL,'NGS-US Conus CSE',1); INSERT INTO "grid_transformation" VALUES('EPSG','10020','NAD83 to NAVD88 height (8)','Uses Geoid03 hybrid model. See information source for further information. Note: Source CRS is 2D, used in this application of the method as a pseudo-3D CRS.','Derivation of approximate gravity-related heights from GPS observations.','EPSG','9665','Geographic3D to GravityRelatedHeight (gtx)','EPSG','4269','EPSG','5703','EPSG','2976',0.05,'EPSG','8666','Geoid (height correction) model file','g2003u08.bin',NULL,NULL,NULL,NULL,NULL,NULL,'NGS-US Conus SE',1); -INSERT INTO "grid_transformation" VALUES('EPSG','10021','ETRS89 to Newlyn height (1)','May be used for transformations from WGS 84 to Newlyn.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5701','EPSG','2792',0.02,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Gbr',0); +INSERT INTO "grid_transformation" VALUES('EPSG','10021','ETRS89 to ODN height (1)','','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5701','EPSG','2792',0.02,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Gbr',0); INSERT INTO "grid_transformation" VALUES('EPSG','10022','ETRS89 to Belfast height (1)','May be used for transformations from WGS 84 to Belfast.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5732','EPSG','2530',0.03,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK NI',1); INSERT INTO "grid_transformation" VALUES('EPSG','10023','ETRS89 to Douglas height (1)','May be used for transformations from WGS 84 to Douglas.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5750','EPSG','2803',0.02,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Man',0); INSERT INTO "grid_transformation" VALUES('EPSG','10024','ETRS89 to Fair Isle height (1)','May be used for transformations from WGS 84 to Fair Isle.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5741','EPSG','2794',0.05,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Fair',0); @@ -398,7 +399,7 @@ INSERT INTO "grid_transformation" VALUES('EPSG','10025','ETRS89 to Flannan Isles INSERT INTO "grid_transformation" VALUES('EPSG','10026','ETRS89 to Foula height (1)','May be used for transformations from WGS 84 to Foula.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5743','EPSG','2796',0.05,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Foula',0); INSERT INTO "grid_transformation" VALUES('EPSG','10027','ETRS89 to Lerwick height (1)','May be used for transformations from WGS 84 to Lerwick.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5742','EPSG','2795',0.05,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Shet',0); INSERT INTO "grid_transformation" VALUES('EPSG','10028','ETRS89 to Malin Head height (1)','May be used for transformations from WGS 84 to Malin Head.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5731','EPSG','1305',0.04,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-Ire',1); -INSERT INTO "grid_transformation" VALUES('EPSG','10029','ETRS89 to Newlyn (Orkney Isles) height (1)','May be used for transformations from WGS 84 to Newlyn (Orkney Isles).','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5740','EPSG','2793',0.05,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Ork',0); +INSERT INTO "grid_transformation" VALUES('EPSG','10029','ETRS89 to ODN Orkney height (1)','','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5740','EPSG','2793',0.05,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Ork',0); INSERT INTO "grid_transformation" VALUES('EPSG','10030','ETRS89 to North Rona height (1)','May be used for transformations from WGS 84 to North Rona.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5745','EPSG','2798',0.05,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Rona',0); INSERT INTO "grid_transformation" VALUES('EPSG','10031','ETRS89 to St. Kilda height (1)','May be used for transformations from WGS 84 to St. Kilda.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5747','EPSG','2800',0.05,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Kilda',0); INSERT INTO "grid_transformation" VALUES('EPSG','10032','ETRS89 to St. Marys height (1)','May be used for transformations from WGS 84 to St. Marys.','Derivation of gravity-related heights from GPS observations.','EPSG','9663','Geographic3D to GravityRelatedHeight (OSGM-GB)','EPSG','4937','EPSG','5749','EPSG','2802',0.0,'EPSG','8666','Geoid (height correction) model file','OSTN02_OSGM02_GB.txt',NULL,NULL,NULL,NULL,NULL,NULL,'OS-UK Scilly',0); diff --git a/data/sql/grid_transformation_custom.sql b/data/sql/grid_transformation_custom.sql index 2de21f64..38210c00 100644 --- a/data/sql/grid_transformation_custom.sql +++ b/data/sql/grid_transformation_custom.sql @@ -50,12 +50,6 @@ INSERT INTO "grid_transformation" VALUES( 'EPSG','8666','Geoid (height correction) model file','SWEN17_RH2000.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); ------ Hopefully temporary entry for SeTa2016.gsb grid ----- - -INSERT INTO "area" VALUES('PROJ','SETA2016','Germany - Saarland','Germany - Saarland',49.10,49.64,6.345,7.45,0); --- Advertize a 0.8 accuracy slightly better than the 0.9 of BETA2007 for sort purposes -INSERT INTO "grid_transformation" VALUES('PROJ','SETA2016','DHDN to ETRS89 (SETA2016)','DHDN to ETRS89 for Saarland. Using official SETA2016 grid but this transformation entry has been created temporarily by PROJ. Accuracy indication not to be considered as authoritative','For applications requiring an accuracy of better than 1 metre.','EPSG','9615','NTv2','EPSG','4314','EPSG','4258','PROJ','SETA2016',0.89,'EPSG','8656','Latitude and longitude difference file','SeTa2016.gsb',NULL,NULL,NULL,NULL,NULL,NULL,'-',0); - -- Iceland INSERT INTO "grid_transformation" VALUES( @@ -68,7 +62,7 @@ INSERT INTO "grid_transformation" VALUES( NULL, 'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN2004.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); - + INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_4945_TO_EPSG_8089','ISN93 to ISH2004 height', NULL,NULL, @@ -79,7 +73,7 @@ INSERT INTO "grid_transformation" VALUES( NULL, 'EPSG','8666','Geoid (height correction) model file','Icegeoid_ISN93.gtx', NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); - + INSERT INTO "grid_transformation" VALUES( 'PROJ','EPSG_8085_TO_EPSG_8089','ISN2016 to ISH2004 height', NULL,NULL, diff --git a/data/sql/helmert_transformation.sql b/data/sql/helmert_transformation.sql index c833c4ef..14311e22 100644 --- a/data/sql/helmert_transformation.sql +++ b/data/sql/helmert_transformation.sql @@ -238,7 +238,7 @@ INSERT INTO "helmert_transformation" VALUES('EPSG','1308','NAD83 to WGS 84 (4)', INSERT INTO "helmert_transformation" VALUES('EPSG','1309','DHDN to ETRS89 (1)','Mean of 69 stations. May be taken as approximate tfm DHDN to WGS 84 (code 1673). Replaced by DHDN to ETRS89 (2) (tfm code 1776) and regional higher accuracy tfms. Note: these later tfms have been published using the Position Vector method.','For applications with an accuracy at 5 m level.','EPSG','9607','Coordinate Frame rotation (geog2D domain)','EPSG','4314','EPSG','4258','EPSG','2326',5.0,582.0,105.0,414.0,'EPSG','9001',-1.04,-0.35,3.08,'EPSG','9104',8.3,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'IfAG-Deu W',0); INSERT INTO "helmert_transformation" VALUES('EPSG','1310','Pulkovo 1942 to ETRS89 (1)','Mean of 20 stations.','Residuals under 2 m.','EPSG','9607','Coordinate Frame rotation (geog2D domain)','EPSG','4284','EPSG','4258','EPSG','1343',2.0,24.0,-123.0,-94.0,'EPSG','9001',-0.02,0.25,0.13,'EPSG','9104',1.1,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'IfAG-Deu E',1); INSERT INTO "helmert_transformation" VALUES('EPSG','1311','ED50 to WGS 84 (18)','Based on ED50 to WGS72 (precise ephemeris) 6-nations agreement of 1981 to which precise to broadcast and broadcast to WGS 84 transformations have been concatenated.','Recommended transformation for UKCS and IrishCS petroleum purposes.','EPSG','9606','Position Vector transformation (geog2D domain)','EPSG','4230','EPSG','4326','EPSG','2342',1.0,-89.5,-93.8,-123.1,'EPSG','9001',0.0,0.0,-0.156,'EPSG','9104',1.2,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UKOOA-CO',0); -INSERT INTO "helmert_transformation" VALUES('EPSG','1314','OSGB 1936 to WGS 84 (6)','For a more accurate transformation see OSGB 1936 / British National Grid to ETRS89 (2) (code 1039): contact the Ordnance Survey of Great Britain (http://www.gps.gov.uk/gpssurveying.asp) for details.','Oil exploration. Accuracy better than 4m and generally better than 2m.','EPSG','9606','Position Vector transformation (geog2D domain)','EPSG','4277','EPSG','4326','EPSG','1264',2.0,446.448,-125.157,542.06,'EPSG','9001',0.15,0.247,0.842,'EPSG','9104',-20.489,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UKOOA-Pet',0); +INSERT INTO "helmert_transformation" VALUES('EPSG','1314','OSGB 1936 to WGS 84 (6)','For a more accurate transformation see ETRS89 to OSGB 1936 / British National Grid (3) (code 7953).','Oil exploration. Accuracy better than 4m and generally better than 2m.','EPSG','9606','Position Vector transformation (geog2D domain)','EPSG','4277','EPSG','4326','EPSG','1264',2.0,446.448,-125.157,542.06,'EPSG','9001',0.15,0.247,0.842,'EPSG','9104',-20.489,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UKOOA-Pet',0); INSERT INTO "helmert_transformation" VALUES('EPSG','1315','OSGB 1936 to ED50 (UKOOA)','This transformation is concatenated from OSGB36 to WGS 84 (Petroleum) (code 1314) minus ED50 to WGS 84 (Common Offshore) (code 1311).','For oil exploration. Accuracy better than 4m and generally better than 2m.','EPSG','9606','Position Vector transformation (geog2D domain)','EPSG','4277','EPSG','4230','EPSG','1264',2.0,535.948,-31.357,665.16,'EPSG','9001',0.15,0.247,0.998,'EPSG','9104',-21.689,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UKOOA-UKCS',0); INSERT INTO "helmert_transformation" VALUES('EPSG','1316','Manoca to WGS 84 (1)','','?','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4260','EPSG','4326','EPSG','1060',999.0,-70.9,-151.8,-41.4,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SCS-Cmr',1); INSERT INTO "helmert_transformation" VALUES('EPSG','1317','Camacupa 1948 to WGS 72BE (1)','Derived by Geophysical Services Inc. in 1979 from mean of Transit results at 7 stations.','Oil exploration.','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4220','EPSG','4324','EPSG','1604',10.0,-37.2,-370.6,-228.5,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'GSI-Ago',0); @@ -1178,6 +1178,7 @@ INSERT INTO "helmert_transformation" VALUES('EPSG','9262','MMS to WGS 84 (1)','' INSERT INTO "helmert_transformation" VALUES('EPSG','9263','Hito XVIII 1963 to WGS 84 (3)','','Oil and gas exploration and production.','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4254','EPSG','4326','EPSG','2357',2.5,18.2,190.7,100.9,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'YPF-Arg TdF Hito',0); INSERT INTO "helmert_transformation" VALUES('EPSG','9264','POSGAR 2007 to WGS 84 (2)','Derived as average at all points common between the POSGAR 94 and POSGAR 2007 networks. POSGAR 94 was adjusted to the WGS 84 coordinates of 20 stations in March to May 1994. Accuracy 0.1m in 1994 + 1.5cm per year.','Oil and gas exploration and production.','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','5340','EPSG','4326','EPSG','1033',0.5,-0.41,0.46,-0.35,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'YPF-Arg',0); INSERT INTO "helmert_transformation" VALUES('EPSG','9281','Amersfoort to ETRS89 (8)','Derived using ETRF2014. In RDNAPTRANS2018 software used assuming an ETRS89 ellipsoidal height of 43m and with an additional correction grid (corrections of up to 0.25m). Replaces Amersfoort to ETRS89 (5) and (6) (tfm codes 4830 and 4831).','Accuracy 0.25m','EPSG','9607','Coordinate Frame rotation (geog2D domain)','EPSG','4289','EPSG','4258','EPSG','1275',0.25,565.7381,50.4018,465.2904,'EPSG','9001',1.91514,-1.60363,9.09546,'EPSG','9109',4.07244,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'IOGP-Nld 2018',0); +INSERT INTO "helmert_transformation" VALUES('EPSG','9298','ONGD17 to WGS 84 (1)','','Geodesy.','EPSG','1032','Coordinate Frame rotation (geocentric domain)','EPSG','9292','EPSG','4978','EPSG','1183',0.1,1.16835,-1.42001,-2.24431,'EPSG','9001',0.00822,0.05508,-0.01818,'EPSG','9104',0.23388,'EPSG','9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NSA-Omn',0); INSERT INTO "helmert_transformation" VALUES('EPSG','9334','ITRF2014 to KSA-GRF17 (1)','Arabian plate rotations derived during KSA-GRF17 adjustment from observations at 41 sites with at least 2.5 years of continuous observations.','Geodesy.','EPSG','1053','Time-dependent Position Vector tfm (geocentric)','EPSG','7789','EPSG','9331','EPSG','1206',0.001,0.0,0.0,0.0,'EPSG','1025',0.0,0.0,0.0,'EPSG','1031',0.0,'EPSG','1028',0.0,0.0,0.0,'EPSG','1027',-1.199,0.107,-1.468,'EPSG','1032',0.0,'EPSG','1030',2017.0,'EPSG','1029',NULL,NULL,NULL,NULL,NULL,'GCS-Sau',0); INSERT INTO "helmert_transformation" VALUES('EPSG','10085','Trinidad 1903 to WGS 84 (2)','Parameter values provided to EOG by Trinidad Ministry of Energy and Energy Industries. Used by EOG offshore Trinidad (including Pelican, Kiskadee and Ibis fields) since 1996.','Oil exploration.','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4302','EPSG','4326','EPSG','1339',3.0,-61.0,285.2,471.6,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'EOG-Tto Trin',0); INSERT INTO "helmert_transformation" VALUES('EPSG','10086','JAD69 to WGS 72 (1)','Derived in 1977 through Transit observations at 2 stations by US DMA.','For military mapping.','EPSG','9603','Geocentric translations (geog2D domain)','EPSG','4242','EPSG','4322','EPSG','3342',15.0,48.0,208.0,382.0,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'SD-Jam',0); diff --git a/data/sql/metadata.sql b/data/sql/metadata.sql index cadc91dd..21a42e9d 100644 --- a/data/sql/metadata.sql +++ b/data/sql/metadata.sql @@ -1,2 +1,2 @@ -INSERT INTO "metadata" VALUES('EPSG.VERSION', 'v9.8.7'); -INSERT INTO "metadata" VALUES('EPSG.DATE', '2020-02-25'); +INSERT INTO "metadata" VALUES('EPSG.VERSION', 'v9.8.9'); +INSERT INTO "metadata" VALUES('EPSG.DATE', '2020-04-07'); diff --git a/data/sql/projected_crs.sql b/data/sql/projected_crs.sql index e2a29bc2..6eca6bfa 100644 --- a/data/sql/projected_crs.sql +++ b/data/sql/projected_crs.sql @@ -163,7 +163,7 @@ INSERT INTO "projected_crs" VALUES('EPSG','2159','Sierra Leone 1924 / New Colony INSERT INTO "projected_crs" VALUES('EPSG','2160','Sierra Leone 1924 / New War Office Grid',NULL,NULL,'EPSG','4404','EPSG','4174','EPSG','19964','EPSG','1342',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','2161','Sierra Leone 1968 / UTM zone 28N',NULL,NULL,'EPSG','4400','EPSG','4175','EPSG','16028','EPSG','1509',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','2162','Sierra Leone 1968 / UTM zone 29N',NULL,NULL,'EPSG','4400','EPSG','4175','EPSG','16029','EPSG','1510',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','2163','US National Atlas Equal Area',NULL,NULL,'EPSG','4499','EPSG','4052','EPSG','3899','EPSG','1245',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','2163','US National Atlas Equal Area',NULL,NULL,'EPSG','4499','EPSG','4052','EPSG','3899','EPSG','1245',NULL,1); INSERT INTO "projected_crs" VALUES('EPSG','2164','Locodjo 1965 / TM 5 NW',NULL,NULL,'EPSG','4400','EPSG','4142','EPSG','17005','EPSG','2296',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','2165','Abidjan 1987 / TM 5 NW',NULL,NULL,'EPSG','4400','EPSG','4143','EPSG','17005','EPSG','2296',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','2166','Pulkovo 1942(83) / Gauss Kruger zone 3',NULL,NULL,'EPSG','4530','EPSG','4178','EPSG','16263','EPSG','1512',NULL,1); @@ -1307,7 +1307,7 @@ INSERT INTO "projected_crs" VALUES('EPSG','3312','CSG67 / UTM zone 21N',NULL,NUL INSERT INTO "projected_crs" VALUES('EPSG','3313','RGFG95 / UTM zone 21N',NULL,NULL,'EPSG','4400','EPSG','4624','EPSG','16021','EPSG','3145',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','3314','Katanga 1955 / Katanga Lambert',NULL,NULL,'EPSG','4400','EPSG','4695','EPSG','17401','EPSG','3147',NULL,1); INSERT INTO "projected_crs" VALUES('EPSG','3315','Katanga 1955 / Katanga TM',NULL,NULL,'EPSG','4400','EPSG','4695','EPSG','17402','EPSG','3147',NULL,1); -INSERT INTO "projected_crs" VALUES('EPSG','3316','Kasai 1953 / Congo TM zone 22',NULL,NULL,'EPSG','4400','EPSG','4696','EPSG','17422','EPSG','3163',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','3316','Kasai 1953 / Congo TM zone 22',NULL,NULL,'EPSG','4400','EPSG','4696','EPSG','17422','EPSG','4587',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','3317','Kasai 1953 / Congo TM zone 24',NULL,NULL,'EPSG','4400','EPSG','4696','EPSG','17424','EPSG','3164',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','3318','IGC 1962 / Congo TM zone 12',NULL,NULL,'EPSG','4400','EPSG','4697','EPSG','17412','EPSG','3150',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','3319','IGC 1962 / Congo TM zone 14',NULL,NULL,'EPSG','4400','EPSG','4697','EPSG','17414','EPSG','3151',NULL,0); @@ -1399,11 +1399,11 @@ INSERT INTO "projected_crs" VALUES('EPSG','3404','NAD83(HARN) / North Carolina ( INSERT INTO "projected_crs" VALUES('EPSG','3405','VN-2000 / UTM zone 48N',NULL,NULL,'EPSG','4400','EPSG','4756','EPSG','16048','EPSG','1452',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','3406','VN-2000 / UTM zone 49N',NULL,NULL,'EPSG','4400','EPSG','4756','EPSG','16049','EPSG','1453',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','3407','Hong Kong 1963 Grid System',NULL,NULL,'EPSG','4502','EPSG','4738','EPSG','19896','EPSG','1118',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','3408','NSIDC EASE-Grid North',NULL,NULL,'EPSG','4469','EPSG','4053','EPSG','3897','EPSG','3475',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','3409','NSIDC EASE-Grid South',NULL,NULL,'EPSG','4470','EPSG','4053','EPSG','3898','EPSG','3474',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','3410','NSIDC EASE-Grid Global',NULL,NULL,'EPSG','4499','EPSG','4053','EPSG','19869','EPSG','3463',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','3411','NSIDC Sea Ice Polar Stereographic North',NULL,NULL,'EPSG','4468','EPSG','4054','EPSG','19865','EPSG','1996',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','3412','NSIDC Sea Ice Polar Stereographic South',NULL,NULL,'EPSG','4470','EPSG','4054','EPSG','19866','EPSG','1997',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','3408','NSIDC EASE-Grid North',NULL,NULL,'EPSG','4469','EPSG','4053','EPSG','3897','EPSG','3475',NULL,1); +INSERT INTO "projected_crs" VALUES('EPSG','3409','NSIDC EASE-Grid South',NULL,NULL,'EPSG','4470','EPSG','4053','EPSG','3898','EPSG','3474',NULL,1); +INSERT INTO "projected_crs" VALUES('EPSG','3410','NSIDC EASE-Grid Global',NULL,NULL,'EPSG','4499','EPSG','4053','EPSG','19869','EPSG','3463',NULL,1); +INSERT INTO "projected_crs" VALUES('EPSG','3411','NSIDC Sea Ice Polar Stereographic North',NULL,NULL,'EPSG','4468','EPSG','4054','EPSG','19865','EPSG','1996',NULL,1); +INSERT INTO "projected_crs" VALUES('EPSG','3412','NSIDC Sea Ice Polar Stereographic South',NULL,NULL,'EPSG','4470','EPSG','4054','EPSG','19866','EPSG','1997',NULL,1); INSERT INTO "projected_crs" VALUES('EPSG','3413','WGS 84 / NSIDC Sea Ice Polar Stereographic North',NULL,NULL,'EPSG','4468','EPSG','4326','EPSG','19865','EPSG','1996',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','3414','SVY21 / Singapore TM',NULL,NULL,'EPSG','4500','EPSG','4757','EPSG','19864','EPSG','1210',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','3415','WGS 72BE / South China Sea Lambert',NULL,NULL,'EPSG','4400','EPSG','4324','EPSG','19863','EPSG','3470',NULL,0); @@ -1898,7 +1898,7 @@ INSERT INTO "projected_crs" VALUES('EPSG','4071','Chua / UTM zone 23S',NULL,NULL INSERT INTO "projected_crs" VALUES('EPSG','4082','REGCAN95 / UTM zone 27N',NULL,NULL,'EPSG','4400','EPSG','4081','EPSG','16027','EPSG','3629',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','4083','REGCAN95 / UTM zone 28N',NULL,NULL,'EPSG','4400','EPSG','4081','EPSG','16028','EPSG','3630',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','4087','WGS 84 / World Equidistant Cylindrical',NULL,NULL,'EPSG','4499','EPSG','4326','EPSG','4085','EPSG','1262',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','4088','World Equidistant Cylindrical (Sphere)',NULL,NULL,'EPSG','4499','EPSG','4047','EPSG','4086','EPSG','1262',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','4088','World Equidistant Cylindrical (Sphere)',NULL,NULL,'EPSG','4499','EPSG','4047','EPSG','4086','EPSG','1262',NULL,1); INSERT INTO "projected_crs" VALUES('EPSG','4093','ETRS89 / DKTM1',NULL,NULL,'EPSG','4400','EPSG','4258','EPSG','4089','EPSG','3631',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','4094','ETRS89 / DKTM2',NULL,NULL,'EPSG','4400','EPSG','4258','EPSG','4090','EPSG','3632',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','4095','ETRS89 / DKTM3',NULL,NULL,'EPSG','4400','EPSG','4258','EPSG','4091','EPSG','2532',NULL,0); @@ -2282,8 +2282,8 @@ INSERT INTO "projected_crs" VALUES('EPSG','5532','SAD69(96) / UTM zone 22S',NULL INSERT INTO "projected_crs" VALUES('EPSG','5533','SAD69(96) / UTM zone 23S',NULL,NULL,'EPSG','4400','EPSG','5527','EPSG','16123','EPSG','3445',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','5534','SAD69(96) / UTM zone 24S',NULL,NULL,'EPSG','4400','EPSG','5527','EPSG','16124','EPSG','3446',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','5535','SAD69(96) / UTM zone 25S',NULL,NULL,'EPSG','4400','EPSG','5527','EPSG','16125','EPSG','3447',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','5536','Corrego Alegre 1961 / UTM zone 21S',NULL,NULL,'EPSG','4400','EPSG','5524','EPSG','16121','EPSG','3355',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','5537','Corrego Alegre 1961 / UTM zone 22S',NULL,NULL,'EPSG','4400','EPSG','5524','EPSG','16122','EPSG','3176',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','5536','Corrego Alegre 1961 / UTM zone 21S',NULL,NULL,'EPSG','4400','EPSG','5524','EPSG','16121','EPSG','4574',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','5537','Corrego Alegre 1961 / UTM zone 22S',NULL,NULL,'EPSG','4400','EPSG','5524','EPSG','16122','EPSG','4576',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','5538','Corrego Alegre 1961 / UTM zone 23S',NULL,NULL,'EPSG','4400','EPSG','5524','EPSG','16123','EPSG','3177',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','5539','Corrego Alegre 1961 / UTM zone 24S',NULL,NULL,'EPSG','4400','EPSG','5524','EPSG','16124','EPSG','3877',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','5550','PNG94 / PNGMG94 zone 54',NULL,NULL,'EPSG','4400','EPSG','5546','EPSG','5547','EPSG','3882',NULL,0); @@ -2379,7 +2379,7 @@ INSERT INTO "projected_crs" VALUES('EPSG','5877','SAD69(96) / UTM zone 20S',NULL INSERT INTO "projected_crs" VALUES('EPSG','5879','Cadastre 1997 / UTM zone 38S',NULL,NULL,'EPSG','4400','EPSG','4475','EPSG','16138','EPSG','3340',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','5880','SIRGAS 2000 / Brazil Polyconic',NULL,NULL,'EPSG','4499','EPSG','4674','EPSG','19941','EPSG','1053',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','5887','TGD2005 / Tonga Map Grid',NULL,NULL,'EPSG','4400','EPSG','5886','EPSG','5883','EPSG','1234',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','5890','JAXA Snow Depth Polar Stereographic North',NULL,NULL,'EPSG','1035','EPSG','4054','EPSG','5889','EPSG','1996',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','5890','JAXA Snow Depth Polar Stereographic North',NULL,NULL,'EPSG','1035','EPSG','4054','EPSG','5889','EPSG','1996',NULL,1); INSERT INTO "projected_crs" VALUES('EPSG','5896','VN-2000 / TM-3 zone 481',NULL,NULL,'EPSG','4400','EPSG','4756','EPSG','5892','EPSG','4193',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','5897','VN-2000 / TM-3 zone 482',NULL,NULL,'EPSG','4400','EPSG','4756','EPSG','5893','EPSG','4215',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','5898','VN-2000 / TM-3 zone 491',NULL,NULL,'EPSG','4400','EPSG','4756','EPSG','5894','EPSG','4217',NULL,0); @@ -3611,6 +3611,10 @@ INSERT INTO "projected_crs" VALUES('EPSG','9272','MGI / Austria Central',NULL,NU INSERT INTO "projected_crs" VALUES('EPSG','9273','MGI / Austria East',NULL,NULL,'EPSG','4530','EPSG','4312','EPSG','9270','EPSG','1708',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','9284','Pampa del Castillo / Argentina 1',NULL,NULL,'EPSG','4530','EPSG','4161','EPSG','18031','EPSG','4564',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','9285','Pampa del Castillo / Argentina 3',NULL,NULL,'EPSG','4530','EPSG','4161','EPSG','18033','EPSG','4565',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','9295','ONGD17 / UTM zone 39N',NULL,NULL,'EPSG','4400','EPSG','9294','EPSG','16039','EPSG','4322',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','9296','ONGD17 / UTM zone 40N',NULL,NULL,'EPSG','4400','EPSG','9294','EPSG','16040','EPSG','4323',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','9297','ONGD17 / UTM zone 41N',NULL,NULL,'EPSG','4400','EPSG','9294','EPSG','16041','EPSG','4324',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','9311','NAD27 / US National Atlas Equal Area',NULL,NULL,'EPSG','4499','EPSG','4267','EPSG','3899','EPSG','1245',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','20004','Pulkovo 1995 / Gauss-Kruger zone 4',NULL,NULL,'EPSG','4530','EPSG','4200','EPSG','16204','EPSG','1763',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','20005','Pulkovo 1995 / Gauss-Kruger zone 5',NULL,NULL,'EPSG','4530','EPSG','4200','EPSG','16205','EPSG','1764',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','20006','Pulkovo 1995 / Gauss-Kruger zone 6',NULL,NULL,'EPSG','4530','EPSG','4200','EPSG','16206','EPSG','1765',NULL,0); @@ -3789,9 +3793,9 @@ INSERT INTO "projected_crs" VALUES('EPSG','22185','POSGAR 94 / Argentina 5',NULL INSERT INTO "projected_crs" VALUES('EPSG','22186','POSGAR 94 / Argentina 6',NULL,NULL,'EPSG','4530','EPSG','4694','EPSG','18036','EPSG','1613',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','22187','POSGAR 94 / Argentina 7',NULL,NULL,'EPSG','4530','EPSG','4694','EPSG','18037','EPSG','1614',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','22191','Campo Inchauspe / Argentina 1',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18031','EPSG','1608',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','22192','Campo Inchauspe / Argentina 2',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18032','EPSG','1609',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','22193','Campo Inchauspe / Argentina 3',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18033','EPSG','1610',NULL,0); -INSERT INTO "projected_crs" VALUES('EPSG','22194','Campo Inchauspe / Argentina 4',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18034','EPSG','1611',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','22192','Campo Inchauspe / Argentina 2',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18032','EPSG','4577',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','22193','Campo Inchauspe / Argentina 3',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18033','EPSG','4578',NULL,0); +INSERT INTO "projected_crs" VALUES('EPSG','22194','Campo Inchauspe / Argentina 4',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18034','EPSG','4579',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','22195','Campo Inchauspe / Argentina 5',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18035','EPSG','1612',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','22196','Campo Inchauspe / Argentina 6',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18036','EPSG','1613',NULL,0); INSERT INTO "projected_crs" VALUES('EPSG','22197','Campo Inchauspe / Argentina 7',NULL,NULL,'EPSG','4530','EPSG','4221','EPSG','18037','EPSG','1614',NULL,0); diff --git a/data/sql/vertical_crs.sql b/data/sql/vertical_crs.sql index a531ce62..2cfb77df 100644 --- a/data/sql/vertical_crs.sql +++ b/data/sql/vertical_crs.sql @@ -78,9 +78,9 @@ INSERT INTO "vertical_crs" VALUES('EPSG','5743','Foula height',NULL,NULL,'EPSG', INSERT INTO "vertical_crs" VALUES('EPSG','5744','Sule Skerry height',NULL,NULL,'EPSG','6499','EPSG','5142','EPSG','2797',0); INSERT INTO "vertical_crs" VALUES('EPSG','5745','North Rona height',NULL,NULL,'EPSG','6499','EPSG','5143','EPSG','2798',0); INSERT INTO "vertical_crs" VALUES('EPSG','5746','Stornoway height',NULL,NULL,'EPSG','6499','EPSG','5144','EPSG','2799',0); -INSERT INTO "vertical_crs" VALUES('EPSG','5747','St Kilda height',NULL,NULL,'EPSG','6499','EPSG','5145','EPSG','2800',0); +INSERT INTO "vertical_crs" VALUES('EPSG','5747','St. Kilda height',NULL,NULL,'EPSG','6499','EPSG','5145','EPSG','2800',0); INSERT INTO "vertical_crs" VALUES('EPSG','5748','Flannan Isles height',NULL,NULL,'EPSG','6499','EPSG','5146','EPSG','2801',0); -INSERT INTO "vertical_crs" VALUES('EPSG','5749','St Marys height',NULL,NULL,'EPSG','6499','EPSG','5147','EPSG','2802',0); +INSERT INTO "vertical_crs" VALUES('EPSG','5749','St. Marys height',NULL,NULL,'EPSG','6499','EPSG','5147','EPSG','2802',0); INSERT INTO "vertical_crs" VALUES('EPSG','5750','Douglas height',NULL,NULL,'EPSG','6499','EPSG','5148','EPSG','2803',0); INSERT INTO "vertical_crs" VALUES('EPSG','5751','Fao height',NULL,NULL,'EPSG','6499','EPSG','5149','EPSG','3390',0); INSERT INTO "vertical_crs" VALUES('EPSG','5752','Bandar Abbas height',NULL,NULL,'EPSG','6499','EPSG','5150','EPSG','3336',0); diff --git a/data/sql/vertical_datum.sql b/data/sql/vertical_datum.sql index e0b14325..6c31172e 100644 --- a/data/sql/vertical_datum.sql +++ b/data/sql/vertical_datum.sql @@ -128,9 +128,9 @@ INSERT INTO "vertical_datum" VALUES('EPSG','5141','Foula',NULL,NULL,'EPSG','2796 INSERT INTO "vertical_datum" VALUES('EPSG','5142','Sule Skerry',NULL,NULL,'EPSG','2797',NULL,0); INSERT INTO "vertical_datum" VALUES('EPSG','5143','North Rona',NULL,NULL,'EPSG','2798',NULL,0); INSERT INTO "vertical_datum" VALUES('EPSG','5144','Stornoway',NULL,NULL,'EPSG','2799',NULL,0); -INSERT INTO "vertical_datum" VALUES('EPSG','5145','St Kilda',NULL,NULL,'EPSG','2800',NULL,0); +INSERT INTO "vertical_datum" VALUES('EPSG','5145','St. Kilda',NULL,NULL,'EPSG','2800',NULL,0); INSERT INTO "vertical_datum" VALUES('EPSG','5146','Flannan Isles',NULL,NULL,'EPSG','2801',NULL,0); -INSERT INTO "vertical_datum" VALUES('EPSG','5147','St Marys',NULL,NULL,'EPSG','2802',NULL,0); +INSERT INTO "vertical_datum" VALUES('EPSG','5147','St. Marys',NULL,NULL,'EPSG','2802',NULL,0); INSERT INTO "vertical_datum" VALUES('EPSG','5148','Douglas',NULL,NULL,'EPSG','2803',NULL,0); INSERT INTO "vertical_datum" VALUES('EPSG','5149','Fao',NULL,NULL,'EPSG','3390',NULL,0); INSERT INTO "vertical_datum" VALUES('EPSG','5150','Bandar Abbas',NULL,NULL,'EPSG','3336','2001-01-01',0); |