annotate db_schema/stammdaten_data_proben_zusatz.sql @ 1247:cba98f3de840

Added tag 2.4.1 for changeset 204fb75b0c06
author Tom Gottfried <tom@intevation.de>
date Fri, 16 Dec 2016 13:50:22 +0100
parents 3923b41f8783
children
rev   line source
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
1 \set ON_ERROR_STOP on
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
3 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
4 -- PostgreSQL database dump
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
5 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
7 -- Dumped from database version 9.5.1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
8 -- Dumped by pg_dump version 9.5.0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
10 -- Started on 2016-03-31 11:38:13
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
12 SET statement_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
13 SET lock_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
14 SET client_encoding = 'UTF8';
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
15 SET standard_conforming_strings = on;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
16 SET check_function_bodies = false;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
17 SET client_min_messages = warning;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
18
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
19 SET search_path = stammdaten, pg_catalog;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
20
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
21 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
22 -- TOC entry 4710 (class 0 OID 535810)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
23 -- Dependencies: 276
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24 -- Data for Name: proben_zusatz; Type: TABLE DATA; Schema: stammdaten; Owner: lada
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
25 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
26
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
27 COPY proben_zusatz (id, meh_id, beschreibung, zusatzwert, eudf_keyword) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
28 A74 32 Volumenstrom VOLSTR \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
29 A75 2 A00-Horizont (lose Blätter oder Nadelteppich) A00-HZT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
30 A76 2 A0-Horizont (Humusauflage) A0-HZT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
31 A77 2 A1-Horizont (humoser Mineralboden) A1-HZT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
32 A78 2 B-Horizont (verdichteter mineralischer Boden) B-HZT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
33 A79 2 Mächtigkeit MAECHT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
34 A35 95 Versorgte Einwohner pro Wasserwerk VERSE/W \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
35 A36 33 Abgabemenge pro Wasserwerk WASSABM \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
36 A38 \N PH-Wert PHWERT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
37 A39 3 Entnahmetiefe ENTTIE \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
38 A40 2 Entnahmetiefe von ENTTIEV \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
39 A41 2 Entnahmetiefe bis ENTTIEB \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
40 A45 33 Abwasser - Trockenwetterdurchsatz ABW-TWD \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
41 A46 33 Abwasser - Regenwetterdurchsatz ABW-RWD \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
42 A47 30 Verbrennungsanlagen - Luftdurchsatz VBA-LUD \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
43 A48 53 Verbrennungsanlagen - Durchsatzmenge d.verbr.Gutes VBA-DMV \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
44 A49 53 Verbrennungsanlagen - Verbrennungsrückstände VBA-VRS \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
45 A50 32 Verbrennungsanlagen - durchgesetzte Wassermenge VBA-DWR \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
46 A51 19 Deponie - Inbetriebnahme DEP-IBN \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
47 A52 19 Deponie - Schließung DEP-SLG \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
48 A53 54 Kompostierungsanlage - Durchsatz KOMP-DS \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
49 A55 16 Luftfilter - Betriebsdauer LF-BDAU \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
50 A56 16 Luftfilter - Einsatzdauer LF-EDAU \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
51 A57 \N Oberfläche OBFLÄCH \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
52 A59 13 Messzeit MEßZEIT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
53 A60 1 Bodenaktivitätsverteilung BODAKTV \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
54 A61 \N Abschirmfaktor ABSCHIF \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
55 A62 2 Relaxationslänge RELAX \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
56 A01 36 Strömungsgeschwindigkeit STRGSCH \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
57 A02 91 Strömungsrichtung STRRICH \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
58 A03 93 Windstärke WINDST \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
59 A04 91 Windrichtung 0 - 360°(Kurs) WINDR WIND_DIRECTION
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
60 A05 11 Wassermenge als Volumen WASMENG \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
61 A06 92 Wassertemperatur WASTEMP \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
62 A07 3 Wassertiefe WASTIEF \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
63 A08 94 Salinität SALIN \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
64 A09 92 Lufttemperatur LUFTEMP \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
65 A10 2 Schneehöhe SCHNEEH \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
66 A11 2 Schichttiefe SCHICHT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
67 A12 2 Bodentiefe BODTIEF \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
68 A13 3 Messtiefe MESTIEF \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
69 A17 47 Schwebstoffkonzentration SCHWEKO \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
70 A18 51 Probenmenge feucht PRMENGF \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
71 A19 50 Probenmenge trocken PRMENGT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
72 A20 3 Wegstrecke von Startposition WEG \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
73 A21 \N Niederschlag: Regen NIEDREG PRECIPITATION_OCCURRENCE
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
74 A22 \N Niederschlag: Hagel NIEDHAG \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
75 A23 \N Niederschlag: Schnee NIEDSCH SNOW_OCCURRENCE
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
76 A25 1 Niederschlagshöhe NIEDHÖH PRECIPITATION
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
77 A26 14 Niederschlagsdauer NIEDDAU \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
78 A27 30 Abflussmenge eines Flusses ABFLMEN \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
79 A29 4 Flusskilometer FLUSSKM \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
80 A30 45 Bewuchsdichte BEWUDI \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
81 A32 \N Niederschlag: Graupel NIEDGRA \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
82 A33 \N Nebel NEBEL \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
83 A34 45 Umrechnungsfaktor von Bq/kg in Bq/ UMRFAKT \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
84 A72 11 Wasserabgabe W-ABGAB \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
85 A73 11 Fortluftmenge F-LUFT- \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
86 A70 227 Thermische Leistung T-LEIST \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
87 A71 227 Elektrische Leistung E-LEIST \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
88 E74 187 Luftdruck in hPa LF-DR PRESSURE
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
89 E78 188 Niederschlagsmenge Regen pro Stunde NIEDR/H PRECIPITATION_INTENSITY
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
90 E54 11 Luftfilter - Luftdurchsatz LF-LUDS AIR_VOLUME
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
91 E75 \N Dichte der Wolkendecke WoDe CLOUD_COVER
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
92 E41 1 Entnahmetiefe bis ENTTIEB DEPTH_MAX
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
93 E40 1 Entnahmetiefe von ENTTIEV DEPTH_MIN
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
94 E76 92 Taupunkttemperatur TauPunk DEW_POINT_TEMPERATURE
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
95 E77 36 vertikale Bewegung der Luft DOP-RAD DOPPLER_RADAR
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
96 E24 1 Niederschlagsmenge - Schnee NIEDSCH SNOW
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
97 E80 90 relative Feuchtigkeit RelFeu RELATIVE_HUMIDITY
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
98 E79 \N Sonneneinstrahlung SOLAR SOLAR_RADIATION
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
99 E81 92 Temperatur TEMP TEMPERATURE
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
100 E82 \N Regenwahrscheinlichkeit RegVor WEATHER_RADAR
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
101 E83 91 Veränderung der Windrichtung WinVerR WIND_DIRECTION_FLUCTUATION
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
102 E03 36 Windstärke (m/s) WINDST WIND_SPEED
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
103 E84 36 Veränderung der Windstärke WinVerG WIND_SPEED_FLUCTUATION
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
104 A80 21 Warenumfang in kg für §7 WARENKG \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
105 A81 27 Warenumfang in l für §7 WAREN-L \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
106 A54 30 Luftfilter - Luftdurchsatz - Rate LF-LUDR \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
107 \.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)