berkeley_housing_map: projects: 4 rows where status = "In Review", unit_category = "5+" and year = "2022.0" 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 = "In Review", unit_category = "5+" and year = "2022.0" sorted by units descending

descending

Link	rowid	id	address	apn	units ▲	new_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	entitled	total_processing_days	accela_status	accela_status_date	app_packet_size_mb
7	7	7	2601 SAN PABLO Ave	054 178501700	223.0	223.0	ZP2022-0171	Demolish existing development (includes vacant residential) to construct an 8-story mixed-use building 223 dwelling units over a 1,940 commercial space, utilizing density bonus.	In Review	37.859267643513995	-122.2886634855373	8.0		2022.0	5+	Renter	Mega (100+)	False	False	False	True	0.0	2023-01-13	2023-11-17			Completeness Review: Application Complete	2023-11-17	112.97
8	8	8	2920 SHATTUCK Ave	053 159000501	221.0	221.0	ZP2022-0116	Demolish two commercial buildings and construct a 10-story mixed-use residential building with 221 dwelling units, ground-floor retail, and nine uncovered parking spaces utilizing State Density Bonus.	In Review	37.856347300047105	-122.26693200991916	10.0		2022.0	5+	Renter	Mega (100+)	False	False	False	True	0.0	2022-10-04	2022-12-15			Completeness Review: Application Complete	2022-12-15	132.07
10	10	10	3000 SHATTUCK Ave	053 159200100	166.0	166.0	ZP2022-0046	Demolish the existing gas station, and construct a 10-story (114 feet) mixed-use building utilizing a Density Bonus, with 166 dwellings, including 17 Very Low-Income units, and 1,043 square-feet of commercial space.	In Review	37.855008098375635	-122.2667720415266	10.0	114.0	2022.0	5+	Renter	Mega (100+)	False	False	False	True	17.0	2022-05-11	2022-08-03	2025-03-11	1035.0	[COMPLETE] Hearing Notice: as: Notice Issued \|	2025-03-11	25.2
13	13	13	2420 SHATTUCK Ave	055 189600300	132.0	132.0	ZP2022-0149	Demolish two non-residential buildings and construct a 17-story mixed-use residential building with ground-floor commercial and 132 dwelling units utilizing State Density Bonus.	In Review	37.86528832390181	-122.26798878801938	17.0		2022.0	5+	Renter	Mega (100+)	False	False	False	True	0.0	2022-10-04	2023-12-01			Due 12/02/2023, assigned to TBD \| Marked as: Resubmittal Pending Staff \| on 11/02/2023 by Niloufar Karimzadegan: as: Application Complete \|	2023-12-01	117.96

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 = "In Review", unit_category = "5+" and year = "2022.0" sorted by units descending

Advanced export