Street_Tree_List

Data source: data.sfgov.org

120 rows where qLegalStatus = 6 and qSiteInfo = 5

View and edit SQL

Suggested facets: SiteOrder, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes

qSiteInfo

  • Sidewalk: Property side : Cutout · 120
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
114 251216 Significant Tree 6 Myoporum laetum :: Myoporum 1 399X Townsend St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
118 251217 Significant Tree 6 Myoporum laetum :: Myoporum 1 399X Townsend St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
1935 252836 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 98 Prosper St 4 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
4673 253651 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 60 131 Font Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
4916 251372 Significant Tree 6 Cedrus deodara :: Deodar Cedar 129 1526 Masonic Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   11/01/2017 12:00:00 AM 3 3x3 Permit Number 779800 5999767.0 2107205.0 37.7659690994291 -122.44404889486401 (37.7659690994291, -122.444048894864)
8131 112367 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 5 2770 Broadway 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   07/23/2015 12:00:00 AM 3 3x3 Permit Number 774944 6000432.434780001 2117179.73451 37.7933951089516 -122.442463497617 (37.7933951089516, -122.442463497617)
9444 173598 Significant Tree 6 Casuarina cunninghamiana :: Horsetail pine 123 1771 11th Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     12 3x3   5992768.0 2103420.0 37.7551747322674 -122.467981458634 (37.7551747322674, -122.467981458634)
9683 173631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 99X Everglade Dr 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5986361.0 2095495.0 37.733042731061104 -122.48955570953301 (37.7330427310611, -122.489555709533)
9684 173630 Significant Tree 6 Myoporum laetum :: Myoporum 1 2699x OCEAN AVE 2 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
9726 173663 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 82 3878 17th St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6003109.0 2105964.0 37.7627516946294 -122.432400964417 (37.7627516946294, -122.432400964417)
9985 120925 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 8 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9986 1263 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   12/02/1998 12:00:00 AM 10 3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9994 120923 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 6 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9998 120931 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 14 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
9999 120922 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10006 120927 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 10 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10015 120928 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 11 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10019 173629 Significant Tree 6 Tibochina urvilleana :: Princess Flower 260 10X Junipero Serra Blvd Off Ramp 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   01/20/2017 12:00:00 AM 3 3x3 Permit Number 779383 5991168.0 2088425.0 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074)
10021 120935 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 18 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3 Permit Number 778829 5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
10627 1283 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 44 3995X Alemany Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     10 10x10   5992081.50866 2087171.0422099999 37.710519496741206 -122.469172961285 (37.7105194967412, -122.469172961285)
11052 1284 Significant Tree 6 Acer buergeranum :: Trident Maple 120 3995X Alemany Blvd 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     12 3X10 Permit Number 778829 5992111.480830001 2087185.8440900003 37.7105618710011 -122.469070448459 (37.7105618710011, -122.469070448459)
19027 97174 Significant Tree 6 Tristaniopsis laurina :: Swamp Myrtle 37 26 Gilbert St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
19054 94934 Significant Tree 6 Ficus carica 'Black Mission' :: Black Mission Fig 311 2451X Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
19699 113640 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 545X Minna St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6010081.18772 2112137.85468 37.7800965567953 -122.40872210131901 (37.7800965567953, -122.408722101319)
22894 206842 Significant Tree 6 Tree(s) :: 17 218 Sadowa St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994803.1874 2087784.4983 37.712360795684 -122.45981072288001 (37.712360795684, -122.45981072288)
22897 215094 Significant Tree 6 Tree(s) :: 17 218 Sadowa St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.2030900002 37.7123610457095 -122.45974695827199 (37.7123610457095, -122.459746958272)
28447 116579 Significant Tree 6 Shrub :: Shrub 98 3000x 19TH AVE 2 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
45605 119614 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 2X Sutter St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6012582.0 2115890.0 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916)
49634 112391 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 40 2201X LYON ST 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x12   5999307.0 2116423.0 37.7912531030346 -122.446303107227 (37.7912531030346, -122.446303107227)
50102 94943 Significant Tree 6 Pyrus pyrifolia '20th Century' :: Asian Pear '20th Century' 417 2525 Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
58967 96572 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
66608 113772 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 21 2550 Broadway 4 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     4     6001375.31674 2117310.7972 37.793808671186106 -122.439210462719 (37.7938086711861, -122.439210462719)
66846 112874 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 21 2636 Vallejo St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   08/25/2015 12:00:00 AM 13 3x3 Permit Number 776037 6000935.48392 2117605.97258 37.794594107573104 -122.440753504176 (37.7945941075731, -122.440753504176)
74397 120924 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 7 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
79421 120930 Significant Tree 6 Pinus radiata :: Monterey Pine 3 3995X Alemany Blvd 13 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
80235 96569 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
81067 113358 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 116 702 Foerster St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5998153.40008835 2095558.62470631 37.733898832504295 -122.448791034412 (37.7338988325043, -122.448791034412)
81078 94935 Significant Tree 6 Ficus carica 'Brown Turkey' :: Brown Turkey Fig 469 2451X Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
81160 96570 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
81453 114249 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 40 499x 24TH AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5988415.0 2112957.0 37.78110836988721 -122.483734439284 (37.7811083698872, -122.483734439284)
82320 113769 Significant Tree 6 Tree(s) :: 17 2550 Broadway 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6001418.65940389 2117313.19689891 37.7938177263924 -122.439060665499 (37.7938177263924, -122.439060665499)
82951 109969 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 44 1x DAVIS ST 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   08/28/2015 12:00:00 AM 18 3x3 Permit Number 774526 6013431.7 2116562.3 37.7924321476874 -122.397441457592 (37.7924321476874, -122.397441457592)
83253 98082 Significant Tree 6 Pinus Spp :: Pine Spp 105 525 Grafton Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5995193.7 2090526.9 37.7199132334677 -122.45865940878001 (37.7199132334677, -122.45865940878)
83393 92053 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 36 1001 Potrero Ave   Sidewalk: Property side : Cutout 5 Tree 1 Private 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
83580 92310 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2591 26th Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 10/18/2008 12:00:00 AM   3x3   5988279.0 2097698.2 37.7392039339278 -122.48308618722099 (37.7392039339278, -122.483086187221)
84297 121446 Significant Tree 6 Tree(s) :: 17 500 Terry A Francois Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6016102.0 2110410.0 37.775687633053 -122.38777260103399 (37.775687633053, -122.387772601034)
84748 120926 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 9 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
86280 113491 Significant Tree 6 Dodonaea viscosa :: Hop Bush 132 366x 07TH AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   12/07/2015 12:00:00 AM 6 3x3 Permit Number 776681 5993712.0 2113143.0 37.7819259902039 -122.465423128165 (37.7819259902039, -122.465423128165)
86907 96483 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
88058 94937 Significant Tree 6 Malus 'Gala' :: Apple Tree 'Gala' 498 2525 Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
88445 122634 Significant Tree 6 Tree(s) :: 17 3680X 19th Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   12/05/2016 12:00:00 AM 3 3x10 Permit Number 779220 5990592.0 2091224.0 37.7215617409212 -122.474616575991 (37.7215617409212, -122.474616575991)
93028 115827 Significant Tree 6 Myoporum laetum :: Myoporum 1 60X CHUMASERO DR 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   08/30/2016 12:00:00 AM 3 3x3 Permit Number 777531 5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
93623 94948 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Pomona St   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
93720 106927 Significant Tree 6 Podocarpus gracilor :: Fern Pine 13 4150 24th St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1       1.5X1.5 Permit Number 772519 6002207.56819 2101805.30097 37.7512817512061 -122.435221219626 (37.7512817512061, -122.435221219626)
93863 94301 Significant Tree 6 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 1150X Fillmore St 5 Sidewalk: Property side : Cutout 5 Tree 1 Rec/Park 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
96189 94940 Significant Tree 6 Morus alba :: White Mulberry 112 2525 Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
96557 107036 Significant Tree 6 Tree(s) :: 17 350 08th St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1   07/23/2014 12:00:00 AM   7x7 Permit Number 772214 6009826.0 2110084.0 37.774442857676505 -122.409459923405 (37.7744428576765, -122.409459923405)
97749 96481 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
99207 96568 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
99448 116072 Significant Tree 6 Juniperus chinensis :: Juniper 19 388 POLARIS WAY 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6000586.0 2086414.0 37.70892857908329 -122.439725431133 (37.7089285790833, -122.439725431133)
100317 113359 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 116 702 Foerster St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           5998153.40008835 2095558.62470631 37.733898832504295 -122.448791034412 (37.7338988325043, -122.448791034412)
100341 120932 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 15 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
100450 107818 Significant Tree 6 Ficus Spp. :: 253 474 Oak St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   6004715.2 2110227.8 37.7745500089947 -122.42714940503201 (37.7745500089947, -122.427149405032)
101102 96484 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 180 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
101234 94303 Significant Tree 6 Ficus nitida :: Laurel Fig 43 1150X Fillmore St 6 Sidewalk: Property side : Cutout 5 Tree 1 Rec/Park 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
102570 94295 Significant Tree 6 Ficus nitida :: Laurel Fig 43 1150X Fillmore St 2 Sidewalk: Property side : Cutout 5 Tree 1 Rec/Park 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
102660 85090 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 82 1600 Chestnut St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
102854 113637 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 1X Russ St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6009949.394180001 2111947.85897 37.7795674908256 -122.40916462626801 (37.7795674908256, -122.409164626268)
102912 119613 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 2X Sutter St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     12 3x3   6012582.0 2115890.0 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916)
103034 96485 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 180 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
103824 94947 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Pomona St   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
103966 94293 Significant Tree 6 Ficus nitida :: Laurel Fig 43 1150X Fillmore St 1 Sidewalk: Property side : Cutout 5 Tree 1 Rec/Park 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
105747 113638 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 1X Russ St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6009949.394180001 2111947.85897 37.7795674908256 -122.40916462626801 (37.7795674908256, -122.409164626268)
107857 94299 Significant Tree 6 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 1150X Fillmore St 4 Sidewalk: Property side : Cutout 5 Tree 1 Rec/Park 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
108754 104003 Significant Tree 6 Acer palmatum 'Sango Kaku' :: Coral Bark Maple 518 2109 Steiner St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   07/17/2013 12:00:00 AM     Permit Number 767176 6002333.5 2115633.4 37.789257448084605 -122.435774995524 (37.7892574480846, -122.435774995524)
109217 96482 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
110151 107080 Significant Tree 6 Magnolia x soulangiana :: Saucer Magnolia 92 401X TOWNSEND ST 8 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     14 2x30   6013045.0 2110022.0 37.774452457479 -122.398320364295 (37.774452457479, -122.398320364295)
110771 109970 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 44 1x DAVIS ST 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   08/28/2015 12:00:00 AM   3x3 Permit Number 774526 6013431.7 2116562.3 37.7924321476874 -122.397441457592 (37.7924321476874, -122.397441457592)
110973 106962 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 218 SADOWA ST 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     22     5994814.0 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106)
111560 94941 Significant Tree 6 Morus alba :: White Mulberry 112 2525 Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
111731 122636 Significant Tree 6 Juniperus chinensis :: Juniper 19 3698X 19th Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5990586.0 2091171.0 37.7214158684235 -122.474633449984 (37.7214158684235, -122.474633449984)
111884 94939 Significant Tree 6 Morus alba :: White Mulberry 112 2525 Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
112975 94938 Significant Tree 6 Malus 'Gala' :: Apple Tree 'Gala' 498 2525 Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
113578 96571 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
114698 94946 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 50 Pomona St   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
114895 116578 Significant Tree 6 Myoporum laetum :: Myoporum 1 2699x OCEAN AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
115088 117438 Significant Tree 6 Juniperus chinensis :: Juniper 19 230 AMBER DR 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     25 3X3   5999593.0 2099199.0 37.7439766577846 -122.444075405191 (37.7439766577846, -122.444075405191)
115407 120934 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 17 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
116287 120933 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 16 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
117763 110393 Significant Tree 6 Juniperus chinensis :: Juniper 19 451 LOS PALMOS DR 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x8   5997298.0 2095759.0 37.7344000615683 -122.45176284684601 (37.7344000615683, -122.451762846846)
118149 120936 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 19 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
118530 104452 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1045 Mission St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       2x6 Permit Number 770594 6009749.9 2112056.4 37.7798543407434 -122.40986242910299 (37.7798543407434, -122.409862429103)
119867 120929 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 12 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
120634 116580 Significant Tree 6 Shrub :: Shrub 98 3000x 19TH AVE 3 Sidewalk: Property side : Cutout 5 Landscaping 2 MTA 6 DPW 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
120702 97175 Significant Tree 6 Tristaniopsis laurina :: Swamp Myrtle 37 26 Gilbert St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
120789 120921 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 3995X Alemany Blvd 4 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
123205 94297 Significant Tree 6 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 1150X Fillmore St 3 Sidewalk: Property side : Cutout 5 Tree 1 Rec/Park 3           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
123251 92054 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 36 1001 Potrero Ave   Sidewalk: Property side : Cutout 5 Tree 1 Private 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
124197 96567 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
125168 85089 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 82 1600 Chestnut St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)

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