203 rows where qCaretaker_id = 14 sorted by Supervisor Districts

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts ▼ Zip Codes Neighborhoods (old)
3669 103667 Undocumented 4 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4934 103659 Significant Tree 6 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
6238 103666 Undocumented 4 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
6834 103660 Significant Tree 6 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7411 103658 Significant Tree 6 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
8509 103668 Significant Tree 6 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
9915 173655 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100 Lawton St 1 Median : Cutout Tree DPW for City Agency 14                              
14456 103661 Significant Tree 6 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
15258 103665 Undocumented 4 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
16355 103663 Undocumented 4 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18064 103664 Undocumented 4 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18674 103662 Undocumented 4 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18988 103657 Significant Tree 6 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
6921 95036 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
10068 49666 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000245.17413 2120665.11682 37.8029543681198 -122.443361894237 (37.8029543681198, -122.443361894237) 13 9 1 57 17
11986 95043 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 4 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     9 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
15243 98997 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
16686 99005 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
32812 99009 DPW Maintained 1 Tristania conferta :: 61 2099X Beach St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   01/20/2015 12:00:00 AM 3   Permit Number 771149 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
40162 95366 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3101X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   14 3x3   6005504.90819 2120981.97244 37.8041229057048 -122.425183031522 (37.8041229057048, -122.425183031522) 13 9 1 28858 17
42721 49663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 7   Permit Number 46510 6000228.83335 2120782.17575 37.8032748487093 -122.443426854966 (37.8032748487093, -122.443426854966) 13 9 1 57 17
43653 95034 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
45985 99003 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
50801 95033 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
50984 95035 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
51749 49665 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000243.34961 2120687.49551 37.8030157099616 -122.443369816371 (37.8030157099616, -122.443369816371) 13 9 1 57 17
56816 98996 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2190X North Point St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000702 2120685 37.8030350020674 -122.441782472194 (37.8030350020674, -122.441782472194) 13 9 1 57 17
68320 137118 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2150 North Point St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   01/20/2015 12:00:00 AM 0 Width 4ft Permit Number 771149 6000490.48443 2120659.70119 37.8029534840902 -122.442512606897 (37.8029534840902, -122.442512606897) 13 9 1 57 17
75069 47415 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   05/14/2002 12:00:00 AM 9   Permit Number 45326 6000240.55787 2120707.38669 37.8030701666099 -122.443380906816 (37.8030701666099, -122.443380906816) 13 9 1 57 17
76830 99000 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
76955 99004 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
77560 95038 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
78526 254583 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1439 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 Private 08/02/2016 06:38:00 AM   3x3   6005488 2119883 37.8011044543754 -122.425163298445 (37.8011044543754, -122.425163298445) 13 9 1 57 17
87127 99008 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
87780 95040 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 13 Sidewalk: Property side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
94774 99002 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
95484 98999 DPW Maintained 1 Tristania conferta :: 61 2190X North Point St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   01/20/2015 12:00:00 AM 3 3x3 Permit Number 771149 6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
100260 49664 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3630 Divisadero St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 26   Permit Number 46510 6000238.4271 2120737.06693 37.8031515390838 -122.443390413534 (37.8031515390838, -122.443390413534) 13 9 1 57 17
112996 49662 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000225.92137 2120807.31261 37.803343701723 -122.44343873861 (37.803343701723, -122.44343873861) 13 9 1 57 17
117347 49668 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 Private 04/18/2011 12:00:00 AM     Permit Number 46510 6000239.54014865 2120711.44405841 37.8030812490195 -122.443384720262 (37.8030812490195, -122.443384720262) 13 9 1 57 17
120981 95046 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 10 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     13 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
122270 95039 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
129349 95041 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 12 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
137242 49667 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 8   Permit Number 46510 6000232.67943 2120757.93136 37.8032084994456 -122.443411803017 (37.8032084994456, -122.443411803017) 13 9 1 57 17
141424 95044 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 6 Sidewalk: Property side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
141911 98998 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
142881 95042 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 2 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     11 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
147165 98995 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2190X Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6000922.9 2115860.7 37.7898013277865 -122.44067180053 (37.7898013277865, -122.44067180053) 13 6 1 29490 27
149567 13091 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1439X Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/02/2016 06:38:00 AM 3 4x5   6005488.54173 2119878.23932 37.8010914133698 -122.425161084884 (37.8010914133698, -122.425161084884) 13 9 1 57 17
152225 129875 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2051 Beach St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   01/20/2015 12:00:00 AM 3 Width 4ft Permit Number 771149 6000472.54237 2120960.44245 37.8037782163629 -122.442596301384 (37.8037782163629, -122.442596301384) 13 9 1 57 17
152727 99006 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
161524 99001 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM   3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
162433 99007 DPW Maintained 1 Tristania conferta :: 61 2099X Beach St 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   01/20/2015 12:00:00 AM 3   Permit Number 771149 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
190761 49658 DPW Maintained 1 Cercis occidentalis :: Western Redbud 136 3630 Divisadero St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 1   Permit Number 46510 6000258.18089 2120685.13581 37.8030100766084 -122.443318322984 (37.8030100766084, -122.443318322984) 13 9 1 57 17
193628 129872 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2051 Beach St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     7 Width 4ft Permit Number 771149 6000353.54628 2120943.15919 37.803723977331 -122.443006850904 (37.803723977331, -122.443006850904) 13 9 1 57 17
24920 81846 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1421 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 12/20/2007 12:00:00 AM 3 3x3 Permit Number 50020 6007049.49584 2115692.06976 37.7896852939829 -122.419462344328 (37.7896852939829, -122.419462344328) 13 9 10 28858 21
35002 98799 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
41337 81843 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1299X Larkin St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.7897129400157 -122.419194651452 (37.7897129400157, -122.419194651452) 13 9 10 28858 21
56512 251807 DPW Maintained 1 Crateagus spp :: Hawthorn 130 2 Hangah St 1 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
72388 82383 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1421 Pine St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 09/11/2012 12:00:00 AM 3 3x3   6007127.03967719 2115700.54784829 37.7897129400157 -122.419194651452 (37.7897129400157, -122.419194651452) 13 9 10 28858 21
73001 98796 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 950@Washington Clay St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 3 3x3 Permit Number 768771 6010177.18626 2117200.01626 37.7940014192822 -122.408747227007 (37.7940014192822, -122.408747227007) 3 1 10 28857 4
78186 98801 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010237.16405 2117207.30409 37.79402478906 -122.408540211182 (37.79402478906, -122.408540211182) 3 1 10 28857 4
87604 81841 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1299X Larkin St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.7897129400157 -122.419194651452 (37.7897129400157, -122.419194651452) 13 9 10 28858 21
95513 98800 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010265.98354 2117209.83013 37.7940333389111 -122.408440670611 (37.7940333389111, -122.408440670611) 3 1 10 28857 4
98832 81842 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1299X Larkin St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.7897129400157 -122.419194651452 (37.7897129400157, -122.419194651452) 13 9 10 28858 21
111923 81845 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1421 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 04/28/2017 08:33:00 AM 3 3x3 Permit Number 50020 6007103.87391 2115697.8037 37.7897041006217 -122.419274608151 (37.7897041006217, -122.419274608151) 13 9 10 28858 21
127023 251811 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 4 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
128875 251813 DPW Maintained 1 Crateagus spp :: Hawthorn 130 2 Hangah St 6 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
135831 81840 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1299X Larkin St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.7897129400157 -122.419194651452 (37.7897129400157, -122.419194651452) 13 9 10 28858 21
141721 98795 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 950@Washington Clay St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
144228 251810 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 3 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
149776 98798 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950@Washington Clay St 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 22 3x3 Permit Number 768771 6010098.56978 2117188.54171 37.7939655093431 -122.409018439172 (37.7939655093431, -122.409018439172) 3 1 10 28857 4
168582 251809 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 2 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
178823 81839 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1299X Larkin St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 12/20/2007 12:00:00 AM 4 3x3 Permit Number 50020 6007127.03967719 2115700.54784829 37.7897129400157 -122.419194651452 (37.7897129400157, -122.419194651452) 13 9 10 28858 21
187706 98797 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 1 3x3 Permit Number 768771 6010116.35805 2117191.91562 37.7939757697248 -122.408957127878 (37.7939757697248, -122.408957127878) 3 1 10 28857 4
3436 103654 Significant Tree 6 Tree(s) :: 17 307X Octavia St 3 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
12201 140276 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/11/2017 12:00:00 AM 3 Width 0ft   5998008.2541 2109969.0086 37.7734578744037 -122.450331271992 (37.7734578744037, -122.450331271992) 15 5 11 29492 16
21486 114737 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 455x LILY ST 1 Sidewalk: Curb side : Pot Tree DPW for City Agency 14 DPW         6004484 2109981 37.77385927942 -122.427931581119 (37.77385927942, -122.427931581119) 7 9 11 28852 10
21624 140275 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/11/2017 12:00:00 AM 3 Width 0ft   5998028.0276 2109971.4803 37.773465792675 -122.450263051124 (37.773465792675, -122.450263051124) 15 5 11 29492 16
21859 98725 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 360 Grove St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     14 3x3   6006216.75471 2111460.37935 37.7780191723707 -122.422042806835 (37.7780191723707, -122.422042806835) 7 9 11 28852 10
26910 111776 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
29114 103653 Significant Tree 6 Tree(s) :: 17 307X Octavia St 2 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
29933 98726 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 360 Grove St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     12 3x3   6006198.51355 2111464.4034 37.7780291926159 -122.422106195562 (37.7780291926159, -122.422106195562) 7 9 11 28852 10
30910 110537 Undocumented 4 Tree(s) :: 17 100X ASHBURY ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
31418 110533 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
36748 246841 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 3 : Tree DPW for City Agency 14     14 Width 3ft   6001195.01805 2109899.62825 37.7734492368388 -122.439302846449 (37.7734492368388, -122.439302846449) 15 5 11 29492 10
39489 111135 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   2 5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
41067 113874 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
45020 111128 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   7 5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
50314 98728 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 360 Grove St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     14 3x3   6006156.19882 2111456.14926 37.778004142027 -122.42225199096 (37.778004142027, -122.42225199096) 7 9 11 28852 10
54557 246846 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 8 : Tree DPW for City Agency 14     14 Width 3ft   6001207.38463 2109809.38993 37.7732021687661 -122.439253599591 (37.7732021687661, -122.439253599591) 15 5 11 29492 10
55624 246843 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 5 : Tree DPW for City Agency 14     9 Width 3ft   6001198.91277 2109877.26909 37.7733880658265 -122.439287771129 (37.7733880658265, -122.439287771129) 15 5 11 29492 10
56896 98734 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 360 Grove St 10 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     14 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295) 7 9 11 28852 10
65235 113871 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
65648 98733 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 360 Grove St 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     13 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295) 7 9 11 28852 10
74558 111133 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
75284 113868 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
78158 113866 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
78336 98729 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 360 Grove St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     13 3x3   6006140.89781 2111454.63858 37.7779991309825 -122.422304815319 (37.7779991309825, -122.422304815319) 7 9 11 28852 10
94178 98727 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 360 Grove St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     12 3x3   6006176.94483 2111455.11485 37.7780024719703 -122.422180149508 (37.7780024719703, -122.422180149508) 7 9 11 28852 10

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);