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

53 rows where street_type = "DR" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

street_name 3

zipcode 1

  • 94702 · 53 ✖

street_type 1

Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
243 243 243 059 228608500 1450 Catherine Dr 1450 CATHERINE DR 1450 CATHERINE DR 1450.0 CATHERINE DR     Berkeley 94702 37.87764634441069 -122.28415859877914
2725 2725 2725 059 228612900 1420 Keoncrest Dr 1420 KEONCREST DR 1420 KEONCREST DR 1420.0 KEONCREST DR     Berkeley 94702 37.876889370539416 -122.28453671315694
2952 2952 2952 059 228606800 1522 Keoncrest Dr 1522 KEONCREST DR 1522 KEONCREST DR 1522.0 KEONCREST DR     Berkeley 94702 37.87802896010937 -122.28387212154348
3297 3297 3297 059 228613900 1541 Keoncrest Dr 1541 KEONCREST DR 1541 KEONCREST DR 1541.0 KEONCREST DR     Berkeley 94702 37.87740578993028 -122.28339688940196
4297 4297 4297 059 228613300 1460 Keoncrest Dr 1460 KEONCREST DR 1460 KEONCREST DR 1460.0 KEONCREST DR     Berkeley 94702 37.876969953330146 -122.28393224129384
8050 8050 8050 059 228604200 1364 Tomlee Dr 1364 TOMLEE DR 1364 TOMLEE DR 1364.0 TOMLEE DR     Berkeley 94702 37.8769553110736 -122.28583467453792
11030 11030 11030 059 228603100 1363 Tomlee Dr 1363 TOMLEE DR 1363 TOMLEE DR 1363.0 TOMLEE DR     Berkeley 94702 37.877393427401074 -122.28573844251314
11580 11580 11580 059 228614100 1533 Keoncrest Dr 1533 KEONCREST DR 1533 KEONCREST DR 1533.0 KEONCREST DR     Berkeley 94702 37.877653485369024 -122.2834296815031
11947 11947 11947 059 228607600 1431 Catherine Dr 1431 CATHERINE DR 1431 CATHERINE DR 1431.0 CATHERINE DR     Berkeley 94702 37.87734313134968 -122.28454939377548
14552 14552 14552 059 228609400 1440 Catherine Dr 1440 CATHERINE DR 1440 CATHERINE DR 1440.0 CATHERINE DR     Berkeley 94702 37.87751621023307 -122.28413332737355
15878 15878 15878 059 228612800 1410 Keoncrest Dr 1410 KEONCREST DR 1410 KEONCREST DR 1410.0 KEONCREST DR     Berkeley 94702 37.87693089217952 -122.28469793200436
16811 16811 16811 059 228613200 1450 Keoncrest Dr 1450 KEONCREST DR 1450 KEONCREST DR 1450.0 KEONCREST DR     Berkeley 94702 37.87695079998172 -122.28408164639698
17156 17156 17156 059 228609300 1430 Catherine Dr 1430 CATHERINE DR 1430 CATHERINE DR 1430.0 CATHERINE DR     Berkeley 94702 37.87738507746337 -122.28411632945176
17623 17623 17623 059 228607000 1471 Catherine Dr 1471 CATHERINE DR 1471 CATHERINE DR 1471.0 CATHERINE DR     Berkeley 94702 37.87797008134031 -122.28414601697528
18467 18467 18467 059 228604400 1378 Tomlee Dr 1378 TOMLEE DR 1378 TOMLEE DR 1378.0 TOMLEE DR     Berkeley 94702 37.87699149765032 -122.28558420806704
19865 19865 19865 059 228614600 1513 Keoncrest Dr 1513 KEONCREST DR 1513 KEONCREST DR 1513.0 KEONCREST DR     Berkeley 94702 37.878263047385985 -122.28350067805496
19948 19948 19948 059 228607300 1455 Catherine Dr 1455 CATHERINE DR 1455 CATHERINE DR 1455.0 CATHERINE DR     Berkeley 94702 37.87776207025217 -122.28456034783208
21825 21825 21825 059 228609000 1558 Keoncrest Dr 1558 KEONCREST DR 1558 KEONCREST DR 1558.0 KEONCREST DR     Berkeley 94702 37.87729335146322 -122.2837855140686
22444 22444 22444 059 228613400 1470 Keoncrest Dr 1470 KEONCREST DR 1470 KEONCREST DR 1470.0 KEONCREST DR     Berkeley 94702 37.87698795798365 -122.2837750118646
23290 23290 23290 059 228614000 1537 Keoncrest Dr 1537 KEONCREST DR 1537 KEONCREST DR 1537.0 KEONCREST DR     Berkeley 94702 37.87753094881058 -122.2834129180416
23518 23518 23518 059 228614200 1529 Keoncrest Dr 1529 KEONCREST DR 1529 KEONCREST DR 1529.0 KEONCREST DR     Berkeley 94702 37.877771911301 -122.2834456032432
25235 25235 25235 059 228613800 1545 Keoncrest Dr 1545 KEONCREST DR 1545 KEONCREST DR 1545.0 KEONCREST DR     Berkeley 94702 37.87727776550537 -122.2833817689591
25718 25718 25718 059 228614700 1509 Keoncrest Dr 1509 KEONCREST DR 1509 KEONCREST DR 1509.0 KEONCREST DR     Berkeley 94702 37.87838321802998 -122.28351747475412
27740 27740 27740 059 228613500 1476 Keoncrest Dr 1476 KEONCREST DR 1476 KEONCREST DR 1476.0 KEONCREST DR     Berkeley 94702 37.87698188836241 -122.28361188050395
28143 28143 28143 059 228609200 1420 Catherine Dr 1420 CATHERINE DR 1420 CATHERINE DR 1420.0 CATHERINE DR     Berkeley 94702 37.87724586678779 -122.28414420417504
28571 28571 28571 059 228606900 1475 Catherine Dr 1475 CATHERINE DR 1475 CATHERINE DR 1475.0 CATHERINE DR     Berkeley 94702 37.87802083926939 -122.28400690207374
29343 29343 29343 059 228614500 1517 Keoncrest Dr 1517 KEONCREST DR 1517 KEONCREST DR 1517.0 KEONCREST DR     Berkeley 94702 37.87813851939206 -122.2834846889412
31004 31004 31004 059 228607800 1415 Keoncrest Dr 1415 KEONCREST DR 1415 KEONCREST DR 1415.0 KEONCREST DR     Berkeley 94702 37.877188480685675 -122.2846721449658
35031 35031 35031 059 228609500 1505 Keoncrest Dr 1505 KEONCREST DR 1505 KEONCREST DR 1505.0 KEONCREST DR     Berkeley 94702 37.878512937297856 -122.28358386564352
37280 37280 37280 059 228613600 1482 Keoncrest Dr 1482 KEONCREST DR 1482 KEONCREST DR 1482.0 KEONCREST DR     Berkeley 94702 37.87699633632909 -122.28343574962284
38250 38250 38250 059 228608600 1460 Catherine Dr 1460 CATHERINE DR 1460 CATHERINE DR 1460.0 CATHERINE DR     Berkeley 94702 37.87770280412247 -122.2839892250256
39592 39592 39592 059 228613700 1488 Keoncrest Dr 1488 KEONCREST DR 1488 KEONCREST DR 1488.0 KEONCREST DR     Berkeley 94702 37.877108588765 -122.28333537277128
40415 40415 40415 059 228604500 1380 Tomlee Dr 1380 TOMLEE DR 1380 TOMLEE DR 1380.0 TOMLEE DR     Berkeley 94702 37.87720293357526 -122.28536994549874
42524 42524 42524 059 228613000 1430 Keoncrest Dr 1430 KEONCREST DR 1430 KEONCREST DR 1430.0 KEONCREST DR     Berkeley 94702 37.8769090649232 -122.28438549166036
43231 43231 43231 059 228606700 1518 Keoncrest Dr 1518 KEONCREST DR 1518 KEONCREST DR 1518.0 KEONCREST DR     Berkeley 94702 37.878212342803025 -122.28389311337502
43517 43517 43517 059 228607500 1441 Catherine Dr 1441 CATHERINE DR 1441 CATHERINE DR 1441.0 CATHERINE DR     Berkeley 94702 37.87747687638277 -122.28456383599033
44219 44219 44219 059 228608900 1548 Keoncrest Dr 1548 KEONCREST DR 1548 KEONCREST DR 1548.0 KEONCREST DR     Berkeley 94702 37.87743485870599 -122.2838368707534
45631 45631 45631 059 228603200 1359 Tomlee Dr 1359 TOMLEE DR 1359 TOMLEE DR 1359.0 TOMLEE DR     Berkeley 94702 37.877353701372705 -122.2858740692564
45733 45733 45733 059 228607700 1421 Catherine Dr 1421 CATHERINE DR 1421 CATHERINE DR 1421.0 CATHERINE DR     Berkeley 94702 37.877212508090125 -122.2844794392694
45753 45753 45753 059 228608700 1528 Keoncrest Dr 1528 KEONCREST DR 1528 KEONCREST DR 1528.0 KEONCREST DR     Berkeley 94702 37.8777375183221 -122.28383672342969
46851 46851 46851 059 228607200 1461 Catherine Dr 1461 CATHERINE DR 1461 CATHERINE DR 1461.0 CATHERINE DR     Berkeley 94702 37.8778929683612 -122.28448217823268
50021 50021 50021 059 228614400 1521 Keoncrest Dr 1521 KEONCREST DR 1521 KEONCREST DR 1521.0 KEONCREST DR     Berkeley 94702 37.87801707842606 -122.283471428011
50402 50402 50402 059 228607100 1465 Catherine Dr 1465 CATHERINE DR 1465 CATHERINE DR 1465.0 CATHERINE DR     Berkeley 94702 37.87791783718877 -122.28428688179496
51827 51827 51827 059 228613100 1440 Keoncrest Dr 1440 KEONCREST DR 1440 KEONCREST DR 1440.0 KEONCREST DR     Berkeley 94702 37.87692936059168 -122.28423449653918
52800 52800 52800 059 228609100 1461 Keoncrest Dr 1461 KEONCREST DR 1461 KEONCREST DR 1461.0 KEONCREST DR     Berkeley 94702 37.87727317785418 -122.2839600917626
53699 53699 53699 059 228614300 1525 Keoncrest Dr 1525 KEONCREST DR 1525 KEONCREST DR 1525.0 KEONCREST DR     Berkeley 94702 37.87789467506656 -122.28345967625044
54402 54402 54402 059 228603300 1355 Tomlee Dr 1355 TOMLEE DR 1355 TOMLEE DR 1355.0 TOMLEE DR     Berkeley 94702 37.87723714031956 -122.28596674395271
56738 56738 56738 059 228604300 1372 Tomlee Dr 1372 TOMLEE DR 1372 TOMLEE DR 1372.0 TOMLEE DR     Berkeley 94702 37.87699033336093 -122.285713115412
56878 56878 56878 059 228603000 1369 Tomlee Dr 1369 TOMLEE DR 1369 TOMLEE DR 1369.0 TOMLEE DR     Berkeley 94702 37.877448775495296 -122.28560786520006
57775 57775 57775 059 228602900 1373 Tomlee Dr 1373 TOMLEE DR 1373 TOMLEE DR 1373.0 TOMLEE DR     Berkeley 94702 37.87749399174739 -122.28547483009636
57886 57886 57886 059 228608800 1538 Keoncrest Dr 1538 KEONCREST DR 1538 KEONCREST DR 1538.0 KEONCREST DR     Berkeley 94702 37.87757623520947 -122.28385582430757
57966 57966 57966 059 228607400 1451 Catherine Dr 1451 CATHERINE DR 1451 CATHERINE DR 1451.0 CATHERINE DR     Berkeley 94702 37.87761333404373 -122.28458420439108
58119 58119 58119 059 228604100 1358 Tomlee Dr 1358 TOMLEE DR 1358 TOMLEE DR 1358.0 TOMLEE DR     Berkeley 94702 37.87687384902135 -122.28593728370296

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