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

135 rows where street_name = "OXFORD" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, base_address, street_number

zipcode 1

  • 94704 · 135 ✖

street_type 1

street_name 1

  • OXFORD · 135 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
181 181 181 057 203100200 2150 Oxford St 6 2150 OXFORD ST 6 2150 OXFORD ST 2150.0 OXFORD ST 6   Berkeley 94704 37.86988481392904 -122.26611805362673
330 330 330 057 203100200 2150 Oxford St 30 2150 OXFORD ST 30 2150 OXFORD ST 2150.0 OXFORD ST 30   Berkeley 94704 37.86988481392904 -122.26611805362673
434 434 434 057 203100101 2132 Oxford St 2132 OXFORD ST 2132 OXFORD ST 2132.0 OXFORD ST     Berkeley 94704 37.87025993966203 -122.26617633093244
730 730 730 057 203100200 2150 Oxford St 25 2150 OXFORD ST 25 2150 OXFORD ST 2150.0 OXFORD ST 25   Berkeley 94704 37.86988481392904 -122.26611805362673
1009 1009 1009 057 203100200 2150 Oxford St 29 2150 OXFORD ST 29 2150 OXFORD ST 2150.0 OXFORD ST 29   Berkeley 94704 37.86988481392904 -122.26611805362673
1157 1157 1157 057 204700201 1910 Oxford St Apt 510 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 510 APT Berkeley 94704 37.87352526988026 -122.26649264391368
1213 1213 1213 057 204700201 1910 Oxford St Apt 202 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 202 APT Berkeley 94704 37.87363676319564 -122.2666578378062
1669 1669 1669 057 203100200 2150 Oxford St 9 2150 OXFORD ST 9 2150 OXFORD ST 2150.0 OXFORD ST 9   Berkeley 94704 37.86988481392904 -122.26611805362673
1678 1678 1678 057 204700201 1910 Oxford St Apt 509 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 509 APT Berkeley 94704 37.87354220888777 -122.26649576915256
1905 1905 1905 057 204700201 1910 Oxford St Apt 209 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 209 APT Berkeley 94704 37.87352402753494 -122.26663520475265
2268 2268 2268 057 204700201 1910 Oxford St Apt 211 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 211 APT Berkeley 94704 37.87348954677139 -122.26662890486756
2937 2937 2937 057 204700201 1910 Oxford St Apt 513 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 513 APT Berkeley 94704 37.8734742358493 -122.26648286754846
3955 3955 3955 057 204700201 1910 Oxford St Apt 410 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 410 APT Berkeley 94704 37.873518612837906 -122.26653910837344
4777 4777 4777 057 203100200 2150 Oxford St 37 2150 OXFORD ST 37 2150 OXFORD ST 2150.0 OXFORD ST 37   Berkeley 94704 37.86988481392904 -122.26611805362673
5248 5248 5248 057 204700201 1910 Oxford St Apt 302 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 302 APT Berkeley 94704 37.87364222823011 -122.2666113454987
5689 5689 5689 057 203100200 2150 Oxford St 53 2150 OXFORD ST 53 2150 OXFORD ST 2150.0 OXFORD ST 53   Berkeley 94704 37.86988481392904 -122.26611805362673
6567 6567 6567 057 203100200 2150 Oxford St 11 2150 OXFORD ST 11 2150 OXFORD ST 2150.0 OXFORD ST 11   Berkeley 94704 37.86988481392904 -122.26611805362673
7587 7587 7587 057 204700201 1920 Oxford St 1920 OXFORD ST 1920 OXFORD ST 1920.0 OXFORD ST     Berkeley 94704 37.873540382952584 -122.2664325780622
7590 7590 7590 057 204700201 1910 Oxford St Apt 408 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 408 APT Berkeley 94704 37.87355231357682 -122.26654566338009
8522 8522 8522 057 203100200 2150 Oxford St 35 2150 OXFORD ST 35 2150 OXFORD ST 2150.0 OXFORD ST 35   Berkeley 94704 37.86988481392904 -122.26611805362673
9242 9242 9242 057 203100200 2150 Oxford St 2 2150 OXFORD ST 2 2150 OXFORD ST 2150.0 OXFORD ST 2   Berkeley 94704 37.86988481392904 -122.26611805362673
9540 9540 9540 057 204700201 1910 Oxford St Apt 508 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 508 APT Berkeley 94704 37.87355896990707 -122.26649919981864
9612 9612 9612 057 203100200 2150 Oxford St 3 2150 OXFORD ST 3 2150 OXFORD ST 2150.0 OXFORD ST 3   Berkeley 94704 37.86988481392904 -122.26611805362673
9792 9792 9792 057 204700105 1900 Oxford St 1900 OXFORD ST 1900 OXFORD ST 1900.0 OXFORD ST     Berkeley 94704 37.87386411523631 -122.26663110843494
10203 10203 10203 057 203100200 2140 Oxford St 2140 OXFORD ST 2140 OXFORD ST 2140.0 OXFORD ST     Berkeley 94704 37.86988481392904 -122.26611805362673
10612 10612 10612 057 204700201 1910 Oxford St Apt 303 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 303 APT Berkeley 94704 37.8736270336322 -122.26660806305463
11320 11320 11320 057 204700201 1910 Oxford St Apt 401 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 401 APT Berkeley 94704 37.87366468471692 -122.26656818953413
11774 11774 11774 057 204700201 1910 Oxford St Apt 414 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 414 APT Berkeley 94704 37.873450056186776 -122.2665258761893
12081 12081 12081 057 204700201 1910 Oxford St Apt 409 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 409 APT Berkeley 94704 37.873535552556056 -122.26654223361233
12130 12130 12130 057 203100200 2150 Oxford St 7 2150 OXFORD ST 7 2150 OXFORD ST 2150.0 OXFORD ST 7   Berkeley 94704 37.86988481392904 -122.26611805362673
12847 12847 12847 057 203100200 2150 Oxford St 41 2150 OXFORD ST 41 2150 OXFORD ST 2150.0 OXFORD ST 41   Berkeley 94704 37.86988481392904 -122.26611805362673
13975 13975 13975 057 203100200 2150 Oxford St 15 2150 OXFORD ST 15 2150 OXFORD ST 2150.0 OXFORD ST 15   Berkeley 94704 37.86988481392904 -122.26611805362673
14840 14840 14840 057 204700201 1910 Oxford St Apt 311 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 311 APT Berkeley 94704 37.87349501110767 -122.26658241256004
15422 15422 15422 057 204700201 1910 Oxford St Apt 404 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 404 APT Berkeley 94704 37.87361676515119 -122.26655856049258
15799 15799 15799 057 204700201 1910 Oxford St Apt 512 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 512 APT Berkeley 94704 37.8734911720321 -122.26648620568804
15891 15891 15891 057 204700201 1910 Oxford St Apt 306 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 306 APT Berkeley 94704 37.87357856803441 -122.26659846545417
15935 15935 15935 057 203100200 2150 Oxford St 20 2150 OXFORD ST 20 2150 OXFORD ST 2150.0 OXFORD ST 20   Berkeley 94704 37.86988481392904 -122.26611805362673
15985 15985 15985 057 204700201 1910 Oxford St Apt 310 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 310 APT Berkeley 94704 37.87351255285828 -122.26658558720622
16165 16165 16165 057 203100200 2150 Oxford St 38 2150 OXFORD ST 38 2150 OXFORD ST 2150.0 OXFORD ST 38   Berkeley 94704 37.86988481392904 -122.26611805362673
16503 16503 16503 057 203100200 2150 Oxford St 2150 OXFORD ST 2150 OXFORD ST 2150.0 OXFORD ST     Berkeley 94704 37.86988481392904 -122.26611805362673
16624 16624 16624 057 204700201 1910 Oxford St Apt 402 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 402 APT Berkeley 94704 37.87364828819912 -122.26656486666587
16815 16815 16815 057 203100200 2150 Oxford St 49 2150 OXFORD ST 49 2150 OXFORD ST 2150.0 OXFORD ST 49   Berkeley 94704 37.86988481392904 -122.26611805362673
17061 17061 17061 057 204700201 1910 Oxford St Apt 505 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 505 APT Berkeley 94704 37.87360752060977 -122.26650871657074
17184 17184 17184 057 203500302 2200 Oxford St 2200 OXFORD ST 2200 OXFORD ST 2200.0 OXFORD ST     Berkeley 94704 37.86948410406166 -122.2662328035228
17428 17428 17428 057 204700201 1910 Oxford St Apt 304 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 304 APT Berkeley 94704 37.873610705179594 -122.2666050393254
18829 18829 18829 057 203100200 2150 Oxford St 1A 2150 OXFORD ST 1A 2150 OXFORD ST 2150.0 OXFORD ST 1A   Berkeley 94704 37.86988481392904 -122.26611805362673
18885 18885 18885 057 204500300 1990 Oxford St 1990 OXFORD ST 1990 OXFORD ST 1990.0 OXFORD ST     Berkeley 94704 37.87271592356259 -122.26637601653866
18926 18926 18926 057 204700201 1910 Oxford St Apt 212 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 212 APT Berkeley 94704 37.87347299066672 -122.2666256412881
19177 19177 19177 057 204700201 1910 Oxford St Apt 301 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 301 APT Berkeley 94704 37.87365862474931 -122.26661466836694
19592 19592 19592 057 204700201 1910 Oxford St Apt 405 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 405 APT Berkeley 94704 37.8736008642839 -122.2665551801322
20044 20044 20044 057 204700201 1910 Oxford St Apt 501 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 501 APT Berkeley 94704 37.873671341746075 -122.26652172507436
20115 20115 20115 057 204700201 1910 Oxford St Apt 305 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 305 APT Berkeley 94704 37.873594803601925 -122.266601658965
20846 20846 20846 057 203100200 2150 Oxford St 5 2150 OXFORD ST 5 2150 OXFORD ST 2150.0 OXFORD ST 5   Berkeley 94704 37.86988481392904 -122.26611805362673
20847 20847 20847 057 203100200 2150 Oxford St 26 2150 OXFORD ST 26 2150 OXFORD ST 2150.0 OXFORD ST 26   Berkeley 94704 37.86988481392904 -122.26611805362673
21130 21130 21130 057 203100200 2150 Oxford St 19 2150 OXFORD ST 19 2150 OXFORD ST 2150.0 OXFORD ST 19   Berkeley 94704 37.86988481392904 -122.26611805362673
21294 21294 21294 057 204700201 1916 Oxford St 1916 OXFORD ST 1916 OXFORD ST 1916.0 OXFORD ST     Berkeley 94704 37.87360457997031 -122.26644463435164
21533 21533 21533 057 203100200 2150 Oxford St 28 2150 OXFORD ST 28 2150 OXFORD ST 2150.0 OXFORD ST 28   Berkeley 94704 37.86988481392904 -122.26611805362673
21637 21637 21637 057 203100200 2150 Oxford St 56 2150 OXFORD ST 56 2150 OXFORD ST 2150.0 OXFORD ST 56   Berkeley 94704 37.86988481392904 -122.26611805362673
21679 21679 21679 057 203100101 2130 Oxford St 2130 OXFORD ST 2130 OXFORD ST 2130.0 OXFORD ST     Berkeley 94704 37.87025993966203 -122.26617633093244
22509 22509 22509 057 204700201 1910 Oxford St Apt 309 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 309 APT Berkeley 94704 37.87352949257778 -122.26658871244511
23168 23168 23168 057 203500302 2240 Oxford St 2240 OXFORD ST 2240 OXFORD ST 2240.0 OXFORD ST     Berkeley 94704 37.86937363626227 -122.2662058082502
23784 23784 23784 057 204700201 1910 Oxford St Apt 204 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 204 APT Berkeley 94704 37.87360524014279 -122.26665153163292
25323 25323 25323 057 203500302 2242 Oxford St 2242 OXFORD ST 2242 OXFORD ST 2242.0 OXFORD ST     Berkeley 94704 37.86933608510088 -122.2661976955649
25671 25671 25671 057 204700201 1910 Oxford St Apt 201 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 201 APT Berkeley 94704 37.873653159716056 -122.26666116067447
25729 25729 25729 057 203100200 2150 Oxford St 13 2150 OXFORD ST 13 2150 OXFORD ST 2150.0 OXFORD ST 13   Berkeley 94704 37.86988481392904 -122.26611805362673
25765 25765 25765 057 203100200 2150 Oxford St 48 2150 OXFORD ST 48 2150 OXFORD ST 2150.0 OXFORD ST 48   Berkeley 94704 37.86988481392904 -122.26611805362673
26294 26294 26294 057 203100200 2150 Oxford St 39 2150 OXFORD ST 39 2150 OXFORD ST 2150.0 OXFORD ST 39   Berkeley 94704 37.86988481392904 -122.26611805362673
26471 26471 26471 057 203100200 2150 Oxford St 52 2150 OXFORD ST 52 2150 OXFORD ST 2150.0 OXFORD ST 52   Berkeley 94704 37.86988481392904 -122.26611805362673
26637 26637 26637 057 204700201 1910 Oxford St Apt 407 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 407 APT Berkeley 94704 37.87356858105968 -122.2665486978891
27026 27026 27026 057 203100200 2150 Oxford St 34 2150 OXFORD ST 34 2150 OXFORD ST 2150.0 OXFORD ST 34   Berkeley 94704 37.86988481392904 -122.26611805362673
27084 27084 27084 057 204700201 1910 Oxford St Apt 406 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 406 APT Berkeley 94704 37.87358462871772 -122.26655198662137
28460 28460 28460 057 203500302 2220 Oxford St 2220 OXFORD ST 2220 OXFORD ST 2220.0 OXFORD ST     Berkeley 94704 37.86944608066907 -122.26622437822375
28658 28658 28658 057 204700201 1910 Oxford St Apt 308 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 308 APT Berkeley 94704 37.873546252890854 -122.26659214221286
28847 28847 28847 057 203100200 2150 Oxford St 22 2150 OXFORD ST 22 2150 OXFORD ST 2150.0 OXFORD ST 22   Berkeley 94704 37.86988481392904 -122.26611805362673
29250 29250 29250 057 204700201 1910 Oxford St Apt 213 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 213 APT Berkeley 94704 37.873456054479696 -122.26662230225024
29683 29683 29683 057 203100200 2150 Oxford St 43 2150 OXFORD ST 43 2150 OXFORD ST 2150.0 OXFORD ST 43   Berkeley 94704 37.86988481392904 -122.26611805362673
29814 29814 29814 057 203100200 2150 Oxford St 12 2150 OXFORD ST 12 2150 OXFORD ST 2150.0 OXFORD ST 12   Berkeley 94704 37.86988481392904 -122.26611805362673
30282 30282 30282 057 204700201 1910 Oxford St 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST     Berkeley 94704 37.87368124219672 -122.26656376892464
32227 32227 32227 057 204700201 1910 Oxford St Apt 214 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 214 APT Berkeley 94704 37.87343853115234 -122.26661884732962
32420 32420 32420 057 203100200 2150 Oxford St 16 2150 OXFORD ST 16 2150 OXFORD ST 2150.0 OXFORD ST 16   Berkeley 94704 37.86988481392904 -122.26611805362673
32421 32421 32421 057 204700201 1910 Oxford St Apt 511 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 511 APT Berkeley 94704 37.87350772813273 -122.26648946926748
32433 32433 32433 057 204700201 1910 Oxford St Apt 203 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 203 APT Berkeley 94704 37.87362156930566 -122.26665455536218
32492 32492 32492 057 203100200 2150 Oxford St 23 2150 OXFORD ST 23 2150 OXFORD ST 2150.0 OXFORD ST 23   Berkeley 94704 37.86988481392904 -122.26611805362673
32814 32814 32814 057 203500302 2230 Oxford St 2230 OXFORD ST 2230 OXFORD ST 2230.0 OXFORD ST     Berkeley 94704 37.869410207371864 -122.26621570319304
33233 33233 33233 057 203100200 2150 Oxford St 24 2150 OXFORD ST 24 2150 OXFORD ST 2150.0 OXFORD ST 24   Berkeley 94704 37.86988481392904 -122.26611805362673
33427 33427 33427 057 203100200 2142 Oxford St 2142 OXFORD ST 2142 OXFORD ST 2142.0 OXFORD ST     Berkeley 94704 37.86988481392904 -122.26611805362673
34140 34140 34140 057 203100101 2134 Oxford St 2134 OXFORD ST 2134 OXFORD ST 2134.0 OXFORD ST     Berkeley 94704 37.87025993966203 -122.26617633093244
34303 34303 34303 057 204700201 1910 Oxford St Apt 307 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 307 APT Berkeley 94704 37.87356252108416 -122.26659517582358
34817 34817 34817 057 204700201 1910 Oxford St Apt 206 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 206 APT Berkeley 94704 37.87357310370433 -122.26664495776168
35033 35033 35033 057 203100200 2150 Oxford St 31 2150 OXFORD ST 31 2150 OXFORD ST 2150.0 OXFORD ST 31   Berkeley 94704 37.86988481392904 -122.26611805362673
35502 35502 35502 057 203100200 2150 Oxford St 10 2150 OXFORD ST 10 2150 OXFORD ST 2150.0 OXFORD ST 10   Berkeley 94704 37.86988481392904 -122.26611805362673
36194 36194 36194 057 204700201 1910 Oxford St Apt 411 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 411 APT Berkeley 94704 37.873501071797904 -122.26653593372724
36418 36418 36418 057 203100200 2150 Oxford St 1 2150 OXFORD ST 1 2150 OXFORD ST 2150.0 OXFORD ST 1   Berkeley 94704 37.86988481392904 -122.26611805362673
37442 37442 37442 057 204700201 1910 Oxford St Apt 313 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 313 APT Berkeley 94704 37.87346151881845 -122.2665758099427
39359 39359 39359 057 203100200 2150 Oxford St 55 2150 OXFORD ST 55 2150 OXFORD ST 2150.0 OXFORD ST 55   Berkeley 94704 37.86988481392904 -122.26611805362673
39493 39493 39493 057 204700201 1910 Oxford St Apt 506 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 506 APT Berkeley 94704 37.87359128504505 -122.26650552305992
39551 39551 39551 057 204700201 1910 Oxford St Apt 503 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 503 APT Berkeley 94704 37.87363975063442 -122.26651512066042
39769 39769 39769 057 204700201 1910 Oxford St Apt 314 1910 OXFORD ST 1910 OXFORD ST 1910.0 OXFORD ST 314 APT Berkeley 94704 37.87344399620151 -122.26657235502208
41201 41201 41201 057 203100200 2150 Oxford St 51 2150 OXFORD ST 51 2150 OXFORD ST 2150.0 OXFORD ST 51   Berkeley 94704 37.86988481392904 -122.26611805362673
41274 41274 41274 057 203100200 2150 Oxford St 21 2150 OXFORD ST 21 2150 OXFORD ST 2150.0 OXFORD ST 21   Berkeley 94704 37.86988481392904 -122.26611805362673

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