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

123 rows where street_name = "BLAKE" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94702 · 123 ✖

street_type 1

street_name 1

  • BLAKE · 123 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1261 1261 1261 054 179502600 1432 Blake St 1432 BLAKE ST 1432 BLAKE ST 1432.0 BLAKE ST     Berkeley 94702 37.86096716838137 -122.28156998291372
1687 1687 1687 054 178200900 1221 Blake St 1221 BLAKE ST 1221 BLAKE ST 1221.0 BLAKE ST     Berkeley 94702 37.86090769370471 -122.28618689677432
1710 1710 1710 054 179601300 1441 Blake St 1441 BLAKE ST 1441 BLAKE ST 1441.0 BLAKE ST     Berkeley 94702 37.86142161945416 -122.2821811427341
1783 1783 1783 054 178402300 1126 Blake St 1126 BLAKE ST 1126 BLAKE ST 1126.0 BLAKE ST     Berkeley 94702 37.860151509564176 -122.28796759751764
1910 1910 1910 054 178200700 1227 Blake St 1227 BLAKE ST 1227 BLAKE ST 1227.0 BLAKE ST     Berkeley 94702 37.860942533549 -122.28591918534494
2458 2458 2458 054 179001900 1316 Blake St 1316 BLAKE ST 1316 BLAKE ST 1316.0 BLAKE ST     Berkeley 94702 37.86058354066074 -122.28456542690672
2483 2483 2483 054 179600700 1495 Blake St 1495 BLAKE ST 1495 BLAKE ST 1495.0 BLAKE ST     Berkeley 94702 37.86146461363617 -122.28143394564034
2558 2558 2558 054 178200400 1239 Blake St 1239 BLAKE ST 1239 BLAKE ST 1239.0 BLAKE ST     Berkeley 94702 37.86095251159683 -122.28549677683708
2702 2702 2702 054 179601500 1421 Blake St 1421 BLAKE ST 1421 BLAKE ST 1421.0 BLAKE ST     Berkeley 94702 37.86138900181635 -122.28241683012192
3447 3447 3447 054 178901800 1212 Blake St 1212 BLAKE ST 1212 BLAKE ST 1212.0 BLAKE ST     Berkeley 94702 37.860339183615665 -122.28650234018632
3514 3514 3514 054 179002500 1334 Blake St 1334 BLAKE ST 1334 BLAKE ST 1334.0 BLAKE ST     Berkeley 94702 37.86069473298995 -122.2837132266377
4976 4976 4976 054 178101400 1111 Blake St A 1111 BLAKE ST A 1111 BLAKE ST 1111.0 BLAKE ST A   Berkeley 94702 37.860578266148615 -122.28875738733228
5797 5797 5797 054 178201000 1215 Blake St 1215 BLAKE ST 1215 BLAKE ST 1215.0 BLAKE ST     Berkeley 94702 37.860885369500586 -122.2863664448468
6113 6113 6113 054 179002400 1332 Blake St B 1332 BLAKE ST B 1332 BLAKE ST 1332.0 BLAKE ST B   Berkeley 94702 37.86067644066474 -122.28384964569504
6553 6553 6553 054 179001800 1314 Blake St 1314 BLAKE ST 1314 BLAKE ST 1314.0 BLAKE ST     Berkeley 94702 37.86057053416853 -122.28467423444717
6984 6984 6984 054 178902500 1236 Blake St 1236 BLAKE ST 1236 BLAKE ST 1236.0 BLAKE ST     Berkeley 94702 37.86046097500159 -122.28554205013076
9141 9141 9141 054 178301400 1309 Blake St 1309 BLAKE ST 1309 BLAKE ST 1309.0 BLAKE ST     Berkeley 94702 37.861085611916096 -122.284809634815
9774 9774 9774 054 178201400 1205 Blake St 1205 BLAKE ST 1205 BLAKE ST 1205.0 BLAKE ST     Berkeley 94702 37.86077835124156 -122.28689487791436
9927 9927 9927 054 179501700 1402 Blake St 1402 BLAKE ST 1402 BLAKE ST 1402.0 BLAKE ST     Berkeley 94702 37.86081011240757 -122.28281510898294
11032 11032 11032 054 179002700 1348 Blake St 1348 BLAKE ST 1348 BLAKE ST 1348.0 BLAKE ST     Berkeley 94702 37.86068064920492 -122.28337959593442
11234 11234 11234 054 178101000 1121 Blake St 1121 BLAKE ST 1121 BLAKE ST 1121.0 BLAKE ST     Berkeley 94702 37.860646922720306 -122.28821080919428
11275 11275 11275 054 178201200 1211 Blake St 1211 BLAKE ST 1211 BLAKE ST 1211.0 BLAKE ST     Berkeley 94702 37.8608455111659 -122.28667215052111
12769 12769 12769 054 178402100 1118 Blake St 1118 BLAKE ST 1118 BLAKE ST 1118.0 BLAKE ST     Berkeley 94702 37.860116163664806 -122.28821891109982
13369 13369 13369 054 179502300 1422 Blake St 1422 BLAKE ST 1422 BLAKE ST 1422.0 BLAKE ST     Berkeley 94702 37.86091511075461 -122.28199395538849
13446 13446 13446 054 178300900 1325 Blake St 1325 BLAKE ST 1325 BLAKE ST 1325.0 BLAKE ST     Berkeley 94702 37.861160392841086 -122.28422760466432
13687 13687 13687 054 178300700 1331 Blake St 1331 BLAKE ST 1331 BLAKE ST 1331.0 BLAKE ST     Berkeley 94702 37.86119525738861 -122.28396343978368
13848 13848 13848 054 178402000 1116 Blake St 1116 BLAKE ST 1116 BLAKE ST 1116.0 BLAKE ST     Berkeley 94702 37.860101159188176 -122.28835442465538
14104 14104 14104 054 179501800 1404 Blake St 1404 BLAKE ST 1404 BLAKE ST 1404.0 BLAKE ST     Berkeley 94702 37.860827122423665 -122.28267100034674
15079 15079 15079 054 178301300 1315 Blake St 1315 BLAKE ST 1315 BLAKE ST 1315.0 BLAKE ST     Berkeley 94702 37.86110180981088 -122.28469137250616
15505 15505 15505 054 178902200 1224 Blake St 1224 BLAKE ST 1224 BLAKE ST 1224.0 BLAKE ST     Berkeley 94702 37.86040854750984 -122.28595574228542
15798 15798 15798 054 179601600 1411 Blake St 1411 BLAKE ST 1411 BLAKE ST 1411.0 BLAKE ST     Berkeley 94702 37.86137481319972 -122.28253772988444
16424 16424 16424 054 178100700 1127 Blake St 1127 BLAKE ST 1127 BLAKE ST 1127.0 BLAKE ST     Berkeley 94702 37.86070643094093 -122.28781034832546
16892 16892 16892 054 178301000 1321 Blake St 1321 BLAKE ST 1321 BLAKE ST 1321.0 BLAKE ST     Berkeley 94702 37.86114335949755 -122.28434772468916
18593 18593 18593 054 178101400 1111 Blake St 2 1111 BLAKE ST 2 1111 BLAKE ST 1111.0 BLAKE ST 2   Berkeley 94702 37.860578266148615 -122.28875738733228
19239 19239 19239 054 178300800 1327 Blake St 1327 BLAKE ST 1327 BLAKE ST 1327.0 BLAKE ST     Berkeley 94702 37.86117755100335 -122.2840955720805
21127 21127 21127 054 178201000 1215 Blake St B 1215 BLAKE ST B 1215 BLAKE ST 1215.0 BLAKE ST B   Berkeley 94702 37.860885369500586 -122.2863664448468
22108 22108 22108 054 178300600 1335 Blake St 1335 BLAKE ST 1335 BLAKE ST 1335.0 BLAKE ST     Berkeley 94702 37.86121011270638 -122.28384161116314
22171 22171 22171 054 178300700 1331 Blake St B 1331 BLAKE ST B 1331 BLAKE ST 1331.0 BLAKE ST B   Berkeley 94702 37.86119525738861 -122.28396343978368
23047 23047 23047 054 178300500 1339 Blake St 1339 BLAKE ST 1339 BLAKE ST 1339.0 BLAKE ST     Berkeley 94702 37.86115827227263 -122.28368860381576
24112 24112 24112 054 178200600 1231 Blake St 1231 BLAKE ST 1231 BLAKE ST 1231.0 BLAKE ST     Berkeley 94702 37.86091857956209 -122.2857756812749
24292 24292 24292 054 179601800 1401 Blake St 1401 BLAKE ST 1401 BLAKE ST 1401.0 BLAKE ST     Berkeley 94702 37.8612467311299 -122.28287407529648
24581 24581 24581 054 178402600 1134 Blake St 1134 BLAKE ST 1134 BLAKE ST 1134.0 BLAKE ST     Berkeley 94702 37.86020190387806 -122.28757561315182
25244 25244 25244 054 179002100 1322 Blake St 1322 BLAKE ST 1322 BLAKE ST 1322.0 BLAKE ST     Berkeley 94702 37.86061686007895 -122.28429684051822
25421 25421 25421 054 179502100 1414 Blake St 1414 BLAKE ST 1414 BLAKE ST 1414.0 BLAKE ST     Berkeley 94702 37.86088036309636 -122.28226595717165
26213 26213 26213 054 178200500 1233 Blake St 1233 BLAKE ST 1233 BLAKE ST 1233.0 BLAKE ST     Berkeley 94702 37.86093537820495 -122.28563488562548
26592 26592 26592 054 179001600 1308 Blake St 1308 BLAKE ST 1308 BLAKE ST 1308.0 BLAKE ST     Berkeley 94702 37.86053779629487 -122.28491161156606
26661 26661 26661 054 178100600 1129 Blake St A 1129 BLAKE ST A 1129 BLAKE ST 1129.0 BLAKE ST A   Berkeley 94702 37.86071391325974 -122.2876901519438
26675 26675 26675 054 179000100 1350 Blake St 1350 BLAKE ST 1350 BLAKE ST 1350.0 BLAKE ST     Berkeley 94702 37.86088771702818 -122.2831571685785
27385 27385 27385 054 179601700 1405 Blake St 1405 BLAKE ST 1405 BLAKE ST 1405.0 BLAKE ST     Berkeley 94702 37.86127444812684 -122.2826773460459
27701 27701 27701 054 179600800 1491 Blake St 1491 BLAKE ST 1491 BLAKE ST 1491.0 BLAKE ST     Berkeley 94702 37.861503661001166 -122.2815646810569
28862 28862 28862 054 178101100 1119 Blake St 1119 BLAKE ST 1119 BLAKE ST 1119.0 BLAKE ST     Berkeley 94702 37.86062936797755 -122.28834896469507
29595 29595 29595 054 178402400 1128 Blake St 1128 BLAKE ST 1128 BLAKE ST 1128.0 BLAKE ST     Berkeley 94702 37.86016687999312 -122.28784413845486
29624 29624 29624 054 179502900 1440 Blake St 1440 BLAKE ST 1440 BLAKE ST 1440.0 BLAKE ST     Berkeley 94702 37.86102316073237 -122.2811591213505
29835 29835 29835 054 178902300 1228 Blake St 1228 BLAKE ST 1228 BLAKE ST 1228.0 BLAKE ST     Berkeley 94702 37.86042793707609 -122.28581320570096
29935 29935 29935 054 178100800 1125 Blake St 1125 BLAKE ST 1125 BLAKE ST 1125.0 BLAKE ST     Berkeley 94702 37.860690018064155 -122.2879387723768
30504 30504 30504 054 179502800 1438 Blake St 1438 BLAKE ST 1438 BLAKE ST 1438.0 BLAKE ST     Berkeley 94702 37.86100650253546 -122.28129629678936
31430 31430 31430 054 179002200 1326 Blake St 1326 BLAKE ST 1326 BLAKE ST 1326.0 BLAKE ST     Berkeley 94702 37.86063831059892 -122.2841414337707
31535 31535 31535 054 178401900 1108 Blake St 1108 BLAKE ST 1108 BLAKE ST 1108.0 BLAKE ST     Berkeley 94702 37.86012184388967 -122.2887420485988
32158 32158 32158 054 179502000 1410 Blake St 1410 BLAKE ST 1410 BLAKE ST 1410.0 BLAKE ST     Berkeley 94702 37.860862311243835 -122.28239985196306
32592 32592 32592 054 179002600 1336 Blake St 1336 BLAKE ST 1336 BLAKE ST 1336.0 BLAKE ST     Berkeley 94702 37.860713746591955 -122.2835672890316
35337 35337 35337 054 178300700 1331 Blake St A 1331 BLAKE ST A 1331 BLAKE ST 1331.0 BLAKE ST A   Berkeley 94702 37.86119525738861 -122.28396343978368
35410 35410 35410 054 179502500 1428 Blake St 1428 BLAKE ST 1428 BLAKE ST 1428.0 BLAKE ST     Berkeley 94702 37.86094899598229 -122.28170899361066
35903 35903 35903 054 178201000 1215 Blake St D 1215 BLAKE ST D 1215 BLAKE ST 1215.0 BLAKE ST D   Berkeley 94702 37.860885369500586 -122.2863664448468
36010 36010 36010 054 178101400 1111 Blake St 1111 BLAKE ST 1111 BLAKE ST 1111.0 BLAKE ST     Berkeley 94702 37.860578266148615 -122.28875738733228
36614 36614 36614 054 178901600 1204 Blake St 1204 BLAKE ST 1204 BLAKE ST 1204.0 BLAKE ST     Berkeley 94702 37.86035172418591 -122.28678056190456
36962 36962 36962 054 179002300 1328 Blake St 1328 BLAKE ST 1328 BLAKE ST 1328.0 BLAKE ST     Berkeley 94702 37.860657609323965 -122.2839938800954
37037 37037 37037 054 179601000 1471 Blake St 1471 BLAKE ST 1471 BLAKE ST 1471.0 BLAKE ST     Berkeley 94702 37.86147020226808 -122.2818107215284
38049 38049 38049 054 179601400 1431 Blake St 1431 BLAKE ST 1431 BLAKE ST 1431.0 BLAKE ST     Berkeley 94702 37.86140534077882 -122.28230197602127
38123 38123 38123 054 179502400 1424 Blake St 1424 BLAKE ST 1424 BLAKE ST 1424.0 BLAKE ST     Berkeley 94702 37.86093114982106 -122.28185327382506
38175 38175 38175 054 178201300 1207 Blake St 1207 BLAKE ST 1207 BLAKE ST 1207.0 BLAKE ST     Berkeley 94702 37.86079516764696 -122.28677473992322
38315 38315 38315 054 178201000 1215 Blake St A 1215 BLAKE ST A 1215 BLAKE ST 1215.0 BLAKE ST A   Berkeley 94702 37.860885369500586 -122.2863664448468
38479 38479 38479 054 178902100 1220 Blake St 1220 BLAKE ST 1220 BLAKE ST 1220.0 BLAKE ST     Berkeley 94702 37.860392019671835 -122.28609044556056
38772 38772 38772 054 179002700 1342 Blake St 1342 BLAKE ST 1342 BLAKE ST 1342.0 BLAKE ST     Berkeley 94702 37.86068064920492 -122.28337959593442
39662 39662 39662 054 179502800 1436 Blake St 1436 BLAKE ST 1436 BLAKE ST 1436.0 BLAKE ST     Berkeley 94702 37.86100650253546 -122.28129629678936
40392 40392 40392 054 179002700 1346 Blake St 1346 BLAKE ST 1346 BLAKE ST 1346.0 BLAKE ST     Berkeley 94702 37.86068064920492 -122.28337959593442
40605 40605 40605 054 178402000 1116 Blake St 3 1116 BLAKE ST 3 1116 BLAKE ST 1116.0 BLAKE ST 3   Berkeley 94702 37.860101159188176 -122.28835442465538
40656 40656 40656 054 178101200 1115 Blake St 1115 BLAKE ST 1115 BLAKE ST 1115.0 BLAKE ST     Berkeley 94702 37.860611704009905 -122.28848887550396
40781 40781 40781 054 178201000 1217 Blake St 1217 BLAKE ST 1217 BLAKE ST 1217.0 BLAKE ST     Berkeley 94702 37.860885369500586 -122.2863664448468
40982 40982 40982 054 178402500 1130 Blake St 1130 BLAKE ST 1130 BLAKE ST 1130.0 BLAKE ST     Berkeley 94702 37.860183628452006 -122.28771549790956
42678 42678 42678 054 179001700 1312 Blake St 1312 BLAKE ST 1312 BLAKE ST 1312.0 BLAKE ST     Berkeley 94702 37.86055514680237 -122.28478304019102
42870 42870 42870 054 178100900 1123 Blake St 1123 BLAKE ST 1123 BLAKE ST 1123.0 BLAKE ST     Berkeley 94702 37.86066513987505 -122.28807356907674
43328 43328 43328 054 179601100 1461 Blake St 1461 BLAKE ST 1461 BLAKE ST 1461.0 BLAKE ST     Berkeley 94702 37.86145505125906 -122.28193075262004
43343 43343 43343 054 178301700 1301 Blake St 1301 BLAKE ST 1301 BLAKE ST 1301.0 BLAKE ST     Berkeley 94702 37.860997304638886 -122.285160001132
43719 43719 43719 054 178901700 1208 Blake St 1208 BLAKE ST 1208 BLAKE ST 1208.0 BLAKE ST     Berkeley 94702 37.86032099758644 -122.28663696351144
43842 43842 43842 054 179000100 1352 Blake St 1352 BLAKE ST 1352 BLAKE ST 1352.0 BLAKE ST     Berkeley 94702 37.86088771702818 -122.2831571685785
43878 43878 43878 054 178100600 1129 Blake St 1129 BLAKE ST 1129 BLAKE ST 1129.0 BLAKE ST     Berkeley 94702 37.86071391325974 -122.2876901519438
44144 44144 44144 054 178201500 1201 Blake St 1201 BLAKE ST 1201 BLAKE ST 1201.0 BLAKE ST     Berkeley 94702 37.86076142561181 -122.28701222483993
44150 44150 44150 054 178201000 1215 Blake St C 1215 BLAKE ST C 1215 BLAKE ST 1215.0 BLAKE ST C   Berkeley 94702 37.860885369500586 -122.2863664448468
44318 44318 44318 054 179001500 1300 Blake St 1300 BLAKE ST 1300 BLAKE ST 1300.0 BLAKE ST     Berkeley 94702 37.86056216530272 -122.28506380414149
44366 44366 44366 054 179502700 1434 Blake St 1434 BLAKE ST 1434 BLAKE ST 1434.0 BLAKE ST     Berkeley 94702 37.8609850812007 -122.28143796560124
44983 44983 44983 054 179600900 1481 Blake St 1481 BLAKE ST 1481 BLAKE ST 1481.0 BLAKE ST     Berkeley 94702 37.86148633199347 -122.28169331890729
45462 45462 45462 054 178200800 1223 Blake St 1223 BLAKE ST 1223 BLAKE ST 1223.0 BLAKE ST     Berkeley 94702 37.86092488171318 -122.28605214319349
45783 45783 45783 054 179002000 1318 Blake St 1318 BLAKE ST 1318 BLAKE ST 1318.0 BLAKE ST     Berkeley 94702 37.86059790602691 -122.284446244723
46145 46145 46145 054 178902000 1216 Blake St 1216 BLAKE ST 1216 BLAKE ST 1216.0 BLAKE ST     Berkeley 94702 37.86037477054553 -122.2862259519296
46285 46285 46285 054 178301600 1305 Blake St 1305 BLAKE ST 1305 BLAKE ST 1305.0 BLAKE ST     Berkeley 94702 37.86101287205506 -122.28504080637188
46634 46634 46634 054 178101400 1111 Blake St D 1111 BLAKE ST D 1111 BLAKE ST 1111.0 BLAKE ST D   Berkeley 94702 37.860578266148615 -122.28875738733228
48052 48052 48052 054 179501900 1408 Blake St 1408 BLAKE ST 1408 BLAKE ST 1408.0 BLAKE ST     Berkeley 94702 37.86084608705514 -122.2825336245836
48070 48070 48070 054 178301500 1307 Blake St 1307 BLAKE ST 1307 BLAKE ST 1307.0 BLAKE ST     Berkeley 94702 37.86102841890056 -122.28491914393972
48101 48101 48101 054 178402000 1116 Blake St 2 1116 BLAKE ST 2 1116 BLAKE ST 1116.0 BLAKE ST 2   Berkeley 94702 37.860101159188176 -122.28835442465538
48237 48237 48237 054 178300400 1345 Blake St 1345 BLAKE ST 1345 BLAKE ST 1345.0 BLAKE ST     Berkeley 94702 37.86118857937405 -122.28330313762564

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