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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6267 | 6267 | 17356 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005536.16539 | 2117610.65272 | 37.794867887291396 | -122.424834871756 | (37.7948678872914, -122.424834871756) | |||
| 8751 | 8751 | 17355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005540.30706 | 2117584.3351 | 37.7947958596827 | -122.424818667772 | (37.7947958596827, -122.424818667772) | |||
| 11313 | 11313 | 26979 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 538 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004789.78173 | 2093487.7597 | 37.728589968546 | -122.42569968949199 | (37.728589968546, -122.425699689492) | |||
| 12555 | 12555 | 27112 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 483 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004609.34849 | 2093526.9165 | 37.728687286881204 | -122.426326244487 | (37.7286872868812, -122.426326244487) | |||
| 13866 | 13866 | 10995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1544 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016004.21156 | 2097242.6965900003 | 37.7395275952262 | -122.387192226744 | (37.7395275952262, -122.387192226744) | |||
| 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) | ||
| 17635 | 17635 | 4185 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3836 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004920.4543 | 2100493.66271 | 37.747833979169705 | -122.42574640029899 | (37.7478339791697, -122.425746400299) | |||
| 18004 | 18004 | 5790 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 573 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002988.46433 | 2108287.7672099997 | 37.769125358463995 | -122.43298388241301 | (37.769125358464, -122.432983882413) | |||
| 20763 | 20763 | 36 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 773 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003693.31613 | 2107706.2481400003 | 37.7675686032223 | -122.430504342717 | (37.7675686032223, -122.430504342717) | |||
| 21098 | 21098 | 10199 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 6005752.31611 | 2101874.30524 | 37.7516718791661 | -122.42296797178801 | (37.7516718791661, -122.422967971788) | |||
| 24678 | 24678 | 21658 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1745 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004251.7833336 | 2114607.9002324 | 37.7865504610901 | -122.42906481766 | (37.7865504610901, -122.42906481766) | |||
| 44768 | 44768 | 121639 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 6000575.25086 | 2092201.75917 | 37.7248198513454 | -122.440177342728 | (37.7248198513454, -122.440177342728) | |||
| 53191 | 53191 | 102037 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 58748 | 58748 | 121640 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Otsego Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 17 | 6000583.2387 | 2092221.3848599999 | 37.724874193767796 | -122.440151136477 | (37.7248741937678, -122.440151136477) | |||
| 77900 | 77900 | 99712 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 80503 | 80503 | 28782 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985488.09937 | 2112541.18326 | 37.7797958470089 | -122.493829255147 | (37.7797958470089, -122.493829255147) | |||
| 81799 | 81799 | 104075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340X Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | 5995047.73702 | 2097534.72021 | 37.7391466176195 | -122.45967126156602 | (37.7391466176195, -122.459671261566) | |||
| 84684 | 84684 | 21663 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1751 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004224.469596201 | 2114604.1030069 | 37.786538488702504 | -122.42915904562 | (37.7865384887025, -122.42915904562) | |||
| 84850 | 84850 | 28781 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985497.48939 | 2112543.62929 | 37.7798031124744 | -122.493796951714 | (37.7798031124744, -122.493796951714) | |||
| 85693 | 85693 | 96953 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 32951 | 5988418.13148 | 2110571.74898 | 37.7745593211999 | -122.483548684419 | (37.7745593211999, -122.483548684419) | ||
| 86434 | 86434 | 108081 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 626 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010239.318530001 | 2105432.7215400003 | 37.761694663220894 | -122.40770213976101 | (37.7616946632209, -122.407702139761) | |||||
| 87806 | 87806 | 102038 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 88443 | 88443 | 108083 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 626 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010239.318530001 | 2105432.7215400003 | 37.761694663220894 | -122.40770213976101 | (37.7616946632209, -122.407702139761) | |||||
| 89743 | 89743 | 28620 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6000051.9098 | 2091608.73805 | 37.723161742302 | -122.441943920583 | (37.723161742302, -122.441943920583) | |||
| 89994 | 89994 | 2451 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1805X Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6003959.5200660005 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | |||
| 90054 | 90054 | 99710 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 90273 | 90273 | 12830 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2224 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 5 | 5988512.18064 | 2114699.8246299997 | 37.785899329731606 | -122.483526054934 | (37.7858993297316, -122.483526054934) | |||
| 90559 | 90559 | 28617 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000011.03973 | 2091602.5396 | 37.7231423937331 | -122.44208475527701 | (37.7231423937331, -122.442084755277) | |||
| 92859 | 92859 | 28143 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 459 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006960.8227954 | 2097937.5089004 | 37.740930442807105 | -122.418509660609 | (37.7409304428071, -122.418509660609) | |||
| 93353 | 93353 | 85071 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009818.0 | 2105945.0 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | |||||
| 93823 | 93823 | 28615 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999987.60975 | 2091601.0392099998 | 37.7231369387356 | -122.442165640215 | (37.7231369387356, -122.442165640215) | |||
| 101577 | 101577 | 28619 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6000038.78425 | 2091606.3548299999 | 37.7231544505641 | -122.441989121927 | (37.7231544505641, -122.441989121927) | |||
| 101806 | 101806 | 99709 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 102770 | 102770 | 96076 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 41st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 767701 | 5983098.7 | 2113007.7 | 37.780936680817206 | -122.502129633812 | (37.7809366808172, -122.502129633812) | ||
| 106314 | 106314 | 85007 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 850 Bryant St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49366 | 6010976.0 | 2110190.0 | 37.7747982776561 | -122.40548930108 | (37.7747982776561, -122.40548930108) | |||||
| 106738 | 106738 | 95016 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010516.6 | 2087234.5 | 37.7117417518759 | -122.405461434977 | (37.7117417518759, -122.405461434977) | |||
| 112868 | 112868 | 4070 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3128 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008858.8906068 | 2100618.9735689997 | 37.7483998253046 | -122.412136282652 | (37.7483998253046, -122.412136282652) | |||
| 112881 | 112881 | 96952 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2302 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 32951 | 5988431.28084 | 2110571.1656 | 37.7745584847462 | -122.483503155986 | (37.7745584847462, -122.483503155986) | ||
| 113083 | 113083 | 99708 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 113453 | 113453 | 26851 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 987 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6006383.06935 | 2103878.3785200003 | 37.7572101739855 | -122.420929013752 | (37.7572101739855, -122.420929013752) | |||
| 114167 | 114167 | 99706 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 114388 | 114388 | 28783 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6938 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5985480.3602 | 2112543.9942799998 | 37.7798031124689 | -122.493856235161 | (37.7798031124689, -122.493856235161) | |||
| 117446 | 117446 | 28616 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999998.87347 | 2091601.9533400002 | 37.7231400906515 | -122.44212676945601 | (37.7231400906515, -122.442126769456) | |||
| 119175 | 119175 | 108830 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | FUF 1 | 3x3 | 6003763.1265 | 2093992.4287599998 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | ||||
| 119703 | 119703 | 99707 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100@Moncada Paloma Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 123805 | 123805 | 108831 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 774658 | 6003763.1265 | 2093992.4287599998 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | |||
| 124779 | 124779 | 102039 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 125012 | 125012 | 92520 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 243 Holly Park Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52872 | 6006893.7 | 2096608.3 | 37.7372769513992 | -122.418647509778 | (37.7372769513992, -122.418647509778) | |||
| 125078 | 125078 | 108634 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | |||
| 126862 | 126862 | 12763 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1806 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5989830.303719999 | 2114748.7330400003 | 37.786110250168704 | -122.478969342589 | (37.7861102501687, -122.478969342589) | |||
| 127709 | 127709 | 108189 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 490X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013735.53307 | 2112587.71036 | 37.781535757063104 | -122.396111508062 | (37.7815357570631, -122.396111508062) | ||||
| 129333 | 129333 | 28105 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3385X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6007142.16868 | 2100525.74665 | 37.7480473709689 | -122.418066075247 | (37.7480473709689, -122.418066075247) | |||
| 138481 | 138481 | 106920 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6006764.0 | 2107336.0 | 37.76672546023 | -122.419856949025 | (37.76672546023, -122.419856949025) | ||||
| 139212 | 139212 | 99711 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 142447 | 142447 | 26728 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 143979 | 143979 | 106551 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 203 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X4 | Permit Number 58742 | 5998066.5 | 2096226.6 | 37.7357279634759 | -122.449139578572 | (37.7357279634759, -122.449139578572) | ||||
| 144521 | 144521 | 28618 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 279 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000023.845509999 | 2091604.32382 | 37.723148022568104 | -122.442040616354 | (37.7231480225681, -122.442040616354) | |||
| 144955 | 144955 | 108082 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 626 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010239.318530001 | 2105432.7215400003 | 37.761694663220894 | -122.40770213976101 | (37.7616946632209, -122.407702139761) | |||||
| 145307 | 145307 | 104076 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340X Juanita Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | 5995047.73702 | 2097534.72021 | 37.7391466176195 | -122.45967126156602 | (37.7391466176195, -122.459671261566) | |||
| 145778 | 145778 | 85006 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 850 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49366 | 6010976.0 | 2110190.0 | 37.7747982776561 | -122.40548930108 | (37.7747982776561, -122.40548930108) | ||||
| 146048 | 146048 | 108084 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 626 Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010239.318530001 | 2105432.7215400003 | 37.761694663220894 | -122.40770213976101 | (37.7616946632209, -122.407702139761) | |||||
| 146079 | 146079 | 102036 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3601X Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52501 | 6012999.572000001 | 2089254.628 | 37.7174271437906 | -122.39702109783701 | (37.7174271437906, -122.397021097837) | ||
| 155812 | 155812 | 92795 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 999 Wisconsin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 52022 | 6012811.72806 | 2102960.97452 | 37.755051454067505 | -122.398631693097 | (37.7550514540675, -122.398631693097) | ||
| 172980 | 172980 | 50792 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2740 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47317 | 5999864.3976 | 2118141.20218 | 37.7960026509676 | -122.444498073449 | (37.7960026509676, -122.444498073449) | |||
| 177753 | 177753 | 111197 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2317 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6003620.633230001 | 2116569.07161 | 37.791899593028205 | -122.43138849140499 | (37.7918995930282, -122.431388491405) | ||||
| 182102 | 182102 | 103454 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5988396.696330001 | 2114118.88325 | 37.7842975073391 | -122.48388298077101 | (37.7842975073391, -122.483882980771) | |||
| 184059 | 184059 | 39688 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 464 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 41073 | 5991907.09743 | 2112240.92064 | 37.779344868431004 | -122.47160144327101 | (37.779344868431, -122.471601443271) | |||
| 21329 | 21329 | 16625 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 143 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2007 12:00:00 AM | 3 | 3x3 | 6002893.733109999 | 2107470.63526 | 37.7668763401938 | -122.43325315650401 | (37.7668763401938, -122.433253156504) | ||
| 19214 | 19214 | 10228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1411 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/2002 12:00:00 AM | 6 | 3X3 | 6005886.64477 | 2100667.53648 | 37.7483659479448 | -122.422417708118 | (37.7483659479448, -122.422417708118) | ||
| 13385 | 13385 | 108724 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 566 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773100 | 6011759.6093 | 2105732.18704 | 37.762601916479504 | -122.40246509469401 | (37.7626019164795, -122.402465094694) |
| 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) | |
| 22957 | 22957 | 108702 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2382 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772586 | 6001605.971969999 | 2118381.98302 | 37.79676299019629 | -122.438489159966 | (37.7967629901963, -122.438489159966) |
| 127326 | 127326 | 108693 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950X Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.803910139733794 | -122.440613252117 | (37.8039101397338, -122.440613252117) |
| 139925 | 139925 | 108694 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950X Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.803910139733794 | -122.440613252117 | (37.8039101397338, -122.440613252117) |
| 143086 | 143086 | 108692 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.803910139733794 | -122.440613252117 | (37.8039101397338, -122.440613252117) |
| 86942 | 86942 | 95442 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2536 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/03/2011 12:00:00 AM | 3x3 | Permit Number 767304 | 5986467.3 | 2097980.9 | 37.7398745611118 | -122.489370926882 | (37.7398745611118, -122.489370926882) | |
| 96866 | 96866 | 46685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1563 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2016 12:00:00 AM | Permit Number 776034 | 5992114.70084954 | 2104801.75310053 | 37.758930915917 | -122.470341358559 | (37.758930915917, -122.470341358559) | ||
| 57991 | 57991 | 37799 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 425 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 6 | Permit Number 40126 | 6010088.32636 | 2092511.7068599998 | 37.7262079180568 | -122.407313455853 | (37.7262079180568, -122.407313455853) | |
| 101259 | 101259 | 65547 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340X Juanita Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1990 12:00:00 AM | Permit Number 770105 | 5994976.11327418 | 2097601.99657825 | 37.7393272229464 | -122.459923774546 | (37.7393272229464, -122.459923774546) | ||
| 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) | ||
| 115727 | 115727 | 93018 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 963 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/2010 12:00:00 AM | 3x3 | Permit Number 53140 | 6006134.0 | 2121397.0 | 37.805297983444 | -122.42303552725402 | (37.805297983444, -122.423035527254) | ||
| 62513 | 62513 | 69303 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 813 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2014 12:00:00 AM | 6 | Permit Number 770956 | 5999968.796 | 2111801.6454 | 37.7786018352438 | -122.443681177953 | (37.7786018352438, -122.443681177953) | |
| 43330 | 43330 | 108919 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 624 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773067 | 6007633.7 | 2096431.2 | 37.7368323085558 | -122.416076443366 | (37.7368323085558, -122.416076443366) |
| 97508 | 97508 | 108899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 16 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772775 | 6000547.04329 | 2086890.00633 | 37.710233369404605 | -122.43989417722 | (37.7102333694046, -122.43989417722) |
| 78144 | 78144 | 87131 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 De Montfort Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 3x3 | Permit Number 50083 | 5995245.2 | 2091924.0 | 37.7237522965749 | -122.45858247555599 | (37.7237522965749, -122.458582475556) | |||
| 150585 | 150585 | 56095 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 783 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52001 | 5981348.38409 | 2110404.98623 | 37.7736874110676 | -122.507991510924 | (37.7736874110676, -122.507991510924) | |
| 3846 | 3846 | 239484 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2017 12:00:00 AM | 8 | Width 3ft | Permit Number 779370 | 6007401.15098 | 2095467.39415 | 37.7341728312175 | -122.416812207728 | (37.7341728312175, -122.416812207728) | |
| 33711 | 33711 | 49142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 520 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 4 | Permit Number 46265 | 5985047.031690001 | 2112314.4789400003 | 37.7791475672211 | -122.495338355641 | (37.7791475672211, -122.495338355641) | ||
| 160586 | 160586 | 95194 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 517 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767108 | 5985627.976369999 | 2112321.20657 | 37.7792000368481 | -122.49332915492701 | (37.7792000368481, -122.493329154927) | |
| 112739 | 112739 | 51419 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2504 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2012 12:00:00 AM | Permit Number 769443 | 6001518.65549528 | 2114626.94659681 | 37.7864476669078 | -122.43852211334999 | (37.7864476669078, -122.43852211335) | |||
| 85414 | 85414 | 104234 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 298X Shrader St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2015 12:00:00 AM | 3 | 6x6 | Permit Number 771309 | 5997366.55609 | 2109687.30332 | 37.772647639236204 | -122.452530652813 | (37.7726476392362, -122.452530652813) | |
| 112791 | 112791 | 23845 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1360 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2001 12:00:00 AM | 8 | 3X3 | 6003737.7759918 | 2113383.7091882997 | 37.7831600307032 | -122.43075576300899 | (37.7831600307032, -122.430755763009) | ||
| 180103 | 180103 | 64839 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 21 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/1989 12:00:00 AM | 13 | Permit Number 25851 | 6003826.24575 | 2093276.39298 | 37.727955108333795 | -122.429015623867 | (37.7279551083338, -122.429015623867) | ||
| 85212 | 85212 | 12835 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2240 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2005 12:00:00 AM | 12 | 5 | 5988460.73959 | 2114698.1479700003 | 37.7858917318965 | -122.48370390161001 | (37.7858917318965, -122.48370390161) | ||
| 96235 | 96235 | 115195 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 288 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 777365 | 6002703.4 | 2104224.0 | 37.7579510666244 | -122.43367942577 | (37.7579510666244, -122.43367942577) | |||
| 128347 | 128347 | 104667 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 172 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/19/2016 12:00:00 AM | 6x12 | Permit Number 777366 | 6003998.6 | 2101043.1 | 37.749290469922705 | -122.42897329466999 | (37.7492904699227, -122.42897329467) | |
| 142293 | 142293 | 115196 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 288 Hartford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 777365 | 6002703.4 | 2104224.0 | 37.7579510666244 | -122.43367942577 | (37.7579510666244, -122.43367942577) | |||
| 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) |
| 103477 | 103477 | 115280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1670 Sloat Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775682 | 5985986.6 | 2095938.5 | 37.73423859995479 | -122.49088271409599 | (37.7342385999548, -122.490882714096) | |||
| 105490 | 105490 | 115279 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1670 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775682 | 5985986.6 | 2095938.5 | 37.73423859995479 | -122.49088271409599 | (37.7342385999548, -122.490882714096) |
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");