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

98 rows where street_name = "ESSEX"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 4

street_type 2

street_name 1

  • ESSEX · 98 ✖
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
680 680 680 056 195518201 713 Essex Way Apt 102 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 102 APT Berkeley 94710 37.8672219812204 -122.30017687632689
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
2431 2431 2431 056 195518201 713 Essex Way Apt 207 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 207 APT Berkeley 94710 37.86715448741798 -122.3000714186041
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
5838 5838 5838 056 195518201 713 Essex Way Apt 103 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 103 APT Berkeley 94710 37.86720423657004 -122.3001711702282
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
9835 9835 9835 056 195518201 713 Essex Way Apt 304 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 304 APT Berkeley 94710 37.867220768553565 -122.30000904228572
10355 10355 10355 056 195518201 713 Essex Way Apt 307 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 307 APT Berkeley 94710 37.86717354048485 -122.2999938526726
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
20700 20700 20700 056 195518201 713 Essex Way Apt 201 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 201 APT Berkeley 94710 37.867255391246665 -122.3001038729387
21163 21163 21163 056 195518201 713 Essex Way Apt 206 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 206 APT Berkeley 94710 37.867171304496 -122.30007682736044
21266 21266 21266 056 195518201 713 Essex Way Apt 302 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 302 APT Berkeley 94710 37.86725225462509 -122.30001916989222
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
21730 21730 21730 056 195518201 713 Essex Way Apt 205 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 205 APT Berkeley 94710 37.86718812157015 -122.30008223701508
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
22300 22300 22300 056 195518201 713 Essex Way Apt 202 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 202 APT Berkeley 94710 37.86723857418788 -122.30009846418234
22887 22887 22887 056 195518201 713 Essex Way Apt 303 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 303 APT Berkeley 94710 37.867236511236456 -122.30001410608898
23411 23411 23411 056 195518201 713 Essex Way Apt 204 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 204 APT Berkeley 94710 37.86720493934962 -122.3000876457714
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
24880 24880 24880 056 195518201 713 Essex Way Apt 107 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 107 APT Berkeley 94710 37.867133259344165 -122.30014834044356
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
26750 26750 26750 056 195518201 713 Essex Way Apt 106 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 106 APT Berkeley 94710 37.86715100401162 -122.30015404744056
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
32342 32342 32342 056 195518201 706 Essex Way 706 ESSEX WAY 706 ESSEX WY 706.0 ESSEX WY     Berkeley 94710 37.866952206333465 -122.30023778120484
32679 32679 32679 056 195518201 713 Essex Way Apt 105 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 105 APT Berkeley 94710 37.86716874867479 -122.30015975533588
33039 33039 33039 053 159500903 1915 Essex St 1915 ESSEX ST 1915 ESSEX ST 1915.0 ESSEX ST     Berkeley 94703 37.8538455128952 -122.26895152508578
33393 33393 33393 056 195518201 713 Essex Way 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY     Berkeley 94710 37.86723514680927 -122.29994628238671
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
41684 41684 41684 056 195518201 713 Essex Way Apt 203 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 203 APT Berkeley 94710 37.86722175641608 -122.30009305452776
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
42554 42554 42554 056 195518201 713 Essex Way Apt 101 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 101 APT Berkeley 94710 37.86723972515731 -122.3001825842222
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
47530 47530 47530 056 195518201 713 Essex Way Apt 305 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 305 APT Berkeley 94710 37.86720502586737 -122.3000039793808
47627 47627 47627 056 195518201 713 Essex Way Apt 104 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 104 APT Berkeley 94710 37.867186491915405 -122.3001654632312
48616 48616 48616 056 195518201 713 Essex Way Apt 306 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 306 APT Berkeley 94710 37.867189283177815 -122.29999891557752
50149 50149 50149 052 158502400 2130 Essex St 2130 ESSEX ST 2130 ESSEX ST 2130.0 ESSEX ST     Berkeley 94705 37.85377319642906 -122.26492908394088
50381 50381 50381 056 195518201 710 Essex Way 710 ESSEX WAY 710 ESSEX WY 710.0 ESSEX WY     Berkeley 94710 37.86697277848248 -122.30013962678532
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
54165 54165 54165 056 195518201 713 Essex Way Apt 301 713 ESSEX WAY 713 ESSEX WY 713.0 ESSEX WY 301 APT Berkeley 94710 37.86726799659207 -122.3000242336955
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);