Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: PlantType
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106408 | 106408 | 90755 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 4125 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982844.302046 | 2110317.735204 | 37.773535873704205 | -122.50281052448 | (37.7735358737042, -122.50281052448) | |
| 106994 | 106994 | 90294 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4899X Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.775022659049704 | -122.51125715579398 | (37.7750226590497, -122.511257155794) | |
| 107566 | 107566 | 90958 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4605 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981330.506527999 | 2110944.422301 | 37.775167490626 | -122.508093395898 | (37.775167490626, -122.508093395898) | |
| 109052 | 109052 | 90297 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4545X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981520.769284 | 2110951.300184 | 37.7751975846267 | -122.50743575643 | (37.7751975846267, -122.50743575643) | |
| 109118 | 109118 | 90951 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4899X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.775022659049704 | -122.51125715579398 | (37.7750226590497, -122.511257155794) | |
| 109181 | 109181 | 90915 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3228 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988669.966739 | 2111929.945878 | 37.7783032057889 | -122.482777102874 | (37.7783032057889, -122.482777102874) | |
| 109216 | 109216 | 90573 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989607.117119 | 2110603.2040279997 | 37.7747148208537 | -122.47943809850099 | (37.7747148208537, -122.479438098501) | |
| 109619 | 109619 | 89531 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5050 ANZA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982937.0 | 2111755.0 | 37.7774876321748 | -122.502596276346 | (37.7774876321748, -122.502596276346) | |
| 110381 | 110381 | 89471 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3828 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5986811.689623999 | 2111863.354052 | 37.7780120700323 | -122.48920058722601 | (37.7780120700323, -122.489200587226) | |
| 110680 | 110680 | 89569 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 4939 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983374.388584 | 2111699.374735 | 37.7773605941443 | -122.501079113369 | (37.7773605941443, -122.501079113369) | |
| 111065 | 111065 | 90246 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 3020 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986239.468923001 | 2111161.958067 | 37.7760528187899 | -122.491128444049 | (37.7760528187899, -122.491128444049) | |
| 111630 | 111630 | 90646 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3300X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985392.933158999 | 2110450.258895 | 37.774049198972605 | -122.49400432939699 | (37.7740491989726, -122.494004329397) | |
| 112407 | 112407 | 90502 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 401X 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988073.547859 | 2113275.972392 | 37.7819642960053 | -122.484939086563 | (37.7819642960053, -122.484939086563) | |
| 112945 | 112945 | 90779 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3801X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983846.387262001 | 2110354.103876 | 37.7736945730016 | -122.49934690614201 | (37.7736945730016, -122.499346906142) | |
| 113701 | 113701 | 90256 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3230 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5985586.651007 | 2111138.404753 | 37.7759499842691 | -122.493384946077 | (37.7759499842691, -122.493384946077) | |
| 113740 | 113740 | 89640 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 3349X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5988302.001433 | 2111876.734088 | 37.7781356853217 | -122.484046112267 | (37.7781356853217, -122.484046112267) | |
| 113762 | 113762 | 90657 | DPW Maintained 3 | Tree(s) :: 17 | 3450 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776853 | 5984933.7362440005 | 2110433.593284 | 37.7739765609982 | -122.495591517296 | (37.7739765609982, -122.495591517296) |
| 113765 | 113765 | 90260 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3816 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5983773.153295 | 2111072.849875 | 37.7756637452827 | -122.499653361397 | (37.7756637452827, -122.499653361397) | |
| 113995 | 113995 | 90935 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4044 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5983069.087957 | 2111047.373036 | 37.775552455582 | -122.50208697176501 | (37.775552455582, -122.502086971765) | |
| 114588 | 114588 | 90645 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3300X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985392.933158999 | 2110450.258895 | 37.774049198972605 | -122.49400432939699 | (37.7740491989726, -122.494004329397) | |
| 114650 | 114650 | 90270 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4036 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5983092.910649 | 2111048.243721 | 37.7755562457499 | -122.502004629102 | (37.7755562457499, -122.502004629102) | |
| 115210 | 115210 | 90934 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4044 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5983069.087957 | 2111047.373036 | 37.775552455582 | -122.50208697176501 | (37.775552455582, -122.502086971765) | |
| 115329 | 115329 | 90636 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3112 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985977.353735 | 2110471.4693 | 37.7741416146835 | -122.49198430858401 | (37.7741416146835, -122.491984308584) | |
| 116619 | 116619 | 89568 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 4939 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983374.388584 | 2111699.374735 | 37.7773605941443 | -122.501079113369 | (37.7773605941443, -122.501079113369) | |
| 118636 | 118636 | 90471 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 534 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5988147.641992 | 2112343.937312 | 37.779409506079396 | -122.484614370085 | (37.7794095060794, -122.484614370085) | |
| 119261 | 119261 | 90929 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4425 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5984963.926317 | 2111755.997226 | 37.7776092710215 | -122.49558464338101 | (37.7776092710215, -122.495584643381) | |
| 119884 | 119884 | 90298 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4527 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981574.06475 | 2110953.226782 | 37.77520601375029 | -122.507251541607 | (37.7752060137503, -122.507251541607) | |
| 120567 | 120567 | 90212 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2349X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5988326.615747 | 2111197.527168 | 37.77627220634061 | -122.48391114694901 | (37.7762722063406, -122.483911146949) | |
| 120709 | 120709 | 90295 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4899X Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.775022659049704 | -122.51125715579398 | (37.7750226590497, -122.511257155794) | |
| 120737 | 120737 | 90704 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 4226 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982526.4863330005 | 2110346.2271189997 | 37.773595421125 | -122.503911988256 | (37.773595421125, -122.503911988256) | |
| 122758 | 122758 | 90659 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3500X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984771.763559 | 2110427.714833 | 37.773950934325796 | -122.49615136588801 | (37.7739509343258, -122.496151365888) | |
| 123318 | 123318 | 90671 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3730 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984065.2455360005 | 2110402.073206 | 37.773839120575104 | -122.49859339731701 | (37.7738391205751, -122.498593397317) | |
| 123325 | 123325 | 90647 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3320 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985333.500383999 | 2110448.101901 | 37.7740397988057 | -122.494209755562 | (37.7740397988057, -122.494209755562) | |
| 124975 | 124975 | 90867 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 2133 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989018.500813 | 2110541.8150979998 | 37.774512057064904 | -122.481469721054 | (37.7745120570649, -122.481469721054) | |
| 125345 | 125345 | 90733 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4525 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981604.755434 | 2110272.748468 | 37.773339427416296 | -122.50709488652001 | (37.7733394274163, -122.50709488652) | |
| 127154 | 127154 | 90676 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3816 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983797.540277 | 2110392.357405 | 37.773796740286 | -122.49951870039301 | (37.773796740286, -122.499518700393) | |
| 127228 | 127228 | 90762 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 4025 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983154.65976 | 2110328.999009 | 37.7735850356272 | -122.501737802253 | (37.7735850356272, -122.501737802253) | |
| 127391 | 127391 | 90662 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3518 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984718.446788 | 2110425.779815 | 37.7739424981767 | -122.49633565193199 | (37.7739424981767, -122.496335651932) | |
| 127581 | 127581 | 90265 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3850X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5983673.104561 | 2111069.198097 | 37.775647847474 | -122.49999917917499 | (37.775647847474, -122.499999179175) | |
| 128081 | 128081 | 89567 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 4949X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983344.613126 | 2111698.2533150003 | 37.7773557666221 | -122.50118203175501 | (37.7773557666221, -122.501182031755) | |
| 128985 | 128985 | 90767 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3927 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5983459.813129 | 2110340.073929 | 37.77363336363379 | -122.50068306696998 | (37.7736333636338, -122.50068306697) | |
| 129285 | 129285 | 90673 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3750x CABRILLO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984009.0 | 2110380.0 | 37.7737752151611 | -122.498786325695 | (37.7737752151611, -122.498786325695) | |
| 139900 | 139900 | 91017 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 457 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 5988087.568302 | 2112897.540762 | 37.7809260463619 | -122.48486281200898 | (37.7809260463619, -122.484862812009) | |
| 140471 | 140471 | 89620 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3745 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987075.727746 | 2111832.790252 | 37.7779435589789 | -122.48828495071001 | (37.7779435589789, -122.48828495071) | |
| 141033 | 141033 | 90799 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 3525 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984702.125295 | 2110385.161127 | 37.77383001476171 | -122.496389112099 | (37.7738300147617, -122.496389112099) | |
| 141260 | 141260 | 90748 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4331 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982206.432655 | 2110294.58511 | 37.773434802186706 | -122.505015255541 | (37.7734348021867, -122.505015255541) | |
| 141454 | 141454 | 90654 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3400 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985083.076571 | 2110439.01327 | 37.7740001866718 | -122.495075331328 | (37.7740001866718, -122.495075331328) | |
| 141899 | 141899 | 90288 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4790X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980763.025413 | 2110963.934321 | 37.7751876098256 | -122.51005785431002 | (37.7751876098256, -122.51005785431) | |
| 142077 | 142077 | 91685 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 383 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007417.550958999 | 2107460.112945 | 37.767103042082795 | -122.417605218645 | (37.7671030420828, -122.417605218645) | ||
| 142392 | 142392 | 90497 | DPW Maintained 3 | Pyrus calleryana 'Capital' :: Ornamental Pear Tree 'Capital' 460 | 319 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5988052.709 | 2113836.722691 | 37.7835027435823 | -122.485052332629 | (37.7835027435823, -122.485052332629) | |
| 143644 | 143644 | 90881 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 1855 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989882.489844 | 2110573.171827 | 37.7746483516209 | -122.478483342296 | (37.7746483516209, -122.478483342296) | |
| 143691 | 143691 | 91888 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1104 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992367.653968 | 2106623.490856 | 37.763947549515 | -122.469599153768 | (37.763947549515, -122.469599153768) | |
| 143779 | 143779 | 90972 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3227 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5985599.860262999 | 2111098.856457 | 37.7758421685745 | -122.49333633811001 | (37.7758421685745, -122.49333633811) | |
| 143872 | 143872 | 90262 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3826 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5983743.727194999 | 2111071.775823 | 37.7756590695628 | -122.49975507253001 | (37.7756590695628, -122.49975507253) | |
| 143887 | 143887 | 90271 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 4100X Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982889.660166 | 2111040.818849 | 37.7755239169344 | -122.502707160377 | (37.7755239169344, -122.502707160377) | |
| 144389 | 144389 | 90741 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4499X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981694.399658999 | 2110276.0019259998 | 37.7733536396946 | -122.50678504147801 | (37.7733536396946, -122.506785041478) | |
| 1905 | 1905 | 251810 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 3 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1912 | 1912 | 251809 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 2 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1919 | 1919 | 251807 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 2 Hangah St | 1 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1921 | 1921 | 251811 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2 Hangah St | 4 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 1923 | 1923 | 251813 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 2 Hangah St | 6 | Unaccepted Street : Cutout 20 | Tree 1 | DPW for City Agency 10 | Rec/Park 7 | 3x3 | 6010544.0 | 2117119.0 | 37.7937995065594 | -122.40747229387699 | (37.7937995065594, -122.407472293877) | |||
| 4715 | 4715 | 103364 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 3 | 3x3 | 6009173.30525 | 2116699.27717 | 37.79257023366971 | -122.412185363057 | (37.7925702336697, -122.412185363057) | ||
| 5817 | 5817 | 103362 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009111.87446 | 2116690.2667799997 | 37.7925420462198 | -122.41239727931601 | (37.7925420462198, -122.412397279316) | ||
| 6038 | 6038 | 103363 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009142.2805 | 2116694.47646 | 37.79255531122121 | -122.412292370693 | (37.7925553112212, -122.412292370693) | ||
| 6622 | 6622 | 103365 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009208.54849 | 2116702.7837799997 | 37.7925818394263 | -122.412063667702 | (37.7925818394263, -122.412063667702) | ||
| 43364 | 43364 | 115743 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 28 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 77413 | 77413 | 94294 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 79827 | 79827 | 103361 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 83849 | 83849 | 103357 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 85133 | 85133 | 104447 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2490X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | |||
| 87248 | 87248 | 104450 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2490X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | |||
| 88266 | 88266 | 94296 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 88405 | 88405 | 103359 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 89814 | 89814 | 103355 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 91178 | 91178 | 103360 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 96843 | 96843 | 94302 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 97748 | 97748 | 115748 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 24 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 98818 | 98818 | 115746 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 28 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 100121 | 100121 | 115744 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 24 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 100271 | 100271 | 115747 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 16 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 100865 | 100865 | 94300 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6x6 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||
| 103230 | 103230 | 115745 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 20 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 106877 | 106877 | 94298 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 116541 | 116541 | 94304 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 120938 | 120938 | 103358 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 139014 | 139014 | 103352 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 140230 | 140230 | 103354 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 140679 | 140679 | 103356 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 145238 | 145238 | 103353 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000X Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 10 | 3x3 | 6009105.1 | 2116370.5 | 37.7916636644225 | -122.412398106821 | (37.7916636644225, -122.412398106821) | ||
| 172264 | 172264 | 116139 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 11 | 6009237.30915 | 2116708.0838099997 | 37.7925980056535 | -122.411964529145 | (37.7925980056535, -122.411964529145) | |||
| 1043 | 1043 | 81845 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 04/28/2017 08:33:00 AM | 3 | 3x3 | Permit Number 50020 | 6007103.87391 | 2115697.8037 | 37.789704100621705 | -122.419274608151 | (37.7897041006217, -122.419274608151) |
| 1171 | 1171 | 172952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3000X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 0 | Width 3ft | 6005556.34576 | 2120733.12845 | 37.8034425497953 | -122.42498731221201 | (37.8034425497953, -122.424987312212) | ||
| 2825 | 2825 | 81846 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007049.49584 | 2115692.06976 | 37.7896852939829 | -122.419462344328 | (37.7896852939829, -122.419462344328) |
| 2924 | 2924 | 140269 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2040 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 08/11/2017 12:00:00 AM | 3 | Width 0ft | 5998144.7463 | 2109987.1343 | 37.7735154534297 | -122.449860434482 | (37.7735154534297, -122.449860434482) | |
| 3824 | 3824 | 229287 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 420 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 2 | 6x6 | 6004863.64618 | 2105856.17124 | 37.7625549619753 | -122.42632458341299 | (37.7625549619753, -122.426324583413) | ||
| 8242 | 8242 | 81844 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 09/11/2012 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007169.781140001 | 2115706.72596 | 37.789732310539705 | -122.419047208268 | (37.7897323105397, -122.419047208268) |
| 12506 | 12506 | 98216 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 30 | 3x12 | 5983098.741 | 2104521.6922 | 37.7576365448231 | -122.50150154301201 | (37.7576365448231, -122.501501543012) | ||
| 12923 | 12923 | 111444 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 14 | 6x12 | 5999970.3074 | 2091024.03837 | 37.721551640364396 | -122.442184051271 | (37.7215516403644, -122.442184051271) | ||
| 13261 | 13261 | 144 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 18 | 3x3 | 6002159.27678 | 2107619.02908 | 37.7672421007673 | -122.435804136578 | (37.7672421007673, -122.435804136578) | ||
| 23389 | 23389 | 43452 | Permitted Site 1 | Quercus agrifolia :: Coast Live Oak 180 | 241 Oneida Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 07/18/2000 12:00:00 AM | 10 | Permit Number 43162 | 5999577.25447 | 2091228.40825 | 37.7220903846374 | -122.44355739787599 | (37.7220903846374, -122.443557397876) |
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");