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

113 rows where street_name = "BANCROFT" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94702 · 113 ✖

street_type 1

street_name 1

  • BANCROFT · 113 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
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
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
1055 1055 1055 056 198702000 1215 Bancroft Way 1215 BANCROFT WAY 1215 BANCROFT WY 1215.0 BANCROFT WY     Berkeley 94702 37.86516145778813 -122.28792729190748
1418 1418 1418 056 192602900 1134 Bancroft Way 1134 BANCROFT WAY 1134 BANCROFT WY 1134.0 BANCROFT WY     Berkeley 94702 37.864623664906595 -122.28901088561724
2403 2403 2403 056 198802000 1231 Bancroft Way 1231 BANCROFT WAY 1231 BANCROFT WY 1231.0 BANCROFT WY     Berkeley 94702 37.86530614560503 -122.2871814476765
3658 3658 3658 056 192500400 1216 Bancroft Way 1216 BANCROFT WAY 1216 BANCROFT WY 1216.0 BANCROFT WY     Berkeley 94702 37.8647739499618 -122.28784253406376
4028 4028 4028 056 198801800 1245 Bancroft Way 1245 BANCROFT WAY 1245 BANCROFT WY 1245.0 BANCROFT WY     Berkeley 94702 37.86534014228258 -122.2869068470672
4222 4222 4222 056 191700100 1328 Bancroft Way 1328 BANCROFT WAY 1328 BANCROFT WY 1328.0 BANCROFT WY     Berkeley 94702 37.86528031299875 -122.2845537434181
4638 4638 4638 056 199301501 1325 Bancroft Way 1325 BANCROFT WAY 1325 BANCROFT WY 1325.0 BANCROFT WY     Berkeley 94702 37.866162068781925 -122.28492231499268
4886 4886 4886 056 198401700 1141 Bancroft Way 1141 BANCROFT WAY 1141 BANCROFT WY 1141.0 BANCROFT WY     Berkeley 94702 37.86509196929602 -122.28882124317592
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
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
7530 7530 7530 056 199802800 1425 Bancroft Way 1425 BANCROFT WAY 1425 BANCROFT WY 1425.0 BANCROFT WY     Berkeley 94702 37.865983958583726 -122.28263035966498
8182 8182 8182 056 191500200 1452 Bancroft Way 1452 BANCROFT WAY 1452 BANCROFT WY 1452.0 BANCROFT WY     Berkeley 94702 37.86548907347316 -122.28229262994904
8283 8283 8283 056 192602700 1128 Bancroft Way 11 1128 BANCROFT WAY 11 1128 BANCROFT WY 1128.0 BANCROFT WY 11   Berkeley 94702 37.8644661479513 -122.28927991577346
8942 8942 8942 056 192602700 1128 Bancroft Way 9 1128 BANCROFT WAY 9 1128 BANCROFT WY 1128.0 BANCROFT WY 9   Berkeley 94702 37.8644661479513 -122.28927991577346
9749 9749 9749 056 192602800 1130 Bancroft Way F 1130 BANCROFT WAY F 1130 BANCROFT WY 1130.0 BANCROFT WY F   Berkeley 94702 37.86448486910401 -122.2891245162125
11351 11351 11351 056 199802200 1437 Bancroft Way B 1437 BANCROFT WAY B 1437 BANCROFT WY 1437.0 BANCROFT WY B   Berkeley 94702 37.86596923684376 -122.28196558389683
12775 12775 12775 056 199803300 1401 Bancroft Way 1401 BANCROFT WAY 1401 BANCROFT WY 1401.0 BANCROFT WY     Berkeley 94702 37.86570308197154 -122.28350880690994
13355 13355 13355 056 199803000 1421 Bancroft Way 1421 BANCROFT WAY 1421 BANCROFT WY 1421.0 BANCROFT WY     Berkeley 94702 37.8657796120029 -122.28293722686097
15006 15006 15006 056 199802200 1437 Bancroft Way C 1437 BANCROFT WAY C 1437 BANCROFT WY 1437.0 BANCROFT WY C   Berkeley 94702 37.86596923684376 -122.28196558389683
15020 15020 15020 056 191500500 1460 Bancroft Way 1460 BANCROFT WAY 1460 BANCROFT WY 1460.0 BANCROFT WY     Berkeley 94702 37.86553672954673 -122.2819326498619
16608 16608 16608 056 192203402 1308 Bancroft Way 1308 BANCROFT WAY 1308 BANCROFT WY 1308.0 BANCROFT WY     Berkeley 94702 37.86486940767663 -122.28578662814498
17444 17444 17444 056 192300300 1322 Bancroft Way 1322 BANCROFT WAY 1322 BANCROFT WY 1322.0 BANCROFT WY     Berkeley 94702 37.86519887491414 -122.28481374640404
18519 18519 18519 056 198702500 1201 Bancroft Way 1201 BANCROFT WAY 1201 BANCROFT WY 1201.0 BANCROFT WY     Berkeley 94702 37.8651346691539 -122.28849313172178
19723 19723 19723 056 192500300 1212 Bancroft Way 1212 BANCROFT WAY 1212 BANCROFT WY 1212.0 BANCROFT WY     Berkeley 94702 37.8647566096669 -122.2879816085411
20410 20410 20410 056 191500400 1458 Bancroft Way 1458 BANCROFT WAY 1458 BANCROFT WY 1458.0 BANCROFT WY     Berkeley 94702 37.86552073261493 -122.28205271598782
20968 20968 20968 056 199803100 1419 Bancroft Way 1419 BANCROFT WAY 1419 BANCROFT WY 1419.0 BANCROFT WY     Berkeley 94702 37.86575231724171 -122.28314015897864
21388 21388 21388 056 192602402 1120 Bancroft Way A 1120 BANCROFT WAY A 1120 BANCROFT WY 1120.0 BANCROFT WY A   Berkeley 94702 37.86441292547116 -122.28966844521868
22008 22008 22008 056 198702100 1211 Bancroft Way 1211 BANCROFT WAY 1211 BANCROFT WY 1211.0 BANCROFT WY     Berkeley 94702 37.86519280786757 -122.28805619565917
22163 22163 22163 056 192200100 1306 Bancroft Way 1306 BANCROFT WAY 1306 BANCROFT WY 1306.0 BANCROFT WY     Berkeley 94702 37.86505002256557 -122.2862519231228
23611 23611 23611 056 191500300 1454 Bancroft Way 1454 BANCROFT WAY 1454 BANCROFT WY 1454.0 BANCROFT WY     Berkeley 94702 37.86550560655073 -122.28217094236406
23905 23905 23905 056 192500200 1208 Bancroft Way 1208 BANCROFT WAY 1208 BANCROFT WY 1208.0 BANCROFT WY     Berkeley 94702 37.86473913816855 -122.28811714096128
23954 23954 23954 056 199803200 1415 Bancroft Way 1415 BANCROFT WAY 1415 BANCROFT WY 1415.0 BANCROFT WY     Berkeley 94702 37.8657297470025 -122.2833111218519
24433 24433 24433 056 192300400 1324 Bancroft Way 1324 BANCROFT WAY 1324 BANCROFT WY 1324.0 BANCROFT WY     Berkeley 94702 37.865189997381634 -122.284656474754
24674 24674 24674 056 192602800 1130 Bancroft Way C 1130 BANCROFT WAY C 1130 BANCROFT WY 1130.0 BANCROFT WY C   Berkeley 94702 37.86448486910401 -122.2891245162125
24700 24700 24700 056 198701900 1219 Bancroft Way 1219 BANCROFT WAY 1219 BANCROFT WY 1219.0 BANCROFT WY     Berkeley 94702 37.86517665271365 -122.28779171277488
25340 25340 25340 056 192300100 1318 Bancroft Way 1318 BANCROFT WAY 1318 BANCROFT WY 1318.0 BANCROFT WY     Berkeley 94702 37.865208083633235 -122.28511760154892
26205 26205 26205 056 192200100 1304 Bancroft Way 1304 BANCROFT WAY 1304 BANCROFT WY 1304.0 BANCROFT WY     Berkeley 94702 37.86505002256557 -122.2862519231228
26400 26400 26400 056 192400300 1266 Bancroft Way 1266 BANCROFT WAY 1266 BANCROFT WY 1266.0 BANCROFT WY     Berkeley 94702 37.86488193329232 -122.2871539421608
27045 27045 27045 056 198401900 1129 Bancroft Way 1129 BANCROFT WAY 1129 BANCROFT WY 1129.0 BANCROFT WY     Berkeley 94702 37.86505204231807 -122.28914160755906
27205 27205 27205 056 191600300 1418 Bancroft Way 1418 BANCROFT WAY 1418 BANCROFT WY 1418.0 BANCROFT WY     Berkeley 94702 37.86545706256513 -122.28317633054183
27549 27549 27549 056 199802200 1437 Bancroft Way A 1437 BANCROFT WAY A 1437 BANCROFT WY 1437.0 BANCROFT WY A   Berkeley 94702 37.86596923684376 -122.28196558389683
27614 27614 27614 056 192602700 1128 Bancroft Way 12 1128 BANCROFT WAY 12 1128 BANCROFT WY 1128.0 BANCROFT WY 12   Berkeley 94702 37.8644661479513 -122.28927991577346
27636 27636 27636 056 198802000 1229 Bancroft Way 1229 BANCROFT WAY 1229 BANCROFT WY 1229.0 BANCROFT WY     Berkeley 94702 37.86530614560503 -122.2871814476765
27930 27930 27930 056 198302200 1115 Bancroft Way 1115 BANCROFT WAY 1115 BANCROFT WY 1115.0 BANCROFT WY     Berkeley 94702 37.864940940955584 -122.28999305593815
28501 28501 28501 056 192602700 1128 Bancroft Way 10 1128 BANCROFT WAY 10 1128 BANCROFT WY 1128.0 BANCROFT WY 10   Berkeley 94702 37.8644661479513 -122.28927991577346
28769 28769 28769 056 199802500 1431 Bancroft Way A 1431 BANCROFT WAY A 1431 BANCROFT WY 1431.0 BANCROFT WY A   Berkeley 94702 37.86602270641057 -122.28232898387031
28852 28852 28852 056 192602301 1116 Bancroft Way 1116 BANCROFT WAY 1116 BANCROFT WY 1116.0 BANCROFT WY     Berkeley 94702 37.86442239881587 -122.28982787192712
29228 29228 29228 056 192602500 1122 Bancroft Way 1122 BANCROFT WAY 1122 BANCROFT WY 1122.0 BANCROFT WY     Berkeley 94702 37.86443207995168 -122.2895372013557
29431 29431 29431 056 198702200 1209 Bancroft Way 1209 BANCROFT WAY 1209 BANCROFT WY 1209.0 BANCROFT WY     Berkeley 94702 37.86517880366121 -122.2881597992592
30001 30001 30001 056 191700100 1326 Bancroft Way 1326 BANCROFT WAY 1326 BANCROFT WY 1326.0 BANCROFT WY     Berkeley 94702 37.86528031299875 -122.2845537434181
30285 30285 30285 056 198401800 1137 Bancroft Way A 1137 BANCROFT WAY A 1137 BANCROFT WY 1137.0 BANCROFT WY A   Berkeley 94702 37.865075186493456 -122.28895939867674
30311 30311 30311 056 192602700 1128 Bancroft Way 2 1128 BANCROFT WAY 2 1128 BANCROFT WY 1128.0 BANCROFT WY 2   Berkeley 94702 37.8644661479513 -122.28927991577346
31463 31463 31463 056 199802900 1423 Bancroft Way 1423 BANCROFT WAY 1423 BANCROFT WY 1423.0 BANCROFT WY     Berkeley 94702 37.86580290984089 -122.28275759524516
31670 31670 31670 056 192602402 1120 Bancroft Way 1120 BANCROFT WAY 1120 BANCROFT WY 1120.0 BANCROFT WY     Berkeley 94702 37.86441292547116 -122.28966844521868
32779 32779 32779 056 191600300 1420 Bancroft Way 1420 BANCROFT WAY 1420 BANCROFT WY 1420.0 BANCROFT WY     Berkeley 94702 37.86545706256513 -122.28317633054183
33285 33285 33285 056 192602700 1128 Bancroft Way 1 1128 BANCROFT WAY 1 1128 BANCROFT WY 1128.0 BANCROFT WY 1   Berkeley 94702 37.8644661479513 -122.28927991577346
33297 33297 33297 056 198801700 1249 Bancroft Way 1249 BANCROFT WAY 1249 BANCROFT WY 1249.0 BANCROFT WY     Berkeley 94702 37.86535737109896 -122.28677211684256
34446 34446 34446 056 191500100 1450 Bancroft Way 1450 BANCROFT WAY 1450 BANCROFT WY 1450.0 BANCROFT WY     Berkeley 94702 37.86547562106414 -122.28242231703167
34783 34783 34783 056 199802100 1465 Bancroft Way 1465 BANCROFT WAY 1465 BANCROFT WY 1465.0 BANCROFT WY     Berkeley 94702 37.865924826940955 -122.28179123796816
35735 35735 35735 056 198702300 1207 Bancroft Way 1207 BANCROFT WAY 1207 BANCROFT WY 1207.0 BANCROFT WY     Berkeley 94702 37.86516301586031 -122.28827121999882
36454 36454 36454 056 192602600 1124 Bancroft Way 1124 BANCROFT WAY 1124 BANCROFT WY 1124.0 BANCROFT WY     Berkeley 94702 37.864443144003985 -122.28942072310102
36653 36653 36653 056 192400500 1280 Bancroft Way 1280 BANCROFT WAY 1280 BANCROFT WY 1280.0 BANCROFT WY     Berkeley 94702 37.86491266224541 -122.2869138772826
36909 36909 36909 056 192602800 1130 Bancroft Way A 1130 BANCROFT WAY A 1130 BANCROFT WY 1130.0 BANCROFT WY A   Berkeley 94702 37.86448486910401 -122.2891245162125
38821 38821 38821 056 198802100 1227 Bancroft Way 1227 BANCROFT WAY 1227 BANCROFT WY 1227.0 BANCROFT WY     Berkeley 94702 37.86528957702372 -122.28732133782414
40036 40036 40036 056 198401800 1137 Bancroft Way 1137 BANCROFT WAY 1137 BANCROFT WY 1137.0 BANCROFT WY     Berkeley 94702 37.865075186493456 -122.28895939867674
40410 40410 40410 056 192200201 1312 Bancroft Way 1312 BANCROFT WAY 1312 BANCROFT WY 1312.0 BANCROFT WY     Berkeley 94702 37.86506823792272 -122.2855642115688
41073 41073 41073 056 199802400 1433 Bancroft Way 1433 BANCROFT WAY 1433 BANCROFT WY 1433.0 BANCROFT WY     Berkeley 94702 37.86598843914356 -122.282212834399
41697 41697 41697 056 198702400 1205 Bancroft Way 1205 BANCROFT WAY 1205 BANCROFT WY 1205.0 BANCROFT WY     Berkeley 94702 37.865149086112424 -122.288381701999
42861 42861 42861 056 199803300 1405 Bancroft Way 1405 BANCROFT WAY 1405 BANCROFT WY 1405.0 BANCROFT WY     Berkeley 94702 37.86570308197154 -122.28350880690994
42887 42887 42887 056 198402100 1125 Bancroft Way 1125 BANCROFT WAY 1125 BANCROFT WY 1125.0 BANCROFT WY     Berkeley 94702 37.86500947928472 -122.2894923224224
42995 42995 42995 056 199802100 1475 Bancroft Way 1475 BANCROFT WAY 1475 BANCROFT WY 1475.0 BANCROFT WY     Berkeley 94702 37.865924826940955 -122.28179123796816
43599 43599 43599 056 198402000 1127 Bancroft Way 1127 BANCROFT WAY 1127 BANCROFT WY 1127.0 BANCROFT WY     Berkeley 94702 37.86502958533369 -122.28932986839146
43882 43882 43882 056 192400200 1260 Bancroft Way 1260 BANCROFT WAY 1260 BANCROFT WY 1260.0 BANCROFT WY     Berkeley 94702 37.86486679291332 -122.28727054528132
44312 44312 44312 056 192400700 1298 Bancroft Way 1298 BANCROFT WAY 1298 BANCROFT WY 1298.0 BANCROFT WY     Berkeley 94702 37.86494068068515 -122.28667377826842
44679 44679 44679 056 198401800 1137 Bancroft Way B 1137 BANCROFT WAY B 1137 BANCROFT WY 1137.0 BANCROFT WY B   Berkeley 94702 37.865075186493456 -122.28895939867674
44683 44683 44683 056 192200100 1302 Bancroft Way 1302 BANCROFT WAY 1302 BANCROFT WY 1302.0 BANCROFT WY     Berkeley 94702 37.86505002256557 -122.2862519231228
44832 44832 44832 056 199802200 1437 Bancroft Way D 1437 BANCROFT WAY D 1437 BANCROFT WY 1437.0 BANCROFT WY D   Berkeley 94702 37.86596923684376 -122.28196558389683
45836 45836 45836 056 199802500 1431 Bancroft Way 1431 BANCROFT WAY 1431 BANCROFT WY 1431.0 BANCROFT WY     Berkeley 94702 37.86602270641057 -122.28232898387031
47154 47154 47154 056 192400100 1254 Bancroft Way 1254 BANCROFT WAY 1254 BANCROFT WY 1254.0 BANCROFT WY     Berkeley 94702 37.86485335457438 -122.28738707743496
47159 47159 47159 056 192603000 1138 Bancroft Way 1138 BANCROFT WAY 1138 BANCROFT WY 1138.0 BANCROFT WY     Berkeley 94702 37.86464171512864 -122.28887187132702
47634 47634 47634 056 192602700 1128 Bancroft Way 8 1128 BANCROFT WAY 8 1128 BANCROFT WY 1128.0 BANCROFT WY 8   Berkeley 94702 37.8644661479513 -122.28927991577346
47811 47811 47811 056 191600100 1402 Bancroft Way 1402 BANCROFT WAY 1402 BANCROFT WY 1402.0 BANCROFT WY     Berkeley 94702 37.86541376221925 -122.28351486065664
48048 48048 48048 056 192602800 1130 Bancroft Way G 1130 BANCROFT WAY G 1130 BANCROFT WY 1130.0 BANCROFT WY G   Berkeley 94702 37.86448486910401 -122.2891245162125
48973 48973 48973 056 192602700 1128 Bancroft Way 1128 BANCROFT WAY 1128 BANCROFT WY 1128.0 BANCROFT WY     Berkeley 94702 37.8644661479513 -122.28927991577346
49033 49033 49033 056 192602800 1130 Bancroft Way 1130 BANCROFT WAY 1130 BANCROFT WY 1130.0 BANCROFT WY     Berkeley 94702 37.86448486910401 -122.2891245162125
49620 49620 49620 056 192602800 1130 Bancroft Way J 1130 BANCROFT WAY J 1130 BANCROFT WY 1130.0 BANCROFT WY J   Berkeley 94702 37.86448486910401 -122.2891245162125
49784 49784 49784 056 198802100 1227 Bancroft Way Ymca 1227 BANCROFT WAY YMCA 1227 BANCROFT WY 1227.0 BANCROFT WY YMCA   Berkeley 94702 37.86528957702372 -122.28732133782414
51061 51061 51061 056 191600400 1432 Bancroft Way 1432 BANCROFT WAY 1432 BANCROFT WY 1432.0 BANCROFT WY     Berkeley 94702 37.86548405319811 -122.28297431290916
51095 51095 51095 056 192600100 1140 Bancroft Way 1140 BANCROFT WAY 1140 BANCROFT WY 1140.0 BANCROFT WY     Berkeley 94702 37.864703454769185 -122.28874603352538
51232 51232 51232 056 192200300 1314 Bancroft Way 1314 BANCROFT WAY 1314 BANCROFT WY 1314.0 BANCROFT WY     Berkeley 94702 37.86514669829722 -122.2854911596716
52608 52608 52608 056 192602700 1128 Bancroft Way 7 1128 BANCROFT WAY 7 1128 BANCROFT WY 1128.0 BANCROFT WY 7   Berkeley 94702 37.8644661479513 -122.28927991577346
52866 52866 52866 056 199802700 1427 Bancroft Way 1427 BANCROFT WAY 1427 BANCROFT WY 1427.0 BANCROFT WY     Berkeley 94702 37.865999488069555 -122.28252581103726
52976 52976 52976 056 199802200 1437 Bancroft Way 1437 BANCROFT WAY 1437 BANCROFT WY 1437.0 BANCROFT WY     Berkeley 94702 37.86596923684376 -122.28196558389683
53562 53562 53562 056 192400600 1290 Bancroft Way 1290 BANCROFT WAY 1290 BANCROFT WY 1290.0 BANCROFT WY     Berkeley 94702 37.864926294180755 -122.28679467443769
54029 54029 54029 056 198801900 1233 Bancroft Way 1233 BANCROFT WAY 1233 BANCROFT WY 1233.0 BANCROFT WY     Berkeley 94702 37.86532307160938 -122.28704325983637
54434 54434 54434 056 192602700 1128 Bancroft Way 5 1128 BANCROFT WAY 5 1128 BANCROFT WY 1128.0 BANCROFT WY 5   Berkeley 94702 37.8644661479513 -122.28927991577346

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