Mercurial > dive4elements > river
diff flys-backend/doc/schema/import-dems.sql @ 2863:b3d5e6d6e468
Added an sql script to insert dems for Saar, Mosel and Elbe into database.
flys-backend/trunk@4354 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 08 May 2012 07:06:37 +0000 |
| parents | |
| children | 89ada0b9083f |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/flys-backend/doc/schema/import-dems.sql Tue May 08 07:06:37 2012 +0000 @@ -0,0 +1,165 @@ +-- 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' +);