home / berkeley_address_centric

Housing Projects

Projects linked to addresses

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

3 rows where status = "Pending" sorted by net_units descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: net_units, has_media_coverage

data_source 2

  • official_permit 2
  • both 1

status 1

  • Pending · 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
23 23 23 1529.0 2326 DURANT Ave 70.0 Pending both 1 1 37.86708906005523 -122.26226004280632 SFYimby
67 67 67 15388.0 1419 GRANT St 2.0 Pending official_permit 1 0 37.88042822672098 -122.27593470111776  
68 68 68 3052.0 1236 DWIGHT Way 2.0 Pending official_permit 1 0 37.861371781292114 -122.2857268632291  

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);
Powered by Datasette · Queries took 15.237ms · Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS