Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25256 | 25256 | 238433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 272 Corbett Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 5999629.6727599995 | 2105348.1757099996 | 37.7608628875441 | -122.444390425487 | (37.7608628875441, -122.444390425487) | |||
| 31814 | 31814 | 196480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6012679.65409 | 2096682.3113 | 37.737804227083004 | -122.39864786201001 | (37.737804227083, -122.39864786201) | |||
| 39076 | 39076 | 123168 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 10th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5992809.72377 | 2111438.2053099996 | 37.7771930089585 | -122.468420491782 | (37.7771930089585, -122.468420491782) | ||||
| 76444 | 76444 | 196479 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 3ft | 6012661.099719999 | 2096663.01157 | 37.737750200312206 | -122.39871065986601 | (37.7377502003122, -122.398710659866) | |||
| 137004 | 137004 | 196478 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 3ft | 6012656.37794 | 2096656.5486400002 | 37.7377321913814 | -122.39872653201799 | (37.7377321913814, -122.398726532018) | |||
| 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) | |||
| 172744 | 172744 | 196477 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1499 Rankin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 3ft | 6012648.615180001 | 2096647.7620400002 | 37.7377076327033 | -122.39875275533501 | (37.7377076327033, -122.398752755335) | |||
| 34117 | 34117 | 237115 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Hwy 101 Southbound | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6005846.05822 | 2108984.84199 | 37.7712010306339 | -122.42314917169399 | (37.7712010306339, -122.423149171694) | ||||
| 76069 | 76069 | 237116 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Hwy 101 Southbound | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6005840.35144 | 2109000.46624 | 37.7712436090254 | -122.423170022474 | (37.7712436090254, -122.423170022474) | ||||
| 5494 | 5494 | 87738 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | ||
| 7662 | 7662 | 88451 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 3 | 5x12 | 6005480.84439 | 2121378.35155 | 37.805209901088396 | -122.425294529632 | (37.8052099010884, -122.425294529632) | ||
| 8626 | 8626 | 87739 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005433.618530001 | 2121623.41722 | 37.8058801199389 | -122.42547541206699 | (37.8058801199389, -122.425475412067) | ||
| 15485 | 15485 | 111661 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1398x Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/25/2015 01:32:00 PM | 3 | 3x3 | 6011721.86925 | 2101900.7924099998 | 37.7520796461774 | -122.402326221379 | (37.7520796461774, -122.402326221379) | ||
| 24090 | 24090 | 238060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Montezuma St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6007260.48935 | 2099759.47356 | 37.7459500163869 | -122.417602623671 | (37.7459500163869, -122.417602623671) | |||
| 71827 | 71827 | 196444 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200x Kansas St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 6011674.76736 | 2102721.10758 | 37.7543294225845 | -122.402546786399 | (37.7543294225845, -122.402546786399) | |||
| 90041 | 90041 | 23487 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | ||
| 93800 | 93800 | 22521 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6600 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/20/1992 12:00:00 AM | 3 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | ||
| 103844 | 103844 | 23488 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2004 12:00:00 AM | 6 | 9 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | ||
| 110120 | 110120 | 101655 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200X Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994672.4771300005 | 2099264.801 | 37.7438754024487 | -122.461094099214 | (37.7438754024487, -122.461094099214) | |||
| 120512 | 120512 | 23489 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2004 12:00:00 AM | 6 | 9 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | ||
| 124893 | 124893 | 29668 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500 Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/09/2004 12:00:00 AM | 6 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | |||
| 130339 | 130339 | 92531 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1298X Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6011695.143180001 | 2102366.06354 | 37.75335568701529 | -122.40245135756201 | (37.7533556870153, -122.402451357562) | ||||
| 142091 | 142091 | 22527 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6600 03rd St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | |||
| 158887 | 158887 | 121620 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300x Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 3x3 | 6011700.392659999 | 2102280.30315 | 37.7531205008135 | -122.402427173876 | (37.7531205008135, -122.402427173876) | |||
| 166035 | 166035 | 214700 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200x Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5994642.56982 | 2099211.09063 | 37.7437262061113 | -122.461193618499 | (37.7437262061113, -122.461193618499) | |||
| 187959 | 187959 | 88452 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 4 | 5x12 | 6005470.42698 | 2121378.16696 | 37.8052088057127 | -122.425330567252 | (37.8052088057127, -122.425330567252) | ||
| 25845 | 25845 | 237234 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5998175.72217 | 2105385.27781 | 37.7608816968555 | -122.449421648503 | (37.7608816968555, -122.449421648503) | |||
| 39376 | 39376 | 239418 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2106 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6002637.419840001 | 2099337.55033 | 37.7445302890331 | -122.433558405315 | (37.7445302890331, -122.433558405315) | ||||
| 42262 | 42262 | 214783 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 984 Portola Dr | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996077.08302 | 2098544.42751 | 37.7419781641671 | -122.456185254462 | (37.7419781641671, -122.456185254462) | |||
| 42756 | 42756 | 237448 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4609 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6000549.980269999 | 2101082.72419 | 37.7492034604754 | -122.440901499304 | (37.7492034604754, -122.440901499304) | |||
| 55416 | 55416 | 237434 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1206 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6001928.49113 | 2100507.97364 | 37.7477037465288 | -122.436093471852 | (37.7477037465288, -122.436093471852) | |||
| 72729 | 72729 | 239396 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4109 23rd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6002403.27601 | 2102357.88055 | 37.7528101150969 | -122.43458394808901 | (37.7528101150969, -122.434583948089) | |||
| 101358 | 101358 | 99777 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 492x Jersey St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 492-494x Jersey St 845-849 Diamond St | 6001966.3 | 2101499.0 | 37.7504270178067 | -122.43603363507799 | (37.7504270178067, -122.436033635078) | |||
| 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) | |||
| 136223 | 136223 | 179108 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 286 Trumbull St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6005259.27603 | 2094300.24021 | 37.7308473792844 | -122.42413437721301 | (37.7308473792844, -122.424134377213) | |||
| 137373 | 137373 | 136004 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1027 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 3ft | 6008655.5558400005 | 2118272.73317 | 37.796861491822604 | -122.41408816572999 | (37.7968614918226, -122.41408816573) | |||
| 146756 | 146756 | 237444 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 909 Douglass St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6001322.75854 | 2101029.25442 | 37.7491006275095 | -122.438225395692 | (37.7491006275095, -122.438225395692) | |||
| 150797 | 150797 | 214670 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2250 15th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 5991762.46474 | 2100100.36567 | 37.7460017588674 | -122.47121701506398 | (37.7460017588674, -122.471217015064) | ||||
| 152516 | 152516 | 179088 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 177 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6004073.80671 | 2092653.92212 | 37.7262599519094 | -122.428115457389 | (37.7262599519094, -122.428115457389) | |||
| 167681 | 167681 | 237432 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1204 Diamond St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6001926.67486 | 2100538.92391 | 37.7477886254592 | -122.436101966853 | (37.7477886254592, -122.436101966853) | ||||
| 170197 | 170197 | 237445 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 909 Douglass St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6001323.34412 | 2101039.65843 | 37.749129227744 | -122.43822411597701 | (37.749129227744, -122.438224115977) | |||
| 173492 | 173492 | 196442 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 971 Kansas St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 5ft | 6011633.4910699995 | 2103859.13783 | 37.7574518984069 | -122.402769561075 | (37.7574518984069, -122.402769561075) | |||
| 176153 | 176153 | 237433 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1206 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6001927.83941 | 2100530.44886 | 37.747765421138794 | -122.43609733352699 | (37.7477654211388, -122.436097333527) | |||
| 180881 | 180881 | 237295 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 614 Banks St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6008499.92821 | 2095980.82324 | 37.735644337901 | -122.413049665524 | (37.735644337901, -122.413049665524) | |||
| 187910 | 187910 | 237431 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1204 Diamond St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001926.93451 | 2100562.26984 | 37.747852742609204 | -122.43610273936899 | (37.7478527426092, -122.436102739369) | ||||
| 18402 | 18402 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | |||
| 23779 | 23779 | 213682 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000730.9848 | 2095013.8875 | 37.7325501736469 | -122.43984052053801 | (37.7325501736469, -122.439840520538) | |||
| 24054 | 24054 | 179073 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 Otsego Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6000546.4255099995 | 2092093.61368 | 37.724521267414296 | -122.440269236362 | (37.7245212674143, -122.440269236362) | |||
| 24513 | 24513 | 213290 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5994132.71522 | 2090951.16156 | 37.721017116620004 | -122.46235759304399 | (37.72101711662, -122.462357593044) | |||
| 24980 | 24980 | 213333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5991918.76578 | 2089524.2789200002 | 37.7169715101175 | -122.469906655166 | (37.7169715101175, -122.469906655166) | |||
| 27296 | 27296 | 213681 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6000730.35653 | 2095033.04499 | 37.7326027399078 | -122.439844065674 | (37.7326027399078, -122.439844065674) | |||
| 30565 | 30565 | 238390 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 80 Collingwood St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001989.17062 | 2105400.26005 | 37.7611402393495 | -122.436233705824 | (37.7611402393495, -122.436233705824) | |||
| 32334 | 32334 | 213694 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 219 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998610.14505 | 2093760.09504 | 37.728986602838205 | -122.447082546947 | (37.7289866028382, -122.447082546947) | ||||
| 32614 | 32614 | 213347 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 529 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5993232.83209 | 2090695.6130099997 | 37.7202635827786 | -122.465449643 | (37.7202635827786, -122.465449643) | |||
| 33059 | 33059 | 135939 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Walnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998471.02227 | 2116380.3328400003 | 37.7910881707365 | -122.44919247964701 | (37.7910881707365, -122.449192479647) | |||
| 36502 | 36502 | 214815 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 655 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5997076.755580001 | 2094378.60032 | 37.73059714113489 | -122.452428176541 | (37.7305971411349, -122.452428176541) | |||
| 37063 | 37063 | 213321 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 325 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5991673.594880001 | 2090710.5616 | 37.7202145769251 | -122.470840448236 | (37.7202145769251, -122.470840448236) | |||
| 37655 | 37655 | 213628 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 518 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5997988.71827 | 2097660.25448 | 37.739659985321495 | -122.449511768669 | (37.7396599853215, -122.449511768669) | |||
| 38858 | 38858 | 238309 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 84 Seward St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000741.11024 | 2104546.1812 | 37.758724158512 | -122.44048894251301 | (37.758724158512, -122.440488942513) | |||
| 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) | |||
| 40048 | 40048 | 214790 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valdez Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5995727.44967 | 2095481.9792400002 | 37.7335493555041 | -122.45717268576401 | (37.7335493555041, -122.457172685764) | |||
| 40188 | 40188 | 213362 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Elmhurst Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5991224.3842 | 2094533.07073 | 37.730684246775205 | -122.472671762002 | (37.7306842467752, -122.472671762002) | |||
| 41005 | 41005 | 196503 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 351 Tehama St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6011737.82052 | 2112830.87734 | 37.7820920832107 | -122.40303978397499 | (37.7820920832107, -122.403039783975) | |||
| 42134 | 42134 | 135965 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 Broadway | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001290.6793 | 2117307.18376 | 37.7937939330834 | -122.439503056242 | (37.7937939330834, -122.439503056242) | |||
| 43020 | 43020 | 238528 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 28 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6003301.9628099995 | 2097731.40275 | 37.740157861699295 | -122.431145932563 | (37.7401578616993, -122.431145932563) | |||
| 43068 | 43068 | 196481 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2075 Palou Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6012348.976530001 | 2097093.78891 | 37.738915629056 | -122.399820067148 | (37.738915629056, -122.399820067148) | |||
| 45979 | 45979 | 196501 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 351 Tehama St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6011701.40176 | 2112798.07009 | 37.7819999683719 | -122.403163468629 | (37.7819999683719, -122.403163468629) | |||
| 49359 | 49359 | 238529 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 32 Harry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6003245.126759999 | 2097701.12571 | 37.7400715069955 | -122.43134028773899 | (37.7400715069955, -122.431340287739) | ||||
| 50566 | 50566 | 238530 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Harry St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6003244.093780001 | 2097672.28705 | 37.7399922641312 | -122.43134180127701 | (37.7399922641312, -122.431341801277) | |||
| 51050 | 51050 | 196476 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2074 Revere Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6012584.77785 | 2096296.25792 | 37.7367389189762 | -122.398948809344 | (37.7367389189762, -122.398948809344) | |||
| 51861 | 51861 | 196502 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 351 Tehama St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6011719.28839 | 2112815.50725 | 37.7820488456301 | -122.403102815636 | (37.7820488456301, -122.403102815636) | |||
| 52062 | 52062 | 179041 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2908 20th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5990269.38069 | 2095895.56899 | 37.734369993170795 | -122.476072795627 | (37.7343699931708, -122.476072795627) | |||
| 53006 | 53006 | 239400 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Hoffman Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6000612.89044 | 2101776.73481 | 37.751112629454106 | -122.440733730797 | (37.7511126294541, -122.440733730797) | |||
| 54381 | 54381 | 123144 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 572 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5992865.77571 | 2111587.1444200003 | 37.7776051929209 | -122.46823742950501 | (37.7776051929209, -122.468237429505) | |||
| 55027 | 55027 | 239461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5725 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6000723.2907 | 2097082.5930400002 | 37.7382299184717 | -122.44001540269 | (37.7382299184717, -122.44001540269) | |||
| 55051 | 55051 | 135961 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2600 Divisadero St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6000735.77189 | 2117237.48779 | 37.793570969586895 | -122.44141807800399 | (37.7935709695869, -122.441418078004) | |||
| 55363 | 55363 | 213618 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5997823.37766 | 2095859.28539 | 37.7347054969618 | -122.449953678441 | (37.7347054969618, -122.449953678441) | |||
| 55934 | 55934 | 213683 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000730.40073 | 2094998.07335 | 37.732506718412 | -122.43984140637 | (37.732506718412, -122.43984140637) | |||
| 58106 | 58106 | 213327 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 331 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5991934.3542 | 2090733.0516599999 | 37.7202914059971 | -122.469940735003 | (37.7202914059971, -122.469940735003) | |||
| 58550 | 58550 | 214789 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 385 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5995719.97757 | 2095492.23955 | 37.7335770986874 | -122.45719926076401 | (37.7335770986874, -122.457199260764) | |||
| 59450 | 59450 | 196470 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1950 Newcomb Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 9ft | 6013295.589480001 | 2097174.20298 | 37.7391891560441 | -122.39655273032899 | (37.7391891560441, -122.396552730329) | |||
| 59687 | 59687 | 135938 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 Walnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5998466.03707 | 2116398.7314400002 | 37.791138403269294 | -122.44921105427 | (37.7911384032693, -122.44921105427) | |||
| 61128 | 61128 | 214484 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1868 17th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5990968.36883 | 2102715.12154 | 37.753135231722396 | -122.47415361899598 | (37.7531352317224, -122.474153618996) | |||
| 61617 | 61617 | 239399 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Hoffman Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6000615.20196 | 2101754.98366 | 37.751053037676 | -122.44072417728998 | (37.751053037676, -122.44072417729) | |||
| 62091 | 62091 | 214816 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 655 Hearst Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5997091.21284 | 2094378.0504 | 37.7305964594612 | -122.452378156221 | (37.7305964594612, -122.452378156221) | |||
| 62297 | 62297 | 213358 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 95 Beachmont Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5990836.79794 | 2095256.5707599998 | 37.7326483517269 | -122.474064462004 | (37.7326483517269, -122.474064462004) | |||
| 63673 | 63673 | 213341 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 455 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5992454.16583 | 2090885.02641 | 37.7207387260928 | -122.468154982671 | (37.7207387260928, -122.468154982671) | |||
| 67645 | 67645 | 239401 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Hoffman Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6000615.63827 | 2101746.4158900003 | 37.7510295374914 | -122.440722053988 | (37.7510295374914, -122.440722053988) | |||
| 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) | |||
| 68105 | 68105 | 213617 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 317 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5996181.3126 | 2095353.67754 | 37.7332231255301 | -122.455594290163 | (37.7332231255301, -122.455594290163) | |||
| 68665 | 68665 | 213332 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 151 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5991918.25557 | 2089546.87165 | 37.717033514761 | -122.46991006271999 | (37.717033514761, -122.46991006272) | |||
| 69441 | 69441 | 238308 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 84 Seward St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000740.70306 | 2104526.54658 | 37.7586702234594 | -122.440488942504 | (37.7586702234594, -122.440488942504) | |||
| 69824 | 69824 | 213337 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 280 Ralston St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5992227.25788 | 2089749.39386 | 37.717607448608796 | -122.468856729068 | (37.7176074486088, -122.468856729068) | |||
| 71219 | 71219 | 214483 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1868 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5990967.174319999 | 2102702.6319999998 | 37.7531008695265 | -122.47415683856899 | (37.7531008695265, -122.474156838569) | |||
| 73413 | 73413 | 239403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 338 Hoffman Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6000617.55151 | 2101735.06623 | 37.7509984830156 | -122.440714623806 | (37.7509984830156, -122.440714623806) | |||
| 74785 | 74785 | 213334 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 147 Byxbee St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5991917.942369999 | 2089508.58685 | 37.716928375916 | -122.469908359396 | (37.716928375916, -122.469908359396) | |||
| 75018 | 75018 | 124048 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 693 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5992526.55561 | 2110733.67497 | 37.775242199176795 | -122.469348757796 | (37.7752421991768, -122.469348757796) | ||||
| 75495 | 75495 | 214785 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 827 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5996599.5377 | 2095019.8783900002 | 37.7323305843738 | -122.454124279916 | (37.7323305843738, -122.454124279916) | ||||
| 76868 | 76868 | 196441 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 768 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6012093.04476 | 2104807.3138 | 37.7600810286241 | -122.401246859559 | (37.7600810286241, -122.401246859559) | ||||
| 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) |
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");