A Smarter Approach to Safer Water 

imagesThe City of Chelsea Massachusetts’s second-most densely populated city faced an urgent public health challenge: to identify and replace unknown lead service lines (LSLs) as quickly and efficiently as possible. The harmful effects of lead exposure are well-documented, and communities across the country, especially those with aging infrastructure and environmental justice concerns, are under pressure to act. 

But like many cities, Chelsea didn’t just need cleaner records. They needed a reliable, modern method for identifying where lead lines might be, prioritizing field inspections, and tracking progress as replacements occurred. Their existing records were scattered, incomplete, and lacked the tools to turn raw data into actionable insights.  

Without a clear system for targeting intervention or documenting progress, the city risked falling behind on both public health goals and evolving regulatory requirements. 

OUR APPROACH

From Fragmented Records to Future-Ready Tools

With funding support from the Environmental Policy Innovation Center, (EPIC) the Center for Geospatial Solutions (CGS) partnered with the City of Chelsea to transform legacy service line data into a modern, actionable system one designed to identify likely lead lines, enable efficient field response, and build trust with the public. 

Hands repairing a blue water pipe.

A Clean, Spatially Intelligent LSL Inventory 

Chelsea’s legacy records two separate spreadsheets, including one compiled from digitized paper records were inconsistent and difficult to use. Some of the city’s historical data was also lost in the Great Chelsea Fire, which devastated large portions of the city decades ago.

CGS merged and cleaned the data, then geocoded each service line location, creating a spatially accurate map of LSLs across the city. From there, we worked with local experts to develop a unique methodology for flagging likely lead service lines, allowing city staff to target high-priority areas for inspection and replacement.

Field-Ready Mobile App for Real-Time LSL Replacement

We built a mobile-friendly inspection form using Esri ArcGIS Field Maps, enabling field crews to verify service line materials and log replacement progress on-site. These updates sync in real time with city databases, eliminating manual reporting and improving response coordination. 

A map identifying lead service line statuses in Chelsea, MA.

Public LSL Dashboard for Transparency and Trust

To support Chelsea’s commitment to transparency, CGS developed a public-facing dashboard that allows residents to easily check the status of service lines at their address. The tool chronicles in real-time the city’s progress as replacements are made — building confidence and demonstrating impact. 

Screenshot of a map showing lead service line locations in Chelsea
Data That Matters

Public Health Powered by Better Infrastructure Intelligence

While many cities are still struggling to act on lead free, Chelsea has built a forward-looking system that enables faster intervention, greater transparency, and measurable progress.

assured_workload_24dp_434343_FILL0_wght400_GRAD0_opsz24
Supported State Reporting & Planning

 CGS structured the final dataset to align with MassDEP reporting standards, simplifying compliance and informing future infrastructure investments. 

balance_24dp_434343_FILL0_wght400_GRAD0_opsz24
Advanced Equity & Local Capacity

 By modernizing Chelsea’s infrastructure intelligence, CGS reduced public health risk, expanded local capacity, and provided a replicable path forward for other cities. 

bolt_24dp_434343_FILL0_wght400_GRAD0_opsz24
Delivered in Under 4 Months 

From fragmented records to functional dashboards and field ready mobile apps, Chelsea’s tools were up and running in just a few months, enabling immediate action. 

Quotes

What stood out most was how collaborative the process was. CGS worked with us, step by step, to build a system we understand, trust, and now manage ourselves.

Jorman Mota
Jorman Mota
Assistant City Engineer, Department of Public Works
Quotes

We’re passionate about accelerating access to safe, reliable water through smarter policy and practical solutions. Chelsea now has a clear, actionable view of its lead service lines, enabling faster replacements, efficient contracting oversight, and stronger public trust — setting a compelling example to follow.

Steve Barr
Steve Barr
Senior National Funding Navigator Manager, EPIC

Let's Rise to the Challenge

CGS is a group of passionate problem solvers with a deep understanding of the complex issues facing our world today – and an even deeper enthusiasm for tackling them. This, combined with our belief in the power of technology to improve communities and our planet, guides our work.

Looking for a partner in progress?
We’d love to hear from you.