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

257 rows where street_name = "BLAKE" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94703 · 257 ✖

street_type 1

street_name 1

  • BLAKE · 257 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
693 693 693 054 180601400 1611 Blake St 1611 BLAKE ST 1611 BLAKE ST 1611.0 BLAKE ST     Berkeley 94703 37.86195436412373 -122.27807197104514
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
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
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
1975 1975 1975 054 180001900 1500 Blake St 1500 BLAKE ST 1500 BLAKE ST 1500.0 BLAKE ST     Berkeley 94703 37.861138002756 -122.28040407028624
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
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
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
2941 2941 2941 054 180503400 1638 Blake St 1638 BLAKE ST 1638 BLAKE ST 1638.0 BLAKE ST     Berkeley 94703 37.86166587716642 -122.27660638403212
3435 3435 3435 054 179701400 1521 Blake St 1521 BLAKE ST 1521 BLAKE ST 1521.0 BLAKE ST     Berkeley 94703 37.861731241968855 -122.27976945365712
3480 3480 3480 054 180502700 1614 Blake St 1614 BLAKE ST 1614 BLAKE ST 1614.0 BLAKE ST     Berkeley 94703 37.86145782855424 -122.27778546506336
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
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
5007 5007 5007 054 180003000 1540 Blake St 1540 BLAKE ST 1540 BLAKE ST 1540.0 BLAKE ST     Berkeley 94703 37.86130712680814 -122.27895027366134
5114 5114 5114 054 181401100 1809 Blake St 1809 BLAKE ST 1809 BLAKE ST 1809.0 BLAKE ST     Berkeley 94703 37.862530710548505 -122.27361025282794
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
5377 5377 5377 054 180701700 1711 Blake St 1711 BLAKE ST 1711 BLAKE ST 1711.0 BLAKE ST     Berkeley 94703 37.8622356223946 -122.27593571890895
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
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
5899 5899 5899 054 179701701 1501 Blake St Apt 305 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 305 APT Berkeley 94703 37.86157922022132 -122.2804848997972
6452 6452 6452 054 180701700 1711 Blake St A 1711 BLAKE ST A 1711 BLAKE ST 1711.0 BLAKE ST A   Berkeley 94703 37.8622356223946 -122.27593571890895
6535 6535 6535 054 179701701 1501 Blake St Apt 315 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 315 APT Berkeley 94703 37.86180098185475 -122.28053007068291
6733 6733 6733 054 181401100 1809 Blake St B 1809 BLAKE ST B 1809 BLAKE ST 1809.0 BLAKE ST B   Berkeley 94703 37.862530710548505 -122.27361025282794
6798 6798 6798 054 181303100 1814 Blake St 3 1814 BLAKE ST 3 1814 BLAKE ST 1814.0 BLAKE ST 3   Berkeley 94703 37.861987852423965 -122.27327243777206
6821 6821 6821 054 179701701 1501 Blake St Apt 402 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 402 APT Berkeley 94703 37.86152117085506 -122.28054440869316
6913 6913 6913 054 181400900 1821 Blake St B 1821 BLAKE ST B 1821 BLAKE ST 1821.0 BLAKE ST B   Berkeley 94703 37.862575301925965 -122.2732735076656
6977 6977 6977 054 180601100 1621 Blake St 20 1621 BLAKE ST 20 1621 BLAKE ST 1621.0 BLAKE ST 20   Berkeley 94703 37.862009793319665 -122.27765919247712
7241 7241 7241 054 179701701 1501 Blake St Apt 213 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 213 APT Berkeley 94703 37.861779267845435 -122.28045672683322
7771 7771 7771 054 180002300 1518 Blake St 1518 BLAKE ST 1518 BLAKE ST 1518.0 BLAKE ST     Berkeley 94703 37.86119069781399 -122.27985599286002
7866 7866 7866 054 179701701 1501 Blake St Apt 311 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 311 APT Berkeley 94703 37.86174026814385 -122.2805177035764
8262 8262 8262 054 179701601 1515 Blake St 1515 BLAKE ST 1515 BLAKE ST 1515.0 BLAKE ST     Berkeley 94703 37.86169643086595 -122.28003291336027
9340 9340 9340 054 181403800 1807 Blake St 1807 BLAKE ST 1807 BLAKE ST 1807.0 BLAKE ST     Berkeley 94703 37.8624613131912 -122.27379226857248
9343 9343 9343 054 181300203 1844 Blake St 4 1844 BLAKE ST 4 1844 BLAKE ST 1844.0 BLAKE ST 4   Berkeley 94703 37.86212831390125 -122.27247112886056
9630 9630 9630 054 180701300 1721 Blake St 1721 BLAKE ST 1721 BLAKE ST 1721.0 BLAKE ST     Berkeley 94703 37.86230491712909 -122.27538912190636
9649 9649 9649 054 179701701 1501 Blake St Apt 316 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 316 APT Berkeley 94703 37.86181616116118 -122.2805331617858
9655 9655 9655 054 180802800 1716 Blake St 1716 BLAKE ST 1716 BLAKE ST 1716.0 BLAKE ST     Berkeley 94703 37.861771677125006 -122.27540841143046
10063 10063 10063 054 181400900 1821 Blake St A 1821 BLAKE ST A 1821 BLAKE ST 1821.0 BLAKE ST A   Berkeley 94703 37.862575301925965 -122.2732735076656
10436 10436 10436 054 181401100 1809 Blake St G 1809 BLAKE ST G 1809 BLAKE ST 1809.0 BLAKE ST G   Berkeley 94703 37.862530710548505 -122.27361025282794
10738 10738 10738 054 180701400 1717 Blake St D 1717 BLAKE ST D 1717 BLAKE ST 1717.0 BLAKE ST D   Berkeley 94703 37.86228865637907 -122.27552643119418
10916 10916 10916 054 181202300 1818 Blake St 2 1818 BLAKE ST 2 1818 BLAKE ST 1818.0 BLAKE ST 2   Berkeley 94703 37.861119944583585 -122.27288789954169
11104 11104 11104 054 180803200 1734 Blake St 2 1734 BLAKE ST 2 1734 BLAKE ST 1734.0 BLAKE ST 2   Berkeley 94703 37.86179464928238 -122.27475613032962
11185 11185 11185 054 181302500 1824 Blake St 1824 BLAKE ST 1824 BLAKE ST 1824.0 BLAKE ST     Berkeley 94703 37.86204707942326 -122.27281653557884
11559 11559 11559 054 181300203 1844 Blake St B 1844 BLAKE ST B 1844 BLAKE ST 1844.0 BLAKE ST B   Berkeley 94703 37.86212831390125 -122.27247112886056
11787 11787 11787 054 180803400 1742 Blake St 3 1742 BLAKE ST 3 1742 BLAKE ST 1742.0 BLAKE ST 3   Berkeley 94703 37.86188481019682 -122.27441848595367
12031 12031 12031 054 181302600 1834 Blake St 1834 BLAKE ST 1834 BLAKE ST 1834.0 BLAKE ST     Berkeley 94703 37.862067780599745 -122.2726456275028
12076 12076 12076 054 180002800 1532 Blake St 1532 BLAKE ST 1532 BLAKE ST 1532.0 BLAKE ST     Berkeley 94703 37.861279300603755 -122.27918084424532
12295 12295 12295 054 180601100 1621 Blake St 6 1621 BLAKE ST 6 1621 BLAKE ST 1621.0 BLAKE ST 6   Berkeley 94703 37.862009793319665 -122.27765919247712
12455 12455 12455 054 179701701 1501 Blake St Apt 212 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 212 APT Berkeley 94703 37.86176408924064 -122.28045363393372
12655 12655 12655 054 180502802 1620 Blake St 3 1620 BLAKE ST 3 1620 BLAKE ST 1620.0 BLAKE ST 3   Berkeley 94703 37.86150545744752 -122.27741925426136
12708 12708 12708 054 180503300 1634 Blake St 1634 BLAKE ST 1634 BLAKE ST 1634.0 BLAKE ST     Berkeley 94703 37.86159724778493 -122.27671988616828
12813 12813 12813 054 181202600 1834 Blake St C 1834 BLAKE ST C 1834 BLAKE ST 1834.0 BLAKE ST C   Berkeley 94703 37.86117028717141 -122.27248194367824
12837 12837 12837 054 179701701 1501 Blake St Apt 203 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 203 APT Berkeley 94703 37.8615549501308 -122.28041103492464
12995 12995 12995 054 180003200 1544 Blake St 1544 BLAKE ST 1544 BLAKE ST 1544.0 BLAKE ST     Berkeley 94703 37.8613722493761 -122.27872485491552
13224 13224 13224 054 181403800 1805 Blake St 1805 BLAKE ST 1805 BLAKE ST 1805.0 BLAKE ST     Berkeley 94703 37.8624613131912 -122.27379226857248
13283 13283 13283 054 180803400 1742 Blake St 4 1742 BLAKE ST 4 1742 BLAKE ST 1742.0 BLAKE ST 4   Berkeley 94703 37.86188481019682 -122.27441848595367
13490 13490 13490 054 181300203 1844 Blake St 1 1844 BLAKE ST 1 1844 BLAKE ST 1844.0 BLAKE ST 1   Berkeley 94703 37.86212831390125 -122.27247112886056
13568 13568 13568 054 179701701 1501 Blake St Apt 218 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 218 APT Berkeley 94703 37.86185516082265 -122.28047218504264
13634 13634 13634 054 179701701 1501 Blake St Apt 401 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 401 APT Berkeley 94703 37.86150471347904 -122.28054105618052
13973 13973 13973 054 181300203 1844 Blake St 1844 BLAKE ST 1844 BLAKE ST 1844.0 BLAKE ST     Berkeley 94703 37.86212831390125 -122.27247112886056
14685 14685 14685 054 180002000 1506 Blake St 1506 BLAKE ST 1506 BLAKE ST 1506.0 BLAKE ST     Berkeley 94703 37.86113711197514 -122.28025058234016
14778 14778 14778 054 180803100 1730 Blake St 1730 BLAKE ST 1730 BLAKE ST 1730.0 BLAKE ST     Berkeley 94703 37.86182761780146 -122.27497409216026
14926 14926 14926 054 181302300 1818 Blake St 1818 BLAKE ST 1818 BLAKE ST 1818.0 BLAKE ST     Berkeley 94703 37.8620064969021 -122.27313951585612
15535 15535 15535 054 181401100 1809 Blake St 7 1809 BLAKE ST 7 1809 BLAKE ST 1809.0 BLAKE ST 7   Berkeley 94703 37.862530710548505 -122.27361025282794
15846 15846 15846 054 181301800 1800 Blake St 1800 BLAKE ST 1800 BLAKE ST 1800.0 BLAKE ST     Berkeley 94703 37.86191463544392 -122.2738346277314
16475 16475 16475 054 179701701 1501 Blake St Apt 302 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 302 APT Berkeley 94703 37.86152985024883 -122.28047484405587
16837 16837 16837 054 180503100 1630 Blake St 1630 BLAKE ST 1630 BLAKE ST 1630.0 BLAKE ST     Berkeley 94703 37.861561260738114 -122.27699021079684
17084 17084 17084 054 180701700 1711 Blake St D 1711 BLAKE ST D 1711 BLAKE ST 1711.0 BLAKE ST D   Berkeley 94703 37.8622356223946 -122.27593571890895
17228 17228 17228 054 180600600 1635 Blake St 1635 BLAKE ST 1635 BLAKE ST 1635.0 BLAKE ST     Berkeley 94703 37.862099353978294 -122.276952840881
17539 17539 17539 054 181401000 1817 Blake St 1817 BLAKE ST 1817 BLAKE ST 1817.0 BLAKE ST     Berkeley 94703 37.86255340375101 -122.2734409994486
18295 18295 18295 054 181401100 1809 Blake St E 1809 BLAKE ST E 1809 BLAKE ST 1809.0 BLAKE ST E   Berkeley 94703 37.862530710548505 -122.27361025282794
18317 18317 18317 054 179701701 1501 Blake St Apt 405 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 405 APT Berkeley 94703 37.861570540124134 -122.28055446443447
18389 18389 18389 054 180002600 1526 Blake St 1526 BLAKE ST 1526 BLAKE ST 1526.0 BLAKE ST     Berkeley 94703 37.86124311765715 -122.2794528514184
18462 18462 18462 054 180002200 1516 Blake St 1516 BLAKE ST 1516 BLAKE ST 1516.0 BLAKE ST     Berkeley 94703 37.86117278717222 -122.27998814312316
18694 18694 18694 054 180803000 1726 Blake St 1726 BLAKE ST 1726 BLAKE ST 1726.0 BLAKE ST     Berkeley 94703 37.86180403785797 -122.27514679327363
18937 18937 18937 054 181303100 1814 Blake St 4 1814 BLAKE ST 4 1814 BLAKE ST 1814.0 BLAKE ST 4   Berkeley 94703 37.861987852423965 -122.27327243777206
18991 18991 18991 054 180701000 1731 Blake St 1731 BLAKE ST 1731 BLAKE ST 1731.0 BLAKE ST     Berkeley 94703 37.862359348204755 -122.27496684994249
19200 19200 19200 054 180701600 1713 Blake St 1713 BLAKE ST 1713 BLAKE ST 1713.0 BLAKE ST     Berkeley 94703 37.86225304342335 -122.27580111894008
19299 19299 19299 054 180701400 1717 Blake St A 1717 BLAKE ST A 1717 BLAKE ST 1717.0 BLAKE ST A   Berkeley 94703 37.86228865637907 -122.27552643119418
19494 19494 19494 054 180002900 1536 Blake St 1536 BLAKE ST 1536 BLAKE ST 1536.0 BLAKE ST     Berkeley 94703 37.861295810512296 -122.27905994358449
19731 19731 19731 054 181400300 1843 Blake St 1843 BLAKE ST 1843 BLAKE ST 1843.0 BLAKE ST     Berkeley 94703 37.8627041809613 -122.27228393163344
19915 19915 19915 054 180803200 1734 Blake St E 1734 BLAKE ST E 1734 BLAKE ST 1734.0 BLAKE ST E   Berkeley 94703 37.86179464928238 -122.27475613032962
20269 20269 20269 054 180803400 1742 Blake St 2 1742 BLAKE ST 2 1742 BLAKE ST 1742.0 BLAKE ST 2   Berkeley 94703 37.86188481019682 -122.27441848595367
20612 20612 20612 054 180700700 1739 Blake St 1739 BLAKE ST 1739 BLAKE ST 1739.0 BLAKE ST     Berkeley 94703 37.862391369678114 -122.2746315214233
20670 20670 20670 054 179701701 1501 Blake St Apt 309 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 309 APT Berkeley 94703 37.8616450460907 -122.28049830805112
20716 20716 20716 054 181400800 1825 Blake St 2 1825 BLAKE ST 2 1825 BLAKE ST 1825.0 BLAKE ST 2   Berkeley 94703 37.86259748377696 -122.27310169498602
20719 20719 20719 054 180601100 1621 Blake St 4 1621 BLAKE ST 4 1621 BLAKE ST 1621.0 BLAKE ST 4   Berkeley 94703 37.862009793319665 -122.27765919247712
20792 20792 20792 054 179701701 1501 Blake St Apt 208 1501 BLAKE ST 1501 BLAKE ST 1501.0 BLAKE ST 208 APT Berkeley 94703 37.86163723195349 -122.2804277956912
20905 20905 20905 054 180003100 1542 Blake St 1542 BLAKE ST 1542 BLAKE ST 1542.0 BLAKE ST     Berkeley 94703 37.861356733099555 -122.27884569269426
20952 20952 20952 054 180502802 1620 Blake St 2 1620 BLAKE ST 2 1620 BLAKE ST 1620.0 BLAKE ST 2   Berkeley 94703 37.86150545744752 -122.27741925426136

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