Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24823 | 24823 | 47425 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 754 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45336 | 5984176.15569 | 2110679.3098400002 | 37.7746068364777 | -122.49823022658701 | (37.7746068364777, -122.498230226587) | |
| 25348 | 25348 | 50499 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 608 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 5 | Permit Number 47136 | 6002721.49496 | 2090080.38174 | 37.719116979545795 | -122.432606577246 | (37.7191169795458, -122.432606577246) | |
| 30074 | 30074 | 47440 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 859 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 5 | Permit Number 45351 | 5982914.18523 | 2109947.95579 | 37.7725246733221 | -122.50254141771099 | (37.7725246733221, -122.502541417711) | |
| 36163 | 36163 | 66052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2153 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1990 12:00:00 AM | 5 | Permit Number 29091 | 6000458.6364 | 2120609.1379299997 | 37.8028128355005 | -122.442619184653 | (37.8028128355005, -122.442619184653) | ||
| 38950 | 38950 | 32086 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3928 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 5 | Permit Number 35459 | 6003448.93768 | 2104799.28963 | 37.759572949446394 | -122.431142104137 | (37.7595729494464, -122.431142104137) | |
| 41835 | 41835 | 36752 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2579 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 5 | Permit Number 41197 | 6002410.05116 | 2116400.74901 | 37.7913687394284 | -122.435565056287 | (37.7913687394284, -122.435565056287) | |
| 44234 | 44234 | 40656 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 5 | Permit Number 47919 | 6004682.83135 | 2093737.6135099998 | 37.729269967531295 | -122.42608720287501 | (37.7292699675313, -122.426087202875) | |
| 44613 | 44613 | 64863 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 77 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 5 | Permit Number 25879 | 5995882.63467 | 2112271.55178 | 37.7796581724444 | -122.45785070123999 | (37.7796581724444, -122.45785070124) | |
| 48200 | 48200 | 31194 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 354 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46596 | 5993258.721390001 | 2089558.71458 | 37.7171434272164 | -122.46527761436899 | (37.7171434272164, -122.465277614369) | |
| 48211 | 48211 | 73744 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 5 | 5995854.8721 | 2112478.1679599998 | 37.7802238906314 | -122.45796169978998 | (37.7802238906314, -122.45796169979) | ||
| 50848 | 50848 | 50228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 741 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 5 | Permit Number 46935 | 5987844.86264 | 2110914.45258 | 37.775466905732706 | -122.485556863724 | (37.7754669057327, -122.485556863724) | |
| 56131 | 56131 | 49551 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1084REVISED Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2003 12:00:00 AM | 5 | Permit Number 46441 | 6009968.28689 | 2111507.46699 | 37.7783593364429 | -122.40906818514601 | (37.7783593364429, -122.409068185146) | ||
| 60883 | 60883 | 68231 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 257 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 5 | Permit Number 32026 | 5990849.231930001 | 2113671.85139 | 37.7832125496886 | -122.475365506488 | (37.7832125496886, -122.475365506488) | |
| 64152 | 64152 | 37966 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 456 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013485.30445 | 2104964.69116 | 37.7605907284002 | -122.396442696467 | (37.7605907284002, -122.396442696467) | |
| 65515 | 65515 | 103235 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 116 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2013 12:00:00 AM | 5 | Permit Number 770114 | 5998278.0 | 2110273.0 | 37.7743079905046 | -122.44942009353998 | (37.7743079905046, -122.44942009354) | ||
| 67388 | 67388 | 46777 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 San Juan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44869 | 6001762.9966400005 | 2091991.0449700002 | 37.7243088277709 | -122.436056382001 | (37.7243088277709, -122.436056382001) | |
| 69577 | 69577 | 246688 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Stoneman St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6008021.86099 | 2099397.11663 | 37.7449978780651 | -122.41494425378 | (37.7449978780651, -122.41494425378) | ||||
| 70594 | 70594 | 41410 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 531 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 5 | Permit Number 42023 | 6007957.48629 | 2088255.0601400002 | 37.714400574992204 | -122.414378624292 | (37.7144005749922, -122.414378624292) | ||
| 73503 | 73503 | 37967 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 456 Missouri St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40197 | 6013486.4792599995 | 2104950.0016 | 37.76055045945989 | -122.396437603638 | (37.7605504594599, -122.396437603638) | |
| 74471 | 74471 | 43214 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 365 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 43005 | 6008676.285 | 2094499.96863 | 37.7315881292836 | -122.41233529443899 | (37.7315881292836, -122.412335294439) | |
| 74882 | 74882 | 48418 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | 5 | Permit Number 45796 | 6001083.868919999 | 2118658.4276799997 | 37.7974923221726 | -122.440315587421 | (37.7974923221726, -122.440315587421) | |
| 76069 | 76069 | 237116 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Hwy 101 Southbound | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6005840.35144 | 2109000.46624 | 37.7712436090254 | -122.423170022474 | (37.7712436090254, -122.423170022474) | ||||
| 123729 | 123729 | 42840 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1828 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 5 | Permit Number 42772 | 6008289.65137 | 2118753.27916 | 37.7981603934451 | -122.415388321908 | (37.7981603934451, -122.415388321908) | |
| 125051 | 125051 | 45479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3008 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 5 | Permit Number 44261 | 5990293.0566 | 2095176.19647 | 37.732396152147295 | -122.475938421626 | (37.7323961521473, -122.475938421626) | |
| 129707 | 129707 | 48506 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | 5 | Permit Number 45843 | 6001715.61599 | 2087735.00145 | 37.71261999108761 | -122.43591578108999 | (37.7126199910876, -122.43591578109) | ||
| 131344 | 131344 | 50296 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3052 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 5 | Permit Number 47008 | 5990299.81493 | 2094981.9607400002 | 37.7318632220065 | -122.47590087674101 | (37.7318632220065, -122.475900876741) | |
| 136726 | 136726 | 32208 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1779 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 5 | Permit Number 35530 | 6009365.92876 | 2099185.56999 | 37.744492451861205 | -122.41028175730601 | (37.7444924518612, -122.410281757306) | |
| 150010 | 150010 | 57783 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1977 12:00:00 AM | 5 | Permit Number 16708 | 6010300.606980001 | 2110589.59695 | 37.7758576905205 | -122.407853819819 | (37.7758576905205, -122.407853819819) | ||
| 151473 | 151473 | 78234 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 5 | 5999806.62934 | 2090324.19629 | 37.7196207041996 | -122.44269961461 | (37.7196207041996, -122.44269961461) | ||
| 156325 | 156325 | 33812 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 261 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/1996 12:00:00 AM | 5 | Permit Number 37827 | 6006136.86682 | 2110893.01835 | 37.776456830551 | -122.42227884741501 | (37.776456830551, -122.422278847415) | |
| 156953 | 156953 | 43260 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43042 | 6010210.47935 | 2092211.96475 | 37.7253917248338 | -122.40687006131 | (37.7253917248338, -122.40687006131) | |
| 162769 | 162769 | 37773 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 611 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 5 | Permit Number 40111 | 6009477.59682 | 2092948.39833 | 37.7273727802074 | -122.409455529449 | (37.7273727802074, -122.409455529449) | |
| 163282 | 163282 | 31057 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34809 | 6002747.277969999 | 2087115.5773200002 | 37.7109777400017 | -122.43230582505 | (37.7109777400017, -122.43230582505) | |
| 175579 | 175579 | 64857 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 21 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 5 | Permit Number 25873 | 5995838.9792599995 | 2112526.25675 | 37.780355016559504 | -122.458020161226 | (37.7803550165595, -122.458020161226) | |
| 185776 | 185776 | 50300 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2917 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | 5 | Permit Number 47010 | 5989048.80024 | 2095796.1569299998 | 37.7340261814504 | -122.480285417057 | (37.7340261814504, -122.480285417057) | |
| 189115 | 189115 | 53052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2517@ SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 5 | Permit Number 49029 | 6001372.258169999 | 2117256.0832 | 37.7936582667653 | -122.439217122188 | (37.7936582667653, -122.439217122188) | |
| 112154 | 112154 | 12805 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2099 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2003 12:00:00 AM | 5 | 3X3 | 5989075.33471 | 2114664.85982 | 37.7858360879126 | -122.48157515850401 | (37.7858360879126, -122.481575158504) | ||
| 12764 | 12764 | 83412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52320 | 6003991.38049 | 2093029.1643599998 | 37.727285619722295 | -122.428427134505 | (37.7272856197223, -122.428427134505) |
| 13759 | 13759 | 109718 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013027.725819999 | 2089252.6527099998 | 37.7174232872231 | -122.396923644015 | (37.7174232872231, -122.396923644015) | |||
| 41693 | 41693 | 91420 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 770 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52101 | 5990400.3408699995 | 2110139.21584 | 37.7734868781795 | -122.47666030039301 | (37.7734868781795, -122.476660300393) | ||
| 53191 | 53191 | 102037 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 60427 | 60427 | 88580 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 474 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51522 | 5989397.97956 | 2112106.21746 | 37.778829528805794 | -122.480271570948 | (37.7788295288058, -122.480271570948) | ||
| 65877 | 65877 | 94102 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53477 | 6009512.5875699995 | 2093214.72689 | 37.7281060226502 | -122.409353352981 | (37.7281060226502, -122.409353352981) | |
| 67866 | 67866 | 92826 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2009 12:00:00 AM | 5 | 3x3 | Permit Number 53040 | 5991610.35704 | 2110282.0512900003 | 37.7739491753353 | -122.47248513397899 | (37.7739491753353, -122.472485133979) | ||
| 73837 | 73837 | 103051 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 400X Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6005072.0 | 2110257.0 | 37.774650355650394 | -122.42591724231501 | (37.7746503556504, -122.425917242315) | |||
| 80258 | 80258 | 82918 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52501 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | |
| 85693 | 85693 | 96953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 32951 | 5988418.13148 | 2110571.74898 | 37.7745593211999 | -122.483548684419 | (37.7745593211999, -122.483548684419) | ||
| 87806 | 87806 | 102038 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 99512 | 99512 | 50872 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 764 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | 5 | 3x3 | Permit Number 47382 | 5993527.27631 | 2110282.90436 | 37.774062282603005 | -122.46585430594101 | (37.774062282603, -122.465854305941) | |
| 101061 | 101061 | 113808 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4101x 25TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
| 101603 | 101603 | 68962 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | 3x3 | Permit Number 32951 | 5988444.16962 | 2110572.72123 | 37.7745635062345 | -122.483458685783 | (37.7745635062345, -122.483458685783) |
| 103524 | 103524 | 84660 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 816 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6001872.13741629 | 2101710.47895055 | 37.751002338731 | -122.436374389271 | (37.751002338731, -122.436374389271) |
| 112881 | 112881 | 96952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 32951 | 5988431.28084 | 2110571.1656 | 37.7745584847462 | -122.483503155986 | (37.7745584847462, -122.483503155986) | ||
| 113773 | 113773 | 84575 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3972-3976 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003353.44622149 | 2101877.75687686 | 37.7515457024264 | -122.431263818404 | (37.7515457024264, -122.431263818404) |
| 124779 | 124779 | 102039 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 133299 | 133299 | 88377 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 458 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51355 | 5991270.95609 | 2112280.85053 | 37.7794176810179 | -122.47380501423599 | (37.7794176810179, -122.473805014236) | ||
| 136747 | 136747 | 95687 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 245 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767434 | 6009837.968859999 | 2093325.23198 | 37.728427671491104 | -122.40823628438801 | (37.7284276714911, -122.408236284388) |
| 139217 | 139217 | 103052 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 400X Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6005072.0 | 2110257.0 | 37.774650355650394 | -122.42591724231501 | (37.7746503556504, -122.425917242315) | |||
| 141114 | 141114 | 121594 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68X Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6002713.0 | 2095655.0 | 37.7344231446599 | -122.433034012036 | (37.7344231446599, -122.433034012036) | |||
| 146079 | 146079 | 102036 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 154459 | 154459 | 30576 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 268 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52597 | 6003988.43817 | 2108723.63607 | 37.770378817350604 | -122.429556120021 | (37.7703788173506, -122.429556120021) | |
| 156227 | 156227 | 52875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118@ BEACH Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48887 | 6001367.786590001 | 2121129.52184 | 37.8042934541427 | -122.439510392889 | (37.8042934541427, -122.439510392889) | |
| 169580 | 169580 | 84326 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 728 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53994 | 5987888.08845 | 2110995.2066599997 | 37.7756911522049 | -122.48541326443899 | (37.7756911522049, -122.485413264439) |
| 171204 | 171204 | 109721 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91x Jennings Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012983.30026 | 2089217.1759900001 | 37.717323402237 | -122.39707471754299 | (37.717323402237, -122.397074717543) | |||
| 182553 | 182553 | 88408 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.794287243625604 | -122.411401815264 | (37.7942872436256, -122.411401815264) | |
| 182777 | 182777 | 49699 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 87@ TUCKER Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50825 | 6011128.67682 | 2088300.86402 | 37.7147039774881 | -122.403420891467 | (37.7147039774881, -122.403420891467) | |
| 26028 | 26028 | 78318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 605 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | 3x6 | 6008900.368419999 | 2091273.5690900001 | 37.722741693447105 | -122.411332749116 | (37.7227416934471, -122.411332749116) | |
| 13234 | 13234 | 82735 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 174 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769757 | 6003803.82611 | 2092820.0296 | 37.726700767200896 | -122.429060604385 | (37.7267007672009, -122.429060604385) |
| 111406 | 111406 | 27310 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2140 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2014 12:00:00 AM | 5 | 5 | 5988795.04874 | 2114709.3 | 37.7859418063725 | -122.4825481157 | (37.7859418063725, -122.4825481157) | ||
| 58542 | 58542 | 43804 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | 6x5 | Permit Number 43434 | 5988398.115730001 | 2114095.5575599996 | 37.7842335442368 | -122.483876359267 | (37.7842335442368, -122.483876359267) |
| 40048 | 40048 | 214790 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valdez Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5995727.44967 | 2095481.9792400002 | 37.7335493555041 | -122.45717268576401 | (37.7335493555041, -122.457172685764) | |||
| 2424 | 2424 | 239429 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 565 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 5 | Width 2ft | Permit Number 51470 | 6001213.70363 | 2103034.08129 | 37.7545991976029 | -122.438746149019 | (37.7545991976029, -122.438746149019) | |
| 24527 | 24527 | 214750 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995612.00037 | 2093456.6914400002 | 37.7279817741139 | -122.457425350319 | (37.7279817741139, -122.457425350319) | |||
| 26826 | 26826 | 239412 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 615 27th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002538.56212 | 2100033.91802 | 37.7464367420653 | -122.433950001585 | (37.7464367420653, -122.433950001585) | |||
| 38148 | 38148 | 237309 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 211 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009018.3172 | 2097311.07667 | 37.739326012187 | -122.411351334505 | (37.739326012187, -122.411351334505) | |||
| 38174 | 38174 | 214754 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995607.36531 | 2093372.70982 | 37.7277509145579 | -122.457435300396 | (37.7277509145579, -122.457435300396) | |||
| 41005 | 41005 | 196503 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 351 Tehama St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6011737.82052 | 2112830.87734 | 37.7820920832107 | -122.40303978397499 | (37.7820920832107, -122.403039783975) | |||
| 42755 | 42755 | 178970 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008583.66239 | 2086910.8267599999 | 37.7107447436356 | -122.412119359132 | (37.7107447436356, -122.412119359132) | |||
| 45979 | 45979 | 196501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 351 Tehama St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6011701.40176 | 2112798.07009 | 37.7819999683719 | -122.403163468629 | (37.7819999683719, -122.403163468629) | |||
| 46943 | 46943 | 238057 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 413 Lily St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6004461.64769 | 2109967.10473 | 37.7738198618406 | -122.42800791104099 | (37.7738198618406, -122.428007911041) | |||
| 51769 | 51769 | 178969 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008570.63643 | 2086915.27252 | 37.710756219889 | -122.412164693966 | (37.710756219889, -122.412164693966) | |||
| 52601 | 52601 | 218243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Wawona St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5992077.34134 | 2097249.8857 | 37.7381932756065 | -122.46992071879299 | (37.7381932756065, -122.469920718793) | |||
| 53778 | 53778 | 239415 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1331 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003277.56126 | 2100489.89633 | 37.7477306623461 | -122.43142717303499 | (37.7477306623461, -122.431427173035) | |||
| 54786 | 54786 | 238038 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Elgin Park | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6005844.524569999 | 2108573.0044 | 37.7700701367551 | -122.423125198471 | (37.7700701367551, -122.423125198471) | |||
| 56890 | 56890 | 178996 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Wanda St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000569.64733 | 2091569.3239400003 | 37.72308300956121 | -122.440151382899 | (37.7230830095612, -122.440151382899) | |||
| 56919 | 56919 | 239433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Carrie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002800.77676 | 2095592.1026 | 37.7342554213364 | -122.43272604769399 | (37.7342554213364, -122.432726047694) | |||
| 56998 | 56998 | 238518 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 218 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002025.02718 | 2096169.5718200002 | 37.7357969924364 | -122.43544935400699 | (37.7357969924364, -122.435449354007) | |||
| 57124 | 57124 | 213298 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 769 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994373.81571 | 2089911.00711 | 37.7181749819741 | -122.461448817305 | (37.7181749819741, -122.461448817305) | |||
| 59195 | 59195 | 237324 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 141 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6009324.726 | 2096749.59433 | 37.7378014841462 | -122.41025227214199 | (37.7378014841462, -122.410252272142) | |||
| 60897 | 60897 | 237343 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 475 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007573.28307 | 2096600.4423099998 | 37.7372936135946 | -122.41629731529 | (37.7372936135946, -122.41629731529) | |||
| 63695 | 63695 | 214742 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995645.35981 | 2093675.42483 | 37.7285842794183 | -122.457325843925 | (37.7285842794183, -122.457325843925) | |||
| 68445 | 68445 | 196459 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1760 Cesar Chavez St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6013796.36432 | 2101069.01684 | 37.7499113519264 | -122.395093999398 | (37.7499113519264, -122.395093999398) | |||
| 68855 | 68855 | 237344 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007638.07716 | 2096593.9745599998 | 37.7372794978562 | -122.416072833696 | (37.7372794978562, -122.416072833696) | |||
| 74234 | 74234 | 214735 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Westwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995155.65804 | 2092771.31144 | 37.72607366365639 | -122.458953324553 | (37.7260736636564, -122.458953324553) | |||
| 105064 | 105064 | 238514 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 319 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004352.554830001 | 2096356.5109 | 37.736442199342704 | -122.42741548983801 | (37.7364421993427, -122.427415489838) | |||
| 116490 | 116490 | 237349 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1327 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008183.5398699995 | 2097707.7987599997 | 37.7403684685413 | -122.414265694627 | (37.7403684685413, -122.414265694627) | |||
| 130078 | 130078 | 214794 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 290 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995480.84421 | 2097515.15227 | 37.739117784956605 | -122.458172366777 | (37.7391177849566, -122.458172366777) | |||
| 131581 | 131581 | 214736 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995136.59009 | 2093647.8547099999 | 37.728479343838394 | -122.459082682125 | (37.7284793438384, -122.459082682125) | |||
| 131840 | 131840 | 179002 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 500 Paris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001822.18343 | 2090679.74768 | 37.7207116627863 | -122.43575800674 | (37.7207116627863, -122.43575800674) | |||
| 133641 | 133641 | 196482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012916.33928 | 2095157.16046 | 37.733629664074705 | -122.39772257563 | (37.7336296640747, -122.39772257563) |
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");