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

186 rows where street_name = "HOPKINS" and zipcode = 94707

✎ View and edit SQL

This data as json, CSV (advanced)

street_type 2

zipcode 1

  • 94707 · 186 ✖

street_name 1

  • HOPKINS · 186 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
36 36 36 061 257000700 1971 Hopkins St 1971 HOPKINS ST 1971 HOPKINS ST 1971.0 HOPKINS ST     Berkeley 94707 37.887872896105094 -122.27334417094248
201 201 201 061 256500800 1970 Hopkins St 1970 HOPKINS ST 1970 HOPKINS ST 1970.0 HOPKINS ST     Berkeley 94707 37.88759802777184 -122.2728641624586
854 854 854 060 243800300 1620 Hopkins St 1620 HOPKINS ST 1620 HOPKINS ST 1620.0 HOPKINS ST     Berkeley 94707 37.88212473093657 -122.28050979570698
1131 1131 1131 060 242902800 39 Hopkins Ct A 39 HOPKINS CT A 39 HOPKINS CT 39.0 HOPKINS CT A   Berkeley 94707 37.88153173461418 -122.28271461265544
1179 1179 1179 060 242902700 1547 Hopkins St 3 1547 HOPKINS ST 3 1547 HOPKINS ST 1547.0 HOPKINS ST 3   Berkeley 94707 37.88163074834889 -122.28258261690256
1252 1252 1252 060 243502701 1607 Hopkins St 4 1607 HOPKINS ST 4 1607 HOPKINS ST 1607.0 HOPKINS ST 4   Berkeley 94707 37.882316135172914 -122.28145627416504
1255 1255 1255 061 256800100 1938 Hopkins St 1938 HOPKINS ST 1938 HOPKINS ST 1938.0 HOPKINS ST     Berkeley 94707 37.886398438782294 -122.273591901145
1259 1259 1259 060 244505301 1632 Hopkins St 1632 HOPKINS ST 1632 HOPKINS ST 1632.0 HOPKINS ST     Berkeley 94707 37.88244583333378 -122.27981002606695
1318 1318 1318 061 257100307 2003 Hopkins St 2003 HOPKINS ST 2003 HOPKINS ST 2003.0 HOPKINS ST     Berkeley 94707 37.888976852517885 -122.27268739018037
1635 1635 1635 060 243800100 1612 Hopkins St 3 1612 HOPKINS ST 3 1612 HOPKINS ST 1612.0 HOPKINS ST 3   Berkeley 94707 37.882046960083265 -122.28087905000112
2046 2046 2046 060 243800100 1600 Hopkins St 1600 HOPKINS ST 1600 HOPKINS ST 1600.0 HOPKINS ST     Berkeley 94707 37.882046960083265 -122.28087905000112
2133 2133 2133 060 242906600 1515 Hopkins St 1515 HOPKINS ST 1515 HOPKINS ST 1515.0 HOPKINS ST     Berkeley 94707 37.881380615892816 -122.28296645714198
2308 2308 2308 060 243502205 1619 Hopkins St 202 1619 HOPKINS ST 202 1619 HOPKINS ST 1619.0 HOPKINS ST 202   Berkeley 94707 37.88244543557616 -122.28110589078004
2884 2884 2884 060 243701800 1735 Hopkins St 1735 HOPKINS ST 1735 HOPKINS ST 1735.0 HOPKINS ST     Berkeley 94707 37.883936469086905 -122.27817113067944
4131 4131 4131 061 256900700 1931 Hopkins St 1931 HOPKINS ST 1931 HOPKINS ST 1931.0 HOPKINS ST     Berkeley 94707 37.88654302462929 -122.27423131837097
4152 4152 4152 061 256901000 1921 Hopkins St 1921 HOPKINS ST 1921 HOPKINS ST 1921.0 HOPKINS ST     Berkeley 94707 37.88621943102024 -122.2745094358846
4624 4624 4624 061 256801701 1922 Hopkins St 1922 HOPKINS ST 1922 HOPKINS ST 1922.0 HOPKINS ST     Berkeley 94707 37.88581709213993 -122.2739466287827
5096 5096 5096 060 243502205 1619 Hopkins St 304 1619 HOPKINS ST 304 1619 HOPKINS ST 1619.0 HOPKINS ST 304   Berkeley 94707 37.88244543557616 -122.28110589078004
5391 5391 5391 061 257000500 1977 Hopkins St 1977 HOPKINS ST 1977 HOPKINS ST 1977.0 HOPKINS ST     Berkeley 94707 37.88812877815848 -122.2732726102486
5481 5481 5481 060 243401600 1510 Hopkins St 1510 HOPKINS ST 1510 HOPKINS ST 1510.0 HOPKINS ST     Berkeley 94707 37.88095041336467 -122.28286796585428
6170 6170 6170 060 242902700 1547 Hopkins St 7 1547 HOPKINS ST 7 1547 HOPKINS ST 1547.0 HOPKINS ST 7   Berkeley 94707 37.88163074834889 -122.28258261690256
6794 6794 6794 060 243402800 1584 Hopkins St 7000 1584 HOPKINS ST 7000 1584 HOPKINS ST 1584.0 HOPKINS ST 7000   Berkeley 94707 37.88165945031035 -122.28146144666444
6854 6854 6854 060 244505301 1642 Hopkins St 1642 HOPKINS ST 1642 HOPKINS ST 1642.0 HOPKINS ST     Berkeley 94707 37.88244583333378 -122.27981002606695
7105 7105 7105 060 243502204 1629 Hopkins St 1629 HOPKINS ST 1629 HOPKINS ST 1629.0 HOPKINS ST     Berkeley 94707 37.88250242975147 -122.28088056006912
7311 7311 7311 060 243701100 1759 Hopkins St 1759 HOPKINS ST 1759 HOPKINS ST 1759.0 HOPKINS ST     Berkeley 94707 37.88422241075225 -122.27727406315526
8073 8073 8073 060 243402800 1578 Hopkins St 7000 1578 HOPKINS ST 7000 1578 HOPKINS ST 1578.0 HOPKINS ST 7000   Berkeley 94707 37.88165945031035 -122.28146144666444
8598 8598 8598 061 260600400 1817 Hopkins St 1817 HOPKINS ST 1817 HOPKINS ST 1817.0 HOPKINS ST     Berkeley 94707 37.88480058377112 -122.276345064116
9019 9019 9019 060 243502205 1619 Hopkins St 301 1619 HOPKINS ST 301 1619 HOPKINS ST 1619.0 HOPKINS ST 301   Berkeley 94707 37.88244543557616 -122.28110589078004
9105 9105 9105 060 243502205 1619 Hopkins St 205 1619 HOPKINS ST 205 1619 HOPKINS ST 1619.0 HOPKINS ST 205   Berkeley 94707 37.88244543557616 -122.28110589078004
9373 9373 9373 060 243701600 1741 Hopkins St 1741 HOPKINS ST 1741 HOPKINS ST 1741.0 HOPKINS ST     Berkeley 94707 37.8840415287765 -122.27793854517428
9823 9823 9823 060 242902700 1547 Hopkins St 6 1547 HOPKINS ST 6 1547 HOPKINS ST 1547.0 HOPKINS ST 6   Berkeley 94707 37.88163074834889 -122.28258261690256
9874 9874 9874 060 243502205 1619 Hopkins St 201 1619 HOPKINS ST 201 1619 HOPKINS ST 1619.0 HOPKINS ST 201   Berkeley 94707 37.88244543557616 -122.28110589078004
10255 10255 10255 060 242902800 1545 Hopkins St 6 1545 HOPKINS ST 6 1545 HOPKINS ST 1545.0 HOPKINS ST 6   Berkeley 94707 37.88153173461418 -122.28271461265544
10281 10281 10281 061 256900300 1949 Hopkins St 1949 HOPKINS ST 1949 HOPKINS ST 1949.0 HOPKINS ST     Berkeley 94707 37.887026521195814 -122.27386683952084
10301 10301 10301 060 242902800 39 Hopkins Ct C 39 HOPKINS CT C 39 HOPKINS CT 39.0 HOPKINS CT C   Berkeley 94707 37.88153173461418 -122.28271461265544
10926 10926 10926 061 256801900 1924 Hopkins St 1924 HOPKINS ST 1924 HOPKINS ST 1924.0 HOPKINS ST     Berkeley 94707 37.885947088288134 -122.2738366022284
11755 11755 11755 061 256900500 1937 Hopkins St 1937 HOPKINS ST 1937 HOPKINS ST 1937.0 HOPKINS ST     Berkeley 94707 37.88678155846876 -122.27404552610896
11922 11922 11922 060 243702800 1701 Hopkins St 1701 HOPKINS ST 1701 HOPKINS ST 1701.0 HOPKINS ST     Berkeley 94707 37.88321451254264 -122.27933081169378
11962 11962 11962 060 244500102 1810 Hopkins St 1810 HOPKINS ST 1810 HOPKINS ST 1810.0 HOPKINS ST     Berkeley 94707 37.88298001914184 -122.27874831352084
12102 12102 12102 061 256902801 1953 Hopkins St 1953 HOPKINS ST 1953 HOPKINS ST 1953.0 HOPKINS ST     Berkeley 94707 37.88735357882102 -122.27375044031793
12350 12350 12350 060 243502801 1601 Hopkins St 1601 HOPKINS ST 1601 HOPKINS ST 1601.0 HOPKINS ST     Berkeley 94707 37.88220885592382 -122.2816081451436
12519 12519 12519 060 244505301 1640 Hopkins St 1640 HOPKINS ST 1640 HOPKINS ST 1640.0 HOPKINS ST     Berkeley 94707 37.88244583333378 -122.27981002606695
13606 13606 13606 060 243502205 1619 Hopkins St 101 1619 HOPKINS ST 101 1619 HOPKINS ST 1619.0 HOPKINS ST 101   Berkeley 94707 37.88244543557616 -122.28110589078004
13686 13686 13686 060 243502205 1619 Hopkins St 203 1619 HOPKINS ST 203 1619 HOPKINS ST 1619.0 HOPKINS ST 203   Berkeley 94707 37.88244543557616 -122.28110589078004
13820 13820 13820 060 243800100 1612 Hopkins St 1 1612 HOPKINS ST 1 1612 HOPKINS ST 1612.0 HOPKINS ST 1   Berkeley 94707 37.882046960083265 -122.28087905000112
13996 13996 13996 060 243800500 1624 Hopkins St 1624 HOPKINS ST 1624 HOPKINS ST 1624.0 HOPKINS ST     Berkeley 94707 37.88222104322645 -122.28030529962244
14543 14543 14543 060 243800400 1622 Hopkins St 1622 HOPKINS ST 1622 HOPKINS ST 1622.0 HOPKINS ST     Berkeley 94707 37.882166275859035 -122.28040467395412
15629 15629 15629 060 243701200 1755 Hopkins St 1755 HOPKINS ST 1755 HOPKINS ST 1755.0 HOPKINS ST     Berkeley 94707 37.88425383992772 -122.27746322320128
15726 15726 15726 060 243400103 1598 Hopkins St 1598 HOPKINS ST 1598 HOPKINS ST 1598.0 HOPKINS ST     Berkeley 94707 37.88178876746506 -122.2812139212778
16234 16234 16234 060 242902800 1545 Hopkins St 2 1545 HOPKINS ST 2 1545 HOPKINS ST 1545.0 HOPKINS ST 2   Berkeley 94707 37.88153173461418 -122.28271461265544
16364 16364 16364 060 242902600 1549 Hopkins St 1549 HOPKINS ST 1549 HOPKINS ST 1549.0 HOPKINS ST     Berkeley 94707 37.88173035327499 -122.28232839277884
16370 16370 16370 061 260600500 1815 Hopkins St 1815 HOPKINS ST 1815 HOPKINS ST 1815.0 HOPKINS ST     Berkeley 94707 37.88472695555594 -122.27645359946692
16457 16457 16457 061 256500200 1950 Hopkins St 1950 HOPKINS ST 1950 HOPKINS ST 1950.0 HOPKINS ST     Berkeley 94707 37.88679551248549 -122.2731715937966
16541 16541 16541 061 256900800 1927 Hopkins St 1927 HOPKINS ST 1927 HOPKINS ST 1927.0 HOPKINS ST     Berkeley 94707 37.88642298782523 -122.27432897781875
16543 16543 16543 061 257100307 2007 Hopkins St 2007 HOPKINS ST 2007 HOPKINS ST 2007.0 HOPKINS ST     Berkeley 94707 37.888976852517885 -122.27268739018037
16929 16929 16929 061 257100307 2009 Hopkins St 2009 HOPKINS ST 2009 HOPKINS ST 2009.0 HOPKINS ST     Berkeley 94707 37.888976852517885 -122.27268739018037
17063 17063 17063 060 242902800 1545 Hopkins St 4 1545 HOPKINS ST 4 1545 HOPKINS ST 1545.0 HOPKINS ST 4   Berkeley 94707 37.88153173461418 -122.28271461265544
17197 17197 17197 060 242902800 39 Hopkins Ct 7 39 HOPKINS CT 7 39 HOPKINS CT 39.0 HOPKINS CT 7   Berkeley 94707 37.88153173461418 -122.28271461265544
17256 17256 17256 060 242902700 1547 Hopkins St 1 1547 HOPKINS ST 1 1547 HOPKINS ST 1547.0 HOPKINS ST 1   Berkeley 94707 37.88163074834889 -122.28258261690256
17338 17338 17338 060 243601700 1655 Hopkins St 3 1655 HOPKINS ST 3 1655 HOPKINS ST 1655.0 HOPKINS ST 3   Berkeley 94707 37.88279217445317 -122.28020810011206
17791 17791 17791 060 242902800 1545 Hopkins St 8 1545 HOPKINS ST 8 1545 HOPKINS ST 1545.0 HOPKINS ST 8   Berkeley 94707 37.88153173461418 -122.28271461265544
17855 17855 17855 060 243502205 1619 Hopkins St 305 1619 HOPKINS ST 305 1619 HOPKINS ST 1619.0 HOPKINS ST 305   Berkeley 94707 37.88244543557616 -122.28110589078004
17941 17941 17941 061 260600300 1821 Hopkins St 1821 HOPKINS ST 1821 HOPKINS ST 1821.0 HOPKINS ST     Berkeley 94707 37.88477217655688 -122.27610592629912
18103 18103 18103 060 243805000 1626 Hopkins St 1626 HOPKINS ST 1626 HOPKINS ST 1626.0 HOPKINS ST     Berkeley 94707 37.88226887991199 -122.28020778390508
18143 18143 18143 060 243402200 1576 Hopkins St 1576 HOPKINS ST 1576 HOPKINS ST 1576.0 HOPKINS ST     Berkeley 94707 37.88154347250763 -122.28169522243736
19088 19088 19088 061 256802200 1934 Hopkins St 1934 HOPKINS ST 1934 HOPKINS ST 1934.0 HOPKINS ST     Berkeley 94707 37.88630486152169 -122.27365553959636
19489 19489 19489 061 256500400 1958 Hopkins St 1958 HOPKINS ST 1958 HOPKINS ST 1958.0 HOPKINS ST     Berkeley 94707 37.88707301622302 -122.27307085851729
20188 20188 20188 060 243502701 1607 Hopkins St 1 1607 HOPKINS ST 1 1607 HOPKINS ST 1607.0 HOPKINS ST 1   Berkeley 94707 37.882316135172914 -122.28145627416504
20263 20263 20263 060 243503101 1575 Hopkins St 1575 HOPKINS ST 1575 HOPKINS ST 1575.0 HOPKINS ST     Berkeley 94707 37.8820468182794 -122.2817993955693
20314 20314 20314 060 243800100 1612 Hopkins St 2 1612 HOPKINS ST 2 1612 HOPKINS ST 1612.0 HOPKINS ST 2   Berkeley 94707 37.882046960083265 -122.28087905000112
20873 20873 20873 061 256500700 1968 Hopkins St 1968 HOPKINS ST 1968 HOPKINS ST 1968.0 HOPKINS ST     Berkeley 94707 37.88746492571794 -122.2729155505844
20916 20916 20916 060 243502205 1619 Hopkins St 307 1619 HOPKINS ST 307 1619 HOPKINS ST 1619.0 HOPKINS ST 307   Berkeley 94707 37.88244543557616 -122.28110589078004
21104 21104 21104 060 243701900 1733 Hopkins St 1733 HOPKINS ST 1733 HOPKINS ST 1733.0 HOPKINS ST     Berkeley 94707 37.88385087702139 -122.27828349644676
21258 21258 21258 060 243601401 1697 Hopkins St 1697 HOPKINS ST 1697 HOPKINS ST 1697.0 HOPKINS ST     Berkeley 94707 37.88305325205832 -122.27964392577428
22014 22014 22014 061 257000400 1981 Hopkins St 1981 HOPKINS ST 1981 HOPKINS ST 1981.0 HOPKINS ST     Berkeley 94707 37.88822188306087 -122.27318568387184
22057 22057 22057 060 243502205 1619 Hopkins St 204 1619 HOPKINS ST 204 1619 HOPKINS ST 1619.0 HOPKINS ST 204   Berkeley 94707 37.88244543557616 -122.28110589078004
22858 22858 22858 060 243702100 1727 Hopkins St 1727 HOPKINS ST 1727 HOPKINS ST 1727.0 HOPKINS ST     Berkeley 94707 37.883734612687505 -122.27852042350968
23165 23165 23165 060 243701000 1761 Hopkins St 1761 HOPKINS ST 1761 HOPKINS ST 1761.0 HOPKINS ST     Berkeley 94707 37.88428713658952 -122.27716210881631
23410 23410 23410 060 243401800 1522 Hopkins St 1522 HOPKINS ST 1522 HOPKINS ST 1522.0 HOPKINS ST     Berkeley 94707 37.8810106099636 -122.28257632600062
24116 24116 24116 060 243702300 1721 Hopkins St 1721 HOPKINS ST 1721 HOPKINS ST 1721.0 HOPKINS ST     Berkeley 94707 37.883612023853736 -122.27875659598776
24391 24391 24391 060 243502701 1607 Hopkins St 2 1607 HOPKINS ST 2 1607 HOPKINS ST 1607.0 HOPKINS ST 2   Berkeley 94707 37.882316135172914 -122.28145627416504
24392 24392 24392 060 243601600 1665 Hopkins St 1665 HOPKINS ST 1665 HOPKINS ST 1665.0 HOPKINS ST     Berkeley 94707 37.88288691186565 -122.28011930883277
24489 24489 24489 061 256901200 1915 Hopkins St 1915 HOPKINS ST 1915 HOPKINS ST 1915.0 HOPKINS ST     Berkeley 94707 37.88606022465188 -122.27467556312672
24727 24727 24727 060 243601600 1665 Hopkins St A 1665 HOPKINS ST A 1665 HOPKINS ST 1665.0 HOPKINS ST A   Berkeley 94707 37.88288691186565 -122.28011930883277
25533 25533 25533 061 256500500 1962 Hopkins St 1962 HOPKINS ST 1962 HOPKINS ST 1962.0 HOPKINS ST     Berkeley 94707 37.887207961597056 -122.27302299178736
25709 25709 25709 061 260600602 1811 Hopkins St 1811 HOPKINS ST 1811 HOPKINS ST 1811.0 HOPKINS ST     Berkeley 94707 37.8846667102381 -122.27656368980162
25831 25831 25831 060 242902800 39 Hopkins Ct 1 39 HOPKINS CT 1 39 HOPKINS CT 39.0 HOPKINS CT 1   Berkeley 94707 37.88153173461418 -122.28271461265544
25863 25863 25863 060 243502204 1629 Hopkins St 3 1629 HOPKINS ST 3 1629 HOPKINS ST 1629.0 HOPKINS ST 3   Berkeley 94707 37.88250242975147 -122.28088056006912
25940 25940 25940 060 243502205 1619 Hopkins St 206 1619 HOPKINS ST 206 1619 HOPKINS ST 1619.0 HOPKINS ST 206   Berkeley 94707 37.88244543557616 -122.28110589078004
26389 26389 26389 060 242902800 39 Hopkins Ct 5 39 HOPKINS CT 5 39 HOPKINS CT 39.0 HOPKINS CT 5   Berkeley 94707 37.88153173461418 -122.28271461265544
26405 26405 26405 061 257100307 2005 Hopkins St 2005 HOPKINS ST 2005 HOPKINS ST 2005.0 HOPKINS ST     Berkeley 94707 37.888976852517885 -122.27268739018037
26618 26618 26618 060 243502205 1619 Hopkins St 1619 HOPKINS ST 1619 HOPKINS ST 1619.0 HOPKINS ST     Berkeley 94707 37.88244543557616 -122.28110589078004
27662 27662 27662 061 256801600 1918 Hopkins St 1918 HOPKINS ST 1918 HOPKINS ST 1918.0 HOPKINS ST     Berkeley 94707 37.885740996260296 -122.27412683891352
28128 28128 28128 060 243601401 1695 Hopkins St 1695 HOPKINS ST 1695 HOPKINS ST 1695.0 HOPKINS ST     Berkeley 94707 37.88305325205832 -122.27964392577428
28468 28468 28468 060 243502205 1619 Hopkins St 303 1619 HOPKINS ST 303 1619 HOPKINS ST 1619.0 HOPKINS ST 303   Berkeley 94707 37.88244543557616 -122.28110589078004
28582 28582 28582 061 257000600 1973 Hopkins St 1973 HOPKINS ST 1973 HOPKINS ST 1973.0 HOPKINS ST     Berkeley 94707 37.88802099834261 -122.2733294547415
29613 29613 29613 060 242902800 39 Hopkins Ct B 39 HOPKINS CT B 39 HOPKINS CT 39.0 HOPKINS CT B   Berkeley 94707 37.88153173461418 -122.28271461265544
29834 29834 29834 060 243702400 1717 Hopkins St Back 1717 HOPKINS ST BACK 1717 HOPKINS ST 1717.0 HOPKINS ST BACK   Berkeley 94707 37.883549734981294 -122.27887381804751
29964 29964 29964 061 256900400 1945 Hopkins St 1945 HOPKINS ST 1945 HOPKINS ST 1945.0 HOPKINS ST     Berkeley 94707 37.88689577331545 -122.27394873533204
30138 30138 30138 061 256801400 1910 Hopkins St 1910 HOPKINS ST 1910 HOPKINS ST 1910.0 HOPKINS ST     Berkeley 94707 37.88555905949955 -122.27437239698968

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