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

42 rows where street_name = "LINCOLN" and zipcode = 94702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94702 · 42 ✖

street_type 1

street_name 1

  • LINCOLN · 42 ✖
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

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