Metric migration / FD-01
FD-01 90th percentile fire and EMS emergency response time
Owner: Fire. Unit: minutes. Reconciliation tolerance: 0.1. Target: 8.0 (lower is better).
Written definition
- Source
- CAD incident summaries (no criminal justice information)
- Calculation
- 90th percentile of minutes from call received to first unit on scene for Priority 1 and 2 fire and EMS calls received in the month.
- Inclusions
- Agency SLFD, priority 1 and 2.
- Exclusions
- Calls cancelled before arrival; clock sync errors.
- Time frame
- Calendar month of call received.
- Definition status
- Accepted Office of Data and Innovation, 11/05/2026
As held in the legacy performance database (PerfDB)
- Name
- 90th percentile fire and EMS emergency response time
- Note
- 90th percentile of minutes from call received to first unit on scene for Priority 1 and 2 fire and EMS calls received in the month.
- Script
perf_fd_01.sql
CDR value against PerfDB
Calculation as run by the CDR
select date_trunc('month', received_at)::date as month, percentile_cont(0.9) within group (order by response_minutes) as value from curated.fact_cad_incident where agency = 'SLFD' and priority <= 2 and response_minutes 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 8 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9.38 | 9.17 | 9.46 | 9.28 | 9.30 | 8.75 | 9.12 | 9.13 | 9.14 | 9.18 | 9.09 | 9.19 | 9.60 |
Monthly reconciliation, latest run
| Month | PerfDB | CDR | Difference | Result |
|---|---|---|---|---|
| Oct 2025 | 9.4 | 9.382 | -0.018 | Within tolerance |
| Nov 2025 | 9.2 | 9.172 | -0.028 | Within tolerance |
| Dec 2025 | 9.5 | 9.464 | -0.036 | Within tolerance |
| Jan 2026 | 9.3 | 9.280 | -0.020 | Within tolerance |
| Feb 2026 | 9.3 | 9.296 | -0.004 | Within tolerance |
| Mar 2026 | 8.7 | 8.745 | 0.045 | Within tolerance |
| Apr 2026 | 9.1 | 9.124 | 0.024 | Within tolerance |
| May 2026 | 9.1 | 9.133 | 0.033 | Within tolerance |
| Jun 2026 | 9.1 | 9.140 | 0.040 | Within tolerance |
| Jul 2026 | 9.2 | 9.182 | -0.018 | Within tolerance |
| Aug 2026 | 9.1 | 9.094 | -0.006 | Within tolerance |
| Sep 2026 | 9.2 | 9.192 | -0.008 | Within tolerance |
| Oct 2026 | 9.6 | 9.598 | -0.002 | 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.