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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37532 | 37532 | 247980 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 501 Peralta Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009795.98268 | 2099453.55621 | 37.745252380808296 | -122.408813614968 | (37.7452523808083, -122.408813614968) | ||||
37557 | 37557 | 178348 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 99 Bowdoin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 6008413.681059999 | 2094760.49373 | 37.732288735333796 | -122.413261587147 | (37.7322887353338, -122.413261587147) | ||||
37570 | 37570 | 246644 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009046.23893 | 2099176.02556 | 37.744448319452204 | -122.41138650967899 | (37.7444483194522, -122.411386509679) | ||||
37839 | 37839 | 239036 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 3911 21st St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6002387.68734 | 2103532.26119 | 37.75603379883479 | -122.43472182765801 | (37.7560337988348, -122.434721827658) | ||||
38374 | 38374 | 136055 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1114 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6007559.35658 | 2119902.6850400004 | 37.8012753005604 | -122.417996888269 | (37.8012753005604, -122.417996888269) | ||||
38549 | 38549 | 247912 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 399 Franconia St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009971.111830001 | 2098794.45901 | 37.7434524515605 | -122.408161569622 | (37.7434524515605, -122.408161569622) | ||||
38800 | 38800 | 248116 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6010379.57479 | 2099419.47211 | 37.745191464327995 | -122.406793240314 | (37.745191464328, -122.406793240314) | ||||
38844 | 38844 | 132391 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6006489.423769999 | 2120936.29447 | 37.8040530536607 | -122.421772791676 | (37.8040530536607, -122.421772791676) | ||||
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) | ||||
39135 | 39135 | 247897 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 351 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010077.88258 | 2098386.8429099997 | 37.7423392041858 | -122.407763645688 | (37.7423392041858, -122.407763645688) | ||||
39303 | 39303 | 118611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 349 Point Lobos Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5981718.6857199995 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | ||||
39341 | 39341 | 218152 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 22 Ashton Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5994167.21256 | 2090073.13732 | 37.71860825915 | -122.46217470241601 | (37.71860825915, -122.462174702416) | ||||
39519 | 39519 | 118599 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 5981986.20635 | 2112598.8818200002 | 37.7797487653148 | -122.50594791191901 | (37.7797487653148, -122.505947911919) | ||||
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) | ||||
40913 | 40913 | 211323 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 16th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5991179.3605 | 2105090.2513200003 | 37.759668932303796 | -122.47359721564399 | (37.7596689323038, -122.473597215644) | ||||
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) | ||||
41232 | 41232 | 194561 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 999 Kansas St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6011649.57806 | 2103809.7609599996 | 37.7573172186375 | -122.40271045314199 | (37.7573172186375, -122.402710453142) | ||||
41287 | 41287 | 205601 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 404 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6000770.98031 | 2095275.60302 | 37.7332710603101 | -122.43972100331699 | (37.7332710603101, -122.439721003317) | ||||
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) | ||||
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) | ||||
42630 | 42630 | 201727 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1411 Phelps St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6013753.9526 | 2095943.1082 | 37.7358343232928 | -122.394881707251 | (37.7358343232928, -122.394881707251) | ||||
43066 | 43066 | 195953 | Undocumented 2 | Populus alba :: White Poplar 408 | 1599 Rankin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6012519.43639 | 2096471.57125 | 37.737216651423296 | -122.39918702716999 | (37.7372166514233, -122.39918702717) | ||||
43430 | 43430 | 246655 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009062.9897 | 2099201.46712 | 37.7445191158731 | -122.411330385684 | (37.7445191158731, -122.411330385684) | ||||
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) | ||||
43726 | 43726 | 247881 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 387 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6009928.32781 | 2098399.30466 | 37.742365048010896 | -122.4082816417 | (37.7423650480109, -122.4082816417) | ||||
44107 | 44107 | 188705 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1998 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013030.362000001 | 2095929.4873 | 37.7357566623473 | -122.397382506903 | (37.7357566623473, -122.397382506903) | ||||
44131 | 44131 | 246656 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009063.73811 | 2099209.72554 | 37.744541833651205 | -122.411328381118 | (37.7445418336512, -122.411328381118) | ||||
44565 | 44565 | 201717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6017089.1408 | 2095350.86435 | 37.7343930239173 | -122.38330932287201 | (37.7343930239173, -122.383309322872) | ||||
44680 | 44680 | 247950 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 7 Joy St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6010415.94161 | 2098863.8955 | 37.7436680064781 | -122.406628345115 | (37.7436680064781, -122.406628345115) | ||||
44694 | 44694 | 132423 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6008817.55248 | 2118666.35728 | 37.7979513838133 | -122.41355547121401 | (37.7979513838133, -122.413555471214) | ||||
45007 | 45007 | 248046 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 38 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010555.404680001 | 2099417.48898 | 37.745195855721995 | -122.406185107956 | (37.745195855722, -122.406185107956) | ||||
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) | ||||
45814 | 45814 | 248245 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 296 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006801.134769999 | 2098995.22543 | 37.7438257043874 | -122.41913681222401 | (37.7438257043874, -122.419136812224) | ||||
45831 | 45831 | 246626 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3300 Harrison St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009022.37721 | 2099388.9393599997 | 37.7450315954447 | -122.411484058261 | (37.7450315954447, -122.411484058261) | ||||
45967 | 45967 | 209014 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6000787.79858 | 2095464.06576 | 37.733789492485 | -122.43967636459601 | (37.733789492485, -122.439676364596) | ||||
46194 | 46194 | 247925 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1098 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010304.27631 | 2098731.76841 | 37.743298966077795 | -122.407005147582 | (37.7432989660778, -122.407005147582) | ||||
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) | ||||
46422 | 46422 | 248058 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 17 Rutledge St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6010687.47782 | 2099346.1468700003 | 37.7450073524216 | -122.405723395139 | (37.7450073524216, -122.405723395139) | ||||
46620 | 46620 | 248114 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6010381.0463 | 2099434.05906 | 37.7452315992509 | -122.406789179902 | (37.7452315992509, -122.406789179902) | ||||
46734 | 46734 | 214372 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1500 16th Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5991179.13729 | 2105098.7165599996 | 37.759692162681 | -122.473598605112 | (37.759692162681, -122.473598605112) | ||||
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) | ||||
46954 | 46954 | 237909 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 3911 21st St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6002350.80679 | 2103530.36749 | 37.7560265053261 | -122.43484923730499 | (37.7560265053261, -122.434849237305) | ||||
47085 | 47085 | 218783 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 230 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998795.47023 | 2095343.3571900001 | 37.7333444548841 | -122.44655572948099 | (37.7333444548841, -122.446555729481) | ||||
47116 | 47116 | 206467 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5999430.1593 | 2095426.08584 | 37.7336078411342 | -122.44436738395099 | (37.7336078411342, -122.444367383951) | ||||
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) | ||||
47445 | 47445 | 248181 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 218 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6007478.19635 | 2098656.7324200002 | 37.7429343836221 | -122.41677171036999 | (37.7429343836221, -122.41677171037) | ||||
47461 | 47461 | 247844 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6009115.842759999 | 2098211.0441099997 | 37.7418025958075 | -122.41107768521002 | (37.7418025958075, -122.41107768521) | ||||
47514 | 47514 | 225238 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 3911 21st St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6002335.3278 | 2103527.7741799997 | 37.7560185058709 | -122.434902583282 | (37.7560185058709, -122.434902583282) | ||||
47540 | 47540 | 176072 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 653 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005100.84385 | 2092592.61654 | 37.7261496752474 | -122.42456068104299 | (37.7261496752474, -122.424560681043) | ||||
47741 | 47741 | 194278 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 22nd St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6012817.610719999 | 2103799.38432 | 37.7573538722899 | -122.398670182286 | (37.7573538722899, -122.398670182286) | ||||
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) | ||||
48330 | 48330 | 178340 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 72 La Grande Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6005229.68605 | 2091771.5142599999 | 37.7239023836832 | -122.424056914098 | (37.7239023836832, -122.424056914098) | ||||
48369 | 48369 | 179631 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 184 Mount Vernon Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998932.987869999 | 2089405.3609099998 | 37.7170479506817 | -122.445653426162 | (37.7170479506817, -122.445653426162) | ||||
48507 | 48507 | 118600 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 5981958.17368 | 2112601.6345 | 37.779754673268705 | -122.506045091658 | (37.7797546732687, -122.506045091658) | ||||
48633 | 48633 | 247854 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 80 Bradford St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6009576.04366 | 2098148.42798 | 37.74165646228621 | -122.409482036964 | (37.7416564622862, -122.409482036964) | ||||
48835 | 48835 | 246649 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009030.81997 | 2099159.0230900003 | 37.744400769587 | -122.411438624517 | (37.744400769587, -122.411438624517) | ||||
49102 | 49102 | 248109 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 138 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010416.26244 | 2099462.28287 | 37.7453110660681 | -122.406669396477 | (37.7453110660681, -122.406669396477) | ||||
49133 | 49133 | 247976 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 503 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009801.95016 | 2099270.17301 | 37.7447491849331 | -122.408780045086 | (37.7447491849331, -122.408780045086) | ||||
49584 | 49584 | 178353 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 648 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6005050.25442 | 2092601.27902 | 37.7261706033722 | -122.42473618194599 | (37.7261706033722, -122.424736181946) | ||||
49965 | 49965 | 114038 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2x Moffitt St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6002767.774130001 | 2096661.3136900002 | 37.737189358209704 | -122.43291650912201 | (37.7371893582097, -122.432916509122) | ||||
50293 | 50293 | 189299 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1750 22nd St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6012797.06573 | 2103802.01858 | 37.7573599607159 | -122.39874142030399 | (37.7573599607159, -122.398741420304) | ||||
50723 | 50723 | 199619 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2399 Lane St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6013984.3244 | 2092869.9258 | 37.727408798052295 | -122.393870163286 | (37.7274087980523, -122.393870163286) | ||||
51094 | 51094 | 201728 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6013736.51011 | 2095944.0047900002 | 37.7358358152635 | -122.394942076023 | (37.7358358152635, -122.394942076023) | ||||
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) | ||||
51296 | 51296 | 248062 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 18 Rutledge St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6010668.82651 | 2099388.20833 | 37.74512180102921 | -122.405790850563 | (37.7451218010292, -122.405790850563) | ||||
51760 | 51760 | 246643 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009035.26115 | 2099177.7888599997 | 37.7444525453606 | -122.41142459327601 | (37.7444525453606, -122.411424593276) | ||||
52032 | 52032 | 248226 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 71 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6007119.30754 | 2099366.9898200002 | 37.7448643988822 | -122.418062992935 | (37.7448643988822, -122.418062992935) | ||||
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) | ||||
52499 | 52499 | 248193 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 216 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6007342.31013 | 2098763.52222 | 37.74321996062879 | -122.417249134357 | (37.7432199606288, -122.417249134357) | ||||
52509 | 52509 | 177834 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6005075.62014 | 2092583.76802 | 37.7261239546294 | -122.424647248878 | (37.7261239546294, -122.424647248878) | ||||
53056 | 53056 | 248184 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 216 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 28 | 6007432.5204300005 | 2098714.89498 | 37.7430915158666 | -122.416933765486 | (37.7430915158666, -122.416933765486) | ||||
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) | ||||
53119 | 53119 | 175069 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011573.1556 | 2092162.2260200002 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | ||||
53325 | 53325 | 247883 | Undocumented 2 | Quercus rubra :: Red Oak 285 | 387 Mayflower St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009924.04752 | 2098397.97998 | 37.7423611710447 | -122.408296348302 | (37.7423611710447, -122.408296348302) | ||||
53365 | 53365 | 248061 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 18 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6010675.96291 | 2099385.23379 | 37.74511403267871 | -122.40576596453 | (37.7451140326787, -122.40576596453) | ||||
53472 | 53472 | 207987 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 19 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5999466.174219999 | 2095456.6543299998 | 37.7336938298041 | -122.444245066271 | (37.7336938298041, -122.444245066271) | ||||
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) | ||||
53743 | 53743 | 118598 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 249 Point Lobos Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 5982022.838269999 | 2112594.06181 | 37.7797376871414 | -122.50582083083799 | (37.7797376871414, -122.505820830838) | ||||
54010 | 54010 | 247872 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 388 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6009895.64631 | 2098398.03188 | 37.7423597231243 | -122.408394555183 | (37.7423597231243, -122.408394555183) | ||||
54011 | 54011 | 196056 | Undocumented 2 | Populus spp :: Poplar Spp 276 | 2399 Lane St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6013962.891369999 | 2092855.96285 | 37.7273692674706 | -122.39394328085599 | (37.7273692674706, -122.393943280856) | ||||
54128 | 54128 | 247978 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6009784.19004 | 2099413.44589 | 37.7451415861154 | -122.40885156275299 | (37.7451415861154, -122.408851562753) | ||||
54173 | 54173 | 248064 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 18 Rutledge St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010656.53215 | 2099389.02438 | 37.7451233541731 | -122.40583342000099 | (37.7451233541731, -122.405833420001) | ||||
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) | ||||
54470 | 54470 | 248222 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 70 Fair Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6007138.69589 | 2099332.0409999997 | 37.7447695284905 | -122.41799347441601 | (37.7447695284905, -122.417993474416) | ||||
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) | ||||
54571 | 54571 | 211276 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 49 | 5998791.497719999 | 2095472.56851 | 37.7336990117025 | -122.446578756609 | (37.7336990117025, -122.446578756609) | ||||
54920 | 54920 | 248118 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Brewster St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010376.970919999 | 2099406.95495 | 37.7451569492381 | -122.40680136209 | (37.7451569492381, -122.40680136209) | ||||
55107 | 55107 | 208887 | Undocumented 2 | Malus :: Crab Apple 235 | 747 Detroit St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999422.56432 | 2095411.3960400003 | 37.733567073059895 | -122.44439258657302 | (37.7335670730599, -122.444392586573) | ||||
55110 | 55110 | 132432 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Green St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6008616.66785 | 2118981.63248 | 37.7988057694225 | -122.41427290988999 | (37.7988057694225, -122.41427290989) | ||||
55847 | 55847 | 201720 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Hawkins Ln | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6017109.38533 | 2095355.2358400002 | 37.734406145933704 | -122.383239634411 | (37.7344061459337, -122.383239634411) | ||||
56013 | 56013 | 248173 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 218 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6007303.951309999 | 2098726.55555 | 37.743116300271 | -122.41737915022101 | (37.743116300271, -122.417379150221) | ||||
56158 | 56158 | 247931 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010377.81236 | 2098773.8118 | 37.7434185228518 | -122.406753840137 | (37.7434185228518, -122.406753840137) | ||||
56715 | 56715 | 207986 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999466.52885 | 2095410.65053 | 37.733567534417794 | -122.444240535497 | (37.7335675344178, -122.444240535497) | ||||
56892 | 56892 | 248221 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6007127.43713 | 2099336.46972 | 37.744781055094705 | -122.418032719051 | (37.7447810550947, -122.418032719051) | ||||
57021 | 57021 | 230426 | Undocumented 2 | Magnolia spp :: Magnolia 89 | 230 Coso Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6007649.023990001 | 2099489.86888 | 37.745231597464795 | -122.416240028469 | (37.7452315974648, -122.416240028469) | ||||
57450 | 57450 | 247885 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 387 Mayflower St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6009895.877069999 | 2098407.02536 | 37.7423844301873 | -122.408394391499 | (37.7423844301873, -122.408394391499) |
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");