ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1
THIS COLUMN WILL BE LOCKED BUT NOT HIDDEN
2
Alabama Service Line Inventory Spreadsheet
Service Line Totals
3
Once you have completed this sheet, enter totals on certification form.
4
PWSIDLegendLead0
5
AL0000133MandatoryRecommended
Galvanized Requiring Replacement
0
6
ConditionalOptionalNon-Lead23523
7
V1.3 06/02/2023Lead Status Unknown0
8
9
Location Information
System-Owned Portion (SOP)
Customer-Owned Portion (COP)
Service Line ClassificationOther Potential Sources of LeadAdditional Information to Assign Tap Monitoring TieringLead Service Line Replacement (LSLR)
10
12. Service Line Location345678910. SOP Field Verification Details1112131415161718. COP Field Verification Details1920212223242526272829
11
Unique Service Line IDa. Street Addressb. Cityc. State Abbrev.d. Zipe. Alternate Descriptionf. Latitudeg. LongitudeSensitive Population?Disadvantaged Neighborhood?SOP Service Line (SL) Material ClassificationSOP SL Installation DateSOP SL Size (Diameter)Basis of SOP SL Material ClassificationWas the SOP SL Material Field Verified?a. Field Verification Methodb. Field Verification DateSOP NotesCOP Service Line (SL) Material ClassificationIf Galvanized, Was Upstream Portion of Service Line Previously Lead?COP SL Installation DateCOP SL Size (Diameter)Basis of COP SL Material ClassificationWas the COP SL Material Field Verified?a. COP Field Verification Methodb. COP Field Verification DateCOP NotesEntire Service Line
Material Classification
(Auto Calculated)
Is there a Lead Connector?Is there Lead Solder in the SL?Describe Other Fittings and Equipment Connected to the SL that Contain LeadBuilding Type Connected to SLPoint-of-Entry or Point-of-Use Treatment Present?Does the Interior Building Plumbing Contain Copper Pipes with Lead Solder Installed Before January, 1989? Current LCR Sampling Site?Date of SOP LSLRDate of COP LSLR
12
100251015 ATLANTA AVEANNISTONAL36201Non-Lead - Copper7/16/1987Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
13
1003013 10TH ST W REARANNISTONAL36201Non-Lead - CopperInstallation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
14
1003215 10TH ST WANNISTONAL36201Non-Lead - Copper3/1/1999Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
15
1004013 10TH ST WANNISTONAL36201Non-Lead - Copper2/10/1992Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
16
100601000 NOBLE STANNISTONAL36201Non-Lead - Copper2/20/1998Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
17
100701004 NOBLE STANNISTONAL36201Non-Lead - Copper2/29/1996Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
18
100901006 NOBLE STANNISTONAL36201Non-Lead - Copper2/20/1989Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
19
101301012 NOBLE STANNISTONAL36201Non-Lead - Copper11/24/1999Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
20
101401014 NOBLE STANNISTONAL36201Non-Lead - Copper9/24/1990Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
21
101501016 NOBLE STANNISTONAL36201Non-Lead - Copper5/11/1994Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
22
101601024 NOBLE STANNISTONAL36201Non-Lead - Copper6/3/1997Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
23
101801030 NOBLE STANNISTONAL36201Non-Lead - Copper1/17/1990Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
24
102101028 NOBLE STANNISTONAL36201Non-Lead - Copper1/18/1990Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
25
102201026 NOBLE STANNISTONAL36201Non-Lead - Copper10/1/1999Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
26
102401020 NOBLE ST #AANNISTONAL36201Non-Lead - Copper3/22/1999Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
27
1024410 NOBLE ST #SANNISTONAL36201Non-Lead - Copper4/22/2004Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
28
102501018 NOBLE STANNISTONAL36201Non-Lead - CopperInstallation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
29
102701010 NOBLE STANNISTONAL36201Non-Lead - Copper10/3/1952Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
30
10290920 NOBLE STANNISTONAL36201Non-Lead - Copper10/10/1995Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
31
10310914 NOBLE STANNISTONAL36201Non-Lead - Copper3/22/1996Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
32
103149 NOBLE ST #SANNISTONAL36201Non-Lead - Copper4/22/2004Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
33
10320912 NOBLE STANNISTONAL36201Non-Lead - Copper2/21/1994Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
34
10330910 NOBLE STANNISTONAL36201Non-Lead - Copper8/10/1994Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
35
10340908 NOBLE STANNISTONAL36201Non-Lead - Copper10/16/1998Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
36
10350906 NOBLE STANNISTONAL36201Non-Lead - Copper3/25/1994Installation record (e.g., tap card)Non-Lead - CopperField inspection only with no recordsYesVisual inspection at meter pitNo
37
10370902 NOBLE STANNISTONAL36201Non-Lead - Plastic10/29/1980Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
38
10380900 NOBLE STANNISTONAL36201Non-Lead - Copper10/11/1993Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
39
10390832 NOBLE STANNISTONAL36201Non-Lead - Copper11/1/1991Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
40
1055012 8TH ST WANNISTONAL36201Non-Lead - Copper12/4/1984Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
41
10570730 NOBLE STANNISTONAL36201Non-Lead - Copper12/20/2001Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
42
10610704 NOBLE STANNISTONAL36201Non-Lead - Plastic6/29/1973Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
43
10615700 NOBLE STANNISTONAL36201Non-Lead - Copper38268Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
44
10630129 7TH ST W #AANNISTONAL36201Non-Lead - Other34432Installation record (e.g., tap card)Non-Lead - OtherField inspection only with no recordsYesVisual inspection at meter pitNo
45
10635129 7TH ST WANNISTONAL36201Non-Lead - Copper33640Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
46
10644128 7TH ST WANNISTONAL36201Non-Lead - Copper35304Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
47
10650630 NOBLE STANNISTONAL36201Non-Lead - Copper30622Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
48
10670620 NOBLE STANNISTONAL36201Non-Lead - Copper31784Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
49
10680606 NOBLE STANNISTONAL36201Non-Lead - Copper37725Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
50
10690606 NOBLE ST #SANNISTONAL36201Non-Lead - Copper37740Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
51
1072220 6TH ST WANNISTONAL36201Non-Lead - Copper33588Installation record (e.g., tap card)Non-Lead - CopperField inspection only with no recordsYesVisual inspection at meter pitNo
52
10724524 POWELL STANNISTONAL36201Non-Lead - Copper31252Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
53
10734524 POWELL ST #AANNISTONAL36201Non-Lead - Copper30788Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
54
10736430 POWELL STANNISTONAL36201Non-Lead - Copper31252Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
55
1073915 5TH ST WANNISTONAL36201Non-Lead - Copper30403Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
56
10742530 NOBLE STANNISTONAL36201Non-Lead - Copper35998Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
57
10744508 NOBLE STANNISTONAL36201Non-Lead - Copper34703Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
58
10746500 NOBLE STANNISTONAL36201Non-Lead - CopperInstallation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
59
10790430 NOBLE STANNISTONAL36201Non-Lead - Copper38461Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
60
10800420 NOBLE STANNISTONAL36201Non-Lead - Plastic28131Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
61
10820404 NOBLE STANNISTONAL36201Non-Lead - Copper35444Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
62
1085010 4TH ST WANNISTONAL36201Non-Lead - Copper34723Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
63
10855323 NOBLE STANNISTONAL36201Non-Lead - CopperInstallation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
64
10860330 NOBLE STANNISTONAL36201Non-Lead - Copper33492Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
65
10870325 NOBLE STANNISTONAL36201Non-Lead - Copper30671Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
66
10880331 NOBLE STANNISTONAL36201Non-Lead - Copper26067Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
67
10882401 NOBLE STANNISTONAL36201Non-Lead - Copper36434Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
68
1088418 4TH ST EANNISTONAL36201Non-Lead - Copper26407Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
69
10886412 GRADY AVEANNISTONAL36201Non-Lead - Copper33212Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
70
11010409 NOBLE STANNISTONAL36201Non-Lead - Copper34703Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
71
11020409 NOBLE STANNISTONAL36201Non-Lead - CopperInstallation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
72
11040421 NOBLE STANNISTONAL36201Non-Lead - Copper18665Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
73
11070427 NOBLE STANNISTONAL36201Non-Lead - Copper30502Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
74
11080501 NOBLE STANNISTONAL36201Non-Lead - Copper35625Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
75
11120531 NOBLE STANNISTONAL36201Non-Lead - Copper35269Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
76
11150601 NOBLE STANNISTONAL36201Non-Lead - Copper35760Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
77
11170625 NOBLE STANNISTONAL36201Non-Lead - Copper35087Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
78
11180631 NOBLE STANNISTONAL36201Non-Lead - Copper36013Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
79
1119010 7TH ST EANNISTONAL36201Non-Lead - Copper36452Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
80
11240715 NOBLE STANNISTONAL36201Non-Lead - Plastic28857Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
81
11250725 NOBLE STANNISTONAL36201Non-Lead - Copper35382Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
82
11290801 NOBLE ST #SANNISTONAL36201Non-Lead - Copper32849Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
83
11300801 NOBLE STANNISTONAL36201Non-Lead - Copper32822Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
84
11302801 NOBLE ST #PFANNISTONAL36201Non-Lead - Copper32904Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
85
11306812 NOBLE STANNISTONAL36201Non-Lead - Copper43609Installation record (e.g., tap card)Non-Lead - PlasticField inspection only with no recordsYesVisual inspection at meter pitNo
86
11430911 NOBLE STANNISTONAL36201Non-Lead - Copper35839Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
87
11440909 NOBLE STANNISTONAL36201Non-Lead - Copper31622Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
88
11450905 NOBLE STANNISTONAL36201Non-Lead - Copper34117Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
89
11460903 NOBLE STANNISTONAL36201Non-Lead - Copper36398Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
90
11480901 NOBLE STANNISTONAL36201Non-Lead - Copper35632Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
91
11500913 NOBLE STANNISTONAL36201Non-Lead - Copper36145Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
92
11510915 NOBLE STANNISTONAL36201Non-Lead - Copper36476Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
93
11520917 NOBLE STANNISTONAL36201Non-Lead - Copper34122Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
94
11530919 NOBLE STANNISTONAL36201Non-Lead - Copper36167Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
95
11540919 NOBLE ST #1/2ANNISTONAL36201Non-Lead - CopperInstallation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
96
11550921 NOBLE STANNISTONAL36201Non-Lead - Copper33260Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
97
11560921 NOBLE ST #1/2ANNISTONAL36201Non-Lead - Copper34971Installation record (e.g., tap card)GalvanizedNoField inspection only with no recordsYesVisual inspection at meter pitNo
98
11590931 NOBLE STANNISTONAL36201Non-Lead - Copper34183Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
99
1160015 10TH ST EANNISTONAL36201Non-Lead - Copper32771Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban
100
1161011 10TH ST EANNISTONAL36201Non-Lead - Copper36396Installation date is after the lead banNon-Lead - OtherInstallation date is after the lead ban