Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1524 | 1524 | 251544 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 863X Ocean Ave | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 5997430.0 | 2091537.0 | 37.722815009603295 | -122.451002133856 | (37.7228150096033, -122.451002133856) | |||||
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 53096 | 53096 | 125439 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 99 Collins St | 0 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | ||||
| 1573 | 1573 | 251597 | Landmark tree 9 | Ficus macrophylla :: Morton Bay Fig 148 | 1650 Valencia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6006336.0 | 2100501.0 | 37.747934015176504 | -122.42085202386299 | (37.7479340151765, -122.420852023863) | |||||
| 1817 | 1817 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Clayton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
| 1918 | 1918 | 251819 | DPW Maintained 3 | Acer macrophyllum :: Big Leaf Maple 159 | 298X Corbett Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | Permit Number 778898 | 5999572.0 | 2105342.0 | 37.7608426398345 | -122.444589445505 | (37.7608426398345, -122.444589445505) | |||
| 2610 | 2610 | 253145 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 801X Santiago St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5990274.0 | 2099728.0 | 37.7448931297685 | -122.47633667765699 | (37.7448931297685, -122.476336677657) | |||||
| 3257 | 3257 | 253379 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 3261 | 3261 | 253388 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 30 Grand View Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
| 3399 | 3399 | 251598 | Undocumented 2 | Tree(s) :: 17 | 900x Moraga St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 09/06/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780206 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | |
| 3586 | 3586 | 253468 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 801X Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | ||||||||||
| 5144 | 5144 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2 Garfield St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x2 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 9694 | 9694 | 173632 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3300X Market St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | ||||||||||
| 9916 | 9916 | 173733 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Richland Ave | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 3x3 | 6004601.0 | 2096122.0 | 37.7358123337564 | -122.426539816145 | (37.7358123337564, -122.426539816145) | ||||
| 13275 | 13275 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 875 El Camino Del Mar | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5985641.0 | 2114972.0 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | ||||
| 15743 | 15743 | 115724 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 250x Octavia St | 1 | Side Yard : Yard 17 | Tree 1 | Dept of Real Estate 5 | ||||||||||
| 23489 | 23489 | 247849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 152 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009118.007540001 | 2098230.0964599997 | 37.74185503078979 | -122.41107154552401 | (37.7418550307898, -122.411071545524) | ||||
| 25663 | 25663 | 188593 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010961.38996 | 2104652.9831 | 37.759594070921004 | -122.40514986509899 | (37.759594070921, -122.405149865099) | ||||
| 25721 | 25721 | 190755 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 1999 Revere Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6012974.9721800005 | 2095942.04055 | 37.7357880468688 | -122.397574892566 | (37.7357880468688, -122.397574892566) | ||||
| 26288 | 26288 | 247985 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 495 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009773.5395 | 2099699.6998799997 | 37.7459269802441 | -122.40890858338001 | (37.7459269802441, -122.40890858338) | ||||
| 26362 | 26362 | 196123 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2300 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 4ft | 6011242.42693 | 2104654.95461 | 37.7596151915071 | -122.404178032517 | (37.7596151915071, -122.404178032517) | |||
| 27802 | 27802 | 206466 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999436.63595 | 2095454.0058900001 | 37.733684872551606 | -122.444346998137 | (37.7336848725516, -122.444346998137) | ||||
| 28120 | 28120 | 178856 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 121 Delta St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6009824.00265 | 2088991.8165400003 | 37.71652823335621 | -122.407979098955 | (37.7165282333562, -122.407979098955) | ||||
| 28127 | 28127 | 191847 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2101 Newcomb Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 10ft | 6012411.60288 | 2097770.43241 | 37.7407770404189 | -122.39965102878901 | (37.7407770404189, -122.399651028789) | |||
| 29143 | 29143 | 248220 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007112.652530001 | 2099342.90806 | 37.7447979012027 | -122.41808429785499 | (37.7447979012027, -122.418084297855) | ||||
| 29637 | 29637 | 247866 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 398 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6009543.35492 | 2098406.93767 | 37.7423644418716 | -122.40961330563101 | (37.7423644418716, -122.409613305631) | ||||
| 29739 | 29739 | 187574 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010842.8913900005 | 2089488.5588 | 37.71794917929 | -122.404492242147 | (37.71794917929, -122.404492242147) | ||||
| 29793 | 29793 | 247852 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6009577.25002 | 2098193.0016099997 | 37.741778919360705 | -122.409481010838 | (37.7417789193607, -122.409481010838) | ||||
| 30657 | 30657 | 220393 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 20 Deming St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 3ft | 5999466.4358 | 2105239.81948 | 37.7605560532329 | -122.44494719845801 | (37.7605560532329, -122.444947198458) | |||
| 31310 | 31310 | 249769 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 295 Kearny St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6010840.59654 | 2120830.53405 | 37.8040070713206 | -122.40670772380399 | (37.8040070713206, -122.406707723804) | |||
| 31566 | 31566 | 179618 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 104 Burrows St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6011168.50385 | 2093508.14959 | 37.729004339277395 | -122.403649399324 | (37.7290043392774, -122.403649399324) | ||||
| 31588 | 31588 | 132395 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6006513.4872 | 2120932.40539 | 37.8040437321931 | -122.42168924196999 | (37.8040437321931, -122.42168924197) | ||||
| 32035 | 32035 | 247948 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6010393.64964 | 2098873.99577 | 37.7436944924075 | -122.406706137374 | (37.7436944924075, -122.406706137374) | ||||
| 33669 | 33669 | 247869 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009720.84865 | 2098403.35069 | 37.7423645372013 | -122.408999330354 | (37.7423645372013, -122.408999330354) | ||||
| 34240 | 34240 | 247903 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 582 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6009830.823 | 2098729.7061900003 | 37.743266798225605 | -122.40864208815701 | (37.7432667982256, -122.408642088157) | ||||
| 34864 | 34864 | 246661 | Undocumented 2 | Malus :: Crab Apple 235 | 3301 Harrison St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6009058.25509 | 2099385.89739 | 37.7450252552125 | -122.41135978362699 | (37.7450252552125, -122.411359783627) | |||
| 35045 | 35045 | 247843 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009097.48489 | 2098216.36998 | 37.7418161899782 | -122.411141537049 | (37.7418161899782, -122.411141537049) | ||||
| 37065 | 37065 | 190085 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1500 Rankin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6012534.55717 | 2096576.85892 | 37.7375065919613 | -122.399142135727 | (37.7375065919613, -122.399142135727) | ||||
| 37152 | 37152 | 207426 | Undocumented 2 | Dodonaea viscosa :: Hop Bush 132 | 404 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6000774.5178 | 2095253.0810900002 | 37.7332094216698 | -122.439707159174 | (37.7332094216698, -122.439707159174) | ||||
| 37251 | 37251 | 136604 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 2ft | 6002548.10466 | 2121650.0452 | 37.8057897776435 | -122.435463071378 | (37.8057897776435, -122.435463071378) | |||
| 39076 | 39076 | 123168 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 598 10th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5992809.72377 | 2111438.2053099996 | 37.7771930089585 | -122.468420491782 | (37.7771930089585, -122.468420491782) | ||||
| 39131 | 39131 | 234106 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 10 Crescent Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6005252.57338 | 2095904.2217 | 37.735251176793604 | -122.424271584978 | (37.7352511767936, -122.424271584978) | |||
| 40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
| 40945 | 40945 | 196597 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1251 20th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6014153.4442300005 | 2104763.78989 | 37.76007625593729 | -122.39411782218599 | (37.7600762559373, -122.394117822186) | ||||
| 41726 | 41726 | 247864 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 399 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6009555.15097 | 2098432.68764 | 37.742435806664794 | -122.409574335293 | (37.7424358066648, -122.409574335293) | ||||
| 41744 | 41744 | 248172 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 218 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6007302.01446 | 2098729.32454 | 37.74312379432521 | -122.41738604353701 | (37.7431237943252, -122.417386043537) | ||||
| 41940 | 41940 | 201704 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 42 Gilroy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | Width 0ft | 6015220.38125 | 2088614.2880799999 | 37.7157922695756 | -122.389300031678 | (37.7157922695756, -122.389300031678) | |||
| 42172 | 42172 | 247916 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 1098 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010216.5253800005 | 2098717.08126 | 37.743253727490504 | -122.407307533818 | (37.7432537274905, -122.407307533818) | ||||
| 43664 | 43664 | 120267 | Undocumented 2 | Cryptomeria japonica :: Japanese Cryptomeria 400 | 100 24th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988369.5187800005 | 2115107.91648 | 37.7870115292654 | -122.48404955627501 | (37.7870115292654, -122.484049556275) | ||||
| 45137 | 45137 | 248182 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 216 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6007496.06144 | 2098688.36246 | 37.743022237487004 | -122.41671217793899 | (37.743022237487, -122.416712177939) | ||||
| 45475 | 45475 | 187553 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 3960 Somerset St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6011370.897059999 | 2088323.0132400002 | 37.7147783208511 | -122.40258523064199 | (37.7147783208511, -122.402585230642) | ||||
| 46389 | 46389 | 248236 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 298 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6006718.26384 | 2099043.39902 | 37.743953311000396 | -122.419426777927 | (37.7439533110004, -122.419426777927) | ||||
| 46759 | 46759 | 187578 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 211 Elliot St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 38 | 6009088.83114 | 2088896.1901099999 | 37.7162244747635 | -122.410513477532 | (37.7162244747635, -122.410513477532) | ||||
| 47213 | 47213 | 180192 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Campbell Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6011017.70209 | 2088215.1538900002 | 37.714462435764105 | -122.40379844036 | (37.7144624357641, -122.40379844036) | ||||
| 48153 | 48153 | 209013 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6000780.48794 | 2095392.50815 | 37.7335925958074 | -122.439696511209 | (37.7335925958074, -122.439696511209) | ||||
| 48170 | 48170 | 240950 | Undocumented 2 | Salix babylonica :: Weeping Willow 182 | 4806 25th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6000018.52876 | 2101091.51792 | 37.7491973234931 | -122.44273989253401 | (37.7491973234931, -122.442739892534) | ||||
| 50991 | 50991 | 203317 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1515 16th Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 8ft | 5991175.14948 | 2105039.99944 | 37.759530710094296 | -122.47360811363899 | (37.7595307100943, -122.473608113639) | |||
| 51235 | 51235 | 201716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017085.9132900005 | 2095352.6498 | 37.7343977480421 | -122.38332060578001 | (37.7343977480421, -122.38332060578) | ||||
| 51302 | 51302 | 178077 | Undocumented 2 | Persea americana :: Avocado 113 | 1551 San Jose Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 3ft | 6001736.5287 | 2094206.7555099998 | 37.7303911613047 | -122.43630637554399 | (37.7303911613047, -122.436306375544) | |||
| 51586 | 51586 | 194761 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 900 Quint St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 3ft | 6014176.55403 | 2097659.59689 | 37.7405709356069 | -122.39354069034799 | (37.7405709356069, -122.393540690348) | |||
| 52473 | 52473 | 230427 | Undocumented 2 | Magnolia spp :: Magnolia 89 | 230 Coso Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6007601.41363 | 2099515.46986 | 37.74529921477939 | -122.416406470502 | (37.7452992147794, -122.416406470502) | ||||
| 52971 | 52971 | 126040 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2390 Bay St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 4ft | 5999373.78481 | 2120164.23699 | 37.801529357251205 | -122.446341287942 | (37.8015293572512, -122.446341287942) | |||
| 53529 | 53529 | 194560 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2045 19th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 5ft | 6011621.05801 | 2105090.22678 | 37.7608315011953 | -122.402899143494 | (37.7608315011953, -122.402899143494) | |||
| 53626 | 53626 | 175808 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6005234.38829 | 2091786.48978 | 37.7239437686747 | -122.42404172366001 | (37.7239437686747, -122.42404172366) | ||||
| 53803 | 53803 | 250309 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Redfield Aly | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | |||
| 54275 | 54275 | 197067 | Undocumented 2 | Pyrus spp :: Pear Tree 291 | 1700 Armstrong Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6013902.76145 | 2092874.5647599997 | 37.7274170025835 | -122.394152453295 | (37.7274170025835, -122.394152453295) | ||||
| 54460 | 54460 | 247886 | Undocumented 2 | Robinia pseudoacacia :: Black Locust 169 | 360 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009987.946719999 | 2098379.7354900003 | 37.7423146536018 | -122.408074116841 | (37.7423146536018, -122.408074116841) | ||||
| 54543 | 54543 | 187786 | Undocumented 2 | Acacia stenophylla :: Shoestring Acacia 109 | 1650 Galvez Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6015560.61147 | 2097934.79581 | 37.7414033822515 | -122.388774319486 | (37.7414033822515, -122.388774319486) | ||||
| 57193 | 57193 | 247001 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 401 Valley St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 8ft | 6003204.32988 | 2099186.4435 | 37.744147533977795 | -122.431587360294 | (37.7441475339778, -122.431587360294) | |||
| 58801 | 58801 | 247910 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 399 Franconia St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6009965.37797 | 2098759.5657599997 | 37.7433563212371 | -122.408178935533 | (37.7433563212371, -122.408178935533) | ||||
| 59193 | 59193 | 190149 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2399 Lane St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6013956.81212 | 2092846.6213599998 | 37.727343279763296 | -122.393963643334 | (37.7273432797633, -122.393963643334) | ||||
| 59496 | 59496 | 247995 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 344 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6009760.7197 | 2099297.4948 | 37.744821895131395 | -122.408924540052 | (37.7448218951314, -122.408924540052) | ||||
| 60035 | 60035 | 187570 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010859.73078 | 2089462.03095 | 37.7178772802949 | -122.404432169207 | (37.7178772802949, -122.404432169207) | ||||
| 60533 | 60533 | 250200 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 203 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 33 | Width 0ft | 6011776.4013 | 2119745.07747 | 37.8010789857668 | -122.403392881194 | (37.8010789857668, -122.403392881194) | |||
| 60867 | 60867 | 246724 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1501 Shotwell St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6008058.52794 | 2099329.47434 | 37.744814207710796 | -122.41481267936001 | (37.7448142077108, -122.41481267936) | ||||
| 62246 | 62246 | 247899 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 353 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010040.64075 | 2098391.36717 | 37.7423495418983 | -122.407892736173 | (37.7423495418983, -122.407892736173) | ||||
| 64078 | 64078 | 247873 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 388 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009888.01932 | 2098399.59712 | 37.7423635938187 | -122.40842103750299 | (37.7423635938187, -122.408421037503) | ||||
| 64418 | 64418 | 247823 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 3565 Folsom St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6008531.99478 | 2098373.38247 | 37.7422155824781 | -122.413107922691 | (37.7422155824781, -122.413107922691) | ||||
| 64471 | 64471 | 250154 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5999263.267440001 | 2117392.55411 | 37.793912744324395 | -122.446524204627 | (37.7939127443244, -122.446524204627) | ||||
| 64819 | 64819 | 246768 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 99 Waltham St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009274.77295 | 2098916.84453 | 37.7437494805599 | -122.410577984112 | (37.7437494805599, -122.410577984112) | ||||
| 65858 | 65858 | 204573 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 403 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 10ft | 6000740.47882 | 2095257.8114200002 | 37.7332204725414 | -122.439825179911 | (37.7332204725414, -122.439825179911) | |||
| 66577 | 66577 | 248067 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 20 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6010631.32823 | 2099397.64766 | 37.745145622269796 | -122.405921178544 | (37.7451456222698, -122.405921178544) | ||||
| 67603 | 67603 | 181293 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 184 Mount Vernon Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 5998992.1360599995 | 2089349.9308099998 | 37.7168991290824 | -122.44544499658998 | (37.7168991290824, -122.44544499659) | ||||
| 67773 | 67773 | 250220 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 312 Filbert St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 0ft | 6011282.86826 | 2120079.66018 | 37.8019700907042 | -122.405124300067 | (37.8019700907042, -122.405124300067) | |||
| 70123 | 70123 | 248111 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010383.711069999 | 2099443.8594400003 | 37.7452586580609 | -122.406780656096 | (37.7452586580609, -122.406780656096) | ||||
| 70451 | 70451 | 176394 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 148 Milton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6003833.54644 | 2094691.18415 | 37.731840220943205 | -122.42909121820801 | (37.7318402209432, -122.429091218208) | ||||
| 70986 | 70986 | 219958 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 802 Sanchez St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6003695.89154 | 2103514.18063 | 37.7560583368314 | -122.430196332992 | (37.7560583368314, -122.430196332992) | |||
| 72602 | 72602 | 187584 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 747 University St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6008737.4209199995 | 2090741.8815799998 | 37.721272650900396 | -122.411858473006 | (37.7212726509004, -122.411858473006) | ||||
| 73567 | 73567 | 177285 | Undocumented 2 | Magnolia champaca :: Champa 170 | 105 Burrows St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6011169.81083 | 2093473.6012799998 | 37.728909549831 | -122.403642451135 | (37.728909549831, -122.403642451135) | ||||
| 73968 | 73968 | 187552 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 2 Beeman Ln | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6012028.620569999 | 2088183.9402700001 | 37.7144331529482 | -122.400302089394 | (37.7144331529482, -122.400302089394) | ||||
| 73975 | 73975 | 247997 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 346 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009761.42839 | 2099270.1592099997 | 37.744746877282 | -122.40892016123199 | (37.744746877282, -122.408920161232) | ||||
| 74085 | 74085 | 218197 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399 Claremont Blvd | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 5993480.75094 | 2097837.1493599997 | 37.7398867790468 | -122.465111106706 | (37.7398867790468, -122.465111106706) | ||||
| 74843 | 74843 | 246640 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3350 Harrison St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009029.3215 | 2099227.55373 | 37.744588855582 | -122.411448646563 | (37.744588855582, -122.411448646563) | ||||
| 75996 | 75996 | 175203 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 655 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 52 | 6005189.8347 | 2092537.12043 | 37.7260023204239 | -122.424249099221 | (37.7260023204239, -122.424249099221) | ||||
| 76093 | 76093 | 248224 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 71 Fair Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6007158.82795 | 2099359.7804799997 | 37.7448468279249 | -122.41792582744199 | (37.7448468279249, -122.417925827442) | ||||
| 76682 | 76682 | 247868 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 397 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009691.8921300005 | 2098418.67435 | 37.7424049905119 | -122.40910053468599 | (37.7424049905119, -122.409100534686) | ||||
| 76994 | 76994 | 132433 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6008619.19252 | 2118974.8638 | 37.79878732612271 | -122.41426369452499 | (37.7987873261227, -122.414263694525) | ||||
| 78279 | 78279 | 117277 | Permitted Site 1 | Tree(s) :: 17 | 1745 Pacheco St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 06/01/2016 12:00:00 AM | 3 | Permit Number 778164 | 5989481.8 | 2101691.1 | 37.75023731196929 | -122.479219506966 | (37.7502373119693, -122.479219506966) | ||
| 86485 | 86485 | 122824 | Undocumented 2 | Pittosporum spp :: Pittosporum spp 128 | 407x Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6010366.0 | 2120356.0 | 37.8026775529699 | -122.40831661418899 | (37.8026775529699, -122.408316614189) | |||||
| 88155 | 88155 | 114671 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 85X Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775155 | 6010502.29579 | 2100335.12269 | 37.7477125069204 | -122.40643339757601 | (37.7477125069204, -122.406433397576) |
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");