Street_Tree_List

Data source: data.sfgov.org

196 rows where qCaretaker = 10 sorted by SiteOrder

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▼ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1586 98725 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 360 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10     14 3x3   6006216.75471 2111460.37935 37.7780191723707 -122.42204280683501 (37.7780191723707, -122.422042806835)
1919 251807 Undocumented 2 Crateagus spp :: Hawthorn 160 2 Hangah St 1 Unaccepted Street : Cutout 20 Tree 1 DPW for City Agency 10 Rec/Park 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
2825 81846 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1421 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 12/20/2007 12:00:00 AM 3 3x3 Permit Number 50020 6007049.49584 2115692.06976 37.7896852939829 -122.419462344328 (37.7896852939829, -122.419462344328)
2924 140269 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 08/11/2017 12:00:00 AM 3 Width 0ft   5998144.7463 2109987.1343 37.7735154534297 -122.449860434482 (37.7735154534297, -122.449860434482)
7681 103657 Significant Tree 6 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7764 103662 Undocumented 2 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
9748 173655 DPW Maintained 3 Quercus ilex :: Holly Oak 78 100 Lawton St 1 Median : Cutout 11 Tree 1 DPW for City Agency 10                    
9751 173659 DPW Maintained 3 Quercus ilex :: Holly Oak 78 200 Lawton St 1 Median : Cutout 11 Tree 1 DPW for City Agency 10           5993693.06683 2104628.21116 37.7585455452803 -122.46487007071998 (37.7585455452803, -122.46487007072)
23495 49666 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000245.17413 2120665.11682 37.8029543681198 -122.443361894237 (37.8029543681198, -122.443361894237)
79317 95366 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 3101X Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   14 3x3   6005504.90819 2120981.97244 37.8041229057048 -122.42518303152201 (37.8041229057048, -122.425183031522)
81617 81843 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1299X Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
83640 101808 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 3149 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   02/03/2015 12:00:00 AM 3 3x3   6008718.2 2100791.7 37.7488661984732 -122.41263499808599 (37.7488661984732, -122.412634998086)
84126 95033 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 3224 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
84535 111128 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2030x HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   7 5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
98857 97214 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300X Claremont Blvd 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10     12     5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
101061 113808 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4101x 25TH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
104559 114737 Undocumented 2 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 455x LILY ST 1 Sidewalk: Curb side : Pot 10 Tree 1 DPW for City Agency 10 DPW 4         6004484.0 2109981.0 37.77385927942 -122.427931581119 (37.77385927942, -122.427931581119)
109029 108973 Property Tree 7 Pinus radiata :: Monterey Pine 3 3485X SAN BRUNO AVE 1 Median : Yard 3 Tree 1 DPW for City Agency 10           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066)
110121 49668 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 Private 3 04/18/2011 12:00:00 AM     Permit Number 46510 6000239.54014865 2120711.44405841 37.8030812490195 -122.44338472026199 (37.8030812490195, -122.443384720262)
110169 113705 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2801x CLEMENT ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   10 4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
113315 13091 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1439X Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/02/2016 06:38:00 AM 3 4x5   6005488.541730001 2119878.23932 37.8010914133698 -122.425161084884 (37.8010914133698, -122.425161084884)
115219 98995 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2190X Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6000922.9 2115860.7 37.7898013277865 -122.44067180053001 (37.7898013277865, -122.44067180053)
121059 103652 Significant Tree 6 Tree(s) :: 17 307X Octavia St 1 Front Yard : Yard 7 Tree 1 DPW for City Agency 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
121695 111379 Undocumented 2 Pinus radiata :: Monterey Pine 3 301x OCEAN AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10 MTA 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
124070 98909 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 501X Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 DPW 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
126853 110533 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 City College 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
127158 98799 DPW Maintained 3 Ginkgo biloba :: Maidenhair Tree 44 950@Washington Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
132930 110400 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 419X 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 MTA 10   28 3x3   5990269.5497 2112500.03817 37.77996145844129 -122.477285287094 (37.7799614584413, -122.477285287094)
1043 81845 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1421 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 04/28/2017 08:33:00 AM 3 3x3 Permit Number 50020 6007103.87391 2115697.8037 37.789704100621705 -122.419274608151 (37.7897041006217, -122.419274608151)
1493 103663 Undocumented 2 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
1912 251809 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 2 Unaccepted Street : Cutout 20 Tree 1 DPW for City Agency 10 Rec/Park 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
2552 246840 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 2 : 4 Tree 1 DPW for City Agency 10     19 Width 3ft   6001188.51269 2109936.2184200003 37.7735493340682 -122.43932797261999 (37.7735493340682, -122.43932797262)
2926 140270 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998125.7967 2109984.6626 37.773507582533604 -122.44992580546001 (37.7735075825336, -122.44992580546)
2933 98726 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 360 Grove St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10     12 3x3   6006198.51355 2111464.4034 37.7780291926159 -122.422106195562 (37.7780291926159, -122.422106195562)
11212 103658 Significant Tree 6 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
43480 111380 Undocumented 2 Pinus radiata :: Monterey Pine 3 301x OCEAN AVE 2 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10 MTA 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
51360 110401 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 419X 18th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 MTA 10   27 3x3   5990271.90904 2112469.3758 37.779877404965504 -122.4772748837 (37.7798774049655, -122.4772748837)
74620 98800 DPW Maintained 3 Ginkgo biloba :: Maidenhair Tree 44 950@Washington Clay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010265.98354 2117209.83013 37.7940333389111 -122.408440670611 (37.7940333389111, -122.408440670611)
79502 98996 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2190X North Point St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   04/18/2011 12:00:00 AM   3x3   6000702.0 2120685.0 37.803035002067396 -122.441782472194 (37.8030350020674, -122.441782472194)
82710 99003 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
93134 98908 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 501X Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 DPW 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
96735 113809 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 4101x 25TH ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 06/15/2016 07:36:00 AM 3 5x5   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
100401 81842 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1299X Larkin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
104962 97215 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300X Claremont Blvd 2 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10     20 4x12   5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
111208 95042 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 3224 Pierce St 2 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10     11 3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
111553 113706 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2801x CLEMENT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
125996 103653 Significant Tree 6 Tree(s) :: 17 307X Octavia St 2 Front Yard : Yard 7 Tree 1 DPW for City Agency 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
142174 111129 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2030x HAYES ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
144577 113865 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
144922 110534 Undocumented 2 Maytenus boaria :: Mayten 22 100X ASHBURY ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 City College 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
187997 49658 DPW Maintained 3 Cercis occidentalis :: Western Redbud 246 3630 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   04/18/2011 12:00:00 AM 1   Permit Number 46510 6000258.18089 2120685.13581 37.8030100766084 -122.44331832298401 (37.8030100766084, -122.443318322984)
1905 251810 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 3 Unaccepted Street : Cutout 20 Tree 1 DPW for City Agency 10 Rec/Park 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
2535 246841 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 3 : 4 Tree 1 DPW for City Agency 10     14 Width 3ft   6001195.01805 2109899.62825 37.7734492368388 -122.439302846449 (37.7734492368388, -122.439302846449)
6064 98727 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 360 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10     12 3x3   6006176.94483 2111455.11485 37.7780024719703 -122.422180149508 (37.7780024719703, -122.422180149508)
8408 103664 Undocumented 2 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
15949 103659 Significant Tree 6 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
46479 49665 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000243.34961 2120687.49551 37.8030157099616 -122.443369816371 (37.8030157099616, -122.443369816371)
62496 103654 Significant Tree 6 Tree(s) :: 17 307X Octavia St 3 Front Yard : Yard 7 Tree 1 DPW for City Agency 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
72352 98801 DPW Maintained 3 Ginkgo biloba :: Maidenhair Tree 44 950@Washington Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010237.16405 2117207.30409 37.794024789059996 -122.408540211182 (37.79402478906, -122.408540211182)
82784 95034 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 3224 Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
92640 109986 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 501X Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 DPW 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
94914 99004 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
95213 113810 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 4101x 25TH ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
95919 113866 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
97025 81841 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1299X Larkin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
107894 111381 Undocumented 2 Pinus radiata :: Monterey Pine 3 301x OCEAN AVE 3 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10 MTA 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
108530 110402 Undocumented 2 Juniperus chinensis :: Juniper 19 419X 18TH AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 MTA 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
115629 113707 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2801x CLEMENT ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
123900 98997 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
143072 97216 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300X Claremont Blvd 3 Back Yard : Cutout 16 Tree 1 DPW for City Agency 10           5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
1921 251811 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 4 Unaccepted Street : Cutout 20 Tree 1 DPW for City Agency 10 Rec/Park 7     3x3   6010544.0 2117119.0 37.7937995065594 -122.40747229387699 (37.7937995065594, -122.407472293877)
2553 246842 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 4 : 4 Tree 1 DPW for City Agency 10     15 Width 4ft   6001208.43411 2109888.06605 37.7734182533891 -122.439255609578 (37.7734182533891, -122.439255609578)
2906 140272 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998087.0735 2109979.7192 37.7734917934815 -122.450059397698 (37.7734917934815, -122.450059397698)
3428 98728 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 360 Grove St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10     14 3x3   6006156.19882 2111456.14926 37.778004142027 -122.42225199096 (37.778004142027, -122.42225199096)
10665 103665 Undocumented 2 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12113 103660 Significant Tree 6 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
19689 99005 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10         Permit Number 46510 6000381.4 2120794.3 37.803316837922104 -122.442899765771 (37.8033168379221, -122.442899765771)
44837 95043 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 3224 Pierce St 4 Sidewalk: Property side : Cutout 5 Tree 1 DPW for City Agency 10     9 3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
61973 47415 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   05/14/2002 12:00:00 AM 9   Permit Number 45326 6000240.55787 2120707.38669 37.8030701666099 -122.443380906816 (37.8030701666099, -122.443380906816)
84481 113708 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2801x CLEMENT ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)
88938 82383 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1421 Pine St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 09/11/2012 12:00:00 AM 3 3x3   6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
92075 111588 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 730X Lake Merced Blvd 4 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4   48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
95046 109987 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 501X Shotwell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 DPW 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
100981 103655 Significant Tree 6 Tree(s) :: 17 307X Octavia St 4 Front Yard : Yard 7 Tree 1 DPW for City Agency 10   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.2033599997 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839)
101265 110403 Undocumented 2 Ficus laurel :: 256 419X 18TH AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 MTA 10   22 3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
101830 113867 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
111252 81840 DPW Maintained 3 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1299X Larkin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.789712940015704 -122.419194651452 (37.7897129400157, -122.419194651452)
114359 98998 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641)
118334 111131 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2030x HAYES ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
118995 97217 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300X Claremont Blvd 4 Back Yard : Cutout 16 Tree 1 DPW for City Agency 10     18     5993486.0 2098110.3 37.7406370848463 -122.465112792055 (37.7406370848463, -122.465112792055)
122616 113811 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4101x 25TH ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   5 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
125443 110737 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 333 1299x PERSIA AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6004594.0 2089787.0 37.71841743015371 -122.42611316787901 (37.7184174301537, -122.426113167879)
2519 246843 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 5 : 4 Tree 1 DPW for City Agency 10     9 Width 3ft   6001198.912769999 2109877.26909 37.7733880658265 -122.439287771129 (37.7733880658265, -122.439287771129)
2913 140273 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2040 Hayes St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   08/11/2017 12:00:00 AM 3 Width 0ft   5998068.9478 2109976.9729 37.773483215641 -122.450121898862 (37.773483215641, -122.450121898862)
4623 129872 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2051 Beach St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10     7 Width 4ft Permit Number 771149 6000353.54628 2120943.15919 37.803723977330996 -122.44300685090401 (37.803723977331, -122.443006850904)
5598 103666 Undocumented 2 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
6003 98729 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 360 Grove St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10     13 3x3   6006140.89781 2111454.63858 37.7779991309825 -122.42230481531901 (37.7779991309825, -122.422304815319)
12885 103661 Significant Tree 6 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard 7 Tree 1 DPW for City Agency 10 DPW 4 06/07/2013 12:00:00 AM     Permit Number 770306          
57041 98796 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 950@Washington Clay St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   03/16/2012 12:00:00 AM 3 3x3 Permit Number 768771 6010177.18626 2117200.01626 37.7940014192822 -122.40874722700701 (37.7940014192822, -122.408747227007)
81348 113709 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2801x CLEMENT ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     4x4   5986698.0 2113245.0 37.78179903933621 -122.4896955071 (37.7817990393362, -122.4896955071)

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