trees
1,098 rows where qCaretaker_id = 4 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 14472 | 100972 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 450X Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/24/2016 07:43:00 AM | 3 | Permit Number 37341 | 6009614 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | 3 | 1 | 10 | 308 | 23 | |
| 17603 | 75990 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 350 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6011912.57037 | 2118781.03793 | 37.7984395708796 | -122.402853834756 | (37.7984395708796, -122.402853834756) | 3 | 1 | 10 | 308 | 23 | ||
| 18687 | 104158 | DPW Maintained 1 | :: 45 | 525X Church St | 6 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 27818 | 98647 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | |||
| 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 | ||
| 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 |
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 49150 | 100970 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | Permit Number 37341 | 6009657.9659 | 2120896.9693 | 37.8041232469329 | -122.410805008122 | (37.8041232469329, -122.410805008122) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 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 | ||
| 51293 | 100971 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 4 | Permit Number 37341 | 6009642.5454 | 2120895.3461 | 37.8041179253888 | -122.410858257388 | (37.8041179253888, -122.410858257388) | 3 | 1 | 10 | 308 | 23 | ||
| 56368 | 34692 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) | 13 | 9 | 1 | 57 | 17 |
| 58468 | 100975 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11 | Permit Number 37341 | 6009580.8633 | 2120886.4184 | 37.8040899533369 | -122.411071082632 | (37.8040899533369, -122.411071082632) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 65532 | 100981 | DPW Maintained 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 05/03/2013 12:00:00 AM | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | ||
| 65536 | 100982 | DPW Maintained 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 05/03/2013 12:00:00 AM | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | ||
| 66219 | 100977 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | Permit Number 37341 | 6009542.7178 | 2120879.1139 | 37.8040677578058 | -122.411202572075 | (37.8040677578058, -122.411202572075) | 3 | 1 | 10 | 308 | 23 | ||
| 66578 | 100978 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 5 | Permit Number 37341 | 6009524.0508 | 2120877.4907 | 37.8040622540071 | -122.411267056058 | (37.8040622540071, -122.411267056058) | 3 | 1 | 10 | 308 | 23 | ||
| 72589 | 47255 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1035 Gilman Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 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 |
| 77923 | 256355 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
| 79291 | 104154 | DPW Maintained 1 | :: 45 | 525X Church St | 2 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 90475 | 234072 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 4 | Width 3ft | 6011140.67766 | 2101759.73109 | 37.7516598624171 | -122.404326151746 | (37.7516598624171, -122.404326151746) | 10 | 4 | 8 | 28859 | 19 | ||
| 90901 | 100974 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 15 | Permit Number 37341 | 6009596.2838 | 2120888.8532 | 37.8040975034287 | -122.411017890761 | (37.8040975034287, -122.411017890761) | 3 | 1 | 10 | 308 | 23 | ||
| 92277 | 100973 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 450X Chestnut St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 0 | Permit Number 37341 | 6009614 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | 3 | 1 | 10 | 308 | 23 | ||
| 93651 | 98648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | 13 | 9 | 1 | 57 | 17 | ||
| 94668 | 104156 | DPW Maintained 1 | :: 45 | 525X Church St | 4 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | ||
| 106695 | 100983 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
| 108543 | 67860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/20/1993 12:00:00 AM | 5 | 5x5 | Permit Number 31536 | 6002806.21719 | 2119247.92289 | 37.7992088356751 | -122.434397983605 | (37.7992088356751, -122.434397983605) | 13 | 9 | 1 | 57 | 17 |
| 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 | ||
| 111419 | 104155 | DPW Maintained 1 | :: 45 | 525X Church St | 3 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 121961 | 100979 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6 | Permit Number 37341 | 6009507.0071 | 2120874.2443 | 37.8040523843138 | -122.411325807727 | (37.8040523843138, -122.411325807727) | 3 | 1 | 10 | 308 | 23 | ||
| 123087 | 34690 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) | 13 | 9 | 1 | 57 | 17 |
| 123904 | 98659 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2110 Greenwich St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 20 | 7x7 | 6002683.8 | 2119245.6 | 37.7991955081761 | -122.434821422435 | (37.7991955081761, -122.434821422435) | 13 | 9 | 1 | 57 | 17 | ||
| 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 | ||
| 129312 | 77648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.14742 | 2093142.98247 | 37.7277576387802 | -122.418666516263 | (37.7277576387802, -122.418666516263) | 9 | 3 | 7 | 309 | 5 | |
| 132915 | 100984 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
| 133386 | 98658 | DPW Maintained 1 | Tree(s) :: 17 | 2110 Greenwich St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 06/20/2014 12:00:00 AM | 6x6 | Permit Number 772915 | 6002683.8 | 2119245.6 | 37.7991955081761 | -122.434821422435 | (37.7991955081761, -122.434821422435) | 13 | 9 | 1 | 57 | 17 | |
| 135797 | 97066 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.389755060411 | (37.7351486000155, -122.389755060411) | 10 | 3 | 8 | 58 | 1 | ||
| 137518 | 98655 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 6 | 5x5 | 6002650.75991 | 2119226.56813 | 37.7991413757273 | -122.434934390513 | (37.7991413757273, -122.434934390513) | 13 | 9 | 1 | 57 | 17 | ||
| 142139 | 34693 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.434380455813 | (37.799535058456, -122.434380455813) | 13 | 9 | 1 | 57 | 17 |
| 152683 | 98649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2110 Greenwich St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 16 | 5x5 | 6002707.76445 | 2119233.0203 | 37.7991623281478 | -122.434737597267 | (37.7991623281478, -122.434737597267) | 13 | 9 | 1 | 57 | 17 | ||
| 153628 | 104153 | DPW Maintained 1 | :: 45 | 525X Church St | 1 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 154088 | 95241 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
| 155740 | 95235 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
| 156692 | 104157 | DPW Maintained 1 | :: 45 | 525X Church St | 5 | Sidewalk: Curb side : Cutout | Landscaping | SFUSD 4 | DPW | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 162318 | 34689 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.7994344701793 | -122.434367321195 | (37.7994344701793, -122.434367321195) | 13 | 9 | 1 | 57 | 17 |
| 164652 | 104152 | DPW Maintained 1 | :: 45 | 525X Church St | 2 | Sidewalk: Property side : Cutout | Landscaping | SFUSD 4 | DPW | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | 8 | 4 | 5 | 28862 | 3 | |||
| 168139 | 34691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.434350145047 | (37.7993346796145, -122.434350145047) | 13 | 9 | 1 | 57 | 17 |
| 169010 | 102195 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
| 170711 | 95240 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
| 175564 | 95236 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 12 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
| 182487 | 256357 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
| 182607 | 100976 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 5 | Permit Number 37341 | 6009558.1383 | 2120880.7372 | 37.8040730797801 | -122.411149322876 | (37.8040730797801, -122.411149322876) | 3 | 1 | 10 | 308 | 23 | ||
| 188027 | 100980 | DPW Maintained 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 05/03/2013 12:00:00 AM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
| 189482 | 97895 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 375X Precita Ave | 1 | 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 | ||
| 191936 | 100987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |||
| 192030 | 256356 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3x3 | 6005985 | 2121074 | 37.804402699388 | -122.423528183462 | (37.804402699388, -122.423528183462) | 5 | 1 | 1 | 28858 | 32 | |||
| 167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | 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 | ||
| 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 |
| 1121 | 77643 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006923.44086 | 2093174.37286 | 37.7278498138936 | -122.418301281799 | (37.7278498138936, -122.418301281799) | 9 | 3 | 7 | 309 | 5 | ||
| 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 | |
| 1403 | 77662 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006681.78325 | 2093389.68756 | 37.7284274151839 | -122.419151965791 | (37.7284274151839, -122.419151965791) | 9 | 3 | 7 | 309 | 5 | ||
| 1406 | 75132 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002992.10347 | 2092540.72564 | 37.7258878789975 | -122.431846767938 | (37.7258878789975, -122.431846767938) | 9 | 7 | 6 | 28861 | 5 | ||
| 1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
| 2028 | 76748 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | 1 | 8 | 3 | 56 | 35 | ||
| 2404 | 76334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006750.61437 | 2093170.72103 | 37.7278300567077 | -122.418898489194 | (37.7278300567077, -122.418898489194) | 9 | 3 | 7 | 309 | 5 | ||
| 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 | |
| 3327 | 99692 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 2x2 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
| 3404 | 74737 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 151X Palm Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 5995889.08215 | 2113282.06845 | 37.7824331529909 | -122.457901543211 | (37.7824331529909, -122.457901543211) | 11 | 6 | 1 | 54 | 31 | ||
| 3604 | 77660 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006693.80957 | 2093349.88561 | 37.7283188049508 | -122.419107568078 | (37.7283188049508, -122.419107568078) | 9 | 3 | 7 | 309 | 5 | ||
| 3628 | 76755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | 1 | 8 | 3 | 56 | 35 | ||
| 3789 | 77644 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | 9 | 3 | 7 | 309 | 5 | ||
| 3937 | 98576 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301X Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:52:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
| 3976 | 75213 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 125 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6002883.60734 | 2092451.48886 | 37.7256367037627 | -122.43221546119 | (37.7256367037627, -122.43221546119) | 9 | 7 | 6 | 28861 | 5 | ||
| 4078 | 78328 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014090.70522 | 2094312.98368 | 37.7313770539035 | -122.393603356926 | (37.7313770539035, -122.393603356926) | 10 | 3 | 8 | 58 | 1 | ||
| 4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 11 | 6 | 2 | 55 | 26 | |
| 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 | ||||
| 4867 | 76353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006742.79477 | 2093189.9157 | 37.7278823207912 | -122.418926882581 | (37.7278823207912, -122.418926882581) | 9 | 3 | 7 | 309 | 5 | ||
| 5047 | 37814 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) | 9 | 7 | 6 | 28861 | 5 |
| 5271 | 78323 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014072.33534 | 2094216.70422 | 37.7311116693492 | -122.393660129315 | (37.7311116693492, -122.393660129315) | 10 | 3 | 8 | 58 | 1 | ||
| 5378 | 76652 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 148X Paris St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6002965.38435 | 2092499.73249 | 37.7257738062998 | -122.43193620819 | (37.7257738062998, -122.43193620819) | 9 | 7 | 6 | 28861 | 5 | ||
| 5484 | 71815 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 151X Palm Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5995888.68435 | 2113315.23973 | 37.7825242096287 | -122.45790532062 | (37.7825242096287, -122.45790532062) | 11 | 6 | 1 | 54 | 31 | ||
| 5500 | 77664 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006642.94243 | 2093520.00504 | 37.728783051183 | -122.419295481395 | (37.728783051183, -122.419295481395) | 9 | 3 | 7 | 309 | 5 | ||
| 5610 | 46958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 5633 | 76756 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x12 | 5983095.0741 | 2104639.3384 | 37.757959352781 | -122.501522927406 | (37.757959352781, -122.501522927406) | 1 | 8 | 3 | 56 | 35 | ||
| 5695 | 77663 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006674.08558 | 2093407.54115 | 37.7284760037541 | -122.419179842976 | (37.7284760037541, -122.419179842976) | 9 | 3 | 7 | 309 | 5 | ||
| 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 | ||
| 5947 | 76372 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006736.19364 | 2093210.27498 | 37.7279378512454 | -122.418951146283 | (37.7279378512454, -122.418951146283) | 9 | 3 | 7 | 309 | 5 |
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) );