1,098 rows where qCaretaker_id = 4

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)
28466 98940 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400X San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
28985 95477 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5986565.00775 2112026.27031 37.7784449897253 -122.490065922262 (37.7784449897253, -122.490065922262) 11 6 2 55 26
30203 95755 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003450.90146 2092257.04406 37.7251349504027 -122.430240505894 (37.7251349504027, -122.430240505894) 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
30370 98969 DPW Maintained 1 Arbutus unedo :: Strawberry Tree 106 825 Shotwell St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
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
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
31112 96772 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
31248 96579 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
31577 104151 DPW Maintained 1 :: 45 525X Church St 1 Sidewalk: Property side : Cutout Landscaping SFUSD 4 DPW     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
32232 99335 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 450 30th Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   30 3.5x3.5   5986578.25407 2112899.8451 37.780844350584 -122.490084370963 (37.780844350584, -122.490084370963) 11 6 2 55 26
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
33247 99356 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986838.12863 2112989.55693 37.781105845983 -122.489191947731 (37.781105845983, -122.489191947731) 11 6 2 55 26
33305 102189 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
33781 95450 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   5986571.54012 2111769.53516 37.7777404494553 -122.49002443627 (37.7777404494553, -122.49002443627) 11 6 2 55 26
33788 96601 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
33807 113465 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
33876 115549 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412) 10 3 8 28856 29
34106 31711 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1250X Shrader St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/19/1995 12:00:00 AM 6 3x3 Permit Number 35211 5997882.313818 2106467.94501531 37.7638376395234 -122.450514467435 (37.7638376395234, -122.450514467435) 15 5 11 29492 9
34431 256554 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 3 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:10:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
34474 95271 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2245 Jones St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/23/2016 02:36:00 PM 3 6x6   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
34496 99371 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 25 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986853.20034 2112633.29686 37.7801285370834 -122.489113608336 (37.7801285370834, -122.489113608336) 11 6 2 55 26
34835 71106 DPW Maintained 1 Acacia longifolia :: Golden Wattle 150 4235 19th St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2015 07:32:00 AM 3 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
35006 96602 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
35366 116063 DPW Maintained 1 Brachychiton discolor :: 437 2100x 19th St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   19 3x3   6011332.66531 2105125.78364 37.7609130247313 -122.403899073603 (37.7609130247313, -122.403899073603) 10 3 8 28856 29
35455 47256 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
35858 102033 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
35960 99029 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
35970 122754 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 693 Vermont St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16     6011277.36342 2105334.1858 37.7614821606899 -122.404105006665 (37.7614821606899, -122.404105006665) 10 3 8 28856 29
36069 99326 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5986588.88353 2112653.99552 37.7801699385412 -122.490029510836 (37.7801699385412, -122.490029510836) 11 6 2 55 26
36159 37832 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 19 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048) 9 7 6 28861 5
36285 95758 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003422.17585 2092210.81209 37.7250063806226 -122.430336510319 (37.7250063806226, -122.430336510319) 9 7 6 28861 5
36405 98645 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   9 5x5   6002788.88101 2119245.38589 37.7992008856766 -122.434457791187 (37.7992008856766, -122.434457791187) 13 9 1 57 17
36749 122752 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066) 10 3 8 28856 29
36927 95272 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2245 Jones St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/08/2011 12:00:00 AM 3 3x3   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
37102 77218 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 499X Hearst Ave 22 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 6x50   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
37151 77198 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
37421 37816 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003955.66683 2090537.19552 37.720441203374 -122.428373060073 (37.720441203374, -122.428373060073) 9 7 6 28861 5
37719 81999 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 5 3x3 Permit Number 50638 6005960.45556 2120727.09731 37.8034488081703 -122.423588442877 (37.8034488081703, -122.423588442877) 5 9 1 28858 32
37736 101041 Significant Tree 6 Tree(s) :: 17 3750 18th St 1 Front Yard : Yard Tree SFUSD 4   03/15/2012 12:00:00 AM 30   Permit Number 769376 6005230 2105481 37.7615455321967 -122.425030802687 (37.7615455321967, -122.425030802687) 8 4 5 28859 19
37806 71177 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 4235 19th St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 08/05/1995 12:00:00 AM 12 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
37865 99674 DPW Maintained 1 Tree(s) :: 17 1250X Shrader St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   30 4x4   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
38172 34688 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 3101X Webster St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 07/28/1997 12:00:00 AM 7 3x3 Permit Number 38352 6002815.38185 2119347.35443 37.7994823689702 -122.434373383533 (37.7994823689702, -122.434373383533) 13 9 1 57 17
38321 102024 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
38417 95498 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500X 32nd Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     18 3x3   5985976.05543 2112422.37376 37.7794981665366 -122.492132474117 (37.7794981665366, -122.492132474117) 11 6 2 55 26
38426 115550 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.390181786362 (37.7584697654838, -122.390181786362) 10 3 8 28856 29
38459 107872 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830X Harrison St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6012494.96542 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325) 6 2 9 28856 34
38478 98628 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x4   6002274.71062 2120096.76485 37.8015093491298 -122.43629795789 (37.8015093491298, -122.43629795789) 13 9 1 57 17
38733 98088 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2X Frank Norris St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6007178.15894 2115574.08384 37.7893685797349 -122.419008809929 (37.7893685797349, -122.419008809929) 13 9 10 28858 21
38858 98972 DPW Maintained 1 Shrub :: Shrub 66 825 Shotwell St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   0 5x5   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
38894 95753 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003478.85461 2092303.36569 37.7252637225375 -122.430147177848 (37.7252637225375, -122.430147177848) 9 7 6 28861 5
38966 47201 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801X Clement St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 8 3x3 Permit Number 45157 5986666.18051 2113215.92346 37.7817173456419 -122.489803447111 (37.7817173456419, -122.489803447111) 11 6 2 55 26
39001 99032 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
39397 99695 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
39581 142525 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 301 FRANCISCO ST 15 Sidewalk: Curb side : Cutout Tree SFUSD 4     23 Width 0ft   6009759.5801 2121214.59 37.8050010513122 -122.410475804946 (37.8050010513122, -122.410475804946) 3 1 10 308 23
39667 95239 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   12     6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
39751 96590 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
40144 40254 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 10 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
40234 98607 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2340 Jackson St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   9 3x3   6002988.21052 2116859.68166 37.7926616713417 -122.433597452086 (37.7926616713417, -122.433597452086) 13 9 1 29490 27
40315 116056 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 650x Kansas St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/30/2018 12:00:00 AM 23 4x4   6011515.19198 2105171.68257 37.7610492486475 -122.403271019449 (37.7610492486475, -122.403271019449) 10 3 8 28856 29
40750 30740 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004184.33514 2109844.20882 37.7734667268354 -122.428958416203 (37.7734667268354, -122.428958416203) 7 9 11 28852 10
40781 99039 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 200X Bartlett St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
40927 99358 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5986838.55817 2112947.10039 37.7809892975063 -122.489187339371 (37.7809892975063, -122.489187339371) 11 6 2 55 26
40964 99037 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
41336 96569 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
41372 95268 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2245 Jones St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
41872 41128 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2049 Grove St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268) 15 5 11 29492 16
41878 116060 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2100x 19th St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   7 3x3   6011408.71891 2105130.5396 37.7609303321981 -122.403636370817 (37.7609303321981, -122.403636370817) 10 3 8 28856 29
41997 95473 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5986560.12785 2112162.57896 37.7788189695175 -122.490092832211 (37.7788189695175, -122.490092832211) 11 6 2 55 26
42099 234076 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400 San Bruno Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     12 Width 4ft   6011147.1312 2101589.6307 37.751193164657 -122.404291863299 (37.751193164657, -122.404291863299) 10 4 8 28859 19
42544 37824 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 450X Moscow St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003906.75378 2090460.71651 37.7202284408775 -122.428536688136 (37.7202284408775, -122.428536688136) 9 7 6 28861 5
42731 115967 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     4 3x3   5986812.8086 2104676.4366 37.7582788637421 -122.488668327875 (37.7582788637421, -122.488668327875) 1 8 3 56 35
43317 113469 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 26 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
43418 99345 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 23 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 4x4   5986571.27659 2113136.01167 37.7814923890114 -122.490125885703 (37.7814923890114, -122.490125885703) 11 6 2 55 26
43511 98646 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   8 5x5   6002771.23879 2119243.65965 37.7991951444108 -122.434518715761 (37.7991951444108, -122.434518715761) 13 9 1 57 17
43550 99349 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5986833.62785 2113132.91132 37.781499193517 -122.489218060865 (37.781499193517, -122.489218060865) 11 6 2 55 26
44113 96509 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
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
44433 94516 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 1106X Wisconsin St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   08/27/2010 12:00:00 AM 2   Permit Number 53703 6012787.7377 2102360.94736 37.7534025731789 -122.398672553793 (37.7534025731789, -122.398672553793) 10 3 8 28856 29
44529 97900 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 375X Precita Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16 3x4   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
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
44884 99367 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 21 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986848.24353 2112713.43374 37.7803482808136 -122.489136649255 (37.7803482808136, -122.489136649255) 11 6 2 55 26
44906 95475 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   5986561.73612 2112070.55828 37.7785664008394 -122.490080498329 (37.7785664008394, -122.490080498329) 11 6 2 55 26
44908 96593 Property Tree 8 Eriobotrya deflexa :: Bronze Loquat 8 450 Church St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
44945 99261 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3099X Polk St 1 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency   12 3x6   6005936.6 2121383.7 37.8052503240173 -122.42371770971 (37.8052503240173, -122.42371770971) 5 1 1 28858 32
45053 98657 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   11 5x5   6002607.56666 2119218.59599 37.7991170337862 -122.435083283187 (37.7991170337862, -122.435083283187) 13 9 1 57 17
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
45359 96211 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 201X Diamond St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   14 4x4   6001762.6 2104666.8 37.759113460692 -122.436964804087 (37.759113460692, -122.436964804087) 2 4 5 28862 3
45651 99551 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Henry St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   26 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
45783 99671 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 150X Alma St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
46043 96215 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200X Collingwood St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   26 4x4   6002035.7 2104682 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266) 2 4 5 28862 3
46093 95466 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 529X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   5986555.1 2112324.8 37.7792640886788 -122.490122160768 (37.7792640886788, -122.490122160768) 11 6 2 55 26
46177 73875 Undocumented 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 450X Banks St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 8 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
46230 99035 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
46233 98631 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 4x4   6002262.16905 2120180.85898 37.8017395368973 -122.436347379249 (37.8017395368973, -122.436347379249) 13 9 1 57 17
46265 95452 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5986573.32223 2111731.41091 37.7776358751612 -122.490015466607 (37.7776358751612, -122.490015466607) 11 6 2 55 26
47600 107870 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830X Harrison St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6012494.96542 2112152.38808 37.7802713603069 -122.400372718325 (37.7802713603069, -122.400372718325) 6 2 9 28856 34
47784 98579 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
47875 234074 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400 San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     11 Width 3ft   6011143.5049 2101689.85229 37.751468148542 -122.404311456823 (37.751468148542, -122.404311456823) 10 4 8 28859 19
47950 97078 DPW Maintained 1 Tree(s) :: 17 1551 Newcomb Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16 4x4   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1

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