Street_Tree_List

Data source: data.sfgov.org

321 rows where qSpecies = 109 sorted by SiteOrder

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
10086 88538 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1306 York St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1   06/26/2009 12:00:00 AM   3x12 Permit Number 52223 6010027.5 2101589.4 37.7511299031436 -122.40816367021999 (37.7511299031436, -122.40816367022)
787 221428 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:47:00 AM 1 Width 3ft   6005427.7802 2108362.05998 37.769467407522896 -122.424551705821 (37.7694674075229, -122.424551705821)
2168 118346 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:47:00 AM 3              
4373 221456 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:59:00 AM 2 Width 3ft   6005491.36744 2107155.48275 37.7661580255906 -122.424245934501 (37.7661580255906, -122.424245934501)
4379 221468 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:37:00 AM 2 Width 3ft   6005525.86145 2106563.70328 37.764535087455 -122.42408453767099 (37.764535087455, -122.424084537671)
4411 221455 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:55:00 PM 1 Width 3ft   6005458.8795300005 2107745.71785 37.7677768358576 -122.424400289657 (37.7677768358576, -122.424400289657)
4507 221494 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 10:53:00 PM 2 Width 3ft   6005589.49697 2105398.2938599996 37.7613387412987 -122.423781567769 (37.7613387412987, -122.423781567769)
5138 152412 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005623.17605 2104812.38517 37.7597318749526 -122.4236234274 (37.7597318749526, -122.4236234274)
30241 201711 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 724 Jamestown Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6015357.64919 2088292.5533900002 37.714916457608204 -122.388803118478 (37.7149164576082, -122.388803118478)
31521 175079 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1104x Alemany Blvd 1 Median : Yard 3 Tree 1 DPW 2     1 Width 10ft   6003837.73065 2094453.4628599999 37.7311877286109 -122.42905980937599 (37.7311877286109, -122.429059809376)
33280 201714 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 726 Jamestown Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6015317.96334 2088364.51894 37.715111861390795 -122.388945312084 (37.7151118613908, -122.388945312084)
34243 221540 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005754.92272 2102467.8076299997 37.753301646771 -122.42300113699301 (37.753301646771, -122.423001136993)
34286 221545 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   6005721.87722 2103062.7074700003 37.754933239094704 -122.423157698184 (37.7549332390947, -122.423157698184)
35135 56924 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 140 Tingley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/1974 12:00:00 AM 3   Permit Number 14167 6002240.5096 2093994.70553 37.7298375431559 -122.434548888919 (37.7298375431559, -122.434548888919)
35380 221506 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 900x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   6005698.11962 2103476.06965 37.756066894799204 -122.423269241105 (37.7560668947992, -122.423269241105)
41267 221568 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 359 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6001813.22675 2103761.96483 37.7566318794794 -122.436724942504 (37.7566318794794, -122.436724942504)
43283 221415 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     1 Width 3ft   6005678.5014 2103825.14435 37.7570242653802 -122.42336190183201 (37.7570242653802, -122.423361901832)
49955 91244 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 852x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   01/20/2016 07:21:00 AM 3     6005625.0 2104006.0 37.757517833055395 -122.423559787953 (37.7575178330554, -122.423559787953)
51201 221569 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 616 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6003001.08037 2104529.5167 37.7588068286936 -122.432671745707 (37.7588068286936, -122.432671745707)
54543 187786 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1650 Galvez Ave 1 Side Yard : Yard 17 Tree 1 Private 1     6     6015560.61147 2097934.79581 37.7414033822515 -122.388774319486 (37.7414033822515, -122.388774319486)
55516 221529 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     10 Width 3ft   6005786.9094 2101880.5255400003 37.751690910628 -122.42284878555701 (37.751690910628, -122.422848785557)
55535 221566 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001342.8820400005 2102344.46852 37.7527130350975 -122.43825001643299 (37.7527130350975, -122.438250016433)
63120 105071 Significant Tree 6 Acacia stenophylla :: Shoestring Acacia 109 1808 Vallejo St 1 Front Yard : Yard 7 Tree 1 Private 1     3   Permit Number 771033 6004794.05676 2118138.55822 37.796275437823894 -122.427440299436 (37.7962754378239, -122.427440299436)
78847 91259 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 952x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005689.43944 2103423.018644 37.755920739203 -122.423295489065 (37.755920739203, -122.423295489065)
79149 91241 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 842x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
79479 91245 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 870x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005631.0 2103898.0 37.7572216289442 -122.423531359417 (37.7572216289442, -122.423531359417)
80086 37574 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 30 Collingwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/2014 12:00:00 AM 3   Permit Number 773155 6001973.00287599 2105680.02476784 37.7619074866084 -122.43630964556101 (37.7619074866084, -122.436309645561)
80089 91264 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 978X Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005697.5214949995 2103276.567378 37.7555190742141 -122.423257128608 (37.7555190742141, -122.423257128608)
83208 91248 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 888x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   01/20/2016 07:34:00 AM 3     6005668.887935 2103795.421709 37.7569421113624 -122.423393035961 (37.7569421113624, -122.423393035961)
85186 91292 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1286x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005762.0 2101471.0 37.7505650422621 -122.422905822788 (37.7505650422621, -122.422905822788)
86391 184203 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1466 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983430.71 2105161.519 37.75941282066329 -122.500400782356 (37.7594128206633, -122.500400782356)
86576 43724 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 759 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
87396 91276 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1156x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005723.0 2102230.0 37.75264688060071 -122.42309463069999 (37.7526468806007, -122.4230946307)
87711 91236 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 804 Guerrero St 1 Median : 22 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3 3x100   6005614.0 2104300.0 37.758324467407704 -122.423618732861 (37.7583244674077, -122.423618732861)
88269 91249 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 870x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   01/20/2016 07:26:00 AM 3     6005631.0 2103898.0 37.7572216289442 -122.423531359417 (37.7572216289442, -122.423531359417)
89562 91280 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1180x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005731.0 2102090.0 37.75226292437829 -122.42305701527599 (37.7522629243783, -122.423057015276)
90094 54118 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 760 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)
90155 91291 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1282x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005761.0 2101495.0 37.7506308843168 -122.422910986406 (37.7506308843168, -122.422910986406)
90343 91247 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 880x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   01/20/2016 07:29:00 AM 3     6005634.0 2103838.0 37.7570570522806 -122.423516718678 (37.7570570522806, -122.423516718678)
94067 91239 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 842x Guerrero St 1 Median : Hanging Pot 28 Tree 1 DPW 2   11/20/1989 12:00:00 AM 3     6005622.0 2104059.0 37.7576631893365 -122.423573931211 (37.7576631893365, -122.423573931211)
95136 110618 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400X GUERRERO ST 1 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:37:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
95405 91269 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1120x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005712.0 2102441.0 37.753225617065894 -122.423147667433 (37.7532256170659, -122.423147667433)
96686 91289 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1258x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005785.088369001 2101640.018452 37.751030430802395 -122.422837991942 (37.7510304308024, -122.422837991942)
101453 91246 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 876x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005633.0 2103862.0 37.7571228942355 -122.423521883288 (37.7571228942355, -122.423521883288)
101466 91258 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 948x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005688.196047001 2103445.549621 37.755982533848794 -122.423301390711 (37.7559825338488, -122.423301390711)
103989 91275 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1150x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005721.0 2102265.0 37.7527428696504 -122.423104034617 (37.7527428696504, -122.423104034617)
105304 43729 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 763 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43366 5994409.95328954 2089904.45905166 37.7181590824666 -122.461323431638 (37.7181590824666, -122.461323431638)
105439 115510 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:55:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
107213 91271 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1130x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005715.0 2102383.0 37.753066531779496 -122.423133170481 (37.7530665317795, -122.423133170481)
108090 91255 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 940x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005685.709261 2103490.611554 37.75610612308 -122.423313194032 (37.75610612308, -122.423313194032)
109310 91243 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 850x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   02/10/2009 12:00:00 AM 3     6005625.0 2104018.0 37.7575507822519 -122.423560641088 (37.7575507822519, -122.423560641088)
111105 91265 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 986x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005700.008282 2103231.505425 37.7553954849101 -122.423245325469 (37.7553954849101, -122.423245325469)
111602 91252 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 908x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005675.762116 2103670.859284 37.7566004799608 -122.42336040770901 (37.7566004799608, -122.423360407709)
111728 91263 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 970x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005695.03471 2103321.62929 37.7556426634019 -122.42326893177601 (37.7556426634019, -122.423268931776)
113015 91288 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1250x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005751.0 2101683.0 37.751146524787295 -122.42295892763201 (37.7511465247873, -122.422958927632)
114885 110772 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000X GUERRERO ST 1 Median : Cutout 11 Tree 1 DPW 2   05/26/2015 03:10:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
116212 91274 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1144x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005719.0 2102300.0 37.7528388586979 -122.423113438558 (37.7528388586979, -122.423113438558)
116885 96193 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1640 Jerrold Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 4x50   6015077.4 2097255.4 37.7395111076977 -122.39039765239299 (37.7395111076977, -122.390397652393)
123181 91238 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 812x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005612.0 2104238.0 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698)
123253 91277 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1170x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005728.0 2102148.0 37.752422009696005 -122.42307151190799 (37.752422009696, -122.423071511908)
123263 91272 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1136x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005717.0 2102348.0 37.752970542737295 -122.423123766486 (37.7529705427373, -122.423123766486)
123889 109693 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x GUERRERO ST 1 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 10:53:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
128795 91254 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 928x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005681.9790819995 2103558.204453 37.7562915069181 -122.423330899086 (37.7562915069181, -122.423330899086)
129415 43734 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 777 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43371 5994281.26699369 2089905.22565848 37.7181537802459 -122.46176829730601 (37.7181537802459, -122.461768297306)
139621 91273 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1140x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3     6005718.0 2102324.0 37.752904700718105 -122.423118602517 (37.7529047007181, -122.423118602517)
140294 110759 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300X GUERRERO ST 1 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:59:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
141128 91251 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 906X Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005675.14042 2103682.124768 37.756631377266295 -122.42336335858299 (37.7566313772663, -122.423363358583)
141379 91281 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
141675 91237 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 808 Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   11/20/2009 12:00:00 AM 3 4x15   6005611.0 2104262.0 37.7582199589604 -122.423626406477 (37.7582199589604, -122.423626406477)
144269 56594 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 533 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/16/2012 12:00:00 AM 3 3x3 Permit Number 768959 6003224.0 2096098.0 37.7356684939052 -122.431298930259 (37.7356684939052, -122.431298930259)
145556 66265 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 4020 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/30/1990 12:00:00 AM 3 6x9 Permit Number 29370 6003740.3803829 2100725.5739603 37.7484039979455 -122.429843577344 (37.7484039979455, -122.429843577344)
155244 221567 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 324 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004154.58593 2103373.98314 37.7556993571514 -122.428600021096 (37.7556993571514, -122.428600021096)
169767 221481 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 500x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   6005557.328430001 2105982.39063 37.7629407171602 -122.423934361684 (37.7629407171602, -122.423934361684)
184620 221570 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 117 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001705.56397 2108155.3423 37.768688901296294 -122.437411868978 (37.7686889012963, -122.437411868978)
745 221429 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:39:00 AM 1 Width 3ft   6005428.96653 2108339.30361 37.76940499098671 -122.424545983407 (37.7694049909867, -122.424545983407)
4312 221469 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:33:00 AM 1 3x3   6005528.17729 2106528.83552 37.7644394796106 -122.42407404799499 (37.7644394796106, -122.424074047995)
4371 221454 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:48:00 PM 1 Width 3ft   6005462.2492 2107712.58298 37.7676860457059 -122.42438627731501 (37.7676860457059, -122.424386277315)
4372 221457 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:54:00 AM 1 Width 3ft   6005492.07657 2107122.67642 37.766067987261295 -122.42424114830798 (37.7660679872613, -122.424241148308)
4454 221495 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 10:54:00 PM 2 Width 3ft   6005593.17627 2105367.35468 37.761253997298205 -122.42376664264299 (37.7612539972982, -122.423766642643)
5110 152413 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 700x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005625.074080001 2104777.98262 37.7596375207611 -122.42361441706899 (37.7596375207611, -122.423614417069)
5643 118347 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:39:00 AM 3              
30827 221416 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 800x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   6005677.18728 2103848.76992 37.757089061516204 -122.42336812603399 (37.7570890615162, -122.423368126034)
45394 203292 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 10 Jules Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5994458.02189 2089982.3581700001 37.7183757412389 -122.461162923744 (37.7183757412389, -122.461162923744)
48376 91282 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005738.0 2101906.0 37.7517580978369 -122.42301973133999 (37.7517580978369, -122.42301973134)
59268 187787 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1650 Galvez Ave 2 Side Yard : Yard 17 Tree 1 Private 1     7     6015518.873319999 2097965.1979799997 37.7414845469671 -122.388920758811 (37.7414845469671, -122.388920758811)
59935 203290 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 11 Jules Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   5994415.40381 2090011.1413599998 37.7184523203103 -122.46131232093201 (37.7184523203103, -122.461312320932)
74207 221519 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005822.7904900005 2101267.93468 37.7500109014944 -122.422681175305 (37.7500109014944, -122.422681175305)
76927 221546 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005723.96055 2103030.09242 37.7548438033068 -122.423148175257 (37.7548438033068, -122.423148175257)
80134 91278 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1170x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005728.0 2102148.0 37.752422009696005 -122.42307151190799 (37.752422009696, -122.423071511908)
83271 43725 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 759 Lakeview Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM     Permit Number 43364 5994445.58077229 2089904.10562801 37.7181601624587 -122.46120025798099 (37.7181601624587, -122.461200257981)
85719 110619 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 400X GUERRERO ST 2 Median : Cutout 11 Tree 1 DPW 2   04/29/2015 10:33:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
109596 91294 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1286x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3     6005762.0 2101471.0 37.7505650422621 -122.422905822788 (37.7505650422621, -122.422905822788)
116707 91266 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100X Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   06/21/2016 01:48:00 PM 3 3x500   6005744.445578 2102548.346221 37.753522195893105 -122.423043093148 (37.7535221958931, -122.423043093148)
117919 91293 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 812x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   11/20/2001 12:00:00 AM 3     6005612.0 2104238.0 37.7581541170225 -122.423621241698 (37.7581541170225, -122.423621241698)
118209 115511 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 200x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   02/09/2016 12:48:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
118317 109694 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 600x GUERRERO ST 2 Median : Cutout 11 Tree 1 DPW 2   02/21/2015 10:54:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
118503 91256 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 940X Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   11/20/2008 12:00:00 AM 3 3x100   6005685.709261 2103490.611554 37.75610612308 -122.423313194032 (37.75610612308, -122.423313194032)
121602 110760 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300X GUERRERO ST 2 Median : Cutout 11 Tree 1 DPW 2   06/19/2015 10:54:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
136012 187785 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1740 20th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 3ft   6012766.00153 2104746.33455 37.7599511143744 -122.39891512883499 (37.7599511143744, -122.398915128835)
141030 43726 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 760 Lakeview Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2000 12:00:00 AM     Permit Number 43365 5994428.64681371 2089956.34861374 37.7183026346731 -122.461262575973 (37.7183026346731, -122.461262575973)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 85.544ms · Data source: data.sfgov.org