Housing Pipeline (162 projects, 755 events)
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
Queries
- Projects by Units
- Projects with Affordable Units
- Processing Time Analysis
- Events by Project
- Recent Processing Events
- Staff Activity
- Density Bonus Projects
- Entitled Projects
Tables
building_permits
id, project_id, permit_number, permit_type, address, status, filed_date, finaled_date, job_value, description, owner, applicant, source, imported_at
11 rows
permit_events
id, project_id, address, permit_number, stage, action, event_date, assigned_to, marked_by, comment, stage_status, source, imported_at, permit_type
755 rows
project_permits
id, project_id, permit_number, permit_type, permit_module, address, filed_date, status, status_date, is_primary, source, imported_at, permit_year, permit_sequence, permit_prefix
69 rows
projects
id, address, apn, owner, units, new_units, old_units, permits, description, status, construction_status, latitude, longitude, height_stories, height_feet, year, unit_category, tenure, project_size_category, sb35_flag, sb330_flag, ab2011_flag, density_bonus, density_bonus_pct, vli_units, app_filed, app_complete, entitled, bp_issued_date, co_date, construction_start, estimated_completion, total_processing_days, accela_status, accela_status_date, app_packet_size_mb
162 rows