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

13 rows where street_type = "CT" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn, latitude, longitude

street_name 2

zipcode 1

  • 94703 · 13 ✖

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
737 737 737 060 243202701 1363 Miramonte Ct 1363 MIRAMONTE CT 1363 MIRAMONTE CT 1363.0 MIRAMONTE CT     Berkeley 94703 37.87988751129032 -122.28191008597858
1604 1604 1604 060 243202800 1359 Miramonte Ct 1359 MIRAMONTE CT 1359 MIRAMONTE CT 1359.0 MIRAMONTE CT     Berkeley 94703 37.880028130087226 -122.28191461797918
6771 6771 6771 059 227802900 1535 Comstock Ct 1535 COMSTOCK CT 1535 COMSTOCK CT 1535.0 COMSTOCK CT     Berkeley 94703 37.8776197085095 -122.27943069267528
12556 12556 12556 060 243202401 1366 Miramonte Ct 1366 MIRAMONTE CT 1366 MIRAMONTE CT 1366.0 MIRAMONTE CT     Berkeley 94703 37.8795985953768 -122.28220528316074
13705 13705 13705 060 243202300 1362 Miramonte Ct 1362 MIRAMONTE CT 1362 MIRAMONTE CT 1362.0 MIRAMONTE CT     Berkeley 94703 37.87971759463222 -122.28227625006818
21548 21548 21548 060 243202501 1367 Miramonte Ct 1367 MIRAMONTE CT 1367 MIRAMONTE CT 1367.0 MIRAMONTE CT     Berkeley 94703 37.87961275637696 -122.2820096211087
26553 26553 26553 060 243202601 1365 Miramonte Ct 1365 MIRAMONTE CT 1365 MIRAMONTE CT 1365.0 MIRAMONTE CT     Berkeley 94703 37.87977482348395 -122.28183715445562
28915 28915 28915 059 227800300 1526 Comstock Ct 1526 COMSTOCK CT 1526 COMSTOCK CT 1526.0 COMSTOCK CT     Berkeley 94703 37.87766663703984 -122.2799461864095
31730 31730 31730 059 227800400 1530 Comstock Ct 1530 COMSTOCK CT 1530 COMSTOCK CT 1530.0 COMSTOCK CT     Berkeley 94703 37.87754979427507 -122.2799272553132
33500 33500 33500 060 243202200 1358 Miramonte Ct 1358 MIRAMONTE CT 1358 MIRAMONTE CT 1358.0 MIRAMONTE CT     Berkeley 94703 37.87986860119231 -122.28229830460674
38245 38245 38245 059 227800500 1534 Comstock Ct 1534 COMSTOCK CT 1534 COMSTOCK CT 1534.0 COMSTOCK CT     Berkeley 94703 37.87744280518096 -122.27990920366756
52449 52449 52449 059 227802800 1537 Comstock Ct 1537 COMSTOCK CT 1537 COMSTOCK CT 1537.0 COMSTOCK CT     Berkeley 94703 37.87751085042728 -122.27940908010788
54408 54408 54408 059 227800500 1536 Comstock Ct 1536 COMSTOCK CT 1536 COMSTOCK CT 1536.0 COMSTOCK CT     Berkeley 94703 37.87744280518096 -122.27990920366756

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