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.

1 files changed, 50 insertions, 10 deletions

diff --git a/data/sql/projected_crs.sql b/data/sql/projected_crs.sql
index b14d0677..53a6895a 100644
--- a/data/sql/projected_crs.sql
+++ b/data/sql/projected_crs.sql
@@ -308,7 +308,7 @@ INSERT INTO "projected_crs" VALUES('EPSG','2152','NAD83(CSRS98) / UTM zone 12N',
 INSERT INTO "usage" VALUES('EPSG','1176','projected_crs','EPSG','2152','EPSG','1507','EPSG','1142');
 INSERT INTO "projected_crs" VALUES('EPSG','2153','NAD83(CSRS98) / UTM zone 11N',NULL,'EPSG','4400','EPSG','4140','EPSG','16011',NULL,1);
 INSERT INTO "usage" VALUES('EPSG','1177','projected_crs','EPSG','2153','EPSG','1508','EPSG','1142');
-INSERT INTO "projected_crs" VALUES('EPSG','2154','RGF93 / Lambert-93',NULL,'EPSG','4499','EPSG','4171','EPSG','18085',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','2154','RGF93 v1 / Lambert-93',NULL,'EPSG','4499','EPSG','4171','EPSG','18085',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','1178','projected_crs','EPSG','2154','EPSG','1096','EPSG','1142');
 INSERT INTO "projected_crs" VALUES('EPSG','2155','American Samoa 1962 / American Samoa Lambert',NULL,'EPSG','4497','EPSG','4169','EPSG','15300',NULL,1);
 INSERT INTO "usage" VALUES('EPSG','1179','projected_crs','EPSG','2155','EPSG','1027','EPSG','1142');
@@ -3703,23 +3703,23 @@ INSERT INTO "projected_crs" VALUES('EPSG','3912','MGI 1901 / Slovene National Gr
 INSERT INTO "usage" VALUES('EPSG','2890','projected_crs','EPSG','3912','EPSG','1212','EPSG','1092');
 INSERT INTO "projected_crs" VALUES('EPSG','3920','Puerto Rico / UTM zone 20N',NULL,'EPSG','4400','EPSG','4139','EPSG','16020',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2891','projected_crs','EPSG','3920','EPSG','3329','EPSG','1142');
-INSERT INTO "projected_crs" VALUES('EPSG','3942','RGF93 / CC42',NULL,'EPSG','4499','EPSG','4171','EPSG','18101',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','3942','RGF93 v1 / CC42',NULL,'EPSG','4499','EPSG','4171','EPSG','18101',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2892','projected_crs','EPSG','3942','EPSG','3545','EPSG','1054');
-INSERT INTO "projected_crs" VALUES('EPSG','3943','RGF93 / CC43',NULL,'EPSG','4499','EPSG','4171','EPSG','18102',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','3943','RGF93 v1 / CC43',NULL,'EPSG','4499','EPSG','4171','EPSG','18102',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2893','projected_crs','EPSG','3943','EPSG','3546','EPSG','1054');
-INSERT INTO "projected_crs" VALUES('EPSG','3944','RGF93 / CC44',NULL,'EPSG','4499','EPSG','4171','EPSG','18103',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','3944','RGF93 v1 / CC44',NULL,'EPSG','4499','EPSG','4171','EPSG','18103',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2894','projected_crs','EPSG','3944','EPSG','3547','EPSG','1054');
-INSERT INTO "projected_crs" VALUES('EPSG','3945','RGF93 / CC45',NULL,'EPSG','4499','EPSG','4171','EPSG','18104',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','3945','RGF93 v1 / CC45',NULL,'EPSG','4499','EPSG','4171','EPSG','18104',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2895','projected_crs','EPSG','3945','EPSG','3548','EPSG','1054');
-INSERT INTO "projected_crs" VALUES('EPSG','3946','RGF93 / CC46',NULL,'EPSG','4499','EPSG','4171','EPSG','18105',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','3946','RGF93 v1 / CC46',NULL,'EPSG','4499','EPSG','4171','EPSG','18105',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2896','projected_crs','EPSG','3946','EPSG','3549','EPSG','1054');
-INSERT INTO "projected_crs" VALUES('EPSG','3947','RGF93 / CC47',NULL,'EPSG','4499','EPSG','4171','EPSG','18106',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','3947','RGF93 v1 / CC47',NULL,'EPSG','4499','EPSG','4171','EPSG','18106',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2897','projected_crs','EPSG','3947','EPSG','3550','EPSG','1054');
-INSERT INTO "projected_crs" VALUES('EPSG','3948','RGF93 / CC48',NULL,'EPSG','4499','EPSG','4171','EPSG','18107',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','3948','RGF93 v1 / CC48',NULL,'EPSG','4499','EPSG','4171','EPSG','18107',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2898','projected_crs','EPSG','3948','EPSG','3551','EPSG','1054');
-INSERT INTO "projected_crs" VALUES('EPSG','3949','RGF93 / CC49',NULL,'EPSG','4499','EPSG','4171','EPSG','18108',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','3949','RGF93 v1 / CC49',NULL,'EPSG','4499','EPSG','4171','EPSG','18108',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2899','projected_crs','EPSG','3949','EPSG','3552','EPSG','1054');
-INSERT INTO "projected_crs" VALUES('EPSG','3950','RGF93 / CC50',NULL,'EPSG','4499','EPSG','4171','EPSG','18109',NULL,0);
+INSERT INTO "projected_crs" VALUES('EPSG','3950','RGF93 v1 / CC50',NULL,'EPSG','4499','EPSG','4171','EPSG','18109',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2900','projected_crs','EPSG','3950','EPSG','3553','EPSG','1054');
 INSERT INTO "projected_crs" VALUES('EPSG','3968','NAD83 / Virginia Lambert',NULL,'EPSG','4499','EPSG','4269','EPSG','3967',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','2901','projected_crs','EPSG','3968','EPSG','1415','EPSG','1135');
@@ -7331,6 +7331,46 @@ INSERT INTO "projected_crs" VALUES('EPSG','9761','ECML14_NB Grid',NULL,'EPSG','4
 INSERT INTO "usage" VALUES('EPSG','16498','projected_crs','EPSG','9761','EPSG','4621','EPSG','1141');
 INSERT INTO "projected_crs" VALUES('EPSG','9766','EWR2 Grid',NULL,'EPSG','4400','EPSG','9763','EPSG','9765',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','16509','projected_crs','EPSG','9766','EPSG','4622','EPSG','1141');
+INSERT INTO "projected_crs" VALUES('EPSG','9793','RGF93 v2 / Lambert-93',NULL,'EPSG','4499','EPSG','9777','EPSG','18085',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16614','projected_crs','EPSG','9793','EPSG','1096','EPSG','1142');
+INSERT INTO "projected_crs" VALUES('EPSG','9794','RGF93 v2b / Lambert-93',NULL,'EPSG','4499','EPSG','9782','EPSG','18085',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16615','projected_crs','EPSG','9794','EPSG','1096','EPSG','1142');
+INSERT INTO "projected_crs" VALUES('EPSG','9822','RGF93 v2 / CC42',NULL,'EPSG','4499','EPSG','9777','EPSG','18101',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16616','projected_crs','EPSG','9822','EPSG','3545','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9823','RGF93 v2 / CC43',NULL,'EPSG','4499','EPSG','9777','EPSG','18102',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16617','projected_crs','EPSG','9823','EPSG','3546','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9824','RGF93 v2 / CC44',NULL,'EPSG','4499','EPSG','9777','EPSG','18103',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16618','projected_crs','EPSG','9824','EPSG','3547','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9825','RGF93 v2 / CC45',NULL,'EPSG','4499','EPSG','9777','EPSG','18104',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16619','projected_crs','EPSG','9825','EPSG','3548','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9826','RGF93 v2 / CC46',NULL,'EPSG','4499','EPSG','9777','EPSG','18105',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16620','projected_crs','EPSG','9826','EPSG','3549','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9827','RGF93 v2 / CC47',NULL,'EPSG','4499','EPSG','9777','EPSG','18106',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16621','projected_crs','EPSG','9827','EPSG','3550','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9828','RGF93 v2 / CC48',NULL,'EPSG','4499','EPSG','9777','EPSG','18107',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16622','projected_crs','EPSG','9828','EPSG','3551','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9829','RGF93 v2 / CC49',NULL,'EPSG','4499','EPSG','9777','EPSG','18108',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16623','projected_crs','EPSG','9829','EPSG','3552','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9830','RGF93 v2 / CC50',NULL,'EPSG','4499','EPSG','9777','EPSG','18109',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16624','projected_crs','EPSG','9830','EPSG','3553','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9842','RGF93 v2b / CC42',NULL,'EPSG','4499','EPSG','9782','EPSG','18101',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16625','projected_crs','EPSG','9842','EPSG','3545','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9843','RGF93 v2b / CC43',NULL,'EPSG','4499','EPSG','9782','EPSG','18102',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16626','projected_crs','EPSG','9843','EPSG','3546','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9844','RGF93 v2b / CC44',NULL,'EPSG','4499','EPSG','9782','EPSG','18103',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16627','projected_crs','EPSG','9844','EPSG','3547','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9845','RGF93 v2b / CC45',NULL,'EPSG','4499','EPSG','9782','EPSG','18104',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16628','projected_crs','EPSG','9845','EPSG','3548','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9846','RGF93 v2b / CC46',NULL,'EPSG','4499','EPSG','9782','EPSG','18105',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16629','projected_crs','EPSG','9846','EPSG','3549','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9847','RGF93 v2b / CC47',NULL,'EPSG','4499','EPSG','9782','EPSG','18106',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16630','projected_crs','EPSG','9847','EPSG','3550','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9848','RGF93 v2b / CC48',NULL,'EPSG','4499','EPSG','9782','EPSG','18107',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16631','projected_crs','EPSG','9848','EPSG','3551','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9849','RGF93 v2b / CC49',NULL,'EPSG','4499','EPSG','9782','EPSG','18108',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16632','projected_crs','EPSG','9849','EPSG','3552','EPSG','1054');
+INSERT INTO "projected_crs" VALUES('EPSG','9850','RGF93 v2b / CC50',NULL,'EPSG','4499','EPSG','9782','EPSG','18109',NULL,0);
+INSERT INTO "usage" VALUES('EPSG','16633','projected_crs','EPSG','9850','EPSG','3553','EPSG','1054');
 INSERT INTO "projected_crs" VALUES('EPSG','20004','Pulkovo 1995 / Gauss-Kruger zone 4',NULL,'EPSG','4530','EPSG','4200','EPSG','16204',NULL,0);
 INSERT INTO "usage" VALUES('EPSG','6177','projected_crs','EPSG','20004','EPSG','1763','EPSG','1211');
 INSERT INTO "projected_crs" VALUES('EPSG','20005','Pulkovo 1995 / Gauss-Kruger zone 5',NULL,'EPSG','4530','EPSG','4200','EPSG','16205',NULL,0);