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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63245 | 63245 | 71602 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 149 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994628.01123 | 2086360.41662 | 37.7084405258897 | -122.46031306439899 | (37.7084405258897, -122.460313064399) | ||
| 57495 | 57495 | 71603 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 171 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994523.67906 | 2086453.64687 | 37.708690512219206 | -122.460680397897 | (37.7086905122192, -122.460680397897) | ||
| 120051 | 120051 | 175838 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994346.0156 | 2086520.6232200002 | 37.708864190212296 | -122.461299273568 | (37.7088641902123, -122.461299273568) | |||
| 149597 | 149597 | 175837 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | |||
| 892 | 892 | 251400 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | ||||
| 171265 | 171265 | 175835 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | |||
| 166100 | 166100 | 71685 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 249 Wilson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 6 | 5994260.16312 | 2086694.7455400003 | 37.7093373478025 | -122.461608605251 | (37.7093373478025, -122.461608605251) | ||
| 47789 | 47789 | 73626 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 249 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994249.9774400005 | 2086699.51142 | 37.7093498474797 | -122.461644153659 | (37.7093498474797, -122.461644153659) | ||
| 70259 | 70259 | 71645 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 193 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994617.0264 | 2086718.3617900002 | 37.7094227276519 | -122.460376946856 | (37.7094227276519, -122.460376946856) | ||
| 64137 | 64137 | 75992 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 188 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 5 | 5994660.40681 | 2086732.9831599998 | 37.7094653698917 | -122.46022807666401 | (37.7094653698917, -122.460228076664) | ||
| 172727 | 172727 | 175831 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994675.09306 | 2086785.5883900002 | 37.7096106562906 | -122.460181127555 | (37.7096106562906, -122.460181127555) | |||
| 61421 | 61421 | 175833 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994704.65642 | 2086785.9340000001 | 37.709613305686 | -122.46007897716999 | (37.709613305686, -122.46007897717) | |||
| 46896 | 46896 | 175829 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5994644.581040001 | 2086786.22758 | 37.709610656266996 | -122.460286627948 | (37.709610656267, -122.460286627948) | |||
| 174401 | 174401 | 175830 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994659.60487 | 2086786.3953 | 37.7096119809882 | -122.460234715484 | (37.7096119809882, -122.460234715484) | |||
| 55877 | 55877 | 175834 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994720.17465 | 2086786.5738400002 | 37.7096159550821 | -122.460025390159 | (37.7096159550821, -122.460025390159) | |||
| 34939 | 34939 | 175832 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 71 De Long St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5994691.10568 | 2086786.7003099998 | 37.709614630390604 | -122.460125866041 | (37.7096146303906, -122.460125866041) | |||
| 126483 | 126483 | 49776 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 110 Talbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46562 | 6010272.64518115 | 2086887.71649918 | 37.710775910974704 | -122.406280195673 | (37.7107759109747, -122.406280195673) | ||
| 154306 | 154306 | 49782 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 327 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | 11 | Permit Number 46567 | 6012093.71999 | 2087090.7414400002 | 37.711435076735 | -122.40000035424801 | (37.711435076735, -122.400000354248) | |
| 67016 | 67016 | 205980 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 121 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995564.77238 | 2087377.85645 | 37.7112880204943 | -122.457149074963 | (37.7112880204943, -122.457149074963) | |||
| 18521 | 18521 | 19046 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 115 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5995705.68255 | 2087377.98209 | 37.711296457039204 | -122.45666206600201 | (37.7112964570392, -122.456662066002) | |||
| 130681 | 130681 | 175825 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1669 Geneva Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6003581.23003 | 2087608.2042099999 | 37.7123776381814 | -122.429458597533 | (37.7123776381814, -122.429458597533) | |||
| 179819 | 179819 | 175826 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1669 Geneva Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6003554.6564 | 2087615.13702 | 37.712395169585704 | -122.429550938144 | (37.7123951695857, -122.429550938144) | |||
| 157528 | 157528 | 175827 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1669 Geneva Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6003539.767469999 | 2087618.6367900001 | 37.7124039361582 | -122.42960264823999 | (37.7124039361582, -122.42960264824) | |||
| 51627 | 51627 | 49757 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1360 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 7 | Permit Number 46553 | 6011586.487000001 | 2088506.8492599998 | 37.7152951315438 | -122.40185297295601 | (37.7152951315438, -122.401852972956) | |
| 67587 | 67587 | 175828 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 490 Harkness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010182.474880001 | 2089702.17663 | 37.7184987999604 | -122.406790070203 | (37.7184987999604, -122.406790070203) | |||
| 138719 | 138719 | 46864 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 96 Athens St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | ||
| 185225 | 185225 | 46860 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 96 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44930 | 6005007.55179 | 2092712.98729 | 37.726474917775896 | -122.424891746668 | (37.7264749177759, -122.424891746668) | ||
| 166330 | 166330 | 175839 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 728 Burrows St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009068.666680001 | 2092869.3876 | 37.7271329121485 | -122.41086362855101 | (37.7271329121485, -122.410863628551) | |||
| 37424 | 37424 | 40707 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 49 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 9 | Permit Number 41686 | 6002532.07349 | 2093390.4237799998 | 37.728194869385796 | -122.433497753227 | (37.7281948693858, -122.433497753227) | |
| 131526 | 131526 | 78188 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 61 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 5 | 6007814.1581 | 2093767.18412 | 37.7295276448871 | -122.415263990666 | (37.7295276448871, -122.415263990666) | ||
| 15757 | 15757 | 78202 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014063.31576 | 2094176.7375400001 | 37.731001427778395 | -122.393688515509 | (37.7310014277784, -122.393688515509) | |
| 16070 | 16070 | 78322 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014069.278530001 | 2094204.9289400002 | 37.7310791669665 | -122.393669873461 | (37.7310791669665, -122.393669873461) | |
| 13640 | 13640 | 78324 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014075.45071 | 2094231.93865 | 37.731153673106796 | -122.393650424725 | (37.7311536731068, -122.393650424725) | |
| 29660 | 29660 | 74449 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 21 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2000 12:00:00 AM | 9 | 6014188.34415 | 2094602.28938 | 37.732176853381205 | -122.393286035632 | (37.7321768533812, -122.393286035632) | ||
| 16461 | 16461 | 51365 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.39340338185801 | (37.7322472522973, -122.393403381858) |
| 15170 | 15170 | 51367 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52508 | 6014166.48709 | 2094684.74927 | 37.732402057093296 | -122.39336736943001 | (37.7324020570933, -122.39336736943) |
| 16516 | 16516 | 51368 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 03/12/2005 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.092119999 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) |
| 90110 | 90110 | 42464 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 673 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42606 | 5996989.53231216 | 2095248.10603498 | 37.7329795980092 | -122.452792452541 | (37.7329795980092, -122.452792452541) | ||
| 181880 | 181880 | 222876 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6003060.85114 | 2095475.7145 | 37.7339505925395 | -122.431818580457 | (37.7339505925395, -122.431818580457) | |||
| 115591 | 115591 | 41704 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.733954758005794 | -122.431850206764 | (37.7339547580058, -122.431850206764) | ||
| 140537 | 140537 | 41705 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.733954758005794 | -122.431850206764 | (37.7339547580058, -122.431850206764) | ||
| 170113 | 170113 | 222875 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003058.60804 | 2095498.12618 | 37.7340120027534 | -122.43182793522301 | (37.7340120027534, -122.431827935223) | |||
| 129164 | 129164 | 35972 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 323 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39130 | 6006883.86528874 | 2096321.14092587 | 37.7364879223661 | -122.41866115506399 | (37.7364879223661, -122.418661155064) | ||
| 152099 | 152099 | 188457 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017980.56674 | 2096851.4508 | 37.738562560606105 | -122.38033159384199 | (37.7385625606061, -122.380331593842) | |||
| 147749 | 147749 | 188458 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017965.45294 | 2096866.00027 | 37.7386016766138 | -122.38038486158001 | (37.7386016766138, -122.38038486158) | |||
| 25929 | 25929 | 188459 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1300 Evans Ave | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017898.8154 | 2096917.7474099998 | 37.7387400867836 | -122.38061886067499 | (37.7387400867836, -122.380618860675) | |||
| 9602 | 9602 | 40720 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 36 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 770949 | 6009333.47018643 | 2097251.8201173 | 37.7391809774349 | -122.41025748834998 | (37.7391809774349, -122.41025748835) | ||
| 55015 | 55015 | 222871 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 51 Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6005724.8358 | 2097421.61611 | 37.7394442577386 | -122.422746599186 | (37.7394442577386, -122.422746599186) | |||
| 49111 | 49111 | 40430 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 242 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1999 12:00:00 AM | Permit Number 41525 | 6007877.26148184 | 2097485.40267829 | 37.7397406088372 | -122.415308947554 | (37.7397406088372, -122.415308947554) | ||
| 129865 | 129865 | 222882 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1857 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004605.27602 | 2097916.14759 | 37.740738898373706 | -122.42665275413201 | (37.7407388983737, -122.426652754132) | |||
| 81997 | 81997 | 47695 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1857 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45494 | 6004612.55463086 | 2097920.97092871 | 37.7407525536623 | -122.42662793081999 | (37.7407525536623, -122.42662793082) | ||
| 139079 | 139079 | 50085 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 169 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46817 | 5992373.11163098 | 2098031.46456186 | 37.7403563861764 | -122.468954963559 | (37.7403563861764, -122.468954963559) | ||
| 91541 | 91541 | 35990 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 222 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | 3x3 | Permit Number 39141 | 6006789.604255901 | 2098298.49411338 | 37.7419119870032 | -122.41912727155199 | (37.7419119870032, -122.419127271552) | |
| 162578 | 162578 | 205979 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 44 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993573.64628 | 2099229.5165 | 37.743715225367104 | -122.46489100842301 | (37.7437152253671, -122.464891008423) | |||
| 130456 | 130456 | 205978 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 26 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993683.84565 | 2099240.9868799997 | 37.7437530733501 | -122.464510801149 | (37.7437530733501, -122.464510801149) | |||
| 123628 | 123628 | 37175 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 681 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39748 | 6005894.17436162 | 2099270.44010947 | 37.7445302641925 | -122.42229242265101 | (37.7445302641925, -122.422292422651) | ||
| 85731 | 85731 | 26664 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 681 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/1997 12:00:00 AM | 12 | 3X3 | 6005893.217896201 | 2099270.732028 | 37.7445310117825 | -122.422295750657 | (37.7445310117825, -122.422295750657) | ||
| 187532 | 187532 | 222870 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 25 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007227.82526 | 2099384.75669 | 37.744919289898604 | -122.417689017034 | (37.7449192898986, -122.417689017034) | |||
| 117622 | 117622 | 36005 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 315 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39154 | 6008606.55118779 | 2100215.49511804 | 37.7472778014217 | -122.412980345984 | (37.7472778014217, -122.412980345984) | ||
| 154453 | 154453 | 222872 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 4250 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002245.78823 | 2100636.8852 | 37.7480757286172 | -122.435005495434 | (37.7480757286172, -122.435005495434) | |||
| 99287 | 99287 | 37428 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1223 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39903 | 6003243.0646952 | 2101122.55260682 | 37.749465833086205 | -122.431591620497 | (37.7494658330862, -122.431591620497) | ||
| 104311 | 104311 | 52258 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48424 | 6005350.78664261 | 2101935.57102078 | 37.75181743534829 | -122.424360871513 | (37.7518174353483, -122.424360871513) | ||
| 116229 | 116229 | 52257 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48424 | 6005350.78664261 | 2101935.57102078 | 37.75181743534829 | -122.424360871513 | (37.7518174353483, -122.424360871513) | ||
| 120629 | 120629 | 52213 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2005 12:00:00 AM | Permit Number 48396 | 6005350.78664261 | 2101935.57102078 | 37.75181743534829 | -122.424360871513 | (37.7518174353483, -122.424360871513) | |||
| 126665 | 126665 | 52212 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3667 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2005 12:00:00 AM | Permit Number 48396 | 6005350.78664261 | 2101935.57102078 | 37.75181743534829 | -122.424360871513 | (37.7518174353483, -122.424360871513) | |||
| 73171 | 73171 | 222867 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3665 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005333.3615 | 2101936.42428 | 37.751818794216206 | -122.424421190788 | (37.7518187942162, -122.424421190788) | |||
| 150703 | 150703 | 222868 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3665 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005340.76956 | 2101936.5260900003 | 37.7518194920941 | -122.42439557991699 | (37.7518194920941, -122.424395579917) | |||
| 23700 | 23700 | 222864 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008644.3268 | 2102383.5696 | 37.753232969139795 | -122.413002991602 | (37.7532329691398, -122.413002991602) | |||
| 107637 | 107637 | 37019 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39631 | 6008654.53435588 | 2102395.73728972 | 37.753266951872 | -122.41296855192302 | (37.753266951872, -122.412968551923) | ||
| 109821 | 109821 | 37018 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1057 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39631 | 6008654.53435588 | 2102395.73728972 | 37.753266951872 | -122.41296855192302 | (37.753266951872, -122.412968551923) | ||
| 91636 | 91636 | 40256 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3625 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2006 12:00:00 AM | Permit Number 41416 | 6005635.54182208 | 2102533.13348143 | 37.7534742792296 | -122.42341862495 | (37.7534742792296, -122.42341862495) | ||
| 106226 | 106226 | 40255 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3625 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41416 | 6005635.54182208 | 2102533.13348143 | 37.7534742792296 | -122.42341862495 | (37.7534742792296, -122.42341862495) | ||
| 136116 | 136116 | 222865 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3625 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005579.30004 | 2102535.69949 | 37.7534781504092 | -122.423613303727 | (37.7534781504092, -122.423613303727) | |||
| 37407 | 37407 | 222866 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3625 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005593.12032 | 2102536.33181 | 37.753480666708704 | -122.423565555132 | (37.7534806667087, -122.423565555132) | |||
| 186635 | 186635 | 222873 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 4354 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000914.513259999 | 2103313.56277 | 37.7553495604475 | -122.439800863126 | (37.7553495604475, -122.439800863126) | |||
| 81403 | 81403 | 52318 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 4354DOUGLASS 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2005 12:00:00 AM | Permit Number 48474 | 6000907.18250943 | 2103314.58552811 | 37.7553519514145 | -122.439826288335 | (37.7553519514145, -122.439826288335) | ||
| 164317 | 164317 | 222874 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 462 Romain St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6001154.00187 | 2103552.8212599996 | 37.7560201354351 | -122.43898978706999 | (37.7560201354351, -122.43898978707) | |||
| 21964 | 21964 | 52299 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 46221st ST. Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/01/2005 12:00:00 AM | Permit Number 48460 | 6001157.72665298 | 2103563.59755974 | 37.7560499364738 | -122.438977677821 | (37.7560499364738, -122.438977677821) | ||
| 99424 | 99424 | 48741 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 964 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | Permit Number 46597 | 6009929.68094635 | 2103590.07459933 | 37.7566178319635 | -122.40864306235001 | (37.7566178319635, -122.40864306235) | ||
| 158361 | 158361 | 184174 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1655 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5985601.1485 | 2103943.8243 | 37.7561965316146 | -122.492804758993 | (37.7561965316146, -122.492804758993) | |||
| 58198 | 58198 | 37963 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 655 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 11 | Permit Number 40194 | 6014150.1956400005 | 2104114.25281 | 37.75829258736211 | -122.39408358501001 | (37.7582925873621, -122.39408358501) | |
| 178818 | 178818 | 205977 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1624 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5993106.31442 | 2104408.61975 | 37.7579087567066 | -122.466883344019 | (37.7579087567066, -122.466883344019) | |||
| 117240 | 117240 | 48945 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 819 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46132 | 6009934.90888897 | 2104445.04060173 | 37.758965669214795 | -122.408685294891 | (37.7589656692148, -122.408685294891) | ||
| 78946 | 78946 | 34015 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1570 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46940 | 5986558.24673304 | 2104566.10079282 | 37.7579610536344 | -122.48954058892001 | (37.7579610536344, -122.48954058892) | ||
| 92668 | 92668 | 35064 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1600 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38619 | 5993105.16308773 | 2104567.76843585 | 37.7583456711152 | -122.46689889533 | (37.7583456711152, -122.46689889533) | ||
| 124458 | 124458 | 35063 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1600 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38619 | 5993105.16308773 | 2104567.76843585 | 37.7583456711152 | -122.46689889533 | (37.7583456711152, -122.46689889533) | ||
| 164186 | 164186 | 182455 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1500 31st Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5986551.2997 | 2104640.4864 | 37.7581648905277 | -122.48957008427 | (37.7581648905277, -122.48957008427) | |||
| 127524 | 127524 | 37556 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 4528 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1998 12:00:00 AM | Permit Number 39995 | 6000974.70295267 | 2104668.04462068 | 37.7590720640705 | -122.439689810342 | (37.7590720640705, -122.439689810342) | ||
| 180911 | 180911 | 222881 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3844 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004001.37732 | 2104831.96458 | 37.759693956822204 | -122.429233822808 | (37.7596939568222, -122.429233822808) | |||
| 140209 | 140209 | 37586 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 2775 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40017 | 6001162.31345404 | 2105517.18376133 | 37.7614142693336 | -122.439101823773 | (37.7614142693336, -122.439101823773) | ||
| 61853 | 61853 | 116770 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 307 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x6 | 6013506.88243 | 2105617.60092 | 37.7623846762351 | -122.39641383275101 | (37.7623846762351, -122.396413832751) | |||
| 23630 | 23630 | 222878 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003263.67356 | 2105959.60231 | 37.7627483890498 | -122.431865689655 | (37.7627483890498, -122.431865689655) | |||
| 155799 | 155799 | 222877 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003276.24685 | 2105959.7003900004 | 37.7627493711059 | -122.43182221013001 | (37.7627493711059, -122.43182221013) | |||
| 60521 | 60521 | 222880 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003225.6095199995 | 2105960.03054 | 37.7627474070019 | -122.431997370179 | (37.7627474070019, -122.431997370179) | |||
| 35226 | 35226 | 222879 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003245.02631 | 2105961.0603 | 37.7627513352378 | -122.431930287959 | (37.7627513352378, -122.431930287959) | |||
| 129275 | 129275 | 68712 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32625 | 6003279.54613576 | 2105963.01747728 | 37.762758666054395 | -122.43181103593099 | (37.7627586660544, -122.431811035931) | ||
| 186968 | 186968 | 188443 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011515.17164 | 2106121.75692 | 37.763657939085704 | -122.40333792809601 | (37.7636579390857, -122.403337928096) | |||
| 65403 | 65403 | 188444 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011513.49426 | 2106142.7463700003 | 37.763715477720794 | -122.403345206341 | (37.7637154777208, -122.403345206341) | |||
| 161840 | 161840 | 188445 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011511.3367099995 | 2106160.81157 | 37.7637649602022 | -122.403353939635 | (37.7637649602022, -122.403353939635) | |||
| 164926 | 164926 | 188446 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011512.27704 | 2106186.3574200002 | 37.763835155891 | -122.403352484549 | (37.763835155891, -122.403352484549) |
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");