Master Address Table
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
42 rows where street_name = "LINCOLN" and zipcode = 94702
This data as json, CSV (advanced)
Suggested facets: unit
| Link | rowid ▼ | address_id | apn | address_full | address_normalized | base_address | street_number | street_name | street_type | unit | unit_type | city | zipcode | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 4407 | 4407 | 4407 | 058 213700500 | 1344 Lincoln St | 1344 LINCOLN ST | 1344 LINCOLN ST | 1344.0 | LINCOLN | ST | Berkeley | 94702 | 37.8748947733697 | -122.28757710705015 | ||
| 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 | ||
| 6590 | 6590 | 6590 | 058 214500600 | 1481 Lincoln St | 1481 LINCOLN ST | 1481 LINCOLN ST | 1481.0 | LINCOLN | ST | Berkeley | 94702 | 37.87597519151262 | -122.28329142539098 | ||
| 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 | |
| 12013 | 12013 | 12013 | 058 214501400 | 1431 Lincoln St | 1431 LINCOLN ST | 1431 LINCOLN ST | 1431.0 | LINCOLN | ST | Berkeley | 94702 | 37.8755334071784 | -122.28436858716334 | ||
| 15949 | 15949 | 15949 | 058 214501600 | 1411 Lincoln St | 1411 LINCOLN ST | 1411 LINCOLN ST | 1411.0 | LINCOLN | ST | Berkeley | 94702 | 37.87542937203118 | -122.28456998046688 | ||
| 16461 | 16461 | 16461 | 058 213700300 | 1320 Lincoln St | 1320 LINCOLN ST | 1320 LINCOLN ST | 1320.0 | LINCOLN | ST | Berkeley | 94702 | 37.87491044704955 | -122.2879681841175 | ||
| 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 | ||
| 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 | |
| 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 | ||
| 26429 | 26429 | 26429 | 058 214500500 | 1483 Lincoln St | 1483 LINCOLN ST | 1483 LINCOLN ST | 1483.0 | LINCOLN | ST | Berkeley | 94702 | 37.87599110392169 | -122.28314878909352 | ||
| 30125 | 30125 | 30125 | 058 214502700 | 1482 Lincoln St | 1482 LINCOLN ST | 1482 LINCOLN ST | 1482.0 | LINCOLN | ST | Berkeley | 94702 | 37.87569116212567 | -122.28318857727407 | ||
| 30897 | 30897 | 30897 | 058 214501200 | 1437 Lincoln St | 1437 LINCOLN ST | 1437 LINCOLN ST | 1437.0 | LINCOLN | ST | Berkeley | 94702 | 37.87583547401736 | -122.28430828056337 | ||
| 31071 | 31071 | 31071 | 058 214504500 | 1420 Lincoln St | 1420 LINCOLN ST | 1420 LINCOLN ST | 1420.0 | LINCOLN | ST | Berkeley | 94702 | 37.87507561470102 | -122.28435790529628 | ||
| 32698 | 32698 | 32698 | 058 213800600 | 1311 Lincoln St | 1311 LINCOLN ST | 1311 LINCOLN ST | 1311.0 | LINCOLN | ST | Berkeley | 94702 | 37.87537325519141 | -122.28802262921025 | ||
| 32789 | 32789 | 32789 | 058 214504300 | 1400 Lincoln St | 1400 LINCOLN ST | 1400 LINCOLN ST | 1400.0 | LINCOLN | ST | Berkeley | 94702 | 37.87503542651629 | -122.2846636729544 | ||
| 36216 | 36216 | 36216 | 058 214501000 | 1451 Lincoln St | 1451 LINCOLN ST | 1451 LINCOLN ST | 1451.0 | LINCOLN | ST | Berkeley | 94702 | 37.87587701752387 | -122.2838946521891 | ||
| 39457 | 39457 | 39457 | 058 213700200 | 1314 Lincoln St | 1314 LINCOLN ST | 1314 LINCOLN ST | 1314.0 | LINCOLN | ST | Berkeley | 94702 | 37.87489329350298 | -122.28809688574827 | ||
| 41208 | 41208 | 41208 | 058 213800106 | 1335 Lincoln St A | 1335 LINCOLN ST A | 1335 LINCOLN ST | 1335.0 | LINCOLN | ST | A | Berkeley | 94702 | 37.87548665810498 | -122.28740958741932 | |
| 41232 | 41232 | 41232 | 058 214501300 | 1435 Lincoln St | 1435 LINCOLN ST | 1435 LINCOLN ST | 1435.0 | LINCOLN | ST | Berkeley | 94702 | 37.875682446109494 | -122.28435815592624 | ||
| 41399 | 41399 | 41399 | 058 213800106 | 1335 Lincoln St | 1335 LINCOLN ST | 1335 LINCOLN ST | 1335.0 | LINCOLN | ST | Berkeley | 94702 | 37.87548665810498 | -122.28740958741932 | ||
| 42419 | 42419 | 42419 | 058 213700700 | 1354 Lincoln St C | 1354 LINCOLN ST C | 1354 LINCOLN ST | 1354.0 | LINCOLN | ST | C | Berkeley | 94702 | 37.87492923503926 | -122.2873180544818 | |
| 42474 | 42474 | 42474 | 058 214504700 | 1426 Lincoln St | 1426 LINCOLN ST | 1426 LINCOLN ST | 1426.0 | LINCOLN | ST | Berkeley | 94702 | 37.87511202414505 | -122.28397392851292 | ||
| 43278 | 43278 | 43278 | 058 213800400 | 1321 Lincoln St | 1321 LINCOLN ST | 1321 LINCOLN ST | 1321.0 | LINCOLN | ST | Berkeley | 94702 | 37.87540843068378 | -122.28776106495232 | ||
| 45644 | 45644 | 45644 | 058 214500700 | 1479 Lincoln St | 1479 LINCOLN ST | 1479 LINCOLN ST | 1479.0 | LINCOLN | ST | Berkeley | 94702 | 37.87596267912792 | -122.28341840045977 | ||
| 48368 | 48368 | 48368 | 058 213800300 | 1327 Lincoln St | 1327 LINCOLN ST | 1327 LINCOLN ST | 1327.0 | LINCOLN | ST | Berkeley | 94702 | 37.87542371284061 | -122.2876357841062 | ||
| 48801 | 48801 | 48801 | 058 214504400 | 1410 Lincoln St | 1410 LINCOLN ST | 1410 LINCOLN ST | 1410.0 | LINCOLN | ST | Berkeley | 94702 | 37.87505515755913 | -122.28450987149628 | ||
| 50110 | 50110 | 50110 | 058 213700600 | 1348 Lincoln St | 1348 LINCOLN ST | 1348 LINCOLN ST | 1348.0 | LINCOLN | ST | Berkeley | 94702 | 37.87491269840346 | -122.2874458560006 | ||
| 53090 | 53090 | 53090 | 058 213800500 | 1317 Lincoln St | 1317 LINCOLN ST | 1317 LINCOLN ST | 1317.0 | LINCOLN | ST | Berkeley | 94702 | 37.8753903660812 | -122.28789832303616 | ||
| 57173 | 57173 | 57173 | 058 214501101 | 1441 Lincoln St | 1441 LINCOLN ST | 1441 LINCOLN ST | 1441.0 | LINCOLN | ST | Berkeley | 94702 | 37.875913076996234 | -122.28409158445896 | ||
| 57206 | 57206 | 57206 | 058 213700400 | 1326 Lincoln St | 1326 LINCOLN ST | 1326 LINCOLN ST | 1326.0 | LINCOLN | ST | Berkeley | 94702 | 37.87487113591682 | -122.287768050252 |
Advanced export
JSON shape: default, array, newline-delimited
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);