Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9777 | 9777 | 88104 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1247 46th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 4x10 | Permit Number 51108 | 5981754.7 | 2106590.8 | 37.763238693975296 | -122.50630313344999 | (37.7632386939753, -122.50630313345) | |||
| 18879 | 18879 | 94134 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Nebraska St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53498 | 6009291.0 | 2097948.0 | 37.7410901551317 | -122.41045347697501 | (37.7410901551317, -122.410453476975) | |||
| 21236 | 21236 | 92078 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1151 Sutter St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2009 12:00:00 AM | 3x3 | Permit Number 52192 | 6007083.0 | 2115004.0 | 37.7877979108835 | -122.41929759225799 | (37.7877979108835, -122.419297592258) | |||
| 40011 | 40011 | 88560 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2901 Pierce St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501.0 | 2118350.0 | 37.7966692015857 | -122.43885009322901 | (37.7966692015857, -122.438850093229) | |||
| 41693 | 41693 | 91420 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 770 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52101 | 5990400.3408699995 | 2110139.21584 | 37.7734868781795 | -122.47666030039301 | (37.7734868781795, -122.476660300393) | ||
| 50040 | 50040 | 87823 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 451 47th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 4 | 2x3 | Permit Number 50716 | 5981265.5826900005 | 2112596.97795 | 37.7797010943021 | -122.508440678428 | (37.7797010943021, -122.508440678428) | ||
| 54060 | 54060 | 91105 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5100 Fulton St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2009 12:00:00 AM | 3 | Permit Number 51994 | 5987471.43657 | 2109862.78332 | 37.7725575525108 | -122.48677137341002 | (37.7725575525108, -122.48677137341) | |||
| 60427 | 60427 | 88580 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 474 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51522 | 5989397.97956 | 2112106.21746 | 37.778829528805794 | -122.480271570948 | (37.7788295288058, -122.480271570948) | ||
| 66036 | 66036 | 88055 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 52 Robblee Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3x3 | Permit Number 51065 | 6012498.0 | 2095923.9 | 37.735711666118604 | -122.39922270968201 | (37.7357116661186, -122.399222709682) | |||
| 67866 | 67866 | 92826 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 755 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2009 12:00:00 AM | 5 | 3x3 | Permit Number 53040 | 5991610.35704 | 2110282.0512900003 | 37.7739491753353 | -122.47248513397899 | (37.7739491753353, -122.472485133979) | ||
| 69774 | 69774 | 91104 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 5100 Fulton St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/08/2009 12:00:00 AM | 3 | Permit Number 51994 | 5987486.90451 | 2109863.03961 | 37.772559157968395 | -122.48671788773399 | (37.7725591579684, -122.486717887734) | |||
| 78144 | 78144 | 87131 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 De Montfort Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 3x3 | Permit Number 50083 | 5995245.2 | 2091924.0 | 37.7237522965749 | -122.45858247555599 | (37.7237522965749, -122.458582475556) | |||
| 79204 | 79204 | 95400 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 227 Valley St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767274 | 6004277.7 | 2099178.3 | 37.744185954454295 | -122.42787530142701 | (37.7441859544543, -122.427875301427) | ||
| 79328 | 79328 | 88522 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 10 Valdez Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417.0 | 2093827.6 | 37.7290464055545 | -122.45466924520201 | (37.7290464055545, -122.454669245202) | |||
| 79469 | 79469 | 88223 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2442 Fulton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51219 | 5996404.0 | 2110432.0 | 37.7746371856421 | -122.455914062335 | (37.7746371856421, -122.455914062335) | |||
| 79787 | 79787 | 96460 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 80163 | 80163 | 88235 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 329 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51224 | 6000219.0 | 2110006.0 | 37.773685716624705 | -122.44268666247 | (37.7736857166247, -122.44268666247) | |||
| 81165 | 81165 | 97014 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 81443 | 81443 | 100355 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 591 Waller St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/30/2014 12:00:00 AM | 3 | 27x6 | Permit Number 769031 | 6002899.6 | 2108847.2 | 37.770656382716396 | -122.43333123962 | (37.7706563827164, -122.43333123962) | ||
| 81641 | 81641 | 89366 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340 Benton Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2008 12:00:00 AM | 3x3 | Permit Number 51946 | 6006673.6 | 2095420.1 | 37.7340020224619 | -122.419324232824 | (37.7340020224619, -122.419324232824) | |||
| 82487 | 82487 | 104995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2220 Castro St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2013 12:00:00 AM | 3X3 | Permit Number 771144 | 6002644.3 | 2099031.5 | 37.7436903366208 | -122.433512747881 | (37.7436903366208, -122.433512747881) | |||
| 82574 | 82574 | 107467 | Permitted Site 1 | Prunus sargentii 'Columnaris' :: Sargent Cherry Tree 'Columnaris' 473 | 1643 35th Ave | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/11/2014 12:00:00 AM | 3 | Permit Number 773410 | 5985268.14341 | 2104019.02784 | 37.7563835411873 | -122.493961929435 | (37.7563835411873, -122.493961929435) | |||
| 83825 | 83825 | 96459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 84888 | 84888 | 88277 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Aptos Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062.0 | 2093861.6 | 37.7289467548913 | -122.46627011422899 | (37.7289467548913, -122.466270114229) | |||
| 85013 | 85013 | 97015 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 85137 | 85137 | 88093 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1726 39th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51097 | 5984135.0 | 2103400.2 | 37.7546180463975 | -122.497834981734 | (37.7546180463975, -122.497834981734) | |||
| 85190 | 85190 | 94875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 44 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53944 | 6011618.0 | 2095077.0 | 37.7333371742049 | -122.40220570440799 | (37.7333371742049, -122.402205704408) | ||
| 86418 | 86418 | 96362 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1432 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2011 12:00:00 AM | Permit Number 767816 | 5989066.4 | 2105558.5 | 37.760832022681896 | -122.480939093689 | (37.7608320226819, -122.480939093689) | ||||
| 86739 | 86739 | 86757 | Permitted Site 1 | Prunus spp :: Cherry 84 | 500 Brotherhood Way | unknown : Yard 19 | Tree 1 | Private 1 | Permit Number 49739 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | |||||
| 87143 | 87143 | 94697 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2443 Clement St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53831 | 5987960.0 | 2113267.0 | 37.7819330460656 | -122.485331246452 | (37.7819330460656, -122.485331246452) | ||
| 90531 | 90531 | 96463 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 90782 | 90782 | 87792 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 88 Neptune St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2008 12:00:00 AM | 3x3 | Permit Number 50533 | 6013015.9 | 2093934.5 | 37.7302780341819 | -122.397292652785 | (37.7302780341819, -122.397292652785) | |||
| 91694 | 91694 | 88359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1443 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51337 | 5992382.4 | 2105622.1 | 37.7611988469011 | -122.46947525322099 | (37.7611988469011, -122.469475253221) | |||
| 92324 | 92324 | 96987 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 93473 | 93473 | 88253 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1025 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131.0 | 2106547.0 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | |||
| 93623 | 93623 | 94948 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 94217 | 94217 | 94954 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1725 Monterey Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53987 | 5992718.5 | 2095334.0 | 37.7329697745731 | -122.46756464142901 | (37.7329697745731, -122.467564641429) | ||
| 94809 | 94809 | 89293 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1353 26th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2008 12:00:00 AM | 3x3 | Permit Number 51899 | 5987992.1 | 2106076.8 | 37.7621926272889 | -122.484692595652 | (37.7621926272889, -122.484692595652) | |||
| 94845 | 94845 | 97016 | Property Tree 7 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 95257 | 95257 | 93959 | Permitted Site 1 | Prunus spp :: Cherry 84 | 419 Elizabeth St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 53399 | 6003681.0 | 2102149.0 | 37.752309029626495 | -122.430150445418 | (37.7523090296265, -122.430150445418) | ||||
| 95873 | 95873 | 88137 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 173 Marietta Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51165 | 5998746.0 | 2097919.0 | 37.740413730770705 | -122.44691203771002 | (37.7404137307707, -122.44691203771) | |||
| 97621 | 97621 | 98306 | Section 143 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Terrace Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993776.0 | 2096639.0 | 37.7366139805049 | -122.46400331489299 | (37.7366139805049, -122.464003314893) | ||||||
| 98303 | 98303 | 96462 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 99390 | 99390 | 87844 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 536 28th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50751 | 5987246.0 | 2112270.7 | 37.7791558680057 | -122.487728106826 | (37.7791558680057, -122.487728106826) | |||
| 101288 | 101288 | 88731 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 248 Scott St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51665 | 6002314.0 | 2109330.0 | 37.771948792814 | -122.435391376972 | (37.771948792814, -122.435391376972) | |||
| 101711 | 101711 | 91489 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 430 Hamilton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2009 12:00:00 AM | 3x3 | Permit Number 52114 | 6009410.2 | 2092292.9 | 37.725569143547204 | -122.40964227476499 | (37.7255691435472, -122.409642274765) | |||
| 102251 | 102251 | 88260 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 123 Corbett Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51245 | 6000668.3 | 2105609.4 | 37.7616393503242 | -122.44081702139401 | (37.7616393503242, -122.440817021394) | |||
| 102787 | 102787 | 94874 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 40 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53943 | 6011600.0 | 2095102.0 | 37.7334048142135 | -122.402269692882 | (37.7334048142135, -122.402269692882) | ||
| 103165 | 103165 | 108498 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 762 10th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773796 | 5992905.3087 | 2110276.51424 | 37.774008838888996 | -122.468005315635 | (37.774008838889, -122.468005315635) | |
| 103824 | 103824 | 94947 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 106314 | 106314 | 85007 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 850 Bryant St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49366 | 6010976.0 | 2110190.0 | 37.7747982776561 | -122.40548930108 | (37.7747982776561, -122.40548930108) | |||||
| 108284 | 108284 | 86728 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 980 Huron Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2007 12:00:00 AM | Permit Number 49704 | 5996769.2 | 2086717.1 | 37.7095428329763 | -122.452938628006 | (37.7095428329763, -122.452938628006) | ||||
| 108918 | 108918 | 91235 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 470 Ramsell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52048 | 5993008.0 | 2090300.0 | 37.719164355766 | -122.46619807183399 | (37.719164355766, -122.466198071834) | |||
| 110626 | 110626 | 96461 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 110648 | 110648 | 94878 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 56 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53946 | 6011673.0 | 2095004.0 | 37.73313980136 | -122.40201042294399 | (37.73313980136, -122.402010422944) | ||
| 112964 | 112964 | 89318 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 Frederick St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2008 12:00:00 AM | 3x3 | Permit Number 51911 | 5997633.0 | 2107488.0 | 37.766624178434 | -122.451450341927 | (37.766624178434, -122.451450341927) | |||
| 113411 | 113411 | 114039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1328 TREAT WAY | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6008689.0 | 2100921.0 | 37.7492195885474 | -122.412745111821 | (37.7492195885474, -122.412745111821) | ||||
| 113465 | 113465 | 89325 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Woodland Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51916 | 5997172.6 | 2105981.7 | 37.762461887858294 | -122.452934038904 | (37.7624618878583, -122.452934038904) | ||||
| 113743 | 113743 | 88226 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2108 Hayes St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51222 | 5997802.0 | 2109918.0 | 37.7733060118428 | -122.451041052194 | (37.7733060118428, -122.451041052194) | |||
| 114698 | 114698 | 94946 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 114798 | 114798 | 105147 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Mirabel Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 12/26/2013 12:00:00 AM | 3X3 | Permit Number 771012 | 6007663.7 | 2099931.8 | 37.7464458666696 | -122.41622057503099 | (37.7464458666696, -122.416220575031) | |||
| 115262 | 115262 | 94958 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 201 San Benito Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53990 | 5992929.1 | 2095285.9 | 37.7328498609093 | -122.46683305318001 | (37.7328498609093, -122.46683305318) | ||
| 117193 | 117193 | 88594 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 298 Divisadero St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51540 | 6001881.0 | 2109400.2 | 37.7721169442044 | -122.436894179858 | (37.7721169442044, -122.436894179858) | |||
| 117329 | 117329 | 89288 | Permitted Site 1 | Prunus x 'Amanogawa' :: Flowering Cherry 57 | 8 Costa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/2008 12:00:00 AM | 3x3 | Permit Number 51896 | 6010584.9 | 2099259.3 | 37.7447631529327 | -122.40607197538 | (37.7447631529327, -122.40607197538) | |||
| 117893 | 117893 | 106553 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 213 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2014 12:00:00 AM | 2.5x4 | Permit Number 771194 | 5998005.6 | 2096224.8 | 37.7357195377121 | -122.44935000292601 | (37.7357195377121, -122.449350002926) | |||
| 119175 | 119175 | 108830 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | FUF 1 | 3x3 | 6003763.1265 | 2093992.4287599998 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | ||||
| 120326 | 120326 | 89001 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 212 Maynard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2008 12:00:00 AM | 3x3 | Permit Number 51753 | 6004786.0 | 2093771.0 | 37.7293674698939 | -122.425732914897 | (37.7293674698939, -122.425732914897) | |||
| 120711 | 120711 | 108458 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 756 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773789 | 5992285.05339 | 2110293.92869 | 37.7740208158449 | -122.47015213289801 | (37.7740208158449, -122.470152132898) | |||
| 120728 | 120728 | 88189 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 123 Dore St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51194 | 6009069.0 | 2109644.0 | 37.7731922763614 | -122.41204743866301 | (37.7731922763614, -122.412047438663) | |||
| 122629 | 122629 | 88131 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 525 Jersey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51155 | 6001754.0 | 2101449.0 | 37.750277666491606 | -122.436764203777 | (37.7502776664916, -122.436764203777) | |||
| 122874 | 122874 | 105008 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1957 - 1959 15TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2014 12:00:00 AM | 11 | 3x3 | Permit Number 771758 | 6004438.4 | 2107144.3 | 37.766067808554205 | -122.42788714698798 | (37.7660678085542, -122.427887146988) | ||
| 123530 | 123530 | 88091 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1619 39th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51095 | 5984024.3 | 2104125.3 | 37.756602478656 | -122.498271356488 | (37.756602478656, -122.498271356488) | |||
| 123599 | 123599 | 88648 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 74 Carmelita St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51628 | 6002619.0 | 2108775.0 | 37.7704422164895 | -122.434296675208 | (37.7704422164895, -122.434296675208) | |||
| 123805 | 123805 | 108831 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 774658 | 6003763.1265 | 2093992.4287599998 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | |||
| 123951 | 123951 | 88225 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2084 Hayes St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51221 | 5997896.9 | 2109991.0 | 37.7735118836843 | -122.450718045928 | (37.7735118836843, -122.450718045928) | |||
| 124322 | 124322 | 88528 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 771 14th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51478 | 6003493.0 | 2107743.0 | 37.7676581652647 | -122.431199833454 | (37.7676581652647, -122.431199833454) | |||
| 124580 | 124580 | 88278 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 103 Aptos Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51270 | 5993062.0 | 2093861.6 | 37.7289467548913 | -122.46627011422899 | (37.7289467548913, -122.466270114229) | |||
| 124984 | 124984 | 88576 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 565 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51516 | 5990288.0 | 2111527.4 | 37.7772919335186 | -122.477150362969 | (37.7772919335186, -122.477150362969) | |||
| 126268 | 126268 | 94585 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2725 Greenwich St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2010 12:00:00 AM | 3x3 | Permit Number 53761 | 5999865.0 | 2118793.0 | 37.7977923490456 | -122.44454285799999 | (37.7977923490456, -122.444542858) | |||
| 128179 | 128179 | 92032 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4232 21st St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2009 12:00:00 AM | 3x3 | Permit Number 52175 | 6001386.1 | 2103403.9 | 37.75562443672 | -122.43817644846001 | (37.75562443672, -122.43817644846) | |||
| 129306 | 129306 | 88236 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1593 McAllister St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51225 | 6001491.0 | 2111451.0 | 37.7777257527509 | -122.438390172535 | (37.7777257527509, -122.438390172535) | |||
| 133299 | 133299 | 88377 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 458 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51355 | 5991270.95609 | 2112280.85053 | 37.7794176810179 | -122.47380501423599 | (37.7794176810179, -122.473805014236) | ||
| 138668 | 138668 | 89365 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 380 Benton Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2008 12:00:00 AM | 3x3 | Permit Number 51945 | 6006769.0 | 2095411.9 | 37.733984879603 | -122.418993823503 | (37.733984879603, -122.418993823503) | |||
| 140557 | 140557 | 109055 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 320 Hanover St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772693 | 5999569.6 | 2086544.4 | 37.70922872292179 | -122.443247602414 | (37.7092287229218, -122.443247602414) | |
| 141937 | 141937 | 92000 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1393 Bacon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 3x3 | Permit Number 52152 | 6007474.0 | 2091791.0 | 37.724082345197104 | -122.416300041455 | (37.7240823451971, -122.416300041455) | |||
| 143271 | 143271 | 88559 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2901 Pierce St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501.0 | 2118350.0 | 37.7966692015857 | -122.43885009322901 | (37.7966692015857, -122.438850093229) | |||
| 143629 | 143629 | 96998 | Significant Tree 6 | Prunus spp :: Cherry 84 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 143890 | 143890 | 88505 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 140 Colon Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51443 | 5996179.5 | 2093971.6 | 37.7294281696535 | -122.455500699897 | (37.7294281696535, -122.455500699897) | |||
| 143979 | 143979 | 106551 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 203 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5X4 | Permit Number 58742 | 5998066.5 | 2096226.6 | 37.7357279634759 | -122.449139578572 | (37.7357279634759, -122.449139578572) | ||||
| 144582 | 144582 | 94869 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Bridgeview Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53939 | 6012921.0 | 2095173.0 | 37.7336734157115 | -122.397707572671 | (37.7336734157115, -122.397707572671) | |
| 145079 | 145079 | 94876 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53945 | 6011636.0 | 2095053.0 | 37.73327227995121 | -122.402141786329 | (37.7332722799512, -122.402141786329) | ||
| 145240 | 145240 | 88714 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 871 Page St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51655 | 6002408.0 | 2109501.0 | 37.7724236544526 | -122.435078456775 | (37.7724236544526, -122.435078456775) | |||
| 145352 | 145352 | 88133 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 782 Foerster St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51160 | 5998155.0 | 2096174.0 | 37.735588597843396 | -122.44882981346399 | (37.7355885978434, -122.448829813464) | |||
| 145525 | 145525 | 108648 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 196 Lippard Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774607 | 6001751.75522 | 2094959.06379 | 37.7324576925005 | -122.436307555189 | (37.7324576925005, -122.436307555189) | |
| 145993 | 145993 | 106859 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 946 RHODE ISLAND ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 14 | 3x3 | Permit Number 773008 | 6011839.2 | 2104029.4 | 37.7579308843014 | -122.402070102772 | (37.7579308843014, -122.402070102772) | ||
| 9562 | 9562 | 19696 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY9 | -3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 71627 | 71627 | 121889 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 17th Ave | 0 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5990520.54715 | 2115002.72082 | 37.78684768786071 | -122.47659987163799 | (37.7868476878607, -122.476599871638) | |||
| 179150 | 179150 | 236928 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 563 Ellsworth St | 0 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008012.37418 | 2096216.3399099999 | 37.736263633562395 | -122.414751994907 | (37.7362636335624, -122.414751994907) | |||
| 26 | 26 | 237469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4200 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2000 12:00:00 AM | 0 | Width 3ft | Permit Number 43111 | 6001814.64366 | 2102375.07824 | 37.75282390261339 | -122.43662077403299 | (37.7528239026134, -122.436620774033) | |
| 71 | 71 | 251206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005145.0 | 2094297.0 | 37.7308320294825 | -122.424529217878 | (37.7308320294825, -122.424529217878) |
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");