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

963 rows where street_name = "BLAKE" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 4

street_type 1

  • ST · 963 ✖

street_name 1

  • BLAKE · 963 ✖
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
693 693 693 054 180601400 1611 Blake St 1611 BLAKE ST 1611 BLAKE ST 1611.0 BLAKE ST     Berkeley 94703 37.86195436412373 -122.27807197104514
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
1005 1005 1005 054 180700600 1741 Blake St 1741 BLAKE ST 1741 BLAKE ST 1741.0 BLAKE ST     Berkeley 94703 37.86240166667347 -122.27453310110246
1072 1072 1072 054 179701701 1501 Blake St Apt 204 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 204 APT Berkeley 94703 37.8615714060772 -122.28041438743726
1261 1261 1261 054 179502600 1432 Blake St 1432 BLAKE ST 1432 BLAKE ST 1432.0 BLAKE ST     Berkeley 94702 37.86096716838137 -122.28156998291372
1573 1573 1573 054 180701400 1717 Blake St B 1717 BLAKE ST B 1717 BLAKE ST 1717.0 BLAKE ST B   Berkeley 94703 37.86228865637907 -122.27552643119418
1595 1595 1595 054 179701701 1501 Blake St Apt 403 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 403 APT Berkeley 94703 37.86153762680894 -122.28054776030751
1680 1680 1680 054 180502500 1606 Blake St 1606 BLAKE ST 1606 BLAKE ST 1606.0 BLAKE ST     Berkeley 94703 37.86150145817348 -122.27806445663776
1687 1687 1687 054 178200900 1221 Blake St 1221 BLAKE ST 1221 BLAKE ST 1221.0 BLAKE ST     Berkeley 94702 37.86090769370471 -122.28618689677432
1710 1710 1710 054 179601300 1441 Blake St 1441 BLAKE ST 1441 BLAKE ST 1441.0 BLAKE ST     Berkeley 94702 37.86142161945416 -122.2821811427341
1783 1783 1783 054 178402300 1126 Blake St 1126 BLAKE ST 1126 BLAKE ST 1126.0 BLAKE ST     Berkeley 94702 37.860151509564176 -122.28796759751764
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
1865 1865 1865 054 180802400 1704 Blake St 1704 BLAKE ST 1704 BLAKE ST 1704.0 BLAKE ST     Berkeley 94703 37.86175676305563 -122.27587663491612
1904 1904 1904 054 180803200 1734 Blake St 1 1734 BLAKE ST 1 1734 BLAKE ST 1734.0 BLAKE ST 1   Berkeley 94703 37.86179464928238 -122.27475613032962
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
1910 1910 1910 054 178200700 1227 Blake St 1227 BLAKE ST 1227 BLAKE ST 1227.0 BLAKE ST     Berkeley 94702 37.860942533549 -122.28591918534494
1975 1975 1975 054 180001900 1500 Blake St 1500 BLAKE ST 1500 BLAKE ST 1500.0 BLAKE ST     Berkeley 94703 37.861138002756 -122.28040407028624
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
2201 2201 2201 054 180802800 1716 Blake St B 1716 BLAKE ST B 1716 BLAKE ST 1716.0 BLAKE ST B   Berkeley 94703 37.861771677125006 -122.27540841143046
2241 2241 2241 054 180502600 1610 Blake St 1610 BLAKE ST 1610 BLAKE ST 1610.0 BLAKE ST     Berkeley 94703 37.8614410435056 -122.27792275009664
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
2370 2370 2370 054 180601100 1621 Blake St 9 1621 BLAKE ST 9 1621 BLAKE ST 1621.0 BLAKE ST 9   Berkeley 94703 37.862009793319665 -122.27765919247712
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
2458 2458 2458 054 179001900 1316 Blake St 1316 BLAKE ST 1316 BLAKE ST 1316.0 BLAKE ST     Berkeley 94702 37.86058354066074 -122.28456542690672
2483 2483 2483 054 179600700 1495 Blake St 1495 BLAKE ST 1495 BLAKE ST 1495.0 BLAKE ST     Berkeley 94702 37.86146461363617 -122.28143394564034
2558 2558 2558 054 178200400 1239 Blake St 1239 BLAKE ST 1239 BLAKE ST 1239.0 BLAKE ST     Berkeley 94702 37.86095251159683 -122.28549677683708
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
2702 2702 2702 054 179601500 1421 Blake St 1421 BLAKE ST 1421 BLAKE ST 1421.0 BLAKE ST     Berkeley 94702 37.86138900181635 -122.28241683012192
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
2752 2752 2752 054 180601100 1621 Blake St 8 1621 BLAKE ST 8 1621 BLAKE ST 1621.0 BLAKE ST 8   Berkeley 94703 37.862009793319665 -122.27765919247712
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
2941 2941 2941 054 180503400 1638 Blake St 1638 BLAKE ST 1638 BLAKE ST 1638.0 BLAKE ST     Berkeley 94703 37.86166587716642 -122.27660638403212
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
3435 3435 3435 054 179701400 1521 Blake St 1521 BLAKE ST 1521 BLAKE ST 1521.0 BLAKE ST     Berkeley 94703 37.861731241968855 -122.27976945365712
3447 3447 3447 054 178901800 1212 Blake St 1212 BLAKE ST 1212 BLAKE ST 1212.0 BLAKE ST     Berkeley 94702 37.860339183615665 -122.28650234018632
3480 3480 3480 054 180502700 1614 Blake St 1614 BLAKE ST 1614 BLAKE ST 1614.0 BLAKE ST     Berkeley 94703 37.86145782855424 -122.27778546506336
3514 3514 3514 054 179002500 1334 Blake St 1334 BLAKE ST 1334 BLAKE ST 1334.0 BLAKE ST     Berkeley 94702 37.86069473298995 -122.2837132266377
3596 3596 3596 055 183001001 2219 Blake St 2219 BLAKE ST 2219 BLAKE ST 2219.0 BLAKE ST     Berkeley 94704 37.86373497322378 -122.26414139259072
3619 3619 3619 054 179701701 1501 Blake St Apt 306 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 306 APT Berkeley 94703 37.861595676162295 -122.2804882523098
3646 3646 3646 054 180000100 1548 Blake St 1548 BLAKE ST 1548 BLAKE ST 1548.0 BLAKE ST     Berkeley 94703 37.86138444296294 -122.27862128545146
3647 3647 3647 054 179701701 1501 Blake St Apt 202 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 202 APT Berkeley 94703 37.86153849347157 -122.2804076833103
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
4517 4517 4517 054 181404200 1801 Blake St 1801 BLAKE ST 1801 BLAKE ST 1801.0 BLAKE ST     Berkeley 94703 37.86241766144551 -122.27391692149624
4621 4621 4621 054 180701700 1711 Blake St C 1711 BLAKE ST C 1711 BLAKE ST 1711.0 BLAKE ST C   Berkeley 94703 37.8622356223946 -122.27593571890895
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
4976 4976 4976 054 178101400 1111 Blake St A 1111 BLAKE ST A 1111 BLAKE ST 1111.0 BLAKE ST A   Berkeley 94702 37.860578266148615 -122.28875738733228
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
5007 5007 5007 054 180003000 1540 Blake St 1540 BLAKE ST 1540 BLAKE ST 1540.0 BLAKE ST     Berkeley 94703 37.86130712680814 -122.27895027366134
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
5114 5114 5114 054 181401100 1809 Blake St 1809 BLAKE ST 1809 BLAKE ST 1809.0 BLAKE ST     Berkeley 94703 37.862530710548505 -122.27361025282794
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
5278 5278 5278 054 180701800 1707 Blake St 1707 BLAKE ST 1707 BLAKE ST 1707.0 BLAKE ST     Berkeley 94703 37.86221799001709 -122.27607395525816
5289 5289 5289 054 179701701 1501 Blake St Apt 307 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 307 APT Berkeley 94703 37.861612132808766 -122.28049160392412
5298 5298 5298 054 180601300 1615 Blake St 1B 1615 BLAKE ST 1B 1615 BLAKE ST 1615.0 BLAKE ST 1B   Berkeley 94703 37.86197133912438 -122.27794068765624
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
5377 5377 5377 054 180701700 1711 Blake St 1711 BLAKE ST 1711 BLAKE ST 1711.0 BLAKE ST     Berkeley 94703 37.8622356223946 -122.27593571890895
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
5667 5667 5667 054 180601600 1601 Blake St 1601 BLAKE ST 1601 BLAKE ST 1601.0 BLAKE ST     Berkeley 94703 37.86188196057802 -122.27838980936568
5770 5770 5770 054 181301800 1800 Blake St A 1800 BLAKE ST A 1800 BLAKE ST 1800.0 BLAKE ST A   Berkeley 94703 37.86191463544392 -122.2738346277314
5797 5797 5797 054 178201000 1215 Blake St 1215 BLAKE ST 1215 BLAKE ST 1215.0 BLAKE ST     Berkeley 94702 37.860885369500586 -122.2863664448468
5893 5893 5893 054 180803200 1734 Blake St K 1734 BLAKE ST K 1734 BLAKE ST 1734.0 BLAKE ST K   Berkeley 94703 37.86179464928238 -122.27475613032962

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