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

648 rows where street_type = "WY" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

street_name 6

zipcode 1

  • 94702 · 648 ✖

street_type 1

  • WY · 648 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
41 41 41 057 207500500 1435 Berkeley Way 1435 BERKELEY WAY 1435 BERKELEY WY 1435.0 BERKELEY WY     Berkeley 94702 37.87129018445151 -122.2828227940702
61 61 61 057 207201501 1440 Berkeley Way 1440 BERKELEY WAY 1440 BERKELEY WY 1440.0 BERKELEY WY     Berkeley 94702 37.87090866835336 -122.28249569501736
87 87 87 056 192002100 1315 Dwight Way 1315 DWIGHT WAY 1315 DWIGHT WY 1315.0 DWIGHT WY     Berkeley 94702 37.862281240176614 -122.28538183110828
179 179 179 056 191905501 1451 Dwight Way 1451 DWIGHT WAY 1451 DWIGHT WY 1451.0 DWIGHT WY     Berkeley 94702 37.86236048506624 -122.28153078312964
224 224 224 057 208101400 1271 Berkeley Way 1271 BERKELEY WAY 1271 BERKELEY WY 1271.0 BERKELEY WY     Berkeley 94702 37.870714417816 -122.28731088862074
406 406 406 056 192002100 1321 Dwight Way K 1321 DWIGHT WAY K 1321 DWIGHT WY 1321.0 DWIGHT WY K   Berkeley 94702 37.862281240176614 -122.28538183110828
478 478 478 056 193102400 1225 Dwight Way 1225 DWIGHT WAY 1225 DWIGHT WY 1225.0 DWIGHT WY     Berkeley 94702 37.861691947917585 -122.2867133095308
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
623 623 623 056 199802600 1429 Bancroft Way 1429 BANCROFT WAY 1429 BANCROFT WY 1429.0 BANCROFT WY     Berkeley 94702 37.866010366083096 -122.28242825040414
628 628 628 056 198401900 1129 Bancroft Way B 1129 BANCROFT WAY B 1129 BANCROFT WY 1129.0 BANCROFT WY B   Berkeley 94702 37.86505204231807 -122.28914160755906
633 633 633 059 228601400 1544 Juanita Way 1544 JUANITA WAY 1544 JUANITA WY 1544.0 JUANITA WY     Berkeley 94702 37.87679890606605 -122.2867734759936
710 710 710 056 192602301 1114 Bancroft Way 1114 BANCROFT WAY 1114 BANCROFT WY 1114.0 BANCROFT WY     Berkeley 94702 37.86442239881587 -122.28982787192712
711 711 711 056 191500600 1466 Bancroft Way 1466 BANCROFT WAY 1466 BANCROFT WY 1466.0 BANCROFT WY     Berkeley 94702 37.865629272973614 -122.2817702802726
762 762 762 054 178302800 1322 Dwight Way 3 1322 DWIGHT WAY 3 1322 DWIGHT WY 1322.0 DWIGHT WY 3   Berkeley 94702 37.861514893577535 -122.28429506005732
774 774 774 056 192002100 1315 Dwight Way G 1315 DWIGHT WAY G 1315 DWIGHT WY 1315.0 DWIGHT WY G   Berkeley 94702 37.862281240176614 -122.28538183110828
1049 1049 1049 056 192002100 1321 Dwight Way B 1321 DWIGHT WAY B 1321 DWIGHT WY 1321.0 DWIGHT WY B   Berkeley 94702 37.862281240176614 -122.28538183110828
1055 1055 1055 056 198702000 1215 Bancroft Way 1215 BANCROFT WAY 1215 BANCROFT WY 1215.0 BANCROFT WY     Berkeley 94702 37.86516145778813 -122.28792729190748
1064 1064 1064 054 178302400 1310 Dwight Way 1310 DWIGHT WAY 1310 DWIGHT WY 1310.0 DWIGHT WY     Berkeley 94702 37.861453386725934 -122.28477087700206
1418 1418 1418 056 192602900 1134 Bancroft Way 1134 BANCROFT WAY 1134 BANCROFT WY 1134.0 BANCROFT WY     Berkeley 94702 37.864623664906595 -122.28901088561724
1596 1596 1596 054 178102201 1114 Dwight Way 6 1114 DWIGHT WAY 6 1114 DWIGHT WY 1114.0 DWIGHT WY 6   Berkeley 94702 37.86095366691979 -122.2886487091492
1652 1652 1652 056 192502000 1205 Channing Way 1205 CHANNING WAY 1205 CHANNING WY 1205.0 CHANNING WY     Berkeley 94702 37.86336935016185 -122.28797324971738
1810 1810 1810 056 199703700 1415 Allston Way 1415 ALLSTON WAY 1415 ALLSTON WY 1415.0 ALLSTON WY     Berkeley 94702 37.86749470309471 -122.2831975343758
1864 1864 1864 056 192002100 1321 Dwight Way 1321 DWIGHT WAY 1321 DWIGHT WY 1321.0 DWIGHT WY     Berkeley 94702 37.862281240176614 -122.28538183110828
1968 1968 1968 054 178102700 1132 Dwight Way 1132 DWIGHT WAY 1132 DWIGHT WY 1132.0 DWIGHT WY     Berkeley 94702 37.861054055124534 -122.28792617619987
1985 1985 1985 056 192002100 1315 Dwight Way B 1315 DWIGHT WAY B 1315 DWIGHT WY 1315.0 DWIGHT WY B   Berkeley 94702 37.862281240176614 -122.28538183110828
2054 2054 2054 056 198901900 1229 Allston Way 1229 ALLSTON WAY 1229 ALLSTON WY 1229.0 ALLSTON WY     Berkeley 94702 37.86707558595424 -122.2876936302206
2239 2239 2239 057 207500600 1433 Berkeley Way A 1433 BERKELEY WAY A 1433 BERKELEY WY 1433.0 BERKELEY WY A   Berkeley 94702 37.87127507729975 -122.28294026855652
2243 2243 2243 056 191702000 1349 Channing Way 1349 CHANNING WAY 1349 CHANNING WY 1349.0 CHANNING WY     Berkeley 94702 37.86388433246556 -122.28390077330944
2322 2322 2322 054 178102300 1118 Dwight Way A 1118 DWIGHT WAY A 1118 DWIGHT WY 1118.0 DWIGHT WY A   Berkeley 94702 37.860982508852864 -122.28842677317174
2403 2403 2403 056 198802000 1231 Bancroft Way 1231 BANCROFT WAY 1231 BANCROFT WY 1231.0 BANCROFT WY     Berkeley 94702 37.86530614560503 -122.2871814476765
2432 2432 2432 054 179602500 1410 Dwight Way 1410 DWIGHT WAY 1410 DWIGHT WY 1410.0 DWIGHT WY     Berkeley 94702 37.86172946751362 -122.28260954659817
2443 2443 2443 057 207400400 1387 Berkeley Way B 1387 BERKELEY WAY B 1387 BERKELEY WY 1387.0 BERKELEY WY B   Berkeley 94702 37.871035013292904 -122.2848186206628
2521 2521 2521 056 192100302 1336 Channing Way 1336 CHANNING WAY 1336 CHANNING WY 1336.0 CHANNING WY     Berkeley 94702 37.86340052724997 -122.28444698134156
2536 2536 2536 056 191602200 1407 Channing Way 1407 CHANNING WAY 1407 CHANNING WY 1407.0 CHANNING WY     Berkeley 94702 37.8640202592965 -122.28285076760814
2693 2693 2693 057 207501300 1415 Berkeley Way 1415 BERKELEY WAY 1415 BERKELEY WY 1415.0 BERKELEY WY     Berkeley 94702 37.87116900520811 -122.28378057513116
2705 2705 2705 056 192701100 1117 Channing Way 1117 CHANNING WAY 1117 CHANNING WY 1117.0 CHANNING WY     Berkeley 94702 37.86322525568899 -122.2892898313776
2707 2707 2707 056 192002100 1315 Dwight Way F 1315 DWIGHT WAY F 1315 DWIGHT WY 1315.0 DWIGHT WY F   Berkeley 94702 37.862281240176614 -122.28538183110828
2783 2783 2783 054 178102401 1124 Dwight Way 1124 DWIGHT WAY 1124 DWIGHT WY 1124.0 DWIGHT WY     Berkeley 94702 37.861005079836765 -122.28824892201683
2790 2790 2790 056 191905501 1445 Dwight Way 1445 DWIGHT WAY 1445 DWIGHT WY 1445.0 DWIGHT WY     Berkeley 94702 37.86236048506624 -122.28153078312964
2966 2966 2966 056 198700100 1200 Allston Way 1200 ALLSTON WAY 1200 ALLSTON WY 1200.0 ALLSTON WY     Berkeley 94702 37.86648837018345 -122.28875615035211
2981 2981 2981 057 207301700 1360 Berkeley Way 17 1360 BERKELEY WAY 17 1360 BERKELEY WY 1360.0 BERKELEY WY 17   Berkeley 94702 37.87055738828812 -122.28523331443898
3012 3012 3012 056 191602200 1405 Channing Way 1405 CHANNING WAY 1405 CHANNING WY 1405.0 CHANNING WY     Berkeley 94702 37.8640202592965 -122.28285076760814
3052 3052 3052 056 198800400 1236 Allston Way 1236 ALLSTON WAY 1236 ALLSTON WY 1236.0 ALLSTON WY     Berkeley 94702 37.86667856691658 -122.28732886301124
3169 3169 3169 057 207400400 1387 Berkeley Way 1387 BERKELEY WAY 1387 BERKELEY WY 1387.0 BERKELEY WY     Berkeley 94702 37.871035013292904 -122.2848186206628
3177 3177 3177 057 207301700 1360 Berkeley Way 6 1360 BERKELEY WAY 6 1360 BERKELEY WY 1360.0 BERKELEY WY 6   Berkeley 94702 37.87055738828812 -122.28523331443898
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
3404 3404 3404 057 207301700 1360 Berkeley Way 16 1360 BERKELEY WAY 16 1360 BERKELEY WY 1360.0 BERKELEY WY 16   Berkeley 94702 37.87055738828812 -122.28523331443898
3417 3417 3417 054 178202100 1210 Dwight Way 1210 DWIGHT WAY 1210 DWIGHT WY 1210.0 DWIGHT WY     Berkeley 94702 37.86120038362962 -122.28674387021678
3430 3430 3430 059 228601600 1556 Juanita Way 1556 JUANITA WAY 1556 JUANITA WY 1556.0 JUANITA WY     Berkeley 94702 37.87657812837899 -122.28702388048072
3473 3473 3473 056 192002100 1321 Dwight Way H 1321 DWIGHT WAY H 1321 DWIGHT WY 1321.0 DWIGHT WY H   Berkeley 94702 37.862281240176614 -122.28538183110828
3616 3616 3616 056 192002100 1321 Dwight Way C 1321 DWIGHT WAY C 1321 DWIGHT WY 1321.0 DWIGHT WY C   Berkeley 94702 37.862281240176614 -122.28538183110828
3630 3630 3630 054 178202400 1218 Dwight Way 1218 DWIGHT WAY 1218 DWIGHT WY 1218.0 DWIGHT WY     Berkeley 94702 37.86124621694588 -122.28638126974391
3631 3631 3631 056 199800500 1418 Allston Way 1418 ALLSTON WAY 1418 ALLSTON WY 1418.0 ALLSTON WY     Berkeley 94702 37.86697576406395 -122.28287506434162
3658 3658 3658 056 192500400 1216 Bancroft Way 1216 BANCROFT WAY 1216 BANCROFT WY 1216.0 BANCROFT WY     Berkeley 94702 37.8647739499618 -122.28784253406376
3720 3720 3720 056 192002200 1307 Dwight Way 1307 DWIGHT WAY 1307 DWIGHT WY 1307.0 DWIGHT WY     Berkeley 94702 37.86184248221154 -122.28555805361756
3863 3863 3863 057 208101400 1275 Berkeley Way 1275 BERKELEY WAY 1275 BERKELEY WY 1275.0 BERKELEY WY     Berkeley 94702 37.870714417816 -122.28731088862074
3901 3901 3901 056 193103700 1236 Channing Way 1236 CHANNING WAY 1236 CHANNING WY 1236.0 CHANNING WY     Berkeley 94702 37.86310625106843 -122.28652733041925
3914 3914 3914 057 207500600 1433 Berkeley Way 1433 BERKELEY WAY 1433 BERKELEY WY 1433.0 BERKELEY WY     Berkeley 94702 37.87127507729975 -122.28294026855652
3946 3946 3946 056 199800800 1430 Allston Way 1430 ALLSTON WAY 1430 ALLSTON WY 1430.0 ALLSTON WY     Berkeley 94702 37.867024428316135 -122.28249505362024
3974 3974 3974 056 192100302 1340 Channing Way 1340 CHANNING WAY 1340 CHANNING WY 1340.0 CHANNING WY     Berkeley 94702 37.86340052724997 -122.28444698134156
4028 4028 4028 056 198801800 1245 Bancroft Way 1245 BANCROFT WAY 1245 BANCROFT WY 1245.0 BANCROFT WY     Berkeley 94702 37.86534014228258 -122.2869068470672
4158 4158 4158 057 207500800 1427 Berkeley Way 1427 BERKELEY WAY 1427 BERKELEY WY 1427.0 BERKELEY WY     Berkeley 94702 37.87124368158766 -122.2831768632428
4162 4162 4162 054 178102800 1136 Dwight Way 1136 DWIGHT WAY 1136 DWIGHT WY 1136.0 DWIGHT WY     Berkeley 94702 37.86106627713286 -122.28776795592889
4222 4222 4222 056 191700100 1328 Bancroft Way 1328 BANCROFT WAY 1328 BANCROFT WY 1328.0 BANCROFT WY     Berkeley 94702 37.86528031299875 -122.2845537434181
4229 4229 4229 057 207400300 1393 Berkeley Way 2 1393 BERKELEY WAY 2 1393 BERKELEY WY 1393.0 BERKELEY WY 2   Berkeley 94702 37.87105055944232 -122.28470117941414
4440 4440 4440 056 192501700 1217 Channing Way 1217 CHANNING WAY 1217 CHANNING WY 1217.0 CHANNING WY     Berkeley 94702 37.8634197436939 -122.28756739985518
4504 4504 4504 057 207201800 1434 Berkeley Way 1434 BERKELEY WAY 1434 BERKELEY WY 1434.0 BERKELEY WY     Berkeley 94702 37.870885555793485 -122.28267276553628
4638 4638 4638 056 199301501 1325 Bancroft Way 1325 BANCROFT WAY 1325 BANCROFT WY 1325.0 BANCROFT WY     Berkeley 94702 37.866162068781925 -122.28492231499268
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
4886 4886 4886 056 198401700 1141 Bancroft Way 1141 BANCROFT WAY 1141 BANCROFT WY 1141.0 BANCROFT WY     Berkeley 94702 37.86509196929602 -122.28882124317592
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
5032 5032 5032 057 207400700 1365 Berkeley Way 1365 BERKELEY WAY 1365 BERKELEY WY 1365.0 BERKELEY WY     Berkeley 94702 37.87098532842126 -122.28517253802012
5091 5091 5091 057 207300902 1320 Berkeley Way 1320 BERKELEY WAY 1320 BERKELEY WY 1320.0 BERKELEY WY     Berkeley 94702 37.87044724617068 -122.28609171398176
5174 5174 5174 057 208102200 1250 Berkeley Way 1 1250 BERKELEY WAY 1 1250 BERKELEY WY 1250.0 BERKELEY WY 1   Berkeley 94702 37.87028984732456 -122.2873362309932
5216 5216 5216 056 192602700 1128 Bancroft Way 4 1128 BANCROFT WAY 4 1128 BANCROFT WY 1128.0 BANCROFT WY 4   Berkeley 94702 37.8644661479513 -122.28927991577346
5286 5286 5286 054 178302800 1322 Dwight Way 1322 DWIGHT WAY 1322 DWIGHT WY 1322.0 DWIGHT WY     Berkeley 94702 37.861514893577535 -122.28429506005732
5314 5314 5314 056 193001800 1219 Dwight Way 1219 DWIGHT WAY 1219 DWIGHT WY 1219.0 DWIGHT WY     Berkeley 94702 37.86165119569835 -122.2870501220668
5328 5328 5328 056 198303900 1112 Allston Way 1112 ALLSTON WAY 1112 ALLSTON WY 1112.0 ALLSTON WY     Berkeley 94702 37.866270217442775 -122.29044880811276
5411 5411 5411 057 207302100 1384 Berkeley Way 1384 BERKELEY WAY 1384 BERKELEY WY 1384.0 BERKELEY WY     Berkeley 94702 37.870622091386906 -122.28472895352606
5461 5461 5461 054 179603200 1480 Dwight Way 1480 DWIGHT WAY 1480 DWIGHT WY 1480.0 DWIGHT WY     Berkeley 94702 37.8618606579364 -122.2816131460648
5488 5488 5488 056 192402001 1235 Channing Way 1235 CHANNING WAY 1235 CHANNING WY 1235.0 CHANNING WY     Berkeley 94702 37.86358776041816 -122.28665156293144
5612 5612 5612 054 179603100 1470 Dwight Way 1470 DWIGHT WAY 1470 DWIGHT WY 1470.0 DWIGHT WY     Berkeley 94702 37.861840445349976 -122.28177025332316
5771 5771 5771 056 191902102 1429 Dwight Way 4 1429 DWIGHT WAY 4 1429 DWIGHT WY 1429.0 DWIGHT WY 4   Berkeley 94702 37.86223254726061 -122.28277836249792
5782 5782 5782 056 193103700 1336 Channing Way D 1336 CHANNING WAY D 1336 CHANNING WY 1336.0 CHANNING WY D   Berkeley 94702 37.86310625106843 -122.28652733041925
6089 6089 6089 057 207201200 1424 Berkeley Way B 1424 BERKELEY WAY B 1424 BERKELEY WY 1424.0 BERKELEY WY B   Berkeley 94702 37.87084213737681 -122.28302338338156
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
6199 6199 6199 056 192701300 1111 Channing Way 1111 CHANNING WAY 1111 CHANNING WY 1111.0 CHANNING WY     Berkeley 94702 37.86319257927656 -122.28953076402836
6295 6295 6295 057 207500600 1433 Berkeley Way C 1433 BERKELEY WAY C 1433 BERKELEY WY 1433.0 BERKELEY WY C   Berkeley 94702 37.87127507729975 -122.28294026855652
6386 6386 6386 059 228601800 1568 Juanita Way 1568 JUANITA WAY 1568 JUANITA WY 1568.0 JUANITA WY     Berkeley 94702 37.87632349032376 -122.28693680947518
6457 6457 6457 054 179602200 1402 Dwight Way 1402 DWIGHT WAY 1402 DWIGHT WY 1402.0 DWIGHT WY     Berkeley 94702 37.8617486070889 -122.28301360701631
6594 6594 6594 057 207301300 1328 Berkeley Way 1328 BERKELEY WAY 1328 BERKELEY WY 1328.0 BERKELEY WY     Berkeley 94702 37.87046957456959 -122.28591728091652
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
6999 6999 6999 054 178200100 1240 Dwight Way 1240 DWIGHT WAY 1240 DWIGHT WY 1240.0 DWIGHT WY     Berkeley 94702 37.86138960323325 -122.28558606757969
7050 7050 7050 056 191803100 1411 Dwight Way 1411 DWIGHT WAY 1411 DWIGHT WY 1411.0 DWIGHT WY     Berkeley 94702 37.86213485069769 -122.28353133665728
7060 7060 7060 059 228600900 1512 Juanita Way 1512 JUANITA WAY 1512 JUANITA WY 1512.0 JUANITA WY     Berkeley 94702 37.87728365074528 -122.28659074249512
7162 7162 7162 056 198401900 1129 Bancroft Way A 1129 BANCROFT WAY A 1129 BANCROFT WY 1129.0 BANCROFT WY A   Berkeley 94702 37.86505204231807 -122.28914160755906
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

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