Public + internal data, shaped to a graph.
Every figure in this demonstrator traces back to a real source. The seed data is already shaped like the target Labeled Property Graph, so swapping the stub layer for Neo4j or Postgres-as-graph is mechanical.
Insight is generated where these sources cross — a SCADA alarm becomes meaningful when Defra rainfall is below threshold AND the asset's EA permit is within its TTNC window AND STREAM scores the consequence-of-failure ≥ 4. The graph is what makes those joins fast.
Source catalogue
Filter by provenance or category. Expand a row to see refresh cadence, format, how this app uses it and which LPG node types it populates.
- Drives the Monitor view's £/percentage-point ODI calculations.
- Anchors the £1.42M/min CML headline and £0.31M storm-overflow rate.
- Used as the modelled glide-path for KPI trajectory charts.
Internal systems map
Systems of record on the left, integration spine in the middle, the LPG and consumer surfaces on the right. Click a system to see what feeds it and what it feeds.
EDA / Arcadia
Bronze/silver/gold curated data products; joins public + internal.
LPG schema
The eleven node types and the relationships between them. Click a node to inspect its properties and adjacent edges.
:Asset
Every physical wastewater asset: WwTW, CSO, Pump, TrunkSewer, CIM, Outfall.
| id | string |
| kind | enum |
| criticality | 1..5 |
| condition | A..E |
| installedYear | int |
| twentyYearSpendK | decimal |
- ←ATTRIBUTED_TON-N
- ←REGULATES1-1
- ←CONTAINS1-N
- →LOCATED_AT1-1
- →FLOWS_TON-N
- →INSTRUMENTED_BY1-N
- →DISCHARGED1-N
- →MAINTAINED_BY1-N
- →TARGETED_BYN-N
Interactive graph explorer
A live walk of the Peasholm Gap subgraph. Click a node to re-centre the walk, filter by label, change the hop depth and see the equivalent Cypher.
Peasholm Gap CSO
| kind | CSO |
| criticality | 4 |
| condition | C |
| installedYear | 1972 |
| twentyYearSpendK | 2150 |
- ←CONTAINS
- →FLOWS_TO
- ←REGULATES
- →LOCATED_AT
- →INSTRUMENTED_BY
- →DISCHARGED
- →ATTRIBUTED_TO
- →TARGETED_BY
- →TARGETED_BY
- →MAINTAINED_BY
MATCH (n:Asset {id: "asset-peasholm"})-[r*1..2]-(m)
RETURN n, r, m LIMIT 50;The explorer reads the same shape used by the Scarborough catchment view and the Operations triage cascade. Swap the in-memory walk for a Neo4j driver and the UI is unchanged.