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

970 rows where street_name = "BANCROFT" and street_type = "WY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

zipcode 5

street_type 1

  • WY · 970 ✖

street_name 1

  • BANCROFT · 970 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
178 178 178 055 187701902 2560 Bancroft Way 166 2560 BANCROFT WAY 166 2560 BANCROFT WY 2560.0 BANCROFT WY 166   Berkeley 94704 37.868744223283414 -122.25767525629354
220 220 220 055 187701300 2510 Bancroft Way 310 2510 BANCROFT WAY 310 2510 BANCROFT WY 2510.0 BANCROFT WY 310   Berkeley 94704 37.86853942270108 -122.25886489252936
250 250 250 055 187701902 2580 Bancroft Way Apt 506 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 506 APT Berkeley 94704 37.86863805606804 -122.25762325910996
252 252 252 055 187001501 2736 Bancroft Way 2736 BANCROFT WAY 2736 BANCROFT WY 2736.0 BANCROFT WY     Berkeley 94704 37.869221065802336 -122.25295637646164
255 255 255 055 187701902 2580 Bancroft Way Apt 408 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 408 APT Berkeley 94704 37.86862112869765 -122.25756914010566
299 299 299 055 187701300 2510 Bancroft Way 204 2510 BANCROFT WAY 204 2510 BANCROFT WY 2510.0 BANCROFT WY 204   Berkeley 94704 37.86853942270108 -122.25886489252936
423 423 423 055 187701902 2580 Bancroft Way Apt 606 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 606 APT Berkeley 94704 37.86866084808889 -122.25762981501492
511 511 511 055 189300701 2124 Bancroft Way Apt 309 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 309 APT Berkeley 94704 37.86725807967805 -122.26648072776143
619 619 619 057 201801700 1845 Bancroft Way 3 1845 BANCROFT WAY 3 1845 BANCROFT WY 1845.0 BANCROFT WY 3   Berkeley 94703 37.867076973786745 -122.2731116384379
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
740 740 740 055 189401401 2020 Bancroft Way 402 2020 BANCROFT WAY 402 2020 BANCROFT WY 2020.0 BANCROFT WY 402   Berkeley 94704 37.86695279564912 -122.26925847223184
782 782 782 056 197501800 1019 Bancroft Way 1019 BANCROFT WAY 1019 BANCROFT WY 1019.0 BANCROFT WY     Berkeley 94710 37.86452672112502 -122.29225501472192
809 809 809 055 187801900 2452 Bancroft Way 5 2452 BANCROFT WAY 5 2452 BANCROFT WY 2452.0 BANCROFT WY 5   Berkeley 94704 37.86830536622177 -122.26018143107042
813 813 813 056 195700301 747 Bancroft Way 747 BANCROFT WAY 747 BANCROFT WY 747.0 BANCROFT WY     Berkeley 94710 37.86352512767258 -122.29888397785086
932 932 932 057 201402700 1801 Bancroft Way 1801 BANCROFT WAY 1801 BANCROFT WY 1801.0 BANCROFT WY     Berkeley 94703 37.866973929456066 -122.27423013079816
973 973 973 057 202801402 2005 Bancroft Way 316 2005 BANCROFT WAY 316 2005 BANCROFT WY 2005.0 BANCROFT WY 316   Berkeley 94704 37.8678249152641 -122.26942837149984
1055 1055 1055 056 198702000 1215 Bancroft Way 1215 BANCROFT WAY 1215 BANCROFT WY 1215.0 BANCROFT WY     Berkeley 94702 37.86516145778813 -122.28792729190748
1163 1163 1163 055 187801700 2428 Bancroft Way 1 2428 BANCROFT WAY 1 2428 BANCROFT WY 2428.0 BANCROFT WY 1   Berkeley 94704 37.868237121001386 -122.26069700116142
1167 1167 1167 055 187701902 2580 Bancroft Way Apt 404 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 404 APT Berkeley 94704 37.86860827609093 -122.25766552214913
1268 1268 1268 056 200802200 1639 Bancroft Way 1639 BANCROFT WAY 1639 BANCROFT WY 1639.0 BANCROFT WY     Berkeley 94703 37.86653294427365 -122.27767228721903
1280 1280 1280 055 187802100 2468 Bancroft Way 10 2468 BANCROFT WAY 10 2468 BANCROFT WY 2468.0 BANCROFT WY 10   Berkeley 94704 37.86835075828235 -122.2598204269038
1335 1335 1335 057 202801402 2005 Bancroft Way 341 2005 BANCROFT WAY 341 2005 BANCROFT WY 2005.0 BANCROFT WY 341   Berkeley 94704 37.8678249152641 -122.26942837149984
1369 1369 1369 055 187701300 2510 Bancroft Way 320 2510 BANCROFT WAY 320 2510 BANCROFT WY 2510.0 BANCROFT WY 320   Berkeley 94704 37.86853942270108 -122.25886489252936
1371 1371 1371 055 189300701 2124 Bancroft Way Apt 504 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 504 APT Berkeley 94704 37.867435596066485 -122.26656526731452
1399 1399 1399 055 189401401 2020 Bancroft Way 313 2020 BANCROFT WAY 313 2020 BANCROFT WY 2020.0 BANCROFT WY 313   Berkeley 94704 37.86695279564912 -122.26925847223184
1418 1418 1418 056 192602900 1134 Bancroft Way 1134 BANCROFT WAY 1134 BANCROFT WY 1134.0 BANCROFT WY     Berkeley 94702 37.864623664906595 -122.28901088561724
1499 1499 1499 057 201302100 1733 Bancroft Way B 1733 BANCROFT WAY B 1733 BANCROFT WY 1733.0 BANCROFT WY B   Berkeley 94703 37.86679731330536 -122.27559453876408
1558 1558 1558 055 187701902 2580 Bancroft Way Apt 706 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 706 APT Berkeley 94704 37.86868460312538 -122.25763579150647
1592 1592 1592 055 187701902 2560 Bancroft Way 21 2560 BANCROFT WAY 21 2560 BANCROFT WY 2560.0 BANCROFT WY 21   Berkeley 94704 37.868744223283414 -122.25767525629354
1723 1723 1723 055 189401401 2020 Bancroft Way 321 2020 BANCROFT WAY 321 2020 BANCROFT WY 2020.0 BANCROFT WY 321   Berkeley 94704 37.86695279564912 -122.26925847223184
2029 2029 2029 055 187701902 2580 Bancroft Way Apt 816 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 816 APT Berkeley 94704 37.868737298460495 -122.25741757006271
2366 2366 2366 055 187701902 2560 Bancroft Way 87 2560 BANCROFT WAY 87 2560 BANCROFT WY 2560.0 BANCROFT WY 87   Berkeley 94704 37.868744223283414 -122.25767525629354
2386 2386 2386 055 187701902 2580 Bancroft Way Apt 507 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 507 APT Berkeley 94704 37.868641326659635 -122.25759873600104
2389 2389 2389 055 187701902 2580 Bancroft Way Apt 414 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 414 APT Berkeley 94704 37.86863869713807 -122.2574373931861
2403 2403 2403 056 198802000 1231 Bancroft Way 1231 BANCROFT WAY 1231 BANCROFT WY 1231.0 BANCROFT WY     Berkeley 94702 37.86530614560503 -122.2871814476765
2418 2418 2418 055 187701902 2580 Bancroft Way Apt 403 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 403 APT Berkeley 94704 37.868604815446055 -122.25769147268106
2514 2514 2514 055 189300701 2124 Bancroft Way Apt 603 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 603 APT Berkeley 94704 37.86746794792993 -122.26659550101373
2599 2599 2599 056 193800200 904 Bancroft Way 904 BANCROFT WAY 904 BANCROFT WY 904.0 BANCROFT WY     Berkeley 94710 37.863563130716976 -122.29478180852952
2721 2721 2721 057 202801402 2005 Bancroft Way 226 2005 BANCROFT WAY 226 2005 BANCROFT WY 2005.0 BANCROFT WY 226   Berkeley 94704 37.8678249152641 -122.26942837149984
2735 2735 2735 055 187701902 2580 Bancroft Way Apt 701 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 701 APT Berkeley 94704 37.868667541027605 -122.257763743044
2842 2842 2842 055 187701902 2554 Bancroft Way 2 2554 BANCROFT WAY 2 2554 BANCROFT WY 2554.0 BANCROFT WY 2   Berkeley 94704 37.8687325854675 -122.25777266960296
3003 3003 3003 055 189401401 2020 Bancroft Way 224 2020 BANCROFT WAY 224 2020 BANCROFT WY 2020.0 BANCROFT WY 224   Berkeley 94704 37.86695279564912 -122.26925847223184
3058 3058 3058 057 202801402 2005 Bancroft Way 426 2005 BANCROFT WAY 426 2005 BANCROFT WY 2005.0 BANCROFT WY 426   Berkeley 94704 37.8678249152641 -122.26942837149984
3104 3104 3104 057 202801402 2005 Bancroft Way 340 2005 BANCROFT WAY 340 2005 BANCROFT WY 2005.0 BANCROFT WY 340   Berkeley 94704 37.8678249152641 -122.26942837149984
3172 3172 3172 055 189401401 2020 Bancroft Way 318 2020 BANCROFT WAY 318 2020 BANCROFT WY 2020.0 BANCROFT WY 318   Berkeley 94704 37.86695279564912 -122.26925847223184
3199 3199 3199 055 187701300 2510 Bancroft Way 301 2510 BANCROFT WAY 301 2510 BANCROFT WY 2510.0 BANCROFT WY 301   Berkeley 94704 37.86853942270108 -122.25886489252936
3216 3216 3216 055 187802000 2462 Bancroft Way 2462 BANCROFT WAY 2462 BANCROFT WY 2462.0 BANCROFT WY     Berkeley 94704 37.86832833279673 -122.2600026447693
3288 3288 3288 057 202801402 2005 Bancroft Way 136 2005 BANCROFT WAY 136 2005 BANCROFT WY 2005.0 BANCROFT WY 136   Berkeley 94704 37.8678249152641 -122.26942837149984
3380 3380 3380 055 187701400 2522 Bancroft Way 2522 BANCROFT WAY 2522 BANCROFT WY 2522.0 BANCROFT WY     Berkeley 94704 37.86850857399582 -122.25849618980078
3405 3405 3405 056 197001100 939 Bancroft Way 939 BANCROFT WAY 939 BANCROFT WY 939.0 BANCROFT WY     Berkeley 94710 37.86425329325958 -122.29359194501993
3425 3425 3425 056 200702301 1609 Bancroft Way 1609 BANCROFT WAY 1609 BANCROFT WY 1609.0 BANCROFT WY     Berkeley 94703 37.8663979156313 -122.27872063642694
3545 3545 3545 057 202801402 2005 Bancroft Way 338 2005 BANCROFT WAY 338 2005 BANCROFT WY 2005.0 BANCROFT WY 338   Berkeley 94704 37.8678249152641 -122.26942837149984
3658 3658 3658 056 192500400 1216 Bancroft Way 1216 BANCROFT WAY 1216 BANCROFT WY 1216.0 BANCROFT WY     Berkeley 94702 37.8647739499618 -122.28784253406376
3687 3687 3687 055 190500500 1740 Bancroft Way A 1740 BANCROFT WAY A 1740 BANCROFT WY 1740.0 BANCROFT WY A   Berkeley 94703 37.86648129267719 -122.27516682839943
3700 3700 3700 055 190900602 1646 Bancroft Way 1646 BANCROFT WAY 1646 BANCROFT WY 1646.0 BANCROFT WY     Berkeley 94703 37.86620840536104 -122.2771794507929
3957 3957 3957 056 194200400 818 Bancroft Way 5 818 BANCROFT WAY 5 818 BANCROFT WY 818.0 BANCROFT WY 5   Berkeley 94710 37.86325506337282 -122.2963741550156
4028 4028 4028 056 198801800 1245 Bancroft Way 1245 BANCROFT WAY 1245 BANCROFT WY 1245.0 BANCROFT WY     Berkeley 94702 37.86534014228258 -122.2869068470672
4040 4040 4040 055 187801900 2454 Bancroft Way 4 2454 BANCROFT WAY 4 2454 BANCROFT WY 2454.0 BANCROFT WY 4   Berkeley 94704 37.86830536622177 -122.26018143107042
4113 4113 4113 056 200802000 1647 Bancroft Way 1647 BANCROFT WAY 1647 BANCROFT WY 1647.0 BANCROFT WY     Berkeley 94703 37.866567786422905 -122.27741239921744
4222 4222 4222 056 191700100 1328 Bancroft Way 1328 BANCROFT WAY 1328 BANCROFT WY 1328.0 BANCROFT WY     Berkeley 94702 37.86528031299875 -122.2845537434181
4453 4453 4453 055 190403400 1806 Bancroft Way 1806 BANCROFT WAY 1806 BANCROFT WY 1806.0 BANCROFT WY     Berkeley 94703 37.866497122036634 -122.2744690099002
4460 4460 4460 055 187701902 2580 Bancroft Way Apt 707 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 707 APT Berkeley 94704 37.868687873714904 -122.25761126839754
4638 4638 4638 056 199301501 1325 Bancroft Way 1325 BANCROFT WAY 1325 BANCROFT WY 1325.0 BANCROFT WY     Berkeley 94702 37.866162068781925 -122.28492231499268
4870 4870 4870 055 190800400 1710 Bancroft Way 1710 BANCROFT WAY 1710 BANCROFT WY 1710.0 BANCROFT WY     Berkeley 94703 37.866253784529945 -122.27642260579296
4886 4886 4886 056 198401700 1141 Bancroft Way 1141 BANCROFT WAY 1141 BANCROFT WY 1141.0 BANCROFT WY     Berkeley 94702 37.86509196929602 -122.28882124317592
4917 4917 4917 055 187701902 2580 Bancroft Way Apt 811 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 811 APT Berkeley 94704 37.868722897805235 -122.2575255601363
4930 4930 4930 055 187701300 2510 Bancroft Way 2510 BANCROFT WAY 2510 BANCROFT WY 2510.0 BANCROFT WY     Berkeley 94704 37.86853942270108 -122.25886489252936
4937 4937 4937 055 187701902 2580 Bancroft Way Ste 2 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 2 STE Berkeley 94704 37.86853152987017 -122.25769892959624
4961 4961 4961 055 187801700 2428 Bancroft Way 4 2428 BANCROFT WAY 4 2428 BANCROFT WY 2428.0 BANCROFT WY 4   Berkeley 94704 37.868237121001386 -122.26069700116142
4988 4988 4988 055 189401600 2032 Bancroft Way 2 2032 BANCROFT WAY 2 2032 BANCROFT WY 2032.0 BANCROFT WY 2   Berkeley 94704 37.86721106154514 -122.26868244731884
5116 5116 5116 055 187701902 2580 Bancroft Way Apt 601 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 601 APT Berkeley 94704 37.86864378598557 -122.2577577665524
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
5218 5218 5218 055 187701902 2560 Bancroft Way 229 2560 BANCROFT WAY 229 2560 BANCROFT WY 2560.0 BANCROFT WY 229   Berkeley 94704 37.868744223283414 -122.25767525629354
5227 5227 5227 055 189300701 2124 Bancroft Way Apt 405 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 405 APT Berkeley 94704 37.867403573239145 -122.2665350920058
5304 5304 5304 057 202801402 2005 Bancroft Way 244 2005 BANCROFT WAY 244 2005 BANCROFT WY 2005.0 BANCROFT WY 244   Berkeley 94704 37.8678249152641 -122.26942837149984
5326 5326 5326 056 197502100 985 Bancroft Way 985 BANCROFT WAY 985 BANCROFT WY 985.0 BANCROFT WY     Berkeley 94710 37.864425136284616 -122.29275925346394
5441 5441 5441 055 189401401 2020 Bancroft Way 127 2020 BANCROFT WAY 127 2020 BANCROFT WY 2020.0 BANCROFT WY 127   Berkeley 94704 37.86695279564912 -122.26925847223184
5517 5517 5517 055 188500800 2338 Bancroft Way 2338 BANCROFT WAY 2338 BANCROFT WY 2338.0 BANCROFT WY     Berkeley 94704 37.868032019746565 -122.26270521372516
5547 5547 5547 055 189401401 2020 Bancroft Way 112 2020 BANCROFT WAY 112 2020 BANCROFT WY 2020.0 BANCROFT WY 112   Berkeley 94704 37.86695279564912 -122.26925847223184
5588 5588 5588 056 193300200 1028 Bancroft Way 1028 BANCROFT WAY 1028 BANCROFT WY 1028.0 BANCROFT WY     Berkeley 94710 37.864226897896 -122.29147083668286
5600 5600 5600 055 187801700 2428 Bancroft Way 5 2428 BANCROFT WAY 5 2428 BANCROFT WY 2428.0 BANCROFT WY 5   Berkeley 94704 37.868237121001386 -122.26069700116142
5658 5658 5658 057 202801402 2005 Bancroft Way 230 2005 BANCROFT WAY 230 2005 BANCROFT WY 2005.0 BANCROFT WY 230   Berkeley 94704 37.8678249152641 -122.26942837149984
5758 5758 5758 056 196401400 845 Bancroft Way H 845 BANCROFT WAY H 845 BANCROFT WY 845.0 BANCROFT WY H   Berkeley 94710 37.86385747953951 -122.29559617804696
5823 5823 5823 055 189301800 2126 Bancroft Way 4 2126 BANCROFT WAY 4 2126 BANCROFT WY 2126.0 BANCROFT WY 4   Berkeley 94704 37.86756143565828 -122.2664203996019
5837 5837 5837 055 189401401 2020 Bancroft Way 324 2020 BANCROFT WAY 324 2020 BANCROFT WY 2020.0 BANCROFT WY 324   Berkeley 94704 37.86695279564912 -122.26925847223184
5890 5890 5890 055 187701902 2580 Bancroft Way Apt 808 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 808 APT Berkeley 94704 37.86871374554803 -122.25759419411892
5920 5920 5920 056 196401600 835 Bancroft Way B 835 BANCROFT WAY B 835 BANCROFT WY 835.0 BANCROFT WY B   Berkeley 94710 37.86379483709443 -122.29591513207508
5932 5932 5932 055 189401401 2020 Bancroft Way 130 2020 BANCROFT WAY 130 2020 BANCROFT WY 2020.0 BANCROFT WY 130   Berkeley 94704 37.86695279564912 -122.26925847223184
6218 6218 6218 057 202801402 2005 Bancroft Way 344 2005 BANCROFT WAY 344 2005 BANCROFT WY 2005.0 BANCROFT WY 344   Berkeley 94704 37.8678249152641 -122.26942837149984
6234 6234 6234 055 187801700 2428 Bancroft Way 3 2428 BANCROFT WAY 3 2428 BANCROFT WY 2428.0 BANCROFT WY 3   Berkeley 94704 37.868237121001386 -122.26069700116142
6341 6341 6341 055 187701902 2580 Bancroft Way Apt 809 2580 BANCROFT WAY 2580 BANCROFT WY 2580.0 BANCROFT WY 809 APT Berkeley 94704 37.86871686579704 -122.25757079390412
6348 6348 6348 055 187701902 2560 Bancroft Way 172 2560 BANCROFT WAY 172 2560 BANCROFT WY 2560.0 BANCROFT WY 172   Berkeley 94704 37.868744223283414 -122.25767525629354
6496 6496 6496 055 189401401 2020 Bancroft Way 223 2020 BANCROFT WAY 223 2020 BANCROFT WY 2020.0 BANCROFT WY 223   Berkeley 94704 37.86695279564912 -122.26925847223184
6505 6505 6505 057 202801402 2005 Bancroft Way 126 2005 BANCROFT WAY 126 2005 BANCROFT WY 2005.0 BANCROFT WY 126   Berkeley 94704 37.8678249152641 -122.26942837149984
6518 6518 6518 057 202801402 2005 Bancroft Way 420 2005 BANCROFT WAY 420 2005 BANCROFT WY 2005.0 BANCROFT WY 420   Berkeley 94704 37.8678249152641 -122.26942837149984
6675 6675 6675 055 189300701 2124 Bancroft Way Apt 407 2124 BANCROFT WAY 2124 BANCROFT WY 2124.0 BANCROFT WY 407 APT Berkeley 94704 37.86733254656403 -122.26652029405814
6799 6799 6799 056 200902300 1701 Bancroft Way 1701 BANCROFT WAY 1701 BANCROFT WY 1701.0 BANCROFT WY     Berkeley 94703 37.86663486235382 -122.27683540053066

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