Mercurial > dive4elements > river

annotate flys-backend/doc/schema/import-dems.sql @ 3948:883dd49d5e74

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapted PostgreSQL spatial schema. flys-backend/trunk@5585 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Mon, 24 Sep 2012 09:13:29 +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