This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
codes:dbaccess [2023/07/07 11:38] jlsolano [UNC Filter Flag] |
codes:dbaccess [2024/02/14 15:25] jlsolano [Last measurement at EUBREWNET] |
||
---|---|---|---|
Line 839: | Line 839: | ||
| FLAG_MAX_FILT | above max Ozone Value, as set in the configuration | 16 | | | FLAG_MAX_FILT | above max Ozone Value, as set in the configuration | 16 | | ||
| FLAG_BLACKLIST | date and time included in the Exclusion List | 32 | | | FLAG_BLACKLIST | date and time included in the Exclusion List | 32 | | ||
- | | FLAG_U_O3 | outside the [0,25] limit for combined uncertainty | 1024 | | + | | FLAG_U_O3 | outside the [0,25] limit for the combined uncertainty of individual measurements | 1024 | |
- | | FLAG_U_O3_SYS | outside the [0,25] limit for systematic uncertainty | 2048 | | + | | FLAG_U_O3_SYS | outside the [0,25] limit for the systematic uncertainty of individual measurements | 2048 | |
- | | FLAG_U_O3_RAN | outside the [0,25] limit for random uncertainty | 4096 | | + | | FLAG_U_O3_RAN | outside the [0,25] limit for the random uncertainty of individual measurements | 4096 | |
---- | ---- | ||
Line 928: | Line 928: | ||
both the FLAG_OZONE_STD_FILT and FLAG_HG_FILT data filters will be ignored and all the data will have a ''filter_flag'' value of 0. | both the FLAG_OZONE_STD_FILT and FLAG_HG_FILT data filters will be ignored and all the data will have a ''filter_flag'' value of 0. | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ===== Last measurement at EUBREWNET ===== | ||
+ | * Function: ''last_measurement'' | ||
+ | * Example: http://rbcce.aemet.es/eubrewnet/stats/last_measurement?gaw_id=izo | ||
+ | * Description: by returning the type and time of the last command run at the Brewer, and the value of the last Direct Sun summary, this function provides a quick way to check the status of a Brewer connected to EUBREWNET's database | ||
+ | * Input: ''brewerid'' or ''gaw_id'', to return the data of a specific Brewer or of all the Brewers at a stations, respectively. See also [[codes:dbaccess#common_inputs|Brewerid in common inputs]] | ||
+ | * Output: one line for each Brewer, with three fields separated by commas: | ||
+ | <code> | ||
+ | brewerid, last command@time when the last command was run, dss:ozone value@time of the Direct Sun summary | ||
+ | </code> | ||
+ | |||
+ | |||