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/07/31 07:49] – [ConfigbyAll] ajberjoncodes:dbaccess [2025/10/14 13:34] (current) – [Brewer Summary] ajberjon
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 220: Line 234:
 ---- ----
  
-==== ConfigAll ==== +==== ConfigbyId ==== 
-  * Function: ConfigbyDate +  * Function: ConfigbyId 
-  * 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. +  * Description: Returns the configuration for a given ID. 
-  * Example: http://eubrewnet.aemet.es/eubrewnet/data/get/ConfigAll?brewerid=185&format=text+  * Example: http://eubrewnet.aemet.es/eubrewnet/data/get/ConfigbyId?id=3391&format=text
   * Inputs:   * Inputs:
-      - brewerid: see [[codes:dbaccess#common_inputs|Brewerid in common inputs]]+      - id: Configuration identification Numer 
       - format: see [[codes:dbaccess#format|Format]]       - format: see [[codes:dbaccess#format|Format]]
-      - non_operative: non-operative configurations are included in the output. +  * Output: Configuration
-  * Output: Configuration or list of configurations +
  
 ---- ----
  
 +==== 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 ==== ==== stationsFromBrewer ====
   * Function: stationsFromBrewer   * Function: stationsFromBrewer
Line 256: Line 293:
   * Example: https://eubrewnet.aemet.es/eubrewnet/data/get/brewersFromStation?stationid=9&format=text   * Example: https://eubrewnet.aemet.es/eubrewnet/data/get/brewersFromStation?stationid=9&format=text
   * Inputs:   * Inputs:
-      - stationid: Eubrewnet station id.+      - stationid or gaw_id: Eubrewnet or GAW station id.
       - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]       - date: see [[codes:dbaccess#common_inputs|Date in common inputs]]
       - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]       - enddate: see [[codes:dbaccess#common_inputs|Enddate in common inputs]]
Line 344: 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 495: 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.1753948156.txt.gz · Last modified: 2025/07/31 07:49 by ajberjon