From 46c6ddf84defeb4ae855285da4416dff7178cacc Mon Sep 17 00:00:00 2001
From: Even Rouault <even.rouault@spatialys.com>
Date: Sun, 27 Oct 2019 19:16:04 +0100
Subject: Database: add an auxiliary concatenated_operation_step table to allow
 arbitrary number of steps (fixes #1632)

EPSG:9103 (NAD27 to ITRF2014 (1)) is now handled.

Note:EPSG:9104 (NAD27 to ITRF2014 (2)) is not currently, since it uses
for step EPSG:8861 (NAD83(HARN) to NAD83(FBN) (1))
an unsupported transformation method (NADCON5 (3D), EPSG:1075).
---
 data/sql/ignf.sql | 64 +++++++++++++++++++++++++++++++++++++++++--------------
 1 file changed, 48 insertions(+), 16 deletions(-)

(limited to 'data/sql/ignf.sql')

diff --git a/data/sql/ignf.sql b/data/sql/ignf.sql
index 7bb3cffb..1abdd5af 100644
--- a/data/sql/ignf.sql
+++ b/data/sql/ignf.sql
@@ -3109,19 +3109,51 @@ INSERT INTO "helmert_transformation" VALUES('PROJ','IGNF_RGF93GDD_TO_EPSG_4326',
 
 --- Concatenated operations
 
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG62_NTFPGRAD_TO_ED50G','Nouvelle Triangulation Francaise Paris grades to ED50G',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','ED50G','IGNF','91',NULL,'IGNF','TSG1240','IGNF','TSG62_NTFG_TO_ED50G',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG62_NTFP_TO_ED50G','Nouvelle Triangulation Francaise Paris grades to ED50G',NULL,'NATIONALE','IGNF','NTFP','IGNF','ED50G','IGNF','91',NULL,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','IGNF','TSG62_NTFG_TO_ED50G',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG62_NTFPGRAD_TO_ED50GEO','Nouvelle Triangulation Francaise Paris grades to ED50GEO',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','ED50GEO','IGNF','91',NULL,'IGNF','TSG1240','IGNF','TSG62_NTFG_TO_ED50GEO',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG62_NTFP_TO_ED50GEO','Nouvelle Triangulation Francaise Paris grades to ED50GEO',NULL,'NATIONALE','IGNF','NTFP','IGNF','ED50GEO','IGNF','91',NULL,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','IGNF','TSG62_NTFG_TO_ED50GEO',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GEODD','Nouvelle Triangulation Francaise Paris grades to WGS84GEODD',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84GEODD','IGNF','91',NULL,'IGNF','TSG1240','IGNF','TSG399_NTFG_TO_WGS84GEODD',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84GEODD','Nouvelle Triangulation Francaise Paris grades to WGS84GEODD',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84GEODD','IGNF','91',NULL,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','IGNF','TSG399_NTFG_TO_WGS84GEODD',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GDD','Nouvelle Triangulation Francaise Paris grades to WGS84GDD',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84GDD','IGNF','91',NULL,'IGNF','TSG1240','IGNF','TSG399_NTFG_TO_WGS84GDD',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84GDD','Nouvelle Triangulation Francaise Paris grades to WGS84GDD',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84GDD','IGNF','91',NULL,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','IGNF','TSG399_NTFG_TO_WGS84GDD',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84G','Nouvelle Triangulation Francaise Paris grades to WGS84G',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84G','IGNF','91',NULL,'IGNF','TSG1240','IGNF','TSG399_NTFG_TO_WGS84G',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84G','Nouvelle Triangulation Francaise Paris grades to WGS84G',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84G','IGNF','91',NULL,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','IGNF','TSG399_NTFG_TO_WGS84G',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_4326','Nouvelle Triangulation Francaise Paris grades to 4326',NULL,'NATIONALE','IGNF','NTFPGRAD','EPSG','4326','IGNF','91',NULL,'IGNF','TSG1240','IGNF','TSG399_NTFG_TO_4326',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_4326','Nouvelle Triangulation Francaise Paris grades to 4326',NULL,'NATIONALE','IGNF','NTFP','EPSG','4326','IGNF','91',NULL,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','IGNF','TSG399_NTFG_TO_4326',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GEO','Nouvelle Triangulation Francaise Paris grades to WGS84GEO',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84GEO','IGNF','91',NULL,'IGNF','TSG1240','IGNF','TSG399_NTFG_TO_WGS84GEO',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84GEO','Nouvelle Triangulation Francaise Paris grades to WGS84GEO',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84GEO','IGNF','91',NULL,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','IGNF','TSG399_NTFG_TO_WGS84GEO',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84RRAFGEO','Nouvelle Triangulation Francaise Paris grades to WGS84RRAFGEO',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84RRAFGEO','IGNF','91',NULL,'IGNF','TSG1240','IGNF','TSG399_NTFG_TO_WGS84RRAFGEO',NULL,NULL,'1.0.0',0);
-INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84RRAFGEO','Nouvelle Triangulation Francaise Paris grades to WGS84RRAFGEO',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84RRAFGEO','IGNF','91',NULL,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','IGNF','TSG399_NTFG_TO_WGS84RRAFGEO',NULL,NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG62_NTFPGRAD_TO_ED50G','Nouvelle Triangulation Francaise Paris grades to ED50G',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','ED50G','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG62_NTFPGRAD_TO_ED50G',1,'IGNF','TSG1240');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG62_NTFPGRAD_TO_ED50G',2,'IGNF','TSG62_NTFG_TO_ED50G');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG62_NTFP_TO_ED50G','Nouvelle Triangulation Francaise Paris grades to ED50G',NULL,'NATIONALE','IGNF','NTFP','IGNF','ED50G','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG62_NTFP_TO_ED50G',1,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG62_NTFP_TO_ED50G',2,'IGNF','TSG62_NTFG_TO_ED50G');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG62_NTFPGRAD_TO_ED50GEO','Nouvelle Triangulation Francaise Paris grades to ED50GEO',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','ED50GEO','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG62_NTFPGRAD_TO_ED50GEO',1,'IGNF','TSG1240');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG62_NTFPGRAD_TO_ED50GEO',2,'IGNF','TSG62_NTFG_TO_ED50GEO');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG62_NTFP_TO_ED50GEO','Nouvelle Triangulation Francaise Paris grades to ED50GEO',NULL,'NATIONALE','IGNF','NTFP','IGNF','ED50GEO','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG62_NTFP_TO_ED50GEO',1,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG62_NTFP_TO_ED50GEO',2,'IGNF','TSG62_NTFG_TO_ED50GEO');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GEODD','Nouvelle Triangulation Francaise Paris grades to WGS84GEODD',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84GEODD','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GEODD',1,'IGNF','TSG1240');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GEODD',2,'IGNF','TSG399_NTFG_TO_WGS84GEODD');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84GEODD','Nouvelle Triangulation Francaise Paris grades to WGS84GEODD',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84GEODD','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84GEODD',1,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84GEODD',2,'IGNF','TSG399_NTFG_TO_WGS84GEODD');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GDD','Nouvelle Triangulation Francaise Paris grades to WGS84GDD',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84GDD','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GDD',1,'IGNF','TSG1240');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GDD',2,'IGNF','TSG399_NTFG_TO_WGS84GDD');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84GDD','Nouvelle Triangulation Francaise Paris grades to WGS84GDD',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84GDD','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84GDD',1,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84GDD',2,'IGNF','TSG399_NTFG_TO_WGS84GDD');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84G','Nouvelle Triangulation Francaise Paris grades to WGS84G',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84G','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84G',1,'IGNF','TSG1240');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84G',2,'IGNF','TSG399_NTFG_TO_WGS84G');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84G','Nouvelle Triangulation Francaise Paris grades to WGS84G',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84G','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84G',1,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84G',2,'IGNF','TSG399_NTFG_TO_WGS84G');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_4326','Nouvelle Triangulation Francaise Paris grades to 4326',NULL,'NATIONALE','IGNF','NTFPGRAD','EPSG','4326','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_4326',1,'IGNF','TSG1240');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_4326',2,'IGNF','TSG399_NTFG_TO_4326');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_4326','Nouvelle Triangulation Francaise Paris grades to 4326',NULL,'NATIONALE','IGNF','NTFP','EPSG','4326','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_4326',1,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_4326',2,'IGNF','TSG399_NTFG_TO_4326');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GEO','Nouvelle Triangulation Francaise Paris grades to WGS84GEO',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84GEO','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GEO',1,'IGNF','TSG1240');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84GEO',2,'IGNF','TSG399_NTFG_TO_WGS84GEO');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84GEO','Nouvelle Triangulation Francaise Paris grades to WGS84GEO',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84GEO','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84GEO',1,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84GEO',2,'IGNF','TSG399_NTFG_TO_WGS84GEO');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84RRAFGEO','Nouvelle Triangulation Francaise Paris grades to WGS84RRAFGEO',NULL,'NATIONALE','IGNF','NTFPGRAD','IGNF','WGS84RRAFGEO','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84RRAFGEO',1,'IGNF','TSG1240');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFPGRAD_TO_WGS84RRAFGEO',2,'IGNF','TSG399_NTFG_TO_WGS84RRAFGEO');
+INSERT INTO "concatenated_operation" VALUES('IGNF','TSG399_NTFP_TO_WGS84RRAFGEO','Nouvelle Triangulation Francaise Paris grades to WGS84RRAFGEO',NULL,'NATIONALE','IGNF','NTFP','IGNF','WGS84RRAFGEO','IGNF','91',NULL,'1.0.0',0);
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84RRAFGEO',1,'IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG');
+INSERT INTO "concatenated_operation_step" VALUES('IGNF','TSG399_NTFP_TO_WGS84RRAFGEO',2,'IGNF','TSG399_NTFG_TO_WGS84RRAFGEO');
-- 
cgit v1.2.3

