Metric migration / PW-01
PW-01 Potholes repaired within 48 hours
Owner: Public Works. Unit: %. Reconciliation tolerance: 0.1. Target: 85.0 (higher is better).
Written definition
- Source
- Cityworks work orders
- Calculation
- Pothole repair work orders completed in the month within 48 hours of creation, divided by all pothole repair work orders completed in the month, times 100.
- Inclusions
- Work order category Pothole repair.
- Exclusions
- Open work orders.
- Time frame
- Calendar month of completion.
- Definition status
- Accepted Office of Data and Innovation, 11/05/2026
As held in the legacy performance database (PerfDB)
- Name
- Potholes repaired within 48 hours
- Note
- Pothole repair work orders completed in the month within 48 hours of creation
- Script
perf_pw_01.sql
CDR value against PerfDB
Calculation as run by the CDR
select date_trunc('month', completed_at)::date as month, 100.0 * avg(case when completed_at - created_at <= interval '48 hours' then 1 else 0 end) as value from curated.fact_work_order where category = 'Pothole repair' and completed_at is not null group by 1
Reproduce now from the curated layer Runs the SQL above against the current curated tables, read only.
Reproduced 13 months in 5 ms from the curated layer; 13 of 13 match the values stored by the latest run.
| Oct 2025 | Nov 2025 | Dec 2025 | Jan 2026 | Feb 2026 | Mar 2026 | Apr 2026 | May 2026 | Jun 2026 | Jul 2026 | Aug 2026 | Sep 2026 | Oct 2026 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82.83 | 80.08 | 81.23 | 79.27 | 78.41 | 78.54 | 82.64 | 85.23 | 81.44 | 81.96 | 79.01 | 78.42 | 80.99 |
Monthly reconciliation, latest run
| Month | PerfDB | CDR | Difference | Result |
|---|---|---|---|---|
| Oct 2025 | 82.8 | 82.833 | 0.033 | Within tolerance |
| Nov 2025 | 80.1 | 80.081 | -0.019 | Within tolerance |
| Dec 2025 | 81.2 | 81.226 | 0.026 | Within tolerance |
| Jan 2026 | 79.3 | 79.273 | -0.027 | Within tolerance |
| Feb 2026 | 78.4 | 78.414 | 0.014 | Within tolerance |
| Mar 2026 | 78.5 | 78.544 | 0.044 | Within tolerance |
| Apr 2026 | 82.6 | 82.645 | 0.045 | Within tolerance |
| May 2026 | 85.2 | 85.232 | 0.032 | Within tolerance |
| Jun 2026 | 81.4 | 81.439 | 0.039 | Within tolerance |
| Jul 2026 | 82.0 | 81.961 | -0.039 | Within tolerance |
| Aug 2026 | 79.0 | 79.008 | 0.008 | Within tolerance |
| Sep 2026 | 78.4 | 78.423 | 0.023 | Within tolerance |
| Oct 2026 | 81.0 | 80.989 | -0.011 | Within tolerance |
Reconciliation history
| Run | Result | Months |
|---|---|---|
| L-20261101-0100 | Within tolerance | 13 |
| R-20261102-0200 | Within tolerance | 13 |
| R-20261103-0200 | Within tolerance | 13 |
| R-20261104-0200 | Within tolerance | 13 |
| R-20261105-0200 | Within tolerance | 13 |
| R-20261106-0200 | Within tolerance | 13 |
| R-20261107-0200 | Within tolerance | 13 |
| R-20261108-0200 | Within tolerance | 13 |
| R-20261109-0200 | Within tolerance | 13 |
| R-20261110-0200 | Within tolerance | 13 |
| R-20261111-0200 | Within tolerance | 13 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.