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

35 rows where street_name = "ESSEX" and zipcode = 94705

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

  • 94705 · 35 ✖

street_type 1

street_name 1

  • ESSEX · 35 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
752 752 752 053 158600200 2141 Essex St 2141 ESSEX ST 2141 ESSEX ST 2141.0 ESSEX ST     Berkeley 94705 37.85428556113363 -122.26447707863932
2382 2382 2382 052 158502100 2114 Essex St 2114 ESSEX ST 2114 ESSEX ST 2114.0 ESSEX ST     Berkeley 94705 37.853714954371306 -122.26537892879408
5242 5242 5242 053 158600700 2127 Essex St 2127 ESSEX ST 2127 ESSEX ST 2127.0 ESSEX ST     Berkeley 94705 37.8542075488147 -122.2650805955933
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
11679 11679 11679 052 158502500 2132 Essex St 2132 ESSEX ST 2132 ESSEX ST 2132.0 ESSEX ST     Berkeley 94705 37.853789716530414 -122.26480650971864
12738 12738 12738 052 158501900 2110 Essex St 2110 ESSEX ST 2110 ESSEX ST 2110.0 ESSEX ST     Berkeley 94705 37.8536823482183 -122.26563795441304
13963 13963 13963 053 159400101 2040 Essex St 2040 ESSEX ST 2040 ESSEX ST 2040.0 ESSEX ST     Berkeley 94705 37.853624292632745 -122.26651128485412
16322 16322 16322 053 158600900 2121 Essex St 2121 ESSEX ST 2121 ESSEX ST 2121.0 ESSEX ST     Berkeley 94705 37.85416487383473 -122.26540606600052
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
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
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
25901 25901 25901 053 158601200 2111 Essex St 2111 ESSEX ST 2111 ESSEX ST 2111.0 ESSEX ST     Berkeley 94705 37.85411452007861 -122.265792858104
27664 27664 27664 053 158600600 2129 Essex St 2129 ESSEX ST 2129 ESSEX ST 2129.0 ESSEX ST     Berkeley 94705 37.85422674637685 -122.264938067992
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
30106 30106 30106 053 158601100 2117 Essex St 2117 ESSEX ST 2117 ESSEX ST 2117.0 ESSEX ST     Berkeley 94705 37.854130081855615 -122.26567285216515
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
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
40671 40671 40671 052 158502000 2112 Essex St 2112 ESSEX ST 2112 ESSEX ST 2112.0 ESSEX ST     Berkeley 94705 37.85369629928432 -122.265524828671
42037 42037 42037 053 158600500 2133 Essex St 2133 ESSEX ST 2133 ESSEX ST 2133.0 ESSEX ST     Berkeley 94705 37.85424045476379 -122.26481722482336
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
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
50149 50149 50149 052 158502400 2130 Essex St 2130 ESSEX ST 2130 ESSEX ST 2130.0 ESSEX ST     Berkeley 94705 37.85377319642906 -122.26492908394088
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
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);