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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13959 | 13959 | 110743 | Section 143 8 | Cercis occidentalis :: Western Redbud 246 | 2300x Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010565.192009999 | 2106016.80838 | 37.7633166706365 | -122.406616231274 | (37.7633166706365, -122.406616231274) | ||
14294 | 14294 | 110746 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010517.260009999 | 2106013.51672 | 37.7633049506856 | -122.406781781161 | (37.7633049506856, -122.406781781161) | ||
15363 | 15363 | 110742 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010595.22782 | 2106018.33058 | 37.7633225306396 | -122.40651245401101 | (37.7633225306396, -122.406512454011) | ||
16786 | 16786 | 110745 | Section 143 8 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 2300x Mariposa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010533.01376 | 2106015.32988 | 37.763310810661295 | -122.406727421634 | (37.7633108106613, -122.406727421634) | ||
77589 | 77589 | 110797 | Section 143 8 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 440 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2015 12:00:00 AM | 3 | 6003697.7 | 2098979.2 | 37.743606443306206 | -122.42986661573299 | (37.7436064433062, -122.429866615733) | |||
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) | |
14802 | 14802 | 24222 | Section 143 8 | Quercus suber :: Cork Oak 76 | 54 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2010 12:00:00 AM | 3 | 4x4 | this is original dpw basin record. | 6017205.2608 | 2094992.48681 | 37.7334154068844 | -122.38288292190398 | (37.7334154068844, -122.382882921904) | |
175584 | 175584 | 96402 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2160 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2011 12:00:00 AM | 1 | 2x3 | 5985141.5215 | 2100472.7854 | 37.746639122425606 | -122.494138462065 | (37.7466391224256, -122.494138462065) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |
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) | ||
140477 | 140477 | 70518 | Section 143 8 | Prunus serrulata :: Ornamental Cherry 35 | 27 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1994 12:00:00 AM | 3x3 | Permit Number 775094 | 6004529.42153392 | 2093371.60291271 | 37.728256311969396 | -122.426591501924 | (37.7282563119694, -122.426591501924) | ||
8240 | 8240 | 111918 | Section 143 8 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 41 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773012 | 6001705.38657 | 2120044.83908 | 37.801334410325104 | -122.438264349848 | (37.8013344103251, -122.438264349848) | |
13845 | 13845 | 117146 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | |
15089 | 15089 | 117148 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011961.8463 | 2098027.63913 | 37.7414581941431 | -122.401224196662 | (37.7414581941431, -122.401224196662) | |
15752 | 15752 | 117149 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.155180001 | 2097982.19203 | 37.7413315821976 | -122.40133403893499 | (37.7413315821976, -122.401334038935) | |
15833 | 15833 | 117147 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978001 | (37.7414998183769, -122.40118925978) | |
18623 | 18623 | 117138 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 3 | 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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
139017 | 139017 | 117144 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 9 | 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) | |
1723 | 1723 | 112197 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 2570 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/2015 12:00:00 AM | 3 | 3x3 | 6001886.22681 | 2116705.46829 | 37.792175654341605 | -122.43739930364599 | (37.7921756543416, -122.437399303646) | ||
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) | |||
144968 | 144968 | 17872 | Section 143 8 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2148 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/21/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53638 | 6003654.7045158 | 2115269.5781823 | 37.788333445178104 | -122.43117780902399 | (37.7883334451781, -122.431177809024) |
12972 | 12972 | 92206 | Section 143 8 | Ginkgo biloba :: Maidenhair Tree 44 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.7684400002 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | |
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) | ||
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) | ||
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) | ||
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) | ||
139876 | 139876 | 31650 | Section 143 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3632 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2015 12:00:00 AM | 3 | Permit Number 35160 | 5981711.46236471 | 2097421.70961548 | 37.7380604052223 | -122.505772893936 | (37.7380604052223, -122.505772893936) | ||
79039 | 79039 | 112619 | Section 143 8 | Cassia leptophylla :: Gold Medallion Tree 406 | 3534 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2015 12:00:00 AM | 3x3 | 6005980.0 | 2102026.6 | 37.752102890525606 | -122.42219142885 | (37.7521028905256, -122.42219142885) | |||
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) | ||
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) | |||
128813 | 128813 | 112756 | Section 143 8 | Tristaniopsis laurina :: Swamp Myrtle 37 | 590x 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | 3x3 | 5989085.68012 | 2111584.9380099997 | 37.7773800886213 | -122.481313741677 | (37.7773800886213, -122.481313741677) | |||
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) | |||
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) | ||
29879 | 29879 | 97159 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012757.6057400005 | 2089814.3813 | 37.7189506418481 | -122.397896712286 | (37.7189506418481, -122.397896712286) | ||
72331 | 72331 | 97157 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 2 | Permit Number 768080 | 6012734.70575 | 2089832.2191 | 37.7189983454895 | -122.397977119771 | (37.7189983454895, -122.397977119771) | ||
73660 | 73660 | 97156 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012721.62132 | 2089840.20593 | 37.7190195469812 | -122.39802290784401 | (37.7190195469812, -122.398022907844) | ||
132132 | 132132 | 97154 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 4 | Permit Number 768080 | 6012676.26956 | 2089874.1029 | 37.7191100952408 | -122.398182049174 | (37.7191100952408, -122.398182049174) | ||
149702 | 149702 | 97155 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012703.24235 | 2089857.9517299999 | 37.719067249734294 | -122.398087681509 | (37.7190672497343, -122.398087681509) | ||
181154 | 181154 | 97158 | Section 143 8 | Schinus molle :: California Pepper 138 | 1079 Le Conte Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2011 12:00:00 AM | 3 | Permit Number 768080 | 6012744.23117 | 2089823.98249 | 37.7189762599209 | -122.39794361640101 | (37.7189762599209, -122.397943616401) | ||
16141 | 16141 | 116230 | Section 143 8 | Pittosporum undulatum :: Victorian Box 26 | 49 Grace St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2014 12:00:00 AM | 3 | 2.5x4 | Permit Number 770598 | 6008318.164030001 | 2110322.45497 | 37.7750129977898 | -122.414692709823 | (37.7750129977898, -122.414692709823) | |
11899 | 11899 | 113090 | Section 143 8 | Pyrus calleryana :: Ornamental Pear 9 | 1213 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6008675.52728 | 2094042.6087200001 | 37.7303322746045 | -122.41230559972999 | (37.7303322746045, -122.41230559973) | ||
12209 | 12209 | 113082 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 414 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6010030.65327 | 2092539.3572 | 37.726280612054204 | -122.40751477809499 | (37.7262806120542, -122.407514778095) | ||
138606 | 138606 | 94563 | Section 143 8 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Oak St | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 09/15/2010 12:00:00 AM | Permit Number 53745 | 6005493.0 | 2110231.0 | 37.7746027492624 | -122.42445906794902 | (37.7746027492624, -122.424459067949) | |||
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) | ||
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) | |||
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) | ||
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) | |||
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) | |
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
144368 | 144368 | 113609 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 7 | 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) | |||
145031 | 145031 | 113612 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 3 | 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) | |||
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) | ||
44012 | 44012 | 114160 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 2250 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002777.5161 | 2117854.22202 | 37.7953804657925 | -122.43439760046499 | (37.7953804657925, -122.434397600465) | |
62298 | 62298 | 114159 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 2250 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770124 | 6002793.85496 | 2117859.65506 | 37.795396310934294 | -122.434341453993 | (37.7953963109343, -122.434341453993) | |
8965 | 8965 | 107967 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770079 | 6001240.6892800005 | 2116684.58018 | 37.792081580751294 | -122.439631370586 | (37.7920815807513, -122.439631370586) | |
79684 | 79684 | 107964 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 2401x SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770079 | 6001096.0 | 2116670.0 | 37.792033311180504 | -122.440130949989 | (37.7920333111805, -122.440130949989) | |
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) | |
1138 | 1138 | 44040 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 2504 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2012 12:00:00 AM | 3 | Permit Number 769379 | 6002104.9323 | 2116736.7445400003 | 37.7922739619269 | -122.436644820121 | (37.7922739619269, -122.436644820121) | ||
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) | |
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) | ||
71351 | 71351 | 101919 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 9 | 3x3 | Permit Number 769132 | 6007497.406219999 | 2116101.25633 | 37.7908340376155 | -122.417941633898 | (37.7908340376155, -122.417941633898) | |
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) | ||
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) | ||
143550 | 143550 | 101925 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1099X Hyde St | 2 | 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) | ||
144056 | 144056 | 101924 | Section 143 8 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1099X Hyde St | 1 | 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) | ||
154640 | 154640 | 101920 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 13 | 3x3 | Permit Number 769132 | 6007536.5156 | 2116104.21807 | 37.79084437080729 | -122.41780652694901 | (37.7908443708073, -122.417806526949) | |
159429 | 159429 | 101921 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769132 | 6007574.87115 | 2116111.37594 | 37.7908661829645 | -122.41767432572901 | (37.7908661829645, -122.417674325729) | |
185806 | 185806 | 101922 | Section 143 8 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769132 | 6007599.52227 | 2116115.67925 | 37.7908793859256 | -122.417589338874 | (37.7908793859256, -122.417589338874) | |
78687 | 78687 | 108260 | Section 143 8 | Liquidambar styraciflua :: American Sweet Gum 62 | 45 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2014 12:00:00 AM | 3 | 6003817.04493 | 2108084.5446900004 | 37.768614322037294 | -122.430103370918 | (37.7686143220373, -122.430103370918) | |||
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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) |
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");