Street_Tree_List

Data source: data.sfgov.org

130 rows where qCareAssistant = 2 and qLegalStatus = 2

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
6478 98738 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1150 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Housing Authority 20 DPW for City Agency 2   3 4X4   6001885.6171 2112431.4484 37.780440254610205 -122.43709527307301 (37.7804402546102, -122.437095273073)
8790 105143 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 432 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3 DPW for City Agency 2   3 4x4   6005556.0703 2110851.1612 37.776309122873705 -122.42428501193301 (37.7763091228737, -122.424285011933)
15372 116055 Undocumented 2 Myoporum laetum :: Myoporum 1 650x Kansas St 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/30/2016 12:00:00 AM 3 4x4   6011513.13975 2105199.40577 37.7611252557522 -122.40328006754801 (37.7611252557522, -122.403280067548)
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)
24594 115551 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 925x Minnesota St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   20 18x7   6015277.41921 2104189.44931 37.7585616474178 -122.39019037219299 (37.7585616474178, -122.390190372193)
25232 116051 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 650x Kansas St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 4x4   6011500.28754 2105307.1354099996 37.761420339490705 -122.40333209689699 (37.7614203394907, -122.403332096897)
30215 116049 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 650x Kansas St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   5 4x4   6011498.3385 2105356.0244 37.761554468880206 -122.403342277248 (37.7615544688802, -122.403342277248)
35622 116053 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 650x Kansas St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   11 4x4   6011508.109619999 2105241.51829 37.761240606399795 -122.40330042728901 (37.7612406063998, -122.403300427289)
46988 116060 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2100x 19th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   7 3x3   6011408.71891 2105130.5396 37.7609303321981 -122.403636370817 (37.7609303321981, -122.403636370817)
55870 108611 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 2025x Taylor St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   1 3x3   6008581.83386 2119799.52206 37.8010495338737 -122.414451351572 (37.8010495338737, -122.414451351572)
58238 116047 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 650x Kansas St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   11 5x12   6011496.1211 2105415.8281900003 37.761718552879 -122.403354153666 (37.761718552879, -122.403354153666)
64195 116061 Undocumented 2 Melaleuca spp :: Melaleuca spp 130 2100x 19th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   16 3x3   6011385.89017 2105128.48272 37.7609234092204 -122.403715181115 (37.7609234092204, -122.403715181115)
65849 116063 Undocumented 2 Brachychiton discolor :: 440 2100x 19th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   19 3x3   6011332.66531 2105125.78364 37.760913024731295 -122.403899073603 (37.7609130247313, -122.403899073603)
77973 95480 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   8 3x3   5986567.36684 2111939.07455 37.7782057127303 -122.490051346189 (37.7782057127303, -122.490051346189)
78146 95448 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x3   5986572.26887 2111788.56268 37.777792736173794 -122.49002331517599 (37.7777927361738, -122.490023315176)
78641 116976 Undocumented 2 Salix spp :: Willow 218 100x CARGO WAY 7 Front Yard : Yard 7 Tree 1 PUC 13 DPW for City Agency 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
79463 116977 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 100x CARGO WAY 117 Front Yard : Yard 7 Tree 1 PUC 13 DPW for City Agency 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
79819 95474 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   5986559.68186 2112141.60911 37.7787613662348 -122.490092832202 (37.7787613662348, -122.490092832202)
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)
80252 102194 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3999X Folsom St 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   4 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
80671 102030 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 10 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)
80947 73875 Undocumented 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 450X Banks St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 8 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
81972 98746 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 540X Eureka St 3 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)
82909 95459 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 657X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   18 3x3   5986588.2 2111449.2 37.776861872872 -122.48994323847201 (37.776861872872, -122.489943238472)
83153 95455 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   8 3x3   5986575.69735 2111690.69221 37.777524211869896 -122.490004254704 (37.7775242118699, -122.490004254704)
83482 95466 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 529X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   5 3x3   5986555.1 2112324.8 37.7792640886788 -122.490122160768 (37.7792640886788, -122.490122160768)
83563 95451 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x3   5986574.08529 2111752.05161 37.777692593218106 -122.49001434550101 (37.7776925932181, -122.490014345501)
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)
84174 95453 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x3   5986555.22372 2112267.25724 37.7791060998783 -122.49011749902701 (37.7791060998783, -122.490117499027)
84851 95479 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   10 3x3   5986565.4115 2111984.30283 37.7783297825409 -122.490061437893 (37.7783297825409, -122.490061437893)
85371 95482 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   5986568.36529 2111879.34223 37.7780417630679 -122.49004349761299 (37.7780417630679, -122.490043497613)
86000 102186 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3999X Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
86703 95460 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3   5986585.7747 2111417.7398 37.77677535046679 -122.489949313769 (37.7767753504668, -122.489949313769)
86909 120542 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 2450 California St 1 Front Yard : Yard 7 Tree 1 MTA 6 DPW for City Agency 2         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726)
87154 95463 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3   5986592.12306 2111264.12941 37.7763539505765 -122.489916052727 (37.7763539505765, -122.489916052727)
88215 95470 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 539X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   4 3x3   5986557.7 2112257.8 37.7790802775989 -122.49010823686399 (37.7790802775989, -122.490108236864)
89957 113573 Undocumented 2 Ficus nitida :: Laurel Fig 43 901 LOMBARD ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3   6007813.0 2120272.0 37.802303618634795 -122.417145352251 (37.8023036186348, -122.417145352251)
90673 98752 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 540X Eureka St 9 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)
92105 98750 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 540X Eureka St 7 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)
92210 102025 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 5 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)
93270 98756 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 540X Eureka St 13 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)
94066 77325 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 11/18/1988 12:00:00 AM 3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
94177 95450 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   5986571.54012 2111769.53516 37.777740449455294 -122.49002443626999 (37.7777404494553, -122.49002443627)
94860 102155 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 450X Banks St 10 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512)
94912 98754 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 540X Eureka St 11 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)
95866 95478 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x3   5986565.85749 2112005.2728 37.7783873861575 -122.49006143788601 (37.7783873861575, -122.490061437886)
96908 113825 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1599x CASTRO ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 11/10/2015 12:00:00 AM 8 3x3   6002577.0 2101074.0 37.749294743689795 -122.433891418078 (37.7492947436898, -122.433891418078)
96989 95473 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x3   5986560.12785 2112162.57896 37.778818969517495 -122.490092832211 (37.7788189695175, -122.490092832211)
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)
99976 102032 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 12 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)
100018 78992 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 450X Banks St 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
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)
101167 102154 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 450X Banks St 9 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512)
101641 78999 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 555 Tompkins Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
101877 102191 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3999X Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
103838 102029 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 9 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)
104096 112062 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1199 VISITACION AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 08/18/2015 12:00:00 AM   4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
104766 95472 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x3   5986558.09049 2112203.93573 37.7789324044573 -122.49010292295799 (37.7789324044573, -122.490102922958)
105164 102027 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 7 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)
105405 98743 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 155 Masonic Ave 5 Sidewalk: Property side : 26 Tree 1 SFUSD 4 DPW for City Agency 2         5998843.8 2112455.0 37.7803315496091 -122.447619999218 (37.7803315496091, -122.447619999218)
105856 113571 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 901 LOMBARD ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
107003 102193 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3999X Folsom St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   18 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
107741 95468 Undocumented 2 Olea europaea :: Olive Tree 41 535X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3 53267 5986556.7 2112284.6 37.7791538043677 -122.49011366804301 (37.7791538043677, -122.490113668043)
107984 95456 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   5986576.02446 2111660.34524 37.7774409068096 -122.49000089052099 (37.7774409068096, -122.490000890521)
108157 113570 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 901 LOMBARD ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
108801 98744 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 540X Eureka St 1 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)
110614 98755 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 540X Eureka St 12 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)
110736 98753 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 540X Eureka St 10 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)
111333 102034 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 14 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)
111619 74109 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 555 Tompkins Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
114491 95467 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 533X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   4 3x3   5986556.1 2112298.0 37.779190561911896 -122.490116729573 (37.7791905619119, -122.490116729573)
114699 98740 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1150 Scott St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Housing Authority 20 DPW for City Agency 2   20 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
114913 73421 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 450X Banks St 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 10 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
115273 95481 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3   5986568.37611 2111910.32722 37.778126839673 -122.490045739805 (37.778126839673, -122.490045739805)
115568 95457 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x3   5986582.95432 2111498.49198 37.776996908357 -122.48996501091601 (37.776996908357, -122.489965010916)
118133 73874 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 450X Banks St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
118157 102031 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 11 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)
118347 95483 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   5 3x3   5986569.82886 2111856.71768 37.777979727950296 -122.490036770148 (37.7779797279503, -122.490036770148)
118537 95464 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3   5986592.75422 2111242.97331 37.7762958987751 -122.48991231304501 (37.7762958987751, -122.489912313045)
118717 102187 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 3999X Folsom St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
118859 95476 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x3   5986563.84754 2112047.92011 37.778504366165 -122.490071528655 (37.778504366165, -122.490071528655)
119479 113827 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1599x CASTRO ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 02/16/2016 05:50:00 AM 3 3x3   6002577.0 2101074.0 37.749294743689795 -122.433891418078 (37.7492947436898, -122.433891418078)
120350 95462 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   5986590.675530001 2111282.39545 37.776404019422294 -122.489922403821 (37.7764040194223, -122.489922403821)
120376 112063 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1199 VISITACION AVE 5 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
120907 78998 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 450X Banks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 6 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
122089 95477 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   8 3x3   5986565.00775 2112026.27031 37.7784449897253 -122.490065922262 (37.7784449897253, -122.490065922262)
122742 102156 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 450X Banks St 11 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512)
123118 112058 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 1199 VISITACION AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579)
124700 95475 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   5986561.73612 2112070.55828 37.7785664008394 -122.490080498329 (37.7785664008394, -122.490080498329)
124734 95452 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   6 3x3   5986573.32223 2111731.4109099996 37.7776358751612 -122.490015466607 (37.7776358751612, -122.490015466607)
125030 102033 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 13 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)
126186 70471 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 450X Banks St 7 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 32 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
126295 102028 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 8 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)
126306 70470 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 450X Banks St 8 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
126367 95461 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   10 3x3   5986588.1418 2111391.86812 37.776704452390796 -122.489939222082 (37.7767044523908, -122.489939222082)
126702 98737 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1150 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Housing Authority 20 DPW for City Agency 2   24 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
127011 102024 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 165X Chattanooga St 4 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)
127043 95458 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 03/12/2011 12:00:00 AM 3 3x3   5986582.44659 2111474.61787 37.7769313271764 -122.48996501092199 (37.7769313271764, -122.489965010922)
127620 102189 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 3999X Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
127891 95465 Undocumented 2 Olea europaea :: Olive Tree 41 601X 30th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   8 3x3   5986594.5418 2111220.3413400003 37.7762338621769 -122.489904464478 (37.7762338621769, -122.489904464478)

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