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

355 rows where street_type = "RD" and zipcode = 94705

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94705 · 355 ✖

street_type 1

  • RD · 355 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
10 10 10 064 425001100 145 Hillcrest Rd 145 HILLCREST RD 145 HILLCREST RD 145.0 HILLCREST RD     Berkeley 94705 37.853069712308425 -122.24551551058904
288 288 288 064 422300600 163 Alvarado Rd 163 ALVARADO RD 163 ALVARADO RD 163.0 ALVARADO RD     Berkeley 94705 37.85669970820088 -122.23772215837536
305 305 305 064 423700600 45 Hazel Rd 45 HAZEL RD 45 HAZEL RD 45.0 HAZEL RD     Berkeley 94705 37.856657241768566 -122.24534522235054
334 334 334 064 425204000 162 Hillcrest Rd 162 HILLCREST RD 162 HILLCREST RD 162.0 HILLCREST RD     Berkeley 94705 37.85253752619113 -122.245056896382
382 382 382 064 422601200 1 Alvarado Rd 1 ALVARADO RD 1 ALVARADO RD 1.0 ALVARADO RD     Berkeley 94705 37.85580946412616 -122.23975189457332
439 439 439 064 422201901 154 Vicente Rd 154 VICENTE RD 154 VICENTE RD 154.0 VICENTE RD     Berkeley 94705 37.8573764917661 -122.23493910216668
492 492 492 064 424701500 81 Hillcrest Rd 81 HILLCREST RD 81 HILLCREST RD 81.0 HILLCREST RD     Berkeley 94705 37.85236445956179 -122.24728212754536
760 760 760 064 423101200 24 Vicente Rd 24 VICENTE RD 24 VICENTE RD 24.0 VICENTE RD     Berkeley 94705 37.854064726626014 -122.23466218390394
850 850 850 064 424901500 104 Hillcrest Rd 104 HILLCREST RD 104 HILLCREST RD 104.0 HILLCREST RD     Berkeley 94705 37.85263786485812 -122.24698107963576
951 951 951 064 422301300 131 Alvarado Rd 131 ALVARADO RD 131 ALVARADO RD 131.0 ALVARADO RD     Berkeley 94705 37.85710336930652 -122.23880801494138
976 976 976 064 423001200 49 Vicente Rd 49 VICENTE RD 49 VICENTE RD 49.0 VICENTE RD     Berkeley 94705 37.854882171385384 -122.23576452904696
1053 1053 1053 064 423001100 51 Vicente Rd 51 VICENTE RD 51 VICENTE RD 51.0 VICENTE RD     Berkeley 94705 37.85501033827995 -122.2357234194446
1363 1363 1363 064 423700200 5 Hazel Rd 5 HAZEL RD 5 HAZEL RD 5.0 HAZEL RD     Berkeley 94705 37.85661387383728 -122.2460847604082
1493 1493 1493 064 424300302 64 Oak Ridge Rd 64 OAK RIDGE RD 64 OAK RIDGE RD 64.0 OAK RIDGE RD     Berkeley 94705 37.85581432192773 -122.24159945782152
1605 1605 1605 064 424900500 17 Eucalyptus Rd 17 EUCALYPTUS RD 17 EUCALYPTUS RD 17.0 EUCALYPTUS RD     Berkeley 94705 37.8520848333342 -122.2464173481674
1795 1795 1795 064 424100500 34 Oak Ridge Rd 34 OAK RIDGE RD 34 OAK RIDGE RD 34.0 OAK RIDGE RD     Berkeley 94705 37.85677690648636 -122.24297606131576
1895 1895 1895 064 423100400 66 Vicente Rd 66 VICENTE RD 66 VICENTE RD 66.0 VICENTE RD     Berkeley 94705 37.85527935256139 -122.23490718592296
1947 1947 1947 064 422801000 175 Alvarado Rd 175 ALVARADO RD 175 ALVARADO RD 175.0 ALVARADO RD     Berkeley 94705 37.85635263940518 -122.23719775515018
2278 2278 2278 064 424900100 120 Hillcrest Rd 120 HILLCREST RD 120 HILLCREST RD 120.0 HILLCREST RD     Berkeley 94705 37.85284380408093 -122.24709150594038
2505 2505 2505 064 425205400 220 Hillcrest Rd 220 HILLCREST RD 220 HILLCREST RD 220.0 HILLCREST RD     Berkeley 94705 37.85211336380512 -122.24265447163054
2643 2643 2643 064 423803300 80 Hazel Rd 80 HAZEL RD 80 HAZEL RD 80.0 HAZEL RD     Berkeley 94705 37.85626522722697 -122.24466044289764
2874 2874 2874 064 425200300 262 Hillcrest Rd 262 HILLCREST RD 262 HILLCREST RD 262.0 HILLCREST RD     Berkeley 94705 37.85214000750845 -122.24159298635824
2908 2908 2908 064 423401700 30 Oak Ridge Rd 30 OAK RIDGE RD 30 OAK RIDGE RD 30.0 OAK RIDGE RD     Berkeley 94705 37.857164567714406 -122.24270780371069
3071 3071 3071 048H769000400 2415 Fernwald Rd 2415 FERNWALD RD 2415 FERNWALD RD 2415.0 FERNWALD RD     Berkeley 94705 37.8649044789697 -122.2473520973228
3349 3349 3349 064 425001401 125 Hillcrest Rd 125 HILLCREST RD 125 HILLCREST RD 125.0 HILLCREST RD     Berkeley 94705 37.853100093665375 -122.24623059111477
3378 3378 3378 064 429500700 20 Hillcrest Rd 20 HILLCREST RD 20 HILLCREST RD 20.0 HILLCREST RD     Berkeley 94705 37.85268346659185 -122.24880596581296
3829 3829 3829 064 426500602 59 Roble Rd 59 ROBLE RD 59 ROBLE RD 59.0 ROBLE RD     Berkeley 94705 37.852581084485706 -122.2352891927009
4279 4279 4279 064 422300400 281 Alvarado Rd 281 ALVARADO RD 281 ALVARADO RD 281.0 ALVARADO RD     Berkeley 94705 37.85711722184741 -122.23798016979632
4384 4384 4384 048H768003201 25 Tanglewood Rd 25 TANGLEWOOD RD 25 TANGLEWOOD RD 25.0 TANGLEWOOD RD     Berkeley 94705 37.86144662008255 -122.24450727565014
4480 4480 4480 064 422200400 160 Vicente Rd 160 VICENTE RD 160 VICENTE RD 160.0 VICENTE RD     Berkeley 94705 37.85718320348302 -122.23528684719967
4525 4525 4525 064 425901801 263 Hillcrest Rd 263 HILLCREST RD 263 HILLCREST RD 263.0 HILLCREST RD     Berkeley 94705 37.85247259158551 -122.24139984408058
5060 5060 5060 064 422702200 50 Alvarado Rd 50 ALVARADO RD 50 ALVARADO RD 50.0 ALVARADO RD     Berkeley 94705 37.857281604518825 -122.24006285988364
5176 5176 5176 064 422701400 135 Tunnel Rd 135 TUNNEL RD 135 TUNNEL RD 135.0 TUNNEL RD     Berkeley 94705 37.85566634147208 -122.23917994531676
5383 5383 5383 064 425204601 186 Hillcrest Rd 186 HILLCREST RD 186 HILLCREST RD 186.0 HILLCREST RD     Berkeley 94705 37.852430898696866 -122.24394236379553
5397 5397 5397 064 422901700 161 Vicente Rd 161 VICENTE RD 161 VICENTE RD 161.0 VICENTE RD     Berkeley 94705 37.85672506931794 -122.23493695698976
6383 6383 6383 064 429501400 54 Hillcrest Rd 54 HILLCREST RD 54 HILLCREST RD 54.0 HILLCREST RD     Berkeley 94705 37.851999548276346 -122.2475982258292
6435 6435 6435 064 426501103 37 Roble Rd 37 ROBLE RD 37 ROBLE RD 37.0 ROBLE RD     Berkeley 94705 37.8527490280339 -122.23629274292558
6517 6517 6517 064 423803200 70 Hazel Rd 70 HAZEL RD 70 HAZEL RD 70.0 HAZEL RD     Berkeley 94705 37.85625455771818 -122.24483686303633
6662 6662 6662 064 425203100 24 Eucalyptus Rd 24 EUCALYPTUS RD 24 EUCALYPTUS RD 24.0 EUCALYPTUS RD     Berkeley 94705 37.851891973785314 -122.24582981134402
6735 6735 6735 064 422300500 277 Alvarado Rd 277 ALVARADO RD 277 ALVARADO RD 277.0 ALVARADO RD     Berkeley 94705 37.857033423545886 -122.23763382344022
6826 6826 6826 064 423401000 34 Tunnel Rd 34 TUNNEL RD 34 TUNNEL RD 34.0 TUNNEL RD     Berkeley 94705 37.8573765669473 -122.24239205037988
6912 6912 6912 064 424900601 25 Eucalyptus Rd 25 EUCALYPTUS RD 25 EUCALYPTUS RD 25.0 EUCALYPTUS RD     Berkeley 94705 37.8518749333349 -122.24643811452184
6974 6974 6974 064 423000301 23 Vicente Rd 23 VICENTE RD 23 VICENTE RD 23.0 VICENTE RD     Berkeley 94705 37.854099388836275 -122.23530095973284
7261 7261 7261 064 422700100 116 Alvarado Rd 116 ALVARADO RD 116 ALVARADO RD 116.0 ALVARADO RD     Berkeley 94705 37.85739051873274 -122.2397978011793
7332 7332 7332 064 424100600 36 Oak Ridge Rd 36 OAK RIDGE RD 36 OAK RIDGE RD 36.0 OAK RIDGE RD     Berkeley 94705 37.85667249660697 -122.24290447007915
7403 7403 7403 064 422601800 71 Tunnel Rd 71 TUNNEL RD 71 TUNNEL RD 71.0 TUNNEL RD     Berkeley 94705 37.856752878091584 -122.240867131439
7415 7415 7415 048H768001900 11 Tanglewood Rd 11 TANGLEWOOD RD 11 TANGLEWOOD RD 11.0 TANGLEWOOD RD     Berkeley 94705 37.8620772365156 -122.24472028686526
7517 7517 7517 064 422600500 33 Alvarado Rd 33 ALVARADO RD 33 ALVARADO RD 33.0 ALVARADO RD     Berkeley 94705 37.85670017276821 -122.24026315095432
7933 7933 7933 064 422701600 10 Alvarado Rd 10 ALVARADO RD 10 ALVARADO RD 10.0 ALVARADO RD     Berkeley 94705 37.85592320852024 -122.23919242291603
8382 8382 8382 064 425200100 254 Hillcrest Rd 254 HILLCREST RD 254 HILLCREST RD 254.0 HILLCREST RD     Berkeley 94705 37.85237540697178 -122.2418171735138
8474 8474 8474 064 422800100 275 Alvarado Rd 275 ALVARADO RD 275 ALVARADO RD 275.0 ALVARADO RD     Berkeley 94705 37.8570690539181 -122.23718510058276
8740 8740 8740 064 423202700 83 Oak Ridge Rd 83 OAK RIDGE RD 83 OAK RIDGE RD 83.0 OAK RIDGE RD     Berkeley 94705 37.85545272017338 -122.2401807287304
8898 8898 8898 064 423802600 30 Hazel Rd 30 HAZEL RD 30 HAZEL RD 30.0 HAZEL RD     Berkeley 94705 37.85619153289898 -122.24587382340306
9284 9284 9284 064 429500800 24 Hillcrest Rd 24 HILLCREST RD 24 HILLCREST RD 24.0 HILLCREST RD     Berkeley 94705 37.85257499441207 -122.248687674758
9561 9561 9561 064 426501500 25 Roble Rd 25 ROBLE RD 25 ROBLE RD 25.0 ROBLE RD     Berkeley 94705 37.85336623659769 -122.23675111728248
10207 10207 10207 064 422702100 44 Alvarado Rd 44 ALVARADO RD 44 ALVARADO RD 44.0 ALVARADO RD     Berkeley 94705 37.85702554083082 -122.23993045270235
10362 10362 10362 064 424300500 70 Oak Ridge Rd 70 OAK RIDGE RD 70 OAK RIDGE RD 70.0 OAK RIDGE RD     Berkeley 94705 37.85558785611014 -122.24139931856612
10363 10363 10363 064 423200502 100 Tunnel Rd 100 TUNNEL RD 100 TUNNEL RD 100.0 TUNNEL RD     Berkeley 94705 37.85593657472332 -122.2408315042548
10376 10376 10376 064 422600400 41 Alvarado Rd 41 ALVARADO RD 41 ALVARADO RD 41.0 ALVARADO RD     Berkeley 94705 37.85680945807604 -122.2403652938937
10502 10502 10502 054 170206800 18 Tanglewood Rd 18 TANGLEWOOD RD 18 TANGLEWOOD RD 18.0 TANGLEWOOD RD     Berkeley 94705 37.86181152644828 -122.24520436561568
10629 10629 10629 064 423802400 8 Hazel Rd 8 HAZEL RD 8 HAZEL RD 8.0 HAZEL RD     Berkeley 94705 37.85616983284099 -122.24621455798358
10929 10929 10929 064 425500603 6 Roble Rd 6 ROBLE RD 6 ROBLE RD 6.0 ROBLE RD     Berkeley 94705 37.85421482255354 -122.2372097512525
11011 11011 11011 064 422901100 182 Alvarado Rd 182 ALVARADO RD 182 ALVARADO RD 182.0 ALVARADO RD     Berkeley 94705 37.85586847408831 -122.23754595652731
11194 11194 11194 064 425101600 165 Hillcrest Rd 165 HILLCREST RD 165 HILLCREST RD 165.0 HILLCREST RD     Berkeley 94705 37.85303769175047 -122.2446702426191
11322 11322 11322 064 425203400 14 Eucalyptus Rd 14 EUCALYPTUS RD 14 EUCALYPTUS RD 14.0 EUCALYPTUS RD     Berkeley 94705 37.85232690328 -122.24590540098194
11510 11510 11510 064 423100900 42 Vicente Rd 42 VICENTE RD 42 VICENTE RD 42.0 VICENTE RD     Berkeley 94705 37.85455694848621 -122.23492467073164
12024 12024 12024 064 422900600 19 Bridge Rd 19 BRIDGE RD 19 BRIDGE RD 19.0 BRIDGE RD     Berkeley 94705 37.85610865275754 -122.23829885792316
12086 12086 12086 064 422301200 135 Alvarado Rd 135 ALVARADO RD 135 ALVARADO RD 135.0 ALVARADO RD     Berkeley 94705 37.85699837120356 -122.23869651245504
12104 12104 12104 064 424300800 80 Oak Ridge Rd 80 OAK RIDGE RD 80 OAK RIDGE RD 80.0 OAK RIDGE RD     Berkeley 94705 37.855275485584215 -122.24102989179542
12177 12177 12177 064 422301600 119 Alvarado Rd 119 ALVARADO RD 119 ALVARADO RD 119.0 ALVARADO RD     Berkeley 94705 37.85741779815024 -122.23914800032692
12410 12410 12410 064 424900900 70 Hillcrest Rd 70 HILLCREST RD 70 HILLCREST RD 70.0 HILLCREST RD     Berkeley 94705 37.851686358186946 -122.2469186341471
12471 12471 12471 064 425501200 16 Roble Rd 16 ROBLE RD 16 ROBLE RD 16.0 ROBLE RD     Berkeley 94705 37.85368093530829 -122.23772075341029
12964 12964 12964 064 423802200 2 Hazel Rd 2 HAZEL RD 2 HAZEL RD 2.0 HAZEL RD     Berkeley 94705 37.85609221332327 -122.24664044836148
13207 13207 13207 064 425001700 115 Hillcrest Rd 115 HILLCREST RD 115 HILLCREST RD 115.0 HILLCREST RD     Berkeley 94705 37.85314758680915 -122.24657425959302
13270 13270 13270 064 422601700 73 Tunnel Rd 73 TUNNEL RD 73 TUNNEL RD 73.0 TUNNEL RD     Berkeley 94705 37.85660066592288 -122.2406773785049
13324 13324 13324 064 422201100 244 Alvarado Rd 244 ALVARADO RD 244 ALVARADO RD 244.0 ALVARADO RD     Berkeley 94705 37.85721009926855 -122.23627110790032
13402 13402 13402 064 425500200 152 Tunnel Rd 152 TUNNEL RD 152 TUNNEL RD 152.0 TUNNEL RD     Berkeley 94705 37.85505354614828 -122.23849936458952
13801 13801 13801 064 422900215 63 Vicente Rd 63 VICENTE RD 63 VICENTE RD 63.0 VICENTE RD     Berkeley 94705 37.85556928660993 -122.23570453056912
13888 13888 13888 064 422700200 118 Alvarado Rd 118 ALVARADO RD 118 ALVARADO RD 118.0 ALVARADO RD     Berkeley 94705 37.85717042902767 -122.23958733758631
14265 14265 14265 048H769000400 1 Tanglewood Rd Z 1 TANGLEWOOD RD Z 1 TANGLEWOOD RD 1.0 TANGLEWOOD RD Z   Berkeley 94705 37.8649044789697 -122.2473520973228
14442 14442 14442 064 425501300 22 Roble Rd A 22 ROBLE RD A 22 ROBLE RD 22.0 ROBLE RD A   Berkeley 94705 37.8535572176277 -122.23743946484366
14620 14620 14620 048H768001400 19 Tanglewood Rd 19 TANGLEWOOD RD 19 TANGLEWOOD RD 19.0 TANGLEWOOD RD     Berkeley 94705 37.86184159073002 -122.24468834816366
14694 14694 14694 064 425200400 266 Hillcrest Rd Flat 266 HILLCREST RD FLAT 266 HILLCREST RD 266.0 HILLCREST RD FLAT   Berkeley 94705 37.85199836160348 -122.24155966245446
14853 14853 14853 064 422801300 215 Alvarado Rd 215 ALVARADO RD 215 ALVARADO RD 215.0 ALVARADO RD     Berkeley 94705 37.85612045428026 -122.23663195935328
15264 15264 15264 064 426500602 250 Tunnel Rd 250 TUNNEL RD 250 TUNNEL RD 250.0 TUNNEL RD     Berkeley 94705 37.852581084485706 -122.2352891927009
15482 15482 15482 064 425205300 214 Hillcrest Rd 214 HILLCREST RD 214 HILLCREST RD 214.0 HILLCREST RD     Berkeley 94705 37.85211073511241 -122.2428213166266
15819 15819 15819 064 425203000 28 Eucalyptus Rd 28 EUCALYPTUS RD 28 EUCALYPTUS RD 28.0 EUCALYPTUS RD     Berkeley 94705 37.851748964108566 -122.24576938167488
15821 15821 15821 054 170206700 10 Tanglewood Rd 10 TANGLEWOOD RD 10 TANGLEWOOD RD 10.0 TANGLEWOOD RD     Berkeley 94705 37.86213205357016 -122.24530998952676
16013 16013 16013 064 424301201 88 Oak Ridge Rd 88 OAK RIDGE RD 88 OAK RIDGE RD 88.0 OAK RIDGE RD     Berkeley 94705 37.855091882666095 -122.24074430479018
16379 16379 16379 064 423101302 20 Vicente Rd 20 VICENTE RD 20 VICENTE RD 20.0 VICENTE RD     Berkeley 94705 37.85374146982336 -122.23468840213384
16488 16488 16488 064 425001801 109 Hillcrest Rd 109 HILLCREST RD 109 HILLCREST RD 109.0 HILLCREST RD     Berkeley 94705 37.85325363660898 -122.24674226611074
16703 16703 16703 064 424702100 15 Hillcrest Rd 15 HILLCREST RD 15 HILLCREST RD 15.0 HILLCREST RD     Berkeley 94705 37.85319749011292 -122.24828149790902
16724 16724 16724 064 422701000 14 Bridge Rd 14 BRIDGE RD 14 BRIDGE RD 14.0 BRIDGE RD     Berkeley 94705 37.85585598382284 -122.2387838313956
16726 16726 16726 064 422300300 287 Alvarado Rd 287 ALVARADO RD 287 ALVARADO RD 287.0 ALVARADO RD     Berkeley 94705 37.85720989712998 -122.23822758469018
16913 16913 16913 064 423401100 20 Oak Ridge Rd 20 OAK RIDGE RD 20 OAK RIDGE RD 20.0 OAK RIDGE RD     Berkeley 94705 37.85722127008448 -122.2423253971824
16990 16990 16990 064 422201000 240 Alvarado Rd 240 ALVARADO RD 240 ALVARADO RD 240.0 ALVARADO RD     Berkeley 94705 37.85702347759349 -122.2361638095295
17206 17206 17206 064 422600900 19 Alvarado Rd 19 ALVARADO RD 19 ALVARADO RD 19.0 ALVARADO RD     Berkeley 94705 37.856229036854025 -122.23991433782446
17487 17487 17487 064 424900200 1 Eucalyptus Rd 1 EUCALYPTUS RD 1 EUCALYPTUS RD 1.0 EUCALYPTUS RD     Berkeley 94705 37.85263917210205 -122.2465464351754
17610 17610 17610 064 423802500 16 Hazel Rd 16 HAZEL RD 16 HAZEL RD 16.0 HAZEL RD     Berkeley 94705 37.856181134319954 -122.24604331753088
17706 17706 17706 064 424901100 82 Hillcrest Rd 82 HILLCREST RD 82 HILLCREST RD 82.0 HILLCREST RD     Berkeley 94705 37.85200194786642 -122.246824606588

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