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

117 rows where street_name = "BANCROFT" and zipcode = 94710

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94710 · 117 ✖

street_type 1

street_name 1

  • BANCROFT · 117 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
782 782 782 056 197501800 1019 Bancroft Way 1019 BANCROFT WAY 1019 BANCROFT WY 1019.0 BANCROFT WY     Berkeley 94710 37.86452672112502 -122.29225501472192
813 813 813 056 195700301 747 Bancroft Way 747 BANCROFT WAY 747 BANCROFT WY 747.0 BANCROFT WY     Berkeley 94710 37.86352512767258 -122.29888397785086
2599 2599 2599 056 193800200 904 Bancroft Way 904 BANCROFT WAY 904 BANCROFT WY 904.0 BANCROFT WY     Berkeley 94710 37.863563130716976 -122.29478180852952
3405 3405 3405 056 197001100 939 Bancroft Way 939 BANCROFT WAY 939 BANCROFT WY 939.0 BANCROFT WY     Berkeley 94710 37.86425329325958 -122.29359194501993
3957 3957 3957 056 194200400 818 Bancroft Way 5 818 BANCROFT WAY 5 818 BANCROFT WY 818.0 BANCROFT WY 5   Berkeley 94710 37.86325506337282 -122.2963741550156
5326 5326 5326 056 197502100 985 Bancroft Way 985 BANCROFT WAY 985 BANCROFT WY 985.0 BANCROFT WY     Berkeley 94710 37.864425136284616 -122.29275925346394
5588 5588 5588 056 193300200 1028 Bancroft Way 1028 BANCROFT WAY 1028 BANCROFT WY 1028.0 BANCROFT WY     Berkeley 94710 37.864226897896 -122.29147083668286
5758 5758 5758 056 196401400 845 Bancroft Way H 845 BANCROFT WAY H 845 BANCROFT WY 845.0 BANCROFT WY H   Berkeley 94710 37.86385747953951 -122.29559617804696
5920 5920 5920 056 196401600 835 Bancroft Way B 835 BANCROFT WAY B 835 BANCROFT WY 835.0 BANCROFT WY B   Berkeley 94710 37.86379483709443 -122.29591513207508
7461 7461 7461 056 194100302 838 Bancroft Way 838 BANCROFT WAY 838 BANCROFT WY 838.0 BANCROFT WY     Berkeley 94710 37.86346771173434 -122.2952914012306
7483 7483 7483 056 196301506 825 Bancroft Way 825 BANCROFT WAY 825 BANCROFT WY 825.0 BANCROFT WY     Berkeley 94710 37.86358566828748 -122.29673075294572
7496 7496 7496 056 197001400 931 Bancroft Way 931 BANCROFT WAY 931 BANCROFT WY 931.0 BANCROFT WY     Berkeley 94710 37.864176684341274 -122.2939789446342
7837 7837 7837 056 196401400 845 Bancroft Way I 845 BANCROFT WAY I 845 BANCROFT WY 845.0 BANCROFT WY I   Berkeley 94710 37.86385747953951 -122.29559617804696
9083 9083 9083 056 196401300 855 Bancroft Way B 855 BANCROFT WAY B 855 BANCROFT WY 855.0 BANCROFT WY B   Berkeley 94710 37.8638903329556 -122.2954280915792
9477 9477 9477 056 193400200 1008 Bancroft Way 1008 BANCROFT WAY 1008 BANCROFT WY 1008.0 BANCROFT WY     Berkeley 94710 37.86404103154713 -122.29243588960608
10047 10047 10047 056 194200301 808 Bancroft Way 808 BANCROFT WAY 808 BANCROFT WY 808.0 BANCROFT WY     Berkeley 94710 37.862962765995626 -122.29667710825191
10915 10915 10915 056 197001200 937 Bancroft Way 937 BANCROFT WAY 937 BANCROFT WY 937.0 BANCROFT WY     Berkeley 94710 37.864223598740836 -122.2937453278631
12328 12328 12328 056 196401400 845 Bancroft Way G 845 BANCROFT WAY G 845 BANCROFT WY 845.0 BANCROFT WY G   Berkeley 94710 37.86385747953951 -122.29559617804696
13876 13876 13876 056 197001000 943 Bancroft Way 943 BANCROFT WAY 943 BANCROFT WY 943.0 BANCROFT WY     Berkeley 94710 37.86428870880307 -122.29341778234756
15055 15055 15055 056 196901900 917 Bancroft Way 917 BANCROFT WAY 917 BANCROFT WY 917.0 BANCROFT WY     Berkeley 94710 37.86406638801068 -122.2945419206194
16120 16120 16120 056 194100301 834 Bancroft Way 834 BANCROFT WAY 834 BANCROFT WY 834.0 BANCROFT WY     Berkeley 94710 37.86343464962554 -122.29545432238548
16528 16528 16528 056 197502000 1007 Bancroft Way 1007 BANCROFT WAY 1007 BANCROFT WY 1007.0 BANCROFT WY     Berkeley 94710 37.86446498771911 -122.2925644546929
16936 16936 16936 056 196401300 855 Bancroft Way E 855 BANCROFT WAY E 855 BANCROFT WY 855.0 BANCROFT WY E   Berkeley 94710 37.8638903329556 -122.2954280915792
17009 17009 17009 056 193700200 930 Bancroft Way 930 BANCROFT WAY 930 BANCROFT WY 930.0 BANCROFT WY     Berkeley 94710 37.863789196867586 -122.29364474889064
17179 17179 17179 056 197602000 1027 Bancroft Way B 1027 BANCROFT WAY B 1027 BANCROFT WY 1027.0 BANCROFT WY B   Berkeley 94710 37.864645672390346 -122.29166455747556
17554 17554 17554 056 193300200 1028 Bancroft Way 2 1028 BANCROFT WAY 2 1028 BANCROFT WY 1028.0 BANCROFT WY 2   Berkeley 94710 37.864226897896 -122.29147083668286
18406 18406 18406 056 196401400 845 Bancroft Way J 845 BANCROFT WAY J 845 BANCROFT WY 845.0 BANCROFT WY J   Berkeley 94710 37.86385747953951 -122.29559617804696
18816 18816 18816 056 194100200 832 Bancroft Way 832 BANCROFT WAY 832 BANCROFT WY 832.0 BANCROFT WY     Berkeley 94710 37.86340198678074 -122.29561816431352
19934 19934 19934 056 196301506 821 Bancroft Way 821 BANCROFT WAY 821 BANCROFT WY 821.0 BANCROFT WY     Berkeley 94710 37.86356626891395 -122.29683855167816
19951 19951 19951 056 196301506 827 Bancroft Way 827 BANCROFT WAY 827 BANCROFT WY 827.0 BANCROFT WY     Berkeley 94710 37.86361400140582 -122.29661943461406
20376 20376 20376 056 194100301 834 Bancroft Way 3 834 BANCROFT WAY 3 834 BANCROFT WY 834.0 BANCROFT WY 3   Berkeley 94710 37.86343464962554 -122.29545432238548
20479 20479 20479 056 193700300 938 Bancroft Way 938 BANCROFT WAY 938 BANCROFT WY 938.0 BANCROFT WY     Berkeley 94710 37.8638260026554 -122.29345430245714
20578 20578 20578 056 196901900 917 Bancroft Way A 917 BANCROFT WAY A 917 BANCROFT WY 917.0 BANCROFT WY A   Berkeley 94710 37.86406638801068 -122.2945419206194
22863 22863 22863 056 193700500 956 Bancroft Way 956 BANCROFT WAY 956 BANCROFT WY 956.0 BANCROFT WY     Berkeley 94710 37.8638968547027 -122.29310598340068
23925 23925 23925 056 197001000 941 Bancroft Way 941 BANCROFT WAY 941 BANCROFT WY 941.0 BANCROFT WY     Berkeley 94710 37.86428870880307 -122.29341778234756
24125 24125 24125 056 194900700 630 Bancroft Way 630 BANCROFT WAY 630 BANCROFT WY 630.0 BANCROFT WY     Berkeley 94710 37.862267660942706 -122.29992063997692
24129 24129 24129 056 194102202 830 Bancroft Way 830 BANCROFT WAY 830 BANCROFT WY 830.0 BANCROFT WY     Berkeley 94710 37.86329738203636 -122.29579660206832
24611 24611 24611 056 193300400 1038 Bancroft Way 1038 BANCROFT WAY 1038 BANCROFT WY 1038.0 BANCROFT WY     Berkeley 94710 37.864286133024585 -122.29118464780638
25072 25072 25072 056 193700200 932 Bancroft Way 932 BANCROFT WAY 932 BANCROFT WY 932.0 BANCROFT WY     Berkeley 94710 37.863789196867586 -122.29364474889064
25204 25204 25204 056 196901900 917 Bancroft Way B 917 BANCROFT WAY B 917 BANCROFT WY 917.0 BANCROFT WY B   Berkeley 94710 37.86406638801068 -122.2945419206194
25676 25676 25676 056 196902200 907 Bancroft Way 907 BANCROFT WAY 907 BANCROFT WY 907.0 BANCROFT WY     Berkeley 94710 37.863992988705355 -122.29491688011392
25684 25684 25684 056 193400300 1012 Bancroft Way 1012 BANCROFT WAY 1012 BANCROFT WY 1012.0 BANCROFT WY     Berkeley 94710 37.864057601827504 -122.29231125375028
27081 27081 27081 056 193700400 944 Bancroft Way 944 BANCROFT WAY 944 BANCROFT WY 944.0 BANCROFT WY     Berkeley 94710 37.86386003122038 -122.29328612975112
27576 27576 27576 056 196902100 909 Bancroft Way 909 BANCROFT WAY 909 BANCROFT WY 909.0 BANCROFT WY     Berkeley 94710 37.86401870971047 -122.29477723610472
28855 28855 28855 056 194900602 620 Bancroft Way 620 BANCROFT WAY 620 BANCROFT WY 620.0 BANCROFT WY     Berkeley 94710 37.86148332845919 -122.299618331731
29096 29096 29096 056 194200400 818 Bancroft Way 818 BANCROFT WAY 818 BANCROFT WY 818.0 BANCROFT WY     Berkeley 94710 37.86325506337282 -122.2963741550156
29160 29160 29160 056 193800500 916 Bancroft Way 916 BANCROFT WAY 916 BANCROFT WY 916.0 BANCROFT WY     Berkeley 94710 37.863652483111856 -122.29434304349697
29255 29255 29255 056 196902000 913 Bancroft Way 913 BANCROFT WAY 913 BANCROFT WY 913.0 BANCROFT WY     Berkeley 94710 37.86404274992046 -122.29465911842462
29438 29438 29438 056 196401300 855 Bancroft Way F 855 BANCROFT WAY F 855 BANCROFT WY 855.0 BANCROFT WY F   Berkeley 94710 37.8638903329556 -122.2954280915792
29449 29449 29449 056 197501800 1023 Bancroft Way 1023 BANCROFT WAY 1023 BANCROFT WY 1023.0 BANCROFT WY     Berkeley 94710 37.86452672112502 -122.29225501472192
29608 29608 29608 056 196401700 831 Bancroft Way 831 BANCROFT WAY 831 BANCROFT WY 831.0 BANCROFT WY     Berkeley 94710 37.863686013901415 -122.29609609409584
30127 30127 30127 056 193700200 928 Bancroft Way 928 BANCROFT WAY 928 BANCROFT WY 928.0 BANCROFT WY     Berkeley 94710 37.863789196867586 -122.29364474889064
30292 30292 30292 056 196401300 855 Bancroft Way D 855 BANCROFT WAY D 855 BANCROFT WY 855.0 BANCROFT WY D   Berkeley 94710 37.8638903329556 -122.2954280915792
30497 30497 30497 056 194900700 626 Bancroft Way 626 BANCROFT WAY 626 BANCROFT WY 626.0 BANCROFT WY     Berkeley 94710 37.862267660942706 -122.29992063997692
30672 30672 30672 056 195700701 701 Bancroft Way 701 BANCROFT WAY 701 BANCROFT WY 701.0 BANCROFT WY     Berkeley 94710 37.86338318805033 -122.2992764068827
30795 30795 30795 056 194200100 800 Bancroft Way 800 BANCROFT WAY 800 BANCROFT WY 800.0 BANCROFT WY     Berkeley 94710 37.86308039428736 -122.29703590256293
30901 30901 30901 056 196301506 819 Bancroft Way 819 BANCROFT WAY 819 BANCROFT WY 819.0 BANCROFT WY     Berkeley 94710 37.863532189151144 -122.29693852877938
31223 31223 31223 056 197602000 1027 Bancroft Way C 1027 BANCROFT WAY C 1027 BANCROFT WY 1027.0 BANCROFT WY C   Berkeley 94710 37.864645672390346 -122.29166455747556
31272 31272 31272 056 197501800 1021 Bancroft Way 1021 BANCROFT WAY 1021 BANCROFT WY 1021.0 BANCROFT WY     Berkeley 94710 37.86452672112502 -122.29225501472192
31446 31446 31446 056 196901700 925 Bancroft Way 925 BANCROFT WAY 925 BANCROFT WY 925.0 BANCROFT WY     Berkeley 94710 37.86411547189808 -122.29429448865756
31459 31459 31459 056 193700300 936 Bancroft Way 936 BANCROFT WAY 936 BANCROFT WY 936.0 BANCROFT WY     Berkeley 94710 37.8638260026554 -122.29345430245714
31695 31695 31695 056 193300400 1036 Bancroft Way 1036 BANCROFT WAY 1036 BANCROFT WY 1036.0 BANCROFT WY     Berkeley 94710 37.864286133024585 -122.29118464780638
31950 31950 31950 056 196401300 855 Bancroft Way 855 BANCROFT WAY 855 BANCROFT WY 855.0 BANCROFT WY     Berkeley 94710 37.8638903329556 -122.2954280915792
32479 32479 32479 056 195700701 705 Bancroft Way 705 BANCROFT WAY 705 BANCROFT WY 705.0 BANCROFT WY     Berkeley 94710 37.86338318805033 -122.2992764068827
32909 32909 32909 056 196401400 845 Bancroft Way L 845 BANCROFT WAY L 845 BANCROFT WY 845.0 BANCROFT WY L   Berkeley 94710 37.86385747953951 -122.29559617804696
33410 33410 33410 056 194200400 818 Bancroft Way 4 818 BANCROFT WAY 4 818 BANCROFT WY 818.0 BANCROFT WY 4   Berkeley 94710 37.86325506337282 -122.2963741550156
33528 33528 33528 056 196301506 809 Bancroft Way 809 BANCROFT WAY 809 BANCROFT WY 809.0 BANCROFT WY     Berkeley 94710 37.8634848516295 -122.29713151744514
33817 33817 33817 056 193700400 940 Bancroft Way 940 BANCROFT WAY 940 BANCROFT WY 940.0 BANCROFT WY     Berkeley 94710 37.86386003122038 -122.29328612975112
33886 33886 33886 056 193300200 1028 Bancroft Way 1 1028 BANCROFT WAY 1 1028 BANCROFT WY 1028.0 BANCROFT WY 1   Berkeley 94710 37.864226897896 -122.29147083668286
33902 33902 33902 056 196401500 837 Bancroft Way 837 BANCROFT WAY 837 BANCROFT WY 837.0 BANCROFT WY     Berkeley 94710 37.86382335594131 -122.2957685782247
34057 34057 34057 056 193300300 1032 Bancroft Way 1032 BANCROFT WAY 1032 BANCROFT WY 1032.0 BANCROFT WY     Berkeley 94710 37.864254603134285 -122.29133376365196
34197 34197 34197 056 194100301 834 Bancroft Way 1 834 BANCROFT WAY 1 834 BANCROFT WY 834.0 BANCROFT WY 1   Berkeley 94710 37.86343464962554 -122.29545432238548
34534 34534 34534 056 196401600 835 Bancroft Way A 835 BANCROFT WAY A 835 BANCROFT WY 835.0 BANCROFT WY A   Berkeley 94710 37.86379483709443 -122.29591513207508
35926 35926 35926 056 193300300 1034 Bancroft Way 1034 BANCROFT WAY 1034 BANCROFT WY 1034.0 BANCROFT WY     Berkeley 94710 37.864254603134285 -122.29133376365196
36405 36405 36405 056 196301506 801 Bancroft Way 801 BANCROFT WAY 801 BANCROFT WY 801.0 BANCROFT WY     Berkeley 94710 37.86346567917289 -122.29722438887246
36788 36788 36788 056 196902300 901 Bancroft Way 901 BANCROFT WAY 901 BANCROFT WY 901.0 BANCROFT WY     Berkeley 94710 37.86396210689229 -122.29507126996856
36974 36974 36974 056 193700500 954 Bancroft Way 954 BANCROFT WAY 954 BANCROFT WY 954.0 BANCROFT WY     Berkeley 94710 37.8638968547027 -122.29310598340068
37254 37254 37254 056 197501900 1011 Bancroft Way 1011 BANCROFT WAY 1011 BANCROFT WY 1011.0 BANCROFT WY     Berkeley 94710 37.864491265981336 -122.2924325963822
37623 37623 37623 056 194100302 840 Bancroft Way 840 BANCROFT WAY 840 BANCROFT WY 840.0 BANCROFT WY     Berkeley 94710 37.86346771173434 -122.2952914012306
40153 40153 40153 056 196401400 845 Bancroft Way 6 845 BANCROFT WAY 6 845 BANCROFT WY 845.0 BANCROFT WY 6   Berkeley 94710 37.86385747953951 -122.29559617804696
40510 40510 40510 056 193800200 904 Bancroft Way B 904 BANCROFT WAY B 904 BANCROFT WY 904.0 BANCROFT WY B   Berkeley 94710 37.863563130716976 -122.29478180852952
40686 40686 40686 056 196401600 835 Bancroft Way 835 BANCROFT WAY 835 BANCROFT WY 835.0 BANCROFT WY     Berkeley 94710 37.86379483709443 -122.29591513207508
40896 40896 40896 056 194100301 834 Bancroft Way 2 834 BANCROFT WAY 2 834 BANCROFT WY 834.0 BANCROFT WY 2   Berkeley 94710 37.86343464962554 -122.29545432238548
41236 41236 41236 056 196301506 829 Bancroft Way 829 BANCROFT WAY 829 BANCROFT WY 829.0 BANCROFT WY     Berkeley 94710 37.86363362700036 -122.29649670767824
41916 41916 41916 056 197001300 935 Bancroft Way 935 BANCROFT WAY 935 BANCROFT WY 935.0 BANCROFT WY     Berkeley 94710 37.864197565054006 -122.29387036616414
42140 42140 42140 056 193800200 906 Bancroft Way B 906 BANCROFT WAY B 906 BANCROFT WY 906.0 BANCROFT WY B   Berkeley 94710 37.863563130716976 -122.29478180852952
42729 42729 42729 056 194100301 834 Bancroft Way C 834 BANCROFT WAY C 834 BANCROFT WY 834.0 BANCROFT WY C   Berkeley 94710 37.86343464962554 -122.29545432238548
42970 42970 42970 056 193800600 922 Bancroft Way 922 BANCROFT WAY 922 BANCROFT WY 922.0 BANCROFT WY     Berkeley 94710 37.86368502953749 -122.29417668538782
43226 43226 43226 056 197601800 1039 Bancroft Way 1039 BANCROFT WAY 1039 BANCROFT WY 1039.0 BANCROFT WY     Berkeley 94710 37.864715448523626 -122.291311183599
43235 43235 43235 056 194100301 834 Bancroft Way 4 834 BANCROFT WAY 4 834 BANCROFT WY 834.0 BANCROFT WY 4   Berkeley 94710 37.86343464962554 -122.29545432238548
43852 43852 43852 056 194500102 742 Bancroft Way 742 BANCROFT WAY 742 BANCROFT WY 742.0 BANCROFT WY     Berkeley 94710 37.862933736898654 -122.29770599725586
44315 44315 44315 056 196401700 833 Bancroft Way 833 BANCROFT WAY 833 BANCROFT WY 833.0 BANCROFT WY     Berkeley 94710 37.8637051792088 -122.29599730995729
44719 44719 44719 056 193800200 906 Bancroft Way A 906 BANCROFT WAY A 906 BANCROFT WY 906.0 BANCROFT WY A   Berkeley 94710 37.863563130716976 -122.29478180852952
46129 46129 46129 056 193300200 1028 Bancroft Way 3 1028 BANCROFT WAY 3 1028 BANCROFT WY 1028.0 BANCROFT WY 3   Berkeley 94710 37.864226897896 -122.29147083668286
46387 46387 46387 056 193400200 1006 Bancroft Way 1006 BANCROFT WAY 1006 BANCROFT WY 1006.0 BANCROFT WY     Berkeley 94710 37.86401926500834 -122.29253461445576
48365 48365 48365 056 193700500 950 Bancroft Way 950 BANCROFT WAY 950 BANCROFT WY 950.0 BANCROFT WY     Berkeley 94710 37.8638968547027 -122.29310598340068
48771 48771 48771 056 197602000 1027 Bancroft Way A 1027 BANCROFT WAY A 1027 BANCROFT WY 1027.0 BANCROFT WY A   Berkeley 94710 37.864645672390346 -122.29166455747556
49716 49716 49716 056 193800300 910 Bancroft Way 910 BANCROFT WAY 910 BANCROFT WY 910.0 BANCROFT WY     Berkeley 94710 37.86359476586423 -122.29463008128138
51180 51180 51180 056 193400500 1018 Bancroft Way 1018 BANCROFT WAY 1018 BANCROFT WY 1018.0 BANCROFT WY     Berkeley 94710 37.86417195119922 -122.29197616238636
51305 51305 51305 056 197601900 1031 Bancroft Way 1031 BANCROFT WAY 1031 BANCROFT WY 1031.0 BANCROFT WY     Berkeley 94710 37.86468583716588 -122.29146542612988

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