Street_Tree_List

Data source: data.sfgov.org

396 rows where qSpecies = 38 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189013 189013 183208 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 4208 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5982977.5431 2098144.6836 37.74011993093129 -122.501448961428 (37.7401199309313, -122.501448961428)
188897 188897 84120 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 336 Campbell Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/24/2006 12:00:00 AM 6     6011186.92342 2088226.0732 37.7145018701492 -122.403214308206 (37.7145018701492, -122.403214308206)
188736 188736 207124 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 5 Front Yard : Yard 7 Tree 1 Private 1     9 Width 0ft   5991335.55729 2095661.67857 37.7337895545331 -122.472369667134 (37.7337895545331, -122.472369667134)
188419 188419 129470 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 45 MacOndray Ln 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     6008463.14234 2119145.61201 37.799247391416394 -122.414815771241 (37.7992473914164, -122.414815771241)
188129 188129 207114 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 53 Ralston St 2 Back Yard : Yard 13 Tree 1 Private 1     23     5992175.21623 2088282.1627599997 37.7135757806697 -122.468929896991 (37.7135757806697, -122.468929896991)
188108 188108 247870 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 394 Mayflower St 2 Side Yard : Yard 17 Tree 1 Private 1     10     6009721.06953 2098395.0417 37.74234173489771 -122.40899798048099 (37.7423417348977, -122.408997980481)
188045 188045 191393 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 845 Vermont St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26     6011318.33835 2104379.19174 37.758862249405 -122.40389608603901 (37.758862249405, -122.403896086039)
187814 187814 102790 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 3445 Moraga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17   Permit Number 42050 5983633.0 2103554.0 37.7550108962308 -122.499582370415 (37.7550108962308, -122.499582370415)
186526 186526 183209 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 4212 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   5982952.5112 2098143.3306 37.740114745803204 -122.501535410067 (37.7401147458032, -122.501535410067)
186348 186348 129483 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 12 Greenwich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17     6012307.75016 2120551.4086599997 37.8033226386787 -122.401610879045 (37.8033226386787, -122.401610879045)
186287 186287 191379 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 29 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6011295.7098900005 2104243.81406 37.758489268176 -122.403964819445 (37.758489268176, -122.403964819445)
185196 185196 207133 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 90 : 4 Tree 1 Private 1     10 Width 0ft   5991231.48328 2092142.9158700001 37.724121889294295 -122.472473035196 (37.7241218892943, -122.472473035196)
185104 185104 191404 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Tulare St 14 Front Yard : Yard 7 Tree 1 Private 1     20     6016173.59275 2100299.3088 37.7479298037296 -122.3868196817 (37.7479298037296, -122.3868196817)
185081 185081 227680 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1541 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6003988.609540001 2099295.3111900003 37.7444908816604 -122.428883253577 (37.7444908816604, -122.428883253577)
184814 184814 207122 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 7 Front Yard : Yard 7 Tree 1 Private 1     12 Width 0ft   5991343.33969 2095670.4637 37.7338141267018 -122.47234340152399 (37.7338141267018, -122.472343401524)
184000 184000 186754 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5984863.7808 2106693.8 37.763704051609004 -122.49555761110202 (37.763704051609, -122.495557611102)
182990 182990 182942 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2671 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5982115.1 2096931.8144 37.736739035882394 -122.504341059874 (37.7367390358824, -122.504341059874)
182655 182655 186512 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1400 Lower Great Hwy 13 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5980899.8324 2105147.1675 37.7592245299801 -122.509152574968 (37.7592245299801, -122.509152574968)
182431 182431 218284 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 50x Junipero Serra Frontage West 0 Median : Yard 3 Tree 1 DPW 2     28     5991438.8932 2095398.7783700002 37.7330736770928 -122.4719932523 (37.7330736770928, -122.4719932523)
180846 180846 207121 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 8 Front Yard : Yard 7 Tree 1 Private 1     20 Width 0ft   5991346.9817 2095677.27593 37.733833042151105 -122.47233130655898 (37.7338330421511, -122.472331306559)
180188 180188 227692 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 75 Holly Park Cir 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6006684.36987 2096973.81613 37.738268789882795 -122.419397184857 (37.7382687898828, -122.419397184857)
179845 179845 207123 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 6 Front Yard : Yard 7 Tree 1 Private 1     21 Width 0ft   5991338.6165 2095665.48618 37.733800186326604 -122.472359368113 (37.7338001863266, -122.472359368113)
179459 179459 176985 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2571 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 2ft   5998574.332719999 2088565.20963 37.714720604140204 -122.44683269999399 (37.7147206041402, -122.446832699994)
179206 179206 176986 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 745 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6002864.08823 2089338.03726 37.7170867510327 -122.43206070495899 (37.7170867510327, -122.432060704959)
178737 178737 186058 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1901 Sunset Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984794.5256 2102183.7824 37.7513167410032 -122.495464490464 (37.7513167410032, -122.495464490464)
178473 178473 122182 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     5991497.785680001 2114857.01928 37.7865042639669 -122.473208256238 (37.7865042639669, -122.473208256238)
178438 178438 207120 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 9 Front Yard : Yard 7 Tree 1 Private 1     21 Width 0ft   5991349.86178 2095682.72956 37.7338481831293 -122.472321746778 (37.7338481831293, -122.472321746778)
178121 178121 47450 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 5049 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 7   Permit Number 45359 5982925.588409999 2111676.1494 37.7772704608477 -122.502629914355 (37.7772704608477, -122.502629914355)
178085 178085 227673 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1000 San Jose Ave 64 Front Yard : Yard 7 Tree 1 Private 1     12     6005078.09924 2097049.5351099998 37.738386096529204 -122.424956266738 (37.7383860965292, -122.424956266738)
177899 177899 191399 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2100 Alameda St 5 Front Yard : Yard 7 Tree 1 Private 1     5     6010727.66479 2107914.7241700003 37.7685370048986 -122.406188011877 (37.7685370048986, -122.406188011877)
177045 177045 191387 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 39 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 4ft   6011279.1597 2104155.2145599998 37.7582450689735 -122.40401582268801 (37.7582450689735, -122.404015822688)
176859 176859 191367 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 548 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 3ft   6011194.69766 2105791.5268900003 37.762733297531206 -122.404423107658 (37.7627332975312, -122.404423107658)
176854 176854 191389 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 43 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 9ft   6011309.9548 2104119.65272 37.758149144577104 -122.403906816767 (37.7581491445771, -122.403906816767)
176379 176379 129482 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 11 Greenwich St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8     6012315.37501 2120537.75286 37.803285568636 -122.401583532467 (37.803285568636, -122.401583532467)
175676 175676 176981 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2315 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 1ft   5999571.4621 2089300.9269299998 37.7167976306892 -122.44343903719299 (37.7167976306892, -122.443439037193)
175633 175633 176982 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2157 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 2ft   5999995.5387 2089705.6098099998 37.717932973520206 -122.442002247903 (37.7179329735202, -122.442002247903)
175563 175563 129481 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 11 Greenwich St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6012317.54236 2120532.7765200003 37.8032720257522 -122.401575682271 (37.8032720257522, -122.401575682271)
175448 175448 191392 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 845 Vermont St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6011311.05886 2104374.20224 37.7588481426559 -122.403920910926 (37.7588481426559, -122.403920910926)
174722 174722 207118 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 12 Front Yard : Yard 7 Tree 1 Private 1     27 Width 0ft   5991361.11034 2095702.06647 37.7339019284143 -122.472284266614 (37.7339019284143, -122.472284266614)
174088 174088 207100 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1325 18th Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5990476.61635 2106239.9997799997 37.762785111079396 -122.476111608564 (37.7627851110794, -122.476111608564)
174070 174070 129473 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 11 Filbert St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     6012532.2991 2120205.0438900003 37.8023841322847 -122.400809466192 (37.8023841322847, -122.400809466192)
173767 173767 83228 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 4234 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50748 5982916.47531802 2098139.9083931 37.740103232807705 -122.50165975231 (37.7401032328077, -122.50165975231)
173722 173722 227683 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 923 Capp St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6007409.880530001 2101914.88747 37.7518767015549 -122.41723875888201 (37.7518767015549, -122.417238758882)
173683 173683 191381 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 32 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6011271.17001 2104191.3624299997 37.7583438765916 -122.40404599854601 (37.7583438765916, -122.404045998546)
173361 173361 46399 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2110 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 5   Permit Number 44629 5981721.80383178 2100709.75793181 37.7470890826019 -122.505980852245 (37.7470890826019, -122.505980852245)
172830 172830 84447 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2266 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2008 12:00:00 AM 4 3x3 Permit Number 50738 5982378.18226568 2099687.61773546 37.744321183805106 -122.503635505549 (37.7443211838051, -122.503635505549)
172620 172620 191407 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Tulare St 7 Front Yard : Yard 7 Tree 1 Private 1     12     6016225.71134 2100306.15132 37.747951477381 -122.386639933312 (37.747951477381, -122.386639933312)
172179 172179 191388 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 40 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6011282.56063 2104153.62595 37.7582408970175 -122.40400394893 (37.7582408970175, -122.40400394893)
172053 172053 207129 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 4986 19th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5990655.7482 2093855.39662 37.7287905920011 -122.47458816511002 (37.7287905920011, -122.47458816511)
172032 172032 176987 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1278 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 5ft   6002815.8897 2094148.3870700002 37.7302921639516 -122.43257070868799 (37.7302921639516, -122.432570708688)
171868 171868 218294 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1 Woodacre Dr 18 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5991183.55146 2095353.09261 37.7329334566034 -122.472872697534 (37.7329334566034, -122.472872697534)
171831 171831 191396 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2100 Alameda St 2 Front Yard : Yard 7 Tree 1 Private 1     6     6010761.0499599995 2107917.30957 37.7685459711594 -122.40607271698799 (37.7685459711594, -122.406072716988)
171814 171814 129480 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 11 Greenwich St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     6012320.77236 2120522.45554 37.8032438670795 -122.401563778859 (37.8032438670795, -122.401563778859)
171720 171720 207111 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 59 Ralston St 2 Back Yard : Yard 13 Tree 1 Private 1     11     5992171.5605 2088305.6585 37.713640083085 -122.468944241206 (37.713640083085, -122.468944241206)
171541 171541 186059 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1901 Sunset Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984803.9529 2102180.8195 37.751309157700604 -122.495431671777 (37.7513091577006, -122.495431671777)
171269 171269 83239 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 4332 Pacheco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2008 12:00:00 AM 5 3x3 Permit Number 50745 5981564.36989544 2101497.47247657 37.749242657582705 -122.50658364702 (37.7492426575827, -122.50658364702)
171177 171177 207103 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 40 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   5995614.83933 2092751.51074 37.726045680348705 -122.457364540844 (37.7260456803487, -122.457364540844)
170757 170757 184168 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 3732 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   5982616.4158 2104253.9424 37.756873039994204 -122.503149769389 (37.7568730399942, -122.503149769389)
170082 170082 191380 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 30 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     6011289.9844 2104226.0484599997 37.7584401679041 -122.403983370659 (37.7584401679041, -122.403983370659)
169951 169951 183438 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2506 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5988326.6233 2098215.7152 37.7406276663345 -122.48295944841401 (37.7406276663345, -122.482959448414)
169634 169634 191405 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Tulare St 9 Front Yard : Yard 7 Tree 1 Private 1     8     6016216.75475 2100305.37684 37.7479488549636 -122.386670851103 (37.7479488549636, -122.386670851103)
169449 169449 191383 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 34 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 4ft   6011269.17641 2104180.10815 37.7583128634534 -122.404052101317 (37.7583128634534, -122.404052101317)
168815 168815 191391 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 845 Vermont St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6011306.2123 2104378.54497 37.7588597960547 -122.40393797827299 (37.7588597960547, -122.403937978273)
167635 167635 207136 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 100 : 4 Tree 1 Private 1     6 Width 0ft   5991240.31686 2092039.5475299999 37.723838576763896 -122.47243496690399 (37.7238385767639, -122.472434966904)
167106 167106 47850 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1342 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/14/2002 12:00:00 AM 7   Permit Number 45609 5983405.04544412 2106002.56953842 37.7617206013965 -122.50055173019501 (37.7617206013965, -122.500551730195)
166550 166550 227682 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 500 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6008186.7931 2096476.1256400002 37.7369867469298 -122.41416732857999 (37.7369867469298, -122.41416732858)
166033 166033 129485 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 12 Greenwich St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6012301.33061 2120559.21941 37.803343726885 -122.40163364357099 (37.803343726885, -122.401633643571)
165701 165701 42597 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1950 Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2000 12:00:00 AM 7   Permit Number 42667 6005420.67346 2116544.61332 37.7919342879744 -122.42515859980499 (37.7919342879744, -122.425158599805)
164753 164753 207116 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 47 Ralston St 9 Back Yard : Yard 13 Tree 1 Private 1     8     5992178.8337 2088240.4151599999 37.7134613608383 -122.46891435762801 (37.7134613608383, -122.468914357628)
164558 164558 138264 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2600 GEARY BLVD 32 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5999039.2359 2113177.9223 37.7823276740968 -122.44699593627199 (37.7823276740968, -122.446995936272)
164300 164300 186000 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1883 47th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5981612.0444 2102288.7145 37.7514179925848 -122.506477461595 (37.7514179925848, -122.506477461595)
164118 164118 191384 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 35 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   6011268.81564 2104171.75859 37.7582899172605 -122.40405276143 (37.7582899172605, -122.40405276143)
164114 164114 184169 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 3734 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 0ft   5982587.082 2104253.9424 37.7568713157118 -122.503251214898 (37.7568713157118, -122.503251214898)
163790 163790 227694 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 239 Caselli Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5999877.66163 2104769.07166 37.7592869569347 -122.44349114479401 (37.7592869569347, -122.443491144794)
163773 163773 83208 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 3634 Rivera St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2008 12:00:00 AM 7 3x3 Permit Number 50746 5981914.57527844 2100148.1004138 37.7455582728462 -122.505272655065 (37.7455582728462, -122.505272655065)
163400 163400 207139 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 208 Colon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996097.007130001 2094250.7795400003 37.7301899955731 -122.45580605711599 (37.7301899955731, -122.455806057116)
162968 162968 191403 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2100 Alameda St 9 Front Yard : Yard 7 Tree 1 Private 1     5     6010692.2016199995 2107913.0668 37.7685304704432 -122.40631055979601 (37.7685304704432, -122.406310559796)
162496 162496 207110 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 59 Ralston St 1 Back Yard : Yard 13 Tree 1 Private 1     7     5992170.63195 2088310.84387 37.7136542672107 -122.468947827707 (37.7136542672107, -122.468947827707)
161309 161309 207102 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1325 18th Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5990480.890819999 2106148.89617 37.7625352128593 -122.476090170539 (37.7625352128593, -122.476090170539)
160532 160532 38367 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 4245 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 5   Permit Number 41159 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224)
160044 160044 186041 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1900 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 0ft   5984992.0482 2102149.6578 37.7512346080754 -122.494778929254 (37.7512346080754, -122.494778929254)
159861 159861 227676 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 427 Valley St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6003106.32375 2099187.31259 37.7441443647786 -122.431926305762 (37.7441443647786, -122.431926305762)
159748 159748 191397 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2100 Alameda St 3 Front Yard : Yard 7 Tree 1 Private 1     9     6010751.13717 2107916.6697400003 37.768543659889005 -122.406106959582 (37.768543659889, -122.406106959582)
159286 159286 191372 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2220 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   6011446.77315 2104664.6622599997 37.7596532625069 -122.403471980161 (37.7596532625069, -122.403471980161)
159182 159182 78557 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2234 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2016 12:00:00 AM 3   Permit Number 771299 5981748.2661 2099861.5988 37.7447618317919 -122.505826480334 (37.7447618317919, -122.505826480334)
158536 158536 207119 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 10 Front Yard : Yard 7 Tree 1 Private 1     25 Width 0ft   5991353.65823 2095688.25461 37.733863573243205 -122.47230902406099 (37.7338635732432, -122.472309024061)
158119 158119 46395 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2091 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 9   Permit Number 44627 5981974.76389525 2100876.77542895 37.74756255280229 -122.505118527994 (37.7475625528023, -122.505118527994)
156319 156319 186749 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1200 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984860.385 2106678.2761 37.7636612284897 -122.495568210877 (37.7636612284897, -122.495568210877)
155355 155355 32594 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1379 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 1   Permit Number 37062 5985531.05347187 2105840.85496484 37.76140115330671 -122.49318691517 (37.7614011533067, -122.49318691517)
154916 154916 37082 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1268 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/15/2002 12:00:00 AM 6   Permit Number 44549 5982146.28824129 2106471.58463776 37.762934408685396 -122.504939947841 (37.7629344086854, -122.504939947841)
154704 154704 191400 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2100 Alameda St 6 Front Yard : Yard 7 Tree 1 Private 1     18     6010721.657430001 2107914.21049 37.76853525842721 -122.406208754734 (37.7685352584272, -122.406208754734)
154417 154417 191378 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 28 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6011285.84337 2104240.2990099997 37.7584790653842 -122.40399869511002 (37.7584790653842, -122.40399869511)
154113 154113 201278 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 28 Lydia Ave 1 : 4 Tree 1 Private 1     6 Width 2ft   6012862.05555 2092837.94578 37.7272585546286 -122.397747632568 (37.7272585546286, -122.397747632568)
154023 154023 207128 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 2 Cranleigh Dr 1 Front Yard : Yard 7 Tree 1 Private 1     15 Width 0ft   5991324.62806 2095649.6189400002 37.7337558092758 -122.472406573513 (37.7337558092758, -122.472406573513)
154014 154014 227691 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 309 Bocana St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6006868.9204400005 2097195.64462 37.7388882743696 -122.418774826116 (37.7388882743696, -122.418774826116)
153486 153486 207109 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 75 Ralston St 2 Back Yard : Yard 13 Tree 1 Private 1     14     5992170.77084 2088338.0326 37.713728928924105 -122.46894932506599 (37.7137289289241, -122.468949325066)
152713 152713 129469 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 1085 Vallejo St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 4ft   6008359.28826 2118585.88506 37.7977046844857 -122.415135501808 (37.7977046844857, -122.415135501808)
152532 152532 129478 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 12 Filbert St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17     6012509.68294 2120230.66756 37.80245322719529 -122.400889531035 (37.8024532271953, -122.400889531035)
152163 152163 207138 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 700 Junipero Serra Blvd 123 : 4 Tree 1 Private 1     8 Width 0ft   5991217.227519999 2091775.34767 37.7231118130309 -122.472495529957 (37.7231118130309, -122.472495529957)
151607 151607 191377 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 800 Vermont St 27 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16     6011285.82751 2104250.98235 37.75850839857429 -122.40399950177601 (37.7585083985743, -122.403999501776)

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