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

49 rows where street_name = "DANA" and zipcode = 94705

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

  • 94705 · 49 ✖

street_type 1

street_name 1

  • DANA · 49 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
55 55 55 052 157403700 3009 Dana St D 3009 DANA ST D 3009 DANA ST 3009.0 DANA ST D   Berkeley 94705 37.85498171317734 -122.25837304694502
771 771 771 054 171500500 2718 Dana St 5 2718 DANA ST 5 2718 DANA ST 2718.0 DANA ST 5   Berkeley 94705 37.860479953202535 -122.26012316993436
1924 1924 1924 054 171500500 2718 Dana St 2718 DANA ST 2718 DANA ST 2718.0 DANA ST     Berkeley 94705 37.860479953202535 -122.26012316993436
2779 2779 2779 052 157402900 3045 Dana St 3045 DANA ST 3045 DANA ST 3045.0 DANA ST     Berkeley 94705 37.85396805054372 -122.2583239288619
3257 3257 3257 054 171500400 2714 Dana St 2714 DANA ST 2714 DANA ST 2714.0 DANA ST     Berkeley 94705 37.86060749759344 -122.26010963232302
6638 6638 6638 052 155901700 3055 Dana St 3 3055 DANA ST 3 3055 DANA ST 3055.0 DANA ST 3   Berkeley 94705 37.85337736969421 -122.25816421109934
9345 9345 9345 052 157400300 3004 Dana St 3004 DANA ST 3004 DANA ST 3004.0 DANA ST     Berkeley 94705 37.85504825776416 -122.25889132455828
9518 9518 9518 052 155901700 3055 Dana St 2 3055 DANA ST 2 3055 DANA ST 3055.0 DANA ST 2   Berkeley 94705 37.85337736969421 -122.25816421109934
9600 9600 9600 054 171500201 2702 Dana St 2702 DANA ST 2702 DANA ST 2702.0 DANA ST     Berkeley 94705 37.86088908440977 -122.26030795877816
9902 9902 9902 052 157500100 3024 Dana St 3024 DANA ST 3024 DANA ST 3024.0 DANA ST     Berkeley 94705 37.85436877881685 -122.25873701195876
12210 12210 12210 052 157400200 3000 Dana St 3000 DANA ST 3000 DANA ST 3000.0 DANA ST     Berkeley 94705 37.8551462984995 -122.25891915885737
12641 12641 12641 054 171401100 2711 Dana St 2711 DANA ST 2711 DANA ST 2711.0 DANA ST     Berkeley 94705 37.86091013910432 -122.2596630043368
13310 13310 13310 054 171500500 2718 Dana St 6 2718 DANA ST 6 2718 DANA ST 2718.0 DANA ST 6   Berkeley 94705 37.860479953202535 -122.26012316993436
13452 13452 13452 052 157403100 3031 Dana St 3031 DANA ST 3031 DANA ST 3031.0 DANA ST     Berkeley 94705 37.85427153712259 -122.25823242826372
15371 15371 15371 052 157403300 3021 Dana St A 3021 DANA ST A 3021 DANA ST 3021.0 DANA ST A   Berkeley 94705 37.85450862922498 -122.2582796077824
17304 17304 17304 052 157402900 3043 Dana St 3043 DANA ST 3043 DANA ST 3043.0 DANA ST     Berkeley 94705 37.85396805054372 -122.2583239288619
20601 20601 20601 052 157403700 3009 Dana St 3009 DANA ST 3009 DANA ST 3009.0 DANA ST     Berkeley 94705 37.85498171317734 -122.25837304694502
20749 20749 20749 052 157401000 3001 Dana St A 3001 DANA ST A 3001 DANA ST 3001.0 DANA ST A   Berkeley 94705 37.855202023619086 -122.2585575878538
20957 20957 20957 054 171500300 2712 Dana St 2712 DANA ST 2712 DANA ST 2712.0 DANA ST     Berkeley 94705 37.86071848917604 -122.26015994696208
22398 22398 22398 054 171500500 2718 Dana St 2 2718 DANA ST 2 2718 DANA ST 2718.0 DANA ST 2   Berkeley 94705 37.860479953202535 -122.26012316993436
22905 22905 22905 052 157403700 3009 Dana St B 3009 DANA ST B 3009 DANA ST 3009.0 DANA ST B   Berkeley 94705 37.85498171317734 -122.25837304694502
23790 23790 23790 054 171401000 2713 Dana St 2713 DANA ST 2713 DANA ST 2713.0 DANA ST     Berkeley 94705 37.86078544560768 -122.25963746613158
26017 26017 26017 052 157403700 3009 Dana St C 3009 DANA ST C 3009 DANA ST 3009.0 DANA ST C   Berkeley 94705 37.85498171317734 -122.25837304694502
26279 26279 26279 052 157400400 3008 Dana St 2 3008 DANA ST 2 3008 DANA ST 3008.0 DANA ST 2   Berkeley 94705 37.854876179382536 -122.25887110078628
27767 27767 27767 052 155901700 3055 Dana St 4 3055 DANA ST 4 3055 DANA ST 3055.0 DANA ST 4   Berkeley 94705 37.85337736969421 -122.25816421109934
29930 29930 29930 054 171500400 2714 Dana St C 2714 DANA ST C 2714 DANA ST 2714.0 DANA ST C   Berkeley 94705 37.86060749759344 -122.26010963232302
31174 31174 31174 054 171400100 2707 Dana St 2707 DANA ST 2707 DANA ST 2707.0 DANA ST     Berkeley 94705 37.86114249141187 -122.25974725193744
31965 31965 31965 052 157403800 3005 Dana St 3005 DANA ST 3005 DANA ST 3005.0 DANA ST     Berkeley 94705 37.85508045122217 -122.25853306923644
33077 33077 33077 052 155901700 3055 Dana St 3055 DANA ST 3055 DANA ST 3055.0 DANA ST     Berkeley 94705 37.85337736969421 -122.25816421109934
35854 35854 35854 052 157403700 3009 Dana St A 3009 DANA ST A 3009 DANA ST 3009.0 DANA ST A   Berkeley 94705 37.85498171317734 -122.25837304694502
39319 39319 39319 054 171500100 2700 Dana St 2700 DANA ST 2700 DANA ST 2700.0 DANA ST     Berkeley 94705 37.86109089561173 -122.26019213809028
41806 41806 41806 052 157400400 3008 Dana St 1 3008 DANA ST 1 3008 DANA ST 3008.0 DANA ST 1   Berkeley 94705 37.854876179382536 -122.25887110078628
41864 41864 41864 052 157400400 3008 Dana St 3008 DANA ST 3008 DANA ST 3008.0 DANA ST     Berkeley 94705 37.854876179382536 -122.25887110078628
45586 45586 45586 054 171500201 2708 Dana St 2708 DANA ST 2708 DANA ST 2708.0 DANA ST     Berkeley 94705 37.86088908440977 -122.26030795877816
47192 47192 47192 052 157403200 3025 Dana St 3025 DANA ST 3025 DANA ST 3025.0 DANA ST     Berkeley 94705 37.85438713370595 -122.2582541585104
48028 48028 48028 052 157401000 3001 Dana St 3001 DANA ST 3001 DANA ST 3001.0 DANA ST     Berkeley 94705 37.855202023619086 -122.2585575878538
48803 48803 48803 054 171500400 2714 Dana St A 2714 DANA ST A 2714 DANA ST 2714.0 DANA ST A   Berkeley 94705 37.86060749759344 -122.26010963232302
51078 51078 51078 052 157400400 3008 Dana St 3 3008 DANA ST 3 3008 DANA ST 3008.0 DANA ST 3   Berkeley 94705 37.854876179382536 -122.25887110078628
51079 51079 51079 052 157403300 3021 Dana St 2 3021 DANA ST 2 3021 DANA ST 3021.0 DANA ST 2   Berkeley 94705 37.85450862922498 -122.2582796077824
53153 53153 53153 054 171500201 2706 Dana St 2706 DANA ST 2706 DANA ST 2706.0 DANA ST     Berkeley 94705 37.86088908440977 -122.26030795877816
53359 53359 53359 054 171401200 2709 Dana St 2709 DANA ST 2709 DANA ST 2709.0 DANA ST     Berkeley 94705 37.861027441593365 -122.25967604967136
54670 54670 54670 054 171500400 2714 Dana St B 2714 DANA ST B 2714 DANA ST 2714.0 DANA ST B   Berkeley 94705 37.86060749759344 -122.26010963232302
54721 54721 54721 052 157400400 3008 Dana St 4 3008 DANA ST 4 3008 DANA ST 3008.0 DANA ST 4   Berkeley 94705 37.854876179382536 -122.25887110078628
54989 54989 54989 052 157403300 3021 Dana St 3021 DANA ST 3021 DANA ST 3021.0 DANA ST     Berkeley 94705 37.85450862922498 -122.2582796077824
55042 55042 55042 052 157400500 3014 Dana St 3014 DANA ST 3014 DANA ST 3014.0 DANA ST     Berkeley 94705 37.854730800108875 -122.25884608270562
57539 57539 57539 052 155901700 3055 Dana St 1 3055 DANA ST 1 3055 DANA ST 3055.0 DANA ST 1   Berkeley 94705 37.85337736969421 -122.25816421109934
57547 57547 57547 052 157403000 3033 Dana St 3033 DANA ST 3033 DANA ST 3033.0 DANA ST     Berkeley 94705 37.85415638366278 -122.2582088825218
57894 57894 57894 054 171500500 2718 Dana St 1 2718 DANA ST 1 2718 DANA ST 2718.0 DANA ST 1   Berkeley 94705 37.860479953202535 -122.26012316993436
57900 57900 57900 054 171401000 2715 Dana St 2715 DANA ST 2715 DANA ST 2715.0 DANA ST     Berkeley 94705 37.86078544560768 -122.25963746613158

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