Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCareAssistant
qCaretaker ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6680 | 6680 | 112268 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
6704 | 6704 | 112269 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
10998 | 10998 | 112267 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
110441 | 110441 | 28300 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5995887.0 | 2088090.0 | 37.713261901345 | -122.45608683538099 | (37.713261901345, -122.456086835381) | |||
10130 | 10130 | 173876 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009764.0 | 2087931.0 | 37.7136120890563 | -122.408111727364 | (37.7136120890563, -122.408111727364) | ||||
129433 | 129433 | 101290 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 830 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769326 | 6001055.4 | 2088979.9 | 37.7160006775821 | -122.438286819162 | (37.7160006775821, -122.438286819162) | ||||
98164 | 98164 | 112394 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2 AMAZON AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6000472.0 | 2089324.0 | 37.7169122992795 | -122.440327982322 | (37.7169122992795, -122.440327982322) | ||||
94791 | 94791 | 119280 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 95 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995293.0 | 2090512.0 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | ||||
114487 | 114487 | 119279 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 95 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995293.0 | 2090512.0 | 37.7198780283713 | -122.458315087488 | (37.7198780283713, -122.458315087488) | ||||
95981 | 95981 | 28249 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3340 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011954.935487099 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | |||
103657 | 103657 | 28250 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3340 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6011954.935487099 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | |||
97718 | 97718 | 29407 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2801X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6014804.18454 | 2090650.03815 | 37.7213589569903 | -122.390880803843 | (37.7213589569903, -122.390880803843) | |||
115129 | 115129 | 15751 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4621 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002118.3239400005 | 2091946.5490400002 | 37.7242068323306 | -122.434824887315 | (37.7242068323306, -122.434824887315) | |||
83736 | 83736 | 111200 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 801x CAYUGA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001252.0 | 2092235.0 | 37.724949629008705 | -122.437840285791 | (37.7249496290087, -122.437840285791) | ||||
105308 | 105308 | 25271 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
110854 | 110854 | 25270 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
112191 | 112191 | 25272 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
120838 | 120838 | 25273 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1800 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 5994503.82801 | 2092400.8361900002 | 37.725018937185 | -122.461179802839 | (37.725018937185, -122.461179802839) | |||
79426 | 79426 | 116125 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
92983 | 92983 | 116128 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
117524 | 117524 | 116126 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
141081 | 141081 | 116127 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.39307534923799 | (37.7252886606488, -122.393075349238) | |||||
94792 | 94792 | 26275 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1770 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 6000824.4471487 | 2093863.5491185002 | 37.729396929882704 | -122.43943496951599 | (37.7293969298827, -122.439434969516) | |||
113651 | 113651 | 57604 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 238 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/1976 12:00:00 AM | 3x3 | Permit Number 16491 | 5999828.22001193 | 2094390.77346711 | 37.730787818817504 | -122.44291685523399 | (37.7307878188175, -122.442916855234) | ||
95716 | 95716 | 108971 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 20x ROUSSEAU ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003466.0 | 2095297.3 | 37.73348366525929 | -122.43040513204599 | (37.7334836652593, -122.430405132046) | ||||
128824 | 128824 | 26153 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500 Oakdale Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | |||
118679 | 118679 | 95409 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2885 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Added tree to database on 2/28/11. Appears to be 15-20 yrs old. | 6002410.0 | 2095371.0 | 37.733626154005705 | -122.434061286386 | (37.7336261540057, -122.434061286386) | ||
98939 | 98939 | 44172 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 59 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2000 12:00:00 AM | Permit Number 43639 | 6003760.97911216 | 2095401.48581894 | 37.733786440894 | -122.42939273268401 | (37.733786440894, -122.429392732684) | |||
110025 | 110025 | 5136 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2842 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 1x1 | 6002395.529069999 | 2095496.33738 | 37.7339694804636 | -122.43412027337799 | (37.7339694804636, -122.434120273378) | |||
114654 | 114654 | 95413 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 691 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2016 12:00:00 AM | 12 | 3x3 | Permit Number 779045 | 6002523.0 | 2095666.0 | 37.734442568942704 | -122.433691689524 | (37.7344425689427, -122.433691689524) | |
139753 | 139753 | 109235 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 670 CHENERY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 6002570.3 | 2095716.9 | 37.734585012482796 | -122.433531794387 | (37.7345850124828, -122.433531794387) | ||||
127933 | 127933 | 92818 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 95 Burlwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2009 12:00:00 AM | 3x3 | Permit Number 53027 | 5996883.0 | 2096019.0 | 37.7350901820695 | -122.453216393363 | (37.7350901820695, -122.453216393363) | ||
79382 | 79382 | 22281 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4755X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 18 | 3X3 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | |||
139075 | 139075 | 59431 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3033 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1980 12:00:00 AM | 14 | 3x3 | Permit Number 18793 | 6002899.25612306 | 2096070.04882186 | 37.735573337111795 | -122.432419698468 | (37.7355733371118, -122.432419698468) | |
78462 | 78462 | 108945 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 105 Richland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |||||
87077 | 87077 | 108943 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 105 Richland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |||||
103029 | 103029 | 25995 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1781 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6014085.16035 | 2096167.03762 | 37.7364675981514 | -122.39375225191002 | (37.7364675981514, -122.39375225191) | |||
116985 | 116985 | 15649 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3718 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6005292.79028 | 2096596.9224099999 | 37.7371554485093 | -122.42418178868999 | (37.7371554485093, -122.42418178869) | |||
128983 | 128983 | 15650 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3718 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6005292.79028 | 2096596.9224099999 | 37.7371554485093 | -122.42418178868999 | (37.7371554485093, -122.42418178869) | |||
83588 | 83588 | 6719 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
86611 | 86611 | 6726 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
93092 | 93092 | 6705 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
107944 | 107944 | 6709 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
113171 | 113171 | 6722 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
122890 | 122890 | 6721 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
126237 | 126237 | 6727 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Fairfax Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
19468 | 19468 | 6756 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
58954 | 58954 | 11429 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016007.44377 | 2096780.4211400002 | 37.738258459777605 | -122.38714881562599 | (37.7382584597776, -122.387148815626) | |||
88023 | 88023 | 6773 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1355 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016787.8631263 | 2097291.0360598997 | 37.7397036915046 | -122.38448604022699 | (37.7397036915046, -122.384486040227) | |||
142537 | 142537 | 6788 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | |||
89158 | 89158 | 6799 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1375 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x9 | 6016685.620596901 | 2097367.3215875 | 37.73990750174121 | -122.384844867735 | (37.7399075017412, -122.384844867735) | |||
115244 | 115244 | 25558 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 50X Industrial St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2001 12:00:00 AM | 8 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | ||
87520 | 87520 | 6801 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1385 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6016634.4993322 | 2097405.4643513 | 37.7400094064471 | -122.38502428222701 | (37.7400094064471, -122.385024282227) | |||
113479 | 113479 | 6808 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1395 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | |||
138580 | 138580 | 33586 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 248 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2006 12:00:00 AM | 3x3 | Permit Number 48813 | 6006863.32350459 | 2097675.63643968 | 37.740205910019704 | -122.418828210102 | (37.7402059100197, -122.418828210102) | ||
84017 | 84017 | 6816 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
108134 | 108134 | 6817 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
139108 | 139108 | 6818 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
145043 | 145043 | 6815 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
79552 | 79552 | 14994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016235.7427248005 | 2097702.9858463 | 37.7408042749191 | -122.38642376985001 | (37.7408042749191, -122.38642376985) | |||
77710 | 77710 | 6828 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
104985 | 104985 | 27857 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
117415 | 117415 | 6829 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
126966 | 126966 | 6825 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1450X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
108226 | 108226 | 4883 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 87 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X2 | 6000657.525159299 | 2098217.505729 | 37.7413423773337 | -122.44032415487499 | (37.7413423773337, -122.440324154875) | |||
122662 | 122662 | 5728 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1688 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005263.116177299 | 2098508.6699422 | 37.742402999925 | -122.42442032403 | (37.742402999925, -122.42442032403) | |||
86670 | 86670 | 59066 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1658 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/16/1980 12:00:00 AM | Permit Number 18361 | 6003975.177671 | 2098610.37486855 | 37.7426094440159 | -122.428880876877 | (37.7426094440159, -122.428880876877) | |||
124876 | 124876 | 4501 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1748 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6004612.9512322 | 2098708.9638206 | 37.74291622476 | -122.4266826598 | (37.74291622476, -122.4266826598) | |||
112792 | 112792 | 112396 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 574 VALLEY ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6002248.0 | 2099192.0 | 37.7441085392299 | -122.434894531673 | (37.7441085392299, -122.434894531673) | ||||
10165 | 10165 | 173892 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007185.0 | 2099410.0 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | ||||
10172 | 10172 | 173891 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007185.0 | 2099410.0 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | ||||
87573 | 87573 | 4493 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1616 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004570.9658455 | 2099475.4807252 | 37.745018530631796 | -122.42688241226101 | (37.7450185306318, -122.426882412261) | |||
119613 | 119613 | 706 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1509X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6005302.4951599995 | 2099477.85942 | 37.745066397258604 | -122.424353081707 | (37.7450663972586, -122.424353081707) | |||
19843 | 19843 | 99594 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | |||
108974 | 108974 | 99595 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1855X Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | |||
97086 | 97086 | 39773 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 112 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/2001 12:00:00 AM | 14 | 6x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.745486997298705 | -122.424877067697 | (37.7454869972987, -122.424877067697) |
105026 | 105026 | 39774 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 112 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/1999 12:00:00 AM | 14 | 5.5x6 | Permit Number 41140 | 6005154.17276637 | 2099634.09116827 | 37.745486997298705 | -122.424877067697 | (37.7454869972987, -122.424877067697) | |
94126 | 94126 | 113702 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 14 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6007138.0 | 2099599.0 | 37.7455024988094 | -122.418014802057 | (37.7455024988094, -122.418014802057) | |||
99501 | 99501 | 113188 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x12 | 6007151.0 | 2099622.0 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | |||
128750 | 128750 | 113701 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6007151.0 | 2099622.0 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | |||
87941 | 87941 | 44245 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2001 12:00:00 AM | Permit Number 43680 | 6010447.16728471 | 2099896.56831072 | 37.7465052482739 | -122.406593130128 | (37.7465052482739, -122.406593130128) | |||
142149 | 142149 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.42854357326401 | (37.7469027259862, -122.428543573264) | ||||
111276 | 111276 | 702 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1399X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005246.2674799 | 2100192.367786 | 37.747025098470004 | -122.42459832380699 | (37.74702509847, -122.424598323807) | |||
109528 | 109528 | 4281 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 4270 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2X2 | 6002137.7495821 | 2100347.8176818 | 37.7472758823749 | -122.435358414005 | (37.7472758823749, -122.435358414005) | |||
142910 | 142910 | 5655 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1332 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005148.498851901 | 2100582.0357256 | 37.7480895150856 | -122.424964119184 | (37.7480895150856, -122.424964119184) | |||
110961 | 110961 | 68840 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1506 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1993 12:00:00 AM | Permit Number 32793 | 6009553.56622839 | 2100554.07443475 | 37.748260580194895 | -122.4097295193 | (37.7482605801949, -122.4097295193) | |||
120738 | 120738 | 4455 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1404 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/13/2015 12:00:00 AM | 70 | 3X3 | 6004493.5375 | 2100668.30282 | 37.7482893665971 | -122.42723509655899 | (37.7482893665971, -122.427235096559) | ||
122470 | 122470 | 112646 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3101 26TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008718.0 | 2100791.0 | 37.748864265204396 | -122.412635640211 | (37.7488642652044, -122.412635640211) | |||
144697 | 144697 | 5633 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1256 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005118.39805 | 2100997.74937 | 37.749229268656 | -122.425097781596 | (37.749229268656, -122.425097781596) | |||
101152 | 101152 | 4559 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1250X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 10x6 | 6005144.059593299 | 2101075.0968608996 | 37.749443096612204 | -122.425014546007 | (37.7494430966122, -122.425014546007) | |||
90516 | 90516 | 20972 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
95236 | 95236 | 20974 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
97048 | 97048 | 20975 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2002X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
116882 | 116882 | 98224 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4068 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2012 12:00:00 AM | 3x3 | Permit Number 56734 | 6003417.8 | 2101304.1 | 37.7499742222019 | -122.43100033681401 | (37.7499742222019, -122.431000336814) | ||
88597 | 88597 | 5622 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1202 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6005101.96034 | 2101291.72603 | 37.750035532108605 | -122.425175538874 | (37.7500355321086, -122.425175538874) | |||
104023 | 104023 | 57425 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3870 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/1976 12:00:00 AM | 20 | 6x10 | Permit Number 16267 | 6004690.36073914 | 2101363.26470881 | 37.750208699935996 | -122.426603966833 | (37.750208699936, -122.426603966833) | |
121214 | 121214 | 96335 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3705 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | Permit Number 28622 | 6005781.0 | 2101380.0 | 37.750316249248904 | -122.422833652647 | (37.7503162492489, -122.422833652647) | ||
80162 | 80162 | 110730 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3515 25TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006381.0 | 2101411.0 | 37.7504352040325 | -122.42076100913799 | (37.7504352040325, -122.420761009138) | ||||
83244 | 83244 | 110731 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3515 25TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006381.0 | 2101411.0 | 37.7504352040325 | -122.42076100913799 | (37.7504352040325, -122.420761009138) | ||||
107919 | 107919 | 110733 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3515 25TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006381.0 | 2101411.0 | 37.7504352040325 | -122.42076100913799 | (37.7504352040325, -122.420761009138) |
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");