Metric migration / DS-01
DS-01 Residential building permits issued
Owner: Development Services. Unit: count. Reconciliation tolerance: 0.0.
Written definition
- Source
- EnerGov permits
- Calculation
- Count of residential building permits with an issue date in the month.
- Inclusions
- Permit type Residential Building (new single family, remodel or addition).
- Exclusions
- Void permits; trade and accessory permits.
- Time frame
- Calendar month of issue date.
- Definition status
- Accepted Office of Data and Innovation, 11/05/2026
As held in the legacy performance database (PerfDB)
- Name
- Residential building permits issued
- Note
- Count of residential building permits with an issue date in the month.
- Script
perf_ds_01.sql
CDR value against PerfDB
Calculation as run by the CDR
select date_trunc('month', issued_date)::date as month, count(*)::float as value from curated.fact_permit where permit_type = 'Residential Building' and status <> 'Void' and issued_date 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 4 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 109 | 136 | 153 | 135 | 148 | 161 | 153 | 137 | 157 | 132 | 127 | 157 | 143 |
Monthly reconciliation, latest run
| Month | PerfDB | CDR | Difference | Result |
|---|---|---|---|---|
| Oct 2025 | 109.0 | 109.000 | 0.000 | Within tolerance |
| Nov 2025 | 136.0 | 136.000 | 0.000 | Within tolerance |
| Dec 2025 | 153.0 | 153.000 | 0.000 | Within tolerance |
| Jan 2026 | 135.0 | 135.000 | 0.000 | Within tolerance |
| Feb 2026 | 148.0 | 148.000 | 0.000 | Within tolerance |
| Mar 2026 | 161.0 | 161.000 | 0.000 | Within tolerance |
| Apr 2026 | 153.0 | 153.000 | 0.000 | Within tolerance |
| May 2026 | 137.0 | 137.000 | 0.000 | Within tolerance |
| Jun 2026 | 157.0 | 157.000 | 0.000 | Within tolerance |
| Jul 2026 | 132.0 | 132.000 | 0.000 | Within tolerance |
| Aug 2026 | 127.0 | 127.000 | 0.000 | Within tolerance |
| Sep 2026 | 157.0 | 157.000 | 0.000 | Within tolerance |
| Oct 2026 | 143.0 | 143.000 | 0.000 | 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 | Out of tolerance | 1 |
| R-20261106-0200 | Within tolerance | 12 |
| 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.