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

3,879 rows where street_type = "ST" and zipcode = 94709

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

street_name 19

zipcode 1

  • 94709 · 3,879 ✖

street_type 1

  • ST · 3,879 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
25 25 25 058 218203600 1729 Spruce St 1729 SPRUCE ST 1729 SPRUCE ST 1729.0 SPRUCE ST     Berkeley 94709 37.87652044749161 -122.26508568993928
43 43 43 059 226503700 2008 Rose St 2008 ROSE ST 2008 ROSE ST 2008.0 ROSE ST     Berkeley 94709 37.88150576234678 -122.27100827631928
52 52 52 060 246302300 2290 Eunice St 2290 EUNICE ST 2290 EUNICE ST 2290.0 EUNICE ST     Berkeley 94709 37.88593906545171 -122.26556284986536
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
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
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
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
215 215 215 060 246609100 1331 Walnut St 1331 WALNUT ST 1331 WALNUT ST 1331.0 WALNUT ST     Berkeley 94709 37.88281839583904 -122.26814145400698
259 259 259 058 218205600 1810 Arch St 1810 ARCH ST 1810 ARCH ST 1810.0 ARCH ST     Berkeley 94709 37.87588151946355 -122.26428494966132
271 271 271 058 217002200 1908 Virginia St 1908 VIRGINIA ST 1908 VIRGINIA ST 1908.0 VIRGINIA ST     Berkeley 94709 37.87581354220183 -122.27297921778188
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
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
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
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
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
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
471 471 471 058 218301600 1675 Oxford St 1675 OXFORD ST 1675 OXFORD ST 1675.0 OXFORD ST     Berkeley 94709 37.877350488602055 -122.2663711701277
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
518 518 518 058 219802400 2566 Virginia St 2566 VIRGINIA ST 2566 VIRGINIA ST 2566.0 VIRGINIA ST     Berkeley 94709 37.87770201210136 -122.25933885175807
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
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
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
700 700 700 059 225702200 1441 Oxford St 1441 OXFORD ST 1441 OXFORD ST 1441.0 OXFORD ST     Berkeley 94709 37.880961579872945 -122.26678378610065
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
787 787 787 057 205600400 1940 Delaware St 1940 DELAWARE ST 1940 DELAWARE ST 1940.0 DELAWARE ST     Berkeley 94709 37.87423756568229 -122.27134836950268
794 794 794 058 217500800 2041 Francisco St 12A 2041 FRANCISCO ST 12A 2041 FRANCISCO ST 2041.0 FRANCISCO ST 12A   Berkeley 94709 37.876012744962715 -122.26959268055184
797 797 797 058 217900800 1650 Oxford St 19 1650 OXFORD ST 19 1650 OXFORD ST 1650.0 OXFORD ST 19   Berkeley 94709 37.87778546427877 -122.26709365097472
824 824 824 059 225400300 2240 Rose St 3 2240 ROSE ST 3 2240 ROSE ST 2240.0 ROSE ST 3   Berkeley 94709 37.882345612531125 -122.26548593072089
834 834 834 058 218000102 1741 Walnut St 1741 WALNUT ST 1741 WALNUT ST 1741.0 WALNUT ST     Berkeley 94709 37.875372799250776 -122.2670668829759
845 845 845 058 218200700 1710 Arch St 1710 ARCH ST 1710 ARCH ST 1710.0 ARCH ST     Berkeley 94709 37.87717767239278 -122.26464307472745
864 864 864 058 218206500 1849 Spruce St 3 1849 SPRUCE ST 3 1849 SPRUCE ST 1849.0 SPRUCE ST 3   Berkeley 94709 37.87479868408076 -122.26519058262171
904 904 904 060 245100600 1306 Milvia St 1306 MILVIA ST 1306 MILVIA ST 1306.0 MILVIA ST     Berkeley 94709 37.88313309569945 -122.27234238231402
922 922 922 060 245101400 1332 Milvia St 1332 MILVIA ST 1332 MILVIA ST 1332.0 MILVIA ST     Berkeley 94709 37.88225848288555 -122.27224351283556
926 926 926 059 225601500 2237 Cedar St 2237 CEDAR ST 2237 CEDAR ST 2237.0 CEDAR ST     Berkeley 94709 37.878995049344795 -122.26598842134136
927 927 927 059 226000201 2122 Vine St A 2122 VINE ST A 2122 VINE ST 2122.0 VINE ST A   Berkeley 94709 37.88015464302729 -122.26837409341108
937 937 937 058 218100300 1700 Spruce St 12 1700 SPRUCE ST 12 1700 SPRUCE ST 1700.0 SPRUCE ST 12   Berkeley 94709 37.876823189571645 -122.26582819064072
949 949 949 058 218202100 1890 Arch St 9 1890 ARCH ST 9 1890 ARCH ST 1890.0 ARCH ST 9   Berkeley 94709 37.87475308893859 -122.2642120630541
950 950 950 058 218100800 1742 Spruce St Unit 23 1742 SPRUCE ST 1742 SPRUCE ST 1742.0 SPRUCE ST 23 UNIT Berkeley 94709 37.87605127337441 -122.26585683971176
961 961 961 058 217900800 1650 Oxford St 3 1650 OXFORD ST 3 1650 OXFORD ST 1650.0 OXFORD ST 3   Berkeley 94709 37.87778546427877 -122.26709365097472
975 975 975 059 225502900 2281 Cedar St 2281 CEDAR ST 2281 CEDAR ST 2281.0 CEDAR ST     Berkeley 94709 37.879134007129906 -122.26487933164717
1000 1000 1000 059 225400200 2238 Rose St 2238 ROSE ST 2238 ROSE ST 2238.0 ROSE ST     Berkeley 94709 37.882274686052256 -122.26563160961216
1001 1001 1001 058 217302500 2020 Cedar St 5 2020 CEDAR ST 5 2020 CEDAR ST 2020.0 CEDAR ST 5   Berkeley 94709 37.8780031319637 -122.2702766191816
1008 1008 1008 059 226000800 1524 Walnut St 2 1524 WALNUT ST 2 1524 WALNUT ST 1524.0 WALNUT ST 2   Berkeley 94709 37.87933678584413 -122.2683972411993
1012 1012 1012 059 225900400 1506 Oxford St 1506 OXFORD ST 1506 OXFORD ST 1506.0 OXFORD ST     Berkeley 94709 37.87999336449833 -122.2673551119264
1027 1027 1027 059 225801400 1438 Oxford St 1438 OXFORD ST 1438 OXFORD ST 1438.0 OXFORD ST     Berkeley 94709 37.880834301147615 -122.26730490508515
1036 1036 1036 060 246605900 2207 Rose St 2207 ROSE ST 2207 ROSE ST 2207.0 ROSE ST     Berkeley 94709 37.88263217437914 -122.26688252352676
1081 1081 1081 058 217001201 1921 Francisco St 1C 1921 FRANCISCO ST 1C 1921 FRANCISCO ST 1921.0 FRANCISCO ST 1C   Berkeley 94709 37.87551408185858 -122.2723596137978
1113 1113 1113 059 226601300 1432 Milvia St B 1432 MILVIA ST B 1432 MILVIA ST 1432.0 MILVIA ST B   Berkeley 94709 37.88041584910029 -122.27203571364568
1129 1129 1129 058 218101400 1820 Spruce St 3 1820 SPRUCE ST 3 1820 SPRUCE ST 1820.0 SPRUCE ST 3   Berkeley 94709 37.87482231304778 -122.26572442893722
1143 1143 1143 059 226102000 1440 Walnut St A 1440 WALNUT ST A 1440 WALNUT ST 1440.0 WALNUT ST A   Berkeley 94709 37.88084176227877 -122.26857263995346
1150 1150 1150 057 205003101 2050 Delaware St 315 2050 DELAWARE ST 315 2050 DELAWARE ST 2050.0 DELAWARE ST 315   Berkeley 94709 37.87439202470472 -122.26904685340544
1175 1175 1175 059 225403500 1411 Spruce St 1 1411 SPRUCE ST 1 1411 SPRUCE ST 1411.0 SPRUCE ST 1   Berkeley 94709 37.88201291510209 -122.26576225968878
1188 1188 1188 058 218401300 2275 Virginia St 2275 VIRGINIA ST 2275 VIRGINIA ST 2275.0 VIRGINIA ST     Berkeley 94709 37.87797462924085 -122.26482808545516
1220 1220 1220 057 205003101 2050 Delaware St 108 2050 DELAWARE ST 108 2050 DELAWARE ST 2050.0 DELAWARE ST 108   Berkeley 94709 37.87439202470472 -122.26904685340544
1232 1232 1232 058 217301200 2017 Lincoln St 2017 LINCOLN ST 2017 LINCOLN ST 2017.0 LINCOLN ST     Berkeley 94709 37.87758520839109 -122.27052909698044
1279 1279 1279 058 217002000 1902 Virginia St 3 1902 VIRGINIA ST 3 1902 VIRGINIA ST 1902.0 VIRGINIA ST 3   Berkeley 94709 37.875865487905536 -122.2732801866397
1286 1286 1286 059 225402100 1429 Spruce St 1429 SPRUCE ST 1429 SPRUCE ST 1429.0 SPRUCE ST     Berkeley 94709 37.88136471528338 -122.26574426284036
1290 1290 1290 057 205003101 2050 Delaware St 309 2050 DELAWARE ST 309 2050 DELAWARE ST 2050.0 DELAWARE ST 309   Berkeley 94709 37.87439202470472 -122.26904685340544
1306 1306 1306 060 244901300 1915 Berryman St B 1915 BERRYMAN ST B 1915 BERRYMAN ST 1915.0 BERRYMAN ST B   Berkeley 94709 37.88362736102886 -122.27343911927473
1309 1309 1309 059 225900800 1524 Oxford St A 1524 OXFORD ST A 1524 OXFORD ST 1524.0 OXFORD ST A   Berkeley 94709 37.87948405723301 -122.26729184986912
1311 1311 1311 059 226701900 1935 Cedar St A 1935 CEDAR ST A 1935 CEDAR ST 1935.0 CEDAR ST A   Berkeley 94709 37.87823100161144 -122.27206499243574
1326 1326 1326 058 217603500 2015 Delaware St 3 2015 DELAWARE ST 3 2015 DELAWARE ST 2015.0 DELAWARE ST 3   Berkeley 94709 37.87483550493303 -122.27043055808196
1344 1344 1344 059 225900900 1528 Oxford St 9 1528 OXFORD ST 9 1528 OXFORD ST 1528.0 OXFORD ST 9   Berkeley 94709 37.87932037782597 -122.267274885185
1353 1353 1353 058 218100800 1742 Spruce St 204 1742 SPRUCE ST 204 1742 SPRUCE ST 1742.0 SPRUCE ST 204   Berkeley 94709 37.876022818822584 -122.26577543527904
1433 1433 1433 059 226801901 1909 Cedar St 311 1909 CEDAR ST 311 1909 CEDAR ST 1909.0 CEDAR ST 311   Berkeley 94709 37.87814158322639 -122.27329478965298
1452 1452 1452 058 217501200 2025 Francisco St 6 2025 FRANCISCO ST 6 2025 FRANCISCO ST 2025.0 FRANCISCO ST 6   Berkeley 94709 37.87580127158568 -122.27008196324267
1484 1484 1484 058 218201901 1862 Arch St 1862 ARCH ST 1862 ARCH ST 1862.0 ARCH ST     Berkeley 94709 37.87509836289433 -122.26434499934314
1543 1543 1543 058 218101200 1786 Spruce St 305 1786 SPRUCE ST 305 1786 SPRUCE ST 1786.0 SPRUCE ST 305   Berkeley 94709 37.875334261975226 -122.265786917545

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