Call Us: (866)-473-0453

Introduction to DataCurrent

This guide explores DataCurrent and its features

INTRODUCTION

DataCurrent has been designed to increase your efficiency and support your decision making by enabling you to access the information you require in seconds instead of in hours or days.

This Quick Start Guide will show you how DataCurrent makes it faster and easier to:
• Collect and view near-real-time data and historical data from:
– rain gauges
– flow monitors
– weather stations
– water quality sensors and
– virtually any environmental monitoring device
• Graphically view the impact which a selected rainfall event has had on the volume, velocity and depth of flow within a specific monitored site (Data Chart)
• Determine the peak intensity of one or more selected rainfall events and compare that value against the peak intensity values of other selected rainfall events meeting a specified range of criteria including date, storm size and duration of inter-event dry periods between rainfall events (IDF Analysis)
• Identify possible sources of clear water entering the sanitary sewer system (inflow & infiltration) by illustrating the difference between the measured actual flow data and the estimated dry weather flow data at a specific monitored site (I/I Event Analysis)

To make it easier for you to start experiencing the benefits of DataCurrent as soon as possible, Civica has already set up a Sample Dataset included with DataCurrent and referenced throughout this Quick Start Guide.

LOGGING IN

To follow along with this guide, a sample dataset has been provided by Civica. This dataset is fictional and is present to demonstrate the functionality of the system. To access this data, please open a web browser, preferably Google Chrome, and navigate to cloud.datacurrent.ca.

You can then log into the system using the credentials below:

Usernamedemo@datacurrent.ca

Passworddatacurrentdemo

Left-click the Login button to begin using the system.

PROJECT HOME SCREEN & NAVIGATION

Once logged in, the user will be directed to the default home page. In the case of the demo user, the image below is the project home page. The data and analysis tools can be accessed from here.

The map can be controlled by the user through left-clicking and dragging the map to the area the user wishes to explore, as well as zooming in and out by using the mouse wheel. The map can also be configured by using the buttons on the top-right corner of the screen to switch map types as well as zooming in and out through the buttons.

The stations can either be accessed by clicking the relevant icon on the map, or by expanding the monitoring station type sections in the table of contents on the left-side of the screen. In the table of contents, the user can view all available stations by using the “+” symbol located next to the checkbox:

1. In the Table of Contents on the left-side of the screen select Monitoring Stations and then Sanitary Flow. Press the “+” button on the left-side of the Sanitary Flow. The different stations will pop-up, indicating if they are active or not. By clicking on the checkboxes beside the stations you have the option of selecting the station(s) you need to be displayed on the screen:

2. You will be taken to the location of the flow Monitoring Station on the map, and a pop-up menu will appear with five icons displayed around the selected station: Station DetailsData ChartSite Visit LogAnalysis Tools, and Close. See the details below:

DATA CHARTS

Viewing the Data & Navigation

1. By clicking on Data Chart from the Monitoring Station pop-up menu, a new tab will open with the most recent month’s captured data for that flow monitoring station

2. To navigate throughout the entire dataset, use the Navigation Pane at the bottom of the page and left-click to drag the data chart view to another time period or use the adjusters on either side of the pane to increase or decrease the time period to view.
See the details in the graphic below:

3. You can also zoom-in on a portion of the data chart by highlighting the section of the data chart you are interested in. By left-clicking and dragging anywhere on the data chart you can selection a portion of the data chart to analyze:

4. If the time range viewed is 48 hours or less, you will be able to see individual data points and highlight them so you can see their exact values:

5. To zoom-out of the current view of the data chart you can move the adjusters on the Navigation Pane at the bottom of the data chart to extend the current time range either forwards or backwards

6. To go back to the previous time range or display setting you were viewing, left-click the Previous View button at the top-left corner of the page

Display Settings

1. To modify the Data Chart display settings, left-click on the Display tab located at the top-right corner of the screen:

a. You can choose which sensors’ data you can display or hide in the Sensor Selection checklist for both Processed Data (the default data displayed) or Raw Data. In this flow monitoring station all four sensors (Rainfall, Depth, Velocity and Flow) are currently displayed and there is no raw data for the sensors

b. Static Data lines can be added or removed from the checkbox to be seen on sensors if specific thresholds are identified, such as a pipe diameter for a depth sensor

c. Manual measurements can be added or removed from the Calibrated Data checkbox to visualize how the measurements taken in the field compare to the sensor data

d. Annotations can be seen by default over the sensors or hidden if the Display Annotations checkbox is unchecked. New annotations can be added by left-clicking the Add Annotation button and left-clicking again on the Data Chart sensor on the time range where you would like the annotation to be seen

e. To select a specific time range, go to the Time Range section, input a date and time to Start and End of the range and left-click the Show Range button. To see all data for all sensors in this flow monitoring station go to Show Entire Range

f. Precipitation and flow sensors can have their time Interval increased and decreased to display different volumes over minutes, hours, days, months, etc. The Flow Interval has been changed in the example below to 1 day and the flow values are calculated into a daily volume (in cubic meters):

2. To close the Display tab simply left-click the right-facing arrow on the top-left side of the tab:

Downloading the Data

1. To download the data available in the Data Chart, left-click the Download tab located at the top-right corner of the screen:

2. Select the format (CSV or InfoNet)

3. Select the data you would like to download

a. To download the data currently viewed in the data chart, left-click Download Selected Data. The data we would be downloading in this case would be the Rainfall, Depth, Velocity and Flow (A/V) sensor data from July 1, 2018 at 00:00 to August 1, 2018 at 00:00

b. To download the raw data currently in the data chart, left-click Download Selected Raw Data. Although we currently cannot see any raw data, the data we would be downloading in this case would be the raw Rainfall, Depth and Velocity sensor data from July 1, 2018 at 00:00 to August 1, 2018 at 00:00. We would not download the Flow (A/V) sensor data if it is calculated by DataCurrent

