home / berkeley_housing_map

All Projects (162)

Housing projects in Berkeley's development pipeline - 10,155 total units

Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS

id
Unique project identifier
address
Project street address
apn
Assessor's Parcel Number
owner
Property owner name
units
Net new dwelling units
new_units
Total new units proposed
old_units
Existing units demolished
permits
Comma-separated permit numbers (ZP, PLN, B prefixes)
description
Project description from permit application
status
Current planning status (Approved, Under Review, etc.)
construction_status
Construction phase status
latitude
Latitude coordinate
longitude
Longitude coordinate
height_stories
Building height in stories
height_feet
Building height in feet
year
Year application filed
unit_category
Size category (SFD, 2-4, 5+)
tenure
Owner or Renter
project_size_category
small/medium/large/major
sb35_flag
SB 35 streamlined approval
sb330_flag
SB 330 Housing Crisis Act
ab2011_flag
AB 2011 Affordable Housing
density_bonus
State Density Bonus used
density_bonus_pct
Density bonus percentage
vli_units
Very Low Income affordable units
app_filed
Application filed date
app_complete
Application deemed complete date
entitled
Entitlement/approval date
bp_issued_date
Building permit issued date
co_date
Certificate of Occupancy date
construction_start
Construction start date
estimated_completion
Estimated completion date
total_processing_days
Days from filed to entitled
accela_status
Most recent Accela processing status
accela_status_date
Date of Accela status
app_packet_size_mb
Application packet size in MB

2 rows where construction_status = "occupied", tenure = "Renter" and unit_category = "5+" sorted by units descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: co_date (date), construction_start (date), estimated_completion (date)

density_bonus 2

  • False 1
  • True 1

year 1

  • 2024.0 2

unit_category 1

  • 5+ · 2 ✖

tenure 1

  • Renter · 2 ✖

status 1

  • Completed 2

construction_status 1

  • occupied · 2 ✖
Link rowid id address apn owner units ▲ new_units old_units permits description status construction_status latitude longitude height_stories height_feet year unit_category tenure project_size_category sb35_flag sb330_flag ab2011_flag density_bonus density_bonus_pct vli_units app_filed app_complete entitled bp_issued_date co_date construction_start estimated_completion total_processing_days accela_status accela_status_date app_packet_size_mb
153 153 154 2001 ASHBY Ave 053 159101803   87.0 87.0 0.0 TBD 87 units, 86 affordable. Resources for Community Development. OPEN June 2025. Completed occupied 37.85541723 -122.26832199     2024.0 5+ Renter Very Large (51-100) False False False True   86.0         2025-06-01 2023-06-01 2025-06-01   Open   0.0
157 157 158 1367 UNIVERSITY Ave 057 207300500   39.0 39.0 0.0 TBD 39 units supportive housing. Panoramic Interests. OPEN July 2025. Completed occupied 37.87028242 -122.28519012     2024.0 5+ Renter Large (21-50) False False False False   39.0         2025-07-01 2023-07-01 2025-07-01   Open   0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "projects" (
"id" INTEGER,
  "address" TEXT,
  "apn" TEXT,
  "owner" TEXT,
  "units" REAL,
  "new_units" REAL,
  "old_units" REAL,
  "permits" TEXT,
  "description" TEXT,
  "status" TEXT,
  "construction_status" TEXT,
  "latitude" REAL,
  "longitude" REAL,
  "height_stories" REAL,
  "height_feet" REAL,
  "year" REAL,
  "unit_category" TEXT,
  "tenure" TEXT,
  "project_size_category" TEXT,
  "sb35_flag" TEXT,
  "sb330_flag" TEXT,
  "ab2011_flag" TEXT,
  "density_bonus" TEXT,
  "density_bonus_pct" REAL,
  "vli_units" REAL,
  "app_filed" TEXT,
  "app_complete" TEXT,
  "entitled" TEXT,
  "bp_issued_date" TEXT,
  "co_date" TEXT,
  "construction_start" TEXT,
  "estimated_completion" TEXT,
  "total_processing_days" REAL,
  "accela_status" TEXT,
  "accela_status_date" TEXT,
  "app_packet_size_mb" REAL
);
CREATE INDEX idx_projects_address ON projects(address);
CREATE INDEX idx_projects_status ON projects(status);
Powered by Datasette · Queries took 46.32ms · Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS