How can FlowWorks help with Combined Sewage Overflow Monitoring?

There’s a good website I found called about Combined Sewage Overflows, I’m going to shamelessly pull some of the writing from it for this blog entry.

The definition of a combined sewer overflow (CSO), from Water Environment Federation Manual of Practice FD-17: Prevention and Control of Sewer System Overflows is: “A CSO is the intentional or unintentional discharge of untreated sanitary wastewater mixed with stormwater runoff or snow melt and occurs when the carrying capacity of a single conveyance system is exceeded by the instantaneous rate of flow within the single conveyance system. To control where overflows occur, engineers design diversion structures at strategic locations within the single conveyance system that ultimately discharge extraneous commingled flow to receiving waters.”

The US Environmental Protection Agency (EPA) has developed a national framework in the United States for control of CSOs called the ‘Combined Sewer Overflow Control Policy’. The Policy was developed through the National Pollutant Discharge Elimination System (NPDES) permitting program, which requires that all point sources discharging pollutants to surface waters must have a permit. The CSO Control Policy provides information on how to meet the pollution control goals of the Clean Water Act flexibly and cost-effectively. The Policy, published in 1994, contains four fundamental principles to ensure that CSO controls are cost-effective and meet local environmental objectives:

  • Clear levels of control to meet health and environmental objectives
  • Flexibility to consider the site-specific nature of CSOs and find the most cost-effective way to control them
  • Phased implementation of CSO controls to accommodate a community’s financial capability
  • Review and revision of water quality standards during the development of CSO control plans to reflect the site-specific wet weather impacts of CSOs3.

As part of the CSO Control Policy, all communities with combined sewer systems were required to implement ‘nine minimum controls’ by January 1, 1997. These controls are measures that can be implemented to reduce the effect of CSOs without large engineering studies. The ‘nine minimum controls’ are summarized below:

  • Proper operation and regular maintenance programs for the sewer system and the CSOs
  • Maximum use of the collection system for storage
  • Review and modification of pre-treatment requirements to assure CSO impacts are minimized
  • Maximization of flow to the publicly owned treatment works for treatment
  • Prohibition of CSOs during dry weather
  • Control of solid and floatable materials in CSOs
  • Pollution prevention
  • Public notification to ensure that the public receives adequate notification of CSO occurrences and CSO impacts.

So it’s not surprising that one of the biggest uses that we see for FlowWorks is clients who are looking for cost-effective monitoring and reporting of CSO’s. The equipment to do this is now WAY cheaper than it used to be, so much so that it’s now possible to instrument overflow manholes or chambers with battery powered, underground wireless level equipment for about the same price that just the basic programmable logic controller (PLC) would cost in a traditional SCADA system. As a result, putting monitors in every overflow location is now within striking distance of cities that have even modest funding available. We are seeing clients instrument their overflow points with ultrasonic level sensors, pressure transducers, and even good old-fashioned float switches. There are even some amazing load-rated all-in-one monitoring manhole lids available on the market!

Once you have those locations instrumented, watching near-realtime data coming into FlowWorks is where the real fun begins. When all is well, you see all of the locations as green symbols on the FlowWorks map. When levels are nearing critical values the symbols switch to orange, and finally to red as the event begins. At several stages before and during the event, FlowWorks will issue alarm emails and text messages to everyone that needs to know. At anytime during or after the event, the FlowWorks graphing and reporting functions can tell you how long the event was. Plus, if the station is setup correctly you can get an estimate of how much overflow volume has been spilled.

It’s even possible for us to customize the reporting functions to match the exact format and requirements of your regulatory agency. After the events are over, a few mouse clicks is all it takes to produce the CSO overflow duration and volume reports to meet your regulatory obligations.

Using FlowWorks with SCADA

Making an Operator’s Life Simple

SCADA control room

Did you know that you can connect your existing SCADA system to FlowWorks? Why would you want to do this? The first reaction that many people have is “we already have a SCADA system, why would we want to use FlowWorks?” Because FlowWorks is not just for dataloggers, and it does a lot more than just store and plot data. Think of some of the things you could be doing with your SCADA data if you used FlowWorks to do it…

