# HG changeset patch # User Ingo Weinzierl # Date 1336460797 0 # Node ID b3d5e6d6e468dfd46913ebe0fe96695341927d69 # Parent 998f1a7dcfdeda0e8f0596f5f86e0ede2078178d Added an sql script to insert dems for Saar, Mosel and Elbe into database. flys-backend/trunk@4354 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 998f1a7dcfde -r b3d5e6d6e468 flys-backend/ChangeLog --- 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 + + * doc/schema/import-dems.sql: New. Insert statements to insert dems into + database. + 2012-05-04 Ingo Weinzierl * doc/schema/oracle-drop-spatial.sql, diff -r 998f1a7dcfde -r b3d5e6d6e468 flys-backend/doc/schema/import-dems.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' +);