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

5 rows where street_name = "WOODMONT" and street_type = "CT"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • WOODMONT · 5 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
12502 12502 12502 063 310009800 1 Woodmont Ct 1 WOODMONT CT 1 WOODMONT CT 1.0 WOODMONT CT     Berkeley 94708 37.90304594614722 -122.26673324778108
13353 13353 13353 063 310009600 3 Woodmont Ct 3 WOODMONT CT 3 WOODMONT CT 3.0 WOODMONT CT     Berkeley 94708 37.9032158167702 -122.26638087462771
23559 23559 23559 063 310009500 4 Woodmont Ct 4 WOODMONT CT 4 WOODMONT CT 4.0 WOODMONT CT     Berkeley 94708 37.90313400313394 -122.26615602361716
53152 53152 53152 063 310009700 2 Woodmont Ct 2 WOODMONT CT 2 WOODMONT CT 2.0 WOODMONT CT     Berkeley 94708 37.90320507750848 -122.26662101765936
53289 53289 53289 063 310009200 5 Woodmont Ct 5 WOODMONT CT 5 WOODMONT CT 5.0 WOODMONT CT     Berkeley 94708 37.902982994668704 -122.2660278034834

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