Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 121829 | 121829 | 42077 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
| 105011 | 105011 | 46168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44497 | 5996113.80902962 | 2106861.13745227 | 37.7648158648531 | -122.45665958836399 | (37.7648158648531, -122.456659588364) | ||
| 123229 | 123229 | 42079 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42389 | 6009265.41363365 | 2099503.07167939 | 37.7453586067376 | -122.41065173677299 | (37.7453586067376, -122.410651736773) | ||
| 183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
| 85199 | 85199 | 47712 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 18799 | 18799 | 11188 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995291.088769999 | 2099424.10153 | 37.7443483813689 | -122.45896663000299 | (37.7443483813689, -122.458966630003) | |||
| 105631 | 105631 | 34419 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38167 | 6003358.09011166 | 2096226.49076231 | 37.7360288984966 | -122.43084449611601 | (37.7360288984966, -122.430844496116) | ||
| 80558 | 80558 | 49133 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | |||
| 121275 | 121275 | 41858 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 94813 | 94813 | 115487 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1004 SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003744.0 | 2102383.0 | 37.7529551066007 | -122.4299492716 | (37.7529551066007, -122.4299492716) | ||||
| 81601 | 81601 | 65210 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1008 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27196 | 6003122.02248491 | 2102364.94475265 | 37.7528702875206 | -122.432098897252 | (37.7528702875206, -122.432098897252) | ||
| 143462 | 143462 | 53023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100@ DEWEY Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 49002 | 5994618.97974152 | 2099903.5858652 | 37.7456262668668 | -122.461325376527 | (37.7456262668668, -122.461325376527) | |||
| 92552 | 92552 | 36557 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39427 | 6008880.2941613 | 2098058.52124465 | 37.7413705893714 | -122.411881362374 | (37.7413705893714, -122.411881362374) | ||
| 103592 | 103592 | 121759 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1019 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015338.0 | 2103772.0 | 37.7574187808175 | -122.389951694408 | (37.7574187808175, -122.389951694408) | ||||
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 94204 | 94204 | 34536 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 102 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38245 | 6009539.66453921 | 2097997.54688011 | 37.7412401371814 | -122.409597177582 | (37.7412401371814, -122.409597177582) | ||
| 87307 | 87307 | 37016 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1024 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39629 | 6008593.31384349 | 2102571.16222478 | 37.7537451924393 | -122.413192669543 | (37.7537451924393, -122.413192669543) | ||
| 141471 | 141471 | 39191 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1025 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40844 | 6008645.24325538 | 2102573.87076335 | 37.7537555446899 | -122.413013276733 | (37.7537555446899, -122.413013276733) | ||
| 165537 | 165537 | 178872 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003905.75349 | 2089465.8631799999 | 37.717496734867396 | -122.428469272232 | (37.7174967348674, -122.428469272232) | |||
| 112903 | 112903 | 84224 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50754 | 6010384.580416299 | 2088747.67100343 | 37.7158892293049 | -122.406024264993 | (37.7158892293049, -122.406024264993) | ||
| 123029 | 123029 | 116779 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1031 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 3x3 | 6008650.0 | 2118281.0 | 37.796883878440795 | -122.41410797545099 | (37.7968838784408, -122.414107975451) | ||
| 49913 | 49913 | 199985 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018147.7753 | 2092169.4169 | 37.725715836336896 | -122.379428312297 | (37.7257158363369, -122.379428312297) | |||
| 167611 | 167611 | 95528 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767319 | 5989620.9197 | 2099732.2391 | 37.7448668732681 | -122.478595193308 | (37.7448668732681, -122.478595193308) |
| 83546 | 83546 | 48870 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 105 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46813 | 5992505.4658098 | 2098397.03654372 | 37.7413678003574 | -122.468523930768 | (37.7413678003574, -122.468523930768) | ||
| 142993 | 142993 | 62195 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 105 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1985 12:00:00 AM | Permit Number 22314 | 6000493.57908868 | 2092148.88322612 | 37.7246700159736 | -122.440455881068 | (37.7246700159736, -122.440455881068) | ||
| 146100 | 146100 | 43905 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1050 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.755232893914794 | -122.408509176777 | (37.7552328939148, -122.408509176777) |
| 102086 | 102086 | 62849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23217 | 6008647.40750977 | 2098052.96381421 | 37.7413422616597 | -122.41268621320101 | (37.7413422616597, -122.412686213201) | ||
| 115997 | 115997 | 36347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39309 | 5995651.79090977 | 2093374.88380892 | 37.7277594354695 | -122.457281878498 | (37.7277594354695, -122.457281878498) | ||
| 11545 | 11545 | 26790 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 106 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2015 09:40:00 AM | 3 | 3X3 | 6010430.5942 | 2087350.2448 | 37.7120547543657 | -122.405766843704 | (37.7120547543657, -122.405766843704) | ||
| 128135 | 128135 | 32384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
| 122373 | 122373 | 63019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1986 12:00:00 AM | Permit Number 23434 | 6007356.32584056 | 2097719.32736654 | 37.740353622343 | -122.417126697503 | (37.740353622343, -122.417126697503) | ||
| 124372 | 124372 | 37006 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1065 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39620 | 6009210.89939839 | 2102965.35956072 | 37.754862222093294 | -122.411084752447 | (37.7548622220933, -122.411084752447) | ||
| 86071 | 86071 | 36348 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39310 | 5995599.90527543 | 2093378.33068424 | 37.7277659195994 | -122.457461496194 | (37.7277659195994, -122.457461496194) | ||
| 10354 | 10354 | 95012 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | 6010407.8674 | 2087313.2581 | 37.7119519253908 | -122.40584279071301 | (37.7119519253908, -122.405842790713) | ||
| 86014 | 86014 | 51430 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1070 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2004 12:00:00 AM | Permit Number 47751 | 6007408.58996673 | 2101077.89386609 | 37.7495784341832 | -122.417183917873 | (37.7495784341832, -122.417183917873) | |||
| 99007 | 99007 | 37007 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1071 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39621 | 6009212.75104301 | 2102931.76923387 | 37.7547700944461 | -122.411075976411 | (37.7547700944461, -122.411075976411) | ||
| 25034 | 25034 | 245135 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 108 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000350.1465 | 2109371.4561 | 37.7719508943795 | -122.442187448391 | (37.7719508943795, -122.442187448391) | |||
| 128860 | 128860 | 39140 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1084 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40818 | 6007412.89120014 | 2100999.62033196 | 37.749363754724996 | -122.417163498301 | (37.749363754725, -122.417163498301) | ||
| 132838 | 132838 | 178906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009976.781880001 | 2089389.92306 | 37.7176299046612 | -122.40747906690399 | (37.7176299046612, -122.407479066904) | |||
| 127102 | 127102 | 27759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.817910201 | 2101113.2850563 | 37.750139234821 | -122.38847329943701 | (37.750139234821, -122.388473299437) | ||
| 101473 | 101473 | 67117 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30537 | 5998254.46044174 | 2105394.41401324 | 37.7609112863716 | -122.449149986975 | (37.7609112863716, -122.449149986975) | ||
| 12918 | 12918 | 26791 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1999 12:00:00 AM | 4 | 3x3 | 6010397.1725 | 2087366.7328 | 37.712098157972605 | -122.40588352001801 | (37.7120981579726, -122.405883520018) | ||
| 91136 | 91136 | 45127 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2001 12:00:00 AM | Permit Number 43984 | 6000366.86976442 | 2109279.71080278 | 37.7716999379516 | -122.442123014739 | (37.7716999379516, -122.442123014739) | ||
| 78757 | 78757 | 65245 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1106 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28039 | 6009173.38165211 | 2102703.44295541 | 37.7541409539447 | -122.411195999264 | (37.7541409539447, -122.411195999264) | ||
| 75758 | 75758 | 47310 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1107 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45241 | 6010288.16181634 | 2102764.77938432 | 37.7543718262723 | -122.407345121668 | (37.7543718262723, -122.407345121668) | ||
| 103053 | 103053 | 40468 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 111 Caine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | Permit Number 41553 | 5997316.73360061 | 2089179.17157647 | 37.71633447730439 | -122.45122371003599 | (37.7163344773044, -122.451223710036) | ||
| 142556 | 142556 | 45132 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1114 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43991 | 6001218.6094792 | 2109380.86443699 | 37.7720261837752 | -122.43918405170099 | (37.7720261837752, -122.439184051701) | ||
| 50138 | 50138 | 245099 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1116 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001200.4602 | 2109374.4683 | 37.7720075888162 | -122.43924637279899 | (37.7720075888162, -122.439246372799) | |||
| 11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");