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

117 rows where street_name = "ALLSTON" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94702 · 117 ✖

street_type 1

street_name 1

  • ALLSTON · 117 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
479 479 479 056 198700400 1210 Allston Way 1210 ALLSTON WAY 1210 ALLSTON WY 1210.0 ALLSTON WY     Berkeley 94702 37.86654206559832 -122.2883503705585
496 496 496 056 199804803 1408 Allston Way 5 1408 ALLSTON WAY 5 1408 ALLSTON WY 1408.0 ALLSTON WY 5   Berkeley 94702 37.86662083005484 -122.28326691485844
1810 1810 1810 056 199703700 1415 Allston Way 1415 ALLSTON WAY 1415 ALLSTON WY 1415.0 ALLSTON WY     Berkeley 94702 37.86749470309471 -122.2831975343758
2054 2054 2054 056 198901900 1229 Allston Way 1229 ALLSTON WAY 1229 ALLSTON WY 1229.0 ALLSTON WY     Berkeley 94702 37.86707558595424 -122.2876936302206
2966 2966 2966 056 198700100 1200 Allston Way 1200 ALLSTON WAY 1200 ALLSTON WY 1200.0 ALLSTON WY     Berkeley 94702 37.86648837018345 -122.28875615035211
3052 3052 3052 056 198800400 1236 Allston Way 1236 ALLSTON WAY 1236 ALLSTON WY 1236.0 ALLSTON WY     Berkeley 94702 37.86667856691658 -122.28732886301124
3359 3359 3359 056 198601000 1203 Allston Way 2 1203 ALLSTON WAY 2 1203 ALLSTON WY 1203.0 ALLSTON WY 2   Berkeley 94702 37.86694326873318 -122.2887125263653
3631 3631 3631 056 199800500 1418 Allston Way 1418 ALLSTON WAY 1418 ALLSTON WY 1418.0 ALLSTON WY     Berkeley 94702 37.86697576406395 -122.28287506434162
3946 3946 3946 056 199800800 1430 Allston Way 1430 ALLSTON WAY 1430 ALLSTON WY 1430.0 ALLSTON WY     Berkeley 94702 37.867024428316135 -122.28249505362024
4808 4808 4808 056 199703300 1429 Allston Way B 1429 ALLSTON WAY B 1429 ALLSTON WY 1429.0 ALLSTON WY B   Berkeley 94702 37.86755231375062 -122.28267128511268
4908 4908 4908 056 199703001 1435 Allston Way 1435 ALLSTON WAY 1435 ALLSTON WY 1435.0 ALLSTON WY     Berkeley 94702 37.867490781443976 -122.28225335380822
5020 5020 5020 056 198700200 1206 Allston Way 1206 ALLSTON WAY 1206 ALLSTON WY 1206.0 ALLSTON WY     Berkeley 94702 37.86650713833669 -122.2886197097352
5328 5328 5328 056 198303900 1112 Allston Way 1112 ALLSTON WAY 1112 ALLSTON WY 1112.0 ALLSTON WY     Berkeley 94702 37.866270217442775 -122.29044880811276
6185 6185 6185 056 198303900 1112 Allston Way B 1112 ALLSTON WAY B 1112 ALLSTON WY 1112.0 ALLSTON WY B   Berkeley 94702 37.866270217442775 -122.29044880811276
6659 6659 6659 056 199800202 1406 Allston Way D 1406 ALLSTON WAY D 1406 ALLSTON WY 1406.0 ALLSTON WY D   Berkeley 94702 37.866927184879465 -122.28335815314858
6827 6827 6827 056 198800500 1244 Allston Way 1244 ALLSTON WAY 1244 ALLSTON WY 1244.0 ALLSTON WY     Berkeley 94702 37.866770370667545 -122.2871387750056
7188 7188 7188 056 199703600 1417 Allston Way A 1417 ALLSTON WAY A 1417 ALLSTON WY 1417.0 ALLSTON WY A   Berkeley 94702 37.86750780551968 -122.28308276651342
7330 7330 7330 056 199402400 1339 Allston Way 1339 ALLSTON WAY 1339 ALLSTON WY 1339.0 ALLSTON WY     Berkeley 94702 37.8672790290155 -122.28410539785308
8509 8509 8509 056 199703600 1417 Allston Way B 1417 ALLSTON WAY B 1417 ALLSTON WY 1417.0 ALLSTON WY B   Berkeley 94702 37.86750780551968 -122.28308276651342
9356 9356 9356 056 198601000 1203 Allston Way 1 1203 ALLSTON WAY 1 1203 ALLSTON WY 1203.0 ALLSTON WY 1   Berkeley 94702 37.86694326873318 -122.2887125263653
10406 10406 10406 056 199404901 1309 Allston Way 3 1309 ALLSTON WAY 3 1309 ALLSTON WY 1309.0 ALLSTON WY 3   Berkeley 94702 37.86751766283073 -122.28560104339375
11444 11444 11444 056 198600700 1215 Allston Way 1215 ALLSTON WAY 1215 ALLSTON WY 1215.0 ALLSTON WY     Berkeley 94702 37.86699588446891 -122.28830152376662
11863 11863 11863 056 198902000 1225 Allston Way 1225 ALLSTON WAY 1225 ALLSTON WY 1225.0 ALLSTON WY     Berkeley 94702 37.86705771432834 -122.28782570053366
13196 13196 13196 056 198501900 1133 Allston Way 1133 ALLSTON WAY 1133 ALLSTON WY 1133.0 ALLSTON WY     Berkeley 94702 37.86680698278249 -122.2897287608018
13962 13962 13962 056 199301501 1326 Allston Way Eqpmt 1326 ALLSTON WAY EQPMT 1326 ALLSTON WY 1326.0 ALLSTON WY EQPMT   Berkeley 94702 37.866162068781925 -122.28492231499268
13967 13967 13967 056 199800500 1420 Allston Way 2 1420 ALLSTON WAY 2 1420 ALLSTON WY 1420.0 ALLSTON WY 2   Berkeley 94702 37.86697576406395 -122.28287506434162
14838 14838 14838 056 199404600 1319 Allston Way 1319 ALLSTON WAY 1319 ALLSTON WY 1319.0 ALLSTON WY     Berkeley 94702 37.867145563316384 -122.2851312712126
14927 14927 14927 056 198303900 1112 Allston Way C 1112 ALLSTON WAY C 1112 ALLSTON WY 1112.0 ALLSTON WY C   Berkeley 94702 37.866270217442775 -122.29044880811276
15051 15051 15051 056 199703200 1431 Allston Way 1431 ALLSTON WAY 1431 ALLSTON WY 1431.0 ALLSTON WY     Berkeley 94702 37.86746362773018 -122.28243523929706
15229 15229 15229 056 199301501 1326 Allston Way Strts 1326 ALLSTON WAY STRTS 1326 ALLSTON WY 1326.0 ALLSTON WY STRTS   Berkeley 94702 37.866162068781925 -122.28492231499268
15836 15836 15836 056 199404500 1321 Allston Way 1321 ALLSTON WAY 1321 ALLSTON WY 1321.0 ALLSTON WY     Berkeley 94702 37.86716052168159 -122.2850250723797
16802 16802 16802 056 199703600 1417 Allston Way 1417 ALLSTON WAY 1417 ALLSTON WY 1417.0 ALLSTON WY     Berkeley 94702 37.86750780551968 -122.28308276651342
17143 17143 17143 056 199800202 1406 Allston Way B 1406 ALLSTON WAY B 1406 ALLSTON WY 1406.0 ALLSTON WY B   Berkeley 94702 37.866927184879465 -122.28335815314858
17387 17387 17387 056 199301501 1326 Allston Way 1326 ALLSTON WAY 1326 ALLSTON WY 1326.0 ALLSTON WY     Berkeley 94702 37.866162068781925 -122.28492231499268
17725 17725 17725 056 198301100 1111 Allston Way 1111 ALLSTON WAY 1111 ALLSTON WY 1111.0 ALLSTON WY     Berkeley 94702 37.866741329596245 -122.29058415098838
18442 18442 18442 056 199402500 1335 Allston Way 1335 ALLSTON WAY 1335 ALLSTON WY 1335.0 ALLSTON WY     Berkeley 94702 37.86725611742806 -122.28427811244116
19347 19347 19347 056 198400100 1128 Allston Way 1128 ALLSTON WAY 1128 ALLSTON WY 1128.0 ALLSTON WY     Berkeley 94702 37.86640527823176 -122.28978497377904
20423 20423 20423 056 198700500 1216 Allston Way 1216 ALLSTON WAY 1216 ALLSTON WY 1216.0 ALLSTON WY     Berkeley 94702 37.866560408946114 -122.28821043729177
20725 20725 20725 056 199703900 1409 Allston Way 1409 ALLSTON WAY 1409 ALLSTON WY 1409.0 ALLSTON WY     Berkeley 94702 37.86744036800267 -122.2834344704219
20855 20855 20855 056 198601000 1203 Allston Way 3 1203 ALLSTON WAY 3 1203 ALLSTON WY 1203.0 ALLSTON WY 3   Berkeley 94702 37.86694326873318 -122.2887125263653
21239 21239 21239 056 198303900 1112 Allston Way D 1112 ALLSTON WAY D 1112 ALLSTON WY 1112.0 ALLSTON WY D   Berkeley 94702 37.866270217442775 -122.29044880811276
22253 22253 22253 056 198303900 1112 Allston Way A 1112 ALLSTON WAY A 1112 ALLSTON WY 1112.0 ALLSTON WY A   Berkeley 94702 37.866270217442775 -122.29044880811276
22449 22449 22449 056 199402600 1333 Allston Way 1333 ALLSTON WAY 1333 ALLSTON WY 1333.0 ALLSTON WY     Berkeley 94702 37.8672377863092 -122.28442230282404
22472 22472 22472 056 199800100 1400 Allston Way 1400 ALLSTON WAY 1400 ALLSTON WY 1400.0 ALLSTON WY     Berkeley 94702 37.86695920365888 -122.2836083743794
23040 23040 23040 056 198400500 1144 Allston Way A 1144 ALLSTON WAY A 1144 ALLSTON WY 1144.0 ALLSTON WY A   Berkeley 94702 37.86649170895066 -122.28917978775527
23556 23556 23556 056 198901500 1245 Allston Way 1245 ALLSTON WAY 1245 ALLSTON WY 1245.0 ALLSTON WY     Berkeley 94702 37.86715012748672 -122.2871452940796
24309 24309 24309 056 198400200 1130 Allston Way 1130 ALLSTON WAY 1130 ALLSTON WY 1130.0 ALLSTON WY     Berkeley 94702 37.866375271836226 -122.289640426765
24691 24691 24691 056 199800400 1414 Allston Way 1414 ALLSTON WAY 1414 ALLSTON WY 1414.0 ALLSTON WY     Berkeley 94702 37.86695367855885 -122.28303735487918
25179 25179 25179 056 199800400 1416 Allston Way 1416 ALLSTON WAY 1416 ALLSTON WY 1416.0 ALLSTON WY     Berkeley 94702 37.86695367855885 -122.28303735487918
25508 25508 25508 056 199703500 1419 Allston Way 1419 ALLSTON WAY 1419 ALLSTON WY 1419.0 ALLSTON WY     Berkeley 94702 37.86751720329567 -122.28296265637005
25824 25824 25824 056 199800202 1408 Allston Way A 1408 ALLSTON WAY A 1408 ALLSTON WY 1408.0 ALLSTON WY A   Berkeley 94702 37.866927184879465 -122.28335815314858
26377 26377 26377 056 198800202 1230 Allston Way 1230 ALLSTON WAY 1230 ALLSTON WY 1230.0 ALLSTON WY     Berkeley 94702 37.86664051725542 -122.28760085221803
26559 26559 26559 056 198600900 1207 Allston Way 1207 ALLSTON WAY 1207 ALLSTON WY 1207.0 ALLSTON WY     Berkeley 94702 37.86696112974934 -122.28857354171949
26840 26840 26840 056 198700200 1204 Allston Way 1204 ALLSTON WAY 1204 ALLSTON WY 1204.0 ALLSTON WY     Berkeley 94702 37.86650713833669 -122.2886197097352
27116 27116 27116 056 198700400 1210 Allston Way B 1210 ALLSTON WAY B 1210 ALLSTON WY 1210.0 ALLSTON WY B   Berkeley 94702 37.86654206559832 -122.2883503705585
27716 27716 27716 056 198901800 1231 Allston Way 1231 ALLSTON WAY 1231 ALLSTON WY 1231.0 ALLSTON WY     Berkeley 94702 37.86709475179838 -122.28755547022818
28137 28137 28137 056 199800202 1406 Allston Way C 1406 ALLSTON WAY C 1406 ALLSTON WY 1406.0 ALLSTON WY C   Berkeley 94702 37.866927184879465 -122.28335815314858
28880 28880 28880 056 199000404 1255 Allston Way 1255 ALLSTON WAY 1255 ALLSTON WY 1255.0 ALLSTON WY     Berkeley 94702 37.86738060637595 -122.28664590444346
29074 29074 29074 056 199704000 1401 Allston Way 1401 ALLSTON WAY 1401 ALLSTON WY 1401.0 ALLSTON WY     Berkeley 94702 37.867307471342976 -122.2836529137495
30192 30192 30192 056 199703400 1423 Allston Way 1423 ALLSTON WAY 1423 ALLSTON WY 1423.0 ALLSTON WY     Berkeley 94702 37.867526508879834 -122.2828252689288
31289 31289 31289 056 199100200 1260 Allston Way 1260 ALLSTON WAY 1260 ALLSTON WY 1260.0 ALLSTON WY     Berkeley 94702 37.86625605955106 -122.28615119862324
31821 31821 31821 056 199800302 1410 Allston Way C 1410 ALLSTON WAY C 1410 ALLSTON WY 1410.0 ALLSTON WY C   Berkeley 94702 37.8669489973642 -122.28319906241008
32219 32219 32219 056 199801000 1436 Allston Way 1436 ALLSTON WAY 1436 ALLSTON WY 1436.0 ALLSTON WY     Berkeley 94702 37.86705678177841 -122.28224638108496
32349 32349 32349 056 198301000 1125 Allston Way 1125 ALLSTON WAY 1125 ALLSTON WY 1125.0 ALLSTON WY     Berkeley 94702 37.866688198823496 -122.29030195512335
32361 32361 32361 056 198400300 1134 Allston Way 1134 ALLSTON WAY 1134 ALLSTON WY 1134.0 ALLSTON WY     Berkeley 94702 37.86639181109746 -122.28950485571724
32419 32419 32419 056 199402800 1325 Allston Way 1325 ALLSTON WAY 1325 ALLSTON WY 1325.0 ALLSTON WY     Berkeley 94702 37.86720715193511 -122.28464680798324
33198 33198 33198 056 199800202 1406 Allston Way A 1406 ALLSTON WAY A 1406 ALLSTON WY 1406.0 ALLSTON WY A   Berkeley 94702 37.866927184879465 -122.28335815314858
34040 34040 34040 056 198601000 1203 Allston Way 1203 ALLSTON WAY 1203 ALLSTON WY 1203.0 ALLSTON WY     Berkeley 94702 37.86694326873318 -122.2887125263653
34394 34394 34394 056 198501800 1137 Allston Way 1137 ALLSTON WAY 1137 ALLSTON WY 1137.0 ALLSTON WY     Berkeley 94702 37.86682472398268 -122.28959326161927
34398 34398 34398 056 199703300 1429 Allston Way C 1429 ALLSTON WAY C 1429 ALLSTON WY 1429.0 ALLSTON WY C   Berkeley 94702 37.86755231375062 -122.28267128511268
35244 35244 35244 056 198400500 1144 Allston Way 1144 ALLSTON WAY 1144 ALLSTON WY 1144.0 ALLSTON WY     Berkeley 94702 37.86649170895066 -122.28917978775527
35596 35596 35596 056 198400500 1142 Allston Way A 1142 ALLSTON WAY A 1142 ALLSTON WY 1142.0 ALLSTON WY A   Berkeley 94702 37.86649170895066 -122.28917978775527
36772 36772 36772 056 199703400 1425 Allston Way 1425 ALLSTON WAY 1425 ALLSTON WY 1425.0 ALLSTON WY     Berkeley 94702 37.867526508879834 -122.2828252689288
37059 37059 37059 056 199800202 1408 Allston Way B 1408 ALLSTON WAY B 1408 ALLSTON WY 1408.0 ALLSTON WY B   Berkeley 94702 37.866927184879465 -122.28335815314858
37184 37184 37184 056 199804803 1408 Allston Way C 1408 ALLSTON WAY C 1408 ALLSTON WY 1408.0 ALLSTON WY C   Berkeley 94702 37.86662083005484 -122.28326691485844
37355 37355 37355 056 199800900 1432 Allston Way 1432 ALLSTON WAY 1432 ALLSTON WY 1432.0 ALLSTON WY     Berkeley 94702 37.86704006750302 -122.2823784828391
37554 37554 37554 056 199800202 1408 Allston Way D 1408 ALLSTON WAY D 1408 ALLSTON WY 1408.0 ALLSTON WY D   Berkeley 94702 37.866927184879465 -122.28335815314858
38507 38507 38507 056 199800302 1410 Allston Way A 1410 ALLSTON WAY A 1410 ALLSTON WY 1410.0 ALLSTON WY A   Berkeley 94702 37.8669489973642 -122.28319906241008
38905 38905 38905 056 198700400 1210 Allston Way A 1210 ALLSTON WAY A 1210 ALLSTON WY 1210.0 ALLSTON WY A   Berkeley 94702 37.86654206559832 -122.2883503705585
39262 39262 39262 056 198700400 1210 Allston Way C 1210 ALLSTON WAY C 1210 ALLSTON WY 1210.0 ALLSTON WY C   Berkeley 94702 37.86654206559832 -122.2883503705585
39478 39478 39478 056 199800600 1424 Allston Way 1424 ALLSTON WAY 1424 ALLSTON WY 1424.0 ALLSTON WY     Berkeley 94702 37.866993969726 -122.28273428396356
39538 39538 39538 056 199800700 1428 Allston Way 1428 ALLSTON WAY 1428 ALLSTON WY 1428.0 ALLSTON WY     Berkeley 94702 37.867008838058176 -122.28261594619622
40092 40092 40092 056 199703800 1413 Allston Way 1413 ALLSTON WAY 1413 ALLSTON WY 1413.0 ALLSTON WY     Berkeley 94702 37.86747753505661 -122.28330861555224
40588 40588 40588 056 199404400 1323 Allston Way 1323 ALLSTON WAY 1323 ALLSTON WY 1323.0 ALLSTON WY     Berkeley 94702 37.86717435034825 -122.28492583099867
40832 40832 40832 056 198901500 1243 Allston Way 1243 ALLSTON WAY 1243 ALLSTON WY 1243.0 ALLSTON WY     Berkeley 94702 37.86715012748672 -122.2871452940796
41580 41580 41580 056 199703500 1419 Allston Way B 1419 ALLSTON WAY B 1419 ALLSTON WY 1419.0 ALLSTON WY B   Berkeley 94702 37.86751720329567 -122.28296265637005
41609 41609 41609 056 199404901 1299 Allston Way 1299 ALLSTON WAY 1299 ALLSTON WY 1299.0 ALLSTON WY     Berkeley 94702 37.86751766283073 -122.28560104339375
41871 41871 41871 056 199800202 1406 Allston Way 1406 ALLSTON WAY 1406 ALLSTON WY 1406.0 ALLSTON WY     Berkeley 94702 37.866927184879465 -122.28335815314858
42114 42114 42114 056 199703300 1429 Allston Way A 1429 ALLSTON WAY A 1429 ALLSTON WY 1429.0 ALLSTON WY A   Berkeley 94702 37.86755231375062 -122.28267128511268
42253 42253 42253 056 199703700 1419 Allston Way A 1419 ALLSTON WAY A 1419 ALLSTON WY 1419.0 ALLSTON WY A   Berkeley 94702 37.86749470309471 -122.2831975343758
43083 43083 43083 056 199703400 1421 Allston Way 1421 ALLSTON WAY 1421 ALLSTON WY 1421.0 ALLSTON WY     Berkeley 94702 37.867526508879834 -122.2828252689288
43116 43116 43116 056 199800302 1410 Allston Way D 1410 ALLSTON WAY D 1410 ALLSTON WY 1410.0 ALLSTON WY D   Berkeley 94702 37.8669489973642 -122.28319906241008
43163 43163 43163 056 199804803 1408 Allston Way 1408 ALLSTON WAY 1408 ALLSTON WY 1408.0 ALLSTON WY     Berkeley 94702 37.86662083005484 -122.28326691485844
43401 43401 43401 056 198400400 1138 Allston Way 1138 ALLSTON WAY 1138 ALLSTON WY 1138.0 ALLSTON WY     Berkeley 94702 37.86641037432528 -122.28936926310996
44189 44189 44189 056 199404901 1309 Allston Way 1309 ALLSTON WAY 1309 ALLSTON WY 1309.0 ALLSTON WY     Berkeley 94702 37.86751766283073 -122.28560104339375
44615 44615 44615 056 198501700 1139 Allston Way 1139 ALLSTON WAY 1139 ALLSTON WY 1139.0 ALLSTON WY     Berkeley 94702 37.86684349205026 -122.28945766631706
45160 45160 45160 056 199800302 1410 Allston Way 1410 ALLSTON WAY 1410 ALLSTON WY 1410.0 ALLSTON WY     Berkeley 94702 37.8669489973642 -122.28319906241008
46124 46124 46124 056 198800203 1234 Allston Way 1234 ALLSTON WAY 1234 ALLSTON WY 1234.0 ALLSTON WY     Berkeley 94702 37.866659469753415 -122.28746870554818
46258 46258 46258 056 199703300 1429 Allston Way 1429 ALLSTON WAY 1429 ALLSTON WY 1429.0 ALLSTON WY     Berkeley 94702 37.86755231375062 -122.28267128511268
46766 46766 46766 056 199804803 1408 Allston Way 4 1408 ALLSTON WAY 4 1408 ALLSTON WY 1408.0 ALLSTON WY 4   Berkeley 94702 37.86662083005484 -122.28326691485844

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