c. To download all the data in the station range, left-click Download Entire Time Range. At this flow monitoring station, we would be downloading the Rainfall, Depth, Velocity and Flow (A/V) sensor data from April 01, 2018 at 00:00 to August 01, 2018 at 00:00

4. To close the Download tab simply left-click the right-facing arrow on the top-left side of the tab

DATA ANALYSIS & REPORTING

DataCurrent has several analysis and reporting tools that allow the user to review their data and turn it into valuable information. To access these tools, simply follow the Tools navigational item in the Main Menu (Three Lines) or select an Analysis Tools from the station callout menu:

DataCurrent’s powerful set of advanced Analysis Tools includes:
• I/I Event Analysis
• Sanitary Report
• Scatter Report
• IDF (Intensity-Duration-Frequency) Analysis
• DRMT (Distributed Rainfall Modelling Technique)
• Report Generation

Inflow and Infiltration (I/I) Event Analysis

1. By clicking on Analysis Tools from the Monitoring Station pop-up menu and selecting the I/I Event Analysis (Site) option from the drop-down menu, a new tab will open with the analysis tool:

2. The flow monitoring station attributes (i.e. CA – Catchment Area, TC – Time of Concentration) will auto-populate in the tool if the station has the attributes assigned to it in Station Details. You can also select “Enter [attribute]” from the drop-down menu of the attributes to manually enter a value

3. Enter the minimum storm size [mm] if you would like to see storms of a different size than the default minimum of 15 mm

4. Left-click the Load Events button to find the storms during the flow monitoring station’s monitoring period that are greater than the minimum storm size [mm] chosen:

5. Select the event from the Event Date Selection drop-down box and view the results for that event:

6. Use the mouse cursor to hover over the flow graph to see the values for each line plotted: the captured wet flow from the flow monitor (blue line), the estimated dry flow (green line) and the difference between the wet and dry flows (red line)

7. Many statistics and key performance indicators (KPIs) can be found in the table below the graph based on the storm event selected and the flow response captured

Please contact Smart City Water if you require any clarification regarding the calculation or interpretation of the output of the analysis tools.

Sanitary Report

1. By clicking on Analysis Tools from the Monitoring Station pop-up menu and selecting the Sanitary Report option from the drop-down menu, a new tab will open with the analysis tool:

2. The flow monitoring station attributes (i.e. population, catchment area) will auto-populate in the tool if the station has the attributes assigned to it in Station Details. You can also select “Enter [attribute]” from the drop-down menu of the attributes to manually enter a value

3. Enter the time range to be analyzed if you would like to see a time range different than the default of the entire time range. Enter the groundwater infiltration (GWI) estimation methodology you would like the tool to use if you would like to use a different methodology than 85% of average daily minimum dry weather flow (DWF)

4. Left-click the Go button to run the tool:

5. You can now view the results for the time range chosen:

6. The graph at the top of screen displays a summary of the measured precipitation and flow captured during the time period that was analyzed

7. The DWF-Dry Water Flow pattern graph is displayed at the bottom-left of the screen and displays the average DWF for a particular timestamp based on the day of the week it was captured. Left-click to turn on and off the different graph lines: the average DWF for all days (green line), the average DWF for weekdays (blue line) and the average DWF for weekends (orange line).

8. Many statistics and key performance indicators (KPIs) can be found in the table displayed at the bottom-right of the screen based on dry weather flows captured within the time range

Please contact Smart City Water if you require any clarification regarding the calculation or interpretation of the output of the analysis tools.

Scatter Report

1. By clicking on Analysis Tools from the Monitoring Station pop-up menu and selecting the Scatter Report option from the drop-down menu, a new tab will open with the analysis tool:

2. The flow monitoring station attributes (i.e. pipe diameter, pipe roughness coefficient, pipe slope) will auto-populate in the tool if the station has the attributes assigned to it in Station Details. You can also select “Enter [attribute]” from the drop-down menu of the attributes to manually enter a value

3. Enter the time range to be analyzed if you would like to see a time range different than the default of the entire time range

4. To configure the display settings and line configuration of the Scatter Report, left-click the Scatter Plot Curves Configuration button and a pop-up window will appear. Select different tabs to configure the display settings for the plot and a variety of curves:

5. Left-click the Run button to run the tool:

6. You can now view the scatter of the data for the time range chosen:

7. Use the mouse cursor to hover over the scatter on the left-hand side to see the values for manual measurements (red dot) and each line plotted: the Froude curves (green line), the static flow (Iso-Q) lines (yellow line) and the analysis method curves (blue line)

8. Many statistics and key performance indicators (KPIs) can be found in the table displayed at the right-hand of the screen based on depth and velocity sensor values captured within the time range

Please contact Smart City Water if you require any clarification regarding the calculation or interpretation of the output of the analysis tools.

Intensity/Duration/Frequency (IDF) Analysis

1. By clicking on Analysis Tools from the Monitoring Station pop-up menu and selecting the IDF Analysis option from the drop-down menu, a new tab will open with the analysis tool:

2. Enter the design storm name to be used in the analysis to use a design storm set different than the default design storms

3. The flow monitoring station attribute (i.e. time of concentration) will auto-populate in the tool if the station has the attribute assigned to it in Station Details. You can also select “Enter [attribute]” from the drop-down menu of the attributes to manually enter a value

4. Rainfall event(s) can be selected or if the event you are looking for is not in the default list, you can left-click Configure Events to change the event selection settings:

5. You can now view the results for the events chosen:

6. The graph at the top of screen displays the captured peak rainfall intensity of the events over various time intervals. Use the mouse cursor to hover over the graph to see values for each line plotted: the time of concentration (light blue line), the design storms intensity curves (grey lines), the captured peak rainfall intensity curve for the entire monitoring period (red line) and the peak intensity curves for the events chosen (r a i n b o w lines)

7. The Return Frequency table at the middle-left of the screen indicates the return period of each event chosen based on the time of concentration (Tc) of the flow monitoring station and the design storms selected

8. Many statistics and key performance indicators (KPIs) can be found in the summary table displayed at the bottom of the screen based on the captured rainfall events chosen

