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

581 rows where street_name = "BLAKE" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94704 · 581 ✖

street_type 1

street_name 1

  • BLAKE · 581 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
42 42 42 055 181603000 1936 Blake St 18 1936 BLAKE ST 18 1936 BLAKE ST 1936.0 BLAKE ST 18   Berkeley 94704 37.86238468255223 -122.27022266726398
241 241 241 055 182402000 2126 Blake St 2126 BLAKE ST 2126 BLAKE ST 2126.0 BLAKE ST     Berkeley 94704 37.8629711473545 -122.26590409918056
245 245 245 055 183000100 2233 Blake St 2233 BLAKE ST 2233 BLAKE ST 2233.0 BLAKE ST     Berkeley 94704 37.86430650521714 -122.26313026777152
367 367 367 055 183200702 2336 Blake St 1 2336 BLAKE ST 1 2336 BLAKE ST 2336.0 BLAKE ST 1   Berkeley 94704 37.86359310705293 -122.26110028274024
383 383 383 055 182401900 2124 Blake St 9 2124 BLAKE ST 9 2124 BLAKE ST 2124.0 BLAKE ST 9   Berkeley 94704 37.86294995424496 -122.26606816658575
573 573 573 055 182000101 2033 Blake St Apt 202 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 202 APT Berkeley 94704 37.863193313299234 -122.26818446085124
699 699 699 055 183202500 2324 Blake St 3 2324 BLAKE ST 3 2324 BLAKE ST 2324.0 BLAKE ST 3   Berkeley 94704 37.86352750419314 -122.26161592828974
831 831 831 055 182902600 2232 Blake St 5 2232 BLAKE ST 5 2232 BLAKE ST 2232.0 BLAKE ST 5   Berkeley 94704 37.863304854872545 -122.26335248581998
857 857 857 055 183100900 2335 Blake St 2335 BLAKE ST 2335 BLAKE ST 2335.0 BLAKE ST     Berkeley 94704 37.864126785633374 -122.2611459881236
891 891 891 055 183800600 2417 Blake St 5 2417 BLAKE ST 5 2417 BLAKE ST 2417.0 BLAKE ST 5   Berkeley 94704 37.864309705791214 -122.25972803517683
1818 1818 1818 055 181603000 1936 Blake St 36 1936 BLAKE ST 36 1936 BLAKE ST 1936.0 BLAKE ST 36   Berkeley 94704 37.86238468255223 -122.27022266726398
1827 1827 1827 055 181603000 1936 Blake St 14 1936 BLAKE ST 14 1936 BLAKE ST 1936.0 BLAKE ST 14   Berkeley 94704 37.86238468255223 -122.27022266726398
1909 1909 1909 055 182000101 2033 Blake St Apt 411 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 411 APT Berkeley 94704 37.86326093342131 -122.26835341149824
1995 1995 1995 055 182300901 2121 Blake St C 2121 BLAKE ST C 2121 BLAKE ST 2121.0 BLAKE ST C   Berkeley 94704 37.86346825072483 -122.26624153424906
2026 2026 2026 055 183801000 2401 Blake St 2401 BLAKE ST 2401 BLAKE ST 2401.0 BLAKE ST     Berkeley 94704 37.86420358182995 -122.26039072415858
2040 2040 2040 055 182902600 2232 Blake St 2232 BLAKE ST 2232 BLAKE ST 2232.0 BLAKE ST     Berkeley 94704 37.863304854872545 -122.26335248581998
2318 2318 2318 055 183101801 2309 Blake St 110 2309 BLAKE ST 110 2309 BLAKE ST 2309.0 BLAKE ST 110   Berkeley 94704 37.86397363482743 -122.26233933170656
2401 2401 2401 055 183101801 2309 Blake St 216 2309 BLAKE ST 216 2309 BLAKE ST 2309.0 BLAKE ST 216   Berkeley 94704 37.86397363482743 -122.26233933170656
2585 2585 2585 055 182401900 2124 Blake St 2 2124 BLAKE ST 2 2124 BLAKE ST 2124.0 BLAKE ST 2   Berkeley 94704 37.86294995424496 -122.26606816658575
2719 2719 2719 055 183101002 2325 Blake St 303 2325 BLAKE ST 303 2325 BLAKE ST 2325.0 BLAKE ST 303   Berkeley 94704 37.86406345053637 -122.2616537814992
2756 2756 2756 055 181602100 1904 Blake St 1904 BLAKE ST 1904 BLAKE ST 1904.0 BLAKE ST     Berkeley 94704 37.86229954486931 -122.27172078137508
2799 2799 2799 055 183101200 2317 Blake St 5 2317 BLAKE ST 5 2317 BLAKE ST 2317.0 BLAKE ST 5   Berkeley 94704 37.86401513112403 -122.2620147272753
2833 2833 2833 055 183200702 2336 Blake St 2 2336 BLAKE ST 2 2336 BLAKE ST 2336.0 BLAKE ST 2   Berkeley 94704 37.86359310705293 -122.26110028274024
2903 2903 2903 055 183101801 2309 Blake St 204 2309 BLAKE ST 204 2309 BLAKE ST 2309.0 BLAKE ST 204   Berkeley 94704 37.86397363482743 -122.26233933170656
3020 3020 3020 055 183101801 2309 Blake St 221 2309 BLAKE ST 221 2309 BLAKE ST 2309.0 BLAKE ST 221   Berkeley 94704 37.86397363482743 -122.26233933170656
3062 3062 3062 055 181602700 1920 Blake St A 1920 BLAKE ST A 1920 BLAKE ST 1920.0 BLAKE ST A   Berkeley 94704 37.862310202864926 -122.2707985771926
3127 3127 3127 055 183000700 2231 Blake St 2 2231 BLAKE ST 2 2231 BLAKE ST 2231.0 BLAKE ST 2   Berkeley 94704 37.863811462747336 -122.2635499040784
3134 3134 3134 055 183200702 2336 Blake St 5 2336 BLAKE ST 5 2336 BLAKE ST 2336.0 BLAKE ST 5   Berkeley 94704 37.86359310705293 -122.26110028274024
3261 3261 3261 055 183001001 2219 Blake St D 2219 BLAKE ST D 2219 BLAKE ST 2219.0 BLAKE ST D   Berkeley 94704 37.86373497322378 -122.26414139259072
3298 3298 3298 055 183101002 2325 Blake St 304 2325 BLAKE ST 304 2325 BLAKE ST 2325.0 BLAKE ST 304   Berkeley 94704 37.86406345053637 -122.2616537814992
3596 3596 3596 055 183001001 2219 Blake St 2219 BLAKE ST 2219 BLAKE ST 2219.0 BLAKE ST     Berkeley 94704 37.86373497322378 -122.26414139259072
3694 3694 3694 055 181603000 1936 Blake St 34 1936 BLAKE ST 34 1936 BLAKE ST 1936.0 BLAKE ST 34   Berkeley 94704 37.86238468255223 -122.27022266726398
3703 3703 3703 055 181602700 1920 Blake St 2 1920 BLAKE ST 2 1920 BLAKE ST 1920.0 BLAKE ST 2   Berkeley 94704 37.862310202864926 -122.2707985771926
3707 3707 3707 055 183001001 2219 Blake St B 2219 BLAKE ST B 2219 BLAKE ST 2219.0 BLAKE ST B   Berkeley 94704 37.86373497322378 -122.26414139259072
3751 3751 3751 055 183101801 2309 Blake St 320 2309 BLAKE ST 320 2309 BLAKE ST 2309.0 BLAKE ST 320   Berkeley 94704 37.86397363482743 -122.26233933170656
3775 3775 3775 055 182000101 2033 Blake St Apt 218 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 218 APT Berkeley 94704 37.86316029007337 -122.26844267169815
3797 3797 3797 055 182902701 2240 Blake St 404 2240 BLAKE ST 404 2240 BLAKE ST 2240.0 BLAKE ST 404   Berkeley 94704 37.86334340482317 -122.2630598147004
3903 3903 3903 055 182300901 2121 Blake St 11 2121 BLAKE ST 11 2121 BLAKE ST 2121.0 BLAKE ST 11   Berkeley 94704 37.86346825072483 -122.26624153424906
3968 3968 3968 055 183202400 2320 Blake St 2320 BLAKE ST 2320 BLAKE ST 2320.0 BLAKE ST     Berkeley 94704 37.86350622472145 -122.26178859436882
4097 4097 4097 055 183202601 2330 Blake St 12 2330 BLAKE ST 12 2330 BLAKE ST 2330.0 BLAKE ST 12   Berkeley 94704 37.86355934644125 -122.26136112205772
4266 4266 4266 055 182000101 2033 Blake St Apt 505 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 505 APT Berkeley 94704 37.86331680133823 -122.26826664232664
4311 4311 4311 055 182101900 2004 Blake St 2004 BLAKE ST 2004 BLAKE ST 2004.0 BLAKE ST     Berkeley 94704 37.86251103927097 -122.26931357758632
4376 4376 4376 055 182000101 2033 Blake St Apt 501 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 501 APT Berkeley 94704 37.86332505712853 -122.26820209028864
4496 4496 4496 055 182000101 2033 Blake St Apt 115 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 115 APT Berkeley 94704 37.86313121353769 -122.26832234955238
4630 4630 4630 055 183001001 2219 Blake St G 2219 BLAKE ST G 2219 BLAKE ST 2219.0 BLAKE ST G   Berkeley 94704 37.86373497322378 -122.26414139259072
4756 4756 4756 055 183101801 2309 Blake St 105 2309 BLAKE ST 105 2309 BLAKE ST 2309.0 BLAKE ST 105   Berkeley 94704 37.86397363482743 -122.26233933170656
4789 4789 4789 055 183101001 2331 Blake St 207 2331 BLAKE ST 207 2331 BLAKE ST 2331.0 BLAKE ST 207   Berkeley 94704 37.86409844703866 -122.26137830323589
4999 4999 4999 055 183204500 2316 Blake St D 2316 BLAKE ST D 2316 BLAKE ST 2316.0 BLAKE ST D   Berkeley 94704 37.8634828587836 -122.26195784145996
5011 5011 5011 055 182000101 2033 Blake St Apt 208 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 208 APT Berkeley 94704 37.863180929236655 -122.26828129025569
5098 5098 5098 055 183101801 2309 Blake St 306 2309 BLAKE ST 306 2309 BLAKE ST 2309.0 BLAKE ST 306   Berkeley 94704 37.86397363482743 -122.26233933170656
5136 5136 5136 055 182300901 2121 Blake St 1A 2121 BLAKE ST 1A 2121 BLAKE ST 2121.0 BLAKE ST 1A   Berkeley 94704 37.86346825072483 -122.26624153424906
5250 5250 5250 055 181602901 1930 Blake St A 1930 BLAKE ST A 1930 BLAKE ST 1930.0 BLAKE ST A   Berkeley 94704 37.862269069432855 -122.27044542789486
5361 5361 5361 055 182402300 2172 Blake St 10 2172 BLAKE ST 10 2172 BLAKE ST 2172.0 BLAKE ST 10   Berkeley 94704 37.863043033531106 -122.26534972007263
5460 5460 5460 055 182902701 2240 Blake St 106 2240 BLAKE ST 106 2240 BLAKE ST 2240.0 BLAKE ST 106   Berkeley 94704 37.86334340482317 -122.2630598147004
5500 5500 5500 055 183101801 2309 Blake St 401 2309 BLAKE ST 401 2309 BLAKE ST 2309.0 BLAKE ST 401   Berkeley 94704 37.86397363482743 -122.26233933170656
5629 5629 5629 055 183202601 2330 Blake St 22 2330 BLAKE ST 22 2330 BLAKE ST 2330.0 BLAKE ST 22   Berkeley 94704 37.86355934644125 -122.26136112205772
5665 5665 5665 055 183101801 2309 Blake St 319 2309 BLAKE ST 319 2309 BLAKE ST 2309.0 BLAKE ST 319   Berkeley 94704 37.86397363482743 -122.26233933170656
6201 6201 6201 055 183202601 2330 Blake St 15 2330 BLAKE ST 15 2330 BLAKE ST 2330.0 BLAKE ST 15   Berkeley 94704 37.86355934644125 -122.26136112205772
6465 6465 6465 055 183800500 2423 Blake St 302 2423 BLAKE ST 302 2423 BLAKE ST 2423.0 BLAKE ST 302   Berkeley 94704 37.86433579830116 -122.2595216050195
6471 6471 6471 055 183101001 2331 Blake St 205 2331 BLAKE ST 205 2331 BLAKE ST 2331.0 BLAKE ST 205   Berkeley 94704 37.86409844703866 -122.26137830323589
6520 6520 6520 055 183101002 2325 Blake St 301 2325 BLAKE ST 301 2325 BLAKE ST 2325.0 BLAKE ST 301   Berkeley 94704 37.86406345053637 -122.2616537814992
6767 6767 6767 055 183202601 2330 Blake St 18 2330 BLAKE ST 18 2330 BLAKE ST 2330.0 BLAKE ST 18   Berkeley 94704 37.86355934644125 -122.26136112205772
6946 6946 6946 055 182901700 2202 Blake St 2 2202 BLAKE ST 2 2202 BLAKE ST 2202.0 BLAKE ST 2   Berkeley 94704 37.86324280201226 -122.26469871727444
7049 7049 7049 055 182902701 2240 Blake St 211 2240 BLAKE ST 211 2240 BLAKE ST 2240.0 BLAKE ST 211   Berkeley 94704 37.86334340482317 -122.2630598147004
7079 7079 7079 055 183101801 2309 Blake St 406 2309 BLAKE ST 406 2309 BLAKE ST 2309.0 BLAKE ST 406   Berkeley 94704 37.86397363482743 -122.26233933170656
7123 7123 7123 055 183101801 2309 Blake St 314 2309 BLAKE ST 314 2309 BLAKE ST 2309.0 BLAKE ST 314   Berkeley 94704 37.86397363482743 -122.26233933170656
7405 7405 7405 055 182000101 2033 Blake St Apt 504 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 504 APT Berkeley 94704 37.86331886439939 -122.26825050499087
7602 7602 7602 055 182000101 2033 Blake St Apt 110 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 110 APT Berkeley 94704 37.86314153241498 -122.26824166107691
7650 7650 7650 055 183101002 2325 Blake St 106 2325 BLAKE ST 106 2325 BLAKE ST 2325.0 BLAKE ST 106   Berkeley 94704 37.86406345053637 -122.2616537814992
7775 7775 7775 055 183101801 2309 Blake St 405 2309 BLAKE ST 405 2309 BLAKE ST 2309.0 BLAKE ST 405   Berkeley 94704 37.86397363482743 -122.26233933170656
7868 7868 7868 055 182902701 2240 Blake St 109 2240 BLAKE ST 109 2240 BLAKE ST 2240.0 BLAKE ST 109   Berkeley 94704 37.86334340482317 -122.2630598147004
8115 8115 8115 055 181603000 1936 Blake St 16 1936 BLAKE ST 16 1936 BLAKE ST 1936.0 BLAKE ST 16   Berkeley 94704 37.86238468255223 -122.27022266726398
8196 8196 8196 055 182102000 2016 Blake St B 2016 BLAKE ST B 2016 BLAKE ST 2016.0 BLAKE ST B   Berkeley 94704 37.862555003012325 -122.2689708155082
8379 8379 8379 055 182102402 2036 Blake St 2036 BLAKE ST 2036 BLAKE ST 2036.0 BLAKE ST     Berkeley 94704 37.86266253428414 -122.26816071209004
8450 8450 8450 055 182902701 2240 Blake St 312 2240 BLAKE ST 312 2240 BLAKE ST 2240.0 BLAKE ST 312   Berkeley 94704 37.86334340482317 -122.2630598147004
8516 8516 8516 055 183101801 2309 Blake St 402 2309 BLAKE ST 402 2309 BLAKE ST 2309.0 BLAKE ST 402   Berkeley 94704 37.86397363482743 -122.26233933170656
8566 8566 8566 055 182902701 2240 Blake St 202 2240 BLAKE ST 202 2240 BLAKE ST 2240.0 BLAKE ST 202   Berkeley 94704 37.86334340482317 -122.2630598147004
8572 8572 8572 055 182902701 2240 Blake St 311 2240 BLAKE ST 311 2240 BLAKE ST 2240.0 BLAKE ST 311   Berkeley 94704 37.86334340482317 -122.2630598147004
8695 8695 8695 055 181603000 1936 Blake St 42 1936 BLAKE ST 42 1936 BLAKE ST 1936.0 BLAKE ST 42   Berkeley 94704 37.86238468255223 -122.27022266726398
8827 8827 8827 055 183101801 2309 Blake St 219 2309 BLAKE ST 219 2309 BLAKE ST 2309.0 BLAKE ST 219   Berkeley 94704 37.86397363482743 -122.26233933170656
8838 8838 8838 055 183101801 2309 Blake St 208 2309 BLAKE ST 208 2309 BLAKE ST 2309.0 BLAKE ST 208   Berkeley 94704 37.86397363482743 -122.26233933170656
9129 9129 9129 055 182000101 2033 Blake St Apt 310 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 310 APT Berkeley 94704 37.8632202579541 -122.26832542987547
9153 9153 9153 055 182902600 2232 Blake St 8 2232 BLAKE ST 8 2232 BLAKE ST 2232.0 BLAKE ST 8   Berkeley 94704 37.863304854872545 -122.26335248581998
9278 9278 9278 055 183101001 2331 Blake St 308 2331 BLAKE ST 308 2331 BLAKE ST 2331.0 BLAKE ST 308   Berkeley 94704 37.86409844703866 -122.26137830323589
9358 9358 9358 055 183200702 2338 Blake St 8 2338 BLAKE ST 8 2338 BLAKE ST 2338.0 BLAKE ST 8   Berkeley 94704 37.86359310705293 -122.26110028274024
9453 9453 9453 055 183800700 2415 Blake St A 2415 BLAKE ST A 2415 BLAKE ST 2415.0 BLAKE ST A   Berkeley 94704 37.86429165903382 -122.25988002383473
9623 9623 9623 055 182000101 2033 Blake St Apt 316 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 316 APT Berkeley 94704 37.86320787318689 -122.26842225748332
9685 9685 9685 055 182000101 2033 Blake St Apt 313 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 313 APT Berkeley 94704 37.863214065925355 -122.26837384278107
9882 9882 9882 055 183101002 2325 Blake St 202 2325 BLAKE ST 202 2325 BLAKE ST 2325.0 BLAKE ST 202   Berkeley 94704 37.86406345053637 -122.2616537814992
9984 9984 9984 055 182201304 2015 Blake St 2015 BLAKE ST 2015 BLAKE ST 2015.0 BLAKE ST     Berkeley 94704 37.86310331639266 -122.26920127110785
10040 10040 10040 055 183101801 2309 Blake St 107 2309 BLAKE ST 107 2309 BLAKE ST 2309.0 BLAKE ST 107   Berkeley 94704 37.86397363482743 -122.26233933170656
10159 10159 10159 055 183202601 2330 Blake St 3 2330 BLAKE ST 3 2330 BLAKE ST 2330.0 BLAKE ST 3   Berkeley 94704 37.86355934644125 -122.26136112205772
10284 10284 10284 055 183101200 2317 Blake St 1 2317 BLAKE ST 1 2317 BLAKE ST 2317.0 BLAKE ST 1   Berkeley 94704 37.86401513112403 -122.2620147272753
10329 10329 10329 055 182902701 2240 Blake St 105 2240 BLAKE ST 105 2240 BLAKE ST 2240.0 BLAKE ST 105   Berkeley 94704 37.86334340482317 -122.2630598147004
10522 10522 10522 055 181602800 1924 Blake St A 1924 BLAKE ST A 1924 BLAKE ST 1924.0 BLAKE ST A   Berkeley 94704 37.86232766146413 -122.27065613672792
10592 10592 10592 055 181603000 1936 Blake St 12 1936 BLAKE ST 12 1936 BLAKE ST 1936.0 BLAKE ST 12   Berkeley 94704 37.86238468255223 -122.27022266726398
10622 10622 10622 055 183101801 2309 Blake St 207 2309 BLAKE ST 207 2309 BLAKE ST 2309.0 BLAKE ST 207   Berkeley 94704 37.86397363482743 -122.26233933170656
11330 11330 11330 055 183101801 2309 Blake St 317 2309 BLAKE ST 317 2309 BLAKE ST 2309.0 BLAKE ST 317   Berkeley 94704 37.86397363482743 -122.26233933170656
11438 11438 11438 055 182000101 2033 Blake St Apt 510 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 510 APT Berkeley 94704 37.863306481776334 -122.26834733529368
11553 11553 11553 055 182102000 2016 Blake St 7 2016 BLAKE ST 7 2016 BLAKE ST 2016.0 BLAKE ST 7   Berkeley 94704 37.862555003012325 -122.2689708155082

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