1 of 58

Welcome to the Association of State Drinking Water Administrator’s �Lead Service Line Inventory Symposium�

2 of 58

Lead Service Line Inventory Symposium�Session 5 – Water System Inventory Case Studies

J. Alan Roberson, P.E.

ASDWA Executive Director

3 of 58

HOUSEKEEPING ITEMS

  • Please note that ASDWA is unable to offer CEUs or completion certificates for this symposium.
  • ASDWA will not be able to provide technical support for GoToWebinar during the session. If you have issues with a lagging video or sound, please check your broadband connection. We recommend closing all other applications to maximize your bandwidth.
  • All sessions will be recorded and will be available later on ASDWA’s website should you have connection issues or if you miss a session.
  • Each session will include at least 30 minutes for question and answers, so please type your questions into the chat box and we will bring those up in the discussion portion.

4 of 58

Now available for download on our website:

  • ASDWA’s LSL Inventory Framework
  • LSL Inventory Template

www.asdwa.org/lead-and-copper-rule-lcr/

5 of 58

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/

    • Session 1: Overview of LCRR 
    • Session 2: Notes from the Field: State and Utility Experiences with Existing LSL Inventory Rules

Wednesday, February 2

    • Session 3: Capitalizing in Innovations for LSL Inventories
    • Session 4: Small Systems, Big Challenges: Implementing LSL Inventories and Replacements at Small Systems 

Wednesday, February 9

    • Session 5: Water System Inventory Case Studies
    • Session 6: Show Me the Money: Funding for LSL Inventories and Replacement

Wednesday, February 16

    • Session 7: The Other Side of the Meter: Practical Tools for Collecting Private-Side Service Line Material
    • Session 8: Tell Me About It: Mapping and Communicating your LSL Inventory and Replacements

Wednesday, February 23

    • States-only debrief (3:00-4:30 EST)

Wednesday, March 2

6 of 58

WHAT THIS SYMPOSIUM…

IS

  • A starting point for the drinking water community to begin developing inventories
  • An introduction to adaptive management
  • Shared experiences from states and water systems
  • Discover opportunities to further the discussion on inventories

IS NOT

  • About EPA’s inventory guidance
  • The final word on inventories or specific inventory requirements
    • Questions will remain for how states should/will implement rule
  • A forum for answering every possible question about inventories
    • Not planning to develop a set of FAQS
    • Not planning to answer state-specific questions
  • A forum to debate LCRR or LCRI

7 of 58

SESSION 5 SPEAKERS

  • Maureen Schmelling, DC Water
  • Jeff Swertfeger, Greater Cincinnati Water Works
  • Alexis Woodrow, Denver Water
  • Joseph Lanzafame, New London Department of Public Utilities
  • Tom Barger, South Central Connecticut Regional Water Authority
  • Suzanne Grendahl, Scottsdale Water

8 of 58

Maureen Schmelling,

DC Water

9 of 58

Greater Cincinnati Water Works�Inventory Building

Jeff Swertfeger

Superintendent

Water Quality and Treatment Division

lead.mygcww.org

10 of 58

Our System

  • 1.1 Million population, 2 states
  • Approx 240,000 service lines
  • 39,165 Lead lines
    • 100 on public side only
    • 13,085 full lead lines
    • 25,980 private side only

lead.mygcww.org

11 of 58

Our History – Great Records (thanks great great grandpa)

  • 1837 – First numbered service branch
  • 1927 - Branch #101808 – Last lead branch installed
  • 1970 – Started organized main replacement program
  • 1992 – LCR began focus on lead inventory and removal
  • 2000 – Big program to put branch material into GIS
  • 2016 – Enhanced Lead Program – private side info needed in GIS

lead.mygcww.org

12 of 58

Enhanced lead program 2016

  • Specific focus on public communication and lead removal
  • Needed great records of both sides to truly engage community
  • Needed to point out where

lead is and who has it.

  • Encouraged and partially

funded private side lead

removal

lead.mygcww.org

13 of 58

Developing private side inventory

  • Build on good public side inventory
  • Assume all private branches lead before #101808 (1927)
  • Unless had records saying otherwise - conservative
    • Active branches
    • >2 inches
    • Water main replacement reports (what did we couple to)
    • Work orders showing private side replaced when we did our side
    • Inspected private side replacement
  • Took about 2 months of 4 people working Saturdays and focused time weekdays to review records in 2016

101,808

39,165

14 of 58

Continually updating records

  • A lot of focus on identifying private side
  • Main replacement
  • Our other field work
  • Line replacements
  • Customer self identification
  • Future meter replacements

lead.mygcww.org

15 of 58

Customer reporting

  • Verify in house and pothole if doesn’t match records

lead.mygcww.org

16 of 58

Side benefits of inventory

  • Notified customers by letter
  • Lookup map
  • Talk to our customers
  • Coordinate with public health efforts
  • Notify customers of disruptions
  • Provide filters to protect health
  • More accurate main replacement bids
  • Prepared to immediately use infrastructure money

lead.mygcww.org

17 of 58

Thank you

Jeff Swertfeger

Jeff.Swertfeger@cincinnati-oh.gov

