Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 18492 | 18492 | 63236 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | 12 | Permit Number 23784 | 6006063.67565171 | 2104362.69748074 | 37.7585219924343 | -122.422068008351 | (37.7585219924343, -122.422068008351) | |
| 27555 | 27555 | 101445 | Permitted Site 1 | Prunus persica :: Peach 330 | 771 Stockton Tunl | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Permit Number 25247 | 6010467.187000001 | 2116750.7503 | 37.7927840821229 | -122.407712097586 | (37.7927840821229, -122.407712097586) | |||
| 52680 | 52680 | 96544 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100@ Front St Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | 2 | Permit Number 767720 | 6013029.74558 | 2116576.80835 | 37.7924495959214 | -122.39883325906099 | (37.7924495959214, -122.398833259061) | ||
| 59110 | 59110 | 93913 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1233 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | 3 | Permit Number 53384 | 6006791.18319 | 2115201.26263 | 37.7883231061636 | -122.42032123196002 | (37.7883231061636, -122.42032123196) | ||
| 79489 | 79489 | 103710 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | ||
| 80863 | 80863 | 106175 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 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) | ||||
| 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) | ||||
| 85497 | 85497 | 103713 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | |||
| 87230 | 87230 | 106179 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 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) | ||||
| 95159 | 95159 | 96547 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 4 | 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) | |||
| 96623 | 96623 | 106177 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 98016 | 98016 | 93915 | Permitted Site 1 | Tree(s) :: 17 | 1131 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53385 | 6006791.4 | 2114889.1 | 37.7874659967155 | -122.42029831720501 | (37.7874659967155, -122.420298317205) | |||
| 98599 | 98599 | 93896 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 98842 | 98842 | 106181 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 99800 | 99800 | 93888 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 99815 | 99815 | 93895 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 101067 | 101067 | 106178 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 104345 | 104345 | 106180 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 104672 | 104672 | 64402 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 05/14/1988 12:00:00 AM | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||
| 106682 | 106682 | 96543 | Permitted Site 1 | Tree(s) :: 17 | 100 Pine St | 4 | 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) | |||
| 107198 | 107198 | 93898 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 107881 | 107881 | 93889 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 109802 | 109802 | 93893 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 110127 | 110127 | 96546 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 3 | 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) | |||
| 110892 | 110892 | 96548 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 5 | 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) | |||
| 111306 | 111306 | 52287 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 72 Valley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 03/04/2011 12:00:00 AM | Permit Number 54678 | 6005433.61319764 | 2099357.0668783 | 37.7447421315969 | -122.42389111052499 | (37.7447421315969, -122.423891110525) | |||
| 112434 | 112434 | 98536 | Permitted Site 1 | Tree(s) :: 17 | 637A Capp St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/23/2012 12:00:00 AM | 3x3 | Permit Number 768694 | 6007346.4 | 2103619.4 | 37.756553332027 | -122.41757907963002 | (37.756553332027, -122.41757907963) | ||
| 113940 | 113940 | 107411 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006068.0 | 2104353.0 | 37.7584956093101 | -122.422052363883 | (37.7584956093101, -122.422052363883) | ||||
| 114639 | 114639 | 103722 | Permitted Site 1 | Tree(s) :: 17 | 238 Eddy St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/14/2014 12:00:00 AM | 3x4 | Permit Number 770336 | 6009270.0 | 2113638.0 | 37.7841701309766 | -122.4116344015 | (37.7841701309766, -122.4116344015) | ||
| 119854 | 119854 | 58338 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/07/1978 12:00:00 AM | 3x3 | Permit Number 17363 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||
| 121768 | 121768 | 93914 | Permitted Site 1 | Tree(s) :: 17 | 1131 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53385 | 6006791.4 | 2114889.1 | 37.7874659967155 | -122.42029831720501 | (37.7874659967155, -122.420298317205) | |||
| 122175 | 122175 | 93892 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 125867 | 125867 | 106176 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 126060 | 126060 | 103712 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | ||
| 127063 | 127063 | 101446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
| 127244 | 127244 | 113228 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1150 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 127599 | 127599 | 93891 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 129101 | 129101 | 106174 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
| 138268 | 138268 | 93890 | Permitted Site 1 | Tree(s) :: 17 | 425 Folsom St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6014407.0 | 2114805.0 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | ||||
| 138787 | 138787 | 113230 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1150 Polk St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006889.32859586 | 2114873.18984569 | 37.7874278290173 | -122.419958374025 | (37.7874278290173, -122.419958374025) | ||||
| 140350 | 140350 | 103723 | Permitted Site 1 | Tree(s) :: 17 | 238 Eddy St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/14/2014 12:00:00 AM | 3x4 | Permit Number 770336 | 6009270.0 | 2113638.0 | 37.7841701309766 | -122.4116344015 | (37.7841701309766, -122.4116344015) | ||
| 141907 | 141907 | 103711 | Permitted Site 1 | Tree(s) :: 17 | 520 Jones St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/13/2013 12:00:00 AM | 3x3.5 | Permit Number 770327 | 6008908.0 | 2114310.0 | 37.7859949684164 | -122.41293432549801 | (37.7859949684164, -122.412934325498) | ||
| 142312 | 142312 | 103724 | Permitted Site 1 | Tree(s) :: 17 | 238 Eddy St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/14/2014 12:00:00 AM | 3x4 | Permit Number 770336 | 6009270.0 | 2113638.0 | 37.7841701309766 | -122.4116344015 | (37.7841701309766, -122.4116344015) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 1781 | 1781 | 214663 | Undocumented 2 | Tree(s) :: 17 | 427 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/01/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779947 | 5993526.84887 | 2105257.2946900004 | 37.7602632600539 | -122.46549062240601 | (37.7602632600539, -122.465490622406) | |
| 4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
| 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) |
| 7553 | 7553 | 142835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1515 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Width 0ft | 6006663.5874 | 2116129.9342 | 37.7908658176323 | -122.42082865045799 | (37.7908658176323, -122.420828650458) | ||||
| 16896 | 16896 | 100001 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 501X 01st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Address is 100 1st Street | |||||||||
| 22812 | 22812 | 224471 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 627 Precita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6009784.7997 | 2100421.88863 | 37.7479105825135 | -122.408920592022 | (37.7479105825135, -122.408920592022) | |||
| 22852 | 22852 | 138173 | Undocumented 2 | :: 54 | 1953 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6000211.2401 | 2111613.6154 | 37.7780993776744 | -122.44282896766 | (37.7780993776744, -122.44282896766) | |||
| 22874 | 22874 | 179489 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 36 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6009813.802999999 | 2094277.0712700002 | 37.7310398674871 | -122.40838693792801 | (37.7310398674871, -122.408386937928) | |||
| 22907 | 22907 | 233756 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.04868 | 2107994.1327400003 | 37.768245263926396 | -122.43746090722 | (37.7682452639264, -122.43746090722) | |||
| 23385 | 23385 | 225339 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3033 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 6002890.27268 | 2096019.3333400001 | 37.73543357459229 | -122.43244713645001 | (37.7354335745923, -122.43244713645) | |||
| 23569 | 23569 | 211718 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Arch St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 5992705.448530001 | 2090061.4664900003 | 37.7184919399203 | -122.46722653339701 | (37.7184919399203, -122.467226533397) | |||
| 23670 | 23670 | 129807 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6010390.20829 | 2116866.53247 | 37.793097682469394 | -122.407986617304 | (37.7930976824694, -122.407986617304) | |||
| 23685 | 23685 | 131311 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3701 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5996479.01622 | 2115904.55519 | 37.7896676762649 | -122.45605029860201 | (37.7896676762649, -122.456050298602) | |||
| 23717 | 23717 | 190342 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014826.26604 | 2116061.6193 | 37.7911349426626 | -122.39258114252199 | (37.7911349426626, -122.392581142522) | |||
| 23754 | 23754 | 194580 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 598 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013513.20546 | 2104325.65158 | 37.758837617875294 | -122.39630140851001 | (37.7588376178753, -122.39630140851) | |||
| 23806 | 23806 | 232314 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007320.806890001 | 2098778.15204 | 37.7432589210582 | -122.417324523624 | (37.7432589210582, -122.417324523624) | ||||
| 23836 | 23836 | 204823 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1331 09th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5993302.77838 | 2106404.87542 | 37.7634012905668 | -122.466348974927 | (37.7634012905668, -122.466348974927) | |||
| 23903 | 23903 | 128508 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 415 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6011852.868919999 | 2116847.94752 | 37.7931284347821 | -122.40292438836 | (37.7931284347821, -122.40292438836) | |||
| 24173 | 24173 | 190232 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 536 Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6013096.96075 | 2115369.31377 | 37.7891378442858 | -122.398515922465 | (37.7891378442858, -122.398515922465) | |||
| 24220 | 24220 | 188507 | Undocumented 2 | Abutilon hybridum :: Flowering maple 339 | 1525 18th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6013039.99307 | 2105636.60333 | 37.7624108600086 | -122.398029973803 | (37.7624108600086, -122.398029973803) | |||
| 24538 | 24538 | 232518 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4518 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6000862.85333 | 2101145.4432599996 | 37.749393486316706 | -122.43982407823401 | (37.7493934863167, -122.439824078234) | |||
| 24563 | 24563 | 128713 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 555 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011289.01038 | 2117973.50016 | 37.7961874301503 | -122.404954668136 | (37.7961874301503, -122.404954668136) | |||
| 24580 | 24580 | 130549 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 341 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 2ft | 5996655.62034 | 2115093.6524799997 | 37.7874512898863 | -122.455380640001 | (37.7874512898863, -122.455380640001) | |||
| 24601 | 24601 | 138420 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1819 STEINER ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 0ft | 6002521.5979 | 2114452.899 | 37.786026776312596 | -122.435039736101 | (37.7860267763126, -122.435039736101) | |||
| 24608 | 24608 | 128760 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 145 Geary St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6010990.83089 | 2114854.39463 | 37.7876064418291 | -122.405766620129 | (37.7876064418291, -122.405766620129) | |||
| 24682 | 24682 | 203198 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 91 Market St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 6013828.57328 | 2116873.69458 | 37.7933092533841 | -122.39609008760401 | (37.7933092533841, -122.396090087604) | |||
| 24709 | 24709 | 182142 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 0ft | 5988379.3786 | 2105646.1459999997 | 37.761032715479395 | -122.483321592218 | (37.7610327154794, -122.483321592218) | |||
| 24727 | 24727 | 129157 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5997198.13027 | 2114418.3589 | 37.785628226512706 | -122.45345490104499 | (37.7856282265127, -122.453454901045) | |||
| 24769 | 24769 | 244936 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 294 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 0ft | 6005165.6636 | 2109931.2421 | 37.7737611964044 | -122.425570051796 | (37.7737611964044, -122.425570051796) | |||
| 24801 | 24801 | 179172 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 766 Brussels St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011071.2158 | 2091212.4916599998 | 37.7226955033774 | -122.403824260795 | (37.7226955033774, -122.403824260795) | |||
| 24832 | 24832 | 246304 | Undocumented 2 | Brachychiton populneus :: Bottle Tree 329 | 3996 17th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6002336.3946 | 2105898.3028 | 37.7625274658745 | -122.435068430359 | (37.7625274658745, -122.435068430359) | |||
| 24865 | 24865 | 127538 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 170 O'Farrell St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6010539.53779 | 2114494.20954 | 37.7865922116181 | -122.40730261183701 | (37.7865922116181, -122.407302611837) | |||
| 25005 | 25005 | 177418 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6009516.77243 | 2090302.7647799999 | 37.720110619797104 | -122.409133494811 | (37.7201106197971, -122.409133494811) | |||
| 25040 | 25040 | 210510 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 5997279.39992 | 2098558.56074 | 37.7420859128371 | -122.452029069086 | (37.7420859128371, -122.452029069086) | |||
| 25089 | 25089 | 224296 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 5 Powhattan Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 43 | Width 3ft | 6007487.03456 | 2098209.30712 | 37.7417063503734 | -122.416709460186 | (37.7417063503734, -122.416709460186) | |||
| 25116 | 25116 | 132137 | Undocumented 2 | Phoenix roebelenii :: Pigmy Date Palm 344 | 576 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6011959.93168 | 2117122.22989 | 37.7938875264289 | -122.40257323908999 | (37.7938875264289, -122.40257323909) | |||
| 25128 | 25128 | 143413 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Kearny St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011351.7699 | 2116964.7162 | 37.7934210599755 | -122.404666454604 | (37.7934210599755, -122.404666454604) | |||
| 25173 | 25173 | 140670 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 40 COLE ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5997774.3514 | 2110415.6204 | 37.7746707659902 | -122.451172585534 | (37.7746707659902, -122.451172585534) | |||
| 25630 | 25630 | 194576 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 572 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6013508.15849 | 2104424.13067 | 37.7591077391483 | -122.396325765734 | (37.7591077391483, -122.396325765734) | |||
| 25634 | 25634 | 128547 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 530 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6011621.44747 | 2116740.1603200003 | 37.792819551831 | -122.40371753735 | (37.792819551831, -122.40371753735) | |||
| 25652 | 25652 | 193862 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90 Stevenson St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6012460.38897 | 2115317.66617 | 37.7889605483383 | -122.40071476487101 | (37.7889605483383, -122.400714764871) | |||
| 25730 | 25730 | 233142 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Worth St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000859.74729 | 2102942.63257 | 37.754327958491395 | -122.43996366469901 | (37.7543279584914, -122.439963664699) | |||
| 25825 | 25825 | 233757 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.84947 | 2107982.08951 | 37.7682122417201 | -122.437457274854 | (37.7682122417201, -122.437457274854) | |||
| 25845 | 25845 | 237234 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5998175.72217 | 2105385.27781 | 37.7608816968555 | -122.449421648503 | (37.7608816968555, -122.449421648503) | |||
| 26021 | 26021 | 137509 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 85 Toledo Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6001461.48208 | 2119936.52079 | 37.801023121670106 | -122.439100597914 | (37.8010231216701, -122.439100597914) | |||
| 26027 | 26027 | 227311 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 405 Beacon St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002323.66405 | 2098293.59277 | 37.7416460184529 | -122.434568676724 | (37.7416460184529, -122.434568676724) |
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");