view db_schema/lada_data.sql @ 987:35878d9b4321

Added unique constraint to result.query_id and result.data_index and fixed data set.
author Raimund Renkert <raimund.renkert@intevation.de>
date Wed, 29 Jun 2016 19:23:50 +0200
parents 807626952aa8
children ce1ec3cbde54 f51a9cf1d52c
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, 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;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
\.


ALTER TABLE probe ENABLE TRIGGER ALL;

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


ALTER TABLE messung ENABLE TRIGGER ALL;

--
-- 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, erzeuger, 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;

--
-- 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, erzeuger, 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;

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


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 4688 (class 0 OID 1170831)
-- Dependencies: 290
-- Data for Name: messung_translation; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE messung_translation DISABLE TRIGGER ALL;

COPY messung_translation (id, messungs_id, messungs_id_alt) FROM stdin;
45	45	1
179	179	1
195	195	1
198	198	1
382	382	1
404	404	1
409	409	1
411	411	1
451	451	1
452	452	1
455	455	1
457	457	1
499	499	1
513	513	1
515	515	1
517	517	1
518	518	1
529	529	1
530	530	2
533	533	1
536	536	1
538	538	2
539	539	1
546	546	2
547	547	1
552	552	1
553	553	2
558	558	2
559	559	1
574	574	1
593	593	1
594	594	3
595	595	4
596	596	2
597	597	5
604	604	1
639	639	2
640	640	1
646	646	1
649	649	1
669	669	1
677	677	1
679	679	1
682	682	1
686	686	1
687	687	1
693	693	1
697	697	1
699	699	1
749	749	1
764	764	1
765	765	2
776	776	1
777	777	2
778	778	4
779	779	3
781	781	3
782	782	1
783	783	4
784	784	2
785	785	1
788	788	1
789	789	1
792	792	1
793	793	4
794	794	3
795	795	2
796	796	5
835	835	1
841	841	1
847	847	1
855	855	1
856	856	4
857	857	2
858	858	3
859	859	5
876	876	1
877	877	2
900	900	1
901	901	1
906	906	1
907	907	1
\.


ALTER TABLE messung_translation ENABLE TRIGGER ALL;

--
-- TOC entry 4703 (class 0 OID 0)
-- Dependencies: 291
-- Name: messung_translation_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
--

SELECT pg_catalog.setval('messung_translation_id_seq', 1009, true);


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

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

--
-- TOC entry 4693 (class 0 OID 1170889)
-- Dependencies: 295
-- Data for Name: probe_translation; Type: TABLE DATA; Schema: land; Owner: postgres
--

ALTER TABLE probe_translation DISABLE TRIGGER ALL;

COPY probe_translation (id, probe_id, probe_id_alt) FROM stdin;
1	1	000007581034X
3	3	000007581040X
4	4	000007587554X
19	19	000007587671X
24	24	000007587691X
25	25	000007587696X
31	31	000007578204X
36	36	000007578214X
42	42	000007578227X
45	45	000007578239X
55	55	000007578259X
65	65	000007578279X
67	67	000007578283X
69	69	000007578287X
70	70	000007578289X
71	71	000007578291X
73	73	000007578295X
76	76	000007578301X
78	78	000007578303X
84	84	000007578312X
88	88	000007578316X
91	91	000007578319X
97	97	000007578331X
99	99	000007575726X
112	112	000007575752X
117	117	000007578031X
140	140	000007578082X
145	145	000007578087X
147	147	000007578141X
155	155	000007575767X
157	157	000007575772X
159	158	000007575778X
161	160	000007575783X
175	174	000007575807X
181	180	000007575819X
187	186	000007575831X
195	194	000007575847X
201	200	000007575856X
204	203	000007575864X
284	284	000007575917X
292	292	000007575939X
294	294	000007575941X
296	296	000007575943X
300	300	000007575949X
301	301	000007575950X
307	307	000007575960X
311	311	000007575967X
313	313	000007575969X
353	353	000007578188X
354	354	000007578191X
357	357	000007578195X
407	406	000007589328X
410	409	000007589343X
660	660	000007590041X
703	703	000007590316X
707	707	000007613597X
\.


ALTER TABLE probe_translation ENABLE TRIGGER ALL;

--
-- TOC entry 4704 (class 0 OID 0)
-- Dependencies: 296
-- Name: probe_translation_id_seq; Type: SEQUENCE SET; Schema: land; Owner: postgres
--

SELECT pg_catalog.setval('probe_translation_id_seq', 733, true);


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


ALTER TABLE status_protokoll ENABLE TRIGGER ALL;

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

SET search_path = bund, pg_catalog;

SELECT pg_catalog.setval('kommentar_id_seq', 661, true);

SELECT pg_catalog.setval('messung_id_seq', 1009, true);

SELECT pg_catalog.setval('messwert_id_seq', 6471, true);

SELECT pg_catalog.setval('ort_id_seq', 921, true);

SELECT pg_catalog.setval('probe_id_seq', 734, true);

SELECT pg_catalog.setval('zusatz_wert_id_seq', 30, true);

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