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 = "both" and status = "Incomplete Pending Applicant" sorted by net_units descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: primary_news_source

status 1

  • Incomplete Pending Applicant · 6 ✖

data_source 1

  • both · 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
12 12 12 16870.0 2115 KITTREDGE St 148.0 Incomplete Pending Applicant both 1 1 37.868856897471 -122.26718328846704 Berkeleyside
14 14 14 6853.0 2847 SHATTUCK Ave 132.0 Incomplete Pending Applicant both 1 1 37.85697777002751 -122.26638589710848 SFYimby
21 21 21 14798.0 2660 BANCROFT Way 78.0 Incomplete Pending Applicant both 1 1 37.868939 -122.255291 SFYimby
27 27 27 97.0 2441 LE CONTE Ave 65.0 Incomplete Pending Applicant both 1 1 37.8770218450383 -122.26186635613308 SFYimby
34 34 34 12732.0 2680 BANCROFT Way 37.0 Incomplete Pending Applicant both 1 1 37.86897721110546 -122.25493601002294 SFYimby
40 40 40 845.0 1710 UNIVERSITY Ave 16.0 Incomplete Pending Applicant both 1 1 37.87074957709555 -122.27712191190231 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);