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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44052 | 44052 | 46958 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 85268 | 85268 | 46950 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 86769 | 86769 | 46964 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 88512 | 88512 | 46967 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 5 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 88649 | 88649 | 46953 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 6 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 89109 | 89109 | 46955 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 4 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 89418 | 89418 | 76344 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 12 | 3x30 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 90893 | 90893 | 46948 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 3 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 91304 | 91304 | 76222 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 5 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 93081 | 93081 | 46957 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 93345 | 93345 | 46960 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 95663 | 95663 | 76252 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 8 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 97074 | 97074 | 46962 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 6 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 98630 | 98630 | 46965 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 100272 | 100272 | 46952 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 118208 | 118208 | 46949 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 5 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 119652 | 119652 | 46951 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 120283 | 120283 | 46961 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1530 43rd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 120521 | 120521 | 46966 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/01/2002 12:00:00 AM | 8 | 3x20 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) |
| 142732 | 142732 | 76271 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 8 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 144911 | 144911 | 76325 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 5 | 3x20 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
| 23340 | 23340 | 76382 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 25 | 3x12 | 5983091.4072 | 2104771.8049 | 37.7583228530818 | -122.501545408351 | (37.7583228530818, -122.501545408351) | |
| 23276 | 23276 | 76755 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | |
| 23355 | 23355 | 76748 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 1501X 42nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 7 | 3x12 | 5983093.5463 | 2104693.1195 | 37.7581069307926 | -122.501532189631 | (37.7581069307926, -122.501532189631) | |
| 23245 | 23245 | 76756 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1501X 42nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 2 | 3x12 | 5983095.0741 | 2104639.3384 | 37.757959352781 | -122.501522927406 | (37.757959352781, -122.501522927406) | |
| 23164 | 23164 | 76784 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1501X 42nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 1 | 3x12 | 5983097.2131 | 2104562.028 | 37.7577472058325 | -122.50150981087799 | (37.7577472058325, -122.501509810878) | |
| 23240 | 23240 | 76785 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501X 42nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 24 | 3x12 | 5983097.8243 | 2104541.5546 | 37.757691027540005 | -122.501506182606 | (37.75769102754, -122.501506182606) | |
| 10264 | 10264 | 92961 | DPW Maintained 3 | Tree(s) :: 17 | 2051 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53120 | 5985698.5 | 2101265.4 | 37.748848003369005 | -122.49227087024799 | (37.748848003369, -122.492270870248) | ||
| 10265 | 10265 | 92962 | DPW Maintained 3 | Tree(s) :: 17 | 2051 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53120 | 5985698.5 | 2101265.4 | 37.748848003369005 | -122.49227087024799 | (37.748848003369, -122.492270870248) | ||
| 98898 | 98898 | 117252 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 2 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 112260 | 112260 | 117251 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 1 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 142324 | 142324 | 117253 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2500x 34TH AVE | 3 | Side Yard : Yard 17 | Tree 1 | SFUSD 4 | 3x3 | 5985829.0 | 2097874.0 | 37.73954376030179 | -122.491570003273 | (37.7395437603018, -122.491570003273) | ||||
| 93185 | 93185 | 95510 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 500X 32nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:35:00 PM | 3 | 3x3 | 5985969.9 | 2112493.2 | 37.7796922752829 | -122.49215898451901 | (37.7796922752829, -122.492158984519) | ||
| 144522 | 144522 | 95498 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X 32nd Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 18 | 3x3 | 5985976.055430001 | 2112422.37376 | 37.779498166536605 | -122.492132474117 | (37.7794981665366, -122.492132474117) | |||
| 87843 | 87843 | 95499 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X 32nd Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 18 | 3x3 | 5985977.73249 | 2112402.27637 | 37.7794430828921 | -122.49212519236 | (37.7794430828921, -122.49212519236) | |||
| 138850 | 138850 | 95501 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5985979.29593 | 2112362.71829 | 37.7793345591202 | -122.492116870392 | (37.7793345591202, -122.492116870392) | |||
| 93918 | 93918 | 95500 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5985980.30461 | 2112381.8602 | 37.779387176289504 | -122.49211479078899 | (37.7793871762895, -122.492114790789) | |||
| 115612 | 115612 | 95502 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X 32nd Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5985980.32699 | 2112340.5385 | 37.7792737200362 | -122.49211167004499 | (37.7792737200362, -122.492111670045) | |||
| 106045 | 106045 | 95504 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600X 32nd Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5985982.4173 | 2112269.2292400002 | 37.779078047402294 | -122.492099187045 | (37.7790780474023, -122.492099187045) | |||
| 107506 | 107506 | 95505 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5985982.87909 | 2112248.55872 | 37.7790213190615 | -122.49209606719299 | (37.7790213190615, -122.492096067193) | |||
| 112176 | 112176 | 95508 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5985983.44854 | 2112162.31032 | 37.7787845389083 | -122.49208774521799 | (37.7787845389083, -122.492087745218) | |||
| 108047 | 108047 | 95503 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 8 | 3x3 | 5985983.49633 | 2112291.6636099997 | 37.7791397088392 | -122.49209710655701 | (37.7791397088392, -122.492097106557) | |||
| 102729 | 102729 | 95507 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5985983.58763 | 2112182.96811 | 37.778841267423296 | -122.492088785464 | (37.7788412674233, -122.492088785464) | |||
| 124241 | 124241 | 95506 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 600X 32nd Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3X3 | 5985984.4170699995 | 2112207.80318 | 37.7789095059085 | -122.49208774520001 | (37.7789095059085, -122.4920877452) | |||
| 112142 | 112142 | 95511 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:32:00 PM | 3 | 3x3 | 5985988.37339 | 2112068.78219 | 37.7785280252799 | -122.492063820389 | (37.7785280252799, -122.492063820389) | ||
| 108571 | 108571 | 95509 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:37:00 PM | 3 | 3x3 | 5985988.58257 | 2112092.73248 | 37.7785937981587 | -122.492064860632 | (37.7785937981587, -122.492064860632) | ||
| 139550 | 139550 | 95513 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985988.88946 | 2112008.2856099997 | 37.7783619491242 | -122.49205757976002 | (37.7783619491242, -122.49205757976) | |||
| 119730 | 119730 | 95512 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5985990.17986 | 2112026.52369 | 37.7784121011104 | -122.49205445901698 | (37.7784121011104, -122.492054459017) | |||
| 120188 | 120188 | 95514 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | ||
| 101527 | 101527 | 95518 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5985992.056890001 | 2111902.81718 | 37.778072548088495 | -122.49203885528601 | (37.7780725480885, -122.492038855286) | |||
| 96578 | 96578 | 95515 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985992.57608 | 2111969.58011 | 37.7782558903759 | -122.492041976045 | (37.7782558903759, -122.492041976045) | |||
| 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) | |||
| 142332 | 142332 | 95517 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5985993.99278 | 2111923.13747 | 37.778128454962 | -122.49203365493601 | (37.778128454962, -122.492033654936) | |||
| 107004 | 107004 | 95516 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5 | 3x3 | 5985994.45155 | 2111944.6872400003 | 37.778187651292896 | -122.492033654948 | (37.7781876512929, -122.492033654948) | |||
| 93377 | 93377 | 95497 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5985999.2312900005 | 2111660.71954 | 37.777408236422296 | -122.491996207782 | (37.7774082364223, -122.491996207782) | |||
| 96802 | 96802 | 95494 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986000.13497 | 2111717.2940599998 | 37.7775636267397 | -122.491997248036 | (37.7775636267397, -122.491997248036) | |||
| 110535 | 110535 | 95495 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X 32nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986000.954969999 | 2111699.3103 | 37.7775142963957 | -122.49199308703699 | (37.7775142963957, -122.491993087037) | |||
| 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) | |||
| 124692 | 124692 | 95484 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986002.98697 | 2111639.37953 | 37.777349862368496 | -122.491981644298 | (37.7773498623685, -122.491981644298) | |||
| 123561 | 123561 | 95485 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 10 | 3x3 | 5986006.6183 | 2111569.83262 | 37.777159118639496 | -122.49196396094601 | (37.7771591186395, -122.491963960946) | |||
| 117880 | 117880 | 95486 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986007.39345 | 2111549.75354 | 37.777104032517705 | -122.49195980083701 | (37.7771040325177, -122.491959800837) | |||
| 141798 | 141798 | 95490 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986007.65609 | 2111463.21002 | 37.7768664240251 | -122.49195251911199 | (37.7768664240251, -122.491952519112) | |||
| 91382 | 91382 | 95488 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986007.7101 | 2111508.12486 | 37.776989750535 | -122.491955639862 | (37.776989750535, -122.491955639862) | |||
| 140987 | 140987 | 95489 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986007.8525 | 2111486.5622099997 | 37.7769305539658 | -122.49195355936199 | (37.7769305539658, -122.491953559362) | |||
| 111692 | 111692 | 95487 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986008.46306 | 2111529.3689900003 | 37.777048124873296 | -122.49195459962401 | (37.7770481248733, -122.491954599624) | |||
| 94030 | 94030 | 95491 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.776807227327396 | -122.491945237383 | (37.7768072273274, -122.491945237383) | |||
| 139255 | 139255 | 95493 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600X 32nd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986013.17376 | 2111397.5149 | 37.77668636645139 | -122.491928594282 | (37.7766863664514, -122.491928594282) | |||
| 129223 | 129223 | 95492 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6 | 3x3 | 5986013.6325199995 | 2111419.06509 | 37.7767455639501 | -122.491928594276 | (37.7767455639501, -122.491928594276) | |||
| 83482 | 83482 | 95466 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 529X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 5986555.1 | 2112324.8 | 37.7792640886788 | -122.490122160768 | (37.7792640886788, -122.490122160768) | ||
| 84174 | 84174 | 95453 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986555.22372 | 2112267.25724 | 37.7791060998783 | -122.49011749902701 | (37.7791060998783, -122.490117499027) | ||
| 100398 | 100398 | 95454 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986556.01855 | 2112243.67907 | 37.7790414073553 | -122.49011301465099 | (37.7790414073553, -122.490113014651) | ||
| 114491 | 114491 | 95467 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 533X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986556.1 | 2112298.0 | 37.779190561911896 | -122.490116729573 | (37.7791905619119, -122.490116729573) | ||
| 107741 | 107741 | 95468 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 535X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 53267 | 5986556.7 | 2112284.6 | 37.7791538043677 | -122.49011366804301 | (37.7791538043677, -122.490113668043) |
| 88215 | 88215 | 95470 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 539X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986557.7 | 2112257.8 | 37.7790802775989 | -122.49010823686399 | (37.7790802775989, -122.490108236864) | ||
| 104766 | 104766 | 95472 | 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 | 5986558.09049 | 2112203.93573 | 37.7789324044573 | -122.49010292295799 | (37.7789324044573, -122.490102922958) | ||
| 142922 | 142922 | 95471 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | 5986558.17112 | 2112222.9767400003 | 37.778984690357 | -122.49010404497 | (37.778984690357, -122.49010404497) | ||
| 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) | ||
| 96989 | 96989 | 95473 | 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 | 5986560.12785 | 2112162.57896 | 37.778818969517495 | -122.490092832211 | (37.7788189695175, -122.490092832211) | ||
| 124700 | 124700 | 95475 | 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 | 5986561.73612 | 2112070.55828 | 37.7785664008394 | -122.490080498329 | (37.7785664008394, -122.490080498329) | ||
| 118859 | 118859 | 95476 | 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 | 5986563.84754 | 2112047.92011 | 37.778504366165 | -122.490071528655 | (37.778504366165, -122.490071528655) | ||
| 122089 | 122089 | 95477 | 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 | 5986565.00775 | 2112026.27031 | 37.7784449897253 | -122.490065922262 | (37.7784449897253, -122.490065922262) | ||
| 84851 | 84851 | 95479 | 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 | 10 | 3x3 | 5986565.4115 | 2111984.30283 | 37.7783297825409 | -122.490061437893 | (37.7783297825409, -122.490061437893) | ||
| 95866 | 95866 | 95478 | 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 | 5986565.85749 | 2112005.2728 | 37.7783873861575 | -122.49006143788601 | (37.7783873861575, -122.490061437886) | ||
| 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) | ||
| 85371 | 85371 | 95482 | 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 | 5986568.36529 | 2111879.34223 | 37.7780417630679 | -122.49004349761299 | (37.7780417630679, -122.490043497613) | ||
| 115273 | 115273 | 95481 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | |
| 118347 | 118347 | 95483 | 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 | 5 | 3x3 | 5986569.82886 | 2111856.71768 | 37.777979727950296 | -122.490036770148 | (37.7779797279503, -122.490036770148) | ||
| 98627 | 98627 | 99346 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 32 | 5x5 | 5986570.64094 | 2113156.51142 | 37.7815486383406 | -122.49012959305401 | (37.7815486383406, -122.490129593054) | ||
| 78240 | 78240 | 99345 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 450 30th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 4x4 | 5986571.27659 | 2113136.01167 | 37.7814923890114 | -122.490125885703 | (37.7814923890114, -122.490125885703) | ||
| 94177 | 94177 | 95450 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986571.54012 | 2111769.53516 | 37.777740449455294 | -122.49002443626999 | (37.7777404494553, -122.49002443627) | ||
| 124223 | 124223 | 99344 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986571.83486 | 2113111.88593 | 37.781426179231204 | -122.49012217925899 | (37.7814261792312, -122.490122179259) | ||
| 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) | ||
| 124734 | 124734 | 95452 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986573.32223 | 2111731.4109099996 | 37.7776358751612 | -122.490015466607 | (37.7776358751612, -122.490015466607) | ||
| 85197 | 85197 | 99341 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 4x5 | 5986573.71046 | 2113038.86406 | 37.7812257915862 | -122.49011031791001 | (37.7812257915862, -122.49011031791) | ||
| 111525 | 111525 | 99343 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 450 30th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 24 | 3x3 | 5986574.07493 | 2113086.2305799997 | 37.781355867791 | -122.490112542148 | (37.781355867791, -122.490112542148) | ||
| 83563 | 83563 | 95451 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 601X 30th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 5986574.08529 | 2111752.05161 | 37.777692593218106 | -122.49001434550101 | (37.7776925932181, -122.490014345501) | ||
| 107292 | 107292 | 99342 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 5986574.23671 | 2113063.60704 | 37.7812937594666 | -122.49011031789301 | (37.7812937594666, -122.490110317893) | ||
| 95801 | 95801 | 99340 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 30 | 6x8 | 5986575.04866 | 2113011.09375 | 37.7811496204005 | -122.49010364520299 | (37.7811496204005, -122.490103645203) | ||
| 83153 | 83153 | 95455 | 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 | 5986575.69735 | 2111690.69221 | 37.777524211869896 | -122.490004254704 | (37.7775242118699, -122.490004254704) | ||
| 107984 | 107984 | 95456 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986576.02446 | 2111660.34524 | 37.7774409068096 | -122.49000089052099 | (37.7774409068096, -122.490000890521) |
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");