How do I enter time series field data and add it to my graph?


  Applies To     
  Product(s):


WaterGEMS, SewerGEMS, CivilStorm, SewerCAD, WaterCAD

 
  Version(s): All  

Problem

How do I enter time series field data and add it to my graph? (so that I can graph observed data along with calculated results)

Background

If you have observed data that you would like to plot on a graph for an element so that you can view it layered on top of your model data, Time Series Field data can be used. This enables you to see how well calibrated your model data is to your field data and help identify differences in your model.

Using the SCADA Element instead

The Time Series Field Data feature is still available for legacy purposes but has been effectively replaced with the more powerful SCADA Element. The latest versions of the Water and Storm/Sewer products have a SCADA Element, which is a much better option for viewing field data alongside model results.

Legacy Documentation for Time Series Field Data

The following section is preserved for legacy purposes as this feature has been replaced with the SCADA Element (see above).

To use Time Series Field data:

1) Go to Components > Time Series Field Data

2) Right click on the element that you'd like to enter time series field data for and choose 'Add'

  

3) Choose the associated modeling attribute (property) which you will be creating the time series field data for

4) Choose the start date and time the data was collected, click the ellipsis button next to the element row to select that element in the drawing to which the time series field data will be associated with, and finally enter your time series field data in the table below.

5) In the model right click on the element you added the time series field data for and choose graph. When the graph series options dialog opens you can select Flow under the common or results section which will add your model results to the graph. Next, go to the time series field data result (highlighted below in red) and select the time series field data property. 

Troubleshooting Time Series Field Data

My time series data is not lining up with my results

  1. Check your time series field data start date/time compared to the simulation start date/time. See the below article for more.
  2. There is a known issue in version 10.03.02.75 and earlier related to the time units (reference # 499940). Make sure the units used in the time series field data match the units in your graph. Right click on X axis (horizontal dark line below the graph), choose Time Properties, change the time unit, click OK.

It takes too long to set this up for many elements

Consider the SCADA Signal feature. See article below for more.

Importing Time Series Data Using ModelBuilder

As mentioned at the beginning of this article, the SCADA Element is the preferred approach, and you can configure the SCADA Signal to read directly from your SCADA data (database connection or file-based) without having to set up the necessary ModelBuilder configuration for bulk import.

If you must use time series field data and need to import it via ModelBuilder, it needs to be done in two passes (two separate imports with two separate worksheets/tables (for Excel or Access data source). Determine the necessary syntax for mapped fields by first creating a test/fake time series field data entry, then set up a ModelBuilder connection to a blank spreadsheet and perform a sync-out to export the values to the spreadsheet. Examine the syntax in the exported spreadsheet data to determine what you need to do for your actual import. Here are the two Table Types that need to be mapped:

Time Series: this is for the basic attributes associated with the time series entry such as the associated element and units. Basic fields that need to be mapped:

Time Series, Time Series Curve: this contains the actual table of time from start vs. data value, associated with the "time series" record.

Example:

 

 

See Also

New SCADA Element annotation and reporting abilities

Negative values shown for Time in Time Series Field Data