home / trees

Street_Tree_List

Data source: data.sfgov.org

797 rows where qCareAssistant = 4

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
1744 102022 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1745 102023 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1746 102024 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1747 102025 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1748 102026 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 6 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1749 102027 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 7 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1750 102028 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 8 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1751 102029 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 9 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1752 102030 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 10 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1753 102031 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 11 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1754 102032 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 12 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1755 102033 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 13 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1756 102034 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 165X Chattanooga St 14 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
1831 102115 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 1035 Gilman Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   6 3x3 Permit Number 52469 6015181.7 2089440.8 37.7180595657824 -122.389491420596 (37.7180595657824, -122.389491420596) 10 3 8 58 1
1866 102154 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 450X Banks St 9 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
1867 102155 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 450X Banks St 10 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
1868 102156 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 450X Banks St 11 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
1897 102186 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 3999X Folsom St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1898 102187 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 3999X Folsom St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1899 102189 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1901 102190 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 6 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   6 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1902 102191 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1903 102192 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 7 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1904 102193 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 8 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   18 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1905 102194 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 10 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   4 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
4564 105143 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 132 432 Octavia St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3 DPW for City Agency 4   3 4x4   6005556.0703 2110851.1612 37.776309122873705 -122.42428501193301 (37.7763091228737, -122.424285011933) 7 9 11 28852 10
6788 107883 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6789 107884 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6790 107885 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6791 107886 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6792 107887 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
7496 108611 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 2025x Taylor St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   1 3x3   6008581.83386 2119799.52206 37.8010495338737 -122.414451351572 (37.8010495338737, -122.414451351572) 5 1 10 308 32
9560 110955 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 940 Filbert St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   9 5x5   6008486.881990001 2119694.39066 37.8007555347125 -122.41477248237699 (37.8007555347125, -122.414772482377) 5 1 10 308 32
9561 110956 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 940 Filbert St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   7 5x5   6008474.06115 2119692.72385 37.800750237701294 -122.414816729923 (37.8007502377013, -122.414816729923) 5 1 10 308 32
9562 110957 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 940 Filbert St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   9 5x5   6008462.007069999 2119690.6551900003 37.800743880377205 -122.41485829568998 (37.8007438803772, -122.41485829569) 5 1 10 308 32
9563 110958 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 940 Filbert St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   11 5x5   6008447.06762 2119689.6105 37.8007401724743 -122.414909918573 (37.8007401724743, -122.414909918573) 5 1 10 308 32
9564 110959 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 940 Filbert St 6 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   10 5x5   6008435.0253800005 2119688.1206900002 37.800735405160296 -122.414951484348 (37.8007354051603, -122.414951484348) 5 1 10 308 32
9566 110960 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 940 Filbert St 7 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   10 5x5   6008419.49323 2119686.5094 37.8007301081687 -122.415005118088 (37.8007301081687, -122.415005118088) 5 1 10 308 32
10519 112058 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 1199 VISITACION AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579) 9 7 8 309 39
10522 112060 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 1199 VISITACION AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579) 9 7 8 309 39
10523 112061 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 1199 VISITACION AVE 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579) 9 7 8 309 39
10524 112062 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 1199 VISITACION AVE 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 08/18/2015 12:00:00 AM   4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579) 9 7 8 309 39
10525 112063 Undocumented 3 Tristaniopsis laurina :: Swamp Myrtle 8 1199 VISITACION AVE 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     4x4   6009231.0 2087548.0 37.7125305915537 -122.40992695457899 (37.7125305915537, -122.409926954579) 9 7 8 309 39
11939 113570 Undocumented 3 Magnolia grandiflora :: Southern Magnolia 39 901 LOMBARD ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247) 5 1 10 308 32
11940 113571 Undocumented 3 Magnolia grandiflora :: Southern Magnolia 39 901 LOMBARD ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247) 5 1 10 308 32
11941 113572 Undocumented 3 Magnolia grandiflora :: Southern Magnolia 39 901 LOMBARD ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247) 5 1 10 308 32
11942 113573 Undocumented 3 Ficus nitida :: Laurel Fig 18 901 LOMBARD ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6007813.0 2120272.0 37.802303618634795 -122.417145352251 (37.8023036186348, -122.417145352251) 5 1 10 308 32
11943 113574 Undocumented 3 Ficus nitida :: Laurel Fig 18 901 LOMBARD ST 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247) 5 1 10 308 32
12180 113825 Undocumented 3 Arbutus unedo :: Strawberry Tree 58 1599x CASTRO ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 11/10/2015 12:00:00 AM 8 3x3   6002577.0 2101074.0 37.749294743689795 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
12182 113827 Undocumented 3 Eriobotrya deflexa :: Bronze Loquat 64 1599x CASTRO ST 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 02/16/2016 05:50:00 AM 3 3x3   6002577.0 2101074.0 37.749294743689795 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
13776 115549 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 925x Minnesota St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412) 10 3 8 28856 29
13778 115550 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 925x Minnesota St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.39018178636199 (37.7584697654838, -122.390181786362) 10 3 8 28856 29
13779 115551 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 26 925x Minnesota St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   20 18x7   6015277.41921 2104189.44931 37.7585616474178 -122.39019037219299 (37.7585616474178, -122.390190372193) 10 3 8 28856 29
13780 115552 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 29 925x Minnesota St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   6 15x7   6015276.56251 2104229.2059299997 37.7586707630633 -122.390196112573 (37.7586707630633, -122.390196112573) 10 3 8 28856 29
14238 116046 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 650x Kansas St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   4 5x15   6011495.20108 2105434.8979700003 37.761770862847705 -122.40335867726002 (37.7617708628477, -122.40335867726) 10 3 8 28856 29
14239 116047 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 133 650x Kansas St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   11 5x12   6011496.1211 2105415.8281900003 37.761718552879 -122.403354153666 (37.761718552879, -122.403354153666) 10 3 8 28856 29
14240 116048 DPW Maintained 1 Myoporum laetum :: Myoporum 27 650x Kansas St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   9 4x4   6011498.51602 2105372.79225 37.7616005195649 -122.403342842915 (37.7616005195649, -122.403342842915) 10 3 8 28856 29
14241 116049 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 650x Kansas St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   5 4x4   6011498.3385 2105356.0244 37.761554468880206 -122.403342277248 (37.7615544688802, -122.403342277248) 10 3 8 28856 29
14243 116050 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 650x Kansas St 6 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 4x4   6011499.79329 2105331.08163 37.76148606285779 -122.403335490949 (37.7614860628578, -122.403335490949) 10 3 8 28856 29
14244 116051 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 650x Kansas St 7 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 4x4   6011500.28754 2105307.1354099996 37.761420339490705 -122.40333209689699 (37.7614203394907, -122.403332096897) 10 3 8 28856 29
14245 116052 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 650x Kansas St 8 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 01/23/2018 12:00:00 AM 3 4x4   6011506.55629 2105277.69862 37.7613398627543 -122.403308344903 (37.7613398627543, -122.403308344903) 10 3 8 28856 29
14246 116053 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 650x Kansas St 9 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   11 4x4   6011508.109619999 2105241.51829 37.761240606399795 -122.40330042728901 (37.7612406063998, -122.403300427289) 10 3 8 28856 29
14247 116054 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 650x Kansas St 10 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   23 4x4   6011511.93551 2105220.59815 37.761183378041395 -122.403285723377 (37.7611833780414, -122.403285723377) 10 3 8 28856 29
14248 116055 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 650x Kansas St 11 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 01/23/2018 12:00:00 AM 3 4x4   6011513.13975 2105199.40577 37.7611252557522 -122.40328006754801 (37.7611252557522, -122.403280067548) 10 3 8 28856 29
14249 116056 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 650x Kansas St 12 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 03/30/2018 12:00:00 AM 23 4x4   6011515.191980001 2105171.68257 37.7610492486475 -122.40327101944901 (37.7610492486475, -122.403271019449) 10 3 8 28856 29
14250 116057 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2100x 19th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   2 3x3   6011480.97635 2105135.37266 37.760947638753 -122.40338680266001 (37.760947638753, -122.40338680266) 10 3 8 28856 29
14251 116058 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2100x 19th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   2 3x3   6011458.59484 2105134.56728 37.760944177262004 -122.403464154268 (37.760944177262, -122.403464154268) 10 3 8 28856 29
14252 116059 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2100x 19th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   2 3x3   6011431.5308 2105131.75607 37.760934946603605 -122.40355755965099 (37.7609349466036, -122.403557559651) 10 3 8 28856 29
14254 116060 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 2100x 19th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   7 3x3   6011408.71891 2105130.5396 37.7609303321981 -122.403636370817 (37.7609303321981, -122.403636370817) 10 3 8 28856 29
14255 116061 DPW Maintained 1 Melaleuca spp :: Melaleuca spp 261 2100x 19th St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   16 3x3   6011385.89017 2105128.48272 37.7609234092204 -122.403715181115 (37.7609234092204, -122.403715181115) 10 3 8 28856 29
14256 116062 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 2100x 19th St 6 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   22 3x3   6011361.02056 2105129.82914 37.7609257168785 -122.40380128939199 (37.7609257168785, -122.403801289392) 10 3 8 28856 29
14257 116063 DPW Maintained 1 Brachychiton discolor :: 336 2100x 19th St 7 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   19 3x3   6011332.66531 2105125.78364 37.760913024731295 -122.403899073603 (37.7609130247313, -122.403899073603) 10 3 8 28856 29
14258 116064 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 171 693 Vermont St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 03/30/2018 12:00:00 AM 3 8x7   6011272.30638 2105412.17877 37.761696029365794 -122.404127986133 (37.7616960293658, -122.404127986133) 10 3 8 28856 29
14259 116065 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 171 693 Vermont St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 03/30/2018 12:00:00 AM 3 8x7   6011274.01561 2105377.63125 37.761601265113896 -122.404119643106 (37.7616012651139, -122.404119643106) 10 3 8 28856 29
14566 116382 Permitted Site 2 Magnolia grandiflora :: Southern Magnolia 39 2501 25th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Fire Dept 13 DPW for City Agency 4     3x3   6011435.88896489 2101815.42613948 37.7518292809831 -122.403309184671 (37.7518292809831, -122.403309184671) 10 4 8 28859 19
14678 116522 DPW Maintained 1 Myoporum laetum :: Myoporum 27 324 08TH AVE 1 Sidewalk: Property side : Cutout 9 Tree 1 MTA 11 DPW for City Agency 4   8 3x3   5993416.0 2113304.0 37.7823509768718 -122.466458848407 (37.7823509768718, -122.466458848407) 11 6 2 54 11
14682 116527 DPW Maintained 1 Olea europaea :: Olive Tree 42 5732 GEARY BLVD 1 Sidewalk: Curb side : Yard 7 Tree 1 MTA 11 DPW for City Agency 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
15022 116857 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 950x Clay St 10 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   2 3x3   6010080.350930001 2117187.65635 37.793962057763 -122.409081415981 (37.793962057763, -122.409081415981) 3 1 10 28857 4
15126 116975 Undocumented 3 Salix spp :: Willow 40 100x CARGO WAY 6 Front Yard : Yard 4 Tree 1 PUC 12 DPW for City Agency 4         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
15127 116976 Undocumented 3 Salix spp :: Willow 40 100x CARGO WAY 7 Front Yard : Yard 4 Tree 1 PUC 12 DPW for City Agency 4         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
15128 116977 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 100x CARGO WAY 117 Front Yard : Yard 4 Tree 1 PUC 12 DPW for City Agency 4         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
17989 120542 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 2450 California St 1 Front Yard : Yard 4 Tree 1 MTA 11 DPW for City Agency 4         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726) 13 9 1 29490 27
20127 122749 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 79 693 Vermont St 9 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   5     6011285.506709999 2105214.92948 37.761155164510605 -122.404068449214 (37.7611551645106, -122.404068449214) 10 3 8 28856 29
20129 122750 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 79 693 Vermont St 8 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   9     6011285.1392 2105241.4016400003 37.761227830607204 -122.40407158333299 (37.7612278306072, -122.404071583333) 10 3 8 28856 29
20130 122751 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 693 Vermont St 7 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   18     6011280.99043 2105260.13165 37.7612790272197 -122.40408725043301 (37.7612790272197, -122.404087250433) 10 3 8 28856 29
20131 122752 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 79 693 Vermont St 6 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066) 10 3 8 28856 29
20132 122753 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 171 693 Vermont St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   15     6011277.810190001 2105311.62173 37.7614202297665 -122.404101873421 (37.7614202297665, -122.404101873421) 10 3 8 28856 29
20133 122754 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 693 Vermont St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   16     6011277.363419999 2105334.1858 37.761482160689894 -122.404105006665 (37.7614821606899, -122.404105006665) 10 3 8 28856 29
20134 122755 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 693 Vermont St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   14     6011274.22678 2105356.76628 37.7615439863765 -122.40411744427601 (37.7615439863765, -122.404117444276) 10 3 8 28856 29
28219 130257 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 2213 Jones St 6 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   4 Width 5ft   6008055.23608 2120086.8486599997 37.801808863839796 -122.416293973386 (37.8018088638398, -122.416293973386) 5 1 10 308 32
40780 142205 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 1683 HAYES ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 DPW for City Agency 4 07/31/2017 12:00:00 AM 3 Width 0ft Permit Number 779644 5999834.1012 2110180.6204 37.774143230926 -122.44403063203698 (37.774143230926, -122.444030632037) 15 5 11 29492 16
45615 173682 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 206 450x Raymond Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375) 9 7 8 309 18
45616 173683 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 206 450x Raymond Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375) 9 7 8 309 18
63958 192430 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 340 06th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 DPW for City Agency 4   9 Width 3ft   6011111.5516 2111334.7393 37.7779490450386 -122.405101020214 (37.7779490450386, -122.405101020214) 14 2 9 28853 34
123532 253146 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 260 Madrid St 12 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 10/25/2017 04:29:00 PM 3 3x3 Permit Number 767495 6003400.64895 2092179.59067 37.7249194341684 -122.430408699814 (37.7249194341684, -122.430408699814) 9 7 6 28861 5
123536 253150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 80 450X Moscow St 3 Sidewalk: Property side : Cutout 9 Tree 1 SFUSD 4 DPW for City Agency 4 10/11/2017 09:41:00 AM 3 3x3   6003965.721940001 2090553.1315400002 37.7204855291627 -122.42833943800899 (37.7204855291627, -122.428339438009) 9 7 6 28861 5
125667 256358 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 1150 Francisco St 10 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6005778.11415 2120709.05822 37.803388983478605 -122.42421815984501 (37.8033889834786, -122.424218159845) 5 9 1 28858 32
125859 256615 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1541x Montgomery St 1 Front Yard : Yard 4 Tree 1 DPW 1 DPW for City Agency 4         6011315.0 2120446.0 37.802977766472395 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
131301 30736 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 490X Page St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
131302 30737 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 36 490X Page St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 07/05/2000 12:00:00 AM 4 3x3 Permit Number 42884 6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355) 7 9 11 28852 10

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 28.781ms · Data source: data.sfgov.org