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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | |
| 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) |
| 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) | ||
| 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) | ||
| 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) |
| 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) | |
| 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) |
| 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) |
| 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) |
| 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) |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 153533 | 153533 | 117710 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 477 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5983117.17834 | 2112671.33055 | 37.7800141944428 | -122.502040811752 | (37.7800141944428, -122.502040811752) | |||
| 32455 | 32455 | 118090 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6909 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5985513.83516 | 2112457.38253 | 37.779567259959 | -122.493734048085 | (37.779567259959, -122.493734048085) | |||
| 71320 | 71320 | 119536 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 871 30th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5986636.85825 | 2109986.6532900003 | 37.772848973963 | -122.489667337074 | (37.772848973963, -122.489667337074) | |||
| 36554 | 36554 | 120353 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5988483.640819999 | 2114700.0523900003 | 37.7858982939261 | -122.48362481032801 | (37.7858982939261, -122.483624810328) | |||
| 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) | |||
| 155902 | 155902 | 123062 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 472 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991906.84489 | 2112217.36307 | 37.7792801711752 | -122.471600599763 | (37.7792801711752, -122.471600599763) | |||
| 134887 | 134887 | 124232 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Paramount Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 5996415.548690001 | 2110976.74716 | 37.7761335815126 | -122.455913502291 | (37.7761335815126, -122.455913502291) | |||
| 46303 | 46303 | 135920 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2495 Filbert St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001110.697980001 | 2118617.5430900003 | 37.797381591353606 | -122.440219818601 | (37.7973815913536, -122.440219818601) | |||
| 61746 | 61746 | 135921 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2495 Filbert St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001125.354069999 | 2118620.11363 | 37.797389483787 | -122.440169289291 | (37.797389483787, -122.440169289291) | |||
| 179105 | 179105 | 135935 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997049.33252 | 2116083.6644599997 | 37.7901921806791 | -122.45409001393999 | (37.7901921806791, -122.45409001394) | |||
| 158254 | 158254 | 135936 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Spruce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997050.12682 | 2116069.05064 | 37.7901521005919 | -122.45408620982501 | (37.7901521005919, -122.454086209825) | |||
| 55051 | 55051 | 135961 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2600 Divisadero St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000735.77189 | 2117237.48779 | 37.793570969586895 | -122.44141807800399 | (37.7935709695869, -122.441418078004) | |||
| 76088 | 76088 | 135974 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2266 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6003300.9204 | 2117230.69268 | 37.793698110328 | -122.43254197714701 | (37.793698110328, -122.432541977147) | |||
| 158748 | 158748 | 135990 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Myrtle St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6007019.38816 | 2114166.0331200003 | 37.7854934765818 | -122.41945820564301 | (37.7854934765818, -122.419458205643) | |||
| 155352 | 155352 | 178968 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1029 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008554.00356 | 2086922.9270900001 | 37.710776304465 | -122.412222721805 | (37.710776304465, -122.412222721805) | |||
| 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) | |||
| 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) | |||
| 167930 | 167930 | 178995 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Wanda St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000596.67394 | 2091620.93611 | 37.7232262634584 | -122.440061656639 | (37.7232262634584, -122.440061656639) | |||
| 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) | |||
| 174660 | 174660 | 178999 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002140.71576 | 2089748.47374 | 37.7181726806159 | -122.434590385445 | (37.7181726806159, -122.434590385445) | |||
| 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) | |||
| 172419 | 172419 | 179017 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 27 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000125.72789 | 2088561.8694099998 | 37.714799938735 | -122.441470215282 | (37.714799938735, -122.441470215282) | |||
| 164925 | 164925 | 179022 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 947 Olmstead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008892.678069999 | 2090361.86972 | 37.7202379269127 | -122.411294959597 | (37.7202379269127, -122.411294959597) | |||
| 153219 | 153219 | 179023 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 947 Olmstead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008910.54006 | 2090367.6054099998 | 37.7202546776964 | -122.411233621349 | (37.7202546776964, -122.411233621349) | |||
| 40440 | 40440 | 179026 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 376 Ordway St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010795.80251 | 2090029.68717 | 37.7194323753865 | -122.40469308234199 | (37.7194323753865, -122.404693082342) | |||
| 51106 | 51106 | 179030 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010311.02154 | 2088780.05452 | 37.715974033352 | -122.406280800329 | (37.715974033352, -122.406280800329) | |||
| 162049 | 162049 | 179042 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2913 20th Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5990217.2226599995 | 2095888.7019900002 | 37.7343481135815 | -122.476252619576 | (37.7343481135815, -122.476252619576) | |||
| 71278 | 71278 | 179062 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Colonial Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000439.3413 | 2093583.9176599998 | 37.7286072022493 | -122.44074626284201 | (37.7286072022493, -122.440746262842) | |||
| 154585 | 154585 | 179063 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Colonial Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000420.96554 | 2093594.54688 | 37.7286353411305 | -122.440810550888 | (37.7286353411305, -122.440810550888) | |||
| 186561 | 186561 | 179064 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000355.465580001 | 2091781.1110900003 | 37.7236523325845 | -122.440906950114 | (37.7236523325845, -122.440906950114) | |||
| 183451 | 183451 | 179086 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 146 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003896.054690001 | 2092965.8387900002 | 37.7271063470709 | -122.42875216298201 | (37.7271063470709, -122.428752162982) | |||
| 45195 | 45195 | 179089 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004232.136580001 | 2092904.6382099998 | 37.7269573195072 | -122.427585973436 | (37.7269573195072, -122.427585973436) | |||
| 134466 | 134466 | 179119 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 621 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008944.10696 | 2093176.6835 | 37.7279696962286 | -122.411315930896 | (37.7279696962286, -122.411315930896) |
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");