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

327 rows where street_name = "DANA" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 2

street_type 1

  • ST · 327 ✖

street_name 1

  • DANA · 327 ✖
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
235 235 235 055 188303300 2406 Dana St C 2406 DANA ST C 2406 DANA ST 2406.0 DANA ST C   Berkeley 94704 37.86619299435097 -122.2612807165516
352 352 352 055 183803100 2501 Dana St 5 2501 DANA ST 5 2501 DANA ST 2501.0 DANA ST 5   Berkeley 94704 37.864649053792235 -122.26039262679036
666 666 666 055 183213000 2550 Dana St 5G 2550 DANA ST 5G 2550 DANA ST 2550.0 DANA ST 5G   Berkeley 94704 37.863205032129635 -122.26071263094909
728 728 728 055 188300500 2414 Dana St 4 2414 DANA ST 4 2414 DANA ST 2414.0 DANA ST 4   Berkeley 94704 37.86595177910724 -122.2612195322976
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
940 940 940 055 183213000 2550 Dana St 2H 2550 DANA ST 2H 2550 DANA ST 2550.0 DANA ST 2H   Berkeley 94704 37.863205032129635 -122.26071263094909
1112 1112 1112 055 183213000 2550 Dana St G24 2550 DANA ST G24 2550 DANA ST 2550.0 DANA ST G24   Berkeley 94704 37.863205032129635 -122.26071263094909
1138 1138 1138 055 183213000 2550 Dana St G20 2550 DANA ST G20 2550 DANA ST 2550.0 DANA ST G20   Berkeley 94704 37.863205032129635 -122.26071263094909
1514 1514 1514 055 183601801 2609 Dana St 2609 DANA ST 2609 DANA ST 2609.0 DANA ST     Berkeley 94704 37.86273470586217 -122.25996351685048
1666 1666 1666 055 183400200 2630 Dana St 3 2630 DANA ST 3 2630 DANA ST 2630.0 DANA ST 3   Berkeley 94704 37.86187270747207 -122.26038042677048
1773 1773 1773 055 183213000 2550 Dana St G23 2550 DANA ST G23 2550 DANA ST 2550.0 DANA ST G23   Berkeley 94704 37.863205032129635 -122.26071263094909
1832 1832 1832 055 183200401 2532 Dana St 2532 DANA ST 2532 DANA ST 2532.0 DANA ST     Berkeley 94704 37.86339246507937 -122.26075346836188
1924 1924 1924 054 171500500 2718 Dana St 2718 DANA ST 2718 DANA ST 2718.0 DANA ST     Berkeley 94705 37.860479953202535 -122.26012316993436
2487 2487 2487 055 183213000 2550 Dana St 6F 2550 DANA ST 6F 2550 DANA ST 2550.0 DANA ST 6F   Berkeley 94704 37.863205032129635 -122.26071263094909
2496 2496 2496 055 183213000 2550 Dana St G22 2550 DANA ST G22 2550 DANA ST 2550.0 DANA ST G22   Berkeley 94704 37.863205032129635 -122.26071263094909
2553 2553 2553 055 183200401 2532 Dana St 9 2532 DANA ST 9 2532 DANA ST 2532.0 DANA ST 9   Berkeley 94704 37.86339246507937 -122.26075346836188
2779 2779 2779 052 157402900 3045 Dana St 3045 DANA ST 3045 DANA ST 3045.0 DANA ST     Berkeley 94705 37.85396805054372 -122.2583239288619
2873 2873 2873 055 188300100 2400 Dana St 1 2400 DANA ST 1 2400 DANA ST 2400.0 DANA ST 1   Berkeley 94704 37.86643162317323 -122.2613341025306
2959 2959 2959 055 188300400 2410 Dana St C 2410 DANA ST C 2410 DANA ST 2410.0 DANA ST C   Berkeley 94704 37.86607594758496 -122.26124598139452
3069 3069 3069 055 188300100 2400 Dana St 2400 DANA ST 2400 DANA ST 2400.0 DANA ST     Berkeley 94704 37.86643162317323 -122.2613341025306
3257 3257 3257 054 171500400 2714 Dana St 2714 DANA ST 2714 DANA ST 2714.0 DANA ST     Berkeley 94705 37.86060749759344 -122.26010963232302
3323 3323 3323 055 183501500 2633 Dana St 2633 DANA ST 2633 DANA ST 2633.0 DANA ST     Berkeley 94704 37.86186434300943 -122.25982418455666
3499 3499 3499 055 183213000 2550 Dana St 5A 2550 DANA ST 5A 2550 DANA ST 2550.0 DANA ST 5A   Berkeley 94704 37.863205032129635 -122.26071263094909
3818 3818 3818 055 183803100 2501 Dana St 4 2501 DANA ST 4 2501 DANA ST 2501.0 DANA ST 4   Berkeley 94704 37.864649053792235 -122.26039262679036
3972 3972 3972 055 183204000 2522 Dana St 207 2522 DANA ST 207 2522 DANA ST 2522.0 DANA ST 207   Berkeley 94704 37.86369612632498 -122.260810034377
4109 4109 4109 055 183702000 2545 Dana St 2545 DANA ST 2545 DANA ST 2545.0 DANA ST     Berkeley 94704 37.86323152714724 -122.26007489626762
4393 4393 4393 055 183100300 2508 Dana St 2508 DANA ST 2508 DANA ST 2508.0 DANA ST     Berkeley 94704 37.86439998773693 -122.26092196176646
4515 4515 4515 055 183300600 2620 Dana St 2620 DANA ST 2620 DANA ST 2620.0 DANA ST     Berkeley 94704 37.86226742903117 -122.26043487096491
4824 4824 4824 055 183400200 2630 Dana St B 2630 DANA ST B 2630 DANA ST 2630.0 DANA ST B   Berkeley 94704 37.86187270747207 -122.26038042677048
5105 5105 5105 055 183213000 2550 Dana St G17 2550 DANA ST G17 2550 DANA ST 2550.0 DANA ST G17   Berkeley 94704 37.863205032129635 -122.26071263094909
5165 5165 5165 055 183300400 2612 Dana St 2612 DANA ST 2612 DANA ST 2612.0 DANA ST     Berkeley 94704 37.86249799411253 -122.26056592977496
5447 5447 5447 055 183801100 2511 Dana St 2511 DANA ST 2511 DANA ST 2511.0 DANA ST     Berkeley 94704 37.86444426594038 -122.26035223584022
5912 5912 5912 055 188200300 2446 Dana St 2 2446 DANA ST 2 2446 DANA ST 2446.0 DANA ST 2   Berkeley 94704 37.86496030379886 -122.26100550329126
5925 5925 5925 055 183702100 2541 Dana St 2541 DANA ST 2541 DANA ST 2541.0 DANA ST     Berkeley 94704 37.86334695152821 -122.26014254120513
6060 6060 6060 055 188300100 2400 Dana St 3 2400 DANA ST 3 2400 DANA ST 2400.0 DANA ST 3   Berkeley 94704 37.86643162317323 -122.2613341025306
6188 6188 6188 055 183213000 2550 Dana St G14 2550 DANA ST G14 2550 DANA ST 2550.0 DANA ST G14   Berkeley 94704 37.863205032129635 -122.26071263094909
6578 6578 6578 055 183213000 2550 Dana St 3G 2550 DANA ST 3G 2550 DANA ST 2550.0 DANA ST 3G   Berkeley 94704 37.863205032129635 -122.26071263094909
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
6687 6687 6687 055 183213000 2550 Dana St 5F 2550 DANA ST 5F 2550 DANA ST 2550.0 DANA ST 5F   Berkeley 94704 37.863205032129635 -122.26071263094909
6756 6756 6756 055 183213000 2550 Dana St 4C 2550 DANA ST 4C 2550 DANA ST 2550.0 DANA ST 4C   Berkeley 94704 37.863205032129635 -122.26071263094909
6859 6859 6859 055 183213000 2550 Dana St G25 2550 DANA ST G25 2550 DANA ST 2550.0 DANA ST G25   Berkeley 94704 37.863205032129635 -122.26071263094909
7135 7135 7135 055 183803100 2501 Dana St 2 2501 DANA ST 2 2501 DANA ST 2501.0 DANA ST 2   Berkeley 94704 37.864649053792235 -122.26039262679036
7232 7232 7232 055 183213000 2550 Dana St 4F 2550 DANA ST 4F 2550 DANA ST 2550.0 DANA ST 4F   Berkeley 94704 37.863205032129635 -122.26071263094909
7491 7491 7491 055 183200401 2532 Dana St 2 2532 DANA ST 2 2532 DANA ST 2532.0 DANA ST 2   Berkeley 94704 37.86339246507937 -122.26075346836188
7699 7699 7699 055 188200300 2444 Dana St 2444 DANA ST 2444 DANA ST 2444.0 DANA ST     Berkeley 94704 37.86496030379886 -122.26100550329126
7737 7737 7737 055 183213000 2550 Dana St 9B 2550 DANA ST 9B 2550 DANA ST 2550.0 DANA ST 9B   Berkeley 94704 37.863205032129635 -122.26071263094909
7796 7796 7796 055 183213000 2550 Dana St 3E 2550 DANA ST 3E 2550 DANA ST 2550.0 DANA ST 3E   Berkeley 94704 37.863205032129635 -122.26071263094909
7937 7937 7937 055 188200200 2440 Dana St 2440 DANA ST 2440 DANA ST 2440.0 DANA ST     Berkeley 94704 37.86513523224434 -122.26103993841105
8177 8177 8177 055 188300100 2400 Dana St 5 2400 DANA ST 5 2400 DANA ST 2400.0 DANA ST 5   Berkeley 94704 37.86643162317323 -122.2613341025306
8235 8235 8235 055 183702301 2531 Dana St A 2531 DANA ST A 2531 DANA ST 2531.0 DANA ST A   Berkeley 94704 37.863587044838575 -122.26012833614556
8285 8285 8285 055 188001502 2407 Dana St 2407 DANA ST 2407 DANA ST 2407.0 DANA ST     Berkeley 94704 37.86622816500729 -122.2605279570896
8343 8343 8343 055 183702401 2529 Dana St A 2529 DANA ST A 2529 DANA ST 2529.0 DANA ST A   Berkeley 94704 37.863689098194314 -122.26023647623778
8388 8388 8388 055 183601700 2611 Dana St A 2611 DANA ST A 2611 DANA ST 2611.0 DANA ST A   Berkeley 94704 37.86257960468215 -122.25993210545992
8395 8395 8395 055 183300500 2616 Dana St 2616 DANA ST 2616 DANA ST 2616.0 DANA ST     Berkeley 94704 37.86238482013866 -122.26045757139217
8710 8710 8710 055 183100100 2500 Dana St 2500 DANA ST 2500 DANA ST 2500.0 DANA ST     Berkeley 94704 37.86464105771259 -122.2609745141089
8713 8713 8713 055 183200301 2528 Dana St 2 2528 DANA ST 2 2528 DANA ST 2528.0 DANA ST 2   Berkeley 94704 37.863519210128835 -122.26077554984988
9102 9102 9102 055 183213000 2550 Dana St 6E 2550 DANA ST 6E 2550 DANA ST 2550.0 DANA ST 6E   Berkeley 94704 37.863205032129635 -122.26071263094909
9288 9288 9288 055 188101701 2431 Dana St 2431 DANA ST 2431 DANA ST 2431.0 DANA ST     Berkeley 94704 37.86541137015752 -122.2606279620386
9345 9345 9345 052 157400300 3004 Dana St 3004 DANA ST 3004 DANA ST 3004.0 DANA ST     Berkeley 94705 37.85504825776416 -122.25889132455828
9416 9416 9416 055 183702401 2527 Dana St 2527 DANA ST 2527 DANA ST 2527.0 DANA ST     Berkeley 94704 37.863689098194314 -122.26023647623778
9492 9492 9492 055 183100100 2500 Dana St 1 2500 DANA ST 1 2500 DANA ST 2500.0 DANA ST 1   Berkeley 94704 37.86464105771259 -122.2609745141089
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
9553 9553 9553 055 183204000 2522 Dana St 201 2522 DANA ST 201 2522 DANA ST 2522.0 DANA ST 201   Berkeley 94704 37.86369612632498 -122.260810034377
9578 9578 9578 055 188300200 2402 Dana St 2402 DANA ST 2402 DANA ST 2402.0 DANA ST     Berkeley 94704 37.86630686597396 -122.26130768038314
9600 9600 9600 054 171500201 2702 Dana St 2702 DANA ST 2702 DANA ST 2702.0 DANA ST     Berkeley 94705 37.86088908440977 -122.26030795877816
9712 9712 9712 055 183213000 2550 Dana St G6 2550 DANA ST G6 2550 DANA ST 2550.0 DANA ST G6   Berkeley 94704 37.863205032129635 -122.26071263094909
9902 9902 9902 052 157500100 3024 Dana St 3024 DANA ST 3024 DANA ST 3024.0 DANA ST     Berkeley 94705 37.85436877881685 -122.25873701195876
10272 10272 10272 055 183213000 2550 Dana St 5C 2550 DANA ST 5C 2550 DANA ST 2550.0 DANA ST 5C   Berkeley 94704 37.863205032129635 -122.26071263094909
10415 10415 10415 055 188300500 2414 Dana St 5 2414 DANA ST 5 2414 DANA ST 2414.0 DANA ST 5   Berkeley 94704 37.86595177910724 -122.2612195322976
10566 10566 10566 055 183100600 2516 Dana St 2516 DANA ST 2516 DANA ST 2516.0 DANA ST     Berkeley 94704 37.864137300108105 -122.26086726245047
10685 10685 10685 055 188300100 2400 Dana St 4 2400 DANA ST 4 2400 DANA ST 2400.0 DANA ST 4   Berkeley 94704 37.86643162317323 -122.2613341025306
10690 10690 10690 055 183200401 2532 Dana St 6 2532 DANA ST 6 2532 DANA ST 2532.0 DANA ST 6   Berkeley 94704 37.86339246507937 -122.26075346836188
10833 10833 10833 055 183603000 2601 Dana St D 2601 DANA ST D 2601 DANA ST 2601.0 DANA ST D   Berkeley 94704 37.86291530754369 -122.25999806875124
11310 11310 11310 055 183204000 2522 Dana St 105 2522 DANA ST 105 2522 DANA ST 2522.0 DANA ST 105   Berkeley 94704 37.86369612632498 -122.260810034377
11405 11405 11405 055 183100100 2500 Dana St 3 2500 DANA ST 3 2500 DANA ST 2500.0 DANA ST 3   Berkeley 94704 37.86464105771259 -122.2609745141089
11797 11797 11797 055 183213000 2550 Dana St G16 2550 DANA ST G16 2550 DANA ST 2550.0 DANA ST G16   Berkeley 94704 37.863205032129635 -122.26071263094909
11887 11887 11887 055 183702100 2541 Dana St 2 2541 DANA ST 2 2541 DANA ST 2541.0 DANA ST 2   Berkeley 94704 37.86334695152821 -122.26014254120513
11910 11910 11910 055 183200301 2528 Dana St 3 2528 DANA ST 3 2528 DANA ST 2528.0 DANA ST 3   Berkeley 94704 37.863519210128835 -122.26077554984988
11971 11971 11971 055 183400500 2642 Dana St 2642 DANA ST 2642 DANA ST 2642.0 DANA ST     Berkeley 94704 37.86149632911654 -122.26029616120356
12056 12056 12056 055 183702100 2543 Dana St 2543 DANA ST 2543 DANA ST 2543.0 DANA ST     Berkeley 94704 37.86334695152821 -122.26014254120513
12181 12181 12181 055 188200300 2446 Dana St 1 2446 DANA ST 1 2446 DANA ST 2446.0 DANA ST 1   Berkeley 94704 37.86496030379886 -122.26100550329126
12183 12183 12183 055 183213000 2550 Dana St G1 2550 DANA ST G1 2550 DANA ST 2550.0 DANA ST G1   Berkeley 94704 37.863205032129635 -122.26071263094909
12210 12210 12210 052 157400200 3000 Dana St 3000 DANA ST 3000 DANA ST 3000.0 DANA ST     Berkeley 94705 37.8551462984995 -122.25891915885737
12230 12230 12230 055 183100100 2500 Dana St 2 2500 DANA ST 2 2500 DANA ST 2500.0 DANA ST 2   Berkeley 94704 37.86464105771259 -122.2609745141089
12641 12641 12641 054 171401100 2711 Dana St 2711 DANA ST 2711 DANA ST 2711.0 DANA ST     Berkeley 94705 37.86091013910432 -122.2596630043368
13017 13017 13017 055 183100700 2518 Dana St 2518 DANA ST 2518 DANA ST 2518.0 DANA ST     Berkeley 94704 37.864044505881004 -122.2607775962121
13056 13056 13056 055 183204000 2522 Dana St 101 2522 DANA ST 101 2522 DANA ST 2522.0 DANA ST 101   Berkeley 94704 37.86369612632498 -122.260810034377
13058 13058 13058 055 183801000 2515 Dana St 3 2515 DANA ST 3 2515 DANA ST 2515.0 DANA ST 3   Berkeley 94704 37.86420358182995 -122.26039072415858
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
13540 13540 13540 055 183100100 2500 Dana St 4 2500 DANA ST 4 2500 DANA ST 2500.0 DANA ST 4   Berkeley 94704 37.86464105771259 -122.2609745141089
13790 13790 13790 055 183204000 2522 Dana St 202 2522 DANA ST 202 2522 DANA ST 2522.0 DANA ST 202   Berkeley 94704 37.86369612632498 -122.260810034377
13867 13867 13867 055 183213000 2550 Dana St 9De 2550 DANA ST 9DE 2550 DANA ST 2550.0 DANA ST 9DE   Berkeley 94704 37.863205032129635 -122.26071263094909
14085 14085 14085 055 188200200 2440 Dana St P 2440 DANA ST P 2440 DANA ST 2440.0 DANA ST P   Berkeley 94704 37.86513523224434 -122.26103993841105
14112 14112 14112 055 183801000 2515 Dana St 4 2515 DANA ST 4 2515 DANA ST 2515.0 DANA ST 4   Berkeley 94704 37.86420358182995 -122.26039072415858
14601 14601 14601 055 183501600 2631 Dana St 2631 DANA ST 2631 DANA ST 2631.0 DANA ST     Berkeley 94704 37.86196535975446 -122.25984478382443
14959 14959 14959 055 183100100 2500 Dana St 8 2500 DANA ST 8 2500 DANA ST 2500.0 DANA ST 8   Berkeley 94704 37.86464105771259 -122.2609745141089
15047 15047 15047 055 183400300 2634 Dana St 2634 DANA ST 2634 DANA ST 2634.0 DANA ST     Berkeley 94704 37.861737095826776 -122.26041271761169
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

Next page

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