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

10,525 rows where zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

street_name >30

street_type 4

zipcode 1

  • 94703 · 10,525 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
7 7 7 052 155200400 1924 Woolsey St 1924 WOOLSEY ST 1924 WOOLSEY ST 1924.0 WOOLSEY ST     Berkeley 94703 37.85185178785158 -122.2684793382331
8 8 8 053 160002800 2913 Harper St 2913 HARPER ST 2913 HARPER ST 2913.0 HARPER ST     Berkeley 94703 37.855467068807606 -122.27198809844408
28 28 28 057 206802100 1510 Hearst Ave 3 1510 HEARST AVE 3 1510 HEARST AV 1510.0 HEARST AV 3   Berkeley 94703 37.871979332917654 -122.28150346356524
30 30 30 059 228301400 1421 Mcgee Ave B 1421 MCGEE AVE B 1421 MCGEE AV 1421.0 MCGEE AV B   Berkeley 94703 37.879495986894675 -122.27933884353074
32 32 32 056 201000800 2112 Roosevelt Ave A 2112 ROOSEVELT AVE A 2112 ROOSEVELT AV 2112.0 ROOSEVELT AV A   Berkeley 94703 37.86957367691092 -122.27655582145805
37 37 37 055 190700700 2416 Roosevelt Ave 5 2416 ROOSEVELT AVE 5 2416 ROOSEVELT AV 2416.0 ROOSEVELT AV 5   Berkeley 94703 37.86411656476258 -122.2759929784235
48 48 48 053 159100802 2916 Newbury St 2916 NEWBURY ST 2916 NEWBURY ST 2916.0 NEWBURY ST     Berkeley 94703 37.85579849311087 -122.26775051528016
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
56 56 56 052 154503100 1632 Prince St C 1632 PRINCE ST C 1632 PRINCE ST 1632.0 PRINCE ST C   Berkeley 94703 37.851748615836954 -122.27494754694362
57 57 57 054 180401201 1621 Carleton St 1621 CARLETON ST 1621 CARLETON ST 1621.0 CARLETON ST     Berkeley 94703 37.860271015415954 -122.27712902745768
58 58 58 053 159402400 2030 Essex St A 2030 ESSEX ST A 2030 ESSEX ST 2030.0 ESSEX ST A   Berkeley 94703 37.85352297506441 -122.26683968466747
66 66 66 053 161300700 1531 Prince St 2 1531 PRINCE ST 2 1531 PRINCE ST 1531.0 PRINCE ST 2   Berkeley 94703 37.85190834535323 -122.27751938317788
68 68 68 053 168200100 2870 Adeline St 602 2870 ADELINE ST 602 2870 ADELINE ST 2870.0 ADELINE ST 602   Berkeley 94703 37.85692293566353 -122.2687468205921
72 72 72 053 159500200 2008 Emerson St 3 2008 EMERSON ST 3 2008 EMERSON ST 2008.0 EMERSON ST 3   Berkeley 94703 37.85409548349568 -122.26858630961712
76 76 76 059 227802500 1629 Cedar St 1629 CEDAR ST 1629 CEDAR ST 1629.0 CEDAR ST     Berkeley 94703 37.87733495867239 -122.27923421944456
91 91 91 053 160400900 2912 Ellis St 2912 ELLIS ST 2912 ELLIS ST 2912.0 ELLIS ST     Berkeley 94703 37.855169596152535 -122.27364212685085
93 93 93 055 190601200 2426 Grant St 6 2426 GRANT ST 6 2426 GRANT ST 2426.0 GRANT ST 6   Berkeley 94703 37.86381528176066 -122.2748232838887
101 101 101 060 244501500 1312 Josephine St 6 1312 JOSEPHINE ST 6 1312 JOSEPHINE ST 1312.0 JOSEPHINE ST 6   Berkeley 94703 37.88249029496245 -122.27571469202658
119 119 119 053 160602700 1632 Tyler St 3 1632 TYLER ST 3 1632 TYLER ST 1632.0 TYLER ST 3   Berkeley 94703 37.85262584005689 -122.27517440479056
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
126 126 126 052 153600800 1525 Harmon St 5 1525 HARMON ST 5 1525 HARMON ST 1525.0 HARMON ST 5   Berkeley 94703 37.849226682857925 -122.27695033368306
127 127 127 057 207001100 1617 University Ave C 1617 UNIVERSITY AVE C 1617 UNIVERSITY AV 1617.0 UNIVERSITY AV C   Berkeley 94703 37.87106125091948 -122.27927686875928
128 128 128 057 206701501 1509 Hearst Ave 205 1509 HEARST AVE 205 1509 HEARST AV 1509.0 HEARST AV 205   Berkeley 94703 37.87246856962238 -122.28175598538148
132 132 132 059 227402800 1419 Edith St 1419 EDITH ST 1419 EDITH ST 1419.0 EDITH ST     Berkeley 94703 37.88010146733144 -122.27695720848992
134 134 134 058 216501300 1630 Josephine St 1630 JOSEPHINE ST 1630 JOSEPHINE ST 1630.0 JOSEPHINE ST     Berkeley 94703 37.87647511364487 -122.27504039501476
141 141 141 057 207000901 1619 University Ave 1619 UNIVERSITY AVE 1619 UNIVERSITY AV 1619.0 UNIVERSITY AV     Berkeley 94703 37.87109573707427 -122.27901951760008
149 149 149 056 201100700 1737 Addison St A 1737 ADDISON ST A 1737 ADDISON ST 1737.0 ADDISON ST A   Berkeley 94703 37.87046767835428 -122.27587562071815
163 163 163 053 159901600 1953 Ashby Ave A 1953 ASHBY AVE A 1953 ASHBY AV 1953.0 ASHBY AV A   Berkeley 94703 37.85466058895309 -122.27020820977776
166 166 166 052 143500900 1614 62nd St 5 1614 62ND ST 5 1614 62ND ST 1614.0 62ND ST 5   Berkeley 94703 37.846185061789946 -122.2747254474728
168 168 168 053 160901001 1635 Julia St 9 1635 JULIA ST 9 1635 JULIA ST 1635.0 JULIA ST 9   Berkeley 94703 37.85489502000247 -122.27556172330677
175 175 175 052 154503100 1632 Prince St D 1632 PRINCE ST D 1632 PRINCE ST 1632.0 PRINCE ST D   Berkeley 94703 37.851702071559735 -122.27493814876914
183 183 183 054 172800300 2716 Grant St 2716 GRANT ST 2716 GRANT ST 2716.0 GRANT ST     Berkeley 94703 37.858844865283885 -122.27357581141996
185 185 185 056 201001100 2126 Roosevelt Ave 2 2126 ROOSEVELT AVE 2 2126 ROOSEVELT AV 2126.0 ROOSEVELT AV 2   Berkeley 94703 37.86917733083612 -122.27651778499228
187 187 187 052 154501102 1625 Woolsey St 8 1625 WOOLSEY ST 8 1625 WOOLSEY ST 1625.0 WOOLSEY ST 8   Berkeley 94703 37.851235430555754 -122.27523843400904
209 209 209 053 159202300 2030 Ashby Ave 2030 ASHBY AVE 2030 ASHBY AV 2030.0 ASHBY AV     Berkeley 94703 37.85489765852584 -122.26754886056688
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
219 219 219 057 201602101 1812 University Ave Apt 309 1812 UNIVERSITY AVE 1812 UNIVERSITY AV 1812.0 UNIVERSITY AV 309 APT Berkeley 94703 37.87098195723786 -122.27462605427648
222 222 222 053 167700600 1816 Stuart St 1816 STUART ST 1816 STUART ST 1816.0 STUART ST     Berkeley 94703 37.85759602905598 -122.27225983522423
223 223 223 053 161000200 2912 California St 2912 CALIFORNIA ST 2912 CALIFORNIA ST 2912.0 CALIFORNIA ST     Berkeley 94703 37.85471355462272 -122.2773778392318
225 225 225 053 159801900 1993 Ashby Ave 5 1993 ASHBY AVE 5 1993 ASHBY AV 1993.0 ASHBY AV 5   Berkeley 94703 37.85466917411088 -122.269697290265
232 232 232 058 215701900 1600 Virginia St 1600 VIRGINIA ST 1600 VIRGINIA ST 1600.0 VIRGINIA ST     Berkeley 94703 37.8749539708499 -122.28008062468166
233 233 233 052 152700104 1896 Alcatraz Ave 1896 ALCATRAZ AVE 1896 ALCATRAZ AV 1896.0 ALCATRAZ AV     Berkeley 94703 37.84876134343059 -122.26933295424702
234 234 234 052 152400801 3398 Adeline St 3398 ADELINE ST 3398 ADELINE ST 3398.0 ADELINE ST     Berkeley 94703 37.84687993899464 -122.27266607854855
248 248 248 054 181002500 1720 Carleton St 1720 CARLETON ST 1720 CARLETON ST 1720.0 CARLETON ST     Berkeley 94703 37.86001703306796 -122.2749272980188
253 253 253 052 143700400 3334 California St 3334 CALIFORNIA ST 3334 CALIFORNIA ST 3334.0 CALIFORNIA ST     Berkeley 94703 37.84669641306018 -122.27583398290643
257 257 257 053 161201800 1505 Tyler St 1505 TYLER ST 1505 TYLER ST 1505.0 TYLER ST     Berkeley 94703 37.85268374605672 -122.2786334540303
263 263 263 057 207000300 1699 University Ave 1699 UNIVERSITY AVE 1699 UNIVERSITY AV 1699.0 UNIVERSITY AV     Berkeley 94703 37.871190934151656 -122.27780389040812
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
282 282 282 053 159901600 1953 Ashby Ave C 1953 ASHBY AVE C 1953 ASHBY AV 1953.0 ASHBY AV C   Berkeley 94703 37.85466058895309 -122.27020820977776
285 285 285 055 190302800 2411 Grant St 2411 GRANT ST 2411 GRANT ST 2411.0 GRANT ST     Berkeley 94703 37.864477207743384 -122.27419554026986
295 295 295 058 216600100 1826 Cedar St 1826 CEDAR ST 1826 CEDAR ST 1826.0 CEDAR ST     Berkeley 94703 37.87753852514454 -122.2746578582308
302 302 302 055 191001200 2426 Mcgee Ave B 2426 MCGEE AVE B 2426 MCGEE AV 2426.0 MCGEE AV B   Berkeley 94703 37.86358523780494 -122.27707933265616
311 311 311 053 159800800 2914 Adeline St A 2914 ADELINE ST A 2914 ADELINE ST 2914.0 ADELINE ST A   Berkeley 94703 37.8558597848073 -122.26930146829628
322 322 322 054 180701900 2521 Mcgee Ave 2521 MCGEE AVE 2521 MCGEE AV 2521.0 MCGEE AV     Berkeley 94703 37.862119569330545 -122.27619368990575
324 324 324 055 191404600 2346 Spaulding Ave 2346 SPAULDING AVE 2346 SPAULDING AV 2346.0 SPAULDING AV     Berkeley 94703 37.864452406006656 -122.28059698259516
331 331 331 052 155400500 2031 Woolsey St 2031 WOOLSEY ST 2031 WOOLSEY ST 2031.0 WOOLSEY ST     Berkeley 94703 37.85253062821748 -122.26663684507632
335 335 335 058 215502500 1610 Cedar St 1610 CEDAR ST 1610 CEDAR ST 1610.0 CEDAR ST     Berkeley 94703 37.87677390497363 -122.27978214685209
337 337 337 056 201003100 2105 Mcgee Ave 2105 MCGEE AVE 2105 MCGEE AV 2105.0 MCGEE AV     Berkeley 94703 37.86976858215303 -122.27712962483734
339 339 339 055 191400800 2416 Spaulding Ave 2416 SPAULDING AVE 2416 SPAULDING AV 2416.0 SPAULDING AV     Berkeley 94703 37.86340186267099 -122.28052148907702
344 344 344 053 168101700 2808 Adeline St 4 2808 ADELINE ST 4 2808 ADELINE ST 2808.0 ADELINE ST 4   Berkeley 94703 37.857943926786 -122.26836338998444
355 355 355 053 161200100 3000 California St 1 3000 CALIFORNIA ST 1 3000 CALIFORNIA ST 3000.0 CALIFORNIA ST 1   Berkeley 94703 37.85333729238306 -122.27706002336916
373 373 373 055 191400900 2418 Spaulding Ave 2418 SPAULDING AVE 2418 SPAULDING AV 2418.0 SPAULDING AV     Berkeley 94703 37.863308354772315 -122.28051050896931
380 380 380 052 152600200 1833 62nd St 1833 62ND ST 1833 62ND ST 1833.0 62ND ST     Berkeley 94703 37.847439168864454 -122.26936549931142
388 388 388 053 167200400 1529 Russell St 1529 RUSSELL ST 1529 RUSSELL ST 1529.0 RUSSELL ST     Berkeley 94703 37.855424659116466 -122.2781363155723
393 393 393 053 161102500 1518 Julia St C 1518 JULIA ST C 1518 JULIA ST 1518.0 JULIA ST C   Berkeley 94703 37.85402958704808 -122.27825873528424
396 396 396 055 191002900 2419 Jefferson Ave A 2419 JEFFERSON AVE A 2419 JEFFERSON AV 2419.0 JEFFERSON AV A   Berkeley 94703 37.86373118044656 -122.2775497129968
397 397 397 055 190701300 2432 Roosevelt Ave 2432 ROOSEVELT AVE 2432 ROOSEVELT AV 2432.0 ROOSEVELT AV     Berkeley 94703 37.86346859894103 -122.27592282089816
399 399 399 058 215902800 1712 Francisco St B 1712 FRANCISCO ST B 1712 FRANCISCO ST 1712.0 FRANCISCO ST B   Berkeley 94703 37.874352916095994 -122.27712860345288
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
410 410 410 053 167200400 1529 Russell St 14 1529 RUSSELL ST 14 1529 RUSSELL ST 1529.0 RUSSELL ST 14   Berkeley 94703 37.855424659116466 -122.2781363155723
411 411 411 055 190302600 2417 Grant St 2417 GRANT ST 2417 GRANT ST 2417.0 GRANT ST     Berkeley 94703 37.8641895178636 -122.2741635476693
416 416 416 059 228202400 1417 Cypress St 1417 CYPRESS ST 1417 CYPRESS ST 1417.0 CYPRESS ST     Berkeley 94703 37.8798257801188 -122.27786180659112
417 417 417 052 152400104 3337 King St 3337 KING ST 3337 KING ST 3337.0 KING ST     Berkeley 94703 37.84720497444026 -122.27295898502672
420 420 420 053 167200400 1529 Russell St 3 1529 RUSSELL ST 3 1529 RUSSELL ST 1529.0 RUSSELL ST 3   Berkeley 94703 37.855424659116466 -122.2781363155723
421 421 421 054 173000400 1645 Stuart St 1645 STUART ST 1645 STUART ST 1645.0 STUART ST     Berkeley 94703 37.8576471166397 -122.27563366129304
426 426 426 056 200601100 2134 Mcgee Ave 2134 MCGEE AVE 2134 MCGEE AV 2134.0 MCGEE AV     Berkeley 94703 37.868669820938216 -122.27760654401494
428 428 428 053 167200400 1529 Russell St 21 1529 RUSSELL ST 21 1529 RUSSELL ST 1529.0 RUSSELL ST 21   Berkeley 94703 37.855424659116466 -122.2781363155723
431 431 431 053 167302200 2835 California St 4 2835 CALIFORNIA ST 4 2835 CALIFORNIA ST 2835.0 CALIFORNIA ST 4   Berkeley 94703 37.85594323264491 -122.27703840631013
435 435 435 052 154501101 1627 Woolsey St 10 1627 WOOLSEY ST 10 1627 WOOLSEY ST 1627.0 WOOLSEY ST 10   Berkeley 94703 37.851181779315795 -122.27504628796302
437 437 437 060 243400500 1523 Ada St 1523 ADA ST 1523 ADA ST 1523.0 ADA ST     Berkeley 94703 37.88065925824167 -122.28229688976016
445 445 445 053 159901100 2926 Otis St 1 2926 OTIS ST 1 2926 OTIS ST 2926.0 OTIS ST 1   Berkeley 94703 37.85528123852836 -122.27040567474856
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
453 453 453 057 206802900 1540 Hearst Ave 1540 HEARST AVE 1540 HEARST AV 1540.0 HEARST AV     Berkeley 94703 37.87211197154264 -122.28045162530074
454 454 454 052 154700101 3131 King St B 3131 KING ST B 3131 KING ST 3131.0 KING ST B   Berkeley 94703 37.851066675647246 -122.27373526328118
460 460 460 053 160203000 3009 Ellis St 3009 ELLIS ST 3009 ELLIS ST 3009.0 ELLIS ST     Berkeley 94703 37.8536597827943 -122.27286220143633
464 464 464 053 167400600 1637 Oregon St 1637 OREGON ST 1637 OREGON ST 1637.0 OREGON ST     Berkeley 94703 37.85675516617272 -122.27585999272716
467 467 467 056 200902500 2229 Mcgee Ave O 2229 MCGEE AVE O 2229 MCGEE AV 2229.0 MCGEE AV O   Berkeley 94703 37.867050975147784 -122.27673704488852
489 489 489 053 160002300 2929 Harper St 2929 HARPER ST 2929 HARPER ST 2929.0 HARPER ST     Berkeley 94703 37.85481305337622 -122.271918770962
491 491 491 053 168200100 2870 Adeline St 505 2870 ADELINE ST 505 2870 ADELINE ST 2870.0 ADELINE ST 505   Berkeley 94703 37.85692293566353 -122.2687468205921
493 493 493 059 228500200 1510 Rose St 1510 ROSE ST 1510 ROSE ST 1510.0 ROSE ST     Berkeley 94703 37.8789619856946 -122.28227038496767
495 495 495 059 228001200 1621 Buena Ave 1621 BUENA AVE 1621 BUENA AV 1621.0 BUENA AV     Berkeley 94703 37.87918003349705 -122.27995111636378
504 504 504 056 201101600 2015 Mcgee Ave 2015 MCGEE AVE 2015 MCGEE AV 2015.0 MCGEE AV     Berkeley 94703 37.87030890738112 -122.27715292444088
510 510 510 058 215301100 1519 Virginia St 1519 VIRGINIA ST 1519 VIRGINIA ST 1519.0 VIRGINIA ST     Berkeley 94703 37.87526565737787 -122.28142222891408
520 520 520 055 190300600 2410 Mckinley Ave 2410 MCKINLEY AVE 2410 MCKINLEY AV 2410.0 MCKINLEY AV     Berkeley 94703 37.86452217806778 -122.27375398057843
526 526 526 057 206001600 1830 Berkeley Way 1830 BERKELEY WAY 1830 BERKELEY WY 1830.0 BERKELEY WY     Berkeley 94703 37.87206681651637 -122.27399328368529
544 544 544 054 172700900 1825 Ward St 1825 WARD ST 1825 WARD ST 1825.0 WARD ST     Berkeley 94703 37.859057913615416 -122.27227905557804
549 549 549 056 200900400 2200 Roosevelt Ave 3 2200 ROOSEVELT AVE 3 2200 ROOSEVELT AV 2200.0 ROOSEVELT AV 3   Berkeley 94703 37.868174482988366 -122.27636723992704
551 551 551 055 190503000 2319 Roosevelt Ave 2319 ROOSEVELT AVE 2319 ROOSEVELT AV 2319.0 ROOSEVELT AV     Berkeley 94703 37.8657405229345 -122.27546877192934
560 560 560 053 160901001 1635 Julia St 6 1635 JULIA ST 6 1635 JULIA ST 1635.0 JULIA ST 6   Berkeley 94703 37.85489502000247 -122.27556172330677

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