| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | * | |||||||||||||||||
2 | Lead Service Line Inventory Template | |||||||||||||||||
3 | *Please enter information in the empty box next to each section | Water System Name | Marseilles | System ID Number: | PWS IL0990500 | Current Inventory Date: | 4/9/2026 | |||||||||||
4 | *Please enter totals in the empty box next to each category | Total Service lines: | 2027 | Total Lead: | 56 | Total Non-Lead: | 1275 | Total Galvanized Requiring replacement: | 0 | Total Unknown: | 696 | Website Link To Material Inventory | https://docs.google.com/spreadsheets/d/1FLc02hk4hOmMraMKFg5SExdjBDBHR-ge/edit?usp=sharing&ouid=113128191771040231822&rtpof=true&sd=true | |||||
5 | ||||||||||||||||||
6 | ||||||||||||||||||
7 | Service Address | Lead and Copper Sample site number. | Is this a high-risk Facility or Area? | Service Line Newly Identified Since Last Submitted Inventory | Year PWS-Owned Service Line was Installed | Year Customer Side Service Line was Installed | Source of Information Used for Service Line Identification | Gooseneck/ Pigtail | PWS-Owned Service Line Material | Customer Side Service Line Material | Classification for Entire Serivice Line | Was Galvanized Service Line Material ever downstream of Lead? | Date Customer Notified of Lead Service Line | Was a Lead Service Line Previously Replaced at this Location? | Date Lead Service Line Replaced | Material of Service Line Replacement | Has the customer refused access to the property? | Date of customer waiver or IDPH notification, if customer refused access to property |
8 | Lead and Copper Sample site number is the 7 digit number starting with "LP" or " LA". / If address is not a lead and copper sample site mark "N/A" | EXAMPLES: | Yes (Y) or No (N) | What year was the PWS-Owned service line installed, if known? | What year was the customer side service line installed, if known? | How was the Material of this Service Line Identified? EXAMPLES: Construction Records, Visual Inspections, Survey Response, Maintenance Records, etc... | EXAMPLES: | EXAMPLES: | EXAMPLES: | EXAMPLES: | If any galvanized service line material was ever downstream of a Lead section, mark Yes (Y). If the galvanized service line material was never downstream of any Lead section, mark No (N). / If Yes, that section of service line should be marked as Galvanized Requiring Replacement in the appropriate immediately preceding column(s). | Enter date customer was notified of Lead Service Line. / If Service Line is not Lead put N/R | Yes (Y) or No (N) | If previous column was marked (Y), provide date the Lead Service Line was replaced. / Leave blank if previous column was (N). | EXAMPLES: | Yes (Y) or No (N) | IF customer refused access to property, date waiver obtained by PWS or date PWS notified IDPH of refusal to sign waiver. / Leave blank if customer has not refused access. | |
9 | Group Homes, Parks, Playgrounds, Special Care Facilities, Hospitals, Clinics, Child Care Facilities | Copper - No Lead Solder (C) | Copper - No Lead Solder (C) | Copper - No Lead Solder (C) | Lead (L) | Copper - No Lead Solder (C) | ||||||||||||
10 | Copper - Lead Solder (CLS) | Copper - Lead Solder (CLS) | Copper - Lead Solder (CLS) | Galvanized Requiring Replacemnt (GRR) | ||||||||||||||
11 | Galvanized (G) | Galvanized (G) | Galvanized (G) | Unknown (U) | Galvanized (G) | |||||||||||||
12 | Lead (L) | Galvanized Requiring Replacemnt (GRR) | Galvanized Requiring Replacemnt (GRR) | Non-Lead (NL) | Plastic - PVC, HDPE, PEX (P) | |||||||||||||
13 | Cast/Ductile Iron or Transite (O) | Lead (L) | Lead (L) | Cast/Ductile Iron or Transite (O) | ||||||||||||||
14 | Yes (Y) or No (N) | Plastic - PVC, HDPE, PEX (P) | Cast/Ductile Iron or Transite (O) | Cast/Ductile Iron or Transite (O) | Leave blank if no Lead Service Line was replaced. | |||||||||||||
15 | Unknown (U) | Plastic - PVC, HDPE, PEX (P) | Plastic - PVC, HDPE, PEX (P) | |||||||||||||||
16 | Unknown Not Lead (UNL) | Unknown (U) | Unknown (U) | |||||||||||||||
17 | Unknown Not Lead (UNL) | Unknown Not Lead (UNL) | ||||||||||||||||
18 | 100 East Bluff Street, Marseilles, IL 61341 | N/A | N | Y | Unknown | Unknown | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
19 | 100 Lions Drive, Marseilles, IL 61341 | N/A | N | Y | Unknown | Unknown | Visual Inspection/ Construction Records | C | C | P | NL | N | N/R | N | N | |||
20 | 100 Washington Street, Marseilles, IL 61341 | N/A | N | Y | Unknown | Unknown | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
21 | 100 Woodview Lane, Marseilles, IL 61341 | N/A | N | Y | 2005 | 2005 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
22 | 1000 Bratton Avenue, Apt 1, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
23 | 1000 Bratton Avenue, Apt 10, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
24 | 1000 Bratton Avenue, Apt 11, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
25 | 1000 Bratton Avenue, Apt 12, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
26 | 1000 Bratton Avenue, Apt 13, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
27 | 1000 Bratton Avenue, Apt 14, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
28 | 1000 Bratton Avenue, Apt 15, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
29 | 1000 Bratton Avenue, Apt 16, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
30 | 1000 Bratton Avenue, Apt 2, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
31 | 1000 Bratton Avenue, Apt 3, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
32 | 1000 Bratton Avenue, Apt 4, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
33 | 1000 Bratton Avenue, Apt 5, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
34 | 1000 Bratton Avenue, Apt 6, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
35 | 1000 Bratton Avenue, Apt 7, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
36 | 1000 Bratton Avenue, Apt 8, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
37 | 1000 Bratton Avenue, Apt 9, Marseilles, IL 61341 | N/A | N | Y | 2008 | 2008 | Visual Inspection/ Construction Records | O | C | C | NL | N | N/R | N | N | |||
38 | 1000 Magnolia Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2002 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
39 | 1000 Pomeroy Street, Marseilles, IL 61341 | N/A | N | Y | 1970 | 2005 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
40 | 1001 Bratton Avenue, Marseilles, IL 61341 | N/A | N | Y | 1976 | 2005 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
41 | 1001 Carter Street, Marseilles, IL 61341 | N/A | N | Y | 1992 | 2002 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
42 | 1001 Morris Road, Marseilles, IL 61341 | N/A | N | Y | 1910 | 2005 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
43 | 1002 Bratton Avenue, Apt 1, Marseilles, IL 61341 | N/A | N | Y | 1975 | 2002 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
44 | 1002 Bratton Avenue, Apt 2, Marseilles, IL 61341 | N/A | N | Y | 1975 | 2000 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
45 | 1002 Bratton Avenue, Apt 3, Marseilles, IL 61341 | N/A | N | Y | 1975 | 2000 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
46 | 1002 Bratton Avenue, Apt 4, Marseilles, IL 61341 | N/A | N | Y | 1975 | 2009 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
47 | 1002 Bratton Avenue, Apt 5, Marseilles, IL 61341 | N/A | N | Y | 1975 | 2005 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
48 | 1002 Bratton Avenue, Apt 6, Marseilles, IL 61341 | N/A | N | Y | 1975 | 2002 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
49 | 1002 Bratton Avenue, Apt 7, Marseilles, IL 61341 | N/A | N | Y | 1975 | 2002 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
50 | 1002 Bratton Avenue, Apt 8, Marseilles, IL 61341 | N/A | N | Y | 1975 | 2002 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
51 | 1002 Catalpa Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2006 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
52 | 1002 Magnolia Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2000 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
53 | 1002 Orange Avenue, Marseilles, IL 61341 | N/A | N | Y | 1967 | 2014 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
54 | 1002 Tower Circle Drive, Marseilles, IL 61341 | N/A | N | Y | 1997 | 2015 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
55 | 1003 Bratton Avenue, Marseilles, IL 61341 | N/A | N | Y | 1979 | 2008 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
56 | 1003 Clark Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2004 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
57 | 1003 Fillebrowne Street, Marseilles, IL 61341 | N/A | N | Y | 1925 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
58 | 1003 Magnolia Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2014 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
59 | 1003 Orange Avenue, Marseilles, IL 61341 | N/A | N | Y | 1880 | 2020 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
60 | 1003 Tower Circle Drive, Marseilles, IL 61341 | N/A | N | Y | 1991 | 2021 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
61 | 1003 Washington Street, Marseilles, IL 61341 | N/A | N | Y | 1977 | 2008 | Construction Records | U | U | U | U | N | 1/14/2026 | N | N | |||
62 | 1004 Bratton Avenue, Apt A, Marseilles, IL 61341 | N/A | N | Y | 1987 | 2005 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
63 | 1004 Bratton Avenue, Apt B, Marseilles, IL 61341 | N/A | N | Y | 1987 | 2006 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
64 | 1004 Carter Street, Marseilles, IL 61341 | N/A | N | Y | 2002 | 2006 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
65 | 1004 Catalpa Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2017 | Visual Inspection/ Construction Records | C | C | P | NL | N | N/R | N | N | |||
66 | 1004 Clark Street, Marseilles, IL 61341 | N/A | N | Y | 1950 | 2005 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
67 | 1004 Tower Circle Drive, Marseilles, IL 61341 | N/A | N | Y | 1997 | 2009 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
68 | 1004 Washington Street, Marseilles, IL 61341 | N/A | N | Y | 1964 | 2021 | Construction Records | U | U | U | U | N | 1/14/2026 | N | N | |||
69 | 1005 Bratton Avenue, Marseilles, IL 61341 | N/A | N | Y | 1978 | 2024 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
70 | 1005 Catalpa Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2003 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
71 | 1005 Tower Circle Drive, Marseilles, IL 61341 | N/A | N | Y | 1993 | 2017 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
72 | 1005 Washington Street, Marseilles, IL 61341 | N/A | N | Y | 1970 | 2012 | Visual Inspection/ Construction Records | U | U | C | U | N | N/R | N | N | |||
73 | 1006 Carter Street, Marseilles, IL 61341 | N/A | N | Y | 1997 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
74 | 1006 Magnolia Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
75 | 1007 Bratton Avenue, Marseilles, IL 61341 | N/A | N | Y | 1978 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
76 | 1007 Clark Street, Marseilles, IL 61341 | N/A | N | Y | 1911 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
77 | 1007 Magnolia Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2012 | Visual Inspection/ Construction Records | C | C | P | NL | N | N/R | N | N | |||
78 | 1007 Tower Circle Drive, Marseilles, IL 61341 | N/A | N | Y | 2005 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
79 | 1007 Union Street, Marseilles, IL 61341 | N/A | N | Y | 1880 | 2012 | Construction Records | U | U | U | U | N | 1/14/2026 | N | N | |||
80 | 1008 Bratton Avenue, Marseilles, IL 61341 | N/A | N | Y | 1977 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
81 | 1008 Carter Street, Marseilles, IL 61341 | N/A | N | Y | 1997 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
82 | 1008 Catalpa Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
83 | 1008 Clark Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
84 | 1009 Bratton Avenue, Marseilles, IL 61341 | N/A | N | Y | 1976 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
85 | 1009 Catalpa Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
86 | 1009 East Bluff Street, Marseilles, IL 61341 | N/A | N | Y | 1990 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
87 | 1009 Magnolia Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
88 | 1009 Tower Circle Drive, Marseilles, IL 61341 | N/A | N | Y | 1993 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
89 | 101 East Bluff Street, Marseilles, IL 61341 | N/A | N | Y | 1976 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
90 | 101 Woodview Lane, Marseilles, IL 61341 | N/A | N | Y | 2005 | 2010 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
91 | 1010 Magnolia Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
92 | 1010 Tower Circle Drive, Marseilles, IL 61341 | N/A | N | Y | 1991 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
93 | 1011 Bratton Avenue, Marseilles, IL 61341 | N/A | N | Y | 1995 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
94 | 1011 Clark Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2012 | Visual Inspection/ Construction Records | C | C | G | NL | N | 1/14/2026 | N | N | |||
95 | 1011 Magnolia Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
96 | 1011 Tower Circle Drive, Marseilles, IL 61341 | N/A | N | Y | 1986 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
97 | 1012 Bratton Avenue, Marseilles, IL 61341 | N/A | N | Y | 1978 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
98 | 1012 Carter Street, Marseilles, IL 61341 | N/A | N | Y | 2002 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
99 | 1012 Catalpa Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||
100 | 1012 Magnolia Street, Marseilles, IL 61341 | N/A | N | Y | 1982 | 2012 | Visual Inspection/ Construction Records | C | C | C | NL | N | N/R | N | N | |||