New FlowWorks Tool – Rainfall Mass Balance

FlowWorks is pleased to announce the arrival of our newest rainfall analysis tool.  This one is aimed at easing the task of performing quality control checks when you have multiple rain gauges.  It can be used to validate rainfall from both historical and current events, and like all FlowWorks tools it’s quick and easy to use.  Check it out…

Tipping bucket rainfall gauges are prone to various sources of failure, including plugged funnels, seized bearings, sudden changes in instrument level, and even well-meaning staff who perform maintenance inspections without reporting when these were done.  The result sometimes sticks out like a sore thumb, say months of missing data or sudden, inexplicably high “events”.  But often, these problems are not clearly visible and can be missed.  This is where our Rainfall Mass Balance (RMB) tool comes in.

Say you have two rain gauges in your network.  If you want to check how one of them is doing, a good way to do this is to check it against the other.  Although they probably won’t show the same values for a given period, it’s a good bet they will be reasonably well correlated if the gauges are close together.  You could use our rainfall statistics tool to generate a monthly summary for each gauge to check their totals, or you could graph them together in our graphing system and use the summary table to see the totals that way.  But now, there is an even better way, using the RMB tool.  The RMB tool allows you to plot the cumulative rainfall total from one gauge against another, for any given time period that you want.  Check out the simple example below, which shows the relationship between two rainfall gauges for the past 30 days:

As you can see, there is a pretty nice relationship between the two sites, indicating that both gauges were likely working well during this time.  Now let’s look at an example where one of the gauges was not working during part of the period:

In that example, you can see that for a period while rain was continuing to be registered at the Surrey Kwantlen Park site, no new rain was being recorded at the Semiahmoo F&G rainfall station.  The effect is even more pronounced if you choose to look at several rainfall gauges at once:

 

In the above example, two other gauges continue to record nicely during the time that the Semiahmoo F&G gauge is not operating, showing even more clearly where the problem lies.

Finally, you can choose to select the average of a group of gauges for use in X-axis of your graph.  This lets you filter out the effects of any one station.  Let’s take a look at this example:

You can see in the above example that we have chosen to combine the average of 3 separate rainfall gauges to use as the X-axis in our graph.  This is great when you want to work with the average value over a larger area, rather than relying on a single gauge for comparisons.

When you are done, you can choose to print or export these graphs, and you can even save them as templates for future use!

Quantifying I&I with FlowWorks

If you are responsible for operating a sanitary sewer system, you know tracking Inflow and Infiltration (I&I) is crucial. However, even with the best data this can be a challenging and sometimes tedious task without the tools to extract useful information from it. This is where FlowWorks comes in.

You have stations monitoring sewers and rainfall all over the city. The challenge for planners and engineers is to use this data to predict I&I in order to implement the required facilities or assess the results of infrastructure rehabilitation. To do this, a host of data is considered and some complex and often tedious calculations are undertaken. The versatile I&I tools in FlowWorks simplify many of the tasks required in I&I analysis, preventing errors and making the task actually tolerable (we won’t go so far as to say enjoyable!)  For those of us who used to do all of this in Excel spreadsheets, the first time you see FlowWorks do in seconds what used to take hours can be very exciting!. The program has already helped municipalities and consultants avoid potential overflows and resulting fines, which can come at a high cost to both the local environment and community.

For each storm event, FlowWorks takes into account Ground Water Infiltration (GWI) and Base Sanitary Flow (BSF), collectively known as Dry Weather Flow (DWF), and subtracts it from the total flow in the sanitary sewer to come up with Rainfall Induced I&I (RDII). This may not sound like a lot of effort, but when it has to be done manually across many stations and storm events it can easily add up to many hours of grueling, error-prone calculations.

Once you’ve accumulated an adequate number of storm events, FlowWorks will quickly handle plotting of an I&I envelope or the Q vs I relationship, giving you the relationship between I&I and rainfall so that return-period based I&I flows can be estimated.

All I&I analysis data can be saved for later reference or comparison and can be published for any audience, public or private. For those who have multiple monitoring sites, a seasonal set up, which includes dates of storms, dry weather patterns, etc., can be easily transferred between sites to avoid the hassles of setting up multiple sites.

If you haven’t tried out the I&I tools yet on some of your data, we encourage you to give it a try (use of the I&I tools is included in your subscription).

A True One-Stop Monitoring Shop

