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

17 rows where street_type = "CT" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, latitude, longitude

street_name 2

zipcode 1

  • 94702 · 17 ✖

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
3318 3318 3318 054 173401200 2725 Sojourner Truth Ct 2725 SOJOURNER TRUTH CT 2725 SOJOURNER TRUTH CT 2725.0 SOJOURNER TRUTH CT     Berkeley 94702 37.85719176068595 -122.28058272633164
3756 3756 3756 054 173401200 2735 Sojourner Truth Ct 2735 SOJOURNER TRUTH CT 2735 SOJOURNER TRUTH CT 2735.0 SOJOURNER TRUTH CT     Berkeley 94702 37.85719176068595 -122.28058272633164
13435 13435 13435 056 199804000 1423 Acroft Ct 1423 ACROFT CT 1423 ACROFT CT 1423.0 ACROFT CT     Berkeley 94702 37.86635652137864 -122.28278007468684
25201 25201 25201 056 199803700 1412 Acroft Ct 1412 ACROFT CT 1412 ACROFT CT 1412.0 ACROFT CT     Berkeley 94702 37.86593254559417 -122.28308554859584
29206 29206 29206 054 173401200 2729 Sojourner Truth Ct 2729 SOJOURNER TRUTH CT 2729 SOJOURNER TRUTH CT 2729.0 SOJOURNER TRUTH CT     Berkeley 94702 37.85719176068595 -122.28058272633164
30095 30095 30095 056 199804100 1419 Acroft Ct 1419 ACROFT CT 1419 ACROFT CT 1419.0 ACROFT CT     Berkeley 94702 37.86632600365128 -122.28292670130077
32352 32352 32352 056 199803900 1420 Acroft Ct 1420 ACROFT CT 1420 ACROFT CT 1420.0 ACROFT CT     Berkeley 94702 37.865963374102705 -122.28276496502376
37267 37267 37267 054 173401200 2731 Sojourner Truth Ct 2731 SOJOURNER TRUTH CT 2731 SOJOURNER TRUTH CT 2731.0 SOJOURNER TRUTH CT     Berkeley 94702 37.85719176068595 -122.28058272633164
38398 38398 38398 056 199804200 1415 Acroft Ct 1415 ACROFT CT 1415 ACROFT CT 1415.0 ACROFT CT     Berkeley 94702 37.86630697731374 -122.28306775027512
38961 38961 38961 056 199803500 1404 Acroft Ct 1404 ACROFT CT 1404 ACROFT CT 1404.0 ACROFT CT     Berkeley 94702 37.86588866187696 -122.28340930232255
39154 39154 39154 054 173401200 2727 Sojourner Truth Ct 2727 SOJOURNER TRUTH CT 2727 SOJOURNER TRUTH CT 2727.0 SOJOURNER TRUTH CT     Berkeley 94702 37.85719176068595 -122.28058272633164
39902 39902 39902 056 199803600 1408 Acroft Ct 1408 ACROFT CT 1408 ACROFT CT 1408.0 ACROFT CT     Berkeley 94702 37.86591058813699 -122.2832495791701
42667 42667 42667 054 173401200 2737 Sojourner Truth Ct 2737 SOJOURNER TRUTH CT 2737 SOJOURNER TRUTH CT 2737.0 SOJOURNER TRUTH CT     Berkeley 94702 37.85719176068595 -122.28058272633164
46842 46842 46842 054 173401200 2733 Sojourner Truth Ct 2733 SOJOURNER TRUTH CT 2733 SOJOURNER TRUTH CT 2733.0 SOJOURNER TRUTH CT     Berkeley 94702 37.85719176068595 -122.28058272633164
48567 48567 48567 056 199803800 1416 Acroft Ct 1416 ACROFT CT 1416 ACROFT CT 1416.0 ACROFT CT     Berkeley 94702 37.86595208263371 -122.28293017778095
53067 53067 53067 056 199804300 1411 Acroft Ct 1411 ACROFT CT 1411 ACROFT CT 1411.0 ACROFT CT     Berkeley 94702 37.86628583551466 -122.28320755148953
54272 54272 54272 056 199803400 1400 Acroft Ct 1400 ACROFT CT 1400 ACROFT CT 1400.0 ACROFT CT     Berkeley 94702 37.86586612926579 -122.28356988965432

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