aboutsummaryrefslogtreecommitdiff
path: root/data/sql/alias_name.sql
diff options
context:
space:
mode:
authorEven Rouault <even.rouault@spatialys.com>2021-09-15 00:32:58 +0200
committerEven Rouault <even.rouault@spatialys.com>2021-09-15 00:32:58 +0200
commit85f496b26702bf6566296072795e821d70156c09 (patch)
tree3085b80ac1ceb0dba3c58946f8b1f9246f651d55 /data/sql/alias_name.sql
parentd3c615f9ce893c9dc1e6314b9542f510bfd0f023 (diff)
downloadPROJ-85f496b26702bf6566296072795e821d70156c09.tar.gz
PROJ-85f496b26702bf6566296072795e821d70156c09.zip
Database: update to EPSG v10.035
This seriously impacts French CRS users with the introduction of new datums, geodetic CRS and projected CRS based on "RGF 93 v2" and "RGF 93 v2b", and the previous single "RGF 93" being renamed as "RGF 93 v1". To be noted too, the addition of a null transformation between NAD83(2011) and WGS 84, which impacts a number of tests in the test suite.
Diffstat (limited to 'data/sql/alias_name.sql')
-rw-r--r--data/sql/alias_name.sql43
1 files changed, 40 insertions, 3 deletions
diff --git a/data/sql/alias_name.sql b/data/sql/alias_name.sql
index cf636a52..3d23d1a5 100644
--- a/data/sql/alias_name.sql
+++ b/data/sql/alias_name.sql
@@ -51,7 +51,7 @@ INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6156','S-JTSK','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6159','ELD79','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6163','YNGN96','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6170','SIRGAS 1995','EPSG');
-INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6171','RGF93','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6171','RGF93 v1','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6172','POSGAR','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6202','AGD66','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6203','AGD84','EPSG');
@@ -633,6 +633,11 @@ INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6809','BD50 (Brussels)'
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1310','ECML14_NB-IRF','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6151','Swiss Terrestrial Reference Frame 1995 (CHTRF95)','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1311','EWR2-IRF','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','6171','Reseau Geodesique Francais 1993','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1312','RGF93 v2','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1312','Réseau Géodésique Français 1993','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1313','RGF93 v2b','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1313','Réseau Géodésique Français 1993','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1193','NAD83(CSRS) 1997','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1194','NAD83(CSRS) 1997','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_datum','EPSG','1195','NAD83(CSRS) 2002','EPSG');
@@ -4298,8 +4303,8 @@ INSERT INTO "alias_name" VALUES('projected_crs','EPSG','20137','Blue Nile 1958
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','20138','Blue Nile 1958 / UTM zone 38N','EPSG');
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6307','NAD83(CORS96) / PR and VI','EPSG');
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','6312','CGRS93 / Local Transverse Mercator (LTM)','EPSG');
-INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4171','RGF93 (lat-lon)','EPSG');
-INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4965','RGF93 (lat-lon)','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4171','RGF93 v1 (lat-lon)','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4965','RGF93 v1 (lat-lon)','EPSG');
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7057','NAD83(2011) / IaRCS zone 1 Spencer','EPSG');
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7058','NAD83(2011) / IaRCS zone 2 Mason City','EPSG');
INSERT INTO "alias_name" VALUES('projected_crs','EPSG','7059','NAD83(2011) / IaRCS zone 3 Elkader','EPSG');
@@ -7361,6 +7366,30 @@ INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9767','ETRS89 / EWR2 Snak
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4932','CHTRF95','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4933','CHTRF95','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4151','CHTRF95','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4964','RGF93','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4965','RGF93','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','4171','RGF93','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','7042','RGF93 (lon-lat)','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','7084','RGF93 (lon-lat)','EPSG');
+INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9538','RGF93 + NGF-IGN69 height','EPSG');
+INSERT INTO "alias_name" VALUES('compound_crs','EPSG','9539','RGF93 + NGF-IGN78 height','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','2154','RGF93 / Lambert-93','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3942','RGF93 / CC42','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3943','RGF93 / CC43','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3944','RGF93 / CC44','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3945','RGF93 / CC45','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3946','RGF93 / CC46','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3947','RGF93 / CC47','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3948','RGF93 / CC48','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3949','RGF93 / CC49','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','3950','RGF93 / CC50','EPSG');
+INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5698','RGF93 / Lambert-93 + NGF-IGN69 height','EPSG');
+INSERT INTO "alias_name" VALUES('compound_crs','EPSG','5699','RGF93 / Lambert-93 + NGF-IGN78 height','EPSG');
+INSERT INTO "alias_name" VALUES('projected_crs','EPSG','9793','(FR_RGF93 / LAMB93 - see alias remarks)','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9776','RGF93 v2 (lat-lon)','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9777','RGF93 v2 (lat-lon)','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9781','RGF93 v2b (lat-lon)','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9782','RGF93 v2b (lat-lon)','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8233','NAD83(CSRS) 1997','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8235','NAD83(CSRS) 1997','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8237','NAD83(CSRS) 1997','EPSG');
@@ -7379,3 +7408,11 @@ INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8252','NAD83(CSRS) 2010',
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8253','NAD83(CSRS) 2010','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8254','NAD83(CSRS) 2010','EPSG');
INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','8255','NAD83(CSRS) 2010','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9331','777','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9331','KSA-GRF17 - XYZ','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9332','778','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9332','KSA-GRF17 - LatLonEHt','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9333','779','EPSG');
+INSERT INTO "alias_name" VALUES('geodetic_crs','EPSG','9333','KSA-GRF17 - LatLon','EPSG');
+INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9335','780','EPSG');
+INSERT INTO "alias_name" VALUES('vertical_crs','EPSG','9335','KSA-VRF14 - OHt','EPSG');