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

10 rows where street_name = "TOMLEE" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94702 · 10 ✖

street_type 1

street_name 1

  • TOMLEE · 10 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
8050 8050 8050 059 228604200 1364 Tomlee Dr 1364 TOMLEE DR 1364 TOMLEE DR 1364.0 TOMLEE DR     Berkeley 94702 37.8769553110736 -122.28583467453792
11030 11030 11030 059 228603100 1363 Tomlee Dr 1363 TOMLEE DR 1363 TOMLEE DR 1363.0 TOMLEE DR     Berkeley 94702 37.877393427401074 -122.28573844251314
18467 18467 18467 059 228604400 1378 Tomlee Dr 1378 TOMLEE DR 1378 TOMLEE DR 1378.0 TOMLEE DR     Berkeley 94702 37.87699149765032 -122.28558420806704
40415 40415 40415 059 228604500 1380 Tomlee Dr 1380 TOMLEE DR 1380 TOMLEE DR 1380.0 TOMLEE DR     Berkeley 94702 37.87720293357526 -122.28536994549874
45631 45631 45631 059 228603200 1359 Tomlee Dr 1359 TOMLEE DR 1359 TOMLEE DR 1359.0 TOMLEE DR     Berkeley 94702 37.877353701372705 -122.2858740692564
54402 54402 54402 059 228603300 1355 Tomlee Dr 1355 TOMLEE DR 1355 TOMLEE DR 1355.0 TOMLEE DR     Berkeley 94702 37.87723714031956 -122.28596674395271
56738 56738 56738 059 228604300 1372 Tomlee Dr 1372 TOMLEE DR 1372 TOMLEE DR 1372.0 TOMLEE DR     Berkeley 94702 37.87699033336093 -122.285713115412
56878 56878 56878 059 228603000 1369 Tomlee Dr 1369 TOMLEE DR 1369 TOMLEE DR 1369.0 TOMLEE DR     Berkeley 94702 37.877448775495296 -122.28560786520006
57775 57775 57775 059 228602900 1373 Tomlee Dr 1373 TOMLEE DR 1373 TOMLEE DR 1373.0 TOMLEE DR     Berkeley 94702 37.87749399174739 -122.28547483009636
58119 58119 58119 059 228604100 1358 Tomlee Dr 1358 TOMLEE DR 1358 TOMLEE DR 1358.0 TOMLEE DR     Berkeley 94702 37.87687384902135 -122.28593728370296

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