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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 14458 | 14458 | 94035 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 32 | 5x5 | 6015684.8669 | 2095240.1882 | 37.7340114236329 | -122.388156677838 | (37.7340114236329, -122.388156677838) | ||
| 15674 | 15674 | 94034 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | ||
| 15999 | 15999 | 94036 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/08/2012 12:00:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | |
| 16453 | 16453 | 96769 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 1 | 4x4 | 6015646.9436 | 2095179.7309 | 37.7338433188148 | -122.388283573512 | (37.7338433188148, -122.388283573512) | ||
| 13403 | 13403 | 96770 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015623.8599 | 2095148.9526 | 37.7337575287133 | -122.388361234061 | (37.7337575287133, -122.388361234061) | |
| 46599 | 46599 | 97073 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 83429 | 83429 | 97069 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 83478 | 83478 | 97078 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 84864 | 84864 | 97082 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 3x3 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 86592 | 86592 | 97067 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1551 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/06/2014 12:00:00 AM | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | |
| 88449 | 88449 | 97070 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 3x3 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 88782 | 88782 | 97068 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1551 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 89738 | 89738 | 97080 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1551 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 93584 | 93584 | 97074 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1551 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/20/2015 05:52:00 PM | 3 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | |
| 106157 | 106157 | 97076 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 116244 | 116244 | 97072 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 124857 | 124857 | 97071 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 139482 | 139482 | 97079 | DPW Maintained 3 | Tree(s) :: 17 | 1551 Newcomb Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 4x4 | 6015475.3 | 2095481.7 | 37.734662952658894 | -122.38889807707899 | (37.7346629526589, -122.388898077079) | ||
| 77312 | 77312 | 96772 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6015407.2 | 2095381.5 | 37.73438404885479 | -122.38912652987801 | (37.7343840488548, -122.389126529878) | ||
| 85372 | 85372 | 96771 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/08/2011 12:00:00 AM | 8 | 4x3 | 6015407.2 | 2095381.5 | 37.73438404885479 | -122.38912652987801 | (37.7343840488548, -122.389126529878) | |
| 124646 | 124646 | 96774 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015407.2 | 2095381.5 | 37.73438404885479 | -122.38912652987801 | (37.7343840488548, -122.389126529878) | |
| 89310 | 89310 | 66890 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/07/2005 12:00:00 AM | 6 | 3x3 | Permit Number 45482 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 129243 | 129243 | 47256 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/09/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45198 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 145918 | 145918 | 47257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52469 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 81950 | 81950 | 97063 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.38975506041099 | (37.7351486000155, -122.389755060411) | ||
| 92342 | 92342 | 97065 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.38975506041099 | (37.7351486000155, -122.389755060411) | ||
| 96887 | 96887 | 97064 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.38975506041099 | (37.7351486000155, -122.389755060411) | ||
| 103946 | 103946 | 97061 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.38975506041099 | (37.7351486000155, -122.389755060411) | ||
| 106885 | 106885 | 97060 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.38975506041099 | (37.7351486000155, -122.389755060411) | ||
| 139761 | 139761 | 97062 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.38975506041099 | (37.7351486000155, -122.389755060411) | ||
| 106838 | 106838 | 102115 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | Permit Number 52469 | 6015181.7 | 2089440.8 | 37.7180595657824 | -122.389491420596 | (37.7180595657824, -122.389491420596) | |
| 14765 | 14765 | 51356 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/10/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014174.8382 | 2094728.0237900002 | 37.732521344076204 | -122.393341524701 | (37.7325213440762, -122.393341524701) |
| 16516 | 16516 | 51368 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.092119999 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) |
| 15702 | 15702 | 51369 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014169.21344 | 2094698.3618 | 37.7324395857978 | -122.39335889598999 | (37.7324395857978, -122.39335889599) |
| 15170 | 15170 | 51367 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52508 | 6014166.48709 | 2094684.74927 | 37.732402057093296 | -122.39336736943001 | (37.7324020570933, -122.39336736943) |
| 16338 | 16338 | 51366 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014162.991119999 | 2094669.4439299998 | 37.73235983751729 | -122.39337838521601 | (37.7323598375173, -122.393378385216) |
| 16461 | 16461 | 51365 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.39340338185801 | (37.7322472522973, -122.393403381858) |
| 13428 | 13428 | 51364 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014150.64944 | 2094610.63008 | 37.732197660973505 | -122.393416939157 | (37.7321976609735, -122.393416939157) |
| 14428 | 14428 | 51357 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 50 Pomona St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014147.24137 | 2094593.6145900001 | 37.732150750552 | -122.393427531355 | (37.732150750552, -122.393427531355) |
| 16645 | 16645 | 51363 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014143.519230001 | 2094573.1883599998 | 37.7320944574823 | -122.393438970749 | (37.7320944574823, -122.393438970749) |
| 14071 | 14071 | 51362 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Pomona St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014137.60928 | 2094535.47761 | 37.7319905830836 | -122.393456764727 | (37.7319905830836, -122.393456764727) |
| 16818 | 16818 | 51361 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 50 Pomona St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014122.20154 | 2094470.50183 | 37.7318113167403 | -122.39350548730499 | (37.7318113167403, -122.393505487305) |
| 16162 | 16162 | 51360 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014114.6767 | 2094431.72556 | 37.7317044268964 | -122.39352878961999 | (37.7317044268964, -122.39352878962) |
| 13409 | 13409 | 51359 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014112.78564 | 2094416.99761 | 37.73166388187129 | -122.393534297068 | (37.7316638818713, -122.393534297068) |
| 14652 | 14652 | 51358 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014110.4538 | 2094404.7193099998 | 37.7316300385939 | -122.393541499766 | (37.7316300385939, -122.393541499766) |
| 16408 | 16408 | 78332 | DPW Maintained 3 | Crataegus laevigata :: English Hawthorn 66 | 50 Pomona St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52305 | 6014106.86245 | 2094390.7581099998 | 37.73159150443121 | -122.393552939125 | (37.7315915044312, -122.393552939125) |
| 14034 | 14034 | 78331 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014103.033559999 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | |
| 13536 | 13536 | 78330 | DPW Maintained 3 | Celtis australis :: European Hackberry 282 | 50 Pomona St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014096.48223 | 2094344.10726 | 37.7314628339206 | -122.39358556204999 | (37.7314628339206, -122.39358556205) | |
| 15350 | 15350 | 78329 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.731420948908294 | -122.39359445903999 | (37.7314209489083, -122.39359445904) | |
| 16401 | 16401 | 78328 | DPW Maintained 3 | Celtis australis :: European Hackberry 282 | 50 Pomona St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014090.70522 | 2094312.9836799998 | 37.7313770539035 | -122.39360335692601 | (37.7313770539035, -122.393603356926) | |
| 15526 | 15526 | 78327 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.39361394824199 | (37.7313351688787, -122.393613948242) | |
| 15298 | 15298 | 78326 | DPW Maintained 3 | Celtis australis :: European Hackberry 282 | 50 Pomona St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014084.32077 | 2094282.11607 | 37.7312919429706 | -122.39362326971799 | (37.7312919429706, -122.393623269718) | |
| 15529 | 15529 | 78325 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014082.074630001 | 2094268.0058099998 | 37.731253074258596 | -122.393630047885 | (37.7312530742586, -122.393630047885) | |
| 13640 | 13640 | 78324 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014075.45071 | 2094231.93865 | 37.731153673106796 | -122.393650424725 | (37.7311536731068, -122.393650424725) | |
| 15731 | 15731 | 78323 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014072.33534 | 2094216.7042200002 | 37.731111669349204 | -122.393660129315 | (37.7311116693492, -122.393660129315) | |
| 16070 | 16070 | 78322 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014069.278530001 | 2094204.9289400002 | 37.7310791669665 | -122.393669873461 | (37.7310791669665, -122.393669873461) | |
| 15539 | 15539 | 78321 | DPW Maintained 3 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014066.05948 | 2094191.2042200002 | 37.73104130280179 | -122.39368004209999 | (37.7310413028018, -122.3936800421) | |
| 15757 | 15757 | 78202 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014063.31576 | 2094176.7375400001 | 37.731001427778395 | -122.393688515509 | (37.7310014277784, -122.393688515509) | |
| 94061 | 94061 | 94895 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 94704 | 94704 | 94894 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 104168 | 104168 | 94893 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 119228 | 119228 | 94892 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 43 Flora St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.732132475471104 | -122.39381008289601 | (37.7321324754711, -122.393810082896) |
| 128247 | 128247 | 116052 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 650x KANSAS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6011530.0 | 2105347.0 | 37.761531458187 | -122.403232137637 | (37.761531458187, -122.403232137637) | |||
| 129870 | 129870 | 116056 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 650x Kansas St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 23 | 4x4 | 6011515.191980001 | 2105171.68257 | 37.7610492486475 | -122.40327101944901 | (37.7610492486475, -122.403271019449) | ||
| 15372 | 15372 | 116055 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/30/2016 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.40328006754801 | (37.7611252557522, -122.403280067548) | |
| 132178 | 132178 | 116054 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650x Kansas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 23 | 4x4 | 6011511.93551 | 2105220.59815 | 37.761183378041395 | -122.403285723377 | (37.7611833780414, -122.403285723377) | ||
| 35622 | 35622 | 116053 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650x Kansas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 4x4 | 6011508.109619999 | 2105241.51829 | 37.761240606399795 | -122.40330042728901 | (37.7612406063998, -122.403300427289) | ||
| 25232 | 25232 | 116051 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 4x4 | 6011500.28754 | 2105307.1354099996 | 37.761420339490705 | -122.40333209689699 | (37.7614203394907, -122.403332096897) | ||
| 163065 | 163065 | 116050 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 4x4 | 6011499.79329 | 2105331.08163 | 37.76148606285779 | -122.403335490949 | (37.7614860628578, -122.403335490949) | ||
| 168957 | 168957 | 116048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 4x4 | 6011498.51602 | 2105372.79225 | 37.7616005195649 | -122.403342842915 | (37.7616005195649, -122.403342842915) | ||
| 30215 | 30215 | 116049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 650x Kansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 4x4 | 6011498.3385 | 2105356.0244 | 37.761554468880206 | -122.403342277248 | (37.7615544688802, -122.403342277248) | ||
| 58238 | 58238 | 116047 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x12 | 6011496.1211 | 2105415.8281900003 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | ||
| 158318 | 158318 | 116046 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 5x15 | 6011495.20108 | 2105434.8979700003 | 37.761770862847705 | -122.40335867726002 | (37.7617708628477, -122.40335867726) | ||
| 130071 | 130071 | 116057 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011480.97635 | 2105135.37266 | 37.760947638753 | -122.40338680266001 | (37.760947638753, -122.40338680266) | ||
| 158398 | 158398 | 116058 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011458.59484 | 2105134.56728 | 37.760944177262004 | -122.403464154268 | (37.760944177262, -122.403464154268) | ||
| 77797 | 77797 | 116382 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2501 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | DPW for City Agency 2 | 3x3 | 6011435.88896489 | 2101815.42613948 | 37.7518292809831 | -122.403309184671 | (37.7518292809831, -122.403309184671) | |||
| 89314 | 89314 | 67338 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2501 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | DPW for City Agency 2 | 07/22/1992 12:00:00 AM | 3x3 | Permit Number 30822 | 6011435.88896489 | 2101815.42613948 | 37.7518292809831 | -122.403309184671 | (37.7518292809831, -122.403309184671) | |
| 166938 | 166938 | 116059 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2100x 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6011431.5308 | 2105131.75607 | 37.760934946603605 | -122.40355755965099 | (37.7609349466036, -122.403557559651) | ||
| 46988 | 46988 | 116060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | ||
| 64195 | 64195 | 116061 | Undocumented 2 | Melaleuca spp :: Melaleuca spp 130 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | ||
| 24331 | 24331 | 116062 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100x 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 22 | 3x3 | 6011361.02056 | 2105129.82914 | 37.7609257168785 | -122.40380128939199 | (37.7609257168785, -122.403801289392) | ||
| 65849 | 65849 | 116063 | Undocumented 2 | Brachychiton discolor :: 440 | 2100x 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 19 | 3x3 | 6011332.66531 | 2105125.78364 | 37.760913024731295 | -122.403899073603 | (37.7609130247313, -122.403899073603) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 170121 | 170121 | 116065 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 693 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 8x7 | 6011274.01561 | 2105377.63125 | 37.761601265113896 | -122.404119643106 | (37.7616012651139, -122.404119643106) |
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");