Lead service line inventory software that classifies every service line from its records — with the evidence the state will ask for
Meet the LCRI inventory deadline with evidence.
See one case, screen by screen ↓Under the Lead and Copper Rule Improvements, every community water system must give its state a baseline service line inventory and a lead service line replacement plan by 1 November 2027. Each service line and connector has to sit in one of four categories — lead, galvanized requiring replacement, non-lead or lead status unknown — and a line can only be called non-lead when an evidence-based record, method or technique shows it. Systems serving more than 50,000 people post the inventory online, address by address.
The evidence exists, but it is on paper: tap cards back to 1921, about a third of them in pencil, building permits, main renewal as-builts, meter change notes and customer photos. Nobody can read them at scale, so lines stay unknown, every unknown address gets an “unknown but may be lead” letter, and the fallback is to dig — at Lumina's contract rates, $1,150 for a keyhole dig against $140 for a look in the curb box or meter pit. The GRR test is easy to miss as well: a galvanized line that ever sat downstream of lead must be replaced, even if the lead was later taken out.
Estimated split for one box of about 200 tap cards, in working hours, by hand and with the solution. The 4 min 10 s read of box 14 was seen in the working solution; the other rows are our estimate.
Seven agents read the records, classify every line and plan the field checks; the compliance manager confirms, the director signs.
Lumina Utilities' water system serves 412,000 people through 118,460 service lines. On Monday 12 October 2026 at 16:40, the records room scanned box 14: 212 Old Mill tap cards from 1956–1959. One of them belongs to 1418 Wexford Avenue. Here is what happens next, screen by screen, in the working solution.
Dana owns the inventory, the replacement plan and the state submission. Her map shows Old Mill parcel by parcel — red for lead, orange for GRR, green for non-lead, grey hatching for unknown — over a system strip that reads 9,184 lead, 5,410 GRR, 94,316 non-lead and 9,550 unknown, 8.1% of all lines, with 384 days to 1 Nov 2027. In the rail, box 14 is waiting: 74 of its 212 cards are written in pencil, and 9 lines on these blocks have no other record.
“Unknown isn't an answer the state will take in 2027 — and it's 9,550 front doors.”
Service line SL-031477, house built 1957. System side, owner side and connector are all unknown. The classifier predicts galvanized at 71%: the house was built before the 1986 lead ban, 5 of 7 known neighbours on this block face are galvanized, and the street was laid by J. Ferris's crew — whose card for this line is in box 14, scanned but not read.
“A prediction never goes in the inventory: the line stays unknown until a record or a visit decides it.”
Dana starts the read. The records reader reads all 212 cards, checks 31 crops twice and sends 3 to the hand-read queue. The record matcher ties 204 to service lines by address, tap date and card number; 8 on streets renumbered in 1961 go to Marcus. Card T-1958-0412, dated 14 May 1958, opens on the map: city side “lead ¾” read at 96%, owner side “galv ¾” at 91%, gooseneck “lead 18 in.”
Remarks on the card: “house side galv. to cellar wall — owner to replace later”
As-built W-79-031 shows the Wexford Ave main renewal of August 1979 replaced the city side in copper. But the galvanized owner side had already sat downstream of lead for 21 years, so 1418 Wexford Ave is GRR at 94%. Seven lines change — 5 to GRR, 2 to lead — all at 90% or more, so they go straight into the inventory. Unknowns drop from 9,550 to 9,543.
“2 lines read as copper → non-lead waits for Dana · non-lead always needs a person”
The evidence page shows the tap card with a numbered note on every field it read and how sure it was, tabs for the as-built, the assessor record and field photos, and the classification by side: system side non-lead, copper from the 1979 renewal; connector non-lead, renewed 1979; owner side galvanized, downstream of lead. Dana can confirm, correct a reading or send the line for a field check. She also confirms 1411 and 1420 Wexford Ave as non-lead — “cop. ¾” on both sides, agreeing with the as-built — and unknowns fall to 9,541.
“Rule: GRR is any galvanized line that ever was downstream of a lead line.”
Marcus keeps the service line layer and matches records to parcels. His records screen lists every batch — 61,412 tap cards, 18,930 permits, 2,214 as-builts, 6,118 work orders and 3,118 self-reports — and the hand-read queue: readings below 85%, each with its crop and alternatives. On card T-1941-0310 for 1315 Pruitt Ave, the owner side “w.i. 3/4” reads at 69%; he picks wrought iron ¾, galv. ¾ or w.l. ¾, and the line is re-classified from his choice.
“Half our evidence is a pencil and a 1958 clerk.”
The inspection planner ranks the unknowns by visit value and builds the routes for Rosa's three crews. Stop 1 is 1309 Pruitt Ave, Little Acorns Childcare — predicted lead at 52%, a meter pit look. 612 Ardent St in Kessler Park is a keyhole dig because it settles 5 neighbours on the 600 block. The 9 Wexford Ave lines with a card in box 14 were left off. Across all 9,550 unknowns the plan is 1,968 curb box looks, 2,104 meter pit looks, 1,238 checked customer photos and 4,240 keyhole digs: $5.62M instead of $10.98M.
“Visit value = chance a visit changes the answer × neighbours it settles × children first”
At 07:52, Evelyn Tran at 2207 Hollis St sent a photo of the pipe at her meter: the magnet does not stick, the scratch is shiny silver. The photo checker reads it as likely lead at 88% and offers a meter pit look. At 508 Linwood Ave a copper pipe reads at 93% as non-lead evidence; with a 2009 replumb permit as a second source, it is ready for Dana to confirm.
“Book a meter pit look to confirm — a photo alone never decides”
The notice writer drafts 24,144 notices, mailed within 30 days of the baseline inventory, in English, Spanish and Vietnamese: lead, galvanized requiring replacement, and unknown but may be lead. Non-lead addresses get no letter. The letter to 1418 Wexford Ave says what the line is, what the customer can do now and that Lumina will replace both its part and theirs at no cost. Each letter waits for approval.
“Wording from the State Drinking Water Program's template, locked — the notice writer cannot edit it.”
The submission builder checks the inventory against the rule and drafts the nine elements of the replacement plan: 1,460 replacements a year at 10%, 12.3 per 1,000 connections — below the 39 that would allow a deferred deadline — so the deadline is 31 Dec 2037, with schools and childcare first. Priya signs 118,460 lines: 9,186 lead, 5,415 GRR, 94,318 non-lead and 9,541 unknown.
“If we say non-lead, I want the record in my hand.”
The same service line, seen by the four people who answer for it — what their month looked like, and what it looks like now.
Seven agents read the records, classify every line and plan the field checks; the compliance manager confirms, the director signs.
Reads tap cards, permits, as-builts and work orders, pencil handwriting included, and returns every field with its read confidence and the crop it came from.
Ties each record to a service line by address, tap date, card number and old street names, using the parcel register and the 1961 street renumbering.
Reads customer photos of the pipe at the meter, with the magnet and scratch answers, and says what the pipe most likely is and how sure it is.
Combines every record into the rule's categories for the system side, the owner side, the connector and the whole line, applying the GRR test every time, and predicts unknowns from build year, neighbours, crew and card batch.
Ranks unknowns by visit value — the chance a visit changes the answer, the neighbours it settles and children first — chooses curb box, meter pit or keyhole dig, and builds the crews' routes.
Drafts the annual and post-inventory notices by category and language from the state's template.
Builds the baseline inventory file, the connector counts, the nine replacement plan elements and the public map, and reconciles every count.
Confirms every non-lead line. The agents propose; a named person decides.
Ask in plain words — an address, a district, tomorrow's routes — or say what to change. Every answer points to its records.
Why is 1418 Wexford Avenue galvanized requiring replacement?
Its 1958 tap card reads “lead ¾” on the city side and “galv ¾” on the owner side. The 1979 Wexford main renewal replaced the city side with copper, but the galvanized pipe had already sat downstream of lead for 21 years — and the rule counts any galvanized line that ever was downstream of lead. So it is GRR at 94%, and on the replacement list.
Which unknowns should the crews check tomorrow?
Tomorrow's Old Mill route has 12 stops, led by 1309 Pruitt Ave — Little Acorns Childcare (predicted lead 52%, children first). The next stops are where a visit would change the answer most, each settling 2–5 neighbours on its block face. The 9 Wexford lines with a card in box 14 are left out: a record beats a dig.
Show unknown lines near schools and childcare
Old Mill Elementary is GRR and first in the replacement plan; Little Acorns Childcare is unknown and stop 1 on tomorrow's route. System-wide, all 38 schools and childcare centres on lead or GRR lines are in program year 1.
Add a rule: a customer photo read as non-lead needs a second source
Done. A customer photo read as non-lead now waits for a second source — a permit, a tap card or a crew visit — before it reaches Dana. Today that holds 2 self-reports: 508 Linwood Ave already has its 2009 replumb permit, 3340 Northgate Dr its 2004 build permit. The rule is in Settings and on the audit trail.
13 screens from the working solution, on its sample data. Pick one to see it large.
How sure the agents must be, how the crews are planned and who confirms and signs are settings Lumina decides — every change saved as a new version and on the audit trail.
| Setting | Default | Choose from |
|---|---|---|
| Apply lead or GRR automatically at | 90% | Adjustable — below it, the change waits for the compliance manager |
| Non-lead needs a person and an evidence-based record | On, locked | Locked — the rule allows non-lead only from a record, method or technique |
| Hand-read below | 85% | Adjustable — readings below it go to the GIS analyst with the crop |
| Put predictions in the inventory | Off | Off: a prediction only steers the field plan and the line stays unknown · On |
| Visit value weights | 0.6 · 0.3 · 0.1 | Chance of change · neighbours settled · schools and childcare |
| Visits per crew per day | 26 | Adjustable — 3 crews: Rosa Delgado, Theo Banks, Amaya Ruiz |
| Keyhole digs need a locate ticket | On | 72 hours ahead, checked by the planner · Off |
| Confirms classifications · signs the submission | Dana Whitlock · Priya Nandakumar | Compliance manager approves; director of water quality signs |
Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.
“demo” = seen in the working solution, on its sample data · “target” = the design goal, measured in the live solution · “estimated” = our estimate: digging avoided uses Lumina's demo contract rates ($1,150 a keyhole dig, $140 a curb box or meter pit look; 4,240 digs and 5,310 looks or checked photos for 9,550 unknowns), and the hours split is our estimate · “typical” = published figures (EPA, 2025 update to the 7th Drinking Water Infrastructure Needs Survey — about 4 million lead service lines). Regulatory context: EPA LCRI fact sheet EPA 816-F-24-019 (2024: baseline inventory and replacement plan due 1 Nov 2027). Lumina Utilities and the people, streets, schools and records named on this page are fictional — characters and sample data in the working solution.
Software that helps a water system put every service line and connector in one of the rule's four categories — lead, galvanized requiring replacement, non-lead or lead status unknown — with the evidence behind each, and build the baseline inventory and replacement plan for the state. Lead Service Line Inventory adds seven agents that read the records, classify the lines, plan the field checks and draft the notices and submission; the compliance manager confirms and the director of water quality signs.
The records reader reads tap cards, permits, as-builts and work orders field by field, pencil included, keeping the crop and a read confidence for each. The record matcher ties each record to its service line, and the material classifier decides the system side, owner side, connector and whole line, citing every record. In the demo, one 1958 card and a 1979 as-built turned 1418 Wexford Ave from unknown to GRR at 94%.
The classifier applies the GRR test on every line: a galvanized line that is, or ever was, downstream of lead — or sits downstream of an unknown — is GRR. That is how 1418 Wexford Ave is GRR even though its city side was renewed in copper in 1979: the galvanized owner side sat below lead for 21 years.
No. Unknown lines are shaded on the map by predicted material and confidence, from build year, neighbours, the crew that laid the street and the card batch, but by default a prediction only steers the field plan. The line stays unknown until a record or a visit decides it.
The inspection planner ranks unknowns by visit value — the chance a visit changes the answer, the neighbours it settles and children first — picks a curb box look, meter pit look or keyhole dig, and builds routes within crew capacity. Lines with a record waiting are never sent. In the demo the plan costs an estimated $5.62M against $10.98M to dig every unknown.
Yes. The submission builder checks the inventory against the rule, drafts the nine replacement plan elements, tests eligibility for a deferred deadline and prepares the public map, and the notice writer drafts the letters for each category from the state's template. Nothing is submitted or mailed until a named person approves or signs.
Yes. Non-lead always needs an evidence-based record and the compliance manager's confirmation, lead or GRR applies on its own only at 90% confidence or more, and handwriting below 85% goes to the GIS analyst. Agents never submit to the state, never change a threshold and never book work on private property without consent; the director of water quality signs.
The Agentic Solution Engine builds and deploys it from your requirements and documents — your tap card layouts, permit and work order exports, service line layer and state template — and it goes live once every quality gate has passed. We will walk you through it on a box of your own tap cards first.
Leak crews sent where the loss is certain, not where a meter is in doubt.
1-min demoWater Quality Compliance MonitoringExceedances caught the hour they happen, and low chlorine seen two days ahead.
1-min demoLeak Detection AnalyticsSend crews to real leaks, not false alarms.
1-min demoWe'll run Lead Service Line Inventory on a box of your own tap cards and one district of your service line layer.