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

835 rows where street_name = "CHANNING" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94704 · 835 ✖

street_type 1

street_name 1

  • CHANNING · 835 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
23 23 23 055 189500500 2035 Channing Way 303 2035 CHANNING WAY 303 2035 CHANNING WY 2035.0 CHANNING WY 303   Berkeley 94704 37.86597060980446 -122.26833746011376
124 124 124 055 189504000 2029 Channing Way B3 2029 CHANNING WAY B3 2029 CHANNING WY 2029.0 CHANNING WY B3   Berkeley 94704 37.86591312272657 -122.26855942753224
164 164 164 055 186900800 2717 Channing Way 15 2717 CHANNING WAY 15 2717 CHANNING WY 2717.0 CHANNING WY 15   Berkeley 94704 37.86785067038956 -122.2534200966928
361 361 361 055 186401000 2811 Channing Way 3 2811 CHANNING WAY 3 2811 CHANNING WY 2811.0 CHANNING WY 3   Berkeley 94704 37.8681748652217 -122.25123187971242
440 440 440 055 189101401 2100 Channing Way 213 2100 CHANNING WAY 213 2100 CHANNING WY 2100.0 CHANNING WY 213   Berkeley 94704 37.86559922796649 -122.26698131125856
450 450 450 055 188802700 2236 Channing Way 401 2236 CHANNING WAY 401 2236 CHANNING WY 2236.0 CHANNING WY 401   Berkeley 94704 37.866004184217175 -122.26367316102024
662 662 662 055 186801400 2700 Channing Way 5 2700 CHANNING WAY 5 2700 CHANNING WY 2700.0 CHANNING WY 5   Berkeley 94704 37.86735605382257 -122.25402870978938
744 744 744 055 188400500 2325 Channing Way 41 2325 CHANNING WAY 41 2325 CHANNING WY 2325.0 CHANNING WY 41   Berkeley 94704 37.866705428743 -122.26241642422596
748 748 748 055 189101401 2100 Channing Way 242 2100 CHANNING WAY 242 2100 CHANNING WY 2100.0 CHANNING WY 242   Berkeley 94704 37.86559922796649 -122.26698131125856
786 786 786 055 189102101 2150 Channing Way 14 2150 CHANNING WAY 14 2150 CHANNING WY 2150.0 CHANNING WY 14   Berkeley 94704 37.865777473837994 -122.2658738861426
862 862 862 055 189101401 2100 Channing Way 358 2100 CHANNING WAY 358 2100 CHANNING WY 2100.0 CHANNING WY 358   Berkeley 94704 37.86559922796649 -122.26698131125856
867 867 867 055 189101401 2100 Channing Way 305 2100 CHANNING WAY 305 2100 CHANNING WY 2100.0 CHANNING WY 305   Berkeley 94704 37.86559922796649 -122.26698131125856
869 869 869 055 188400305 2333 Channing Way 10 2333 CHANNING WAY 10 2333 CHANNING WY 2333.0 CHANNING WY 10   Berkeley 94704 37.866750492735896 -122.262072725205
871 871 871 055 189602100 2012 Channing Way D 2012 CHANNING WAY D 2012 CHANNING WY 2012.0 CHANNING WY D   Berkeley 94704 37.86527990309237 -122.26933463679154
880 880 880 055 188400403 2329 Channing Way J 2329 CHANNING WAY J 2329 CHANNING WY 2329.0 CHANNING WY J   Berkeley 94704 37.86672707960336 -122.26225319315228
1047 1047 1047 055 189504000 2029 Channing Way 2B 2029 CHANNING WAY 2B 2029 CHANNING WY 2029.0 CHANNING WY 2B   Berkeley 94704 37.86591312272657 -122.26855942753224
1056 1056 1056 055 188801100 2226 Channing Way 4 2226 CHANNING WAY 4 2226 CHANNING WY 2226.0 CHANNING WY 4   Berkeley 94704 37.866039237950055 -122.26416324680494
1089 1089 1089 055 188700700 2225 Channing Way 102 2225 CHANNING WAY 102 2225 CHANNING WY 2225.0 CHANNING WY 102   Berkeley 94704 37.866454208089955 -122.26440617371566
1164 1164 1164 055 186901000 2709 Channing Way 8 2709 CHANNING WAY 8 2709 CHANNING WY 2709.0 CHANNING WY 8   Berkeley 94704 37.867770315191066 -122.25375780035756
1248 1248 1248 055 189102101 2150 Channing Way 17 2150 CHANNING WAY 17 2150 CHANNING WY 2150.0 CHANNING WY 17   Berkeley 94704 37.865777473837994 -122.2658738861426
1419 1419 1419 055 189101401 2100 Channing Way 210 2100 CHANNING WAY 210 2100 CHANNING WY 2100.0 CHANNING WY 210   Berkeley 94704 37.86559922796649 -122.26698131125856
1425 1425 1425 055 188802700 2236 Channing Way 202 2236 CHANNING WAY 202 2236 CHANNING WY 2236.0 CHANNING WY 202   Berkeley 94704 37.866004184217175 -122.26367316102024
1488 1488 1488 055 189101401 2100 Channing Way 211 2100 CHANNING WAY 211 2100 CHANNING WY 2100.0 CHANNING WY 211   Berkeley 94704 37.86559922796649 -122.26698131125856
1578 1578 1578 055 189102101 2150 Channing Way 12 2150 CHANNING WAY 12 2150 CHANNING WY 2150.0 CHANNING WY 12   Berkeley 94704 37.865777473837994 -122.2658738861426
1642 1642 1642 055 188001502 2420 Channing Way 2420 CHANNING WAY 2420 CHANNING WY 2420.0 CHANNING WY     Berkeley 94704 37.866476639110104 -122.2600799609692
1755 1755 1755 055 188801100 2226 Channing Way 1 2226 CHANNING WAY 1 2226 CHANNING WY 2226.0 CHANNING WY 1   Berkeley 94704 37.866039237950055 -122.26416324680494
1806 1806 1806 055 186802100 2832 Channing Way 2832 CHANNING WAY 2832 CHANNING WY 2832.0 CHANNING WY     Berkeley 94704 37.86741650335443 -122.252557551425
1808 1808 1808 055 189101401 2100 Channing Way 404 2100 CHANNING WAY 404 2100 CHANNING WY 2100.0 CHANNING WY 404   Berkeley 94704 37.86559922796649 -122.26698131125856
1883 1883 1883 055 189101401 2100 Channing Way 424 2100 CHANNING WAY 424 2100 CHANNING WY 2100.0 CHANNING WY 424   Berkeley 94704 37.86559922796649 -122.26698131125856
1962 1962 1962 055 189902300 1924 Channing Way D 1924 CHANNING WAY D 1924 CHANNING WY 1924.0 CHANNING WY D   Berkeley 94704 37.86505047644252 -122.27106752021226
2014 2014 2014 055 189500500 2035 Channing Way 205 2035 CHANNING WAY 205 2035 CHANNING WY 2035.0 CHANNING WY 205   Berkeley 94704 37.86597060980446 -122.26833746011376
2058 2058 2058 055 188802700 2236 Channing Way 301 2236 CHANNING WAY 301 2236 CHANNING WY 2236.0 CHANNING WY 301   Berkeley 94704 37.866004184217175 -122.26367316102024
2080 2080 2080 055 187301800 2550 Channing Way 2550 CHANNING WAY 2550 CHANNING WY 2550.0 CHANNING WY     Berkeley 94704 37.86710148388335 -122.25624183705256
2109 2109 2109 055 186901000 2709 Channing Way 1 2709 CHANNING WAY 1 2709 CHANNING WY 2709.0 CHANNING WY 1   Berkeley 94704 37.867770315191066 -122.25375780035756
2178 2178 2178 055 188802700 2236 Channing Way 304 2236 CHANNING WAY 304 2236 CHANNING WY 2236.0 CHANNING WY 304   Berkeley 94704 37.866004184217175 -122.26367316102024
2198 2198 2198 055 186900900 2715 Channing Way 4 2715 CHANNING WAY 4 2715 CHANNING WY 2715.0 CHANNING WY 4   Berkeley 94704 37.86779110127695 -122.25358594186392
2351 2351 2351 055 189501200 2009 Channing Way 2009 CHANNING WAY 2009 CHANNING WY 2009.0 CHANNING WY     Berkeley 94704 37.8657766277913 -122.26959500898504
2383 2383 2383 055 189101800 2118 Channing Way C 2118 CHANNING WAY C 2118 CHANNING WY 2118.0 CHANNING WY C   Berkeley 94704 37.865655298353744 -122.26643917259472
2438 2438 2438 055 189101401 2100 Channing Way 414 2100 CHANNING WAY 414 2100 CHANNING WY 2100.0 CHANNING WY 414   Berkeley 94704 37.86559922796649 -122.26698131125856
2488 2488 2488 055 189500500 2035 Channing Way 106 2035 CHANNING WAY 106 2035 CHANNING WY 2035.0 CHANNING WY 106   Berkeley 94704 37.86597060980446 -122.26833746011376
2522 2522 2522 055 189602501 2020 Channing Way 12B 2020 CHANNING WAY 12B 2020 CHANNING WY 2020.0 CHANNING WY 12B   Berkeley 94704 37.86535476840901 -122.26877334424918
2560 2560 2560 055 189602000 2010 Channing Way 3 2010 CHANNING WAY 3 2010 CHANNING WY 2010.0 CHANNING WY 3   Berkeley 94704 37.86525660225232 -122.2695063093339
2595 2595 2595 055 186301400 2907 Channing Way 2907 CHANNING WAY 2907 CHANNING WY 2907.0 CHANNING WY     Berkeley 94704 37.86817126556251 -122.25015079050566
2637 2637 2637 055 187900601 2431 Channing Way Bid 2431 CHANNING WAY BID 2431 CHANNING WY 2431.0 CHANNING WY BID   Berkeley 94704 37.86728164298409 -122.25940850892184
2701 2701 2701 055 188802600 2214 Channing Way 6 2214 CHANNING WAY 6 2214 CHANNING WY 2214.0 CHANNING WY 6   Berkeley 94704 37.8659176387494 -122.26481696071868
2846 2846 2846 055 189101401 2100 Channing Way 215 2100 CHANNING WAY 215 2100 CHANNING WY 2100.0 CHANNING WY 215   Berkeley 94704 37.86559922796649 -122.26698131125856
2909 2909 2909 055 188302900 2336 Channing Way B 2336 CHANNING WAY B 2336 CHANNING WY 2336.0 CHANNING WY B   Berkeley 94704 37.86628473133556 -122.26156964259474
2911 2911 2911 055 189500800 2023 Channing Way 5 2023 CHANNING WAY 5 2023 CHANNING WY 2023.0 CHANNING WY 5   Berkeley 94704 37.86585889071707 -122.26897587931144
2944 2944 2944 055 187201100 2613 Channing Way 2613 CHANNING WAY 2613 CHANNING WY 2613.0 CHANNING WY     Berkeley 94704 37.86754346203137 -122.25603415823696
3005 3005 3005 055 188700900 2217 Channing Way A 2217 CHANNING WAY A 2217 CHANNING WY 2217.0 CHANNING WY A   Berkeley 94704 37.86640383719888 -122.26479218069156
3036 3036 3036 055 187201200 2601 Channing Way 202 2601 CHANNING WAY 202 2601 CHANNING WY 2601.0 CHANNING WY 202   Berkeley 94704 37.86749918852677 -122.25630156962906
3124 3124 3124 055 188400305 2333 Channing Way 17 2333 CHANNING WAY 17 2333 CHANNING WY 2333.0 CHANNING WY 17   Berkeley 94704 37.866750492735896 -122.262072725205
3232 3232 3232 055 189101401 2100 Channing Way 432 2100 CHANNING WAY 432 2100 CHANNING WY 2100.0 CHANNING WY 432   Berkeley 94704 37.86559922796649 -122.26698131125856
3303 3303 3303 055 188801100 2226 Channing Way 2226 CHANNING WAY 2226 CHANNING WY 2226.0 CHANNING WY     Berkeley 94704 37.866039237950055 -122.26416324680494
3390 3390 3390 055 188700700 2225 Channing Way 101 2225 CHANNING WAY 101 2225 CHANNING WY 2225.0 CHANNING WY 101   Berkeley 94704 37.866454208089955 -122.26440617371566
3398 3398 3398 055 189101401 2100 Channing Way 446 2100 CHANNING WAY 446 2100 CHANNING WY 2100.0 CHANNING WY 446   Berkeley 94704 37.86559922796649 -122.26698131125856
3416 3416 3416 055 189500900 2021 Channing Way 3 2021 CHANNING WAY 3 2021 CHANNING WY 2021.0 CHANNING WY 3   Berkeley 94704 37.8658425896191 -122.26909769805052
3585 3585 3585 055 189602000 2010 Channing Way 6 2010 CHANNING WAY 6 2010 CHANNING WY 2010.0 CHANNING WY 6   Berkeley 94704 37.86525660225232 -122.2695063093339
3595 3595 3595 055 189602501 2020 Channing Way 8B 2020 CHANNING WAY 8B 2020 CHANNING WY 2020.0 CHANNING WY 8B   Berkeley 94704 37.86535476840901 -122.26877334424918
3721 3721 3721 055 189900100 1942 Channing Way 105 1942 CHANNING WAY 105 1942 CHANNING WY 1942.0 CHANNING WY 105   Berkeley 94704 37.86516479094208 -122.27017290688542
3728 3728 3728 055 186901000 2709 Channing Way 2 2709 CHANNING WAY 2 2709 CHANNING WY 2709.0 CHANNING WY 2   Berkeley 94704 37.867770315191066 -122.25375780035756
3876 3876 3876 055 189504000 2029 Channing Way C2 2029 CHANNING WAY C2 2029 CHANNING WY 2029.0 CHANNING WY C2   Berkeley 94704 37.86591312272657 -122.26855942753224
4001 4001 4001 055 187201200 2601 Channing Way 309 2601 CHANNING WAY 309 2601 CHANNING WY 2601.0 CHANNING WY 309   Berkeley 94704 37.86749918852677 -122.25630156962906
4078 4078 4078 055 189602501 2020 Channing Way 6 2020 CHANNING WAY 6 2020 CHANNING WY 2020.0 CHANNING WY 6   Berkeley 94704 37.86535476840901 -122.26877334424918
4101 4101 4101 055 188002103 2430 Channing Way 2430 CHANNING WAY 2430 CHANNING WY 2430.0 CHANNING WY     Berkeley 94704 37.866552687521995 -122.25949622222284
4110 4110 4110 055 186401000 2811 Channing Way 1 2811 CHANNING WAY 1 2811 CHANNING WY 2811.0 CHANNING WY 1   Berkeley 94704 37.8681748652217 -122.25123187971242
4112 4112 4112 055 188700600 2233 Channing Way 7 2233 CHANNING WAY 7 2233 CHANNING WY 2233.0 CHANNING WY 7   Berkeley 94704 37.866481588400646 -122.26419110805348
4304 4304 4304 055 189500500 2035 Channing Way 307 2035 CHANNING WAY 307 2035 CHANNING WY 2035.0 CHANNING WY 307   Berkeley 94704 37.86597060980446 -122.26833746011376
4365 4365 4365 055 187201200 2601 Channing Way 104 2601 CHANNING WAY 104 2601 CHANNING WY 2601.0 CHANNING WY 104   Berkeley 94704 37.86749918852677 -122.25630156962906
4386 4386 4386 055 189500500 2035 Channing Way 108 2035 CHANNING WAY 108 2035 CHANNING WY 2035.0 CHANNING WY 108   Berkeley 94704 37.86597060980446 -122.26833746011376
4574 4574 4574 055 188400305 2333 Channing Way 2333 CHANNING WAY 2333 CHANNING WY 2333.0 CHANNING WY     Berkeley 94704 37.866750492735896 -122.262072725205
4599 4599 4599 055 189602501 2020 Channing Way 4 2020 CHANNING WAY 4 2020 CHANNING WY 2020.0 CHANNING WY 4   Berkeley 94704 37.86535476840901 -122.26877334424918
4602 4602 4602 055 188802600 2214 Channing Way 4 2214 CHANNING WAY 4 2214 CHANNING WY 2214.0 CHANNING WY 4   Berkeley 94704 37.8659176387494 -122.26481696071868
4649 4649 4649 055 186900700 2721 Channing Way 2721 CHANNING WAY 2721 CHANNING WY 2721.0 CHANNING WY     Berkeley 94704 37.86787236417194 -122.2532473722232
4707 4707 4707 055 186900800 2717 Channing Way 3 2717 CHANNING WAY 3 2717 CHANNING WY 2717.0 CHANNING WY 3   Berkeley 94704 37.86785067038956 -122.2534200966928
4765 4765 4765 055 189500500 2035 Channing Way 201 2035 CHANNING WAY 201 2035 CHANNING WY 2035.0 CHANNING WY 201   Berkeley 94704 37.86597060980446 -122.26833746011376
4783 4783 4783 055 188802500 2212 Channing Way 2 2212 CHANNING WAY 2 2212 CHANNING WY 2212.0 CHANNING WY 2   Berkeley 94704 37.86587109278086 -122.2649536196262
5017 5017 5017 055 186400900 2813 Channing Way Apt C 2813 CHANNING WAY 2813 CHANNING WY 2813.0 CHANNING WY C APT Berkeley 94704 37.86829113922427 -122.25113805068102
5132 5132 5132 055 189601900 2002 Channing Way 2002 CHANNING WAY 2002 CHANNING WY 2002.0 CHANNING WY     Berkeley 94704 37.865352849368314 -122.26974343402618
5157 5157 5157 055 187201200 2601 Channing Way 204 2601 CHANNING WAY 204 2601 CHANNING WY 2601.0 CHANNING WY 204   Berkeley 94704 37.86749918852677 -122.25630156962906
5201 5201 5201 055 189902100 1914 Channing Way 5 1914 CHANNING WAY 5 1914 CHANNING WY 1914.0 CHANNING WY 5   Berkeley 94704 37.86500399091602 -122.2714147028999
5299 5299 5299 055 189200800 2125 Channing Way 2125 CHANNING WAY 2125 CHANNING WY 2125.0 CHANNING WY     Berkeley 94704 37.866163027582566 -122.26627284862154
5369 5369 5369 055 189902501 1930 Channing Way 2G 1930 CHANNING WAY 2G 1930 CHANNING WY 1930.0 CHANNING WY 2G   Berkeley 94704 37.86508315699547 -122.27080762143088
5427 5427 5427 055 189101401 2100 Channing Way 448 2100 CHANNING WAY 448 2100 CHANNING WY 2100.0 CHANNING WY 448   Berkeley 94704 37.86559922796649 -122.26698131125856
5563 5563 5563 055 188701100 2211 Channing Way 6 2211 CHANNING WAY 6 2211 CHANNING WY 2211.0 CHANNING WY 6   Berkeley 94704 37.86635858435471 -122.26513497061744
5569 5569 5569 055 188802700 2236 Channing Way 206 2236 CHANNING WAY 206 2236 CHANNING WY 2236.0 CHANNING WY 206   Berkeley 94704 37.866004184217175 -122.26367316102024
5675 5675 5675 055 189902200 1918 Channing Way 1918 CHANNING WAY 1918 CHANNING WY 1918.0 CHANNING WY     Berkeley 94704 37.86502646351019 -122.27124288123716
5742 5742 5742 055 189504000 2029 Channing Way E3 2029 CHANNING WAY E3 2029 CHANNING WY 2029.0 CHANNING WY E3   Berkeley 94704 37.86591312272657 -122.26855942753224
5793 5793 5793 055 187600901 2515 Channing Way 2515 CHANNING WAY 2515 CHANNING WY 2515.0 CHANNING WY     Berkeley 94704 37.8673547908076 -122.25745808498036
5885 5885 5885 055 189902700 1940 Channing Way 3 1940 CHANNING WAY 3 1940 CHANNING WY 1940.0 CHANNING WY 3   Berkeley 94704 37.86514051635884 -122.27035686209268
5966 5966 5966 055 189101401 2100 Channing Way 247 2100 CHANNING WAY 247 2100 CHANNING WY 2100.0 CHANNING WY 247   Berkeley 94704 37.86559922796649 -122.26698131125856
6079 6079 6079 055 186900900 2715 Channing Way 10 2715 CHANNING WAY 10 2715 CHANNING WY 2715.0 CHANNING WY 10   Berkeley 94704 37.86779110127695 -122.25358594186392
6334 6334 6334 055 188302900 2338 Channing Way 2338 CHANNING WAY 2338 CHANNING WY 2338.0 CHANNING WY     Berkeley 94704 37.86628473133556 -122.26156964259474
6340 6340 6340 055 189900100 1942 Channing Way 106 1942 CHANNING WAY 106 1942 CHANNING WY 1942.0 CHANNING WY 106   Berkeley 94704 37.86516479094208 -122.27017290688542
6347 6347 6347 055 188701100 2211 Channing Way 5 2211 CHANNING WAY 5 2211 CHANNING WY 2211.0 CHANNING WY 5   Berkeley 94704 37.86635858435471 -122.26513497061744
6349 6349 6349 055 189900100 1942 Channing Way 201 1942 CHANNING WAY 201 1942 CHANNING WY 1942.0 CHANNING WY 201   Berkeley 94704 37.86516479094208 -122.27017290688542
6498 6498 6498 055 188700600 2233 Channing Way 4 2233 CHANNING WAY 4 2233 CHANNING WY 2233.0 CHANNING WY 4   Berkeley 94704 37.866481588400646 -122.26419110805348
6577 6577 6577 055 188400500 2325 Channing Way 51 2325 CHANNING WAY 51 2325 CHANNING WY 2325.0 CHANNING WY 51   Berkeley 94704 37.866705428743 -122.26241642422596
6629 6629 6629 055 189101401 2100 Channing Way 224 2100 CHANNING WAY 224 2100 CHANNING WY 2100.0 CHANNING WY 224   Berkeley 94704 37.86559922796649 -122.26698131125856
6773 6773 6773 055 189101401 2100 Channing Way 204 2100 CHANNING WAY 204 2100 CHANNING WY 2100.0 CHANNING WY 204   Berkeley 94704 37.86559922796649 -122.26698131125856

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