Smarter Sustainable Dubuque Local Analytics in Action

1. Smarter Sustainable Dubuque Local Analytics in Action Connecting the Dots Between Engagement and Understanding February 12, 2013

2. A Unique Partnership of the City of Dubuque and IBM Research

3. IBM/DubuqueSmarterSustainableCityPartnership • Announced Sept. 17, 2009 • IBM’s first “Smart City” in the U.S. • Goal: Replicable model for cities under 200,000 • Coordinating smart, instrumented technology with active community engagement • Providing residents with information and tools • needed to: • Save Money •  Conserve Resources •  Improve local economy and environment

4. Americas Europe Middle East Africa Asia IBM Research at a Glance IBM Partnership Structure IBM Organization IBM Research Engagements Geographies Business Units Key Focus Areas First of a Kind/Proof of Concept Sales & Distribution (Client Relations) Material Science Research & Customer partnerships to prototype tomorrow’s technologies on today’s business problems. Global Technology Services (SO, Hosting, Technology) Analytics Conferences Software Group (Inf Mgmt, Middleware, Web tools) IBM Research Technology Innovations & solutions presented and discussed with other leading experts in the field. Next Gen Computing Systems & Technology Group (Storage, Servers) Research Papers Industrial Solutions Technology breakthroughs published in research journals Global Business Services (Consulting, BTO, AS & SI) Science & technology Industry Technology Consortiums Integrated Supply Chain (SC, Call Centers, Inventory) Industry leaders collaborating to drive technology solutions & innovation Storage

5. Water Electricity Travel Discards Health and Wellness

6. Smarter Sustainable Dubuque • Designed to give people what they need so they can do what they want • Save money and resources • Improve environment and local economy • Improve Health & Wellness Reliable information specific to them

7. Data Relevance Which accomplishes its objective by increasing the availability and usability of relevant data both as it relates to the number of resource decisions it can effect and the level of impact it can have

8. IBM Smarter Sustainable Dubuque Model Smarter Sustainable Dubuque Research Cloud Staff and Management Portal Smarter City Services Layer Applications, Website, Security Citizen Portal Analytics Decision Support and Modeling Metrics, Monitoring, Analytics and Insights Data Integration and Data Management Travel Discards Water Electricity Health Instrumented Data Collectors

9. Smarter Water • Volunteers • 400 volunteers • 600 total households • 300 active portal users • 100 never accessed the portal • 200 no access to the portal or their data • Volunteers in a Specific Geographic area • High Concentration of Residential Water Users • Similar Topography • Last Area for Water Meter Replacements • Helpdesk • Responded to questions • Conducted Training sessions • Corresponded and engaged participants

10. Smarter Water Data Collection Collectors download data to City servers using the City’s fiber optic backhaul 16 Data Collectors MIU Hourly reading data transmitted once per day to collectors using licensed frequency Data is transferred To a secure ftp site IBM automatically picks up data once per day

11. Smarter Water Portal Menu Area Progress Area Profile Area Usage Area Leak Notification Detail Area

12. Smarter WaterLessons Learned and OpportunitiesPilot Project • 77% improved water usage understanding • 61% took specific actions to conserve • 48 % reported they plan to make additional changes in their appliances or in how they use water (or both) • 6.6% decrease in utilization • 8 fold increase in leak detection/response: What if we apply new knowledge and tools to 23,000 households? What if 23,000 households had an opportunity to be notified of continuous or intermittent leak?

13. Smarter WaterLeak Repair Grant • Water Leak Repair Grant • Individually metered residential units (including rentals) • One grant provided per building if not individually metered • The grant is available one time per 12 months per service address • Leak notification appears on meter or smarter water portal • Contact by SSD helpdesk by phone or electronically • The amount of reimbursement is 50% of the repair work up to $100 maximum

14. Smarter Water Opportunities • Currently offering an expanded sign-up for Smarter Water Portal to residents and small businesses • Proving value at “entire community” scale • Engagement opportunity for City • Smarter Water Portal Provides a tool for: • Increased Understanding and Education on Water Usage • Indentifying High Water Uses • Identifying Leaks

15. Smarter Water Challenges • Challenges • Monetizing and identifying water “savings” on a community scale • Defining metrics, reporting, dialoging, taking actions • “Meeting consumers where they are” – keeping them engaged when and how they wish

16. Meeting Consumers Where They Are Enlighten Me 20% Inform Me 60% Warn Me 20%

17. Smarter Electricity Pilot Project • Partnership of City, State (Power Fund) and Alliant Energy. • The goal is to allow volunteer participants to better monitor their electric energy consumption and enable them to make more-informed choices about when to use energy and how much they are using • In spring 2011 Alliant Energy installed new AMI (advanced metering infrastructure) electric meters at nearly 1,000 volunteer Dubuque households and is providing the electricity usage data from those households to the City and IBM for analysis. Hourly meter readings are transferred to IBM once per day

18. Smarter Electricity Pilot Project Lessons Learned and Opportunities • Usage reduction ranging from 3% to 11%. • If extrapolated to community as a whole, annual savings range from $552,000 to $3,588,000. • 68% said it increased their understanding of personal electricity use. • 45% said it helped them find specific ways to reduce based upon their individual usage. • Strategies most often used by consumers included shifting to non-peak usage (52%), turning off devices (44%), decreasing lighting (29%) and decreasing heating/cooling (20%)

