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:
  1. 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)
  2. Pollutant concentrations:
    • SO2, CO, NOx, NO2, PM10, PM2.5, O3.
  3. Emissions: (default unit is g/s)
    • SO2, CO, NOx, NO2, PM10, PM2.5, VOC.

Import Dialog

Time series data can be imported
  • manually, bulk, for larger data sets;
  • automatically, from any local or remote data base, in real-time;
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.

Bulk import, manual:

The import dialog for bulk import consists of the following steps:
  • 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:
      TIMESTAMP,VALUE  
      e.g:	2004-01-01,111.0
      	2004-01-02 10:00,112.0
      	2004-01-03 11:00,111.5
      	....
      
    TIMESTAMP is in the format YYYYMMDD hh:mm

  • in the web dialog, the descriptive data (meta data) are entered;
    They include:
    • 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.
  • after the IMPORT button was pressed, the file will be uploaded to the WaterWare data base location on the WaterWare server;

    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.

Incremental manual data import

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:

  • 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.
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


© Copyright 1995-2016 by:   ESS   Environmental Software and Services GmbH AUSTRIA | print page