Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PermitNotes
qSiteInfo ✖
qCareAssistant ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40050 | 40050 | 176160 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990378.89561 | 2089837.21304 | 37.7177416175535 | -122.47525201947701 | (37.7177416175535, -122.475252019477) | ||||
175601 | 175601 | 176161 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990361.86615 | 2090050.7376 | 37.718326916127204 | -122.475326462647 | (37.7183269161272, -122.475326462647) | ||||
183376 | 183376 | 176159 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5989661.71527 | 2090692.2421799998 | 37.720047719404 | -122.477793431626 | (37.720047719404, -122.477793431626) | ||||
130707 | 130707 | 190965 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 24th St | 17 | : Yard 23 | Tree 1 | Private 1 | 6 | 6017293.94065 | 2102634.4333599997 | 37.754403540203796 | -122.38310803210899 | (37.7544035402038, -122.383108032109) | ||||
164784 | 164784 | 246716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Bonview St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | 6007832.06726 | 2099366.51815 | 37.744903194719704 | -122.415598362177 | (37.7449031947197, -122.415598362177) | ||||
166002 | 166002 | 246711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Bonview St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6007747.55824 | 2099198.25056 | 37.7444364187148 | -122.415878666471 | (37.7444364187148, -122.415878666471) | ||||
139692 | 139692 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Cascade Walk | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | |||||
44565 | 44565 | 201717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6017089.1408 | 2095350.86435 | 37.7343930239173 | -122.38330932287201 | (37.7343930239173, -122.383309322872) | ||||
51235 | 51235 | 201716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017085.9132900005 | 2095352.6498 | 37.7343977480421 | -122.38332060578001 | (37.7343977480421, -122.38332060578) | ||||
55847 | 55847 | 201720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017109.38533 | 2095355.2358400002 | 37.734406145933704 | -122.383239634411 | (37.7344061459337, -122.383239634411) | ||||
58146 | 58146 | 201718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6017093.28201 | 2095356.3247099998 | 37.7344082458391 | -122.38329538517401 | (37.7344082458391, -122.383295385174) | ||||
65706 | 65706 | 201723 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6017160.60225 | 2095378.34378 | 37.734472425960895 | -122.383064166774 | (37.7344724259609, -122.383064166774) | ||||
146514 | 146514 | 201719 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6017095.79964 | 2095357.4210400002 | 37.7344113952763 | -122.38328675710501 | (37.7344113952763, -122.383286757105) | ||||
167728 | 167728 | 201724 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6017165.24184 | 2095383.9343 | 37.7344880327856 | -122.383048514986 | (37.7344880327856, -122.383048514986) | ||||
4884 | 4884 | 253710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
4891 | 4891 | 253709 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
4893 | 4893 | 253707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
4898 | 4898 | 253711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 5 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
4906 | 4906 | 253708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
44939 | 44939 | 223816 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 45 | Width 5ft | 6002135.08017 | 2096585.1811900001 | 37.7369444095655 | -122.435098574335 | (37.7369444095655, -122.435098574335) | |||
26075 | 26075 | 206897 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Pizarro Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995088.9482 | 2093956.7124599998 | 37.729324653504 | -122.459269738418 | (37.729324653504, -122.459269738418) | |||
76009 | 76009 | 206898 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Pizarro Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995090.77505 | 2093954.0978400002 | 37.7293175794217 | -122.459263233611 | (37.7293175794217, -122.459263233611) | |||
130353 | 130353 | 206896 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Pizarro Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995094.72754 | 2093951.90742 | 37.729311792297395 | -122.459249411033 | (37.7293117922974, -122.459249411033) | |||
182357 | 182357 | 206895 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Pizarro Way | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995113.71049 | 2093937.45787 | 37.729273208687204 | -122.459182739799 | (37.7292732086872, -122.459182739799) | |||
68489 | 68489 | 176113 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Santa Barbara Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5993424.30452 | 2086604.0814 | 37.709040256765 | -122.464490865868 | (37.709040256765, -122.464490865868) | |||
49019 | 49019 | 217851 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Woodacre Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5991372.3988 | 2095655.7532099998 | 37.7337754172003 | -122.47224186449301 | (37.7337754172003, -122.472241864493) | ||||
51562 | 51562 | 218296 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Woodacre Dr | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | 5991178.95125 | 2095337.5178200002 | 37.732890425845106 | -122.47288746619499 | (37.7328904258451, -122.472887466195) | ||||
65855 | 65855 | 217846 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Woodacre Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 54 | 5991427.317980001 | 2095733.50913 | 37.733992093541396 | -122.47205765993601 | (37.7339920935414, -122.472057659936) | ||||
136840 | 136840 | 217847 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Woodacre Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | 5991420.07679 | 2095725.93853 | 37.7339708875491 | -122.472082143088 | (37.7339708875491, -122.472082143088) | ||||
175849 | 175849 | 218295 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Woodacre Dr | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | 5991182.782880001 | 2095348.63112 | 37.7329211619833 | -122.47287502947701 | (37.7329211619833, -122.472875029477) | ||||
136019 | 136019 | 206848 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Brotherhood Way | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5993673.9414 | 2087579.0167599998 | 37.7117315859181 | -122.46369880328001 | (37.7117315859181, -122.46369880328) | |||
137802 | 137802 | 206847 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Brotherhood Way | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5993688.70591 | 2087590.2808700001 | 37.711763365253894 | -122.463648590504 | (37.7117633652539, -122.463648590504) | |||
156086 | 156086 | 206846 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 0ft | 5993694.0595 | 2087568.4676400002 | 37.7117037797802 | -122.463628505047 | (37.7117037797802, -122.463628505047) | |||
30768 | 30768 | 223720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Crescent Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6005295.72226 | 2095902.89747 | 37.7352499770995 | -122.424122309196 | (37.7352499770995, -122.424122309196) | |||
67552 | 67552 | 223719 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Crescent Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 3ft | 6005300.64092 | 2095902.62438 | 37.735249504969104 | -122.424105284154 | (37.7352495049691, -122.424105284154) | |||
35639 | 35639 | 176145 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 6 | : 4 | Tree 1 | Private 1 | 41 | Width 0ft | 5987592.83524 | 2090286.1257900002 | 37.7188123395933 | -122.484914976763 | (37.7188123395933, -122.484914976763) | |||
38808 | 38808 | 176142 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 2 | : 4 | Tree 1 | Private 1 | 38 | Width 0ft | 5987571.34971 | 2089706.0579 | 37.7172183686082 | -122.48494670935 | (37.7172183686082, -122.48494670935) | |||
44967 | 44967 | 176143 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 4 | : 4 | Tree 1 | Private 1 | 60 | Width 0ft | 5987585.53383 | 2089941.9294099999 | 37.7178668382624 | -122.48491497676201 | (37.7178668382624, -122.484914976762) | |||
45769 | 45769 | 176148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 9 | : 4 | Tree 1 | Private 1 | 34 | Width 0ft | 5987583.49684 | 2090495.06547 | 37.7193854910228 | -122.484962576086 | (37.7193854910228, -122.484962576086) | |||
46715 | 46715 | 176139 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5987453.25598 | 2088569.38174 | 37.714090463565796 | -122.485271539962 | (37.7140904635658, -122.485271539962) | |||
49614 | 49614 | 176138 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5987453.76086 | 2088540.35852 | 37.714010802520704 | -122.485267666593 | (37.7140108025207, -122.485267666593) | |||
67783 | 67783 | 176150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 11 | : 4 | Tree 1 | Private 1 | 36 | Width 0ft | 5987592.48981 | 2090630.47985 | 37.7197578283347 | -122.484941420412 | (37.7197578283347, -122.484941420412) | |||
71082 | 71082 | 176144 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 5 | : 4 | Tree 1 | Private 1 | 39 | Width 0ft | 5987593.26623 | 2090234.31177 | 37.7186700965335 | -122.484909687836 | (37.7186700965335, -122.484909687836) | |||
72073 | 72073 | 176140 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5987455.898580001 | 2088588.29538 | 37.7141425496068 | -122.48526379321501 | (37.7141425496068, -122.485263793215) | |||
136102 | 136102 | 176147 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 8 | : 4 | Tree 1 | Private 1 | 40 | Width 0ft | 5987595.02111 | 2090461.3006400003 | 37.7192934526127 | -122.484920265678 | (37.7192934526127, -122.484920265678) | |||
149666 | 149666 | 176149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 10 | : 4 | Tree 1 | Private 1 | 58 | Width 0ft | 5987588.89275 | 2090533.04242 | 37.7194900803794 | -122.48494670933998 | (37.7194900803794, -122.48494670934) | |||
171157 | 171157 | 176146 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 7 | : 4 | Tree 1 | Private 1 | 40 | Width 0ft | 5987590.810219999 | 2090334.9259400002 | 37.7189462144818 | -122.48492555458999 | (37.7189462144818, -122.48492555459) | |||
174101 | 174101 | 176141 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 1 | : 4 | Tree 1 | Private 1 | 48 | Width 0ft | 5987562.65817 | 2089512.7313599999 | 37.7166870365437 | -122.484962576069 | (37.7166870365437, -122.484962576069) | |||
184095 | 184095 | 176151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 12 | : 4 | Tree 1 | Private 1 | 28 | Width 0ft | 5987601.77319 | 2090779.60025 | 37.7201678157831 | -122.484920265686 | (37.7201678157831, -122.484920265686) | |||
119121 | 119121 | 176115 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Skyline Blvd | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5982387.31367 | 2092831.90061 | 37.7254977881756 | -122.503096467121 | (37.7254977881756, -122.503096467121) | |||
178699 | 178699 | 176116 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Skyline Blvd | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5982365.02042 | 2092827.7229400002 | 37.725485007020296 | -122.503173222486 | (37.7254850070203, -122.503173222486) | |||
60160 | 60160 | 223790 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Storrie St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000695.90206 | 2105313.46128 | 37.7608283472609 | -122.44070032905701 | (37.7608283472609, -122.440700329057) | |||
62231 | 62231 | 176114 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Zoo Rd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 10ft | 5982696.49512 | 2094384.4536 | 37.729778850703894 | -122.502142508582 | (37.7297788507039, -122.502142508582) | |||
113837 | 113837 | 116669 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Esmeralda Ave | 6 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 20 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | ||||
131331 | 131331 | 206802 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 5994234.49251 | 2106025.56842 | 37.762413528276205 | -122.463098978843 | (37.7624135282762, -122.463098978843) | |||
110956 | 110956 | 118356 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 RACCOON DR | 2 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 48 | 5998776.0 | 2103987.0 | 37.7570766935068 | -122.44724492231701 | (37.7570766935068, -122.447244922317) | ||||
5091 | 5091 | 253769 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Raccoon Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998692.0 | 2104165.0 | 37.7575606372552 | -122.44754823773899 | (37.7575606372552, -122.447548237739) | |||||
5096 | 5096 | 253768 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998692.0 | 2104165.0 | 37.7575606372552 | -122.44754823773899 | (37.7575606372552, -122.447548237739) | |||||
886 | 886 | 19568 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
6533 | 6533 | 19565 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
8903 | 8903 | 19566 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | -9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
10571 | 10571 | 19570 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
10705 | 10705 | 19569 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY1 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 100ST | ||||||||
7938 | 7938 | 19700 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY11 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 40ST | ||||||||
15767 | 15767 | 19699 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 40ST | ||||||||
13158 | 13158 | 19753 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY15 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
5855 | 5855 | 19776 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY18 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
9072 | 9072 | 19804 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY22 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20 | ||||||||
14206 | 14206 | 19813 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY24 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
12151 | 12151 | 19869 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY33 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 25ST | ||||||||
6023 | 6023 | 19905 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
6147 | 6147 | 19906 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
6517 | 6517 | 19907 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
10816 | 10816 | 19910 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
15771 | 15771 | 19908 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 120ST | ||||||||
16878 | 16878 | 19909 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY35 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 120ST | ||||||||
6952 | 6952 | 19935 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
10674 | 10674 | 19936 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
10949 | 10949 | 19933 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
14400 | 14400 | 19934 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
14992 | 14992 | 19932 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
15978 | 15978 | 19943 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY38 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
6834 | 6834 | 19955 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2ST | ||||||||
7732 | 7732 | 19948 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
7886 | 7886 | 19945 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
11220 | 11220 | 19950 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
12812 | 12812 | 19953 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
16424 | 16424 | 19949 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 25ST | ||||||||
16608 | 16608 | 19951 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
16721 | 16721 | 19947 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY39 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 25ST | ||||||||
17092 | 17092 | 19978 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY45 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 30ST | ||||||||
13184 | 13184 | 20013 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY47 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
14425 | 14425 | 19694 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 STAIRWAY7 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 12ST | ||||||||
42268 | 42268 | 53726 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1972 12:00:00 AM | 8 | Permit Number 9405 | 6012451.87174 | 2095251.14558 | 37.733861851932296 | -122.399334980939 | (37.7338618519323, -122.399334980939) | ||
185031 | 185031 | 190987 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Topeka Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6012468.98817 | 2095242.94143 | 37.7338402790006 | -122.39927522817 | (37.7338402790006, -122.39927522817) | |||
123752 | 123752 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Vasquez Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | |||||
122936 | 122936 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000 ESMERALDA AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009839.0 | 2098688.0 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | ||||||
1822 | 1822 | 251717 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000X San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004710.0 | 2096486.0 | 37.736817957153605 | -122.426188866367 | (37.7368179571536, -122.426188866367) | |||||
50101 | 50101 | 121189 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
145554 | 145554 | 121180 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000x Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) |
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");