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

14 rows where street_name = "LA VEREDA" and zipcode = 94708

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

  • 94708 · 14 ✖

street_type 1

street_name 1

  • LA VEREDA · 14 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
193 193 193 058 224210300 1555 La Vereda Rd 2 1555 LA VEREDA RD 2 1555 LA VEREDA RD 1555.0 LA VEREDA RD 2   Berkeley 94708 37.88090622023778 -122.25750521599004
1925 1925 1925 058 224209900 1585 La Vereda Rd 1585 LA VEREDA RD 1585 LA VEREDA RD 1585.0 LA VEREDA RD     Berkeley 94708 37.880478942541096 -122.25681072664726
3337 3337 3337 058 224211300 1570 La Vereda Rd 1570 LA VEREDA RD 1570 LA VEREDA RD 1570.0 LA VEREDA RD     Berkeley 94708 37.88041403113483 -122.25723315581637
6032 6032 6032 058 224210100 1565 La Vereda Rd 1565 LA VEREDA RD 1565 LA VEREDA RD 1565.0 LA VEREDA RD     Berkeley 94708 37.880880303054205 -122.25719040139872
12765 12765 12765 058 224210000 1575 La Vereda Rd 1575 LA VEREDA RD 1575 LA VEREDA RD 1575.0 LA VEREDA RD     Berkeley 94708 37.880635782170955 -122.25696875737376
13620 13620 13620 058 224210400 1553 La Vereda Rd 1553 LA VEREDA RD 1553 LA VEREDA RD 1553.0 LA VEREDA RD     Berkeley 94708 37.88067972020849 -122.2575145944016
17809 17809 17809 058 224209700 1595 La Vereda Rd 1595 LA VEREDA RD 1595 LA VEREDA RD 1595.0 LA VEREDA RD     Berkeley 94708 37.8802106236346 -122.2565235684886
19225 19225 19225 058 224210300 1555 La Vereda Rd 1555 LA VEREDA RD 1555 LA VEREDA RD 1555.0 LA VEREDA RD     Berkeley 94708 37.88090622023778 -122.25750521599004
27997 27997 27997 058 224211000 1550 La Vereda Rd 1550 LA VEREDA RD 1550 LA VEREDA RD 1550.0 LA VEREDA RD     Berkeley 94708 37.88030823525434 -122.2576962598032
38038 38038 38038 058 224209406 1589 La Vereda Rd 1589 LA VEREDA RD 1589 LA VEREDA RD 1589.0 LA VEREDA RD     Berkeley 94708 37.88058302018884 -122.25657962965052
45284 45284 45284 058 224210500 1551 La Vereda Rd 1551 LA VEREDA RD 1551 LA VEREDA RD 1551.0 LA VEREDA RD     Berkeley 94708 37.880682413822264 -122.25768480718165
48813 48813 48813 058 224210300 1555 La Vereda Rd 1 1555 LA VEREDA RD 1 1555 LA VEREDA RD 1555.0 LA VEREDA RD 1   Berkeley 94708 37.88090622023778 -122.25750521599004
52214 52214 52214 058 224209800 1591 La Vereda Rd 1591 LA VEREDA RD 1591 LA VEREDA RD 1591.0 LA VEREDA RD     Berkeley 94708 37.88022458244165 -122.25670804651534
54823 54823 54823 058 224211400 1590 La Vereda Rd 1590 LA VEREDA RD 1590 LA VEREDA RD 1590.0 LA VEREDA RD     Berkeley 94708 37.88011296579807 -122.25727585364012

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