These slides are from an independent, permit-level reconstruction of Berkeley's housing pipeline from primary sources — every building and zoning permit from 2015 to 2026, the County Assessor's roll, the city's filings to the state — plus Berkeley business licenses, County property ownership files, and more.
The scope: 82,065 permit records. ■ Building permits ■ Zoning & planning cases — filed per year:
And the city those records describe — next slide: Berkeley in one breath.
Every number on these slides traces to a public record. The method is published and audited: our count vs the city's official state filing differs by 130 units out of ~4,200 — and every row of that difference, in both directions, is named. → berkeleybuild.com/housing-audit.html
PL Multi-City Open Data APR Test →
UC Berkeley: 46,151 students (fall 2025, its largest ever) + 13,422 faculty and staff — roughly a third of the city turns over with the academic calendar — and ≈5,200 new student beds are in UC's construction pipeline.
Behind the tap: EBMUD's local distribution runs 250–400 miles of pressurized water mains under Berkeley's streets, with many tanks and pumping plants lifting water into the hills. Next iterations add the other daily flows: power and data.
The corridors that carry 48% of the new housing are the 22 arterial miles — one-tenth of the street network. Under it all: the sewers are mostly 6-inch vitrified-clay pipe (mains run 6–18 inches), and the city has rehabilitated 227 of the 254 miles since 1986 — the pipes are older than every building on the deck.
Berkeley is 6,156 acres. The city's own watershed plan counts 848 acres of streets + 182 acres of sidewalks — 17% of the city is public pavement before a single roof or parking lot is counted. Where the city has measured whole watersheds, imperviousness runs 34% (Gilman, near the hills) to 55% (Potter, the flats) — rain that once soaked in now runs to the Bay through the storm drains.
4,229 homes completed 2018–2025 · +216 so far in 2026 · +772 UC beds
Counted at the certificate of occupancy — keys in doors, not approvals — permit by permit: the same fine-grained count the Audit page checks against the city's state filing, every one of its 845 permits located by the feed's own street fields. 48% of the units came from the 11% of permits on the 14 commercial corridors (■ 94 corridor permits, 2,016 units); the other ■ 751 permits — ADUs and small infill, the neighborhood fabric — added 2,213. Top corridors: Shattuck 590 · San Pablo 513 · University 407 · Telegraph 150.
CO = certificate of occupancy: the city's final inspection sign-off that a building is safe and lawful to live in. We count a home only at this moment — not when it is approved, not when it is permitted — so every unit on this chart is a door someone can open.
■ corridor completions ■ neighborhood fabric — dot area ∝ units, on the County's own parcel fabric (every gray point is one of Berkeley's 29,131 parcels). The pattern the numbers promised: a few large gold dots on the arterials; a blue mist of ADUs across every neighborhood.
4,005 of 4,229 units located (95%); 224 units on 7 permits not yet mappable — their permit-era parcels were re-platted or merged after construction and the crosswalk holds them for review rather than guessing (the standing never-auto-re-point rule).
The same 4,229 completed homes, split by building size instead of street: ■ buildings over 4 units delivered 3,382 units on just 53 permits; ■ small projects (1–4 units, mostly ADUs) delivered 847 on 792. The small stream is a metronome — 67–135 units every single year, through COVID, rate spikes, everything — while the tower stream swings 4× with the financing cycle. Policy reads: the ministerial lane produces reliability; the big buildings produce volume.
Our total units completed match the city's official numbers almost exactly (ours | city's state filing) — 2022: 836 | 828 · 2023: 720 | 716 · 2024: 715 | 708. In 2025 — 600 | 492 — most of the gap is two completed group-living buildings the city's filing omits (80 units: a 41-unit project on San Pablo and the 39-unit 1367 University), plus a tail of small ADU completions. Every row of the difference is named.
■ intake (application → deemed complete) ■ consideration (deemed complete → entitlement) ■ entitled — waiting for building permit ■ construction ● certificate of occupancy
† application date recovered from the city's own planning portal records (use-permit / design-review filings at the address; record numbers in the generator); building-permit dates for the CO-import rows recovered from the permit feed. ※ milestones still unrecorded. Muted bars = the stages between application and completion are unrecorded (permit predates the 2018 feed).
■ intake (application → deemed complete) ■ consideration (deemed complete → entitlement) ■ entitled — waiting for building permit ■ construction ● certificate of occupancy
Gold bars run to today. The specimen to see: 1701 San Pablo — entitled in 2013, a decade in the gray waiting room before its 2023 building permit.
■ intake (application → deemed complete) ■ consideration (deemed complete → entitlement) ■ entitled — waiting for building permit ■ construction ● certificate of occupancy
The orange is the finding: for these majors the median consideration stage (deemed complete → entitlement) runs 410 days — the back-and-forth intake before it, 113. The clock the law tracks starts at deemed-complete; that's the stage to watch.
All 87 major (≥50-unit) housing applications in our record: 59 entitled, 33 reached a building permit, 25 completed (2,458 units delivered) — and not one denied. The pipe doesn't close; it narrows by waiting: 26 entitled projects (5,366 units) sit in the waiting room and 27 (3,793 units proposed) haven't reached entitlement yet. 1 (58 units) were withdrawn by their applicants — the only exits are voluntary. (Three more permitted projects carry a "withdrawn" status — flagged to the stalled register, kept as under-construction here because their issued permits are hard evidence.)
3 days
Median time from application to permit for an ADU — across 2,881 ADU permits since 2018. The ministerial lane demonstrably works. Solar is the biggest fast lane of all: 1,076 permits in the last 13 months.
Completed ADUs by certificate-of-occupancy year (permit final). The curve follows the 2017–2020 state ministerial mandates with the expected construction lag; another 767 ADU permits are issued and in construction.
| Applications (Nov 2025–Jun 2026) | 28 (~3.5/month, no growth trend yet) |
|---|---|
| Outcomes | 15 approved · 0 denied · 6 under review |
| What they build | two-thirds are additions/remodels to existing homes |
| Net new units proposed | ~15–20 in the entire first year (one application removes a unit) |
It neither flooded neighborhoods nor failed: today it is a homeowner-flexibility tool more than a housing-production engine. SB 9, meanwhile, is essentially unused in Berkeley (zero applications).
189 days median · 527 days 90th pct.
…from application to permit issuance for new-housing projects (928 permits). End to end, the slowest tenth of completed housing takes 3.5+ years from application to finished building. One 63-unit building (2527 San Pablo) waited 4.9 years for its permit.
48% of units · 11% of permits
2018–2025, 94 corridor permits produced 2,016 units; 751 neighborhood-fabric permits produced 2,213. The big buildings carry the totals (80% of all units came from 5+-unit buildings); the fabric stream (ADUs, Middle Housing) is many hands, small numbers — and touches zero storefronts.
| Corridor | Units 2018–2025 |
|---|---|
| Shattuck | 590 |
| San Pablo | 513 |
| University | 407 |
| Telegraph | 150 |
| Permitted construction | ~$250M/year of declared valuation (2022 peak: $338M)derived |
|---|---|
| Building fees | ~$4–7M/yr at an illustrative 2% effective ratemodeled — actuals requested |
| New tax base | 40+-unit completions since 2018 added $857M of assessed improvements → ≥$8.6M/year at the 1% base levy alonederived |
One building — 1951 Shattuck — now carries $70.4M of improvements: ≈$704k/yr in base property tax. Fiscally, one corridor tower ≈ a thousand ADUs; ADUs add homes at near-zero fiscal and commercial footprint. And the $0 rows are honest: new completions awaiting reassessment, and nonprofit projects that are exempt — affordable housing pays in homes, not taxes. The portfolio beats either simplistic story.
We tested both cities' permit systems this week — same software (Accela), same county, very different windows. This is what a homeowner or developer sees without filing a single records request:
| Oakland | Berkeley | |
|---|---|---|
| Bulk export of permit records | One click — a full month (2,351 records, with descriptions) downloads instantly | None — 10 records per page; a full pull requires scraping or a CPRA |
| Where an application sits | Full lifecycle public: Pending–Incomplete, Intake–Completed, In Review, On Hold — the statutory-clock states | Terse Issued / Finaled; the clock states exist in the system but aren't shown |
| What kind of project it is | Pre-classified record types (1–2 unit vs 3+ residential vs commercial; New vs Alteration; SolarApp+) | Generic "Building Permit" |
Why it matters for housing: an applicant who can see the queue plans with confidence — openness is a subsidy that costs nothing. And Berkeley can leapfrog: Oakland hides its milestone dates too. Publish the permit feed with dates and clock states and Berkeley becomes the East Bay's transparency benchmark, not its laggard.
display:none). Showing it is a display setting, not a data project.The record that produced these slides watches itself: the state filing is re-pulled and diffed on schedule (five mechanical error-detectors, anchor-validated), business licenses snapshot monthly, and the permit stream refreshes by harvest and CPRA. When the city's numbers move, we know the week it happens — and every claim keeps its receipt.
berkeleybuild.com · the Audit page · the Explorer · the open curriculum (anyone can rebuild this record — and now, any city's).