Building Permits (11)
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
1 row where permit_type = "Building Permit (Electrical)"
This data as json, CSV (advanced)
Suggested facets: imported_at (date)
status 1
permit_type 1
- Building Permit (Electrical) · 1 ✖
| 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 |
Advanced export
JSON shape: default, array, newline-delimited
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);