Street_Tree_List

Data source: data.sfgov.org

575 rows where qSiteInfo = 13

View and edit SQL

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
427 251307 Undocumented 2 Tree(s) :: 17 200 Cashmere St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
433 251301 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Whitney Young Cir 2 Back Yard : Yard 13 Tree 1 Mayor Office of Housing 7       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
474 251300 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Whitney Young Cir 1 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
669 251343 Property Tree 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 934 Brannan St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
780 251383 Undocumented 2 Persea americana :: Avocado 113 49x Milan Ter 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997587.0 2087495.0 37.711725600519706 -122.450168218052 (37.7117256005197, -122.450168218052)
883 251306 Undocumented 2 Myoporum laetum :: Myoporum 1 1 Cashmere St 5 Back Yard : Yard 13 Tree 1 Private 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
885 251305 Undocumented 2 Myoporum laetum :: Myoporum 1 1 Cashmere St 4 Back Yard : Yard 13 Tree 1 Private 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
887 251303 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1 Cashmere St 2 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
891 251304 Undocumented 2 Myoporum laetum :: Myoporum 1 1 Cashmere St 3 Back Yard : Yard 13 Tree 1 Private 1 Health Dept 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
896 251302 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1 Cashmere St 1 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
1273 251481 Property Tree 7 Pinus radiata :: Monterey Pine 3 32 Peralta Ave 1 Back Yard : Yard 13 Tree 1 DPW 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
1305 251497 Undocumented 2 Tree(s) :: 17 329x Warren Dr 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5994610.0 2103362.0 37.7551216790189 -122.461607123764 (37.7551216790189, -122.461607123764)
1380 251512 Property Tree 7 Callistemon viminalis :: Weeping Bottlebrush 20 4116x 18th St 1 Back Yard : Yard 13 Tree 1 MTA 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
1384 251515 Significant Tree 6 Pinus radiata :: Monterey Pine 3 99x Mountview Ct 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1398 251517 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 145 Bonview St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6007188.0 2098162.0 37.7415596321362 -122.417740072125 (37.7415596321362, -122.417740072125)
1409 251514 Significant Tree 6 Pinus radiata :: Monterey Pine 3 99x Mountview Ct 2 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1598 251612 Significant Tree 6 Pinus radiata :: Monterey Pine 3 60R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1600 251625 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 76R Amber Dr 3 Back Yard : Yard 13 Tree 1 Private 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1603 251636 Significant Tree 6 Pinus radiata :: Monterey Pine 3 22R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1604 251632 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 14R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1605 251634 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 14R Amethyst Way 3 Back Yard : Yard 13 Tree 1 Private 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1607 251602 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 108 44R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1608 251603 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 44R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 251630 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1611 251605 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 108 48R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1613 251616 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 64R Amber Dr 3 Back Yard : Yard 13 Tree 1 Private 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1615 251604 Significant Tree 6 Pinus radiata :: Monterey Pine 3 48R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 251607 Significant Tree 6 Pinus radiata :: Monterey Pine 3 52R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1618 251611 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 4 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1619 251617 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 64R Amber Dr 4 Back Yard : Yard 13 Tree 1 Private 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1623 251613 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 60R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1624 251624 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 76R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1625 251623 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 76R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999293.0 2100015.0 37.746200078593205 -122.44517138727 (37.7462000785932, -122.44517138727)
1626 251635 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 18R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999176.0 2100050.0 37.746289501198795 -122.445578473632 (37.7462895011988, -122.445578473632)
1628 251629 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1629 251631 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 3 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1631 251621 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 4 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1632 251628 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 2R Amethyst Way 3 Back Yard : Yard 13 Tree 1 Private 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1637 251619 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1638 251620 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 3 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1639 251615 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 64R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1640 251622 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 5 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1641 251627 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 2R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1643 251614 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 64R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999367.0 2100045.0 37.746286674920704 -122.44491766156601 (37.7462866749207, -122.444917661566)
1645 251626 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 2R Amethyst Way 1 Back Yard : Yard 13 Tree 1 Private 1           5999263.0 2100016.0 37.746201111936706 -122.44527519504999 (37.7462011119367, -122.44527519505)
1646 251633 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 14R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1648 251606 Significant Tree 6 Pinus radiata :: Monterey Pine 3 52R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1650 251608 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1651 251609 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1652 251618 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1654 251610 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 3 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
1772 173895 Undocumented 2 Pinus radiata :: Monterey Pine 3 326x Dellbrook Ave 2 Back Yard : Yard 13 Tree 1 Private 1     3 3x3   5997295.0 2102064.0 37.7517118802849 -122.452228008054 (37.7517118802849, -122.452228008054)
1996 252848 Property Tree 7 Pinus halepensis :: Allepo Pine 164 99 Reposa Way 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5998022.0 2098104.0 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965)
2457 253065 Undocumented 2 Private shrub :: Private Shrub 64 1x Drake St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6001423.0 2086924.0 37.710376533009295 -122.436869130393 (37.7103765330093, -122.436869130393)
2502 253119 Private 5 Pinus radiata :: Monterey Pine 3 185 Belgrave Ave 1 Back Yard : Yard 13 Tree 1 Private 1         Permit Number 780239 5997636.85301 2104869.74588 37.759435335978296 -122.45124816933 (37.7594353359783, -122.45124816933)
2864 209183 Undocumented 2 Tree(s) :: 17 140 Kensington Way 3 Back Yard : Yard 13 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994862.40668 2098482.07156 37.741737150351 -122.460380669142 (37.741737150351, -122.460380669142)
2887 209188 Undocumented 2 Tree(s) :: 17 156 Kensington Way 2 Back Yard : Yard 13 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780524 5994823.818630001 2098534.27999 37.7418782818471 -122.46051787510599 (37.7418782818471, -122.460517875106)
3750 253551 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 19 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 04:40:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3754 253538 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1000 Cayuga Ave 6 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 02:43:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3755 253535 DPW Maintained 3 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 1000 Cayuga Ave 3 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 02:31:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3758 253548 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 16 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 04:31:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3760 253533 DPW Maintained 3 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 1000 Cayuga Ave 1 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 01:57:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3761 253534 DPW Maintained 3 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 1000 Cayuga Ave 2 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 02:08:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3832 253545 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1000 Cayuga Ave 13 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:58:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3835 253567 Private 5 Salix spp :: Willow 218 25 Raycliff Ter 1 Back Yard : Yard 13 Tree 1 Private 1           6000333.0 2116919.0 37.792673532262505 -122.44278881704399 (37.7926735322625, -122.442788817044)
3837 253550 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 18 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:43:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3840 253546 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 14 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:50:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3841 253549 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 17 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:46:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3842 253547 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 15 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:40:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3896 253542 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 10 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:42:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3899 253541 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 9 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 03:59:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3900 253543 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 11 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:35:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3902 253544 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 12 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:38:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3906 253540 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 8 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 04:11:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
4033 253536 DPW Maintained 3 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 1000 Cayuga Ave 4 Back Yard : Yard 13 Tree 1 DPW 2   10/05/2017 04:10:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
4040 253539 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1000 Cayuga Ave 7 Back Yard : Yard 13 Tree 1 DPW 2   10/05/2017 04:07:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
4116 253537 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 1000 Cayuga Ave 5 Back Yard : Yard 13 Tree 1 DPW 2   10/05/2017 04:02:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
4283 253621 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 200x Montcalm St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6010036.0 2099760.0 37.7461072494139 -122.40800527847799 (37.7461072494139, -122.408005278478)
4447 253626 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 1671 Funston Ave 1 Back Yard : Yard 13 Tree 1 Private 1       10x10   5992125.0 2104081.0 37.756952512450205 -122.47025325330601 (37.7569525124502, -122.470253253306)
4922 253717 Significant Tree 6 Pinus Spp :: Pine Spp 105 4101 Balboa St 1 Back Yard : Yard 13 Tree 1 Private 1           5982822.0 2110967.0 37.7753172554615 -122.50293574331002 (37.7753172554615, -122.50293574331)
5091 253769 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 100 Raccoon Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
5096 253768 Property Tree 7 Cupressus macrocarpa :: Monterey Cypress 47 100 Raccoon Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
8592 121500 Private 5 Pinus radiata :: Monterey Pine 3 251X Pennsylvania Ave 1 Back Yard : Yard 13 Tree 1 DPW 2                    
10146 173882 Undocumented 2 Pinus radiata :: Monterey Pine 3 201x Howth St 1 Back Yard : Yard 13 Tree 1 Private 1           5997459.0 2090748.0 37.7206502603184 -122.450845024895 (37.7206502603184, -122.450845024895)
10196 173897 Undocumented 2 Pinus Spp :: Pine Spp 105 90x Knollview Way 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997593.0 2101480.0 37.7501254274205 -122.451155378281 (37.7501254274205, -122.451155378281)
10199 173896 Undocumented 2 Pinus radiata :: Monterey Pine 3 326x Dellbrook Ave 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997295.0 2102064.0 37.7517118802849 -122.452228008054 (37.7517118802849, -122.452228008054)
10223 173927 Significant Tree 6 Pinus radiata :: Monterey Pine 3 240 States St 1 Back Yard : Yard 13 Tree 1 Private 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
10255 112606 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Back Yard : Yard 13 Tree 1 Private 1       10x10   5999003.0 2105766.0 37.761974353511896 -122.446587863076 (37.7619743535119, -122.446587863076)
13268 187627 Private 5 Cupressus macrocarpa :: Monterey Cypress 47 88 States St 1 Back Yard : Yard 13 Tree 1 Private 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
13301 187651 Significant Tree 6 Myoporum laetum :: Myoporum 1 175 Raccoon Dr 1 Back Yard : Yard 13 Tree 1 Private 1           5998689.0 2104063.0 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828)
13315 187668 Significant Tree 6 Eriobotrya deflexa :: Bronze Loquat 49 100x OGDEN AVE 4 Back Yard : Yard 13 Tree 1 Private 1           6007659.0 2096105.0 37.7359380573488 -122.41596587682 (37.7359380573488, -122.41596587682)
13321 187670 Property Tree 7 Pinus radiata :: Monterey Pine 3 230 Victoria St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5993274.0 2088748.0 37.7149182807441 -122.465165952001 (37.7149182807441, -122.465165952001)
19360 105328 Significant Tree 6 Tree(s) :: 17 2051 03rd St 2 Back Yard : Yard 13 Tree 1 Private 1         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631)
20974 109568 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 116 95 Nordhoff St 1 Back Yard : Yard 13 Tree 1 Private 1         Permit Number 777169 6000348.8 2095645.6 37.734262946491704 -122.44120712981501 (37.7342629464917, -122.441207129815)
22300 248974 Property Tree 7 Metrosideros excelsa :: New Zealand Xmas Tree 2 716 Goettingen St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6010713.0 2091306.0 37.7229322393396 -122.405069122237 (37.7229322393396, -122.405069122237)
22826 251117 Property Tree 7 Sequoiadendron giganteum :: Sierra Redwood 212 2024 Castro St 1 Back Yard : Yard 13 Tree 1 Private 1           6002622.0 2099601.0 37.7452527853239 -122.43363054854099 (37.7452527853239, -122.433630548541)
22866 251139 Significant Tree 6 Tree(s) :: 17 621X Gough St 1 Back Yard : Yard 13 Tree 1 Private 1   03/10/2017 12:00:00 AM 3   Permit Number 779685          
22926 251147 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 113x Gladeview Way 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997915.0 2102038.0 37.7516759885035 -122.450082102397 (37.7516759885035, -122.450082102397)
23421 195972 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 18 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015355.8319 2100319.8042599997 37.7479407691514 -122.389648918288 (37.7479407691514, -122.389648918288)
23859 223337 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 21 Poppy Ln 1 Back Yard : Yard 13 Tree 1 Private 1     5 Width 2ft   6002002.72042 2096679.5859400001 37.737196106421706 -122.435562951888 (37.7371961064217, -122.435562951888)

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