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,099 rows where street_type = "ST" and zipcode = 94710

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit_type

street_name 27

zipcode 1

  • 94710 · 5,099 ✖

street_type 1

  • ST · 5,099 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1 1 1 059 231000205 1080 Jones St Apt 106 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 106 APT Berkeley 94710 37.875857552605694 -122.29526674876428
12 12 12 059 231000205 1080 Jones St Apt 512 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 512 APT Berkeley 94710 37.876038373846576 -122.29539666491728
65 65 65 059 231000205 1080 Jones St Apt 551 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 551 APT Berkeley 94710 37.87615380369332 -122.29482956566495
73 73 73 056 197700300 1046 Addison St 1046 ADDISON ST 1046 ADDISON ST 1046.0 ADDISON ST     Berkeley 94710 37.86745915647912 -122.29232508870398
114 114 114 056 196001404 2010 5th St Apt 378 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 378 APT Berkeley 94710 37.86688112319923 -122.299139972554
214 214 214 054 174503301 1021 Grayson St 1021 GRAYSON ST 1021 GRAYSON ST 1021.0 GRAYSON ST     Berkeley 94710 37.85615306644765 -122.28940593952638
274 274 274 060 235500802 1025 Gilman St 1025 GILMAN ST 1025 GILMAN ST 1025.0 GILMAN ST     Berkeley 94710 37.88064798816878 -122.29766619021066
279 279 279 053 166000900 1016 Grayson St 1016 GRAYSON ST 1016 GRAYSON ST 1016.0 GRAYSON ST     Berkeley 94710 37.85571738145333 -122.28930798093958
357 357 357 057 209805100 800 Delaware St 13 800 DELAWARE ST 13 800 DELAWARE ST 800.0 DELAWARE ST 13   Berkeley 94710 37.870384354749206 -122.29928111495312
554 554 554 059 231601102 753 Cedar St 753 CEDAR ST 753 CEDAR ST 753.0 CEDAR ST     Berkeley 94710 37.873955218664825 -122.30142913951104
561 561 561 060 235401200 1031 Gilman St 1031 GILMAN ST 1031 GILMAN ST 1031.0 GILMAN ST     Berkeley 94710 37.88055137177347 -122.29685626286228
563 563 563 054 176600100 918 Parker St 13 918 PARKER ST 13 918 PARKER ST 918.0 PARKER ST 13   Berkeley 94710 37.85843022323249 -122.2927536560614
613 613 613 058 212600200 1006 Virginia St 1006 VIRGINIA ST 1006 VIRGINIA ST 1006.0 VIRGINIA ST     Berkeley 94710 37.87286699411413 -122.29533604660192
616 616 616 059 231000205 1080 Jones St Apt 244 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 244 APT Berkeley 94710 37.87599910656952 -122.2948083151186
639 639 639 059 231000205 1080 Jones St Apt 314 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 314 APT Berkeley 94710 37.87596337118779 -122.29523144227866
672 672 672 059 231000205 1080 Jones St Apt 525 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 525 APT Berkeley 94710 37.87607933295953 -122.29519543600544
682 682 682 056 197400300 1008 Addison St 1008 ADDISON ST 1008 ADDISON ST 1008.0 ADDISON ST     Berkeley 94710 37.867252210657064 -122.29344440751429
733 733 733 058 212500200 1004 Cedar St 1004 CEDAR ST 1004 CEDAR ST 1004.0 CEDAR ST     Berkeley 94710 37.87460467496349 -122.29595775174543
814 814 814 058 212400500 966 Cedar St 966 CEDAR ST 966 CEDAR ST 966.0 CEDAR ST     Berkeley 94710 37.87446426492218 -122.2966577477609
822 822 822 059 231000205 1080 Jones St Apt 232 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 232 APT Berkeley 94710 37.87596559556457 -122.29497295654724
839 839 839 057 209400300 906 Delaware St C 906 DELAWARE ST C 906 DELAWARE ST 906.0 DELAWARE ST C   Berkeley 94710 37.87063271343151 -122.29692183628477
875 875 875 056 196001100 741 Addison St A 741 ADDISON ST A 741 ADDISON ST 741.0 ADDISON ST A   Berkeley 94710 37.86661428372794 -122.29882113351022
924 924 924 056 196001404 2010 5th St Apt 570 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 570 APT Berkeley 94710 37.867054123124575 -122.29890122370767
930 930 930 059 234801400 805 Camelia St 805 CAMELIA ST 805 CAMELIA ST 805.0 CAMELIA ST     Berkeley 94710 37.877666650511976 -122.30160765272431
936 936 936 056 195600100 708 Addison St 708 ADDISON ST 708 ADDISON ST 708.0 ADDISON ST     Berkeley 94710 37.86544586037509 -122.29972235035268
946 946 946 057 209805100 801 Delaware St 5-12 801 DELAWARE ST 5-12 801 DELAWARE ST 801.0 DELAWARE ST 5-12   Berkeley 94710 37.870443938784405 -122.29930355756387
992 992 992 059 232500400 776 Page St 776 PAGE ST 776 PAGE ST 776.0 PAGE ST     Berkeley 94710 37.876005899530554 -122.30168946499217
1063 1063 1063 056 196001404 2010 5th St Apt 271 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 271 APT Berkeley 94710 37.866812167493926 -122.2992884784435
1078 1078 1078 056 196001404 2010 5th St Apt 579 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 579 APT Berkeley 94710 37.86695793141796 -122.29937878248576
1127 1127 1127 056 196100170 2001 5th St Apt 205 2001 5TH ST 2001 5TH ST 2001.0 5TH ST 205 APT Berkeley 94710 37.867444626506966 -122.29855689137445
1142 1142 1142 056 195400900 651 Addison St Apt 505 651 ADDISON ST 651 ADDISON ST 651.0 ADDISON ST 505 APT Berkeley 94710 37.866663183662354 -122.30111746722658
1276 1276 1276 059 231000205 1080 Jones St Apt 249 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 249 APT Berkeley 94710 37.876017724103 -122.29471684596142
1383 1383 1383 053 163402907 1028 Murray St 1028 MURRAY ST 1028 MURRAY ST 1028.0 MURRAY ST     Berkeley 94710 37.85131906663106 -122.28784507090614
1412 1412 1412 056 196001404 2010 5th St Apt 477 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 477 APT Berkeley 94710 37.86694109230713 -122.29926734288148
1448 1448 1448 059 233300700 1045 Page St 1045 PAGE ST 1045 PAGE ST 1045.0 PAGE ST     Berkeley 94710 37.87749510923068 -122.29626679825432
1540 1540 1540 058 212801500 1043 Virginia St 1043 VIRGINIA ST 1043 VIRGINIA ST 1043.0 VIRGINIA ST     Berkeley 94710 37.873506916211646 -122.2939594889218
1618 1618 1618 056 197203600 933 Addison St F 933 ADDISON ST F 933 ADDISON ST 933.0 ADDISON ST F   Berkeley 94710 37.86737353746536 -122.294537759623
1655 1655 1655 059 233200700 1048 Camelia St 1048 CAMELIA ST 1048 CAMELIA ST 1048.0 CAMELIA ST     Berkeley 94710 37.878490916229694 -122.29550342070566
1736 1736 1736 056 196001404 2010 5th St Apt 276 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 276 APT Berkeley 94710 37.866914372399656 -122.29877925405164
1740 1740 1740 056 197400500 1016 Addison St 1016 ADDISON ST 1016 ADDISON ST 1016.0 ADDISON ST     Berkeley 94710 37.867309487487795 -122.29316250629664
1759 1759 1759 056 196100170 2001 5th St Apt 310 2001 5TH ST 2001 5TH ST 2001.0 5TH ST 310 APT Berkeley 94710 37.86733669444544 -122.2984596658129
1798 1798 1798 056 196800300 910 Addison St 910 ADDISON ST 910 ADDISON ST 910.0 ADDISON ST     Berkeley 94710 37.866803453263934 -122.29565797585028
1831 1831 1831 059 232500300 770 Page St 770 PAGE ST 770 PAGE ST 770.0 PAGE ST     Berkeley 94710 37.875897897048254 -122.30188091933545
1846 1846 1846 053 164400300 801 Anthony St 801 ANTHONY ST 801 ANTHONY ST 801.0 ANTHONY ST     Berkeley 94710 37.85200689387318 -122.29361368335148
1892 1892 1892 058 212701700 1031 Delaware St 1031 DELAWARE ST 1031 DELAWARE ST 1031.0 DELAWARE ST     Berkeley 94710 37.871760821310296 -122.293873026974
1940 1940 1940 058 212301601 929 Delaware St E 929 DELAWARE ST E 929 DELAWARE ST 929.0 DELAWARE ST E   Berkeley 94710 37.87147682744036 -122.29616470472226
1991 1991 1991 056 195400900 651 Addison St Apt 419 651 ADDISON ST 651 ADDISON ST 651.0 ADDISON ST 419 APT Berkeley 94710 37.86628653404795 -122.30086108445126
2047 2047 2047 056 196001404 2000 5th St Apt 548 2000 5TH ST 2000 5TH ST 2000.0 5TH ST 548 APT Berkeley 94710 37.86747218870365 -122.2991357118446
2090 2090 2090 054 174602500 931 Grayson St 931 GRAYSON ST 931 GRAYSON ST 931.0 GRAYSON ST     Berkeley 94710 37.855792918943614 -122.29117106438096
2103 2103 2103 056 196100170 2001 5th St Apt 211 2001 5TH ST 2001 5TH ST 2001.0 5TH ST 211 APT Berkeley 94710 37.86729788773999 -122.29850866082684
2214 2214 2214 060 235600804 933 Gilman St 933 GILMAN ST 933 GILMAN ST 933.0 GILMAN ST     Berkeley 94710 37.88033159302045 -122.29876889917136
2410 2410 2410 054 174701200 901 Grayson St 202 901 GRAYSON ST 202 901 GRAYSON ST 901.0 GRAYSON ST 202   Berkeley 94710 37.85566378241478 -122.29200188744116
2484 2484 2484 053 163402100 926 Murray St 926 MURRAY ST 926 MURRAY ST 926.0 MURRAY ST     Berkeley 94710 37.850922752895144 -122.28945906589226
2512 2512 2512 058 212800200 1032 Cedar St 1032 CEDAR ST 1032 CEDAR ST 1032.0 CEDAR ST     Berkeley 94710 37.87486024715694 -122.2947242094518
2531 2531 2531 056 196100170 2001 5th St Apt 416 2001 5TH ST 2001 5TH ST 2001.0 5TH ST 416 APT Berkeley 94710 37.86719326866916 -122.29834791269664
2533 2533 2533 056 196001404 2010 5th St Apt 568 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 568 APT Berkeley 94710 37.867024029056886 -122.29905286112428
2551 2551 2551 059 234500601 635 Camelia St 635 CAMELIA ST 635 CAMELIA ST 635.0 CAMELIA ST     Berkeley 94710 37.87706165066124 -122.30470397482875
2570 2570 2570 058 212001500 871 Virginia St 871 VIRGINIA ST 871 VIRGINIA ST 871.0 VIRGINIA ST     Berkeley 94710 37.87270385807216 -122.29849146707228
2736 2736 2736 056 196800500 924 Addison St 924 ADDISON ST 924 ADDISON ST 924.0 ADDISON ST     Berkeley 94710 37.86688610295674 -122.29525719518122
2770 2770 2770 059 231000205 1080 Jones St Apt 336 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 336 APT Berkeley 94710 37.876022947165566 -122.29493874600624
2796 2796 2796 059 231000205 1080 Jones St Apt 328 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 328 APT Berkeley 94710 37.87600433034244 -122.2950302133668
2854 2854 2854 059 231200500 986 Jones St 986 JONES ST 986 JONES ST 986.0 JONES ST     Berkeley 94710 37.87563596729045 -122.2970318224149
2869 2869 2869 056 196001404 2010 5th St Apt 476 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 476 APT Berkeley 94710 37.86703055903661 -122.29882177311067
2871 2871 2871 059 234900200 836 Gilman St 836 GILMAN ST 836 GILMAN ST 836.0 GILMAN ST     Berkeley 94710 37.87891098308302 -122.30053430160538
2926 2926 2926 059 231800112 635 Cedar St 635 CEDAR ST 635 CEDAR ST 635.0 CEDAR ST     Berkeley 94710 37.87357439639497 -122.30366968964492
2974 2974 2974 056 196001404 2000 5th St Apt 553 2000 5TH ST 2000 5TH ST 2000.0 5TH ST 553 APT Berkeley 94710 37.867439622675775 -122.29929656148444
3021 3021 3021 056 196001404 2000 5th St Apt 250 2000 5TH ST 2000 5TH ST 2000.0 5TH ST 250 APT Berkeley 94710 37.867287941045234 -122.2991400444192
3097 3097 3097 056 197400400 1012 Addison St 1012 ADDISON ST 1012 ADDISON ST 1012.0 ADDISON ST     Berkeley 94710 37.86728210252056 -122.29330298933236
3109 3109 3109 056 196100170 2001 5th St Apt 402 2001 5TH ST 2001 5TH ST 2001.0 5TH ST 402 APT Berkeley 94710 37.86754769641831 -122.29846543209872
3149 3149 3149 056 196001404 2010 5th St Apt 472 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 472 APT Berkeley 94710 37.866999638783305 -122.29897894414944
3151 3151 3151 053 165800100 906 Grayson St 906 GRAYSON ST 906 GRAYSON ST 906.0 GRAYSON ST     Berkeley 94710 37.85514802275448 -122.29218611483792
3174 3174 3174 059 232901400 979 Jones St 979 JONES ST 979 JONES ST 979.0 JONES ST     Berkeley 94710 37.876033494687505 -122.29731696295742
3239 3239 3239 060 235801500 833 Gilman St 833 GILMAN ST 833 GILMAN ST 833.0 GILMAN ST     Berkeley 94710 37.87969765779809 -122.3010340263131
3525 3525 3525 056 196001404 2000 5th St Apt 258 2000 5TH ST 2000 5TH ST 2000.0 5TH ST 258 APT Berkeley 94710 37.86723487094533 -122.29940099422949
3557 3557 3557 059 231000205 1080 Jones St Apt 218 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 218 APT Berkeley 94710 37.8759283604665 -122.29515589216663
3568 3568 3568 057 208702100 1032 Delaware St A 1032 DELAWARE ST A 1032 DELAWARE ST 1032.0 DELAWARE ST A   Berkeley 94710 37.87126768753004 -122.2938160621069
3648 3648 3648 059 231000205 1080 Jones St Apt 420 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 420 APT Berkeley 94710 37.87603293735295 -122.29516076103546
3727 3727 3727 060 235100106 950 Gilman St 210 950 GILMAN ST 210 950 GILMAN ST 950.0 GILMAN ST 210   Berkeley 94710 37.87959657815016 -122.29855464019631
3866 3866 3866 056 195400900 651 Addison St Apt 506 651 ADDISON ST 651 ADDISON ST 651.0 ADDISON ST 506 APT Berkeley 94710 37.86667248297186 -122.3010707602217
3917 3917 3917 054 177000402 811 Carleton St 811 CARLETON ST 811 CARLETON ST 811.0 CARLETON ST     Berkeley 94710 37.85721395976086 -122.2947121486708
3960 3960 3960 056 196001404 2000 5th St Apt 347 2000 5TH ST 2000 5TH ST 2000.0 5TH ST 347 APT Berkeley 94710 37.8673494210434 -122.29906250633547
4046 4046 4046 059 231000205 1080 Jones St Apt 434 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 434 APT Berkeley 94710 37.87607017168908 -122.29497782541604
4121 4121 4121 059 231302400 903 Cedar St 903 CEDAR ST 903 CEDAR ST 903.0 CEDAR ST     Berkeley 94710 37.874563468266864 -122.2983268939156
4143 4143 4143 058 212502200 1017 Virginia St 1017 VIRGINIA ST 1017 VIRGINIA ST 1017.0 VIRGINIA ST     Berkeley 94710 37.8732869895099 -122.295356646768
4151 4151 4151 059 231500300 810 Jones St 810 JONES ST 810 JONES ST 810.0 JONES ST     Berkeley 94710 37.87491838386962 -122.30059398746953
4156 4156 4156 059 233400400 938 Camelia St 938 CAMELIA ST 938 CAMELIA ST 938.0 CAMELIA ST     Berkeley 94710 37.87796049841519 -122.29799951728336
4223 4223 4223 059 232700400 840 Page St C 840 PAGE ST C 840 PAGE ST 840.0 PAGE ST C   Berkeley 94710 37.87634327916566 -122.29971031741944
4272 4272 4272 053 166003800 1004 Grayson St 1004 GRAYSON ST 1004 GRAYSON ST 1004.0 GRAYSON ST     Berkeley 94710 37.85558732982893 -122.29001387080164
4324 4324 4324 053 163300109 1035 Murray St 1035 MURRAY ST 1035 MURRAY ST 1035.0 MURRAY ST     Berkeley 94710 37.851484264465086 -122.28849859258038
4325 4325 4325 053 164700100 750 Potter St 750 POTTER ST 750 POTTER ST 750.0 POTTER ST     Berkeley 94710 37.85070701258698 -122.29329526561756
4328 4328 4328 057 209805100 800 Delaware St 1121 800 DELAWARE ST 1121 800 DELAWARE ST 800.0 DELAWARE ST 1121   Berkeley 94710 37.870384354749206 -122.29928111495312
4433 4433 4433 056 196100170 2001 5th St Apt 303 2001 5TH ST 2001 5TH ST 2001.0 5TH ST 303 APT Berkeley 94710 37.86750985995362 -122.29851559582082
4497 4497 4497 054 177700200 915 Parker St 915 PARKER ST 915 PARKER ST 915.0 PARKER ST     Berkeley 94710 37.85886925825648 -122.2930381489186
4508 4508 4508 059 231000205 1080 Jones St Apt 251 1080 JONES ST 1080 JONES ST 1080.0 JONES ST 251 APT Berkeley 94710 37.876025171540554 -122.29468026027484
4526 4526 4526 054 174602300 937 Grayson St 937 GRAYSON ST 937 GRAYSON ST 937.0 GRAYSON ST     Berkeley 94710 37.85585904858379 -122.29084959866326
4584 4584 4584 056 196001404 2000 5th St Apt 348 2000 5TH ST 2000 5TH ST 2000.0 5TH ST 348 APT Berkeley 94710 37.86734318752111 -122.29909377489388
4594 4594 4594 058 212601700 1011 Delaware St 1011 DELAWARE ST 1011 DELAWARE ST 1011.0 DELAWARE ST     Berkeley 94710 37.871582751591866 -122.2947428009849
4687 4687 4687 056 196001404 2000 5th St Apt 457 2000 5TH ST 2000 5TH ST 2000.0 5TH ST 457 APT Berkeley 94710 37.867369411569946 -122.29940950666511
4767 4767 4767 059 234500100 630 Gilman St 630 GILMAN ST 630 GILMAN ST 630.0 GILMAN ST     Berkeley 94710 37.878190931433416 -122.30514220087213
4793 4793 4793 056 196001404 2010 5th St Apt 373 2010 5TH ST 2010 5TH ST 2010.0 5TH ST 373 APT Berkeley 94710 37.86695700454008 -122.29875934469004

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