Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
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) | |||
2641 | 2641 | 37818 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 450X Moscow St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003946.32629 | 2090524.4735599998 | 37.720405743114 | -122.428404441023 | (37.720405743114, -122.428404441023) |
4107 | 4107 | 98607 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6002988.210519999 | 2116859.68166 | 37.792661671341705 | -122.43359745208599 | (37.7926616713417, -122.433597452086) | ||
5823 | 5823 | 98617 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005326.63971 | 2118722.15466 | 37.7979079528477 | -122.425639007743 | (37.7979079528477, -122.425639007743) | ||
7085 | 7085 | 42636 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) |
8457 | 8457 | 98627 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 6x6 | 6002279.94472 | 2120071.20683 | 37.801439470916 | -122.43627801543998 | (37.801439470916, -122.43627801544) | ||
8576 | 8576 | 97728 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005878.13407 | 2120716.4935 | 37.8034150458325 | -122.423872565669 | (37.8034150458325, -122.423872565669) | |
9776 | 9776 | 99552 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Henry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/28/2016 06:02:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | |
10598 | 10598 | 95755 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003450.901459999 | 2092257.0440599998 | 37.725134950402705 | -122.43024050589399 | (37.7251349504027, -122.430240505894) |
10784 | 10784 | 77645 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006883.8507199995 | 2093162.97754 | 37.727816296176705 | -122.41843733843201 | (37.7278162961767, -122.418437338432) | |
10996 | 10996 | 77652 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006723.02825 | 2093252.77715 | 37.7280538116191 | -122.41899967279 | (37.7280538116191, -122.41899967279) | |
12293 | 12293 | 75309 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | |
12381 | 12381 | 75048 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6003019.452409999 | 2092585.35122 | 37.7260119611657 | -122.431755409402 | (37.7260119611657, -122.431755409402) | |
12687 | 12687 | 97250 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003264.30376 | 2092207.6887700001 | 37.724988860924 | -122.430882033691 | (37.724988860924, -122.430882033691) |
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) | |
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) |
17300 | 17300 | 30745 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 486X Page St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34630 | 6004274.8073 | 2109806.6859 | 37.773368818647 | -122.42864278458 | (37.773368818647, -122.42864278458) |
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) | ||||
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) | |
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) | ||
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) | |||
67897 | 67897 | 110959 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5x5 | 6008435.0253800005 | 2119688.1206900002 | 37.800735405160296 | -122.414951484348 | (37.8007354051603, -122.414951484348) | ||
77873 | 77873 | 99668 | DPW Maintained 3 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
79583 | 79583 | 73289 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1999 12:00:00 AM | 10 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
79881 | 79881 | 97900 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 375X Precita Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 3x4 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | ||
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) | ||||
80447 | 80447 | 99695 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1550X Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.41878469564101 | (37.7936275055362, -122.418784695641) | ||
80823 | 80823 | 98972 | DPW Maintained 3 | Shrub :: Shrub 98 | 825 Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 0 | 5x5 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
83864 | 83864 | 102190 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
84763 | 84763 | 99032 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
87136 | 87136 | 76065 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2999X Polk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/16/1996 12:00:00 AM | 6 | 4x4 | 6005804.42794414 | 2120704.37010887 | 37.8033775968655 | -122.42412676624 | (37.8033775968655, -122.42412676624) | |
88275 | 88275 | 47199 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/2002 12:00:00 AM | 8 | 4x4 | Permit Number 45157 | 5986584.12235 | 2112732.41489 | 37.7803849777225 | -122.49005175134701 | (37.7803849777225, -122.490051751347) |
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) |
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) | |
92098 | 92098 | 42366 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
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) | ||
92468 | 92468 | 73518 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2015 07:36:00 AM | 3 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | |
94595 | 94595 | 98794 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 950@Washington Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.794749768385294 | -122.40882353278799 | (37.7947497683853, -122.408823532788) | ||
98194 | 98194 | 70472 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
100398 | 100398 | 95454 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986556.01855 | 2112243.67907 | 37.7790414073553 | -122.49011301465099 | (37.7790414073553, -122.490113014651) | ||
104670 | 104670 | 74737 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 151X Palm Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/31/1997 12:00:00 AM | 6 | 3x3 | 5995889.08215 | 2113282.06845 | 37.7824331529909 | -122.45790154321101 | (37.7824331529909, -122.457901543211) | |
109074 | 109074 | 42988 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/16/2000 12:00:00 AM | 10 | 4x5 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
109410 | 109410 | 76771 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 200X Farallones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.45912868181601 | (37.7143256328225, -122.459128681816) | |
109492 | 109492 | 76051 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 380 Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) | |
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) | ||||
114467 | 114467 | 99352 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451X 29th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5986835.92891 | 2113074.05562 | 37.781337726878206 | -122.489205771916 | (37.7813377268782, -122.489205771916) | ||
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) | ||
119062 | 119062 | 98568 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 301X Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/23/2016 02:55:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.805042475469605 | -122.410124709263 | (37.8050424754696, -122.410124709263) | |
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) | ||||
121322 | 121322 | 42347 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
123342 | 123342 | 98942 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400X San Bruno Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.40430583648501 | (37.7517881116631, -122.404305836485) | ||
126442 | 126442 | 95363 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 775X Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 20 | 3x3 | 6009884.0 | 2118395.5 | 37.7972675002992 | -122.40984611339898 | (37.7972675002992, -122.409846113399) | ||
126608 | 126608 | 76687 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 163X London St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 8 | 3x3 | 6002837.0 | 2092721.0 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | |
126948 | 126948 | 99684 | DPW Maintained 3 | Tree(s) :: 17 | 165 Grattan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/04/2013 12:00:00 AM | 8 | 3x3 | Permit Number 770537 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) |
129440 | 129440 | 99676 | DPW Maintained 3 | Tree(s) :: 17 | 1250X Shrader St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
140274 | 140274 | 99024 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006571.0 | 2102346.4 | 37.753014305467794 | -122.420170352411 | (37.7530143054678, -122.420170352411) | ||
140326 | 140326 | 102026 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | ||
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) | ||||
144482 | 144482 | 98742 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
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) | ||
183247 | 183247 | 98791 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 950 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 1 | 3x6 | Permit Number 768771 | 6010164.1906 | 2117196.54488 | 37.7939911598214 | -122.408791948484 | (37.7939911598214, -122.408791948484) |
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");