Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
6,738 rows where zipcode = 94709
This data as json, CSV (advanced)
Suggested facets: unit_type
street_name >30
- SHATTUCK 592
- OXFORD 587
- SPRUCE 543
- VIRGINIA 471
- WALNUT 436
- MARTIN LUTHER KING JR 422
- HEARST 346
- MILVIA 325
- DELAWARE 313
- LE CONTE 274
- BONITA 266
- HILGARD 260
- HENRY 209
- EUCLID 202
- FRANCISCO 191
- VINE 177
- CEDAR 176
- RIDGE 156
- ARCH 146
- ROSE 130
- SCENIC 103
- HIGHLAND 74
- BERRYMAN 69
- LE ROY 56
- LA LOMA 50
- EUNICE 43
- LINCOLN 35
- LA VEREDA 26
- SUMMER 24
- GLEN 16
- …
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 |
Advanced export
JSON shape: default, array, newline-delimited
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);