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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 750 | 750 | 251368 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 270 06th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 3x3 | 6010822.0 | 2111616.0 | 37.7787051302825 | -122.40612250689199 | (37.7787051302825, -122.406122506892) | |||
| 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) | ||||
| 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) | ||
| 10041 | 10041 | 173806 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 950 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007805.7000400005 | 2120292.0567099997 | 37.802358278640206 | -122.41717203578699 | (37.8023582786402, -122.417172035787) | ||||
| 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) | |
| 14149 | 14149 | 105282 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 190 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009783.34609 | 2111415.87404 | 37.7780974817408 | -122.40970150032899 | (37.7780974817408, -122.409701500329) | |||
| 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) |
| 15645 | 15645 | 105283 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 190 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009798.61642 | 2111399.33424 | 37.778052923046104 | -122.40964750682 | (37.7780529230461, -122.40964750682) | |||
| 15711 | 15711 | 105284 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 190 07th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009809.36345 | 2111386.0864 | 37.7780171498111 | -122.40960939355601 | (37.7780171498111, -122.409609393556) | |||
| 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) | |
| 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) |
| 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) |
| 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) | |||
| 21196 | 21196 | 28504 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 270 06th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.77880883239779 | -122.406117215604 | (37.7788088323978, -122.406117215604) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 25251 | 25251 | 244200 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 540 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003980.524 | 2109759.8502 | 37.773223560287796 | -122.429657410606 | (37.7732235602878, -122.429657410606) | |||
| 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) | |||
| 27674 | 27674 | 33308 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1534 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 7 | Permit Number 37456 | 6004490.72276 | 2120176.84619 | 37.8018548920575 | -122.42863526732 | (37.8018548920575, -122.42863526732) | |
| 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) | ||
| 30476 | 30476 | 244481 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1074 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001413.516 | 2109405.0473 | 37.77210367272939 | -122.43851158928499 | (37.7721036727294, -122.438511589285) | |||
| 33544 | 33544 | 44052 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3100 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 8 | Permit Number 43582 | 6001963.46914 | 2118819.46564 | 37.79798453192029 | -122.43728348086901 | (37.7979845319203, -122.437283480869) | ||
| 33784 | 33784 | 125959 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007983.53221 | 2120324.66338 | 37.802457811042 | -122.41655895865401 | (37.802457811042, -122.416558958654) | |||
| 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) | |||
| 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) | |||
| 36331 | 36331 | 188452 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011502.89501 | 2106343.32084 | 37.7642656181765 | -122.40339597754499 | (37.7642656181765, -122.403395977545) | |||
| 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) | |||
| 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) | |
| 38168 | 38168 | 59248 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 939 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 9 | Permit Number 18580 | 6007864.8919400005 | 2120254.38142 | 37.8022581615512 | -122.41696453128999 | (37.8022581615512, -122.41696453129) | ||
| 39299 | 39299 | 125958 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 941 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007838.51696 | 2120251.34871 | 37.802248350842795 | -122.41705558676901 | (37.8022483508428, -122.417055586769) | |||
| 40338 | 40338 | 222869 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997758.85551 | 2107160.25032 | 37.765731467257396 | -122.45099139535299 | (37.7657314672574, -122.450991395353) | |||
| 40399 | 40399 | 125952 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 2294 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001994.86126 | 2118787.45338 | 37.79789841912879 | -122.437172562074 | (37.7978984191288, -122.437172562074) | |||
| 42583 | 42583 | 32638 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 787 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 13 | Permit Number 37084 | 6011713.6673099995 | 2109582.88625 | 37.77317250104971 | -122.402894833955 | (37.7731725010497, -122.402894833955) | |
| 43209 | 43209 | 188465 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 766 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6011787.2831 | 2109744.8541900003 | 37.773621338281295 | -122.402651578111 | (37.7736213382813, -122.402651578111) | |||
| 43647 | 43647 | 205976 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 1701 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990268.09461 | 2106501.35163 | 37.763490619320294 | -122.476851900801 | (37.7634906193203, -122.476851900801) | |||
| 46237 | 46237 | 247494 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 335 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002693.3039 | 2109766.0565 | 37.77316763021489 | -122.434110515465 | (37.7731676302149, -122.434110515465) | |||
| 46416 | 46416 | 125961 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007947.134880001 | 2120318.93587 | 37.802440037726 | -122.41668450579999 | (37.802440037726, -122.4166845058) | |||
| 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) | |||
| 47462 | 47462 | 188462 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011845.31362 | 2109707.14292 | 37.7735210314987 | -122.402448188337 | (37.7735210314987, -122.402448188337) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 53157 | 53157 | 32629 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 766 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 8 | Permit Number 37081 | 6011821.137130001 | 2109777.45892 | 37.7737127534642 | -122.40253676438299 | (37.7737127534642, -122.402536764383) | |
| 53454 | 53454 | 188455 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011498.78949 | 2106422.9347099997 | 37.76448399066 | -122.40341577880899 | (37.76448399066, -122.403415778809) | |||
| 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) | |||
| 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) | |||
| 56122 | 56122 | 59251 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 955 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 15 | Permit Number 18583 | 6007775.57137 | 2120243.85461 | 37.8022242328199 | -122.417272878267 | (37.8022242328199, -122.417272878267) | ||
| 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) | ||
| 58112 | 58112 | 125960 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 900 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007965.18699 | 2120322.0284599997 | 37.8024495444817 | -122.416622255608 | (37.8024495444817, -122.416622255608) | |||
| 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) | |
| 60072 | 60072 | 188463 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 769 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011854.3498599995 | 2109717.34943 | 37.773549560687705 | -122.402417648277 | (37.7735495606877, -122.402417648277) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 63815 | 63815 | 106235 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 785 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6011771.382680001 | 2109636.80705 | 37.773323777798794 | -122.40269898048099 | (37.7733237777988, -122.402698980481) | ||||
| 63879 | 63879 | 188450 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011505.24263 | 2106303.9355 | 37.7641576060043 | -122.403385086777 | (37.7641576060043, -122.403385086777) | |||
| 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) | ||
| 64872 | 64872 | 38246 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.41515711380501 | (37.7684933273993, -122.415157113805) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 69719 | 69719 | 32628 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 766 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 7 | Permit Number 37081 | 6011809.7571 | 2109765.86877 | 37.7736802942351 | -122.40257531472601 | (37.7736802942351, -122.402575314726) | |
| 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) | ||
| 71722 | 71722 | 101286 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 3333 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6001806.51614 | 2119614.34242 | 37.8001581312395 | -122.43788354539 | (37.8001581312395, -122.43788354539) | |||
| 72455 | 72455 | 125964 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 954 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007746.87512 | 2120288.68768 | 37.8023457186479 | -122.41737536049999 | (37.8023457186479, -122.4173753605) | |||
| 72694 | 72694 | 188448 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 401 Kansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011508.86092 | 2106242.57461 | 37.763989324874295 | -122.403368255061 | (37.7639893248743, -122.403368255061) | |||
| 72847 | 72847 | 65051 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 3026 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2013 12:00:00 AM | 5 | Permit Number 769905 | 6003418.47474 | 2118846.82882 | 37.7981422694136 | -122.432250702931 | (37.7981422694136, -122.432250702931) | ||
| 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) | |||
| 75387 | 75387 | 123032 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 660 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5991952.29381 | 2110935.71162 | 37.775763734780504 | -122.47134996528 | (37.7757637347805, -122.47134996528) | |||
| 77568 | 77568 | 115854 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 78366 | 78366 | 38245 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.41515711380501 | (37.7684933273993, -122.415157113805) | ||
| 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) | ||
| 80967 | 80967 | 32635 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | ||
| 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) | ||
| 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) | ||
| 83424 | 83424 | 35160 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 335 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38691 | 6002701.11607915 | 2109682.95719093 | 37.7729399034438 | -122.43407755068701 | (37.7729399034438, -122.434077550687) | ||
| 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) | ||
| 85898 | 85898 | 33286 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 1055@Clay Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/2002 12:00:00 AM | 3x3 | Permit Number 44830 | 6009456.49724061 | 2116992.25574546 | 37.7933905675371 | -122.411226210566 | (37.7933905675371, -122.411226210566) | |
| 85932 | 85932 | 115858 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 86213 | 86213 | 35150 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 220 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38682 | 6003657.87156781 | 2109198.47011365 | 37.7716638731645 | -122.430733439651 | (37.7716638731645, -122.430733439651) | ||
| 87280 | 87280 | 38807 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 202 Townsend St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963120995 | 2111590.96099347 | 37.7788497186051 | -122.39287985258801 | (37.7788497186051, -122.392879852588) | ||
| 88142 | 88142 | 115865 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 88232 | 88232 | 32632 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | ||
| 89682 | 89682 | 32634 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | ||
| 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) | ||
| 90669 | 90669 | 34575 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 295X Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38282 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | ||
| 90820 | 90820 | 1548 | DPW Maintained 3 | Celtis sinensis :: Chinese Hackberry 111 | 501 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5995571.41042 | 2112712.2375 | 37.7808502932087 | -122.45895926991501 | (37.7808502932087, -122.458959269915) | |||
| 90837 | 90837 | 32631 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 777 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 93733 | 93733 | 115862 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 95602 | 95602 | 52141 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 100 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2005 12:00:00 AM | Permit Number 48322 | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | ||
| 96110 | 96110 | 222863 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 75 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008222.11657 | 2107958.0474099996 | 37.7685154940131 | -122.414857584305 | (37.7685154940131, -122.414857584305) | |||
| 97521 | 97521 | 115866 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 451x KANSAS ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6011530.0 | 2106284.0 | 37.7641042503363 | -122.40329805519501 | (37.7641042503363, -122.403298055195) | ||||
| 97829 | 97829 | 35151 | Permitted Site 1 | Celtis sinensis :: Chinese Hackberry 111 | 220 Laussat St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | Permit Number 38682 | 6003657.87156781 | 2109198.47011365 | 37.7716638731645 | -122.430733439651 | (37.7716638731645, -122.430733439651) | |||
| 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) |
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");