
ingo@2863: -- SAAR
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Saar'),
ingo@2863:     0,
ingo@2863:     7.9,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0000-0079_long.txt'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Saar'),
ingo@2863:     8.0,
ingo@2863:     20.4,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0080-0204_long.txt'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Saar'),
ingo@2863:     20.5,
ingo@2863:     31.4,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0205-0314_long.txt'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Saar'),
ingo@2863:     31.5,
ingo@2863:     54.1,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0315-0541_long.txt'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Saar'),
ingo@2863:     54.2,
ingo@2863:     65.5,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0542-0655_long.txt'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Saar'),
ingo@2863:     65.6,
ingo@2863:     82.8,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0656-0828_long.txt'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Saar'),
ingo@2863:     82.9,
ingo@2863:     93.1,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0829-0931_erweitert.txt'
ingo@2863: );
ingo@2863: 
ingo@2863: 
ingo@2863: -- ELBE
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Elbe'),
ingo@2863:     0.0,
ingo@2863:     101.1,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_00000_10110.grd'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Elbe'),
ingo@2863:     99.2,
ingo@2863:     203.0,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_09920_20300.grd'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Elbe'),
ingo@2863:     202.0,
ingo@2863:     299.8,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_20200_29980.grd'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Elbe'),
ingo@2863:     298.1,
ingo@2863:     401.0,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_29810_40100.grd'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Elbe'),
ingo@2863:     400.0,
ingo@2863:     500.9,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_40000_50090.grd'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Elbe'),
ingo@2863:     500.1,
ingo@2863:     583.3,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_50010_58330.grd'
ingo@2863: );
ingo@2863: 
ingo@2863: 
ingo@2863: -- MOSEL
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     0.0,
ingo@2863:     5.8,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0000-0580.xyz'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     5.8,
ingo@2863:     15.3,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0058-0153.xyz'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     15.3,
ingo@2863:     41.6,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0153-0416.xyz'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     41.4,
ingo@2863:     101.2,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0414-1012O.xyz'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     41.4,
ingo@2863:     101.21,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0414-1012W.xyz'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     101.2,
ingo@2863:     148.8,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1012-1488.xyz'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     148.8,
ingo@2863:     166.6,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1488-1666.xyz'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     166.6,
ingo@2863:     196.0,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1666-1960.xyz'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     196.0,
ingo@2863:     204.4,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1960-2044.XYZ'
ingo@2863: );
ingo@2863: 
ingo@2863: INSERT INTO dem (river_id, lower, upper, path) VALUES (
ingo@2863:     (SELECT id FROM rivers WHERE name = 'Mosel'),
ingo@2863:     204.4,
ingo@2863:     218.4,
ingo@2863:     '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/2044-2184.XYZ'
ingo@2863: );




