Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by PlotSize descending

✎ View and edit SQL

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
109285 109285 98270 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 990X York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/2012 12:00:00 AM   witin landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.40858435969801 (37.7562208239384, -122.408584359698)
106640 106640 98271 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 990X York St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.40858435969801 (37.7562208239384, -122.408584359698)
107595 107595 98272 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 990X York St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.40858435969801 (37.7562208239384, -122.408584359698)
118014 118014 98273 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 990X York St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.40858435969801 (37.7562208239384, -122.408584359698)
79389 79389 98269 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 2700 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/2012 12:00:00 AM   within landscape plot Permit Number 768491 6009963.0 2103401.0 37.7561005415225 -122.40851449565001 (37.7561005415225, -122.40851449565)
125626 125626 49691 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 450 Stanyan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/2003 12:00:00 AM   tx5 Permit Number 46512 5996840.32777146 2110125.42661407 37.7738204478349 -122.45438257610901 (37.7738204478349, -122.454382576109)
81756 81756 97781 Undocumented 2 Eucalyptus Spp :: Eucalyptus 40 249 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 strip   5992441.6 2097612.4 37.7392096976829 -122.468687674985 (37.7392096976829, -122.468687674985)
113240 113240 67948 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 491 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/1993 12:00:00 AM 6 ex3 Permit Number 31662 5988736.13806 2111981.42447 37.778448401356705 -122.48255196765498 (37.7784484013567, -122.482551967655)
869 869 124177 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 8X Almaden Ct 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2     10 Width 9ft   5995876.0 2112606.0 37.7805760973259 -122.457897862346 (37.7805760973259, -122.457897862346)
3018 3018 128709 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 4x Columbus Ave 1 Median : Yard 3 Tree 1 Private 1     19 Width 9ft   6011726.08303 2117794.9108 37.795721488711294 -122.403429729102 (37.7957214887113, -122.403429729102)
23844 23844 192384 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500 Illinois St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 9ft   6015929.33713 2106466.90045 37.7648511775542 -122.38809465775 (37.7648511775542, -122.38809465775)
24061 24061 190934 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1101 25th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 9ft   6015168.60212 2102024.17667 37.752610233591206 -122.390415424833 (37.7526102335912, -122.390415424833)
24308 24308 190929 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1101 25th St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 9ft   6015301.73602 2102030.54675 37.752635108841 -122.389955465678 (37.752635108841, -122.389955465678)
25864 25864 211289 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 100x Idora Ave 8 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   5995366.53481 2099407.6063200003 37.744307426259205 -122.45870456127399 (37.7443074262592, -122.458704561274)
26492 26492 242374 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   6006546.0037 2109148.1970900004 37.771689039651896 -122.42073962714899 (37.7716890396519, -122.420739627149)
26568 26568 124644 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 20 Arguello Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 9ft   5995537.35644 2115745.75128 37.7891775496077 -122.459296819974 (37.7891775496077, -122.459296819974)
27451 27451 232290 Undocumented 2 Myoporum laetum :: Myoporum 1 1100 San Jose Ave 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 9ft   6004782.10663 2096684.4357 37.737366892177704 -122.425953683239 (37.7373668921777, -122.425953683239)
27503 27503 208879 DPW Maintained 3 Malus :: Crab Apple 235 100x Idora Ave 19 Median : Yard 3 Tree 1 DPW 2     7 Width 9ft   5995727.40355 2099320.3409700003 37.74408855195821 -122.457450449475 (37.7440885519582, -122.457450449475)
28868 28868 208175 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1000x Lawton St 3 Median : Yard 3 Tree 1 DPW 2     1 Width 9ft   5991060.8036 2104516.28775 37.758086113802904 -122.473965364836 (37.7580861138029, -122.473965364836)
30071 30071 228915 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 902 Duboce Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 9ft   6002590.6451900005 2108266.76384 37.76904511557 -122.434358412533 (37.76904511557, -122.434358412533)
31220 31220 119409 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 375 32nd Ave 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 9ft   5985886.66593 2113283.98808 37.781858686295294 -122.492505176161 (37.7818586862953, -122.492505176161)
31416 31416 198059 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 820 Illinois St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6016002.244 2105125.97833 37.7611733325983 -122.387748922377 (37.7611733325983, -122.387748922377)
31464 31464 123190 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 575 09th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 9ft   5993120.96689 2111576.90099 37.7775918025948 -122.46735389958401 (37.7775918025948, -122.467353899584)
32072 32072 126075 Undocumented 2 Cordyline australis :: Dracena Palm 141 280 Euclid Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 9ft   5997922.81564 2113961.32913 37.7844148567072 -122.450914744323 (37.7844148567072, -122.450914744323)
32242 32242 126072 Undocumented 2 Cordyline australis :: Dracena Palm 141 280 Euclid Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 9ft   5997944.17854 2113963.60849 37.78442233817079 -122.45084100083099 (37.7844223381708, -122.450841000831)
33100 33100 198058 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 820 Illinois St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6016003.50284 2105138.76714 37.7612085176665 -122.387745460881 (37.7612085176665, -122.387745460881)
33605 33605 227093 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 31 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 9ft   6009184.481319999 2095791.0539799999 37.7351616771725 -122.41066949551201 (37.7351616771725, -122.410669495512)
35624 35624 188036 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 766 De Haro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 9ft   6012093.47908 2104828.68967 37.760139746259796 -122.401246859578 (37.7601397462598, -122.401246859578)
35891 35891 125523 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 220 Lombard St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 9ft   6011207.16585 2120734.5295700002 37.8037639692824 -122.40543241409401 (37.8037639692824, -122.405432414094)
35930 35930 194083 Undocumented 2 Myoporum laetum :: Myoporum 1 495 Barneveld Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 9ft   6011094.10915 2097586.53301 37.74019856231661 -122.40419351074199 (37.7401985623166, -122.404193510742)
36320 36320 212934 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1964 17th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 9ft   5990996.330519999 2102040.26003 37.751283858566104 -122.47400768869801 (37.7512838585661, -122.474007688698)
36940 36940 233930 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 451 Florida St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38 Width 9ft   6009251.7265800005 2106253.20346 37.763892184592706 -122.41117579493 (37.7638921845927, -122.41117579493)
37375 37375 211161 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Idora Ave 17 Median : Yard 3 Tree 1 DPW 2     41 Width 9ft   5995684.4738300005 2099331.0800900003 37.7441155729727 -122.45759966680599 (37.7441155729727, -122.457599666806)
37627 37627 199566 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1512 25th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 9ft   6014108.69485 2102017.7502599997 37.7525337354666 -122.39408034653799 (37.7525337354666, -122.394080346538)
37851 37851 226637 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1199 Capp St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 9ft   6007225.3101699995 2100622.72822 37.7483183396245 -122.417785447755 (37.7483183396245, -122.417785447755)
38163 38163 194192 Undocumented 2 Olea europaea :: Olive Tree 41 1601 Kansas St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 9ft   6011834.442419999 2100473.73914 37.748167551187 -122.401836621487 (37.748167551187, -122.401836621487)
38489 38489 214330 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 12 Median : Yard 3 Tree 1 DPW 2     10 Width 9ft   5995527.4625 2099368.48178 37.7442092481691 -122.458145280077 (37.7442092481691, -122.458145280077)
39187 39187 178946 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 25 Madison St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 9ft   6005433.25 2093389.63985 37.7283568930528 -122.42346820799 (37.7283568930528, -122.42346820799)
39359 39359 192974 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Arkansas St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6012869.163480001 2105974.38729 37.763328824083295 -122.39864451922399 (37.7633288240833, -122.398644519224)
39465 39465 189705 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 500 Wisconsin St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 9ft   6012637.736959999 2105122.26077 37.7609761769225 -122.39938512804399 (37.7609761769225, -122.399385128044)
39479 39479 234374 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 581 Dolores St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 9ft   6004996.87402 2105008.5457599997 37.760235113069896 -122.425803460464 (37.7602351130699, -122.425803460464)
40024 40024 225850 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 58 Liberty St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 9ft   6005957.80102 2104057.14664 37.7576770490776 -122.42241246056001 (37.7576770490776, -122.42241246056)
40573 40573 194605 Undocumented 2 Pittosporum tobira :: Japanese Mockorange 243 601 Carolina St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 9ft   6012419.56999 2105123.3254299997 37.7609669381886 -122.40013975184401 (37.7609669381886, -122.400139751844)
41035 41035 189987 Undocumented 2 Cercis occidentalis :: Western Redbud 246 2001 Revere Ave 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6012597.96632 2096223.24019 37.736539162453 -122.398898087577 (37.736539162453, -122.398898087577)
41430 41430 192969 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Arkansas St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6012874.930240001 2105836.14542 37.7629495637933 -122.398614872189 (37.7629495637933, -122.398614872189)
42737 42737 239675 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 689 Dolores St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 9ft   6005030.3991 2104342.90235 37.7584093076526 -122.425640136401 (37.7584093076526, -122.425640136401)
43046 43046 201567 Undocumented 2 Pinus radiata :: Monterey Pine 3 799 Jerrold Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 9ft   6019712.532430001 2093705.4483299998 37.730019658579295 -122.37412535530899 (37.7300196585793, -122.374125355309)
43162 43162 123191 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 571 09th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 9ft   5993121.2243 2111602.66813 37.777662567064205 -122.467354883235 (37.7776625670642, -122.467354883235)
44924 44924 217728 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 100x Lincoln Way 3 Median : Yard 3 Tree 1 DPW 2     10 Width 9ft   5995225.13962 2107407.04812 37.766263730121004 -122.45977279128901 (37.766263730121, -122.459772791289)
46015 46015 124181 Undocumented 2 Araucaria araucana :: Monkey puzzle 154 18 Almaden Ct 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   5995866.538240001 2112606.8415599996 37.780577864424295 -122.457930655785 (37.7805778644243, -122.457930655785)
46155 46155 189816 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 15th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 9ft   6010379.86715 2107373.23208 37.767030731308104 -122.40735284165702 (37.7670307313081, -122.407352841657)
46834 46834 189823 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 15th St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 9ft   6010524.410519999 2107382.85181 37.767065233807 -122.40685356416 (37.767065233807, -122.40685356416)
47117 47117 191814 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1301 Iowa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 9ft   6014800.46205 2101999.0803099996 37.752520895829704 -122.391686773025 (37.7525208958297, -122.391686773025)
48991 48991 225846 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 44 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 9ft   6006029.75247 2104062.03373 37.7576945264884 -122.422163969788 (37.7576945264884, -122.422163969788)
49610 49610 131039 Undocumented 2 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 3001 Divisadero St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 9ft   6000465.59076 2118697.11067 37.79756331373971 -122.442457765333 (37.7975633137397, -122.442457765333)
50425 50425 175713 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 637 Hamilton St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 9ft   6009802.3378800005 2091425.9949299998 37.7232107699499 -122.40822556625099 (37.7232107699499, -122.408225566251)
50547 50547 211162 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Idora Ave 21 Median : Yard 3 Tree 1 DPW 2     2 Width 9ft   5995762.15632 2099312.39681 37.744068735376295 -122.457329708294 (37.7440687353763, -122.457329708294)
50700 50700 192970 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Arkansas St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6012874.88445 2105863.7088900004 37.763025244431894 -122.398616964909 (37.7630252444319, -122.398616964909)
51030 51030 192383 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500 Illinois St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 9ft   6015928.566269999 2106487.94693 37.7649089239349 -122.38809879283501 (37.7649089239349, -122.388098792835)
51364 51364 214329 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 11 Median : Yard 3 Tree 1 DPW 2     11 Width 9ft   5995487.46893 2099377.84768 37.744232666505106 -122.45828424602301 (37.7442326665051, -122.458284246023)
51904 51904 125891 Undocumented 2 Calocedrus decurrens :: Incense Cedar 177 3001 Divisadero St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 9ft   6000478.83017 2118614.89434 37.7973383240724 -122.442406047996 (37.7973383240724, -122.442406047996)
52121 52121 124178 Undocumented 2 Pinus thunbergii :: Japanese Black Pine 306 8X Almaden Ct 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   5995876.0 2112606.0 37.7805760973259 -122.457897862346 (37.7805760973259, -122.457897862346)
52437 52437 232289 Undocumented 2 Myoporum laetum :: Myoporum 1 0 San Jose Av Off Ramp 4 Front Yard : Yard 7 Tree 1 Private 1     16 Width 9ft   6002953.30911 2095259.2744599998 37.7333502006365 -122.43217493415301 (37.7333502006365, -122.432174934153)
52802 52802 194602 Undocumented 2 Pittosporum tobira :: Japanese Mockorange 243 500 Wisconsin St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 9ft   6012630.51831 2105140.83146 37.7610267655993 -122.39941139812599 (37.7610267655993, -122.399411398126)
55435 55435 131324 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 400 Cherry St 14 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 9ft   5996252.06992 2114879.22587 37.7868393686989 -122.456761319676 (37.7868393686989, -122.456761319676)
55532 55532 194655 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 637 Carolina St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 9ft   6012415.8477300005 2104999.11852 37.7606256859357 -122.40014390223601 (37.7606256859357, -122.400143902236)
56159 56159 136657 Undocumented 2 Taxus baccata :: Irish Yew 241 1725 North Point St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 9ft   6002469.52976 2120880.32815 37.8036718751301 -122.435679888015 (37.8036718751301, -122.435679888015)
56393 56393 232297 Undocumented 2 Myoporum laetum :: Myoporum 1 301 Putnam St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 9ft   6009073.4894199995 2095823.27697 37.73524393096471 -122.411055511504 (37.7352439309647, -122.411055511504)
56547 56547 129893 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 400 Cherry St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 9ft   5996283.0892 2114624.04425 37.78614048933979 -122.45663553961701 (37.7861404893398, -122.456635539617)
57046 57046 202062 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1 Hwy 101 S On Ramp 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 9ft   6012907.59941 2090167.98565 37.7199299208095 -122.397403024054 (37.7199299208095, -122.397403024054)
57260 57260 242793 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2x Coso Ave 1 Median : Yard 3 Tree 1 DPW 2     30 Width 9ft   6007083.58829 2099965.0449 37.746504513177 -122.418228897148 (37.746504513177, -122.418228897148)
57475 57475 192380 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500 Illinois St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 9ft   6015923.02581 2106586.6192099997 37.7651795497335 -122.388124842588 (37.7651795497335, -122.388124842588)
57651 57651 189821 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 15th St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 9ft   6010484.40346 2107380.66629 37.7670569942101 -122.406991789056 (37.7670569942101, -122.406991789056)
57723 57723 177584 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 414 Desmond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 9ft   6010519.18521 2086688.0468099997 37.7102414461649 -122.40541404002701 (37.7102414461649, -122.405414040027)
58167 58167 201927 Undocumented 2 Citrus spp :: Lemon: Orange: Lime 278 118 Elmira St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 9ft   6011149.33758 2096046.2397099999 37.735972330566 -122.403894190267 (37.735972330566, -122.403894190267)
59450 59450 196470 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950 Newcomb Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 9ft   6013295.589480001 2097174.20298 37.7391891560441 -122.39655273032899 (37.7391891560441, -122.396552730329)
59728 59728 244843 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 90 Bartlett St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 9ft   6006632.98295 2103729.04135 37.7568142125173 -122.4200541162 (37.7568142125173, -122.4200541162)
59764 59764 132675 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1 Heather Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 9ft   5997331.41397 2114381.51283 37.7855346961081 -122.45299111975201 (37.7855346961081, -122.452991119752)
59919 59919 189983 Undocumented 2 Cercis occidentalis :: Western Redbud 246 2001 Revere Ave 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6012461.23167 2096321.12771 37.7368003210833 -122.399377710436 (37.7368003210833, -122.399377710436)
60126 60126 205301 DPW Maintained 3 Cordyline australis :: Dracena Palm 141 100x Idora Ave 16 Median : Yard 3 Tree 1 DPW 2     6 Width 9ft   5995644.80929 2099340.4392 37.7441389922109 -122.45773749420799 (37.7441389922109, -122.457737494208)
60935 60935 228916 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 902 Duboce Ave 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 9ft   6002616.34038 2108266.2326700003 37.76904511557179 -122.434269496565 (37.7690451155718, -122.434269496565)
61235 61235 232868 Undocumented 2 Olea europaea :: Olive Tree 41 301 Putnam St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 9ft   6009077.45417 2095862.97856 37.735353165298 -122.41104460722401 (37.735353165298, -122.411044607224)
61472 61472 189819 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 15th St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 9ft   6010449.36204 2107378.3567 37.7670486916722 -122.407112829708 (37.7670486916722, -122.407112829708)
62135 62135 193516 Undocumented 2 Maytenus boaria :: Mayten 22 1600 Bay Shore Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 9ft   6011933.86087 2091488.8209799998 37.723502402108004 -122.400861670948 (37.723502402108, -122.400861670948)
62382 62382 199579 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 2212 25th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 9ft   6012144.74308 2101906.79924 37.7521197361546 -122.400864273582 (37.7521197361546, -122.400864273582)
62711 62711 203188 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 2212 25th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 9ft   6012161.98551 2101908.2137 37.752124581703896 -122.400804745651 (37.7521245817039, -122.400804745651)
63875 63875 189985 Undocumented 2 Cercis occidentalis :: Western Redbud 246 2001 Revere Ave 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6012486.98266 2096301.3562200002 37.7367474679233 -122.399287289877 (37.7367474679233, -122.399287289877)
64244 64244 192381 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500 Illinois St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 9ft   6015923.36734 2106564.05052 37.7651175999097 -122.38812208619 (37.7651175999097, -122.38812208619)
64296 64296 126068 Undocumented 2 Cordyline australis :: Dracena Palm 141 280 Euclid Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 9ft   5997967.67549 2113970.59524 37.7844428670011 -122.45076021380699 (37.7844428670011, -122.450760213807)
64753 64753 233931 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 451 Florida St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 9ft   6009251.45318 2106264.05651 37.763921969247704 -122.411177507234 (37.7639219692477, -122.411177507234)
65275 65275 189981 Undocumented 2 Cercis occidentalis :: Western Redbud 246 2001 Revere Ave 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6012438.4082 2096335.74445 37.7368391834845 -122.399457647549 (37.7368391834845, -122.399457647549)
65503 65503 193622 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 602 Arthur Ave 43 Front Yard : Yard 7 Tree 1 Private 1     13 Width 9ft   6015925.13403 2099837.38031 37.746647684362394 -122.387646625393 (37.7466476843624, -122.387646625393)
65522 65522 205300 DPW Maintained 3 Cordyline australis :: Dracena Palm 141 100x Idora Ave 15 Median : Yard 3 Tree 1 DPW 2     6 Width 9ft   5995637.606269999 2099342.55805 37.7441443962476 -122.457762553794 (37.7441443962476, -122.457762553794)
65963 65963 232871 Undocumented 2 Olea europaea :: Olive Tree 41 301 Putnam St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 9ft   6009080.3789099995 2095903.22512 37.7354638376772 -122.411037337111 (37.7354638376772, -122.411037337111)
65989 65989 192965 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Arkansas St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6012881.021480001 2105727.71881 37.7626521876609 -122.39858619552 (37.7626521876609, -122.39858619552)
66177 66177 131322 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 400 Cherry St 11 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 9ft   5996256.90517 2114854.47123 37.786771676724 -122.45674279995501 (37.786771676724, -122.456742799955)
66549 66549 126069 Undocumented 2 Cordyline australis :: Dracena Palm 141 280 Euclid Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 9ft   5997966.0697099995 2113969.8681799998 37.7844407787666 -122.45076571678699 (37.7844407787666, -122.450765716787)
66694 66694 225148 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1199 Capp St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 9ft   6007231.69522 2100624.49408 37.7483235475968 -122.417763493512 (37.7483235475968, -122.417763493512)
67961 67961 206836 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100x Idora Ave 14 Median : Yard 3 Tree 1 DPW 2     66 Width 9ft   5995604.17085 2099350.4744700002 37.7441642119029 -122.45787873812799 (37.7441642119029, -122.457878738128)
68670 68670 189288 Undocumented 2 Cordyline australis :: Dracena Palm 141 301 Pennsylvania Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 9ft   6014362.47484 2105695.4983200002 37.76264614062129 -122.393460085018 (37.7626461406213, -122.393460085018)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 3177.425ms · Data source: data.sfgov.org