Housing Projects

Projects linked to addresses

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

3 rows where data_source = "official_permit" and status = "Pending Final Action" sorted by net_units descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: net_units

status 1

  • Pending Final Action · 3 ✖

data_source 1

  • official_permit · 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
70 70 70 212.0 3001 BENVENUE Ave 1.0 Pending Final Action official_permit 1 0 37.85584052170821 -122.25370441887011  
77 77 77 528.0 1420 FIFTH St 1.0 Pending Final Action official_permit 1 0 37.87654884158006 -122.3019522159246  
94 94 94 39172.0 2145 GRANT St 0.0 Pending Final Action official_permit 1 0 37.86891842367285 -122.27466130955813  

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