Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119 | 119 | 251215 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | ||||
| 746 | 746 | 251371 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 786 | 786 | 251369 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 390 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6011351.0 | 2111108.0 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | |||
| 939 | 939 | 13046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 534 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x3 | 6009764.2975 | 2120561.184 | 37.8032072253646 | -122.41041331411199 | (37.8032072253646, -122.410413314112) | |||
| 1042 | 1042 | 21994 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2585 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x6 | 6015909.89309 | 2103367.8988900003 | 37.756340904732596 | -122.387945645479 | (37.7563409047326, -122.387945645479) | |||
| 1383 | 1383 | 26841 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | ||
| 1579 | 1579 | 588 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008688.10488 | 2102161.42262 | 37.7526254609089 | -122.412835893087 | (37.7526254609089, -122.412835893087) | |||
| 1766 | 1766 | 251688 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 925 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008132.0 | 2115128.0 | 37.788197407905 | -122.415677021756 | (37.788197407905, -122.415677021756) | ||||
| 2214 | 2214 | 4695 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 850X Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 4x8 | 6008940.69941 | 2120350.9777900004 | 37.802583847399 | -122.41324853649999 | (37.802583847399, -122.4132485365) | |||
| 2585 | 2585 | 6246 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1280 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004721.4422 | 2113335.3655 | 37.7830829720913 | -122.427349228935 | (37.7830829720913, -122.427349228935) | |||
| 2824 | 2824 | 124729 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 3591 | 3591 | 21679 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1809 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003858.3353 | 2114554.3239 | 37.7863810745889 | -122.430422226637 | (37.7863810745889, -122.430422226637) | |||
| 3698 | 3698 | 20141 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1001 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002903.1358 | 2111776.1473 | 37.7786987467479 | -122.433528357436 | (37.7786987467479, -122.433528357436) | |||
| 3917 | 3917 | 253597 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010453.0 | 2107072.0 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | ||||
| 4268 | 4268 | 2729 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2250 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002744.1445 | 2114802.6476 | 37.7869997310528 | -122.434294799469 | (37.7869997310528, -122.434294799469) | |||
| 4532 | 4532 | 253201 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4536 | 4536 | 253202 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4541 | 4541 | 253199 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4545 | 4545 | 253200 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Private 3 | 6x6 | 6003064.0 | 2109976.0 | 37.77376511482 | -122.43284323125299 | (37.77376511482, -122.432843231253) | |||
| 4548 | 4548 | 253634 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 830 Oak St | 1 | Sidewalk: Property side : Cutout 5 | tree 3 | DPW 2 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | |||||
| 4562 | 4562 | 253642 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010361.39347 | 2118971.94152 | 37.7988770104459 | -122.40823488063499 | (37.7988770104459, -122.408234880635) | ||||
| 4854 | 4854 | 253694 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 536 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005450.0 | 2111168.0 | 37.7771730951376 | -122.42467448311199 | (37.7771730951376, -122.424674483112) | ||||
| 4859 | 4859 | 253693 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 536 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005450.0 | 2111168.0 | 37.7771730951376 | -122.42467448311199 | (37.7771730951376, -122.424674483112) | ||||
| 5108 | 5108 | 124732 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 5465 | 5465 | 7223 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1234X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003286.8961 | 2111743.0712 | 37.7786296939692 | -122.432198419662 | (37.7786296939692, -122.432198419662) | |||
| 5755 | 5755 | 124730 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 5973 | 5973 | 12978 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 300 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6010840.9455 | 2120711.3367 | 37.803679804278104 | -122.40669811093099 | (37.8036798042781, -122.406698110931) | |||
| 6433 | 6433 | 13039 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 515-519 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009909.1781 | 2120541.7464 | 37.8031619752733 | -122.409910575369 | (37.8031619752733, -122.409910575369) | |||
| 6653 | 6653 | 124728 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 6680 | 6680 | 112268 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 6704 | 6704 | 112269 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 7170 | 7170 | 4704 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 940 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6008705.2823 | 2120549.3769 | 37.803115382163206 | -122.414077244448 | (37.8031153821632, -122.414077244448) | |||
| 7811 | 7811 | 124731 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 7941 | 7941 | 124727 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 198X Division St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 9032 | 9032 | 173593 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9033 | 9033 | 173592 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9040 | 9040 | 173594 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9043 | 9043 | 173595 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 75 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015060.0 | 2116254.0 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | ||||
| 9046 | 9046 | 44757 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 480 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43870 | 6003593.00847933 | 2105481.98628904 | 37.7614556341181 | -122.430692553071 | (37.7614556341181, -122.430692553071) | ||||
| 9701 | 9701 | 173642 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 657 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012793.0 | 2114089.0 | 37.78560546361629 | -122.39947767317301 | (37.7856054636163, -122.399477673173) | ||||
| 9862 | 9862 | 173716 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 1652 Fell St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5999516.0 | 2109850.0 | 37.7732172801378 | -122.445107222354 | (37.7732172801378, -122.445107222354) | |||||
| 9938 | 9938 | 27712 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 175X Otis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | |||
| 9990 | 9990 | 173774 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2239 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002625.0 | 2107043.0 | 37.7656869095489 | -122.434152085943 | (37.7656869095489, -122.434152085943) | ||||
| 9993 | 9993 | 173772 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2235 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002649.0 | 2107045.0 | 37.7656937631635 | -122.434069218237 | (37.7656937631635, -122.434069218237) | ||||
| 10016 | 10016 | 173777 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 89 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001439.0 | 2105287.0 | 37.760797980712205 | -122.438128392537 | (37.7607979807122, -122.438128392537) | ||||
| 10023 | 10023 | 173776 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 89 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001439.0 | 2105287.0 | 37.760797980712205 | -122.438128392537 | (37.7607979807122, -122.438128392537) | ||||
| 10025 | 10025 | 173773 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2235 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002649.0 | 2107045.0 | 37.7656937631635 | -122.434069218237 | (37.7656937631635, -122.434069218237) | ||||
| 10044 | 10044 | 120656 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 160 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10045 | 10045 | 120661 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10058 | 10058 | 120660 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 126 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10065 | 10065 | 120663 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10066 | 10066 | 120655 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 160 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10073 | 10073 | 120662 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 299X Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778623 | 6015082.0 | 2115536.0 | 37.7897059122539 | -122.3916595384 | (37.7897059122539, -122.3916595384) | |||
| 10130 | 10130 | 173876 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009764.0 | 2087931.0 | 37.7136120890563 | -122.408111727364 | (37.7136120890563, -122.408111727364) | ||||
| 10165 | 10165 | 173892 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007185.0 | 2099410.0 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | ||||
| 10172 | 10172 | 173891 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007185.0 | 2099410.0 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | ||||
| 10210 | 10210 | 173906 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6005854.79213 | 2118988.3638299997 | 37.7986687249765 | -122.423830387644 | (37.7986687249765, -122.423830387644) | |||||
| 10252 | 10252 | 173934 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9x9 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | ||||
| 10998 | 10998 | 112267 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 11026 | 11026 | 173949 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1306 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999102.0 | 2105133.0 | 37.760241947595404 | -122.446199926833 | (37.7602419475954, -122.446199926833) | ||||
| 12922 | 12922 | 173948 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1300 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999106.0 | 2105162.0 | 37.7603218028196 | -122.446188178838 | (37.7603218028196, -122.446188178838) | ||||
| 17517 | 17517 | 653 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3255X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 3 | 4x4 | 6007260.4251 | 2102038.7621 | 37.752208423697205 | -122.41776437753201 | (37.7522084236972, -122.417764377532) | |||
| 17596 | 17596 | 17025 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1109 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001571.2304 | 2109724.9634 | 37.772991052563704 | -122.43798896281 | (37.7729910525637, -122.43798896281) | |||
| 17885 | 17885 | 102456 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007790.0 | 2104415.0 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | |||
| 18014 | 18014 | 113224 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 4244 23RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001623.0 | 2102374.0 | 37.752810049427794 | -122.437283434624 | (37.7528100494278, -122.437283434624) | ||||
| 18363 | 18363 | 94569 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100@ Cole Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998051.0 | 2107197.0 | 37.765849093366796 | -122.449983584058 | (37.7658490933668, -122.449983584058) | ||||
| 18408 | 18408 | 17037 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1200X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001158.18128 | 2109720.4277 | 37.7729551007398 | -122.439417421896 | (37.7729551007398, -122.439417421896) | |||
| 18683 | 18683 | 108105 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2390X Green St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | |||||
| 19024 | 19024 | 4603 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | |||
| 19352 | 19352 | 20113 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 800X OAK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002934.0 | 2109937.0 | 37.773650656395205 | -122.43329013413602 | (37.7736506563952, -122.433290134136) | |||
| 19468 | 19468 | 6756 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | Permit Number 769095 | 6017521.099066501 | 2096743.3718321999 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | ||
| 19501 | 19501 | 117186 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 201x GREENWICH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6011833.0 | 2120374.0 | 37.80280901508429 | -122.40324129087 | (37.8028090150843, -122.40324129087) | ||||
| 19675 | 19675 | 103628 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.768764440650294 | -122.42141735000799 | (37.7687644406503, -122.421417350008) | ||
| 19751 | 19751 | 96542 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | ||||
| 19843 | 19843 | 99594 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1855X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014349.8 | 2099426.2 | 37.7454312840379 | -122.393065244865 | (37.7454312840379, -122.393065244865) | |||
| 20082 | 20082 | 111807 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 20099 | 20099 | 615 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3134X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6008105.608030001 | 2102127.9045700002 | 37.752500715042295 | -122.414847903135 | (37.7525007150423, -122.414847903135) | |||
| 20379 | 20379 | 9943 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | |||
| 20384 | 20384 | 104821 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2173 15TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003063.7 | 2107068.1 | 37.7657807169148 | -122.43263651234301 | (37.7657807169148, -122.432636512343) | |||||
| 20651 | 20651 | 115057 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 20740 | 20740 | 16969 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 770 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003329.8686 | 2110020.1015 | 37.773901282351105 | -122.431926699871 | (37.7739012823511, -122.431926699871) | |||
| 20818 | 20818 | 603 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3085 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008454.62539 | 2102106.73452 | 37.752462191692295 | -122.413639440921 | (37.7524621916923, -122.413639440921) | |||
| 20843 | 20843 | 111792 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6010857.0 | 2110997.0 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | ||||
| 21788 | 21788 | 17003 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | |||
| 27180 | 27180 | 21626 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004833.69671 | 2114745.4452299997 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | |||
| 27184 | 27184 | 117402 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 28450 | 28450 | 104230 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 409 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14x8 | 5998587.6 | 2115205.6 | 37.787869332154 | -122.44870447955601 | (37.787869332154, -122.448704479556) | ||||
| 34299 | 34299 | 16935 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 542 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004164.66828 | 2110140.85762 | 37.7742801386068 | -122.429047601533 | (37.7742801386068, -122.429047601533) | |||
| 37389 | 37389 | 95036 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | ||||
| 41076 | 41076 | 117048 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2183 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6002170.0 | 2114323.0 | 37.78565013631621 | -122.436246868292 | (37.7856501363162, -122.436246868292) | |||
| 42747 | 42747 | 115058 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 499X BRANNAN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013762.0 | 2111312.0 | 37.7780344196247 | -122.39593052209601 | (37.7780344196247, -122.395930522096) | ||||
| 43174 | 43174 | 117400 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 43364 | 43364 | 115743 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X POND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Rec/Park 7 | 28 | 3x3 | 6003250.0 | 2106477.0 | 37.764168263011996 | -122.43194992880301 | (37.764168263012, -122.431949928803) | ||
| 44347 | 44347 | 224728 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1110 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | Permit Number 771820 | 6009984.63313 | 2102660.33541 | 37.754068053508 | -122.40838743973801 | (37.754068053508, -122.408387439738) | ||
| 44578 | 44578 | 17305 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 51X Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | |||
| 44837 | 44837 | 95043 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW for City Agency 10 | 9 | 3x3 | 6001388.0 | 2119447.0 | 37.79967484547421 | -122.43931976889999 | (37.7996748454742, -122.4393197689) | |||
| 49227 | 49227 | 15149 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | |||
| 49233 | 49233 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 610 Brannan St | 1 | unknown : Cutout 12 | Tree 1 | Private 1 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.39955535858401 | (37.7766267904106, -122.399555358584) | ||||
| 49589 | 49589 | 104825 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 45 Prosper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003350.0 | 2106266.0 | 37.763594576550496 | -122.431588992909 | (37.7635945765505, -122.431588992909) | |||
| 49591 | 49591 | 110708 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2999X Turk St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) |
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");