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

78 rows where street_name = "ALVARADO" and zipcode = 94705

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94705 · 78 ✖

street_type 1

street_name 1

  • ALVARADO · 78 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
288 288 288 064 422300600 163 Alvarado Rd 163 ALVARADO RD 163 ALVARADO RD 163.0 ALVARADO RD     Berkeley 94705 37.85669970820088 -122.23772215837536
382 382 382 064 422601200 1 Alvarado Rd 1 ALVARADO RD 1 ALVARADO RD 1.0 ALVARADO RD     Berkeley 94705 37.85580946412616 -122.23975189457332
951 951 951 064 422301300 131 Alvarado Rd 131 ALVARADO RD 131 ALVARADO RD 131.0 ALVARADO RD     Berkeley 94705 37.85710336930652 -122.23880801494138
1947 1947 1947 064 422801000 175 Alvarado Rd 175 ALVARADO RD 175 ALVARADO RD 175.0 ALVARADO RD     Berkeley 94705 37.85635263940518 -122.23719775515018
4279 4279 4279 064 422300400 281 Alvarado Rd 281 ALVARADO RD 281 ALVARADO RD 281.0 ALVARADO RD     Berkeley 94705 37.85711722184741 -122.23798016979632
5060 5060 5060 064 422702200 50 Alvarado Rd 50 ALVARADO RD 50 ALVARADO RD 50.0 ALVARADO RD     Berkeley 94705 37.857281604518825 -122.24006285988364
6735 6735 6735 064 422300500 277 Alvarado Rd 277 ALVARADO RD 277 ALVARADO RD 277.0 ALVARADO RD     Berkeley 94705 37.857033423545886 -122.23763382344022
7261 7261 7261 064 422700100 116 Alvarado Rd 116 ALVARADO RD 116 ALVARADO RD 116.0 ALVARADO RD     Berkeley 94705 37.85739051873274 -122.2397978011793
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
8474 8474 8474 064 422800100 275 Alvarado Rd 275 ALVARADO RD 275 ALVARADO RD 275.0 ALVARADO RD     Berkeley 94705 37.8570690539181 -122.23718510058276
10207 10207 10207 064 422702100 44 Alvarado Rd 44 ALVARADO RD 44 ALVARADO RD 44.0 ALVARADO RD     Berkeley 94705 37.85702554083082 -122.23993045270235
10376 10376 10376 064 422600400 41 Alvarado Rd 41 ALVARADO RD 41 ALVARADO RD 41.0 ALVARADO RD     Berkeley 94705 37.85680945807604 -122.2403652938937
11011 11011 11011 064 422901100 182 Alvarado Rd 182 ALVARADO RD 182 ALVARADO RD 182.0 ALVARADO RD     Berkeley 94705 37.85586847408831 -122.23754595652731
12086 12086 12086 064 422301200 135 Alvarado Rd 135 ALVARADO RD 135 ALVARADO RD 135.0 ALVARADO RD     Berkeley 94705 37.85699837120356 -122.23869651245504
12177 12177 12177 064 422301600 119 Alvarado Rd 119 ALVARADO RD 119 ALVARADO RD 119.0 ALVARADO RD     Berkeley 94705 37.85741779815024 -122.23914800032692
13324 13324 13324 064 422201100 244 Alvarado Rd 244 ALVARADO RD 244 ALVARADO RD 244.0 ALVARADO RD     Berkeley 94705 37.85721009926855 -122.23627110790032
13888 13888 13888 064 422700200 118 Alvarado Rd 118 ALVARADO RD 118 ALVARADO RD 118.0 ALVARADO RD     Berkeley 94705 37.85717042902767 -122.23958733758631
14853 14853 14853 064 422801300 215 Alvarado Rd 215 ALVARADO RD 215 ALVARADO RD 215.0 ALVARADO RD     Berkeley 94705 37.85612045428026 -122.23663195935328
16726 16726 16726 064 422300300 287 Alvarado Rd 287 ALVARADO RD 287 ALVARADO RD 287.0 ALVARADO RD     Berkeley 94705 37.85720989712998 -122.23822758469018
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
19935 19935 19935 064 422202100 252 Alvarado Rd 252 ALVARADO RD 252 ALVARADO RD 252.0 ALVARADO RD     Berkeley 94705 37.857568068819866 -122.23650190665636
21492 21492 21492 064 422800400 231 Alvarado Rd 231 ALVARADO RD 231 ALVARADO RD 231.0 ALVARADO RD     Berkeley 94705 37.85668357742794 -122.23675848795938
21789 21789 21789 064 422701700 12 Alvarado Rd 12 ALVARADO RD 12 ALVARADO RD 12.0 ALVARADO RD     Berkeley 94705 37.85611524541081 -122.23924446232046
22925 22925 22925 064 422900210 216 Alvarado Rd 216 ALVARADO RD 216 ALVARADO RD 216.0 ALVARADO RD     Berkeley 94705 37.856242554784934 -122.23589436794488
23750 23750 23750 064 422202300 264 Alvarado Rd 264 ALVARADO RD 264 ALVARADO RD 264.0 ALVARADO RD     Berkeley 94705 37.85753369548888 -122.23707790551822
23842 23842 23842 064 422300100 601 Alvarado Rd 601 ALVARADO RD 601 ALVARADO RD 601.0 ALVARADO RD     Berkeley 94705 37.85751563714266 -122.23850263894872
24458 24458 24458 064 422301700 115 Alvarado Rd 115 ALVARADO RD 115 ALVARADO RD 115.0 ALVARADO RD     Berkeley 94705 37.85752721218776 -122.23926213577536
24835 24835 24835 064 422300900 151 Alvarado Rd 151 ALVARADO RD 151 ALVARADO RD 151.0 ALVARADO RD     Berkeley 94705 37.85669373265883 -122.23833589456402
25289 25289 25289 064 422600300 45 Alvarado Rd 45 ALVARADO RD 45 ALVARADO RD 45.0 ALVARADO RD     Berkeley 94705 37.856924210205506 -122.24046153849493
25397 25397 25397 064 422301400 127 Alvarado Rd 127 ALVARADO RD 127 ALVARADO RD 127.0 ALVARADO RD     Berkeley 94705 37.857209966637235 -122.23891870624898
25529 25529 25529 048H760704000 266 Alvarado Rd 266 ALVARADO RD 266 ALVARADO RD 266.0 ALVARADO RD     Berkeley 94705 37.85762852921763 -122.23690016844938
26537 26537 26537 064 422600100 55 Alvarado Rd 55 ALVARADO RD 55 ALVARADO RD 55.0 ALVARADO RD     Berkeley 94705 37.85726245314473 -122.24073084982386
26725 26725 26725 064 422701800 18 Alvarado Rd 18 ALVARADO RD 18 ALVARADO RD 18.0 ALVARADO RD     Berkeley 94705 37.856316251189746 -122.2393777408676
27257 27257 27257 064 422300800 155 Alvarado Rd 155 ALVARADO RD 155 ALVARADO RD 155.0 ALVARADO RD     Berkeley 94705 37.856663964877235 -122.23814984089226
27963 27963 27963 064 422901603 186 Alvarado Rd 186 ALVARADO RD 186 ALVARADO RD 186.0 ALVARADO RD     Berkeley 94705 37.855420651710425 -122.23765918916892
28564 28564 28564 064 422600800 23 Alvarado Rd 23 ALVARADO RD 23 ALVARADO RD 23.0 ALVARADO RD     Berkeley 94705 37.85635561194086 -122.2399813440598
29726 29726 29726 064 422202500 270 Alvarado Rd 270 ALVARADO RD 270 ALVARADO RD 270.0 ALVARADO RD     Berkeley 94705 37.85747990485352 -122.23728247077302
30602 30602 30602 064 422600100 59 Alvarado Rd 59 ALVARADO RD 59 ALVARADO RD 59.0 ALVARADO RD     Berkeley 94705 37.857327348068544 -122.24096828353662
31031 31031 31031 064 422900209 214 Alvarado Rd 214 ALVARADO RD 214 ALVARADO RD 214.0 ALVARADO RD     Berkeley 94705 37.85603424403858 -122.2359220522253
31124 31124 31124 064 422301000 145 Alvarado Rd 145 ALVARADO RD 145 ALVARADO RD 145.0 ALVARADO RD     Berkeley 94705 37.85676786906458 -122.23847658421222
31933 31933 31933 064 422901000 176 Alvarado Rd 176 ALVARADO RD 176 ALVARADO RD 176.0 ALVARADO RD     Berkeley 94705 37.85597602930088 -122.23765305637046
32061 32061 32061 048H760704200 290 Alvarado Rd 290 ALVARADO RD 290 ALVARADO RD 290.0 ALVARADO RD     Berkeley 94705 37.857552372301015 -122.23784685441828
32322 32322 32322 064 422700500 142 Alvarado Rd 142 ALVARADO RD 142 ALVARADO RD 142.0 ALVARADO RD     Berkeley 94705 37.8565320396269 -122.23902402742785
32424 32424 32424 064 422801401 225 Alvarado Rd 225 ALVARADO RD 225 ALVARADO RD 225.0 ALVARADO RD     Berkeley 94705 37.85648423020345 -122.23665645281784
33203 33203 33203 064 422801100 171 Alvarado Rd 171 ALVARADO RD 171 ALVARADO RD 171.0 ALVARADO RD     Berkeley 94705 37.85661741873837 -122.23727189760214
33376 33376 33376 064 422701500 6 Alvarado Rd 6 ALVARADO RD 6 ALVARADO RD 6.0 ALVARADO RD     Berkeley 94705 37.85569773956536 -122.23937322054508
33827 33827 33827 064 422600700 27 Alvarado Rd 27 ALVARADO RD 27 ALVARADO RD 27.0 ALVARADO RD     Berkeley 94705 37.856476947468074 -122.24006218614716
34834 34834 34834 064 422201600 278 Alvarado Rd 278 ALVARADO RD 278 ALVARADO RD 278.0 ALVARADO RD     Berkeley 94705 37.85740401020815 -122.23756563861522
37408 37408 37408 064 422900900 172 Alvarado Rd 172 ALVARADO RD 172 ALVARADO RD 172.0 ALVARADO RD     Berkeley 94705 37.85609465391773 -122.2377726302196
40141 40141 40141 064 422200801 220 Alvarado Rd 220 ALVARADO RD 220 ALVARADO RD 220.0 ALVARADO RD     Berkeley 94705 37.85682329435907 -122.23600279639628
40769 40769 40769 064 422900800 160 Alvarado Rd 160 ALVARADO RD 160 ALVARADO RD 160.0 ALVARADO RD     Berkeley 94705 37.85624879137396 -122.23787766303928
41166 41166 41166 064 422700300 128 Alvarado Rd 128 ALVARADO RD 128 ALVARADO RD 128.0 ALVARADO RD     Berkeley 94705 37.85696516221272 -122.23938685607276
41219 41219 41219 064 422600600 31 Alvarado Rd 31 ALVARADO RD 31 ALVARADO RD 31.0 ALVARADO RD     Berkeley 94705 37.856590973828624 -122.2401600234614
41318 41318 41318 064 422800900 179 Alvarado Rd 179 ALVARADO RD 179 ALVARADO RD 179.0 ALVARADO RD     Berkeley 94705 37.85622697643147 -122.23708547831606
41589 41589 41589 048H766303800 111 Alvarado Rd 111 ALVARADO RD 111 ALVARADO RD 111.0 ALVARADO RD     Berkeley 94705 37.85746929864427 -122.2394943619544
43166 43166 43166 064 422601000 15 Alvarado Rd 15 ALVARADO RD 15 ALVARADO RD 15.0 ALVARADO RD     Berkeley 94705 37.85611507660485 -122.23982153736404
44376 44376 44376 064 422300100 617 Alvarado Rd 617 ALVARADO RD 617 ALVARADO RD 617.0 ALVARADO RD     Berkeley 94705 37.857515232867186 -122.23877490034502
44664 44664 44664 064 422702000 34 Alvarado Rd 34 ALVARADO RD 34 ALVARADO RD 34.0 ALVARADO RD     Berkeley 94705 37.856795514691754 -122.23973431454318
44701 44701 44701 064 422800200 255 Alvarado Rd 255 ALVARADO RD 255 ALVARADO RD 255.0 ALVARADO RD     Berkeley 94705 37.85722368581758 -122.2369103858874
44991 44991 44991 064 422301500 123 Alvarado Rd 123 ALVARADO RD 123 ALVARADO RD 123.0 ALVARADO RD     Berkeley 94705 37.85731398282686 -122.2390312148484
45321 45321 45321 064 422800300 245 Alvarado Rd 245 ALVARADO RD 245 ALVARADO RD 245.0 ALVARADO RD     Berkeley 94705 37.856890089071285 -122.23685003886328
46403 46403 46403 064 422900201 190 Alvarado Rd 190 ALVARADO RD 190 ALVARADO RD 190.0 ALVARADO RD     Berkeley 94705 37.85551083389806 -122.23683101883374
47119 47119 47119 064 422300700 159 Alvarado Rd 159 ALVARADO RD 159 ALVARADO RD 159.0 ALVARADO RD     Berkeley 94705 37.856674398851354 -122.2379505209004
47150 47150 47150 064 422801200 207 Alvarado Rd 207 ALVARADO RD 207 ALVARADO RD 207.0 ALVARADO RD     Berkeley 94705 37.85604645624023 -122.23705204122456
48073 48073 48073 064 422301100 139 Alvarado Rd 139 ALVARADO RD 139 ALVARADO RD 139.0 ALVARADO RD     Berkeley 94705 37.85689623482008 -122.23858227190372
48904 48904 48904 064 422900700 150 Alvarado Rd 150 ALVARADO RD 150 ALVARADO RD 150.0 ALVARADO RD     Berkeley 94705 37.85627744861082 -122.2383627604792
49025 49025 49025 048H760703800 256 Alvarado Rd 256 ALVARADO RD 256 ALVARADO RD 256.0 ALVARADO RD     Berkeley 94705 37.85760018245018 -122.2363126594738
49170 49170 49170 064 422200801 218 Alvarado Rd 218 ALVARADO RD 218 ALVARADO RD 218.0 ALVARADO RD     Berkeley 94705 37.85682329435907 -122.23600279639628
49830 49830 49830 064 422601100 11 Alvarado Rd 11 ALVARADO RD 11 ALVARADO RD 11.0 ALVARADO RD     Berkeley 94705 37.856006400948885 -122.2397073022026
50327 50327 50327 064 422600200 47 Alvarado Rd 47 ALVARADO RD 47 ALVARADO RD 47.0 ALVARADO RD     Berkeley 94705 37.85706473310874 -122.2405903865511
51176 51176 51176 064 422900208 210 Alvarado Rd 210 ALVARADO RD 210 ALVARADO RD 210.0 ALVARADO RD     Berkeley 94705 37.855860814669064 -122.23607567941023
51861 51861 51861 064 422300200 291 Alvarado Rd 291 ALVARADO RD 291 ALVARADO RD 291.0 ALVARADO RD     Berkeley 94705 37.85736403863754 -122.23838659098706
51897 51897 51897 064 422700400 136 Alvarado Rd 136 ALVARADO RD 136 ALVARADO RD 136.0 ALVARADO RD     Berkeley 94705 37.85673791193973 -122.23917390863804
53298 53298 53298 064 422300200 291 Alvarado Rd 1 291 ALVARADO RD 1 291 ALVARADO RD 291.0 ALVARADO RD 1   Berkeley 94705 37.85736403863754 -122.23838659098706
54025 54025 54025 064 422701900 26 Alvarado Rd 26 ALVARADO RD 26 ALVARADO RD 26.0 ALVARADO RD     Berkeley 94705 37.85656479275578 -122.23953336141416
56868 56868 56868 064 422202800 284 Alvarado Rd 284 ALVARADO RD 284 ALVARADO RD 284.0 ALVARADO RD     Berkeley 94705 37.85750792895597 -122.2376925094794

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