Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10426 | 10426 | 108779 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005562.18075 | 2088048.73923 | 37.7136992126121 | -122.422643108799 | (37.7136992126121, -122.422643108799) |
| 10629 | 10629 | 108781 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005591.90568 | 2088038.18998 | 37.7136719236049 | -122.422539619323 | (37.7136719236049, -122.422539619323) |
| 12330 | 12330 | 108783 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005623.18894 | 2088028.7554099998 | 37.7136477830893 | -122.42243082291901 | (37.7136477830893, -122.422430822919) |
| 12879 | 12879 | 108784 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 2055 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005634.22998 | 2088024.3237700001 | 37.7136362375916 | -122.42239234634899 | (37.7136362375916, -122.422392346349) |
| 13106 | 13106 | 108782 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 2055 Sunnydale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005606.4158 | 2088034.4515 | 37.713662477117 | -122.422489201534 | (37.713662477117, -122.422489201534) |
| 17867 | 17867 | 98680 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 26614 | 26614 | 98657 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | 5x5 | 6002607.56666 | 2119218.5959900003 | 37.7991170337862 | -122.43508328318701 | (37.7991170337862, -122.435083283187) | ||
| 29249 | 29249 | 60892 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/11/1983 12:00:00 AM | 16 | 5x5 | Permit Number 20677 | 6008514.66964 | 2119698.45237 | 37.8007682484075 | -122.414676612845 | (37.8007682484075, -122.414676612845) |
| 29352 | 29352 | 110960 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5x5 | 6008419.49323 | 2119686.5094 | 37.8007301081687 | -122.415005118088 | (37.8007301081687, -122.415005118088) | ||
| 31571 | 31571 | 98656 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002629.88193 | 2119221.45898 | 37.799126161900396 | -122.435006269744 | (37.7991261619004, -122.435006269744) | ||
| 33468 | 33468 | 95148 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 5988724.779619999 | 2113566.5271900003 | 37.78279998730721 | -122.482707449869 | (37.7827999873072, -122.482707449869) | |||
| 33915 | 33915 | 98646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.799195144410795 | -122.43451871576099 | (37.7991951444108, -122.434518715761) | ||
| 41129 | 41129 | 95156 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 21 | 5988717.78601 | 2113765.0163 | 37.7833445754979 | -122.48274619510799 | (37.7833445754979, -122.482746195108) | |||
| 41571 | 41571 | 95149 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 15 | 5988721.12033 | 2113580.3815900004 | 37.7828378146839 | -122.48272112492901 | (37.7828378146839, -122.482721124929) | |||
| 42751 | 42751 | 108789 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 44207 | 44207 | 98648 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002730.0885 | 2119237.75472 | 37.7991765949935 | -122.434660687245 | (37.7991765949935, -122.434660687245) | ||
| 52422 | 52422 | 34688 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 7 | 3x3 | Permit Number 38352 | 6002815.38185 | 2119347.35443 | 37.7994823689702 | -122.434373383533 | (37.7994823689702, -122.434373383533) |
| 53064 | 53064 | 98650 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 11 | 5x5 | 6002693.158 | 2119231.9709099997 | 37.799158617543604 | -122.43478806542801 | (37.7991586175436, -122.434788065428) | ||
| 60314 | 60314 | 95147 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 13 | 5988726.59645 | 2113538.2792 | 37.7827225319963 | -122.48269909375901 | (37.7827225319963, -122.482699093759) | |||
| 61243 | 61243 | 34693 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002813.73545 | 2119366.57801 | 37.799535058456 | -122.43438045581301 | (37.799535058456, -122.434380455813) |
| 63647 | 63647 | 95150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 5988721.361169999 | 2113591.74757 | 37.7828690364709 | -122.482721124926 | (37.7828690364709, -122.482721124926) | |||
| 67897 | 67897 | 110959 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5x5 | 6008435.0253800005 | 2119688.1206900002 | 37.800735405160296 | -122.414951484348 | (37.8007354051603, -122.414951484348) | ||
| 69128 | 69128 | 98649 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 16 | 5x5 | 6002707.76445 | 2119233.0203 | 37.799162328147794 | -122.434737597267 | (37.7991623281478, -122.434737597267) | ||
| 70878 | 70878 | 95154 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 5988718.8555 | 2113711.8550400003 | 37.783198671909794 | -122.48273859805 | (37.7831986719098, -122.48273859805) | |||
| 71504 | 71504 | 98651 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2110 Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 23 | 5x5 | 6002674.17203 | 2119228.66956 | 37.799148474973705 | -122.434853527066 | (37.7991484749737, -122.434853527066) | ||
| 72275 | 72275 | 110957 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 5x5 | 6008462.007069999 | 2119690.6551900003 | 37.800743880377205 | -122.41485829568998 | (37.8007438803772, -122.41485829569) | ||
| 73429 | 73429 | 34690 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) |
| 73786 | 73786 | 94516 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.9473599996 | 37.753402573178896 | -122.39867255379299 | (37.7534025731789, -122.398672553793) | ||
| 73832 | 73832 | 110956 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 5x5 | 6008474.06115 | 2119692.72385 | 37.800750237701294 | -122.414816729923 | (37.8007502377013, -122.414816729923) | ||
| 74427 | 74427 | 67860 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/20/1993 12:00:00 AM | 5 | 5x5 | Permit Number 31536 | 6002806.21719 | 2119247.92289 | 37.7992088356751 | -122.43439798360501 | (37.7992088356751, -122.434397983605) |
| 78104 | 78104 | 92958 | Permitted Site 1 | Tree(s) :: 17 | 300 Seneca Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 81163 | 81163 | 104152 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 81722 | 81722 | 104155 | Permitted Site 1 | :: 54 | 525X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 82210 | 82210 | 108786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 84872 | 84872 | 108785 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 84977 | 84977 | 98681 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 87723 | 87723 | 43903 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) | |
| 88992 | 88992 | 98678 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 89609 | 89609 | 79386 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2355 Folsom St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10/30/2009 12:00:00 AM | Permit Number 53016 | 6008491.21757684 | 2104497.38565881 | 37.7590284322587 | -122.4136819767 | (37.7590284322587, -122.4136819767) | |||
| 92729 | 92729 | 98679 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 92935 | 92935 | 104156 | Permitted Site 1 | :: 54 | 525X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 94772 | 94772 | 98675 | Permitted Site 1 | Tree(s) :: 17 | 199X Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 95375 | 95375 | 98676 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 95495 | 95495 | 104151 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 95556 | 95556 | 104158 | Permitted Site 1 | :: 54 | 525X Church St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 96077 | 96077 | 104157 | Permitted Site 1 | :: 54 | 525X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 97683 | 97683 | 98677 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 99997 | 99997 | 108787 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 100074 | 100074 | 43904 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 101631 | 101631 | 94927 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 325 Sanchez St | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/07/2010 12:00:00 AM | 3x3 | Permit Number 53976 | 6003898.0 | 2106263.7 | 37.7636193068731 | -122.42969346968599 | (37.7636193068731, -122.429693469686) | |||
| 105652 | 105652 | 98659 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2110 Greenwich St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 20 | 7x7 | 6002683.8 | 2119245.6 | 37.799195508176105 | -122.434821422435 | (37.7991955081761, -122.434821422435) | ||
| 111986 | 111986 | 108780 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 2055 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6006878.58529 | 2087505.45215 | 37.7122816418905 | -122.418054633195 | (37.7122816418905, -122.418054633195) |
| 113603 | 113603 | 104154 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 115759 | 115759 | 92960 | Permitted Site 1 | Tree(s) :: 17 | 300 Seneca Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 116407 | 116407 | 92806 | Permitted Site 1 | Tree(s) :: 17 | 2355 Folsom St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10/30/2009 12:00:00 AM | Permit Number 53016 | 6008199.4 | 2104720.1 | 37.7596235634815 | -122.414706984191 | (37.7596235634815, -122.414706984191) | |||
| 117184 | 117184 | 98682 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 120054 | 120054 | 95152 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 5988720.65561 | 2113620.6282200003 | 37.7829482935383 | -122.482725682965 | (37.7829482935383, -122.482725682965) | |||
| 131687 | 131687 | 98655 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | 5x5 | 6002650.75991 | 2119226.56813 | 37.799141375727295 | -122.434934390513 | (37.7991413757273, -122.434934390513) | ||
| 133902 | 133902 | 34692 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 9 | 3x3 | Permit Number 38352 | 6002825.2019 | 2119271.55666 | 37.7992748054477 | -122.434333980647 | (37.7992748054477, -122.434333980647) |
| 139294 | 139294 | 92959 | Permitted Site 1 | Tree(s) :: 17 | 300 Seneca Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 139752 | 139752 | 92963 | Permitted Site 1 | Tree(s) :: 17 | 1515 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53121 | 5988690.8 | 2100920.9 | 37.7480765758445 | -122.481898390884 | (37.7480765758445, -122.481898390884) | ||
| 141475 | 141475 | 104153 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x17 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 142924 | 142924 | 108788 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
| 144074 | 144074 | 92957 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 145041 | 145041 | 92956 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Seneca Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/23/2009 12:00:00 AM | 20 | 3x3 | Permit Number 53118 | 5999177.1 | 2091098.3 | 37.721710307674606 | -122.444931280306 | (37.7217103076746, -122.444931280306) | |
| 146100 | 146100 | 43905 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 146991 | 146991 | 95155 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 5988718.098730001 | 2113738.3311400004 | 37.7832713237769 | -122.482743157022 | (37.7832713237769, -122.482743157022) | |||
| 151441 | 151441 | 70932 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 14 | 5988727.46903 | 2113517.2675099997 | 37.7826648905872 | -122.48269453478301 | (37.7826648905872, -122.482694534783) | ||
| 152078 | 152078 | 110955 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 5x5 | 6008486.881990001 | 2119694.39066 | 37.8007555347125 | -122.41477248237699 | (37.8007555347125, -122.414772482377) | ||
| 153048 | 153048 | 98645 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 5x5 | 6002788.88101 | 2119245.38589 | 37.799200885676605 | -122.434457791187 | (37.7992008856766, -122.434457791187) | ||
| 159681 | 159681 | 73495 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/11/1995 12:00:00 AM | 10 | 5988730.14838 | 2113498.62278 | 37.7826138532986 | -122.482683898749 | (37.7826138532986, -122.482683898749) | ||
| 161870 | 161870 | 98647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | ||
| 163336 | 163336 | 95153 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 5988721.4522400005 | 2113658.22406 | 37.783051567455004 | -122.482725682991 | (37.783051567455, -122.482725682991) | |||
| 166820 | 166820 | 110958 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 940 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x5 | 6008447.06762 | 2119689.6105 | 37.8007401724743 | -122.414909918573 | (37.8007401724743, -122.414909918573) | ||
| 166994 | 166994 | 34691 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 10 | 3x3 | Permit Number 38352 | 6002820.98316 | 2119293.45008 | 37.7993346796145 | -122.43435014504699 | (37.7993346796145, -122.434350145047) |
| 176592 | 176592 | 34689 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.79943447017929 | -122.434367321195 | (37.7994344701793, -122.434367321195) |
| 183769 | 183769 | 95151 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 250 23rd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 13 | 5988720.99449 | 2113605.53219 | 37.7829068638151 | -122.482723403965 | (37.7829068638151, -122.482723403965) | |||
| 10282 | 10282 | 173941 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3750 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 6004590.0 | 2105440.0 | 37.7613967828987 | -122.42724138037701 | (37.7613967828987, -122.427241380377) | ||||
| 15372 | 15372 | 116055 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/30/2016 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.40328006754801 | (37.7611252557522, -122.403280067548) | |
| 24331 | 24331 | 116062 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2100x 19th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 22 | 3x3 | 6011361.02056 | 2105129.82914 | 37.7609257168785 | -122.40380128939199 | (37.7609257168785, -122.403801289392) | ||
| 24594 | 24594 | 115551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 18x7 | 6015277.41921 | 2104189.44931 | 37.7585616474178 | -122.39019037219299 | (37.7585616474178, -122.390190372193) | ||
| 25232 | 25232 | 116051 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 650x Kansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 4x4 | 6011500.28754 | 2105307.1354099996 | 37.761420339490705 | -122.40333209689699 | (37.7614203394907, -122.403332096897) | ||
| 30215 | 30215 | 116049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 650x Kansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 4x4 | 6011498.3385 | 2105356.0244 | 37.761554468880206 | -122.403342277248 | (37.7615544688802, -122.403342277248) | ||
| 35622 | 35622 | 116053 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 650x Kansas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 4x4 | 6011508.109619999 | 2105241.51829 | 37.761240606399795 | -122.40330042728901 | (37.7612406063998, -122.403300427289) | ||
| 42976 | 42976 | 113471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 46988 | 46988 | 116060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | ||
| 55870 | 55870 | 108611 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2025x Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 1 | 3x3 | 6008581.83386 | 2119799.52206 | 37.8010495338737 | -122.414451351572 | (37.8010495338737, -122.414451351572) | ||
| 58238 | 58238 | 116047 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 650x Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11 | 5x12 | 6011496.1211 | 2105415.8281900003 | 37.761718552879 | -122.403354153666 | (37.761718552879, -122.403354153666) | ||
| 63146 | 63146 | 75990 | Undocumented 2 | Acer saccharinum :: Silver Maple 273 | 350 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 10/07/1995 12:00:00 AM | 3 | 3x3 | 6011912.57037 | 2118781.03793 | 37.7984395708796 | -122.40285383475599 | (37.7984395708796, -122.402853834756) | |
| 63419 | 63419 | 106952 | Undocumented 2 | Tree(s) :: 17 | 399X SOMERSET ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 6009953.0 | 2092875.0 | 37.7271978698015 | -122.40780687976499 | (37.7271978698015, -122.407806879765) | ||||
| 64195 | 64195 | 116061 | Undocumented 2 | Melaleuca spp :: Melaleuca spp 130 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | ||
| 65849 | 65849 | 116063 | Undocumented 2 | Brachychiton discolor :: 440 | 2100x 19th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 19 | 3x3 | 6011332.66531 | 2105125.78364 | 37.760913024731295 | -122.403899073603 | (37.7609130247313, -122.403899073603) | ||
| 77944 | 77944 | 95496 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5986002.12653 | 2111683.71465 | 37.7774715436696 | -122.491987885766 | (37.7774715436696, -122.491987885766) | |||
| 77973 | 77973 | 95480 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986567.36684 | 2111939.07455 | 37.7782057127303 | -122.490051346189 | (37.7782057127303, -122.490051346189) | ||
| 78146 | 78146 | 95448 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986572.26887 | 2111788.56268 | 37.777792736173794 | -122.49002331517599 | (37.7777927361738, -122.490023315176) | ||
| 79513 | 79513 | 95519 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5985993.74648 | 2111883.3180400003 | 37.7780191077803 | -122.49203157445 | (37.7780191077803, -122.49203157445) | |||
| 79819 | 79819 | 95474 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986559.68186 | 2112141.60911 | 37.7787613662348 | -122.490092832202 | (37.7787613662348, -122.490092832202) | ||
| 80122 | 80122 | 98749 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 540X Eureka St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6001522.2 | 2102674.7 | 37.7536299686816 | -122.437653552201 | (37.7536299686816, -122.437653552201) | ||||
| 80252 | 80252 | 102194 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 80671 | 80671 | 102030 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 165X Chattanooga St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6004753.0 | 2102714.0 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");