Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 208 | 208 | 100305 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3701 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003064.411830001 | 2121045.8637900003 | 37.804160163827206 | -122.433633107497 | (37.8041601638272, -122.433633107497) | |||
| 467 | 467 | 85277 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 801 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49566 | ||||||||
| 824 | 824 | 175557 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 80X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | Width 3ft | 5991341.18573 | 2088991.3817 | 37.71547490063521 | -122.471864234655 | (37.7154749006352, -122.471864234655) | ||
| 1069 | 1069 | 80004 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 881 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2017 12:00:00 AM | 3 | Permit Number 779791 | 5982299.17664 | 2109781.12407 | 37.772030443625795 | -122.504656395048 | (37.7720304436258, -122.504656395048) | |
| 1621 | 1621 | 88501 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1599 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51438 | 6015120.9647 | 2094333.0532 | 37.7314893544439 | -122.390042929541 | (37.7314893544439, -122.390042929541) | |
| 2212 | 2212 | 204345 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 44 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 13 | Width 3ft | Permit Number 46258 | 5995599.60309 | 2092472.80372 | 37.7252795425123 | -122.45739705673 | (37.7252795425123, -122.45739705673) | |
| 2752 | 2752 | 204285 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 130 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2016 12:00:00 AM | 0 | Width 4ft | Permit Number 778704 | 5994440.258090001 | 2105345.9021900003 | 37.7605591918785 | -122.462338019278 | (37.7605591918785, -122.462338019278) | |
| 3364 | 3364 | 188226 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 3 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013575.41694 | 2105253.06849 | 37.7613875637091 | -122.396151246903 | (37.7613875637091, -122.396151246903) | |
| 3371 | 3371 | 188225 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 2 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 6 | Width 3ft | Permit Number 37286 | 6013591.2999599995 | 2105254.0413599997 | 37.7613911187249 | -122.396096381957 | (37.7613911187249, -122.396096381957) | |
| 3379 | 3379 | 188227 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1350 19th St | 4 | : 4 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | 5 | Width 3ft | Permit Number 37286 | 6013561.10942 | 2105252.84027 | 37.7613861409778 | -122.39620071499901 | (37.7613861409778, -122.396200714999) | |
| 3441 | 3441 | 32703 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 890 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37106 | 6007477.85623 | 2114415.95786 | 37.7862055211206 | -122.417889760126 | (37.7862055211206, -122.417889760126) |
| 6342 | 6342 | 30510 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2774 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2016 12:00:00 AM | 3 | 6x7 | Permit Number 778747 | 5999768.8918 | 2117782.75925 | 37.7950130117898 | -122.444802762862 | (37.7950130117898, -122.444802762862) | |
| 6505 | 6505 | 20152 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1057 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1997 12:00:00 AM | 12 | 3X3 | 6002876.4729 | 2111952.9425 | 37.7791826693541 | -122.433633233262 | (37.7791826693541, -122.433633233262) | ||
| 6578 | 6578 | 9618 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2000 12:00:00 AM | 7 | 3X3 | 6002831.8444 | 2112032.7875 | 37.7793993714118 | -122.43379332982599 | (37.7793993714118, -122.433793329826) | ||
| 10426 | 10426 | 108779 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005562.18075 | 2088048.73923 | 37.7136992126121 | -122.422643108799 | (37.7136992126121, -122.422643108799) |
| 10430 | 10430 | 86483 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1706 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987833.1754 | 2103641.2255 | 37.7554959453769 | -122.48506354557101 | (37.7554959453769, -122.485063545571) | ||
| 10488 | 10488 | 86479 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1750 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103389.1385 | 37.7548041785464 | -122.485021542908 | (37.7548041785464, -122.485021542908) | ||
| 10629 | 10629 | 108781 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005591.90568 | 2088038.18998 | 37.7136719236049 | -122.422539619323 | (37.7136719236049, -122.422539619323) |
| 10877 | 10877 | 86480 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1742 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987841.1062 | 2103418.0293 | 37.754883570877105 | -122.485019744249 | (37.7548835708771, -122.485019744249) | ||
| 10966 | 10966 | 86558 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1867 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 7 | 3x3 | 5987816.4554 | 2102586.0208 | 37.7525976639013 | -122.48504395302 | (37.7525976639013, -122.48504395302) | ||
| 11268 | 11268 | 86482 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1722 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987834.8749 | 2103544.3561 | 37.7552300671815 | -122.48505056143499 | (37.7552300671815, -122.485050561435) | ||
| 11450 | 11450 | 86561 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1891 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987822.6937 | 2102437.7427 | 37.7521908954775 | -122.485011502397 | (37.7521908954775, -122.485011502397) | ||
| 11831 | 11831 | 86477 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1754 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987839.9732 | 2103364.7795 | 37.754737295309 | -122.485019755857 | (37.754737295309, -122.485019755857) | ||
| 12330 | 12330 | 108783 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005623.18894 | 2088028.7554099998 | 37.7136477830893 | -122.42243082291901 | (37.7136477830893, -122.422430822919) |
| 15921 | 15921 | 29468 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1613 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/05/2015 07:24:00 AM | 3 | 3X3 | 6016802.5034 | 2093317.3698 | 37.7287936059494 | -122.384158766122 | (37.7287936059494, -122.384158766122) | ||
| 17785 | 17785 | 32763 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1754 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778589 | 6009301.89278 | 2099228.78566 | 37.7446075228294 | -122.410506232583 | (37.7446075228294, -122.410506232583) | |
| 18354 | 18354 | 29366 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2012 12:00:00 AM | 3 | 3X3 | 5992064.02141 | 2096527.0918599998 | 37.7362078962607 | -122.46991416090599 | (37.7362078962607, -122.469914160906) | ||
| 18576 | 18576 | 29362 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5991983.966469999 | 2096447.7248099998 | 37.7359853464519 | -122.470185163514 | (37.7359853464519, -122.470185163514) | ||
| 19218 | 19218 | 29363 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2009 12:00:00 AM | 3 | 3X3 | 5992002.78104 | 2096471.37185 | 37.736051362971004 | -122.470121835975 | (37.736051362971, -122.470121835975) | ||
| 19222 | 19222 | 29357 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991847.829940001 | 2096308.81938 | 37.7355960757897 | -122.470645723443 | (37.7355960757897, -122.470645723443) | ||
| 19378 | 19378 | 27278 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005367.959369999 | 2108416.37045 | 37.7696131525447 | -122.424762488 | (37.7696131525447, -122.424762488) | |||
| 19384 | 19384 | 27275 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005306.02285 | 2108414.57657 | 37.7696047286145 | -122.424976596817 | (37.7696047286145, -122.424976596817) | |||
| 19510 | 19510 | 122456 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1355x 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013550.0 | 2105274.0 | 37.7614436228031 | -122.39624062117399 | (37.7614436228031, -122.396240621174) | ||||
| 19782 | 19782 | 67081 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 345 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | Permit Number 30479 | 6006832.91402463 | 2097113.31465906 | 37.7386601871907 | -122.418893482297 | (37.7386601871907, -122.418893482297) | ||
| 20563 | 20563 | 29361 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991939.73246 | 2096403.05712 | 37.735860142840096 | -122.470334844889 | (37.7358601428401, -122.470334844889) | ||
| 20784 | 20784 | 27276 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 223X Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005326.21516 | 2108415.83453 | 37.7696093232375 | -122.424906841772 | (37.7696093232375, -122.424906841772) | |||
| 20795 | 20795 | 29365 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992050.3612 | 2096514.70328 | 37.7361730907045 | -122.46996048768601 | (37.7361730907045, -122.469960487686) | ||
| 20905 | 20905 | 46594 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2138 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2002 12:00:00 AM | Permit Number 44723 | 5991340.38326484 | 2100857.00751715 | 37.748054878059705 | -122.472731661639 | (37.7480548780597, -122.472731661639) | |||
| 20927 | 20927 | 27318 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 326 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5993116.17703 | 2089857.5003900002 | 37.7179555995549 | -122.465792014904 | (37.7179555995549, -122.465792014904) | |||
| 20965 | 20965 | 29364 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992027.40322 | 2096494.06765 | 37.7361151033221 | -122.470038359996 | (37.7361151033221, -122.470038359996) | ||
| 21608 | 21608 | 19327 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 230 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5993348.8476 | 2089853.7551099998 | 37.717958734599705 | -122.46498750927601 | (37.7179587345997, -122.464987509276) | |||
| 21756 | 21756 | 29359 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991917.55406 | 2096377.82265 | 37.735789573027205 | -122.470409686474 | (37.7357895730272, -122.470409686474) | ||
| 22089 | 22089 | 29358 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991885.18 | 2096342.85411 | 37.735691686328295 | -122.470519069219 | (37.7356916863283, -122.470519069219) | ||
| 22144 | 22144 | 2049 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 701X Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001977.73953 | 2095412.31759 | 37.733715061000204 | -122.43555868909901 | (37.7337150610002, -122.435558689099) | |||
| 22167 | 22167 | 29360 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991958.47705 | 2096423.3893400002 | 37.73591705373521 | -122.470271518219 | (37.7359170537352, -122.470271518219) | ||
| 22191 | 22191 | 29356 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 1600X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5991811.277419999 | 2096273.10994 | 37.7354959129041 | -122.47076949802201 | (37.7354959129041, -122.470769498022) | ||
| 22355 | 22355 | 204264 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992423.56649 | 2104856.18392 | 37.7590982216204 | -122.469277127955 | (37.7590982216204, -122.469277127955) | |||
| 22943 | 22943 | 115613 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 22952 | 22952 | 115614 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1400 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | ||
| 23602 | 23602 | 221152 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1107 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997675.68991 | 2106703.68443 | 37.7644730917729 | -122.45124611571899 | (37.7644730917729, -122.451246115719) | |||
| 23628 | 23628 | 185802 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2612 Pacheco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5986872.5715 | 2101682.5627 | 37.7500619869815 | -122.488241637782 | (37.7500619869815, -122.488241637782) | |||
| 23955 | 23955 | 204246 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 81 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997506.8200199995 | 2099205.04953 | 37.7438740375718 | -122.45128934072399 | (37.7438740375718, -122.451289340724) | |||
| 23966 | 23966 | 221105 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009452.05657 | 2105439.4087799997 | 37.761668922891296 | -122.41042544467301 | (37.7616689228913, -122.410425444673) | |||
| 24322 | 24322 | 125703 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 23 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008909.16091 | 2116830.53076 | 37.7929157990679 | -122.4131085999 | (37.7929157990679, -122.4131085999) | |||
| 24343 | 24343 | 204238 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 318 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992991.89309 | 2103254.47145 | 37.7547331606106 | -122.467195142542 | (37.7547331606106, -122.467195142542) | |||
| 24410 | 24410 | 204341 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 102 San Ramon Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995790.71137 | 2092717.35001 | 37.725961983138596 | -122.45675409635 | (37.7259619831386, -122.45675409635) | |||
| 24588 | 24588 | 125698 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2107 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5999370.9628800005 | 2116081.41447 | 37.7903188519859 | -122.446057218191 | (37.7903188519859, -122.446057218191) | |||
| 24623 | 24623 | 204297 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 509 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991637.536280001 | 2099057.6971400003 | 37.7431316319124 | -122.471573030598 | (37.7431316319124, -122.471573030598) | |||
| 24672 | 24672 | 61260 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 445 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | Permit Number 21147 | 6007898.64601891 | 2096796.82911577 | 37.737851139099 | -122.41518627959299 | (37.737851139099, -122.415186279593) | ||
| 24810 | 24810 | 125700 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 900 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007433.50155 | 2114436.05545 | 37.786258207895706 | -122.418044641354 | (37.7862582078957, -122.418044641354) | |||
| 25164 | 25164 | 221116 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 444 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008032.554719999 | 2096752.52732 | 37.7377370207421 | -122.414720156219 | (37.7377370207421, -122.414720156219) | |||
| 25324 | 25324 | 204254 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 81 Elmhurst Dr | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991110.1119800005 | 2094515.36236 | 37.7306290086229 | -122.473065523856 | (37.7306290086229, -122.473065523856) | |||
| 25419 | 25419 | 205555 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 18 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996627.05055 | 2093785.0930599999 | 37.7289417374555 | -122.45394001961701 | (37.7289417374555, -122.453940019617) | |||
| 25859 | 25859 | 221159 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 72 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007370.31333 | 2098939.53779 | 37.743704835509796 | -122.417164776158 | (37.7437048355098, -122.417164776158) | |||
| 26711 | 26711 | 204314 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 256 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5992041.21842 | 2097983.95743 | 37.740206762332704 | -122.47009904983801 | (37.7402067623327, -122.470099049838) | |||
| 26801 | 26801 | 221170 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 82 Hancock St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6003717.37028 | 2105106.00276 | 37.7604303181269 | -122.430235612701 | (37.7604303181269, -122.430235612701) | |||
| 27026 | 27026 | 52825 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 323 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 2 | Permit Number 48850 | 5987743.22888 | 2113770.24482 | 37.7833021825875 | -122.486118118549 | (37.7833021825875, -122.486118118549) | ||
| 27077 | 27077 | 50163 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2127WASHINGTON Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2003 12:00:00 AM | 4 | Permit Number 46876 | 6000341.02119 | 2116095.30485 | 37.7904123382987 | -122.442701892589 | (37.7904123382987, -122.442701892589) | ||
| 27666 | 27666 | 183543 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2581 25th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5988605.1751 | 2097774.8752 | 37.7394334392266 | -122.481964049119 | (37.7394334392266, -122.481964049119) | |||
| 27729 | 27729 | 204333 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 351 Kenwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993563.47012 | 2093605.7563900002 | 37.72827319225029 | -122.464517939956 | (37.7282731922503, -122.464517939956) | |||
| 28051 | 28051 | 204348 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1274 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995861.784 | 2092564.0492599998 | 37.7255451365929 | -122.456497323712 | (37.7255451365929, -122.456497323712) | |||
| 28060 | 28060 | 204303 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2663 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990796.60271 | 2097278.2689900002 | 37.7381970923259 | -122.47435090236701 | (37.7381970923259, -122.474350902367) | |||
| 28073 | 28073 | 221120 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 326 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008611.309880001 | 2097158.27133 | 37.7388836059924 | -122.41274779008499 | (37.7388836059924, -122.412747790085) | |||
| 28228 | 28228 | 205559 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 24 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995247.107919999 | 2100152.69765 | 37.74634639618 | -122.45917145420601 | (37.74634639618, -122.459171454206) | |||
| 28253 | 28253 | 247297 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 251 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002733.6666 | 2109491.8212 | 37.7724169385487 | -122.43395128968099 | (37.7724169385487, -122.433951289681) | |||
| 28456 | 28456 | 183540 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1412 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988533.1723 | 2097656.6869 | 37.739104737168105 | -122.48220434364299 | (37.7391047371681, -122.482204343643) | |||
| 28594 | 28594 | 35262 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2231 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 10 | Permit Number 38747 | 6006326.183230001 | 2118540.89021 | 37.797466675306104 | -122.42216741420499 | (37.7974666753061, -122.422167414205) | |
| 28775 | 28775 | 125696 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3011 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000243.1729999995 | 2116103.47647 | 37.7904291970031 | -122.44304102692399 | (37.7904291970031, -122.443041026924) | |||
| 29030 | 29030 | 205556 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 40 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995160.10892 | 2100068.40682 | 37.746109952717 | -122.45946618093299 | (37.746109952717, -122.459466180933) | |||
| 29270 | 29270 | 125699 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2107 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5999372.165130001 | 2116056.16018 | 37.79024957900621 | -122.446051241271 | (37.7902495790062, -122.446051241271) | |||
| 29548 | 29548 | 204248 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 547 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996224.70545 | 2089880.3826 | 37.7181972518712 | -122.455048908902 | (37.7181972518712, -122.455048908902) | |||
| 29668 | 29668 | 205564 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1570 07th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994021.91378 | 2104924.9541599997 | 37.7593792795413 | -122.46375431661501 | (37.7593792795413, -122.463754316615) | |||
| 30304 | 30304 | 125706 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008674.29968 | 2116820.86226 | 37.7928760643434 | -122.41392055009199 | (37.7928760643434, -122.413920550092) | |||
| 30365 | 30365 | 204312 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 156 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992641.06046 | 2098150.29955 | 37.7406981546001 | -122.468037152598 | (37.7406981546001, -122.468037152598) | |||
| 30473 | 30473 | 221155 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 449 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008058.6001 | 2096752.2718 | 37.7377377824817 | -122.41463008643 | (37.7377377824817, -122.41463008643) | |||
| 30708 | 30708 | 221176 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 398 Surrey St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6001072.81046 | 2096163.63119 | 37.735726554821504 | -122.43874110741899 | (37.7357265548215, -122.438741107419) | |||
| 30971 | 30971 | 188230 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6012869.68369 | 2113682.0678 | 37.784492396237 | -122.39918379321001 | (37.784492396237, -122.39918379321) | |||
| 31054 | 31054 | 205576 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993987.58227 | 2096991.7389900002 | 37.737594705717896 | -122.463297378285 | (37.7375947057179, -122.463297378285) | |||
| 31337 | 31337 | 125710 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 944 Vallejo St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6009006.53902 | 2118723.89067 | 37.798119966232704 | -122.412905591427 | (37.7981199662327, -122.412905591427) | ||||
| 31851 | 31851 | 188228 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 602 Arthur Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015950.839319999 | 2099751.9631 | 37.746414570195704 | -122.387551780196 | (37.7464145701957, -122.387551780196) | ||||
| 31995 | 31995 | 204340 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 102 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5995780.03889 | 2092724.36521 | 37.7259806323898 | -122.456791497325 | (37.7259806323898, -122.456791497325) | |||
| 32074 | 32074 | 204315 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 140 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992371.69102 | 2098164.25102 | 37.740720902060204 | -122.468969536415 | (37.7407209020602, -122.468969536415) | |||
| 32146 | 32146 | 204250 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 535 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996278.68243 | 2089878.5277599997 | 37.7181952553759 | -122.45486220065399 | (37.7181952553759, -122.454862200654) | |||
| 32233 | 32233 | 204292 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 128 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 5993577.25837 | 2103274.10161 | 37.7548208328355 | -122.465172231806 | (37.7548208328355, -122.465172231806) | |||
| 32431 | 32431 | 204346 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1280 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995860.5873 | 2092590.7127099999 | 37.7256182793497 | -122.45650338783399 | (37.7256182793497, -122.456503387834) | |||
| 32639 | 32639 | 205566 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 7 Locksley Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994170.44899 | 2104994.66764 | 37.759579252803505 | -122.463245671761 | (37.7595792528035, -122.463245671761) | |||
| 32937 | 32937 | 40207 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 543 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 11 | Permit Number 41389 | 5982528.29213 | 2112062.1562099997 | 37.7783069675702 | -122.504032865431 | (37.7783069675702, -122.504032865431) | |
| 33243 | 33243 | 204317 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 120 Merced Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5994559.82289 | 2099500.03958 | 37.7445148251981 | -122.461500679435 | (37.7445148251981, -122.461500679435) | |||
| 33477 | 33477 | 221124 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 355 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007210.69865 | 2096548.51088 | 37.737130625862704 | -122.41754726049801 | (37.7371306258627, -122.417547260498) | |||
| 33880 | 33880 | 221109 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 119 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010247.14882 | 2100206.80415 | 37.7473458954989 | -122.407306641714 | (37.7473458954989, -122.407306641714) |
JSON shape: default, array, newline-delimited
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");