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

18 rows where street_name = "BERRYMAN" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

  • 94703 · 18 ✖

street_type 1

street_name 1

  • BERRYMAN · 18 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
941 941 941 060 244601700 1845 Berryman St 1 1845 BERRYMAN ST 1 1845 BERRYMAN ST 1845.0 BERRYMAN ST 1   Berkeley 94703 37.883450489854674 -122.27450819980275
3341 3341 3341 060 244501200 1808 Berryman St 1808 BERRYMAN ST 1808 BERRYMAN ST 1808.0 BERRYMAN ST     Berkeley 94703 37.88281441970109 -122.27591301129524
9067 9067 9067 060 244601700 1845 Berryman St 3 1845 BERRYMAN ST 3 1845 BERRYMAN ST 1845.0 BERRYMAN ST 3   Berkeley 94703 37.883450489854674 -122.27450819980275
11998 11998 11998 060 244700200 1830 Berryman St 1830 BERRYMAN ST 1830 BERRYMAN ST 1830.0 BERRYMAN ST     Berkeley 94703 37.88294335905216 -122.27507829224166
15523 15523 15523 060 244700300 1834 Berryman St 1834 BERRYMAN ST 1834 BERRYMAN ST 1834.0 BERRYMAN ST     Berkeley 94703 37.88296273063548 -122.27492969292734
16410 16410 16410 060 244602000 1837 Berryman St 1837 BERRYMAN ST 1837 BERRYMAN ST 1837.0 BERRYMAN ST     Berkeley 94703 37.88339535471833 -122.274905456381
19460 19460 19460 060 244501300 1820 Berryman St 1820 BERRYMAN ST 1820 BERRYMAN ST 1820.0 BERRYMAN ST     Berkeley 94703 37.882842973017866 -122.2756832465001
21105 21105 21105 060 244602300 1829 Berryman St 1829 BERRYMAN ST 1829 BERRYMAN ST 1829.0 BERRYMAN ST     Berkeley 94703 37.883348019323144 -122.27529510692368
21733 21733 21733 060 244602100 1833 Berryman St 1833 BERRYMAN ST 1833 BERRYMAN ST 1833.0 BERRYMAN ST     Berkeley 94703 37.88337920426464 -122.27503332976504
24888 24888 24888 060 244501100 1811 Berryman St 1811 BERRYMAN ST 1811 BERRYMAN ST 1811.0 BERRYMAN ST     Berkeley 94703 37.88321763926752 -122.2757918267668
27209 27209 27209 060 244501200 1810 Berryman St 1810 BERRYMAN ST 1810 BERRYMAN ST 1810.0 BERRYMAN ST     Berkeley 94703 37.88281441970109 -122.27591301129524
33998 33998 33998 060 244601700 1845 Berryman St 1845 BERRYMAN ST 1845 BERRYMAN ST 1845.0 BERRYMAN ST     Berkeley 94703 37.883450489854674 -122.27450819980275
44237 44237 44237 060 244601900 1841 Berryman St 1841 BERRYMAN ST 1841 BERRYMAN ST 1841.0 BERRYMAN ST     Berkeley 94703 37.883414541132225 -122.2747742313826
44755 44755 44755 060 244601800 1843 Berryman St 1843 BERRYMAN ST 1843 BERRYMAN ST 1843.0 BERRYMAN ST     Berkeley 94703 37.883432793071414 -122.27464379600336
47552 47552 47552 060 244700100 1828 Berryman St 1828 BERRYMAN ST 1828 BERRYMAN ST 1828.0 BERRYMAN ST     Berkeley 94703 37.8829244270504 -122.27523204069917
49451 49451 49451 060 244501300 1818 Berryman St 1818 BERRYMAN ST 1818 BERRYMAN ST 1818.0 BERRYMAN ST     Berkeley 94703 37.882842973017866 -122.2756832465001
52147 52147 52147 060 244601700 1845 Berryman St 2 1845 BERRYMAN ST 2 1845 BERRYMAN ST 1845.0 BERRYMAN ST 2   Berkeley 94703 37.883450489854674 -122.27450819980275
54391 54391 54391 060 244602200 1831 Berryman St 1831 BERRYMAN ST 1831 BERRYMAN ST 1831.0 BERRYMAN ST     Berkeley 94703 37.8833637557239 -122.27516378670389

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