====== kvqc2d Version: 1.1.3 ====== Source: [[https://svn.met.no/viewvc/kvoss/kvqc2d/branches/kvqc2d-1.1.3/]] **Significant Changes** * Fix of BUG1322 and check to mitigate errors in fd flags settings. All other details identical to [[kvoss:system:qc2:user:version: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 ===== Production Checks 2011-06-16 ===== 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) ===== Production Checks 2011-06-17 <<30 DAY RUN>> ===== 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