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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 1846 | 1846 | 251738 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 859 Prague St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6002345.06488 | 2087027.78932 | 37.7107138789231 | -122.433689697349 | (37.7107138789231, -122.433689697349) | ||||
| 3387 | 3387 | 161273 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002889.180369999 | 2090346.5289900003 | 37.719857269085104 | -122.432045948864 | (37.7198572690851, -122.432045948864) | ||
| 3455 | 3455 | 160606 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 745 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002538.27018 | 2089198.0058799998 | 37.716683778298 | -122.43317690119301 | (37.716683778298, -122.433176901193) | ||
| 3759 | 3759 | 253555 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 27 Ceres St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | FUF 1 | 6013919.66127 | 2093997.4229599999 | 37.730501082737604 | -122.394172607985 | (37.7305010827376, -122.394172607985) | ||||
| 4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
| 5176 | 5176 | 253818 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 219 Concord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||||
| 5256 | 5256 | 253838 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1458 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5.5x4 | 5981900.0 | 2105162.0 | 37.759324170949604 | -122.505694672765 | (37.7593241709496, -122.505694672765) | |||
| 5969 | 5969 | 111118 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 5997454.0334 | 2109847.6499 | 37.7730929211041 | -122.45223963309401 | (37.7730929211041, -122.452239633094) | |||
| 6158 | 6158 | 111117 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5997427.9716 | 2109844.5838 | 37.7730830093731 | -122.452329562425 | (37.7730830093731, -122.452329562425) | |||
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 9563 | 9563 | 108596 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 36 Bronte St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 770949 | 6009339.44395 | 2097251.26276 | 37.7391797819084 | -122.410236794344 | (37.7391797819084, -122.410236794344) | ||
| 9827 | 9827 | 173704 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 99x Majestic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5997184.0 | 2089426.0 | 37.7170046100656 | -122.451700294591 | (37.7170046100656, -122.451700294591) | |||
| 9954 | 9954 | 173752 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1291 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5994529.13136199 | 2106735.38069373 | 37.7643794565111 | -122.46213141846201 | (37.7643794565111, -122.462131418462) | |||
| 9956 | 9956 | 173750 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 989 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007621.28893018 | 2103912.36255672 | 37.7573732040434 | -122.41664916584601 | (37.7573732040434, -122.416649165846) | ||||
| 10027 | 10027 | 122385 | Undocumented 2 | Tree(s) :: 17 | 1642 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 778904 | 5990935.0 | 2104213.0 | 37.7572460781285 | -122.474378311379 | (37.7572460781285, -122.474378311379) | ||
| 10035 | 10035 | 173805 | Permitted Site 1 | Private shrub :: Private Shrub 64 | 221 Stillings Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999380.73268965 | 2095746.24622826 | 37.7344841059817 | -122.444561268208 | (37.7344841059817, -122.444561268208) | ||||
| 10860 | 10860 | 104506 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 631 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6002582.75614 | 2089515.1433 | 37.7175570910528 | -122.43304578096 | (37.7175570910528, -122.43304578096) | ||
| 11636 | 11636 | 92966 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2186 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5981735.5599 | 2100228.0428 | 37.7457672370442 | -122.505897577684 | (37.7457672370442, -122.505897577684) | |||
| 13187 | 13187 | 106199 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2107 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 3x4 | 5983225.8003 | 2100763.9337 | 37.74732624942661 | -122.500784246807 | (37.7473262494266, -122.500784246807) | ||
| 13344 | 13344 | 187697 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1256 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.41284238591601 | (37.7500562758063, -122.412842385916) | ||||
| 13559 | 13559 | 106005 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 59 Reddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6013632.51665 | 2093922.487 | 37.7302793593954 | -122.395160068985 | (37.7302793593954, -122.395160068985) | ||
| 13782 | 13782 | 121585 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 424 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6013758.73818 | 2105099.18568 | 37.760975233543 | -122.395506429391 | (37.760975233543, -122.395506429391) | ||
| 15030 | 15030 | 101775 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1700 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 3x3 | Permit Number 19103 | 6014052.75296 | 2093112.8912 | 37.728079734566606 | -122.393650601914 | (37.7280797345666, -122.393650601914) | |
| 16234 | 16234 | 96620 | Permitted Site 1 | Azara microphylla :: Little-Leaf Azara 295 | 525 Phelps St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 15 | 5x15 | Permit Number 48345 | 6015380.46656 | 2098080.19885 | 37.741792643019096 | -122.38940735498801 | (37.7417926430191, -122.389407354988) | |
| 19027 | 19027 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 37 | 26 Gilbert St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | |||||
| 19276 | 19276 | 108963 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 20943 | 20943 | 6386 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 205 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6006831.93965 | 2097911.00568 | 37.7408504143285 | -122.418953412568 | (37.7408504143285, -122.418953412568) | ||
| 22409 | 22409 | 249318 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 26077 | 26077 | 98248 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | I believe these were planted in 2010 by FUF. C.Buck | 6007281.495490001 | 2113344.84788 | 37.7832534614285 | -122.41849313956001 | (37.7832534614285, -122.41849313956) | |
| 27331 | 27331 | 117477 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1999X Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | Permit Number 778454 | 6004121.651819999 | 2117991.3278099997 | 37.7958331278375 | -122.429756453008 | (37.7958331278375, -122.429756453008) | ||
| 27427 | 27427 | 109082 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5993123.846940001 | 2113007.94423 | 37.7815212258156 | -122.46744802506399 | (37.7815212258156, -122.467448025064) | |||
| 28065 | 28065 | 84526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1607 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985279.5041 | 2104240.0581 | 37.756991093889496 | -122.49393892942699 | (37.7569910938895, -122.493938929427) | |||
| 28159 | 28159 | 116806 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1300 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 5991537.4363400005 | 2110683.08947 | 37.7750460962456 | -122.472766623766 | (37.7750460962456, -122.472766623766) | |||
| 28970 | 28970 | 84365 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 129 Escolta Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5986616.9958 | 2097211.3869 | 37.7377704195158 | -122.488796798517 | (37.7377704195158, -122.488796798517) | |||
| 30447 | 30447 | 114559 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1551 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 5x6 | 5986195.2764 | 2104674.6971 | 37.7582380320911 | -122.490803866981 | (37.7582380320911, -122.490803866981) | ||
| 30893 | 30893 | 81813 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1419 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5988645.6741 | 2105641.5626 | 37.7610356250119 | -122.482400266833 | (37.7610356250119, -122.482400266833) | |||
| 31787 | 31787 | 121581 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6013754.46885 | 2106222.8302700003 | 37.764060277784 | -122.395599922908 | (37.764060277784, -122.395599922908) | ||
| 32214 | 32214 | 121078 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 726 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 4x4 | 6007074.608519999 | 2113528.41761 | 37.7837458501408 | -122.419221913271 | (37.7837458501408, -122.419221913271) | ||
| 33883 | 33883 | 110043 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 890 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 9 | 6011841.59848 | 2104237.14125 | 37.7585014297196 | -122.402076412192 | (37.7585014297196, -122.402076412192) | |||
| 34385 | 34385 | 109079 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5993122.1097099995 | 2113067.45423 | 37.7816845237935 | -122.46745836376999 | (37.7816845237935, -122.46745836377) | |||
| 36317 | 36317 | 108395 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 311 Ordway St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6011028.372719999 | 2090050.89786 | 37.7195036115824 | -122.403890660433 | (37.7195036115824, -122.403890660433) | ||
| 36445 | 36445 | 106365 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1970 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 4x2 | 5981684.7966 | 2101671.2426 | 37.7497268716349 | -122.506180099858 | (37.7497268716349, -122.506180099858) | ||
| 38343 | 38343 | 122390 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x2 | 5991007.0 | 2102078.0 | 37.7513881006776 | -122.47397354599501 | (37.7513881006776, -122.473973545995) | |||
| 39790 | 39790 | 79264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.47853534669399 | (37.7845600440954, -122.478535346694) | |||
| 39825 | 39825 | 83498 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1840 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987237.7366 | 2102721.865 | 37.752936928713495 | -122.48705521280199 | (37.7529369287135, -122.487055212802) | |||
| 41039 | 41039 | 110469 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005632.4002 | 2111334.52 | 37.777640618295706 | -122.42405534708901 | (37.7776406182957, -122.424055347089) | ||
| 41359 | 41359 | 80821 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 843 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 5988489.67822 | 2110248.9611400003 | 37.7736771996736 | -122.48327752702299 | (37.7736771996736, -122.483277527023) | |||
| 41932 | 41932 | 114086 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 20 Cook St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5997489.0948 | 2113600.1035 | 37.783398187645 | -122.45238918542401 | (37.783398187645, -122.452389185424) | |||
| 43230 | 43230 | 81651 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100@ 12th Ave Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | Permit Number 767881 | 5992197.33713 | 2110704.35062 | 37.7751426520596 | -122.470485452724 | (37.7751426520596, -122.470485452724) | ||
| 43730 | 43730 | 110480 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 573 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 6002112.3456 | 2110445.7265 | 37.7750008457371 | -122.436168770849 | (37.7750008457371, -122.436168770849) | |||
| 44768 | 44768 | 121639 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 6000575.25086 | 2092201.75917 | 37.7248198513454 | -122.440177342728 | (37.7248198513454, -122.440177342728) | |||
| 46325 | 46325 | 82058 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2663 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 5988935.079 | 2097218.8486 | 37.737925915904896 | -122.480782703185 | (37.7379259159049, -122.480782703185) | |||
| 46752 | 46752 | 121094 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1697 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 3x3 | 6001082.7006 | 2111393.2018 | 37.777543821113206 | -122.43979847194099 | (37.7775438211132, -122.439798471941) | ||
| 46823 | 46823 | 114049 | Undocumented 2 | Betula spp :: Birch 95 | 1190 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6017122.5886 | 2092569.8305 | 37.7267587013694 | -122.38300019404801 | (37.7267587013694, -122.383000194048) | ||
| 47382 | 47382 | 84587 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2374 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5981781.9237 | 2098926.9802 | 37.7421976095989 | -122.50564083146999 | (37.7421976095989, -122.50564083147) | |||
| 48882 | 48882 | 111292 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 291 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5991505.832330001 | 2113494.12901 | 37.78276261074429 | -122.47308099011002 | (37.7827626107443, -122.47308099011) | |||
| 49381 | 49381 | 109083 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 9 | 5993121.9003800005 | 2112970.33483 | 37.7814178482518 | -122.46745202346001 | (37.7814178482518, -122.46745202346) | |||
| 50399 | 50399 | 83940 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 346 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 6002623.3428 | 2091444.05642 | 37.722855759877895 | -122.43304322866999 | (37.7228557598779, -122.43304322867) | |||
| 51321 | 51321 | 115599 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 699 02nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6015347.857021701 | 2112248.60687265 | 37.7806942317989 | -122.390509891446 | (37.7806942317989, -122.390509891446) | |||
| 53655 | 53655 | 112501 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 801 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 2x2 | 5993015.96784 | 2113442.43109 | 37.782707979643504 | -122.467852842771 | (37.7827079796435, -122.467852842771) | ||
| 54494 | 54494 | 83988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6004863.63581 | 2090857.16015 | 37.7213710933771 | -122.425257258112 | (37.7213710933771, -122.425257258112) | |||
| 55462 | 55462 | 113717 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 5991400.52029 | 2110673.00421 | 37.775010478076794 | -122.47323950591299 | (37.7750104780768, -122.473239505913) | |||
| 56054 | 56054 | 114089 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 20 Cook St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5997479.2806 | 2113658.9889 | 37.78355930916071 | -122.452427389255 | (37.7835593091607, -122.452427389255) | |||
| 57301 | 57301 | 83542 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 19 | 5980747.696719999 | 2109761.67142 | 37.7718856460039 | -122.51002154176399 | (37.7718856460039, -122.510021541764) | |||
| 57867 | 57867 | 79130 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1293 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987372.1815 | 2106509.2764 | 37.763343966061896 | -122.486868390866 | (37.7633439660619, -122.486868390866) | |||
| 58276 | 58276 | 122823 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | ||
| 58748 | 58748 | 121640 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Otsego Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 17 | 6000583.2387 | 2092221.3848599999 | 37.724874193767796 | -122.440151136477 | (37.7248741937678, -122.440151136477) | |||
| 58950 | 58950 | 121048 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2652 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006192.78395747 | 2119877.54417008 | 37.80112926306921 | -122.422724050002 | (37.8011292630692, -122.422724050002) | ||||
| 58967 | 58967 | 96572 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 59233 | 59233 | 108371 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.719605888781295 | -122.43642558878 | (37.7196058887813, -122.43642558878) | ||
| 59442 | 59442 | 80399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1359 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5985221.9445 | 2105957.3134 | 37.7617028317997 | -122.494264562885 | (37.7617028317997, -122.494264562885) | |||
| 59855 | 59855 | 82988 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1345 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6008577.18796 | 2110086.84492 | 37.7743806179076 | -122.41378001753701 | (37.7743806179076, -122.413780017537) | |||
| 59973 | 59973 | 82021 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1550 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5987476.0557 | 2104733.3067 | 37.75847369503 | -122.48637873374099 | (37.75847369503, -122.486378733741) | |||
| 61145 | 61145 | 95563 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003239.0 | 2102086.6 | 37.75211264995529 | -122.43167449646799 | (37.7521126499553, -122.431674496468) | |||
| 61360 | 61360 | 83419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988867.9747 | 2099162.5294 | 37.7432588555713 | -122.48115699763201 | (37.7432588555713, -122.481156997632) | |||
| 62195 | 62195 | 84689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6002195.05393 | 2120739.39081 | 37.80326930438871 | -122.436619630107 | (37.8032693043887, -122.436619630107) | |||
| 63984 | 63984 | 121080 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 726 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 6007066.4684 | 2113565.1138400002 | 37.78384615061189 | -122.419252679062 | (37.7838461506119, -122.419252679062) | |||
| 64744 | 64744 | 114084 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 20 Cook St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 17 | 5997493.8327 | 2113562.2002 | 37.783294386609796 | -122.452370058209 | (37.7832943866098, -122.452370058209) | |||
| 65198 | 65198 | 82609 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 343 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 5990560.55724 | 2113091.75493 | 37.7816030289127 | -122.476321807103 | (37.7816030289127, -122.476321807103) | |||
| 65671 | 65671 | 78959 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2083 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5987558.9086 | 2101118.3339 | 37.748552784681 | -122.485826868551 | (37.748552784681, -122.485826868551) | |||
| 66019 | 66019 | 111476 | Permitted Site 1 | Tree(s) :: 17 | 2x TRAINOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | |||
| 66616 | 66616 | 110470 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005644.9931 | 2111337.1436 | 37.777648533038395 | -122.42401197054701 | (37.7776485330384, -122.424011970547) | ||
| 68176 | 68176 | 110468 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005616.1343 | 2111331.3718 | 37.7776310557335 | -122.42411139247 | (37.7776310557335, -122.42411139247) | ||
| 69699 | 69699 | 109081 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5993122.61553 | 2113029.97254 | 37.7815816384713 | -122.46745388745701 | (37.7815816384713, -122.467453887457) | |||
| 69765 | 69765 | 83695 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2434 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5986135.3818 | 2098661.4883 | 37.741723893319 | -122.49056860476601 | (37.741723893319, -122.490568604766) | |||
| 69848 | 69848 | 81662 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 563 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5991577.12734 | 2111607.04314 | 37.7775853186785 | -122.472696706975 | (37.7775853186785, -122.472696706975) | |||
| 70462 | 70462 | 81627 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 351 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 5990871.84274 | 2113035.63499 | 37.781466986417605 | -122.475240820306 | (37.7814669864176, -122.475240820306) | |||
| 70536 | 70536 | 83955 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 6005194.32236 | 2092948.4396799998 | 37.7271319660671 | -122.42426282649099 | (37.7271319660671, -122.424262826491) | |||
| 71159 | 71159 | 84446 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6000457.5617 | 2112125.7689 | 37.77951966026271 | -122.442013625663 | (37.7795196602627, -122.442013625663) | |||
| 72482 | 72482 | 116841 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 2344 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6002015.0 | 2107091.0 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | |||
| 72719 | 72719 | 116386 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 3x3 | 6012827.44648 | 2106665.0509 | 37.765222908729996 | -122.398837280835 | (37.76522290873, -122.398837280835) | ||
| 72782 | 72782 | 102646 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 650X Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | Permit Number 28309 | 6008830.0317 | 2114874.50645 | 37.7875405898706 | -122.413244009 | (37.7875405898706, -122.413244009) | |
| 73278 | 73278 | 113422 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1583 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 3x3 | 6015014.3399 | 2094064.2928 | 37.7307454784064 | -122.390392783554 | (37.7307454784064, -122.390392783554) | ||
| 73309 | 73309 | 110467 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005585.7014 | 2111327.1742 | 37.7776178118347 | -122.424216371681 | (37.7776178118347, -122.424216371681) | ||
| 74070 | 74070 | 110466 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 16 | 3x3 | 6005573.1085 | 2111325.0754 | 37.777611337989605 | -122.42425978551701 | (37.7776113379896, -122.424259785517) | ||
| 74615 | 74615 | 78962 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2324 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6000164.38759 | 2119919.6080400003 | 37.8009027932886 | -122.443587870495 | (37.8009027932886, -122.443587870495) | |||
| 75438 | 75438 | 112502 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 801 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 2x2 | 5993032.4422699995 | 2113443.17737 | 37.7827109800118 | -122.46779590302799 | (37.7827109800118, -122.467795903028) | ||
| 76012 | 76012 | 97025 | Property Tree 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) |
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");