Housing Projects

Projects linked to addresses

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

2 rows where data_source = "both" and status = "Approved" sorted by net_units descending

✎ View and edit SQL

This data as json, CSV (advanced)

status 1

  • Approved · 2 ✖

data_source 1

  • both · 2 ✖
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);