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) |
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) |
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");