Street_Tree_List

Data source: data.sfgov.org

120 rows where qLegalStatus = 6 and qSiteInfo = 5 sorted by YCoord

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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
139320 94936 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)
144144 94944 Significant Tree 6 Pyrus pyrifolia 'Sainseiki' :: Asian Pear 'Sainseiki' 540 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)
144883 94942 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)
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)
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)
141804 96996 Significant Tree 6 Malus :: Crab Apple 235 2451X Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
143629 96998 Significant Tree 6 Prunus spp :: Cherry 84 2451X Griffith St   Sidewalk: Property side : Cutout 5 Tree 1 Housing Authority 20 FUF 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
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)
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)
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)
140792 94868 Significant Tree 6 Trachycarpus fortunei :: Windmill Palm 31 51 Princeton St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
138508 96480 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)
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)
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)
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)
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)
126456 116577 Significant Tree 6 Shrub :: Shrub 98 3000x 19TH AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
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)
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)
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)
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)
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)
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)
145258 96222 Significant Tree 6 Tree(s) :: 17 176 Holladay Ave 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   05/18/2011 12:00:00 AM 18 3x3 Permit Number 767739 6010842.9 2100101.6 37.7470903528282 -122.405239158587 (37.7470903528282, -122.405239158587)
140837 105857 Significant Tree 6 Juniperus chinensis :: Juniper 19 1500X Valencia St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6006259.2 2100711.5 37.7485076710609 -122.42113253995599 (37.7485076710609, -122.421132539956)
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)
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)
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)
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)
142282 96784 Significant Tree 6 Acer palmatum :: Japanese Maple 175 615 Rhode Island St   Sidewalk: Property side : Cutout 5 Tree 1 Private 1   07/19/2011 12:00:00 AM     Permit Number 767987 6011854.6 2105476.9 37.7619062576766 -122.40211860576099 (37.7619062576766, -122.402118605761)
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)
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)
145280 99376 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 177 1088 Ashbury St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1         Permit Number 768767 5998994.0 2106195.0 37.7631517661679 -122.44664985791401 (37.7631517661679, -122.446649857914)
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)
140157 6099 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 40 500X 08th St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     18 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
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)
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)
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)
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)
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)
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)
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)
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)
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)
126401 113639 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 1X Russ St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6009949.394180001 2111947.85897 37.7795674908256 -122.40916462626801 (37.7795674908256, -122.409164626268)
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)
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)
142453 113641 Significant Tree 6 Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 545X Minna St 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1           6010081.18772 2112137.85468 37.7800965567953 -122.40872210131901 (37.7800965567953, -122.408722101319)
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)
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)
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)
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)

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