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 permit_type = "Building Permit"

✎ View and edit SQL

This data as json, CSV (advanced)

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

status 2

permit_type 1

  • Building Permit · 5 ✖
Link rowid ▼ id project_id permit_number permit_type address status filed_date finaled_date job_value description owner applicant source imported_at
6 6 6 13 B2015-06033 Building Permit 2420 SHATTUCK AVE Finaled 2015-12-11 2015-11-04   Demolition of interior finishes, equipment, built-in seating and non-structural partition walls (TI under separate permit)     accela 2026-03-28 16:22:35
7 7 7 13 B2015-05395 Building Permit 2420 SHATTUCK AVE Finaled 2015-11-04 2015-11-04   Re-roof with Class A roof     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);