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

138 rows where street_name = "OXFORD" and zipcode = 94707

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94707 · 138 ✖

street_type 1

street_name 1

  • OXFORD · 138 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
485 485 485 061 258803900 1019 Oxford St 1019 OXFORD ST 1019 OXFORD ST 1019.0 OXFORD ST     Berkeley 94707 37.89002782944345 -122.2678847406516
577 577 577 061 258402000 814 Oxford St 814 OXFORD ST 814 OXFORD ST 814.0 OXFORD ST     Berkeley 94707 37.89244302234366 -122.27196616338144
997 997 997 061 258301200 843 Oxford St 843 OXFORD ST 843 OXFORD ST 843.0 OXFORD ST     Berkeley 94707 37.89203636184776 -122.2702095392844
1541 1541 1541 061 255703900 1133 Oxford St 1133 OXFORD ST 1133 OXFORD ST 1133.0 OXFORD ST     Berkeley 94707 37.8878949569058 -122.2678214453567
1707 1707 1707 061 255801900 1156 Oxford St 1156 OXFORD ST 1156 OXFORD ST 1156.0 OXFORD ST     Berkeley 94707 37.88708877876863 -122.26818694559128
1745 1745 1745 061 255800900 1106 Oxford St A 1106 OXFORD ST A 1106 OXFORD ST 1106.0 OXFORD ST A   Berkeley 94707 37.88862199544134 -122.26815518745104
1800 1800 1800 061 255802300 1170 Oxford St 1170 OXFORD ST 1170 OXFORD ST 1170.0 OXFORD ST     Berkeley 94707 37.88665098456124 -122.26813837727714
1989 1989 1989 061 258403000 844 Oxford St 844 OXFORD ST 844 OXFORD ST 844.0 OXFORD ST     Berkeley 94707 37.89183893858327 -122.2706498880468
2115 2115 2115 061 258301100 845 Oxford St 845 OXFORD ST 845 OXFORD ST 845.0 OXFORD ST     Berkeley 94707 37.891925973949064 -122.2701349180304
2381 2381 2381 061 258805400 915 Oxford St 915 OXFORD ST 915 OXFORD ST 915.0 OXFORD ST     Berkeley 94707 37.89157620488004 -122.26923038370956
2765 2765 2765 061 258804900 935 Oxford St 935 OXFORD ST 935 OXFORD ST 935.0 OXFORD ST     Berkeley 94707 37.89129817082039 -122.2684906165815
4061 4061 4061 061 258700702 910 Oxford St 910 OXFORD ST 910 OXFORD ST 910.0 OXFORD ST     Berkeley 94707 37.89118607258184 -122.26975642905508
4091 4091 4091 061 258805000 933 Oxford St 933 OXFORD ST 933 OXFORD ST 933.0 OXFORD ST     Berkeley 94707 37.891422522725286 -122.26859836590658
4486 4486 4486 061 255703400 1147 Oxford St 1147 OXFORD ST 1147 OXFORD ST 1147.0 OXFORD ST     Berkeley 94707 37.887243690105215 -122.26753410484
6418 6418 6418 061 258302300 821 Oxford St 821 OXFORD ST 821 OXFORD ST 821.0 OXFORD ST     Berkeley 94707 37.89279554993896 -122.27148589348784
6837 6837 6837 061 258803200 1053 Oxford St 1053 OXFORD ST 1053 OXFORD ST 1053.0 OXFORD ST     Berkeley 94707 37.888970993025694 -122.2674555103375
7848 7848 7848 061 258701500 976 Oxford St 976 OXFORD ST 976 OXFORD ST 976.0 OXFORD ST     Berkeley 94707 37.890608309131814 -122.26858393447154
8004 8004 8004 061 258804200 1005 Oxford St 1005 OXFORD ST 1005 OXFORD ST 1005.0 OXFORD ST     Berkeley 94707 37.89044276796409 -122.26795420198265
8044 8044 8044 061 255703100 1161 Oxford St 1161 OXFORD ST 1161 OXFORD ST 1161.0 OXFORD ST     Berkeley 94707 37.88680788903396 -122.26748195224788
8341 8341 8341 061 255802700 1192 Oxford St 1192 OXFORD ST 1192 OXFORD ST 1192.0 OXFORD ST     Berkeley 94707 37.88616164920945 -122.2679837826066
8782 8782 8782 061 255806000 1124 Oxford St 1124 OXFORD ST 1124 OXFORD ST 1124.0 OXFORD ST     Berkeley 94707 37.88809091823411 -122.2686501528844
9039 9039 9039 061 258804100 1009 Oxford St 1009 OXFORD ST 1009 OXFORD ST 1009.0 OXFORD ST     Berkeley 94707 37.89030832194054 -122.26792141437306
9870 9870 9870 061 258302800 807 Oxford St 807 OXFORD ST 807 OXFORD ST 807.0 OXFORD ST     Berkeley 94707 37.892927193335346 -122.27220020775064
10033 10033 10033 061 258301500 837 Oxford St 837 OXFORD ST 837 OXFORD ST 837.0 OXFORD ST     Berkeley 94707 37.89247041709817 -122.27023887466834
11643 11643 11643 061 258301800 831 Oxford St A 831 OXFORD ST A 831 OXFORD ST 831.0 OXFORD ST A   Berkeley 94707 37.8926758990541 -122.2706965258814
13631 13631 13631 061 258402700 832 Oxford St 832 OXFORD ST 832 OXFORD ST 832.0 OXFORD ST     Berkeley 94707 37.892279503598374 -122.2708043353936
14100 14100 14100 061 258402200 818 Oxford St 818 OXFORD ST 818 OXFORD ST 818.0 OXFORD ST     Berkeley 94707 37.89238604366031 -122.27164419999713
14201 14201 14201 061 258700901 916 Oxford St 916 OXFORD ST 916 OXFORD ST 916.0 OXFORD ST     Berkeley 94707 37.8911537318435 -122.26927518089614
14420 14420 14420 061 258701400 946 Oxford St 946 OXFORD ST 946 OXFORD ST 946.0 OXFORD ST     Berkeley 94707 37.890731174855134 -122.26866153184407
14742 14742 14742 061 258702600 1042 Oxford St 1042 OXFORD ST 1042 OXFORD ST 1042.0 OXFORD ST     Berkeley 94707 37.88913603911009 -122.26799157369508
15306 15306 15306 061 255801000 1110 Oxford St 1110 OXFORD ST 1110 OXFORD ST 1110.0 OXFORD ST     Berkeley 94707 37.88854280999161 -122.26836763901574
15396 15396 15396 061 255801800 1150 Oxford St 1150 OXFORD ST 1150 OXFORD ST 1150.0 OXFORD ST     Berkeley 94707 37.88721691517207 -122.26819559097758
15429 15429 15429 061 255703700 1139 Oxford St 3 1139 OXFORD ST 3 1139 OXFORD ST 1139.0 OXFORD ST 3   Berkeley 94707 37.88773076588641 -122.26762608603693
16587 16587 16587 061 258804602 963 Oxford St 963 OXFORD ST 963 OXFORD ST 963.0 OXFORD ST     Berkeley 94707 37.891017426878655 -122.26824059926828
16707 16707 16707 061 255703400 1147 Oxford St A 1147 OXFORD ST A 1147 OXFORD ST 1147.0 OXFORD ST A   Berkeley 94707 37.887243690105215 -122.26753410484
16903 16903 16903 061 258700500 900 Oxford St 900 OXFORD ST 900 OXFORD ST 900.0 OXFORD ST     Berkeley 94707 37.891347211043346 -122.27012044437453
17141 17141 17141 061 258301600 835 Oxford St 835 OXFORD ST 835 OXFORD ST 835.0 OXFORD ST     Berkeley 94707 37.8926052299373 -122.27035089907582
17671 17671 17671 061 255703400 1149 Oxford St 1149 OXFORD ST 1149 OXFORD ST 1149.0 OXFORD ST     Berkeley 94707 37.887243690105215 -122.26753410484
17780 17780 17780 061 258701102 928 Oxford St 928 OXFORD ST 928 OXFORD ST 928.0 OXFORD ST     Berkeley 94707 37.891042566340275 -122.26891851559236
19402 19402 19402 061 258803500 1035 Oxford St 1035 OXFORD ST 1035 OXFORD ST 1035.0 OXFORD ST     Berkeley 94707 37.88945357257672 -122.26762216309405
19509 19509 19509 061 258301800 831 Oxford St 831 OXFORD ST 831 OXFORD ST 831.0 OXFORD ST     Berkeley 94707 37.8926758990541 -122.2706965258814
20204 20204 20204 061 258702400 1032 Oxford St 1032 OXFORD ST 1032 OXFORD ST 1032.0 OXFORD ST     Berkeley 94707 37.88941708302155 -122.26813864946666
20261 20261 20261 061 255703700 1139 Oxford St 6 1139 OXFORD ST 6 1139 OXFORD ST 1139.0 OXFORD ST 6   Berkeley 94707 37.88773076588641 -122.26762608603693
20448 20448 20448 061 258700800 912 Oxford St 912 OXFORD ST 912 OXFORD ST 912.0 OXFORD ST     Berkeley 94707 37.891161250061536 -122.26945732869304
20485 20485 20485 061 255800900 1106 Oxford St 1106 OXFORD ST 1106 OXFORD ST 1106.0 OXFORD ST     Berkeley 94707 37.88862199544134 -122.26815518745104
21199 21199 21199 061 258301400 839 Oxford St 839 OXFORD ST 839 OXFORD ST 839.0 OXFORD ST     Berkeley 94707 37.89238520359054 -122.27014418505084
21544 21544 21544 061 258402800 836 Oxford St 836 OXFORD ST 836 OXFORD ST 836.0 OXFORD ST     Berkeley 94707 37.89209721789849 -122.27076325633396
21952 21952 21952 061 255702800 1191 Oxford St 1191 OXFORD ST 1191 OXFORD ST 1191.0 OXFORD ST     Berkeley 94707 37.886399978680934 -122.26742805961904
22953 22953 22953 061 255703700 1139 Oxford St 1139 OXFORD ST 1139 OXFORD ST 1139.0 OXFORD ST     Berkeley 94707 37.88773076588641 -122.26762608603693
23568 23568 23568 061 255802200 1166 Oxford St 1166 OXFORD ST 1166 OXFORD ST 1166.0 OXFORD ST     Berkeley 94707 37.8867492994547 -122.26814864142756
23914 23914 23914 061 258301900 829 Oxford St 829 OXFORD ST 829 OXFORD ST 829.0 OXFORD ST     Berkeley 94707 37.892689427312646 -122.27086374727152
24002 24002 24002 061 255703400 1151 Oxford St 1151 OXFORD ST 1151 OXFORD ST 1151.0 OXFORD ST     Berkeley 94707 37.887243690105215 -122.26753410484
24117 24117 24117 061 258301800 831 Oxford St B 831 OXFORD ST B 831 OXFORD ST 831.0 OXFORD ST B   Berkeley 94707 37.8926758990541 -122.2706965258814
24593 24593 24593 061 255801000 1110 Oxford St 1 1110 OXFORD ST 1 1110 OXFORD ST 1110.0 OXFORD ST 1   Berkeley 94707 37.88854280999161 -122.26836763901574
25098 25098 25098 061 258302100 825 Oxford St 825 OXFORD ST 825 OXFORD ST 825.0 OXFORD ST     Berkeley 94707 37.89274367218049 -122.27117350524613
25337 25337 25337 061 258301700 833 Oxford St 833 OXFORD ST 833 OXFORD ST 833.0 OXFORD ST     Berkeley 94707 37.89266104511829 -122.2705248829834
25602 25602 25602 061 255702700 1197 Oxford St 1197 OXFORD ST 1197 OXFORD ST 1197.0 OXFORD ST     Berkeley 94707 37.8862644440829 -122.26747674291757
25669 25669 25669 061 258402100 816 Oxford St 816 OXFORD ST 816 OXFORD ST 816.0 OXFORD ST     Berkeley 94707 37.892415409940696 -122.2717999103752
26044 26044 26044 061 255806000 1122 Oxford St 1122 OXFORD ST 1122 OXFORD ST 1122.0 OXFORD ST     Berkeley 94707 37.88809091823411 -122.2686501528844
26058 26058 26058 061 255704100 1125 Oxford St 1125 OXFORD ST 1125 OXFORD ST 1125.0 OXFORD ST     Berkeley 94707 37.88804618136502 -122.2680521533829
26462 26462 26462 061 258803600 1031 Oxford St 1031 OXFORD ST 1031 OXFORD ST 1031.0 OXFORD ST     Berkeley 94707 37.889641217364954 -122.26768805901172
26560 26560 26560 061 258301302 841 Oxford St 841 OXFORD ST 841 OXFORD ST 841.0 OXFORD ST     Berkeley 94707 37.89224543357325 -122.27012738026684
26728 26728 26728 061 258301600 835 Oxford St B 835 OXFORD ST B 835 OXFORD ST 835.0 OXFORD ST B   Berkeley 94707 37.8926052299373 -122.27035089907582
26862 26862 26862 061 258701900 1014 Oxford St 1014 OXFORD ST 1014 OXFORD ST 1014.0 OXFORD ST     Berkeley 94707 37.89002180556028 -122.26849390441542
27228 27228 27228 061 255700200 1115 Oxford St 1115 OXFORD ST 1115 OXFORD ST 1115.0 OXFORD ST     Berkeley 94707 37.888251699064625 -122.26794581710776
27361 27361 27361 061 258701300 940 Oxford St 940 OXFORD ST 940 OXFORD ST 940.0 OXFORD ST     Berkeley 94707 37.89082335981424 -122.26872708191036
27707 27707 27707 061 255801800 1150 Oxford St A 1150 OXFORD ST A 1150 OXFORD ST 1150.0 OXFORD ST A   Berkeley 94707 37.88721691517207 -122.26819559097758
28328 28328 28328 061 258701700 1004 Oxford St 1004 OXFORD ST 1004 OXFORD ST 1004.0 OXFORD ST     Berkeley 94707 37.8903257129364 -122.26852764962908
29093 29093 29093 061 258302700 811 Oxford St 811 OXFORD ST 811 OXFORD ST 811.0 OXFORD ST     Berkeley 94707 37.892898060492016 -122.2720741292005
29646 29646 29646 061 258701800 1010 Oxford St 1010 OXFORD ST 1010 OXFORD ST 1010.0 OXFORD ST     Berkeley 94707 37.89018050001513 -122.26851024297385
30580 30580 30580 061 258402400 822 Oxford St 822 OXFORD ST 822 OXFORD ST 822.0 OXFORD ST     Berkeley 94707 37.892324885139395 -122.27131345378422
30871 30871 30871 061 258803700 1027 Oxford St 1027 OXFORD ST 1027 OXFORD ST 1027.0 OXFORD ST     Berkeley 94707 37.88976877720812 -122.26775792009305
30896 30896 30896 061 255802800 1198 Oxford St 1198 OXFORD ST 1198 OXFORD ST 1198.0 OXFORD ST     Berkeley 94707 37.88604979980146 -122.26790923591275
31267 31267 31267 061 255703700 1139 Oxford St 2 1139 OXFORD ST 2 1139 OXFORD ST 1139.0 OXFORD ST 2   Berkeley 94707 37.88773076588641 -122.26762608603693
31525 31525 31525 061 255801100 1114 Oxford St 1114 OXFORD ST 1114 OXFORD ST 1114.0 OXFORD ST     Berkeley 94707 37.88842442477439 -122.268485549185
33684 33684 33684 061 255703000 1167 Oxford St 1167 OXFORD ST 1167 OXFORD ST 1167.0 OXFORD ST     Berkeley 94707 37.886675147837806 -122.26746312355954
34417 34417 34417 061 258400100 850 Oxford St 850 OXFORD ST 850 OXFORD ST 850.0 OXFORD ST     Berkeley 94707 37.89170758886305 -122.2704501799827
34444 34444 34444 061 255703700 1139 Oxford St 1 1139 OXFORD ST 1 1139 OXFORD ST 1139.0 OXFORD ST 1   Berkeley 94707 37.88773076588641 -122.26762608603693
34545 34545 34545 061 255702900 1175 Oxford St 1175 OXFORD ST 1175 OXFORD ST 1175.0 OXFORD ST     Berkeley 94707 37.88653649283421 -122.26744350525205
34564 34564 34564 061 255703600 1141 Oxford St 1141 OXFORD ST 1141 OXFORD ST 1141.0 OXFORD ST     Berkeley 94707 37.8876215335266 -122.26758283215597
34827 34827 34827 061 255700300 1111 Oxford St 1111 OXFORD ST 1111 OXFORD ST 1111.0 OXFORD ST     Berkeley 94707 37.888280696917434 -122.267815921616
35085 35085 35085 061 258803300 1047 Oxford St 1047 OXFORD ST 1047 OXFORD ST 1047.0 OXFORD ST     Berkeley 94707 37.88909637967639 -122.26753480732258
36214 36214 36214 061 258805300 919 Oxford St 919 OXFORD ST 919 OXFORD ST 919.0 OXFORD ST     Berkeley 94707 37.89155417850189 -122.26905843268943
37152 37152 37152 061 258702100 1020 Oxford St 1020 OXFORD ST 1020 OXFORD ST 1020.0 OXFORD ST     Berkeley 94707 37.88974895227246 -122.26838833530157
37225 37225 37225 061 258804000 1015 Oxford St 1015 OXFORD ST 1015 OXFORD ST 1015.0 OXFORD ST     Berkeley 94707 37.89016881241521 -122.26790350016968
37665 37665 37665 061 258805100 929 Oxford St 929 OXFORD ST 929 OXFORD ST 929.0 OXFORD ST     Berkeley 94707 37.891487149364096 -122.2687380341703
38166 38166 38166 061 258701200 936 Oxford St 936 OXFORD ST 936 OXFORD ST 936.0 OXFORD ST     Berkeley 94707 37.890927585188265 -122.26882671675348
39034 39034 39034 061 258302600 815 Oxford St 815 OXFORD ST 815 OXFORD ST 815.0 OXFORD ST     Berkeley 94707 37.89287425725971 -122.27193483463591
39414 39414 39414 061 255801000 1110 Oxford St A 1110 OXFORD ST A 1110 OXFORD ST 1110.0 OXFORD ST A   Berkeley 94707 37.88854280999161 -122.26836763901574
39620 39620 39620 061 258402500 824 Oxford St 824 OXFORD ST 824 OXFORD ST 824.0 OXFORD ST     Berkeley 94707 37.89229339418816 -122.27114461273165
39677 39677 39677 061 255700100 1121 Oxford St 1121 OXFORD ST 1121 OXFORD ST 1121.0 OXFORD ST     Berkeley 94707 37.88819994429923 -122.26811381015074
39757 39757 39757 061 255802400 1178 Oxford St 1178 OXFORD ST 1178 OXFORD ST 1178.0 OXFORD ST     Berkeley 94707 37.886503543169894 -122.2681202546646
39800 39800 39800 061 258402300 820 Oxford St 820 OXFORD ST 820 OXFORD ST 820.0 OXFORD ST     Berkeley 94707 37.89235627399276 -122.27148490623932
40236 40236 40236 061 258401800 808 Oxford St 808 OXFORD ST 808 OXFORD ST 808.0 OXFORD ST     Berkeley 94707 37.89257073542112 -122.27228925774476
40239 40239 40239 061 255703200 1159 Oxford St 1159 OXFORD ST 1159 OXFORD ST 1159.0 OXFORD ST     Berkeley 94707 37.8869301145166 -122.26749698914742
40469 40469 40469 061 258702500 1036 Oxford St 1036 OXFORD ST 1036 OXFORD ST 1036.0 OXFORD ST     Berkeley 94707 37.889287166730114 -122.26808687326864
40480 40480 40480 061 258702200 1024 Oxford St 1024 OXFORD ST 1024 OXFORD ST 1024.0 OXFORD ST     Berkeley 94707 37.889655577774725 -122.2682870933724
41285 41285 41285 061 255703400 1149 Oxford St A 1149 OXFORD ST A 1149 OXFORD ST 1149.0 OXFORD ST A   Berkeley 94707 37.887243690105215 -122.26753410484
42692 42692 42692 061 258803400 1043 Oxford St 1043 OXFORD ST 1043 OXFORD ST 1043.0 OXFORD ST     Berkeley 94707 37.88924444329655 -122.267589368298
42705 42705 42705 061 255802100 1162 Oxford St 1162 OXFORD ST 1162 OXFORD ST 1162.0 OXFORD ST     Berkeley 94707 37.88686133355108 -122.2681607938367

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