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

66 rows where street_type = "RD" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

street_name 6

zipcode 1

  • 94704 · 66 ✖

street_type 1

Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1699 1699 1699 055 186201401 39 Canyon Rd A 39 CANYON RD A 39 CANYON RD 39.0 CANYON RD A   Berkeley 94704 37.870393266403326 -122.2486358419661
2324 2324 2324 055 186202600 50 Arden Rd 50 ARDEN RD 50 ARDEN RD 50.0 ARDEN RD     Berkeley 94704 37.869199206477646 -122.24751508854628
3675 3675 3675 055 186204905 20 Mosswood Rd 20 MOSSWOOD RD 20 MOSSWOOD RD 20.0 MOSSWOOD RD     Berkeley 94704 37.869974747241045 -122.24828088705463
3816 3816 3816 055 186201700 38 Mosswood Rd 38 MOSSWOOD RD 38 MOSSWOOD RD 38.0 MOSSWOOD RD     Berkeley 94704 37.87020694190688 -122.2474953642376
5538 5538 5538 055 186201302 33 Canyon Rd 33 CANYON RD 33 CANYON RD 33.0 CANYON RD     Berkeley 94704 37.87014317237269 -122.24901669530722
6712 6712 6712 055 186200700 11 Mosswood Rd 11 MOSSWOOD RD 11 MOSSWOOD RD 11.0 MOSSWOOD RD     Berkeley 94704 37.86953803556444 -122.24901614463997
7547 7547 7547 055 186201000 1 Canyon Rd 2 1 CANYON RD 2 1 CANYON RD 1.0 CANYON RD 2   Berkeley 94704 37.8694914152957 -122.24944252729463
10369 10369 10369 055 186201401 39 Canyon Rd 39 CANYON RD 39 CANYON RD 39.0 CANYON RD     Berkeley 94704 37.870393266403326 -122.2486358419661
10662 10662 10662 055 186000500 10 Arden Rd 10 ARDEN RD 10 ARDEN RD 10.0 ARDEN RD     Berkeley 94704 37.8686074499329 -122.24735318248769
14664 14664 14664 055 186201200 15 Canyon Rd C 15 CANYON RD C 15 CANYON RD 15.0 CANYON RD C   Berkeley 94704 37.87003444152345 -122.24948050806483
14923 14923 14923 055 186201100 9 Canyon Rd 9 CANYON RD 9 CANYON RD 9.0 CANYON RD     Berkeley 94704 37.869754315726304 -122.24937070339438
15007 15007 15007 055 186000600 24 Arden Rd 24 ARDEN RD 24 ARDEN RD 24.0 ARDEN RD     Berkeley 94704 37.8688403431618 -122.24738640128857
15360 15360 15360 055 186205800 45 Canyon Rd 45 CANYON RD 45 CANYON RD 45.0 CANYON RD     Berkeley 94704 37.87050178611141 -122.2484208571523
16841 16841 16841 055 186201200 15 Canyon Rd A 15 CANYON RD A 15 CANYON RD 15.0 CANYON RD A   Berkeley 94704 37.87003444152345 -122.24948050806483
17445 17445 17445 055 186203105 100 Arden Rd 100 ARDEN RD 100 ARDEN RD 100.0 ARDEN RD     Berkeley 94704 37.86990147153739 -122.24744076014306
17567 17567 17567 055 186201700 38 Mosswood Rd 1 38 MOSSWOOD RD 1 38 MOSSWOOD RD 38.0 MOSSWOOD RD 1   Berkeley 94704 37.87020694190688 -122.2474953642376
18164 18164 18164 055 186206300 62 Arden Rd 62 ARDEN RD 62 ARDEN RD 62.0 ARDEN RD     Berkeley 94704 37.86935943003605 -122.24764358446284
18689 18689 18689 055 186203300 89 Arden Rd 89 ARDEN RD 89 ARDEN RD 89.0 ARDEN RD     Berkeley 94704 37.869921504628905 -122.2479406743953
20108 20108 20108 055 186200200 37 Mosswood Rd 37 MOSSWOOD RD 37 MOSSWOOD RD 37.0 MOSSWOOD RD     Berkeley 94704 37.870477637384205 -122.24770823801047
21688 21688 21688 055 186206000 61 Canyon Rd 61 CANYON RD 61 CANYON RD 61.0 CANYON RD     Berkeley 94704 37.870684577693005 -122.24798748111316
21881 21881 21881 055 186201901 44 Mosswood Rd 44 MOSSWOOD RD 44 MOSSWOOD RD 44.0 MOSSWOOD RD     Berkeley 94704 37.870191621793 -122.24717350326117
21939 21939 21939 055 186201000 1 Canyon Rd 3 1 CANYON RD 3 1 CANYON RD 1.0 CANYON RD 3   Berkeley 94704 37.8694914152957 -122.24944252729463
21969 21969 21969 055 186203700 59 Arden Rd 59 ARDEN RD 59 ARDEN RD 59.0 ARDEN RD     Berkeley 94704 37.86929729788612 -122.24806295217344
22220 22220 22220 055 186200600 13 Mosswood Rd 13 MOSSWOOD RD 13 MOSSWOOD RD 13.0 MOSSWOOD RD     Berkeley 94704 37.86982131784286 -122.24894579757007
23820 23820 23820 055 186201000 1 Canyon Rd 1 CANYON RD 1 CANYON RD 1.0 CANYON RD     Berkeley 94704 37.8694914152957 -122.24944252729463
23830 23830 23830 055 186205800 47 Canyon Rd 47 CANYON RD 47 CANYON RD 47.0 CANYON RD     Berkeley 94704 37.87050178611141 -122.2484208571523
24676 24676 24676 055 186204702 10 Mosswood Rd 10 MOSSWOOD RD 10 MOSSWOOD RD 10.0 MOSSWOOD RD     Berkeley 94704 37.86961022310137 -122.24851887772286
26261 26261 26261 055 186203900 9 Arden Rd A 9 ARDEN RD A 9 ARDEN RD 9.0 ARDEN RD A   Berkeley 94704 37.86893501767658 -122.24788130383986
26403 26403 26403 055 186203003 76 Arden Rd A 76 ARDEN RD A 76 ARDEN RD 76.0 ARDEN RD A   Berkeley 94704 37.8696971180921 -122.24747301684828
27110 27110 27110 055 186204704 6 Mosswood Rd 6 MOSSWOOD RD 6 MOSSWOOD RD 6.0 MOSSWOOD RD     Berkeley 94704 37.8694405458276 -122.24874607692958
27438 27438 27438 057 204200408 210 Stadium Rim Rd 210 STADIUM RIM RD 210 STADIUM RIM RD 210.0 STADIUM RIM RD     Berkeley 94704 37.87153221756338 -122.25044261810716
28021 28021 28021 055 186201000 1 Canyon Rd 1 1 CANYON RD 1 1 CANYON RD 1.0 CANYON RD 1   Berkeley 94704 37.8694914152957 -122.24944252729463
28978 28978 28978 055 186203105 100 Arden Rd A 100 ARDEN RD A 100 ARDEN RD 100.0 ARDEN RD A   Berkeley 94704 37.86990147153739 -122.24744076014306
29193 29193 29193 055 186203200 99 Arden Rd 99 ARDEN RD 99 ARDEN RD 99.0 ARDEN RD     Berkeley 94704 37.87009160698479 -122.24781193144204
30976 30976 30976 055 186206300 60 Arden Rd 60 ARDEN RD 60 ARDEN RD 60.0 ARDEN RD     Berkeley 94704 37.86935943003605 -122.24764358446284
31323 31323 31323 055 186204904 14 Mosswood Rd 14 MOSSWOOD RD 14 MOSSWOOD RD 14.0 MOSSWOOD RD     Berkeley 94704 37.86981254014645 -122.24844759371013
33005 33005 33005 055 186203003 76 Arden Rd 76 ARDEN RD 76 ARDEN RD 76.0 ARDEN RD     Berkeley 94704 37.8696971180921 -122.24747301684828
33102 33102 33102 055 186204800 16 Mosswood Rd 16 MOSSWOOD RD 16 MOSSWOOD RD 16.0 MOSSWOOD RD     Berkeley 94704 37.869727135190296 -122.24832048479236
33487 33487 33487 055 186200301 29 Mosswood Rd 29 MOSSWOOD RD 29 MOSSWOOD RD 29.0 MOSSWOOD RD     Berkeley 94704 37.87037183857839 -122.24802464082322
33726 33726 33726 055 186201700 38 Mosswood Rd 2 38 MOSSWOOD RD 2 38 MOSSWOOD RD 38.0 MOSSWOOD RD 2   Berkeley 94704 37.87020694190688 -122.2474953642376
33808 33808 33808 055 186201401 39 Canyon Rd 2 39 CANYON RD 2 39 CANYON RD 39.0 CANYON RD 2   Berkeley 94704 37.870393266403326 -122.2486358419661
34166 34166 34166 055 186203200 95 Arden Rd 95 ARDEN RD 95 ARDEN RD 95.0 ARDEN RD     Berkeley 94704 37.87009160698479 -122.24781193144204
36840 36840 36840 055 186200105 53 Canyon Rd 53 CANYON RD 53 CANYON RD 53.0 CANYON RD     Berkeley 94704 37.8705908343859 -122.24819666191188
36995 36995 36995 055 186202001 48 Mosswood Rd 48 MOSSWOOD RD 48 MOSSWOOD RD 48.0 MOSSWOOD RD     Berkeley 94704 37.870184518404535 -122.24670374904628
37086 37086 37086 055 186205800 51 Canyon Rd 51 CANYON RD 51 CANYON RD 51.0 CANYON RD     Berkeley 94704 37.87050178611141 -122.2484208571523
37528 37528 37528 055 186200700 11 Mosswood Rd A 11 MOSSWOOD RD A 11 MOSSWOOD RD 11.0 MOSSWOOD RD A   Berkeley 94704 37.86953803556444 -122.24901614463997
37652 37652 37652 055 186203600 65 Arden Rd 65 ARDEN RD 65 ARDEN RD 65.0 ARDEN RD     Berkeley 94704 37.86948245956576 -122.24807338610546
37973 37973 37973 055 186200500 21 Mosswood Rd 21 MOSSWOOD RD 21 MOSSWOOD RD 21.0 MOSSWOOD RD     Berkeley 94704 37.87018643944675 -122.24848047474444
39408 39408 39408 055 186202503 40 Arden Rd 40 ARDEN RD 40 ARDEN RD 40.0 ARDEN RD     Berkeley 94704 37.86898969134677 -122.2475842678063
40648 40648 40648 055 186201304 37 Canyon Rd A 37 CANYON RD A 37 CANYON RD 37.0 CANYON RD A   Berkeley 94704 37.870235604353624 -122.24885577020892
40818 40818 40818 055 186200105 57 Canyon Rd 57 CANYON RD 57 CANYON RD 57.0 CANYON RD     Berkeley 94704 37.8705908343859 -122.24819666191188
42421 42421 42421 055 186201200 15 Canyon Rd B 15 CANYON RD B 15 CANYON RD 15.0 CANYON RD B   Berkeley 94704 37.87003444152345 -122.24948050806483
46525 46525 46525 055 186201304 37 Canyon Rd 2 37 CANYON RD 2 37 CANYON RD 37.0 CANYON RD 2   Berkeley 94704 37.870235604353624 -122.24885577020892
48060 48060 48060 055 186201700 38 Mosswood Rd 4 38 MOSSWOOD RD 4 38 MOSSWOOD RD 38.0 MOSSWOOD RD 4   Berkeley 94704 37.87020694190688 -122.2474953642376
51070 51070 51070 055 186205800 49 Canyon Rd 49 CANYON RD 49 CANYON RD 49.0 CANYON RD     Berkeley 94704 37.87050178611141 -122.2484208571523
52571 52571 52571 055 186203900 9 Arden Rd 9 ARDEN RD 9 ARDEN RD 9.0 ARDEN RD     Berkeley 94704 37.86893501767658 -122.24788130383986
53145 53145 53145 055 186203002 70 Arden Rd 70 ARDEN RD 70 ARDEN RD 70.0 ARDEN RD     Berkeley 94704 37.869548264192986 -122.24753136062934
53819 53819 53819 055 186201200 15 Canyon Rd 15 CANYON RD 15 CANYON RD 15.0 CANYON RD     Berkeley 94704 37.87003444152345 -122.24948050806483
53971 53971 53971 055 186201304 37 Canyon Rd 37 CANYON RD 37 CANYON RD 37.0 CANYON RD     Berkeley 94704 37.870235604353624 -122.24885577020892
56272 56272 56272 055 186204703 8 Mosswood Rd 8 MOSSWOOD RD 8 MOSSWOOD RD 8.0 MOSSWOOD RD     Berkeley 94704 37.86947339037234 -122.24853295162842
57540 57540 57540 055 186205900 67 Canyon Rd 67 CANYON RD 67 CANYON RD 67.0 CANYON RD     Berkeley 94704 37.87080498123876 -122.24774230931256
57979 57979 57979 055 186201000 5 Canyon Rd 5 CANYON RD 5 CANYON RD 5.0 CANYON RD     Berkeley 94704 37.8694914152957 -122.24944252729463
62197 62197 62197 057 204200410 1 Cyclotron Rd 1 CYCLOTRON RD 1 CYCLOTRON RD 1.0 CYCLOTRON RD     Berkeley 94704 37.87578356445552 -122.25280209889644
62199 62199 62199 057 204200410 1975 Gayley Rd 1975 GAYLEY RD 1975 GAYLEY RD 1975.0 GAYLEY RD     Berkeley 94704 37.87384008673968 -122.25507887359416
62200 62200 62200 057 204200410 2001 Gayley Rd 2001 GAYLEY RD 2001 GAYLEY RD 2001.0 GAYLEY RD     Berkeley 94704 37.873486315395624 -122.25454969851818
62201 62201 62201 057 204200410 2175 Gayley Rd 2175 GAYLEY RD 2175 GAYLEY RD 2175.0 GAYLEY RD     Berkeley 94704 37.87236653055287 -122.25286200215284

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