This is an old revision of the document!
DIP TEST
Testing First Implementation
This example uses paramid=174, POX (below is more details for PON but that case was a bit muddled due to running the algorithm twice, the POX 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 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)