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

587 rows where street_name = "OXFORD" and zipcode = 94709

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94709 · 587 ✖

street_type 1

street_name 1

  • OXFORD · 587 ✖
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
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
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
471 471 471 058 218301600 1675 Oxford St 1675 OXFORD ST 1675 OXFORD ST 1675.0 OXFORD ST     Berkeley 94709 37.877350488602055 -122.2663711701277
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
7943 7943 7943 059 225702300 1437 Oxford St 1437 OXFORD ST 1437 OXFORD ST 1437.0 OXFORD ST     Berkeley 94709 37.881080781835486 -122.26673642063064
7960 7960 7960 058 218301700 1669 Oxford St 3 1669 OXFORD ST 3 1669 OXFORD ST 1669.0 OXFORD ST 3   Berkeley 94709 37.87748581412343 -122.26638822194845
7969 7969 7969 059 225601801 1555 Oxford St 304 1555 OXFORD ST 304 1555 OXFORD ST 1555.0 OXFORD ST 304   Berkeley 94709 37.8789860387553 -122.2665642387435
8063 8063 8063 060 246608000 1332 Oxford St 1332 OXFORD ST 1332 OXFORD ST 1332.0 OXFORD ST     Berkeley 94709 37.88285263897108 -122.26767535324034
8120 8120 8120 059 225602201 1541 Oxford St 301 1541 OXFORD ST 301 1541 OXFORD ST 1541.0 OXFORD ST 301   Berkeley 94709 37.87928657762329 -122.26658622860336
8288 8288 8288 058 217901100 1672 Oxford St 11 1672 OXFORD ST 11 1672 OXFORD ST 1672.0 OXFORD ST 11   Berkeley 94709 37.87737733590169 -122.2670467472388
8374 8374 8374 058 218103200 1725 Oxford St 107 1725 OXFORD ST 107 1725 OXFORD ST 1725.0 OXFORD ST 107   Berkeley 94709 37.876329729467955 -122.2662473032298
8447 8447 8447 058 217900600 1634 Oxford St 102 1634 OXFORD ST 102 1634 OXFORD ST 1634.0 OXFORD ST 102   Berkeley 94709 37.878062894901035 -122.2671227429152
8510 8510 8510 058 218301900 1651 Oxford St 1651 OXFORD ST 1651 OXFORD ST 1651.0 OXFORD ST     Berkeley 94709 37.877763422430334 -122.26642000254655
8534 8534 8534 059 225900600 1512 Oxford St B 1512 OXFORD ST B 1512 OXFORD ST 1512.0 OXFORD ST B   Berkeley 94709 37.87974953836712 -122.26732414610024
8555 8555 8555 059 225704000 1409 Oxford St 1409 OXFORD ST 1409 OXFORD ST 1409.0 OXFORD ST     Berkeley 94709 37.88197369496925 -122.26690410105992
8582 8582 8582 059 225900500 1510 Oxford St A 1510 OXFORD ST A 1510 OXFORD ST 1510.0 OXFORD ST A   Berkeley 94709 37.87986793823975 -122.26734078379762
8644 8644 8644 058 218302102 1639 Oxford St 1639 OXFORD ST 1639 OXFORD ST 1639.0 OXFORD ST     Berkeley 94709 37.87802893245607 -122.2664488752981
8652 8652 8652 058 218103000 1749 Oxford St 10 1749 OXFORD ST 10 1749 OXFORD ST 1749.0 OXFORD ST 10   Berkeley 94709 37.875966920830834 -122.26621912307937
8714 8714 8714 058 218103000 1749 Oxford St 22 1749 OXFORD ST 22 1749 OXFORD ST 1749.0 OXFORD ST 22   Berkeley 94709 37.875966920830834 -122.26621912307937
8718 8718 8718 058 217900600 1634 Oxford St 302 1634 OXFORD ST 302 1634 OXFORD ST 1634.0 OXFORD ST 302   Berkeley 94709 37.878062894901035 -122.2671227429152
8757 8757 8757 059 225900400 1508 Oxford St 1508 OXFORD ST 1508 OXFORD ST 1508.0 OXFORD ST     Berkeley 94709 37.87999336449833 -122.2673551119264
8777 8777 8777 059 225605000 1519 Oxford St H 1519 OXFORD ST H 1519 OXFORD ST 1519.0 OXFORD ST H   Berkeley 94709 37.87962015452707 -122.2666218081768
9114 9114 9114 059 225602600 1503 Oxford St 1 1503 OXFORD ST 1 1503 OXFORD ST 1503.0 OXFORD ST 1   Berkeley 94709 37.88025583748228 -122.26674878414389
9160 9160 9160 058 218103200 1725 Oxford St 306 1725 OXFORD ST 306 1725 OXFORD ST 1725.0 OXFORD ST 306   Berkeley 94709 37.876329729467955 -122.2662473032298
9370 9370 9370 058 217900300 1608 Oxford St 1608 OXFORD ST 1608 OXFORD ST 1608.0 OXFORD ST     Berkeley 94709 37.878449241604265 -122.2670523239801
9484 9484 9484 058 217900800 1650 Oxford St 6 1650 OXFORD ST 6 1650 OXFORD ST 1650.0 OXFORD ST 6   Berkeley 94709 37.87778546427877 -122.26709365097472
9491 9491 9491 059 225602201 1541 Oxford St 107 1541 OXFORD ST 107 1541 OXFORD ST 1541.0 OXFORD ST 107   Berkeley 94709 37.87928657762329 -122.26658622860336
9622 9622 9622 059 225601801 1555 Oxford St 205 1555 OXFORD ST 205 1555 OXFORD ST 1555.0 OXFORD ST 205   Berkeley 94709 37.8789860387553 -122.2665642387435
9677 9677 9677 058 218103300 1717 Oxford St 203 1717 OXFORD ST 203 1717 OXFORD ST 1717.0 OXFORD ST 203   Berkeley 94709 37.876582533842 -122.26627488061074
9722 9722 9722 058 217900700 1644 Oxford St 4 1644 OXFORD ST 4 1644 OXFORD ST 1644.0 OXFORD ST 4   Berkeley 94709 37.87792428749744 -122.26710658132497
9843 9843 9843 058 217901300 1694 Oxford St 1694 OXFORD ST 1694 OXFORD ST 1694.0 OXFORD ST     Berkeley 94709 37.87707469465951 -122.26686632869882
10001 10001 10001 060 246607000 1286 Oxford St 1286 OXFORD ST 1286 OXFORD ST 1286.0 OXFORD ST     Berkeley 94709 37.8839386634449 -122.26790131097532
10116 10116 10116 058 218103200 1725 Oxford St 104 1725 OXFORD ST 104 1725 OXFORD ST 1725.0 OXFORD ST 104   Berkeley 94709 37.876329729467955 -122.2662473032298
10138 10138 10138 058 218103200 1725 Oxford St 201 1725 OXFORD ST 201 1725 OXFORD ST 1725.0 OXFORD ST 201   Berkeley 94709 37.876329729467955 -122.2662473032298
10191 10191 10191 058 218302102 1639 Oxford St 2 1639 OXFORD ST 2 1639 OXFORD ST 1639.0 OXFORD ST 2   Berkeley 94709 37.87802893245607 -122.2664488752981
10274 10274 10274 058 218103100 1739 Oxford St 3 1739 OXFORD ST 3 1739 OXFORD ST 1739.0 OXFORD ST 3   Berkeley 94709 37.87612045584634 -122.26623443576167
10308 10308 10308 059 225600100 1501 Oxford St 1 1501 OXFORD ST 1 1501 OXFORD ST 1501.0 OXFORD ST 1   Berkeley 94709 37.88039613651017 -122.26676425133648
10489 10489 10489 058 217901300 1694 Oxford St D 1694 OXFORD ST D 1694 OXFORD ST 1694.0 OXFORD ST D   Berkeley 94709 37.87707469465951 -122.26686632869882
10539 10539 10539 060 246606300 1323 Oxford St 1323 OXFORD ST 1323 OXFORD ST 1323.0 OXFORD ST     Berkeley 94709 37.883094634802944 -122.26703302816776
10575 10575 10575 058 217900800 1650 Oxford St 16 1650 OXFORD ST 16 1650 OXFORD ST 1650.0 OXFORD ST 16   Berkeley 94709 37.87778546427877 -122.26709365097472

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