ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
1
2
Detailed InventoryImportant Instructions: Each row in this worksheet represents one service line connecting the water main to the customer's plumbing. The worksheet includes required and recommended elements; the columns with the aqua shading are required by the LCRR. The green column is a required, auto populated field that will update as systems provide system-owned and customer-owned service line material classification information. Column H is used in the green column calculation to determine if the customer-owned portion of the service line is galvanized requiring replacement. If column H is blank and the customer-owned portion is galvanized, the entire line will be classified as galvanized requiring replacement. Important notes for each column are in Row 13; also see the Template Instructions worksheet for detailed instructions. Remove provided examples before submitting your completed inventory.
3
PWS Name: Town of Murfreesboro
4
PWSID: NC0446015
5
Date Last Updated:
6
4/17/2024
7
8
Purpose of this worksheet: To allow water systems to track materials for each service line in their distribution system.
9
10
Location InformationSystem-Owned PortionCustomer-Owned PortionEntire Service Line
Material Classification		Other Potential Sources of LeadAdditional Information to Assign Tap Monitoring TieringLead Service Line Replacement (LSLR)
11
Unique Service Line IDLocation Identifier Sensitive Population? (Yes/No)Disadvantaged Neighborhood? (Yes/No)System-Owned Portion
Service Line Material Classification 		If Non-Lead in Column G,
Was Material Ever Previously Lead?		Service Line Installation DateService Line SizeBasis of Material ClassificationWas the Service Line Material Field Verified?If "Yes" Service Line Material Was Field Verified:NotesCustomer-Owned Portion
Service Line Material Classification		Service Line Installation DateService Line SizeBasis of Material ClassificationWas the Service Line Material Field Verified?If "Yes" Service Line Material Was Field Verified:NotesIs there a Lead Connector?Is there Lead Solder in the Service Line?Describe Other Fittings and Equipment Connected to the Service Line that Contain LeadBuilding Type Connected to Service LinePoint-of-Entry or Point-of-Use Treatment Present?Does the Interior Building Plumbing Contain Copper Pipes with Lead Solder Installed Before Your State's Lead Ban (Generally 1986 - 1988)? Current LCR Sampling Site?Date of System-owned LSLRDate of Customer-owned LSLR
12
Street AddressOther Location IdentifierDescribe the Field Verification MethodEnter the Date of Field VerificationDescribe the Field Verification MethodEnter the Date of Field Verification
13
A Unique ID is recommended for each service line.Water systems must track addresses of all service lines in their internal inventory. For the publicly accessible version, location identifiers are required for lead and galvanized requiring replacement. If the system does not use addresses for their location identifier, other options could include GPS coordinates, landmark, intersection, block, or other details to specify service line locations.Select Yes if sensitive subpopulation, e.g., day care, school, multifamily home. If Yes-Other, describe in the Notes field.Does location meet state affordability guidelines or other measures?Drop-down list includes recommended subclassifications. If "Non-Lead Other", describe in Notes fieldSelect Yes, No, or Don't know.
Used to determine if service line is galvanized requiring replacement.		Date, year, or estimated date range when the service line was installed or replacedDiameter in inchesSelect option from drop down list. If "Other," describe in the Notes fieldSelect Yes or NoSelect option from drop down list. If "Other," describe in the Notes fieldEnter approximate date of field verification or date that the record was updatedCan use this field for documenting additional relevant information, including when classification changes.Drop-down list includes recommended subclassifications. If non-lead other, describe in Notes field.Date, year, or estimated date range when the service line was installed or replacedDiameter in inchesSelect option from drop down list. If "Other," describe in the Notes fieldSelect Yes or NoSelect option from drop down list. If "Other," describe in the Notes fieldEnter approximate date of field verification or date that record was updatedCan use this field for documenting additional relevant information, including when classification changes.Auto-filled list includes four required service line classifications of Lead, Non-lead, Galvanized Requiring Replacement, or UnknownFor example, lead gooseneck or pigtail where the water main is connected to the service lineSelect Yes, No, or Don't KnowFor example, backflow preventer or meter containing leadNote: This information may be helpful for identifying lead tap monitoring locations.
14
M001200 W MAIN STUnknown - Lead Status UnknownNoUnknown - Material Unknown Non-Lead
15
M002304 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
16
M003308 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
17
M004314 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
18
M005320 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
19
M006324 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
20
M007414 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
21
M008420 W MAIN STUnknown - Unlikely LeadNoUnknown - Unlikely LeadBUILT 2004Unknown
22
M009422 W MAIN ST SPRINKLERUnknown - Material UnknownNoUnknown - Material UnknownUnknown
23
M010506 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
24
M011606 W MAIN STUnknown - Unlikely LeadNoUnknown - Unlikely LeadBUILT 2015Unknown
25
M012616 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
26
M013618 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
27
M014624 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
28
M015103 LAWRENCE STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
29
M016626 W MAIN STUnknown - Unlikely LeadNoInstallation date after lead banUnknown - Unlikely LeadInstallation date after lead banNoBUILT 2018Unknown
30
M017107 LAWRENCE STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
31
M018111 LAWRENCE STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
32
M019200 LAWRENCE STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
33
M020204 LAWRENCE STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
34
M021206 LAWRENCE STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
35
M022207 LAWRENCE STNon-Lead - CopperNoField inspection only with no recordsYesVisual inspection at the meter pitGalvanizedField inspection only with no recordsYesVisual inspection at the meter pitNon-Lead
36
M023210 LAWRENCE STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
37
M024211 LAWRENCE STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
38
M025621 W BROAD STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
39
M026619 W BROAD STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
40
M027617 W BROAD STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
41
M028522 W BROAD STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
42
M029902 W MAIN STUnknown - Unlikely LeadNoInstallation date after lead banNoUnknown - Unlikely LeadInstallation date after lead banNoBUILT 2001Unknown
43
M030904 W MAIN ST Unknown - Material UnknownNoUnknown - Material UnknownUnknown
44
M031908-B W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
45
M032912 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
46
M033914 W MAIN STUnknown - Unlikely LeadNoInstallation date after lead banNoUnknown - Unlikely LeadInstallation date after lead banNoBUILT 1998Unknown
47
M034924 W MAIN STUnknown - Unlikely LeadNoInstallation date after lead banNoUnknown - Unlikely LeadInstallation date after lead banNoBUILT 1992Unknown
48
M035913 W MAIN ST HWY 158-258Unknown - Unlikely LeadNoInstallation date after lead banNoUnknown - Unlikely LeadInstallation date after lead banNoBUILT 1999Unknown
49
M036922 W MAIN ST SUITE BUnknown - Unlikely LeadNoInstallation date after lead banNoUnknown - Unlikely LeadInstallation date after lead banNoBUILT 1992Unknown
50
M037920 W MAIN STUnknown - Unlikely LeadNoInstallation date after lead banNoUnknown - Unlikely LeadInstallation date after lead banNoBUILT 1992Unknown
51
M038918 W MAIN STUnknown - Unlikely LeadNoInstallation date after lead banNoUnknown - Unlikely LeadInstallation date after lead banNoBUILT 1993Unknown
52
M039857 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
53
M040855 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
54
M041851 W MAIN ST SUITE CUnknown - Material UnknownNoUnknown - Material UnknownUnknown
55
M042849 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
56
M043915 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
57
M044847 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
58
M045845 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
59
M046843 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
60
M047841 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
61
M048841 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
62
M049837 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
63
M050831 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
64
M051415 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
65
M052625 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
66
M053319 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
67
M054311 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
68
M055305 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
69
M056107 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
70
M057105 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
71
M058101 W MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
72
M059116 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
73
M060212 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
74
M061402 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
75
M062408-B E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
76
M063408-A E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
77
M064502 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
78
M065504 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
79
M066604 E MAIN STUnknown - Unlikely LeadNoInstallation date after lead banNoUnknown - Unlikely LeadInstallation date after lead banNoBUILT 1992Unknown
80
M067608 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
81
M068106 N SECOND STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
82
M069108 N SECOND STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
83
M070703 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
84
M071611 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
85
M072609 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
86
M073601 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
87
M074505 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
88
M075503 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
89
M076407 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
90
M077401 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
91
M078349 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
92
M079345 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
93
M080343 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
94
M081339 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
95
M082337 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
96
M083222 WILLIAMS STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
97
M084331 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
98
M085329 E MAIN STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
99
M086115 WILLIAMS STUnknown - Material UnknownNoUnknown - Material UnknownUnknown
100
M087105 & 107 WILLIAM STUnknown - Material UnknownNoUnknown - Material UnknownUnknown