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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
97551 | 97551 | 80517 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 3 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
114609 | 114609 | 80518 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 5 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
114700 | 114700 | 80515 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
119627 | 119627 | 80516 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
127060 | 127060 | 22386 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | |||
15764 | 15764 | 80467 | Private 5 | Alnus cordata :: Italian Alder 294 | 1780 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 10 | 6013451.73876 | 2092852.71308 | 37.727331923129896 | -122.395710120444 | (37.7273319231299, -122.395710120444) | |||
90903 | 90903 | 80593 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1780 Bancroft Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 7 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
119892 | 119892 | 22381 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1780 Bancroft Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | |||
16217 | 16217 | 22383 | Private 5 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1799X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 2 | 4x15 | 6013476.602999999 | 2093118.78047 | 37.7280638732384 | -122.39564279807301 | (37.7280638732384, -122.395642798073) | ||
120169 | 120169 | 104564 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) | |||||
138621 | 138621 | 104565 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) | |||||
109920 | 109920 | 114977 | Private 5 | Pittosporum undulatum :: Victorian Box 26 | 183 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 774982 | 5996484.3 | 2091092.2 | 37.7215395068839 | -122.454239087603 | (37.7215395068839, -122.454239087603) | |||
2502 | 2502 | 253119 | Private 5 | Pinus radiata :: Monterey Pine 3 | 185 Belgrave Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 780239 | 5997636.85301 | 2104869.74588 | 37.759435335978296 | -122.45124816933 | (37.7594353359783, -122.45124816933) | ||||
120946 | 120946 | 122898 | Private 5 | Podocarpus gracilor :: Fern Pine 13 | 198X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6006160.0 | 2102149.0 | 37.752449123979794 | -122.421577653162 | (37.7524491239798, -122.421577653162) | |||
92292 | 92292 | 39627 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
104147 | 104147 | 39629 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 6 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
122002 | 122002 | 39628 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 199X Carmel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 5 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.45031878213301 | (37.7607233191374, -122.450318782133) | |
101429 | 101429 | 121090 | Private 5 | Pinus radiata :: Monterey Pine 3 | 1X Grand View Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
141824 | 141824 | 121089 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 1X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
120714 | 120714 | 104436 | Private 5 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 SAN FERNANDO WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5992040.0 | 2096369.0 | 37.7357724272627 | -122.469985704629 | (37.7357724272627, -122.469985704629) | ||||
2648 | 2648 | 183237 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2001 37th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984780.1717 | 2100543.2827 | 37.7468115375468 | -122.495393151852 | (37.7468115375468, -122.495393151852) | |
2656 | 2656 | 183240 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2001 37th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984790.3243 | 2100348.3517 | 37.7462769046122 | -122.495343672098 | (37.7462769046122, -122.495343672098) | |
2672 | 2672 | 183250 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2107 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984200.2859 | 2100804.8827 | 37.7474958486327 | -122.497417620086 | (37.7474958486327, -122.497417620086) | |
111683 | 111683 | 114761 | Private 5 | Pinus radiata :: Monterey Pine 3 | 2155 10TH AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993160.0 | 2101036.0 | 37.7486515109126 | -122.466452556212 | (37.7486515109126, -122.466452556212) | ||||
105247 | 105247 | 25212 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 215X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006420.227630001 | 2110742.05634 | 37.7760583047566 | -122.421287897592 | (37.7760583047566, -122.421287897592) | |||
18151 | 18151 | 124716 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
19281 | 19281 | 114961 | Private 5 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 220 Evelyn Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.45011626136801 | (37.7429206264442, -122.450116261368) | |||
76816 | 76816 | 104448 | Private 5 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
88695 | 88695 | 104451 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
92561 | 92561 | 104449 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
100922 | 100922 | 104446 | Private 5 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
88690 | 88690 | 80520 | Private 5 | Pyrus spp :: Pear Tree 291 | 2499X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 2 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
94178 | 94178 | 22382 | Private 5 | Pyrus spp :: Pear Tree 291 | 2499X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | ||
3835 | 3835 | 253567 | Private 5 | Salix spp :: Willow 218 | 25 Raycliff Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000333.0 | 2116919.0 | 37.792673532262505 | -122.44278881704399 | (37.7926735322625, -122.442788817044) | |||||
119359 | 119359 | 108314 | Private 5 | Corymbia ficifolia :: Red Flowering Gum 60 | 2501X DIAMOND ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002141.0 | 2097265.0 | 37.7388113707969 | -122.435126715418 | (37.7388113707969, -122.435126715418) | ||||
84402 | 84402 | 109353 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
104832 | 104832 | 109350 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
113379 | 113379 | 109349 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
122284 | 122284 | 109352 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
125736 | 125736 | 109351 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
139898 | 139898 | 109348 | Private 5 | Ficus Spp. :: 253 | 2505 Pacific Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | .5x1 | 6002092.0 | 2116990.0 | 37.7929686009801 | -122.43670770268999 | (37.7929686009801, -122.43670770269) | ||
8592 | 8592 | 121500 | Private 5 | Pinus radiata :: Monterey Pine 3 | 251X Pennsylvania Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | ||||||||||
85994 | 85994 | 104510 | Private 5 | Sequoia sempervirens :: Coast Redwood 116 | 254 ALLISON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 6000052.0 | 2087408.0 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | ||||
110838 | 110838 | 107348 | Private 5 | Private shrub :: Private Shrub 64 | 260 LANSDALE AVE | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5995019.0 | 2096651.7 | 37.7367204092857 | -122.459706678853 | (37.7367204092857, -122.459706678853) | |||||
2668 | 2668 | 183245 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2706 Rivera St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984600.1313 | 2100244.4562 | 37.745980498085295 | -122.495993663284 | (37.7459804980853, -122.495993663284) | |
97106 | 97106 | 102276 | Private 5 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.43839895973301 | (37.7402178594385, -122.438398959733) | ||||||
2640 | 2640 | 183247 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2890 Rivera St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984262.8939 | 2100232.1038 | 37.7459268239815 | -122.49715885534201 | (37.7459268239815, -122.497158855342) | |
82462 | 82462 | 114642 | Private 5 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 30 MacEdonia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 773527 | 6010319.9 | 2099707.2 | 37.745978163196995 | -122.407019863158 | (37.745978163197, -122.407019863158) | |||
78271 | 78271 | 16888 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
83519 | 83519 | 16883 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
85166 | 85166 | 16887 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
85178 | 85178 | 16884 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
102333 | 102333 | 122643 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
113580 | 113580 | 16882 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
115127 | 115127 | 122644 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
116204 | 116204 | 16886 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X4 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
140005 | 140005 | 122641 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
140429 | 140429 | 122642 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
142156 | 142156 | 16885 | Private 5 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300X Oak St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.341599599 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | ||
100517 | 100517 | 104502 | Private 5 | Pinus radiata :: Monterey Pine 3 | 30X SATURN ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6000456.0 | 2106003.0 | 37.7627079858093 | -122.44157952536999 | (37.7627079858093, -122.44157952537) | ||||
88121 | 88121 | 71505 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 328 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774557 | 6006691.32680411 | 2104197.11487977 | 37.758102721165706 | -122.41988555479601 | (37.7581027211657, -122.419885554796) | |
118626 | 118626 | 114647 | Private 5 | Eriobotrya deflexa :: Bronze Loquat 49 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | |||
27 | 27 | 244214 | Private 5 | Tree(s) :: 17 | 342 Scott St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779666 | 6002262.2202 | 2109717.5413 | 37.7730099442883 | -122.43559821674499 | (37.7730099442883, -122.435598216745) | |
146018 | 146018 | 104109 | Private 5 | Maytenus boaria :: Mayten 22 | 342-346 MOULTRIE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | 6007700.0 | 2097518.0 | 37.739820149686295 | -122.415924151926 | (37.7398201496863, -122.415924151926) | |||
116115 | 116115 | 104650 | Private 5 | Corymbia ficifolia :: Red Flowering Gum 60 | 346 LAKE ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 10x8 | 5994385.6 | 2114927.2 | 37.7868637456835 | -122.46322230514099 | (37.7868637456835, -122.463222305141) | ||||
79705 | 79705 | 108816 | Private 5 | Pinus radiata :: Monterey Pine 3 | 348 Gold Mine Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 6001084.0 | 2097744.0 | 37.740066514789 | -122.43881563429301 | (37.740066514789, -122.438815634293) | ||||
122211 | 122211 | 36938 | Private 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 351 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774744 | 5992449.52236815 | 2113091.8234389997 | 37.781712581861 | -122.46978695177602 | (37.781712581861, -122.469786951776) | |
130745 | 130745 | 82138 | Private 5 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/2004 12:00:00 AM | 12 | 5993114.289030001 | 2113170.0137400003 | 37.781965672785795 | -122.467492879752 | (37.7819656727858, -122.467492879752) | ||
97889 | 97889 | 104310 | Private 5 | Brachychiton populneus :: Bottle Tree 329 | 3747 23RD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x5 | 6004798.0 | 2102451.0 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | |||
110181 | 110181 | 104309 | Private 5 | Myoporum laetum :: Myoporum 1 | 3747 23RD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6004798.0 | 2102451.0 | 37.7532014528284 | -122.426309178314 | (37.7532014528284, -122.426309178314) | ||||
93096 | 93096 | 114666 | Private 5 | Podocarpus gracilor :: Fern Pine 13 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774512 | 6007233.6 | 2095963.6 | 37.7355258779344 | -122.41742663990699 | (37.7355258779344, -122.417426639907) | |||
78203 | 78203 | 26198 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 3830 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x4 | 6015747.5106037995 | 2098323.3315623 | 37.742480578689 | -122.388155190044 | (37.742480578689, -122.388155190044) | |||
79103 | 79103 | 120636 | Private 5 | Private shrub :: Private Shrub 64 | 385 Nevada St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6008960.0 | 2096519.0 | 37.7371478708762 | -122.411497024701 | (37.7371478708762, -122.411497024701) | ||||
99380 | 99380 | 119616 | Private 5 | :: 54 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 6005873.6969099995 | 2111410.5639299997 | 37.777863036884796 | -122.42322602570499 | (37.7778630368848, -122.423226025705) | |||
14482 | 14482 | 109063 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014773.1420599995 | 2114255.79417 | 37.7861736122787 | -122.39263857322901 | (37.7861736122787, -122.392638573229) | ||
15625 | 15625 | 109064 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014787.30736 | 2114269.34055 | 37.7862115942283 | -122.39259051256799 | (37.7862115942283, -122.392590512568) | ||
16245 | 16245 | 109062 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014756.57852 | 2114238.14616 | 37.7861242349771 | -122.392694644144 | (37.7861242349771, -122.392694644144) | ||
966 | 966 | 251417 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5990003.0 | 2112517.0 | 37.779992561868504 | -122.478208632121 | (37.7799925618685, -122.478208632121) | ||||
106936 | 106936 | 105441 | Private 5 | Eucalyptus globulus :: Blue Gum 103 | 425 WAWONA ST | unknown : Yard 19 | Tree 1 | Private 1 | 5991587.6 | 2097036.5 | 37.737579050883106 | -122.471598439568 | (37.7375790508831, -122.471598439568) | ||||||
145512 | 145512 | 72375 | Private 5 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 4299X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 3x3 | Permit Number 773790 | 5990099.63678033 | 2109979.56687008 | 37.773031079694 | -122.47768879633699 | (37.773031079694, -122.477688796337) | |
123092 | 123092 | 104627 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 49 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5X5 | 6001306.0 | 2108720.0 | 37.7702165872443 | -122.438834395611 | (37.7702165872443, -122.438834395611) | |||
126236 | 126236 | 104626 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 49 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6X5 | 6001285.0 | 2108936.0 | 37.7708084746611 | -122.438922516011 | (37.7708084746611, -122.438922516011) | |||
124928 | 124928 | 104968 | Private 5 | Pinus halepensis :: Allepo Pine 164 | 495 COLLINGWOOD ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Permit Number 770776 | 6002186.6 | 2103026.0 | 37.7546323087418 | -122.435381040855 | (37.7546323087418, -122.435381040855) | |||
98596 | 98596 | 115128 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
104521 | 104521 | 115129 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
93974 | 93974 | 121246 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
94513 | 94513 | 121248 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
100736 | 100736 | 121249 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
113673 | 113673 | 121247 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
140147 | 140147 | 121245 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
79432 | 79432 | 106576 | Private 5 | Private shrub :: Private Shrub 64 | 507 STEINER ST | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6003113.3 | 2110111.6 | 37.7741402349502 | -122.432682383122 | (37.7741402349502, -122.432682383122) | |||||
97877 | 97877 | 121418 | Private 5 | Juniperus californica :: California juniper 226 | 521 Lakeview Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 5996348.0 | 2089857.0 | 37.718140121256106 | -122.45462104638399 | (37.7181401212561, -122.454621046384) | ||||
22941 | 22941 | 110324 | Private 5 | Tree(s) :: 17 | 580 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2015 12:00:00 AM | 3 | Permit Number 773594 | 6005065.6 | 2110970.4 | 37.7766088164574 | -122.42599017584601 | (37.7766088164574, -122.425990175846) | ||
97007 | 97007 | 117070 | Private 5 | Tree(s) :: 17 | 6 JOY ST | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010444.0 | 2098901.0 | 37.7437714571602 | -122.406533939617 | (37.7437714571602, -122.406533939617) | |||||
102017 | 102017 | 85741 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 601X Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798001 | 2114488.497614 | 37.78672294116279 | -122.398229721423 | (37.7867229411628, -122.398229721423) | |
117366 | 117366 | 85739 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 601X Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798001 | 2114488.497614 | 37.78672294116279 | -122.398229721423 | (37.7867229411628, -122.398229721423) | |
142254 | 142254 | 85740 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 601X Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798001 | 2114488.497614 | 37.78672294116279 | -122.398229721423 | (37.7867229411628, -122.398229721423) | |
10202 | 10202 | 173900 | Private 5 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
125580 | 125580 | 109829 | Private 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 629 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 775362 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | |||
50 | 50 | 138938 | Private 5 | Tree(s) :: 17 | 632 HAYES ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779650 | 6004797.9634 | 2110922.1515 | 37.7764612085261 | -122.426912572117 | (37.7764612085261, -122.426912572117) |
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");