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

251 rows where street_name = "STUART" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94703 · 251 ✖

street_type 1

street_name 1

  • STUART · 251 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
222 222 222 053 167700600 1816 Stuart St 1816 STUART ST 1816 STUART ST 1816.0 STUART ST     Berkeley 94703 37.85759602905598 -122.27225983522423
421 421 421 054 173000400 1645 Stuart St 1645 STUART ST 1645 STUART ST 1645.0 STUART ST     Berkeley 94703 37.8576471166397 -122.27563366129304
576 576 576 053 167503600 1722 Stuart St B 1722 STUART ST B 1722 STUART ST 1722.0 STUART ST B   Berkeley 94703 37.85734356239292 -122.2742301325948
654 654 654 053 168100200 2012 Stuart St B 2012 STUART ST B 2012 STUART ST 2012.0 STUART ST B   Berkeley 94703 37.858007540912645 -122.26873851836224
685 685 685 054 173001100 1617 Stuart St 1617 STUART ST 1617 STUART ST 1617.0 STUART ST     Berkeley 94703 37.85754592446426 -122.2768074153146
702 702 702 053 167400101 1640 Stuart St 1640 STUART ST 1640 STUART ST 1640.0 STUART ST     Berkeley 94703 37.85716067955841 -122.27560208820572
812 812 812 054 172601000 1819 Stuart St 1819 STUART ST 1819 STUART ST 1819.0 STUART ST     Berkeley 94703 37.85812244224716 -122.27236504860528
1080 1080 1080 054 173301901 1501 Stuart St 3 1501 STUART ST 3 1501 STUART ST 1501.0 STUART ST 3   Berkeley 94703 37.857223377999546 -122.27954181607257
1200 1200 1200 053 167402200 1612 Stuart St 1612 STUART ST 1612 STUART ST 1612.0 STUART ST     Berkeley 94703 37.8569990159211 -122.27686877384176
1701 1701 1701 053 167402100 1610 Stuart St 1610 STUART ST 1610 STUART ST 1610.0 STUART ST     Berkeley 94703 37.85712967005287 -122.27706066476624
1803 1803 1803 054 173000800 1631 Stuart St C 1631 STUART ST C 1631 STUART ST 1631.0 STUART ST C   Berkeley 94703 37.85760913749643 -122.27632212473686
1964 1964 1964 054 172501000 1923 Stuart St 1923 STUART ST 1923 STUART ST 1923.0 STUART ST     Berkeley 94703 37.85834271564179 -122.27041288911865
2663 2663 2663 053 167503203 1730 Stuart St C 1730 STUART ST C 1730 STUART ST 1730.0 STUART ST C   Berkeley 94703 37.85738491347863 -122.27392288630972
2733 2733 2733 054 172500800 1931 Stuart St 1931 STUART ST 1931 STUART ST 1931.0 STUART ST     Berkeley 94703 37.85837937520773 -122.2701210660087
3222 3222 3222 053 167402000 1600 Stuart St D 1600 STUART ST D 1600 STUART ST 1600.0 STUART ST D   Berkeley 94703 37.857097525010175 -122.27732061564993
3489 3489 3489 054 173000900 1629 Stuart St 1629 STUART ST 1629 STUART ST 1629.0 STUART ST     Berkeley 94703 37.85759068978791 -122.27646722062156
3718 3718 3718 053 168002500 1914 Stuart St 1914 STUART ST 1914 STUART ST 1914.0 STUART ST     Berkeley 94703 37.857754084123385 -122.27068552690903
3894 3894 3894 054 172901600 1715 Stuart St 1715 STUART ST 1715 STUART ST 1715.0 STUART ST     Berkeley 94703 37.8578105576607 -122.27474639528688
4106 4106 4106 054 172500600 1935 Stuart St 1935 STUART ST 1935 STUART ST 1935.0 STUART ST     Berkeley 94703 37.85841306372134 -122.26986287312803
4116 4116 4116 053 167402300 1616 Stuart St 1616 STUART ST 1616 STUART ST 1616.0 STUART ST     Berkeley 94703 37.85701320963566 -122.27674958536986
4379 4379 4379 053 167700100 1800 Stuart St 1800 STUART ST 1800 STUART ST 1800.0 STUART ST     Berkeley 94703 37.8575282164931 -122.27294763840638
4406 4406 4406 053 168003300 1936 Stuart St 5 1936 STUART ST 5 1936 STUART ST 1936.0 STUART ST 5   Berkeley 94703 37.85788897682349 -122.26966065427274
4675 4675 4675 053 167102200 1508 Stuart St 1508 STUART ST 1508 STUART ST 1508.0 STUART ST     Berkeley 94703 37.85671711635289 -122.27923601158354
4929 4929 4929 053 167503300 1736 Stuart St B 1736 STUART ST B 1736 STUART ST 1736.0 STUART ST B   Berkeley 94703 37.85741312344238 -122.2737156575501
5082 5082 5082 054 173301800 1511 Stuart St E 1511 STUART ST E 1511 STUART ST 1511.0 STUART ST E   Berkeley 94703 37.85724779987906 -122.27935440235149
5184 5184 5184 053 167502800 1714 Stuart St A 1714 STUART ST A 1714 STUART ST 1714.0 STUART ST A   Berkeley 94703 37.85727657233654 -122.2747085043482
5349 5349 5349 053 167503500 1720 Stuart St 1720 STUART ST 1720 STUART ST 1720.0 STUART ST     Berkeley 94703 37.85732399611951 -122.2743553577454
5394 5394 5394 053 167503203 1730 Stuart St D 1730 STUART ST D 1730 STUART ST 1730.0 STUART ST D   Berkeley 94703 37.85738491347863 -122.27392288630972
5434 5434 5434 053 167402400 1620 Stuart St 1620 STUART ST 1620 STUART ST 1620.0 STUART ST     Berkeley 94703 37.857028691363624 -122.27662180720722
5851 5851 5851 053 167403400 1622 Stuart St B 1622 STUART ST B 1622 STUART ST 1622.0 STUART ST B   Berkeley 94703 37.85704656187527 -122.27648110318594
6021 6021 6021 054 173301800 1511 Stuart St A 1511 STUART ST A 1511 STUART ST 1511.0 STUART ST A   Berkeley 94703 37.85724779987906 -122.27935440235149
6575 6575 6575 053 167503400 1738 Stuart St A 1738 STUART ST A 1738 STUART ST 1738.0 STUART ST A   Berkeley 94703 37.85747546420395 -122.27357256401018
6612 6612 6612 053 167503203 1730 Stuart St H 1730 STUART ST H 1730 STUART ST 1730.0 STUART ST H   Berkeley 94703 37.85738491347863 -122.27392288630972
6678 6678 6678 054 172500900 1927 Stuart St 2 1927 STUART ST 2 1927 STUART ST 1927.0 STUART ST 2   Berkeley 94703 37.858363106499205 -122.27025486557868
6873 6873 6873 054 172201200 2001 Stuart St 2001 STUART ST 2001 STUART ST 2001.0 STUART ST     Berkeley 94703 37.858516199457945 -122.26907109534169
7226 7226 7226 054 172201100 2005 Stuart St 2005 STUART ST 2005 STUART ST 2005.0 STUART ST     Berkeley 94703 37.858534026345005 -122.2689372544492
7251 7251 7251 053 167102500 1520 Stuart St 1520 STUART ST 1520 STUART ST 1520.0 STUART ST     Berkeley 94703 37.856770684127234 -122.27883019136574
7529 7529 7529 054 173301800 1511 Stuart St D 1511 STUART ST D 1511 STUART ST 1511.0 STUART ST D   Berkeley 94703 37.85724779987906 -122.27935440235149
8019 8019 8019 054 172201403 2015 Stuart St 2015 STUART ST 2015 STUART ST 2015.0 STUART ST     Berkeley 94703 37.85843085658958 -122.26864169794094
8220 8220 8220 054 172501200 1917 Stuart St 1917 STUART ST 1917 STUART ST 1917.0 STUART ST     Berkeley 94703 37.8583102484204 -122.27066500220144
8301 8301 8301 053 168002600 1916 Stuart St C 1916 STUART ST C 1916 STUART ST 1916.0 STUART ST C   Berkeley 94703 37.857768436565195 -122.27058275514898
8386 8386 8386 054 173000701 1635 Stuart St 1635 STUART ST 1635 STUART ST 1635.0 STUART ST     Berkeley 94703 37.85782684209478 -122.2761893205002
8387 8387 8387 053 167503203 1730 Stuart St G 1730 STUART ST G 1730 STUART ST 1730.0 STUART ST G   Berkeley 94703 37.85738491347863 -122.27392288630972
8546 8546 8546 053 167502600 1708 Stuart St 1708 STUART ST 1708 STUART ST 1708.0 STUART ST     Berkeley 94703 37.85728958863036 -122.27493303196528
8928 8928 8928 053 168003300 1936 Stuart St 1 1936 STUART ST 1 1936 STUART ST 1936.0 STUART ST 1   Berkeley 94703 37.85788897682349 -122.26966065427274
9031 9031 9031 053 167403100 1638 Stuart St E 1638 STUART ST E 1638 STUART ST 1638.0 STUART ST E   Berkeley 94703 37.85713503772469 -122.2758032901681
9138 9138 9138 053 167503202 1726 Stuart St 1726 STUART ST 1726 STUART ST 1726.0 STUART ST     Berkeley 94703 37.857360231347286 -122.27410163488162
9366 9366 9366 053 167503203 1730 Stuart St 1730 STUART ST 1730 STUART ST 1730.0 STUART ST     Berkeley 94703 37.85738491347863 -122.27392288630972
10559 10559 10559 054 172500900 1927 Stuart St 4 1927 STUART ST 4 1927 STUART ST 1927.0 STUART ST 4   Berkeley 94703 37.858363106499205 -122.27025486557868
10574 10574 10574 053 167403000 1636 Stuart St 1636 STUART ST 1636 STUART ST 1636.0 STUART ST     Berkeley 94703 37.857119853907854 -122.27592067841618
10731 10731 10731 053 167402000 1600 Stuart St 1600 STUART ST 1600 STUART ST 1600.0 STUART ST     Berkeley 94703 37.857097525010175 -122.27732061564993
10794 10794 10794 053 167402901 1632 Stuart St 1632 STUART ST 1632 STUART ST 1632.0 STUART ST     Berkeley 94703 37.85710286431396 -122.27605451481712
10834 10834 10834 054 172901300 1725 Stuart St 1725 STUART ST 1725 STUART ST 1725.0 STUART ST     Berkeley 94703 37.85786643112769 -122.27433114365692
11009 11009 11009 054 172201403 2017 Stuart St 2017 STUART ST 2017 STUART ST 2017.0 STUART ST     Berkeley 94703 37.85843946471339 -122.26861106538972
11476 11476 11476 054 173301901 1501 Stuart St 5 1501 STUART ST 5 1501 STUART ST 1501.0 STUART ST 5   Berkeley 94703 37.857223377999546 -122.27954181607257
11488 11488 11488 053 167502700 1712 Stuart St 1712 STUART ST 1712 STUART ST 1712.0 STUART ST     Berkeley 94703 37.8572649532781 -122.27480515139467
11597 11597 11597 054 173301700 1513 Stuart St 1513 STUART ST 1513 STUART ST 1513.0 STUART ST     Berkeley 94703 37.85726501143721 -122.2792153440438
11824 11824 11824 053 167502400 1700 Stuart St 1700 STUART ST 1700 STUART ST 1700.0 STUART ST     Berkeley 94703 37.857254391721185 -122.27520677648012
11874 11874 11874 053 167102300 1512 Stuart St C 1512 STUART ST C 1512 STUART ST 1512.0 STUART ST C   Berkeley 94703 37.856736857975285 -122.27909782913328
12026 12026 12026 054 173301901 1501 Stuart St 8 1501 STUART ST 8 1501 STUART ST 1501.0 STUART ST 8   Berkeley 94703 37.857223377999546 -122.27954181607257
12133 12133 12133 053 167503400 1738 Stuart St C 1738 STUART ST C 1738 STUART ST 1738.0 STUART ST C   Berkeley 94703 37.85747546420395 -122.27357256401018
12139 12139 12139 054 172601100 1813 Stuart St 1813 STUART ST 1813 STUART ST 1813.0 STUART ST     Berkeley 94703 37.858105150743974 -122.27250226806154
12585 12585 12585 054 172900800 1739 Stuart St 1739 STUART ST 1739 STUART ST 1739.0 STUART ST     Berkeley 94703 37.8579126849755 -122.27364799464628
12604 12604 12604 054 173000900 1629 Stuart St B 1629 STUART ST B 1629 STUART ST 1629.0 STUART ST B   Berkeley 94703 37.85759068978791 -122.27646722062156
13917 13917 13917 054 173000800 1631 Stuart St 1631 STUART ST 1631 STUART ST 1631.0 STUART ST     Berkeley 94703 37.85760913749643 -122.27632212473686
14083 14083 14083 054 173001501 1601 Stuart St 1601 STUART ST 1601 STUART ST 1601.0 STUART ST     Berkeley 94703 37.857414027034864 -122.27746589119764
14195 14195 14195 054 172500400 1945 Stuart St 4 1945 STUART ST 4 1945 STUART ST 1945.0 STUART ST 4   Berkeley 94703 37.858403632868225 -122.26949803135857
14248 14248 14248 054 172201403 2009 Stuart St 2009 STUART ST 2009 STUART ST 2009.0 STUART ST     Berkeley 94703 37.85841276654705 -122.26876119633158
14740 14740 14740 054 173001300 1611 Stuart St 1611 STUART ST 1611 STUART ST 1611.0 STUART ST     Berkeley 94703 37.8575398723913 -122.27712164240774
15200 15200 15200 053 168003300 1936 Stuart St 1936 STUART ST 1936 STUART ST 1936.0 STUART ST     Berkeley 94703 37.85788897682349 -122.26966065427274
15585 15585 15585 054 173000800 1631 Stuart St 2 1631 STUART ST 2 1631 STUART ST 1631.0 STUART ST 2   Berkeley 94703 37.85760913749643 -122.27632212473686
15741 15741 15741 054 172902000 1701 Stuart St 1701 STUART ST 1701 STUART ST 1701.0 STUART ST     Berkeley 94703 37.857694254355074 -122.27528400913668
15900 15900 15900 054 173001300 1609 Stuart St 1609 STUART ST 1609 STUART ST 1609.0 STUART ST     Berkeley 94703 37.8575398723913 -122.27712164240774
16448 16448 16448 054 173301901 1501 Stuart St 7 1501 STUART ST 7 1501 STUART ST 1501.0 STUART ST 7   Berkeley 94703 37.857223377999546 -122.27954181607257
16770 16770 16770 054 172601500 1801 Stuart St 1 1801 STUART ST 1 1801 STUART ST 1801.0 STUART ST 1   Berkeley 94703 37.85800010087412 -122.2730324968614
17066 17066 17066 054 172201200 2003 Stuart St 2003 STUART ST 2003 STUART ST 2003.0 STUART ST     Berkeley 94703 37.858516199457945 -122.26907109534169
17096 17096 17096 054 172901900 1705 Stuart St 1705 STUART ST 1705 STUART ST 1705.0 STUART ST     Berkeley 94703 37.85771180341359 -122.27514154890903
17309 17309 17309 054 172601200 1811 Stuart St 1811 STUART ST 1811 STUART ST 1811.0 STUART ST     Berkeley 94703 37.85808603717408 -122.27263787773684
17400 17400 17400 053 168002600 1916 Stuart St B 1916 STUART ST B 1916 STUART ST 1916.0 STUART ST B   Berkeley 94703 37.857768436565195 -122.27058275514898
17556 17556 17556 053 168000100 1940 Stuart St 1940 STUART ST 1940 STUART ST 1940.0 STUART ST     Berkeley 94703 37.857921761974985 -122.26938605186682
17605 17605 17605 054 172601100 1815 Stuart St 1815 STUART ST 1815 STUART ST 1815.0 STUART ST     Berkeley 94703 37.858105150743974 -122.27250226806154
17670 17670 17670 053 168100200 2012 Stuart St C 2012 STUART ST C 2012 STUART ST 2012.0 STUART ST C   Berkeley 94703 37.858007540912645 -122.26873851836224
18441 18441 18441 053 167403100 1638 Stuart St C 1638 STUART ST C 1638 STUART ST 1638.0 STUART ST C   Berkeley 94703 37.85713503772469 -122.2758032901681
18555 18555 18555 054 172501400 1911 Stuart St 1911 STUART ST 1911 STUART ST 1911.0 STUART ST     Berkeley 94703 37.858273262565994 -122.2709291850484
18945 18945 18945 054 172500900 1927 Stuart St 1927 STUART ST 1927 STUART ST 1927.0 STUART ST     Berkeley 94703 37.858363106499205 -122.27025486557868
18957 18957 18957 054 172500400 1945 Stuart St 1 1945 STUART ST 1 1945 STUART ST 1945.0 STUART ST 1   Berkeley 94703 37.858403632868225 -122.26949803135857
19143 19143 19143 053 167503400 1738 Stuart St 1738 STUART ST 1738 STUART ST 1738.0 STUART ST     Berkeley 94703 37.85747546420395 -122.27357256401018
19573 19573 19573 053 167102300 1512 Stuart St E 1512 STUART ST E 1512 STUART ST 1512.0 STUART ST E   Berkeley 94703 37.856736857975285 -122.27909782913328
19898 19898 19898 054 173001000 1623 Stuart St 1623 STUART ST 1623 STUART ST 1623.0 STUART ST     Berkeley 94703 37.85756846954883 -122.27664163482216
20015 20015 20015 053 167503203 1730 Stuart St A 1730 STUART ST A 1730 STUART ST 1730.0 STUART ST A   Berkeley 94703 37.85738491347863 -122.27392288630972
20337 20337 20337 054 173301901 1501 Stuart St 4 1501 STUART ST 4 1501 STUART ST 1501.0 STUART ST 4   Berkeley 94703 37.857223377999546 -122.27954181607257
20682 20682 20682 053 168003300 1936 Stuart St 4 1936 STUART ST 4 1936 STUART ST 1936.0 STUART ST 4   Berkeley 94703 37.85788897682349 -122.26966065427274
20841 20841 20841 054 173301200 1525 Stuart St 1525 STUART ST 1525 STUART ST 1525.0 STUART ST     Berkeley 94703 37.85735310686272 -122.27852719231537
20970 20970 20970 054 173301100 1529 Stuart St 1529 STUART ST 1529 STUART ST 1529.0 STUART ST     Berkeley 94703 37.857369411257075 -122.27840196806304
21004 21004 21004 054 172500700 1933 Stuart St A 1933 STUART ST A 1933 STUART ST 1933.0 STUART ST A   Berkeley 94703 37.858397837613026 -122.26998196098864
21346 21346 21346 054 173301901 1501 Stuart St 6 1501 STUART ST 6 1501 STUART ST 1501.0 STUART ST 6   Berkeley 94703 37.857223377999546 -122.27954181607257
22179 22179 22179 054 172500900 1927 Stuart St 5 1927 STUART ST 5 1927 STUART ST 1927.0 STUART ST 5   Berkeley 94703 37.858363106499205 -122.27025486557868
22467 22467 22467 054 172501500 1909 Stuart St 1909 STUART ST 1909 STUART ST 1909.0 STUART ST     Berkeley 94703 37.8582065733667 -122.27105918654138
22748 22748 22748 053 167700500 1812 Stuart St 1812 STUART ST 1812 STUART ST 1812.0 STUART ST     Berkeley 94703 37.857580079339115 -122.27239531464384
22819 22819 22819 053 168003300 1936 Stuart St 6 1936 STUART ST 6 1936 STUART ST 1936.0 STUART ST 6   Berkeley 94703 37.85788897682349 -122.26966065427274

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