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

77 rows where street_name = "DWIGHT" and zipcode = 94710

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: apn

zipcode 1

  • 94710 · 77 ✖

street_type 1

street_name 1

  • DWIGHT · 77 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
1171 1171 1171 056 193201201 1057 Dwight Way 1057 DWIGHT WAY 1057 DWIGHT WY 1057.0 DWIGHT WY     Berkeley 94710 37.86104784660169 -122.29041808752665
1469 1469 1469 056 193902300 903 Dwight Way 903 DWIGHT WAY 903 DWIGHT WY 903.0 DWIGHT WY     Berkeley 94710 37.86040596166656 -122.29385759930732
1563 1563 1563 054 177300101 800 Dwight Way Unit B54 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B54 UNIT Berkeley 94710 37.85944911612316 -122.29521399430092
3189 3189 3189 054 177300101 800 Dwight Way Unit B50 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B50 UNIT Berkeley 94710 37.85948248782848 -122.2950522822784
3923 3923 3923 056 194401801 727 Dwight Way 727 DWIGHT WAY 727 DWIGHT WY 727.0 DWIGHT WY     Berkeley 94710 37.85983261286642 -122.29686781968844
3990 3990 3990 056 193902100 923 Dwight Way 923 DWIGHT WAY 923 DWIGHT WY 923.0 DWIGHT WY     Berkeley 94710 37.86051252868903 -122.29324693625526
6495 6495 6495 054 177300101 800 Dwight Way Unit B48 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B48 UNIT Berkeley 94710 37.85940770803802 -122.29570881869874
6521 6521 6521 054 177300101 800 Dwight Way Unit B54A 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B54A UNIT Berkeley 94710 37.85943751230114 -122.29527022254948
6607 6607 6607 054 177300101 800 Dwight Way Unit B59 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B59 UNIT Berkeley 94710 37.85941495076657 -122.29508565648784
7931 7931 7931 054 177300101 800 Dwight Way Unit B64 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B64 UNIT Berkeley 94710 37.85935809617942 -122.29536116080232
8531 8531 8531 054 177300101 800 Dwight Way Unit B56A 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B56A UNIT Berkeley 94710 37.859404051920855 -122.2954323639667
8934 8934 8934 054 177300101 800 Dwight Way Unit B53 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B53 UNIT Berkeley 94710 37.85946046816439 -122.29515898865944
9604 9604 9604 054 177300101 800 Dwight Way Unit B52 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B52 UNIT Berkeley 94710 37.85947190318447 -122.2951035751828
9616 9616 9616 054 177300101 800 Dwight Way Unit B47A 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B47A UNIT Berkeley 94710 37.85941877993699 -122.29565517041164
11288 11288 11288 054 177300101 800 Dwight Way Unit B28 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B28 UNIT Berkeley 94710 37.85947199609448 -122.2953972991279
11855 11855 11855 056 193902300 901 Dwight Way 901 DWIGHT WAY 901 DWIGHT WY 901.0 DWIGHT WY     Berkeley 94710 37.86040596166656 -122.29385759930732
12306 12306 12306 056 194401801 739 Dwight Way 739 DWIGHT WAY 739 DWIGHT WY 739.0 DWIGHT WY     Berkeley 94710 37.85990086799792 -122.29657305639256
12452 12452 12452 054 177300101 800 Dwight Way Unit B60 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B60 UNIT Berkeley 94710 37.8594035157376 -122.29514107086275
12592 12592 12592 054 177300101 800 Dwight Way Unit B19 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B19 UNIT Berkeley 94710 37.85949446044622 -122.29528844218008
14016 14016 14016 056 194001703 851 Dwight Way 851 DWIGHT WAY 851 DWIGHT WY 851.0 DWIGHT WY     Berkeley 94710 37.86024813569266 -122.29456814154422
14066 14066 14066 054 177800101 930 Dwight Way 930 DWIGHT WAY 930 DWIGHT WY 930.0 DWIGHT WY     Berkeley 94710 37.8596262796833 -122.29234025675754
14233 14233 14233 054 177300101 800 Dwight Way Unit B63 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B63 UNIT Berkeley 94710 37.85936955958493 -122.29530561168008
14358 14358 14358 056 193601800 943 Dwight Way 943 DWIGHT WAY 943 DWIGHT WY 943.0 DWIGHT WY     Berkeley 94710 37.86070927847752 -122.2921533990936
14495 14495 14495 054 177801600 940 Dwight Way 14 940 DWIGHT WAY 14 940 DWIGHT WY 940.0 DWIGHT WY 14   Berkeley 94710 37.86024573849867 -122.29206670448218
15503 15503 15503 056 194700101 701 Dwight Way 701 DWIGHT WAY 701 DWIGHT WY 701.0 DWIGHT WY     Berkeley 94710 37.860195603083575 -122.29807622981536
16207 16207 16207 054 177300101 800 Dwight Way Unit B14 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B14 UNIT Berkeley 94710 37.85951741558249 -122.29517720918832
16277 16277 16277 056 193601900 937 Dwight Way 937 DWIGHT WAY 937 DWIGHT WY 937.0 DWIGHT WY     Berkeley 94710 37.86065758095496 -122.2924397200224
16394 16394 16394 056 194401801 735 Dwight Way 735 DWIGHT WAY 735 DWIGHT WY 735.0 DWIGHT WY     Berkeley 94710 37.85988912310982 -122.2966733164631
17834 17834 17834 056 193902200 911 Dwight Way 911 DWIGHT WAY 911 DWIGHT WY 911.0 DWIGHT WY     Berkeley 94710 37.86045849554419 -122.2935573688646
19154 19154 19154 056 194401801 723 Dwight Way 723 DWIGHT WAY 723 DWIGHT WY 723.0 DWIGHT WY     Berkeley 94710 37.85976323211789 -122.29685262738036
20382 20382 20382 056 193502001 1001 Dwight Way 1001 DWIGHT WAY 1001 DWIGHT WY 1001.0 DWIGHT WY     Berkeley 94710 37.86090112984898 -122.29130616291484
21885 21885 21885 054 177300101 800 Dwight Way Unit B18 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B18 UNIT Berkeley 94710 37.85950606425927 -122.29523221393148
21900 21900 21900 056 194401801 737 Dwight Way 737 DWIGHT WAY 737 DWIGHT WY 737.0 DWIGHT WY     Berkeley 94710 37.85983168944509 -122.2965443642024
22846 22846 22846 054 177300101 800 Dwight Way 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY     Berkeley 94710 37.859557543435706 -122.29542478488064
23069 23069 23069 056 193902200 915 Dwight Way 915 DWIGHT WAY 915 DWIGHT WY 915.0 DWIGHT WY     Berkeley 94710 37.86045849554419 -122.2935573688646
23737 23737 23737 054 178000200 1090 Dwight Way 1090 DWIGHT WAY 1090 DWIGHT WY 1090.0 DWIGHT WY     Berkeley 94710 37.86075739863761 -122.29018312238432
24794 24794 24794 054 177900401 1048 Dwight Way 1048 DWIGHT WAY 1048 DWIGHT WY 1048.0 DWIGHT WY     Berkeley 94710 37.86069141098152 -122.29081352501645
27224 27224 27224 054 177300101 800 Dwight Way Unit B49 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B49 UNIT Berkeley 94710 37.85939576732182 -122.29576667649124
27924 27924 27924 056 194401801 731 Dwight Way 731 DWIGHT WAY 731 DWIGHT WY 731.0 DWIGHT WY     Berkeley 94710 37.85985546364014 -122.29677381548552
28718 28718 28718 054 177300101 800 Dwight Way Unit B13 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B13 UNIT Berkeley 94710 37.85952885059378 -122.2951217948134
28748 28748 28748 054 177300101 800 Dwight Way Unit B58 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B58 UNIT Berkeley 94710 37.85942553612796 -122.29503436358344
30182 30182 30182 054 177900300 1042 Dwight Way 1042 DWIGHT WAY 1042 DWIGHT WY 1042.0 DWIGHT WY     Berkeley 94710 37.86067359525458 -122.29089935904182
32688 32688 32688 054 177300101 800 Dwight Way Unit B55 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B55 UNIT Berkeley 94710 37.8594265120379 -122.29532353037509
35147 35147 35147 054 177300101 700 Dwight Way 700 DWIGHT WAY 700 DWIGHT WY 700.0 DWIGHT WY     Berkeley 94710 37.85937859739693 -122.29605937635692
35271 35271 35271 054 177300101 800 Dwight Way Unit B61 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B61 UNIT Berkeley 94710 37.85939216368765 -122.29519607560594
35709 35709 35709 054 178000300 1092 Dwight Way 1092 DWIGHT WAY 1092 DWIGHT WY 1092.0 DWIGHT WY     Berkeley 94710 37.86078535057166 -122.29004783250926
36144 36144 36144 056 193201201 1055 Dwight Way 1055 DWIGHT WAY 1055 DWIGHT WY 1055.0 DWIGHT WY     Berkeley 94710 37.86104784660169 -122.29041808752665
37122 37122 37122 056 193201201 1053 Dwight Way 1053 DWIGHT WAY 1053 DWIGHT WY 1053.0 DWIGHT WY     Berkeley 94710 37.86104784660169 -122.29041808752665
38870 38870 38870 054 178000106 1052 Dwight Way 1052 DWIGHT WAY 1052 DWIGHT WY 1052.0 DWIGHT WY     Berkeley 94710 37.86064645534095 -122.2903752540573
39675 39675 39675 056 194401801 733 Dwight Way 733 DWIGHT WAY 733 DWIGHT WY 733.0 DWIGHT WY     Berkeley 94710 37.85980924150846 -122.29664436555814
40303 40303 40303 056 193902100 917 Dwight Way 917 DWIGHT WAY 917 DWIGHT WY 917.0 DWIGHT WY     Berkeley 94710 37.86051252868903 -122.29324693625526
40422 40422 40422 056 194700101 715 Dwight Way 715 DWIGHT WAY 715 DWIGHT WY 715.0 DWIGHT WY     Berkeley 94710 37.860195603083575 -122.29807622981536
40560 40560 40560 054 177300101 800 Dwight Way Unit B57 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B57 UNIT Berkeley 94710 37.8593835074469 -122.29553191796144
41675 41675 41675 056 193902300 907 Dwight Way 907 DWIGHT WAY 907 DWIGHT WY 907.0 DWIGHT WY     Berkeley 94710 37.86040596166656 -122.29385759930732
41816 41816 41816 054 177300101 800 Dwight Way Unit B19A 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B19A UNIT Berkeley 94710 37.85948346019148 -122.29534175000566
42216 42216 42216 056 193902200 909 Dwight Way 909 DWIGHT WAY 909 DWIGHT WY 909.0 DWIGHT WY     Berkeley 94710 37.86045849554419 -122.2935573688646
42691 42691 42691 054 177300101 740 Dwight Way 740 DWIGHT WAY 740 DWIGHT WY 740.0 DWIGHT WY     Berkeley 94710 37.85937859739693 -122.29605937635692
43525 43525 43525 054 177300101 800 Dwight Way Unit B44 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B44 UNIT Berkeley 94710 37.859450059407926 -122.29550359767376
43581 43581 43581 054 177300101 800 Dwight Way Unit B49A 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B49A UNIT Berkeley 94710 37.859384658539064 -122.29582050354308
43970 43970 43970 054 177300101 800 Dwight Way Unit B47 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B47 UNIT Berkeley 94710 37.859429850415864 -122.29560152212456
44708 44708 44708 056 193902100 921 Dwight Way 921 DWIGHT WAY 921 DWIGHT WY 921.0 DWIGHT WY     Berkeley 94710 37.86051252868903 -122.29324693625526
44782 44782 44782 054 177801600 940 Dwight Way 940 DWIGHT WAY 940 DWIGHT WY 940.0 DWIGHT WY     Berkeley 94710 37.86024573849867 -122.29206670448218
44808 44808 44808 054 177300101 800 Dwight Way Unit B28A 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B28A UNIT Berkeley 94710 37.859460999382534 -122.2954505844956
45737 45737 45737 056 193902100 919 Dwight Way 919 DWIGHT WAY 919 DWIGHT WY 919.0 DWIGHT WY     Berkeley 94710 37.86051252868903 -122.29324693625526
46148 46148 46148 054 177300101 800 Dwight Way Unit B56B 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B56B UNIT Berkeley 94710 37.85939311193779 -122.29548537804315
46361 46361 46361 054 177300101 800 Dwight Way Unit B46 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B46 UNIT Berkeley 94710 37.8594404549245 -122.29555013759204
47205 47205 47205 054 177300101 800 Dwight Way Unit B66 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B66 UNIT Berkeley 94710 37.85934709945052 -122.29541444527172
49623 49623 49623 056 193602000 929 Dwight Way 929 DWIGHT WAY 929 DWIGHT WY 929.0 DWIGHT WY     Berkeley 94710 37.86060628410858 -122.2927260616125
51034 51034 51034 056 193902300 905 Dwight Way 905 DWIGHT WAY 905 DWIGHT WY 905.0 DWIGHT WY     Berkeley 94710 37.86040596166656 -122.29385759930732
52448 52448 52448 056 194401801 729 Dwight Way 729 DWIGHT WAY 729 DWIGHT WY 729.0 DWIGHT WY     Berkeley 94710 37.85978062607096 -122.29676524645602
52672 52672 52672 054 177300101 800 Dwight Way Unit B56 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B56 UNIT Berkeley 94710 37.85941504864124 -122.2953790794973
53443 53443 53443 054 177300101 800 Dwight Way Unit B62 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B62 UNIT Berkeley 94710 37.85938056056592 -122.2952523038545
53823 53823 53823 054 177900100 1000 Dwight Way 1000 DWIGHT WAY 1000 DWIGHT WY 1000.0 DWIGHT WY     Berkeley 94710 37.860511525133646 -122.291327458377
55628 55628 55628 056 193902200 913 Dwight Way 913 DWIGHT WAY 913 DWIGHT WY 913.0 DWIGHT WY     Berkeley 94710 37.86045849554419 -122.2935573688646
56318 56318 56318 054 177300101 800 Dwight Way Unit B1 800 DWIGHT WAY 800 DWIGHT WY 800.0 DWIGHT WY B1 UNIT Berkeley 94710 37.85953943593881 -122.29507050190898
56666 56666 56666 054 177801600 940 Dwight Way 15 940 DWIGHT WAY 15 940 DWIGHT WY 940.0 DWIGHT WY 15   Berkeley 94710 37.86024573849867 -122.29206670448218
57105 57105 57105 054 177900200 1034 Dwight Way 1034 DWIGHT WAY 1034 DWIGHT WY 1034.0 DWIGHT WY     Berkeley 94710 37.860527857907606 -122.29100634300228

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