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

271 rows where street_name = "HOPKINS" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94702 · 271 ✖

street_type 1

street_name 1

  • HOPKINS · 271 ✖
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
1136 1136 1136 060 242307800 1300 Hopkins St 1300 HOPKINS ST 1300 HOPKINS ST 1300.0 HOPKINS ST     Berkeley 94702 37.87795949793365 -122.28813604780308
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
1686 1686 1686 060 242801900 1405 Hopkins St 1405 HOPKINS ST 1405 HOPKINS ST 1405.0 HOPKINS ST     Berkeley 94702 37.88007517549253 -122.28537831600056
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
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
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
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
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
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
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
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
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
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
9103 9103 9103 060 242904500 1497 Hopkins St 1497 HOPKINS ST 1497 HOPKINS ST 1497.0 HOPKINS ST     Berkeley 94702 37.88121297582058 -122.2834745981656
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
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
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
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
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
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
11963 11963 11963 060 242308400 1338 Hopkins St 1338 HOPKINS ST 1338 HOPKINS ST 1338.0 HOPKINS ST     Berkeley 94702 37.87846510668139 -122.28746312251867
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
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
12716 12716 12716 060 242300900 1355 Hopkins St 1355 HOPKINS ST 1355 HOPKINS ST 1355.0 HOPKINS ST     Berkeley 94702 37.879631775024194 -122.28620567785195
12818 12818 12818 060 242904500 1497 Hopkins St 5 1497 HOPKINS ST 5 1497 HOPKINS ST 1497.0 HOPKINS ST 5   Berkeley 94702 37.88121297582058 -122.2834745981656
13118 13118 13118 060 242904500 1497 Hopkins St 2B 1497 HOPKINS ST 2B 1497 HOPKINS ST 1497.0 HOPKINS ST 2B   Berkeley 94702 37.88121297582058 -122.2834745981656
13143 13143 13143 060 241402700 1237 Hopkins St 1237 HOPKINS ST 1237 HOPKINS ST 1237.0 HOPKINS ST     Berkeley 94702 37.877383413290026 -122.29032414710414
13359 13359 13359 059 228900400 1164 Hopkins St 1164 HOPKINS ST 1164 HOPKINS ST 1164.0 HOPKINS ST     Berkeley 94702 37.8761560982629 -122.29181639701308
13667 13667 13667 060 242905100 1463 Hopkins St 1463 HOPKINS ST 1463 HOPKINS ST 1463.0 HOPKINS ST     Berkeley 94702 37.88074283965744 -122.28409524689036
13737 13737 13737 059 229300106 1290 Hopkins St 12 1290 HOPKINS ST 12 1290 HOPKINS ST 1290.0 HOPKINS ST 12   Berkeley 94702 37.8775084403227 -122.28851462481325
13808 13808 13808 060 242904500 1497 Hopkins St 4 1497 HOPKINS ST 4 1497 HOPKINS ST 1497.0 HOPKINS ST 4   Berkeley 94702 37.88121297582058 -122.2834745981656
13914 13914 13914 059 229301800 1252 Hopkins St 5 1252 HOPKINS ST 5 1252 HOPKINS ST 1252.0 HOPKINS ST 5   Berkeley 94702 37.87729146960488 -122.2896192813215
13968 13968 13968 060 241605100 1333 Hopkins St 1 1333 HOPKINS ST 1 1333 HOPKINS ST 1333.0 HOPKINS ST 1   Berkeley 94702 37.878861383645734 -122.28766659542212
14271 14271 14271 060 241605200 1329 Hopkins St A 1329 HOPKINS ST A 1329 HOPKINS ST 1329.0 HOPKINS ST A   Berkeley 94702 37.878827875361054 -122.28786815132074
14520 14520 14520 059 229301400 1228 Hopkins St A 1228 HOPKINS ST A 1228 HOPKINS ST 1228.0 HOPKINS ST A   Berkeley 94702 37.87684732771002 -122.2905162078102
14621 14621 14621 060 239402400 1127 Hopkins St 2 1127 HOPKINS ST 2 1127 HOPKINS ST 1127.0 HOPKINS ST 2   Berkeley 94702 37.8759918739798 -122.29304739527784
15042 15042 15042 059 229300104 1260 Hopkins St 14 1260 HOPKINS ST 14 1260 HOPKINS ST 1260.0 HOPKINS ST 14   Berkeley 94702 37.87735660853645 -122.28900466747884
15217 15217 15217 060 241605500 1311 Hopkins St B 1311 HOPKINS ST B 1311 HOPKINS ST 1311.0 HOPKINS ST B   Berkeley 94702 37.87870730837377 -122.28825438377376
15272 15272 15272 059 229300106 1290 Hopkins St 26 1290 HOPKINS ST 26 1290 HOPKINS ST 1290.0 HOPKINS ST 26   Berkeley 94702 37.8775084403227 -122.28851462481325
15541 15541 15541 060 243003000 1458 Hopkins St 3 1458 HOPKINS ST 3 1458 HOPKINS ST 1458.0 HOPKINS ST 3   Berkeley 94702 37.88033780700891 -122.2838633315284
15898 15898 15898 059 229300104 1260 Hopkins St 26 1260 HOPKINS ST 26 1260 HOPKINS ST 1260.0 HOPKINS ST 26   Berkeley 94702 37.87735660853645 -122.28900466747884
15927 15927 15927 060 241605200 1323 Hopkins St 1323 HOPKINS ST 1323 HOPKINS ST 1323.0 HOPKINS ST     Berkeley 94702 37.878827875361054 -122.28786815132074
16075 16075 16075 060 241605200 1327 Hopkins St 1327 HOPKINS ST 1327 HOPKINS ST 1327.0 HOPKINS ST     Berkeley 94702 37.878827875361054 -122.28786815132074
16239 16239 16239 060 241605500 1311 Hopkins St 1 1311 HOPKINS ST 1 1311 HOPKINS ST 1311.0 HOPKINS ST 1   Berkeley 94702 37.87870730837377 -122.28825438377376
16328 16328 16328 060 242904700 1485 Hopkins St B 1485 HOPKINS ST B 1485 HOPKINS ST 1485.0 HOPKINS ST B   Berkeley 94702 37.88102436300061 -122.28370749628448
16508 16508 16508 059 229300104 1260 Hopkins St 15 1260 HOPKINS ST 15 1260 HOPKINS ST 1260.0 HOPKINS ST 15   Berkeley 94702 37.87735660853645 -122.28900466747884
17351 17351 17351 059 229300104 1260 Hopkins St 27 1260 HOPKINS ST 27 1260 HOPKINS ST 1260.0 HOPKINS ST 27   Berkeley 94702 37.87735660853645 -122.28900466747884
17363 17363 17363 060 242307800 1300 Hopkins St C 1300 HOPKINS ST C 1300 HOPKINS ST 1300.0 HOPKINS ST C   Berkeley 94702 37.87795949793365 -122.28813604780308
17873 17873 17873 060 239204200 1209 Hopkins St 1209 HOPKINS ST 1209 HOPKINS ST 1209.0 HOPKINS ST     Berkeley 94702 37.876803556144914 -122.29144506401737
18062 18062 18062 060 242904900 1475 Hopkins St 1475 HOPKINS ST 1475 HOPKINS ST 1475.0 HOPKINS ST     Berkeley 94702 37.88092425725352 -122.28394068186428
18087 18087 18087 060 242300900 1357 Hopkins St 2 1357 HOPKINS ST 2 1357 HOPKINS ST 1357.0 HOPKINS ST 2   Berkeley 94702 37.879631775024194 -122.28620567785195
18149 18149 18149 060 242302300 1340 Hopkins St 1340 HOPKINS ST 1340 HOPKINS ST 1340.0 HOPKINS ST     Berkeley 94702 37.8786534715057 -122.28720739281852
18203 18203 18203 059 229300104 1260 Hopkins St 21 1260 HOPKINS ST 21 1260 HOPKINS ST 1260.0 HOPKINS ST 21   Berkeley 94702 37.87735660853645 -122.28900466747884
18291 18291 18291 060 243002703 1430 Hopkins St 1430 HOPKINS ST 1430 HOPKINS ST 1430.0 HOPKINS ST     Berkeley 94702 37.88003233184988 -122.28443556375429
18391 18391 18391 060 242307800 1300 Hopkins St D 1300 HOPKINS ST D 1300 HOPKINS ST 1300.0 HOPKINS ST D   Berkeley 94702 37.87795949793365 -122.28813604780308
18401 18401 18401 059 229300104 1260 Hopkins St 17 1260 HOPKINS ST 17 1260 HOPKINS ST 1260.0 HOPKINS ST 17   Berkeley 94702 37.87735660853645 -122.28900466747884
18623 18623 18623 060 242309900 1316 Hopkins St B 1316 HOPKINS ST B 1316 HOPKINS ST 1316.0 HOPKINS ST B   Berkeley 94702 37.87807606138895 -122.28786199157284
18632 18632 18632 060 242302400 1342 Hopkins St 1342 HOPKINS ST 1342 HOPKINS ST 1342.0 HOPKINS ST     Berkeley 94702 37.878731736605666 -122.28703423266607
19187 19187 19187 060 239503600 1109 Hopkins St 1109 HOPKINS ST 1109 HOPKINS ST 1109.0 HOPKINS ST     Berkeley 94702 37.87572313951532 -122.2935811472702
19418 19418 19418 059 229300106 1290 Hopkins St 25 1290 HOPKINS ST 25 1290 HOPKINS ST 1290.0 HOPKINS ST 25   Berkeley 94702 37.8775084403227 -122.28851462481325
19772 19772 19772 060 243002900 1456 Hopkins St 1456 HOPKINS ST 1456 HOPKINS ST 1456.0 HOPKINS ST     Berkeley 94702 37.88025879416407 -122.28400271233124
19874 19874 19874 059 229300104 1260 Hopkins St 1 1260 HOPKINS ST 1 1260 HOPKINS ST 1260.0 HOPKINS ST 1   Berkeley 94702 37.87735660853645 -122.28900466747884
19985 19985 19985 059 229301700 1248 Hopkins St 1248 HOPKINS ST 1248 HOPKINS ST 1248.0 HOPKINS ST     Berkeley 94702 37.8772248947579 -122.2897744679818
20026 20026 20026 060 242300900 1355 Hopkins St A 1355 HOPKINS ST A 1355 HOPKINS ST 1355.0 HOPKINS ST A   Berkeley 94702 37.879631775024194 -122.28620567785195
20280 20280 20280 059 229300106 1290 Hopkins St 37 1290 HOPKINS ST 37 1290 HOPKINS ST 1290.0 HOPKINS ST 37   Berkeley 94702 37.8775084403227 -122.28851462481325

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