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

143 rows where street_name = "CHESTNUT" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94702 · 143 ✖

street_type 1

street_name 1

  • CHESTNUT · 143 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
566 566 566 057 208301200 1914 Chestnut St 1914 CHESTNUT ST 1914 CHESTNUT ST 1914.0 CHESTNUT ST     Berkeley 94702 37.87043332593127 -122.28841637068076
588 588 588 059 229200600 1514 Chestnut St 1514 CHESTNUT ST 1514 CHESTNUT ST 1514.0 CHESTNUT ST     Berkeley 94702 37.87624671810408 -122.28919038158745
938 938 938 058 213701600 1637 Chestnut St 1637 CHESTNUT ST 1637 CHESTNUT ST 1637.0 CHESTNUT ST     Berkeley 94702 37.87465195003261 -122.28819533571352
1367 1367 1367 057 208102100 1951 Chestnut St 311 1951 CHESTNUT ST 311 1951 CHESTNUT ST 1951.0 CHESTNUT ST 311   Berkeley 94702 37.87030294074293 -122.28775667398725
1554 1554 1554 057 208101800 1913 Chestnut St 1913 CHESTNUT ST 1913 CHESTNUT ST 1913.0 CHESTNUT ST     Berkeley 94702 37.8707260773018 -122.28792797193212
2151 2151 2151 057 208002400 1807 Chestnut St 1807 CHESTNUT ST 1807 CHESTNUT ST 1807.0 CHESTNUT ST     Berkeley 94702 37.87200960436773 -122.28806982579697
2252 2252 2252 057 208102900 1955 Chestnut St 305 1955 CHESTNUT ST 305 1955 CHESTNUT ST 1955.0 CHESTNUT ST 305   Berkeley 94702 37.87016344083085 -122.2877203730666
2414 2414 2414 057 208102900 1955 Chestnut St 307 1955 CHESTNUT ST 307 1955 CHESTNUT ST 1955.0 CHESTNUT ST 307   Berkeley 94702 37.87016344083085 -122.2877203730666
3319 3319 3319 058 213300900 1708 Chestnut St 1708 CHESTNUT ST 1708 CHESTNUT ST 1708.0 CHESTNUT ST     Berkeley 94702 37.87363194840564 -122.28878014255672
3347 3347 3347 059 229202201 1610 Chestnut St 1610 CHESTNUT ST 1610 CHESTNUT ST 1610.0 CHESTNUT ST     Berkeley 94702 37.87515552655373 -122.2889435452086
3745 3745 3745 057 208102100 1951 Chestnut St 211 1951 CHESTNUT ST 211 1951 CHESTNUT ST 1951.0 CHESTNUT ST 211   Berkeley 94702 37.87030294074293 -122.28775667398725
5858 5858 5858 058 213801300 1601 Chestnut St 1601 CHESTNUT ST 1601 CHESTNUT ST 1601.0 CHESTNUT ST     Berkeley 94702 37.87579285055958 -122.2884486228944
6102 6102 6102 059 229202300 1618 Chestnut St 1618 CHESTNUT ST 1618 CHESTNUT ST 1618.0 CHESTNUT ST     Berkeley 94702 37.87508525118287 -122.2889296806105
6362 6362 6362 057 208102100 1951 Chestnut St 302 1951 CHESTNUT ST 302 1951 CHESTNUT ST 1951.0 CHESTNUT ST 302   Berkeley 94702 37.87030294074293 -122.28775667398725
6806 6806 6806 057 208102900 1955 Chestnut St 106 1955 CHESTNUT ST 106 1955 CHESTNUT ST 1955.0 CHESTNUT ST 106   Berkeley 94702 37.87016344083085 -122.2877203730666
6872 6872 6872 057 208102100 1951 Chestnut St 309 1951 CHESTNUT ST 309 1951 CHESTNUT ST 1951.0 CHESTNUT ST 309   Berkeley 94702 37.87030294074293 -122.28775667398725
6918 6918 6918 057 208000100 1801 Chestnut St 1801 CHESTNUT ST 1801 CHESTNUT ST 1801.0 CHESTNUT ST     Berkeley 94702 37.87213060140438 -122.28808483125545
7155 7155 7155 057 208301100 1912 Chestnut St 1912 CHESTNUT ST 1912 CHESTNUT ST 1912.0 CHESTNUT ST     Berkeley 94702 37.870542097321405 -122.28842772538594
7185 7185 7185 057 208102900 1955 Chestnut St 304 1955 CHESTNUT ST 304 1955 CHESTNUT ST 1955.0 CHESTNUT ST 304   Berkeley 94702 37.87016344083085 -122.2877203730666
7760 7760 7760 057 208102100 1951 Chestnut St 103 1951 CHESTNUT ST 103 1951 CHESTNUT ST 1951.0 CHESTNUT ST 103   Berkeley 94702 37.87030294074293 -122.28775667398725
7876 7876 7876 057 208102100 1951 Chestnut St 102 1951 CHESTNUT ST 102 1951 CHESTNUT ST 1951.0 CHESTNUT ST 102   Berkeley 94702 37.87030294074293 -122.28775667398725
8462 8462 8462 057 208102100 1951 Chestnut St 205 1951 CHESTNUT ST 205 1951 CHESTNUT ST 1951.0 CHESTNUT ST 205   Berkeley 94702 37.87030294074293 -122.28775667398725
8593 8593 8593 057 208102100 1951 Chestnut St 101 1951 CHESTNUT ST 101 1951 CHESTNUT ST 1951.0 CHESTNUT ST 101   Berkeley 94702 37.87030294074293 -122.28775667398725
9425 9425 9425 057 208102900 1955 Chestnut St 204 1955 CHESTNUT ST 204 1955 CHESTNUT ST 1955.0 CHESTNUT ST 204   Berkeley 94702 37.87016344083085 -122.2877203730666
9809 9809 9809 058 213401000 1732 Chestnut St 1732 CHESTNUT ST 1732 CHESTNUT ST 1732.0 CHESTNUT ST     Berkeley 94702 37.873005886167 -122.28858586570686
9876 9876 9876 058 213801100 1611 Chestnut St 1611 CHESTNUT ST 1611 CHESTNUT ST 1611.0 CHESTNUT ST     Berkeley 94702 37.87555912060975 -122.28842217469578
10157 10157 10157 057 208001900 1821 Chestnut St 1821 CHESTNUT ST 1821 CHESTNUT ST 1821.0 CHESTNUT ST     Berkeley 94702 37.87141320933905 -122.28800518033415
10243 10243 10243 058 213500100 1729 Chestnut St 1729 CHESTNUT ST 1729 CHESTNUT ST 1729.0 CHESTNUT ST     Berkeley 94702 37.87310095597366 -122.28814031120744
10326 10326 10326 057 208102100 1951 Chestnut St 307 1951 CHESTNUT ST 307 1951 CHESTNUT ST 1951.0 CHESTNUT ST 307   Berkeley 94702 37.87030294074293 -122.28775667398725
10461 10461 10461 057 208102100 1951 Chestnut St 107 1951 CHESTNUT ST 107 1951 CHESTNUT ST 1951.0 CHESTNUT ST 107   Berkeley 94702 37.87030294074293 -122.28775667398725
10477 10477 10477 057 208102900 1955 Chestnut St 306 1955 CHESTNUT ST 306 1955 CHESTNUT ST 1955.0 CHESTNUT ST 306   Berkeley 94702 37.87016344083085 -122.2877203730666
12048 12048 12048 057 208102900 1955 Chestnut St 201 1955 CHESTNUT ST 201 1955 CHESTNUT ST 1955.0 CHESTNUT ST 201   Berkeley 94702 37.87016344083085 -122.2877203730666
12191 12191 12191 057 208300700 1900 Chestnut St 1900 CHESTNUT ST 1900 CHESTNUT ST 1900.0 CHESTNUT ST     Berkeley 94702 37.87094677395888 -122.28844526499184
12206 12206 12206 057 208100100 1901 Chestnut St 1901 CHESTNUT ST 1901 CHESTNUT ST 1901.0 CHESTNUT ST     Berkeley 94702 37.871004326603995 -122.28795723006093
12225 12225 12225 057 208102100 1951 Chestnut St 210 1951 CHESTNUT ST 210 1951 CHESTNUT ST 1951.0 CHESTNUT ST 210   Berkeley 94702 37.87030294074293 -122.28775667398725
12318 12318 12318 058 213302300 1716 Chestnut St 1716 CHESTNUT ST 1716 CHESTNUT ST 1716.0 CHESTNUT ST     Berkeley 94702 37.87350841525197 -122.28879201199658
12470 12470 12470 057 208301000 1910 Chestnut St 1910 CHESTNUT ST 1910 CHESTNUT ST 1910.0 CHESTNUT ST     Berkeley 94702 37.87064448780918 -122.28843886269884
14361 14361 14361 057 208102900 1955 Chestnut St 202 1955 CHESTNUT ST 202 1955 CHESTNUT ST 1955.0 CHESTNUT ST 202   Berkeley 94702 37.87016344083085 -122.2877203730666
14510 14510 14510 058 213501500 1743 Chestnut St 1743 CHESTNUT ST 1743 CHESTNUT ST 1743.0 CHESTNUT ST     Berkeley 94702 37.87261268856717 -122.28808345144316
14764 14764 14764 059 229200400 1500 Chestnut St 1500 CHESTNUT ST 1500 CHESTNUT ST 1500.0 CHESTNUT ST     Berkeley 94702 37.87656517009046 -122.28920630063256
15038 15038 15038 057 208102900 1955 Chestnut St 102 1955 CHESTNUT ST 102 1955 CHESTNUT ST 1955.0 CHESTNUT ST 102   Berkeley 94702 37.87016344083085 -122.2877203730666
15111 15111 15111 057 208102000 1905 Chestnut St 1905 CHESTNUT ST 1905 CHESTNUT ST 1905.0 CHESTNUT ST     Berkeley 94702 37.87091188140496 -122.28794715006514
15525 15525 15525 057 208102100 1951 Chestnut St 106 1951 CHESTNUT ST 106 1951 CHESTNUT ST 1951.0 CHESTNUT ST 106   Berkeley 94702 37.87030294074293 -122.28775667398725
15686 15686 15686 059 229202100 1606 Chestnut St 1606 CHESTNUT ST 1606 CHESTNUT ST 1606.0 CHESTNUT ST     Berkeley 94702 37.87530789752628 -122.28897754464546
15860 15860 15860 057 208102100 1951 Chestnut St 305 1951 CHESTNUT ST 305 1951 CHESTNUT ST 1951.0 CHESTNUT ST 305   Berkeley 94702 37.87030294074293 -122.28775667398725
17233 17233 17233 057 208102900 1955 Chestnut St 303 1955 CHESTNUT ST 303 1955 CHESTNUT ST 1955.0 CHESTNUT ST 303   Berkeley 94702 37.87016344083085 -122.2877203730666
17450 17450 17450 057 208102900 1955 Chestnut St 105 1955 CHESTNUT ST 105 1955 CHESTNUT ST 1955.0 CHESTNUT ST 105   Berkeley 94702 37.87016344083085 -122.2877203730666
17469 17469 17469 058 213801000 1615 Chestnut St 1615 CHESTNUT ST 1615 CHESTNUT ST 1615.0 CHESTNUT ST     Berkeley 94702 37.87544365083158 -122.28841076878663
17985 17985 17985 057 208200700 1800 Chestnut St 1800 CHESTNUT ST 1800 CHESTNUT ST 1800.0 CHESTNUT ST     Berkeley 94702 37.87208475003853 -122.28852731261836
18095 18095 18095 057 208102900 1955 Chestnut St 104 1955 CHESTNUT ST 104 1955 CHESTNUT ST 1955.0 CHESTNUT ST 104   Berkeley 94702 37.87016344083085 -122.2877203730666
18224 18224 18224 057 208102100 1951 Chestnut St 112 1951 CHESTNUT ST 112 1951 CHESTNUT ST 1951.0 CHESTNUT ST 112   Berkeley 94702 37.87030294074293 -122.28775667398725
18770 18770 18770 057 208102100 1951 Chestnut St 312 1951 CHESTNUT ST 312 1951 CHESTNUT ST 1951.0 CHESTNUT ST 312   Berkeley 94702 37.87030294074293 -122.28775667398725
18981 18981 18981 057 208102100 1951 Chestnut St 201 1951 CHESTNUT ST 201 1951 CHESTNUT ST 1951.0 CHESTNUT ST 201   Berkeley 94702 37.87030294074293 -122.28775667398725
19336 19336 19336 057 208102100 1951 Chestnut St 202 1951 CHESTNUT ST 202 1951 CHESTNUT ST 1951.0 CHESTNUT ST 202   Berkeley 94702 37.87030294074293 -122.28775667398725
20132 20132 20132 057 208102100 1951 Chestnut St 203 1951 CHESTNUT ST 203 1951 CHESTNUT ST 1951.0 CHESTNUT ST 203   Berkeley 94702 37.87030294074293 -122.28775667398725
20489 20489 20489 057 208002300 1809 Chestnut St 1809 CHESTNUT ST 1809 CHESTNUT ST 1809.0 CHESTNUT ST     Berkeley 94702 37.871889282211725 -122.28805559738116
20772 20772 20772 058 213302300 1718 Chestnut St 1718 CHESTNUT ST 1718 CHESTNUT ST 1718.0 CHESTNUT ST     Berkeley 94702 37.87350841525197 -122.28879201199658
20837 20837 20837 059 229202202 1608 Chestnut St 1608 CHESTNUT ST 1608 CHESTNUT ST 1608.0 CHESTNUT ST     Berkeley 94702 37.87522348527737 -122.28895638033738
21037 21037 21037 057 208301300 1918 Chestnut St 1918 CHESTNUT ST 1918 CHESTNUT ST 1918.0 CHESTNUT ST     Berkeley 94702 37.87032499049667 -122.28840167963256
21065 21065 21065 057 208102100 1951 Chestnut St 207 1951 CHESTNUT ST 207 1951 CHESTNUT ST 1951.0 CHESTNUT ST 207   Berkeley 94702 37.87030294074293 -122.28775667398725
22126 22126 22126 058 213602301 1711 Chestnut St 1711 CHESTNUT ST 1711 CHESTNUT ST 1711.0 CHESTNUT ST     Berkeley 94702 37.87360577905914 -122.28821309450836
22261 22261 22261 057 208102100 1951 Chestnut St 111 1951 CHESTNUT ST 111 1951 CHESTNUT ST 1951.0 CHESTNUT ST 111   Berkeley 94702 37.87030294074293 -122.28775667398725
22365 22365 22365 057 208102900 1955 Chestnut St 302 1955 CHESTNUT ST 302 1955 CHESTNUT ST 1955.0 CHESTNUT ST 302   Berkeley 94702 37.87016344083085 -122.2877203730666
22782 22782 22782 059 229203000 1636 Chestnut St 1636 CHESTNUT ST 1636 CHESTNUT ST 1636.0 CHESTNUT ST     Berkeley 94702 37.87449964152159 -122.28884797703878
23285 23285 23285 057 208200800 1802 Chestnut St 1802 CHESTNUT ST 1802 CHESTNUT ST 1802.0 CHESTNUT ST     Berkeley 94702 37.87197682973785 -122.2885151260732
24101 24101 24101 058 213501600 1737 Chestnut St 1737 CHESTNUT ST 1737 CHESTNUT ST 1737.0 CHESTNUT ST     Berkeley 94702 37.87273629838837 -122.28809857997088
24440 24440 24440 057 208102100 1951 Chestnut St 110 1951 CHESTNUT ST 110 1951 CHESTNUT ST 1951.0 CHESTNUT ST 110   Berkeley 94702 37.87030294074293 -122.28775667398725
24954 24954 24954 058 213602302 1707 Chestnut St 1707 CHESTNUT ST 1707 CHESTNUT ST 1707.0 CHESTNUT ST     Berkeley 94702 37.873703275339224 -122.28822582543256
25054 25054 25054 057 208201401 1822 Chestnut St B 1822 CHESTNUT ST B 1822 CHESTNUT ST 1822.0 CHESTNUT ST B   Berkeley 94702 37.87132359830617 -122.2884414184058
25689 25689 25689 058 213401200 1738 Chestnut St 1738 CHESTNUT ST 1738 CHESTNUT ST 1738.0 CHESTNUT ST     Berkeley 94702 37.87269268747557 -122.28867968036523
26113 26113 26113 057 208102900 1955 Chestnut St 205 1955 CHESTNUT ST 205 1955 CHESTNUT ST 1955.0 CHESTNUT ST 205   Berkeley 94702 37.87016344083085 -122.2877203730666
26148 26148 26148 059 229202501 1624 Chestnut St 1624 CHESTNUT ST 1624 CHESTNUT ST 1624.0 CHESTNUT ST     Berkeley 94702 37.87490765040695 -122.2889279998626
27635 27635 27635 058 213401100 1734 Chestnut St 1734 CHESTNUT ST 1734 CHESTNUT ST 1734.0 CHESTNUT ST     Berkeley 94702 37.87282463059956 -122.28868938306864
27699 27699 27699 057 208201101 1812 Chestnut St B 1812 CHESTNUT ST B 1812 CHESTNUT ST 1812.0 CHESTNUT ST B   Berkeley 94702 37.8716409575482 -122.2884767186032
28050 28050 28050 057 208201001 1808 Chestnut St 1808 CHESTNUT ST 1808 CHESTNUT ST 1808.0 CHESTNUT ST     Berkeley 94702 37.87174952363857 -122.28848888897868
29394 29394 29394 059 229200500 1506 Chestnut St 1506 CHESTNUT ST 1506 CHESTNUT ST 1506.0 CHESTNUT ST     Berkeley 94702 37.876351949013845 -122.28918465931906
29582 29582 29582 059 229202701 1626 Chestnut St 1626 CHESTNUT ST 1626 CHESTNUT ST 1626.0 CHESTNUT ST     Berkeley 94702 37.87477245558522 -122.2888970546977
29630 29630 29630 057 208102900 1955 Chestnut St 207 1955 CHESTNUT ST 207 1955 CHESTNUT ST 1955.0 CHESTNUT ST 207   Berkeley 94702 37.87016344083085 -122.2877203730666
29793 29793 29793 057 208102100 1951 Chestnut St 304 1951 CHESTNUT ST 304 1951 CHESTNUT ST 1951.0 CHESTNUT ST 304   Berkeley 94702 37.87030294074293 -122.28775667398725
29811 29811 29811 058 213602302 1709 Chestnut St 1709 CHESTNUT ST 1709 CHESTNUT ST 1709.0 CHESTNUT ST     Berkeley 94702 37.873703275339224 -122.28822582543256
30064 30064 30064 058 213600100 1703 Chestnut St 1703 CHESTNUT ST 1703 CHESTNUT ST 1703.0 CHESTNUT ST     Berkeley 94702 37.87387440991948 -122.28834519356752
30729 30729 30729 057 208201101 1812 Chestnut St 1812 CHESTNUT ST 1812 CHESTNUT ST 1812.0 CHESTNUT ST     Berkeley 94702 37.8716409575482 -122.2884767186032
31009 31009 31009 057 208102100 1951 Chestnut St 301 1951 CHESTNUT ST 301 1951 CHESTNUT ST 1951.0 CHESTNUT ST 301   Berkeley 94702 37.87030294074293 -122.28775667398725
32070 32070 32070 057 208201300 1820 Chestnut St 1820 CHESTNUT ST 1820 CHESTNUT ST 1820.0 CHESTNUT ST     Berkeley 94702 37.87143037575101 -122.28845255931196
32470 32470 32470 058 213701700 1631 Chestnut St 1631 CHESTNUT ST 1631 CHESTNUT ST 1631.0 CHESTNUT ST     Berkeley 94702 37.87479725030289 -122.28833709795018
32877 32877 32877 057 208102900 1955 Chestnut St 208 1955 CHESTNUT ST 208 1955 CHESTNUT ST 1955.0 CHESTNUT ST 208   Berkeley 94702 37.87016344083085 -122.2877203730666
32905 32905 32905 057 208102900 1955 Chestnut St 1955 CHESTNUT ST 1955 CHESTNUT ST 1955.0 CHESTNUT ST     Berkeley 94702 37.87016344083085 -122.2877203730666
33646 33646 33646 058 213501800 1731 Chestnut St 1731 CHESTNUT ST 1731 CHESTNUT ST 1731.0 CHESTNUT ST     Berkeley 94702 37.872980092424555 -122.28812521681569
33970 33970 33970 057 208102100 1951 Chestnut St 212 1951 CHESTNUT ST 212 1951 CHESTNUT ST 1951.0 CHESTNUT ST 212   Berkeley 94702 37.87030294074293 -122.28775667398725
34592 34592 34592 057 208101900 1907 Chestnut St 1907 CHESTNUT ST 1907 CHESTNUT ST 1907.0 CHESTNUT ST     Berkeley 94702 37.87082192158083 -122.28793812469146
35044 35044 35044 059 229202400 1620 Chestnut St 1620 CHESTNUT ST 1620 CHESTNUT ST 1620.0 CHESTNUT ST     Berkeley 94702 37.875015693340856 -122.28891327917005
36799 36799 36799 057 208102900 1955 Chestnut St 203 1955 CHESTNUT ST 203 1955 CHESTNUT ST 1955.0 CHESTNUT ST 203   Berkeley 94702 37.87016344083085 -122.2877203730666
37270 37270 37270 058 213800900 1619 Chestnut St 1619 CHESTNUT ST 1619 CHESTNUT ST 1619.0 CHESTNUT ST     Berkeley 94702 37.87533455482682 -122.28839945809888
37338 37338 37338 057 208102100 1951 Chestnut St 206 1951 CHESTNUT ST 206 1951 CHESTNUT ST 1951.0 CHESTNUT ST 206   Berkeley 94702 37.87030294074293 -122.28775667398725
38377 38377 38377 059 229202000 1604 Chestnut St 1604 CHESTNUT ST 1604 CHESTNUT ST 1604.0 CHESTNUT ST     Berkeley 94702 37.87541079547582 -122.28899816816777
38555 38555 38555 058 213300800 1706 Chestnut St 1706 CHESTNUT ST 1706 CHESTNUT ST 1706.0 CHESTNUT ST     Berkeley 94702 37.8737289738092 -122.28874451896584
38627 38627 38627 057 208200900 1804 Chestnut St 1804 CHESTNUT ST 1804 CHESTNUT ST 1804.0 CHESTNUT ST     Berkeley 94702 37.8718666379768 -122.28850034429516
39243 39243 39243 058 213300900 1710 Chestnut St 1710 CHESTNUT ST 1710 CHESTNUT ST 1710.0 CHESTNUT ST     Berkeley 94702 37.87363503795502 -122.28873359455366
39328 39328 39328 057 208102100 1951 Chestnut St 209 1951 CHESTNUT ST 209 1951 CHESTNUT ST 1951.0 CHESTNUT ST 209   Berkeley 94702 37.87030294074293 -122.28775667398725
39404 39404 39404 057 208102100 1951 Chestnut St 310 1951 CHESTNUT ST 310 1951 CHESTNUT ST 1951.0 CHESTNUT ST 310   Berkeley 94702 37.87030294074293 -122.28775667398725

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