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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5640 | 5640 | 79352 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 8 | 3x3 | 5999487.033 | 2114286.0485 | 37.785395874336 | -122.445526470028 | (37.785395874336, -122.445526470028) | |
| 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) | |||
| 6616 | 6616 | 43072 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 775 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 6 | 3x3 | 6008014.74915 | 2114436.68155 | 37.7862926240458 | -122.41603371409799 | (37.7862926240458, -122.416033714098) | |
| 6966 | 6966 | 120642 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 795 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2016 12:00:00 AM | 3 | 3x3 | 6008851.25075 | 2115247.06869 | 37.788564746801896 | -122.413196950189 | (37.7885647468019, -122.413196950189) | |
| 7047 | 7047 | 71287 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 225 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/1982 12:00:00 AM | 6 | 5998480.7052 | 2112368.9268 | 37.780074457240794 | -122.448869905513 | (37.7800744572408, -122.448869905513) | ||
| 7256 | 7256 | 71253 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1436 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 10 | 3x3 | 6007270.15279 | 2117448.61656 | 37.7945207624857 | -122.418823519012 | (37.7945207624857, -122.418823519012) | |
| 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 | ||||||||
| 8004 | 8004 | 110481 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 573 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/2016 12:00:00 AM | 3 | 4x4 | 6002115.7966 | 2110416.1461 | 37.7749198214087 | -122.436154715842 | (37.7749198214087, -122.436154715842) | |
| 8381 | 8381 | 71797 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.44990310006399 | (37.7733879494567, -122.449903100064) | ||
| 8730 | 8730 | 97454 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.805910669901294 | -122.41950228141899 | (37.8059106699013, -122.419502281419) | |
| 8830 | 8830 | 71801 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2170 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 8 | 5997504.5785 | 2109900.8998 | 37.77324202696929 | -122.452068634732 | (37.7732420269693, -122.452068634732) | ||
| 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) | ||||
| 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) | ||||
| 10248 | 10248 | 69823 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 490 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2017 12:00:00 AM | 3 | 5985346.30869 | 2112623.83377 | 37.7800144848575 | -122.49432585822201 | (37.7800144848575, -122.494325858222) | ||
| 10356 | 10356 | 75141 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 5 | 4x4 | 6005823.096940001 | 2092308.52948 | 37.7254103965462 | -122.422043716969 | (37.7254103965462, -122.422043716969) | |
| 10461 | 10461 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | |
| 10568 | 10568 | 75056 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 12 | 4x4 | 6005836.26564 | 2092311.52216 | 37.7254193565072 | -122.421998406407 | (37.7254193565072, -122.421998406407) | |
| 10582 | 10582 | 69800 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 367 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 3x3 | 5999779.7835 | 2091764.7216900003 | 37.7235745268131 | -122.442895800812 | (37.7235745268131, -122.442895800812) | |
| 10597 | 10597 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.73570120363421 | -122.491429290175 | (37.7357012036342, -122.491429290175) | |
| 10633 | 10633 | 78424 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 337 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 12 | 3x3 | 6001367.33803 | 2089018.36243 | 37.716124024086 | -122.43721136872499 | (37.716124024086, -122.437211368725) | |
| 10790 | 10790 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.49125558617901 | (37.735588983385, -122.491255586179) | ||
| 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) | ||
| 10885 | 10885 | 75223 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 5 | 3x3 | 6005812.42229 | 2092304.2308200002 | 37.7253979913003 | -122.42208031306801 | (37.7253979913003, -122.422080313068) | |
| 10899 | 10899 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | |
| 10912 | 10912 | 75399 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 12 | 4x6 | 5988689.6276 | 2099701.3205 | 37.7447278644639 | -122.48181312543501 | (37.7447278644639, -122.481813125435) | |
| 10939 | 10939 | 75321 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1350 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 9x4 | 5988672.5581 | 2099700.4669999997 | 37.7447245283024 | -122.481872085268 | (37.7447245283024, -122.481872085268) | |
| 11186 | 11186 | 108449 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 90-98X Prague St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6004652.59412 | 2090606.81694 | 37.7206717805504 | -122.42596895909901 | (37.7206717805504, -122.425968959099) | |
| 11621 | 11621 | 76445 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998808.0264099995 | 2086988.0844400001 | 37.710403523785 | -122.445911599067 | (37.710403523785, -122.445911599067) | |
| 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) | |||
| 11652 | 11652 | 75299 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 3x3 | 6005800.51839 | 2092301.4633900002 | 37.7253897211337 | -122.422121267299 | (37.7253897211337, -122.422121267299) | |
| 12245 | 12245 | 72809 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998733.92072 | 2087172.14442 | 37.710904679081395 | -122.446180954109 | (37.7109046790814, -122.446180954109) | |
| 12317 | 12317 | 75378 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 3x3 | 6005787.8485 | 2092298.2096 | 37.7253800723092 | -122.422164834944 | (37.7253800723092, -122.422164834944) | |
| 12363 | 12363 | 92312 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2711 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985822.132 | 2096946.3119 | 37.7369961745626 | -122.49152548244 | (37.7369961745626, -122.49152548244) | |
| 12422 | 12422 | 70297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2016 12:00:00 AM | 3 | 6003327.44558 | 2094643.03884 | 37.7316793628021 | -122.43083747856001 | (37.7316793628021, -122.43083747856) | ||
| 12500 | 12500 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988222999 | (37.7356241060746, -122.49141988223) | |
| 12651 | 12651 | 73720 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 157 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 3x3 | 6001432.84153 | 2093102.8758 | 37.7273429002463 | -122.437277252154 | (37.7273429002463, -122.437277252154) | |
| 12690 | 12690 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | |
| 12818 | 12818 | 72149 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 157 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/1985 12:00:00 AM | 22 | 3x3 | 6001449.82558 | 2093091.8640599998 | 37.727313630005895 | -122.437217750315 | (37.7273136300059, -122.437217750315) | |
| 12983 | 12983 | 73822 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 10 | 3x3 | 5998761.76944 | 2087100.1867 | 37.7107086898252 | -122.44607953033999 | (37.7107086898252, -122.44607953034) | |
| 12985 | 12985 | 76427 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 118X Lowell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 3 | 3x3 | 5998792.69271 | 2087037.2667900003 | 37.710537691825294 | -122.445968130449 | (37.7105376918253, -122.445968130449) | |
| 13056 | 13056 | 108448 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 90-98X Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6004670.84101 | 2090640.5659299998 | 37.7207654791334 | -122.42590828635599 | (37.7207654791334, -122.425908286356) | |
| 13114 | 13114 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511002 | (37.7355642757438, -122.49142378511) | |
| 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) | ||
| 13616 | 13616 | 83038 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | |||
| 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) | ||
| 13795 | 13795 | 78433 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 870 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2016 12:00:00 AM | 3 | 6011558.925919999 | 2104265.3143 | 37.7585630053957 | -122.403056007737 | (37.7585630053957, -122.403056007737) | ||
| 13897 | 13897 | 83463 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1011 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | 6 | 3x3 | 6010416.80991 | 2111846.95811 | 37.77931661531171 | -122.407540511299 | (37.7793166153117, -122.407540511299) | |
| 14059 | 14059 | 73480 | Undocumented 2 | Acacia cognata :: River Wattle 249 | 599x 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1994 12:00:00 AM | 14 | 3x3 | 6013522.7636400005 | 2111545.67763 | 37.7786627326451 | -122.39677451844601 | (37.7786627326451, -122.396774518446) | |
| 14217 | 14217 | 82927 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1140 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2005 12:00:00 AM | 3 | 3x3 | 6010031.8585 | 2110690.2274 | 37.776118949001706 | -122.40879059487 | (37.7761189490017, -122.40879059487) | |
| 14304 | 14304 | 110654 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2015 12:00:00 AM | 3 | 3x3 | 6012037.262709999 | 2106026.3006599997 | 37.763424983208 | -122.40152545783 | (37.763424983208, -122.40152545783) | |
| 14466 | 14466 | 73241 | Undocumented 2 | Koelreuteria bipinnata :: Chinese Flame Tree 283 | 917 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 12 | 6x15 | 6015272.446409999 | 2104314.96126 | 37.7589060005196 | -122.390216339206 | (37.7589060005196, -122.390216339206) | |
| 15219 | 15219 | 74369 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 535 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 2 | 8x4 | 6009942.57894 | 2111988.4402900003 | 37.7796785357608 | -122.40919106762101 | (37.7796785357608, -122.409191067621) | |
| 15329 | 15329 | 83441 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 325 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 3 | 3x3 | 6014074.068940001 | 2105534.94834 | 37.7621892769404 | -122.39444634273899 | (37.7621892769404, -122.394446342739) | |
| 15476 | 15476 | 110656 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 500 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2015 12:00:00 AM | 3 | 3x3 | 6012024.49835 | 2106000.36066 | 37.7633530455212 | -122.40156778264 | (37.7633530455212, -122.40156778264) | |
| 15681 | 15681 | 73555 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 315 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 8 | 6011765.85635 | 2112068.38095 | 37.7800000110193 | -122.402889147539 | (37.7800000110193, -122.402889147539) | ||
| 15700 | 15700 | 72422 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2400 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1996 12:00:00 AM | 10 | 3x3 | 6010224.23312 | 2105998.24791 | 37.7632466260627 | -122.40779419295299 | (37.7632466260627, -122.407794192953) | |
| 16719 | 16719 | 71331 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 315 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 8 | 6011757.84173 | 2112077.6198 | 37.780024931232795 | -122.402917523848 | (37.7800249312328, -122.402917523848) | ||
| 16724 | 16724 | 74019 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2400 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1996 12:00:00 AM | 10 | 3x3 | 6010272.25282 | 2105997.87843 | 37.7632482996846 | -122.40762808187799 | (37.7632482996846, -122.407628081878) | |
| 18190 | 18190 | 73083 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1999 12:00:00 AM | 3x3 | 6007158.13725384 | 2106179.72119915 | 37.7635727856768 | -122.41841169643601 | (37.7635727856768, -122.418411696436) | ||
| 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) | |||||
| 19054 | 19054 | 94934 | Significant Tree 6 | Ficus carica 'Black Mission' :: Black Mission Fig 311 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 04/04/2009 12:00:00 AM | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | ||||
| 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 | ||||||||
| 22988 | 22988 | 70383 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | ||
| 23201 | 23201 | 69744 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1855X Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/16/2002 12:00:00 AM | 8 | 3x3 | 6014390.51341 | 2099418.69013 | 37.7454129250631 | -122.392923937985 | (37.7454129250631, -122.392923937985) | |
| 23470 | 23470 | 71021 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 511 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 6 | 5990601.64729 | 2111881.43393 | 37.7782822050168 | -122.476091231143 | (37.7782822050168, -122.476091231143) | ||
| 23649 | 23649 | 83478 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 729 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 10 | 6015481.04355 | 2105634.6159 | 37.762541056634 | -122.38958707191001 | (37.762541056634, -122.38958707191) | ||
| 23667 | 23667 | 71626 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6010902.3539 | 2118984.9834 | 37.7989430963584 | -122.406363890018 | (37.7989430963584, -122.406363890018) | ||
| 23692 | 23692 | 71227 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.48543517398599 | (37.7450642803204, -122.485435173986) | ||
| 23821 | 23821 | 74230 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1011 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/1996 12:00:00 AM | 10 | 6011143.4423 | 2118449.9882 | 37.797487612886705 | -122.40549194088301 | (37.7974876128867, -122.405491940883) | ||
| 23884 | 23884 | 70675 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 49 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 11 | 6009740.45587 | 2110875.89947 | 37.7766124348397 | -122.409811748212 | (37.7766124348397, -122.409811748212) | ||
| 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) | |||
| 23899 | 23899 | 72385 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 686 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 8 | 5995057.69186 | 2110887.03516 | 37.775809229939206 | -122.460604158861 | (37.7758092299392, -122.460604158861) | ||
| 23971 | 23971 | 78224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6009704.84764 | 2090538.9392099997 | 37.7207696402774 | -122.40850003035101 | (37.7207696402774, -122.408500030351) | ||
| 24154 | 24154 | 79962 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 751 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2002 12:00:00 AM | 2 | 5991293.33065 | 2110344.2165900003 | 37.774101509723 | -122.47358630593399 | (37.774101509723, -122.473586305934) | ||
| 24362 | 24362 | 73557 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 734 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 15 | 5982628.313080001 | 2110748.29603 | 37.774705372511704 | -122.50358954053301 | (37.7747053725117, -122.503589540533) | ||
| 24547 | 24547 | 83274 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1639X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 5 | 6008741.72565 | 2118600.6509700003 | 37.7977667125146 | -122.41381320433001 | (37.7977667125146, -122.41381320433) | ||
| 24705 | 24705 | 74639 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 749 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 3 | 6007029.8225 | 2113512.7316900003 | 37.7837002581006 | -122.419375743216 | (37.7837002581006, -122.419375743216) | ||
| 24726 | 24726 | 72266 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325116999 | (37.7230023412585, -122.43384325117) | ||
| 24817 | 24817 | 70493 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 53 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6005304.47442 | 2091965.6716099998 | 37.7244397195916 | -122.42381218159599 | (37.7244397195916, -122.423812181596) | ||
| 24978 | 24978 | 70667 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 8 | 6009828.97228 | 2111081.0117200003 | 37.777180585152394 | -122.40952002252399 | (37.7771805851524, -122.409520022524) | ||
| 25010 | 25010 | 78257 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 538 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003439.3186800005 | 2090205.80452 | 37.7195020449593 | -122.430134279779 | (37.7195020449593, -122.430134279779) | ||
| 25042 | 25042 | 70403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 215 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 18 | 6006511.50188 | 2092924.3025099998 | 37.7271399781258 | -122.419707630826 | (37.7271399781258, -122.419707630826) | ||
| 25178 | 25178 | 71050 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 11 | 6011229.446 | 2095779.1610400002 | 37.735243464197296 | -122.403598436523 | (37.7352434641973, -122.403598436523) | ||
| 25304 | 25304 | 78734 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 901 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 4 | 5997023.15719 | 2086886.0352900003 | 37.710021240846 | -122.452073093618 | (37.710021240846, -122.452073093618) | ||
| 25531 | 25531 | 70321 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 148 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 11 | 7x6 | 5997828.6446 | 2110019.5409 | 37.7735863423596 | -122.45095620867501 | (37.7735863423596, -122.450956208675) | |
| 25537 | 25537 | 71240 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.43840717979201 | (37.781532142896, -122.438407179792) | ||
| 25545 | 25545 | 71820 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1262 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1982 12:00:00 AM | 11 | 5988034.0091 | 2106701.9931 | 37.763911677097894 | -122.484593510615 | (37.7639116770979, -122.484593510615) | ||
| 25548 | 25548 | 71937 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1053 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011562.24883 | 2118965.23166 | 37.7989257551836 | -122.404079031531 | (37.7989257551836, -122.404079031531) | ||
| 25755 | 25755 | 70316 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1574 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 9 | 5984074.4364 | 2104459.8766 | 37.7575240722826 | -122.49812267764 | (37.7575240722826, -122.49812267764) | ||
| 25783 | 25783 | 70682 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 414 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 8 | 6010606.08274 | 2106339.87511 | 37.764206026409795 | -122.406497569303 | (37.7642060264098, -122.406497569303) | ||
| 25826 | 25826 | 78305 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4435 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 14 | 5984852.19199 | 2111745.44954 | 37.777573766565396 | -122.49597038603301 | (37.7775737665654, -122.495970386033) | ||
| 25838 | 25838 | 75303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 376 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 1 | 6010591.15079 | 2106579.14528 | 37.7648621726769 | -122.40656607695699 | (37.7648621726769, -122.406566076957) | ||
| 25852 | 25852 | 70376 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1434 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 17 | 5982801.126 | 2105356.1278 | 37.7599101850833 | -122.502592561024 | (37.7599101850833, -122.502592561024) |
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");