kvalobs:kvoss:system:qc2:test

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
kvalobs:kvoss:system:qc2:test [2010-01-16 23:09:12]
paule 		kvalobs:kvoss:system:qc2:test [2022-05-31 09:29:32] (current)
Line 2: Line 2:
 ====== Test Files ====== ====== Test Files ======
  
-  * ... +  * [[.:test:perf|Results of performance monitoring tests]] 
-  * ...+  * [[.:test:algorithms|Specific tests supporting new algorithm development]]
   * [[.:test:acceptance|Acceptance Test File]]   * [[.:test:acceptance|Acceptance Test File]]
 +  * [[.:test:vm101notes|Installation and test on dev-vm101 notes]]
 +  * [[.:test:flagtests|Flag tests]]
 +  * [[.:test:SLv32|Single Linear version 3.2 test]]
 +  * [[.:test:trpt|Template for official test report]] [[.:test:trpt-en|EN]]
 +  * [[.:test:downstream|Tests to propagate data downstream]]
  
 ====== Case Studies ====== ====== Case Studies ======
  
 An interesting example to test in a space-time-qc. A sudden drop (10 degrees) in temp caused by front-passage gives error message in QC1. To be granted in QC2. An interesting example to test in a space-time-qc. A sudden drop (10 degrees) in temp caused by front-passage gives error message in QC1. To be granted in QC2.
-{{:kvoss:system:qc2:1292gartland140709kl14.png?400|1292gartland140709kl14}}|{{:kvoss:system:qc2:1292gartland140709kl14lyn.png?400|1292gartland140709kl14lyn}}+{{kvalobs:kvoss:system:qc2:1292gartland140709kl14.png?400|1292gartland140709kl14}}|{{kvalobs:kvoss:system:qc2:1292gartland140709kl14lyn.png?400|1292gartland140709kl14lyn}}
  
  
 **Station Gartland, Trøndelag 14 july 2009** **Station Gartland, Trøndelag 14 july 2009**
  
-Corresponding {{:kvoss:system:qc2:20090714event.doc|data}} series (two-days spanning).+Corresponding {{kvalobs:kvoss:system:qc2:20090714event.doc|data}} series (two-days spanning).
  
  
Line 36: Line 41:
 </code> </code>
  
 +FIXME ... NB some old data files had 'NULL' for cfailed where the filed was empty. Later found that it was cleaner to use just "", i.e. no string, since NULL value did not allow string concatenation. Later files uploaded to the wiki do not use null.
 +
 +**Some other reference data**
 +
 +   * {{kvalobs:kvoss:system:qc2:2018-diptest.dat.gz|2018 Simulated DipTest test data.}}
  
 ====== Using generator.pl ====== ====== Using generator.pl ======
