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
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)
73631 73631 211163 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Idora Ave 24 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   5995808.0564 2099301.9235400003 37.744042614569295 -122.45717023961001 (37.7440426145693, -122.45717023961)
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)
74696 74696 192973 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Arkansas St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6012869.52448 2105946.64842 37.7632526794011 -122.39864132394301 (37.7632526794011, -122.398641323943)
74742 74742 193451 Undocumented 2 Malus :: Crab Apple 235 760 De Haro St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 9ft   6012093.60455 2104911.13829 37.7603661389049 -122.401252219518 (37.7603661389049, -122.401252219518)
75383 75383 125524 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 220 Lombard St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 9ft   6011207.6846199995 2120726.9389400003 37.8037431562814 -122.40543008395201 (37.8037431562814, -122.405430083952)
76465 76465 126074 Undocumented 2 Cordyline australis :: Dracena Palm 141 280 Euclid Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 9ft   5997931.91034 2113961.1395099997 37.7844148567016 -122.450883266276 (37.7844148567016, -122.450883266276)
76839 76839 210860 Undocumented 2 Olea europaea :: Olive Tree 41 458 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   5998392.85645 2095276.6341799998 37.7331382439186 -122.447942868994 (37.7331382439186, -122.447942868994)
77277 77277 118638 Undocumented 2 Ilex spp :: Holly Species 163 489 45th Ave 1 Front Yard : Yard 7 Tree 1 Private 1     2 Width 9ft   5981883.80409 2112496.71277 37.779462211155 -122.506294581666 (37.779462211155, -122.506294581666)
93610 93610 192378 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500 Illinois St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 9ft   6015920.68395 2106620.6403200002 37.765272834597894 -122.388135317012 (37.7652728345979, -122.388135317012)
115432 115432 210682 DPW Maintained 3 Olea europaea :: Olive Tree 41 100x Idora Ave 6 Median : Yard 3 Tree 1 DPW 2     15 Width 9ft   5995339.29404 2099412.4410200003 37.7443191354124 -122.4587991034 (37.7443191354124, -122.4587991034)
129709 129709 131323 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 400 Cherry St 12 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     13 Width 9ft   5996254.50366 2114867.62545 37.7868076567964 -122.456752060266 (37.7868076567964, -122.456752060266)
131686 131686 190788 Undocumented 2 Juniperus chinensis :: Juniper 19 1701 19th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 9ft   6012435.911169999 2105136.5588700003 37.7610041854195 -122.400084163877 (37.7610041854195, -122.400084163877)
132787 132787 202063 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1 Hwy 101 S On Ramp 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 9ft   6012938.96015 2090178.7208200002 37.7199611434755 -122.3972953725 (37.7199611434755, -122.3972953725)
132813 132813 201611 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 98 Jerrold Ave 1 Side Yard : Yard 17 Tree 1 Private 1     2 Width 9ft   6020793.34161 2092957.5019 37.7280253184122 -122.37033713297501 (37.7280253184122, -122.370337132975)
133930 133930 198057 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 820 Illinois St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6015999.46733 2105182.54146 37.7613284890375 -122.38776247247499 (37.7613284890375, -122.387762472475)
134543 134543 189984 Undocumented 2 Cercis occidentalis :: Western Redbud 246 2001 Revere Ave 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6012475.97844 2096310.0717099998 37.73677078553071 -122.39932594815599 (37.7367707855307, -122.399325948156)
134715 134715 211077 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 100x Idora Ave 9 Median : Yard 3 Tree 1 DPW 2     9 Width 9ft   5995433.6180300005 2099390.76131 37.7442650295015 -122.45847138416799 (37.7442650295015, -122.458471384168)
134932 134932 202258 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 1 Kalmanovitz St 50 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 9ft   6013221.11687 2093370.23706 37.7287401067524 -122.396543647186 (37.7287401067524, -122.396543647186)
135950 135950 192385 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500 Illinois St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 9ft   6015934.883119999 2106386.4235799997 37.7646305127095 -122.388069858948 (37.7646305127095, -122.388069858948)
136941 136941 211477 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 100x Idora Ave 10 Median : Yard 3 Tree 1 DPW 2     37 Width 9ft   5995466.33774 2099382.46662 37.7442441346666 -122.45835764690001 (37.7442441346666, -122.4583576469)
137327 137327 214332 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 18 Median : Yard 3 Tree 1 DPW 2     9 Width 9ft   5995718.21124 2099321.8453599997 37.7440921546362 -122.457482343055 (37.7440921546362, -122.457482343055)
137366 137366 225845 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 38 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 9ft   6006048.77626 2104063.35692 37.7576992326564 -122.42209827161301 (37.7576992326564, -122.422098271613)
138133 138133 202067 Undocumented 2 Ficus carica :: Edible Fig 201 1 Hwy 101 S On Ramp 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 9ft   6013024.681059999 2090205.86512 37.720040448378704 -122.397000965021 (37.7200404483787, -122.397000965021)
146356 146356 199366 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300x Division St 5 Median : Yard 3 Tree 1 DPW 2     28 Width 9ft   6009946.07759 2108167.65587 37.769187748042704 -122.40890931543801 (37.7691877480427, -122.408909315438)
146780 146780 214408 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 100x Idora Ave 20 Median : Yard 3 Tree 1 DPW 2     3 Width 9ft   5995751.653580001 2099314.25679 37.7440732391823 -122.457366158726 (37.7440732391823, -122.457366158726)
146834 146834 190932 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1101 25th St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 9ft   6015229.59957 2102026.97334 37.7526212961411 -122.390204678629 (37.7526212961411, -122.390204678629)
146878 146878 201557 Undocumented 2 Pinus radiata :: Monterey Pine 3 200 Jerrold Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 9ft   6019843.77362 2093685.4029299999 37.7299718344327 -122.373670245296 (37.7299718344327, -122.373670245296)
147053 147053 226002 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 169 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6005477.49545 2100188.99105 37.7470288826965 -122.42379851640499 (37.7470288826965, -122.423798516405)
147435 147435 194484 Undocumented 2 Pinus radiata :: Monterey Pine 3 2208 25th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 9ft   6012170.679769999 2101904.59247 37.7521151235314 -122.40077442501699 (37.7521151235314, -122.400774425017)
147673 147673 194031 Undocumented 2 Myoporum laetum :: Myoporum 1 1101 25th St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 9ft   6015324.74216 2102030.33526 37.7526358040022 -122.38987589096901 (37.7526358040022, -122.389875890969)
147873 147873 189982 Undocumented 2 Cercis occidentalis :: Western Redbud 246 2001 Revere Ave 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6012448.34075 2096330.25882 37.7368246747079 -122.39942292113301 (37.7368246747079, -122.399422921133)
148329 148329 192967 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Arkansas St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6012878.79115 2105782.39393 37.7628021891935 -122.398597746415 (37.7628021891935, -122.398597746415)
148511 148511 212576 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100x Idora Ave 7 Median : Yard 3 Tree 1 DPW 2     2 Width 9ft   5995353.74805 2099410.49817 37.74431463161879 -122.458748984199 (37.7443146316188, -122.458748984199)
148740 148740 194781 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 37 Maddux Ave 2 Front Yard : Yard 7 Tree 1 Private 1     9 Width 9ft   6012782.01516 2095526.39332 37.734636019838 -122.398212872552 (37.734636019838, -122.398212872552)
149322 149322 123178 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 755 10th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 9ft   5992851.1981 2110319.1636799998 37.77412281782561 -122.46819559495 (37.7741228178256, -122.46819559495)
150923 150923 204192 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 442 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 9ft   5998503.82131 2095275.63385 37.7331418394226 -122.44755916334199 (37.7331418394226, -122.447559163342)
151463 151463 224192 Undocumented 2 Eucalyptus camaldulensis :: River Red Gum 340 1200 San Jose Ave 7 Front Yard : Yard 7 Tree 1 Private 1     23 Width 9ft   6004059.13086 2095959.7871599998 37.7353362859469 -122.42840171247101 (37.7353362859469, -122.428401712471)
151482 151482 189815 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 15th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 9ft   6010361.40821 2107373.60835 37.7670307313104 -122.407416715103 (37.7670307313104, -122.407416715103)
152760 152760 232869 Undocumented 2 Olea europaea :: Olive Tree 41 301 Putnam St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 9ft   6009077.71064 2095875.53633 37.7353876606063 -122.411044607225 (37.7353876606063, -122.411044607225)
152930 152930 132679 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 16 Heather Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 9ft   5997380.732580001 2114357.4428 37.78547143241121 -122.452818754791 (37.7854714324112, -122.452818754791)
154396 154396 124182 Undocumented 2 Pinus radiata :: Monterey Pine 3 18 Almaden Ct 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 9ft   5995869.666259999 2112609.07722 37.780584182666395 -122.45791999637699 (37.7805841826664, -122.457919996377)
155889 155889 187486 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 700 Velasco Ave 2 Front Yard : Yard 7 Tree 1 Private 1     9 Width 9ft   6006768.10436 2086582.6135 37.7097415013489 -122.41837109707 (37.7097415013489, -122.41837109707)
155898 155898 192971 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Arkansas St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6012871.7630900005 2105891.87126 37.7631023981666 -122.398629737092 (37.7631023981666, -122.398629737092)
156731 156731 198053 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 820 Illinois St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 9ft   6015994.50717 2105252.5943299998 37.761520564453896 -122.387784515751 (37.7615205644539, -122.387784515751)
156796 156796 191266 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1721 Revere Ave 1 : 4 Tree 1 Private 1     25 Width 9ft   6014437.69224 2094855.17275 37.7328850694924 -122.39244165855499 (37.7328850694924, -122.392441658555)
157169 157169 187487 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 700 Velasco Ave 3 Front Yard : Yard 7 Tree 1 Private 1     12 Width 9ft   6006739.4924099995 2086592.2880099998 37.709766454838096 -122.418470670891 (37.7097664548381, -122.418470670891)
157332 157332 192376 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500 Illinois St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 9ft   6015917.31296 2106690.54623 37.7654645943419 -122.388151855539 (37.7654645943419, -122.388151855539)
157488 157488 192968 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 200 Arkansas St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 9ft   6012876.85912 2105807.00697 37.762869663519 -122.39860615594999 (37.762869663519, -122.39860615595)
157593 157593 124179 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 8X Almaden Ct 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 9ft   5995876.0 2112606.0 37.7805760973259 -122.457897862346 (37.7805760973259, -122.457897862346)
157732 157732 189820 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 601 15th St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 9ft   6010468.25457 2107379.34073 37.7670524508424 -122.40704755241 (37.7670524508424, -122.40704755241)
158033 158033 225852 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 58 Liberty St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 9ft   6005926.4648400005 2104057.0106 37.7576749077845 -122.422520824396 (37.7576749077845, -122.422520824396)
158785 158785 189988 Undocumented 2 Cercis occidentalis :: Western Redbud 246 2001 Revere Ave 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6012609.72443 2096214.3207900003 37.736515326817 -122.39885680871201 (37.736515326817, -122.398856808712)
159160 159160 124582 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 3969 Washington St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 9ft   5995697.73054 2115463.76534 37.7884125114933 -122.458721526276 (37.7884125114933, -122.458721526276)
159189 159189 234375 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 581 Dolores St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 9ft   6004995.06327 2105009.72546 37.760238249920604 -122.425809806971 (37.7602382499206, -122.425809806971)
159281 159281 126073 Undocumented 2 Cordyline australis :: Dracena Palm 141 280 Euclid Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 9ft   5997937.77739 2113961.77772 37.784416944922704 -122.450863014442 (37.7844169449227, -122.450863014442)
159393 159393 198054 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 820 Illinois St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6015996.1825 2105236.6253 37.7614768097219 -122.387777607167 (37.7614768097219, -122.387777607167)
159564 159564 242778 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1 McCoppin St 1 : 4 Tree 1 Private 1     4 Width 9ft   6006595.78841 2109152.55753 37.7717038182152 -122.420567728011 (37.7717038182152, -122.420567728011)
160138 160138 125525 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 220 Lombard St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 9ft   6011203.66326 2120729.63027 37.8037503211682 -122.405444189817 (37.8037503211682, -122.405444189817)
160221 160221 130561 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 49 Heather Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 9ft   5997335.31934 2114155.38722 37.784914038893206 -122.452961280243 (37.7849140388932, -122.452961280243)
160429 160429 192377 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500 Illinois St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 9ft   6015920.48189 2106647.80141 37.7653474018847 -122.38813791154499 (37.7653474018847, -122.388137911545)
160560 160560 234507 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1100 San Jose Ave 32 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 9ft   6004787.92016 2096687.497 37.7373756263678 -122.425933801003 (37.7373756263678, -122.425933801003)
160876 160876 131042 Undocumented 2 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 3001 Divisadero St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 9ft   6000473.91869 2118638.90202 37.797403962867996 -122.442424767404 (37.797403962868, -122.442424767404)
160927 160927 242373 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2x McCoppin St 1 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   6006573.34583 2109150.3275 37.771696430266 -122.420645200112 (37.771696430266, -122.420645200112)
161434 161434 119408 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 375 32nd Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 9ft   5985886.47906 2113308.3563599996 37.781925583655294 -122.49250761776301 (37.7819255836553, -122.492507617763)
161733 161733 196296 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 383 Arkansas St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 9ft   6012973.423830001 2105290.2988400003 37.7614562764103 -122.398235915848 (37.7614562764103, -122.398235915848)
161939 161939 198055 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 820 Illinois St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6015997.74921 2105213.0549 37.7614121772375 -122.387770543876 (37.7614121772375, -122.387770543876)
162022 162022 131041 Undocumented 2 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 3001 Divisadero St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 9ft   6000469.3004 2118677.0449099997 37.7975084299175 -122.44244348768 (37.7975084299175, -122.44244348768)
162455 162455 195979 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 900 Phelps St 1 Side Yard : Yard 17 Tree 1 Private 1     30 Width 9ft   6014704.25324 2097268.53042 37.739526454869704 -122.39168875963999 (37.7395264548697, -122.39168875964)
162650 162650 192374 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 500 Illinois St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 9ft   6015916.946 2106720.28142 37.765546220411295 -122.38815520010901 (37.7655462204113, -122.388155200109)
163006 163006 228912 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 902 Duboce Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 9ft   6002507.65455 2108261.418 37.769025726184395 -122.43464508941999 (37.7690257261844, -122.43464508942)
163978 163978 232291 Undocumented 2 Myoporum laetum :: Myoporum 1 1100 San Jose Ave 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 9ft   6004778.102000001 2096680.6709599998 37.737356328728104 -122.42596726120001 (37.7373563287281, -122.4259672612)
164075 164075 241289 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1201 Vermont St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 9ft   6011466.52977 2102070.65758 37.7525318019104 -122.403221176312 (37.7525318019104, -122.403221176312)
164086 164086 189216 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 1660 La Salle Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 9ft   6015290.992769999 2096384.2824799998 37.737131043164794 -122.38959831162501 (37.7371310431648, -122.389598311625)
165512 165512 131040 Undocumented 2 Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 3001 Divisadero St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 9ft   6000467.64422 2118686.84374 37.797535240511706 -122.442449922347 (37.7975352405117, -122.442449922347)
165743 165743 225851 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 58 Liberty St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 9ft   6005940.80903 2104056.71589 37.7576749077866 -122.4224711953 (37.7576749077866, -122.4224711953)
165827 165827 201926 Undocumented 2 Citrus spp :: Lemon: Orange: Lime 278 118 Elmira St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 9ft   6011142.54954 2096046.89892 37.7359737613804 -122.403917705737 (37.7359737613804, -122.403917705737)
166369 166369 194603 Undocumented 2 Pittosporum tobira :: Japanese Mockorange 243 500 Wisconsin St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 9ft   6012631.4012 2105136.35292 37.761014517726295 -122.399408030156 (37.7610145177263, -122.399408030156)
166371 166371 246687 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 65 Randall St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 9ft   6004944.1218 2097602.36636 37.7398964773322 -122.42545882766301 (37.7398964773322, -122.425458827663)
166774 166774 242781 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 95x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 9ft   6006152.38517 2109124.27435 37.771601160584 -122.42209948031099 (37.771601160584, -122.422099480311)
167388 167388 194082 Undocumented 2 Myoporum laetum :: Myoporum 1 495 Barneveld Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 9ft   6011088.380890001 2097569.3881900003 37.7401511662306 -122.404212110497 (37.7401511662306, -122.404212110497)
167492 167492 228917 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 902 Duboce Ave 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 9ft   6002641.22231 2108269.24913 37.7690548102697 -122.434183647259 (37.7690548102697, -122.434183647259)
167759 167759 196407 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 301 Pennsylvania Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   6014364.2295 2105674.4780599996 37.7625885210619 -122.393452545091 (37.7625885210619, -122.393452545091)
167931 167931 124291 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 4401x Cornwall St 3 Median : Yard 3 Tree 1 DPW 2     16 Width 9ft   5993813.763719999 2114194.95027 37.7848202285685 -122.465147505193 (37.7848202285685, -122.465147505193)
168179 168179 119407 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 375 32nd Ave 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     26 Width 9ft   5985884.85714 2113320.57304 37.78195903231371 -122.49251412874399 (37.7819590323137, -122.492514128744)
169278 169278 124176 Undocumented 2 Olea europaea :: Olive Tree 41 11 Almaden Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 9ft   5995826.0985199995 2112588.51087 37.7805252097548 -122.45806922812099 (37.7805252097548, -122.458069228121)
169555 169555 125268 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 2960 Van Ness Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 9ft   6005626.14224 2120703.55494 37.8033652908254 -122.42474367328 (37.8033652908254, -122.42474367328)
169841 169841 190933 Undocumented 2 Crataegus phaenopyrum :: Washington Hawthorn 135 1101 25th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 9ft   6015201.2247 2102025.49065 37.7526156511008 -122.390302701123 (37.7526156511008, -122.390302701123)

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 354.111ms · Data source: data.sfgov.org