Street_Tree_List

Data source: data.sfgov.org

1,742 rows where qSpecies = 51 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
25481 25481 198281 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017868.75025 2099595.89007 37.7460920687928 -122.380908946009 (37.7460920687928, -122.380908946009)
30849 30849 198285 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017793.32679 2099592.23757 37.7460778765941 -122.381169499371 (37.7460778765941, -122.381169499371)
31735 31735 198284 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017813.21777 2099593.44192 37.74608228148 -122.381100801954 (37.74608228148, -122.381100801954)
35317 35317 123509 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2636 Fulton St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 8ft   5995163.8038800005 2110297.4884900004 37.77419659482779 -122.46019437077899 (37.7741965948278, -122.460194370779)
37378 37378 198292 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017651.2465699995 2099584.75723 37.7460494930826 -122.381660279195 (37.7460494930826, -122.381660279195)
38574 38574 219441 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 147 Stillings Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   5999786.27103 2095740.5208700001 37.734491517651 -122.443158781469 (37.734491517651, -122.443158781469)
38795 38795 198287 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017753.37339 2099590.18904 37.7460700461913 -122.38130751204399 (37.7460700461913, -122.381307512044)
53948 53948 198296 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 17 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017552.343280001 2099579.4388200003 37.7460294283132 -122.382001907384 (37.7460294283132, -122.382001907384)
55610 55610 198286 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017773.62926 2099591.7423799997 37.7460754295565 -122.381237577149 (37.7460754295565, -122.381237577149)
57758 57758 198294 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017591.2197 2099581.33021 37.7460367685821 -122.381867608025 (37.7460367685821, -122.381867608025)
57835 57835 198293 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017632.06769 2099583.36051 37.746044598982 -122.381726500798 (37.746044598982, -122.381726500798)
65432 65432 198288 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017733.321719999 2099589.8795 37.7460680892801 -122.3813768273 (37.7460680892801, -122.3813768273)
67092 67092 198290 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017692.8350599995 2099588.0199599997 37.746060748120705 -122.381516697036 (37.7460607481207, -122.381516697036)
73875 73875 198295 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 16 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017570.97457 2099580.31165 37.746032853833206 -122.38193754289101 (37.7460328538332, -122.381937542891)
74955 74955 198283 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017833.27301 2099593.92963 37.7460847276446 -122.381031486718 (37.7460847276446, -122.381031486718)
131704 131704 198291 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017672.75114 2099586.10688 37.746054386310796 -122.38158601229601 (37.7460543863108, -122.381586012296)
147691 147691 198299 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 20 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017490.49598 2099601.17912 37.746085707003004 -122.38221728150499 (37.746085707003, -122.382217281505)
160306 160306 198282 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017853.17114 2099595.49021 37.74609011098 -122.38096278932301 (37.74609011098, -122.380962789323)
163126 163126 180411 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2 Still St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   6003370.62574 2094727.02091 37.731912405013 -122.430694186892 (37.731912405013, -122.430694186892)
170643 170643 198289 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 8ft   6017712.53976 2099588.87163 37.746064174537004 -122.381448619273 (37.746064174537, -122.381448619273)
172019 172019 198298 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017519.7761 2099586.1475400003 37.7460460504973 -122.38211498813601 (37.7460460504973, -122.382114988136)
183395 183395 198297 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 500 Amador St 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   6017533.81233 2099583.55419 37.7460397048816 -122.382066271836 (37.7460397048816, -122.382066271836)
188836 188836 180410 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2 Still St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   6003389.548769999 2094727.9749900002 37.7319160967549 -122.43062883406601 (37.7319160967549, -122.430628834066)
154342 154342 136919 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 101 Laurel St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 7ft   5997971.7056 2116051.1115099997 37.790155644821 -122.450896340588 (37.790155644821, -122.450896340588)
185852 185852 180408 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 141 Rousseau St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 7ft   6003605.879 2094702.80598 37.731859241593106 -122.429879140314 (37.7318592415931, -122.429879140314)
67039 67039 120355 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2270 Lake St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5988402.72558 2114696.23379 37.78588309898829 -122.48390447116999 (37.7858830989883, -122.48390447117)
70304 70304 120354 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2270 Lake St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5988430.28754 2114697.53592 37.7858882787477 -122.483809211099 (37.7858882787477, -122.483809211099)
157952 157952 242873 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2650 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 6ft   6010144.5827 2103997.84571 37.757749513755705 -122.40792860561501 (37.7577495137557, -122.407928605615)
159205 159205 198306 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 502 Beale St 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 6ft   6015908.341130001 2113925.9394400003 37.78533088635999 -122.38868801426202 (37.78533088636, -122.388688014262)
176526 176526 242872 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2650 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 6ft   6010155.11126 2103998.01915 37.7577505794312 -122.407892205568 (37.7577505794312, -122.407892205568)
27116 27116 136928 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3835 Scott St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6000577.85991 2121479.43113 37.8052092229902 -122.442269124421 (37.8052092229902, -122.442269124421)
28007 28007 198263 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015429.86935 2107171.76588 37.7667588995269 -122.38987144293002 (37.7667588995269, -122.38987144293)
28474 28474 198266 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015509.21403 2107176.39831 37.7667760190131 -122.389597324184 (37.7667760190131, -122.389597324184)
33869 33869 198258 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015275.05109 2107162.53945 37.766724978901 -122.390406293135 (37.766724978901, -122.390406293135)
36902 36902 136926 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3835 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6000573.99959 2121502.15962 37.805271409309 -122.442284116143 (37.805271409309, -122.442284116143)
37968 37968 136932 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3825 Scott St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6000587.38423 2121403.46977 37.8050011962985 -122.442230708079 (37.8050011962985, -122.442230708079)
38435 38435 136931 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3825 Scott St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6000586.31642 2121417.2428200003 37.805038952541295 -122.442235392672 (37.8050389525413, -122.442235392672)
40735 40735 198261 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015349.85102 2107166.4928900003 37.7667399832017 -122.390147846856 (37.7667399832017, -122.390147846856)
41510 41510 198346 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 522 Minna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6010010.37374 2112093.20065 37.7799699808627 -122.40896392853901 (37.7799699808627, -122.408963928539)
46587 46587 198262 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015403.651819999 2107169.78818 37.766752015232 -122.38996198758001 (37.766752015232, -122.38996198758)
51539 51539 198268 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015559.03734 2107179.0425299997 37.7667860419549 -122.389425176852 (37.7667860419549, -122.389425176852)
59154 59154 218160 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 5ft   5993082.74921 2097580.44526 37.7391589756979 -122.46646856589899 (37.7391589756979, -122.466468565899)
69929 69929 198264 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015458.161180001 2107173.009 37.7667638817829 -122.389773672231 (37.7667638817829, -122.389773672231)
71395 71395 136927 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3835 Scott St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6000575.8794 2121488.3697200003 37.8052336530829 -122.44227662028 (37.8052336530829, -122.44227662028)
132057 132057 198269 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015584.25134 2107180.42064 37.7667912238576 -122.38933806131 (37.7667912238576, -122.38933806131)
132413 132413 198257 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015249.12496 2107161.11313 37.7667196243297 -122.390495868314 (37.7667196243297, -122.390495868314)
147190 147190 218159 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993095.853519999 2097590.7626 37.7391880606825 -122.46642400716001 (37.7391880606825, -122.46642400716)
159176 159176 198265 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015482.60076 2107174.90803 37.766770451333706 -122.38968927173799 (37.7667704513337, -122.389689271738)
161872 161872 123700 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 314 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   5994582.57052 2111471.99981 37.7773880411684 -122.462290147524 (37.7773880411684, -122.462290147524)
162245 162245 198260 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015323.86346 2107164.8695799997 37.7667340845278 -122.390237620786 (37.7667340845278, -122.390237620786)
163030 163030 136929 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3825 Scott St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6000583.85394 2121442.09911 37.8051070609006 -122.442245699797 (37.8051070609006, -122.442245699797)
163334 163334 136930 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3825 Scott St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6000585.214790001 2121429.39855 37.8050722661295 -122.442240078135 (37.8050722661295, -122.442240078135)
170522 170522 198259 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015299.78244 2107163.66731 37.7667294476245 -122.39032082966601 (37.7667294476245, -122.390320829666)
175261 175261 198355 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 538 Natoma St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6010114.138119999 2111927.58164 37.7795210419915 -122.40859327295401 (37.7795210419915, -122.408593272954)
184260 184260 218161 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1400 Portola Dr 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   5993069.62325 2097569.10976 37.7391270938355 -122.466513125474 (37.7391270938355, -122.466513125474)
184466 184466 198267 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 401 16th St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6015536.948369999 2107177.2535099997 37.7667799049876 -122.389501454631 (37.7667799049876, -122.389501454631)
2511 2511 246852 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 300 Broderick St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6001238.428669999 2109976.67902 37.7736632691848 -122.43915820668998 (37.7736632691848, -122.43915820669)
23892 23892 180452 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6008393.709980001 2091906.0725900002 37.724449984452704 -122.413128866997 (37.7244499844527, -122.413128866997)
25557 25557 242876 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3298 16th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6005033.62978 2106658.32415 37.7647670900596 -122.425793770266 (37.7647670900596, -122.425793770266)
29241 29241 180442 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008511.7814 2091523.97842 37.723407462461296 -122.412693709355 (37.7234074624613, -122.412693709355)
29284 29284 198256 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 718 Tennessee St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6015417.87325 2105664.96075 37.762620874174104 -122.38980767650499 (37.7626208741741, -122.389807676505)
29751 29751 219429 DPW Maintained 3 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 900x Kirkham St 1 Median : Cutout 11 Tree 1 DPW 2     1 Width 4ft   5992085.46562 2105232.9931400004 37.7601132972171 -122.47047387378099 (37.7601132972171, -122.470473873781)
32498 32498 136953 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 685 North Point St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6007628.69919 2121609.81563 37.8059665519739 -122.41787801227 (37.8059665519739, -122.41787801227)
35277 35277 136947 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 915 Front St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6012726.66985 2119026.8860400002 37.799160033972 -122.400054056345 (37.799160033972, -122.400054056345)
35858 35858 246494 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 365 Duncan St 1 : 4 Tree 1 Private 1     5 Width 4ft   6004182.0093 2099825.58993 37.745957849487795 -122.428252301803 (37.7459578494878, -122.428252301803)
38673 38673 242350 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 70 McCoppin St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6006095.21609 2109159.69147 37.771695182903706 -122.42229974855302 (37.7716951829037, -122.422299748553)
39535 39535 136939 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1149 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008985.04879 2116923.16762 37.7931744171228 -122.412852575501 (37.7931744171228, -122.412852575501)
39624 39624 180440 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008537.64455 2091440.44703 37.72317955448779 -122.41259840282 (37.7231795544878, -122.41259840282)
46044 46044 120186 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 172 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5987746.67951 2114854.71533 37.7862800304413 -122.48618581827 (37.7862800304413, -122.48618581827)
46161 46161 219422 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1301 Funston Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5992066.9106 2106337.95166 37.7631461484089 -122.470618527048 (37.7631461484089, -122.470618527048)
48324 48324 219420 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1301 Funston Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5992057.8729 2106495.38821 37.7635779048182 -122.470661252913 (37.7635779048182, -122.470661252913)
48325 48325 136956 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 225 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6012358.49357 2116085.98474 37.7910644861899 -122.401121320516 (37.7910644861899, -122.401121320516)
48703 48703 136949 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 915 Front St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6012733.733109999 2118974.78929 37.7990173826009 -122.400025954359 (37.7990173826009, -122.400025954359)
48947 48947 180450 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6008413.5895 2091843.5213400002 37.7242793479848 -122.413055725159 (37.7242793479848, -122.413055725159)
50950 50950 246860 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1198 Oak St 4 : 4 Tree 1 Private 1     2 Width 4ft   6001322.98115 2109744.38173 37.773030249875795 -122.43884907734301 (37.7730302498758, -122.438849077343)
61024 61024 180453 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 21 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6008383.04001 2091938.2142400001 37.7245376395946 -122.4131680235 (37.7245376395946, -122.4131680235)
61139 61139 123206 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 471 09th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5993100.221580001 2112267.5253 37.7794868724906 -122.467475897994 (37.7794868724906, -122.467475897994)
64622 64622 198302 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2651 Phelps St 4 : 4 Tree 1 Private 1     9 Width 4ft   6011892.6623 2093405.69149 37.7287634360827 -122.40113871700301 (37.7287634360827, -122.401138717003)
69123 69123 180485 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1222 Athens St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6001620.509380001 2087598.74128 37.712240447503 -122.436234753557 (37.712240447503, -122.436234753557)
73088 73088 136950 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 685 North Point St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6007570.27525 2121602.58608 37.805943413335 -122.41807968522801 (37.805943413335, -122.418079685228)
74338 74338 242877 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 3298 16th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6004980.057 2106654.52331 37.7647536263021 -122.425978794106 (37.7647536263021, -122.425978794106)
74674 74674 180449 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6008420.75846 2091817.8357900002 37.724209223351295 -122.413029127716 (37.7242092233513, -122.413029127716)
76900 76900 242875 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 2600 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6010748.80165 2102292.81523 37.753101687901605 -122.40571886164699 (37.7531016879016, -122.405718861647)
130241 130241 123203 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 471 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5993099.80494 2112301.80229 37.7795809637616 -122.467479832594 (37.7795809637616, -122.467479832594)
131999 131999 123205 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 471 09th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5993101.276869999 2112277.13231 37.7795133116616 -122.467472946131 (37.7795133116616, -122.467472946131)
134180 134180 219427 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1426 16th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5991170.38541 2105691.7804 37.7613200515933 -122.47367213637101 (37.7613200515933, -122.473672136371)
136447 136447 180441 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6008527.9291900005 2091467.03616 37.7232520173547 -122.412633865781 (37.7232520173547, -122.412633865781)
151384 151384 123603 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 316 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5994658.00106 2113296.21915 37.782401201877796 -122.46216154021799 (37.7824012018778, -122.462161540218)
152310 152310 242870 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 498 Oak St 2 : 4 Tree 1 Private 1     1 Width 4ft   6004648.6662099995 2110205.3941200003 37.7744847252106 -122.42737796202 (37.7744847252106, -122.42737796202)
152635 152635 136916 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1921 Jefferson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6000038.63255 2121244.89177 37.804534494021794 -122.444118317601 (37.8045344940218, -122.444118317601)
153111 153111 136951 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 685 North Point St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6007589.5511300005 2121604.68053 37.8059502490578 -122.418013126415 (37.8059502490578, -122.418013126415)
153727 153727 123356 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 712 04th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5994756.85987 2110644.08831 37.7751248504722 -122.46162718724301 (37.7751248504722, -122.461627187243)
155949 155949 136948 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 915 Front St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6012731.24873 2118997.87566 37.7990806337212 -122.400036173353 (37.7990806337212, -122.400036173353)
157353 157353 136943 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1771 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6006301.75363 2116945.84778 37.7930857115761 -122.42213857116 (37.7930857115761, -122.42213857116)
158057 158057 180451 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6008402.1171699995 2091878.23344 37.724374016020896 -122.413097836812 (37.7243740160209, -122.413097836812)
159051 159051 180448 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 599 University St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6008430.60445 2091787.20061 37.7241256583517 -122.4129929264 (37.7241256583517, -122.4129929264)
164940 164940 123706 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 448 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 4ft   5994137.21954 2111457.4203 37.7773223559503 -122.46382969194201 (37.7773223559503, -122.463829691942)
165814 165814 198420 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 6500 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6012967.05358 2089962.4416099999 37.7193688481865 -122.397183104734 (37.7193688481865, -122.397183104734)
166233 166233 218782 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 1434 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5991822.86644 2105659.6117 37.7612694917142 -122.47141315629999 (37.7612694917142, -122.4714131563)
166295 166295 242330 Undocumented 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 110 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6005175.96727 2099631.57497 37.745481319400795 -122.424801526695 (37.7454813194008, -122.424801526695)

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