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

11 rows where street_type = "WK" and zipcode = 94707

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, base_address, street_number, latitude, longitude

street_name 2

zipcode 1

  • 94707 · 11 ✖

street_type 1

Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
9957 9957 9957 061 256400100 10 Terrace Walk 10 TERRACE WALK 10 TERRACE WK 10.0 TERRACE WK     Berkeley 94707 37.888725731916935 -122.2719881882756
15856 15856 15856 061 256301600 21 Terrace Walk 21 TERRACE WALK 21 TERRACE WK 21.0 TERRACE WK     Berkeley 94707 37.88883351779078 -122.27157817831532
19988 19988 19988 061 257200800 1011 Fountain Walk A 1011 FOUNTAIN WALK A 1011 FOUNTAIN WK 1011.0 FOUNTAIN WK A   Berkeley 94707 37.88950495497251 -122.272191530025
22689 22689 22689 061 256400300 30 Terrace Walk 30 TERRACE WALK 30 TERRACE WK 30.0 TERRACE WK     Berkeley 94707 37.8884270571345 -122.27165098407414
23977 23977 23977 061 256301500 29 Terrace Walk 29 TERRACE WALK 29 TERRACE WK 29.0 TERRACE WK     Berkeley 94707 37.88882149180604 -122.2713876312705
33369 33369 33369 061 256301700 15 Terrace Walk 15 TERRACE WALK 15 TERRACE WK 15.0 TERRACE WK     Berkeley 94707 37.88889373346834 -122.2717132409166
35046 35046 35046 061 257200800 1011 Fountain Walk 1011 FOUNTAIN WALK 1011 FOUNTAIN WK 1011.0 FOUNTAIN WK     Berkeley 94707 37.88950495497251 -122.272191530025
44306 44306 44306 061 256400300 28 Terrace Walk 28 TERRACE WALK 28 TERRACE WK 28.0 TERRACE WK     Berkeley 94707 37.8884270571345 -122.27165098407414
45584 45584 45584 061 256400200 20 Terrace Walk 20 TERRACE WALK 20 TERRACE WK 20.0 TERRACE WK     Berkeley 94707 37.88855358045985 -122.27176397776384
48486 48486 48486 061 256000202 70 Terrace Walk 70 TERRACE WALK 70 TERRACE WK 70.0 TERRACE WK     Berkeley 94707 37.88807775424556 -122.27045974165058
50355 50355 50355 061 255901300 81 Terrace Walk 81 TERRACE WALK 81 TERRACE WK 81.0 TERRACE WK     Berkeley 94707 37.88837053971076 -122.27019947276332

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