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

28 rows where street_type = "WK"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: street_number, 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
2319 2319 2319 060 246800702 2525 Rose Walk 2525 ROSE WALK 2525 ROSE WK 2525.0 ROSE WK     Berkeley 94708 37.88327706332237 -122.26142840856744
3754 3754 3754 060 246800800 2565 Rose Walk 2565 ROSE WALK 2565 ROSE WK 2565.0 ROSE WK     Berkeley 94708 37.8833544485951 -122.26078916830956
4749 4749 4749 060 246800702 2527 Rose Walk 2527 ROSE WALK 2527 ROSE WK 2527.0 ROSE WK     Berkeley 94708 37.883282566637035 -122.26139514664744
7276 7276 7276 059 224800100 2500 Rose Walk 2500 ROSE WALK 2500 ROSE WK 2500.0 ROSE WK     Berkeley 94708 37.88300146882383 -122.2614363406914
7314 7314 7314 060 246800702 2519 Rose Walk 2519 ROSE WALK 2519 ROSE WK 2519.0 ROSE WK     Berkeley 94708 37.88326519382982 -122.26150483902843
7628 7628 7628 060 246800800 2555 Rose Walk 2555 ROSE WALK 2555 ROSE WK 2555.0 ROSE WK     Berkeley 94708 37.8833544485951 -122.26078916830956
9957 9957 9957 061 256400100 10 Terrace Walk 10 TERRACE WALK 10 TERRACE WK 10.0 TERRACE WK     Berkeley 94707 37.888725731916935 -122.2719881882756
10453 10453 10453 060 246800800 2567 Rose Walk 2567 ROSE WALK 2567 ROSE WK 2567.0 ROSE WK     Berkeley 94708 37.8833544485951 -122.26078916830956
15856 15856 15856 061 256301600 21 Terrace Walk 21 TERRACE WALK 21 TERRACE WK 21.0 TERRACE WK     Berkeley 94707 37.88883351779078 -122.27157817831532
16106 16106 16106 060 246801002 2537 Rose Walk 2537 ROSE WALK 2537 ROSE WK 2537.0 ROSE WK     Berkeley 94708 37.88352482764198 -122.26099915040557
16965 16965 16965 060 246800702 2511 Rose Walk 2511 ROSE WALK 2511 ROSE WK 2511.0 ROSE WK     Berkeley 94708 37.88326024495775 -122.26159677800452
17999 17999 17999 059 224800200 2518 Rose Walk 2518 ROSE WALK 2518 ROSE WK 2518.0 ROSE WK     Berkeley 94708 37.883001505692334 -122.26126275922908
19988 19988 19988 061 257200800 1011 Fountain Walk A 1011 FOUNTAIN WALK A 1011 FOUNTAIN WK 1011.0 FOUNTAIN WK A   Berkeley 94707 37.88950495497251 -122.272191530025
22689 22689 22689 061 256400300 30 Terrace Walk 30 TERRACE WALK 30 TERRACE WK 30.0 TERRACE WK     Berkeley 94707 37.8884270571345 -122.27165098407414
23977 23977 23977 061 256301500 29 Terrace Walk 29 TERRACE WALK 29 TERRACE WK 29.0 TERRACE WK     Berkeley 94707 37.88882149180604 -122.2713876312705
24879 24879 24879 060 246800702 2523 Rose Walk 2523 ROSE WALK 2523 ROSE WK 2523.0 ROSE WK     Berkeley 94708 37.88327083114771 -122.26146255622636
25453 25453 25453 060 246800702 2505 Rose Walk 2505 ROSE WALK 2505 ROSE WK 2505.0 ROSE WK     Berkeley 94708 37.88328144144246 -122.2616144281032
27728 27728 27728 060 246800800 2553 Rose Walk 2553 ROSE WALK 2553 ROSE WK 2553.0 ROSE WK     Berkeley 94708 37.8833544485951 -122.26078916830956
33369 33369 33369 061 256301700 15 Terrace Walk 15 TERRACE WALK 15 TERRACE WK 15.0 TERRACE WK     Berkeley 94707 37.88889373346834 -122.2717132409166
35046 35046 35046 061 257200800 1011 Fountain Walk 1011 FOUNTAIN WALK 1011 FOUNTAIN WK 1011.0 FOUNTAIN WK     Berkeley 94707 37.88950495497251 -122.272191530025
38571 38571 38571 060 246800800 2577 Rose Walk 2577 ROSE WALK 2577 ROSE WK 2577.0 ROSE WK     Berkeley 94708 37.8833544485951 -122.26078916830956
44306 44306 44306 061 256400300 28 Terrace Walk 28 TERRACE WALK 28 TERRACE WK 28.0 TERRACE WK     Berkeley 94707 37.8884270571345 -122.27165098407414
45584 45584 45584 061 256400200 20 Terrace Walk 20 TERRACE WALK 20 TERRACE WK 20.0 TERRACE WK     Berkeley 94707 37.88855358045985 -122.27176397776384
46502 46502 46502 060 246800702 2507 Rose Walk 2507 ROSE WALK 2507 ROSE WK 2507.0 ROSE WK     Berkeley 94708 37.88325745430421 -122.26164003188546
48486 48486 48486 061 256000202 70 Terrace Walk 70 TERRACE WALK 70 TERRACE WK 70.0 TERRACE WK     Berkeley 94707 37.88807775424556 -122.27045974165058
49417 49417 49417 060 246800702 2501 Rose Walk 2501 ROSE WALK 2501 ROSE WK 2501.0 ROSE WK     Berkeley 94708 37.88330753503286 -122.26163941564118
50355 50355 50355 061 255901300 81 Terrace Walk 81 TERRACE WALK 81 TERRACE WK 81.0 TERRACE WK     Berkeley 94707 37.88837053971076 -122.27019947276332
54032 54032 54032 060 246800702 2515 Rose Walk 2515 ROSE WALK 2515 ROSE WK 2515.0 ROSE WK     Berkeley 94708 37.88323473202792 -122.26158082931497

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