trees

133 rows where Fire Prevention Districts = 2 and qCaretaker_id = 4 sorted by PlantType

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
2158 95238 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
2915 223666 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 1511 Castro St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   02/16/2016 05:50:00 AM 2 Width 3ft   6002610.0457 2101075.27233 37.7493001124297 -122.433777236447 (37.7493001124297, -122.433777236447) 2 4 5 28862 22
4815 98680 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 199X Park St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
5758 262529 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 555 Portola Dr 8 Front Yard : Yard Tree SFUSD 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
5845 96500 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 1 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
7851 220311 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 4235 19th St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     18 Width 3ft   6001938.02984 2104676.35813 37.7591496745354 -122.436358769151 (37.7591496745354, -122.436358769151) 2 4 5 28862 3
9627 228661 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     13 Width 3ft   6001838.07707 2104669.16217 37.7591242363206 -122.436703937943 (37.7591242363206, -122.436703937943) 2 4 5 28862 3
12179 220312 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 4235 19th St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     15 Width 3ft   6002007.42492 2104678.29116 37.7591589249724 -122.436118906483 (37.7591589249724, -122.436118906483) 2 4 5 28862 3
12520 228662 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     16 Width 3ft   6001863.4982 2104671.44362 37.7591319452903 -122.436616182999 (37.7591319452903, -122.436616182999) 2 4 5 28862 3
16064 235284 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4235 19th St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     11 Width 3ft   6001885.77275 2104671.54401 37.7591334867264 -122.436539154285 (37.7591334867264, -122.436539154285) 2 4 5 28862 3
17099 96505 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 7 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
17590 73937 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/07/1990 12:00:00 AM 10 3x3   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
19907 102028 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 8 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
20806 102022 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 2 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
21524 96504 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 5 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
25347 98970 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 4 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
48192 99026 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3 Permit Number 41415 6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
48405 102030 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 10 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
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
50209 97899 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
51837 113436 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
52900 40252 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 8 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
55022 96512 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 14 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
56850 98746 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
57036 98749 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
58400 113437 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
61217 98752 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
62996 99030 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 4 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
66136 99033 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 7 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
67353 98678 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 199X Park St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
68245 34754 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 825 Shotwell St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/07/2010 12:00:00 AM 5 3x3 Permit Number 53353 6007982.56974873 2103121.8781615 37.7552230267666 -122.415343751113 (37.7552230267666, -122.415343751113) 2 4 7 28859 19
68625 96214 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200X Collingwood St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   20 3x3   6002035.7 2104682 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266) 2 4 5 28862 3
68939 43903 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1050 York St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4   04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19
68964 113434 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     12 4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
71171 98681 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 199X Park St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
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
75897 96511 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 13 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
76443 102025 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 5 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
78075 98679 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 199X Park St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
78271 73518 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2015 07:36:00 AM 3 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
81015 97898 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
81818 96502 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 3 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
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
84673 98750 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
84800 97902 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 375X Precita Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
85492 95237 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   9 3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
85919 98676 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 199X Park St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
87067 98675 Permitted Site 7 Tree(s) :: 17 199X Park St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
87145 113435 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 198x HIGHLAND AVE 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       4x4   6006173 2096415 37.7367055902603 -122.421125584355 (37.7367055902603, -122.421125584355) 2 7 7 28859 2
87595 97901 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 375X Precita Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
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
88151 98756 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
88213 96513 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 15 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
90910 98754 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
91360 110190 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 625 Holly Park Cir 6 Sidewalk: Curb side : Cutout Tree SFUSD 4           6006167.62160945 2096413.49051844 37.7367011423593 -122.421144072665 (37.7367011423593, -122.421144072665) 2 7 7 28859 2
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
92761 110187 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 625 Holly Park Cir 3 Sidewalk: Curb side : Cutout Tree SFUSD 4           6006167.62160945 2096413.49051844 37.7367011423593 -122.421144072665 (37.7367011423593, -122.421144072665) 2 7 7 28859 2
98383 96212 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 201X Diamond St 4 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
98389 99034 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 8 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
98851 98677 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 199X Park St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6006189.1 2096374.1 37.7365941955595 -122.421067016387 (37.7365941955595, -122.421067016387) 2 7 7 28859 2
100312 98971 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 5 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
100591 96499 DPW Maintained 1 Washingtonia filifera :: California Fan Palm 176 2500X Harrison St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     5x5   6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
101825 97903 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 375X Precita Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
102622 99027 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 1 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
105771 99036 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 10 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
106047 40253 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 5 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
109017 43904 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1050 York St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19
109710 97896 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
112801 96209 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 60 201X Diamond St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/28/2012 12:00:00 AM 3 4x4   6001762.6 2104666.8 37.759113460692 -122.436964804087 (37.759113460692, -122.436964804087) 2 4 5 28862 3
113513 96492 DPW Maintained 1 Washingtonia filifera :: California Fan Palm 176 2500X Harrison St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     5x5   6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
113529 102032 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 12 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
115599 96503 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
117978 99025 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
121802 96216 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200X Collingwood St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 4x4   6002035.7 2104682 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266) 2 4 5 28862 3
124180 96506 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 8 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
126964 97897 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
127029 99028 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 2 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
128246 98744 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 540X Eureka St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
129482 102027 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 7 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
129647 40250 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 3351X 23rd St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 3 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
130000 102029 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 9 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
132313 73528 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 4235 19th St 7 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
134492 228663 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   06/23/2015 07:36:00 AM 2 Width 3ft   6001958.87793 2104675.64602 37.7591489038263 -122.436286615639 (37.7591489038263, -122.436286615639) 2 4 5 28862 3

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