home / trees

Street_Tree_List

Data source: data.sfgov.org

191,550 rows sorted by qSiteInfo

View and edit SQL

Suggested facets: qLegalStatus, qCaretaker, qCareAssistant

PlantType

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
1 1 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 10 10th Ave 1 Median : Cutout 1 Tree 1 DPW 1     3 16   5992719.40718 2114869.71245 37.7866097734767 -122.46898271049601 (37.7866097734767, -122.468982710496) 11 6 1 54 11
2 10 DPW Maintained 1 Palm (unknown Genus) :: Palm Spp 2 97 12th St 4 Median : Cutout 1 Tree 1 DPW 1     20 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651) 8 2 9 28853 19
483 100535 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2050X Market St 5 Median : Cutout 1 Tree 1 DPW 1     36 8   6004529.3 2108103.5 37.7687066827543 -122.427641088373 (37.7687066827543, -122.427641088373) 7 4 5 28862 3
484 100536 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2050X Market St 6 Median : Cutout 1 Tree 1 DPW 1     36 8   6004529.3 2108103.5 37.7687066827543 -122.427641088373 (37.7687066827543, -122.427641088373) 7 4 5 28862 3
485 100537 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2010X Market St 1 Median : Cutout 1 Tree 1 DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
486 100538 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2010X Market St 2 Median : Cutout 1 Tree 1 DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
487 100539 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2010X Market St 3 Median : Cutout 1 Tree 1 DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
489 100540 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 2010X Market St 4 Median : Cutout 1 Tree 1 DPW 1     36 8   6004815.4 2108376.1 37.7694713555808 -122.426670904591 (37.7694713555808, -122.426670904591) 7 4 5 28862 3
918 101064 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 380X Beacon St 2 Median : Cutout 1 Tree 1 DPW 1     3 3x3   6002433.0 2098186.8 37.7413589965156 -122.43418299753701 (37.7413589965156, -122.434182997537) 2 7 5 63 7
919 101065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 380X Beacon St 1 Median : Cutout 1 Tree 1 DPW 1     3 3x3   6002433.0 2098186.8 37.7413589965156 -122.43418299753701 (37.7413589965156, -122.434182997537) 2 7 5 63 7
1464 101655 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 200X Vasquez Ave 2 Median : Cutout 1 Tree 1 DPW 1     6 8   5994672.4771300005 2099264.801 37.7438754024487 -122.461094099214 (37.7438754024487, -122.461094099214) 1 8 4 59 40
1465 101656 DPW Maintained 1 Malus sylvestris :: Apple 141 200X Vasquez Ave 3 Median : Cutout 1 Tree 1 DPW 1     6 8   5994672.4771300005 2099264.801 37.7438754024487 -122.461094099214 (37.7438754024487, -122.461094099214) 1 8 4 59 40
1981 102267 DPW Maintained 1 Shrub :: Shrub 47 100X Casitas Ave 1 Median : Cutout 1 Tree 1 DPW 1     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
1982 102268 DPW Maintained 1 Shrub :: Shrub 47 100X Casitas Ave 2 Median : Cutout 1 Tree 1 DPW 1     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
1983 102269 DPW Maintained 1 Eucalyptus lehmanni :: Bushy Yate 163 100X Casitas Ave 3 Median : Cutout 1 Tree 1 DPW 1     8 6x10   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
1985 102270 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 100X Casitas Ave 4 Median : Cutout 1 Tree 1 DPW 1     12 6x100   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
1986 102271 DPW Maintained 1 Eucalyptus lehmanni :: Bushy Yate 163 100X Casitas Ave 5 Median : Cutout 1 Tree 1 DPW 1     8 6x200   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
1987 102272 DPW Maintained 1 Eucalyptus lehmanni :: Bushy Yate 163 100X Casitas Ave 6 Median : Cutout 1 Tree 1 DPW 1     8 6x70   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
1988 102273 DPW Maintained 1 Cordyline australis :: Dracena Palm 82 100X Casitas Ave 7 Median : Cutout 1 Tree 1 DPW 1     12 6x14   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
2276 102575 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 2X Drumm St 1 Median : Cutout 1 Tree 1 DPW 1         Permit Number 769964 6013786.1 2116863.1 37.7932777999137 -122.396236306259 (37.7932777999137, -122.396236306259) 12 2 9 28855 6
2277 102576 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 2X Drumm St 2 Median : Cutout 1 Tree 1 DPW 1         Permit Number 769964 6013786.1 2116863.1 37.7932777999137 -122.396236306259 (37.7932777999137, -122.396236306259) 12 2 9 28855 6
2278 102577 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 2X Drumm St 3 Median : Cutout 1 Tree 1 DPW 1   03/12/2013 12:00:00 AM     Permit Number 769964 6013786.1 2116863.1 37.7932777999137 -122.396236306259 (37.7932777999137, -122.396236306259) 12 2 9 28855 6
2279 102578 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 2X Drumm St 4 Median : Cutout 1 Tree 1 DPW 1   03/12/2013 12:00:00 AM     Permit Number 769964 6013786.1 2116863.1 37.7932777999137 -122.396236306259 (37.7932777999137, -122.396236306259) 12 2 9 28855 6
2280 102579 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 2X Drumm St 5 Median : Cutout 1 Tree 1 DPW 1   03/12/2013 12:00:00 AM     Permit Number 769964 6013786.1 2116863.1 37.7932777999137 -122.396236306259 (37.7932777999137, -122.396236306259) 12 2 9 28855 6
2281 102580 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 2X Drumm St 6 Median : Cutout 1 Tree 1 DPW 1   03/12/2013 12:00:00 AM     Permit Number 769964 6013786.1 2116863.1 37.7932777999137 -122.396236306259 (37.7932777999137, -122.396236306259) 12 2 9 28855 6
2282 102581 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 2X Drumm St 7 Median : Cutout 1 Tree 1 DPW 1         Permit Number 769964 6013786.1 2116863.1 37.7932777999137 -122.396236306259 (37.7932777999137, -122.396236306259) 12 2 9 28855 6
2283 102582 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 2X Drumm St 8 Median : Cutout 1 Tree 1 DPW 1         Permit Number 769964 6013786.1 2116863.1 37.7932777999137 -122.396236306259 (37.7932777999137, -122.396236306259) 12 2 9 28855 6
3048 103414 Permitted Site 2 Quercus agrifolia :: Coast Live Oak 129 1490X Plymouth Ave 1 Median : Cutout 1 Tree 1 Private 2   04/18/2013 12:00:00 AM     Permit Number 770026 5995919.3 2094026.5 37.7295639775589 -122.456404198854 (37.7295639775589, -122.456404198854) 9 7 4 28861 40
3551 103927 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 83 100 The Embarcadero 13 Median : Cutout 1 Tree 1 DPW 1   02/05/2001 12:00:00 AM   4x4   6014859.0 2117030.0 37.793795709183996 -122.392535650186 (37.793795709184, -122.392535650186) 12 2 10 28855 6
4206 104734 Undocumented 3 Schinus terebinthifolius :: Brazilian Pepper 121 5490x 03RD ST 1 Median : Cutout 1 Tree 1 DPW 1     40 9x9   6014203.0 2093127.0 37.7281268221954 -122.39313217573601 (37.7281268221954, -122.393132175736) 10 3 8 58 1
4258 104785 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 750 Holly Park Cir 1 Median : Cutout 1 Tree 1 DPW 1   12/21/2014 11:00:00 PM 3 2x2   6006276.6738599995 2096799.83163 37.7377680961975 -122.42079445065201 (37.7377680961975, -122.420794450652) 2 7 7 28859 2
4259 104786 DPW Maintained 1 Tree(s) :: 13 750 Holly Park Cir 2 Median : Cutout 1 Tree 1 DPW 1       2x2   6006276.6738599995 2096799.83163 37.7377680961975 -122.42079445065201 (37.7377680961975, -122.420794450652) 2 7 7 28859 2
4300 104834 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 1202X Arguello Blvd 1 Median : Cutout 1 Tree 1 DPW 1   05/27/2014 12:00:00 AM 1 1x4   5995869.9 2107172.9 37.7656578771265 -122.45752575958599 (37.7656578771265, -122.457525759586) 15 5 11 29492 12
4451 104999 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 180X SAN MARCOS AVE 5 Median : Cutout 1 Tree 1 DPW 1     42     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338) 1 8 4 29491 40
4454 105000 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 280X SAN MARCOS AVE 1 Median : Cutout 1 Tree 1 DPW 1     65   Tree tag no. 416 5993063.2 2100277.9 37.7465643757171 -122.466732187112 (37.7465643757171, -122.466732187112) 1 8 4 29491 40
4629 105235 Undocumented 3 Acacia baileyana :: Bailey's Acacia 156 182X LOWER TER 27 Median : Cutout 1 Tree 1 Private 2     24 200x30   6000081.0 2106216.0 37.763271458828704 -122.442891809215 (37.7632714588287, -122.442891809215) 15 5 5 28862 3
5180 105889 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 2150X 09TH AVE 11 Median : Cutout 1 Tree 1 Private 2   03/21/2014 12:00:00 AM 40     5993666.0 2101247.0 37.7492600480712 -122.46471814740102 (37.7492600480712, -122.464718147401) 1 8 4 29491 40
5322 106081 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 398X KIRKHAM ST 1 Median : Cutout 1 Tree 1 DPW 1     3 4x12   5993829.0 2105294.0 37.760381465230395 -122.46444829698 (37.7603814652304, -122.46444829698) 1 8 11 56 12
5488 106278 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 200X VIDAL DR 2 Median : Cutout 1 Tree 1 DPW 1     60     5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298) 1 8 4 64 14
5522 106329 DPW Maintained 1 Prunus subhirtella 'Pendula' :: Weeping Cherry 169 600X Webster St 1 Median : Cutout 1 Tree 1 DPW 1     9 12x30   6004014.02744 2111067.07552 37.7768147769105 -122.429634767527 (37.7768147769105, -122.429634767527) 7 9 11 28852 10
5537 106344 Permitted Site 2 Agonis flexuosa :: Peppermint Willow 102 2428 14th Ave 1 Median : Cutout 1 Tree 1 Private 2   04/18/2014 12:00:00 AM   3x3   5992079.0 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922) 1 8 4 29491 40
5538 106345 Permitted Site 2 Agonis flexuosa :: Peppermint Willow 102 2428 14th Ave 2 Median : Cutout 1 Tree 1 Private 2   04/18/2014 12:00:00 AM   3x3   5992079.0 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922) 1 8 4 29491 40
5566 106374 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 1 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5567 106375 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 2 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5568 106376 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 3 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5569 106377 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 4 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5570 106378 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 5 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5571 106379 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 6 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5572 106380 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 7 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5573 106381 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 8 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5574 106382 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 9 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5575 106383 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 10 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5576 106384 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 11 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5577 106385 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 12 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5578 106386 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 13 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5579 106387 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 14 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5580 106388 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 15 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5581 106389 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 16 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5583 106390 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 17 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5584 106391 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 18 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5585 106392 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 19 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5586 106393 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 20 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5587 106394 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 21 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5588 106395 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 22 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5589 106396 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 23 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5590 106397 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 24 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5591 106398 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 25 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5592 106399 DPW Maintained 1 Tree(s) :: 13 182x Lower Ter 26 Median : Cutout 1 Tree 1 DPW 1       10x10   6000081.12192 2106216.81045 37.763273691074204 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
5641 106462 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 114 3500X MISSION ST 2 Median : Cutout 1 Tree 1 DPW 1     36     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716) 2 7 7 28859 2
5642 106463 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 114 3500X MISSION ST 3 Median : Cutout 1 Tree 1 DPW 1     28     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716) 2 7 7 28859 2
5643 106464 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 114 3500X MISSION ST 5 Median : Cutout 1 Tree 1 DPW 1     28     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716) 2 7 7 28859 2
5645 106466 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 114 3500X MISSION ST 6 Median : Cutout 1 Tree 1 DPW 1     26     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716) 2 7 7 28859 2
5718 106550 DPW Maintained 1 Pinus Spp :: Pine Spp 89 81 MINERVA ST   Median : Cutout 1 Tree 1 DPW 1           5996079.6 2088963.3 37.7156708325413 -122.455484227095 (37.7156708325413, -122.455484227095) 9 8 6 28861 24
5742 106577 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 114 1001X SAN JOSE AVE 1 Median : Cutout 1 Tree 1 DPW 1     10     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
5776 106625 DPW Maintained 1 Myoporum laetum :: Myoporum 27 500X 27TH ST 7 Median : Cutout 1 Tree 1 DPW 1     8 5x400   6003184.0 2100084.0 37.7466108627938 -122.431721727073 (37.7466108627938, -122.431721727073) 2 7 5 63 22
5889 106792 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 206 199X ARLINGTON ST 1 Median : Cutout 1 Tree 1 DPW 1     15     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639) 2 7 5 63 7
5890 106793 DPW Maintained 1 Eucalyptus camaldulensis :: River Red Gum 245 199X ARLINGTON ST 49 Median : Cutout 1 Tree 1 DPW 1     9     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639) 2 7 5 63 7
5891 106794 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 206 199X ARLINGTON ST 51 Median : Cutout 1 Tree 1 DPW 1     18     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639) 2 7 5 63 7
5892 106795 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 206 199X ARLINGTON ST 55 Median : Cutout 1 Tree 1 DPW 1     12     6005045.0 2097131.0 37.7386079110333 -122.425076502639 (37.7386079110333, -122.425076502639) 2 7 5 63 7
5907 106810 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 206 3500X MISSION ST 10 Median : Cutout 1 Tree 1 DPW 1     11     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716) 2 7 7 28859 2
5908 106811 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 206 3500X MISSION ST 17 Median : Cutout 1 Tree 1 DPW 1     20     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716) 2 7 7 28859 2
5952 106878 Undocumented 3 Pinus radiata :: Monterey Pine 1 180X SAN MARCOS AVE 1 Median : Cutout 1 Tree 1 Private 2 DPW 3   26     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338) 1 8 4 29491 40
5953 106879 Undocumented 3 Albizia julibrissin :: Mimosa Silk Tree 248 180X SAN MARCOS AVE 2 Median : Cutout 1 Tree 1 Private 2 DPW 3   6     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338) 1 8 4 29491 40
5955 106880 Undocumented 3 Ulmus pumila :: Siberian Elm 31 180X SAN MARCOS AVE 3 Median : Cutout 1 Tree 1 Private 2 DPW 3   5     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338) 1 8 4 29491 40
5958 106883 Undocumented 3 Ulmus pumila :: Siberian Elm 31 180X SAN MARCOS AVE 4 Median : Cutout 1 Tree 1 Private 2 DPW 3   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338) 1 8 4 29491 40
5959 106884 Undocumented 3 Ulmus pumila :: Siberian Elm 31 180X SAN MARCOS AVE 6 Median : Cutout 1 Tree 1 Private 2 DPW 3   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338) 1 8 4 29491 40
6154 107116 DPW Maintained 1 Tree(s) :: 13 300X LIBERTY ST 18 Median : Cutout 1 Tree 1 DPW 1     12     6004270.1 2103982.4 37.757376462852704 -122.42824389606199 (37.7573764628527, -122.428243896062) 2 4 5 28862 3
6155 107117 DPW Maintained 1 Pseudotsuga menziesii :: Douglas Fir 205 300X LIBERTY ST 17 Median : Cutout 1 Tree 1 DPW 1     18     6004270.1 2103982.4 37.757376462852704 -122.42824389606199 (37.7573764628527, -122.428243896062) 2 4 5 28862 3
6172 107140 Permitted Site 2 Olea europaea 'Fruitless' :: Fruitless Olive 14 250X Roosevelt Way   Median : Cutout 1 Tree 1 Private 2   08/01/2014 12:00:00 AM   5x5 Permit Number 773751 6000794.71275 2107196.95489 37.766005582708395 -122.440493678393 (37.7660055827084, -122.440493678393) 15 5 5 29492 3
6251 107239 DPW Maintained 1 Salix babylonica :: Weeping Willow 254 300x Liberty St 27 Median : Cutout 1 Tree 1 DPW 1     27     6004353.0 2103966.0 37.7573361226439 -122.42795602638 (37.7573361226439, -122.42795602638) 2 4 5 28862 3
6321 107319 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 530X JUNIPERO SERRA BLVD 1 Median : Cutout 1 Tree 1 DPW 1     27     5991365.2 2093720.0 37.728459908419 -122.47212570206699 (37.728459908419, -122.472125702067) 9 8 4 64 40
6323 107320 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 600X JUNIPERO SERRA BLVD 1 Median : Cutout 1 Tree 1 DPW 1   03/31/2015 12:47:00 PM 3     5991349.3 2093478.1 37.7277947912967 -122.472163043281 (37.7277947912967, -122.472163043281) 9 8 4 64 40
6324 107321 DPW Maintained 1 Pinus Spp :: Pine Spp 89 400X JUNIPERO SERRA BLVD 4 Median : Cutout 1 Tree 1 DPW 1     14     5991395.0 2094254.0 37.729927863300794 -122.47206158934999 (37.7299278633008, -122.47206158935) 9 8 4 64 40
6336 107347 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1126X PORTOLA DR 1 Median : Cutout 1 Tree 1 DPW 1     68     5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341) 1 8 4 59 40
6453 107481 DPW Maintained 1 Phoenix dactylifera :: Date Palm 253 1300x Montgomery St 1 Median : Cutout 1 Tree 1 DPW 1           6011490.9987699995 2119741.7952799997 37.801054029046504 -122.404380271142 (37.8010540290465, -122.404380271142) 3 1 10 308 23
6454 107482 DPW Maintained 1 Olea europaea :: Olive Tree 42 1306x Montgomery St 4 Median : Cutout 1 Tree 1 DPW 1     5     6011457.97806 2119852.64786 37.801356557918794 -122.404502345126 (37.8013565579188, -122.404502345126) 3 1 10 308 23
6455 107483 DPW Maintained 1 Ulmus pumila :: Siberian Elm 31 1306x Montgomery St 6 Median : Cutout 1 Tree 1 DPW 1     17     6011458.52251 2119859.64432 37.8013757989196 -122.404500953851 (37.8013757989196, -122.404500953851) 3 1 10 308 23
6456 107485 DPW Maintained 1 Olea europaea :: Olive Tree 42 1306x Montgomery St 7 Median : Cutout 1 Tree 1 DPW 1     5     6011457.45538 2119866.47345 37.8013944904094 -122.40450512760401 (37.8013944904094, -122.404505127604) 3 1 10 308 23
6457 107486 DPW Maintained 1 Olea europaea :: Olive Tree 42 1306x Montgomery St 8 Median : Cutout 1 Tree 1 DPW 1     9     6011455.57226 2119886.9035799997 37.8014504813279 -122.404513083014 (37.8014504813279, -122.404513083014) 3 1 10 308 23
6458 107487 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 98 1306x Montgomery St 12 Median : Cutout 1 Tree 1 DPW 1     23     6011454.1798 2119912.99001 37.801522030487 -122.40451973891001 (37.801522030487, -122.40451973891) 3 1 10 308 23

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 323.724ms · Data source: data.sfgov.org