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

387 rows where street_name = "ADELINE" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

zipcode 1

street_type 1

  • ST · 387 ✖

street_name 1

  • ADELINE · 387 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
68 68 68 053 168200100 2870 Adeline St 602 2870 ADELINE ST 602 2870 ADELINE ST 2870.0 ADELINE ST 602   Berkeley 94703 37.85692293566353 -122.2687468205921
234 234 234 052 152400801 3398 Adeline St 3398 ADELINE ST 3398 ADELINE ST 3398.0 ADELINE ST     Berkeley 94703 37.84687993899464 -122.27266607854855
311 311 311 053 159800800 2914 Adeline St A 2914 ADELINE ST A 2914 ADELINE ST 2914.0 ADELINE ST A   Berkeley 94703 37.8558597848073 -122.26930146829628
344 344 344 053 168101700 2808 Adeline St 4 2808 ADELINE ST 4 2808 ADELINE ST 2808.0 ADELINE ST 4   Berkeley 94703 37.857943926786 -122.26836338998444
491 491 491 053 168200100 2870 Adeline St 505 2870 ADELINE ST 505 2870 ADELINE ST 2870.0 ADELINE ST 505   Berkeley 94703 37.85692293566353 -122.2687468205921
593 593 593 052 152400501 3380 Adeline St 3380 ADELINE ST 3380 ADELINE ST 3380.0 ADELINE ST     Berkeley 94703 37.84707624067913 -122.27260227929877
687 687 687 053 168101700 2808 Adeline St 2 2808 ADELINE ST 2 2808 ADELINE ST 2808.0 ADELINE ST 2   Berkeley 94703 37.857943926786 -122.26836338998444
967 967 967 053 159601501 3061 Adeline St 3061 ADELINE ST 3061 ADELINE ST 3061.0 ADELINE ST     Berkeley 94703 37.85314496311839 -122.26925589945688
1114 1114 1114 052 143400300 3411 Adeline St 4 3411 ADELINE ST 4 3411 ADELINE ST 3411.0 ADELINE ST 4   Berkeley 94703 37.846406563290664 -122.27207270896406
1116 1116 1116 052 152400300 3360 Adeline St 3 3360 ADELINE ST 3 3360 ADELINE ST 3360.0 ADELINE ST 3   Berkeley 94703 37.84748531008355 -122.27239382164385
1325 1325 1325 053 170300800 3075 Adeline St Unit 280 3075 ADELINE ST 3075 ADELINE ST 3075.0 ADELINE ST 280 UNIT Berkeley 94703 37.85277350246541 -122.26932783564654
1951 1951 1951 053 159800800 2914 Adeline St 1 2914 ADELINE ST 1 2914 ADELINE ST 2914.0 ADELINE ST 1   Berkeley 94703 37.8558597848073 -122.26930146829628
2070 2070 2070 053 168200100 2870 Adeline St 503 2870 ADELINE ST 503 2870 ADELINE ST 2870.0 ADELINE ST 503   Berkeley 94703 37.85692293566353 -122.2687468205921
2212 2212 2212 053 168200100 2870 Adeline St 413 2870 ADELINE ST 413 2870 ADELINE ST 2870.0 ADELINE ST 413   Berkeley 94703 37.85692293566353 -122.2687468205921
2349 2349 2349 053 168200100 2870 Adeline St 605 2870 ADELINE ST 605 2870 ADELINE ST 2870.0 ADELINE ST 605   Berkeley 94703 37.85692293566353 -122.2687468205921
2685 2685 2685 052 153002102 3224 Adeline St Apt 208 3224 ADELINE ST 3224 ADELINE ST 3224.0 ADELINE ST 208 APT Berkeley 94703 37.850067282623606 -122.27136476106168
3038 3038 3038 053 168200100 2870 Adeline St 219 2870 ADELINE ST 219 2870 ADELINE ST 2870.0 ADELINE ST 219   Berkeley 94703 37.85692293566353 -122.2687468205921
3102 3102 3102 052 155100900 3198 Adeline St 3198 ADELINE ST 3198 ADELINE ST 3198.0 ADELINE ST     Berkeley 94703 37.85076202252071 -122.27106837001853
3117 3117 3117 052 153100600 3286 Adeline St 3286 ADELINE ST 3286 ADELINE ST 3286.0 ADELINE ST     Berkeley 94703 37.84885977556932 -122.27189894873696
3296 3296 3296 052 152400501 3380 Adeline St 8 3380 ADELINE ST 8 3380 ADELINE ST 3380.0 ADELINE ST 8   Berkeley 94703 37.84707624067913 -122.27260227929877
3339 3339 3339 053 168200100 2870 Adeline St 216 2870 ADELINE ST 216 2870 ADELINE ST 2870.0 ADELINE ST 216   Berkeley 94703 37.85692293566353 -122.2687468205921
3814 3814 3814 053 159100100 2903 Adeline St 2903 ADELINE ST 2903 ADELINE ST 2903.0 ADELINE ST     Berkeley 94703 37.85636176695468 -122.26810249137816
3884 3884 3884 052 153000500 3228 Adeline St C 3228 ADELINE ST C 3228 ADELINE ST 3228.0 ADELINE ST C   Berkeley 94703 37.84997386775412 -122.27145605953896
4170 4170 4170 052 152400300 3358 Adeline St 3358 ADELINE ST 3358 ADELINE ST 3358.0 ADELINE ST     Berkeley 94703 37.84748531008355 -122.27239382164385
4189 4189 4189 052 153000100 3208 Adeline St 3208 ADELINE ST 3208 ADELINE ST 3208.0 ADELINE ST     Berkeley 94703 37.850416755825535 -122.27130890561396
4378 4378 4378 053 159601501 3055 Adeline St 3055 ADELINE ST 3055 ADELINE ST 3055.0 ADELINE ST     Berkeley 94703 37.85314496311839 -122.26925589945688
4444 4444 4444 052 153100600 3286 Adeline St 9 3286 ADELINE ST 9 3286 ADELINE ST 3286.0 ADELINE ST 9   Berkeley 94703 37.84885977556932 -122.27189894873696
4455 4455 4455 053 168200100 2870 Adeline St 502 2870 ADELINE ST 502 2870 ADELINE ST 2870.0 ADELINE ST 502   Berkeley 94703 37.85692293566353 -122.2687468205921
4535 4535 4535 052 153100402 3276 Adeline St 3276 ADELINE ST 3276 ADELINE ST 3276.0 ADELINE ST     Berkeley 94703 37.849103757834065 -122.27187492239636
4587 4587 4587 053 168200100 2870 Adeline St 306 2870 ADELINE ST 306 2870 ADELINE ST 2870.0 ADELINE ST 306   Berkeley 94703 37.85692293566353 -122.2687468205921
4699 4699 4699 052 153002102 3224 Adeline St Apt 101 3224 ADELINE ST 3224 ADELINE ST 3224.0 ADELINE ST 101 APT Berkeley 94703 37.85002776104436 -122.2716801981855
4787 4787 4787 052 152902000 3215 Adeline St 3215 ADELINE ST 3215 ADELINE ST 3215.0 ADELINE ST     Berkeley 94703 37.85023117313841 -122.27023778501189
5320 5320 5320 052 152400501 3380 Adeline St 15 3380 ADELINE ST 15 3380 ADELINE ST 3380.0 ADELINE ST 15   Berkeley 94703 37.84707624067913 -122.27260227929877
5360 5360 5360 053 168200100 2870 Adeline St 313 2870 ADELINE ST 313 2870 ADELINE ST 2870.0 ADELINE ST 313   Berkeley 94703 37.85692293566353 -122.2687468205921
5422 5422 5422 052 152400300 3360 Adeline St 7273 3360 ADELINE ST 7273 3360 ADELINE ST 3360.0 ADELINE ST 7273   Berkeley 94703 37.84748531008355 -122.27239382164385
5704 5704 5704 052 155202001 3165 Adeline St 3165 ADELINE ST 3165 ADELINE ST 3165.0 ADELINE ST     Berkeley 94703 37.85151778447607 -122.26984575932356
5726 5726 5726 052 155201900 3175 Adeline St 3175 ADELINE ST 3175 ADELINE ST 3175.0 ADELINE ST     Berkeley 94703 37.851329943264815 -122.26992266589168
5796 5796 5796 053 168200100 2870 Adeline St 410 2870 ADELINE ST 410 2870 ADELINE ST 2870.0 ADELINE ST 410   Berkeley 94703 37.85692293566353 -122.2687468205921
6255 6255 6255 053 159800900 2918 Adeline St E 2918 ADELINE ST E 2918 ADELINE ST 2918.0 ADELINE ST E   Berkeley 94703 37.855754459377025 -122.26932747093048
6455 6455 6455 052 153000500 3230 Adeline St 3230 ADELINE ST 3230 ADELINE ST 3230.0 ADELINE ST     Berkeley 94703 37.84997386775412 -122.27145605953896
6871 6871 6871 052 152400300 3356 Adeline St 3356 ADELINE ST 3356 ADELINE ST 3356.0 ADELINE ST     Berkeley 94703 37.84748531008355 -122.27239382164385
6954 6954 6954 052 143400300 3411 Adeline St 3411 ADELINE ST 3411 ADELINE ST 3411.0 ADELINE ST     Berkeley 94703 37.846406563290664 -122.27207270896406
7104 7104 7104 052 153100500 3284 Adeline St 3284 ADELINE ST 3284 ADELINE ST 3284.0 ADELINE ST     Berkeley 94703 37.84900059828881 -122.27188488471288
7485 7485 7485 052 153200101 3310 Adeline St 3310 ADELINE ST 3310 ADELINE ST 3310.0 ADELINE ST     Berkeley 94703 37.84834709438575 -122.27202743028045
7512 7512 7512 052 153000700 3240 Adeline St A 3240 ADELINE ST A 3240 ADELINE ST 3240.0 ADELINE ST A   Berkeley 94703 37.84978631910917 -122.27148647469784
7626 7626 7626 052 152400501 3380 Adeline St 3 3380 ADELINE ST 3 3380 ADELINE ST 3380.0 ADELINE ST 3   Berkeley 94703 37.84707624067913 -122.27260227929877
7708 7708 7708 053 168200100 2870 Adeline St 405 2870 ADELINE ST 405 2870 ADELINE ST 2870.0 ADELINE ST 405   Berkeley 94703 37.85692293566353 -122.2687468205921
7729 7729 7729 053 168200100 2870 Adeline St 407 2870 ADELINE ST 407 2870 ADELINE ST 2870.0 ADELINE ST 407   Berkeley 94703 37.85692293566353 -122.2687468205921
7874 7874 7874 052 152801404 3271 Adeline St 3271 ADELINE ST 3271 ADELINE ST 3271.0 ADELINE ST     Berkeley 94703 37.849133959944695 -122.2706666631864
8162 8162 8162 052 153200201 3330 Adeline St 3330 ADELINE ST 3330 ADELINE ST 3330.0 ADELINE ST     Berkeley 94703 37.84810489929677 -122.27215849178548
8408 8408 8408 053 159801401 2934 Adeline St D 2934 ADELINE ST D 2934 ADELINE ST 2934.0 ADELINE ST D   Berkeley 94703 37.855375764492 -122.26941107533736
8440 8440 8440 053 168200100 2870 Adeline St 318 2870 ADELINE ST 318 2870 ADELINE ST 2870.0 ADELINE ST 318   Berkeley 94703 37.85692293566353 -122.2687468205921
8614 8614 8614 053 168101700 2808 Adeline St 2808 ADELINE ST 2808 ADELINE ST 2808.0 ADELINE ST     Berkeley 94703 37.857943926786 -122.26836338998444
8626 8626 8626 052 153100600 3286 Adeline St 6 3286 ADELINE ST 6 3286 ADELINE ST 3286.0 ADELINE ST 6   Berkeley 94703 37.84885977556932 -122.27189894873696
8974 8974 8974 052 152400501 3380 Adeline St 7 3380 ADELINE ST 7 3380 ADELINE ST 3380.0 ADELINE ST 7   Berkeley 94703 37.84707624067913 -122.27260227929877
9040 9040 9040 053 168200100 2870 Adeline St 312 2870 ADELINE ST 312 2870 ADELINE ST 2870.0 ADELINE ST 312   Berkeley 94703 37.85692293566353 -122.2687468205921
9042 9042 9042 054 172100100 2747 Adeline St 2747 ADELINE ST 2747 ADELINE ST 2747.0 ADELINE ST     Berkeley 94703 37.85879430904404 -122.26718750695564
9167 9167 9167 052 152400300 3362 Adeline St 3362 ADELINE ST 3362 ADELINE ST 3362.0 ADELINE ST     Berkeley 94703 37.84748531008355 -122.27239382164385
9266 9266 9266 052 152801702 3253 Adeline St 303 3253 ADELINE ST 303 3253 ADELINE ST 3253.0 ADELINE ST 303   Berkeley 94703 37.84943415312837 -122.27071691943496
9478 9478 9478 053 168200100 2870 Adeline St 211 2870 ADELINE ST 211 2870 ADELINE ST 2870.0 ADELINE ST 211   Berkeley 94703 37.85692293566353 -122.2687468205921
9607 9607 9607 053 170300800 3075 Adeline St Unit 290 3075 ADELINE ST 3075 ADELINE ST 3075.0 ADELINE ST 290 UNIT Berkeley 94703 37.85284629230606 -122.269342974954
9726 9726 9726 053 168101700 2808 Adeline St 3 2808 ADELINE ST 3 2808 ADELINE ST 2808.0 ADELINE ST 3   Berkeley 94703 37.857943926786 -122.26836338998444
10227 10227 10227 053 170300800 3075 Adeline St Unit 110 3075 ADELINE ST 3075 ADELINE ST 3075.0 ADELINE ST 110 UNIT Berkeley 94703 37.85224686311065 -122.26905258555524
10494 10494 10494 052 153200101 3320 Adeline St 3320 ADELINE ST 3320 ADELINE ST 3320.0 ADELINE ST     Berkeley 94703 37.84834709438575 -122.27202743028045
10628 10628 10628 053 168200100 2870 Adeline St 409 2870 ADELINE ST 409 2870 ADELINE ST 2870.0 ADELINE ST 409   Berkeley 94703 37.85692293566353 -122.2687468205921
10671 10671 10671 053 168100500 2800 Adeline St 2800 ADELINE ST 2800 ADELINE ST 2800.0 ADELINE ST     Berkeley 94703 37.858188758457665 -122.26829777523945
10800 10800 10800 052 152400400 3370 Adeline St 3370 ADELINE ST 3370 ADELINE ST 3370.0 ADELINE ST     Berkeley 94703 37.84729169084481 -122.27242052496396
10869 10869 10869 053 159800700 2912 Adeline St C 2912 ADELINE ST C 2912 ADELINE ST 2912.0 ADELINE ST C   Berkeley 94703 37.855957834393145 -122.26921785310964
10870 10870 10870 052 152801702 3253 Adeline St 205 3253 ADELINE ST 205 3253 ADELINE ST 3253.0 ADELINE ST 205   Berkeley 94703 37.84943415312837 -122.27071691943496
10902 10902 10902 053 159801600 2970 Adeline St 2970 ADELINE ST 2970 ADELINE ST 2970.0 ADELINE ST     Berkeley 94703 37.85510092738615 -122.26948244379174
11150 11150 11150 052 153100100 3254 Adeline St 3254 ADELINE ST 3254 ADELINE ST 3254.0 ADELINE ST     Berkeley 94703 37.849493484555865 -122.27162441909456
11200 11200 11200 052 153002102 3224 Adeline St Apt 201 3224 ADELINE ST 3224 ADELINE ST 3224.0 ADELINE ST 201 APT Berkeley 94703 37.85003245111635 -122.27164257314814
11265 11265 11265 052 153000500 3228 Adeline St A 3228 ADELINE ST A 3228 ADELINE ST 3228.0 ADELINE ST A   Berkeley 94703 37.84997386775412 -122.27145605953896
11631 11631 11631 053 159801900 2996 Adeline St 1 2996 ADELINE ST 1 2996 ADELINE ST 2996.0 ADELINE ST 1   Berkeley 94703 37.85466917411088 -122.269697290265
11728 11728 11728 053 168200100 2870 Adeline St 304 2870 ADELINE ST 304 2870 ADELINE ST 2870.0 ADELINE ST 304   Berkeley 94703 37.85692293566353 -122.2687468205921
12197 12197 12197 053 170300800 3075 Adeline St Unit 150 3075 ADELINE ST 3075 ADELINE ST 3075.0 ADELINE ST 150 UNIT Berkeley 94703 37.85249670010815 -122.26910426204029
12472 12472 12472 052 152400801 3392 Adeline St 3392 ADELINE ST 3392 ADELINE ST 3392.0 ADELINE ST     Berkeley 94703 37.84687993899464 -122.27266607854855
12616 12616 12616 053 168200100 2870 Adeline St 214 2870 ADELINE ST 214 2870 ADELINE ST 2870.0 ADELINE ST 214   Berkeley 94703 37.85692293566353 -122.2687468205921
12671 12671 12671 052 153200101 3318 Adeline St 3318 ADELINE ST 3318 ADELINE ST 3318.0 ADELINE ST     Berkeley 94703 37.84834709438575 -122.27202743028045
12753 12753 12753 052 153200201 3328 Adeline St 3328 ADELINE ST 3328 ADELINE ST 3328.0 ADELINE ST     Berkeley 94703 37.84810489929677 -122.27215849178548
12940 12940 12940 053 168200100 2870 Adeline St 203 2870 ADELINE ST 203 2870 ADELINE ST 2870.0 ADELINE ST 203   Berkeley 94703 37.85692293566353 -122.2687468205921
13205 13205 13205 053 168200100 2870 Adeline St 518 2870 ADELINE ST 518 2870 ADELINE ST 2870.0 ADELINE ST 518   Berkeley 94703 37.85692293566353 -122.2687468205921
13276 13276 13276 052 152400501 3380 Adeline St 1 3380 ADELINE ST 1 3380 ADELINE ST 3380.0 ADELINE ST 1   Berkeley 94703 37.84707624067913 -122.27260227929877
13470 13470 13470 053 168200100 2870 Adeline St 402 2870 ADELINE ST 402 2870 ADELINE ST 2870.0 ADELINE ST 402   Berkeley 94703 37.85692293566353 -122.2687468205921
13560 13560 13560 052 153000600 3234 Adeline St 3234 ADELINE ST 3234 ADELINE ST 3234.0 ADELINE ST     Berkeley 94703 37.84987113147688 -122.2714715087652
13726 13726 13726 053 159800800 2914 Adeline St 2 2914 ADELINE ST 2 2914 ADELINE ST 2914.0 ADELINE ST 2   Berkeley 94703 37.8558597848073 -122.26930146829628
14056 14056 14056 053 159201700 3017 Adeline St 3017 ADELINE ST 3017 ADELINE ST 3017.0 ADELINE ST     Berkeley 94703 37.85464678985607 -122.26863477013345
14389 14389 14389 052 152801702 3269 Adeline St 3269 ADELINE ST 3269 ADELINE ST 3269.0 ADELINE ST     Berkeley 94703 37.84943415312837 -122.27071691943496
14445 14445 14445 053 168200100 2870 Adeline St 104 2870 ADELINE ST 104 2870 ADELINE ST 2870.0 ADELINE ST 104   Berkeley 94703 37.85692293566353 -122.2687468205921
14812 14812 14812 053 159500903 3031 Adeline St 3031 ADELINE ST 3031 ADELINE ST 3031.0 ADELINE ST     Berkeley 94703 37.8538455128952 -122.26895152508578
14971 14971 14971 053 168200100 2870 Adeline St 414 2870 ADELINE ST 414 2870 ADELINE ST 2870.0 ADELINE ST 414   Berkeley 94703 37.85692293566353 -122.2687468205921
15122 15122 15122 053 159201500 3023 Adeline St 3023 ADELINE ST 3023 ADELINE ST 3023.0 ADELINE ST     Berkeley 94703 37.85444902166579 -122.26880374772996
15127 15127 15127 053 168101201 2816 Adeline St 2816 ADELINE ST 2816 ADELINE ST 2816.0 ADELINE ST     Berkeley 94703 37.85768662846044 -122.2683961183052
15340 15340 15340 053 168200100 2870 Adeline St 316 2870 ADELINE ST 316 2870 ADELINE ST 2870.0 ADELINE ST 316   Berkeley 94703 37.85692293566353 -122.2687468205921
15502 15502 15502 053 168200100 2870 Adeline St 501 2870 ADELINE ST 501 2870 ADELINE ST 2870.0 ADELINE ST 501   Berkeley 94703 37.85692293566353 -122.2687468205921
15519 15519 15519 053 168200100 2870 Adeline St 512 2870 ADELINE ST 512 2870 ADELINE ST 2870.0 ADELINE ST 512   Berkeley 94703 37.85692293566353 -122.2687468205921
15596 15596 15596 052 153100600 3286 Adeline St 7 3286 ADELINE ST 7 3286 ADELINE ST 3286.0 ADELINE ST 7   Berkeley 94703 37.84885977556932 -122.27189894873696
15604 15604 15604 052 152902300 3201 Adeline St Sumrf 3201 ADELINE ST SUMRF 3201 ADELINE ST 3201.0 ADELINE ST SUMRF   Berkeley 94703 37.85058891129228 -122.27020212908162
15649 15649 15649 053 168101001 2834 Adeline St 2834 ADELINE ST 2834 ADELINE ST 2834.0 ADELINE ST     Berkeley 94703 37.85756952137364 -122.26846012057425
16104 16104 16104 053 159801700 2986 Adeline St 2986 ADELINE ST 2986 ADELINE ST 2986.0 ADELINE ST     Berkeley 94703 37.85493605754137 -122.2695183171143

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