Street_Tree_List

Data source: data.sfgov.org

237 rows where qSiteInfo = 8

View and edit SQL

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

qCareAssistant

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
96 251196 Significant Tree 6 Pinus radiata :: Monterey Pine 3 900X 14th St 2 Front Yard : Cutout 8 Tree 1 Private 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
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)
901 224716 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 5 Front Yard : Cutout 8 Tree 1 MTA 6     13 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
905 224715 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 4 Front Yard : Cutout 8 Tree 1 MTA 6     12 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
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)
916 224714 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 3 Front Yard : Cutout 8 Tree 1 MTA 6     11 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
928 224422 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 2 Front Yard : Cutout 8 Tree 1 MTA 6     16 Width 3ft   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)
1791 251711 DPW Maintained 3 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 902 Market St 3 Front Yard : Cutout 8 Tree 1 DPW 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1793 251713 DPW Maintained 3 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 902 Market St 5 Front Yard : Cutout 8 Tree 1 DPW 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1795 251712 DPW Maintained 3 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 902 Market St 4 Front Yard : Cutout 8 Tree 1 DPW 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1797 251710 DPW Maintained 3 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 902 Market St 2 Front Yard : Cutout 8 Tree 1 DPW 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1799 251715 DPW Maintained 3 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 902 Market St 7 Front Yard : Cutout 8 Tree 1 DPW 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
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)
1807 251714 DPW Maintained 3 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 902 Market St 6 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)
2436 110026 Permitted Site 1 Acer palmatum :: Japanese Maple 175 2585 Pacific Ave 2 Front Yard : Cutout 8 Tree 1 Private 1   03/18/2015 12:00:00 AM 3   Permit Number 779691 6001774.18039 2116969.68651 37.7928947585324 -122.437805917729 (37.7928947585324, -122.437805917729)
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)
2712 253178 Significant Tree 6 Washingtonia filifera :: California Fan Palm 189 4450 24th St 2 Front Yard : Cutout 8 Tree 1 Private 1       Width 0ft   6000289.52403 2101701.02913 37.7508863393389 -122.441846529398 (37.7508863393389, -122.441846529398)
2767 252950 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 261x Winding Way 2 Front Yard : Cutout 8 Tree 1 Private 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
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)
3272 253387 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 726 El Camino Del Mar 2 Front Yard : Cutout 8 Tree 1 Private 1           5986306.0 2114851.0 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158)
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)
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)
4182 253620 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 142 1120 South Van Ness Ave 3 Front Yard : Cutout 8 Tree 1 Private 1       Width 3ft   6007603.98274 2103104.1444200003 37.755153048679205 -122.41665176419201 (37.7551530486792, -122.416651764192)
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)
9868 173714 Undocumented 2 Myoporum laetum :: Myoporum 1 699x 29th St 3 Front Yard : Cutout 8 Tree 1 Private 1       3x3   6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
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)
10195 173713 Undocumented 2 Tree(s) :: 17 699x 29th St 2 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)
13821 105161 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1600X Oakdale Ave 2 Front Yard : Cutout 8 Tree 1 Arts Commission 19     13 3x3   6014869.34112 2095641.8363700002 37.735069048787 -122.39100428831499 (37.735069048787, -122.391004288315)
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)
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)
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)
42991 105168 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 4755X 03RD ST 2 Front Yard : Cutout 8 Tree 1 Arts Commission 19     23 3x3 Permit Number 770204 6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
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)
50075 113043 Significant Tree 6 Pinus radiata :: Monterey Pine 3 500 RAYMOND AVE 2 Front Yard : Cutout 8 Tree 1 Private 1   10/06/2015 12:00:00 AM   3x3   6008527.0 2088690.0 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248)
54137 106873 Significant Tree 6 Pittosporum undulatum :: Victorian Box 26 38 08th St 4 Front Yard : Cutout 8 Tree 1 Private 1         Permit Number 769156 6008506.93846 2111466.3623599997 37.7781645006636 -122.41412064163201 (37.7781645006636, -122.414120641632)
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)
58682 116625 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 6 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
78259 111280 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 700X BOSWORTH ST 18 Front Yard : Cutout 8 Tree 1 DPW 2     48     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
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)
78663 114932 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 8 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
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)
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)
79308 111069 Significant Tree 6 Ilex spp :: Holly Species 163 1836 08TH AVE 3 Front Yard : Cutout 8 Tree 1 Private 1       3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175)
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)
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)
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)
80436 87674 Permitted Site 1 Eucalyptus Spp :: Eucalyptus 40 770 Golden Gate Ave 10 Front Yard : Cutout 8 Tree 1 Private 1   05/22/2008 12:00:00 AM   3x3 Permit Number 50396 6005860.1 2112469.5 37.7807698496384 -122.42334835915399 (37.7807698496384, -122.423348359154)
80776 114263 Undocumented 2 Pinus radiata :: Monterey Pine 3 800x BROTHERHOOD WAY 4 Front Yard : Cutout 8 Tree 1 Private 1     29     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
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)
81053 88569 Significant Tree 6 Tree(s) :: 17 1335 Webster St 60 Front Yard : Cutout 8 Tree 1 Private 1   07/30/2008 12:00:00 AM     Permit Number 51511 6003187.0 2113215.0 37.782665577707796 -122.43264916888701 (37.7826655777078, -122.432649168887)
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)
82056 114939 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 15 Front Yard : Cutout 8 Tree 1 Private 1     36 3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
82154 114926 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 2 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
83219 108097 Significant Tree 6 Tree(s) :: 17 3370 Washington St 2 Front Yard : Cutout 8 Tree 1 Private 1           5998663.3699 2115944.3199400003 37.789901994506 -122.44849555223101 (37.789901994506, -122.448495552231)
83931 105169 Property Tree 7 Corymbia ficifolia :: Red Flowering Gum 60 4755X 03RD ST 3 Front Yard : Cutout 8 Tree 1 Arts Commission 19     23 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679)
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)
84743 116631 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 12 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
85042 106874 Significant Tree 6 Pittosporum undulatum :: Victorian Box 26 38 08th St 5 Front Yard : Cutout 8 Tree 1 Private 1         Permit Number 769156 6008506.93846 2111466.3623599997 37.7781645006636 -122.41412064163201 (37.7781645006636, -122.414120641632)
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)
85143 115005 Private 5 Prunus cerasifera :: Cherry Plum 16 1050 MCALLISTER ST 2 Front Yard : Cutout 8 Tree 1 Office of Mayor 21 DPW 4     3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
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)
85808 98327 Permitted Site 1 Acacia spp :: Acacia Spp 176 143 Alhambra St 2 Front Yard : Cutout 8 Tree 1 Private 1   03/27/2007 12:00:00 AM   4x6 Permit Number 49254 6001613.1 2120268.4 37.8019430002039 -122.43859972925199 (37.8019430002039, -122.438599729252)
86072 54809 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 150 Carmel St 2 Front Yard : Cutout 8 Tree 1 Private 1   03/12/2007 12:00:00 AM 5 3x3 Permit Number 773425 5998092.51354995 2105385.25255364 37.760876867329294 -122.449709427273 (37.7608768673293, -122.449709427273)
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)
86717 108022 Significant Tree 6 Grevillea robusta :: Silk Oak Tree 145 455X Ivy St 2 Front Yard : Cutout 8 Tree 1 Private 1           6005179.30837 2111099.83336 37.776970634543 -122.42560603936 (37.776970634543, -122.42560603936)
86718 114261 Undocumented 2 Pinus radiata :: Monterey Pine 3 800x BROTHERHOOD WAY 2 Front Yard : Cutout 8 Tree 1 Private 1     36     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
86948 106872 Significant Tree 6 Pittosporum undulatum :: Victorian Box 26 38 08th St 3 Front Yard : Cutout 8 Tree 1 Private 1   07/31/2014 12:00:00 AM     Permit Number 769156 6008506.93846 2111466.3623599997 37.7781645006636 -122.41412064163201 (37.7781645006636, -122.414120641632)
87119 112572 Significant Tree 6 Cordyline australis :: Dracena Palm 141 162 GRAND VIEW AVE 4 Front Yard : Cutout 8 Tree 1 Private 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
87235 117162 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1383X VERMONT ST 2 Front Yard : Cutout 8 Tree 1 Private 1 DPW 4         6011571.0 2102081.0 37.752566033842896 -122.40286062573799 (37.7525660338429, -122.402860625738)
88034 111070 Significant Tree 6 Prunus cerasifera :: Cherry Plum 16 1836 08TH AVE 2 Front Yard : Cutout 8 Tree 1 Private 1     2 3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175)
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)

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