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

657 rows where street_name = "9TH" and zipcode = 94710

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94710 · 657 ✖

street_type 1

street_name 1

  • 9TH · 657 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
58346 58346 58346 053 166003301 2823 9th St 2823 9TH ST 2823 9TH ST 2823.0 9TH ST     Berkeley 94710 37.85493907410955 -122.2895828115176
58355 58355 58355 054 174504404 2741 9th St 2741 9TH ST 2741 9TH ST 2741.0 9TH ST     Berkeley 94710 37.85628531083716 -122.2900594656922
58364 58364 58364 057 209200500 1910 9th St 1 1910 9TH ST 1 1910 9TH ST 1910.0 9TH ST 1   Berkeley 94710 37.86949284563107 -122.29505259938368
58368 58368 58368 057 209200700 1930 9th St 1930 9TH ST 1930 9TH ST 1930.0 9TH ST     Berkeley 94710 37.869289500870586 -122.29498524639862
58371 58371 58371 057 208901601 1923 9th St A 1923 9TH ST A 1923 9TH ST 1923.0 9TH ST A   Berkeley 94710 37.86928327247644 -122.29428612444391
58382 58382 58382 056 193701200 2332 9th St 1 2332 9TH ST 1 2332 9TH ST 2332.0 9TH ST 1   Berkeley 94710 37.86286717815443 -122.29291049202855
58388 58388 58388 056 193600700 2410 9th St 3 2410 9TH ST 3 2410 9TH ST 2410.0 9TH ST 3   Berkeley 94710 37.86191737016898 -122.29260860958408
58404 58404 58404 056 197100501 2102 9th St 2102 9TH ST 2102 9TH ST 2102.0 9TH ST     Berkeley 94710 37.867122708420496 -122.29411547328604
58410 58410 58410 056 193402400 2333 9th St 2 2333 9TH ST 2 2333 9TH ST 2333.0 9TH ST 2   Berkeley 94710 37.86301203855673 -122.292202819909
58413 58413 58413 056 193402500 2331 9th St B 2331 9TH ST B 2331 9TH ST 2331.0 9TH ST B   Berkeley 94710 37.86313434395187 -122.2922430473657
58419 58419 58419 056 193502500 2435 9th St 2 2435 9TH ST 2 2435 9TH ST 2435.0 9TH ST 2   Berkeley 94710 37.86120558646598 -122.29161697910486
58434 58434 58434 053 165200601 2919 9th St Apt 317 2919 9TH ST 2919 9TH ST 2919.0 9TH ST 317 APT Berkeley 94710 37.85198591962458 -122.28922135639672
58437 58437 58437 056 197101000 2122 9th St B 2122 9TH ST B 2122 9TH ST 2122.0 9TH ST B   Berkeley 94710 37.86646813830036 -122.29407942748696
58440 58440 58440 056 193601600 2438 9th St 2438 9TH ST 2438 9TH ST 2438.0 9TH ST     Berkeley 94710 37.86098770674008 -122.29230881482428
58448 58448 58448 053 165200601 2919 9th St Apt 314 2919 9TH ST 2919 9TH ST 2919.0 9TH ST 314 APT Berkeley 94710 37.852071838819235 -122.28925092893589
58458 58458 58458 058 212602100 1737 9th St 1737 9TH ST 1737 9TH ST 1737.0 9TH ST     Berkeley 94710 37.87171243461524 -122.29501709347208
58465 58465 58465 053 165200601 2909 9th St Apt 403 2909 9TH ST 2909 9TH ST 2909.0 9TH ST 403 APT Berkeley 94710 37.85246207828398 -122.2893372157122
58470 58470 58470 054 177800202 2560 9th St 212M 2560 9TH ST 212M 2560 9TH ST 2560.0 9TH ST 212M   Berkeley 94710 37.85944385287767 -122.2918178549788
58476 58476 58476 056 197203600 2018 9th St C 2018 9TH ST C 2018 9TH ST 2018.0 9TH ST C   Berkeley 94710 37.86737353746536 -122.294537759623
58483 58483 58483 056 197100700 2112 9th St A 2112 9TH ST A 2112 9TH ST 2112.0 9TH ST A   Berkeley 94710 37.86678607515162 -122.2941841306249
58487 58487 58487 053 165200601 2909 9th St Apt 207 2909 9TH ST 2909 9TH ST 2909.0 9TH ST 207 APT Berkeley 94710 37.85232245735491 -122.2894134171028
58490 58490 58490 054 174601705 2730 9th St 2730 9TH ST 2730 9TH ST 2730.0 9TH ST     Berkeley 94710 37.85636662330142 -122.2907783353118
58491 58491 58491 056 193701200 2332 9th St 4 2332 9TH ST 4 2332 9TH ST 2332.0 9TH ST 4   Berkeley 94710 37.86286717815443 -122.29291049202855
58503 58503 58503 056 197502800 2217 9th St 3 2217 9TH ST 3 2217 9TH ST 2217.0 9TH ST 3   Berkeley 94710 37.86538421284076 -122.29298169159964
58505 58505 58505 056 193701300 2344 9th St 5 2344 9TH ST 5 2344 9TH ST 2344.0 9TH ST 5   Berkeley 94710 37.86273369028056 -122.29286833588888
58516 58516 58516 060 235200201 1329 9th St 1329 9TH ST 1329 9TH ST 1329.0 9TH ST     Berkeley 94710 37.87913452189817 -122.2974916682122
58521 58521 58521 053 166003101 2829 9th St 2829 9TH ST 2829 9TH ST 2829.0 9TH ST     Berkeley 94710 37.85459806565301 -122.2894751017184
58522 58522 58522 056 197200800 2016 9th St X 2016 9TH ST X 2016 9TH ST 2016.0 9TH ST X   Berkeley 94710 37.8679108117423 -122.29454219999546
58534 58534 58534 056 197101300 2128 9th St 2128 9TH ST 2128 9TH ST 2128.0 9TH ST     Berkeley 94710 37.866183196433155 -122.2938706572183
58535 58535 58535 059 233301400 1421 9th St 1421 9TH ST 1421 9TH ST 1421.0 9TH ST     Berkeley 94710 37.877989927173594 -122.29704287348952
58536 58536 58536 060 235100500 1320 9th St 1 1320 9TH ST 1 1320 9TH ST 1320.0 9TH ST 1   Berkeley 94710 37.87913362778967 -122.2981769606031
58551 58551 58551 058 212301100 1732 9th St 1732 9TH ST 1732 9TH ST 1732.0 9TH ST     Berkeley 94710 37.87171534696548 -122.29576997330834
58552 58552 58552 056 193603800 2430 9th St 1 2430 9TH ST 1 2430 9TH ST 2430.0 9TH ST 1   Berkeley 94710 37.861313128217304 -122.2924155391716
58554 58554 58554 058 212401600 1644 9th St 1644 9TH ST 1644 9TH ST 1644.0 9TH ST     Berkeley 94710 37.87331553942917 -122.29629030447036
58561 58561 58561 059 232900700 1450 9th St 1450 9TH ST 1450 9TH ST 1450.0 9TH ST     Berkeley 94710 37.87662298779358 -122.29735986380048
58563 58563 58563 056 193402500 2331 9th St C 2331 9TH ST C 2331 9TH ST 2331.0 9TH ST C   Berkeley 94710 37.86313434395187 -122.2922430473657
58568 58568 58568 058 212401700 1646 9th St B 1646 9TH ST B 1646 9TH ST 1646.0 9TH ST B   Berkeley 94710 37.87316405284388 -122.29608222590444
58574 58574 58574 054 176500303 2612 9th St 2612 9TH ST 2612 9TH ST 2612.0 9TH ST     Berkeley 94710 37.85787475845369 -122.29121794116745
58575 58575 58575 056 197000900 2244 9th St 2244 9TH ST 2244 9TH ST 2244.0 9TH ST     Berkeley 94710 37.864324002348894 -122.29323934549112
58579 58579 58579 056 193402700 2327 9th St 2327 9TH ST 2327 9TH ST 2327.0 9TH ST     Berkeley 94710 37.86334496293374 -122.29231137681948
58580 58580 58580 056 193402400 2333 9th St 4 2333 9TH ST 4 2333 9TH ST 2333.0 9TH ST 4   Berkeley 94710 37.86301203855673 -122.292202819909
58586 58586 58586 058 212503300 1619 9th St 1619 9TH ST 1619 9TH ST 1619.0 9TH ST     Berkeley 94710 37.874079101362646 -122.295787309895
58594 58594 58594 054 174506600 2777 9th St 20 2777 9TH ST 20 2777 9TH ST 2777.0 9TH ST 20   Berkeley 94710 37.85606351133042 -122.28984290164014
58601 58601 58601 053 165200601 2919 9th St Apt 412 2919 9TH ST 2919 9TH ST 2919.0 9TH ST 412 APT Berkeley 94710 37.85214348524055 -122.28921406027996
58602 58602 58602 060 235102200 1332 9th St 1332 9TH ST 1332 9TH ST 1332.0 9TH ST     Berkeley 94710 37.87888288699686 -122.29804352215584
58603 58603 58603 056 193603500 2424 9th St 2424 9TH ST 2424 9TH ST 2424.0 9TH ST     Berkeley 94710 37.861445820794486 -122.29246036959589
58607 58607 58607 056 193700700 2312 9th St C 2312 9TH ST C 2312 9TH ST 2312.0 9TH ST C   Berkeley 94710 37.86353907900334 -122.29313112814376
58608 58608 58608 056 193502500 2435 9th St 3 2435 9TH ST 3 2435 9TH ST 2435.0 9TH ST 3   Berkeley 94710 37.86120558646598 -122.29161697910486
58610 58610 58610 054 177800202 2560 9th St 117 2560 9TH ST 117 2560 9TH ST 2560.0 9TH ST 117   Berkeley 94710 37.85944385287767 -122.2918178549788
58615 58615 58615 054 174603600 2720 9th St 1 2720 9TH ST 1 2720 9TH ST 2720.0 9TH ST 1   Berkeley 94710 37.85676180983509 -122.29088264229271
58624 58624 58624 057 209200500 1910 9th St 3 1910 9TH ST 3 1910 9TH ST 1910.0 9TH ST 3   Berkeley 94710 37.86949284563107 -122.29505259938368
58632 58632 58632 057 209200500 1910 9th St 2 1910 9TH ST 2 1910 9TH ST 1910.0 9TH ST 2   Berkeley 94710 37.86949284563107 -122.29505259938368
58641 58641 58641 054 177800202 2560 9th St 217 2560 9TH ST 217 2560 9TH ST 2560.0 9TH ST 217   Berkeley 94710 37.85944385287767 -122.2918178549788
58645 58645 58645 054 174506600 2777 9th St 6 2777 9TH ST 6 2777 9TH ST 2777.0 9TH ST 6   Berkeley 94710 37.85606351133042 -122.28984290164014
58651 58651 58651 056 193601600 2438 9th St A 2438 9TH ST A 2438 9TH ST 2438.0 9TH ST A   Berkeley 94710 37.86098770674008 -122.29230881482428
58655 58655 58655 058 212401500 1636 9th St 1636 9TH ST 1636 9TH ST 1636.0 9TH ST     Berkeley 94710 37.87341737296279 -122.29632485187956
58660 58660 58660 057 208901601 1923 9th St 1923 9TH ST 1923 9TH ST 1923.0 9TH ST     Berkeley 94710 37.86928327247644 -122.29428612444391
58663 58663 58663 054 177900100 2501 9th St 102 2501 9TH ST 102 2501 9TH ST 2501.0 9TH ST 102   Berkeley 94710 37.860511525133646 -122.291327458377
58665 58665 58665 056 193502500 2435 9th St 4 2435 9TH ST 4 2435 9TH ST 2435.0 9TH ST 4   Berkeley 94710 37.86120558646598 -122.29161697910486
58668 58668 58668 053 165200601 2919 9th St Apt 210 2919 9TH ST 2919 9TH ST 2919.0 9TH ST 210 APT Berkeley 94710 37.85217703474274 -122.28934956844564
58679 58679 58679 057 208901800 1915 9th St 1915 9TH ST 1915 9TH ST 1915.0 9TH ST     Berkeley 94710 37.86941570534031 -122.29427626184042
58689 58689 58689 053 165200601 2919 9th St Apt 212 2919 9TH ST 2919 9TH ST 2919.0 9TH ST 212 APT Berkeley 94710 37.85212025685267 -122.28933077748655
58705 58705 58705 060 235600501 1226 9th St 1226 9TH ST 1226 9TH ST 1226.0 9TH ST     Berkeley 94710 37.88075472728234 -122.29871881000946
58718 58718 58718 054 174506600 2777 9th St 13 2777 9TH ST 13 2777 9TH ST 2777.0 9TH ST 13   Berkeley 94710 37.85606351133042 -122.28984290164014
58722 58722 58722 058 212400700 1606 9th St 1606 9TH ST 1606 9TH ST 1606.0 9TH ST     Berkeley 94710 37.874272662298395 -122.29660111437217
58727 58727 58727 054 177800202 2550 9th St 112 2550 9TH ST 112 2550 9TH ST 2550.0 9TH ST 112   Berkeley 94710 37.85944385287767 -122.2918178549788
58728 58728 58728 056 193403000 2313 9th St 2 2313 9TH ST 2 2313 9TH ST 2313.0 9TH ST 2   Berkeley 94710 37.86367995169465 -122.2924207862312
58733 58733 58733 056 197301500 2029 9th St 2029 9TH ST 2029 9TH ST 2029.0 9TH ST     Berkeley 94710 37.8676317366442 -122.29384597959913
58735 58735 58735 053 165200601 2909 9th St Apt 208 2909 9TH ST 2909 9TH ST 2909.0 9TH ST 208 APT Berkeley 94710 37.85229406740739 -122.2894044025089
58741 58741 58741 053 165200601 2919 9th St Apt 418 2919 9TH ST 2919 9TH ST 2919.0 9TH ST 418 APT Berkeley 94710 37.85196767833631 -122.28915365127207
58744 58744 58744 059 233400802 1420 9th St 1420 9TH ST 1420 9TH ST 1420.0 9TH ST     Berkeley 94710 37.87746837613312 -122.29763153051206
58747 58747 58747 059 233400700 1408 9th St A 1408 9TH ST A 1408 9TH ST 1408.0 9TH ST A   Berkeley 94710 37.87779881375376 -122.29774002184554
58749 58749 58749 054 174603600 2714 9th St 4 2714 9TH ST 4 2714 9TH ST 2714.0 9TH ST 4   Berkeley 94710 37.85676180983509 -122.29088264229271
58754 58754 58754 059 233000203 1451 9th St 1451 9TH ST 1451 9TH ST 1451.0 9TH ST     Berkeley 94710 37.87676713902807 -122.29665290045166
58764 58764 58764 054 177800202 2560 9th St 320B 2560 9TH ST 320B 2560 9TH ST 2560.0 9TH ST 320B   Berkeley 94710 37.85944385287767 -122.2918178549788
58786 58786 58786 057 209200500 1910 9th St 6 1910 9TH ST 6 1910 9TH ST 1910.0 9TH ST 6   Berkeley 94710 37.86949284563107 -122.29505259938368
58796 58796 58796 054 177800202 2550 9th St 102 2550 9TH ST 102 2550 9TH ST 2550.0 9TH ST 102   Berkeley 94710 37.85944385287767 -122.2918178549788
58806 58806 58806 054 177800202 2560 9th St 316 2560 9TH ST 316 2560 9TH ST 2560.0 9TH ST 316   Berkeley 94710 37.85944385287767 -122.2918178549788
58812 58812 58812 058 212602800 1715 9th St 1715 9TH ST 1715 9TH ST 1715.0 9TH ST     Berkeley 94710 37.87252747618944 -122.29528278908197
58823 58823 58823 059 231201100 1570 9th St 1570 9TH ST 1570 9TH ST 1570.0 9TH ST     Berkeley 94710 37.87506958746742 -122.29685780886292
58841 58841 58841 059 233400801 1412 9th St A 1412 9TH ST A 1412 9TH ST 1412.0 9TH ST A   Berkeley 94710 37.87763883403055 -122.29768417358434
58842 58842 58842 058 212303200 1740 9th St 1740 9TH ST 1740 9TH ST 1740.0 9TH ST     Berkeley 94710 37.871417124398874 -122.2955392527057
58848 58848 58848 058 212600100 1703 9th St 1703 9TH ST 1703 9TH ST 1703.0 9TH ST     Berkeley 94710 37.87282968441171 -122.2955145140011
58850 58850 58850 056 193402500 2331 9th St 3 2331 9TH ST 3 2331 9TH ST 2331.0 9TH ST 3   Berkeley 94710 37.86313434395187 -122.2922430473657
58863 58863 58863 056 193603800 2428 9th St 2428 9TH ST 2428 9TH ST 2428.0 9TH ST     Berkeley 94710 37.861313128217304 -122.2924155391716
58870 58870 58870 058 212400900 1614 9th St 1614 9TH ST 1614 9TH ST 1614.0 9TH ST     Berkeley 94710 37.874057607245554 -122.2965318398907
58880 58880 58880 058 212502800 1635 9th St 1635 9TH ST 1635 9TH ST 1635.0 9TH ST     Berkeley 94710 37.873553165207035 -122.29561521334784
58887 58887 58887 056 197100700 2112 9th St C 2112 9TH ST C 2112 9TH ST 2112.0 9TH ST C   Berkeley 94710 37.86678607515162 -122.2941841306249
58893 58893 58893 053 165200601 2909 9th St 2909 9TH ST 2909 9TH ST 2909.0 9TH ST     Berkeley 94710 37.85254458801312 -122.28942874236154
58896 58896 58896 058 212602601 1721 9th St 4 1721 9TH ST 4 1721 9TH ST 1721.0 9TH ST 4   Berkeley 94710 37.872268545342834 -122.29523328472332
58902 58902 58902 054 177800202 2560 9th St 317A 2560 9TH ST 317A 2560 9TH ST 2560.0 9TH ST 317A   Berkeley 94710 37.85944385287767 -122.2918178549788
58904 58904 58904 057 208901900 1911 9th St 1911 9TH ST 1911 9TH ST 1911.0 9TH ST     Berkeley 94710 37.86955298918916 -122.2943229400992
58925 58925 58925 056 193601600 2438 9th St B 2438 9TH ST B 2438 9TH ST 2438.0 9TH ST B   Berkeley 94710 37.86098770674008 -122.29230881482428
58932 58932 58932 056 193502603 2429 9th St B 2429 9TH ST B 2429 9TH ST 2429.0 9TH ST B   Berkeley 94710 37.8614510746772 -122.29169068946716
58937 58937 58937 056 197203600 2018 9th St D 2018 9TH ST D 2018 9TH ST 2018.0 9TH ST D   Berkeley 94710 37.86737353746536 -122.294537759623
58954 58954 58954 054 174506600 2777 9th St 12 2777 9TH ST 12 2777 9TH ST 2777.0 9TH ST 12   Berkeley 94710 37.85606351133042 -122.28984290164014
58955 58955 58955 056 193700900 2320 9th St 1 2320 9TH ST 1 2320 9TH ST 2320.0 9TH ST 1   Berkeley 94710 37.863267316930106 -122.2930457711238
58957 58957 58957 058 212302700 1726 9th St 1726 9TH ST 1726 9TH ST 1726.0 9TH ST     Berkeley 94710 37.87191149458757 -122.29584661667008
58959 58959 58959 053 165900900 2808 9th St 2808 9TH ST 2808 9TH ST 2808.0 9TH ST     Berkeley 94710 37.85528776387431 -122.29048156428124
58961 58961 58961 056 193402400 2333 9th St 7 2333 9TH ST 7 2333 9TH ST 2333.0 9TH ST 7   Berkeley 94710 37.86301203855673 -122.292202819909

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