annotate db_schema/stammdaten_data_umwelt.sql @ 1334:739ad8e78fca

tag 2.6.1
author Michael Stanko <mstanko@bfs.de>
date Wed, 05 Apr 2017 16:15:47 +0200
parents 3923b41f8783
children 5f7f2157a7b8
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 4721 (class 0 OID 535858)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
23 -- Dependencies: 292
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24 -- Data for Name: umwelt; 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 umwelt (id, beschreibung, umwelt_bereich, meh_id) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
28 L6 \N Spurenmessung Luft 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
29 I19 \N Gras (REI) 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
30 L61 \N Spurenmessung Luft - Aerosole 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
31 L62 \N Spurenmessung Luft - gasförmige Komponenten (einschl. Iod) 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
32 L63 \N Spurenmessung Luft - Edelgase 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
33 A42 \N organische Düngemittel (aus landwirtschaftlichen Abfällen) 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
34 A32 \N Deponieoberfläche 97
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
35 G5 \N Rohwasser zur Trinkwassergewinnung 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
36 G51 \N Rohwasser, geschützt, aus Grund- und Tiefenwasser 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
37 G52 \N Rohwasser, ungeschützt, aus Oberflächenwasser 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
38 G53 \N Zisternenwasser 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
39 A56 \N Bauschutt 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
40 F11 \N Weide- u. Wiesenbewuchs 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
41 F21 \N Mais (ganze Pflanze) 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
42 F31 \N Futtergetreide (einschl. Maiskörner) 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
43 F41 \N Futterkartoffeln und Futterrüben 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
44 F61 \N Maisprodukte 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
45 F71 \N Kraftfuttermischungen 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
46 NZ1 \N Hühnereier 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
47 N51 \N Rindfleisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
48 N52 \N Kalbfleisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
49 N53 \N Schweinefleisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
50 N54 \N Geflügelfleisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
51 N55 \N Lammfleisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
52 N56 \N Haarwildfleisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
53 N31 \N Getreidekörner (Weizen-,Roggen-, Gersten-, Hafer-, Mais-, Triticalenkörner) 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
54 N21 \N Blattgemüse, ungeschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
55 N22 \N Wurzelgemüse, ungeschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
56 N23 \N Fruchtgemüse, ungeschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
57 N24 \N Sprossgemüse, ungeschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
58 N25 \N Kartoffeln 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
59 N26 \N Blattgemüse, geschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
60 N41 \N Schalenobst (Nüsse) 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
61 N42 \N Kernobst 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
62 N43 \N Steinobst 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
63 N44 \N Beerenobst, ungeschützter Anbau (außer Wald-/Wildbeeren) 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
64 N45 \N Beerenobst, geschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
65 N46 \N Wald-/Wildbeeren 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
66 N2A \N Wildpilze 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
67 N28 \N Fruchtgemüse, geschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
68 N2B \N Kulturpilze 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
69 N85 \N Getränke, trinkfertig, nicht alkoholisch (einschl. Tee und Kaffee) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
70 N86 \N Getränke, Trockensubstanz, nicht alkoholisch (einschl. Tee und Kaffee) 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
71 N81 \N Gesamtnahrung 69
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
72 N82 \N Säuglings- und Kleinkindernahrung 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
73 N11 \N Sammelmilch (Kuh-) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
74 N12 \N Hofmilch (Kuh-) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
75 N13 \N bearbeitete Trinkmilch (Kuh-) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
76 N14 \N Milch anderer Tiere (Schaf, Ziege, Stute) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
77 N91 \N Käse aus Kuhmilch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
78 N92 \N Käse aus Milch anderer Tiere 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
79 N93 \N Milchprodukte außer Käse, Frischprodukte 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
80 N94 \N Milchprodukte außer Käse, Trockenprodukte 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
81 G21 \N Wasser in stehenden Gewässern 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
82 G22 \N Schwebstoffe in stehenden Gewässern 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
83 G23 \N Sedimente in stehenden Gewässern 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
84 G11 \N Wasser in Fließgewässern 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
85 G12 \N Schwebstoff in Fließgewässern 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
86 G13 \N Sediment in Fließgewässern 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
87 G31 \N Meerwasser 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
88 F63 \N Maniok und Tapioka 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
89 G32 \N Schwebstoffe im Meerwasser 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
90 G33 \N Sedimente im Meerwasser 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
91 N61 \N Süßwasserfisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
92 N62 \N Seefisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
93 I15 \N Wasserpflanzen 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
94 N63 \N Meeresfrüchte 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
95 N73 \N Reinwasser aus Mischrohwasser 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
96 N74 \N Rohwasser, geschützt, aus Grund- und Tiefenwasser (ungültig) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
97 N71 \N Reinwasser aus geschützten Rohwasservorkommen 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
98 N72 \N Reinwasser aus ungeschützten Rohwasservorkommen 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
99 A31 \N Sicker- und Grundwasser 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
100 A22 \N Kesselasche, Schlacke 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
101 A21 \N Filterstaub, Filterasche 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
102 A23 \N Feste Rückstände aus Rauchgaswäsche 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
103 A24 \N Flüssige Rückstände aus Rauchgaswäsche 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
104 A41 \N Kompost 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
105 A51 \N Luftfilter 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
106 A52 \N Gartenabfälle 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
107 A53 \N Folien 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
108 A54 \N sonstige spezielle Reststoffe und Abfälle 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
109 A55 \N Reststoffe aus der Trinkwasseraufbereitung 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
110 A11 \N Abwasser aus Kläranlagenablauf 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
111 A12 \N Wasser aus Kanalisation, Kläranlagenzulauf, Regenrückhaltebecken 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
112 A13 \N Klärschlamm 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
113 I21 \N Tabakblätter 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
114 I31 \N Ausgangsstoffe für Arzneimittel 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
115 Z31 \N Bedarfsgegenstände mit Lebensmittelkontakt 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
116 Z32 \N Bedarfsgegenstände zur Verpackung von Tabakerz. und kosmet. Mitteln 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
117 Z33 \N Bedarfsgegenstände mit Körperkontakt/ Spielwaren/ Kleidung 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
118 L41 \N Luft/gasförmiges Iod 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
119 L42 \N Luft/Edelgase 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
120 L43 \N andere gasförmige Komponenten (außer Iod u. Edelgase) 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
121 L12 \N Gamma-Ortsdosisleistung 76
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
122 L11 \N Gamma-Ortsdosis 72
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
123 B12 \N Boden in-situ (flächenbezogene Aktivität); Boden versiegelt 61
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
124 L22 \N Neutronen-Ortsdosisleistung 76
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
125 L21 \N Neutronen-Ortsdosis 72
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
126 B22 \N Boden in-situ (nuklidspez. Dosisleistung),Boden versiegelt 76
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
127 B34 \N Freizeitflächenböden 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
128 B35 \N Ödlandböden, Brachen 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
129 B36 \N Gartenböden 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
130 F12 \N Grünfutterpflanzen (außer Weide- u. Wiesenbewuchs) 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
131 F51 \N Heu 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
132 F52 \N Stroh, Cobs, Trockenmehle 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
133 F62 \N Schrote 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
134 A1 \N Kläranlage \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
135 A2 \N Verbrennungsanlage \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
136 A3 \N Mülldeponie \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
137 A4 \N Kompostierungsanlage 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
138 A5 \N Spezielle Reststoffe und Abfälle 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
139 B1 \N Boden in-situ (flächenbezogene Aktivität) 61
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
140 B2 \N Boden in-situ (nuklidspezifische Dosisleistung) 76
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
141 B3 \N Weide-/ Acker-/ Wald-/ Freizeitflächen-/ Ödland- und Gartenböden 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
142 F1 \N Grünfutter (einschl. Weide- und Wiesenbewuchs) \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
143 F2 \N Mais 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
144 F3 \N Futtergetreide 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
145 F4 \N Hackfrüchte 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
146 F5 \N Heu, Stroh, Cobs, Trockenmehle 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
147 F6 \N Mischfuttermittelrohstoffe 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
148 F7 \N Mischfuttermittel 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
149 G1 \N Fließgewässer \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
150 G2 \N Stehende Gewässer \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
151 G3 \N Meer \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
152 G4 \N Grundwasser 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
153 GZ \N Sonstige Wässer 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
154 I1 \N Pflanzliche Indikatoren \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
155 I2 \N Tabak 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
156 I3 \N Arzneimittel 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
157 L1 \N Luft/Gammastrahlung \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
158 L2 \N Luft/Neutronenstrahlung \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
159 L3 \N Luft/Aerosole \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
160 L4 \N Luft/gasförmige Komponenten (einschl. Iod) \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
161 L5 \N Niederschlag \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
162 N1 \N Milch 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
163 N2 \N Frischgemüse (einschl. Kartoffeln und Pilze) 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
164 N3 \N Getreide 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
165 N4 \N Obst 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
166 N5 \N Fleisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
167 N6 \N Fisch und Meeresfrüchte 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
168 N7 \N Trinkwasser 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
169 N8 \N Gesamtnahrung, Fertiggerichte und Getränke \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
170 N9 \N Nahrungsmittelprodukte \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
171 NZ \N Sonstige Nahrungsmittel 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
172 Z1 \N Baustoffe 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
173 Z2 \N Bodenschätze 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
174 Z3 \N Bedarfsgegenstände und Kosmetische Mittel 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
175 A \N Abwasser, Reststoffe und Abfälle \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
176 B \N Boden \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
177 F \N Futtermittel \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
178 G \N Gewässer \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
179 I \N Bio-Indikatoren, Tabak und Arzneimittel \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
180 L \N Luft und Niederschlag \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
181 N \N Nahrungsmittel (einschl. Trinkwasser) \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
182 Z \N Sonstige Mediengruppen \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
183 L32 \N Bilanzierungsmessung Aerosole 60
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
184 L44 \N Bilanzierungsmessung Luft/Iod 60
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
185 L45 \N Bilanzierungsmessung Luft/Edelgase 60
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
186 L46 \N Bilanzierungsmessung andere gasförmige Komponenten (außer Iod und Edelgase) 60
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
187 N2Y \N Sonstiges Gemüse, ungeschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
188 N2Z \N Sonstiges Gemüse, geschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
189 N3Z \N Sonstige Getreidearten 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
190 N4Z \N Sonstige Obstarten 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
191 N5Z \N Sonstiges Fleisch 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
192 NZZ \N weitere Nahrungsmittel 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
193 F5Z \N Sonstige Futtermittel 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
194 N2C \N Sonstige Wildpilze 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
195 G41 \N Grundwasser (nicht zur Trinkwassergewinnung) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
196 GZ1 \N Wasser zur Viehtränke 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
197 L31 \N Aerosole 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
198 L52 \N nasse Niederschläge (Deposition) 61
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
199 L51 \N Niederschlag (Aktivitätskonzentration) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
200 L54 \N Niederschlagsmenge 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
201 L53 \N trockene Niederschläge (Deposition) 61
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
202 N27 \N Wurzelgemüse, geschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
203 N75 \N Rohwasser, ungeschützt, aus Oberflächenwasser (ungültig) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
204 N76 \N Zisternenwasser (ungültig) 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
205 N83 \N Fertiggerichte, verzehrsfertig (einschl. Suppen) 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
206 N84 \N Fertiggerichte, Trockensubstanz (einschl. Suppen) 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
207 N87 \N Getränke, alkoholisch 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
208 N95 \N Milchprodukte außer Käse, haltbar gemacht 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
209 N96 \N Gemüseprodukte einschl. Kartoffeln, Frischprodukte auch tiefgefroren 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
210 N97 \N Gemüseprodukte einschl. Kartoffeln, Trockenprodukte 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
211 N98 \N Gemüseprodukte einschl. Kartoffeln, haltbar gemacht 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
212 N99 \N Wildpilzprodukte, Frischprodukte auch tiefgefroren 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
213 N9A \N Wildpilzprodukte, Trockenprodukte 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
214 N9B \N Wildpilzprodukte, haltbar gemacht 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
215 N9C \N Kulturpilzprodukte, Frischprodukte auch tiefgefroren 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
216 N9D \N Kulturpilzprodukte, Trockenprodukte 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
217 N9E \N Kulturpilzprodukte, haltbar gemacht 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
218 B11 \N Boden in-situ (flächenbezogene Aktivität); Boden unversiegelt 61
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
219 B31 \N Weideböden 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
220 B32 \N Ackerböden 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
221 B33 \N Waldböden 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
222 B21 \N Boden in-situ (nuklidspez. Dosisleistung),Boden unversiegelt 76
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
223 N9F \N Getreideprodukte außer Brot 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
224 N9G \N Brote und Gebäcke 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
225 N9H \N Obstprodukte, Frischprodukte auch tiefgefroren 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
226 N9I \N Obstprodukte, Trockenprodukte 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
227 N9J \N Obstprodukte, haltbar gemacht 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
228 N9K \N Fleischprodukte u. Wurstwaren, ohne Wild, Frischprod. auch tiefgefr. 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
229 N9L \N Fleischprodukte u. Wurstwaren, ohne Wild, haltbar gemacht 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
230 N9M \N Wildfleischprodukte u. -wurstwaren, Frischprod. auch tiefgefr. 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
231 N9N \N Wildfleischprodukte u. -wurstwaren, haltbar gemacht 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
232 N9O \N Fischprodukte, Frischprod. auch tiefgefr. 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
233 N9P \N Fischprodukte, haltbar gemacht 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
234 N9Q \N Meeresfrüchteprodukte, Frischprod. auch tiefgefr. 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
235 N9R \N Meeresfrüchteprodukte, haltbar gemacht 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
236 NZ2 \N Honig 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
237 Z11 \N mineralische Ausgangsstoffe für Baustoffe 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
238 I11 \N Blätter 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
239 I12 \N Nadeln 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
240 I13 \N Gras 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
241 I14 \N Moose, Farne, Flechten u. Heidekraut 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
242 Z12 \N verarbeitete mineralische Baustoffe 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
243 Z13 \N organische Ausgangsstoffe für Baustoffe 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
244 Z14 \N verarbeitete organische Baustoffe 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
245 Z21 \N Rohgas 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
246 Z22 \N Reingas 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
247 Z34 \N Bedarfsgegenstände zur Reinigung und Pflege 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
248 Z35 \N Kosmetische Mittel und Stoffe zu deren Herstellung 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
249 I22 \N Zigaretten, Zigarren 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
250 I32 \N Arzneimittelprodukte 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
251 N29 \N Sprossgemüse, geschützter Anbau 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
252 N15 \N Humanmilch 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
253 N64 \N Fischerzeugnisse 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
254 M Markiert eine Probe als Meteo-Probe Meteo-Umweltbereich \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
255 N65 \N Wasserpflanzen, Trockenprodukte 64
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
256 B13 \N Bodenauflage 61
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
257 S \N Umweltbereiche für Störfall \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
258 S1 \N Luft - Störfall \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
259 S11 \N Luft/äußere Strahlung (Gamma-ODL) - Störfall 76
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
260 S12 \N Luft/Aerosole - Störfall 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
261 S13 \N Luft/gasförmiges Iod - Störfall 62
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
262 S14 \N Luft/äußere Strahlung (Gamma-OD) -Störfall 72
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
263 S2 \N Boden/-Oberfläche - Störfall \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
264 S21 \N Bodenoberfläche (unversiegelt, in-situ, flächenbezogene Aktivität) - Störfall 61
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
265 S22 \N Boden - Störfall 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
266 S23 \N Bodenoberfläche (versiegelt, in-situ, flächenbezogene Aktivität) - Störfall 61
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
267 S3 \N Pflanzen/Bewuchs - Störfall \N
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
268 S31 \N Weide- und Wiesenbewuchs - Störfall 67
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
269 S32 \N Grünfutterpflanzen (außer Weide- und Wiesenbewuchs) - Störfall 65
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
270 S4 \N Oberirdische Gewässer - Störfall 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
271 S41 \N Oberflächenwasser (Fließgewässer) - Störfall 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
272 S42 \N Oberflächenwasser (stehende Gewässer) - Störfall 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
273 S43 \N Oberflächenwasser (Viehtränke) - Störfall 63
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
274 \.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)