1,098 rows where qCaretaker_id = 4 sorted by PlantDate descending

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)
44657 99552 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Henry St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 12/28/2016 06:02:00 AM 3 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
121060 92961 DPW Maintained 1 Tree(s) :: 17 2051 34th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369 -122.492270870248 (37.748848003369, -122.492270870248) 1 8 3 29491 35
129395 92962 DPW Maintained 1 Tree(s) :: 17 2051 34th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369 -122.492270870248 (37.748848003369, -122.492270870248) 1 8 3 29491 35
184091 92963 Permitted Site 7 Tree(s) :: 17 1515 Quintara St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53121 5988690.8 2100920.9 37.7480765758445 -122.481898390884 (37.7480765758445, -122.481898390884) 1 8 3 29491 35
27100 92958 Permitted Site 7 Tree(s) :: 17 300 Seneca Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
142685 92960 Permitted Site 7 Tree(s) :: 17 300 Seneca Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
180121 92959 Permitted Site 7 Tree(s) :: 17 300 Seneca Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
189331 92957 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 300 Seneca Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
190901 92956 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 300 Seneca Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
14678 96770 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 6 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 12/08/2012 12:00:00 AM 3 3x3   6015623.8599 2095148.9526 37.7337575287133 -122.388361234061 (37.7337575287133, -122.388361234061) 10 3 8 58 1
30823 96774 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 12/08/2012 12:00:00 AM 3 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
98248 94927 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 325 Sanchez St   Sidewalk: Curb side : Cutout Tree SFUSD 4   12/07/2010 12:00:00 AM   3x3 Permit Number 53976 6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
82714 94895 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
84292 94894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
132285 94893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
167565 94892 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
30715 73286 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 8 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
52590 73289 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 10 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
95651 73287 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 8 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
176204 73285 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 13 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
183898 73288 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 8 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
61370 76728 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 10 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
94599 76762 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X Farallones St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 10 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
119464 76771 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
129428 76768 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
140619 76757 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
174971 76749 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 200X Farallones St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 8 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
84100 77325 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/18/1988 12:00:00 AM 3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
10649 76037 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x6   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
21099 76027 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
25637 76093 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
71791 76065 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
113652 76212 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
136269 76137 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
158351 76145 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
177702 76170 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 5 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
1341 76159 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
7708 76081 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
86443 76019 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
127608 76051 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
159694 76205 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
167966 76185 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
192959 76112 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
92461 113825 Undocumented 4 Arbutus unedo :: Strawberry Tree 106 1599x CASTRO ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/10/2015 12:00:00 AM 8 3x3   6002577 2101074 37.7492947436898 -122.433891418078 (37.7492947436898, -122.433891418078) 2 4 5 28862 22
75977 96771 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/08/2011 12:00:00 AM 8 4x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
1047 42641 DPW Maintained 1 Hymenosporum flavum :: Sweetshade 24 1651 Union St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 12:11:00 PM 3 5x5 Permit Number 42688 6005090.06351 2118821.98656 37.7981686950973 -122.426464740961 (37.7981686950973, -122.426464740961) 13 9 1 57 17
13407 42632 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 12:07:00 PM 3 4x4 Permit Number 42688 6005134.31421 2118828.07494 37.7981879136105 -122.426312054082 (37.7981879136105, -122.426312054082) 13 9 1 57 17
15563 42636 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 11:48:00 AM 3 4x5 Permit Number 42688 6005181.30457 2118838.80185 37.7982200229931 -122.426150217479 (37.7982200229931, -122.426150217479) 13 9 1 57 17
17940 42637 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 11:43:00 AM 3 4x4 Permit Number 42688 6005203.48268 2118840.06651 37.7982247489172 -122.42607356464 (37.7982247489172, -122.42607356464) 13 9 1 57 17
12918 42635 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 1651 Union St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/07/2020 11:32:00 AM 3 4x5 Permit Number 42688 6005113.34773 2118824.42387 37.7981767035488 -122.426384344263 (37.7981767035488, -122.426384344263) 13 9 1 57 17
11226 33101 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 450X Chestnut St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 11/05/1996 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754367 -122.410721035819 (37.804135754367, -122.410721035819) 3 1 10 308 23
11856 107887 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
171481 107886 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
71723 79386 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 2355 Folsom St 16 Sidewalk: Curb side : Cutout Tree SFUSD 4   10/30/2009 12:00:00 AM     Permit Number 53016 6008491.21757684 2104497.38565881 37.7590284322587 -122.4136819767 (37.7590284322587, -122.4136819767) 2 4 7 28859 19
141407 92806 Permitted Site 7 Tree(s) :: 17 2355 Folsom St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4   10/30/2009 12:00:00 AM     Permit Number 53016 6008199.4 2104720.1 37.7596235634815 -122.414706984191 (37.7596235634815, -122.414706984191) 2 4 7 28859 19
62860 32726 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 200X Farallones St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 20 6x9 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
65943 32730 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.58898 2088651.07748 37.7147529482781 -122.459108206688 (37.7147529482781, -122.459108206688) 9 8 6 28861 24
68707 32729 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 200X Farallones St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 12 3x3 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
77942 32731 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.91433 2088666.61691 37.7147956345921 -122.459108206687 (37.7147956345921, -122.459108206687) 9 8 6 28861 24
129766 32725 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.24753 2088599.26436 37.7146106620382 -122.45910563734 (37.7146106620382, -122.45910563734) 9 8 6 28861 24
178848 32728 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.59612 2088615.91363 37.714656397048 -122.459105637326 (37.714656397048, -122.459105637326) 9 8 6 28861 24
190377 32727 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.97569 2088634.0427 37.7147061970204 -122.459105637321 (37.7147061970204, -122.459105637321) 9 8 6 28861 24
32373 77649 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 3 3x3   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
67880 77637 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 14 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
89151 77638 DPW Maintained 1 Tree(s) :: 17 2X Yale St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 3 3x3   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
118983 77668 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 19 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 5 3x3   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
133673 77636 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 10 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
135683 77635 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 10 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
141010 77633 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 8 3x3   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
180726 77634 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 14 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
183530 95751 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:36:00 PM 3 3x3 Permit Number 767495 6003552.81378 2092420.08444 37.7255883948789 -122.429899830124 (37.7255883948789, -122.429899830124) 9 7 6 28861 5
30221 95757 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:33:00 PM 3 3x3 Permit Number 767495 6003435.4103 2092233.16774 37.7250685138993 -122.430292354528 (37.7250685138993, -122.430292354528) 9 7 6 28861 5
163627 253146 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:29:00 PM 3 3x3 Permit Number 767495 6003400.64895 2092179.59067 37.7249194341684 -122.430408699814 (37.7249194341684, -122.430408699814) 9 7 6 28861 5
90004 97245 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:18:00 PM 3 4x4 Permit Number 767495 6003351.72812 2092154.84242 37.7248487096971 -122.430576048361 (37.7248487096971, -122.430576048361) 9 7 6 28861 5
44331 95756 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:16:00 PM 3 3x3 Permit Number 767495 6003442.24703 2092244.67659 37.7251005018853 -122.430269541405 (37.7251005018853, -122.430269541405) 9 7 6 28861 5
141169 97246 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:11:00 PM 3 4x4 Permit Number 767495 6003334.6314 2092165.82905 37.7248779079737 -122.430635933307 (37.7248779079737, -122.430635933307) 9 7 6 28861 5
118902 97239 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 03:49:00 PM 3 3x3 Permit Number 767495 6003412.15812 2092196.84002 37.7249674489828 -122.430370144078 (37.7249674489828, -122.430370144078) 9 7 6 28861 5
50118 95752 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 03:47:00 PM 3 3x3 Permit Number 767495 6003490.3309 2092321.64943 37.7253145756058 -122.430108809186 (37.7253145756058, -122.430108809186) 9 7 6 28861 5
49986 96493 DPW Maintained 1 Tree(s) :: 17 2500X Harrison St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/24/2014 12:00:00 AM 3 5x5 Permit Number 774006 6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
136350 59884 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/20/1981 12:00:00 AM 24 3x3 Permit Number 19349 6004500.5356676 2116743.15343908 37.7924274060317 -122.42835643846 (37.7924274060317, -122.42835643846) 13 9 1 28858 27
87632 98968 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/16/2015 08:08:00 AM 3 3x3 Permit Number 53353 6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
2999 94036 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1300X Lane St 4 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/14/2019 09:52:00 AM 3 5x5   6015673.325 2095216.0053 37.7339443827642 -122.388194894968 (37.7339443827642, -122.388194894968) 10 3 8 58 1
7113 51366 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014162.99112 2094669.44393 37.7323598375173 -122.393378385216 (37.7323598375173, -122.393378385216) 10 3 8 58 1
8049 51364 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014150.64944 2094610.63008 37.7321976609735 -122.393416939157 (37.7321976609735, -122.393416939157) 10 3 8 58 1
11126 51368 DPW Maintained 1 Celtis sinensis :: Chinese Hackberry 153 50 Pomona St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014172.09212 2094713.43563 37.7324811353964 -122.393349998121 (37.7324811353964, -122.393349998121) 10 3 8 58 1
13398 51356 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014174.8382 2094728.02379 37.7325213440762 -122.393341524701 (37.7325213440762, -122.393341524701) 10 3 8 58 1
14886 51359 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014112.78564 2094416.99761 37.7316638818713 -122.393534297068 (37.7316638818713, -122.393534297068) 10 3 8 58 1
16291 51365 DPW Maintained 1 Celtis sinensis :: Chinese Hackberry 153 50 Pomona St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014154.93455 2094628.60419 37.7322472522973 -122.393403381858 (37.7322472522973, -122.393403381858) 10 3 8 58 1
18431 51369 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014169.21344 2094698.3618 37.7324395857978 -122.39335889599 (37.7324395857978, -122.39335889599) 10 3 8 58 1
45066 51362 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 50 Pomona St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014137.60928 2094535.47761 37.7319905830836 -122.393456764727 (37.7319905830836, -122.393456764727) 10 3 8 58 1
70543 51357 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 50 Pomona St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014147.24137 2094593.61459 37.732150750552 -122.393427531355 (37.732150750552, -122.393427531355) 10 3 8 58 1
80368 51358 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014110.4538 2094404.71931 37.7316300385939 -122.393541499766 (37.7316300385939, -122.393541499766) 10 3 8 58 1
153668 51360 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 50 Pomona St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014114.6767 2094431.72556 37.7317044268964 -122.39352878962 (37.7317044268964, -122.39352878962) 10 3 8 58 1
174301 51361 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 50 Pomona St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014122.20154 2094470.50183 37.7318113167403 -122.393505487305 (37.7318113167403, -122.393505487305) 10 3 8 58 1
176902 51363 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 50 Pomona St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014143.51923 2094573.18836 37.7320944574823 -122.393438970749 (37.7320944574823, -122.393438970749) 10 3 8 58 1
194434 37829 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 450X Moscow St 17 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:54:00 AM 3 3x3 Permit Number 40134 6003878.28183 2090416.42534 37.7201052157501 -122.428631950629 (37.7201052157501, -122.428631950629) 9 7 6 28861 5
194422 37823 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:49:00 AM 3 3x3 Permit Number 40134 6003922.69393 2090463.29382 37.7202364196636 -122.428481771941 (37.7202364196636, -122.428481771941) 9 7 6 28861 5
76214 37822 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 10 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:46:00 AM 3 3x3 Permit Number 40134 6003933.77466 2090481.79158 37.7202878374987 -122.428444787301 (37.7202878374987, -122.428444787301) 9 7 6 28861 5
84190 253150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:41:00 AM 3 3x3   6003965.72194 2090553.13154 37.7204855291627 -122.428339438009 (37.7204855291627, -122.428339438009) 9 7 6 28861 5
55540 60316 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/07/1982 12:00:00 AM 8 4x4   5986588.61699 2112633.05068 37.7801124144217 -122.490028891926 (37.7801124144217, -122.490028891926) 11 6 2 55 26

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)
);