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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) |
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
68988 | 68988 | 190930 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015277.62058 | 2102029.1535 | 37.752629945825795 | -122.39003876447799 | (37.7526299458258, -122.390038764478) | |||
69219 | 69219 | 193379 | Undocumented 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 500 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 9ft | 6012632.72668 | 2105144.08354 | 37.7610358181789 | -122.39940398859699 | (37.7610358181789, -122.399403988597) | |||
69302 | 69302 | 222965 | Undocumented 2 | Corymbia maculata :: Spotted Gum 165 | 1201 San Jose Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 9ft | 6004149.63466 | 2095858.37478 | 37.7350629514011 | -122.428081582617 | (37.7350629514011, -122.428081582617) | |||
69873 | 69873 | 202066 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1 Hwy 101 S On Ramp | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012981.8772 | 2090193.58175 | 37.7200043379011 | -122.39714806353001 | (37.7200043379011, -122.39714806353) | |||
70006 | 70006 | 175852 | Undocumented 2 | Citrus aurantifolia 'Bearss' :: Seedless Lime 268 | 981 Delano Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 5998486.05845 | 2089261.9262299999 | 37.7166285851125 | -122.447187923197 | (37.7166285851125, -122.447187923197) | |||
70440 | 70440 | 194604 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 500 Wisconsin St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 9ft | 6012630.87805 | 2105129.76973 | 37.760996412581704 | -122.39940937733999 | (37.7609964125817, -122.39940937734) | |||
71415 | 71415 | 226675 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 127 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 9ft | 6005684.59904 | 2100199.28079 | 37.7470688251863 | -122.423083100303 | (37.7470688251863, -122.423083100303) | |||
71992 | 71992 | 192382 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 9ft | 6015926.910759999 | 2106504.64628 | 37.7649546850211 | -122.38810568434499 | (37.7649546850211, -122.388105684345) | |||
72093 | 72093 | 198060 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 820 Illinois St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6016003.71174 | 2105110.97053 | 37.761132205694295 | -122.387742798886 | (37.7611322056943, -122.387742798886) | |||
73184 | 73184 | 132229 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3599 Jackson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 9ft | 5997088.40366 | 2115983.62327 | 37.7899197346433 | -122.45394760361602 | (37.7899197346433, -122.453947603616) | |||
74510 | 74510 | 131861 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3640 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 9ft | 5998876.901959999 | 2121298.6839099997 | 37.8046158502946 | -122.448142451919 | (37.8046158502946, -122.448142451919) | |||
74523 | 74523 | 194587 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 37 Maddux Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 9ft | 6012781.54528 | 2095521.68187 | 37.7346230570026 | -122.398214166653 | (37.7346230570026, -122.398214166653) | |||
74607 | 74607 | 189822 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 601 15th St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 9ft | 6010499.44736 | 2107381.21521 | 37.767059343243105 | -122.40693979295901 | (37.7670593432431, -122.406939792959) | |||
74642 | 74642 | 119410 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 375 32nd Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 5985887.68292 | 2113265.4589 | 37.78180786995821 | -122.49250029292101 | (37.7818078699582, -122.492500292921) |
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");