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

608 rows where street_name = "BERKELEY" and street_type = "WY"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 4

street_type 1

  • WY · 608 ✖

street_name 1

  • BERKELEY · 608 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
41 41 41 057 207500500 1435 Berkeley Way 1435 BERKELEY WAY 1435 BERKELEY WY 1435.0 BERKELEY WY     Berkeley 94702 37.87129018445151 -122.2828227940702
53 53 53 057 206001200 1810 Berkeley Way 4 1810 BERKELEY WAY 4 1810 BERKELEY WY 1810.0 BERKELEY WY 4   Berkeley 94703 37.87197267857206 -122.27469630343002
61 61 61 057 207201501 1440 Berkeley Way 1440 BERKELEY WAY 1440 BERKELEY WY 1440.0 BERKELEY WY     Berkeley 94702 37.87090866835336 -122.28249569501736
184 184 184 057 204600100 2114 Berkeley Way 2114 BERKELEY WAY 2114 BERKELEY WY 2114.0 BERKELEY WY     Berkeley 94704 37.87295479646589 -122.26800428665298
224 224 224 057 208101400 1271 Berkeley Way 1271 BERKELEY WAY 1271 BERKELEY WY 1271.0 BERKELEY WY     Berkeley 94702 37.870714417816 -122.28731088862074
368 368 368 057 205602300 1945 Berkeley Way 328 1945 BERKELEY WAY 328 1945 BERKELEY WY 1945.0 BERKELEY WY 328   Berkeley 94704 37.8728988635272 -122.27127748703688
526 526 526 057 206001600 1830 Berkeley Way 1830 BERKELEY WAY 1830 BERKELEY WY 1830.0 BERKELEY WY     Berkeley 94703 37.87206681651637 -122.27399328368529
534 534 534 057 205102700 2005 Berkeley Way D 2005 BERKELEY WAY D 2005 BERKELEY WY 2005.0 BERKELEY WY D   Berkeley 94704 37.87301017200475 -122.2704268749893
537 537 537 057 205900200 1910 Berkeley Way 1910 BERKELEY WAY 1910 BERKELEY WY 1910.0 BERKELEY WY     Berkeley 94704 37.872302906128674 -122.27245870516016
565 565 565 057 206000100 1888 Berkeley Way Apt 201 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 201 APT Berkeley 94704 37.87222175590544 -122.27384508142632
629 629 629 057 207001700 1620 Berkeley Way 1620 BERKELEY WAY 1620 BERKELEY WY 1620.0 BERKELEY WY     Berkeley 94703 37.87142891070623 -122.27914622856416
677 677 677 057 205602300 1933 Berkeley Way 1933 BERKELEY WAY 1933 BERKELEY WY 1933.0 BERKELEY WY     Berkeley 94704 37.8728988635272 -122.27127748703688
815 815 815 057 205602300 1941 Berkeley Way 1941 BERKELEY WAY 1941 BERKELEY WY 1941.0 BERKELEY WY     Berkeley 94704 37.8728988635272 -122.27127748703688
817 817 817 057 205900200 1912 Berkeley Way 1912 BERKELEY WAY 1912 BERKELEY WY 1912.0 BERKELEY WY     Berkeley 94704 37.872302906128674 -122.27245870516016
1014 1014 1014 057 205102700 2005 Berkeley Way A 2005 BERKELEY WAY A 2005 BERKELEY WY 2005.0 BERKELEY WY A   Berkeley 94704 37.87301017200475 -122.2704268749893
1033 1033 1033 057 206001200 1810 Berkeley Way 10 1810 BERKELEY WAY 10 1810 BERKELEY WY 1810.0 BERKELEY WY 10   Berkeley 94703 37.87197267857206 -122.27469630343002
1270 1270 1270 057 206301200 1823 Berkeley Way B 1823 BERKELEY WAY B 1823 BERKELEY WY 1823.0 BERKELEY WY B   Berkeley 94703 37.87254618111184 -122.27434791250832
1283 1283 1283 057 205602300 1945 Berkeley Way 318 1945 BERKELEY WAY 318 1945 BERKELEY WY 1945.0 BERKELEY WY 318   Berkeley 94704 37.8728988635272 -122.27127748703688
1332 1332 1332 057 205103000 2017 Berkeley Way 9 2017 BERKELEY WAY 9 2017 BERKELEY WY 2017.0 BERKELEY WY 9   Berkeley 94704 37.87306930079794 -122.26996137160236
1511 1511 1511 057 206300900 1833 Berkeley Way 4 1833 BERKELEY WAY 4 1833 BERKELEY WY 1833.0 BERKELEY WY 4   Berkeley 94703 37.8725989474326 -122.27393590020328
1571 1571 1571 057 206000100 1888 Berkeley Way Apt 507 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 507 APT Berkeley 94704 37.872135402819296 -122.2736785706036
1695 1695 1695 057 206200600 1741 Berkeley Way 1741 BERKELEY WAY 1741 BERKELEY WY 1741.0 BERKELEY WY     Berkeley 94703 37.87233517005241 -122.27590988336144
1722 1722 1722 057 205103000 2017 Berkeley Way 7 2017 BERKELEY WAY 7 2017 BERKELEY WY 2017.0 BERKELEY WY 7   Berkeley 94704 37.87306930079794 -122.26996137160236
1730 1730 1730 057 205602300 1945 Berkeley Way 206 1945 BERKELEY WAY 206 1945 BERKELEY WY 1945.0 BERKELEY WY 206   Berkeley 94704 37.8728988635272 -122.27127748703688
1749 1749 1749 057 205800900 1913 Berkeley Way A 1913 BERKELEY WAY A 1913 BERKELEY WY 1913.0 BERKELEY WY A   Berkeley 94704 37.8727526986547 -122.27249023063672
1887 1887 1887 057 205602300 1945 Berkeley Way 123 1945 BERKELEY WAY 123 1945 BERKELEY WY 1945.0 BERKELEY WY 123   Berkeley 94704 37.8728988635272 -122.27127748703688
2037 2037 2037 057 206102200 1728 Berkeley Way 2 1728 BERKELEY WAY 2 1728 BERKELEY WY 1728.0 BERKELEY WY 2   Berkeley 94703 37.87179999866119 -122.2762072409918
2122 2122 2122 057 206000100 1888 Berkeley Way Apt 213 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 213 APT Berkeley 94704 37.87224946310159 -122.2735342194223
2239 2239 2239 057 207500600 1433 Berkeley Way A 1433 BERKELEY WAY A 1433 BERKELEY WY 1433.0 BERKELEY WY A   Berkeley 94702 37.87127507729975 -122.28294026855652
2264 2264 2264 057 206204200 1721 Berkeley Way 9 1721 BERKELEY WAY 9 1721 BERKELEY WY 1721.0 BERKELEY WY 9   Berkeley 94703 37.8722326762563 -122.27672692446852
2375 2375 2375 057 206000100 1888 Berkeley Way Apt 207 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 207 APT Berkeley 94704 37.8722350992976 -122.27369465853202
2443 2443 2443 057 207400400 1387 Berkeley Way B 1387 BERKELEY WAY B 1387 BERKELEY WY 1387.0 BERKELEY WY B   Berkeley 94702 37.871035013292904 -122.2848186206628
2588 2588 2588 057 205602300 1945 Berkeley Way 303 1945 BERKELEY WAY 303 1945 BERKELEY WY 1945.0 BERKELEY WY 303   Berkeley 94704 37.8728988635272 -122.27127748703688
2693 2693 2693 057 207501300 1415 Berkeley Way 1415 BERKELEY WAY 1415 BERKELEY WY 1415.0 BERKELEY WY     Berkeley 94702 37.87116900520811 -122.28378057513116
2774 2774 2774 057 205102800 2009 Berkeley Way 2009 BERKELEY WAY 2009 BERKELEY WY 2009.0 BERKELEY WY     Berkeley 94704 37.87302994046354 -122.270274013169
2834 2834 2834 057 206000100 1888 Berkeley Way Apt 510 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 510 APT Berkeley 94704 37.87213815063826 -122.2736513291926
2904 2904 2904 057 206102200 1728 Berkeley Way 3 1728 BERKELEY WAY 3 1728 BERKELEY WY 1728.0 BERKELEY WY 3   Berkeley 94703 37.87179999866119 -122.2762072409918
2981 2981 2981 057 207301700 1360 Berkeley Way 17 1360 BERKELEY WAY 17 1360 BERKELEY WY 1360.0 BERKELEY WY 17   Berkeley 94702 37.87055738828812 -122.28523331443898
3004 3004 3004 057 205800900 1911 Berkeley Way A 1911 BERKELEY WAY A 1911 BERKELEY WY 1911.0 BERKELEY WY A   Berkeley 94704 37.8727526986547 -122.27249023063672
3169 3169 3169 057 207400400 1387 Berkeley Way 1387 BERKELEY WAY 1387 BERKELEY WY 1387.0 BERKELEY WY     Berkeley 94702 37.871035013292904 -122.2848186206628
3177 3177 3177 057 207301700 1360 Berkeley Way 6 1360 BERKELEY WAY 6 1360 BERKELEY WY 1360.0 BERKELEY WY 6   Berkeley 94702 37.87055738828812 -122.28523331443898
3196 3196 3196 057 206000100 1888 Berkeley Way Apt 301 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 301 APT Berkeley 94704 37.872188492790315 -122.2738409698373
3404 3404 3404 057 207301700 1360 Berkeley Way 16 1360 BERKELEY WAY 16 1360 BERKELEY WY 1360.0 BERKELEY WY 16   Berkeley 94702 37.87055738828812 -122.28523331443898
3541 3541 3541 057 206800900 1529 Berkeley Way 1529 BERKELEY WAY 1529 BERKELEY WY 1529.0 BERKELEY WY     Berkeley 94703 37.87171621350841 -122.28080859333676
3586 3586 3586 057 205800900 1913 Berkeley Way B 1913 BERKELEY WAY B 1913 BERKELEY WY 1913.0 BERKELEY WY B   Berkeley 94704 37.8727526986547 -122.27249023063672
3702 3702 3702 057 205602300 1945 Berkeley Way 309 1945 BERKELEY WAY 309 1945 BERKELEY WY 1945.0 BERKELEY WY 309   Berkeley 94704 37.8728988635272 -122.27127748703688
3788 3788 3788 057 206102200 1728 Berkeley Way 1 1728 BERKELEY WAY 1 1728 BERKELEY WY 1728.0 BERKELEY WY 1   Berkeley 94703 37.87179999866119 -122.2762072409918
3862 3862 3862 057 206101900 1720 Berkeley Way 1720 BERKELEY WAY 1720 BERKELEY WY 1720.0 BERKELEY WY     Berkeley 94703 37.87174622836575 -122.2766459503288
3863 3863 3863 057 208101400 1275 Berkeley Way 1275 BERKELEY WAY 1275 BERKELEY WY 1275.0 BERKELEY WY     Berkeley 94702 37.870714417816 -122.28731088862074
3897 3897 3897 057 206000100 1888 Berkeley Way Apt 307 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 307 APT Berkeley 94704 37.872201836897624 -122.27369054694296
3914 3914 3914 057 207500600 1433 Berkeley Way 1433 BERKELEY WAY 1433 BERKELEY WY 1433.0 BERKELEY WY     Berkeley 94702 37.87127507729975 -122.28294026855652
3919 3919 3919 057 206000100 1888 Berkeley Way Apt 205 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 205 APT Berkeley 94704 37.872230723357326 -122.27374496328964
4158 4158 4158 057 207500800 1427 Berkeley Way 1427 BERKELEY WAY 1427 BERKELEY WY 1427.0 BERKELEY WY     Berkeley 94702 37.87124368158766 -122.2831768632428
4168 4168 4168 057 205602300 1945 Berkeley Way 214 1945 BERKELEY WAY 214 1945 BERKELEY WY 1945.0 BERKELEY WY 214   Berkeley 94704 37.8728988635272 -122.27127748703688
4229 4229 4229 057 207400300 1393 Berkeley Way 2 1393 BERKELEY WAY 2 1393 BERKELEY WY 1393.0 BERKELEY WY 2   Berkeley 94702 37.87105055944232 -122.28470117941414
4335 4335 4335 057 207001600 1618 Berkeley Way 1618 BERKELEY WAY 1618 BERKELEY WY 1618.0 BERKELEY WY     Berkeley 94703 37.87140479348425 -122.27932150963902
4343 4343 4343 057 206201301 1709 Berkeley Way A 1709 BERKELEY WAY A 1709 BERKELEY WY 1709.0 BERKELEY WY A   Berkeley 94703 37.87217252850362 -122.27719234071893
4492 4492 4492 057 205602300 1945 Berkeley Way 127 1945 BERKELEY WAY 127 1945 BERKELEY WY 1945.0 BERKELEY WY 127   Berkeley 94704 37.8728988635272 -122.27127748703688
4504 4504 4504 057 207201800 1434 Berkeley Way 1434 BERKELEY WAY 1434 BERKELEY WY 1434.0 BERKELEY WY     Berkeley 94702 37.870885555793485 -122.28267276553628
4625 4625 4625 057 206200700 1735 Berkeley Way 2 1735 BERKELEY WAY 2 1735 BERKELEY WY 1735.0 BERKELEY WY 2   Berkeley 94703 37.87231227280123 -122.27608348189176
4627 4627 4627 057 205602300 1945 Berkeley Way 315 1945 BERKELEY WAY 315 1945 BERKELEY WY 1945.0 BERKELEY WY 315   Berkeley 94704 37.8728988635272 -122.27127748703688
4703 4703 4703 057 206000100 1888 Berkeley Way Apt 506 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 506 APT Berkeley 94704 37.87213320243673 -122.27370484452904
5012 5012 5012 057 207001500 1616 Berkeley Way 6 1616 BERKELEY WAY 6 1616 BERKELEY WY 1616.0 BERKELEY WY 6   Berkeley 94703 37.87138162009557 -122.27949163618078
5032 5032 5032 057 207400700 1365 Berkeley Way 1365 BERKELEY WAY 1365 BERKELEY WY 1365.0 BERKELEY WY     Berkeley 94702 37.87098532842126 -122.28517253802012
5091 5091 5091 057 207300902 1320 Berkeley Way 1320 BERKELEY WAY 1320 BERKELEY WY 1320.0 BERKELEY WY     Berkeley 94702 37.87044724617068 -122.28609171398176
5142 5142 5142 057 206001300 1818 Berkeley Way 1818 BERKELEY WAY 1818 BERKELEY WY 1818.0 BERKELEY WY     Berkeley 94703 37.872017415986825 -122.27437414960282
5171 5171 5171 057 207001500 1616 Berkeley Way 5 1616 BERKELEY WAY 5 1616 BERKELEY WY 1616.0 BERKELEY WY 5   Berkeley 94703 37.87138162009557 -122.27949163618078
5174 5174 5174 057 208102200 1250 Berkeley Way 1 1250 BERKELEY WAY 1 1250 BERKELEY WY 1250.0 BERKELEY WY 1   Berkeley 94702 37.87028984732456 -122.2873362309932
5190 5190 5190 057 207001900 1624 Berkeley Way 1624 BERKELEY WAY 1624 BERKELEY WY 1624.0 BERKELEY WY     Berkeley 94703 37.87146898881731 -122.27880153780312
5230 5230 5230 057 207101200 1510 Berkeley Way 1510 BERKELEY WAY 1510 BERKELEY WY 1510.0 BERKELEY WY     Berkeley 94703 37.871173435813944 -122.28140800588822
5411 5411 5411 057 207302100 1384 Berkeley Way 1384 BERKELEY WAY 1384 BERKELEY WY 1384.0 BERKELEY WY     Berkeley 94702 37.870622091386906 -122.28472895352606
5414 5414 5414 057 206101800 1714 Berkeley Way 1714 BERKELEY WAY 1714 BERKELEY WY 1714.0 BERKELEY WY     Berkeley 94703 37.871728992533825 -122.27677807993072
5640 5640 5640 057 206000100 1888 Berkeley Way Apt 212 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 212 APT Berkeley 94704 37.87224718613819 -122.27356074757094
5708 5708 5708 057 206000100 1888 Berkeley Way Apt 513 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 513 APT Berkeley 94704 37.87214543466255 -122.27356841199696
5762 5762 5762 057 206300700 1837 Berkeley Way 1837 BERKELEY WAY 1837 BERKELEY WY 1837.0 BERKELEY WY     Berkeley 94703 37.8726363083078 -122.27365701912164
5807 5807 5807 057 205103000 2017 Berkeley Way 10 2017 BERKELEY WAY 10 2017 BERKELEY WY 2017.0 BERKELEY WY 10   Berkeley 94704 37.87306930079794 -122.26996137160236
5870 5870 5870 057 206000100 1888 Berkeley Way Apt 210 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 210 APT Berkeley 94704 37.87224218050582 -122.2736171384146
5971 5971 5971 057 207101800 1534 Berkeley Way 1534 BERKELEY WAY 1534 BERKELEY WY 1534.0 BERKELEY WY     Berkeley 94703 37.87124733073531 -122.28051930976412
6064 6064 6064 057 206000100 1888 Berkeley Way Apt 404 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 404 APT Berkeley 94704 37.872160903993326 -122.27376051761875
6089 6089 6089 057 207201200 1424 Berkeley Way B 1424 BERKELEY WAY B 1424 BERKELEY WY 1424.0 BERKELEY WY B   Berkeley 94702 37.87084213737681 -122.28302338338156
6232 6232 6232 057 206301600 1811 Berkeley Way A 1811 BERKELEY WAY A 1811 BERKELEY WY 1811.0 BERKELEY WY A   Berkeley 94703 37.8724811102559 -122.27485749622628
6263 6263 6263 057 206102100 1726 Berkeley Way 1726 BERKELEY WAY 1726 BERKELEY WY 1726.0 BERKELEY WY     Berkeley 94703 37.87178125312962 -122.27635316152994
6295 6295 6295 057 207500600 1433 Berkeley Way C 1433 BERKELEY WAY C 1433 BERKELEY WY 1433.0 BERKELEY WY C   Berkeley 94702 37.87127507729975 -122.28294026855652
6331 6331 6331 057 206000100 1888 Berkeley Way Apt 403 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 403 APT Berkeley 94704 37.87215884968907 -122.2737850910334
6443 6443 6443 057 206000100 1888 Berkeley Way Apt 309 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 309 APT Berkeley 94704 37.87220622134896 -122.2736397265524
6506 6506 6506 057 206301400 1815 Berkeley Way 1815 BERKELEY WAY 1815 BERKELEY WY 1815.0 BERKELEY WY     Berkeley 94703 37.87251026181355 -122.2746241741026
6594 6594 6594 057 207301300 1328 Berkeley Way 1328 BERKELEY WAY 1328 BERKELEY WY 1328.0 BERKELEY WY     Berkeley 94702 37.87046957456959 -122.28591728091652
6803 6803 6803 057 206000100 1888 Berkeley Way Apt 304 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 304 APT Berkeley 94704 37.87219506485922 -122.27376718221988
6850 6850 6850 057 205602300 1945 Berkeley Way 406 1945 BERKELEY WAY 406 1945 BERKELEY WY 1945.0 BERKELEY WY 406   Berkeley 94704 37.8728988635272 -122.27127748703688
6998 6998 6998 057 205103000 2017 Berkeley Way 5 2017 BERKELEY WAY 5 2017 BERKELEY WY 2017.0 BERKELEY WY 5   Berkeley 94704 37.87306930079794 -122.26996137160236
7100 7100 7100 057 205801000 1909 Berkeley Way 1909 BERKELEY WAY 1909 BERKELEY WY 1909.0 BERKELEY WY     Berkeley 94704 37.87274164861403 -122.27263815172302
7148 7148 7148 057 206200700 1735 Berkeley Way 3 1735 BERKELEY WAY 3 1735 BERKELEY WY 1735.0 BERKELEY WY 3   Berkeley 94703 37.87231227280123 -122.27608348189176
7220 7220 7220 057 206801500 1505 Berkeley Way 1505 BERKELEY WAY 1505 BERKELEY WY 1505.0 BERKELEY WY     Berkeley 94703 37.87155767639895 -122.28163631002268
7227 7227 7227 057 205103000 2017 Berkeley Way 8 2017 BERKELEY WAY 8 2017 BERKELEY WY 2017.0 BERKELEY WY 8   Berkeley 94704 37.87306930079794 -122.26996137160236
7272 7272 7272 057 205103000 2017 Berkeley Way 1 2017 BERKELEY WAY 1 2017 BERKELEY WY 2017.0 BERKELEY WY 1   Berkeley 94704 37.87306930079794 -122.26996137160236
7381 7381 7381 057 207400600 1369 Berkeley Way 1369 BERKELEY WAY 1369 BERKELEY WY 1369.0 BERKELEY WY     Berkeley 94702 37.87100056965722 -122.2850560067648
7393 7393 7393 057 206301000 1829 Berkeley Way A 1829 BERKELEY WAY A 1829 BERKELEY WY 1829.0 BERKELEY WY A   Berkeley 94703 37.87258551192204 -122.27406284922093
7425 7425 7425 057 206002000 1822 Berkeley Way 1822 BERKELEY WAY 1822 BERKELEY WY 1822.0 BERKELEY WY     Berkeley 94703 37.87203371784614 -122.27424902686016
7692 7692 7692 057 207101503 1524 Berkeley Way 3 1524 BERKELEY WAY 3 1524 BERKELEY WY 1524.0 BERKELEY WY 3   Berkeley 94703 37.87123253629811 -122.28094847450124
7758 7758 7758 057 206000100 1888 Berkeley Way Apt 409 1888 BERKELEY WAY 1888 BERKELEY WY 1888.0 BERKELEY WY 409 APT Berkeley 94704 37.87217206048823 -122.27363306195129

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