← Back to Blog
GuideSeptember 14, 2026

From CCTV to Capital Plan: A Five-Step Playbook

A dollar spent finding a problem is worth about five spent fixing it after it fails. Here's the five-step workflow two very different teams use to turn inspection data into a capital plan their board will fund.

From CCTV to Capital Plan: A Five-Step Playbook

A dollar spent finding a problem is worth about five spent fixing it after it fails, but only for utilities that get to the problem first. An 8-person coastal utility team and a national water management provider running half a million feet of inspection a year are both proving that out right now, using the same five-step workflow to turn a list of pipes into a plan their board actually funds.

Most programs never get that far. The inspections pile up, the budget gets pitched with a spreadsheet and a gut call, and the plan is out of date before the ink dries. Here's the workflow that closes that gap, and what it looks like at two very different scales.

The math that makes this worth fixing

A dollar spent finding the problem is worth about five spent fixing it after it fails. That's not a marketing number. It's DOE and EPA asset management guidance: assessment is the cheapest work a utility can do, because it moves spending from emergency repair, which is reactive and expensive, to planned rehab, which is scheduled and far cheaper. The catch is that the five-to-one only holds if the dollar lands on the right asset before the failure, which means the plan has to exist before the pipe breaks, not after.

Five steps, not a study

The programs that get this right don't run a once-a-year planning cycle. They run a workflow that updates as fast as the inspections come in:

  • Inspect. CCTV and MACP data you're already collecting.
  • Score risk. Likelihood of failure times consequence of failure, per asset, not per photo.
  • Prioritize. Ranked by what actually fails first, not by whoever complained loudest.
  • Cost it. Your local pricing behind every line, not a generic default.
  • Defend it. Board-ready, because every number traces back to real data and real rates.

Every step uses data the program already has. The last one is where budgets actually get won or lost.

Two teams, same workflow, completely different scale

One is a barrier-island coastal city of about 10,000 residents, with an eight-person team responsible for the whole system, aging 1957-era clay pipe, and the added pressure of hurricanes and high groundwater. In the first five months of running inspection data through a risk-and-rehab workflow, that team uploaded more than 170,000 linear feet of video. As one of them put it, the goal was never to collect more data. It was to get more value out of the data they already had.

The other is a national water management provider running high-volume CCTV operations for utilities across the country. That team inspects more than 510,000 linear feet a year across 300-plus projects, and building a repeatable rehab-plan template has saved them roughly an hour on every single report they turn around for a client.

Different team size, different scope, same underlying shift. Both stopped treating risk and cost as two separate conversations that happen in two different meetings.

The step everyone skips: your own numbers

A national cost benchmark gets a program a fast, defensible-sounding estimate. It also gets picked apart the moment a council member asks where the number came from. The programs that hold up under scrutiny calibrate that baseline with their own contractor rates and their own project history first.

The difference shows up in the total. Take a straightforward CIPP lining job: 2,340 linear feet of 8-inch VCP. A national benchmark prices that around $38 a foot. Calibrated to actual local contract rates, it comes in at $46 a foot, a number that, added to mobilization, bypass pumping, traffic control, and contingency, lands at a defensible $144,480. That's not a rounding error. That's the difference between an estimate and a number a program can stand behind in a budget meeting.

The plan was always sitting in the data

None of this requires new fieldwork or a GIS specialist on staff. It requires treating the inspection data a program already has as a living, requeryable asset instead of a study that gets filed once a year and goes stale. Score it by risk. Cost it with real numbers. Then defend it, because by the time anyone asks a hard question, the answer is already sitting in the plan.

See a plan built live, from real data. A short walkthrough shows how risk scoring and local cost calibration turn a list of worried-about pipes into a number a board will approve.

[Book a walkthrough]

NEWSLETTER

STAY AHEAD OF THE FLOW

Get SewerAI updates, product news, and practical guidance for modern sewer inspection programs.

READY TO GET STARTED?

See how SewerAI can transform your sewer inspection workflow.

BOOK A DEMO →