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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
85354 | 85354 | 116746 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
88764 | 88764 | 116749 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
108617 | 108617 | 116747 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
120023 | 120023 | 116748 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9x BLANKEN AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011671.0 | 2087411.0 | 37.71229086541071 | -122.40148388608 | (37.7122908654107, -122.40148388608) | ||||
139866 | 139866 | 115801 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 9M CAIRE TER | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012720.0 | 2101959.0 | 37.7522951385919 | -122.398878598484 | (37.7522951385919, -122.398878598484) | |||||
81662 | 81662 | 115444 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
97297 | 97297 | 115442 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
112326 | 112326 | 115441 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
113661 | 113661 | 115440 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
115493 | 115493 | 115443 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 99x Vandewater St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | ||||
2733 | 2733 | 253189 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2735 | 2735 | 253188 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2737 | 2737 | 253186 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2738 | 2738 | 253184 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2739 | 2739 | 253185 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2741 | 2741 | 253190 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
2744 | 2744 | 253187 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 99x The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014645.0 | 2117171.0 | 37.794170975650296 | -122.393285986986 | (37.7941709756503, -122.393285986986) | ||||
77511 | 77511 | 121374 | Undocumented 2 | Palm (unknown Genus) :: Palm Spp 161 | 99x Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006202.0 | 2097575.0 | 37.73989232614821 | -122.421107660096 | (37.7398923261482, -122.421107660096) | ||||
98900 | 98900 | 121373 | Undocumented 2 | Palm (unknown Genus) :: Palm Spp 161 | 99x Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006202.0 | 2097575.0 | 37.73989232614821 | -122.421107660096 | (37.7398923261482, -122.421107660096) | ||||
109131 | 109131 | 121376 | Undocumented 2 | Palm (unknown Genus) :: Palm Spp 161 | 99x Santa Marina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006202.0 | 2097575.0 | 37.73989232614821 | -122.421107660096 | (37.7398923261482, -122.421107660096) | ||||
120908 | 120908 | 121375 | Undocumented 2 | Palm (unknown Genus) :: Palm Spp 161 | 99x Santa Marina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006202.0 | 2097575.0 | 37.73989232614821 | -122.421107660096 | (37.7398923261482, -122.421107660096) | ||||
166 | 166 | 251230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
167 | 167 | 251232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
3258 | 3258 | 253374 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 99x Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007537.0 | 2096150.0 | 37.7360547576169 | -122.416390866966 | (37.7360547576169, -122.416390866966) | ||||
65538 | 65538 | 110519 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
95125 | 95125 | 110520 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
113014 | 113014 | 110518 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
114259 | 114259 | 110522 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
114942 | 114942 | 110521 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
115187 | 115187 | 110517 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 99x JULIAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6006400.0 | 2107588.0 | 37.7673968795345 | -122.421133861104 | (37.7673968795345, -122.421133861104) | |||
53479 | 53479 | 108406 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008120.84483 | 2112658.906 | 37.7814172463574 | -122.41554073723302 | (37.7814172463574, -122.415540737233) | |
135927 | 135927 | 108405 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008118.29339 | 2112682.65315 | 37.7814823069089 | -122.41555124581001 | (37.7814823069089, -122.41555124581) | |
151164 | 151164 | 108408 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 11 | 3x3 | Permit Number 773269 | 6008126.98045 | 2112612.39837 | 37.7812898924571 | -122.41551621722601 | (37.7812898924571, -122.415516217226) | |
170033 | 170033 | 108407 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 12 | 3x3 | Permit Number 773269 | 6008123.88182 | 2112634.14044 | 37.7813494167874 | -122.415528476779 | (37.7813494167874, -122.415528476779) | |
182575 | 182575 | 108410 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 10 | 3x3 | Permit Number 773269 | 6008131.8663 | 2112579.02445 | 37.781198530314995 | -122.41549695101801 | (37.781198530315, -122.415496951018) | |
184627 | 184627 | 108409 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 99x Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 13 | 3x3 | Permit Number 773269 | 6008129.59407 | 2112591.6747 | 37.78123313714521 | -122.41550570771601 | (37.7812331371452, -122.415505707716) | |
88315 | 88315 | 108412 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
92393 | 92393 | 108411 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
107281 | 107281 | 108413 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
112409 | 112409 | 108414 | Undocumented 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 | 99x HYDE ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x3 | Permit Number 773269 | 6008108.0 | 2112443.0 | 37.7808236983351 | -122.415569883338 | (37.7808236983351, -122.415569883338) | ||
91188 | 91188 | 111312 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 99x GILROY ST | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 30x30 | 6015277.0 | 2088666.0 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | ||||
96975 | 96975 | 111311 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 99x GILROY ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 30x30 | 6015277.0 | 2088666.0 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | ||||
123880 | 123880 | 111310 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 99x GILROY ST | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 30x30 | 6015277.0 | 2088666.0 | 37.7159373992527 | -122.389107938034 | (37.7159373992527, -122.389107938034) | ||||
107056 | 107056 | 104507 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99x DICHIERA CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5998517.0 | 2087907.0 | 37.7129100350962 | -122.44698352706499 | (37.7129100350962, -122.446983527065) | |||
53785 | 53785 | 111858 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
88303 | 88303 | 111854 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
88535 | 88535 | 111853 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | |||
95443 | 95443 | 111857 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
110099 | 110099 | 111855 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
144152 | 144152 | 111856 | Undocumented 2 | Celtis occidentalis :: Common Hackberry 292 | 99x DE LONG ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994668.0 | 2086747.0 | 37.7095042936171 | -122.46020284835699 | (37.7095042936171, -122.460202848357) | ||||
110994 | 110994 | 111670 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99x CARL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998115.0 | 2107097.0 | 37.7655781805803 | -122.44975501544201 | (37.7655781805803, -122.449755015442) | ||||
116012 | 116012 | 111669 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99x CARL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998115.0 | 2107097.0 | 37.7655781805803 | -122.44975501544201 | (37.7655781805803, -122.449755015442) | ||||
99106 | 99106 | 111065 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007219.0 | 2106804.0 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | ||||
111688 | 111688 | 111064 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007219.0 | 2106804.0 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | |||
79227 | 79227 | 106170 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 99X THOR AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6002346.0 | 2095994.0 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | |||
143358 | 143358 | 117258 | Undocumented 2 | Tree(s) :: 17 | 99X PROSPER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | 6003339.0 | 2106236.0 | 37.7635115803019 | -122.431624896471 | (37.7635115803019, -122.431624896471) | ||||
44523 | 44523 | 111165 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003411.20248 | 2119815.94235 | 37.800802791376796 | -122.432345118256 | (37.8008027913768, -122.432345118256) | |||
53706 | 53706 | 111161 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003338.31122 | 2119805.5444900002 | 37.8007701082019 | -122.432596609162 | (37.8007701082019, -122.432596609162) | |||
61466 | 61466 | 111164 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003392.2553900005 | 2119813.00098 | 37.8007936407819 | -122.43241047286199 | (37.8007936407819, -122.432410472862) | |||
151211 | 151211 | 111160 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003321.77346 | 2119803.50555 | 37.8007635719416 | -122.43265369092899 | (37.8007635719416, -122.432653690929) | |||
154752 | 154752 | 111162 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6003355.09781 | 2119808.05454 | 37.8007779520905 | -122.43253870000001 | (37.8007779520905, -122.4325387) | |||
167365 | 167365 | 111163 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 99X Magnolia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6003374.28365 | 2119810.9912900003 | 37.80078710360971 | -122.43247251891898 | (37.8007871036097, -122.432472518919) | |||
102548 | 102548 | 101898 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
105468 | 105468 | 101899 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 99X MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6008233.5 | 2119097.7 | 37.7991029311983 | -122.415607021356 | (37.7991029311983, -122.415607021356) | |||||
102241 | 102241 | 121608 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
117773 | 117773 | 121606 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
140890 | 140890 | 121607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
113153 | 113153 | 106104 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99X HARTFORD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x3 | 6002644.0 | 2105609.0 | 37.761750572206104 | -122.433983855891 | (37.7617505722061, -122.433983855891) | |||
42198 | 42198 | 113587 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X Augusta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6011311.6755800005 | 2095454.8306 | 37.734357514173496 | -122.40329132882601 | (37.7343575141735, -122.403291328826) | |||
127574 | 127574 | 113586 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 99X AUGUSTA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | 3x3 | 6011271.0 | 2095434.0 | 37.7342980459086 | -122.403430493306 | (37.7342980459086, -122.403430493306) | |||
141333 | 141333 | 113369 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 999x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x9 | 6009304.0 | 2096928.0 | 37.7382901856605 | -122.41033652541401 | (37.7382901856605, -122.410336525414) | |||
84938 | 84938 | 102708 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 999X PHELPS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773962 | 6014744.0 | 2097272.0 | 37.7395381878784 | -122.39155157401501 | (37.7395381878784, -122.391551574015) | |
114153 | 114153 | 102709 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 999X PHELPS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773962 | 6014744.0 | 2097272.0 | 37.7395381878784 | -122.39155157401501 | (37.7395381878784, -122.391551574015) | |
94431 | 94431 | 109645 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 999X PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001842.0 | 2109394.0 | 37.7720977038705 | -122.437028639855 | (37.7720977038705, -122.437028639855) | ||||
96428 | 96428 | 117621 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
105246 | 105246 | 117625 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
116417 | 116417 | 117623 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999X BRAZIL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004288.0 | 2090756.0 | 37.7210607924735 | -122.42723986886601 | (37.7210607924735, -122.427239868866) | |||
44218 | 44218 | 232060 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 999 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009979.53816 | 2103472.3105599997 | 37.756297270530894 | -122.40846233078399 | (37.7562972705309, -122.408462330784) | |||
46460 | 46460 | 232059 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 999 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009981.93097 | 2103452.1603 | 37.7562420764311 | -122.408452634282 | (37.7562420764311, -122.408452634282) | |||
134775 | 134775 | 232058 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 999 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009981.55531 | 2103433.74149 | 37.7561914814659 | -122.40845263427799 | (37.7561914814659, -122.408452634278) | |||
164625 | 164625 | 235855 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 999 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008625.313519999 | 2102772.01425 | 37.7542984832041 | -122.41309620812001 | (37.7542984832041, -122.41309620812) | |||
38414 | 38414 | 142770 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 999 POLK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006930.1247 | 2114212.3142 | 37.785615524997894 | -122.419770316589 | (37.7856155249979, -122.419770316589) | |||
43001 | 43001 | 142771 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 999 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6006933.7616 | 2114178.8543 | 37.7855238571853 | -122.419755358932 | (37.7855238571853, -122.419755358932) | |||
167589 | 167589 | 142772 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 999 POLK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6006935.5801 | 2114166.125 | 37.785489008085705 | -122.419748163911 | (37.7854890080857, -122.419748163911) | |||
188844 | 188844 | 132293 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 999 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6005925.58045 | 2121359.44598 | 37.805183106669 | -122.42375411867799 | (37.805183106669, -122.423754118678) | |||
3028 | 3028 | 191362 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 999 Key Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6013336.3333 | 2089743.8780099999 | 37.718789267498295 | -122.39589132571999 | (37.7187892674983, -122.39589132572) | ||||
16807 | 16807 | 106757 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/02/2014 12:00:00 AM | 36 | 6013321.202330001 | 2089752.82506 | 37.718812992515105 | -122.395944254446 | (37.7188129925151, -122.395944254446) | |||
41232 | 41232 | 194561 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 999 Kansas St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6011649.57806 | 2103809.7609599996 | 37.7573172186375 | -122.40271045314199 | (37.7573172186375, -122.402710453142) | ||||
58667 | 58667 | 197373 | Undocumented 2 | Robinia pseudoacacia :: Black Locust 169 | 999 Kansas St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6011643.7126 | 2103814.56815 | 37.7573300906303 | -122.402731076388 | (37.7573300906303, -122.402731076388) | ||||
150355 | 150355 | 190919 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 999 Kansas St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011651.17755 | 2103795.8209 | 37.7572790316179 | -122.40270394113001 | (37.7572790316179, -122.40270394113) | ||||
129895 | 129895 | 138989 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 999 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003118.0992 | 2110635.6071 | 37.7755793009505 | -122.432703221339 | (37.7755793009505, -122.432703221339) | |||
39540 | 39540 | 131592 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6008355.8018 | 2118946.79635 | 37.7986954612792 | -122.41517312674601 | (37.7986954612792, -122.415173126746) | ||||
54378 | 54378 | 131593 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6008359.29361 | 2118943.47544 | 37.7986865391195 | -122.415160808731 | (37.7986865391195, -122.415160808731) | ||||
136669 | 136669 | 131594 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6008361.61132 | 2118940.7694200003 | 37.7986792393119 | -122.41515259703999 | (37.7986792393119, -122.41515259704) | ||||
163624 | 163624 | 131595 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 999 Green St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6008365.45395 | 2118940.10023 | 37.7986776178289 | -122.41513925288 | (37.7986776178289, -122.41513925288) | ||||
34866 | 34866 | 128940 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 999 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6007019.651319999 | 2114299.92893 | 37.7858611365224 | -122.419466797772 | (37.7858611365224, -122.419466797772) | |||
44030 | 44030 | 128939 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 999 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6007005.09645 | 2114299.52069 | 37.7858591957899 | -122.41951712470801 | (37.7858591957899, -122.419517124708) | |||
57549 | 57549 | 128941 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 999 Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6007034.604069999 | 2114302.44848 | 37.78586889678329 | -122.41941524411301 | (37.7858688967833, -122.419415244113) | |||
152351 | 152351 | 128943 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 999 Geary St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6007076.9364 | 2114307.93952 | 37.7858863580241 | -122.41926917535 | (37.7858863580241, -122.41926917535) | |||
181570 | 181570 | 128942 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 999 Geary St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6007052.43012 | 2114306.6758 | 37.785881507968 | -122.419353870795 | (37.785881507968, -122.419353870795) |
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");