codes:dbaccess
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
codes:dbaccess [2023/05/08 10:34] – [GET FUNCTIONS FOR LEVEL 0] jlsolano | codes:dbaccess [2024/02/14 15:35] – [Last measurement at EUBREWNET] jlsolano | ||
---|---|---|---|
Line 75: | Line 75: | ||
^ SLS | Returns the SL summaries | [[codes: | ^ SLS | Returns the SL summaries | [[codes: | ||
^ ConfigbyDate | ^ ConfigbyDate | ||
+ | ^ HK | Returns housekeeping Details|[[codes: | ||
^ HG | Returns the mercury lamp tests |[[codes: | ^ HG | Returns the mercury lamp tests |[[codes: | ||
^ HP | Returns the grating synchronisation tests |[[codes: | ^ HP | Returns the grating synchronisation tests |[[codes: | ||
Line 91: | Line 92: | ||
^ AVG | Returns the available AVG measures | ^ AVG | Returns the available AVG measures | ||
^ 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: | ||
- | ---- | + | ----- |
Line 216: | Line 218: | ||
---- | ---- | ||
+ | |||
+ | ==== HK ==== | ||
+ | * Function: HK | ||
+ | * Description: | ||
+ | * Inputs: | ||
+ | - brewerid: see [[codes: | ||
+ | - date: see [[codes: | ||
+ | - enddate: see [[codes: | ||
+ | - format: see [[codes: | ||
+ | * Output: instrumental parameters: temperature at the PMT, fan temperature, | ||
+ | |||
+ | |||
+ | ---- | ||
+ | |||
+ | |||
==== HP ==== | ==== HP ==== | ||
Line 396: | Line 413: | ||
- '' | - '' | ||
- '' | - '' | ||
+ | |||
+ | ---- | ||
+ | |||
+ | ==== bfiletimes ==== | ||
+ | * Function: '' | ||
+ | * Description: | ||
+ | * Example: [[https:// | ||
+ | * Input: | ||
+ | - '' | ||
+ | - '' | ||
+ | - '' | ||
+ | - '' | ||
+ | * Output: | ||
+ | - '' | ||
+ | - '' | ||
+ | - '' | ||
+ | - '' | ||
+ | - '' | ||
+ | - '' | ||
+ | - '' | ||
+ | - '' | ||
---- | ---- | ||
Line 787: | 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 843: | Line 898: | ||
===== Bypassing data filters ===== | ===== Bypassing data filters ===== | ||
- | Data with a non-zero filter_flag value will not be included in the O3L1_5 and AODL1_5 output unless ''& | + | Data with a non-zero |
https:// | https:// | ||
- | only shows data with filter_flag equal to zero, whereas | + | only shows data with '' |
https:// | https:// | ||
- | includes observations with filter_flag values of 1 and 4 which will would have been hidden were it not for the ''& | + | includes observations with filter_flag values of 1, 2, 3, 6..., which will would have been hidden were it not for the ''& |
- | The filter_flag values correspond to the following conditions and variables: | + | The '' |
^ Flag type ^ Flag name ^ Description ^ Value ^ | ^ Flag type ^ Flag name ^ Description ^ Value ^ | ||
Line 862: | 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 869: | Line 927: | ||
https:// | https:// | ||
- | 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 '' |
+ | |||
+ | ---- | ||
+ | ===== 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