Shared Tools: Reference Manual
|Release Level || 5.4
||Release Date ||2008 10
||Revision Level ||1.0
Time Series Data Imports
Time Series in AirWare are by default of hourly resolution.
They cover the following parameters with the associated (implied) units:
- Meteorological variables, including MM5 generated data:
- temperature (deg.C)
- wind speed (m/s) and direction (degree);
- precepitation (mm/hour)
- humidity (ppm)
- cloud water content (g/m3)
- pressure (mbar)
- Pollutant concentrations:
- SO2, CO, NOx, NO2, PM10, PM2.5, O3.
- Emissions: (default unit is g/s)
- SO2, CO, NOx, NO2, PM10, PM2.5, VOC.
Time series data can be imported
respective node input data. An interactive tool to IMPORT/UPLOAD additional
time series by remote users to this data base and selector list is available
with the IMPORT button at the TS selector page.
- manually, bulk, for larger data sets;
- automatically, from any local or remote data base, in real-time;
Bulk import, manual:
The import dialog for bulk import consists of the following steps:
TIMESTAMP is in the format YYYYMMDD hh:mm
- an appropriate time series file is prepared on the local client PC, e.g., using
a spreadsheet, then exported in CSV format.
The following file format is supported:
in the web dialog, the descriptive data (meta data) are entered;
after the IMPORT button was pressed, the file will be uploaded to the WaterWare
data base location on the WaterWare server;
- USER: (determined automatically)
- NAME: a descriptive (short) name for the time series that will be used
in the selector list;
- DESCRIPTION: a free text field that defines, e.g., data source
(such as the original monitoring station), method for
patching, assumptions (for synthetic time series),
- LOCATION: (selected by the user from a list of pre-defined options);
- VARIABLE: (or parameter selected from a pre-defined list) with its associated UNIT;
- SOURCE FILE: local (on the client PC) file name and path from where the data set
will be taken from; a browser option supports an interactive definition of
the source file;
- START DATE: will be determined automatically
from the time stamps of the imported data.
- TIME STEP: will be determined automatically
from the time stamps of the imported data where possible.
Preview: after import, an analysis program will check it,
and provide the user with a graphical display, plus descriptive statistics and an echo of all
data and information provided.
As an additional function, data sets can be added manually
to an existing time series, e.g., for completing or correcting existing data sets.
The user can decide whether existing values
hsould be overwritten (replaced with the new import), or only missing values patched.
Real-time automatic data import
For a given monitoring station, a real-time connection to a (remote or local)
data base that holds real-time monitoring data can be defined.
For the real-time data acquisition, paramerts include:
followed with a list of parameters (time series) defined for this monitoring stations, where for each
parameter the data base, table, column name as well as a condition (SQL WHERE clause) can be defined
- User name and pasword for data base access;
- IP address of the data base server;
- Data base type (ORACLE, MySQL, PostgreSQL);
- Data base and Table names; these will be used for all
parameters that do not have specifc, individual data base and table names defined;
- Date and time column names;
- Time shift: delay in minutes after the full hour, when the data acquisition will be attempted;
- Status to switch the import on or off.