Please contact Smart City Water if you require any clarification regarding the calculation or interpretation of the output of the analysis tools.

Your feedback is very important for us. Any suggestion or recommendation about DataCurrent will help us in improving the software. Feel free to contact us at info@civi.ca

SETUP

My Organization

As an account holder with DataCurrent, you can develop and customize your account profile. This section will demonstrate how you can customize and save your organization’s information and create a list of organizations associated and/or involved with your account.

1. Left-click the hamburger menu on the top left of the screen

2. Left-click the option Administration. The option My Organization will appear as the menu drops down

3. Left-click My Organization

4. The main Organization page will appear

5. Fill in the fields under the four tabs on the top right of the page: GeneralLocationsPermissions, and Design Storms

6. Left-click Save

Users

The Users feature allows the Datacurrent account admin user to create a directory of those using the Datacurrent account. The admin user will be able to see the current account users and add new users to the account.

1. Left-click Users under the Administration tab in the hamburger menu on the top left of the page

2. When the Users page appears, you have the option to EditDelete, and Add account users

3. The Copy Permissions options allows the account admin to confer certain functions to select users

Roles

The Roles feature allows account administrators to Add and Edit roles the users can have on the Datacurrent account

1. Left-click Roles under the Administration tab in the hamburger menu on the top left of the page

2. The options to AddEdit and Delete under the Role List page appear

3. The option to Add a role opens a page with numerous categories of roles users can be assigned. The admin user can select combinations of roles and permissions to customize another user’s access to the Datacurrent account


Adding a Project

1. Using the hamburger menu on the top left, left-click Projects

2. Once the Project List page appears, left-click the green Add button on the right side of the page

3. A Project Details window will appear with the following mandatory fields to fill in: Project NameProject OrganizationProject Type and Project Code. The Project Type options are the following: I/IInspection, and Monitoring

4. Left-click the Save Project button

5. A profile page will appear displaying the Project Details. This page allows for the project to be further edited before being saved

6. The tabs on the top right allow for additions and editions to the Project InformationServicesAssets, and Users

7. The Action drop-down menu on the left will make the following editing options available: Add GroupAdd LayerSet Custom MapAdd Boundary, and Import Boundary

8. Once the project has been edited to fit your preferences, left-click the dark blue Save button to save your changes

9. Left-click the light blue Return button to the left of Save to view the project main page

Adding a Service

1. The navigational pane on the left of a project page will have an Active Services title. The selected Project Type during the project creation phase reveals itself underneath the Active Services label

2. A project may have numerous services and two ways to add a service. Both ways will be shown below

Adding a Service Method 1:

3. To add a service to a project, left-click the Edit Project option under the Actions tab.

4. Once within the edit page, left-click the Services tab on the right

5. In the example below, three different test services are on display to illustrate how the project services are listed

6. Left-click the green Add button

7. The Add Service mini window will appear with the three mandatory fields to fill in: Service TypeService Name, and Service Code

8. Once filled in, left-click Add

9. The following page will appear with the options under the Actions tab to Edit Service or Add New Defect

10. Right-click on a location on the map to add a New Point of Interest (this is also considered the same as adding a new defect)

Adding a Service Method 2:

11. Alternatively, left-click the Add Service option under the Actions tab

12. The Add Service window will appear with the three mandatory fields to fill in: Service TypeService Name, and Service Code

13. As previously stated, once the Add button is selected, the Service’s main page will appear and the option to edit the service will be available

14. Upon completing the desired edits, left-click the Save button

Adding a Station

1. Select a project from the list on the left of the page

2. Once the project is selected, select the service being provided on the project from the list of Active Services on the left-sided menu. Below, the Active Service is a Monitoring service given the name “Sanitary Sewer Flow Monitoring”

3. This will reveal a map ready to be populated with monitoring stations. See below:

4. Once the service is selected, right-click on the map at the exact location of the desired station to begin the station set up process.

5. The tab labelled Add Station will appear. Left-click this tab

6. A Station Detail window will appear with the fields to populate

7. Fill in at minimum the three mandatory fields: 1) Station Name, 2) Station Type, and 3) Station State. Other fields like the SlopeRoughness, and Diameter can also be filled out here.

8. Once the station is saved, the user will be brought to a new window offering a more comprehensive resource to further record station details.

9. The following tabs allow for extensive information/features to be saved for each individual station: GeneralSensorsMonitor/LoggerAlarmsAlarm LogsActivity LogAttributes, and Documents

10. Each sensor associated with the station can have its information recorded under the Sensors tab. This includes its IDName, and Type among others

11. Each logger associated with the station can have its information recorded under the Monitor/Logger tab. This includes the Logger Type. Here are some of the logger types compatible with Datacurrent: ADSBlue Heron Piezo txtBlue Heron Piezo txt V2Blue SirenCampbell SCI CR6

CivicaFlowMeterDetectronicDigi Connect SensorFlowWorks

FtsAxiomPhoneFtsAxiomTCPGOES Field TestHACHHOBO RX300HOBOUX120Remote SenseRed LionSutronTelogWaterOfficeScraper

WonderwareAPI and others

Alarm Setup

1. Left-click the Alarms tab from the top Navigational Pane

2. Left-click the Add button on the right side

3. The Station Alarm Detail tab will appear, providing the means to set the parameters of the type of alarm desired

4. At minimum, the three fields, NameSeverity, and Alarm Condition must be filled in

5. Severity has 6 levels: LowMediumHighEmergencyCritical and Information.

6. Alarm Condition has 11 options: DiscrepancyFluctuation Over TimeMax Avg Over TimeMax Sum Over TimeMaximumMin Avg Over TimeMin Sum Over TimeMinimumNew DataNo Data, and Out of Range

7. Once the alarm parameters are in place for individual alarm types, settings to manage alarm reception follow

8. Add email addresses and phone numbers to the desired alarms

9. Once the desired settings are in place, left-click Update

DATACURRENT MANAGEMENT

Data Management

This section allows the account user to manage the data collected from monitoring sites.

