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

52 rows where street_name = "ACTON" and zipcode = 94706

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94706 · 52 ✖

street_type 1

street_name 1

  • ACTON · 52 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
3582 3582 3582 060 242802300 1395 Acton St 1395 ACTON ST 1395 ACTON ST 1395.0 ACTON ST     Berkeley 94706 37.880616132743704 -122.28516443701288
3752 3752 3752 060 242701100 1356 Acton St 1356 ACTON ST 1356 ACTON ST 1356.0 ACTON ST     Berkeley 94706 37.88121154074953 -122.28567342874103
4322 4322 4322 060 242700900 1352 Acton St A 1352 ACTON ST A 1352 ACTON ST 1352.0 ACTON ST A   Berkeley 94706 37.881480526746856 -122.28571346485666
4530 4530 4530 060 242803003 1347 Acton St 1347 ACTON ST 1347 ACTON ST 1347.0 ACTON ST     Berkeley 94706 37.8813828273436 -122.28491852230552
6647 6647 6647 060 242700200 1304 Acton St 1304 ACTON ST 1304 ACTON ST 1304.0 ACTON ST     Berkeley 94706 37.88233774954005 -122.28523732002682
8941 8941 8941 060 242704100 1310 Acton St D 1310 ACTON ST D 1310 ACTON ST 1310.0 ACTON ST D   Berkeley 94706 37.88200769813643 -122.28533262499026
9350 9350 9350 060 242802500 1375 Acton St 1375 ACTON ST 1375 ACTON ST 1375.0 ACTON ST     Berkeley 94706 37.88082894796455 -122.28507942853923
9472 9472 9472 060 242703800 1310 Acton St A 1310 ACTON ST A 1310 ACTON ST 1310.0 ACTON ST A   Berkeley 94706 37.88196814688855 -122.28516759189615
9569 9569 9569 060 242704200 1310 Acton St 1310 ACTON ST 1310 ACTON ST 1310.0 ACTON ST     Berkeley 94706 37.882054417546456 -122.28545073728046
11498 11498 11498 060 242700801 1350 Acton St 1350 ACTON ST 1350 ACTON ST 1350.0 ACTON ST     Berkeley 94706 37.88156060607095 -122.28554241574508
11839 11839 11839 060 242802400 1385 Acton St 1385 ACTON ST 1385 ACTON ST 1385.0 ACTON ST     Berkeley 94706 37.880709793099584 -122.28506614694774
13037 13037 13037 060 242803004 1335 Acton St 1335 ACTON ST 1335 ACTON ST 1335.0 ACTON ST     Berkeley 94706 37.88150408054094 -122.28486792559546
14580 14580 14580 060 242701000 1354 Acton St 1354 ACTON ST 1354 ACTON ST 1354.0 ACTON ST     Berkeley 94706 37.881328201867085 -122.28562947327588
14998 14998 14998 060 242700501 1312 Acton St 1312 ACTON ST 1312 ACTON ST 1312.0 ACTON ST     Berkeley 94706 37.88187810272101 -122.28533593348548
16138 16138 16138 060 242802700 1355 Acton St 1355 ACTON ST 1355 ACTON ST 1355.0 ACTON ST     Berkeley 94706 37.88103514165885 -122.28500124636342
17312 17312 17312 060 242703900 1310 Acton St B 1310 ACTON ST B 1310 ACTON ST 1310.0 ACTON ST B   Berkeley 94706 37.88198195150524 -122.28522467354428
17448 17448 17448 060 242700801 1350 Acton St C 1350 ACTON ST C 1350 ACTON ST 1350.0 ACTON ST C   Berkeley 94706 37.88156060607095 -122.28554241574508
18429 18429 18429 060 242700900 1352 Acton St 1352 ACTON ST 1352 ACTON ST 1352.0 ACTON ST     Berkeley 94706 37.881443592936115 -122.28558542528424
19554 19554 19554 060 242802800 1353 Acton St 1353 ACTON ST 1353 ACTON ST 1353.0 ACTON ST     Berkeley 94706 37.88114709298408 -122.28496139440249
20924 20924 20924 060 242802201 1399 Acton St 1399 ACTON ST 1399 ACTON ST 1399.0 ACTON ST     Berkeley 94706 37.88048833795353 -122.28527390751002
23468 23468 23468 060 242803003 1345 Acton St 1345 ACTON ST 1345 ACTON ST 1345.0 ACTON ST     Berkeley 94706 37.8813828273436 -122.28491852230552
24414 24414 24414 060 242701300 1360 Acton St 1360 ACTON ST 1360 ACTON ST 1360.0 ACTON ST     Berkeley 94706 37.88097601855061 -122.2857612857725
24988 24988 24988 060 242803004 1337 Acton St 1337 ACTON ST 1337 ACTON ST 1337.0 ACTON ST     Berkeley 94706 37.88150408054094 -122.28486792559546
25213 25213 25213 060 242803400 1311 Acton St 1311 ACTON ST 1311 ACTON ST 1311.0 ACTON ST     Berkeley 94706 37.881968253950575 -122.2846520173136
25394 25394 25394 060 242700801 1348 Acton St B 1348 ACTON ST B 1348 ACTON ST 1348.0 ACTON ST B   Berkeley 94706 37.8816145755285 -122.28552115262232
29949 29949 29949 060 242803300 1315 Acton St 1315 ACTON ST 1315 ACTON ST 1315.0 ACTON ST     Berkeley 94706 37.88185682500394 -122.28469346737742
31944 31944 31944 060 242802800 1353 Acton St A 1353 ACTON ST A 1353 ACTON ST 1353.0 ACTON ST A   Berkeley 94706 37.881133769640904 -122.28489639590178
32242 32242 32242 060 242700801 1348 Acton St 1348 ACTON ST 1348 ACTON ST 1348.0 ACTON ST     Berkeley 94706 37.8816145755285 -122.28552115262232
33016 33016 33016 060 242800113 1303 Acton St 1303 ACTON ST 1303 ACTON ST 1303.0 ACTON ST     Berkeley 94706 37.88226875087093 -122.2845417760619
33228 33228 33228 060 242700801 1350 Acton St A 1350 ACTON ST A 1350 ACTON ST 1350.0 ACTON ST A   Berkeley 94706 37.88156060607095 -122.28554241574508
33700 33700 33700 060 242700801 1348 Acton St C 1348 ACTON ST C 1348 ACTON ST 1348.0 ACTON ST C   Berkeley 94706 37.8816145755285 -122.28552115262232
33872 33872 33872 060 242700900 1352 Acton St B 1352 ACTON ST B 1352 ACTON ST 1352.0 ACTON ST B   Berkeley 94706 37.881480526746856 -122.28571346485666
34818 34818 34818 060 242700600 1324 Acton St 1324 ACTON ST 1324 ACTON ST 1324.0 ACTON ST     Berkeley 94706 37.88178039037373 -122.28546190872932
35842 35842 35842 060 242800113 1301 Acton St 1301 ACTON ST 1301 ACTON ST 1301.0 ACTON ST     Berkeley 94706 37.88226875087093 -122.2845417760619
36436 36436 36436 060 242704000 1310 Acton St C 1310 ACTON ST C 1310 ACTON ST 1310.0 ACTON ST C   Berkeley 94706 37.881994796815654 -122.28528049934758
37256 37256 37256 060 242700600 1322 Acton St 1322 ACTON ST 1322 ACTON ST 1322.0 ACTON ST     Berkeley 94706 37.88178039037373 -122.28546190872932
37318 37318 37318 060 242803200 1321 Acton St 1321 ACTON ST 1321 ACTON ST 1321.0 ACTON ST     Berkeley 94706 37.88173571560983 -122.28473733840092
37423 37423 37423 060 242700801 1326 Acton St 1326 ACTON ST 1326 ACTON ST 1326.0 ACTON ST     Berkeley 94706 37.88167456029582 -122.28549627378052
39211 39211 39211 060 242802900 1351 Acton St 1351 ACTON ST 1351 ACTON ST 1351.0 ACTON ST     Berkeley 94706 37.88125620590502 -122.28492165113768
40504 40504 40504 060 242700801 1350 Acton St B 1350 ACTON ST B 1350 ACTON ST 1350.0 ACTON ST B   Berkeley 94706 37.88156060607095 -122.28554241574508
40524 40524 40524 060 242803100 1323 Acton St 1323 ACTON ST 1323 ACTON ST 1323.0 ACTON ST     Berkeley 94706 37.881617082634975 -122.28478385406466
43063 43063 43063 060 242701000 1354 Acton St 1 1354 ACTON ST 1 1354 ACTON ST 1354.0 ACTON ST 1   Berkeley 94706 37.88134852538798 -122.28577045128334
45442 45442 45442 060 242800112 1307 Acton St 1307 ACTON ST 1307 ACTON ST 1307.0 ACTON ST     Berkeley 94706 37.882110007458614 -122.28465709638816
45633 45633 45633 060 242700300 1308 Acton St 1308 ACTON ST 1308 ACTON ST 1308.0 ACTON ST     Berkeley 94706 37.88213495781752 -122.2853248617496
46186 46186 46186 060 242802600 1365 Acton St 1365 ACTON ST 1365 ACTON ST 1365.0 ACTON ST     Berkeley 94706 37.88092927860363 -122.2850428105133
46411 46411 46411 060 242701500 1380 Acton St 1380 ACTON ST 1380 ACTON ST 1380.0 ACTON ST     Berkeley 94706 37.88074224336176 -122.285843182482
47482 47482 47482 060 242701200 1358 Acton St 1358 ACTON ST 1358 ACTON ST 1358.0 ACTON ST     Berkeley 94706 37.88109248222235 -122.28571914220926
49862 49862 49862 060 242703600 1364 Acton St 1364 ACTON ST 1364 ACTON ST 1364.0 ACTON ST     Berkeley 94706 37.88085942706921 -122.28580102185076
54465 54465 54465 060 242803300 1317 Acton St 1317 ACTON ST 1317 ACTON ST 1317.0 ACTON ST     Berkeley 94706 37.88185682500394 -122.28469346737742
55982 55982 55982 060 242700801 1348 Acton St A 1348 ACTON ST A 1348 ACTON ST 1348.0 ACTON ST A   Berkeley 94706 37.8816145755285 -122.28552115262232
56173 56173 56173 060 242701000 1354 Acton St 2 1354 ACTON ST 2 1354 ACTON ST 1354.0 ACTON ST 2   Berkeley 94706 37.88134852538798 -122.28577045128334
57802 57802 57802 060 242703600 1362 Acton St 1362 ACTON ST 1362 ACTON ST 1362.0 ACTON ST     Berkeley 94706 37.88085942706921 -122.28580102185076

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