Eubrewnet Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== ACCESS FUNCTIONS ======
**Definition of the access functions that are developed in [[http://eubrewnet.aemet.es/eubrewnet|Eubrewnet]]**

The users with the right permissions have access to some functions to directly get the information stored in the database. The root of the access functions is the same for all http://eubrewnet.aemet.es/eubrewnet/data/. From this point users can select different function. As Example **Get DS**.

The DS database access function provides the Direct Sun individual measures enhanced by information from their summaries and if they are between correct Mercury Lamp Tests.
  * It receives as inputs at least a brewerid and a date: [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2016-01-01|Use of get DS with brewerid and date]]
  * Optionally, an enddate input parameter can be provided: [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2016-01-01&enddate=2016-01-07|Use of get DS with enddate]]
  * The functions accept a format input parameter for formatting the output in different ways: [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2016-01-01&format=text|Use of get DS with format]]

**Description of the DS Get Function**:
  * Function: DS
  * Description: Get the Direct Sun individual measures. Gives extra information from the summaries as the temperature or the double ratios and set a flag for mercury (hg_test) if the measure is between two correct mercury tests with a difference of 1 or less from the reference.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Direct Sun individual measures with extra values comming from:
      - Summary: temp (temperature), zenith_angle, airmass, double_ratio1, double_ratio2 
      - B file: date (in ISO 8601 format)
      - HG measures: hg_test (0: measures is not between two correct HG tests; 1: measure between two correct HG tests)

