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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
80666 | 80666 | 85452 | Section 143 8 | Tree(s) :: 17 | 275 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006138.0 | 2107427.0 | 37.7669400383946 | -122.422028645748 | (37.7669400383946, -122.422028645748) | |
80836 | 80836 | 103465 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 890X Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012118.0 | 2118740.5 | 37.7983397318906 | -122.402140129264 | (37.7983397318906, -122.402140129264) | |||||
81380 | 81380 | 112795 | Section 143 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.763735444165796 | -122.49984801640899 | (37.7637354441658, -122.499848016409) | |||
81444 | 81444 | 101926 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1099X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 3x3 | Permit Number 769132 | 6007639.0 | 2116135.7 | 37.790936579280896 | -122.417454166812 | (37.7909365792809, -122.417454166812) | ||
81451 | 81451 | 98286 | Section 143 8 | Cercis occidentalis :: Western Redbud 246 | 300 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
81723 | 81723 | 85457 | Section 143 8 | Tree(s) :: 17 | 265 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
82275 | 82275 | 109948 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
82447 | 82447 | 98285 | Section 143 8 | Cercis occidentalis :: Western Redbud 246 | 300 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
82449 | 82449 | 112583 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | |||
82994 | 82994 | 113610 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
82999 | 82999 | 109123 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
83145 | 83145 | 118340 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
83581 | 83581 | 43568 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 601 29TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2000 12:00:00 AM | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) | |||
83777 | 83777 | 103097 | Section 143 8 | Fagus sylvatica 'Red Obelisk' :: Red Obelisk Beech 478 | 1199X Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/2013 12:00:00 AM | 3x3 | Permit Number 768649 | 6008392.3 | 2117900.9 | 37.7958257402639 | -122.41497276422399 | (37.7958257402639, -122.414972764224) | ||
84121 | 84121 | 117143 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
84197 | 84197 | 113998 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 1110 SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2015 12:00:00 AM | 3 | 3x3 | 6007591.0 | 2103152.0 | 37.75528371898589 | -122.41670005245301 | (37.7552837189859, -122.416700052453) | ||
84595 | 84595 | 102523 | Section 143 8 | Liquidambar styraciflua :: American Sweet Gum 62 | 2192 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2013 12:00:00 AM | 3X3 | Permit Number 769544 | 5992300.8 | 2100554.8 | 37.7472806432819 | -122.46938861272601 | (37.7472806432819, -122.469388612726) | ||
86995 | 86995 | 85449 | Section 143 8 | Tree(s) :: 17 | 287 GUERRERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6005798.0 | 2107491.2 | 37.7670971345308 | -122.42320921716801 | (37.7670971345308, -122.423209217168) | |
87817 | 87817 | 112830 | Section 143 8 | Pittosporum undulatum :: Victorian Box 26 | 2265 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/2015 12:00:00 AM | 3 | 3x3 | 6006944.0 | 2105170.0 | 37.760788269780996 | -122.41908070679399 | (37.760788269781, -122.419080706794) | ||
87984 | 87984 | 108821 | Section 143 8 | Acer buergeranum :: Trident Maple 120 | 101x FREMONT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | 5x5 | Permit Number 774616 | 6013648.6 | 2115847.1 | 37.7904804500674 | -122.396640813258 | (37.7904804500674, -122.396640813258) | |
88189 | 88189 | 113605 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
88888 | 88888 | 113602 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | ||
88908 | 88908 | 107533 | Section 143 8 | Tree(s) :: 17 | 130 MATEO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774373 | 6003821.3 | 2096389.2 | 37.7365018950939 | -122.429254591879 | (37.7365018950939, -122.429254591879) | |
89850 | 89850 | 113613 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
90414 | 90414 | 112573 | Section 143 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 56 ROCKWOOD CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685.0 | 2098946.0 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | ||
90793 | 90793 | 113600 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | |
92212 | 92212 | 109944 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
93245 | 93245 | 112892 | Section 143 8 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 216 | 1X WEBSTER ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6004219.0 | 2108568.0 | 37.769964530341895 | -122.428747509741 | (37.7699645303419, -122.428747509741) | ||||
93248 | 93248 | 109945 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
93411 | 93411 | 109120 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
93713 | 93713 | 109942 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
93779 | 93779 | 109124 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
94493 | 94493 | 110787 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
94702 | 94702 | 112368 | Section 143 8 | Prunus cerasifera :: Cherry Plum 16 | 550 Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | ||
95513 | 95513 | 117140 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
95747 | 95747 | 85451 | Section 143 8 | Tree(s) :: 17 | 281 GUERRERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6005518.5 | 2107341.2 | 37.7666694929162 | -122.424165297356 | (37.7666694929162, -122.424165297356) | |
95825 | 95825 | 113796 | Section 143 8 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 331 TERESITA BLVD | 2 | Hanging basket : Cutout 29 | Tree 1 | Private 1 | 3x3 | 5997873.0 | 2098382.0 | 37.741635103508294 | -122.44996387489401 | (37.7416351035083, -122.449963874894) | ||||
96009 | 96009 | 112370 | Section 143 8 | Prunus cerasifera :: Cherry Plum 16 | 550 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | ||
97450 | 97450 | 113603 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
97598 | 97598 | 100059 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011435.0 | 2112345.0 | 37.7807410625565 | -122.404053207068 | (37.7807410625565, -122.404053207068) | |
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) | ||||||
97717 | 97717 | 85456 | Section 143 8 | Tree(s) :: 17 | 265 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
97792 | 97792 | 89263 | Section 143 8 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775142 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |
98030 | 98030 | 118337 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
98123 | 98123 | 113611 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
98492 | 98492 | 112891 | Section 143 8 | Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 216 | 1X WEBSTER ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6004219.0 | 2108568.0 | 37.769964530341895 | -122.428747509741 | (37.7699645303419, -122.428747509741) | ||||
98791 | 98791 | 111204 | Section 143 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 168 CLIPPER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2015 12:00:00 AM | 3 | 3x3 | 6004024.0 | 2101044.0 | 37.7492943788142 | -122.428885525131 | (37.7492943788142, -122.428885525131) | ||
99018 | 99018 | 112371 | Section 143 8 | Prunus cerasifera :: Cherry Plum 16 | 550 Jessie St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | ||
99592 | 99592 | 112755 | Section 143 8 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2038 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | 3x3 | 5989157.5 | 2111303.8 | 37.7766123371313 | -122.481044705999 | (37.7766123371313, -122.481044705999) | |||
100550 | 100550 | 109117 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
100892 | 100892 | 109943 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
101156 | 101156 | 111313 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
102243 | 102243 | 111193 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 890x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774267 | 6009115.0 | 2096842.0 | 37.738043451743295 | -122.41098392432899 | (37.7380434517433, -122.410983924329) | |
102547 | 102547 | 112688 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 259 BRIGHT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2015 12:00:00 AM | 3 | 5x4 | 5993720.0 | 2088919.0 | 37.71541351482001 | -122.46363680360001 | (37.71541351482, -122.4636368036) | ||
102863 | 102863 | 113300 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 29 DORLAND ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2015 12:00:00 AM | 3 | 3x3 | 6005366.0 | 2105717.0 | 37.7622012138481 | -122.42457722211901 | (37.7622012138481, -122.424577222119) | ||
103008 | 103008 | 111194 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 890x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 774267 | 6009115.0 | 2096842.0 | 37.738043451743295 | -122.41098392432899 | (37.7380434517433, -122.410983924329) | ||
103897 | 103897 | 117136 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
104643 | 104643 | 109122 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2036x 15TH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12x6 | 6003817.0 | 2107261.0 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | ||||
104982 | 104982 | 109946 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
105420 | 105420 | 85455 | Section 143 8 | Tree(s) :: 17 | 265 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
106507 | 106507 | 85450 | Section 143 8 | Tree(s) :: 17 | 285 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006141.0 | 2107369.0 | 37.7667809533476 | -122.42201414851601 | (37.7667809533476, -122.422014148516) | |
106970 | 106970 | 113608 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
107223 | 107223 | 85454 | Section 143 8 | Tree(s) :: 17 | 269 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006135.0 | 2107486.0 | 37.7671018691982 | -122.42204321408998 | (37.7671018691982, -122.42204321409) | |
107818 | 107818 | 111195 | Section 143 8 | Corymbia ficifolia :: Red Flowering Gum 60 | 890x JARBOE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x12 | 6009115.0 | 2096842.0 | 37.738043451743295 | -122.41098392432899 | (37.7380434517433, -122.410983924329) | |||
108143 | 108143 | 110651 | Section 143 8 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 127 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5999845.0 | 2108967.0 | 37.770811558248 | -122.44390571748998 | (37.770811558248, -122.44390571749) | |||
108178 | 108178 | 112584 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
108448 | 108448 | 85460 | Section 143 8 | Tree(s) :: 17 | 245x Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006128.0 | 2107603.0 | 37.7674227286224 | -122.422075738783 | (37.7674227286224, -122.422075738783) | |
108682 | 108682 | 111636 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2625 35TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2015 12:00:00 AM | 3 | 3x3 | 5985486.0 | 2097347.0 | 37.738076708209796 | -122.492717127165 | (37.7380767082098, -122.492717127165) | ||
108721 | 108721 | 118336 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
109812 | 109812 | 117145 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
110700 | 110700 | 107977 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 2750 JACKSON ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770079 | 6001096.4 | 2116670.4 | 37.7920344322485 | -122.440129594684 | (37.7920344322485, -122.440129594684) | |
111043 | 111043 | 117137 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
111923 | 111923 | 85461 | Section 143 8 | Tree(s) :: 17 | 245x Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006128.0 | 2107603.0 | 37.7674227286224 | -122.422075738783 | (37.7674227286224, -122.422075738783) | |
112158 | 112158 | 111315 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
112556 | 112556 | 112627 | Section 143 8 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2385 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002100.0 | 2114635.0 | 37.78650283124671 | -122.436511387034 | (37.7865028312467, -122.436511387034) | ||||
112757 | 112757 | 117142 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
112863 | 112863 | 32654 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011426.1069309 | 2112339.71009356 | 37.7807260408269 | -122.40408360027 | (37.7807260408269, -122.40408360027) | |
113160 | 113160 | 109947 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 400x CLEMENTINA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | 6011439.0 | 2112324.0 | 37.780683624939606 | -122.40403789076099 | (37.7806836249396, -122.404037890761) | ||
113248 | 113248 | 112574 | Section 143 8 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 56 ROCKWOOD CT | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2015 12:00:00 AM | 3x6 | Permit Number 776002 | 5995685.0 | 2098946.0 | 37.7430582687021 | -122.457569991387 | (37.7430582687021, -122.457569991387) | ||
113705 | 113705 | 112586 | Section 143 8 | Lagunaria patersonii :: Primrose Tree 48 | 3400x WAWONA ST | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4x4 | 5982411.0 | 2096792.0 | 37.7363725426512 | -122.50330767262899 | (37.7363725426512, -122.503307672629) | ||||
113824 | 113824 | 111316 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
114269 | 114269 | 111632 | Section 143 8 | Tree(s) :: 17 | 1758 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774682 | 5985071.0 | 2103231.6 | 37.7542099449347 | -122.49458566251002 | (37.7542099449347, -122.49458566251) | |
115319 | 115319 | 101923 | Section 143 8 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1401X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 3x3 | Permit Number 769132 | 6007402.7 | 2116063.9 | 37.790726135860204 | -122.418266664095 | (37.7907261358602, -122.418266664095) | ||
115517 | 115517 | 118338 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
116007 | 116007 | 113607 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
116308 | 116308 | 85459 | Section 143 8 | Tree(s) :: 17 | 245x Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 4x4 | Permit Number 774478 | 6006128.0 | 2107603.0 | 37.7674227286224 | -122.422075738783 | (37.7674227286224, -122.422075738783) | |
116617 | 116617 | 117139 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
116665 | 116665 | 103467 | Section 143 8 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 890X Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012118.0 | 2118740.5 | 37.7983397318906 | -122.402140129264 | (37.7983397318906, -122.402140129264) | |||||
117182 | 117182 | 111314 | Section 143 8 | Tree(s) :: 17 | 3400x Wawona St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | 5982298.43845 | 2096733.6213900002 | 37.7362056333855 | -122.503692516423 | (37.7362056333855, -122.503692516423) | ||
117371 | 117371 | 113795 | Section 143 8 | Maytenus boaria :: Mayten 22 | 331 TERESITA BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997873.0 | 2098382.0 | 37.741635103508294 | -122.44996387489401 | (37.7416351035083, -122.449963874894) | ||||
120424 | 120424 | 72837 | Section 143 8 | Gleditsia triacanthos :: Honey Locust 67 | 2624 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770762 | 6010331.33933918 | 2104014.11752446 | 37.7578046465334 | -122.407283867997 | (37.7578046465334, -122.407283867997) | |
121912 | 121912 | 111085 | Section 143 8 | Acer japonicum :: Japanese Maple 183 | 117 Manchester St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/20/2015 12:00:00 AM | 3 | Permit Number 774000 | 6008295.8 | 2099262.4 | 37.744643365507706 | -122.413987490618 | (37.7446433655077, -122.413987490618) | ||
121990 | 121990 | 118341 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 1 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006507.0 | 2110162.0 | 37.774470501260296 | -122.42094653529199 | (37.7744705012603, -122.420946535292) | ||||
122514 | 122514 | 113604 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
122830 | 122830 | 113601 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | ||
123153 | 123153 | 117141 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
123283 | 123283 | 112369 | Section 143 8 | Prunus cerasifera :: Cherry Plum 16 | 550 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 12:00:00 AM | 3 | 3x3 | 6009683.8 | 2112475.6 | 37.7810016601266 | -122.410120702727 | (37.7810016601266, -122.410120702727) | ||
123789 | 123789 | 113606 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
124592 | 124592 | 109936 | Section 143 8 | Lophostemon confertus :: Brisbane Box 11 | 260 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011302.0 | 2112245.5 | 37.780460426865396 | -122.404506314811 | (37.7804604268654, -122.404506314811) |
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");