User Tools

Site Tools


codes:usermanual

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
codes:usermanual [2019/09/27 12:38]
jlsolano [1.1.2. Unzip the downloaded file to a pre-existing folder]
codes:usermanual [2023/11/06 15:31] (current)
jlsolano [1.1.4. Execute the client]
Line 19: Line 19:
 Either Either
  
-**a)** Download the client executable for Windows from [[http://rbcce.aemet.es/​eubrewnet/​static/​files/​client_exe.zip]]+**a)** Download the client executable for Windows from [[http://eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_exe.zip]], or the experimental Linux static binary from [[http://​rbcce.aemet.es/​eubrewnet/​static/​files/​client_linuxstatic.zip]]
  
 or or
     ​     ​
-**b)** Setup the Python 2.7 interpreter in your computer, and then download the client Python script from [[http://rbcce.aemet.es/​eubrewnet/​static/​files/​client_python.zip]]+**b)** Setup the Python 2.7 interpreter in your computer, and then download the client Python script from [[http://eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_python.zip]]
 ---- ----
  
Line 32: Line 32:
 Depending on the version of Eubrewnet'​s software client, the files extracted will be Depending on the version of Eubrewnet'​s software client, the files extracted will be
  
-**a)** for the client executable for Windows: ''​refresh.exe''​ and ''​example_client.ini''​+**a)** for the client executable for Windows ​(Linux): ''​refresh.exe'' ​(''​refresh''​) ​and ''​example_client.ini''​
  
 **b)** for client Python script: ''​refresh.py'',​ ''​example_client.ini'',​ ''​refreshdb.py'',​ ''​util.py'',​ ''​xmlrpcproxy.py'',​ ''​log.py'',​ ''​alive.py''​ (in total, 6 ''​.py''​ files and 1 ''​.ini''​)  ​ **b)** for client Python script: ''​refresh.py'',​ ''​example_client.ini'',​ ''​refreshdb.py'',​ ''​util.py'',​ ''​xmlrpcproxy.py'',​ ''​log.py'',​ ''​alive.py''​ (in total, 6 ''​.py''​ files and 1 ''​.ini''​)  ​
Line 68: Line 68:
 ==== 1.1.4. Execute the client ==== ==== 1.1.4. Execute the client ====
  
-In the case of the client executable, just double click on ''​refresh.exe''​. ​+In the case of the client executable, ​in Windows ​just double click on ''​refresh.exe''​, and in Linux run ''​./​refresh''​ from a terminal inside the refresh directory 
  
 To execute the Python script, open a console/​terminal,​ change to your work directory, and use the command ''​python refresh.py''​. ​ To execute the Python script, open a console/​terminal,​ change to your work directory, and use the command ''​python refresh.py''​. ​
Line 94: Line 94:
 This is the preferred option for PCs running Windows. It has been tested under Windows XP and 10. This is the preferred option for PCs running Windows. It has been tested under Windows XP and 10.
  
