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_name = "MAYBECK TWIN" and street_type = "DR"

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

street_type 1

street_name 1

  • MAYBECK TWIN · 13 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
4577 4577 4577 058 224204324 1 Maybeck Twin Dr 1 MAYBECK TWIN DR 1 MAYBECK TWIN DR 1.0 MAYBECK TWIN DR     Berkeley 94708 37.88211274001608 -122.25741136539908
8320 8320 8320 058 224204324 1 Maybeck Twin Dr 2 1 MAYBECK TWIN DR 2 1 MAYBECK TWIN DR 1.0 MAYBECK TWIN DR 2   Berkeley 94708 37.88211274001608 -122.25741136539908
11744 11744 11744 058 224205203 15 Maybeck Twin Dr 15 MAYBECK TWIN DR 15 MAYBECK TWIN DR 15.0 MAYBECK TWIN DR     Berkeley 94708 37.8832566070402 -122.25783895628778
16909 16909 16909 058 224204832 3 Maybeck Twin Dr 3 MAYBECK TWIN DR 3 MAYBECK TWIN DR 3.0 MAYBECK TWIN DR     Berkeley 94708 37.882223025639334 -122.25772110720396
19803 19803 19803 058 224204829 5 Maybeck Twin Dr 5 MAYBECK TWIN DR 5 MAYBECK TWIN DR 5.0 MAYBECK TWIN DR     Berkeley 94708 37.882352069542215 -122.25790183117114
20938 20938 20938 058 224201623 10 Maybeck Twin Dr 10 MAYBECK TWIN DR 10 MAYBECK TWIN DR 10.0 MAYBECK TWIN DR     Berkeley 94708 37.88249022902406 -122.25739927048208
21052 21052 21052 058 224204324 1 Maybeck Twin Dr 1 1 MAYBECK TWIN DR 1 1 MAYBECK TWIN DR 1.0 MAYBECK TWIN DR 1   Berkeley 94708 37.88211274001608 -122.25741136539908
21463 21463 21463 058 224201611 14 Maybeck Twin Dr 14 MAYBECK TWIN DR 14 MAYBECK TWIN DR 14.0 MAYBECK TWIN DR     Berkeley 94708 37.88295408212675 -122.25762758180312
23544 23544 23544 058 224202514 4 Maybeck Twin Dr 4 MAYBECK TWIN DR 4 MAYBECK TWIN DR 4.0 MAYBECK TWIN DR     Berkeley 94708 37.88223015268261 -122.25678361728862
30643 30643 30643 058 224204821 9 Maybeck Twin Dr 9 MAYBECK TWIN DR 9 MAYBECK TWIN DR 9.0 MAYBECK TWIN DR     Berkeley 94708 37.88277701719323 -122.25803440813404
33298 33298 33298 058 224201624 8 Maybeck Twin Dr 8 MAYBECK TWIN DR 8 MAYBECK TWIN DR 8.0 MAYBECK TWIN DR     Berkeley 94708 37.88238013594429 -122.2571242728174
39964 39964 39964 058 224204825 7 Maybeck Twin Dr 7 MAYBECK TWIN DR 7 MAYBECK TWIN DR 7.0 MAYBECK TWIN DR     Berkeley 94708 37.88255742020837 -122.25799370816344
53249 53249 53249 058 224202534 2 Maybeck Twin Dr 2 MAYBECK TWIN DR 2 MAYBECK TWIN DR 2.0 MAYBECK TWIN DR     Berkeley 94708 37.88199176788359 -122.25686975404628

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