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

165 rows where street_name = "ELLIS" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94703 · 165 ✖

street_type 1

street_name 1

  • ELLIS · 165 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
91 91 91 053 160400900 2912 Ellis St 2912 ELLIS ST 2912 ELLIS ST 2912.0 ELLIS ST     Berkeley 94703 37.855169596152535 -122.27364212685085
460 460 460 053 160203000 3009 Ellis St 3009 ELLIS ST 3009 ELLIS ST 3009.0 ELLIS ST     Berkeley 94703 37.8536597827943 -122.27286220143633
1191 1191 1191 052 153300500 3244 Ellis St D 3244 ELLIS ST D 3244 ELLIS ST 3244.0 ELLIS ST D   Berkeley 94703 37.84878961556945 -122.27280392233398
1329 1329 1329 053 160200100 3001 Ellis St D 3001 ELLIS ST D 3001 ELLIS ST 3001.0 ELLIS ST D   Berkeley 94703 37.85391340828638 -122.2728767918732
1404 1404 1404 052 154600900 3114 Ellis St B 3114 ELLIS ST B 3114 ELLIS ST 3114.0 ELLIS ST B   Berkeley 94703 37.851600388891214 -122.27329935489124
1792 1792 1792 052 153300500 3244 Ellis St A 3244 ELLIS ST A 3244 ELLIS ST 3244.0 ELLIS ST A   Berkeley 94703 37.8487751677467 -122.27291228251342
2228 2228 2228 052 154901500 3113 Ellis St 3113 ELLIS ST 3113 ELLIS ST 3113.0 ELLIS ST     Berkeley 94703 37.85171331697872 -122.27264842755154
2356 2356 2356 053 160202701 3023 Ellis St 3023 ELLIS ST 3023 ELLIS ST 3023.0 ELLIS ST     Berkeley 94703 37.85324636774036 -122.27281728207886
3032 3032 3032 053 160302400 2929 Ellis St 2929 ELLIS ST 2929 ELLIS ST 2929.0 ELLIS ST     Berkeley 94703 37.85471743368712 -122.27295749202672
3678 3678 3678 052 153001300 3221 Ellis St A 3221 ELLIS ST A 3221 ELLIS ST 3221.0 ELLIS ST A   Berkeley 94703 37.849799189894306 -122.2723679295024
4057 4057 4057 052 153300102 3240 Ellis St G 3240 ELLIS ST G 3240 ELLIS ST 3240.0 ELLIS ST G   Berkeley 94703 37.848920140964424 -122.27289309180402
4446 4446 4446 052 154700800 3140 Ellis St 8 3140 ELLIS ST 8 3140 ELLIS ST 3140.0 ELLIS ST 8   Berkeley 94703 37.850530431933215 -122.27305494845528
4482 4482 4482 053 160401100 2922 Ellis St 2922 ELLIS ST 2922 ELLIS ST 2922.0 ELLIS ST     Berkeley 94703 37.854953465400584 -122.27361707104092
4538 4538 4538 052 154801700 3143 Ellis St B 3143 ELLIS ST B 3143 ELLIS ST 3143.0 ELLIS ST B   Berkeley 94703 37.85079906534274 -122.27244738459096
4910 4910 4910 053 160302900 2917 Ellis St 2917 ELLIS ST 2917 ELLIS ST 2917.0 ELLIS ST     Berkeley 94703 37.855225509922256 -122.2730112570948
4914 4914 4914 052 153101400 3225 Ellis St 3225 ELLIS ST 3225 ELLIS ST 3225.0 ELLIS ST     Berkeley 94703 37.84938544037623 -122.27246121056152
5126 5126 5126 052 153300400 3230 Ellis St 3230 ELLIS ST 3230 ELLIS ST 3230.0 ELLIS ST     Berkeley 94703 37.849198319382424 -122.27300744554304
6211 6211 6211 052 153101202 3233 Ellis St 3233 ELLIS ST 3233 ELLIS ST 3233.0 ELLIS ST     Berkeley 94703 37.849195432387745 -122.27238652193384
6830 6830 6830 052 154601000 3116 Ellis St 1 3116 ELLIS ST 1 3116 ELLIS ST 3116.0 ELLIS ST 1   Berkeley 94703 37.8515461889088 -122.27314752074362
7323 7323 7323 052 154601100 3120 Ellis St A 3120 ELLIS ST A 3120 ELLIS ST 3120.0 ELLIS ST A   Berkeley 94703 37.85141001563942 -122.27310609223932
7505 7505 7505 053 160203000 3009 Ellis St B 3009 ELLIS ST B 3009 ELLIS ST 3009.0 ELLIS ST B   Berkeley 94703 37.85361469022741 -122.27281820015708
7579 7579 7579 053 160302501 2925 Ellis St 3 2925 ELLIS ST 3 2925 ELLIS ST 2925.0 ELLIS ST 3   Berkeley 94703 37.854877180886874 -122.27297527507608
7936 7936 7936 053 160303100 2909 Ellis St 2909 ELLIS ST 2909 ELLIS ST 2909.0 ELLIS ST     Berkeley 94703 37.85540951395756 -122.27303467797088
8867 8867 8867 052 154600900 3114 Ellis St C 3114 ELLIS ST C 3114 ELLIS ST 3114.0 ELLIS ST C   Berkeley 94703 37.85160580023367 -122.27325026106269
9414 9414 9414 053 160302501 2925 Ellis St 9 2925 ELLIS ST 9 2925 ELLIS ST 2925.0 ELLIS ST 9   Berkeley 94703 37.854877180886874 -122.27297527507608
9762 9762 9762 052 153400800 3208 Ellis St 1 3208 ELLIS ST 1 3208 ELLIS ST 3208.0 ELLIS ST 1   Berkeley 94703 37.84977673393718 -122.27314490484952
10544 10544 10544 052 154901700 3107 Ellis St 3107 ELLIS ST 3107 ELLIS ST 3107.0 ELLIS ST     Berkeley 94703 37.85192756550269 -122.27280595162816
10602 10602 10602 052 153400800 3208 Ellis St A 3208 ELLIS ST A 3208 ELLIS ST 3208.0 ELLIS ST A   Berkeley 94703 37.84978637443692 -122.2730699790666
10715 10715 10715 052 154700300 3130 Ellis St 3130 ELLIS ST 3130 ELLIS ST 3130.0 ELLIS ST     Berkeley 94703 37.85115226182508 -122.27313993626768
10745 10745 10745 053 160200100 3001 Ellis St A 3001 ELLIS ST A 3001 ELLIS ST 3001.0 ELLIS ST A   Berkeley 94703 37.85391340828638 -122.2728767918732
11155 11155 11155 053 160202200 3035 Ellis St 3035 ELLIS ST 3035 ELLIS ST 3035.0 ELLIS ST     Berkeley 94703 37.85271038387953 -122.27275256295422
11818 11818 11818 053 160302501 2925 Ellis St 11 2925 ELLIS ST 11 2925 ELLIS ST 2925.0 ELLIS ST 11   Berkeley 94703 37.854877180886874 -122.27297527507608
12000 12000 12000 053 160302501 2925 Ellis St 10 2925 ELLIS ST 10 2925 ELLIS ST 2925.0 ELLIS ST 10   Berkeley 94703 37.854877180886874 -122.27297527507608
12326 12326 12326 053 160203100 3005 Ellis St D 3005 ELLIS ST D 3005 ELLIS ST 3005.0 ELLIS ST D   Berkeley 94703 37.85374406157477 -122.27288063396765
13112 13112 13112 053 160202701 3023 Ellis St B 3023 ELLIS ST B 3023 ELLIS ST 3023.0 ELLIS ST B   Berkeley 94703 37.853207613196375 -122.27274204368224
13386 13386 13386 052 154700800 3140 Ellis St 2 3140 ELLIS ST 2 3140 ELLIS ST 3140.0 ELLIS ST 2   Berkeley 94703 37.85050659160092 -122.27323850031895
13708 13708 13708 052 154801800 3139 Ellis St 3139 ELLIS ST 3139 ELLIS ST 3139.0 ELLIS ST     Berkeley 94703 37.8508910484703 -122.2725577192674
14067 14067 14067 052 153101101 3237 Ellis St 3237 ELLIS ST 3237 ELLIS ST 3237.0 ELLIS ST     Berkeley 94703 37.84907488642637 -122.27237150120396
14759 14759 14759 052 153001400 3219 Ellis St 3219 ELLIS ST 3219 ELLIS ST 3219.0 ELLIS ST     Berkeley 94703 37.84989192970424 -122.27245682857952
14846 14846 14846 053 160202900 3011 Ellis St B 3011 ELLIS ST B 3011 ELLIS ST 3011.0 ELLIS ST B   Berkeley 94703 37.853497983097135 -122.27267532131452
14957 14957 14957 052 153300500 3244 Ellis St 3244 ELLIS ST 3244 ELLIS ST 3244.0 ELLIS ST     Berkeley 94703 37.8488245398778 -122.2728651092829
15061 15061 15061 052 153001300 3221 Ellis St 3221 ELLIS ST 3221 ELLIS ST 3221.0 ELLIS ST     Berkeley 94703 37.84978245964652 -122.27249094120414
15477 15477 15477 053 160400700 2908 Ellis St 2908 ELLIS ST 2908 ELLIS ST 2908.0 ELLIS ST     Berkeley 94703 37.855378448391846 -122.27366184307472
16099 16099 16099 052 153300500 3244 Ellis St C 3244 ELLIS ST C 3244 ELLIS ST 3244.0 ELLIS ST C   Berkeley 94703 37.84878505806476 -122.27283810412884
16219 16219 16219 053 160202701 3023 Ellis St 3 3023 ELLIS ST 3 3023 ELLIS ST 3023.0 ELLIS ST 3   Berkeley 94703 37.853190736188296 -122.2728759456602
16547 16547 16547 052 154700700 3138 Ellis St C 3138 ELLIS ST C 3138 ELLIS ST 3138.0 ELLIS ST C   Berkeley 94703 37.85068662386775 -122.27314218564914
16659 16659 16659 052 153101301 3231 Ellis St 3231 ELLIS ST 3231 ELLIS ST 3231.0 ELLIS ST     Berkeley 94703 37.84929531879174 -122.27239553473106
17647 17647 17647 052 154700800 3140 Ellis St 5 3140 ELLIS ST 5 3140 ELLIS ST 3140.0 ELLIS ST 5   Berkeley 94703 37.85051845502222 -122.27314716411244
17707 17707 17707 052 153400600 3204 Ellis St 3204 ELLIS ST 3204 ELLIS ST 3204.0 ELLIS ST     Berkeley 94703 37.85003425422627 -122.27309936924776
17718 17718 17718 053 160203100 3005 Ellis St E 3005 ELLIS ST E 3005 ELLIS ST 3005.0 ELLIS ST E   Berkeley 94703 37.85374864147024 -122.27284403750129
17835 17835 17835 053 160203100 3005 Ellis St C 3005 ELLIS ST C 3005 ELLIS ST 3005.0 ELLIS ST C   Berkeley 94703 37.853739378122455 -122.27291806676553
17925 17925 17925 052 154700700 3138 Ellis St F 3138 ELLIS ST F 3138 ELLIS ST 3138.0 ELLIS ST F   Berkeley 94703 37.85067234097925 -122.2732571340729
18969 18969 18969 053 160401000 2916 Ellis St 2916 ELLIS ST 2916 ELLIS ST 2916.0 ELLIS ST     Berkeley 94703 37.85505828413161 -122.27362996366188
18975 18975 18975 053 160401500 2934 Ellis St 2934 ELLIS ST 2934 ELLIS ST 2934.0 ELLIS ST     Berkeley 94703 37.85454433387382 -122.27357773471296
19388 19388 19388 052 153001500 3207 Ellis St 3207 ELLIS ST 3207 ELLIS ST 3207.0 ELLIS ST     Berkeley 94703 37.85002673251972 -122.27239858181652
19877 19877 19877 053 160202000 3039 Ellis St 2 3039 ELLIS ST 2 3039 ELLIS ST 3039.0 ELLIS ST 2   Berkeley 94703 37.8523942468122 -122.27278297811311
20268 20268 20268 053 160303000 2915 Ellis St 2915 ELLIS ST 2915 ELLIS ST 2915.0 ELLIS ST     Berkeley 94703 37.85530502553951 -122.27302088254308
20544 20544 20544 053 160303300 2905 Ellis St 2905 ELLIS ST 2905 ELLIS ST 2905.0 ELLIS ST     Berkeley 94703 37.855640012541976 -122.27311906840362
20548 20548 20548 053 160203100 3005 Ellis St G 3005 ELLIS ST G 3005 ELLIS ST 3005.0 ELLIS ST G   Berkeley 94703 37.8537575764149 -122.2727726286227
22199 22199 22199 052 153001500 3211 Ellis St 3211 ELLIS ST 3211 ELLIS ST 3211.0 ELLIS ST     Berkeley 94703 37.85000218766232 -122.27258443875722
22415 22415 22415 052 154700700 3138 Ellis St B 3138 ELLIS ST B 3138 ELLIS ST 3138.0 ELLIS ST B   Berkeley 94703 37.85069189766895 -122.27309973755705
22780 22780 22780 052 153300102 3240 Ellis St E 3240 ELLIS ST E 3240 ELLIS ST 3240.0 ELLIS ST E   Berkeley 94703 37.848909193041386 -122.27297499210678
23499 23499 23499 052 153401000 3218 Ellis St 3218 ELLIS ST 3218 ELLIS ST 3218.0 ELLIS ST     Berkeley 94703 37.84959278393894 -122.27305331711472
23705 23705 23705 053 160302501 2925 Ellis St 5 2925 ELLIS ST 5 2925 ELLIS ST 2925.0 ELLIS ST 5   Berkeley 94703 37.854877180886874 -122.27297527507608
24381 24381 24381 052 154700700 3138 Ellis St 3138 ELLIS ST 3138 ELLIS ST 3138.0 ELLIS ST     Berkeley 94703 37.850723970316835 -122.273161702447
24819 24819 24819 052 154601100 3118 Ellis St A 3118 ELLIS ST A 3118 ELLIS ST 3118.0 ELLIS ST A   Berkeley 94703 37.85145520531209 -122.27311482835547
25014 25014 25014 052 153001500 3209 Ellis St 3209 ELLIS ST 3209 ELLIS ST 3209.0 ELLIS ST     Berkeley 94703 37.84998723645454 -122.27238983851385
25275 25275 25275 052 154601000 3116 Ellis St 3116 ELLIS ST 3116 ELLIS ST 3116.0 ELLIS ST     Berkeley 94703 37.851529127808355 -122.27327237399167
25750 25750 25750 052 154601100 3118 Ellis St 3118 ELLIS ST 3118 ELLIS ST 3118.0 ELLIS ST     Berkeley 94703 37.85144471527281 -122.27320981351868
26343 26343 26343 052 153400800 3208 Ellis St 3208 ELLIS ST 3208 ELLIS ST 3208.0 ELLIS ST     Berkeley 94703 37.849840489174824 -122.27308149457023
26648 26648 26648 053 160303200 2907 Ellis St 2907 ELLIS ST 2907 ELLIS ST 2907.0 ELLIS ST     Berkeley 94703 37.85553181778292 -122.27304619167786
26959 26959 26959 052 154700800 3140 Ellis St 7 3140 ELLIS ST 7 3140 ELLIS ST 3140.0 ELLIS ST 7   Berkeley 94703 37.85052636467804 -122.27308626552268
27903 27903 27903 052 153400800 3208 Ellis St B 3208 ELLIS ST B 3208 ELLIS ST 3208.0 ELLIS ST B   Berkeley 94703 37.84979539498129 -122.2729998727452
28640 28640 28640 052 154600900 3114 Ellis St 3114 ELLIS ST 3114 ELLIS ST 3114.0 ELLIS ST     Berkeley 94703 37.85164405697351 -122.27328898563796
28709 28709 28709 053 160202400 3029 Ellis St 3029 ELLIS ST 3029 ELLIS ST 3029.0 ELLIS ST     Berkeley 94703 37.85290941999648 -122.2727740677238
28977 28977 28977 052 154901400 3117 Ellis St 3117 ELLIS ST 3117 ELLIS ST 3117.0 ELLIS ST     Berkeley 94703 37.85160116842528 -122.27263536604733
29006 29006 29006 052 153300102 3240 Ellis St A 3240 ELLIS ST A 3240 ELLIS ST 3240.0 ELLIS ST A   Berkeley 94703 37.848885850849754 -122.27314961112327
29222 29222 29222 053 160200100 3001 Ellis St B 3001 ELLIS ST B 3001 ELLIS ST 3001.0 ELLIS ST B   Berkeley 94703 37.85391340828638 -122.2728767918732
29579 29579 29579 053 160400600 2906 Ellis St 2906 ELLIS ST 2906 ELLIS ST 2906.0 ELLIS ST     Berkeley 94703 37.855482357228254 -122.27367385444836
29746 29746 29746 052 153400500 3202 Ellis St 3202 ELLIS ST 3202 ELLIS ST 3202.0 ELLIS ST     Berkeley 94703 37.850136611495984 -122.27311047601792
29755 29755 29755 052 154700500 3134 Ellis St 3134 ELLIS ST 3134 ELLIS ST 3134.0 ELLIS ST     Berkeley 94703 37.850929360198585 -122.27311816829172
30221 30221 30221 053 160302501 2925 Ellis St 2925 ELLIS ST 2925 ELLIS ST 2925.0 ELLIS ST     Berkeley 94703 37.854877180886874 -122.27297527507608
30238 30238 30238 052 154901600 3109 Ellis St 3109 ELLIS ST 3109 ELLIS ST 3109.0 ELLIS ST     Berkeley 94703 37.85183472256603 -122.27266262811956
30760 30760 30760 052 154700800 3140 Ellis St 10 3140 ELLIS ST 10 3140 ELLIS ST 3140.0 ELLIS ST 10   Berkeley 94703 37.8505386515616 -122.27299167022834
30846 30846 30846 052 153300102 3240 Ellis St H 3240 ELLIS ST H 3240 ELLIS ST 3240.0 ELLIS ST H   Berkeley 94703 37.84892592490596 -122.27284982265174
30886 30886 30886 053 160302501 2925 Ellis St 7 2925 ELLIS ST 7 2925 ELLIS ST 2925.0 ELLIS ST 7   Berkeley 94703 37.854877180886874 -122.27297527507608
31253 31253 31253 053 160302501 2925 Ellis St 2 2925 ELLIS ST 2 2925 ELLIS ST 2925.0 ELLIS ST 2   Berkeley 94703 37.854877180886874 -122.27297527507608
31331 31331 31331 053 160202900 3013 Ellis St 3013 ELLIS ST 3013 ELLIS ST 3013.0 ELLIS ST     Berkeley 94703 37.853532881768665 -122.27286378965776
32151 32151 32151 053 160302501 2925 Ellis St 6 2925 ELLIS ST 6 2925 ELLIS ST 2925.0 ELLIS ST 6   Berkeley 94703 37.854877180886874 -122.27297527507608
32314 32314 32314 052 153400700 3206 Ellis St 3206 ELLIS ST 3206 ELLIS ST 3206.0 ELLIS ST     Berkeley 94703 37.84993562504353 -122.27308836578383
32626 32626 32626 052 153300102 3240 Ellis St C 3240 ELLIS ST C 3240 ELLIS ST 3240.0 ELLIS ST C   Berkeley 94703 37.84889783228194 -122.27305998441076
33299 33299 33299 052 154700800 3140 Ellis St 4 3140 ELLIS ST 4 3140 ELLIS ST 3140.0 ELLIS ST 4   Berkeley 94703 37.850514161492434 -122.27318021762332
33501 33501 33501 052 154601100 3120 Ellis St 3120 ELLIS ST 3120 ELLIS ST 3120.0 ELLIS ST     Berkeley 94703 37.85140012425481 -122.27320260903012
33730 33730 33730 053 160401600 2938 Ellis St A 2938 ELLIS ST A 2938 ELLIS ST 2938.0 ELLIS ST A   Berkeley 94703 37.85444287429438 -122.27356502983992
34208 34208 34208 052 154600700 3110 Ellis St 3110 ELLIS ST 3110 ELLIS ST 3110.0 ELLIS ST     Berkeley 94703 37.85183550564418 -122.27328701203926
35719 35719 35719 052 153300102 3240 Ellis St B 3240 ELLIS ST B 3240 ELLIS ST 3240.0 ELLIS ST B   Berkeley 94703 37.84889163479398 -122.27310634376762
35777 35777 35777 053 160202300 3033 Ellis St 3033 ELLIS ST 3033 ELLIS ST 3033.0 ELLIS ST     Berkeley 94703 37.85280925618701 -122.27276638173824
36303 36303 36303 053 160401800 2942 Ellis St 2942 ELLIS ST 2942 ELLIS ST 2942.0 ELLIS ST     Berkeley 94703 37.854243677762824 -122.2734805765251
36726 36726 36726 053 160302800 2921 Ellis St 2921 ELLIS ST 2921 ELLIS ST 2921.0 ELLIS ST     Berkeley 94703 37.85513933055144 -122.27300221734808
36786 36786 36786 052 154600500 3100 Ellis St 3100 ELLIS ST 3100 ELLIS ST 3100.0 ELLIS ST     Berkeley 94703 37.85205088870561 -122.2732384787594

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