diff options
Diffstat (limited to 'data/sql/ignf.sql')
| -rw-r--r-- | data/sql/ignf.sql | 64 |
1 files changed, 48 insertions, 16 deletions
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'); |