WaterWare On-line Manuals

WaterWare
Reference & User Manual

WaterWare On-line Manuals

Release Level

6.2

Release Date

2010 05

Revision Level

1.0

Last modified on: Thursday, 20-May-10 18:52 CEST

Time Series Data import

WRM and STREAM as well as the RRM model use so-called model time series that are used as dynamic inputs for these models (and can also be generated by them, e.g., RRM generated basin outflow time series that can be used as input time series for START NODES, type subcatchment).

Model time series cover always 365/6 days of daily values, and are expected to be complete
no MISSING DATA, but of course there may be "0.0" .....

Model Time Series must be of one of the following types and with the associated (implied) units:

flow (m3/s)
temperature (deg.C)
precepitation (mm/day)
DO, BOD, tracer (pollutant) in g/m³

Please note that there are also generic patterns which have NO units associated, so they can be used for any purpose ....

Some of the other model use slightly different timeseries data. XGW uses monthly timeseries of variable length. SPILL uses hourly timeseries covering 48 hours.

Import Dialog

TS are selected, at the level of the NODE editor, to be associated with the 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.

The dialog consistes 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.
Two file formats supported:
1. ```
STARTDATE (YYYYMMDD or YYYY-MM-DD)
VALUE (one per record, separated by NEWLINE)
VALUE   

e.g:    2004-01-01
        111.0
        112.0
        111.5
        ....
```
2. ```
TIMESTAMP,VALUE  
e.g:    2004-01-01,111.0
        2004-01-02,112.0
        2004-01-03,111.5
        ....
```
Alternative STARTDATE (or TIMESTAMP) formats such are YYYY-MM-DD and YYYYMMDD. For hourly and monthly data, only format 2 is supported. For hourly data the timestamp format must be YYYYMMDD hh:mm:ss.
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 omported data.
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.

print page