-The file is available at [[http://rbcce.aemet.es/​eubrewnet/​static/​files/​client_exe.zip]]+The file is available at [[http://eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_exe.zip]]
  
 After the download, unzip the file to your preferred location, edit the ''​client.ini''​ file (see below), and double click on ''​refresh.exe''​ to submit your data After the download, unzip the file to your preferred location, edit the ''​client.ini''​ file (see below), and double click on ''​refresh.exe''​ to submit your data
Line 104: Line 104:
 After the Python 2.7 interpreter has been installed in your system, please make sure that is included in your path -- open a console and try to execute ''​python''​ (if Python successfully starts, use ''​exit()''​ to end the interpreter). After the Python 2.7 interpreter has been installed in your system, please make sure that is included in your path -- open a console and try to execute ''​python''​ (if Python successfully starts, use ''​exit()''​ to end the interpreter).
  
-Once Python 2.7 is up and running, download Eubrewnet'​s client software from [[http://rbcce.aemet.es/​eubrewnet/​static/​files/​client_python.zip]]. Then, unzip the file to your preferred location, edit the ''​client.ini''​ file, and run the script from a console with ''​python refresh.py''​ to submit your data+Once Python 2.7 is up and running, download Eubrewnet'​s client software from [[http://eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_python.zip]]. Then, unzip the file to your preferred location, edit the ''​client.ini''​ file, and run the script from a console with ''​python refresh.py''​ to submit your data 
 + 
 +---- 
 + 
 +=== If setup fails === 
 + 
 +If you have a very old Windows computer which can't run the compiled .exe of the new version of the client, and furthermore can't run the official Python2.7 installer to use the python version, try the following options, sorted in order of complexity:​ 
 + 
 +** Easiest) ** Try to use the .exe of the old version of the client, available from [[http://​eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_exe_2014.zip]] 
 + 
 +** Normal) ** If you have an old setup of Python in your computer, try to use the python version of the old client, available from [[http://​eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_python_2014.zip]] 
 + 
 +** Most difficult) ** Download the file [[http://​eubrewnet.aemet.es/​eubrewnet/​static/​files/​Python27_32bits.zip]] and follow the instructions in the ''​running_refresh_client.txt''​ file included in the zip. In short, the zip contains a folder with the Python27 setup of a WindowsXP 32-bits computer, and you can you use it to run the python version of the new client (available from [[http://​eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_python.zip]]) 
 + 
 ---- ----
  
Line 171: Line 185:
 ==== 1.2.4. Checking the communication with the server ==== ==== 1.2.4. Checking the communication with the server ====
  
-On the local PC running the client sofware, open a web browser and try to access [[http://rbcce.aemet.es/​eubrewnet]]. If Eubrewnet'​s website doesn'​t load, check your network settings -- in particular, contact your system manager and ask if you need to set up a proxy.+On the local PC running the client sofware, open a web browser and try to access [[http://eubrewnet.aemet.es/​eubrewnet]]. If Eubrewnet'​s website doesn'​t load, check your network settings -- in particular, contact your system manager and ask if you need to set up a proxy.
  
 For debugging, it is recommended to execute the client software redirecting all the output to a log file. If running the client executable, open a console in Windows, change to the folder where ''​refresh.exe''​ is located and run the command For debugging, it is recommended to execute the client software redirecting all the output to a log file. If running the client executable, open a console in Windows, change to the folder where ''​refresh.exe''​ is located and run the command
Line 258: Line 272:
 **Q** I just sent you data from my computer: did you receive it? **Q** I just sent you data from my computer: did you receive it?
  
-**A** You can check the data yourself. The easiest way is perhaps to check the color of your Brewer on the map at [[http://rbcce.aemet.es/​eubrewnet/​default/​index]] -- Green or yellow is OK.+**A** You can check the data yourself. The easiest way is perhaps to check the color of your Brewer on the map at [[http://eubrewnet.aemet.es/​eubrewnet/​default/​index]] -- Green or yellow is OK.
  
-Another possibility is to use the "File Status Check" tool available at http://rbcce.aemet.es/​eubrewnet/​files/​status. A status value of 0 for your file means everything is OK.+Another possibility is to use the "File Status Check" tool available at http://eubrewnet.aemet.es/​eubrewnet/​files/​status. A status value of 0 for your file means everything is OK.
  
 Also, please note that communication errors usually produce some messages in the output of Eubrewnet'​s client. If you want to debug these messages, we recommend running the client redirecting the output to a log file: you just have to use ''​refresh.exe > client.log''​ or ''​python refresh.py > client.log'',​ depending on the package you donwloaded. Also, please note that communication errors usually produce some messages in the output of Eubrewnet'​s client. If you want to debug these messages, we recommend running the client redirecting the output to a log file: you just have to use ''​refresh.exe > client.log''​ or ''​python refresh.py > client.log'',​ depending on the package you donwloaded.
Line 300: Line 314:
  
 **A** Most likely, the registration of your Brewer in Eubrewnet has not been completed yet. Please, contact us at [[eubrewnet@aemet.es]] **A** Most likely, the registration of your Brewer in Eubrewnet has not been completed yet. Please, contact us at [[eubrewnet@aemet.es]]
 +
 +----
 +
 +**Q** My Windows computer is very old and I can't setup the refresh client following the steps in the Quick Setup -- help!!!
 +
 +**A** If you have a very old Windows computer which can't run the compiled .exe of the new version of the client, and furthermore can't run the official Python2.7 installer to use the python version, try the following options, sorted in order of complexity:
 +
 +** Easiest) ** Try to use the .exe of the old version of the client, available from [[http://​eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_exe_2014.zip]]
 +
 +** Normal) ** If you have an old setup of Python in your computer, try to use the python version of the old client, available from [[http://​eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_python_2014.zip]]
 +
 +** Most difficult) ** Download the file [[http://​eubrewnet.aemet.es/​eubrewnet/​static/​files/​Python27_32bits.zip]] and follow the instructions in the ''​running_refresh_client.txt''​ file included in the zip. In short, the zip contains a folder with the Python2.7 setup of a WindowsXP 32-bit computer, and you can you use it to run the python version of the new client (available from [[http://​eubrewnet.aemet.es/​eubrewnet/​static/​files/​client_python.zip]])
 +
 ---- ----
 ---- ----
Line 306: Line 333:
 The raw data (Brewer spectral measurements) sent to the Eubrewnet database have to be processed in order to get the final products (currently Total Ozone Column (O<​sub>​3</​sub>​) and sulfur dioxide (SO<​sub>​2</​sub>​) and in the future, Aerosol Optical Depth (AOD), spectral UV irradiance, Nitrogen dioxide (NO<​sub>​2</​sub>​),​ and ozone profiles). For this purpose, a number of instrumental and calibration constants have to be inserted in the data processing algorithm. The operator of each instrument is responsible for uploading and saving the configuration (i.e. the needed constants) for each product in the database. In addition to the configuration of each product, information regarding the station and the instruments should be also provided. A detailed list of all necessary configuration parameters and other useful information can be found in the following link: The raw data (Brewer spectral measurements) sent to the Eubrewnet database have to be processed in order to get the final products (currently Total Ozone Column (O<​sub>​3</​sub>​) and sulfur dioxide (SO<​sub>​2</​sub>​) and in the future, Aerosol Optical Depth (AOD), spectral UV irradiance, Nitrogen dioxide (NO<​sub>​2</​sub>​),​ and ozone profiles). For this purpose, a number of instrumental and calibration constants have to be inserted in the data processing algorithm. The operator of each instrument is responsible for uploading and saving the configuration (i.e. the needed constants) for each product in the database. In addition to the configuration of each product, information regarding the station and the instruments should be also provided. A detailed list of all necessary configuration parameters and other useful information can be found in the following link:
  
-[[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=devel:​eubrewnetconfiguration|http://​rbcce.aemet.es/​dokuwiki/​doku.php?​id=devel:​eubrewnetconfiguration]]____+[[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=devel:​eubrewnetconfiguration|http://​eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=devel:​eubrewnetconfiguration]]____
  
-Before uploading the configuration for the station and the products, the operators have to contact the system administrator ([[eubrewnet@aemet.es|eubrewnet@aemet.es]]) and provide contact information and the list of Brewers for which they are responsible. Then, they have to register in the system. When the registration is complete they are able to login the website of [[http://rbcce.aemet.es/​eubrewnet/​|Eubrewnet]] and upload the configuration. In the following there is a more detailed description of the configuration uploading process.+Before uploading the configuration for the station and the products, the operators have to contact the system administrator ([[eubrewnet@aemet.es|eubrewnet@aemet.es]]) and provide contact information and the list of Brewers for which they are responsible. Then, they have to register in the system. When the registration is complete they are able to login the website of [[http://eubrewnet.aemet.es/​eubrewnet/​|Eubrewnet]] and upload the configuration. In the following there is a more detailed description of the configuration uploading process.
  
 __Registration and login__ __Registration and login__
Line 549: Line 576:
 The registered users have access to functions which can be used to directly get the information they need (without downloading and processing the files containing this information). The root for all access functions is: The registered users have access to functions which can be used to directly get the information they need (without downloading and processing the files containing this information). The root for all access functions is:
  
- [[http://rbcce.aemet.es/​eubrewnet/​data/​|http://​rbcce.aemet.es/​eubrewnet/​data/​]]+ [[http://eubrewnet.aemet.es/​eubrewnet/​data/​|http://​eubrewnet.aemet.es/​eubrewnet/​data/​]]
  
 If the user wants to use a specific function, then he/she should add the name of the function to the above link, followed by comments which specify how the function is going to be used. There are three different types of functions: If the user wants to use a specific function, then he/she should add the name of the function to the above link, followed by comments which specify how the function is going to be used. There are three different types of functions:
Line 561: Line 588:
 The three different types of available functions are listed and shortly described in Tables 1, 2 and 3 respectivelly. The link in the last column is an example of getting data for the Brewer with serial number 157. The extended documentation for each function can be directly accessed in the Eubrewnet website by clicking on the links in the column //​Long Description//​. Extended description for each function is also provided in the following link: The three different types of available functions are listed and shortly described in Tables 1, 2 and 3 respectivelly. The link in the last column is an example of getting data for the Brewer with serial number 157. The extended documentation for each function can be directly accessed in the Eubrewnet website by clicking on the links in the column //​Long Description//​. Extended description for each function is also provided in the following link:
  
-[[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess|http://​rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess]]+[[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess|http://​eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess]]
  
 **Table 1:​**Eubrewnet access functions **Table 1:​**Eubrewnet access functions
  
 | **Function** | **Short Description** | **Long Description** | **Link** | | **Function** | **Short Description** | **Long Description** | **Link** |
-| **DS** | Returns DS measurements | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​ds|DS]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get DS]] | +| **DS** | Returns DS measurements | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​ds|DS]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get DS]] | 
-| **DSS** | Returns the DS summaries | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​dss|DSS]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DSS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get DSS]] | +| **DSS** | Returns the DS summaries | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​dss|DSS]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DSS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get DSS]] | 
-| **ZS** | Returns ZS measurements | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​zs|ZS]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​ZS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get ZS]] | +| **ZS** | Returns ZS measurements | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​zs|ZS]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​ZS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get ZS]] | 
-| **ZSS** | Returns the ZS summaries | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​zss|ZSS]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​ZSS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get ZSS]] | +| **ZSS** | Returns the ZS summaries | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​zss|ZSS]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​ZSS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get ZSS]] | 
-| **FM** | Returns FM measurements | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​fm|FM]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​FM?​brewerid=037&​amp;​date=2016-01-18&​amp;​format=text|Get FM]] | +| **FM** | Returns FM measurements | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​fm|FM]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​FM?​brewerid=037&​amp;​date=2016-01-18&​amp;​format=text|Get FM]] | 
-| **FMS** | Returns the FM summaries | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​fms|FMS]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​FMS?​brewerid=037&​amp;​date=2016-01-18&​amp;​format=text|Get FMS]] | +| **FMS** | Returns the FM summaries | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​fms|FMS]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​FMS?​brewerid=037&​amp;​date=2016-01-18&​amp;​format=text|Get FMS]] | 
-| **SL** | Returns SL measurements | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​sl|SL]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​SL?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get SL]] | +| **SL** | Returns SL measurements | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​sl|SL]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​SL?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get SL]] | 
-| **SLS** | Returns the SL summaries | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​sls|SLS]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​SLS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get SLS]] | +| **SLS** | Returns the SL summaries | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​sls|SLS]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​SLS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get SLS]] | 
-| **ConfigbyDate****** | Returns the available Configuration | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​configbydate|ConfigbyDate]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​ConfigbyDate?​brewerid=157&​amp;​date=2015-01-01|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​ConfigbyDate?​brewerid=157&​amp;​date=2015-01-01|Config]][[http://​rbcce.aemet.es/​eubrewnet/​data/​get/​ConfigbyDate?​brewerid=157&​amp;​date=2015-01-01| by Date]] | +| **ConfigbyDate****** | Returns the available Configuration | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​configbydate|ConfigbyDate]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​ConfigbyDate?​brewerid=157&​amp;​date=2015-01-01|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​ConfigbyDate?​brewerid=157&​amp;​date=2015-01-01|Config]][[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​ConfigbyDate?​brewerid=157&​amp;​date=2015-01-01| by Date]] | 
-| **HG** | Returns the mercury lamp tests | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​hg|HG]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​HG?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get HG]] | +| **HG** | Returns the mercury lamp tests | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​hg|HG]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​HG?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get HG]] | 
-| **FV** | Returns the FV tests | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​fv|FV]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​FV?​brewerid=157&​amp;​date=2016-11-14&​amp;​format=text|Get FV]] | +| **FV** | Returns the FV tests | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​fv|FV]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​FV?​brewerid=157&​amp;​date=2016-11-14&​amp;​format=text|Get FV]] | 
-| **BFV** | Returns the FV tests (from B file) | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​bfv|BFV]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​BFV?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get BFV]] | +| **BFV** | Returns the FV tests (from B file) | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​bfv|BFV]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​BFV?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get BFV]] | 
-| **AP** | Returns the AP tests (from B file) | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​ap|AP]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​AP?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get AP]] | +| **AP** | Returns the AP tests (from B file) | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​ap|AP]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​AP?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get AP]] | 
-| **SC** | Returns the SC tests (from B file) | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​sc|SC]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​SC?​brewerid=153&​amp;​date=2016-11-16&​amp;​format=text|Get SC]] | +| **SC** | Returns the SC tests (from B file) | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​sc|SC]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​SC?​brewerid=153&​amp;​date=2016-11-16&​amp;​format=text|Get SC]] | 
-| **BHeader****** | Returns the B File Header with INST values | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​bheader|BHeader]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​BHeader?​brewerid=157&​amp;​date=2016-01-01&​amp;​format=text|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​BHeader?​brewerid=157&​amp;​date=2016-01-01&​amp;​format=text|BHeader]] | +| **BHeader****** | Returns the B File Header with INST values | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​bheader|BHeader]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​BHeader?​brewerid=157&​amp;​date=2016-01-01&​amp;​format=text|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​BHeader?​brewerid=157&​amp;​date=2016-01-01&​amp;​format=text|BHeader]] | 
-| **DTO3** | Returns the DTO3 tests (from B file) | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​dto3|DTO3]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DTO3?​brewerid=157&​amp;​date=2016-01-18&​amp;​format=text|Get DTO3]] | +| **DTO3** | Returns the DTO3 tests (from B file) | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​dto3|DTO3]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DTO3?​brewerid=157&​amp;​date=2016-01-18&​amp;​format=text|Get DTO3]] | 
-| **RSO3** | Returns the RSO3 tests (from B file) | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​rso3|RSO3]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​RSO3?​brewerid=157&​amp;​date=2016-01-18&​amp;​format=text|Get RSO3]] | +| **RSO3** | Returns the RSO3 tests (from B file) | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​rso3|RSO3]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​RSO3?​brewerid=157&​amp;​date=2016-01-18&​amp;​format=text|Get RSO3]] | 
-| **ActiveBrewers****** | Returns the number of Brewers whith at least one SL test by dates | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​activebrewers|ActiveBrewers]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​ActiveBrewers?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-01&​amp;​format=text|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​ActiveBrewers?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-01&​amp;​format=text|ActiveBrewers]] | +| **ActiveBrewers****** | Returns the number of Brewers whith at least one SL test by dates | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​activebrewers|ActiveBrewers]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​ActiveBrewers?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-01&​amp;​format=text|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​ActiveBrewers?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-01&​amp;​format=text|ActiveBrewers]] | 
-| **FileStatus****** | Returns the status of the received files | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​filestatus|FileStatus]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​FileStatus?​file=B00115.157&​amp;​format=text|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​FileStatus?​file=B00115.157&​amp;​format=text|FileStatus]] | +| **FileStatus****** | Returns the status of the received files | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​filestatus|FileStatus]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​FileStatus?​file=B00115.157&​amp;​format=text|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​FileStatus?​file=B00115.157&​amp;​format=text|FileStatus]] | 
-| **Umkehr****** | Returns the Umkehr measurements | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​umkehr|Umkehr]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​Umkehr?​brewerid=48&​amp;​date=2015-03-03|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​Umkehr?​brewerid=48&​amp;​date=2015-03-03|Umkehr]] | +| **Umkehr****** | Returns the Umkehr measurements | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​umkehr|Umkehr]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​Umkehr?​brewerid=48&​amp;​date=2015-03-03|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​Umkehr?​brewerid=48&​amp;​date=2015-03-03|Umkehr]] | 
-| **BfilesbyLocation****** | Returns the Available B files for a range of locations | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​bfilesbylocation|BfilesbyLocation]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​BfilesByLocation?​brewerid=157&​amp;​date=2015-05-01&​amp;​enddate=2015-08-01&​amp;​location=37.1,​6.73&​amp;​location2=37.2,​6.75&​amp;​format=text|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​BfilesByLocation?​brewerid=157&​amp;​date=2015-05-01&​amp;​enddate=2015-08-01&​amp;​location=37.1,​6.73&​amp;​location2=37.2,​6.75&​amp;​format=text|Bfiles]][[http://​rbcce.aemet.es/​eubrewnet/​data/​get/​BfilesByLocation?​brewerid=157&​amp;​date=2015-05-01&​amp;​enddate=2015-08-01&​amp;​location=37.1,​6.73&​amp;​location2=37.2,​6.75&​amp;​format=text| by Location]] | +| **BfilesbyLocation****** | Returns the Available B files for a range of locations | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​bfilesbylocation|BfilesbyLocation]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​BfilesByLocation?​brewerid=157&​amp;​date=2015-05-01&​amp;​enddate=2015-08-01&​amp;​location=37.1,​6.73&​amp;​location2=37.2,​6.75&​amp;​format=text|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​BfilesByLocation?​brewerid=157&​amp;​date=2015-05-01&​amp;​enddate=2015-08-01&​amp;​location=37.1,​6.73&​amp;​location2=37.2,​6.75&​amp;​format=text|Bfiles]][[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​BfilesByLocation?​brewerid=157&​amp;​date=2015-05-01&​amp;​enddate=2015-08-01&​amp;​location=37.1,​6.73&​amp;​location2=37.2,​6.75&​amp;​format=text| by Location]] | 
-| **BrewerLocation****** | Returns the changes in location of a Brewer | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​brewerlocation|BrewerLocation]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​BrewerLocation?​brewerid=185&​amp;​date=2014-05-01&​amp;​enddate=2015-08-01&​amp;​format=text|Get Brewer Location]] | +| **BrewerLocation****** | Returns the changes in location of a Brewer | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​brewerlocation|BrewerLocation]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​BrewerLocation?​brewerid=185&​amp;​date=2014-05-01&​amp;​enddate=2015-08-01&​amp;​format=text|Get Brewer Location]] | 
-| **AVG** | Returns the available AVG measurements | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​avg|AVG]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​AVG?​avg=apnavg&​amp;​brewerid=070&​amp;​date=2003-01-01&​amp;​enddate=2014-01-01|Get AVG]] | +| **AVG** | Returns the available AVG measurements | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​avg|AVG]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​AVG?​avg=apnavg&​amp;​brewerid=070&​amp;​date=2003-01-01&​amp;​enddate=2014-01-01|Get AVG]] | 
-| **O3L1** | Returns the Level 1 of Ozone | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​get_o3l1|O3L1]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​O3L1?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Get O3L1]] | +| **O3L1** | Returns the Level 1 of Ozone | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​get_o3l1|O3L1]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​O3L1?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Get O3L1]] | 
-| **O3L1_5** | Returns the Level 1.5 of Ozone | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​get_o3l1_5|O3L1_5]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​O3L1_5?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Get O3L1_5]] | +| **O3L1_5** | Returns the Level 1.5 of Ozone | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​get_o3l1_5|O3L1_5]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​O3L1_5?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Get O3L1_5]] | 
-| **O3L2_0** | Returns the Level 2.0 of Ozone | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​get_o3l2_0|O3L2_0]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​O3L2_0?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Get O3L2_0]] | +| **O3L2_0** | Returns the Level 2.0 of Ozone | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​get_o3l2_0|O3L2_0]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​O3L2_0?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Get O3L2_0]] | 
-| **DZ** | Returns the DZ test results (used to get the dead time from the sun) | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DZ?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get DZ]] | +| **DZ** | Returns the DZ test results (used to get the dead time from the sun) | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DZ?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get DZ]] | 
-| **AvailableBfile****** | Returns the dates for which B files are available for a given period and a specific Brewer. | -____ | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​AvailableBfile?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​AvailableBfile?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|AvailableBfile]]____ | +| **AvailableBfile****** | Returns the dates for which B files are available for a given period and a specific Brewer. | -____ | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​AvailableBfile?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​AvailableBfile?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|AvailableBfile]]____ | 
-| **TableFields****** | Returns the fields of a specific table | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​TableFields?​table=b_ds_t|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​TableFields?​table=b_ds_t|TableFields]]____ | +| **TableFields****** | Returns the fields of a specific table | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​TableFields?​table=b_ds_t|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​TableFields?​table=b_ds_t|TableFields]]____ | 
-| **O3L1byStation** | Returns the level 1 ozone product for a specified station. The ozone comes from the Brewer which is first in the priority list. If the product is not available from the particular Brewer, then it comes from any other Brewer from which it may be available. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​O3L1byStation?​gaw_id=IZO&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get O3L1byStation]]____ | +| **O3L1byStation** | Returns the level 1 ozone product for a specified station. The ozone comes from the Brewer which is first in the priority list. If the product is not available from the particular Brewer, then it comes from any other Brewer from which it may be available. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​O3L1byStation?​gaw_id=IZO&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get O3L1byStation]]____ | 
-| **O3L1_5byStation** | Same as the previous function but returns the level 1.5 ozone product. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​O3L1_5byStation?​gaw_id=IZO&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get O3L1_5byStation]]____ | +| **O3L1_5byStation** | Same as the previous function but returns the level 1.5 ozone product. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​O3L1_5byStation?​gaw_id=IZO&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get O3L1_5byStation]]____ | 
-| **O3L2_0byStation** | Same as the previous function but returns the level 2.0 ozone product. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​O3L2_0byStation?​gaw_id=IZO&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get O3L2_0byStation]]____ | +| **O3L2_0byStation** | Same as the previous function but returns the level 2.0 ozone product. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​O3L2_0byStation?​gaw_id=IZO&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get O3L2_0byStation]]____ | 
-| **dailyOzoneMean****** | Return the daily mean ozone for a given instrument and a given time period. | -   | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​dailyOzoneMean?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​dailyOzoneMean?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|dailyOzoneMean]]____ | +| **dailyOzoneMean****** | Return the daily mean ozone for a given instrument and a given time period. | -   | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​dailyOzoneMean?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​dailyOzoneMean?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|dailyOzoneMean]]____ | 
-| **AllFiles****** | Returns a .zip file containing all files uploaded for a given Brewer and a given time period. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​AllFiles?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​AllFiles?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|AllFiles]]____ | +| **AllFiles****** | Returns a .zip file containing all files uploaded for a given Brewer and a given time period. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​AllFiles?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​AllFiles?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|AllFiles]]____ | 
-| **Files** | Returns a .zip file containing the files of a specific type uploaded for a given Brewer and a given time period. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​Files?​type=B&​amp;​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get Files]]____ | +| **Files** | Returns a .zip file containing the files of a specific type uploaded for a given Brewer and a given time period. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​Files?​type=B&​amp;​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get Files]]____ | 
-| **StationConfig****** | Returns the station configuration | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​StationConfig?​gaw_id=IZO|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​StationConfig?​gaw_id=IZO|StationConfig]]____ | +| **StationConfig****** | Returns the station configuration | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​StationConfig?​gaw_id=IZO|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​StationConfig?​gaw_id=IZO|StationConfig]]____ | 
-| **StationBrewerList****** | Returns the Brewer priority list,  if a priority list is available. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​StationBrewerList?​gaw_id=IZO&​amp;​product=ozone&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​StationBrewerList?​gaw_id=IZO&​amp;​product=ozone&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|StationBrewerList]]____ | +| **StationBrewerList****** | Returns the Brewer priority list,  if a priority list is available. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​StationBrewerList?​gaw_id=IZO&​amp;​product=ozone&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​StationBrewerList?​gaw_id=IZO&​amp;​product=ozone&​amp;​date=2015-01-01&​amp;​enddate=2015-01-10|StationBrewerList]]____ | 
-| **CompareConfigs****** | Returns all configuration constants for the specified instrument and the specified date. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​CompareConfigs?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​CompareConfigs?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|CompareConfig]]____ | +| **CompareConfigs****** | Returns all configuration constants for the specified instrument and the specified date. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​CompareConfigs?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​CompareConfigs?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|CompareConfig]]____ | 
-| **NetworkStatus****** | Returns the status of the network (Total Brewers, Total Stations, Brewer sending data, Stations sending data) | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​NetworkStatus?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​NetworkStatus?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|NetworkStatus]]____ | +| **NetworkStatus****** | Returns the status of the network (Total Brewers, Total Stations, Brewer sending data, Stations sending data) | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​NetworkStatus?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​NetworkStatus?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|NetworkStatus]]____ | 
-| **Brewerlist****** | Returns the list of all registered Brewers | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​Brewerlist|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​Brewerlist|Brewerlist]]____ | +| **Brewerlist****** | Returns the list of all registered Brewers | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​Brewerlist|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​Brewerlist|Brewerlist]]____ | 
-| **Byearly****** | Returns the number of B files for each year for a specific Brewer. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​Byearly?​brewerid=157|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​Byearly?​brewerid=157|Byearly]]____ | +| **Byearly****** | Returns the number of B files for each year for a specific Brewer. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​Byearly?​brewerid=157|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​Byearly?​brewerid=157|Byearly]]____ | 
-| **ByearlyB****** | Same as the Byearly function with a different format. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​ByearlyB?​brewerid=157|Get ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​ByearlyB?​brewerid=157|Byearly]]__B______ | +| **ByearlyB****** | Same as the Byearly function with a different format. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​ByearlyB?​brewerid=157|Get ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​ByearlyB?​brewerid=157|Byearly]]__B______ | 
-| **SCP** | Returns information for SC that have been performed between two dates and comply with the desired quality criteria. | - | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​SCP?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get SCP]]____ |+| **SCP** | Returns information for SC that have been performed between two dates and comply with the desired quality criteria. | - | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​SCP?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get SCP]]____ |
  
    
Line 614: Line 641:
 **Table 2:**process functions **Table 2:**process functions
  