1. Left-click the hamburger menu on the top let of the page and left-click the Data Management option.

2. Three sub-options will appear: Monitoring DataMonitoring Station, and Manual Measurement

Data Management - Monitoring Data

Selecting this feature takes you to a page with multiple functions. This feature is the hub for managing incoming data and keeping records of station loggers. If a station’s telemetered data does not automatically upload, the option to manually upload data is made available with this function.

1. Four tab options appear on the top right of the main page: 1) New Task, 2) Import Task List, 3) Export Task List, 4) Monitoring Station Logger

2. The Monitoring Data Upload page below allows for data files to be uploaded

3. Fill in the fields: Task TypeFile FormatOrganizationProjectService, and Station

4. If the Task Type selected is Upload or Delete, the option to upload the files from your device will appear

5. Select a File to upload and Submit the task

6. The Import Task List shows each task submitted from the previous New Task page

7. The options to ConfirmRedo, and Undo allow for edits to the list

8. The Export Task List shows each New Task submitted as an Export

9. The Monitoring Station Logger page provides a record of the stations receiving uploaded data

Data Management - Monitoring Station

This feature allows the Datacurrent account user to add monitoring stations to projects by uploading a CSV file.

1. Select your organization’s name, appropriate project and service name from the drop-down menus

2. Left-click the Choose file option and select the desired CSV file

3. Left-click Upload. The files will appear below

4. Left-click Next Step

5. Step 2 will appear offering the opportunity to Upload Monitoring Sensors also via a CSV file

6. If there are no monitoring sensors to upload, left-click Next Step

7. Step 3: Setup Logger will appear as an optional final step

8. Select the Logger Type from the dropdown menu then left-click Finish to complete the upload process

Manual Measurement

This feature allows the Datacurrent account user to upload manual measurements taken in the field such as calibration data via a CSV file.

1. Select your organization’s name, appropriate project and service name from the drop-down menus

2. Choose a file and left-click Upload

3. Left-click Finish to complete the upload

Usage Tracking

This feature allows Datacurrent admin staff to track the account’s usage of both stations and tools

1. Two sub-options will appear: Stations and Tools

Usage Tracking - Stations

Using graphs and charts, this feature uses visuals to depict the various statuses of stations.

1. The Overall tab on the top right depicts the station conditions (Active And Has DataActive But No DataInactive StationArchived Station) within a selected time range

2. Under the Organization tab on the top right, the Datacurrent super admin can select one or all the organizations associated with the account and track station status

3. The total number of stations per organization can be tracked and compared. See below

4. Bar graphs and pie charts visually depict the Station Tracking Summary chart. See below

5. Under the Project tab on the top right, the Datacurrent super admin can select one or all the organizations associated with the account and track station status within the selected project

6. Like the Organization tab, the Project tab displays a visual record of station statuses within an organization’s individual projects

Usage Tracking - Tools

This feature allows the Datacurrent Super Admin user to use tool combinations to analyze individual or combined Organizations and Projects

1. Select the Organization(s) and/or Project(s) to be analyzed from the drop-down menus

2. Select the desired Time Range

3. Select the three preferred tools of analysis. The following tools are available: Data ChartSanitary ReportScatter ReportI/I Event Analysis (Site)I/I Normalization (Site)DRMTThematic MappingIDF AnalysisReport TemplateData Comparison

4. After setting the desired conditions, left-click Run Analysis

5. The three tools selected will appear in graph and chart form. An excel-based Tools Usage Summary will populate the bottom of the page

REPORTING

Define Report Templates

This feature allows the Datacurrent account user to produce reports

1. Left-click the Reports options under the hamburger menu on the top left of the page

2. Left-click Define Report Templates

3. The Report Template page will appear. Select the desired project

4. Fill in the four fields: Select StationsStandard Report SectionsMy Report, and Configuration

5. Once the template information has be filled in, include the email address you wish it sent to and left-click Save Template

6. The window below will appear. Fill in the two fields Report Template Name and Report Template Description then left-click Save Changes

7. Left-click Email This Template to complete the report-making process

View / Edit Report Templates

This feature allows the Datacurrent account user to view and edit reports made by the Define Report Templates function.

1. Left-click the Reports options under the hamburger menu on the top left of the page

2. Left-click View / Edit Report Templates

3. The Report Configuration page will appear. Select the project from which the report is to be viewed / edited

4. Selecting the Add/Edit option from the Report Templates box will send the user to the Define Report Templates page for editing

5. Selecting the Add/Edit option from the Schedules box will open the window below:

6. This schedule feature allows for the regular submission of a report template

7. Select Add/Edit under Email Lists to input the email addresses that will be receiving these reports

8. As Report Templates are created and saved, they will be recorded and shown at the bottom of this page in between the brackets below

9. Left-click the tab to the right of View / Edit Report Templates labeled Report Generation Progress

10. This page shows a list of the reports created

11. Select a Report ID number to get a closer look at the Monitoring Progress. Below is a status report of the content for Report ID 1273

12. The Report Generation feature automatically draws from the indicated sources within Datacurrent selected in the Define Report Templates page. Combining stations and desired report section

13. This page summarizes the status of the report and allows the users to Download the finished report

ANALYSIS TOOLS

Data Chart

The Data Chart is the foundational tool of the analysis suite and is used to view, edit, and statistically analyze the collected monitoring data.

From the Monitoring Station pop-up menu, select the second icon from the top (Data Chart). A new browser tab will open with four (4) weeks of the most recent data displayed.

This page has five tabs:

  1. Chart: view the data
  2. Statistics: statistical analysis of the data
  3. Display: configure the data display settings
  4. Download: download the data
  5. Admin: edit the data

1. Chart

