Time Series Database Objects

Closed

There are two types of Time Series Database (TSDB) objects in InfoWorks ICM: Time Series Database and Spatial Time Series Database. These objects provide an intermediate store between external data sources (such as SCADA/telemetry or RADAR) and an InfoWorks ICM run.

Note

Time Series Database objects (scalar and spatial) cannot be used in simulations in conjunction with Events. However events can be imported into scalar time series databases.

This approach of intermediate storage has the following advantages:

The main differences between the Time Series Database and the Spatial Time Series Database objects are shown in the table below.

Characteristic

Time Series Database Spatial Time Series Database

Type of time varying data stored

Scalar

Spatial

Information stored in each time series data point

In a scalar TSDB, each time series data point has no geometry (i.e. no polygons) and has only one value.

Each time series data point in a spatial TSDB stores a number of polygons and a value for each of these polygons.

Number of datastreams and data sources

Scalar TSDBs can have many streams and data sources defined.

Spatial TSDBs can only contain one stream (and only one data source).

Spatial data requires much more storage than scalar data so limiting spatial TSDBs to one stream significantly helps partition the storage. Also, a model tends to have many scalar data sources (and only a few spatial data sources) so it is more manageable to keep a number of streams together in one scalar TSDB rather than have many tree objects.

Display in InfoWorks ICM

Scalar values are displayed alongside their timestamp in a grid (see Time Series Data Grid).

Spatial time series values are displayed in the GeoPlan as a theme. See Displaying Spatial Rainfall on the GeoPlan.

For an in-depth description of these two objects, see the Time Series Database topic and the Spatial Time Series Database topic.

Time Series Data Grid

Time Series Database

Spatial Time Series Database

Select date for historical view of TSDB Dialog

Editing Time Series Data

Updating Time Series Data