codes:dbaccess
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| codes:dbaccess [2024/02/14 15:34] – [Last measurement at EUBREWNET] jlsolano | codes: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:// | ^ jsonO | JSON object of lists, where each key is the value name and its value is the time sorted list of them| [[http:// | ||
| ^ text | Human readable comma separated values where first row is the value names and the following are the query outputs | [[http:// | ^ text | Human readable comma separated values where first row is the value names and the following are the query outputs | [[http:// | ||
| - | ^ csv | CSV direct download where first row are the value names and the following are the query outputs | [[http:// | + | ^ csv | CSV direct download where first row are the value names and the following are the query outputs | [[http:// |
| ==== Common Inputs ==== | ==== Common Inputs ==== | ||
| Line 48: | Line 48: | ||
| ^ Parameter ^ Description ^ Example ^ | ^ Parameter ^ Description ^ Example ^ | ||
| ^ brewerid | Brewer identification number | [[http:// | ^ brewerid | Brewer identification number | [[http:// | ||
| - | ^ date | Date in YYYY-MM-DD format | [[http:// | + | ^ date | Date in YYYY-MM-DD |
| - | ^ enddate | Date in YYYY-MM-DD format. If provided, the function will return the query in a date range | [[http:// | + | ^ enddate | Date in YYYY-MM-DD |
| ^ fields | Comma separated list of fields to write in the output. You can use '' | ^ fields | Comma separated list of fields to write in the output. You can use '' | ||
| Line 74: | Line 74: | ||
| ^ SL | Returns SL measures | [[codes: | ^ SL | Returns SL measures | [[codes: | ||
| ^ SLS | Returns the SL summaries | [[codes: | ^ SLS | Returns the SL summaries | [[codes: | ||
| - | ^ ConfigbyDate | + | ^ ConfigAll |
| + | ^ ConfigbyDate | ||
| + | ^ ConfigbyId | ||
| ^ HK | Returns housekeeping Details|[[codes: | ^ HK | Returns housekeeping Details|[[codes: | ||
| ^ HG | Returns the mercury lamp tests |[[codes: | ^ HG | Returns the mercury lamp tests |[[codes: | ||
| Line 91: | Line 93: | ||
| ^ BrewerLocation | ^ BrewerLocation | ||
| ^ AVG | Returns the available AVG measures | ^ AVG | Returns the available AVG measures | ||
| - | ^ CO | Return comments from the B files | [[codes: | + | ^ CO | Return comments from the B files | [[codes: |
| - | ^ bfiletimes | Returns the time span included in a bfile | [[codes: | + | ^ bfiletimes | Returns the time span included in a bfile | [[codes: |
| ----- | ----- | ||
| Line 204: | Line 206: | ||
| - format: see [[codes: | - format: see [[codes: | ||
| * Output: Standard Lamp Summary measures | * Output: Standard Lamp Summary measures | ||
| + | |||
| + | ---- | ||
| + | |||
| + | ==== ConfigAll ==== | ||
| + | * Function: ConfigbyDate | ||
| + | * Description: | ||
| + | * Example: http:// | ||
| + | * Inputs: | ||
| + | - brewerid: see [[codes: | ||
| + | - format: see [[codes: | ||
| + | - non_operative: | ||
| + | * Output: Configuration or list of configurations | ||
| ---- | ---- | ||
| Line 210: | Line 224: | ||
| * Function: ConfigbyDate | * Function: ConfigbyDate | ||
| * Description: | * Description: | ||
| + | * Example: http:// | ||
| * Inputs: | * Inputs: | ||
| - brewerid: see [[codes: | - brewerid: see [[codes: | ||
| Line 219: | Line 234: | ||
| ---- | ---- | ||
| + | ==== ConfigbyId ==== | ||
| + | * Function: ConfigbyId | ||
| + | * Description: | ||
| + | * Example: http:// | ||
| + | * Inputs: | ||
| + | - id: Configuration identification Numer | ||
| + | - format: see [[codes: | ||
| + | * Output: Configuration | ||
| + | |||
| + | ---- | ||
| + | |||
| + | ==== Brewer Summary ==== | ||
| + | * Function: '' | ||
| + | * Description: | ||
| + | * Access function example: http:// | ||
| + | * Input: | ||
| + | - '' | ||
| + | * Output: | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | - '' | ||
| + | |||
| + | |||
| + | ---- | ||
| + | ==== stationsFromBrewer ==== | ||
| + | * Function: stationsFromBrewer | ||
| + | * Description: | ||
| + | * Example: https:// | ||
| + | * Inputs: | ||
| + | - brewerid: see [[codes: | ||
| + | - date: see [[codes: | ||
| + | - enddate: see [[codes: | ||
| + | - format: see [[codes: | ||
| + | * Output: | ||
| + | - brewerid: see [[codes: | ||
| + | - 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: | ||
| + | * Example: https:// | ||
| + | * Inputs: | ||
| + | - stationid or gaw_id: Eubrewnet or GAW station id. | ||
| + | - date: see [[codes: | ||
| + | - enddate: see [[codes: | ||
| + | - format: see [[codes: | ||
| + | * Output: | ||
| + | - brewerid: see [[codes: | ||
| + | - 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 402: | Line 515: | ||
| * Function: '' | * Function: '' | ||
| * Description: | * Description: | ||
| - | * Example: [[https://rbcce.aemet.es/ | + | * Example: [[https://eubrewnet.aemet.es/ |
| * Input: | * Input: | ||
| - '' | - '' | ||
| Line 419: | Line 532: | ||
| * Function: '' | * Function: '' | ||
| * Description: | * Description: | ||
| - | * Example: [[https://rbcce.aemet.es/ | + | * Example: [[https://eubrewnet.aemet.es/ |
| * Input: | * Input: | ||
| - '' | - '' | ||
| Line 446: | Line 559: | ||
| ^ O3L2_0 | ^ O3L2_0 | ||
| ^ O3L1ZS | ^ O3L1ZS | ||
| - | ^ O3L1_5ZS | + | ^ O3L1_5ZS |
| ^ O3L2_0ZS | ^ O3L2_0ZS | ||
| ^ O3L1byStation, | ^ O3L1byStation, | ||
| - | ^ O3L1ALLbyStation, | + | ^ O3L1ALLbyStation, |
| - | ^ O3L1PRIObyStation, | + | ^ O3L1PRIObyStation, |
| - | ^ UNCL1 and UNCL1_V2 | Returns the Uncertainty L1 products for the standard and V2 Ozone algorithms | [[codes: | + | ^ UNCL1 and UNCL1_V2 | Returns the Uncertainty L1 products for the standard and V2 Ozone algorithms | [[codes: |
| - | ^ UNCL1_5 and UNCL1_5_V2 | Returns the Uncertainty L1.5 products for the standard and V2 Ozone algorithms | [[codes: | + | ^ UNCL1_5 and UNCL1_5_V2 | Returns the Uncertainty L1.5 products for the standard and V2 Ozone algorithms | [[codes: |
| ^ UNCL1byStation, | ^ UNCL1byStation, | ||
| Line 537: | Line 650: | ||
| * Functions: O3L1ALLbyStation, | * Functions: O3L1ALLbyStation, | ||
| * Description: | * Description: | ||
| - | * Example: https://rbcce.aemet.es/ | + | * Example: https://eubrewnet.aemet.es/ |
| * Input: | * Input: | ||
| - '' | - '' | ||
| Line 552: | Line 665: | ||
| * Functions: O3L1PRIObyStation, | * Functions: O3L1PRIObyStation, | ||
| * Description: | * Description: | ||
| - | * Example: https://rbcce.aemet.es/ | + | * Example: https://eubrewnet.aemet.es/ |
| * Input: | * Input: | ||
| - '' | - '' | ||
| Line 572: | Line 685: | ||
| * Function: brewerStationClimatology | * Function: brewerStationClimatology | ||
| * Description: | * Description: | ||
| - | * Example: https://rbcce.aemet.es/ | + | * Example: https://eubrewnet.aemet.es/ |
| * Input: | * Input: | ||
| - '' | - '' | ||
| Line 604: | Line 717: | ||
| * Functions: UNCL1 and UNCL1_V2 | * Functions: UNCL1 and UNCL1_V2 | ||
| * Description: | * Description: | ||
| - | * Examples: https://rbcce.aemet.es/ | + | * Examples: https://eubrewnet.aemet.es/ |
| * Input: | * Input: | ||
| - '' | - '' | ||
| Line 620: | Line 733: | ||
| * Functions: UNCL1_5 and UNCL1_5_V2 | * Functions: UNCL1_5 and UNCL1_5_V2 | ||
| * Description: | * Description: | ||
| - | * Examples: https://rbcce.aemet.es/ | + | * Examples: https://eubrewnet.aemet.es/ |
| * Input: | * Input: | ||
| - '' | - '' | ||
| Line 655: | Line 768: | ||
| ^ O3L1_5 | ^ O3L1_5 | ||
| ^ O3L2_0 | ^ O3L2_0 | ||
| - | ^ UNCL1 and UNCL1_V2 | Returns L1 uncertatinty for the standard and V2 Ozone algorithms | [[codes: | + | ^ UNCL1 and UNCL1_V2 | Returns L1 uncertatinty for the standard and V2 Ozone algorithms | [[codes: |
| - | ^ UNCL1_5 and UNCL1_5_V2 | Returns L1.5 uncertatinty for the standard and V2 Ozone algorithms | [[codes: | + | ^ UNCL1_5 and UNCL1_5_V2 | Returns L1.5 uncertatinty for the standard and V2 Ozone algorithms | [[codes: |
| ^ TempCoef | ^ TempCoef | ||
| Line 738: | Line 851: | ||
| * Functions: UNCL1 and UNCL1_V2 | * Functions: UNCL1 and UNCL1_V2 | ||
| * Description: | * Description: | ||
| - | * Examples: https://rbcce.aemet.es/ | + | * Examples: https://eubrewnet.aemet.es/ |
| * Input: | * Input: | ||
| - '' | - '' | ||
| Line 765: | Line 878: | ||
| * Functions: UNCL1_5 and UNCL1_5_V2 | * Functions: UNCL1_5 and UNCL1_5_V2 | ||
| * Description: | * Description: | ||
| - | * Examples: https://rbcce.aemet.es/ | + | * Examples: https://eubrewnet.aemet.es/ |
| * Input: | * Input: | ||
| - '' | - '' | ||
| Line 933: | Line 1046: | ||
| ===== Last measurement at EUBREWNET ===== | ===== Last measurement at EUBREWNET ===== | ||
| * Function: '' | * Function: '' | ||
| - | * Example: http://rbcce.aemet.es/ | + | * Example: http://eubrewnet.aemet.es/ |
| * Description: | * Description: | ||
| - | * Input: '' | + | * Input: '' |
| * Output: one line for each Brewer, with three fields separated by commas: | * Output: one line for each Brewer, with three fields separated by commas: | ||
| - '' | - '' | ||
| Line 948: | Line 1061: | ||
| 258, hk@14: | 258, hk@14: | ||
| </ | </ | ||
| + | |||
codes/dbaccess.1707924865.txt.gz · Last modified: 2024/02/14 15:34 by jlsolano