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

80 rows where street_name = "ALLSTON" and zipcode = 94710

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94710 · 80 ✖

street_type 1

street_name 1

  • ALLSTON · 80 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
436 436 436 056 196300300 808 Allston Way 808 ALLSTON WAY 808 ALLSTON WY 808.0 ALLSTON WY     Berkeley 94710 37.86492207808195 -122.297379513549
713 713 713 056 197101600 941 Allston Way 941 ALLSTON WAY 941 ALLSTON WY 941.0 ALLSTON WY     Berkeley 94710 37.866056300656474 -122.29400711130994
947 947 947 056 197101400 949 Allston Way 949 ALLSTON WAY 949 ALLSTON WY 949.0 ALLSTON WY     Berkeley 94710 37.866060598245234 -122.29377332475724
1195 1195 1195 056 196402501 830 Allston Way 830 ALLSTON WAY 830 ALLSTON WY 830.0 ALLSTON WY     Berkeley 94710 37.86510351265648 -122.2964232533358
1473 1473 1473 056 195900901 739 Allston Way 739 ALLSTON WAY 739 ALLSTON WY 739.0 ALLSTON WY     Berkeley 94710 37.865244919207214 -122.29833229638372
2061 2061 2061 056 197600200 1034 Allston Way 1034 ALLSTON WAY 1034 ALLSTON WY 1034.0 ALLSTON WY     Berkeley 94710 37.86599762010617 -122.292041961286
2405 2405 2405 056 196201700 805 Allston Way 805 ALLSTON WAY 805 ALLSTON WY 805.0 ALLSTON WY     Berkeley 94710 37.86531659112096 -122.29765322841943
4108 4108 4108 056 197101800 935 Allston Way 935 ALLSTON WAY 935 ALLSTON WY 935.0 ALLSTON WY     Berkeley 94710 37.866008543507114 -122.29424410754314
4982 4982 4982 056 197000101 920 Allston Way 920 ALLSTON WAY 920 ALLSTON WY 920.0 ALLSTON WY     Berkeley 94710 37.865471802846045 -122.2940951336314
6023 6023 6023 056 196801400 913 Allston Way 913 ALLSTON WAY 913 ALLSTON WY 913.0 ALLSTON WY     Berkeley 94710 37.86584379025258 -122.29506050365988
6524 6524 6524 056 195800100 724 Allston Way 724 ALLSTON WAY 724 ALLSTON WY 724.0 ALLSTON WY     Berkeley 94710 37.8646316546055 -122.29862235699906
6747 6747 6747 056 197401600 1017 Allston Way B 1017 ALLSTON WAY B 1017 ALLSTON WY 1017.0 ALLSTON WY B   Berkeley 94710 37.8663056681847 -122.29277885650008
7879 7879 7879 056 197701500 1033 Allston Way 1033 ALLSTON WAY 1033 ALLSTON WY 1033.0 ALLSTON WY     Berkeley 94710 37.86644882336764 -122.2920563846362
8104 8104 8104 056 195800100 726 Allston Way 726 ALLSTON WAY 726 ALLSTON WY 726.0 ALLSTON WY     Berkeley 94710 37.8646316546055 -122.29862235699906
11733 11733 11733 056 195900901 741 Allston Way 741 ALLSTON WAY 741 ALLSTON WY 741.0 ALLSTON WY     Berkeley 94710 37.865244919207214 -122.29833229638372
13272 13272 13272 056 196801500 909 Allston Way 909 ALLSTON WAY 909 ALLSTON WY 909.0 ALLSTON WY     Berkeley 94710 37.86580754855784 -122.29523629497784
13311 13311 13311 056 197500100 1004 Allston Way 1004 ALLSTON WAY 1004 ALLSTON WY 1004.0 ALLSTON WY     Berkeley 94710 37.86575986500155 -122.29324548457777
13796 13796 13796 056 196201500 811 Allston Way 811 ALLSTON WAY 811 ALLSTON WY 811.0 ALLSTON WY     Berkeley 94710 37.865378544368376 -122.29736705750926
14470 14470 14470 056 195700102 700 Allston Way 700 ALLSTON WAY 700 ALLSTON WY 700.0 ALLSTON WY     Berkeley 94710 37.864306091050246 -122.29956901152694
15089 15089 15089 056 196300400 812 Allston Way B 812 ALLSTON WAY B 812 ALLSTON WY 812.0 ALLSTON WY B   Berkeley 94710 37.864901442243024 -122.29721101924608
15265 15265 15265 056 196201400 815 Allston Way 815 ALLSTON WAY 815 ALLSTON WY 815.0 ALLSTON WY     Berkeley 94710 37.86533746370981 -122.29713485827966
17416 17416 17416 056 195902300 727 Allston Way 727 ALLSTON WAY 727 ALLSTON WY 727.0 ALLSTON WY     Berkeley 94710 37.86501845896131 -122.2987494766966
17779 17779 17779 056 196400300 840 Allston Way 2 840 ALLSTON WAY 2 840 ALLSTON WY 840.0 ALLSTON WY 2   Berkeley 94710 37.86518411472152 -122.29602507328946
19788 19788 19788 056 197401900 1011 Allston Way 1011 ALLSTON WAY 1011 ALLSTON WY 1011.0 ALLSTON WY     Berkeley 94710 37.86624488443102 -122.29308046046684
21273 21273 21273 056 197401500 1019 Allston Way B 1019 ALLSTON WAY B 1019 ALLSTON WY 1019.0 ALLSTON WY B   Berkeley 94710 37.86633334711132 -122.29265554565931
21568 21568 21568 056 196501600 839 Allston Way 839 ALLSTON WAY 839 ALLSTON WY 839.0 ALLSTON WY     Berkeley 94710 37.86559058592919 -122.29627828680847
22039 22039 22039 056 197102000 927 Allston Way 927 ALLSTON WAY 927 ALLSTON WY 927.0 ALLSTON WY     Berkeley 94710 37.865950232398504 -122.29453202837148
22040 22040 22040 056 197401600 1017 Allston Way 1017 ALLSTON WAY 1017 ALLSTON WY 1017.0 ALLSTON WY     Berkeley 94710 37.8663056681847 -122.29277885650008
22409 22409 22409 056 195902300 727 Allston Way 1 727 ALLSTON WAY 1 727 ALLSTON WY 727.0 ALLSTON WY 1   Berkeley 94710 37.86501845896131 -122.2987494766966
22418 22418 22418 056 197101700 939 Allston Way 939 ALLSTON WAY 939 ALLSTON WY 939.0 ALLSTON WY     Berkeley 94710 37.8660336340628 -122.29411566642382
22750 22750 22750 056 197600300 1036 Allston Way 1036 ALLSTON WAY 1036 ALLSTON WY 1036.0 ALLSTON WY     Berkeley 94710 37.866023029084495 -122.29190493047592
25583 25583 25583 056 197500100 1004 Allston Way B 1004 ALLSTON WAY B 1004 ALLSTON WY 1004.0 ALLSTON WY B   Berkeley 94710 37.86575986500155 -122.29324548457777
26519 26519 26519 056 197401800 1013 Allston Way 1013 ALLSTON WAY 1013 ALLSTON WY 1013.0 ALLSTON WY     Berkeley 94710 37.86626518232831 -122.29297873793898
28298 28298 28298 056 197101500 945 Allston Way B 945 ALLSTON WAY B 945 ALLSTON WY 945.0 ALLSTON WY B   Berkeley 94710 37.86603909966125 -122.29388367919664
29099 29099 29099 056 196300400 812 Allston Way 812 ALLSTON WAY 812 ALLSTON WY 812.0 ALLSTON WY     Berkeley 94710 37.864901442243024 -122.29721101924608
29224 29224 29224 056 196201800 801 Allston Way 801 ALLSTON WAY 801 ALLSTON WY 801.0 ALLSTON WY     Berkeley 94710 37.86528194127726 -122.29781782942388
29670 29670 29670 056 196400300 840 Allston Way 4 840 ALLSTON WAY 4 840 ALLSTON WY 840.0 ALLSTON WY 4   Berkeley 94710 37.86518411472152 -122.29602507328946
30768 30768 30768 056 197101500 945 Allston Way 945 ALLSTON WAY 945 ALLSTON WY 945.0 ALLSTON WY     Berkeley 94710 37.86603909966125 -122.29388367919664
30827 30827 30827 056 196400300 840 Allston Way 840 ALLSTON WAY 840 ALLSTON WY 840.0 ALLSTON WY     Berkeley 94710 37.86518411472152 -122.29602507328946
31297 31297 31297 056 197401500 1019 Allston Way 1019 ALLSTON WAY 1019 ALLSTON WY 1019.0 ALLSTON WY     Berkeley 94710 37.86633334711132 -122.29265554565931
31378 31378 31378 056 197701700 1023 Allston Way 1023 ALLSTON WAY 1023 ALLSTON WY 1023.0 ALLSTON WY     Berkeley 94710 37.86639626326564 -122.29231924426472
31421 31421 31421 056 197401700 1015 Allston Way 1015 ALLSTON WAY 1015 ALLSTON WY 1015.0 ALLSTON WY     Berkeley 94710 37.86628537384442 -122.29287875993946
31624 31624 31624 056 196300400 812 Allston Way A 812 ALLSTON WAY A 812 ALLSTON WY 812.0 ALLSTON WY A   Berkeley 94710 37.864901442243024 -122.29721101924608
31976 31976 31976 056 197101900 931 Allston Way 931 ALLSTON WAY 931 ALLSTON WY 931.0 ALLSTON WY     Berkeley 94710 37.865978051875054 -122.29438898064564
32443 32443 32443 056 196402501 828 Allston Way 828 ALLSTON WAY 828 ALLSTON WY 828.0 ALLSTON WY     Berkeley 94710 37.86510351265648 -122.2964232533358
32574 32574 32574 056 197402000 1009 Allston Way 1009 ALLSTON WAY 1009 ALLSTON WY 1009.0 ALLSTON WY     Berkeley 94710 37.86622521627243 -122.2931821802997
33547 33547 33547 056 197500100 1004 Allston Way A 1004 ALLSTON WAY A 1004 ALLSTON WY 1004.0 ALLSTON WY A   Berkeley 94710 37.86575986500155 -122.29324548457777
34174 34174 34174 056 196400400 846 Allston Way 846 ALLSTON WAY 846 ALLSTON WY 846.0 ALLSTON WY     Berkeley 94710 37.86521715760674 -122.29585867385782
35736 35736 35736 056 197701600 1027 Allston Way 1027 ALLSTON WAY 1027 ALLSTON WY 1027.0 ALLSTON WY     Berkeley 94710 37.86642209831745 -122.29218907029522
36063 36063 36063 056 197500300 1012 Allston Way 2 1012 ALLSTON WAY 2 1012 ALLSTON WY 1012.0 ALLSTON WY 2   Berkeley 94710 37.865821691643056 -122.29294285832825
36142 36142 36142 056 196400200 832 Allston Way A 832 ALLSTON WAY A 832 ALLSTON WY 832.0 ALLSTON WY A   Berkeley 94710 37.86515234693032 -122.29618709792568
36281 36281 36281 056 197500300 1012 Allston Way 1 1012 ALLSTON WAY 1 1012 ALLSTON WY 1012.0 ALLSTON WY 1   Berkeley 94710 37.865821691643056 -122.29294285832825
37466 37466 37466 056 195901100 733 Allston Way 733 ALLSTON WAY 733 ALLSTON WY 733.0 ALLSTON WY     Berkeley 94710 37.86514626853304 -122.2985132619977
38867 38867 38867 056 197701400 1035 Allston Way 1035 ALLSTON WAY 1035 ALLSTON WY 1035.0 ALLSTON WY     Berkeley 94710 37.86648145365858 -122.29190032930502
39449 39449 39449 056 197600200 1032 Allston Way 1032 ALLSTON WAY 1032 ALLSTON WY 1032.0 ALLSTON WY     Berkeley 94710 37.86599762010617 -122.292041961286
39725 39725 39725 056 196400300 840 Allston Way 1 840 ALLSTON WAY 1 840 ALLSTON WY 840.0 ALLSTON WY 1   Berkeley 94710 37.86518411472152 -122.29602507328946
40071 40071 40071 056 196300200 804 Allston Way 804 ALLSTON WAY 804 ALLSTON WY 804.0 ALLSTON WY     Berkeley 94710 37.86489265048601 -122.29752861681814
40298 40298 40298 056 195902300 727 Allston Way 2 727 ALLSTON WAY 2 727 ALLSTON WY 727.0 ALLSTON WY 2   Berkeley 94710 37.86501845896131 -122.2987494766966
41245 41245 41245 056 196201600 807 Allston Way 807B 807 ALLSTON WAY 807B 807 ALLSTON WY 807.0 ALLSTON WY 807B   Berkeley 94710 37.865351592701614 -122.29748686222544
41343 41343 41343 056 197600100 1030 Allston Way 1030 ALLSTON WAY 1030 ALLSTON WY 1030.0 ALLSTON WY     Berkeley 94710 37.86597054952466 -122.29217556951482
41702 41702 41702 056 197600300 1036 Allston Way B 1036 ALLSTON WAY B 1036 ALLSTON WY 1036.0 ALLSTON WY B   Berkeley 94710 37.866023029084495 -122.29190493047592
42254 42254 42254 056 197500400 1014 Allston Way 1014 ALLSTON WAY 1014 ALLSTON WY 1014.0 ALLSTON WY     Berkeley 94710 37.86584225205173 -122.29284550161267
42873 42873 42873 056 197402100 1007 Allston Way 1007 ALLSTON WAY 1007 ALLSTON WY 1007.0 ALLSTON WY     Berkeley 94710 37.86620381489301 -122.29328220950325
43312 43312 43312 056 197701400 1039 Allston Way 1039 ALLSTON WAY 1039 ALLSTON WY 1039.0 ALLSTON WY     Berkeley 94710 37.86648145365858 -122.29190032930502
43524 43524 43524 056 196300500 816 Allston Way 816 ALLSTON WAY 816 ALLSTON WY 816.0 ALLSTON WY     Berkeley 94710 37.86506747626061 -122.29703304322535
43653 43653 43653 056 197701400 1037 Allston Way 1037 ALLSTON WAY 1037 ALLSTON WY 1037.0 ALLSTON WY     Berkeley 94710 37.86648145365858 -122.29190032930502
44012 44012 44012 056 197500100 1000 Allston Way 1000 ALLSTON WAY 1000 ALLSTON WY 1000.0 ALLSTON WY     Berkeley 94710 37.86575986500155 -122.29324548457777
44122 44122 44122 056 196300200 806 Allston Way 806 ALLSTON WAY 806 ALLSTON WY 806.0 ALLSTON WY     Berkeley 94710 37.86489265048601 -122.29752861681814
44254 44254 44254 056 196400200 834 Allston Way 834 ALLSTON WAY 834 ALLSTON WY 834.0 ALLSTON WY     Berkeley 94710 37.86515234693032 -122.29618709792568
46824 46824 46824 056 195600100 719 Allston Way 719 ALLSTON WAY 719 ALLSTON WY 719.0 ALLSTON WY     Berkeley 94710 37.86544586037509 -122.29972235035268
47323 47323 47323 056 196400300 840 Allston Way 3 840 ALLSTON WAY 3 840 ALLSTON WY 840.0 ALLSTON WY 3   Berkeley 94710 37.86518411472152 -122.29602507328946
48337 48337 48337 056 196201600 807 Allston Way 807 ALLSTON WAY 807 ALLSTON WY 807.0 ALLSTON WY     Berkeley 94710 37.865351592701614 -122.29748686222544
49122 49122 49122 056 197500200 1010 Allston Way 1010 ALLSTON WAY 1010 ALLSTON WY 1010.0 ALLSTON WY     Berkeley 94710 37.86579400046822 -122.29307561136092
49938 49938 49938 056 196201600 809 Allston Way 809 ALLSTON WAY 809 ALLSTON WY 809.0 ALLSTON WY     Berkeley 94710 37.865351592701614 -122.29748686222544
50382 50382 50382 056 197701400 1041 Allston Way 1041 ALLSTON WAY 1041 ALLSTON WY 1041.0 ALLSTON WY     Berkeley 94710 37.86648145365858 -122.29190032930502
51938 51938 51938 056 196201600 809 Allston Way 809 809 ALLSTON WAY 809 809 ALLSTON WY 809.0 ALLSTON WY 809   Berkeley 94710 37.865351592701614 -122.29748686222544
53637 53637 53637 056 196400200 836 Allston Way 836 ALLSTON WAY 836 ALLSTON WY 836.0 ALLSTON WY     Berkeley 94710 37.86515234693032 -122.29618709792568
56915 56915 56915 056 196400200 832 Allston Way B 832 ALLSTON WAY B 832 ALLSTON WY 832.0 ALLSTON WY B   Berkeley 94710 37.86515234693032 -122.29618709792568
56950 56950 56950 056 197600300 1036 Allston Way A 1036 ALLSTON WAY A 1036 ALLSTON WY 1036.0 ALLSTON WY A   Berkeley 94710 37.866023029084495 -122.29190493047592
57992 57992 57992 056 197500300 1012 Allston Way 1012 ALLSTON WAY 1012 ALLSTON WY 1012.0 ALLSTON WY     Berkeley 94710 37.865821691643056 -122.29294285832825

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