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

288 rows where street_type = "ST" and zipcode = 94706

✎ View and edit SQL

This data as json, CSV (advanced)

street_name 8

zipcode 1

  • 94706 · 288 ✖

street_type 1

  • ST · 288 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
144 144 144 060 241201602 1301 Gilman St Apt 204 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 204 APT Berkeley 94706 37.88150405785215 -122.28960477712292
162 162 162 060 240500100 1100 Harrison St Apt 204 1100 HARRISON ST 1100 HARRISON ST 1100.0 HARRISON ST 204 APT Berkeley 94706 37.88218885737043 -122.29602383541098
781 781 781 060 239100204 1310 Gilman St 1310 GILMAN ST 1310 GILMAN ST 1310.0 GILMAN ST     Berkeley 94706 37.88103732263173 -122.28959436834374
1060 1060 1060 060 241500500 1349 Watkins St 1349 WATKINS ST 1349 WATKINS ST 1349.0 WATKINS ST     Berkeley 94706 37.881963233380326 -122.28810945767069
1218 1218 1218 060 242702800 1217 Ordway St 1217 ORDWAY ST 1217 ORDWAY ST 1217.0 ORDWAY ST     Berkeley 94706 37.88163957852294 -122.28602326864532
1423 1423 1423 060 242300100 1380 Gilman St 1380 GILMAN ST 1380 GILMAN ST 1380.0 GILMAN ST     Berkeley 94706 37.880439367074125 -122.2864692893704
1839 1839 1839 060 241600101 1206 Ordway St 1206 ORDWAY ST 1206 ORDWAY ST 1206.0 ORDWAY ST     Berkeley 94706 37.88233575294989 -122.28643702368204
1861 1861 1861 060 241201602 1301 Gilman St Apt 214 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 214 APT Berkeley 94706 37.881670526665246 -122.28953914980154
2541 2541 2541 060 241601700 1244 Ordway St 1244 ORDWAY ST 1244 ORDWAY ST 1244.0 ORDWAY ST     Berkeley 94706 37.88085185816721 -122.28699119348248
2575 2575 2575 060 241500207 1202 Tevlin St 1202 TEVLIN ST 1202 TEVLIN ST 1202.0 TEVLIN ST     Berkeley 94706 37.88246165784515 -122.28808755674405
2584 2584 2584 060 241600700 1218 Ordway St 1218 ORDWAY ST 1218 ORDWAY ST 1218.0 ORDWAY ST     Berkeley 94706 37.88174877508788 -122.2866558505903
2862 2862 2862 060 241200600 1212 Neilson St 2 1212 NEILSON ST 2 1212 NEILSON ST 1212.0 NEILSON ST 2   Berkeley 94706 37.88247350477875 -122.28898402778688
3099 3099 3099 060 241202302 1211 Curtis St 1211 CURTIS ST 1211 CURTIS ST 1211.0 CURTIS ST     Berkeley 94706 37.88256843474398 -122.2893138065142
3188 3188 3188 060 241201602 1301 Gilman St Apt 208 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 208 APT Berkeley 94706 37.88157385914353 -122.2895772805904
3385 3385 3385 060 239100300 1316 Gilman St 1316 GILMAN ST 1316 GILMAN ST 1316.0 GILMAN ST     Berkeley 94706 37.88112345611952 -122.28939337389218
3532 3532 3532 060 240601907 1121 Gilman St 1121 GILMAN ST 1121 GILMAN ST 1121.0 GILMAN ST     Berkeley 94706 37.8808678418439 -122.29468153767915
3582 3582 3582 060 242802300 1395 Acton St 1395 ACTON ST 1395 ACTON ST 1395.0 ACTON ST     Berkeley 94706 37.880616132743704 -122.28516443701288
3752 3752 3752 060 242701100 1356 Acton St 1356 ACTON ST 1356 ACTON ST 1356.0 ACTON ST     Berkeley 94706 37.88121154074953 -122.28567342874103
3766 3766 3766 060 241600500 1214 Ordway St 1214 ORDWAY ST 1214 ORDWAY ST 1214.0 ORDWAY ST     Berkeley 94706 37.88196488468778 -122.28657699647464
3835 3835 3835 060 241201400 1236 Neilson St 1236 NEILSON ST 1236 NEILSON ST 1236.0 NEILSON ST     Berkeley 94706 37.881687710539616 -122.2892803631345
4276 4276 4276 060 241202000 1227 Curtis St 1227 CURTIS ST 1227 CURTIS ST 1227.0 CURTIS ST     Berkeley 94706 37.88212691825835 -122.28947992387484
4322 4322 4322 060 242700900 1352 Acton St A 1352 ACTON ST A 1352 ACTON ST 1352.0 ACTON ST A   Berkeley 94706 37.881480526746856 -122.28571346485666
4391 4391 4391 060 240100200 1208 Gilman St 1208 GILMAN ST 1208 GILMAN ST 1208.0 GILMAN ST     Berkeley 94706 37.88092703806903 -122.29282547097849
4530 4530 4530 060 242803003 1347 Acton St 1347 ACTON ST 1347 ACTON ST 1347.0 ACTON ST     Berkeley 94706 37.8813828273436 -122.28491852230552
4537 4537 4537 060 241200800 1220 Neilson St 1220 NEILSON ST 1220 NEILSON ST 1220.0 NEILSON ST     Berkeley 94706 37.88225213363689 -122.28906880359686
4645 4645 4645 060 241501100 1219 Neilson St 1219 NEILSON ST 1219 NEILSON ST 1219.0 NEILSON ST     Berkeley 94706 37.88217850783685 -122.28861131408055
4831 4831 4831 060 241502000 1350 Watkins St 1350 WATKINS ST 1350 WATKINS ST 1350.0 WATKINS ST     Berkeley 94706 37.88156932351867 -122.28826210659024
4919 4919 4919 060 241201100 1230 Neilson St 1230 NEILSON ST 1230 NEILSON ST 1230.0 NEILSON ST     Berkeley 94706 37.881981371527 -122.28917057463374
4978 4978 4978 060 240100300 1216 Gilman St 1216 GILMAN ST 1216 GILMAN ST 1216.0 GILMAN ST     Berkeley 94706 37.88096031070989 -122.29265736834104
5050 5050 5050 060 241500100 1203 Neilson St 1203 NEILSON ST 1203 NEILSON ST 1203.0 NEILSON ST     Berkeley 94706 37.88279920714281 -122.28833513243632
5086 5086 5086 060 241702300 1342 Gilman St 1342 GILMAN ST 1342 GILMAN ST 1342.0 GILMAN ST     Berkeley 94706 37.88081286643311 -122.2881754928272
5840 5840 5840 060 241201602 1301 Gilman St Apt 110 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 110 APT Berkeley 94706 37.88162032570751 -122.28961457594606
6180 6180 6180 060 241200405 1202 Neilson St 1202 NEILSON ST 1202 NEILSON ST 1202.0 NEILSON ST     Berkeley 94706 37.882851960447134 -122.28884327256164
6212 6212 6212 060 240500100 1100 Harrison St Apt 401 1100 HARRISON ST 1100 HARRISON ST 1100.0 HARRISON ST 401 APT Berkeley 94706 37.882211633145744 -122.29611101780765
6581 6581 6581 060 242300200 1386 Gilman St 1386 GILMAN ST 1386 GILMAN ST 1386.0 GILMAN ST     Berkeley 94706 37.88034440600316 -122.28619930610164
6647 6647 6647 060 242700200 1304 Acton St 1304 ACTON ST 1304 ACTON ST 1304.0 ACTON ST     Berkeley 94706 37.88233774954005 -122.28523732002682
6797 6797 6797 060 240500100 1100 Harrison St Apt 305 1100 HARRISON ST 1100 HARRISON ST 1100.0 HARRISON ST 305 APT Berkeley 94706 37.88221151190374 -122.29601103082491
6831 6831 6831 060 241501401 1211 Neilson St 1211 NEILSON ST 1211 NEILSON ST 1211.0 NEILSON ST     Berkeley 94706 37.882411005783666 -122.28847994625002
7431 7431 7431 060 241101106 1285 Gilman St 1285 GILMAN ST 1285 GILMAN ST 1285.0 GILMAN ST     Berkeley 94706 37.88172990659099 -122.2903126010578
7534 7534 7534 060 241200700 1216 Neilson St 1216 NEILSON ST 1216 NEILSON ST 1216.0 NEILSON ST     Berkeley 94706 37.882344723424694 -122.28903630165156
7780 7780 7780 060 241202200 1219 Curtis St B 1219 CURTIS ST B 1219 CURTIS ST 1219.0 CURTIS ST B   Berkeley 94706 37.88232402794502 -122.28940408720024
8178 8178 8178 060 240000200 1236 Gilman St 1236 GILMAN ST 1236 GILMAN ST 1236.0 GILMAN ST     Berkeley 94706 37.88099937823207 -122.2919278168544
8879 8879 8879 060 241101304 1275 Gilman St 1275 GILMAN ST 1275 GILMAN ST 1275.0 GILMAN ST     Berkeley 94706 37.881802058783755 -122.2906035069878
8941 8941 8941 060 242704100 1310 Acton St D 1310 ACTON ST D 1310 ACTON ST 1310.0 ACTON ST D   Berkeley 94706 37.88200769813643 -122.28533262499026
9085 9085 9085 060 241200600 1212 Neilson St 4 1212 NEILSON ST 4 1212 NEILSON ST 1212.0 NEILSON ST 4   Berkeley 94706 37.88247350477875 -122.28898402778688
9118 9118 9118 060 240300200 1136 Gilman St 1136 GILMAN ST 1136 GILMAN ST 1136.0 GILMAN ST     Berkeley 94706 37.880633538791294 -122.29424534362498
9174 9174 9174 060 241201602 1301 Gilman St Apt 211 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 211 APT Berkeley 94706 37.88162369144089 -122.28955764970648
9350 9350 9350 060 242802500 1375 Acton St 1375 ACTON ST 1375 ACTON ST 1375.0 ACTON ST     Berkeley 94706 37.88082894796455 -122.28507942853923
9402 9402 9402 060 241201602 1301 Gilman St Apt 113 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 113 APT Berkeley 94706 37.881666200208024 -122.28959650453749
9472 9472 9472 060 242703800 1310 Acton St A 1310 ACTON ST A 1310 ACTON ST 1310.0 ACTON ST A   Berkeley 94706 37.88196814688855 -122.28516759189615
9490 9490 9490 060 242703100 1209 Ordway St 1209 ORDWAY ST 1209 ORDWAY ST 1209.0 ORDWAY ST     Berkeley 94706 37.88202159420917 -122.28587229957527
9569 9569 9569 060 242704200 1310 Acton St 1310 ACTON ST 1310 ACTON ST 1310.0 ACTON ST     Berkeley 94706 37.882054417546456 -122.28545073728046
9687 9687 9687 060 241501800 1344 Watkins St 1344 WATKINS ST 1344 WATKINS ST 1344.0 WATKINS ST     Berkeley 94706 37.88162588657684 -122.28850882798474
10146 10146 10146 060 242702300 1235 Ordway St 1235 ORDWAY ST 1235 ORDWAY ST 1235.0 ORDWAY ST     Berkeley 94706 37.88112172963621 -122.28621361267088
10309 10309 10309 060 241600900 1222 Ordway St 1222 ORDWAY ST 1222 ORDWAY ST 1222.0 ORDWAY ST     Berkeley 94706 37.88157755102995 -122.28672453038703
10397 10397 10397 060 240904600 1251 Gilman St 1251 GILMAN ST 1251 GILMAN ST 1251.0 GILMAN ST     Berkeley 94706 37.88152439550504 -122.29141297889034
10402 10402 10402 060 241202301 1217 Curtis St 1217 CURTIS ST 1217 CURTIS ST 1217.0 CURTIS ST     Berkeley 94706 37.88243798666072 -122.2893626083903
10420 10420 10420 060 239100204 1310 Neilson St 2 1310 NEILSON ST 2 1310 NEILSON ST 1310.0 NEILSON ST 2   Berkeley 94706 37.88103732263173 -122.28959436834374
10554 10554 10554 060 241501200 1215 Neilson St 1215 NEILSON ST 1215 NEILSON ST 1215.0 NEILSON ST     Berkeley 94706 37.88227955770773 -122.28852710061594
10823 10823 10823 060 242701600 1399 Gilman St 1399 GILMAN ST 1399 GILMAN ST 1399.0 GILMAN ST     Berkeley 94706 37.880586799336015 -122.28577620409445
10997 10997 10997 060 240300200 1138 Gilman St 1138 GILMAN ST 1138 GILMAN ST 1138.0 GILMAN ST     Berkeley 94706 37.880633538791294 -122.29424534362498
11102 11102 11102 060 241000402 1115 Harrison St 1115 HARRISON ST 1115 HARRISON ST 1115.0 HARRISON ST     Berkeley 94706 37.8825363043429 -122.29577708437216
11192 11192 11192 060 240601907 1125 Gilman St 1125 GILMAN ST 1125 GILMAN ST 1125.0 GILMAN ST     Berkeley 94706 37.8808678418439 -122.29468153767915
11252 11252 11252 060 242702200 1237 Ordway St 1237 ORDWAY ST 1237 ORDWAY ST 1237.0 ORDWAY ST     Berkeley 94706 37.88103386469777 -122.28624614336228
11353 11353 11353 060 241601200 1228 Ordway St 1228 ORDWAY ST 1228 ORDWAY ST 1228.0 ORDWAY ST     Berkeley 94706 37.88131349170137 -122.28681944637997
11484 11484 11484 060 241202301 1217 Curtis St A 1217 CURTIS ST A 1217 CURTIS ST 1217.0 CURTIS ST A   Berkeley 94706 37.88243798666072 -122.2893626083903
11498 11498 11498 060 242700801 1350 Acton St 1350 ACTON ST 1350 ACTON ST 1350.0 ACTON ST     Berkeley 94706 37.88156060607095 -122.28554241574508
11839 11839 11839 060 242802400 1385 Acton St 1385 ACTON ST 1385 ACTON ST 1385.0 ACTON ST     Berkeley 94706 37.880709793099584 -122.28506614694774
11888 11888 11888 060 241600400 1212 Ordway St 1212 ORDWAY ST 1212 ORDWAY ST 1212.0 ORDWAY ST     Berkeley 94706 37.88205708274919 -122.28654199631455
12096 12096 12096 060 241201602 1301 Gilman St 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST     Berkeley 94706 37.88161076594607 -122.2897178040503
12099 12099 12099 060 241502200 1331 Gilman St 1331 GILMAN ST 1331 GILMAN ST 1331.0 GILMAN ST     Berkeley 94706 37.88132566071753 -122.28851278596188
12533 12533 12533 060 241500600 1347 Watkins St 1347 WATKINS ST 1347 WATKINS ST 1347.0 WATKINS ST     Berkeley 94706 37.881983273118095 -122.28820724557757
12599 12599 12599 060 241201602 1301 Gilman St Apt 104 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 104 APT Berkeley 94706 37.881516163024614 -122.28965560829327
12844 12844 12844 060 240500100 1100 Harrison St Apt 208 1100 HARRISON ST 1100 HARRISON ST 1100.0 HARRISON ST 208 APT Berkeley 94706 37.88220528885615 -122.29593994893314
12904 12904 12904 060 242701800 1385 Gilman St 1385 GILMAN ST 1385 GILMAN ST 1385.0 GILMAN ST     Berkeley 94706 37.8807431062534 -122.28620971577917
12931 12931 12931 060 240801800 1201 Gilman St 1201 GILMAN ST 1201 GILMAN ST 1201.0 GILMAN ST     Berkeley 94706 37.88121229090028 -122.2930100235654
13037 13037 13037 060 242803004 1335 Acton St 1335 ACTON ST 1335 ACTON ST 1335.0 ACTON ST     Berkeley 94706 37.88150408054094 -122.28486792559546
13069 13069 13069 060 241601000 1224 Ordway St 1224 ORDWAY ST 1224 ORDWAY ST 1224.0 ORDWAY ST     Berkeley 94706 37.88149754617185 -122.2867529755405
13119 13119 13119 060 242702000 1377 Gilman St 1377 GILMAN ST 1377 GILMAN ST 1377.0 GILMAN ST     Berkeley 94706 37.88080938012737 -122.28648333093662
13320 13320 13320 060 241201500 1311 Gilman St 1311 GILMAN ST 1311 GILMAN ST 1311.0 GILMAN ST     Berkeley 94706 37.8815094875608 -122.28935069044144
13443 13443 13443 060 241501000 1223 Neilson St 1223 NEILSON ST 1223 NEILSON ST 1223.0 NEILSON ST     Berkeley 94706 37.88208899285453 -122.28864723770874
13476 13476 13476 060 241201602 1301 Gilman St Apt 205 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 205 APT Berkeley 94706 37.881521508358496 -122.2895979032144
13785 13785 13785 060 241601600 1240 Ordway St 1240 ORDWAY ST 1240 ORDWAY ST 1240.0 ORDWAY ST     Berkeley 94706 37.88094528211638 -122.2869561834409
13938 13938 13938 060 241100202 1202 Curtis St B 1202 CURTIS ST B 1202 CURTIS ST 1202.0 CURTIS ST B   Berkeley 94706 37.88278252479936 -122.28974062125852
14022 14022 14022 060 241201602 1301 Gilman St Apt 107 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 107 APT Berkeley 94706 37.88156797424642 -122.28963519767171
14367 14367 14367 060 240701901 1145 Gilman St 1145 GILMAN ST 1145 GILMAN ST 1145.0 GILMAN ST     Berkeley 94706 37.88118088169757 -122.29356966320762
14461 14461 14461 060 241201900 1229 Curtis St 1229 CURTIS ST 1229 CURTIS ST 1229.0 CURTIS ST     Berkeley 94706 37.88202780309192 -122.28951906706506
14473 14473 14473 060 241101204 1277 Gilman St 1277 GILMAN ST 1277 GILMAN ST 1277.0 GILMAN ST     Berkeley 94706 37.88176927149408 -122.2904710575857
14580 14580 14580 060 242701000 1354 Acton St 1354 ACTON ST 1354 ACTON ST 1354.0 ACTON ST     Berkeley 94706 37.881328201867085 -122.28562947327588
14599 14599 14599 060 241201602 1301 Gilman St Apt 209 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 209 APT Berkeley 94706 37.88159077006636 -122.28957061868424
14752 14752 14752 060 241201000 1228 Neilson St 1228 NEILSON ST 1228 NEILSON ST 1228.0 NEILSON ST     Berkeley 94706 37.88207280524538 -122.28913547026907
14998 14998 14998 060 242700501 1312 Acton St 1312 ACTON ST 1312 ACTON ST 1312.0 ACTON ST     Berkeley 94706 37.88187810272101 -122.28533593348548
15128 15128 15128 060 241101106 1283 Gilman St 1283 GILMAN ST 1283 GILMAN ST 1283.0 GILMAN ST     Berkeley 94706 37.88172990659099 -122.2903126010578
15195 15195 15195 060 241201602 1301 Gilman St Apt 108 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 108 APT Berkeley 94706 37.88158596501356 -122.28962811176076
15364 15364 15364 060 242702400 1231 Ordway St 1231 ORDWAY ST 1231 ORDWAY ST 1231.0 ORDWAY ST     Berkeley 94706 37.88122978827148 -122.2861729297683
15584 15584 15584 060 242801600 1407 Gilman St 1407 GILMAN ST 1407 GILMAN ST 1407.0 GILMAN ST     Berkeley 94706 37.88043689821544 -122.28510098720773
15989 15989 15989 060 241500900 1225 Neilson St 1225 NEILSON ST 1225 NEILSON ST 1225.0 NEILSON ST     Berkeley 94706 37.88200442033904 -122.28867982319736
16019 16019 16019 060 241200100 1201 Curtis St 1201 CURTIS ST 1201 CURTIS ST 1201.0 CURTIS ST     Berkeley 94706 37.882990073614565 -122.2891402457131
16047 16047 16047 060 240901601 1231 Gilman St 1231 GILMAN ST 1231 GILMAN ST 1231.0 GILMAN ST     Berkeley 94706 37.88138553014894 -122.29211402862964
16138 16138 16138 060 242802700 1355 Acton St 1355 ACTON ST 1355 ACTON ST 1355.0 ACTON ST     Berkeley 94706 37.88103514165885 -122.28500124636342

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