Building Permits (11)

Building permits linked to housing projects

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

id
Permit ID
project_id
Link to projects table
permit_number
Building permit number (B2023-00001 format)
permit_type
Type of permit (Building, Electrical, etc.)
address
Project address
status
Permit status
filed_date
Date filed
finaled_date
Date finaled
job_value
Construction value
description
Work description
owner
Property owner
applicant
Permit applicant
source
Data source
imported_at
Import timestamp

5 rows where status = "Closed Expired"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: project_id, address, filed_date (date), imported_at (date)

status 1

  • Closed Expired · 5 ✖
Link rowid ▼ id project_id permit_number permit_type address status filed_date finaled_date job_value description owner applicant source imported_at
1 1 1 17 B2005-02350 Building Permit (Electrical) 2109 MILVIA ST Closed Expired       Electrical - run conduit for pay station.     accela 2026-03-28 16:22:35
2 2 2 13 B2019-05657 Building Electrical Mechanical Plumbing Permit 2420 SHATTUCK AVE Closed Expired 2019-12-30     TI to convert old Gio's pizza to Edel restaurant, new kitchen layout, walk-in cooler     accela 2026-03-28 16:22:35
8 8 8 13 B1998-05207 Building Permit 2420 SHATTUCK AVE Closed Expired 1998-11-24     Add second layer of tar & paint     accela 2026-03-28 16:22:35
10 10 10 14 B2014-03919 Building Permit 2847 SHATTUCK AVE Closed Expired       Install two (2) exterior signs.     accela 2026-03-28 16:22:35
11 11 11 8 B1999-03755 Building Permit 2920 SHATTUCK AVE Closed Expired       T/O EXISTING ROOFING MATL. INSTALL CLASS A MODIFIED BITUMEN ROOF SYSTEM, HEAT WELDING SEAMS EDINOFF PETER & SUSAN & WORTH, 2920 Shattuck Ave Nicholas Rofing, 1816 San Pablo Ave, Berkeley CA 94702, (510)848-4433 accela 2026-03-28 16:22:35

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "building_permits" (
"id" INTEGER,
  "project_id" INTEGER,
  "permit_number" TEXT,
  "permit_type" TEXT,
  "address" TEXT,
  "status" TEXT,
  "filed_date" TEXT,
  "finaled_date" TEXT,
  "job_value" TEXT,
  "description" TEXT,
  "owner" TEXT,
  "applicant" TEXT,
  "source" TEXT,
  "imported_at" TEXT
);
CREATE INDEX idx_bp_permit ON building_permits(permit_number);