trees
1,098 rows where qCaretaker_id = 4 sorted by PermitNotes
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||||
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 | |
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 | ||
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 | ||||
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 | |||
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 | ||
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 | ||
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 | ||
48126 | 108611 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2025x Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 3x3 | 6008581.83386 | 2119799.52206 | 37.8010495338737 | -122.414451351572 | (37.8010495338737, -122.414451351572) | 5 | 1 | 10 | 308 | 32 | ||
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 | ||
48885 | 98651 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2110 Greenwich St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 23 | 5x5 | 6002674.17203 | 2119228.66956 | 37.7991484749737 | -122.434853527066 | (37.7991484749737, -122.434853527066) | 13 | 9 | 1 | 57 | 17 | ||
48931 | 95501 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 8 | 3x3 | 5985979.29593 | 2112362.71829 | 37.7793345591202 | -122.492116870392 | (37.7793345591202, -122.492116870392) | 11 | 6 | 2 | 55 | 26 | |||
49723 | 115970 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30TH AVE | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 0 | 3x3 | 5986686 | 2104596 | 37.7580506061519 | -122.489100968136 | (37.7580506061519, -122.489100968136) | 1 | 8 | 3 | 56 | 35 | |||
49808 | 99350 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5986835.93382 | 2113116.06056 | 37.7814530607414 | -122.489208844148 | (37.7814530607414, -122.489208844148) | 11 | 6 | 2 | 55 | 26 | ||
49823 | 98650 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | 5x5 | 6002693.158 | 2119231.97091 | 37.7991586175436 | -122.434788065428 | (37.7991586175436, -122.434788065428) | 13 | 9 | 1 | 57 | 17 | ||
50176 | 99498 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6002794.02408 | 2092508.79842 | 37.7257889832596 | -122.432529234659 | (37.7257889832596, -122.432529234659) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
50714 | 97069 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 6x6 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
51466 | 95482 | 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 | 5986568.36529 | 2111879.34223 | 37.7780417630679 | -122.490043497613 | (37.7780417630679, -122.490043497613) | 11 | 6 | 2 | 55 | 26 | ||
51523 | 107874 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 830X Harrison St | 7 | 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 | ||||
51808 | 111862 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
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 | ||||
51914 | 95459 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 657X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 3x3 | 5986588.2 | 2111449.2 | 37.776861872872 | -122.489943238472 | (37.776861872872, -122.489943238472) | 11 | 6 | 2 | 55 | 26 | ||
52455 | 117257 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1570 31ST AVE | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
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 | |
52882 | 102190 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
53024 | 99347 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986832.70752 | 2113173.16715 | 37.7816096708126 | -122.489224205331 | (37.7816096708126, -122.489224205331) | 11 | 6 | 2 | 55 | 26 | ||
54458 | 95149 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 15 | 5988721.12033 | 2113580.38159 | 37.7828378146839 | -122.482721124929 | (37.7828378146839, -122.482721124929) | 11 | 6 | 2 | 55 | 26 | |||
54757 | 97063 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
55011 | 99667 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
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 | ||
55266 | 142521 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 301 FRANCISCO ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/04/2013 12:00:00 AM | 0 | Width 0ft | 6009485.2617 | 2121177.5361 | 37.8048839283261 | -122.411422499274 | (37.8048839283261, -122.411422499274) | 3 | 1 | 10 | 308 | 23 | ||
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 | |
56509 | 95507 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 10 | 3x3 | 5985983.58763 | 2112182.96811 | 37.7788412674233 | -122.492088785464 | (37.7788412674233, -122.492088785464) | 11 | 6 | 2 | 55 | 26 | |||
56734 | 173683 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | 6008515 | 2088365 | 37.7147337500707 | -122.412459395375 | (37.7147337500707, -122.412459395375) | 9 | 7 | 8 | 309 | 18 | |||
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 | ||||
57109 | 102194 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
57556 | 99341 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 24 | 4x5 | 5986573.71046 | 2113038.86406 | 37.7812257915862 | -122.49011031791 | (37.7812257915862, -122.49011031791) | 11 | 6 | 2 | 55 | 26 | ||
57689 | 117255 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1570 31ST AVE | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5986686.8 | 2104596 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | 1 | 8 | 3 | 56 | 35 | |||||
58278 | 75214 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 125 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 14 | 4x5 | 6002868.59368 | 2092460.80856 | 37.7256614422973 | -122.432268027453 | (37.7256614422973, -122.432268027453) | 9 | 7 | 6 | 28861 | 5 | |
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 | ||||
58686 | 98656 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.7991261619004 | -122.435006269744 | (37.7991261619004, -122.435006269744) | 13 | 9 | 1 | 57 | 17 | ||
58702 | 95478 | 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 | 5986565.85749 | 2112005.2728 | 37.7783873861575 | -122.490061437886 | (37.7783873861575, -122.490061437886) | 11 | 6 | 2 | 55 | 26 | ||
58864 | 116052 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/23/2018 12:00:00 AM | 3 | 4x4 | 6011506.55629 | 2105277.69862 | 37.7613398627543 | -122.403308344903 | (37.7613398627543, -122.403308344903) | 10 | 3 | 8 | 28856 | 29 | |
58967 | 95156 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 250 23rd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 21 | 5988717.78601 | 2113765.0163 | 37.7833445754979 | -122.482746195108 | (37.7833445754979, -122.482746195108) | 11 | 6 | 2 | 55 | 26 | |||
59231 | 97070 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
59247 | 98633 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6002258.36283 | 2120214.87059 | 37.8018327075615 | -122.436362986088 | (37.8018327075615, -122.436362986088) | 13 | 9 | 1 | 57 | 17 | ||
60043 | 111861 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
60137 | 98622 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3500X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 6x6 | 6002297.34528 | 2119958.59074 | 37.8011312453645 | -122.436209738003 | (37.8011312453645, -122.436209738003) | 13 | 9 | 1 | 57 | 17 | ||
60432 | 112026 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||||
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 | |
61767 | 97068 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
62037 | 95492 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 6 | 3x3 | 5986013.63252 | 2111419.06509 | 37.7767455639501 | -122.491928594276 | (37.7767455639501, -122.491928594276) | 11 | 6 | 2 | 55 | 26 | |||
62341 | 225510 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 21 | 6x6 | 6004199.54992 | 2106135.78909 | 37.7632851647079 | -122.42864138449 | (37.7632851647079, -122.42864138449) | 8 | 4 | 5 | 28862 | 3 | |||
62536 | 112022 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2101x 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||||
62685 | 98637 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3500X Fillmore St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6002243.51572 | 2120296.51697 | 37.8020560434066 | -122.436420210829 | (37.8020560434066, -122.436420210829) | 13 | 9 | 1 | 57 | 17 | ||
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 | ||
63052 | 98617 | DPW Maintained 1 | Vitex lucens :: Puriri tree 492 | 2501X Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6005326.63971 | 2118722.15466 | 37.7979079528477 | -122.425639007743 | (37.7979079528477, -122.425639007743) | 13 | 9 | 1 | 57 | 17 | ||
63210 | 96591 | 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 | |||||
63669 | 97067 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/06/2014 12:00:00 AM | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | |
63809 | 99258 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 5995889.58772 | 2113188.82138 | 37.7821771504315 | -122.45789304424 | (37.7821771504315, -122.45789304424) | 11 | 6 | 1 | 54 | 31 | ||
64192 | 99336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) | 11 | 6 | 2 | 55 | 26 | ||
64478 | 98626 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3500X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 6x6 | 6002283.11168 | 2120054.94147 | 37.8013949904512 | -122.436265891653 | (37.8013949904512, -122.436265891653) | 13 | 9 | 1 | 57 | 17 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );