User Tools

Site Tools


codes:dbaccess

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
codes:dbaccess [2023/07/07 11:35]
jlsolano [UNC Flag]
codes:dbaccess [2024/02/14 15:35] (current)
jlsolano [Last measurement at EUBREWNET]
Line 830: Line 830:
 ==== UNC Filter Flag ==== ==== 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 standard ozone ''​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 ^ ^ Name ^ Set when ^ Value ^
Line 838: Line 838:
 | FLAG_MIN_FILT | below min Ozone Value, as set in the configuration | 8 | | 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_MAX_FILT | above max Ozone Value, as set in the configuration | 16 |
-| FLAG_BLACKLIST | 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 929: 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.1688729759.txt.gz · Last modified: 2023/07/07 11:35 by jlsolano