The Data Chart page is laid out as follows:

  • -The monitoring site name heads up the Data Chart, and is clickable to access Site Details.
  • -Beneath the header is the date range of the data being currently viewed.
  • -Each sensor channel (typically starting with rainfall) is displayed as measurement over time. Weekends are grey, while weekdays are white.
  • -The Navigation Pane at the bottom shows the entire range of data collected for that site as well as the extent of the data currently being viewed; you can manipulate this Pane by clicking on the “Current Display” segment and moving it forwards or backwards, or you can increase or decrease the extent of data viewed by clicking on the “Current Display” segment expanders and pulling.
  • -Likewise, clicking and dragging on any point of the Data Chart display will “zoom in” to that extent.

Zooming to within forty-eight (48) hours will display each data point, which you can hover over to see the exact metrics of each point.

2. Display

The Display Tab configures the presentation of the data. The “Sensor Selection” lists the different sensor channels (edited/calculated) to display. The “Raw Data” notes the raw sensor channels; in some cases, the raw and edited data sets are nearly or entirely identical.

Side Note: The user can define horizontal static lines (useful for defining pipe diameters, flow thresholds, etc.) by navigating to Station, selecting “Sensors” tab, choosing the sensor to which you will add the static line, clicking the sensor name, and navigating to the “Static Data” tab.

In-field calibration measurements (as entered into the site’s Activity Log) may be displayed on the Data Chart by selecting the check box under “Calibrated Data”.

Annotations can be added to the Data Chart. Depending on where you click, the annotation is tied to a specific sensor, time, and Y-axis value (which denotes where the text will appear on the chart).

Finally, the user can manipulate the time range of the data (user-defined or the entire range), the inter-event dry period between rainfall, and the resolution of the precipitation and flow time-steps.

3. Statistics

The Sensor Statistics tab takes you to a different view of the data. Average, minimum, maximum, and median values for the measured data are shown in tabular and chart form. The user selects the sensor to be analysed at the top right corner of the screen, and at the top left corner of the screen has the option of four quick views: the most recent full week, the most recent full month, the current month to date, and year to date. The user can also customize the time range, as well as the “time-step” of the statistics (daily, weekly, monthly, quarterly, or annually).

The user can export this statistical data as a .xlsx file.

4. Download

The user has the options of downloading either 1) selected monitoring data, 2) selected raw data, 3) or entire time range of data in.csv or InfoNet file formats.

5. Admin

The Admin tab allows the user to add alarms, and toggles the Data Editor.

The Data Editor allows you to:

  • -Manually enter data points
  • -Interpolate between points
  • -Copy in data from historical records

-You can manually edit by directly manipulating and/or modifying the numerical data points of each sensor; note that only existing data points on the chart can be edited.

Linear interpolation fills in data gaps (less than five consecutive data points) within a maximum one month time range. The user first selects the sensor, then selects the data gap by date (the number and dates of the data gaps listed in the drop-down menu will vary according to the extent of the data in view on the chart). The user then selects the starting point and the endpoint of the linear interpolation. The program then extrapolates the missing data between the two points.

Larger data gaps can be filled using historic information. The tool copies data within a one month time range. The user again selects the sensor to be edited, selects the gap to be filled, and finally selects the starting point of the historic data to be copied.

Remember to save the edits using the Data Editor.

Scatter Report

The Scatter Report graphically displays the correlation between two (2) variables (sensor input) using Cartesian coordinates. Typically, depth and velocity readings are compared. Scattergraphs can give valuable insights into the condition and performance of both the pipe and the sensors.

From the Monitoring Station pop-up menu, select the bottom icon (Analysis Tools) and Scatter Report from the drop-down menu. Alternatively, you can select Scatter Report under Tools in the hamburger menu, in which case you would have to define the Organization, Project, Service, and Monitoring Station in addition to the configurations noted below.

In order to generate a scatter report, the report parameters must be specified in the “Configuration” tab (required fields are marked with a red asterisk). Pipe diameter, roughness coefficient, and pipe slope default to those entered under “Attributes” in Station Details; if these have not yet been defined, or if alternate values are being used, the drop-down menus allow for user inputs. The user also defines the time range or entire range to be used to generate the scatterplot. Note: the user has the option to exclude specific dates or date ranges.

Under “Scatter Plot Curves Configuration,” the user may further detail:

  1. General Scattergraph;
  2. Analysis Method;
  3. Froude Number; and
  4. Iso-Q Lines.

These configuration options are explained below.

1. Scatter Graph

The user may assign data from a specific sensor to the X and Y axes of the scattergraph. Typically, these are depth (Y axis) and velocity (X axis). Manual measurements used to calibrate either sensor, if available, may also be displayed on the scattergraph.

The user may also achieve insights through applying a color-ramp to the data points. “Simple” is the default value and displays a single color for all data points. “Two Color” takes the time extent of the data being analyzed, and divides into two (2) timeframes. The “Rainbow” option adds further resolution to the timeseries of data.

2. Analysis Method

The Manning Equation is the central feature of the scattergraph, describing the relationship between depth and velocity under ideal conditions. The Manning Equation generates a pipe curve against which monitoring data can be compared and assessed. The scatter plot configuration allows for three (3) different analysis methods applying the Manning Equation:

  1. Design Method (DM): this standard application, the design pipe curve of the sewer, relates depth and velocity using a specified roughness coefficient and pipe slope as detailed by the sewer system designer.
  2. Lanfear-Coll (LC): this method fits the Manning Equation to monitored data without direct reference to pipe slope or roughness coefficient. The resultant pipe curve is compared to actual data (under uniform flow conditions) and used to estimate the full-pipe capacity of the sewer.
  3. Stevens-Schutzbach (SS): this is an iterative regression technique that fits the Manning Equation to flow monitoring data, with special application for non-uniform flow conditions caused by downstream obstructions. The Stevens-Schutzbach pipe curve is not constrained to the origin (0,0), unlike the Design and Lanfear-Coll methods (thereby accounting for the dimensions of the obstruction).
  4.  

Note: if the monitoring data does not line up to any of the three methods’ pipe curves, the user is alerted that either (1) the sewer was not experiencing uniform flow conditions during that period, or (2) the monitoring sensors are not making valid depth or velocity measurement (e.g., sensor drift).

3. Froude Number

