home / berkeley_address_centric

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

208 rows where street_name = "OREGON" and zipcode = 94703

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

zipcode 1

  • 94703 · 208 ✖

street_type 1

  • ST 208

street_name 1

  • OREGON · 208 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
464 464 464 053 167400600 1637 Oregon St 1637 OREGON ST 1637 OREGON ST 1637.0 OREGON ST     Berkeley 94703 37.85675516617272 -122.27585999272716
1092 1092 1092 053 167400500 1639 Oregon St 1639 OREGON ST 1639 OREGON ST 1639.0 OREGON ST     Berkeley 94703 37.85672602753208 -122.27571894375284
1526 1526 1526 053 167101200 1531 Oregon St 1531 OREGON ST 1531 OREGON ST 1531.0 OREGON ST     Berkeley 94703 37.85644330417185 -122.27847938667088
2093 2093 2093 053 167202101 1534 Oregon St B 1534 OREGON ST B 1534 OREGON ST 1534.0 OREGON ST B   Berkeley 94703 37.855916433567224 -122.27823989671442
2363 2363 2363 053 167202101 1534 Oregon St A 1534 OREGON ST A 1534 OREGON ST 1534.0 OREGON ST A   Berkeley 94703 37.855916433567224 -122.27823989671442
2600 2600 2600 053 167501900 1709 Oregon St 1709 OREGON ST 1709 OREGON ST 1709.0 OREGON ST     Berkeley 94703 37.85683771152497 -122.2748382597028
3025 3025 3025 053 167902500 1924 Oregon St 1924 OREGON ST 1924 OREGON ST 1924.0 OREGON ST     Berkeley 94703 37.856912157733014 -122.2700981607656
4282 4282 4282 053 168001400 1911 Oregon St 1911 OREGON ST 1911 OREGON ST 1911.0 OREGON ST     Berkeley 94703 37.85737288661467 -122.27083409118906
4607 4607 4607 053 167501100 1727 Oregon St B 1727 OREGON ST B 1727 OREGON ST 1727.0 OREGON ST B   Berkeley 94703 37.85701462673734 -122.273892397489
4634 4634 4634 053 168000200 1947 Oregon St 7 1947 OREGON ST 7 1947 OREGON ST 1947.0 OREGON ST 7   Berkeley 94703 37.85768370491697 -122.2694772578176
4678 4678 4678 053 167600102 1718 Oregon St 1718 OREGON ST 1718 OREGON ST 1718.0 OREGON ST     Berkeley 94703 37.85623691327085 -122.27399467427736
4815 4815 4815 053 168000500 1937 Oregon St 1937 OREGON ST 1937 OREGON ST 1937.0 OREGON ST     Berkeley 94703 37.85751702019043 -122.26974532587816
5542 5542 5542 053 167401400 1613 Oregon St A 1613 OREGON ST A 1613 OREGON ST 1613.0 OREGON ST A   Berkeley 94703 37.8566291684034 -122.27683307748732
5639 5639 5639 053 167600102 1720 Oregon St 1720 OREGON ST 1720 OREGON ST 1720.0 OREGON ST     Berkeley 94703 37.85623691327085 -122.27399467427736
5857 5857 5857 053 167600102 1730 Oregon St Rec 1730 OREGON ST REC 1730 OREGON ST 1730.0 OREGON ST REC   Berkeley 94703 37.85623691327085 -122.27399467427736
6146 6146 6146 053 167200103 1590 Oregon St 17 1590 OREGON ST 17 1590 OREGON ST 1590.0 OREGON ST 17   Berkeley 94703 37.8559793607424 -122.277633400947
6230 6230 6230 053 167701800 1809 Oregon St 1809 OREGON ST 1809 OREGON ST 1809.0 OREGON ST     Berkeley 94703 37.85719865467718 -122.27245735409396
6404 6404 6404 053 167101500 1519 Oregon St A 1519 OREGON ST A 1519 OREGON ST 1519.0 OREGON ST A   Berkeley 94703 37.856389160235494 -122.27889032369252
6602 6602 6602 053 167201800 1514 Oregon St F 1514 OREGON ST F 1514 OREGON ST 1514.0 OREGON ST F   Berkeley 94703 37.8558106897476 -122.27878037439336
6709 6709 6709 053 167303100 1632 Oregon St D 1632 OREGON ST D 1632 OREGON ST 1632.0 OREGON ST D   Berkeley 94703 37.8562072609154 -122.27589708057198
6824 6824 6824 053 167501800 1711 Oregon St 1711 OREGON ST 1711 OREGON ST 1711.0 OREGON ST     Berkeley 94703 37.856901386184234 -122.2747289329361
7614 7614 7614 053 168000800 1925 Oregon St 1925 OREGON ST 1925 OREGON ST 1925.0 OREGON ST     Berkeley 94703 37.857467184352934 -122.27012870348524
7646 7646 7646 053 167501100 1727 Oregon St D 1727 OREGON ST D 1727 OREGON ST 1727.0 OREGON ST D   Berkeley 94703 37.85701462673734 -122.273892397489
7661 7661 7661 053 167200104 1550 Oregon St 12A 1550 OREGON ST 12A 1550 OREGON ST 1550.0 OREGON ST 12A   Berkeley 94703 37.85591693998648 -122.2780061245348
7756 7756 7756 053 167701800 1811 Oregon St Lowr 1811 OREGON ST LOWR 1811 OREGON ST 1811.0 OREGON ST LOWR   Berkeley 94703 37.85719865467718 -122.27245735409396
7954 7954 7954 053 167500600 1747 Oregon St 1747 OREGON ST 1747 OREGON ST 1747.0 OREGON ST     Berkeley 94703 37.857055491455434 -122.27320998779186
8181 8181 8181 053 167302500 1608 Oregon St 1608 OREGON ST 1608 OREGON ST 1608.0 OREGON ST     Berkeley 94703 37.85615349768278 -122.27692302220348
8979 8979 8979 053 167101800 1505 Oregon St 1505 OREGON ST 1505 OREGON ST 1505.0 OREGON ST     Berkeley 94703 37.856333950940865 -122.27930129215524
9022 9022 9022 053 167201800 1514 Oregon St A 1514 OREGON ST A 1514 OREGON ST 1514.0 OREGON ST A   Berkeley 94703 37.8558106897476 -122.27878037439336
9276 9276 9276 053 168000200 1947 Oregon St 3 1947 OREGON ST 3 1947 OREGON ST 1947.0 OREGON ST 3   Berkeley 94703 37.85768370491697 -122.2694772578176
9468 9468 9468 053 168000200 1947 Oregon St 1947 OREGON ST 1947 OREGON ST 1947.0 OREGON ST     Berkeley 94703 37.85768370491697 -122.2694772578176
9620 9620 9620 053 167701600 1817 Oregon St A 1817 OREGON ST A 1817 OREGON ST 1817.0 OREGON ST A   Berkeley 94703 37.857233331017554 -122.27217926622473
9865 9865 9865 053 167303100 1632 Oregon St C 1632 OREGON ST C 1632 OREGON ST 1632.0 OREGON ST C   Berkeley 94703 37.8562072609154 -122.27589708057198
9934 9934 9934 053 168001500 1907 Oregon St 1907 OREGON ST 1907 OREGON ST 1907.0 OREGON ST     Berkeley 94703 37.857227600212816 -122.27095711277228
10151 10151 10151 053 167200103 1590 Oregon St 11 1590 OREGON ST 11 1590 OREGON ST 1590.0 OREGON ST 11   Berkeley 94703 37.8559793607424 -122.277633400947
10550 10550 10550 053 167302900 1624 Oregon St 1624 OREGON ST 1624 OREGON ST 1624.0 OREGON ST     Berkeley 94703 37.85616560560228 -122.27621833249064
12109 12109 12109 053 168001300 1915 Oregon St C 1915 OREGON ST C 1915 OREGON ST 1915.0 OREGON ST C   Berkeley 94703 37.857391399629286 -122.27069936904928
12286 12286 12286 053 167501100 1727 Oregon St 1727 OREGON ST 1727 OREGON ST 1727.0 OREGON ST     Berkeley 94703 37.85701462673734 -122.273892397489
12489 12489 12489 053 167902100 1912 Oregon St B 1912 OREGON ST B 1912 OREGON ST 1912.0 OREGON ST B   Berkeley 94703 37.85684215363145 -122.27064036051488
12494 12494 12494 053 168101105 2041 Oregon St B 2041 OREGON ST B 2041 OREGON ST 2041.0 OREGON ST B   Berkeley 94703 37.85750556075236 -122.26895252850396
12588 12588 12588 053 167101000 1549 Oregon St 1549 OREGON ST 1549 OREGON ST 1549.0 OREGON ST     Berkeley 94703 37.85647698931469 -122.2782056457493
12640 12640 12640 053 167500800 1741 Oregon St 1741 OREGON ST 1741 OREGON ST 1741.0 OREGON ST     Berkeley 94703 37.857020866098125 -122.2734724719246
12929 12929 12929 053 167303000 1628 Oregon St 1628 OREGON ST 1628 OREGON ST 1628.0 OREGON ST     Berkeley 94703 37.85618993208102 -122.2760301057942
13211 13211 13211 053 167902300 1918 Oregon St 1918 OREGON ST 1918 OREGON ST 1918.0 OREGON ST     Berkeley 94703 37.856877453580296 -122.27036580212636
13910 13910 13910 053 167401400 1615 Oregon St 1615 OREGON ST 1615 OREGON ST 1615.0 OREGON ST     Berkeley 94703 37.8566291684034 -122.27683307748732
13940 13940 13940 053 167201800 1514 Oregon St C 1514 OREGON ST C 1514 OREGON ST 1514.0 OREGON ST C   Berkeley 94703 37.8558106897476 -122.27878037439336
14462 14462 14462 053 167200104 1550 Oregon St 3 1550 OREGON ST 3 1550 OREGON ST 1550.0 OREGON ST 3   Berkeley 94703 37.85591693998648 -122.2780061245348
14847 14847 14847 053 167101100 1535 Oregon St 1535 OREGON ST 1535 OREGON ST 1535.0 OREGON ST     Berkeley 94703 37.85646057762392 -122.27833949382833
15077 15077 15077 053 167101300 1525 Oregon St B 1525 OREGON ST B 1525 OREGON ST 1525.0 OREGON ST B   Berkeley 94703 37.8564239433465 -122.27861838119811
15258 15258 15258 053 167302600 1610 Oregon St 1610 OREGON ST 1610 OREGON ST 1610.0 OREGON ST     Berkeley 94703 37.856095361768126 -122.2767440912736
15293 15293 15293 053 167901801 1910 Oregon St 1910 OREGON ST 1910 OREGON ST 1910.0 OREGON ST     Berkeley 94703 37.8568463113237 -122.27103106028984
15817 15817 15817 053 167600102 1730 Oregon St 1730 OREGON ST 1730 OREGON ST 1730.0 OREGON ST     Berkeley 94703 37.85623691327085 -122.27399467427736
15933 15933 15933 053 167200103 1590 Oregon St 9 1590 OREGON ST 9 1590 OREGON ST 1590.0 OREGON ST 9   Berkeley 94703 37.8559793607424 -122.277633400947
16962 16962 16962 053 167101300 1525 Oregon St 1525 OREGON ST 1525 OREGON ST 1525.0 OREGON ST     Berkeley 94703 37.8564239433465 -122.27861838119811
17001 17001 17001 053 167902100 1912 Oregon St 1912 OREGON ST 1912 OREGON ST 1912.0 OREGON ST     Berkeley 94703 37.85684215363145 -122.27064036051488
18190 18190 18190 053 167501100 1727 Oregon St C 1727 OREGON ST C 1727 OREGON ST 1727.0 OREGON ST C   Berkeley 94703 37.85701462673734 -122.273892397489
18731 18731 18731 053 168001300 1915 Oregon St B 1915 OREGON ST B 1915 OREGON ST 1915.0 OREGON ST B   Berkeley 94703 37.857391399629286 -122.27069936904928
18741 18741 18741 053 167200103 1590 Oregon St 14 1590 OREGON ST 14 1590 OREGON ST 1590.0 OREGON ST 14   Berkeley 94703 37.8559793607424 -122.277633400947
19117 19117 19117 053 167201700 1512 Oregon St 1512 OREGON ST 1512 OREGON ST 1512.0 OREGON ST     Berkeley 94703 37.85579094504008 -122.27892109458426
19166 19166 19166 053 167201700 1512 Oregon St A 1512 OREGON ST A 1512 OREGON ST 1512.0 OREGON ST A   Berkeley 94703 37.85579094504008 -122.27892109458426
19564 19564 19564 053 167501100 1727 Oregon St A 1727 OREGON ST A 1727 OREGON ST 1727.0 OREGON ST A   Berkeley 94703 37.85701462673734 -122.273892397489
20140 20140 20140 053 167701500 1821 Oregon St 1821 OREGON ST 1821 OREGON ST 1821.0 OREGON ST     Berkeley 94703 37.85725125396467 -122.27204371404164
20287 20287 20287 053 167202000 1528 Oregon St 1528 OREGON ST 1528 OREGON ST 1528.0 OREGON ST     Berkeley 94703 37.85586657182312 -122.27837288690236
20491 20491 20491 053 167201500 1500 Oregon St 1500 OREGON ST 1500 OREGON ST 1500.0 OREGON ST     Berkeley 94703 37.85583152956498 -122.27925978190429
21933 21933 21933 053 168000700 1927 Oregon St 1927 OREGON ST 1927 OREGON ST 1927.0 OREGON ST     Berkeley 94703 37.85748014741892 -122.2700207924634
22159 22159 22159 053 167902802 1932 Oregon St 1932 OREGON ST 1932 OREGON ST 1932.0 OREGON ST     Berkeley 94703 37.85696446075403 -122.26969488816992
22347 22347 22347 053 167501400 1721 Oregon St 1721 OREGON ST 1721 OREGON ST 1721.0 OREGON ST     Berkeley 94703 37.856959749135875 -122.27430502154677
22493 22493 22493 053 167200104 1550 Oregon St 11 1550 OREGON ST 11 1550 OREGON ST 1550.0 OREGON ST 11   Berkeley 94703 37.85591693998648 -122.2780061245348
22613 22613 22613 053 167902300 1918 Oregon St A 1918 OREGON ST A 1918 OREGON ST 1918.0 OREGON ST A   Berkeley 94703 37.856877453580296 -122.27036580212636
22739 22739 22739 053 167601800 1708 Oregon St 1708 OREGON ST 1708 OREGON ST 1708.0 OREGON ST     Berkeley 94703 37.85641018146142 -122.27474660908592
22761 22761 22761 053 167902900 1938 Oregon St 1938 OREGON ST 1938 OREGON ST 1938.0 OREGON ST     Berkeley 94703 37.856982507887125 -122.26955420121664
23202 23202 23202 053 167200104 1550 Oregon St 2 1550 OREGON ST 2 1550 OREGON ST 1550.0 OREGON ST 2   Berkeley 94703 37.85591693998648 -122.2780061245348
23373 23373 23373 053 167501300 1723 Oregon St Uppr 1723 OREGON ST UPPR 1723 OREGON ST 1723.0 OREGON ST UPPR   Berkeley 94703 37.85697819345599 -122.27416688401226
23476 23476 23476 053 167200104 1550 Oregon St 10 1550 OREGON ST 10 1550 OREGON ST 1550.0 OREGON ST 10   Berkeley 94703 37.85591693998648 -122.2780061245348
24464 24464 24464 053 167200103 1590 Oregon St 1 1590 OREGON ST 1 1590 OREGON ST 1590.0 OREGON ST 1   Berkeley 94703 37.8559793607424 -122.277633400947
24480 24480 24480 053 168000600 1933 Oregon St 2 1933 OREGON ST 2 1933 OREGON ST 1933.0 OREGON ST 2   Berkeley 94703 37.85749828450119 -122.26987827204864
24607 24607 24607 053 167101400 1521 Oregon St 1521 OREGON ST 1521 OREGON ST 1521.0 OREGON ST     Berkeley 94703 37.856406656409774 -122.2787548227134
24653 24653 24653 053 167302800 1622 Oregon St 1622 OREGON ST 1622 OREGON ST 1622.0 OREGON ST     Berkeley 94703 37.85613884987087 -122.27642119543798
24750 24750 24750 053 167303100 1632 Oregon St B 1632 OREGON ST B 1632 OREGON ST 1632.0 OREGON ST B   Berkeley 94703 37.8562072609154 -122.27589708057198
25105 25105 25105 053 167200104 1550 Oregon St 1 1550 OREGON ST 1 1550 OREGON ST 1550.0 OREGON ST 1   Berkeley 94703 37.85591693998648 -122.2780061245348
25224 25224 25224 053 167302400 1602 Oregon St 1602 OREGON ST 1602 OREGON ST 1602.0 OREGON ST     Berkeley 94703 37.85613698733168 -122.27706636906832
25336 25336 25336 053 167601700 1704 Oregon St 1704 OREGON ST 1704 OREGON ST 1704.0 OREGON ST     Berkeley 94703 37.85639385486771 -122.27488045896156
25352 25352 25352 053 167902600 1926 Oregon St 1926 OREGON ST 1926 OREGON ST 1926.0 OREGON ST     Berkeley 94703 37.85692968782769 -122.26995824277016
25376 25376 25376 053 167101500 1517 Oregon St 1517 OREGON ST 1517 OREGON ST 1517.0 OREGON ST     Berkeley 94703 37.856389160235494 -122.27889032369252
25413 25413 25413 053 167100900 1553 Oregon St 1553 OREGON ST 1553 OREGON ST 1553.0 OREGON ST     Berkeley 94703 37.856493562004985 -122.27807874793564
26495 26495 26495 053 167400800 1627 Oregon St 1627 OREGON ST 1627 OREGON ST 1627.0 OREGON ST     Berkeley 94703 37.856721002404505 -122.27613284521492
26566 26566 26566 053 167200104 1550 Oregon St 1550 OREGON ST 1550 OREGON ST 1550.0 OREGON ST     Berkeley 94703 37.85591693998648 -122.2780061245348
26755 26755 26755 053 167101000 1547 Oregon St 1547 OREGON ST 1547 OREGON ST 1547.0 OREGON ST     Berkeley 94703 37.85647698931469 -122.2782056457493
27015 27015 27015 053 167200104 1550 Oregon St 12 1550 OREGON ST 12 1550 OREGON ST 1550.0 OREGON ST 12   Berkeley 94703 37.85591693998648 -122.2780061245348
27121 27121 27121 053 167401000 1621 Oregon St 1621 OREGON ST 1621 OREGON ST 1621.0 OREGON ST     Berkeley 94703 37.85663509713928 -122.27641146219187
27652 27652 27652 053 167902300 1918 Oregon St B 1918 OREGON ST B 1918 OREGON ST 1918.0 OREGON ST B   Berkeley 94703 37.856877453580296 -122.27036580212636
28121 28121 28121 053 167200103 1590 Oregon St 16 1590 OREGON ST 16 1590 OREGON ST 1590.0 OREGON ST 16   Berkeley 94703 37.8559793607424 -122.277633400947
28490 28490 28490 053 167200103 1590 Oregon St 5 1590 OREGON ST 5 1590 OREGON ST 1590.0 OREGON ST 5   Berkeley 94703 37.8559793607424 -122.277633400947
28590 28590 28590 053 167701700 1815 Oregon St A 1815 OREGON ST A 1815 OREGON ST 1815.0 OREGON ST A   Berkeley 94703 37.85721429594922 -122.2723165844957
28772 28772 28772 053 167701800 1811 Oregon St 1811 OREGON ST 1811 OREGON ST 1811.0 OREGON ST     Berkeley 94703 37.85719865467718 -122.27245735409396
29016 29016 29016 053 167303200 1636 Oregon St 1636 OREGON ST 1636 OREGON ST 1636.0 OREGON ST     Berkeley 94703 37.856225422426 -122.2757572326452
29174 29174 29174 053 167101600 1513 Oregon St 1513 OREGON ST 1513 OREGON ST 1513.0 OREGON ST     Berkeley 94703 37.85636969726159 -122.27902333633834
30579 30579 30579 053 167200104 1550 Oregon St 14 1550 OREGON ST 14 1550 OREGON ST 1550.0 OREGON ST 14   Berkeley 94703 37.85591693998648 -122.2780061245348
30718 30718 30718 053 167902300 1918 Oregon St D 1918 OREGON ST D 1918 OREGON ST 1918.0 OREGON ST D   Berkeley 94703 37.856877453580296 -122.27036580212636
30801 30801 30801 053 167200104 1550 Oregon St 7 1550 OREGON ST 7 1550 OREGON ST 1550.0 OREGON ST 7   Berkeley 94703 37.85591693998648 -122.2780061245348

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);
Powered by Datasette · Queries took 2166.668ms · Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS