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

93 rows where street_name = "BANCROFT" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94703 · 93 ✖

street_type 1

street_name 1

  • BANCROFT · 93 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
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
932 932 932 057 201402700 1801 Bancroft Way 1801 BANCROFT WAY 1801 BANCROFT WY 1801.0 BANCROFT WY     Berkeley 94703 37.866973929456066 -122.27423013079816
1268 1268 1268 056 200802200 1639 Bancroft Way 1639 BANCROFT WAY 1639 BANCROFT WY 1639.0 BANCROFT WY     Berkeley 94703 37.86653294427365 -122.27767228721903
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
3425 3425 3425 056 200702301 1609 Bancroft Way 1609 BANCROFT WAY 1609 BANCROFT WY 1609.0 BANCROFT WY     Berkeley 94703 37.8663979156313 -122.27872063642694
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
4113 4113 4113 056 200802000 1647 Bancroft Way 1647 BANCROFT WAY 1647 BANCROFT WY 1647.0 BANCROFT WY     Berkeley 94703 37.866567786422905 -122.27741239921744
4453 4453 4453 055 190403400 1806 Bancroft Way 1806 BANCROFT WAY 1806 BANCROFT WY 1806.0 BANCROFT WY     Berkeley 94703 37.866497122036634 -122.2744690099002
4870 4870 4870 055 190800400 1710 Bancroft Way 1710 BANCROFT WAY 1710 BANCROFT WY 1710.0 BANCROFT WY     Berkeley 94703 37.866253784529945 -122.27642260579296
6799 6799 6799 056 200902300 1701 Bancroft Way 1701 BANCROFT WAY 1701 BANCROFT WY 1701.0 BANCROFT WY     Berkeley 94703 37.86663486235382 -122.27683540053066
7733 7733 7733 055 190400400 1816 Bancroft Way 1816 BANCROFT WAY 1816 BANCROFT WY 1816.0 BANCROFT WY     Berkeley 94703 37.86654773185371 -122.273983444438
7747 7747 7747 055 191200200 1602 Bancroft Way 1602 BANCROFT WAY 1602 BANCROFT WY 1602.0 BANCROFT WY     Berkeley 94703 37.86592154913703 -122.2789630153653
7788 7788 7788 056 200802300 1631 Bancroft Way 1 1631 BANCROFT WAY 1 1631 BANCROFT WY 1631.0 BANCROFT WY 1   Berkeley 94703 37.86643851984606 -122.277878801818
8023 8023 8023 057 201801800 1833 Bancroft Way 1833 BANCROFT WAY 1833 BANCROFT WY 1833.0 BANCROFT WY     Berkeley 94703 37.867086280844795 -122.27321761808189
9321 9321 9321 056 200102100 1533 Bancroft Way 1533 BANCROFT WAY 1533 BANCROFT WY 1533.0 BANCROFT WY     Berkeley 94703 37.86622788488459 -122.28004887013468
9330 9330 9330 055 190800200 1704 Bancroft Way 1704 BANCROFT WAY 1704 BANCROFT WY 1704.0 BANCROFT WY     Berkeley 94703 37.86626491922589 -122.27669401019652
9592 9592 9592 057 201402700 1809 Bancroft Way 1809 BANCROFT WAY 1809 BANCROFT WY 1809.0 BANCROFT WY     Berkeley 94703 37.866973929456066 -122.27423013079816
9972 9972 9972 056 200702200 1617 Bancroft Way 1617 BANCROFT WAY 1617 BANCROFT WY 1617.0 BANCROFT WY     Berkeley 94703 37.866417141222016 -122.2785634474219
10273 10273 10273 057 201801700 1843 Bancroft Way 1843 BANCROFT WAY 1843 BANCROFT WY 1843.0 BANCROFT WY     Berkeley 94703 37.867076973786745 -122.2731116384379
12211 12211 12211 057 201302100 1733 Bancroft Way A 1733 BANCROFT WAY A 1733 BANCROFT WY 1733.0 BANCROFT WY A   Berkeley 94703 37.86679731330536 -122.27559453876408
12492 12492 12492 056 200902105 1707 Bancroft Way 1707 BANCROFT WAY 1707 BANCROFT WY 1707.0 BANCROFT WY     Berkeley 94703 37.86683321695049 -122.27657406085156
13496 13496 13496 057 201801700 1845 Bancroft Way 2 1845 BANCROFT WAY 2 1845 BANCROFT WY 1845.0 BANCROFT WY 2   Berkeley 94703 37.867076973786745 -122.2731116384379
13741 13741 13741 056 200702401 1607 Bancroft Way 1607 BANCROFT WAY 1607 BANCROFT WY 1607.0 BANCROFT WY     Berkeley 94703 37.8663749129962 -122.27890115737485
13966 13966 13966 057 201801700 1845 Bancroft Way 4 1845 BANCROFT WAY 4 1845 BANCROFT WY 1845.0 BANCROFT WY 4   Berkeley 94703 37.867076973786745 -122.2731116384379
14415 14415 14415 055 191200400 1606 Bancroft Way 1606 BANCROFT WAY 1606 BANCROFT WY 1606.0 BANCROFT WY     Berkeley 94703 37.86595107276983 -122.27873424500518
15586 15586 15586 057 201301600 1747 Bancroft Way 2 1747 BANCROFT WAY 2 1747 BANCROFT WY 1747.0 BANCROFT WY 2   Berkeley 94703 37.86687628669279 -122.2749813990568
15644 15644 15644 055 190500400 1736 Bancroft Way 1736 BANCROFT WAY 1736 BANCROFT WY 1736.0 BANCROFT WY     Berkeley 94703 37.86646850494078 -122.27526703277444
16513 16513 16513 057 201301800 1739 Bancroft Way A 1739 BANCROFT WAY A 1739 BANCROFT WY 1739.0 BANCROFT WY A   Berkeley 94703 37.86684669889664 -122.27521201455656
18107 18107 18107 056 200902101 1709 Bancroft Way 1709 BANCROFT WAY 1709 BANCROFT WY 1709.0 BANCROFT WY     Berkeley 94703 37.86663347238551 -122.27655987735152
18383 18383 18383 055 190900602 1648 Bancroft Way 1648 BANCROFT WAY 1648 BANCROFT WY 1648.0 BANCROFT WY     Berkeley 94703 37.86620840536104 -122.2771794507929
18528 18528 18528 056 200802300 1631 Bancroft Way 1631 BANCROFT WAY 1631 BANCROFT WY 1631.0 BANCROFT WY     Berkeley 94703 37.86643851984606 -122.277878801818
19994 19994 19994 056 200102200 1529 Bancroft Way 1529 BANCROFT WAY 1529 BANCROFT WY 1529.0 BANCROFT WY     Berkeley 94703 37.866217483466414 -122.28015863707589
20556 20556 20556 057 201302100 1733 Bancroft Way C 1733 BANCROFT WAY C 1733 BANCROFT WY 1733.0 BANCROFT WY C   Berkeley 94703 37.86679731330536 -122.27559453876408
21538 21538 21538 055 190400300 1812 Bancroft Way 1812 BANCROFT WAY 1812 BANCROFT WY 1812.0 BANCROFT WY     Berkeley 94703 37.86653092243424 -122.27412249645744
22218 22218 22218 055 190800300 1706 Bancroft Way 1706 BANCROFT WAY 1706 BANCROFT WY 1706.0 BANCROFT WY     Berkeley 94703 37.86623384901609 -122.27657018731604
22601 22601 22601 057 201302100 1733 Bancroft Way 1733 BANCROFT WAY 1733 BANCROFT WY 1733.0 BANCROFT WY     Berkeley 94703 37.86679731330536 -122.27559453876408
23054 23054 23054 055 190800400 1710 Bancroft Way B 1710 BANCROFT WAY B 1710 BANCROFT WY 1710.0 BANCROFT WY B   Berkeley 94703 37.866253784529945 -122.27642260579296
23614 23614 23614 056 200702100 1619 Bancroft Way 1619 BANCROFT WAY 1619 BANCROFT WY 1619.0 BANCROFT WY     Berkeley 94703 37.866430043143616 -122.2784580714458
23894 23894 23894 057 201801700 1845 Bancroft Way 1845 BANCROFT WAY 1845 BANCROFT WY 1845.0 BANCROFT WY     Berkeley 94703 37.867076973786745 -122.2731116384379
24140 24140 24140 055 190400200 1808 Bancroft Way 1808 BANCROFT WAY 1808 BANCROFT WY 1808.0 BANCROFT WY     Berkeley 94703 37.866531906760166 -122.27425511564115
24633 24633 24633 055 190800400 1710 Bancroft Way A 1710 BANCROFT WAY A 1710 BANCROFT WY 1710.0 BANCROFT WY A   Berkeley 94703 37.866253784529945 -122.27642260579296
27359 27359 27359 055 190500500 1740 Bancroft Way 1740 BANCROFT WAY 1740 BANCROFT WY 1740.0 BANCROFT WY     Berkeley 94703 37.86648129267719 -122.27516682839943
27794 27794 27794 055 190900400 1640 Bancroft Way 1640 BANCROFT WAY 1640 BANCROFT WY 1640.0 BANCROFT WY     Berkeley 94703 37.86611768381641 -122.27744748831074
28882 28882 28882 056 200901900 1715 Bancroft Way 1715 BANCROFT WAY 1715 BANCROFT WY 1715.0 BANCROFT WY     Berkeley 94703 37.86666828753884 -122.2762740433096
31149 31149 31149 056 200702501 1601 Bancroft Way 1601 BANCROFT WAY 1601 BANCROFT WY 1601.0 BANCROFT WY     Berkeley 94703 37.86635186283945 -122.27907643844972
31305 31305 31305 055 191200100 1600 Bancroft Way 1600 BANCROFT WAY 1600 BANCROFT WY 1600.0 BANCROFT WY     Berkeley 94703 37.86590668484049 -122.27907006939436
31448 31448 31448 056 200902200 1703 Bancroft Way 1703 BANCROFT WAY 1703 BANCROFT WY 1703.0 BANCROFT WY     Berkeley 94703 37.866651043427275 -122.27669983038123
32351 32351 32351 055 191200100 1600 Bancroft Way B 1600 BANCROFT WAY B 1600 BANCROFT WY 1600.0 BANCROFT WY B   Berkeley 94703 37.86590668484049 -122.27907006939436
32425 32425 32425 056 200802100 1643 Bancroft Way 1643 BANCROFT WAY 1643 BANCROFT WY 1643.0 BANCROFT WY     Berkeley 94703 37.866550256493 -122.27754451983616
33009 33009 33009 055 190900500 1642 Bancroft Way 1642 BANCROFT WAY 1642 BANCROFT WY 1642.0 BANCROFT WY     Berkeley 94703 37.86613614357413 -122.27731113303378
33180 33180 33180 055 190500300 1734 Bancroft Way 1734 BANCROFT WAY 1734 BANCROFT WY 1734.0 BANCROFT WY     Berkeley 94703 37.86638144799762 -122.27538535976196
34378 34378 34378 057 201301700 1741 Bancroft Way 1741 BANCROFT WAY 1741 BANCROFT WY 1741.0 BANCROFT WY     Berkeley 94703 37.86686036876911 -122.27511183443605
36034 36034 36034 057 201801700 1845 Bancroft Way 1 1845 BANCROFT WAY 1 1845 BANCROFT WY 1845.0 BANCROFT WY 1   Berkeley 94703 37.867076973786745 -122.2731116384379
36779 36779 36779 056 200902200 1705 Bancroft Way 1705 BANCROFT WAY 1705 BANCROFT WY 1705.0 BANCROFT WY     Berkeley 94703 37.866651043427275 -122.27669983038123
37571 37571 37571 055 191300300 1538 Bancroft Way 1538 BANCROFT WAY 1538 BANCROFT WY 1538.0 BANCROFT WY     Berkeley 94703 37.8658201711711 -122.27978771191528
38371 38371 38371 056 200702501 1603 Bancroft Way 1603 BANCROFT WAY 1603 BANCROFT WY 1603.0 BANCROFT WY     Berkeley 94703 37.86635186283945 -122.27907643844972
38711 38711 38711 057 201301800 1739 Bancroft Way B 1739 BANCROFT WAY B 1739 BANCROFT WY 1739.0 BANCROFT WY B   Berkeley 94703 37.86684669889664 -122.27521201455656
38872 38872 38872 056 200802300 1631 Bancroft Way 4 1631 BANCROFT WAY 4 1631 BANCROFT WY 1631.0 BANCROFT WY 4   Berkeley 94703 37.86643851984606 -122.277878801818
39103 39103 39103 055 190900101 1632 Bancroft Way 1632 BANCROFT WAY 1632 BANCROFT WY 1632.0 BANCROFT WY     Berkeley 94703 37.86606932320068 -122.27781795622884
39688 39688 39688 056 200101800 1547 Bancroft Way 1547 BANCROFT WAY 1547 BANCROFT WY 1547.0 BANCROFT WY     Berkeley 94703 37.86619457864066 -122.27960995328688
39871 39871 39871 055 190800100 1700 Bancroft Way 1700 BANCROFT WAY 1700 BANCROFT WY 1700.0 BANCROFT WY     Berkeley 94703 37.86625014435415 -122.27681227789525
40521 40521 40521 057 201301600 1745 Bancroft Way 1745 BANCROFT WAY 1745 BANCROFT WY 1745.0 BANCROFT WY     Berkeley 94703 37.86687628669279 -122.2749813990568
42547 42547 42547 057 201302200 1725 Bancroft Way 1725 BANCROFT WAY 1725 BANCROFT WY 1725.0 BANCROFT WY     Berkeley 94703 37.866780264244696 -122.27572835989366
46231 46231 46231 055 191300100 1530 Bancroft Way 1530 BANCROFT WAY 1530 BANCROFT WY 1530.0 BANCROFT WY     Berkeley 94703 37.865861348008366 -122.2801163156462
46700 46700 46700 056 200702000 1621 Bancroft Way 1621 BANCROFT WAY 1621 BANCROFT WY 1621.0 BANCROFT WY     Berkeley 94703 37.866444157742585 -122.27834237652206
47003 47003 47003 057 201301900 1737 Bancroft Way 1737 BANCROFT WAY 1737 BANCROFT WY 1737.0 BANCROFT WY     Berkeley 94703 37.86683146885724 -122.27532853143876
47376 47376 47376 056 200902000 1711 Bancroft Way 1711 BANCROFT WAY 1711 BANCROFT WY 1711.0 BANCROFT WY     Berkeley 94703 37.86669544509156 -122.27642884459264
48184 48184 48184 057 201801900 1829 Bancroft Way 1829 BANCROFT WAY 1829 BANCROFT WY 1829.0 BANCROFT WY     Berkeley 94703 37.867122197114114 -122.27334495247676
48446 48446 48446 057 201302100 1733 Bancroft Way 1 1733 BANCROFT WAY 1 1733 BANCROFT WY 1733.0 BANCROFT WY 1   Berkeley 94703 37.86679731330536 -122.27559453876408
48533 48533 48533 055 190900101 1630 Bancroft Way 1630 BANCROFT WAY 1630 BANCROFT WY 1630.0 BANCROFT WY     Berkeley 94703 37.86606932320068 -122.27781795622884
48896 48896 48896 056 200802300 1631 Bancroft Way 2 1631 BANCROFT WAY 2 1631 BANCROFT WY 1631.0 BANCROFT WY 2   Berkeley 94703 37.86643851984606 -122.277878801818
49543 49543 49543 057 201302000 1735 Bancroft Way 1735 BANCROFT WAY 1735 BANCROFT WY 1735.0 BANCROFT WY     Berkeley 94703 37.8668150772012 -122.27545893717362
49919 49919 49919 056 200702301 1611 Bancroft Way 1611 BANCROFT WAY 1611 BANCROFT WY 1611.0 BANCROFT WY     Berkeley 94703 37.8663979156313 -122.27872063642694
50667 50667 50667 055 190500500 1740 Bancroft Way B 1740 BANCROFT WAY B 1740 BANCROFT WY 1740.0 BANCROFT WY B   Berkeley 94703 37.86648129267719 -122.27516682839943
51654 51654 51654 055 191300200 1532 Bancroft Way 1532 BANCROFT WAY 1532 BANCROFT WY 1532.0 BANCROFT WY     Berkeley 94703 37.86583062867019 -122.279901483546
52411 52411 52411 056 200802300 1631 Bancroft Way 3 1631 BANCROFT WAY 3 1631 BANCROFT WY 1631.0 BANCROFT WY 3   Berkeley 94703 37.86643851984606 -122.277878801818
53313 53313 53313 055 190500200 1732 Bancroft Way 1732 BANCROFT WAY 1732 BANCROFT WY 1732.0 BANCROFT WY     Berkeley 94703 37.86636418041634 -122.27552439651006
54162 54162 54162 056 200702401 1605 Bancroft Way 1605 BANCROFT WAY 1605 BANCROFT WY 1605.0 BANCROFT WY     Berkeley 94703 37.8663749129962 -122.27890115737485
54222 54222 54222 057 201301600 1747 Bancroft Way 1747 BANCROFT WAY 1747 BANCROFT WY 1747.0 BANCROFT WY     Berkeley 94703 37.86687628669279 -122.2749813990568
54381 54381 54381 055 191200700 1628 Bancroft Way 1628 BANCROFT WAY 1628 BANCROFT WY 1628.0 BANCROFT WY     Berkeley 94703 37.86609063029912 -122.27835202981812
54587 54587 54587 057 201301800 1739 Bancroft Way 1739 BANCROFT WAY 1739 BANCROFT WY 1739.0 BANCROFT WY     Berkeley 94703 37.86684669889664 -122.27521201455656
55175 55175 55175 055 190500100 1730 Bancroft Way 1730 BANCROFT WAY 1730 BANCROFT WY 1730.0 BANCROFT WY     Berkeley 94703 37.86639532645235 -122.27567502691522
55572 55572 55572 055 190800500 1718 Bancroft Way 1718 BANCROFT WAY 1718 BANCROFT WY 1718.0 BANCROFT WY     Berkeley 94703 37.86636891625427 -122.27616980729564
55888 55888 55888 055 191200501 1608 Bancroft Way 1608 BANCROFT WAY 1608 BANCROFT WY 1608.0 BANCROFT WY     Berkeley 94703 37.8659715317305 -122.27857178199108
56051 56051 56051 056 200102000 1537 Bancroft Way 1537 BANCROFT WAY 1537 BANCROFT WY 1537.0 BANCROFT WY     Berkeley 94703 37.86623818205308 -122.27994692302802
56217 56217 56217 057 201302100 1733 Bancroft Way 3 1733 BANCROFT WAY 3 1733 BANCROFT WY 1733.0 BANCROFT WY 3   Berkeley 94703 37.86679731330536 -122.27559453876408
56431 56431 56431 057 201301600 1747 Bancroft Way 1 1747 BANCROFT WAY 1 1747 BANCROFT WY 1747.0 BANCROFT WY 1   Berkeley 94703 37.86687628669279 -122.2749813990568
57403 57403 57403 055 190403400 1802 Bancroft Way 1802 BANCROFT WAY 1802 BANCROFT WY 1802.0 BANCROFT WY     Berkeley 94703 37.866497122036634 -122.2744690099002
57804 57804 57804 056 200901800 1717 Bancroft Way 1717 BANCROFT WAY 1717 BANCROFT WY 1717.0 BANCROFT WY     Berkeley 94703 37.866688013730894 -122.27611684801634
58029 58029 58029 055 190900300 1638 Bancroft Way 1638 BANCROFT WAY 1638 BANCROFT WY 1638.0 BANCROFT WY     Berkeley 94703 37.86609929709888 -122.27757533025375
58039 58039 58039 055 191200300 1604 Bancroft Way 1604 BANCROFT WAY 1604 BANCROFT WY 1604.0 BANCROFT WY     Berkeley 94703 37.86593680985897 -122.27885078165036
58216 58216 58216 056 200101900 1541 Bancroft Way 1541 BANCROFT WAY 1541 BANCROFT WY 1541.0 BANCROFT WY     Berkeley 94703 37.86630330026371 -122.27986019697558

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