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

146 rows where street_name = "ARCH" and zipcode = 94709

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

  • 94709 · 146 ✖

street_type 1

street_name 1

  • ARCH · 146 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
259 259 259 058 218205600 1810 Arch St 1810 ARCH ST 1810 ARCH ST 1810.0 ARCH ST     Berkeley 94709 37.87588151946355 -122.26428494966132
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
1484 1484 1484 058 218201901 1862 Arch St 1862 ARCH ST 1862 ARCH ST 1862.0 ARCH ST     Berkeley 94709 37.87509836289433 -122.26434499934314
2266 2266 2266 058 218205600 1826 Arch St 1826 ARCH ST 1826 ARCH ST 1826.0 ARCH ST     Berkeley 94709 37.875578214048105 -122.26424439611613
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
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
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
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
6024 6024 6024 058 218205600 1818 Arch St 1818 ARCH ST 1818 ARCH ST 1818.0 ARCH ST     Berkeley 94709 37.87571890134378 -122.26426163478644
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
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
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
7222 7222 7222 058 218701900 1675 Arch St 1675 ARCH ST 1675 ARCH ST 1675.0 ARCH ST     Berkeley 94709 37.877803572964744 -122.26398225783475
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
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
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
10104 10104 10104 058 218205600 1824 Arch St 1824 ARCH ST 1824 ARCH ST 1824.0 ARCH ST     Berkeley 94709 37.87560899455786 -122.2642479076306
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
12578 12578 12578 058 218205600 1822 Arch St 1822 ARCH ST 1822 ARCH ST 1822.0 ARCH ST     Berkeley 94709 37.87564633617948 -122.26425435394106
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
13610 13610 13610 058 218801200 1729 Arch St 1729 ARCH ST 1729 ARCH ST 1729.0 ARCH ST     Berkeley 94709 37.877010131241605 -122.2639139409574
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
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
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
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
16652 16652 16652 058 218201801 1850 Arch St 517 1850 ARCH ST 517 1850 ARCH ST 1850.0 ARCH ST 517   Berkeley 94709 37.87530607447117 -122.26436977937024
17006 17006 17006 058 218202100 1890 Arch St 101 1890 ARCH ST 101 1890 ARCH ST 1890.0 ARCH ST 101   Berkeley 94709 37.87475308893859 -122.2642120630541
17117 17117 17117 058 218201400 1790 Arch St 1790 ARCH ST 1790 ARCH ST 1790.0 ARCH ST     Berkeley 94709 37.876097328612744 -122.2645177184228
17582 17582 17582 058 218202100 1890 Arch St 305 1890 ARCH ST 305 1890 ARCH ST 1890.0 ARCH ST 305   Berkeley 94709 37.87475308893859 -122.2642120630541
18002 18002 18002 058 218202000 1876 Arch St 2 1876 ARCH ST 2 1876 ARCH ST 1876.0 ARCH ST 2   Berkeley 94709 37.874933183239385 -122.26423271352589
19127 19127 19127 058 218202100 1890 Arch St 202 1890 ARCH ST 202 1890 ARCH ST 1890.0 ARCH ST 202   Berkeley 94709 37.87475308893859 -122.2642120630541
19173 19173 19173 058 218601300 1605 Arch St 1605 ARCH ST 1605 ARCH ST 1605.0 ARCH ST     Berkeley 94709 37.87877602321392 -122.26414048619058
19609 19609 19609 058 218702000 1671 Arch St 5 1671 ARCH ST 5 1671 ARCH ST 1671.0 ARCH ST 5   Berkeley 94709 37.87794048239992 -122.26400449113804
19720 19720 19720 058 218201901 1862 Arch St 11 1862 ARCH ST 11 1862 ARCH ST 1862.0 ARCH ST 11   Berkeley 94709 37.87509836289433 -122.26434499934314
20546 20546 20546 058 218401100 1668 Arch St 1668 ARCH ST 1668 ARCH ST 1668.0 ARCH ST     Berkeley 94709 37.8779535702042 -122.26451499473086
20980 20980 20980 058 218800100 1717 Arch St 2 1717 ARCH ST 2 1717 ARCH ST 1717.0 ARCH ST 2   Berkeley 94709 37.87716762208999 -122.26405314389385
21334 21334 21334 058 218205600 1828 Arch St 1828 ARCH ST 1828 ARCH ST 1828.0 ARCH ST     Berkeley 94709 37.87554527649887 -122.26423805760348
22142 22142 22142 058 218202000 1876 Arch St 4 1876 ARCH ST 4 1876 ARCH ST 1876.0 ARCH ST 4   Berkeley 94709 37.874933183239385 -122.26423271352589
22299 22299 22299 058 218801200 1729 Arch St 1 1729 ARCH ST 1 1729 ARCH ST 1729.0 ARCH ST 1   Berkeley 94709 37.877010131241605 -122.2639139409574
22933 22933 22933 058 218201901 1862 Arch St 5 1862 ARCH ST 5 1862 ARCH ST 1862.0 ARCH ST 5   Berkeley 94709 37.87509836289433 -122.26434499934314
23591 23591 23591 058 218401000 1646 Arch St 1646 ARCH ST 1646 ARCH ST 1646.0 ARCH ST     Berkeley 94709 37.87817195566657 -122.26475598936536
23622 23622 23622 058 218601000 1643 Arch St 1643 ARCH ST 1643 ARCH ST 1643.0 ARCH ST     Berkeley 94709 37.87837625298793 -122.26414659203958
24144 24144 24144 058 218202100 1890 Arch St 8 1890 ARCH ST 8 1890 ARCH ST 1890.0 ARCH ST 8   Berkeley 94709 37.87475308893859 -122.2642120630541
24423 24423 24423 058 218201801 1850 Arch St 5A 1850 ARCH ST 5A 1850 ARCH ST 1850.0 ARCH ST 5A   Berkeley 94709 37.87530607447117 -122.26436977937024
25635 25635 25635 058 218801200 1729 Arch St 4 1729 ARCH ST 4 1729 ARCH ST 1729.0 ARCH ST 4   Berkeley 94709 37.877010131241605 -122.2639139409574
26845 26845 26845 058 218205600 1834 Arch St 1834 ARCH ST 1834 ARCH ST 1834.0 ARCH ST     Berkeley 94709 37.87545302419566 -122.2642219714717
27042 27042 27042 058 218701800 1685 Arch St 2 1685 ARCH ST 2 1685 ARCH ST 1685.0 ARCH ST 2   Berkeley 94709 37.87766790555054 -122.2639599311067
27935 27935 27935 058 218201801 1850 Arch St 3 1850 ARCH ST 3 1850 ARCH ST 1850.0 ARCH ST 3   Berkeley 94709 37.87530607447117 -122.26436977937024
28738 28738 28738 058 218700100 1657 Arch St 1657 ARCH ST 1657 ARCH ST 1657.0 ARCH ST     Berkeley 94709 37.87806451864275 -122.26410795819416
29357 29357 29357 058 218202000 1876 Arch St 4A 1876 ARCH ST 4A 1876 ARCH ST 1876.0 ARCH ST 4A   Berkeley 94709 37.874933183239385 -122.26423271352589
29532 29532 29532 058 218400900 1642 Arch St 1642 ARCH ST 1642 ARCH ST 1642.0 ARCH ST     Berkeley 94709 37.87828343627677 -122.26476556540632
29782 29782 29782 058 218801200 1729 Arch St 2 1729 ARCH ST 2 1729 ARCH ST 1729.0 ARCH ST 2   Berkeley 94709 37.877010131241605 -122.2639139409574
29942 29942 29942 058 218601400 1601 Arch St 1601 ARCH ST 1601 ARCH ST 1601.0 ARCH ST     Berkeley 94709 37.87890150734679 -122.26422830998436
30364 30364 30364 058 218202100 1890 Arch St 5 1890 ARCH ST 5 1890 ARCH ST 1890.0 ARCH ST 5   Berkeley 94709 37.87475308893859 -122.2642120630541
30880 30880 30880 058 218202000 1876 Arch St 4B 1876 ARCH ST 4B 1876 ARCH ST 1876.0 ARCH ST 4B   Berkeley 94709 37.874933183239385 -122.26423271352589
31040 31040 31040 058 218200600 1702 Arch St 1702 ARCH ST 1702 ARCH ST 1702.0 ARCH ST     Berkeley 94709 37.877314285893185 -122.26465850958066
31861 31861 31861 058 218701800 1685 Arch St 1685 ARCH ST 1685 ARCH ST 1685.0 ARCH ST     Berkeley 94709 37.87766790555054 -122.2639599311067
32159 32159 32159 058 218202100 1890 Arch St 302 1890 ARCH ST 302 1890 ARCH ST 1890.0 ARCH ST 302   Berkeley 94709 37.87475308893859 -122.2642120630541
32416 32416 32416 058 218205600 1812 Arch St 1812 ARCH ST 1812 ARCH ST 1812.0 ARCH ST     Berkeley 94709 37.87584197485298 -122.26427845394352
32563 32563 32563 058 218201801 1850 Arch St 5 1850 ARCH ST 5 1850 ARCH ST 1850.0 ARCH ST 5   Berkeley 94709 37.87530607447117 -122.26436977937024
32630 32630 32630 058 218701800 1685 Arch St 1 1685 ARCH ST 1 1685 ARCH ST 1685.0 ARCH ST 1   Berkeley 94709 37.87766790555054 -122.2639599311067
32713 32713 32713 058 218801200 1729 Arch St 3 1729 ARCH ST 3 1729 ARCH ST 1729.0 ARCH ST 3   Berkeley 94709 37.877010131241605 -122.2639139409574
32778 32778 32778 058 218201801 1850 Arch St 1850 ARCH ST 1850 ARCH ST 1850.0 ARCH ST     Berkeley 94709 37.87530607447117 -122.26436977937024
33399 33399 33399 058 218702000 1671 Arch St 4 1671 ARCH ST 4 1671 ARCH ST 1671.0 ARCH ST 4   Berkeley 94709 37.87794048239992 -122.26400449113804
33558 33558 33558 058 218202100 1890 Arch St 204 1890 ARCH ST 204 1890 ARCH ST 1890.0 ARCH ST 204   Berkeley 94709 37.87475308893859 -122.2642120630541
33733 33733 33733 058 218400800 1630 Arch St 1630 ARCH ST 1630 ARCH ST 1630.0 ARCH ST     Berkeley 94709 37.87839433316652 -122.26477940754653
33784 33784 33784 058 218901000 1815 Arch St 104 1815 ARCH ST 104 1815 ARCH ST 1815.0 ARCH ST 104   Berkeley 94709 37.87583110821806 -122.26373366345292
33812 33812 33812 058 218202100 1890 Arch St 303 1890 ARCH ST 303 1890 ARCH ST 1890.0 ARCH ST 303   Berkeley 94709 37.87475308893859 -122.2642120630541
34836 34836 34836 058 218700100 1661 Arch St 1661 ARCH ST 1661 ARCH ST 1661.0 ARCH ST     Berkeley 94709 37.87806451864275 -122.26410795819416
35230 35230 35230 058 218202100 1890 Arch St 301 1890 ARCH ST 301 1890 ARCH ST 1890.0 ARCH ST 301   Berkeley 94709 37.87475308893859 -122.2642120630541
35868 35868 35868 058 218201901 1862 Arch St 10 1862 ARCH ST 10 1862 ARCH ST 1862.0 ARCH ST 10   Berkeley 94709 37.87509836289433 -122.26434499934314
36111 36111 36111 058 218202100 1890 Arch St 7 1890 ARCH ST 7 1890 ARCH ST 1890.0 ARCH ST 7   Berkeley 94709 37.87475308893859 -122.2642120630541
36452 36452 36452 058 218700100 1659 Arch St 1659 ARCH ST 1659 ARCH ST 1659.0 ARCH ST     Berkeley 94709 37.87806451864275 -122.26410795819416
36677 36677 36677 058 218202100 1890 Arch St 3 1890 ARCH ST 3 1890 ARCH ST 1890.0 ARCH ST 3   Berkeley 94709 37.87475308893859 -122.2642120630541
36719 36719 36719 058 218800100 1717 Arch St 1717 ARCH ST 1717 ARCH ST 1717.0 ARCH ST     Berkeley 94709 37.87716762208999 -122.26405314389385
37593 37593 37593 058 218702000 1671 Arch St 7 1671 ARCH ST 7 1671 ARCH ST 1671.0 ARCH ST 7   Berkeley 94709 37.87794048239992 -122.26400449113804
37658 37658 37658 058 218202100 1890 Arch St 1890 ARCH ST 1890 ARCH ST 1890.0 ARCH ST     Berkeley 94709 37.87475308893859 -122.2642120630541
37907 37907 37907 058 218400700 1624 Arch St 1624 ARCH ST 1624 ARCH ST 1624.0 ARCH ST     Berkeley 94709 37.87850300346202 -122.26479065355558
37991 37991 37991 058 218201901 1862 Arch St 8 1862 ARCH ST 8 1862 ARCH ST 1862.0 ARCH ST 8   Berkeley 94709 37.87509836289433 -122.26434499934314
38002 38002 38002 058 218601200 1615 Arch St A 1615 ARCH ST A 1615 ARCH ST 1615.0 ARCH ST A   Berkeley 94709 37.87866495034493 -122.26411821875132
38137 38137 38137 058 218202100 1890 Arch St 6 1890 ARCH ST 6 1890 ARCH ST 1890.0 ARCH ST 6   Berkeley 94709 37.87475308893859 -122.2642120630541
38805 38805 38805 058 218901400 1849 Arch St 2 1849 ARCH ST 2 1849 ARCH ST 1849.0 ARCH ST 2   Berkeley 94709 37.875434824169176 -122.2637885630932
40220 40220 40220 058 218601000 1645 Arch St 1645 ARCH ST 1645 ARCH ST 1645.0 ARCH ST     Berkeley 94709 37.87837625298793 -122.26414659203958
40331 40331 40331 058 218800100 1717 Arch St 4 1717 ARCH ST 4 1717 ARCH ST 1717.0 ARCH ST 4   Berkeley 94709 37.87716762208999 -122.26405314389385
41400 41400 41400 058 218201801 1850 Arch St 8 1850 ARCH ST 8 1850 ARCH ST 1850.0 ARCH ST 8   Berkeley 94709 37.87530607447117 -122.26436977937024
42468 42468 42468 058 218801200 1729 Arch St 6 1729 ARCH ST 6 1729 ARCH ST 1729.0 ARCH ST 6   Berkeley 94709 37.877010131241605 -122.2639139409574

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