From ef443bdf0e85a5ef7611bf0ac815610b9645f2eb Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Fri, 23 Oct 2020 17:42:39 +0200 Subject: Database: add interpolation_crs_auth_name and interpolation_crs_code columns to other_transformation table --- data/sql/ignf.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'data/sql/ignf.sql') diff --git a/data/sql/ignf.sql b/data/sql/ignf.sql index defc743f..c74b8155 100644 --- a/data/sql/ignf.sql +++ b/data/sql/ignf.sql @@ -2329,10 +2329,10 @@ INSERT INTO "usage" VALUES('IGNF', 'TSG759_ANAA92G_TO_WGS84G_USAGE','helmert_tra INSERT INTO "helmert_transformation" VALUES('IGNF','TSG759_ANAA92G_TO_4326','MOP92 (ANAA) TUAMOTU vers WGS 84',NULL,'EPSG','9603','Geocentric translations (geog2D domain)','IGNF','ANAA92G','EPSG','4326',NULL,1.50,3.84,4.81,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0.0',0); INSERT INTO "usage" VALUES('IGNF', 'TSG759_ANAA92G_TO_4326_USAGE','helmert_transformation','IGNF','TSG759_ANAA92G_TO_4326','IGNF','139','IGNF','5'); INSERT INTO "extent" VALUES('IGNF','140','EUROPE (EVRF2000)','EUROPE (EVRF2000)',36,71.2,-10,32,0); -INSERT INTO "other_transformation" VALUES('IGNF','TSG1250','NGF-IGN 1969 vers EVRF2000 (UELN-95/98)(EUROPEAN VERTICAL REFERENCE FRAME)',NULL,'EPSG','9616','Vertical Offset','IGNF','IGN69','IGNF','EVRF2000',NULL,'EPSG','8603','Vertical Offset',-0.486,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0',0); +INSERT INTO "other_transformation" VALUES('IGNF','TSG1250','NGF-IGN 1969 vers EVRF2000 (UELN-95/98)(EUROPEAN VERTICAL REFERENCE FRAME)',NULL,'EPSG','9616','Vertical Offset','IGNF','IGN69','IGNF','EVRF2000',NULL,'EPSG','8603','Vertical Offset',-0.486,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0',0); INSERT INTO "usage" VALUES('IGNF', 'TSG1250_USAGE','other_transformation','IGNF','TSG1250','IGNF','140','IGNF','11'); INSERT INTO "extent" VALUES('IGNF','141','EUROPE (EVRF2007)','EUROPE (EVRF2007)',36,71.2,-10,32,0); -INSERT INTO "other_transformation" VALUES('IGNF','TSG1251','NGF-IGN 1969 vers EVRF2007 (EUROPEAN VERTICAL REFERENCE FRAME 2007)',NULL,'EPSG','9616','Vertical Offset','IGNF','IGN69','IGNF','EVRF2007',NULL,'EPSG','8603','Vertical Offset',-0.47,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0',0); +INSERT INTO "other_transformation" VALUES('IGNF','TSG1251','NGF-IGN 1969 vers EVRF2007 (EUROPEAN VERTICAL REFERENCE FRAME 2007)',NULL,'EPSG','9616','Vertical Offset','IGNF','IGN69','IGNF','EVRF2007',NULL,'EPSG','8603','Vertical Offset',-0.47,'EPSG','9001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0',0); INSERT INTO "usage" VALUES('IGNF', 'TSG1251_USAGE','other_transformation','IGNF','TSG1251','IGNF','141','IGNF','3'); INSERT INTO "extent" VALUES('IGNF','142','FRANCE CONTINENTALE','FRANCE CONTINENTALE',42.00,51.50,-5.50,8.50,0); INSERT INTO "grid_transformation" VALUES('IGNF','TSG1164','RGF93 (ETRS89) vers NGF-IGN 1969',NULL,'EPSG','9664','Geographic3D to GravityRelatedHeight (IGN1997)','IGNF','RGF93GEODD','IGNF','IGN69',NULL,'EPSG','8666','Geoid (height correction) model file','http://geodesie.ign.fr/contenu/fichiers/documentation/grilles/metropole/RAF09.mnt',NULL,NULL,NULL,NULL,NULL,NULL,'1.0.0',0); @@ -2409,9 +2409,9 @@ INSERT INTO "helmert_transformation" VALUES('IGNF','TSG802_LUXGEO_TO_WGS84G','NO INSERT INTO "usage" VALUES('IGNF', 'TSG802_LUXGEO_TO_WGS84G_USAGE','helmert_transformation','IGNF','TSG802_LUXGEO_TO_WGS84G','IGNF','144','IGNF','6'); INSERT INTO "helmert_transformation" VALUES('IGNF','TSG802_LUXGEO_TO_4326','NOUVELLE TRIANGULATION DU GRAND DUCHE DE LUXEMBOURG (LURES) vers WGS 84',NULL,'EPSG','9606','Position Vector transformation (geog2D domain)','IGNF','LUXGEO','EPSG','4326',NULL,-192.986,13.673,-39.309,'EPSG','9001',-0.409900,-2.933200,2.688100,'EPSG','9104',0.43,'EPSG', '9202',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0.0',0); INSERT INTO "usage" VALUES('IGNF', 'TSG802_LUXGEO_TO_4326_USAGE','helmert_transformation','IGNF','TSG802_LUXGEO_TO_4326','IGNF','144','IGNF','6'); -INSERT INTO "other_transformation" VALUES('IGNF','TSG1240','NTF geographiques Paris (gr) vers NTF GEOGRAPHIQUES GREENWICH (DMS)',NULL,'EPSG','9601','Longitude rotation','IGNF','NTFPGRAD','IGNF','NTFG',0.0,'EPSG','8602','Longitude offset',2.5969213,'EPSG','9105',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0',0); +INSERT INTO "other_transformation" VALUES('IGNF','TSG1240','NTF geographiques Paris (gr) vers NTF GEOGRAPHIQUES GREENWICH (DMS)',NULL,'EPSG','9601','Longitude rotation','IGNF','NTFPGRAD','IGNF','NTFG',0.0,'EPSG','8602','Longitude offset',2.5969213,'EPSG','9105',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0',0); INSERT INTO "usage" VALUES('IGNF', 'TSG1240_USAGE','other_transformation','IGNF','TSG1240','IGNF','143','IGNF','6'); -INSERT INTO "other_transformation" VALUES('IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','NTF geographiques Paris (gr) vers NTF GEOGRAPHIQUES GREENWICH (DMS)',NULL,'EPSG','9601','Longitude rotation','IGNF','NTFP','IGNF','NTFG',0.0,'EPSG','8602','Longitude offset',2.5969213,'EPSG','9105',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0',0); +INSERT INTO "other_transformation" VALUES('IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','NTF geographiques Paris (gr) vers NTF GEOGRAPHIQUES GREENWICH (DMS)',NULL,'EPSG','9601','Longitude rotation','IGNF','NTFP','IGNF','NTFG',0.0,'EPSG','8602','Longitude offset',2.5969213,'EPSG','9105',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0',0); INSERT INTO "usage" VALUES('IGNF', 'TSG1240_IGNF_NTFP_TO_IGNF_NTFG_USAGE','other_transformation','IGNF','TSG1240_IGNF_NTFP_TO_IGNF_NTFG','IGNF','143','IGNF','6'); INSERT INTO "extent" VALUES('IGNF','145','TERRE ADELIE - ILE DES PETRELS','TERRE ADELIE - ILE DES PETRELS',-68,-66.17,139.67,140.17,0); INSERT INTO "helmert_transformation" VALUES('IGNF','TSG608','PETRELS-IGN 1972 vers WGS 84',NULL,'EPSG','1031','Geocentric translations (geocentric domain)','IGNF','PETRELS72','IGNF','WGS84',NULL,365,194,166,'EPSG','9001',NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.0.0',0); -- cgit v1.2.3