codes:dbaccess
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
codes:dbaccess [2023/07/07 11:25] jlsolano [Bypassing data filters] |
codes:dbaccess [2024/02/14 15:35] (current) jlsolano [Last measurement at EUBREWNET] |
||
|---|---|---|---|
| Line 825: | Line 825: | ||
| | Stray Light (V1) | Stray Light | Systematic | 16384 | Yes/No | Dobson Units | | | Stray Light (V1) | Stray Light | Systematic | 16384 | Yes/No | Dobson Units | | ||
| | Stray Light (V2) | Stray Light | Systematic | 16384 | Yes/No | Dobson Units | | | Stray Light (V2) | Stray Light | Systematic | 16384 | Yes/No | Dobson Units | | ||
| + | |||
| + | ---- | ||
| + | |||
| + | ==== UNC Filter Flag ==== | ||
| + | |||
| + | The following table describes the values of the ''filter_flag'' field found in the [[codes:dbaccess&#process_uncl1_5_and_uncl1_5_v2|UNCL1_5 and UNCL1_5_V2]] functions. Note the values below 1024 correspond to the [[codes:ozoneproduct&#level_15_realtime_observation|standard ozone ''filter_flag'']] | ||
| + | |||
| + | ^ Name ^ Set when ^ Value ^ | ||
| + | | FLAG_OZONE_STD_FILT | Ozone standard deviation above 2.5 (ds) or 5 (zs), unless another values is set in the configuration | 1 | | ||
| + | | FLAG_AIRMASS_FILT | above airmass 3.5 (brewers affected by straylight) or 6 (straylight correction provided or MKIII), unless another value is set in the configuration | 2 | | ||
| + | | FLAG_HG_FILT | no valid HG | 4 | | ||
| + | | FLAG_MIN_FILT | below min Ozone Value, as set in the configuration | 8 | | ||
| + | | 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_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 the systematic uncertainty of individual measurements | 2048 | | ||
| + | | FLAG_U_O3_RAN | outside the [0,25] limit for the random uncertainty of individual measurements | 4096 | | ||
| ---- | ---- | ||
| Line 912: | Line 929: | ||
| 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 most recent command run at the Brewer on the present day, and the value of the most recent 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 present at a station, respectively | ||
| + | * Output: one line for each Brewer, with three fields separated by commas: | ||
| + | - ''brewerid'', | ||
| + | - ''last command''@''time when the last command was run'', | ||
| + | - dss:''ozone value''@''time of the Direct Sun summary'' | ||
| + | * Output example: | ||
| + | <code> | ||
| + | 157, hk@14:49:54, dss:289.1@14:46:22 | ||
| + | 183, co@14:40:40, dss:286.8@12:06:03 | ||
| + | 185, co@14:24:57, dss:283.9@10:45:09 | ||
| + | 257, hk@14:50:02, dss:289.1@14:48:14 | ||
| + | 258, hk@14:48:17, dss:283.3@14:42:50 | ||
| + | </code> | ||
codes/dbaccess.1688729124.txt.gz ยท Last modified: 2023/07/07 11:25 by jlsolano
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 3.0 Unported
