{"id":2803,"date":"2017-10-30T13:59:18","date_gmt":"2017-10-30T20:59:18","guid":{"rendered":"https:\/\/cm-edgetun.pages.dev\/industry\/blog\/uncategorized\/how-miami-dade-water-gets-smarter-with-the-internet-of-things\/"},"modified":"2019-10-16T02:22:04","modified_gmt":"2019-10-16T02:22:04","slug":"how-miami-dade-water-gets-smarter-with-the-internet-of-things","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/industry\/microsoft-in-business\/customer-experience\/2017\/10\/30\/how-miami-dade-water-gets-smarter-with-the-internet-of-things\/","title":{"rendered":"How Miami-Dade Water gets smarter with the Internet of Things"},"content":{"rendered":"\n\n\n
<\/a><\/td>\nFocus on: Empower Employees, Optimize Operations, Engage Customers
\n <\/span><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

There\u2019s not much like Miami-Dade\u2019s water. With almost three million residents, Miami-Dade is the seventh most populated county in the United States and a popular one for tourists. When visitors and residents can\u2019t make it to the beach, the Miami-Dade County Water and Sewer Department (WASD) brings the water to them through more than 6,000 miles of pipes.<\/p>\n

But with such a wide-ranging infrastructure comes the challenge of maintaining the system to protect residents and the environment from leaks and spills. With the Internet of Things (IoT), a cloud database, and thousands of sensors gathering data such as water pressure, flow rates, and rainfall, Miami-Dade\u2019s Water and Sewer Department (WASD) is developing a smarter way to manage and supply this precious resource and manage the wastewater serving over 400,000 households across the County. \"\"<\/p>\n

Modernizing an aging infrastructure<\/strong><\/span><\/p>\n

Miami-Dade sits roughly one meter above sea level. While that\u2019s excellent for bike cruises and beach life, for the water department that means relying on more than 1,000 separate sewer pump stations (many with more than 2 pumps) to push residents\u2019 wastewater through more than 4,000 miles of infrastructure\u2014some sections of which are over 90 years old. That\u2019s a lot of delicate pieces working in tandem to help flush a toilet, and those parts create massive amounts of data.<\/p>\n

The Supervisory Control and Data Acquisition System, better known as SCADA, is a control system architecture that Miami-Dade Water relies on to operate and collect data from their water pipes, sewer lines, meters, and pumps. For the past 22 years, SCADA has collected millions of rows of data every day\u2014flow rates, pressure, usage\u2014to provide data for engineers, operations staff, maintenance staff, and regulatory reporting. These metrics equipped Miami-Dade Water to measure usage, identify trends and defects, predict problems, and record work orders and maintenance, but for years, no one really knew what to do with those statistics until after a problem surfaced. Instead, they found themselves trying to figure out how to store, manage, and analyze that constantly-growing mountain of information.\"\"<\/p>\n

Limited to spreadsheets, SQL tools, and basic reports, SCADA users lacked any significant means of visualizing for their information, and the existing tools could only manage so much data at a time\u2014to the point that it took a team of WASD engineers upwards of days, weeks, or months to process data from a single pump station. For WASD to make significant improvements, they needed a way to look at more than 1,000 pump stations and every mile of pipe together. Without a holistic look at their system, engineers and analysts were limited to analyzing small individual scenarios.<\/p>\n

In 2013, the Federal Environmental Protection Agency (EPA) tasked Miami-Dade with managing and operating their sewer system more effectively. Their aging infrastructure was failing, and the results were spilling into residents\u2019 homes and out into the local ecosystem. The EPA now expects reports demonstrating WASD\u2019s infrastructure investments, along with maintenance, operator, and management dashboards that demonstrated their improvement. Visualizations that, given the pace of WASD\u2019s data and the condition of their infrastructure, felt nearly impossible to create. The WASD\u2019s Information Technology team proposed a technology solution to solve the agency\u2019s data problem, meet the EPA requirements, and rebuild their infrastructure in an IoT solution built on Microsoft Azure SQL Data Warehouse and Power BI.\"\"<\/p>\n

\u201cThere\u2019s so much data, and it\u2019s so voluminous that with the current tools, you can\u2019t see it. The answer might be there but you can\u2019t see it,\u201d Andrew, IT Manager, says. \u201cWe\u2019re looking at a platform that can process it and visualize it more quickly and accurately.\u201d<\/p>\n

Crunching the numbers in seconds, not days<\/strong><\/span><\/p>\n

This new platform equips the WASD\u2019s Information Technology team with the scalability, insight, and power to process data in seconds rather than days. Andrew explains, \u201cThe engineers would get an extract of three years\u2019 worth of data of one metric of that one pump station\u2014because that\u2019s all a spreadsheet can handle. But now we can crunch data from more than 1,000 pump stations from the past 22 years in a matter of seconds.\u201d<\/p>\n

Since adopting their cloud solution, WASD has loaded over fifteen billion rows of SCADA historical data into their Azure SQL Data Warehouse and are adding over four million more every day. This not only equips WASD to better analyze and act on its existing infrastructure but will allow for better insight which can help the planners, operations and maintenance staff identify and respond. If the pumps are overworked, this can be quickly identified for a maintenance crew to respond.<\/p>\n

That\u2019s the beauty of near real-time data\u2014it will allow WASD to proactively serve Miami-Dade County residents instead of responding to issues after the fact. WASD employees can address those needs much more effectively and with intention instead of reaction.\"\"<\/p>\n

\u201cWhen you look at the data, it paints a better picture and tells a richer story about what to do,\u201d Andrew says. \u201cThat\u2019s how I see IoT being able to help the county analyze the data it has and likely make better decisions about planning and operations.\u201d<\/p>\n

Improving service and reducing costs with the Internet of Things<\/strong><\/span><\/p>\n

With Azure SQL Data Warehouse, WASD staff can extract data from specific years and better visualize those metrics to conduct a proper analysis over time. Visualizations can include charts, graphs, GIS, and even tabular data extracts. Data can be stored as necessary to better identify key details, and planners and engineers can make data-driven decisions in near real time instead of acting based on outdated data.<\/p>\n

\u201cThe new platform and its benefits were presented to planning engineers a few weeks ago, and they were amazed and excited as well as looking forward to use technology to solve their everyday problems,\u201d Andrew says.<\/p>\n

But it\u2019s not just improving WASD\u2019s analytics\u2014it\u2019s saving them money. This new solution provides a more efficient use of WASD\u2019s annual budget and better spends tax payers\u2019 dollars. Now, the WASD\u2019s Information Technology team and WASD staff can easily pull data from their entire network to create not only a holistic view of their infrastructure but a more accurate profile of each pump station, its maintenance history, and projected future performance.\"\"<\/p>\n

This Azure solution could have wide implications across Miami-Dade County. With help from the Microsoft team, WASD created a utility resource that is scalable and easily transferable for use by other government agencies. Other agencies can apply a similar IoT solution to the predictive and preventative maintenance of its operations.<\/p>\n

\u201cWASD has lots of data, but until now they didn\u2019t have the platform to process large amounts of data this quickly. And when you can, I think you\u2019re able to ask the data different questions that you couldn\u2019t do before, and if the answer is in the data, it can be surfaced,\u201d he says.<\/p>\n

Every day, WASD\u2019s Information Technology team working with the business users are asking those questions to improve the lives and ecosystems of Miami-Dade residents. Together with their new Microsoft solution, they\u2019re finding answers and reshaping the future of how governments use data and technology to better serve citizens.<\/p>\n

\"\"<\/a><\/p>\n

\n

Related Content<\/span><\/p>\n