Data Landscape

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.

Data sources catalogued
14
Public open data
7
Internal systems
6
Partner / regulator
1

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.

ProvenanceCategory14 of 14 sources
Refresh
AMP cycle (5 yr) + annual APR
Format
PDF + CSV appendices
Volume
~2,400 pp; 38 PCs
How this app uses it
  • 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.
Populates LPG
PerformanceCommitmentOdiRateRegulatoryPeriod
Open source ↗

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.

Systems of RecordIntegrationAnalytics platformAsset graphConsumer surfacesPROAMOracle EAMYW360 SCADAAVEVA + customCatchment ModellerInfoWorks ICMSTREAMYorkshire WaterSAP S/4HANASAPEvent BusConfluent KafkaEDA / ArcadiaDatabricks LakehouseAsset LPGNeo4j (target)This DemonstratorTanStack + ReactExec BI / APRPower BI + ESRI
Analytics platform

EDA / Arcadia

Databricks Lakehouse

Bronze/silver/gold curated data products; joins public + internal.

Feeds downstream
Fed by upstream

LPG schema

The eleven node types and the relationships between them. Click a node to inspect its properties and adjacent edges.

ATTRIBUTED_TOREGULATESCONTAINSLOCATED_ATINSTRUMENTED_BYDISCHARGEDMAINTAINED_BYTARGETED_BYValueStreamPerformanceCommitmentPermitCatchmentAssetGeoPointTelemetrySensorReadingSpillEventWorkOrderInvestmentOption
Asset

:Asset

Every physical wastewater asset: WwTW, CSO, Pump, TrunkSewer, CIM, Outfall.

Properties
idstring
kindenum
criticality1..5
conditionA..E
installedYearint
twentyYearSpendKdecimal
Relationships
  • 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.

Depth
15 nodes · 19 edges
CONTAINSFLOWS_TOREGULATESLOCATED_ATINSTRUMENTED_BYDISCHARGEDATTRIBUTED_TOTARGETED_BYTARGETED_BYMAINTAINED_BYPeasholm Gap CSOScarborough CatchmentScarborough WwTWPermit YW-CSO-314254.290, −0.405PEAS-LVL-01Spill 2026-05-31PC: Storm OverflowsOption: Peasholm SuDSOption: 3.4 ML tankWO #4456121Scalby Mills OutfallPermit YW-WwTW-091WWTW-FLOW-INPC: Customer Minutes Lost
Asset

Peasholm Gap CSO

id: asset-peasholm
Properties
kindCSO
criticality4
conditionC
installedYear1972
twentyYearSpendK2150
Neighbours (10)
  • CONTAINS
  • FLOWS_TO
  • REGULATES
  • LOCATED_AT
  • INSTRUMENTED_BY
  • DISCHARGED
  • ATTRIBUTED_TO
  • TARGETED_BY
  • TARGETED_BY
  • MAINTAINED_BY
Equivalent Cypher
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.