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).