Housing Projects
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
3 rows where status = "Approved" sorted by net_units descending
This data as json, CSV (advanced)
Suggested facets: has_media_coverage
data_source 2
- both 2
- official_permit 1
status 1
- Approved · 3 ✖
| Link | rowid | project_id | address_id | address_display | net_units ▲ | status | data_source | has_official_permit | has_media_coverage | latitude | longitude | primary_news_source |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 | 15 | 15 | 57084.0 | 2109 VIRGINIA St | 131.0 | Approved | both | 1 | 1 | 37.87677757653766 | -122.26852368805868 | SFYimby |
| 62 | 62 | 62 | 48730.0 | 2201 BLAKE St | 3.0 | Approved | both | 1 | 1 | 37.86364315221662 | -122.264826999392 | SFYimby |
| 82 | 82 | 82 | 33217.0 | 3035 COLBY St | 0.0 | Approved | official_permit | 1 | 0 | 37.85409909022599 | -122.25726526879114 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "projects" ( "project_id" INTEGER, "address_id" REAL, "address_display" TEXT, "net_units" REAL, "status" TEXT, "data_source" TEXT, "has_official_permit" INTEGER, "has_media_coverage" INTEGER, "latitude" REAL, "longitude" REAL, "primary_news_source" TEXT ); CREATE INDEX idx_projects_address_id ON projects(address_id);