Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4704 | 4704 | 253666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993791.71774 | 2111566.05198 | 37.7776007134003 | -122.465032776868 | (37.7776007134003, -122.465032776868) | ||||
| 3822 | 3822 | 253559 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993184.39566 | 2099612.1282900004 | 37.7447433294416 | -122.46626473273199 | (37.7447433294416, -122.466264732732) | ||||
| 3396 | 3396 | 253424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 1749 | 1749 | 251678 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1841 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989656.0 | 2102823.0 | 37.7533553254519 | -122.478699889248 | (37.7533553254519, -122.478699889248) | ||||
| 71 | 71 | 251206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005145.0 | 2094297.0 | 37.7308320294825 | -122.424529217878 | (37.7308320294825, -122.424529217878) | ||||
| 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) | |||
| 126747 | 126747 | 250902 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 266 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986843.33005 | 2114156.49339 | 37.7843102232907 | -122.489259776936 | (37.7843102232907, -122.489259776936) | |||
| 70024 | 70024 | 250882 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 154 29th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5986822.39512 | 2114740.35297 | 37.7859121118945 | -122.48937514824699 | (37.7859121118945, -122.489375148247) | |||
| 172451 | 172451 | 250881 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 154 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986823.250630001 | 2114733.9114599996 | 37.78589447530229 | -122.489371714655 | (37.7858944753023, -122.489371714655) | |||
| 56077 | 56077 | 250876 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 30th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986468.29527 | 2114661.08637 | 37.7856737915584 | -122.490594385245 | (37.7856737915584, -122.490594385245) | |||
| 166433 | 166433 | 250875 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 125 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986467.14332 | 2114671.0752 | 37.7857011507179 | -122.490599105783 | (37.7857011507179, -122.490599105783) | |||
| 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) | |||
| 166651 | 166651 | 250870 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 30th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986470.3680300005 | 2114630.24299 | 37.7855892256034 | -122.490584944137 | (37.7855892256034, -122.490584944137) | |||
| 180995 | 180995 | 250869 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986468.30668 | 2114640.25117 | 37.785616584774104 | -122.490592812307 | (37.7856165847741, -122.490592812307) | |||
| 132130 | 132130 | 250868 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986468.4993 | 2114649.30576 | 37.7856414573183 | -122.490592812321 | (37.7856414573183, -122.490592812321) | |||
| 75705 | 75705 | 250820 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 60 Sea View Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986182.97775 | 2114165.47247 | 37.7842963089586 | -122.49154499381599 | (37.7842963089586, -122.491544993816) | |||
| 153946 | 153946 | 250819 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 60 Sea View Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986191.04243 | 2114164.9353 | 37.7842953053345 | -122.49151705368999 | (37.7842953053345, -122.49151705369) | |||
| 147077 | 147077 | 250761 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 228 32nd Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985903.37202 | 2114379.41265 | 37.7848673829594 | -122.49252807871001 | (37.7848673829594, -122.49252807871) | |||
| 73215 | 73215 | 250760 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 228 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5985903.61307 | 2114361.31306 | 37.7848177008131 | -122.492525911365 | (37.7848177008131, -122.492525911365) | |||
| 170118 | 170118 | 250758 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 214 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985901.94322 | 2114466.62788 | 37.785106767213705 | -122.49253944703699 | (37.7851067672137, -122.492539447037) | |||
| 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) | |||
| 40381 | 40381 | 250676 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 735 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5986293.297259999 | 2114811.88275 | 37.786077611448 | -122.49121092176 | (37.786077611448, -122.49121092176) | |||
| 135875 | 135875 | 250645 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987300.52243 | 2114656.77456 | 37.78571052885479 | -122.48771483877199 | (37.7857105288548, -122.487714838772) | |||
| 39473 | 39473 | 250644 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987312.1046400005 | 2114657.5756599996 | 37.785713403992 | -122.487674827026 | (37.785713403992, -122.487674827026) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 27074 | 27074 | 250328 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 27th Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987394.32135 | 2114885.37066 | 37.7863436587784 | -122.487407123146 | (37.7863436587784, -122.487407123146) | |||
| 158284 | 158284 | 250003 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 232 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 0ft | 6011516.941380001 | 2120107.55399 | 37.802059763016096 | -122.404316256511 | (37.8020597630161, -122.404316256511) | |||
| 171242 | 171242 | 249941 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011275.707669999 | 2120025.2952 | 37.8018204174494 | -122.40514524887199 | (37.8018204174494, -122.405145248872) | |||
| 132944 | 132944 | 249940 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011278.90186 | 2120029.10977 | 37.80183106989429 | -122.40513446418801 | (37.8018310698943, -122.405134464188) | |||
| 64904 | 64904 | 249855 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 241 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011547.42399 | 2120404.90985 | 37.802877932936504 | -122.40423171211901 | (37.8028779329365, -122.404231712119) | |||
| 47683 | 47683 | 247785 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 310 30th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6004480.1773 | 2098425.89767 | 37.7421314823968 | -122.42712159768101 | (37.7421314823968, -122.427121597681) | |||
| 186096 | 186096 | 246690 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Stoneman St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6008005.33416 | 2099391.14992 | 37.7449805661161 | -122.41500097851002 | (37.7449805661161, -122.41500097851) | ||||
| 51687 | 51687 | 246689 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Stoneman St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6008012.99299 | 2099394.86915 | 37.744991208669504 | -122.414974758775 | (37.7449912086695, -122.414974758775) | ||||
| 69577 | 69577 | 246688 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 51 Stoneman St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6008021.86099 | 2099397.11663 | 37.7449978780651 | -122.41494425378 | (37.7449978780651, -122.41494425378) | ||||
| 58834 | 58834 | 246596 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Waller St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005499.23386 | 2109278.3771900004 | 37.771987429293794 | -122.424369733388 | (37.7719874292938, -122.424369733388) | |||
| 132424 | 132424 | 246595 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Waller St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005513.49124 | 2109280.44319 | 37.77199390711311 | -122.424320562945 | (37.7719939071131, -122.424320562945) | |||
| 173717 | 173717 | 246594 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Waller St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005538.63737 | 2109282.04946 | 37.771999737437206 | -122.424233694733 | (37.7719997374372, -122.424233694733) | |||
| 169968 | 169968 | 246593 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Waller St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005556.53311 | 2109286.77456 | 37.7720137218797 | -122.424172128036 | (37.7720137218797, -122.424172128036) | |||
| 180388 | 180388 | 246511 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 207 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005075.21268 | 2099872.36362 | 37.746136778598 | -122.42516705074101 | (37.746136778598, -122.425167050741) | |||
| 61043 | 61043 | 246498 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 313 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6004359.59327 | 2099835.65026 | 37.745995519392295 | -122.42763895699 | (37.7459955193923, -122.42763895699) | |||
| 25479 | 25479 | 246475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004316.48172 | 2099879.2195200003 | 37.7461127118429 | -122.427791134863 | (37.7461127118429, -122.427791134863) | |||
| 66508 | 66508 | 246474 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 312 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004388.68199 | 2099882.3051 | 37.746125268169706 | -122.42754169531601 | (37.7461252681697, -122.427541695316) | |||
| 31951 | 31951 | 246463 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Duncan St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6005105.34641 | 2099923.38039 | 37.746278561223605 | -122.42506648135 | (37.7462785612236, -122.42506648135) | |||
| 146677 | 146677 | 246461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Duncan St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6005134.84006 | 2099924.67887 | 37.7462837925778 | -122.424964588148 | (37.7462837925778, -122.424964588148) | |||
| 27319 | 27319 | 246424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 418 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6003710.7768 | 2099847.4001700003 | 37.7459910605319 | -122.429883314964 | (37.7459910605319, -122.429883314964) | |||
| 34 | 34 | 240126 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006399.28254 | 2110261.0751 | 37.7747364652596 | -122.42132618837299 | (37.7747364652596, -122.421326188373) | |||
| 64826 | 64826 | 239556 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 222 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006749.08669 | 2098198.6867400003 | 37.741635656457 | -122.419260290053 | (37.741635656457, -122.419260290053) | |||
| 41928 | 41928 | 239555 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 83 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006204.59449 | 2097700.8031099997 | 37.7402378995646 | -122.421107619815 | (37.7402378995646, -122.421107619815) | |||
| 46645 | 46645 | 239554 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 115 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006386.35805 | 2098191.38212 | 37.7415951644956 | -122.42051396747101 | (37.7415951644956, -122.420513967471) | |||
| 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) | |||
| 75543 | 75543 | 239552 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 29 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006988.28189 | 2099581.68079 | 37.7454465165508 | -122.418531277097 | (37.7454465165508, -122.418531277097) | |||
| 73105 | 73105 | 239551 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 121 Kingston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005985.55135 | 2098206.06147 | 37.7416128748431 | -122.421900865949 | (37.7416128748431, -122.421900865949) | |||
| 150786 | 150786 | 239550 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 173 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007148.228630001 | 2098090.56095 | 37.7413612382336 | -122.417872525497 | (37.7413612382336, -122.417872525497) | |||
| 55558 | 55558 | 239549 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 511 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006925.075680001 | 2097949.2793900003 | 37.740960749435295 | -122.41863409569099 | (37.7409607494353, -122.418634095691) | |||
| 40503 | 40503 | 239548 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 229 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6006756.29841 | 2097775.0153900003 | 37.7404727557057 | -122.419205308176 | (37.7404727557057, -122.419205308176) | |||
| 60745 | 60745 | 239547 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 222 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007079.84049 | 2097669.6869900003 | 37.7402017630091 | -122.418079158229 | (37.7402017630091, -122.418079158229) | |||
| 45412 | 45412 | 239546 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 234 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007043.97235 | 2097599.78307 | 37.7400078035106 | -122.418198221295 | (37.7400078035106, -122.418198221295) | |||
| 40487 | 40487 | 239545 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 98 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007158.6919599995 | 2097383.79915 | 37.7394212162163 | -122.417786261644 | (37.7394212162163, -122.417786261644) | |||
| 58131 | 58131 | 239544 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 91 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007182.00683 | 2097328.45529 | 37.7392705662735 | -122.41770172716801 | (37.7392705662735, -122.417701727168) | |||
| 52504 | 52504 | 239541 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007189.61469 | 2097414.0271400004 | 37.7395059557214 | -122.417681486136 | (37.7395059557214, -122.417681486136) | |||
| 38819 | 38819 | 239540 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007190.57712 | 2097427.3810900003 | 37.7395426768657 | -122.417679104726 | (37.7395426768657, -122.417679104726) | |||
| 59864 | 59864 | 239539 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007197.88288 | 2097498.21378 | 37.739737578835204 | -122.417658863675 | (37.7397375788352, -122.417658863675) | |||
| 39343 | 39343 | 239538 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 17 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007204.198059999 | 2097571.12365 | 37.739938128529204 | -122.417642194727 | (37.7399381285292, -122.417642194727) | |||
| 48583 | 48583 | 239537 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 11 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007207.949109999 | 2097619.73987 | 37.7400718289571 | -122.41763267000799 | (37.7400718289571, -122.417632670008) | |||
| 165066 | 165066 | 239536 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 7 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007212.48694 | 2097673.14055 | 37.7402187107189 | -122.41762076389999 | (37.7402187107189, -122.4176207639) | |||
| 22246 | 22246 | 239535 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007214.411780001 | 2097683.0452099997 | 37.7402460150284 | -122.417614810389 | (37.7402460150284, -122.417614810389) | ||||
| 20033 | 20033 | 239534 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007215.03698 | 2097696.74866 | 37.7402836768401 | -122.417613619697 | (37.7402836768401, -122.417613619697) | ||||
| 27495 | 27495 | 239533 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007383.2687800005 | 2097890.8152900003 | 37.7408260058127 | -122.417045687025 | (37.7408260058127, -122.417045687025) | |||
| 69055 | 69055 | 239532 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007362.80754 | 2097682.06201 | 37.7402516645702 | -122.41710164643801 | (37.7402516645702, -122.417101646438) | |||
| 64555 | 64555 | 239531 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 122 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007359.24637 | 2097609.09568 | 37.7400511148656 | -122.417108790654 | (37.7400511148656, -122.417108790654) | |||
| 29303 | 29303 | 239530 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 142 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007356.16273 | 2097559.43734 | 37.7399145905948 | -122.417115934858 | (37.7399145905948, -122.417115934858) | |||
| 58822 | 58822 | 239529 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 85 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007405.607559999 | 2097821.4337400002 | 37.7406367560843 | -122.41696353305099 | (37.7406367560843, -122.416963533051) | |||
| 47196 | 47196 | 239528 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1304 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009160.31566 | 2097453.89362 | 37.7397261196631 | -122.410870449031 | (37.7397261196631, -122.410870449031) | |||
| 66562 | 66562 | 239527 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 216 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009524.89815 | 2097270.5071099997 | 37.739243016440795 | -122.40959693254999 | (37.7392430164408, -122.40959693255) | |||
| 48001 | 48001 | 239526 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 90 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009313.28362 | 2096939.56022 | 37.738322447926706 | -122.410305243092 | (37.7383224479267, -122.410305243092) | |||
| 25654 | 25654 | 239525 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 86 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009315.75125 | 2096958.2130200001 | 37.738373802798 | -122.41029802783501 | (37.738373802798, -122.410298027835) | |||
| 137234 | 137234 | 239524 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 76 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009320.898519999 | 2097005.90416 | 37.7385050408634 | -122.410283597331 | (37.7385050408634, -122.410283597331) | |||
| 180862 | 180862 | 239523 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 102 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009546.51282 | 2097971.75612 | 37.7411697051097 | -122.40957167870701 | (37.7411697051097, -122.409571678707) | |||
| 131188 | 131188 | 239522 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Nebraska St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009287.77496 | 2097929.2494900003 | 37.7410384895229 | -122.41046330434901 | (37.7410384895229, -122.410463304349) | |||
| 73579 | 73579 | 239521 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009178.34843 | 2097439.10396 | 37.739686521604796 | -122.410807054895 | (37.7396865216048, -122.410807054895) | |||
| 45705 | 45705 | 239520 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009174.2731800005 | 2097387.06102 | 37.739543394514705 | -122.41081747084299 | (37.7395433945147, -122.410817470843) | |||
| 187085 | 187085 | 239519 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Putnam St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009111.365619999 | 2096703.94776 | 37.7376641864385 | -122.41098674217 | (37.7376641864385, -122.41098674217) | |||
| 56382 | 56382 | 239518 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 518 Nevada St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008859.919290001 | 2095921.12965 | 37.7355006343334 | -122.411800816557 | (37.7355006343334, -122.411800816557) | |||
| 115941 | 115941 | 239517 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 290 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008955.56273 | 2096972.02468 | 37.7383915293498 | -122.41154436407601 | (37.7383915293498, -122.411544364076) | |||
| 188794 | 188794 | 239516 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 248 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008976.50075 | 2097193.92135 | 37.739001983760296 | -122.411487642954 | (37.7390019837603, -122.411487642954) | |||
| 142755 | 142755 | 239515 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 232 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008982.58188 | 2097271.59989 | 37.7392156132066 | -122.411472103573 | (37.7392156132066, -122.411472103573) | |||
| 45808 | 45808 | 239514 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 124 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008829.96224 | 2097957.37744 | 37.7410900467809 | -122.412048247039 | (37.7410900467809, -122.412048247039) | |||
| 47241 | 47241 | 239513 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 126 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008827.2981900005 | 2097928.51469 | 37.7410106465187 | -122.412055419131 | (37.7410106465187, -122.412055419131) | |||
| 56137 | 56137 | 239512 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 184 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008807.60125 | 2097692.07072 | 37.7403603179715 | -122.41210681810101 | (37.7403603179715, -122.412106818101) | |||
| 63063 | 63063 | 239511 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 368 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008784.34963 | 2097059.5549 | 37.7386222630119 | -122.41214252205499 | (37.7386222630119, -122.412142522055) | |||
| 44863 | 44863 | 239510 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 402 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008765.7261 | 2096876.2315900002 | 37.738117852164294 | -122.41219396058099 | (37.7381178521643, -122.412193960581) | |||
| 50623 | 50623 | 239509 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 444 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008753.78485 | 2096712.524 | 37.737667676711794 | -122.412223680483 | (37.7376676767118, -122.412223680483) | |||
| 43390 | 43390 | 239508 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008645.57123 | 2097204.44722 | 37.7390123178534 | -122.412632593227 | (37.7390123178534, -122.412632593227) | |||
| 37823 | 37823 | 239507 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008641.776000001 | 2097174.69349 | 37.738930407604606 | -122.41264361263599 | (37.7389304076046, -122.412643612636) | |||
| 24566 | 24566 | 239506 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 405 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008613.321269999 | 2096852.4753900003 | 37.738044069977605 | -122.412719223109 | (37.7380440699776, -122.412719223109) | |||
| 27433 | 27433 | 239505 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 407 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008610.5608 | 2096828.12275 | 37.737977048001106 | -122.412727046317 | (37.7379770480011, -122.412727046317) | |||
| 168693 | 168693 | 239504 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 447 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008598.51297 | 2096699.9408200001 | 37.737624412144 | -122.412759642259 | (37.737624412144, -122.412759642259) | |||
| 75270 | 75270 | 239503 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3769 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008444.934230001 | 2097359.11004 | 37.7394257254265 | -122.41333724082399 | (37.7394257254265, -122.413337240824) |
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");