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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||
| 77880 | 77880 | 93215 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 499 Jackson St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53209 | 6011715.0 | 2118034.0 | 37.7963773511427 | -122.403484907832 | (37.7963773511427, -122.403484907832) | |||
| 81573 | 81573 | 110967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003043.0 | 2116458.0 | 37.7915618650441 | -122.43337916182101 | (37.7915618650441, -122.433379161821) | ||||
| 82045 | 82045 | 86740 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1275 02nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49708 | 5995441.8 | 2106872.8 | 37.7648092803065 | -122.458984723243 | (37.7648092803065, -122.458984723243) | |||||
| 93550 | 93550 | 105290 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 330 11TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4x4 | 5992515.1 | 2113228.4 | 37.7820913739714 | -122.469570031425 | (37.7820913739714, -122.469570031425) | ||||
| 98164 | 98164 | 112394 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2 AMAZON AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6000472.0 | 2089324.0 | 37.7169122992795 | -122.440327982322 | (37.7169122992795, -122.440327982322) | ||||
| 102090 | 102090 | 107368 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 660 OFARRELL ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008096.0 | 2114145.0 | 37.785496305176395 | -122.415731945695 | (37.7854963051764, -122.415731945695) | ||||||
| 115348 | 115348 | 106967 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1225 02ND AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995419.1 | 2107212.6 | 37.7657409782079 | -122.45908784262899 | (37.7657409782079, -122.459087842629) | ||||||
| 119002 | 119002 | 104729 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 250-252 FRANCISCO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 5x5 | 6010061.3 | 2121325.4 | 37.805322217951 | -122.409439489572 | (37.805322217951, -122.409439489572) | ||||
| 119380 | 119380 | 109326 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1624 VALLEJO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005582.1 | 2118270.7 | 37.7966828044962 | -122.424722909098 | (37.7966828044962, -122.424722909098) | |||||
| 140625 | 140625 | 104744 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 15 WAVERLY PL | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010745.5 | 2116998.1 | 37.793478820697295 | -122.406766557506 | (37.7934788206973, -122.406766557506) | ||||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||||
| 4346 | 4346 | 12986 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 312 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 06:43:00 AM | 3 | 3X3 | 6010791.3462 | 2120702.976 | 37.8036540726688 | -122.40686916312401 | (37.8036540726688, -122.406869163124) | ||
| 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) | ||
| 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) | |||
| 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) | |||||
| 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) | ||||
| 5314 | 5314 | 12245 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 501 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2015 03:15:00 PM | 3 | 5x5 | 6004995.5845 | 2110652.4736 | 37.775731910957106 | -122.426209740207 | (37.7757319109571, -122.426209740207) | ||
| 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) | |||
| 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) | |||
| 7836 | 7836 | 13005 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 383 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:59:00 AM | 3 | 3X3 | 6010464.6699 | 2120611.8662 | 37.8033856231837 | -122.407993219356 | (37.8033856231837, -122.407993219356) | ||
| 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) | ||||
| 8862 | 8862 | 13007 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 373 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 10:56:00 AM | 3 | 3x3 | 6010526.1986 | 2120617.8557 | 37.8034055135257 | -122.40778071851601 | (37.8034055135257, -122.407780718516) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |||||
| 76014 | 76014 | 9687 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 330 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2001 12:00:00 AM | 16 | 3x3 | 6006025.521509999 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | ||
| 76139 | 76139 | 94058 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1401X 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5993648.0 | 2105942.0 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | |||
| 77413 | 77413 | 94294 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 77503 | 77503 | 23131 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 610X Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/1999 12:00:00 AM | 3 | 4x4 | 6010622.643569999 | 2118948.98987 | 37.7988286159864 | -122.407329246317 | (37.7988286159864, -122.407329246317) | ||
| 77711 | 77711 | 484 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.40670053704201 | (37.7532507356841, -122.406700537042) | |||
| 77740 | 77740 | 1442 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | |||
| 77761 | 77761 | 22671 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1140X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003752.72615 | 2112639.8215900003 | 37.7811183481869 | -122.43065094190099 | (37.7811183481869, -122.430650941901) | |||
| 77911 | 77911 | 16945 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 602 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004026.09211 | 2110141.24132 | 37.7742733469863 | -122.429526989132 | (37.7742733469863, -122.429526989132) | |||
| 78183 | 78183 | 575 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3007 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008864.65035 | 2102095.7164 | 37.752454954328606 | -122.41222072226999 | (37.7524549543286, -122.41222072227) | |||
| 78264 | 78264 | 525 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009855.900330001 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | |||
| 78404 | 78404 | 108604 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 625 LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008310.7 | 2114660.6 | 37.7869240847944 | -122.41502565223101 | (37.7869240847944, -122.415025652231) | |||
| 78463 | 78463 | 115215 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778.0 | 2103691.0 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | |
| 78647 | 78647 | 9661 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6006079.1393099995 | 2110176.8838400003 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | |||
| 78842 | 78842 | 120144 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2111839.0 | 37.77916064960021 | -122.41581078056299 | (37.7791606496002, -122.415810780563) | ||||
| 78930 | 78930 | 57108 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 280 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 24 | 6x6 | Permit Number 14378 | 6004748.38429029 | 2102046.50032189 | 37.752087986316106 | -122.42645196024401 | (37.7520879863161, -122.426451960244) | |
| 78939 | 78939 | 8182 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | |||
| 78965 | 78965 | 11046 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1560 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007462.427490001 | 2117742.7343900003 | 37.795339161156605 | -122.41817908492399 | (37.7953391611566, -122.418179084924) | |||
| 79022 | 79022 | 61158 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) |
| 79069 | 79069 | 44125 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 431 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43629 | 6012046.82946857 | 2118068.4414971 | 37.796490448112 | -122.40233912369301 | (37.796490448112, -122.402339123693) |
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");