Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23600 | 23600 | 135193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 35 Bay St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 6010885.4927900005 | 2121705.9799599997 | 37.806413341469 | -122.40661408636801 | (37.806413341469, -122.406614086368) | |||
25890 | 25890 | 211894 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 42 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 8ft | 5992633.05576 | 2096891.53005 | 37.73724142864779 | -122.467973292645 | (37.7372414286478, -122.467973292645) | |||
27830 | 27830 | 195766 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6014104.3852699995 | 2110532.00713 | 37.7759117775522 | -122.394691443959 | (37.7759117775522, -122.394691443959) | |||
30288 | 30288 | 195777 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 8ft | 6013688.74919 | 2110125.02195 | 37.774771170975704 | -122.396100718491 | (37.7747711709757, -122.396100718491) | |||
30873 | 30873 | 211922 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 San Anselmo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993428.13683 | 2096525.45183 | 37.736282151484296 | -122.465197772566 | (37.7362821514843, -122.465197772566) | |||
30878 | 30878 | 211892 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 15 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992677.8722 | 2096919.75593 | 37.7373215177838 | -122.46782039530399 | (37.7373215177838, -122.467820395304) | |||
31603 | 31603 | 211912 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 160 San Anselmo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993474.36419 | 2096435.15771 | 37.73603689198271 | -122.465031390792 | (37.7360368919827, -122.465031390792) | |||
34872 | 34872 | 211905 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 8ft | 5993202.216519999 | 2096632.8865099999 | 37.7365641096345 | -122.465986670445 | (37.7365641096345, -122.465986670445) | |||
35206 | 35206 | 195775 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6013821.82406 | 2110259.84157 | 37.7751487585315 | -122.395649829891 | (37.7751487585315, -122.395649829891) | |||
35875 | 35875 | 211898 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 5992872.84504 | 2096808.4352799999 | 37.7370271156957 | -122.46713819838001 | (37.7370271156957, -122.46713819838) | |||
36397 | 36397 | 195772 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 8ft | 6013930.44742 | 2110363.9939599996 | 37.7754407791936 | -122.395281372244 | (37.7754407791936, -122.395281372244) | |||
37873 | 37873 | 195921 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6018012.35548 | 2092964.6692 | 37.72789197591621 | -122.379951686024 | (37.7278919759162, -122.379951686024) | |||
38047 | 38047 | 211920 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993463.1611 | 2096494.07268 | 37.7361980118237 | -122.465074401756 | (37.7361980118237, -122.465074401756) | |||
39021 | 39021 | 211904 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 80 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 8ft | 5993117.507999999 | 2096685.0409 | 37.7367024253714 | -122.466283330728 | (37.7367024253714, -122.466283330728) | |||
40408 | 40408 | 195193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 180 Industrial St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6011356.489709999 | 2097189.94333 | 37.739124269068796 | -122.403258408244 | (37.7391242690688, -122.403258408244) | |||
41103 | 41103 | 195768 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6014054.2182599995 | 2110478.98946 | 37.775763413678 | -122.394861271956 | (37.775763413678, -122.394861271956) | |||
41734 | 41734 | 211902 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 60 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 8ft | 5993032.3976 | 2096733.05843 | 37.7368293583846 | -122.466581080979 | (37.7368293583846, -122.466581080979) | |||
41907 | 41907 | 211927 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993219.3101 | 2096667.4089099998 | 37.736659885632704 | -122.46593007882299 | (37.7366598856327, -122.465930078823) | |||
42112 | 42112 | 211890 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 33 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5992746.48615 | 2096899.9823599998 | 37.737271186301705 | -122.467581729613 | (37.7372711863017, -122.467581729613) | |||
42580 | 42580 | 211899 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 San Anselmo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 5992903.15569 | 2096794.06334 | 37.7369894035426 | -122.46703235718 | (37.7369894035426, -122.46703235718) | |||
43749 | 43749 | 211923 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 135 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993369.75745 | 2096567.1017 | 37.736393144928 | -122.465402637242 | (37.736393144928, -122.465402637242) | |||
45462 | 45462 | 211908 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 140 San Anselmo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 8ft | 5993318.47057 | 2096556.76908 | 37.7363618161472 | -122.46557920562401 | (37.7363618161472, -122.465579205624) | |||
46669 | 46669 | 211886 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 8ft | 5992960.04473 | 2096809.6715400002 | 37.7370355432472 | -122.4668368023 | (37.7370355432472, -122.4668368023) | |||
48494 | 48494 | 195774 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6013840.56716 | 2110278.0449099997 | 37.7751997833822 | -122.39558626849701 | (37.7751997833822, -122.395586268497) | |||
48496 | 48496 | 211895 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 42 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5992673.51698 | 2096879.9592900001 | 37.737211994721704 | -122.46783255953599 | (37.7372119947217, -122.467832559536) | |||
48962 | 48962 | 195770 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6014000.92339 | 2110427.4645700003 | 37.7756189744596 | -122.395042023971 | (37.7756189744596, -122.395042023971) | |||
52496 | 52496 | 211907 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 140 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 5993271.966130001 | 2096587.08569 | 37.736442375607794 | -122.465742191567 | (37.7364423756078, -122.465742191567) | |||
54152 | 54152 | 135194 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 33 Bay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 6010953.55365 | 2121723.39359 | 37.806464962561996 | -122.40637977613301 | (37.806464962562, -122.406379776133) | |||
55526 | 55526 | 211891 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 25 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992707.7708 | 2096909.12858 | 37.73729406415679 | -122.467716250229 | (37.7372940641568, -122.467716250229) | |||
55905 | 55905 | 195769 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6014035.25222 | 2110463.93544 | 37.77572102415021 | -122.394925826163 | (37.7757210241502, -122.394925826163) | |||
56832 | 56832 | 135192 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 35 Bay St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 6010823.80585 | 2121697.83678 | 37.806387530914 | -122.406826991865 | (37.806387530914, -122.406826991865) | |||
58372 | 58372 | 211925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 115 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5993291.36421 | 2096622.2118400002 | 37.73653994216279 | -122.465677676 | (37.7365399421628, -122.465677676) | |||
59427 | 59427 | 211882 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 5993133.46797 | 2096720.62207 | 37.7368010432217 | -122.466230735658 | (37.7368010432217, -122.466230735658) | |||
63098 | 63098 | 211910 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 160 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 8ft | 5993413.89239 | 2096486.3053099997 | 37.7361738434551 | -122.465244178503 | (37.7361738434551, -122.465244178503) | |||
64015 | 64015 | 195776 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6013789.3208 | 2110228.4798 | 37.7750608381088 | -122.39576006878299 | (37.7750608381088, -122.395760068783) | |||
67353 | 67353 | 195773 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6013858.15082 | 2110295.7002 | 37.7752492388859 | -122.39552667940599 | (37.7752492388859, -122.395526679406) | |||
68126 | 68126 | 211916 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 175 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 5993576.99611 | 2096411.8129 | 37.7359787103437 | -122.464674859058 | (37.7359787103437, -122.464674859058) | |||
69435 | 69435 | 211913 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 170 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 8ft | 5993507.71848 | 2096402.1835599998 | 37.735948276383205 | -122.46491367851802 | (37.7359482763832, -122.464913678518) | |||
70373 | 70373 | 211915 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 170 San Anselmo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 8ft | 5993555.44783 | 2096336.63357 | 37.7357710442905 | -122.464743901813 | (37.7357710442905, -122.464743901813) | |||
71774 | 71774 | 211885 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 69 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 5993003.60348 | 2096792.0914599998 | 37.7369897866347 | -122.466684923885 | (37.7369897866347, -122.466684923885) | |||
72368 | 72368 | 195924 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6017916.47309 | 2093037.8784299998 | 37.728087704366395 | -122.380288242927 | (37.7280877043664, -122.380288242927) | |||
73253 | 73253 | 195922 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6017988.36084 | 2092981.7840200001 | 37.7279376461829 | -122.38003582571899 | (37.7279376461829, -122.380035825719) | |||
75970 | 75970 | 195765 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 King St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 8ft | 6014123.60367 | 2110545.34082 | 37.7759494573415 | -122.39462589597 | (37.7759494573415, -122.39462589597) | |||
78133 | 78133 | 211911 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 160 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 8ft | 5993445.46093 | 2096461.8444599998 | 37.736108500497295 | -122.46513325792 | (37.7361085004973, -122.46513325792) | |||
132455 | 132455 | 211884 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 75 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 8ft | 5993049.1481800005 | 2096769.47059 | 37.736930303678996 | -122.466525813128 | (37.736930303679, -122.466525813128) | |||
133193 | 133193 | 195923 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Palou Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6017931.94783 | 2093024.26142 | 37.7280511685158 | -122.380233799755 | (37.7280511685158, -122.380233799755) | |||
134452 | 134452 | 211921 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 155 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993447.08738 | 2096508.1020799999 | 37.736235606189105 | -122.465130993427 | (37.7362356061891, -122.465130993427) | |||
146547 | 146547 | 195767 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6014073.23663 | 2110496.61551 | 37.7758128682948 | -122.39479671682 | (37.7758128682948, -122.39479671682) | |||
147106 | 147106 | 211893 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 15 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992652.52095 | 2096927.7879400002 | 37.7373421077603 | -122.467908629578 | (37.7373421077603, -122.467908629578) | |||
148507 | 148507 | 195232 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300x Evans Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 6017081.8167 | 2097473.87775 | 37.740221988756105 | -122.383482389326 | (37.7402219887561, -122.383482389326) | |||
149043 | 149043 | 135191 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 35 Bay St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6010790.5648300005 | 2121695.9208 | 37.8063804101047 | -122.406941893775 | (37.8063804101047, -122.406941893775) | |||
150007 | 150007 | 195771 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6013983.076169999 | 2110410.9582599998 | 37.7755726593879 | -122.39510260590201 | (37.7755726593879, -122.395102605902) | |||
152332 | 152332 | 211909 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 140 San Anselmo Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5993350.12818 | 2096536.54419 | 37.736308109533795 | -122.46546828414199 | (37.7363081095338, -122.465468284142) | |||
157458 | 157458 | 211903 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 80 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 8ft | 5993075.96143 | 2096709.0282700001 | 37.7367658914278 | -122.466428716926 | (37.7367658914278, -122.466428716926) | |||
159843 | 159843 | 211924 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 125 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5993331.74703 | 2096596.5876799999 | 37.736471913839296 | -122.46553619555701 | (37.7364719138393, -122.465536195557) | |||
161233 | 161233 | 211918 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 165 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993507.60683 | 2096459.2354700002 | 37.736104920292 | -122.464918206608 | (37.736104920292, -122.464918206608) | |||
162957 | 162957 | 211901 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 60 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 5992985.1351 | 2096757.1660799999 | 37.736892824454706 | -122.466746238754 | (37.7368928244547, -122.466746238754) | |||
165560 | 165560 | 211914 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 170 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993524.60983 | 2096380.31294 | 37.735889199014004 | -122.46485369105801 | (37.735889199014, -122.464853691058) | |||
165735 | 165735 | 211889 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 39 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5992793.76457 | 2096880.24095 | 37.737219710925004 | -122.467416832647 | (37.737219710925, -122.467416832647) | |||
166996 | 166996 | 211883 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 5993091.26879 | 2096743.1724900003 | 37.73686052618039 | -122.466378273942 | (37.7368605261804, -122.466378273942) | |||
171517 | 171517 | 211919 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 165 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5993483.83 | 2096480.59858 | 37.7361622071096 | -122.465001963172 | (37.7361622071096, -122.465001963172) | |||
173755 | 173755 | 211896 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 44 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992722.6294 | 2096863.85213 | 37.7371706043268 | -122.467661585835 | (37.7371706043268, -122.467661585835) | |||
173842 | 173842 | 211888 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 45 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5992853.918769999 | 2096856.0627 | 37.737156796137704 | -122.46720709635001 | (37.7371567961377, -122.46720709635) | |||
174624 | 174624 | 211887 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 55 San Anselmo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 8ft | 5992915.72841 | 2096831.01688 | 37.737091594397604 | -122.46699157379801 | (37.7370915943976, -122.466991573798) | |||
175727 | 175727 | 211900 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 50 San Anselmo Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 8ft | 5992945.19275 | 2096777.43519 | 37.736946173117104 | -122.466885809037 | (37.7369461731171, -122.466885809037) | |||
177000 | 177000 | 135190 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 35 Bay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 8ft | 6010769.03716 | 2121693.76645 | 37.8063732901518 | -122.407016242525 | (37.8063732901518, -122.407016242525) | |||
177657 | 177657 | 211906 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 8ft | 5993235.809830001 | 2096611.3169099998 | 37.736506822832204 | -122.465868958209 | (37.7365068228322, -122.465868958209) | |||
184144 | 184144 | 211897 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 44 San Anselmo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992779.12527 | 2096846.9196799998 | 37.737127373917 | -122.46746502461201 | (37.737127373917, -122.467465024612) | |||
186314 | 186314 | 118191 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 866 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 5985457.0333 | 2109984.4342900002 | 37.7727739274481 | -122.49374826573299 | (37.7727739274481, -122.493748265733) | |||
186423 | 186423 | 211926 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 115 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 8ft | 5993257.7161 | 2096641.17439 | 37.7365900676864 | -122.465795388244 | (37.7365900676864, -122.465795388244) | |||
188837 | 188837 | 211917 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 175 San Anselmo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 5993542.1892099995 | 2096437.97139 | 37.7360485283247 | -122.464797098516 | (37.7360485283247, -122.464797098516) | |||
31536 | 31536 | 135595 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6013640.01114 | 2117757.01067 | 37.7957241381178 | -122.39680448565001 | (37.7957241381178, -122.39680448565) | |||
32926 | 32926 | 195231 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300x Evans Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6017124.15925 | 2097442.52392 | 37.7401382376012 | -122.38333380241001 | (37.7401382376012, -122.38333380241) | |||
38029 | 38029 | 135591 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6013668.97989 | 2117535.62616 | 37.7951178808501 | -122.39668872043 | (37.7951178808501, -122.39668872043) | |||
38423 | 38423 | 135585 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6013716.425530001 | 2117200.6985 | 37.7942008889087 | -122.396501061571 | (37.7942008889087, -122.396501061571) | |||
41025 | 41025 | 135586 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6013710.78377 | 2117230.4416 | 37.794282242493 | -122.39652266870701 | (37.794282242493, -122.396522668707) | |||
44028 | 44028 | 135590 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 7ft | 6013675.90495 | 2117467.1976 | 37.7949303775801 | -122.396659959189 | (37.7949303775801, -122.396659959189) | |||
47340 | 47340 | 195222 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Phelps St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 7ft | 6014590.36228 | 2097114.26531 | 37.739096551976 | -122.392071762927 | (37.739096551976, -122.392071762927) | |||
47889 | 47889 | 135126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6009794.33207 | 2122480.55113 | 37.808479012257706 | -122.410444987853 | (37.8084790122577, -122.410444987853) | |||
49952 | 49952 | 135593 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6013643.30781 | 2117724.86941 | 37.795636069300606 | -122.396790824061 | (37.7956360693006, -122.396790824061) | |||
53516 | 53516 | 135600 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013623.6813 | 2117874.05106 | 37.7960445944406 | -122.39686919997 | (37.7960445944406, -122.39686919997) | |||
62669 | 62669 | 195221 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Phelps St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 7ft | 6014598.7472 | 2097125.5339900001 | 37.739127958984106 | -122.392043559277 | (37.7391279589841, -122.392043559277) | |||
67913 | 67913 | 135584 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6013720.96572 | 2117170.97741 | 37.7941195344513 | -122.39648326760201 | (37.7941195344513, -122.396483267602) | |||
123746 | 123746 | 135581 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 22 Drumm St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 7ft | 6013732.77285 | 2117082.9490900002 | 37.7938784864461 | -122.39643624024099 | (37.7938784864461, -122.396436240241) | |||
129785 | 129785 | 135594 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013641.29963 | 2117738.5675 | 37.7956735692465 | -122.396798733574 | (37.7956735692465, -122.396798733574) | |||
133666 | 133666 | 135589 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6013690.1191300005 | 2117409.79568 | 37.79477355652 | -122.396606749907 | (37.79477355652, -122.396606749907) | |||
146587 | 146587 | 135587 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6013707.40444 | 2117263.065 | 37.794371630605795 | -122.39653664955699 | (37.7943716306058, -122.396536649557) | |||
147917 | 147917 | 135592 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 7ft | 6013656.57361 | 2117641.2066 | 37.7954070893311 | -122.39673905365801 | (37.7954070893311, -122.396739053658) | |||
147962 | 147962 | 195223 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Phelps St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 7ft | 6014580.60262 | 2097100.86929 | 37.7390592273959 | -122.392104571083 | (37.7390592273959, -122.392104571083) | |||
150043 | 150043 | 135601 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013619.0965 | 2117904.14877 | 37.7961269804374 | -122.396887175602 | (37.7961269804374, -122.396887175602) | |||
150266 | 150266 | 135599 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013626.9255 | 2117849.56722 | 37.7959775481806 | -122.39685625692499 | (37.7959775481806, -122.396856256925) | |||
150944 | 150944 | 135124 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6009811.99757 | 2122478.3969 | 37.8084740875856 | -122.41038369905701 | (37.8084740875856, -122.410383699057) | |||
153591 | 153591 | 135582 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013728.8853 | 2117108.6329200002 | 37.7939487918665 | -122.396451492763 | (37.7939487918665, -122.396451492763) | |||
163339 | 163339 | 135128 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 7ft | 6009778.15443 | 2122482.07693 | 37.808482294798104 | -122.410501083081 | (37.8084822947981, -122.410501083081) | |||
166163 | 166163 | 195224 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 Phelps St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 7ft | 6014570.35716 | 2097088.14635 | 37.7390237239721 | -122.392139105952 | (37.7390237239721, -122.392139105952) | |||
168848 | 168848 | 135596 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 7ft | 6013635.89834 | 2117779.6494400003 | 37.7957860699142 | -122.396820304724 | (37.7957860699142, -122.396820304724) | |||
171564 | 171564 | 135597 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 160x Drumm St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 7ft | 6013633.10727 | 2117805.98643 | 37.7958582297137 | -122.39683180976299 | (37.7958582297137, -122.396831809763) | |||
173411 | 173411 | 235416 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 186 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 7ft | 6005136.25452 | 2104017.07446 | 37.757520641669295 | -122.425250855854 | (37.7575206416693, -122.425250855854) | |||
177428 | 177428 | 135583 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6013725.73224 | 2117134.30218 | 37.794019098152205 | -122.396464202864 | (37.7940190981522, -122.396464202864) | |||
179167 | 179167 | 135588 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6013703.14985 | 2117288.7562700002 | 37.794441936008894 | -122.39655317280899 | (37.7944419360089, -122.396553172809) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");