Street_Tree_List

Data source: data.sfgov.org

237 rows where qSiteInfo = 8 sorted by Longitude

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
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)
140914 114321 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2118 47th Ave 1 Front Yard : Cutout 8 Landscaping 2 Private 1   01/14/2016 12:00:00 AM   5x16 Permit Number 777356 5981743.9 2100646.6 37.7469169691931 -122.505899765145 (37.7469169691931, -122.505899765145)
102290 31648 Permitted Site 1 Tree(s) :: 17 4500 Ulloa St 3 Front Yard : Cutout 8 Tree 1 Private 1   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106)
113764 31646 Permitted Site 1 Tree(s) :: 17 4500 Ulloa St 2 Front Yard : Cutout 8 Tree 1 Private 1   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106)
127767 31647 Permitted Site 1 Tree(s) :: 17 4500 Ulloa St 4 Front Yard : Cutout 8 Tree 1 Private 1   02/13/2009 12:00:00 AM   3x3 Permit Number 52054 5982086.63822537 2098111.49533937 37.7399764418309 -122.504526837106 (37.7399764418309, -122.504526837106)
129398 109973 Undocumented 2 Tree(s) :: 17 1458 43rd Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   03/16/2015 12:00:00 AM 3 3x3   5982831.2 2105195.6 37.7594711884194 -122.502476670215 (37.7594711884194, -122.502476670215)
148125 79257 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 571 35th Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   12/06/2007 12:00:00 AM 11 3x3 Permit Number 49957 5985010.61242 2111991.22713 37.7782578784089 -122.495440495889 (37.7782578784089, -122.495440495889)
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)
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)
125647 85060 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 7070 California St 1 Front Yard : Cutout 8 Tree 1 Private 1   07/03/2007 12:00:00 AM     Permit Number 49405 5985878.0 2113896.0 37.7835385880022 -122.49258024231199 (37.7835385880022, -122.492580242312)
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)
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)
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)
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)
91895 114933 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 9 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
100601 114931 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 7 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
100636 114940 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 16 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
102481 114925 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 4400x OCEAN AVE 3 Front Yard : Cutout 8 Tree 1 Private 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
103199 114934 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 4400x OCEAN AVE 10 Front Yard : Cutout 8 Tree 1 Private 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
103256 114928 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 4 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
106106 114937 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 13 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
139185 114938 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 14 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
140796 114929 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 5 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
141835 114936 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 12 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
141973 114935 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 11 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
144669 114930 Undocumented 2 Pinus radiata :: Monterey Pine 3 4400x OCEAN AVE 6 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
142230 120534 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2043 32nd Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   08/10/2016 12:00:00 AM 3 3x3   5986293.0 2101328.0 37.7490546230695 -122.49021972232599 (37.7490546230695, -122.490219722326)
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)
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)
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)
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)
122091 114098 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 219x VIDAL DR 1 Front Yard : Cutout 8 Tree 1 Private 1     40     5987664.0 2090565.0 37.719582202213104 -122.48468943736401 (37.7195822022131, -122.484689437364)
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)
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)
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)
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)
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)
96632 116628 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 9 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
98906 116629 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 10 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
111008 116626 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 5732X GEARY BLVD 7 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
113343 116624 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 5 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
119101 116621 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 2 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
123257 116622 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 3 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
124339 116630 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 11 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
125790 116627 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 8 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
142683 116623 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 4 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
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)
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)
96445 114266 Undocumented 2 Pittosporum spp :: Pittosporum spp 128 800x BROTHERHOOD WAY 7 Front Yard : Cutout 8 Tree 1 Private 1     9     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
101205 114262 Undocumented 2 Pinus radiata :: Monterey Pine 3 800x BROTHERHOOD WAY 3 Front Yard : Cutout 8 Tree 1 Private 1     36     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
118309 114264 Undocumented 2 Pinus radiata :: Monterey Pine 3 800x BROTHERHOOD WAY 5 Front Yard : Cutout 8 Tree 1 Private 1     32     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
123578 114260 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 800x BROTHERHOOD WAY 1 Front Yard : Cutout 8 Tree 1 Private 1     7     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
124433 114265 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 800x BROTHERHOOD WAY 6 Front Yard : Cutout 8 Tree 1 Private 1     26     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779)
119427 12711 Significant Tree 6 Tree(s) :: 17 1449 Lake St 3 Front Yard : Cutout 8 Tree 1 DPW 2   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046)
139135 112417 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 98X BROADMOOR DR 1 Front Yard : Cutout 8 Tree 1 Private 1     28 3x3   5990934.0 2093194.0 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435)
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)
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)
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)
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)
104090 87073 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 395 Byxbee St 4 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
106143 87075 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 395 Byxbee St 6 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
110241 87072 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 395 Byxbee St 3 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
111937 87074 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 395 Byxbee St 5 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
139591 87070 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 395 Byxbee St 1 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
143622 87071 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 395 Byxbee St 2 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
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)
128304 115100 Significant Tree 6 Tree(s) :: 17 710 PACHECO ST 1 Front Yard : Cutout 8 Tree 1 Private 1   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727.0 2102215.0 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741)
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)
143274 122379 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 466 Vernon St 1 Front Yard : Cutout 8 Tree 1 Private 1   10/26/2016 12:00:00 AM 3 3x3   5992521.0 2090937.0 37.7208852925782 -122.46792773796801 (37.7208852925782, -122.467927737968)
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)
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)
119287 85367 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1990 09th Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   08/17/2007 12:00:00 AM     Permit Number 49643 5993523.3 2101996.8 37.7513105791605 -122.46526605884199 (37.7513105791605, -122.465266058842)
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)
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)
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)
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)
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)
117945 104498 Permitted Site 1 Chionanthus retusa :: Chinese Fringe Tree 526 26 Allston Way 2 Front Yard : Cutout 8 Tree 1 Private 1   10/11/2013 12:00:00 AM   3x3 Permit Number 770732 5994373.7 2098352.0 37.741351881225704 -122.46206101169201 (37.7413518812257, -122.462061011692)
128374 104497 Permitted Site 1 Chionanthus retusa :: Chinese Fringe Tree 526 26 Allston Way 1 Front Yard : Cutout 8 Tree 1 Private 1   10/11/2013 12:00:00 AM   3x3 Permit Number 770732 5994373.7 2098352.0 37.741351881225704 -122.46206101169201 (37.7413518812257, -122.462061011692)
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)
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)
142320 82180 Private 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 105 Lake St 1 Front Yard : Cutout 8 Tree 1 Private 1 FUF 1     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.78679106496129 -122.46047184952101 (37.7867910649613, -122.460471849521)
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)
105928 109708 Significant Tree 6 Tree(s) :: 17 621 Laguna Honda Blvd 3 Front Yard : Cutout 8 Tree 1 Private 1 FUF 1 07/29/2015 12:00:00 AM     Permit Number 774799 5995723.9 2099907.4 37.745700269008296 -122.457505029341 (37.7457002690083, -122.457505029341)
127496 36443 Permitted Site 1 Tree(s) :: 17 1260 Plymouth Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   11/20/2009 12:00:00 AM   3x3 Permit Number 53041 5995883.45550893 2092448.59347632 37.725229366758 -122.456414062747 (37.725229366758, -122.456414062747)
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)
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)
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)
99011 115564 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 35 3524 Jackson St 2 Front Yard : Cutout 8 Tree 1 Private 1       5x10   5997387.02929021 2116081.37513577 37.790205252620794 -122.452921449726 (37.7902052526208, -122.452921449726)
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)
119856 85365 Significant Tree 6 Myoporum laetum :: Myoporum 1 66 Clarendon Ave 1 Front Yard : Cutout 8 Tree 1 Private 1   08/17/2007 12:00:00 AM     Permit Number 49641 5997837.8 2104660.2 37.758871479144396 -122.45053809231199 (37.7588714791444, -122.450538092312)
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)
139674 117208 Significant Tree 6 Pinus radiata :: Monterey Pine 3 25 MIDCREST WAY 1 Front Yard : Cutout 8 Tree 1 Private 1     20     5997992.0 2100464.0 37.747358577228496 -122.44970241305 (37.7473585772285, -122.44970241305)
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)
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)
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)
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)

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