Master Address Table

62,226 Berkeley addresses with APNs and coordinates

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

13 rows where street_type = "CI" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, base_address, street_number, unit, latitude, longitude

zipcode 1

  • 94702 · 13 ✖

street_type 1

street_name 1

Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
2598 2598 2598 056 199705500 7 Acton Cir 7 ACTON CIR 7 ACTON CI 7.0 ACTON CI     Berkeley 94702 37.86837590690003 -122.28317957435831
5396 5396 5396 056 199705600 5 Acton Cir 5 ACTON CIR 5 ACTON CI 5.0 ACTON CI     Berkeley 94702 37.86831980170712 -122.28342177902351
6012 6012 6012 056 199705800 2 Acton Cir 2 2 ACTON CIR 2 2 ACTON CI 2.0 ACTON CI 2   Berkeley 94702 37.868021138485695 -122.28331463516297
7563 7563 7563 056 199705400 6 Acton Cir 6 ACTON CIR 6 ACTON CI 6.0 ACTON CI     Berkeley 94702 37.86835890784523 -122.2828606347032
14591 14591 14591 056 199705300 4 Acton Cir 4 ACTON CIR 4 ACTON CI 4.0 ACTON CI     Berkeley 94702 37.868261666878816 -122.2828430897074
21536 21536 21536 056 199705500 11 Acton Cir 11 ACTON CIR 11 ACTON CI 11.0 ACTON CI     Berkeley 94702 37.86837590690003 -122.28317957435831
24022 24022 24022 056 199705700 3 Acton Cir 3 ACTON CIR 3 ACTON CI 3.0 ACTON CI     Berkeley 94702 37.86819749002581 -122.28341320101087
42446 42446 42446 056 199705800 2 Acton Cir 2 ACTON CIR 2 ACTON CI 2.0 ACTON CI     Berkeley 94702 37.868021138485695 -122.28331463516297
45383 45383 45383 056 199705800 1 Acton Cir A 1 ACTON CIR A 1 ACTON CI 1.0 ACTON CI A   Berkeley 94702 37.868021138485695 -122.28331463516297
47348 47348 47348 056 199705400 6 Acton Cir 2 6 ACTON CIR 2 6 ACTON CI 6.0 ACTON CI 2   Berkeley 94702 37.86835890784523 -122.2828606347032
55645 55645 55645 056 199705500 9 Acton Cir 9 ACTON CIR 9 ACTON CI 9.0 ACTON CI     Berkeley 94702 37.86837590690003 -122.28317957435831
55784 55784 55784 056 199705300 4 Acton Cir 2 4 ACTON CIR 2 4 ACTON CI 4.0 ACTON CI 2   Berkeley 94702 37.868261666878816 -122.2828430897074
57968 57968 57968 056 199705800 1 Acton Cir 1 ACTON CIR 1 ACTON CI 1.0 ACTON CI     Berkeley 94702 37.868021138485695 -122.28331463516297

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "addresses" (
"address_id" INTEGER,
  "apn" TEXT,
  "address_full" TEXT,
  "address_normalized" TEXT,
  "base_address" TEXT,
  "street_number" REAL,
  "street_name" TEXT,
  "street_type" TEXT,
  "unit" TEXT,
  "unit_type" TEXT,
  "city" TEXT,
  "zipcode" INTEGER,
  "latitude" REAL,
  "longitude" REAL
);
CREATE INDEX idx_addresses_apn ON addresses(apn);
CREATE INDEX idx_addresses_base ON addresses(base_address);
CREATE INDEX idx_addresses_street ON addresses(street_name);
CREATE INDEX idx_addresses_zipcode ON addresses(zipcode);
CREATE INDEX idx_addresses_coords ON addresses(latitude, longitude);