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,600 rows where zipcode = 94705

✎ View and edit SQL

This data as json, CSV (advanced)

street_name >30

street_type 9

zipcode 1

  • 94705 · 6,600 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
2 2 2 053 169302100 2823 Regent St 2823 REGENT ST 2823 REGENT ST 2823.0 REGENT ST     Berkeley 94705 37.85894520458626 -122.25658232100312
5 5 5 054 170901900 2793 Benvenue Ave 4 2793 BENVENUE AVE 4 2793 BENVENUE AV 2793.0 BENVENUE AV 4   Berkeley 94705 37.86022211620459 -122.2543164419715
10 10 10 064 425001100 145 Hillcrest Rd 145 HILLCREST RD 145 HILLCREST RD 145.0 HILLCREST RD     Berkeley 94705 37.853069712308425 -122.24551551058904
13 13 13 054 171400300 2706 Telegraph Ave Front 2706 TELEGRAPH AVE FRONT 2706 TELEGRAPH AV 2706.0 TELEGRAPH AV FRONT   Berkeley 94705 37.86119392760136 -122.25934374667808
14 14 14 064 423901200 3027 Claremont Ave 3027 CLAREMONT AVE 3027 CLAREMONT AV 3027.0 CLAREMONT AV     Berkeley 94705 37.85486984834304 -122.24748219942713
24 24 24 052 155700500 2311 Woolsey St D 2311 WOOLSEY ST D 2311 WOOLSEY ST 2311.0 WOOLSEY ST D   Berkeley 94705 37.853073541808456 -122.26134864176348
27 27 27 052 155701400 2314 Prince St C 2314 PRINCE ST C 2314 PRINCE ST 2314.0 PRINCE ST C   Berkeley 94705 37.85347146826686 -122.26118578888055
40 40 40 052 156902000 2925 Hillegass Ave 2925 HILLEGASS AVE 2925 HILLEGASS AV 2925.0 HILLEGASS AV     Berkeley 94705 37.85726900739488 -122.25521665090425
49 49 49 052 157300900 2631 Webster St 2631 WEBSTER ST 2631 WEBSTER ST 2631.0 WEBSTER ST     Berkeley 94705 37.856236198329135 -122.25370512135268
55 55 55 052 157403700 3009 Dana St D 3009 DANA ST D 3009 DANA ST 3009.0 DANA ST D   Berkeley 94705 37.85498171317734 -122.25837304694502
63 63 63 052 158401600 3042 Fulton St C 3042 FULTON ST C 3042 FULTON ST 3042.0 FULTON ST C   Berkeley 94705 37.85405530514662 -122.26350854294776
84 84 84 052 158403200 3021 Wheeler St 3021 WHEELER ST 3021 WHEELER ST 3021.0 WHEELER ST     Berkeley 94705 37.85462077193717 -122.26407099252022
88 88 88 052 156103600 3005 Hillegass Ave 3005 HILLEGASS AVE 3005 HILLEGASS AV 3005.0 HILLEGASS AV     Berkeley 94705 37.85560371476175 -122.25469746778914
118 118 118 053 169002200 2318 Oregon St 2318 OREGON ST 2318 OREGON ST 2318.0 OREGON ST     Berkeley 94705 37.85814834757806 -122.26076408195696
120 120 120 054 170901300 2740 College Ave 307 2740 COLLEGE AVE 307 2740 COLLEGE AV 2740.0 COLLEGE AV 307   Berkeley 94705 37.860379502512984 -122.25374248318364
121 121 121 016 142202000 6699 Telegraph Ave 6699 TELEGRAPH AVE 6699 TELEGRAPH AV 6699.0 TELEGRAPH AV     Berkeley 94705 37.85277945704617 -122.26056175350722
133 133 133 052 155500500 2137 Woolsey St 2137 WOOLSEY ST 2137 WOOLSEY ST 2137.0 WOOLSEY ST     Berkeley 94705 37.852798855712294 -122.26458289119668
137 137 137 054 170802500 2736 Derby St 2 2736 DERBY ST 2 2736 DERBY ST 2736.0 DERBY ST 2   Berkeley 94705 37.8619878205094 -122.25179007755862
154 154 154 052 156600600 2839 Ashby Ave 2839 ASHBY AVE 2839 ASHBY AV 2839.0 ASHBY AV     Berkeley 94705 37.858018473299616 -122.24873875655832
156 156 156 055 184501800 2671 Derby St 5 2671 DERBY ST 5 2671 DERBY ST 2671.0 DERBY ST 5   Berkeley 94705 37.8619127836889 -122.25430614368508
157 157 157 048H769000300 2951 Derby St 119 2951 DERBY ST 119 2951 DERBY ST 2951.0 DERBY ST 119   Berkeley 94705 37.86316583247865 -122.24734899723678
196 196 196 016 141300100 2428 Woolsey St 2428 WOOLSEY ST 2428 WOOLSEY ST 2428.0 WOOLSEY ST     Berkeley 94705 37.85318664992885 -122.25699150271672
197 197 197 055 183401100 2327 Derby St A 2327 DERBY ST A 2327 DERBY ST 2327.0 DERBY ST A   Berkeley 94705 37.86140338901128 -122.2610172550518
205 205 205 053 168502300 2813 Shattuck Ave 10 2813 SHATTUCK AVE 10 2813 SHATTUCK AV 2813.0 SHATTUCK AV 10   Berkeley 94705 37.858182112086915 -122.26651589949978
212 212 212 048H769000400 3001 Derby St I 3001 DERBY ST I 3001 DERBY ST 3001.0 DERBY ST I   Berkeley 94705 37.8649044789697 -122.2473520973228
231 231 231 054 170801700 2704 Derby St 31 2704 DERBY ST 31 2704 DERBY ST 2704.0 DERBY ST 31   Berkeley 94705 37.861968661138334 -122.25323432419373
242 242 242 054 171400800 2407 Ward St 2407 WARD ST 2407 WARD ST 2407.0 WARD ST     Berkeley 94705 37.860568705074975 -122.25940940184726
262 262 262 052 156605700 2973 Piedmont Ave 2973 PIEDMONT AVE 2973 PIEDMONT AV 2973.0 PIEDMONT AV     Berkeley 94705 37.85608423050061 -122.25023983780484
265 265 265 053 169201401 2808 Regent St A 2808 REGENT ST A 2808 REGENT ST 2808.0 REGENT ST A   Berkeley 94705 37.85927015847334 -122.25731762080926
266 266 266 054 171702000 2208 Ward St Upper 2208 WARD ST UPPER 2208 WARD ST 2208.0 WARD ST UPPER   Berkeley 94705 37.85959237398891 -122.26367218185658
278 278 278 054 170700500 2763 Garber St 1 2763 GARBER ST 1 2763 GARBER ST 2763.0 GARBER ST 1   Berkeley 94705 37.860993778388185 -122.25146255809425
287 287 287 052 158102300 2907 Fulton St 2907 FULTON ST 2907 FULTON ST 2907.0 FULTON ST     Berkeley 94705 37.85686175904216 -122.26336561469786
288 288 288 064 422300600 163 Alvarado Rd 163 ALVARADO RD 163 ALVARADO RD 163.0 ALVARADO RD     Berkeley 94705 37.85669970820088 -122.23772215837536
293 293 293 053 169001400 2305 Russell St 2305 RUSSELL ST 2305 RUSSELL ST 2305.0 RUSSELL ST     Berkeley 94705 37.857646958476025 -122.26125189949558
298 298 298 052 157406500 3016 Bateman St 3016 BATEMAN ST 3016 BATEMAN ST 3016.0 BATEMAN ST     Berkeley 94705 37.85510987918957 -122.25596064909728
303 303 303 053 169900200 2752 Piedmont Ave 2752 PIEDMONT AVE 2752 PIEDMONT AV 2752.0 PIEDMONT AV     Berkeley 94705 37.86036988963996 -122.25125121415228
305 305 305 064 423700600 45 Hazel Rd 45 HAZEL RD 45 HAZEL RD 45.0 HAZEL RD     Berkeley 94705 37.856657241768566 -122.24534522235054
310 310 310 054 170207800 2808 Claremont Blvd 2808 CLAREMONT BLVD 2808 CLAREMONT BL 2808.0 CLAREMONT BL     Berkeley 94705 37.860358343410326 -122.2458004112814
313 313 313 055 182700700 2227 Derby St 2 2227 DERBY ST 2 2227 DERBY ST 2227.0 DERBY ST 2   Berkeley 94705 37.86110362612522 -122.26325594387642
334 334 334 064 425204000 162 Hillcrest Rd 162 HILLCREST RD 162 HILLCREST RD 162.0 HILLCREST RD     Berkeley 94705 37.85253752619113 -122.245056896382
341 341 341 052 141002001 3110 College Ave 3 3110 COLLEGE AVE 3 3110 COLLEGE AV 3110.0 COLLEGE AV 3   Berkeley 94705 37.85336253265811 -122.2529997659882
342 342 342 053 158901801 2955 Shattuck Ave 2 2955 SHATTUCK AVE 2 2955 SHATTUCK AV 2955.0 SHATTUCK AV 2   Berkeley 94705 37.85577704614729 -122.26623093862028
374 374 374 054 170701300 2736 Forest Ave 2736 FOREST AVE 2736 FOREST AV 2736.0 FOREST AV     Berkeley 94705 37.86126188076329 -122.25169758881358
382 382 382 064 422601200 1 Alvarado Rd 1 ALVARADO RD 1 ALVARADO RD 1.0 ALVARADO RD     Berkeley 94705 37.85580946412616 -122.23975189457332
390 390 390 053 169501000 2828 College Ave 17 2828 COLLEGE AVE 17 2828 COLLEGE AV 2828.0 COLLEGE AV 17   Berkeley 94705 37.85884710152536 -122.25358065078689
394 394 394 064 423202402 115 El Camino Real 115 EL CAMINO REAL 115 EL CAMINO REAL 115.0 EL CAMINO REAL       Berkeley 94705 37.85401461254119 -122.2401350502965
398 398 398 052 155900500 3090 Regent St 3090 REGENT ST 3090 REGENT ST 3090.0 REGENT ST     Berkeley 94705 37.85364126174964 -122.2563641435768
403 403 403 052 156800900 2942 College Ave 2942 COLLEGE AVE 2942 COLLEGE AV 2942.0 COLLEGE AV     Berkeley 94705 37.857443359739634 -122.25346690790224
407 407 407 054 170202300 2732 Claremont Blvd 2732 CLAREMONT BLVD 2732 CLAREMONT BL 2732.0 CLAREMONT BL     Berkeley 94705 37.86127776301685 -122.24728920267653
409 409 409 052 157307200 3017 Telegraph Ave 320 3017 TELEGRAPH AVE 320 3017 TELEGRAPH AV 3017.0 TELEGRAPH AV 320   Berkeley 94705 37.8555430179335 -122.2593627954537
413 413 413 052 157701100 2315 Webster St C 2315 WEBSTER ST C 2315 WEBSTER ST 2315.0 WEBSTER ST C   Berkeley 94705 37.85525590670417 -122.2615728558685
433 433 433 054 171101100 2732 Hillegass Ave 2732 HILLEGASS AVE 2732 HILLEGASS AV 2732.0 HILLEGASS AV     Berkeley 94705 37.86036898679294 -122.25622117939427
439 439 439 064 422201901 154 Vicente Rd 154 VICENTE RD 154 VICENTE RD 154.0 VICENTE RD     Berkeley 94705 37.8573764917661 -122.23493910216668
448 448 448 052 155601000 2227 Woolsey St 2227 WOOLSEY ST 2227 WOOLSEY ST 2227.0 WOOLSEY ST     Berkeley 94705 37.85289759100629 -122.26271630432568
469 469 469 048H769000300 2951 Derby St 316 2951 DERBY ST 316 2951 DERBY ST 2951.0 DERBY ST 316   Berkeley 94705 37.86316583247865 -122.24734899723678
483 483 483 064 423500501 2932 Domingo Ave 2932 DOMINGO AVE 2932 DOMINGO AV 2932.0 DOMINGO AV     Berkeley 94705 37.858318606193954 -122.24416136587526
484 484 484 053 168802600 2218 Stuart St 2218 STUART ST 2218 STUART ST 2218.0 STUART ST     Berkeley 94705 37.858747328774946 -122.26315661805376
486 486 486 052 157701500 3023 Deakin St 3023 DEAKIN ST 3023 DEAKIN ST 3023.0 DEAKIN ST     Berkeley 94705 37.85511655988268 -122.26205105784032
492 492 492 064 424701500 81 Hillcrest Rd 81 HILLCREST RD 81 HILLCREST RD 81.0 HILLCREST RD     Berkeley 94705 37.85236445956179 -122.24728212754536
497 497 497 052 157801200 2925 Ellsworth St 2925 ELLSWORTH ST 2925 ELLSWORTH ST 2925.0 ELLSWORTH ST     Berkeley 94705 37.85653356738308 -122.2610644866728
507 507 507 053 168900200 2818 Telegraph Ave 35 2818 TELEGRAPH AVE 35 2818 TELEGRAPH AV 2818.0 TELEGRAPH AV 35   Berkeley 94705 37.85911406912359 -122.25969511371832
516 516 516 052 157600800 3042 Halcyon Ct 3042 HALCYON CT 3042 HALCYON CT 3042.0 HALCYON CT     Berkeley 94705 37.854349793368115 -122.26140754519496
525 525 525 052 155501700 3101 Shattuck Ave 3101 SHATTUCK AVE 3101 SHATTUCK AV 3101.0 SHATTUCK AV     Berkeley 94705 37.85298716486482 -122.265906334189
543 543 543 052 156309600 3105 College Ave 3105 COLLEGE AVE 3105 COLLEGE AV 3105.0 COLLEGE AV     Berkeley 94705 37.853543916957506 -122.25238310039344
553 553 553 052 156316600 3151 Eton Ave 4 3151 ETON AVE 4 3151 ETON AV 3151.0 ETON AV 4   Berkeley 94705 37.852621984289385 -122.25006285172756
578 578 578 053 168800700 2243 Oregon St 2243 OREGON ST 2243 OREGON ST 2243.0 OREGON ST     Berkeley 94705 37.85847775478782 -122.26229711987136
605 605 605 052 158200700 2910 Fulton St 1 2910 FULTON ST 1 2910 FULTON ST 2910.0 FULTON ST 1   Berkeley 94705 37.85663235370708 -122.26398721743344
612 612 612 048H769000300 2951 Derby St B100 2951 DERBY ST B100 2951 DERBY ST 2951.0 DERBY ST B100   Berkeley 94705 37.86316583247865 -122.24734899723678
615 615 615 054 170902500 2717 Benvenue Ave 2717 BENVENUE AVE 2717 BENVENUE AV 2717.0 BENVENUE AV     Berkeley 94705 37.861041755809055 -122.25431853953768
620 620 620 052 157310700 2942 Hillegass Ave 2942 HILLEGASS AVE 2942 HILLEGASS AV 2942.0 HILLEGASS AV     Berkeley 94705 37.85644596888259 -122.25564324017142
624 624 624 053 169701200 2731 Russell St 2731 RUSSELL ST 2731 RUSSELL ST 2731.0 RUSSELL ST     Berkeley 94705 37.85883333654645 -122.2516592747684
634 634 634 048H769000300 2951 Derby St 331 2951 DERBY ST 331 2951 DERBY ST 2951.0 DERBY ST 331   Berkeley 94705 37.86316583247865 -122.24734899723678
637 637 637 053 168800700 2243 Oregon St 1 2243 OREGON ST 1 2243 OREGON ST 2243.0 OREGON ST 1   Berkeley 94705 37.85847775478782 -122.26229711987136
640 640 640 053 169002801 2850 Telegraph Ave 414 2850 TELEGRAPH AVE 414 2850 TELEGRAPH AV 2850.0 TELEGRAPH AV 414   Berkeley 94705 37.85832331914373 -122.25979916917092
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
651 651 651 052 158402600 3049 Wheeler St 3049 WHEELER ST 3049 WHEELER ST 3049.0 WHEELER ST     Berkeley 94705 37.853847957110496 -122.2639071335242
659 659 659 053 170101000 2834 Garber St 2834 GARBER ST 2834 GARBER ST 2834.0 GARBER ST     Berkeley 94705 37.86066620796779 -122.24946965461956
674 674 674 054 170501000 2828 Forest Ave 2 2828 FOREST AVE 2 2828 FOREST AV 2828.0 FOREST AV 2   Berkeley 94705 37.86136700257997 -122.24962795753558
688 688 688 052 157405908 3001 Colby St 3001 COLBY ST 3001 COLBY ST 3001.0 COLBY ST     Berkeley 94705 37.85507943908144 -122.25706633417651
689 689 689 054 171903300 2708 Walker St 4 2708 WALKER ST 4 2708 WALKER ST 2708.0 WALKER ST 4   Berkeley 94705 37.859977082772794 -122.26630612132134
698 698 698 053 169600300 2712 Stuart St 2712 STUART ST 2712 STUART ST 2712.0 STUART ST     Berkeley 94705 37.85970273730018 -122.25264731737636
705 705 705 053 158700600 3020 Wheeler St 3020 WHEELER ST 3020 WHEELER ST 3020.0 WHEELER ST     Berkeley 94705 37.85490324410926 -122.26469442153076
718 718 718 054 171000200 2608 Derby St 2608 DERBY ST 2608 DERBY ST 2608.0 DERBY ST     Berkeley 94705 37.86151483258487 -122.25545307580892
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
732 732 732 054 171903300 2708 Walker St 7 2708 WALKER ST 7 2708 WALKER ST 2708.0 WALKER ST 7   Berkeley 94705 37.859977082772794 -122.26630612132134
734 734 734 052 156511300 2932 Pine Ave 2932 PINE AVE 2932 PINE AV 2932.0 PINE AV     Berkeley 94705 37.85741007293114 -122.24854935037392
752 752 752 053 158600200 2141 Essex St 2141 ESSEX ST 2141 ESSEX ST 2141.0 ESSEX ST     Berkeley 94705 37.85428556113363 -122.26447707863932
760 760 760 064 423101200 24 Vicente Rd 24 VICENTE RD 24 VICENTE RD 24.0 VICENTE RD     Berkeley 94705 37.854064726626014 -122.23466218390394
761 761 761 053 169200100 2803 Telegraph Ave A 2803 TELEGRAPH AVE A 2803 TELEGRAPH AV 2803.0 TELEGRAPH AV A   Berkeley 94705 37.85943615907738 -122.25884453401008
766 766 766 052 158001400 2235 Ashby Ave 2 2235 ASHBY AVE 2 2235 ASHBY AV 2235.0 ASHBY AV 2   Berkeley 94705 37.856155831175734 -122.26186611987616
771 771 771 054 171500500 2718 Dana St 5 2718 DANA ST 5 2718 DANA ST 2718.0 DANA ST 5   Berkeley 94705 37.860479953202535 -122.26012316993436
777 777 777 053 169901700 2751 College Ave 2751 COLLEGE AVE 2751 COLLEGE AV 2751.0 COLLEGE AV     Berkeley 94705 37.860191289549746 -122.25316459516476
791 791 791 053 168502300 2813 Shattuck Ave 7 2813 SHATTUCK AVE 7 2813 SHATTUCK AV 2813.0 SHATTUCK AV 7   Berkeley 94705 37.858182112086915 -122.26651589949978
795 795 795 048H769000300 2951 Derby St 314 2951 DERBY ST 314 2951 DERBY ST 2951.0 DERBY ST 314   Berkeley 94705 37.86316583247865 -122.24734899723678
800 800 800 053 168902100 2807 Ellsworth St 2807 ELLSWORTH ST 2807 ELLSWORTH ST 2807.0 ELLSWORTH ST     Berkeley 94705 37.858846832722456 -122.2615239138552
803 803 803 064 429503300 9 Eton Ct 9 ETON CT 9 ETON CT 9.0 ETON CT     Berkeley 94705 37.85184917262645 -122.2493830354666
808 808 808 052 157102600 2917 Florence St A 2917 FLORENCE ST A 2917 FLORENCE ST 2917.0 FLORENCE ST A   Berkeley 94705 37.85720222082789 -122.25797703902504
811 811 811 053 159300200 3024 Shattuck Ave 3024 SHATTUCK AVE 3024 SHATTUCK AV 3024.0 SHATTUCK AV     Berkeley 94705 37.85421051079756 -122.2666586642563
818 818 818 064 423600300 3020 Ashby Ave 3020 ASHBY AVE 3020 ASHBY AV 3020.0 ASHBY AV     Berkeley 94705 37.857805734744 -122.24442642727456
836 836 836 054 172002600 2136 Ward St 2136 WARD ST 2136 WARD ST 2136.0 WARD ST     Berkeley 94705 37.85938561955557 -122.2652869287326

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