home / trees

Street_Tree_List

Data source: data.sfgov.org

191,550 rows sorted by YCoord

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
6 100001 Undocumented 3 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 501X 01st St 2 Sidewalk: Curb side : Pot 3 Tree 1 Private 2         Address is 100 1st Street                    
169 100166 Property Tree 5 Salix spp :: Willow 40 2340 Twin Peaks Blvd   Front Yard : Yard 4 Tree 1 Private 2         Permit Number 769026                    
490 100543 Undocumented 3 Acer spp :: Maple 84 290X Tehama St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x4                      
496 100549 Undocumented 3 Acer spp :: Maple 84 290X Tehama St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x4                      
1347 101532 Undocumented 3 Tree(s) :: 13 11323 Palou Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3                      
2525 102838 Undocumented 3 Pinus radiata :: Monterey Pine 1 1101X Portola Dr 1 Sidewalk: Property side : Yard 5 Tree 1 DPW 1                              
2526 102839 Undocumented 3 Pinus pinea :: Italian Stone Pine 98 1101X Portola Dr 2 Sidewalk: Property side : Yard 5 Tree 1 DPW 1                              
2529 102842 Undocumented 3 Metrosideros excelsa :: New Zealand Xmas Tree 3 1101X Portola Dr 8 Sidewalk: Property side : Yard 5 Tree 1 DPW 1                              
2530 102843 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 1101X Portola Dr 10 Sidewalk: Property side : Yard 5 Tree 1 DPW 1                              
3283 103657 Significant Tree 4 Tree(s) :: 13 350X Hickory St 1 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3284 103658 Significant Tree 4 Tree(s) :: 13 350X Hickory St 2 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3285 103659 Significant Tree 4 Tree(s) :: 13 350X Hickory St 3 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3287 103660 Significant Tree 4 Tree(s) :: 13 350X Hickory St 4 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3288 103661 Significant Tree 4 Tree(s) :: 13 350X Hickory St 5 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3289 103662 Undocumented 3 Tree(s) :: 13 350X Hickory St 1 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3290 103663 Undocumented 3 Tree(s) :: 13 350X Hickory St 2 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3291 103664 Undocumented 3 Tree(s) :: 13 350X Hickory St 3 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3292 103665 Undocumented 3 Tree(s) :: 13 350X Hickory St 4 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3293 103666 Undocumented 3 Tree(s) :: 13 350X Hickory St 5 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3294 103667 Undocumented 3 Tree(s) :: 13 350X Hickory St 6 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
3295 103668 Significant Tree 4 Tree(s) :: 13 350X Hickory St 6 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3 06/07/2013 12:00:00 AM     Permit Number 770306                    
4282 104813 Significant Tree 4 Corymbia ficifolia :: Red Flowering Gum 5 1601X Portola Dr 5 Front Yard : Yard 4 Tree 1 Private 2                              
7069 108180 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 835 Sacramento St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3                      
7475 108593 Permitted Site 2 Olea europaea 'Fruitless' :: Fruitless Olive 14 530 Moraga Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774578                    
8096 109193 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 4124 Moraga Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/02/2015 12:00:00 AM 3 3x3 Permit Number 773525                    
8702 109923 Undocumented 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 214 state st 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3                      
8707 109931 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 2822 Moraga Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/12/2015 12:00:00 AM 3 3x3 Permit Number 775171                    
10719 112267 Undocumented 3 Ficus nitida :: Laurel Fig 18 1X Geary St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2                              
10720 112268 Undocumented 3 Ficus nitida :: Laurel Fig 18 1X Geary St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2                              
10721 112269 Undocumented 3 Ficus nitida :: Laurel Fig 18 1X Geary St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2                              
11338 112908 Undocumented 3 Tree(s) :: 13 1899X Beach St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2                              
11339 112909 Undocumented 3 Tree(s) :: 13 1899X Beach St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2                              
11341 112910 Undocumented 3 Tree(s) :: 13 1899X Beach St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2                              
13702 115471 DPW Maintained 1 Ulmus pumila :: Siberian Elm 31 10X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     24                        
13940 115724 Undocumented 3 Syzygium paniculatum :: Brush Cherry 191 250x Octavia St 1 Side Yard : Yard 27 Tree 1 Dept of Real Estate 15                              
13941 115725 Undocumented 3 Syzygium paniculatum :: Brush Cherry 191 250X Octavia St 2 Side Yard : Yard 27 Tree 1 Dept of Real Estate 15                              
15157 117001 DPW Maintained 1 :: 55 1X Bernal Heights Blvd 1 Front Yard : Yard 4 Tree 1 DPW 1                              
15580 117428 Permitted Site 2 Leptospermum laevigatum :: Australian Tea Tree 73   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/14/2016 12:00:00 AM 3   Permit Number 776915                    
16397 118346 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 1 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 05:47:00 AM 3                        
16398 118347 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 2 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 05:39:00 AM 3                        
16399 118348 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 3 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 06:19:00 AM 3                        
16400 118349 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 4 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 06:43:00 AM 3                        
16402 118350 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 5 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 05:53:00 AM 3                        
16403 118351 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 6 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 06:32:00 AM 3                        
16404 118352 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 7 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 06:56:00 AM 3                        
16405 118353 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 8 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 05:58:00 AM 3                        
16406 118354 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 9 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 06:05:00 AM 3                        
16407 118355 DPW Maintained 1 Acacia stenophylla :: Shoestring Acacia 216 100X Guerrero St 10 Median : Cutout 1 Tree 1 DPW 1   07/15/2016 06:48:00 AM 3                        
16931 119263 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 495X Lakeshore Dr 1 Median : Yard 11 Tree 1 DPW 1       10x30                      
17090 119599 Significant Tree 4 Cupressocyparis leylandii :: Leyland Cypress 134 4357x Mission St 1 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 774415                    
17092 119600 Significant Tree 4 Cupressocyparis leylandii :: Leyland Cypress 134 4357x Mission St 2 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 774415                    
17093 119601 Significant Tree 4 Cupressocyparis leylandii :: Leyland Cypress 134 4357x Mission St 3 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 774415                    
17097 119605 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 299x Avalon Ave 1 Front Yard : Yard 4 Tree 1 Private 2                              
17098 119606 Significant Tree 4 Myoporum laetum :: Myoporum 27 299x Avalon Ave 2 Front Yard : Yard 4 Tree 1 Private 2                              
17099 119607 Significant Tree 4 Pinus radiata :: Monterey Pine 1 299x Avalon Ave 3 Front Yard : Yard 4 Tree 1 Private 2                              
17100 119608 Significant Tree 4 Cupressocyparis leylandii :: Leyland Cypress 134 299x Avalon Ave 4 Front Yard : Yard 4 Tree 1 Private 2                              
17245 119758 DPW Maintained 1 Maytenus boaria :: Mayten 51 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2                              
17246 119759 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 132 101X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       4x4                      
17247 119760 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 132 101X Octavia St Frontage West 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       4x4                      
17248 119761 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 132 101X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       4x4                      
17249 119762 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 132 101X Octavia St Frontage West 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       4x4                      
17250 119763 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 101X Octavia St Frontage West 5 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       4x4                      
17251 119764 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 101X Octavia St Frontage West 6 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       4x4                      
17252 119765 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 101X Octavia St Frontage West 7 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       4x4                      
17405 119914 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 400X Brotherhood Way 1 Front Yard : Yard 4 Tree 1 DPW 1       100x100                      
17625 120130 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 799x Shotwell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3                      
17626 120131 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 799x Shotwell St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3                      
18552 121137 Planning Code 138.1 required 8 Pittosporum undulatum :: Victorian Box 38 1388x Minna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/08/2016 12:00:00 AM 3 3x3                      
18553 121138 Planning Code 138.1 required 8 Pittosporum undulatum :: Victorian Box 38 1388x Minna St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/08/2016 12:00:00 AM 3 3x3                      
18554 121139 Planning Code 138.1 required 8 Pittosporum undulatum :: Victorian Box 38 1388x Minna St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/08/2016 12:00:00 AM 3 3x3                      
18642 121227 DPW Maintained 1 Sequoia sempervirens :: Coast Redwood 157 4299x 17th St 3 Front Yard : Yard 4 Tree 1 DPW 1                              
18802 121399 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 5 349X Cargo Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1                              
18880 121489 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 14 2 Judah St 1 Median : Cutout 1 Tree 1 DPW 1       3x3                      
18893 121500 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 251X Pennsylvania Ave 1 Back Yard : Yard 6 Tree 1 DPW 1                              
19938 122532 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 1900X Castro St 1 Unaccepted Street : Yard 13 Tree 1 Private 2                              
20032 122645 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20033 122646 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20034 122647 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20035 122648 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20036 122649 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20038 122650 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20039 122651 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20040 122652 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20041 122653 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20042 122654 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20043 122655 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20044 122656 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20045 122657 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 13 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20046 122658 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 14 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20047 122659 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 15 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20049 122660 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 16 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20050 122661 DPW Maintained 1 Acer rubrum :: Red Maple 68 300x Hickory St 17 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3x3                      
20051 122663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 401x Laguna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3X3                      
20052 122664 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 401x Laguna St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3X3                      
20053 122665 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 401x Laguna St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3X3                      
20054 122666 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 401x Laguna St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3X3                      
20055 122667 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 401x Laguna St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3X3                      
20056 122668 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 112 301x Hickory St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3X3                      
20057 122669 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 112 301x Hickory St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3X3                      
20059 122670 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 112 301x Hickory St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/10/2016 12:00:00 AM 3 3X3                      

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