-| **O3L1** | Returns the Level 1 of Ozone | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​process_o3l1|O3L1]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​process/​O3L1?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Process O3L1]] | +| **O3L1** | Returns the Level 1 of Ozone | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​process_o3l1|O3L1]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​process/​O3L1?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Process O3L1]] | 
-| **O3L1_5** | Returns the Level 1.5 of Ozone | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​process_o3l1_5|O3L1_5]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​process/​O3L1_5?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Process O3L1_5]] | +| **O3L1_5** | Returns the Level 1.5 of Ozone | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​process_o3l1_5|O3L1_5]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​process/​O3L1_5?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Process O3L1_5]] | 
-| **O3L2_0** | Returns the Level 2.0 of Ozone | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​process_o3l2_0|O3L2_0]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​process/​O3L2_0?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Process O3L2_0]] |+| **O3L2_0** | Returns the Level 2.0 of Ozone | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​process_o3l2_0|O3L2_0]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​process/​O3L2_0?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Process O3L2_0]] |
  
    
Line 622: Line 649:
 **Table 3:** update functions**** **Table 3:** update functions****
  
-| **O3L1** | Update the Database content for the Level 1 of Ozone | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​update_o3l1|O3L1]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​update/​O3L1?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Update O3L1]] | +| **O3L1** | Update the Database content for the Level 1 of Ozone | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​update_o3l1|O3L1]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​update/​O3L1?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Update O3L1]] | 
-| **O3L1_5** | Update the Database content for 1.5 of Ozone | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​update_o3l1_5|O3L1_5]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​update/​O3L1_5?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Update O3L1_5]] | +| **O3L1_5** | Update the Database content for 1.5 of Ozone | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​update_o3l1_5|O3L1_5]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​update/​O3L1_5?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Update O3L1_5]] | 
-| **O3L2_0** | Update the Database content for 2.0 of Ozone | [[http://rbcce.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​update_o3l2_0|O3L2_0]] | [[http://rbcce.aemet.es/​eubrewnet/​data/​update/​O3L2_0?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Update O3L2_0]] |+| **O3L2_0** | Update the Database content for 2.0 of Ozone | [[http://eubrewnet.aemet.es/​dokuwiki/​doku.php?​id=codes:​dbaccess#​update_o3l2_0|O3L2_0]] | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​update/​O3L2_0?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-02|Update O3L2_0]] |
  
    
Line 635: Line 662:
  
 | **Parameter** | **Description** | **Example** | | **Parameter** | **Description** | **Example** |
-| **brewerid****** | Brewer identification number | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get function with ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|brewerid]][[http://​rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text| input parameter]] | +| **brewerid****** | Brewer identification number | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get function with ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|brewerid]][[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text| input parameter]] | 
-| **date** | Date in YYYY-MM-DD format | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get function with date input parameter]] | +| **date** | Date in YYYY-MM-DD format | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get function with date input parameter]] | 
-| **enddate****** | Date in YYYY-MM-DD format. If provided, the function will return the query in a date range | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-05&​amp;​format=text|Get function with ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-05&​amp;​format=text|enddate]][[http://​rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-05&​amp;​format=text| input parameter]] |+| **enddate****** | Date in YYYY-MM-DD format. If provided, the function will return the query in a date range | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-05&​amp;​format=text|Get function with ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-05&​amp;​format=text|enddate]][[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​enddate=2015-01-05&​amp;​format=text| input parameter]] |
  
 ** ** ** **
Line 644: Line 671:
  
 | **Format input** | **Description** | **Example** | | **Format input** | **Description** | **Example** |
-| **jsonM****** | JSON matrix formed by lists of lists (default value). The first list is formed by the parameters’ names and the following lists are the query outputs | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01|Get DS by default]] | +| **jsonM****** | JSON matrix formed by lists of lists (default value). The first list is formed by the parameters’ names and the following lists are the query outputs | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01|Get DS by default]] | 
-| **jsonO****** | JSON object of lists, where each key is the parameter name and its value is the time sorted list of them | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=jsonO|Get DS with ]][[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=jsonO|jsonO]][[http://​rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=jsonO| format]] | +| **jsonO****** | JSON object of lists, where each key is the parameter name and its value is the time sorted list of them | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=jsonO|Get DS with ]][[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=jsonO|jsonO]][[http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=jsonO| format]] | 
-| **text** | Human readable, comma separated values where first row is the parameters’ names and the following are the query outputs | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get DS with text format]] | +| **text** | Human readable, comma separated values where first row is the parameters’ names and the following are the query outputs | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=text|Get DS with text format]] | 
-| **csv****** | CSV direct download where first row displays the parameters’ names and the following rows are the query outputs | [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=csv|Get DS with text format]] |+| **csv****** | CSV direct download where first row displays the parameters’ names and the following rows are the query outputs | [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2015-01-01&​amp;​format=csv|Get DS with text format]] |
  
    
  
