Deploying a data-analytics approach to completing a service line material inventory
The Environmental Protection Agency’s Lead and Copper Rule Revisions require water utilities to complete an inventory of service line materials. This is a complex task requiring a thorough review of a utility’s records and reconciling what’s currently in the ground, all while under a major regulatory deadline. Acting as an extension of JXN Water’s team, we provided an inventory of service line materials to identify possible lead in the water distribution system.
As part of the process of digitizing 20,000 historical records and building out a geographic information system (GIS) from scratch, we’re documenting service line materials as we encounter them on record drawings—for over 400 addresses and 55 public schools. We also built an interim work order system that captures data from multiple contractors performing repair and replacement work throughout the city. To assist with lead service line (LSL) inventory development, we’re working with BlueConduit to input the field data from all ongoing work in Jackson to leverage predictive modeling.
With a long-term system in place, the team can plan for and replace lead service lines as they encounter them. Ultimately, all information will be catalogued in Esri’s AcrGIS LSL Inventory solution (an online database that utilities use to identify lead in their systems) and hosted on JXN Water’s website.
At a Glance
- Offices
- Client
-
- JXN Water
- Partners
-
- BlueConduit
- Ace Pipe Cleaning
Pat Brown, Senior Principal, Senior Project Manager
Working in this industry is akin to being a detective. You have to quickly solve the mystery to restore the services people depend on.
Brendan O'Brien, Project Manager, Water
My passion? I care about the water quality in my community—I like knowing that our work makes a difference, whether large-scale or small.
Meredith Degner, GIS Analyst
My passion? Producing quality data to help our teams and clients make informed decisions—driving positive change and increasing efficiency.
Charles Smith, Senior Construction Manager
I have been in our clients’ position and understand the challenges of water system operation.
Samantha Hensley, GIS Analyst
I am passionate about producing accurate and informed spatial data to empower communities and promote a sustainable and equitable society.
We’re better together
-
Become a client
Partner with us today to change how tomorrow looks. You’re exactly what’s needed to help us make it happen in your community.
-
Design your career
Work with passionate people who are experts in their field. Our teams love what they do and are driven by how their work makes an impact on the communities they serve.