lead.mygcww.org

18 of 58

��LSLI Development�ASDWA LSLI Symposium�February 16, 2022

Date here

19 of 58

Lead Service Lines (LSLs)

  • In Denver Water’s service area, the entire service line is owned by the property owner
  • Lead pipe was commonly used until 1951, banned altogether in 1971
  • Estimate between 63,000-82,000 lead service lines

20 of 58

Developing the LSL inventory- water quality testing

  • Offer free testing to all customers since May 2016
  • Kits shipped to customer address and include:
    • 3 1-L bottles
    • Instructions
    • Bags
    • COC card

21 of 58

Why water quality data?

22 of 58

Developing the LSL inventory- data review

  • Multiple data sources
    • Customer records
    • Water quality data
  • Multiple parameters
    • Year build
    • Tap date
    • Main install date

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.

23 of 58

Developing the LSL inventory- preliminary assumptions

  • Logic rules applied to sort service lines into 5 categories:
      • Known LSL – 100% direct evidence documenting lead.
      • Suspected LSL – 80% or higher likelihood of lead, based upon available data (i.e., homes built prior to 1951).
      • Possible LSL – 50% or higher likelihood of lead, as some data may be conflicting or missing but there is not enough information to confirm a non-lead service line.
      • Unlikely LSL – <10% very low likelihood of lead.
      • Non-lead – 100% direct evidence or statistically defensible factors supporting categorization as a non-lead service line

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.

24 of 58

Public inventory map

25 of 58

Refining the inventory- learning by doing

26 of 58

Developing the LSL inventory- using a predictive model

  • A tool that looks for patterns in the data to predict material designations (non-lead or lead).
  • Statistically driven. 
  • The purpose is to refine the inventory and prioritize replacements.
  • Emphasizes learning and prioritizing around equity and replacing lead for vulnerable populations.
  • The predictive model alone is not used to change existing probability values in the inventory.

27 of 58

Predictive Model Testing, Training and Outputs

Model Development

    • Training and validation of discrete data to generate predictions.
    • As of January 2022, used 16,000 data points for learning.

Material Estimates

  • Provides a different perspective on lead in the system than the inventory.
    • Provides increased granularity on the likelihood of finding lead.
    • Uses a continuous feedback loop based on learning from the field.

Observations

  • Lead and non-lead estimates align with the inventory.
  • Investigations focus to refine the remaining service lines.
  • Predictive model assists in identifying the true location of these services.

28 of 58

Conclusion- Next steps

  • Model is continuously updated with field data.
  • Supports the long-term maintenance of the inventory.
  • Helps to target investigations.
  • Supports replacement activities and prioritization to serve disproportionately impacted communities.

29 of 58

Thank you.

30 of 58

Lead Service Line Inventory Approach City of New London Connecticut

30

16 February 2022

CITY OF NEW LONDON

CONNECTICUT

31 of 58

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

32 of 58

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

33 of 58

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

34 of 58

Service Valve Cards Identified Potential Utility-Owned Lead Lines�

No historical customer-owned service line material records are available

34

16 February 2022

35 of 58

Field Investigations to Verify Customer Service Line Material

35

16 February 2022

  • Physical inspection conducted at 150 sites of unknown material
    • 26 Confirmed Lead (17%)
    • 1 Confirmed Galvanized
    • Challenges
    • 21% Resident Resistance to Testing
      • 3% Covid Concerns
      • 11% Uncomfortable with In Home Testing
      • 6% Renters requiring Landlord Permission
      • 2% Meters not accessible

Lead/Galvanized

Not Lead

36 of 58

3. Identify Inventory Elements and Format

Best practices for inventory development and data management:

  • Reduce duplicate information (i.e., store asset information in GIS and customer account information, like address, in billing system)
  • Use a unique identifier to tie data together
  • Track the utility and customer side of service line separately (separate assets)
  • Limit the amount text fields in GIS/databases (numerical values preferred)
  • Include and document all available sources by adding a source value
  • Maintain historical data (original/previous material and size), preferably in a separate source/file
  • Develop a dashboard or database to maintain current information from all available sources

36

37 of 58

Inventory Next Steps

37

16 February 2022

38 of 58

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

39 of 58

Develop and Continuously Update Inventory

  • Inventory is not static
  • Use dashboard or database to ‘query’ results in near real time and perform QC checks

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

40 of 58

Challenges Associated with Service Line Inventory Development

ASDWA Symposium

February 16, 2022

Tom Barger,

Manager, Water Quality

Regional Water Authority

New Haven, Connecticut

41 of 58

RWA Service Area

C O N N E C T I C U T

NEW

LONDON

42 of 58

Inventory Data Challenges

    • Lead Service Lines – Expanding Definition
    • Inconsistency of Data from Multiple Sources
    • Interpretation of Data Lingo/Abbreviations
    • What percentage of missing/available information is acceptable to you and your regulator to provide a level of confidence ?
    • Use existing infrastructure
    • Available Time – Value of Time

43 of 58

Suzanne Grendahl, Water Quality Director

Proving a Negative

Water Sustainability through Stewardship, Innovation and People

Water Sustainability through Stewardship, Innovation and People