The Froude number (Fr) denotes the flow conditions within the sewer:

  1. Fr < 0.7: flow conditions are subcritical (generally slow, tranquil flow)
  2. Fr 0.7 < 1: flow conditions are transitional (potentially unstable) and subcritical
  3. Fr = 1: flow conditions are critical
  4. Fr 1 < 1.5: flow conditions are transitional (potentially unstable) and supercritical (generally rapid, fast flow)
  5. Fr 1.2 < 1.7: development of undular hydraulic jumps (waves) without breaking
  6. Fr > 1.5: flow conditions are supercritical
  7. Fr 1.7 < 2.4: undular hydraulic jump breaking
  8. Fr > 2.6: diminishment of undular hydraulic jumps

Note: generally, monitoring is avoided at locations with hydraulic jumps and waves.

4. Iso-Q Lines

Iso-Q lines are depth-velocity points resulting in a constant flow rate, interpreted similarly to elevation contour lines on a topographic map. These are typically used to denote percentages of full-pipe capacity at actual flow rates, and are useful for visualizing the capacity. DataCurrent defaults with Iso-Q lines at 25%, 50%, and 75% capacity; further Iso-Q lines can be defined and added by the user.

The Scatter Report displays the scatterplot within a graphical display of the sewer dimensions, including the pipe curves of all three methods, Froude number curves, and Iso-Q lines.

The Scatter Report further notes key measurements in tabular format:

  • -the hydraulic coefficients of each of the three (3) methods of applying the Manning Equation
  • -the nominal pipe capacities as calculated using each method
  • -the maximum velocity as calculated using each method
  • -the correlation coefficient representing the proportion of variance between the method’s pipe curve and actual measured data
  • -for the Stevens-Schutzbach method, the depth of the downstream obstruction, if applicable

Sanitary Report

The Sanitary Report calculates key dry weather sanitary flow metrics for a specified monitoring period.

From the Monitoring Station pop-up menu, select the bottom icon (Analysis Tools) and Sanitary Report from the drop-down menu. Alternatively, you can select Sanitary Report under Tools in the hamburger menu, in which case you would have to define the Organization, Project, Service, and Monitoring Station in addition to the configurations noted below.

The Sanitary Report takes as inputs:

  • -Flow sensor and rain gauge data associated with a single monitoring site
  • -The total contributing population upstream of the monitoring station (defined in Station Details under the “Attributes” tab)
  • -The total area of the contributing catchment (defined in Station Details under the “Attributes” tab)
  •  

The Sanitary Report provides three outputs:

  • A data chart of the flow and rainfall data over the specified time period
  • The patterns of all dry weather data over a twenty-four (24) hour period (showing horizontal indicators for calculated average dry weather flow and groundwater infiltration, and flow patterns for weekdays, weekends, and all days)
  • Dry weather flow parameters for the monitoring station

The following parameters are reported:

  • -Average dry weather flow (DWF), measured rate and per capita
  • -Average sewage flow (DWF less groundwater infiltration)
  • -Average daily minimum DWF
  • -Average daily peak DWF
  • -Groundwater infiltration (GWI) (calculated as specified in the “Configuration” tab)
  • -% GWI in average DWF
  • -Measured peaking factor (compares the average daily peak DWF to the average DWF)
  • -Harmon peaking factor (an empirical formula used to determine maximum hourly design flow rate, taking population as an input)

The Sanitary Report is run and/or modified using the “Configuration” tab on the right-hand side of the page.

The user can set:

  • -Flow Sensor and Rain Gauge (defaulted to originating station if accessed through the Monitoring Station pop-up menu)
  • -Population and catchment area (defaulted to the selected station attributes, but customizable by selecting “Enter …” from the drop-down menu)
  • -Time range, either customizable or whole extent of monitoring period
  • -Groundwater infiltration (GWI) calculation parameters, either as a percentage of minimum DWF or as a static area-weighted infiltration rate
  •  

The red asterisk denotes required fields.

The display options for the Dry Weather Flow Pattern can be modified using the “Options” button (all patterns are defaulted on).

The Dry Weather Flow Pattern and Dry Weather Flow Parameters can be exported as .csv.

IDF Analysis

The IDF Analysis tool charts the relationship between rainfall intensity, rainfall duration, and storm return period (frequency) for a specified wet weather event.

From the Monitoring Station pop-up menu, select the bottom icon (Analysis Tools) and IDF Analysis from the drop-down menu. Alternatively, you can select IDF Analysis under Tools in the hamburger menu, in which case you would have to define the Organization, Project, Service, and Monitoring Station in addition to the configurations noted below.

Under “General” in the “Configuration” tab, the user determines the design storm to be used and confirms the station’s Time of Concentration. The user can also check whether to display the IDF curve using a logarithmic or linear scale on the X Axis.

Under “Curves” in the “Configuration” tab, the user can “Configure Events,” choosing minimum storm size (default 15mm volume), inter-event dry period (default 12 hours), and time extent / entire time range.

The user may then select a specific wet weather event(s) in the “Events” tab under “Curves.” Under the “Design Storm” tab, the user may select 2, 5, 10, 25, 50, and/or 100-year storm events. Finally, under the “Time Range” tab, the user may use total precipitation over a time range (the user must check the box “Time Range Event” for the time range to be displayed on the chart).

On the IDF Analysis chart, the user may hover over the event and design storm lines, displaying the time step and intensity.

Below the graphical chart, information regarding the event and design storms is displayed in tabular format:

  • -Event
  • -Duration
  • -Total Precipitation
  • -Peak Rainfall Intensity over 5, 10, 15, 20, 30 minutes and 1, 2, 3, 4, 6, 12, and 24 hours

The user may print the IDF chart, or download as .png, .jpeg, .svg vector image, or PDF.

I/I Event Analysis (Site)

The I/I Event Analysis tool calculates inflow and infiltration for a specified wet weather event.

From the Monitoring Station pop-up menu, select the bottom icon (Analysis Tools) and I/I Event Analysis from the drop-down menu. Alternatively, you can select I/I Event Analysis under Tools in the hamburger menu, in which case you would have to define the Organization, Project, Service, and Monitoring Station in addition to the configurations noted below.

