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

34 rows where street_name = "ESSEX" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

  • 94703 · 34 ✖

street_type 1

street_name 1

  • ESSEX · 34 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
58 58 58 053 159402400 2030 Essex St A 2030 ESSEX ST A 2030 ESSEX ST 2030.0 ESSEX ST A   Berkeley 94703 37.85352297506441 -122.26683968466747
2293 2293 2293 053 159600300 1910 Essex St 1910 ESSEX ST 1910 ESSEX ST 1910.0 ESSEX ST     Berkeley 94703 37.85327674051298 -122.2687556079122
2832 2832 2832 053 159401900 2020 Essex St 2020 ESSEX ST 2020 ESSEX ST 2020.0 ESSEX ST     Berkeley 94703 37.85344714656533 -122.2674241896768
4045 4045 4045 053 159402500 2034 Essex St A 2034 ESSEX ST A 2034 ESSEX ST 2034.0 ESSEX ST A   Berkeley 94703 37.8535795475978 -122.2666912739994
4700 4700 4700 053 159300900 2017 Essex St 2017 ESSEX ST 2017 ESSEX ST 2017.0 ESSEX ST     Berkeley 94703 37.85389468161126 -122.267450474382
5504 5504 5504 053 159300600 2029 Essex St 2029 ESSEX ST 2029 ESSEX ST 2029.0 ESSEX ST     Berkeley 94703 37.85394823157651 -122.26702908725862
7181 7181 7181 053 159600200 1908 Essex St 1908 ESSEX ST 1908 ESSEX ST 1908.0 ESSEX ST     Berkeley 94703 37.85325667239701 -122.26891015587032
10591 10591 10591 053 159402000 2022 Essex St 2022 ESSEX ST 2022 ESSEX ST 2022.0 ESSEX ST     Berkeley 94703 37.85346198642162 -122.26729989697746
12416 12416 12416 053 159301100 2011 Essex St A 2011 ESSEX ST A 2011 ESSEX ST 2011.0 ESSEX ST A   Berkeley 94703 37.853860114349686 -122.267719848593
13314 13314 13314 053 159600300 1912 Essex St 1912 ESSEX ST 1912 ESSEX ST 1912.0 ESSEX ST     Berkeley 94703 37.85327674051298 -122.2687556079122
13535 13535 13535 053 159402500 2036 Essex St 2036 ESSEX ST 2036 ESSEX ST 2036.0 ESSEX ST     Berkeley 94703 37.8535795475978 -122.2666912739994
13823 13823 13823 053 159401800 2012 Essex St 2012 ESSEX ST 2012 ESSEX ST 2012.0 ESSEX ST     Berkeley 94703 37.85343147966865 -122.26755289669744
14298 14298 14298 053 159300500 2035 Essex St 2035 ESSEX ST 2035 ESSEX ST 2035.0 ESSEX ST     Berkeley 94703 37.85396985001088 -122.26685820882696
15300 15300 15300 053 159402100 2024 Essex St 2024 ESSEX ST 2024 ESSEX ST 2024.0 ESSEX ST     Berkeley 94703 37.85347759302186 -122.26718157717644
17522 17522 17522 053 159301200 2007 Essex St 2007 ESSEX ST 2007 ESSEX ST 2007.0 ESSEX ST     Berkeley 94703 37.853784108165286 -122.26785661350176
17648 17648 17648 053 159402200 2026 Essex St 2026 ESSEX ST 2026 ESSEX ST 2026.0 ESSEX ST     Berkeley 94703 37.85349045961608 -122.26708142759868
22246 22246 22246 053 159301300 2001 Essex St 2001 ESSEX ST 2001 ESSEX ST 2001.0 ESSEX ST     Berkeley 94703 37.85375558756171 -122.26807853600448
25829 25829 25829 053 159402500 2034 Essex St 2034 ESSEX ST 2034 ESSEX ST 2034.0 ESSEX ST     Berkeley 94703 37.8535795475978 -122.2666912739994
29219 29219 29219 053 159401800 2012 Essex St A 2012 ESSEX ST A 2012 ESSEX ST 2012.0 ESSEX ST A   Berkeley 94703 37.85343147966865 -122.26755289669744
30212 30212 30212 053 159402400 2030 Essex St C 2030 ESSEX ST C 2030 ESSEX ST 2030.0 ESSEX ST C   Berkeley 94703 37.85352297506441 -122.26683968466747
33039 33039 33039 053 159500903 1915 Essex St 1915 ESSEX ST 1915 ESSEX ST 1915.0 ESSEX ST     Berkeley 94703 37.8538455128952 -122.26895152508578
37287 37287 37287 053 159300800 2021 Essex St 2021 ESSEX ST 2021 ESSEX ST 2021.0 ESSEX ST     Berkeley 94703 37.853910242016056 -122.2673287230166
40623 40623 40623 053 159401700 2004 Essex St 2004 ESSEX ST 2004 ESSEX ST 2004.0 ESSEX ST     Berkeley 94703 37.85341176695142 -122.26770482606648
41493 41493 41493 053 159600100 1900 Essex St A 1900 ESSEX ST A 1900 ESSEX ST 1900.0 ESSEX ST A   Berkeley 94703 37.85329381468564 -122.26916279356924
42438 42438 42438 053 159402500 2036 Essex St A 2036 ESSEX ST A 2036 ESSEX ST 2036.0 ESSEX ST A   Berkeley 94703 37.8535795475978 -122.2666912739994
44028 44028 44028 053 159402300 2028 Essex St 2028 ESSEX ST 2028 ESSEX ST 2028.0 ESSEX ST     Berkeley 94703 37.85350289353882 -122.26698476617916
44186 44186 44186 053 159301300 2003 Essex St 2003 ESSEX ST 2003 ESSEX ST 2003.0 ESSEX ST     Berkeley 94703 37.85375558756171 -122.26807853600448
45153 45153 45153 053 159600100 1900 Essex St 1900 ESSEX ST 1900 ESSEX ST 1900.0 ESSEX ST     Berkeley 94703 37.85329381468564 -122.26916279356924
52348 52348 52348 053 159301000 2013 Essex St 2013 ESSEX ST 2013 ESSEX ST 2013.0 ESSEX ST     Berkeley 94703 37.853876037918376 -122.26758775133048
52697 52697 52697 053 159300700 2025 Essex St 2025 ESSEX ST 2025 ESSEX ST 2025.0 ESSEX ST     Berkeley 94703 37.85392632303628 -122.26719748184856
54845 54845 54845 053 159402400 2030 Essex St B 2030 ESSEX ST B 2030 ESSEX ST 2030.0 ESSEX ST B   Berkeley 94703 37.85352297506441 -122.26683968466747
54984 54984 54984 053 159402400 2030 Essex St 2030 ESSEX ST 2030 ESSEX ST 2030.0 ESSEX ST     Berkeley 94703 37.85352297506441 -122.26683968466747
57287 57287 57287 053 159301100 2011 Essex St 2011 ESSEX ST 2011 ESSEX ST 2011.0 ESSEX ST     Berkeley 94703 37.853860114349686 -122.267719848593
57597 57597 57597 053 159402400 2030 Essex St D 2030 ESSEX ST D 2030 ESSEX ST 2030.0 ESSEX ST D   Berkeley 94703 37.85352297506441 -122.26683968466747

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