Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
50 rows where street_name = "ELLSWORTH" and zipcode = 94705
This data as json, CSV (advanced)
Suggested facets: apn, unit, latitude, longitude
| Link | rowid ▼ | address_id | apn | address_full | address_normalized | base_address | street_number | street_name | street_type | unit | unit_type | city | zipcode | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 497 | 497 | 497 | 052 157801200 | 2925 Ellsworth St | 2925 ELLSWORTH ST | 2925 ELLSWORTH ST | 2925.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85653356738308 | -122.2610644866728 | ||
| 800 | 800 | 800 | 053 168902100 | 2807 Ellsworth St | 2807 ELLSWORTH ST | 2807 ELLSWORTH ST | 2807.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.858846832722456 | -122.2615239138552 | ||
| 1446 | 1446 | 1446 | 054 171501801 | 2713 Ellsworth St 2 | 2713 ELLSWORTH ST 2 | 2713 ELLSWORTH ST | 2713.0 | ELLSWORTH | ST | 2 | Berkeley | 94705 | 37.86056333481635 | -122.26192924538948 | |
| 3205 | 3205 | 3205 | 052 158001101 | 2936 Ellsworth St | 2936 ELLSWORTH ST | 2936 ELLSWORTH ST | 2936.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85635343094658 | -122.26164073706292 | ||
| 3738 | 3738 | 3738 | 054 171501801 | 2713 Ellsworth St 3 | 2713 ELLSWORTH ST 3 | 2713 ELLSWORTH ST | 2713.0 | ELLSWORTH | ST | 3 | Berkeley | 94705 | 37.86056333481635 | -122.26192924538948 | |
| 3739 | 3739 | 3739 | 053 168901900 | 2817 Ellsworth St | 2817 ELLSWORTH ST | 2817 ELLSWORTH ST | 2817.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.858622583390634 | -122.26151760858022 | ||
| 4396 | 4396 | 4396 | 053 168902200 | 2805 Ellsworth St | 2805 ELLSWORTH ST | 2805 ELLSWORTH ST | 2805.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85896433850134 | -122.26154645707727 | ||
| 4799 | 4799 | 4799 | 052 158000800 | 2918 Ellsworth St 1 | 2918 ELLSWORTH ST 1 | 2918 ELLSWORTH ST | 2918.0 | ELLSWORTH | ST | 1 | Berkeley | 94705 | 37.85666309319242 | -122.26169976086872 | |
| 6026 | 6026 | 6026 | 054 171700100 | 2730 Ellsworth St | 2730 ELLSWORTH ST | 2730 ELLSWORTH ST | 2730.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85983899879984 | -122.26221510548255 | ||
| 8929 | 8929 | 8929 | 052 158001001 | 2932 Ellsworth St Right | 2932 ELLSWORTH ST RIGHT | 2932 ELLSWORTH ST | 2932.0 | ELLSWORTH | ST | RIGHT | Berkeley | 94705 | 37.856431688528346 | -122.2616544399643 | |
| 10209 | 10209 | 10209 | 053 168800300 | 2812 Ellsworth St | 2812 ELLSWORTH ST | 2812 ELLSWORTH ST | 2812.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85864250465079 | -122.26208021176454 | ||
| 12314 | 12314 | 12314 | 052 158001001 | 2932 Ellsworth St Left | 2932 ELLSWORTH ST LEFT | 2932 ELLSWORTH ST | 2932.0 | ELLSWORTH | ST | LEFT | Berkeley | 94705 | 37.856431688528346 | -122.2616544399643 | |
| 14095 | 14095 | 14095 | 052 158000700 | 2916 Ellsworth St | 2916 ELLSWORTH ST | 2916 ELLSWORTH ST | 2916.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85679022572333 | -122.26172785118764 | ||
| 15866 | 15866 | 15866 | 052 158000500 | 2906 Ellsworth St | 2906 ELLSWORTH ST | 2906 ELLSWORTH ST | 2906.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85707143986726 | -122.26171286998364 | ||
| 16905 | 16905 | 16905 | 052 158001001 | 2932 Ellsworth St A | 2932 ELLSWORTH ST A | 2932 ELLSWORTH ST | 2932.0 | ELLSWORTH | ST | A | Berkeley | 94705 | 37.856431688528346 | -122.2616544399643 | |
| 21895 | 21895 | 21895 | 052 158000800 | 2918 Ellsworth St 2 | 2918 ELLSWORTH ST 2 | 2918 ELLSWORTH ST | 2918.0 | ELLSWORTH | ST | 2 | Berkeley | 94705 | 37.85666309319242 | -122.26169976086872 | |
| 23812 | 23812 | 23812 | 053 168800200 | 2808 Ellsworth St | 2808 ELLSWORTH ST | 2808 ELLSWORTH ST | 2808.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85875368926963 | -122.26209063042522 | ||
| 26784 | 26784 | 26784 | 053 168902000 | 2815 Ellsworth St | 2815 ELLSWORTH ST | 2815 ELLSWORTH ST | 2815.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85873550001225 | -122.26148562136956 | ||
| 27668 | 27668 | 27668 | 054 171501801 | 2713 Ellsworth St | 2713 ELLSWORTH ST | 2713 ELLSWORTH ST | 2713.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.86056333481635 | -122.26192924538948 | ||
| 34342 | 34342 | 34342 | 052 158000700 | 2914 Ellsworth St | 2914 ELLSWORTH ST | 2914 ELLSWORTH ST | 2914.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85679022572333 | -122.26172785118764 | ||
| 35724 | 35724 | 35724 | 052 158001101 | 2934 Ellsworth St | 2934 ELLSWORTH ST | 2934 ELLSWORTH ST | 2934.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85635343094658 | -122.26164073706292 | ||
| 36040 | 36040 | 36040 | 052 158000700 | 2916 Ellsworth St 2 | 2916 ELLSWORTH ST 2 | 2916 ELLSWORTH ST | 2916.0 | ELLSWORTH | ST | 2 | Berkeley | 94705 | 37.85679022572333 | -122.26172785118764 | |
| 36306 | 36306 | 36306 | 052 158000900 | 2928 Ellsworth St | 2928 ELLSWORTH ST | 2928 ELLSWORTH ST | 2928.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85653737471604 | -122.26167424062976 | ||
| 39466 | 39466 | 39466 | 052 158000500 | 2902 Ellsworth St | 2902 ELLSWORTH ST | 2902 ELLSWORTH ST | 2902.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85707143986726 | -122.26171286998364 | ||
| 39872 | 39872 | 39872 | 053 169001800 | 2831 Ellsworth St | 2831 ELLSWORTH ST | 2831 ELLSWORTH ST | 2831.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85807986670069 | -122.26133329225024 | ||
| 40158 | 40158 | 40158 | 052 158000601 | 2908 Ellsworth St | 2908 ELLSWORTH ST | 2908 ELLSWORTH ST | 2908.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.856918076516465 | -122.26179508290012 | ||
| 40639 | 40639 | 40639 | 052 158000500 | 2900 Ellsworth St | 2900 ELLSWORTH ST | 2900 ELLSWORTH ST | 2900.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85707143986726 | -122.26171286998364 | ||
| 41258 | 41258 | 41258 | 052 157801100 | 2929 Ellsworth St | 2929 ELLSWORTH ST | 2929 ELLSWORTH ST | 2929.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85629839255852 | -122.26110301002544 | ||
| 43279 | 43279 | 43279 | 054 171501700 | 2715 Ellsworth St | 2715 ELLSWORTH ST | 2715 ELLSWORTH ST | 2715.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.86030856623214 | -122.2619500171338 | ||
| 43618 | 43618 | 43618 | 053 168902300 | 2801 Ellsworth St | 2801 ELLSWORTH ST | 2801 ELLSWORTH ST | 2801.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85907922699654 | -122.2616081893036 | ||
| 43823 | 43823 | 43823 | 054 171700200 | 2734 Ellsworth St | 2734 ELLSWORTH ST | 2734 ELLSWORTH ST | 2734.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.859653968920234 | -122.26217705554208 | ||
| 44332 | 44332 | 44332 | 053 169001600 | 2839 Ellsworth St | 2839 ELLSWORTH ST | 2839 ELLSWORTH ST | 2839.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.857831610397646 | -122.26128321566468 | ||
| 44406 | 44406 | 44406 | 054 171800200 | 2708 Ellsworth St | 2708 ELLSWORTH ST | 2708 ELLSWORTH ST | 2708.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.86052268055551 | -122.26245404746668 | ||
| 44643 | 44643 | 44643 | 052 158000700 | 2914 Ellsworth St South | 2914 ELLSWORTH ST SOUTH | 2914 ELLSWORTH ST | 2914.0 | ELLSWORTH | ST | SOUTH | Berkeley | 94705 | 37.85679022572333 | -122.26172785118764 | |
| 45712 | 45712 | 45712 | 054 171601900 | 2735 Ellsworth St | 2735 ELLSWORTH ST | 2735 ELLSWORTH ST | 2735.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85972481859524 | -122.26167451371764 | ||
| 46160 | 46160 | 46160 | 053 169001700 | 2837 Ellsworth St | 2837 ELLSWORTH ST | 2837 ELLSWORTH ST | 2837.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.857954754213274 | -122.26130511748964 | ||
| 46533 | 46533 | 46533 | 052 158001001 | 2932 Ellsworth St B | 2932 ELLSWORTH ST B | 2932 ELLSWORTH ST | 2932.0 | ELLSWORTH | ST | B | Berkeley | 94705 | 37.856431688528346 | -122.2616544399643 | |
| 46680 | 46680 | 46680 | 052 158000800 | 2918 Ellsworth St | 2918 ELLSWORTH ST | 2918 ELLSWORTH ST | 2918.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85666309319242 | -122.26169976086872 | ||
| 46806 | 46806 | 46806 | 053 168901800 | 2819 Ellsworth St | 2819 ELLSWORTH ST | 2819 ELLSWORTH ST | 2819.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.858486911153285 | -122.2614936693762 | ||
| 47459 | 47459 | 47459 | 054 171700100 | 2732 Ellsworth St | 2732 ELLSWORTH ST | 2732 ELLSWORTH ST | 2732.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85983899879984 | -122.26221510548255 | ||
| 47799 | 47799 | 47799 | 052 157901300 | 2907 Ellsworth St | 2907 ELLSWORTH ST | 2907 ELLSWORTH ST | 2907.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.857081083668675 | -122.26125238009426 | ||
| 48770 | 48770 | 48770 | 054 171800300 | 2712 Ellsworth St | 2712 ELLSWORTH ST | 2712 ELLSWORTH ST | 2712.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.86041534545448 | -122.26243233069468 | ||
| 49068 | 49068 | 49068 | 052 158000700 | 2914 Ellsworth St 2 | 2914 ELLSWORTH ST 2 | 2914 ELLSWORTH ST | 2914.0 | ELLSWORTH | ST | 2 | Berkeley | 94705 | 37.85679022572333 | -122.26172785118764 | |
| 50131 | 50131 | 50131 | 053 169001700 | 2835 Ellsworth St | 2835 ELLSWORTH ST | 2835 ELLSWORTH ST | 2835.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.857954754213274 | -122.26130511748964 | ||
| 50841 | 50841 | 50841 | 052 158001001 | 2932 Ellsworth St | 2932 ELLSWORTH ST | 2932 ELLSWORTH ST | 2932.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.856431688528346 | -122.2616544399643 | ||
| 51130 | 51130 | 51130 | 052 158000700 | 2914 Ellsworth St 1 | 2914 ELLSWORTH ST 1 | 2914 ELLSWORTH ST | 2914.0 | ELLSWORTH | ST | 1 | Berkeley | 94705 | 37.85679022572333 | -122.26172785118764 | |
| 51192 | 51192 | 51192 | 054 171501801 | 2713 Ellsworth St 1 | 2713 ELLSWORTH ST 1 | 2713 ELLSWORTH ST | 2713.0 | ELLSWORTH | ST | 1 | Berkeley | 94705 | 37.86056333481635 | -122.26192924538948 | |
| 53426 | 53426 | 53426 | 052 158000700 | 2916 Ellsworth St 1 | 2916 ELLSWORTH ST 1 | 2916 ELLSWORTH ST | 2916.0 | ELLSWORTH | ST | 1 | Berkeley | 94705 | 37.85679022572333 | -122.26172785118764 | |
| 55735 | 55735 | 55735 | 052 158000700 | 2914 Ellsworth St North | 2914 ELLSWORTH ST NORTH | 2914 ELLSWORTH ST | 2914.0 | ELLSWORTH | ST | NORTH | Berkeley | 94705 | 37.85679022572333 | -122.26172785118764 | |
| 55819 | 55819 | 55819 | 054 171601800 | 2739 Ellsworth St | 2739 ELLSWORTH ST | 2739 ELLSWORTH ST | 2739.0 | ELLSWORTH | ST | Berkeley | 94705 | 37.85961168220786 | -122.2616433313975 |
Advanced export
JSON shape: default, array, newline-delimited
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);