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

31 rows where street_name = "CLAREMONT" and street_type = "BL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, latitude, longitude

zipcode 1

street_type 1

street_name 1

  • CLAREMONT · 31 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
310 310 310 054 170207800 2808 Claremont Blvd 2808 CLAREMONT BLVD 2808 CLAREMONT BL 2808.0 CLAREMONT BL     Berkeley 94705 37.860358343410326 -122.2458004112814
407 407 407 054 170202300 2732 Claremont Blvd 2732 CLAREMONT BLVD 2732 CLAREMONT BL 2732.0 CLAREMONT BL     Berkeley 94705 37.86127776301685 -122.24728920267653
1624 1624 1624 054 170205600 2731 Claremont Blvd 2731 CLAREMONT BLVD 2731 CLAREMONT BL 2731.0 CLAREMONT BL     Berkeley 94705 37.861342650859434 -122.24660049219594
4519 4519 4519 054 170207700 2800 Claremont Blvd 2800 CLAREMONT BLVD 2800 CLAREMONT BL 2800.0 CLAREMONT BL     Berkeley 94705 37.860505849903426 -122.245835635122
5345 5345 5345 054 170209100 2960 Claremont Blvd 2960 CLAREMONT BLVD 2960 CLAREMONT BL 2960.0 CLAREMONT BL     Berkeley 94705 37.860417722784554 -122.24610055189255
6233 6233 6233 054 170212200 2815 Claremont Blvd 2815 CLAREMONT BLVD 2815 CLAREMONT BL 2815.0 CLAREMONT BL     Berkeley 94705 37.86026754161343 -122.24507937492535
8085 8085 8085 054 170202200 2728 Claremont Blvd 2728 CLAREMONT BLVD 2728 CLAREMONT BL 2728.0 CLAREMONT BL     Berkeley 94705 37.86142383930549 -122.2473005394154
8527 8527 8527 054 170209301 2840 Claremont Blvd 2840 CLAREMONT BLVD 2840 CLAREMONT BL 2840.0 CLAREMONT BL     Berkeley 94705 37.85922508848772 -122.24578115140172
11027 11027 11027 054 170204000 2701 Claremont Blvd 2701 CLAREMONT BLVD 2701 CLAREMONT BL 2701.0 CLAREMONT BL     Berkeley 94705 37.86232607496364 -122.24668420440064
15526 15526 15526 054 170208900 2946 Claremont Blvd 2946 CLAREMONT BLVD 2946 CLAREMONT BL 2946.0 CLAREMONT BL     Berkeley 94705 37.8603987112339 -122.24645352601884
19006 19006 19006 054 170205500 2733 Claremont Blvd 2733 CLAREMONT BLVD 2733 CLAREMONT BL 2733.0 CLAREMONT BL     Berkeley 94705 37.861205099232 -122.2465859709294
20411 20411 20411 054 170211200 2801 Claremont Blvd 2801 CLAREMONT BLVD 2801 CLAREMONT BL 2801.0 CLAREMONT BL     Berkeley 94705 37.86064187800171 -122.24519207037436
21428 21428 21428 054 170211800 2837 Claremont Blvd 2837 CLAREMONT BLVD 2837 CLAREMONT BL 2837.0 CLAREMONT BL     Berkeley 94705 37.85928400067768 -122.24487415659532
24332 24332 24332 054 170207900 2810 Claremont Blvd 2810 CLAREMONT BLVD 2810 CLAREMONT BL 2810.0 CLAREMONT BL     Berkeley 94705 37.860219542411656 -122.24578494947876
27684 27684 27684 054 170200100 2700 Claremont Blvd 2700 CLAREMONT BLVD 2700 CLAREMONT BL 2700.0 CLAREMONT BL     Berkeley 94705 37.86230498166711 -122.24738274784032
36207 36207 36207 054 170205800 2725 Claremont Blvd 2725 CLAREMONT BLVD 2725 CLAREMONT BL 2725.0 CLAREMONT BL     Berkeley 94705 37.86161534839338 -122.2466259019421
37242 37242 37242 054 170200200 2708 Claremont Blvd 2708 CLAREMONT BLVD 2708 CLAREMONT BL 2708.0 CLAREMONT BL     Berkeley 94705 37.86216882685275 -122.24736997918689
39360 39360 39360 054 170205400 2737 Claremont Blvd 2737 CLAREMONT BLVD 2737 CLAREMONT BL 2737.0 CLAREMONT BL     Berkeley 94705 37.861067608340846 -122.2465732058692
39578 39578 39578 054 170205300 2945 Claremont Blvd 2945 CLAREMONT BLVD 2945 CLAREMONT BL 2945.0 CLAREMONT BL     Berkeley 94705 37.86091343344328 -122.24655826778437
40582 40582 40582 054 170205900 2717 Claremont Blvd 2717 CLAREMONT BLVD 2717 CLAREMONT BL 2717.0 CLAREMONT BL     Berkeley 94705 37.861755040373694 -122.24663793577363
42622 42622 42622 054 170200300 2710 Claremont Blvd 2710 CLAREMONT BLVD 2710 CLAREMONT BL 2710.0 CLAREMONT BL     Berkeley 94705 37.862032036333105 -122.24735905477468
43976 43976 43976 054 170205700 2727 Claremont Blvd 2727 CLAREMONT BLVD 2727 CLAREMONT BL 2727.0 CLAREMONT BL     Berkeley 94705 37.86147866606585 -122.24661236343243
45530 45530 45530 054 170206200 2709 Claremont Blvd 2709 CLAREMONT BLVD 2709 CLAREMONT BL 2709.0 CLAREMONT BL     Berkeley 94705 37.86216491413832 -122.24667446486636
46182 46182 46182 054 170208800 2942 Claremont Blvd 2942 CLAREMONT BLVD 2942 CLAREMONT BL 2942.0 CLAREMONT BL     Berkeley 94705 37.86038799976974 -122.24663688025318
48922 48922 48922 054 170206000 2715 Claremont Blvd 2715 CLAREMONT BLVD 2715 CLAREMONT BL 2715.0 CLAREMONT BL     Berkeley 94705 37.861893500185985 -122.24665241751433
49433 49433 49433 054 170212301 2811 Claremont Blvd 2811 CLAREMONT BLVD 2811 CLAREMONT BL 2811.0 CLAREMONT BL     Berkeley 94705 37.86044075352055 -122.24503012299328
49675 49675 49675 054 170206100 2711 Claremont Blvd 2711 CLAREMONT BLVD 2711 CLAREMONT BL 2711.0 CLAREMONT BL     Berkeley 94705 37.86202898601303 -122.24666420969903
49953 49953 49953 054 170211800 2821 Claremont Blvd 2821 CLAREMONT BLVD 2821 CLAREMONT BL 2821.0 CLAREMONT BL     Berkeley 94705 37.85928400067768 -122.24487415659532
50454 50454 50454 054 170208701 2930 Claremont Blvd 2930 CLAREMONT BLVD 2930 CLAREMONT BL 2930.0 CLAREMONT BL     Berkeley 94705 37.86037872449017 -122.24680385280998
54542 54542 54542 054 170209000 2952 Claremont Blvd 2952 CLAREMONT BLVD 2952 CLAREMONT BL 2952.0 CLAREMONT BL     Berkeley 94705 37.86040817303776 -122.24628227478634
56101 56101 56101 054 170211900 2833 Claremont Blvd 2833 CLAREMONT BLVD 2833 CLAREMONT BL 2833.0 CLAREMONT BL     Berkeley 94705 37.85959767552251 -122.2450496487743

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