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

16 rows where street_name = "HILL" and street_type = "CT"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, latitude, longitude

zipcode 1

street_type 1

street_name 1

  • HILL · 16 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
3202 3202 3202 058 224601200 2522 Hill Ct 2522 HILL CT 2522 HILL CT 2522.0 HILL CT     Berkeley 94708 37.87976846409461 -122.26027412103808
6085 6085 6085 058 224601505 2502 Hill Ct 2502 HILL CT 2502 HILL CT 2502.0 HILL CT     Berkeley 94708 37.8798831202058 -122.26112093051704
7911 7911 7911 058 224601700 2525 Hill Ct 2525 HILL CT 2525 HILL CT 2525.0 HILL CT     Berkeley 94708 37.879913742218825 -122.26011730213892
11704 11704 11704 058 224601300 2518 Hill Ct 2518 HILL CT 2518 HILL CT 2518.0 HILL CT     Berkeley 94708 37.879776415281086 -122.2604427240371
17249 17249 17249 058 224601600 2514 Hill Ct 2514 HILL CT 2514 HILL CT 2514.0 HILL CT     Berkeley 94708 37.8798437642211 -122.26062668822752
23451 23451 23451 058 224602100 2513 Hill Ct 2513 HILL CT 2513 HILL CT 2513.0 HILL CT     Berkeley 94708 37.88005353351789 -122.26063417748205
32137 32137 32137 058 224601900 2521 Hill Ct 2521 HILL CT 2521 HILL CT 2521.0 HILL CT     Berkeley 94708 37.880079306348655 -122.2603125383895
36512 36512 36512 058 224601506 2512 Hill Ct 2512 HILL CT 2512 HILL CT 2512.0 HILL CT     Berkeley 94708 37.87983040448111 -122.26083310670676
37614 37614 37614 058 224601300 2520 Hill Ct 2520 HILL CT 2520 HILL CT 2520.0 HILL CT     Berkeley 94708 37.879776415281086 -122.2604427240371
48855 48855 48855 058 224601506 2510 Hill Ct 2510 HILL CT 2510 HILL CT 2510.0 HILL CT     Berkeley 94708 37.87983040448111 -122.26083310670676
49475 49475 49475 058 224602300 2509 Hill Ct 2509 HILL CT 2509 HILL CT 2509.0 HILL CT     Berkeley 94708 37.880060750819005 -122.26094009695542
50222 50222 50222 058 224602000 2519 Hill Ct 2519 HILL CT 2519 HILL CT 2519.0 HILL CT     Berkeley 94708 37.88007005694594 -122.2604422640997
54036 54036 54036 058 224601505 2504 Hill Ct 2504 HILL CT 2504 HILL CT 2504.0 HILL CT     Berkeley 94708 37.8798831202058 -122.26112093051704
55473 55473 55473 058 224602100 2515 Hill Ct 2515 HILL CT 2515 HILL CT 2515.0 HILL CT     Berkeley 94708 37.88005353351789 -122.26063417748205
57106 57106 57106 058 224602400 2501 Hill Ct 2501 HILL CT 2501 HILL CT 2501.0 HILL CT     Berkeley 94708 37.880062222782456 -122.26114916456642
57273 57273 57273 058 224602201 2511 Hill Ct 2511 HILL CT 2511 HILL CT 2511.0 HILL CT     Berkeley 94708 37.88006640469008 -122.26081665585896

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