-| **Example 3:** Using the DS function****\\ \\ The DS database access function provides the Direct Sun individual measurements as well as information from their summaries (e.g. temperature,​ the double ratios etc.) and a quality flag which denotes if they are between correct Mercury Lamp Tests. The minimum inputs are a brewerid and a date.\\ In this case all the available information for the specific date is provided. For example:\\ [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2016-01-01|http://​rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2016-01-01]]\\ Optionally, an enddate input parameter can be defined:\\ [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2016-01-01&​amp;​enddate=2016-01-07|http://​rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2016-01-01&​enddate=2016-01-07]]\\ If the enddate parameter is defined, then all information for the period between the date and the end date is provided. The default output format parameter is “text’. Though, a different output format can be defined. For example:\\ [[http://rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2016-01-01&​amp;​format=csv\\http://​rbcce.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2016-01-01&​format=csv]]\\ In all the above examples the function output includes Direct Sun individual measurements and additional information coming from: \\ ▪        DS Summary: temp (temperature),​ zenith_angle,​ airmass, double_ratio1,​ double_ratio2 \\ ▪        B file: date (in ISO 8601 format) HG measurements:​ hg_test (0: measurement is not between two correct Hg tests; 1: measurement is between two correct Hg tests) |+| **Example 3:** Using the DS function****\\ \\ The DS database access function provides the Direct Sun individual measurements as well as information from their summaries (e.g. temperature,​ the double ratios etc.) and a quality flag which denotes if they are between correct Mercury Lamp Tests. The minimum inputs are a brewerid and a date.\\ In this case all the available information for the specific date is provided. For example:\\ [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2016-01-01|http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2016-01-01]]\\ Optionally, an enddate input parameter can be defined:\\ [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2016-01-01&​amp;​enddate=2016-01-07|http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2016-01-01&​enddate=2016-01-07]]\\ If the enddate parameter is defined, then all information for the period between the date and the end date is provided. The default output format parameter is “text’. Though, a different output format can be defined. For example:\\ [[http://eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​amp;​date=2016-01-01&​amp;​format=csv\\http://​eubrewnet.aemet.es/​eubrewnet/​data/​get/​DS?​brewerid=157&​date=2016-01-01&​format=csv]]\\ In all the above examples the function output includes Direct Sun individual measurements and additional information coming from: \\ ▪        DS Summary: temp (temperature),​ zenith_angle,​ airmass, double_ratio1,​ double_ratio2 \\ ▪        B file: date (in ISO 8601 format) HG measurements:​ hg_test (0: measurement is not between two correct Hg tests; 1: measurement is between two correct Hg tests) |
  
 ---- ----
codes/usermanual.1569587919.txt.gz · Last modified: 2019/09/27 12:38 by jlsolano