
mstanko@1191: \set ON_ERROR_STOP on
mstanko@1191: 
mstanko@1191: --
mstanko@1191: -- PostgreSQL database dump
mstanko@1191: --
mstanko@1191: 
mstanko@1191: -- Dumped from database version 9.5.1
mstanko@1191: -- Dumped by pg_dump version 9.5.0
mstanko@1191: 
mstanko@1191: -- Started on 2016-03-31 11:38:13
mstanko@1191: 
mstanko@1191: SET statement_timeout = 0;
mstanko@1191: SET lock_timeout = 0;
mstanko@1191: SET client_encoding = 'UTF8';
mstanko@1191: SET standard_conforming_strings = on;
mstanko@1191: SET check_function_bodies = false;
mstanko@1191: SET client_min_messages = warning;
mstanko@1191: 
mstanko@1191: SET search_path = stammdaten, pg_catalog;
mstanko@1191: 
mstanko@1191: 
mstanko@1191: --
mstanko@1191: -- TOC entry 4697 (class 0 OID 535760)
mstanko@1191: -- Dependencies: 262
mstanko@1191: -- Data for Name: messgroessen_gruppe; Type: TABLE DATA; Schema: stammdaten; Owner: lada
mstanko@1191: --
mstanko@1191: 
mstanko@1191: COPY messgroessen_gruppe (id, bezeichnung, ist_leitnuklidgruppe) FROM stdin;
mstanko@1191: 57	Messgrössen für nuklidspezifische Gammamessung	0
mstanko@1191: 97	Gesamt-Alpha und Beta	0
mstanko@1191: 30	Sr-Isotope (insbes. Sr 90)	0
mstanko@1191: 31	Iod-Isotope (insbes. I 131)	0
mstanko@1191: 32	Alpha-Teilchen emittierende Pu-Isotope (insbes. Pu 239, Am 241)	0
mstanko@1191: 33	sonst. Nuklide mit Halbwertzeiten > 10d (insbes. Cs 134, Cs 137)	0
mstanko@1191: 34	Cs-Isotope (Cs 134, Cs 137)	0
mstanko@1191: 5	Alphaspektrometrie Messgrößen	0
mstanko@1191: 6	Berechnete Größen	0
mstanko@1191: 7	Beta Größen	0
mstanko@1191: 8	Elementbestimmungsmessgrößen	0
mstanko@1191: 10	Gamma-OD	0
mstanko@1191: 11	Gamma-ODL	0
mstanko@1191: 12	Gamma-Spektrometrie Iod 131	0
mstanko@1191: 13	Gammaspektrometrie Messgrößen	0
mstanko@1191: 14	Gesamt-Alpha-Aktivität	0
mstanko@1191: 15	Gesamt-Alpha-Aktivität, Handmonitor	0
mstanko@1191: 16	Gesamt-Alpha-Aktivität, verzögert	0
mstanko@1191: 17	Gesamt-Beta-Aktivität	0
mstanko@1191: 18	Gesamt-Beta-Aktivität, Handmonitor	0
mstanko@1191: 19	Gesamt-Beta-Aktivität, verzögert / Künstlich Gesamt-Beta	0
mstanko@1191: 20	Gesamt-Cäsium-Aktivität	0
mstanko@1191: 21	Gesamt-Gamma-Aktivität	0
mstanko@1191: 22	Neutronen-Dosisleistung	0
mstanko@1191: 23	Neutronen-Ortsdosis	0
mstanko@1191: 24	Niederschlagsintensität	0
mstanko@1191: 25	Niederschlagsmenge	0
mstanko@1191: 26	nuklidspezifische Dosisleistung	0
mstanko@1191: 3	PARK - Alpha-Strahler	0
mstanko@1191: 2	PARK - Beta-Strahler	0
mstanko@1191: 4	PARK - Edelgase	0
mstanko@1191: 1	PARK - Gamma-Strahler (aerosolgebunden vorkommend)	0
mstanko@1191: 27	Rest-Beta	0
mstanko@1191: 28	Schneehöhe	0
mstanko@1191: 29	sonstige radiologische Meßmethode	0
mstanko@1191: 35	Cs 137	0
mstanko@1191: 36	I 131	0
mstanko@1191: 37	Sr 89/90	0
mstanko@1191: 55	H 3	0
mstanko@1191: 56	C 14	0
mstanko@1191: 77	Edelgas-Messgrößen	0
mstanko@1191: 119	Gamma-ODL (Handmessung)	0
mstanko@1191: 117	Alphaspektrometrie Uran	0
mstanko@1191: 118	Alphaspektrometrie Plutonium	0
mstanko@1191: \.
mstanko@1191: 
mstanko@1191: 
mstanko@1191: --
mstanko@1191: -- TOC entry 4701 (class 0 OID 535771)
mstanko@1191: -- Dependencies: 266
mstanko@1191: -- Data for Name: mg_grp; Type: TABLE DATA; Schema: stammdaten; Owner: lada
mstanko@1191: --
mstanko@1191: 
mstanko@1191: COPY mg_grp (messgroessengruppe_id, messgroesse_id) FROM stdin;
mstanko@1191: 1	2
mstanko@1191: 1	10
mstanko@1191: 1	28
mstanko@1191: 1	51
mstanko@1191: 1	56
mstanko@1191: 1	60
mstanko@1191: 1	64
mstanko@1191: 1	66
mstanko@1191: 1	68
mstanko@1191: 1	85
mstanko@1191: 1	166
mstanko@1191: 1	167
mstanko@1191: 1	176
mstanko@1191: 1	177
mstanko@1191: 1	184
mstanko@1191: 1	185
mstanko@1191: 1	193
mstanko@1191: 1	196
mstanko@1191: 1	201
mstanko@1191: 1	214
mstanko@1191: 1	220
mstanko@1191: 1	222
mstanko@1191: 1	250
mstanko@1191: 1	303
mstanko@1191: 1	304
mstanko@1191: 1	307
mstanko@1191: 1	310
mstanko@1191: 1	316
mstanko@1191: 1	321
mstanko@1191: 1	322
mstanko@1191: 1	323
mstanko@1191: 1	325
mstanko@1191: 1	340
mstanko@1191: 1	342
mstanko@1191: 1	343
mstanko@1191: 1	345
mstanko@1191: 1	369
mstanko@1191: 1	372
mstanko@1191: 1	373
mstanko@1191: 1	384
mstanko@1191: 1	393
mstanko@1191: 1	394
mstanko@1191: 1	402
mstanko@1191: 1	403
mstanko@1191: 1	404
mstanko@1191: 1	423
mstanko@1191: 1	437
mstanko@1191: 1	543
mstanko@1191: 1	658
mstanko@1191: 1	670
mstanko@1191: 1	672
mstanko@1191: 1	673
mstanko@1191: 1	684
mstanko@1191: 1	686
mstanko@1191: 1	725
mstanko@1191: 1	739
mstanko@1191: 1	749
mstanko@1191: 1	761
mstanko@1191: 2	1
mstanko@1191: 2	164
mstanko@1191: 2	165
mstanko@1191: 3	732
mstanko@1191: 3	746
mstanko@1191: 3	747
mstanko@1191: 3	750
mstanko@1191: 3	759
mstanko@1191: 3	768
mstanko@1191: 3	769
mstanko@1191: 3	781
mstanko@1191: 3	793
mstanko@1191: 3	795
mstanko@1191: 4	26
mstanko@1191: 4	140
mstanko@1191: 4	142
mstanko@1191: 4	143
mstanko@1191: 4	354
mstanko@1191: 4	355
mstanko@1191: 4	356
mstanko@1191: 4	357
mstanko@1191: 5	717
mstanko@1191: 5	727
mstanko@1191: 5	728
mstanko@1191: 5	730
mstanko@1191: 5	732
mstanko@1191: 5	744
mstanko@1191: 5	745
mstanko@1191: 5	746
mstanko@1191: 5	747
mstanko@1191: 5	750
mstanko@1191: 5	759
mstanko@1191: 5	766
mstanko@1191: 5	768
mstanko@1191: 5	769
mstanko@1191: 5	770
mstanko@1191: 5	781
mstanko@1191: 5	793
mstanko@1191: 5	794
mstanko@1191: 5	795
mstanko@1191: 5	850
mstanko@1191: 5	978
mstanko@1191: 6	950
mstanko@1191: 7	1
mstanko@1191: 7	5
mstanko@1191: 7	164
mstanko@1191: 7	165
mstanko@1191: 7	215
mstanko@1191: 7	717
mstanko@1191: 8	28
mstanko@1191: 8	958
mstanko@1191: 10	925
mstanko@1191: 10	926
mstanko@1191: 11	900
mstanko@1191: 11	909
mstanko@1191: 11	910
mstanko@1191: 11	911
mstanko@1191: 11	998
mstanko@1191: 11	999
mstanko@1191: 12	259
mstanko@1191: 12	273
mstanko@1191: 12	338
mstanko@1191: 12	340
mstanko@1191: 12	860
mstanko@1191: 12	870
mstanko@1191: 12	880
mstanko@1191: 13	2
mstanko@1191: 13	10
mstanko@1191: 13	26
mstanko@1191: 13	28
mstanko@1191: 13	40
mstanko@1191: 13	51
mstanko@1191: 13	56
mstanko@1191: 13	60
mstanko@1191: 13	64
mstanko@1191: 13	66
mstanko@1191: 13	67
mstanko@1191: 13	68
mstanko@1191: 13	85
mstanko@1191: 13	90
mstanko@1191: 13	92
mstanko@1191: 13	117
mstanko@1191: 13	140
mstanko@1191: 13	141
mstanko@1191: 13	142
mstanko@1191: 13	143
mstanko@1191: 13	144
mstanko@1191: 13	162
mstanko@1191: 13	166
mstanko@1191: 13	167
mstanko@1191: 13	171
mstanko@1191: 13	176
mstanko@1191: 13	177
mstanko@1191: 13	184
mstanko@1191: 13	185
mstanko@1191: 13	193
mstanko@1191: 13	196
mstanko@1191: 13	201
mstanko@1191: 13	214
mstanko@1191: 13	220
mstanko@1191: 13	221
mstanko@1191: 13	222
mstanko@1191: 13	247
mstanko@1191: 13	248
mstanko@1191: 13	250
mstanko@1191: 13	251
mstanko@1191: 13	252
mstanko@1191: 13	257
mstanko@1191: 13	267
mstanko@1191: 13	281
mstanko@1191: 13	303
mstanko@1191: 13	304
mstanko@1191: 13	307
mstanko@1191: 13	310
mstanko@1191: 13	316
mstanko@1191: 13	321
mstanko@1191: 13	322
mstanko@1191: 13	323
mstanko@1191: 13	325
mstanko@1191: 13	335
mstanko@1191: 13	338
mstanko@1191: 13	340
mstanko@1191: 13	342
mstanko@1191: 13	343
mstanko@1191: 13	345
mstanko@1191: 13	354
mstanko@1191: 13	355
mstanko@1191: 13	356
mstanko@1191: 13	357
mstanko@1191: 13	358
mstanko@1191: 13	359
mstanko@1191: 13	369
mstanko@1191: 13	372
mstanko@1191: 13	373
mstanko@1191: 13	380
mstanko@1191: 13	384
mstanko@1191: 13	392
mstanko@1191: 13	393
mstanko@1191: 13	394
mstanko@1191: 13	401
mstanko@1191: 13	402
mstanko@1191: 13	403
mstanko@1191: 13	404
mstanko@1191: 13	423
mstanko@1191: 13	432
mstanko@1191: 13	435
mstanko@1191: 13	437
mstanko@1191: 13	445
mstanko@1191: 13	456
mstanko@1191: 13	457
mstanko@1191: 13	458
mstanko@1191: 13	529
mstanko@1191: 13	543
mstanko@1191: 13	560
mstanko@1191: 13	582
mstanko@1191: 13	644
mstanko@1191: 13	653
mstanko@1191: 13	654
mstanko@1191: 13	657
mstanko@1191: 13	658
mstanko@1191: 13	670
mstanko@1191: 13	671
mstanko@1191: 13	672
mstanko@1191: 13	673
mstanko@1191: 13	683
mstanko@1191: 13	684
mstanko@1191: 13	686
mstanko@1191: 13	705
mstanko@1191: 13	714
mstanko@1191: 13	715
mstanko@1191: 13	717
mstanko@1191: 13	719
mstanko@1191: 13	720
mstanko@1191: 13	724
mstanko@1191: 13	725
mstanko@1191: 13	727
mstanko@1191: 13	728
mstanko@1191: 13	730
mstanko@1191: 13	731
mstanko@1191: 13	732
mstanko@1191: 13	733
mstanko@1191: 13	737
mstanko@1191: 13	739
mstanko@1191: 13	740
mstanko@1191: 13	741
mstanko@1191: 13	747
mstanko@1191: 13	749
mstanko@1191: 13	750
mstanko@1191: 13	761
mstanko@1191: 13	781
mstanko@1191: 13	860
mstanko@1191: 13	861
mstanko@1191: 13	862
mstanko@1191: 13	955
mstanko@1191: 14	904
mstanko@1191: 14	905
mstanko@1191: 14	923
mstanko@1191: 15	904
mstanko@1191: 16	915
mstanko@1191: 16	916
mstanko@1191: 16	917
mstanko@1191: 16	918
mstanko@1191: 17	902
mstanko@1191: 17	903
mstanko@1191: 17	924
mstanko@1191: 18	902
mstanko@1191: 19	919
mstanko@1191: 19	920
mstanko@1191: 19	921
mstanko@1191: 19	922
mstanko@1191: 20	906
mstanko@1191: 21	901
mstanko@1191: 21	908
mstanko@1191: 22	914
mstanko@1191: 22	929
mstanko@1191: 22	930
mstanko@1191: 22	1000
mstanko@1191: 22	1001
mstanko@1191: 23	913
mstanko@1191: 23	927
mstanko@1191: 23	928
mstanko@1191: 25	950
mstanko@1191: 25	951
mstanko@1191: 25	952
mstanko@1191: 26	2
mstanko@1191: 26	10
mstanko@1191: 26	26
mstanko@1191: 26	28
mstanko@1191: 26	51
mstanko@1191: 26	56
mstanko@1191: 26	60
mstanko@1191: 26	64
mstanko@1191: 26	66
mstanko@1191: 26	68
mstanko@1191: 26	85
mstanko@1191: 26	140
mstanko@1191: 26	141
mstanko@1191: 26	142
mstanko@1191: 26	143
mstanko@1191: 26	144
mstanko@1191: 26	166
mstanko@1191: 26	167
mstanko@1191: 26	176
mstanko@1191: 26	177
mstanko@1191: 26	184
mstanko@1191: 26	185
mstanko@1191: 26	193
mstanko@1191: 26	196
mstanko@1191: 26	201
mstanko@1191: 26	214
mstanko@1191: 26	220
mstanko@1191: 26	222
mstanko@1191: 26	250
mstanko@1191: 26	303
mstanko@1191: 26	304
mstanko@1191: 26	307
mstanko@1191: 26	310
mstanko@1191: 26	316
mstanko@1191: 26	321
mstanko@1191: 26	322
mstanko@1191: 26	323
mstanko@1191: 26	325
mstanko@1191: 26	340
mstanko@1191: 26	342
mstanko@1191: 26	343
mstanko@1191: 26	345
mstanko@1191: 26	354
mstanko@1191: 26	355
mstanko@1191: 26	356
mstanko@1191: 26	357
mstanko@1191: 26	358
mstanko@1191: 26	359
mstanko@1191: 26	369
mstanko@1191: 26	372
mstanko@1191: 26	373
mstanko@1191: 26	384
mstanko@1191: 26	393
mstanko@1191: 26	394
mstanko@1191: 26	402
mstanko@1191: 26	403
mstanko@1191: 26	404
mstanko@1191: 26	423
mstanko@1191: 26	437
mstanko@1191: 26	543
mstanko@1191: 26	658
mstanko@1191: 26	670
mstanko@1191: 26	672
mstanko@1191: 26	673
mstanko@1191: 26	684
mstanko@1191: 26	686
mstanko@1191: 26	717
mstanko@1191: 26	725
mstanko@1191: 26	739
mstanko@1191: 26	747
mstanko@1191: 26	749
mstanko@1191: 26	761
mstanko@1191: 27	907
mstanko@1191: 28	951
mstanko@1191: 29	2
mstanko@1191: 29	28
mstanko@1191: 29	59
mstanko@1191: 29	68
mstanko@1191: 29	74
mstanko@1191: 29	165
mstanko@1191: 29	222
mstanko@1191: 29	340
mstanko@1191: 29	369
mstanko@1191: 29	373
mstanko@1191: 29	670
mstanko@1191: 29	715
mstanko@1191: 29	717
mstanko@1191: 29	719
mstanko@1191: 29	725
mstanko@1191: 29	728
mstanko@1191: 29	740
mstanko@1191: 29	746
mstanko@1191: 29	747
mstanko@1191: 29	750
mstanko@1191: 29	900
mstanko@1191: 29	902
mstanko@1191: 29	904
mstanko@1191: 29	909
mstanko@1191: 29	955
mstanko@1191: 30	164
mstanko@1191: 30	165
mstanko@1191: 30	166
mstanko@1191: 30	167
mstanko@1191: 31	340
mstanko@1191: 31	342
mstanko@1191: 31	343
mstanko@1191: 31	345
mstanko@1191: 32	769
mstanko@1191: 32	781
mstanko@1191: 32	850
mstanko@1191: 33	369
mstanko@1191: 33	373
mstanko@1191: 33	384
mstanko@1191: 34	369
mstanko@1191: 34	373
mstanko@1191: 35	373
mstanko@1191: 36	340
mstanko@1191: 37	164
mstanko@1191: 37	165
mstanko@1191: 55	1
mstanko@1191: 56	5
mstanko@1191: 57	340
mstanko@1191: 57	369
mstanko@1191: 57	373
mstanko@1191: 77	141
mstanko@1191: 77	353
mstanko@1191: 77	355
mstanko@1191: 77	357
mstanko@1191: 97	902
mstanko@1191: 97	904
mstanko@1191: 8	750
mstanko@1191: 8	769
mstanko@1191: 8	781
mstanko@1191: 8	747
mstanko@1191: 8	746
mstanko@1191: 12	342
mstanko@1191: 13	353
mstanko@1191: 13	531
mstanko@1191: 117	745
mstanko@1191: 117	750
mstanko@1191: 117	746
mstanko@1191: 117	747
mstanko@1191: 117	744
mstanko@1191: 118	768
mstanko@1191: 118	850
mstanko@1191: 118	766
mstanko@1191: 118	769
mstanko@1191: 118	770
mstanko@1191: 119	900
mstanko@1311: 13	11
mstanko@1191: \.
mstanko@1191: 
mstanko@1191: 
mstanko@1191: --
mstanko@1191: -- TOC entry 4702 (class 0 OID 535774)
mstanko@1191: -- Dependencies: 267
mstanko@1191: -- Data for Name: mmt_messgroesse_grp; Type: TABLE DATA; Schema: stammdaten; Owner: lada
mstanko@1191: --
mstanko@1191: 
mstanko@1191: COPY mmt_messgroesse_grp (messgroessengruppe_id, mmt_id) FROM stdin;
mstanko@1191: 5	A1
mstanko@1191: 6	S1
mstanko@1191: 7	B1
mstanko@1191: 8	E1
mstanko@1191: 10	D1
mstanko@1191: 11	O1
mstanko@1191: 12	G3
mstanko@1191: 12	GI
mstanko@1191: 13	G1
mstanko@1191: 13	I1
mstanko@1191: 13	I2
mstanko@1191: 14	A2
mstanko@1191: 15	A3
mstanko@1191: 16	A4
mstanko@1191: 17	B2
mstanko@1191: 18	B3
mstanko@1191: 19	B4
mstanko@1191: 21	G4
mstanko@1191: 22	O2
mstanko@1191: 23	D2
mstanko@1191: 24	M2
mstanko@1191: 25	M1
mstanko@1191: 26	I3
mstanko@1191: 27	B5
mstanko@1191: 28	M3
mstanko@1191: 29	S4
mstanko@1191: 37	BS
mstanko@1191: 37	BX
mstanko@1191: 55	BH
mstanko@1191: 56	BC
mstanko@1191: 57	G2
mstanko@1191: 77	BE
mstanko@1191: 97	AB
mstanko@1191: 117	AU
mstanko@1191: 118	AP
mstanko@1191: 119	O3
mstanko@1191: \.
mstanko@1191: 