If you are in the municipal business, odds are that you have a SCADA system. You probably also have some dataloggers and maybe some sewer flow meters. Wouldn’t it be nice to put all of that data into one place? Do you want to easily plot flow data from your treatment plant SCADA with rainfall data collected by your dataloggers? How about adding some laboratory measurement results along side? If you use FlowWorks, you can do this.

Plus, if you want, the data flow can go BACKWARDS from FlowWorks to your SCADA! What if you use FlowWorks to collect rainfall from some rain gauge dataloggers, but your SCADA also collects rainfall data? The two can give data to each other, so you and your users see the complete dataset! Core staff who use SCADA see valuable information, using the interface that they are used to. At the same time, data from SCADA (which is often difficult to distribute to users outside of the SCADA system) is made available to a larger set of users. No more having to deal with different data formats because some of your data came from the SCADA, some came datalogger brand X and yet other info came from Brand Y.

Setup Personal Alarms

Use the FlowWorks alarming system to setup notifications for other purposes that aren’t mission critical SCADA alarms…maybe you need to know when flows at a treatment plant reach a certain point so you can take a sample…or it’s time to photograph potential flooding at a drainage location…or maybe you want to know the next time a chlorine analyzer shows a low value so that you can go and take a sample to verify it. These are all things that you can do but might not have SCADA alarms setup for…with FlowWorks you can create your OWN notifications without requiring your SCADA staff to setup these alarms for you.

Your OWN Notifications

Yes, that’s what I said – this is a big deal. In FlowWorks, each user can customize their alarms and notifications, independent of anyone else. This can help you do your job more efficiently, the way you want to do it, and without extra corporate overhead that is so often required.

Custom Reporting

Use the reporting functions to produce tables for your reports…total water consumption, water quality reporting, rainfall summaries and statistics, pump run times, chemical injection summaries…if your SCADA system has been measuring it there is something that FlowWorks can do to make it more useful to you. Why record it if you can’t use it for anything?

SCADA Data Security and FlowWorks

FlowWorks provides data viewing and analysis tools only. There are no control functions that would be in a typical SCADA setup. This means that when you are viewing data sent to FlowWorks from your SCADA system, it is a mirrored COPY of the data rather than the original data itself. In this way the finite control details of your system are protected from the user, leaving your system and network ultimately secure.

Do you have information that you want to distribute to a larger group of users, but due to security concerns over your SCADA system you can’t do it? If your SCADA system is connected to FlowWorks then you get the best of both worlds…your SCADA system stays locked behind your corporate security, but the data that you want to distribute to others is made available. FlowWorks CANNOT be used to alter data or access your SCADA system and controls in any way.

In the meantime, you and other FlowWorks users within your organization enjoy simple, unlimited access to the information you need, from anywhere with an internet connection. Even if the only thing you use your SCADA system for is to graph data, I guarantee you that FlowWorks will do a better job than your SCADA graphing engine.

Stop-Motion Video Of A Construction Project

One of our clients (the District of West Vancouver) has graciously allowed us to post the results of their Eagle Creek Culvert Replacement project.  The District used an wireless video camera to monitor vehicle traffic around a fish-friendly culvert replacement project.  The camera took pictures of the site, day and night, once per-minute for about 3 months.  We took daytime images and processed them into a stop-motion project video.  Take a look….3 months of construction in 3 minutes!

How Can FlowWorks Remote Cameras Create Stop-Motion Video?

It’s easy.  FlowWorks Wireless Cameras send images from a remote installation based on motion sensing and timed intervals.  This allows us to find a balance between image quality and available wireless bandwidth.  When it was time to make a stop-motion movie, routines in the FlowWorks server strips out night-time images and string the daytime ones together into a movie file.

How a FlowWorks Wireless Camera helped The Eagle Creek Culvert Replacement Project

In this case the District wanted the camera to monitor traffic around a very congested section of Marine Drive in West Vancouver.  Automated traffic lights were used to alternate the single lane traffic.  This keepsake project video was produced as a side benefit after the project was done.  The District also has a permanent visual record (some 125,000 images in all) of the construction for future reference.

Off to the Olympics: What’s next for the Wireless Camera Station

