view db_schema/lada_data.sql @ 1151:7a9bc3fe0efd

Moved probe validation to have all subobject available during validation.
author Raimund Renkert <raimund.renkert@intevation.de>
date Mon, 07 Nov 2016 12:30:35 +0100
parents d1d7d684800c
children 4ee336c65ab3
line wrap: on
line source
\set ON_ERROR_STOP on

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.2
-- Dumped by pg_dump version 9.5.2

-- Started on 2016-05-04 09:10:49 CEST

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = land, pg_catalog;

--
-- TOC entry 4692 (class 0 OID 1170850)
-- Dependencies: 294
-- Data for Name: probe; Type: TABLE DATA; Schema: land; Owner: postgres
--

SET SESSION AUTHORIZATION DEFAULT;

ALTER TABLE probe DISABLE TRIGGER ALL;

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;
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
409	000007589343X	f	12010	12010	A0239MP12	2	1	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
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
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
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
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
117	000007578031X	f	06060	06060	1420	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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
73	000007578295X	f	06060	06060	1436	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
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
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
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
147	000007578141X	f	06060	06060	1424	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
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
\.


ALTER TABLE probe ENABLE TRIGGER ALL;

SELECT setval(pg_get_serial_sequence('probe', 'id'),
    (SELECT max(id) FROM probe));


--
-- TOC entry 4687 (class 0 OID 1170823)
-- Dependencies: 289
-- Data for Name: messung; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE messung DISABLE TRIGGER ALL;

COPY messung (id, id_alt, probe_id, nebenproben_nr, mmt_id, messdauer, messzeitpunkt, fertig, status, letzte_aenderung, geplant, tree_modified) FROM stdin;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
\.


ALTER TABLE messung ENABLE TRIGGER ALL;

SELECT setval(pg_get_serial_sequence('messung', 'id'),
    (SELECT max(id) FROM messung));


--
-- TOC entry 4681 (class 0 OID 1170751)
-- Dependencies: 283
-- Data for Name: kommentar_m; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE kommentar_m DISABLE TRIGGER ALL;

COPY kommentar_m (id, mst_id, datum, text, messungs_id) FROM stdin;
481	12020	2012-07-12 06:18:00	Messung FM\nFM/TM lt Stammdaten	195
482	12020	2012-07-12 09:32:00	Messung FM\nFM/TM lt Stammdaten	195
\.


ALTER TABLE kommentar_m ENABLE TRIGGER ALL;

SELECT setval(pg_get_serial_sequence('kommentar_m', 'id'),
    (SELECT max(id) FROM kommentar_m));


--
-- TOC entry 4682 (class 0 OID 1170759)
-- Dependencies: 284
-- Data for Name: kommentar_p; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE kommentar_p DISABLE TRIGGER ALL;

COPY kommentar_p (id, mst_id, datum, text, probe_id) FROM stdin;
120	12020	2011-12-14 12:43:38	n_im04	660
168	06010	2011-11-07 12:10:49	A76, A0-Horizont: Probenahmetiefe (Mächtigkeit der Humusschicht) notieren!	84
183	12020	2011-12-14 12:30:49	n_pf07	406
186	12010	2011-12-14 12:31:07	o_mi02	409
344	06010	2012-04-26 10:56:00	#125404438#	703
373	12020	2012-02-22 11:38:00	MHD 25.05.12                  /	660
379	06010	2012-01-18 11:44:00	Wolfsbarschfilet	354
413	11010	2012-06-18 06:52:49	Rehkeule	311
444	12020	2012-07-12 06:18:00	FM/TM lt. Stammdaten          /für Grüngetreide	406
455	12020	2012-07-12 09:32:00	FM/TM lt. Stammdaten          /für Grüngetreide	406
\.


ALTER TABLE kommentar_p ENABLE TRIGGER ALL;

SELECT setval(pg_get_serial_sequence('kommentar_p', 'id'),
    (SELECT max(id) FROM kommentar_p));


--
-- TOC entry 4684 (class 0 OID 1170769)
-- Dependencies: 286
-- Data for Name: messprogramm; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE messprogramm DISABLE TRIGGER ALL;

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;
\.


ALTER TABLE messprogramm ENABLE TRIGGER ALL;

--
-- TOC entry 4701 (class 0 OID 0)
-- Dependencies: 285
-- Name: messprogramm_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
--

SELECT pg_catalog.setval('messprogramm_id_seq', 1, false);


--
-- TOC entry 4685 (class 0 OID 1170813)
-- Dependencies: 287
-- Data for Name: messprogramm_mmt; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE messprogramm_mmt DISABLE TRIGGER ALL;

COPY messprogramm_mmt (id, messprogramm_id, mmt_id, messgroessen, letzte_aenderung) FROM stdin;
\.


ALTER TABLE messprogramm_mmt ENABLE TRIGGER ALL;

--
-- TOC entry 4702 (class 0 OID 0)
-- Dependencies: 288
-- Name: messprogramm_mmt_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
--

SELECT pg_catalog.setval('messprogramm_mmt_id_seq', 1, false);

--
-- TOC entry 4690 (class 0 OID 1170837)
-- Dependencies: 292
-- Data for Name: messwert; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE messwert DISABLE TRIGGER ALL;