The user must first confirm the key inputs for the site and apply a filter for the wet weather event in the “Configuration” tab:

  • -The total area of the contributing catchment (defined in Station Details under the “Attributes” tab)
  • -The Time of Concentration of the catchment (the time needed for water to flow from the most remote point in the catchment to the outlet), in minutes (defined in Station Details under the “Attributes” tab)
  • -The minimum wet weather event volume threshold, to filter out smaller/insignificant storms (the tool defaults to 15mm but can be modified); once selected, the user must “Load Events” in order to use the “Event Date Selection” to select a single wet weather event to analyze.
  •  

A red asterisk denotes required inputs.

The user can further configure the analysis:

  • -Display Options: display estimated dry weather flow and measured flow, or both (the tool defaults to show both)
  • -Time Range: once a wet weather event has been selected, the tool automatically defines a time range, but this can be edited by the user
  • -Inter-Event Dry Period: defaulted to 12 hours, this can be modified by the user to better define the start/end of storm events
  • -Precipitation Display Timestep: defaulted to the Time of Concentration, the user can view the precipitation data in 5, 10, 30, 60, 90, and 120 minute timesteps

The graphical display plots precipitation, estimated dry weather flow, measured flow, and calculated inflow and infiltration. The chart is interactive: hovering over any point on the X Axis of the chart (time) gives the user the exact values for estimated DWF, measured flow, and I/I. Similarly, hovering over the precipitation shows the volume of rainfall for the given timestep.

Below the chart, a table details important I/I metrics:

  • Catchment Area
  • -Time of Concentration (Tc)
  • -Total Precipitation (for the event)
  • -Duration of the Storm
  • -Peak Precipitation Intensity over Tc
  • -Return Period over Tc
  • -Time of Peak Measured Flow
  • -Peak Measured Flow
  • -Peak Measured Depth
  • -Total Measured Flow Volume during Event
  • -Time of Peak I/I Flow
  • -Peak I/I Rate
  • -Estimated Dry Weather Flow at Time of Peak I/I Flow
  • -Peak I/I Flow
  • -Total I/I Flow Volume during Event
  • -Volumetric Coefficient (Cv%) (the percentage of the volume of rainfall that became I/I in the sewers)
  • -Peak I/I Coefficient
  • -Hourly Wet Weather Peaking Factor (the ratio of peak hourly wet weather flow to average daily dry weather flow)
  • -Instantaneous Wet Weather Peaking Factor (the ratio of peak wet weather flow to average daily dry weather flow)

The I/I Event Analysis output may be downloaded by the user as a .csv.

I/I Normalization (Site)

The I/I Normalization tool uses regression analysis to predict the inflow and infiltration for a specified site under storms of various return periods (e.g., a 1:10 or 1:25 year return period storm). Typically, proper usage of this tool requires at least five (5) measured rainfall events above a defined threshold volume.

From the Monitoring Station pop-up menu, select the bottom icon (Analysis Tools) and I/I Normalization from the drop-down menu. Alternatively, you can select I/I Normalization under Tools in the hamburger menu, in which case you would have to define the Organization, Project, Service, and Monitoring Station in addition to the configurations noted below.

Upon opening the tool, the user is prompted by a “Select Sensor Information” pop-up; this sets up the sensor used for normalization. This setup includes:

  • -Flow Sensor
  • -Rain Gauge
  • -Catchment Area (total area of contributing catchment, defined in Station Details under the “Attributes” tab)
  • -The Time of Concentration of the catchment (the time needed for water to flow from the most remote point in the catchment to the outlet), in minutes (defined in Station Details under the “Attributes” tab)
  • -Pipe diameter of the sewer at the monitoring site (defined in Station Details under the “Attributes” tab)
  • -Total pipe length (the sum of the lengths of all connected sewer pipes within the catchment), if known (required if you want to see the rainfall-derived inflow and infiltration per pipe footprint in the output)
  • -Options to define start and end dates for the normalization analysis, or to use the entire range of monitored data
  • -Defining the minimum storm volume used to run the regression analysis (defaulted to 15mm volume events and higher)

A red asterisk denotes required inputs.

The user is then taken to the “Configuration” tab, where they have the options of:

  • -Adding further sensors to the regression (these are differentiated for comparison purposes)
  • -Defining the X Axis of the normalization graph (peak rainfall intensity or total rainfall volume)
  • -Defining the Y Axis of the normalization graph (peak I/I flow, peak I/I rate, I/I volume, or volumetric coefficient)
  • -Selecting the design storm to be used as a benchmark, with choices to display 1:2 year, 1:5 year, 1:10 year, 1:25 year, 1:50 year, and 1:100 year storm thresholds (in terms of peak rainfall intensity or total rainfall volume) on the graph
  • -The user can determine whether the line of best fit for the regression analysis is constrained to the origin, intercepting (0,0)

The resulting I/I Normalization regression graph is interactive: the user can hover over any of the points (representing the wet weather events included in the analysis) and view the event’s date and the two variables defined by the user for both axes of the graph.

Below the graph is a summary of the site ID, the sensor utilized, the regression equation, and the correlation coefficient (values less than 0.4 generally indicating poor curve fit, and values greater than 0.7 generally representing acceptable correlation).

Finally, each of the wet weather events included in the analysis is presented in tabular form, along with key metrics:

  • -Event Date
  • -Total Precipitation
  • -Peak Rainfall Intensity
  • -Peak Precipitation Intensity over Time of Concentration
  • -Peak I/I Flow
  • -Peak I/I Rate
  • -Total I/I Flow Volume during Event
  • -Volumetric Coefficient (the percentage of the volume of rainfall that became I/I in the sewers)
  • -Instantaneous Wet-Weather Peaking Factor (the ratio of peak wet weather flow to average daily dry weather flow)
  • -I/I per Pipe Area