Flow monitoring must be efficient in order to truly be effective. With that in mind, FlowWorks continues to promote the ease of accessing all data sources in one location. We now have the ability to add real-time United States Geological Survey (USGS) and National Oceanic and Atmospheric Administration (NOAA) station data into our already- robust flow monitoring network.

The additional data is comprehensive:

  • Precipitation
  • Groundwater level
  • Streamflow
  • Surface water quality
  • Tide data

The upgrades bring more than 2,500 USGS precipitation stations, 9,000 streamflow stations, 1,300 groundwater level stations and 1,900 surface water quality stations to FlowWorks users. And, NOAA allows access to almost 50 real-time tide data streams. It’s all just keystrokes away. For a list of available stations in your area click here for USGS and here for NOAA.

This real-time data is typically recorded at 15- to 60-minute intervals, stored onsite, and then transmitted to USGS offices every one to four hours, depending on the data relay technique used. Recording and transmission times may be more frequent during critical events. Plus, data from real-time sites are relayed to USGS offices via satellite, telephone, and/or radio telemetry and are available for viewing within minutes of arrival.

The benefits are impressive. In essence, FlowWorks analysis and reporting tools enable more useful information to be captured from the USGS stations. For example, clients are able to enhance their existing rain gauge network with all available stations in their monitoring area, which increases access to spatial and temporal storm information.

Gwinnett County in Georgia is using this service to bring the 18 local USGS rainfall stations into their FlowWorks platform in addition to the 12 rainfall stations coming in from their SCADA system.  The result will be a dramatic improvement in their understanding of local rainfall conditions.

Implementing these new features—additional data—from FlowWorks requires just a small one-time setup fee and no monthly charges. More importantly, accessing all your data in one spot, and in real time, will improve the decision-making process perhaps more than any other upgrade a firm could make.

Inflow and Infiltration 101 – Part 3

This is part 3 of Mike Homenuke’s series on Inflow and Infiltration. For part 1 click here and part 2 click here.

Why care about I&I?

 Before we get too much further into this, we should probably discuss why we should even care about inflow and infiltration into our sanitary sewers. Whether you’re an engineer or an urban planner, inflow and infiltration (I&I)—surface runoff and groundwater that has entered the sanitary sewer system—should be on your radar.

 Sanitary sewer systems are designed to carry a specific volume of wastewater, usually from systems including toilets and sinks in homes and businesses. Meanwhile, stormwater sewers are designed to carry rainwater and groundwater away. However, when this water flows into sanitary sewers, it taxes the load on the overall system, including wastewater treatment plants.

 The result—public health risk and extra costs to your community. And if that doesn’t get your attention, consider that sanitary sewer overflows can kill fish and will violate state and federal environmental regulations.

 

Extra Load and Dangerous Consequences

Wet weather and storm events can quickly fill sanitary sewer systems beyond capacity. At that point, wastewater flows at higher-than-usual water levels and can begin to flood basements and homes and spill onto streets. These wastewaters and potential pathogens are a significant public health risk. And, as these flows mix into water bodies like streams and lakes, contamination becomes a major issue for all those interconnected waterways—harming the flora and fauna that reside there and can prompt officials to issue beach advisories and closures.

 EPA regulations 

The Environmental Protection Agency (EPA) requires regulated agencies possessing a National Pollutant Discharge Elimination System (NPDES) permit to stop all wastewater overflows from reaching United States waters. It’s a daunting and nearly impossible task because I&I can’t be stopped altogether, and will continue to increase over time as the infrastructure ages. Since the late 1980s public awareness and interest has grown in upgrading sanitary sewer infrastructure and municipalities are continuing to respond.

Costs can be high when it comes to dealing with I&I, and encompass fees associated with overflows, wastewater treatment and transportation facilities and funding opportunities. Also bear in mind that sewer backups that spill water into households can result in litigation for which the city or local agency may be responsible.

The best thing municipalities can do is to understand the I&I within their systems, and determine if larger responses could result in a problem.  I&I events are based on climatic events and as such their return periods can be calculated.  A return period I&I response that causes a sewer backup or overflow can be calculated for every pipe in a city. If the return period is less than the expected service level promised to the rate payers or results in an overflow that harms the aquatic environment, action is required.  Since I&I increases with sewer age, it’s important for utilities to understand the current response and calculate the corresponding return period.  Information such as this helps to avoid overflows and resulting fines—and starts with effective monitoring tools.

 Stay tuned for our next blog about how to quantify I&I and how FlowWorks can help.

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.