Welcome to the Association of State Drinking Water Administrator’s �Lead Service Line Inventory Symposium�
Lead Service Line Inventory Symposium�Session 5 – Water System Inventory Case Studies
J. Alan Roberson, P.E.
ASDWA Executive Director
HOUSEKEEPING ITEMS
Now available for download on our website:
www.asdwa.org/lead-and-copper-rule-lcr/
SYMPOSIUM OVERVIEW��Morning Webinars�11:00 AM-12:30 PM EST��Afternoon Webinars�3:00 PM-4:30 PM EST��Recordings and slide decks will be available on the event page:�www.asdwa.org/event/lead-service-line-inventory-symposium/�
Wednesday, February 2
Wednesday, February 9
Wednesday, February 16
Wednesday, February 23
Wednesday, March 2
WHAT THIS SYMPOSIUM…
IS
IS NOT
SESSION 5 SPEAKERS
Maureen Schmelling,
DC Water
Greater Cincinnati Water Works�Inventory Building
Jeff Swertfeger
Superintendent
Water Quality and Treatment Division
lead.mygcww.org
Our System
lead.mygcww.org
Our History – Great Records (thanks great great grandpa)
lead.mygcww.org
Enhanced lead program 2016
lead is and who has it.
funded private side lead
removal
lead.mygcww.org
Developing private side inventory
101,808
39,165
Continually updating records
lead.mygcww.org
Customer reporting
lead.mygcww.org
Side benefits of inventory
lead.mygcww.org
Thank you
Jeff Swertfeger
Jeff.Swertfeger@cincinnati-oh.gov
lead.mygcww.org
��LSLI Development�ASDWA LSLI Symposium�February 16, 2022
Date here
Lead Service Lines (LSLs)
Developing the LSL inventory- water quality testing
Why water quality data?
�
Developing the LSL inventory- data review
Data | Use |
Current service line material | Data from the field recorded in customer billing database. |
Previous service line material | Data from the field recorded in customer billing database. |
LCR sites | Service line material from the Lead and Copper Rule sample site materials survey |
Asset historical data | Asset recording historical data of full and partial service line replacements 1962-2014. |
Year built | The year the parcel/property was developed. |
Year tapped | Year the service tap was made on the water main. |
Main install date | Year the water main was constructed (includes abandoned mains). |
Tap size | Tap size. |
Service Line Size | Service line diameters size. Lead was rarely used for >2”. |
Service area | Type of water service contract (wholesale, retail). |
WQ count | Number of lead samples at the tap. |
WQ max | Highest concentration of lead at the tap. |
WQ avg | Average concentration of lead at the tap. |
Tap cut date | Full date of the tap cut/abandonment. |
Developing the LSL inventory- preliminary assumptions
The probability represents the uncertainty in our knowledge of the service line material and is captured as a “p-value” that is assigned based on known construction practices, historical records, expert judgement, and data interpretation.
Public inventory map
Refining the inventory- learning by doing
Developing the LSL inventory- using a predictive model
Predictive Model Testing, Training and Outputs
Model Development
Material Estimates
Observations
Conclusion- Next steps
Thank you.
Lead Service Line Inventory Approach City of New London Connecticut
30
16 February 2022
CITY OF NEW LONDON
CONNECTICUT
Process Description for Inventory Development
31
16 February 2022
1. Review Historical Records
2. Develop and Run Predictive Model (BlueConduit)
3. Identify Inventory Elements and Format
4. Develop Initial Inventory
5. Continuously Update Inventory
Historical Records Review – Useful Data Sources
32
Sources | Description of Use | Availability for New London |
Service valve cards | Paper cards containing information on City-Owned portion of water service lines. | Available |
As-builts | Drawings that record new construction information | In PDF |
Water main records | Water main installation years | Available |
Hydrant records | Hydrant installation years or manufacturer | In process |
Tariffs/ordinances | Tariffs or ordinances that designate non-lead materials | Unavailable |
Billing Data | Billing database records service type and service meter size | Available |
City Parcel Data | Includes parcel information such as home build date and building type | Available |
Real Estate Sales | Real estate transaction records, including transaction value and property details | Available |
Property Construction Permits | Permits can contain service line information | Unavailable |
Historical Service Valve Cards Contain Utility Side Information
33
16 February 2022
Address
Date Laid
Service Size
Service Material
FRONT OF CARD
BACK OF CARD
Service Valve Cards Identified Potential Utility-Owned Lead Lines�
No historical customer-owned service line material records are available
34
16 February 2022
Field Investigations to Verify Customer Service Line Material
35
16 February 2022
Lead/Galvanized
Not Lead
3. Identify Inventory Elements and Format
Best practices for inventory development and data management:
36
Inventory Next Steps
37
16 February 2022
Inventory Next Steps
38
16 February 2022
Run and incorporate predictive model results
Dashboard and public facing inventory in development
Submit initial inventory to CT DPH
Develop and Continuously Update Inventory
39
16 February 2022
SL Inventory
Field Investigations as part of LSLR
Additional Field Investigations (in homes on the same street during LSLR)
Field Data Collected by Utility Staff (i.e., emergency repairs, service line maintenance, etc.)
Customer Identifications
Challenges Associated with Service Line Inventory Development
ASDWA Symposium
February 16, 2022
Tom Barger,
Manager, Water Quality
Regional Water Authority
New Haven, Connecticut
RWA Service Area
C O N N E C T I C U T
NEW
LONDON
Inventory Data Challenges
Suzanne Grendahl, Water Quality Director
Proving a Negative
Water Sustainability through Stewardship, Innovation and People
Water Sustainability through Stewardship, Innovation and People
Phoenix Metro
Water Sustainability through Stewardship, Innovation and People
About Scottsdale
Water Sustainability through Stewardship, Innovation and People
Distribution System Statistics
Water Sustainability through Stewardship, Innovation and People
Public Service Connections
Water Sustainability through Stewardship, Innovation and People
Private Service Connections
Water Sustainability through Stewardship, Innovation and People
Need Guidance from State
Water Sustainability through Stewardship, Innovation and People
Inventory budget and contract
Water Sustainability through Stewardship, Innovation and People
Planned Approach
Water Sustainability through Stewardship, Innovation and People
Mapping of Inventory
Started creation of map using ArcGIS/Esri that shows each service line by parcel reflecting both public and private side.
Water Sustainability through Stewardship, Innovation and People
Future Replacement Program
Water Sustainability through Stewardship, Innovation and People
What if we find a lead line?
Public Side
Private Side
Water Sustainability through Stewardship, Innovation and People
Questions?
Water Sustainability through Stewardship, Innovation and People
Suzanne Grendahl
480-312-8732
sgrendahl@scottsdaleaz.gov
Water Sustainability through Stewardship, Innovation and People
QUESTIONS?
Join us for our next session!��Morning Webinars�11:00 AM-12:30 PM EST��Afternoon Webinars�3:00 PM-4:30 PM EST��Recordings and slide decks will be available on the event page:�www.asdwa.org/event/lead-service-line-inventory-symposium/�
Wednesday, February 2
Wednesday, February 9
Wednesday, February 16
Wednesday, February 23
Wednesday, March 2