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

92 rows where street_name = "GILMAN" and zipcode = 94706

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94706 · 92 ✖

street_type 1

street_name 1

  • GILMAN · 92 ✖
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
781 781 781 060 239100204 1310 Gilman St 1310 GILMAN ST 1310 GILMAN ST 1310.0 GILMAN ST     Berkeley 94706 37.88103732263173 -122.28959436834374
1423 1423 1423 060 242300100 1380 Gilman St 1380 GILMAN ST 1380 GILMAN ST 1380.0 GILMAN ST     Berkeley 94706 37.880439367074125 -122.2864692893704
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
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
4391 4391 4391 060 240100200 1208 Gilman St 1208 GILMAN ST 1208 GILMAN ST 1208.0 GILMAN ST     Berkeley 94706 37.88092703806903 -122.29282547097849
4978 4978 4978 060 240100300 1216 Gilman St 1216 GILMAN ST 1216 GILMAN ST 1216.0 GILMAN ST     Berkeley 94706 37.88096031070989 -122.29265736834104
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
6581 6581 6581 060 242300200 1386 Gilman St 1386 GILMAN ST 1386 GILMAN ST 1386.0 GILMAN ST     Berkeley 94706 37.88034440600316 -122.28619930610164
7431 7431 7431 060 241101106 1285 Gilman St 1285 GILMAN ST 1285 GILMAN ST 1285.0 GILMAN ST     Berkeley 94706 37.88172990659099 -122.2903126010578
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
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
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
10397 10397 10397 060 240904600 1251 Gilman St 1251 GILMAN ST 1251 GILMAN ST 1251.0 GILMAN ST     Berkeley 94706 37.88152439550504 -122.29141297889034
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
11192 11192 11192 060 240601907 1125 Gilman St 1125 GILMAN ST 1125 GILMAN ST 1125.0 GILMAN ST     Berkeley 94706 37.8808678418439 -122.29468153767915
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
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
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
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
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
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
14473 14473 14473 060 241101204 1277 Gilman St 1277 GILMAN ST 1277 GILMAN ST 1277.0 GILMAN ST     Berkeley 94706 37.88176927149408 -122.2904710575857
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
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
15584 15584 15584 060 242801600 1407 Gilman St 1407 GILMAN ST 1407 GILMAN ST 1407.0 GILMAN ST     Berkeley 94706 37.88043689821544 -122.28510098720773
16047 16047 16047 060 240901601 1231 Gilman St 1231 GILMAN ST 1231 GILMAN ST 1231.0 GILMAN ST     Berkeley 94706 37.88138553014894 -122.29211402862964
16190 16190 16190 060 241502100 1335 Gilman St 1335 GILMAN ST 1335 GILMAN ST 1335.0 GILMAN ST     Berkeley 94706 37.88129383181949 -122.28838379597192
16320 16320 16320 060 240904400 1265 Gilman St M 1265 GILMAN ST M 1265 GILMAN ST 1265.0 GILMAN ST M   Berkeley 94706 37.88163126239069 -122.29104321704804
16848 16848 16848 060 240801700 1221 Gilman St 1221 GILMAN ST 1221 GILMAN ST 1221.0 GILMAN ST     Berkeley 94706 37.88127830201228 -122.29267628326768
16928 16928 16928 060 240000200 1236 Gilman St B 1236 GILMAN ST B 1236 GILMAN ST 1236.0 GILMAN ST B   Berkeley 94706 37.88099937823207 -122.2919278168544
17082 17082 17082 060 242701600 1397 Gilman St 1397 GILMAN ST 1397 GILMAN ST 1397.0 GILMAN ST     Berkeley 94706 37.880586799336015 -122.28577620409445
18262 18262 18262 060 241702400 1346 Gilman St 1346 GILMAN ST 1346 GILMAN ST 1346.0 GILMAN ST     Berkeley 94706 37.880778586901066 -122.28803945106225
20374 20374 20374 060 240901602 1227 Gilman St 1227 GILMAN ST 1227 GILMAN ST 1227.0 GILMAN ST     Berkeley 94706 37.88135383599175 -122.29228219055588
20944 20944 20944 060 241201602 1301 Gilman St Apt 106 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 106 APT Berkeley 94706 37.88155016427598 -122.28964221351409
21609 21609 21609 060 241201602 1301 Gilman St Apt 103 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 103 APT Berkeley 94706 37.88149799285727 -122.28966276606948
22860 22860 22860 060 240002500 1252 Gilman St 1252 GILMAN ST 1252 GILMAN ST 1252.0 GILMAN ST     Berkeley 94706 37.88118086184478 -122.29134406553165
23377 23377 23377 060 241201602 1301 Gilman St Apt 114 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 114 APT Berkeley 94706 37.88168263251939 -122.2895899809719
23469 23469 23469 060 241201602 1301 Gilman St Apt 105 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 105 APT Berkeley 94706 37.88153361423708 -122.28964873438474
26448 26448 26448 060 241400100 1320 Gilman St 1320 GILMAN ST 1320 GILMAN ST 1320.0 GILMAN ST     Berkeley 94706 37.88101511867977 -122.28905024709806
28289 28289 28289 060 241201602 1301 Gilman St Apt 102 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 102 APT Berkeley 94706 37.88148036367118 -122.2896697100466
28403 28403 28403 060 241201602 1301 Gilman St Apt 207 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 207 APT Berkeley 94706 37.88155586908246 -122.28958436650136
28791 28791 28791 060 241101106 1281 Gilman St 1281 GILMAN ST 1281 GILMAN ST 1281.0 GILMAN ST     Berkeley 94706 37.88172990659099 -122.2903126010578
29231 29231 29231 060 240000200 1236 Gilman St A 1236 GILMAN ST A 1236 GILMAN ST 1236.0 GILMAN ST A   Berkeley 94706 37.88099937823207 -122.2919278168544
30055 30055 30055 060 241201602 1301 Gilman St Apt 201 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 201 APT Berkeley 94706 37.88145152692513 -122.2896254698155
30147 30147 30147 060 241702100 1336 Gilman St 1336 GILMAN ST 1336 GILMAN ST 1336.0 GILMAN ST     Berkeley 94706 37.880892092810726 -122.28856636328204
31288 31288 31288 060 241502400 1321 Gilman St 1321 GILMAN ST 1321 GILMAN ST 1321.0 GILMAN ST     Berkeley 94706 37.881345033435394 -122.28888663064714
35339 35339 35339 060 241201602 1301 Gilman St Apt 206 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 206 APT Berkeley 94706 37.8815380591091 -122.28959138234372
35519 35519 35519 060 241201602 1301 Gilman St Apt 203 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 203 APT Berkeley 94706 37.881485887681805 -122.28961193489911
35728 35728 35728 060 240904400 1265 Gilman St C 1265 GILMAN ST C 1265 GILMAN ST 1265.0 GILMAN ST C   Berkeley 94706 37.88163126239069 -122.29104321704804
36218 36218 36218 060 241201602 1301 Gilman St Apt 109 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 109 APT Berkeley 94706 37.88160287522457 -122.2896214498546
36567 36567 36567 060 239200100 1270 Gilman St 1270 GILMAN ST 1270 GILMAN ST 1270.0 GILMAN ST     Berkeley 94706 37.881320126768514 -122.29066851447166
37211 37211 37211 060 240904400 1265 Gilman St D 1265 GILMAN ST D 1265 GILMAN ST 1265.0 GILMAN ST D   Berkeley 94706 37.88163126239069 -122.29104321704804
38283 38283 38283 060 240904400 1265 Gilman St 1265 GILMAN ST 1265 GILMAN ST 1265.0 GILMAN ST     Berkeley 94706 37.88163126239069 -122.29104321704804
39225 39225 39225 060 241201602 1301 Gilman St Apt 202 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 202 APT Berkeley 94706 37.88146825849282 -122.28961887887624
39487 39487 39487 060 239100300 1312 Gilman St 1312 GILMAN ST 1312 GILMAN ST 1312.0 GILMAN ST     Berkeley 94706 37.88112345611952 -122.28939337389218
42976 42976 42976 060 242701900 1381 Gilman St 1381 GILMAN ST 1381 GILMAN ST 1381.0 GILMAN ST     Berkeley 94706 37.88077886484137 -122.2863552419569
43103 43103 43103 060 240100400 1222 Gilman St 1222 GILMAN ST 1222 GILMAN ST 1222.0 GILMAN ST     Berkeley 94706 37.88099300193172 -122.29249352192144
43136 43136 43136 060 241201500 1313 Gilman St B 1313 GILMAN ST B 1313 GILMAN ST 1313.0 GILMAN ST B   Berkeley 94706 37.8815094875608 -122.28935069044144
43480 43480 43480 060 239100204 1302 Gilman St 1302 GILMAN ST 1302 GILMAN ST 1302.0 GILMAN ST     Berkeley 94706 37.88103732263173 -122.28959436834374
44721 44721 44721 060 242801500 1411 Gilman St 1411 GILMAN ST 1411 GILMAN ST 1411.0 GILMAN ST     Berkeley 94706 37.880431727934486 -122.28496535507456
45163 45163 45163 060 241201602 1301 Gilman St Apt 112 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 112 APT Berkeley 94706 37.881651448277545 -122.28960231484076
45512 45512 45512 060 242300300 1390 Gilman St 1390 GILMAN ST 1390 GILMAN ST 1390.0 GILMAN ST     Berkeley 94706 37.88030986816402 -122.28604769114294
45578 45578 45578 060 240601800 1139 Gilman St 1139 GILMAN ST 1139 GILMAN ST 1139.0 GILMAN ST     Berkeley 94706 37.88093274505085 -122.2943469835078
46950 46950 46950 060 240904400 1265 Gilman St B 1265 GILMAN ST B 1265 GILMAN ST 1265.0 GILMAN ST B   Berkeley 94706 37.88163126239069 -122.29104321704804
47710 47710 47710 060 240904500 1263 Gilman St 1263 GILMAN ST 1263 GILMAN ST 1263.0 GILMAN ST     Berkeley 94706 37.88155638383381 -122.29124570360128
47950 47950 47950 060 241502300 1329 Gilman St 1329 GILMAN ST 1329 GILMAN ST 1329.0 GILMAN ST     Berkeley 94706 37.88135259306943 -122.2886260689091
48552 48552 48552 060 240904400 1265 Gilman St A 1265 GILMAN ST A 1265 GILMAN ST 1265.0 GILMAN ST A   Berkeley 94706 37.88163126239069 -122.29104321704804
49517 49517 49517 060 241702000 1330 Gilman St 1330 GILMAN ST 1330 GILMAN ST 1330.0 GILMAN ST     Berkeley 94706 37.88092620637693 -122.28869975861016
49791 49791 49791 060 241201602 1301 Gilman St Apt 111 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 111 APT Berkeley 94706 37.88163579730273 -122.28960848087684
50206 50206 50206 060 240702000 1100 Gilman St 1100 GILMAN ST 1100 GILMAN ST 1100.0 GILMAN ST     Berkeley 94706 37.88112539814735 -122.29391088557335
50427 50427 50427 060 241201602 1301 Gilman St Apt 212 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 212 APT Berkeley 94706 37.88163934312731 -122.28955148367037
50610 50610 50610 060 241702200 1338 Gilman St 1338 GILMAN ST 1338 GILMAN ST 1338.0 GILMAN ST     Berkeley 94706 37.88084833428467 -122.28831758115231
51875 51875 51875 060 242701700 1389 Gilman St 1389 GILMAN ST 1389 GILMAN ST 1389.0 GILMAN ST     Berkeley 94706 37.880647410307176 -122.28603313394376
52221 52221 52221 060 239100204 1304 Gilman St 1304 GILMAN ST 1304 GILMAN ST 1304.0 GILMAN ST     Berkeley 94706 37.88103732263173 -122.28959436834374
52883 52883 52883 060 240901601 1235 Gilman St 1235 GILMAN ST 1235 GILMAN ST 1235.0 GILMAN ST     Berkeley 94706 37.88138553014894 -122.29211402862964
54126 54126 54126 060 241201602 1301 Gilman St Apt 210 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 210 APT Berkeley 94706 37.88160821984312 -122.28956374477568
55027 55027 55027 060 239100204 1308 Gilman St 1308 GILMAN ST 1308 GILMAN ST 1308.0 GILMAN ST     Berkeley 94706 37.88103732263173 -122.28959436834374
55529 55529 55529 060 241201500 1313 Gilman St A 1313 GILMAN ST A 1313 GILMAN ST 1313.0 GILMAN ST A   Berkeley 94706 37.8815094875608 -122.28935069044144
55581 55581 55581 060 241201602 1301 Gilman St Apt 213 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 213 APT Berkeley 94706 37.88165409506021 -122.28954567246883
55595 55595 55595 060 241201602 1301 Gilman St Apt 101 1301 GILMAN ST 1301 GILMAN ST 1301.0 GILMAN ST 101 APT Berkeley 94706 37.88146363281528 -122.28967630188416

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