Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlotSize, PermitNotes
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1975 | 1975 | 238619 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001066.93276 | 2101745.60422 | 37.7510529990026 | -122.43916137771099 | (37.7510529990026, -122.439161377711) | |||
| 1964 | 1964 | 238618 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 14 | Width 4ft | 6001078.53558 | 2101746.02342 | 37.751054810249 | -122.439121284114 | (37.751054810249, -122.439121284114) | |||
| 1974 | 1974 | 238616 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4302 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 23 | Width 4ft | 6001186.94921 | 2101750.3744 | 37.7510729252903 | -122.43874669133301 | (37.7510729252903, -122.438746691333) | |||
| 2010 | 2010 | 142062 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | |
| 2033 | 2033 | 139199 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 19 | Width 0ft | 6001773.0984 | 2113703.8723 | 37.7839276110688 | -122.437575676931 | (37.7839276110688, -122.437575676931) | |||
| 2024 | 2024 | 139198 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 GEARY BLVD | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | Width 0ft | 6001803.3539 | 2113704.6103 | 37.783931357581395 | -122.437471057097 | (37.7839313575814, -122.437471057097) | |||
| 1909 | 1909 | 125218 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 13 | Width 4ft | 6005090.35688 | 2116771.11072 | 37.7925375271472 | -122.42631763077499 | (37.7925375271472, -122.426317630775) | |||
| 11793 | 11793 | 120892 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201 Leland Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6009904.76 | 2087542.3079 | 37.7125527002168 | -122.407597819442 | (37.7125527002168, -122.407597819442) | |||
| 63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
| 149958 | 149958 | 120890 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009870.8927 | 2087557.0134 | 37.71259118267999 | -122.40771591213999 | (37.71259118268, -122.40771591214) | |||
| 74957 | 74957 | 120889 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.71260369432971 | -122.407774785999 | (37.7126036943297, -122.407774785999) | |||
| 61322 | 61322 | 120888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.40787112709101 | (37.7126351844606, -122.407871127091) | |||
| 56141 | 56141 | 120887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | |||
| 187851 | 187851 | 120886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009795.1369 | 2087583.7508 | 37.712660357001795 | -122.40797963340599 | (37.7126603570018, -122.407979633406) | |||
| 128075 | 128075 | 120885 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6009830.0 | 2087548.0 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | ||||
| 123341 | 123341 | 117622 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 890x VERMONT ST | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 6011292.0 | 2104239.0 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | |||||
| 88981 | 88981 | 117174 | Undocumented 2 | Tree(s) :: 17 | 299x ALMA ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 85303 | 85303 | 117173 | Undocumented 2 | Tree(s) :: 17 | 299x ALMA ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 125476 | 125476 | 117172 | Undocumented 2 | Tree(s) :: 17 | 299x ALMA ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 111214 | 111214 | 117171 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 78486 | 78486 | 117170 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 115442 | 115442 | 117169 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 67560 | 67560 | 117168 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 100218 | 100218 | 117167 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 94182 | 94182 | 117166 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 299x ALMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 112111 | 112111 | 117165 | Undocumented 2 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 299x ALMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 5997407.0 | 2106053.0 | 37.7626710894654 | -122.45212848427799 | (37.7626710894654, -122.452128484278) | ||||
| 98945 | 98945 | 116341 | Undocumented 2 | :: 54 | 201X Bright St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5993755.0695 | 2088847.02637 | 37.715217913096104 | -122.463510368547 | (37.7152179130961, -122.463510368547) | |||||
| 119252 | 119252 | 116340 | Undocumented 2 | :: 54 | 201X Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5993755.0695 | 2088847.02637 | 37.715217913096104 | -122.463510368547 | (37.7152179130961, -122.463510368547) | |||||
| 113797 | 113797 | 116339 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 108927 | 108927 | 116338 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 143572 | 143572 | 116337 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 144301 | 144301 | 116336 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 98178 | 98178 | 116335 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 107184 | 107184 | 116334 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 94078 | 94078 | 116333 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 91482 | 91482 | 116332 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 121543 | 121543 | 116331 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 107067 | 107067 | 116330 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 88387 | 88387 | 116329 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 93124 | 93124 | 116328 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 118898 | 118898 | 116327 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 79036 | 79036 | 116326 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 112628 | 112628 | 116325 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 95183 | 95183 | 116324 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 125361 | 125361 | 116323 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 124407 | 124407 | 116322 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 88078 | 88078 | 116321 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 94106 | 94106 | 116320 | Undocumented 2 | :: 54 | 1451 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
| 99142 | 99142 | 116319 | Undocumented 2 | :: 54 | 1451 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
| 72532 | 72532 | 116318 | Undocumented 2 | :: 54 | 1451 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010547.7 | 2101110.8 | 37.749844886729996 | -122.406331036849 | (37.74984488673, -122.406331036849) | |||||
| 100230 | 100230 | 116306 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 104628 | 104628 | 116305 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 89720 | 89720 | 116304 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 90870 | 90870 | 116303 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 81886 | 81886 | 116302 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1550 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | |||||
| 108909 | 108909 | 116293 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 139446 | 139446 | 116292 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 84099 | 84099 | 116291 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 83060 | 83060 | 116290 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 123347 | 123347 | 116289 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 111444 | 111444 | 116288 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 92543 | 92543 | 116287 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 88440 | 88440 | 116286 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 94547 | 94547 | 116285 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1901X Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009504.70132 | 2120333.4249299997 | 37.802567299543206 | -122.41129555893 | (37.8025672995432, -122.41129555893) | |||||
| 80868 | 80868 | 116284 | Undocumented 2 | :: 54 | 700X Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 92470 | 92470 | 116283 | Undocumented 2 | :: 54 | 700X Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 98757 | 98757 | 116282 | Undocumented 2 | :: 54 | 700X Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 116105 | 116105 | 116281 | Undocumented 2 | :: 54 | 700X Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 140188 | 140188 | 116280 | Undocumented 2 | :: 54 | 700X Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 84777 | 84777 | 116279 | Undocumented 2 | :: 54 | 700X Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138579 | 138579 | 116278 | Undocumented 2 | :: 54 | 700X Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 117089 | 117089 | 116277 | Undocumented 2 | :: 54 | 700X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 82559 | 82559 | 116276 | Undocumented 2 | :: 54 | 700X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 141239 | 141239 | 116275 | Undocumented 2 | :: 54 | 700X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138269 | 138269 | 116274 | Undocumented 2 | :: 54 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 81330 | 81330 | 116229 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 110949 | 110949 | 116228 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 98431 | 98431 | 116227 | Undocumented 2 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1699 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6002584.4 | 2114045.3 | 37.7849111787577 | -122.434793299622 | (37.7849111787577, -122.434793299622) | |||||
| 128318 | 128318 | 116151 | Undocumented 2 | Tree(s) :: 17 | 3701 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | |||||
| 146211 | 146211 | 116150 | Undocumented 2 | Tree(s) :: 17 | 3701 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | |||||
| 113581 | 113581 | 116149 | Undocumented 2 | Tree(s) :: 17 | 3701 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | |||||
| 80880 | 80880 | 116148 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 96944 | 96944 | 116147 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 91125 | 91125 | 116146 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 100067 | 100067 | 116145 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 87523 | 87523 | 116144 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 96429 | 96429 | 116143 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 98464 | 98464 | 116142 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 102030 | 102030 | 116141 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 120223 | 120223 | 116140 | Undocumented 2 | Tree(s) :: 17 | 3800X 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004661.9257 | 2104258.88373 | 37.758157784571296 | -122.426908497787 | (37.7581577845713, -122.426908497787) | |||||
| 38305 | 38305 | 116138 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.39238857399599 | (37.7262356791342, -122.392388573996) | ||||
| 140572 | 140572 | 116137 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 102302 | 102302 | 116136 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 125773 | 125773 | 116135 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 84841 | 84841 | 116134 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 93581 | 93581 | 116133 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 20862 | 20862 | 116132 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 105094 | 105094 | 116131 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 81024 | 81024 | 116130 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) | |||||
| 77747 | 77747 | 116129 | Undocumented 2 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6014258.08027 | 2092570.23406 | 37.726601114752604 | -122.392902822978 | (37.7266011147526, -122.392902822978) |
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");