Mercurial > lada > lada-server

comparison db_schema/lada_data.sql @ 1021:f51a9cf1d52c schema-update

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Update data files.
author Raimund Renkert <raimund.renkert@intevation.de>
date Mon, 04 Jul 2016 14:11:00 +0200
parents 807626952aa8
children 9971471d562c
comparison
equal deleted inserted replaced
1018:178ac8ee17c0 1021:f51a9cf1d52c
26 26
27 SET SESSION AUTHORIZATION DEFAULT; 27 SET SESSION AUTHORIZATION DEFAULT;
28 28
29 ALTER TABLE probe DISABLE TRIGGER ALL; 29 ALTER TABLE probe DISABLE TRIGGER ALL;
30 30
31 COPY probe (id, test, netzbetreiber_id, mst_id, labor_mst_id, hauptproben_nr, datenbasis_id, ba_id, probenart_id, media_desk, media, umw_id, probeentnahme_beginn, probeentnahme_ende, mittelungsdauer, letzte_aenderung, erzeuger_id, probe_nehmer_id, mp_kat, mpl_id, mpr_id, solldatum_beginn, solldatum_ende, tree_modified) FROM stdin; 31 COPY probe (id, id_alt, test, mst_id, labor_mst_id, hauptproben_nr, datenbasis_id, ba_id, probenart_id, media_desk, media, umw_id, probeentnahme_beginn, probeentnahme_ende, mittelungsdauer, letzte_aenderung, erzeuger_id, probe_nehmer_id, mpl_id, mpr_id, solldatum_beginn, solldatum_ende, tree_modified) FROM stdin;
32 660 f 12 12020 12020 N0013KE12 2 1 1 D: 01 03 52 02 00 00 00 00 00 00 00 Schafkäse N92 2012-01-26 11:30:00+01 \N \N 2012-02-22 12:38:39 \N 784 1 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469 32 660 000007590041X f 12020 12020 N0013KE12 2 1 1 D: 01 03 52 02 00 00 00 00 00 00 00 Schafkäse N92 2012-01-26 11:30:00+01 \N \N 2012-02-22 12:38:39 \N 784 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469
33 409 f 12 12010 12010 A0239MP12 2 U 1 D: 01 02 07 03 00 00 00 00 00 00 00 Magermilchpulver N94 2012-03-15 11:00:00+01 \N \N 2012-03-26 16:31:35 \N 1199 U \N \N 2012-03-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469 33 409 000007589343X f 12010 12010 A0239MP12 2 U 1 D: 01 02 07 03 00 00 00 00 00 00 00 Magermilchpulver N94 2012-03-15 11:00:00+01 \N \N 2012-03-26 16:31:35 \N 1199 \N \N 2012-03-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469
34 42 f 06 06010 06010 120109003 2 1 1 D: 01 03 26 03 04 02 00 00 00 00 00 Frischkäse Fettstufe auch mit Gewürzen/Kräutern N91 2012-01-04 08:00:00+01 \N \N 2012-01-23 08:48:21 \N 734 1 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469 34 42 000007578227X f 06010 06010 120109003 2 1 1 D: 01 03 26 03 04 02 00 00 00 00 00 Frischkäse Fettstufe auch mit Gewürzen/Kräutern N91 2012-01-04 08:00:00+01 \N \N 2012-01-23 08:48:21 \N 734 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469
35 313 f 11 11010 11010 122200001 2 1 1 D: 01 06 35 04 01 02 02 20 00 00 00 Suppenhuhn auch tiefgefroren N54 2012-02-24 09:30:00+01 2012-02-24 09:30:00+01 \N 2012-03-01 13:35:02 \N \N 1 \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469 35 313 000007575969X f 11010 11010 122200001 2 1 1 D: 01 06 35 04 01 02 02 20 00 00 00 Suppenhuhn auch tiefgefroren N54 2012-02-24 09:30:00+01 2012-02-24 09:30:00+01 \N 2012-03-01 13:35:02 \N \N \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469
36 311 f 11 11010 11010 122100011 2 1 1 D: 01 06 40 04 01 02 02 11 00 00 00 Fleischteilstück Reh auch tiefgefroren N56 2012-06-04 10:00:00+02 2012-06-04 10:00:00+02 \N 2012-06-18 08:47:25 \N \N 1 \N \N 2012-01-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469 36 311 000007575967X f 11010 11010 122100011 2 1 1 D: 01 06 40 04 01 02 02 11 00 00 00 Fleischteilstück Reh auch tiefgefroren N56 2012-06-04 10:00:00+02 2012-06-04 10:00:00+02 \N 2012-06-18 08:47:25 \N \N \N \N 2012-01-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469
37 112 f 11 11010 11010 122800001 2 1 1 D: 01 01 01 02 01 02 00 20 00 00 00 Milch ab Hof A13 2012-01-10 09:30:00+01 2012-01-10 09:30:00+01 \N 2016-03-07 10:29:55.669 \N \N 1 \N \N 2012-01-09 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469 37 112 000007575752X f 11010 11010 122800001 2 1 1 D: 01 01 01 02 01 02 00 20 00 00 00 Milch ab Hof A13 2012-01-10 09:30:00+01 2012-01-10 09:30:00+01 \N 2016-03-07 10:29:55.669 \N \N \N \N 2012-01-09 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469
38 117 f 06 06060 06060 14206 2 1 1 D: 01 01 01 01 02 00 00 00 00 00 00 Sammelmilch N11 2012-01-25 11:00:00+01 \N \N 2012-01-27 17:04:47 553 727 1 \N \N 2012-01-23 00:00:00 2012-01-29 21:59:59 2016-03-17 09:19:04.94469 38 117 000007578031X f 06060 06060 14206 2 1 1 D: 01 01 01 01 02 00 00 00 00 00 00 Sammelmilch N11 2012-01-25 11:00:00+01 \N \N 2012-01-27 17:04:47 553 727 \N \N 2012-01-23 00:00:00 2012-01-29 21:59:59 2016-03-17 09:19:04.94469
39 307 f 11 11010 11010 122100004 2 1 1 D: 01 06 16 19 01 02 02 20 00 00 00 Schnitzel Schwein auch tiefgefroren N53 2012-02-24 09:30:00+01 2012-02-24 09:30:00+01 \N 2012-03-01 13:35:02 \N \N 1 \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469 39 307 000007575960X f 11010 11010 122100004 2 1 1 D: 01 06 16 19 01 02 02 20 00 00 00 Schnitzel Schwein auch tiefgefroren N53 2012-02-24 09:30:00+01 2012-02-24 09:30:00+01 \N 2012-03-01 13:35:02 \N \N \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469
40 203 f 11 11010 11010 122400003 2 1 1 D: 01 10 29 50 01 02 05 01 02 00 00 Schleie (Tinca tinca) Süßwasserfisch N61 2012-06-01 09:00:00+02 2012-06-01 09:00:00+02 \N 2012-06-11 11:16:53 \N \N 1 \N \N 2012-03-26 00:00:00 2012-12-09 21:59:59 2016-03-17 09:19:04.94469 40 203 000007575864X f 11010 11010 122400003 2 1 1 D: 01 10 29 50 01 02 05 01 02 00 00 Schleie (Tinca tinca) Süßwasserfisch N61 2012-06-01 09:00:00+02 2012-06-01 09:00:00+02 \N 2012-06-11 11:16:53 \N \N \N \N 2012-03-26 00:00:00 2012-12-09 21:59:59 2016-03-17 09:19:04.94469
41 357 f 06 06010 06010 120110255 2 1 1 D: 01 12 01 13 04 02 02 00 00 00 00 Tiefseegarnele (Pandalus sp.) N63 2012-01-10 10:00:00+01 \N \N 2012-01-19 11:08:01 \N 734 1 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469 41 357 000007578195X f 06010 06010 120110255 2 1 1 D: 01 12 01 13 04 02 02 00 00 00 00 Tiefseegarnele (Pandalus sp.) N63 2012-01-10 10:00:00+01 \N \N 2012-01-19 11:08:01 \N 734 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469
42 292 f 11 11010 11010 121300007 2 1 1 D: 01 15 01 01 01 02 01 00 00 00 00 Weizenkörner N31 2012-01-27 10:15:00+01 2012-01-27 10:15:00+01 \N 2012-02-01 09:11:02 \N \N 1 \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469 42 292 000007575939X f 11010 11010 121300007 2 1 1 D: 01 15 01 01 01 02 01 00 00 00 00 Weizenkörner N31 2012-01-27 10:15:00+01 2012-01-27 10:15:00+01 \N 2012-02-01 09:11:02 \N \N \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469
43 294 f 11 11010 11010 121300009 2 1 1 D: 01 15 06 03 01 02 01 00 00 00 00 Langkornreis N3Z 2012-01-27 10:45:00+01 2012-01-27 10:45:00+01 \N 2012-02-01 09:12:36 \N \N 1 \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469 43 294 000007575941X f 11010 11010 121300009 2 1 1 D: 01 15 06 03 01 02 01 00 00 00 00 Langkornreis N3Z 2012-01-27 10:45:00+01 2012-01-27 10:45:00+01 \N 2012-02-01 09:12:36 \N \N \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469
44 25 f 06 06010 06010 120614003 2 1 1 D: 01 29 01 02 00 00 00 00 02 00 00 Erdbeere N44 2012-06-14 08:00:00+02 \N \N 2012-06-19 09:32:23 \N 92 1 \N \N 2012-07-01 00:00:00 2012-07-31 21:59:59 2016-03-17 09:19:04.94469 44 25 000007587696X f 06010 06010 120614003 2 1 1 D: 01 29 01 02 00 00 00 00 02 00 00 Erdbeere N44 2012-06-14 08:00:00+02 \N \N 2012-06-19 09:32:23 \N 92 \N \N 2012-07-01 00:00:00 2012-07-31 21:59:59 2016-03-17 09:19:04.94469
45 145 f 06 06010 06010 120425002 2 1 1 D: 01 24 01 02 04 00 00 00 00 00 00 Kartoffel festkochend (Salatware) N25 2012-04-24 11:00:00+02 \N \N 2012-06-12 13:43:03 \N 734 1 \N \N 2012-04-01 00:00:00 2012-04-30 21:59:59 2016-03-17 09:19:04.94469 45 145 000007578087X f 06010 06010 120425002 2 1 1 D: 01 24 01 02 04 00 00 00 00 00 00 Kartoffel festkochend (Salatware) N25 2012-04-24 11:00:00+02 \N \N 2012-06-12 13:43:03 \N 734 \N \N 2012-04-01 00:00:00 2012-04-30 21:59:59 2016-03-17 09:19:04.94469
46 4 f 06 06010 06010 120619003 2 1 1 D: 01 25 01 01 00 00 00 00 02 00 00 Kopfsalat N21 2012-06-18 09:30:00+02 \N \N 2012-06-20 08:55:23 \N 78 1 \N \N 2012-06-01 00:00:00 2012-07-31 21:59:59 2016-03-17 09:19:04.94469 46 4 000007587554X f 06010 06010 120619003 2 1 1 D: 01 25 01 01 00 00 00 00 02 00 00 Kopfsalat N21 2012-06-18 09:30:00+02 \N \N 2012-06-20 08:55:23 \N 78 \N \N 2012-06-01 00:00:00 2012-07-31 21:59:59 2016-03-17 09:19:04.94469
47 140 f 06 06010 06010 120109006 2 1 1 D: 01 25 03 02 04 02 00 00 02 00 00 Gemüsepaprika N23 2012-01-04 06:30:00+01 \N \N 2012-01-23 14:52:40 \N 734 1 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469 47 140 000007578082X f 06010 06010 120109006 2 1 1 D: 01 25 03 02 04 02 00 00 02 00 00 Gemüsepaprika N23 2012-01-04 06:30:00+01 \N \N 2012-01-23 14:52:40 \N 734 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469
48 284 f 11 11010 11010 121100004 2 1 1 D: 01 25 04 06 01 02 02 00 02 00 00 Radieschen N22 2012-06-04 09:30:00+02 2012-06-04 09:30:00+02 \N 2012-06-11 11:16:53 \N \N 1 \N \N 2012-05-21 00:00:00 2012-07-01 21:59:59 2016-03-17 09:19:04.94469 48 284 000007575917X f 11010 11010 121100004 2 1 1 D: 01 25 04 06 01 02 02 00 02 00 00 Radieschen N22 2012-06-04 09:30:00+02 2012-06-04 09:30:00+02 \N 2012-06-11 11:16:53 \N \N \N \N 2012-05-21 00:00:00 2012-07-01 21:59:59 2016-03-17 09:19:04.94469
49 703 f 06 06010 06010 120426001 2 1 1 D: 01 27 08 03 01 00 02 00 00 00 00 Speisemorchel (Morchella esculenta) N2A 2012-04-24 22:00:00+02 \N \N 2012-04-26 13:00:15 \N 977 1 716 \N 2012-01-10 00:00:00 2012-01-10 21:59:59 2016-03-17 09:19:04.94469 49 703 000007590316X f 06010 06010 120426001 2 1 1 D: 01 27 08 03 01 00 02 00 00 00 00 Speisemorchel (Morchella esculenta) N2A 2012-04-24 22:00:00+02 \N \N 2012-04-26 13:00:15 \N 977 716 \N 2012-01-10 00:00:00 2012-01-10 21:59:59 2016-03-17 09:19:04.94469
50 301 f 11 11010 11010 121200009 2 1 1 D: 01 29 01 14 01 02 02 00 00 00 00 Moosbeere N46 2012-01-27 10:30:00+01 2012-01-27 10:30:00+01 \N 2012-02-06 09:04:26 \N \N 1 \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469 50 301 000007575950X f 11010 11010 121200009 2 1 1 D: 01 29 01 14 01 02 02 00 00 00 00 Moosbeere N46 2012-01-27 10:30:00+01 2012-01-27 10:30:00+01 \N 2012-02-06 09:04:26 \N \N \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469
51 300 f 11 11010 11010 121200008 2 1 1 D: 01 29 02 01 01 02 02 00 00 00 00 Apfel N42 2012-01-27 10:45:00+01 2012-01-27 10:45:00+01 \N 2012-02-01 09:14:31 \N \N 1 \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469 51 300 000007575949X f 11010 11010 121200008 2 1 1 D: 01 29 02 01 01 02 02 00 00 00 00 Apfel N42 2012-01-27 10:45:00+01 2012-01-27 10:45:00+01 \N 2012-02-01 09:14:31 \N \N \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469
52 24 f 06 06010 06010 120619004 2 1 1 D: 01 29 03 07 00 00 00 00 00 00 00 Süßkirsche N43 2012-06-18 11:30:00+02 \N \N 2012-06-20 08:56:20 \N 78 1 \N \N 2012-06-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469 52 24 000007587691X f 06010 06010 120619004 2 1 1 D: 01 29 03 07 00 00 00 00 00 00 00 Süßkirsche N43 2012-06-18 11:30:00+02 \N \N 2012-06-20 08:56:20 \N 78 \N \N 2012-06-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469
53 296 f 11 11010 11010 121200002 2 1 1 D: 01 29 05 14 01 02 02 00 02 00 00 Rhabarber N4Z 2012-05-07 10:10:00+02 2012-05-07 10:10:00+02 \N 2012-05-15 08:27:55 \N \N 1 \N \N 2012-08-06 00:00:00 2012-10-21 21:59:59 2016-03-17 09:19:04.94469 53 296 000007575943X f 11010 11010 121200002 2 1 1 D: 01 29 05 14 01 02 02 00 02 00 00 Rhabarber N4Z 2012-05-07 10:10:00+02 2012-05-07 10:10:00+02 \N 2012-05-15 08:27:55 \N \N \N \N 2012-08-06 00:00:00 2012-10-21 21:59:59 2016-03-17 09:19:04.94469
54 99 f 11 11010 11010 123100001 2 1 3 D: 01 50 90 01 06 02 05 00 00 00 00 51 Tageskost einschl. flüssiger Bestandteile und Getränke N81 2012-01-03 23:00:00+01 2012-01-04 22:00:00+01 82800 2012-01-23 08:56:08 \N \N 1 \N \N 2012-01-02 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469 54 99 000007575726X f 11010 11010 123100001 2 1 3 D: 01 50 90 01 06 02 05 00 00 00 00 51 Tageskost einschl. flüssiger Bestandteile und Getränke N81 2012-01-03 23:00:00+01 2012-01-04 22:00:00+01 82800 2012-01-23 08:56:08 \N \N \N \N 2012-01-02 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469
55 194 f 11 11010 11010 125500001 2 1 1 D: 01 59 01 01 05 02 03 03 01 01 00 Rohwasser aus Grundwasser nicht aufbereitet G51 2012-03-02 12:10:00+01 2012-03-02 12:10:00+01 \N 2012-03-22 08:12:08 \N \N 1 \N \N 2012-01-09 00:00:00 2012-04-01 21:59:59 2016-03-17 09:19:04.94469 55 194 000007575847X f 11010 11010 125500001 2 1 1 D: 01 59 01 01 05 02 03 03 01 01 00 Rohwasser aus Grundwasser nicht aufbereitet G51 2012-03-02 12:10:00+01 2012-03-02 12:10:00+01 \N 2012-03-22 08:12:08 \N \N \N \N 2012-01-09 00:00:00 2012-04-01 21:59:59 2016-03-17 09:19:04.94469
56 3 f 06 06010 06010 120515001 2 1 1 D: 01 59 03 01 01 02 05 01 02 00 00 Trinkwasser Zentralversorgung Grundwasser aufbereitet N71 2012-05-10 11:00:00+02 \N \N 2012-05-30 13:21:12 \N 716 1 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469 56 3 000007581040X f 06010 06010 120515001 2 1 1 D: 01 59 03 01 01 02 05 01 02 00 00 Trinkwasser Zentralversorgung Grundwasser aufbereitet N71 2012-05-10 11:00:00+02 \N \N 2012-05-30 13:21:12 \N 716 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469
57 1 f 06 06010 06010 120510002 2 1 1 D: 01 59 04 01 00 05 05 01 02 00 00 Trinkwasser Zentralversorgung Oberflächenwasser aufbereitet N72 2012-05-08 11:00:00+02 \N \N 2012-06-13 08:51:46 \N 726 1 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469 57 1 000007581034X f 06010 06010 120510002 2 1 1 D: 01 59 04 01 00 05 05 01 02 00 00 Trinkwasser Zentralversorgung Oberflächenwasser aufbereitet N72 2012-05-08 11:00:00+02 \N \N 2012-06-13 08:51:46 \N 726 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469
58 31 f 06 06010 06010 120210003 2 1 1 D: 01 59 05 01 05 05 05 01 02 00 00 Trinkwasser aus Mischwasser Zentralversorgung aufbereitet N73 2012-02-07 23:00:00+01 \N \N 2012-03-02 12:40:21 \N 724 1 \N \N 2012-02-06 00:00:00 2012-02-12 21:59:59 2016-03-17 09:19:04.94469 58 31 000007578204X f 06010 06010 120210003 2 1 1 D: 01 59 05 01 05 05 05 01 02 00 00 Trinkwasser aus Mischwasser Zentralversorgung aufbereitet N73 2012-02-07 23:00:00+01 \N \N 2012-03-02 12:40:21 \N 724 \N \N 2012-02-06 00:00:00 2012-02-12 21:59:59 2016-03-17 09:19:04.94469
59 84 f 06 06010 06010 120404004 2 1 1 D: 04 01 98 01 00 00 23 07 00 72 03 Unbearbeiteter Boden B33 2012-04-02 12:30:00+02 \N \N 2012-04-23 12:32:56 \N 60 1 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469 59 84 000007578312X f 06010 06010 120404004 2 1 1 D: 04 01 98 01 00 00 23 07 00 72 03 Unbearbeiteter Boden B33 2012-04-02 12:30:00+02 \N \N 2012-04-23 12:32:56 \N 60 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469
60 76 f 06 06010 06010 120326001 2 1 1 D: 04 01 42 28 00 00 10 08 00 31 03 Unbearbeiteter Boden B31 2012-03-26 09:00:00+02 \N \N 2012-04-18 11:47:05 \N 813 1 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469 60 76 000007578301X f 06010 06010 120326001 2 1 1 D: 04 01 42 28 00 00 10 08 00 31 03 Unbearbeiteter Boden B31 2012-03-26 09:00:00+02 \N \N 2012-04-18 11:47:05 \N 813 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469
61 88 f 06 06010 06010 120326002 2 1 1 D: 04 01 24 84 00 00 60 15 00 31 07 Unbearbeiteter Boden B34 2012-03-26 10:40:00+02 \N \N 2012-04-18 11:47:21 \N 813 1 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469 61 88 000007578316X f 06010 06010 120326002 2 1 1 D: 04 01 24 84 00 00 60 15 00 31 07 Unbearbeiteter Boden B34 2012-03-26 10:40:00+02 \N \N 2012-04-18 11:47:21 \N 813 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469
62 180 f 11 11010 11010 126100037 2 1 1 D: 06 04 05 01 00 00 00 02 01 01 00 Sediment G13 2012-03-12 10:30:00+01 2012-03-12 10:30:00+01 \N 2012-03-20 12:20:47 \N \N 1 \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469 62 180 000007575819X f 11010 11010 126100037 2 1 1 D: 06 04 05 01 00 00 00 02 01 01 00 Sediment G13 2012-03-12 10:30:00+01 2012-03-12 10:30:00+01 \N 2012-03-20 12:20:47 \N \N \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469
63 97 f 06 06010 06010 120306001 2 1 3 D: 06 05 00 01 00 00 00 06 00 00 01 Schwebstoffe G12 2012-01-24 09:00:00+01 2012-02-24 09:00:00+01 2678400 2012-03-09 08:51:44 \N 60 1 \N \N 2012-01-23 00:00:00 2012-02-19 21:59:59 2016-03-17 09:19:04.94469 63 97 000007578331X f 06010 06010 120306001 2 1 3 D: 06 05 00 01 00 00 00 06 00 00 01 Schwebstoffe G12 2012-01-24 09:00:00+01 2012-02-24 09:00:00+01 2678400 2012-03-09 08:51:44 \N 60 \N \N 2012-01-23 00:00:00 2012-02-19 21:59:59 2016-03-17 09:19:04.94469
64 91 f 06 06060 06060 14246 2 1 1 D: 06 02 00 01 00 00 01 02 02 00 00 Oberflächenwasser G11 2012-02-13 11:00:00+01 \N \N 2012-03-02 11:00:40 553 60 1 \N \N 2012-02-13 00:00:00 2012-02-19 21:59:59 2016-03-17 09:19:04.94469 64 91 000007578319X f 06060 06060 14246 2 1 1 D: 06 02 00 01 00 00 01 02 02 00 00 Oberflächenwasser G11 2012-02-13 11:00:00+01 \N \N 2012-03-02 11:00:40 553 60 \N \N 2012-02-13 00:00:00 2012-02-19 21:59:59 2016-03-17 09:19:04.94469
65 186 f 11 11010 11010 126100049 2 1 1 D: 06 05 00 02 00 00 00 01 00 00 00 Schwebstoffe G22 2012-03-06 11:00:00+01 2012-03-06 11:00:00+01 \N 2012-03-12 09:23:31 \N \N 1 \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469 65 186 000007575831X f 11010 11010 126100049 2 1 1 D: 06 05 00 02 00 00 00 01 00 00 00 Schwebstoffe G22 2012-03-06 11:00:00+01 2012-03-06 11:00:00+01 \N 2012-03-12 09:23:31 \N \N \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469
66 174 f 11 11010 11010 126100025 2 1 1 D: 06 04 05 02 00 00 00 02 01 01 00 Sediment G23 2012-03-06 11:00:00+01 2012-03-06 11:00:00+01 \N 2012-03-20 12:20:47 \N \N 1 \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469 66 174 000007575807X f 11010 11010 126100025 2 1 1 D: 06 04 05 02 00 00 00 02 01 01 00 Sediment G23 2012-03-06 11:00:00+01 2012-03-06 11:00:00+01 \N 2012-03-20 12:20:47 \N \N \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469
67 160 f 11 11010 11010 126100001 2 1 3 D: 06 02 00 02 00 00 01 04 02 00 00 Oberflächenwasser G21 2012-01-17 11:00:00+01 2012-03-13 11:00:00+01 4838400 2012-03-22 08:12:08 \N \N 1 \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469 67 160 000007575783X f 11010 11010 126100001 2 1 3 D: 06 02 00 02 00 00 01 04 02 00 00 Oberflächenwasser G21 2012-01-17 11:00:00+01 2012-03-13 11:00:00+01 4838400 2012-03-22 08:12:08 \N \N \N \N 2012-01-01 00:00:00 2012-03-31 21:59:59 2016-03-17 09:19:04.94469
68 200 f 11 11010 11010 125500010 2 1 1 D: 06 03 00 01 00 00 01 03 00 00 00 Grundwasser G41 2012-04-27 07:00:00+02 2012-04-27 07:00:00+02 \N 2012-05-30 09:36:31 \N \N 1 \N \N 2012-01-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469 68 200 000007575856X f 11010 11010 125500010 2 1 1 D: 06 03 00 01 00 00 01 03 00 00 00 Grundwasser G41 2012-04-27 07:00:00+02 2012-04-27 07:00:00+02 \N 2012-05-30 09:36:31 \N \N \N \N 2012-01-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469
69 45 f 06 06010 06010 120120005 2 1 1 D: 08 01 03 01 00 00 00 06 00 00 00 Abwasser A11 2012-01-19 06:00:00+01 \N \N 2012-02-01 13:30:03 \N 60 1 \N \N 2012-01-09 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469 69 45 000007578239X f 06010 06010 120120005 2 1 1 D: 08 01 03 01 00 00 00 06 00 00 00 Abwasser A11 2012-01-19 06:00:00+01 \N \N 2012-02-01 13:30:03 \N 60 \N \N 2012-01-09 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469
70 55 f 06 06010 06010 120120006 2 1 1 D: 08 02 04 01 00 00 04 02 00 00 00 Schlamm aus Abwässern A13 2012-01-19 07:00:00+01 \N \N 2012-02-02 13:38:43 \N 60 1 \N \N 2012-01-09 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469 70 55 000007578259X f 06010 06010 120120006 2 1 1 D: 08 02 04 01 00 00 04 02 00 00 00 Schlamm aus Abwässern A13 2012-01-19 07:00:00+01 \N \N 2012-02-02 13:38:43 \N 60 \N \N 2012-01-09 00:00:00 2012-01-15 21:59:59 2016-03-17 09:19:04.94469
71 69 f 06 06010 06010 120309008 2 1 1 D: 09 01 16 01 00 00 00 00 00 00 00 Reststoffe aus Verbrennungsanlagen A23 2012-03-09 11:30:00+01 \N \N 2012-03-15 10:33:22 \N 813 1 \N \N 2012-03-05 00:00:00 2012-03-11 21:59:59 2016-03-17 09:19:04.94469 71 69 000007578287X f 06010 06010 120309008 2 1 1 D: 09 01 16 01 00 00 00 00 00 00 00 Reststoffe aus Verbrennungsanlagen A23 2012-03-09 11:30:00+01 \N \N 2012-03-15 10:33:22 \N 813 \N \N 2012-03-05 00:00:00 2012-03-11 21:59:59 2016-03-17 09:19:04.94469
72 67 f 06 06010 06010 120309009 2 1 1 D: 09 01 07 01 00 00 00 00 00 00 00 Reststoffe aus Verbrennungsanlagen A22 2012-03-09 11:30:00+01 \N \N 2012-03-15 10:33:31 \N 813 1 \N \N 2012-03-05 00:00:00 2012-03-11 21:59:59 2016-03-17 09:19:04.94469 72 67 000007578283X f 06010 06010 120309009 2 1 1 D: 09 01 07 01 00 00 00 00 00 00 00 Reststoffe aus Verbrennungsanlagen A22 2012-03-09 11:30:00+01 \N \N 2012-03-15 10:33:31 \N 813 \N \N 2012-03-05 00:00:00 2012-03-11 21:59:59 2016-03-17 09:19:04.94469
73 70 f 06 06010 06010 120309004 2 1 1 D: 09 01 14 05 00 00 00 00 00 00 00 Reststoffe aus Verbrennungsanlagen A24 2012-03-07 09:00:00+01 \N \N 2012-03-15 10:32:18 \N 60 1 \N \N 2012-03-05 00:00:00 2012-03-11 21:59:59 2016-03-17 09:19:04.94469 73 70 000007578289X f 06010 06010 120309004 2 1 1 D: 09 01 14 05 00 00 00 00 00 00 00 Reststoffe aus Verbrennungsanlagen A24 2012-03-07 09:00:00+01 \N \N 2012-03-15 10:32:18 \N 60 \N \N 2012-03-05 00:00:00 2012-03-11 21:59:59 2016-03-17 09:19:04.94469
74 65 f 06 06010 06010 120309005 2 1 1 D: 09 01 02 05 00 00 00 00 00 00 00 Reststoffe aus Verbrennungsanlagen A21 2012-03-07 09:00:00+01 \N \N 2012-03-15 12:09:13 \N 60 1 \N \N 2012-03-05 00:00:00 2012-03-11 21:59:59 2016-03-17 09:19:04.94469 74 65 000007578279X f 06010 06010 120309005 2 1 1 D: 09 01 02 05 00 00 00 00 00 00 00 Reststoffe aus Verbrennungsanlagen A21 2012-03-07 09:00:00+01 \N \N 2012-03-15 12:09:13 \N 60 \N \N 2012-03-05 00:00:00 2012-03-11 21:59:59 2016-03-17 09:19:04.94469
75 78 f 06 06010 06010 120330006 2 1 1 D: 04 02 42 26 00 00 01 25 00 31 03 Ackerboden B32 2012-03-28 11:00:00+02 \N \N 2012-04-20 12:45:31 \N 60 1 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469 75 78 000007578303X f 06010 06010 120330006 2 1 1 D: 04 02 42 26 00 00 01 25 00 31 03 Ackerboden B32 2012-03-28 11:00:00+02 \N \N 2012-04-20 12:45:31 \N 60 \N \N 2012-04-02 00:00:00 2012-04-08 21:59:59 2016-03-17 09:19:04.94469
76 36 f 06 06010 06010 120502004 2 1 1 D: 01 48 25 04 02 00 00 00 00 00 00 Milch für die besondere Ernährung von Kleinkindern N82 2012-04-27 08:00:00+02 \N \N 2012-09-18 12:41:00 \N 729 1 \N \N 2012-04-01 00:00:00 2012-04-30 21:59:59 2016-03-17 09:19:04.94469 76 36 000007578214X f 06010 06010 120502004 2 1 1 D: 01 48 25 04 02 00 00 00 00 00 00 Milch für die besondere Ernährung von Kleinkindern N82 2012-04-27 08:00:00+02 \N \N 2012-09-18 12:41:00 \N 729 \N \N 2012-04-01 00:00:00 2012-04-30 21:59:59 2016-03-17 09:19:04.94469
77 157 f 11 11010 11010 125100001 2 1 1 D: 02 01 01 01 00 02 00 00 00 00 00 21 00 00 00 01 00 00 00 00 00 00 00 00 Grünfutter A3 2012-05-21 09:30:00+02 2012-05-21 09:30:00+02 \N 2016-03-07 11:04:15.14 \N \N 1 \N \N 2012-04-16 00:00:00 2012-06-17 21:59:59 2016-03-17 09:19:04.94469 77 157 000007575772X f 11010 11010 125100001 2 1 1 D: 02 01 01 01 00 02 00 00 00 00 00 21 00 00 00 01 00 00 00 00 00 00 00 00 Grünfutter A3 2012-05-21 09:30:00+02 2012-05-21 09:30:00+02 \N 2016-03-07 11:04:15.14 \N \N \N \N 2012-04-16 00:00:00 2012-06-17 21:59:59 2016-03-17 09:19:04.94469
78 19 f 06 06010 06010 120614002 2 1 1 D: 01 25 02 25 00 00 00 00 02 00 00 Spargel, weiß N24 2012-06-14 07:00:00+02 \N \N 2012-06-19 09:31:23 \N 92 1 \N \N 2012-06-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469 78 19 000007587671X f 06010 06010 120614002 2 1 1 D: 01 25 02 25 00 00 00 00 02 00 00 Spargel, weiß N24 2012-06-14 07:00:00+02 \N \N 2012-06-19 09:31:23 \N 92 \N \N 2012-06-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469
79 707 f 11 11010 11010 125100012 2 1 1 D: 02 02 20 00 00 02 00 00 00 00 00 Silagen F5Z 2012-01-11 10:00:00+01 2012-01-11 10:00:00+01 \N 2012-01-23 08:56:08 \N \N 1 \N \N \N \N 2016-03-17 09:19:04.94469 79 707 000007613597X f 11010 11010 125100012 2 1 1 D: 02 02 20 00 00 02 00 00 00 00 00 Silagen F5Z 2012-01-11 10:00:00+01 2012-01-11 10:00:00+01 \N 2012-01-23 08:56:08 \N \N \N \N \N \N 2016-03-17 09:19:04.94469
80 158 f 11 11010 11010 125100007 2 1 1 D: 02 06 48 00 00 01 00 00 00 00 00 Nebenerzeugnisse trocken F62 2012-01-27 10:15:00+01 2012-01-27 10:15:00+01 \N 2012-02-06 08:59:59 \N \N 1 \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469 80 158 000007575778X f 11010 11010 125100007 2 1 1 D: 02 06 48 00 00 01 00 00 00 00 00 Nebenerzeugnisse trocken F62 2012-01-27 10:15:00+01 2012-01-27 10:15:00+01 \N 2012-02-06 08:59:59 \N \N \N \N 2012-01-01 00:00:00 2012-12-31 21:59:59 2016-03-17 09:19:04.94469
81 155 f 11 11010 11010 125300001 2 1 1 D: 03 09 01 00 00 00 00 00 00 00 00 Pflanzliche Indikatoren I13 2012-05-14 10:00:00+02 2012-05-14 10:00:00+02 \N 2012-05-30 12:04:35 \N \N 1 \N \N 2012-05-07 00:00:00 2012-09-30 21:59:59 2016-03-17 09:19:04.94469 81 155 000007575767X f 11010 11010 125300001 2 1 1 D: 03 09 01 00 00 00 00 00 00 00 00 Pflanzliche Indikatoren I13 2012-05-14 10:00:00+02 2012-05-14 10:00:00+02 \N 2012-05-30 12:04:35 \N \N \N \N 2012-05-07 00:00:00 2012-09-30 21:59:59 2016-03-17 09:19:04.94469
82 73 f 06 06060 06060 14360 2 1 1 D: 09 03 00 00 00 00 00 00 00 00 00 Kompostierung A41 2012-05-10 10:00:00+02 \N \N 2012-05-24 12:45:00 553 813 1 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469 82 73 000007578295X f 06060 06060 14360 2 1 1 D: 09 03 00 00 00 00 00 00 00 00 00 Kompostierung A41 2012-05-10 10:00:00+02 \N \N 2012-05-24 12:45:00 553 813 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469
83 71 f 06 06010 06010 120523008 2 1 1 D: 09 02 08 00 00 00 00 00 00 00 00 Deponie A31 2012-05-11 10:30:00+02 \N \N 2012-06-04 14:03:58 \N 813 1 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469 83 71 000007578291X f 06010 06010 120523008 2 1 1 D: 09 02 08 00 00 00 00 00 00 00 00 Deponie A31 2012-05-11 10:30:00+02 \N \N 2012-06-04 14:03:58 \N 813 \N \N 2012-05-07 00:00:00 2012-05-13 21:59:59 2016-03-17 09:19:04.94469
84 354 f 06 06010 06010 120110258 2 1 1 D: 01 10 55 00 00 00 00 00 00 00 00 Barschartige Fische Seefische Zuschnitte N62 2012-01-10 09:00:00+01 \N \N 2012-01-19 10:55:44 \N 734 1 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469 84 354 000007578191X f 06010 06010 120110258 2 1 1 D: 01 10 55 00 00 00 00 00 00 00 00 Barschartige Fische Seefische Zuschnitte N62 2012-01-10 09:00:00+01 \N \N 2012-01-19 10:55:44 \N 734 \N \N 2012-01-01 00:00:00 2012-01-31 21:59:59 2016-03-17 09:19:04.94469
85 353 f 06 06010 06010 120117004 2 1 1 D: 01 06 23 00 05 02 02 00 00 00 00 Fleischteilstücke Lamm/Schaf auch tiefgefroren N55 2012-01-17 10:00:00+01 \N \N 2012-01-26 13:03:27 \N 734 1 \N \N 2012-01-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469 85 353 000007578188X f 06010 06010 120117004 2 1 1 D: 01 06 23 00 05 02 02 00 00 00 00 Fleischteilstücke Lamm/Schaf auch tiefgefroren N55 2012-01-17 10:00:00+01 \N \N 2012-01-26 13:03:27 \N 734 \N \N 2012-01-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469
86 147 f 06 06060 06060 14242 2 1 1 D: 01 06 02 00 00 00 00 00 00 00 00 Fleischteilstücke Rind auch tiefgefroren N51 2012-02-22 11:00:00+01 \N \N 2012-02-29 14:45:58 553 714 1 \N \N 2012-02-01 00:00:00 2012-02-29 21:59:59 2016-03-17 09:19:04.94469 86 147 000007578141X f 06060 06060 14242 2 1 1 D: 01 06 02 00 00 00 00 00 00 00 00 Fleischteilstücke Rind auch tiefgefroren N51 2012-02-22 11:00:00+01 \N \N 2012-02-29 14:45:58 553 714 \N \N 2012-02-01 00:00:00 2012-02-29 21:59:59 2016-03-17 09:19:04.94469
87 406 f 12 12020 12020 N0198FU12 2 1 1 D: 02 01 16 00 00 00 00 00 00 00 00 Grünfutter F12 2012-06-07 09:00:00+02 \N \N 2012-07-12 11:32:17 \N 1859 1 \N \N 2012-04-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469 87 406 000007589328X f 12020 12020 N0198FU12 2 1 1 D: 02 01 16 00 00 00 00 00 00 00 00 Grünfutter F12 2012-06-07 09:00:00+02 \N \N 2012-07-12 11:32:17 \N 1859 \N \N 2012-04-01 00:00:00 2012-06-30 21:59:59 2016-03-17 09:19:04.94469
88 \. 88 \.
89 89
90 90
91 ALTER TABLE probe ENABLE TRIGGER ALL; 91 ALTER TABLE probe ENABLE TRIGGER ALL;
92 92
96 -- Data for Name: messung; Type: TABLE DATA; Schema: land; Owner: postgres 96 -- Data for Name: messung; Type: TABLE DATA; Schema: land; Owner: postgres
97 -- 97 --
98 98
99 ALTER TABLE messung DISABLE TRIGGER ALL; 99 ALTER TABLE messung DISABLE TRIGGER ALL;
100 100
101 COPY messung (id, probe_id, nebenproben_nr, mmt_id, messdauer, messzeitpunkt, fertig, status, letzte_aenderung, geplant, tree_modified) FROM stdin; 101 COPY messung (id, id_alt, probe_id, nebenproben_nr, mmt_id, messdauer, messzeitpunkt, fertig, status, letzte_aenderung, geplant, tree_modified) FROM stdin;
102 179 660 01G1 G1 82693 2012-01-30 09:32:00+01 t 571 2012-03-06 17:42:26 t 2016-03-17 09:19:04.94469 102 179 1 660 01G1 G1 82693 2012-01-30 09:32:00+01 t 571 2012-03-06 17:42:26 t 2016-03-17 09:19:04.94469
103 198 409 01G1 G1 161733 2012-03-19 23:00:00+01 t 572 2012-04-17 19:42:25 t 2016-03-17 09:19:04.94469 103 198 1 409 01G1 G1 161733 2012-03-19 23:00:00+01 t 572 2012-04-17 19:42:25 t 2016-03-17 09:19:04.94469
104 646 42 00G1 G1 60000 2012-01-09 14:48:00+01 f 573 2016-03-08 10:23:04.791 t 2016-03-17 09:19:04.94469 104 646 1 42 00G1 G1 60000 2012-01-09 14:48:00+01 f 573 2016-03-08 10:23:04.791 t 2016-03-17 09:19:04.94469
105 699 313 G101 G1 247215 2012-02-24 11:00:00+01 t 574 2012-03-06 17:42:26 t 2016-03-17 09:19:04.94469 105 699 1 313 G101 G1 247215 2012-02-24 11:00:00+01 t 574 2012-03-06 17:42:26 t 2016-03-17 09:19:04.94469
106 697 311 G101 G1 90333 2012-06-13 11:00:00+02 t 575 2012-06-26 16:43:09 t 2016-03-17 09:19:04.94469 106 697 1 311 G101 G1 90333 2012-06-13 11:00:00+02 t 575 2012-06-26 16:43:09 t 2016-03-17 09:19:04.94469
107 765 112 BS01 BS 60000 2012-02-15 14:48:00+01 t 579 2012-02-22 15:42:21 t 2016-03-17 09:19:04.94469 107 765 2 112 BS01 BS 60000 2012-02-15 14:48:00+01 t 579 2012-02-22 15:42:21 t 2016-03-17 09:19:04.94469
108 764 112 G101 G1 164945 2012-01-16 11:00:00+01 t 578 2012-01-25 11:42:08 t 2016-03-17 09:19:04.94469 108 764 1 112 G101 G1 164945 2012-01-16 11:00:00+01 t 578 2012-01-25 11:42:08 t 2016-03-17 09:19:04.94469
109 876 117 0001 G1 100000 2012-01-25 13:08:00+01 t 576 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469 109 876 1 117 0001 G1 100000 2012-01-25 13:08:00+01 t 576 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469
110 877 117 0002 BS 36000 2012-05-09 12:00:00+02 t 577 2012-08-16 10:44:27 t 2016-03-17 09:19:04.94469 110 877 2 117 0002 BS 36000 2012-05-09 12:00:00+02 t 577 2012-08-16 10:44:27 t 2016-03-17 09:19:04.94469
111 693 307 G101 G1 247808 2012-02-24 11:00:00+01 t 580 2012-03-06 17:42:26 t 2016-03-17 09:19:04.94469 111 693 1 307 G101 G1 247808 2012-02-24 11:00:00+01 t 580 2012-03-06 17:42:26 t 2016-03-17 09:19:04.94469
112 604 203 G101 G1 100732 2012-06-05 08:00:00+02 t 581 2012-06-11 15:45:32 t 2016-03-17 09:19:04.94469 112 604 1 203 G101 G1 100732 2012-06-05 08:00:00+02 t 581 2012-06-11 15:45:32 t 2016-03-17 09:19:04.94469
113 455 357 00G1 G1 60000 2012-01-12 14:24:00+01 t 582 2012-01-20 19:42:14 t 2016-03-17 09:19:04.94469 113 455 1 357 00G1 G1 60000 2012-01-12 14:24:00+01 t 582 2012-01-20 19:42:14 t 2016-03-17 09:19:04.94469
114 677 292 G101 G1 330852 2012-01-27 12:00:00+01 t 583 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469 114 677 1 292 G101 G1 330852 2012-01-27 12:00:00+01 t 583 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469
115 679 294 G101 G1 245865 2012-01-27 12:00:00+01 t 584 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469 115 679 1 294 G101 G1 245865 2012-01-27 12:00:00+01 t 584 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469
116 907 25 00G1 G1 60000 2012-06-14 14:05:00+02 f 585 2016-03-08 16:46:57.46 t 2016-03-17 09:19:04.94469 116 907 1 25 00G1 G1 60000 2012-06-14 14:05:00+02 f 585 2016-03-08 16:46:57.46 t 2016-03-17 09:19:04.94469
117 409 145 00G1 G1 60000 2012-04-25 13:10:00+02 t 586 2012-06-15 18:43:15 t 2016-03-17 09:19:04.94469 117 409 1 145 00G1 G1 60000 2012-04-25 13:10:00+02 t 586 2012-06-15 18:43:15 t 2016-03-17 09:19:04.94469
118 45 4 00G1 G1 60000 2012-06-19 13:40:00+02 t 587 2012-06-26 15:42:31 t 2016-03-17 09:19:04.94469 118 45 1 4 00G1 G1 60000 2012-06-19 13:40:00+02 t 587 2012-06-26 15:42:31 t 2016-03-17 09:19:04.94469
119 404 140 00G1 G1 60000 2012-01-05 14:35:00+01 t 588 2012-01-25 11:42:08 t 2016-03-17 09:19:04.94469 119 404 1 140 00G1 G1 60000 2012-01-05 14:35:00+01 t 588 2012-01-25 11:42:08 t 2016-03-17 09:19:04.94469
120 669 284 G101 G1 105051 2012-06-05 07:00:00+02 t 589 2012-06-15 18:43:15 t 2016-03-17 09:19:04.94469 120 669 1 284 G101 G1 105051 2012-06-05 07:00:00+02 t 589 2012-06-15 18:43:15 t 2016-03-17 09:19:04.94469
121 382 703 00G1 G1 3600 2012-04-26 11:33:00+02 t 590 2012-05-07 11:45:47 t 2016-03-17 09:19:04.94469 121 382 1 703 00G1 G1 3600 2012-04-26 11:33:00+02 t 590 2012-05-07 11:45:47 t 2016-03-17 09:19:04.94469
122 687 301 G101 G1 249270 2012-02-03 10:00:00+01 t 591 2012-02-16 16:42:24 t 2016-03-17 09:19:04.94469 122 687 1 301 G101 G1 249270 2012-02-03 10:00:00+01 t 591 2012-02-16 16:42:24 t 2016-03-17 09:19:04.94469
123 686 300 G101 G1 166714 2012-01-30 10:00:00+01 t 592 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469 123 686 1 300 G101 G1 166714 2012-01-30 10:00:00+01 t 592 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469
124 906 24 00G1 G1 60000 2012-06-19 13:33:00+02 t 593 2012-06-26 16:43:09 t 2016-03-17 09:19:04.94469 124 906 1 24 00G1 G1 60000 2012-06-19 13:33:00+02 t 593 2012-06-26 16:43:09 t 2016-03-17 09:19:04.94469
125 682 296 G101 G1 158952 2012-05-07 12:00:00+02 t 594 2012-05-23 12:42:55 t 2016-03-17 09:19:04.94469 125 682 1 296 G101 G1 158952 2012-05-07 12:00:00+02 t 594 2012-05-23 12:42:55 t 2016-03-17 09:19:04.94469
126 749 99 G101 G1 421389 2012-01-11 10:00:00+01 t 595 2012-01-25 12:42:18 t 2016-03-17 09:19:04.94469 126 749 1 99 G101 G1 421389 2012-01-11 10:00:00+01 t 595 2012-01-25 12:42:18 t 2016-03-17 09:19:04.94469
127 855 194 BH01 BH 36000 2012-03-28 12:00:00+02 t 596 2012-04-16 14:42:18 t 2016-03-17 09:19:04.94469 127 855 1 194 BH01 BH 36000 2012-03-28 12:00:00+02 t 596 2012-04-16 14:42:18 t 2016-03-17 09:19:04.94469
128 856 194 G101 G1 346327 2012-03-16 11:00:00+01 t 597 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469 128 856 4 194 G101 G1 346327 2012-03-16 11:00:00+01 t 597 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469
129 857 194 A101 A1 422783 2012-04-27 12:00:00+02 t 598 2012-05-14 13:42:57 t 2016-03-17 09:19:04.94469 129 857 2 194 A101 A1 422783 2012-04-27 12:00:00+02 t 598 2012-05-14 13:42:57 t 2016-03-17 09:19:04.94469
130 858 194 Bs01 BS 60000 2012-05-09 14:20:00+02 t 599 2012-05-30 12:42:36 t 2016-03-17 09:19:04.94469 130 858 3 194 Bs01 BS 60000 2012-05-09 14:20:00+02 t 599 2012-05-30 12:42:36 t 2016-03-17 09:19:04.94469
131 859 194 A102 A1 422795 2012-04-27 12:00:00+02 t 600 2012-05-14 13:42:57 f 2016-03-17 09:19:04.94469 131 859 5 194 A102 A1 422795 2012-04-27 12:00:00+02 t 600 2012-05-14 13:42:57 f 2016-03-17 09:19:04.94469
132 781 3 00G1 G1 60000 2012-05-29 12:59:00+02 t 601 2012-06-29 11:42:27 t 2016-03-17 09:19:04.94469 132 781 3 3 00G1 G1 60000 2012-05-29 12:59:00+02 t 601 2012-06-29 11:42:27 t 2016-03-17 09:19:04.94469
133 782 3 0003 BS 36000 2012-06-15 10:00:00+02 t 602 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469 133 782 1 3 0003 BS 36000 2012-06-15 10:00:00+02 t 602 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469
134 783 3 00A1 A1 230005 2012-08-31 08:47:00+02 t 603 2012-10-02 10:42:49 t 2016-03-17 09:19:04.94469 134 783 4 3 00A1 A1 230005 2012-08-31 08:47:00+02 t 603 2012-10-02 10:42:49 t 2016-03-17 09:19:04.94469
135 784 3 0004 BH 18000 2012-06-29 10:00:00+02 t 604 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469 135 784 2 3 0004 BH 18000 2012-06-29 10:00:00+02 t 604 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469
136 776 1 00A1 A1 230005 2012-08-31 08:44:00+02 t 605 2012-10-02 10:42:49 t 2016-03-17 09:19:04.94469 136 776 1 1 00A1 A1 230005 2012-08-31 08:44:00+02 t 605 2012-10-02 10:42:49 t 2016-03-17 09:19:04.94469
137 777 1 00G1 G1 60000 2012-06-11 13:52:00+02 t 606 2012-06-29 11:42:27 t 2016-03-17 09:19:04.94469 137 777 2 1 00G1 G1 60000 2012-06-11 13:52:00+02 t 606 2012-06-29 11:42:27 t 2016-03-17 09:19:04.94469
138 778 1 0004 BH 18000 2012-06-29 10:00:00+02 t 607 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469 138 778 4 1 0004 BH 18000 2012-06-29 10:00:00+02 t 607 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469
139 779 1 0003 BS 36000 2012-06-15 10:00:00+02 t 608 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469 139 779 3 1 0003 BS 36000 2012-06-15 10:00:00+02 t 608 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469
140 457 31 00G1 G1 60000 2012-03-01 15:33:00+01 t 609 2012-03-15 14:42:18 t 2016-03-17 09:19:04.94469 140 457 1 31 00G1 G1 60000 2012-03-01 15:33:00+01 t 609 2012-03-15 14:42:18 t 2016-03-17 09:19:04.94469
141 546 84 00G1 G1 60000 2012-04-17 13:21:00+02 t 610 2012-06-29 13:42:59 t 2016-03-17 09:19:04.94469 141 546 2 84 00G1 G1 60000 2012-04-17 13:21:00+02 t 610 2012-06-29 13:42:59 t 2016-03-17 09:19:04.94469
142 547 84 0003 BS 36000 2012-11-13 11:00:00+01 t 611 2013-02-22 11:42:23 t 2016-03-17 09:19:04.94469 142 547 1 84 0003 BS 36000 2012-11-13 11:00:00+01 t 611 2013-02-22 11:42:23 t 2016-03-17 09:19:04.94469
143 536 76 00G1 G1 60000 2012-03-30 12:20:00+02 t 612 2012-04-20 17:42:12 t 2016-03-17 09:19:04.94469 143 536 1 76 00G1 G1 60000 2012-03-30 12:20:00+02 t 612 2012-04-20 17:42:12 t 2016-03-17 09:19:04.94469
144 552 88 0003 BS 36000 2012-10-25 10:00:00+02 t 613 2012-11-09 17:42:48 t 2016-03-17 09:19:04.94469 144 552 1 88 0003 BS 36000 2012-10-25 10:00:00+02 t 613 2012-11-09 17:42:48 t 2016-03-17 09:19:04.94469
145 553 88 00G1 G1 60000 2012-03-30 12:15:00+02 t 614 2012-04-20 17:42:12 t 2016-03-17 09:19:04.94469 145 553 2 88 00G1 G1 60000 2012-03-30 12:15:00+02 t 614 2012-04-20 17:42:12 t 2016-03-17 09:19:04.94469
146 841 180 G101 G1 246610 2012-03-16 11:00:00+01 t 615 2012-03-27 13:42:09 t 2016-03-17 09:19:04.94469 146 841 1 180 G101 G1 246610 2012-03-16 11:00:00+01 t 615 2012-03-27 13:42:09 t 2016-03-17 09:19:04.94469
147 574 97 00G1 G1 60000 2012-03-07 14:12:00+01 t 616 2012-03-27 13:42:09 t 2016-03-17 09:19:04.94469 147 574 1 97 00G1 G1 60000 2012-03-07 14:12:00+01 t 616 2012-03-27 13:42:09 t 2016-03-17 09:19:04.94469
148 558 91 0003 BH 18000 2012-03-12 21:40:00+01 t 617 2012-07-27 11:42:24 t 2016-03-17 09:19:04.94469 148 558 2 91 0003 BH 18000 2012-03-12 21:40:00+01 t 617 2012-07-27 11:42:24 t 2016-03-17 09:19:04.94469
149 559 91 0001 G1 150000 2012-02-29 16:36:00+01 t 618 2012-03-06 12:42:22 t 2016-03-17 09:19:04.94469 149 559 1 91 0001 G1 150000 2012-02-29 16:36:00+01 t 618 2012-03-06 12:42:22 t 2016-03-17 09:19:04.94469
150 847 186 G101 G1 244982 2012-03-09 12:00:00+01 t 619 2012-03-12 11:42:52 t 2016-03-17 09:19:04.94469 150 847 1 186 G101 G1 244982 2012-03-09 12:00:00+01 t 619 2012-03-12 11:42:52 t 2016-03-17 09:19:04.94469
151 835 174 G101 G1 264401 2012-03-13 09:00:00+01 t 620 2012-03-27 13:42:09 t 2016-03-17 09:19:04.94469 151 835 1 174 G101 G1 264401 2012-03-13 09:00:00+01 t 620 2012-03-27 13:42:09 t 2016-03-17 09:19:04.94469
152 792 160 BS01 BS 60000 2012-05-14 13:50:00+02 t 621 2012-05-22 15:42:28 t 2016-03-17 09:19:04.94469 152 792 1 160 BS01 BS 60000 2012-05-14 13:50:00+02 t 621 2012-05-22 15:42:28 t 2016-03-17 09:19:04.94469
153 793 160 BH01 BH 36000 2012-03-27 12:00:00+02 t 622 2012-04-18 17:42:24 t 2016-03-17 09:19:04.94469 153 793 4 160 BH01 BH 36000 2012-03-27 12:00:00+02 t 622 2012-04-18 17:42:24 t 2016-03-17 09:19:04.94469
154 794 160 G101 G1 136410 2012-03-20 12:00:00+01 t 623 2012-03-27 13:42:09 t 2016-03-17 09:19:04.94469 154 794 3 160 G101 G1 136410 2012-03-20 12:00:00+01 t 623 2012-03-27 13:42:09 t 2016-03-17 09:19:04.94469
155 795 160 A101 A1 416061 2012-05-02 12:00:00+02 t 624 2012-05-11 19:42:33 t 2016-03-17 09:19:04.94469 155 795 2 160 A101 A1 416061 2012-05-02 12:00:00+02 t 624 2012-05-11 19:42:33 t 2016-03-17 09:19:04.94469
156 796 160 A102 A1 338466 2012-05-03 12:00:00+02 t 625 2012-05-11 19:42:33 f 2016-03-17 09:19:04.94469 156 796 5 160 A102 A1 338466 2012-05-03 12:00:00+02 t 625 2012-05-11 19:42:33 f 2016-03-17 09:19:04.94469
157 593 200 BH01 BH 36000 2012-07-05 12:00:00+02 t 626 2012-07-27 11:42:24 t 2016-03-17 09:19:04.94469 157 593 1 200 BH01 BH 36000 2012-07-05 12:00:00+02 t 626 2012-07-27 11:42:24 t 2016-03-17 09:19:04.94469
158 594 200 A101 A1 344683 2012-06-01 12:00:00+02 t 627 2012-06-12 11:46:00 t 2016-03-17 09:19:04.94469 158 594 3 200 A101 A1 344683 2012-06-01 12:00:00+02 t 627 2012-06-12 11:46:00 t 2016-03-17 09:19:04.94469
159 595 200 BS01 BS 1000 2012-07-10 12:40:00+02 t 628 2012-07-27 11:42:24 t 2016-03-17 09:19:04.94469 159 595 4 200 BS01 BS 1000 2012-07-10 12:40:00+02 t 628 2012-07-27 11:42:24 t 2016-03-17 09:19:04.94469
160 596 200 G101 G1 696089 2012-05-15 10:00:00+02 t 629 2012-06-12 11:46:00 t 2016-03-17 09:19:04.94469 160 596 2 200 G101 G1 696089 2012-05-15 10:00:00+02 t 629 2012-06-12 11:46:00 t 2016-03-17 09:19:04.94469
161 597 200 A102 A1 436113 2012-05-31 12:00:00+02 t 630 2012-06-12 11:46:00 f 2016-03-17 09:19:04.94469 161 597 5 200 A102 A1 436113 2012-05-31 12:00:00+02 t 630 2012-06-12 11:46:00 f 2016-03-17 09:19:04.94469
162 649 45 00G1 G1 60000 2012-01-26 14:26:00+01 t 631 2012-03-12 09:12:13 t 2016-03-17 09:19:04.94469 162 649 1 45 00G1 G1 60000 2012-01-26 14:26:00+01 t 631 2012-03-12 09:12:13 t 2016-03-17 09:19:04.94469
163 499 55 00G1 G1 60000 2012-02-01 13:54:00+01 t 632 2012-03-15 13:42:20 t 2016-03-17 09:19:04.94469 163 499 1 55 00G1 G1 60000 2012-02-01 13:54:00+01 t 632 2012-03-15 13:42:20 t 2016-03-17 09:19:04.94469
164 517 69 00G1 G1 60000 2012-03-13 14:19:00+01 t 633 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469 164 517 1 69 00G1 G1 60000 2012-03-13 14:19:00+01 t 633 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469
165 515 67 00G1 G1 60000 2012-03-13 14:17:00+01 t 634 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469 165 515 1 67 00G1 G1 60000 2012-03-13 14:17:00+01 t 634 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469
166 518 70 00G1 G1 60000 2012-03-14 14:41:00+01 t 635 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469 166 518 1 70 00G1 G1 60000 2012-03-14 14:41:00+01 t 635 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469
167 513 65 00G1 G1 60000 2012-03-13 14:24:00+01 t 636 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469 167 513 1 65 00G1 G1 60000 2012-03-13 14:24:00+01 t 636 2012-03-26 11:42:27 t 2016-03-17 09:19:04.94469
168 538 78 00G1 G1 60000 2012-04-04 14:01:00+02 t 637 2012-05-07 18:42:50 t 2016-03-17 09:19:04.94469 168 538 2 78 00G1 G1 60000 2012-04-04 14:01:00+02 t 637 2012-05-07 18:42:50 t 2016-03-17 09:19:04.94469
169 539 78 0003 BS 36000 2012-06-21 10:00:00+02 t 638 2012-07-12 17:42:35 t 2016-03-17 09:19:04.94469 169 539 1 78 0003 BS 36000 2012-06-21 10:00:00+02 t 638 2012-07-12 17:42:35 t 2016-03-17 09:19:04.94469
170 639 36 0003 BS 36000 2012-09-10 10:00:00+02 t 639 2013-02-22 11:42:23 t 2016-03-17 09:19:04.94469 170 639 2 36 0003 BS 36000 2012-09-10 10:00:00+02 t 639 2013-02-22 11:42:23 t 2016-03-17 09:19:04.94469
171 640 36 00G1 G1 60000 2012-05-02 13:44:00+02 t 640 2012-09-18 12:41:00 t 2016-03-17 09:19:04.94469 171 640 1 36 00G1 G1 60000 2012-05-02 13:44:00+02 t 640 2012-09-18 12:41:00 t 2016-03-17 09:19:04.94469
172 788 157 G101 G1 445822 2012-05-24 09:00:00+02 t 645 2012-06-07 18:42:19 t 2016-03-17 09:19:04.94469 172 788 1 157 G101 G1 445822 2012-05-24 09:00:00+02 t 645 2012-06-07 18:42:19 t 2016-03-17 09:19:04.94469
173 901 19 00G1 G1 60000 2012-06-14 14:03:00+02 t 641 2012-06-26 15:42:31 t 2016-03-17 09:19:04.94469 173 901 1 19 00G1 G1 60000 2012-06-14 14:03:00+02 t 641 2012-06-26 15:42:31 t 2016-03-17 09:19:04.94469
174 900 707 G101 G1 419333 2012-01-18 11:00:00+01 t 642 2012-01-24 19:42:23 f 2016-03-17 09:19:04.94469 174 900 1 707 G101 G1 419333 2012-01-18 11:00:00+01 t 642 2012-01-24 19:42:23 f 2016-03-17 09:19:04.94469
175 789 158 G101 G1 425991 2012-02-01 09:00:00+01 t 643 2012-02-16 19:42:18 t 2016-03-17 09:19:04.94469 175 789 1 158 G101 G1 425991 2012-02-01 09:00:00+01 t 643 2012-02-16 19:42:18 t 2016-03-17 09:19:04.94469
176 785 155 G101 G1 345463 2012-05-18 06:00:00+02 t 646 2012-06-05 17:42:20 t 2016-03-17 09:19:04.94469 176 785 1 155 G101 G1 345463 2012-05-18 06:00:00+02 t 646 2012-06-05 17:42:20 t 2016-03-17 09:19:04.94469
177 533 73 0001 G1 100000 2012-05-22 11:12:00+02 t 647 2012-05-30 12:42:35 t 2016-03-17 09:19:04.94469 177 533 1 73 0001 G1 100000 2012-05-22 11:12:00+02 t 647 2012-05-30 12:42:35 t 2016-03-17 09:19:04.94469
178 529 71 0004 BH 18000 2012-06-30 10:00:00+02 t 648 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469 178 529 1 71 0004 BH 18000 2012-06-30 10:00:00+02 t 648 2012-07-18 11:42:37 t 2016-03-17 09:19:04.94469
179 530 71 00G1 G1 60000 2012-05-31 13:32:00+02 t 649 2012-06-29 13:42:59 t 2016-03-17 09:19:04.94469 179 530 2 71 00G1 G1 60000 2012-05-31 13:32:00+02 t 649 2012-06-29 13:42:59 t 2016-03-17 09:19:04.94469
180 452 354 00G1 G1 60000 2012-01-12 14:22:00+01 t 650 2012-01-20 19:42:14 t 2016-03-17 09:19:04.94469 180 452 1 354 00G1 G1 60000 2012-01-12 14:22:00+01 t 650 2012-01-20 19:42:14 t 2016-03-17 09:19:04.94469
181 451 353 00G1 G1 60000 2012-01-18 15:20:00+01 t 651 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469 181 451 1 353 00G1 G1 60000 2012-01-18 15:20:00+01 t 651 2012-02-03 16:45:22 t 2016-03-17 09:19:04.94469
182 411 147 0001 G1 50000 2012-02-28 12:38:00+01 t 653 2012-03-06 17:42:26 t 2016-03-17 09:19:04.94469 182 411 1 147 0001 G1 50000 2012-02-28 12:38:00+01 t 653 2012-03-06 17:42:26 t 2016-03-17 09:19:04.94469
183 195 406 01G1 G1 85198 2012-06-11 13:06:00+02 t 654 2012-07-17 15:42:25 t 2016-03-17 09:19:04.94469 183 195 1 406 01G1 G1 85198 2012-06-11 13:06:00+02 t 654 2012-07-17 15:42:25 t 2016-03-17 09:19:04.94469
184 \. 184 \.
185 185
186 186
187 ALTER TABLE messung ENABLE TRIGGER ALL; 187 ALTER TABLE messung ENABLE TRIGGER ALL;
188 188
192 -- Data for Name: kommentar_m; Type: TABLE DATA; Schema: land; Owner: postgres 192 -- Data for Name: kommentar_m; Type: TABLE DATA; Schema: land; Owner: postgres
193 -- 193 --
194 194
195 ALTER TABLE kommentar_m DISABLE TRIGGER ALL; 195 ALTER TABLE kommentar_m DISABLE TRIGGER ALL;
196 196
197 COPY kommentar_m (id, erzeuger, datum, text, messungs_id) FROM stdin; 197 COPY kommentar_m (id, mst_id, datum, text, messungs_id) FROM stdin;
198 481 12020 2012-07-12 06:18:00 Messung FM\nFM/TM lt Stammdaten 195 198 481 12020 2012-07-12 06:18:00 Messung FM\nFM/TM lt Stammdaten 195
199 482 12020 2012-07-12 09:32:00 Messung FM\nFM/TM lt Stammdaten 195 199 482 12020 2012-07-12 09:32:00 Messung FM\nFM/TM lt Stammdaten 195
200 \. 200 \.
201 201
202 202
208 -- Data for Name: kommentar_p; Type: TABLE DATA; Schema: land; Owner: postgres 208 -- Data for Name: kommentar_p; Type: TABLE DATA; Schema: land; Owner: postgres
209 -- 209 --
210 210
211 ALTER TABLE kommentar_p DISABLE TRIGGER ALL; 211 ALTER TABLE kommentar_p DISABLE TRIGGER ALL;
212 212
213 COPY kommentar_p (id, erzeuger, datum, text, probe_id) FROM stdin; 213 COPY kommentar_p (id, mst_id, datum, text, probe_id) FROM stdin;
214 120 12020 2011-12-14 12:43:38 n_im04 660 214 120 12020 2011-12-14 12:43:38 n_im04 660
215 168 06010 2011-11-07 12:10:49 A76, A0-Horizont: Probenahmetiefe (Mächtigkeit der Humusschicht) notieren! 84 215 168 06010 2011-11-07 12:10:49 A76, A0-Horizont: Probenahmetiefe (Mächtigkeit der Humusschicht) notieren! 84
216 183 12020 2011-12-14 12:30:49 n_pf07 406 216 183 12020 2011-12-14 12:30:49 n_pf07 406
217 186 12010 2011-12-14 12:31:07 o_mi02 409 217 186 12010 2011-12-14 12:31:07 o_mi02 409
218 344 06010 2012-04-26 10:56:00 #125404438# 703 218 344 06010 2012-04-26 10:56:00 #125404438# 703
232 -- Data for Name: messprogramm; Type: TABLE DATA; Schema: land; Owner: postgres 232 -- Data for Name: messprogramm; Type: TABLE DATA; Schema: land; Owner: postgres
233 -- 233 --
234 234
235 ALTER TABLE messprogramm DISABLE TRIGGER ALL; 235 ALTER TABLE messprogramm DISABLE TRIGGER ALL;
236 236
237 COPY messprogramm (id, name, test, netzbetreiber_id, mst_id, labor_mst_id, datenbasis_id, ba_id, gem_id, ort_id, media_desk, umw_id, probenart_id, probenintervall, teilintervall_von, teilintervall_bis, intervall_offset, gueltig_von, gueltig_bis, probe_nehmer_id, probe_kommentar, letzte_aenderung) FROM stdin; 237 COPY messprogramm (id, test, mst_id, labor_mst_id, datenbasis_id, ba_id, gem_id, ort_id, media_desk, umw_id, probenart_id, probenintervall, teilintervall_von, teilintervall_bis, intervall_offset, gueltig_von, gueltig_bis, probe_nehmer_id, probe_kommentar, letzte_aenderung) FROM stdin;
238 \. 238 \.
239 239
240 240
241 ALTER TABLE messprogramm ENABLE TRIGGER ALL; 241 ALTER TABLE messprogramm ENABLE TRIGGER ALL;
242 242
268 -- Dependencies: 288 268 -- Dependencies: 288
269 -- Name: messprogramm_mmt_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres 269 -- Name: messprogramm_mmt_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
270 -- 270 --
271 271
272 SELECT pg_catalog.setval('messprogramm_mmt_id_seq', 1, false); 272 SELECT pg_catalog.setval('messprogramm_mmt_id_seq', 1, false);
273
274
275 --
276 -- TOC entry 4688 (class 0 OID 1170831)
277 -- Dependencies: 290
278 -- Data for Name: messung_translation; Type: TABLE DATA; Schema: land; Owner: postgres
279 --
280
281 ALTER TABLE messung_translation DISABLE TRIGGER ALL;
282
283 COPY messung_translation (id, messungs_id, messungs_id_alt) FROM stdin;
284 45 45 1
285 179 179 1
286 195 195 1
287 198 198 1
288 382 382 1
289 404 404 1
290 409 409 1
291 411 411 1
292 451 451 1
293 452 452 1
294 455 455 1
295 457 457 1
296 499 499 1
297 513 513 1
298 515 515 1
299 517 517 1
300 518 518 1
301 529 529 1
302 530 530 2
303 533 533 1
304 536 536 1
305 538 538 2
306 539 539 1
307 546 546 2
308 547 547 1
309 552 552 1
310 553 553 2
311 558 558 2
312 559 559 1
313 574 574 1
314 593 593 1
315 594 594 3
316 595 595 4
317 596 596 2
318 597 597 5
319 604 604 1
320 639 639 2
321 640 640 1
322 646 646 1
323 649 649 1
324 669 669 1
325 677 677 1
326 679 679 1
327 682 682 1
328 686 686 1
329 687 687 1
330 693 693 1
331 697 697 1
332 699 699 1
333 749 749 1
334 764 764 1
335 765 765 2
336 776 776 1
337 777 777 2
338 778 778 4
339 779 779 3
340 781 781 3
341 782 782 1
342 783 783 4
343 784 784 2
344 785 785 1
345 788 788 1
346 789 789 1
347 792 792 1
348 793 793 4
349 794 794 3
350 795 795 2
351 796 796 5
352 835 835 1
353 841 841 1
354 847 847 1
355 855 855 1
356 856 856 4
357 857 857 2
358 858 858 3
359 859 859 5
360 876 876 1
361 877 877 2
362 900 900 1
363 901 901 1
364 906 906 1
365 907 907 1
366 \.
367
368
369 ALTER TABLE messung_translation ENABLE TRIGGER ALL;
370
371 --
372 -- TOC entry 4703 (class 0 OID 0)
373 -- Dependencies: 291
374 -- Name: messung_translation_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
375 --
376
377 SELECT pg_catalog.setval('messung_translation_id_seq', 1009, true);
378
379 273
380 -- 274 --
381 -- TOC entry 4690 (class 0 OID 1170837) 275 -- TOC entry 4690 (class 0 OID 1170837)
382 -- Dependencies: 292 276 -- Dependencies: 292
383 -- Data for Name: messwert; Type: TABLE DATA; Schema: land; Owner: postgres 277 -- Data for Name: messwert; Type: TABLE DATA; Schema: land; Owner: postgres
996 890
997 891
998 ALTER TABLE ortszuordnung ENABLE TRIGGER ALL; 892 ALTER TABLE ortszuordnung ENABLE TRIGGER ALL;
999 893
1000 -- 894 --
1001 -- TOC entry 4693 (class 0 OID 1170889)
1002 -- Dependencies: 295
1003 -- Data for Name: probe_translation; Type: TABLE DATA; Schema: land; Owner: postgres
1004 --
1005
1006 ALTER TABLE probe_translation DISABLE TRIGGER ALL;
1007
1008 COPY probe_translation (id, probe_id, probe_id_alt) FROM stdin;
1009 1 1 000007581034X
1010 3 3 000007581040X
1011 4 4 000007587554X
1012 19 19 000007587671X
1013 24 24 000007587691X
1014 25 25 000007587696X
1015 31 31 000007578204X
1016 36 36 000007578214X
1017 42 42 000007578227X
1018 45 45 000007578239X
1019 55 55 000007578259X
1020 65 65 000007578279X
1021 67 67 000007578283X
1022 69 69 000007578287X
1023 70 70 000007578289X
1024 71 71 000007578291X
1025 73 73 000007578295X
1026 76 76 000007578301X
1027 78 78 000007578303X
1028 84 84 000007578312X
1029 88 88 000007578316X
1030 91 91 000007578319X
1031 97 97 000007578331X
1032 99 99 000007575726X
1033 112 112 000007575752X
1034 117 117 000007578031X
1035 140 140 000007578082X
1036 145 145 000007578087X
1037 147 147 000007578141X
1038 155 155 000007575767X
1039 157 157 000007575772X
1040 159 158 000007575778X
1041 161 160 000007575783X
1042 175 174 000007575807X
1043 181 180 000007575819X
1044 187 186 000007575831X
1045 195 194 000007575847X
1046 201 200 000007575856X
1047 204 203 000007575864X
1048 284 284 000007575917X
1049 292 292 000007575939X
1050 294 294 000007575941X
1051 296 296 000007575943X
1052 300 300 000007575949X
1053 301 301 000007575950X
1054 307 307 000007575960X
1055 311 311 000007575967X
1056 313 313 000007575969X
1057 353 353 000007578188X
1058 354 354 000007578191X
1059 357 357 000007578195X
1060 407 406 000007589328X
1061 410 409 000007589343X
1062 660 660 000007590041X
1063 703 703 000007590316X
1064 707 707 000007613597X
1065 \.
1066
1067
1068 ALTER TABLE probe_translation ENABLE TRIGGER ALL;
1069
1070 --
1071 -- TOC entry 4704 (class 0 OID 0)
1072 -- Dependencies: 296
1073 -- Name: probe_translation_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
1074 --
1075
1076 SELECT pg_catalog.setval('probe_translation_id_seq', 733, true);
1077
1078
1079 --
1080 -- TOC entry 4695 (class 0 OID 1170895) 895 -- TOC entry 4695 (class 0 OID 1170895)
1081 -- Dependencies: 297 896 -- Dependencies: 297
1082 -- Data for Name: status_protokoll; Type: TABLE DATA; Schema: land; Owner: postgres 897 -- Data for Name: status_protokoll; Type: TABLE DATA; Schema: land; Owner: postgres
1083 -- 898 --
1084 899
1085 ALTER TABLE status_protokoll DISABLE TRIGGER ALL; 900 ALTER TABLE status_protokoll DISABLE TRIGGER ALL;
1086 901
1087 COPY status_protokoll (id, erzeuger, datum, text, messungs_id, status_stufe, status_wert, tree_modified) FROM stdin; 902 COPY status_protokoll (id, mst_id, datum, text, messungs_id, status_kombi, tree_modified) FROM stdin;
1088 571 12020 2016-02-29 21:53:01.736444 Test 179 1 0 2016-03-17 09:19:04.94469 903 571 12020 2016-02-29 21:53:01.736444 Test 179 1 2016-03-17 09:19:04.94469
1089 572 12010 2016-02-29 21:53:01.736444 Test 198 1 0 2016-03-17 09:19:04.94469 904 572 12010 2016-02-29 21:53:01.736444 Test 198 1 2016-03-17 09:19:04.94469
1090 573 06010 2016-02-29 21:53:01.736444 Test 646 1 0 2016-03-17 09:19:04.94469 905 573 06010 2016-02-29 21:53:01.736444 Test 646 1 2016-03-17 09:19:04.94469
1091 574 11010 2016-02-29 21:53:01.736444 Test 699 1 0 2016-03-17 09:19:04.94469 906 574 11010 2016-02-29 21:53:01.736444 Test 699 1 2016-03-17 09:19:04.94469
1092 575 11010 2016-02-29 21:53:01.736444 Test 697 1 0 2016-03-17 09:19:04.94469 907 575 11010 2016-02-29 21:53:01.736444 Test 697 1 2016-03-17 09:19:04.94469
1093 579 11010 2016-02-29 21:53:01.736444 Test 765 1 0 2016-03-17 09:19:04.94469 908 579 11010 2016-02-29 21:53:01.736444 Test 765 1 2016-03-17 09:19:04.94469
1094 578 11010 2016-02-29 21:53:01.736444 Test 764 1 0 2016-03-17 09:19:04.94469 909 578 11010 2016-02-29 21:53:01.736444 Test 764 1 2016-03-17 09:19:04.94469
1095 576 06060 2016-02-29 21:53:01.736444 Test 876 1 0 2016-03-17 09:19:04.94469 910 576 06060 2016-02-29 21:53:01.736444 Test 876 1 2016-03-17 09:19:04.94469
1096 577 06060 2016-02-29 21:53:01.736444 Test 877 1 0 2016-03-17 09:19:04.94469 911 577 06060 2016-02-29 21:53:01.736444 Test 877 1 2016-03-17 09:19:04.94469
1097 580 11010 2016-02-29 21:53:01.736444 Test 693 1 0 2016-03-17 09:19:04.94469 912 580 11010 2016-02-29 21:53:01.736444 Test 693 1 2016-03-17 09:19:04.94469
1098 581 11010 2016-02-29 21:53:01.736444 Test 604 1 0 2016-03-17 09:19:04.94469 913 581 11010 2016-02-29 21:53:01.736444 Test 604 1 2016-03-17 09:19:04.94469
1099 582 06010 2016-02-29 21:53:01.736444 Test 455 1 0 2016-03-17 09:19:04.94469 914 582 06010 2016-02-29 21:53:01.736444 Test 455 1 2016-03-17 09:19:04.94469
1100 583 11010 2016-02-29 21:53:01.736444 Test 677 1 0 2016-03-17 09:19:04.94469 915 583 11010 2016-02-29 21:53:01.736444 Test 677 1 2016-03-17 09:19:04.94469
1101 584 11010 2016-02-29 21:53:01.736444 Test 679 1 0 2016-03-17 09:19:04.94469 916 584 11010 2016-02-29 21:53:01.736444 Test 679 1 2016-03-17 09:19:04.94469
1102 585 06010 2016-02-29 21:53:01.736444 Test 907 1 0 2016-03-17 09:19:04.94469 917 585 06010 2016-02-29 21:53:01.736444 Test 907 1 2016-03-17 09:19:04.94469
1103 586 06010 2016-02-29 21:53:01.736444 Test 409 1 0 2016-03-17 09:19:04.94469 918 586 06010 2016-02-29 21:53:01.736444 Test 409 1 2016-03-17 09:19:04.94469
1104 587 06010 2016-02-29 21:53:01.736444 Test 45 1 0 2016-03-17 09:19:04.94469 919 587 06010 2016-02-29 21:53:01.736444 Test 45 1 2016-03-17 09:19:04.94469
1105 588 06010 2016-02-29 21:53:01.736444 Test 404 1 0 2016-03-17 09:19:04.94469 920 588 06010 2016-02-29 21:53:01.736444 Test 404 1 2016-03-17 09:19:04.94469
1106 589 11010 2016-02-29 21:53:01.736444 Test 669 1 0 2016-03-17 09:19:04.94469 921 589 11010 2016-02-29 21:53:01.736444 Test 669 1 2016-03-17 09:19:04.94469
1107 590 06010 2016-02-29 21:53:01.736444 Test 382 1 0 2016-03-17 09:19:04.94469 922 590 06010 2016-02-29 21:53:01.736444 Test 382 1 2016-03-17 09:19:04.94469
1108 591 11010 2016-02-29 21:53:01.736444 Test 687 1 0 2016-03-17 09:19:04.94469 923 591 11010 2016-02-29 21:53:01.736444 Test 687 1 2016-03-17 09:19:04.94469
1109 592 11010 2016-02-29 21:53:01.736444 Test 686 1 0 2016-03-17 09:19:04.94469 924 592 11010 2016-02-29 21:53:01.736444 Test 686 1 2016-03-17 09:19:04.94469
1110 593 06010 2016-02-29 21:53:01.736444 Test 906 1 0 2016-03-17 09:19:04.94469 925 593 06010 2016-02-29 21:53:01.736444 Test 906 1 2016-03-17 09:19:04.94469
1111 594 11010 2016-02-29 21:53:01.736444 Test 682 1 0 2016-03-17 09:19:04.94469 926 594 11010 2016-02-29 21:53:01.736444 Test 682 1 2016-03-17 09:19:04.94469
1112 595 11010 2016-02-29 21:53:01.736444 Test 749 1 0 2016-03-17 09:19:04.94469 927 595 11010 2016-02-29 21:53:01.736444 Test 749 1 2016-03-17 09:19:04.94469
1113 596 11010 2016-02-29 21:53:01.736444 Test 855 1 0 2016-03-17 09:19:04.94469 928 596 11010 2016-02-29 21:53:01.736444 Test 855 1 2016-03-17 09:19:04.94469
1114 597 11010 2016-02-29 21:53:01.736444 Test 856 1 0 2016-03-17 09:19:04.94469 929 597 11010 2016-02-29 21:53:01.736444 Test 856 1 2016-03-17 09:19:04.94469
1115 598 11010 2016-02-29 21:53:01.736444 Test 857 1 0 2016-03-17 09:19:04.94469 930 598 11010 2016-02-29 21:53:01.736444 Test 857 1 2016-03-17 09:19:04.94469
1116 599 11010 2016-02-29 21:53:01.736444 Test 858 1 0 2016-03-17 09:19:04.94469 931 599 11010 2016-02-29 21:53:01.736444 Test 858 1 2016-03-17 09:19:04.94469
1117 600 11010 2016-02-29 21:53:01.736444 Test 859 1 0 2016-03-17 09:19:04.94469 932 600 11010 2016-02-29 21:53:01.736444 Test 859 1 2016-03-17 09:19:04.94469
1118 601 06010 2016-02-29 21:53:01.736444 Test 781 1 0 2016-03-17 09:19:04.94469 933 601 06010 2016-02-29 21:53:01.736444 Test 781 1 2016-03-17 09:19:04.94469
1119 602 06010 2016-02-29 21:53:01.736444 Test 782 1 0 2016-03-17 09:19:04.94469 934 602 06010 2016-02-29 21:53:01.736444 Test 782 1 2016-03-17 09:19:04.94469
1120 603 06010 2016-02-29 21:53:01.736444 Test 783 1 0 2016-03-17 09:19:04.94469 935 603 06010 2016-02-29 21:53:01.736444 Test 783 1 2016-03-17 09:19:04.94469
1121 604 06010 2016-02-29 21:53:01.736444 Test 784 1 0 2016-03-17 09:19:04.94469 936 604 06010 2016-02-29 21:53:01.736444 Test 784 1 2016-03-17 09:19:04.94469
1122 605 06010 2016-02-29 21:53:01.736444 Test 776 1 0 2016-03-17 09:19:04.94469 937 605 06010 2016-02-29 21:53:01.736444 Test 776 1 2016-03-17 09:19:04.94469
1123 606 06010 2016-02-29 21:53:01.736444 Test 777 1 0 2016-03-17 09:19:04.94469 938 606 06010 2016-02-29 21:53:01.736444 Test 777 1 2016-03-17 09:19:04.94469
1124 607 06010 2016-02-29 21:53:01.736444 Test 778 1 0 2016-03-17 09:19:04.94469 939 607 06010 2016-02-29 21:53:01.736444 Test 778 1 2016-03-17 09:19:04.94469
1125 608 06010 2016-02-29 21:53:01.736444 Test 779 1 0 2016-03-17 09:19:04.94469 940 608 06010 2016-02-29 21:53:01.736444 Test 779 1 2016-03-17 09:19:04.94469
1126 609 06010 2016-02-29 21:53:01.736444 Test 457 1 0 2016-03-17 09:19:04.94469 941 609 06010 2016-02-29 21:53:01.736444 Test 457 1 2016-03-17 09:19:04.94469
1127 610 06010 2016-02-29 21:53:01.736444 Test 546 1 0 2016-03-17 09:19:04.94469 942 610 06010 2016-02-29 21:53:01.736444 Test 546 1 2016-03-17 09:19:04.94469
1128 611 06010 2016-02-29 21:53:01.736444 Test 547 1 0 2016-03-17 09:19:04.94469 943 611 06010 2016-02-29 21:53:01.736444 Test 547 1 2016-03-17 09:19:04.94469
1129 612 06010 2016-02-29 21:53:01.736444 Test 536 1 0 2016-03-17 09:19:04.94469 944 612 06010 2016-02-29 21:53:01.736444 Test 536 1 2016-03-17 09:19:04.94469
1130 613 06010 2016-02-29 21:53:01.736444 Test 552 1 0 2016-03-17 09:19:04.94469 945 613 06010 2016-02-29 21:53:01.736444 Test 552 1 2016-03-17 09:19:04.94469
1131 614 06010 2016-02-29 21:53:01.736444 Test 553 1 0 2016-03-17 09:19:04.94469 946 614 06010 2016-02-29 21:53:01.736444 Test 553 1 2016-03-17 09:19:04.94469
1132 615 11010 2016-02-29 21:53:01.736444 Test 841 1 0 2016-03-17 09:19:04.94469 947 615 11010 2016-02-29 21:53:01.736444 Test 841 1 2016-03-17 09:19:04.94469
1133 616 06010 2016-02-29 21:53:01.736444 Test 574 1 0 2016-03-17 09:19:04.94469 948 616 06010 2016-02-29 21:53:01.736444 Test 574 1 2016-03-17 09:19:04.94469
1134 617 06060 2016-02-29 21:53:01.736444 Test 558 1 0 2016-03-17 09:19:04.94469 949 617 06060 2016-02-29 21:53:01.736444 Test 558 1 2016-03-17 09:19:04.94469
1135 618 06060 2016-02-29 21:53:01.736444 Test 559 1 0 2016-03-17 09:19:04.94469 950 618 06060 2016-02-29 21:53:01.736444 Test 559 1 2016-03-17 09:19:04.94469
1136 619 11010 2016-02-29 21:53:01.736444 Test 847 1 0 2016-03-17 09:19:04.94469 951 619 11010 2016-02-29 21:53:01.736444 Test 847 1 2016-03-17 09:19:04.94469
1137 620 11010 2016-02-29 21:53:01.736444 Test 835 1 0 2016-03-17 09:19:04.94469 952 620 11010 2016-02-29 21:53:01.736444 Test 835 1 2016-03-17 09:19:04.94469
1138 621 11010 2016-02-29 21:53:01.736444 Test 792 1 0 2016-03-17 09:19:04.94469 953 621 11010 2016-02-29 21:53:01.736444 Test 792 1 2016-03-17 09:19:04.94469
1139 622 11010 2016-02-29 21:53:01.736444 Test 793 1 0 2016-03-17 09:19:04.94469 954 622 11010 2016-02-29 21:53:01.736444 Test 793 1 2016-03-17 09:19:04.94469
1140 623 11010 2016-02-29 21:53:01.736444 Test 794 1 0 2016-03-17 09:19:04.94469 955 623 11010 2016-02-29 21:53:01.736444 Test 794 1 2016-03-17 09:19:04.94469
1141 624 11010 2016-02-29 21:53:01.736444 Test 795 1 0 2016-03-17 09:19:04.94469 956 624 11010 2016-02-29 21:53:01.736444 Test 795 1 2016-03-17 09:19:04.94469
1142 625 11010 2016-02-29 21:53:01.736444 Test 796 1 0 2016-03-17 09:19:04.94469 957 625 11010 2016-02-29 21:53:01.736444 Test 796 1 2016-03-17 09:19:04.94469
1143 626 11010 2016-02-29 21:53:01.736444 Test 593 1 0 2016-03-17 09:19:04.94469 958 626 11010 2016-02-29 21:53:01.736444 Test 593 1 2016-03-17 09:19:04.94469
1144 627 11010 2016-02-29 21:53:01.736444 Test 594 1 0 2016-03-17 09:19:04.94469 959 627 11010 2016-02-29 21:53:01.736444 Test 594 1 2016-03-17 09:19:04.94469
1145 628 11010 2016-02-29 21:53:01.736444 Test 595 1 0 2016-03-17 09:19:04.94469 960 628 11010 2016-02-29 21:53:01.736444 Test 595 1 2016-03-17 09:19:04.94469
1146 629 11010 2016-02-29 21:53:01.736444 Test 596 1 0 2016-03-17 09:19:04.94469 961 629 11010 2016-02-29 21:53:01.736444 Test 596 1 2016-03-17 09:19:04.94469
1147 630 11010 2016-02-29 21:53:01.736444 Test 597 1 0 2016-03-17 09:19:04.94469 962 630 11010 2016-02-29 21:53:01.736444 Test 597 1 2016-03-17 09:19:04.94469
1148 631 06010 2016-02-29 21:53:01.736444 Test 649 1 0 2016-03-17 09:19:04.94469 963 631 06010 2016-02-29 21:53:01.736444 Test 649 1 2016-03-17 09:19:04.94469
1149 632 06010 2016-02-29 21:53:01.736444 Test 499 1 0 2016-03-17 09:19:04.94469 964 632 06010 2016-02-29 21:53:01.736444 Test 499 1 2016-03-17 09:19:04.94469
1150 633 06010 2016-02-29 21:53:01.736444 Test 517 1 0 2016-03-17 09:19:04.94469 965 633 06010 2016-02-29 21:53:01.736444 Test 517 1 2016-03-17 09:19:04.94469
1151 634 06010 2016-02-29 21:53:01.736444 Test 515 1 0 2016-03-17 09:19:04.94469 966 634 06010 2016-02-29 21:53:01.736444 Test 515 1 2016-03-17 09:19:04.94469
1152 635 06010 2016-02-29 21:53:01.736444 Test 518 1 0 2016-03-17 09:19:04.94469 967 635 06010 2016-02-29 21:53:01.736444 Test 518 1 2016-03-17 09:19:04.94469
1153 636 06010 2016-02-29 21:53:01.736444 Test 513 1 0 2016-03-17 09:19:04.94469 968 636 06010 2016-02-29 21:53:01.736444 Test 513 1 2016-03-17 09:19:04.94469
1154 637 06010 2016-02-29 21:53:01.736444 Test 538 1 0 2016-03-17 09:19:04.94469 969 637 06010 2016-02-29 21:53:01.736444 Test 538 1 2016-03-17 09:19:04.94469
1155 638 06010 2016-02-29 21:53:01.736444 Test 539 1 0 2016-03-17 09:19:04.94469 970 638 06010 2016-02-29 21:53:01.736444 Test 539 1 2016-03-17 09:19:04.94469
1156 639 06010 2016-02-29 21:53:01.736444 Test 639 1 0 2016-03-17 09:19:04.94469 971 639 06010 2016-02-29 21:53:01.736444 Test 639 1 2016-03-17 09:19:04.94469
1157 640 06010 2016-02-29 21:53:01.736444 Test 640 1 0 2016-03-17 09:19:04.94469 972 640 06010 2016-02-29 21:53:01.736444 Test 640 1 2016-03-17 09:19:04.94469
1158 645 11010 2016-02-29 21:53:01.736444 Test 788 1 0 2016-03-17 09:19:04.94469 973 645 11010 2016-02-29 21:53:01.736444 Test 788 1 2016-03-17 09:19:04.94469
1159 641 06010 2016-02-29 21:53:01.736444 Test 901 1 0 2016-03-17 09:19:04.94469 974 641 06010 2016-02-29 21:53:01.736444 Test 901 1 2016-03-17 09:19:04.94469
1160 642 11010 2016-02-29 21:53:01.736444 Test 900 1 0 2016-03-17 09:19:04.94469 975 642 11010 2016-02-29 21:53:01.736444 Test 900 1 2016-03-17 09:19:04.94469
1161 643 11010 2016-02-29 21:53:01.736444 Test 789 1 0 2016-03-17 09:19:04.94469 976 643 11010 2016-02-29 21:53:01.736444 Test 789 1 2016-03-17 09:19:04.94469
1162 646 11010 2016-02-29 21:53:01.736444 Test 785 1 0 2016-03-17 09:19:04.94469 977 646 11010 2016-02-29 21:53:01.736444 Test 785 1 2016-03-17 09:19:04.94469
1163 647 06060 2016-02-29 21:53:01.736444 Test 533 1 0 2016-03-17 09:19:04.94469 978 647 06060 2016-02-29 21:53:01.736444 Test 533 1 2016-03-17 09:19:04.94469
1164 648 06010 2016-02-29 21:53:01.736444 Test 529 1 0 2016-03-17 09:19:04.94469 979 648 06010 2016-02-29 21:53:01.736444 Test 529 1 2016-03-17 09:19:04.94469
1165 649 06010 2016-02-29 21:53:01.736444 Test 530 1 0 2016-03-17 09:19:04.94469 980 649 06010 2016-02-29 21:53:01.736444 Test 530 1 2016-03-17 09:19:04.94469
1166 650 06010 2016-02-29 21:53:01.736444 Test 452 1 0 2016-03-17 09:19:04.94469 981 650 06010 2016-02-29 21:53:01.736444 Test 452 1 2016-03-17 09:19:04.94469
1167 651 06010 2016-02-29 21:53:01.736444 Test 451 1 0 2016-03-17 09:19:04.94469 982 651 06010 2016-02-29 21:53:01.736444 Test 451 1 2016-03-17 09:19:04.94469
1168 653 06060 2016-02-29 21:53:01.736444 Test 411 1 0 2016-03-17 09:19:04.94469 983 653 06060 2016-02-29 21:53:01.736444 Test 411 1 2016-03-17 09:19:04.94469
1169 654 12020 2016-02-29 21:53:01.736444 Test 195 1 0 2016-03-17 09:19:04.94469 984 654 12020 2016-02-29 21:53:01.736444 Test 195 1 2016-03-17 09:19:04.94469
1170 \. 985 \.
1171 986
1172 987
1173 ALTER TABLE status_protokoll ENABLE TRIGGER ALL; 988 ALTER TABLE status_protokoll ENABLE TRIGGER ALL;
1174 989
1187 \. 1002 \.
1188 1003
1189 1004
1190 ALTER TABLE zusatz_wert ENABLE TRIGGER ALL; 1005 ALTER TABLE zusatz_wert ENABLE TRIGGER ALL;
1191 1006
1192 SET search_path = bund, pg_catalog;
1193
1194 SELECT pg_catalog.setval('kommentar_id_seq', 661, true);
1195
1196 SELECT pg_catalog.setval('messung_id_seq', 1009, true);
1197
1198 SELECT pg_catalog.setval('messwert_id_seq', 6471, true);
1199
1200 SELECT pg_catalog.setval('ort_id_seq', 921, true);
1201
1202 SELECT pg_catalog.setval('probe_id_seq', 734, true);
1203
1204 SELECT pg_catalog.setval('zusatz_wert_id_seq', 30, true);
1205
1206 -- 1007 --
1207 -- PostgreSQL database dump complete 1008 -- PostgreSQL database dump complete
1208 -- 1009 --
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)