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,738 rows where zipcode = 94709

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

street_name >30

street_type 5

zipcode 1

  • 94709 · 6,738 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
6 6 6 059 226101000 1467 Shattuck Ave 1467 SHATTUCK AVE 1467 SHATTUCK AV 1467.0 SHATTUCK AV     Berkeley 94709 37.88086633869915 -122.26894662836916
19 19 19 058 217700100 1709 Shattuck Ave 222 1709 SHATTUCK AVE 222 1709 SHATTUCK AV 1709.0 SHATTUCK AV 222   Berkeley 94709 37.87615366613259 -122.26846057871502
25 25 25 058 218203600 1729 Spruce St 1729 SPRUCE ST 1729 SPRUCE ST 1729.0 SPRUCE ST     Berkeley 94709 37.87652044749161 -122.26508568993928
35 35 35 058 219300102 1708 Euclid Ave 2 1708 EUCLID AVE 2 1708 EUCLID AV 1708.0 EUCLID AV 2   Berkeley 94709 37.87740017556253 -122.26087638214726
43 43 43 059 226503700 2008 Rose St 2008 ROSE ST 2008 ROSE ST 2008.0 ROSE ST     Berkeley 94709 37.88150576234678 -122.27100827631928
44 44 44 060 246401100 2249 Glen Ave 2249 GLEN AVE 2249 GLEN AV 2249.0 GLEN AV     Berkeley 94709 37.88469248925343 -122.26526777844737
46 46 46 058 219400100 1652 Euclid Ave 3 1652 EUCLID AVE 3 1652 EUCLID AV 1652.0 EUCLID AV 3   Berkeley 94709 37.87841445612566 -122.26101042875396
52 52 52 060 246302300 2290 Eunice St 2290 EUNICE ST 2290 EUNICE ST 2290.0 EUNICE ST     Berkeley 94709 37.88593906545171 -122.26556284986536
59 59 59 058 218600400 1640 Scenic Ave 2 1640 SCENIC AVE 2 1640 SCENIC AV 1640.0 SCENIC AV 2   Berkeley 94709 37.878542616840186 -122.26311174810364
64 64 64 060 245501000 1222 Shattuck Ave A 1222 SHATTUCK AVE A 1222 SHATTUCK AV 1222.0 SHATTUCK AV A   Berkeley 94709 37.88473974934014 -122.27023117610636
77 77 77 058 217700100 1709 Shattuck Ave 311 1709 SHATTUCK AVE 311 1709 SHATTUCK AV 1709.0 SHATTUCK AV 311   Berkeley 94709 37.87615366613259 -122.26846057871502
96 96 96 057 205001302 2015 Hearst Ave 2015 HEARST AVE 2015 HEARST AV 2015.0 HEARST AV     Berkeley 94709 37.87395294459053 -122.27023887017674
102 102 102 059 226503200 1408 Henry St 1408 HENRY ST 1408 HENRY ST 1408.0 HENRY ST     Berkeley 94709 37.881178507873464 -122.27097964431624
104 104 104 058 218100200 2210 Virginia St 1 2210 VIRGINIA ST 1 2210 VIRGINIA ST 2210.0 VIRGINIA ST 1   Berkeley 94709 37.876792191175774 -122.2661498962086
125 125 125 060 245506401 2095 Rose St 103 2095 ROSE ST 103 2095 ROSE ST 2095.0 ROSE ST 103   Berkeley 94709 37.88222783348664 -122.26993556120756
130 130 130 058 220000700 2511 Hearst Ave 203 2511 HEARST AVE 203 2511 HEARST AV 2511.0 HEARST AV 203   Berkeley 94709 37.87542843887812 -122.25958119206894
145 145 145 058 219701100 2505 Virginia St 4 2505 VIRGINIA ST 4 2505 VIRGINIA ST 2505.0 VIRGINIA ST 4   Berkeley 94709 37.87796842781608 -122.26046876440056
148 148 148 059 225401900 1433 Spruce St A 1433 SPRUCE ST A 1433 SPRUCE ST 1433.0 SPRUCE ST A   Berkeley 94709 37.8811052766379 -122.26565651091184
153 153 153 059 226700400 1524 Milvia St 1524 MILVIA ST 1524 MILVIA ST 1524.0 MILVIA ST     Berkeley 94709 37.879321975305274 -122.2719631153977
155 155 155 058 218100400 1720 Spruce St 1 1720 SPRUCE ST 1 1720 SPRUCE ST 1720.0 SPRUCE ST 1   Berkeley 94709 37.87667202431772 -122.26579711791508
171 171 171 058 219800700 2565 Le Conte Ave 2565 LE CONTE AVE 2565 LE CONTE AV 2565.0 LE CONTE AV     Berkeley 94709 37.87729848154779 -122.25940056601812
172 172 172 058 217900700 1644 Oxford St 10 1644 OXFORD ST 10 1644 OXFORD ST 1644.0 OXFORD ST 10   Berkeley 94709 37.87792428749744 -122.26710658132497
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
199 199 199 058 217600301 2087 Delaware St 15 2087 DELAWARE ST 15 2087 DELAWARE ST 2087.0 DELAWARE ST 15   Berkeley 94709 37.87493720660259 -122.26907990961126
213 213 213 057 205001103 2025 Hearst Ave 3 2025 HEARST AVE 3 2025 HEARST AV 2025.0 HEARST AV 3   Berkeley 94709 37.87400257073312 -122.26982323496614
215 215 215 060 246609100 1331 Walnut St 1331 WALNUT ST 1331 WALNUT ST 1331.0 WALNUT ST     Berkeley 94709 37.88281839583904 -122.26814145400698
256 256 256 058 217300203 1600 Shattuck Ave 118 1600 SHATTUCK AVE 118 1600 SHATTUCK AV 1600.0 SHATTUCK AV 118   Berkeley 94709 37.878062146845366 -122.2695263103237
258 258 258 058 218701101 1682 Scenic Ave 1682 SCENIC AVE 1682 SCENIC AV 1682.0 SCENIC AV     Berkeley 94709 37.87775688418406 -122.26294228901014
259 259 259 058 218205600 1810 Arch St 1810 ARCH ST 1810 ARCH ST 1810.0 ARCH ST     Berkeley 94709 37.87588151946355 -122.26428494966132
270 270 270 058 217300203 1600 Shattuck Ave 212 1600 SHATTUCK AVE 212 1600 SHATTUCK AV 1600.0 SHATTUCK AV 212   Berkeley 94709 37.878062146845366 -122.2695263103237
271 271 271 058 217002200 1908 Virginia St 1908 VIRGINIA ST 1908 VIRGINIA ST 1908.0 VIRGINIA ST     Berkeley 94709 37.87581354220183 -122.27297921778188
283 283 283 058 218801100 1798 Scenic Ave 422 1798 SCENIC AVE 422 1798 SCENIC AV 1798.0 SCENIC AV 422   Berkeley 94709 37.8766939260967 -122.2633426061485
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
291 291 291 058 217902300 1627 Walnut St 1627 WALNUT ST 1627 WALNUT ST 1627.0 WALNUT ST     Berkeley 94709 37.877612567547885 -122.2675417674694
294 294 294 058 217600700 2029 Delaware St 2029 DELAWARE ST 2029 DELAWARE ST 2029.0 DELAWARE ST     Berkeley 94709 37.87493792419924 -122.2696732576362
314 314 314 060 246606000 2201 Rose St 1 2201 ROSE ST 1 2201 ROSE ST 2201.0 ROSE ST 1   Berkeley 94709 37.88260607275032 -122.26708548349217
321 321 321 058 217902300 1625 Walnut St 1625 WALNUT ST 1625 WALNUT ST 1625.0 WALNUT ST     Berkeley 94709 37.877612567547885 -122.2675417674694
328 328 328 058 217901100 1672 Oxford St 18 1672 OXFORD ST 18 1672 OXFORD ST 1672.0 OXFORD ST 18   Berkeley 94709 37.87737733590169 -122.2670467472388
333 333 333 059 225600200 2210 Vine St 2210 VINE ST 2210 VINE ST 2210.0 VINE ST     Berkeley 94709 37.880356117851555 -122.26651555454669
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
346 346 346 058 218203100 1785 Spruce St 1 1785 SPRUCE ST 1 1785 SPRUCE ST 1785.0 SPRUCE ST 1   Berkeley 94709 37.875505634563595 -122.26487810724342
353 353 353 058 219900800 2523 Ridge Rd 214 2523 RIDGE RD 214 2523 RIDGE RD 2523.0 RIDGE RD 214   Berkeley 94709 37.87639846070757 -122.25955390574217
358 358 358 058 217502300 2018 Virginia St A 2018 VIRGINIA ST A 2018 VIRGINIA ST 2018.0 VIRGINIA ST A   Berkeley 94709 37.87616007759661 -122.27026293783985
359 359 359 059 226002003 1521 Shattuck Ave 9901 1521 SHATTUCK AVE 9901 1521 SHATTUCK AV 1521.0 SHATTUCK AV 9901   Berkeley 94709 37.87945534591521 -122.26885331766567
366 366 366 058 218600700 2355 Hilgard Ave 305 2355 HILGARD AVE 305 2355 HILGARD AV 2355.0 HILGARD AV 305   Berkeley 94709 37.878530801181725 -122.26363653401116
389 389 389 059 226303200 1511 Henry St B 1511 HENRY ST B 1511 HENRY ST 1511.0 HENRY ST B   Berkeley 94709 37.87964921037518 -122.27013396222291
392 392 392 058 218203301 1743 Spruce St 1743 SPRUCE ST 1743 SPRUCE ST 1743.0 SPRUCE ST     Berkeley 94709 37.87607529618623 -122.2650943604784
400 400 400 058 217902100 1633 Walnut St 2 1633 WALNUT ST 2 1633 WALNUT ST 1633.0 WALNUT ST 2   Berkeley 94709 37.87734074747496 -122.26751187333336
404 404 404 058 218600800 2339 Hilgard Ave 202 2339 HILGARD AVE 202 2339 HILGARD AV 2339.0 HILGARD AV 202   Berkeley 94709 37.87850811644504 -122.26380927105711
415 415 415 057 204901000 2111 Hearst Ave 2111 HEARST AVE 2111 HEARST AV 2111.0 HEARST AV     Berkeley 94709 37.874217998930376 -122.2682033389469
432 432 432 060 246603800 1229 Oxford St A 1229 OXFORD ST A 1229 OXFORD ST 1229.0 OXFORD ST A   Berkeley 94709 37.88495921716209 -122.26725330765186
438 438 438 059 226604100 1429 Bonita Ave 3 1429 BONITA AVE 3 1429 BONITA AV 1429.0 BONITA AV 3   Berkeley 94709 37.88061964883796 -122.27252495950562
456 456 456 057 205602800 1932 Hearst Ave H 1932 HEARST AVE H 1932 HEARST AV 1932.0 HEARST AV H   Berkeley 94709 37.873252761785416 -122.2714947131473
458 458 458 060 246402500 2240 Summer St 2 2240 SUMMER ST 2 2240 SUMMER ST 2240.0 SUMMER ST 2   Berkeley 94709 37.884971411099535 -122.26565223313446
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
471 471 471 058 218301600 1675 Oxford St 1675 OXFORD ST 1675 OXFORD ST 1675.0 OXFORD ST     Berkeley 94709 37.877350488602055 -122.2663711701277
473 473 473 058 219100102 1810 Euclid Ave 18 1810 EUCLID AVE 18 1810 EUCLID AV 1810.0 EUCLID AV 18   Berkeley 94709 37.87580213595333 -122.26059587601328
477 477 477 059 226501400 2015 Vine St 2015 VINE ST 2015 VINE ST 2015.0 VINE ST     Berkeley 94709 37.880191201694814 -122.2708703337192
498 498 498 059 225702200 1441 Oxford St 2 1441 OXFORD ST 2 1441 OXFORD ST 1441.0 OXFORD ST 2   Berkeley 94709 37.880961579872945 -122.26678378610065
500 500 500 060 245100400 1990 Berryman St 1990 BERRYMAN ST 1990 BERRYMAN ST 1990.0 BERRYMAN ST     Berkeley 94709 37.883362762405774 -122.27228285814668
502 502 502 060 245501400 2033 Berryman St 2033 BERRYMAN ST 2033 BERRYMAN ST 2033.0 BERRYMAN ST     Berkeley 94709 37.883992351813575 -122.27044207717884
509 509 509 058 221200103 2779 Hilgard Ave 2779 HILGARD AVE 2779 HILGARD AV 2779.0 HILGARD AV     Berkeley 94709 37.87965011794923 -122.2552855202455
513 513 513 059 226001700 1533 Shattuck Ave A 1533 SHATTUCK AVE A 1533 SHATTUCK AV 1533.0 SHATTUCK AV A   Berkeley 94709 37.878981369669944 -122.26879159262587
518 518 518 058 219802400 2566 Virginia St 2566 VIRGINIA ST 2566 VIRGINIA ST 2566.0 VIRGINIA ST     Berkeley 94709 37.87770201210136 -122.25933885175807
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
527 527 527 058 218700900 2396 Hilgard Ave 2396 HILGARD AVE 2396 HILGARD AV 2396.0 HILGARD AV     Berkeley 94709 37.87817460257434 -122.2630285218875
528 528 528 059 226901000 1420 Bonita Ave 1420 BONITA AVE 1420 BONITA AV 1420.0 BONITA AV     Berkeley 94709 37.88059614368429 -122.27320276893025
529 529 529 057 204901201 1801 Shattuck Ave Apt 206 1801 SHATTUCK AVE 1801 SHATTUCK AV 1801.0 SHATTUCK AV 206 APT Berkeley 94709 37.874565856486015 -122.26825581762748
531 531 531 059 226001400 2109 Cedar St Front 2109 CEDAR ST FRONT 2109 CEDAR ST 2109.0 CEDAR ST FRONT   Berkeley 94709 37.87869513750692 -122.26854315455088
540 540 540 058 217301300 2013 Lincoln St 4 2013 LINCOLN ST 4 2013 LINCOLN ST 2013.0 LINCOLN ST 4   Berkeley 94709 37.87756144913377 -122.27070964308116
545 545 545 059 225503400 2277 Cedar St 2277 CEDAR ST 2277 CEDAR ST 2277.0 CEDAR ST     Berkeley 94709 37.87910299907082 -122.26509693684666
555 555 555 058 220501201 1765 Le Roy Ave C 1765 LE ROY AVE C 1765 LE ROY AV 1765.0 LE ROY AV C   Berkeley 94709 37.87661310475602 -122.25824480615
568 568 568 059 226401401 1530 Henry St 11 1530 HENRY ST 11 1530 HENRY ST 1530.0 HENRY ST 11   Berkeley 94709 37.87888770073464 -122.27071435474484
571 571 571 060 245504300 1334 Walnut St 4 1334 WALNUT ST 4 1334 WALNUT ST 1334.0 WALNUT ST 4   Berkeley 94709 37.88263085419593 -122.26881107798268
583 583 583 059 225902500 1517 Walnut St 6 1517 WALNUT ST 6 1517 WALNUT ST 1517.0 WALNUT ST 6   Berkeley 94709 37.879817529013465 -122.26779873864125
598 598 598 058 218100600 1734 Spruce St 5 1734 SPRUCE ST 5 1734 SPRUCE ST 1734.0 SPRUCE ST 5   Berkeley 94709 37.876292165543326 -122.26575573342824
603 603 603 058 218102200 1819 Oxford St 1819 OXFORD ST 1819 OXFORD ST 1819.0 OXFORD ST     Berkeley 94709 37.874930570251344 -122.26612295752986
614 614 614 058 217700707 1728 Walnut St 3 1728 WALNUT ST 3 1728 WALNUT ST 1728.0 WALNUT ST 3   Berkeley 94709 37.8761080448842 -122.26803089115845
632 632 632 060 245508700 2043 Berryman St 1 2043 BERRYMAN ST 1 2043 BERRYMAN ST 2043.0 BERRYMAN ST 1   Berkeley 94709 37.88412173789877 -122.27015669049791
638 638 638 058 217502002 2002 Virginia St 2002 VIRGINIA ST 2002 VIRGINIA ST 2002.0 VIRGINIA ST     Berkeley 94709 37.876201251491736 -122.27102369230788
642 642 642 059 225601500 2235 Cedar St 2235 CEDAR ST 2235 CEDAR ST 2235.0 CEDAR ST     Berkeley 94709 37.878995049344795 -122.26598842134136
646 646 646 058 218103200 1725 Oxford St 202 1725 OXFORD ST 202 1725 OXFORD ST 1725.0 OXFORD ST 202   Berkeley 94709 37.876329729467955 -122.2662473032298
648 648 648 059 226502400 1423 Milvia St D 1423 MILVIA ST D 1423 MILVIA ST 1423.0 MILVIA ST D   Berkeley 94709 37.88096316029992 -122.27142418012616
649 649 649 060 246610100 1303 Walnut St A 1303 WALNUT ST A 1303 WALNUT ST 1303.0 WALNUT ST A   Berkeley 94709 37.88383381063709 -122.26828265299996
661 661 661 058 219100102 1810 Euclid Ave 1 1810 EUCLID AVE 1 1810 EUCLID AV 1810.0 EUCLID AV 1   Berkeley 94709 37.87580213595333 -122.26059587601328
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
673 673 673 058 216902801 1920 Francisco St 109 1920 FRANCISCO ST 109 1920 FRANCISCO ST 1920.0 FRANCISCO ST 109   Berkeley 94709 37.87494632617776 -122.27249858317224
675 675 675 060 245506000 1322 Shattuck Ave 306 1322 SHATTUCK AVE 306 1322 SHATTUCK AV 1322.0 SHATTUCK AV 306   Berkeley 94709 37.88295251379563 -122.27005857380765
681 681 681 058 219701301 1675 Euclid Ave 4 1675 EUCLID AVE 4 1675 EUCLID AV 1675.0 EUCLID AV 4   Berkeley 94709 37.87825407854124 -122.26046688153173
700 700 700 059 225702200 1441 Oxford St 1441 OXFORD ST 1441 OXFORD ST 1441.0 OXFORD ST     Berkeley 94709 37.880961579872945 -122.26678378610065
703 703 703 058 217600301 1786 Shattuck Ave 1786 SHATTUCK AVE 1786 SHATTUCK AV 1786.0 SHATTUCK AV     Berkeley 94709 37.87510448514307 -122.26895027642756
708 708 708 058 220800904 2772 Hilgard Ave 2772 HILGARD AVE 2772 HILGARD AV 2772.0 HILGARD AV     Berkeley 94709 37.87902268167056 -122.25587354934564
719 719 719 058 219701100 2505 Virginia St 7 2505 VIRGINIA ST 7 2505 VIRGINIA ST 2505.0 VIRGINIA ST 7   Berkeley 94709 37.87796842781608 -122.26046876440056
736 736 736 057 205003101 2050 Delaware St 412 2050 DELAWARE ST 412 2050 DELAWARE ST 2050.0 DELAWARE ST 412   Berkeley 94709 37.87439202470472 -122.26904685340544
743 743 743 058 218103000 1749 Oxford St 2 1749 OXFORD ST 2 1749 OXFORD ST 1749.0 OXFORD ST 2   Berkeley 94709 37.875966920830834 -122.26621912307937
745 745 745 059 226501900 1437 Milvia St 1437 MILVIA ST 1437 MILVIA ST 1437.0 MILVIA ST     Berkeley 94709 37.880403618956805 -122.27136228620309
746 746 746 059 226403000 1517 Milvia St 1517 MILVIA ST 1517 MILVIA ST 1517.0 MILVIA ST     Berkeley 94709 37.87932822695831 -122.27123443348026
751 751 751 058 217202300 1621 Bonita Ave A 1621 BONITA AVE A 1621 BONITA AV 1621.0 BONITA AV A   Berkeley 94709 37.877171843869704 -122.2721132948486
757 757 757 058 219200102 2450 Le Conte Ave 303 2450 LE CONTE AVE 303 2450 LE CONTE AV 2450.0 LE CONTE AV 303   Berkeley 94709 37.87638188114811 -122.26123567951484
787 787 787 057 205600400 1940 Delaware St 1940 DELAWARE ST 1940 DELAWARE ST 1940.0 DELAWARE ST     Berkeley 94709 37.87423756568229 -122.27134836950268

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