Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 142088 | 142088 | 114593 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1 BRADFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | 6x9 | 6009441.0 | 2096050.0 | 37.735887066073104 | -122.409800886333 | (37.7358870660731, -122.409800886333) | |||
| 76166 | 76166 | 108293 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 79166 | 79166 | 108289 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 82065 | 82065 | 108279 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 84119 | 84119 | 108284 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1 HENRY ADAMS ST | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 84985 | 84985 | 108281 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 96207 | 96207 | 108286 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1 HENRY ADAMS ST | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 106924 | 106924 | 108287 | Undocumented 2 | Arecastrum romanzoffianum :: Queen Palm 238 | 1 HENRY ADAMS ST | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 106980 | 106980 | 108282 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1 HENRY ADAMS ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 110031 | 110031 | 108276 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | |||
| 115108 | 115108 | 108280 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 117468 | 117468 | 108291 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 118258 | 118258 | 108278 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 119619 | 119619 | 108292 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 121945 | 121945 | 108290 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 126194 | 126194 | 108285 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 139211 | 139211 | 108277 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 141261 | 141261 | 108283 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 145921 | 145921 | 108288 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 HENRY ADAMS ST | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6011517.4 | 2108140.5 | 37.769201076268395 | -122.40347225564399 | (37.7692010762684, -122.403472255644) | ||||
| 85183 | 85183 | 122398 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1 Marne Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5995245.0 | 2097844.0 | 37.7400071651049 | -122.45901160777099 | (37.7400071651049, -122.459011607771) | ||||
| 98582 | 98582 | 122401 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1 Marne Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5995245.0 | 2097844.0 | 37.7400071651049 | -122.45901160777099 | (37.7400071651049, -122.459011607771) | ||||
| 113235 | 113235 | 122400 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1 Marne Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5995245.0 | 2097844.0 | 37.7400071651049 | -122.45901160777099 | (37.7400071651049, -122.459011607771) | ||||
| 118970 | 118970 | 122399 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1 Marne Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5995245.0 | 2097844.0 | 37.7400071651049 | -122.45901160777099 | (37.7400071651049, -122.459011607771) | ||||
| 92845 | 92845 | 114978 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 118399 | 118399 | 115436 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 144359 | 144359 | 115437 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 122566 | 122566 | 121611 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 10 Fountain St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000298.0 | 2101623.0 | 37.750672573162106 | -122.441811619208 | (37.7506725731621, -122.441811619208) | ||||
| 14347 | 14347 | 87020 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 10 Osceola Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 13246 | 13246 | 187614 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13247 | 13247 | 187613 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13248 | 13248 | 187615 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 13249 | 13249 | 187612 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 100 Castro St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3x3 | 6002192.0 | 2107639.0 | 37.767298794762 | -122.43569238083799 | (37.767298794762, -122.435692380838) | ||||
| 81042 | 81042 | 112562 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 117600 | 117600 | 112563 | Permitted Site 1 | Tree(s) :: 17 | 1000X 17th Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | Permit Number 774340 | 5990959.97324 | 2102133.59106 | 37.7515380150924 | -122.47414022419301 | (37.7515380150924, -122.474140224193) | ||||
| 92501 | 92501 | 97725 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | |||
| 92726 | 92726 | 97722 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 117800 | 117800 | 97724 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 128722 | 128722 | 97723 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 127931 | 127931 | 2101 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 04/09/1990 12:00:00 AM | 14 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 138901 | 138901 | 2095 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 146288 | 146288 | 2099 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Bosworth St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10 | 3X3 | 6001184.3961352995 | 2095706.3375319 | 37.7344772801388 | -122.438322562248 | (37.7344772801388, -122.438322562248) | |||
| 83393 | 83393 | 92053 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1001 Potrero Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | |||||
| 123251 | 123251 | 92054 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1001 Potrero Ave | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | |||||
| 17355 | 17355 | 18407 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 06/02/1992 12:00:00 AM | 12 | 3X3 | 6010549.786619999 | 2103464.28095 | 37.7563071414784 | -122.4064896391 | (37.7563071414784, -122.4064896391) | ||
| 18091 | 18091 | 18397 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3X3 | 6010576.96525 | 2102937.51144 | 37.7548622699958 | -122.406358530544 | (37.7548622699958, -122.406358530544) | |||
| 20353 | 20353 | 18398 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 05/23/1997 12:00:00 AM | 3 | 3X3 | 6010574.371780001 | 2102982.33848 | 37.7549852100133 | -122.40637065790101 | (37.7549852100133, -122.406370657901) | ||
| 20727 | 20727 | 18395 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3x3 | 6010583.3123699995 | 2102829.86253 | 37.7545670450388 | -122.406328995892 | (37.7545670450388, -122.406328995892) | |||
| 20860 | 20860 | 18406 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 3x3 | 6010555.16427 | 2103408.27395 | 37.7561536595775 | -122.406467094883 | (37.7561536595775, -122.406467094883) | |||
| 21450 | 21450 | 18404 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 12 | 3x3 | 6010558.96581 | 2103310.46639 | 37.755885314463605 | -122.40644705620001 | (37.7558853144636, -122.4064470562) | |||
| 22206 | 22206 | 18402 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 18 | 3x3 | 6010563.4475 | 2103210.4803400002 | 37.755611025734 | -122.40642451198299 | (37.755611025734, -122.406424511983) | |||
| 23146 | 23146 | 18396 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 8 | 3X3 | 6010579.89975 | 2102879.8481400004 | 37.7547041035309 | -122.406344319459 | (37.7547041035309, -122.406344319459) | |||
| 23258 | 23258 | 18405 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 15 | 3X3 | 6010556.98057 | 2103355.2247200003 | 37.756008099814295 | -122.406457075558 | (37.7560080998143, -122.406457075558) | |||
| 23324 | 23324 | 18403 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/14/1991 12:00:00 AM | 10 | 3X3 | 6010561.22501 | 2103261.37452 | 37.7557506454989 | -122.406435784089 | (37.7557506454989, -122.406435784089) | ||
| 76011 | 76011 | 18432 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 40 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
| 92972 | 92972 | 18426 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 30 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
| 99627 | 99627 | 18428 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 24 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
| 103504 | 103504 | 18429 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 30 | 3x3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
| 107467 | 107467 | 18427 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 40 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
| 112444 | 112444 | 18430 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 30 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | |||
| 142641 | 142641 | 18431 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1001X Potrero Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Health Dept 8 | 01/20/2016 12:00:00 AM | 24 | 3X3 | 6010537.158904701 | 2103412.4254884 | 37.75616405148111 | -122.406529656376 | (37.7561640514811, -122.406529656376) | ||
| 15948 | 15948 | 101850 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001X Rhode Island St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 2 | 3x3 | Permit Number 774983 | 6011937.4679 | 2103668.00433 | 37.7569440557359 | -122.401704847401 | (37.7569440557359, -122.401704847401) | |
| 54876 | 54876 | 101849 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1001X Rhode Island St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6011941.506630001 | 2103634.1121 | 37.756851220510505 | -122.401688497731 | (37.7568512205105, -122.401688497731) | |||
| 63008 | 63008 | 114541 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001X Rhode Island St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774983 | 6011939.68484 | 2103650.19837 | 37.756895288204 | -122.401695928834 | (37.756895288204, -122.401695928834) | ||
| 13841 | 13841 | 3685 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout 5 | Tree 1 | Port 9 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767871999 | (37.744924332395, -122.38470767872) | |||
| 109068 | 109068 | 112659 | Permitted Site 1 | Tree(s) :: 17 | 101 Quintara St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/14/2015 12:00:00 AM | Permit Number 775001 | 5993151.2 | 2101136.7 | 37.748927499569604 | -122.466490304373 | (37.7489274995696, -122.466490304373) | |||
| 39918 | 39918 | 98828 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6008042.556030001 | 2119299.03058 | 37.7996449996806 | -122.41628202140801 | (37.7996449996806, -122.416282021408) | |||
| 45206 | 45206 | 98827 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 3x3 | 6008062.2749 | 2119302.48836 | 37.7996556026694 | -122.416214031774 | (37.7996556026694, -122.416214031774) | |||
| 187249 | 187249 | 98829 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1020 Union St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 21 | 3x3 | 6008023.617869999 | 2119295.81426 | 37.7996351035429 | -122.41634732658702 | (37.7996351035429, -122.416347326587) | |||
| 79336 | 79336 | 97887 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1030 Cabrillo St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/23/2011 12:00:00 AM | 1 | Permit Number 768379 | 5992385.79681 | 2110712.74988 | 37.775176609355896 | -122.469834146271 | (37.7751766093559, -122.469834146271) | ||
| 20 | 20 | 251179 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 1043 Minna St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007668.0 | 2109797.0 | 37.7735336727503 | -122.41690453761002 | (37.7735336727503, -122.41690453761) | ||||
| 21 | 21 | 251178 | Planning Code 138.1 required 4 | Podocarpus gracilor :: Fern Pine 13 | 1043 Minna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6007668.0 | 2109797.0 | 37.7735336727503 | -122.41690453761002 | (37.7735336727503, -122.41690453761) | ||||
| 118530 | 118530 | 104452 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1045 Mission St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x6 | Permit Number 770594 | 6009749.9 | 2112056.4 | 37.7798543407434 | -122.40986242910299 | (37.7798543407434, -122.409862429103) | |||
| 13252 | 13252 | 115099 | Undocumented 2 | Tree(s) :: 17 | 1061X PACHECO ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/16/2017 12:00:00 AM | 3 | 3x10 | Permit Number 779333 | 5991641.0 | 2102174.0 | 37.7516883950984 | -122.47178811631599 | (37.7516883950984, -122.471788116316) | |
| 145280 | 145280 | 99376 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 1088 Ashbury St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 768767 | 5998994.0 | 2106195.0 | 37.7631517661679 | -122.44664985791401 | (37.7631517661679, -122.446649857914) | ||||
| 82026 | 82026 | 119268 | Permitted Site 1 | Tree(s) :: 17 | 109 Gates St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778717 | 6008342.0 | 2098018.0 | 37.741229112716105 | -122.41373973636001 | (37.7412291127161, -122.41373973636) | |
| 108014 | 108014 | 113985 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 109 MADRONE AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x10 | 5992778.0 | 2098364.0 | 37.74129282931111 | -122.46757920887899 | (37.7412928293111, -122.467579208879) | ||||
| 1718 | 1718 | 251667 | Undocumented 2 | Shrub :: Shrub 98 | 1090x Eucalyptus Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5988120.0 | 2094796.0 | 37.731225993649296 | -122.483423232518 | (37.7312259936493, -122.483423232518) | ||||
| 10019 | 10019 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 260 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | |
| 88044 | 88044 | 10731 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3X4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 103686 | 103686 | 10735 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 141733 | 141733 | 10733 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100 Hudson Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/28/2016 08:19:00 AM | 3 | 3x4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | ||
| 46604 | 46604 | 2135 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 24 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 82755 | 82755 | 2119 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 95857 | 95857 | 2117 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 100446 | 100446 | 2113 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 103627 | 103627 | 2130 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 106968 | 106968 | 2121 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | |||
| 125275 | 125275 | 2132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 0 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 125511 | 125511 | 2128 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 128760 | 128760 | 2115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 140071 | 140071 | 2139 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 28 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 12 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 9886 | 9886 | 173724 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1101 Connecticut St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 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) | ||||
| 80235 | 80235 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 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) | ||||
| 81160 | 81160 | 96570 | 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) | ||||
| 86907 | 86907 | 96483 | 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 = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 97749 | 97749 | 96481 | 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 = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 99207 | 99207 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 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) | ||||
| 101102 | 101102 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 103034 | 103034 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) |
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");