diff options
| author | Even Rouault <even.rouault@spatialys.com> | 2021-09-15 00:32:58 +0200 |
|---|---|---|
| committer | Even Rouault <even.rouault@spatialys.com> | 2021-09-15 00:32:58 +0200 |
| commit | 85f496b26702bf6566296072795e821d70156c09 (patch) | |
| tree | 3085b80ac1ceb0dba3c58946f8b1f9246f651d55 /data/sql/geodetic_crs.sql | |
| parent | d3c615f9ce893c9dc1e6314b9542f510bfd0f023 (diff) | |
| download | PROJ-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/geodetic_crs.sql')
| -rw-r--r-- | data/sql/geodetic_crs.sql | 30 |
1 files changed, 25 insertions, 5 deletions
diff --git a/data/sql/geodetic_crs.sql b/data/sql/geodetic_crs.sql index ecb99c41..019c18c8 100644 --- a/data/sql/geodetic_crs.sql +++ b/data/sql/geodetic_crs.sql @@ -230,7 +230,7 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','4169','American Samoa 1962',NULL,'geog INSERT INTO "usage" VALUES('EPSG','3054','geodetic_crs','EPSG','4169','EPSG','3109','EPSG','1027'); INSERT INTO "geodetic_crs" VALUES('EPSG','4170','SIRGAS 1995',NULL,'geographic 2D','EPSG','6422','EPSG','6170',NULL,0); INSERT INTO "usage" VALUES('EPSG','3055','geodetic_crs','EPSG','4170','EPSG','3448','EPSG','1183'); -INSERT INTO "geodetic_crs" VALUES('EPSG','4171','RGF93',NULL,'geographic 2D','EPSG','6422','EPSG','6171',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','4171','RGF93 v1',NULL,'geographic 2D','EPSG','6422','EPSG','6171',NULL,0); INSERT INTO "usage" VALUES('EPSG','3056','geodetic_crs','EPSG','4171','EPSG','1096','EPSG','1183'); INSERT INTO "geodetic_crs" VALUES('EPSG','4172','POSGAR',NULL,'geographic 2D','EPSG','6402','EPSG','6172',NULL,1); INSERT INTO "usage" VALUES('EPSG','3057','geodetic_crs','EPSG','4172','EPSG','1033','EPSG','1027'); @@ -1204,9 +1204,9 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','4962','REGVEN',NULL,'geocentric','EPSG INSERT INTO "usage" VALUES('EPSG','3762','geodetic_crs','EPSG','4962','EPSG','1251','EPSG','1027'); INSERT INTO "geodetic_crs" VALUES('EPSG','4963','REGVEN',NULL,'geographic 3D','EPSG','6423','EPSG','6189',NULL,0); INSERT INTO "usage" VALUES('EPSG','3763','geodetic_crs','EPSG','4963','EPSG','1251','EPSG','1027'); -INSERT INTO "geodetic_crs" VALUES('EPSG','4964','RGF93',NULL,'geocentric','EPSG','6500','EPSG','6171',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','4964','RGF93 v1',NULL,'geocentric','EPSG','6500','EPSG','6171',NULL,0); INSERT INTO "usage" VALUES('EPSG','3764','geodetic_crs','EPSG','4964','EPSG','1096','EPSG','1027'); -INSERT INTO "geodetic_crs" VALUES('EPSG','4965','RGF93',NULL,'geographic 3D','EPSG','6423','EPSG','6171',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','4965','RGF93 v1',NULL,'geographic 3D','EPSG','6423','EPSG','6171',NULL,0); INSERT INTO "usage" VALUES('EPSG','3765','geodetic_crs','EPSG','4965','EPSG','1096','EPSG','1182'); INSERT INTO "geodetic_crs" VALUES('EPSG','4966','RGFG95',NULL,'geocentric','EPSG','6500','EPSG','6624',NULL,0); INSERT INTO "usage" VALUES('EPSG','3766','geodetic_crs','EPSG','4966','EPSG','1097','EPSG','1027'); @@ -1518,7 +1518,7 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','7040','RGFG95 (lon-lat)',NULL,'geograp INSERT INTO "usage" VALUES('EPSG','5081','geodetic_crs','EPSG','7040','EPSG','1097','EPSG','1189'); INSERT INTO "geodetic_crs" VALUES('EPSG','7041','RGFG95 (lon-lat)',NULL,'geographic 2D','EPSG','6424','EPSG','6624',NULL,0); INSERT INTO "usage" VALUES('EPSG','5082','geodetic_crs','EPSG','7041','EPSG','1097','EPSG','1189'); -INSERT INTO "geodetic_crs" VALUES('EPSG','7042','RGF93 (lon-lat)',NULL,'geographic 3D','EPSG','6426','EPSG','6171',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','7042','RGF93 v1 (lon-lat)',NULL,'geographic 3D','EPSG','6426','EPSG','6171',NULL,0); INSERT INTO "usage" VALUES('EPSG','5083','geodetic_crs','EPSG','7042','EPSG','1096','EPSG','1189'); INSERT INTO "geodetic_crs" VALUES('EPSG','7071','RGTAAF07',NULL,'geocentric','EPSG','6500','EPSG','1113',NULL,0); INSERT INTO "usage" VALUES('EPSG','5098','geodetic_crs','EPSG','7071','EPSG','4246','EPSG','1027'); @@ -1526,7 +1526,7 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','7072','RGTAAF07',NULL,'geographic 3D', INSERT INTO "usage" VALUES('EPSG','5099','geodetic_crs','EPSG','7072','EPSG','4246','EPSG','1182'); INSERT INTO "geodetic_crs" VALUES('EPSG','7073','RGTAAF07',NULL,'geographic 2D','EPSG','6422','EPSG','1113',NULL,0); INSERT INTO "usage" VALUES('EPSG','5100','geodetic_crs','EPSG','7073','EPSG','4246','EPSG','1183'); -INSERT INTO "geodetic_crs" VALUES('EPSG','7084','RGF93 (lon-lat)',NULL,'geographic 2D','EPSG','6424','EPSG','6171',NULL,0); +INSERT INTO "geodetic_crs" VALUES('EPSG','7084','RGF93 v1 (lon-lat)',NULL,'geographic 2D','EPSG','6424','EPSG','6171',NULL,0); INSERT INTO "usage" VALUES('EPSG','5110','geodetic_crs','EPSG','7084','EPSG','1096','EPSG','1189'); INSERT INTO "geodetic_crs" VALUES('EPSG','7085','RGAF09 (lon-lat)',NULL,'geographic 3D','EPSG','6426','EPSG','1073',NULL,0); INSERT INTO "usage" VALUES('EPSG','5111','geodetic_crs','EPSG','7085','EPSG','2824','EPSG','1189'); @@ -2132,3 +2132,23 @@ INSERT INTO "geodetic_crs" VALUES('EPSG','9758','ECML14_NB-IRF',NULL,'geographic INSERT INTO "usage" VALUES('EPSG','16495','geodetic_crs','EPSG','9758','EPSG','4621','EPSG','1141'); INSERT INTO "geodetic_crs" VALUES('EPSG','9763','EWR2-IRF',NULL,'geographic 2D','EPSG','6422','EPSG','1311',NULL,0); INSERT INTO "usage" VALUES('EPSG','16507','geodetic_crs','EPSG','9763','EPSG','4622','EPSG','1141'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9775','RGF93 v2',NULL,'geocentric','EPSG','6500','EPSG','1312',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16642','geodetic_crs','EPSG','9775','EPSG','1096','EPSG','1027'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9776','RGF93 v2',NULL,'geographic 3D','EPSG','6423','EPSG','1312',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16641','geodetic_crs','EPSG','9776','EPSG','1096','EPSG','1182'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9777','RGF93 v2',NULL,'geographic 2D','EPSG','6422','EPSG','1312',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16643','geodetic_crs','EPSG','9777','EPSG','1096','EPSG','1183'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9778','RGF93 v2 (lon-lat)',NULL,'geographic 3D','EPSG','6426','EPSG','1312',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16647','geodetic_crs','EPSG','9778','EPSG','1096','EPSG','1189'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9779','RGF93 v2 (lon-lat)',NULL,'geographic 2D','EPSG','6424','EPSG','1312',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16646','geodetic_crs','EPSG','9779','EPSG','1096','EPSG','1189'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9780','RGF93 v2b',NULL,'geocentric','EPSG','6500','EPSG','1313',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16649','geodetic_crs','EPSG','9780','EPSG','1096','EPSG','1027'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9781','RGF93 v2b',NULL,'geographic 3D','EPSG','6423','EPSG','1313',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16650','geodetic_crs','EPSG','9781','EPSG','1096','EPSG','1182'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9782','RGF93 v2b',NULL,'geographic 2D','EPSG','6422','EPSG','1313',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16651','geodetic_crs','EPSG','9782','EPSG','1096','EPSG','1183'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9783','RGF93 v2b (lon-lat)',NULL,'geographic 3D','EPSG','6426','EPSG','1313',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16652','geodetic_crs','EPSG','9783','EPSG','1096','EPSG','1189'); +INSERT INTO "geodetic_crs" VALUES('EPSG','9784','RGF93 v2b (lon-lat)',NULL,'geographic 2D','EPSG','6424','EPSG','1313',NULL,0); +INSERT INTO "usage" VALUES('EPSG','16653','geodetic_crs','EPSG','9784','EPSG','1096','EPSG','1189'); |
