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

32 rows where street_type = "CI"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: street_number, unit, longitude

These facets timed out: street_name

zipcode 2

street_type 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
4382 4382 4382 060 248502100 1 Columbia Cir 1 COLUMBIA CIR 1 COLUMBIA CI 1.0 COLUMBIA CI     Berkeley 94708 37.885295836163834 -122.251579446879
4721 4721 4721 060 249000501 14 Wilson Cir 14 WILSON CIR 14 WILSON CI 14.0 WILSON CI     Berkeley 94708 37.881347546932275 -122.24839428768117
5396 5396 5396 056 199705600 5 Acton Cir 5 ACTON CIR 5 ACTON CI 5.0 ACTON CI     Berkeley 94702 37.86831980170712 -122.28342177902351
5874 5874 5874 060 248400900 2 Harvard Cir 2 HARVARD CIR 2 HARVARD CI 2.0 HARVARD CI     Berkeley 94708 37.883082362563755 -122.25057415482097
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
6810 6810 6810 060 248502601 7 Columbia Cir 7 COLUMBIA CIR 7 COLUMBIA CI 7.0 COLUMBIA CI     Berkeley 94708 37.885118506735736 -122.25068097169476
6965 6965 6965 060 248401100 9 Harvard Cir 9 HARVARD CIR 9 HARVARD CI 9.0 HARVARD CI     Berkeley 94708 37.88303024398814 -122.2510592172266
7402 7402 7402 060 248502000 22 Columbia Cir 22 COLUMBIA CIR 22 COLUMBIA CI 22.0 COLUMBIA CI     Berkeley 94708 37.88539593667771 -122.2514429649396
7563 7563 7563 056 199705400 6 Acton Cir 6 ACTON CIR 6 ACTON CI 6.0 ACTON CI     Berkeley 94702 37.86835890784523 -122.2828606347032
9090 9090 9090 060 248502000 22 Columbia Cir 1 22 COLUMBIA CIR 1 22 COLUMBIA CI 22.0 COLUMBIA CI 1   Berkeley 94708 37.88539593667771 -122.2514429649396
9643 9643 9643 060 249000601 9 Wilson Cir 9 WILSON CIR 9 WILSON CI 9.0 WILSON CI     Berkeley 94708 37.88182467443985 -122.2486482998025
11878 11878 11878 060 248401200 3 Harvard Cir 3 HARVARD CIR 3 HARVARD CI 3.0 HARVARD CI     Berkeley 94708 37.88281581574528 -122.25092115964216
14591 14591 14591 056 199705300 4 Acton Cir 4 ACTON CIR 4 ACTON CI 4.0 ACTON CI     Berkeley 94702 37.868261666878816 -122.2828430897074
16617 16617 16617 060 248502400 15 Columbia Cir 15 COLUMBIA CIR 15 COLUMBIA CI 15.0 COLUMBIA CI     Berkeley 94708 37.88498765479078 -122.25100688676804
19775 19775 19775 060 248502500 11 Columbia Cir 11 COLUMBIA CIR 11 COLUMBIA CI 11.0 COLUMBIA CI     Berkeley 94708 37.88506518360899 -122.25087663015351
21536 21536 21536 056 199705500 11 Acton Cir 11 ACTON CIR 11 ACTON CI 11.0 ACTON CI     Berkeley 94702 37.86837590690003 -122.28317957435831
23368 23368 23368 060 249000101 2 Wilson Cir 2 WILSON CIR 2 WILSON CI 2.0 WILSON CI     Berkeley 94708 37.88119895906059 -122.24898913229936
24022 24022 24022 056 199705700 3 Acton Cir 3 ACTON CIR 3 ACTON CI 3.0 ACTON CI     Berkeley 94702 37.86819749002581 -122.28341320101087
26394 26394 26394 060 248301204 1 Harding Cir 1 HARDING CIR 1 HARDING CI 1.0 HARDING CI     Berkeley 94708 37.88149735686234 -122.25154368404924
27853 27853 27853 060 248502000 22 Columbia Cir 2 22 COLUMBIA CIR 2 22 COLUMBIA CI 22.0 COLUMBIA CI 2   Berkeley 94708 37.88539593667771 -122.2514429649396
30388 30388 30388 060 248502200 18 Columbia Cir 18 COLUMBIA CIR 18 COLUMBIA CI 18.0 COLUMBIA CI     Berkeley 94708 37.88505276777312 -122.25156942257874
34053 34053 34053 060 248502300 17 Columbia Cir 17 COLUMBIA CIR 17 COLUMBIA CI 17.0 COLUMBIA CI     Berkeley 94708 37.884955905464444 -122.25124521789776
36355 36355 36355 060 248401000 6 Harvard Cir 6 HARVARD CIR 6 HARVARD CI 6.0 HARVARD CI     Berkeley 94708 37.88319471349366 -122.25090090442916
40019 40019 40019 060 249000301 10 Wilson Cir 10 WILSON CIR 10 WILSON CI 10.0 WILSON CI     Berkeley 94708 37.881267050468814 -122.24864852258467
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
54270 54270 54270 060 248401300 1 Harvard Cir 1 HARVARD CIR 1 HARVARD CI 1.0 HARVARD CI     Berkeley 94708 37.882788065019554 -122.25064665784754
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);