Skip to content

Upgrading your lead pipe infrastructure with Trimble Cityworks

7 minutes read
|
January 24, 2024

Share this post:

A close-up of stacked blue pipes with sunlight shining through the center.

Whether it is flipping a lightswitch, turning on a water faucet, or traveling on a road, public infrastructure has a direct impact on our everyday lives. Sustainable and efficient infrastructure has the potential to connect communities, promote health, foster equity, and enrich quality of life on an individual level. In the United States, the reality is that much of the country’s public works are rapidly aging— becoming outdated and, in some cases, unsafe. For years, U.S. infrastructure has been largely underfunded, leaving public works and utility organizations to grapple with the task of maintaining their communities’ aging assets while also staying within budget constraints.

If you are one of many asset managers in the U.S. feeling overburdened by the amount of infrastructural upkeep that needs to be done, you have likely worked day-in and day-out to ensure that your public assets are well maintained to the best of your ability. With new funding opportunities on the horizon, you may also be in luck.

New opportunities on the horizon

This past year, focus on Capitol Hill in Washington, D.C., has shifted toward infrastructure improvement programs. A handful of new bills and packages have been proposed and passed and aim to increase funding for a wide spectrum of infrastructural improvements in the U.S., ranging from water and wastewater to roads and electricity. These bills and packages have the potential to free up billions of dollars of federal funding and create opportunities for local governments and utilities to bring their community services up to date.

Infographic detailing initiatives of the Infrastructure Investment and Jobs Act, including bridges, transit, and broadband.

One issue in particular that is brought up in almost every piece of infrastructure policy is the need to update water infrastructure—namely the inventory, management, and removal of lead piping and service lines.

It is well known that lead is very harmful to human health and poses an extreme safety hazard for communities where they are present. In fact, the Natural Resources Defense Council, an environmental group, estimates that there could be as many as 12.8 million lead services lines in the U.S. that need replacing. It is only a matter of time before cities across the country are required to inventory, inspect, and remove their lead pipes and service lines.

Cities like Flint and Dearborn, Michigan, have already begun their lead abatement process. Here’s how Trimble Cityworks and Esri ArcGIS are helping them inventory, inspect, and remove lead piping and service lines.

Inventory

The first step of planning for any infrastructure project is knowing where your assets are located and which ones need to be upgraded. As Andrew Murray, GISP for DLZ Michigan, Inc. who works on behalf of the City of Flint puts it, “The actual physical execution of replacement is one part of the process, but the documentation portion of lead removal is just as important.” One of the difficulties many cities run into when starting the lead removal process is a lack of information concerning the location of lead service lines. A large portion of water infrastructure in the U.S. was installed long before laws required detailed material and location records.

To fill this data gap, Flint used lead service line inventory data that the University of Michigan-Flint compiled from digitized tap cards and historic parcel records, and then mapped out and visualized in ArcGIS. A similar inventory process has been adopted by the City of Dearborn. In order to comply with state mandates, the city has taken it upon itself to sift through vast amounts of tap card and historic infrastructure data to locate potential lead service lines.

“The whole process for maintaining a digital inventory was new and we had to start from the ground up,” says Eric Roggow, the Trimble Cityworks administrator for the City of Dearborn. “It was a difficult task to undertake. Pipe material data from the time of installation was often unreliable or totally absent and this data hadn’t been recorded digitally.” Dearborn was able to work through this process to organize a preliminary inventory of lead service lines in their community.

Similar to Flint, Dearborn’s inventory data is constantly being updated in ArcGIS as the lead abatement process is being completed. This ensures that a GIS-centric system of record is being created not only for present replacement efforts, but for future maintenance activities. “Our inventory is constantly evolving and getting updated. So when someone goes out to do an inspection, they can see in Trimble Cityworks what material we have previously documented for a particular address,” says Roggow.

Dearborn has also created a way for the community to get involved in the lead abatement and inventory process. The city has set up a survey using Esri's Survey123 and ArcGIS Online that allows residents to report what type of service line materials are used in their homes. Around 300 hundred of these surveys have already been submitted to the city, contributing valuable data to the city’s water infrastructure material inventory.

Inspections

The inventory data in ArcGIS provides a foundation for the inspection process, which consists of in-person assessments by city crews and contractors. At the start of their inspection process, Flint was using a legacy asset management system and paper spreadsheets to keep track of inspection data.

“Everything was disorganized and stored on various hard drives, flash drives, and printed documents,” says Terry Biederman, vice president of DLZ Michigan, Inc. Flint eventually implemented Trimble Cityworks AMS to organize and maintain their inspection and restoration data and workflows. “It was great to have everything in one place where all of our data was standardized, searchable, and easily accessible.”

Inspection work orders were created in Trimble Cityworks AMS and based off of the location information from the inventory GIS data. Contractors performed their inspections, and all observations and data were logged in custom Trimble Cityworks inspection templates. These inspection templates included various data fields where observations were recorded, pictures were taken, and it was determined whether a restoration or replacement was needed.

Service Line Exploration form showing details on pipe type, diameter, depth, and inspector names.

A service line exploration form with custom fields: used by the city of Flint, Michigan

