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,
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:
Please note that there are also generic patterns which have NO units associated,
so they can be used for any purpose ....
- flow (m3/s)
- temperature (deg.C)
- precepitation (mm/day)
- DO, BOD, tracer (pollutant) in g/m³
Some of the other model use slightly different timeseries data. XGW uses monthly timeseries of variable length. SPILL uses hourly timeseries covering 48 hours.
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:
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.
STARTDATE (YYYYMMDD or YYYY-MM-DD)
VALUE (one per record, separated by NEWLINE)
- in the web dialog, the descriptive data (meta data) are entered;
- 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.