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

454 rows where street_name = "HOPKINS" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 3

street_type 1

  • ST · 454 ✖

street_name 1

  • HOPKINS · 454 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
34 34 34 059 229300106 1290 Hopkins St 9 1290 HOPKINS ST 9 1290 HOPKINS ST 1290.0 HOPKINS ST 9   Berkeley 94702 37.8775084403227 -122.28851462481325
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
1109 1109 1109 060 244500103 1750 Hopkins St 1750 HOPKINS ST 1750 HOPKINS ST 1750.0 HOPKINS ST     Berkeley 94703 37.88228240086556 -122.27776698042976
1136 1136 1136 060 242307800 1300 Hopkins St 1300 HOPKINS ST 1300 HOPKINS ST 1300.0 HOPKINS ST     Berkeley 94702 37.87795949793365 -122.28813604780308
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
1333 1333 1333 059 229300104 1260 Hopkins St 25 1260 HOPKINS ST 25 1260 HOPKINS ST 1260.0 HOPKINS ST 25   Berkeley 94702 37.87735660853645 -122.28900466747884
1586 1586 1586 059 229300104 1260 Hopkins St 32 1260 HOPKINS ST 32 1260 HOPKINS ST 1260.0 HOPKINS ST 32   Berkeley 94702 37.87735660853645 -122.28900466747884
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
1686 1686 1686 060 242801900 1405 Hopkins St 1405 HOPKINS ST 1405 HOPKINS ST 1405.0 HOPKINS ST     Berkeley 94702 37.88007517549253 -122.28537831600056
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
2348 2348 2348 060 241605100 1333 Hopkins St 1333 HOPKINS ST 1333 HOPKINS ST 1333.0 HOPKINS ST     Berkeley 94702 37.878861383645734 -122.28766659542212
2633 2633 2633 060 241402800 1233 Hopkins St 1233 HOPKINS ST 1233 HOPKINS ST 1233.0 HOPKINS ST     Berkeley 94702 37.87734131685376 -122.29041160797853
2715 2715 2715 059 228900100 1150 Hopkins St 1150 HOPKINS ST 1150 HOPKINS ST 1150.0 HOPKINS ST     Berkeley 94702 37.87591264162224 -122.2922815913796
2817 2817 2817 059 229300104 1260 Hopkins St 36 1260 HOPKINS ST 36 1260 HOPKINS ST 1260.0 HOPKINS ST 36   Berkeley 94702 37.87735660853645 -122.28900466747884
2884 2884 2884 060 243701800 1735 Hopkins St 1735 HOPKINS ST 1735 HOPKINS ST 1735.0 HOPKINS ST     Berkeley 94707 37.883936469086905 -122.27817113067944
2961 2961 2961 059 229300400 1260 Hopkins St 8 1260 HOPKINS ST 8 1260 HOPKINS ST 1260.0 HOPKINS ST 8   Berkeley 94702 37.87703358719588 -122.28925544656344
3056 3056 3056 060 241605100 1333 Hopkins St 3 1333 HOPKINS ST 3 1333 HOPKINS ST 1333.0 HOPKINS ST 3   Berkeley 94702 37.878861383645734 -122.28766659542212
3348 3348 3348 060 242802000 1401 Hopkins St 1401 HOPKINS ST 1401 HOPKINS ST 1401.0 HOPKINS ST     Berkeley 94702 37.880007953682046 -122.28554628119576
3387 3387 3387 060 241605500 1311 Hopkins St 3 1311 HOPKINS ST 3 1311 HOPKINS ST 1311.0 HOPKINS ST 3   Berkeley 94702 37.87870730837377 -122.28825438377376
3415 3415 3415 060 242904500 1497 Hopkins St 7 1497 HOPKINS ST 7 1497 HOPKINS ST 1497.0 HOPKINS ST 7   Berkeley 94702 37.88121297582058 -122.2834745981656
3466 3466 3466 060 242303400 1376 Hopkins St 1376 HOPKINS ST 1376 HOPKINS ST 1376.0 HOPKINS ST     Berkeley 94702 37.87943009755899 -122.28566515525728
3911 3911 3911 060 242904700 1485 Hopkins St A 1485 HOPKINS ST A 1485 HOPKINS ST 1485.0 HOPKINS ST A   Berkeley 94702 37.88102436300061 -122.28370749628448
3925 3925 3925 059 229300104 1260 Hopkins St 41 1260 HOPKINS ST 41 1260 HOPKINS ST 1260.0 HOPKINS ST 41   Berkeley 94702 37.87735660853645 -122.28900466747884
3980 3980 3980 059 229300104 1260 Hopkins St 28 1260 HOPKINS ST 28 1260 HOPKINS ST 1260.0 HOPKINS ST 28   Berkeley 94702 37.87735660853645 -122.28900466747884
4114 4114 4114 060 239103600 1217 Hopkins St 1217 HOPKINS ST 1217 HOPKINS ST 1217.0 HOPKINS ST     Berkeley 94702 37.877019806469136 -122.29104568741508
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
4197 4197 4197 059 229300106 1290 Hopkins St 1 1290 HOPKINS ST 1 1290 HOPKINS ST 1290.0 HOPKINS ST 1   Berkeley 94702 37.8775084403227 -122.28851462481325
4624 4624 4624 061 256801701 1922 Hopkins St 1922 HOPKINS ST 1922 HOPKINS ST 1922.0 HOPKINS ST     Berkeley 94707 37.88581709213993 -122.2739466287827
4816 4816 4816 059 229300106 1290 Hopkins St 8 1290 HOPKINS ST 8 1290 HOPKINS ST 1290.0 HOPKINS ST 8   Berkeley 94702 37.8775084403227 -122.28851462481325
5029 5029 5029 060 239503500 1103 Hopkins St 1103 HOPKINS ST 1103 HOPKINS ST 1103.0 HOPKINS ST     Berkeley 94702 37.87549031555149 -122.29382558604551
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
5407 5407 5407 059 229300104 1260 Hopkins St 50 1260 HOPKINS ST 50 1260 HOPKINS ST 1260.0 HOPKINS ST 50   Berkeley 94702 37.87735660853645 -122.28900466747884
5459 5459 5459 060 242308200 1324 Hopkins St 1324 HOPKINS ST 1324 HOPKINS ST 1324.0 HOPKINS ST     Berkeley 94702 37.87837435555805 -122.28767718386436
5481 5481 5481 060 243401600 1510 Hopkins St 1510 HOPKINS ST 1510 HOPKINS ST 1510.0 HOPKINS ST     Berkeley 94707 37.88095041336467 -122.28286796585428
5854 5854 5854 060 242300900 1357 Hopkins St A 1357 HOPKINS ST A 1357 HOPKINS ST 1357.0 HOPKINS ST A   Berkeley 94702 37.879631775024194 -122.28620567785195
5861 5861 5861 060 242308300 1336 Hopkins St 1336 HOPKINS ST 1336 HOPKINS ST 1336.0 HOPKINS ST     Berkeley 94702 37.878426274639054 -122.28757093203087
5996 5996 5996 060 242303100 1362 Hopkins St 1362 HOPKINS ST 1362 HOPKINS ST 1362.0 HOPKINS ST     Berkeley 94702 37.87919811560546 -122.28609712094143
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
6266 6266 6266 059 229300106 1290 Hopkins St 32 1290 HOPKINS ST 32 1290 HOPKINS ST 1290.0 HOPKINS ST 32   Berkeley 94702 37.8775084403227 -122.28851462481325
6793 6793 6793 059 229300104 1260 Hopkins St 39 1260 HOPKINS ST 39 1260 HOPKINS ST 1260.0 HOPKINS ST 39   Berkeley 94702 37.87735660853645 -122.28900466747884
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
7364 7364 7364 060 242307800 1300 Hopkins St B 1300 HOPKINS ST B 1300 HOPKINS ST 1300.0 HOPKINS ST B   Berkeley 94702 37.87795949793365 -122.28813604780308
7377 7377 7377 060 242307900 1306 Hopkins St 3 1306 HOPKINS ST 3 1306 HOPKINS ST 1306.0 HOPKINS ST 3   Berkeley 94702 37.87801222846944 -122.2880050940959
7387 7387 7387 060 243002900 1454 Hopkins St 1454 HOPKINS ST 1454 HOPKINS ST 1454.0 HOPKINS ST     Berkeley 94702 37.88025879416407 -122.28400271233124
7442 7442 7442 060 242801400 1429 Hopkins St 1429 HOPKINS ST 1429 HOPKINS ST 1429.0 HOPKINS ST     Berkeley 94702 37.88039043445006 -122.28482950195584
7701 7701 7701 060 242904500 1497 Hopkins St 2D 1497 HOPKINS ST 2D 1497 HOPKINS ST 1497.0 HOPKINS ST 2D   Berkeley 94702 37.88121297582058 -122.2834745981656
7940 7940 7940 059 229301400 1228 Hopkins St 1228 HOPKINS ST 1228 HOPKINS ST 1228.0 HOPKINS ST     Berkeley 94702 37.87684732771002 -122.2905162078102
7990 7990 7990 060 242301000 1351 Hopkins St 1351 HOPKINS ST 1351 HOPKINS ST 1351.0 HOPKINS ST     Berkeley 94702 37.87955327618724 -122.28650202757262
8022 8022 8022 060 243003000 1458 Hopkins St 4 1458 HOPKINS ST 4 1458 HOPKINS ST 1458.0 HOPKINS ST 4   Berkeley 94702 37.88033780700891 -122.2838633315284
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
8473 8473 8473 060 241605100 1333 Hopkins St 2 1333 HOPKINS ST 2 1333 HOPKINS ST 1333.0 HOPKINS ST 2   Berkeley 94702 37.878861383645734 -122.28766659542212
8598 8598 8598 061 260600400 1817 Hopkins St 1817 HOPKINS ST 1817 HOPKINS ST 1817.0 HOPKINS ST     Berkeley 94707 37.88480058377112 -122.276345064116
8855 8855 8855 060 242801200 1443 Hopkins St 1443 HOPKINS ST 1443 HOPKINS ST 1443.0 HOPKINS ST     Berkeley 94702 37.88055182839105 -122.28461577388512
8990 8990 8990 060 241605800 1301 Hopkins St 1301 HOPKINS ST 1301 HOPKINS ST 1301.0 HOPKINS ST     Berkeley 94702 37.878300554290185 -122.28860846821772
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
9103 9103 9103 060 242904500 1497 Hopkins St 1497 HOPKINS ST 1497 HOPKINS ST 1497.0 HOPKINS ST     Berkeley 94702 37.88121297582058 -122.2834745981656
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
9165 9165 9165 059 229300106 1290 Hopkins St 17 1290 HOPKINS ST 17 1290 HOPKINS ST 1290.0 HOPKINS ST 17   Berkeley 94702 37.8775084403227 -122.28851462481325
9248 9248 9248 059 228900200 1154 Hopkins St 1154 HOPKINS ST 1154 HOPKINS ST 1154.0 HOPKINS ST     Berkeley 94702 37.87596931396801 -122.29211314019582
9373 9373 9373 060 243701600 1741 Hopkins St 1741 HOPKINS ST 1741 HOPKINS ST 1741.0 HOPKINS ST     Berkeley 94707 37.8840415287765 -122.27793854517428
9558 9558 9558 059 229300106 1290 Hopkins St 4 1290 HOPKINS ST 4 1290 HOPKINS ST 1290.0 HOPKINS ST 4   Berkeley 94702 37.8775084403227 -122.28851462481325
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
9857 9857 9857 060 243003100 1466 Hopkins St 3 1466 HOPKINS ST 3 1466 HOPKINS ST 1466.0 HOPKINS ST 3   Berkeley 94702 37.880414842979775 -122.28372307037657
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
10437 10437 10437 059 229300104 1260 Hopkins St 45 1260 HOPKINS ST 45 1260 HOPKINS ST 1260.0 HOPKINS ST 45   Berkeley 94702 37.87735660853645 -122.28900466747884
10730 10730 10730 060 239503600 1111 Hopkins St 1111 HOPKINS ST 1111 HOPKINS ST 1111.0 HOPKINS ST     Berkeley 94702 37.87572313951532 -122.2935811472702
10926 10926 10926 061 256801900 1924 Hopkins St 1924 HOPKINS ST 1924 HOPKINS ST 1924.0 HOPKINS ST     Berkeley 94707 37.885947088288134 -122.2738366022284
10975 10975 10975 060 239402200 1133 Hopkins St 1133 HOPKINS ST 1133 HOPKINS ST 1133.0 HOPKINS ST     Berkeley 94702 37.87615751428739 -122.29273861826356
11010 11010 11010 060 242302600 1346 Hopkins St 1346 HOPKINS ST 1346 HOPKINS ST 1346.0 HOPKINS ST     Berkeley 94702 37.87885985777048 -122.28675235031308
11059 11059 11059 059 229301500 1224 Hopkins St 1224 HOPKINS ST 1224 HOPKINS ST 1224.0 HOPKINS ST     Berkeley 94702 37.87677085384568 -122.29074131843386
11065 11065 11065 060 242307800 1300 Hopkins St A 1300 HOPKINS ST A 1300 HOPKINS ST 1300.0 HOPKINS ST A   Berkeley 94702 37.87795949793365 -122.28813604780308
11148 11148 11148 059 229300104 1260 Hopkins St 46 1260 HOPKINS ST 46 1260 HOPKINS ST 1260.0 HOPKINS ST 46   Berkeley 94702 37.87735660853645 -122.28900466747884
11623 11623 11623 059 229301300 1232 Hopkins St 1232 HOPKINS ST 1232 HOPKINS ST 1232.0 HOPKINS ST     Berkeley 94702 37.87688221036213 -122.29040616328956
11755 11755 11755 061 256900500 1937 Hopkins St 1937 HOPKINS ST 1937 HOPKINS ST 1937.0 HOPKINS ST     Berkeley 94707 37.88678155846876 -122.27404552610896
11894 11894 11894 060 242302600 1346 Hopkins St A 1346 HOPKINS ST A 1346 HOPKINS ST 1346.0 HOPKINS ST A   Berkeley 94702 37.87885985777048 -122.28675235031308
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
11963 11963 11963 060 242308400 1338 Hopkins St 1338 HOPKINS ST 1338 HOPKINS ST 1338.0 HOPKINS ST     Berkeley 94702 37.87846510668139 -122.28746312251867
12102 12102 12102 061 256902801 1953 Hopkins St 1953 HOPKINS ST 1953 HOPKINS ST 1953.0 HOPKINS ST     Berkeley 94707 37.88735357882102 -122.27375044031793
12346 12346 12346 060 239102400 1127 Hopkins St 3 1127 HOPKINS ST 3 1127 HOPKINS ST 1127.0 HOPKINS ST 3   Berkeley 94702 37.878104725737565 -122.29063812266898
12350 12350 12350 060 243502801 1601 Hopkins St 1601 HOPKINS ST 1601 HOPKINS ST 1601.0 HOPKINS ST     Berkeley 94707 37.88220885592382 -122.2816081451436
12497 12497 12497 060 243002300 1418 Hopkins St 1418 HOPKINS ST 1418 HOPKINS ST 1418.0 HOPKINS ST     Berkeley 94702 37.87979486027203 -122.28487353108284
12512 12512 12512 059 229300106 1290 Hopkins St 28 1290 HOPKINS ST 28 1290 HOPKINS ST 1290.0 HOPKINS ST 28   Berkeley 94702 37.8775084403227 -122.28851462481325
12519 12519 12519 060 244505301 1640 Hopkins St 1640 HOPKINS ST 1640 HOPKINS ST 1640.0 HOPKINS ST     Berkeley 94707 37.88244583333378 -122.27981002606695
12716 12716 12716 060 242300900 1355 Hopkins St 1355 HOPKINS ST 1355 HOPKINS ST 1355.0 HOPKINS ST     Berkeley 94702 37.879631775024194 -122.28620567785195

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