A similar process within Trimble Cityworks and ArcGIS has greatly enhanced Dearborn’s inspection efforts, which was originally done by use of paper spreadsheets and digital cameras. “Trimble Cityworks streamlined the inspection process by helping us organize our inspection data and images and making us more time efficient. We no longer have to constantly update and keep track of various spreadsheets,” says Roggow.

The City of Dearborn now uses Trimble Cityworks and ArcGIS in both field and office settings to assist with data collection and organization in the inventory, inspection, and abatement process. Dearborn currently collects service line material data in the course of their water main replacement projects. Inspectors are sent out to conduct an inventory of pipes and service lines in the area where a water main replacement is taking place. For areas where water mains were already replaced, inspections are also conducted and recorded in Trimble Cityworks.

Replacement

Once the inventory and inspections were complete, Flint used Trimble Cityworks to transfer lead pipe replacement work to contractors by creating a restoration work order. This ensured that the full lead removal process was smooth and fostered communication between city crews and contractors. Through this process and the use of Trimble Cityworks and ArcGIS, Flint was able to update their water infrastructure and ensure the safety of their community by fulfilling approximately 8,900 inspection and replacement work orders over the course of nine months.

In the City of Dearborn, lead lines identified during water main replacement projects are removed and replaced with copper lines by contractors. Other replacement projects, completed by city crews, are fully managed in Trimble Cityworks. When lead is discovered during the inspection process, a child work order is created in Trimble Cityworks to kick off the service line replacement project. City crews document equipment, labor, and material in Trimble Cityworks in order to keep track of the full abatement process.

Service Line Replacement custom fields form, with many fields set to No.

A service line replacement work order with custom fields; used by the city of Dearborn, Michigan.

After lead service lines are replaced, water quality sampling is documented in Trimble Cityworks. This ensures the ongoing health and safety of the community.

Dearborn also uses the GIS information and Trimble Cityworks data to create reports for the Michigan Department of Environment, Great Lakes, and Energy (EGLE). This allows the city to share with the State of Michigan the efforts that they have put into the lead abatement process and comply with state mandates.

“We are required to replace all lead in the city within the next 20 years,” says Roggow. However, Roggow is confident in the city’s lead removal program and the tools that they have adopted. “We have good plans in place to make sure we accomplish that before the deadline.”

Looking Ahead

With an increased focus on infrastructure revitalization in the U.S., it is likely that many local government and utility organizations will be following in the footsteps of Flint and Dearborn by setting up their own lead abatement programs. Trimble Cityworks can not only help you organize, manage, and maintain your infrastructure throughout its entire lifecycle, it can also help you plan and execute public works projects, such as removing lead from your water system. The main goal of infrastructure investment and projects is to ensure that public assets are safe, sustainable, efficient, and foster equity for years to come.

Related articles

Article

Chicago Rockford International Airport Simplifies Part 139 Compliance and Streamlines Operations

Modernizing asset management has given Chicago Rockford International Airport the data visibility to...
Read full article
Article

3 ways to enhance infrastructure management with Nearmap and Trimble Cityworks

Using Nearmap in conjunction with Trimble Cityworks and Esri ArcGIS offers a highly scalable and eff...
Read full article
Article

5 applications for 3D GIS in local government and utilities

3D data will play a significant role in the digital transformation of local government, utility, and...
Read full article
Attention

We tried to combine the products in your guest cart with your saved cart, but we encountered an issue while merging them. When choosing a subscription, please select either monthly or yearly as they cannot be combined. Kindly review your cart before proceeding to checkout.

Cart updated
Some items in your cart are not available for purchase in your region, so we removed them. Please review your cart before proceeding.

Items Removed:
Attention

The software you are trying to purchase is not available in your country or region.

Cart updated
The items in your cart have been updated for two reasons. Firstly, the prices now match the currency linked to your account address. Secondly, some items have been removed because they are not available for purchase in your region. Please review your cart before proceeding.

Items Removed:
Cart updated
The items in your cart have been updated for two reasons. Firstly, you've added too many of one item to your cart. Secondly, some items have been removed because they are not available for purchase in your region. Please review your cart before proceeding.

Items Removed:
Cart updated
The items in your cart have been updated for three reasons. Firstly, the prices now match the currency linked to your account address. Secondly, you've added too many of one item to your cart. Thirdly, some items have been removed because they are not available for purchase in your region. Please review your cart before proceeding

Items Removed:
Cart updated

Your currency has been changed to match the currency associated with your account address.

Cart updated

Your cart has been updated for two reasons. First, the prices now reflect the currency associated with your account address. Second, you've added too many of one item to your cart. Please review your cart before proceeding.

Cart updated

While combining the products in your guest cart with your saved cart, at least one item in your cart has exceeded the maximum allowable quantity. Please review and correct your cart before proceeding to checkout.

Attention

We were unable to access your account information. Please contact customer support for assistance.

Attention
Unable to update shopping cart information. Please refresh the page to resolve the issue. If this issue persists, please contact Trimble support.
© 2026 Trimble Inc.

Trimble is a global technology company that connects the physical and digital worlds, transforming the ways work gets done. With relentless innovation in precise positioning, modeling and data analytics, Trimble enables essential industries including construction, geospatial and transportation. Whether it's helping customers build and maintain infrastructure, design and construct buildings, optimize global supply chains or map the world, Trimble is at the forefront, driving productivity and progress.