About Services Tools Blog Contact us

Power Interruption Hotspot Map

Plots electricity interruption records on a county map, with monthly totals and the overhead and underground lines near each site.

  • Mapping & Geospatial
  • Electricity distribution
  • Dashboard feature
  • Productised
  • Local/private
  • 2026

The problem

An interruption spreadsheet lists start times and references, so it does not show which substations fail again and again. It also does not show how those sites sit on the overhead and underground network. The repeat locations stayed hidden in the rows.

What it does

Incidents are grouped by site reference, checked against the county boundary and drawn as hotspots. A second download fetches the power-line paths for the same area, so each point can be read against the network. Monthly totals sit beside the map.

Outcomes

  • Repeat failures show up as hotspots instead of rows.
  • Each site can be read against the local lines.
  • Monthly totals make a bad run of weeks easy to spot.
  • The map is rebuilt when a new month of records arrives.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Hestmere interruption hotspots

Incidents
92
Sites inside the county
8
January peak
20
Worst month
County boundary · size is incident count
Selected site
HF-0311
Fen Gate
11.4 h
Time off supply
22 incidents

January is the tall bar. The same shape is not used for every site.

92 incidents in the year
Overhead Underground

Group the interruption file

1. Records
Click to load the Hestmere year file

Each row has a site reference, a start, an end and a coordinate.

2. Group
Load the file to start

Monthly totals

Incidents by month January peak
January
20
Quietest month
2
July
Winter share
61%
Nov to Feb

November to February accounts for 56 of the 92 incidents. The sheet hides that run of weeks. The chart does not.

How it works

  1. Group the interruption records by site reference, with start, end and coordinates.
  2. Drop points that fall outside the county boundary.
  3. Draw repeat sites as hotspots on an interactive map.
  4. Take the overhead and underground power lines for the same area from OpenStreetMap data and draw them as lines.
  5. Write monthly counts beside the map so a bad month is visible without opening the sheet.

Pipeline

flowchart LR
  Csv[Interruption records] --> Group[Group by substation]
  Group --> Bounds[Keep points inside the county]
  Bounds --> Hot[Hotspot map]
  Lines[Network paths] --> Hot
  Hot --> Month[Monthly totals]