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

29 rows where street_name = "KEONCREST"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • KEONCREST · 29 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
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
11580 11580 11580 059 228614100 1533 Keoncrest Dr 1533 KEONCREST DR 1533 KEONCREST DR 1533.0 KEONCREST DR     Berkeley 94702 37.877653485369024 -122.2834296815031
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
19865 19865 19865 059 228614600 1513 Keoncrest Dr 1513 KEONCREST DR 1513 KEONCREST DR 1513.0 KEONCREST DR     Berkeley 94702 37.878263047385985 -122.28350067805496
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
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
39592 39592 39592 059 228613700 1488 Keoncrest Dr 1488 KEONCREST DR 1488 KEONCREST DR 1488.0 KEONCREST DR     Berkeley 94702 37.877108588765 -122.28333537277128
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
44219 44219 44219 059 228608900 1548 Keoncrest Dr 1548 KEONCREST DR 1548 KEONCREST DR 1548.0 KEONCREST DR     Berkeley 94702 37.87743485870599 -122.2838368707534
45753 45753 45753 059 228608700 1528 Keoncrest Dr 1528 KEONCREST DR 1528 KEONCREST DR 1528.0 KEONCREST DR     Berkeley 94702 37.8777375183221 -122.28383672342969
50021 50021 50021 059 228614400 1521 Keoncrest Dr 1521 KEONCREST DR 1521 KEONCREST DR 1521.0 KEONCREST DR     Berkeley 94702 37.87801707842606 -122.283471428011
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
57886 57886 57886 059 228608800 1538 Keoncrest Dr 1538 KEONCREST DR 1538 KEONCREST DR 1538.0 KEONCREST DR     Berkeley 94702 37.87757623520947 -122.28385582430757

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