Working with Time Series Data (Using TSDB)

About TSDB
The TSDB is a powerful and comprehensive time-series database that lets utilities and consultants archive, analyse and aggregate real-time and historical data, including radar images and meteorological forecasts, into user-defined actionable information. They can then use this data to drive simulations of past and future events for optimal management of integrated catchment systems.

nimrod

TSDB brings together all the relevant data from disparate sources into a single system readily available for detailed analysis using InfoWorks ICM, ICMLive and Infinity System. The tool provides accurate real-time data, enabling engineers and operators to quickly and reliably assess the integrity of the network and respond to potential overflows, flooding and other non-routine events.

Such advanced capabilities greatly enhance the ability of wastewater utilities to predict flood risks, support cost-effective drainage management and online urban flooding forecasts, and improve drainage system operation.  This enables operators to detect problems before they become events, and gives them crucial time to react and reduce or eliminate the impacts of these events.

Availability
The TSDB is standard in ICMLive and an optional component in regular InfoWorks ICM.  Within ICM, it forms part of the InfoWorks ICM Suite, which is the Full Edition of InfoWorks ICM (i.e. 1D & 2D) plus the Time Series Database (TSDB), the PDM Module and RiskMaster add-on packages. In years gone by RiskMaster, TSDB and PDM were sold as separate upgrades for ICM, but in 2015 the decision was taken to bundle them all together under the “ICM Suite” banner.

On-line Information Resources
You can find more information and some example screenshots at http://www.innovyze.com/products/icm_tsdb. Alternatively, you can download a copy of our complete Innovyze software brochure by clicking here. This contains details of all products in our “Project Management” portfolio, with the option to download a PDF of either the entire booklet or just products like TSDB.

abingdon

Video Tutorials
There are two video tutorials which you should watch to help you get started with the ICM TSDB software. The first of these is based on example data Innovyze provide (see below) and can be followed step-by-step to help learn how to use and apply TSDB.

Using TSDB with Scalar Data -> https://youtu.be/e94ykAGa0Zk

  • In this tutorial we look at the process of importing a number of different scalar based data items into a Scalar TSDB. The individual inputs consist of 3 point Inflows, 1 tidal boundary and 4 rain gauges.  As an extra complication, all the different input types are recorded at different time-steps. As part of the tutorial, a new Scalar TSDB is created, which is then connected to the network and the individual data streams added to the TSDB.  As part of the import process the timesteps of the different streams are harmonised and TVD Connectors are added to the Network to match the data streams to their respective network objects. The final part of the tutorial is to create and run a run a 24hr simulation with the Network and Scalar TSDB and then view the results across the catchment.

Using TSDB with Spatial Data -> https://youtu.be/M9XleHg8gnw

  • In this tutorial we look at the process of importing NIMROD rainfall data into a spatial TSDB. The individual inputs consist of multiple weather radar cells, each recording rainfall within the cell boundary.  This particular data type is supplied by the UKMO (United Kingdom Met Office) and updated at regular intervals throughout the day.  As part of the tutorial a new Spatial TSDB is created, then the NIMROD data is imported, with the area of coverage trimmed to the view space of the current GeoPlan.  The final part of the tutorial looks at the simulation run parameters and how to view the results as a time-varying animation showing the rainfall response in the individual radar cells across the catchment as well as the runoff response on the catchment surface and the resulting flooding on the 2D zone.

Example Data
We have created an example dataset for people to experiment with. A transportable database can be downloaded from here (1Mb ZIP file). The *.icmt contains a dataset for a small model located on the far northern coast of Scotland in the United Kingdom. As well as the network data, the transportable database also contains a number of Time Varying Data items associated with the model, including point Inflows from outlying parts of the network, the tidal boundary at the main outfall and spatially varying Rainfall for the catchment as a whole.

Share this post!

    About Andrew Walker

    Andrew Walker is a Senior Client Services Manager with Innovyze in the United Kingdom, specializing in the computerized analysis of drainage and flooding. He has over 30 years experience of modeling the key hydraulic processes involved in urban drainage design and analysis. He is one of the key members of staff tasked with supervising the roll-out and adoption of InfoWorks ICM throughout the UK and Europe.

    This entry was posted in ICMLive, InfoWorks ICM, Wastewater and tagged . Bookmark the permalink.