Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 178867 | 178867 | 250677 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 735 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5986302.66224 | 2114812.53014 | 37.78607993617911 | -122.49117856955 | (37.7860799361791, -122.49117856955) | |||
| 57812 | 57812 | 250934 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 259 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987104.958930001 | 2114216.89652 | 37.7844913413477 | -122.48835908522699 | (37.7844913413477, -122.488359085227) | |||
| 166797 | 166797 | 50876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 322 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | 7 | Permit Number 47534 | 5987167.73714 | 2113766.40078 | 37.7832580715076 | -122.48810878253401 | (37.7832580715076, -122.488108782534) | ||
| 39369 | 39369 | 250521 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 95 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5987685.5238 | 2115445.0256 | 37.787897288863796 | -122.48644075485201 | (37.7878972888638, -122.486440754852) | |||
| 26752 | 26752 | 250523 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 95 26th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5987685.92853 | 2115397.50584 | 37.78776683682629 | -122.48643586433998 | (37.7877668368263, -122.48643586434) | |||
| 132655 | 132655 | 250524 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 95 26th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5987685.45058 | 2115374.99193 | 37.7877049922276 | -122.486435864334 | (37.7877049922276, -122.486435864334) | |||
| 133247 | 133247 | 50771 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 638 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2004 12:00:00 AM | 7 | Permit Number 47314 | 5988487.7879800005 | 2111617.79391 | 37.7774355226981 | -122.48338443014799 | (37.7774355226981, -122.483384430148) | ||
| 170838 | 170838 | 68956 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 874 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32945 | 5988542.5052 | 2110035.3324599997 | 37.7730937088544 | -122.483079131422 | (37.7730937088544, -122.483079131422) | |
| 73738 | 73738 | 72374 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 766 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 7 | 5990089.45799 | 2110137.86742 | 37.7734651388758 | -122.477735579303 | (37.7734651388758, -122.477735579303) | ||
| 68712 | 68712 | 214661 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1207 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990516.2149 | 2103788.47288 | 37.756056167676796 | -122.47579561737899 | (37.7560561676768, -122.475795617379) | |||
| 70635 | 70635 | 213403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2115 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990666.17605 | 2100976.9204599997 | 37.7483450764622 | -122.475071772846 | (37.7483450764622, -122.475071772846) | |||
| 70879 | 70879 | 214481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1623 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5990862.01954 | 2104342.15602 | 37.7575964779098 | -122.474640129733 | (37.7575964779098, -122.474640129733) | |||
| 66278 | 66278 | 214511 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1256 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991129.134930001 | 2106870.28966 | 37.7645535343379 | -122.47390078539301 | (37.7645535343379, -122.473900785393) | |||
| 160968 | 160968 | 213417 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1500 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991348.87476 | 2098431.44962 | 37.7413954124699 | -122.47252548818001 | (37.7413954124699, -122.47252548818) | |||
| 133107 | 133107 | 213425 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2333 Cecilia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991441.219819999 | 2099500.5467 | 37.744336223447704 | -122.472284109241 | (37.7443362234477, -122.472284109241) | |||
| 147395 | 147395 | 213428 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2356 Cecilia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991465.99867 | 2099400.33215 | 37.744062494091 | -122.472191126522 | (37.744062494091, -122.472191126522) | |||
| 155818 | 155818 | 213407 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2281 Cecilia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991478.9532699995 | 2099887.90451 | 37.7454019920197 | -122.47218186622 | (37.7454019920197, -122.47218186622) | |||
| 47537 | 47537 | 213432 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2330 Cecilia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991474.23883 | 2099545.3415099997 | 37.744461129378 | -122.472173202136 | (37.744461129378, -122.472173202136) | |||
| 179415 | 179415 | 213431 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2336 Cecilia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991475.01091 | 2099520.48282 | 37.74439291849001 | -122.472168720814 | (37.74439291849, -122.472168720814) | |||
| 71505 | 71505 | 213438 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2310 Cecilia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991478.325209999 | 2099662.36916 | 37.7447826936787 | -122.472167601152 | (37.7447826936787, -122.472167601152) | |||
| 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) | |||
| 27213 | 27213 | 123061 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 464 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5991908.507730001 | 2112261.53902 | 37.7794015624552 | -122.47159806739799 | (37.7794015624552, -122.471598067398) | |||
| 51860 | 51860 | 123039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 586 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5991933.9124300005 | 2111475.88268 | 37.777245834278 | -122.47145291941601 | (37.777245834278, -122.471452919416) | |||
| 39666 | 39666 | 213322 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991674.008280001 | 2090730.18875 | 37.720268492169296 | -122.470840448222 | (37.7202684921693, -122.470840448222) | |||
| 31968 | 31968 | 213326 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 333 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991939.8499300005 | 2090759.9353900002 | 37.7203655398194 | -122.46992369461701 | (37.7203655398194, -122.469923694617) | |||
| 156124 | 156124 | 213373 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1623 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5992438.33257 | 2104386.8742299997 | 37.757810473397605 | -122.46919190279101 | (37.7578104733976, -122.469191902791) | |||
| 41242 | 41242 | 213372 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1695 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992451.123869999 | 2104023.5243900004 | 37.756813548812794 | -122.46912122148198 | (37.7568135488128, -122.469121221482) | |||
| 163139 | 163139 | 213469 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 134 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992386.6287 | 2098205.19502 | 37.740834186951396 | -122.468920866899 | (37.7408341869514, -122.468920866899) | |||
| 60874 | 60874 | 214690 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992455.885480001 | 2098286.40938 | 37.7410611821255 | -122.468687312988 | (37.7410611821255, -122.468687312988) | |||
| 135510 | 135510 | 214623 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1405 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992699.2887699995 | 2105840.21181 | 37.7618160331047 | -122.46839514841801 | (37.7618160331047, -122.468395148418) | |||
| 69686 | 69686 | 214618 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1318 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5992726.7392 | 2106452.86445 | 37.7634998014025 | -122.46834478191299 | (37.7634998014025, -122.468344781913) | |||
| 50996 | 50996 | 213444 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2351 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992608.79172 | 2099462.0696400004 | 37.7442980787015 | -122.468244128866 | (37.7442980787015, -122.468244128866) | |||
| 160670 | 160670 | 213443 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2379 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992616.385419999 | 2099292.02218 | 37.743831610246 | -122.468205503896 | (37.743831610246, -122.468205503896) | |||
| 50591 | 50591 | 214626 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1490 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5992765.05186 | 2105331.6268700003 | 37.7604233906498 | -122.468130704575 | (37.7604233906498, -122.468130704575) | |||
| 46698 | 46698 | 214631 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1776 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5992834.36322 | 2103387.96848 | 37.7550906141526 | -122.467749627638 | (37.7550906141526, -122.467749627638) | |||
| 62002 | 62002 | 214782 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1627 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5992928.85631 | 2095341.1686900002 | 37.733001600925 | -122.466837912033 | (37.733001600925, -122.466837912033) | |||
| 64442 | 64442 | 123762 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 715 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993380.466569999 | 2110693.3554599998 | 37.775180801458795 | -122.46639197909599 | (37.7751808014588, -122.466391979096) | |||
| 39553 | 39553 | 213453 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Dorantes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993154.524540001 | 2099672.2697099997 | 37.7449067389721 | -122.46637239059099 | (37.7449067389721, -122.466372390591) | |||
| 34760 | 34760 | 213591 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2038 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993200.871040001 | 2101602.44663 | 37.75020918670911 | -122.466352387876 | (37.7502091867091, -122.466352387876) | |||
| 147855 | 147855 | 213348 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 438 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993267.15159 | 2090112.97171 | 37.7186657698839 | -122.46528871291599 | (37.7186657698839, -122.465288712916) | |||
| 164627 | 164627 | 213356 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 128 Shields St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5993609.42924 | 2089850.5677200002 | 37.717965004654495 | -122.464086568463 | (37.7179650046545, -122.464086568463) | |||
| 160414 | 160414 | 213608 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 31 Fairfield Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993869.7323900005 | 2093013.6052400002 | 37.7266649400141 | -122.46341623267 | (37.7266649400141, -122.46341623267) | |||
| 51607 | 51607 | 214770 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 328 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994294.76269 | 2100935.2317 | 37.748440240943204 | -122.462521279527 | (37.7484402409432, -122.462521279527) | |||
| 182686 | 182686 | 213280 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 370 Ashton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994204.93621 | 2092304.65471 | 37.7247376407218 | -122.462206059074 | (37.7247376407218, -122.462206059074) | |||
| 129580 | 129580 | 68530 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 632 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32411 | 5994733.00638 | 2111219.97817 | 37.7767047179401 | -122.461751466472 | (37.7767047179401, -122.461751466472) | |
| 76058 | 76058 | 214695 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5994531.06764 | 2099914.59728 | 37.7456514414536 | -122.46163015929899 | (37.7456514414536, -122.461630159299) | |||
| 67348 | 67348 | 50606 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 219 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2003 12:00:00 AM | 7 | Permit Number 47205 | 5994896.0666 | 2113978.5362299997 | 37.784288365194996 | -122.461387423321 | (37.784288365195, -122.461387423321) | ||
| 156414 | 156414 | 213668 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Edgehill Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 3ft | 5994864.53372 | 2098940.09364 | 37.742994887300895 | -122.460406494088 | (37.7429948873009, -122.460406494088) | |||
| 66676 | 66676 | 213286 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 361 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994727.8524400005 | 2090960.34895 | 37.7210765950904 | -122.460301059362 | (37.7210765950904, -122.460301059362) | |||
| 68722 | 68722 | 213285 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 361 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994728.2194300005 | 2090977.86647 | 37.721124715117995 | -122.460301059356 | (37.721124715118, -122.460301059356) | |||
| 76653 | 76653 | 213500 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 777 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994870.75365 | 2093146.80923 | 37.7270883084579 | -122.45996540448 | (37.7270883084579, -122.45996540448) | |||
| 157637 | 157637 | 213481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5995034.05151 | 2100934.56273 | 37.7484809505562 | -122.45996480284201 | (37.7484809505562, -122.459964802842) | |||
| 51859 | 51859 | 214798 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Juanita Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995023.55094 | 2097563.83424 | 37.7392251667135 | -122.459756993785 | (37.7392251667135, -122.459756993785) | |||
| 130209 | 130209 | 214797 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995039.23542 | 2097556.26401 | 37.7392052826872 | -122.459702216086 | (37.7392052826872, -122.459702216086) | |||
| 49680 | 49680 | 214796 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 336 Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995062.32448 | 2097542.59009 | 37.7391690651991 | -122.45962139492701 | (37.7391690651991, -122.459621394927) | |||
| 147639 | 147639 | 213305 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 223 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995012.40881 | 2087891.7837 | 37.712667406052496 | -122.45909535897499 | (37.7126674060525, -122.459095358975) | |||
| 73393 | 73393 | 64860 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 7 | Permit Number 25876 | 5995898.384980001 | 2112421.39255 | 37.7800705003105 | -122.457807060175 | (37.7800705003105, -122.457807060175) | |
| 137695 | 137695 | 214748 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995627.33147 | 2093578.0296099999 | 37.728315820111206 | -122.457381125259 | (37.7283158201112, -122.457381125259) | |||
| 186400 | 186400 | 214739 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 163 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995642.708819999 | 2093778.0293599998 | 37.7288658544767 | -122.457342428316 | (37.7288658544767, -122.457342428316) | |||
| 174447 | 174447 | 214741 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995646.65866 | 2093691.6399400001 | 37.7286288768052 | -122.457322526337 | (37.7286288768052, -122.457322526337) | |||
| 31889 | 31889 | 214758 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5995633.68738 | 2092918.64015 | 37.7265056601867 | -122.457311470041 | (37.7265056601867, -122.457311470041) | |||
| 149473 | 149473 | 213517 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995657.9114 | 2093576.16628 | 37.728312460239 | -122.45727527503 | (37.728312460239, -122.45727527503) | |||
| 50711 | 50711 | 213511 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 150 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995678.2658 | 2093705.9591 | 37.728670009096604 | -122.457214294721 | (37.7286700090966, -122.457214294721) | |||
| 153101 | 153101 | 214648 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996112.805480001 | 2106851.3196400004 | 37.7647888500462 | -122.456662349289 | (37.7647888500462, -122.456662349289) | |||
| 48145 | 48145 | 213532 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1321 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995868.11744 | 2092855.1447 | 37.726344778666004 | -122.456496470238 | (37.726344778666, -122.456496470238) | |||
| 156212 | 156212 | 213288 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1039 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995905.05181 | 2090820.4262299999 | 37.720760046333496 | -122.456221739052 | (37.7207600463335, -122.456221739052) | |||
| 46671 | 46671 | 214787 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Robinhood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5996140.97875 | 2096605.13185 | 37.7366570006238 | -122.455824168555 | (37.7366570006238, -122.455824168555) | |||
| 138154 | 138154 | 213546 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996160.95111 | 2093881.0696900003 | 37.729178530763704 | -122.45555828401001 | (37.7291785307637, -122.45555828401) | |||
| 76147 | 76147 | 213552 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 159 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996195.23273 | 2094521.1933400002 | 37.7309381235969 | -122.45548601716999 | (37.7309381235969, -122.45548601717) | |||
| 131464 | 131464 | 82264 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Parsons St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 51587 | 5996552.33685 | 2110597.55386 | 37.775100265791394 | -122.455412906224 | (37.7751002657914, -122.455412906224) | |
| 130098 | 130098 | 213561 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Montecito Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996368.30466 | 2094246.96905 | 37.7301950992263 | -122.45486787625099 | (37.7301950992263, -122.454867876251) | |||
| 25588 | 25588 | 213562 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 145 Hazelwood Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5996449.59751 | 2094511.04667 | 37.7309248558938 | -122.454605908258 | (37.7309248558938, -122.454605908258) | |||
| 29134 | 29134 | 213564 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996496.71182 | 2094497.05235 | 37.730889133023894 | -122.454442016707 | (37.7308891330239, -122.454442016707) | |||
| 184536 | 184536 | 214808 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 550 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5996759.66261 | 2093640.1443 | 37.7285513453471 | -122.453471111309 | (37.7285513453471, -122.453471111309) | |||
| 48498 | 48498 | 214807 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 550 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5996780.18786 | 2093638.94841 | 37.72854923825879 | -122.45340006847799 | (37.7285492382588, -122.453400068478) | |||
| 170585 | 170585 | 237238 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 160 Belgrave Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997759.67882 | 2104910.90723 | 37.7595553865982 | -122.45082634726002 | (37.7595553865982, -122.45082634726) | |||
| 24205 | 24205 | 135941 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998124.31484 | 2115011.10892 | 37.787308808511604 | -122.45029332808998 | (37.7873088085116, -122.45029332809) | |||
| 133475 | 133475 | 178977 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Rae Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5997636.8287 | 2087155.6990200002 | 37.71079680899621 | -122.449971558745 | (37.7107968089962, -122.449971558745) | |||
| 133870 | 133870 | 237233 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998197.90052 | 2105385.6119999997 | 37.760883883112506 | -122.449344967798 | (37.7608838831125, -122.449344967798) | |||
| 67810 | 67810 | 213625 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Sequoia Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5998243.47992 | 2097619.18832 | 37.73956179822439 | -122.448627959023 | (37.7395617982244, -122.448627959023) | |||
| 78887 | 78887 | 47481 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1809 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45377 | 5999494.3233199995 | 2115164.49026 | 37.7878082622913 | -122.445564438253 | (37.7878082622913, -122.445564438253) | |
| 186638 | 186638 | 238427 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Mars St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999551.73328 | 2105494.96582 | 37.761261489550705 | -122.444670533732 | (37.7612614895507, -122.444670533732) | |||
| 181618 | 181618 | 239476 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 192 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5999659.94513 | 2106593.00366 | 37.7642826027833 | -122.444375189158 | (37.7642826027833, -122.444375189158) | |||
| 54367 | 54367 | 213646 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999502.91716 | 2096107.4577900001 | 37.735482879036105 | -122.444164784704 | (37.7354828790361, -122.444164784704) | |||
| 132126 | 132126 | 213640 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Malta Dr | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999549.40588 | 2096053.5305299999 | 37.735337459545605 | -122.444000182688 | (37.7353374595456, -122.444000182688) | |||
| 136441 | 136441 | 238408 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 227 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999936.15736 | 2105561.41019 | 37.7614658586796 | -122.44334575050199 | (37.7614658586796, -122.443345750502) | |||
| 45771 | 45771 | 48784 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 268 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | 7 | Permit Number 46039 | 6000083.90087 | 2091529.02554 | 37.7229446929396 | -122.44182761574801 | (37.7229446929396, -122.441827615748) | ||
| 185527 | 185527 | 237450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Fountain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000333.56461 | 2101396.44944 | 37.750052546398 | -122.441672377502 | (37.750052546398, -122.441672377502) | |||
| 25262 | 25262 | 237451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4407 24th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000528.815780001 | 2101672.95433 | 37.7508228849759 | -122.441017024421 | (37.7508228849759, -122.441017024421) | |||
| 37021 | 37021 | 52927 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 7 | Permit Number 48911 | 6000347.40158 | 2092558.92243 | 37.7257875650324 | -122.44099059964199 | (37.7257875650324, -122.440990599642) | |
| 38127 | 38127 | 179057 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000509.01333 | 2093743.60898 | 37.7290496453045 | -122.440516852064 | (37.7290496453045, -122.440516852064) | |||
| 33723 | 33723 | 179058 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000523.58378 | 2093733.7871599998 | 37.729023506521294 | -122.44046577686899 | (37.7290235065213, -122.440465776869) | |||
| 69506 | 69506 | 51979 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 7 | 3x3 | Permit Number 775837 | 6000531.055869999 | 2092082.3650200001 | 37.7244895060779 | -122.440321560704 | (37.7244895060779, -122.440321560704) | |
| 153792 | 153792 | 68094 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 7 | Permit Number 31838 | 6000539.95972 | 2091455.5942900002 | 37.7227690436428 | -122.440245854872 | (37.7227690436428, -122.440245854872) | |
| 163917 | 163917 | 79764 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 26 Wanda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 7 | 6000559.455569999 | 2091550.49268 | 37.723030722971394 | -122.440185263946 | (37.7230307229714, -122.440185263946) | ||
| 54203 | 54203 | 78243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 7 | 6000646.02726 | 2093117.37413 | 37.727337949475896 | -122.439998300301 | (37.7273379494759, -122.439998300301) | ||
| 40984 | 40984 | 239422 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 866 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000847.1085 | 2102022.76139 | 37.751801494864395 | -122.439941420873 | (37.7518014948644, -122.439941420873) | |||
| 184236 | 184236 | 65288 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Rico Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/1990 12:00:00 AM | 7 | Permit Number 28836 | 6001457.593230001 | 2121333.88235 | 37.8048596843835 | -122.439214266819 | (37.8048596843835, -122.439214266819) | |
| 73174 | 73174 | 239450 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Mizpah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001052.8438 | 2096432.45143 | 37.736463536652295 | -122.438829397462 | (37.7364635366523, -122.438829397462) | |||
| 38699 | 38699 | 52528 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | 7 | Permit Number 48628 | 6001332.37944 | 2092272.13723 | 37.725056169781205 | -122.437565081984 | (37.7250561697812, -122.437565081984) |
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");