Eubrewnet Wiki

User Tools

Site Tools

Trace:
codes:dbaccess

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
codes:dbaccess [2025/02/14 14:08] – external edit 127.0.0.1codes:dbaccess [2025/10/14 13:34] (current) – [Brewer Summary] ajberjon
Line 41: Line 41:
 ^ 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]] | ^ 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]] | ^ 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 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 ==== ==== Common Inputs ====
Line 74: Line 74:
 ^ 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]] | ^ 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]] | ^ 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]] |
-^ ConfigbyDate    | Returns the available Configuration | [[codes:dbaccess#configbydate|ConfigbyDate]] |[[http://eubrewnet.aemet.es/eubrewnet/data/get/ConfigbyDate?brewerid=157&date=2015-01-01|Get Config by Date]]        |+^ 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]] | ^ 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]] | ^ 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]] |
Line 204: Line 206:
       - format: see [[codes:dbaccess#format|Format]]       - format: see [[codes:dbaccess#format|Format]]
   * Output: Standard Lamp Summary measures   * 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 
  
 ---- ----
Line 210: Line 224:
   * Function: 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.   * 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:   * Inputs:
       - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]       - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]
Line 219: Line 234:
 ---- ----
  
 +==== 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 ==== ==== HK ====
   * Function: HK   * Function: HK
Line 295: Line 381:
       - channel: number of channel to look for       - channel: number of channel to look for
   * Output: AP measurements   * 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)  |
 +
  
 ---- ----
Line 446: Line 559:
 ^ 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]]        | ^ 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]]        | ^ 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_5?brewerid=172&date=2021-05-01|Get O3L1_5ZS]]        |+^ 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]]        | ^ 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]] | ^ 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]] |
codes/dbaccess.1739542114.txt.gz · Last modified: 2025/02/14 14:08 by 127.0.0.1