COPY messwert (id, messungs_id, messgroesse_id, messwert_nwg, messwert, messfehler, nwg_zu_messwert, meh_id, grenzwertueberschreitung, letzte_aenderung, tree_modified) FROM stdin;
6076	179	28	\N	19	4.5	\N	67	\N	2012-02-22 12:38:39	2016-03-17 09:19:04.94469
6077	179	68	<	0.127000004	\N	\N	67	\N	2012-02-22 12:38:39	2016-03-17 09:19:04.94469
6078	179	220	<	0.0975999981000000016	\N	\N	67	\N	2012-02-22 12:38:39	2016-03-17 09:19:04.94469
6079	179	340	<	0.122000000999999997	\N	\N	67	\N	2012-02-22 12:38:39	2016-03-17 09:19:04.94469
6080	179	369	<	0.101999997999999995	\N	\N	67	\N	2012-02-22 12:38:39	2016-03-17 09:19:04.94469
6081	179	373	<	0.0992999970999999954	\N	\N	67	\N	2012-02-22 12:38:39	2016-03-17 09:19:04.94469
6082	179	404	<	0.510999977999999966	\N	\N	67	\N	2012-02-22 12:38:39	2016-03-17 09:19:04.94469
3820	198	28	\N	500	2.5	\N	64	\N	2012-03-26 16:31:35	2016-03-17 09:19:04.94469
3821	198	68	<	0.148000001999999992	\N	\N	64	\N	2012-03-26 16:31:35	2016-03-17 09:19:04.94469
3822	198	220	<	0.112999998000000004	\N	\N	64	\N	2012-03-26 16:31:35	2016-03-17 09:19:04.94469
3823	198	340	<	0.17499999699999999	\N	\N	64	\N	2012-03-26 16:31:35	2016-03-17 09:19:04.94469
3824	198	369	<	0.153999998999999999	\N	\N	64	\N	2012-03-26 16:31:35	2016-03-17 09:19:04.94469
3825	198	373	\N	1.7000000500000001	3.20000005	\N	64	\N	2012-03-26 16:31:35	2016-03-17 09:19:04.94469
3826	198	404	<	0.695999979999999963	\N	\N	64	\N	2012-03-26 16:31:35	2016-03-17 09:19:04.94469
2316	646	28	\N	30.7450007999999997	4.80000019	\N	67	\N	2012-01-11 14:12:49	2016-03-17 09:19:04.94469
2317	646	68	<	0.0790000035999999933	\N	\N	67	\N	2012-01-11 14:12:49	2016-03-17 09:19:04.94469
2318	646	220	<	0.0719999969000000017	\N	\N	67	\N	2012-01-11 14:12:49	2016-03-17 09:19:04.94469
2319	646	340	<	0.119000002999999993	\N	\N	67	\N	2012-01-11 14:12:49	2016-03-17 09:19:04.94469
2320	646	369	<	0.0659999995999999978	\N	\N	67	\N	2012-01-11 14:12:49	2016-03-17 09:19:04.94469
2321	646	373	<	0.0810000002000000052	\N	\N	67	\N	2012-01-11 14:12:49	2016-03-17 09:19:04.94469
2322	646	404	<	0.476000011000000001	\N	\N	67	\N	2012-01-11 14:12:49	2016-03-17 09:19:04.94469
1527	699	28	\N	101.207549999999998	1.60000002	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1528	699	68	<	0.168830320000000006	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1529	699	220	<	0.142792404000000012	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1530	699	222	<	1.37202632000000002	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1531	699	325	<	0.155931934999999994	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1532	699	340	<	0.152073264000000014	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1533	699	369	<	0.148148373	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1534	699	373	<	0.132176249999999995	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1535	699	404	<	0.801997662	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1509	697	28	\N	100.402801999999994	1.70000005	\N	67	\N	2012-06-18 08:47:25	2016-03-17 09:19:04.94469
1510	697	68	<	0.20000000300000001	\N	\N	67	\N	2012-06-18 08:47:25	2016-03-17 09:19:04.94469
1511	697	220	<	0.281809091999999983	\N	\N	67	\N	2012-06-18 08:47:25	2016-03-17 09:19:04.94469
1512	697	222	<	1.97511685000000003	\N	\N	67	\N	2012-06-18 08:47:25	2016-03-17 09:19:04.94469
1513	697	325	<	1.44841324999999999	\N	\N	67	\N	2012-06-18 08:47:25	2016-03-17 09:19:04.94469
1514	697	340	<	0.52557063100000001	\N	\N	67	\N	2012-06-18 08:47:25	2016-03-17 09:19:04.94469
1515	697	369	<	0.20000000300000001	\N	\N	67	\N	2012-06-18 08:47:25	2016-03-17 09:19:04.94469
1516	697	373	\N	40.8204345999999987	0.800000012	\N	67	\N	2012-06-18 08:47:25	2016-03-17 09:19:04.94469
1517	697	404	<	1.15046942000000008	\N	\N	67	\N	2012-06-18 08:47:25	2016-03-17 09:19:04.94469
129	765	165	\N	0.00960000046000000079	12.3999996	0.00520000000999999972	63	\N	2012-02-22 10:33:00	2016-03-17 09:19:04.94469
120	764	28	\N	47.4342995000000016	1.5	\N	63	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
121	764	68	<	0.0557887069999999999	\N	\N	63	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
122	764	220	<	0.0449622943999999983	\N	\N	63	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
123	764	222	<	0.425907433000000002	\N	\N	63	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
124	764	325	<	0.117578633000000002	\N	\N	63	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
125	764	340	<	0.0650383159999999988	\N	\N	63	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
126	764	369	<	0.0435773730000000026	\N	\N	63	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
127	764	373	\N	0.174444674999999993	9.5	\N	63	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
128	764	404	<	0.152959078999999998	\N	\N	63	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
1824	876	28	\N	47.2689018000000019	4.5	\N	63	\N	2012-01-27 17:04:47	2016-03-17 09:19:04.94469
1825	876	68	<	0.0670299976999999964	\N	\N	63	\N	2012-01-27 17:04:47	2016-03-17 09:19:04.94469
1826	876	220	<	0.0517399981999999981	\N	\N	63	\N	2012-01-27 17:04:47	2016-03-17 09:19:04.94469
1827	876	340	<	0.0600100011000000017	\N	\N	63	\N	2012-01-27 17:04:47	2016-03-17 09:19:04.94469
1828	876	369	<	0.0515800007000000033	\N	\N	63	\N	2012-01-27 17:04:47	2016-03-17 09:19:04.94469
1829	876	373	<	0.0615600011999999988	\N	\N	63	\N	2012-01-27 17:04:47	2016-03-17 09:19:04.94469
1830	876	404	<	0.430500001000000021	\N	\N	63	\N	2012-01-27 17:04:47	2016-03-17 09:19:04.94469
6461	877	164	\N	0.00999999977999999935	10	0	63	f	2016-03-07 15:46:01	2016-03-17 09:19:04.94469
1831	877	165	\N	0.0189999993999999985	23.3999996	\N	63	\N	2012-05-23 19:05:54	2016-03-17 09:19:04.94469
1473	693	28	\N	115.055701999999997	1.10000002	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1474	693	68	<	0.119670942000000002	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1475	693	220	<	0.0891667976999999945	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1476	693	222	<	0.860624194000000009	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1477	693	325	<	0.0925810113999999962	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1478	693	340	<	0.0928947553000000065	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1479	693	369	<	0.0887934268000000054	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1480	693	373	\N	0.103807717999999993	26.2999992	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
1481	693	404	<	0.464386255000000026	\N	\N	67	\N	2012-03-01 13:35:02	2016-03-17 09:19:04.94469
849	604	28	\N	93.2788314999999955	1.39999998	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
850	604	68	<	0.142586127000000007	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
851	604	220	<	0.147827238	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
852	604	222	<	1.32585192000000007	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
853	604	325	<	0.302643239000000008	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
854	604	340	<	0.190747038000000008	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
855	604	369	<	0.143185913999999997	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
856	604	373	\N	0.592932700999999951	7.9000001	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
857	604	404	<	0.953275800000000006	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
2224	455	28	\N	62.3479996000000014	4.5	\N	67	\N	2012-01-18 12:43:58	2016-03-17 09:19:04.94469
2225	455	68	<	0.0970000029000000069	\N	\N	67	\N	2012-01-18 12:43:58	2016-03-17 09:19:04.94469
2226	455	220	<	0.0810000002000000052	\N	\N	67	\N	2012-01-18 12:43:58	2016-03-17 09:19:04.94469
2227	455	340	<	0.0970000029000000069	\N	\N	67	\N	2012-01-18 12:43:58	2016-03-17 09:19:04.94469
2228	455	369	<	0.0810000002000000052	\N	\N	67	\N	2012-01-18 12:43:58	2016-03-17 09:19:04.94469
2229	455	373	<	0.105999998999999998	\N	\N	67	\N	2012-01-18 12:43:58	2016-03-17 09:19:04.94469
2230	455	404	<	0.621999979000000036	\N	\N	67	\N	2012-01-18 12:43:58	2016-03-17 09:19:04.94469
1337	677	28	\N	124.807793000000004	1	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1338	677	68	<	0.111939617000000005	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1339	677	220	<	0.084865637100000002	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1340	677	222	<	0.862398803000000047	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1341	677	325	<	0.0836788341000000019	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1342	677	340	<	0.0859226956999999958	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1343	677	369	<	0.0963074416000000016	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1344	677	373	<	0.10387747	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1345	677	404	<	0.341507881999999985	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1355	679	28	\N	23.5515900000000009	4.5999999	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1356	679	68	<	0.161153003999999989	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1357	679	220	<	0.141316800999999992	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1358	679	222	<	1.34632719000000001	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1359	679	325	<	0.161958024000000006	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1360	679	340	<	0.150202721000000011	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1361	679	369	<	0.145732105000000001	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1362	679	373	<	0.141465157000000008	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1363	679	404	<	0.828320025999999987	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
3495	907	28	\N	27.0020008000000011	7.0999999	\N	67	\N	2012-06-19 09:32:23	2016-03-17 09:19:04.94469
3496	907	68	<	0.17800000299999999	\N	\N	67	\N	2012-06-19 09:32:23	2016-03-17 09:19:04.94469
3497	907	220	<	0.152999996999999999	\N	\N	67	\N	2012-06-19 09:32:23	2016-03-17 09:19:04.94469
3498	907	340	<	0.159999996000000005	\N	\N	67	\N	2012-06-19 09:32:23	2016-03-17 09:19:04.94469
3499	907	369	<	0.148000001999999992	\N	\N	67	\N	2012-06-19 09:32:23	2016-03-17 09:19:04.94469
3500	907	373	<	0.173999994999999991	\N	\N	67	\N	2012-06-19 09:32:23	2016-03-17 09:19:04.94469
3501	907	404	<	1.11099993999999991	\N	\N	67	\N	2012-06-19 09:32:23	2016-03-17 09:19:04.94469
2027	409	28	\N	118.767998000000006	4.4000001	\N	67	\N	2012-05-04 11:31:45	2016-03-17 09:19:04.94469
2028	409	68	<	0.120999998999999997	\N	\N	67	\N	2012-05-04 11:31:45	2016-03-17 09:19:04.94469
2029	409	220	<	0.0979999973999999968	\N	\N	67	\N	2012-05-04 11:31:45	2016-03-17 09:19:04.94469
2030	409	340	<	0.112000003000000001	\N	\N	67	\N	2012-05-04 11:31:45	2016-03-17 09:19:04.94469
2031	409	369	<	0.108000002999999997	\N	\N	67	\N	2012-05-04 11:31:45	2016-03-17 09:19:04.94469
2032	409	373	<	0.136999995000000013	\N	\N	67	\N	2012-05-04 11:31:45	2016-03-17 09:19:04.94469
2033	409	404	<	0.66299998800000004	\N	\N	67	\N	2012-05-04 11:31:45	2016-03-17 09:19:04.94469
3347	45	28	\N	73.1989975000000044	4.5	\N	67	\N	2012-06-20 08:55:23	2016-03-17 09:19:04.94469
3348	45	68	<	0.105999998999999998	\N	\N	67	\N	2012-06-20 08:55:23	2016-03-17 09:19:04.94469
3349	45	220	<	0.0879999994999999952	\N	\N	67	\N	2012-06-20 08:55:23	2016-03-17 09:19:04.94469
3350	45	340	<	0.107000000999999997	\N	\N	67	\N	2012-06-20 08:55:23	2016-03-17 09:19:04.94469
3351	45	369	<	0.0970000029000000069	\N	\N	67	\N	2012-06-20 08:55:23	2016-03-17 09:19:04.94469
3352	45	373	<	0.114000000000000004	\N	\N	67	\N	2012-06-20 08:55:23	2016-03-17 09:19:04.94469
3353	45	404	<	0.619000018000000041	\N	\N	67	\N	2012-06-20 08:55:23	2016-03-17 09:19:04.94469
1992	404	28	\N	72.1770020000000017	4.4000001	\N	67	\N	2012-01-11 14:27:56	2016-03-17 09:19:04.94469
1993	404	68	<	0.089000001499999995	\N	\N	67	\N	2012-01-11 14:27:56	2016-03-17 09:19:04.94469
1994	404	220	<	0.0680000037000000057	\N	\N	67	\N	2012-01-11 14:27:56	2016-03-17 09:19:04.94469
1995	404	340	<	0.0850000008999999973	\N	\N	67	\N	2012-01-11 14:27:56	2016-03-17 09:19:04.94469
1996	404	369	<	0.0680000037000000057	\N	\N	67	\N	2012-01-11 14:27:56	2016-03-17 09:19:04.94469
1997	404	373	<	0.0810000002000000052	\N	\N	67	\N	2012-01-11 14:27:56	2016-03-17 09:19:04.94469
1998	404	404	<	0.483999997000000015	\N	\N	67	\N	2012-01-11 14:27:56	2016-03-17 09:19:04.94469
1262	669	28	\N	76.752960200000004	1.70000005	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
1263	669	68	<	0.169841558000000004	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
1264	669	220	<	0.135238096000000002	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
1265	669	222	<	1.36822819999999989	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
1266	669	325	<	0.120374463000000001	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
1267	669	340	<	0.126882269999999991	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
1268	669	369	<	0.143208503999999986	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
1269	669	373	<	0.155749470000000001	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
1270	669	404	<	0.56653392300000005	\N	\N	67	\N	2012-06-11 11:16:53	2016-03-17 09:19:04.94469
6374	382	28	\N	111.257003999999995	7.69999981	\N	67	\N	2012-04-26 12:56:57	2016-03-17 09:19:04.94469
6375	382	68	<	0.368000001000000021	\N	\N	67	\N	2012-04-26 12:56:57	2016-03-17 09:19:04.94469
6376	382	220	<	0.529999970999999959	\N	\N	67	\N	2012-04-26 12:56:57	2016-03-17 09:19:04.94469
6377	382	340	<	0.593999982000000037	\N	\N	67	\N	2012-04-26 12:56:57	2016-03-17 09:19:04.94469
6378	382	369	<	0.50199997399999996	\N	\N	67	\N	2012-04-26 12:56:57	2016-03-17 09:19:04.94469
6379	382	373	\N	2.29500007999999989	15.3999996	\N	67	\N	2012-04-26 12:56:57	2016-03-17 09:19:04.94469
6380	382	404	<	3.46700001000000002	\N	\N	67	\N	2012-04-26 12:56:57	2016-03-17 09:19:04.94469
1419	687	28	\N	26.8731231999999984	3.5	\N	67	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
1420	687	68	<	0.139102891000000006	\N	\N	67	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
1421	687	220	<	0.142707929000000011	\N	\N	67	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
1422	687	222	<	1.2259517900000001	\N	\N	67	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
1423	687	325	<	0.482552289999999995	\N	\N	67	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
1424	687	340	<	0.229643135999999998	\N	\N	67	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
1425	687	369	<	0.128076345000000008	\N	\N	67	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
1426	687	373	\N	5.90278672999999987	1.60000002	\N	67	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
1427	687	404	<	0.471235216000000012	\N	\N	67	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
1410	686	28	\N	41.1948166000000029	2.20000005	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1411	686	68	<	0.120307638999999994	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1412	686	220	<	0.121018371999999999	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1413	686	222	<	1.1164464999999999	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1414	686	325	<	0.187686249999999999	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1415	686	340	<	0.148165181000000007	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1416	686	369	<	0.115840978999999997	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1417	686	373	<	0.125201865999999995	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
1418	686	404	<	0.753361940000000008	\N	\N	67	\N	2012-02-01 09:06:15	2016-03-17 09:19:04.94469
3488	906	28	\N	41.3510016999999976	5	\N	67	\N	2012-06-20 08:56:20	2016-03-17 09:19:04.94469
3489	906	68	<	0.118000000999999993	\N	\N	67	\N	2012-06-20 08:56:20	2016-03-17 09:19:04.94469
3490	906	220	<	0.105999998999999998	\N	\N	67	\N	2012-06-20 08:56:20	2016-03-17 09:19:04.94469
3491	906	340	<	0.136999995000000013	\N	\N	67	\N	2012-06-20 08:56:20	2016-03-17 09:19:04.94469
3492	906	369	<	0.104000001999999994	\N	\N	67	\N	2012-06-20 08:56:20	2016-03-17 09:19:04.94469
3493	906	373	<	0.127000004	\N	\N	67	\N	2012-06-20 08:56:20	2016-03-17 09:19:04.94469
3494	906	404	<	0.666000009000000004	\N	\N	67	\N	2012-06-20 08:56:20	2016-03-17 09:19:04.94469
1374	682	28	\N	116.195258999999993	1.10000002	\N	67	\N	2012-05-15 08:27:55	2016-03-17 09:19:04.94469
1375	682	68	<	0.118619173999999994	\N	\N	67	\N	2012-05-15 08:27:55	2016-03-17 09:19:04.94469
1376	682	220	<	0.106746331	\N	\N	67	\N	2012-05-15 08:27:55	2016-03-17 09:19:04.94469
1377	682	222	<	1.00748836999999991	\N	\N	67	\N	2012-05-15 08:27:55	2016-03-17 09:19:04.94469
1378	682	325	<	0.110738158000000003	\N	\N	67	\N	2012-05-15 08:27:55	2016-03-17 09:19:04.94469
1379	682	340	<	0.109336569999999994	\N	\N	67	\N	2012-05-15 08:27:55	2016-03-17 09:19:04.94469
1380	682	369	<	0.112910419999999997	\N	\N	67	\N	2012-05-15 08:27:55	2016-03-17 09:19:04.94469
1381	682	373	<	0.120659194999999997	\N	\N	67	\N	2012-05-15 08:27:55	2016-03-17 09:19:04.94469
1382	682	404	<	0.741539538000000054	\N	\N	67	\N	2012-05-15 08:27:55	2016-03-17 09:19:04.94469
1	749	28	\N	97	1.10000002	\N	69	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
2	749	68	<	0.0716999992999999974	\N	\N	69	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
3	749	220	<	0.0644000024000000032	\N	\N	69	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
4	749	222	<	0.558000028000000037	\N	\N	69	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
5	749	325	<	0.279000014000000018	\N	\N	69	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6	749	340	<	0.111000001000000001	\N	\N	69	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
7	749	369	<	0.0584000013999999984	\N	\N	69	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
8	749	373	<	0.0666000023000000024	\N	\N	69	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
9	749	404	<	0.222000003000000001	\N	\N	69	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
687	855	1	<	3	\N	\N	63	\N	2012-04-16 09:51:41	2016-03-17 09:19:04.94469
692	856	28	\N	0.128978922999999995	7.5	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
693	856	68	<	0.00137814821000000007	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
694	856	220	<	0.00145654007999999999	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
695	856	222	<	0.0119643118000000003	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
696	856	325	<	0.0242622104000000012	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
697	856	340	<	0.00414422340999999993	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
698	856	369	<	0.00138184184000000009	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
699	856	373	<	0.00138636387000000004	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
700	856	404	<	0.00521474099000000021	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
701	856	658	\N	0.0307449046999999989	4.5	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
702	856	670	\N	0.0340126492000000016	14.1000004	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
703	856	672	\N	0.0316770411999999987	1.89999998	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
704	856	673	\N	0.00955014862000000062	8.30000019	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
705	856	684	\N	0.0362088232999999982	12.6000004	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
706	856	686	\N	0.0102149891000000003	9	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
707	856	717	<	0.0337323584000000024	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
708	856	725	\N	0.0111436360000000002	9.39999962	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
688	857	746	\N	0.00115999999000000005	4.80000019	3.69000009000000002e-05	63	\N	2012-05-04 07:21:12	2016-03-17 09:19:04.94469
689	857	747	\N	4.74000007999999997e-05	26.2000008	2.83999997999999993e-05	63	\N	2012-05-04 07:21:12	2016-03-17 09:19:04.94469
690	857	750	\N	0.00101000001000000001	5.0999999	3.85999991999999968e-05	63	\N	2012-05-04 07:21:12	2016-03-17 09:19:04.94469
691	858	165	\N	0.00200000009000000012	5.80000019	0.000460000009999999974	63	\N	2012-05-21 12:02:14	2016-03-17 09:19:04.94469
709	859	768	<	2.83000007999999996e-05	\N	\N	63	\N	2012-05-04 07:22:50	2016-03-17 09:19:04.94469
710	859	850	<	3.22000013999999992e-05	\N	\N	63	\N	2012-05-04 07:22:50	2016-03-17 09:19:04.94469
3335	781	28	<	0.17599999899999999	\N	\N	63	\N	2012-05-30 13:21:12	2016-03-17 09:19:04.94469
3336	781	68	<	0.00700000022000000013	\N	\N	63	\N	2012-05-30 13:21:12	2016-03-17 09:19:04.94469
3337	781	220	<	0.0109999998999999998	\N	\N	63	\N	2012-05-30 13:21:12	2016-03-17 09:19:04.94469
3338	781	340	<	0.0390000007999999967	\N	\N	63	\N	2012-05-30 13:21:12	2016-03-17 09:19:04.94469
3339	781	369	<	0.00700000022000000013	\N	\N	63	\N	2012-05-30 13:21:12	2016-03-17 09:19:04.94469
3340	781	373	<	0.00800000038000000038	\N	\N	63	\N	2012-05-30 13:21:12	2016-03-17 09:19:04.94469
3341	781	404	<	0.0460000001000000006	\N	\N	63	\N	2012-05-30 13:21:12	2016-03-17 09:19:04.94469
3333	782	165	\N	0.00800000038000000038	25.1000004	0.00700000022000000013	63	\N	2012-07-12 13:30:43	2016-03-17 09:19:04.94469
3342	783	746	\N	0.0710000023000000036	16	\N	63	\N	2012-09-12 08:24:09	2016-03-17 09:19:04.94469
3343	783	747	<	0.00499999988999999968	\N	\N	63	\N	2012-09-12 08:24:09	2016-03-17 09:19:04.94469
3344	783	750	\N	0.0370000004999999979	16	\N	63	\N	2012-09-12 08:24:09	2016-03-17 09:19:04.94469
3345	783	768	<	0.00499999988999999968	\N	\N	63	\N	2012-09-12 08:24:09	2016-03-17 09:19:04.94469
3346	783	850	<	0.00499999988999999968	\N	\N	63	\N	2012-09-12 08:24:09	2016-03-17 09:19:04.94469
3334	784	1	<	6.9800000200000003	\N	\N	63	\N	2012-07-05 08:00:46	2016-03-17 09:19:04.94469
3312	776	746	\N	0.0120000000999999999	16	\N	63	\N	2012-09-12 08:23:10	2016-03-17 09:19:04.94469
3313	776	747	<	0.00499999988999999968	\N	\N	63	\N	2012-09-12 08:23:10	2016-03-17 09:19:04.94469
3314	776	750	\N	0.00999999977999999935	17	\N	63	\N	2012-09-12 08:23:10	2016-03-17 09:19:04.94469
3315	776	768	<	0.00499999988999999968	\N	\N	63	\N	2012-09-12 08:23:10	2016-03-17 09:19:04.94469
3316	776	850	<	0.00499999988999999968	\N	\N	63	\N	2012-09-12 08:23:10	2016-03-17 09:19:04.94469
3317	777	28	<	0.241999998999999993	\N	\N	63	\N	2012-06-13 08:51:46	2016-03-17 09:19:04.94469
3318	777	68	<	0.00899999961000000001	\N	\N	63	\N	2012-06-13 08:51:46	2016-03-17 09:19:04.94469
3319	777	220	<	0.0170000008999999994	\N	\N	63	\N	2012-06-13 08:51:46	2016-03-17 09:19:04.94469
3320	777	340	<	0.19599999500000001	\N	\N	63	\N	2012-06-13 08:51:46	2016-03-17 09:19:04.94469
3321	777	369	<	0.00899999961000000001	\N	\N	63	\N	2012-06-13 08:51:46	2016-03-17 09:19:04.94469
3322	777	373	<	0.0109999998999999998	\N	\N	63	\N	2012-06-13 08:51:46	2016-03-17 09:19:04.94469
3323	777	404	<	0.0839999988999999975	\N	\N	63	\N	2012-06-13 08:51:46	2016-03-17 09:19:04.94469
3325	778	1	<	7	\N	\N	63	\N	2012-07-05 07:59:30	2016-03-17 09:19:04.94469
3324	779	165	\N	0.00999999977999999935	24	0.00800000038000000038	63	\N	2012-07-12 13:35:14	2016-03-17 09:19:04.94469
2238	457	28	<	0.204999997999999989	\N	\N	63	\N	2012-03-02 12:40:21	2016-03-17 09:19:04.94469
2239	457	68	<	0.00700000022000000013	\N	\N	63	\N	2012-03-02 12:40:21	2016-03-17 09:19:04.94469
2240	457	220	<	0.00999999977999999935	\N	\N	63	\N	2012-03-02 12:40:21	2016-03-17 09:19:04.94469
2241	457	340	<	0.056000001700000003	\N	\N	63	\N	2012-03-02 12:40:21	2016-03-17 09:19:04.94469
2242	457	369	<	0.00700000022000000013	\N	\N	63	\N	2012-03-02 12:40:21	2016-03-17 09:19:04.94469
2243	457	373	<	0.00700000022000000013	\N	\N	63	\N	2012-03-02 12:40:21	2016-03-17 09:19:04.94469
2244	457	404	<	0.0549999997000000032	\N	\N	63	\N	2012-03-02 12:40:21	2016-03-17 09:19:04.94469
2642	546	28	\N	252.158996999999999	4.30000019	\N	65	\N	2012-04-18 11:47:50	2016-03-17 09:19:04.94469
2643	546	68	<	0.226999998000000008	\N	\N	65	\N	2012-04-18 11:47:50	2016-03-17 09:19:04.94469
2644	546	220	<	0.335999994999999996	\N	\N	65	\N	2012-04-18 11:47:50	2016-03-17 09:19:04.94469
2645	546	340	<	1.01400006000000009	\N	\N	65	\N	2012-04-18 11:47:50	2016-03-17 09:19:04.94469
2646	546	369	<	0.215000003999999995	\N	\N	65	\N	2012-04-18 11:47:50	2016-03-17 09:19:04.94469
2647	546	373	\N	59.4729996000000014	6	\N	65	\N	2012-04-18 11:47:50	2016-03-17 09:19:04.94469
2648	546	404	<	1.42999995000000002	\N	\N	65	\N	2012-04-18 11:47:50	2016-03-17 09:19:04.94469
2641	547	165	\N	4.7699999799999997	16.1000004	\N	65	\N	2013-02-12 12:36:06	2016-03-17 09:19:04.94469
2583	536	28	\N	593.539000999999985	4.19999981	\N	65	\N	2012-04-18 11:47:05	2016-03-17 09:19:04.94469
2584	536	68	<	0.18000000699999999	\N	\N	65	\N	2012-04-18 11:47:05	2016-03-17 09:19:04.94469
2585	536	220	<	0.19599999500000001	\N	\N	65	\N	2012-04-18 11:47:05	2016-03-17 09:19:04.94469
2586	536	340	<	0.284000008999999998	\N	\N	65	\N	2012-04-18 11:47:05	2016-03-17 09:19:04.94469
2587	536	369	<	0.172999992999999991	\N	\N	65	\N	2012-04-18 11:47:05	2016-03-17 09:19:04.94469
2588	536	373	\N	12.6910000000000007	6.0999999	\N	65	\N	2012-04-18 11:47:05	2016-03-17 09:19:04.94469
2589	536	404	<	1.84699999999999998	\N	\N	65	\N	2012-04-18 11:47:05	2016-03-17 09:19:04.94469
2671	552	165	\N	1.37999999999999989	16.3999996	\N	65	\N	2012-10-31 12:51:02	2016-03-17 09:19:04.94469
2672	553	28	\N	354.654998999999975	4.19999981	\N	65	\N	2012-04-18 11:47:21	2016-03-17 09:19:04.94469
2673	553	68	<	0.17499999699999999	\N	\N	65	\N	2012-04-18 11:47:21	2016-03-17 09:19:04.94469
2674	553	220	<	0.185000001999999997	\N	\N	65	\N	2012-04-18 11:47:21	2016-03-17 09:19:04.94469
2675	553	340	<	0.273999988999999999	\N	\N	65	\N	2012-04-18 11:47:21	2016-03-17 09:19:04.94469
2676	553	369	<	0.166999996000000012	\N	\N	65	\N	2012-04-18 11:47:21	2016-03-17 09:19:04.94469
2677	553	373	\N	13.9410000000000007	6.0999999	\N	65	\N	2012-04-18 11:47:21	2016-03-17 09:19:04.94469
2678	553	404	<	1.47599995000000006	\N	\N	65	\N	2012-04-18 11:47:21	2016-03-17 09:19:04.94469
504	841	2	\N	7.41751908999999987	9.5	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
505	841	28	\N	229.183197000000007	1.60000002	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
506	841	68	<	0.280420214000000001	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
507	841	220	<	0.276409923999999974	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
508	841	222	<	2.49894070999999984	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
509	841	325	<	0.706013321999999999	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
510	841	340	<	0.397895037999999979	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
511	841	369	<	0.342206805999999975	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
512	841	373	\N	14.0789299000000003	1.20000005	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
513	841	404	<	1.67993306999999992	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
514	841	658	\N	30.4505347999999998	1.39999998	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
515	841	670	\N	154.071563999999995	1.70000005	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
516	841	672	\N	33.0379944000000023	0.699999988	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
517	841	673	\N	33.3438644000000011	0.699999988	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
518	841	684	\N	35.9584198000000015	3.70000005	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
519	841	686	\N	31.8192616000000008	0.800000012	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
520	841	717	\N	84.5872726000000057	6.5999999	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
521	841	725	\N	36.3506203000000028	0.899999976	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
2755	574	28	\N	502.601990000000001	4.5	\N	65	\N	2012-03-09 08:51:44	2016-03-17 09:19:04.94469
2756	574	68	<	0.930000006999999962	\N	\N	65	\N	2012-03-09 08:51:44	2016-03-17 09:19:04.94469
2757	574	220	<	1.1599999700000001	\N	\N	65	\N	2012-03-09 08:51:44	2016-03-17 09:19:04.94469
2758	574	340	\N	11.9740000000000002	21.7999992	\N	65	\N	2012-03-09 08:51:44	2016-03-17 09:19:04.94469
2759	574	369	<	0.708999990999999996	\N	\N	65	\N	2012-03-09 08:51:44	2016-03-17 09:19:04.94469
2760	574	373	\N	6.58300017999999998	7.9000001	\N	65	\N	2012-03-09 08:51:44	2016-03-17 09:19:04.94469
2761	574	404	<	3.52200006999999982	\N	\N	65	\N	2012-03-09 08:51:44	2016-03-17 09:19:04.94469
2702	558	1	\N	6.0476150500000001	17.6000004	\N	63	\N	2012-03-15 20:04:12	2016-03-17 09:19:04.94469
2695	559	28	\N	0.762426971999999981	16.1000004	\N	63	\N	2012-03-02 11:00:40	2016-03-17 09:19:04.94469
2696	559	68	<	0.0162599998999999988	\N	\N	63	\N	2012-03-02 11:00:40	2016-03-17 09:19:04.94469
2697	559	220	<	0.0154999996999999994	\N	\N	63	\N	2012-03-02 11:00:40	2016-03-17 09:19:04.94469
2698	559	340	<	0.0520600006000000032	\N	\N	63	\N	2012-03-02 11:00:40	2016-03-17 09:19:04.94469
2699	559	369	<	0.0126599994999999996	\N	\N	63	\N	2012-03-02 11:00:40	2016-03-17 09:19:04.94469
2700	559	373	<	0.0157500003000000006	\N	\N	63	\N	2012-03-02 11:00:40	2016-03-17 09:19:04.94469
2701	559	404	<	0.0680000037000000057	\N	\N	63	\N	2012-03-02 11:00:40	2016-03-17 09:19:04.94469
608	847	2	\N	10.8878678999999998	6.80000019	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
609	847	28	\N	378.161254999999983	1.10000002	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
610	847	68	<	0.321417510999999989	\N	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
611	847	220	<	0.253271102999999997	\N	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
612	847	222	<	2.46086812000000021	\N	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
613	847	325	<	0.390654086999999983	\N	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
614	847	340	\N	0.335008680999999975	22.6000004	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
615	847	369	<	0.278405665999999996	\N	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
616	847	373	\N	0.833487569999999955	9.30000019	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
617	847	404	<	0.915440023000000047	\N	\N	65	\N	2012-03-12 09:19:07	2016-03-17 09:19:04.94469
406	835	28	\N	118.186958000000004	1.70000005	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
407	835	68	<	0.167968227999999997	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
408	835	220	<	0.188048974000000008	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
409	835	222	<	1.59371448000000004	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
410	835	325	<	0.770765542999999997	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
411	835	340	<	0.32514426099999999	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
412	835	369	<	0.196677371999999989	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
413	835	373	\N	32.7951163999999977	0.600000024	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
414	835	404	<	0.878977180000000025	\N	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
415	835	658	\N	11.0682887999999995	1.79999995	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
416	835	670	\N	93.7899170000000026	1.70000005	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
417	835	672	\N	12.0025530000000007	1	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
418	835	673	\N	13.7101354999999998	1	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
419	835	684	\N	14.2685537	4.5999999	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
420	835	686	\N	13.1888884999999991	1.10000002	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
421	835	717	\N	33.7797928000000027	10.1000004	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
422	835	725	\N	11.0511780000000002	1.39999998	\N	65	\N	2012-03-20 12:20:47	2016-03-17 09:19:04.94469
236	792	165	\N	0.00240000010999999978	7.80000019	0.000730000028999999956	63	\N	2012-05-21 12:12:40	2016-03-17 09:19:04.94469
249	793	1	<	3	\N	\N	63	\N	2012-04-16 09:57:22	2016-03-17 09:19:04.94469
240	794	28	\N	0.174206643999999994	12.6000004	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
241	794	68	<	0.00372764956999999987	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
242	794	220	<	0.00606708881000000023	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
243	794	222	<	0.0357809216000000013	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
244	794	325	<	0.174499005000000013	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
245	794	340	<	0.0314799248999999975	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
246	794	369	<	0.0036611820100000002	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
247	794	373	<	0.00404624687999999982	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
248	794	404	<	0.0183811449000000002	\N	\N	63	\N	2012-03-22 08:12:08	2016-03-17 09:19:04.94469
237	795	746	\N	0.00404000003000000007	5	0.000138999996000000007	63	\N	2012-05-07 13:15:57	2016-03-17 09:19:04.94469
238	795	747	\N	0.000127000006999999996	32.0999985	0.000106999999999999999	63	\N	2012-05-07 13:15:57	2016-03-17 09:19:04.94469
239	795	750	\N	0.00323999998999999986	5.5	0.000144999998000000009	63	\N	2012-05-07 13:15:57	2016-03-17 09:19:04.94469
250	796	768	<	0.000103999998999999998	\N	\N	63	\N	2012-05-07 13:17:54	2016-03-17 09:19:04.94469
251	796	850	<	0.000117000002999999999	\N	\N	63	\N	2012-05-07 13:17:54	2016-03-17 09:19:04.94469
796	593	1	<	2.29999995000000013	\N	\N	63	\N	2012-07-25 12:12:59	2016-03-17 09:19:04.94469
810	594	746	<	0.000287000003000000025	\N	\N	63	\N	2012-06-08 11:51:07	2016-03-17 09:19:04.94469
811	594	747	<	0.000222999994999999992	\N	\N	63	\N	2012-06-08 11:51:07	2016-03-17 09:19:04.94469
812	594	750	<	0.000299000006999999976	\N	\N	63	\N	2012-06-08 11:51:07	2016-03-17 09:19:04.94469
813	595	165	<	0.000289999996000000018	\N	\N	63	\N	2012-07-23 10:54:31	2016-03-17 09:19:04.94469
797	596	28	\N	0.463155925000000024	2	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
798	596	68	<	0.0010462796800000001	\N	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
799	596	220	<	0.00122176902000000007	\N	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
800	596	222	<	0.00855376757999999973	\N	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
801	596	325	<	0.0586886293999999975	\N	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
802	596	340	<	0.00483464543000000028	\N	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
803	596	369	<	0.000995716778999999929	\N	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
804	596	373	<	0.00100263243000000006	\N	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
805	596	404	<	0.00337290810000000002	\N	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
806	596	673	\N	0.0112730804999999993	5.19999981	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
807	596	686	\N	0.010525777	7	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
808	596	717	<	0.0190863143999999985	\N	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
809	596	725	\N	0.0178463067999999996	5	\N	63	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
814	597	768	<	1.59999999999999993e-05	\N	\N	63	\N	2012-06-08 11:53:04	2016-03-17 09:19:04.94469
815	597	850	<	1.82000003000000001e-05	\N	\N	63	\N	2012-06-08 11:53:04	2016-03-17 09:19:04.94469
2337	649	28	<	0.660000025999999962	\N	\N	63	\N	2012-02-01 13:30:03	2016-03-17 09:19:04.94469
2338	649	68	<	0.0260000004999999985	\N	\N	63	\N	2012-02-01 13:30:03	2016-03-17 09:19:04.94469
2339	649	220	<	0.0289999992000000012	\N	\N	63	\N	2012-02-01 13:30:03	2016-03-17 09:19:04.94469
2340	649	340	<	0.0610000007000000011	\N	\N	63	\N	2012-02-01 13:30:03	2016-03-17 09:19:04.94469
2341	649	369	<	0.0240000001999999997	\N	\N	63	\N	2012-02-01 13:30:03	2016-03-17 09:19:04.94469
2342	649	373	<	0.0309999995	\N	\N	63	\N	2012-02-01 13:30:03	2016-03-17 09:19:04.94469
2343	649	404	<	0.19699999700000001	\N	\N	63	\N	2012-02-01 13:30:03	2016-03-17 09:19:04.94469
2419	499	28	\N	126.535004000000001	6.0999999	\N	65	\N	2012-02-02 13:38:43	2016-03-17 09:19:04.94469
2420	499	68	<	1.07899999999999996	\N	\N	65	\N	2012-02-02 13:38:43	2016-03-17 09:19:04.94469
2421	499	220	<	1.37199998000000001	\N	\N	65	\N	2012-02-02 13:38:43	2016-03-17 09:19:04.94469
2422	499	340	\N	9.02000046000000033	13.3999996	\N	65	\N	2012-02-02 13:38:43	2016-03-17 09:19:04.94469
2423	499	369	<	1.2000000500000001	\N	\N	65	\N	2012-02-02 13:38:43	2016-03-17 09:19:04.94469
2424	499	373	<	1.57799994999999993	\N	\N	65	\N	2012-02-02 13:38:43	2016-03-17 09:19:04.94469
2425	499	404	<	5.47599983000000012	\N	\N	65	\N	2012-02-02 13:38:43	2016-03-17 09:19:04.94469
2529	517	28	\N	1191.36999999999989	4.19999981	\N	65	\N	2012-03-15 10:33:22	2016-03-17 09:19:04.94469
2530	517	68	<	0.257999986000000014	\N	\N	65	\N	2012-03-15 10:33:22	2016-03-17 09:19:04.94469
2531	517	220	<	0.224999994000000009	\N	\N	65	\N	2012-03-15 10:33:22	2016-03-17 09:19:04.94469
2532	517	340	\N	13.7200003000000006	6.80000019	\N	65	\N	2012-03-15 10:33:22	2016-03-17 09:19:04.94469
2533	517	369	<	0.205999999999999989	\N	\N	65	\N	2012-03-15 10:33:22	2016-03-17 09:19:04.94469
2534	517	373	\N	28.2719993999999986	6.0999999	\N	65	\N	2012-03-15 10:33:22	2016-03-17 09:19:04.94469
2535	517	404	<	1.29600000000000004	\N	\N	65	\N	2012-03-15 10:33:22	2016-03-17 09:19:04.94469
2515	515	28	\N	232.007995999999991	4.30000019	\N	65	\N	2012-03-15 10:33:31	2016-03-17 09:19:04.94469
2516	515	68	<	0.148000001999999992	\N	\N	65	\N	2012-03-15 10:33:31	2016-03-17 09:19:04.94469
2517	515	220	<	0.149000003999999991	\N	\N	65	\N	2012-03-15 10:33:31	2016-03-17 09:19:04.94469
2518	515	340	<	0.263000010999999978	\N	\N	65	\N	2012-03-15 10:33:31	2016-03-17 09:19:04.94469
2519	515	369	<	0.136000007000000006	\N	\N	65	\N	2012-03-15 10:33:31	2016-03-17 09:19:04.94469
2520	515	373	\N	1.19799995000000004	7.9000001	\N	65	\N	2012-03-15 10:33:31	2016-03-17 09:19:04.94469
2521	515	404	<	1.23500001000000004	\N	\N	65	\N	2012-03-15 10:33:31	2016-03-17 09:19:04.94469
2536	518	28	<	0.939000009999999996	\N	\N	63	\N	2012-03-15 10:32:18	2016-03-17 09:19:04.94469
2537	518	68	<	0.0399999991000000027	\N	\N	63	\N	2012-03-15 10:32:18	2016-03-17 09:19:04.94469
2538	518	220	<	0.0390000007999999967	\N	\N	63	\N	2012-03-15 10:32:18	2016-03-17 09:19:04.94469
2539	518	340	<	0.0700000003000000037	\N	\N	63	\N	2012-03-15 10:32:18	2016-03-17 09:19:04.94469
2540	518	369	<	0.0350000000999999977	\N	\N	63	\N	2012-03-15 10:32:18	2016-03-17 09:19:04.94469
2541	518	373	<	0.0399999991000000027	\N	\N	63	\N	2012-03-15 10:32:18	2016-03-17 09:19:04.94469
2542	518	404	<	0.268000006999999985	\N	\N	63	\N	2012-03-15 10:32:18	2016-03-17 09:19:04.94469
2501	513	28	\N	470.076996000000008	3.9000001	\N	65	\N	2012-03-15 12:09:13	2016-03-17 09:19:04.94469
2502	513	68	<	0.211999996999999996	\N	\N	65	\N	2012-03-15 12:09:13	2016-03-17 09:19:04.94469
2503	513	220	<	0.209000005999999988	\N	\N	65	\N	2012-03-15 12:09:13	2016-03-17 09:19:04.94469
2504	513	340	\N	2.08999990999999996	7.4000001	\N	65	\N	2012-03-15 12:09:13	2016-03-17 09:19:04.94469
2505	513	369	<	0.188999996000000003	\N	\N	65	\N	2012-03-15 12:09:13	2016-03-17 09:19:04.94469
2506	513	373	\N	1.29900002000000003	7	\N	65	\N	2012-03-15 12:09:13	2016-03-17 09:19:04.94469
2507	513	404	<	2.13499998999999985	\N	\N	65	\N	2012-03-15 12:09:13	2016-03-17 09:19:04.94469
2598	538	28	\N	559.80902100000003	4.19999981	\N	65	\N	2012-04-20 12:45:31	2016-03-17 09:19:04.94469
2599	538	68	<	0.17499999699999999	\N	\N	65	\N	2012-04-20 12:45:31	2016-03-17 09:19:04.94469
2600	538	220	<	0.188999996000000003	\N	\N	65	\N	2012-04-20 12:45:31	2016-03-17 09:19:04.94469
2601	538	340	<	0.344999999000000002	\N	\N	65	\N	2012-04-20 12:45:31	2016-03-17 09:19:04.94469
2602	538	369	<	0.160999998000000005	\N	\N	65	\N	2012-04-20 12:45:31	2016-03-17 09:19:04.94469
2603	538	373	\N	16.6019992999999992	6.0999999	\N	65	\N	2012-04-20 12:45:31	2016-03-17 09:19:04.94469
2604	538	404	<	1.28600000999999997	\N	\N	65	\N	2012-04-20 12:45:31	2016-03-17 09:19:04.94469
2597	539	165	\N	1.03999996000000006	16.5	\N	65	\N	2012-06-28 06:24:03	2016-03-17 09:19:04.94469
2280	639	165	\N	0.0649999975999999979	17.7999992	\N	67	\N	2013-02-12 12:42:02	2016-03-17 09:19:04.94469
2273	640	28	\N	148.587006000000002	4.30000019	\N	67	\N	2012-05-04 11:32:54	2016-03-17 09:19:04.94469
2274	640	68	<	0.126000002	\N	\N	67	\N	2012-05-04 11:32:54	2016-03-17 09:19:04.94469
2275	640	220	<	0.102999999999999994	\N	\N	67	\N	2012-05-04 11:32:54	2016-03-17 09:19:04.94469
2276	640	340	<	0.166999996000000012	\N	\N	67	\N	2012-05-04 11:32:54	2016-03-17 09:19:04.94469
2277	640	369	<	0.0960000007999999988	\N	\N	67	\N	2012-05-04 11:32:54	2016-03-17 09:19:04.94469
2278	640	373	\N	0.183999999999999997	19.7000008	\N	67	\N	2012-05-04 11:32:54	2016-03-17 09:19:04.94469
2279	640	404	<	0.60699999299999996	\N	\N	67	\N	2012-05-04 11:32:54	2016-03-17 09:19:04.94469
6452	788	720	\N	0	0	0	247	f	2016-03-07 10:55:54.243	2016-03-17 09:19:04.94469
6460	788	185	\N	0	0	0	164	f	2016-03-07 10:58:13	2016-03-17 09:19:04.94469
200	788	2	\N	15.2635764999999992	2.70000005	\N	67	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
201	788	28	\N	88.9598236000000071	1.29999995	\N	67	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
202	788	68	<	0.112214267000000006	\N	\N	67	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
203	788	220	<	0.101773246999999997	\N	\N	67	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
204	788	222	<	0.939999998000000003	0	0	69	f	2016-03-07 10:57:58.509	2016-03-17 09:19:04.94469
205	788	325	<	0.219999999000000002	0	0	67	f	2016-03-07 10:57:50.126	2016-03-17 09:19:04.94469
206	788	340	<	0.137293844999999998	\N	\N	67	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
207	788	369	<	0.100221999000000006	\N	\N	67	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
208	788	373	\N	0.594288527999999983	5.5999999	\N	67	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
209	788	404	<	0.474219084000000013	\N	\N	67	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
3453	901	28	\N	54.1870003000000011	4.69999981	\N	67	\N	2012-06-19 09:31:23	2016-03-17 09:19:04.94469
3454	901	68	<	0.112000003000000001	\N	\N	67	\N	2012-06-19 09:31:23	2016-03-17 09:19:04.94469
3455	901	220	<	0.0960000007999999988	\N	\N	67	\N	2012-06-19 09:31:23	2016-03-17 09:19:04.94469
3456	901	340	<	0.101000004000000004	\N	\N	67	\N	2012-06-19 09:31:23	2016-03-17 09:19:04.94469
3457	901	369	<	0.112000003000000001	\N	\N	67	\N	2012-06-19 09:31:23	2016-03-17 09:19:04.94469
3458	901	373	<	0.122000000999999997	\N	\N	67	\N	2012-06-19 09:31:23	2016-03-17 09:19:04.94469
3459	901	404	<	0.66299998800000004	\N	\N	67	\N	2012-06-19 09:31:23	2016-03-17 09:19:04.94469
6388	900	2	\N	21.1653118000000013	4.69999981	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6389	900	28	\N	327.749023000000022	1.70000005	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6390	900	68	<	0.266908705000000024	\N	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6391	900	220	<	0.323401987999999974	\N	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6392	900	222	<	2.63727188000000012	\N	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6393	900	325	<	1.87468528999999995	\N	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6394	900	340	<	0.627474069999999995	\N	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6395	900	369	<	0.27228635499999998	\N	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6396	900	373	<	0.302946686999999992	\N	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
6397	900	404	<	2.15960836	\N	\N	65	\N	2012-01-23 08:56:08	2016-03-17 09:19:04.94469
211	789	28	\N	264.395019999999988	0.800000012	\N	65	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
212	789	68	<	0.156867474000000007	\N	\N	65	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
213	789	220	<	0.126424252999999986	\N	\N	65	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
214	789	222	<	1.20922339000000001	\N	\N	65	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
215	789	325	<	0.378945201999999981	\N	\N	65	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
216	789	340	<	0.193785265000000012	\N	\N	65	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
217	789	369	<	0.132164388999999993	\N	\N	65	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
218	789	373	<	0.142245218000000007	\N	\N	65	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
219	789	404	<	0.511382817999999961	\N	\N	65	\N	2012-02-06 08:57:51	2016-03-17 09:19:04.94469
180	785	2	\N	195.068252999999999	2	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
181	785	28	\N	642.813537999999994	0.899999976	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
182	785	68	<	0.35002288199999998	\N	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
183	785	220	<	0.324094563999999974	\N	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
184	785	222	<	2.90925120999999987	\N	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
185	785	325	<	0.886366427000000012	\N	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
186	785	340	<	0.478573619999999977	\N	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
187	785	369	<	0.32272213700000002	\N	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
188	785	373	\N	0.486364334999999981	18.2000008	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
189	785	404	<	2.09769200999999983	\N	\N	65	\N	2012-05-30 09:36:31	2016-03-17 09:19:04.94469
2559	533	2	\N	13.1285000000000007	8.5	\N	65	\N	2012-05-24 12:45:00	2016-03-17 09:19:04.94469
2560	533	28	\N	793.111023000000046	2.0999999	\N	65	\N	2012-05-24 12:45:00	2016-03-17 09:19:04.94469
2561	533	68	<	0.238100007000000002	\N	\N	65	\N	2012-05-24 12:45:00	2016-03-17 09:19:04.94469
2562	533	220	<	0.224900007000000013	\N	\N	65	\N	2012-05-24 12:45:00	2016-03-17 09:19:04.94469
2563	533	340	<	0.567399979000000054	\N	\N	65	\N	2012-05-24 12:45:00	2016-03-17 09:19:04.94469
2564	533	369	<	0.183799996999999993	\N	\N	65	\N	2012-05-24 12:45:00	2016-03-17 09:19:04.94469
2565	533	373	\N	10.5309000000000008	1.79999995	\N	65	\N	2012-05-24 12:45:00	2016-03-17 09:19:04.94469
2566	533	404	<	1.55900002000000004	\N	\N	65	\N	2012-05-24 12:45:00	2016-03-17 09:19:04.94469
2543	529	1	<	7.23999976999999983	\N	\N	63	\N	2012-07-05 08:08:14	2016-03-17 09:19:04.94469
2544	530	28	\N	9.18099976000000062	5.30000019	\N	63	\N	2012-06-04 14:03:58	2016-03-17 09:19:04.94469
2545	530	68	<	0.0340000017999999987	\N	\N	63	\N	2012-06-04 14:03:58	2016-03-17 09:19:04.94469
2546	530	220	<	0.0430000015000000027	\N	\N	63	\N	2012-06-04 14:03:58	2016-03-17 09:19:04.94469
2547	530	340	<	0.19900000100000001	\N	\N	63	\N	2012-06-04 14:03:58	2016-03-17 09:19:04.94469
2548	530	369	<	0.0299999993	\N	\N	63	\N	2012-06-04 14:03:58	2016-03-17 09:19:04.94469
2549	530	373	<	0.0430000015000000027	\N	\N	63	\N	2012-06-04 14:03:58	2016-03-17 09:19:04.94469
2550	530	404	<	0.223000005000000001	\N	\N	63	\N	2012-06-04 14:03:58	2016-03-17 09:19:04.94469
2203	452	28	\N	35.2960014000000015	4.69999981	\N	67	\N	2012-01-18 12:44:22	2016-03-17 09:19:04.94469
2204	452	68	<	0.0750000029999999956	\N	\N	67	\N	2012-01-18 12:44:22	2016-03-17 09:19:04.94469
2205	452	220	<	0.0710000023000000036	\N	\N	67	\N	2012-01-18 12:44:22	2016-03-17 09:19:04.94469
2206	452	340	<	0.093000002200000001	\N	\N	67	\N	2012-01-18 12:44:22	2016-03-17 09:19:04.94469
2207	452	369	<	0.0649999975999999979	\N	\N	67	\N	2012-01-18 12:44:22	2016-03-17 09:19:04.94469
2208	452	373	<	0.0879999994999999952	\N	\N	67	\N	2012-01-18 12:44:22	2016-03-17 09:19:04.94469
2209	452	404	<	0.451999992000000017	\N	\N	67	\N	2012-01-18 12:44:22	2016-03-17 09:19:04.94469
2196	451	28	\N	97.5049972999999994	4.5999999	\N	67	\N	2012-01-20 10:42:22	2016-03-17 09:19:04.94469
2197	451	68	<	0.150000005999999991	\N	\N	67	\N	2012-01-20 10:42:22	2016-03-17 09:19:04.94469
2198	451	220	<	0.135000005000000006	\N	\N	67	\N	2012-01-20 10:42:22	2016-03-17 09:19:04.94469
2199	451	340	<	0.165999994000000012	\N	\N	67	\N	2012-01-20 10:42:22	2016-03-17 09:19:04.94469
2200	451	369	<	0.136999995000000013	\N	\N	67	\N	2012-01-20 10:42:22	2016-03-17 09:19:04.94469
2201	451	373	<	0.212999999999999995	\N	\N	67	\N	2012-01-20 10:42:22	2016-03-17 09:19:04.94469
2202	451	404	<	0.949000001000000037	\N	\N	67	\N	2012-01-20 10:42:22	2016-03-17 09:19:04.94469
2041	411	28	\N	116.545997999999997	2.70000005	\N	67	\N	2012-02-29 14:37:51	2016-03-17 09:19:04.94469
2042	411	68	<	0.100199996999999999	\N	\N	67	\N	2012-02-29 14:37:51	2016-03-17 09:19:04.94469
2043	411	220	<	0.0879300013000000047	\N	\N	67	\N	2012-02-29 14:37:51	2016-03-17 09:19:04.94469
2044	411	340	<	0.143000007000000012	\N	\N	67	\N	2012-02-29 14:37:51	2016-03-17 09:19:04.94469
2045	411	369	<	0.0732399970000000011	\N	\N	67	\N	2012-02-29 14:37:51	2016-03-17 09:19:04.94469
2046	411	373	<	0.0985900014999999963	\N	\N	67	\N	2012-02-29 14:37:51	2016-03-17 09:19:04.94469
2047	411	404	<	0.593500017999999963	\N	\N	67	\N	2012-02-29 14:37:51	2016-03-17 09:19:04.94469
3799	195	28	\N	1030	2.9000001	\N	65	\N	2012-07-12 11:40:58	2016-03-17 09:19:04.94469
3800	195	68	<	0.486999989000000022	\N	\N	65	\N	2012-07-12 11:40:58	2016-03-17 09:19:04.94469
3801	195	220	<	0.310999990000000004	\N	\N	65	\N	2012-07-12 11:40:58	2016-03-17 09:19:04.94469
3802	195	340	<	0.423999995000000018	\N	\N	65	\N	2012-07-12 11:40:58	2016-03-17 09:19:04.94469
3803	195	369	<	0.324000000999999982	\N	\N	65	\N	2012-07-12 11:40:58	2016-03-17 09:19:04.94469
3804	195	373	<	0.326999992000000017	\N	\N	65	\N	2012-07-12 11:40:58	2016-03-17 09:19:04.94469
3805	195	404	<	1.58000004000000005	\N	\N	65	\N	2012-07-12 11:40:58	2016-03-17 09:19:04.94469
\.


