Mercurial > dive4elements > river
view flys-backend/doc/schema/import-dems.sql @ 3788:71834666447d
Moved some code over from flys-artifacts.
flys-backend/trunk@5400 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Sat, 08 Sep 2012 13:31:03 +0000 |
parents | b3d5e6d6e468 |
children | 89ada0b9083f |
line wrap: on
line source
-- SAAR INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Saar'), 0, 7.9, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0000-0079_long.txt' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Saar'), 8.0, 20.4, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0080-0204_long.txt' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Saar'), 20.5, 31.4, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0205-0314_long.txt' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Saar'), 31.5, 54.1, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0315-0541_long.txt' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Saar'), 54.2, 65.5, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0542-0655_long.txt' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Saar'), 65.6, 82.8, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0656-0828_long.txt' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Saar'), 82.9, 93.1, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0829-0931_erweitert.txt' ); -- ELBE INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Elbe'), 0.0, 101.1, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_00000_10110.grd' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Elbe'), 99.2, 203.0, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_09920_20300.grd' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Elbe'), 202.0, 299.8, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_20200_29980.grd' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Elbe'), 298.1, 401.0, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_29810_40100.grd' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Elbe'), 400.0, 500.9, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_40000_50090.grd' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Elbe'), 500.1, 583.3, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_50010_58330.grd' ); -- MOSEL INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 0.0, 5.8, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0000-0580.xyz' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 5.8, 15.3, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0058-0153.xyz' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 15.3, 41.6, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0153-0416.xyz' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 41.4, 101.2, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0414-1012O.xyz' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 41.4, 101.21, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0414-1012W.xyz' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 101.2, 148.8, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1012-1488.xyz' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 148.8, 166.6, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1488-1666.xyz' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 166.6, 196.0, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1666-1960.xyz' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 196.0, 204.4, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1960-2044.XYZ' ); INSERT INTO dem (river_id, lower, upper, path) VALUES ( (SELECT id FROM rivers WHERE name = 'Mosel'), 204.4, 218.4, '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/2044-2184.XYZ' );