There is a [[codes:dbaccess#get_functions|Get Function Table]] with a summary of the available functions to access stored data and their links as example. The extended documentation for each function can be directly access from the table using the links in the column //Long Description//.

For products, the Eubrewnet provides an interface for processing by demand. The [[codes:dbaccess#process_functions|Process Function Table]] gives a summary of the available process functions. Even the data providers can force a process and database stored data update using the update interface. The [[codes:dbaccess#update_functions|Update Function Table]] sumarizes the available functions. Providers can force only the update of the products of their Brewers.

There are some common inputs for the functions as the parameter [[codes:dbaccess#format|format]] or the list of [[codes:dbaccess#comoninputs|common inputs]] (as the brewerid and dates) wich can be used in almost every function. The description can be found in the [[codes:dbaccess#common|COMMON SECTION]].

Examples of the use of the functions are provided for [[codes:dbaccess#matlab_2013a|Matlab 2013A]], [[codes:dbaccess#matlab_2015a|Matlab 2015A]] and [[codes:dbaccess#python|Python]] in the [[codes:dbaccess#examples|EXAMPLE SECTION]].

**For security purposes user authentication has been added to this tools and their use is registered.**

----

===== COMMON =====
==== Format ====
The access functions provide four different ways of data access using the format input parameter.
^ Format input ^ Description ^ Example ^
^ jsonM | JSON matrix formed by lists of lists (default value). The first list is formed by the value names and the following lists are the query outputs | [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2015-01-01|Get DS by default]] |
^ jsonO | JSON object of lists, where each key is the value name and its value is the time sorted list of them| [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2015-01-01&format=jsonO|Get DS with jsonO format]] |
^ text | Human readable comma separated values where first row is the value names and the following are the query outputs | [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2015-01-01&format=text|Get DS with text format]] |
^ csv | CSV direct download where first row are the value names and the following are the query outputs | [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2015-01-01&format=csv|Get DS with csv format]] |

==== Common Inputs ====
Almost all functions accept the following input options:

^ Parameter ^ Description ^ Example ^
^ brewerid | Brewer identification number | [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2015-01-01&format=text|Get function with brewerid input parameter]] |
^ date | Date in YYYY-MM-DD or JJJYY format | [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2015-01-01&format=text|Get function with date input parameter]] |
^ enddate | Date in YYYY-MM-DD or JJJYY format. If provided, the function will return the query in a date range | [[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2015-01-01&enddate=2015-01-05&format=text|Get function with enddate input parameter]] |
^ fields | Comma separated list of fields to write in the output. You can use ''myfields*'' to select all fields starting with ''myfields'' | [[http://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5?brewerid=157&date=2015-01-01&format=text&fields=gmt,o3| O3L1_5 output with just the ''gmt'' and ''o3'' fields]] |

See also the code examples in [[codes:dbaccess#matlab|matlab]] and [[codes:dbaccess#python|python]].
==== Means ====
For selected functions, passing the ''&means=xk'' variable in the URL will return the mean of all the output fields in the period specified by ''xk'', where ''x'' is a number and ''k'' is any of ''min'', ''h'' (hours), ''d'' (days), or ''M'' (months). The output includes two extra fields, ''stats_nobs'', with the number of measurements which have been used to calculate the mean, and ''stats_std_o3'' with the standard deviation of the ozone over the specified period. Examples:
   - Hourly means: http://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5?brewerid=185&date=2018-05-01&enddate=2018-05-15&format=text&means=1h
   - Daily means: http://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5?brewerid=185&date=2018-05-01&enddate=2018-06-01&format=text&means=1d

----




===== GET FUNCTIONS FOR LEVEL 0 =====

^ Function ^ Short Description ^ Long Description ^Link          ^
^ DS | Returns DS measures | [[codes:dbaccess#ds|DS]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/DS?brewerid=157&date=2015-01-01&format=text|Get DS]] |
^ DSS | Returns the DS summaries | [[codes:dbaccess#dss|DSS]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/DSS?brewerid=157&date=2015-01-01&format=text|Get DSS]] |
^ ZS | Returns ZS measures | [[codes:dbaccess#zs|ZS]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/ZS?brewerid=157&date=2015-01-01&format=text|Get ZS]] |
^ ZSS | Returns the ZS summaries | [[codes:dbaccess#zss|ZSS]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/ZSS?brewerid=157&date=2015-01-01&format=text|Get ZSS]] |
^ FM | Returns FM measures | [[codes:dbaccess#fm|FM]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/FM?brewerid=037&date=2016-01-18&format=text|Get FM]] |
^ FMS | Returns the FM summaries | [[codes:dbaccess#fms|FMS]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/FMS?brewerid=037&date=2016-01-18&format=text|Get FMS]] |
^ SL | Returns SL measures | [[codes:dbaccess#sl|SL]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/SL?brewerid=157&date=2015-01-01&format=text|Get SL]] |
^ SLS | Returns the SL summaries | [[codes:dbaccess#sls|SLS]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/SLS?brewerid=157&date=2015-01-01&format=text|Get SLS]] |
^ ConfigAll    | Returns all available configurations | [[codes:dbaccess#configall |ConfigAll]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/ConfigAll?brewerid=185 |Get all configs]]        |
^ ConfigbyDate    | Returns the configurations for a date | [[codes:dbaccess#configbydate|ConfigbyDate]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/ConfigbyDate?brewerid=157&date=2015-01-01|Get Config by Date]]        |
^ ConfigbyId    | Returns the configuration for a given ID | [[codes:dbaccess#configbyid|ConfigbyId]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/ConfigbyId?id=3391 |Get config by Id]]        |
^ HK | Returns housekeeping Details|[[codes:dbaccess#hk|HK]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/HK?brewerid=157&date=2020-07-20|Get HK]] |
^ HG | Returns the mercury lamp tests |[[codes:dbaccess#hg|HG]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/HG?brewerid=157&date=2015-01-01&format=text|Get HG]] |
^ HP | Returns the grating synchronisation tests |[[codes:dbaccess#hp|HP]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/HP?brewerid=157&date=2015-01-01&format=text|Get HP]] |
^ FV | Returns the FV tests |[[codes:dbaccess#fv|FV]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/FV?brewerid=157&date=2016-11-14&format=text|Get FV]] |
^ BFV | Returns the FV tests (from B file) |[[codes:dbaccess#bfv|BFV]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/BFV?brewerid=157&date=2015-01-01&format=text|Get BFV]] |
^ AP | Returns the AP tests (from B file) |[[codes:dbaccess#ap|AP]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/AP?brewerid=157&date=2015-01-01&format=text|Get AP]] |
^ BHeader | Returns the B File Header with INST values |[[codes:dbaccess#bheader|BHeader]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/BHeader?brewerid=157&date=2016-01-01&format=text|Get BHeader]] |
^ DTO3 | Returns the DTO3 tests (from B file) |[[codes:dbaccess#dto3|DTO3]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/DTO3?brewerid=157&date=2016-01-18&format=text|Get DTO3]] |
^ RSO3 | Returns the RSO3 tests (from B file) |[[codes:dbaccess#rso3|RSO3]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/RSO3?brewerid=157&date=2016-01-18&format=text|Get RSO3]] |
^ ActiveBrewers | Returns the number of Brewers whith at least one SL test by dates |[[codes:dbaccess#hg|HG]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/HG?brewerid=157&date=2015-01-01&format=text|Get HG]] |
^ FileStatus    | Returns the status of the received files     |[[codes:dbaccess#filestatus|FileStatus]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/FileStatus?file=B00115.157&format=text|Get FileStatus]]        |
^ ActiveBrewers    | Returns the number of Active Brewers     |[[codes:dbaccess#activebrewers|ActiveBrewers]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/ActiveBrewers?brewerid=157&date=2015-01-01&enddate=2015-01-01&format=text|Get ActiveBrewers]]        |
^ Umkehr    | Returns the Umkehr measures      |[[codes:dbaccess#umkehr|Umkehr]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/Umkehr?brewerid=48&date=2015-03-03|Get Umkehr]]        |
^ BfilesbyLocation    | Returns the Available B files for a range of locations     |[[codes:dbaccess#bfilesbylocation|BfilesbyLocation]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/BfilesByLocation?brewerid=157&date=2015-05-01&enddate=2015-08-01&location=37.1,6.73&location2=37.2,6.75&format=text|Get Bfiles by Location]]        |
^ BrewerLocation    | Returns the changes in location of a Brewer     |[[codes:dbaccess#brewerlocation|BrewerLocation]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/BrewerLocation?brewerid=185&date=2014-05-01&enddate=2015-08-01&format=text|Get Brewer Location]]        |
^ AVG    | Returns the available AVG measures      | [[codes:dbaccess#avg|AVG]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=apnavg&brewerid=070&date=2003-01-01&enddate=2014-01-01|Get AVG]]        |
^ CO     | Return comments from the B files | [[codes:dbaccess#co|CO]] | [[https://eubrewnet.aemet.es/eubrewnet/data/get/CO?brewerid=185&date=2023-01-01&format=text|Get comments]] |
^ bfiletimes | Returns the time span included in a bfile | [[codes:dbaccess#bfiletimes|bfiletimes]] | [[https://eubrewnet.aemet.es/eubrewnet/data/get/bfiletimes?brewerid=185&date=2023-01-01&enddate=2023-01-05&format=text|Get bfile time span]] |

-----


==== Descriptions ====
=== DS ===
  * Function: DS
  * Description: Get the Direct Sun individual measures. Gives extra information from the summaries as the temperature or the double ratios and set a flag for mercury (hg_test) if the measure is between two correct mercury tests with a difference of 1 or less from the reference.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Direct Sun individual measures with extra values comming from:
      - Summary: temp (temperature), zenith_angle, airmass, double_ratio1, double_ratio2 
      - B file: date (in ISO 8601 format)
      - HG measures: hg_test (0: measures is not between two correct HG tests; 1: measure between two correct HG tests)

----

==== DSS ====
  * Function: DSS
  * Description: Get the Direct Sun Summary measures. Set a flag for mercury (hg_test) if the measure is between two correct mercury tests with a difference of 1 or less from the reference.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Direct Sun Summary measures with extra value coming fromm:
      - HG measures: hg_test (0: measures is not between two correct HG tests; 1: measure between two correct HG tests)

----

==== ZS ====
  * Function: ZS
  * Description: Get the Zenith Sky individual measures. Gives extra information from the summaries as the temperature or the double ratios and set a flag for mercury (hg_test) if the measure is between two correct mercury tests with a difference of 1 or less from the reference.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Zenith Sky individual measures with extra values comming from:
      - Summary: temp (temperature), zenith_angle, airmass, double_ratio1, double_ratio2 
      - B file: date (in ISO 8601 format)
      - HG measures: hg_test (0: measures is not between two correct HG tests; 1: measure between two correct HG tests)

----

==== ZSS ====
  * Function: ZSS
  * Description: Get the Zenith Sky Summary measures. Set a flag for mercury (hg_test) if the measure is between two correct mercury tests with a difference of 1 or less from the reference.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Zenith Sky Summary measures with extra value coming fromm:
      - HG measures: hg_test (0: measures is not between two correct HG tests; 1: measure between two correct HG tests)

----

==== FM ====
  * Function: FM
  * Description: Get the Focused Moon individual measures. Gives extra information from the summaries as the temperature or the double ratios and set a flag for mercury (hg_test) if the measure is between two correct mercury tests with a difference of 1 or less from the reference.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Focused Moon individual measures with extra values comming from:
      - Summary: temp (temperature), zenith_angle, airmass, double_ratio1, double_ratio2 
      - B file: date (in ISO 8601 format)
      - HG measures: hg_test (0: measures is not between two correct HG tests; 1: measure between two correct HG tests)

----

==== FMS ====
  * Function: FMS
  * Description: Get the Focused Moon Summary measures. Set a flag for mercury (hg_test) if the measure is between two correct mercury tests with a difference of 1 or less from the reference.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Focused Moon Summary measures with extra value coming fromm:
      - HG measures: hg_test (0: measures is not between two correct HG tests; 1: measure between two correct HG tests)

----

==== SL ====
  * Function: SL
  * Description: Get the Standard Lamp individual measures. Gives extra information from the summaries as the temperature or the double ratios.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Zenith Sky individual measures with extra values comming from:
      - Summary: temp (temperature), zenith_angle, airmass, double_ratio1, double_ratio2 
  * Example: http://eubrewnet.aemet.es/eubrewnet/data/process/SL?brewerid=157&date=2026-01-01&format=text

----

==== SLS ====
  * Function: SLS
  * Description: Get the Standard Lamp Summary measures.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Standard Lamp Summary measures

----

==== ConfigAll ====
  * Function: ConfigbyDate
  * Description: Returns all configurations (see configuration information) of a given brewer. By default, only operational configurations are returned, but if the non_operative parameter is given, the function returns all configurations.
  * Example: http://eubrewnet.aemet.es/eubrewnet/data/get/ConfigAll?brewerid=185&format=text
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
      - non_operative: non-operative configurations are included in the output.
  * Output: Configuration or list of configurations 

----

==== ConfigbyDate ====
  * Function: ConfigbyDate
  * Description: Returns the latest operative configuration (see configuration info) with earlier date than given as input. If a date range is provided, returns the list of available configuration during the date range.
  * Example: http://eubrewnet.aemet.es/eubrewnet/data/get/ConfigbyDate?brewerid=185&date=2024-06-25&format=text
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Configuration or list of configurations 

----

==== ConfigbyId ====
  * Function: ConfigbyId
  * Description: Returns the configuration for a given ID.
  * Example: http://eubrewnet.aemet.es/eubrewnet/data/get/ConfigbyId?id=3391&format=text
  * Inputs:
      - id: Configuration identification Numer 
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Configuration

----

==== Brewer Summary ====	 
  * Function: ''brewer_summary''	 
  * Description: This function returns a list of the Brewers in Eubrewnet with information about their latest configuration, latest installation, whether the Brewer is active, and the number of data points retrieved.
  * Access function example: http://eubrewnet.aemet.es/eubrewnet/data/get/brewer_summary?format=text	 
  * Input: 	 
      - ''format'': see [[codes:dbaccess#format|Format]]	 
  * Output:	 
      - ''brewerid'': Brewer serial number
      - ''min_date'': Date of first measurement on Eubrewnet
      - ''max_date'': Date of last measurement on Eubrewnet	 
      - ''num_bfiles'':	Number of B files on Eubrewnet 
      - ''brewer_model'': Brewer model	 
      - ''active'': Shows whether the brewer actively sends data to Eubrewnet.	 
      - ''last_config'': Date of last configuration on Eubrewnet	 
      - ''last_station'': Last station from which data was sent
      - ''gaw_id'': The GAW station identifier from which the data was last sent
      - ''wmo_id'':	The WIGOS Station Identifier from which the data was last sent
      - ''latitude'': Latitude of the station from which the data was last sent 
      - ''longitude'': Longitude of the station from which the data was last sent 
      - ''first_name'': First name of Principal Investigator of the station from which the data was last sent 
      - ''last_name'':	Last name of Principal Investigator of the station from which the data was last sent 
		 
 		 	
 	----
==== stationsFromBrewer ====
  * Function: stationsFromBrewer
  * Description: Returns the stations where there are measurements of a certain brewer. For periods where B-files have been received, the ‘active’ field is set to ‘T’ and ‘F’ where there is no data. The stations are identified by the coordinates associated to the B-files. So if there is data from stations not registered in Eubrewnet, the station will appear as None.
  * Example: https://eubrewnet.aemet.es/eubrewnet/data/get/stationsFromBrewer?brewerid=185&format=text
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - name: station name in Eubrewnet
      - stationid: station id in Eubrewnet
      - date: start date of period	  
      - enddate: end date of period	  
      - active: indicates whether or not data has been received during this period.

----

==== brewersFromStation ====
  * Function: brewersFromStation
  * Description: returns the brewers that have sent data to Eubrewnet associated to a certain station, and in which periods they have done so.
  * Example: https://eubrewnet.aemet.es/eubrewnet/data/get/brewersFromStation?stationid=9&format=text
  * Inputs:
      - stationid or gaw_id: Eubrewnet or GAW station id.
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - name: station name in Eubrewnet
      - stationid: station id in Eubrewnet
      - date: start date of period	  
      - enddate: end date of period	  

----
==== HK ====
  * Function: HK
  * Description: Returns instrumental information to characterize the measuring conditions
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: instrumental parameters: temperature at the PMT, fan temperature, temperature of base plate, relative humidity, absolute humidity, atmospheric pressure and external temperature.


----



==== HP ====
  * Function: HP
  * Description: Returns the grating synchronisation tests with a flag (hp_test) which sets if its a passed the test or not
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Grating synchronisation test with extra value:
      - hp_test (0: incorrect HP test; 1: correct HP test)

----

==== HG ====
  * Function: HG
  * Description: Returns Mercury Tests with a mercury flag (hg_test) which sets if its a passed mercury test or not
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Mercury tests with extra value:
      - hg_test (0: measures is not between two correct HG tests; 1: measure between two correct HG tests)

----

==== FV ====
  * Function: FV
  * Description: Returns Field of view Tests 
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Field of view measurements:
      - scan format: (azimuth step, zenith step, azimuth angle, zenith angle, intensity)

----

==== BFV ====
  * Function: BFV
  * Description: Returns Field of view Tests from B file
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Field of view measurements

----

==== AP ====
  * Function: AP
  * Description: Returns AP measurements from B file
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
      - channel: number of channel to look for
  * Output: AP measurements

^ Channel ^ Description ^
| ch0     | PMT temp (deg C) |
| ch1 | Fan temp (deg C) |
| ch2 | Base temp (deg C) |
| ch3 | H.T. voltage (V) |
| ch4 | +12V power supply (V) |
| ch5 | + 5V power supply (V) |
| ch6 | -12V power supply (V) |
| ch7 | +24V power supply (V) |
| ch8 | Rate meter (V) |
| ch9 | Below Spectro temp (C) |
| ch10 | Window area temp (C) |
| ch11 | External temp (deg C) |
| ch12 | + 5V ss (V) |
| ch13 | - 5V ss (V) |
| ch14 | Std lamp current (A) |
| ch15 | Std lamp voltage (V) |
| ch16 | Mer lamp current (A) |
| ch17 | Mer lamp voltage (V) |
| ch18 | External 1 (V) |
| ch19 | External 2 (V) |
| ch20 | Relative humidity (%) |
| ch21 | Moisture (g/m3) |
| ch22 | External 4 (V)  |
| ch23 | External 5 (V)  |


----


==== BHeader ====
  * Function: BHeader
  * Description: Returns B File Header. Values like date of B file, latitude, longitude and pressure and the content of the used ICF file
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: Inst section from B file with extra fields. All of them from the B file:
      - brewerid
      - date
      - location
      - latitude
      - longitude
      - temp
      - press

----

==== DTO3 ====
  * Function: DTO3
  * Description: Returns DTO3 measurements from B file. 
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: DTO3 measurements from B file

----

==== RSO3 ====
  * Function: RSO3
  * Description: Returns RSO3 measurements from B file. 
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Output: RSO3 measurements from B file

----

==== FileStatus ====
  * Function: FileStatus
  * Description: Give the status after parsing of a file. Users can look for files for a Brewer between a range of dates or directly look for the information of a specific file.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
      - file: name of the file to see STATUS
  * Outputs: File status information as:
      - date: date of the file
      - status: error status of the Brewer (0: No error)
      - path: where to find the file
      - fname: name of the file
      - process_date, process_time: timestamp of the parsing
      - kind: kind of the file
      - text: messages thrown while file parsing

----

==== AVG ====
  * Function: AVG
  * Description: Give the stored avg measures depending on avg input parameter
  * Inputs:
      - avg: Average name (apnavg, apoavg...)
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Outputs: AVG measures

The list of available AVGS access functions is:

^ File ^ Table definition ^ Access function ^
|	apnavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=apnavg_t|apnavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=apnavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|apnavg access function]]	|
|	apoavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=apoavg_t|apoavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=apoavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|apoavg access function]]	|
|	dtnavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=dtnavg_t|dtnavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=dtnavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|dtnavg access function]]	|
|	dtoavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=dtoavg_t|dtoavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=dtoavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|dtoavg access function]]	|
|	fmnavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=fmoavg_t|fmnavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=fmnavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|fmnavg access function]]	|
|	fmoavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=fmoavg_t|fmoavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=fmoavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|fmoavg access function]]	|
|	h2oavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=h2oavg_t|h2oavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=h2oavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|h2oavg access function]]	|
|	hgoavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=hgoavg_t|hgoavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=nonavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|hgoavg access function]]	|
|	mioavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=mioavg_t|mioavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=mioavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|mioavg access function]]	|
|	nonavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=nonavg_t|nonavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=nonavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|nonavg access function]]	|
|	opavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=opavg_t|opavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=opavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|opavg access function]]	|
|	ozoavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=ozoavg_t|ozoavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=ozoavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|ozoavg access function]]	|
|	rsnavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=rsnavg_t|rsnavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=rsnavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|rsnavg access function]]	|
|	rsoavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=rsoavg_t|rsoavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=rsoavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|rsoavg access function]]	|
|	scoavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=scoavg_t|scoavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=scoavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|scoavg access function]]	|
|	slnavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=slnavg_t|slnavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=slnavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|slnavg access function]]	|
|	sloavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=sloavg_t|sloavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=sloavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|sloavg access function]]	|
|	uvoavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=uvoavg_t|uvoavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=uvoavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|uvoavg access function]]	|
|	fioavg	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/TableFields?table=fioavg_t|fioavg definition]]	|	[[http://eubrewnet.aemet.es/eubrewnet/data/get/AVG?avg=fioavg&brewerid=157&date=2015-01-01&enddate=2015-01-10|fioavg access function]]	|


----

==== CO ====
  * Function: ''CO''
  * Description: return the comments in the B file
  * Example: [[https://eubrewnet.aemet.es/eubrewnet/data/get/CO?brewerid=185&date=2023-01-01&enddate=2023-01-05&format=text&keyword=ds:]]
  * Input:
      - ''brewerid'': see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''keyword'': return only the comments than contain this keyword
      - ''format'': see [[codes:dbaccess#format|Format]]
  * Output:
      - ''brewerid''
      - ''gmt''
      - ''comment''

----

==== bfiletimes ====
  * Function: ''bfiletimes''
  * Description: return the time range, both UTC and solar, included in a B file, as determined from the first and last CO comment included in the file
  * Example: [[https://eubrewnet.aemet.es/eubrewnet/data/get/bfiletimes?brewerid=185&date=2023-01-01&enddate=2023-01-05&format=text]]
  * Input:
      - ''brewerid'': see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
  * Output:
      - ''brewerid''
      - ''bfile'': jjjyy value in the name of the bfile
      - ''gmt'': UTC time of the first CO comment in the bfile
      - ''endgmt'': UTC time of the last CO comment in the bfile
      - ''solartime'': solar time corresponding to ''gmt''
      - ''endsolartime'': solar time corresponding to ''endgmt''
      - ''longitude'': longitude of the Brewer location
      - ''bfileid'': id used by EUBREWNET to identify the bfile

----
----
===== GET FUNCTIONS FOR HIGHER LEVELS =====

The output of the GET functions is stored in Eubrewnet's database, from where it's retrieved on each function call with little further processing. They are faster than their equivalent PROCESS functions, which process the data in real time, usually starting from the previous level. Whenever possible, GET functions should be used instead of the PROCESS equivalents.

^ Function ^ Short Description ^ Long Description ^Link          ^
^ O3L1    | Returns the Level 1 of Ozone     |[[codes:dbaccess#get_O3L1|O3L1]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/O3L1?brewerid=157&date=2015-01-01&enddate=2015-01-02|Get O3L1]]        |
^ O3L1_5    | Returns the Level 1.5 of Ozone     |[[codes:dbaccess#get_O3L1_5|O3L1_5]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5?brewerid=157&date=2015-01-01&enddate=2015-01-02|Get O3L1_5]]        |
^ O3L2_0    | Returns the Level 2.0 of Ozone     |[[codes:dbaccess#get_O3L2_0|O3L2_0]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/O3L2_0?brewerid=157&date=2015-01-01&enddate=2015-01-02|Get O3L2_0]]        |
^ O3L1ZS    | Returns the Level 1 of the Zenith Sky Ozone     |[[codes:dbaccess#get_o3l1zs_o3l1_5zs_and_o3l2_0zs|O3L1ZS]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/O3L1ZS?brewerid=172&date=2021-05-01|Get O3ZS]]        |
^ O3L1_5ZS    | Returns the Level 1.5 of the Zenith Sky Ozone     |[[codes:dbaccess#get_o3l1zs_o3l1_5zs_and_o3l2_0zs|O3L1_5ZS]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5ZS?brewerid=172&date=2021-05-01|Get O3L1_5ZS]]        |
^ O3L2_0ZS    | Returns the Level 2.0 of the Zenith Sky Ozone     |[[codes:dbaccess#get_o3l1zs_o3l1_5zs_and_o3l2_0zs|O3L2_0ZS]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/O3L2_0ZS?brewerid=172&date=2021-05-01|Get O3L2_0ZS]]        |
^ O3L1byStation, O3L1_5byStation, and O3L2_0byStation | For the requested station, returns the L1, L1_5 or L2_0 ozone product | [[codes:dbaccess&#get_o3l1bystation_o3l1_5bystation_and_o3l2_0bystation|O3L1byStation,  O3L1_5byStation, and O3L2_0byStation]] | [[http://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5byStation?gaw_id=IZO&date=2020-04-05&enddate=2020-04-06&format=text|Get O3L1_5byStation]] |
^ O3L1ALLbyStation, O3L1_5ALLbyStation, and O3L2_0ALLbyStation | For the requested station, returns the L1, L1_5 or L2_0 ozone product, with both DS and ZS measurements | [[codes:dbaccess&#get_o3l1allbystation_o3l1_5allbystation_and_o3l2_0allbystation|O3L1ALLbyStation,  O3L1_5ALLbyStation, and O3L2_0ALLbyStation]] | [[https://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5ALLbyStation?gaw_id=IZO&date=2022-05-10&format=text|Get O3L1_5ALLbyStation]] |
^ O3L1PRIObyStation, O3L1_5PRIObyStation, and O3L2_0PRIObyStation | For the requested station, returns the L1, L1_5 or L2_0 ozone product, with both DS and ZS measurements -- the latter only if no DS measurements are available in the day | [[codes:dbaccess&#get_o3l1priobystation_o3l1_5priobystation_and_o3l2_0priobystation|O3L1PRIObyStation,  O3L1_5PRIObyStation, and O3L2_0PRIObyStation]] | [[https://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5PRIObyStation?gaw_id=IZO&date=2022-05-10&format=text|Get O3L1_5PRIObyStation]] |
^ UNCL1 and UNCL1_V2 | Returns the Uncertainty L1 products for the standard and V2 Ozone algorithms | [[codes:dbaccess&#get_uncl1_and_uncl1_v2|UNCL1 and UNCL1_V2]] | [[https://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1?brewerid=163&date=2019-06-03&format=text|Get UNCL1]], [[https://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1_V2?brewerid=163&date=2019-06-03&format=text|Get UNCL1_V2]] | 
^ UNCL1_5 and UNCL1_5_V2 | Returns the Uncertainty L1.5 products for the standard and V2 Ozone algorithms | [[codes:dbaccess&#get_uncl1_5_and_uncl1_5_v2|UNCL1_5 and UNCL1_5_V2]] | [[https://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1_5?brewerid=163&date=2019-06-03&format=text|Get UNCL1_5]], [[https://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1_5_V2?brewerid=163&date=2019-06-03&format=text|Get UNCL1_5_V2]] |
^ UNCL1byStation, UNCL1_V2byStation, UNCL1_5byStation and UNCL1_5_V2byStation | For the requested station, returns the Uncertainty L1 or L1.5 products for the standard or V2 Ozone algorithms | [[codes:dbaccess&#get_uncl1bystation_uncl1_v2bystation_uncl1_5bystation_and_uncl1_5_v2bystation|UNCL1byStation, UNCL1_V2byStation, UNCL1_5byStation, and UNCL1_5_V2byStation]] | [[http://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1_5byStation?gaw_id=IZO&date=2020-04-05&enddate=2020-04-06&format=text|Get UNCL1_5byStation]] |

----
==== Get O3L1 ====
  * Function: O3L1
  * Description: Give the processed Ozone calculated using standard Algorithm and Direct Sun Measures. The Operators have to upload configurations for calculation. See [[codes:ozoneproduct|Ozone Level Definition]] and [[http://eubrewnet.aemet.es/cost1207/2015/03/04/configuration-upload-intructions/|Configuration Upload Instructions]]
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
      - means: see [[codes:dbaccess#means|means]]
  * Outputs: Ozone calculated from the DS raw counts using standard algorithm from [[devel:brewerpythonmodule|Brewer Python Library]]. Measurements have been enhanced with info from:
      - DS Summaries: temperature
      - B file: latitude, longitude, pressure
      - Daily index of the Summary they belong
      - Standard Deviation for Ozone and SO2
      - Config Identification number and date
      - Date and Time when they where processed
      - Date in Continuous Index (see [[http://es.mathworks.com/help/matlab/ref/datenum.html|Matlab Datenum Ref]])
**In** [[codes:productsdescription#ozone_level_1|Products Description Ozone Level 1]] **there is a summary table with the output of this product**

----
==== Get O3L1_5 ====
  * Function: O3L1_5
  * Description: Give the processed Ozone calculated using standard Algorithm and Direct Sun Measures. The Standard Lamp corrections, ETC by filter and Straylight corrections. The measures are filtered by standard deviation, max airmass, correct mercury test, maximun and mininum values. The Operators have to upload configurations for calculation. See [[codes:ozoneproduct|Ozone Level Definition]] and [[http://eubrewnet.aemet.es/cost1207/2015/03/04/configuration-upload-intructions/|Configuration Upload Instructions]]
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
      - means: see [[codes:dbaccess#means|means]]
  * Outputs: Ozone calculated from the DS raw counts using standard algorithm from [[devel:brewerpythonmodule|Brewer Python Library]]. Measurements have been enhanced with info from:
      - Filter flag
      - Correction flag
      - r5, r6 and their references
**In** [[codes:productsdescription#ozone_level_15|Products Description Ozone Level 1.5]] **there is a summary table with product content**

----
==== Get O3L2_0 ====
  * Function: O3L2_0
  * Description: Give the processed Ozone calculated using standard Algorithm and Direct Sun Measures. The Standard Lamp corrections, ETC by filter and Straylight corrections. The measures are filtered by standard deviation, max airmass, correct mercury test, maximun and mininum values. The Operators have to upload configurations for calculation. See [[codes:ozoneproduct|Ozone Level Definition]] and [[http://eubrewnet.aemet.es/cost1207/2015/03/04/configuration-upload-intructions/|Configuration Upload Instructions]]. The Level 2.0 is available only for validated Configurations.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
      - debug: change the ouput to see the corrections that are being applied. (True)
      - rejected: returns the filtered data, too (True)
  * Outputs: Ozone calculated from the DS raw counts using standard algorithm from [[devel:brewerpythonmodule|Brewer Python Library]]. Measurements have been enhanced with info from:
      - Filter flag
      - Correction flag
      - r5, r6 and their references
  * Outputs in case that the debug input is set, the output will contain:
      - date index, solar zenith angle, airmass, temperature, filter
      - o3, o3 sl correction, o3 etc correction by slit, o3 straylight correction,
      - r6, r6 of reference, filter flag, correction flag
**In** [[codes:productsdescription#ozone_level_20|Products Description Ozone Level 2.0]] **there is a summary table with the output of this product**

----
==== Get O3L1ZS, O3L1_5ZS, and O3L2_0ZS ====
  * Functions: O3L1ZS, O3L1_5ZS, and O3L2_0ZS
  * Description: These functions provide the same output as the [[codes:dbaccess#get_o3l1|O3L1]], [[codes:dbaccess#get_o3l1_5|O3L1_5]], and [[codes:dbaccess#get_o3l2_0|O3L2_0]] described above, but for the Zenith Sky measurement. Note that the 9 empirical Zenith Sky constants must be defined in the Brewer configuration.
  * Input: same as the [[codes:dbaccess#get_o3l1|O3L1]], [[codes:dbaccess#get_o3l1_5|O3L1_5]], and [[codes:dbaccess#get_o3l2_0|O3L2_0]] functions
  * Output: same as the [[codes:dbaccess#get_o3l1|O3L1]], [[codes:dbaccess#get_o3l1_5|O3L1_5]], and [[codes:dbaccess#get_o3l2_0|O3L2_0]] functions

----
==== Get O3L1byStation, O3L1_5byStation, and O3L2_0byStation  ====
  * Functions: O3L1byStation, O3L1_5byStation, and O3L2_0byStation
  * Description: These functions provide the same output as the [[codes:dbaccess#get_o3l1|O3L1]], [[codes:dbaccess#get_o3l1_5|O3L1_5]], and [[codes:dbaccess#get_o3l2_0|O3L2_0]] described above, but for the requested station. As of September 2020, the station products will output the data of the first Brewer defined for a station, or, if not available, that of the second. If data of the second Brewer is also not available, data of the third Brewer will be used, and so on.
  * Example: http://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5byStation?gaw_id=IZO&date=2020-04-05&enddate=2020-04-06&format=text -- note that in the output there is data for both Brewers #157 and #185: the former is the first Brewer defined in the station view (http://eubrewnet.aemet.es/eubrewnet/station/view/9) but it was not operating on 2020-04-05; Brewer #183 is the second instrument defined for the station, but it was also not operating on this day, so the data of B#185 has been used.
  * Input:
      - ''gaw_id'' or ''woudc_id'': GAW or WOUDC ID of the station
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
      - ''means'': see [[codes:dbaccess#means|means]]
  * Output: same as [[codes:dbaccess#get_o3l1|O3L1]], [[codes:dbaccess#get_o3l1_5|O3L1_5]], or [[codes:dbaccess#get_o3l2_0|O3L2_0]]

----

==== Get O3L1ALLbyStation, O3L1_5ALLbyStation, and O3L2_0ALLbyStation  ====
  * Functions: O3L1ALLbyStation, O3L1_5ALLbyStation, and O3L2_0ALLbyStation
  * Description: These functions provide the same output as the [[codes:dbaccess#get_o3l1bystation_o3l1_5bystation_and_o3l2_0bystation|O3L1byStation, O3L1_5byStation, and O3L2_0byStation]] described above, but includes both DS and ZS observations.
  * Example: https://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5ALLbyStation?gaw_id=IZO&date=2022-05-10&format=text
  * Input:
      - ''gaw_id'' or ''woudc_id'': GAW or WOUDC ID of the station
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
      - ''means'': see [[codes:dbaccess#means|means]]
  * Output: the same as [[codes:dbaccess#get_o3l1bystation_o3l1_5bystation_and_o3l2_0bystation|O3L1byStation, O3L1_5byStation, and O3L2_0byStation]], plus
      - ''obscode'': a numeric code indicating whether the observation corresponds to a DS (0) or ZS (3) measurement

----

==== Get O3L1PRIObyStation, O3L1_5PRIObyStation, and O3L2_0PRIObyStation  ====
  * Functions: O3L1PRIObyStation, O3L1_5PRIObyStation, and O3L2_0PRIObyStation
  * Description: These functions provide the same output as the [[codes:dbaccess#get_o3l1bystation_o3l1_5bystation_and_o3l2_0bystation|O3L1byStation, O3L1_5byStation, and O3L2_0byStation]] described above, but includes both DS and ZS observations -- the latter only when there are no DS observations available in the day (see also the ''priority'' input option below)
  * Example: https://eubrewnet.aemet.es/eubrewnet/data/get/O3L1_5PRIObyStation?gaw_id=IZO&date=2022-05-10&format=text
  * Input:
      - ''gaw_id'' or ''woudc_id'': GAW or WOUDC ID of the station
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
      - ''means'': see [[codes:dbaccess#means|means]]
      - ''priority'': set the priority of mesaurements' types. By default, this is set to ''DS,ZS'', but the user can also select ''ZS,DS'' to show the DS measurements when no ZS are available in the day
  * Output: the same as [[codes:dbaccess#get_o3l1bystation_o3l1_5bystation_and_o3l2_0bystation|O3L1byStation, O3L1_5byStation, and O3L2_0byStation]], plus
      - ''obscode'': a numeric code indicating whether the observation corresponds to a DS (0) or ZS (3) measurement

----





==== Get brewerStationClimatology ====
  * Function: brewerStationClimatology
  * Description: This function returns the daily atmospheric parameters corresponding to the location of the Brewer spectrophotometer
  * Example: https://eubrewnet.aemet.es/eubrewnet/data/get/brewerStationClimatology?brewerid=150&date=2021-01-01&enddate=2021-01-02&format=text
  * Input:
      - ''brewerid'': this is the ID of the Brewer. This follows the format described in [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
  * Output:
      - ''brewerid'': ID of the Brewer
      - ''date'': date in YYYY-MM-DD format
      - ''name'': station's name
      - ''id'': Eubrewnet's internal station ID
      - ''latitude'': station's latitude in +N degrees
      - ''longitude'': station's longitude in +W degrees
      - ''height'': station's altitude in meters
      - ''hteff_fun'': climatological series used
      - ''h_eff'': ozone effective altitude in km
      - ''e_h_eff'': uncertainty of the ozone effective altitude in km
      - ''t_eff'': effective temperature in K
      - ''e_t_eff'': uncertainty of the effective temperature in K
      - ''press'': station's pressure in mbar
      - ''e_press'': uncertainty of the station's pressure in mbar
      - ''heff_r'': Rayleigh effective altitude in km
      - ''e_heff_r'': uncertainty of the Rayleigh effective altitude in km
      - ''h_error_m'': difference between the ERA5 and TOMS effective altitudes
      - ''h_error_std'': standard deviation of the ERA5-TOMS difference of effective altitudes
      - ''t_error_m'': difference between the ERA5 and TOMS effective temperatures
      - ''t_error_std'': standard deviation of the ERA5-TOMS difference of effective temperatures

----
==== Get UNCL1 and UNCL1_V2 ====
  * Functions: UNCL1 and UNCL1_V2
  * Description: Level 1 uncertainty product for the standard and V2 ozone algorithms.
  * Examples: https://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1?brewerid=163&date=2019-06-03&format=text, https://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1_V2?brewerid=163&date=2019-06-03&format=text
  * Input:
      - ''brewerid'': see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
  * Output: [[codes:dbaccess#Process O3L1|O3L1 fields]] plus uncertainty-specific fields:
      - ''combined'': total combined uncertainty in DU
      - ''systematic'': systematic component of the uncertainty in DU
      - ''random'': random component of the uncertainty in DU
      - ''unc_flag'': flag describing wether default or Brewer-specific configuration parameters have been used, see [[codes:dbaccess#UNC_Flag|this table]].

----
==== Get UNCL1_5 and UNCL1_5_V2 ====
  * Functions: UNCL1_5 and UNCL1_5_V2
  * Description: Level 1.5 uncertainty product calculated from the level 1 uncertainty, standard and V2 ozone algorithms. Note measurements with more 25 units in the individual (not summaries) values of the combined, systematic and/or random uncertainties are not included in the output, use [[codes:dbaccess&#process_uncl1_5_and_uncl1_5_v2|process with rejected]] to get these data.
  * Examples: https://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1_5?brewerid=163&date=2019-06-03&format=text, https://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1_5_V2?brewerid=163&date=2019-06-03&format=text
  * Input:
      - ''brewerid'': see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
  * Output: [[codes:dbaccess#Process O3L1_5|O3L1_5 fields]] plus uncertainty-specific fields:
      - ''combined'': total combined uncertainty in DU
      - ''systematic'': systematic component of the uncertainty in DU
      - ''random'': random component of the uncertainty in DU
      - ''unc_flag'': flag describing wether default or Brewer-specific configuration parameters have been used (flag values up to 2048), and if L1.5 corrections are included (flag values starting at 4096), see   [[codes:dbaccess#UNC_Flag|this table]].

----
==== Get UNCL1byStation, UNCL1_V2byStation, UNCL1_5byStation, and UNCL1_5_V2byStation  ====
  * Functions: UNCL1byStation, UNCL1_5byStation, UNCL1_V2byStation, and UNCL1_5_V2byStation
  * Description: These functions provide the same output as the [[codes:dbaccess#get_uncl1_and_uncl1_v2|UNCL1 and UNCL1_V2]], and [[codes:dbaccess#get_uncl1_5_and_uncl1_5_v2|UNCL1_5 and UNCL1_5_V2]] described above, but for the requested station. As of September 2020, the station products will output the data of the first Brewer defined for a station, or, if not available, that of the second. If data of the second Brewer is also not available, data of the third Brewer will be used, and so on.
  * Example: http://eubrewnet.aemet.es/eubrewnet/data/get/UNCL1_5byStation?gaw_id=IZO&date=2020-04-05&enddate=2020-04-06&format=text
  * Input:
      - ''gaw_id'' or ''woudc_id'': GAW or WOUDC ID of the station
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
      - ''means'': see [[codes:dbaccess#means|means]]
  * Output: same as [[codes:dbaccess#get_uncl1_and_uncl1_v2|UNCL1 and UNCL1_V2]], and [[codes:dbaccess#get_uncl1_5_and_uncl1_5_v2|UNCL1_5 and UNCL1_5_V2]]

----
----
===== PROCESS FUNCTIONS FOR HIGHER LEVELS =====

The main output of the PROCESS functions is the same as their GET equivalents, but here the calculation is done in real time, usually starting from the previous level. This makes the PROCESS functions much slower, so we recommend using the GET equivalents when available.

^ Function ^ Description ^ Help ^ Example ^
^ O3L1    | Returns the Level 1 of Ozone     |[[codes:dbaccess#process_O3L1|O3L1]] |[[http://eubrewnet.aemet.es/eubrewnet/data/process/O3L1?brewerid=157&date=2015-01-01&enddate=2015-01-02|Process O3L1]]        |
^ O3L1_5    | Returns the Level 1.5 of Ozone     |[[codes:dbaccess#process_O3L1_5|O3L1_5]] |[[http://eubrewnet.aemet.es/eubrewnet/data/process/O3L1_5?brewerid=157&date=2015-01-01&enddate=2015-01-02|Process O3L1_5]]        |
^ O3L2_0    | Returns the Level 2.0 of Ozone     |[[codes:dbaccess#process_O3L2_0|O3L2_0]] |[[http://eubrewnet.aemet.es/eubrewnet/data/process/O3L2_0?brewerid=157&date=2015-01-01&enddate=2015-01-02|Process O3L2_0]]        |
^ UNCL1 and UNCL1_V2 | Returns L1 uncertatinty for the standard and V2 Ozone algorithms | [[codes:dbaccess&#process_uncl1_and_uncl1_v2|UNCL1 and UNCL1_V2]] | [[https://eubrewnet.aemet.es/eubrewnet/data/process/UNCL1?brewerid=163&date=2019-06-03&format=text|Process UNCL1]] [[https://eubrewnet.aemet.es/eubrewnet/data/process/UNCL1_V2?brewerid=163&date=2019-06-03&format=text|Process UNCL1_V2]] |
^ UNCL1_5 and UNCL1_5_V2 | Returns L1.5 uncertatinty for the standard and V2 Ozone algorithms | [[codes:dbaccess&#process_uncl1_5_and_uncl1_5_v2|UNCL1_5 and UNCL1_5_V2]] | [[https://eubrewnet.aemet.es/eubrewnet/data/process/UNCL1_5?brewerid=163&date=2019-06-03&format=text|Process UNCL1_5]] [[https://eubrewnet.aemet.es/eubrewnet/data/process/UNCL1_5_V2?brewerid=163&date=2019-06-03&format=text|Process UNCL1_5_V2]] | 
^ TempCoef  | Returns SL Temperature analysis | [[codes:dbaccess#process_TempCoef|TempCoef]] | [[https://eubrewnet.aemet.es/eubrewnet/data/process/TempCoef?brewerid=40&tc&tmin=5&tmax=40&alpha=3&date=2021-07-06&enddate=2021-07-16&format=text|Process TempCoef]] |

----


==== Process O3L1 ====
  * Function: O3L1
  * Description: Process Ozone calculated using standard Algorithm and Direct Sun Measures. The Operators have to upload configurations for calculation. See [[codes:ozoneproduct|Ozone Level Definition]] and [[http://eubrewnet.aemet.es/cost1207/2015/03/04/configuration-upload-intructions/|Configuration Upload Instructions]]
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Outputs: Ozone calculated from the DS raw counts using standard algorithm from [[devel:brewerpythonmodule|Brewer Python Library]]. Measurements have been enhanced with info from:
      - DS Summaries: temperature
      - B file: latitude, longitude, pressure
      - Daily index of the Summary they belong
      - Standard Deviation for Ozone and SO2
      - Config Identification number and date
      - Date and Time when they where processed
      - Date in Continuous Index (see [[http://es.mathworks.com/help/matlab/ref/datenum.html|Matlab Datenum Ref]])

**In** [[codes:productsdescription#ozone_level_1|Products Description Ozone Level 1]] **there is a table with a summary of this function's output**

----

==== Process O3L1_5 ====
  * Function: O3L1_5
  * Description: Process Ozone calculated using standard Algorithm and Direct Sun Measures. The Standard Lamp corrections, ETC by filter and Straylight corrections. The measures are filtered by standard deviation, max airmass, correct mercury test, maximun and mininum values. The Operators have to upload configurations for calculation. See [[codes:ozoneproduct|Ozone Level Definition]] and [[http://eubrewnet.aemet.es/cost1207/2015/03/04/configuration-upload-intructions/|Configuration Upload Instructions]]
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
      - debug: change the ouput to see the corrections that are being applied. (True)
      - rejected: returns the filtered data, too (True)
  * Outputs: Ozone calculated from the DS raw counts using standard algorithm from [[devel:brewerpythonmodule|Brewer Python Library]]. Measurements have been enhanced with info from:
      - Filter flag
      - Correction flag
      - r5, r6 and their references
  * Outputs in case that the debug input is set, the output will contain:
      - date index, solar zenith angle, airmass, temperature, filter
      - o3, o3 sl correction, o3 etc correction by slit, o3 straylight correction,
      - r6, r6 of reference, filter flag, correction flag

**In** [[codes:productsdescription#ozone_level_15|Products Description Ozone Level 1.5]] **there is a table with a summary of this function's output**
----

==== Process O3L2_0 ====
  * Function: O3L2_0
  * Description: Process Ozone calculated using standard Algorithm and Direct Sun Measures. The Standard Lamp corrections, ETC by filter and Straylight corrections. The measures are filtered by standard deviation, max airmass, correct mercury test, maximun and mininum values. The Operators have to upload configurations for calculation. See [[codes:ozoneproduct|Ozone Level Definition]] and [[http://eubrewnet.aemet.es/cost1207/2015/03/04/configuration-upload-intructions/|Configuration Upload Instructions]]. The Level 2.0 is available only for validated Configurations.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
      - debug: change the ouput to see the corrections that are being applied. (True)
      - rejected: returns the filtered data, too (True)
  * Outputs: Ozone calculated from the DS raw counts using standard algorithm from [[devel:brewerpythonmodule|Brewer Python Library]]. Measurements have been enhanced with info from:
      - Filter flag
      - Correction flag
      - r5, r6 and their references
  * Outputs in case that the debug input is set, the output will contain:
      - date index, solar zenith angle, airmass, temperature, filter
      - o3, o3 sl correction, o3 etc correction by slit, o3 straylight correction,
      - r6, r6 of reference, filter flag, correction flag

**In** [[codes:productsdescription#ozone_level_20|Products Description Ozone Level 2.0]] **there is a table with summary of this function's output**

----
----







==== Process UNCL1 and UNCL1_V2 ====
  * Functions: UNCL1 and UNCL1_V2
  * Description: Level 1 uncertainty product for the standard and V2 ozone algorithms.
  * Examples: https://eubrewnet.aemet.es/eubrewnet/data/process/UNCL1?brewerid=163&date=2019-06-03&format=text, https://eubrewnet.aemet.es/eubrewnet/data/process/UNCL1_V2?brewerid=163&date=2019-06-03&format=text
  * Input:
      - ''brewerid'': see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
  * Output: [[codes:dbaccess#Process O3L1|O3L1 fields]] plus uncertainty-specific fields:
      - ''combined'': total combined uncertainty in DU
      - ''systematic'': systematic component of the uncertainty in DU
      - ''random'': random component of the uncertainty in DU
      - ''unc_flag'': flag describing wether default or Brewer-specific configuration parameters have been used, see [[codes:dbaccess#UNC_Flag|this table]].
      - ''u_dt_f0'', ''u_dt_f1'', ''u_dt_f2'', ''u_dt_f3'', ''u_dt_f4'', ''u_dt_f5'' : Uncertainty of the Dead Time Corrected Operational-Wavelength counts per second for slits 0, 1, 2, 3, 4, and 5 (does not include the Rayleigh correction)
      - ''u_temp_r6'': Uncertainty of the Temperature Corrected Operational counts per second for R6 (does not include the Rayleigh correction) in R6 units
      - ''u_a1_xsec_v1'' (''u_a1_xsec_v2''): Uncertainty of the absorption cross section component in (atm-cm)<sup>-1</sup> units
      - ''u_a1_grad_v1'' (''u_a1_grad_v2''): Uncertainty of the effective temperature gradient component in (atm-cm)<sup>-1</sup> units
      - ''u_a1_step_v1'' (''u_a1_step_v2''): Uncertainty of the wavelength gradient component in (atm-cm)<sup>-1</sup> units
      - ''u_a1_v1'' (''u_a1_v2)'': Uncertainty of the ozone absorption coefficient in (atm-cm)<sup>-1</sup> units
      - ''airmass_rayleigh_uncertainty'': Uncertainty of the Rayleigh Airmass
      - ''airmass_uncertainty'' (''airmass_uncertainty_v2''): Uncertainty of the Ozone Airmass
      - ''zenith_angle_uncertainty'': Uncertainty of the Solar Zenith Angle in degrees
      - ''u_ms9_v1'' (''u_ms9_v2''): Second double ratio uncertainty in R6 units
      - ''u_b'' (''u_b_v2''): Uncertainty of the weighted Rayleigh scattering coefficients in cm<sup>-1</sup>

----
==== Process UNCL1_5 and UNCL1_5_V2 ====
  * Functions: UNCL1_5 and UNCL1_5_V2
  * Description: Level 1.5 uncertainty product calculated from the level 1 uncertainty, standard and V2 ozone algorithms.
  * Examples: https://eubrewnet.aemet.es/eubrewnet/data/process/UNCL1_5?brewerid=163&date=2019-06-03&format=text, https://eubrewnet.aemet.es/eubrewnet/data/process/UNCL1_5_V2?brewerid=163&date=2019-06-03&format=text
  * Input:
      - ''brewerid'': see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - ''date'': see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - ''enddate'': see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - ''format'': see [[codes:dbaccess#format|Format]]
  * Output: [[codes:dbaccess#Process O3L1_5|O3L1_5 fields]] plus uncertainty-specific fields:
      - ''combined'': total combined uncertainty in DU
      - ''systematic'': systematic component of the uncertainty in DU
      - ''random'': random component of the uncertainty in DU
      - ''unc_flag'': flag describing wether default or Brewer-specific configuration parameters have been used (flag values up to 2048), and if L1.5 corrections are included (flag values starting at 4096), see   [[codes:dbaccess#UNC_Flag|this table]].
   * Debug output: when called with the ''debug'' input argument, the output additionally contains the following variables:
        - ''etco3rate'': ETC in R6 units
        - ''o3o3rate'': ozone absorption coefficient (A1) in (atm-cm)<sup>-1</sup>
        - ''ms9'': second double ratio in R6 units
        - ''c_etc'': ETC sensitivity component of the combined uncertainty in DU
        - ''c_meas'': Measurement sensitivity component of the combined uncertainty in DU
        - ''c_b'': Rayleigh coefficient sensitivity component of the combined uncertainty in DU
        - ''c_pressure'': Pressure sensitivity component of the combined uncertainty in DU
        - ''c_rayleigh_airmass'': Rayleigh airmass sensitivity component of the combined uncertainty in DU
        - ''c_a1'': Ozone Absorption coefficient sensitivity component of the combined uncertainty in DU
        - ''c_airmass'': Ozone airmass sensitivity component of the combined uncertainty in DU
        - ''u_ms9'': Uncertainty of the MS9 double-ratio (corrected by Rayleigh scattering) in R6 units
        - ''u_a1'': Uncertainty of the ozone absorption coefficient in (atm-cm)<sup>-1</sup>
        - ''airmass_uncertainty'': Uncertainty of the Ozone Airmass
        - ''u_sl_corr'': Uncertainty of the correction associated to the Standard Lamp in DU
        - ''u_etc_corr'': Uncertainty of the correction associated to the Filter Non-Linearity in DU
        - ''u_st_corr'': Uncertainty of the correction associated to the Stray Light in DU
        - ''e_etco3rate_v1'' (''e_etco3rate_v2''): ETC error from the Brewer configuration in R6 units
   * Rejected output: by default, measurements with more 25 units in the individual (not summaries) values of the combined, systematic and/or random uncertainties are not included in the output. You can get these measurements passing the ''&rejected'' option in the url.

----
==== UNC Flag ====

The following table describes the values of the ''unc_flag'' field found in the [[codes:dbaccess&#process_uncl1_and_uncl1_v2|UNCL1 and UNCL1_V2]] and [[codes:dbaccess&#process_uncl1_5_and_uncl1_5_v2|UNCL1_5 and UNCL1_5_V2]] functions

^ Correction ^ Component ^ Type ^ Flag ^ Default Value ^ Units ^ Source ^
| Dead Time | Measurement | Systematic | 1 | 1E-9 | sec | Fountoulakis et al., AMT 9(4), 1799-1816 (2016)|
| Temperature Coeff. | Measurement | Systematic | 2 | 0.093578 | counts/s/ºC | Campaign maximum |
| Sun Scan | Measurement | Systematic | 4 | 0.02262 | %MS9/step | Campaign maximum |
| Time (SZA) | Measurement | Systematic | 8 | 1 | sec | Software |
| Ozone Eff. Temperature (V1) | Absorption | Random | 16 | 3.95 | ºC | Climatology |
| Ozone Eff. Temperature (V2) | Absorption | Random | 16 | 1.56 | ºC | Climatology |
| Temperature Grad. | Absorption | Random | 32 | 0.0149 | (atm-cm)<sup>-1</sup>/K | Dispersion |
| Wavelength Grad. (V1) | Absorption | Random | 64 | -0.00102 | (atm-cm)<sup>-1</sup>/step | Dispersion |
| Wavelength Grad. (V2) | Absorption | Random | 64 | -0.00097 | (atm-cm)<sup>-1</sup>/step | Dispersion |
| Rayleigh Eff. Altitude | Rayleigh airmass | Random | 128 | 0.5 | km | Constant |
| Ozone Eff. Altitude (V1) | Ozone airmass | Random | 256 | 0.75 | km | Climatology |
| Ozone Eff. Altitude (V2) | Ozone airmass | Random | 256 | 0.54 | km | Climatology |
| Rayleigh Scatt. Coeff. (V1) | Scattering Coeff | Systematic | 512 | 1 | % | hard-coded |
| Rayleigh Scatt. Coeff. (V2) | Scattering Coeff | Systematic | 512 | 0.002 | % | Bodhaine et al., Journal of Atmospheric and Oceanic Technology, 16(11), 1854-1861 (1999) |
| Pressure | Pressure | Random | 1024 | 15 | milibars | Climatology |
| ETC (V1) | ETC | Systematic | 2048 | 15 | R6 | Campaing Mean |
| ETC (V2) | ETC | Systematic | 2048 | 15 | R6 | Campaing Mean |
| Standard Lamp (V1) | Standard Lamp | Systematic | 4096 | Yes/No | Dobson Units |
| Standard Lamp (V2) | Standard Lamp | Systematic | 4096 | Yes/No | Dobson Units |
| Filter No-Linearity (V1) | Filter No-Linearity | Systematic | 8192 | Yes/No | Dobson Units |
| Filter No-Linearity (V2) | Filter No-Linearity | Systematic | 8192 | 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 |

----

==== 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 |

----
----

===== UPDATE FUNCTIONS =====

These functions use the PROCESS functions to update Eubrewnet's database, so that the data is available to the GET functions. This process is automatically done when a configuration is updated, so users do not need to directly access these functions.

^ O3L1    | Update the Database content for the Level 1 of Ozone     |[[codes:dbaccess#update_O3L1|O3L1]] |[[http://eubrewnet.aemet.es/eubrewnet/data/update/O3L1?brewerid=157&date=2015-01-01&enddate=2015-01-02|Update O3L1]]        |
^ O3L1_5    | Update the Database content for 1.5 of Ozone     |[[codes:dbaccess#update_O3L1_5|O3L1_5]] |[[http://eubrewnet.aemet.es/eubrewnet/data/update/O3L1_5?brewerid=157&date=2015-01-01&enddate=2015-01-02|Update O3L1_5]]        |
^ O3L2_0    | Update the Database content for 2.0 of Ozone     |[[codes:dbaccess#update_O3L2_0|O3L2_0]] |[[http://eubrewnet.aemet.es/eubrewnet/data/update/O3L2_0?brewerid=157&date=2015-01-01&enddate=2015-01-02|Update O3L2_0]]        |

----

==== Update O3L1 ====
  * Function: O3L1
  * Description: Process and Updates Ozone calculated using standard Algorithm and Direct Sun Measures. The Operators have to upload configurations for calculation. See [[codes:ozoneproduct|Ozone Level Definition]] and [[http://eubrewnet.aemet.es/cost1207/2015/03/04/configuration-upload-intructions/|Configuration Upload Instructions]]. Only the providers of the RAW data can update the processed data. After updating, the product will be accesible using Get function.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Outputs: The time to process and update the product

----

==== Update O3L1_5 ====
  * Function: O3L1_5
  * Description: Process and Updates Ozone calculated using standard Algorithm and Direct Sun Measures. The Standard Lamp corrections, ETC by filter and Straylight corrections. The measures are filtered by standard deviation, max airmass, correct mercury test, maximun and mininum values. The Operators have to upload configurations for calculation. See [[codes:ozoneproduct|Ozone Level Definition]] and [[http://eubrewnet.aemet.es/cost1207/2015/03/04/configuration-upload-intructions/|Configuration Upload Instructions]]. Only the providers of the RAW data can update the processed data. After updating, the product will be accesible using Get function.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Outputs: The time to process and update the product

----

==== Update O3L2_0 ====
  * Function: O3L2_0
  * Description: Process and Updates Ozone calculated using standard Algorithm and Direct Sun Measures. The Standard Lamp corrections, ETC by filter and Straylight corrections. The measures are filtered by standard deviation, max airmass, correct mercury test, maximun and mininum values. The Operators have to upload configurations for calculation. See [[codes:ozoneproduct|Ozone Level Definition]] and [[http://eubrewnet.aemet.es/cost1207/2015/03/04/configuration-upload-intructions/|Configuration Upload Instructions]]. Only the providers of the RAW data can update the processed data. After updating, the product will be accesible using Get function. The Level 2.0 is available only for validated Configurations.
  * Inputs:
      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
      - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
      - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
      - format: see [[codes:dbaccess#format|Format]]
  * Outputs: The time to process and update the product

----





===== Bypassing data filters =====

Data with a non-zero ''filter_flag'' value will not be included in the O3L1_5 and AODL1_5 output unless ''&rejected'' is added included in the URL. For example, the output of 

https://eubrewnet.aemet.es/eubrewnet/data/process/O3L1_5?brewerid=185&date=2018-11-01&enddate=2018-11-02&format=text&fields=gmt,filter_flag

only shows data with ''filter_flag'' equal to zero, whereas

https://eubrewnet.aemet.es/eubrewnet/data/process/O3L1_5?brewerid=185&date=2018-11-01&enddate=2018-11-02&rejected&format=text&fields=gmt,filter_flag

includes observations with filter_flag values of 1, 2, 3, 6..., which will would have been hidden were it not for the ''&reject'' included in the URL

The ''filter_flag'' values correspond to the following conditions and variables:

^ Flag type ^ Flag name ^ Description ^ Value ^
| Ozone data filter | FLAG_OZONE_STD_FILT | Above the ozone standard deviation threshold |  1  |
| Ozone data filter | FLAG_AIRMASS_FILT | Above max airmass |  2  |
| Ozone data filter | FLAG_HG_FILT | Wrong HG |  4  |
| Ozone data filter | FLAG_MIN_FILT | Below Min Ozone Value |  8  |
| Ozone data filter | FLAG_MAX_FILT | Above Max Ozone Value |  16  |
| 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 ''allowfilter=xxx[,yyy]'' to the URL, where ''xxx'' is one of the Flag names in the above table. Note you can pass more than one Flag name, separating them by commas. Capitalization is not taken into account.

Thus for example, if the last URL is changed to

https://eubrewnet.aemet.es/eubrewnet/data/process/O3L1_5?brewerid=185&date=2018-11-01&enddate=2018-11-02&rejected=True&format=text&fields=gmt,filter_flag&allowfilter=FLAG_OZONE_STD_FILT,flag_hg_filt

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://eubrewnet.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>