Mercurial > dive4elements > river

annotate flys-backend/doc/schema/import-dems.sql @ 3943:a5b003595d6c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Store minfo values into database only if their peer has been successfully stored. flys-backend/trunk@5520 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Wed, 19 Sep 2012 10:05:36 +0000
parents b3d5e6d6e468
children 89ada0b9083f
rev   line source
2863
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
1 -- SAAR
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
2 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
3 (SELECT id FROM rivers WHERE name = 'Saar'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
4 0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
5 7.9,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
6 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0000-0079_long.txt'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
7 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
8
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
9 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
10 (SELECT id FROM rivers WHERE name = 'Saar'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
11 8.0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
12 20.4,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
13 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0080-0204_long.txt'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
14 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
15
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
16 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
17 (SELECT id FROM rivers WHERE name = 'Saar'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
18 20.5,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
19 31.4,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
20 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0205-0314_long.txt'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
21 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
22
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
23 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
24 (SELECT id FROM rivers WHERE name = 'Saar'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
25 31.5,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
26 54.1,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
27 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0315-0541_long.txt'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
28 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
29
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
30 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
31 (SELECT id FROM rivers WHERE name = 'Saar'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
32 54.2,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
33 65.5,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
34 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0542-0655_long.txt'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
35 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
36
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
37 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
38 (SELECT id FROM rivers WHERE name = 'Saar'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
39 65.6,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
40 82.8,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
41 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0656-0828_long.txt'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
42 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
43
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
44 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
45 (SELECT id FROM rivers WHERE name = 'Saar'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
46 82.9,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
47 93.1,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
48 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0829-0931_erweitert.txt'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
49 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
50
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
51
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
52 -- ELBE
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
53 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
54 (SELECT id FROM rivers WHERE name = 'Elbe'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
55 0.0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
56 101.1,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
57 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_00000_10110.grd'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
58 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
59
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
60 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
61 (SELECT id FROM rivers WHERE name = 'Elbe'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
62 99.2,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
63 203.0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
64 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_09920_20300.grd'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
65 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
66
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
67 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
68 (SELECT id FROM rivers WHERE name = 'Elbe'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
69 202.0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
70 299.8,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
71 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_20200_29980.grd'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
72 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
73
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
74 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
75 (SELECT id FROM rivers WHERE name = 'Elbe'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
76 298.1,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
77 401.0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
78 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_29810_40100.grd'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
79 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
80
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
81 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
82 (SELECT id FROM rivers WHERE name = 'Elbe'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
83 400.0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
84 500.9,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
85 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_40000_50090.grd'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
86 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
87
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
88 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
89 (SELECT id FROM rivers WHERE name = 'Elbe'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
90 500.1,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
91 583.3,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
92 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_50010_58330.grd'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
93 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
94
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
95
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
96 -- MOSEL
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
97 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
98 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
99 0.0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
100 5.8,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
101 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0000-0580.xyz'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
102 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
103
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
104 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
105 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
106 5.8,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
107 15.3,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
108 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0058-0153.xyz'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
109 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
110
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
111 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
112 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
113 15.3,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
114 41.6,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
115 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0153-0416.xyz'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
116 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
117
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
118 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
119 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
120 41.4,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
121 101.2,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
122 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0414-1012O.xyz'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
123 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
124
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
125 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
126 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
127 41.4,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
128 101.21,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
129 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0414-1012W.xyz'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
130 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
131
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
132 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
133 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
134 101.2,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
135 148.8,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
136 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1012-1488.xyz'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
137 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
138
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
139 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
140 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
141 148.8,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
142 166.6,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
143 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1488-1666.xyz'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
144 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
145
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
146 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
147 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
148 166.6,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
149 196.0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
150 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1666-1960.xyz'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
151 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
152
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
153 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
154 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
155 196.0,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
156 204.4,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
157 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1960-2044.XYZ'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
158 );
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
159
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
160 INSERT INTO dem (river_id, lower, upper, path) VALUES (
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
161 (SELECT id FROM rivers WHERE name = 'Mosel'),
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
162 204.4,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
163 218.4,
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
164 '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/2044-2184.XYZ'
b3d5e6d6e468 Added an sql script to insert dems for Saar, Mosel and Elbe into database.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
diff changeset
165 );
http://dive4elements.wald.intevation.org