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

Added an sql script to insert dems for Saar, Mosel and Elbe into database. flys-backend/trunk@4354 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Tue, 08 May 2012 07:06:37 +0000
parents
children 89ada0b9083f
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/flys-backend/doc/schema/import-dems.sql	Tue May 08 07:06:37 2012 +0000
@@ -0,0 +1,165 @@
+-- SAAR
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Saar'),
+    0,
+    7.9,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0000-0079_long.txt'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Saar'),
+    8.0,
+    20.4,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0080-0204_long.txt'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Saar'),
+    20.5,
+    31.4,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0205-0314_long.txt'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Saar'),
+    31.5,
+    54.1,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0315-0541_long.txt'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Saar'),
+    54.2,
+    65.5,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0542-0655_long.txt'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Saar'),
+    65.6,
+    82.8,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0656-0828_long.txt'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Saar'),
+    82.9,
+    93.1,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Saar/Geodaesie/Hoehenmodelle/km0829-0931_erweitert.txt'
+);
+
+
+-- ELBE
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Elbe'),
+    0.0,
+    101.1,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_00000_10110.grd'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Elbe'),
+    99.2,
+    203.0,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_09920_20300.grd'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Elbe'),
+    202.0,
+    299.8,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_20200_29980.grd'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Elbe'),
+    298.1,
+    401.0,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_29810_40100.grd'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Elbe'),
+    400.0,
+    500.9,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_40000_50090.grd'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Elbe'),
+    500.1,
+    583.3,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Elbe/Geodaesie/Hoehenmodelle/m_50010_58330.grd'
+);
+
+
+-- MOSEL
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    0.0,
+    5.8,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0000-0580.xyz'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    5.8,
+    15.3,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0058-0153.xyz'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    15.3,
+    41.6,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0153-0416.xyz'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    41.4,
+    101.2,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0414-1012O.xyz'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    41.4,
+    101.21,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/0414-1012W.xyz'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    101.2,
+    148.8,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1012-1488.xyz'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    148.8,
+    166.6,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1488-1666.xyz'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    166.6,
+    196.0,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1666-1960.xyz'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    196.0,
+    204.4,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/1960-2044.XYZ'
+);
+
+INSERT INTO dem (river_id, lower, upper, path) VALUES (
+    (SELECT id FROM rivers WHERE name = 'Mosel'),
+    204.4,
+    218.4,
+    '/vol1/projects/Geospatial/flys-3.0/testdaten/Gewaesser/Mosel/Geodaesie/Hoehenmodelle/DGMW-ASCII/2044-2184.XYZ'
+);

http://dive4elements.wald.intevation.org