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

282 rows where street_name = "STUART" and zipcode = 94705

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94705 · 282 ✖

street_type 1

street_name 1

  • STUART · 282 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
484 484 484 053 168802600 2218 Stuart St 2218 STUART ST 2218 STUART ST 2218.0 STUART ST     Berkeley 94705 37.858747328774946 -122.26315661805376
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
698 698 698 053 169600300 2712 Stuart St 2712 STUART ST 2712 STUART ST 2712.0 STUART ST     Berkeley 94705 37.85970273730018 -122.25264731737636
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
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
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
1763 1763 1763 053 168802300 2206 Stuart St 2206 STUART ST 2206 STUART ST 2206.0 STUART ST     Berkeley 94705 37.85862517284267 -122.26376349201192
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
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
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
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
4119 4119 4119 054 171101500 2509 Stuart St 2509 STUART ST 2509 STUART ST 2509.0 STUART ST     Berkeley 94705 37.860009118756594 -122.25653306727442
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
4921 4921 4921 053 169200900 2432 Stuart St 2432 STUART ST 2432 STUART ST 2432.0 STUART ST     Berkeley 94705 37.859447479914145 -122.25764911981037
5223 5223 5223 053 169600400 2716 Stuart St 2716 STUART ST 2716 STUART ST 2716.0 STUART ST     Berkeley 94705 37.85976551017631 -122.25247724563184
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
5849 5849 5849 054 170901600 2645 Stuart St 2645 STUART ST 2645 STUART ST 2645.0 STUART ST     Berkeley 94705 37.86017053323553 -122.25390124244382
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
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
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
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
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
8274 8274 8274 053 168903102 2334 Stuart St 2334 STUART ST 2334 STUART ST 2334.0 STUART ST     Berkeley 94705 37.859121854449455 -122.26031688533718
8357 8357 8357 053 168902600 2314 Stuart St 2314 STUART ST 2314 STUART ST 2314.0 STUART ST     Berkeley 94705 37.859033381694104 -122.2610197945891
8499 8499 8499 053 169900900 2727 Stuart St 2727 STUART ST 2727 STUART ST 2727.0 STUART ST     Berkeley 94705 37.860195381094734 -122.25195043941324
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
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
10438 10438 10438 054 171600500 2345 Stuart St 2345 STUART ST 2345 STUART ST 2345.0 STUART ST     Berkeley 94705 37.859685917099355 -122.26008775295595
10446 10446 10446 053 169400400 2620 Stuart St 2620 STUART ST 2620 STUART ST 2620.0 STUART ST     Berkeley 94705 37.85974884814891 -122.25481192213952
10530 10530 10530 053 168802500 2214 Stuart St A 2214 STUART ST A 2214 STUART ST 2214.0 STUART ST A   Berkeley 94705 37.85872541527779 -122.26331558033316
10638 10638 10638 054 171700300 2247 Stuart St 2247 STUART ST 2247 STUART ST 2247.0 STUART ST     Berkeley 94705 37.85941251595594 -122.26213132320927
10695 10695 10695 053 169800200 2804 Stuart St 2804 STUART ST 2804 STUART ST 2804.0 STUART ST     Berkeley 94705 37.85984989190735 -122.2506309445166
10732 10732 10732 054 171101400 2525 Stuart St 403 2525 STUART ST 403 2525 STUART ST 2525.0 STUART ST 403   Berkeley 94705 37.85997577636822 -122.25617623847724
10802 10802 10802 053 169901600 2703 Stuart St 5 2703 STUART ST 5 2703 STUART ST 2703.0 STUART ST 5   Berkeley 94705 37.86003474469668 -122.25314797633196
10880 10880 10880 053 169900600 2745 Stuart St 10 2745 STUART ST 10 2745 STUART ST 2745.0 STUART ST 10   Berkeley 94705 37.8602307170269 -122.25143065802018
11046 11046 11046 053 169200300 2412 Stuart St 1 2412 STUART ST 1 2412 STUART ST 2412.0 STUART ST 1   Berkeley 94705 37.85936597155265 -122.25841977461111
11189 11189 11189 054 171600600 2343 Stuart St 2343 STUART ST 2343 STUART ST 2343.0 STUART ST     Berkeley 94705 37.859669192641384 -122.26021295564868
11490 11490 11490 053 169900600 2745 Stuart St 8 2745 STUART ST 8 2745 STUART ST 2745.0 STUART ST 8   Berkeley 94705 37.8602307170269 -122.25143065802018
12159 12159 12159 054 171601500 2309 Stuart St A 2309 STUART ST A 2309 STUART ST 2309.0 STUART ST A   Berkeley 94705 37.85945515172697 -122.26145167583162
12223 12223 12223 053 169200200 2410 Stuart St B 2410 STUART ST B 2410 STUART ST 2410.0 STUART ST B   Berkeley 94705 37.859348723604676 -122.25855455334477
12431 12431 12431 053 169500400 2648 Stuart St 2648 STUART ST 2648 STUART ST 2648.0 STUART ST     Berkeley 94705 37.85981367988968 -122.25357408140722
12637 12637 12637 053 168502600 2108 Stuart St 2 2108 STUART ST 2 2108 STUART ST 2108.0 STUART ST 2   Berkeley 94705 37.85835148973975 -122.26622976721715
12783 12783 12783 053 168803200 2238 Stuart St 2238 STUART ST 2238 STUART ST 2238.0 STUART ST     Berkeley 94705 37.858845425585415 -122.26233314590752
12794 12794 12794 054 171700500 2239 Stuart St 2239 STUART ST 2239 STUART ST 2239.0 STUART ST     Berkeley 94705 37.8593707737994 -122.26246383101844
13041 13041 13041 053 169901000 2723 Stuart St B 2723 STUART ST B 2723 STUART ST 2723.0 STUART ST B   Berkeley 94705 37.86018494903751 -122.25212508897246
13565 13565 13565 053 168503100 2128 Stuart St 2128 STUART ST 2128 STUART ST 2128.0 STUART ST     Berkeley 94705 37.85844276483673 -122.2655243004616
13596 13596 13596 054 171601600 2307 Stuart St 2307 STUART ST 2307 STUART ST 2307.0 STUART ST     Berkeley 94705 37.85943817756524 -122.26158639797144
13638 13638 13638 053 168502600 2108 Stuart St 1 2108 STUART ST 1 2108 STUART ST 2108.0 STUART ST 1   Berkeley 94705 37.85835148973975 -122.26622976721715
13854 13854 13854 053 169900600 2745 Stuart St 7 2745 STUART ST 7 2745 STUART ST 2745.0 STUART ST 7   Berkeley 94705 37.8602307170269 -122.25143065802018
14259 14259 14259 054 171601100 2331 Stuart St 2331 STUART ST 2331 STUART ST 2331.0 STUART ST     Berkeley 94705 37.85959318109868 -122.26080535325605
14432 14432 14432 053 169400400 2620 Stuart St 4 2620 STUART ST 4 2620 STUART ST 2620.0 STUART ST 4   Berkeley 94705 37.85974884814891 -122.25481192213952
15103 15103 15103 054 171101400 2525 Stuart St 304 2525 STUART ST 304 2525 STUART ST 2525.0 STUART ST 304   Berkeley 94705 37.85997577636822 -122.25617623847724
15190 15190 15190 054 171601100 2333 Stuart St A 2333 STUART ST A 2333 STUART ST 2333.0 STUART ST A   Berkeley 94705 37.85959318109868 -122.26080535325605
15411 15411 15411 053 168502600 2108 Stuart St 4 2108 STUART ST 4 2108 STUART ST 2108.0 STUART ST 4   Berkeley 94705 37.85835148973975 -122.26622976721715
15437 15437 15437 054 170901600 2643 Stuart St 2643 STUART ST 2643 STUART ST 2643.0 STUART ST     Berkeley 94705 37.86017053323553 -122.25390124244382
15441 15441 15441 054 171600700 2341 Stuart St 2341 STUART ST 2341 STUART ST 2341.0 STUART ST     Berkeley 94705 37.8596522802324 -122.26033470611578
15545 15545 15545 054 171101600 2501 Stuart St 2501 STUART ST 2501 STUART ST 2501.0 STUART ST     Berkeley 94705 37.85992737626037 -122.25678489020136
15805 15805 15805 054 171101400 2525 Stuart St 404 2525 STUART ST 404 2525 STUART ST 2525.0 STUART ST 404   Berkeley 94705 37.85997577636822 -122.25617623847724
15824 15824 15824 054 170901500 2647 Stuart St 2647 STUART ST 2647 STUART ST 2647.0 STUART ST     Berkeley 94705 37.86017722694539 -122.25374547547186
16237 16237 16237 053 169200800 2428 Stuart St 2428 STUART ST 2428 STUART ST 2428.0 STUART ST     Berkeley 94705 37.85944040385944 -122.25779278467878
16292 16292 16292 054 171701100 2219 Stuart St 2219 STUART ST 2219 STUART ST 2219.0 STUART ST     Berkeley 94705 37.85926396185729 -122.26331276321643
16373 16373 16373 054 172001801 2111 Stuart St 2111 STUART ST 2111 STUART ST 2111.0 STUART ST     Berkeley 94705 37.8588878297623 -122.2662771425686
16460 16460 16460 053 169500200 2636 Stuart St 2636 STUART ST 2636 STUART ST 2636.0 STUART ST     Berkeley 94705 37.85978967447106 -122.25402818966482
16499 16499 16499 053 170106500 2805 Stuart St 2805 STUART ST 2805 STUART ST 2805.0 STUART ST     Berkeley 94705 37.86022380558856 -122.25068218082713
16878 16878 16878 054 171101400 2525 Stuart St 602 2525 STUART ST 602 2525 STUART ST 2525.0 STUART ST 602   Berkeley 94705 37.85997577636822 -122.25617623847724
17323 17323 17323 054 171700700 2231 Stuart St 2231 STUART ST 2231 STUART ST 2231.0 STUART ST     Berkeley 94705 37.859337350978365 -122.2627229473672
17375 17375 17375 053 169400200 2606 Stuart St 2606 STUART ST 2606 STUART ST 2606.0 STUART ST     Berkeley 94705 37.85968689867976 -122.25524441064314
17682 17682 17682 054 172001600 2119 Stuart St 2119 STUART ST 2119 STUART ST 2119.0 STUART ST     Berkeley 94705 37.8589186973891 -122.26601377629024
17810 17810 17810 053 169700200 2728 Stuart St 2728 STUART ST 2728 STUART ST 2728.0 STUART ST     Berkeley 94705 37.85974942617446 -122.25182294601656
17820 17820 17820 054 171600900 2337 Stuart St 2337 STUART ST 2337 STUART ST 2337.0 STUART ST     Berkeley 94705 37.85962708182803 -122.26054025682248
17950 17950 17950 053 169400400 2620 Stuart St 3 2620 STUART ST 3 2620 STUART ST 2620.0 STUART ST 3   Berkeley 94705 37.85974884814891 -122.25481192213952
18141 18141 18141 053 169901000 2723 Stuart St 2723 STUART ST 2723 STUART ST 2723.0 STUART ST     Berkeley 94705 37.86018494903751 -122.25212508897246
18248 18248 18248 053 169201100 2440 Stuart St 2440 STUART ST 2440 STUART ST 2440.0 STUART ST     Berkeley 94705 37.85956862382299 -122.2573817937582
18264 18264 18264 054 172001500 2121 Stuart St 2121 STUART ST 2121 STUART ST 2121.0 STUART ST     Berkeley 94705 37.85893537095199 -122.26588598465284
18331 18331 18331 053 169700400 2732 Stuart St 2732 STUART ST 2732 STUART ST 2732.0 STUART ST     Berkeley 94705 37.859787653155855 -122.25153275334884

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