Mercurial > dive4elements > river
annotate flys-backend/doc/schema/import-dems.sql @ 3945:26084ee6d352
Change methods names until the url is really be fetched from the db
flys-backend/trunk@5551 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Bjoern Ricks <bjoern.ricks@intevation.de> |
---|---|
date | Fri, 21 Sep 2012 10:47:32 +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 ); |