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

54 rows where street_name = "PARK HILLS"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • PARK HILLS · 54 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
546 546 546 063 314009800 1076 Park Hills Rd 1076 PARK HILLS RD 1076 PARK HILLS RD 1076.0 PARK HILLS RD     Berkeley 94708 37.892324212374135 -122.2544970087335
1076 1076 1076 063 315005800 1120 Park Hills Rd 1120 PARK HILLS RD 1120 PARK HILLS RD 1120.0 PARK HILLS RD     Berkeley 94708 37.891541164007336 -122.25308336231024
7273 7273 7273 063 314009900 1080 Park Hills Rd 1080 PARK HILLS RD 1080 PARK HILLS RD 1080.0 PARK HILLS RD     Berkeley 94708 37.89221728586065 -122.25432807425612
9056 9056 9056 063 315005300 1145 Park Hills Rd 1145 PARK HILLS RD 1145 PARK HILLS RD 1145.0 PARK HILLS RD     Berkeley 94708 37.89185321774691 -122.25166142713184
9520 9520 9520 063 316001000 1154 Park Hills Rd 1154 PARK HILLS RD 1154 PARK HILLS RD 1154.0 PARK HILLS RD     Berkeley 94708 37.89161761899019 -122.2510903492411
10200 10200 10200 063 314007000 1058 Park Hills Rd 1058 PARK HILLS RD 1058 PARK HILLS RD 1058.0 PARK HILLS RD     Berkeley 94708 37.893229651046006 -122.2546770176417
11731 11731 11731 063 315006100 1108 Park Hills Rd 1108 PARK HILLS RD 1108 PARK HILLS RD 1108.0 PARK HILLS RD     Berkeley 94708 37.89185660073574 -122.25363411941096
12660 12660 12660 063 314004501 1053 Park Hills Rd 1053 PARK HILLS RD 1053 PARK HILLS RD 1053.0 PARK HILLS RD     Berkeley 94708 37.89357699630059 -122.25425765981257
13692 13692 13692 063 314004702 1061 Park Hills Rd 1061 PARK HILLS RD 1061 PARK HILLS RD 1061.0 PARK HILLS RD     Berkeley 94708 37.89326313009263 -122.25415948922335
15471 15471 15471 063 314004900 1067 Park Hills Rd 1067 PARK HILLS RD 1067 PARK HILLS RD 1067.0 PARK HILLS RD     Berkeley 94708 37.89293018778977 -122.2541757298654
16612 16612 16612 063 315005600 1130 Park Hills Rd 1130 PARK HILLS RD 1130 PARK HILLS RD 1130.0 PARK HILLS RD     Berkeley 94708 37.89136893831514 -122.25268270830362
16753 16753 16753 063 315004500 1103 Park Hills Rd 1103 PARK HILLS RD 1103 PARK HILLS RD 1103.0 PARK HILLS RD     Berkeley 94708 37.8923516979146 -122.2537055103232
18815 18815 18815 063 314005700 1044 Park Hills Rd 1044 PARK HILLS RD 1044 PARK HILLS RD 1044.0 PARK HILLS RD     Berkeley 94708 37.893858218208734 -122.25508403890709
19066 19066 19066 063 315005100 1131 Park Hills Rd 1131 PARK HILLS RD 1131 PARK HILLS RD 1131.0 PARK HILLS RD     Berkeley 94708 37.891734228176254 -122.25234452404018
19170 19170 19170 063 314005100 1075 Park Hills Rd 1075 PARK HILLS RD 1075 PARK HILLS RD 1075.0 PARK HILLS RD     Berkeley 94708 37.89260283663176 -122.25405930191636
19303 19303 19303 063 315004800 1119 Park Hills Rd 1119 PARK HILLS RD 1119 PARK HILLS RD 1119.0 PARK HILLS RD     Berkeley 94708 37.89188768566018 -122.25291844150551
19440 19440 19440 063 313002100 1016 Park Hills Rd 1016 PARK HILLS RD 1016 PARK HILLS RD 1016.0 PARK HILLS RD     Berkeley 94708 37.89521295523441 -122.2559432954426
19545 19545 19545 063 315006200 1104 Park Hills Rd 1104 PARK HILLS RD 1104 PARK HILLS RD 1104.0 PARK HILLS RD     Berkeley 94708 37.891955375150246 -122.25381859833598
20403 20403 20403 063 316000200 1169 Park Hills Rd 1169 PARK HILLS RD 1169 PARK HILLS RD 1169.0 PARK HILLS RD     Berkeley 94708 37.892068119463886 -122.25004718151573
21010 21010 21010 063 314004800 1065 Park Hills Rd 1065 PARK HILLS RD 1065 PARK HILLS RD 1065.0 PARK HILLS RD     Berkeley 94708 37.89309570776845 -122.25415329983107
22516 22516 22516 063 314005000 1071 Park Hills Rd 1071 PARK HILLS RD 1071 PARK HILLS RD 1071.0 PARK HILLS RD     Berkeley 94708 37.892769785812064 -122.2541485360651
22785 22785 22785 063 314005401 1032 Park Hills Rd 1032 PARK HILLS RD 1032 PARK HILLS RD 1032.0 PARK HILLS RD     Berkeley 94708 37.89452932884248 -122.25555550531088
23073 23073 23073 063 313001800 1004 Park Hills Rd 1004 PARK HILLS RD 1004 PARK HILLS RD 1004.0 PARK HILLS RD     Berkeley 94708 37.89565293223843 -122.25612052406504
23312 23312 23312 063 315004600 1107 Park Hills Rd 1107 PARK HILLS RD 1107 PARK HILLS RD 1107.0 PARK HILLS RD     Berkeley 94708 37.89227477864211 -122.25348612196784
23889 23889 23889 063 314004600 1055 Park Hills Rd 1055 PARK HILLS RD 1055 PARK HILLS RD 1055.0 PARK HILLS RD     Berkeley 94708 37.89342403999249 -122.25419112519272
25050 25050 25050 063 313001700 1002 Park Hills Rd 1002 PARK HILLS RD 1002 PARK HILLS RD 1002.0 PARK HILLS RD     Berkeley 94708 37.89586577276488 -122.2561930926686
25133 25133 25133 063 315005900 1118 Park Hills Rd 1118 PARK HILLS RD 1118 PARK HILLS RD 1118.0 PARK HILLS RD     Berkeley 94708 37.89163958012808 -122.25327209026658
25686 25686 25686 063 314007100 1062 Park Hills Rd 1062 PARK HILLS RD 1062 PARK HILLS RD 1062.0 PARK HILLS RD     Berkeley 94708 37.89304309011605 -122.25470131257856
27037 27037 27037 063 316000900 1158 Park Hills Rd 1158 PARK HILLS RD 1158 PARK HILLS RD 1158.0 PARK HILLS RD     Berkeley 94708 37.891665270922104 -122.25086860999468
30633 30633 30633 063 314003400 1039 Park Hills Rd 1039 PARK HILLS RD 1039 PARK HILLS RD 1039.0 PARK HILLS RD     Berkeley 94708 37.89430730560078 -122.2548396630138
33277 33277 33277 063 313005500 1007 Park Hills Rd 1007 PARK HILLS RD 1007 PARK HILLS RD 1007.0 PARK HILLS RD     Berkeley 94708 37.895560980880155 -122.25556066792882
33985 33985 33985 063 314005600 1040 Park Hills Rd 1040 PARK HILLS RD 1040 PARK HILLS RD 1040.0 PARK HILLS RD     Berkeley 94708 37.89397451263685 -122.25524669775386
34162 34162 34162 063 314004400 1051 Park Hills Rd 1051 PARK HILLS RD 1051 PARK HILLS RD 1051.0 PARK HILLS RD     Berkeley 94708 37.89379857867864 -122.25430159371815
34854 34854 34854 063 313005600 1011 Park Hills Rd 1011 PARK HILLS RD 1011 PARK HILLS RD 1011.0 PARK HILLS RD     Berkeley 94708 37.89541698410772 -122.25549571344555
35880 35880 35880 063 314007200 1066 Park Hills Rd 1066 PARK HILLS RD 1066 PARK HILLS RD 1066.0 PARK HILLS RD     Berkeley 94708 37.89286304789616 -122.25474204219354
36883 36883 36883 063 314005200 1077 Park Hills Rd 1077 PARK HILLS RD 1077 PARK HILLS RD 1077.0 PARK HILLS RD     Berkeley 94708 37.892458237872056 -122.25393269156358
37873 37873 37873 063 313005400 1003 Park Hills Rd 1003 PARK HILLS RD 1003 PARK HILLS RD 1003.0 PARK HILLS RD     Berkeley 94708 37.89577385640794 -122.25560931259976
38037 38037 38037 063 314006900 1054 Park Hills Rd 1054 PARK HILLS RD 1054 PARK HILLS RD 1054.0 PARK HILLS RD     Berkeley 94708 37.893445676619926 -122.25472498408462
39046 39046 39046 063 315005200 1141 Park Hills Rd 1141 PARK HILLS RD 1141 PARK HILLS RD 1141.0 PARK HILLS RD     Berkeley 94708 37.89177975609208 -122.25187057738786
40105 40105 40105 063 316001100 1150 Park Hills Rd 1150 PARK HILLS RD 1150 PARK HILLS RD 1150.0 PARK HILLS RD     Berkeley 94708 37.8915559983191 -122.2513102011271
40165 40165 40165 063 316000400 1180 Park Hills Rd 1180 PARK HILLS RD 1180 PARK HILLS RD 1180.0 PARK HILLS RD     Berkeley 94708 37.891484549724055 -122.249717754928
40646 40646 40646 063 313005700 1015 Park Hills Rd 1015 PARK HILLS RD 1015 PARK HILLS RD 1015.0 PARK HILLS RD     Berkeley 94708 37.89528086780351 -122.25542667611934
41941 41941 41941 063 315005000 1127 Park Hills Rd 1127 PARK HILLS RD 1127 PARK HILLS RD 1127.0 PARK HILLS RD     Berkeley 94708 37.89176552441216 -122.252537193804
42146 42146 42146 063 314003300 1045 Park Hills Rd 1045 PARK HILLS RD 1045 PARK HILLS RD 1045.0 PARK HILLS RD     Berkeley 94708 37.894181896632894 -122.2547273277892
48167 48167 48167 063 314005500 1036 Park Hills Rd 1036 PARK HILLS RD 1036 PARK HILLS RD 1036.0 PARK HILLS RD     Berkeley 94708 37.89420693222314 -122.25531451965948
48848 48848 48848 063 315003402 1147 Park Hills Rd 1147 PARK HILLS RD 1147 PARK HILLS RD 1147.0 PARK HILLS RD     Berkeley 94708 37.89189205263444 -122.2513639617036
51281 51281 51281 063 315008800 1111 Park Hills Rd 1111 PARK HILLS RD 1111 PARK HILLS RD 1111.0 PARK HILLS RD     Berkeley 94708 37.89212599517982 -122.2531936691389
51586 51586 51586 063 313002200 1020 Park Hills Rd 1020 PARK HILLS RD 1020 PARK HILLS RD 1020.0 PARK HILLS RD     Berkeley 94708 37.89502924128739 -122.25583488765244
51769 51769 51769 063 315004900 1123 Park Hills Rd 1123 PARK HILLS RD 1123 PARK HILLS RD 1123.0 PARK HILLS RD     Berkeley 94708 37.89181771478695 -122.25273874880428
51919 51919 51919 063 315005700 1126 Park Hills Rd 1126 PARK HILLS RD 1126 PARK HILLS RD 1126.0 PARK HILLS RD     Berkeley 94708 37.891444604439286 -122.2528907733948
52077 52077 52077 063 314002300 1021 Park Hills Rd 1021 PARK HILLS RD 1021 PARK HILLS RD 1021.0 PARK HILLS RD     Berkeley 94708 37.89504004058033 -122.25540429639068
53836 53836 53836 063 313001901 1010 Park Hills Rd 1010 PARK HILLS RD 1010 PARK HILLS RD 1010.0 PARK HILLS RD     Berkeley 94708 37.895433377906016 -122.25605089564736
54518 54518 54518 063 315006000 1114 Park Hills Rd 1114 PARK HILLS RD 1114 PARK HILLS RD 1114.0 PARK HILLS RD     Berkeley 94708 37.89174171939579 -122.25345496390224
58105 58105 58105 063 314003500 1035 Park Hills Rd 1035 PARK HILLS RD 1035 PARK HILLS RD 1035.0 PARK HILLS RD     Berkeley 94708 37.89447726940975 -122.25497553320054

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