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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135146 | 135146 | 175875 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 670 Brunswick St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998788.01102 | 2086736.62559 | 37.709711931626394 | -122.445962702139 | (37.7097119316264, -122.445962702139) | ||||
135743 | 135743 | 222993 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | 6002546.229730001 | 2099483.20236 | 37.7449250410506 | -122.43388413076 | (37.7449250410506, -122.43388413076) | ||||
137397 | 137397 | 214320 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1518 05th Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5994627.9467 | 2105254.67875 | 37.7603195216609 | -122.46168228042801 | (37.7603195216609, -122.461682280428) | ||||
137512 | 137512 | 179979 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998643.39451 | 2086681.70368 | 37.709552869435896 | -122.44645857210399 | (37.7095528694359, -122.446458572104) | ||||
137734 | 137734 | 197516 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6009818.3758 | 2109520.83011 | 37.772896097121894 | -122.40944654343299 | (37.7728960971219, -122.409446543433) | ||||
137842 | 137842 | 233341 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 181 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6006970.42421 | 2098142.10929 | 37.7414927703813 | -122.418490966799 | (37.7414927703813, -122.418490966799) | ||||
138125 | 138125 | 199573 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1399 De Haro St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6012315.17384 | 2101950.7126 | 37.7522498176817 | -122.400277978566 | (37.7522498176817, -122.400277978566) | ||||
139163 | 139163 | 116411 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 600x GRANT AVE | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6011037.0 | 2116673.0 | 37.7926024798136 | -122.405735030164 | (37.7926024798136, -122.405735030164) | |||||
139331 | 139331 | 117386 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1601 POLK ST | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6006595.0 | 2116425.0 | 37.791672128860505 | -122.42108692021401 | (37.7916721288605, -122.421086920214) | |||||
143083 | 143083 | 101447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
143626 | 143626 | 96540 | Permitted Site 1 | Tree(s) :: 17 | 100 Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
143941 | 143941 | 32129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 35 Spofford Ln | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35491 | 6010554.96159279 | 2117351.45133924 | 37.7944383752725 | -122.407450761229 | (37.7944383752725, -122.407450761229) | ||
148175 | 148175 | 199603 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 628 Missouri St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6013523.6449 | 2104171.29494 | 37.7584143690574 | -122.39625448547501 | (37.7584143690574, -122.396254485475) | ||||
148664 | 148664 | 205684 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5991419.75521 | 2104444.35599 | 37.757909393427205 | -122.472718723697 | (37.7579093934272, -122.472718723697) | ||||
149598 | 149598 | 222992 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | 6002556.21356 | 2099484.40965 | 37.7449289225421 | -122.433849694824 | (37.7449289225421, -122.433849694824) | ||||
149734 | 149734 | 198011 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 250 Clara St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6011627.81903 | 2111614.0669299997 | 37.77874486142171 | -122.40333471393299 | (37.7787448614217, -122.403334713933) | ||||
149765 | 149765 | 233349 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 1847 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 6002644.4365300005 | 2100086.75284 | 37.7465878218663 | -122.433587675538 | (37.7465878218663, -122.433587675538) | ||||
150207 | 150207 | 116416 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 654 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6010952.55495 | 2116896.00924 | 37.793210086935396 | -122.40604293235701 | (37.7932100869354, -122.406042932357) | ||||
150454 | 150454 | 199572 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1399 De Haro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6012303.844380001 | 2101937.88969 | 37.752213976998895 | -122.400316257304 | (37.7522139769989, -122.400316257304) | ||||
150518 | 150518 | 100683 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6012308.796130001 | 2116830.37882 | 37.7931056432739 | -122.401345607834 | (37.7931056432739, -122.401345607834) | ||||
150797 | 150797 | 214670 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2250 15th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 5991762.46474 | 2100100.36567 | 37.7460017588674 | -122.47121701506398 | (37.7460017588674, -122.471217015064) | ||||
151278 | 151278 | 116414 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 616 Grant Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6010958.19294 | 2116856.3996900003 | 37.7931016439695 | -122.406020632759 | (37.7931016439695, -122.406020632759) | ||||
151900 | 151900 | 222989 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6002586.19946 | 2099486.51271 | 37.7449363986116 | -122.43374615947701 | (37.7449363986116, -122.433746159477) | ||||
152824 | 152824 | 101443 | Permitted Site 1 | Prunus persica :: Peach 330 | 771 Stockton Tunl | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Permit Number 25247 | 6010450.0538 | 2116823.4858 | 37.7929828371273 | -122.407776510606 | (37.7929828371273, -122.407776510606) | |||
153067 | 153067 | 199571 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1399 De Haro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6012297.36216 | 2101934.2505 | 37.75220362310421 | -122.400338418383 | (37.7522036231042, -122.400338418383) | ||||
155314 | 155314 | 100686 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6012251.79525 | 2116824.78932 | 37.7930871154393 | -122.401542442434 | (37.7930871154393, -122.401542442434) | ||||
155516 | 155516 | 116413 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 616 Grant Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6010963.21196 | 2116835.06885 | 37.7930433553227 | -122.40600176317801 | (37.7930433553227, -122.406001763178) | ||||
156380 | 156380 | 197515 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6009794.12284 | 2109513.9369200002 | 37.7728758110884 | -122.409529951052 | (37.7728758110884, -122.409529951052) | ||||
156800 | 156800 | 234495 | Undocumented 2 | Pinus muricata :: Bishop Pine 302 | 101 Prospect Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 6006979.85845 | 2098918.36092 | 37.74362471490279 | -122.418513376991 | (37.7436247149028, -122.418513376991) | ||||
157209 | 157209 | 179360 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 522 Sunnydale Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 6010043.89457 | 2086419.58682 | 37.709477722997 | -122.40703783884399 | (37.709477722997, -122.407037838844) | ||||
157783 | 157783 | 227304 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Castro St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002725.4323 | 2099066.84867 | 37.7437919986955 | -122.433234737486 | (37.7437919986955, -122.433234737486) | ||||
158001 | 158001 | 101444 | Permitted Site 1 | Prunus persica :: Peach 330 | 771 Stockton Tunl | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Permit Number 25247 | 6010458.7821 | 2116783.7237 | 37.7928741486166 | -122.40774350511002 | (37.7928741486166, -122.40774350511) | |||
159072 | 159072 | 227265 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6001689.18438 | 2099736.15615 | 37.7455709197615 | -122.436865735887 | (37.7455709197615, -122.436865735887) | ||||
159459 | 159459 | 234473 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | 6007295.70063 | 2098744.01488 | 37.7431637754778 | -122.417408915989 | (37.7431637754778, -122.417408915989) | ||||
160127 | 160127 | 222990 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | 6002575.82203 | 2099485.9676200002 | 37.744934313062004 | -122.433782003739 | (37.744934313062, -122.433782003739) | ||||
160321 | 160321 | 197508 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6009725.72224 | 2109430.36659 | 37.7726425134742 | -122.409760657749 | (37.7726425134742, -122.409760657749) | ||||
161494 | 161494 | 233340 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 181 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | 6006969.35222 | 2098138.0175 | 37.741481474889795 | -122.418494383305 | (37.7414814748898, -122.418494383305) | ||||
161784 | 161784 | 226591 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 793 27th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001403.92595 | 2099956.05685 | 37.7461584981302 | -122.43786786123998 | (37.7461584981302, -122.43786786124) | ||||
162013 | 162013 | 236751 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6002101.36864 | 2103370.60532 | 37.7555736715096 | -122.43570044651301 | (37.7555736715096, -122.435700446513) | ||||
165841 | 165841 | 199570 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1399 De Haro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 6012307.76781 | 2101930.26834 | 37.752193269208 | -122.40030215414 | (37.752193269208, -122.40030215414) | ||||
166602 | 166602 | 222991 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6002568.09263 | 2099485.22731 | 37.7449318417374 | -122.433808677655 | (37.7449318417374, -122.433808677655) | ||||
167044 | 167044 | 177804 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 670 Brunswick St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 5998746.52485 | 2086721.86687 | 37.709669038459 | -122.446105024329 | (37.709669038459, -122.446105024329) | ||||
167256 | 167256 | 116417 | Undocumented 2 | Elaeocarpus decipiens :: Japanese Blueberry Tree 326 | 654 Grant Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6010951.3253 | 2116916.7689799997 | 37.79326701941329 | -122.406048650219 | (37.7932670194133, -122.406048650219) | ||||
167472 | 167472 | 96545 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100@ Front St Pine St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | 2 | Permit Number 767720 | 6012972.08955 | 2116568.16592 | 37.7924226531442 | -122.399032145021 | (37.7924226531442, -122.399032145021) | ||
167681 | 167681 | 237432 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1204 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6001926.67486 | 2100538.92391 | 37.7477886254592 | -122.436101966853 | (37.7477886254592, -122.436101966853) | ||||
168632 | 168632 | 177803 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 670 Brunswick St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | 5998734.37003 | 2086718.8653400003 | 37.70966010280571 | -122.44614681761499 | (37.7096601028057, -122.446146817615) | ||||
169554 | 169554 | 197514 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | 6009780.84318 | 2109499.43172 | 37.7728352390743 | -122.409574863193 | (37.7728352390743, -122.409574863193) | ||||
169793 | 169793 | 222735 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 793 27th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 29 | 6001397.56905 | 2099954.79977 | 37.7461546850012 | -122.43788975253 | (37.7461546850012, -122.43788975253) | ||||
171587 | 171587 | 179814 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 522 Sunnydale Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6010066.66697 | 2086413.12079 | 37.7094612429124 | -122.406958677794 | (37.7094612429124, -122.406958677794) | ||||
172985 | 172985 | 245575 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | 6002723.45066 | 2099047.1713 | 37.7437378568072 | -122.43324018378901 | (37.7437378568072, -122.433240183789) | ||||
173399 | 173399 | 232313 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6007317.39057 | 2098776.5375599996 | 37.743254295847 | -122.417336222008 | (37.743254295847, -122.417336222008) | ||||
174539 | 174539 | 207721 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 228 Montana St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 5994631.9391 | 2089350.3088 | 37.7166502911674 | -122.460515994629 | (37.7166502911674, -122.460515994629) | ||||
177123 | 177123 | 222171 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1847 Castro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002657.11857 | 2100088.80937 | 37.746594188174896 | -122.433543969383 | (37.7465941881749, -122.433543969383) | ||||
178442 | 178442 | 199604 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 630 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6013529.78506 | 2104152.57114 | 37.758363299237104 | -122.39623193765699 | (37.7583632992371, -122.396231937657) | ||||
180328 | 180328 | 220926 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 99 Esmeralda Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007313.3532 | 2098768.19788 | 37.743231169794605 | -122.417349591335 | (37.7432311697946, -122.417349591335) | ||||
183200 | 183200 | 227303 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002724.72616 | 2099043.5598 | 37.7437280128274 | -122.43323551541701 | (37.7437280128274, -122.433235515417) | ||||
183211 | 183211 | 222520 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 793 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6001413.31101 | 2099956.87619 | 37.7461612815178 | -122.437835467626 | (37.7461612815178, -122.437835467626) | ||||
183895 | 183895 | 197512 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6009788.18393 | 2109495.5877 | 37.7728250956205 | -122.40954919922899 | (37.7728250956205, -122.409549199229) | ||||
183958 | 183958 | 205682 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 5991412.37682 | 2104411.58455 | 37.757818984582705 | -122.47274185157801 | (37.7578189845827, -122.472741851578) | ||||
185093 | 185093 | 220033 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 502 28th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6002622.25428 | 2099488.24408 | 37.7449431983695 | -122.433621612357 | (37.7449431983695, -122.433621612357) | ||||
186143 | 186143 | 177480 | Undocumented 2 | Malus :: Crab Apple 235 | 289 Flournoy St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 5993810.32054 | 2086750.1830099998 | 37.7094636621006 | -122.46316734172501 | (37.7094636621006, -122.463167341725) | ||||
186209 | 186209 | 245576 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6002722.8359199995 | 2099050.09706 | 37.7437458553887 | -122.433242518424 | (37.7437458553887, -122.433242518424) | ||||
187674 | 187674 | 245578 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2211 Castro St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | 6002722.030809999 | 2099065.57444 | 37.7437883069939 | -122.433246407993 | (37.7437883069939, -122.433246407993) | ||||
187910 | 187910 | 237431 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1204 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001926.93451 | 2100562.26984 | 37.747852742609204 | -122.43610273936899 | (37.7478527426092, -122.436102739369) | ||||
188473 | 188473 | 215418 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 5994025.68496 | 2088506.9373700002 | 37.7142996980529 | -122.462550356439 | (37.7142996980529, -122.462550356439) | ||||
188680 | 188680 | 234494 | Undocumented 2 | Pinus muricata :: Bishop Pine 302 | 101 Prospect Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | 6006984.21795 | 2098930.06522 | 37.7436570977129 | -122.41849913263799 | (37.7436570977129, -122.418499132638) | ||||
198 | 198 | 103786 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1221 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006804.9894 | 2115120.2532 | 37.7881014522033 | -122.420267712778 | (37.7881014522033, -122.420267712778) | ||
4327 | 4327 | 103839 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1552 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.2576 | 2116316.1212 | 37.791378262309706 | -122.420766896 | (37.7913782623097, -122.420766896) | ||
4899 | 4899 | 109487 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1314 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 10/31/2017 02:27:00 PM | 3 | 3x3 | 6006825.7 | 2115468.8 | 37.7890596427133 | -122.420220804515 | (37.7890596427133, -122.420220804515) | ||
5221 | 5221 | 72132 | Undocumented 2 | Tree(s) :: 17 | 950 Wisconsin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 12/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 780813 | 6012748.1522699995 | 2103075.8524599997 | 37.755363341648795 | -122.398859619973 | (37.7553633416488, -122.398859619973) |
6196 | 6196 | 103853 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1507 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006668.0099 | 2116095.4388 | 37.790771351094605 | -122.420810898748 | (37.7907713510946, -122.420810898748) | ||
6300 | 6300 | 103795 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1215 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006811.4062 | 2115079.7468 | 37.78799059318229 | -122.42024263571899 | (37.7879905931823, -122.420242635719) | ||
8870 | 8870 | 103858 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1475 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006691.391 | 2115929.0779 | 37.790315883136 | -122.42071818597401 | (37.790315883136, -122.420718185974) | ||
8938 | 8938 | 103857 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1475 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006690.1878 | 2115953.9432 | 37.7903840892726 | -122.42072411493 | (37.7903840892726, -122.42072411493) | ||
22940 | 22940 | 103859 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1475 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677.0 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | ||
22953 | 22953 | 103852 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1507 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | ||
22956 | 22956 | 103844 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1541 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006635.7 | 2116216.3 | 37.791101384779296 | -122.420931274285 | (37.7911013847793, -122.420931274285) | ||
22958 | 22958 | 103860 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1475 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677.0 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | ||
22965 | 22965 | 103768 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1323 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757.0 | 2115467.0 | 37.7890508291132 | -122.42045837028401 | (37.7890508291132, -122.420458370284) | ||
22970 | 22970 | 103849 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1524 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006765.8 | 2116184.9 | 37.7910225007002 | -122.420478902042 | (37.7910225007002, -122.420478902042) | ||
22978 | 22978 | 103850 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1524 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006765.8 | 2116184.9 | 37.7910225007002 | -122.420478902042 | (37.7910225007002, -122.420478902042) | ||
30751 | 30751 | 117574 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 838 Grant Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 3x3 | 6010874.95685 | 2117476.8733599996 | 37.7948006593736 | -122.406352374685 | (37.7948006593736, -122.406352374685) | |||
37006 | 37006 | 113232 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 3x3 | 6006901.77113 | 2114384.86271 | 37.7860877036192 | -122.419880660363 | (37.7860877036192, -122.419880660363) | |||
66030 | 66030 | 103847 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1529 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006640.1 | 2116184.7 | 37.7910148670423 | -122.42091380589399 | (37.7910148670423, -122.420913805894) | ||
73092 | 73092 | 117576 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Waverly Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 3x3 | 6010746.80079 | 2117296.5570099996 | 37.794298384417296 | -122.40678310046499 | (37.7942983844173, -122.406783100465) | |||
77434 | 77434 | 81367 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1001 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/08/2003 12:00:00 AM | 3x3 | 6006914.85774282 | 2114314.60875621 | 37.7858955407321 | -122.41983039718201 | (37.7858955407321, -122.419830397182) | |||
80726 | 80726 | 112691 | Undocumented 2 | Tree(s) :: 17 | 1x CUMBERLAND ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6005299.0 | 2104587.0 | 37.7590947163124 | -122.424728559182 | (37.7590947163124, -122.424728559182) | ||||
82217 | 82217 | 93894 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
83122 | 83122 | 103782 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1237 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006764.1 | 2115217.5 | 37.7883661638156 | -122.420416088533 | (37.7883661638156, -122.420416088533) | ||
84192 | 84192 | 113229 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1150 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
85219 | 85219 | 111679 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 1150 SUTTER ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6007057.0 | 2115063.0 | 37.787958446039504 | -122.419391734764 | (37.7879584460395, -122.419391734764) | ||||
86304 | 86304 | 103872 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1401 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006693.3 | 2115724.1 | 37.789753172189705 | -122.420697023404 | (37.7897531721897, -122.420697023404) | ||
86655 | 86655 | 103856 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1489 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006726.686980001 | 2115849.48669 | 37.790099334646705 | -122.42059041188101 | (37.7900993346467, -122.420590411881) | ||
86852 | 86852 | 103869 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1411 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.42073037630101 | (37.7899185422019, -122.420730376301) | ||
86873 | 86873 | 103854 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1507 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | ||
87496 | 87496 | 103843 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1541 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006635.7 | 2116216.3 | 37.791101384779296 | -122.420931274285 | (37.7911013847793, -122.420931274285) | ||
87768 | 87768 | 113227 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
88742 | 88742 | 93897 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
90280 | 90280 | 103767 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1323 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757.0 | 2115467.0 | 37.7890508291132 | -122.42045837028401 | (37.7890508291132, -122.420458370284) | ||
91623 | 91623 | 103865 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1424 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006775.0 | 2115831.4 | 37.790052395748404 | -122.420421968076 | (37.7900523957484, -122.420421968076) |
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");