Introduction to DataCurrent
This guide explores DataCurrent and its features
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.
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:
Username: demo@datacurrent.ca
Password: datacurrentdemo
Left-click the Login button to begin using the system.
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 Details, Data Chart, Site Visit Log, Analysis Tools, and Close. See the details below:
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
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:
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
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
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.
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.
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.
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
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: General, Locations, Permissions, and Design Storms
6. Left-click Save
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 Edit, Delete, and Add account users
3. The Copy Permissions options allows the account admin to confer certain functions to select users
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 Add, Edit 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
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 Name, Project Organization, Project Type and Project Code. The Project Type options are the following: I/I, Inspection, 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 Information, Services, Assets, and Users
7. The Action drop-down menu on the left will make the following editing options available: Add Group, Add Layer, Set Custom Map, Add 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
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 Type, Service 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 Type, Service 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
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 Slope, Roughness, 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: General, Sensors, Monitor/Logger, Alarms, Alarm Logs, Activity Log, Attributes, and Documents
10. Each sensor associated with the station can have its information recorded under the Sensors tab. This includes its ID, Name, 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: ADS, Blue Heron Piezo txt, Blue Heron Piezo txt V2, Blue Siren, Campbell SCI CR6,
CivicaFlowMeter, Detectronic, Digi Connect Sensor, FlowWorks,
FtsAxiomPhone, FtsAxiomTCP, GOES Field Test, HACH, HOBO RX300, HOBOUX120, Remote Sense, Red Lion, Sutron, Telog, WaterOfficeScraper,
WonderwareAPI and others
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, Name, Severity, and Alarm Condition must be filled in
5. Severity has 6 levels: Low, Medium, High, Emergency, Critical and Information.
6. Alarm Condition has 11 options: Discrepancy, Fluctuation Over Time, Max Avg Over Time, Max Sum Over Time, Maximum, Min Avg Over Time, Min Sum Over Time, Minimum, New Data, No 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
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 Data, Monitoring Station, and Manual Measurement
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 Type, File Format, Organization, Project, Service, 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 Confirm, Redo, 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
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
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
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
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 Data, Active But No Data, Inactive Station, Archived 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
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 Chart, Sanitary Report, Scatter Report, I/I Event Analysis (Site), I/I Normalization (Site), DRMT, Thematic Mapping, IDF Analysis, Report Template, Data 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
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 Stations, Standard Report Sections, My 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
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
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
The Data Chart page is laid out as follows:
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:
-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.
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:
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:
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:
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 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:
The Sanitary Report provides three outputs:
The following parameters are reported:
The Sanitary Report is run and/or modified using the “Configuration” tab on the right-hand side of the page.
The user can set:
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.
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:
The user may print the IDF chart, or download as .png, .jpeg, .svg vector image, or PDF.
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:
A red asterisk denotes required inputs.
The user can further configure the analysis:
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:
The I/I Event Analysis output may be downloaded by the user as a .csv.
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:
A red asterisk denotes required inputs.
The user is then taken to the “Configuration” tab, where they have the options of:
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:
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.
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:
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:
-Multiple series statistics options include:
Reports can be saved for future reference and use.
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
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:
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:
A table below the graphical DRMT image notes:
This table may be exported as a .xlsx.
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
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:
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.
Copyright (c) 2021 Smart City Water Inc. All rights reserved.
