Houseman, Ann

Ann Houseman is a Principal Engineer at Hazen and Sawyer working primarily with the Water Resources and Utility Management Service groups. Since joining Hazen's Atlanta Office in 2016 after graduating from Auburn University, Ann has grown from an assistant engineer to a project manager assisting clients with projects including hydrologic and hydraulic modeling; dam rehabilitation, dam removal, and stormwater management design; asset condition assessments; asset management; and data analytics.

Titles from this speaker

A Collaborative Approach to Business Intelligence Software Selection

Abstract

Clayton County Water Authority (CCWA) provides clean, quality drinking water and wastewater collection and treatment to its estimated 275,000 residential, commercial, and industrial customers in Clayton County, GA as well as portions of Fulton County and Henry County. CCWA recently developed a performance management model that identifies strategic and operational metrics aligned with its strategic goals for each department. To effectively track and communicate organizational performance against these metrics to stakeholders, CCWA sought to select an enterprise business intelligence (BI) software to be deployed across the organization. The first step to successful selection and implementation of an enterprise BI software was to develop a robust understanding of CCWA's existing software architecture. Data characterization workshops were held to identify software systems and databases used by each department and distinguish them by hosting environment, user groups, integration with other databases or software systems, general functions, workflows, and reporting needs. This information served as the basis for creating a detailed software architecture map, which provides CCWA with valuable insight into their existing system and a vision for how an enterprise BI software would tie into their existing infrastructure. Information gathered during the data characterization workshops was also critical in defining the BI software evaluation criteria. An initial list of performance criteria was developed based on industry experience and narrowed to focus on key areas of interest for each department within CCWA. The final criteria included a variety of attributes for enterprise BI software including: - Compatibility, which focuses on the ability of the software to integrate with CCWA's existing system and transform data into the correct structure required for creating dashboards. - Development and Maintainability, which includes support for a mature formula language, a scalable and flexible data model structure, integrated metadata capabilities, and consideration for staff resiliency. - User Interface, which centers on the ability of the software to create compelling, easily understood, interactive visualizations of CCWA's strategic and operational metrics. - Ecosystem Capabilities, which considers the ability of the software to enable platform security, administration, and sharing in cloud-based and on-premises environments, and the ability of the software to integrate machine learning techniques. - Market Stability, which focuses on how well the company that owns the BI software has supported its development and innovation in the past and the company's vision for the future. Taking time to gather input from a variety of stakeholders including Board members, general management, department directors, and CCWA staff was critical to the successful selection and implementation of the enterprise BI software. Clearly demonstrating how stakeholder input from the data characterization workshops was incorporated into the BI software evaluation criteria promoted interest, buy-in, and trust across the organization. This presentation will discuss the collaborative approach used to evaluate and select an enterprise BI software including data characterization, development of selection criteria, software evaluation and testing, selection of a final enterprise BI software, and development of a roadmap to ensure successful implementation.

This paper was presented at the WEF/AWWA Utility Management Conference, February 21-24, 2022.

SpeakerHouseman, Ann

Presentation time

11:00:00

11:30:00

Session time

10:30:00

12:00:00

SessionData Management

Session number2

Session locationHyatt Regency Grand Cypress, Orlando, Florida

TopicAsset Management, Business Intellligence, Business Process Optimization, Condition Assessment, Data Analytics, Data Management, Management Systems, Risk Analysis

Author(s)

A. HousemanL. Chamblin

Author(s)A. Houseman 1; L. Chamblin 2

Author affiliation(s)Hazen and Sawyer 1; Clayton County Water Authority 2

SourceProceedings of the Water Environment Federation

Document typeConference Paper

PublisherWater Environment Federation

Print publication date Feb 2022

DOI10.2175/193864718825158241

Volume / Issue

Content sourceUtility Management Conference

Word count9

A Stepwise Approach to Developing a Flood Emergency Planning and Climate Adaptation Program with Case Studies from Clayton County, GA and Boston, MA

Abstract

