view flys-backend/doc/schema/import-dems.sql @ 3793:8f232119011e

FYLS-Backend: Bring MINFO schemes of Oracle and PostgreSQL back in sync. flys-backend/trunk@5433 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 11 Sep 2012 13:55:08 +0000
parents b3d5e6d6e468
children 89ada0b9083f
line wrap: on
line source
-- 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