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: );