The portable camera is now being moved to a traffic congestion area to monitor access to Cypress Mountain during the Olympics.

More Information?

Take a look at our FlowWorks Demo video.  After the video you can fill out our demonstration request form.  Or, you can fill it out directly below.  One of our staff will contact you shortly to set up a live demonstration.

[contact-form 3 "Demo Request"]

New Feature! Clipboard Pasting

Staff from the City of Ottawa suggested we add a simple button to save a copy of the current graph to the Windows clipboard.  Use this icon: at the top of the graphing engine.

After you press the button, you can simply paste a copy of the graph into Word, Excel, email, or any other document that can work with images.  Thanks Ottawa!

Rainfall Statistics

This video shows you how to use the rainfall summary report.

Rainfall Statistics Summary Table Report

Once you have logged in and selected ‘Reporting’ in ‘My Network’, select ‘Rainfall Statistics’ to bring up the ‘Rainfall Statistics’ start up page.

Rainfall statistics tool

Basic Instructions

  1. Site Selection
  2. Date Range Selection
  3. Rainfall Summary Table Interpretation
  4. Data Export
  5. Printing

1. Site Selection

Begin by selecting the site from the drop down list. Only sites the contain rainfall data will show up in the list. For this example we will select the station Surrey Kwantlen Park.

Rainfall statistics site selection

2. Date Range Selection

Then select the year and the month of interest, from the ‘Year:’ and ‘Month:’ window. For this example we will select ‘2009’ and ‘January’. Next click ‘View Rainfall Statistics

Rainfall date range selection

If you’re having problems with the screen showing up, make sure you allow pop-ups for www.flowworks.com.

3. Rainfall Summary Table Interpretation

In the summary able that appears, the top axis shows the hours of a day and the left axis shows days of the month.
Rainfall summary table

Hourly Rainfall

Boxes that contain a point/period indicate no rainfall during that period. Boxes that contain stars/asterisks indicate that there is no data available or that the data has been invalidated.

Daily Rainfall Totals

Totals for the day are shown in the middle column and a summation of the total rainfall is located at the bottom of this column.

Rainfall summary table interpretation

The report will be viewed in metric or imperial, depending on where the station is located

Rainfall Maxima

On the right hand side the rainfall maxima are shown. These represent the maximum given rainfall in a given time period, during the day in question. For example if we look at the 6 hour column on the 6th day, we see a value of 25.8mm. This means that the greatest amount of rain that fell over any given 6-hour period is 25.8mm, and the time immediately to the right represents the time the rainfall event ended.

Rainfall maxima table

Rainfall Event Data

When you see a plus sign next to the time it refers to the time on the following day. For example on the 9th day in the 24-hour rainfall event column, the greatest amount of rainfall was 38.0mm. The rainfall event ended at 21:20 on the 10th. This allows you to look at the entire rainfall event because the system is capable of looking at rainfall over 2 calendar days and is not confused by midnight.

At the bottom of the table the monthly values for each duration are shown. For example in the 24-hour period 54.8mm was the greatest rainfall event that occurred in the given month. This way you can easily see a months worth of data to examine if any storm events match a particular minimum criteria that you have.

Rainfall event interpretation

4. Data Export

You can also copy the values from the table into Microsoft Excel by simply selecting the entire table which is done by clicking on the day cell in the top left hand corner and while holding the mouse button down, drag it to the bottom right corner. The data should now all be highlighted. Copy the data either by going to edit in the toolbar at the top of the screen and choosing copy, or by simply pushing Ctrl + C on your keyboard, while the text is highlighted.

Rainfall data export

Next bring up Microsoft Excel and click inside the spreadsheet and paste paste the data in either by using the toolbar tool ‘edit’, ‘paste’ or press Ctrl + V on your keyboard.

You will see the table as it appeared in FlowWorks. Excel will recognize the numerical values ready for analysis.

Rainfall data import into Excel

5. Printing

If you want to print directly from the internet explorer window just make sure your settings are on landscape so you’re print out comes out clearly. Or you can print off of excel.

Printing rainfall summary table

For other instruction please see the instructional video for Rainfall Summary.