Looking up object in CORBA nameservice: corbaname::corbans.met.no:2809#kvtest-dev-vm101/kvServiceDataReady Data input by kvQc2:
-- ProcessUnitT Writing Data -6.4 17850 2010-11-25 9:0:0
Corresponding signal in kvServiced.log
20101125201847: DEBUG (ServiceSubscriber) --------------- Closing the database connection! 20101125202116: DEBUG (dataReady) --------------- New data from <UNKNOWN>! 20101125202116: INFO (ServiceSubscriber) --------------- New database connection (PostgreSQL) created! 20101125202116: DEBUG (ServiceSubscriber) --------------- Created a new connection to the database! 20101125202116: DEBUG (ServiceSubscriber) --------------- DataReady received from <> (Unknown)! 20101125202116: DEBUG (ServiceSubscriber) --------------- CALL DataSubscribers: stationID: 17850 obstime: 2010-11-25 09:00:00 typeID: 330 20101125202116: DEBUG (service/getData) --------------- called ... 20101125202116: DEBUG (service/getData) --------------- isMaxClientReached: # : 0 max: 10000 20101125202116: INFO (service/getData) --------------- New database connection (PostgreSQL) created! 20101125202116: DEBUG (service/DataIterator) --------------- next: called ... 20101125202116: DEBUG (service/DataIterator/findData) --------------- stationid: 17850 currentEndTime: 0000-00-00 --:--:-- endTime: 0000-00-00 --:--:-- iData: 0 20101125202116: DEBUG (service/DataIterator/findData) --------------- select(17850, 2010-11-24 17:00:01, 2010-11-25 05:00:00 20101125202116: DEBUG (service/DataIterator/findData) --------------- data: nElements=77 20101125202116: DEBUG (service/DataIterator/findData) --------------- textData: nElements=0 20101125202116: DEBUG (service/DataIterator/findData) --------------- DataIteratorImpl::findData: return TRUE 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[0].dataList.length()=9 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[1].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[2].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[3].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[4].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[5].dataList.length()=8 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[6].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[7].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[8].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[9].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[10].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList->length()=12 20101125202116: DEBUG (service/DataIterator) --------------- text_data: 20101125202116: DEBUG (service/DataIterator) --------------- No <textdata>! 20101125202116: DEBUG (service/DataIterator) --------------- next: called ... 20101125202116: DEBUG (service/DataIterator/findData) --------------- stationid: 17850 currentEndTime: 2010-11-25 05:00:01 endTime: 2010-11-25 18:00:00 iData: 0 20101125202116: DEBUG (service/DataIterator/findData) --------------- select(17850, 2010-11-25 05:00:01, 2010-11-25 17:00:00 20101125202116: DEBUG (service/DataIterator/findData) --------------- data: nElements=52 20101125202116: DEBUG (service/DataIterator/findData) --------------- textData: nElements=0 20101125202116: DEBUG (service/DataIterator/findData) --------------- DataIteratorImpl::findData: return TRUE 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[0].dataList.length()=10 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[1].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[2].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[3].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[4].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[5].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList[6].dataList.length()=6 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList->length()=8 20101125202116: DEBUG (service/DataIterator) --------------- text_data: 20101125202116: DEBUG (service/DataIterator) --------------- No <textdata>! 20101125202116: DEBUG (service/DataIterator) --------------- next: called ... 20101125202116: DEBUG (service/DataIterator/findData) --------------- stationid: 17850 currentEndTime: 2010-11-25 17:00:01 endTime: 2010-11-25 18:00:00 iData: 0 20101125202116: DEBUG (service/DataIterator/findData) --------------- select(17850, 2010-11-25 17:00:01, 2010-11-25 18:00:00 20101125202116: DEBUG (service/DataIterator/findData) --------------- data: nElements=0 20101125202116: DEBUG (service/DataIterator/findData) --------------- textData: nElements=0 20101125202116: DEBUG (service/DataIterator/findData) --------------- DataIteratorImpl::findData: return TRUE 20101125202116: DEBUG (service/DataIterator) --------------- next: End of data reached (return false)! 20101125202116: DEBUG --------------- DataIteratorImpl::destroy: called! 20101125202116: DEBUG --------------- DataIteratorImpl::destroy: leaving! 20101125202116: DEBUG (service/getData) --------------- called ... 20101125202116: DEBUG (service/getData) --------------- isMaxClientReached: # : 1 max: 10000 20101125202116: INFO (service/getData) --------------- New database connection (PostgreSQL) created! 20101125202116: DEBUG (service/DataIterator) --------------- next: called ... 20101125202116: DEBUG (service/DataIterator/findData) --------------- stationid: 17850 currentEndTime: 0000-00-00 --:--:-- endTime: 0000-00-00 --:--:-- iData: 0 20101125202116: DEBUG (service/DataIterator/findData) --------------- select(17850, 2010-11-25 09:00:00, 2010-11-25 09:00:00 20101125202116: DEBUG (service/DataIterator/findData) --------------- data: nElements=6 20101125202116: DEBUG (service/DataIterator/findData) --------------- textData: nElements=0 20101125202116: DEBUG (service/DataIterator/findData) --------------- DataIteratorImpl::findData: return TRUE 20101125202116: DEBUG (service/DataIterator) --------------- next: obsDataList->length()=1 20101125202116: DEBUG (service/DataIterator) --------------- text_data: 20101125202116: DEBUG (service/DataIterator) --------------- No <textdata>! 20101125202116: DEBUG (service/DataIterator) --------------- next: called ... 20101125202116: DEBUG (service/DataIterator) --------------- next: End of data reached (return false)! 20101125202116: DEBUG --------------- DataIteratorImpl::destroy: called! 20101125202116: DEBUG --------------- DataIteratorImpl::destroy: leaving! 20101125202116: DEBUG (service/getData) --------------- called ... 20101125202116: DEBUG (service/getData) --------------- isMaxClientReached: # : 2 max: 10000 20101125202116: INFO (service/getData) --------------- New database connection (PostgreSQL) created! 20101125202116: DEBUG (service/DataIterator) --------------- next: called ... 20101125202116: DEBUG (service/DataIterator/findData) --------------- stationid: 17850 currentEndTime: 0000-00-00 --:--:-- endTime: 0000-00-00 --:--:-- iData: 0 20101125202116: DEBUG (service/DataIterator/findData) --------------- select(17850, 2010-11-25 09:00:00, 2010-11-25 09:00:00 20101125202116: DEBUG (service/DataIterator/findData) --------------- data: nElements=6 20101125202116: DEBUG (service/DataIterator/findData) --------------- textData: nElements=0
This test case is in reponse to version 3.2 of the ftime flag specification.
The following steps are performed on dev-vm101. The test data source file and algorithm configuration have been pre-loaded. When necessary the test data may be restored from this FILE and the configuration from the Reference Section below.
For shell commands the prefix “$” represents the Unix prompt. All the SQL commands are typed with no admonishments.
The test case data includes one example of a missing value and one example of rejected data. There is also a run of two missing values (in the middle) that is ignored.
87120;2025-09-16 11:00:00;6.6;211;2010-09-16 11:03:21;330;0;0;6.6;0111000000000010;7000000000000000; 87120;2025-09-16 12:00:00;-19.1;211;2010-09-16 12:03:25;330;0;0;-32766;05120020000000A0;7038300000000002;QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 87120;2025-09-16 13:00:00;6.7;211;2010-09-16 13:03:17;330;0;0;6.7;0110000000000010;7000000000000000; ... 87120;2025-09-16 15:00:00;7;211;2010-09-16 15:03:21;330;0;0;7;0111000000000010;7000000000000000; 87120;2025-09-16 16:00:00;-32767;211;2010-09-16 16:51:24;330;0;0;-32767;0000003000000000;9899900000000000; 87120;2025-09-16 17:00:00;-32767;211;2010-09-16 17:33:00;330;0;0;-32767;0000003000000000;9899900000000000; 87120;2025-09-16 18:00:00;8.3;211;2010-09-16 18:04:25;330;0;0;8.3;0110000000000010;7000000000000000; ... 87120;2025-09-17 09:00:00;8.7;211;2010-09-17 09:03:50;330;0;0;8.7;0111000000000010;7000000000000000; 87120;2025-09-17 10:00:00;-32767;211;2010-09-17 10:32:33;330;0;0;-32767;0100003000000000;7899900000000000; 87120;2025-09-17 11:00:00;9.5;211;2010-09-17 11:03:44;330;0;0;9.5;0110000000000010;7000000000000000;
| Step 1 |
|---|
| Step 2 |
|---|
$ psql kvalobs
SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
COPY data FROM '/home/kvalobs/QC2/TESTDATA/qc2-211-singlepointtest.db.dat' USING DELIMITERS ';' ; SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
| Step 3 |
|---|
$ cd /etc/kvalobs/Qc2Config/ $cp SLv32.hold SLv32.cfg
$tail -f /var/log/kvalobs/Qc2.log
SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
| Step 4 |
|---|
| Step 5 |
|---|
UPDATE data SET corrected=5, original=5 WHERE stationid=87120 AND obstime='2025-09-17 09:00:00' AND paramid=211; UPDATE data SET corrected=7.2, original=7.2 WHERE stationid=87120 AND obstime='2025-09-16 11:00:00' AND paramid=211;
| Step 6 |
|---|
| Step 7 |
|---|
UPDATE data SET useinfo='7010000000000000' WHERE stationid=87120 and obstime='2025-09-17 09:00:00' and paramid=211; UPDATE data SET useinfo='7010000000000000' WHERE stationid=87120 and obstime='2025-09-16 11:00:00' and paramid=211;
| Step 8 |
|---|
$rm /etc/kvalobs/Qc2Config/SLv32.cfg
DELETE from DATA where stationid=87120 and obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' and paramid=211;
The following lists the changes to the database either through UPDATES or by the action of the algorithm that occurs between each step.
kvalobs=# DELETE from DATA where stationid=87120 and obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' and paramid=211;
DELETE 35
kvalobs=# COPY data FROM '/home/kvalobs/QC2/TESTDATA/qc2-211-singlepointtest.db.dat' USING DELIMITERS ';' ;
COPY 35
kvalobs=# SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------
87120 | 2025-09-16 06:00:00 | 11.3 | 211 | 2010-09-16 06:03:18 | 330 | 0 | 0 | 11.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 07:00:00 | 11.5 | 211 | 2010-09-16 07:03:24 | 330 | 0 | 0 | 11.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 08:00:00 | 10.7 | 211 | 2010-09-16 08:03:19 | 330 | 0 | 0 | 10.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 09:00:00 | 9.7 | 211 | 2010-09-16 09:03:22 | 330 | 0 | 0 | 9.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 10:00:00 | 7.9 | 211 | 2010-09-16 10:03:21 | 330 | 0 | 0 | 7.9 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 11:00:00 | 6.6 | 211 | 2010-09-16 11:03:21 | 330 | 0 | 0 | 6.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | -32766 | 05120020000000A0 | 7038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1
87120 | 2025-09-16 13:00:00 | 6.7 | 211 | 2010-09-16 13:03:17 | 330 | 0 | 0 | 6.7 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 14:00:00 | 6.4 | 211 | 2010-09-16 14:03:19 | 330 | 0 | 0 | 6.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 15:00:00 | 7 | 211 | 2010-09-16 15:03:21 | 330 | 0 | 0 | 7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 16:00:00 | -32767 | 211 | 2010-09-16 16:51:24 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 17:00:00 | -32767 | 211 | 2010-09-16 17:33:00 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 18:00:00 | 8.3 | 211 | 2010-09-16 18:04:25 | 330 | 0 | 0 | 8.3 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 19:00:00 | 8 | 211 | 2010-09-16 19:04:22 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 20:00:00 | 7.8 | 211 | 2010-09-16 20:04:23 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 21:00:00 | 8.2 | 211 | 2010-09-16 21:04:21 | 330 | 0 | 0 | 8.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 22:00:00 | 8.1 | 211 | 2010-09-16 22:04:25 | 330 | 0 | 0 | 8.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 23:00:00 | 8 | 211 | 2010-09-16 23:04:25 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 00:00:00 | 7.7 | 211 | 2010-09-17 00:04:20 | 330 | 0 | 0 | 7.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 01:00:00 | 7.6 | 211 | 2010-09-17 01:03:46 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 02:00:00 | 7.5 | 211 | 2010-09-17 02:03:44 | 330 | 0 | 0 | 7.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 03:00:00 | 7.1 | 211 | 2010-09-17 03:03:42 | 330 | 0 | 0 | 7.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 04:00:00 | 7.3 | 211 | 2010-09-17 04:03:46 | 330 | 0 | 0 | 7.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 05:00:00 | 7.8 | 211 | 2010-09-17 05:03:49 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 06:00:00 | 7.4 | 211 | 2010-09-17 06:03:46 | 330 | 0 | 0 | 7.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 07:00:00 | 7.6 | 211 | 2010-09-17 07:03:49 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 08:00:00 | 8.5 | 211 | 2010-09-17 08:03:43 | 330 | 0 | 0 | 8.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 09:00:00 | 8.7 | 211 | 2010-09-17 09:03:50 | 330 | 0 | 0 | 8.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | -32767 | 0100003000000000 | 7899900000000000 |
87120 | 2025-09-17 11:00:00 | 9.5 | 211 | 2010-09-17 11:03:44 | 330 | 0 | 0 | 9.5 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-17 12:00:00 | 9.5 | 211 | 2010-09-17 12:04:47 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 13:00:00 | 9.8 | 211 | 2010-09-17 13:04:51 | 330 | 0 | 0 | 9.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 14:00:00 | 9.3 | 211 | 2010-09-17 14:04:48 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 15:00:00 | 9.5 | 211 | 2010-09-17 15:04:48 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 16:00:00 | 9.3 | 211 | 2010-09-17 16:21:26 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7100000400000000 |
(35 rows)
kvalobs=# SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------------------
87120 | 2025-09-16 06:00:00 | 11.3 | 211 | 2010-09-16 06:03:18 | 330 | 0 | 0 | 11.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 07:00:00 | 11.5 | 211 | 2010-09-16 07:03:24 | 330 | 0 | 0 | 11.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 08:00:00 | 10.7 | 211 | 2010-09-16 08:03:19 | 330 | 0 | 0 | 10.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 09:00:00 | 9.7 | 211 | 2010-09-16 09:03:22 | 330 | 0 | 0 | 9.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 10:00:00 | 7.9 | 211 | 2010-09-16 10:03:21 | 330 | 0 | 0 | 7.9 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 11:00:00 | 6.6 | 211 | 2010-09-16 11:03:21 | 330 | 0 | 0 | 6.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | 6.7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2
87120 | 2025-09-16 13:00:00 | 6.7 | 211 | 2010-09-16 13:03:17 | 330 | 0 | 0 | 6.7 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 14:00:00 | 6.4 | 211 | 2010-09-16 14:03:19 | 330 | 0 | 0 | 6.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 15:00:00 | 7 | 211 | 2010-09-16 15:03:21 | 330 | 0 | 0 | 7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 16:00:00 | -32767 | 211 | 2010-09-16 16:51:24 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 17:00:00 | -32767 | 211 | 2010-09-16 17:33:00 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 18:00:00 | 8.3 | 211 | 2010-09-16 18:04:25 | 330 | 0 | 0 | 8.3 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 19:00:00 | 8 | 211 | 2010-09-16 19:04:22 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 20:00:00 | 7.8 | 211 | 2010-09-16 20:04:23 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 21:00:00 | 8.2 | 211 | 2010-09-16 21:04:21 | 330 | 0 | 0 | 8.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 22:00:00 | 8.1 | 211 | 2010-09-16 22:04:25 | 330 | 0 | 0 | 8.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 23:00:00 | 8 | 211 | 2010-09-16 23:04:25 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 00:00:00 | 7.7 | 211 | 2010-09-17 00:04:20 | 330 | 0 | 0 | 7.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 01:00:00 | 7.6 | 211 | 2010-09-17 01:03:46 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 02:00:00 | 7.5 | 211 | 2010-09-17 02:03:44 | 330 | 0 | 0 | 7.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 03:00:00 | 7.1 | 211 | 2010-09-17 03:03:42 | 330 | 0 | 0 | 7.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 04:00:00 | 7.3 | 211 | 2010-09-17 04:03:46 | 330 | 0 | 0 | 7.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 05:00:00 | 7.8 | 211 | 2010-09-17 05:03:49 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 06:00:00 | 7.4 | 211 | 2010-09-17 06:03:46 | 330 | 0 | 0 | 7.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 07:00:00 | 7.6 | 211 | 2010-09-17 07:03:49 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 08:00:00 | 8.5 | 211 | 2010-09-17 08:03:43 | 330 | 0 | 0 | 8.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 09:00:00 | 8.7 | 211 | 2010-09-17 09:03:50 | 330 | 0 | 0 | 8.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | 9.1 | 0100001100000000 | 5894900000000000 | QC2d-2
87120 | 2025-09-17 11:00:00 | 9.5 | 211 | 2010-09-17 11:03:44 | 330 | 0 | 0 | 9.5 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-17 12:00:00 | 9.5 | 211 | 2010-09-17 12:04:47 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 13:00:00 | 9.8 | 211 | 2010-09-17 13:04:51 | 330 | 0 | 0 | 9.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 14:00:00 | 9.3 | 211 | 2010-09-17 14:04:48 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 15:00:00 | 9.5 | 211 | 2010-09-17 15:04:48 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 16:00:00 | 9.3 | 211 | 2010-09-17 16:21:26 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7100000400000000 |
(35 rows)
kvalobs=# SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------------------
87120 | 2025-09-16 06:00:00 | 11.3 | 211 | 2010-09-16 06:03:18 | 330 | 0 | 0 | 11.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 07:00:00 | 11.5 | 211 | 2010-09-16 07:03:24 | 330 | 0 | 0 | 11.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 08:00:00 | 10.7 | 211 | 2010-09-16 08:03:19 | 330 | 0 | 0 | 10.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 09:00:00 | 9.7 | 211 | 2010-09-16 09:03:22 | 330 | 0 | 0 | 9.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 10:00:00 | 7.9 | 211 | 2010-09-16 10:03:21 | 330 | 0 | 0 | 7.9 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 11:00:00 | 6.6 | 211 | 2010-09-16 11:03:21 | 330 | 0 | 0 | 6.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | 6.7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2
87120 | 2025-09-16 13:00:00 | 6.7 | 211 | 2010-09-16 13:03:17 | 330 | 0 | 0 | 6.7 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 14:00:00 | 6.4 | 211 | 2010-09-16 14:03:19 | 330 | 0 | 0 | 6.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 15:00:00 | 7 | 211 | 2010-09-16 15:03:21 | 330 | 0 | 0 | 7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 16:00:00 | -32767 | 211 | 2010-09-16 16:51:24 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 17:00:00 | -32767 | 211 | 2010-09-16 17:33:00 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 18:00:00 | 8.3 | 211 | 2010-09-16 18:04:25 | 330 | 0 | 0 | 8.3 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 19:00:00 | 8 | 211 | 2010-09-16 19:04:22 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 20:00:00 | 7.8 | 211 | 2010-09-16 20:04:23 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 21:00:00 | 8.2 | 211 | 2010-09-16 21:04:21 | 330 | 0 | 0 | 8.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 22:00:00 | 8.1 | 211 | 2010-09-16 22:04:25 | 330 | 0 | 0 | 8.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 23:00:00 | 8 | 211 | 2010-09-16 23:04:25 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 00:00:00 | 7.7 | 211 | 2010-09-17 00:04:20 | 330 | 0 | 0 | 7.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 01:00:00 | 7.6 | 211 | 2010-09-17 01:03:46 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 02:00:00 | 7.5 | 211 | 2010-09-17 02:03:44 | 330 | 0 | 0 | 7.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 03:00:00 | 7.1 | 211 | 2010-09-17 03:03:42 | 330 | 0 | 0 | 7.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 04:00:00 | 7.3 | 211 | 2010-09-17 04:03:46 | 330 | 0 | 0 | 7.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 05:00:00 | 7.8 | 211 | 2010-09-17 05:03:49 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 06:00:00 | 7.4 | 211 | 2010-09-17 06:03:46 | 330 | 0 | 0 | 7.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 07:00:00 | 7.6 | 211 | 2010-09-17 07:03:49 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 08:00:00 | 8.5 | 211 | 2010-09-17 08:03:43 | 330 | 0 | 0 | 8.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 09:00:00 | 8.7 | 211 | 2010-09-17 09:03:50 | 330 | 0 | 0 | 8.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | 9.1 | 0100001100000000 | 5894900000000000 | QC2d-2
87120 | 2025-09-17 11:00:00 | 9.5 | 211 | 2010-09-17 11:03:44 | 330 | 0 | 0 | 9.5 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-17 12:00:00 | 9.5 | 211 | 2010-09-17 12:04:47 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 13:00:00 | 9.8 | 211 | 2010-09-17 13:04:51 | 330 | 0 | 0 | 9.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 14:00:00 | 9.3 | 211 | 2010-09-17 14:04:48 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 15:00:00 | 9.5 | 211 | 2010-09-17 15:04:48 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 16:00:00 | 9.3 | 211 | 2010-09-17 16:21:26 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7100000400000000 |
(35 rows)
kvalobs=# UPDATE data SET corrected=5, original=5 WHERE stationid=87120 AND obstime='2025-09-17 09:00:00' AND paramid=211;
UPDATE 1
kvalobs=# UPDATE data SET corrected=7.2, original=7.2 WHERE stationid=87120 AND obstime='2025-09-16 11:00:00' AND paramid=211;
UPDATE 1
kvalobs=# SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+------------------------------------------------------
87120 | 2025-09-16 06:00:00 | 11.3 | 211 | 2010-09-16 06:03:18 | 330 | 0 | 0 | 11.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 07:00:00 | 11.5 | 211 | 2010-09-16 07:03:24 | 330 | 0 | 0 | 11.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 08:00:00 | 10.7 | 211 | 2010-09-16 08:03:19 | 330 | 0 | 0 | 10.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 09:00:00 | 9.7 | 211 | 2010-09-16 09:03:22 | 330 | 0 | 0 | 9.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 10:00:00 | 7.9 | 211 | 2010-09-16 10:03:21 | 330 | 0 | 0 | 7.9 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 11:00:00 | 7.2 | 211 | 2010-09-16 11:03:21 | 330 | 0 | 0 | 7.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | 7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2 QC2d-2
87120 | 2025-09-16 13:00:00 | 6.7 | 211 | 2010-09-16 13:03:17 | 330 | 0 | 0 | 6.7 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 14:00:00 | 6.4 | 211 | 2010-09-16 14:03:19 | 330 | 0 | 0 | 6.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 15:00:00 | 7 | 211 | 2010-09-16 15:03:21 | 330 | 0 | 0 | 7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 16:00:00 | -32767 | 211 | 2010-09-16 16:51:24 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 17:00:00 | -32767 | 211 | 2010-09-16 17:33:00 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 18:00:00 | 8.3 | 211 | 2010-09-16 18:04:25 | 330 | 0 | 0 | 8.3 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 19:00:00 | 8 | 211 | 2010-09-16 19:04:22 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 20:00:00 | 7.8 | 211 | 2010-09-16 20:04:23 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 21:00:00 | 8.2 | 211 | 2010-09-16 21:04:21 | 330 | 0 | 0 | 8.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 22:00:00 | 8.1 | 211 | 2010-09-16 22:04:25 | 330 | 0 | 0 | 8.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 23:00:00 | 8 | 211 | 2010-09-16 23:04:25 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 00:00:00 | 7.7 | 211 | 2010-09-17 00:04:20 | 330 | 0 | 0 | 7.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 01:00:00 | 7.6 | 211 | 2010-09-17 01:03:46 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 02:00:00 | 7.5 | 211 | 2010-09-17 02:03:44 | 330 | 0 | 0 | 7.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 03:00:00 | 7.1 | 211 | 2010-09-17 03:03:42 | 330 | 0 | 0 | 7.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 04:00:00 | 7.3 | 211 | 2010-09-17 04:03:46 | 330 | 0 | 0 | 7.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 05:00:00 | 7.8 | 211 | 2010-09-17 05:03:49 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 06:00:00 | 7.4 | 211 | 2010-09-17 06:03:46 | 330 | 0 | 0 | 7.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 07:00:00 | 7.6 | 211 | 2010-09-17 07:03:49 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 08:00:00 | 8.5 | 211 | 2010-09-17 08:03:43 | 330 | 0 | 0 | 8.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 09:00:00 | 5 | 211 | 2010-09-17 09:03:50 | 330 | 0 | 0 | 5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | 7.3 | 0100001100000000 | 5894900000000000 | QC2d-2 QC2d-2
87120 | 2025-09-17 11:00:00 | 9.5 | 211 | 2010-09-17 11:03:44 | 330 | 0 | 0 | 9.5 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-17 12:00:00 | 9.5 | 211 | 2010-09-17 12:04:47 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 13:00:00 | 9.8 | 211 | 2010-09-17 13:04:51 | 330 | 0 | 0 | 9.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 14:00:00 | 9.3 | 211 | 2010-09-17 14:04:48 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 15:00:00 | 9.5 | 211 | 2010-09-17 15:04:48 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 16:00:00 | 9.3 | 211 | 2010-09-17 16:21:26 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7100000400000000 |
(35 rows)
kvalobs=# SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+------------------------------------------------------
87120 | 2025-09-16 06:00:00 | 11.3 | 211 | 2010-09-16 06:03:18 | 330 | 0 | 0 | 11.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 07:00:00 | 11.5 | 211 | 2010-09-16 07:03:24 | 330 | 0 | 0 | 11.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 08:00:00 | 10.7 | 211 | 2010-09-16 08:03:19 | 330 | 0 | 0 | 10.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 09:00:00 | 9.7 | 211 | 2010-09-16 09:03:22 | 330 | 0 | 0 | 9.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 10:00:00 | 7.9 | 211 | 2010-09-16 10:03:21 | 330 | 0 | 0 | 7.9 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 11:00:00 | 7.2 | 211 | 2010-09-16 11:03:21 | 330 | 0 | 0 | 7.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | 7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2 QC2d-2
87120 | 2025-09-16 13:00:00 | 6.7 | 211 | 2010-09-16 13:03:17 | 330 | 0 | 0 | 6.7 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 14:00:00 | 6.4 | 211 | 2010-09-16 14:03:19 | 330 | 0 | 0 | 6.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 15:00:00 | 7 | 211 | 2010-09-16 15:03:21 | 330 | 0 | 0 | 7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 16:00:00 | -32767 | 211 | 2010-09-16 16:51:24 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 17:00:00 | -32767 | 211 | 2010-09-16 17:33:00 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 18:00:00 | 8.3 | 211 | 2010-09-16 18:04:25 | 330 | 0 | 0 | 8.3 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 19:00:00 | 8 | 211 | 2010-09-16 19:04:22 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 20:00:00 | 7.8 | 211 | 2010-09-16 20:04:23 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 21:00:00 | 8.2 | 211 | 2010-09-16 21:04:21 | 330 | 0 | 0 | 8.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 22:00:00 | 8.1 | 211 | 2010-09-16 22:04:25 | 330 | 0 | 0 | 8.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 23:00:00 | 8 | 211 | 2010-09-16 23:04:25 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 00:00:00 | 7.7 | 211 | 2010-09-17 00:04:20 | 330 | 0 | 0 | 7.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 01:00:00 | 7.6 | 211 | 2010-09-17 01:03:46 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 02:00:00 | 7.5 | 211 | 2010-09-17 02:03:44 | 330 | 0 | 0 | 7.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 03:00:00 | 7.1 | 211 | 2010-09-17 03:03:42 | 330 | 0 | 0 | 7.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 04:00:00 | 7.3 | 211 | 2010-09-17 04:03:46 | 330 | 0 | 0 | 7.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 05:00:00 | 7.8 | 211 | 2010-09-17 05:03:49 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 06:00:00 | 7.4 | 211 | 2010-09-17 06:03:46 | 330 | 0 | 0 | 7.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 07:00:00 | 7.6 | 211 | 2010-09-17 07:03:49 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 08:00:00 | 8.5 | 211 | 2010-09-17 08:03:43 | 330 | 0 | 0 | 8.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 09:00:00 | 5 | 211 | 2010-09-17 09:03:50 | 330 | 0 | 0 | 5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | 7.3 | 0100001100000000 | 5894900000000000 | QC2d-2 QC2d-2
87120 | 2025-09-17 11:00:00 | 9.5 | 211 | 2010-09-17 11:03:44 | 330 | 0 | 0 | 9.5 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-17 12:00:00 | 9.5 | 211 | 2010-09-17 12:04:47 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 13:00:00 | 9.8 | 211 | 2010-09-17 13:04:51 | 330 | 0 | 0 | 9.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 14:00:00 | 9.3 | 211 | 2010-09-17 14:04:48 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 15:00:00 | 9.5 | 211 | 2010-09-17 15:04:48 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 16:00:00 | 9.3 | 211 | 2010-09-17 16:21:26 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7100000400000000 |
(35 rows)
kvalobs=# UPDATE data SET useinfo='7010000000000000' WHERE stationid=87120 and obstime='2025-09-17 09:00:00' and paramid=211;
UPDATE 1
kvalobs=# UPDATE data SET useinfo='7010000000000000' WHERE stationid=87120 and obstime='2025-09-16 11:00:00' and paramid=211;
UPDATE 1
kvalobs=# SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+------------------------------------------------------
87120 | 2025-09-16 06:00:00 | 11.3 | 211 | 2010-09-16 06:03:18 | 330 | 0 | 0 | 11.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 07:00:00 | 11.5 | 211 | 2010-09-16 07:03:24 | 330 | 0 | 0 | 11.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 08:00:00 | 10.7 | 211 | 2010-09-16 08:03:19 | 330 | 0 | 0 | 10.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 09:00:00 | 9.7 | 211 | 2010-09-16 09:03:22 | 330 | 0 | 0 | 9.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 10:00:00 | 7.9 | 211 | 2010-09-16 10:03:21 | 330 | 0 | 0 | 7.9 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 11:00:00 | 7.2 | 211 | 2010-09-16 11:03:21 | 330 | 0 | 0 | 7.2 | 0111000000000010 | 7010000000000000 |
87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | 7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2 QC2d-2
87120 | 2025-09-16 13:00:00 | 6.7 | 211 | 2010-09-16 13:03:17 | 330 | 0 | 0 | 6.7 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 14:00:00 | 6.4 | 211 | 2010-09-16 14:03:19 | 330 | 0 | 0 | 6.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 15:00:00 | 7 | 211 | 2010-09-16 15:03:21 | 330 | 0 | 0 | 7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 16:00:00 | -32767 | 211 | 2010-09-16 16:51:24 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 17:00:00 | -32767 | 211 | 2010-09-16 17:33:00 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 18:00:00 | 8.3 | 211 | 2010-09-16 18:04:25 | 330 | 0 | 0 | 8.3 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 19:00:00 | 8 | 211 | 2010-09-16 19:04:22 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 20:00:00 | 7.8 | 211 | 2010-09-16 20:04:23 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 21:00:00 | 8.2 | 211 | 2010-09-16 21:04:21 | 330 | 0 | 0 | 8.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 22:00:00 | 8.1 | 211 | 2010-09-16 22:04:25 | 330 | 0 | 0 | 8.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 23:00:00 | 8 | 211 | 2010-09-16 23:04:25 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 00:00:00 | 7.7 | 211 | 2010-09-17 00:04:20 | 330 | 0 | 0 | 7.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 01:00:00 | 7.6 | 211 | 2010-09-17 01:03:46 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 02:00:00 | 7.5 | 211 | 2010-09-17 02:03:44 | 330 | 0 | 0 | 7.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 03:00:00 | 7.1 | 211 | 2010-09-17 03:03:42 | 330 | 0 | 0 | 7.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 04:00:00 | 7.3 | 211 | 2010-09-17 04:03:46 | 330 | 0 | 0 | 7.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 05:00:00 | 7.8 | 211 | 2010-09-17 05:03:49 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 06:00:00 | 7.4 | 211 | 2010-09-17 06:03:46 | 330 | 0 | 0 | 7.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 07:00:00 | 7.6 | 211 | 2010-09-17 07:03:49 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 08:00:00 | 8.5 | 211 | 2010-09-17 08:03:43 | 330 | 0 | 0 | 8.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 09:00:00 | 5 | 211 | 2010-09-17 09:03:50 | 330 | 0 | 0 | 5 | 0111000000000010 | 7010000000000000 |
87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | 7.3 | 0100001100000000 | 5894900000000000 | QC2d-2 QC2d-2
87120 | 2025-09-17 11:00:00 | 9.5 | 211 | 2010-09-17 11:03:44 | 330 | 0 | 0 | 9.5 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-17 12:00:00 | 9.5 | 211 | 2010-09-17 12:04:47 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 13:00:00 | 9.8 | 211 | 2010-09-17 13:04:51 | 330 | 0 | 0 | 9.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 14:00:00 | 9.3 | 211 | 2010-09-17 14:04:48 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 15:00:00 | 9.5 | 211 | 2010-09-17 15:04:48 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 16:00:00 | 9.3 | 211 | 2010-09-17 16:21:26 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7100000400000000 |
(35 rows)
kvalobs=# SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------------------------
87120 | 2025-09-16 06:00:00 | 11.3 | 211 | 2010-09-16 06:03:18 | 330 | 0 | 0 | 11.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 07:00:00 | 11.5 | 211 | 2010-09-16 07:03:24 | 330 | 0 | 0 | 11.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 08:00:00 | 10.7 | 211 | 2010-09-16 08:03:19 | 330 | 0 | 0 | 10.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 09:00:00 | 9.7 | 211 | 2010-09-16 09:03:22 | 330 | 0 | 0 | 9.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 10:00:00 | 7.9 | 211 | 2010-09-16 10:03:21 | 330 | 0 | 0 | 7.9 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 11:00:00 | 7.2 | 211 | 2010-09-16 11:03:21 | 330 | 0 | 0 | 7.2 | 0111000000000010 | 7010000000000000 |
87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | -32766 | 05120021000000A0 | 5038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2 QC2d-2 QC2d-2
87120 | 2025-09-16 13:00:00 | 6.7 | 211 | 2010-09-16 13:03:17 | 330 | 0 | 0 | 6.7 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 14:00:00 | 6.4 | 211 | 2010-09-16 14:03:19 | 330 | 0 | 0 | 6.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 15:00:00 | 7 | 211 | 2010-09-16 15:03:21 | 330 | 0 | 0 | 7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 16:00:00 | -32767 | 211 | 2010-09-16 16:51:24 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 17:00:00 | -32767 | 211 | 2010-09-16 17:33:00 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 18:00:00 | 8.3 | 211 | 2010-09-16 18:04:25 | 330 | 0 | 0 | 8.3 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 19:00:00 | 8 | 211 | 2010-09-16 19:04:22 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 20:00:00 | 7.8 | 211 | 2010-09-16 20:04:23 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 21:00:00 | 8.2 | 211 | 2010-09-16 21:04:21 | 330 | 0 | 0 | 8.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 22:00:00 | 8.1 | 211 | 2010-09-16 22:04:25 | 330 | 0 | 0 | 8.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 23:00:00 | 8 | 211 | 2010-09-16 23:04:25 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 00:00:00 | 7.7 | 211 | 2010-09-17 00:04:20 | 330 | 0 | 0 | 7.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 01:00:00 | 7.6 | 211 | 2010-09-17 01:03:46 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 02:00:00 | 7.5 | 211 | 2010-09-17 02:03:44 | 330 | 0 | 0 | 7.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 03:00:00 | 7.1 | 211 | 2010-09-17 03:03:42 | 330 | 0 | 0 | 7.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 04:00:00 | 7.3 | 211 | 2010-09-17 04:03:46 | 330 | 0 | 0 | 7.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 05:00:00 | 7.8 | 211 | 2010-09-17 05:03:49 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 06:00:00 | 7.4 | 211 | 2010-09-17 06:03:46 | 330 | 0 | 0 | 7.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 07:00:00 | 7.6 | 211 | 2010-09-17 07:03:49 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 08:00:00 | 8.5 | 211 | 2010-09-17 08:03:43 | 330 | 0 | 0 | 8.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 09:00:00 | 5 | 211 | 2010-09-17 09:03:50 | 330 | 0 | 0 | 5 | 0111000000000010 | 7010000000000000 |
87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | -32767 | 0100003100000000 | 5899900000000000 | QC2d-2 QC2d-2 QC2d-2
87120 | 2025-09-17 11:00:00 | 9.5 | 211 | 2010-09-17 11:03:44 | 330 | 0 | 0 | 9.5 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-17 12:00:00 | 9.5 | 211 | 2010-09-17 12:04:47 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 13:00:00 | 9.8 | 211 | 2010-09-17 13:04:51 | 330 | 0 | 0 | 9.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 14:00:00 | 9.3 | 211 | 2010-09-17 14:04:48 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 15:00:00 | 9.5 | 211 | 2010-09-17 15:04:48 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 16:00:00 | 9.3 | 211 | 2010-09-17 16:21:26 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7100000400000000 |
(35 rows)
kvalobs=# SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------------------------
87120 | 2025-09-16 06:00:00 | 11.3 | 211 | 2010-09-16 06:03:18 | 330 | 0 | 0 | 11.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 07:00:00 | 11.5 | 211 | 2010-09-16 07:03:24 | 330 | 0 | 0 | 11.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 08:00:00 | 10.7 | 211 | 2010-09-16 08:03:19 | 330 | 0 | 0 | 10.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 09:00:00 | 9.7 | 211 | 2010-09-16 09:03:22 | 330 | 0 | 0 | 9.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 10:00:00 | 7.9 | 211 | 2010-09-16 10:03:21 | 330 | 0 | 0 | 7.9 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 11:00:00 | 7.2 | 211 | 2010-09-16 11:03:21 | 330 | 0 | 0 | 7.2 | 0111000000000010 | 7010000000000000 |
87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | -32766 | 05120021000000A0 | 5038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2 QC2d-2 QC2d-2
87120 | 2025-09-16 13:00:00 | 6.7 | 211 | 2010-09-16 13:03:17 | 330 | 0 | 0 | 6.7 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 14:00:00 | 6.4 | 211 | 2010-09-16 14:03:19 | 330 | 0 | 0 | 6.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 15:00:00 | 7 | 211 | 2010-09-16 15:03:21 | 330 | 0 | 0 | 7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 16:00:00 | -32767 | 211 | 2010-09-16 16:51:24 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 17:00:00 | -32767 | 211 | 2010-09-16 17:33:00 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 18:00:00 | 8.3 | 211 | 2010-09-16 18:04:25 | 330 | 0 | 0 | 8.3 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 19:00:00 | 8 | 211 | 2010-09-16 19:04:22 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 20:00:00 | 7.8 | 211 | 2010-09-16 20:04:23 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 21:00:00 | 8.2 | 211 | 2010-09-16 21:04:21 | 330 | 0 | 0 | 8.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 22:00:00 | 8.1 | 211 | 2010-09-16 22:04:25 | 330 | 0 | 0 | 8.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 23:00:00 | 8 | 211 | 2010-09-16 23:04:25 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 00:00:00 | 7.7 | 211 | 2010-09-17 00:04:20 | 330 | 0 | 0 | 7.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 01:00:00 | 7.6 | 211 | 2010-09-17 01:03:46 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 02:00:00 | 7.5 | 211 | 2010-09-17 02:03:44 | 330 | 0 | 0 | 7.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 03:00:00 | 7.1 | 211 | 2010-09-17 03:03:42 | 330 | 0 | 0 | 7.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 04:00:00 | 7.3 | 211 | 2010-09-17 04:03:46 | 330 | 0 | 0 | 7.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 05:00:00 | 7.8 | 211 | 2010-09-17 05:03:49 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 06:00:00 | 7.4 | 211 | 2010-09-17 06:03:46 | 330 | 0 | 0 | 7.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 07:00:00 | 7.6 | 211 | 2010-09-17 07:03:49 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 08:00:00 | 8.5 | 211 | 2010-09-17 08:03:43 | 330 | 0 | 0 | 8.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 09:00:00 | 5 | 211 | 2010-09-17 09:03:50 | 330 | 0 | 0 | 5 | 0111000000000010 | 7010000000000000 |
87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | -32767 | 0100003100000000 | 5899900000000000 | QC2d-2 QC2d-2 QC2d-2
87120 | 2025-09-17 11:00:00 | 9.5 | 211 | 2010-09-17 11:03:44 | 330 | 0 | 0 | 9.5 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-17 12:00:00 | 9.5 | 211 | 2010-09-17 12:04:47 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 13:00:00 | 9.8 | 211 | 2010-09-17 13:04:51 | 330 | 0 | 0 | 9.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 14:00:00 | 9.3 | 211 | 2010-09-17 14:04:48 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 15:00:00 | 9.5 | 211 | 2010-09-17 15:04:48 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 16:00:00 | 9.3 | 211 | 2010-09-17 16:21:26 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7100000400000000 |
(35 rows)
kvalobs=#
Corresponding Log file
Mon Sep 27 00:25:27 CEST 2010 kvalobs@dev-vm101:~/QC2/TESTDATA$ tail -f /var/log/kvalobs/Qc2.log 20100926083305: INFO --------------- Single Linear 20100926083308: INFO --------------- ProcessUnitT Writing Data 0.3 25110 2010-9-26 2:0:0 20100926083309: INFO --------------- ProcessUnitT Writing Data 3.5 49800 2010-9-26 1:0:0 20100926125805: INFO --------------- Case 10: Single Linear 20100926125805: INFO --------------- Single Linear 20100927002955: INFO --------------- Case 10: Single Linear 20100927002955: INFO --------------- Single Linear 20100927002955: INFO --------------- ProcessUnitT Writing Data 9.1 87120 2025-9-17 10:0:0 20100927002955: INFO --------------- ProcessUnitT Writing Data 6.7 87120 2025-9-16 12:0:0 20100927003054: INFO --------------- Case 9: Single Min Max Average 20100927003054: INFO --------------- Algorithm chosen is not available in this release. 20100927003054: INFO --------------- Case 10: Single Linear 20100927003054: INFO --------------- Single Linear 20100927003252: INFO --------------- Case 10: Single Linear 20100927003252: INFO --------------- Single Linear 20100927003252: INFO --------------- ProcessUnitT Writing Data 7.3 87120 2025-9-17 10:0:0 20100927003252: INFO --------------- ProcessUnitT Writing Data 7 87120 2025-9-16 12:0:0 20100927003352: INFO --------------- Case 10: Single Linear 20100927003352: INFO --------------- Single Linear 20100927003451: INFO --------------- Case 10: Single Linear 20100927003451: INFO --------------- Single Linear 20100927003451: INFO --------------- ProcessUnitT Writing Data -32767 87120 2025-9-17 10:0:0 20100927003451: INFO --------------- ProcessUnitT Writing Data -32766 87120 2025-9-16 12:0:0 20100927003550: INFO --------------- Case 10: Single Linear 20100927003550: INFO --------------- Single Linear
NB The results from 2010-09-26 correspond to the test reported above (a similar test was also carried out earlier).
kvalobs=# select * from data_history where obstime='2025-09-16 12:00:00' and stationid=87120 and paramid=211 order by modificationtime; Cancel request sent ERROR: canceling statement due to user request kvalobs=# select * from data_history where obstime='2025-09-16 12:00:00' and stationid=87120 and paramid=211 order by modificationtime; version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime ----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------------------------------+---------------------------- 87813610 | 87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | -32766 | 05120020000000A0 | 7038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 | 2010-09-24 10:52:27.021832 88015727 | 87120 | 2025-09-16 12:00:00 | | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | | | | | 2010-09-25 10:58:55.972068 88015728 | 87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | 6.7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2 | 2010-09-25 10:58:55.983701 88310641 | 87120 | 2025-09-16 12:00:00 | | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | | | | | 2010-09-26 22:21:01.274446 88310829 | 87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | -32766 | 05120020000000A0 | 7038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 | 2010-09-26 22:24:30.465528 88310864 | 87120 | 2025-09-16 12:00:00 | | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | | | | | 2010-09-26 22:24:35.941759 88310899 | 87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | -32766 | 05120020000000A0 | 7038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 | 2010-09-26 22:24:37.960795 88310930 | 87120 | 2025-09-16 12:00:00 | | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | | | | | 2010-09-26 22:29:55.536605 88310931 | 87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | 6.7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2 | 2010-09-26 22:29:55.545059 88311611 | 87120 | 2025-09-16 12:00:00 | | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | | | | | 2010-09-26 22:32:52.957787 88311612 | 87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | 7 | 05120041000000A0 | 5033300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2 QC2d-2 | 2010-09-26 22:32:52.96432 88311617 | 87120 | 2025-09-16 12:00:00 | | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | | | | | 2010-09-26 22:34:51.328849 88311618 | 87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | -32766 | 05120021000000A0 | 5038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1 QC2d-2 QC2d-2 QC2d-2 | 2010-09-26 22:34:51.33704 (13 rows)
…
kvalobs=# select * from data_history where obstime='2025-09-17 10:00:00' and stationid=87120 and paramid=211 order by modificationtime; version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime ----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------+---------------------------- 87813632 | 87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | -32767 | 0100003000000000 | 7899900000000000 | | 2010-09-24 10:52:27.021832 88015725 | 87120 | 2025-09-17 10:00:00 | | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | | | | | 2010-09-25 10:58:55.846379 88015726 | 87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | 9.1 | 0100001100000000 | 5894900000000000 | QC2d-2 | 2010-09-25 10:58:55.915267 88310663 | 87120 | 2025-09-17 10:00:00 | | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | | | | | 2010-09-26 22:21:01.274446 88310851 | 87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | -32767 | 0100003000000000 | 7899900000000000 | | 2010-09-26 22:24:30.465528 88310886 | 87120 | 2025-09-17 10:00:00 | | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | | | | | 2010-09-26 22:24:35.941759 88310921 | 87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | -32767 | 0100003000000000 | 7899900000000000 | | 2010-09-26 22:24:37.960795 88310928 | 87120 | 2025-09-17 10:00:00 | | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | | | | | 2010-09-26 22:29:55.509838 88310929 | 87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | 9.1 | 0100001100000000 | 5894900000000000 | QC2d-2 | 2010-09-26 22:29:55.519257 88311609 | 87120 | 2025-09-17 10:00:00 | | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | | | | | 2010-09-26 22:32:52.939681 88311610 | 87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | 7.3 | 0100001100000000 | 5894900000000000 | QC2d-2 QC2d-2 | 2010-09-26 22:32:52.940653 88311615 | 87120 | 2025-09-17 10:00:00 | | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | | | | | 2010-09-26 22:34:51.312347 88311616 | 87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | -32767 | 0100003100000000 | 5899900000000000 | QC2d-2 QC2d-2 QC2d-2 | 2010-09-26 22:34:51.313104 (13 rows) kvalobs=#
Note Data not deleted from the database in case it is required for inspection.
Configuration file
AlgoCode=10 # Time to run the algorithm RunAtHour=22 RunAtMinute=28 #[Time Range] Start_YYYY=2025 Start_MM=9 Start_DD=16 Start_hh=6 Start_mm=0 Start_ss=0 # End_YYYY=2025 End_MM=9 End_DD=17 End_hh=16 End_mm=0 End_ss=0 #[Specific Data Type and Paramters ids etc.] ParamId=211 MaxParamId=215 MinParamId=213 # Only write back the result if not previously controlled W_fhqc=0 #Flag to set if value is corrected S_ftime=1 change_fmis=3->1 change_fmis=0->4 change_fmis=2->4 #If there is already a 1 in place then we do not want run the algorithm again! U_2=0
Sql for the test:
SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211 ORDER BY obstime; COPY data FROM '/metno/kvalobs/TESTDATA/kvqc2_1.0.4/Qc2-211-SinglePointTest.db.dat' USING DELIMITERS ';' ; SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211; UPDATE data SET corrected=5, original=5 WHERE stationid=87120 AND obstime='2025-09-17 09:00:00' AND paramid=211; UPDATE data SET corrected=7.2, original=7.2 WHERE stationid=87120 AND obstime='2025-09-16 11:00:00' AND paramid=211; SELECT * FROM data WHERE stationid=87120 AND obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' AND paramid=211; UPDATE data SET useinfo='7010000000000000' WHERE stationid=87120 and obstime='2025-09-17 09:00:00' and paramid=211; UPDATE data SET useinfo='7010000000000000' WHERE stationid=87120 and obstime='2025-09-16 11:00:00' and paramid=211; DELETE from DATA where stationid=87120 and obstime BETWEEN '2025-09-16 06:00:00' AND '2025-09-17 16:00:00' and paramid=211;
The test data set:
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+--------------------------------------
87120 | 2025-09-16 07:00:00 | 11.5 | 211 | 2010-09-16 07:03:24 | 330 | 0 | 0 | 11.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 08:00:00 | 10.7 | 211 | 2010-09-16 08:03:19 | 330 | 0 | 0 | 10.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 09:00:00 | 9.7 | 211 | 2010-09-16 09:03:22 | 330 | 0 | 0 | 9.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 10:00:00 | 7.9 | 211 | 2010-09-16 10:03:21 | 330 | 0 | 0 | 7.9 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 11:00:00 | 6.6 | 211 | 2010-09-16 11:03:21 | 330 | 0 | 0 | 6.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 12:00:00 | -19.1 | 211 | 2010-09-16 12:03:25 | 330 | 0 | 0 | -32766 | 05120020000000A0 | 7038300000000002 | QC1-1-211:1,QC1-3a-211:1,QC1-9-211:1
87120 | 2025-09-16 13:00:00 | 6.7 | 211 | 2010-09-16 13:03:17 | 330 | 0 | 0 | 6.7 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 14:00:00 | 6.4 | 211 | 2010-09-16 14:03:19 | 330 | 0 | 0 | 6.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 15:00:00 | 7 | 211 | 2010-09-16 15:03:21 | 330 | 0 | 0 | 7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 16:00:00 | -32767 | 211 | 2010-09-16 16:51:24 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 17:00:00 | -32767 | 211 | 2010-09-16 17:33:00 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 |
87120 | 2025-09-16 18:00:00 | 8.3 | 211 | 2010-09-16 18:04:25 | 330 | 0 | 0 | 8.3 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-16 19:00:00 | 8 | 211 | 2010-09-16 19:04:22 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 20:00:00 | 7.8 | 211 | 2010-09-16 20:04:23 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 21:00:00 | 8.2 | 211 | 2010-09-16 21:04:21 | 330 | 0 | 0 | 8.2 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 22:00:00 | 8.1 | 211 | 2010-09-16 22:04:25 | 330 | 0 | 0 | 8.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-16 23:00:00 | 8 | 211 | 2010-09-16 23:04:25 | 330 | 0 | 0 | 8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 00:00:00 | 7.7 | 211 | 2010-09-17 00:04:20 | 330 | 0 | 0 | 7.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 01:00:00 | 7.6 | 211 | 2010-09-17 01:03:46 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 02:00:00 | 7.5 | 211 | 2010-09-17 02:03:44 | 330 | 0 | 0 | 7.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 03:00:00 | 7.1 | 211 | 2010-09-17 03:03:42 | 330 | 0 | 0 | 7.1 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 04:00:00 | 7.3 | 211 | 2010-09-17 04:03:46 | 330 | 0 | 0 | 7.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 05:00:00 | 7.8 | 211 | 2010-09-17 05:03:49 | 330 | 0 | 0 | 7.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 06:00:00 | 7.4 | 211 | 2010-09-17 06:03:46 | 330 | 0 | 0 | 7.4 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 07:00:00 | 7.6 | 211 | 2010-09-17 07:03:49 | 330 | 0 | 0 | 7.6 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 08:00:00 | 8.5 | 211 | 2010-09-17 08:03:43 | 330 | 0 | 0 | 8.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 09:00:00 | 8.7 | 211 | 2010-09-17 09:03:50 | 330 | 0 | 0 | 8.7 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 10:00:00 | -32767 | 211 | 2010-09-17 10:32:33 | 330 | 0 | 0 | -32767 | 0100003000000000 | 7899900000000000 |
87120 | 2025-09-17 11:00:00 | 9.5 | 211 | 2010-09-17 11:03:44 | 330 | 0 | 0 | 9.5 | 0110000000000010 | 7000000000000000 |
87120 | 2025-09-17 12:00:00 | 9.5 | 211 | 2010-09-17 12:04:47 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 13:00:00 | 9.8 | 211 | 2010-09-17 13:04:51 | 330 | 0 | 0 | 9.8 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 14:00:00 | 9.3 | 211 | 2010-09-17 14:04:48 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 15:00:00 | 9.5 | 211 | 2010-09-17 15:04:48 | 330 | 0 | 0 | 9.5 | 0111000000000010 | 7000000000000000 |
87120 | 2025-09-17 16:00:00 | 9.3 | 211 | 2010-09-17 16:21:26 | 330 | 0 | 0 | 9.3 | 0111000000000010 | 7100000400000000 |
(34 rows)
Some results from the general inspection of the database on dev-vm101 after a few days testing:
kvalobs=# SELECT count(*) FROM data WHERE obstime BETWEEN '2010-09-24 20:00:00' and 'today' and cfailed like '%QC2%';
count
-------
16
(1 row)
kvalobs=# SELECT * FROM data WHERE obstime BETWEEN '2010-09-24 20:00:00' and 'today' and cfailed like '%QC2%';
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------
99754 | 2010-09-25 00:00:00 | -32767 | 213 | 2010-09-25 00:30:40 | 330 | 0 | 0 | 1.9 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-25 00:00:00 | -32767 | 262 | 2010-09-25 00:30:40 | 330 | 0 | 0 | 85.3 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-25 00:00:00 | -32767 | 215 | 2010-09-25 00:30:40 | 330 | 0 | 0 | 2.5 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-25 00:00:00 | -32767 | 211 | 2010-09-25 00:30:40 | 330 | 0 | 0 | 2 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-25 00:00:00 | -32767 | 178 | 2010-09-25 00:30:40 | 330 | 0 | 0 | 1011.4 | 0000001100000000 | 6894900000000000 | QC2d-2
49800 | 2010-09-25 15:00:00 | -32767 | 178 | 2010-09-25 15:30:09 | 330 | 0 | 0 | 1012.5 | 0000001100000000 | 6894900000000000 | QC2d-2
49800 | 2010-09-25 15:00:00 | -32767 | 211 | 2010-09-25 15:30:09 | 330 | 0 | 0 | 5.7 | 0000001100000000 | 6894900000000000 | QC2d-2
49800 | 2010-09-25 15:00:00 | -32767 | 262 | 2010-09-25 15:30:09 | 330 | 0 | 0 | 64.5 | 0000001100000000 | 6894900000000000 | QC2d-2
49800 | 2010-09-25 15:00:00 | -32767 | 213 | 2010-09-25 15:30:09 | 330 | 0 | 0 | 5.6 | 0000001100000000 | 6894900000000000 | QC2d-2
49800 | 2010-09-25 15:00:00 | -32767 | 215 | 2010-09-25 15:30:09 | 330 | 0 | 0 | 6 | 0000001100000000 | 6894900000000000 | QC2d-2
60990 | 2010-09-25 17:00:00 | -99.9 | 178 | 2010-09-25 16:53:18 | 311 | 0 | 0 | 1017.1 | 0700001100000000 | 5894900000000001 | QC1-1-178:1,QC1-1-178x:1 QC2d-2
99754 | 2010-09-25 23:00:00 | -32767 | 262 | 2010-09-25 23:30:10 | 330 | 0 | 0 | 96.3 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-25 23:00:00 | -32767 | 178 | 2010-09-25 23:30:10 | 330 | 0 | 0 | 1015.3 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-25 23:00:00 | -32767 | 211 | 2010-09-25 23:30:10 | 330 | 0 | 0 | -0.3 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-25 23:00:00 | -32767 | 213 | 2010-09-25 23:30:10 | 330 | 0 | 0 | -0.2 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-25 23:00:00 | -32767 | 215 | 2010-09-25 23:30:10 | 330 | 0 | 0 | -0.1 | 0000001100000000 | 6894900000000000 | QC2d-2
(16 rows)
kvalobs=# select * from data_history where obstime='' and stationid=87120 and paramid=211 order by modificationtime;
kvalobs=# select * from data_history where obstime='2010-09-25 00:00:00' and stationid=99754 and paramid=213 order by modificationtime;
version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime
----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
87920142 | 99754 | 2010-09-25 00:00:00 | -32767 | 213 | 2010-09-25 00:30:40 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 | | 2010-09-25 00:30:40.458435
87974667 | 99754 | 2010-09-25 00:00:00 | | 213 | 2010-09-25 00:30:40 | 330 | 0 | 0 | | | | | 2010-09-25 06:34:00.580871
87974668 | 99754 | 2010-09-25 00:00:00 | -32767 | 213 | 2010-09-25 00:30:40 | 330 | 0 | 0 | 1.9 | 0000001100000000 | 6894900000000000 | QC2d-2 | 2010-09-25 06:34:00.622777
(3 rows)
kvalobs=# select * from data_history where obstime='2010-09-25 00:00:00' and stationid=99754 and paramid=211 order by modificationtime;
version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime
----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
87920141 | 99754 | 2010-09-25 00:00:00 | -32767 | 211 | 2010-09-25 00:30:40 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 | | 2010-09-25 00:30:40.453091
87971303 | 99754 | 2010-09-25 00:00:00 | | 211 | 2010-09-25 00:30:40 | 330 | 0 | 0 | | | | | 2010-09-25 06:08:27.567518
87971304 | 99754 | 2010-09-25 00:00:00 | -32767 | 211 | 2010-09-25 00:30:40 | 330 | 0 | 0 | 2 | 0000001100000000 | 6894900000000000 | QC2d-2 | 2010-09-25 06:08:27.606269
(3 rows)
kvalobs=# select * from data_history where obstime='2010-09-25 00:00:00' and stationid=99754 and paramid=178 order by modificationtime;
version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime
----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
87920140 | 99754 | 2010-09-25 00:00:00 | -32767 | 178 | 2010-09-25 00:30:40 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 | | 2010-09-25 00:30:40.452025
87928769 | 99754 | 2010-09-25 00:00:00 | | 178 | 2010-09-25 00:30:40 | 330 | 0 | 0 | | | | | 2010-09-25 01:42:02.857757
87928770 | 99754 | 2010-09-25 00:00:00 | -32767 | 178 | 2010-09-25 00:30:40 | 330 | 0 | 0 | 1011.4 | 0000001100000000 | 6894900000000000 | QC2d-2 | 2010-09-25 01:42:02.871307
(3 rows)
kvalobs=# select * from data_history where obstime='2010-09-25 15:00:00' and stationid=49800 and paramid=262 order by modificationtime;
version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime
----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
88053044 | 49800 | 2010-09-25 15:00:00 | -32767 | 262 | 2010-09-25 15:30:09 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 | | 2010-09-25 15:30:09.934391
88119212 | 49800 | 2010-09-25 15:00:00 | | 262 | 2010-09-25 15:30:09 | 330 | 0 | 0 | | | | | 2010-09-25 23:35:33.618095
88119213 | 49800 | 2010-09-25 15:00:00 | -32767 | 262 | 2010-09-25 15:30:09 | 330 | 0 | 0 | 64.5 | 0000001100000000 | 6894900000000000 | QC2d-2 | 2010-09-25 23:35:33.664943
(3 rows)
kvalobs=# select * from data where obstime between '2010-09-25 14:00:00' and '2010-09-25 16:00:00' and stationid=49800 and paramid=262; stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------
49800 | 2010-09-25 14:00:00 | 64 | 262 | 2010-09-25 13:59:09 | 330 | 0 | 0 | 64 | 0100000000000000 | 7000000000000000 |
49800 | 2010-09-25 15:00:00 | -32767 | 262 | 2010-09-25 15:30:09 | 330 | 0 | 0 | 64.5 | 0000001100000000 | 6894900000000000 | QC2d-2
49800 | 2010-09-25 16:00:00 | 65 | 262 | 2010-09-25 17:00:23 | 330 | 0 | 0 | 65 | 0100000000000000 | 7100000400000000 |
(3 rows)
kvalobs=#
kvalobs=# select * from data where obstime between '2010-09-25 16:00:00' and '2010-09-25 18:00:00' and stationid=60990 and paramid=178;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------
60990 | 2010-09-25 16:00:00 | 1016.6 | 178 | 2010-09-25 15:53:19 | 311 | 0 | 0 | 1016.6 | 0100000000000010 | 7000000000000000 |
60990 | 2010-09-25 17:00:00 | -99.9 | 178 | 2010-09-25 16:53:18 | 311 | 0 | 0 | 1017.1 | 0700001100000000 | 5894900000000001 | QC1-1-178:1,QC1-1-178x:1 QC2d-2
60990 | 2010-09-25 18:00:00 | 1017.6 | 178 | 2010-09-25 17:53:18 | 311 | 0 | 0 | 1017.6 | 0100000000000010 | 7000000000000000 |
(3 rows)
kvalobs=# select * from data_history where obstime='2010-09-25 17:00:00' and stationid=60990 and paramid=178 order by modificationtime;
version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime
----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------------------------------+----------------------------
88063331 | 60990 | 2010-09-25 17:00:00 | -99.9 | 178 | 2010-09-25 16:53:18 | 311 | 0 | 0 | -99.9 | 0000000000000000 | 9999900000000000 | | 2010-09-25 16:53:19.026327
88063466 | 60990 | 2010-09-25 17:00:00 | -99.9 | 178 | 2010-09-25 16:53:18 | 311 | 0 | 0 | -32767 | 0700003000000000 | 7899900000000001 | QC1-1-178:1,QC1-1-178x:1 | 2010-09-25 16:53:23.784335
88135807 | 60990 | 2010-09-25 17:00:00 | | 178 | 2010-09-25 16:53:18 | 311 | 0 | 0 | | | | | 2010-09-26 01:42:58.550019
88135808 | 60990 | 2010-09-25 17:00:00 | -99.9 | 178 | 2010-09-25 16:53:18 | 311 | 0 | 0 | 1017.1 | 0700001100000000 | 5894900000000001 | QC1-1-178:1,QC1-1-178x:1 QC2d-2 | 2010-09-26 01:42:58.597193
(4 rows)
kvalobs=# select * from data_history where obstime='2010-09-25 23:00:00' and stationid=99754 and paramid=211 order by modificationtime;
version | stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed | modificationtime
----------+-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------+----------------------------
88118974 | 99754 | 2010-09-25 23:00:00 | -32767 | 211 | 2010-09-25 23:30:10 | 330 | 0 | 0 | -32767 | 0000003000000000 | 9899900000000000 | | 2010-09-25 23:30:10.435031
88126578 | 99754 | 2010-09-25 23:00:00 | | 211 | 2010-09-25 23:30:10 | 330 | 0 | 0 | | | | | 2010-09-26 00:11:50.368793
88126579 | 99754 | 2010-09-25 23:00:00 | -32767 | 211 | 2010-09-25 23:30:10 | 330 | 0 | 0 | -0.3 | 0000001100000000 | 6894900000000000 | QC2d-2 | 2010-09-26 00:11:50.382412
(3 rows)
kvalobs=# select * from data where obstime between '2010-09-25 22:00:00' and '2010-09-26 00:00:00' and stationid=99754 and paramid=211;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------
99754 | 2010-09-25 22:00:00 | 0 | 211 | 2010-09-25 22:01:51 | 330 | 0 | 0 | 0 | 0111000000000010 | 7000000000000000 |
99754 | 2010-09-25 23:00:00 | -32767 | 211 | 2010-09-25 23:30:10 | 330 | 0 | 0 | -0.3 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-26 00:00:00 | -0.4 | 211 | 2010-09-26 00:01:55 | 330 | 0 | 0 | -0.4 | 0110000000100010 | 7000000000000000 |
(3 rows)
kvalobs=# select * from data where obstime between '2010-09-25 22:00:00' and '2010-09-26 00:00:00' and stationid=99754 and paramid=213;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------
99754 | 2010-09-25 22:00:00 | 0 | 213 | 2010-09-25 22:01:51 | 330 | 0 | 0 | 0 | 0111000000000010 | 7000000000000000 |
99754 | 2010-09-25 23:00:00 | -32767 | 213 | 2010-09-25 23:30:10 | 330 | 0 | 0 | -0.2 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-26 00:00:00 | -0.4 | 213 | 2010-09-26 00:01:55 | 330 | 0 | 0 | -0.4 | 0110000000000010 | 7000000000000000 |
(3 rows)
kvalobs=# select * from data where obstime between '2010-09-25 22:00:00' and '2010-09-26 00:00:00' and stationid=99754 and paramid=215;
stationid | obstime | original | paramid | tbtime | typeid | sensor | level | corrected | controlinfo | useinfo | cfailed
-----------+---------------------+----------+---------+---------------------+--------+--------+-------+-----------+------------------+------------------+----------
99754 | 2010-09-25 22:00:00 | 0.1 | 215 | 2010-09-25 22:01:51 | 330 | 0 | 0 | 0.1 | 0111000000000010 | 7000000000000000 |
99754 | 2010-09-25 23:00:00 | -32767 | 215 | 2010-09-25 23:30:10 | 330 | 0 | 0 | -0.1 | 0000001100000000 | 6894900000000000 | QC2d-2
99754 | 2010-09-26 00:00:00 | -0.3 | 215 | 2010-09-26 00:01:55 | 330 | 0 | 0 | -0.3 | 0110000000000010 | 7000000000000000 |
(3 rows)
kvalobs=#