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

860 rows where street_name = "OXFORD" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 3

street_type 1

  • ST · 860 ✖

street_name 1

  • OXFORD · 860 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
172 172 172 058 217900700 1644 Oxford St 10 1644 OXFORD ST 10 1644 OXFORD ST 1644.0 OXFORD ST 10   Berkeley 94709 37.87792428749744 -122.26710658132497
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
328 328 328 058 217901100 1672 Oxford St 18 1672 OXFORD ST 18 1672 OXFORD ST 1672.0 OXFORD ST 18   Berkeley 94709 37.87737733590169 -122.2670467472388
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
432 432 432 060 246603800 1229 Oxford St A 1229 OXFORD ST A 1229 OXFORD ST 1229.0 OXFORD ST A   Berkeley 94709 37.88495921716209 -122.26725330765186
434 434 434 057 203100101 2132 Oxford St 2132 OXFORD ST 2132 OXFORD ST 2132.0 OXFORD ST     Berkeley 94704 37.87025993966203 -122.26617633093244
471 471 471 058 218301600 1675 Oxford St 1675 OXFORD ST 1675 OXFORD ST 1675.0 OXFORD ST     Berkeley 94709 37.877350488602055 -122.2663711701277
485 485 485 061 258803900 1019 Oxford St 1019 OXFORD ST 1019 OXFORD ST 1019.0 OXFORD ST     Berkeley 94707 37.89002782944345 -122.2678847406516
498 498 498 059 225702200 1441 Oxford St 2 1441 OXFORD ST 2 1441 OXFORD ST 1441.0 OXFORD ST 2   Berkeley 94709 37.880961579872945 -122.26678378610065
577 577 577 061 258402000 814 Oxford St 814 OXFORD ST 814 OXFORD ST 814.0 OXFORD ST     Berkeley 94707 37.89244302234366 -122.27196616338144
603 603 603 058 218102200 1819 Oxford St 1819 OXFORD ST 1819 OXFORD ST 1819.0 OXFORD ST     Berkeley 94709 37.874930570251344 -122.26612295752986
646 646 646 058 218103200 1725 Oxford St 202 1725 OXFORD ST 202 1725 OXFORD ST 1725.0 OXFORD ST 202   Berkeley 94709 37.876329729467955 -122.2662473032298
700 700 700 059 225702200 1441 Oxford St 1441 OXFORD ST 1441 OXFORD ST 1441.0 OXFORD ST     Berkeley 94709 37.880961579872945 -122.26678378610065
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
743 743 743 058 218103000 1749 Oxford St 2 1749 OXFORD ST 2 1749 OXFORD ST 1749.0 OXFORD ST 2   Berkeley 94709 37.875966920830834 -122.26621912307937
797 797 797 058 217900800 1650 Oxford St 19 1650 OXFORD ST 19 1650 OXFORD ST 1650.0 OXFORD ST 19   Berkeley 94709 37.87778546427877 -122.26709365097472
961 961 961 058 217900800 1650 Oxford St 3 1650 OXFORD ST 3 1650 OXFORD ST 1650.0 OXFORD ST 3   Berkeley 94709 37.87778546427877 -122.26709365097472
997 997 997 061 258301200 843 Oxford St 843 OXFORD ST 843 OXFORD ST 843.0 OXFORD ST     Berkeley 94707 37.89203636184776 -122.2702095392844
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
1012 1012 1012 059 225900400 1506 Oxford St 1506 OXFORD ST 1506 OXFORD ST 1506.0 OXFORD ST     Berkeley 94709 37.87999336449833 -122.2673551119264
1027 1027 1027 059 225801400 1438 Oxford St 1438 OXFORD ST 1438 OXFORD ST 1438.0 OXFORD ST     Berkeley 94709 37.880834301147615 -122.26730490508515
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
1309 1309 1309 059 225900800 1524 Oxford St A 1524 OXFORD ST A 1524 OXFORD ST 1524.0 OXFORD ST A   Berkeley 94709 37.87948405723301 -122.26729184986912
1344 1344 1344 059 225900900 1528 Oxford St 9 1528 OXFORD ST 9 1528 OXFORD ST 1528.0 OXFORD ST 9   Berkeley 94709 37.87932037782597 -122.267274885185
1541 1541 1541 061 255703900 1133 Oxford St 1133 OXFORD ST 1133 OXFORD ST 1133.0 OXFORD ST     Berkeley 94707 37.8878949569058 -122.2678214453567
1645 1645 1645 060 246603700 1231 Oxford St A 1231 OXFORD ST A 1231 OXFORD ST 1231.0 OXFORD ST A   Berkeley 94709 37.88485127956454 -122.26724121093824
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
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
1853 1853 1853 058 218103200 1725 Oxford St 302 1725 OXFORD ST 302 1725 OXFORD ST 1725.0 OXFORD ST 302   Berkeley 94709 37.876329729467955 -122.2662473032298
1868 1868 1868 058 217901100 1672 Oxford St 19 1672 OXFORD ST 19 1672 OXFORD ST 1672.0 OXFORD ST 19   Berkeley 94709 37.87737733590169 -122.2670467472388
1877 1877 1877 058 218102100 1827 Oxford St 1827 OXFORD ST 1827 OXFORD ST 1827.0 OXFORD ST     Berkeley 94709 37.8747950053272 -122.26610939207076
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
1982 1982 1982 059 225901000 1536 Oxford St 1B 1536 OXFORD ST 1B 1536 OXFORD ST 1536.0 OXFORD ST 1B   Berkeley 94709 37.879130648373184 -122.26729884684688
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
2149 2149 2149 058 218302002 1643 Oxford St 1643 OXFORD ST 1643 OXFORD ST 1643.0 OXFORD ST     Berkeley 94709 37.8778941851067 -122.26643525594008
2209 2209 2209 058 218103200 1725 Oxford St 209 1725 OXFORD ST 209 1725 OXFORD ST 1725.0 OXFORD ST 209   Berkeley 94709 37.876329729467955 -122.2662473032298
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
2381 2381 2381 061 258805400 915 Oxford St 915 OXFORD ST 915 OXFORD ST 915.0 OXFORD ST     Berkeley 94707 37.89157620488004 -122.26923038370956
2498 2498 2498 058 217900700 1644 Oxford St 12 1644 OXFORD ST 12 1644 OXFORD ST 1644.0 OXFORD ST 12   Berkeley 94709 37.87792428749744 -122.26710658132497
2559 2559 2559 059 225605000 1519 Oxford St D 1519 OXFORD ST D 1519 OXFORD ST 1519.0 OXFORD ST D   Berkeley 94709 37.87962015452707 -122.2666218081768
2734 2734 2734 058 217900700 1644 Oxford St 7 1644 OXFORD ST 7 1644 OXFORD ST 1644.0 OXFORD ST 7   Berkeley 94709 37.87792428749744 -122.26710658132497
2765 2765 2765 061 258804900 935 Oxford St 935 OXFORD ST 935 OXFORD ST 935.0 OXFORD ST     Berkeley 94707 37.89129817082039 -122.2684906165815
2812 2812 2812 058 218102200 1817 Oxford St 3 1817 OXFORD ST 3 1817 OXFORD ST 1817.0 OXFORD ST 3   Berkeley 94709 37.874930570251344 -122.26612295752986
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
3070 3070 3070 058 217900700 1644 Oxford St 16 1644 OXFORD ST 16 1644 OXFORD ST 1644.0 OXFORD ST 16   Berkeley 94709 37.87792428749744 -122.26710658132497
3400 3400 3400 060 246600700 1214 Oxford St 1214 OXFORD ST 1214 OXFORD ST 1214.0 OXFORD ST     Berkeley 94709 37.88531500577584 -122.26797291838156
3487 3487 3487 058 218301700 1669 Oxford St 6 1669 OXFORD ST 6 1669 OXFORD ST 1669.0 OXFORD ST 6   Berkeley 94709 37.87748581412343 -122.26638822194845
3614 3614 3614 058 217903300 1622 Oxford St 5T 1622 OXFORD ST 5T 1622 OXFORD ST 1622.0 OXFORD ST 5T   Berkeley 94709 37.8781965826118 -122.26713985582136
3626 3626 3626 058 217901000 1664 Oxford St 1664 OXFORD ST 1664 OXFORD ST 1664.0 OXFORD ST     Berkeley 94709 37.87751352146697 -122.26705942875569
3768 3768 3768 058 218103300 1717 Oxford St 310 1717 OXFORD ST 310 1717 OXFORD ST 1717.0 OXFORD ST 310   Berkeley 94709 37.876582533842 -122.26627488061074
3837 3837 3837 059 225602201 1541 Oxford St 202 1541 OXFORD ST 202 1541 OXFORD ST 1541.0 OXFORD ST 202   Berkeley 94709 37.87928657762329 -122.26658622860336
3868 3868 3868 060 246601100 1226 Oxford St 1226 OXFORD ST 1226 OXFORD ST 1226.0 OXFORD ST     Berkeley 94709 37.88487222177222 -122.267921915633
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
3999 3999 3999 059 225702400 1431 Oxford St 2 1431 OXFORD ST 2 1431 OXFORD ST 1431.0 OXFORD ST 2   Berkeley 94709 37.88121018508948 -122.26681224383051
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
4204 4204 4204 058 218102900 1757 Oxford St 6 1757 OXFORD ST 6 1757 OXFORD ST 1757.0 OXFORD ST 6   Berkeley 94709 37.87583209383786 -122.26621717643012
4360 4360 4360 059 225602201 1541 Oxford St 204 1541 OXFORD ST 204 1541 OXFORD ST 1541.0 OXFORD ST 204   Berkeley 94709 37.87928657762329 -122.26658622860336
4363 4363 4363 058 217900800 1650 Oxford St 2 1650 OXFORD ST 2 1650 OXFORD ST 1650.0 OXFORD ST 2   Berkeley 94709 37.87778546427877 -122.26709365097472
4392 4392 4392 058 217903300 1622 Oxford St 5N 1622 OXFORD ST 5N 1622 OXFORD ST 1622.0 OXFORD ST 5N   Berkeley 94709 37.8781965826118 -122.26713985582136
4486 4486 4486 061 255703400 1147 Oxford St 1147 OXFORD ST 1147 OXFORD ST 1147.0 OXFORD ST     Berkeley 94707 37.887243690105215 -122.26753410484
4611 4611 4611 058 218301800 1661 Oxford St 4 1661 OXFORD ST 4 1661 OXFORD ST 1661.0 OXFORD ST 4   Berkeley 94709 37.877622901414654 -122.2664028438263
4650 4650 4650 060 246607200 1296 Oxford St 1296 OXFORD ST 1296 OXFORD ST 1296.0 OXFORD ST     Berkeley 94709 37.883727113563246 -122.26785558762568
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
4809 4809 4809 059 225900800 1526 Oxford St A 1526 OXFORD ST A 1526 OXFORD ST 1526.0 OXFORD ST A   Berkeley 94709 37.87948405723301 -122.26729184986912
5053 5053 5053 060 246600400 1200 Oxford St 1200 OXFORD ST 1200 OXFORD ST 1200.0 OXFORD ST     Berkeley 94709 37.88575788212077 -122.26789966077015
5235 5235 5235 059 225702200 1441 Oxford St 1 1441 OXFORD ST 1 1441 OXFORD ST 1441.0 OXFORD ST 1   Berkeley 94709 37.880961579872945 -122.26678378610065
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
5301 5301 5301 059 225605000 1519 Oxford St A 1519 OXFORD ST A 1519 OXFORD ST 1519.0 OXFORD ST A   Berkeley 94709 37.87962015452707 -122.2666218081768
5423 5423 5423 058 218300100 1603 Oxford St 1603 OXFORD ST 1603 OXFORD ST 1603.0 OXFORD ST     Berkeley 94709 37.87859030063245 -122.2666932664627
5605 5605 5605 059 225602201 1541 Oxford St 305 1541 OXFORD ST 305 1541 OXFORD ST 1541.0 OXFORD ST 305   Berkeley 94709 37.87928657762329 -122.26658622860336
5657 5657 5657 059 225900500 1510 Oxford St 1510 OXFORD ST 1510 OXFORD ST 1510.0 OXFORD ST     Berkeley 94709 37.87986793823975 -122.26734078379762
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
5811 5811 5811 058 217900600 1634 Oxford St 204 1634 OXFORD ST 204 1634 OXFORD ST 1634.0 OXFORD ST 204   Berkeley 94709 37.878062894901035 -122.2671227429152
5919 5919 5919 059 225901000 1540 Oxford St 2 1540 OXFORD ST 2 1540 OXFORD ST 1540.0 OXFORD ST 2   Berkeley 94709 37.879130648373184 -122.26729884684688
5948 5948 5948 058 218302102 1639 Oxford St 9 1639 OXFORD ST 9 1639 OXFORD ST 1639.0 OXFORD ST 9   Berkeley 94709 37.87802893245607 -122.2664488752981
6165 6165 6165 058 218102800 1765 Oxford St 1 1765 OXFORD ST 1 1765 OXFORD ST 1765.0 OXFORD ST 1   Berkeley 94709 37.875709724428745 -122.26620217995476
6189 6189 6189 058 217900800 1650 Oxford St 17 1650 OXFORD ST 17 1650 OXFORD ST 1650.0 OXFORD ST 17   Berkeley 94709 37.87778546427877 -122.26709365097472
6219 6219 6219 059 225702500 1427 Oxford St 2 1427 OXFORD ST 2 1427 OXFORD ST 1427.0 OXFORD ST 2   Berkeley 94709 37.88134110472264 -122.26682576437386
6381 6381 6381 058 218103100 1739 Oxford St 6 1739 OXFORD ST 6 1739 OXFORD ST 1739.0 OXFORD ST 6   Berkeley 94709 37.87612045584634 -122.26623443576167
6387 6387 6387 058 218302300 1619 Oxford St 2 1619 OXFORD ST 2 1619 OXFORD ST 1619.0 OXFORD ST 2   Berkeley 94709 37.87831522889583 -122.26648337599488
6418 6418 6418 061 258302300 821 Oxford St 821 OXFORD ST 821 OXFORD ST 821.0 OXFORD ST     Berkeley 94707 37.89279554993896 -122.27148589348784
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
6657 6657 6657 058 218302300 1619 Oxford St 1 1619 OXFORD ST 1 1619 OXFORD ST 1619.0 OXFORD ST 1   Berkeley 94709 37.87831522889583 -122.26648337599488
6682 6682 6682 058 218103300 1717 Oxford St 309 1717 OXFORD ST 309 1717 OXFORD ST 1717.0 OXFORD ST 309   Berkeley 94709 37.876582533842 -122.26627488061074
6706 6706 6706 058 217903300 1622 Oxford St 5S 1622 OXFORD ST 5S 1622 OXFORD ST 1622.0 OXFORD ST 5S   Berkeley 94709 37.8781965826118 -122.26713985582136
6837 6837 6837 061 258803200 1053 Oxford St 1053 OXFORD ST 1053 OXFORD ST 1053.0 OXFORD ST     Berkeley 94707 37.888970993025694 -122.2674555103375
6847 6847 6847 058 217901100 1672 Oxford St 4 1672 OXFORD ST 4 1672 OXFORD ST 1672.0 OXFORD ST 4   Berkeley 94709 37.87737733590169 -122.2670467472388
6886 6886 6886 058 218102100 1827 Oxford St 8 1827 OXFORD ST 8 1827 OXFORD ST 1827.0 OXFORD ST 8   Berkeley 94709 37.8747950053272 -122.26610939207076
7006 7006 7006 059 225801300 1436 Oxford St A 1436 OXFORD ST A 1436 OXFORD ST 1436.0 OXFORD ST A   Berkeley 94709 37.88095362030602 -122.26746551307818
7010 7010 7010 060 246610600 1235 Oxford St 1235 OXFORD ST 1235 OXFORD ST 1235.0 OXFORD ST     Berkeley 94709 37.88468603457456 -122.26722431452608
7374 7374 7374 058 218102800 1765 Oxford St 9 1765 OXFORD ST 9 1765 OXFORD ST 1765.0 OXFORD ST 9   Berkeley 94709 37.875709724428745 -122.26620217995476
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
7848 7848 7848 061 258701500 976 Oxford St 976 OXFORD ST 976 OXFORD ST 976.0 OXFORD ST     Berkeley 94707 37.890608309131814 -122.26858393447154

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