Convergence Radar

← Feed

B

LCRI Unknown-Line Resolver: Mining County Records into Compliant Lead Service Line Inventories for Small Utilities

62/100

A records-mining service/tool that turns county permit and assessor websites into citable service-line-material evidence, so ~49,000 small water systems under the EPA's binding LCRI replacement mandate can resolve their 'unknown' lines and file state inventory templates without paying an engineering firm for archival research.

Worth deeper research β€” promising but has risk. Β· created 2026-08-13 22:02 UTC

public recordsaiindustrialsaasapilong-term

Scorecard

newness 6/10
convergence 8/10
demand evidence 8/10
existing spend 7/10
solo feasibility 7/10
speed to mvp 6/10
speed to revenue 5/10
distribution 5/10
competitive gap 6/10
expansion 7/10
founder fit 9/10

Penalty flags
long trust cycle (βˆ’3 from raw 65)

Opportunity brief

What changed
FACT: EPA finalized the Lead and Copper Rule Improvements (LCRI, Federal Register 2024-23549), compelling drinking water systems to inventory and replace lead and certain galvanized service lines. FACT: Context.dev-style schema extraction now returns structured data from arbitrary public websites via one API call, removing the per-county custom-scraper cost that made records research an engineering-firm archival job. FACT: EPA is funding technical-assistance intermediaries for rural/small systems (Grants.gov 362798), meaning subsidized buyers exist for exactly this segment.
Why now
The LCRI is final and binding: inventories must be maintained and updated, replacement plans filed, and lines classified as 'unknown' must be resolved on the way to full replacement, with obligations running through the 2030s. Small systems have the largest unknown-line backlogs and the least staff. The capability side (schema extraction + LLM classification of permit text) just collapsed the cost of the exact task β€” mining undocumented county permit/assessor/tap-card records β€” that consultants bill for by the hour. Estimated ~12-month edge before state TA programs and engineering firms standardize equivalent tooling (hypothesis).
Converging signals
(1) Regulation: LCRI final rule creates a defined, compelled class β€” every community water system with lead/galvanized/unknown lines β€” with named submissions (inventory on the state's template, replacement plan) [federalregister.gov]. (2) Capability: single-API structured extraction from arbitrary public sites makes bulk mining of county records feasible without scraping infrastructure [context.dev]. (3) Money: EPA-funded TA pipeline to small/rural systems proves public money is flowing to help this exact segment comply [grants.gov/362798]. Rule + filer class + newly cheap evidence pipeline is a genuine three-signal convergence.
Customer pain
Small systems (often one part-time operator) must produce and annually update a line-by-line materials inventory with evidence, and resolve thousands of 'unknown' classifications. Today that means hand-searching county permit books, tap cards, and assessor records β€” work they can't staff and currently buy from engineering firms at archival-research rates. HYPOTHESIS (no complaint threads in input): the pain is inferred from the mandate structure and staffing reality of small systems, not from captured complaint signals.
Who pays
Primary: small community water systems (roughly 500–10,000 connections), paying with SRF/BIL lead-service-line funds and compliance budgets. Secondary and likely the better wedge: EPA-funded TA intermediaries (RCAP affiliates, state rural water associations) and the small engineering/consulting firms serving dozens of systems β€” a white-label records-mining engine makes their fixed-fee TA dollars go further. The beneficiary (the utility) and the buyer (often the intermediary) may differ; both are named and reachable.
Solved today
Engineering consultants do manual archival research billed hourly or as a per-system project (commonly five figures); some states offer free statistical predictive tools and templates; larger systems buy platforms like 120Water or Trinnex leadCAST; many small systems simply mark lines 'unknown' and defer β€” which the LCRI no longer permits indefinitely.
Why current solutions are bad
Consultant archival research is priced for the job's former difficulty, not its current one. Incumbent platforms are program-management suites priced and designed for mid/large utilities, not a 2,000-connection system that needs one deliverable: classified lines with citable evidence on the state's template. Free state tools predict materials statistically but don't produce the per-line documentary evidence that survives a state audit.
Proposed product
A per-system service (tool-assisted, not self-serve at first): utility provides its billing address list; the engine runs schema extraction over the county's permit/assessor/tap-card portals, LLM-classifies material evidence per address, links each classification to its source document, and emits (a) the state-template inventory rows and (b) the LCRI replacement-plan skeleton with prioritization. Charge a flat per-system fee far below the consultant quote, plus an annual update subscription β€” the LCRI's annual update duty makes this recurring.
MVP version
The kill test IS the MVP: one cooperating utility, 200 addresses, one county portal. Measure the fraction of lines classified with citable evidence versus manual review. β‰₯40% auto-classification with evidence links beats the consultant baseline; under 40% kills or narrows the play. Deliverable doubles as the sales artifact for every neighboring system in the same county (records source is shared).
30-day build
Recruit 1–2 pilot utilities via a state rural water association or RCAP affiliate; run the 200-address kill test on their county; validate against the state's inventory template requirements; price against the utility's actual consultant quote.
60-day build
If β‰₯40%: productionize the county-portal extraction recipes, add the evidence-link citation format states accept, deliver both pilots as paid engagements ($3–8k each, hypothesis on price tolerance), and package results into a one-page proof for the TA intermediary channel.
90-day revenue plan
Sell county-by-county: every utility in a covered county is a warm prospect because the records source is already mapped. Target 5–10 paid systems directly plus one white-label agreement with a TA provider or small consultancy; realistic first-revenue window is 90–150 days given pilot lead time β€” within the founder's funded ramp.
Distribution path
State rural water associations (training events, newsletters), RCAP/EPA TA intermediaries, state drinking-water program contact lists (public), and direct outreach to systems with large published 'unknown' counts (state inventory summaries are public records β€” a self-generating lead list that fits the founder's public-records strength).
Pricing hypothesis
Flat per-system inventory-resolution fee (e.g., $2,500–$10,000 scaled by connection count) vs consultant quotes typically multiples higher; $500–$1,500/yr annual-update subscription; white-label per-system rate for TA providers and consultancies.
Technical difficulty
Moderate. Extraction API + address matching + LLM classification is squarely in the founder's automation/AI-workflow strengths. The real difficulty is variance: county portals range from clean databases to scanned PDFs to nothing online. Expect a meaningful fraction of counties to be unminable β€” the model must survive selling only where records are good, which the county-by-county go-to-market accommodates.
Legal / regulatory risk
Low-moderate. Public records are lawfully scrapable; no licensure to prepare inventory data a utility files itself (the utility remains the submitter of record). HYPOTHESIS: regulatory risk that the current EPA revisits LCRI provisions β€” litigation and reconsideration noise exists β€” but the replacement mandate direction has so far been retained; a delay would stretch, not erase, demand. Do not represent classifications as engineering certifications; some states may require a PE stamp on the replacement plan itself β€” check per state and partner with a PE where required (flagged in kill arguments, not assumed fatal).
Platform dependency
Context.dev is one vendor, but the capability (schema extraction) is commoditizing across several providers and could be rebuilt in-house; no platform owner can deplatform a tool that reads public records. Low dependency.
Founder fit
Very high. This is structurally the FMCSA ELDT play: a federal rule compels a defined class to produce a submission, and the founder builds the evidence/filing layer and charges per system. It additionally stacks his public-records skill, industrial-operations credibility (small utility operators respect operational fluency, not degrees), and demonstrated-value sales style β€” the 200-address pilot IS the demo.
Breakout potential
49,000+ small systems, obligations through the 2030s, annual updates as recurring revenue, and the county-records-mining engine generalizes to adjacent verification products (septic, backflow, well permits) once proven. Replicable state-by-state like his thesis prefers.
Final recommendation
PURSUE, gated hard on the kill test. The mandate is real, final, and durable; the filer class is defined; public money is flowing to the segment; and the shape matches the founder's proven ELDT pattern almost exactly. The two honest unknowns β€” county record minability and whether the free-TA path crowds out paid tools β€” are both resolvable in 30 days for a few thousand dollars. Run the 200-address pilot before writing any product code beyond the pipeline.
Next action
Contact one state rural water association or RCAP affiliate this week to recruit a cooperating small utility, then run the 200-address county-records kill test and measure the citable-evidence classification rate against the 40% threshold.

Kill arguments (adversarial)

  • The initial LCRR inventory deadline (Oct 2024) already passed, so the archival panic-phase is partly behind us; if most small systems have parked their lines as 'unknown' and states don't enforce unknown-resolution timelines aggressively, the buying urgency collapses until 2027 enforcement bites.
  • EPA-funded TA is FREE to small systems β€” if RCAP/state programs absorb records research themselves (or state predictive tools satisfy regulators), the free path is adequate and no one pays a third party; the counter is to sell TO those intermediaries, which must be validated, not assumed.
  • County record quality may fail the 40% kill-test threshold in most rural counties (scanned tap cards, offline books), shrinking the addressable market to well-digitized counties and making this a lumpy services business rather than a product.
  • Incumbents (120Water, BlueConduit, Trinnex) could ship a down-market records-mining tier faster than a solo founder can build distribution, since they already own utility relationships and state program contacts.

Competitors

β€’ 120Water (link) β€” Full lead-program management platform (inventory, sampling, communications); priced and structured for mid/large utilities and state programs, not a flat-fee small-system deliverable.
β€’ BlueConduit (link) β€” Machine-learning statistical prediction of service-line materials; predicts probability rather than producing per-line documentary evidence from permit records β€” complementary weakness this play attacks.
β€’ Trinnex (leadCAST) (link) β€” CDM Smith's lead service line software β€” an engineering-firm incumbent that could bundle records research; strongest threat if it moves down-market.

Source citations (facts)

β€’ National Primary Drinking Water Regulations for Lead and Copper: Improvements (LCRI) β€” FACT: Final rule compels water systems to replace lead and certain galvanized service lines and maintain inventories/replacement plans β€” the forced-buyer mandate defining the filer class and submissions.
β€’ EPA Technical Assistance and Training for Rural, Small and Tribal Municipalities and Wastewater Treatment Systems β€” FACT: EPA appropriates money to TA intermediaries serving small systems β€” evidence of funded buyers/channel partners for compliance help in this segment (note: this listing is wastewater-side; drinking-water TA analogues exist and must be cited during the pilot).
β€’ Context.dev β€” API for structured data from any website β€” FACT: Schema-defined extraction from arbitrary public sites via one API is now available, collapsing the cost of mining county permit/assessor records β€” the capability leg of the convergence.

Actions