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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 671 | 671 | 225029 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4543 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 17041 | 6000793.7951 | 2105198.47261 | 37.7605181908718 | -122.44035351451099 | (37.7605181908718, -122.440353514511) | |
| 1369 | 1369 | 121635 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 506 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | 5992560.0 | 2111978.0 | 37.778660711296794 | -122.46932365779699 | (37.7786607112968, -122.469323657797) | ||
| 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) | ||||
| 2095 | 2095 | 58908 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 353 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1980 12:00:00 AM | 13 | 3x3 | Permit Number 780019 | 6009109.47745 | 2109280.29041 | 37.7721958858688 | -122.41188171506501 | (37.7721958858688, -122.411881715065) | |
| 2588 | 2588 | 56931 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1909 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 17 | Permit Number 14175 | 6004317.92538 | 2118019.6979799997 | 37.795922137343 | -122.429079333669 | (37.795922137343, -122.429079333669) | ||
| 2631 | 2631 | 105340 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1401 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 12 | Permit Number 770950 | 6000144.5 | 2113810.0 | 37.784126280525605 | -122.44321763524201 | (37.7841262805256, -122.443217635242) | ||
| 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) | ||||
| 2875 | 2875 | 53666 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1630 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1994 12:00:00 AM | 17 | 3x3 | Permit Number 772472 | 6006654.5213 | 2116532.6022 | 37.7919709328888 | -122.420888619402 | (37.7919709328888, -122.420888619402) |
| 2914 | 2914 | 225015 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 157 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780170 | 6002699.8255900005 | 2104972.04176 | 37.7600048066089 | -122.433745251143 | (37.7600048066089, -122.433745251143) | |
| 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) | |||
| 3707 | 3707 | 253520 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 3713 | 3713 | 253521 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2626 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6006643.0 | 2120264.0 | 37.8022157634914 | -122.42119356191999 | (37.8022157634914, -122.42119356192) | ||
| 4449 | 4449 | 59787 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1755 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | Permit Number 19237 | 6004552.42886001 | 2119092.68520918 | 37.7988815571833 | -122.428344419585 | (37.7988815571833, -122.428344419585) | ||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 8669 | 8669 | 21630 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1615 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1990 12:00:00 AM | 6 | 4X4 | 6004701.1521 | 2114671.0024 | 37.786749150584996 | -122.427514608894 | (37.786749150585, -122.427514608894) | ||
| 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) | ||||
| 9044 | 9044 | 55522 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 484 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | Permit Number 11483 | 6003594.27279224 | 2105459.16759406 | 37.7613930510814 | -122.430686551957 | (37.7613930510814, -122.430686551957) | |||
| 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) | ||||
| 9804 | 9804 | 59226 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 530 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779363 | 5992552.44717 | 2111818.61025 | 37.7782226338783 | -122.469338181035 | (37.7782226338783, -122.469338181035) | ||
| 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) | |||||
| 9915 | 9915 | 59271 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2017 12:00:00 AM | 3 | Permit Number 18607 | 6004280.88948873 | 2109181.36087728 | 37.7716521728269 | -122.428577162778 | (37.7716521728269, -122.428577162778) | ||
| 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) | ||||
| 10207 | 10207 | 58902 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 15 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1980 12:00:00 AM | Permit Number 18176 | 6005036.25199829 | 2101622.63318287 | 37.7509404143338 | -122.425426308198 | (37.7509404143338, -122.425426308198) | |||
| 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) | ||||
| 10260 | 10260 | 45427 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | ||
| 10266 | 10266 | 45428 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |||
| 10267 | 10267 | 45426 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 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) | ||||
| 13244 | 13244 | 113373 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 88 HOWARD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2015 12:00:00 AM | 3x3 | 6014757.0 | 2116474.0 | 37.7922633974731 | -122.39284966575 | (37.7922633974731, -122.39284966575) | |||
| 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) | ||||
| 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) | |||||
| 19099 | 19099 | 34262 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3618 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | 14 | 3x3 | Permit Number 38067 | 6002793.22003166 | 2106527.80070587 | 37.7642818435653 | -122.433533428216 | (37.7642818435653, -122.433533428216) | |
| 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) | ||||
| 19551 | 19551 | 55849 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2801X Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | Permit Number 46336 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | ||
| 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) | |||
| 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) | ||||
| 22869 | 22869 | 13081 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 650-654 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2017 12:08:00 PM | 3 | 3x3 | 6009251.0552 | 2120493.5635 | 37.8029927712959 | -122.412184629201 | (37.8029927712959, -122.412184629201) | ||
| 22938 | 22938 | 110472 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 477 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x10 | 6005542.0 | 2111298.0 | 37.77753523894629 | -122.424365474196 | (37.7775352389463, -122.424365474196) | ||
| 22981 | 22981 | 116011 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1448 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 6000920.0 | 2110390.8 | 37.7747822166773 | -122.44028940195601 | (37.7747822166773, -122.440289401956) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 50078 | 50078 | 7238 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1085 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4X4 | 6003353.84267 | 2112023.38614 | 37.7794031644909 | -122.43198684768801 | (37.7794031644909, -122.431986847688) | |||
| 50412 | 50412 | 111774 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 215 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5998260.0 | 2109886.0 | 37.773244358342296 | -122.449454468346 | (37.7732443583423, -122.449454468346) | |||
| 51254 | 51254 | 120965 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1145x Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003243.0 | 2101623.0 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | ||||
| 51311 | 51311 | 110985 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 54782 | 54782 | 17106 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1777 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5998507.83576 | 2109285.1679 | 37.771608801349394 | -122.448553894841 | (37.7716088013494, -122.448553894841) | |||
| 58674 | 58674 | 102786 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | ||
| 58723 | 58723 | 116509 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500x Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2016 12:00:00 AM | 3 | 3x3 | 5998488.0 | 2108327.0 | 37.7689767823615 | -122.448553488995 | (37.7689767823615, -122.448553488995) | ||
| 58966 | 58966 | 110983 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||||
| 62742 | 62742 | 100053 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003300.0 | 2119605.0 | 37.800217292537106 | -122.432714848025 | (37.8002172925371, -122.432714848025) | |||
| 65719 | 65719 | 99967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2270 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
| 65794 | 65794 | 115992 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 438 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | Permit Number 778644 | 5989723.9 | 2112354.3 | 37.7795296278249 | -122.47916224845301 | (37.7795296278249, -122.479162248453) | ||
| 66011 | 66011 | 108152 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003295.44003 | 2116396.66877 | 37.791407783491294 | -122.432501340527 | (37.7914077834913, -122.432501340527) | |||||
| 66021 | 66021 | 485 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6010468.2249 | 2102315.4128099997 | 37.7531480416193 | -122.40669074837099 | (37.7531480416193, -122.406690748371) | |||
| 66642 | 66642 | 4609 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 316 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774670 | 6010771.0363 | 2118706.95943 | 37.7981723635161 | -122.406798689949 | (37.7981723635161, -122.406798689949) | |
| 71075 | 71075 | 106808 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 10 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 772884 | 5998469.3 | 2110801.2 | 37.7757692329232 | -122.44879640789101 | (37.7757692329232, -122.448796407891) | |||
| 72158 | 72158 | 116028 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1500 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006937.0 | 2117734.0 | 37.7952855901943 | -122.419996533467 | (37.7952855901943, -122.419996533467) | ||||
| 72207 | 72207 | 101715 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 72212 | 72212 | 40354 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) |
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");