Python, Tkinter and SQLite · free desktop tooling built on Street Manager data · current version 1.0.2

Four applications that help highway authorities and utilities get more out of their Street Manager data, bundled behind a single launcher. Free to use, and built over evenings and weekends.

Demo

The four tools

FPN Sentinel — identifies potential Fixed Penalty Notices using built-in logic against your own Street Manager data, with works openable directly in Street Manager from the results.

TPI Sentinel — tracks, analyses and visualises performance indicators.

Management Sentinel — surfaces wider trends, patterns and performance across road and street works.

Notice Sentinel — handles Section 50 and Road Opening Notices, including bond return details.

All four sit behind a central launcher that also handles updates, so there’s no manual re-downloading when a new version lands.

Designed to be tried, not deployed

The friction with tooling like this is usually the setup: nobody wants to put real operational data into an unfamiliar application to find out whether it’s useful. So the download includes fictional street works test data — with a few deliberately silly names hidden in it — that works with both FPN and Management Sentinel. You can see exactly what the tools do before deciding whether to point them at anything real.

Setup is: download the ZIP, extract it, add your Street Manager data (the DAMD file doesn’t need unzipping). The optional S70 distance check needs GeoPlace API credentials; everything else doesn’t.

Keeping pace with national changes

The tools track the DfT’s Street Manager Download All My Data layout, which changes periodically — version 1.0.2 brought them back in line with the latest revision. That’s the unglamorous part of maintaining something other organisations rely on: when the national format shifts, every user’s workflow breaks unless someone keeps up with it.

Get it

Most bar charts are clickable, and name lists can be double-clicked.

Who’s using it


A personal project, built in my own time and separate from my day job. Feedback welcome.