home / berkeley_address_centric

Housing Projects

Projects linked to addresses

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

6 rows where data_source = "official_permit" and status = "In Review" sorted by net_units descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: net_units

status 1

  • In Review · 6 ✖

data_source 1

  • official_permit · 6 ✖
Link rowid project_id address_id address_display net_units ▲ status data_source has_official_permit has_media_coverage latitude longitude primary_news_source
33 33 33 95.0 130 BERKELEY Sq 50.0 In Review official_permit 1 0 37.870858 -122.267959  
51 51 51 403.0 2942 COLLEGE Ave 4.0 In Review official_permit 1 0 37.857443359739634 -122.25346690790224  
55 55 55 1660.0 2221 FIFTH St 3.0 In Review official_permit 1 0 37.864346138994605 -122.29734734038708  
87 87 87 3542.0 1109 COWPER St 0.0 In Review official_permit 1 0 37.86759590004899 -122.29101743270444  
88 88 88 13663.0 705 ARLINGTON Ave 0.0 In Review official_permit 1 0 37.89747706176223 -122.27563396222864  
101 101 101 21610.0 385 VERMONT Ave 0.0 In Review official_permit 1 0 37.9032943088105 -122.27469798687288  

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 12.795ms · Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS