Street_Tree_List

Data source: data.sfgov.org

821 rows where search matches "cherry" and qSiteInfo = 2 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSpecies, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 821 ✖
Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
168210 168210 218135 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 0 Noriega St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5992409.03176 2103467.31015 37.7552838973381 -122.469226308173 (37.7552838973381, -122.469226308173)
131128 131128 123933 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 08th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     5993312.90228 2114946.82765 37.7868557832667 -122.466934987319 (37.7868557832667, -122.466934987319)
149532 149532 123932 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 08th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     5993304.79465 2114951.8615900003 37.7868691371328 -122.46696340370801 (37.7868691371328, -122.466963403708)
38273 38273 202293 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 Issleib Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   6012754.8343 2093244.37958 37.7283685671459 -122.39814680025499 (37.7283685671459, -122.398146800255)
73712 73712 202295 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 Issleib Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   6012780.58541 2093228.85419 37.7283273718953 -122.398056688169 (37.7283273718953, -122.398056688169)
132706 132706 202294 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 Issleib Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 2ft   6012769.019119999 2093237.37262 37.7283501175462 -122.398097270977 (37.7283501175462, -122.398097270977)
147991 147991 202291 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 Issleib Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   6012719.32075 2093257.8431 37.728403557061895 -122.398270517286 (37.7284035570619, -122.398270517286)
150404 150404 237804 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 Loma Vista Ter 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6000006.51649 2106939.02785 37.7652524667463 -122.443201354463 (37.7652524667463, -122.443201354463)
170839 170839 237803 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 Loma Vista Ter 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6000002.45309 2106902.83574 37.765152860531 -122.44321280913601 (37.765152860531, -122.443212809136)
176936 176936 237802 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 Loma Vista Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6000002.6635 2106881.0655400003 37.765093096983705 -122.44321051766899 (37.7650930969837, -122.443210517669)
69786 69786 212402 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 San Rafael Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5991904.19278 2095912.91043 37.734512268621295 -122.470422033273 (37.7345122686213, -122.470422033273)
172302 172302 212403 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 San Rafael Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5991902.57817 2095944.2843799999 37.734598320237296 -122.470429899615 (37.7345983202373, -122.470429899615)
174012 174012 212401 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 San Rafael Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5991904.4182 2095887.6067400002 37.7344428040878 -122.470419411726 (37.7344428040878, -122.470419411726)
156323 156323 213482 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Sola Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994974.838219999 2100674.05314 37.7477622510295 -122.460150689121 (37.7477622510295, -122.460150689121)
71627 71627 121889 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 17th Ave 0 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 5ft   5990520.54715 2115002.72082 37.78684768786071 -122.47659987163799 (37.7868476878607, -122.476599871638)
40170 40170 213651 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994859.86261 2099088.6488 37.743402514010704 -122.460433407183 (37.7434025140107, -122.460433407183)
72974 72974 213652 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994842.29481 2099078.88139 37.743374684505206 -122.46049344413099 (37.7433746845052, -122.460493444131)
76291 76291 213654 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5994824.078840001 2099066.74247 37.7433403061049 -122.460555550413 (37.7433403061049, -122.460555550413)
76930 76930 213653 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Edgehill Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994833.218169999 2099074.30171 37.7433615876766 -122.46052449682699 (37.7433615876766, -122.460524496827)
37243 37243 202167 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Kalmanovitz St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 2ft   6013164.547619999 2093230.83795 37.7283541968866 -122.396729443526 (37.7283541968866, -122.396729443526)
45654 45654 202165 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Kalmanovitz St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 2ft   6013169.468859999 2093279.75554 37.7284887885067 -122.39671585835698 (37.7284887885067, -122.396715858357)
64207 64207 202166 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Kalmanovitz St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 2ft   6013167.38298 2093268.67632 37.7284582511357 -122.39672229302201 (37.7284582511357, -122.396722293022)
29000 29000 237789 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Loma Vista Ter 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5999974.87074 2106875.7261900003 37.7650768516417 -122.443306262176 (37.7650768516417, -122.443306262176)
48155 48155 237787 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Loma Vista Ter 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5999975.78391 2106902.16823 37.76514950696679 -122.44330500312701 (37.7651495069668, -122.443305003127)
59446 59446 237788 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Loma Vista Ter 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5999974.057569999 2106889.15487 37.7651136770803 -122.44331003932699 (37.7651136770803, -122.443310039327)
151324 151324 237790 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Loma Vista Ter 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5999973.591030001 2106866.6906 37.765051969188704 -122.443310039322 (37.7650519691887, -122.443310039322)
50305 50305 213569 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Merced Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5995296.87532 2100197.80172 37.7464731016692 -122.459002630776 (37.7464731016692, -122.459002630776)
149108 149108 213571 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Merced Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5995317.16684 2100218.39007 37.746530798564 -122.458933955845 (37.746530798564, -122.458933955845)
166643 166643 213570 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Merced Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5995304.50078 2100206.2944900002 37.7464968590373 -122.458976877776 (37.7464968590373, -122.458976877776)
41657 41657 213555 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 10 Valdez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5996402.0458 2093842.9488400002 37.7290876920423 -122.45472205120599 (37.7290876920423, -122.454722051206)
60101 60101 135697 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Walnut St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5998449.317000001 2116481.46771 37.7913646187353 -122.449274868335 (37.7913646187353, -122.449274868335)
172696 172696 135698 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 10 Walnut St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5998453.121780001 2116461.2064400003 37.7913092042995 -122.449260243563 (37.7913092042995, -122.449260243563)
134948 134948 178732 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 100 Morse St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 1ft   6000912.22914 2087974.06631 37.713230738679705 -122.43870965184601 (37.7132307386797, -122.438709651846)
149450 149450 178733 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 100 Morse St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 1ft   6000880.0864 2087963.6418299999 37.713200286736495 -122.438820001354 (37.7132002867365, -122.438820001354)
45242 45242 213576 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994554.1980800005 2099981.39248 37.7458361756945 -122.46155502007299 (37.7458361756945, -122.461555020073)
169697 169697 213577 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 100 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994569.9735900005 2099964.1686400003 37.745789791378 -122.46149922251001 (37.745789791378, -122.46149922251)
70402 70402 215201 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 100 San Buenaventura Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 8ft   5993358.68485 2095957.8363599998 37.7347196153991 -122.46539667472601 (37.7347196153991, -122.465396674726)
178374 178374 215202 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 100 San Buenaventura Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   5993358.65821 2095928.85229 37.7346400308107 -122.465394662057 (37.7346400308107, -122.465394662057)
34957 34957 214766 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Alton Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993866.28574 2101627.27037 37.7503157185921 -122.464053162237 (37.7503157185921, -122.464053162237)
29767 29767 140858 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 101 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5996504.4566 2113783.0205 37.7838439696062 -122.455808853694 (37.7838439696062, -122.455808853694)
175963 175963 140859 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 101 COMMONWEALTH AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   5996507.8408 2113753.2393 37.783762392571795 -122.45579499216998 (37.7837623925718, -122.45579499217)
131134 131134 218043 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 101 Montalvo Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993702.92374 2099723.43076 37.7450788422242 -122.46447985636499 (37.7450788422242, -122.464479856365)
76569 76569 136021 Undocumented 2 Prunus spp :: Cherry 84 1010 Lombard St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6007482.49892 2120248.47345 37.802220422406705 -122.418287380977 (37.8022204224067, -122.418287380977)
166256 166256 213085 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 102 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994444.11048 2101305.31055 37.7494649833313 -122.462031675131 (37.7494649833313, -122.462031675131)
54244 54244 196406 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1021 Minnesota St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6015301.01099 2103753.62638 37.7573662793475 -122.390078334671 (37.7573662793475, -122.390078334671)
67593 67593 197875 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 1022 Harrison St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   6011232.56794 2110864.16266 37.7766637150973 -122.40464924398998 (37.7766637150973, -122.40464924399)
169642 169642 197876 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 1022 Harrison St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6011218.09567 2110851.71403 37.7766287251786 -122.404698431509 (37.7766287251786, -122.404698431509)
56504 56504 214451 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 103 Dorantes Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993921.129 2099948.59538 37.7457096635647 -122.463741686529 (37.7457096635647, -122.463741686529)
132406 132406 124015 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 104 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5991819.02656 2114698.83579 37.7860885309356 -122.472085318982 (37.7860885309356, -122.472085318982)
166198 166198 124014 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 104 Funston Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5991818.088169999 2114740.92009 37.786204028457604 -122.47209163415 (37.7862040284576, -122.47209163415)
53209 53209 201245 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 105 Orsi Cir 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 2ft   6012837.41647 2093205.33465 37.7282659571993 -122.397858570225 (37.7282659571993, -122.397858570225)
174449 174449 201244 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 105 Orsi Cir 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 2ft   6012833.80846 2093200.62135 37.728252814508295 -122.397870712864 (37.7282528145083, -122.397870712864)
183824 183824 201243 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 105 Orsi Cir 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 2ft   6012828.52235 2093195.2061299998 37.7282376510311 -122.39788860758001 (37.7282376510311, -122.39788860758)
173598 173598 196263 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1059 Jamestown Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6013674.30393 2089830.73604 37.7190465590346 -122.394729166931 (37.7190465590346, -122.394729166931)
39787 39787 135818 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1071 Lombard St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   6007217.26018 2120160.1793299997 37.801963055314495 -122.419198970666 (37.8019630553145, -122.419198970666)
54014 54014 135817 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1083 Lombard St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6007203.659469999 2120166.57987 37.8019798636266 -122.419246489941 (37.8019798636266, -122.419246489941)
47186 47186 200490 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1088 Jamestown Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   6013545.6611 2089994.9439 37.7194902878281 -122.39518533478001 (37.7194902878281, -122.39518533478)
56051 56051 136019 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 11 Greenwich St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6012283.42018 2120515.08235 37.803221537807204 -122.401692519489 (37.8032215378072, -122.401692519489)
154989 154989 136018 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 11 Greenwich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6012250.392990001 2120519.5939 37.8032320823636 -122.401807129095 (37.8032320823636, -122.401807129095)
34956 34956 212607 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 11 Miramar Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5995300.7051800005 2090004.7098400001 37.7184855727191 -122.458251756207 (37.7184855727191, -122.458251756207)
46765 46765 140864 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 111 COMMONWEALTH AVE 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5996511.5635 2113696.0461 37.7836055688965 -122.455777977423 (37.7836055688965, -122.455777977423)
71144 71144 214810 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 111 Edgehill Way 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994724.24125 2098971.31175 37.7430725329757 -122.460893845698 (37.7430725329757, -122.460893845698)
72503 72503 214812 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 111 Edgehill Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994729.24198 2098958.41321 37.7430374045466 -122.460875620025 (37.7430374045466, -122.460875620025)
153720 153720 214811 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 111 Edgehill Way 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994726.40905 2098964.7055200003 37.7430545186528 -122.46088587139799 (37.7430545186528, -122.460885871398)
32935 32935 196267 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1121 Jamestown Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6013259.78096 2090144.7382099999 37.719885690359604 -122.396184017281 (37.7198856903596, -122.396184017281)
132021 132021 196266 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1121 Jamestown Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6013242.639359999 2090155.46784 37.71991419797 -122.39624402185 (37.71991419797, -122.39624402185)
135040 135040 196264 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1121 Jamestown Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11     6013209.07716 2090182.42282 37.7199863433675 -122.39636192385599 (37.7199863433675, -122.396361923856)
174870 174870 196265 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1121 Jamestown Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6013225.87785 2090169.90622 37.7199529101853 -122.39630297241999 (37.7199529101853, -122.39630297242)
175920 175920 196268 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1121 Jamestown Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6013281.01333 2090127.7740900002 37.719840291665896 -122.396109435604 (37.7198402916659, -122.396109435604)
52586 52586 214452 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 115 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993881.37151 2099908.46331 37.7455971799806 -122.463876248508 (37.7455971799806, -122.463876248508)
63220 63220 135844 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1155 Greenwich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6007360.5897 2119841.38777 37.801095804879395 -122.418680361323 (37.8010958048794, -122.418680361323)
69090 69090 135843 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1175 Greenwich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 10ft   6007285.978759999 2119831.2458099998 37.8010637566478 -122.418937828239 (37.8010637566478, -122.418937828239)
58342 58342 135841 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1177 Greenwich St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6007250.45092 2119825.88461 37.801047035553005 -122.41906038964 (37.801047035553, -122.41906038964)
71521 71521 135838 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1177 Greenwich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6007200.951230001 2119822.58623 37.801035191466205 -122.41923144609301 (37.8010351914662, -122.419231446093)
136919 136919 135840 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1177 Greenwich St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6007238.199519999 2119824.8673400003 37.8010435524736 -122.419102712642 (37.8010435524736, -122.419102712642)
155473 155473 135842 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1177 Greenwich St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6007263.48219 2119827.6474 37.801052609542396 -122.419015420851 (37.8010526095424, -122.419015420851)
165955 165955 135839 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1177 Greenwich St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6007217.01278 2119823.01799 37.8010372815012 -122.419175896763 (37.8010372815012, -122.419175896763)
136138 136138 212561 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 119 Terrace Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5993479.864130001 2096836.47332 37.7371391217766 -122.465041513556 (37.7371391217766, -122.465041513556)
64645 64645 213553 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 119 Valdez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5996273.88735 2094337.4099 37.730438011494996 -122.455200820562 (37.730438011495, -122.455200820562)
36107 36107 215203 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 120 San Buenaventura Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   5993362.10241 2095871.1002099998 37.7344816565847 -122.465378560574 (37.7344816565847, -122.465378560574)
186331 186331 215204 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 120 San Buenaventura Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   5993362.71827 2095845.00098 37.734410030100996 -122.465374536105 (37.734410030101, -122.465374536105)
27002 27002 181705 Undocumented 2 Prunus serrulata :: Ornamental Cherry 35 1206 22nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5989261.3602 2107107.536 37.7650965865931 -122.48037820612 (37.7650965865931, -122.48037820612)
132642 132642 212559 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 121 Terrace Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5993518.68842 2096812.9908200002 37.7370768832988 -122.464905576542 (37.7370768832988, -122.464905576542)
178238 178238 212560 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 121 Terrace Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5993496.587590001 2096822.61338 37.7371020301329 -122.464982687119 (37.7371020301329, -122.464982687119)
42686 42686 213037 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 123 Edgewood Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5996575.33266 2106255.76351 37.7631801508579 -122.45501955952801 (37.7631801508579, -122.455019559528)
148013 148013 213036 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 123 Edgewood Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5996574.93619 2106264.5775200003 37.7632043291332 -122.455021567702 (37.7632043291332, -122.455021567702)
184531 184531 213038 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 123 Edgewood Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 3ft   5996575.8509599995 2106245.56182 37.7631521693566 -122.45501702971201 (37.7631521693566, -122.455017029712)
69358 69358 215222 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 123 Ortega St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 2ft   5993571.89199 2102535.20203 37.75279169520329 -122.465137125003 (37.7527916952033, -122.465137125003)
56077 56077 250876 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986468.29527 2114661.08637 37.7856737915584 -122.490594385245 (37.7856737915584, -122.490594385245)
71891 71891 250874 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5986467.3841 2114682.3933599996 37.7857322411853 -122.490599105779 (37.7857322411853, -122.490599105779)
166433 166433 250875 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5986467.14332 2114671.0752 37.7857011507179 -122.490599105783 (37.7857011507179, -122.490599105783)
76027 76027 213474 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993866.67958 2099897.14622 37.7455652594364 -122.463926229234 (37.7455652594364, -122.463926229234)
52702 52702 213581 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Garcia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994661.106000001 2099475.65423 37.7444536982758 -122.461148698258 (37.7444536982758, -122.461148698258)
62188 62188 213582 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Garcia Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994660.96861 2099488.84226 37.7444899013971 -122.461150129069 (37.7444899013971, -122.461150129069)
149385 149385 213057 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 125 Garcia Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994656.19634 2099517.7844599998 37.744569094794706 -122.46116872797701 (37.7445690947947, -122.461168727977)
159600 159600 213583 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 125 Garcia Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994657.50527 2099501.27559 37.744523840899205 -122.46116300556801 (37.7445238408992, -122.461163005568)
180691 180691 218044 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 125 Montalvo Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993762.98726 2099592.0728599997 37.744721628811895 -122.464262634132 (37.7447216288119, -122.464262634132)
173038 173038 212558 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 125 Terrace Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5993542.30176 2096798.75728 37.7370391630172 -122.464822901877 (37.7370391630172, -122.464822901877)
30750 30750 213598 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 128 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994427.44461 2101171.23368 37.749095882669295 -122.462079583807 (37.7490958826693, -122.462079583807)
73158 73158 213599 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 128 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994429.75237 2101162.69532 37.7490725713631 -122.46207098449601 (37.7490725713631, -122.462070984496)

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