codes:dbaccess
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
codes:dbaccess [2023/06/23 10:48] – [GET FUNCTIONS FOR LEVEL 0] jlsolano | codes:dbaccess [2024/02/14 15:30] – [Last measurement at EUBREWNET] jlsolano | ||
---|---|---|---|
Line 93: | Line 93: | ||
^ CO | Return comments from the B files | [[codes: | ^ CO | Return comments from the B files | [[codes: | ||
^ bfiletimes | Returns the time span included in a bfile | [[codes: | ^ bfiletimes | Returns the time span included in a bfile | [[codes: | ||
- | ---- | + | |
+ | ----- | ||
Line 824: | 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 '' | ||
+ | |||
+ | ^ 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 899: | Line 917: | ||
| Ozone data filter | FLAG_MAX_FILT | Above Max Ozone Value | 16 | | | Ozone data filter | FLAG_MAX_FILT | Above Max Ozone Value | 16 | | ||
| Ozone data filter | FLAG_BLACKLIST | Date in Exclusion List | 32 | | | Ozone data filter | FLAG_BLACKLIST | Date in Exclusion List | 32 | | ||
+ | | Uncertainty data filter | FLAG_U_O3 | outside the [0,25] limit for combined uncertainty | 1024 | | ||
+ | | Uncertainty data filter | FLAG_U_O3_SYS | outside the [0,25] limit for systematic uncertainty | 2048 | | ||
+ | | Uncertainty data filter | FLAG_U_O3_RAN | outside the [0,25] limit for random uncertainty | 4096 | | ||
You can also omit any of these data filters adding '' | You can also omit any of these data filters adding '' | ||
Line 908: | Line 929: | ||
both the FLAG_OZONE_STD_FILT and FLAG_HG_FILT data filters will be ignored and all the data will have a '' | both the FLAG_OZONE_STD_FILT and FLAG_HG_FILT data filters will be ignored and all the data will have a '' | ||
+ | ---- | ||
+ | |||
+ | ===== Last measurement at EUBREWNET ===== | ||
+ | * Function: '' | ||
+ | * Example: http:// | ||
+ | * Description: | ||
+ | * Input: '' | ||
+ | * Output: one line for each Brewer, with three fields separated by commas: | ||
+ | - '' | ||
+ | - '' | ||
+ | - dss:'' | ||
+ | |||
+ | Output example: | ||
+ | |||
+ | < | ||
+ | 157, hk@14: | ||
+ | 183, co@14: | ||
+ | 185, co@14: | ||
+ | 257, hk@14: | ||
+ | 258, hk@14: | ||
+ | </ |
codes/dbaccess.txt · Last modified: 2024/06/21 10:27 by jlsolano