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

Lead Service Line Inventory Symposium�Session 7 – The Other Side of the Meter: Practical Tools for Collecting Private-Side Service Line Material

J. Alan Roberson, P.E.

ASDWA Executive Director

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.

Now available for download on our website:

• ASDWA’s LSL Inventory Framework
• LSL Inventory Template

​

​

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/�

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

SESSION 7 SPEAKERS

• Yigliola Lorang, Minneapolis Public Works

​

• Rob Orthman, Boston Water and Sewer Commission

​

• Brandon Onan, Michigan Department of Environment, Great Lakes, and Energy

​

�Water Treatment and Distribution Services Division ��Lead Service Line Inventory

Yigliola Lorang

GIS Analyst

8

2/23/2022

CITY OF MINNEAPOLIS

Outline

• Water Treatment and Distribution Services Facts
• Water Distribution Network Facts
• Definition of Lead Service Line
• Multi-Year phase approach
• Phase 1 –
• Sources of service line material data
• Historical facts
• Developed assumptions
• Implemented assumptions in the analysis of electronic data
• Validated the analysis by performing manual research
• Phase 2 - Scanning of paper records
• Phase 3 - Publishing lead data
• What’s Next?

9

10

Water Treatment and Distribution Services Facts

Water Distribution Network Facts

• 1,019 Miles of Water Main.
• Water Main buried depth average = 8 ft
• 101,000 Water Service Connections of which 48% are considered Lead.

​

11

Definition of a Lead Service Line

• In Minneapolis, the property owner owns the full water service line from the water main to the meter.
• The service is a lead service line if lead is present in any part of the service line from the tap to the meter.
• This includes the tail piece (brass fitting with one to two feet of lead attached) that was used to connect the original tap to the new copper line prior to 1992.

​

12

Phase 1 – Sources of Service Line Material Data

• Interviewed Public Works Permit Records and Connections office and Water Permits and Connections office.
• Paper sources: Material information of a service lines is listed in following paper records:
• Inspections Books
• Tap Cards (160,000)
• Repair Books
• Repair Cards (300,000)

​

• Identified electronic sources: No material data is available.
• Utility Billing (Enquesta software)
• Enterprise Content Management System (ECMS-Previously scanned Tap Cards records)

13

Phase 1- Historical Facts

• Prior to 1930
• Service lines were composed of lead from the tap (connection at the water main) to the stop box and galvanized pipe from the stop box to the meter.
• Post 1930
• New service lines were made of copper except during the era encompassing World War II.
• 1939 to 1945
• Tube-Loy which is 99.7% lead was used for water service lines during the era encompassing World War II because of the short supply of copper and steel.
• 1889-1954
• Service lines in the proximity of streetcar (trolley) routes were composed of lead in order to protect them from the electrical current generated by the streetcars.
• 1992
• The City Council passed an ordinance prohibiting repairs or reconnections to lead service lines.
•  1992 to Present
• Copper is required to be used or all new and repaired or replaced service lines.

​

​

14

Phase 1 - Assumptions

• Taps Assumed Lead:
• Taps installed prior to 1930 (Tap numbers <= 100145)
• Tube-Loy services installed from 1939 to 1946 (Tap numbers >=107940 and <= 111822)
• Tap Assumed NOT Lead:
• Large Taps (Taps >= 2”)
• Fire Lines
• Fire lines are not used for potable water and were excluded from the analysis unless they were part of a combination line.
• Discontinued Taps
• Discontinued taps were confirmed discontinued and excluded from the analysis because a discontinued lead service will never be reconnected based on City Ordinance.
• Reconnects
• These taps may have been installed before 1930 but they received a newer tap number because a new tap permit was issued to reconnect the taps to a new water main. These taps were taken into account as part of the manual research.

15

Phase 1- Analysis of Electronic Data

16

Enquesta

ECMS

All Tap Records (153,000)

Utility Billing Active Accounts (101,000)

Data combined and cleaned up

(Active Accounts-101,000)

GIS

Data:

PID

Account Number

Status

Tap Number

Address

Meter size

​

Data:

Tap Number

Address

URL

​

EAS

Enterprise Addressing System

Data:

X,Y and Lat, Lon

Parcel Centroid

Applied Assumptions and Performed Queries and Spatial Analysis

​

Water Permits and Connections Staff

Datasets extracted were updated

Datasets extracted for manual research

Phase 1- Analysis of Electronic Data

• Query #1 Records with no match or a discrepancy between the tap number and the address between Enquesta and ECMS datasets.
• Query #2 Queried all tap records prior to December 11, 1,930 with tap number <=100145 to see if there were newer tap numbers. The original record was dropped if a newer record was found unless it represented a reconnect.
• Query #3 Identified tap numbers in ECMS that have been assigned to two different addresses.
• Query #4 Verified that tap numbers between 107640 and 111822 were Tub-Loy.
• Query #5 Extracted taps where the parcels centroids are in proximity to streetcar (trolley) lines.

17

Phase 1 - Trolley Lines

18

Phase 1 - Trolley Lines

19

Phase 1 – Final Count

20

2016-2017

• Gathering of Facts
• Data Analysis based on Assumptions

​

• Initial Lead Service Line Count: 48,308 records

​

​

2017-2020

• 18,917 Manually researched 25% verified to be Lead

​

• Final Lead Service Line Count: 49,306 records

​

Phase 2 – Scanning Records

• Bradford scanning services
• Tap dashboard map and clean up some of the data

21

Phase 3 – Publishing of Data

• Internally: Tap records dashboard map (EAS)

​

​

22

What’s Next?

23

• Public access of data : Property website

​

What’s Next ?

• Water sampling free lead testing program for the public

​

24

Thank you

Contact info:

Yigliola.malca@minneapolismn.gov

612-673-5387

25

Rob Orthman

​

Boston Water and Sewer Commission

Brandon Onan

​

Michigan Department of Environment, Great Lakes, and Energy

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/