Mercurial > dive4elements > river

changeset 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 998f1a7dcfde
children bb116a8d6e19
files flys-backend/ChangeLog flys-backend/doc/schema/import-dems.sql
diffstat 2 files changed, 170 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/flys-backend/ChangeLog	Fri May 04 06:58:00 2012 +0000
+++ b/flys-backend/ChangeLog	Tue May 08 07:06:37 2012 +0000
@@ -1,3 +1,8 @@
+2012-05-08  Ingo Weinzierl <ingo@intevation.de>
+
+	* doc/schema/import-dems.sql: New. Insert statements to insert dems into
+	  database.
+
 2012-05-04  Ingo Weinzierl <ingo@intevation.de>
 
 	* doc/schema/oracle-drop-spatial.sql,
--- /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