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

19 rows where street_type = "CI" and zipcode = 94708

✎ View and edit SQL

This data as json, CSV (advanced)

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

street_name 4

zipcode 1

  • 94708 · 19 ✖

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
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
5874 5874 5874 060 248400900 2 Harvard Cir 2 HARVARD CIR 2 HARVARD CI 2.0 HARVARD CI     Berkeley 94708 37.883082362563755 -122.25057415482097
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
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
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
23368 23368 23368 060 249000101 2 Wilson Cir 2 WILSON CIR 2 WILSON CI 2.0 WILSON CI     Berkeley 94708 37.88119895906059 -122.24898913229936
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
54270 54270 54270 060 248401300 1 Harvard Cir 1 HARVARD CIR 1 HARVARD CI 1.0 HARVARD CI     Berkeley 94708 37.882788065019554 -122.25064665784754

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);