Mercurial > lada > lada-server
annotate db_schema/stammdaten_data_messgroessen_gruppe.sql @ 1336:18c789672b14
Made validator messages more verbose for importer.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Thu, 06 Apr 2017 10:10:39 +0200 |
| parents | 5549c214e816 |
| children |
| rev | line source |
|---|---|
| 1191 | 1 \set ON_ERROR_STOP on |
| 2 | |
| 3 -- | |
| 4 -- PostgreSQL database dump | |
| 5 -- | |
| 6 | |
| 7 -- Dumped from database version 9.5.1 | |
| 8 -- Dumped by pg_dump version 9.5.0 | |
| 9 | |
| 10 -- Started on 2016-03-31 11:38:13 | |
| 11 | |
| 12 SET statement_timeout = 0; | |
| 13 SET lock_timeout = 0; | |
| 14 SET client_encoding = 'UTF8'; | |
| 15 SET standard_conforming_strings = on; | |
| 16 SET check_function_bodies = false; | |
| 17 SET client_min_messages = warning; | |
| 18 | |
| 19 SET search_path = stammdaten, pg_catalog; | |
| 20 | |
| 21 | |
| 22 -- | |
| 23 -- TOC entry 4697 (class 0 OID 535760) | |
| 24 -- Dependencies: 262 | |
| 25 -- Data for Name: messgroessen_gruppe; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 26 -- | |
| 27 | |
| 28 COPY messgroessen_gruppe (id, bezeichnung, ist_leitnuklidgruppe) FROM stdin; | |
| 29 57 Messgrössen für nuklidspezifische Gammamessung 0 | |
| 30 97 Gesamt-Alpha und Beta 0 | |
| 31 30 Sr-Isotope (insbes. Sr 90) 0 | |
| 32 31 Iod-Isotope (insbes. I 131) 0 | |
| 33 32 Alpha-Teilchen emittierende Pu-Isotope (insbes. Pu 239, Am 241) 0 | |
| 34 33 sonst. Nuklide mit Halbwertzeiten > 10d (insbes. Cs 134, Cs 137) 0 | |
| 35 34 Cs-Isotope (Cs 134, Cs 137) 0 | |
| 36 5 Alphaspektrometrie Messgrößen 0 | |
| 37 6 Berechnete Größen 0 | |
| 38 7 Beta Größen 0 | |
| 39 8 Elementbestimmungsmessgrößen 0 | |
| 40 10 Gamma-OD 0 | |
| 41 11 Gamma-ODL 0 | |
| 42 12 Gamma-Spektrometrie Iod 131 0 | |
| 43 13 Gammaspektrometrie Messgrößen 0 | |
| 44 14 Gesamt-Alpha-Aktivität 0 | |
| 45 15 Gesamt-Alpha-Aktivität, Handmonitor 0 | |
| 46 16 Gesamt-Alpha-Aktivität, verzögert 0 | |
| 47 17 Gesamt-Beta-Aktivität 0 | |
| 48 18 Gesamt-Beta-Aktivität, Handmonitor 0 | |
| 49 19 Gesamt-Beta-Aktivität, verzögert / Künstlich Gesamt-Beta 0 | |
| 50 20 Gesamt-Cäsium-Aktivität 0 | |
| 51 21 Gesamt-Gamma-Aktivität 0 | |
| 52 22 Neutronen-Dosisleistung 0 | |
| 53 23 Neutronen-Ortsdosis 0 | |
| 54 24 Niederschlagsintensität 0 | |
| 55 25 Niederschlagsmenge 0 | |
| 56 26 nuklidspezifische Dosisleistung 0 | |
| 57 3 PARK - Alpha-Strahler 0 | |
| 58 2 PARK - Beta-Strahler 0 | |
| 59 4 PARK - Edelgase 0 | |
| 60 1 PARK - Gamma-Strahler (aerosolgebunden vorkommend) 0 | |
| 61 27 Rest-Beta 0 | |
| 62 28 Schneehöhe 0 | |
| 63 29 sonstige radiologische Meßmethode 0 | |
| 64 35 Cs 137 0 | |
| 65 36 I 131 0 | |
| 66 37 Sr 89/90 0 | |
| 67 55 H 3 0 | |
| 68 56 C 14 0 | |
| 69 77 Edelgas-Messgrößen 0 | |
| 70 119 Gamma-ODL (Handmessung) 0 | |
| 71 117 Alphaspektrometrie Uran 0 | |
| 72 118 Alphaspektrometrie Plutonium 0 | |
| 73 \. | |
| 74 | |
| 75 | |
| 76 -- | |
| 77 -- TOC entry 4701 (class 0 OID 535771) | |
| 78 -- Dependencies: 266 | |
| 79 -- Data for Name: mg_grp; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 80 -- | |
| 81 | |
| 82 COPY mg_grp (messgroessengruppe_id, messgroesse_id) FROM stdin; | |
| 83 1 2 | |
| 84 1 10 | |
| 85 1 28 | |
| 86 1 51 | |
| 87 1 56 | |
| 88 1 60 | |
| 89 1 64 | |
| 90 1 66 | |
| 91 1 68 | |
| 92 1 85 | |
| 93 1 166 | |
| 94 1 167 | |
| 95 1 176 | |
| 96 1 177 | |
| 97 1 184 | |
| 98 1 185 | |
| 99 1 193 | |
| 100 1 196 | |
| 101 1 201 | |
| 102 1 214 | |
| 103 1 220 | |
| 104 1 222 | |
| 105 1 250 | |
| 106 1 303 | |
| 107 1 304 | |
| 108 1 307 | |
| 109 1 310 | |
| 110 1 316 | |
| 111 1 321 | |
| 112 1 322 | |
| 113 1 323 | |
| 114 1 325 | |
| 115 1 340 | |
| 116 1 342 | |
| 117 1 343 | |
| 118 1 345 | |
| 119 1 369 | |
| 120 1 372 | |
| 121 1 373 | |
| 122 1 384 | |
| 123 1 393 | |
| 124 1 394 | |
| 125 1 402 | |
| 126 1 403 | |
| 127 1 404 | |
| 128 1 423 | |
| 129 1 437 | |
| 130 1 543 | |
| 131 1 658 | |
| 132 1 670 | |
| 133 1 672 | |
| 134 1 673 | |
| 135 1 684 | |
| 136 1 686 | |
| 137 1 725 | |
| 138 1 739 | |
| 139 1 749 | |
| 140 1 761 | |
| 141 2 1 | |
| 142 2 164 | |
| 143 2 165 | |
| 144 3 732 | |
| 145 3 746 | |
| 146 3 747 | |
| 147 3 750 | |
| 148 3 759 | |
| 149 3 768 | |
| 150 3 769 | |
| 151 3 781 | |
| 152 3 793 | |
| 153 3 795 | |
| 154 4 26 | |
| 155 4 140 | |
| 156 4 142 | |
| 157 4 143 | |
| 158 4 354 | |
| 159 4 355 | |
| 160 4 356 | |
| 161 4 357 | |
| 162 5 717 | |
| 163 5 727 | |
| 164 5 728 | |
| 165 5 730 | |
| 166 5 732 | |
| 167 5 744 | |
| 168 5 745 | |
| 169 5 746 | |
| 170 5 747 | |
| 171 5 750 | |
| 172 5 759 | |
| 173 5 766 | |
| 174 5 768 | |
| 175 5 769 | |
| 176 5 770 | |
| 177 5 781 | |
| 178 5 793 | |
| 179 5 794 | |
| 180 5 795 | |
| 181 5 850 | |
| 182 5 978 | |
| 183 6 950 | |
| 184 7 1 | |
| 185 7 5 | |
| 186 7 164 | |
| 187 7 165 | |
| 188 7 215 | |
| 189 7 717 | |
| 190 8 28 | |
| 191 8 958 | |
| 192 10 925 | |
| 193 10 926 | |
| 194 11 900 | |
| 195 11 909 | |
| 196 11 910 | |
| 197 11 911 | |
| 198 11 998 | |
| 199 11 999 | |
| 200 12 259 | |
| 201 12 273 | |
| 202 12 338 | |
| 203 12 340 | |
| 204 12 860 | |
| 205 12 870 | |
| 206 12 880 | |
| 207 13 2 | |
| 208 13 10 | |
| 209 13 26 | |
| 210 13 28 | |
| 211 13 40 | |
| 212 13 51 | |
| 213 13 56 | |
| 214 13 60 | |
| 215 13 64 | |
| 216 13 66 | |
| 217 13 67 | |
| 218 13 68 | |
| 219 13 85 | |
| 220 13 90 | |
| 221 13 92 | |
| 222 13 117 | |
| 223 13 140 | |
| 224 13 141 | |
| 225 13 142 | |
| 226 13 143 | |
| 227 13 144 | |
| 228 13 162 | |
| 229 13 166 | |
| 230 13 167 | |
| 231 13 171 | |
| 232 13 176 | |
| 233 13 177 | |
| 234 13 184 | |
| 235 13 185 | |
| 236 13 193 | |
| 237 13 196 | |
| 238 13 201 | |
| 239 13 214 | |
| 240 13 220 | |
| 241 13 221 | |
| 242 13 222 | |
| 243 13 247 | |
| 244 13 248 | |
| 245 13 250 | |
| 246 13 251 | |
| 247 13 252 | |
| 248 13 257 | |
| 249 13 267 | |
| 250 13 281 | |
| 251 13 303 | |
| 252 13 304 | |
| 253 13 307 | |
| 254 13 310 | |
| 255 13 316 | |
| 256 13 321 | |
| 257 13 322 | |
| 258 13 323 | |
| 259 13 325 | |
| 260 13 335 | |
| 261 13 338 | |
| 262 13 340 | |
| 263 13 342 | |
| 264 13 343 | |
| 265 13 345 | |
| 266 13 354 | |
| 267 13 355 | |
| 268 13 356 | |
| 269 13 357 | |
| 270 13 358 | |
| 271 13 359 | |
| 272 13 369 | |
| 273 13 372 | |
| 274 13 373 | |
| 275 13 380 | |
| 276 13 384 | |
| 277 13 392 | |
| 278 13 393 | |
| 279 13 394 | |
| 280 13 401 | |
| 281 13 402 | |
| 282 13 403 | |
| 283 13 404 | |
| 284 13 423 | |
| 285 13 432 | |
| 286 13 435 | |
| 287 13 437 | |
| 288 13 445 | |
| 289 13 456 | |
| 290 13 457 | |
| 291 13 458 | |
| 292 13 529 | |
| 293 13 543 | |
| 294 13 560 | |
| 295 13 582 | |
| 296 13 644 | |
| 297 13 653 | |
| 298 13 654 | |
| 299 13 657 | |
| 300 13 658 | |
| 301 13 670 | |
| 302 13 671 | |
| 303 13 672 | |
| 304 13 673 | |
| 305 13 683 | |
| 306 13 684 | |
| 307 13 686 | |
| 308 13 705 | |
| 309 13 714 | |
| 310 13 715 | |
| 311 13 717 | |
| 312 13 719 | |
| 313 13 720 | |
| 314 13 724 | |
| 315 13 725 | |
| 316 13 727 | |
| 317 13 728 | |
| 318 13 730 | |
| 319 13 731 | |
| 320 13 732 | |
| 321 13 733 | |
| 322 13 737 | |
| 323 13 739 | |
| 324 13 740 | |
| 325 13 741 | |
| 326 13 747 | |
| 327 13 749 | |
| 328 13 750 | |
| 329 13 761 | |
| 330 13 781 | |
| 331 13 860 | |
| 332 13 861 | |
| 333 13 862 | |
| 334 13 955 | |
| 335 14 904 | |
| 336 14 905 | |
| 337 14 923 | |
| 338 15 904 | |
| 339 16 915 | |
| 340 16 916 | |
| 341 16 917 | |
| 342 16 918 | |
| 343 17 902 | |
| 344 17 903 | |
| 345 17 924 | |
| 346 18 902 | |
| 347 19 919 | |
| 348 19 920 | |
| 349 19 921 | |
| 350 19 922 | |
| 351 20 906 | |
| 352 21 901 | |
| 353 21 908 | |
| 354 22 914 | |
| 355 22 929 | |
| 356 22 930 | |
| 357 22 1000 | |
| 358 22 1001 | |
| 359 23 913 | |
| 360 23 927 | |
| 361 23 928 | |
| 362 25 950 | |
| 363 25 951 | |
| 364 25 952 | |
| 365 26 2 | |
| 366 26 10 | |
| 367 26 26 | |
| 368 26 28 | |
| 369 26 51 | |
| 370 26 56 | |
| 371 26 60 | |
| 372 26 64 | |
| 373 26 66 | |
| 374 26 68 | |
| 375 26 85 | |
| 376 26 140 | |
| 377 26 141 | |
| 378 26 142 | |
| 379 26 143 | |
| 380 26 144 | |
| 381 26 166 | |
| 382 26 167 | |
| 383 26 176 | |
| 384 26 177 | |
| 385 26 184 | |
| 386 26 185 | |
| 387 26 193 | |
| 388 26 196 | |
| 389 26 201 | |
| 390 26 214 | |
| 391 26 220 | |
| 392 26 222 | |
| 393 26 250 | |
| 394 26 303 | |
| 395 26 304 | |
| 396 26 307 | |
| 397 26 310 | |
| 398 26 316 | |
| 399 26 321 | |
| 400 26 322 | |
| 401 26 323 | |
| 402 26 325 | |
| 403 26 340 | |
| 404 26 342 | |
| 405 26 343 | |
| 406 26 345 | |
| 407 26 354 | |
| 408 26 355 | |
| 409 26 356 | |
| 410 26 357 | |
| 411 26 358 | |
| 412 26 359 | |
| 413 26 369 | |
| 414 26 372 | |
| 415 26 373 | |
| 416 26 384 | |
| 417 26 393 | |
| 418 26 394 | |
| 419 26 402 | |
| 420 26 403 | |
| 421 26 404 | |
| 422 26 423 | |
| 423 26 437 | |
| 424 26 543 | |
| 425 26 658 | |
| 426 26 670 | |
| 427 26 672 | |
| 428 26 673 | |
| 429 26 684 | |
| 430 26 686 | |
| 431 26 717 | |
| 432 26 725 | |
| 433 26 739 | |
| 434 26 747 | |
| 435 26 749 | |
| 436 26 761 | |
| 437 27 907 | |
| 438 28 951 | |
| 439 29 2 | |
| 440 29 28 | |
| 441 29 59 | |
| 442 29 68 | |
| 443 29 74 | |
| 444 29 165 | |
| 445 29 222 | |
| 446 29 340 | |
| 447 29 369 | |
| 448 29 373 | |
| 449 29 670 | |
| 450 29 715 | |
| 451 29 717 | |
| 452 29 719 | |
| 453 29 725 | |
| 454 29 728 | |
| 455 29 740 | |
| 456 29 746 | |
| 457 29 747 | |
| 458 29 750 | |
| 459 29 900 | |
| 460 29 902 | |
| 461 29 904 | |
| 462 29 909 | |
| 463 29 955 | |
| 464 30 164 | |
| 465 30 165 | |
| 466 30 166 | |
| 467 30 167 | |
| 468 31 340 | |
| 469 31 342 | |
| 470 31 343 | |
| 471 31 345 | |
| 472 32 769 | |
| 473 32 781 | |
| 474 32 850 | |
| 475 33 369 | |
| 476 33 373 | |
| 477 33 384 | |
| 478 34 369 | |
| 479 34 373 | |
| 480 35 373 | |
| 481 36 340 | |
| 482 37 164 | |
| 483 37 165 | |
| 484 55 1 | |
| 485 56 5 | |
| 486 57 340 | |
| 487 57 369 | |
| 488 57 373 | |
| 489 77 141 | |
| 490 77 353 | |
| 491 77 355 | |
| 492 77 357 | |
| 493 97 902 | |
| 494 97 904 | |
| 495 8 750 | |
| 496 8 769 | |
| 497 8 781 | |
| 498 8 747 | |
| 499 8 746 | |
| 500 12 342 | |
| 501 13 353 | |
| 502 13 531 | |
| 503 117 745 | |
| 504 117 750 | |
| 505 117 746 | |
| 506 117 747 | |
| 507 117 744 | |
| 508 118 768 | |
| 509 118 850 | |
| 510 118 766 | |
| 511 118 769 | |
| 512 118 770 | |
| 513 119 900 | |
|
1311
5549c214e816
remove s12 from stammdaten.deskriptor_umwelt and update stammdaten
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
514 13 11 |
| 1191 | 515 \. |
| 516 | |
| 517 | |
| 518 -- | |
| 519 -- TOC entry 4702 (class 0 OID 535774) | |
| 520 -- Dependencies: 267 | |
| 521 -- Data for Name: mmt_messgroesse_grp; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 522 -- | |
| 523 | |
| 524 COPY mmt_messgroesse_grp (messgroessengruppe_id, mmt_id) FROM stdin; | |
| 525 5 A1 | |
| 526 6 S1 | |
| 527 7 B1 | |
| 528 8 E1 | |
| 529 10 D1 | |
| 530 11 O1 | |
| 531 12 G3 | |
| 532 12 GI | |
| 533 13 G1 | |
| 534 13 I1 | |
| 535 13 I2 | |
| 536 14 A2 | |
| 537 15 A3 | |
| 538 16 A4 | |
| 539 17 B2 | |
| 540 18 B3 | |
| 541 19 B4 | |
| 542 21 G4 | |
| 543 22 O2 | |
| 544 23 D2 | |
| 545 24 M2 | |
| 546 25 M1 | |
| 547 26 I3 | |
| 548 27 B5 | |
| 549 28 M3 | |
| 550 29 S4 | |
| 551 37 BS | |
| 552 37 BX | |
| 553 55 BH | |
| 554 56 BC | |
| 555 57 G2 | |
| 556 77 BE | |
| 557 97 AB | |
| 558 117 AU | |
| 559 118 AP | |
| 560 119 O3 | |
| 561 \. | |
| 562 |