Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantDate, PlotSize, PermitNotes
| 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) | |||
| 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) | |||||
| 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) | ||||||
| 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) | ||||
| 35718 | 35718 | 223696 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6005111.39586 | 2096784.72517 | 37.7376608688401 | -122.42482230911999 | (37.7376608688401, -122.42482230912) | ||||
| 58052 | 58052 | 223695 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005104.91543 | 2096758.07935 | 37.73758733938811 | -122.42484281995701 | (37.7375873393881, -122.424842819957) | ||||
| 132735 | 132735 | 223694 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 65 | 6005104.45792 | 2096735.8383799999 | 37.7375262448502 | -122.424842819945 | (37.7375262448502, -122.424842819945) | ||||
| 146111 | 146111 | 223697 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6005304.12461 | 2097202.65687 | 37.738819299062904 | -122.424185667341 | (37.7388192990629, -122.424185667341) | ||||
| 549 | 549 | 251321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | ||||||||||
| 10255 | 10255 | 112606 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5999003.0 | 2105766.0 | 37.761974353511896 | -122.446587863076 | (37.7619743535119, -122.446587863076) | ||||
| 9172 | 9172 | 173599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Warren Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5995367.0 | 2102770.0 | 37.7535397418859 | -122.458946354326 | (37.7535397418859, -122.458946354326) | |||
| 83377 | 83377 | 87064 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2007 12:00:00 AM | Permit Number 50006 | 6001805.0 | 2096722.0 | 37.737301333655 | -122.436249595043 | (37.737301333655, -122.436249595043) | |||
| 84753 | 84753 | 108074 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 BUENA VISTA AVE EAST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001336.0 | 2108482.0 | 37.769564805176394 | -122.438713569331 | (37.7695648051764, -122.438713569331) | ||||
| 2151 | 2151 | 252916 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001472.0 | 2098865.0 | 37.7431665844065 | -122.437554349716 | (37.7431665844065, -122.437554349716) | ||||
| 145393 | 145393 | 98880 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Lansdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5994747.9 | 2097283.1 | 37.738438484278895 | -122.460689725403 | (37.7384384842789, -122.460689725403) | ||||
| 108351 | 108351 | 106363 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 URBANO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 80 | 5993535.8 | 2092458.1 | 37.7251204132224 | -122.464530299025 | (37.7251204132224, -122.464530299025) | ||||
| 109226 | 109226 | 109516 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 105 MIDCREST WAY | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 12x12 | 5998180.4 | 2101012.8 | 37.748876224655795 | -122.4490904711 | (37.7488762246558, -122.4490904711) | ||||
| 64824 | 64824 | 205899 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 106 Miraloma Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994504.976530001 | 2097169.62353 | 37.7381129265739 | -122.461521406103 | (37.7381129265739, -122.461521406103) | |||
| 186232 | 186232 | 205900 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 106 Miraloma Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5994506.11445 | 2097146.60332 | 37.7380497842769 | -122.461515803309 | (37.7380497842769, -122.461515803309) | |||
| 155412 | 155412 | 223726 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 107 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 7ft | 6007259.15325 | 2098682.1985299997 | 37.742991985195104 | -122.41753090725 | (37.7429919851951, -122.41753090725) | |||
| 66371 | 66371 | 223725 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 109 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 34 | Width 10ft | 6007250.83201 | 2098665.28415 | 37.742945073859794 | -122.417558481357 | (37.7429450738598, -122.417558481357) | |||
| 76030 | 76030 | 206838 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 11 Edgehill Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | 5994833.8129199995 | 2099043.81007 | 37.7432778994565 | -122.460520231332 | (37.7432778994565, -122.460520231332) | ||||
| 185755 | 185755 | 205895 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5995734.854669999 | 2096206.24435 | 37.7355384364582 | -122.457199459482 | (37.7355384364582, -122.457199459482) | |||
| 165726 | 165726 | 205902 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Kensington Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5994974.56869 | 2098324.33345 | 37.741310492185605 | -122.45998142862699 | (37.7413104921856, -122.459981428627) | |||
| 180949 | 180949 | 205903 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 110 Kensington Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994961.52752 | 2098342.73028 | 37.7413602552605 | -122.460027852509 | (37.7413602552605, -122.460027852509) | |||
| 25090 | 25090 | 223699 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 72 | 6004901.063490001 | 2096745.81285 | 37.737542142145706 | -122.425546760699 | (37.7375421421457, -122.425546760699) | ||||
| 33033 | 33033 | 223700 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004786.16622 | 2096652.60405 | 37.7372797190785 | -122.42593738210199 | (37.7372797190785, -122.425937382102) | ||||
| 49562 | 49562 | 223703 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004573.37155 | 2096423.41392 | 37.7366383864359 | -122.426656795699 | (37.7366383864359, -122.426656795699) | ||||
| 137317 | 137317 | 223704 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6004560.21701 | 2096406.8969299998 | 37.7365922907993 | -122.426701100777 | (37.7365922907993, -122.426701100777) | ||||
| 152523 | 152523 | 223698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 151 | 6004903.42732 | 2096771.39372 | 37.7376125150086 | -122.42554040785801 | (37.7376125150086, -122.425540407858) | ||||
| 152844 | 152844 | 223706 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 80 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004536.52923 | 2096375.8684900003 | 37.736505754442504 | -122.42678079059999 | (37.7365057544425, -122.4267807906) | ||||
| 159461 | 159461 | 223702 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6004596.80195 | 2096429.4382 | 37.7366562523786 | -122.426576215516 | (37.7366562523786, -122.426576215516) | ||||
| 176054 | 176054 | 223701 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 9ft | 6004786.9856 | 2096684.12369 | 37.7373663112035 | -122.425936792158 | (37.7373663112035, -122.425936792158) | |||
| 181738 | 181738 | 223705 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6004537.44257 | 2096386.8120900001 | 37.7365358547364 | -122.426778411906 | (37.7365358547364, -122.426778411906) | ||||
| 34710 | 34710 | 223715 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004750.57812 | 2096360.89303 | 37.736476735096296 | -122.426039666491 | (37.7364767350963, -122.426039666491) | ||||
| 47893 | 47893 | 223716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004761.80581 | 2096370.25265 | 37.7365030690611 | -122.42600151366399 | (37.7365030690611, -122.426001513664) | ||||
| 137779 | 137779 | 223717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | 6005027.45143 | 2096662.24212 | 37.737319816266705 | -122.425103832873 | (37.7373198162667, -122.425103832873) | ||||
| 166767 | 166767 | 223718 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 59 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6005036.8773300005 | 2096676.581 | 37.7373597200698 | -122.42507226308999 | (37.7373597200698, -122.42507226309) | ||||
| 41442 | 41442 | 205894 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 3ft | 5998252.60091 | 2095669.89095 | 37.7342100154709 | -122.44845607881099 | (37.7342100154709, -122.448456078811) | |||
| 175698 | 175698 | 205893 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1110 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 5998235.76076 | 2095666.83858 | 37.734200671531504 | -122.448514080556 | (37.7342006715315, -122.448514080556) | |||
| 139657 | 139657 | 117644 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1111X SANSOME ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x30 | 6011937.0 | 2119613.0 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) |
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");