Client Success Story

A Water Utility’s Asset Management Strategy
Goes Vertical

City of Evansville, Indiana

The Challenge

It takes a lot to manage water and wastewater plants and their associated assets. Utility organizations need a way to organize and track preventative maintenance activities and vertical asset data.

The Solution

Evansville Water and Sewer Utility—with the help of POWER Engineers Inc.—implemented Cityworks to streamline plant management and maintenance workflows and to organize and track vertical assets

The Evansville Water and Sewer Utility (EWSU) draws water from the nearby Ohio River to supply water and sewer services to 65,000 customers in the metro area. As a longtime Cityworks user, EWSU is well-versed in managing and tracking its horizontal water and wastewater assets. 

Vertical asset data for the utility’s three water and wastewater treatment plants had historically been tracked via paper methods and current work activities were being tracked through two legacy systems. Although the two asset management systems for the utility’s treatment plants were working well, neither system had a mapping component, and the asset selection process was not robust enough to consistently meet EWSU’s preventative maintenance needs. 

Recognizing there was a gap between the information being collected and the assets being managed, EWSU turned to longtime trusted advisor POWER Engineers, Incorporated (POWER), to overhaul their vertical asset tracking and management procedures.

Improving Inspection Programs

The team began by converting the water treatment plants’ mechanical work activities in the legacy system to Cityworks AMS branching inspections. Branching inspections were selected since they could facilitate the robust nature of the vertical asset hierarchy and align with the Institute of Asset Management’s best practices. 

Since EWSU did not have a complete GIS database for the treatment plant, the project team was able to build the assets into the branching inspection so that each system branch was exclusive. With this style of inspection, observations displayed to the user are determined by each previously selected result, allowing the user to hone in on a discrete asset or system and create a finite selection. This helps ensure accuracy of inspections by reducing the chance of choosing an incorrect asset.

an icon with a green outline of the state of Indiana

Evansville,

Indiana

Population Served: 121,000

Depts. Using Cityworks: Engineering Services, Distribution and Collections, Plants, Vehicle Maintenance and Regulatory Compliance

Staff Using Cityworks: 50

Cityworks User Since: 2012

A screenshot showing a checklist of activities related to inspecting a sump pump

Sump pump inspection observation on the Alum and Chlorine Building Inspection template. Observations were configured with a blank result set to display the necessary safety measures and inspection instructions in an easily accessible location.

Before the implementation of Cityworks, deteriorating asset conditions of water filtration were not reportable or traceable and were often communicated verbally or recorded on paper, which made it difficult to properly manage and maintain this system. To help streamline these processes, linear inspections in Cityworks were developed to capture cyclical preventative maintenance activities. Instruction and safety check observations were configured without any predefined result set and were designed to appear at the top of each observation set. This arrangement ensures the user must review the observations prior to beginning the inspection. To support the water treatment plant’s preventative maintenance needs, roughly 30 cyclical inspections were configured. 

Realizing the benefits that Cityworks, Esri, and their vertical asset management system could provide, stakeholders on the wastewater side of the treatment plant requested POWER’s assistance with migrating wastewater work management practices to Cityworks. This involved an intense review and understanding of the approximately 440 separate work types within the legacy system and how those would translate into Cityworks work orders and inspections. 

This migration has resulted in removing redundancy and culling the work activities down to roughly 180 total work orders and inspection templates. These inspections and work orders will tie into the new vertical asset hierarchy being developed for wastewater assets.

Expanding Vertically

Building on examples from similar utilities around the country, POWER constructed a vertical asset structure that was concise, promoted ease of data editing, and facilitated the future growth of the utility’s GIS data. By strategically grouping similar assets into a small number of tables (HVAC, electrical, etc.), EWSU staff can easily find specific types of equipment without having to search through an overwhelming number of tables.

Using GIS relationship classes, EWSU can quickly find all assets in an individual wastewater treatment plant or facility. Not only will this allow for reporting on all assets in a facility or site, but will also allow for future reporting to identify assets that are frequently failing or incurring an excessive cost. EWSU plans to continue expanding its GIS vertical hierarchy to make sure all inspection and asset data is cataloged in GIS, the utility’s system of record.

An image showing the hierarchy of vertical asset structure that will be deployed for Headworks

An example of the vertical asset structure that will be deployed for headworks. Headworks is a spatial feature and all items below Headworks are related tables. 

Streamlining Inspection Workflows

EWSU implemented a number of key features to help refine and streamline various workflows for their inspection programs. The utility set up its inspection program hierarchies to be location based rather than equipment based. This allowed the maintenance crew to follow a similar process that was originally used before the implementation of Cityworks, which included selecting a building location first instead of the equipment type. When the crew visits a location, all preventative maintenance can be done at one time in a single location, removing the need for multiple visits—making inspections and maintenance activities more efficient.

High service pump #4 located in the high service 2 area of the Water Treatment Plant.

The location-based process aligns with the GIS and helps streamline inspections for the utility, making it more cost- and time-effective. This workflow allows an entire filter bed group or the entire chemical building to be inspected during one visit with each component visited representing a unique inspection observation.

Due to the concrete construction of treatment plants, the signal strength inside most plants is low, making it difficult to input inspection data from the field. EWSU solved this issue by implementing the Cityworks mobile app, which can be used in a disconnected environment and synced when back online. They also provided the teams with iPads equipped with cellular LTE connectivity. With this new setup, teams don’t have to rely on a Wi-Fi signal to conduct their inspections within the plants.

Looking Ahead

EWSU plans to expand its use of Cityworks and ArcGIS to encompass electrical, HVAC, and structural inspection activities. They also plan to create a vertical GIS asset model for water treatment, which would further assist in maintaining their water assets and would expand their use of Cityworks in plant management. In the near future, EWSU will perform condition scoring and weighting of inspections for each individual vertical asset.  

Once all vertical assets are established and organized, EWSU is planning to use Esri’s ArcGIS Field Maps to keep assets updated in the GIS. Field Maps will be useful for the utility to capture asset data in the field and can be used seamlessly with the Cityworks mobile app.

With plans next year to transition from the geometric network to Esri’s new Utility Network, EWSU has set a clear path for meeting its asset management goals. This will ensure the utility continues to provide safe and reliable water and sewer services to its customers for many years to come.

By Logan Guffey, facilities asset manager at Evansville Water and Sewer Utility, and Jessica Stack, senior consultant at POWER Engineers, Inc.

Learn how Trimble Unity Mobile for Cityworks can help support easy and accurate data collection at your organization.