Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2216 | 2216 | 122752 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | |||
| 2219 | 2219 | 122754 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 6011277.363419999 | 2105334.1858 | 37.761482160689894 | -122.404105006665 | (37.7614821606899, -122.404105006665) | |||
| 2223 | 2223 | 43305 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43072 | 6011285.67007 | 2105193.27319 | 37.7610957103087 | -122.4040663601 | (37.7610957103087, -122.4040663601) | |
| 2229 | 2229 | 43306 | DPW Maintained 3 | Prunus caroliniana :: Carolina Cherry Laurel 133 | 693 Vermont St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/12/2000 12:00:00 AM | 22 | Permit Number 43072 | 6011289.47877 | 2105149.93268 | 37.7609769197604 | -122.404050137204 | (37.7609769197604, -122.404050137204) | |
| 2231 | 2231 | 122750 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 6011285.1392 | 2105241.4016400003 | 37.761227830607204 | -122.40407158333299 | (37.7612278306072, -122.404071583333) | |||
| 2232 | 2232 | 122753 | DPW Maintained 3 | Podocarpus gracilor :: Fern Pine 13 | 693 Vermont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 15 | 6011277.810190001 | 2105311.62173 | 37.7614202297665 | -122.404101873421 | (37.7614202297665, -122.404101873421) | |||
| 2233 | 2233 | 122749 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 693 Vermont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 6011285.506709999 | 2105214.92948 | 37.761155164510605 | -122.404068449214 | (37.7611551645106, -122.404068449214) | |||
| 2240 | 2240 | 122755 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.40411744427601 | (37.7615439863765, -122.404117444276) | |||
| 17867 | 17867 | 98680 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 33468 | 33468 | 95148 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 5988724.779619999 | 2113566.5271900003 | 37.78279998730721 | -122.482707449869 | (37.7827999873072, -122.482707449869) | |||
| 41129 | 41129 | 95156 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 21 | 5988717.78601 | 2113765.0163 | 37.7833445754979 | -122.48274619510799 | (37.7833445754979, -122.482746195108) | |||
| 41571 | 41571 | 95149 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 15 | 5988721.12033 | 2113580.3815900004 | 37.7828378146839 | -122.48272112492901 | (37.7828378146839, -122.482721124929) | |||
| 60314 | 60314 | 95147 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 13 | 5988726.59645 | 2113538.2792 | 37.7827225319963 | -122.48269909375901 | (37.7827225319963, -122.482699093759) | |||
| 63647 | 63647 | 95150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 5988721.361169999 | 2113591.74757 | 37.7828690364709 | -122.482721124926 | (37.7828690364709, -122.482721124926) | |||
| 70878 | 70878 | 95154 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 5988718.8555 | 2113711.8550400003 | 37.783198671909794 | -122.48273859805 | (37.7831986719098, -122.48273859805) | |||
| 78641 | 78641 | 116976 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 79463 | 79463 | 116977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100x CARGO WAY | 117 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 80122 | 80122 | 98749 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 81972 | 81972 | 98746 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 82915 | 82915 | 95268 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2245 Jones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 84977 | 84977 | 98681 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 86909 | 86909 | 120542 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2450 California St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | DPW for City Agency 2 | 6002644.1089699995 | 2115479.97736 | 37.7888538273233 | -122.43468935172599 | (37.7888538273233, -122.434689351726) | ||||
| 88992 | 88992 | 98678 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 90630 | 90630 | 98561 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 90673 | 90673 | 98752 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 91242 | 91242 | 98559 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 92105 | 92105 | 98750 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 92729 | 92729 | 98679 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 93270 | 93270 | 98756 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 94912 | 94912 | 98754 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 95375 | 95375 | 98676 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 97683 | 97683 | 98677 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 99342 | 99342 | 95260 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 104719 | 104719 | 95263 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 105405 | 105405 | 98743 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 155 Masonic Ave | 5 | Sidewalk: Property side : 26 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5998843.8 | 2112455.0 | 37.7803315496091 | -122.447619999218 | (37.7803315496091, -122.447619999218) | ||||
| 106816 | 106816 | 95261 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 108801 | 108801 | 98744 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 540X Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 110614 | 110614 | 98755 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 110736 | 110736 | 98753 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 112310 | 112310 | 95267 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 2245 Jones St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 116005 | 116005 | 95264 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 117184 | 117184 | 98682 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 119088 | 119088 | 95258 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 120054 | 120054 | 95152 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5988720.65561 | 2113620.6282200003 | 37.7829482935383 | -122.482725682965 | (37.7829482935383, -122.482725682965) | |||
| 120920 | 120920 | 95266 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 121500 | 121500 | 42841 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2245 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/03/2000 12:00:00 AM | Permit Number 42773 | 6008051.69679947 | 2120116.37092576 | 37.8018897255523 | -122.416308313185 | (37.8018897255523, -122.416308313185) | ||
| 121513 | 121513 | 107883 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 941 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946771999 | (37.7944046419585, -122.40879946772) | ||||
| 126599 | 126599 | 98562 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 138350 | 138350 | 98747 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 138703 | 138703 | 95262 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 139365 | 139365 | 98751 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 140503 | 140503 | 116975 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 141315 | 141315 | 98560 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2035X Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | ||||
| 141772 | 141772 | 98748 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 142592 | 142592 | 96085 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 143508 | 143508 | 95265 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2245 Jones St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||||
| 145208 | 145208 | 95259 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2290X 14th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5992014.7 | 2099861.3 | 37.745359932747 | -122.47032742053699 | (37.745359932747, -122.470327420537) | ||||
| 145453 | 145453 | 95270 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 2245 Jones St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/23/2016 02:41:00 PM | 3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | ||
| 146991 | 146991 | 95155 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 5988718.098730001 | 2113738.3311400004 | 37.7832713237769 | -122.482743157022 | (37.7832713237769, -122.482743157022) | |||
| 151441 | 151441 | 70932 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 14 | 5988727.46903 | 2113517.2675099997 | 37.7826648905872 | -122.48269453478301 | (37.7826648905872, -122.482694534783) | ||
| 156514 | 156514 | 122751 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 6011280.99043 | 2105260.13165 | 37.7612790272197 | -122.40408725043301 | (37.7612790272197, -122.404087250433) | |||
| 159681 | 159681 | 73495 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 10 | 5988730.14838 | 2113498.62278 | 37.7826138532986 | -122.482683898749 | (37.7826138532986, -122.482683898749) | ||
| 163336 | 163336 | 95153 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 5988721.4522400005 | 2113658.22406 | 37.783051567455004 | -122.482725682991 | (37.783051567455, -122.482725682991) | |||
| 174085 | 174085 | 43304 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/12/2000 12:00:00 AM | 19 | Permit Number 43072 | 6011287.96925 | 2105166.37556 | 37.7610219838923 | -122.404056515205 | (37.7610219838923, -122.404056515205) | |
| 183769 | 183769 | 95151 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 13 | 5988720.99449 | 2113605.53219 | 37.7829068638151 | -122.482723403965 | (37.7829068638151, -122.482723403965) | |||
| 23202 | 23202 | 77640 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 13 | 0 | 6006980.92428 | 2093193.1114700001 | 37.7279045016753 | -122.418103887786 | (37.7279045016753, -122.418103887786) | |
| 23284 | 23284 | 76311 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 299X Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 4 | 0 | 6006754.260559999 | 2093151.90933 | 37.7277786091743 | -122.418884550584 | (37.7277786091743, -122.418884550584) | |
| 186618 | 186618 | 115552 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 925x Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 15x7 | 6015276.56251 | 2104229.2059299997 | 37.7586707630633 | -122.390196112573 | (37.7586707630633, -122.390196112573) | ||
| 24594 | 24594 | 115551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 18x7 | 6015277.41921 | 2104189.44931 | 37.7585616474178 | -122.39019037219299 | (37.7585616474178, -122.390190372193) | ||
| 155253 | 155253 | 115550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.39018178636199 | (37.7584697654838, -122.390181786362) | ||
| 180919 | 180919 | 115549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 20x7 | 6015281.58054 | 2104112.34112 | 37.7583501556473 | -122.390170593412 | (37.7583501556473, -122.390170593412) | ||
| 72161 | 72161 | 99692 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1550X Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 2x2 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.41878469564101 | (37.7936275055362, -122.418784695641) | ||
| 122316 | 122316 | 99339 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3.5x3.5 | 5986576.130469999 | 2112991.43823 | 37.7810957151351 | -122.49009845653799 | (37.7810957151351, -122.490098456538) | ||
| 124662 | 124662 | 99335 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 30th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 30 | 3.5x3.5 | 5986578.25407 | 2112899.8451 | 37.780844350584005 | -122.490084370963 | (37.780844350584, -122.490084370963) | ||
| 91017 | 91017 | 99338 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3X3 | 5986576.26956 | 2112967.74794 | 37.7810306764919 | -122.490096232309 | (37.7810306764919, -122.490096232309) | ||
| 23164 | 23164 | 76784 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1501X 42nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 1 | 3x12 | 5983097.2131 | 2104562.028 | 37.7577472058325 | -122.50150981087799 | (37.7577472058325, -122.501509810878) | |
| 23240 | 23240 | 76785 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 24 | 3x12 | 5983097.8243 | 2104541.5546 | 37.757691027540005 | -122.501506182606 | (37.75769102754, -122.501506182606) | |
| 23245 | 23245 | 76756 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1501X 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 2 | 3x12 | 5983095.0741 | 2104639.3384 | 37.757959352781 | -122.501522927406 | (37.757959352781, -122.501522927406) | |
| 23276 | 23276 | 76755 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | |
| 23340 | 23340 | 76382 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 25 | 3x12 | 5983091.4072 | 2104771.8049 | 37.7583228530818 | -122.501545408351 | (37.7583228530818, -122.501545408351) | |
| 23355 | 23355 | 76748 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | |
| 86769 | 86769 | 46964 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 88512 | 88512 | 46967 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 5 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 91304 | 91304 | 76222 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 5 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 95663 | 95663 | 76252 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 8 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 98630 | 98630 | 46965 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 120521 | 120521 | 46966 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 142732 | 142732 | 76271 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 8 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 144911 | 144911 | 76325 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 5 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 44052 | 44052 | 46958 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 85268 | 85268 | 46950 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 88649 | 88649 | 46953 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 6 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 89109 | 89109 | 46955 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 4 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 90893 | 90893 | 46948 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 3 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 93081 | 93081 | 46957 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 93345 | 93345 | 46960 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 97074 | 97074 | 46962 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 6 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 100272 | 100272 | 46952 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 118208 | 118208 | 46949 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 5 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 119652 | 119652 | 46951 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
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");