Mercurial > dive4elements > river
diff backend/doc/schema/oracle-sinfo-uinfo.sql @ 9661:9b8ba3b83a15
Importer (s/u-info) vegetation zones: new database column in vegetation_type table for german type name,
localized vegetation type names by querying the database instead of translating by resource property,
detecting and cancelling the import of a second vegetation zone file for a river,
detecting, logging, cancelling in case of wrong column titles,
detecting, logging and ignoring lines with missing (color) values,
comparing vegetation zone name and class with the database and logging+ignoring in case of inconsistencies,
starting the most elevated zone with 0 instead of -1 overflow days
| author | mschaefer |
|---|---|
| date | Mon, 23 Mar 2020 16:38:12 +0100 |
| parents | d889ffe2fb05 |
| children | 692f49b7de63 |
line wrap: on
line diff
--- a/backend/doc/schema/oracle-sinfo-uinfo.sql Mon Mar 23 15:40:12 2020 +0100 +++ b/backend/doc/schema/oracle-sinfo-uinfo.sql Mon Mar 23 16:38:12 2020 +0100 @@ -429,17 +429,19 @@ CREATE TABLE vegetation_type ( id NUMBER(9,0) PRIMARY KEY, - name VARCHAR2(256) NOT NULL + name VARCHAR2(256) NOT NULL, + de_name VARCHAR2(256) NOT NULL ); -INSERT INTO vegetation_type (id, name) VALUES (1, 'zonal forest'); -INSERT INTO vegetation_type (id, name) VALUES (2, 'dry hartwood forest floodplain'); -INSERT INTO vegetation_type (id, name) VALUES (3, 'wet hartwood forest floodplain'); -INSERT INTO vegetation_type (id, name) VALUES (4, 'salix alba forest'); -INSERT INTO vegetation_type (id, name) VALUES (5, 'salix shrubs'); -INSERT INTO vegetation_type (id, name) VALUES (6, 'reed bed'); -INSERT INTO vegetation_type (id, name) VALUES (7, 'bank pioneers'); -INSERT INTO vegetation_type (id, name) VALUES (8, 'no vegetation'); -INSERT INTO vegetation_type (id, name) VALUES (9, 'water'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (1, 'zonal forest', 'Zonaler Wald'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (1, 'zonal forest', 'Zonaler Wald'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (2, 'dry hartwood forest floodplain', 'Hartholzaue, trocken'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (3, 'wet hartwood forest floodplain', 'Hartholzaue, feucht'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (4, 'salix alba forest', 'Silberweidenwald'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (5, 'salix shrubs', 'Weidengebüsch'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (6, 'reed bed', 'Uferröhricht'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (7, 'bank pioneers', 'Uferpioniere'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (8, 'no vegetation', 'vegetationslos'); +INSERT INTO vegetation_type (id, name, de_name) VALUES (9, 'water', 'Wasserfläche'); CREATE TABLE vegetation (