Source: https://svn.met.no/viewvc/kvoss/kvqc2d/branches/kvqc2d-1.1.3/
Significant Changes
All other details identical to kvqc2d-1.1.2.
The problem resolved is illustrated here in a test result:
Initial data:
66100 | 2011-05-05 06:00:00 | 5.8 | 110 | 2011-05-10 14:35:42.958498 | 402 | 0 | 0 | 5.8 | 0110000000001000 | 7000000000000000 |
66100 | 2011-05-06 06:00:00 | 0.9 | 110 | 2011-05-10 14:35:42.973629 | 402 | 0 | 0 | 0.9 | 0110000000001000 | 7000000000000000 |
66100 | 2011-05-07 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.323114 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-08 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.507621 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-09 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.568129 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-10 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.612785 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-11 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.687356 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-12 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.803361 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-13 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110b
66100 | 2011-05-14 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110b
66100 | 2011-05-15 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110b
66100 | 2011-05-16 06:00:00 | 27.1 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | 27.1 | 0140004000002000 | 7330900000000001 | QC1-7-110b
After kvqc2d-1.1.2 (old version): /scroll to the right to see the problem/
66100 | 2011-05-05 06:00:00 | 5.8 | 110 | 2011-05-10 14:35:42.958498 | 402 | 0 | 0 | 5.8 | 0110000000001000 | 7000000000000000 |
66100 | 2011-05-06 06:00:00 | 0.9 | 110 | 2011-05-10 14:35:42.973629 | 402 | 0 | 0 | 0.9 | 0110000000001000 | 7000000000000000 |
66100 | 2011-05-07 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.323114 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-08 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.507621 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-09 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.568129 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-10 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.612785 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-11 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.687356 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-12 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.803361 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-13 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | 9.3 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_66070_65270_65230_64900_68270,QC2-redist
66100 | 2011-05-14 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | 4.4 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_66070_65270_67150_65230_64900_68270,QC2-redist
66100 | 2011-05-15 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | 7.5 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_66070_65270_67150_65230_64900_68270,QC2-redist
66100 | 2011-05-16 06:00:00 | 27.1 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | 6 | 0140004000007000 | 5336900000000001 | QC1-2-72.c12,QC1-7-110b,QC2N_66070_65270_67150_65230_64900_68270,QC2-redist
After kvqc2d-1.1.3 (this version) the data series with incorrect fd flags is ignored:
66100 | 2011-05-05 06:00:00 | 5.8 | 110 | 2011-05-10 14:35:42.958498 | 402 | 0 | 0 | 5.8 | 0110000000001000 | 7000000000000000 |
66100 | 2011-05-06 06:00:00 | 0.9 | 110 | 2011-05-10 14:35:42.973629 | 402 | 0 | 0 | 0.9 | 0110000000001000 | 7000000000000000 |
66100 | 2011-05-07 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.323114 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-08 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.507621 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-09 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.568129 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-10 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.612785 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-11 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.687356 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-12 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18.803361 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-13 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110b
66100 | 2011-05-14 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110b
66100 | 2011-05-15 06:00:00 | -32767 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110b
66100 | 2011-05-16 06:00:00 | 27.1 | 110 | 2011-05-24 19:21:18 | 402 | 0 | 0 | 27.1 | 0140004000002000 | 7330900000000001 | QC1-7-110b
NB This is an extra check. The underlying problem in kvalobs that leads to an fd 0 0 0 2 2 2 sequence is to be resolved.
Another example where a good sequence is redistributed and the next anomalous sequence is ignored:
66100 | 2011-05-19 06:00:00 | 3 | 110 | 2011-05-24 19:21:18.953294 | 402 | 0 | 0 | 3 | 0110000000001000 | 7000000000000000 |
66100 | 2011-05-20 06:00:00 | 0.1 | 110 | 2011-05-24 19:21:18.963215 | 402 | 0 | 0 | 0.1 | 0110000000001000 | 7000000000000000 |
66100 | 2011-05-21 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23 | 402 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_66070_65270_67150_65230_68270,QC2-redist
66100 | 2011-05-22 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23 | 402 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_66070_65270_67150_65230_68270,QC2-redist
66100 | 2011-05-23 06:00:00 | -1 | 110 | 2011-06-05 21:13:23 | 402 | 0 | 0 | -1 | 0110004000007000 | 5336900000000000 | QC1-7-110b,QC2N_66070_65270_67150_65230_68270,QC2-redist
66100 | 2011-05-24 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23.629222 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-25 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23.63351 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-26 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23.637654 | 402 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110b
66100 | 2011-05-27 06:00:00 | 13.5 | 110 | 2011-06-05 21:13:23.642076 | 402 | 0 | 0 | 13.5 | 0140004000002000 | 7330900000000001 | QC1-2-72.c12,QC1-7-110b
Extracts from the log file:
First entry in the log file for 2011-06-16:
2011-06-16 01:20:35 INFO -------------------- Case Redistribute 2011-06-16 01:20:35 INFO -------------------- Redistribute Accumulations 2011-06-16 01:22:44 INFO -------------------- Redistribution: 54320 2011-6-4 6:0:0 -32767 110 302 0 0 0.7 2011-06-16 01:22:47 INFO -------------------- Redistribution: 54320 2011-6-5 6:0:0 -32767 110 302 0 0 -1 2011-06-16 01:22:49 INFO -------------------- Redistribution: 54320 2011-6-6 6:0:0 -32767 110 302 0 0 -1 ...
(1)grep for the rest, and then need to (2)check what happened immediately before and after …
| 1 |
|---|
-------------------- Redistribute Accumulations -------------------- Redistribution: 54320 2011-6-4 6:0:0 -32767 110 302 0 0 0.7 -------------------- Redistribution: 54320 2011-6-5 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 54320 2011-6-6 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 54320 2011-6-7 6:0:0 -32767 110 302 0 0 6.2 -------------------- Redistribution: 54320 2011-6-8 6:0:0 -32767 110 302 0 0 2.5 -------------------- Redistribution: 54320 2011-6-9 6:0:0 -32767 110 302 0 0 5.8 -------------------- Redistribution: 54320 2011-6-10 6:0:0 31.1 110 302 0 0 15.9 -------------------- Redistribution: 55550 2011-6-8 6:0:0 -32767 110 302 0 0 8.5 -------------------- Redistribution: 55550 2011-6-9 6:0:0 -32767 110 302 0 0 5.9 -------------------- Redistribution: 55550 2011-6-10 6:0:0 -32767 110 302 0 0 25.8 -------------------- Redistribution: 55550 2011-6-11 6:0:0 66.2 110 302 0 0 26 -------------------- Redistribution: 53730 2011-6-10 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 53730 2011-6-11 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 53730 2011-6-12 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 53730 2011-6-13 6:0:0 0 110 302 0 0 -1 -------------------- Redistribution: 54780 2011-6-11 6:0:0 -32767 110 302 0 0 31.7 -------------------- Redistribution: 54780 2011-6-12 6:0:0 -32767 110 302 0 0 6.6 -------------------- Redistribution: 54780 2011-6-13 6:0:0 38.3 110 302 0 0 -1 -------------------- Redistribution: 22951 2011-6-9 6:0:0 -32767 110 302 0 0 11.8 -------------------- Redistribution: 22951 2011-6-10 6:0:0 -32767 110 302 0 0 19.8 -------------------- Redistribution: 22951 2011-6-11 6:0:0 -32767 110 302 0 0 36.1 -------------------- Redistribution: 22951 2011-6-12 6:0:0 -32767 110 302 0 0 8.4 -------------------- Redistribution: 22951 2011-6-13 6:0:0 76.1 110 302 0 0 -1 -------------------- Redistribution: 53950 2011-6-10 6:0:0 -32767 110 302 0 0 13.3 -------------------- Redistribution: 53950 2011-6-11 6:0:0 -32767 110 302 0 0 19.2 -------------------- Redistribution: 53950 2011-6-12 6:0:0 -32767 110 302 0 0 4.1 -------------------- Redistribution: 53950 2011-6-13 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 53950 2011-6-14 6:0:0 38.5 110 302 0 0 1.9 -------------------- Redistribution: 17780 2011-6-9 6:0:0 -32767 110 302 0 0 4.3 -------------------- Redistribution: 17780 2011-6-10 6:0:0 -32767 110 302 0 0 14.4 -------------------- Redistribution: 17780 2011-6-11 6:0:0 -32767 110 302 0 0 27.6 -------------------- Redistribution: 17780 2011-6-12 6:0:0 -32767 110 302 0 0 4.7 -------------------- Redistribution: 17780 2011-6-13 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 17780 2011-6-14 6:0:0 54 110 302 0 0 3.1 -------------------- Redistribution: 94130 2011-6-4 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-5 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-6 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-7 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-8 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-9 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-10 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-11 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-12 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-13 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 94130 2011-6-14 6:0:0 -1 110 302 0 0 -1 -------------------- Redistribution: 55930 2011-6-11 6:0:0 -32767 110 302 0 0 9.9 -------------------- Redistribution: 55930 2011-6-12 6:0:0 -32767 110 302 0 0 4.8 -------------------- Redistribution: 55930 2011-6-13 6:0:0 -32767 110 302 0 0 0.6 -------------------- Redistribution: 55930 2011-6-14 6:0:0 18.2 110 302 0 0 2.9 -------------------- Redistribution: 64320 2011-6-11 6:0:0 -32767 110 302 0 0 4.6 -------------------- Redistribution: 64320 2011-6-12 6:0:0 -32767 110 302 0 0 0.4 -------------------- Redistribution: 64320 2011-6-13 6:0:0 -32767 110 302 0 0 4.6 -------------------- Redistribution: 64320 2011-6-14 6:0:0 9.7 110 302 0 0 -1 -------------------- Redistribution: 54420 2011-6-10 6:0:0 -32767 110 302 0 0 34.5 -------------------- Redistribution: 54420 2011-6-11 6:0:0 -32767 110 302 0 0 49.1 -------------------- Redistribution: 54420 2011-6-12 6:0:0 -32767 110 302 0 0 16.5 -------------------- Redistribution: 54420 2011-6-13 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 54420 2011-6-14 6:0:0 -32767 110 302 0 0 1.9 -------------------- Redistribution: 54420 2011-6-15 6:0:0 104 110 302 0 0 2 -------------------- Redistribute Completed
| 2 |
|---|
Note: the window checked was 14 days running backwards from 2011-06-16. Therefore any corrections prior to 2011-06-02 are due to older versions of the algorithm where errors may have occurred.
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=54320;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------------------------------------------------
54320 | 2011-06-01 06:00:00 | -32767 | 110 | 2011-06-02 00:32:15 | 302 | 0 | 0 | 3.6 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_54780_53950_53730_23720_25100_53130,QC2-redist
54320 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:32:26 | 302 | 0 | 0 | 1.4 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_23720_25100_53130,QC2-redist
54320 | 2011-06-03 06:00:00 | 5 | 110 | 2011-06-03 08:27:15 | 302 | 0 | 0 | -1 | 0140004000002006 | 33359000000000C1 | QC1-2-72.b12,QC1-7-110,QC2N_23720_55550_25100_53130_25260,QC2-redist,hqc
54320 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:33:20 | 302 | 0 | 0 | 0.7 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53700_23720_55550_25100_53130,QC2-redist
54320 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:31:54 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53700_23720_55550_25100_53130,QC2-redist
54320 | 2011-06-06 06:00:00 | -32767 | 110 | 2011-06-07 00:31:17 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53700_23720_55550_25100_53130,QC2-redist
54320 | 2011-06-07 06:00:00 | -32767 | 110 | 2011-06-08 00:30:14 | 302 | 0 | 0 | 6.2 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_54780_53950_53730_23720_55550_25100_53130,QC2-redist
54320 | 2011-06-08 06:00:00 | -32767 | 110 | 2011-06-09 00:30:30 | 302 | 0 | 0 | 2.5 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_54780_53950_53730_53700_23720_25100_53130_25260,QC2-redist
54320 | 2011-06-09 06:00:00 | -32767 | 110 | 2011-06-10 00:31:19 | 302 | 0 | 0 | 5.8 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_54780_53950_53730_53700_23720_25100_53130,QC2-redist
54320 | 2011-06-10 06:00:00 | 31.1 | 110 | 2011-06-10 08:36:23 | 302 | 0 | 0 | 15.9 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_54780_23720_25100_53130,QC2-redist
54320 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:32:27 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
54320 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:32:08 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
54320 | 2011-06-13 06:00:00 | -32767 | 110 | 2011-06-14 00:31:46 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
54320 | 2011-06-14 06:00:00 | -32767 | 110 | 2011-06-15 00:30:08 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
54320 | 2011-06-15 06:00:00 | -32767 | 110 | 2011-06-16 00:46:12 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
(15 rows)
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=55550;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------------------------------------------------
55550 | 2011-06-01 06:00:00 | -32767 | 110 | 2011-06-02 00:32:04 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
55550 | 2011-06-02 06:00:00 | 12.2 | 110 | 2011-06-02 08:31:41.630344 | 302 | 0 | 0 | 12.2 | 0140004000002000 | 7330900000000001 | QC1-2-72.b12,QC1-7-110
55550 | 2011-06-03 06:00:00 | -1 | 110 | 2011-06-04 11:04:16.908299 | 302 | 0 | 0 | -1 | 0110000000001000 | 7000000000000000 |
55550 | 2011-06-04 06:00:00 | 2.6 | 110 | 2011-06-04 11:04:16.195367 | 302 | 0 | 0 | 2.6 | 0110000000001000 | 7000000000000000 |
55550 | 2011-06-05 06:00:00 | -1 | 110 | 2011-06-05 09:08:07.505407 | 302 | 0 | 0 | -1 | 0110000000001000 | 7000000000000000 |
55550 | 2011-06-06 06:00:00 | -1 | 110 | 2011-06-06 06:42:27.888803 | 302 | 0 | 0 | -1 | 0110000000001000 | 7000000000000000 |
55550 | 2011-06-07 06:00:00 | 16.3 | 110 | 2011-06-07 18:55:51.536667 | 302 | 0 | 0 | 16.3 | 0110000000001000 | 7000000000000000 |
55550 | 2011-06-08 06:00:00 | -32767 | 110 | 2011-06-09 00:30:54 | 302 | 0 | 0 | 8.5 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_54780_55930_53070_53700_56960_57390_53730,QC2-redist
55550 | 2011-06-09 06:00:00 | -32767 | 110 | 2011-06-10 00:31:05 | 302 | 0 | 0 | 5.9 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_54780_55930_53070_53700_56960_57390_53730,QC2-redist
55550 | 2011-06-10 06:00:00 | -32767 | 110 | 2011-06-11 00:30:53 | 302 | 0 | 0 | 25.8 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_54780_55930_53070_56960_57390,QC2-redist
55550 | 2011-06-11 06:00:00 | 66.2 | 110 | 2011-06-11 11:34:25 | 302 | 0 | 0 | 26 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_53130_53070_53700_56960_57390,QC2-redist
55550 | 2011-06-12 06:00:00 | 9.3 | 110 | 2011-06-12 18:25:30.941345 | 302 | 0 | 0 | 9.3 | 0110000000001000 | 7000000000000000 |
55550 | 2011-06-13 06:00:00 | -1 | 110 | 2011-06-13 10:27:21.10707 | 302 | 0 | 0 | -1 | 0110000000001000 | 7000000000000000 |
55550 | 2011-06-14 06:00:00 | 0.3 | 110 | 2011-06-14 16:20:44.391221 | 302 | 0 | 0 | 0.3 | 0110000000001000 | 7000000000000000 |
55550 | 2011-06-15 06:00:00 | -32767 | 110 | 2011-06-16 00:46:23 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
(15 rows)
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=53730;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------------------------------------
53730 | 2011-06-01 06:00:00 | 4 | 110 | 2011-06-01 09:56:54 | 302 | 0 | 0 | 4 | 0140000000001001 | 30000000000000C1 | QC1-2-72.b12,hqc
53730 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:32:11 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
53730 | 2011-06-03 06:00:00 | 5.5 | 110 | 2011-06-06 05:56:09.122376 | 302 | 0 | 0 | 5.5 | 0140004000002000 | 7330900000000001 | QC1-2-72.b12,QC1-7-110
53730 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:33:08 | 302 | 0 | 0 | 0.5 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_53160_49631_53070_55550,QC2-redist
53730 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:32:16 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_53160_49631_53070_55550,QC2-redist
53730 | 2011-06-06 06:00:00 | 0.5 | 110 | 2011-06-06 12:35:29 | 302 | 0 | 0 | -1 | 0000004000000000 | 53369000000000C1 |
53730 | 2011-06-07 06:00:00 | 1.5 | 110 | 2011-06-08 10:08:05.119014 | 302 | 0 | 0 | 1.5 | 0140000000001000 | 7020400000000001 | QC1-2-72.b12
53730 | 2011-06-08 06:00:00 | 2.5 | 110 | 2011-06-08 10:10:33.550992 | 302 | 0 | 0 | 2.5 | 0140000000001000 | 7020400000000001 | QC1-2-72.b12
53730 | 2011-06-09 06:00:00 | 9.5 | 110 | 2011-06-09 11:46:07 | 302 | 0 | 0 | 9.5 | 0140000000001001 | 30000000000000C1 | QC1-2-72.b12,hqc
53730 | 2011-06-10 06:00:00 | -32767 | 110 | 2011-06-11 00:30:46 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_53160_49631_53070,QC2-redist
53730 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:32:41 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53700_53130_53160_49631_53070,QC2-redist
53730 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:31:46 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_53160_49631_53070_55550,QC2-redist
53730 | 2011-06-13 06:00:00 | 0 | 110 | 2011-06-15 12:11:41 | 302 | 0 | 0 | -1 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_53160_49631_53070_55550,QC2-redist
53730 | 2011-06-14 06:00:00 | 33.5 | 110 | 2011-06-14 11:56:33.883809 | 302 | 0 | 0 | 33.5 | 0140000000000000 | 7020400000000001 | QC1-2-72.b12
53730 | 2011-06-15 06:00:00 | 4.5 | 110 | 2011-06-15 12:11:40.487721 | 302 | 0 | 0 | 4.5 | 0140000000001000 | 7020400000000001 | QC1-2-72.b12
(15 rows)
kvalobs=#
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=54780;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------
54780 | 2011-06-01 06:00:00 | 2.5 | 110 | 2011-06-01 08:53:13.650483 | 302 | 0 | 0 | 2.5 | 0110000000001000 | 7000000000000000 |
54780 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:32:21 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54780 | 2011-06-03 06:00:00 | -32767 | 110 | 2011-06-04 00:32:38 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54780 | 2011-06-04 06:00:00 | 10.5 | 110 | 2011-06-06 07:42:13.382283 | 302 | 0 | 0 | 10.5 | 0110004000002000 | 7330900000000000 | QC1-7-110
54780 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:32:36 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54780 | 2011-06-06 06:00:00 | -1 | 110 | 2011-06-06 07:42:12.395496 | 302 | 0 | 0 | -1 | 0110000000002000 | 7330900000000000 | QC1-7-110
54780 | 2011-06-07 06:00:00 | 6.5 | 110 | 2011-06-07 06:51:45.406395 | 302 | 0 | 0 | 6.5 | 0110000000001000 | 7000000000000000 |
54780 | 2011-06-08 06:00:00 | 0.4 | 110 | 2011-06-08 05:59:02.770386 | 302 | 0 | 0 | 0.4 | 0110000000001000 | 7000000000000000 |
54780 | 2011-06-09 06:00:00 | 2.6 | 110 | 2011-06-09 06:27:30.380257 | 302 | 0 | 0 | 2.6 | 0110000000001000 | 7000000000000000 |
54780 | 2011-06-10 06:00:00 | 21 | 110 | 2011-06-10 06:35:08.247577 | 302 | 0 | 0 | 21 | 0110000000001000 | 7000000000000000 |
54780 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:33:15 | 302 | 0 | 0 | 31.7 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_23720,QC2-redist
54780 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:32:18 | 302 | 0 | 0 | 6.6 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_55550,QC2-redist
54780 | 2011-06-13 06:00:00 | 38.3 | 110 | 2011-06-14 06:14:07 | 302 | 0 | 0 | -1 | 0110004000007000 | 5336900000000000 | QC1-7-110,QC2N_55550,QC2-redist
54780 | 2011-06-14 06:00:00 | 0.2 | 110 | 2011-06-14 06:14:07.165162 | 302 | 0 | 0 | 0.2 | 0110000000001000 | 7000000000000000 |
54780 | 2011-06-15 06:00:00 | 3 | 110 | 2011-06-15 06:26:02.377816 | 302 | 0 | 0 | 3 | 0110000000001000 | 7000000000000000 |
(15 rows)
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=22951;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------------------------------
22951 | 2011-06-01 06:00:00 | -32767 | 110 | 2011-06-02 00:30:03 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
22951 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:30:37 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
22951 | 2011-06-03 06:00:00 | -32767 | 110 | 2011-06-04 00:30:49 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
22951 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:30:53 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
22951 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:30:43 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
22951 | 2011-06-06 06:00:00 | -32767 | 110 | 2011-06-07 00:30:26 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
22951 | 2011-06-07 06:00:00 | -32767 | 110 | 2011-06-08 00:30:02 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
22951 | 2011-06-08 06:00:00 | 25.1 | 110 | 2011-06-08 05:04:28.630255 | 302 | 0 | 0 | 25.1 | 0140004000002000 | 7330900000000001 | QC1-2-72.b12,QC1-7-110
22951 | 2011-06-09 06:00:00 | -32767 | 110 | 2011-06-10 00:30:03 | 302 | 0 | 0 | 11.8 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-10 06:00:00 | -32767 | 110 | 2011-06-11 00:30:02 | 302 | 0 | 0 | 19.8 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:30:07 | 302 | 0 | 0 | 36.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:30:43 | 302 | 0 | 0 | 8.4 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-13 06:00:00 | 76.1 | 110 | 2011-06-13 09:25:48 | 302 | 0 | 0 | -1 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-14 06:00:00 | -32767 | 110 | 2011-06-15 00:30:03 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
22951 | 2011-06-15 06:00:00 | -32767 | 110 | 2011-06-16 00:44:33 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
(15 rows)
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=53950;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------------------------------
53950 | 2011-06-01 06:00:00 | 2.8 | 110 | 2011-06-01 09:56:54 | 302 | 0 | 0 | 2.8 | 0140000000001001 | 30000000000000C1 | QC1-2-72.b12,hqc
53950 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:32:26 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
53950 | 2011-06-03 06:00:00 | 2.5 | 110 | 2011-06-06 05:56:11.86727 | 302 | 0 | 0 | 2.5 | 0140004000002000 | 7330900000000001 | QC1-2-72.b12,QC1-7-110
53950 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:32:58 | 302 | 0 | 0 | 0.9 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_49631_53160,QC2-redist
53950 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:32:16 | 302 | 0 | 0 | 0.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_49631_53160,QC2-redist
53950 | 2011-06-06 06:00:00 | 1 | 110 | 2011-06-06 12:35:30 | 302 | 0 | 0 | -1 | 0000004000000000 | 53369000000000C1 |
53950 | 2011-06-07 06:00:00 | 4 | 110 | 2011-06-08 10:08:02.41781 | 302 | 0 | 0 | 4 | 0140000000001000 | 7020400000000001 | QC1-2-72.b12
53950 | 2011-06-08 06:00:00 | 6.5 | 110 | 2011-06-08 10:08:05.82013 | 302 | 0 | 0 | 6.5 | 0140000000001000 | 7020400000000001 | QC1-2-72.b12
53950 | 2011-06-09 06:00:00 | 15 | 110 | 2011-06-09 11:46:07 | 302 | 0 | 0 | 15 | 0140000000001001 | 30000000000000C1 | QC1-2-72.b12,hqc
53950 | 2011-06-10 06:00:00 | -32767 | 110 | 2011-06-11 00:31:03 | 302 | 0 | 0 | 13.3 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53130_49631_53160,QC2-redist
53950 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:32:27 | 302 | 0 | 0 | 19.2 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53700_25260_53130_49631_53160,QC2-redist
53950 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:32:18 | 302 | 0 | 0 | 4.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25260_53130_49631_53160,QC2-redist
53950 | 2011-06-13 06:00:00 | -32767 | 110 | 2011-06-14 00:31:32 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_49631_53160,QC2-redist
53950 | 2011-06-14 06:00:00 | 38.5 | 110 | 2011-06-14 11:56:21 | 302 | 0 | 0 | 1.9 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_49631_53160,QC2-redist
53950 | 2011-06-15 06:00:00 | 2.5 | 110 | 2011-06-15 12:11:39.116458 | 302 | 0 | 0 | 2.5 | 0140000000001000 | 7020400000000001 | QC1-2-72.b12
(15 rows)
kvalobs=#
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=17780;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------------------
17780 | 2011-06-01 06:00:00 | -32767 | 110 | 2011-06-02 00:30:03 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
17780 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:30:58 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
17780 | 2011-06-03 06:00:00 | -32767 | 110 | 2011-06-04 00:31:00 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
17780 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:31:04 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
17780 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:30:59 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
17780 | 2011-06-06 06:00:00 | -32767 | 110 | 2011-06-07 00:30:50 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
17780 | 2011-06-07 06:00:00 | -32767 | 110 | 2011-06-08 00:30:02 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
17780 | 2011-06-08 06:00:00 | 10 | 110 | 2011-06-08 05:51:02.576696 | 302 | 0 | 0 | 10 | 0140004000002000 | 7330900000000001 | QC1-2-72.b12,QC1-7-110
17780 | 2011-06-09 06:00:00 | -32767 | 110 | 2011-06-10 00:30:04 | 302 | 0 | 0 | 4.3 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_18160_4040_17251_4740,QC2-redist
17780 | 2011-06-10 06:00:00 | -32767 | 110 | 2011-06-11 00:30:02 | 302 | 0 | 0 | 14.4 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_18160_4040_17251_4740,QC2-redist
17780 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:30:07 | 302 | 0 | 0 | 27.6 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_18160_4040_4740,QC2-redist
17780 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:30:02 | 302 | 0 | 0 | 4.7 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_4040_17251_4740,QC2-redist
17780 | 2011-06-13 06:00:00 | -32767 | 110 | 2011-06-14 00:30:41 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_4040_17251_4740,QC2-redist
17780 | 2011-06-14 06:00:00 | 54 | 110 | 2011-06-14 09:57:48 | 302 | 0 | 0 | 3.1 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_4040_17251_4740,QC2-redist
17780 | 2011-06-15 06:00:00 | -32767 | 110 | 2011-06-16 00:45:14 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
(15 rows)
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=94130;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------
94130 | 2011-06-01 06:00:00 | 0 | 110 | 2011-06-01 06:49:05.719486 | 302 | 0 | 0 | 0 | 0110000000001000 | 7000000000000000 |
94130 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:34:35 | 302 | 0 | 0 | -32767 | 0000003000003000 | 7899900000000000 | QC1-7-110
94130 | 2011-06-03 06:00:00 | -1 | 110 | 2011-06-03 06:42:52.6536 | 302 | 0 | 0 | -1 | 0110000000003000 | 7220900000000000 | QC1-7-110
94130 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:35:37 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:33:59 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-06 06:00:00 | -32767 | 110 | 2011-06-07 00:32:34 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-07 06:00:00 | -32767 | 110 | 2011-06-08 00:30:25 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-08 06:00:00 | -32767 | 110 | 2011-06-09 00:32:31 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-09 06:00:00 | -32767 | 110 | 2011-06-10 00:32:06 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-10 06:00:00 | -32767 | 110 | 2011-06-11 00:32:52 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:35:31 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:34:27 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-13 06:00:00 | -32767 | 110 | 2011-06-14 00:33:47 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-14 06:00:00 | -1 | 110 | 2011-06-14 06:26:00 | 302 | 0 | 0 | -1 | 0110004000007000 | 5336900000000000 | QC1-7-110,QC2N_94170,QC2-redist
94130 | 2011-06-15 06:00:00 | -1 | 110 | 2011-06-15 06:27:24.604715 | 302 | 0 | 0 | -1 | 0110000000001000 | 7000000000000000 |
(15 rows)
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=55930;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------------------------------------------------------------------
55930 | 2011-06-01 06:00:00 | 0.5 | 110 | 2011-06-01 05:55:51.567429 | 302 | 0 | 0 | 0.5 | 0110000000003000 | 7220900000000000 | QC1-7-110
55930 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:32:37 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
55930 | 2011-06-03 06:00:00 | 21 | 110 | 2011-06-03 05:49:48.53551 | 302 | 0 | 0 | 21 | 0110004000002000 | 7330900000000000 | QC1-7-110
55930 | 2011-06-04 06:00:00 | -1 | 110 | 2011-06-08 05:55:47.29971 | 302 | 0 | 0 | -1 | 0110000000001000 | 7000000000000000 |
55930 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:32:44 | 302 | 0 | 0 | -32767 | 0000003000003000 | 7899900000000000 | QC1-7-110,QC1-7-110
55930 | 2011-06-06 06:00:00 | 3.2 | 110 | 2011-06-08 05:55:47.914735 | 302 | 0 | 0 | 3.2 | 0110004000002000 | 7330900000000000 | QC1-7-110
55930 | 2011-06-07 06:00:00 | 24 | 110 | 2011-06-08 05:55:47.860146 | 302 | 0 | 0 | 24 | 0110000000001000 | 7000000000000000 |
55930 | 2011-06-08 06:00:00 | 3.2 | 110 | 2011-06-08 05:55:47.846445 | 302 | 0 | 0 | 3.2 | 0110000000001000 | 7000000000000000 |
55930 | 2011-06-09 06:00:00 | 2.9 | 110 | 2011-06-10 09:39:33.15637 | 302 | 0 | 0 | 2.9 | 0110000000001000 | 7000000000000000 |
55930 | 2011-06-10 06:00:00 | 13.8 | 110 | 2011-06-10 09:39:33.36484 | 302 | 0 | 0 | 13.8 | 0110000000001000 | 7000000000000000 |
55930 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:33:03 | 302 | 0 | 0 | 9.9 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53070_56850_52990_56960_53130_53160_57390_52220_57480_52170_53700,QC2-redist
55930 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:32:08 | 302 | 0 | 0 | 4.8 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53070_56850_52990_56960_53130_53160_55550_57390_52220_57480_52170,QC2-redist
55930 | 2011-06-13 06:00:00 | -32767 | 110 | 2011-06-14 00:32:17 | 302 | 0 | 0 | 0.6 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_53070_56850_52990_56960_53160_55550_57390_52220_57480_52170,QC2-redist
55930 | 2011-06-14 06:00:00 | 18.2 | 110 | 2011-06-14 05:42:14 | 302 | 0 | 0 | 2.9 | 0110004000007000 | 5336900000000000 | QC1-7-110,QC2N_56850_52990_56960_53160_55550_57390_52220_57480_52170,QC2-redist
55930 | 2011-06-15 06:00:00 | 10.5 | 110 | 2011-06-15 05:48:10.200862 | 302 | 0 | 0 | 10.5 | 0110000000001000 | 7000000000000000 |
(15 rows)
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=64320;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------------------
64320 | 2011-06-01 06:00:00 | -1 | 110 | 2011-06-01 05:10:32.948208 | 302 | 0 | 0 | -1 | 0110000000001000 | 7000000000000000 |
64320 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:33:14 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
64320 | 2011-06-03 06:00:00 | 3.1 | 110 | 2011-06-03 05:10:35.525833 | 302 | 0 | 0 | 3.1 | 0140004000002000 | 7330900000000001 | QC1-2-72.b12,QC1-7-110
64320 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:34:00 | 302 | 0 | 0 | -32767 | 0000003000003000 | 7899900000000000 | QC1-7-110
64320 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:32:53 | 302 | 0 | 0 | -32767 | 0000003000003000 | 7899900000000000 | QC1-7-110
64320 | 2011-06-06 06:00:00 | -32767 | 110 | 2011-06-07 00:32:24 | 302 | 0 | 0 | 5.1 | 0000001000003005 | 38929000000000C0 | QC1-7-110,watchRR
64320 | 2011-06-07 06:00:00 | 2.6 | 110 | 2011-06-07 05:36:31 | 302 | 0 | 0 | 2.6 | 0140000000001001 | 30000000000000C1 | QC1-2-72.b12,QC1-7-110,hqc
64320 | 2011-06-08 06:00:00 | 2.9 | 110 | 2011-06-08 05:12:01.125103 | 302 | 0 | 0 | 2.9 | 0110000000001000 | 7000000000000000 |
64320 | 2011-06-09 06:00:00 | -1 | 110 | 2011-06-09 05:25:52.300792 | 302 | 0 | 0 | -1 | 0110000000001000 | 7000000000000000 |
64320 | 2011-06-10 06:00:00 | 14.5 | 110 | 2011-06-10 05:38:01.426832 | 302 | 0 | 0 | 14.5 | 0110000000001000 | 7000000000000000 |
64320 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:33:32 | 302 | 0 | 0 | 4.6 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_62900,QC2-redist
64320 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:32:28 | 302 | 0 | 0 | 0.4 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_62900,QC2-redist
64320 | 2011-06-13 06:00:00 | -32767 | 110 | 2011-06-14 00:32:07 | 302 | 0 | 0 | 4.6 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_62900,QC2-redist
64320 | 2011-06-14 06:00:00 | 9.7 | 110 | 2011-06-14 05:06:24 | 302 | 0 | 0 | -1 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_62900,QC2-redist
64320 | 2011-06-15 06:00:00 | 2.7 | 110 | 2011-06-15 06:02:55.861245 | 302 | 0 | 0 | 2.7 | 0110000000001000 | 7000000000000000 |
(15 rows)
kvalobs=# select * from data where obstime between '2011-06-01' and '2011-06-16' and paramid=110 and stationid=54420;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+--------------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------------------------------------------------
54420 | 2011-06-01 06:00:00 | 7.5 | 110 | 2011-06-01 07:48:10 | 302 | 0 | 0 | 1.9 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_25100_23720_53950_54780_53730_25320,QC2-redist
54420 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:32:21 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54420 | 2011-06-03 06:00:00 | -32767 | 110 | 2011-06-04 00:32:38 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54420 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:33:40 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54420 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:32:05 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54420 | 2011-06-06 06:00:00 | -32767 | 110 | 2011-06-07 00:31:36 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54420 | 2011-06-07 06:00:00 | -32767 | 110 | 2011-06-08 00:30:19 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54420 | 2011-06-08 06:00:00 | -32767 | 110 | 2011-06-09 00:31:01 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54420 | 2011-06-09 06:00:00 | 28 | 110 | 2011-06-09 07:41:20.4187 | 302 | 0 | 0 | 28 | 0140004000002000 | 7330900000000001 | QC1-2-72.b12,QC1-7-110
54420 | 2011-06-10 06:00:00 | -32767 | 110 | 2011-06-11 00:31:03 | 302 | 0 | 0 | 34.5 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25100_23720_54780_25320,QC2-redist
54420 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:32:52 | 302 | 0 | 0 | 49.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25100_23720_25260_25320_53700,QC2-redist
54420 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:32:28 | 302 | 0 | 0 | 16.5 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25100_25260_25320,QC2-redist
54420 | 2011-06-13 06:00:00 | -32767 | 110 | 2011-06-14 00:32:17 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25100_25320,QC2-redist
54420 | 2011-06-14 06:00:00 | -32767 | 110 | 2011-06-15 00:30:08 | 302 | 0 | 0 | 1.9 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_54780_25320,QC2-redist
54420 | 2011-06-15 06:00:00 | 104 | 110 | 2011-06-15 07:48:01 | 302 | 0 | 0 | 2 | 0240004000007000 | 5336900000000002 | QC1-1-110,QC1-2-72.b12,QC1-7-110,QC2N_25100_53950_54780_25260_53730_25320,QC2-redist
(15 rows)
Logfile:
2011-06-17 01:20:42 INFO -------------------- Redistribute Accumulations 2011-06-17 01:22:05 INFO -------------------- Redistribution: 66100 2011-5-21 6:0:0 -32767 110 402 0 0 -1 -------------------- Redistribution: 66100 2011-5-22 6:0:0 -32767 110 402 0 0 -1 -------------------- Redistribution: 66100 2011-5-23 6:0:0 -1 110 402 0 0 -1 -------------------- Redistribution: 3200 2011-5-20 6:0:0 -32767 110 402 0 0 -1 -------------------- Redistribution: 3200 2011-5-21 6:0:0 -32767 110 402 0 0 -1 -------------------- Redistribution: 3200 2011-5-22 6:0:0 -32767 110 402 0 0 -1 -------------------- Redistribution: 3200 2011-5-23 6:0:0 5.5 110 402 0 0 5.5 -------------------- Redistribution: 15480 2011-5-24 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 15480 2011-5-25 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 15480 2011-5-26 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 15480 2011-5-27 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 15480 2011-5-28 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 15480 2011-5-29 6:0:0 0 110 302 0 0 -1 -------------------- Redistribution: 85440 2011-5-24 6:0:0 -32767 110 302 0 0 18.9 -------------------- Redistribution: 85440 2011-5-25 6:0:0 -32767 110 302 0 0 10.3 -------------------- Redistribution: 85440 2011-5-26 6:0:0 -32767 110 302 0 0 13.4 -------------------- Redistribution: 85440 2011-5-27 6:0:0 -32767 110 302 0 0 0.5 -------------------- Redistribution: 85440 2011-5-28 6:0:0 -32767 110 302 0 0 1.2 -------------------- Redistribution: 85440 2011-5-29 6:0:0 -32767 110 302 0 0 5.2 -------------------- Redistribution: 85440 2011-5-30 6:0:0 57 110 302 0 0 7.5 -------------------- Redistribution: 64620 2011-5-28 6:0:0 -32767 110 402 0 0 2.1 -------------------- Redistribution: 64620 2011-5-29 6:0:0 -32767 110 402 0 0 0.5 -------------------- Redistribution: 64620 2011-5-30 6:0:0 3.7 110 402 0 0 1.1 -------------------- Redistribution: 30530 2011-5-28 6:0:0 -32767 110 402 0 0 0.6 -------------------- Redistribution: 30530 2011-5-29 6:0:0 -32767 110 402 0 0 1.9 -------------------- Redistribution: 30530 2011-5-30 6:0:0 4.4 110 402 0 0 1.9 -------------------- Redistribution: 47240 2011-5-28 6:0:0 -32767 110 302 0 0 0.8 -------------------- Redistribution: 47240 2011-5-29 6:0:0 -32767 110 302 0 0 13.4 -------------------- Redistribution: 47240 2011-5-30 6:0:0 17.7 110 302 0 0 3.6 -------------------- Redistribution: 54780 2011-6-2 6:0:0 -32767 110 302 0 0 0.1 -------------------- Redistribution: 54780 2011-6-3 6:0:0 -32767 110 302 0 0 0.6 -------------------- Redistribution: 54780 2011-6-4 6:0:0 10.5 110 302 0 0 9.7 -------------------- Redistribution: 89650 2011-6-2 6:0:0 -32767 110 302 0 0 0.5 -------------------- Redistribution: 89650 2011-6-3 6:0:0 -32767 110 302 0 0 1 -------------------- Redistribution: 89650 2011-6-4 6:0:0 -32767 110 302 0 0 1.9 -------------------- Redistribution: 89650 2011-6-5 6:0:0 -32767 110 302 0 0 6.5 -------------------- Redistribution: 89650 2011-6-6 6:0:0 -32767 110 302 0 0 1.1 -------------------- Redistribution: 89650 2011-6-7 6:0:0 -32767 110 302 0 0 0.1 -------------------- Redistribution: 89650 2011-6-8 6:0:0 13.7 110 302 0 0 2.5 -------------------- Redistribution: 22951 2011-5-30 6:0:0 -32767 110 302 0 0 2.1 -------------------- Redistribution: 22951 2011-5-31 6:0:0 -32767 110 302 0 0 4.9 -------------------- Redistribution: 22951 2011-6-1 6:0:0 -32767 110 302 0 0 4.4 -------------------- Redistribution: 22951 2011-6-2 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 22951 2011-6-3 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 22951 2011-6-4 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 22951 2011-6-5 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 22951 2011-6-6 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 22951 2011-6-7 6:0:0 -32767 110 302 0 0 7.7 -------------------- Redistribution: 22951 2011-6-8 6:0:0 25.1 110 302 0 0 5.9 -------------------- Redistribution: 54420 2011-6-2 6:0:0 -32767 110 302 0 0 0.3 -------------------- Redistribution: 54420 2011-6-3 6:0:0 -32767 110 302 0 0 0.1 -------------------- Redistribution: 54420 2011-6-4 6:0:0 -32767 110 302 0 0 0.1 -------------------- Redistribution: 54420 2011-6-5 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 54420 2011-6-6 6:0:0 -32767 110 302 0 0 -1 -------------------- Redistribution: 54420 2011-6-7 6:0:0 -32767 110 302 0 0 12.6 -------------------- Redistribution: 54420 2011-6-8 6:0:0 -32767 110 302 0 0 3.5 -------------------- Redistribution: 54420 2011-6-9 6:0:0 28 110 302 0 0 11.4 -------------------- Redistribute Completed -------------------- Case DipTest
Individual extracts:
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------------------------------
66100 | 2011-05-20 06:00:00 | 0.1 | 110 | 2011-05-24 19:21:18.963215 | 402 | 0 | 0 | 0.1 | 0110000000001000 | 7000000000000000 |
66100 | 2011-05-21 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23 | 402 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_66070_65270_67150_65230_68270,QC2-redist
66100 | 2011-05-22 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23 | 402 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_66070_65270_67150_65230_68270,QC2-redist
66100 | 2011-05-23 06:00:00 | -1 | 110 | 2011-06-05 21:13:23 | 402 | 0 | 0 | -1 | 0110004000007000 | 5336900000000000 | QC1-7-110b,QC2N_66070_65270_67150_65230_68270,QC2-redist
66100 | 2011-05-24 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23.629222 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-25 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23.63351 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
66100 | 2011-05-26 06:00:00 | -32767 | 110 | 2011-06-05 21:13:23.637654 | 402 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110b
66100 | 2011-05-27 06:00:00 | 13.5 | 110 | 2011-06-05 21:13:23.642076 | 402 | 0 | 0 | 13.5 | 0140004000002000 | 7330900000000001 | QC1-2-72.c12,QC1-7-110b
66100 | 2011-05-28 06:00:00 | -32767 | 110 | 2011-06-15 17:57:08.24819 | 402 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
66100 | 2011-05-29 06:00:00 | -32767 | 110 | 2011-06-15 17:57:08.348889 | 402 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
66100 | 2011-05-30 06:00:00 | 24.5 | 110 | 2011-06-15 17:57:08.354118 | 402 | 0 | 0 | 24.5 | 0140000000000000 | 7020400000000001 | QC1-2-72.c12
66100 | 2011-05-31 06:00:00 | 0.2 | 110 | 2011-06-15 17:57:08.407599 | 402 | 0 | 0 | 0.2 | 0110000000000000 | 7000000000000000 |
Note: The case above also includes examples of “0 0 2 2 0 … ” that were ignored by the current algorithm.
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------------------------------------------------
3200 | 2011-05-18 06:00:00 | 1 | 110 | 2011-05-23 16:31:39.618357 | 402 | 0 | 0 | 1 | 0110004000002000 | 7330900000000000 | QC1-7-110b
3200 | 2011-05-19 06:00:00 | 15 | 110 | 2011-05-23 16:31:39.728458 | 402 | 0 | 0 | 15 | 0110000000001000 | 7000000000000000 |
3200 | 2011-05-20 06:00:00 | -32767 | 110 | 2011-05-23 16:31:39 | 402 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_17500_3280_1230_17251_1650_1080_1950_3780_4040,QC2-redist
3200 | 2011-05-21 06:00:00 | -32767 | 110 | 2011-06-05 21:13:12 | 402 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_17500_1230_17251_1650_1080_1950_3780_4040,QC2-redist
3200 | 2011-05-22 06:00:00 | -32767 | 110 | 2011-06-05 21:13:12 | 402 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_17500_1230_17251_1650_1080_1950_3780_4040,QC2-redist
3200 | 2011-05-23 06:00:00 | 5.5 | 110 | 2011-06-05 21:13:12 | 402 | 0 | 0 | 5.5 | 0110004000007000 | 5336900000000000 | QC1-7-110b,QC2N_17500_1230_17251_1650_1080_1950_3780_4040,QC2-redist
3200 | 2011-05-24 06:00:00 | 4.5 | 110 | 2011-06-05 21:13:12.247816 | 402 | 0 | 0 | 4.5 | 0110000000001000 | 7000000000000000 |
3200 | 2011-05-25 06:00:00 | -32767 | 110 | 2011-06-05 21:13:12.253529 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
3200 | 2011-05-26 06:00:00 | -32767 | 110 | 2011-06-05 21:13:12.258527 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
3200 | 2011-05-27 06:00:00 | 14 | 110 | 2011-06-05 21:13:12.262951 | 402 | 0 | 0 | 14 | 0110004000002000 | 7330900000000000 | QC1-7-110b
15480 | 2011-05-22 06:00:00 | 0 | 110 | 2011-05-24 07:52:04 | 302 | 0 | 0 | -1 | 0140004000001007 | 3031900000000031 | QC1-2-72.b12,watchRR
15480 | 2011-05-23 06:00:00 | 1.4 | 110 | 2011-06-06 21:27:53.828082 | 302 | 0 | 0 | 1.4 | 0110000000001000 | 7000000000000000 |
15480 | 2011-05-24 06:00:00 | -32767 | 110 | 2011-05-25 00:30:04 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_15660_15430_14550_14711_14580_16790,QC2-redist
15480 | 2011-05-25 06:00:00 | -32767 | 110 | 2011-05-26 00:30:04 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_15660_15430_14550_14711_14580_16790,QC2-redist
15480 | 2011-05-26 06:00:00 | -32767 | 110 | 2011-05-27 00:30:04 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_15660_15430_14550_14711_14580_16790,QC2-redist
15480 | 2011-05-27 06:00:00 | -32767 | 110 | 2011-05-28 00:30:03 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_15660_15430_14550_14711_14580_16790,QC2-redist
15480 | 2011-05-28 06:00:00 | -32767 | 110 | 2011-05-29 00:30:05 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_14711_16790,QC2-redist
15480 | 2011-05-29 06:00:00 | 0 | 110 | 2011-06-06 21:28:42 | 302 | 0 | 0 | -1 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_14711_16790,QC2-redist
15480 | 2011-05-30 06:00:00 | 0.2 | 110 | 2011-06-06 21:30:08.201342 | 302 | 0 | 0 | 0.2 | 0110000000001000 | 7000000000000000 |
15480 | 2011-05-31 06:00:00 | 0.3 | 110 | 2011-06-06 21:31:28.374901 | 302 | 0 | 0 | 0.3 | 0110000000001000 | 7000000000000000 |
15480 | 2011-06-01 06:00:00 | 2 | 110 | 2011-06-06 21:32:48.38752 | 302 | 0 | 0 | 2 | 0110000000001000 | 7000000000000000 |
15480 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:30:02 | 302 | 0 | 0 | -1 | 0000001000002006 | 3895900000000050 | QC1-7-110,watchRR
15480 | 2011-06-03 06:00:00 | -32767 | 110 | 2011-06-04 00:30:05 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_14711_16790,QC2-redist
15480 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:31:28 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_14711_16790,QC2-redist
15480 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:30:04 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_14711_16790,QC2-redist
15480 | 2011-06-06 06:00:00 | 0 | 110 | 2011-06-06 21:34:08 | 302 | 0 | 0 | -1 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_14711_16790,QC2-redist
15480 | 2011-06-07 06:00:00 | 3.5 | 110 | 2011-06-07 21:52:29.194444 | 302 | 0 | 0 | 3.5 | 0110000000001000 | 7000000000000000 |
15480 | 2011-06-08 06:00:00 | 4 | 110 | 2011-06-09 21:55:32.650467 | 302 | 0 | 0 | 4 | 0110000000001000 | 7000000000000000 |
85440 | 2011-05-23 06:00:00 | 50 | 110 | 2011-05-23 13:11:09 | 302 | 0 | 0 | 4.8 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_83300,QC2-redist
85440 | 2011-05-24 06:00:00 | -32767 | 110 | 2011-05-25 00:30:31 | 302 | 0 | 0 | 18.9 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC1-7-110,QC2N_85540_83300,QC2-redist
85440 | 2011-05-25 06:00:00 | -32767 | 110 | 2011-05-26 00:30:45 | 302 | 0 | 0 | 10.3 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC1-7-110,QC2N_85180_85540_83300,QC2-redist
85440 | 2011-05-26 06:00:00 | -32767 | 110 | 2011-05-27 00:31:35 | 302 | 0 | 0 | 13.4 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC1-7-110,QC2N_85180_85540_83300,QC2-redist
85440 | 2011-05-27 06:00:00 | -32767 | 110 | 2011-05-28 00:31:31 | 302 | 0 | 0 | 0.5 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC1-7-110,QC2N_85180_85540_83300,QC2-redist
85440 | 2011-05-28 06:00:00 | -32767 | 110 | 2011-05-29 00:34:04 | 302 | 0 | 0 | 1.2 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC1-7-110,QC2N_85180_83300,QC2-redist
85440 | 2011-05-29 06:00:00 | -32767 | 110 | 2011-05-30 00:33:33 | 302 | 0 | 0 | 5.2 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC1-7-110,QC2N_85180_83300,QC2-redist
85440 | 2011-05-30 06:00:00 | 57 | 110 | 2011-06-07 06:19:29 | 302 | 0 | 0 | 7.5 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_85180_83300,QC2-redist
85440 | 2011-05-31 06:00:00 | -32767 | 110 | 2011-06-01 00:31:52 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
64620 | 2011-05-27 06:00:00 | 37.2 | 110 | 2011-05-30 17:34:47.41402 | 402 | 0 | 0 | 37.2 | 0110004000002000 | 7330900000000000 | QC1-7-110b
64620 | 2011-05-28 06:00:00 | -32767 | 110 | 2011-06-06 13:46:31 | 402 | 0 | 0 | 2.1 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_63100_61820_63580_63530_64900,QC2-redist
64620 | 2011-05-29 06:00:00 | -32767 | 110 | 2011-06-06 13:46:31 | 402 | 0 | 0 | 0.5 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_63100_61820_63580_63530_64900,QC2-redist
64620 | 2011-05-30 06:00:00 | 3.7 | 110 | 2011-06-06 13:46:31 | 402 | 0 | 0 | 1.1 | 0110004000007000 | 5336900000000000 | QC1-7-110b,QC2N_63100_61820_63580_63530_64900,QC2-redist
64620 | 2011-05-31 06:00:00 | -32767 | 110 | 2011-06-06 13:46:31.586788 | 402 | 0 | 0 | -32767 | 0000003000000000 | 7899900000000000 |
30530 | 2011-05-27 06:00:00 | 17 | 110 | 2011-05-30 17:34:40.805122 | 402 | 0 | 0 | 17 | 0110000000001000 | 7000000000000000 |
30530 | 2011-05-28 06:00:00 | -32767 | 110 | 2011-06-06 13:46:22 | 402 | 0 | 0 | 0.6 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_32200_30380_31850_31900_32320_30860_34900_30320_32850,QC2-redist
30530 | 2011-05-29 06:00:00 | -32767 | 110 | 2011-06-06 13:46:22 | 402 | 0 | 0 | 1.9 | 0000001000007000 | 5896900000000000 | QC1-7-110b,QC2N_32200_30380_31850_31900_32320_30860_34900_30320,QC2-redist
30530 | 2011-05-30 06:00:00 | 4.4 | 110 | 2011-06-06 13:46:22 | 402 | 0 | 0 | 1.9 | 0110004000007000 | 5336900000000000 | QC1-7-110b,QC2N_32200_30380_31850_31900_32320_30860_34900_30320_32850,QC2-redist
30530 | 2011-05-31 06:00:00 | 16.2 | 110 | 2011-06-06 13:46:22.285368 | 402 | 0 | 0 | 16.2 | 0110000000001000 | 7000000000000000 |
47240 | 2011-05-27 06:00:00 | 4.6 | 110 | 2011-05-27 05:35:50.615186 | 302 | 0 | 0 | 4.6 | 0110000000001000 | 7000000000000000 |
47240 | 2011-05-28 06:00:00 | -32767 | 110 | 2011-05-29 00:31:42 | 302 | 0 | 0 | 0.8 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_47450_44700_45600,QC2-redist
47240 | 2011-05-29 06:00:00 | -32767 | 110 | 2011-05-30 00:31:42 | 302 | 0 | 0 | 13.4 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_44700_45600,QC2-redist
47240 | 2011-05-30 06:00:00 | 17.7 | 110 | 2011-05-30 05:36:52 | 302 | 0 | 0 | 3.6 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_47090_44700_45600,QC2-redist
47240 | 2011-05-31 06:00:00 | 6 | 110 | 2011-05-31 05:41:54.558407 | 302 | 0 | 0 | 6 | 0110000000001000 | 7000000000000000 |
54780 | 2011-05-31 06:00:00 | 1.6 | 110 | 2011-05-31 06:21:32.607113 | 302 | 0 | 0 | 1.6 | 0110000000001000 | 7000000000000000 |
54780 | 2011-06-01 06:00:00 | 2.5 | 110 | 2011-06-01 08:53:13.650483 | 302 | 0 | 0 | 2.5 | 0110000000001000 | 7000000000000000 |
54780 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:32:21 | 302 | 0 | 0 | 0.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_54600_23720,QC2-redist
54780 | 2011-06-03 06:00:00 | -32767 | 110 | 2011-06-04 00:32:38 | 302 | 0 | 0 | 0.6 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_54600_55550_23720,QC2-redist
54780 | 2011-06-04 06:00:00 | 10.5 | 110 | 2011-06-06 07:42:13 | 302 | 0 | 0 | 9.7 | 0110004000007000 | 5336900000000000 | QC1-7-110,QC2N_55550_23720,QC2-redist
54780 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:32:36 | 302 | 0 | 0 | -32767 | 0000003000002000 | 7899900000000000 | QC1-7-110
54780 | 2011-06-06 06:00:00 | -1 | 110 | 2011-06-06 07:42:12.395496 | 302 | 0 | 0 | -1 | 0110000000002000 | 7330900000000000 | QC1-7-110
54780 | 2011-06-07 06:00:00 | 6.5 | 110 | 2011-06-07 06:51:45.406395 | 302 | 0 | 0 | 6.5 | 0110000000001000 | 7000000000000000 |
89650 | 2011-06-01 06:00:00 | 2.3 | 110 | 2011-06-01 07:59:47.168921 | 302 | 0 | 0 | 2.3 | 0140004000002000 | 7330900000000001 | QC1-2-72.b12,QC1-7-110
89650 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:33:55 | 302 | 0 | 0 | 0.5 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_88100,QC2-redist
89650 | 2011-06-03 06:00:00 | -32767 | 110 | 2011-06-04 00:34:18 | 302 | 0 | 0 | 1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_88100,QC2-redist
89650 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:35:17 | 302 | 0 | 0 | 1.9 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_88100,QC2-redist
89650 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:34:10 | 302 | 0 | 0 | 6.5 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_88100,QC2-redist
89650 | 2011-06-06 06:00:00 | -32767 | 110 | 2011-06-07 00:32:34 | 302 | 0 | 0 | 1.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_88100,QC2-redist
89650 | 2011-06-07 06:00:00 | -32767 | 110 | 2011-06-08 00:30:32 | 302 | 0 | 0 | 0.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_88100,QC2-redist
89650 | 2011-06-08 06:00:00 | 13.7 | 110 | 2011-06-08 06:36:28 | 302 | 0 | 0 | 2.5 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_88100,QC2-redist
89650 | 2011-06-09 06:00:00 | 1.6 | 110 | 2011-06-09 05:54:59.510344 | 302 | 0 | 0 | 1.6 | 0110000000001000 | 7000000000000000 |
22951 | 2011-05-28 06:00:00 | -32767 | 110 | 2011-05-29 00:30:05 | 302 | 0 | 0 | 3.5 | 0000001000007001 | 1896900000000050 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist,watchRR
22951 | 2011-05-29 06:00:00 | 11 | 110 | 2011-05-29 12:02:47 | 302 | 0 | 0 | 3.4 | 0140004000007001 | 1306000000000051 | QC1-2-72.b12,QC1-7-110,QC2N_22790_22730_25100,QC2-redist,watchRR
22951 | 2011-05-30 06:00:00 | -32767 | 110 | 2011-05-31 00:30:06 | 302 | 0 | 0 | 2.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-05-31 06:00:00 | -32767 | 110 | 2011-06-01 00:30:03 | 302 | 0 | 0 | 4.9 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-01 06:00:00 | -32767 | 110 | 2011-06-02 00:30:03 | 302 | 0 | 0 | 4.4 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:30:37 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-03 06:00:00 | -32767 | 110 | 2011-06-04 00:30:49 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:30:53 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:30:43 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-06 06:00:00 | -32767 | 110 | 2011-06-07 00:30:26 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-07 06:00:00 | -32767 | 110 | 2011-06-08 00:30:02 | 302 | 0 | 0 | 7.7 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-08 06:00:00 | 25.1 | 110 | 2011-06-08 05:04:28 | 302 | 0 | 0 | 5.9 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-09 06:00:00 | -32767 | 110 | 2011-06-10 00:30:03 | 302 | 0 | 0 | 11.8 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-10 06:00:00 | -32767 | 110 | 2011-06-11 00:30:02 | 302 | 0 | 0 | 19.8 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-11 06:00:00 | -32767 | 110 | 2011-06-12 00:30:07 | 302 | 0 | 0 | 36.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-12 06:00:00 | -32767 | 110 | 2011-06-13 00:30:43 | 302 | 0 | 0 | 8.4 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-13 06:00:00 | 76.1 | 110 | 2011-06-13 09:25:48 | 302 | 0 | 0 | -1 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_22790_22730_25100,QC2-redist
22951 | 2011-06-14 06:00:00 | -32767 | 110 | 2011-06-15 00:30:03 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
22951 | 2011-06-15 06:00:00 | -32767 | 110 | 2011-06-16 00:44:33 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
22951 | 2011-06-16 06:00:00 | -32767 | 110 | 2011-06-17 00:30:04 | 302 | 0 | 0 | -32767 | 0000003000000000 | 9999900000000000 |
54420 | 2011-06-01 06:00:00 | 7.5 | 110 | 2011-06-01 07:48:10 | 302 | 0 | 0 | 1.9 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_25100_23720_53950_54780_53730_25320,QC2-redist
54420 | 2011-06-02 06:00:00 | -32767 | 110 | 2011-06-03 00:32:21 | 302 | 0 | 0 | 0.3 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_54600_25100_23720_25320_53700,QC2-redist
54420 | 2011-06-03 06:00:00 | -32767 | 110 | 2011-06-04 00:32:38 | 302 | 0 | 0 | 0.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_54600_25100_23720_25260_25320,QC2-redist
54420 | 2011-06-04 06:00:00 | -32767 | 110 | 2011-06-05 00:33:40 | 302 | 0 | 0 | 0.1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25100_23720_25320_53700,QC2-redist
54420 | 2011-06-05 06:00:00 | -32767 | 110 | 2011-06-06 00:32:05 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25100_23720_25320_53700,QC2-redist
54420 | 2011-06-06 06:00:00 | -32767 | 110 | 2011-06-07 00:31:36 | 302 | 0 | 0 | -1 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25100_23720_25320_53700,QC2-redist
54420 | 2011-06-07 06:00:00 | -32767 | 110 | 2011-06-08 00:30:19 | 302 | 0 | 0 | 12.6 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25100_23720_53950_54780_53730_25320,QC2-redist
54420 | 2011-06-08 06:00:00 | -32767 | 110 | 2011-06-09 00:31:01 | 302 | 0 | 0 | 3.5 | 0000001000007000 | 5896900000000000 | QC1-7-110,QC2N_25100_23720_53950_54780_25260_53730_25320_53700,QC2-redist
54420 | 2011-06-09 06:00:00 | 28 | 110 | 2011-06-09 07:41:20 | 302 | 0 | 0 | 11.4 | 0140004000007000 | 5336900000000001 | QC1-2-72.b12,QC1-7-110,QC2N_25100_23720_53950_54780_53730_25320_53700,QC2-redist