Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by qLegalStatus

View and edit SQL

These facets timed out: qLegalStatus

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
10187 173885   Tree(s) :: 17 410 Hearst Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/03/2017 12:00:00 AM 3 3x3 Permit Number 774920 5998687.3529 2094401.8148700001 37.7307530256695 -122.446861792344 (37.7307530256695, -122.446861792344)
10251 173771   Tree(s) :: 17 231 Stratford Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1   02/13/2017 12:00:00 AM 3 3x3 Permit Number 779366 5990884.97189 2090977.2345099999 37.7209011553391 -122.47358587031601 (37.7209011553391, -122.473585870316)
20491 85214   Jacaranda mimosifolia :: Jacaranda 52 2889 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 04/13/2007 12:00:00 AM 3 3x3 under 3yr maintenance agreement. ends on 4/13/2007 6009588.01504 2102148.81833 37.75264132339179 -122.409722943913 (37.7526413233918, -122.409722943913)
25407 95032   Tree(s) :: 17 211 Maynard St   Front Yard : Cutout 8 Landscaping 2 Private 1           6004772.0 2093802.0 37.729451797878205 -122.425783519869 (37.7294517978782, -122.425783519869)
42741 85379   Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3390 Cesar Chavez St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6007302.06128 2100623.1120599997 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933)
61148 85309   Olea europaea :: Olive Tree 41 1250 Haight St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/26/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
79071 95369   Tree(s) :: 17 27 Hartford St   Front Yard : Cutout 8 Landscaping 2 Private 1   02/18/2011 12:00:00 AM       6002651.0 2105744.0 37.7621216467866 -122.433969295968 (37.7621216467866, -122.433969295968)
79402 105345   Acacia melanoxylon :: Blackwood Acacia 5 466 Gonzalez Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5989603.4 2089229.6 37.7160282834266 -122.477888136934 (37.7160282834266, -122.477888136934)
80888 87432   Acer rubrum :: Red Maple 6 598X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 3 3x3   6006099.613365 2094764.868461 37.732170557364995 -122.421262171784 (37.732170557365, -122.421262171784)
82777 85446   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y12 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
83194 87400   Pyrus kawakamii :: Evergreen Pear 82 400X Monterey Blvd 10 Median : Cutout 11 Tree 1 DPW 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
84406 122604   Prunus serrulata :: Ornamental Cherry 35 132 Surrey St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/21/2016 12:00:00 AM 3 3x3 Permit Number 779127 6002205.30607 2096205.3193700002 37.7359053840536 -122.434828615692 (37.7359053840536, -122.434828615692)
85180 85312   Lophostemon confertus :: Brisbane Box 11 1366 Turk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     9 3x3   6003535.852940001 2112477.60862 37.780660663043605 -122.431389631549 (37.7806606630436, -122.431389631549)
88231 85433   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y1 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
89317 85483   Myoporum laetum :: Myoporum 1 2448 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6007028.643792 2120821.987554 37.8037695888063 -122.419898663276 (37.8037695888063, -122.419898663276)
90534 87858   Koelreuteria paniculata :: Golden Rain Tree 56     Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000340.49747 2104887.90927 37.7596396402708 -122.441898968169 (37.7596396402708, -122.441898968169)
90989 105124   Maytenus boaria :: Mayten 22 134 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 4x4   5987764.1 2115070.3 37.7868729795597 -122.486141380245 (37.7868729795597, -122.486141380245)
91145 87431   Acer rubrum :: Red Maple 6 522X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 3 3x3   6006584.964111 2094794.1521 37.732278314780295 -122.419586279513 (37.7322783147803, -122.419586279513)
91687 85306   Ligustrum lucidum :: Glossy Privet 55 1661 Pine St 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6005989.138522 2115548.501173 37.789231309471795 -122.423120870526 (37.7892313094718, -122.423120870526)
93324 32776   Tree(s) :: 17 552 Broderick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/20/2010 12:00:00 AM     Permit Number 54024 6001158.24288979 2110568.68225327 37.775284198166496 -122.43947802668 (37.7752841981665, -122.43947802668)
95026 85377   Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3390 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6007302.06128 2100623.1120599997 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933)
95845 85448   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y14 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
96265 85437   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y4 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
96662 87399   Pyrus kawakamii :: Evergreen Pear 82 400X Monterey Blvd 9 Median : Cutout 11 Tree 1 DPW 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
97533 85444   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y10 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
98712 85439   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y5 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
99579 85445   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y11 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
102642 85435   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y3 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/07/2006 12:00:00 AM 3 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
103498 85440   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y6 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
104112 87433   Acer rubrum :: Red Maple 6 598X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 3 3x3   6006099.613365 2094764.868461 37.732170557364995 -122.421262171784 (37.732170557365, -122.421262171784)
104127 105442   Tree(s) :: 17 38 Museum Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6000691.7 2106753.8 37.764782922965004 -122.440818185531 (37.764782922965, -122.440818185531)
105765 87423   Lophostemon confertus :: Brisbane Box 11 45X Jones St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 3 3x3   6009092.517833999 2112687.614007 37.7815506408215 -122.412181237011 (37.7815506408215, -122.412181237011)
105788 85443   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y9 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3   6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
107509 87402   Prunus cerasifera :: Cherry Plum 16 1300 Webster St 7 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 3x3   6003725.160049 2113179.0694110002 37.7825974263114 -122.430784800607 (37.7825974263114, -122.430784800607)
108522 113066   Cupressus macrocarpa :: Monterey Cypress 47 2X Cranleigh Dr 7 : 4 Tree 1 DPW 2   09/09/2015 01:08:00 PM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664)
110133 87430   Acer rubrum :: Red Maple 6 522X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 3 3x3   6006584.964111 2094794.1521 37.732278314780295 -122.419586279513 (37.7322783147803, -122.419586279513)
117485 87401   Pyrus kawakamii :: Evergreen Pear 82 400X Monterey Blvd 11 Median : Cutout 11 Tree 1 DPW 2   03/17/2008 12:00:00 AM 3 3x3   5999413.960874 2094696.855647 37.7316046219852 -122.44437099815 (37.7316046219852, -122.44437099815)
117918 87429   Acer rubrum :: Red Maple 6 500X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 3 3x3   6006724.46969 2094782.06277 37.7322529772765 -122.419103118684 (37.7322529772765, -122.419103118684)
119480 87425   Tree(s) :: 17 25X Jones St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 3 3x3   6009102.081359 2112621.9601169997 37.781370907497 -122.41214351023399 (37.781370907497, -122.412143510234)
119540 85436   Lophostemon confertus :: Brisbane Box 11 1397X Buchanan St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/17/2007 12:00:00 AM 3 3x3 Maintenance agreement ends 8/17/2010 6004184.830731 2113056.513958 37.782286952179 -122.429185796304 (37.782286952179, -122.429185796304)
120951 85249   Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1335 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/19/2007 12:00:00 AM 3 3x3 under 3 yr maintenance agreement. expires 7/19/2010 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)
122843 85018   Prunus cerasifera :: Cherry Plum 16 455 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2007 12:00:00 AM     Permit Number 49374 6002971.0 2099180.0 37.744116613623 -122.43239370297701 (37.744116613623, -122.432393702977)
122914 85441   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y7 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
123072 85434   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y2 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/23/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
123320 109532   Sequoia sempervirens :: Coast Redwood 116 818 Goettingen St 1 Back Yard : Yard 13 Tree 1 Private 1           6010847.3 2090865.3 37.7217296747854 -122.404573864697 (37.7217296747854, -122.404573864697)
123690 85484   Myoporum laetum :: Myoporum 1 2448 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   6007028.643792 2120821.987554 37.8037695888063 -122.419898663276 (37.8037695888063, -122.419898663276)
125466 110020   Myoporum laetum :: Myoporum 1 1490X Douglass St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       9x9   6001386.81709 2099547.0285 37.745034430207795 -122.437897729467 (37.7450344302078, -122.437897729467)
126348 85447   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y13 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
128811 87422   Lophostemon confertus :: Brisbane Box 11 45X Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM       6009092.517833999 2112687.614007 37.7815506408215 -122.412181237011 (37.7815506408215, -122.412181237011)
129428 85380   Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3390 Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3x3   6007302.06128 2100623.1120599997 37.7483237124677 -122.417520070933 (37.7483237124677, -122.417520070933)
138815 87410   Lophostemon confertus :: Brisbane Box 11 898X Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/22/2008 12:00:00 AM 3 3x3   6006570.640875 2113589.260791 37.783884515657896 -122.42096977598499 (37.7838845156579, -122.420969775985)
140895 85310   Olea europaea :: Olive Tree 41 1250 Haight St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/27/2007 12:00:00 AM 3 3x3 Under 3 yr maintenance agreement. Ends 7/27/2010. 6000155.2862 2108898.36192 37.77064078968729 -122.442827504693 (37.7706407896873, -122.442827504693)
141531 91166   Cercis canadensis :: Eastern Redbud 299 1548x Quesada Ave 4 Median : Cutout 11 Tree 1 DPW 2   01/31/2009 12:00:00 AM 3     6015526.48125 2094420.051093 37.7317507154659 -122.388647039673 (37.7317507154659, -122.388647039673)
141737 97434   Ulmus parvifolia :: Chinese Elm 46 1380x Newcomb Ave 5 Median : Cutout 11 Tree 1 DPW 2   09/30/2011 12:00:00 AM 3     6016360.63733 2094893.94179 37.7330981190079 -122.38579618360501 (37.7330981190079, -122.385796183605)
143542 85442   Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 360Y8 Valencia St   Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 08/22/2007 12:00:00 AM 6 4x4   6005797.96455 2107491.19806 37.7670971272034 -122.423209339646 (37.7670971272034, -122.423209339646)
143623 122603   Prunus serrulata :: Ornamental Cherry 35 132 Surrey St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 779127 6002205.30607 2096205.3193700002 37.7359053840536 -122.434828615692 (37.7359053840536, -122.434828615692)
145363 85250   Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1335 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2 Private 3 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.124369999 2111060.02557 37.7766442216524 -122.43884948393499 (37.7766442216524, -122.438849483935)
1 141565 Permitted Site 1 Myoporum laetum :: Myoporum 1 501X Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1988 12:00:00 AM 21 Width 0ft Permit Number 25401 6000609.0 2110829.0 37.7759676911831 -122.441396661871 (37.7759676911831, -122.441396661871)
6 141566 Permitted Site 1 Myoporum laetum :: Myoporum 1 501X Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 0ft   6000587.8822 2110733.5952 37.7757045307049 -122.441462866076 (37.7757045307049, -122.441462866076)
8 122650 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
10 122670 Permitted Site 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 301x Hickory St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3X3            
11 122658 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
12 122660 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
13 122648 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
16 122649 Permitted Site 1 Acer rubrum :: Red Maple 6 300x Hickory St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2016 12:00:00 AM 3 3x3            
23 52566 Permitted Site 1 Hakea suaveolens :: Sweet Hakea Tree 14 1555 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/12/2016 12:00:00 AM 2 3x3 Permit Number 777142 5983716.6125 2104561.7225 37.7577827259957 -122.499367683206 (37.7577827259957, -122.499367683206)
26 237469 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 4200 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/17/2000 12:00:00 AM 0 Width 3ft Permit Number 43111 6001814.64366 2102375.07824 37.75282390261339 -122.43662077403299 (37.7528239026134, -122.436620774033)
28 21823 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2741 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/19/2006 12:00:00 AM 3 4x4   6008229.33947 2122327.41953 37.8079706947476 -122.415850241604 (37.8079706947476, -122.415850241604)
31 22614 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1001 Turk St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 3x5   6005426.7391 2112695.1691 37.781365013820206 -122.424863625752 (37.7813650138202, -122.424863625752)
33 2889 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1545 California St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     65 3X3   6006951.47041 2116025.01423 37.79059395549061 -122.419825138035 (37.7905939554906, -122.419825138035)
39 3558 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 101 Cargo Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/2017 05:52:00 PM 6 3X3   6018773.865780001 2097541.9761 37.7405023461002 -122.377636624239 (37.7405023461002, -122.377636624239)
45 27522 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 3201 California St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3X3   5998967.7443 2114917.3257 37.787099536792 -122.44736849888001 (37.787099536792, -122.44736849888)
51 60867 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/1983 12:00:00 AM     Permit Number 20649          
55 2909 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1700 California St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 4X4   6006037.49643 2115968.63965 37.7903876339283 -122.422983431149 (37.7903876339283, -122.422983431149)
56 27602 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 988 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 4X4   6003218.3377 2111393.5053 37.7776659856505 -122.432410615738 (37.7776659856505, -122.432410615738)
57 44642 Permitted Site 1 Tree(s) :: 17   60 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/2001 12:00:00 AM     Permit Number 43835          
58 4749 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1255 Columbus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/03/2015 12:00:00 AM 8 3X3   6007516.58505 2121541.63395 37.805773032263296 -122.41826116482599 (37.8057730322633, -122.418261164826)
59 44994 Permitted Site 1 Tree(s) :: 17   106 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2001 12:00:00 AM     Permit Number 43922          
67 166623 Permitted Site 1 Potential Site :: Potential Site 29 520 Jersey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/2017 12:00:00 AM 3 Width 3ft Permit Number 18521 6001647.24706 2101482.78936 37.7503643764264 -122.437135780708 (37.7503643764264, -122.437135780708)
73 65479 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1051 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/1997 12:00:00 AM 10 3x3 Permit Number 28361 6008468.497880001 2115537.43749 37.789340533487795 -122.41454177659901 (37.7893405334878, -122.414541776599)
75 138824 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 729 GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6004305.1004 2111150.1162 37.77705926326529 -122.428633779399 (37.7770592632653, -122.428633779399)
76 241180 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 3 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004770.13014 2108408.30025 37.7695572102182 -122.426829784767 (37.7695572102182, -122.426829784767)
77 49739 Permitted Site 1 Tree(s) :: 17 145 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/2017 12:00:00 AM 3   Permit Number 779552 6013462.1222 2106403.54987 37.764540227980206 -122.396623740816 (37.7645402279802, -122.396623740816)
80 225032 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 4425 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/02/2004 12:00:00 AM 11 Width 3ft Permit Number 47310 6001257.01437 2105216.66208 37.7605944983664 -122.43875275812799 (37.7605944983664, -122.438752758128)
82 241178 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 1 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004795.3896699995 2108410.1055900003 37.769563595403106 -122.42674254153299 (37.7695635954031, -122.426742541533)
84 36641 Permitted Site 1 Robinia x ambigua :: Locust 33   13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/20/1998 12:00:00 AM     Permit Number 39461          
85 22613 Permitted Site 1 Acacia melanoxylon :: Blackwood Acacia 5 1001 Turk St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 3x5   6005358.7073 2112686.5825 37.7813375942673 -122.42509837168001 (37.7813375942673, -122.42509837168)
87 11032 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1500 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     70 3X3   6007492.86428 2117507.22815 37.794694232707 -122.41805706457599 (37.794694232707, -122.418057064576)
89 251189 Permitted Site 1 Tree(s) :: 17 1493 Hudson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/22/2017 12:00:00 AM 3 3x3   6016267.45517 2096986.6643299998 37.7388391569445 -122.38626419104999 (37.7388391569445, -122.38626419105)
90 241179 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 2 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 7 Width 3ft Permit Number 43693 6004783.47466 2108409.88584 37.769562318364 -122.426783739481 (37.769562318364, -122.426783739481)
91 241181 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 300 Duboce Ave 4 Front Yard : Yard 7 Tree 1 Private 1   02/20/2001 12:00:00 AM 8 Width 3ft Permit Number 43693 6004757.3052900005 2108409.26199 37.7695591257908 -122.42687421397 (37.7695591257908, -122.42687421397)
99 7992 Permitted Site 1 Pyrus calleryana :: Ornamental Pear 9 2247 Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/01/2007 12:00:00 AM 3 3X3   6005467.69382 2117725.44397 37.7951792074025 -122.42507996488001 (37.7951792074025, -122.42507996488)
100 106679 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 2200 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/24/2014 12:00:00 AM 10 3x3 Permit Number 773028 5999374.7893199995 2116379.94206 37.7911387486163 -122.44606546047702 (37.7911387486163, -122.446065460477)
103 117428 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 776915          
111 7749 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 400X Franklin St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3X3   6006371.15759 2111615.2483900003 37.7784531123456 -122.421519673008 (37.7784531123456, -122.421519673008)
113 183695 Permitted Site 1 Olea europaea :: Olive Tree 41 1341 42nd Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983048.7244 2105854.1384 37.7612921278024 -122.50177309900499 (37.7612921278024, -122.501773099005)
115 6964 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 700 Fell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3X3   6003997.6735 2110460.7643 37.7751490695403 -122.42964808764499 (37.7751490695403, -122.429648087645)
116 26163 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 220 Richardson Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   5999083.87135 2119853.9919 37.8006609458028 -122.447322173097 (37.8006609458028, -122.447322173097)
120 110194 Permitted Site 1 Ginkgo biloba :: Maidenhair Tree 44 2123 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/26/2015 12:00:00 AM 3 3x3 Permit Number 774924 6001844.69538 2115843.7088 37.789807124247496 -122.43748126425501 (37.7898071242475, -122.437481264255)
121 59839 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1201 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/1981 12:00:00 AM 3   Permit Number 19293 6016946.5018 2093669.1216 37.729767407645895 -122.383685429115 (37.7297674076459, -122.383685429115)

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