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

3,861 rows where street_type = "WY" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

street_name 10

zipcode 1

  • 94704 · 3,861 ✖

street_type 1

  • WY · 3,861 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
11 11 11 055 183800201 2430 Dwight Way 102 2430 DWIGHT WAY 102 2430 DWIGHT WY 2430.0 DWIGHT WY 102   Berkeley 94704 37.86431751538991 -122.25900638616976
18 18 18 055 183002100 2222 Dwight Way 3 2222 DWIGHT WAY 3 2222 DWIGHT WY 2222.0 DWIGHT WY 3   Berkeley 94704 37.8641122429479 -122.26413389165808
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
51 51 51 055 189800700 1931 Dwight Way 15 1931 DWIGHT WAY 15 1931 DWIGHT WY 1931.0 DWIGHT WY 15   Berkeley 94704 37.863819744722456 -122.27057484368626
75 75 75 055 183002001 2220 Dwight Way 204 2220 DWIGHT WAY 204 2220 DWIGHT WY 2220.0 DWIGHT WY 204   Berkeley 94704 37.864077629415895 -122.26438686712356
78 78 78 055 189901700 2409 Martin Luther King Jr Way 2409 MARTIN LUTHER KING JR WAY 2409 MARTIN LUTHER KING JR WY 2409.0 MARTIN LUTHER KING JR WY     Berkeley 94704 37.86496930901207 -122.2719699569669
82 82 82 055 188100400 2449 Dwight Way 33 2449 DWIGHT WAY 33 2449 DWIGHT WY 2449.0 DWIGHT WY 33   Berkeley 94704 37.86530920217209 -122.25876941598769
97 97 97 055 189801700 2441 Martin Luther King Jr Way 2441 MARTIN LUTHER KING JR WAY 2441 MARTIN LUTHER KING JR WY 2441.0 MARTIN LUTHER KING JR WY     Berkeley 94704 37.86375817951277 -122.2719193701383
100 100 100 055 182202600 2030 Dwight Way 201 2030 DWIGHT WAY 201 2030 DWIGHT WY 2030.0 DWIGHT WY 201   Berkeley 94704 37.863593502784774 -122.2682385169734
108 108 108 057 202601500 2001 Allston Way 325 2001 ALLSTON WAY 325 2001 ALLSTON WY 2001.0 ALLSTON WY 325   Berkeley 94704 37.86939494524181 -122.26998376660237
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
138 138 138 055 188901400 2201 Dwight Way Apt 203 2201 DWIGHT WAY 2201 DWIGHT WY 2201.0 DWIGHT WY 203 APT Berkeley 94704 37.86476428660056 -122.2650978459417
140 140 140 057 203300101 2000 Kala Bagai Way 109 2000 KALA BAGAI WAY 109 2000 KALA BAGAI WY 2000.0 KALA BAGAI WY 109   Berkeley 94704 37.871863042043564 -122.26809782193531
143 143 143 055 186701100 2709 Dwight Way 18 2709 DWIGHT WAY 18 2709 DWIGHT WY 2709.0 DWIGHT WY 18   Berkeley 94704 37.86604571270155 -122.2533564393768
161 161 161 055 182300100 2180 Dwight Way A 2180 DWIGHT WAY A 2180 DWIGHT WY 2180.0 DWIGHT WY A   Berkeley 94704 37.86400446415546 -122.26537083946498
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
178 178 178 055 187701902 2560 Bancroft Way 166 2560 BANCROFT WAY 166 2560 BANCROFT WY 2560.0 BANCROFT WY 166   Berkeley 94704 37.868744223283414 -122.25767525629354
184 184 184 057 204600100 2114 Berkeley Way 2114 BERKELEY WAY 2114 BERKELEY WY 2114.0 BERKELEY WY     Berkeley 94704 37.87295479646589 -122.26800428665298
186 186 186 057 203201000 2109 Kala Bagai Way 308 2109 KALA BAGAI WAY 308 2109 KALA BAGAI WY 2109.0 KALA BAGAI WY 308   Berkeley 94704 37.871025224528424 -122.26735182948234
220 220 220 055 187701300 2510 Bancroft Way 310 2510 BANCROFT WAY 310 2510 BANCROFT WY 2510.0 BANCROFT WY 310   Berkeley 94704 37.86853942270108 -122.25886489252936
229 229 229 055 189801800 2435 Martin Luther King Jr Way 2435 MARTIN LUTHER KING JR WAY 2435 MARTIN LUTHER KING JR WY 2435.0 MARTIN LUTHER KING JR WY     Berkeley 94704 37.86391046413174 -122.2717896075972
250 250 250 055 187701902 2580 Bancroft Way Apt 506 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 506 APT Berkeley 94704 37.86863805606804 -122.25762325910996
252 252 252 055 187001501 2736 Bancroft Way 2736 BANCROFT WAY 2736 BANCROFT WY 2736.0 BANCROFT WY     Berkeley 94704 37.869221065802336 -122.25295637646164
255 255 255 055 187701902 2580 Bancroft Way Apt 408 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 408 APT Berkeley 94704 37.86862112869765 -122.25756914010566
299 299 299 055 187701300 2510 Bancroft Way 204 2510 BANCROFT WAY 204 2510 BANCROFT WY 2510.0 BANCROFT WY 204   Berkeley 94704 37.86853942270108 -122.25886489252936
312 312 312 057 206000100 1942 Martin Luther King Jr Way 1942 MARTIN LUTHER KING JR WAY 1942 MARTIN LUTHER KING JR WY 1942.0 MARTIN LUTHER KING JR WY     Berkeley 94704 37.87173286644798 -122.27345796503108
345 345 345 055 188200500 2335 Dwight Way 305 2335 DWIGHT WAY 305 2335 DWIGHT WY 2335.0 DWIGHT WY 305   Berkeley 94704 37.86499854013364 -122.2615156682192
347 347 347 055 183800201 2430 Dwight Way 104 2430 DWIGHT WAY 104 2430 DWIGHT WY 2430.0 DWIGHT WY 104   Berkeley 94704 37.86431751538991 -122.25900638616976
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
368 368 368 057 205602300 1945 Berkeley Way 328 1945 BERKELEY WAY 328 1945 BERKELEY WY 1945.0 BERKELEY WY 328   Berkeley 94704 37.8728988635272 -122.27127748703688
369 369 369 055 188100400 2449 Dwight Way 22 2449 DWIGHT WAY 22 2449 DWIGHT WY 2449.0 DWIGHT WY 22   Berkeley 94704 37.86530920217209 -122.25876941598769
402 402 402 057 203201000 2109 Kala Bagai Way 408 2109 KALA BAGAI WAY 408 2109 KALA BAGAI WY 2109.0 KALA BAGAI WY 408   Berkeley 94704 37.871025224528424 -122.26735182948234
423 423 423 055 187701902 2580 Bancroft Way Apt 606 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 606 APT Berkeley 94704 37.86866084808889 -122.25762981501492
430 430 430 055 188200500 2335 Dwight Way 109 2335 DWIGHT WAY 109 2335 DWIGHT WY 2335.0 DWIGHT WY 109   Berkeley 94704 37.86499854013364 -122.2615156682192
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
442 442 442 055 183002100 2224 Dwight Way 2224 DWIGHT WAY 2224 DWIGHT WY 2224.0 DWIGHT WY     Berkeley 94704 37.8641122429479 -122.26413389165808
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
451 451 451 057 203100300 2161 Allston Way 204 2161 ALLSTON WAY 204 2161 ALLSTON WY 2161.0 ALLSTON WY 204   Berkeley 94704 37.86984650070638 -122.26642724386603
459 459 459 057 202401400 2031 Martin Luther King Jr Way 7 2031 MARTIN LUTHER KING JR WAY 7 2031 MARTIN LUTHER KING JR WY 2031.0 MARTIN LUTHER KING JR WY 7   Berkeley 94704 37.87126864555511 -122.27267136872726
511 511 511 055 189300701 2124 Bancroft Way Apt 309 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 309 APT Berkeley 94704 37.86725807967805 -122.26648072776143
522 522 522 055 188101701 2415 Dwight Way 13 2415 DWIGHT WAY 13 2415 DWIGHT WY 2415.0 DWIGHT WY 13   Berkeley 94704 37.8651107952487 -122.25999090917844
523 523 523 057 206000100 1920 Martin Luther King Jr Way 1920 MARTIN LUTHER KING JR WAY 1920 MARTIN LUTHER KING JR WY 1920.0 MARTIN LUTHER KING JR WY     Berkeley 94704 37.8716862645869 -122.27345313299318
530 530 530 054 181200100 2602 Martin Luther King Jr Way 1 2602 MARTIN LUTHER KING JR WAY 1 2602 MARTIN LUTHER KING JR WY 2602.0 MARTIN LUTHER KING JR WY 1   Berkeley 94704 37.86132469982919 -122.2721790641038
534 534 534 057 205102700 2005 Berkeley Way D 2005 BERKELEY WAY D 2005 BERKELEY WY 2005.0 BERKELEY WY D   Berkeley 94704 37.87301017200475 -122.2704268749893
537 537 537 057 205900200 1910 Berkeley Way 1910 BERKELEY WAY 1910 BERKELEY WY 1910.0 BERKELEY WY     Berkeley 94704 37.872302906128674 -122.27245870516016
558 558 558 057 202601500 2001 Allston Way Apt 328 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 328 APT Berkeley 94704 37.86952136936425 -122.26994508963782
565 565 565 057 206000100 1888 Berkeley Way Apt 201 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 201 APT Berkeley 94704 37.87222175590544 -122.27384508142632
601 601 601 057 203401000 2015 Kala Bagai Way 2015 KALA BAGAI WAY 2015 KALA BAGAI WY 2015.0 KALA BAGAI WY     Berkeley 94704 37.87197931944443 -122.26748894473404
607 607 607 055 189800801 1927 Dwight Way 203 1927 DWIGHT WAY 203 1927 DWIGHT WY 1927.0 DWIGHT WY 203   Berkeley 94704 37.86378033051236 -122.27086835832384
658 658 658 057 203000200 2116 Allston Way 411 2116 ALLSTON WAY 411 2116 ALLSTON WY 2116.0 ALLSTON WY 411   Berkeley 94704 37.86925187591561 -122.2670315594223
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
665 665 665 055 189800700 1931 Dwight Way 17 1931 DWIGHT WAY 17 1931 DWIGHT WY 1931.0 DWIGHT WY 17   Berkeley 94704 37.863819744722456 -122.27057484368626
677 677 677 057 205602300 1933 Berkeley Way 1933 BERKELEY WAY 1933 BERKELEY WY 1933.0 BERKELEY WY     Berkeley 94704 37.8728988635272 -122.27127748703688
723 723 723 055 184600400 2646 Dwight Way 8 2646 DWIGHT WAY 8 2646 DWIGHT WY 2646.0 DWIGHT WY 8   Berkeley 94704 37.86548547793786 -122.25426501611643
726 726 726 055 188200500 2335 Dwight Way 210 2335 DWIGHT WAY 210 2335 DWIGHT WY 2335.0 DWIGHT WY 210   Berkeley 94704 37.86499854013364 -122.2615156682192
727 727 727 057 202601500 2001 Allston Way Apt 317 2001 ALLSTON WAY 2001 ALLSTON WY 2001.0 ALLSTON WY 317 APT Berkeley 94704 37.86941884754291 -122.27024333210876
740 740 740 055 189401401 2020 Bancroft Way 402 2020 BANCROFT WAY 402 2020 BANCROFT WY 2020.0 BANCROFT WY 402   Berkeley 94704 37.86695279564912 -122.26925847223184
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
754 754 754 055 185000100 2726 Dwight Way 5 2726 DWIGHT WAY 5 2726 DWIGHT WY 2726.0 DWIGHT WY 5   Berkeley 94704 37.865585888336845 -122.252507382313
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
793 793 793 057 203000200 2116 Allston Way 515 2116 ALLSTON WAY 515 2116 ALLSTON WY 2116.0 ALLSTON WY 515   Berkeley 94704 37.86925187591561 -122.2670315594223
809 809 809 055 187801900 2452 Bancroft Way 5 2452 BANCROFT WAY 5 2452 BANCROFT WY 2452.0 BANCROFT WY 5   Berkeley 94704 37.86830536622177 -122.26018143107042
815 815 815 057 205602300 1941 Berkeley Way 1941 BERKELEY WAY 1941 BERKELEY WY 1941.0 BERKELEY WY     Berkeley 94704 37.8728988635272 -122.27127748703688
817 817 817 057 205900200 1912 Berkeley Way 1912 BERKELEY WAY 1912 BERKELEY WY 1912.0 BERKELEY WY     Berkeley 94704 37.872302906128674 -122.27245870516016
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
905 905 905 055 188101701 2407 Dwight Way 2407 DWIGHT WAY 2407 DWIGHT WY 2407.0 DWIGHT WY     Berkeley 94704 37.86506685572585 -122.26031100227038
909 909 909 055 188901400 2201 Dwight Way 2201 DWIGHT WAY 2201 DWIGHT WY 2201.0 DWIGHT WY     Berkeley 94704 37.864613183833086 -122.26496179429532
935 935 935 055 189801400 1909 Dwight Way 1 1909 DWIGHT WAY 1 1909 DWIGHT WY 1909.0 DWIGHT WY 1   Berkeley 94704 37.86368589121052 -122.27161276884364
953 953 953 057 203100300 2161 Allston Way 304 2161 ALLSTON WAY 304 2161 ALLSTON WY 2161.0 ALLSTON WY 304   Berkeley 94704 37.86984650070638 -122.26642724386603
954 954 954 057 203000200 2116 Allston Way 509 2116 ALLSTON WAY 509 2116 ALLSTON WY 2116.0 ALLSTON WY 509   Berkeley 94704 37.86925187591561 -122.2670315594223
970 970 970 055 183802000 2434 Dwight Way Indus 2434 DWIGHT WAY INDUS 2434 DWIGHT WY 2434.0 DWIGHT WY INDUS   Berkeley 94704 37.8648204462712 -122.25904366984732
973 973 973 057 202801402 2005 Bancroft Way 316 2005 BANCROFT WAY 316 2005 BANCROFT WY 2005.0 BANCROFT WY 316   Berkeley 94704 37.8678249152641 -122.26942837149984
980 980 980 055 188901400 2201 Dwight Way Apt 105 2201 DWIGHT WAY 2201 DWIGHT WY 2201.0 DWIGHT WY 105 APT Berkeley 94704 37.86473012654454 -122.2651586645814
1014 1014 1014 057 205102700 2005 Berkeley Way A 2005 BERKELEY WAY A 2005 BERKELEY WY 2005.0 BERKELEY WY A   Berkeley 94704 37.87301017200475 -122.2704268749893
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
1059 1059 1059 055 185303202 2939 Dwight Way C10 2939 DWIGHT WAY C10 2939 DWIGHT WY 2939.0 DWIGHT WY C10   Berkeley 94704 37.86744034601878 -122.24681798690268
1066 1066 1066 055 183801600 2420 Dwight Way 5 2420 DWIGHT WAY 5 2420 DWIGHT WY 2420.0 DWIGHT WY 5   Berkeley 94704 37.86469690685361 -122.25963412978862
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
1163 1163 1163 055 187801700 2428 Bancroft Way 1 2428 BANCROFT WAY 1 2428 BANCROFT WY 2428.0 BANCROFT WY 1   Berkeley 94704 37.868237121001386 -122.26069700116142
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
1167 1167 1167 055 187701902 2580 Bancroft Way Apt 404 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 404 APT Berkeley 94704 37.86860827609093 -122.25766552214913
1185 1185 1185 057 203201000 2109 Kala Bagai Way 504 2109 KALA BAGAI WAY 504 2109 KALA BAGAI WY 2109.0 KALA BAGAI WY 504   Berkeley 94704 37.871025224528424 -122.26735182948234
1221 1221 1221 055 190201201 2430 Martin Luther King Jr Way 8 2430 MARTIN LUTHER KING JR WAY 8 2430 MARTIN LUTHER KING JR WY 2430.0 MARTIN LUTHER KING JR WY 8   Berkeley 94704 37.86400513788864 -122.27255758362182
1225 1225 1225 055 188900500 2245 Dwight Way B 2245 DWIGHT WAY B 2245 DWIGHT WY 2245.0 DWIGHT WY B   Berkeley 94704 37.86472329424778 -122.26322507506828
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
1258 1258 1258 055 185303700 2987 Dwight Way 2987 DWIGHT WAY 2987 DWIGHT WY 2987.0 DWIGHT WY     Berkeley 94704 37.86655967141118 -122.24678532595554
1280 1280 1280 055 187802100 2468 Bancroft Way 10 2468 BANCROFT WAY 10 2468 BANCROFT WY 2468.0 BANCROFT WY 10   Berkeley 94704 37.86835075828235 -122.2598204269038
1283 1283 1283 057 205602300 1945 Berkeley Way 318 1945 BERKELEY WAY 318 1945 BERKELEY WY 1945.0 BERKELEY WY 318   Berkeley 94704 37.8728988635272 -122.27127748703688
1301 1301 1301 055 182201800 2000 Dwight Way B 2000 DWIGHT WAY B 2000 DWIGHT WY 2000.0 DWIGHT WY B   Berkeley 94704 37.863478112831416 -122.26958527663729
1332 1332 1332 057 205103000 2017 Berkeley Way 9 2017 BERKELEY WAY 9 2017 BERKELEY WY 2017.0 BERKELEY WY 9   Berkeley 94704 37.87306930079794 -122.26996137160236
1335 1335 1335 057 202801402 2005 Bancroft Way 341 2005 BANCROFT WAY 341 2005 BANCROFT WY 2005.0 BANCROFT WY 341   Berkeley 94704 37.8678249152641 -122.26942837149984
1369 1369 1369 055 187701300 2510 Bancroft Way 320 2510 BANCROFT WAY 320 2510 BANCROFT WY 2510.0 BANCROFT WY 320   Berkeley 94704 37.86853942270108 -122.25886489252936
1371 1371 1371 055 189300701 2124 Bancroft Way Apt 504 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 504 APT Berkeley 94704 37.867435596066485 -122.26656526731452
1399 1399 1399 055 189401401 2020 Bancroft Way 313 2020 BANCROFT WAY 313 2020 BANCROFT WY 2020.0 BANCROFT WY 313   Berkeley 94704 37.86695279564912 -122.26925847223184

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