Line 189: Line 199:
      18500 | 2032-03-01 20:00:00 |     21.7 |     110 | 2032-03-01 19:50:04 |    342 | 0      |     0 |      21.7 | 1100000000000000 | 7000000000000000 |       18500 | 2032-03-01 20:00:00 |     21.7 |     110 | 2032-03-01 19:50:04 |    342 | 0      |     0 |      21.7 | 1100000000000000 | 7000000000000000 | 
      18500 | 2032-03-01 21:00:00 |     19.9 |     110 | 2032-03-01 20:50:10 |    342 | 0      |     0 |      19.9 | 1100000000000000 | 7000000000000000 |A      18500 | 2032-03-01 21:00:00 |     19.9 |     110 | 2032-03-01 20:50:10 |    342 | 0      |     0 |      19.9 | 1100000000000000 | 7000000000000000 |A
 +</code>
 +
 +===== Some recent results from dev-vm116 April 2010 =====
 +
 +<code>
 +kvalobs=# select * from data WHERE obstime>'2010-03-28' and obstime<'2010-04-10' and cfailed like '%Qc2%' and paramid=110;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                        cfailed                         
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------------------
 +     22951 | 2010-03-28 06:00:00 |      0.6 |     110 | 2010-03-28 16:30:35 |    302 | 0      |     0 |       0.1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:0.6
 +     53950 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:36 |    302 | 0      |     0 |        -1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     53950 | 2010-03-29 06:00:00 |       -1 |     110 | 2010-03-29 11:41:24 |    302 | 0      |     0 |        -1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-1
 +     53730 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:33 |    302 | 0      |     0 |        -1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     53730 | 2010-03-29 06:00:00 |       -1 |     110 | 2010-03-29 11:40:23 |    302 | 0      |     0 |        -1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-1
 +     58480 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:37 |    302 | 0      |     0 |       0.8 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767,QC1-7-110:1
 +     46700 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:24 |    302 | 0      |     0 |       3.1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     46700 | 2010-03-29 06:00:00 |       10 |     110 | 2010-03-29 06:44:24 |    302 | 0      |     0 |       5.7 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:10
 +     81370 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:41 |    302 | 0      |     0 |        -1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     81370 | 2010-03-29 06:00:00 |       -1 |     110 | 2010-03-29 05:55:21 |    302 | 0      |     0 |        -1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-1
 +     55930 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:38 |    302 | 0      |     0 |       1.2 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     55930 | 2010-03-29 06:00:00 |      5.7 |     110 | 2010-03-29 05:55:21 |    302 | 0      |     0 |       2.6 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:5.7
 +     48780 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:34 |    302 | 0      |     0 |       1.2 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     48780 | 2010-03-29 06:00:00 |      3.7 |     110 | 2010-03-29 05:48:46 |    302 | 0      |     0 |       1.8 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:3.7
 +     47240 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:28 |    302 | 0      |     0 |       0.9 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     47240 | 2010-03-29 06:00:00 |      4.5 |     110 | 2010-03-29 05:27:24 |    302 | 0      |     0 |       3.2 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:4.5
 +     92750 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:51 |    302 | 0      |     0 |         0 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     92750 | 2010-03-29 06:00:00 |      0.1 |     110 | 2010-03-29 06:10:28 |    302 | 0      |     0 |       0.1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:0.1
 +     22951 | 2010-03-29 06:00:00 |   -32767 |     110 | 2010-03-30 00:30:11 |    302 | 0      |     0 |       0.1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-30 06:00:00 |   -32767 |     110 | 2010-03-31 00:30:08 |    302 | 0      |     0 |       1.5 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-31 06:00:00 |   -32767 |     110 | 2010-04-01 00:30:15 |    302 | 0      |     0 |       5.3 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-04-01 06:00:00 |     22.3 |     110 | 2010-04-01 09:26:50 |    302 | 0      |     0 |      15.4 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:22.3
 +(22 rows)
 +
 +</code>
 +
 +
 +====  ... ordered by station ====
 +
 +<code>
 +kvalobs=# 
 +kvalobs=# 
 +kvalobs=# 
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=22951 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                        cfailed                         
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------------------
 +     22951 | 2010-03-20 06:00:00 |   -32767 |     110 | 2010-03-23 10:06:31 |    302 | 0      |     0 |    -32767 | 1000003000002000 | 7899900000000000 | QC1-7-110:1,QC1-7-110:1
 +     22951 | 2010-03-21 06:00:00 |   -32767 |     110 | 2010-03-23 05:46:14 |    302 | 0      |     0 |       5.1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1,QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-22 06:00:00 |   -32767 |     110 | 2010-03-23 02:27:12 |    302 | 0      |     0 |       2.9 | 1000003000007000 | 7899900000000000 | QC1-7-110:1,QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-23 06:00:00 |     11.6 |     110 | 2010-03-23 15:23:15 |    302 | 0      |     0 |       3.6 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:11.6
 +     22951 | 2010-03-24 06:00:00 |   -32767 |     110 | 2010-03-25 00:30:04 |    302 | 0      |     0 |       0.1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-25 06:00:00 |   -32767 |     110 | 2010-03-26 00:30:08 |    302 | 0      |     0 |       0.1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-26 06:00:00 |   -32767 |     110 | 2010-03-27 00:30:20 |    302 | 0      |     0 |         0 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:15 |    302 | 0      |     0 |       0.3 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-28 06:00:00 |      0.6 |     110 | 2010-03-28 16:30:35 |    302 | 0      |     0 |       0.1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:0.6
 +     22951 | 2010-03-29 06:00:00 |   -32767 |     110 | 2010-03-30 00:30:11 |    302 | 0      |     0 |       0.1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-30 06:00:00 |   -32767 |     110 | 2010-03-31 00:30:08 |    302 | 0      |     0 |       1.5 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-03-31 06:00:00 |   -32767 |     110 | 2010-04-01 00:30:15 |    302 | 0      |     0 |       5.3 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     22951 | 2010-04-01 06:00:00 |     22.3 |     110 | 2010-04-01 09:26:50 |    302 | 0      |     0 |      15.4 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:22.3
 +     22951 | 2010-04-02 06:00:00 |      3.9 |     110 | 2010-04-02 10:38:17 |    302 | 0      |     0 |       3.9 | 1100000000001000 | 7000000000000000 | 
 +     22951 | 2010-04-03 06:00:00 |      1.6 |     110 | 2010-04-03 19:17:31 |    302 | 0      |     0 |       1.6 | 0000000000000000 | 9999900000000000 | 
 +(15 rows)
 +
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=53950 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                  cfailed                   
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
 +     53950 | 2010-03-26 06:00:00 |      0.6 |     110 | 2010-03-26 08:11:36 |    302 | 0      |     0 |       0.6 | 1100000000001000 | 7000000000000000 | 
 +     53950 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:26 |    302 | 0      |     0 |        -1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     53950 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:36 |    302 | 0      |     0 |        -1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     53950 | 2010-03-29 06:00:00 |       -1 |     110 | 2010-03-29 11:41:24 |    302 | 0      |     0 |        -1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-1
 +     53950 | 2010-03-30 06:00:00 |      0.7 |     110 | 2010-03-30 08:57:13 |    302 | 0      |     0 |       0.7 | 1100000000001000 | 7000000000000000 | 
 +
 +
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=53730 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                  cfailed                   
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
 +     53730 | 2010-03-26 06:00:00 |      1.5 |     110 | 2010-03-26 08:10:30 |    302 | 0      |     0 |       1.5 | 1100000000001000 | 7000000000000000 | 
 +     53730 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:28 |    302 | 0      |     0 |        -1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     53730 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:33 |    302 | 0      |     0 |        -1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     53730 | 2010-03-29 06:00:00 |       -1 |     110 | 2010-03-29 11:40:23 |    302 | 0      |     0 |        -1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-1
 +     53730 | 2010-03-30 06:00:00 |        2 |     110 | 2010-03-30 08:57:13 |    302 | 0      |     0 |         2 | 1100000000001000 | 7000000000000000 | 
 +
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=58480 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                        cfailed                         
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------------------
 +     58480 | 2010-03-26 06:00:00 |      3.7 |     110 | 2010-03-26 06:15:11 |    302 | 0      |     0 |       3.7 | 1100000000001000 | 7000000000000000 | 
 +     58480 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:29 |    302 | 0      |     0 |       1.2 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767,QC1-7-110:1
 +     58480 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:37 |    302 | 0      |     0 |       0.8 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767,QC1-7-110:1
 +     58480 | 2010-03-29 06:00:00 |      4.6 |     110 | 2010-03-30 07:35:12 |    302 | 0      |     0 |       4.6 | 1100000000002000 | 7330900000000000 | QC1-7-110:1
 +     58480 | 2010-03-30 06:00:00 |        4 |     110 | 2010-04-02 02:15:55 |    302 | 0      |     0 |         4 | 1100000000001000 | 7000000000000000 | 
 +
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=46700 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                  cfailed                   
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
 +     46700 | 2010-03-26 06:00:00 |        1 |     110 | 2010-03-26 07:17:55 |    302 | 0      |     0 |         1 | 1100000000001000 | 7000000000000000 | 
 +     46700 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:17 |    302 | 0      |     0 |       1.2 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     46700 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:24 |    302 | 0      |     0 |       3.1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     46700 | 2010-03-29 06:00:00 |       10 |     110 | 2010-03-29 06:44:24 |    302 | 0      |     0 |       5.7 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:10
 +     46700 | 2010-03-30 06:00:00 |        7 |     110 | 2010-03-30 06:50:39 |    302 | 0      |     0 |         7 | 1100000000001000 | 7000000000000000 | 
 +
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=81370 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                  cfailed                   
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
 +     81370 | 2010-03-26 06:00:00 |      0.8 |     110 | 2010-03-26 06:52:41 |    302 | 0      |     0 |       0.8 | 1100000000001000 | 7000000000000000 | 
 +     81370 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:40 |    302 | 0      |     0 |        -1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     81370 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:41 |    302 | 0      |     0 |        -1 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     81370 | 2010-03-29 06:00:00 |       -1 |     110 | 2010-03-29 05:55:21 |    302 | 0      |     0 |        -1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-1
 +     81370 | 2010-03-30 06:00:00 |   -32767 |     110 | 2010-03-31 00:30:26 |    302 | 0      |     0 |    -32767 | 1000003000002000 | 7899900000000000 | QC1-7-110:1
 +
 +
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=55930 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                  cfailed                   
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
 +     55930 | 2010-03-26 06:00:00 |      4.8 |     110 | 2010-03-26 09:11:16 |    302 | 0      |     0 |       4.8 | 1100000000001000 | 7000000000000000 | 
 +     55930 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:32 |    302 | 0      |     0 |         2 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     55930 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:38 |    302 | 0      |     0 |       1.2 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     55930 | 2010-03-29 06:00:00 |      5.7 |     110 | 2010-03-29 05:55:21 |    302 | 0      |     0 |       2.6 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:5.7
 +     55930 | 2010-03-30 06:00:00 |       -1 |     110 | 2010-03-30 05:55:17 |    302 | 0      |     0 |        -1 | 1100000000001000 | 7000000000000000 | 
 +
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=48780 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                  cfailed                   
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
 +     48780 | 2010-03-26 06:00:00 |       -1 |     110 | 2010-03-26 07:45:35 |    302 | 0      |     0 |        -1 | 1100000000001000 | 7000000000000000 | 
 +     48780 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:28 |    302 | 0      |     0 |       0.7 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     48780 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:34 |    302 | 0      |     0 |       1.2 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     48780 | 2010-03-29 06:00:00 |      3.7 |     110 | 2010-03-29 05:48:46 |    302 | 0      |     0 |       1.8 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:3.7
 +     48780 | 2010-03-30 06:00:00 |      5.3 |     110 | 2010-03-30 06:44:38 |    302 | 0      |     0 |       5.3 | 1100000000001000 | 7000000000000000 | 
 +
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=47240 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                  cfailed                   
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
 +     47240 | 2010-03-26 06:00:00 |        2 |     110 | 2010-03-26 06:43:30 |    302 | 0      |     0 |         2 | 1100000000001000 | 7000000000000000 | 
 +     47240 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:26 |    302 | 0      |     0 |       0.4 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     47240 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:28 |    302 | 0      |     0 |       0.9 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     47240 | 2010-03-29 06:00:00 |      4.5 |     110 | 2010-03-29 05:27:24 |    302 | 0      |     0 |       3.2 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:4.5
 +     47240 | 2010-03-30 06:00:00 |      0.7 |     110 | 2010-03-30 05:50:44 |    302 | 0      |     0 |       0.7 | 1100000000001000 | 7000000000000000 | 
 +
 +kvalobs=# select * from data WHERE obstime>'2010-03-20' and obstime<'2010-04-10' and stationid=92750 and paramid=110 order by obstime;
 + stationid |       obstime       | original | paramid |       tbtime        | typeid | sensor | level | corrected |   controlinfo    |     useinfo      |                  cfailed                   
 +-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------
 +     92750 | 2010-03-26 06:00:00 |      5.1 |     110 | 2010-03-26 07:23:01 |    302 | 0      |     0 |       5.1 | 1100000000001000 | 7000000000000000 | 
 +     92750 | 2010-03-27 06:00:00 |   -32767 |     110 | 2010-03-28 00:30:47 |    302 | 0      |     0 |         0 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     92750 | 2010-03-28 06:00:00 |   -32767 |     110 | 2010-03-29 00:30:51 |    302 | 0      |     0 |         0 | 1000003000007000 | 7899900000000000 | QC1-7-110:1 Qc2 Redis corrected was:-32767
 +     92750 | 2010-03-29 06:00:00 |      0.1 |     110 | 2010-03-29 06:10:28 |    302 | 0      |     0 |       0.1 | 1100000000007000 | 7336900000000000 | QC1-7-110:1 Qc2 Redis corrected was:0.1
 +     92750 | 2010-03-30 06:00:00 |      0.1 |     110 | 2010-03-30 06:11:33 |    302 | 0      |     0 |       0.1 | 1100000000001000 | 7000000000000000 | 
 +
 +kvalobs=# 
 </code> </code>
  • kvalobs/kvoss/system/qc2/test.1263683352.txt.gz
  • Last modified: 2022-05-31 09:23:18
  • (external edit)