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

61 rows where street_name = "THOUSAND OAKS" and street_type = "BL"

✎ View and edit SQL

This data as json, CSV (advanced)

zipcode 1

street_type 1

street_name 1

  • THOUSAND OAKS · 61 ✖
Link rowid ▼ address_id apn address_full address_normalized base_address street_number street_name street_type unit unit_type city zipcode latitude longitude
39 39 39 062 286101200 1545 Thousand Oaks Blvd 1545 THOUSAND OAKS BLVD 1545 THOUSAND OAKS BL 1545.0 THOUSAND OAKS BL     Berkeley 94707 37.89679278792589 -122.28652091914304
356 356 356 062 289700601 1871 Thousand Oaks Blvd 1871 THOUSAND OAKS BLVD 1871 THOUSAND OAKS BL 1871.0 THOUSAND OAKS BL     Berkeley 94707 37.89743095113354 -122.27930480546634
1349 1349 1349 062 292101300 1923 Thousand Oaks Blvd 1923 THOUSAND OAKS BLVD 1923 THOUSAND OAKS BL 1923.0 THOUSAND OAKS BL     Berkeley 94707 37.89732672646021 -122.27794971482652
2501 2501 2501 062 289902000 1824 Thousand Oaks Blvd 1824 THOUSAND OAKS BLVD 1824 THOUSAND OAKS BL 1824.0 THOUSAND OAKS BL     Berkeley 94707 37.897203394672815 -122.28074213776868
2520 2520 2520 062 289201000 1738 Thousand Oaks Blvd 1738 THOUSAND OAKS BLVD 1738 THOUSAND OAKS BL 1738.0 THOUSAND OAKS BL     Berkeley 94707 37.89714107476551 -122.28291678479836
2946 2946 2946 062 289601700 1811 Thousand Oaks Blvd 1811 THOUSAND OAKS BLVD 1811 THOUSAND OAKS BL 1811.0 THOUSAND OAKS BL     Berkeley 94707 37.89767060657209 -122.28111601030172
3386 3386 3386 062 289700400 1885 Thousand Oaks Blvd 1885 THOUSAND OAKS BLVD 1885 THOUSAND OAKS BL 1885.0 THOUSAND OAKS BL     Berkeley 94707 37.897393443339695 -122.2789615672811
3803 3803 3803 062 289902400 1848 Thousand Oaks Blvd 1848 THOUSAND OAKS BLVD 1848 THOUSAND OAKS BL 1848.0 THOUSAND OAKS BL     Berkeley 94707 37.89712032744336 -122.2800581748844
5145 5145 5145 062 286701600 1581 Thousand Oaks Blvd 1581 THOUSAND OAKS BLVD 1581 THOUSAND OAKS BL 1581.0 THOUSAND OAKS BL     Berkeley 94707 37.896773813407954 -122.28580728849818
5162 5162 5162 062 289300200 1790 Thousand Oaks Blvd 1790 THOUSAND OAKS BLVD 1790 THOUSAND OAKS BL 1790.0 THOUSAND OAKS BL     Berkeley 94707 37.89719509447571 -122.28176945561918
5321 5321 5321 062 289903000 1884 Thousand Oaks Blvd 1884 THOUSAND OAKS BLVD 1884 THOUSAND OAKS BL 1884.0 THOUSAND OAKS BL     Berkeley 94707 37.896997709147506 -122.27907340663565
7726 7726 7726 062 286701800 1563 Thousand Oaks Blvd 1563 THOUSAND OAKS BLVD 1563 THOUSAND OAKS BL 1563.0 THOUSAND OAKS BL     Berkeley 94707 37.89678058247757 -122.28606913303048
7827 7827 7827 062 292000500 1946 Thousand Oaks Blvd 1946 THOUSAND OAKS BLVD 1946 THOUSAND OAKS BL 1946.0 THOUSAND OAKS BL     Berkeley 94707 37.89701634901871 -122.27719659154684
8910 8910 8910 062 290201500 1665 Thousand Oaks Blvd 1665 THOUSAND OAKS BLVD 1665 THOUSAND OAKS BL 1665.0 THOUSAND OAKS BL     Berkeley 94707 37.89710583309472 -122.2845175898212
9024 9024 9024 062 289902100 1830 Thousand Oaks Blvd 1830 THOUSAND OAKS BLVD 1830 THOUSAND OAKS BL 1830.0 THOUSAND OAKS BL     Berkeley 94707 37.897183142870794 -122.28056832094772
9384 9384 9384 062 289501300 1797 Thousand Oaks Blvd 1797 THOUSAND OAKS BLVD 1797 THOUSAND OAKS BL 1797.0 THOUSAND OAKS BL     Berkeley 94707 37.897503543745025 -122.2817184295144
12060 12060 12060 062 292101101 1951 Thousand Oaks Blvd 1951 THOUSAND OAKS BLVD 1951 THOUSAND OAKS BL 1951.0 THOUSAND OAKS BL     Berkeley 94707 37.89743817311128 -122.27726604479302
14310 14310 14310 062 289200800 1710 Thousand Oaks Blvd 1710 THOUSAND OAKS BLVD 1710 THOUSAND OAKS BL 1710.0 THOUSAND OAKS BL     Berkeley 94707 37.897063823781835 -122.28326757961176
14932 14932 14932 062 289003200 1666 Thousand Oaks Blvd 1666 THOUSAND OAKS BLVD 1666 THOUSAND OAKS BL 1666.0 THOUSAND OAKS BL     Berkeley 94707 37.89689506536353 -122.2840430916033
15997 15997 15997 062 289901800 1800 Thousand Oaks Blvd 1800 THOUSAND OAKS BLVD 1800 THOUSAND OAKS BL 1800.0 THOUSAND OAKS BL     Berkeley 94707 37.89724873631706 -122.28119520218392
17439 17439 17439 062 292000600 1958 Thousand Oaks Blvd 1958 THOUSAND OAKS BLVD 1958 THOUSAND OAKS BL 1958.0 THOUSAND OAKS BL     Berkeley 94707 37.89702164998598 -122.27697992059524
19069 19069 19069 062 292000400 1936 Thousand Oaks Blvd 1936 THOUSAND OAKS BLVD 1936 THOUSAND OAKS BL 1936.0 THOUSAND OAKS BL     Berkeley 94707 37.89692824501529 -122.27748369760322
19291 19291 19291 062 292101000 1963 Thousand Oaks Blvd 1963 THOUSAND OAKS BLVD 1963 THOUSAND OAKS BL 1963.0 THOUSAND OAKS BL     Berkeley 94707 37.89741726637691 -122.27702156918674
19722 19722 19722 062 289700602 1869 Thousand Oaks Blvd 1869 THOUSAND OAKS BLVD 1869 THOUSAND OAKS BL 1869.0 THOUSAND OAKS BL     Berkeley 94707 37.8974541127821 -122.27947858545636
19894 19894 19894 062 290201900 1601 Thousand Oaks Blvd 1601 THOUSAND OAKS BLVD 1601 THOUSAND OAKS BL 1601.0 THOUSAND OAKS BL     Berkeley 94707 37.89673709496904 -122.28511111391592
23204 23204 23204 062 289400700 1761 Thousand Oaks Blvd 1761 THOUSAND OAKS BLVD 1761 THOUSAND OAKS BL 1761.0 THOUSAND OAKS BL     Berkeley 94707 37.89744735724293 -122.28255297159988
24031 24031 24031 062 290702800 1669 Thousand Oaks Blvd 1669 THOUSAND OAKS BLVD 1669 THOUSAND OAKS BL 1669.0 THOUSAND OAKS BL     Berkeley 94707 37.89715487866422 -122.284042458291
24436 24436 24436 062 289300100 1770 Thousand Oaks Blvd 1770 THOUSAND OAKS BLVD 1770 THOUSAND OAKS BL 1770.0 THOUSAND OAKS BL     Berkeley 94707 37.897194024076995 -122.28210855706251
24942 24942 24942 062 289102200 1620 Thousand Oaks Blvd 1620 THOUSAND OAKS BLVD 1620 THOUSAND OAKS BL 1620.0 THOUSAND OAKS BL     Berkeley 94707 37.89645042355274 -122.28473363644366
25877 25877 25877 062 286701700 1573 Thousand Oaks Blvd 1573 THOUSAND OAKS BLVD 1573 THOUSAND OAKS BL 1573.0 THOUSAND OAKS BL     Berkeley 94707 37.8967775073678 -122.2859417132956
26274 26274 26274 062 290201700 1631 Thousand Oaks Blvd 1631 THOUSAND OAKS BLVD 1631 THOUSAND OAKS BL 1631.0 THOUSAND OAKS BL     Berkeley 94707 37.8967890046483 -122.28482283376148
26596 26596 26596 062 289700800 1859 Thousand Oaks Blvd 1859 THOUSAND OAKS BLVD 1859 THOUSAND OAKS BL 1859.0 THOUSAND OAKS BL     Berkeley 94707 37.89749484590549 -122.27981936046103
27643 27643 27643 062 289200900 1720 Thousand Oaks Blvd 1720 THOUSAND OAKS BLVD 1720 THOUSAND OAKS BL 1720.0 THOUSAND OAKS BL     Berkeley 94707 37.89718936961466 -122.28308570310608
29762 29762 29762 062 292000100 1930 Thousand Oaks Blvd 1930 THOUSAND OAKS BLVD 1930 THOUSAND OAKS BL 1930.0 THOUSAND OAKS BL     Berkeley 94707 37.89673942505006 -122.27821410159108
30195 30195 30195 062 290201800 1611 Thousand Oaks Blvd 1611 THOUSAND OAKS BLVD 1611 THOUSAND OAKS BL 1611.0 THOUSAND OAKS BL     Berkeley 94707 37.89671126629601 -122.28493435062084
30956 30956 30956 062 289902200 1836 Thousand Oaks Blvd 1836 THOUSAND OAKS BLVD 1836 THOUSAND OAKS BL 1836.0 THOUSAND OAKS BL     Berkeley 94707 37.89716378424393 -122.28039888880366
33188 33188 33188 062 289902500 1854 Thousand Oaks Blvd 1854 THOUSAND OAKS BLVD 1854 THOUSAND OAKS BL 1854.0 THOUSAND OAKS BL     Berkeley 94707 37.89709952127887 -122.2798887041128
35477 35477 35477 062 292000201 1932 Thousand Oaks Blvd 1932 THOUSAND OAKS BLVD 1932 THOUSAND OAKS BL 1932.0 THOUSAND OAKS BL     Berkeley 94707 37.89691743394848 -122.27788965077168
37995 37995 37995 062 292000900 1988 Thousand Oaks Blvd 1988 THOUSAND OAKS BLVD 1988 THOUSAND OAKS BL 1988.0 THOUSAND OAKS BL     Berkeley 94707 37.89703693616443 -122.27643513998612
38146 38146 38146 062 289400800 1737 Thousand Oaks Blvd B 1737 THOUSAND OAKS BLVD B 1737 THOUSAND OAKS BL 1737.0 THOUSAND OAKS BL B   Berkeley 94707 37.89748196927318 -122.28289892179896
38440 38440 38440 062 286101300 1531 Thousand Oaks Blvd 1531 THOUSAND OAKS BLVD 1531 THOUSAND OAKS BL 1531.0 THOUSAND OAKS BL     Berkeley 94707 37.89679796627356 -122.28669261773656
39227 39227 39227 062 286701500 1599 Thousand Oaks Blvd 1599 THOUSAND OAKS BLVD 1599 THOUSAND OAKS BL 1599.0 THOUSAND OAKS BL     Berkeley 94707 37.89676969199484 -122.28565643441252
40308 40308 40308 062 289700900 1855 Thousand Oaks Blvd 1855 THOUSAND OAKS BLVD 1855 THOUSAND OAKS BL 1855.0 THOUSAND OAKS BL     Berkeley 94707 37.89752081962199 -122.2800192023741
40983 40983 40983 062 289400800 1737 Thousand Oaks Blvd 1737 THOUSAND OAKS BLVD 1737 THOUSAND OAKS BL 1737.0 THOUSAND OAKS BL     Berkeley 94707 37.89748196927318 -122.28289892179896
41428 41428 41428 062 286701900 1559 Thousand Oaks Blvd 1559 THOUSAND OAKS BLVD 1559 THOUSAND OAKS BL 1559.0 THOUSAND OAKS BL     Berkeley 94707 37.89678291964599 -122.28620006966966
42106 42106 42106 062 289700500 1877 Thousand Oaks Blvd 1877 THOUSAND OAKS BLVD 1877 THOUSAND OAKS BL 1877.0 THOUSAND OAKS BL     Berkeley 94707 37.89741201718571 -122.279132699936
45128 45128 45128 062 292101400 1915 Thousand Oaks Blvd 1915 THOUSAND OAKS BLVD 1915 THOUSAND OAKS BL 1915.0 THOUSAND OAKS BL     Berkeley 94707 37.89727644827585 -122.27815652137798
45548 45548 45548 062 289902801 1870 Thousand Oaks Blvd 1870 THOUSAND OAKS BLVD 1870 THOUSAND OAKS BL 1870.0 THOUSAND OAKS BL     Berkeley 94707 37.89702974817331 -122.27933405551028
45722 45722 45722 062 290702700 1687 Thousand Oaks Blvd 1687 THOUSAND OAKS BLVD 1687 THOUSAND OAKS BL 1687.0 THOUSAND OAKS BL     Berkeley 94707 37.89717605555395 -122.28382466803858
46119 46119 46119 062 289902600 1858 Thousand Oaks Blvd 1858 THOUSAND OAKS BLVD 1858 THOUSAND OAKS BL 1858.0 THOUSAND OAKS BL     Berkeley 94707 37.89707916737037 -122.27971739808306
46500 46500 46500 062 290201600 1661 Thousand Oaks Blvd 1661 THOUSAND OAKS BLVD 1661 THOUSAND OAKS BL 1661.0 THOUSAND OAKS BL     Berkeley 94707 37.8969735400433 -122.28467954977872
46829 46829 46829 062 289501400 1771 Thousand Oaks Blvd 1771 THOUSAND OAKS BLVD 1771 THOUSAND OAKS BL 1771.0 THOUSAND OAKS BL     Berkeley 94707 37.89745392847568 -122.28206376885906
47405 47405 47405 062 289902300 1842 Thousand Oaks Blvd 1842 THOUSAND OAKS BLVD 1842 THOUSAND OAKS BL 1842.0 THOUSAND OAKS BL     Berkeley 94707 37.8971422281032 -122.2802285278016
47540 47540 47540 062 289901900 1818 Thousand Oaks Blvd 1818 THOUSAND OAKS BLVD 1818 THOUSAND OAKS BL 1818.0 THOUSAND OAKS BL     Berkeley 94707 37.89722558098373 -122.28091420377316
49817 49817 49817 062 289700700 1863 Thousand Oaks Blvd 1863 THOUSAND OAKS BLVD 1863 THOUSAND OAKS BL 1863.0 THOUSAND OAKS BL     Berkeley 94707 37.89747328419077 -122.27964544752038
51325 51325 51325 062 292000701 1974 Thousand Oaks Blvd 1974 THOUSAND OAKS BLVD 1974 THOUSAND OAKS BL 1974.0 THOUSAND OAKS BL     Berkeley 94707 37.897028696202945 -122.27671407137343
51794 51794 51794 062 292101201 1937 Thousand Oaks Blvd 1937 THOUSAND OAKS BLVD 1937 THOUSAND OAKS BL 1937.0 THOUSAND OAKS BL     Berkeley 94707 37.89734655431736 -122.277587232033
53228 53228 53228 062 289902700 1866 Thousand Oaks Blvd 1866 THOUSAND OAKS BLVD 1866 THOUSAND OAKS BL 1866.0 THOUSAND OAKS BL     Berkeley 94707 37.89705592124769 -122.2795453572314
56240 56240 56240 062 289700300 1891 Thousand Oaks Blvd 1891 THOUSAND OAKS BLVD 1891 THOUSAND OAKS BL 1891.0 THOUSAND OAKS BL     Berkeley 94707 37.897365946213064 -122.2787537833626
56366 56366 56366 062 289601600 1819 Thousand Oaks Blvd 1819 THOUSAND OAKS BLVD 1819 THOUSAND OAKS BL 1819.0 THOUSAND OAKS BL     Berkeley 94707 37.897622032744195 -122.28084700260337
57957 57957 57957 062 290702600 1701 Thousand Oaks Blvd 1701 THOUSAND OAKS BLVD 1701 THOUSAND OAKS BL 1701.0 THOUSAND OAKS BL     Berkeley 94707 37.89722695123526 -122.28349803790633

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