berkeley_housing_map: projects: 4 rows where status = "Corrections Pending Applicant" and unit_category = "5+" sorted by units descending

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

4 rows where status = "Corrections Pending Applicant" and unit_category = "5+" sorted by units descending

descending

Link	rowid	id	address	apn	units ▲	new_units	old_units	permits	description	status	latitude	longitude	height_stories	height_feet	year	unit_category	tenure	project_size_category	sb35_flag	sb330_flag	ab2011_flag	density_bonus	vli_units	app_filed	app_complete	accela_status	accela_status_date	app_packet_size_mb
11	11	11	1581 UNIVERSITY Ave	057 207100601	158.0	158.0	0.0	ZP2024-0074	SB-330 Project - Demolition of 2 existing non-landmarked mixed-use structures and surface parking to construct a new 88'6", 7-story, 158-unit mixed-use housing development with 96,256 sq ft of new residential space, 1788 sq ft of commercial space, and 32 parking spaces. 14 units (15%) of base project units are VLI; 9 units (10%) are moderate-income households; project entitled to 82.5% density bonus, waviers, and up to 4 concessions under the State Density Bonus Law.	Corrections Pending Applicant	37.870882755452506	-122.28064826022822	7.0	158.0	2024.0	5+	Renter	Mega (100+)	False	False	False	True	0.0	2024-07-12	2024-11-07	Application Processing: Corrections - Pending Applicant	2024-12-05	0.0
19	19	19	2450 SHATTUCK Ave	055 189700600	94.0	94.0	0.0	ZP2024-0047	SB-330 Mixed-Use Housing Development Project for the construction of an eight story building with 94 residential units, 2,438-sqft of retail space; 4,653-sqft of residential amenities and lobbies. Amenity roof terrace provided on top level. A total of 134,115-sqft.	Corrections Pending Applicant	37.864568726306736	-122.26795078029971			2024.0	5+	Renter	Very Large (51-100)	False	False	False	False	0.0	2024-05-16	2024-09-06	Application Processing: Corrections - Pending Applicant	2024-11-01	0.0
22	22	22	2955 SHATTUCK Ave	053 158901801	74.0	74.0	0.0	ZP2024-0071	State Density Bonus Project to merge two lots and demolish (2) existing 2-story commercial structures and (1) existing 1-story commercial structure. The proposed project is an 8-story, 75-feet, 80,682-sqft mixed-use building with 74 dwelling units, ground level retail space, and a ground level parking garage with 24 parking spaces. This will include 4 affordable units.	Corrections Pending Applicant	37.85577704614729	-122.26623093862028	2.0	75.0	2024.0	5+	Renter	Very Large (51-100)	False	False	False	True	0.0	2024-07-03	2024-08-21	Application Processing: Corrections - Pending Applicant	2025-07-25	24.11
37	37	37	2614 TELEGRAPH Ave	055 183600800	31.0	32.0	1.0	ZP2024-0027	SB-330 Mixed-Use Housing Development Project. Use Permit to merge two parcels, demolish a single-family dwelling (2614 Telegraph) and a commercial office (2417 Carleton), and construct a 38,000 square-foot, 5-story (57-foot) mixed-use building with 32 dwelling units (3 Very Low-Income, 2 Low-Income), and 605 sq. ft. of commercial space, using a State Density Bonus.	Corrections Pending Applicant	37.86268272962413	-122.25913983449848	5.0	57.0	2024.0	5+	Renter	Large (21-50)	False	False	False	True	3.0		2025-04-30			0.0

Advanced export

JSON shape: default, array, newline-delimited

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);

All Projects (162)

4 rows where status = "Corrections Pending Applicant" and unit_category = "5+" sorted by units descending

Advanced export