Berkeley Housing Pipeline Explorer

Berkeley Data Journalism and Civic Challenge

Last updated: Loading...
Data source: City of Berkeley Accela Permitting Portal | Independent Civic Data Audit
Explorer Dashboard View Project Map
Data as of: Loading...
--
Total Projects
--
Total Units
--
VLI Units
--
Median Processing Days

RHNA Progress (2023-2031)

Entitled: -- units Pipeline: -- units Target: 8,934 units

Building Permits Issued (RHNA Credit)

BP Units
--
from -- projects
BP VLI Units
--
--% of BP issued
CO Units
--
from -- projects
CO VLI Units
--
--% of CO issued
Note: Our data captures 83% of city's reported BPs. Difference is ADUs, SFDs, and smaller projects not in our pipeline tracking.

Beyond Building Permits: What RHNA Doesn't Measure

HCD measures housing progress by building permits issued. But permits don't build housing — construction does. Of Berkeley's -- pipeline units, only -- have building permits issued and only -- have confirmed certificates of occupancy. A complete measure of housing delivery should track:

  • Actual construction starts
  • Certificates of occupancy
  • Vacancy rates after completion
  • Lease-up timelines
  • Rental affordability at market rates
  • Purchase prices vs income levels
Data reliability: Of projects in our database, only 7 have confirmed construction data from city inspection records (408 units). Construction progress for most projects is estimated from news reporting and building permit status.
Stale approvals: Berkeley's 8,934-unit RHNA target counts a permit as progress even if construction never begins. Our data shows 10 approved projects (983 units) with no construction activity after 12+ months of approval.

The Entitlement-to-Construction Gap

Berkeley's housing pipeline narrows dramatically from approval to construction.

Key Finding: We searched the Building tab for 20 entitled projects representing over 3,000 units approved between 2021-2024. None had filed housing building permits. Berkeley's housing pipeline is heavily front-loaded with approvals but construction is not following. The gap between entitlement and building permit filing — not the approval process itself — may be the primary bottleneck in housing delivery.

Stalled Projects: Entitled with No Building Permit

Address Units Entitled Date Months Stalled BP Status
Total: -- projects --

Sorted by months since entitlement. Highlighted: 2128 Oxford (485 units) is the largest stalled project.

Affordable Housing Progress by Income Level

Very Low Income (VLI)
--
of 1,786 RHNA (--%)
Low Income (LI)
--
of 825 RHNA (--%)
Moderate Income (MOD)
--
of 1,416 RHNA (--%)
Above Moderate
--
of 5,261 RHNA (--%)

Units Entitled by Year & Income Level

Affordable Housing Metrics

Projects with VLI units -- projects
Density Bonus projects -- projects (-- units)
2025 ADUs (est. ABAG method) ~95 units
Berkeley total housing stock ~52,000 units
In-Lieu Fees Identified $11M (1 project)

Berkeley Housing: City + University

City-Permitted Projects
-- projects, -- units
Counted toward RHNA allocation
UC Berkeley Projects
-- projects, ~-- units/beds
Exempt from city zoning and RHNA
🏫2200 Bancroft Way: 23 stories, ~550 beds, under construction
🏫1950 Oxford St: 14 stories, ~772 beds, finishing
🏫2000 Channing Way: 26 stories, ~1,500 beds, proposed
Combined: -- projects, -- units
Note: UC Berkeley currently houses approximately 9,800 students in university housing. These three projects would add ~2,800 beds, increasing UC housing capacity by 29%. UC projects are exempt from city permitting and are not counted toward Berkeley's RHNA allocation of 8,934 units.

Notes on Housing Data

  • ADU Affordability: Per ABAG methodology, ADUs count as 30% VLI, 30% LI, 30% MOD, 10% Above Moderate
  • Estimates: LI/MOD counts are estimates based on density bonus requirements. Actual deed-restricted counts may vary.
  • In-Lieu Fees: $11M identified from 2128 Oxford. See CostAnal tab for full accountability analysis. Complete data requires City Affordable Housing Trust Fund records.

Projects by Status

Units by Year Filed

Permit Fees Tracked

Total Fees Tracked
$0
across 0 projects
Avg Fee per Project
$0
Avg Fee per Unit
$0
Large Fees (>$100k)
0

All Projects

Address Units Height Year Status Proc. Days Filed Complete Entitled

Project Timeline Gantt Chart

Completeness Review City Decision Post-Entitlement Construction Completed

Loading project timeline data...

Note: Construction start dates estimated from building permit "Issued" status. Green bars show projects with active building permits.

Project Lifecycle: Typical Path from Conception to Occupancy

Average timeline showing median days at each stage. Based on -- Berkeley housing projects.

Completeness Review
City Decision
Post-Entitlement
Construction

Lifecycle Summary

Processing Time Distribution

Units vs Processing Time

Processing Time by Project Size

Processing Time Trend by Year

Fee Analysis

Top 15 Projects by Total Fees

Units vs Total Fees

Fee per Unit by Project

Large Fees (>$100,000)

Project Amount Description

Fee Summary

Berkeley Skyline: Top 20 Projects by Height

🏙️ 3D Skyline — Google Earth

Fly through Berkeley's future skyline in 3D. See every proposed building at its actual height and location.

📥 Download Berkeley Skyline KML

How to view:

  1. Download the KML file above
  2. Open in Google Earth Web (File → Import KML) or Google Earth Pro
  3. Navigate to Berkeley to see 174 housing projects as 3D columns

Color legend: 🟡 Gold = UC Berkeley | 🟢 Green = Under Construction | 🔵 Blue = Completed | 🟠 Orange = Entitled | 🟡 Yellow = In Review | 🔴 Red = Stalled

2024 Citizen APR — Independent Verification

We independently reconstructed Berkeley's 2024 Annual Progress Report (APR) using primary data extracted directly from Accela permit records. This demonstrates that civic data auditing is feasible and that citizens can verify official housing reports.

Our Method
  • • Accela permit records extraction
  • • Address normalization
  • • APN cross-reference
  • • Status reconciliation with HCD data
Verification Results
  • • City reported: 117 projects
  • • We matched: 114 projects
  • • Match rate: 97.4%
  • • Unit counts aligned within ±5%
Conclusion

This successful independent verification demonstrates that civic data auditing is feasible using publicly available permit data.

2024 APR Comparison Results

114
Matched Projects
3
Unmatched (ADUs)
97.4%
Match Rate
Projects Potentially Missing from City's 2024 APR (885 units)
1974 Shattuck Ave
599 units
Entitled December 2024
1899 Oxford St
212 units
Pending final action
2955 Shattuck Ave
74 units
In corrections

City 2024 APR vs Our Independent Data

Address City Units Our Units Diff City Status Match

2025 Citizen APR

Independent analysis of Berkeley's 2025 housing production using primary data from Accela permits and field verification.

RHNA Progress (Building Permits Issued Only)
Income Level Permitted RHNA Target % of Goal
Very Low Income3491,78619.5%
Low Income281,0282.7%
Moderate Income281,4521.9%
Above Moderate9394,66820.1%
Total1,3448,93415.0%
Table A: Apps Complete in 2025
6
projects (877 units)
Table A2: Permitted in 2025
25
projects (2,928 units)
16 entitled, 1 BP, 8 CO
ADUs (estimated)
95
ABAG 30/30/30/10 split
Stalled Projects
31
4,508 units at risk
Key Finding: The Entitlement-to-Construction Gap

Berkeley has -- units in its pipeline (--% of RHNA) but only -- have building permits (--%). The entitlement-to-construction gap is the primary bottleneck preventing housing production.

Spatial Processing Analysis

Map showing projects colored by processing time, status, or affordability. Marker size = unit count.

Filter:
Color by:

Geographic Clusters

Modular & Off-Site Construction

Factory-built housing can reduce construction timelines by 30-50% while improving quality and reducing waste. Berkeley has an opportunity to lead in this space.

Berkeley Modular Projects

Panoramic Shattuck Studios — 2711 Shattuck Ave (2018)

22-unit steel modular building by Panoramic Interests. Modules manufactured off-site, assembled in weeks. One of Berkeley's first multi-story modular residential projects.

Completed Steel Modular

1598 University Ave (CITYSPACE Berkeley)

170-unit student housing project using cross-laminated timber (CLT) and modular construction.

Under Construction

Panoramic Regal — 2274 Shattuck Ave (Est. 2028)

299-unit, 22-story tower by Panoramic Interests using prefab low-waste construction. Car-free design.

Planned Prefab

Panoramic Southside — 2712 Telegraph Ave (Est. 2027)

40-unit, 6-story building by Panoramic Interests using prefab low-waste construction. Car-free design.

Planned Prefab