ALTER TABLE messwert ENABLE TRIGGER ALL;

SELECT setval(pg_get_serial_sequence('messwert', 'id'),
    (SELECT max(id) FROM messwert));


--
-- TOC entry 4691 (class 0 OID 1170844)
-- Dependencies: 293
-- Data for Name: ortszuordnung; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE ortszuordnung DISABLE TRIGGER ALL;

COPY ortszuordnung (id, probe_id, ort_id, ortszuordnung_typ, ortszusatztext, letzte_aenderung, tree_modified) FROM stdin;
614	660	97	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
297	409	69	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
820	42	23	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
853	313	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
525	311	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
683	112	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
214	117	138	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
719	307	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
24	203	218	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
538	203	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
793	357	23	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
514	292	86	E	Region Rostow; IGW 2012	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
805	294	86	E	IGW 2012	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
409	25	129	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
884	145	23	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
818	4	76	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
402	140	23	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
859	284	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
288	703	29	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
552	301	86	E	IGW 2012, Region Riga	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
730	300	86	E	Region Krasnodar, IGW 2012	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
489	24	68	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
573	296	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
350	99	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
40	194	33	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
864	194	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
107	3	51	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
496	3	161	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
124	1	156	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
882	1	12	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
43	31	19	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
378	31	87	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
761	84	74	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
345	76	131	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
261	88	87	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
59	180	140	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
569	180	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
36	97	64	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
226	97	5	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
143	91	85	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
895	91	26	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
186	186	165	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
838	186	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
138	174	165	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
228	174	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
169	160	165	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
568	160	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
78	200	223	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
399	200	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
65	45	173	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
625	45	12	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
8	55	173	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
854	55	12	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
116	69	61	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
416	69	87	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
166	67	61	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
753	67	87	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
173	70	198	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
336	70	29	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
85	65	198	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
500	65	29	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
919	78	127	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
223	36	162	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
803	157	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
355	19	129	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
377	707	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
451	158	86	E	IGW 2012, Region Rostov	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
921	155	86	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
833	73	131	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
103	71	168	Z	\N	2013-08-12 07:57:26.510971	2016-03-17 09:19:04.94469
521	71	4	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
842	354	23	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
705	353	102	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
874	353	102	U	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
460	147	190	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
333	406	42	E	\N	2013-08-12 07:57:26.600695	2016-03-17 09:19:04.94469
\.


