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

82 rows where street_type = "CT" and zipcode = 94708

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

street_name 6

zipcode 1

  • 94708 · 82 ✖

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
958 958 958 061 255200900 2358 Corona Ct 2358 CORONA CT 2358 CORONA CT 2358.0 CORONA CT     Berkeley 94708 37.8885493054519 -122.264277201692
1105 1105 1105 061 255101602 1101 High Ct 1101 HIGH CT 1101 HIGH CT 1101.0 HIGH CT     Berkeley 94708 37.88841586481783 -122.26388599077563
2008 2008 2008 061 255100300 1113 High Ct 1113 HIGH CT 1113 HIGH CT 1113.0 HIGH CT     Berkeley 94708 37.88915658592263 -122.26377598398427
3193 3193 3193 061 255100603 1119 High Ct 1119 HIGH CT 1119 HIGH CT 1119.0 HIGH CT     Berkeley 94708 37.889430133339 -122.26320459886972
3202 3202 3202 058 224601200 2522 Hill Ct 2522 HILL CT 2522 HILL CT 2522.0 HILL CT     Berkeley 94708 37.87976846409461 -122.26027412103808
3715 3715 3715 061 255101000 1131 High Ct Lowr 1131 HIGH CT LOWR 1131 HIGH CT 1131.0 HIGH CT LOWR   Berkeley 94708 37.88877863623675 -122.26305362081656
5587 5587 5587 061 255202200 2310 Corona Ct 2310 CORONA CT 2310 CORONA CT 2310.0 CORONA CT     Berkeley 94708 37.88801142310592 -122.26533041797214
6085 6085 6085 058 224601505 2502 Hill Ct 2502 HILL CT 2502 HILL CT 2502.0 HILL CT     Berkeley 94708 37.8798831202058 -122.26112093051704
6585 6585 6585 061 255100703 1121 High Ct 1121 HIGH CT 1121 HIGH CT 1121.0 HIGH CT     Berkeley 94708 37.88927560872619 -122.26314369219514
7911 7911 7911 058 224601700 2525 Hill Ct 2525 HILL CT 2525 HILL CT 2525.0 HILL CT     Berkeley 94708 37.879913742218825 -122.26011730213892
8539 8539 8539 061 255200400 2325 Corona Ct 2325 CORONA CT 2325 CORONA CT 2325.0 CORONA CT     Berkeley 94708 37.88851079492137 -122.2650605658574
9246 9246 9246 058 223202200 5 W Parnassus Ct 5 W PARNASSUS CT 5 PARNASSUS CT 5.0 PARNASSUS CT     Berkeley 94708 37.88108918027722 -122.25404589545909
9968 9968 9968 061 255202600 2340 Corona Ct 2340 CORONA CT 2340 CORONA CT 2340.0 CORONA CT     Berkeley 94708 37.88817799489663 -122.26471573316256
11675 11675 11675 061 255101101 1137 High Ct 1137 HIGH CT 1137 HIGH CT 1137.0 HIGH CT     Berkeley 94708 37.88864860609483 -122.26293815496318
11704 11704 11704 058 224601300 2518 Hill Ct 2518 HILL CT 2518 HILL CT 2518.0 HILL CT     Berkeley 94708 37.879776415281086 -122.2604427240371
11915 11915 11915 061 255102300 1150 High Ct 1150 HIGH CT 1150 HIGH CT 1150.0 HIGH CT     Berkeley 94708 37.88809975330529 -122.26319970394972
12502 12502 12502 063 310009800 1 Woodmont Ct 1 WOODMONT CT 1 WOODMONT CT 1.0 WOODMONT CT     Berkeley 94708 37.90304594614722 -122.26673324778108
13353 13353 13353 063 310009600 3 Woodmont Ct 3 WOODMONT CT 3 WOODMONT CT 3.0 WOODMONT CT     Berkeley 94708 37.9032158167702 -122.26638087462771
13662 13662 13662 061 255200800 2357 Corona Ct 2357 CORONA CT 2357 CORONA CT 2357.0 CORONA CT     Berkeley 94708 37.88882304299726 -122.26434357731004
15661 15661 15661 060 246905105 5 El Portal Ct 5 EL PORTAL CT 5 EL PORTAL CT 5.0 EL PORTAL CT     Berkeley 94708 37.88448474175435 -122.25592393225666
15697 15697 15697 058 223200900 12 E Parnassus Ct 12 E PARNASSUS CT 12 PARNASSUS CT 12.0 PARNASSUS CT     Berkeley 94708 37.882040853300936 -122.25292577894476
15880 15880 15880 061 255102200 1142 High Ct 1142 HIGH CT 1142 HIGH CT 1142.0 HIGH CT     Berkeley 94708 37.88830600959053 -122.26322261188776
16054 16054 16054 061 255202300 2316 Corona Ct 2316 CORONA CT 2316 CORONA CT 2316.0 CORONA CT     Berkeley 94708 37.88804035441102 -122.2651744470826
17249 17249 17249 058 224601600 2514 Hill Ct 2514 HILL CT 2514 HILL CT 2514.0 HILL CT     Berkeley 94708 37.8798437642211 -122.26062668822752
17414 17414 17414 060 246905400 11 El Portal Ct 11 EL PORTAL CT 11 EL PORTAL CT 11.0 EL PORTAL CT     Berkeley 94708 37.8847562270502 -122.25601460101493
17708 17708 17708 061 255202700 2350 Corona Ct 2350 CORONA CT 2350 CORONA CT 2350.0 CORONA CT     Berkeley 94708 37.8881898267314 -122.26450816394144
19823 19823 19823 061 255100803 1123 High Ct 1123 HIGH CT 1123 HIGH CT 1123.0 HIGH CT     Berkeley 94708 37.88908018722702 -122.26311374775348
20834 20834 20834 061 255101101 1137 High Ct B 1137 HIGH CT B 1137 HIGH CT 1137.0 HIGH CT B   Berkeley 94708 37.88864860609483 -122.26293815496318
21555 21555 21555 061 255101902 1104 High Ct 1104 HIGH CT 1104 HIGH CT 1104.0 HIGH CT     Berkeley 94708 37.888741691907136 -122.263465996041
21841 21841 21841 061 255101203 1141 High Ct 1141 HIGH CT 1141 HIGH CT 1141.0 HIGH CT     Berkeley 94708 37.888472979857774 -122.26273726202125
23451 23451 23451 058 224602100 2513 Hill Ct 2513 HILL CT 2513 HILL CT 2513.0 HILL CT     Berkeley 94708 37.88005353351789 -122.26063417748205
23559 23559 23559 063 310009500 4 Woodmont Ct 4 WOODMONT CT 4 WOODMONT CT 4.0 WOODMONT CT     Berkeley 94708 37.90313400313394 -122.26615602361716
24598 24598 24598 061 255102300 1148 High Ct 1148 HIGH CT 1148 HIGH CT 1148.0 HIGH CT     Berkeley 94708 37.88809975330529 -122.26319970394972
25577 25577 25577 061 255102101 1138 High Ct A 1138 HIGH CT A 1138 HIGH CT 1138.0 HIGH CT A   Berkeley 94708 37.88847845726166 -122.2633463395468
25875 25875 25875 061 255200500 2335 Corona Ct 2335 CORONA CT 2335 CORONA CT 2335.0 CORONA CT     Berkeley 94708 37.88855876505873 -122.2649205247928
26664 26664 26664 058 223201000 10 E Parnassus Ct 10 E PARNASSUS CT 10 PARNASSUS CT 10.0 PARNASSUS CT     Berkeley 94708 37.88180837687426 -122.2529391925886
26912 26912 26912 061 255201000 2356 Corona Ct 2356 CORONA CT 2356 CORONA CT 2356.0 CORONA CT     Berkeley 94708 37.888289147001046 -122.264273435056
27068 27068 27068 061 255101300 1147 High Ct 1147 HIGH CT 1147 HIGH CT 1147.0 HIGH CT     Berkeley 94708 37.88821961368082 -122.26282627608272
27269 27269 27269 058 223202300 7 W Parnassus Ct 7 W PARNASSUS CT 7 PARNASSUS CT 7.0 PARNASSUS CT     Berkeley 94708 37.880954790914046 -122.25453472539904
28646 28646 28646 061 255200300 2321 Corona Ct 2321 CORONA CT 2321 CORONA CT 2321.0 CORONA CT     Berkeley 94708 37.88846286516334 -122.26520321922284
28868 28868 28868 061 255100400 1115 High Ct 1115 HIGH CT 1115 HIGH CT 1115.0 HIGH CT     Berkeley 94708 37.88920617204575 -122.26364239821334
29047 29047 29047 061 255202400 2326 Corona Ct 2326 CORONA CT 2326 CORONA CT 2326.0 CORONA CT     Berkeley 94708 37.88812536522198 -122.26501779347348
29235 29235 29235 061 255101500 1105 High Ct 1105 HIGH CT 1105 HIGH CT 1105.0 HIGH CT     Berkeley 94708 37.8887064256556 -122.2639605195032
29535 29535 29535 061 255200700 2355 Corona Ct 2355 CORONA CT 2355 CORONA CT 2355.0 CORONA CT     Berkeley 94708 37.888691820471145 -122.2646255755457
30173 30173 30173 061 255100901 1125 High Ct 1125 HIGH CT 1125 HIGH CT 1125.0 HIGH CT     Berkeley 94708 37.88893470740981 -122.26309684505308
30275 30275 30275 058 223203200 9 W Parnassus Ct 9 W PARNASSUS CT 9 PARNASSUS CT 9.0 PARNASSUS CT     Berkeley 94708 37.88128109415883 -122.25443921382306
30844 30844 30844 061 255102101 1138 High Ct 1138 HIGH CT 1138 HIGH CT 1138.0 HIGH CT     Berkeley 94708 37.88847845726166 -122.2633463395468
32067 32067 32067 061 255101400 1149 High Ct 1149 HIGH CT 1149 HIGH CT 1149.0 HIGH CT     Berkeley 94708 37.88810202836077 -122.26280691020186
32137 32137 32137 058 224601900 2521 Hill Ct 2521 HILL CT 2521 HILL CT 2521.0 HILL CT     Berkeley 94708 37.880079306348655 -122.2603125383895
34541 34541 34541 061 255200200 2311 Corona Ct 2311 CORONA CT 2311 CORONA CT 2311.0 CORONA CT     Berkeley 94708 37.888412517827774 -122.26535107742704
36512 36512 36512 058 224601506 2512 Hill Ct 2512 HILL CT 2512 HILL CT 2512.0 HILL CT     Berkeley 94708 37.87983040448111 -122.26083310670676
37614 37614 37614 058 224601300 2520 Hill Ct 2520 HILL CT 2520 HILL CT 2520.0 HILL CT     Berkeley 94708 37.879776415281086 -122.2604427240371
38290 38290 38290 061 255101101 1137 High Ct A 1137 HIGH CT A 1137 HIGH CT 1137.0 HIGH CT A   Berkeley 94708 37.88864860609483 -122.26293815496318
38601 38601 38601 061 255100103 1109 High Ct 1109 HIGH CT 1109 HIGH CT 1109.0 HIGH CT     Berkeley 94708 37.88900759694328 -122.2640570210226
39196 39196 39196 061 255202500 2334 Corona Ct 2334 CORONA CT 2334 CORONA CT 2334.0 CORONA CT     Berkeley 94708 37.888151603850794 -122.26486850335472
39424 39424 39424 061 255200600 2345 Corona Ct 2345 CORONA CT 2345 CORONA CT 2345.0 CORONA CT     Berkeley 94708 37.888606839381346 -122.26478391529264
39661 39661 39661 060 246905106 7 El Portal Ct 7 EL PORTAL CT 7 EL PORTAL CT 7.0 EL PORTAL CT     Berkeley 94708 37.88460912289138 -122.2559651523518
39692 39692 39692 061 255102000 1136 High Ct 1136 HIGH CT 1136 HIGH CT 1136.0 HIGH CT     Berkeley 94708 37.88862097950761 -122.26341377427856
40140 40140 40140 061 255101203 1141 High Ct B 1141 HIGH CT B 1141 HIGH CT 1141.0 HIGH CT B   Berkeley 94708 37.888472979857774 -122.26273726202125
42486 42486 42486 058 223203100 8 W Parnassus Ct 8 W PARNASSUS CT 8 PARNASSUS CT 8.0 PARNASSUS CT     Berkeley 94708 37.88152294413254 -122.25435881999502
43057 43057 43057 061 255100101 1107 High Ct 1107 HIGH CT 1107 HIGH CT 1107.0 HIGH CT     Berkeley 94708 37.88882249710274 -122.26397013596834
45112 45112 45112 060 246905106 9 El Portal Ct 9 EL PORTAL CT 9 EL PORTAL CT 9.0 EL PORTAL CT     Berkeley 94708 37.88460912289138 -122.2559651523518
45121 45121 45121 061 255100501 1117 High Ct 1117 HIGH CT 1117 HIGH CT 1117.0 HIGH CT     Berkeley 94708 37.88925546250351 -122.2634926930729
45526 45526 45526 061 255101000 1131 High Ct 1131 HIGH CT 1131 HIGH CT 1131.0 HIGH CT     Berkeley 94708 37.88877863623675 -122.26305362081656
45527 45527 45527 061 255101400 1151 High Ct 1151 HIGH CT 1151 HIGH CT 1151.0 HIGH CT     Berkeley 94708 37.88810202836077 -122.26280691020186
47318 47318 47318 061 255101901 1108 High Ct 1108 HIGH CT 1108 HIGH CT 1108.0 HIGH CT     Berkeley 94708 37.88888121051713 -122.26350461012343
48855 48855 48855 058 224601506 2510 Hill Ct 2510 HILL CT 2510 HILL CT 2510.0 HILL CT     Berkeley 94708 37.87983040448111 -122.26083310670676
49412 49412 49412 061 255101203 1141 High Ct A 1141 HIGH CT A 1141 HIGH CT 1141.0 HIGH CT A   Berkeley 94708 37.888472979857774 -122.26273726202125
49475 49475 49475 058 224602300 2509 Hill Ct 2509 HILL CT 2509 HILL CT 2509.0 HILL CT     Berkeley 94708 37.880060750819005 -122.26094009695542
50222 50222 50222 058 224602000 2519 Hill Ct 2519 HILL CT 2519 HILL CT 2519.0 HILL CT     Berkeley 94708 37.88007005694594 -122.2604422640997
50431 50431 50431 058 223200700 7 E Parnassus Ct 7 E PARNASSUS CT 7 PARNASSUS CT 7.0 PARNASSUS CT     Berkeley 94708 37.88208701752824 -122.25330502519984
51712 51712 51712 060 246904400 8 El Portal Ct 8 EL PORTAL CT 8 EL PORTAL CT 8.0 EL PORTAL CT     Berkeley 94708 37.88487872677325 -122.25561340622252
53152 53152 53152 063 310009700 2 Woodmont Ct 2 WOODMONT CT 2 WOODMONT CT 2.0 WOODMONT CT     Berkeley 94708 37.90320507750848 -122.26662101765936
53289 53289 53289 063 310009200 5 Woodmont Ct 5 WOODMONT CT 5 WOODMONT CT 5.0 WOODMONT CT     Berkeley 94708 37.902982994668704 -122.2660278034834
54036 54036 54036 058 224601505 2504 Hill Ct 2504 HILL CT 2504 HILL CT 2504.0 HILL CT     Berkeley 94708 37.8798831202058 -122.26112093051704
54598 54598 54598 058 223200800 9 E Parnassus Ct 9 E PARNASSUS CT 9 PARNASSUS CT 9.0 PARNASSUS CT     Berkeley 94708 37.882155771756345 -122.25302721850328
54928 54928 54928 061 255101101 1137 High Ct C 1137 HIGH CT C 1137 HIGH CT 1137.0 HIGH CT C   Berkeley 94708 37.88864860609483 -122.26293815496318
55473 55473 55473 058 224602100 2515 Hill Ct 2515 HILL CT 2515 HILL CT 2515.0 HILL CT     Berkeley 94708 37.88005353351789 -122.26063417748205
56820 56820 56820 061 255100200 1111 High Ct 1111 HIGH CT 1111 HIGH CT 1111.0 HIGH CT     Berkeley 94708 37.88906709289259 -122.26389222508372
57106 57106 57106 058 224602400 2501 Hill Ct 2501 HILL CT 2501 HILL CT 2501.0 HILL CT     Berkeley 94708 37.880062222782456 -122.26114916456642
57273 57273 57273 058 224602201 2511 Hill Ct 2511 HILL CT 2511 HILL CT 2511.0 HILL CT     Berkeley 94708 37.88006640469008 -122.26081665585896
58340 58340 58340 061 255101603 1103 High Ct 1103 HIGH CT 1103 HIGH CT 1103.0 HIGH CT     Berkeley 94708 37.888542037937825 -122.26394558141835

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