Construction Timeline Comparison

Source: McKinsey Global Institute, Modular Construction Report 2019

Global Leaders in Modular Construction

Sweden
84%
of single-family homes built with prefab components
Japan (Sekisui House)
2.5M+
homes built using factory methods since 1960
Holon / BROAD Group (Changsha)
75%
reduction in construction time
CIMC MBS (China)
30+
story modular buildings completed

Other notable companies: Lindbäcks (Sweden), BoKlok (IKEA/Skanska), Factory OS (Oakland), Katerra (closed 2021), Volumetric Building Companies

💡 Opportunity for Berkeley

  • Track construction method in building permits to measure modular adoption
  • Expedited permitting for pre-approved modular designs (following LA's pre-approved ADU program model)
  • Factory OS partnership – Oakland-based modular manufacturer could serve Berkeley projects
  • CLT/mass timber incentives – Lower carbon footprint, faster construction, fire-resistant
Policy Research in Progress
📊 Construction method data not yet captured in Berkeley building permits. Timeline comparisons require building permit to CO tracking.
Data Collection Needed

Process Cost Analysis

Estimating the true cost of housing development review

1 Conceptual Framework

A housing project's total cost includes not just construction, but public-sector staff time to review proposals and private-sector time and consultant costs to prepare submissions. We approximate these process costs using permit event data, staffing patterns, and review cycle counts extracted from Berkeley's Accela system.

City Review Costs
Staff hours × loaded rate for completeness review, CEQA, staff decisions, ZAB hearings
Developer Soft Costs
Permit fees + resubmittal cycles × consultant costs (architect, environmental, legal)
Carrying Costs
Interest on land + development financing during review period

2 City Staff Review Costs

$60 $95 (default) $150

Based on Berkeley Planner III salary (~$55/hr) + benefits (~$40/hr). Adjust to test sensitivity.

Staff Review Activity (from permit events)

Staff Member Projects Review Events Est. Hours Est. Cost

Staff names from public permit records. Hour estimates: 4 hrs/completeness review, 8 hrs/staff decision, 2 hrs/correction cycle, 16 hrs/ZAB prep. Methodology

Est. City Review Cost by Project (Top 20)

Cost Metrics

$4,750
Median city review cost per project
$285
Median city review cost per unit
2,450
Total estimated review hours (all projects)

3 Developer Proposal Costs

Resubmittal Cycles by Project

Events with "Incomplete" or "Corrections" status from permit_events

Cost per Resubmittal Cycle

Architect revisions $5,000 - $15,000
Environmental consultant $3,000 - $10,000
Attorney/permit expediter $2,000 - $5,000
Total per cycle (range) $10,000 - $30,000

Total Developer Soft Costs by Scenario

Low Estimate
$45,000
Fees + 2 cycles × $10K
Medium Estimate
$85,000
Fees + 3 cycles × $20K
High Estimate
$165,000
Fees + 4 cycles × $30K

4 Staff Workload Distribution

Review Events by Staff Member

Workload Concentration

47%
of all review events handled by top 3 staff
28
average events per staff member
12
staff members with review activity

Workload concentration may indicate specialization (good) or bottleneck risk (concern).

5 Process Cost as Share of Total Project Cost

Permit Fees as % of Construction Cost

Construction cost estimated at $400/sq ft × (units × 900 sq ft avg)

Cost Breakdown (Typical 100-Unit Project)

Hard costs (construction) $36,000,000
Soft costs (design, permits, legal) $5,400,000
Process costs (city review + resubmittals) $180,000

Key insight: Direct process costs appear small (~0.4%), but delay costs during the review period can add 3-5% to total project cost via carrying costs on land and construction financing.

Methodology & Data Notes

Data Sources

  • Permit events extracted from Berkeley Accela system
  • Staff names from public permit records
  • Fee data from individual permit detail pages

Hour Estimates

  • Completeness review: 4 hours
  • Staff decision: 8 hours
  • Correction cycle: 2 hours
  • ZAB hearing prep: 16 hours

Assumptions

  • Loaded hourly rate: $95 (adjustable)
  • Construction cost: $400/sq ft
  • Average unit size: 900 sq ft

Limitations

  • Estimates should be validated with city time-tracking
  • Developer costs vary significantly by project complexity
  • Some events may be logged inconsistently
Estimates Only — Requires Validation with Actual Time-Tracking Data

Affordable Housing In-Lieu Fee Accountability

Tracking developer contributions to Berkeley's Affordable Housing Trust Fund

Known In-Lieu Fee Commitments

Data Limitation Notice:

In-lieu fee payments are not recorded in Accela permit records. This analysis relies on public reporting, council records, and project descriptions. A complete accounting requires access to the City's Affordable Housing Trust Fund financial records.

Project Units In-Lieu Fee On-Site Affordable Source
2128 Oxford St 485 units $11,000,000 47 units (5 ELI + 42 VLI) Public reporting
Total Identified $11,000,000 47 units 1 project

Accountability Metrics

$11M
In-Lieu Fees Identified
From 1 documented project
~16 units
Affordable Units Equivalent
At $700K/unit (Terner Center avg)
47 units
On-Site Affordable Built
2128 Oxford (5 ELI + 42 VLI)

In-Lieu Fee vs. On-Site Affordable: Value Comparison

Density Bonus Projects Context

Berkeley has 56 density bonus projects representing 7,465 total units. These projects use California's State Density Bonus Law to receive increased density in exchange for affordable housing commitments (either on-site units or in-lieu fees).

56
Density Bonus Projects
7,465
Total Units
84+
VLI Units Documented
?
In-Lieu Projects (Unknown)

Key Finding: In-Lieu Fee Adequacy

At current Bay Area construction costs ($600-800K per affordable unit per Terner Center), the $11M in-lieu fee from 2128 Oxford could fund approximately 14-18 affordable units. However, the project is providing 47 on-site affordable units (5 ELI + 42 VLI), suggesting that on-site affordable housing delivers 3x more units than the equivalent in-lieu payment would provide.

Policy Question for City Auditor

How many affordable units have been built using Berkeley's Affordable Housing Trust Fund? This requires:

  • Total in-lieu fees collected since program inception
  • Affordable units actually constructed with Trust Fund dollars
  • Cost per unit achieved vs. in-lieu fee formula
  • Comparison to on-site affordable unit production
💧⚡

Infrastructure Capacity Analysis

Assess cumulative infrastructure demands from pipeline projects. Track water, sewer, electrical capacity, traffic impacts, and school enrollment projections. Identify capacity constraints before they cause delays.

Coming Soon — Requires Utility Connection Data
📊

Neighborhood Economic Impact

Measure how new housing affects local business activity, property values, and displacement risk. Replace anecdotal concerns about development impacts with measured outcomes using geocoded permit data (95.6% coverage achieved).

Coming Soon — Requires Business License Integration

Pipeline Players

Developers, architects, and project economics in Berkeley's housing pipeline. Who's building, how fast, and at what cost?

-
Developers
-
Architects
-
Property Owners
-
Developer Units
-
Total Fees Tracked

Top Developers by Unit Count

Developer Rankings

Major developers building housing in Berkeley. NX Ventures and Panoramic Interests lead the pipeline.

Panoramic Interests (Patrick Kennedy): 24 projects in Berkeley since 1990 totaling 700+ units including 70+ low-income units. Pioneer in modular/prefab construction — Shattuck Studios (2018) used steel modules; Regal (2274 Shattuck) and Southside (2712 Telegraph) will use prefab low-waste construction.
Developer Projects Total Units Total Fees Project Addresses

Architect Rankings

Known architects from project descriptions. Trachtenberg, Studio KDA, and SDT dominate Berkeley's housing pipeline.

Architect Projects Total Units Total Fees Sample Projects

Property Owners

Property owners from parcel records — often LLCs. These are distinct from developers who build the projects.

Owner Projects Total Units Total Fees Project Addresses

Project Economics

Estimated annual revenue and city fees. Revenue based on $3,000/mo market rate, $1,500/mo affordable. Fees estimated from unit count.

Address Units VLI Est. Annual Revenue Est. Fees Fee %

Slowest Projects (Processing Days)

Address Days Units Status

Fastest Projects (Processing Days)

Address Days Units Status

In-Lieu Fee Tracker

Developers who paid in-lieu fees instead of building affordable units. These fees go to the Affordable Housing Trust Fund.

Project Developer Total Units VLI Built In-Lieu Fee Units Avoided Notes

Data Limitations

  • • In-lieu fee data is limited. Only fees explicitly documented in permit records or public filings are included.
  • • Complete tracking requires access to City Finance/AHTF records.
  • • Economic estimates are rough approximations based on typical market rents and fee structures.