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

109 rows where street_name = "CHANNING" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94703 · 109 ✖

street_type 1

street_name 1

  • CHANNING · 109 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
280 280 280 055 191000101 1626 Channing Way A 1626 CHANNING WAY A 1626 CHANNING WY 1626.0 CHANNING WY A   Berkeley 94703 37.86427703553314 -122.27775421536955
948 948 948 055 190803600 1707 Channing Way 1707 CHANNING WAY 1707 CHANNING WY 1707.0 CHANNING WY     Berkeley 94703 37.86485200641434 -122.27644615961974
1172 1172 1172 055 191303800 1546 Channing Way 1546 CHANNING WAY 1546 CHANNING WY 1546.0 CHANNING WY     Berkeley 94703 37.86408297105082 -122.27932853356624
2679 2679 2679 055 190802200 1701 Channing Way 1701 CHANNING WAY 1701 CHANNING WY 1701.0 CHANNING WY     Berkeley 94703 37.86476679144375 -122.2766183612698
4364 4364 4364 055 190501900 1735 Channing Way 1735 CHANNING WAY 1735 CHANNING WY 1735.0 CHANNING WY     Berkeley 94703 37.86504445477146 -122.27496010718797
5023 5023 5023 055 190802000 1711 Channing Way 4 1711 CHANNING WAY 4 1711 CHANNING WY 1711.0 CHANNING WY 4   Berkeley 94703 37.86487208484813 -122.2762821254522
5951 5951 5951 055 190200200 1842 Channing Way 1842 CHANNING WAY 1842 CHANNING WY 1842.0 CHANNING WY     Berkeley 94703 37.86485297303302 -122.27293644090636
6786 6786 6786 055 191000300 1636 Channing Way 1636 CHANNING WAY 1636 CHANNING WY 1636.0 CHANNING WY     Berkeley 94703 37.86428617628518 -122.27735172071496
7307 7307 7307 055 191405100 1501 Channing Way 1501 CHANNING WAY 1501 CHANNING WY 1501.0 CHANNING WY     Berkeley 94703 37.86423342103166 -122.28105684096892
7477 7477 7477 055 190501800 1737 Channing Way 1737 CHANNING WAY 1737 CHANNING WY 1737.0 CHANNING WY     Berkeley 94703 37.86506541679432 -122.27480640903607
8980 8980 8980 055 190902400 1627 Channing Way 1627 CHANNING WAY 1627 CHANNING WY 1627.0 CHANNING WY     Berkeley 94703 37.86467880061937 -122.27779851309285
9258 9258 9258 055 191000102 1630 Channing Way 1630 CHANNING WAY 1630 CHANNING WY 1630.0 CHANNING WY     Berkeley 94703 37.86429593332219 -122.27760138499028
10289 10289 10289 055 190502300 1727 Channing Way 2 1727 CHANNING WAY 2 1727 CHANNING WY 1727.0 CHANNING WY 2   Berkeley 94703 37.86490978366712 -122.27551559571522
10937 10937 10937 055 191404900 1505 Channing Way 1505 CHANNING WAY 1505 CHANNING WY 1505.0 CHANNING WY     Berkeley 94703 37.86425782924148 -122.28082271485304
11069 11069 11069 055 191000101 1626 Channing Way B 1626 CHANNING WAY B 1626 CHANNING WY 1626.0 CHANNING WY B   Berkeley 94703 37.86427703553314 -122.27775421536955
11193 11193 11193 055 191100400 1616 Channing Way 3 1616 CHANNING WAY 3 1616 CHANNING WY 1616.0 CHANNING WY 3   Berkeley 94703 37.864200957114335 -122.27821323741176
11386 11386 11386 055 191202600 1607 Channing Way 1607 CHANNING WAY 1607 CHANNING WY 1607.0 CHANNING WY     Berkeley 94703 37.86454852155492 -122.27867026429568
11683 11683 11683 055 190300200 1814 Channing Way 1814 CHANNING WAY 1814 CHANNING WY 1814.0 CHANNING WY     Berkeley 94703 37.86476660918311 -122.27383696424944
11794 11794 11794 055 190300102 1802 Channing Way 2 1802 CHANNING WAY 2 1802 CHANNING WY 1802.0 CHANNING WY 2   Berkeley 94703 37.864746442072345 -122.2742989686984
11899 11899 11899 055 191100400 1616 Channing Way 1616 CHANNING WAY 1616 CHANNING WY 1616.0 CHANNING WY     Berkeley 94703 37.864200957114335 -122.27821323741176
12005 12005 12005 055 190600200 1732 Channing Way 1732 CHANNING WAY 1732 CHANNING WY 1732.0 CHANNING WY     Berkeley 94703 37.86454516851589 -122.27533962563253
12251 12251 12251 055 191202200 1619 Channing Way 1619 CHANNING WAY 1619 CHANNING WY 1619.0 CHANNING WY     Berkeley 94703 37.86456329818617 -122.27818301988222
12843 12843 12843 055 191100400 1616 Channing Way 4 1616 CHANNING WAY 4 1616 CHANNING WY 1616.0 CHANNING WY 4   Berkeley 94703 37.864200957114335 -122.27821323741176
13438 13438 13438 055 190100900 1849 Channing Way 1849 CHANNING WAY 1849 CHANNING WY 1849.0 CHANNING WY     Berkeley 94703 37.86526787609832 -122.27261808964778
13985 13985 13985 055 190802000 1709 Channing Way 3 1709 CHANNING WAY 3 1709 CHANNING WY 1709.0 CHANNING WY 3   Berkeley 94703 37.86487208484813 -122.2762821254522
14498 14498 14498 055 191301900 1545 Channing Way 1545 CHANNING WAY 1545 CHANNING WY 1545.0 CHANNING WY     Berkeley 94703 37.86441842310331 -122.27949960603398
15281 15281 15281 055 190803600 1705 Channing Way 1705 CHANNING WAY 1705 CHANNING WY 1705.0 CHANNING WY     Berkeley 94703 37.86485200641434 -122.27644615961974
15663 15663 15663 055 190101200 1833 Channing Way 1833 CHANNING WAY 1833 CHANNING WY 1833.0 CHANNING WY     Berkeley 94703 37.865262757941245 -122.27305196604851
16717 16717 16717 055 190902200 1633 Channing Way 1633 CHANNING WAY 1633 CHANNING WY 1633.0 CHANNING WY     Berkeley 94703 37.86470876515456 -122.27755500317552
17265 17265 17265 055 190101300 1829 Channing Way 1829 CHANNING WAY 1829 CHANNING WY 1829.0 CHANNING WY     Berkeley 94703 37.865244997926304 -122.27317621203548
17327 17327 17327 055 190902100 1635 Channing Way 1635 CHANNING WAY 1635 CHANNING WY 1635.0 CHANNING WY     Berkeley 94703 37.86472265527128 -122.27744782428064
17350 17350 17350 055 190300102 1802 Channing Way 6 1802 CHANNING WAY 6 1802 CHANNING WY 1802.0 CHANNING WY 6   Berkeley 94703 37.864746442072345 -122.2742989686984
18573 18573 18573 055 191100400 1616 Channing Way 2 1616 CHANNING WAY 2 1616 CHANNING WY 1616.0 CHANNING WY 2   Berkeley 94703 37.864200957114335 -122.27821323741176
18640 18640 18640 055 190600400 1736 Channing Way 1736 CHANNING WAY 1736 CHANNING WY 1736.0 CHANNING WY     Berkeley 94703 37.86461425754216 -122.275069400717
18999 18999 18999 055 191202500 1609 Channing Way 1609 CHANNING WAY 1609 CHANNING WY 1609.0 CHANNING WY     Berkeley 94703 37.8645795903477 -122.27856094741048
19134 19134 19134 055 191202400 1611 Channing Way 1611 CHANNING WAY 1611 CHANNING WY 1611.0 CHANNING WY     Berkeley 94703 37.8645924344377 -122.27845735818347
19447 19447 19447 055 190902000 1637 Channing Way 1637 CHANNING WAY 1637 CHANNING WY 1637.0 CHANNING WY     Berkeley 94703 37.86473515679962 -122.27734172426244
19452 19452 19452 055 190502100 1731 Channing Way 1731 CHANNING WAY 1731 CHANNING WY 1731.0 CHANNING WY     Berkeley 94703 37.86500890342796 -122.27523900623588
20153 20153 20153 055 190502000 1733 Channing Way 1733 CHANNING WAY 1733 CHANNING WY 1733.0 CHANNING WY     Berkeley 94703 37.86502628337772 -122.27510080941256
20452 20452 20452 055 190700200 1712 Channing Way A 1712 CHANNING WAY A 1712 CHANNING WY 1712.0 CHANNING WY A   Berkeley 94703 37.86443097361726 -122.27625744873136
20850 20850 20850 055 190802000 1711 Channing Way 1711 CHANNING WAY 1711 CHANNING WY 1711.0 CHANNING WY     Berkeley 94703 37.86487208484813 -122.2762821254522
21076 21076 21076 055 190501800 1739 Channing Way 1739 CHANNING WAY 1739 CHANNING WY 1739.0 CHANNING WY     Berkeley 94703 37.86506541679432 -122.27480640903607
21494 21494 21494 055 191100300 1614 Channing Way 1614 CHANNING WAY 1614 CHANNING WY 1614.0 CHANNING WY     Berkeley 94703 37.86418495067309 -122.27833671174588
21702 21702 21702 055 190300102 1802 Channing Way 1802 CHANNING WAY 1802 CHANNING WY 1802.0 CHANNING WY     Berkeley 94703 37.864746442072345 -122.2742989686984
22260 22260 22260 055 190401700 1805 Channing Way 1805 CHANNING WAY 1805 CHANNING WY 1805.0 CHANNING WY     Berkeley 94703 37.865137885293954 -122.27425810253948
22793 22793 22793 055 190300102 1802 Channing Way 3 1802 CHANNING WAY 3 1802 CHANNING WY 1802.0 CHANNING WY 3   Berkeley 94703 37.864746442072345 -122.2742989686984
22869 22869 22869 055 191000400 1640 Channing Way 1640 CHANNING WAY 1640 CHANNING WY 1640.0 CHANNING WY     Berkeley 94703 37.86430610097891 -122.27720490635312
23416 23416 23416 055 190802000 1709 Channing Way 1 1709 CHANNING WAY 1 1709 CHANNING WY 1709.0 CHANNING WY 1   Berkeley 94703 37.86487208484813 -122.2762821254522
23566 23566 23566 055 191100400 1616 Channing Way 1 1616 CHANNING WAY 1 1616 CHANNING WY 1616.0 CHANNING WY 1   Berkeley 94703 37.864200957114335 -122.27821323741176
23593 23593 23593 055 190801800 1719 Channing Way 1719 CHANNING WAY 1719 CHANNING WY 1719.0 CHANNING WY     Berkeley 94703 37.86485960249097 -122.27593021493124
23650 23650 23650 055 191303600 1532 Channing Way 1532 CHANNING WAY 1532 CHANNING WY 1532.0 CHANNING WY     Berkeley 94703 37.864030312102024 -122.27987805099184
24949 24949 24949 055 190200300 1844 Channing Way 1844 CHANNING WAY 1844 CHANNING WY 1844.0 CHANNING WY     Berkeley 94703 37.8648787490544 -122.2728218922329
25613 25613 25613 055 190802000 1711 Channing Way 2 1711 CHANNING WAY 2 1711 CHANNING WY 1711.0 CHANNING WY 2   Berkeley 94703 37.86487208484813 -122.2762821254522
25838 25838 25838 055 191000200 1634 Channing Way 1634 CHANNING WAY 1634 CHANNING WY 1634.0 CHANNING WY     Berkeley 94703 37.86427274067712 -122.27746308845396
26782 26782 26782 055 190101000 1839 Channing Way 1839 CHANNING WAY 1839 CHANNING WY 1839.0 CHANNING WY     Berkeley 94703 37.86533813033898 -122.27284322272934
27115 27115 27115 055 190700200 1712 Channing Way 1712 CHANNING WAY 1712 CHANNING WY 1712.0 CHANNING WY     Berkeley 94703 37.86443097361726 -122.27625744873136
28928 28928 28928 055 191202800 1601 Channing Way 1601 CHANNING WAY 1601 CHANNING WY 1601.0 CHANNING WY     Berkeley 94703 37.86450746809198 -122.27891272767572
28952 28952 28952 055 191202200 1617 Channing Way 1617 CHANNING WAY 1617 CHANNING WY 1617.0 CHANNING WY     Berkeley 94703 37.86456329818617 -122.27818301988222
29019 29019 29019 055 190802000 1709 Channing Way 1709 CHANNING WAY 1709 CHANNING WY 1709.0 CHANNING WY     Berkeley 94703 37.86487208484813 -122.2762821254522
29042 29042 29042 055 191202700 1605 Channing Way 1605 CHANNING WAY 1605 CHANNING WY 1605.0 CHANNING WY     Berkeley 94703 37.86453578525379 -122.27878343675012
29332 29332 29332 055 190801900 1715 Channing Way 1715 CHANNING WAY 1715 CHANNING WY 1715.0 CHANNING WY     Berkeley 94703 37.86489464400299 -122.27611110778167
29862 29862 29862 055 191100200 1608 Channing Way 1608 CHANNING WAY 1608 CHANNING WY 1608.0 CHANNING WY     Berkeley 94703 37.864137129192954 -122.2784940588544
31238 31238 31238 055 191302100 1537 Channing Way 1537 CHANNING WAY 1537 CHANNING WY 1537.0 CHANNING WY     Berkeley 94703 37.86442875882086 -122.27974410858972
31882 31882 31882 055 191100100 1600 Channing Way 1600 CHANNING WAY 1600 CHANNING WY 1600.0 CHANNING WY     Berkeley 94703 37.86418341740192 -122.27876458380727
32056 32056 32056 055 191301800 1549 Channing Way 1549 CHANNING WAY 1549 CHANNING WY 1549.0 CHANNING WY     Berkeley 94703 37.86443268488965 -122.27934323000429
32545 32545 32545 055 191202300 1615 Channing Way 1615 CHANNING WAY 1615 CHANNING WY 1615.0 CHANNING WY     Berkeley 94703 37.86460636358166 -122.27834428095044
33266 33266 33266 055 190502300 1727 Channing Way 1727 CHANNING WAY 1727 CHANNING WY 1727.0 CHANNING WY     Berkeley 94703 37.86490978366712 -122.27551559571522
34000 34000 34000 055 190101400 1827 Channing Way 1827 CHANNING WAY 1827 CHANNING WY 1827.0 CHANNING WY     Berkeley 94703 37.86522794566977 -122.27330312781544
34722 34722 34722 055 190502300 1727 Channing Way 3 1727 CHANNING WAY 3 1727 CHANNING WY 1727.0 CHANNING WY 3   Berkeley 94703 37.86490978366712 -122.27551559571522
34859 34859 34859 055 191303700 1540 Channing Way 1540 CHANNING WAY 1540 CHANNING WY 1540.0 CHANNING WY     Berkeley 94703 37.86406063504304 -122.27955495034034
35296 35296 35296 055 190600100 1728 Channing Way 1728 CHANNING WAY 1728 CHANNING WY 1728.0 CHANNING WY     Berkeley 94703 37.86452647787361 -122.2754847251105
36103 36103 36103 055 190100900 1845 Channing Way 1845 CHANNING WAY 1845 CHANNING WY 1845.0 CHANNING WY     Berkeley 94703 37.86526787609832 -122.27261808964778
36500 36500 36500 055 191302000 1548 Channing Way 1548 CHANNING WAY 1548 CHANNING WY 1548.0 CHANNING WY     Berkeley 94703 37.86444711333251 -122.27963112657812
36651 36651 36651 055 191400200 1512 Channing Way 1512 CHANNING WAY 1512 CHANNING WY 1512.0 CHANNING WY     Berkeley 94703 37.86391660149408 -122.28080140591616
36841 36841 36841 055 190700200 1712 Channing Way B 1712 CHANNING WAY B 1712 CHANNING WY 1712.0 CHANNING WY B   Berkeley 94703 37.86443097361726 -122.27625744873136
37147 37147 37147 055 190300102 1802 Channing Way 5 1802 CHANNING WAY 5 1802 CHANNING WY 1802.0 CHANNING WY 5   Berkeley 94703 37.864746442072345 -122.2742989686984
39453 39453 39453 055 190901900 1639 Channing Way 1639 CHANNING WAY 1639 CHANNING WY 1639.0 CHANNING WY     Berkeley 94703 37.86474993906692 -122.27722852036698
39511 39511 39511 055 190703900 1708 Channing Way 1708 CHANNING WAY 1708 CHANNING WY 1708.0 CHANNING WY     Berkeley 94703 37.86439687014192 -122.27651326826302
41226 41226 41226 055 190100900 1847 Channing Way 1847 CHANNING WAY 1847 CHANNING WY 1847.0 CHANNING WY     Berkeley 94703 37.86526787609832 -122.27261808964778
42368 42368 42368 055 190700200 1712 Channing Way 2 1712 CHANNING WAY 2 1712 CHANNING WY 1712.0 CHANNING WY 2   Berkeley 94703 37.86443097361726 -122.27625744873136
43225 43225 43225 055 190401600 1809 Channing Way 1809 CHANNING WAY 1809 CHANNING WY 1809.0 CHANNING WY     Berkeley 94703 37.86514852727716 -122.27412060819871
43242 43242 43242 055 190100900 1843 Channing Way 1843 CHANNING WAY 1843 CHANNING WY 1843.0 CHANNING WY     Berkeley 94703 37.86526787609832 -122.27261808964778
43368 43368 43368 055 191000101 1626 Channing Way 1626 CHANNING WAY 1626 CHANNING WY 1626.0 CHANNING WY     Berkeley 94703 37.86427703553314 -122.27775421536955
43509 43509 43509 055 190502300 1727 Channing Way 1 1727 CHANNING WAY 1 1727 CHANNING WY 1727.0 CHANNING WY 1   Berkeley 94703 37.86490978366712 -122.27551559571522
44089 44089 44089 055 190902300 1631 Channing Way 1631 CHANNING WAY 1631 CHANNING WY 1631.0 CHANNING WY     Berkeley 94703 37.86469598491157 -122.27765946017507
44107 44107 44107 055 190101100 1835 Channing Way 1835 CHANNING WAY 1835 CHANNING WY 1835.0 CHANNING WY     Berkeley 94703 37.8653276238366 -122.27294692873733
45334 45334 45334 055 190401500 1825 Channing Way A 1825 CHANNING WAY A 1825 CHANNING WY 1825.0 CHANNING WY A   Berkeley 94703 37.86516846875806 -122.2739703910186
45988 45988 45988 055 190802000 1709 Channing Way 2 1709 CHANNING WAY 2 1709 CHANNING WY 1709.0 CHANNING WY 2   Berkeley 94703 37.86487208484813 -122.2762821254522
46784 46784 46784 055 191400300 1522 Channing Way 1522 CHANNING WAY 1522 CHANNING WY 1522.0 CHANNING WY     Berkeley 94703 37.86395011797958 -122.28054141999824
47304 47304 47304 055 190700200 1712 Channing Way X 1712 CHANNING WAY X 1712 CHANNING WY 1712.0 CHANNING WY X   Berkeley 94703 37.86443097361726 -122.27625744873136
47894 47894 47894 055 190300102 1802 Channing Way 4 1802 CHANNING WAY 4 1802 CHANNING WY 1802.0 CHANNING WY 4   Berkeley 94703 37.864746442072345 -122.2742989686984
49049 49049 49049 055 191000101 1626 Channing Way C 1626 CHANNING WAY C 1626 CHANNING WY 1626.0 CHANNING WY C   Berkeley 94703 37.86427703553314 -122.27775421536955
49388 49388 49388 055 191405000 1503 Channing Way 1503 CHANNING WAY 1503 CHANNING WY 1503.0 CHANNING WY     Berkeley 94703 37.86424432129081 -122.28094633471422
50216 50216 50216 055 190502200 1729 Channing Way 1729 CHANNING WAY 1729 CHANNING WY 1729.0 CHANNING WY     Berkeley 94703 37.86499219577991 -122.27537111966808
50257 50257 50257 055 190802000 1711 Channing Way 5 1711 CHANNING WAY 5 1711 CHANNING WY 1711.0 CHANNING WY 5   Berkeley 94703 37.86487208484813 -122.2762821254522
50310 50310 50310 055 191302000 1541 Channing Way 1541 CHANNING WAY 1541 CHANNING WY 1541.0 CHANNING WY     Berkeley 94703 37.86444711333251 -122.27963112657812
50755 50755 50755 055 190802000 1711 Channing Way 3 1711 CHANNING WAY 3 1711 CHANNING WY 1711.0 CHANNING WY 3   Berkeley 94703 37.86487208484813 -122.2762821254522
50944 50944 50944 055 190300101 1808 Channing Way 1808 CHANNING WAY 1808 CHANNING WY 1808.0 CHANNING WY     Berkeley 94703 37.86471546696246 -122.27402113774733
51184 51184 51184 055 190501900 1735 Channing Way A 1735 CHANNING WAY A 1735 CHANNING WY 1735.0 CHANNING WY A   Berkeley 94703 37.86504445477146 -122.27496010718797
53307 53307 53307 055 190401500 1825 Channing Way 1825 CHANNING WAY 1825 CHANNING WY 1825.0 CHANNING WY     Berkeley 94703 37.86516846875806 -122.2739703910186

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