Street_Tree_List

Data source: data.sfgov.org

237 rows where qSiteInfo = 8 sorted by SiteOrder

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3318 253415 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 55 Stoneybrook Ave   Front Yard : Cutout 8 Tree 1 Private 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
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)
66196 107892 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 162 Brewster St   Front Yard : Cutout 8 Tree 1 Private 1   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773952 6010231.01704 2099016.49618 37.7440766668365 -122.40727852777799 (37.7440766668365, -122.407278527778)
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)
80037 86731 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 2 Pico Ave   Front Yard : Cutout 8 Tree 1 Private 1         Permit Number 49705 5994102.9 2092171.9 37.724367252780496 -122.462549157922 (37.7243672527805, -122.462549157922)
86498 107113 Significant Tree 6 Brahea edulis :: Guadalupe Palm 115 2100 MARKET ST   Front Yard : Cutout 8 Tree 1 Private 1           6004034.0 2107672.1 37.767494134010896 -122.429323526179 (37.7674941340109, -122.429323526179)
93980 110202 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1039 PAGE ST   Front Yard : Cutout 8 Tree 1 Private 1       4x5   6001572.7 2109358.5 37.771984919077 -122.43795762529301 (37.771984919077, -122.437957625293)
94216 100680 Undocumented 2 Myoporum laetum :: Myoporum 1 387 Beacon St   Front Yard : Cutout 8 Tree 1 Private 1         7' wide public RoW 6002378.0 2098199.0 37.7413893731095 -122.434374040118 (37.7413893731095, -122.434374040118)
95257 93959 Permitted Site 1 Prunus spp :: Cherry 84 419 Elizabeth St   Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 53399 6003681.0 2102149.0 37.752309029626495 -122.430150445418 (37.7523090296265, -122.430150445418)
103688 92051 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2323 Cesar Chavez St   Front Yard : Cutout 8 Tree 1 DPW 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
104404 106685 Undocumented 2 Juniperus chinensis :: Juniper 19 100 Yukon St   Front Yard : Cutout 8 Tree 1 Private 1         Permit Number 772768 6000197.4 2104288.0 37.757984281634 -122.44235080136299 (37.757984281634, -122.442350801363)
105054 104686 Undocumented 2 Maytenus boaria :: Mayten 22 140 26TH AVE   Front Yard : Cutout 8 Tree 1 Private 1     22 4x4   5987812.9 2115041.6 37.786797021543 -122.485970438221 (37.786797021543, -122.485970438221)
114285 96183 Permitted Site 1 Tree(s) :: 17 330 South Van Ness Ave   Front Yard : Cutout 8 Landscaping 2 Private 1           6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
117993 108442 Permitted Site 1 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 750 12th Ave   Front Yard : Cutout 8 Tree 1 Private 1 FUF 1     3x3 Permit Number 773771 5992283.6285 2110333.09253 37.7741282667999 -122.470159914203 (37.7741282667999, -122.470159914203)
123053 113153 Significant Tree 6 Populus alba :: White Poplar 408 55 BRONTE ST   Front Yard : Cutout 8 Tree 1 Private 1     12 3x3   6009403.0 2097128.0 37.738844891472894 -122.410008345842 (37.7388448914729, -122.410008345842)
124228 111770 Significant Tree 6 Pittosporum tobira :: Japanese Mockorange 243 707 Douglass St   Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 775627 6001281.0 2102187.2 37.7522776937422 -122.438452748375 (37.7522776937422, -122.438452748375)
129310 99268 Property Tree 7 Tree(s) :: 17 292 Whitney St   Front Yard : Cutout 8 Tree 1 Private 1           6004280.0 2096681.0 37.7373290690714 -122.42768945491501 (37.7373290690714, -122.427689454915)
129412 104753 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2328 12TH AVE   Front Yard : Cutout 8 Tree 1 Private 1     22   Permit Number 770921 5992676.8 2099585.2 37.7446400909628 -122.468017927356 (37.7446400909628, -122.468017927356)
138475 96182 Permitted Site 1 Tree(s) :: 17 330 South Van Ness Ave   Front Yard : Cutout 8 Landscaping 2 Private 1   04/04/2011 12:00:00 AM     Permit Number 767813 6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
140608 92050 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 2323 Cesar Chavez St   Front Yard : Cutout 8 Tree 1 DPW 2   05/16/2009 12:00:00 AM       6012395.8634440005 2100936.77011 37.749470250033795 -122.399927744224 (37.7494702500338, -122.399927744224)
142217 108441 Private 5 Magnolia grandiflora :: Southern Magnolia 21 105 Lake St   Front Yard : Cutout 8 Tree 1 Private 1 FUF 1     3x3 Permit Number 773769 5995179.45913 2114890.0759 37.786807513731105 -122.46047306430201 (37.7868075137311, -122.460473064302)
563 173951 Significant Tree 6 Tree(s) :: 17 2646 Union St 1 Front Yard : Cutout 8 Tree 1 Private 1   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338.0 2118225.0 37.796259749404605 -122.442865342513 (37.7962597494046, -122.442865342513)
914 225888 Property Tree 7 Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 3255x 24th St 1 Front Yard : Cutout 8 Tree 1 MTA 6     32 6x6   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
1337 251410 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 21 2777 Pine St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 779015 6000658.0 2114782.0 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069)
1358 173635 Significant Tree 6 Tree(s) :: 17 2590 Pacific Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
1805 251709 DPW Maintained 3 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 902 Market St 1 Front Yard : Cutout 8 Tree 1 DPW 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
2105 251411 Significant Tree 6 Tree(s) :: 17 2751 Buchanan St 1 Front Yard : Cutout 8 Tree 1 Private 1   06/21/2017 12:00:00 AM 3 6x6 Permit Number 779887 6003497.0 2117826.0 37.7953437887296 -122.431906052505 (37.7953437887296, -122.431906052505)
2134 252904 Undocumented 2 Magnolia champaca :: Champa 170 1216 Clay St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   6008866.0 2117029.0 37.7934583239602 -122.41327198066799 (37.7934583239602, -122.413271980668)
2687 253164 Planning Code 138.1 required 4 Tree(s) :: 17 146 Cambridge St 1 Front Yard : Cutout 8 Tree 1 Private 1   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.4119099998 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225)
2772 252949 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 261x Winding Way 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
3269 253386 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 726 El Camino Del Mar 1 Front Yard : Cutout 8 Tree 1 Private 1           5986306.0 2114851.0 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158)
3709 253265 Significant Tree 6 Juniperus chinensis :: Juniper 19 180 San Aleso Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   09/19/2017 12:00:00 AM 3 3x3   5993319.0 2094440.0 37.730549723890206 -122.465423653439 (37.7305497238902, -122.465423653439)
3843 253568 Significant Tree 6 Eucalyptus globulus :: Blue Gum 103 301X Sargent St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
5087 150676 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 548 Rhode Island St 1 Front Yard : Cutout 8 Tree 1 Private 1   11/07/2017 12:00:00 AM 3 3x3 Permit Number 780811 6011754.983990001 2105812.52377 37.762822244976505 -122.402486741392 (37.7628222449765, -122.402486741392)
5179 253770 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 142 234 Carl St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 770677 5997066.0 2107091.0 37.7655016335596 -122.453382820195 (37.7655016335596, -122.453382820195)
5622 87285 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1820 Webster St 1 Front Yard : Cutout 8 Tree 1 Private 1     24 3x3 Permit Number 50302 6003460.507999999 2115059.4384 37.7877454479518 -122.43183468665801 (37.7877454479518, -122.431834686658)
8205 110025 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2585 Pacific Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   03/18/2015 12:00:00 AM 3   Permit Number 774536 6001760.7528800005 2116964.32872 37.7928792839017 -122.437851993568 (37.7928792839017, -122.437851993568)
9848 122687 Significant Tree 6 Tree(s) :: 17 1462 Funston Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   01/04/2017 12:00:00 AM 3 3x8 Permit Number 779171 5992142.99696903 2105491.66018597 37.7608268551195 -122.470293739312 (37.7608268551195, -122.470293739312)
9862 173716 Significant Tree 6 Ficus nitida :: Laurel Fig 43 1652 Fell St 1 Front Yard : Cutout 8 Tree 1 Private 1           5999516.0 2109850.0 37.7732172801378 -122.445107222354 (37.7732172801378, -122.445107222354)
9948 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 6 Higuera Ave 1 Front Yard : Cutout 8 Tree 1 Private 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
10183 173712 Undocumented 2 Tree(s) :: 17 699x 29th St 1 Front Yard : Cutout 8 Tree 1 Private 1   02/03/2017 12:00:00 AM 3 3x3 Permit Number 779391 6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
10236 173928 Undocumented 2 Pinus radiata :: Monterey Pine 3 51 Vulcan Stwy 1 Front Yard : Cutout 8 Tree 1 Private 1           6000543.0 2106304.0 37.763539413759204 -122.441300222472 (37.7635394137592, -122.441300222472)
11071 113042 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 62 500 Raymond Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   10/06/2015 12:00:00 AM 30 3x3   6008233.879509999 2088473.9314700002 37.715017072864796 -122.413438766187 (37.7150170728648, -122.413438766187)
11497 69940 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 1295 30th Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   05/06/2016 12:00:00 AM 3 5x5 Permit Number 778203 5986757.5345 2106473.3538 37.7632094781069 -122.488991584645 (37.7632094781069, -122.488991584645)
22873 251137 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 25x Goettingen St 1 Front Yard : Cutout 8 Tree 1 Private 1   03/10/2017 12:00:00 AM 3 3x3 Permit Number 779273 6009828.0 2094364.0 37.7312793503434 -122.40834398535401 (37.7312793503434, -122.408343985354)
29261 105753 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 15 3636 Buchanan St 1 Front Yard : Cutout 8 Tree 1 Private 1   02/21/2014 12:00:00 AM 13   Permit Number 771077 6003146.89414 2120799.57812 37.803488607670296 -122.433330062032 (37.8034886076703, -122.433330062032)
46828 84740 Permitted Site 1 Agonis flexuosa :: Peppermint Willow 7 143 Alhambra St 1 Front Yard : Cutout 8 Tree 1 Private 1   03/27/2007 12:00:00 AM 13 4x6 Permit Number 49254 6001588.49283 2120281.76365 37.8019782934262 -122.438685839601 (37.8019782934262, -122.438685839601)
56265 104652 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 94 953 Indiana St 1 Front Yard : Cutout 8 Tree 1 Private 1           6015057.1 2104275.7 37.758786250670205 -122.39095836980302 (37.7587862506702, -122.390958369803)
56651 31242 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 2523 17th Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   02/08/2008 12:00:00 AM 5 3x3 Permit Number 50225 5991071.12499 2098214.14208 37.7407826611875 -122.473469993967 (37.7407826611875, -122.473469993967)
68819 108096 Significant Tree 6 Ficus rubiginosa :: Port Jackson Fig 188 3370 Washington St 1 Front Yard : Cutout 8 Tree 1 Private 1     17   Permit Number 773610 5998674.83986 2115933.37372 37.789872594881295 -122.44845507873801 (37.7898725948813, -122.448455078738)
74401 121592 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 4233 Cesar Chavez St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   6002342.0 2100313.0 37.7471918787018 -122.434649642859 (37.7471918787018, -122.434649642859)
77706 114927 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
78331 117161 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1383X VERMONT ST 1 Front Yard : Cutout 8 Tree 1 Private 1           6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
78703 105804 Permitted Site 1 Geijera parviflora :: Australian Willow 68 117 ALPINE TER 1 Front Yard : Cutout 8 Tree 1 Private 1   04/10/2014 12:00:00 AM 14 3x3 Permit Number 772090 6001724.2 2108149.5 37.7686739192463 -122.437346990121 (37.7686739192463, -122.437346990121)
78878 2044 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 700X Bosworth St 1 Front Yard : Cutout 8 Tree 1 DPW 2     36   Permit Number 772999 6002154.6210393 2095431.8532492002 37.733778746199796 -122.43494855504801 (37.7337787461998, -122.434948555048)
79626 94583 Permitted Site 1 Tree(s) :: 17 90 Joost Ave 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   6001518.0 2094975.2 37.732488714298 -122.43711685564699 (37.732488714298, -122.437116855647)
79650 107185 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 21 10 Florence St 1 Front Yard : Cutout 8 Tree 1 Private 1         Permit Number 773363 6008515.42073 2118375.20615 37.7971349853662 -122.41458032272 (37.7971349853662, -122.41458032272)
80053 109497 Permitted Site 1 Acer rubrum 'Red Sunset' :: Red Swamp Maple 254 785 Mangels Ave 1 Front Yard : Cutout 8 Tree 1 Private 1 FUF 1 02/19/2015 12:00:00 AM 3 3x3 Permit Number 771883 5996438.0 2095245.0 37.732939449865896 -122.45469900823 (37.7329394498659, -122.45469900823)
80785 104444 Significant Tree 6 Acer japonicum :: Japanese Maple 183 507 Capp St 1 Front Yard : Cutout 8 Tree 1 Private 1       2x6 Permit Number 770679 6007300.0 2104257.5 37.7583027968034 -122.41778477647301 (37.7583027968034, -122.417784776473)
80984 88447 Permitted Site 1 Tree(s) :: 17 93 Prentiss St 1 Front Yard : Cutout 8 Tree 1 Private 1   07/14/2008 12:00:00 AM   3x3 Permit Number 51413 6008891.7 2098141.7 37.7415996198956 -122.411847801096 (37.7415996198956, -122.411847801096)
81076 88608 Significant Tree 6 Tree(s) :: 17 350 Urbano Dr 1 Front Yard : Cutout 8 Tree 1 Private 1   08/01/2008 12:00:00 AM     Permit Number 51562 5991996.0 2092560.0 37.72531132011171 -122.46986059313801 (37.7253113201117, -122.469860593138)
81797 115888 Significant Tree 6 Olea europaea :: Olive Tree 41 811 TREAT AVE 1 Front Yard : Cutout 8 Tree 1 Private 1     20 3x3   6008597.0 2103712.0 37.7568778816719 -122.413260590978 (37.7568778816719, -122.413260590978)
82032 39247 Significant Tree 6 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 3524 Jackson St 1 Front Yard : Cutout 8 Tree 1 Private 1   08/22/2002 12:00:00 AM   5x10 Permit Number 772836 5997387.02929021 2116081.37513577 37.790205252620794 -122.452921449726 (37.7902052526208, -122.452921449726)
84041 114392 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 15 104x TAPIA DR 1 Front Yard : Cutout 8 Tree 1 Private 1     10     5988688.0 2090939.0 37.72066869526729 -122.481177253578 (37.7206686952673, -122.481177253578)
85057 115566 Permitted Site 1 Tree(s) :: 17 2026 36TH AVE 1 Front Yard : Cutout 8 Tree 1 Private 1   04/04/2016 12:00:00 AM 3 3x3 Permit Number 777529 5985134.0 2101392.0 37.7491625951009 -122.49423221215099 (37.7491625951009, -122.494232212151)
85444 104728 Significant Tree 6 Tree(s) :: 17 3212 Jackson St 1 Front Yard : Cutout 8 Tree 1 Private 1   11/06/2013 12:00:00 AM     Permit Number 770525 5998810.5 2116292.9 37.7908675143955 -122.448011605492 (37.7908675143955, -122.448011605492)
85532 108239 Permitted Site 1 Tree(s) :: 17 15 ASHBURY TER 1 Front Yard : Cutout 8 Tree 1 Private 1   01/14/2015 12:00:00 AM 3 5x50 Permit Number 774721 5999554.7 2106911.6 37.7651513833487 -122.444762103204 (37.7651513833487, -122.444762103204)
85675 108214 Undocumented 2 Myoporum laetum :: Myoporum 1 1611 47th Ave 1 Front Yard : Cutout 8 Tree 1 Private 1     15 3x3   5981530.432709999 2104091.45519 37.756363002508294 -122.50689338520701 (37.7563630025083, -122.506893385207)
85684 116955 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 46 818 Douglass St 1 Front Yard : Cutout 8 Tree 1 Private 1     6 3x3   6001245.0 2101454.0 37.7502624545247 -122.43852471352 (37.7502624545247, -122.43852471352)
85775 114272 Significant Tree 6 Tree(s) :: 17 2241 Sacramento St 1 Front Yard : Cutout 8 Tree 1 Private 1   03/22/2016 12:00:00 AM 3 3x6 Permit Number 776884 6004082.4 2115905.7 37.79010430227179 -122.42974344149499 (37.7901043022718, -122.429743441495)
88886 117247 Undocumented 2 Maytenus boaria :: Mayten 22 1096 EDDY ST 1 Front Yard : Cutout 8 Tree 1 Private 1       6x6   6005188.0 2113045.0 37.7823120756394 -122.425714454198 (37.7823120756394, -122.425714454198)
88934 107130 Property Tree 7 Phoenix dactylifera :: Date Palm 65 751 DOLORES ST 1 Front Yard : Cutout 8 Tree 1 Private 1           6005081.8 2103948.4 37.7573290011944 -122.42543429450701 (37.7573290011944, -122.425434294507)
89532 112366 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 2 2224 Baker St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 775823 5999858.5 2116547.8 37.791627252722 -122.444403911295 (37.791627252722, -122.444403911295)
89540 112569 Undocumented 2 Cordyline australis :: Dracena Palm 141 162 GRAND VIEW AVE 1 Front Yard : Cutout 8 Tree 1 Private 1     7 3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
89776 98528 Permitted Site 1 Cupressus sempervirens :: Italian Cypress 136 428 11th St 1 Front Yard : Cutout 8 Tree 1 Private 1   02/22/2012 12:00:00 AM   3x3 Permit Number 768342 6009030.0 2108561.0 37.7702164230423 -122.41210579217699 (37.7702164230423, -122.412105792177)
91973 106184 Significant Tree 6 Olea europaea :: Olive Tree 41 1327 ULLOA ST 1 Front Yard : Cutout 8 Tree 1 Private 1 FUF 1   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077)
92947 99830 Significant Tree 6 Syzygium paniculatum :: Brush Cherry 198 2398@Steiner Broadway 1 Front Yard : Cutout 8 Tree 1 Private 1           6002195.8 2117442.8 37.7942177709498 -122.436380971376 (37.7942177709498, -122.436380971376)
94493 110787 Section 143 8 Tree(s) :: 17 850x SANCHEZ ST 1 Front Yard : Cutout 8 Tree 1 Private 1   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
95797 114729 Permitted Site 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1930 35TH AVE 1 Front Yard : Cutout 8 Tree 1 Private 1   12/03/2015 12:00:00 AM   4x4   5985421.0 2102058.0 37.7510080399178 -122.493288836187 (37.7510080399178, -122.493288836187)
95902 96835 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 6001 Geary Blvd 1 Front Yard : Cutout 8 Tree 1 Private 1           5988352.4 2112527.1 37.779924341439 -122.483919468894 (37.779924341439, -122.483919468894)
97229 85428 Significant Tree 6 Tree(s) :: 17 43 Ora Way 1 Front Yard : Cutout 8 Tree 1 Private 1   08/23/2007 12:00:00 AM     Permit Number 49665 6001553.3 2098294.6 37.741605021987205 -122.437232403771 (37.7416050219872, -122.437232403771)
97249 114184 Significant Tree 6 Tree(s) :: 17 2454 HYDE ST 1 Front Yard : Cutout 8 Tree 1 Private 1   01/07/2016 12:00:00 AM   30x30 Permit Number 776893 6007060.0 2120781.0 37.8036588138585 -122.41978724303999 (37.8036588138585, -122.41978724304)
98858 114924 Undocumented 2 Pinus radiata :: Monterey Pine 3 37X EVERGLADE DR 1 Front Yard : Cutout 8 Tree 1 Private 1   01/13/2016 12:00:00 AM 3 3x3   5986312.0 2095495.0 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139)
99196 108002 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 75 461X Ivy St 1 Front Yard : Cutout 8 Tree 1 Private 1           6005199.36333 2111122.83043 37.777034912059605 -122.425538300101 (37.7770349120596, -122.425538300101)
100355 116620 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 1 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4   12 3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
100592 116998 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 36 880x MCALLISTER ST 1 Front Yard : Cutout 8 Tree 1 Private 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
102339 113744 Significant Tree 6 Cordyline australis :: Dracena Palm 141 909 ASHBURY ST 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5999156.0 2107025.0 37.7654399906909 -122.44614926226002 (37.7654399906909, -122.44614926226)
103011 114923 Undocumented 2 Pinus radiata :: Monterey Pine 3 51X EVERGLADE DR 1 Front Yard : Cutout 8 Tree 1 Private 1   01/13/2016 12:00:00 AM 3 3x3   5986312.0 2095495.0 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139)
103533 12529 Private 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 105 Lake St 1 Front Yard : Cutout 8 Tree 1 Private 1 FUF 1 07/12/2004 12:00:00 AM 6 3x3 Permit Number 773769 5995136.95364 2114887.49287 37.78679797610221 -122.460619935074 (37.7867979761022, -122.460619935074)
103820 111068 Significant Tree 6 Ilex spp :: Holly Species 163 1836 08TH AVE 1 Front Yard : Cutout 8 Tree 1 Private 1       3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175)
104759 87819 Permitted Site 1 Cupressus macrocarpa :: Monterey Cypress 47 390 Lansdale Ave 1 Front Yard : Cutout 8 Tree 1 Private 1         Permit Number 50681 5995630.7 2096410.1 37.736092191921294 -122.457574304331 (37.7360921919213, -122.457574304331)
106272 115004 Private 5 Olea europaea 'Fruitless' :: Fruitless Olive 80 1050 MCALLISTER ST 1 Front Yard : Cutout 8 Tree 1 Office of Mayor 21 DPW 4 01/19/2016 09:19:00 AM 3 3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
107044 107197 Significant Tree 6 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 339 Kirkham St 1 Front Yard : Cutout 8 Tree 1 Private 1   08/07/2014 12:00:00 AM   3x3 Permit Number 773549 5993785.2645 2105241.5874099997 37.7602350326789 -122.464595750688 (37.7602350326789, -122.464595750688)
108375 111357 Significant Tree 6 Pinus radiata :: Monterey Pine 3 600x MANSELL ST 1 Front Yard : Cutout 8 Tree 1 DPW 2     48 3x3   6010142.0 2090267.0 37.720047423695505 -122.40696976451099 (37.7200474236955, -122.406969764511)
109200 101625 Property Tree 7 Fagus sylvatica :: European Beech 250 64 Levant St 1 Front Yard : Cutout 8 Tree 1 Private 1         Permit Number 769362 6000275.9 2106473.5 37.76398959970761 -122.442236202383 (37.7639895997076, -122.442236202383)
110088 114688 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 231 Dwight St 1 Front Yard : Cutout 8 Tree 1 Private 1   12/01/2015 12:00:00 AM     Permit Number 774702 6010865.8 2091429.3 37.723279336417704 -122.404549596707 (37.7232793364177, -122.404549596707)
111891 105167 Property Tree 7 Corymbia ficifolia :: Red Flowering Gum 60 4755X 03RD ST 1 Front Yard : Cutout 8 Tree 1 Arts Commission 19     8 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
114585 115388 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 169x BOCANA ST 1 Front Yard : Cutout 8 Tree 1 Private 1     25 40x50   6007278.0 2097999.0 37.7411171346524 -122.417417333034 (37.7411171346524, -122.417417333034)
115370 107863 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 218 HOWTH ST 1 Front Yard : Cutout 8 Tree 1 Private 1     3     5997350.1 2090721.9 37.720572361158105 -122.451219574954 (37.7205723611581, -122.451219574954)
117224 117027 Significant Tree 6 Cedrus deodara :: Deodar Cedar 129 731 CLAYTON ST 1 Front Yard : Cutout 8 Tree 1 Private 1           5998515.0 2108057.0 37.768236974715705 -122.44844065135099 (37.7682369747157, -122.448440651351)

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