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

128 rows where street_name = "CHANNING" and zipcode = 94710

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94710 · 128 ✖

street_type 1

street_name 1

  • CHANNING · 128 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
2095 2095 2095 056 194400300 732 Channing Way 732 CHANNING WAY 732 CHANNING WY 732.0 CHANNING WY     Berkeley 94710 37.86121024178439 -122.297219549648
2234 2234 2234 056 193600500 944 Channing Way A 944 CHANNING WAY A 944 CHANNING WY 944.0 CHANNING WY A   Berkeley 94710 37.86210627658813 -122.29272497105777
3217 3217 3217 056 193500400 1020 Channing Way 1020 CHANNING WAY 1020 CHANNING WY 1020.0 CHANNING WY     Berkeley 94710 37.86238025283631 -122.29159345043092
4542 4542 4542 056 194101201 839 Channing Way 3 839 CHANNING WAY 3 839 CHANNING WY 839.0 CHANNING WY 3   Berkeley 94710 37.862124843732325 -122.2950526047736
5179 5179 5179 056 193600300 936 Channing Way 936 CHANNING WAY 936 CHANNING WY 936.0 CHANNING WY     Berkeley 94710 37.86205424316996 -122.29300169977596
5576 5576 5576 056 194300400 810 Channing Way 810 CHANNING WAY 810 CHANNING WY 810.0 CHANNING WY     Berkeley 94710 37.86142686837409 -122.29610036917828
5822 5822 5822 056 193401700 1019 Channing Way 1019 CHANNING WAY 1019 CHANNING WY 1019.0 CHANNING WY     Berkeley 94710 37.86278790544138 -122.2915322176679
6288 6288 6288 056 193302100 1031 Channing Way 1031 CHANNING WAY 1031 CHANNING WY 1031.0 CHANNING WY     Berkeley 94710 37.8628921251022 -122.2910064157658
6617 6617 6617 056 194300500 818 Channing Way 818 CHANNING WAY 818 CHANNING WY 818.0 CHANNING WY     Berkeley 94710 37.861457926426205 -122.29594607993496
7470 7470 7470 056 194500600 753 Channing Way 753 CHANNING WAY 753 CHANNING WY 753.0 CHANNING WY     Berkeley 94710 37.86156550327016 -122.29715930772676
8599 8599 8599 056 194101201 835 Channing Way D 835 CHANNING WAY D 835 CHANNING WY 835.0 CHANNING WY D   Berkeley 94710 37.862124843732325 -122.2950526047736
8605 8605 8605 056 193200200 1034 Channing Way 1034 CHANNING WAY 1034 CHANNING WY 1034.0 CHANNING WY     Berkeley 94710 37.86257148497605 -122.2907335201589
8701 8701 8701 056 194700200 710 Channing Way 710 CHANNING WAY 710 CHANNING WY 710.0 CHANNING WY     Berkeley 94710 37.861022350092185 -122.2982367812145
9011 9011 9011 056 194101400 827 Channing Way 827 CHANNING WAY 827 CHANNING WY 827.0 CHANNING WY     Berkeley 94710 37.8619571385632 -122.29540813550516
9265 9265 9265 056 193701500 945 Channing Way 945 CHANNING WAY 945 CHANNING WY 945.0 CHANNING WY     Berkeley 94710 37.862530116233 -122.29285113764276
9470 9470 9470 056 193500200 1006 Channing Way 4 1006 CHANNING WAY 4 1006 CHANNING WY 1006.0 CHANNING WY 4   Berkeley 94710 37.86226090359388 -122.29191362347292
9596 9596 9596 056 193601400 949 Channing Way B 949 CHANNING WAY B 949 CHANNING WY 949.0 CHANNING WY B   Berkeley 94710 37.86114746091883 -122.29236308384723
9952 9952 9952 056 193301900 1037 Channing Way Uplef 1037 CHANNING WAY UPLEF 1037 CHANNING WY 1037.0 CHANNING WY UPLEF   Berkeley 94710 37.8629476649377 -122.2907452225121
10280 10280 10280 056 193701600 937 Channing Way C 937 CHANNING WAY C 937 CHANNING WY 937.0 CHANNING WY C   Berkeley 94710 37.86249638350267 -122.29301926633136
10751 10751 10751 056 194101201 835 Channing Way 835 CHANNING WAY 835 CHANNING WY 835.0 CHANNING WY     Berkeley 94710 37.862124843732325 -122.2950526047736
12107 12107 12107 056 193601400 949 Channing Way A 949 CHANNING WAY A 949 CHANNING WY 949.0 CHANNING WY A   Berkeley 94710 37.86114746091883 -122.29236308384723
12305 12305 12305 056 193600600 950 Channing Way 950 CHANNING WAY 950 CHANNING WY 950.0 CHANNING WY     Berkeley 94710 37.8621415683423 -122.29255077514776
12500 12500 12500 056 193900200 906 Channing Way 906 CHANNING WAY 906 CHANNING WY 906.0 CHANNING WY     Berkeley 94710 37.86182261146123 -122.29416974680058
13380 13380 13380 056 193900300 910 Channing Way 910 CHANNING WAY 910 CHANNING WY 910.0 CHANNING WY     Berkeley 94710 37.8618621770716 -122.293991315334
14714 14714 14714 056 193900200 906 Channing Way C 906 CHANNING WAY C 906 CHANNING WY 906.0 CHANNING WY C   Berkeley 94710 37.86182261146123 -122.29416974680058
15074 15074 15074 056 193701600 937 Channing Way 6 937 CHANNING WAY 6 937 CHANNING WY 937.0 CHANNING WY 6   Berkeley 94710 37.86249638350267 -122.29301926633136
15781 15781 15781 056 194000300 834 Channing Way 834 CHANNING WAY 834 CHANNING WY 834.0 CHANNING WY     Berkeley 94710 37.86163145893817 -122.29510062870864
17906 17906 17906 056 193301900 1037 Channing Way 1037 CHANNING WAY 1037 CHANNING WY 1037.0 CHANNING WY     Berkeley 94710 37.8629476649377 -122.2907452225121
17929 17929 17929 056 193600200 930 Channing Way 930 CHANNING WAY 930 CHANNING WY 930.0 CHANNING WY     Berkeley 94710 37.86202312154005 -122.29316283328345
18513 18513 18513 056 193401900 1011 Channing Way 1011 CHANNING WAY 1011 CHANNING WY 1011.0 CHANNING WY     Berkeley 94710 37.86271699204552 -122.29187782111728
19145 19145 19145 056 193401800 1015 Channing Way A 1015 CHANNING WAY A 1015 CHANNING WY 1015.0 CHANNING WY A   Berkeley 94710 37.86275002468969 -122.29171068596538
19255 19255 19255 056 194201600 805 Channing Way 805 CHANNING WAY 805 CHANNING WY 805.0 CHANNING WY     Berkeley 94710 37.86179014719116 -122.29654483222464
19617 19617 19617 056 193200301 1038 Channing Way 1038 CHANNING WAY 1038 CHANNING WY 1038.0 CHANNING WY     Berkeley 94710 37.86260675381283 -122.29057419496012
20509 20509 20509 056 193802100 907 Channing Way Back 907 CHANNING WAY BACK 907 CHANNING WY 907.0 CHANNING WY BACK   Berkeley 94710 37.86224857823901 -122.29431257533749
20645 20645 20645 056 193801700 919 Channing Way 919 CHANNING WAY 919 CHANNING WY 919.0 CHANNING WY     Berkeley 94710 37.86235316886944 -122.29379314338904
21545 21545 21545 056 193401800 1015 Channing Way 2 1015 CHANNING WAY 2 1015 CHANNING WY 1015.0 CHANNING WY 2   Berkeley 94710 37.86275002468969 -122.29171068596538
23018 23018 23018 056 193801903 917 Channing Way 917 CHANNING WAY 917 CHANNING WY 917.0 CHANNING WY     Berkeley 94710 37.86232922668832 -122.29391467376892
23090 23090 23090 056 193701600 937 Channing Way 1 937 CHANNING WAY 1 937 CHANNING WY 937.0 CHANNING WY 1   Berkeley 94710 37.86249638350267 -122.29301926633136
23138 23138 23138 056 193802000 911 Channing Way 911 CHANNING WAY 911 CHANNING WY 911.0 CHANNING WY     Berkeley 94710 37.86227880049616 -122.29417038280776
23177 23177 23177 056 194101201 835 Channing Way C 835 CHANNING WAY C 835 CHANNING WY 835.0 CHANNING WY C   Berkeley 94710 37.862124843732325 -122.2950526047736
23434 23434 23434 056 193701500 947 Channing Way 947 CHANNING WAY 947 CHANNING WY 947.0 CHANNING WY     Berkeley 94710 37.862530116233 -122.29285113764276
23903 23903 23903 056 194201500 809 Channing Way 809 CHANNING WAY 809 CHANNING WY 809.0 CHANNING WY     Berkeley 94710 37.86182343840455 -122.29639053040492
23968 23968 23968 056 193402000 1007 Channing Way 1007 CHANNING WAY 1007 CHANNING WY 1007.0 CHANNING WY     Berkeley 94710 37.86268329131492 -122.29204589590694
24878 24878 24878 056 194300600 820 Channing Way 820 CHANNING WAY 820 CHANNING WY 820.0 CHANNING WY     Berkeley 94710 37.86154831753872 -122.29581487649612
25156 25156 25156 056 194000600 850 Channing Way 850 CHANNING WAY 850 CHANNING WY 850.0 CHANNING WY     Berkeley 94710 37.86175123189185 -122.29473189633568
26321 26321 26321 056 193701800 933 Channing Way 933 CHANNING WAY 933 CHANNING WY 933.0 CHANNING WY     Berkeley 94710 37.86244250641952 -122.29328823270718
26387 26387 26387 056 193402102 1003 Channing Way 1003 CHANNING WAY 1003 CHANNING WY 1003.0 CHANNING WY     Berkeley 94710 37.86262375774069 -122.29215933336438
27381 27381 27381 056 194400102 720 Channing Way 720 CHANNING WAY 720 CHANNING WY 720.0 CHANNING WY     Berkeley 94710 37.86119728504815 -122.29757322176526
29554 29554 29554 056 193500102 1000 Channing Way 1000 CHANNING WAY 1000 CHANNING WY 1000.0 CHANNING WY     Berkeley 94710 37.86227418070575 -122.29211049016574
29871 29871 29871 056 194500701 739 Channing Way 739 CHANNING WAY 739 CHANNING WY 739.0 CHANNING WY     Berkeley 94710 37.861617315758 -122.29738721480592
29902 29902 29902 056 194000500 840 Channing Way 840 CHANNING WAY 840 CHANNING WY 840.0 CHANNING WY     Berkeley 94710 37.86172288812835 -122.29487238116803
30359 30359 30359 056 194500702 725 Channing Way 725 CHANNING WAY 725 CHANNING WY 725.0 CHANNING WY     Berkeley 94710 37.86159437687854 -122.29767562701272
30644 30644 30644 056 193801902 913 Channing Way 913 CHANNING WAY 913 CHANNING WY 913.0 CHANNING WY     Berkeley 94710 37.86230311928374 -122.29405011635755
30957 30957 30957 056 193302200 1021 Channing Way 1021 CHANNING WAY 1021 CHANNING WY 1021.0 CHANNING WY     Berkeley 94710 37.86286334845395 -122.29115369006506
31230 31230 31230 056 194000200 828 Channing Way 828 CHANNING WAY 828 CHANNING WY 828.0 CHANNING WY     Berkeley 94710 37.861608063328056 -122.2952194955837
31626 31626 31626 056 194300300 806 Channing Way 806 CHANNING WAY 806 CHANNING WY 806.0 CHANNING WY     Berkeley 94710 37.86139667342708 -122.29625031147393
31645 31645 31645 056 193900600 922 Channing Way 922 CHANNING WAY 922 CHANNING WY 922.0 CHANNING WY     Berkeley 94710 37.86198933113145 -122.29364454407477
31683 31683 31683 056 193600500 944 Channing Way B 944 CHANNING WAY B 944 CHANNING WY 944.0 CHANNING WY B   Berkeley 94710 37.86210627658813 -122.29272497105777
32211 32211 32211 056 194000400 836 Channing Way 836 CHANNING WAY 836 CHANNING WY 836.0 CHANNING WY     Berkeley 94710 37.861656373680354 -122.29498334825844
32315 32315 32315 056 194500600 741 Channing Way 741 CHANNING WAY 741 CHANNING WY 741.0 CHANNING WY     Berkeley 94710 37.86171069530673 -122.2971525982099
32908 32908 32908 056 193200200 1034 Channing Way A 1034 CHANNING WAY A 1034 CHANNING WY 1034.0 CHANNING WY A   Berkeley 94710 37.86257148497605 -122.2907335201589
33402 33402 33402 056 194400400 736 Channing Way 736 CHANNING WAY 736 CHANNING WY 736.0 CHANNING WY     Berkeley 94710 37.86124920559622 -122.2970618387218
33645 33645 33645 056 193600100 926 Channing Way 926 CHANNING WAY 926 CHANNING WY 926.0 CHANNING WY     Berkeley 94710 37.86199253818907 -122.29329647744488
33761 33761 33761 056 193500200 1006 Channing Way 2 1006 CHANNING WAY 2 1006 CHANNING WY 1006.0 CHANNING WY 2   Berkeley 94710 37.86226090359388 -122.29191362347292
33776 33776 33776 056 194500600 755 Channing Way 755 CHANNING WAY 755 CHANNING WY 755.0 CHANNING WY     Berkeley 94710 37.86157648051923 -122.29710788995654
34201 34201 34201 056 193500200 1006 Channing Way 1006 CHANNING WAY 1006 CHANNING WY 1006.0 CHANNING WY     Berkeley 94710 37.86226090359388 -122.29191362347292
34805 34805 34805 056 194300100 800 Channing Way 800 CHANNING WAY 800 CHANNING WY 800.0 CHANNING WY     Berkeley 94710 37.86133622321237 -122.29655719394128
35004 35004 35004 056 193500200 1006 Channing Way 1 1006 CHANNING WAY 1 1006 CHANNING WY 1006.0 CHANNING WY 1   Berkeley 94710 37.86226090359388 -122.29191362347292
35054 35054 35054 056 194300300 806 Channing Way 1 806 CHANNING WAY 1 806 CHANNING WY 806.0 CHANNING WY 1   Berkeley 94710 37.86139667342708 -122.29625031147393
35630 35630 35630 056 193701400 949 Channing Way 949 CHANNING WAY 949 CHANNING WY 949.0 CHANNING WY     Berkeley 94710 37.86256428723766 -122.29267786430256
37840 37840 37840 056 193200200 1034 Channing Way B 1034 CHANNING WAY B 1034 CHANNING WY 1034.0 CHANNING WY B   Berkeley 94710 37.86257148497605 -122.2907335201589
37975 37975 37975 056 194000400 836 Channing Way 1 836 CHANNING WAY 1 836 CHANNING WY 836.0 CHANNING WY 1   Berkeley 94710 37.861656373680354 -122.29498334825844
38306 38306 38306 056 193701600 937 Channing Way 937 CHANNING WAY 937 CHANNING WY 937.0 CHANNING WY     Berkeley 94710 37.86249638350267 -122.29301926633136
38318 38318 38318 056 193401700 1019 Channing Way 1 1019 CHANNING WAY 1 1019 CHANNING WY 1019.0 CHANNING WY 1   Berkeley 94710 37.86278790544138 -122.2915322176679
38892 38892 38892 056 194500600 747 Channing Way 747 CHANNING WAY 747 CHANNING WY 747.0 CHANNING WY     Berkeley 94710 37.86164469715666 -122.29712984298544
39093 39093 39093 056 194500600 751 Channing Way 751 CHANNING WAY 751 CHANNING WY 751.0 CHANNING WY     Berkeley 94710 37.86165551907577 -122.2970812638915
39331 39331 39331 056 193701600 937 Channing Way D 937 CHANNING WAY D 937 CHANNING WY 937.0 CHANNING WY D   Berkeley 94710 37.86249638350267 -122.29301926633136
39711 39711 39711 056 193900300 908 Channing Way 908 CHANNING WAY 908 CHANNING WY 908.0 CHANNING WY     Berkeley 94710 37.8618621770716 -122.293991315334
40033 40033 40033 056 193701600 937 Channing Way 4 937 CHANNING WAY 4 937 CHANNING WY 937.0 CHANNING WY 4   Berkeley 94710 37.86249638350267 -122.29301926633136
40941 40941 40941 056 193900200 906 Channing Way A 906 CHANNING WAY A 906 CHANNING WY 906.0 CHANNING WY A   Berkeley 94710 37.86182261146123 -122.29416974680058
40952 40952 40952 056 193401800 1015 Channing Way 1015 CHANNING WAY 1015 CHANNING WY 1015.0 CHANNING WY     Berkeley 94710 37.86275002468969 -122.29171068596538
40999 40999 40999 056 193600500 944 Channing Way 944 CHANNING WAY 944 CHANNING WY 944.0 CHANNING WY     Berkeley 94710 37.86210627658813 -122.29272497105777
41290 41290 41290 056 193701600 939 Channing Way 939 CHANNING WAY 939 CHANNING WY 939.0 CHANNING WY     Berkeley 94710 37.86249638350267 -122.29301926633136
41819 41819 41819 056 193500200 1006 Channing Way 3 1006 CHANNING WAY 3 1006 CHANNING WY 1006.0 CHANNING WY 3   Berkeley 94710 37.86226090359388 -122.29191362347292
42889 42889 42889 056 193802100 907 Channing Way A 907 CHANNING WAY A 907 CHANNING WY 907.0 CHANNING WY A   Berkeley 94710 37.86224857823901 -122.29431257533749
42957 42957 42957 056 193301900 1039 Channing Way 1039 CHANNING WAY 1039 CHANNING WY 1039.0 CHANNING WY     Berkeley 94710 37.8629476649377 -122.2907452225121
43261 43261 43261 056 194101201 835 Channing Way A 835 CHANNING WAY A 835 CHANNING WY 835.0 CHANNING WY A   Berkeley 94710 37.862124843732325 -122.2950526047736
43798 43798 43798 056 193401700 1019 Channing Way 2 1019 CHANNING WAY 2 1019 CHANNING WY 1019.0 CHANNING WY 2   Berkeley 94710 37.86278790544138 -122.2915322176679
43947 43947 43947 056 194201400 813 Channing Way 813 CHANNING WAY 813 CHANNING WY 813.0 CHANNING WY     Berkeley 94710 37.861853571475145 -122.29624141366102
44109 44109 44109 056 193701700 935 Channing Way 935 CHANNING WAY 935 CHANNING WY 935.0 CHANNING WY     Berkeley 94710 37.86246575495877 -122.29316930115348
44322 44322 44322 056 193900200 906 Channing Way B 906 CHANNING WAY B 906 CHANNING WY 906.0 CHANNING WY B   Berkeley 94710 37.86182261146123 -122.29416974680058
44660 44660 44660 056 194101201 835 Channing Way B 835 CHANNING WAY B 835 CHANNING WY 835.0 CHANNING WY B   Berkeley 94710 37.862124843732325 -122.2950526047736
44824 44824 44824 056 193900501 914 Channing Way 914 CHANNING WAY 914 CHANNING WY 914.0 CHANNING WY     Berkeley 94710 37.86189908169323 -122.29380870939627
45351 45351 45351 056 193500300 1008 Channing Way 1008 CHANNING WAY 1008 CHANNING WY 1008.0 CHANNING WY     Berkeley 94710 37.862295232876995 -122.29174462162187
45446 45446 45446 056 193401800 1017 Channing Way 1017 CHANNING WAY 1017 CHANNING WY 1017.0 CHANNING WY     Berkeley 94710 37.86275002468969 -122.29171068596538
45471 45471 45471 056 193801600 921 Channing Way 921 CHANNING WAY 921 CHANNING WY 921.0 CHANNING WY     Berkeley 94710 37.86235138875551 -122.29370528186608
45701 45701 45701 056 194101201 839 Channing Way 1 839 CHANNING WAY 1 839 CHANNING WY 839.0 CHANNING WY 1   Berkeley 94710 37.862124843732325 -122.2950526047736
45939 45939 45939 056 193401700 1019 Channing Way B 1019 CHANNING WAY B 1019 CHANNING WY 1019.0 CHANNING WY B   Berkeley 94710 37.86278790544138 -122.2915322176679
46130 46130 46130 056 193401700 1019 Channing Way 3 1019 CHANNING WAY 3 1019 CHANNING WY 1019.0 CHANNING WY 3   Berkeley 94710 37.86278790544138 -122.2915322176679
46401 46401 46401 056 194500600 745 Channing Way 745 CHANNING WAY 745 CHANNING WY 745.0 CHANNING WY     Berkeley 94710 37.8616337199177 -122.29718126075566

Next page

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