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

170 rows where street_name = "GILMAN"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 3

street_type 1

street_name 1

  • GILMAN · 170 ✖
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
274 274 274 060 235500802 1025 Gilman St 1025 GILMAN ST 1025 GILMAN ST 1025.0 GILMAN ST     Berkeley 94710 37.88064798816878 -122.29766619021066
561 561 561 060 235401200 1031 Gilman St 1031 GILMAN ST 1031 GILMAN ST 1031.0 GILMAN ST     Berkeley 94710 37.88055137177347 -122.29685626286228
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
2214 2214 2214 060 235600804 933 Gilman St 933 GILMAN ST 933 GILMAN ST 933.0 GILMAN ST     Berkeley 94710 37.88033159302045 -122.29876889917136
2871 2871 2871 059 234900200 836 Gilman St 836 GILMAN ST 836 GILMAN ST 836.0 GILMAN ST     Berkeley 94710 37.87891098308302 -122.30053430160538
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
3239 3239 3239 060 235801500 833 Gilman St 833 GILMAN ST 833 GILMAN ST 833.0 GILMAN ST     Berkeley 94710 37.87969765779809 -122.3010340263131
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
3727 3727 3727 060 235100106 950 Gilman St 210 950 GILMAN ST 210 950 GILMAN ST 950.0 GILMAN ST 210   Berkeley 94710 37.87959657815016 -122.29855464019631
4391 4391 4391 060 240100200 1208 Gilman St 1208 GILMAN ST 1208 GILMAN ST 1208.0 GILMAN ST     Berkeley 94706 37.88092703806903 -122.29282547097849
4767 4767 4767 059 234500100 630 Gilman St 630 GILMAN ST 630 GILMAN ST 630.0 GILMAN ST     Berkeley 94710 37.878190931433416 -122.30514220087213
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
6306 6306 6306 060 235100106 950 Gilman St 950 GILMAN ST 950 GILMAN ST 950.0 GILMAN ST     Berkeley 94710 37.87959657815016 -122.29855464019631
6581 6581 6581 060 242300200 1386 Gilman St 1386 GILMAN ST 1386 GILMAN ST 1386.0 GILMAN ST     Berkeley 94706 37.88034440600316 -122.28619930610164
6956 6956 6956 059 234500100 640 Gilman St 640 GILMAN ST 640 GILMAN ST 640.0 GILMAN ST     Berkeley 94710 37.878190931433416 -122.30514220087213
7431 7431 7431 060 241101106 1285 Gilman St 1285 GILMAN ST 1285 GILMAN ST 1285.0 GILMAN ST     Berkeley 94706 37.88172990659099 -122.2903126010578
8161 8161 8161 060 236001600 741 Gilman St 741 GILMAN ST 741 GILMAN ST 741.0 GILMAN ST     Berkeley 94710 37.87933614699432 -122.30282047717256
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
10759 10759 10759 060 252900103 400 Gilman St 400 GILMAN ST 400 GILMAN ST 400.0 GILMAN ST     Berkeley 94710 37.87588026864899 -122.30833262060428
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
11098 11098 11098 060 235200100 1000 Gilman St 1000 GILMAN ST 1000 GILMAN ST 1000.0 GILMAN ST     Berkeley 94710 37.87989333959856 -122.29760543265644
11192 11192 11192 060 240601907 1125 Gilman St 1125 GILMAN ST 1125 GILMAN ST 1125.0 GILMAN ST     Berkeley 94706 37.8808678418439 -122.29468153767915
11706 11706 11706 060 235901803 815 Gilman St 815 GILMAN ST 815 GILMAN ST 815.0 GILMAN ST     Berkeley 94710 37.8797172635098 -122.30220908379016
11829 11829 11829 060 235001600 920 Gilman St 920 GILMAN ST 920 GILMAN ST 920.0 GILMAN ST     Berkeley 94710 37.87909616101632 -122.29959674611302
12091 12091 12091 060 239200200 1272 Gilman St 1272 GILMAN ST 1272 GILMAN ST 1272.0 GILMAN ST     Berkeley 94702 37.88130150773912 -122.29033246909694
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
12248 12248 12248 059 234900100 830 Gilman St 830 GILMAN ST 830 GILMAN ST 830.0 GILMAN ST     Berkeley 94710 37.879198043282706 -122.30101585069995
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
12766 12766 12766 060 235901601 801 Gilman St 801 GILMAN ST 801 GILMAN ST 801.0 GILMAN ST     Berkeley 94710 37.879435425318064 -122.302322103531
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
13111 13111 13111 060 235700100 901 Gilman St A 901 GILMAN ST A 901 GILMAN ST 901.0 GILMAN ST A   Berkeley 94710 37.8805920972321 -122.30001105271532
13119 13119 13119 060 242702000 1377 Gilman St 1377 GILMAN ST 1377 GILMAN ST 1377.0 GILMAN ST     Berkeley 94706 37.88080938012737 -122.28648333093662
13248 13248 13248 060 235000300 924 Gilman St 924 GILMAN ST 924 GILMAN ST 924.0 GILMAN ST     Berkeley 94710 37.87950486695773 -122.29929581408612
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
13905 13905 13905 060 235801202 843 Gilman St B 843 GILMAN ST B 843 GILMAN ST 843.0 GILMAN ST B   Berkeley 94710 37.87975688332539 -122.30074526466166
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
14163 14163 14163 059 234800200 820 Gilman St 820 GILMAN ST 820 GILMAN ST 820.0 GILMAN ST     Berkeley 94710 37.87906937390314 -122.301474863759
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
14675 14675 14675 060 236300200 641 Gilman St 641 GILMAN ST 641 GILMAN ST 641.0 GILMAN ST     Berkeley 94710 37.87874414499856 -122.3061857800259
14754 14754 14754 059 234700100 750 Gilman St 750 GILMAN ST 750 GILMAN ST 750.0 GILMAN ST     Berkeley 94710 37.87828780973035 -122.30272792913873
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
15895 15895 15895 060 235100106 950 Gilman St 101 950 GILMAN ST 101 950 GILMAN ST 950.0 GILMAN ST 101   Berkeley 94710 37.87959657815016 -122.29855464019631
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
17801 17801 17801 059 234800200 816 Gilman St 816 GILMAN ST 816 GILMAN ST 816.0 GILMAN ST     Berkeley 94710 37.879044788374536 -122.30156050823987
18262 18262 18262 060 241702400 1346 Gilman St 1346 GILMAN ST 1346 GILMAN ST 1346.0 GILMAN ST     Berkeley 94706 37.880778586901066 -122.28803945106225
19197 19197 19197 060 235801202 841 Gilman St B 841 GILMAN ST B 841 GILMAN ST 841.0 GILMAN ST B   Berkeley 94710 37.87975688332539 -122.30074526466166
19273 19273 19273 060 235100106 950 Gilman St 200 950 GILMAN ST 200 950 GILMAN ST 950.0 GILMAN ST 200   Berkeley 94710 37.87959657815016 -122.29855464019631
19416 19416 19416 060 235801600 831 Gilman St 831 GILMAN ST 831 GILMAN ST 831.0 GILMAN ST     Berkeley 94710 37.87966846157876 -122.30118059273993
19850 19850 19850 060 235100106 950 Gilman St 105 950 GILMAN ST 105 950 GILMAN ST 950.0 GILMAN ST 105   Berkeley 94710 37.87959657815016 -122.29855464019631
20237 20237 20237 060 235200100 1010 Gilman St 1010 GILMAN ST 1010 GILMAN ST 1010.0 GILMAN ST     Berkeley 94710 37.87992430478256 -122.29742141456713
20344 20344 20344 060 235500802 1011 Gilman St 1011 GILMAN ST 1011 GILMAN ST 1011.0 GILMAN ST     Berkeley 94710 37.88064798816878 -122.29766619021066
20360 20360 20360 060 235901803 805 Gilman St 805 GILMAN ST 805 GILMAN ST 805.0 GILMAN ST     Berkeley 94710 37.8797172635098 -122.30220908379016
20374 20374 20374 060 240901602 1227 Gilman St 1227 GILMAN ST 1227 GILMAN ST 1227.0 GILMAN ST     Berkeley 94706 37.88135383599175 -122.29228219055588
20635 20635 20635 060 236200110 669 Gilman St F 669 GILMAN ST F 669 GILMAN ST 669.0 GILMAN ST F   Berkeley 94710 37.879282400634686 -122.30518421148471
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
21216 21216 21216 060 239107301 1300 Gilman St 1300 GILMAN ST 1300 GILMAN ST 1300.0 GILMAN ST     Berkeley 94702 37.88097342421169 -122.28996955062046
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
22644 22644 22644 060 235301402 1050 Gilman St 1050 GILMAN ST 1050 GILMAN ST 1050.0 GILMAN ST     Berkeley 94710 37.87998851963509 -122.29655752362298
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
23796 23796 23796 060 235100106 950 Gilman St 110 950 GILMAN ST 110 950 GILMAN ST 950.0 GILMAN ST 110   Berkeley 94710 37.87959657815016 -122.29855464019631
24228 24228 24228 060 235801202 841 Gilman St 841 GILMAN ST 841 GILMAN ST 841.0 GILMAN ST     Berkeley 94710 37.87975688332539 -122.30074526466166
24681 24681 24681 060 235001600 912 Gilman St 912 GILMAN ST 912 GILMAN ST 912.0 GILMAN ST     Berkeley 94710 37.87909616101632 -122.29959674611302
25003 25003 25003 059 234607200 760 Gilman St A 760 GILMAN ST A 760 GILMAN ST 760.0 GILMAN ST A   Berkeley 94710 37.878626042539395 -122.3039093224335
25286 25286 25286 060 235100106 950 Gilman St 101B 950 GILMAN ST 101B 950 GILMAN ST 950.0 GILMAN ST 101B   Berkeley 94710 37.87959657815016 -122.29855464019631
25793 25793 25793 060 235801202 843 Gilman St A 843 GILMAN ST A 843 GILMAN ST 843.0 GILMAN ST A   Berkeley 94710 37.87975688332539 -122.30074526466166
26448 26448 26448 060 241400100 1320 Gilman St 1320 GILMAN ST 1320 GILMAN ST 1320.0 GILMAN ST     Berkeley 94706 37.88101511867977 -122.28905024709806
27181 27181 27181 060 235001600 916 Gilman St 916 GILMAN ST 916 GILMAN ST 916.0 GILMAN ST     Berkeley 94710 37.87909616101632 -122.29959674611302
27266 27266 27266 060 236101703 725 Gilman St 725 GILMAN ST 725 GILMAN ST 725.0 GILMAN ST     Berkeley 94710 37.87933991060648 -122.30395274879096
27486 27486 27486 060 235801100 899 Gilman St 899 GILMAN ST 899 GILMAN ST 899.0 GILMAN ST     Berkeley 94710 37.87981091508216 -122.30049526082314
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
28380 28380 28380 059 234607200 748 Gilman St B 748 GILMAN ST B 748 GILMAN ST 748.0 GILMAN ST B   Berkeley 94710 37.87857686266933 -122.30409691222437
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
28712 28712 28712 060 236200110 669 Gilman St B 669 GILMAN ST B 669 GILMAN ST 669.0 GILMAN ST B   Berkeley 94710 37.879282400634686 -122.30518421148471
28791 28791 28791 060 241101106 1281 Gilman St 1281 GILMAN ST 1281 GILMAN ST 1281.0 GILMAN ST     Berkeley 94706 37.88172990659099 -122.2903126010578

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