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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92501 | 92501 | 97725 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | |||
| 92726 | 92726 | 97722 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 117800 | 117800 | 97724 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 128722 | 128722 | 97723 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | ||
| 89310 | 89310 | 66890 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/07/2005 12:00:00 AM | 6 | 3x3 | Permit Number 45482 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 90552 | 90552 | 47255 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 05/09/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45198 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 106838 | 106838 | 102115 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | Permit Number 52469 | 6015181.7 | 2089440.8 | 37.7180595657824 | -122.389491420596 | (37.7180595657824, -122.389491420596) | |
| 129243 | 129243 | 47256 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/09/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45198 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 145918 | 145918 | 47257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1035 Gilman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52469 | 6015368.10493708 | 2089617.80548286 | 37.71855592189279 | -122.388859444456 | (37.7185559218928, -122.388859444456) |
| 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) | |
| 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) |
| 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) |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 58967 | 58967 | 96572 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 80235 | 80235 | 96569 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 81160 | 81160 | 96570 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 86907 | 86907 | 96483 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 97749 | 97749 | 96481 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 99207 | 99207 | 96568 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 101102 | 101102 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 103034 | 103034 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 180 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 109217 | 109217 | 96482 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 113578 | 113578 | 96571 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 124197 | 124197 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 138508 | 138508 | 96480 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.731037066667795 | -122.483566221845 | (37.7310370666678, -122.483566221845) | ||||
| 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) | ||
| 1794 | 1794 | 81999 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005960.45556 | 2120727.0973099996 | 37.803448808170295 | -122.423588442877 | (37.8034488081703, -122.423588442877) |
| 5294 | 5294 | 97730 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | Permit Number 50638 | 6005803.34745 | 2120703.57786 | 37.8033753605476 | -122.424130448959 | (37.8033753605476, -122.424130448959) | |
| 5699 | 5699 | 97727 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005898.3389 | 2120719.3141099997 | 37.8034239311172 | -122.42380284664699 | (37.8034239311172, -122.423802846647) | |
| 5962 | 5962 | 82000 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50638 | 6005983.68719 | 2120729.63993 | 37.803457100839296 | -122.423508229633 | (37.8034571008393, -122.423508229633) |
| 6518 | 6518 | 97735 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Francisco St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:46:00 PM | 3 | 3x3 | Permit Number 50638 | 6005694.978999999 | 2120690.49004 | 37.8033333055591 | -122.424504530974 | (37.8033333055591, -122.424504530974) |
| 7339 | 7339 | 97732 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005757.30775 | 2120698.05289 | 37.8033575908394 | -122.424289378073 | (37.8033575908394, -122.424289378073) | |
| 7419 | 7419 | 97731 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.803388983478605 | -122.42421815984501 | (37.8033889834786, -122.424218159845) | |
| 7474 | 7474 | 81997 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005918.11487 | 2120722.35908 | 37.8034334081868 | -122.42373462766001 | (37.8034334081868, -122.42373462766) |
| 7989 | 7989 | 97733 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005736.8865 | 2120695.23683 | 37.8033487055393 | -122.42435984622801 | (37.8033487055393, -122.424359846228) | |
| 8271 | 8271 | 81998 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50638 | 6005939.397969999 | 2120724.9413900003 | 37.8034416999448 | -122.42366116024999 | (37.8034416999448, -122.42366116025) |
| 8363 | 8363 | 97734 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005715.837730001 | 2120693.51258 | 37.8033427825912 | -122.424432563629 | (37.8033427825912, -122.424432563629) | |
| 8576 | 8576 | 97728 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005878.13407 | 2120716.4935 | 37.8034150458325 | -122.423872565669 | (37.8034150458325, -122.423872565669) | |
| 8881 | 8881 | 97729 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005819.00921 | 2120706.70735 | 37.80338483759171 | -122.42407647347099 | (37.8033848375917, -122.424076473471) | |
| 10126 | 10126 | 97736 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/2017 12:02:00 PM | 3 | 3x3 | Permit Number 50638 | 6005674.32361 | 2120686.81612 | 37.8033220514443 | -122.424575748272 | (37.8033220514443, -122.424575748272) |
| 104096 | 104096 | 112062 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/18/2015 12:00:00 AM | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | ||
| 120376 | 120376 | 112063 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 123118 | 123118 | 112058 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 140135 | 140135 | 112060 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 141095 | 141095 | 112061 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1199 VISITACION AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4x4 | 6009231.0 | 2087548.0 | 37.7125305915537 | -122.40992695457899 | (37.7125305915537, -122.409926954579) | |||
| 81591 | 81591 | 95239 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | |||
| 95002 | 95002 | 95237 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 9 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
| 107934 | 107934 | 95238 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | |||
| 117440 | 117440 | 95240 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
| 120777 | 120777 | 95241 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
| 121486 | 121486 | 95235 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
| 142420 | 142420 | 95236 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1220 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | ||
| 10863 | 10863 | 99498 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6002794.02408 | 2092508.7984200001 | 37.725788983259605 | -122.432529234659 | (37.7257889832596, -122.432529234659) | ||
| 11215 | 11215 | 75214 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x5 | 6002868.59368 | 2092460.8085599998 | 37.725661442297294 | -122.432268027453 | (37.7256614422973, -122.432268027453) | |
| 11694 | 11694 | 75308 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 125 Excelsior Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 10 | 4x5 | 6002852.682680001 | 2092471.3085599998 | 37.725689370766204 | -122.43232378004 | (37.7256893707662, -122.43232378004) | |
| 12293 | 12293 | 75309 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | |
| 12657 | 12657 | 75213 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 125 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 10 | 4x5 | 6002883.607340001 | 2092451.48886 | 37.7256367037627 | -122.43221546119 | (37.7256367037627, -122.43221546119) | |
| 12861 | 12861 | 75133 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x4 | 6002899.19862 | 2092441.61812 | 37.7256104849218 | -122.43216085884501 | (37.7256104849218, -122.432160858845) | |
| 21199 | 21199 | 97237 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 100052 | 100052 | 97238 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) |
| 127434 | 127434 | 97236 | Property Tree 7 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 458 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 77433 | 77433 | 31711 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1250X Shrader St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/19/1995 12:00:00 AM | 6 | 3x3 | Permit Number 35211 | 5997882.313818 | 2106467.94501531 | 37.763837639523395 | -122.450514467435 | (37.7638376395234, -122.450514467435) |
| 80701 | 80701 | 99678 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1250X Shrader St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 4x4 | Permit Number 770537 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | |
| 82347 | 82347 | 99677 | DPW Maintained 3 | Tree(s) :: 17 | 1250X Shrader St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/04/2013 12:00:00 AM | 16 | 3x3 | Permit Number 770537 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) |
| 105707 | 105707 | 99675 | DPW Maintained 3 | Tree(s) :: 17 | 1250X Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 111245 | 111245 | 99672 | DPW Maintained 3 | Shrub :: Shrub 98 | 1250X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 117464 | 117464 | 72536 | DPW Maintained 3 | Tree(s) :: 17 | 1250X Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/21/1992 12:00:00 AM | 10 | 3x3 | 5997766.5684589995 | 2106397.97443782 | 37.7636388926021 | -122.45090974788 | (37.7636388926021, -122.45090974788) | |
| 126843 | 126843 | 99674 | DPW Maintained 3 | Tree(s) :: 17 | 1250X Shrader St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 30 | 4x4 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 129440 | 129440 | 99676 | DPW Maintained 3 | Tree(s) :: 17 | 1250X Shrader St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 14 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 138394 | 138394 | 99673 | DPW Maintained 3 | Tree(s) :: 17 | 1250X Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 4x4 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 13403 | 13403 | 96770 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015623.8599 | 2095148.9526 | 37.7337575287133 | -122.388361234061 | (37.7337575287133, -122.388361234061) | |
| 14458 | 14458 | 94035 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 32 | 5x5 | 6015684.8669 | 2095240.1882 | 37.7340114236329 | -122.388156677838 | (37.7340114236329, -122.388156677838) | ||
| 15674 | 15674 | 94034 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1300X Lane St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 6015674.4242 | 2095246.7836 | 37.7340289546749 | -122.388193241926 | (37.7340289546749, -122.388193241926) | ||
| 15999 | 15999 | 94036 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/08/2012 12:00:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | |
| 16453 | 16453 | 96769 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 1 | 4x4 | 6015646.9436 | 2095179.7309 | 37.7338433188148 | -122.388283573512 | (37.7338433188148, -122.388283573512) | ||
| 77312 | 77312 | 96772 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 2 | 3x3 | 6015407.2 | 2095381.5 | 37.73438404885479 | -122.38912652987801 | (37.7343840488548, -122.389126529878) | ||
| 85372 | 85372 | 96771 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 11/08/2011 12:00:00 AM | 8 | 4x3 | 6015407.2 | 2095381.5 | 37.73438404885479 | -122.38912652987801 | (37.7343840488548, -122.389126529878) | |
| 124646 | 124646 | 96774 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015407.2 | 2095381.5 | 37.73438404885479 | -122.38912652987801 | (37.7343840488548, -122.389126529878) | |
| 10289 | 10289 | 77643 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006923.4408599995 | 2093174.3728599998 | 37.7278498138936 | -122.41830128179899 | (37.7278498138936, -122.418301281799) | |
| 10418 | 10418 | 77647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | |
| 10784 | 10784 | 77645 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006883.8507199995 | 2093162.97754 | 37.727816296176705 | -122.41843733843201 | (37.7278162961767, -122.418437338432) | |
| 11530 | 11530 | 77642 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006942.1040900005 | 2093179.9332599998 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | |
| 11692 | 11692 | 77644 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | |
| 12057 | 12057 | 77641 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006964.988919999 | 2093186.8525200002 | 37.7278864190206 | -122.418158533295 | (37.7278864190206, -122.418158533295) | |
| 12092 | 12092 | 77648 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.147419999 | 2093142.9824700002 | 37.727757638780204 | -122.418666516263 | (37.7277576387802, -122.418666516263) | |
| 13090 | 13090 | 77646 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | |
| 23202 | 23202 | 77640 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 13 | 0 | 6006980.92428 | 2093193.1114700001 | 37.7279045016753 | -122.418103887786 | (37.7279045016753, -122.418103887786) | |
| 129020 | 129020 | 77649 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
| 463 | 463 | 234072 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 4 | Width 3ft | 6011140.67766 | 2101759.7310900004 | 37.7516598624171 | -122.404326151746 | (37.7516598624171, -122.404326151746) | ||
| 1449 | 1449 | 234076 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12 | Width 4ft | 6011147.1312 | 2101589.6307 | 37.751193164657 | -122.40429186329901 | (37.751193164657, -122.404291863299) | |||
| 1454 | 1454 | 234074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 11 | Width 3ft | 6011143.5049 | 2101689.8522900003 | 37.751468148541996 | -122.40431145682301 | (37.751468148542, -122.404311456823) | |||
| 1461 | 1461 | 234073 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 17 | Width 3ft | 6011143.13167 | 2101723.71293 | 37.7515611015794 | -122.404315130536 | (37.7515611015794, -122.404315130536) | |||
| 1464 | 1464 | 234075 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 14 | Width 4ft | 6011146.17896 | 2101629.85029 | 37.75130354562771 | -122.404297986789 | (37.7513035456277, -122.404297986789) | |||
| 77788 | 77788 | 98940 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400X San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.40430583648501 | (37.7517881116631, -122.404305836485) | ||
| 93944 | 93944 | 98943 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400X San Bruno Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.40430583648501 | (37.7517881116631, -122.404305836485) | ||
| 98082 | 98082 | 98941 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400X San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6011147.5 | 2101806.3 | 37.7517881116631 | -122.40430583648501 | (37.7517881116631, -122.404305836485) |
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");