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

5,586 rows where street_type = "ST" and zipcode = 94704

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

street_name 21

zipcode 1

  • 94704 · 5,586 ✖

street_type 1

  • ST · 5,586 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
4 4 4 055 182001500 2605 Milvia St 2605 MILVIA ST 2605 MILVIA ST 2605.0 MILVIA ST     Berkeley 94704 37.86164004895787 -122.26941061539996
9 9 9 055 183202000 2529 Ellsworth St 3 2529 ELLSWORTH ST 3 2529 ELLSWORTH ST 2529.0 ELLSWORTH ST 3   Berkeley 94704 37.863535204658334 -122.26252992007392
42 42 42 055 181603000 1936 Blake St 18 1936 BLAKE ST 18 1936 BLAKE ST 1936.0 BLAKE ST 18   Berkeley 94704 37.86238468255223 -122.27022266726398
60 60 60 057 202200800 1907 Center St 1 1907 CENTER ST 1 1907 CENTER ST 1907.0 CENTER ST 1   Berkeley 94704 37.87002797917772 -122.2722691830931
70 70 70 055 182100700 2037 Parker St Apt 306 2037 PARKER ST 2037 PARKER ST 2037.0 PARKER ST 306 APT Berkeley 94704 37.862287718095075 -122.26793969598742
74 74 74 057 202301701 2002 Addison St 2 2002 ADDISON ST 2 2002 ADDISON ST 2002.0 ADDISON ST 2   Berkeley 94704 37.8707665181595 -122.27030273500355
81 81 81 057 203201200 2112 Addison St 310 2112 ADDISON ST 310 2112 ADDISON ST 2112.0 ADDISON ST 310   Berkeley 94704 37.87110287937675 -122.26706095589168
113 113 113 055 188201700 2322 Haste St 17 2322 HASTE ST 17 2322 HASTE ST 2322.0 HASTE ST 17   Berkeley 94704 37.86531247645735 -122.2619736032999
115 115 115 055 185002700 2519 Etna St U2 2519 ETNA ST U2 2519 ETNA ST 2519.0 ETNA ST U2   Berkeley 94704 37.8651061486869 -122.25235137369422
139 139 139 055 182000101 2038 Parker St Apt 422 2038 PARKER ST 2038 PARKER ST 2038.0 PARKER ST 422 APT Berkeley 94704 37.861935569279304 -122.2676609155171
142 142 142 055 186800300 2747 Haste St 18 2747 HASTE ST 18 2747 HASTE ST 2747.0 HASTE ST 18   Berkeley 94704 37.866963294828146 -122.25214493994363
147 147 147 055 189601500 2419 Milvia St 2419 MILVIA ST 2419 MILVIA ST 2419.0 MILVIA ST     Berkeley 94704 37.864795201409166 -122.26971713045636
165 165 165 055 183900500 2512 Regent St 3 2512 REGENT ST 3 2512 REGENT ST 2512.0 REGENT ST 3   Berkeley 94704 37.86461955304099 -122.2580904881606
169 169 169 055 181703000 1928 Parker St 1928 PARKER ST 1928 PARKER ST 1928.0 PARKER ST     Berkeley 94704 37.86146181010024 -122.2702889611353
174 174 174 055 182000101 2038 Parker St Apt 219 2038 PARKER ST 2038 PARKER ST 2038.0 PARKER ST 219 APT Berkeley 94704 37.861754497115406 -122.26753692105844
176 176 176 057 202302600 2055 Center St Apt 904 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 904 APT Berkeley 94704 37.87050590474006 -122.26952670648076
181 181 181 057 203100200 2150 Oxford St 6 2150 OXFORD ST 6 2150 OXFORD ST 2150.0 OXFORD ST 6   Berkeley 94704 37.86988481392904 -122.26611805362673
189 189 189 055 188101701 2424 Haste St D40 2424 HASTE ST D40 2424 HASTE ST 2424.0 HASTE ST D40   Berkeley 94704 37.865632043728894 -122.26005680060452
235 235 235 055 188303300 2406 Dana St C 2406 DANA ST C 2406 DANA ST 2406.0 DANA ST C   Berkeley 94704 37.86619299435097 -122.2612807165516
240 240 240 057 202302600 2055 Center St Apt 312 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 312 APT Berkeley 94704 37.87036130159193 -122.26926794047496
241 241 241 055 182402000 2126 Blake St 2126 BLAKE ST 2126 BLAKE ST 2126.0 BLAKE ST     Berkeley 94704 37.8629711473545 -122.26590409918056
245 245 245 055 183000100 2233 Blake St 2233 BLAKE ST 2233 BLAKE ST 2233.0 BLAKE ST     Berkeley 94704 37.86430650521714 -122.26313026777152
284 284 284 057 203500302 2175 Kittredge St Apt 411 2175 KITTREDGE ST 2175 KITTREDGE ST 2175.0 KITTREDGE ST 411 APT Berkeley 94704 37.86895617786256 -122.26662864705108
292 292 292 055 188201700 2322 Haste St 12 2322 HASTE ST 12 2322 HASTE ST 2322.0 HASTE ST 12   Berkeley 94704 37.86531247645735 -122.2619736032999
296 296 296 057 202201401 1912 Addison St 11 1912 ADDISON ST 11 1912 ADDISON ST 1912.0 ADDISON ST 11   Berkeley 94704 37.87040566556387 -122.27214484188472
306 306 306 055 183201700 2537 Ellsworth St D 2537 ELLSWORTH ST D 2537 ELLSWORTH ST 2537.0 ELLSWORTH ST D   Berkeley 94704 37.86318108951605 -122.2623906838998
315 315 315 055 182000101 2038 Parker St Apt 321 2038 PARKER ST 2038 PARKER ST 2038.0 PARKER ST 321 APT Berkeley 94704 37.86188414424562 -122.2676272215074
319 319 319 055 183300304 2398 Parker St 17 2398 PARKER ST 17 2398 PARKER ST 2398.0 PARKER ST 17   Berkeley 94704 37.86275590045203 -122.26051400265996
330 330 330 057 203100200 2150 Oxford St 30 2150 OXFORD ST 30 2150 OXFORD ST 2150.0 OXFORD ST 30   Berkeley 94704 37.86988481392904 -122.26611805362673
340 340 340 057 203101100 2130 Center St Unit 301 2130 CENTER ST 2130 CENTER ST 2130.0 CENTER ST 301 UNIT Berkeley 94704 37.87025257177367 -122.26709881718594
348 348 348 055 185100700 2522 Warring St 2522 WARRING ST 2522 WARRING ST 2522.0 WARRING ST     Berkeley 94704 37.86502617487274 -122.25072532780857
352 352 352 055 183803100 2501 Dana St 5 2501 DANA ST 5 2501 DANA ST 2501.0 DANA ST 5   Berkeley 94704 37.864649053792235 -122.26039262679036
354 354 354 055 183403502 2338 Carleton St 2338 CARLETON ST 2338 CARLETON ST 2338.0 CARLETON ST     Berkeley 94704 37.86189699447908 -122.26061487717816
362 362 362 055 182501502 2113 Carleton St 2113 CARLETON ST 2113 CARLETON ST 2113.0 CARLETON ST     Berkeley 94704 37.86160630730952 -122.26645455175236
367 367 367 055 183200702 2336 Blake St 1 2336 BLAKE ST 1 2336 BLAKE ST 2336.0 BLAKE ST 1   Berkeley 94704 37.86359310705293 -122.26110028274024
375 375 375 055 186800701 2725 Haste St 202 2725 HASTE ST 202 2725 HASTE ST 2725.0 HASTE ST 202   Berkeley 94704 37.86693449991304 -122.25309103302442
377 377 377 055 189600701 2033 Haste St 206 2033 HASTE ST 206 2033 HASTE ST 2033.0 HASTE ST 206   Berkeley 94704 37.86499612465541 -122.26866857194096
383 383 383 055 182401900 2124 Blake St 9 2124 BLAKE ST 9 2124 BLAKE ST 2124.0 BLAKE ST 9   Berkeley 94704 37.86294995424496 -122.26606816658575
391 391 391 055 183300303 2390 Parker St 3 2390 PARKER ST 3 2390 PARKER ST 2390.0 PARKER ST 3   Berkeley 94704 37.86272896768392 -122.26072729504776
395 395 395 057 202801402 2020 Kittredge St 404 2020 KITTREDGE ST 404 2020 KITTREDGE ST 2020.0 KITTREDGE ST 404   Berkeley 94704 37.8678249152641 -122.26942837149984
412 412 412 055 186800402 2731 Haste St 10 2731 HASTE ST 10 2731 HASTE ST 2731.0 HASTE ST 10   Berkeley 94704 37.86699844880608 -122.25261262084682
418 418 418 055 182100700 2037 Parker St Apt 53 2037 PARKER ST 2037 PARKER ST 2037.0 PARKER ST 53 APT Berkeley 94704 37.862407336084054 -122.26801146509042
424 424 424 055 186400200 2300 Warring St 2300 WARRING ST 2300 WARRING ST 2300.0 WARRING ST     Berkeley 94704 37.86907088271465 -122.25123309243806
425 425 425 055 183301701 2609 Ellsworth St 203 2609 ELLSWORTH ST 203 2609 ELLSWORTH ST 2609.0 ELLSWORTH ST 203   Berkeley 94704 37.86222614025822 -122.26219043864316
434 434 434 057 203100101 2132 Oxford St 2132 OXFORD ST 2132 OXFORD ST 2132.0 OXFORD ST     Berkeley 94704 37.87025993966203 -122.26617633093244
441 441 441 055 186800701 2725 Haste St 102 2725 HASTE ST 102 2725 HASTE ST 2725.0 HASTE ST 102   Berkeley 94704 37.86693449991304 -122.25309103302442
443 443 443 055 189300503 2310 Fulton St Apt 402 2310 FULTON ST 2310 FULTON ST 2310.0 FULTON ST 402 APT Berkeley 94704 37.86706174024915 -122.26602633294128
452 452 452 055 188800300 2412 Ellsworth St 18 2412 ELLSWORTH ST 18 2412 ELLSWORTH ST 2412.0 ELLSWORTH ST 18   Berkeley 94704 37.8657853073931 -122.26361584311522
455 455 455 055 183201800 2535 Ellsworth St 2A 2535 ELLSWORTH ST 2A 2535 ELLSWORTH ST 2535.0 ELLSWORTH ST 2A   Berkeley 94704 37.8633005074791 -122.26241430150696
466 466 466 057 202200800 1907 Center St 2 1907 CENTER ST 2 1907 CENTER ST 1907.0 CENTER ST 2   Berkeley 94704 37.87002797917772 -122.2722691830931
470 470 470 055 183900400 2510 Regent St 2 2510 REGENT ST 2 2510 REGENT ST 2510.0 REGENT ST 2   Berkeley 94704 37.86472537996352 -122.2580914816973
487 487 487 057 204600804 1922 Walnut St Apt 302 1922 WALNUT ST 1922 WALNUT ST 1922.0 WALNUT ST 302 APT Berkeley 94704 37.87301096478544 -122.26741937740182
488 488 488 055 183303100 2320 Parker St A 2320 PARKER ST A 2320 PARKER ST 2320.0 PARKER ST A   Berkeley 94704 37.86254545141481 -122.2615268702108
506 506 506 055 182101600 2007 Parker St 2007 PARKER ST 2007 PARKER ST 2007.0 PARKER ST     Berkeley 94704 37.862161209931635 -122.26924371291172
547 547 547 055 187301400 2605 Haste St 201 2605 HASTE ST 201 2605 HASTE ST 2605.0 HASTE ST 201   Berkeley 94704 37.86652745247263 -122.25606201499392
550 550 550 055 188101701 2424 Haste St B42 2424 HASTE ST B42 2424 HASTE ST 2424.0 HASTE ST B42   Berkeley 94704 37.865632043728894 -122.26005680060452
567 567 567 055 182500100 2146 Parker St 2146 PARKER ST 2146 PARKER ST 2146.0 PARKER ST     Berkeley 94704 37.86228344652706 -122.26509776778826
573 573 573 055 182000101 2033 Blake St Apt 202 2033 BLAKE ST 2033 BLAKE ST 2033.0 BLAKE ST 202 APT Berkeley 94704 37.863193313299234 -122.26818446085124
587 587 587 057 203500302 2175 Kittredge St Apt 202 2175 KITTREDGE ST 2175 KITTREDGE ST 2175.0 KITTREDGE ST 202 APT Berkeley 94704 37.86913502476807 -122.2667728742649
589 589 589 057 202302600 2055 Center St Apt 817 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 817 APT Berkeley 94704 37.87052253455192 -122.2691756080368
604 604 604 055 182000101 2038 Parker St Apt 128 2038 PARKER ST 2038 PARKER ST 2038.0 PARKER ST 128 APT Berkeley 94704 37.86169986772196 -122.26758362985994
610 610 610 055 188600200 2310 Ellsworth St 1 2310 ELLSWORTH ST 1 2310 ELLSWORTH ST 2310.0 ELLSWORTH ST 1   Berkeley 94704 37.86770162341522 -122.2639256253443
625 625 625 055 182702900 2246 Carleton St 2246 CARLETON ST 2246 CARLETON ST 2246.0 CARLETON ST     Berkeley 94704 37.86161375974987 -122.26270508706271
636 636 636 055 188000700 2435 Haste St 3 2435 HASTE ST 3 2435 HASTE ST 2435.0 HASTE ST 3   Berkeley 94704 37.86619517150824 -122.25933618106676
644 644 644 055 186400801 2330 Warring St 110 2330 WARRING ST 110 2330 WARRING ST 2330.0 WARRING ST 110   Berkeley 94704 37.868153922521266 -122.25089275042131
653 653 653 055 185206000 2638 Warring St A 2638 WARRING ST A 2638 WARRING ST 2638.0 WARRING ST A   Berkeley 94704 37.86259855184171 -122.25048965389546
666 666 666 055 183213000 2550 Dana St 5G 2550 DANA ST 5G 2550 DANA ST 2550.0 DANA ST 5G   Berkeley 94704 37.863205032129635 -122.26071263094909
667 667 667 055 184202600 2521 Regent St 14 2521 REGENT ST 14 2521 REGENT ST 2521.0 REGENT ST 14   Berkeley 94704 37.864431292752194 -122.25735410857948
670 670 670 057 203500302 2175 Kittredge St Apt 501 2175 KITTREDGE ST 2175 KITTREDGE ST 2175.0 KITTREDGE ST 501 APT Berkeley 94704 37.869176969173175 -122.26661539600232
683 683 683 057 202400102 2010 Milvia St Apt 202 2010 MILVIA ST 2010 MILVIA ST 2010.0 MILVIA ST 202 APT Berkeley 94704 37.8713382835203 -122.27083420976668
699 699 699 055 183202500 2324 Blake St 3 2324 BLAKE ST 3 2324 BLAKE ST 2324.0 BLAKE ST 3   Berkeley 94704 37.86352750419314 -122.26161592828974
712 712 712 055 184500300 2640 Parker St 2640 PARKER ST 2640 PARKER ST 2640.0 PARKER ST     Berkeley 94704 37.86331274613566 -122.25438261367196
720 720 720 055 183301000 2329 Carleton St 2329 CARLETON ST 2329 CARLETON ST 2329.0 CARLETON ST     Berkeley 94704 37.862294502391435 -122.26119077902196
728 728 728 055 188300500 2414 Dana St 4 2414 DANA ST 4 2414 DANA ST 2414.0 DANA ST 4   Berkeley 94704 37.86595177910724 -122.2612195322976
730 730 730 057 203100200 2150 Oxford St 25 2150 OXFORD ST 25 2150 OXFORD ST 2150.0 OXFORD ST 25   Berkeley 94704 37.86988481392904 -122.26611805362673
747 747 747 055 185601700 2421 Prospect St 2421 PROSPECT ST 2421 PROSPECT ST 2421.0 PROSPECT ST     Berkeley 94704 37.866835340901474 -122.2493974174943
749 749 749 057 202300100 2080 Addison St 105 2080 ADDISON ST 105 2080 ADDISON ST 2080.0 ADDISON ST 105   Berkeley 94704 37.87086677599117 -122.26857126912434
755 755 755 055 188001502 2419 Haste St 5 2419 HASTE ST 5 2419 HASTE ST 2419.0 HASTE ST 5   Berkeley 94704 37.86621439715186 -122.25998557228736
756 756 756 057 202302500 2070 Addison St 710 2070 ADDISON ST 710 2070 ADDISON ST 2070.0 ADDISON ST 710   Berkeley 94704 37.87073121989894 -122.26874780334904
758 758 758 055 188802301 2405 Fulton St 305 2405 FULTON ST 305 2405 FULTON ST 2405.0 FULTON ST 305   Berkeley 94704 37.86574589494345 -122.26522780521384
784 784 784 055 189001302 2110 Haste St 524 2110 HASTE ST 524 2110 HASTE ST 2110.0 HASTE ST 524   Berkeley 94704 37.864687183201426 -122.26683788803692
788 788 788 057 202400102 2010 Milvia St Apt 301 2010 MILVIA ST 2010 MILVIA ST 2010.0 MILVIA ST 301 APT Berkeley 94704 37.87130856561906 -122.27086793970896
798 798 798 055 189100400 2416 Fulton St 2416 FULTON ST 2416 FULTON ST 2416.0 FULTON ST     Berkeley 94704 37.86536902150395 -122.26577223817496
831 831 831 055 182902600 2232 Blake St 5 2232 BLAKE ST 5 2232 BLAKE ST 2232.0 BLAKE ST 5   Berkeley 94704 37.863304854872545 -122.26335248581998
857 857 857 055 183100900 2335 Blake St 2335 BLAKE ST 2335 BLAKE ST 2335.0 BLAKE ST     Berkeley 94704 37.864126785633374 -122.2611459881236
859 859 859 055 185002700 2519 Etna St 3 2519 ETNA ST 3 2519 ETNA ST 2519.0 ETNA ST 3   Berkeley 94704 37.8651061486869 -122.25235137369422
873 873 873 057 203500302 2175 Kittredge St Apt 611 2175 KITTREDGE ST 2175 KITTREDGE ST 2175.0 KITTREDGE ST 611 APT Berkeley 94704 37.86897072313783 -122.26651710324224
879 879 879 057 202302600 2055 Center St Apt 415 2055 CENTER ST 2055 CENTER ST 2055.0 CENTER ST 415 APT Berkeley 94704 37.870400680371176 -122.2691960671674
882 882 882 055 188101701 2424 Haste St C12 2424 HASTE ST C12 2424 HASTE ST 2424.0 HASTE ST C12   Berkeley 94704 37.865632043728894 -122.26005680060452
891 891 891 055 183800600 2417 Blake St 5 2417 BLAKE ST 5 2417 BLAKE ST 2417.0 BLAKE ST 5   Berkeley 94704 37.864309705791214 -122.25972803517683
913 913 913 055 183201800 2535 Ellsworth St 6 2535 ELLSWORTH ST 6 2535 ELLSWORTH ST 2535.0 ELLSWORTH ST 6   Berkeley 94704 37.8633005074791 -122.26241430150696
933 933 933 055 186800701 2725 Haste St 309 2725 HASTE ST 309 2725 HASTE ST 2725.0 HASTE ST 309   Berkeley 94704 37.86693449991304 -122.25309103302442
940 940 940 055 183213000 2550 Dana St 2H 2550 DANA ST 2H 2550 DANA ST 2550.0 DANA ST 2H   Berkeley 94704 37.863205032129635 -122.26071263094909
956 956 956 055 183200701 2335 Parker St 1 2335 PARKER ST 1 2335 PARKER ST 2335.0 PARKER ST 1   Berkeley 94704 37.86321663323086 -122.2611113580694
969 969 969 055 188800400 2418 Ellsworth St 2418 ELLSWORTH ST 2418 ELLSWORTH ST 2418.0 ELLSWORTH ST     Berkeley 94704 37.865571369342135 -122.2634479354122
971 971 971 055 184400300 2616 Parker St 2616 PARKER ST 2616 PARKER ST 2616.0 PARKER ST     Berkeley 94704 37.86336468434182 -122.25537123479498
977 977 977 055 188101701 2424 Haste St D30 2424 HASTE ST D30 2424 HASTE ST 2424.0 HASTE ST D30   Berkeley 94704 37.865632043728894 -122.26005680060452
986 986 986 055 182201600 2515 Milvia St D 2515 MILVIA ST D 2515 MILVIA ST 2515.0 MILVIA ST D   Berkeley 94704 37.86318271713178 -122.26947081420208
995 995 995 055 182701600 2635 Fulton St A 2635 FULTON ST A 2635 FULTON ST 2635.0 FULTON ST A   Berkeley 94704 37.86109444668056 -122.26425787623528
1006 1006 1006 057 202400102 2010 Milvia St Apt 713 2010 MILVIA ST 2010 MILVIA ST 2010.0 MILVIA ST 713 APT Berkeley 94704 37.87156101209999 -122.27106907789094

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