====== Communication Tests ======
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 !
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 !
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 !
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 !
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
====== Test Case for Qc2 Single Linear ======
This test case is in reponse to version 3.2 of the ftime {{kvalobs:kvoss:system:qc2:test:algorithms:qc2-d2_flagg_08_2010_v32.pdf|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 {{kvalobs:kvoss:system:qc2:test:qc2-211-singlepointtest.db.dat.gz|FILE}} and the configuration from the [[kvalobs:kvoss:system:qc2:test:slv32#reference|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;
====== PROCEDURE ======
^Step 1^
* Open two terminals (A) and (B) on dev-vm1010 as user "kvalobs".
* (A) is for monitoring database changes and (B) for managing the algorithm
^Step 2^
* (A) Enter the kvalobs database
$ psql kvalobs
* Check for presence of no test data
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;
* Load the test data and view it with the same select statement:
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;
* Please see the [[kvalobs:kvoss:system:qc2:test:slv32#reference|Reference Section]] below for a printout of the test data that is inserted.
^Step 3^
* In terminal (B):
$ cd /etc/kvalobs/Qc2Config/
$cp SLv32.hold SLv32.cfg
* Edit the SLv32.cfg file so that the values of RunAtHour and RunAtMinute are set to the next minute. This will cause the algorithm specified in SLv32.cfg to be run in the next minute (provided there are no conflicts with another scheduled algorithm).
* If one opens a third terminal (C) when the algorithm runs may be monitored with, for example:
$tail -f /var/log/kvalobs/Qc2.log
* Approximately, one minute later check the values in the kvalobs database, i.e. on (A) Enter the command
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;
* Observe the updates to the single missing values.
^Step 4^
* (B) Edit the SLv32.cfg file so that the values of RunAtHour and RunAtMinute are set to the next minute. So that the algorithm runs again.
* Confirm that there is no change to the data. (Rerun the previous SELECT).
^Step 5^
* Change the test data so that the algorithm will make a correction again by changing the value of a neighbour.
* (A):
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;
* (B) Edit the SLv32.cfg file so that the values of RunAtHour and RunAtMinute are set to the next minute. So that the algorithm runs again.
* Confirm that there is a change to the corrected data. (Rerun the previous SELECT).
^Step 6^
* (B) Edit the SLv32.cfg file so that the values of RunAtHour and RunAtMinute are set to the next minute. So that the algorithm runs again.
* Confirm that there is no change to the data.
^Step 7^
* Change the test data so that one of the nighbours becomes invalid to run, so that the missing or rejected value is reset.
* (A):
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;
* Confirm that the data is reset to missing or rejected as appropriate. (Rerun the previous SELECT).
^Step 8^
* Run the algorithm once more and confirm that no further change occurs.
* Continue ad hoc tests if required.
* When finished remove the configuration file (B):
$rm /etc/kvalobs/Qc2Config/SLv32.cfg
* And remove the test data (A):
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;
====== RESULTS ======
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
====== Data History ======
**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.
====== Reference ======
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)
====== Operations Testing ======
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=#