This is an old revision of the document!
DIP TEST
Output of various tests. The latest is always posted at the top of the page.
March 2011
Reference: https://kvalobs.wiki.met.no/doku.php?id=kvoss:system:qc2:requirements:algorithms:diptest01
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------
17000 | 2008-01-30 22:00:00 | 317.4 | 104 | 2008-01-30 22:08:48 | 3 | 0 | 0 | 317.4 | 1101000000100100 | 7000000000000000 |
17000 | 2008-01-30 23:00:00 | 0 | 104 | 2008-01-30 23:04:45 | 3 | 0 | 0 | 317.4 | 1109000000100100 | 5033300000000001 | QC1-3a-104:1,QC2d-1
17000 | 2008-01-31 00:00:00 | 317.4 | 104 | 2008-01-31 00:03:38 | 3 | 0 | 0 | 317.4 | 1104000000100100 | 5010300000000001 | QC1-3a-104:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------
17000 | 2008-02-14 23:00:00 | 1041.9 | 172 | 2008-02-14 23:02:21 | 3 | 0 | 0 | 1041.9 | 1201000000000000 | 7010100000000001 | QC1-1-172:1
17000 | 2008-02-15 00:00:00 | 985 | 172 | 2008-02-15 00:03:38 | 3 | 0 | 0 | 1042.2 | 1109000000000000 | 5033300000000001 | QC1-3a-172:1,QC2d-1
17000 | 2008-02-15 01:00:00 | 1042.5 | 172 | 2008-02-15 01:02:21 | 3 | 0 | 0 | 1042.5 | 1104000000000000 | 5010300000000001 | QC1-1-172:1,QC1-3a-172:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------
17000 | 2008-02-15 02:00:00 | 1042.8 | 172 | 2008-02-15 02:02:21 | 3 | 0 | 0 | 1042.8 | 1201000000000000 | 7010100000000001 | QC1-1-172:1
17000 | 2008-02-15 03:00:00 | 984.5 | 172 | 2008-02-15 03:02:33 | 3 | 0 | 0 | 1043.1 | 1109000000000000 | 5033300000000001 | QC1-3a-172:1,QC2d-1
17000 | 2008-02-15 04:00:00 | 1043.3 | 172 | 2008-02-15 04:02:22 | 3 | 0 | 0 | 1043.3 | 1104000000000000 | 5010300000000001 | QC1-1-172:1,QC1-3a-172:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------
17000 | 2008-02-16 17:00:00 | 1033.2 | 172 | 2008-02-16 17:02:30 | 3 | 0 | 0 | 1033.2 | 1101000000000000 | 7000000000000000 |
17000 | 2008-02-16 18:00:00 | 994.6 | 172 | 2008-02-16 18:03:40 | 3 | 0 | 0 | 1032.3 | 1109000000000000 | 5033300000000001 | QC1-3a-172:1,QC2d-1
17000 | 2008-02-16 19:00:00 | 1031.4 | 172 | 2008-02-16 19:02:33 | 3 | 0 | 0 | 1031.4 | 1104000000000000 | 5010300000000001 | QC1-3a-172:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------
90800 | 2008-02-11 12:00:00 | 1020.7 | 172 | 2008-02-11 11:55:25 | 3 | 0 | 0 | 1020.7 | 1101000000000000 | 7000000000000000 |
90800 | 2008-02-11 13:00:00 | 1005.6 | 172 | 2008-02-11 12:55:27 | 3 | 0 | 0 | 1020.9 | 1109000000000000 | 5033300000000001 | QC1-3a-172:1,QC2d-1
90800 | 2008-02-11 14:00:00 | 1021 | 172 | 2008-02-11 13:55:26 | 3 | 0 | 0 | 1021 | 1104000000000000 | 5010300000000001 | QC1-3a-172:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------------
16610 | 2008-01-26 06:00:00 | 882.7 | 176 | 2008-01-26 05:55:22 | 3 | 0 | 0 | 882.7 | 1101000000000000 | 7000000000000000 |
16610 | 2008-01-26 07:00:00 | 991 | 176 | 2008-01-26 06:55:23 | 3 | 0 | 0 | 882.3 | 1409000000000000 | 5033300000000002 | QC1-1-176:1,QC1-3a-176:1,QC2d-1
16610 | 2008-01-26 08:00:00 | 881.8 | 176 | 2008-01-26 08:20:36 | 3 | 0 | 0 | 881.8 | 1404000000000000 | 5020300000000002 | QC1-3a-176:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------
77001 | 2008-02-13 12:00:00 | 0 | 211 | 2008-02-13 12:03:35 | 11 | 0 | 0 | 0 | 1111000000100010 | 7000000000000000 |
77001 | 2008-02-13 13:00:00 | 29.3 | 211 | 2008-02-13 13:03:44 | 11 | 0 | 0 | 0 | 1119000000100010 | 5033300000000001 | QC1-3a-211:1,QC2d-1
77001 | 2008-02-13 14:00:00 | 0 | 211 | 2008-02-13 14:03:58 | 11 | 0 | 0 | 0 | 1114000000100010 | 5010300000000001 | QC1-3a-211:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------
77001 | 2008-02-13 17:00:00 | 30 | 211 | 2008-02-13 17:04:09 | 11 | 0 | 0 | 30 | 1111000000100010 | 7000000000000000 |
77001 | 2008-02-13 18:00:00 | 0 | 211 | 2008-02-13 18:03:16 | 11 | 0 | 0 | 26.6 | 1119000000100010 | 5033300000000001 | QC1-3a-211:1,QC2d-1
77001 | 2008-02-13 19:00:00 | 23.2 | 211 | 2008-02-13 19:03:26 | 11 | 0 | 0 | 23.2 | 1114000000100010 | 5010300000000001 | QC1-3a-211:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------
99710 | 2008-02-18 05:00:00 | -5.4 | 211 | 2008-02-18 04:59:22 | 1 | 0 | 0 | -5.4 | 1111100000100010 | 7000000000000000 |
99710 | 2008-02-18 06:00:00 | -13.4 | 211 | 2008-02-18 06:07:28 | 1 | 0 | 0 | -5.5 | 1139500000100010 | 50333000000000C3 | QC1-2-34:1,QC1-3a-211:1,QC1-4-211:1,QC1-2-35:1,hqc,QC1-2-34:1,QC1-3a-211:1,QC1-4-211:1,hqc,QC1-2-35:1,QC1-2-34:1,QC1-3a-211:1,QC1-4-211:1,QC1-2-35:1,QC2d-1
99710 | 2008-02-18 07:00:00 | -5.7 | 211 | 2008-02-18 06:54:35 | 1 | 0 | 0 | -5.7 | 1134500000100010 | 5020300000000103 | QC1-3a-211:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
5590 | 2008-01-14 18:00:00 | 1.6 | 81 | 2008-01-14 17:46:04 | 330 | 0 | 0 | 1.6 | 1111100000000000 | 7100000300000000 |
5590 | 2008-01-14 19:00:00 | 63 | 81 | 2008-02-21 12:09:22 | 330 | 0 | 0 | 2 | 1119400000000000 | 5133300400000002 | QC1-3a-81:1,QC1-4-81:1,QC2d-1
5590 | 2008-01-14 20:00:00 | 2.3 | 81 | 2008-01-14 19:46:02 | 330 | 0 | 0 | 2.3 | 1114400000000000 | 5110300300000002 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
75410 | 2008-01-26 02:00:00 | 22.08 | 81 | 2008-01-26 01:56:48 | 3 | 0 | 0 | 22.1 | 1111200000000002 | 3000000000000041 | QC1-4-81:1,hqc
75410 | 2008-01-26 03:00:00 | 11.74 | 81 | 2008-01-26 02:56:53 | 3 | 0 | 0 | 22.3 | 1119100000100000 | 5033300000000001 | QC1-3a-81:1,QC2d-1
75410 | 2008-01-26 04:00:00 | 22.52 | 81 | 2008-01-26 03:56:49 | 3 | 0 | 0 | 22.52 | 1114100000100000 | 5010300000000001 | QC1-3a-81:1,QC1-4-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
76972 | 2008-02-13 08:00:00 | 10.288 | 81 | 2008-02-13 08:04:23 | 11 | 0 | 0 | 10.288 | 1111000000000000 | 7000000000000000 |
76972 | 2008-02-13 09:00:00 | 29.8352 | 81 | 2008-02-13 09:04:28 | 11 | 0 | 0 | 10.5 | 1419000000000000 | 5033300000000002 | QC1-1-81:1,QC1-3a-81:1,QC2d-1
76972 | 2008-02-13 10:00:00 | 10.8024 | 81 | 2008-02-13 10:04:27 | 11 | 0 | 0 | 10.8024 | 1414000000000000 | 5020300000000002 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
76972 | 2008-02-13 15:00:00 | 26.2344 | 81 | 2008-02-13 15:04:58 | 11 | 0 | 0 | 26.2344 | 1211000000000000 | 7010100000000001 | QC1-1-81:1
76972 | 2008-02-13 16:00:00 | 12.3456 | 81 | 2008-02-13 16:06:02 | 11 | 0 | 0 | 24.4 | 1119000000000000 | 5033300000000001 | QC1-3a-81:1,QC2d-1
76972 | 2008-02-13 17:00:00 | 22.6336 | 81 | 2008-02-13 17:05:09 | 11 | 0 | 0 | 22.6336 | 1114000000000000 | 5010300000000001 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
76990 | 2008-01-06 15:00:00 | 9.7736 | 81 | 2008-01-06 15:01:32 | 11 | 0 | 0 | 9.7736 | 1111000000000000 | 7000000000000000 |
76990 | 2008-01-06 16:00:00 | 47.8392 | 81 | 2008-01-06 16:01:36 | 11 | 0 | 0 | 10 | 1419000000000000 | 5033300000000002 | QC1-1-81:1,QC1-3a-81:1,QC2d-1
76990 | 2008-01-06 17:00:00 | 10.288 | 81 | 2008-01-06 17:02:09 | 11 | 0 | 0 | 10.288 | 1414000000000000 | 5020300000000002 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
76990 | 2008-01-08 00:00:00 | 4.6296 | 81 | 2008-01-08 00:03:12 | 11 | 0 | 0 | 4.6296 | 1111000000000000 | 7000000000000000 |
76990 | 2008-01-08 01:00:00 | 40.1232 | 81 | 2008-01-08 01:02:34 | 11 | 0 | 0 | 10.8 | 1419000000000000 | 5033300000000002 | QC1-1-81:1,QC1-3a-81:1,QC2d-1
76990 | 2008-01-08 02:00:00 | 16.9752 | 81 | 2008-01-08 02:02:14 | 11 | 0 | 0 | 16.9752 | 1414000000000000 | 5020300000000002 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
76990 | 2008-01-12 17:00:00 | 6.1728 | 81 | 2008-01-12 17:02:11 | 11 | 0 | 0 | 6.1728 | 1111000000000000 | 7000000000000000 |
76990 | 2008-01-12 18:00:00 | 49.8968 | 81 | 2008-01-12 18:02:12 | 11 | 0 | 0 | 4.4 | 1419000000000000 | 5033300000000002 | QC1-1-81:1,QC1-3a-81:1,QC2d-1
76990 | 2008-01-12 19:00:00 | 2.572 | 81 | 2008-01-12 19:02:22 | 11 | 0 | 0 | 2.572 | 1414000000000000 | 5020300000000002 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
76990 | 2008-01-21 04:00:00 | 11.3168 | 81 | 2008-01-21 04:03:35 | 11 | 0 | 0 | 11.3168 | 1111000000000000 | 7000000000000000 |
76990 | 2008-01-21 05:00:00 | 25.72 | 81 | 2008-01-21 05:02:42 | 11 | 0 | 0 | 6.4 | 1119000000000000 | 5033300000000001 | QC1-3a-81:1,QC2d-1
76990 | 2008-01-21 06:00:00 | 1.5432 | 81 | 2008-01-21 06:01:49 | 11 | 0 | 0 | 1.5432 | 1114000000000000 | 5010300000000001 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
76990 | 2008-01-24 16:00:00 | 5.6584 | 81 | 2008-01-24 16:02:34 | 11 | 0 | 0 | 5.6584 | 1111000000000000 | 7000000000000000 |
76990 | 2008-01-24 17:00:00 | 44.2384 | 81 | 2008-01-24 17:03:20 | 11 | 0 | 0 | 8.2 | 1419000000000000 | 5033300000000002 | QC1-1-81:1,QC1-3a-81:1,QC2d-1
76990 | 2008-01-24 18:00:00 | 10.8024 | 81 | 2008-01-24 18:03:21 | 11 | 0 | 0 | 10.8024 | 1414000000000000 | 5020300000000002 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
76990 | 2008-01-25 20:00:00 | 9.2592 | 81 | 2008-01-25 20:01:27 | 11 | 0 | 0 | 9.2592 | 1111000000000000 | 7000000000000000 |
76990 | 2008-01-25 21:00:00 | 30.3496 | 81 | 2008-01-25 21:01:33 | 11 | 0 | 0 | 9.3 | 1219000000000000 | 5033300000000002 | QC1-1-81:1,QC1-3a-81:1,QC2d-1
76990 | 2008-01-25 22:00:00 | 9.2592 | 81 | 2008-01-25 22:01:40 | 11 | 0 | 0 | 9.2592 | 1214000000000000 | 5010300000000002 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
76990 | 2008-02-18 23:00:00 | 6.6872 | 81 | 2008-02-18 23:02:00 | 11 | 0 | 0 | 6.6872 | 1111000000000000 | 7000000000000000 |
76990 | 2008-02-19 00:00:00 | 46.8104 | 81 | 2008-02-19 00:00:58 | 11 | 0 | 0 | 7.7 | 1419000000000000 | 5033300000000002 | QC1-1-81:1,QC1-3a-81:1,QC2d-1
76990 | 2008-02-19 01:00:00 | 8.7448 | 81 | 2008-02-19 01:01:17 | 11 | 0 | 0 | 8.7448 | 1414000000000000 | 5020300000000002 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
76990 | 2008-02-20 16:00:00 | 3.6008 | 81 | 2008-02-20 16:01:45 | 11 | 0 | 0 | 3.6008 | 1111000000000000 | 7000000000000000 |
76990 | 2008-02-20 17:00:00 | 22.1192 | 81 | 2008-02-20 17:02:05 | 11 | 0 | 0 | 5.4 | 1119000000000000 | 5033300000000001 | QC1-3a-81:1,QC2d-1
76990 | 2008-02-20 18:00:00 | 7.2016 | 81 | 2008-02-20 18:02:09 | 11 | 0 | 0 | 7.2016 | 1114000000000000 | 5010300000000001 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
76990 | 2008-02-23 09:00:00 | 11.8312 | 81 | 2008-02-23 09:02:32 | 11 | 0 | 0 | 11.8312 | 1111000000000000 | 7000000000000000 |
76990 | 2008-02-23 10:00:00 | 23.6624 | 81 | 2008-02-23 10:02:34 | 11 | 0 | 0 | 9.3 | 1219000000000000 | 5033300000000002 | QC1-1-81:1,QC1-3a-81:1,QC2d-1
76990 | 2008-02-23 11:00:00 | 6.6872 | 81 | 2008-02-23 11:01:48 | 11 | 0 | 0 | 6.6872 | 1214000000000000 | 5010300000000002 | QC1-3a-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
85040 | 2008-01-29 03:00:00 | 19.5 | 81 | 2008-01-29 03:04:19 | 330 | 0 | 0 | 19.5 | 1111100000000000 | 7000000000000000 |
85040 | 2008-01-29 04:00:00 | 9.2 | 81 | 2008-01-29 04:04:06 | 330 | 0 | 0 | 20.6 | 1119300000000000 | 5033300000000002 | QC1-3a-81:1,QC1-4-81:1,QC2d-1
85040 | 2008-01-29 05:00:00 | 21.7 | 81 | 2008-01-29 05:04:07 | 330 | 0 | 0 | 21.7 | 1114300000000000 | 5010300000000002 | QC1-3a-81:1,QC1-4-81:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
26990 | 2008-01-11 09:00:00 | 3.84 | 87 | 2008-01-11 09:05:25 | 3 | 0 | 0 | 3.84 | 1101000000000000 | 7000000000000000 |
26990 | 2008-01-11 10:00:00 | 52.55 | 87 | 2008-01-11 12:05:19 | 3 | 0 | 0 | 5.7 | 1409000000000000 | 5133300400000002 | QC1-1-87:1,QC1-3a-87:1,QC2d-1
26990 | 2008-01-11 11:00:00 | 7.57 | 87 | 2008-01-11 12:05:19 | 3 | 0 | 0 | 7.57 | 1404000000000000 | 5120300400000002 | QC1-3a-87:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
57770 | 2008-02-02 17:00:00 | 6.8 | 87 | 2008-02-02 16:55:42 | 330 | 0 | 0 | 6.8 | 1101000000000000 | 7000000000000000 |
57770 | 2008-02-02 18:00:00 | 19.4 | 87 | 2008-02-02 17:55:46 | 330 | 0 | 0 | 7.7 | 1109000000000000 | 5033300000000001 | QC1-3a-87:1,QC2d-1
57770 | 2008-02-02 19:00:00 | 8.6 | 87 | 2008-02-02 18:55:47 | 330 | 0 | 0 | 8.6 | 1104000000000000 | 5010300000000021 | QC1-3a-87:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
85040 | 2008-01-25 07:00:00 | 13.5 | 87 | 2008-01-25 07:04:06 | 330 | 0 | 0 | 13.5 | 1101000000000000 | 7000000000000000 |
85040 | 2008-01-25 08:00:00 | 25.4 | 87 | 2008-01-25 08:04:03 | 330 | 0 | 0 | 12.9 | 1109000000000000 | 5033300000000001 | QC1-3a-87:1,QC2d-1
85040 | 2008-01-25 09:00:00 | 12.2 | 87 | 2008-01-25 09:04:03 | 330 | 0 | 0 | 12.2 | 1104000000000000 | 5010300000000001 | QC1-3a-87:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
10380 | 2008-01-08 22:00:00 | 1.7 | 90 | 2008-01-08 21:50:12 | 311 | 0 | 0 | 1.7 | 1101000000000000 | 7000000000000000 |
10380 | 2008-01-08 23:00:00 | 37.43 | 90 | 2008-01-08 22:50:16 | 311 | 0 | 0 | 1.7 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
10380 | 2008-01-09 00:00:00 | 1.6 | 90 | 2008-01-08 23:50:23 | 311 | 0 | 0 | 1.6 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
10380 | 2008-01-09 02:00:00 | 1.5 | 90 | 2008-01-09 01:50:20 | 311 | 0 | 0 | 1.5 | 1101000000000000 | 7000000000000000 |
10380 | 2008-01-09 03:00:00 | 41.13 | 90 | 2008-01-09 02:50:24 | 311 | 0 | 0 | 2.1 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
10380 | 2008-01-09 04:00:00 | 2.6 | 90 | 2008-01-09 03:50:13 | 311 | 0 | 0 | 2.6 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------
10380 | 2008-01-30 17:00:00 | 1.3 | 90 | 2008-01-30 16:50:12 | 311 | 0 | 0 | 1.3 | 1101000000000000 | 7000000000000000 |
10380 | 2008-01-30 18:00:00 | 14.57 | 90 | 2008-01-30 17:50:10 | 311 | 0 | 0 | 1.3 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC1-3a-90:1,QC2d-1
10380 | 2008-01-30 19:00:00 | 1.37 | 90 | 2008-01-30 18:50:08 | 311 | 0 | 0 | 1.37 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
10380 | 2008-01-30 21:00:00 | 1.17 | 90 | 2008-01-30 20:50:12 | 311 | 0 | 0 | 1.17 | 1101000000000000 | 7000000000000000 |
10380 | 2008-01-30 22:00:00 | 33.27 | 90 | 2008-01-30 21:50:13 | 311 | 0 | 0 | 1.6 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
10380 | 2008-01-30 23:00:00 | 2 | 90 | 2008-01-30 22:50:10 | 311 | 0 | 0 | 2 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
10380 | 2008-02-03 01:00:00 | 1.57 | 90 | 2008-02-03 00:50:14 | 311 | 0 | 0 | 1.57 | 1101000000000000 | 7000000000000000 |
10380 | 2008-02-03 02:00:00 | 34.07 | 90 | 2008-02-03 01:50:13 | 311 | 0 | 0 | 1.3 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
10380 | 2008-02-03 03:00:00 | 1 | 90 | 2008-02-03 02:50:11 | 311 | 0 | 0 | 1 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+------------------------------------------------------
10380 | 2008-02-03 11:00:00 | 0.8 | 90 | 2008-02-03 10:50:10 | 311 | 0 | 0 | 0.8 | 1101000000000000 | 7000000000000000 |
10380 | 2008-02-03 12:00:00 | 35.47 | 90 | 2008-02-03 11:50:11 | 311 | 0 | 0 | 7.1 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC1-1-90:1,QC1-3a-90:1,QC2d-1
10380 | 2008-02-03 13:00:00 | 13.47 | 90 | 2008-02-03 12:50:11 | 311 | 0 | 0 | 13.47 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+------------------------------------------------------
10380 | 2008-02-10 05:00:00 | 2.3 | 90 | 2008-02-10 04:50:16 | 311 | 0 | 0 | 2.3 | 1101000000000000 | 7000000000000000 |
10380 | 2008-02-10 06:00:00 | 47.53 | 90 | 2008-02-10 05:50:15 | 311 | 0 | 0 | 1.6 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC1-1-90:1,QC1-3a-90:1,QC2d-1
10380 | 2008-02-10 07:00:00 | 0.9 | 90 | 2008-02-10 06:50:10 | 311 | 0 | 0 | 0.9 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
10380 | 2008-02-11 09:00:00 | 0 | 90 | 2008-02-11 08:50:11 | 311 | 0 | 0 | 0 | 1101000000000000 | 7000000000000000 |
10380 | 2008-02-11 10:00:00 | 32 | 90 | 2008-02-11 09:50:07 | 311 | 0 | 0 | 2.3 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
10380 | 2008-02-11 11:00:00 | 4.63 | 90 | 2008-02-11 10:50:07 | 311 | 0 | 0 | 4.63 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
10380 | 2008-02-12 18:00:00 | 1.8 | 90 | 2008-02-12 17:50:12 | 311 | 0 | 0 | 1.8 | 1101000000000000 | 7000000000000000 |
10380 | 2008-02-12 19:00:00 | 35.83 | 90 | 2008-02-12 18:50:06 | 311 | 0 | 0 | 1.5 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
10380 | 2008-02-12 20:00:00 | 1.1 | 90 | 2008-02-12 19:50:13 | 311 | 0 | 0 | 1.1 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
18230 | 2008-01-14 08:00:00 | 7.6 | 90 | 2008-01-14 07:50:32 | 330 | 0 | 0 | 7.6 | 1101000000000000 | 7000000000000000 |
18230 | 2008-01-14 09:00:00 | 37.5 | 90 | 2008-01-14 08:50:28 | 330 | 0 | 0 | 8.3 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
18230 | 2008-01-14 10:00:00 | 9 | 90 | 2008-01-14 09:50:34 | 330 | 0 | 0 | 9 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
23410 | 2008-01-07 01:00:00 | 2.17 | 90 | 2008-01-07 00:48:11 | 311 | 0 | 0 | 2.17 | 1101000000000000 | 7000000000000000 |
23410 | 2008-01-07 02:00:00 | 20.67 | 90 | 2008-01-07 01:48:10 | 311 | 0 | 0 | 1.6 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
23410 | 2008-01-07 03:00:00 | 1 | 90 | 2008-01-07 02:48:11 | 311 | 0 | 0 | 1 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
23410 | 2008-02-03 19:00:00 | 1.8 | 90 | 2008-02-03 18:48:13 | 311 | 0 | 0 | 1.8 | 1101000000000000 | 7000000000000000 |
23410 | 2008-02-03 20:00:00 | 18.17 | 90 | 2008-02-03 19:48:11 | 311 | 0 | 0 | 2 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
23410 | 2008-02-03 21:00:00 | 2.27 | 90 | 2008-02-03 20:48:10 | 311 | 0 | 0 | 2.27 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
23410 | 2008-02-15 03:00:00 | 2.3 | 90 | 2008-02-15 03:30:11 | 311 | 0 | 0 | 2.3 | 1101000000000000 | 7100000400000000 |
23410 | 2008-02-15 04:00:00 | 30.7 | 90 | 2008-02-15 04:30:14 | 311 | 0 | 0 | 2 | 1109000000000000 | 5133300400000001 | QC1-3a-90:1,QC2d-1
23410 | 2008-02-15 05:00:00 | 1.6 | 90 | 2008-02-15 05:30:12 | 311 | 0 | 0 | 1.6 | 1104000000000000 | 5110300400000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
38140 | 2008-01-12 17:00:00 | 3.34 | 90 | 2008-01-12 17:01:12 | 3 | 0 | 0 | 3.34 | 1111000000000000 | 7000000000000000 |
38140 | 2008-01-12 18:00:00 | 35.48 | 90 | 2008-01-12 18:01:14 | 3 | 0 | 0 | 3 | 1119000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
38140 | 2008-01-12 19:00:00 | 2.64 | 90 | 2008-01-12 19:01:08 | 3 | 0 | 0 | 2.64 | 1114000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
48330 | 2008-02-22 21:00:00 | 21.9 | 90 | 2008-02-22 20:59:35 | 330 | 0 | 0 | 21.9 | 1101000000000000 | 7000000000000000 |
48330 | 2008-02-22 22:00:00 | 39 | 90 | 2008-02-22 21:59:39 | 330 | 0 | 0 | 22.2 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
48330 | 2008-02-22 23:00:00 | 22.4 | 90 | 2008-02-22 22:59:37 | 330 | 0 | 0 | 22.4 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
55700 | 2008-01-27 20:00:00 | 2.2 | 90 | 2008-01-27 19:50:25 | 311 | 0 | 0 | 2.2 | 1101000000000000 | 7000000000000000 |
55700 | 2008-01-27 21:00:00 | 19.7 | 90 | 2008-01-27 20:50:16 | 311 | 0 | 0 | 2.4 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
55700 | 2008-01-27 22:00:00 | 2.6 | 90 | 2008-01-27 21:50:22 | 311 | 0 | 0 | 2.6 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
57770 | 2008-01-09 08:00:00 | 22.7 | 90 | 2008-01-09 07:49:47 | 330 | 0 | 0 | 22.7 | 1101000000000000 | 7100000300000000 |
57770 | 2008-01-09 09:00:00 | 35.7 | 90 | 2008-01-09 08:49:43 | 330 | 0 | 0 | 19.9 | 1209000000000000 | 5133300300000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
57770 | 2008-01-09 10:00:00 | 17.1 | 90 | 2008-01-09 09:49:45 | 330 | 0 | 0 | 17.1 | 1204000000000000 | 5110300300000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
57770 | 2008-01-20 07:00:00 | 13.8 | 90 | 2008-01-20 06:55:55 | 330 | 0 | 0 | 13.8 | 1101000000000000 | 7000000000000000 |
57770 | 2008-01-20 08:00:00 | 28.2 | 90 | 2008-01-20 07:55:54 | 330 | 0 | 0 | 12.9 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
57770 | 2008-01-20 09:00:00 | 12 | 90 | 2008-01-20 08:55:57 | 330 | 0 | 0 | 12 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
57770 | 2008-01-24 08:00:00 | 17.2 | 90 | 2008-01-24 07:55:53 | 330 | 0 | 0 | 17.2 | 1101000000000000 | 7000000000000000 |
57770 | 2008-01-24 09:00:00 | 37.1 | 90 | 2008-01-24 08:55:54 | 330 | 0 | 0 | 17.5 | 1209000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
57770 | 2008-01-24 10:00:00 | 17.7 | 90 | 2008-01-24 09:55:51 | 330 | 0 | 0 | 17.7 | 1204000000000000 | 5010300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
57770 | 2008-02-02 17:00:00 | 9.7 | 90 | 2008-02-02 16:55:42 | 330 | 0 | 0 | 9.7 | 1101000000000000 | 7000000000000000 |
57770 | 2008-02-02 18:00:00 | 35.3 | 90 | 2008-02-02 17:55:46 | 330 | 0 | 0 | 12.8 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
57770 | 2008-02-02 19:00:00 | 15.8 | 90 | 2008-02-02 18:55:47 | 330 | 0 | 0 | 15.8 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
57770 | 2008-02-21 19:00:00 | 22.5 | 90 | 2008-02-21 18:55:36 | 330 | 0 | 0 | 22.5 | 1101000000000000 | 7000000000000000 |
57770 | 2008-02-21 20:00:00 | 43.2 | 90 | 2008-02-21 19:55:38 | 330 | 0 | 0 | 22.4 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
57770 | 2008-02-21 21:00:00 | 22.3 | 90 | 2008-02-21 20:55:50 | 330 | 0 | 0 | 22.3 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
57770 | 2008-02-22 02:00:00 | 21.8 | 90 | 2008-02-22 01:55:38 | 330 | 0 | 0 | 21.8 | 1101000000000000 | 7000000000000000 |
57770 | 2008-02-22 03:00:00 | 61.3 | 90 | 2008-02-22 02:55:37 | 330 | 0 | 0 | 21.5 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
57770 | 2008-02-22 04:00:00 | 21.2 | 90 | 2008-02-22 03:55:40 | 330 | 0 | 0 | 21.2 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
57770 | 2008-02-22 08:00:00 | 20.7 | 90 | 2008-02-22 07:55:37 | 330 | 0 | 0 | 20.7 | 1101000000000000 | 7000000000000000 |
57770 | 2008-02-22 09:00:00 | 33.6 | 90 | 2008-02-22 08:55:41 | 330 | 0 | 0 | 19.4 | 1209000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
57770 | 2008-02-22 10:00:00 | 18.1 | 90 | 2008-02-22 09:55:39 | 330 | 0 | 0 | 18.1 | 1204000000000000 | 5010300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
58100 | 2008-02-10 19:00:00 | 1.7 | 90 | 2008-02-10 18:49:41 | 311 | 0 | 0 | 1.7 | 1101000000000000 | 7000000000000000 |
58100 | 2008-02-10 20:00:00 | 29.2 | 90 | 2008-02-10 19:49:19 | 311 | 0 | 0 | 2 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
58100 | 2008-02-10 21:00:00 | 2.3 | 90 | 2008-02-10 20:49:42 | 311 | 0 | 0 | 2.3 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
58100 | 2008-02-13 08:00:00 | 2.8 | 90 | 2008-02-13 07:49:30 | 311 | 0 | 0 | 2.8 | 1101000000000000 | 7000000000000000 |
58100 | 2008-02-13 09:00:00 | 20.9 | 90 | 2008-02-13 08:50:15 | 311 | 0 | 0 | 3.3 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
58100 | 2008-02-13 10:00:00 | 3.8 | 90 | 2008-02-13 09:49:14 | 311 | 0 | 0 | 3.8 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
59800 | 2008-01-19 12:00:00 | 20.8 | 90 | 2008-01-19 12:01:42 | 330 | 0 | 0 | 20.8 | 1101000000000000 | 7000000000000000 |
59800 | 2008-01-19 13:00:00 | 43.4 | 90 | 2008-01-19 13:01:43 | 330 | 0 | 0 | 22.9 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
59800 | 2008-01-19 14:00:00 | 25 | 90 | 2008-01-19 14:01:45 | 330 | 0 | 0 | 25 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
59800 | 2008-01-19 21:00:00 | 17.7 | 90 | 2008-01-19 21:16:20 | 330 | 0 | 0 | 17.7 | 1101000000000000 | 7000000000000000 |
59800 | 2008-01-19 22:00:00 | 34.2 | 90 | 2008-01-19 22:01:45 | 330 | 0 | 0 | 16 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
59800 | 2008-01-19 23:00:00 | 14.3 | 90 | 2008-01-19 23:33:36 | 330 | 0 | 0 | 14.3 | 1104000000000000 | 5110300400000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
59800 | 2008-01-24 20:00:00 | 24.2 | 90 | 2008-01-24 20:01:44 | 330 | 0 | 0 | 24.2 | 1101000000000000 | 7000000000000000 |
59800 | 2008-01-24 21:00:00 | 58.3 | 90 | 2008-01-24 21:01:46 | 330 | 0 | 0 | 21.7 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
59800 | 2008-01-24 22:00:00 | 19.1 | 90 | 2008-01-24 22:01:44 | 330 | 0 | 0 | 19.1 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
59800 | 2008-02-22 10:00:00 | 27 | 90 | 2008-02-22 10:01:48 | 330 | 0 | 0 | 27 | 1101000000000000 | 7000000000000000 |
59800 | 2008-02-22 11:00:00 | 43.9 | 90 | 2008-02-22 11:01:49 | 330 | 0 | 0 | 24.1 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
59800 | 2008-02-22 12:00:00 | 21.1 | 90 | 2008-02-22 12:01:53 | 330 | 0 | 0 | 21.1 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
62270 | 2008-01-13 12:00:00 | 2.5 | 90 | 2008-01-13 11:49:52 | 311 | 0 | 0 | 2.5 | 1101000000000000 | 7000000000000000 |
62270 | 2008-01-13 13:00:00 | 16.6 | 90 | 2008-01-13 12:49:55 | 311 | 0 | 0 | 3 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
62270 | 2008-01-13 14:00:00 | 3.5 | 90 | 2008-01-13 13:49:47 | 311 | 0 | 0 | 3.5 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
62270 | 2008-01-17 08:00:00 | 1.9 | 90 | 2008-01-17 07:49:35 | 311 | 0 | 0 | 1.9 | 1101000000000000 | 7000000000000000 |
62270 | 2008-01-17 09:00:00 | 22.9 | 90 | 2008-01-17 08:49:38 | 311 | 0 | 0 | 3 | 1209000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
62270 | 2008-01-17 10:00:00 | 4 | 90 | 2008-01-17 09:49:37 | 311 | 0 | 0 | 4 | 1204000000000000 | 5010300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
62270 | 2008-01-23 00:00:00 | 4.7 | 90 | 2008-01-22 23:49:52 | 311 | 0 | 0 | 4.7 | 1101000000000000 | 7000000000000000 |
62270 | 2008-01-23 01:00:00 | 34.9 | 90 | 2008-01-23 01:22:25 | 311 | 0 | 0 | 5.7 | 1409000000000000 | 5133300400000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
62270 | 2008-01-23 02:00:00 | 6.6 | 90 | 2008-01-23 02:00:45 | 311 | 0 | 0 | 6.6 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
62270 | 2008-01-26 11:00:00 | 13.7 | 90 | 2008-01-26 10:49:41 | 311 | 0 | 0 | 13.7 | 1101000000000000 | 7000000000000000 |
62270 | 2008-01-26 12:00:00 | 73.8 | 90 | 2008-01-26 11:49:40 | 311 | 0 | 0 | 13 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
62270 | 2008-01-26 13:00:00 | 12.2 | 90 | 2008-01-26 12:49:43 | 311 | 0 | 0 | 12.2 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
69100 | 2008-01-17 13:00:00 | 1.7 | 90 | 2008-01-17 12:38:56 | 311 | 0 | 0 | 1.7 | 1101000000000000 | 7100000300000000 |
69100 | 2008-01-17 14:00:00 | 25.77 | 90 | 2008-01-17 13:38:47 | 311 | 0 | 0 | 2 | 1109000000000000 | 5133300300000001 | QC1-3a-90:1,QC1-3a-90:1,QC2d-1
69100 | 2008-01-17 15:00:00 | 2.37 | 90 | 2008-01-17 14:38:45 | 311 | 0 | 0 | 2.37 | 1104000000000000 | 5110300300000001 | QC1-3a-90:1,QC1-3a-90:1,QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
69100 | 2008-02-17 13:00:00 | 1.6 | 90 | 2008-02-17 12:36:49 | 311 | 0 | 0 | 1.6 | 1101000000000000 | 7100000300000000 |
69100 | 2008-02-17 14:00:00 | 20 | 90 | 2008-02-17 13:36:51 | 311 | 0 | 0 | 4 | 1109000000000000 | 5133300300000001 | QC1-3a-90:1,QC1-3a-90:1,QC2d-1
69100 | 2008-02-17 15:00:00 | 6.3 | 90 | 2008-02-17 14:36:51 | 311 | 0 | 0 | 6.3 | 1104000000000000 | 5110300300000001 | QC1-3a-90:1,QC1-3a-90:1,QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
75220 | 2008-02-15 07:00:00 | 4.9 | 90 | 2008-02-15 06:49:15 | 311 | 0 | 0 | 4.9 | 1101000000000000 | 7000000000000000 |
75220 | 2008-02-15 08:00:00 | 69.2 | 90 | 2008-02-15 07:49:08 | 311 | 0 | 0 | 2.5 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
75220 | 2008-02-15 09:00:00 | 0 | 90 | 2008-02-15 08:49:15 | 311 | 0 | 0 | 0 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
76750 | 2008-01-24 18:00:00 | 3.6 | 90 | 2008-01-24 17:51:09 | 311 | 0 | 0 | 3.6 | 1101000000000000 | 7000000000000000 |
76750 | 2008-01-24 19:00:00 | 35.23 | 90 | 2008-01-24 18:51:11 | 311 | 0 | 0 | 5.2 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
76750 | 2008-01-24 20:00:00 | 6.73 | 90 | 2008-01-24 19:51:06 | 311 | 0 | 0 | 6.73 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
77230 | 2008-01-02 22:00:00 | 2.3 | 90 | 2008-01-02 21:52:06 | 311 | 0 | 0 | 2.3 | 1101000000000000 | 7000000000000000 |
77230 | 2008-01-02 23:00:00 | 49.53 | 90 | 2008-01-02 22:52:10 | 311 | 0 | 0 | 2.9 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
77230 | 2008-01-03 00:00:00 | 3.4 | 90 | 2008-01-02 23:52:10 | 311 | 0 | 0 | 3.4 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
77230 | 2008-01-13 11:00:00 | 2.77 | 90 | 2008-01-13 10:52:08 | 311 | 0 | 0 | 2.77 | 1101000000000000 | 7000000000000000 |
77230 | 2008-01-13 12:00:00 | 37.47 | 90 | 2008-01-13 11:52:05 | 311 | 0 | 0 | 5 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
77230 | 2008-01-13 13:00:00 | 7.17 | 90 | 2008-01-13 12:52:04 | 311 | 0 | 0 | 7.17 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
77230 | 2008-01-21 10:00:00 | 1.6 | 90 | 2008-01-21 09:52:09 | 311 | 0 | 0 | 1.6 | 1101000000000000 | 7000000000000000 |
77230 | 2008-01-21 11:00:00 | 53.67 | 90 | 2008-01-21 10:52:08 | 311 | 0 | 0 | 1.9 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
77230 | 2008-01-21 12:00:00 | 2.17 | 90 | 2008-01-21 11:52:10 | 311 | 0 | 0 | 2.17 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
77230 | 2008-02-25 23:00:00 | 1.33 | 90 | 2008-02-25 22:52:06 | 311 | 0 | 0 | 1.33 | 1101000000000000 | 7000000000000000 |
77230 | 2008-02-26 00:00:00 | 14.53 | 90 | 2008-02-25 23:52:06 | 311 | 0 | 0 | 1.3 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
77230 | 2008-02-26 01:00:00 | 1.27 | 90 | 2008-02-26 00:52:10 | 311 | 0 | 0 | 1.27 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
79600 | 2008-01-13 01:00:00 | 3.4 | 90 | 2008-01-14 07:32:53 | 311 | 0 | 0 | 3.4 | 1101000000000000 | 7100000400000000 |
79600 | 2008-01-13 02:00:00 | 58.93 | 90 | 2008-01-13 09:50:19 | 311 | 0 | 0 | 2.7 | 1409000000000000 | 5133300400000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
79600 | 2008-01-13 03:00:00 | 2 | 90 | 2008-01-13 09:50:19 | 311 | 0 | 0 | 2 | 1404000000000000 | 5120300400000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
79600 | 2008-01-21 12:00:00 | 1.93 | 90 | 2008-01-21 11:50:10 | 311 | 0 | 0 | 1.93 | 1101000000000000 | 7000000000000000 |
79600 | 2008-01-21 13:00:00 | 39.57 | 90 | 2008-01-21 12:50:07 | 311 | 0 | 0 | 1.8 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
79600 | 2008-01-21 14:00:00 | 1.6 | 90 | 2008-01-21 13:50:05 | 311 | 0 | 0 | 1.6 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
79600 | 2008-01-26 18:00:00 | 1.3 | 90 | 2008-01-26 17:50:08 | 311 | 0 | 0 | 1.3 | 1101000000000000 | 7000000000000000 |
79600 | 2008-01-26 19:00:00 | 48.8 | 90 | 2008-01-26 18:50:11 | 311 | 0 | 0 | 1.3 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
79600 | 2008-01-26 20:00:00 | 1.2 | 90 | 2008-01-26 19:50:06 | 311 | 0 | 0 | 1.2 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
79600 | 2008-01-27 09:00:00 | 1.1 | 90 | 2008-01-27 08:50:08 | 311 | 0 | 0 | 1.1 | 1101000000000000 | 7000000000000000 |
79600 | 2008-01-27 10:00:00 | 45.83 | 90 | 2008-01-27 09:50:20 | 311 | 0 | 0 | 1.5 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
79600 | 2008-01-27 11:00:00 | 1.9 | 90 | 2008-01-27 10:50:08 | 311 | 0 | 0 | 1.9 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
79600 | 2008-01-27 19:00:00 | 1.37 | 90 | 2008-01-27 18:50:11 | 311 | 0 | 0 | 1.37 | 1101000000000000 | 7000000000000000 |
79600 | 2008-01-27 20:00:00 | 15.27 | 90 | 2008-01-27 19:50:04 | 311 | 0 | 0 | 1.2 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
79600 | 2008-01-27 21:00:00 | 0.97 | 90 | 2008-01-27 20:50:05 | 311 | 0 | 0 | 0.97 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
79600 | 2008-01-27 23:00:00 | 1 | 90 | 2008-01-27 22:50:05 | 311 | 0 | 0 | 1 | 1101000000000000 | 7000000000000000 |
79600 | 2008-01-28 00:00:00 | 51.57 | 90 | 2008-01-27 23:50:09 | 311 | 0 | 0 | 1 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
79600 | 2008-01-28 01:00:00 | 1.07 | 90 | 2008-01-28 01:50:36 | 311 | 0 | 0 | 1.07 | 1404000000000000 | 5120300400000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+------------------------------------------------------
79600 | 2008-02-17 18:00:00 | 1.57 | 90 | 2008-02-17 17:50:06 | 311 | 0 | 0 | 1.57 | 1101000000000000 | 7000000000000000 |
79600 | 2008-02-17 19:00:00 | 55.5 | 90 | 2008-02-17 18:50:14 | 311 | 0 | 0 | 1.9 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC1-1-90:1,QC1-3a-90:1,QC2d-1
79600 | 2008-02-17 20:00:00 | 2.27 | 90 | 2008-02-17 19:50:10 | 311 | 0 | 0 | 2.27 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
80102 | 2008-01-25 00:00:00 | 5.2 | 90 | 2008-01-24 23:49:48 | 330 | 0 | 0 | 5.2 | 1101000000000000 | 7100000300000000 |
80102 | 2008-01-25 01:00:00 | 30 | 90 | 2008-01-25 00:49:34 | 330 | 0 | 0 | 6.2 | 1109000000000000 | 5133300300000001 | QC1-3a-90:1,QC2d-1
80102 | 2008-01-25 02:00:00 | 7.1 | 90 | 2008-01-25 01:49:39 | 330 | 0 | 0 | 7.1 | 1104000000000000 | 5110300300000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
85040 | 2008-01-25 03:00:00 | 8.4 | 90 | 2008-01-25 03:04:07 | 330 | 0 | 0 | 8.4 | 1101000000000000 | 7000000000000000 |
85040 | 2008-01-25 04:00:00 | 57.7 | 90 | 2008-01-25 04:04:00 | 330 | 0 | 0 | 22.8 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
85040 | 2008-01-25 05:00:00 | 37.2 | 90 | 2008-01-25 05:04:07 | 330 | 0 | 0 | 37.2 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
85040 | 2008-02-07 07:00:00 | 16.8 | 90 | 2008-02-07 07:04:14 | 330 | 0 | 0 | 16.8 | 1101000000000000 | 7000000000000000 |
85040 | 2008-02-07 08:00:00 | 45.1 | 90 | 2008-02-07 08:04:17 | 330 | 0 | 0 | 19.9 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
85040 | 2008-02-07 09:00:00 | 22.9 | 90 | 2008-02-07 09:04:16 | 330 | 0 | 0 | 22.9 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
85891 | 2008-01-28 23:00:00 | 28.2 | 90 | 2008-01-28 22:55:30 | 330 | 0 | 0 | 28.2 | 1101000000000000 | 7000000000000000 |
85891 | 2008-01-29 00:00:00 | 43.5 | 90 | 2008-01-28 23:55:33 | 330 | 0 | 0 | 29.3 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
85891 | 2008-01-29 01:00:00 | 30.3 | 90 | 2008-01-29 00:55:28 | 330 | 0 | 0 | 30.3 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
85891 | 2008-02-12 20:00:00 | 21.3 | 90 | 2008-02-12 19:55:29 | 330 | 0 | 0 | 21.3 | 1101000000000000 | 7000000000000000 |
85891 | 2008-02-12 21:00:00 | 37.6 | 90 | 2008-02-12 20:55:28 | 330 | 0 | 0 | 22 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
85891 | 2008-02-12 22:00:00 | 22.7 | 90 | 2008-02-12 21:55:29 | 330 | 0 | 0 | 22.7 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
85891 | 2008-02-13 00:00:00 | 42.3 | 90 | 2008-02-13 01:44:42 | 330 | 0 | 0 | 42.3 | 1101000000000000 | 7100000400000000 |
85891 | 2008-02-13 01:00:00 | 57.5 | 90 | 2008-02-13 01:18:30 | 330 | 0 | 0 | 36.4 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
85891 | 2008-02-13 02:00:00 | 30.4 | 90 | 2008-02-13 01:55:33 | 330 | 0 | 0 | 30.4 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
91740 | 2008-01-10 11:00:00 | 2.2 | 90 | 2008-01-10 11:04:54 | 311 | 0 | 0 | 2.2 | 1101000000000000 | 7000000000000000 |
91740 | 2008-01-10 12:00:00 | 47.3 | 90 | 2008-01-10 12:04:50 | 311 | 0 | 0 | 2.5 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
91740 | 2008-01-10 13:00:00 | 2.7 | 90 | 2008-01-10 13:04:53 | 311 | 0 | 0 | 2.7 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
91740 | 2008-02-26 13:00:00 | 2.4 | 90 | 2008-02-26 13:05:18 | 311 | 0 | 0 | 2.4 | 1101000000000000 | 7000000000000000 |
91740 | 2008-02-26 14:00:00 | 19.6 | 90 | 2008-02-26 14:05:16 | 311 | 0 | 0 | 3.3 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
91740 | 2008-02-26 15:00:00 | 4.1 | 90 | 2008-02-26 15:05:15 | 311 | 0 | 0 | 4.1 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
94280 | 2008-02-20 08:00:00 | 2 | 90 | 2008-02-20 07:51:00 | 311 | 0 | 0 | 2 | 1101000000000000 | 7000000000000000 |
94280 | 2008-02-20 09:00:00 | 18.9 | 90 | 2008-02-20 08:50:57 | 311 | 0 | 0 | 4 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
94280 | 2008-02-20 10:00:00 | 5.9 | 90 | 2008-02-20 09:50:57 | 311 | 0 | 0 | 5.9 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
94280 | 2008-02-26 19:00:00 | 2.6 | 90 | 2008-02-26 18:51:01 | 311 | 0 | 0 | 2.6 | 1101000000000000 | 7000000000000000 |
94280 | 2008-02-26 20:00:00 | 62.6 | 90 | 2008-02-26 19:51:04 | 311 | 0 | 0 | 3.3 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
94280 | 2008-02-26 21:00:00 | 4 | 90 | 2008-02-26 20:51:06 | 311 | 0 | 0 | 4 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
99760 | 2008-01-04 15:00:00 | 4.63 | 90 | 2008-01-04 14:52:07 | 311 | 0 | 0 | 4.63 | 1101000000000000 | 7000000000000000 |
99760 | 2008-01-04 16:00:00 | 33.17 | 90 | 2008-01-04 15:52:07 | 311 | 0 | 0 | 3.5 | 1209000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
99760 | 2008-01-04 17:00:00 | 2.3 | 90 | 2008-01-04 16:52:06 | 311 | 0 | 0 | 2.3 | 1204000000000000 | 5010300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
99760 | 2008-01-05 19:00:00 | 3.07 | 90 | 2008-01-05 18:52:09 | 311 | 0 | 0 | 3.07 | 1101000000000000 | 7000000000000000 |
99760 | 2008-01-05 20:00:00 | 17 | 90 | 2008-01-05 19:52:08 | 311 | 0 | 0 | 3.6 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
99760 | 2008-01-05 21:00:00 | 4.17 | 90 | 2008-01-05 20:52:05 | 311 | 0 | 0 | 4.17 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
99760 | 2008-01-06 23:00:00 | 1.5 | 90 | 2008-01-06 22:52:09 | 311 | 0 | 0 | 1.5 | 1101000000000000 | 7000000000000000 |
99760 | 2008-01-07 00:00:00 | 50.3 | 90 | 2008-01-06 23:52:02 | 311 | 0 | 0 | 1.4 | 1409000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
99760 | 2008-01-07 01:00:00 | 1.2 | 90 | 2008-01-07 00:52:09 | 311 | 0 | 0 | 1.2 | 1404000000000000 | 5020300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
99760 | 2008-01-07 07:00:00 | 1.6 | 90 | 2008-01-07 06:52:06 | 311 | 0 | 0 | 1.6 | 1101000000000000 | 7000000000000000 |
99760 | 2008-01-07 08:00:00 | 31.6 | 90 | 2008-01-07 07:52:05 | 311 | 0 | 0 | 1.9 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
99760 | 2008-01-07 09:00:00 | 2.27 | 90 | 2008-01-07 08:52:06 | 311 | 0 | 0 | 2.27 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------------------
99760 | 2008-01-10 08:00:00 | 1.67 | 90 | 2008-01-10 09:18:09 | 311 | 0 | 0 | 1.67 | 1101000000000000 | 7100000400000000 |
99760 | 2008-01-10 09:00:00 | 34.8 | 90 | 2008-01-10 08:52:07 | 311 | 0 | 0 | 1.7 | 1209000000000000 | 5033300000000002 | QC1-1-90:1,QC1-3a-90:1,QC2d-1
99760 | 2008-01-10 10:00:00 | 1.7 | 90 | 2008-01-10 09:52:07 | 311 | 0 | 0 | 1.7 | 1204000000000000 | 5010300000000002 | QC1-3a-90:1,QC2d-1
(3 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------
99760 | 2008-01-10 15:00:00 | 2 | 90 | 2008-01-10 14:52:11 | 311 | 0 | 0 | 2 | 1101000000000000 | 7000000000000000 |
99760 | 2008-01-10 16:00:00 | 17.43 | 90 | 2008-01-10 15:52:08 | 311 | 0 | 0 | 2 | 1109000000000000 | 5033300000000001 | QC1-3a-90:1,QC2d-1
99760 | 2008-01-10 17:00:00 | 1.97 | 90 | 2008-01-10 16:52:05 | 311 | 0 | 0 | 1.97 | 1104000000000000 | 5010300000000001 | QC1-3a-90:1,QC2d-1
(3 rows)
FEB 2011
Reference Specification: https://kvalobs.wiki.met.no/doku.php?id=kvoss:system:qc2:requirements:algorithms:diptest02
In this variation fs=2 is only checked for the point at (t-1), but this seems to generate some undesired effects. The algorithm that requires fs=2 for both (t) and (t-1) performed better.
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------------------
38140 | 2011-02-09 22:00:00 | 1 | 87 | 2011-02-09 22:03:47.563418 | 342 | 0 | 0 | 1 | 0101000000000000 | 7000000000000000 |
38140 | 2011-02-09 23:00:00 | 1 | 87 | 2011-02-09 23:03:49.217217 | 342 | 0 | 0 | 1 | 0101000000000000 | 7000000000000000 |
38140 | 2011-02-10 00:00:00 | 36.4 | 87 | 2011-02-10 00:03:43 | 342 | 0 | 0 | 18.1 | 0409000000000000 | 5033300000000002 | QC1-1-87,QC1-3a-87,QC1-1-87,QC1-3a-87,QC2d-1
38140 | 2011-02-10 01:00:00 | 35.2 | 87 | 2011-02-10 01:03:43 | 342 | 0 | 0 | 35.2 | 0404000000000000 | 5020300000000002 | QC1-1-87,QC1-1-87,QC2d-1
38140 | 2011-02-10 02:00:00 | 35.2 | 87 | 2011-02-10 02:03:46.453178 | 342 | 0 | 0 | 35.2 | 0401000000000000 | 7020100000000001 | QC1-1-87,QC1-1-87
38140 | 2011-02-10 03:00:00 | 0 | 87 | 2011-02-10 03:03:40.679786 | 342 | 0 | 0 | 0 | 0102000000000000 | 7010300000000001 | QC1-3a-87,QC1-3a-87
38140 | 2011-02-10 04:00:00 | 0 | 87 | 2011-02-10 04:04:46.648117 | 342 | 0 | 0 | 0 | 0101000000000000 | 7000000000000000 |
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+------------------
94500 | 2011-02-11 22:00:00 | 20 | 90 | 2011-02-11 21:52:31.70266 | 330 | 0 | 0 | 20 | 0111000000000000 | 7000000000000000 |
94500 | 2011-02-11 23:00:00 | 6.6 | 90 | 2011-02-11 22:52:24 | 330 | 0 | 0 | 14.3 | 0119000000000000 | 5033300000000001 | QC1-3a-90,QC2d-1
94500 | 2011-02-12 00:00:00 | 8.6 | 90 | 2011-02-11 23:52:28 | 330 | 0 | 0 | 8.6 | 0114000000000000 | 5010300000000001 | QC2d-1
94500 | 2011-02-12 01:00:00 | 10.9 | 90 | 2011-02-12 00:52:27.309979 | 330 | 0 | 0 | 10.9 | 0111000000000000 | 7000000000000000 |
94500 | 2011-02-12 02:00:00 | 1.6 | 90 | 2011-02-12 01:52:31.394062 | 330 | 0 | 0 | 1.6 | 0111000000000000 | 7000000000000000 |
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------
38140 | 2011-02-09 22:00:00 | 2.1 | 90 | 2011-02-09 22:03:47.563418 | 342 | 0 | 0 | 2.1 | 0101000000000000 | 7000000000000000 |
38140 | 2011-02-09 23:00:00 | 4.4 | 90 | 2011-02-09 23:03:49.217217 | 342 | 0 | 0 | 4.4 | 0101000000000000 | 7000000000000000 |
38140 | 2011-02-10 00:00:00 | 46.3 | 90 | 2011-02-10 00:03:43 | 342 | 0 | 0 | 19.85 | 0109000000000000 | 5033300000000001 | QC1-3a-90,QC1-3a-90,QC2d-1
38140 | 2011-02-10 01:00:00 | 35.3 | 90 | 2011-02-10 01:03:43 | 342 | 0 | 0 | 35.3 | 0104000000000000 | 5010300000000001 | QC2d-1
38140 | 2011-02-10 02:00:00 | 35.3 | 90 | 2011-02-10 02:03:46.453178 | 342 | 0 | 0 | 35.3 | 0101000000000000 | 7000000000000000 |
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+-------------------
29400 | 2011-02-12 12:00:00 | -28 | 213 | 2011-02-12 12:55:52.63197 | 330 | 0 | 0 | -28 | 0111000000000000 | 7100000400000000 |
29400 | 2011-02-12 13:00:00 | -25.2 | 213 | 2011-02-12 12:55:48.98915 | 330 | 0 | 0 | -25.2 | 0111000000000000 | 7000000000000000 |
29400 | 2011-02-12 14:00:00 | -11.4 | 213 | 2011-02-12 13:55:48 | 330 | 0 | 0 | -19 | 0119000000000000 | 5033300000000001 | QC1-3a-213,QC2d-1
29400 | 2011-02-12 15:00:00 | -12.8 | 213 | 2011-02-12 14:55:50 | 330 | 0 | 0 | -12.8 | 0114000000000000 | 5010300000000001 | QC2d-1
29400 | 2011-02-12 16:00:00 | -13.3 | 213 | 2011-02-12 15:55:45.955979 | 330 | 0 | 0 | -13.3 | 0111000000000000 | 7000000000000000 |
(5 rows)
Reference Specification: https://kvalobs.wiki.met.no/doku.php?id=kvoss:system:qc2:requirements:algorithms:diptest01
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+------------------
94500 | 2011-02-11 19:00:00 | 12.4 | 87 | 2011-02-11 18:52:24.728471 | 330 | 0 | 0 | 12.4 | 0111000000000000 | 7000000000000000 |
94500 | 2011-02-11 20:00:00 | 7.3 | 87 | 2011-02-11 19:52:28.140128 | 330 | 0 | 0 | 7.3 | 0111000000000000 | 7000000000000000 |
94500 | 2011-02-11 21:00:00 | 1.4 | 87 | 2011-02-11 20:52:27.962884 | 330 | 0 | 0 | 1.4 | 0111000000000000 | 7000000000000000 |
94500 | 2011-02-11 22:00:00 | 13.5 | 87 | 2011-02-11 21:52:31 | 330 | 0 | 0 | 2.4 | 0119000000000000 | 5033300000000001 | QC1-3a-87,QC2d-1
94500 | 2011-02-11 23:00:00 | 3.4 | 87 | 2011-02-11 22:52:24 | 330 | 0 | 0 | 3.4 | 0114000000000000 | 5010300000000001 | QC1-3a-87,QC2d-1
94500 | 2011-02-12 00:00:00 | 5.1 | 87 | 2011-02-11 23:52:28.986602 | 330 | 0 | 0 | 5.1 | 0111000000000000 | 7000000000000000 |
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+----------------------------+--------+--------+-------+-----------+------------------+------------------+---------------------------
79600 | 2011-02-12 02:00:00 | 2.9 | 90 | 2011-02-12 01:53:14.380216 | 311 | 0 | 0 | 2.9 | 0101000000000000 | 7000000000000000 |
79600 | 2011-02-12 03:00:00 | 2.1 | 90 | 2011-02-12 02:53:28.683869 | 311 | 0 | 0 | 2.1 | 0101000000000000 | 7000000000000000 |
79600 | 2011-02-12 04:00:00 | 8.6 | 90 | 2011-02-12 03:53:09.153196 | 311 | 0 | 0 | 8.6 | 0101000000000000 | 7000000000000000 |
79600 | 2011-02-12 05:00:00 | 54.9 | 90 | 2011-02-12 04:53:15 | 311 | 0 | 0 | 7.1 | 0409000000000000 | 5033300000000002 | QC1-1-90,QC1-3a-90,QC2d-1
79600 | 2011-02-12 06:00:00 | 5.6 | 90 | 2011-02-12 05:53:10 | 311 | 0 | 0 | 5.6 | 0404000000000000 | 5020300000000002 | QC1-3a-90,QC2d-1
79600 | 2011-02-12 07:00:00 | 3.2 | 90 | 2011-02-12 06:53:02.747584 | 311 | 0 | 0 | 3.2 | 0101000000000000 | 7000000000000000 |
79600 | 2011-02-12 08:00:00 | 2.1 | 90 | 2011-02-12 07:53:04.726599 | 311 | 0 | 0 | 2.1 | 0101000000000000 | 7000000000000000 |
79600 | 2011-02-12 09:00:00 | 58.4 | 90 | 2011-02-12 08:53:15 | 311 | 0 | 0 | 2.6 | 0409000000000000 | 5033300000000002 | QC1-1-90,QC1-3a-90,QC2d-1
79600 | 2011-02-12 10:00:00 | 3.1 | 90 | 2011-02-12 09:53:10 | 311 | 0 | 0 | 3.1 | 0404000000000000 | 5020300000000002 | QC1-3a-90,QC2d-1
79600 | 2011-02-12 11:00:00 | 3 | 90 | 2011-02-12 10:53:22.675885 | 311 | 0 | 0 | 3 | 0101000000000000 | 7000000000000000 |
79600 | 2011-02-12 12:00:00 | 2.7 | 90 | 2011-02-12 11:53:16.57737 | 311 | 0 | 0 | 2.7 | 0101000000000000 | 7000000000000000 |
DEC 2010
Reference Specification: https://kvalobs.wiki.met.no/doku.php?id=kvoss:system:qc2:requirements:algorithms:diptest01
kvalobs=# select * from data WHERE obstime between '2010-12-30 17:0:0' and '2010-12-30 22:00:00' and paramid=211 and stationid=27010; stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------
27010 | 2010-12-30 17:00:00 | -12.6 | 211 | 2010-12-30 17:08:38 | 330 | 0 | 0 | -12.6 | 0111100000100010 | 7000000000000000 |
27010 | 2010-12-30 18:00:00 | -11.9 | 211 | 2010-12-30 18:14:10 | 330 | 0 | 0 | -11.9 | 0111100000100010 | 7000000000000000 |
27010 | 2010-12-30 19:00:00 | -1.3 | 211 | 2010-12-30 19:04:57 | 330 | 0 | 0 | -11.3 | 0119100000100010 | 5033300000000001 | QC1-3a-211,QC2d-1
27010 | 2010-12-30 20:00:00 | -10.7 | 211 | 2010-12-30 20:05:00 | 330 | 0 | 0 | -10.7 | 0114100000100010 | 5010300000000001 | QC1-3a-211,QC2d-1
27010 | 2010-12-30 21:00:00 | -12 | 211 | 2010-12-30 21:06:47 | 330 | 0 | 0 | -12 | 0111100000100010 | 7000000000000000 |
27010 | 2010-12-30 22:00:00 | -12.9 | 211 | 2010-12-30 22:04:32 | 330 | 0 | 0 | -12.9 | 0111100000100010 | 7000000000000000 |
(6 rows)
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-----------------------------
2650 | 2011-01-12 09:00:00 | -3.5 | 215 | 2011-01-12 08:56:21 | 330 | 0 | 0 | -3.5 | 0111000000000010 | 7000000000000000 |
2650 | 2011-01-12 10:00:00 | 25.8 | 215 | 2011-01-12 09:51:06 | 330 | 0 | 0 | -3 | 0419000000000010 | 5033300000000002 | QC1-1-215,QC1-3a-215,QC2d-1
2650 | 2011-01-12 11:00:00 | -2.5 | 215 | 2011-01-12 10:51:05 | 330 | 0 | 0 | -2.5 | 0414000000000010 | 5010300000000002 | QC1-3a-215,QC2d-1
2650 | 2011-01-12 12:00:00 | -2.5 | 215 | 2011-01-12 11:51:06 | 330 | 0 | 0 | -2.5 | 0111000000000010 | 7000000000000000 |
2650 | 2011-01-12 13:00:00 | -2 | 215 | 2011-01-12 12:51:05 | 330 | 0 | 0 | -2 | 0111000000000010 | 7000000000000000 |
2650 | 2011-01-12 14:00:00 | -2.6 | 215 | 2011-01-12 13:51:02 | 330 | 0 | 0 | -2.6 | 0111000000000010 | 7000000000000000 |
2650 | 2011-01-12 15:00:00 | -4.5 | 215 | 2011-01-12 14:51:06 | 330 | 0 | 0 | -4.5 | 0111000000000010 | 7000000000000000 |
(7 rows)
kvalobs=#
check this other case … something went wrong:
kvalobs=# select * from data_history WHERE obstime between '2011-01-15 00:00:00' and '2011-01-15 05:00:00' and paramid=211 and stationid=10380 order by obstime, modificationtime; version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime -----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+-------------------+---------------------------- 111992720 | 10380 | 2011-01-15 00:00:00 | -24.8 | 211 | 2011-01-14 23:54:25 | 311 | 0 | 0 | -24.8 | 0000000000000000 | 9999900000000000 | | 2011-01-14 23:54:25.639965 111992837 | 10380 | 2011-01-15 00:00:00 | -24.8 | 211 | 2011-01-14 23:54:25 | 311 | 0 | 0 | -24.8 | 0111100000100010 | 7000000000000000 | | 2011-01-14 23:54:31.110964 112002383 | 10380 | 2011-01-15 01:00:00 | -17.3 | 211 | 2011-01-15 00:54:24 | 311 | 0 | 0 | -17.3 | 0000000000000000 | 9999900000000000 | | 2011-01-15 00:54:24.754625 112002452 | 10380 | 2011-01-15 01:00:00 | -17.3 | 211 | 2011-01-15 00:54:24 | 311 | 0 | 0 | -17.3 | 0112100000100010 | 7010300000000001 | QC1-3a-211 | 2011-01-15 00:54:27.219503 113049280 | 10380 | 2011-01-15 01:00:00 | | 211 | 2011-01-15 00:54:24 | 311 | 0 | 0 | | | | | 2011-01-19 21:59:26.237642 113049281 | 10380 | 2011-01-15 01:00:00 | -17.3 | 211 | 2011-01-15 00:54:24 | 311 | 0 | 0 | 0 | 0119100000100010 | 5033300000000001 | QC1-3a-211,QC2d-1 | 2011-01-19 21:59:26.366322 112012547 | 10380 | 2011-01-15 02:00:00 | -9.8 | 211 | 2011-01-15 01:54:24 | 311 | 0 | 0 | -9.8 | 0000000000000000 | 9999900000000000 | | 2011-01-15 01:54:24.698061 112012616 | 10380 | 2011-01-15 02:00:00 | -9.8 | 211 | 2011-01-15 01:54:24 | 311 | 0 | 0 | -9.8 | 0112100000100010 | 7010300000000001 | QC1-3a-211 | 2011-01-15 01:54:26.708917 113049282 | 10380 | 2011-01-15 02:00:00 | | 211 | 2011-01-15 01:54:24 | 311 | 0 | 0 | | | | | 2011-01-19 21:59:26.411919 113049283 | 10380 | 2011-01-15 02:00:00 | -9.8 | 211 | 2011-01-15 01:54:24 | 311 | 0 | 0 | -9.8 | 0114100000100010 | 5010300000000001 | QC1-3a-211,QC2d-1 | 2011-01-19 21:59:26.437011 112020555 | 10380 | 2011-01-15 03:00:00 | -10.6 | 211 | 2011-01-15 02:54:27 | 311 | 0 | 0 | -10.6 | 0000000000000000 | 9999900000000000 | | 2011-01-15 02:54:27.555131 112020640 | 10380 | 2011-01-15 03:00:00 | -10.6 | 211 | 2011-01-15 02:54:27 | 311 | 0 | 0 | -10.6 | 0111100000100010 | 7000000000000000 | | 2011-01-15 02:54:29.893188 112028858 | 10380 | 2011-01-15 04:00:00 | -11 | 211 | 2011-01-15 03:54:23 | 311 | 0 | 0 | -11 | 0000000000000000 | 9999900000000000 | | 2011-01-15 03:54:23.666946 112029137 | 10380 | 2011-01-15 04:00:00 | -11 | 211 | 2011-01-15 03:54:23 | 311 | 0 | 0 | -11 | 0111100000100010 | 7000000000000000 | | 2011-01-15 03:54:40.472211 112036834 | 10380 | 2011-01-15 05:00:00 | -10 | 211 | 2011-01-15 04:54:24 | 311 | 0 | 0 | -10 | 0000000000000000 | 9999900000000000 | | 2011-01-15 04:54:24.15591 112037080 | 10380 | 2011-01-15 05:00:00 | -10 | 211 | 2011-01-15 04:54:24 | 311 | 0 | 0 | -10 | 0111100000100010 | 7000000000000000 | | 2011-01-15 04:54:40.554491 (16 rows)
OLDER
Testing First Implementation
This example uses paramid=174, POM (below is more details for PON but that case was a bit muddled due to running the algorithm twice, the POM case just demonstrates clean operation of the algorithm and the flag changes).
The Data:
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------
33890 | 2006-12-19 07:00:00 | 918.8 | 174 | 2006-12-19 09:04:48 | 3 | 0 | 0 | 918.8 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-19 08:00:00 | 879.7 | 174 | 2006-12-19 09:04:48 | 3 | 0 | 0 | 916.55 | 1109000000000000 | 5133300400000001 | QC1-3a-174:1,QC2d-1
33890 | 2006-12-19 09:00:00 | 914.3 | 174 | 2006-12-19 09:04:48 | 3 | 0 | 0 | 914.3 | 1104000000000000 | 5010300000000001 | QC1-3a-174:1,QC2d-1
33890 | 2006-12-19 10:00:00 | 918.2 | 174 | 2006-12-19 12:05:03 | 3 | 0 | 0 | 918.2 | 1101000000000000 | 7100000400000000 |
(4 rows)
Data History:
version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime ---------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------+---------------------------- 1813657 | 33890 | 2006-12-19 08:00:00 | 879.7 | 174 | 2006-12-19 09:04:48 | 3 | 0 | 0 | 879.7 | 1102000000000000 | 7110300400000001 | QC1-3a-174:1 | 2010-12-22 00:32:30.118469 3074694 | 33890 | 2006-12-19 08:00:00 | | 174 | 2006-12-19 09:04:48 | 3 | 0 | 0 | | | | | 2011-01-04 00:50:42.286332 3074695 | 33890 | 2006-12-19 08:00:00 | 879.7 | 174 | 2006-12-19 09:04:48 | 3 | 0 | 0 | 916.55 | 1109000000000000 | 5133300400000001 | QC1-3a-174:1,QC2d-1 | 2011-01-04 00:50:42.32538 (3 rows) version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime ---------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+---------------------+---------------------------- 1817930 | 33890 | 2006-12-19 09:00:00 | 914.3 | 174 | 2006-12-19 09:04:48 | 3 | 0 | 0 | 914.3 | 1102000000000000 | 7010300000000001 | QC1-3a-174:1 | 2010-12-22 00:32:30.118469 3074696 | 33890 | 2006-12-19 09:00:00 | | 174 | 2006-12-19 09:04:48 | 3 | 0 | 0 | | | | | 2011-01-04 00:50:42.35075 3074697 | 33890 | 2006-12-19 09:00:00 | 914.3 | 174 | 2006-12-19 09:04:48 | 3 | 0 | 0 | 914.3 | 1104000000000000 | 5010300000000001 | QC1-3a-174:1,QC2d-1 | 2011-01-04 00:50:42.366671 (3 rows)
This next example uses paramid=175, PON
NB The interpolated values (with fs=9) are not yet “ROUNDED” in this example. Also the algorithm was run twice (hence two QC2d-1 in Cfailed (the first time controlinfo was not updated due to a bug)).
version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime ---------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------+---------------------------- 2234843 | 33890 | 2006-12-23 17:00:00 | 932.3 | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | 932.3 | 1102000000000000 | 7110300400000001 | QC1-3a-175:1 | 2010-12-22 00:32:30.118469 3074494 | 33890 | 2006-12-23 17:00:00 | | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | | | | | 2011-01-02 21:17:13.627398 3074495 | 33890 | 2006-12-23 17:00:00 | 932.3 | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | 914 | 1102000000000000 | 7110300400000001 | QC1-3a-175:1,QC2d-1 | 2011-01-02 21:17:13.67768 3074566 | 33890 | 2006-12-23 17:00:00 | | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | | | | | 2011-01-02 21:50:28.326757 3074567 | 33890 | 2006-12-23 17:00:00 | 932.3 | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | 914 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1 | 2011-01-02 21:50:28.350528 (5 rows) version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime ---------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------+---------------------------- 2238799 | 33890 | 2006-12-23 18:00:00 | 911.6 | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | 911.6 | 1102000000000000 | 7010300000000001 | QC1-3a-175:1 | 2010-12-22 00:32:30.118469 3074496 | 33890 | 2006-12-23 18:00:00 | | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | | | | | 2011-01-02 21:17:13.695019 3074497 | 33890 | 2006-12-23 18:00:00 | 911.6 | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | 911.6 | 1102000000000000 | 7010300000000001 | QC1-3a-175:1,QC2d-1 | 2011-01-02 21:17:13.727396 3074568 | 33890 | 2006-12-23 18:00:00 | | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | | | | | 2011-01-02 21:50:28.359746 3074569 | 33890 | 2006-12-23 18:00:00 | 911.6 | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | 911.6 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1 | 2011-01-02 21:50:28.375331 (5 rows)
33890 | 2006-12-18 16:00:00 | 901.8 | 175 | 2006-12-18 18:01:47 | 3 | 0 | 0 | 901.8 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-18 17:00:00 | 905 | 175 | 2006-12-18 18:01:47 | 3 | 0 | 0 | 905 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-18 18:00:00 | 904.3 | 175 | 2006-12-18 18:01:47 | 3 | 0 | 0 | 904.3 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-18 19:00:00 | 905 | 175 | 2006-12-18 21:02:38 | 3 | 0 | 0 | 905 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-18 20:00:00 | 924.7 | 175 | 2006-12-18 21:02:38 | 3 | 0 | 0 | 905.65 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-18 21:00:00 | 906.3 | 175 | 2006-12-18 21:02:38 | 3 | 0 | 0 | 906.3 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-18 22:00:00 | 897.9 | 175 | 2006-12-19 00:02:37 | 3 | 0 | 0 | 897.9 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-18 23:00:00 | 907.4 | 175 | 2006-12-19 00:02:37 | 3 | 0 | 0 | 907.4 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-20 21:00:00 | 932.5 | 175 | 2006-12-20 21:02:31 | 3 | 0 | 0 | 932.5 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-20 22:00:00 | 932.3 | 175 | 2006-12-21 00:01:48 | 3 | 0 | 0 | 932.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-20 23:00:00 | 911.6 | 175 | 2006-12-21 00:01:48 | 3 | 0 | 0 | 933.95 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-21 00:00:00 | 935.6 | 175 | 2006-12-21 00:11:13 | 3 | 0 | 0 | 935.6 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-21 01:00:00 | 935.5 | 175 | 2006-12-21 03:01:50 | 3 | 0 | 0 | 935.5 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-21 02:00:00 | 916.9 | 175 | 2006-12-21 03:01:50 | 3 | 0 | 0 | 935.5 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-21 03:00:00 | 935.5 | 175 | 2006-12-21 03:01:50 | 3 | 0 | 0 | 935.5 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-21 04:00:00 | 933.2 | 175 | 2006-12-21 06:01:46 | 3 | 0 | 0 | 933.2 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-21 05:00:00 | 932.3 | 175 | 2006-12-21 06:01:46 | 3 | 0 | 0 | 932.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-23 04:00:00 | 898.6 | 175 | 2006-12-23 06:01:47 | 3 | 0 | 0 | 898.6 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-23 05:00:00 | 898.6 | 175 | 2006-12-23 06:01:47 | 3 | 0 | 0 | 898.6 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-23 06:00:00 | 917.9 | 175 | 2006-12-23 06:01:47 | 3 | 0 | 0 | 917.8 | 1109000000000000 | 5033300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-23 07:00:00 | 936.7 | 175 | 2006-12-23 09:01:47 | 3 | 0 | 0 | 936.7 | 1104000000000000 | 5110300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-23 08:00:00 | 899.2 | 175 | 2006-12-23 09:01:47 | 3 | 0 | 0 | 899.2 | 1102000000000000 | 7110300400000001 | QC1-3a-175:1
33890 | 2006-12-23 09:00:00 | 918.1 | 175 | 2006-12-23 09:01:47 | 3 | 0 | 0 | 918.1 | 1102000000000000 | 7010300000000001 | QC1-3a-175:1
33890 | 2006-12-23 10:00:00 | 917.6 | 175 | 2006-12-23 12:01:46 | 3 | 0 | 0 | 917.6 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-23 11:00:00 | 918.1 | 175 | 2006-12-23 12:01:46 | 3 | 0 | 0 | 918.1 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-23 12:00:00 | 899.1 | 175 | 2006-12-23 12:01:46 | 3 | 0 | 0 | 917.8 | 1109000000000000 | 5033300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-23 13:00:00 | 917.5 | 175 | 2006-12-23 15:01:50 | 3 | 0 | 0 | 917.5 | 1104000000000000 | 5110300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-23 14:00:00 | 898.5 | 175 | 2006-12-23 15:01:50 | 3 | 0 | 0 | 898.5 | 1102000000000000 | 7110300400000001 | QC1-3a-175:1
33890 | 2006-12-23 15:00:00 | 917.2 | 175 | 2006-12-23 15:01:50 | 3 | 0 | 0 | 917.2 | 1102000000000000 | 7010300000000001 | QC1-3a-175:1
33890 | 2006-12-23 16:00:00 | 916.4 | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | 916.4 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-23 17:00:00 | 932.3 | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | 914 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-23 18:00:00 | 911.6 | 175 | 2006-12-23 18:01:49 | 3 | 0 | 0 | 911.6 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-23 19:00:00 | 911.7 | 175 | 2006-12-23 21:01:44 | 3 | 0 | 0 | 911.7 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-23 20:00:00 | 911.7 | 175 | 2006-12-23 21:01:44 | 3 | 0 | 0 | 911.7 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-23 21:00:00 | 916.9 | 175 | 2006-12-23 21:01:44 | 3 | 0 | 0 | 916.9 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-23 22:00:00 | 907.4 | 175 | 2006-12-24 00:01:44 | 3 | 0 | 0 | 907.4 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-23 23:00:00 | 900.3 | 175 | 2006-12-24 00:01:44 | 3 | 0 | 0 | 900.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-24 00:00:00 | 915.8 | 175 | 2006-12-24 00:01:44 | 3 | 0 | 0 | 908.7 | 1109000000000000 | 5033300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-24 01:00:00 | 932 | 175 | 2006-12-24 03:01:49 | 3 | 0 | 0 | 932 | 1104000000000000 | 5110300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-24 02:00:00 | 932.3 | 175 | 2006-12-24 03:01:49 | 3 | 0 | 0 | 932.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-24 03:00:00 | 932.3 | 175 | 2006-12-24 03:01:49 | 3 | 0 | 0 | 932.3 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-24 04:00:00 | 906.3 | 175 | 2006-12-24 06:01:45 | 3 | 0 | 0 | 906.3 | 1102000000000000 | 7110300400000001 | QC1-3a-175:1
33890 | 2006-12-24 05:00:00 | 910.1 | 175 | 2006-12-24 06:01:45 | 3 | 0 | 0 | 910.1 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-24 06:00:00 | 906.3 | 175 | 2006-12-24 06:01:45 | 3 | 0 | 0 | 906.3 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-24 07:00:00 | 932 | 175 | 2006-12-24 09:01:44 | 3 | 0 | 0 | 908.7 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-24 08:00:00 | 911.1 | 175 | 2006-12-24 09:01:44 | 3 | 0 | 0 | 911.1 | 1104000000000000 | 5110300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-24 09:00:00 | 903.3 | 175 | 2006-12-24 09:01:44 | 3 | 0 | 0 | 903.3 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-24 10:00:00 | 898.5 | 175 | 2006-12-24 12:01:44 | 3 | 0 | 0 | 898.5 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-24 11:00:00 | 898.6 | 175 | 2006-12-24 12:01:44 | 3 | 0 | 0 | 898.6 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-24 12:00:00 | 917.5 | 175 | 2006-12-24 12:01:44 | 3 | 0 | 0 | 917.5 | 1102000000000000 | 7010300000000001 | QC1-3a-175:1
33890 | 2006-12-24 13:00:00 | 918.1 | 175 | 2006-12-24 15:01:46 | 3 | 0 | 0 | 918.1 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-24 14:00:00 | 922.8 | 175 | 2006-12-24 15:01:46 | 3 | 0 | 0 | 922.8 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-24 15:00:00 | 904.3 | 175 | 2006-12-24 15:01:46 | 3 | 0 | 0 | 920.6 | 1109000000000000 | 5033300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-24 16:00:00 | 918.4 | 175 | 2006-12-24 18:01:44 | 3 | 0 | 0 | 918.4 | 1104000000000000 | 5110300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-24 17:00:00 | 903 | 175 | 2006-12-24 18:01:44 | 3 | 0 | 0 | 903 | 1102000000000000 | 7110300400000001 | QC1-3a-175:1
33890 | 2006-12-24 18:00:00 | 921.4 | 175 | 2006-12-24 18:01:44 | 3 | 0 | 0 | 921.4 | 1102000000000000 | 7010300000000001 | QC1-3a-175:1
33890 | 2006-12-24 19:00:00 | 938.1 | 175 | 2006-12-24 21:01:44 | 3 | 0 | 0 | 938.1 | 1202000000000000 | 7110300400000002 | QC1-1-175:1,QC1-3a-175:1
33890 | 2006-12-24 20:00:00 | 936 | 175 | 2006-12-24 21:01:44 | 3 | 0 | 0 | 936 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-24 21:00:00 | 936.5 | 175 | 2006-12-24 21:01:44 | 3 | 0 | 0 | 936.5 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-24 22:00:00 | 936.3 | 175 | 2006-12-25 00:01:44 | 3 | 0 | 0 | 936.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-24 23:00:00 | 936.4 | 175 | 2006-12-25 00:01:44 | 3 | 0 | 0 | 936.4 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-25 00:00:00 | 936.8 | 175 | 2006-12-25 00:01:44 | 3 | 0 | 0 | 936.8 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-25 01:00:00 | 936.3 | 175 | 2006-12-25 03:01:50 | 3 | 0 | 0 | 936.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-25 02:00:00 | 938.1 | 175 | 2006-12-25 03:01:50 | 3 | 0 | 0 | 938.1 | 1201000000000000 | 7110100400000001 | QC1-1-175:1
33890 | 2006-12-25 03:00:00 | 937.9 | 175 | 2006-12-25 03:01:50 | 3 | 0 | 0 | 937.9 | 1201000000000000 | 7010100000000001 | QC1-1-175:1
33890 | 2006-12-25 04:00:00 | 937.7 | 175 | 2006-12-25 06:01:49 | 3 | 0 | 0 | 937.7 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-25 05:00:00 | 918.7 | 175 | 2006-12-25 06:01:49 | 3 | 0 | 0 | 937.65 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-25 06:00:00 | 937.6 | 175 | 2006-12-25 06:01:49 | 3 | 0 | 0 | 937.6 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-25 07:00:00 | 937.7 | 175 | 2006-12-25 09:01:47 | 3 | 0 | 0 | 937.7 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-25 08:00:00 | 937.9 | 175 | 2006-12-25 09:01:47 | 3 | 0 | 0 | 937.9 | 1201000000000000 | 7110100400000001 | QC1-1-175:1
33890 | 2006-12-25 09:00:00 | 937.8 | 175 | 2006-12-25 09:01:47 | 3 | 0 | 0 | 937.8 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-25 10:00:00 | 937.7 | 175 | 2006-12-25 12:01:47 | 3 | 0 | 0 | 937.7 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-25 11:00:00 | 918.6 | 175 | 2006-12-25 12:01:47 | 3 | 0 | 0 | 909.75 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-25 12:00:00 | 904.3 | 175 | 2006-12-25 12:01:47 | 3 | 0 | 0 | 904.3 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-25 13:00:00 | 917.9 | 175 | 2006-12-25 15:52:06 | 3 | 0 | 0 | 917.9 | 1102000000000000 | 7110300400000001 | QC1-3a-175:1
33890 | 2006-12-25 14:00:00 | 903.3 | 175 | 2006-12-25 15:52:06 | 3 | 0 | 0 | 903.3 | 1102000000000000 | 7110300400000001 | QC1-3a-175:1
33890 | 2006-12-25 15:00:00 | 903.3 | 175 | 2006-12-25 15:52:06 | 3 | 0 | 0 | 903.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-25 16:00:00 | 936 | 175 | 2006-12-25 18:01:46 | 3 | 0 | 0 | 909.75 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-25 17:00:00 | 916.2 | 175 | 2006-12-25 18:01:46 | 3 | 0 | 0 | 916.2 | 1104000000000000 | 5110300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-25 18:00:00 | 904.3 | 175 | 2006-12-25 18:01:46 | 3 | 0 | 0 | 904.3 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-25 19:00:00 | 911.6 | 175 | 2006-12-25 21:01:47 | 3 | 0 | 0 | 911.6 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-25 20:00:00 | 906.3 | 175 | 2006-12-25 21:01:47 | 3 | 0 | 0 | 906.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-25 21:00:00 | 932.3 | 175 | 2006-12-25 21:01:47 | 3 | 0 | 0 | 932.3 | 1102000000000000 | 7010300000000001 | QC1-3a-175:1
33890 | 2006-12-25 22:00:00 | 933.7 | 175 | 2006-12-26 00:01:47 | 3 | 0 | 0 | 933.7 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-25 23:00:00 | 933.2 | 175 | 2006-12-26 00:01:47 | 3 | 0 | 0 | 933.2 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-26 00:00:00 | 932.9 | 175 | 2006-12-26 00:01:47 | 3 | 0 | 0 | 932.9 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-26 01:00:00 | 932.5 | 175 | 2006-12-26 03:01:48 | 3 | 0 | 0 | 932.5 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-26 02:00:00 | 932.2 | 175 | 2006-12-26 03:01:48 | 3 | 0 | 0 | 932.2 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-26 03:00:00 | 932.1 | 175 | 2006-12-26 03:01:48 | 3 | 0 | 0 | 932.1 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-26 04:00:00 | 929.5 | 175 | 2006-12-26 06:01:47 | 3 | 0 | 0 | 929.5 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-26 05:00:00 | 902.3 | 175 | 2006-12-26 06:01:47 | 3 | 0 | 0 | 925.15 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-26 06:00:00 | 920.8 | 175 | 2006-12-26 06:01:47 | 3 | 0 | 0 | 920.8 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-26 07:00:00 | 920.7 | 175 | 2006-12-26 09:01:47 | 3 | 0 | 0 | 920.7 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-26 08:00:00 | 911.7 | 175 | 2006-12-26 09:01:47 | 3 | 0 | 0 | 911.7 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-27 18:00:00 | 893.4 | 175 | 2006-12-27 18:01:47 | 3 | 0 | 0 | 893.4 | 1102000000000000 | 7010300000000001 | QC1-3a-175:1
33890 | 2006-12-27 19:00:00 | 902.4 | 175 | 2006-12-27 21:01:46 | 3 | 0 | 0 | 902.4 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-27 20:00:00 | 876.4 | 175 | 2006-12-27 21:01:46 | 3 | 0 | 0 | 901.35 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-27 21:00:00 | 900.3 | 175 | 2006-12-27 21:01:46 | 3 | 0 | 0 | 900.3 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-27 22:00:00 | 908.3 | 175 | 2006-12-28 00:01:47 | 3 | 0 | 0 | 908.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-27 23:00:00 | 899.7 | 175 | 2006-12-28 00:01:47 | 3 | 0 | 0 | 899.7 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-29 17:00:00 | 872.6 | 175 | 2006-12-29 18:02:31 | 3 | 0 | 0 | 872.6 | 1302000000000000 | 7110300400000002 | QC1-1-175:1,QC1-3a-175:1
33890 | 2006-12-29 18:00:00 | 873.8 | 175 | 2006-12-29 18:02:31 | 3 | 0 | 0 | 873.8 | 1301000000000000 | 7010100000000001 | QC1-1-175:1
33890 | 2006-12-29 19:00:00 | 891.9 | 175 | 2006-12-29 21:02:34 | 3 | 0 | 0 | 874.25 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-29 20:00:00 | 874.7 | 175 | 2006-12-29 21:02:34 | 3 | 0 | 0 | 874.7 | 1104000000000000 | 5110300400000001 | QC1-1-175:1,QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-29 21:00:00 | 875 | 175 | 2006-12-29 21:02:34 | 3 | 0 | 0 | 875 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-29 22:00:00 | 874.5 | 175 | 2006-12-30 00:02:33 | 3 | 0 | 0 | 874.5 | 1301000000000000 | 7110100400000001 | QC1-1-175:1
33890 | 2006-12-29 23:00:00 | 911.8 | 175 | 2006-12-30 00:02:33 | 3 | 0 | 0 | 883.25 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-30 00:00:00 | 892 | 175 | 2006-12-30 00:02:33 | 3 | 0 | 0 | 892 | 1104000000000000 | 5010300000000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-30 01:00:00 | 900.8 | 175 | 2006-12-30 03:02:29 | 3 | 0 | 0 | 900.8 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-30 02:00:00 | 891.3 | 175 | 2006-12-30 03:02:29 | 3 | 0 | 0 | 891.3 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-30 03:00:00 | 896.5 | 175 | 2006-12-30 03:02:29 | 3 | 0 | 0 | 896.5 | 1101000000000000 | 7000000000000000 |
33890 | 2006-12-30 04:00:00 | 868.1 | 175 | 2006-12-30 06:02:35 | 3 | 0 | 0 | 900.45 | 1309000000000000 | 5133300400000002 | QC1-1-175:1,QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-30 05:00:00 | 904.4 | 175 | 2006-12-30 06:02:35 | 3 | 0 | 0 | 904.4 | 1304000000000000 | 5110300400000002 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-30 06:00:00 | 870.4 | 175 | 2006-12-30 06:02:35 | 3 | 0 | 0 | 870.4 | 1302000000000000 | 7010300000000002 | QC1-1-175:1,QC1-3a-175:1
33890 | 2006-12-30 07:00:00 | 872.3 | 175 | 2006-12-30 09:02:32 | 3 | 0 | 0 | 872.3 | 1301000000000000 | 7110100400000001 | QC1-1-175:1
33890 | 2006-12-30 08:00:00 | 872.9 | 175 | 2006-12-30 09:02:32 | 3 | 0 | 0 | 872.9 | 1301000000000000 | 7110100400000001 |
33890 | 2006-12-31 02:00:00 | 875.6 | 175 | 2006-12-31 09:02:03 | 3 | 0 | 0 | 875.6 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-31 03:00:00 | 876 | 175 | 2006-12-31 09:02:03 | 3 | 0 | 0 | 876 | 1101000000000000 | 7100000400000000 |
33890 | 2006-12-31 04:00:00 | 871.6 | 175 | 2006-12-31 09:02:03 | 3 | 0 | 0 | 871.6 | 1301000000000000 | 7110100400000001 | QC1-1-175:1
33890 | 2006-12-31 05:00:00 | 900.2 | 175 | 2006-12-31 09:02:03 | 3 | 0 | 0 | 869.65 | 1109000000000000 | 5133300400000001 | QC1-3a-175:1,QC2d-1,QC2d-1
33890 | 2006-12-31 06:00:00 | 867.7 | 175 | 2006-12-31 09:02:03 | 3 | 0 | 0 | 867.7 | 1104000000000000 | 5110300400000001 | QC1-1-175:1,QC1-3a-175:1,QC2d-1,QC2d-1
(721 rows)
Reference
kvalobs=# select * from data where obstime between '2008-01-01' and '2008-01-31' and substr(controlinfo,4,1)='2' and substr(controlinfo,7,1)>'0';
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+------------------------------------------
76973 | 2008-01-06 00:00:00 | 5 | 211 | 2008-01-28 02:05:13 | 11 | 0 | 0 | -32766 | 14120020001000A0 | 7038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1
71990 | 2008-01-06 19:00:00 | 5.5 | 211 | 2008-01-06 18:54:26 | 330 | 0 | 0 | -32766 | 111220200000001A | 3038900000000082 | QC1-3a-211:1,QC1-4-211:1,hqc
76926 | 2008-01-20 13:00:00 | -14.4 | 211 | 2008-01-20 13:24:04 | 22 | 0 | 0 | -32766 | 15120020000000A0 | 7138300400000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1
76926 | 2008-01-20 13:00:00 | -14.5 | 213 | 2008-01-20 13:24:04 | 22 | 0 | 0 | -32766 | 15120020000000A0 | 7138300400000002 | QC1-1-213:1,QC1-3a-213:1,QC1-9-213:1
76926 | 2008-01-20 17:00:00 | 20 | 212 | 2008-01-20 17:24:06 | 22 | 0 | 0 | -32766 | 14120020000000A0 | 7138300400000002 | QC1-1-212:1,QC1-3a-212:1,QC1-9-212:1
76926 | 2008-01-20 17:00:00 | -49.3 | 213 | 2008-01-20 17:24:06 | 22 | 0 | 0 | -32766 | 15120020000000A0 | 7138300400000002 | QC1-1-213:1,QC1-3a-213:1,QC1-9-213:1
58900 | 2008-01-24 06:00:00 | 17.4 | 215 | 2008-01-24 06:06:38 | 3 | 0 | 0 | 3 | 14120020000000A7 | 3031900000000022 | QC1-1-215:1,QC1-3a-215:1,QC1-9-215:1,hqc
(7 rows)