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

533 rows where street_name = "STUART" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 2

street_type 1

  • ST · 533 ✖

street_name 1

  • STUART · 533 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
222 222 222 053 167700600 1816 Stuart St 1816 STUART ST 1816 STUART ST 1816.0 STUART ST     Berkeley 94703 37.85759602905598 -122.27225983522423
421 421 421 054 173000400 1645 Stuart St 1645 STUART ST 1645 STUART ST 1645.0 STUART ST     Berkeley 94703 37.8576471166397 -122.27563366129304
484 484 484 053 168802600 2218 Stuart St 2218 STUART ST 2218 STUART ST 2218.0 STUART ST     Berkeley 94705 37.858747328774946 -122.26315661805376
576 576 576 053 167503600 1722 Stuart St B 1722 STUART ST B 1722 STUART ST 1722.0 STUART ST B   Berkeley 94703 37.85734356239292 -122.2742301325948
641 641 641 054 171101400 2525 Stuart St 303 2525 STUART ST 303 2525 STUART ST 2525.0 STUART ST 303   Berkeley 94705 37.85997577636822 -122.25617623847724
654 654 654 053 168100200 2012 Stuart St B 2012 STUART ST B 2012 STUART ST 2012.0 STUART ST B   Berkeley 94703 37.858007540912645 -122.26873851836224
685 685 685 054 173001100 1617 Stuart St 1617 STUART ST 1617 STUART ST 1617.0 STUART ST     Berkeley 94703 37.85754592446426 -122.2768074153146
698 698 698 053 169600300 2712 Stuart St 2712 STUART ST 2712 STUART ST 2712.0 STUART ST     Berkeley 94705 37.85970273730018 -122.25264731737636
702 702 702 053 167400101 1640 Stuart St 1640 STUART ST 1640 STUART ST 1640.0 STUART ST     Berkeley 94703 37.85716067955841 -122.27560208820572
731 731 731 054 171701200 2217 Stuart St A 2217 STUART ST A 2217 STUART ST 2217.0 STUART ST A   Berkeley 94705 37.85924744936591 -122.26345349328884
812 812 812 054 172601000 1819 Stuart St 1819 STUART ST 1819 STUART ST 1819.0 STUART ST     Berkeley 94703 37.85812244224716 -122.27236504860528
983 983 983 053 170105700 2828 Stuart St 2828 STUART ST 2828 STUART ST 2828.0 STUART ST     Berkeley 94705 37.8600756346912 -122.249687826656
996 996 996 054 172004000 2115 Stuart St 1 2115 STUART ST 1 2115 STUART ST 2115.0 STUART ST 1   Berkeley 94705 37.85890378983485 -122.26613901311892
1080 1080 1080 054 173301901 1501 Stuart St 3 1501 STUART ST 3 1501 STUART ST 1501.0 STUART ST 3   Berkeley 94703 37.857223377999546 -122.27954181607257
1139 1139 1139 053 168803100 2234 Stuart St 2234 STUART ST 2234 STUART ST 2234.0 STUART ST     Berkeley 94705 37.85882685548736 -122.26248558641798
1160 1160 1160 053 168503500 2140 Stuart St B 2140 STUART ST B 2140 STUART ST 2140.0 STUART ST B   Berkeley 94705 37.858507560845496 -122.26502010394036
1200 1200 1200 053 167402200 1612 Stuart St 1612 STUART ST 1612 STUART ST 1612.0 STUART ST     Berkeley 94703 37.8569990159211 -122.27686877384176
1701 1701 1701 053 167402100 1610 Stuart St 1610 STUART ST 1610 STUART ST 1610.0 STUART ST     Berkeley 94703 37.85712967005287 -122.27706066476624
1763 1763 1763 053 168802300 2206 Stuart St 2206 STUART ST 2206 STUART ST 2206.0 STUART ST     Berkeley 94705 37.85862517284267 -122.26376349201192
1803 1803 1803 054 173000800 1631 Stuart St C 1631 STUART ST C 1631 STUART ST 1631.0 STUART ST C   Berkeley 94703 37.85760913749643 -122.27632212473686
1964 1964 1964 054 172501000 1923 Stuart St 1923 STUART ST 1923 STUART ST 1923.0 STUART ST     Berkeley 94703 37.85834271564179 -122.27041288911865
2063 2063 2063 054 171001500 2615 Stuart St 5 2615 STUART ST 5 2615 STUART ST 2615.0 STUART ST 5   Berkeley 94705 37.86010272942424 -122.25514772496912
2085 2085 2085 053 168802800 2224 Stuart St 2224 STUART ST 2224 STUART ST 2224.0 STUART ST     Berkeley 94705 37.858779244721894 -122.26287680991074
2478 2478 2478 053 168903200 2348 Stuart St 2348 STUART ST 2348 STUART ST 2348.0 STUART ST     Berkeley 94705 37.859301206086485 -122.25969664085432
2603 2603 2603 054 171101400 2525 Stuart St 301 2525 STUART ST 301 2525 STUART ST 2525.0 STUART ST 301   Berkeley 94705 37.85997577636822 -122.25617623847724
2663 2663 2663 053 167503203 1730 Stuart St C 1730 STUART ST C 1730 STUART ST 1730.0 STUART ST C   Berkeley 94703 37.85738491347863 -122.27392288630972
2733 2733 2733 054 172500800 1931 Stuart St 1931 STUART ST 1931 STUART ST 1931.0 STUART ST     Berkeley 94703 37.85837937520773 -122.2701210660087
2745 2745 2745 053 169200600 2422 Stuart St 2422 STUART ST 2422 STUART ST 2422.0 STUART ST     Berkeley 94705 37.85941369683552 -122.25805281012263
2760 2760 2760 053 169300200 2510 Stuart St 2510 STUART ST 2510 STUART ST 2510.0 STUART ST     Berkeley 94705 37.859579141784955 -122.25646304000476
2872 2872 2872 054 172001801 2109 Stuart St 2109 STUART ST 2109 STUART ST 2109.0 STUART ST     Berkeley 94705 37.8588878297623 -122.2662771425686
2953 2953 2953 053 169901400 2711 Stuart St 2711 STUART ST 2711 STUART ST 2711.0 STUART ST     Berkeley 94705 37.86012150913301 -122.25282439957338
3077 3077 3077 053 169200700 2424 Stuart St 2424 STUART ST 2424 STUART ST 2424.0 STUART ST     Berkeley 94705 37.85942797022892 -122.25792681511582
3126 3126 3126 053 169200100 2404 Stuart St 2404 STUART ST 2404 STUART ST 2404.0 STUART ST     Berkeley 94705 37.85943615907738 -122.25884453401008
3215 3215 3215 054 172000900 2145 Stuart St A 2145 STUART ST A 2145 STUART ST 2145.0 STUART ST A   Berkeley 94705 37.8590326646518 -122.26513128662648
3222 3222 3222 053 167402000 1600 Stuart St D 1600 STUART ST D 1600 STUART ST 1600.0 STUART ST D   Berkeley 94703 37.857097525010175 -122.27732061564993
3276 3276 3276 054 171101400 2525 Stuart St 203 2525 STUART ST 203 2525 STUART ST 2525.0 STUART ST 203   Berkeley 94705 37.85997577636822 -122.25617623847724
3434 3434 3434 053 169200300 2412 Stuart St 2 2412 STUART ST 2 2412 STUART ST 2412.0 STUART ST 2   Berkeley 94705 37.85936597155265 -122.25841977461111
3452 3452 3452 053 170106600 2803 Stuart St 2803 STUART ST 2803 STUART ST 2803.0 STUART ST     Berkeley 94705 37.860214650857344 -122.2508301252696
3489 3489 3489 054 173000900 1629 Stuart St 1629 STUART ST 1629 STUART ST 1629.0 STUART ST     Berkeley 94703 37.85759068978791 -122.27646722062156
3718 3718 3718 053 168002500 1914 Stuart St 1914 STUART ST 1914 STUART ST 1914.0 STUART ST     Berkeley 94703 37.857754084123385 -122.27068552690903
3894 3894 3894 054 172901600 1715 Stuart St 1715 STUART ST 1715 STUART ST 1715.0 STUART ST     Berkeley 94703 37.8578105576607 -122.27474639528688
4077 4077 4077 053 169900600 2745 Stuart St 2 2745 STUART ST 2 2745 STUART ST 2745.0 STUART ST 2   Berkeley 94705 37.8602307170269 -122.25143065802018
4106 4106 4106 054 172500600 1935 Stuart St 1935 STUART ST 1935 STUART ST 1935.0 STUART ST     Berkeley 94703 37.85841306372134 -122.26986287312803
4116 4116 4116 053 167402300 1616 Stuart St 1616 STUART ST 1616 STUART ST 1616.0 STUART ST     Berkeley 94703 37.85701320963566 -122.27674958536986
4119 4119 4119 054 171101500 2509 Stuart St 2509 STUART ST 2509 STUART ST 2509.0 STUART ST     Berkeley 94705 37.860009118756594 -122.25653306727442
4379 4379 4379 053 167700100 1800 Stuart St 1800 STUART ST 1800 STUART ST 1800.0 STUART ST     Berkeley 94703 37.8575282164931 -122.27294763840638
4406 4406 4406 053 168003300 1936 Stuart St 5 1936 STUART ST 5 1936 STUART ST 1936.0 STUART ST 5   Berkeley 94703 37.85788897682349 -122.26966065427274
4421 4421 4421 053 169400400 2620 Stuart St 1 2620 STUART ST 1 2620 STUART ST 2620.0 STUART ST 1   Berkeley 94705 37.85974884814891 -122.25481192213952
4435 4435 4435 053 169200700 2426 Stuart St 2426 STUART ST 2426 STUART ST 2426.0 STUART ST     Berkeley 94705 37.85942797022892 -122.25792681511582
4675 4675 4675 053 167102200 1508 Stuart St 1508 STUART ST 1508 STUART ST 1508.0 STUART ST     Berkeley 94703 37.85671711635289 -122.27923601158354
4921 4921 4921 053 169200900 2432 Stuart St 2432 STUART ST 2432 STUART ST 2432.0 STUART ST     Berkeley 94705 37.859447479914145 -122.25764911981037
4929 4929 4929 053 167503300 1736 Stuart St B 1736 STUART ST B 1736 STUART ST 1736.0 STUART ST B   Berkeley 94703 37.85741312344238 -122.2737156575501
5082 5082 5082 054 173301800 1511 Stuart St E 1511 STUART ST E 1511 STUART ST 1511.0 STUART ST E   Berkeley 94703 37.85724779987906 -122.27935440235149
5184 5184 5184 053 167502800 1714 Stuart St A 1714 STUART ST A 1714 STUART ST 1714.0 STUART ST A   Berkeley 94703 37.85727657233654 -122.2747085043482
5223 5223 5223 053 169600400 2716 Stuart St 2716 STUART ST 2716 STUART ST 2716.0 STUART ST     Berkeley 94705 37.85976551017631 -122.25247724563184
5349 5349 5349 053 167503500 1720 Stuart St 1720 STUART ST 1720 STUART ST 1720.0 STUART ST     Berkeley 94703 37.85732399611951 -122.2743553577454
5366 5366 5366 054 171101400 2525 Stuart St 503 2525 STUART ST 503 2525 STUART ST 2525.0 STUART ST 503   Berkeley 94705 37.85997577636822 -122.25617623847724
5394 5394 5394 053 167503203 1730 Stuart St D 1730 STUART ST D 1730 STUART ST 1730.0 STUART ST D   Berkeley 94703 37.85738491347863 -122.27392288630972
5434 5434 5434 053 167402400 1620 Stuart St 1620 STUART ST 1620 STUART ST 1620.0 STUART ST     Berkeley 94703 37.857028691363624 -122.27662180720722
5849 5849 5849 054 170901600 2645 Stuart St 2645 STUART ST 2645 STUART ST 2645.0 STUART ST     Berkeley 94705 37.86017053323553 -122.25390124244382
5851 5851 5851 053 167403400 1622 Stuart St B 1622 STUART ST B 1622 STUART ST 1622.0 STUART ST B   Berkeley 94703 37.85704656187527 -122.27648110318594
6021 6021 6021 054 173301800 1511 Stuart St A 1511 STUART ST A 1511 STUART ST 1511.0 STUART ST A   Berkeley 94703 37.85724779987906 -122.27935440235149
6277 6277 6277 054 171001500 2615 Stuart St 8 2615 STUART ST 8 2615 STUART ST 2615.0 STUART ST 8   Berkeley 94705 37.86010272942424 -122.25514772496912
6441 6441 6441 053 168502801 2114 Stuart St 2114 STUART ST 2114 STUART ST 2114.0 STUART ST     Berkeley 94705 37.85838466264361 -122.26597246905853
6575 6575 6575 053 167503400 1738 Stuart St A 1738 STUART ST A 1738 STUART ST 1738.0 STUART ST A   Berkeley 94703 37.85747546420395 -122.27357256401018
6612 6612 6612 053 167503203 1730 Stuart St H 1730 STUART ST H 1730 STUART ST 1730.0 STUART ST H   Berkeley 94703 37.85738491347863 -122.27392288630972
6678 6678 6678 054 172500900 1927 Stuart St 2 1927 STUART ST 2 1927 STUART ST 1927.0 STUART ST 2   Berkeley 94703 37.858363106499205 -122.27025486557868
6738 6738 6738 054 171701200 2215 Stuart St A 2215 STUART ST A 2215 STUART ST 2215.0 STUART ST A   Berkeley 94705 37.85924744936591 -122.26345349328884
6873 6873 6873 054 172201200 2001 Stuart St 2001 STUART ST 2001 STUART ST 2001.0 STUART ST     Berkeley 94703 37.858516199457945 -122.26907109534169
7198 7198 7198 054 171101500 2509 Stuart St 3 2509 STUART ST 3 2509 STUART ST 2509.0 STUART ST 3   Berkeley 94705 37.860009118756594 -122.25653306727442
7216 7216 7216 053 168502801 2110 Stuart St 2110 STUART ST 2110 STUART ST 2110.0 STUART ST     Berkeley 94705 37.85838466264361 -122.26597246905853
7225 7225 7225 054 171101400 2525 Stuart St 504 2525 STUART ST 504 2525 STUART ST 2525.0 STUART ST 504   Berkeley 94705 37.85997577636822 -122.25617623847724
7226 7226 7226 054 172201100 2005 Stuart St 2005 STUART ST 2005 STUART ST 2005.0 STUART ST     Berkeley 94703 37.858534026345005 -122.2689372544492
7251 7251 7251 053 167102500 1520 Stuart St 1520 STUART ST 1520 STUART ST 1520.0 STUART ST     Berkeley 94703 37.856770684127234 -122.27883019136574
7529 7529 7529 054 173301800 1511 Stuart St D 1511 STUART ST D 1511 STUART ST 1511.0 STUART ST D   Berkeley 94703 37.85724779987906 -122.27935440235149
7947 7947 7947 053 168502600 2108 Stuart St 5 2108 STUART ST 5 2108 STUART ST 2108.0 STUART ST 5   Berkeley 94705 37.85835148973975 -122.26622976721715
7987 7987 7987 054 172001200 2131 Stuart St 2131 STUART ST 2131 STUART ST 2131.0 STUART ST     Berkeley 94705 37.85897896589314 -122.26554920715114
8019 8019 8019 054 172201403 2015 Stuart St 2015 STUART ST 2015 STUART ST 2015.0 STUART ST     Berkeley 94703 37.85843085658958 -122.26864169794094
8144 8144 8144 053 169901600 2703 Stuart St 4 2703 STUART ST 4 2703 STUART ST 2703.0 STUART ST 4   Berkeley 94705 37.86003474469668 -122.25314797633196
8220 8220 8220 054 172501200 1917 Stuart St 1917 STUART ST 1917 STUART ST 1917.0 STUART ST     Berkeley 94703 37.8583102484204 -122.27066500220144
8274 8274 8274 053 168903102 2334 Stuart St 2334 STUART ST 2334 STUART ST 2334.0 STUART ST     Berkeley 94705 37.859121854449455 -122.26031688533718
8301 8301 8301 053 168002600 1916 Stuart St C 1916 STUART ST C 1916 STUART ST 1916.0 STUART ST C   Berkeley 94703 37.857768436565195 -122.27058275514898
8357 8357 8357 053 168902600 2314 Stuart St 2314 STUART ST 2314 STUART ST 2314.0 STUART ST     Berkeley 94705 37.859033381694104 -122.2610197945891
8386 8386 8386 054 173000701 1635 Stuart St 1635 STUART ST 1635 STUART ST 1635.0 STUART ST     Berkeley 94703 37.85782684209478 -122.2761893205002
8387 8387 8387 053 167503203 1730 Stuart St G 1730 STUART ST G 1730 STUART ST 1730.0 STUART ST G   Berkeley 94703 37.85738491347863 -122.27392288630972
8499 8499 8499 053 169900900 2727 Stuart St 2727 STUART ST 2727 STUART ST 2727.0 STUART ST     Berkeley 94705 37.860195381094734 -122.25195043941324
8546 8546 8546 053 167502600 1708 Stuart St 1708 STUART ST 1708 STUART ST 1708.0 STUART ST     Berkeley 94703 37.85728958863036 -122.27493303196528
8655 8655 8655 054 171101600 2503 Stuart St 2503 STUART ST 2503 STUART ST 2503.0 STUART ST     Berkeley 94705 37.85992737626037 -122.25678489020136
8721 8721 8721 053 169900600 2745 Stuart St 1 2745 STUART ST 1 2745 STUART ST 2745.0 STUART ST 1   Berkeley 94705 37.8602307170269 -122.25143065802018
8928 8928 8928 053 168003300 1936 Stuart St 1 1936 STUART ST 1 1936 STUART ST 1936.0 STUART ST 1   Berkeley 94703 37.85788897682349 -122.26966065427274
9031 9031 9031 053 167403100 1638 Stuart St E 1638 STUART ST E 1638 STUART ST 1638.0 STUART ST E   Berkeley 94703 37.85713503772469 -122.2758032901681
9138 9138 9138 053 167503202 1726 Stuart St 1726 STUART ST 1726 STUART ST 1726.0 STUART ST     Berkeley 94703 37.857360231347286 -122.27410163488162
9366 9366 9366 053 167503203 1730 Stuart St 1730 STUART ST 1730 STUART ST 1730.0 STUART ST     Berkeley 94703 37.85738491347863 -122.27392288630972
9483 9483 9483 053 168802500 2214 Stuart St 2214 STUART ST 2214 STUART ST 2214.0 STUART ST     Berkeley 94705 37.85872541527779 -122.26331558033316
9597 9597 9597 053 168903200 2346 Stuart St 2346 STUART ST 2346 STUART ST 2346.0 STUART ST     Berkeley 94705 37.859301206086485 -122.25969664085432
9602 9602 9602 054 171600400 2347 Stuart St 2347 STUART ST 2347 STUART ST 2347.0 STUART ST     Berkeley 94705 37.85970193657471 -122.25996689541424
9732 9732 9732 053 169901000 2723 Stuart St C 2723 STUART ST C 2723 STUART ST 2723.0 STUART ST C   Berkeley 94705 37.86018494903751 -122.25212508897246
9748 9748 9748 053 168502600 2108 Stuart St 3 2108 STUART ST 3 2108 STUART ST 2108.0 STUART ST 3   Berkeley 94705 37.85835148973975 -122.26622976721715
10160 10160 10160 053 168502801 2110 Stuart St D 2110 STUART ST D 2110 STUART ST 2110.0 STUART ST D   Berkeley 94705 37.85838466264361 -122.26597246905853
10409 10409 10409 054 172004000 2117 Stuart St 2117 STUART ST 2117 STUART ST 2117.0 STUART ST     Berkeley 94705 37.85890378983485 -122.26613901311892

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