Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2582 | 2582 | 253132 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 522 Avalon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004047.94044 | 2092448.5749599999 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | ||||
| 1850 | 1850 | 251747 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 706 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002959.0 | 2087321.0 | 37.7115537887528 | -122.431588720074 | (37.7115537887528, -122.431588720074) | ||||
| 34843 | 34843 | 250128 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1798 Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005370.71997 | 2115516.69917 | 37.78910907136579 | -122.42525826176399 | (37.7891090713658, -122.425258261764) | |||
| 35750 | 35750 | 250093 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.789394379498894 | -122.425398617158 | (37.7893943794989, -122.425398617158) | |||
| 132641 | 132641 | 250079 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 5 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6005448.26526 | 2115310.78255 | 37.7885480563034 | -122.42497530809099 | (37.7885480563034, -122.424975308091) | |||
| 136912 | 136912 | 250078 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005435.52045 | 2115308.45101 | 37.78854093456471 | -122.425019237271 | (37.7885409345647, -122.425019237271) | |||
| 181941 | 181941 | 250077 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6005420.83643 | 2115306.80822 | 37.7885355944018 | -122.425069924841 | (37.7885355944018, -122.425069924841) | |||
| 187777 | 187777 | 250076 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6005407.46076 | 2115305.4621099997 | 37.788531142735295 | -122.425116106829 | (37.7885311427353, -122.425116106829) | |||
| 1099 | 1099 | 250070 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 1 | : 4 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005393.47416 | 2115303.0126799997 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | |||
| 61770 | 61770 | 249991 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011578.47013 | 2120102.62532 | 37.802049668108396 | -122.404102989475 | (37.8020496681084, -122.404102989475) | |||
| 184956 | 184956 | 249990 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011580.18498 | 2120103.15607 | 37.802051221233 | -122.404097092619 | (37.802051221233, -122.404097092619) | |||
| 35263 | 35263 | 249989 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011581.894069999 | 2120103.40396 | 37.802051997370896 | -122.404091195777 | (37.8020519973709, -122.404091195777) | |||
| 61458 | 61458 | 249988 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011583.89861 | 2120104.21147 | 37.802054326596206 | -122.404084315938 | (37.8020543265962, -122.404084315938) | |||
| 159610 | 159610 | 249987 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011587.32256 | 2120104.99043 | 37.802056656736 | -122.404072522227 | (37.802056656736, -122.404072522227) | |||
| 45739 | 45739 | 249986 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011589.33259 | 2120106.08083 | 37.802059763014 | -122.404065643309 | (37.802059763014, -122.404065643309) | |||
| 183705 | 183705 | 249985 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011591.62105 | 2120106.88257 | 37.802062092258 | -122.40405778055799 | (37.802062092258, -122.404057780558) | |||
| 70754 | 70754 | 249984 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 226 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6011604.5053 | 2120111.99388 | 37.8020768465317 | -122.404013554575 | (37.8020768465317, -122.404013554575) | |||
| 133037 | 133037 | 249983 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 226 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011603.53088 | 2120119.93244 | 37.8020985894405 | -122.40401748554301 | (37.8020985894405, -122.404017485543) | |||
| 26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
| 60021 | 60021 | 249949 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011354.62644 | 2120055.4997 | 37.801907763195 | -122.404874279527 | (37.801907763195, -122.404874279527) | |||
| 148756 | 148756 | 249948 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6011338.9869 | 2120052.71472 | 37.8018992421182 | -122.40492820376998 | (37.8018992421182, -122.40492820377) | |||
| 41677 | 41677 | 249947 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011342.9125 | 2120054.18632 | 37.8019035022036 | -122.40491472295 | (37.8019035022036, -122.40491472295) | |||
| 74131 | 74131 | 249946 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 305 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6011346.83837 | 2120055.6582400003 | 37.801907763181205 | -122.404901241218 | (37.8019077631812, -122.404901241218) | |||
| 63040 | 63040 | 249939 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 331 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 0ft | 6011281.55151 | 2120038.154 | 37.801856051265204 | -122.40512593233 | (37.8018560512652, -122.40512593233) | |||
| 154615 | 154615 | 249823 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010881.14413 | 2120640.5408 | 37.8034876651725 | -122.406554008974 | (37.8034876651725, -122.406554008974) | |||
| 183937 | 183937 | 249822 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 0ft | 6010893.58143 | 2120633.6568400003 | 37.8034694593133 | -122.406510483572 | (37.8034694593133, -122.406510483572) | |||
| 39363 | 39363 | 249821 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010901.8759699995 | 2120623.17353 | 37.8034411387496 | -122.406481040676 | (37.8034411387496, -122.406481040676) | |||
| 46865 | 46865 | 249820 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6010902.80513 | 2120614.31353 | 37.8034168633488 | -122.40647720057301 | (37.8034168633488, -122.406477200573) | |||
| 137536 | 137536 | 249818 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Kearny St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 0ft | 6010887.46579 | 2120660.30432 | 37.803542284601996 | -122.40653352599399 | (37.803542284602, -122.406533525994) | |||
| 172051 | 172051 | 249551 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005490.31575 | 2114993.82461 | 37.787680143969496 | -122.424807261672 | (37.7876801439695, -122.424807261672) | |||
| 40929 | 40929 | 249550 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005507.2276099995 | 2114996.10092 | 37.7876873493358 | -122.424748911848 | (37.7876873493358, -122.424748911848) | |||
| 149175 | 149175 | 249549 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6005525.061919999 | 2114997.09858 | 37.7876910959164 | -122.424687279516 | (37.7876910959164, -122.424687279516) | |||
| 168630 | 168630 | 249544 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 298 Myrtle St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006142.8789800005 | 2114042.34322 | 37.7851044469485 | -122.422481881052 | (37.7851044469485, -122.422481881052) | |||
| 43603 | 43603 | 249538 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 7 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6006360.10871 | 2114050.0114700003 | 37.785137754239294 | -122.421730877876 | (37.7851377542393, -122.421730877876) | |||
| 67177 | 67177 | 249537 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6006345.87488 | 2114047.3209700002 | 37.7851295641198 | -122.421779931396 | (37.7851295641198, -122.421779931396) | |||
| 182097 | 182097 | 249536 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006331.73852 | 2114045.88325 | 37.7851248193023 | -122.421828736708 | (37.7851248193023, -122.421828736708) | |||
| 148879 | 148879 | 249535 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6006279.61488 | 2114039.5342599996 | 37.7851044469537 | -122.422008617322 | (37.7851044469537, -122.422008617322) | |||
| 24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
| 173152 | 173152 | 249533 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006226.92854 | 2114031.46887 | 37.78507932978 | -122.42219032262 | (37.78507932978, -122.42219032262) | |||
| 186609 | 186609 | 249532 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006202.66878 | 2114026.7968200003 | 37.7850651330954 | -122.42227392182801 | (37.7850651330954, -122.422273921828) | |||
| 156172 | 156172 | 249529 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1035 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006430.75514 | 2114125.51985 | 37.7853490652506 | -122.4214918273 | (37.7853490652506, -122.4214918273) | |||
| 60116 | 60116 | 248097 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010442.71302 | 2099823.47595 | 37.7463043033989 | -122.406603382656 | (37.7463043033989, -122.406603382656) | |||
| 178320 | 178320 | 248096 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010442.96014 | 2099835.6038900004 | 37.7463376179016 | -122.406603382642 | (37.7463376179016, -122.406603382642) | |||
| 151503 | 151503 | 248095 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010444.10359 | 2099844.52048 | 37.746362164885 | -122.406600056945 | (37.746362164885, -122.406600056945) | |||
| 172952 | 172952 | 248094 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6010447.33936 | 2099861.6956599997 | 37.7464095052133 | -122.406590078085 | (37.7464095052133, -122.406590078085) | |||
| 130796 | 130796 | 248093 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010450.13728 | 2099873.13293 | 37.746441065995604 | -122.40658120898199 | (37.7464410659956, -122.406581208982) | |||
| 64363 | 64363 | 248092 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 8 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010451.32651 | 2099884.28332 | 37.7464717490664 | -122.40657788235701 | (37.7464717490664, -122.406577882357) | |||
| 48850 | 48850 | 246960 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2177 15th St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6003038.46952 | 2107086.92585 | 37.7658309772437 | -122.432725124067 | (37.7658309772437, -122.432725124067) | |||
| 173556 | 173556 | 246911 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 459 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997556.58518 | 2107424.48902 | 37.766445417441204 | -122.451710064262 | (37.7664454174412, -122.451710064262) | |||
| 182457 | 182457 | 246824 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 402 Franconia St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6009972.67277 | 2098701.6792900003 | 37.7431977860534 | -122.408149630203 | (37.7431977860534, -122.408149630203) | |||
| 38814 | 38814 | 221775 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 21 Addison St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | |||
| 133444 | 133444 | 221774 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001628.85719 | 2097123.02869 | 37.7383924556487 | -122.43688730163 | (37.7383924556487, -122.43688730163) | |||
| 31793 | 31793 | 221773 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | |||
| 155006 | 155006 | 221772 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 71 Miguel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003850.95701 | 2097297.26656 | 37.7389969178725 | -122.429216785123 | (37.7389969178725, -122.429216785123) | |||
| 30740 | 30740 | 221771 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | |||
| 183969 | 183969 | 221770 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001816.47531 | 2096513.16567 | 37.736728574973604 | -122.436194979235 | (37.7367285749736, -122.436194979235) | |||
| 179987 | 179987 | 221769 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001830.02285 | 2096488.5302 | 37.7366617013818 | -122.436146377158 | (37.7366617013818, -122.436146377158) | |||
| 180841 | 180841 | 221768 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1888 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004580.21183 | 2097666.30062 | 37.740051458397495 | -122.426721628722 | (37.7400514583975, -122.426721628722) | |||
| 46074 | 46074 | 221767 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 287 Hermann St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6003902.82897 | 2108654.79623 | 37.770184952298 | -122.429847331292 | (37.770184952298, -122.429847331292) | |||
| 43952 | 43952 | 221766 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 712 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002158.80169 | 2108813.78872 | 37.770522589268204 | -122.43589127638799 | (37.7705225892682, -122.435891276388) | |||
| 183455 | 183455 | 221765 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 165 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000037.69587 | 2106199.4106799997 | 37.7632234397255 | -122.443040392005 | (37.7632234397255, -122.443040392005) | |||
| 49806 | 49806 | 221764 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3809 16th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6001727.44948 | 2106346.3994299998 | 37.7637232334694 | -122.437206631108 | (37.7637232334694, -122.437206631108) | |||
| 31786 | 31786 | 221763 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3816 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002948.3546400005 | 2103602.92928 | 37.7562596509731 | -122.432787903054 | (37.7562596509731, -122.432787903054) | |||
| 32542 | 32542 | 221762 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4407 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001705.956180001 | 2104074.38405 | 37.7574836102927 | -122.43711828977399 | (37.7574836102927, -122.437118289774) | |||
| 47631 | 47631 | 221761 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4441 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001542.762080001 | 2104063.39418 | 37.75744415704379 | -122.437681892224 | (37.7574441570438, -122.437681892224) | |||
| 54829 | 54829 | 221760 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001372.8328 | 2104055.08022 | 37.7574116654297 | -122.43826897865101 | (37.7574116654297, -122.438268978651) | |||
| 49294 | 49294 | 221759 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001360.92884 | 2104054.05926 | 37.7574081850601 | -122.438310074049 | (37.7574081850601, -122.438310074049) | |||
| 63403 | 63403 | 221758 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4515 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001348.5727699995 | 2104052.2530799997 | 37.757402522937 | -122.438352676761 | (37.757402522937, -122.438352676761) | |||
| 158252 | 158252 | 221757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Seward St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 3ft | 6001069.49524 | 2104258.14697 | 37.7579519799282 | -122.43933259334699 | (37.7579519799282, -122.439332593347) | |||
| 153546 | 153546 | 221756 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3649 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004058.63602 | 2103618.7990900003 | 37.7563661334022 | -122.42894929977699 | (37.7563661334022, -122.428949299777) | |||
| 44045 | 44045 | 221755 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 14 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004062.6885 | 2102905.39693 | 37.7544075287057 | -122.42888442629601 | (37.7544075287057, -122.428884426296) | |||
| 188993 | 188993 | 221754 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3879 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003935.10667 | 2102444.58543 | 37.753135026677604 | -122.42929277965099 | (37.7531350266776, -122.429292779651) | |||
| 154406 | 154406 | 221753 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 466 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003367.55908 | 2102748.60922 | 37.7539376572014 | -122.431277170628 | (37.7539376572014, -122.431277170628) | |||
| 184898 | 184898 | 221752 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4000 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003785.28495 | 2101310.15216 | 37.75001165602829 | -122.42972998686301 | (37.7500116560283, -122.429729986863) | |||
| 57484 | 57484 | 221751 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4000 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003801.92979 | 2101310.951 | 37.750014791971104 | -122.429672485102 | (37.7500147919711, -122.429672485102) | |||
| 27258 | 27258 | 220664 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1192 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003819.11819 | 2101351.9934400003 | 37.7501284581809 | -122.429615973494 | (37.7501284581809, -122.429615973494) | |||
| 170184 | 170184 | 220663 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003819.29636 | 2101374.54384 | 37.7501903863949 | -122.42961696546999 | (37.7501903863949, -122.42961696547) | |||
| 174293 | 174293 | 220662 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005443.37587 | 2096387.81015 | 37.7365897745051 | -122.42364628187599 | (37.7365897745051, -122.423646281876) | |||
| 147861 | 147861 | 220661 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005456.84136 | 2096363.09768 | 37.7365226796806 | -122.423597969391 | (37.7365226796806, -122.423597969391) | |||
| 184201 | 184201 | 220660 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003703.338380001 | 2095523.5259999998 | 37.734118272040604 | -122.429600714704 | (37.7341182720406, -122.429600714704) | |||
| 50288 | 50288 | 220659 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 998 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009137.788819999 | 2103468.55533 | 37.756239784053996 | -122.41137313676799 | (37.756239784054, -122.411373136768) | |||
| 75445 | 75445 | 220658 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 172 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007553.6507 | 2100235.86656 | 37.7472745765577 | -122.416622650424 | (37.7472745765577, -122.416622650424) | |||
| 44032 | 44032 | 220657 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 505 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008343.07833 | 2096482.99595 | 37.737014388512996 | -122.41362746465799 | (37.737014388513, -122.413627464658) | |||
| 66877 | 66877 | 220656 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 505 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008322.74158 | 2096484.8015599998 | 37.737018204322 | -122.41369790583 | (37.737018204322, -122.41369790583) | |||
| 38930 | 38930 | 220655 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008083.69599 | 2096082.2563599998 | 37.735899476465704 | -122.41449592016599 | (37.7358994764657, -122.414495920166) | |||
| 63824 | 63824 | 220654 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008103.73158 | 2096079.3451 | 37.735892608341 | -122.414426443037 | (37.735892608341, -122.414426443037) | |||
| 152079 | 152079 | 220653 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008119.35429 | 2096079.0254799998 | 37.7358926083592 | -122.41437240636002 | (37.7358926083592, -122.41437240636) | |||
| 172151 | 172151 | 220652 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 324 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | |||
| 126745 | 126745 | 220651 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6008064.96703 | 2099392.46104 | 37.74498751697679 | -122.41479487098101 | (37.7449875169768, -122.414794870981) | |||
| 157432 | 157432 | 220650 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6008081.1542 | 2099392.86215 | 37.744989527842996 | -122.41473892687999 | (37.744989527843, -122.41473892688) | |||
| 59975 | 59975 | 220649 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 41 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008103.651880001 | 2099402.16609 | 37.7450163384242 | -122.414661792014 | (37.7450163384242, -122.414661792014) | |||
| 183131 | 183131 | 220648 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 35 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008125.23959 | 2099402.94475 | 37.74501968930829 | -122.414587200443 | (37.7450196893083, -122.414587200443) | |||
| 64810 | 64810 | 220647 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007230.99534 | 2098247.75396 | 37.7417975128515 | -122.41759748493999 | (37.7417975128515, -122.41759748494) | |||
| 37791 | 37791 | 220646 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008205.0189 | 2095636.66757 | 37.7346828016745 | -122.41404494431801 | (37.7346828016745, -122.414044944318) | |||
| 133342 | 133342 | 220645 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008216.9228300005 | 2095637.5252200002 | 37.7346858251821 | -122.414003848906 | (37.7346858251821, -122.414003848906) | |||
| 58297 | 58297 | 220644 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6009354.03531 | 2097334.2588400003 | 37.7394084890188 | -122.410192201918 | (37.7394084890188, -122.410192201918) | |||
| 163606 | 163606 | 220643 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009355.21688 | 2097375.10372 | 37.739520706418396 | -122.410190999519 | (37.7395207064184, -122.410190999519) | |||
| 161762 | 161762 | 220642 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008547.4442300005 | 2096175.62445 | 37.7361818869891 | -122.41289915230101 | (37.7361818869891, -122.412899152301) | |||
| 132179 | 132179 | 220641 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 859 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007571.590369999 | 2095340.9683400001 | 37.7338352787826 | -122.416213992189 | (37.7338352787826, -122.416213992189) | |||
| 157605 | 157605 | 220640 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 821 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007587.8208800005 | 2095563.9191 | 37.7344483655074 | -122.416173662982 | (37.7344483655074, -122.416173662982) |
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");