IBM Smarter Cities Challenge City of Tucson Award Recipient for 2013 November 14, 2012

1. IBM Smarter Cities ChallengeCity of Tucson Award Recipient for 2013November 14, 2012

2. BackgroundAvailable Water Supplies Colorado River Alan ForrestDirector, Tucson Water Renewable Water Supplies • Colorado River Allocation • Recycled Water • “Other” Water Supplies Rocky Mountains Santa Cruz River Tucson Water Supply In Channel Recharge Finite Water Supplies • Groundwater • Stored Colorado River Water Reclaimed Water

3. BackgroundExtensive & Complex System Covering a Large Area with a Relatively Low Population Density System ~107,000 AF 120,000,000 KWH 4.200 miles of water mains ~ 800,000 Customers 225,000 Metered Services 212 Production Wells ~65 Water Storage Facilities ~100 Boosters 22,000 Fire Hydrants 80,000 Valves Tucson Water Potable Water System Tucson City Limits Potable Water Lines (2” - 96”) Tucson Miles 0 5 10

4. BackgroundExtensive & Complex System Covering a Large Area with a Relatively Low Population Density Tucson Water Potable and Reclaimed Water Systems System Demands Average Day: 15.6 MGD System 165 miles of piping 4 Production facilities 6 storage reservoirs 8 booster stations Landscape irrigation on: 18 Golf Courses 65 Schools 50 Parks 726 Residential 137 Commercial 3 Others Tucson City Limits Reclaimed Water Potable Water Lines Tucson Tucson Miles 0 5 10

5. Tucson Water Challenges Coordinating technology improvements in water metering and SCADA upgrades for better customer service. • Utilize Advanced Metering Infrastructure (AMI) technology to increase efficiency in measuring water use • Further conservation by giving easy access for customers to daily water demand information • Implement SCADA upgrades to enhance water operations and energy efficiencies Sandy Elder TW Deputy Director

6. Advanced Metering Infrastructure (AMI) • Tucson Water (TW) has ~225,000 water meters. ~50,000 meters have drive-by automatic meter reading (AMR) hardware. • AMR offers flexible upgrades from drive-meter to a fixed network AMI system. • All manually read (walk-by) meters will be converted to AMR over a ten-year capital improvement project. • TW intends to prepare an AMI Strategic Plan that presents the costs and benefits of various approaches to reading water meters and establishes the business case for implementation of recommendations.

7. Project DetailsDriving Forces for Implementing Water Utility AMI • Water loss reduction and revenue recovery (leak detection and auditing) • Improvement of customer service issues (ability to respond to calls and complaints) • Promote water conservation • comparative use plots among neighbors • innovative incentive programs to encourage changing time of appliance or irrigation to reduce peak water and energy consumption • Reading frequency versus perceived cost of water and wastewater bills • Cost reduction in traditionally labor intense areas (manual meter reading) • Improved meter asset management Monitor your water use in “real time”

8. Data Challenges • New AMI systems must interface with existing utility systems, including CIS applications • New AMI systems must peacefully coexist with multiple meter data collection technologies with diverse reading requirements • AMI systems produce high volumes of data for both billing and analytic purposes

9. Project DetailsWhat is SCADA? SCADA: Computer system that monitors and controls processes of physical assets at multiple sites over large distances. Processes include water pressures, flows, reservoir levels and energy use Master Station Computer Water Operator City IT Infrastructure Water Main Booster Pump Water Main Radio Tower Water System RTU’s

10. Used to operate system assets of over 350 sites from production, transmission, storage, pumping, and distribution to services. Produces 12 Gigabytes of data yearly. (approx) Data used for regulatory compliance, cost analysis, system planning Project DetailsSupervisory Control and Data Acquisition (SCADA) Systems

11. Project DetailsWhy upgrade SCADA? • System installed 1984 • Last upgrade in 2001 • Technology has changed • Installed software/hardware at End-of-Life • Required functionality greater than installed system capabilities

12. Project DetailsSCADA Opportunities • Connecting customer demand data with water process control data • Scheduling water pumping to match customer demand to save energy by conducting a mass balance over time • Central to forecasting demands to determine system operations or react to current conditions • Identify occurrences of leaks and breaks by comparing withdrawals with monitored system inflows • Tracking system changes in: • Pump characteristic and efficiency curves over time for: • Re-calibrating pump curves and • Predicting pump/motor failure or impending need for repairs to maintain efficiencies and lower energy consumption/cost.

13. ConceptIssues and Questions • Customer acceptance – Use • Scalability – Magnitude/complexity of system • Data management – System architecture • Bandwidth – How much is enough? • Data storage – Archiving • Data mining application development platform for developers • Partnering with local electric utilities

14. What IBM can do for Tucson Water IBM can help Tucson Water improve customer service, reduce costs, and maximize the use of data to create the smart and efficient water delivery system. As a grant recipient, Tucson will receive pro bono consulting expertise valued at $400,000.

15. IBM Smarter Cities ChallengeCity of Tucson Award Recipient for 2013November 14, 2012 Questions?