Release Level	5.4
Release Date	2008 10
Revision Level	1.0

Time Series Data Imports

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

• manually, bulk, for larger data sets;
• automatically, from any local or remote data base, in real-time;

Bulk import, manual:

• 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