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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179054 | 179054 | 249777 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010400.427069999 | 2121136.58311 | 37.8048227690275 | -122.40825256571001 | (37.8048227690275, -122.40825256571) | |||
| 122510 | 122510 | 116619 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 120x KNOLLVIEW WAY | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 3x3 | 5997764.0 | 2102030.0 | 37.7516453806516 | -122.45060370088001 | (37.7516453806516, -122.45060370088) | |||
| 92869 | 92869 | 99821 | Undocumented 2 | Salix spp :: Willow 218 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Tree closest to sidewalk and retaining wall | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 95481 | 95481 | 101470 | Undocumented 2 | Salix spp :: Willow 218 | 1230 Twin Peaks Blvd | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||||
| 103296 | 103296 | 101469 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||||
| 119975 | 119975 | 112668 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 129 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002668.0 | 2107340.8 | 37.766507036069605 | -122.434024647923 | (37.7665070360696, -122.434024647923) | ||||||
| 163239 | 163239 | 220552 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 13 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6002169.64489 | 2096371.31931 | 37.736359156858704 | -122.434963778568 | (37.7363591568587, -122.434963778568) | |||
| 177217 | 177217 | 245789 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 13 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 2ft | 6002510.68516 | 2096313.6496700002 | 37.736220167514404 | -122.433780540537 | (37.7362201675144, -122.433780540537) | |||
| 120804 | 120804 | 96938 | Property Tree 7 | Tree(s) :: 17 | 1306 Cole St | Back Yard : Yard 13 | Tree 1 | Private 1 | Backyard tree on private property | 5998246.0 | 2105961.0 | 37.7624665052811 | -122.449220068104 | (37.7624665052811, -122.449220068104) | |||||
| 50494 | 50494 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 131X Washington St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.796266453658795 | -122.397554954018 | (37.7962664536588, -122.397554954018) | |
| 103907 | 103907 | 106639 | Private 5 | Private shrub :: Private Shrub 64 | 1321X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2105100.0 | 37.7601403710114 | -122.44686158716699 | (37.7601403710114, -122.446861587167) | |||||
| 123904 | 123904 | 106641 | Private 5 | Private shrub :: Private Shrub 64 | 1323X CLAYTON ST | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
| 140844 | 140844 | 102706 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1342 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | |||||
| 126828 | 126828 | 115415 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 137 ANZAVISTA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5999865.0 | 2112093.0 | 37.7793958997315 | -122.444061187374 | (37.7793958997315, -122.444061187374) | ||||
| 2864 | 2864 | 209183 | Undocumented 2 | Tree(s) :: 17 | 140 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994862.40668 | 2098482.07156 | 37.741737150351 | -122.460380669142 | (37.741737150351, -122.460380669142) | |
| 27119 | 27119 | 209185 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 3ft | 5994853.690119999 | 2098493.2474700003 | 37.741767335194105 | -122.460411617495 | (37.7417673351941, -122.460411617495) | |||
| 48070 | 48070 | 209184 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 3ft | 5994856.4919300005 | 2098484.57238 | 37.7417436767315 | -122.460401301401 | (37.7417436767315, -122.460401301401) | |||
| 48281 | 48281 | 209182 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5994867.86795 | 2098472.15279 | 37.7417102300345 | -122.46036106750799 | (37.7417102300345, -122.460361067508) | |||
| 174819 | 174819 | 209181 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5994876.85162 | 2098459.48593 | 37.7416759667651 | -122.46032908762699 | (37.7416759667651, -122.460329087627) | |||
| 177691 | 177691 | 209186 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5994849.5459 | 2098494.81966 | 37.741771413634794 | -122.46042606063 | (37.7417714136348, -122.46042606063) | |||
| 186211 | 186211 | 197763 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1405 Minnesota St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6015410.29997 | 2101920.42662 | 37.7523387624307 | -122.389572339186 | (37.7523387624307, -122.389572339186) | ||||
| 119332 | 119332 | 120526 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1439 47th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x3 | 5981489.0 | 2105275.0 | 37.759610238830206 | -122.50712446853998 | (37.7596102388302, -122.50712446854) | |||
| 1398 | 1398 | 251517 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 145 Bonview St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6007188.0 | 2098162.0 | 37.7415596321362 | -122.417740072125 | (37.7415596321362, -122.417740072125) | ||||
| 102307 | 102307 | 99256 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1466 York St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010099.0 | 2100741.0 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | ||||||
| 140030 | 140030 | 103504 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 148 Huntington Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5984515.0 | 2095210.0 | 37.732152252278794 | -122.49591670504999 | (37.7321522522788, -122.49591670505) | |||||
| 1604 | 1604 | 251632 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 1605 | 1605 | 251634 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 1646 | 1646 | 251633 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 14R Amethyst Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999202.0 | 2100044.0 | 37.746274510978395 | -122.445488137723 | (37.7462745109784, -122.445488137723) | |||||
| 161192 | 161192 | 233957 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 15 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002524.54294 | 2096295.7854099998 | 37.7361719027113 | -122.43373135214199 | (37.7361719027113, -122.433731352142) | |||
| 79011 | 79011 | 108637 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 15 TUCKER AVE | Back Yard : Yard 13 | Tree 1 | Private 1 | 6011049.2 | 2088423.2 | 37.715035447895396 | -122.403704200211 | (37.7150354478954, -122.403704200211) | ||||||
| 143856 | 143856 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 150 CONRAD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 6001768.8 | 2096480.0 | 37.7366348009068 | -122.43635744032801 | (37.7366348009068, -122.436357440328) | ||||
| 63607 | 63607 | 191841 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 9 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 6015067.74656 | 2099262.4877299997 | 37.7450216201491 | -122.39057124226801 | (37.7450216201491, -122.390571242268) | ||||
| 71300 | 71300 | 191840 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | 6015034.2062 | 2099284.7294900003 | 37.7450808306162 | -122.39068877377701 | (37.7450808306162, -122.390688773777) | ||||
| 73581 | 73581 | 191844 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 27 | 6015247.82087 | 2099125.91751 | 37.7446566150196 | -122.38993903417 | (37.7446566150196, -122.38993903417) | ||||
| 172795 | 172795 | 191843 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 6015141.47385 | 2099207.7707599998 | 37.7448754686187 | -122.390312482158 | (37.7448754686187, -122.390312482158) | ||||
| 180957 | 180957 | 191842 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1501 Davidson Ave | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6015112.514169999 | 2099226.0983 | 37.744924185813396 | -122.390413900506 | (37.7449241858134, -122.390413900506) | ||||
| 82422 | 82422 | 113192 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 150X Museum Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | Permit Number 774288 | 6001029.7 | 2106463.5 | 37.7640050744287 | -122.439628320832 | (37.7640050744287, -122.439628320832) | |||
| 84714 | 84714 | 92484 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 85249 | 85249 | 92475 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 85668 | 85668 | 92476 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 88491 | 88491 | 92474 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 91344 | 91344 | 87564 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 104140 | 104140 | 92480 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 113154 | 113154 | 87562 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 128270 | 128270 | 92481 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 140175 | 140175 | 87563 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 145573 | 145573 | 92485 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 2887 | 2887 | 209188 | Undocumented 2 | Tree(s) :: 17 | 156 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994823.818630001 | 2098534.27999 | 37.7418782818471 | -122.46051787510599 | (37.7418782818471, -122.460517875106) | |
| 182862 | 182862 | 209187 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994832.7400400005 | 2098518.64338 | 37.7418358608449 | -122.460485895213 | (37.7418358608449, -122.460485895213) | |||
| 189024 | 189024 | 209189 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994812.38667 | 2098544.02713 | 37.7419043873887 | -122.460558108972 | (37.7419043873887, -122.460558108972) | |||
| 71556 | 71556 | 227504 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 16 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002174.41423 | 2096447.2518799999 | 37.7365679209746 | -122.434952717804 | (37.7365679209746, -122.434952717804) | |||
| 74942 | 74942 | 189463 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 22 | 6014124.78069 | 2095373.74732 | 37.7342915875929 | -122.393559763171 | (37.7342915875929, -122.393559763171) | ||||
| 134977 | 134977 | 189464 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6014119.82993 | 2095366.8489 | 37.7342723708559 | -122.39357639702699 | (37.7342723708559, -122.393576397027) | ||||
| 147650 | 147650 | 189462 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6014132.345380001 | 2095385.42746 | 37.7343240791916 | -122.393534426582 | (37.7343240791916, -122.393534426582) | ||||
| 27647 | 27647 | 223848 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000598.61266 | 2104296.68505 | 37.758030988052 | -122.44096386459299 | (37.758030988052, -122.440963864593) | |||
| 29662 | 29662 | 223849 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000601.16124 | 2104292.97169 | 37.7580209372281 | -122.440954784152 | (37.7580209372281, -122.440954784152) | |||
| 42552 | 42552 | 241129 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 163 Corwin St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000604.9463 | 2104285.57219 | 37.758000835587396 | -122.440941163018 | (37.7580008355874, -122.440941163018) | |||
| 132023 | 132023 | 223850 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000602.6654 | 2104289.54137 | 37.758011604077296 | -122.440949336057 | (37.7580116040773, -122.440949336057) | |||
| 160996 | 160996 | 223847 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000596.08551 | 2104301.4441 | 37.758043911304895 | -122.44097294593901 | (37.7580439113049, -122.440972945939) | |||
| 166702 | 166702 | 223846 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000593.0444 | 2104306.7365599996 | 37.7580582698975 | -122.440983843043 | (37.7580582698975, -122.440983843043) | |||
| 169264 | 169264 | 223845 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000588.980819999 | 2104313.3574 | 37.7580762176596 | -122.440998371578 | (37.7580762176596, -122.440998371578) | |||
| 4447 | 4447 | 253626 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1671 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5992125.0 | 2104081.0 | 37.756952512450205 | -122.47025325330601 | (37.7569525124502, -122.470253253306) | ||||
| 146046 | 146046 | 117273 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 17 PEREGO TER | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999542.0 | 2101494.0 | 37.7502752643571 | -122.444416651791 | (37.7502752643571, -122.444416651791) | |||||
| 171592 | 171592 | 223338 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 17 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.736120036118706 | -122.433668499417 | (37.7361200361187, -122.433668499417) | |||
| 27599 | 27599 | 232417 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 173 Everson St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6002718.41885 | 2097663.27226 | 37.7399377058635 | -122.433158722322 | (37.7399377058635, -122.433158722322) | ||||
| 114761 | 114761 | 112559 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1735x GRANT AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010373.0 | 2120454.0 | 37.8029470287696 | -122.40829930674299 | (37.8029470287696, -122.408299306743) | |||||
| 13301 | 13301 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 175 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998689.0 | 2104063.0 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | |||||
| 129259 | 129259 | 122558 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1760 Diamond St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x3 | 6001927.0 | 2098732.0 | 37.7428272563398 | -122.43597156823799 | (37.7428272563398, -122.435971568238) | |||
| 143647 | 143647 | 120560 | Significant Tree 6 | Grevillea robusta :: Silk Oak Tree 145 | 17X Castro St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002113.0 | 2108564.0 | 37.7698341292575 | -122.436031827668 | (37.7698341292575, -122.436031827668) | ||||
| 60877 | 60877 | 250194 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 0ft | 6011773.11718 | 2119954.14642 | 37.8016528548612 | -122.403418962409 | (37.8016528548612, -122.403418962409) | |||
| 75944 | 75944 | 242822 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 46 | Width 5ft | 6002178.85689 | 2096424.55585 | 37.7365058551638 | -122.434935735002 | (37.7365058551638, -122.434935735002) | |||
| 174189 | 174189 | 242821 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 37 | Width 5ft | 6002176.86514 | 2096431.6975599998 | 37.7365253515621 | -122.43494313191499 | (37.7365253515621, -122.434943131915) | |||
| 142812 | 142812 | 107493 | Significant Tree 6 | Tree(s) :: 17 | 180 BARTLETT ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | Permit Number 774017 | 6006657.2 | 2102756.7 | 37.7541457516772 | -122.419901368465 | (37.7541457516772, -122.419901368465) | ||
| 122667 | 122667 | 100169 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 180X Manchester St | Back Yard : Yard 13 | Tree 1 | DPW 2 | Adjacent to rear of property - DPW parcel | 6008242.0 | 2099158.0 | 37.7443536844995 | -122.414166136282 | (37.7443536844995, -122.414166136282) | |||||
| 2502 | 2502 | 253119 | Private 5 | Pinus radiata :: Monterey Pine 3 | 185 Belgrave Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 780239 | 5997636.85301 | 2104869.74588 | 37.759435335978296 | -122.45124816933 | (37.7594353359783, -122.45124816933) | ||||
| 113071 | 113071 | 108574 | Property Tree 7 | Tree(s) :: 17 | 1891 15th St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7x8 | 6004884.86016 | 2107160.4412599998 | 37.7661373754728 | -122.426344078904 | (37.7661373754728, -122.426344078904) | ||||
| 1626 | 1626 | 251635 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 18R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999176.0 | 2100050.0 | 37.746289501198795 | -122.445578473632 | (37.7462895011988, -122.445578473632) | |||||
| 183893 | 183893 | 240363 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 19 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002113.49716 | 2096265.44164 | 37.7360652530044 | -122.435150333941 | (37.7360652530044, -122.435150333941) | |||
| 30330 | 30330 | 233958 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 19 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002544.64531 | 2096274.1188599998 | 37.73611355200129 | -122.433660302082 | (37.7361135520013, -122.433660302082) | |||
| 114948 | 114948 | 113440 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 3x3 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | ||||
| 82720 | 82720 | 98465 | Property Tree 7 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | ||||||
| 79534 | 79534 | 121404 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1900 08th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 10x10 | 5993817.0 | 2102486.0 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | |||
| 81929 | 81929 | 98694 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 140306 | 140306 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 144229 | 144229 | 98696 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 2457 | 2457 | 253065 | Undocumented 2 | Private shrub :: Private Shrub 64 | 1x Drake St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6001423.0 | 2086924.0 | 37.710376533009295 | -122.436869130393 | (37.7103765330093, -122.436869130393) | ||||
| 53610 | 53610 | 104278 | Significant Tree 6 | Acacia spp :: Acacia Spp 176 | 2 Allston Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994445.1 | 2098202.2 | 37.7409446783355 | -122.461803277974 | (37.7409446783355, -122.461803277974) | |||||
| 91893 | 91893 | 107542 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 124990 | 124990 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 50796 | 50796 | 225251 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 20 Ohlone Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002182.75585 | 2096407.15248 | 37.736458290902796 | -122.43492101042 | (37.7364582909028, -122.43492101042) | |||
| 134638 | 134638 | 233923 | Undocumented 2 | Persea americana :: Avocado 113 | 20 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002185.25785 | 2096400.06868 | 37.736438982481395 | -122.43491185351299 | (37.7364389824814, -122.434911853513) | |||
| 126137 | 126137 | 105444 | Landmark tree 9 | Quercus agrifolia :: Coast Live Oak 180 | 20-28 ROSEMONT PL | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005075.5 | 2108088.5 | 37.768696376708895 | -122.425750755404 | (37.7686963767089, -122.425750755404) | |||||
| 427 | 427 | 251307 | Undocumented 2 | Tree(s) :: 17 | 200 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6016315.0 | 2096328.0 | 37.7370332293639 | -122.38605389871 | (37.7370332293639, -122.38605389871) | ||||
| 23421 | 23421 | 195972 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015355.8319 | 2100319.8042599997 | 37.7479407691514 | -122.389648918288 | (37.7479407691514, -122.389648918288) | |||
| 26205 | 26205 | 195969 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015417.97335 | 2100326.09336 | 37.7479614832509 | -122.389434473133 | (37.7479614832509, -122.389434473133) | ||||
| 31601 | 31601 | 195958 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 6015649.240619999 | 2100340.8983400003 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | ||||
| 33201 | 33201 | 195967 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 6015456.783980001 | 2100328.64296 | 37.747970635647 | -122.389300444473 | (37.747970635647, -122.389300444473) | ||||
| 33236 | 33236 | 195970 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 16 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 6015399.1088 | 2100325.42161 | 37.747958592828205 | -122.389499659601 | (37.7479585928282, -122.389499659601) | ||||
| 38334 | 38334 | 195966 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 6015475.98989 | 2100328.78152 | 37.7479720808553 | -122.389234040342 | (37.7479720808553, -122.389234040342) | ||||
| 38396 | 38396 | 195968 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 6015437.03514 | 2100327.8138099997 | 37.747967264084295 | -122.389368677829 | (37.7479672640843, -122.389368677829) |
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");