How to add rainfall to ICM using TSDB ? — Part 1

Source: Innovyze Support Portal

TSDB (time series database) provides a streamlined workflow for getting real-time data into ICM models. It can greatly reduce the time needed to run a model with real-time data from external sources by automating the data connection, retrieval, conversion and validation.

In this article we’ll focus on the commonly used methods to connect rainfall sources to ICM. We will cover the following 3 scenarios,

1. Bring existing calibration rainfall data into ICM
2. Bring new rainfall data sources into ICM
3. Bring spatial rainfall into ICM

Bring existing rainfall data into ICM

As shown below, we have an existing model using a rainfall event. And we would like to turn this into a TSDB.

ICM has built-in tool to import event files into a TSDB and creates tvd connectors in the network.

1. create a new TSDB
2. create a new scenario called “with_tsdb”
3. drag the TSDB into the Geoplan, you should see “scalar_tsdb [Target])”showing in the title bar.

Then call for the import tool,

Now check the TVD connectors created,

The import tool did the following,

1. import the rainfall into the TSDB
2. created TVD connector reading the rainfall from the TSDB
3. making sure the TVD connector name matches the rainfall profile name

Now we can rerun the model, the only difference is that we need to turn on “Use TSDB” and drag the TSDB into the box.

and it shows the same results.