The user can apply a thematic color ramping based on defined thresholds to the table’s columns. Based on a green, yellow, orange, and red color ramp, the user can set a “theme” based on ascending threshold for a specific parameter.

The graphical output can be exported as a PDF, .jpeg, or .png. The table can be exported as a .csv.

Data Comparison

The Data Comparison tool is accessible under Tools in the hamburger menu. As this tool uses multiple monitoring sites, it is not accessible through a site’s Monitoring Station pop-up menu.

The user may either (1) create a new report or (2) load a previously saved report from a drop-down menu.

New Report

First, at least two (2) sensors must be added, detailing:

  • -Organization
  • -Project
  • -Service
  • -Monitoring station
  • -Sensor
  • -Color of the sensor in the Data Comparison
  • -Numbering of each sensor in the chart
  • -Select whether to invert the axis

The user may then add a calculation (summing, subtracting, or shifting the data) as another data chart to compare with the sensor data.

Under “Advanced Options,” the user may add statistical analysis beneath the visualized data.

Single series statistics options include:

  • -Absolute Maximum
  • -Absolute Minimum
  • -Average
  • -Average Daily Maximum
  • -Average Daily Minimum
  • -Total
  • -Average Daily Total
  • -Standard Deviation
  • -Point Count

-Multiple series statistics options include:

  • -Average 24-hr Peak Lag
  • -Average 24-hr Trough Lag
  • -Difference in Max
  • -Difference in Min
  • -Difference in Average
  • -Difference in Total
  • -Difference in Average Daily Total
  • -Difference in Average Daily Max
  • -Difference in Average Daily Min

Reports can be saved for future reference and use.

DRMT

The Distributed Rainfall Modeling Technique (DRMT) tool is accessible under Tools in the hamburger menu. As this tool uses multiple rain gauge sites by design, it is not accessible through a site’s Monitoring Station pop-up menu.

In the “Configuration” tab, the user may specify the following:

  1. Service Selection
  2. DRMT Configuration Setting (takes the user to the Edit Service page of the project’s monitoring Service)
  3. Raster Option
  4. Generate Styling
  5. Event Selection

1. Service Selection

The user must first define the Organization and Project (if applicable) for the DRMT analysis.

2. DRMT Configuration Setting

Clicking this button opens a new tab for the user (opening to the Edit Service page of the Project’s monitoring Service), wherein the general configuration settings for DRMT and Thematic Mapping may be defined:

  • -DRMT Boundary: Project Boundary or Fit to Rain Gauges
  • -Analysis Type: either by Total Volume or Peak Intensity over a timestep (from 5 minutes to 24 hours)
  • -Minimum Storm Size Filter
  • -Styling options for raster and contours (with natural breaks / manual, and number of breaks)

3. Raster Option

The user may modify the analysis type either on the DRMT tool page (“Configuration” tab) or in “DRMT Configuration Setting” (Edit Service page) as noted above.

4. Generate Styling

The user may modify the raster styling or the contour styling either on the DRMT tool page (“Configuration” tab) or in “DRMT Configuration Setting” (Edit Service page) as noted above.

5. Event Selection

The user may sort the wet weather events to be analyzed by either date or volume. The drop-down menu notes the storm date and the lowest, highest, and average rain gauge measurements.

The legend for the DRMT raster can be found in the left-hand side tab.

After generating the DRMT raster, the user can further customize the chart using the “Configuration” tab:

  • -Show Contours (default on)
  • -Show Flow Meters (default on)
  • -Show FM Labels
  • -Show Contour Labels (default on)
  • -Show FM Boundaries (requires flow monitoring boundaries to be set)
  • -Candle Stick Map (see Figure below)

A table below the graphical DRMT image notes:

  • -Every rain gauge used in the DRMT analysis
  • -Total Volume measured at each rain gauge
  • -Peak Intensity over Minute Timestep (5, 10, 15, 20, 30 minutes and 1, 2, 3, 4, 6, 12, or 24 hours)

This table may be exported as a .xlsx.

Thematic Mapping

The Thematic Mapping tool is accessible under Tools in the hamburger menu. As this tool uses multiple sites, it is not accessible through a site’s Monitoring Station pop-up menu.

In the “Configuration” tab, the user may specify the following:

  1. Service Selection
  2. Thematic Map Configuration Setting
  3. KPI Type Selection
  4. Event Selection
  5. Display Selection

1. Service Selection

The user must first define the Organization, Project, and Service for the Thematic Map.

2. Thematic Map Configuration Setting

Clicking this button opens a new tab for the user (opening to the Edit Service page of the Project’s monitoring Service), wherein the general configuration settings for DRMT and Thematic Mapping may be defined.

A number of Key Performance Indicators (KPIs) have been predefined:

  • -Volumetric Coefficient (the ratio of total I/I volume to total rainfall volume)
  • -Total Precipitation
  • -Peak Precipitation Intensity over Time of Concentration (Tc)
  • -Peak I/I Rate
  • -Peak I/I Coefficient
  • -Instantaneous Wet Weather Peaking Factor (the ratio of instantaneous peak wet weather flow to peak dry weather flow)
  • -Hourly Wet Weather Peaking Factor
  • -Peak Rainfall Intensity
  • -I/I per Pipe Area
  • -Average Dry Weather Generation Rate
  • -Normalized Groundwater Infiltration Rate
  • -Cumulative Precipitation
  • -Projected 2, 5, 10, 25, 50, or 100 Year I/I Rate
  •  

Each of these KPIs is either event based or time ranged, and has a user-defined color-coding theme (click on the KPI to edit the color theme).

3. KPI Type Selection

Back to the Thematic Map “Configuration” tab, the user selects either event based or time based KPIs.

4. Event Selection

The user selects the wet weather event to be analyzed.

5. Display Selection

The user determines whether to display (1) station labels and (2) KPI on the map.

Once the Thematic Map has been generated, the user can view one KPI at a time on the map, by clicking on the various KPI column headers (clicking on the row takes the user to a specific station). The legend, including KPI thresholds, is found in the lower left hand corner.

×

Table of Contents