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

6,475 rows where street_type = "WY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

These facets timed out: street_name

zipcode 8

street_type 1

  • WY · 6,475 ✖
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
41 41 41 057 207500500 1435 Berkeley Way 1435 BERKELEY WAY 1435 BERKELEY WY 1435.0 BERKELEY WY     Berkeley 94702 37.87129018445151 -122.2828227940702
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
53 53 53 057 206001200 1810 Berkeley Way 4 1810 BERKELEY WAY 4 1810 BERKELEY WY 1810.0 BERKELEY WY 4   Berkeley 94703 37.87197267857206 -122.27469630343002
61 61 61 057 207201501 1440 Berkeley Way 1440 BERKELEY WAY 1440 BERKELEY WY 1440.0 BERKELEY WY     Berkeley 94702 37.87090866835336 -122.28249569501736
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
87 87 87 056 192002100 1315 Dwight Way 1315 DWIGHT WAY 1315 DWIGHT WY 1315.0 DWIGHT WY     Berkeley 94702 37.862281240176614 -122.28538183110828
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
123 123 123 052 155101302 3132 Martin Luther King Jr Way 3132 MARTIN LUTHER KING JR WAY 3132 MARTIN LUTHER KING JR WY 3132.0 MARTIN LUTHER KING JR WY     Berkeley 94703 37.85115003457128 -122.27106610536568
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
179 179 179 056 191905501 1451 Dwight Way 1451 DWIGHT WAY 1451 DWIGHT WY 1451.0 DWIGHT WY     Berkeley 94702 37.86236048506624 -122.28153078312964
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
192 192 192 059 226902000 1457 Martin Luther King Jr Way 1457 MARTIN LUTHER KING JR WAY 1457 MARTIN LUTHER KING JR WY 1457.0 MARTIN LUTHER KING JR WY     Berkeley 94709 37.87988446029134 -122.2736587627516
210 210 210 057 201800300 1872 Allston Way 1872 ALLSTON WAY 1872 ALLSTON WY 1872.0 ALLSTON WY     Berkeley 94703 37.86850615154113 -122.27318115276952
216 216 216 053 160001600 2944 Martin Luther King Jr Way 7 2944 MARTIN LUTHER KING JR WAY 7 2944 MARTIN LUTHER KING JR WY 2944.0 MARTIN LUTHER KING JR WY 7   Berkeley 94703 37.85455121534551 -122.27146467348422
218 218 218 054 177300101 800 Cutter Way 800 CUTTER WAY 800 CUTTER WY 800.0 CUTTER WY     Berkeley 94710 37.85937859739693 -122.29605937635692
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
224 224 224 057 208101400 1271 Berkeley Way 1271 BERKELEY WAY 1271 BERKELEY WY 1271.0 BERKELEY WY     Berkeley 94702 37.870714417816 -122.28731088862074
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
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
286 286 286 059 226902400 1435 Martin Luther King Jr Way 5 1435 MARTIN LUTHER KING JR WAY 5 1435 MARTIN LUTHER KING JR WY 1435.0 MARTIN LUTHER KING JR WY 5   Berkeley 94709 37.88022101527787 -122.27361424404272
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
336 336 336 058 216600600 1600 Martin Luther King Jr Way 1600 MARTIN LUTHER KING JR WAY 1600 MARTIN LUTHER KING JR WY 1600.0 MARTIN LUTHER KING JR WY     Berkeley 94709 37.87766834587762 -122.27398004161972
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
401 401 401 053 160001000 2928 Martin Luther King Jr Way 2928 MARTIN LUTHER KING JR WAY 2928 MARTIN LUTHER KING JR WY 2928.0 MARTIN LUTHER KING JR WY     Berkeley 94703 37.855170776390864 -122.2715315404807
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
406 406 406 056 192002100 1321 Dwight Way K 1321 DWIGHT WAY K 1321 DWIGHT WY 1321.0 DWIGHT WY K   Berkeley 94702 37.862281240176614 -122.28538183110828
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
436 436 436 056 196300300 808 Allston Way 808 ALLSTON WAY 808 ALLSTON WY 808.0 ALLSTON WY     Berkeley 94710 37.86492207808195 -122.297379513549
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
446 446 446 057 206300601 1922 Martin Luther King Jr Way 1922 MARTIN LUTHER KING JR WAY 1922 MARTIN LUTHER KING JR WY 1922.0 MARTIN LUTHER KING JR WY     Berkeley 94703 37.87272439670541 -122.27340698204544
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
465 465 465 057 206400200 1806 Martin Luther King Jr Way 2 1806 MARTIN LUTHER KING JR WAY 2 1806 MARTIN LUTHER KING JR WY 1806.0 MARTIN LUTHER KING JR WY 2   Berkeley 94709 37.87389795409124 -122.27355020584108
478 478 478 056 193102400 1225 Dwight Way 1225 DWIGHT WAY 1225 DWIGHT WY 1225.0 DWIGHT WY     Berkeley 94702 37.861691947917585 -122.2867133095308
479 479 479 056 198700400 1210 Allston Way 1210 ALLSTON WAY 1210 ALLSTON WY 1210.0 ALLSTON WY     Berkeley 94702 37.86654206559832 -122.2883503705585
496 496 496 056 199804803 1408 Allston Way 5 1408 ALLSTON WAY 5 1408 ALLSTON WY 1408.0 ALLSTON WY 5   Berkeley 94702 37.86662083005484 -122.28326691485844
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
524 524 524 060 244901700 1277 Martin Luther King Jr Way 1277 MARTIN LUTHER KING JR WAY 1277 MARTIN LUTHER KING JR WY 1277.0 MARTIN LUTHER KING JR WY     Berkeley 94709 37.883498326450656 -122.27415683725413
526 526 526 057 206001600 1830 Berkeley Way 1830 BERKELEY WAY 1830 BERKELEY WY 1830.0 BERKELEY WY     Berkeley 94703 37.87206681651637 -122.27399328368529
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
579 579 579 060 247601400 3070 Buena Vista Way 3070 BUENA VISTA WAY 3070 BUENA VISTA WY 3070.0 BUENA VISTA WY     Berkeley 94708 37.88213278963948 -122.25541468361033
584 584 584 054 180702500 1712 Dwight Way 4 1712 DWIGHT WAY 4 1712 DWIGHT WY 1712.0 DWIGHT WY 4   Berkeley 94703 37.86260452832349 -122.27587008799432
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
619 619 619 057 201801700 1845 Bancroft Way 3 1845 BANCROFT WAY 3 1845 BANCROFT WY 1845.0 BANCROFT WY 3   Berkeley 94703 37.867076973786745 -122.2731116384379
623 623 623 056 199802600 1429 Bancroft Way 1429 BANCROFT WAY 1429 BANCROFT WY 1429.0 BANCROFT WY     Berkeley 94702 37.866010366083096 -122.28242825040414
628 628 628 056 198401900 1129 Bancroft Way B 1129 BANCROFT WAY B 1129 BANCROFT WY 1129.0 BANCROFT WY B   Berkeley 94702 37.86505204231807 -122.28914160755906
629 629 629 057 207001700 1620 Berkeley Way 1620 BERKELEY WAY 1620 BERKELEY WY 1620.0 BERKELEY WY     Berkeley 94703 37.87142891070623 -122.27914622856416
633 633 633 059 228601400 1544 Juanita Way 1544 JUANITA WAY 1544 JUANITA WY 1544.0 JUANITA WY     Berkeley 94702 37.87679890606605 -122.2867734759936
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
664 664 664 060 244803300 1309 Martin Luther King Jr Way 1309 MARTIN LUTHER KING JR WAY 1309 MARTIN LUTHER KING JR WY 1309.0 MARTIN LUTHER KING JR WY     Berkeley 94709 37.88299399373123 -122.27399472188807
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
680 680 680 056 195518201 713 Essex Way Apt 102 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 102 APT Berkeley 94710 37.8672219812204 -122.30017687632689
710 710 710 056 192602301 1114 Bancroft Way 1114 BANCROFT WAY 1114 BANCROFT WY 1114.0 BANCROFT WY     Berkeley 94702 37.86442239881587 -122.28982787192712
711 711 711 056 191500600 1466 Bancroft Way 1466 BANCROFT WAY 1466 BANCROFT WY 1466.0 BANCROFT WY     Berkeley 94702 37.865629272973614 -122.2817702802726
713 713 713 056 197101600 941 Allston Way 941 ALLSTON WAY 941 ALLSTON WY 941.0 ALLSTON WY     Berkeley 94710 37.866056300656474 -122.29400711130994
722 722 722 056 200800500 1642 Allston Way A 1642 ALLSTON WAY A 1642 ALLSTON WY 1642.0 ALLSTON WY A   Berkeley 94703 37.86792976745935 -122.2775637590546
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
762 762 762 054 178302800 1322 Dwight Way 3 1322 DWIGHT WAY 3 1322 DWIGHT WY 1322.0 DWIGHT WY 3   Berkeley 94702 37.861514893577535 -122.28429506005732
774 774 774 056 192002100 1315 Dwight Way G 1315 DWIGHT WAY G 1315 DWIGHT WY 1315.0 DWIGHT WY G   Berkeley 94702 37.862281240176614 -122.28538183110828
782 782 782 056 197501800 1019 Bancroft Way 1019 BANCROFT WAY 1019 BANCROFT WY 1019.0 BANCROFT WY     Berkeley 94710 37.86452672112502 -122.29225501472192

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