44 of 58

Phoenix Metro

  • Scottsdale is located in the Phoenix metro area,is the 7th largest city in Arizona and is located within the Sonoran Desert.

  • Typical annual temperatures range from 45-107°, with extremes as low as 32° and as high as 122°. In 2020 we had 53 days over 110°

Water Sustainability through Stewardship, Innovation and People

45 of 58

  • Incorporated in 1951, Population 2,000
  • Scottsdale Water was established in 1971 involving the eventual purchase of over 15 private water companies and the portion of Phoenix system within Scottsdale
  • Population in 2021: ~245,000
  • 184.5 square miles
  • 31 miles long
  • Elevation change 3,727 feet
  • 2021 average water delivery: 69 million gallons/day

About Scottsdale

Water Sustainability through Stewardship, Innovation and People

46 of 58

Distribution System Statistics

  • Miles of main lines: 2,144
  • Service Connections: ~93,500
    • 83,000 Single-family residential
    • 4,500 Multifamily residential
    • 6,000 Commercial, nonresidential
  • 18 major pressure zones
  • Two surface water sources, approximately 20 groundwater wells, most of which are treated/blended for arsenic mitigation or part of a federal
  • 8 EPDSs

Water Sustainability through Stewardship, Innovation and People

47 of 58

Public Service Connections

  • Water meter located at property line in meter vault
  • Historically have never uncovered any lead lines.
  • Known Materials
    • Copper - 89%
    • Plastic – 6%
    • Galvanized/unknown – 5%
  • Proactive galvanized replacement program over last 25 years
    • Replaced over 3,500 lines

Water Sustainability through Stewardship, Innovation and People

48 of 58

Private Service Connections

  • Do not expect to find any lead lines
    • City is young
    • Never found any lead on public side of meter.
  • 93,500 Unknowns
    • ~45,000 built prior to 1987
      • Over 3,500 “galvanized needing replacement”
        • Insufficient record keeping with galvanized replacement program. Cannot prove material other than staff historical knowledge

Water Sustainability through Stewardship, Innovation and People

49 of 58

Need Guidance from State

  • Can we limit inventory to only services prior to 1988?
  • Visual inspection at meter box on public and private side, as well as building hose bib?
  • Photos required?
  • Is assurance from multiple long- term staff, that lines replaced under galvanized replacement program were not lead, enough to classify those replaced lines as non-lead?

Water Sustainability through Stewardship, Innovation and People

50 of 58

Inventory budget and contract

  • Requesting significant funding in capital budget to hire contractor to perform material inventory
  • Adding FTE to coordinate all LCRR requirements

Water Sustainability through Stewardship, Innovation and People

51 of 58

Planned Approach

  • Start with unknowns on public side
  • Move on to properties starting oldest to newest
  • Plan to do visual inspection at meter box on public and private side, as well as building hose bib?
  • Hope to have definitive guidance from state before we get to homes built after 1987-1988 timeframe. Hope physical inventory will not be necessary.
  • If we find any lines that are not obvious, will do further investigation

Water Sustainability through Stewardship, Innovation and People

52 of 58

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

53 of 58

Future Replacement Program

  • Do not expect to find, therefore replace, any lead lines
  • Will continue galvanized program until all public services are replaced.
  • Depending on state guidance, may have “galvanized needing replacement” lines on private side
    • Hope to be able to fund some/all of these replacements but need to complete survey first and determine a timeline.

Water Sustainability through Stewardship, Innovation and People

54 of 58

What if we find a lead line?

Public Side

  • Funds can be made available and/or budgeted for replacement
  • Coordinate with property owner for “immediate” replacement of both sides of meter.
    • Timeframe would be dependent on number identified.

Private Side

  • Current discussions have centered around a rebate program or covering full cost.
  • Restriction on uses of public funds – “gift” clause
  • Private property rights issues – will need access/permission agreement with property owner.
  • Need to identify qualified plumber to do work
  • May need to consider incentives to encourage replacements if resistance is met

Water Sustainability through Stewardship, Innovation and People

55 of 58

Questions?

Water Sustainability through Stewardship, Innovation and People

56 of 58

Suzanne Grendahl

480-312-8732

sgrendahl@scottsdaleaz.gov

Water Sustainability through Stewardship, Innovation and People

57 of 58

QUESTIONS?

58 of 58

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/

    • Session 1: Overview of LCRR 
    • Session 2: Notes from the Field: State and Utility Experiences with Existing LSL Inventory Rules

Wednesday, February 2

    • Session 3: Capitalizing in Innovations for LSL Inventories
    • Session 4: Small Systems, Big Challenges: Implementing LSL Inventories and Replacements at Small Systems 

Wednesday, February 9

    • Session 5: Water System Inventory Case Studies
    • Session 6: Show Me the Money: Funding for LSL Inventories and Replacement

Wednesday, February 16

    • Session 7: The Other Side of the Meter: Practical Tools for Collecting Private-Side Service Line Material
    • Session 8: Tell Me About It: Mapping and Communicating your LSL Inventory and Replacements

Wednesday, February 23

    • States-only debrief (3:00-4:30 EST)

Wednesday, March 2