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

349 rows where street_name = "ARCH" and street_type = "ST"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 2

street_type 1

  • ST · 349 ✖

street_name 1

  • ARCH · 349 ✖
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
259 259 259 058 218205600 1810 Arch St 1810 ARCH ST 1810 ARCH ST 1810.0 ARCH ST     Berkeley 94709 37.87588151946355 -122.26428494966132
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
845 845 845 058 218200700 1710 Arch St 1710 ARCH ST 1710 ARCH ST 1710.0 ARCH ST     Berkeley 94709 37.87717767239278 -122.26464307472745
949 949 949 058 218202100 1890 Arch St 9 1890 ARCH ST 9 1890 ARCH ST 1890.0 ARCH ST 9   Berkeley 94709 37.87475308893859 -122.2642120630541
964 964 964 060 246502800 1321 Arch St 1321 ARCH ST 1321 ARCH ST 1321.0 ARCH ST     Berkeley 94708 37.8837292398632 -122.26486480858397
1484 1484 1484 058 218201901 1862 Arch St 1862 ARCH ST 1862 ARCH ST 1862.0 ARCH ST     Berkeley 94709 37.87509836289433 -122.26434499934314
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
2266 2266 2266 058 218205600 1826 Arch St 1826 ARCH ST 1826 ARCH ST 1826.0 ARCH ST     Berkeley 94709 37.875578214048105 -122.26424439611613
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
2621 2621 2621 058 218201901 1862 Arch St 6 1862 ARCH ST 6 1862 ARCH ST 1862.0 ARCH ST 6   Berkeley 94709 37.87509836289433 -122.26434499934314
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
3594 3594 3594 058 218901400 1849 Arch St A 1849 ARCH ST A 1849 ARCH ST 1849.0 ARCH ST A   Berkeley 94709 37.875434824169176 -122.2637885630932
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
4968 4968 4968 058 218901400 1849 Arch St 1849 ARCH ST 1849 ARCH ST 1849.0 ARCH ST     Berkeley 94709 37.875434824169176 -122.2637885630932
4980 4980 4980 058 218901400 1849 Arch St 3 1849 ARCH ST 3 1849 ARCH ST 1849.0 ARCH ST 3   Berkeley 94709 37.875434824169176 -122.2637885630932
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
5382 5382 5382 058 218201300 1780 Arch St 1780 ARCH ST 1780 ARCH ST 1780.0 ARCH ST     Berkeley 94709 37.87622367032657 -122.26453199624594
5448 5448 5448 058 218901000 1811 Arch St 1811 ARCH ST 1811 ARCH ST 1811.0 ARCH ST     Berkeley 94709 37.87583110821806 -122.26373366345292
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
6024 6024 6024 058 218205600 1818 Arch St 1818 ARCH ST 1818 ARCH ST 1818.0 ARCH ST     Berkeley 94709 37.87571890134378 -122.26426163478644
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
6353 6353 6353 058 218702000 1671 Arch St 1671 ARCH ST 1671 ARCH ST 1671.0 ARCH ST     Berkeley 94709 37.87794048239992 -122.26400449113804
6406 6406 6406 058 218201801 1850 Arch St 1 1850 ARCH ST 1 1850 ARCH ST 1850.0 ARCH ST 1   Berkeley 94709 37.87530607447117 -122.26436977937024
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
6754 6754 6754 058 218400600 1620 Arch St A 1620 ARCH ST A 1620 ARCH ST 1620.0 ARCH ST A   Berkeley 94709 37.8786154393735 -122.26480294161034
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
7026 7026 7026 058 218601200 1615 Arch St 1615 ARCH ST 1615 ARCH ST 1615.0 ARCH ST     Berkeley 94709 37.87866495034493 -122.26411821875132
7071 7071 7071 058 218202000 1876 Arch St 1876 ARCH ST 1876 ARCH ST 1876.0 ARCH ST     Berkeley 94709 37.874933183239385 -122.26423271352589
7150 7150 7150 059 225202200 1515 Arch St 1515 ARCH ST 1515 ARCH ST 1515.0 ARCH ST     Berkeley 94708 37.88016436960152 -122.26441440048704
7222 7222 7222 058 218701900 1675 Arch St 1675 ARCH ST 1675 ARCH ST 1675.0 ARCH ST     Berkeley 94709 37.877803572964744 -122.26398225783475
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
7975 7975 7975 058 218800100 1717 Arch St 3 1717 ARCH ST 3 1717 ARCH ST 1717.0 ARCH ST 3   Berkeley 94709 37.87716762208999 -122.26405314389385
8049 8049 8049 059 225201800 1577 Arch St 1577 ARCH ST 1577 ARCH ST 1577.0 ARCH ST     Berkeley 94708 37.87955591595493 -122.26431848826248
8107 8107 8107 058 218201801 1850 Arch St 7 1850 ARCH ST 7 1850 ARCH ST 1850.0 ARCH ST 7   Berkeley 94709 37.87530607447117 -122.26436977937024
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
9260 9260 9260 058 218901000 1815 Arch St 482 1815 ARCH ST 482 1815 ARCH ST 1815.0 ARCH ST 482   Berkeley 94709 37.87583110821806 -122.26373366345292
9299 9299 9299 058 218701800 1685 Arch St 3 1685 ARCH ST 3 1685 ARCH ST 1685.0 ARCH ST 3   Berkeley 94709 37.87766790555054 -122.2639599311067
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
10104 10104 10104 058 218205600 1824 Arch St 1824 ARCH ST 1824 ARCH ST 1824.0 ARCH ST     Berkeley 94709 37.87560899455786 -122.2642479076306
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
11089 11089 11089 058 218205600 1814 Arch St 1814 ARCH ST 1814 ARCH ST 1814.0 ARCH ST     Berkeley 94709 37.87580027320204 -122.26426912853252
11296 11296 11296 058 218202100 1890 Arch St 105 1890 ARCH ST 105 1890 ARCH ST 1890.0 ARCH ST 105   Berkeley 94709 37.87475308893859 -122.2642120630541
11427 11427 11427 058 218400600 1620 Arch St 1620 ARCH ST 1620 ARCH ST 1620.0 ARCH ST     Berkeley 94709 37.8786154393735 -122.26480294161034
11566 11566 11566 058 218201901 1862 Arch St 7 1862 ARCH ST 7 1862 ARCH ST 1862.0 ARCH ST 7   Berkeley 94709 37.87509836289433 -122.26434499934314
11803 11803 11803 058 218901400 1849 Arch St 1 1849 ARCH ST 1 1849 ARCH ST 1849.0 ARCH ST 1   Berkeley 94709 37.875434824169176 -122.2637885630932
11861 11861 11861 058 218702000 1671 Arch St 8 1671 ARCH ST 8 1671 ARCH ST 1671.0 ARCH ST 8   Berkeley 94709 37.87794048239992 -122.26400449113804
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
12578 12578 12578 058 218205600 1822 Arch St 1822 ARCH ST 1822 ARCH ST 1822.0 ARCH ST     Berkeley 94709 37.87564633617948 -122.26425435394106
12705 12705 12705 060 246200700 1326 Arch St 1326 ARCH ST 1326 ARCH ST 1326.0 ARCH ST     Berkeley 94708 37.883322651061206 -122.26542870624064
12723 12723 12723 058 218800100 1717 Arch St 1 1717 ARCH ST 1 1717 ARCH ST 1717.0 ARCH ST 1   Berkeley 94709 37.87716762208999 -122.26405314389385
12770 12770 12770 058 218201801 1850 Arch St 4 1850 ARCH ST 4 1850 ARCH ST 1850.0 ARCH ST 4   Berkeley 94709 37.87530607447117 -122.26436977937024
13117 13117 13117 058 218601100 1635 Arch St 1635 ARCH ST 1635 ARCH ST 1635.0 ARCH ST     Berkeley 94709 37.87853155135978 -122.26417017730738
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
13610 13610 13610 058 218801200 1729 Arch St 1729 ARCH ST 1729 ARCH ST 1729.0 ARCH ST     Berkeley 94709 37.877010131241605 -122.2639139409574
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
14340 14340 14340 058 218201901 1862 Arch St 2 1862 ARCH ST 2 1862 ARCH ST 1862.0 ARCH ST 2   Berkeley 94709 37.87509836289433 -122.26434499934314
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
14878 14878 14878 058 218201801 1850 Arch St 2 1850 ARCH ST 2 1850 ARCH ST 1850.0 ARCH ST 2   Berkeley 94709 37.87530607447117 -122.26436977937024
14899 14899 14899 059 225304502 1407 Arch St 1407 ARCH ST 1407 ARCH ST 1407.0 ARCH ST     Berkeley 94708 37.882471430909646 -122.26457323969726
15315 15315 15315 058 218201500 1800 Arch St 1800 ARCH ST 1800 ARCH ST 1800.0 ARCH ST     Berkeley 94709 37.87596055047652 -122.26450412331928
15323 15323 15323 058 218202000 1876 Arch St 5 1876 ARCH ST 5 1876 ARCH ST 1876.0 ARCH ST 5   Berkeley 94709 37.874933183239385 -122.26423271352589
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
15752 15752 15752 058 218202100 1890 Arch St 205 1890 ARCH ST 205 1890 ARCH ST 1890.0 ARCH ST 205   Berkeley 94709 37.87475308893859 -122.2642120630541

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