TMP Data Platform
Live — querying PostgreSQL + PostGIS
LIVE
Loading live data…

Portfolio activity by year

Jobs started + worksite registrations

Closure types deployed

MyWorksites deployments

Worksites by region

RCA region

NZ crashes by year & severity

CAS 2015–2025

Live project lookup

Search by PXJ, job name, road or client — queries the warehouse live.

SQL console (read-only)

SELECT/WITH only · single statement · auto-LIMIT 1000 · 10s timeout. Schemas: wfm, mws, cas, ref, link, meta, analytics.

Ingestion manifest

Record completeness

Deployment actual sign-in times are recorded for only ~0.2% of rows, so adherence analysis is flagged unavailable. CAS↔TMP linkage is road-level & exploratory (worksites lack coordinates).