Many communities perceive climate adaptation efforts as being prohibitively expensive, resource intensive, and complex. This presentation introduces a step-by-step approach that communities can follow to overcome these barriers by examining climate adaptation efforts undertaken by two unique communities. The approach illustrates how lower cost efforts that utilize publicly available data can help communities begin adapting to climate change threats such as intense rainfall, rising sea levels, and coastal or fluvial flooding while also laying the groundwork for future, more intensive efforts. One example is the Flood Warning and Response Plan (FWRP) project for the Clayton County Water Authority (CCWA), which demonstrates how publicly available datasets can be used to inform emergency planning and flood preparedness. Another case study highlights inundation modeling and coastal stormwater conceptual design efforts that were recently completed in Boston. Topics covered include the following:

*Strategies for identifying, obtaining, and analyzing publicly available datasets for resilience planning and vulnerability assessment

*Leveraging climate change projections to update and establish appropriate design storms and future levels of service

*Development and application of two-dimensional (2D) hydraulic/inundation models to develop flood management solutions and characterize flooding for various adaptation scenarios (using PCSWMM and parallel computing)

*Tools for public communication including static mapping, interactive mapping, emergency planning dashboards, and 360-degree photos and flood renderings The FWRP project for CCWA will be used as a case study for communities interested in beginning the process of identifying and adapting to climate threats, that do not currently have the ability, or are not ready, to engage in more intensive efforts involving the development of custom hydrologic and hydraulic models. Clayton County, Georgia and its incorporated municipalities are partially located in the floodplains of the Flint and Ocmulgee Rivers, which pose a risk of flooding to the community. A countywide FWRP was developed as a tool to coordinate and guide effective response to flood events with the goals of promoting public safety and mitigating damage to critical infrastructure. The flood analysis used GIS, HEC-RAS, and publicly available data to identify the highest risk critical facilities and road crossings for flooding in Clayton County. The resulting flood maps highlight the facilities and roadways most vulnerable to impacts by the FEMA 100-year floodplain allowing CCWA to better understand where to focus emergency response and future climate adaptation efforts. The FWRP was developed in collaboration with CCWA, emergency responders, and other public agencies. It outlines strategies for flood preparedness, flood forecasting and monitoring methods, communication and response procedures, and post-flood recovery actions. The plan was adopted by CCWA and distributed to stakeholders in 2023. Future considerations for plan development include inundation modeling in high-risk areas for a range of design storms based on climate change projections and the development of more robust flood monitoring and simulation tools. The case study/work in Boston, however, demonstrates the implementation of these future steps. Figures 1 and 2 depict mapping and a response plan developed during the project. In 2017, Hurricane Harvey highlighted the severe impacts that extreme storm events can have on coastal urban areas. In the wake of this disaster, BWSC initiated the Inundation Model project to evaluate Boston's vulnerability to similar extreme storm events and develop a tool for emergency planners, City agencies, and residents to use ahead of extreme storm events. This resulted in Boston's first, citywide, 2D flood model and groundbreaking visualization and analysis tools. During the project, emergency planning tools and model predictions were developed to help increase Boston's preparedness for climate change and extreme storms. The Inundation Model project culminated in the development of a suite of tools including an innovative, custom-coded dashboard and online interface called the Inundation Model Viewer, that combines high-resolution, 360-degree images; ESRI ArcGIS story maps and a custom map viewer; and Microsoft PowerBI and SQL Server to visualize results, as shown in Figure 3, 4, and 5. Combining these technologies presented complexities but produced an elegant and simple means for users to interact with and 'see' model predicted flooding at well-known locations throughout Boston for various extreme storm events. The publicly accessible web-based Inundation Model Viewer maximizes accessibility of study results to the public, and aids in comprehension through non-technical visualizations such as maps and interactive streetview renderings of flood predictions. The work represents a benchmark for future practitioners publicly communicating flood study findings and helps facilitate awareness of flood risks among residents and other public officials. Using each of these projects as case studies, this paper and presentation will summarize key data needs, level of effort, challenges, and expected outcomes at each step (starting with static mapping and concluding with fully interactive mapping and tools) in the development of a flood emergency planning and climate adaptat

This paper was presented at the WEFTEC 2024 conference in New Orleans, LA October 5-9.

SpeakerAgrawal, Benjamin

Presentation time

14:30:00

15:00:00

Session time

13:30:00

15:00:00

SessionClimate-Proofing Our Cities: Transformative Solutions

Session number406

Session locationRoom 340

TopicClimate Change Adaptation and Metrics, CSO & SSO Planning and Mitigation, Intermediate Level, Stormwater and Green Infrastructure