Mercurial > dive4elements > river

comparison flys-backend/doc/schema/import-dems.sql @ 2863:b3d5e6d6e468

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