berkeley_housing_map: projects: 4 rows where density_bonus = "True" and status = "Incomplete Pending Applicant" 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 density_bonus = "True" and status = "Incomplete Pending Applicant" sorted by units descending

descending

Link	rowid	id	address	apn	owner	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	accela_status	accela_status_date	app_packet_size_mb
12	12	12	2115 KITTREDGE St	057 203000900	Aquarius Twins Inc	148.0	148.0	0.0	ZP2024-0131	Construction of a twenty-three-story building with a live performance theater and 148 dwelling units that will retain the original primary south facade of the building. The density bonus project includes 24 affordable units (12 VLI + 12 MI units) with residential amenity space and usable open space.	Incomplete Pending Applicant	37.868856897471	-122.26718328846704			2024.0	5+	Renter	Mega (100+)	False	False	False	True	12.0	2024-09-17	Completeness Review: Incomplete Pending Applicant	2024-10-16	0.0
14	14	14	2847 SHATTUCK Ave	053 168602000		132.0	136.0	4.0	ZP2022-0132, ZP2024-0077	SB-330 Project - Demolition of existing non-landmarked mixed-use structure and surface parking to construct a new 9-story, 102'0" in height, 136-unit mixed-use housing development with 55,849 sq ft of residential space and 2,503 sq ft commercial space. 14% of the base project's units will be VLI income households; Entitled to 46.25% density bonus, waivers, and up to 3 concessions under the State Density Bonus Law.	Incomplete Pending Applicant	37.85697777002751	-122.26638589710848	9.0	136.0	2024.0	5+	Renter	Mega (100+)	False	False	False	True	0.0	2022-11-23	Completeness Review: Incomplete Pending Applicant	2023-07-05	0.0
21	21	21	2660 BANCROFT Way	55-1871-20	AMI LLC &	78.0	78.0	0.0	ZP2023-0095	Construction of an 8-story residential development with 78 studio units in a 32,632 SF building. This project will include 8 affordable units for VLI households. Does not have vehicle parking, only bicycle parking is provided with residential amenities and useable open space. This is a State Density Bonus project.	Incomplete Pending Applicant	37.868939	-122.255291	8.0		2023.0	5+	Renter	Very Large (51-100)	False	False	False	True	0.0	2023-07-28	Completeness Review: Incomplete Pending Applicant	2023-07-28	0.0
27	27	27	2441 LE CONTE Ave	058 219300600		65.0	65.0	0.0	ZP2023-0089	Change the use from educational/religious facility to a residential hotel with 65 group living accommodations (7 Very-Low Income Units), and construct a five-story (48 feet average height) major residential addition for a total of 24,300 square feet gross floor feet, utilizing State Density Bonus	Incomplete Pending Applicant	37.8770218450383	-122.26186635613308			2023.0	5+	Renter	Very Large (51-100)	False	False	False	True	0.0	2023-07-21	ness Review [ACTIVE]: Incomplete Pending Applicant	2023-11-21	162.05

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 density_bonus = "True" and status = "Incomplete Pending Applicant" sorted by units descending

Advanced export