Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qSiteInfo, PlantType, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42481 | 42481 | 71284 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 5 | 5998802.9816 | 2111041.8064 | 37.7764489521659 | -122.447659448254 | (37.7764489521659, -122.447659448254) | ||
| 98840 | 98840 | 42078 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
| 121829 | 121829 | 42077 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42388 | 6009309.20723614 | 2099453.41599437 | 37.7452247183965 | -122.410496799342 | (37.7452247183965, -122.410496799342) | ||
| 38648 | 38648 | 68912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.870730001 | 2118345.67653 | 37.797052862167604 | -122.41464241973 | (37.7970528621676, -122.41464241973) | |
| 105011 | 105011 | 46168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Hillway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44497 | 5996113.80902962 | 2106861.13745227 | 37.7648158648531 | -122.45665958836399 | (37.7648158648531, -122.456659588364) | ||
| 123229 | 123229 | 42079 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42389 | 6009265.41363365 | 2099503.07167939 | 37.7453586067376 | -122.41065173677299 | (37.7453586067376, -122.410651736773) | ||
| 165156 | 165156 | 69496 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 6 | Permit Number 33619 | 6000930.02783 | 2092989.43743 | 37.7270028279165 | -122.439007348127 | (37.7270028279165, -122.439007348127) | |
| 82956 | 82956 | 47713 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 85199 | 85199 | 47712 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 85911 | 85911 | 47714 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Bemis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45508 | 6003740.19756864 | 2096888.33096849 | 37.7378678033179 | -122.429570583661 | (37.7378678033179, -122.429570583661) | ||
| 98555 | 98555 | 42815 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42760 | 6001684.72316119 | 2105247.9392865 | 37.760704701255 | -122.437275750105 | (37.760704701255, -122.437275750105) | ||
| 64593 | 64593 | 60783 | Permitted Site 1 | Syzygium paniculatum :: Brush Cherry 198 | 100 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 5 | Permit Number 20453 | 5998776.2822 | 2112393.1221 | 37.7801577900357 | -122.447849117584 | (37.7801577900357, -122.447849117584) | |
| 104017 | 104017 | 102628 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2013 12:00:00 AM | 3x3 | Permit Number 769972 | 6013417.4 | 2111578.2 | 37.778746166691 | -122.397141295625 | (37.778746166691, -122.397141295625) | |
| 10801 | 10801 | 83237 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769756 | 6004043.10746 | 2093201.4009 | 37.727761469894794 | -122.42826058457099 | (37.7277614698948, -122.428260584571) |
| 105631 | 105631 | 34419 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38167 | 6003358.09011166 | 2096226.49076231 | 37.7360288984966 | -122.43084449611601 | (37.7360288984966, -122.430844496116) | ||
| 109631 | 109631 | 94680 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53816 | 6003489.0 | 2095230.0 | 37.733300177534204 | -122.430320814613 | (37.7333001775342, -122.430320814613) | |
| 140743 | 140743 | 66752 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30004 | 5999885.94793997 | 2106981.28514866 | 37.76536161907 | -122.443621406981 | (37.76536161907, -122.443621406981) | ||
| 62212 | 62212 | 78428 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1000 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 10 | 6003760.55793 | 2089507.02649 | 37.7176015427445 | -122.42897407970699 | (37.7176015427445, -122.428974079707) | ||
| 154800 | 154800 | 79787 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1000 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 10 | 6003769.36441 | 2089501.7721900002 | 37.717587614063895 | -122.428943265313 | (37.7175876140639, -122.428943265313) | ||
| 108763 | 108763 | 41855 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 121275 | 121275 | 41858 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 122844 | 122844 | 41857 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 143410 | 143410 | 41856 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1001 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42242 | 5991806.94075666 | 2105198.64427989 | 37.7600028757378 | -122.471434646474 | (37.7600028757378, -122.471434646474) | ||
| 77358 | 77358 | 47252 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767654 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.39663499597201 | (37.718267407089, -122.396634995972) | |
| 158154 | 158154 | 79061 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1006 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6012156.574130001 | 2103666.55961 | 37.756952313327396 | -122.40094698961599 | (37.7569523133274, -122.400946989616) | ||
| 81601 | 81601 | 65210 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1008 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27196 | 6003122.02248491 | 2102364.94475265 | 37.7528702875206 | -122.432098897252 | (37.7528702875206, -122.432098897252) | ||
| 115710 | 115710 | 42429 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 142249 | 142249 | 42109 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 79959 | 79959 | 42068 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100X Ripley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42381 | 6015269.0 | 2115673.0 | 37.790092461076604 | -122.39102211089701 | (37.7900924610766, -122.391022110897) |
| 125439 | 125439 | 38880 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
| 83133 | 83133 | 32376 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
| 90719 | 90719 | 32373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
| 94155 | 94155 | 32375 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
| 111748 | 111748 | 32374 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
| 96244 | 96244 | 40667 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Maynard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767516 | 6004070.62612566 | 2093782.39936272 | 37.72935831911229 | -122.428206841061 | (37.7293583191123, -122.428206841061) | |
| 127500 | 127500 | 40666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Maynard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767516 | 6004070.62612566 | 2093782.39936272 | 37.72935831911229 | -122.428206841061 | (37.7293583191123, -122.428206841061) | |
| 119263 | 119263 | 31008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 127132 | 127132 | 31009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 92552 | 92552 | 36557 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39427 | 6008880.2941613 | 2098058.52124465 | 37.7413705893714 | -122.411881362374 | (37.7413705893714, -122.411881362374) | ||
| 120325 | 120325 | 89313 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767419 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | |
| 75775 | 75775 | 35480 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1011 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | 4 | Permit Number 44832 | 6007756.215530001 | 2093380.89962 | 37.7284637342957 | -122.415436968047 | (37.7284637342957, -122.415436968047) | |
| 93154 | 93154 | 49881 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1018 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2003 12:00:00 AM | Permit Number 46647 | 5998856.6109844 | 2106476.48364513 | 37.763916800747204 | -122.447145297349 | (37.7639168007472, -122.447145297349) | ||
| 94204 | 94204 | 34536 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 102 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38245 | 6009539.66453921 | 2097997.54688011 | 37.7412401371814 | -122.409597177582 | (37.7412401371814, -122.409597177582) | ||
| 94480 | 94480 | 68763 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 102 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32686 | 6003608.24557851 | 2105105.19353469 | 37.760421914692 | -122.430612966732 | (37.760421914692, -122.430612966732) | ||
| 145686 | 145686 | 35966 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 102 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39124 | 6005564.29083619 | 2096119.54100756 | 37.7358599920196 | -122.42320916287301 | (37.7358599920196, -122.423209162873) | ||
| 87307 | 87307 | 37016 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1024 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39629 | 6008593.31384349 | 2102571.16222478 | 37.7537451924393 | -122.413192669543 | (37.7537451924393, -122.413192669543) | ||
| 141471 | 141471 | 39191 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1025 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40844 | 6008645.24325538 | 2102573.87076335 | 37.7537555446899 | -122.413013276733 | (37.7537555446899, -122.413013276733) | ||
| 87465 | 87465 | 51286 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1026 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767263 | 6004381.40328388 | 2102911.72608688 | 37.7544429415209 | -122.42778267914301 | (37.7544429415209, -122.427782679143) | |
| 92764 | 92764 | 43648 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1030 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43295 | 5998862.78386083 | 2106432.26100273 | 37.7637957291639 | -122.447120764539 | (37.7637957291639, -122.447120764539) | ||
| 115824 | 115824 | 65254 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1031 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | 4x6 | Permit Number 28053. Expanded basin to 4x6 | 6009460.81528619 | 2103170.09802024 | 37.755438399754894 | -122.41023492456199 | (37.7554383997549, -122.410234924562) | |
| 167611 | 167611 | 95528 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767319 | 5989620.9197 | 2099732.2391 | 37.7448668732681 | -122.478595193308 | (37.7448668732681, -122.478595193308) |
| 127295 | 127295 | 60577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1036 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20361 | 6009410.76277257 | 2103133.61421034 | 37.7553354176475 | -122.41040544615801 | (37.7553354176475, -122.410405446158) | ||
| 79621 | 79621 | 43653 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 98301 | 98301 | 43650 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 112360 | 112360 | 43651 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 119377 | 119377 | 43649 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 164074 | 164074 | 68694 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 104 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 7 | Permit Number 32606 | 5991821.21978 | 2114667.98437 | 37.7860039484018 | -122.47207548155399 | (37.7860039484018, -122.472075481554) | |
| 109919 | 109919 | 37179 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 104 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39752 | 6006192.48658967 | 2099515.53626406 | 37.7452200653601 | -122.42127831881001 | (37.7452200653601, -122.42127831881) | ||
| 119044 | 119044 | 35155 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1044 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38686 | 6001561.46281092 | 2109428.97187027 | 37.7721777782295 | -122.438001544264 | (37.7721777782295, -122.438001544264) | ||
| 20479 | 20479 | 73501 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.74920537061129 | -122.436016109621 | (37.7492053706113, -122.436016109621) | |
| 97124 | 97124 | 71983 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.74920537061129 | -122.436016109621 | (37.7492053706113, -122.436016109621) | |
| 143111 | 143111 | 70987 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.74920537061129 | -122.436016109621 | (37.7492053706113, -122.436016109621) | |
| 156030 | 156030 | 41773 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1045 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 5 | Permit Number 42187 | 6009460.67023 | 2116947.19217 | 37.7932670679698 | -122.411208586919 | (37.7932670679698, -122.411208586919) | |
| 182262 | 182262 | 41772 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1045 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 7 | Permit Number 42187 | 6009458.388040001 | 2116963.23117 | 37.793310979166 | -122.411217616996 | (37.793310979166, -122.411217616996) | |
| 83546 | 83546 | 48870 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 105 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46813 | 5992505.4658098 | 2098397.03654372 | 37.7413678003574 | -122.468523930768 | (37.7413678003574, -122.468523930768) | ||
| 91235 | 91235 | 47701 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45497 | 6003509.82655426 | 2097791.42406059 | 37.7403344433628 | -122.430431505695 | (37.7403344433628, -122.430431505695) | ||
| 129147 | 129147 | 47700 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45497 | 6003509.82655426 | 2097791.42406059 | 37.7403344433628 | -122.430431505695 | (37.7403344433628, -122.430431505695) | ||
| 142993 | 142993 | 62195 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 105 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1985 12:00:00 AM | Permit Number 22314 | 6000493.57908868 | 2092148.88322612 | 37.7246700159736 | -122.440455881068 | (37.7246700159736, -122.440455881068) | ||
| 187669 | 187669 | 31093 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34826 | 6007741.23443 | 2107311.13584 | 37.7667121941381 | -122.416475089665 | (37.7667121941381, -122.416475089665) | |
| 73 | 73 | 65479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1051 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 10 | 3x3 | Permit Number 28361 | 6008468.497880001 | 2115537.43749 | 37.789340533487795 | -122.41454177659901 | (37.7893405334878, -122.414541776599) |
| 71185 | 71185 | 64744 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1058 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1988 12:00:00 AM | Permit Number 25706 | 6001496.66932698 | 2109419.88262313 | 37.7721491365124 | -122.43822501871 | (37.7721491365124, -122.43822501871) | ||
| 102086 | 102086 | 62849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23217 | 6008647.40750977 | 2098052.96381421 | 37.7413422616597 | -122.41268621320101 | (37.7413422616597, -122.412686213201) | ||
| 115997 | 115997 | 36347 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39309 | 5995651.79090977 | 2093374.88380892 | 37.7277594354695 | -122.457281878498 | (37.7277594354695, -122.457281878498) | ||
| 146302 | 146302 | 32385 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 106 Park St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | ||
| 122373 | 122373 | 63019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1986 12:00:00 AM | Permit Number 23434 | 6007356.32584056 | 2097719.32736654 | 37.740353622343 | -122.417126697503 | (37.740353622343, -122.417126697503) | ||
| 124372 | 124372 | 37006 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1065 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39620 | 6009210.89939839 | 2102965.35956072 | 37.754862222093294 | -122.411084752447 | (37.7548622220933, -122.411084752447) | ||
| 13060 | 13060 | 109069 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1065 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772763 | 6002105.570119999 | 2087176.80573 | 37.7111094529054 | -122.434528092094 | (37.7111094529054, -122.434528092094) |
| 128146 | 128146 | 48946 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1066 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46133 | 6008605.50841318 | 2102337.36203543 | 37.7531039144279 | -122.41313396681002 | (37.7531039144279, -122.41313396681) | ||
| 86071 | 86071 | 36348 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39310 | 5995599.90527543 | 2093378.33068424 | 37.7277659195994 | -122.457461496194 | (37.7277659195994, -122.457461496194) | ||
| 129117 | 129117 | 36349 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 107 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39310 | 5995599.90527543 | 2093378.33068424 | 37.7277659195994 | -122.457461496194 | (37.7277659195994, -122.457461496194) | ||
| 133883 | 133883 | 54535 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | Permit Number 10330 | 6009992.40019 | 2095186.16028 | 37.7335460325239 | -122.407833574281 | (37.7335460325239, -122.407833574281) | |
| 98201 | 98201 | 45126 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2001 12:00:00 AM | Permit Number 43983 | 6000317.21225262 | 2109259.39896311 | 37.7716413366819 | -122.44229332427099 | (37.7716413366819, -122.442293324271) | ||
| 78060 | 78060 | 31092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 109007 | 109007 | 31091 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 123857 | 123857 | 31090 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 99007 | 99007 | 37007 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1071 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39621 | 6009212.75104301 | 2102931.76923387 | 37.7547700944461 | -122.411075976411 | (37.7547700944461, -122.411075976411) | ||
| 72980 | 72980 | 69395 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1075 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33499 | 6002066.46838 | 2087158.9447 | 37.711058190666705 | -122.43466196070801 | (37.7110581906667, -122.434661960708) | |
| 94757 | 94757 | 65242 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1077 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28036 | 6009214.60268532 | 2102898.17894887 | 37.7546779669117 | -122.411067200407 | (37.7546779669117, -122.411067200407) | ||
| 72023 | 72023 | 40646 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 108 Congdon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41644 | 6004664.1042599995 | 2094195.33475 | 37.7305257097718 | -122.426184517611 | (37.7305257097718, -122.426184517611) | |
| 128860 | 128860 | 39140 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1084 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40818 | 6007412.89120014 | 2100999.62033196 | 37.749363754724996 | -122.417163498301 | (37.749363754725, -122.417163498301) | ||
| 123557 | 123557 | 69212 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1089 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33263 | 6008066.8179196995 | 2101598.29376591 | 37.7510443436687 | -122.414944565 | (37.7510443436687, -122.414944565) | ||
| 48367 | 48367 | 49748 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 109@ BRUSSELS Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46547 | 6011907.8290099995 | 2088398.1624200002 | 37.715014627609 | -122.400734636294 | (37.715014627609, -122.400734636294) | |
| 49635 | 49635 | 35149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.771962024845294 | -122.427256837171 | (37.7719620248453, -122.427256837171) | ||
| 89676 | 89676 | 49125 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 11 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46256 | 5995794.69069605 | 2092577.70083633 | 37.725578768403295 | -122.456730244977 | (37.7255787684033, -122.456730244977) | ||
| 92654 | 92654 | 50123 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 11 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46846 | 5993295.32163742 | 2099072.65431328 | 37.7432684700147 | -122.465841985308 | (37.7432684700147, -122.465841985308) | ||
| 101473 | 101473 | 67117 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30537 | 5998254.46044174 | 2105394.41401324 | 37.7609112863716 | -122.449149986975 | (37.7609112863716, -122.449149986975) | ||
| 124905 | 124905 | 33472 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 110 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37570 | 6006648.0674886 | 2099041.17525906 | 37.7439432510879 | -122.419669343585 | (37.7439432510879, -122.419669343585) | ||
| 91136 | 91136 | 45127 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 110 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2001 12:00:00 AM | Permit Number 43984 | 6000366.86976442 | 2109279.71080278 | 37.7716999379516 | -122.442123014739 | (37.7716999379516, -122.442123014739) | ||
| 65798 | 65798 | 49135 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 110 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46262 | 5996344.49436596 | 2094285.70346417 | 37.730300088752706 | -122.45495298879601 | (37.7303000887527, -122.454952988796) | ||
| 85799 | 85799 | 49136 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 110 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46262 | 5996344.49436596 | 2094285.70346417 | 37.730300088752706 | -122.45495298879601 | (37.7303000887527, -122.454952988796) |
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");