Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30204 | 30204 | 74333 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2002 12:00:00 AM | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | ||
| 90653 | 90653 | 36351 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 112 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39311 | 5995654.83604113 | 2093420.72201256 | 37.727885471049 | -122.45727466612 | (37.727885471049, -122.45727466612) | ||
| 138998 | 138998 | 36350 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 112 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39311 | 5995654.83604113 | 2093420.72201256 | 37.727885471049 | -122.45727466612 | (37.727885471049, -122.45727466612) | ||
| 86470 | 86470 | 59536 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 112 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1986 12:00:00 AM | Permit Number 23254 | 6008824.34551261 | 2098013.30354602 | 37.7412432924744 | -122.412071619145 | (37.7412432924744, -122.412071619145) | ||
| 113994 | 113994 | 34420 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 112 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38168 | 6003375.78345726 | 2096203.88784509 | 37.735967838506205 | -122.43078171061501 | (37.7359678385062, -122.430781710615) | ||
| 118957 | 118957 | 34421 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 112 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38168 | 6003375.78345726 | 2096203.88784509 | 37.735967838506205 | -122.43078171061501 | (37.7359678385062, -122.430781710615) | ||
| 109796 | 109796 | 55120 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 112 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/1972 12:00:00 AM | 15 | Permit Number 11022 | 5997123.97183158 | 2105914.83996284 | 37.76227552033671 | -122.453097398278 | (37.7622755203367, -122.453097398278) | ||
| 51435 | 51435 | 65246 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1123 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28040 | 6009230.45296658 | 2102616.7905535 | 37.753906226408 | -122.410992511898 | (37.753906226408, -122.410992511898) | ||
| 14606 | 14606 | 15049 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1125 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1999 12:00:00 AM | 25 | 8X15 | 6015485.0268 | 2096001.9904 | 37.7360921037992 | -122.388900760186 | (37.7360921037992, -122.388900760186) | ||
| 105603 | 105603 | 44525 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1125 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2001 12:00:00 AM | Permit Number 43825 | 6008743.61210523 | 2117943.22188109 | 37.7959616805463 | -122.41376014990601 | (37.7959616805463, -122.413760149906) | ||
| 133064 | 133064 | 178900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1128 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009581.67769 | 2090926.3916900002 | 37.721826605402 | -122.40895311598699 | (37.721826605402, -122.408953115987) | |||
| 106318 | 106318 | 62862 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 113 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23230 | 6008340.909435 | 2098059.21377466 | 37.7413422154251 | -122.413746421648 | (37.7413422154251, -122.413746421648) | ||
| 140048 | 140048 | 69215 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1130 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50957 | 6008626.30487399 | 2101955.77666936 | 37.752057334329294 | -122.413035069679 | (37.7520573343293, -122.413035069679) | ||
| 93642 | 93642 | 62850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 114 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23218 | 6008644.66398789 | 2098019.91095776 | 37.7412513517889 | -122.412693363275 | (37.7412513517889, -122.412693363275) | ||
| 109806 | 109806 | 43736 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 114 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43373 | 5996541.98319278 | 2090652.82083499 | 37.720336382823 | -122.45400797708 | (37.720336382823, -122.45400797708) | ||
| 75493 | 75493 | 237987 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005526.563490001 | 2096388.0227 | 37.736595053504296 | -122.423358681381 | (37.7365950535043, -122.423358681381) | |||
| 132824 | 132824 | 237988 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005544.33972 | 2096386.4343299998 | 37.736591695453896 | -122.42329710838001 | (37.7365916954539, -122.42329710838) | |||
| 151841 | 151841 | 237989 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005562.12851 | 2096385.4572 | 37.7365900164084 | -122.423235535394 | (37.7365900164084, -122.423235535394) | |||
| 177308 | 177308 | 237986 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005505.73076 | 2096390.28542 | 37.7366000906246 | -122.42343086995899 | (37.7366000906246, -122.423430869959) | |||
| 63044 | 63044 | 196410 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6009614.35227 | 2111076.8827400003 | 37.7771572198736 | -122.410262172786 | (37.7771572198736, -122.410262172786) | |||
| 171106 | 171106 | 196409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6009598.37036 | 2111065.11658 | 37.7771240168943 | -122.41031662852801 | (37.7771240168943, -122.410316628528) | |||
| 52586 | 52586 | 214452 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 115 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993881.37151 | 2099908.46331 | 37.7455971799806 | -122.463876248508 | (37.7455971799806, -122.463876248508) | |||
| 113451 | 113451 | 36352 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 115 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39312 | 5995603.96545011 | 2093439.4482819 | 37.7279339670328 | -122.457451880091 | (37.7279339670328, -122.457451880091) | ||
| 140913 | 140913 | 36353 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 115 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39312 | 5995603.96545011 | 2093439.4482819 | 37.7279339670328 | -122.457451880091 | (37.7279339670328, -122.457451880091) | ||
| 82342 | 82342 | 63149 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 115 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1986 12:00:00 AM | Permit Number 23679 | 6006308.72972245 | 2098250.05588025 | 37.7417518943702 | -122.420786544899 | (37.7417518943702, -122.420786544899) | ||
| 125923 | 125923 | 67193 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 115 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30643 | 5997981.64121917 | 2106794.49458323 | 37.764739946577 | -122.45019446502701 | (37.764739946577, -122.450194465027) | ||
| 26914 | 26914 | 245213 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1155 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001001.539 | 2109303.6237 | 37.7718017456892 | -122.439929374343 | (37.7718017456892, -122.439929374343) | |||
| 104488 | 104488 | 45135 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1155 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2001 12:00:00 AM | Permit Number 43992 | 6001042.61306002 | 2109303.63872684 | 37.771804125001395 | -122.439787297823 | (37.7718041250014, -122.439787297823) | |||
| 114503 | 114503 | 45133 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1155 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2014 12:00:00 AM | Permit Number 772552 | 6001042.61306002 | 2109303.63872684 | 37.771804125001395 | -122.439787297823 | (37.7718041250014, -122.439787297823) | |||
| 11078 | 11078 | 94996 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 116 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010370.4352 | 2087379.2102 | 37.7121309230244 | -122.405976810763 | (37.7121309230244, -122.405976810763) | |||
| 138440 | 138440 | 34393 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 116 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38140 | 6002651.93696473 | 2096854.08476893 | 37.7377120923069 | -122.433330781491 | (37.7377120923069, -122.433330781491) | ||
| 7425 | 7425 | 8168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1160 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6002214.9627 | 2111253.4218 | 37.7772244047313 | -122.435871600468 | (37.7772244047313, -122.435871600468) | |||
| 141940 | 141940 | 66596 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1166 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 2 | Permit Number 29789 | 6008318.17747093 | 2115921.39203862 | 37.79038633277379 | -122.415089057915 | (37.7903863327738, -122.415089057915) | |
| 79623 | 79623 | 62851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/1986 12:00:00 AM | 6008695.79989615 | 2098007.34632384 | 37.7412197219886 | -122.412515664848 | (37.7412197219886, -122.412515664848) | |||
| 118882 | 118882 | 55671 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1994 12:00:00 AM | Permit Number 23401 | 6006313.81948634 | 2098247.3231176003 | 37.7417446776937 | -122.420768752189 | (37.7417446776937, -122.420768752189) | ||
| 18086 | 18086 | 32173 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 88347 | 88347 | 32171 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 107326 | 107326 | 32172 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 114564 | 114564 | 32169 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 127685 | 127685 | 32170 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
| 11042 | 11042 | 26800 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1999 12:00:00 AM | 5 | 3x3 | 6010377.1195 | 2087327.5180000002 | 37.7119893605537 | -122.40595006858901 | (37.7119893605537, -122.405950068589) | ||
| 139250 | 139250 | 37010 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1174 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39624 | 6009195.299584201 | 2102322.47660187 | 37.7530961349664 | -122.411093293486 | (37.7530961349664, -122.411093293486) | ||
| 176542 | 176542 | 135906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6007265.472680001 | 2119876.0558700003 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | |||
| 44877 | 44877 | 238005 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 118 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002126.98293 | 2096665.47856 | 37.7371644277915 | -122.435132311514 | (37.7371644277915, -122.435132311514) | |||
| 109647 | 109647 | 34437 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 118 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38181 | 6002137.76311009 | 2096681.81927125 | 37.73720990774861 | -122.43509620795601 | (37.7372099077486, -122.435096207956) | ||
| 142184 | 142184 | 52542 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2006 12:00:00 AM | Permit Number 48640 | 6000058.65812884 | 2094126.3356256 | 37.7300748692234 | -122.44210122198 | (37.7300748692234, -122.44210122198) | ||
| 145639 | 145639 | 62945 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23327 | 6007203.62024712 | 2097035.47638332 | 37.7384673272843 | -122.41760623779601 | (37.7384673272843, -122.417606237796) | ||
| 112262 | 112262 | 33701 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37770 | 6003654.24341388 | 2108799.1286398 | 37.7705671735444 | -122.430717487593 | (37.7705671735444, -122.430717487593) | ||
| 119202 | 119202 | 33702 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37770 | 6003654.24341388 | 2108799.1286398 | 37.7705671735444 | -122.430717487593 | (37.7705671735444, -122.430717487593) | |||
| 124447 | 124447 | 32174 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
| 145196 | 145196 | 32175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
| 89946 | 89946 | 62884 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1986 12:00:00 AM | Permit Number 23256 | 6008874.101722799 | 2097984.21673408 | 37.7411662180492 | -122.41189752426399 | (37.7411662180492, -122.411897524264) | ||
| 52829 | 52829 | 135900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006826.338330001 | 2115526.46894 | 37.7892180233479 | -122.420222690545 | (37.7892180233479, -122.420222690545) | |||
| 56608 | 56608 | 135898 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006854.3438099995 | 2115529.77615 | 37.7892286821026 | -122.420126029605 | (37.7892286821026, -122.420126029605) | |||
| 68414 | 68414 | 135899 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006839.2179 | 2115528.7927900003 | 37.7892251297772 | -122.420178293706 | (37.7892251297772, -122.420178293706) | |||
| 53803 | 53803 | 250309 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Redfield Aly | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | |||
| 93981 | 93981 | 37867 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40154 | 5996172.53384132 | 2093848.71609655 | 37.7290903602157 | -122.45551590429399 | (37.7290903602157, -122.455515904294) | ||
| 108384 | 108384 | 37868 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Colon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40154 | 5996172.53384132 | 2093848.71609655 | 37.7290903602157 | -122.45551590429399 | (37.7290903602157, -122.455515904294) | ||
| 56224 | 56224 | 50964 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 4 | Permit Number 47459 | 5996570.7873 | 2113602.9801 | 37.783353433045995 | -122.455566358041 | (37.783353433046, -122.455566358041) | ||
| 161721 | 161721 | 50963 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2004 12:00:00 AM | 2 | Permit Number 47459 | 5996572.8178 | 2113583.69 | 37.7833005840711 | -122.455557938638 | (37.7833005840711, -122.455557938638) | ||
| 188866 | 188866 | 238006 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 120 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002226.03876 | 2096243.0070099998 | 37.7360100427193 | -122.434759628851 | (37.7360100427193, -122.434759628851) | |||
| 12090 | 12090 | 85962 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988020.9888 | 2107061.1992 | 37.7648972002579 | -122.484664894353 | (37.7648972002579, -122.484664894353) | ||
| 12727 | 12727 | 85961 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988024.0524 | 2107011.4158 | 37.7647606871244 | -122.484650646191 | (37.7647606871244, -122.484650646191) | ||
| 55286 | 55286 | 186809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 118 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984810.136 | 2106955.7691 | 37.7644202036906 | -122.495762474243 | (37.7644202036906, -122.495762474243) | |||
| 68183 | 68183 | 186811 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 116 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.3107 | 2106920.8907 | 37.7643249161453 | -122.495731627712 | (37.7643249161453, -122.495731627712) | |||
| 75257 | 75257 | 186812 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 115 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984824.8504 | 2106905.6313 | 37.764283401100705 | -122.495707883417 | (37.7642834011007, -122.495707883417) | |||
| 155382 | 155382 | 186813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 114 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.8556 | 2106897.4567 | 37.7642606048812 | -122.4957280144 | (37.7642606048812, -122.4957280144) | |||
| 173050 | 173050 | 186810 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 117 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984819.4006 | 2106939.4198 | 37.7643758556702 | -122.49572922497102 | (37.7643758556702, -122.495729224971) | |||
| 119612 | 119612 | 96804 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200X Revere Ave | 1 | Median : 22 | Tree 1 | DPW 2 | 6017205.4 | 2092876.1 | 37.7276042330013 | -122.38273521775801 | (37.7276042330013, -122.382735217758) | |||||
| 171275 | 171275 | 199981 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200x Shafter Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6017028.9443 | 2092601.7798 | 37.7268412531355 | -122.38332614590799 | (37.7268412531355, -122.383326145908) | |||
| 3398 | 3398 | 245004 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000727.3724 | 2109263.3505 | 37.7716755548589 | -122.44087484303499 | (37.7716755548589, -122.440874843035) | |||
| 154517 | 154517 | 245006 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000755.8359 | 2109268.0945 | 37.771690201724205 | -122.440776726653 | (37.7716902017242, -122.440776726653) | |||
| 27002 | 27002 | 181705 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1206 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5989261.3602 | 2107107.536 | 37.7650965865931 | -122.48037820612 | (37.7650965865931, -122.48037820612) | |||
| 76549 | 76549 | 44797 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1206 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 0 | Permit Number 43891 | 5989264.78401364 | 2107125.07259505 | 37.7651449362762 | -122.48036764782499 | (37.7651449362762, -122.480367647825) | |
| 153200 | 153200 | 183419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1206 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989183.8607 | 2096995.3104 | 37.73732659489539 | -122.479906199072 | (37.7373265948954, -122.479906199072) | |||
| 141755 | 141755 | 53024 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 120@ DEWEY Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 49003 | 5994552.8833077 | 2099973.38897946 | 37.7458141244153 | -122.461558986184 | (37.7458141244153, -122.461558986184) | |||
| 80096 | 80096 | 31127 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 121 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 5.5x4 | Permit Number 34844 | 5998074.93385537 | 2093867.82881443 | 37.729251820430605 | -122.448940561252 | (37.7292518204306, -122.448940561252) | |
| 36230 | 36230 | 237982 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 121 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003530.56657 | 2095073.53788 | 37.732872922347205 | -122.43016594940501 | (37.7328729223472, -122.430165949405) | |||
| 167724 | 167724 | 183420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1210 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989168.5817 | 2096994.6461 | 37.737323883205704 | -122.479958976444 | (37.7373238832057, -122.479958976444) | |||
| 95411 | 95411 | 48937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1211 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47623 | 6011655.9812658 | 2091521.24979215 | 37.7235759411749 | -122.401824534776 | (37.7235759411749, -122.401824534776) | ||
| 86163 | 86163 | 62629 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1212 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1986 12:00:00 AM | Permit Number 22943 | 5996753.97709573 | 2107294.12734381 | 37.7660414791749 | -122.45447670568599 | (37.7660414791749, -122.454476705686) | ||
| 106934 | 106934 | 48938 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1213 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46126 | 6011656.06397948 | 2091520.97870067 | 37.7235752014293 | -122.40182422980101 | (37.7235752014293, -122.401824229801) | ||
| 48024 | 48024 | 183421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1214 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989156.9564 | 2096994.6461 | 37.7373232077722 | -122.47999917002701 | (37.7373232077722, -122.479999170027) | |||
| 54063 | 54063 | 237992 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1217 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001369.41512 | 2100163.22575 | 37.7467253722857 | -122.438002031971 | (37.7467253722857, -122.438002031971) | |||
| 88065 | 88065 | 34303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1219 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38091 | 6011656.31212487 | 2091520.16541192 | 37.7235729821535 | -122.40182331486 | (37.7235729821535, -122.40182331486) | ||
| 107181 | 107181 | 62852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 122 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23220 | 6008641.92046569 | 2097986.85809745 | 37.7411604419058 | -122.412700513333 | (37.7411604419058, -122.412700513333) | ||
| 53846 | 53846 | 237983 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 122 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003747.81471 | 2095090.5430400001 | 37.7329319169677 | -122.429416079391 | (37.7329319169677, -122.429416079391) | |||
| 92808 | 92808 | 67926 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 122 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | Permit Number 31639 | 6003737.46375671 | 2095111.38827629 | 37.732988567235296 | -122.42945335133699 | (37.7329885672353, -122.429453351337) | ||
| 25201 | 25201 | 183343 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1220 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983371.791 | 2106830.4783 | 37.7639918518381 | -122.500727966306 | (37.7639918518381, -122.500727966306) | |||
| 114341 | 114341 | 37422 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1220 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2002 12:00:00 AM | Permit Number 46192 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.43177398011801 | (37.7494863167503, -122.431773980118) | |||
| 110342 | 110342 | 51519 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1225 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2005 12:00:00 AM | Permit Number 47822 | 5995038.52615382 | 2091975.35473544 | 37.7238814240936 | -122.45930062456101 | (37.7238814240936, -122.459300624561) | |||
| 121997 | 121997 | 62630 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1225 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1986 12:00:00 AM | Permit Number 22944 | 5996707.94282717 | 2107247.73883255 | 37.765911467967896 | -122.454632576444 | (37.7659114679679, -122.454632576444) | ||
| 92154 | 92154 | 45136 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1226 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43993 | 6000686.57421699 | 2109306.41262626 | 37.7717914689993 | -122.44101905593399 | (37.7717914689993, -122.441019055934) | ||
| 147043 | 147043 | 245121 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1226 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000650.5369 | 2109296.0266 | 37.7717608989394 | -122.441142965804 | (37.7717608989394, -122.441142965804) | |||
| 106842 | 106842 | 56626 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1228 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1987 12:00:00 AM | 6001939.04368319 | 2100514.9699415 | 37.74772355623 | -122.43605748231899 | (37.74772355623, -122.436057482319) | |||
| 102251 | 102251 | 88260 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 123 Corbett Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51245 | 6000668.3 | 2105609.4 | 37.7616393503242 | -122.44081702139401 | (37.7616393503242, -122.440817021394) | |||
| 120728 | 120728 | 88189 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 123 Dore St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51194 | 6009069.0 | 2109644.0 | 37.7731922763614 | -122.41204743866301 | (37.7731922763614, -122.412047438663) | |||
| 97344 | 97344 | 62948 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 123 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | Permit Number 23330 | 6007218.86184929 | 2097033.29709348 | 37.738462201074 | -122.417553385172 | (37.738462201074, -122.417553385172) | ||
| 110053 | 110053 | 62864 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 123 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23232 | 6008337.20642708 | 2098017.19315291 | 37.7412266280986 | -122.413756253828 | (37.7412266280986, -122.413756253828) | ||
| 11815 | 11815 | 85960 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1230 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988027.116 | 2106908.7855 | 37.764479070899 | -122.48463252131201 | (37.764479070899, -122.484632521312) |
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");