The deadline is on the calendar. The records are in a shoebox.
Maybe it is not a shoebox. Maybe it is a metal drawer of tap cards, a roll of as-builts in the back of the truck, and a three-ring binder the last superintendent kept in his own handwriting. You know the lines are in there somewhere. You just have to find them, read them, and turn them into a list the state will accept.
That is the job in front of small water systems right now. You have to say what every service line is made of, lead, galvanized, copper, or plastic, on both the public side and the private side. And you have to do it without a GIS department, because you do not have one.
Here is the good news. You do not need one. You already have most of what you need. This walks through how to build a lead service line inventory from the records you have, verify the pipe in the field with your phone, handle the ones you cannot identify, hand a clean list to the state, and keep it current after the first submission so you never start from scratch again.
What the Lead and Copper Rule Improvements actually ask of you
Strip away the acronyms and it comes down to one question. For every connection you serve, what is the service line made of?
The Lead and Copper Rule Improvements, the LCRI, ask you to build and keep a lead service line inventory. That means a record for each service line, public side and customer side, with the material identified or flagged as unknown. You report it to your state, you make it available to the people you serve, and you keep working down the list of unknowns over time. Lines made of lead or galvanized pipe that once sat downstream of lead get pointed toward replacement.
There are dates and review cycles tied to all of this. They shift, and the brief you are reading should not be the thing you cite to your state. So plan against the compliance deadline you are working against and confirm the current numbers with your primary agency. [VERIFY: current LCRI inventory and replacement deadlines and any state-specific submission dates]
The part that trips people up is not the rule. It is the records. The rule assumes you can answer "what is this pipe made of" for thousands of connections. Your answer is sitting on paper, in a few heads, and under the ground. So that is where the work is.
Build the inventory from what you already have
You do not start in the field. You start at the desk, with the paper. Most small systems are sitting on more information than they think.
Pull your tap cards. The tap card from the day the service was installed often names the material, the size, and the date. A card that says "3/4 copper, 1962" is a verified line, not a guess. A card that says nothing useful is still a clue, because the year tells you a lot about what was legal and common to install back then.
Pull your as-builts and old plans. The roll in the truck and the prints in the file cabinet show mains, sizes, and sometimes service materials by neighborhood. A subdivision built in one year was usually plumbed with one material. Find the year, find the likely material.
Walk the meter cans in your memory first. You have looked in thousands of meter pits over the years. You know which side of town still has galvanized risers and which streets got swapped to plastic when the road was repaved. Get that out of your head and onto the record before you forget it, or before you retire.
That last point is the whole reason to do this on a screen instead of another binder. Institutional knowledge walks out the door when the person does. As Tyler Henke in Newport, North Carolina put it about his own system, "Preventative maintenance data is stored in Bernie's brain." A service line inventory locked in one operator's memory is one retirement away from gone. Get it into the system while Bernie is still here to tell you. If you are still working off paper today, that is not a failure, it is just the starting line. We wrote more about that move in getting from paper maps to a digital map.
Verify the pipe in the field, on the map, from your phone
Paper gets you a first guess for a lot of lines. The rest you confirm the only way anyone can, by looking at the pipe.
You already do this. When you pull a meter, when you dig up a leak, when you set a new service, the pipe is right there in front of you. The trick is capturing what you see while you are standing over the hole, not scribbling it on your glove to enter "later." Later does not come.
This is where everything on a map earns its keep. In Ziptility you open the service location on your phone, pick the material from a list, lead, galvanized, copper, plastic, or unknown, and snap a photo of the actual pipe. The point drops where you are standing. The photo attaches to that point. The next person who opens that record sees the pipe you saw, not a note they have to trust.
It works in the field with no signal. If you are in a basement or out past the edge of cell coverage, you capture it now and it syncs when you are back in range. You are not driving back to the office to type it in. The scratch test on a copper-looking line, the magnet on a galvanized riser, the photo of the goose-neck, all of it lands on the map from the truck. For more on what putting your system on a map looks like, see our guide to GIS mapping for small utilities.
Handle the unknowns honestly
You are not going to know every line on day one. Nobody does. The rule expects that. What it wants is that you say so plainly and keep chipping away.
There is a real difference between two kinds of records, and you should keep them apart:
- Predicted material. Your best read from the tap card, the install year, the as-built, or the pattern on that street. Useful, defensible, but not eyes-on.
- Verified material. Somebody looked at the pipe, or you have a record clear enough to count as confirmed. This is the one that holds up.
Mark each line for what it is. A line you predicted as copper from a 1980s card is not the same as one you dug up and photographed last week, and your state will care about the difference. Recording it as "unknown" when you truly do not know is not a gap in your work, it is an honest answer that tells you where to send the crew next.
That is also how you build a plan instead of a panic. Sort the map by material and by predicted-versus-verified, and the unknowns and the suspect lines show you exactly which streets to hit when you have a crew and a free afternoon. The town of Iola, Kansas knows this rhythm. They have worked lead-and-copper sampling on a multi-year cycle, and a single result pushed them into far more frequent sampling. When a number can change your whole schedule like that, you want the underlying records clear, current, and in one place, not scattered across a drawer and three trucks.
Produce the list you can hand the state
All this work is worth nothing if you cannot get it back out. The output is a list, your whole inventory, every service line with its material and its status, in a file your state can take.
Because each line is already a record on the map, with its material, its public and customer side, its status, and its photo, the list is not a separate project you build at the end. It is a report you run from what you already entered. You export it when the submission is due. You export it again when someone on the board asks what shape the system is in.
And the data is yours. You can pull your inventory out any time, in a standard file, for the state, for an engineer, for a funding application. You are not locked in and you are not asking permission to get at your own records. When a clean inventory lands on a regulator's desk, it stands out. Samuel Cushman in Bingen, Washington saw that firsthand: "The state regulators were thrilled... most communities just don't have this." That is the position you want to be in, the system that already has its act together while everyone else is still digging through the drawer.
Keep it current after the first submission
Here is the mistake to avoid. A system pours months into the first inventory, submits it, and lets it rot. A year later the spreadsheet is stale, three lines got replaced, two services got added, and nobody updated the file. Next cycle, you are half starting over.
The inventory is not a one-time form. It is a living record of your system, and the LCRI expects you to keep it that way. The fix is to make updating it part of the work you already do, not a separate chore.
- Replace a service line? Change the material on that point and add a photo before you leave the site.
- Set a new service? Drop it on the map with its material the day it goes in.
- Confirm an unknown while you are out for something else? Flip it from predicted to verified right there.
Do it from the truck, in the moment, and the inventory stays true on its own. The list you hand the state next time is just today's records, exported again. No scramble, no archaeology.
You do not need a GIS department to do this
That is the whole point. A lead service line inventory is a map of your service lines with the material on each one, kept current. You do not need a GIS degree, a big budget, or an IT department to keep that map. Ziptility lets you record each service line's material, lead, galvanized, copper, plastic, or unknown, drop it on the map, tell predicted from verified, attach a field photo, and export the whole list when the state asks. It is built for small water systems, the ones with one to five people doing everything, not for an enterprise GIS shop.
Be clear on what it is not. Ziptility is not a lab and not a testing service. It does not tell you what the pipe is made of. You and your crew do that, with your eyes and your hands in the field. What the app does is hold the answer, put it on the map, and give it back to you in a file the state will take. Plenty of small utilities are already running this way, and the ones with the most to lose tend to feel it first, which we got into in why the smallest utilities have the most to lose.
Getting started
You do not have to figure this out alone, and you do not have to block out a week. We will sit down with you and set it up with your actual data, your tap cards, your service area, in about 45 minutes. You will walk away with your service lines on a map and a clear way to record material as you verify it.
You can start your free trial, see how it works, or check what it costs. Bring the drawer of tap cards. We will help you turn it into the list the state is waiting on.
Related reading: