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

74 rows where street_name = "ESSEX" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 3

street_type 1

street_name 1

  • ESSEX · 74 ✖
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
752 752 752 053 158600200 2141 Essex St 2141 ESSEX ST 2141 ESSEX ST 2141.0 ESSEX ST     Berkeley 94705 37.85428556113363 -122.26447707863932
2293 2293 2293 053 159600300 1910 Essex St 1910 ESSEX ST 1910 ESSEX ST 1910.0 ESSEX ST     Berkeley 94703 37.85327674051298 -122.2687556079122
2382 2382 2382 052 158502100 2114 Essex St 2114 ESSEX ST 2114 ESSEX ST 2114.0 ESSEX ST     Berkeley 94705 37.853714954371306 -122.26537892879408
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
5242 5242 5242 053 158600700 2127 Essex St 2127 ESSEX ST 2127 ESSEX ST 2127.0 ESSEX ST     Berkeley 94705 37.8542075488147 -122.2650805955933
5504 5504 5504 053 159300600 2029 Essex St 2029 ESSEX ST 2029 ESSEX ST 2029.0 ESSEX ST     Berkeley 94703 37.85394823157651 -122.26702908725862
6164 6164 6164 052 158502300 2128 Essex St B 2128 ESSEX ST B 2128 ESSEX ST 2128.0 ESSEX ST B   Berkeley 94705 37.85375824031166 -122.2650517192485
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
11679 11679 11679 052 158502500 2132 Essex St 2132 ESSEX ST 2132 ESSEX ST 2132.0 ESSEX ST     Berkeley 94705 37.853789716530414 -122.26480650971864
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
12738 12738 12738 052 158501900 2110 Essex St 2110 ESSEX ST 2110 ESSEX ST 2110.0 ESSEX ST     Berkeley 94705 37.8536823482183 -122.26563795441304
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
13963 13963 13963 053 159400101 2040 Essex St 2040 ESSEX ST 2040 ESSEX ST 2040.0 ESSEX ST     Berkeley 94705 37.853624292632745 -122.26651128485412
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
15810 15810 15810 016 144800400 6456 Essex St 6456 ESSEX ST 6456 ESSEX ST 6456.0 ESSEX ST     Berkeley 94702 37.84802263003311 -122.28210047851316
16322 16322 16322 053 158600900 2121 Essex St 2121 ESSEX ST 2121 ESSEX ST 2121.0 ESSEX ST     Berkeley 94705 37.85416487383473 -122.26540606600052
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
18700 18700 18700 052 158502200 2120 Essex St 2120 ESSEX ST 2120 ESSEX ST 2120.0 ESSEX ST     Berkeley 94705 37.85373849434511 -122.2652071026398
18833 18833 18833 052 158502100 2116 Essex St 2 2116 ESSEX ST 2 2116 ESSEX ST 2116.0 ESSEX ST 2   Berkeley 94705 37.853714954371306 -122.26537892879408
19135 19135 19135 053 158601000 2119 Essex St 2119 ESSEX ST 2119 ESSEX ST 2119.0 ESSEX ST     Berkeley 94705 37.85414756083389 -122.26553989341828
19531 19531 19531 016 144800500 6426 Essex St 6426 ESSEX ST 6426 ESSEX ST 6426.0 ESSEX ST     Berkeley 94702 37.84791436805661 -122.28207699295837
20352 20352 20352 052 158502400 2130 Essex St 3 2130 ESSEX ST 3 2130 ESSEX ST 2130.0 ESSEX ST 3   Berkeley 94705 37.85377319642906 -122.26492908394088
20440 20440 20440 052 158502200 2118 Essex St 2118 ESSEX ST 2118 ESSEX ST 2118.0 ESSEX ST     Berkeley 94705 37.85373849434511 -122.2652071026398
21602 21602 21602 052 158502100 2114 Essex St 1 2114 ESSEX ST 1 2114 ESSEX ST 2114.0 ESSEX ST 1   Berkeley 94705 37.853714954371306 -122.26537892879408
21762 21762 21762 052 158502300 2128 Essex St 2128 ESSEX ST 2128 ESSEX ST 2128.0 ESSEX ST     Berkeley 94705 37.85375824031166 -122.2650517192485
22246 22246 22246 053 159301300 2001 Essex St 2001 ESSEX ST 2001 ESSEX ST 2001.0 ESSEX ST     Berkeley 94703 37.85375558756171 -122.26807853600448
23960 23960 23960 052 158502400 2130 Essex St 1 2130 ESSEX ST 1 2130 ESSEX ST 2130.0 ESSEX ST 1   Berkeley 94705 37.85377319642906 -122.26492908394088
25764 25764 25764 052 158501800 2108 Essex St 2108 ESSEX ST 2108 ESSEX ST 2108.0 ESSEX ST     Berkeley 94705 37.85366925893972 -122.26574762164122
25829 25829 25829 053 159402500 2034 Essex St 2034 ESSEX ST 2034 ESSEX ST 2034.0 ESSEX ST     Berkeley 94703 37.8535795475978 -122.2666912739994
25901 25901 25901 053 158601200 2111 Essex St 2111 ESSEX ST 2111 ESSEX ST 2111.0 ESSEX ST     Berkeley 94705 37.85411452007861 -122.265792858104
27437 27437 27437 016 144800304 6468 Essex St 6468 ESSEX ST 6468 ESSEX ST 6468.0 ESSEX ST     Berkeley 94702 37.848249116961775 -122.28214252505836
27664 27664 27664 053 158600600 2129 Essex St 2129 ESSEX ST 2129 ESSEX ST 2129.0 ESSEX ST     Berkeley 94705 37.85422674637685 -122.264938067992
27706 27706 27706 016 144800600 6420 Essex St 6420 ESSEX ST 6420 ESSEX ST 6420.0 ESSEX ST     Berkeley 94702 37.84780610379306 -122.28205350560698
27915 27915 27915 053 158600400 2135 Essex St 2135 ESSEX ST 2135 ESSEX ST 2135.0 ESSEX ST     Berkeley 94705 37.85425707264196 -122.26470411345436
28636 28636 28636 052 158502600 2134 Essex St 2134 ESSEX ST 2134 ESSEX ST 2134.0 ESSEX ST     Berkeley 94705 37.853807845299904 -122.26467187112218
28913 28913 28913 052 158502100 2116 Essex St 1 2116 ESSEX ST 1 2116 ESSEX ST 2116.0 ESSEX ST 1   Berkeley 94705 37.853714954371306 -122.26537892879408
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
30106 30106 30106 053 158601100 2117 Essex St 2117 ESSEX ST 2117 ESSEX ST 2117.0 ESSEX ST     Berkeley 94705 37.854130081855615 -122.26567285216515
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
35151 35151 35151 052 158502300 2128 Essex St D 2128 ESSEX ST D 2128 ESSEX ST 2128.0 ESSEX ST D   Berkeley 94705 37.85375824031166 -122.2650517192485
37287 37287 37287 053 159300800 2021 Essex St 2021 ESSEX ST 2021 ESSEX ST 2021.0 ESSEX ST     Berkeley 94703 37.853910242016056 -122.2673287230166
40095 40095 40095 052 158502400 2130 Essex St 2 2130 ESSEX ST 2 2130 ESSEX ST 2130.0 ESSEX ST 2   Berkeley 94705 37.85377319642906 -122.26492908394088
40623 40623 40623 053 159401700 2004 Essex St 2004 ESSEX ST 2004 ESSEX ST 2004.0 ESSEX ST     Berkeley 94703 37.85341176695142 -122.26770482606648
40671 40671 40671 052 158502000 2112 Essex St 2112 ESSEX ST 2112 ESSEX ST 2112.0 ESSEX ST     Berkeley 94705 37.85369629928432 -122.265524828671
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
42037 42037 42037 053 158600500 2133 Essex St 2133 ESSEX ST 2133 ESSEX ST 2133.0 ESSEX ST     Berkeley 94705 37.85424045476379 -122.26481722482336
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
42718 42718 42718 052 158502300 2128 Essex St C 2128 ESSEX ST C 2128 ESSEX ST 2128.0 ESSEX ST C   Berkeley 94705 37.85375824031166 -122.2650517192485
42726 42726 42726 053 158600800 2125 Essex St 2125 ESSEX ST 2125 ESSEX ST 2125.0 ESSEX ST     Berkeley 94705 37.854183962887 -122.26525152522892
43061 43061 43061 052 158502100 2116 Essex St 2116 ESSEX ST 2116 ESSEX ST 2116.0 ESSEX ST     Berkeley 94705 37.853714954371306 -122.26537892879408
44028 44028 44028 053 159402300 2028 Essex St 2028 ESSEX ST 2028 ESSEX ST 2028.0 ESSEX ST     Berkeley 94703 37.85350289353882 -122.26698476617916
44140 44140 44140 052 158502300 2128 Essex St A 2128 ESSEX ST A 2128 ESSEX ST 2128.0 ESSEX ST A   Berkeley 94705 37.85375824031166 -122.2650517192485
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
50149 50149 50149 052 158502400 2130 Essex St 2130 ESSEX ST 2130 ESSEX ST 2130.0 ESSEX ST     Berkeley 94705 37.85377319642906 -122.26492908394088
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
53644 53644 53644 052 158502700 2136 Essex St 2136 ESSEX ST 2136 ESSEX ST 2136.0 ESSEX ST     Berkeley 94705 37.85382598754143 -122.26453797273751
53762 53762 53762 053 158600300 2139 Essex St 2139 ESSEX ST 2139 ESSEX ST 2139.0 ESSEX ST     Berkeley 94705 37.85427138604461 -122.26458759387718
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
55788 55788 55788 016 144800301 6460 Essex St 6460 ESSEX ST 6460 ESSEX ST 6460.0 ESSEX ST     Berkeley 94702 37.84813089256003 -122.28212396227131
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
58321 58321 58321 052 158502100 2114 Essex St 2 2114 ESSEX ST 2 2114 ESSEX ST 2114.0 ESSEX ST 2   Berkeley 94705 37.853714954371306 -122.26537892879408

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