Municipality puts wireless water meter-reading data to work

Town of Cary uses SAS® Analytics to analyze data from sensors, assess demand, detect problems and visually engage customers

A leaky faucet. A malfunctioning dishwasher. A cracked sprinkler head. These are more than just a headache for a homeowner or business to fix. They can be costly, unpredictable and, unfortunately, hard to pinpoint.

Through a combination of wireless water meters and an analytics-driven, customer-accessible portal, the Town of Cary, North Carolina is making it much easier to find and fix water loss issues. In the process, the town has gained a big-picture view of water usage critical to planning future water plant expansions and promoting targeted conservation efforts.

When the Town of Cary installed the wireless meters for 60,000 customers in 2010, it knew the new technology wouldn’t just save money by eliminating manual monthly readings; the town also realized it would get more accurate and timely information about water consumption. The Aquastar wireless system reads meters once an hour – that’s 8,760 data points per customer each year instead of 12 monthly readings. The data had tremendous potential, if it could be easily consumed.

“Monthly readings are like having a gallon of water’s worth of data. Hourly meter readings are more like an Olympic-size pool of data,” says Karen Mills, Finance Director for the Town of Cary. “SAS helps us manage the volume of that data nicely.” In fact, the solution enables the town to analyze a half-a-billion data points on water usage and make them available, and easily consumable, to all customers.

Monthly readings are like having a gallon of water’s worth of data. Hourly meter readings are more like an Olympic-size pool of data. SAS helps us manage the volume of that data nicely.

Karen Mills
Finance Director for the Town of Cary

The ability to visually look at data by household or commercial customer, by hour, has led to some very practical applications:

  • The town can notify customers of potential leaks within days.
  • Customers can set alerts that notify them within hours if there is a spike in water usage.
  • Customers can track their water usage online, helping them to be more proactive in conserving water.

Through the online portal, one business in the Town of Cary saw a spike in water consumption on weekends, when employees are away. This seemed odd, and the unusual reading helped the company learn that a commercial dishwasher was malfunctioning, running continuously over weekends. Without the wireless water-meter data and the customer-accessible portal, this problem could have gone unnoticed, continuing to waste water and money.

The town has a much more accurate picture of daily water usage per person, critical for planning future water plant expansions. Perhaps the most interesting perk is that the town was able to verify a hunch that has far-reaching cost ramifications: Cary residents are very economical in their use of water. “We calculate that with modern high-efficiency appliances, indoor water use could be as low as 35 gallons per person per day. Cary residents average 45 gallons, which is still phenomenally low,” explains Leila Goodwin, Water Resource Manager for the town. Why is this important? The town was spending money to encourage water efficiency – rebates on low-flow toilets or discounts on rain barrels. Now it can take a more targeted approach, helping specific consumers understand and manage both their indoor and outdoor water use.

SAS was critical not just for enabling residents to understand their water use, but also in working behind the scenes to link two disparate databases. “We have a billing database and the meter-reading database. We needed to bring that together and make it presentable,” Mills says.

The town estimates that by just removing the need for manual readings, the Aquastar system will save more than $10 million above the cost of the project. But the analytics component could provide even bigger savings. Already, both the town and individual citizens have saved money by catching water leaks early. As the Town of Cary continues to plan its future infrastructure needs, having accurate information on water usage will help it invest in the right amount of infrastructure at the right time. Additionally, understanding water usage will help the town if it experiences something detrimental like a drought.

“We went through a drought in 2007,” says Goodwin. “If we go through another, we have a plan in place to use Aquastar data to see exactly how much water we are using on a day-by-day basis and communicate with customers. We can show ‘here’s what’s happening, and here is how much you can use because our supply is low.’ Hopefully, we’ll never have to use it, but we’re prepared.”

Town of Cary logo

Challenge

  • Analyze a half-a-billion data points on water usage and make them available, visually, to all customers.
  • Gain a big-picture view of water consumption to better plan future water plant expansions and promote targeted conservation efforts.

Solution

SAS® Analytics

Benefits

  • Customers can know within days if they have a leak or other water-usage spike.
  • Customers can set alerts to notify them immediately when their water usage exceeds a predefined amount.
  • The town better understands how water is consumed.
  • The town can identify when water is leaking in its network of pipes.
  • The town can better prepare for future water needs and emergency events like a drought.
The results illustrated in this article are specific to the particular situations, business models, data input, and computing environments described herein. Each SAS customer’s experience is unique based on business and technical variables and all statements must be considered non-typical. Actual savings, results, and performance characteristics will vary depending on individual customer configurations and conditions. SAS does not guarantee or represent that every customer will achieve similar results. The only warranties for SAS products and services are those that are set forth in the express warranty statements in the written agreement for such products and services. Nothing herein should be construed as constituting an additional warranty. Customers have shared their successes with SAS as part of an agreed-upon contractual exchange or project success summarization following a successful implementation of SAS software. Brand and product names are trademarks of their respective companies.