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

178 rows where street_name = "LINCOLN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 3

street_type 1

street_name 1

  • LINCOLN · 178 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
540 540 540 058 217301300 2013 Lincoln St 4 2013 LINCOLN ST 4 2013 LINCOLN ST 2013.0 LINCOLN ST 4   Berkeley 94709 37.87756144913377 -122.27070964308116
694 694 694 058 216200100 1726 Lincoln St 1726 LINCOLN ST 1726 LINCOLN ST 1726.0 LINCOLN ST     Berkeley 94703 37.876389948988255 -122.27672341295406
790 790 790 058 214504600 1424 Lincoln St 1424 LINCOLN ST 1424 LINCOLN ST 1424.0 LINCOLN ST     Berkeley 94702 37.87509441399395 -122.28417663066185
893 893 893 058 213700400 1336 Lincoln St 1336 LINCOLN ST 1336 LINCOLN ST 1336.0 LINCOLN ST     Berkeley 94702 37.87487113591682 -122.287768050252
1153 1153 1153 058 215401000 1531 Lincoln St 1531 LINCOLN ST 1531 LINCOLN ST 1531.0 LINCOLN ST     Berkeley 94703 37.876226880310014 -122.28110746193347
1232 1232 1232 058 217301200 2017 Lincoln St 2017 LINCOLN ST 2017 LINCOLN ST 2017.0 LINCOLN ST     Berkeley 94709 37.87758520839109 -122.27052909698044
2248 2248 2248 058 215500900 1629 Lincoln St 1629 LINCOLN ST 1629 LINCOLN ST 1629.0 LINCOLN ST     Berkeley 94703 37.87650079625739 -122.2790123319761
2355 2355 2355 058 214504800 1428 Lincoln St 1428 LINCOLN ST 1428 LINCOLN ST 1428.0 LINCOLN ST     Berkeley 94702 37.87527695451039 -122.2839196783546
2419 2419 2419 058 214505000 1440 Lincoln St 1440 LINCOLN ST 1440 LINCOLN ST 1440.0 LINCOLN ST     Berkeley 94702 37.875546125978815 -122.28391035024868
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
3478 3478 3478 058 217300600 2043 Lincoln St 2043 LINCOLN ST 2043 LINCOLN ST 2043.0 LINCOLN ST     Berkeley 94709 37.877729401704315 -122.2694098482387
3952 3952 3952 058 217301300 2013 Lincoln St 5 2013 LINCOLN ST 5 2013 LINCOLN ST 2013.0 LINCOLN ST 5   Berkeley 94709 37.87756144913377 -122.27070964308116
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
4407 4407 4407 058 213700500 1344 Lincoln St 1344 LINCOLN ST 1344 LINCOLN ST 1344.0 LINCOLN ST     Berkeley 94702 37.8748947733697 -122.28757710705015
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
6276 6276 6276 058 214501500 1421 Lincoln St 1421 LINCOLN ST 1421 LINCOLN ST 1421.0 LINCOLN ST     Berkeley 94702 37.87540386915225 -122.28435295018916
6309 6309 6309 058 213800700 1305 Lincoln St 1305 LINCOLN ST 1305 LINCOLN ST 1305.0 LINCOLN ST     Berkeley 94702 37.87535603438968 -122.28814962404196
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
6590 6590 6590 058 214500600 1481 Lincoln St 1481 LINCOLN ST 1481 LINCOLN ST 1481.0 LINCOLN ST     Berkeley 94702 37.87597519151262 -122.28329142539098
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
6907 6907 6907 058 213700700 1354 Lincoln St B 1354 LINCOLN ST B 1354 LINCOLN ST 1354.0 LINCOLN ST B   Berkeley 94702 37.87492923503926 -122.2873180544818
6991 6991 6991 058 214505100 1460 Lincoln St 1460 LINCOLN ST 1460 LINCOLN ST 1460.0 LINCOLN ST     Berkeley 94702 37.8755866209172 -122.28364588443242
7223 7223 7223 058 213800106 1335 Lincoln St B 1335 LINCOLN ST B 1335 LINCOLN ST 1335.0 LINCOLN ST B   Berkeley 94702 37.87548665810498 -122.28740958741932
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
10344 10344 10344 058 217301500 2005 Lincoln St 2005 LINCOLN ST 2005 LINCOLN ST 2005.0 LINCOLN ST     Berkeley 94709 37.87752138568216 -122.2710135961424
11158 11158 11158 058 217301600 2001 Lincoln St 2001 LINCOLN ST 2001 LINCOLN ST 2001.0 LINCOLN ST     Berkeley 94709 37.87750342795719 -122.27115266792478
11204 11204 11204 058 217300800 2037 Lincoln St A 2037 LINCOLN ST A 2037 LINCOLN ST 2037.0 LINCOLN ST A   Berkeley 94709 37.8776878748419 -122.26974927397384
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
12013 12013 12013 058 214501400 1431 Lincoln St 1431 LINCOLN ST 1431 LINCOLN ST 1431.0 LINCOLN ST     Berkeley 94702 37.8755334071784 -122.28436858716334
12977 12977 12977 058 217301000 2025 Lincoln St 2025 LINCOLN ST 2025 LINCOLN ST 2025.0 LINCOLN ST     Berkeley 94709 37.87763015015262 -122.2701698553084
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
15831 15831 15831 058 217300701 2039 Lincoln St A 2039 LINCOLN ST A 2039 LINCOLN ST 2039.0 LINCOLN ST A   Berkeley 94709 37.877674279302504 -122.26954542467632
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
15949 15949 15949 058 214501600 1411 Lincoln St 1411 LINCOLN ST 1411 LINCOLN ST 1411.0 LINCOLN ST     Berkeley 94702 37.87542937203118 -122.28456998046688
16191 16191 16191 058 215602300 1620 Lincoln St 1620 LINCOLN ST 1620 LINCOLN ST 1620.0 LINCOLN ST     Berkeley 94703 37.87585160130752 -122.27981714521556
16461 16461 16461 058 213700300 1320 Lincoln St 1320 LINCOLN ST 1320 LINCOLN ST 1320.0 LINCOLN ST     Berkeley 94702 37.87491044704955 -122.2879681841175
16957 16957 16957 058 215302500 1526 Lincoln St 1526 LINCOLN ST 1526 LINCOLN ST 1526.0 LINCOLN ST     Berkeley 94703 37.87563731667138 -122.28146496895867
17105 17105 17105 058 217303900 2011 Lincoln St C 2011 LINCOLN ST C 2011 LINCOLN ST 2011.0 LINCOLN ST C   Berkeley 94709 37.877539309367755 -122.27087285888346
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
17403 17403 17403 058 217301300 2013 Lincoln St 2 2013 LINCOLN ST 2 2013 LINCOLN ST 2013.0 LINCOLN ST 2   Berkeley 94709 37.87756144913377 -122.27070964308116
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
18543 18543 18543 058 217300701 2041 Lincoln St 2041 LINCOLN ST 2041 LINCOLN ST 2041.0 LINCOLN ST     Berkeley 94709 37.877674279302504 -122.26954542467632
18570 18570 18570 058 214504900 1430 Lincoln St 1430 LINCOLN ST 1430 LINCOLN ST 1430.0 LINCOLN ST     Berkeley 94702 37.87542383196655 -122.28389774508864
19363 19363 19363 058 213700700 1354 Lincoln St 1354 LINCOLN ST 1354 LINCOLN ST 1354.0 LINCOLN ST     Berkeley 94702 37.87492923503926 -122.2873180544818
19441 19441 19441 058 214501700 1401 Lincoln St 1401 LINCOLN ST 1401 LINCOLN ST 1401.0 LINCOLN ST     Berkeley 94702 37.875408111596435 -122.28471245506756
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
22186 22186 22186 058 214500800 1471 Lincoln St 1471 LINCOLN ST 1471 LINCOLN ST 1471.0 LINCOLN ST     Berkeley 94702 37.87593159386242 -122.28358236186374
22587 22587 22587 058 213700700 1354 Lincoln St A 1354 LINCOLN ST A 1354 LINCOLN ST 1354.0 LINCOLN ST A   Berkeley 94702 37.87492923503926 -122.2873180544818
22868 22868 22868 058 217301200 2019 Lincoln St 2019 LINCOLN ST 2019 LINCOLN ST 2019.0 LINCOLN ST     Berkeley 94709 37.87758520839109 -122.27052909698044
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
23515 23515 23515 058 217301300 2013 Lincoln St 3 2013 LINCOLN ST 3 2013 LINCOLN ST 2013.0 LINCOLN ST 3   Berkeley 94709 37.87756144913377 -122.27070964308116
23932 23932 23932 058 217301300 2013 Lincoln St 1 2013 LINCOLN ST 1 2013 LINCOLN ST 2013.0 LINCOLN ST 1   Berkeley 94709 37.87756144913377 -122.27070964308116
23946 23946 23946 058 213800200 1333 Lincoln St 1333 LINCOLN ST 1333 LINCOLN ST 1333.0 LINCOLN ST     Berkeley 94702 37.875439914674544 -122.28750450790382
24438 24438 24438 058 214500900 1461 Lincoln St 1461 LINCOLN ST 1461 LINCOLN ST 1461.0 LINCOLN ST     Berkeley 94702 37.87590359803804 -122.28374200686277
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
25851 25851 25851 058 217303500 2023 Lincoln St A & B 2023 LINCOLN ST A & B 2023 LINCOLN ST 2023.0 LINCOLN ST A & B   Berkeley 94709 37.87760812740243 -122.27034946626294
25855 25855 25855 058 215500700 1635 Lincoln St 1635 LINCOLN ST 1635 LINCOLN ST 1635.0 LINCOLN ST     Berkeley 94703 37.876534604829175 -122.27872983966704
26429 26429 26429 058 214500500 1483 Lincoln St 1483 LINCOLN ST 1483 LINCOLN ST 1483.0 LINCOLN ST     Berkeley 94702 37.87599110392169 -122.28314878909352
26771 26771 26771 058 217301300 2013 Lincoln St 2013 LINCOLN ST 2013 LINCOLN ST 2013.0 LINCOLN ST     Berkeley 94709 37.87756144913377 -122.27070964308116
27313 27313 27313 058 217303500 2021 Lincoln St B 2021 LINCOLN ST B 2021 LINCOLN ST 2021.0 LINCOLN ST B   Berkeley 94709 37.87760812740243 -122.27034946626294
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
30125 30125 30125 058 214502700 1482 Lincoln St 1482 LINCOLN ST 1482 LINCOLN ST 1482.0 LINCOLN ST     Berkeley 94702 37.87569116212567 -122.28318857727407
30501 30501 30501 058 217300701 2041 Lincoln St B 2041 LINCOLN ST B 2041 LINCOLN ST 2041.0 LINCOLN ST B   Berkeley 94709 37.877674279302504 -122.26954542467632
30680 30680 30680 058 215602200 1606 Lincoln St 1606 LINCOLN ST 1606 LINCOLN ST 1606.0 LINCOLN ST     Berkeley 94703 37.87595216279521 -122.28007857742114
30897 30897 30897 058 214501200 1437 Lincoln St 1437 LINCOLN ST 1437 LINCOLN ST 1437.0 LINCOLN ST     Berkeley 94702 37.87583547401736 -122.28430828056337
31005 31005 31005 058 217303900 2011 Lincoln St A 2011 LINCOLN ST A 2011 LINCOLN ST 2011.0 LINCOLN ST A   Berkeley 94709 37.877539309367755 -122.27087285888346
31071 31071 31071 058 214504500 1420 Lincoln St 1420 LINCOLN ST 1420 LINCOLN ST 1420.0 LINCOLN ST     Berkeley 94702 37.87507561470102 -122.28435790529628
31322 31322 31322 058 217300900 2031 Lincoln St 2031 LINCOLN ST 2031 LINCOLN ST 2031.0 LINCOLN ST     Berkeley 94709 37.87765609826047 -122.26997547874554

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