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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 157439 | 157439 | 30897 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 252 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | 7 | Permit Number 34724 | 6007528.97575 | 2097493.2020099997 | 37.739742443263296 | -122.416513727228 | (37.7397424432633, -122.416513727228) | |
| 73045 | 73045 | 31021 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 317 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34787 | 6002776.11429 | 2086581.1916200002 | 37.7095120680942 | -122.432168021935 | (37.7095120680942, -122.432168021935) | |
| 61324 | 61324 | 31297 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34941 | 6002026.478019999 | 2105548.36068 | 37.7615490072959 | -122.43611527411899 | (37.7615490072959, -122.436115274119) | ||
| 19771 | 19771 | 31446 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 239 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 7 | Permit Number 35021 | 6002088.5838 | 2104465.22029 | 37.758578494425294 | -122.435822975577 | (37.7585784944253, -122.435822975577) | |
| 163171 | 163171 | 32104 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 242 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 7 | Permit Number 35476 | 6002688.38371 | 2104495.7919400004 | 37.7586964899576 | -122.433750783787 | (37.7586964899576, -122.433750783787) | |
| 136377 | 136377 | 33273 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1121 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 7 | Permit Number 37442 | 6009382.25638 | 2117052.9627099996 | 37.7935530901583 | -122.41148738125901 | (37.7935530901583, -122.411487381259) | |
| 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) | |||
| 37645 | 37645 | 40655 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 7 | Permit Number 47919 | 6004683.61058 | 2093747.9444400002 | 37.729298378011705 | -122.42608524416401 | (37.7292983780117, -122.426085244164) | |
| 28886 | 28886 | 40657 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Congdon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | 7 | Permit Number 47919 | 6004684.27364 | 2093706.73058 | 37.729185251382 | -122.4260800191 | (37.729185251382, -122.4260800191) | |
| 37085 | 37085 | 43877 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 144 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2000 12:00:00 AM | 7 | Permit Number 43492 | 6003098.49585 | 2092711.51751 | 37.726362865838 | -122.431491164302 | (37.726362865838, -122.431491164302) | ||
| 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) | |
| 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) | ||
| 153971 | 153971 | 50505 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 671 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 7 | Permit Number 47140 | 6001286.63286 | 2089768.4439299998 | 37.7181789920349 | -122.43754400816002 | (37.7181789920349, -122.43754400816) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 148458 | 148458 | 65791 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 523 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1990 12:00:00 AM | 7 | Permit Number 28759 | 6001804.02439 | 2090571.26735 | 37.7204127686105 | -122.43581301917801 | (37.7204127686105, -122.435813019178) | ||
| 71708 | 71708 | 66515 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1173 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1991 12:00:00 AM | 7 | Permit Number 29681 | 6007962.75323 | 2118537.74133 | 37.7975502016423 | -122.41650421331 | (37.7975502016423, -122.41650421331) | ||
| 68955 | 68955 | 67626 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1334 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1993 12:00:00 AM | 7 | Permit Number 31212 | 6007155.75192 | 2118470.9352 | 37.7973213520513 | -122.41929191739901 | (37.7973213520513, -122.419291917399) | |
| 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) | |
| 174561 | 174561 | 68280 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 621 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32088 | 6008949.32855 | 2093160.8279900001 | 37.7279264532255 | -122.411296760036 | (37.7279264532255, -122.411296760036) | |
| 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) | |
| 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) | |
| 147925 | 147925 | 69417 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 149 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 7 | Permit Number 33522 | 6001453.459840001 | 2087297.44526 | 37.7114036625088 | -122.436790570551 | (37.7114036625088, -122.436790570551) | |
| 34283 | 34283 | 71395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1553 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 7 | 6015450.35777 | 2096531.9462 | 37.7375453329415 | -122.389057616714 | (37.7375453329415, -122.389057616714) | ||
| 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) | ||
| 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) | ||
| 45575 | 45575 | 78381 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 631 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003379.385319999 | 2089522.9059 | 37.7176235608499 | -122.43029275202299 | (37.7176235608499, -122.430292752023) | ||
| 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) | ||
| 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) | |
| 63221 | 63221 | 84826 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 855 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2010 12:00:00 AM | 7 | Permit Number 53480 | 6010945.70103 | 2090738.7413400002 | 37.7213876696754 | -122.404224813428 | (37.7213876696754, -122.404224813428) | ||
| 105585 | 105585 | 113819 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4101x 25TH ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 7 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
| 16684 | 16684 | 121586 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 855 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6012479.74347 | 2103984.1173799997 | 37.7578422788274 | -122.399851639655 | (37.7578422788274, -122.399851639655) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 35149 | 35149 | 135976 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2319 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003577.71337 | 2116564.31874 | 37.7918841103205 | -122.43153665472 | (37.7918841103205, -122.43153665472) | |||
| 180553 | 180553 | 136007 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 851 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008899.0755 | 2119356.3922200003 | 37.7998506260751 | -122.413322200567 | (37.7998506260751, -122.413322200567) | |||
| 2028 | 2028 | 137540 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1510 Steiner St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002670.5536 | 2113409.7602 | 37.7831710382055 | -122.434449780345 | (37.7831710382055, -122.434449780345) | |||
| 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) | |||
| 186156 | 186156 | 178984 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 33 Leo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001422.09119 | 2091414.6513 | 37.722706807859396 | -122.43719359092199 | (37.7227068078594, -122.437193590922) | |||
| 173955 | 173955 | 179013 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6001863.70015 | 2090153.04553 | 37.719267814726 | -122.435576835623 | (37.719267814726, -122.435576835623) | |||
| 161431 | 161431 | 179036 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 551 Sawyer St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007618.72078 | 2086894.99872 | 37.7106470934606 | -122.415453306029 | (37.7106470934606, -122.415453306029) | |||
| 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) | |||
| 30982 | 30982 | 179077 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 26 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004472.54344 | 2093374.1401799999 | 37.7282600630306 | -122.426788312529 | (37.7282600630306, -122.426788312529) | |||
| 118166 | 118166 | 179079 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 72 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004347.61094 | 2093176.52987 | 37.7277104045865 | -122.42720613936899 | (37.7277104045865, -122.427206139369) | |||
| 69928 | 69928 | 179111 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1362 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007634.67362 | 2091466.7715 | 37.723201116628395 | -122.415721669126 | (37.7232011166284, -122.415721669126) | |||
| 177590 | 177590 | 179114 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Yale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006904.09352 | 2093533.23761 | 37.7288340895016 | -122.418393600792 | (37.7288340895016, -122.418393600792) | |||
| 73040 | 73040 | 179149 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 387 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003556.4774 | 2091326.8138400002 | 37.7225867240926 | -122.429809220726 | (37.7225867240926, -122.429809220726) | |||
| 169877 | 169877 | 179150 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 332 Edinburgh St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6003465.83302 | 2091792.2726 | 37.7238596371003 | -122.43015574750099 | (37.7238596371003, -122.430155747501) | |||
| 172050 | 172050 | 179155 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1219 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001609.50582 | 2087555.82392 | 37.7121219807101 | -122.436269715579 | (37.7121219807101, -122.436269715579) | |||
| 177043 | 177043 | 196434 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2400 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010626.05667 | 2105554.79226 | 37.7620514837216 | -122.406373163394 | (37.7620514837216, -122.406373163394) | |||
| 172812 | 172812 | 196484 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 South Park | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6014481.0981 | 2112803.55306 | 37.7821698664821 | -122.393547301273 | (37.7821698664821, -122.393547301273) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");