19. Energy Portal Main Page Menu Area Profile Area Progress Area Daily Usage Area Insight Area Consumption Area Comparison Area Action Area

20. Smarter Travel • City, Regional, State, Federal and Private Sector Research Partnership • New technology successfully developed and deployed: - RFID (Radio Frequency Identification Device) - SmartPhone (Transit Planner) • Recruitment of over 1,000 volunteers • Transit route optimization opportunities • Outcomes include policy optimization opportunities (knowing when, how, where and why citizens are traveling makes that easier and more accurate) • Outcomes include “options in real-time” to citizens (whether they are looking for ways to avoid vehicle miles travelled or just avoid traffic congestion on their route)

21. Smarter Health and Wellness • Exploring opportunities for Smarter Health and Wellness • Short pilot on obesity engagement and prevention: • use existing SSD volunteers and IBM employees • demonstrate feasibility, technology and impact • design program with larger scale efforts in mind

22. Smarter Health and Wellness • Opportunity for citizen interaction, engagement and impact • Dubuque as a “Living Lab”: Technology + Engagement = Data • Expanding access and value: Data = Decision-making and policy-making • Initial meeting with City health and business leaders positive

23. Smarter Discards • A prototype platform for tracking and managing individual and aggregated waste (trash and recyclables) disposal activities • City will identify volunteers among its residents to participate in this project • City will identify two waste management routes to participate in this project • IBM will develop software tools for transferring, updating and processing the Data • Management/Aggregate and Individual Portals

24. First Draft “City” Diversion Page Compost 10% tons Annual Waste Totals 18000 15000 12000 Recycle 30% 9000 6000 3000 2011 2010 2012 2009 Year-to-date breakdown 100 Average Diversion Rates 80% Diversion cost savings Year-to-date: $166K 60% 40% 20% Note: hovering over one of the “total” recycle bars with your mouse will give a pie chart of the finer level breakdown if the data is available. 2011 2010 2012 2009

25. Draft of a “City” default view Compost 10% Recycle 30% Data Configuration Admin tools Year-to-date discard breakdown Diversion cost savings Year-to-date: $66K Interactive Analysis alerts/log messages Key Performance Indicators Oddity Analysis

26. Sustainability requires on-going efforts (it is a process not a product) Replicating infrastructure and initiation efforts for each new activity is inefficient IBM interested in researching the potential to “automate” sustainability campaigns. Searching for a good candidate project in City of Dubuque (small and defined to start) Community Engagement Platform

27. Opportunity Create a model for citizen and community engagement using technology tools which provide a view oriented approach

28. DubuqueView DubuqueView • What is it? A web and mobile enabled set of interactive technology tools for the purpose getting accurate and up to date information to people when and how they need it to make the decisions they need to make. • How? By leveraging the City’s investment in data, applications, mobile and social media tools to create an easy to use, integrated and accessible interface for citizens, mayor, council, staff and management.

29. DubuqueView Part of an Equitable Engagement Process • DubuqueView is built by the citizens through an engagement process that is participatory, inclusive, deliberative and collaborative • During a disaster and times of critical engagement thepublic is our eyes • Mechanism to deliver the information which is both high tech and high touch • Rich in content and broad in reach

30. assess the emergency situation, mobilize city resources and engage citizens to minimize the impact of the disaster • assess the emergency situation, mobilize city resources and engage citizens to minimize the impact of the disaster • assess the emergency situation, mobilize city resources and engage citizens to minimize the impact of the disaster • Provides a way to assess the emergency situation, mobilize city resources and engage citizens to minimize the impact of the disaster • Provides a way to assess the emergency situation, mobilize city resources and engage citizens to minimize the impact of the disaster DubuqueView and “Big Data” Synthesize and analyze large amounts of data from unrelated and unstructured sources Shared, Easy to Access, Common Operational Picture “DubuqueView” Logistics Operations Command Communications Web Mobile Desktop

31. DubuqueView Model • Role Based Views into Shared Data Sources • Citizen Inform • Community Connect • Staff – Management Alert and Advise • Elected Officials Recommend

32. Business Analytics Communications Logistics Business Analytics Business Analytics Command Operations Business Analytics

33. Dubuque View “Where are We?” • Database Design, Data Population and Applications in Development • ESRI Local Government Data model as a basis for nearly 300 feature classes and 100 GB of GIS data maintained by the City of Dubuque on a daily basis • Geocoding Social Media Feeds • “Story-boarding” projects through GIS • Mobile CRM • IBM Community Engagement for Health & Wellness and Water Expansion

34. What does this mean to the citizen? • Tools which are readily available on multiple delivery platforms – computer – mobile device – cell phone • Increase citizen impact on City service delivery – easy access to tools for dialogue using social media – chat - blogs • Increase citizen ability to analyze issues with current relevant data • Increasing Citizen access and input by meeting them where they are most comfortable

35. “I've got the greatest job in the world. There's no other job in government where cause and effect is so tightly coupled where you can make a difference every day in so many different ways and in so many different people's lives. It's a great challenge.” Michael Bloomberg, Philanthropist and Mayor of New York City

36. Questions