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

31 rows where street_name = "PARKER" and zipcode = 94710

✎ View and edit SQL

This data as json, CSV (advanced)

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

zipcode 1

  • 94710 · 31 ✖

street_type 1

street_name 1

  • PARKER · 31 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
563 563 563 054 176600100 918 Parker St 13 918 PARKER ST 13 918 PARKER ST 918.0 PARKER ST 13   Berkeley 94710 37.85843022323249 -122.2927536560614
4497 4497 4497 054 177700200 915 Parker St 915 PARKER ST 915 PARKER ST 915.0 PARKER ST     Berkeley 94710 37.85886925825648 -122.2930381489186
4849 4849 4849 054 176500200 950 Parker St 950 PARKER ST 950 PARKER ST 950.0 PARKER ST     Berkeley 94710 37.85850344509246 -122.29142180304136
6671 6671 6671 054 176600100 918 Parker St 918 PARKER ST 918 PARKER ST 918.0 PARKER ST     Berkeley 94710 37.858348808785195 -122.2929871210172
7130 7130 7130 054 176600100 918 Parker St 5 918 PARKER ST 5 918 PARKER ST 918.0 PARKER ST 5   Berkeley 94710 37.85841926466444 -122.29252340258272
8367 8367 8367 054 176600100 918 Parker St 1A 918 PARKER ST 1A 918 PARKER ST 918.0 PARKER ST 1A   Berkeley 94710 37.858344961827974 -122.29288329463498
8500 8500 8500 054 176600100 918 Parker St 2 918 PARKER ST 2 918 PARKER ST 918.0 PARKER ST 2   Berkeley 94710 37.858187867641206 -122.2928298565537
8544 8544 8544 054 176500200 948 Parker St 948 PARKER ST 948 PARKER ST 948.0 PARKER ST     Berkeley 94710 37.85850344509246 -122.29142180304136
10947 10947 10947 054 176600100 918 Parker St 4 918 PARKER ST 4 918 PARKER ST 918.0 PARKER ST 4   Berkeley 94710 37.85840421090432 -122.2925963224276
12866 12866 12866 054 176600100 918 Parker St A21 918 PARKER ST A21 918 PARKER ST 918.0 PARKER ST A21   Berkeley 94710 37.858187867641206 -122.2928298565537
12980 12980 12980 054 176600100 918 Parker St 1B 918 PARKER ST 1B 918 PARKER ST 918.0 PARKER ST 1B   Berkeley 94710 37.85836055959277 -122.29280774811625
13454 13454 13454 054 176300100 1050 Parker St 1050 PARKER ST 1050 PARKER ST 1050.0 PARKER ST     Berkeley 94710 37.85841494464343 -122.28952273668295
19496 19496 19496 054 176600100 918 Parker St A14 918 PARKER ST A14 918 PARKER ST 918.0 PARKER ST A14   Berkeley 94710 37.858187867641206 -122.2928298565537
20588 20588 20588 054 176600100 918 Parker St 22 918 PARKER ST 22 918 PARKER ST 918.0 PARKER ST 22   Berkeley 94710 37.85847270424679 -122.29254789964052
25506 25506 25506 054 176600100 918 Parker St 3 918 PARKER ST 3 918 PARKER ST 918.0 PARKER ST 3   Berkeley 94710 37.858390295482366 -122.2926637194301
26478 26478 26478 054 177000800 710 Parker St 710 PARKER ST 710 PARKER ST 710.0 PARKER ST     Berkeley 94710 37.8574983880525 -122.29734743111692
30314 30314 30314 054 176600100 918 Parker St 11 918 PARKER ST 11 918 PARKER ST 918.0 PARKER ST 11   Berkeley 94710 37.858415560978706 -122.2928246741728
32309 32309 32309 054 177700200 905 Parker St 905 PARKER ST 905 PARKER ST 905.0 PARKER ST     Berkeley 94710 37.85886925825648 -122.2930381489186
33100 33100 33100 054 177700200 927 Parker St 927 PARKER ST 927 PARKER ST 927.0 PARKER ST     Berkeley 94710 37.85886925825648 -122.2930381489186
34196 34196 34196 054 176600100 918 Parker St 21 918 PARKER ST 21 918 PARKER ST 918.0 PARKER ST 21   Berkeley 94710 37.85845873067955 -122.29261557961232
35108 35108 35108 054 176600100 910 Parker St 910 PARKER ST 910 PARKER ST 910.0 PARKER ST     Berkeley 94710 37.858187867641206 -122.2928298565537
35168 35168 35168 054 176500100 932 Parker St 6 932 PARKER ST 6 932 PARKER ST 932.0 PARKER ST 6   Berkeley 94710 37.85804145655631 -122.29171162919646
36051 36051 36051 054 177901206 1005 Parker St 1005 PARKER ST 1005 PARKER ST 1005.0 PARKER ST     Berkeley 94710 37.85921133847341 -122.29075649816556
37447 37447 37447 054 176600100 918 Parker St 14 918 PARKER ST 14 918 PARKER ST 918.0 PARKER ST 14   Berkeley 94710 37.858444803919966 -122.2926830332087
37742 37742 37742 054 176600100 918 Parker St 1C 918 PARKER ST 1C 918 PARKER ST 918.0 PARKER ST 1C   Berkeley 94710 37.85837611692713 -122.2927323965319
45842 45842 45842 054 177700200 901 Parker St 901 PARKER ST 901 PARKER ST 901.0 PARKER ST     Berkeley 94710 37.85886925825648 -122.2930381489186
48012 48012 48012 054 176500100 932 Parker St 932 PARKER ST 932 PARKER ST 932.0 PARKER ST     Berkeley 94710 37.85804145655631 -122.29171162919646
48117 48117 48117 054 177700200 921 Parker St 921 PARKER ST 921 PARKER ST 921.0 PARKER ST     Berkeley 94710 37.85886925825648 -122.2930381489186
49048 49048 49048 054 177300202 801 Parker St 801 PARKER ST 801 PARKER ST 801.0 PARKER ST     Berkeley 94710 37.85877139765565 -122.29486749612953
53720 53720 53720 054 177000700 820 Parker St 820 PARKER ST 820 PARKER ST 820.0 PARKER ST     Berkeley 94710 37.85781930770744 -122.29500821721876
57732 57732 57732 054 177000401 830 Parker St 830 PARKER ST 830 PARKER ST 830.0 PARKER ST     Berkeley 94710 37.858023521034774 -122.2943783230331

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