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

62,226 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

street_name >30

street_type 16

zipcode 12

Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1 1 1 059 231000205 1080 Jones St Apt 106 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 106 APT Berkeley 94710 37.875857552605694 -122.29526674876428
2 2 2 053 169302100 2823 Regent St 2823 REGENT ST 2823 REGENT ST 2823.0 REGENT ST     Berkeley 94705 37.85894520458626 -122.25658232100312
3 3 3 063 314011500 1079 Creston Rd 1079 CRESTON RD 1079 CRESTON RD 1079.0 CRESTON RD     Berkeley 94708 37.89348404845872 -122.25700367039724
4 4 4 055 182001500 2605 Milvia St 2605 MILVIA ST 2605 MILVIA ST 2605.0 MILVIA ST     Berkeley 94704 37.86164004895787 -122.26941061539996
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
6 6 6 059 226101000 1467 Shattuck Ave 1467 SHATTUCK AVE 1467 SHATTUCK AV 1467.0 SHATTUCK AV     Berkeley 94709 37.88086633869915 -122.26894662836916
7 7 7 052 155200400 1924 Woolsey St 1924 WOOLSEY ST 1924 WOOLSEY ST 1924.0 WOOLSEY ST     Berkeley 94703 37.85185178785158 -122.2684793382331
8 8 8 053 160002800 2913 Harper St 2913 HARPER ST 2913 HARPER ST 2913.0 HARPER ST     Berkeley 94703 37.855467068807606 -122.27198809844408
9 9 9 055 183202000 2529 Ellsworth St 3 2529 ELLSWORTH ST 3 2529 ELLSWORTH ST 2529.0 ELLSWORTH ST 3   Berkeley 94704 37.863535204658334 -122.26252992007392
10 10 10 064 425001100 145 Hillcrest Rd 145 HILLCREST RD 145 HILLCREST RD 145.0 HILLCREST RD     Berkeley 94705 37.853069712308425 -122.24551551058904
11 11 11 055 183800201 2430 Dwight Way 102 2430 DWIGHT WAY 102 2430 DWIGHT WY 2430.0 DWIGHT WY 102   Berkeley 94704 37.86431751538991 -122.25900638616976
12 12 12 059 231000205 1080 Jones St Apt 512 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 512 APT Berkeley 94710 37.876038373846576 -122.29539666491728
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
15 15 15 052 145200200 3218 Idaho St 3218 IDAHO ST 3218 IDAHO ST 3218.0 IDAHO ST     Berkeley 94702 37.8491320149456 -122.281982332087
16 16 16 056 199601203 1414 University Ave 1414 UNIVERSITY AVE 1414 UNIVERSITY AV 1414.0 UNIVERSITY AV     Berkeley 94702 37.86948675482731 -122.28358104044192
17 17 17 063 295200200 30 Alta Rd 30 ALTA RD 30 ALTA RD 30.0 ALTA RD     Berkeley 94708 37.902526297842634 -122.27036099254636
18 18 18 055 183002100 2222 Dwight Way 3 2222 DWIGHT WAY 3 2222 DWIGHT WY 2222.0 DWIGHT WY 3   Berkeley 94704 37.8641122429479 -122.26413389165808
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
20 20 20 058 212803500 1644 San Pablo Ave A 1644 SAN PABLO AVE A 1644 SAN PABLO AV 1644.0 SAN PABLO AV A   Berkeley 94702 37.87397257310421 -122.2941110679479
21 21 21 063 296505500 663 Grizzly Peak Blvd 663 GRIZZLY PEAK BLVD 663 GRIZZLY PEAK BL 663.0 GRIZZLY PEAK BL     Berkeley 94708 37.90001301041502 -122.26535644216594
22 22 22 056 197300501 1040 University Ave 327 1040 UNIVERSITY AVE 327 1040 UNIVERSITY AV 1040.0 UNIVERSITY AV 327   Berkeley 94710 37.86854806864747 -122.29348350219549
23 23 23 055 189500500 2035 Channing Way 303 2035 CHANNING WAY 303 2035 CHANNING WY 2035.0 CHANNING WY 303   Berkeley 94704 37.86597060980446 -122.26833746011376
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
25 25 25 058 218203600 1729 Spruce St 1729 SPRUCE ST 1729 SPRUCE ST 1729.0 SPRUCE ST     Berkeley 94709 37.87652044749161 -122.26508568993928
26 26 26 056 199400503 1320 Addison St Unit C232 1320 ADDISON ST 1320 ADDISON ST 1320.0 ADDISON ST C232 UNIT Berkeley 94702 37.86831066712861 -122.28464976433882
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
28 28 28 057 206802100 1510 Hearst Ave 3 1510 HEARST AVE 3 1510 HEARST AV 1510.0 HEARST AV 3   Berkeley 94703 37.871979332917654 -122.28150346356524
29 29 29 055 184600101 2501 Benvenue Ave 30 2501 BENVENUE AVE 30 2501 BENVENUE AV 2501.0 BENVENUE AV 30   Berkeley 94704 37.8653038478608 -122.25491987717878
30 30 30 059 228301400 1421 Mcgee Ave B 1421 MCGEE AVE B 1421 MCGEE AV 1421.0 MCGEE AV B   Berkeley 94703 37.879495986894675 -122.27933884353074
31 31 31 054 174204900 2762 Mathews St 2762 MATHEWS ST 2762 MATHEWS ST 2762.0 MATHEWS ST     Berkeley 94702 37.85573149668548 -122.28609082644626
32 32 32 056 201000800 2112 Roosevelt Ave A 2112 ROOSEVELT AVE A 2112 ROOSEVELT AV 2112.0 ROOSEVELT AV A   Berkeley 94703 37.86957367691092 -122.27655582145805
33 33 33 055 191402700 2415 Sacramento St 2415 SACRAMENTO ST 2415 SACRAMENTO ST 2415.0 SACRAMENTO ST     Berkeley 94702 37.86349379177683 -122.28089092572915
34 34 34 059 229300106 1290 Hopkins St 9 1290 HOPKINS ST 9 1290 HOPKINS ST 1290.0 HOPKINS ST 9   Berkeley 94702 37.8775084403227 -122.28851462481325
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
36 36 36 061 257000700 1971 Hopkins St 1971 HOPKINS ST 1971 HOPKINS ST 1971.0 HOPKINS ST     Berkeley 94707 37.887872896105094 -122.27334417094248
37 37 37 055 190700700 2416 Roosevelt Ave 5 2416 ROOSEVELT AVE 5 2416 ROOSEVELT AV 2416.0 ROOSEVELT AV 5   Berkeley 94703 37.86411656476258 -122.2759929784235
38 38 38 052 154000600 1453 66th St 1453 66TH ST 1453 66TH ST 1453.0 66TH ST     Berkeley 94702 37.850494098299066 -122.27898201383526
39 39 39 062 286101200 1545 Thousand Oaks Blvd 1545 THOUSAND OAKS BLVD 1545 THOUSAND OAKS BL 1545.0 THOUSAND OAKS BL     Berkeley 94707 37.89679278792589 -122.28652091914304
40 40 40 052 156902000 2925 Hillegass Ave 2925 HILLEGASS AVE 2925 HILLEGASS AV 2925.0 HILLEGASS AV     Berkeley 94705 37.85726900739488 -122.25521665090425
41 41 41 057 207500500 1435 Berkeley Way 1435 BERKELEY WAY 1435 BERKELEY WY 1435.0 BERKELEY WY     Berkeley 94702 37.87129018445151 -122.2828227940702
42 42 42 055 181603000 1936 Blake St 18 1936 BLAKE ST 18 1936 BLAKE ST 1936.0 BLAKE ST 18   Berkeley 94704 37.86238468255223 -122.27022266726398
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
45 45 45 061 257702700 929 Mendocino Ave 929 MENDOCINO AVE 929 MENDOCINO AV 929.0 MENDOCINO AV     Berkeley 94707 37.89092911152244 -122.27396082216418
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
47 47 47 062 288803300 1886 San Pedro Ave 1886 SAN PEDRO AVE 1886 SAN PEDRO AV 1886.0 SAN PEDRO AV     Berkeley 94707 37.893759925568006 -122.277405502851
48 48 48 053 159100802 2916 Newbury St 2916 NEWBURY ST 2916 NEWBURY ST 2916.0 NEWBURY ST     Berkeley 94703 37.85579849311087 -122.26775051528016
49 49 49 052 157300900 2631 Webster St 2631 WEBSTER ST 2631 WEBSTER ST 2631.0 WEBSTER ST     Berkeley 94705 37.856236198329135 -122.25370512135268
50 50 50 056 192701900 2365 San Pablo Ave 2365 SAN PABLO AVE 2365 SAN PABLO AV 2365.0 SAN PABLO AV     Berkeley 94702 37.86357401901893 -122.28998707046344
51 51 51 055 189800700 1931 Dwight Way 15 1931 DWIGHT WAY 15 1931 DWIGHT WY 1931.0 DWIGHT WY 15   Berkeley 94704 37.863819744722456 -122.27057484368626
52 52 52 060 246302300 2290 Eunice St 2290 EUNICE ST 2290 EUNICE ST 2290.0 EUNICE ST     Berkeley 94709 37.88593906545171 -122.26556284986536
53 53 53 057 206001200 1810 Berkeley Way 4 1810 BERKELEY WAY 4 1810 BERKELEY WY 1810.0 BERKELEY WY 4   Berkeley 94703 37.87197267857206 -122.27469630343002
54 54 54 055 188500201 2315 Durant Ave 307 2315 DURANT AVE 307 2315 DURANT AV 2315.0 DURANT AV 307   Berkeley 94704 37.86767914241777 -122.262294565961
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
56 56 56 052 154503100 1632 Prince St C 1632 PRINCE ST C 1632 PRINCE ST 1632.0 PRINCE ST C   Berkeley 94703 37.851748615836954 -122.27494754694362
57 57 57 054 180401201 1621 Carleton St 1621 CARLETON ST 1621 CARLETON ST 1621.0 CARLETON ST     Berkeley 94703 37.860271015415954 -122.27712902745768
58 58 58 053 159402400 2030 Essex St A 2030 ESSEX ST A 2030 ESSEX ST 2030.0 ESSEX ST A   Berkeley 94703 37.85352297506441 -122.26683968466747
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
60 60 60 057 202200800 1907 Center St 1 1907 CENTER ST 1 1907 CENTER ST 1907.0 CENTER ST 1   Berkeley 94704 37.87002797917772 -122.2722691830931
61 61 61 057 207201501 1440 Berkeley Way 1440 BERKELEY WAY 1440 BERKELEY WY 1440.0 BERKELEY WY     Berkeley 94702 37.87090866835336 -122.28249569501736
62 62 62 052 153803300 3234 Baker St 3234 BAKER ST 3234 BAKER ST 3234.0 BAKER ST     Berkeley 94702 37.84884470212363 -122.28009767650238
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
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
65 65 65 059 231000205 1080 Jones St Apt 551 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 551 APT Berkeley 94710 37.87615380369332 -122.29482956566495
66 66 66 053 161300700 1531 Prince St 2 1531 PRINCE ST 2 1531 PRINCE ST 1531.0 PRINCE ST 2   Berkeley 94703 37.85190834535323 -122.27751938317788
67 67 67 063 314009500 1064 Overlook Rd 1064 OVERLOOK RD 1064 OVERLOOK RD 1064.0 OVERLOOK RD     Berkeley 94708 37.89259905172096 -122.2550630237193
68 68 68 053 168200100 2870 Adeline St 602 2870 ADELINE ST 602 2870 ADELINE ST 2870.0 ADELINE ST 602   Berkeley 94703 37.85692293566353 -122.2687468205921
69 69 69 059 228703100 1609 San Pablo Ave B 1609 SAN PABLO AVE B 1609 SAN PABLO AV 1609.0 SAN PABLO AV B   Berkeley 94702 37.87486099453608 -122.29363781748992
70 70 70 055 182100700 2037 Parker St Apt 306 2037 PARKER ST 2037 PARKER ST 2037.0 PARKER ST 306 APT Berkeley 94704 37.862287718095075 -122.26793969598742
71 71 71 060 248604400 1259 Queens Rd 1259 QUEENS RD 1259 QUEENS RD 1259.0 QUEENS RD     Berkeley 94708 37.88677757474611 -122.25360426120751
72 72 72 053 159500200 2008 Emerson St 3 2008 EMERSON ST 3 2008 EMERSON ST 2008.0 EMERSON ST 3   Berkeley 94703 37.85409548349568 -122.26858630961712
73 73 73 056 197700300 1046 Addison St 1046 ADDISON ST 1046 ADDISON ST 1046.0 ADDISON ST     Berkeley 94710 37.86745915647912 -122.29232508870398
74 74 74 057 202301701 2002 Addison St 2 2002 ADDISON ST 2 2002 ADDISON ST 2002.0 ADDISON ST 2   Berkeley 94704 37.8707665181595 -122.27030273500355
75 75 75 055 183002001 2220 Dwight Way 204 2220 DWIGHT WAY 204 2220 DWIGHT WY 2220.0 DWIGHT WY 204   Berkeley 94704 37.864077629415895 -122.26438686712356
76 76 76 059 227802500 1629 Cedar St 1629 CEDAR ST 1629 CEDAR ST 1629.0 CEDAR ST     Berkeley 94703 37.87733495867239 -122.27923421944456
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
78 78 78 055 189901700 2409 Martin Luther King Jr Way 2409 MARTIN LUTHER KING JR WAY 2409 MARTIN LUTHER KING JR WY 2409.0 MARTIN LUTHER KING JR WY     Berkeley 94704 37.86496930901207 -122.2719699569669
79 79 79 060 248201600 1340 Queens Rd 1340 QUEENS RD 1340 QUEENS RD 1340.0 QUEENS RD     Berkeley 94708 37.88525257867311 -122.25265455779756
80 80 80 059 229000300 1208 Rose St 1208 ROSE ST 1208 ROSE ST 1208.0 ROSE ST     Berkeley 94702 37.87634690040688 -122.29120824924382
81 81 81 057 203201200 2112 Addison St 310 2112 ADDISON ST 310 2112 ADDISON ST 2112.0 ADDISON ST 310   Berkeley 94704 37.87110287937675 -122.26706095589168
82 82 82 055 188100400 2449 Dwight Way 33 2449 DWIGHT WAY 33 2449 DWIGHT WY 2449.0 DWIGHT WY 33   Berkeley 94704 37.86530920217209 -122.25876941598769
83 83 83 062 288502900 1836 Capistrano Ave 1836 CAPISTRANO AVE 1836 CAPISTRANO AV 1836.0 CAPISTRANO AV     Berkeley 94707 37.89411625933739 -122.27977139311984
84 84 84 052 158403200 3021 Wheeler St 3021 WHEELER ST 3021 WHEELER ST 3021.0 WHEELER ST     Berkeley 94705 37.85462077193717 -122.26407099252022
85 85 85 062 287401100 1561 Capistrano Ave 1561 CAPISTRANO AVE 1561 CAPISTRANO AV 1561.0 CAPISTRANO AV     Berkeley 94707 37.89159855168666 -122.2854602621174
86 86 86 062 289500100 551 Santa Rosa Ave 551 SANTA ROSA AVE 551 SANTA ROSA AV 551.0 SANTA ROSA AV     Berkeley 94707 37.8984196827758 -122.28244555824472
87 87 87 056 192002100 1315 Dwight Way 1315 DWIGHT WAY 1315 DWIGHT WY 1315.0 DWIGHT WY     Berkeley 94702 37.862281240176614 -122.28538183110828
88 88 88 052 156103600 3005 Hillegass Ave 3005 HILLEGASS AVE 3005 HILLEGASS AV 3005.0 HILLEGASS AV     Berkeley 94705 37.85560371476175 -122.25469746778914
89 89 89 060 249400301 104 Hill Rd 104 HILL RD 104 HILL RD 104.0 HILL RD     Berkeley 94708 37.887867387461775 -122.25092691155494
90 90 90 055 184600500 2504 College Ave 6 2504 COLLEGE AVE 6 2504 COLLEGE AV 2504.0 COLLEGE AV 6   Berkeley 94704 37.865504616537685 -122.25408878642062
91 91 91 053 160400900 2912 Ellis St 2912 ELLIS ST 2912 ELLIS ST 2912.0 ELLIS ST     Berkeley 94703 37.855169596152535 -122.27364212685085
92 92 92 056 199100111 2207 Bonar St D 2207 BONAR ST D 2207 BONAR ST 2207.0 BONAR ST D   Berkeley 94702 37.866568106966895 -122.28655615556006
93 93 93 055 190601200 2426 Grant St 6 2426 GRANT ST 6 2426 GRANT ST 2426.0 GRANT ST 6   Berkeley 94703 37.86381528176066 -122.2748232838887
94 94 94 060 248100300 1224 Queens Rd 1224 QUEENS RD 1224 QUEENS RD 1224.0 QUEENS RD     Berkeley 94708 37.887553409000624 -122.25383277824274
95 95 95 060 242800107 1302 Albina Ave A 1302 ALBINA AVE A 1302 ALBINA AV 1302.0 ALBINA AV A   Berkeley 94706 37.88199322421002 -122.2840703159463
96 96 96 057 205001302 2015 Hearst Ave 2015 HEARST AVE 2015 HEARST AV 2015.0 HEARST AV     Berkeley 94709 37.87395294459053 -122.27023887017674
97 97 97 055 189801700 2441 Martin Luther King Jr Way 2441 MARTIN LUTHER KING JR WAY 2441 MARTIN LUTHER KING JR WY 2441.0 MARTIN LUTHER KING JR WY     Berkeley 94704 37.86375817951277 -122.2719193701383
98 98 98 053 167000603 2836 Sacramento St 2836 SACRAMENTO ST 2836 SACRAMENTO ST 2836.0 SACRAMENTO ST     Berkeley 94702 37.85619717370725 -122.27995025128617
99 99 99 060 243003201 1330 Sacramento St 35 1330 SACRAMENTO ST 35 1330 SACRAMENTO ST 1330.0 SACRAMENTO ST 35   Berkeley 94702 37.880523567725994 -122.28353562701108
100 100 100 055 182202600 2030 Dwight Way 201 2030 DWIGHT WAY 201 2030 DWIGHT WY 2030.0 DWIGHT WY 201   Berkeley 94704 37.863593502784774 -122.2682385169734

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