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

101 rows where street_name = "LINCOLN" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94703 · 101 ✖

street_type 1

street_name 1

  • LINCOLN · 101 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
694 694 694 058 216200100 1726 Lincoln St 1726 LINCOLN ST 1726 LINCOLN ST 1726.0 LINCOLN ST     Berkeley 94703 37.876389948988255 -122.27672341295406
1153 1153 1153 058 215401000 1531 Lincoln St 1531 LINCOLN ST 1531 LINCOLN ST 1531.0 LINCOLN ST     Berkeley 94703 37.876226880310014 -122.28110746193347
2248 2248 2248 058 215500900 1629 Lincoln St 1629 LINCOLN ST 1629 LINCOLN ST 1629.0 LINCOLN ST     Berkeley 94703 37.87650079625739 -122.2790123319761
2606 2606 2606 058 215401700 1507 Lincoln St 1507 LINCOLN ST 1507 LINCOLN ST 1507.0 LINCOLN ST     Berkeley 94703 37.87611327999464 -122.2820212462068
2957 2957 2957 058 216200100 1726 Lincoln St 4 1726 LINCOLN ST 4 1726 LINCOLN ST 1726.0 LINCOLN ST 4   Berkeley 94703 37.876389948988255 -122.27672341295406
3203 3203 3203 058 215501500 1611 Lincoln St 1611 LINCOLN ST 1611 LINCOLN ST 1611.0 LINCOLN ST     Berkeley 94703 37.876390270907685 -122.27988296926804
3467 3467 3467 058 215401600 1511 Lincoln St 1511 LINCOLN ST 1511 LINCOLN ST 1511.0 LINCOLN ST     Berkeley 94703 37.87613202016945 -122.28186231626673
4126 4126 4126 058 216401400 1739 Lincoln St 10 1739 LINCOLN ST 10 1739 LINCOLN ST 1739.0 LINCOLN ST 10   Berkeley 94703 37.87690208201499 -122.27646540602468
5464 5464 5464 058 216100200 1710 Lincoln St 3 1710 LINCOLN ST 3 1710 LINCOLN ST 1710.0 LINCOLN ST 3   Berkeley 94703 37.87601680301175 -122.27752136665802
5767 5767 5767 058 216401400 1739 Lincoln St 1739 LINCOLN ST 1739 LINCOLN ST 1739.0 LINCOLN ST     Berkeley 94703 37.87690208201499 -122.27646540602468
6562 6562 6562 058 216301100 1711 Lincoln St B 1711 LINCOLN ST B 1711 LINCOLN ST 1711.0 LINCOLN ST B   Berkeley 94703 37.87672586263404 -122.27759347262923
6633 6633 6633 058 216301100 1707 Lincoln St B 1707 LINCOLN ST B 1707 LINCOLN ST 1707.0 LINCOLN ST B   Berkeley 94703 37.87672586263404 -122.27759347262923
6866 6866 6866 058 216100200 1710 Lincoln St 1710 LINCOLN ST 1710 LINCOLN ST 1710.0 LINCOLN ST     Berkeley 94703 37.87601680301175 -122.27752136665802
7317 7317 7317 058 215400800 1539 Lincoln St 1539 LINCOLN ST 1539 LINCOLN ST 1539.0 LINCOLN ST     Berkeley 94703 37.876214797667735 -122.2808551027123
7832 7832 7832 058 216100200 1710 Lincoln St 2 1710 LINCOLN ST 2 1710 LINCOLN ST 1710.0 LINCOLN ST 2   Berkeley 94703 37.87601680301175 -122.27752136665802
9089 9089 9089 058 216401400 1739 Lincoln St 2 1739 LINCOLN ST 2 1739 LINCOLN ST 1739.0 LINCOLN ST 2   Berkeley 94703 37.87690208201499 -122.27646540602468
9317 9317 9317 058 216401400 1739 Lincoln St C 1739 LINCOLN ST C 1739 LINCOLN ST 1739.0 LINCOLN ST C   Berkeley 94703 37.87690208201499 -122.27646540602468
9391 9391 9391 058 216100401 1716 Lincoln St 1716 LINCOLN ST 1716 LINCOLN ST 1716.0 LINCOLN ST     Berkeley 94703 37.876250708778066 -122.27733252461564
11548 11548 11548 058 215501400 1615 Lincoln St 1615 LINCOLN ST 1615 LINCOLN ST 1615.0 LINCOLN ST     Berkeley 94703 37.876409481836845 -122.27973691038932
11668 11668 11668 058 216401400 1739 Lincoln St 4 1739 LINCOLN ST 4 1739 LINCOLN ST 1739.0 LINCOLN ST 4   Berkeley 94703 37.87690208201499 -122.27646540602468
11691 11691 11691 058 216401300 1743 Lincoln St 1743 LINCOLN ST 1743 LINCOLN ST 1743.0 LINCOLN ST     Berkeley 94703 37.87677953853401 -122.27623892277524
11707 11707 11707 058 216401400 1739 Lincoln St G 1739 LINCOLN ST G 1739 LINCOLN ST 1739.0 LINCOLN ST G   Berkeley 94703 37.87690208201499 -122.27646540602468
11784 11784 11784 058 216401400 1739 Lincoln St 5 1739 LINCOLN ST 5 1739 LINCOLN ST 1739.0 LINCOLN ST 5   Berkeley 94703 37.87690208201499 -122.27646540602468
13269 13269 13269 058 215302300 1516 Lincoln St A 1516 LINCOLN ST A 1516 LINCOLN ST 1516.0 LINCOLN ST A   Berkeley 94703 37.87560277378872 -122.28173443839108
13306 13306 13306 058 215401500 1515 Lincoln St 1515 LINCOLN ST 1515 LINCOLN ST 1515.0 LINCOLN ST     Berkeley 94703 37.876147206450874 -122.28173454169732
14366 14366 14366 058 215303100 1544 Lincoln St 1544 LINCOLN ST 1544 LINCOLN ST 1544.0 LINCOLN ST     Berkeley 94703 37.87582210362323 -122.2806697587096
14579 14579 14579 058 216401400 1739 Lincoln St 9 1739 LINCOLN ST 9 1739 LINCOLN ST 1739.0 LINCOLN ST 9   Berkeley 94703 37.87690208201499 -122.27646540602468
15224 15224 15224 058 215602600 1640 Lincoln St 1640 LINCOLN ST 1640 LINCOLN ST 1640.0 LINCOLN ST     Berkeley 94703 37.875906680401414 -122.27939308919748
15312 15312 15312 058 215501600 1607 Lincoln St 1607 LINCOLN ST 1607 LINCOLN ST 1607.0 LINCOLN ST     Berkeley 94703 37.876321436135584 -122.28005483135492
15939 15939 15939 058 216401400 1739 Lincoln St 6 1739 LINCOLN ST 6 1739 LINCOLN ST 1739.0 LINCOLN ST 6   Berkeley 94703 37.87690208201499 -122.27646540602468
16191 16191 16191 058 215602300 1620 Lincoln St 1620 LINCOLN ST 1620 LINCOLN ST 1620.0 LINCOLN ST     Berkeley 94703 37.87585160130752 -122.27981714521556
16957 16957 16957 058 215302500 1526 Lincoln St 1526 LINCOLN ST 1526 LINCOLN ST 1526.0 LINCOLN ST     Berkeley 94703 37.87563731667138 -122.28146496895867
17167 17167 17167 058 215602200 1610 Lincoln St 1610 LINCOLN ST 1610 LINCOLN ST 1610.0 LINCOLN ST     Berkeley 94703 37.87595216279521 -122.28007857742114
17377 17377 17377 058 215303000 1542 Lincoln St 1542 LINCOLN ST 1542 LINCOLN ST 1542.0 LINCOLN ST     Berkeley 94703 37.87580618834134 -122.28079319890774
17624 17624 17624 058 216301000 1715 Lincoln St 1715 LINCOLN ST 1715 LINCOLN ST 1715.0 LINCOLN ST     Berkeley 94703 37.87660708402986 -122.27735931956391
18436 18436 18436 058 216100200 1708 Lincoln St 1708 LINCOLN ST 1708 LINCOLN ST 1708.0 LINCOLN ST     Berkeley 94703 37.87601680301175 -122.27752136665802
20137 20137 20137 058 216401400 1739 Lincoln St A 1739 LINCOLN ST A 1739 LINCOLN ST 1739.0 LINCOLN ST A   Berkeley 94703 37.87690208201499 -122.27646540602468
20275 20275 20275 058 215401100 1527 Lincoln St A 1527 LINCOLN ST A 1527 LINCOLN ST 1527.0 LINCOLN ST A   Berkeley 94703 37.87620882512617 -122.281244753255
20637 20637 20637 058 215501100 1623 Lincoln St 1623 LINCOLN ST 1623 LINCOLN ST 1623.0 LINCOLN ST     Berkeley 94703 37.876463243765144 -122.27930163710828
20692 20692 20692 058 215302400 1520 Lincoln St 1520 LINCOLN ST 1520 LINCOLN ST 1520.0 LINCOLN ST     Berkeley 94703 37.87562044479924 -122.28160135567668
21009 21009 21009 058 216300900 1721 Lincoln St 1721 LINCOLN ST 1721 LINCOLN ST 1721.0 LINCOLN ST     Berkeley 94703 37.87663172567969 -122.27718492153298
21475 21475 21475 058 215302100 1510 Lincoln St 1510 LINCOLN ST 1510 LINCOLN ST 1510.0 LINCOLN ST     Berkeley 94703 37.875570728275 -122.2820029924402
21612 21612 21612 058 216200100 1726 Lincoln St 3 1726 LINCOLN ST 3 1726 LINCOLN ST 1726.0 LINCOLN ST 3   Berkeley 94703 37.876389948988255 -122.27672341295406
23064 23064 23064 058 215603000 1668 Lincoln St 1668 LINCOLN ST 1668 LINCOLN ST 1668.0 LINCOLN ST     Berkeley 94703 37.87598346006623 -122.27881192412444
23072 23072 23072 058 216401200 1745 Lincoln St 1745 LINCOLN ST 1745 LINCOLN ST 1745.0 LINCOLN ST     Berkeley 94703 37.876743475940486 -122.27606351773288
23323 23323 23323 058 215602900 1660 Lincoln St 1660 LINCOLN ST 1660 LINCOLN ST 1660.0 LINCOLN ST     Berkeley 94703 37.87596083268944 -122.2789819922757
23467 23467 23467 058 215602500 1636 Lincoln St 1636 LINCOLN ST 1636 LINCOLN ST 1636.0 LINCOLN ST     Berkeley 94703 37.87588957175877 -122.27953132105507
24502 24502 24502 058 215302800 1536 Lincoln St 1536 LINCOLN ST 1536 LINCOLN ST 1536.0 LINCOLN ST     Berkeley 94703 37.87568938658845 -122.2810503353696
25026 25026 25026 058 215603200 1678 Lincoln St 1678 LINCOLN ST 1678 LINCOLN ST 1678.0 LINCOLN ST     Berkeley 94703 37.87607227268333 -122.27857575703624
25855 25855 25855 058 215500700 1635 Lincoln St 1635 LINCOLN ST 1635 LINCOLN ST 1635.0 LINCOLN ST     Berkeley 94703 37.876534604829175 -122.27872983966704
28237 28237 28237 058 215500800 1631 Lincoln St 1631 LINCOLN ST 1631 LINCOLN ST 1631.0 LINCOLN ST     Berkeley 94703 37.87651826709407 -122.27886891234772
28286 28286 28286 058 215602800 1654 Lincoln St 1654 LINCOLN ST 1654 LINCOLN ST 1654.0 LINCOLN ST     Berkeley 94703 37.87594194427381 -122.27911764776508
28599 28599 28599 058 215602200 1602 Lincoln St 1602 LINCOLN ST 1602 LINCOLN ST 1602.0 LINCOLN ST     Berkeley 94703 37.87595216279521 -122.28007857742114
30680 30680 30680 058 215602200 1606 Lincoln St 1606 LINCOLN ST 1606 LINCOLN ST 1606.0 LINCOLN ST     Berkeley 94703 37.87595216279521 -122.28007857742114
32113 32113 32113 058 216401500 1737 Lincoln St 1737 LINCOLN ST 1737 LINCOLN ST 1737.0 LINCOLN ST     Berkeley 94703 37.87674300015434 -122.27652832762044
32195 32195 32195 058 215602700 1644 Lincoln St 1644 LINCOLN ST 1644 LINCOLN ST 1644.0 LINCOLN ST     Berkeley 94703 37.87592508027129 -122.27925317928693
32776 32776 32776 058 215400900 1535 Lincoln St 1535 LINCOLN ST 1535 LINCOLN ST 1535.0 LINCOLN ST     Berkeley 94703 37.87624246010854 -122.2809796541264
33573 33573 33573 058 216401400 1739 Lincoln St H 1739 LINCOLN ST H 1739 LINCOLN ST 1739.0 LINCOLN ST H   Berkeley 94703 37.87690208201499 -122.27646540602468
34399 34399 34399 058 215500500 1647 Lincoln St 1647 LINCOLN ST 1647 LINCOLN ST 1647.0 LINCOLN ST     Berkeley 94703 37.87653286972941 -122.27838065014303
34698 34698 34698 058 215501701 1601 Lincoln St 1601 LINCOLN ST 1601 LINCOLN ST 1601.0 LINCOLN ST     Berkeley 94703 37.876298168568326 -122.28023054990932
35722 35722 35722 058 216301100 1711 Lincoln St 1711 LINCOLN ST 1711 LINCOLN ST 1711.0 LINCOLN ST     Berkeley 94703 37.87672586263404 -122.27759347262923
35825 35825 35825 058 215302300 1516 Lincoln St 1516 LINCOLN ST 1516 LINCOLN ST 1516.0 LINCOLN ST     Berkeley 94703 37.87560277378872 -122.28173443839108
36332 36332 36332 058 215302900 1540 Lincoln St 1540 LINCOLN ST 1540 LINCOLN ST 1540.0 LINCOLN ST     Berkeley 94703 37.87570579825172 -122.28091561502646
37253 37253 37253 058 215501200 1619 Lincoln St 1619 LINCOLN ST 1619 LINCOLN ST 1619.0 LINCOLN ST     Berkeley 94703 37.87644662025779 -122.27944246958866
38042 38042 38042 058 215602400 1626 Lincoln St 1626 LINCOLN ST 1626 LINCOLN ST 1626.0 LINCOLN ST     Berkeley 94703 37.87587112366265 -122.27967294854449
38278 38278 38278 058 215602200 1600 Lincoln St 1600 LINCOLN ST 1600 LINCOLN ST 1600.0 LINCOLN ST     Berkeley 94703 37.87595216279521 -122.28007857742114
38689 38689 38689 058 216401400 1739 Lincoln St 3 1739 LINCOLN ST 3 1739 LINCOLN ST 1739.0 LINCOLN ST 3   Berkeley 94703 37.87690208201499 -122.27646540602468
39060 39060 39060 058 216301100 1709 Lincoln St 1709 LINCOLN ST 1709 LINCOLN ST 1709.0 LINCOLN ST     Berkeley 94703 37.87672586263404 -122.27759347262923
39563 39563 39563 058 216301100 1707 Lincoln St A 1707 LINCOLN ST A 1707 LINCOLN ST 1707.0 LINCOLN ST A   Berkeley 94703 37.87672586263404 -122.27759347262923
39978 39978 39978 058 216200100 1726 Lincoln St 5 1726 LINCOLN ST 5 1726 LINCOLN ST 1726.0 LINCOLN ST 5   Berkeley 94703 37.876389948988255 -122.27672341295406
40943 40943 40943 058 215302200 1514 Lincoln St 1514 LINCOLN ST 1514 LINCOLN ST 1514.0 LINCOLN ST     Berkeley 94703 37.8755870045302 -122.281868240656
41668 41668 41668 058 216401400 1739 Lincoln St 7 1739 LINCOLN ST 7 1739 LINCOLN ST 1739.0 LINCOLN ST 7   Berkeley 94703 37.87690208201499 -122.27646540602468
42847 42847 42847 058 216100200 1710 Lincoln St 1 1710 LINCOLN ST 1 1710 LINCOLN ST 1710.0 LINCOLN ST 1   Berkeley 94703 37.87601680301175 -122.27752136665802
43263 43263 43263 058 215302700 1532 Lincoln St 1532 LINCOLN ST 1532 LINCOLN ST 1532.0 LINCOLN ST     Berkeley 94703 37.87567204248059 -122.28119116605332
43935 43935 43935 058 215401100 1527 Lincoln St 1527 LINCOLN ST 1527 LINCOLN ST 1527.0 LINCOLN ST     Berkeley 94703 37.87620882512617 -122.281244753255
44940 44940 44940 058 216200300 1736 Lincoln St 1736 LINCOLN ST 1736 LINCOLN ST 1736.0 LINCOLN ST     Berkeley 94703 37.87632470284072 -122.27635190838012
45102 45102 45102 058 215500600 1639 Lincoln St 1639 LINCOLN ST 1639 LINCOLN ST 1639.0 LINCOLN ST     Berkeley 94703 37.87650669077732 -122.27858099601096
46006 46006 46006 058 215302600 1530 Lincoln St 1530 LINCOLN ST 1530 LINCOLN ST 1530.0 LINCOLN ST     Berkeley 94703 37.875656270400576 -122.28132764799275
46775 46775 46775 058 216301200 1701 Lincoln St 1701 LINCOLN ST 1701 LINCOLN ST 1701.0 LINCOLN ST     Berkeley 94703 37.87650794867192 -122.27786456980894
46971 46971 46971 058 216301100 1711 Lincoln St A 1711 LINCOLN ST A 1711 LINCOLN ST 1711.0 LINCOLN ST A   Berkeley 94703 37.87672586263404 -122.27759347262923
47240 47240 47240 058 216401400 1739 Lincoln St 1 1739 LINCOLN ST 1 1739 LINCOLN ST 1739.0 LINCOLN ST 1   Berkeley 94703 37.87690208201499 -122.27646540602468
47257 47257 47257 058 216200100 1726 Lincoln St 2 1726 LINCOLN ST 2 1726 LINCOLN ST 1726.0 LINCOLN ST 2   Berkeley 94703 37.876389948988255 -122.27672341295406
48893 48893 48893 058 215500500 1641 Lincoln St 1641 LINCOLN ST 1641 LINCOLN ST 1641.0 LINCOLN ST     Berkeley 94703 37.87653286972941 -122.27838065014303
49118 49118 49118 058 215603200 1676 Lincoln St 1676 LINCOLN ST 1676 LINCOLN ST 1676.0 LINCOLN ST     Berkeley 94703 37.87607227268333 -122.27857575703624
49391 49391 49391 058 216401400 1739 Lincoln St E 1739 LINCOLN ST E 1739 LINCOLN ST 1739.0 LINCOLN ST E   Berkeley 94703 37.87690208201499 -122.27646540602468
49679 49679 49679 058 216401400 1739 Lincoln St 8 1739 LINCOLN ST 8 1739 LINCOLN ST 1739.0 LINCOLN ST 8   Berkeley 94703 37.87690208201499 -122.27646540602468
50142 50142 50142 058 215401300 1521 Lincoln St 1521 LINCOLN ST 1521 LINCOLN ST 1521.0 LINCOLN ST     Berkeley 94703 37.87617736415441 -122.28149611893949
50568 50568 50568 058 215603100 1672 Lincoln St 1672 LINCOLN ST 1672 LINCOLN ST 1672.0 LINCOLN ST     Berkeley 94703 37.87600190175251 -122.27867371652133
50651 50651 50651 058 215500800 1633 Lincoln St 1633 LINCOLN ST 1633 LINCOLN ST 1633.0 LINCOLN ST     Berkeley 94703 37.87651826709407 -122.27886891234772
51308 51308 51308 058 216301100 1707 Lincoln St 1707 LINCOLN ST 1707 LINCOLN ST 1707.0 LINCOLN ST     Berkeley 94703 37.87672586263404 -122.27759347262923
52402 52402 52402 058 215501000 1625 Lincoln St 1625 LINCOLN ST 1625 LINCOLN ST 1625.0 LINCOLN ST     Berkeley 94703 37.87648127336005 -122.2791660382128
52623 52623 52623 058 215501300 1617 Lincoln St 1617 LINCOLN ST 1617 LINCOLN ST 1617.0 LINCOLN ST     Berkeley 94703 37.876428681415774 -122.27958496934218
52680 52680 52680 058 216100300 1712 Lincoln St 1712 LINCOLN ST 1712 LINCOLN ST 1712.0 LINCOLN ST     Berkeley 94703 37.87620917611845 -122.2774641260081
52907 52907 52907 058 215602200 1608 Lincoln St 1608 LINCOLN ST 1608 LINCOLN ST 1608.0 LINCOLN ST     Berkeley 94703 37.87595216279521 -122.28007857742114
53320 53320 53320 058 216200100 1726 Lincoln St 1 1726 LINCOLN ST 1 1726 LINCOLN ST 1726.0 LINCOLN ST 1   Berkeley 94703 37.876389948988255 -122.27672341295406
53483 53483 53483 058 215602200 1612 Lincoln St 1612 LINCOLN ST 1612 LINCOLN ST 1612.0 LINCOLN ST     Berkeley 94703 37.87595216279521 -122.28007857742114
53681 53681 53681 058 215401400 1517 Lincoln St 1517 LINCOLN ST 1517 LINCOLN ST 1517.0 LINCOLN ST     Berkeley 94703 37.87616330176438 -122.28161271128018
54045 54045 54045 058 215602200 1604 Lincoln St 1604 LINCOLN ST 1604 LINCOLN ST 1604.0 LINCOLN ST     Berkeley 94703 37.87595216279521 -122.28007857742114
55706 55706 55706 058 215401200 1525 Lincoln St 1525 LINCOLN ST 1525 LINCOLN ST 1525.0 LINCOLN ST     Berkeley 94703 37.87619243130179 -122.2813725934014
56339 56339 56339 058 216200200 1734 Lincoln St 1734 LINCOLN ST 1734 LINCOLN ST 1734.0 LINCOLN ST     Berkeley 94703 37.876309132277555 -122.27647888165228

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