Street_Tree_List

Data source: data.sfgov.org

321 rows where qSpecies = 109 sorted by Location

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 ▼
1982 118349 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:43:00 AM 3              
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              
2766 118353 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:58:00 AM 3              
3111 118355 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:48:00 AM 3              
3394 118348 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:19:00 AM 3              
4215 118354 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:05:00 AM 3              
4374 118351 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:32:00 AM 3              
5429 118350 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:53:00 AM 3              
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              
5661 118352 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:56:00 AM 3              
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)
179218 201712 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 724 Jamestown Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6015351.33364 2088303.0821 37.7149450173645 -122.388825682463 (37.7149450173645, -122.388825682463)
39265 201713 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 724 Jamestown Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6015343.41284 2088314.94317 37.7149771465452 -122.38885388790001 (37.7149771465452, -122.3888538879)
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)
161335 201715 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 726 Jamestown Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6015296.606380001 2088393.85947 37.715191240972 -122.38902117888901 (37.715191240972, -122.389021178889)
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)
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)
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)
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)
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)
111021 43728 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 760 Lakeview Ave 4 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)
112173 43727 Permitted Site 1 Acacia stenophylla :: Shoestring Acacia 109 760 Lakeview Ave 3 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)
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)
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)
55253 203291 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 11 Jules Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5994415.48252 2089998.39973 37.7184173393668 -122.461311125716 (37.7184173393668, -122.461311125716)
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)
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)
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)
29150 221508 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1201 San Jose Ave 15 Front Yard : Yard 7 Tree 1 Private 1     1     6004291.813569999 2095940.5809 37.73529671397821 -122.427595874056 (37.7352967139782, -122.427595874056)
46563 221509 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1201 San Jose Ave 38 Front Yard : Yard 7 Tree 1 Private 1     2     6004439.440880001 2096038.0117799998 37.735572586401894 -122.42709240931102 (37.7355725864019, -122.427092409311)
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)
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)
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)
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)
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)
178254 221510 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 13 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005838.80296 2100921.0233299998 37.7490592658716 -122.422601154533 (37.7490592658716, -122.422601154533)
185178 221511 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005835.54562 2100976.57743 37.749211620932606 -122.422616365666 (37.7492116209326, -122.422616365666)
182868 221512 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005835.43443 2101000.02463 37.749275995297296 -122.422618416129 (37.7492759952973, -122.422618416129)
41002 221513 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005831.83209 2101056.03846 37.7494295931996 -122.42263485302799 (37.7494295931996, -122.422634853028)
73212 221514 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005830.22915 2101083.18072 37.7495040291878 -122.42264232458 (37.7495040291878, -122.42264232458)
52769 221515 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005828.19442 2101110.33186 37.7495784651962 -122.42265128992399 (37.7495784651962, -122.422651289924)
137049 221516 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     9 Width 3ft   6005827.472999999 2101138.31675 37.749655264584 -122.42265577304701 (37.749655264584, -122.422655773047)
153605 221517 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005823.4134 2101214.1336 37.7498632112216 -122.422675198428 (37.7498632112216, -122.422675198428)
48258 221518 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1300x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005823.14172 2101242.96968 37.7499423731511 -122.42267818684799 (37.7499423731511, -122.422678186848)
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)
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)
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)
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)
150263 221520 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 13 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005805.491090001 2101500.8171 37.7506493670819 -122.422757545722 (37.7506493670819, -122.422757545722)
182320 221521 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005805.669319999 2101529.55059 37.7507282726947 -122.422758971142 (37.7507282726947, -122.422758971142)
32093 221522 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     18 Width 3ft   6005804.6365 2101559.54048 37.750810559762705 -122.42276467376999 (37.7508105597627, -122.42276467377)
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)
155379 221559 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 1306 York St 4 : 4 Tree 1 Private 1     7 Width 3ft   6010039.89073 2101557.1439900002 37.7510420290671 -122.408118546954 (37.7510420290671, -122.408118546954)
25270 221523 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005797.77147 2101666.82906 37.751104762181 -122.42279603761101 (37.751104762181, -122.422796037611)
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)
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)
54972 221524 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005795.8556 2101693.96335 37.7511791585977 -122.42280459107401 (37.7511791585977, -122.422804591074)
48249 221525 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     4 Width 3ft   6005795.99168 2101720.64475 37.7512524272579 -122.422806016491 (37.7512524272579, -122.422806016491)
73681 221526 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005792.85635 2101748.62489 37.7513290773756 -122.42281884712601 (37.7513290773756, -122.422818847126)
65787 221527 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005790.21854 2101800.81566 37.7514722323764 -122.422831677752 (37.7514722323764, -122.422831677752)
47639 221528 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1200x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005788.731319999 2101828.76193 37.7515488824818 -122.422838806667 (37.7515488824818, -122.422838806667)
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)
18710 91284 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 4 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)
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)
87539 91285 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 5 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)
94847 91287 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 7 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)
113634 91283 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 3 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)
120589 91286 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1212x Guerrero St 6 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)
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)
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)
42667 221530 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 12 Median : Cutout 11 Tree 1 DPW 2     11 Width 3ft   6005772.5167 2102115.11175 37.75233421815221 -122.422915228372 (37.7523342181522, -122.422915228372)
150449 221531 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 11 Median : Cutout 11 Tree 1 DPW 2     0 Width 3ft   6005769.92765 2102140.767 37.7524045154572 -122.422926004956 (37.7524045154572, -122.422926004956)
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)
84876 91279 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1170x Guerrero St 3 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)
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)
159464 221532 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005770.103999999 2102168.30473 37.7524801376575 -122.42292735211201 (37.7524801376575, -122.422927352112)
188083 221533 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2     8 Width 3ft   6005767.42939 2102227.70946 37.75264309841 -122.422940823082 (37.75264309841, -122.422940823082)
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)
158034 221565 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001328.916669999 2102339.67059 37.7526990668325 -122.438297967381 (37.7526990668325, -122.438297967381)
179284 221563 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001305.60339 2102341.6071 37.752703058000705 -122.438378727412 (37.7527030580007, -122.438378727412)
179875 221564 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 4286 23rd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001316.917769999 2102341.7359599997 37.7527040553705 -122.438339609582 (37.7527040553705, -122.438339609582)
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)
163113 221534 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005765.63484 2102254.12398 37.7527155253202 -122.422948906168 (37.7527155253202, -122.422948906168)
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)
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)
129563 221535 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2     4 Width 3ft   6005763.23809 2102308.0919 37.7528635735186 -122.42296102995199 (37.7528635735186, -122.422961029952)
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)
185218 221536 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2     9 Width 3ft   6005762.1987 2102333.32685 37.75293280420979 -122.422966417762 (37.7529328042098, -122.422966417762)
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)
130218 221537 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2     6 Width 3ft   6005757.84067 2102377.3752200003 37.753053504939 -122.422984619142 (37.753053504939, -122.422984619142)
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)
32785 221538 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   6005757.68157 2102409.38047 37.7531413749784 -122.422987443927 (37.7531413749784, -122.422987443927)
177057 221539 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1100x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   6005756.51513 2102435.1394700003 37.753212037416 -122.422993308391 (37.753212037416, -122.422993308391)
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)
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)
44105 221562 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 100 San Jose Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6006161.28805 2102498.9287799997 37.753410020459995 -122.421598049829 (37.75341002046, -122.421598049829)
148793 221561 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 100 San Jose Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6006161.81341 2102510.42937 37.7534416280528 -122.42159704977 (37.7534416280528, -122.42159704977)
71884 221560 Undocumented 2 Acacia stenophylla :: Shoestring Acacia 109 100 San Jose Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6006161.42459 2102519.64651 37.7534669142699 -122.42159904898001 (37.7534669142699, -122.42159904898)
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)
67326 221557 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 1000x Guerrero St 15 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   6005743.02813 2102638.73526 37.7537703032837 -122.42305441913099 (37.7537703032837, -122.423054419131)

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 97.164ms · Data source: data.sfgov.org