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

69 rows where street_name = "BERRYMAN" and zipcode = 94709

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

  • 94709 · 69 ✖

street_type 1

street_name 1

  • BERRYMAN · 69 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
500 500 500 060 245100400 1990 Berryman St 1990 BERRYMAN ST 1990 BERRYMAN ST 1990.0 BERRYMAN ST     Berkeley 94709 37.883362762405774 -122.27228285814668
502 502 502 060 245501400 2033 Berryman St 2033 BERRYMAN ST 2033 BERRYMAN ST 2033.0 BERRYMAN ST     Berkeley 94709 37.883992351813575 -122.27044207717884
632 632 632 060 245508700 2043 Berryman St 1 2043 BERRYMAN ST 1 2043 BERRYMAN ST 2043.0 BERRYMAN ST 1   Berkeley 94709 37.88412173789877 -122.27015669049791
1306 1306 1306 060 244901300 1915 Berryman St B 1915 BERRYMAN ST B 1915 BERRYMAN ST 1915.0 BERRYMAN ST B   Berkeley 94709 37.88362736102886 -122.27343911927473
1814 1814 1814 060 245001701 1939 Berryman St 1939 BERRYMAN ST 1939 BERRYMAN ST 1939.0 BERRYMAN ST     Berkeley 94709 37.88373441983872 -122.27241180771244
2298 2298 2298 060 245001701 1943 Berryman St C 1943 BERRYMAN ST C 1943 BERRYMAN ST 1943.0 BERRYMAN ST C   Berkeley 94709 37.88373441983872 -122.27241180771244
2545 2545 2545 060 245100300 1936 Berryman St D 1936 BERRYMAN ST D 1936 BERRYMAN ST 1936.0 BERRYMAN ST D   Berkeley 94709 37.88328004753415 -122.27250704889548
3437 3437 3437 060 244800401 1910 Berryman St 108 1910 BERRYMAN ST 108 1910 BERRYMAN ST 1910.0 BERRYMAN ST 108   Berkeley 94709 37.88309018293481 -122.27353952397404
3562 3562 3562 060 244800401 1910 Berryman St 306 1910 BERRYMAN ST 306 1910 BERRYMAN ST 1910.0 BERRYMAN ST 306   Berkeley 94709 37.88309018293481 -122.27353952397404
3605 3605 3605 060 244901300 1915 Berryman St 1915 BERRYMAN ST 1915 BERRYMAN ST 1915.0 BERRYMAN ST     Berkeley 94709 37.88362736102886 -122.27343911927473
3755 3755 3755 060 245001701 1941 Berryman St 1941 BERRYMAN ST 1941 BERRYMAN ST 1941.0 BERRYMAN ST     Berkeley 94709 37.88373441983872 -122.27241180771244
5699 5699 5699 060 244800401 1910 Berryman St 106 1910 BERRYMAN ST 106 1910 BERRYMAN ST 1910.0 BERRYMAN ST 106   Berkeley 94709 37.88309018293481 -122.27353952397404
5947 5947 5947 060 245100300 1936 Berryman St A 1936 BERRYMAN ST A 1936 BERRYMAN ST 1936.0 BERRYMAN ST A   Berkeley 94709 37.88328004753415 -122.27250704889548
6228 6228 6228 060 245100300 1936 Berryman St 1936 BERRYMAN ST 1936 BERRYMAN ST 1936.0 BERRYMAN ST     Berkeley 94709 37.88328004753415 -122.27250704889548
6606 6606 6606 060 244901500 1909 Berryman St 1909 BERRYMAN ST 1909 BERRYMAN ST 1909.0 BERRYMAN ST     Berkeley 94709 37.88352700145112 -122.273850773152
9324 9324 9324 060 245505400 2040 Berryman St 2040 BERRYMAN ST 2040 BERRYMAN ST 2040.0 BERRYMAN ST     Berkeley 94709 37.88351977739967 -122.27024209512862
9409 9409 9409 060 245001701 1945 Berryman St A 1945 BERRYMAN ST A 1945 BERRYMAN ST 1945.0 BERRYMAN ST A   Berkeley 94709 37.88373441983872 -122.27241180771244
10198 10198 10198 060 245001701 1945 Berryman St B 1945 BERRYMAN ST B 1945 BERRYMAN ST 1945.0 BERRYMAN ST B   Berkeley 94709 37.88373441983872 -122.27241180771244
11015 11015 11015 060 244800401 1910 Berryman St 301 1910 BERRYMAN ST 301 1910 BERRYMAN ST 1910.0 BERRYMAN ST 301   Berkeley 94709 37.88309018293481 -122.27353952397404
11425 11425 11425 060 244800401 1910 Berryman St 308 1910 BERRYMAN ST 308 1910 BERRYMAN ST 1910.0 BERRYMAN ST 308   Berkeley 94709 37.88309018293481 -122.27353952397404
12068 12068 12068 060 245001801 1937 Berryman St 1937 BERRYMAN ST 1937 BERRYMAN ST 1937.0 BERRYMAN ST     Berkeley 94709 37.88367878152247 -122.27255126307548
12304 12304 12304 060 244800401 1910 Berryman St 305 1910 BERRYMAN ST 305 1910 BERRYMAN ST 1910.0 BERRYMAN ST 305   Berkeley 94709 37.88309018293481 -122.27353952397404
12341 12341 12341 060 244800401 1910 Berryman St 204 1910 BERRYMAN ST 204 1910 BERRYMAN ST 1910.0 BERRYMAN ST 204   Berkeley 94709 37.88309018293481 -122.27353952397404
12887 12887 12887 060 244800401 1910 Berryman St 208 1910 BERRYMAN ST 208 1910 BERRYMAN ST 1910.0 BERRYMAN ST 208   Berkeley 94709 37.88309018293481 -122.27353952397404
13546 13546 13546 060 244800401 1910 Berryman St 101 1910 BERRYMAN ST 101 1910 BERRYMAN ST 1910.0 BERRYMAN ST 101   Berkeley 94709 37.88309018293481 -122.27353952397404
14425 14425 14425 060 245001701 1939 Berryman St A 1939 BERRYMAN ST A 1939 BERRYMAN ST 1939.0 BERRYMAN ST A   Berkeley 94709 37.88373441983872 -122.27241180771244
15012 15012 15012 060 245300200 2010 Berryman St 2010 BERRYMAN ST 2010 BERRYMAN ST 2010.0 BERRYMAN ST     Berkeley 94709 37.88334770736022 -122.27152619550476
15946 15946 15946 060 245001701 1939 Berryman St B 1939 BERRYMAN ST B 1939 BERRYMAN ST 1939.0 BERRYMAN ST B   Berkeley 94709 37.88373441983872 -122.27241180771244
15967 15967 15967 060 244901400 1913 Berryman St A 1913 BERRYMAN ST A 1913 BERRYMAN ST 1913.0 BERRYMAN ST A   Berkeley 94709 37.88360523301221 -122.2736768467366
16537 16537 16537 060 245508700 2047 Berryman St 2047 BERRYMAN ST 2047 BERRYMAN ST 2047.0 BERRYMAN ST     Berkeley 94709 37.88412173789877 -122.27015669049791
16868 16868 16868 060 245001701 1943 Berryman St B 1943 BERRYMAN ST B 1943 BERRYMAN ST 1943.0 BERRYMAN ST B   Berkeley 94709 37.88373441983872 -122.27241180771244
18253 18253 18253 060 245100300 1936 Berryman St B 1936 BERRYMAN ST B 1936 BERRYMAN ST 1936.0 BERRYMAN ST B   Berkeley 94709 37.88328004753415 -122.27250704889548
18320 18320 18320 060 245001701 1945 Berryman St 1945 BERRYMAN ST 1945 BERRYMAN ST 1945.0 BERRYMAN ST     Berkeley 94709 37.88373441983872 -122.27241180771244
18924 18924 18924 060 244800401 1910 Berryman St 105 1910 BERRYMAN ST 105 1910 BERRYMAN ST 1910.0 BERRYMAN ST 105   Berkeley 94709 37.88309018293481 -122.27353952397404
20557 20557 20557 060 244800401 1910 Berryman St 202 1910 BERRYMAN ST 202 1910 BERRYMAN ST 1910.0 BERRYMAN ST 202   Berkeley 94709 37.88309018293481 -122.27353952397404
22474 22474 22474 060 244800401 1910 Berryman St 103 1910 BERRYMAN ST 103 1910 BERRYMAN ST 1910.0 BERRYMAN ST 103   Berkeley 94709 37.88309018293481 -122.27353952397404
22764 22764 22764 060 244901400 1913 Berryman St 1913 BERRYMAN ST 1913 BERRYMAN ST 1913.0 BERRYMAN ST     Berkeley 94709 37.88360523301221 -122.2736768467366
22891 22891 22891 060 244901400 1911 Berryman St B 1911 BERRYMAN ST B 1911 BERRYMAN ST 1911.0 BERRYMAN ST B   Berkeley 94709 37.88360523301221 -122.2736768467366
23240 23240 23240 060 245100200 1934 Berryman St 1934 BERRYMAN ST 1934 BERRYMAN ST 1934.0 BERRYMAN ST     Berkeley 94709 37.883263422729186 -122.27265133000822
23529 23529 23529 060 245501500 2031 Berryman St 2031 BERRYMAN ST 2031 BERRYMAN ST 2031.0 BERRYMAN ST     Berkeley 94709 37.88385987425369 -122.27068756428812
24682 24682 24682 060 244800401 1910 Berryman St 206 1910 BERRYMAN ST 206 1910 BERRYMAN ST 1910.0 BERRYMAN ST 206   Berkeley 94709 37.88309018293481 -122.27353952397404
24987 24987 24987 060 244901600 1905 Berryman St 1905 BERRYMAN ST 1905 BERRYMAN ST 1905.0 BERRYMAN ST     Berkeley 94709 37.883513670030446 -122.2740003597148
25327 25327 25327 060 245100300 1936 Berryman St C 1936 BERRYMAN ST C 1936 BERRYMAN ST 1936.0 BERRYMAN ST C   Berkeley 94709 37.88328004753415 -122.27250704889548
27445 27445 27445 060 245002000 1933 Berryman St 1933 BERRYMAN ST 1933 BERRYMAN ST 1933.0 BERRYMAN ST     Berkeley 94709 37.883677260001065 -122.27281722099345
29321 29321 29321 060 244800401 1910 Berryman St 1910 BERRYMAN ST 1910 BERRYMAN ST 1910.0 BERRYMAN ST     Berkeley 94709 37.88309018293481 -122.27353952397404
29952 29952 29952 060 244800401 1910 Berryman St 104 1910 BERRYMAN ST 104 1910 BERRYMAN ST 1910.0 BERRYMAN ST 104   Berkeley 94709 37.88309018293481 -122.27353952397404
30734 30734 30734 060 245001900 1935 Berryman St 1935 BERRYMAN ST 1935 BERRYMAN ST 1935.0 BERRYMAN ST     Berkeley 94709 37.883702123330565 -122.27268960003596
33927 33927 33927 060 244800401 1910 Berryman St 207 1910 BERRYMAN ST 207 1910 BERRYMAN ST 1910.0 BERRYMAN ST 207   Berkeley 94709 37.88309018293481 -122.27353952397404
35413 35413 35413 060 245200502 2005 Berryman St 2005 BERRYMAN ST 2005 BERRYMAN ST 2005.0 BERRYMAN ST     Berkeley 94709 37.88381501144761 -122.27154211634654
36016 36016 36016 060 244800401 1910 Berryman St 205 1910 BERRYMAN ST 205 1910 BERRYMAN ST 1910.0 BERRYMAN ST 205   Berkeley 94709 37.88309018293481 -122.27353952397404
39014 39014 39014 060 244901300 1915 Berryman St C 1915 BERRYMAN ST C 1915 BERRYMAN ST 1915.0 BERRYMAN ST C   Berkeley 94709 37.88362736102886 -122.27343911927473
39066 39066 39066 060 244800401 1910 Berryman St 303 1910 BERRYMAN ST 303 1910 BERRYMAN ST 1910.0 BERRYMAN ST 303   Berkeley 94709 37.88309018293481 -122.27353952397404
39345 39345 39345 060 244800401 1910 Berryman St 203 1910 BERRYMAN ST 203 1910 BERRYMAN ST 1910.0 BERRYMAN ST 203   Berkeley 94709 37.88309018293481 -122.27353952397404
40087 40087 40087 060 245001701 1945 Berryman St C 1945 BERRYMAN ST C 1945 BERRYMAN ST 1945.0 BERRYMAN ST C   Berkeley 94709 37.88373441983872 -122.27241180771244
42783 42783 42783 060 244800401 1910 Berryman St 107 1910 BERRYMAN ST 107 1910 BERRYMAN ST 1910.0 BERRYMAN ST 107   Berkeley 94709 37.88309018293481 -122.27353952397404
43296 43296 43296 060 244800401 1910 Berryman St 102 1910 BERRYMAN ST 102 1910 BERRYMAN ST 1910.0 BERRYMAN ST 102   Berkeley 94709 37.88309018293481 -122.27353952397404
43954 43954 43954 060 245508700 2045 Berryman St 2 2045 BERRYMAN ST 2 2045 BERRYMAN ST 2045.0 BERRYMAN ST 2   Berkeley 94709 37.88412173789877 -122.27015669049791
44951 44951 44951 060 244800401 1910 Berryman St 307 1910 BERRYMAN ST 307 1910 BERRYMAN ST 1910.0 BERRYMAN ST 307   Berkeley 94709 37.88309018293481 -122.27353952397404
46489 46489 46489 060 244901300 1915 Berryman St A 1915 BERRYMAN ST A 1915 BERRYMAN ST 1915.0 BERRYMAN ST A   Berkeley 94709 37.88362736102886 -122.27343911927473
47453 47453 47453 060 244901400 1913 Berryman St B 1913 BERRYMAN ST B 1913 BERRYMAN ST 1913.0 BERRYMAN ST B   Berkeley 94709 37.88360523301221 -122.2736768467366
47984 47984 47984 060 245001701 1943 Berryman St A 1943 BERRYMAN ST A 1943 BERRYMAN ST 1943.0 BERRYMAN ST A   Berkeley 94709 37.88373441983872 -122.27241180771244
48644 48644 48644 060 244800401 1910 Berryman St 302 1910 BERRYMAN ST 302 1910 BERRYMAN ST 1910.0 BERRYMAN ST 302   Berkeley 94709 37.88309018293481 -122.27353952397404
49622 49622 49622 060 245200501 2001 Berryman St 2001 BERRYMAN ST 2001 BERRYMAN ST 2001.0 BERRYMAN ST     Berkeley 94709 37.883835420780535 -122.27183432842698
50076 50076 50076 060 245002100 1931 Berryman St 1931 BERRYMAN ST 1931 BERRYMAN ST 1931.0 BERRYMAN ST     Berkeley 94709 37.88365414932025 -122.2729933375015
50707 50707 50707 060 244800100 1911 Berryman St A 1911 BERRYMAN ST A 1911 BERRYMAN ST 1911.0 BERRYMAN ST A   Berkeley 94709 37.883130363888874 -122.27401275466907
52527 52527 52527 060 244800401 1910 Berryman St 201 1910 BERRYMAN ST 201 1910 BERRYMAN ST 1910.0 BERRYMAN ST 201   Berkeley 94709 37.88309018293481 -122.27353952397404
54819 54819 54819 060 244800100 1911 Berryman St 1911 BERRYMAN ST 1911 BERRYMAN ST 1911.0 BERRYMAN ST     Berkeley 94709 37.883130363888874 -122.27401275466907
55703 55703 55703 060 244800401 1910 Berryman St 304 1910 BERRYMAN ST 304 1910 BERRYMAN ST 1910.0 BERRYMAN ST 304   Berkeley 94709 37.88309018293481 -122.27353952397404
56743 56743 56743 060 245508700 2051 Berryman St 4 2051 BERRYMAN ST 4 2051 BERRYMAN ST 2051.0 BERRYMAN ST 4   Berkeley 94709 37.88412173789877 -122.27015669049791

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