ALTER TABLE ortszuordnung ENABLE TRIGGER ALL;

SELECT setval(pg_get_serial_sequence('ortszuordnung', 'id'),
    (SELECT max(id) FROM ortszuordnung));


--
-- TOC entry 4695 (class 0 OID 1170895)
-- Dependencies: 297
-- Data for Name: status_protokoll; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE status_protokoll DISABLE TRIGGER ALL;

COPY status_protokoll (id, mst_id, datum, text, messungs_id, status_kombi, tree_modified) FROM stdin;
571	12020	2016-02-29 21:53:01.736444	Test	179	1	2016-03-17 09:19:04.94469
572	12010	2016-02-29 21:53:01.736444	Test	198	1	2016-03-17 09:19:04.94469
573	06010	2016-02-29 21:53:01.736444	Test	646	1	2016-03-17 09:19:04.94469
574	11010	2016-02-29 21:53:01.736444	Test	699	1	2016-03-17 09:19:04.94469
575	11010	2016-02-29 21:53:01.736444	Test	697	1	2016-03-17 09:19:04.94469
579	11010	2016-02-29 21:53:01.736444	Test	765	1	2016-03-17 09:19:04.94469
578	11010	2016-02-29 21:53:01.736444	Test	764	1	2016-03-17 09:19:04.94469
576	06060	2016-02-29 21:53:01.736444	Test	876	1	2016-03-17 09:19:04.94469
577	06060	2016-02-29 21:53:01.736444	Test	877	1	2016-03-17 09:19:04.94469
580	11010	2016-02-29 21:53:01.736444	Test	693	1	2016-03-17 09:19:04.94469
581	11010	2016-02-29 21:53:01.736444	Test	604	1	2016-03-17 09:19:04.94469
582	06010	2016-02-29 21:53:01.736444	Test	455	1	2016-03-17 09:19:04.94469
583	11010	2016-02-29 21:53:01.736444	Test	677	1	2016-03-17 09:19:04.94469
584	11010	2016-02-29 21:53:01.736444	Test	679	1	2016-03-17 09:19:04.94469
585	06010	2016-02-29 21:53:01.736444	Test	907	1	2016-03-17 09:19:04.94469
586	06010	2016-02-29 21:53:01.736444	Test	409	1	2016-03-17 09:19:04.94469
587	06010	2016-02-29 21:53:01.736444	Test	45	1	2016-03-17 09:19:04.94469
588	06010	2016-02-29 21:53:01.736444	Test	404	1	2016-03-17 09:19:04.94469
589	11010	2016-02-29 21:53:01.736444	Test	669	1	2016-03-17 09:19:04.94469
590	06010	2016-02-29 21:53:01.736444	Test	382	1	2016-03-17 09:19:04.94469
591	11010	2016-02-29 21:53:01.736444	Test	687	1	2016-03-17 09:19:04.94469
592	11010	2016-02-29 21:53:01.736444	Test	686	1	2016-03-17 09:19:04.94469
593	06010	2016-02-29 21:53:01.736444	Test	906	1	2016-03-17 09:19:04.94469
594	11010	2016-02-29 21:53:01.736444	Test	682	1	2016-03-17 09:19:04.94469
595	11010	2016-02-29 21:53:01.736444	Test	749	1	2016-03-17 09:19:04.94469
596	11010	2016-02-29 21:53:01.736444	Test	855	1	2016-03-17 09:19:04.94469
597	11010	2016-02-29 21:53:01.736444	Test	856	1	2016-03-17 09:19:04.94469
598	11010	2016-02-29 21:53:01.736444	Test	857	1	2016-03-17 09:19:04.94469
599	11010	2016-02-29 21:53:01.736444	Test	858	1	2016-03-17 09:19:04.94469
600	11010	2016-02-29 21:53:01.736444	Test	859	1	2016-03-17 09:19:04.94469
601	06010	2016-02-29 21:53:01.736444	Test	781	1	2016-03-17 09:19:04.94469
602	06010	2016-02-29 21:53:01.736444	Test	782	1	2016-03-17 09:19:04.94469
603	06010	2016-02-29 21:53:01.736444	Test	783	1	2016-03-17 09:19:04.94469
604	06010	2016-02-29 21:53:01.736444	Test	784	1	2016-03-17 09:19:04.94469
605	06010	2016-02-29 21:53:01.736444	Test	776	1	2016-03-17 09:19:04.94469
606	06010	2016-02-29 21:53:01.736444	Test	777	1	2016-03-17 09:19:04.94469
607	06010	2016-02-29 21:53:01.736444	Test	778	1	2016-03-17 09:19:04.94469
608	06010	2016-02-29 21:53:01.736444	Test	779	1	2016-03-17 09:19:04.94469
609	06010	2016-02-29 21:53:01.736444	Test	457	1	2016-03-17 09:19:04.94469
610	06010	2016-02-29 21:53:01.736444	Test	546	1	2016-03-17 09:19:04.94469
611	06010	2016-02-29 21:53:01.736444	Test	547	1	2016-03-17 09:19:04.94469
612	06010	2016-02-29 21:53:01.736444	Test	536	1	2016-03-17 09:19:04.94469
613	06010	2016-02-29 21:53:01.736444	Test	552	1	2016-03-17 09:19:04.94469
614	06010	2016-02-29 21:53:01.736444	Test	553	1	2016-03-17 09:19:04.94469
615	11010	2016-02-29 21:53:01.736444	Test	841	1	2016-03-17 09:19:04.94469
616	06010	2016-02-29 21:53:01.736444	Test	574	1	2016-03-17 09:19:04.94469
617	06060	2016-02-29 21:53:01.736444	Test	558	1	2016-03-17 09:19:04.94469
618	06060	2016-02-29 21:53:01.736444	Test	559	1	2016-03-17 09:19:04.94469
619	11010	2016-02-29 21:53:01.736444	Test	847	1	2016-03-17 09:19:04.94469
620	11010	2016-02-29 21:53:01.736444	Test	835	1	2016-03-17 09:19:04.94469
621	11010	2016-02-29 21:53:01.736444	Test	792	1	2016-03-17 09:19:04.94469
622	11010	2016-02-29 21:53:01.736444	Test	793	1	2016-03-17 09:19:04.94469
623	11010	2016-02-29 21:53:01.736444	Test	794	1	2016-03-17 09:19:04.94469
624	11010	2016-02-29 21:53:01.736444	Test	795	1	2016-03-17 09:19:04.94469
625	11010	2016-02-29 21:53:01.736444	Test	796	1	2016-03-17 09:19:04.94469
626	11010	2016-02-29 21:53:01.736444	Test	593	1	2016-03-17 09:19:04.94469
627	11010	2016-02-29 21:53:01.736444	Test	594	1	2016-03-17 09:19:04.94469
628	11010	2016-02-29 21:53:01.736444	Test	595	1	2016-03-17 09:19:04.94469
629	11010	2016-02-29 21:53:01.736444	Test	596	1	2016-03-17 09:19:04.94469
630	11010	2016-02-29 21:53:01.736444	Test	597	1	2016-03-17 09:19:04.94469
631	06010	2016-02-29 21:53:01.736444	Test	649	1	2016-03-17 09:19:04.94469
632	06010	2016-02-29 21:53:01.736444	Test	499	1	2016-03-17 09:19:04.94469
633	06010	2016-02-29 21:53:01.736444	Test	517	1	2016-03-17 09:19:04.94469
634	06010	2016-02-29 21:53:01.736444	Test	515	1	2016-03-17 09:19:04.94469
635	06010	2016-02-29 21:53:01.736444	Test	518	1	2016-03-17 09:19:04.94469
636	06010	2016-02-29 21:53:01.736444	Test	513	1	2016-03-17 09:19:04.94469
637	06010	2016-02-29 21:53:01.736444	Test	538	1	2016-03-17 09:19:04.94469
638	06010	2016-02-29 21:53:01.736444	Test	539	1	2016-03-17 09:19:04.94469
639	06010	2016-02-29 21:53:01.736444	Test	639	1	2016-03-17 09:19:04.94469
640	06010	2016-02-29 21:53:01.736444	Test	640	1	2016-03-17 09:19:04.94469
645	11010	2016-02-29 21:53:01.736444	Test	788	1	2016-03-17 09:19:04.94469
641	06010	2016-02-29 21:53:01.736444	Test	901	1	2016-03-17 09:19:04.94469
642	11010	2016-02-29 21:53:01.736444	Test	900	1	2016-03-17 09:19:04.94469
643	11010	2016-02-29 21:53:01.736444	Test	789	1	2016-03-17 09:19:04.94469
646	11010	2016-02-29 21:53:01.736444	Test	785	1	2016-03-17 09:19:04.94469
647	06060	2016-02-29 21:53:01.736444	Test	533	1	2016-03-17 09:19:04.94469
648	06010	2016-02-29 21:53:01.736444	Test	529	1	2016-03-17 09:19:04.94469
649	06010	2016-02-29 21:53:01.736444	Test	530	1	2016-03-17 09:19:04.94469
650	06010	2016-02-29 21:53:01.736444	Test	452	1	2016-03-17 09:19:04.94469
651	06010	2016-02-29 21:53:01.736444	Test	451	1	2016-03-17 09:19:04.94469
653	06060	2016-02-29 21:53:01.736444	Test	411	1	2016-03-17 09:19:04.94469
654	12020	2016-02-29 21:53:01.736444	Test	195	1	2016-03-17 09:19:04.94469
\.


ALTER TABLE status_protokoll ENABLE TRIGGER ALL;

SELECT setval(pg_get_serial_sequence('status_protokoll', 'id'),
    (SELECT max(id) FROM status_protokoll));


--
-- TOC entry 4696 (class 0 OID 1170904)
-- Dependencies: 298
-- Data for Name: zusatz_wert; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE zusatz_wert DISABLE TRIGGER ALL;

COPY zusatz_wert (id, probe_id, pzs_id, messwert_pzs, messfehler, letzte_aenderung, nwg_zu_messwert, tree_modified) FROM stdin;
1	84	A76	7.5	48	2012-04-23 12:32:56	\N	2016-03-17 09:19:04.94469
26	186	A78	0	0	2016-03-07 12:32:37	0	2016-03-17 09:19:04.94469
21	157	A78	0	2	2016-03-07 10:26:00	2	2016-03-17 09:19:04.94469
\.


ALTER TABLE zusatz_wert ENABLE TRIGGER ALL;

SELECT setval(pg_get_serial_sequence('zusatz_wert', 'id'),
    (SELECT max(id) FROM zusatz_wert));

--
-- PostgreSQL database dump complete
--
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)