Street_Tree_List

Data source: data.sfgov.org

10,815 rows where qSiteInfo = 9 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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