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@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: