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

203 rows where street_name = "ARCH" and zipcode = 94708

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94708 · 203 ✖

street_type 1

street_name 1

  • ARCH · 203 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
103 103 103 059 225500900 1530 Arch St 1 1530 ARCH ST 1 1530 ARCH ST 1530.0 ARCH ST 1   Berkeley 94708 37.87961315060466 -122.26502241620392
109 109 109 060 246200901 1340 Arch St 1340 ARCH ST 1340 ARCH ST 1340.0 ARCH ST     Berkeley 94708 37.88286146119953 -122.265300429513
275 275 275 059 225501100 1546 Arch St 1546 ARCH ST 1546 ARCH ST 1546.0 ARCH ST     Berkeley 94708 37.87928364146482 -122.26498339608293
611 611 611 059 225400600 1408 Arch St 1408 ARCH ST 1408 ARCH ST 1408.0 ARCH ST     Berkeley 94708 37.882209215395704 -122.2653195842898
964 964 964 060 246502800 1321 Arch St 1321 ARCH ST 1321 ARCH ST 1321.0 ARCH ST     Berkeley 94708 37.8837292398632 -122.26486480858397
1858 1858 1858 059 225500900 1530 Arch St 3 1530 ARCH ST 3 1530 ARCH ST 1530.0 ARCH ST 3   Berkeley 94708 37.87961315060466 -122.26502241620392
1931 1931 1931 059 225203600 1581 Arch St A 1581 ARCH ST A 1581 ARCH ST 1581.0 ARCH ST A   Berkeley 94708 37.87938063106263 -122.26433420967824
2402 2402 2402 060 246200400 1314 Arch St A 1314 ARCH ST A 1314 ARCH ST 1314.0 ARCH ST A   Berkeley 94708 37.883804006315515 -122.26548341364143
2875 2875 2875 059 225202000 1525 Arch St 7 1525 ARCH ST 7 1525 ARCH ST 1525.0 ARCH ST 7   Berkeley 94708 37.879873801292504 -122.26437627508804
2880 2880 2880 061 255601400 1172 Arch St 1172 ARCH ST 1172 ARCH ST 1172.0 ARCH ST     Berkeley 94708 37.88701607308611 -122.26588486445372
2972 2972 2972 061 255601700 1188 Arch St 1188 ARCH ST 1188 ARCH ST 1188.0 ARCH ST     Berkeley 94708 37.88663041507134 -122.2658418827623
4226 4226 4226 059 225202400 1509 Arch St A 1509 ARCH ST A 1509 ARCH ST 1509.0 ARCH ST A   Berkeley 94708 37.88042913995771 -122.26444578223315
4415 4415 4415 061 255604600 1176 Arch St 1176 ARCH ST 1176 ARCH ST 1176.0 ARCH ST     Berkeley 94708 37.886874618991435 -122.26586763925812
4622 4622 4622 061 255601400 1174 Arch St 1174 ARCH ST 1174 ARCH ST 1174.0 ARCH ST     Berkeley 94708 37.88701607308611 -122.26588486445372
5125 5125 5125 059 225400704 1410 Arch St 2 1410 ARCH ST 2 1410 ARCH ST 1410.0 ARCH ST 2   Berkeley 94708 37.88207032013402 -122.26530873264116
5347 5347 5347 059 225300101 1345 Arch St 1345 ARCH ST 1345 ARCH ST 1345.0 ARCH ST     Berkeley 94708 37.88289528174097 -122.2647748198504
5368 5368 5368 059 225202000 1525 Arch St 1 1525 ARCH ST 1 1525 ARCH ST 1525.0 ARCH ST 1   Berkeley 94708 37.879873801292504 -122.26437627508804
5780 5780 5780 059 225201800 1567 Arch St 1567 ARCH ST 1567 ARCH ST 1567.0 ARCH ST     Berkeley 94708 37.87955591595493 -122.26431848826248
5968 5968 5968 061 255600400 1126 Arch St 1126 ARCH ST 1126 ARCH ST 1126.0 ARCH ST     Berkeley 94708 37.888339354756134 -122.26602204797736
6082 6082 6082 059 225500900 1530 Arch St 1530 ARCH ST 1530 ARCH ST 1530.0 ARCH ST     Berkeley 94708 37.87961315060466 -122.26502241620392
6195 6195 6195 059 225401200 1434 Arch St B 1434 ARCH ST B 1434 ARCH ST 1434.0 ARCH ST B   Berkeley 94708 37.881403277764946 -122.2652304875833
6487 6487 6487 061 255402000 1171 Arch St 1171 ARCH ST 1171 ARCH ST 1171.0 ARCH ST     Berkeley 94708 37.88723137814623 -122.26518295323004
6497 6497 6497 059 225401200 1432 Arch St D 1432 ARCH ST D 1432 ARCH ST 1432.0 ARCH ST D   Berkeley 94708 37.881403277764946 -122.2652304875833
6661 6661 6661 059 225304304 1415 Arch St 2 1415 ARCH ST 2 1415 ARCH ST 1415.0 ARCH ST 2   Berkeley 94708 37.88210673604689 -122.26470574030334
6688 6688 6688 059 225401200 1434 Arch St A 1434 ARCH ST A 1434 ARCH ST 1434.0 ARCH ST A   Berkeley 94708 37.881403277764946 -122.2652304875833
6855 6855 6855 061 255401900 1175 Arch St 1175 ARCH ST 1175 ARCH ST 1175.0 ARCH ST     Berkeley 94708 37.887090476044285 -122.26521335221926
7005 7005 7005 059 225400900 1422 Arch St 1422 ARCH ST 1422 ARCH ST 1422.0 ARCH ST     Berkeley 94708 37.881735955968345 -122.2652696190954
7150 7150 7150 059 225202200 1515 Arch St 1515 ARCH ST 1515 ARCH ST 1515.0 ARCH ST     Berkeley 94708 37.88016436960152 -122.26441440048704
7247 7247 7247 059 225202400 1509 Arch St 1509 ARCH ST 1509 ARCH ST 1509.0 ARCH ST     Berkeley 94708 37.88042913995771 -122.26444578223315
7609 7609 7609 061 255600300 1124 Arch St 1124 ARCH ST 1124 ARCH ST 1124.0 ARCH ST     Berkeley 94708 37.88849509081464 -122.26603330835944
7643 7643 7643 059 225500700 1524 Arch St 1524 ARCH ST 1524 ARCH ST 1524.0 ARCH ST     Berkeley 94708 37.87991786882981 -122.26501326955773
7669 7669 7669 059 225500500 1514 Arch St 1514 ARCH ST 1514 ARCH ST 1514.0 ARCH ST     Berkeley 94708 37.88013702982753 -122.26504183239048
7820 7820 7820 060 246502600 1329 Arch St 1329 ARCH ST 1329 ARCH ST 1329.0 ARCH ST     Berkeley 94708 37.88343193517437 -122.26478926655678
8049 8049 8049 059 225201800 1577 Arch St 1577 ARCH ST 1577 ARCH ST 1577.0 ARCH ST     Berkeley 94708 37.87955591595493 -122.26431848826248
8344 8344 8344 061 255400100 1159 Arch St 1159 ARCH ST 1159 ARCH ST 1159.0 ARCH ST     Berkeley 94708 37.88748516034239 -122.26532844437348
8482 8482 8482 059 225303800 1431 Arch St 1431 ARCH ST 1431 ARCH ST 1431.0 ARCH ST     Berkeley 94708 37.88161165009822 -122.26456661192708
8496 8496 8496 059 225201800 1565 Arch St 1565 ARCH ST 1565 ARCH ST 1565.0 ARCH ST     Berkeley 94708 37.87955591595493 -122.26431848826248
8538 8538 8538 059 225305401 1403 Arch St B 1403 ARCH ST B 1403 ARCH ST 1403.0 ARCH ST B   Berkeley 94708 37.88263461196764 -122.2643829244178
8669 8669 8669 061 255601200 1168 Arch St 1168 ARCH ST 1168 ARCH ST 1168.0 ARCH ST     Berkeley 94708 37.8872742771542 -122.26591442351814
8844 8844 8844 059 225202100 1519 Arch St 1519 ARCH ST 1519 ARCH ST 1519.0 ARCH ST     Berkeley 94708 37.88002710623552 -122.26439631021384
9456 9456 9456 059 225305300 1401 Arch St 1401 ARCH ST 1401 ARCH ST 1401.0 ARCH ST     Berkeley 94708 37.88258700736717 -122.26472643389424
10059 10059 10059 060 246200805 1328 Arch St 1328 ARCH ST 1328 ARCH ST 1328.0 ARCH ST     Berkeley 94708 37.88315403839576 -122.26540938886876
10095 10095 10095 060 246200805 1334 Arch St 1334 ARCH ST 1334 ARCH ST 1334.0 ARCH ST     Berkeley 94708 37.88315403839576 -122.26540938886876
10299 10299 10299 059 225202400 1509 Arch St B 1509 ARCH ST B 1509 ARCH ST 1509.0 ARCH ST B   Berkeley 94708 37.88042913995771 -122.26444578223315
10315 10315 10315 059 225500800 1526 Arch St 3 1526 ARCH ST 3 1526 ARCH ST 1526.0 ARCH ST 3   Berkeley 94708 37.879773837207864 -122.26503841160589
10852 10852 10852 059 225500202 1500 Arch St 1500 ARCH ST 1500 ARCH ST 1500.0 ARCH ST     Berkeley 94708 37.88061675669269 -122.2650697169952
10927 10927 10927 059 225303700 1435 Arch St 1435 ARCH ST 1435 ARCH ST 1435.0 ARCH ST     Berkeley 94708 37.88149731148474 -122.26461674061488
10945 10945 10945 059 225305900 1411 Arch St 2 1411 ARCH ST 2 1411 ARCH ST 1411.0 ARCH ST 2   Berkeley 94708 37.88231274323754 -122.26463616578457
11876 11876 11876 059 225500800 1526 Arch St 9 1526 ARCH ST 9 1526 ARCH ST 1526.0 ARCH ST 9   Berkeley 94708 37.879773837207864 -122.26503841160589
12445 12445 12445 059 225500600 1520 Arch St 1520 ARCH ST 1520 ARCH ST 1520.0 ARCH ST     Berkeley 94708 37.88002914897571 -122.26502535818648
12705 12705 12705 060 246200700 1326 Arch St 1326 ARCH ST 1326 ARCH ST 1326.0 ARCH ST     Berkeley 94708 37.883322651061206 -122.26542870624064
13199 13199 13199 061 255604600 1178 Arch St 1178 ARCH ST 1178 ARCH ST 1178.0 ARCH ST     Berkeley 94708 37.886874618991435 -122.26586763925812
13237 13237 13237 061 255500700 1101 Arch St 1101 ARCH ST 1101 ARCH ST 1101.0 ARCH ST     Berkeley 94708 37.88893961690811 -122.26637317067583
13399 13399 13399 061 255500600 1115 Arch St 1115 ARCH ST 1115 ARCH ST 1115.0 ARCH ST     Berkeley 94708 37.88900341908809 -122.2659691408004
13760 13760 13760 059 225401301 1440 Arch St 1440 ARCH ST 1440 ARCH ST 1440.0 ARCH ST     Berkeley 94708 37.88125907817247 -122.26521539049664
14182 14182 14182 061 255600600 1136 Arch St 1136 ARCH ST 1136 ARCH ST 1136.0 ARCH ST     Berkeley 94708 37.88810033323529 -122.26603347724271
14262 14262 14262 059 225401100 1430 Arch St 2 1430 ARCH ST 2 1430 ARCH ST 1430.0 ARCH ST 2   Berkeley 94708 37.88154076687194 -122.26524591974156
14637 14637 14637 059 225401302 1438 Arch St Down 1438 ARCH ST DOWN 1438 ARCH ST 1438.0 ARCH ST DOWN   Berkeley 94708 37.881157073968176 -122.2651492798816
14877 14877 14877 059 225500800 1526 Arch St 5 1526 ARCH ST 5 1526 ARCH ST 1526.0 ARCH ST 5   Berkeley 94708 37.879773837207864 -122.26503841160589
14899 14899 14899 059 225304502 1407 Arch St 1407 ARCH ST 1407 ARCH ST 1407.0 ARCH ST     Berkeley 94708 37.882471430909646 -122.26457323969726
15398 15398 15398 059 225203600 1583 Arch St A 1583 ARCH ST A 1583 ARCH ST 1583.0 ARCH ST A   Berkeley 94708 37.87938063106263 -122.26433420967824
15953 15953 15953 059 225401302 1438 Arch St 1438 ARCH ST 1438 ARCH ST 1438.0 ARCH ST     Berkeley 94708 37.881157073968176 -122.2651492798816
16170 16170 16170 059 225303900 1425 Arch St 1425 ARCH ST 1425 ARCH ST 1425.0 ARCH ST     Berkeley 94708 37.881728470111995 -122.26456420983202
16493 16493 16493 059 225305300 1401 Arch St 2 1401 ARCH ST 2 1401 ARCH ST 1401.0 ARCH ST 2   Berkeley 94708 37.88258700736717 -122.26472643389424
16881 16881 16881 060 246200300 1308 Arch St 2 1308 ARCH ST 2 1308 ARCH ST 1308.0 ARCH ST 2   Berkeley 94708 37.8840029981634 -122.26550571072508
16885 16885 16885 059 225202000 1525 Arch St 1525 ARCH ST 1525 ARCH ST 1525.0 ARCH ST     Berkeley 94708 37.879873801292504 -122.26437627508804
17245 17245 17245 059 225401400 1490 Arch St 1490 ARCH ST 1490 ARCH ST 1490.0 ARCH ST     Berkeley 94708 37.880981921220744 -122.26502465660224
17529 17529 17529 059 225500900 1530 Arch St 4 1530 ARCH ST 4 1530 ARCH ST 1530.0 ARCH ST 4   Berkeley 94708 37.87961315060466 -122.26502241620392
17649 17649 17649 060 246502800 1323 Arch St 1323 ARCH ST 1323 ARCH ST 1323.0 ARCH ST     Berkeley 94708 37.8837292398632 -122.26486480858397
17690 17690 17690 060 246502600 1329 Arch St B 1329 ARCH ST B 1329 ARCH ST 1329.0 ARCH ST B   Berkeley 94708 37.88343193517437 -122.26478926655678
17844 17844 17844 059 225500800 1526 Arch St 4 1526 ARCH ST 4 1526 ARCH ST 1526.0 ARCH ST 4   Berkeley 94708 37.879773837207864 -122.26503841160589
18079 18079 18079 060 246503300 1303 Arch St 1303 ARCH ST 1303 ARCH ST 1303.0 ARCH ST     Berkeley 94708 37.884412006558854 -122.26487363183668
18110 18110 18110 061 255601200 1166 Arch St 1166 ARCH ST 1166 ARCH ST 1166.0 ARCH ST     Berkeley 94708 37.8872742771542 -122.26591442351814
18659 18659 18659 061 255200100 1135 Arch St 1135 ARCH ST 1135 ARCH ST 1135.0 ARCH ST     Berkeley 94708 37.88835884189816 -122.26550749567758
18910 18910 18910 060 246502500 1331 Arch St 1331 ARCH ST 1331 ARCH ST 1331.0 ARCH ST     Berkeley 94708 37.8832889767715 -122.26482656909894
19292 19292 19292 061 255500300 1127 Arch St 1127 ARCH ST 1127 ARCH ST 1127.0 ARCH ST     Berkeley 94708 37.88863346776424 -122.2653262497892
20075 20075 20075 059 225204500 1557 Arch St 1557 ARCH ST 1557 ARCH ST 1557.0 ARCH ST     Berkeley 94708 37.87971124374642 -122.26435588512771
20176 20176 20176 059 225305401 1403 Arch St A 1403 ARCH ST A 1403 ARCH ST 1403.0 ARCH ST A   Berkeley 94708 37.88263461196764 -122.2643829244178
20603 20603 20603 059 225401200 1432 Arch St G 1432 ARCH ST G 1432 ARCH ST 1432.0 ARCH ST G   Berkeley 94708 37.881403277764946 -122.2652304875833
20722 20722 20722 059 225202300 1511 Arch St 9847 1511 ARCH ST 9847 1511 ARCH ST 1511.0 ARCH ST 9847   Berkeley 94708 37.8802982966974 -122.26442968172832
20734 20734 20734 059 225500800 1526 Arch St 10 1526 ARCH ST 10 1526 ARCH ST 1526.0 ARCH ST 10   Berkeley 94708 37.879773837207864 -122.26503841160589
21026 21026 21026 059 225305401 1403 Arch St 1403 ARCH ST 1403 ARCH ST 1403.0 ARCH ST     Berkeley 94708 37.88263461196764 -122.2643829244178
21660 21660 21660 059 225401200 1432 Arch St F 1432 ARCH ST F 1432 ARCH ST 1432.0 ARCH ST F   Berkeley 94708 37.881403277764946 -122.2652304875833
21866 21866 21866 059 225401301 1436 Arch St 1 1436 ARCH ST 1 1436 ARCH ST 1436.0 ARCH ST 1   Berkeley 94708 37.88125907817247 -122.26521539049664
22551 22551 22551 061 255402100 1165 Arch St 1165 ARCH ST 1165 ARCH ST 1165.0 ARCH ST     Berkeley 94708 37.88735727963429 -122.26523967016212
23114 23114 23114 059 225302203 1419 Arch St 1419 ARCH ST 1419 ARCH ST 1419.0 ARCH ST     Berkeley 94708 37.88214082423486 -122.26424218176896
23170 23170 23170 059 225500400 1512 Arch St 2 1512 ARCH ST 2 1512 ARCH ST 1512.0 ARCH ST 2   Berkeley 94708 37.8802466497879 -122.26505050921782
23629 23629 23629 060 246200400 1316 Arch St 1316 ARCH ST 1316 ARCH ST 1316.0 ARCH ST     Berkeley 94708 37.883804006315515 -122.26548341364143
23884 23884 23884 059 225202000 1525 Arch St 4 1525 ARCH ST 4 1525 ARCH ST 1525.0 ARCH ST 4   Berkeley 94708 37.879873801292504 -122.26437627508804
24720 24720 24720 059 225401000 1428 Arch St 1428 ARCH ST 1428 ARCH ST 1428.0 ARCH ST     Berkeley 94708 37.88162182954586 -122.26525564041128
24928 24928 24928 060 246200500 1320 Arch St 1320 ARCH ST 1320 ARCH ST 1320.0 ARCH ST     Berkeley 94708 37.88358697615269 -122.2654609773189
25208 25208 25208 059 225203600 1581 Arch St 1581 ARCH ST 1581 ARCH ST 1581.0 ARCH ST     Berkeley 94708 37.87938063106263 -122.26433420967824
26754 26754 26754 059 225400800 1416 Arch St 1416 ARCH ST 1416 ARCH ST 1416.0 ARCH ST     Berkeley 94708 37.88190037731484 -122.26528741921274
26944 26944 26944 059 225201800 1579 Arch St 1579 ARCH ST 1579 ARCH ST 1579.0 ARCH ST     Berkeley 94708 37.87955591595493 -122.26431848826248
27197 27197 27197 059 225500900 1530 Arch St 2 1530 ARCH ST 2 1530 ARCH ST 1530.0 ARCH ST 2   Berkeley 94708 37.87961315060466 -122.26502241620392
27331 27331 27331 060 246503200 1305 Arch St 1305 ARCH ST 1305 ARCH ST 1305.0 ARCH ST     Berkeley 94708 37.88427975734215 -122.26485972771272
27457 27457 27457 060 246200400 1314 Arch St 1314 ARCH ST 1314 ARCH ST 1314.0 ARCH ST     Berkeley 94708 37.883804006315515 -122.26548341364143
27585 27585 27585 059 225401301 1436 Arch St 2 1436 ARCH ST 2 1436 ARCH ST 1436.0 ARCH ST 2   Berkeley 94708 37.88125907817247 -122.26521539049664
27611 27611 27611 059 225401100 1430 Arch St 1 1430 ARCH ST 1 1430 ARCH ST 1430.0 ARCH ST 1   Berkeley 94708 37.88154076687194 -122.26524591974156
27710 27710 27710 059 225500800 1526 Arch St 1 1526 ARCH ST 1 1526 ARCH ST 1526.0 ARCH ST 1   Berkeley 94708 37.879773837207864 -122.26503841160589

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