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

94 rows where street_name = "CHANNING" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94702 · 94 ✖

street_type 1

street_name 1

  • CHANNING · 94 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1652 1652 1652 056 192502000 1205 Channing Way 1205 CHANNING WAY 1205 CHANNING WY 1205.0 CHANNING WY     Berkeley 94702 37.86336935016185 -122.28797324971738
2243 2243 2243 056 191702000 1349 Channing Way 1349 CHANNING WAY 1349 CHANNING WY 1349.0 CHANNING WY     Berkeley 94702 37.86388433246556 -122.28390077330944
2521 2521 2521 056 192100302 1336 Channing Way 1336 CHANNING WAY 1336 CHANNING WY 1336.0 CHANNING WY     Berkeley 94702 37.86340052724997 -122.28444698134156
2536 2536 2536 056 191602200 1407 Channing Way 1407 CHANNING WAY 1407 CHANNING WY 1407.0 CHANNING WY     Berkeley 94702 37.8640202592965 -122.28285076760814
2705 2705 2705 056 192701100 1117 Channing Way 1117 CHANNING WAY 1117 CHANNING WY 1117.0 CHANNING WY     Berkeley 94702 37.86322525568899 -122.2892898313776
3012 3012 3012 056 191602200 1405 Channing Way 1405 CHANNING WAY 1405 CHANNING WY 1405.0 CHANNING WY     Berkeley 94702 37.8640202592965 -122.28285076760814
3901 3901 3901 056 193103700 1236 Channing Way 1236 CHANNING WAY 1236 CHANNING WY 1236.0 CHANNING WY     Berkeley 94702 37.86310625106843 -122.28652733041925
3974 3974 3974 056 192100302 1340 Channing Way 1340 CHANNING WAY 1340 CHANNING WY 1340.0 CHANNING WY     Berkeley 94702 37.86340052724997 -122.28444698134156
4440 4440 4440 056 192501700 1217 Channing Way 1217 CHANNING WAY 1217 CHANNING WY 1217.0 CHANNING WY     Berkeley 94702 37.8634197436939 -122.28756739985518
5488 5488 5488 056 192402001 1235 Channing Way 1235 CHANNING WAY 1235 CHANNING WY 1235.0 CHANNING WY     Berkeley 94702 37.86358776041816 -122.28665156293144
5782 5782 5782 056 193103700 1336 Channing Way D 1336 CHANNING WAY D 1336 CHANNING WY 1336.0 CHANNING WY D   Berkeley 94702 37.86310625106843 -122.28652733041925
6199 6199 6199 056 192701300 1111 Channing Way 1111 CHANNING WAY 1111 CHANNING WY 1111.0 CHANNING WY     Berkeley 94702 37.86319257927656 -122.28953076402836
7576 7576 7576 056 191602300 1403 Channing Way 1403 CHANNING WAY 1403 CHANNING WY 1403.0 CHANNING WY     Berkeley 94702 37.86400143873877 -122.28298114908849
8703 8703 8703 056 192000701 1322 Channing Way 1322 CHANNING WAY 1322 CHANNING WY 1322.0 CHANNING WY     Berkeley 94702 37.86329517500712 -122.2851244008973
9262 9262 9262 056 191903600 1424 Channing Way 1424 CHANNING WAY 1424 CHANNING WY 1424.0 CHANNING WY     Berkeley 94702 37.86378270702475 -122.28198653799916
9785 9785 9785 056 192502100 1201 Channing Way 1201 CHANNING WAY 1201 CHANNING WY 1201.0 CHANNING WY     Berkeley 94702 37.86335095424816 -122.2881097011141
10702 10702 10702 056 193103700 1336 Channing Way E 1336 CHANNING WAY E 1336 CHANNING WY 1336.0 CHANNING WY E   Berkeley 94702 37.86310625106843 -122.28652733041925
10788 10788 10788 056 193000200 1204 Channing Way 1204 CHANNING WAY 1204 CHANNING WY 1204.0 CHANNING WY     Berkeley 94702 37.86293144971853 -122.28788216234425
11437 11437 11437 056 191702100 1347 Channing Way 1347 CHANNING WAY 1347 CHANNING WY 1347.0 CHANNING WY     Berkeley 94702 37.86386828765904 -122.28402167397029
11846 11846 11846 056 192201200 1315 Channing Way 1315 CHANNING WAY 1315 CHANNING WY 1315.0 CHANNING WY     Berkeley 94702 37.86372946277511 -122.28552117148692
12155 12155 12155 056 192201500 1307 Channing Way 1307 CHANNING WAY 1307 CHANNING WY 1307.0 CHANNING WY     Berkeley 94702 37.863642090549725 -122.28583689607164
15273 15273 15273 056 191501900 1435 Channing Way 1435 CHANNING WAY 1435 CHANNING WY 1435.0 CHANNING WY     Berkeley 94702 37.86410460495187 -122.28172896226113
16862 16862 16862 056 191602400 1401 Channing Way 1401 CHANNING WAY 1401 CHANNING WY 1401.0 CHANNING WY     Berkeley 94702 37.86398323091903 -122.2831149154208
17259 17259 17259 056 193100300 1228 Channing Way 1228 CHANNING WAY 1228 CHANNING WY 1228.0 CHANNING WY     Berkeley 94702 37.86307573908709 -122.2867613271777
18080 18080 18080 056 193100100 1224 Channing Way 1224 CHANNING WAY 1224 CHANNING WY 1224.0 CHANNING WY     Berkeley 94702 37.86304389875766 -122.28700220862451
18188 18188 18188 056 192800400 1118 Channing Way 1118 CHANNING WAY 1118 CHANNING WY 1118.0 CHANNING WY     Berkeley 94702 37.86275913300768 -122.28921624498275
18777 18777 18777 056 192900300 1132 Channing Way 1132 CHANNING WAY 1132 CHANNING WY 1132.0 CHANNING WY     Berkeley 94702 37.86283340302609 -122.28864810368468
18861 18861 18861 056 192700700 1129 Channing Way 1129 CHANNING WAY 1129 CHANNING WY 1129.0 CHANNING WY     Berkeley 94702 37.86328979643672 -122.2887864181873
19701 19701 19701 056 192000200 1302 Channing Way 1302 CHANNING WAY 1302 CHANNING WY 1302.0 CHANNING WY     Berkeley 94702 37.863194863611795 -122.28582616569555
20335 20335 20335 056 192501900 1209 Channing Way 1209 CHANNING WAY 1209 CHANNING WY 1209.0 CHANNING WY     Berkeley 94702 37.8633868886496 -122.28783507804694
20549 20549 20549 056 192402300 1227 Channing Way 1227 CHANNING WAY 1227 CHANNING WY 1227.0 CHANNING WY     Berkeley 94702 37.863492471959816 -122.28700347974062
21051 21051 21051 056 191502200 1421 Channing Way 1421 CHANNING WAY 1421 CHANNING WY 1421.0 CHANNING WY     Berkeley 94702 37.864116083930575 -122.28214107338086
21255 21255 21255 056 192203200 1323 Channing Way 1323 CHANNING WAY 1323 CHANNING WY 1323.0 CHANNING WY     Berkeley 94702 37.863698558866545 -122.28523022603102
21958 21958 21958 056 192701000 1119 Channing Way 1119 CHANNING WAY 1119 CHANNING WY 1119.0 CHANNING WY     Berkeley 94702 37.86324103752223 -122.28916633099232
22006 22006 22006 056 191701700 1357 Channing Way 1357 CHANNING WAY 1357 CHANNING WY 1357.0 CHANNING WY     Berkeley 94702 37.86392873225093 -122.28356228451716
22216 22216 22216 056 191701800 1353 Channing Way 1353 CHANNING WAY 1353 CHANNING WY 1353.0 CHANNING WY     Berkeley 94702 37.86391327253886 -122.283672831196
22330 22330 22330 056 192201600 1303 Channing Way 1303 CHANNING WAY 1303 CHANNING WY 1303.0 CHANNING WY     Berkeley 94702 37.86362670098801 -122.28595262153812
22478 22478 22478 056 191601900 1413 Channing Way 1413 CHANNING WAY 1413 CHANNING WY 1413.0 CHANNING WY     Berkeley 94702 37.86406785107422 -122.28246736305162
22501 22501 22501 056 192201700 1301 Channing Way 1301 CHANNING WAY 1301 CHANNING WY 1301.0 CHANNING WY     Berkeley 94702 37.86361234826853 -122.28606484177836
23837 23837 23837 056 193200401 1050 Channing Way 1050 CHANNING WAY 1050 CHANNING WY 1050.0 CHANNING WY     Berkeley 94702 37.86247727745438 -122.290383396387
24380 24380 24380 056 191701600 1359 Channing Way 1359 CHANNING WAY 1359 CHANNING WY 1359.0 CHANNING WY     Berkeley 94702 37.86394231968908 -122.28345000319143
24779 24779 24779 056 192402202 1229 Channing Way 1229 CHANNING WAY 1229 CHANNING WY 1229.0 CHANNING WY     Berkeley 94702 37.86350468434422 -122.28689984290293
25089 25089 25089 056 193000100 1200 Channing Way 1200 CHANNING WAY 1200 CHANNING WY 1200.0 CHANNING WY     Berkeley 94702 37.86291601320098 -122.2880168377716
26061 26061 26061 056 193103600 1232 Channing Way 1232 CHANNING WAY 1232 CHANNING WY 1232.0 CHANNING WY     Berkeley 94702 37.86308977631634 -122.2866439838454
26065 26065 26065 056 193000300 1208 Channing Way 1208 CHANNING WAY 1208 CHANNING WY 1208.0 CHANNING WY     Berkeley 94702 37.86294722665022 -122.28775001208108
26165 26165 26165 056 192100101 1330 Channing Way 1330 CHANNING WAY 1330 CHANNING WY 1330.0 CHANNING WY     Berkeley 94702 37.86314104306615 -122.28462229206085
26211 26211 26211 056 192402001 1235 Channing Way A 1235 CHANNING WAY A 1235 CHANNING WY 1235.0 CHANNING WY A   Berkeley 94702 37.86358776041816 -122.28665156293144
26518 26518 26518 056 192201300 1311 Channing Way 1311 CHANNING WAY 1311 CHANNING WY 1311.0 CHANNING WY     Berkeley 94702 37.8637152639711 -122.28562561950334
28592 28592 28592 056 191501900 1437 Channing Way 1437 CHANNING WAY 1437 CHANNING WY 1437.0 CHANNING WY     Berkeley 94702 37.864143294904025 -122.2817414290806
28635 28635 28635 056 191701900 1351 Channing Way 1351 CHANNING WAY 1351 CHANNING WY 1351.0 CHANNING WY     Berkeley 94702 37.86389849790489 -122.2837858841745
29789 29789 29789 056 192401800 1239 Channing Way 1239 CHANNING WAY 1239 CHANNING WY 1239.0 CHANNING WY     Berkeley 94702 37.863518786737934 -122.2863761484485
29975 29975 29975 056 191800101 1348 Channing Way 1348 CHANNING WAY 1348 CHANNING WY 1348.0 CHANNING WY     Berkeley 94702 37.86347800503336 -122.28383988729612
30366 30366 30366 056 192800200 1108 Channing Way 1108 CHANNING WAY 1108 CHANNING WY 1108.0 CHANNING WY     Berkeley 94702 37.86272330397171 -122.28948130458544
30448 30448 30448 056 192201100 1321 Channing Way 1321 CHANNING WAY 1321 CHANNING WY 1321.0 CHANNING WY     Berkeley 94702 37.863669617999655 -122.2853673870968
30743 30743 30743 056 191502000 1429 Channing Way 1429 CHANNING WAY 1429 CHANNING WY 1429.0 CHANNING WY     Berkeley 94702 37.86414737133663 -122.28189662292742
31623 31623 31623 056 192000600 1318 Channing Way 1318 CHANNING WAY 1318 CHANNING WY 1318.0 CHANNING WY     Berkeley 94702 37.863267348134904 -122.28528568801666
32693 32693 32693 056 193000500 1216 Channing Way 1216 CHANNING WAY 1216 CHANNING WY 1216.0 CHANNING WY     Berkeley 94702 37.86298182794754 -122.28747545548924
34736 34736 34736 056 191602100 1409 Channing Way 1409 CHANNING WAY 1409 CHANNING WY 1409.0 CHANNING WY     Berkeley 94702 37.86403696361894 -122.28271686922346
35084 35084 35084 056 192402001 1233 Channing Way 1233 CHANNING WAY 1233 CHANNING WY 1233.0 CHANNING WY     Berkeley 94702 37.86358776041816 -122.28665156293144
36667 36667 36667 056 193103700 1250 Channing Way 1250 CHANNING WAY 1250 CHANNING WY 1250.0 CHANNING WY     Berkeley 94702 37.86310625106843 -122.28652733041925
37068 37068 37068 056 192501800 1213 Channing Way 1213 CHANNING WAY 1213 CHANNING WY 1213.0 CHANNING WY     Berkeley 94702 37.863403073273034 -122.28770214265622
37561 37561 37561 056 191501900 1433 Channing Way 1433 CHANNING WAY 1433 CHANNING WY 1433.0 CHANNING WY     Berkeley 94702 37.86413802702943 -122.28178746055242
38297 38297 38297 056 193103700 1336 Channing Way A 1336 CHANNING WAY A 1336 CHANNING WY 1336.0 CHANNING WY A   Berkeley 94702 37.86310625106843 -122.28652733041925
39705 39705 39705 056 193103700 1336 Channing Way B 1336 CHANNING WAY B 1336 CHANNING WY 1336.0 CHANNING WY B   Berkeley 94702 37.86310625106843 -122.28652733041925
40782 40782 40782 056 193100200 1226 Channing Way 1226 CHANNING WAY 1226 CHANNING WY 1226.0 CHANNING WY     Berkeley 94702 37.86305949907402 -122.28688221885538
40853 40853 40853 056 192402201 1231 Channing Way 1231 CHANNING WAY 1231 CHANNING WY 1231.0 CHANNING WY     Berkeley 94702 37.863517580392944 -122.28679449657125
42269 42269 42269 056 193000400 1212 Channing Way 1212 CHANNING WAY 1212 CHANNING WY 1212.0 CHANNING WY     Berkeley 94702 37.86296573826475 -122.2876101174419
42696 42696 42696 056 192000100 1300 Channing Way 1300 CHANNING WAY 1300 CHANNING WY 1300.0 CHANNING WY     Berkeley 94702 37.86317793286341 -122.2859660675213
43318 43318 43318 056 193103700 1336 Channing Way C 1336 CHANNING WAY C 1336 CHANNING WY 1336.0 CHANNING WY C   Berkeley 94702 37.86310625106843 -122.28652733041925
43606 43606 43606 056 191903700 1464 Channing Way 1464 CHANNING WAY 1464 CHANNING WY 1464.0 CHANNING WY     Berkeley 94702 37.86381066561253 -122.2817273695481
43846 43846 43846 056 192000400 1310 Channing Way 1310 CHANNING WAY 1310 CHANNING WY 1310.0 CHANNING WY     Berkeley 94702 37.863182021405855 -122.28554695133896
44636 44636 44636 056 193000600 1220 Channing Way 1220 CHANNING WAY 1220 CHANNING WY 1220.0 CHANNING WY     Berkeley 94702 37.86301851002818 -122.28734380468936
45154 45154 45154 056 191501900 1431 Channing Way 1431 CHANNING WAY 1431 CHANNING WY 1431.0 CHANNING WY     Berkeley 94702 37.86409700596066 -122.28177781983278
46827 46827 46827 056 191502100 1425 Channing Way 1425 CHANNING WAY 1425 CHANNING WY 1425.0 CHANNING WY     Berkeley 94702 37.8641330903469 -122.28201327994684
49148 49148 49148 056 192401900 1237 Channing Way 1237 CHANNING WAY 1237 CHANNING WY 1237.0 CHANNING WY     Berkeley 94702 37.86360892143046 -122.28649529469956
49566 49566 49566 056 191900300 1412 Channing Way 1412 CHANNING WAY 1412 CHANNING WY 1412.0 CHANNING WY     Berkeley 94702 37.86370764366382 -122.28254075630863
49962 49962 49962 056 192000300 1306 Channing Way 1306 CHANNING WAY 1306 CHANNING WY 1306.0 CHANNING WY     Berkeley 94702 37.86321031638254 -122.2857044170251
50692 50692 50692 056 192700900 1123 Channing Way 1123 CHANNING WAY 1123 CHANNING WY 1123.0 CHANNING WY     Berkeley 94702 37.8632570016165 -122.28903254938864
50960 50960 50960 056 192700500 1135 Channing Way 1135 CHANNING WAY 1135 CHANNING WY 1135.0 CHANNING WY     Berkeley 94702 37.86330532010746 -122.28854940847938
51211 51211 51211 056 192900400 1134 Channing Way 1134 CHANNING WAY 1134 CHANNING WY 1134.0 CHANNING WY     Berkeley 94702 37.862849180687995 -122.288516843652
51911 51911 51911 056 192000500 1314 Channing Way 1314 CHANNING WAY 1314 CHANNING WY 1314.0 CHANNING WY     Berkeley 94702 37.86319999822411 -122.28540540110468
52216 52216 52216 056 192701200 1113 Channing Way 1113 CHANNING WAY 1113 CHANNING WY 1113.0 CHANNING WY     Berkeley 94702 37.86320951144 -122.2894167507508
52558 52558 52558 056 191900200 1408 Channing Way 1408 CHANNING WAY 1408 CHANNING WY 1408.0 CHANNING WY     Berkeley 94702 37.86365900629838 -122.28279610781804
52969 52969 52969 056 192701400 1109 Channing Way 1109 CHANNING WAY 1109 CHANNING WY 1109.0 CHANNING WY     Berkeley 94702 37.86319780750352 -122.28963327887028
53646 53646 53646 056 192402400 1225 Channing Way 1225 CHANNING WAY 1225 CHANNING WY 1225.0 CHANNING WY     Berkeley 94702 37.86348042268892 -122.2871028244279
53904 53904 53904 056 192800300 1114 Channing Way 1114 CHANNING WAY 1114 CHANNING WY 1114.0 CHANNING WY     Berkeley 94702 37.86274054545636 -122.28935353450764
54307 54307 54307 056 192700600 1133 Channing Way 1133 CHANNING WAY 1133 CHANNING WY 1133.0 CHANNING WY     Berkeley 94702 37.86330368469326 -122.28867166200304
54370 54370 54370 056 191900100 1400 Channing Way 1400 CHANNING WAY 1400 CHANNING WY 1400.0 CHANNING WY     Berkeley 94702 37.86363409010563 -122.28300685078707
54513 54513 54513 056 192900500 1138 Channing Way 1138 CHANNING WAY 1138 CHANNING WY 1138.0 CHANNING WY     Berkeley 94702 37.86286707602905 -122.2883735039737
55721 55721 55721 056 192900200 1128 Channing Way 1128 CHANNING WAY 1128 CHANNING WY 1128.0 CHANNING WY     Berkeley 94702 37.86281762252395 -122.28877589891532
56321 56321 56321 056 192800300 1112 Channing Way 1112 CHANNING WAY 1112 CHANNING WY 1112.0 CHANNING WY     Berkeley 94702 37.86274054545636 -122.28935353450764
56951 56951 56951 056 192201400 1309 Channing Way 1309 CHANNING WAY 1309 CHANNING WY 1309.0 CHANNING WY     Berkeley 94702 37.863653531303854 -122.28573591555224
57647 57647 57647 056 191602000 1411 Channing Way 1411 CHANNING WAY 1411 CHANNING WY 1411.0 CHANNING WY     Berkeley 94702 37.864052538194215 -122.28258389520522
57942 57942 57942 056 192700800 1125 Channing Way 1125 CHANNING WAY 1125 CHANNING WY 1125.0 CHANNING WY     Berkeley 94702 37.86327416212745 -122.2889038369781

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