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

19 rows where street_type = "CT" and zipcode = 94706

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

  • 94706 · 19 ✖

street_type 1

street_name 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
5765 5765 5765 060 242904200 32 Hopkins Ct 32 HOPKINS CT 32 HOPKINS CT 32.0 HOPKINS CT     Berkeley 94706 37.881514785390465 -122.2830895308275
5938 5938 5938 060 242903600 7 Hopkins Ct 7 HOPKINS CT 7 HOPKINS CT 7.0 HOPKINS CT     Berkeley 94706 37.88231548925881 -122.28333753860947
13002 13002 13002 060 242904000 24 Hopkins Ct 24 HOPKINS CT 24 HOPKINS CT 24.0 HOPKINS CT     Berkeley 94706 37.88171291061746 -122.2832665016334
15269 15269 15269 060 242903900 20 Hopkins Ct 20 HOPKINS CT 20 HOPKINS CT 20.0 HOPKINS CT     Berkeley 94706 37.88184359892512 -122.28325457200644
16749 16749 16749 060 242905700 8 Hopkins Ct 8 HOPKINS CT 8 HOPKINS CT 8.0 HOPKINS CT     Berkeley 94706 37.88180210274309 -122.28346185825828
19083 19083 19083 060 242903800 12 Hopkins Ct 12 HOPKINS CT 12 HOPKINS CT 12.0 HOPKINS CT     Berkeley 94706 37.88195661113349 -122.28329408081098
25143 25143 25143 060 242903200 23 Hopkins Ct 23 HOPKINS CT 23 HOPKINS CT 23.0 HOPKINS CT     Berkeley 94706 37.88205082069253 -122.28284265671944
29849 29849 29849 060 242904100 28 Hopkins Ct 28 HOPKINS CT 28 HOPKINS CT 28.0 HOPKINS CT     Berkeley 94706 37.88163375815218 -122.28317712465254
31056 31056 31056 060 242903000 31 Hopkins Ct 31 HOPKINS CT 31 HOPKINS CT 31.0 HOPKINS CT     Berkeley 94706 37.881825326030416 -122.28280409204427
37778 37778 37778 060 242903500 11 Hopkins Ct 11 HOPKINS CT 11 HOPKINS CT 11.0 HOPKINS CT     Berkeley 94706 37.88233621239253 -122.28311409076738
38154 38154 38154 060 242905501 4 Hopkins Ct 4 HOPKINS CT 4 HOPKINS CT 4.0 HOPKINS CT     Berkeley 94706 37.88167736022657 -122.28357915936974
41036 41036 41036 060 242903800 16 Hopkins Ct 16 HOPKINS CT 16 HOPKINS CT 16.0 HOPKINS CT     Berkeley 94706 37.88195661113349 -122.28329408081098
46352 46352 46352 060 242903701 3 Hopkins Ct 3 HOPKINS CT 3 HOPKINS CT 3.0 HOPKINS CT     Berkeley 94706 37.88226522847419 -122.28345193906088
48506 48506 48506 060 242905501 2 Hopkins Ct 2 HOPKINS CT 2 HOPKINS CT 2.0 HOPKINS CT     Berkeley 94706 37.88167736022657 -122.28357915936974
51521 51521 51521 060 242902900 35 Hopkins Ct 35 HOPKINS CT 35 HOPKINS CT 35.0 HOPKINS CT     Berkeley 94706 37.88166254377721 -122.28276302376445
56675 56675 56675 060 242903100 27 Hopkins Ct 27 HOPKINS CT 27 HOPKINS CT 27.0 HOPKINS CT     Berkeley 94706 37.881931789046845 -122.28284031840477
57285 57285 57285 060 242903400 15 Hopkins Ct A 15 HOPKINS CT A 15 HOPKINS CT 15.0 HOPKINS CT A   Berkeley 94706 37.88230002206044 -122.28297704109268
57454 57454 57454 060 242903300 19 Hopkins Ct 19 HOPKINS CT 19 HOPKINS CT 19.0 HOPKINS CT     Berkeley 94706 37.882191710458024 -122.2828656419126
57534 57534 57534 060 242903400 15 Hopkins Ct 15 HOPKINS CT 15 HOPKINS CT 15.0 HOPKINS CT     Berkeley 94706 37.88230002206044 -122.28297704109268

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