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

14 rows where street_name = "CATHERINE" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94702 · 14 ✖

street_type 1

street_name 1

  • CATHERINE · 14 ✖
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
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
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
19948 19948 19948 059 228607300 1455 Catherine Dr 1455 CATHERINE DR 1455 CATHERINE DR 1455.0 CATHERINE DR     Berkeley 94702 37.87776207025217 -122.28456034783208
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
38250 38250 38250 059 228608600 1460 Catherine Dr 1460 CATHERINE DR 1460 CATHERINE DR 1460.0 CATHERINE DR     Berkeley 94702 37.87770280412247 -122.2839892250256
43517 43517 43517 059 228607500 1441 Catherine Dr 1441 CATHERINE DR 1441 CATHERINE DR 1441.0 CATHERINE DR     Berkeley 94702 37.87747687638277 -122.28456383599033
45733 45733 45733 059 228607700 1421 Catherine Dr 1421 CATHERINE DR 1421 CATHERINE DR 1421.0 CATHERINE DR     Berkeley 94702 37.877212508090125 -122.2844794392694
46851 46851 46851 059 228607200 1461 Catherine Dr 1461 CATHERINE DR 1461 CATHERINE DR 1461.0 CATHERINE DR     Berkeley 94702 37.8778929683612 -122.28448217823268
50402 50402 50402 059 228607100 1465 Catherine Dr 1465 CATHERINE DR 1465 CATHERINE DR 1465.0 CATHERINE DR     Berkeley 94702 37.87791783718877 -122.28428688179496
57966 57966 57966 059 228607400 1451 Catherine Dr 1451 CATHERINE DR 1451 CATHERINE DR 1451.0 CATHERINE DR     Berkeley 94702 37.87761333404373 -122.28458420439108

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