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

9 rows where street_name = "HILLCREST" and street_type = "CT"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • HILLCREST · 9 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
6423 6423 6423 064 424700800 12 Hillcrest Ct 12 HILLCREST CT 12 HILLCREST CT 12.0 HILLCREST CT     Berkeley 94705 37.85357814958102 -122.24780494973564
13702 13702 13702 064 424700600 18 Hillcrest Ct 18 HILLCREST CT 18 HILLCREST CT 18.0 HILLCREST CT     Berkeley 94705 37.85375442361445 -122.24739649206415
16490 16490 16490 064 424700700 16 Hillcrest Ct 16 HILLCREST CT 16 HILLCREST CT 16.0 HILLCREST CT     Berkeley 94705 37.8537649182901 -122.24769370776076
17564 17564 17564 064 425002200 5 Hillcrest Ct 5 HILLCREST CT 5 HILLCREST CT 5.0 HILLCREST CT     Berkeley 94705 37.853302076563736 -122.24711317510166
30342 30342 30342 064 424700900 10 Hillcrest Ct 10 HILLCREST CT 10 HILLCREST CT 10.0 HILLCREST CT     Berkeley 94705 37.85339428141503 -122.24781540432892
32870 32870 32870 064 425002300 9 Hillcrest Ct 9 HILLCREST CT 9 HILLCREST CT 9.0 HILLCREST CT     Berkeley 94705 37.85343242444899 -122.24712227503548
33128 33128 33128 064 424701101 2 Hillcrest Ct 2 HILLCREST CT 2 HILLCREST CT 2.0 HILLCREST CT     Berkeley 94705 37.85303483185944 -122.24768601818192
42177 42177 42177 064 424701000 6 Hillcrest Ct 6 HILLCREST CT 6 HILLCREST CT 6.0 HILLCREST CT     Berkeley 94705 37.85326047067831 -122.24773614956467
54316 54316 54316 064 425002400 15 Hillcrest Ct 15 HILLCREST CT 15 HILLCREST CT 15.0 HILLCREST CT     Berkeley 94705 37.85362769440049 -122.2471972978364

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