Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 168210 | 168210 | 218135 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 0 Noriega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5992409.03176 | 2103467.31015 | 37.7552838973381 | -122.469226308173 | (37.7552838973381, -122.469226308173) | |||
| 41657 | 41657 | 213555 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Valdez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5996402.0458 | 2093842.9488400002 | 37.7290876920423 | -122.45472205120599 | (37.7290876920423, -122.454722051206) | |||
| 163914 | 163914 | 136012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006953.337619999 | 2120481.80968 | 37.802831303989 | -122.420135108266 | (37.802831303989, -122.420135108266) | |||
| 92548 | 92548 | 103760 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006758.9 | 2115521.2 | 37.789199755991795 | -122.420455645258 | (37.7891997559918, -122.420455645258) | ||
| 31155 | 31155 | 87154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50137 | 5992080.87589 | 2114715.15142 | 37.7861484784179 | -122.47118058793998 | (37.7861484784179, -122.47118058794) | |
| 153588 | 153588 | 68685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50137 | 5992080.71456 | 2114734.20286 | 37.7862007790713 | -122.47118253461001 | (37.7862007790713, -122.47118253461) | |
| 34957 | 34957 | 214766 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993866.28574 | 2101627.27037 | 37.7503157185921 | -122.464053162237 | (37.7503157185921, -122.464053162237) | |||
| 66671 | 66671 | 237246 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1011 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998816.10599 | 2106399.33422 | 37.763702653385 | -122.447279838404 | (37.763702653385, -122.447279838404) | |||
| 3629 | 3629 | 103766 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006706.11036 | 2115484.69473 | 37.7890965465282 | -122.420635698799 | (37.7890965465282, -122.420635698799) | ||
| 127259 | 127259 | 103765 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101X Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006551.29204 | 2115477.0840000003 | 37.789066922774204 | -122.42117081077 | (37.7890669227742, -122.42117081077) | ||
| 56422 | 56422 | 179145 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 102 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011376.8849 | 2092609.1227799999 | 37.726547436394604 | -122.402865802033 | (37.7265474363946, -122.402865802033) | |||
| 185392 | 185392 | 238527 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6004847.1355800005 | 2097543.60322 | 37.7397296468092 | -122.425789984144 | (37.7397296468092, -122.425789984144) | |||
| 4600 | 4600 | 103784 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006741.56415 | 2115141.24736 | 37.788155522905505 | -122.420488644345 | (37.7881555229055, -122.420488644345) | ||
| 8999 | 8999 | 103785 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006767.43674 | 2115144.46398 | 37.7881658129506 | -122.420399357843 | (37.7881658129506, -122.420399357843) | ||
| 162231 | 162231 | 136002 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1043 Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009478.99985 | 2116817.49063 | 37.7929119670677 | -122.41113599902201 | (37.7929119670677, -122.411135999022) | |||
| 102743 | 102743 | 107954 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Danvers St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999967.5 | 2105076.1 | 37.760135104087794 | -122.44320249258301 | (37.7601351040878, -122.443202492583) | |
| 115650 | 115650 | 107953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Danvers St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999967.5 | 2105076.1 | 37.760135104087794 | -122.44320249258301 | (37.7601351040878, -122.443202492583) | |
| 117774 | 117774 | 81336 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771125 | 5999938.45094538 | 2105136.44437451 | 37.760299138392 | -122.44330729346599 | (37.760299138392, -122.443307293466) | |
| 13060 | 13060 | 109069 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1065 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772763 | 6002105.570119999 | 2087176.80573 | 37.7111094529054 | -122.434528092094 | (37.7111094529054, -122.434528092094) |
| 6501 | 6501 | 103875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006702.4202 | 2115509.69435 | 37.7891649813311 | -122.42065024171002 | (37.7891649813311, -122.42065024171) | ||
| 6617 | 6617 | 103761 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.575019999 | 2115508.13748 | 37.7891597571573 | -122.42070841348101 | (37.7891597571573, -122.420708413481) | ||
| 6991 | 6991 | 103876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.01893 | 2115511.31786 | 37.7891702054911 | -122.420603306998 | (37.7891702054911, -122.420603306998) | ||
| 17026 | 17026 | 16614 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 107 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | privately planted on dpw street without permit | 6002879.45304 | 2107636.12058 | 37.7673299123847 | -122.433314375152 | (37.7673299123847, -122.433314375152) | ||
| 88917 | 88917 | 91030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1086 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6009941.213427 | 2111462.810786 | 37.778235204322904 | -122.409158690819 | (37.7782352043229, -122.409158690819) | ||
| 13686 | 13686 | 27731 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015524.1696 | 2101161.19501 | 37.7502603851148 | -122.38912554882 | (37.7502603851148, -122.38912554882) | ||
| 14286 | 14286 | 27729 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015622.7491 | 2101166.85438 | 37.75028138877779 | -122.38878504659999 | (37.7502813887778, -122.3887850466) | ||
| 31826 | 31826 | 88412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009452.7788 | 2116769.6537 | 37.792779147992796 | -122.411223344786 | (37.7927791479928, -122.411223344786) | |
| 153833 | 153833 | 88415 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009399.28346 | 2116763.19844 | 37.792758423123495 | -122.41140798549601 | (37.7927584231235, -122.411407985496) | |
| 155637 | 155637 | 88414 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009411.74152 | 2116765.8223 | 37.7927663263429 | -122.41136506535 | (37.7927663263429, -122.41136506535) | |
| 55544 | 55544 | 196465 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1101 Cesar Chavez St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015262.99985 | 2101056.82815 | 37.7499593343528 | -122.39002140848801 | (37.7499593343528, -122.390021408488) | |||
| 143691 | 143691 | 91888 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1104 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992367.653968 | 2106623.490856 | 37.763947549515 | -122.469599153768 | (37.763947549515, -122.469599153768) | |
| 71144 | 71144 | 214810 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Edgehill Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994724.24125 | 2098971.31175 | 37.7430725329757 | -122.460893845698 | (37.7430725329757, -122.460893845698) | |||
| 72503 | 72503 | 214812 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Edgehill Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994729.24198 | 2098958.41321 | 37.7430374045466 | -122.460875620025 | (37.7430374045466, -122.460875620025) | |||
| 153720 | 153720 | 214811 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Edgehill Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994726.40905 | 2098964.7055200003 | 37.7430545186528 | -122.46088587139799 | (37.7430545186528, -122.460885871398) | |||
| 40112 | 40112 | 214554 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1112 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992290.405180001 | 2106633.90901 | 37.76397169007029 | -122.46986709041 | (37.7639716900703, -122.46986709041) | |||
| 51558 | 51558 | 91889 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1112 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992343.82828 | 2106622.674723 | 37.7639439315835 | -122.46968149954701 | (37.7639439315835, -122.469681499547) | ||
| 19279 | 19279 | 91934 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1115 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992339.241228 | 2106582.494136 | 37.7638333412086 | -122.46969443927 | (37.7638333412086, -122.46969443927) | ||
| 142920 | 142920 | 91935 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1115 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992339.241228 | 2106582.494136 | 37.7638333412086 | -122.46969443927 | (37.7638333412086, -122.46969443927) | ||
| 14693 | 14693 | 67488 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1117 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | Permit Number 773109 | 6012239.52235 | 2103185.1315 | 37.7556350439301 | -122.400626303061 | (37.7556350439301, -122.400626303061) | |
| 99154 | 99154 | 57489 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111X Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52603 | 6002672.27523217 | 2105293.3654228 | 37.760885520528795 | -122.43386350193 | (37.7608855205288, -122.43386350193) |
| 76327 | 76327 | 214555 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1120 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992269.382669999 | 2106633.52914 | 37.7639694318537 | -122.469939772699 | (37.7639694318537, -122.469939772699) | |||
| 144626 | 144626 | 91890 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1120 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992320.002593 | 2106621.8585900003 | 37.763940313594496 | -122.469763845315 | (37.7639403135945, -122.469763845315) | ||
| 40362 | 40362 | 237411 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1129 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001354.34636 | 2100420.93652 | 37.747432127898996 | -122.43807259549601 | (37.747432127899, -122.438072595496) | |||
| 150270 | 150270 | 237410 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1129 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001354.452930001 | 2100411.80472 | 37.747407060207294 | -122.438071572955 | (37.7474070602073, -122.438071572955) | |||
| 100282 | 100282 | 109418 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771960 | 6000642.7 | 2102407.9 | 37.752847354291504 | -122.44067591422599 | (37.7528473542915, -122.440675914226) |
| 19460 | 19460 | 16615 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778956 | 6002889.7801 | 2107581.65027 | 37.7671809360695 | -122.433274762729 | (37.7671809360695, -122.433274762729) | |
| 66850 | 66850 | 237361 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1130 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008633.25472 | 2101950.7398599996 | 37.752043894517 | -122.413010679898 | (37.752043894517, -122.413010679898) | |||
| 93715 | 93715 | 91891 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1134 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992278.307636 | 2106620.430357 | 37.7639339819744 | -122.469907950407 | (37.7639339819744, -122.469907950407) | ||
| 82049 | 82049 | 69397 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | Permit Number 772744 | 6001523.93675849 | 2087030.79827901 | 37.7106755138649 | -122.436527911504 | (37.7106755138649, -122.436527911504) | |
| 160369 | 160369 | 214557 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1138 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992182.77942 | 2106630.32651 | 37.7639556317565 | -122.4702390716 | (37.7639556317565, -122.4702390716) | |||
| 143790 | 143790 | 91892 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1140 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992260.438373 | 2106619.818257 | 37.7639312683688 | -122.46996970970899 | (37.7639312683688, -122.469969709709) | ||
| 71204 | 71204 | 214751 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5995612.00056 | 2093441.40457 | 37.7279398000583 | -122.45742424415701 | (37.7279398000583, -122.457424244157) | |||
| 23601 | 23601 | 238482 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003589.43942 | 2108803.81702 | 37.7705763750292 | -122.430941979801 | (37.7705763750292, -122.430941979801) | |||
| 38972 | 38972 | 239470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1154 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5997382.293980001 | 2106266.214 | 37.7632551057696 | -122.452229318435 | (37.7632551057696, -122.452229318435) | |||
| 185006 | 185006 | 52876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 118@ BEACH Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 3 | Permit Number 48887 | 6001354.74762 | 2121139.05445 | 37.8043188860645 | -122.439556198976 | (37.8043188860645, -122.439556198976) | ||
| 64023 | 64023 | 213692 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 119 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000067.8174 | 2094188.92148 | 37.7302472374194 | -122.442074047998 | (37.7302472374194, -122.442074047998) | |||
| 27309 | 27309 | 239553 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 119 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006419.09504 | 2098176.68739 | 37.7415566609206 | -122.42039973105801 | (37.7415566609206, -122.420399731058) | |||
| 100903 | 100903 | 91931 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992089.071506 | 2106573.92474 | 37.7637953493605 | -122.470559068172 | (37.7637953493605, -122.470559068172) | ||
| 115072 | 115072 | 91933 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992089.071506 | 2106573.92474 | 37.7637953493605 | -122.470559068172 | (37.7637953493605, -122.470559068172) | ||
| 128216 | 128216 | 91932 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992089.071506 | 2106573.92474 | 37.7637953493605 | -122.470559068172 | (37.7637953493605, -122.470559068172) | ||
| 29900 | 29900 | 213665 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 5994824.1493 | 2098927.22664 | 37.7429572344905 | -122.460545199208 | (37.7429572344905, -122.460545199208) | |||
| 33821 | 33821 | 213667 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 5994852.48941 | 2098936.7686799997 | 37.7429850649213 | -122.46044789885401 | (37.7429850649213, -122.460447898854) | |||
| 39231 | 39231 | 213669 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 5994884.8089 | 2098938.57589 | 37.7429918862669 | -122.460336278605 | (37.7429918862669, -122.460336278605) | |||
| 21015 | 21015 | 19321 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/2010 12:00:00 AM | 3 | 3X3 | 5993639.27417 | 2089852.22483 | 37.7179712747243 | -122.46398352863001 | (37.7179712747243, -122.46398352863) | ||
| 13815 | 13815 | 27724 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015353.113480001 | 2101161.82636 | 37.750252634763996 | -122.389717121075 | (37.750252634764, -122.389717121075) | ||
| 15791 | 15791 | 27728 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015202.17288 | 2101166.08495 | 37.750255956855 | -122.390239385253 | (37.750255956855, -122.390239385253) | ||
| 63359 | 63359 | 237130 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010014.7385 | 2102168.9770400003 | 37.7527205785919 | -122.40824867434601 | (37.7527205785919, -122.408248674346) | |||
| 9424 | 9424 | 16412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
| 9468 | 9468 | 16413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6016451.798598001 | 2094870.8752060002 | 37.7330398269448 | -122.38547940494499 | (37.7330398269448, -122.385479404945) | ||
| 21554 | 21554 | 10197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2004 12:00:00 AM | 3 | 2X2 | 6005817.7414 | 2101914.20762 | 37.7517851334751 | -122.42274455772301 | (37.7517851334751, -122.422744557723) | ||
| 179971 | 179971 | 214513 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201 Irving St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991875.48637 | 2106556.84064 | 37.763736088371 | -122.471296542118 | (37.763736088371, -122.471296542118) | |||
| 53189 | 53189 | 91930 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 38672 | 38672 | 214517 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1203 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992165.72073 | 2106566.0592799997 | 37.763778184733894 | -122.470293391536 | (37.7637781847339, -122.470293391536) | |||
| 91912 | 91912 | 115432 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Edgehill Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777500 | 5994912.6 | 2098995.5 | 37.7431497843009 | -122.460244308613 | (37.7431497843009, -122.460244308613) | ||
| 129278 | 129278 | 115431 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Edgehill Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777500 | 5994912.6 | 2098995.5 | 37.7431497843009 | -122.460244308613 | (37.7431497843009, -122.460244308613) | ||
| 62662 | 62662 | 213365 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Hugo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995367.388719999 | 2107028.24385 | 37.7652318111279 | -122.45925334826299 | (37.7652318111279, -122.459253348263) | |||
| 78855 | 78855 | 54202 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770897 | 5995407.75355189 | 2107023.99587375 | 37.765222467855295 | -122.459113429254 | (37.7652224678553, -122.459113429254) |
| 129219 | 129219 | 91981 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1210 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993318.025647 | 2107238.1041650004 | 37.7656899972839 | -122.46635680061001 | (37.7656899972839, -122.46635680061) | ||
| 71360 | 71360 | 78237 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1215 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | Permit Number 779512 | 5999758.88688 | 2090259.2057 | 37.7194395330998 | -122.442859978114 | (37.7194395330998, -122.442859978114) | |
| 43052 | 43052 | 213374 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1231 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993276.25677 | 2107124.6508 | 37.765376074084394 | -122.46649302204901 | (37.7653760740844, -122.466493022049) | |||
| 92878 | 92878 | 91982 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1231 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993282.58983 | 2107104.747155 | 37.7653217893633 | -122.466469670891 | (37.7653217893633, -122.466469670891) | ||
| 38785 | 38785 | 136006 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1237x Robert C Levy Tunl | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007669.82361 | 2118117.1353700003 | 37.7963788445653 | -122.417488005977 | (37.7963788445653, -122.417488005977) | ||||
| 164473 | 164473 | 136005 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1237x Robert C Levy Tunl | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007661.46268 | 2118150.4985 | 37.7964699809712 | -122.417519302367 | (37.7964699809712, -122.417519302367) | ||||
| 37981 | 37981 | 213375 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1239 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993278.62034 | 2107063.27366 | 37.7652076850186 | -122.466480385674 | (37.7652076850186, -122.466480385674) | |||
| 81475 | 81475 | 91983 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1239 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993284.406043 | 2107051.954484 | 37.7651769393996 | -122.46645955171999 | (37.7651769393996, -122.46645955172) | ||
| 75194 | 75194 | 237247 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998909.15382 | 2107445.1478 | 37.7665795108621 | -122.447033281177 | (37.7665795108621, -122.447033281177) | |||
| 83265 | 83265 | 91984 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1243 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993285.31415 | 2107025.55813 | 37.7651045143653 | -122.466454492146 | (37.7651045143653, -122.466454492146) | ||
| 11489 | 11489 | 918 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1246 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3x6 | 6002972.02958 | 2094203.5052200002 | 37.730452359288996 | -122.43203484674801 | (37.730452359289, -122.432034846748) | ||
| 71891 | 71891 | 250874 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986467.3841 | 2114682.3933599996 | 37.7857322411853 | -122.490599105779 | (37.7857322411853, -122.490599105779) | |||
| 11888 | 11888 | 108379 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Bertita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773806 | 6000690.090969999 | 2090159.58738 | 37.7192190489897 | -122.439634019098 | (37.7192190489897, -122.439634019098) |
| 65084 | 65084 | 214689 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Forest Side Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992460.51353 | 2098300.43293 | 37.7410999545955 | -122.468672331166 | (37.7410999545955, -122.468672331166) | |||
| 52702 | 52702 | 213581 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994661.106000001 | 2099475.65423 | 37.7444536982758 | -122.461148698258 | (37.7444536982758, -122.461148698258) | |||
| 59819 | 59819 | 213566 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Merced Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994661.84114 | 2099550.21632 | 37.7446584694058 | -122.46115155990101 | (37.7446584694058, -122.461151559901) | |||
| 151598 | 151598 | 213565 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994666.93375 | 2099556.29013 | 37.744675439634 | -122.461134390953 | (37.744675439634, -122.461134390953) | |||
| 132680 | 132680 | 213534 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993559.98064 | 2093781.74568 | 37.7287562145219 | -122.464542776527 | (37.7287562145219, -122.464542776527) | |||
| 93511 | 93511 | 67139 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1256 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778711 | 5995503.40408063 | 2107002.8233616003 | 37.765169831893104 | -122.45878106616199 | (37.7651698318931, -122.458781066162) |
| 100587 | 100587 | 91980 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1256 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993328.468873001 | 2106934.546237 | 37.7648571097371 | -122.466298616883 | (37.7648571097371, -122.466298616883) | ||
| 144158 | 144158 | 91985 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1259 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993288.9465769995 | 2106919.972764 | 37.7648148143539 | -122.466434253957 | (37.7648148143539, -122.466434253957) | ||
| 184114 | 184114 | 218215 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Lenox Way | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993412.17188 | 2098613.00635 | 37.74201313250371 | -122.465404568079 | (37.7420131325037, -122.465404568079) | |||
| 142923 | 142923 | 91979 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1262 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993329.831033 | 2106894.951731 | 37.76474847223739 | -122.46629102779801 | (37.7647484722374, -122.466291027798) |
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");