Differences

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

--- codes:dbaccess [2025/08/26 12:05] – fparraro
+++ codes:dbaccess [2025/10/14 13:34] (current) – [Brewer Summary] ajberjon
@@ Line 245: / Line 245: @@
 ----
+==== 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
@@ Line 269: / Line 293: @@
   * Example: https://eubrewnet.aemet.es/eubrewnet/data/get/brewersFromStation?stationid=9&format=text
   * Inputs:
-      - stationid: Eubrewnet station id.
+      - 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]]
@@ Line 357: / Line 381: @@
       - 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)  |
 ----