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

17 rows where street_name = "ROSE" and street_type = "WK"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, latitude, longitude

zipcode 1

street_type 1

street_name 1

  • ROSE · 17 ✖
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
10453 10453 10453 060 246800800 2567 Rose Walk 2567 ROSE WALK 2567 ROSE WK 2567.0 ROSE WK     Berkeley 94708 37.8833544485951 -122.26078916830956
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
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
38571 38571 38571 060 246800800 2577 Rose Walk 2577 ROSE WALK 2577 ROSE WK 2577.0 ROSE WK     Berkeley 94708 37.8833544485951 -122.26078916830956
46502 46502 46502 060 246800702 2507 Rose Walk 2507 ROSE WALK 2507 ROSE WK 2507.0 ROSE WK     Berkeley 94708 37.88325745430421 -122.26164003188546
49417 49417 49417 060 246800702 2501 Rose Walk 2501 ROSE WALK 2501 ROSE WK 2501.0 ROSE WK     Berkeley 94708 37.88330753503286 -122.26163941564118
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);