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

13,577 rows where zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

street_name >30

street_type 8

zipcode 1

  • 94704 · 13,577 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
4 4 4 055 182001500 2605 Milvia St 2605 MILVIA ST 2605 MILVIA ST 2605.0 MILVIA ST     Berkeley 94704 37.86164004895787 -122.26941061539996
9 9 9 055 183202000 2529 Ellsworth St 3 2529 ELLSWORTH ST 3 2529 ELLSWORTH ST 2529.0 ELLSWORTH ST 3   Berkeley 94704 37.863535204658334 -122.26252992007392
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
29 29 29 055 184600101 2501 Benvenue Ave 30 2501 BENVENUE AVE 30 2501 BENVENUE AV 2501.0 BENVENUE AV 30   Berkeley 94704 37.8653038478608 -122.25491987717878
42 42 42 055 181603000 1936 Blake St 18 1936 BLAKE ST 18 1936 BLAKE ST 1936.0 BLAKE ST 18   Berkeley 94704 37.86238468255223 -122.27022266726398
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
54 54 54 055 188500201 2315 Durant Ave 307 2315 DURANT AVE 307 2315 DURANT AV 2315.0 DURANT AV 307   Berkeley 94704 37.86767914241777 -122.262294565961
60 60 60 057 202200800 1907 Center St 1 1907 CENTER ST 1 1907 CENTER ST 1907.0 CENTER ST 1   Berkeley 94704 37.87002797917772 -122.2722691830931
70 70 70 055 182100700 2037 Parker St Apt 306 2037 PARKER ST 2037 PARKER ST 2037.0 PARKER ST 306 APT Berkeley 94704 37.862287718095075 -122.26793969598742
74 74 74 057 202301701 2002 Addison St 2 2002 ADDISON ST 2 2002 ADDISON ST 2002.0 ADDISON ST 2   Berkeley 94704 37.8707665181595 -122.27030273500355
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
81 81 81 057 203201200 2112 Addison St 310 2112 ADDISON ST 310 2112 ADDISON ST 2112.0 ADDISON ST 310   Berkeley 94704 37.87110287937675 -122.26706095589168
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
90 90 90 055 184600500 2504 College Ave 6 2504 COLLEGE AVE 6 2504 COLLEGE AV 2504.0 COLLEGE AV 6   Berkeley 94704 37.865504616537685 -122.25408878642062
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
113 113 113 055 188201700 2322 Haste St 17 2322 HASTE ST 17 2322 HASTE ST 2322.0 HASTE ST 17   Berkeley 94704 37.86531247645735 -122.2619736032999
115 115 115 055 185002700 2519 Etna St U2 2519 ETNA ST U2 2519 ETNA ST 2519.0 ETNA ST U2   Berkeley 94704 37.8651061486869 -122.25235137369422
122 122 122 057 204600804 2131 University Ave Apt 411 2131 UNIVERSITY AVE 2131 UNIVERSITY AV 2131.0 UNIVERSITY AV 411 APT Berkeley 94704 37.87243684468192 -122.26745464795482
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
131 131 131 055 187800501 2433 Durant Ave 2433 DURANT AVE 2433 DURANT AV 2433.0 DURANT AV     Berkeley 94704 37.867988850688995 -122.25984129656447
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
139 139 139 055 182000101 2038 Parker St Apt 422 2038 PARKER ST 2038 PARKER ST 2038.0 PARKER ST 422 APT Berkeley 94704 37.861935569279304 -122.2676609155171
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
142 142 142 055 186800300 2747 Haste St 18 2747 HASTE ST 18 2747 HASTE ST 2747.0 HASTE ST 18   Berkeley 94704 37.866963294828146 -122.25214493994363
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
147 147 147 055 189601500 2419 Milvia St 2419 MILVIA ST 2419 MILVIA ST 2419.0 MILVIA ST     Berkeley 94704 37.864795201409166 -122.26971713045636
158 158 158 055 184603101 2515 Benvenue Ave 109 2515 BENVENUE AVE 109 2515 BENVENUE AV 2515.0 BENVENUE AV 109   Berkeley 94704 37.864984052227335 -122.25476506960754
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
165 165 165 055 183900500 2512 Regent St 3 2512 REGENT ST 3 2512 REGENT ST 2512.0 REGENT ST 3   Berkeley 94704 37.86461955304099 -122.2580904881606
169 169 169 055 181703000 1928 Parker St 1928 PARKER ST 1928 PARKER ST 1928.0 PARKER ST     Berkeley 94704 37.86146181010024 -122.2702889611353
174 174 174 055 182000101 2038 Parker St Apt 219 2038 PARKER ST 2038 PARKER ST 2038.0 PARKER ST 219 APT Berkeley 94704 37.861754497115406 -122.26753692105844
176 176 176 057 202302600 2055 Center St Apt 904 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 904 APT Berkeley 94704 37.87050590474006 -122.26952670648076
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
180 180 180 055 184005500 2615 Telegraph Ave 402 2615 TELEGRAPH AVE 402 2615 TELEGRAPH AV 2615.0 TELEGRAPH AV 402   Berkeley 94704 37.86280611710247 -122.25839680199437
181 181 181 057 203100200 2150 Oxford St 6 2150 OXFORD ST 6 2150 OXFORD ST 2150.0 OXFORD ST 6   Berkeley 94704 37.86988481392904 -122.26611805362673
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
189 189 189 055 188101701 2424 Haste St D40 2424 HASTE ST D40 2424 HASTE ST 2424.0 HASTE ST D40   Berkeley 94704 37.865632043728894 -122.26005680060452
208 208 208 055 187601700 2526 Durant Ave Apt 506 2526 DURANT AVE 2526 DURANT AV 2526.0 DURANT AV 506 APT Berkeley 94704 37.867696085606035 -122.25775429546214
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
226 226 226 055 184201401 2530 Hillegass Ave 402 2530 HILLEGASS AVE 402 2530 HILLEGASS AV 2530.0 HILLEGASS AV 402   Berkeley 94704 37.864177050283885 -122.25677292913336
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
235 235 235 055 188303300 2406 Dana St C 2406 DANA ST C 2406 DANA ST 2406.0 DANA ST C   Berkeley 94704 37.86619299435097 -122.2612807165516
236 236 236 055 184200801 2520 Hillegass Ave 301 2520 HILLEGASS AVE 301 2520 HILLEGASS AV 2520.0 HILLEGASS AV 301   Berkeley 94704 37.86460771529214 -122.25680997924896
238 238 238 057 205300500 2067 University Ave Apt 502 2067 UNIVERSITY AVE 2067 UNIVERSITY AV 2067.0 UNIVERSITY AV 502 APT Berkeley 94704 37.87244696015928 -122.26915361817694
240 240 240 057 202302600 2055 Center St Apt 312 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 312 APT Berkeley 94704 37.87036130159193 -122.26926794047496
241 241 241 055 182402000 2126 Blake St 2126 BLAKE ST 2126 BLAKE ST 2126.0 BLAKE ST     Berkeley 94704 37.8629711473545 -122.26590409918056
245 245 245 055 183000100 2233 Blake St 2233 BLAKE ST 2233 BLAKE ST 2233.0 BLAKE ST     Berkeley 94704 37.86430650521714 -122.26313026777152
247 247 247 055 187100600 2637 Durant Ave 202 2637 DURANT AVE 202 2637 DURANT AV 2637.0 DURANT AV 202   Berkeley 94704 37.86857088977123 -122.25531596145552
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
254 254 254 057 203001000 2233 Shattuck Ave 2233 SHATTUCK AVE 2233 SHATTUCK AV 2233.0 SHATTUCK AV     Berkeley 94704 37.868718708162135 -122.26755177559996
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
284 284 284 057 203500302 2175 Kittredge St Apt 411 2175 KITTREDGE ST 2175 KITTREDGE ST 2175.0 KITTREDGE ST 411 APT Berkeley 94704 37.86895617786256 -122.26662864705108
292 292 292 055 188201700 2322 Haste St 12 2322 HASTE ST 12 2322 HASTE ST 2322.0 HASTE ST 12   Berkeley 94704 37.86531247645735 -122.2619736032999
296 296 296 057 202201401 1912 Addison St 11 1912 ADDISON ST 11 1912 ADDISON ST 1912.0 ADDISON ST 11   Berkeley 94704 37.87040566556387 -122.27214484188472
297 297 297 055 184502600 2619 Benvenue Ave G 2619 BENVENUE AVE G 2619 BENVENUE AV 2619.0 BENVENUE AV G   Berkeley 94704 37.86285708476558 -122.25455124092552
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
306 306 306 055 183201700 2537 Ellsworth St D 2537 ELLSWORTH ST D 2537 ELLSWORTH ST 2537.0 ELLSWORTH ST D   Berkeley 94704 37.86318108951605 -122.2623906838998
309 309 309 055 184200600 2500 Hillegass Ave 16 2500 HILLEGASS AVE 16 2500 HILLEGASS AV 2500.0 HILLEGASS AV 16   Berkeley 94704 37.865131627472415 -122.25668814434025
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
315 315 315 055 182000101 2038 Parker St Apt 321 2038 PARKER ST 2038 PARKER ST 2038.0 PARKER ST 321 APT Berkeley 94704 37.86188414424562 -122.2676272215074
319 319 319 055 183300304 2398 Parker St 17 2398 PARKER ST 17 2398 PARKER ST 2398.0 PARKER ST 17   Berkeley 94704 37.86275590045203 -122.26051400265996
329 329 329 055 184302200 2527 Hillegass Ave 2527 HILLEGASS AVE 2527 HILLEGASS AV 2527.0 HILLEGASS AV     Berkeley 94704 37.86432729582606 -122.25616754727686
330 330 330 057 203100200 2150 Oxford St 30 2150 OXFORD ST 30 2150 OXFORD ST 2150.0 OXFORD ST 30   Berkeley 94704 37.86988481392904 -122.26611805362673
332 332 332 055 184401200 2632 Benvenue Ave 2632 BENVENUE AVE 2632 BENVENUE AV 2632.0 BENVENUE AV     Berkeley 94704 37.862319033936544 -122.2552772036426
340 340 340 057 203101100 2130 Center St Unit 301 2130 CENTER ST 2130 CENTER ST 2130.0 CENTER ST 301 UNIT Berkeley 94704 37.87025257177367 -122.26709881718594
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
348 348 348 055 185100700 2522 Warring St 2522 WARRING ST 2522 WARRING ST 2522.0 WARRING ST     Berkeley 94704 37.86502617487274 -122.25072532780857
352 352 352 055 183803100 2501 Dana St 5 2501 DANA ST 5 2501 DANA ST 2501.0 DANA ST 5   Berkeley 94704 37.864649053792235 -122.26039262679036
354 354 354 055 183403502 2338 Carleton St 2338 CARLETON ST 2338 CARLETON ST 2338.0 CARLETON ST     Berkeley 94704 37.86189699447908 -122.26061487717816
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
362 362 362 055 182501502 2113 Carleton St 2113 CARLETON ST 2113 CARLETON ST 2113.0 CARLETON ST     Berkeley 94704 37.86160630730952 -122.26645455175236
367 367 367 055 183200702 2336 Blake St 1 2336 BLAKE ST 1 2336 BLAKE ST 2336.0 BLAKE ST 1   Berkeley 94704 37.86359310705293 -122.26110028274024
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
371 371 371 057 203001000 2231 Shattuck Ave Apt 221 2231 SHATTUCK AVE 2231 SHATTUCK AV 2231.0 SHATTUCK AV 221 APT Berkeley 94704 37.868790495833885 -122.26741609226282
375 375 375 055 186800701 2725 Haste St 202 2725 HASTE ST 202 2725 HASTE ST 2725.0 HASTE ST 202   Berkeley 94704 37.86693449991304 -122.25309103302442
377 377 377 055 189600701 2033 Haste St 206 2033 HASTE ST 206 2033 HASTE ST 2033.0 HASTE ST 206   Berkeley 94704 37.86499612465541 -122.26866857194096
379 379 379 055 184300900 2540 Benvenue Ave 102 2540 BENVENUE AVE 102 2540 BENVENUE AV 2540.0 BENVENUE AV 102   Berkeley 94704 37.86396950519573 -122.25544107431674
383 383 383 055 182401900 2124 Blake St 9 2124 BLAKE ST 9 2124 BLAKE ST 2124.0 BLAKE ST 9   Berkeley 94704 37.86294995424496 -122.26606816658575
384 384 384 055 189501801 2020 Durant Ave 105 2020 DURANT AVE 105 2020 DURANT AV 2020.0 DURANT AV 105   Berkeley 94704 37.86618045406547 -122.2692870144034
391 391 391 055 183300303 2390 Parker St 3 2390 PARKER ST 3 2390 PARKER ST 2390.0 PARKER ST 3   Berkeley 94704 37.86272896768392 -122.26072729504776
395 395 395 057 202801402 2020 Kittredge St 404 2020 KITTREDGE ST 404 2020 KITTREDGE ST 2020.0 KITTREDGE ST 404   Berkeley 94704 37.8678249152641 -122.26942837149984
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
412 412 412 055 186800402 2731 Haste St 10 2731 HASTE ST 10 2731 HASTE ST 2731.0 HASTE ST 10   Berkeley 94704 37.86699844880608 -122.25261262084682
418 418 418 055 182100700 2037 Parker St Apt 53 2037 PARKER ST 2037 PARKER ST 2037.0 PARKER ST 53 APT Berkeley 94704 37.862407336084054 -122.26801146509042
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
424 424 424 055 186400200 2300 Warring St 2300 WARRING ST 2300 WARRING ST 2300.0 WARRING ST     Berkeley 94704 37.86907088271465 -122.25123309243806
425 425 425 055 183301701 2609 Ellsworth St 203 2609 ELLSWORTH ST 203 2609 ELLSWORTH ST 2609.0 ELLSWORTH ST 203   Berkeley 94704 37.86222614025822 -122.26219043864316
429 429 429 055 186801100 2415 College Ave 25 2415 COLLEGE AVE 25 2415 COLLEGE AV 2415.0 COLLEGE AV 25   Berkeley 94704 37.86691392633499 -122.2537860793227
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
434 434 434 057 203100101 2132 Oxford St 2132 OXFORD ST 2132 OXFORD ST 2132.0 OXFORD ST     Berkeley 94704 37.87025993966203 -122.26617633093244

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