Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26790 | 26790 | 218822 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 210 Vernon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5992480.53035 | 2089289.94219 | 37.7163605349795 | -122.467947888583 | (37.7163605349795, -122.467947888583) | |||
| 39298 | 39298 | 126628 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | |||
| 62024 | 62024 | 126626 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 350 Washington St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 8ft | 6013909.986409999 | 2118052.46146 | 37.796550399249796 | -122.39589102894399 | (37.7965503992498, -122.395891028944) | |||
| 71439 | 71439 | 126629 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013771.20775 | 2118034.57435 | 37.7964935638782 | -122.396369982705 | (37.7964935638782, -122.396369982705) | |||
| 133542 | 133542 | 126631 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6013670.6132 | 2118002.8434900003 | 37.796400840179 | -122.39671583859 | (37.796400840179, -122.39671583859) | |||
| 173926 | 173926 | 126630 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | |||
| 174003 | 174003 | 126627 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.39598707025499 | (37.796538299751, -122.395987070255) | |||
| 44349 | 44349 | 124423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 5996107.9721800005 | 2115471.34233 | 37.78845688642 | -122.45730271274401 | (37.78845688642, -122.457302712744) | |||
| 154029 | 154029 | 124424 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 207 Cherry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.788413082259105 | -122.45729418503599 | (37.7884130822591, -122.457294185036) | |||
| 148290 | 148290 | 176417 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 825 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6001125.807159999 | 2088973.54213 | 37.7159872246076 | -122.438043004189 | (37.7159872246076, -122.438043004189) | |||
| 181204 | 181204 | 176413 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 816 Lisbon St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6001088.39895 | 2089005.3588599998 | 37.7160724587542 | -122.43817458219999 | (37.7160724587542, -122.4381745822) | |||
| 27704 | 27704 | 224485 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1528 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6007214.093119999 | 2107363.71404 | 37.7668269026679 | -122.418302114548 | (37.7668269026679, -122.418302114548) | |||
| 39271 | 39271 | 126617 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3001 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5999428.93901 | 2119163.44026 | 37.798784587708504 | -122.446078403512 | (37.7987845877085, -122.446078403512) | |||
| 47489 | 47489 | 224527 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 171 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6006719.85919 | 2102790.50948 | 37.7542421146046 | -122.419687075893 | (37.7542421146046, -122.419687075893) | |||
| 48220 | 48220 | 218820 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | |||
| 155045 | 155045 | 224625 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 50 Piedmont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5999457.54578 | 2107020.99028 | 37.7654461969099 | -122.44510599986602 | (37.7654461969099, -122.445105999866) | |||
| 156833 | 156833 | 224526 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 173 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6006718.37785 | 2102818.25251 | 37.7543182071448 | -122.419694167076 | (37.7543182071448, -122.419694167076) | |||
| 159184 | 159184 | 218819 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 205 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5991410.90841 | 2090573.24495 | 37.71982234389839 | -122.47173845727801 | (37.7198223438984, -122.471738457278) | |||
| 166587 | 166587 | 224484 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1514 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6007262.01073 | 2107365.0441 | 37.7668332518872 | -122.418136469321 | (37.7668332518872, -122.418136469321) | |||
| 176422 | 176422 | 226481 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007993.239469999 | 2105048.9001700003 | 37.7605147878543 | -122.415443270504 | (37.7605147878543, -122.415443270504) | |||
| 25337 | 25337 | 250803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 283 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5986183.75415 | 2114029.47113 | 37.7839229338472 | -122.491532293599 | (37.7839229338472, -122.491532293599) | |||
| 32026 | 32026 | 224492 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5998346.422619999 | 2106894.64873 | 37.7650358128629 | -122.448940002185 | (37.7650358128629, -122.448940002185) | |||
| 33009 | 33009 | 218828 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 831 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990524.89237 | 2100389.62216 | 37.746724319168294 | -122.47551744719802 | (37.7467243191683, -122.475517447198) | |||
| 40276 | 40276 | 224680 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006416.173690001 | 2101511.36496 | 37.7507127656919 | -122.420646499657 | (37.7507127656919, -122.420646499657) | |||
| 42892 | 42892 | 218825 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 295 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.716049240944706 | -122.463613852416 | (37.7160492409447, -122.463613852416) | |||
| 44876 | 44876 | 224512 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 915 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009423.35212 | 2103670.74387 | 37.756810960566 | -122.41039983289 | (37.756810960566, -122.41039983289) | |||
| 46078 | 46078 | 224507 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2201 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008190.11914 | 2105143.7552799997 | 37.760786302161996 | -122.414769064951 | (37.760786302162, -122.414769064951) | |||
| 46174 | 46174 | 224682 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6006417.42588 | 2101484.35178 | 37.750638664248704 | -122.42064025206899 | (37.7506386642487, -122.420640252069) | |||
| 46243 | 46243 | 224511 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1117 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6009227.24206 | 2102557.50534 | 37.7537432624556 | -122.410999428875 | (37.7537432624556, -122.410999428875) | |||
| 52756 | 52756 | 218802 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2370 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992350.84884 | 2099324.20257 | 37.7439046297971 | -122.46912600049 | (37.7439046297971, -122.46912600049) | |||
| 53817 | 53817 | 224489 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998519.39636 | 2106289.8820599997 | 37.763385166627295 | -122.44829817853399 | (37.7633851666273, -122.448298178534) | |||
| 56060 | 56060 | 218830 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 833 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990479.90891 | 2100386.13678 | 37.746712141459604 | -122.47567273941699 | (37.7467121414596, -122.475672739417) | |||
| 62058 | 62058 | 224491 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 60 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5998359.17902 | 2106895.28933 | 37.765038301310796 | -122.4488959273 | (37.7650383013108, -122.4488959273) | |||
| 66232 | 66232 | 224502 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 203 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006664.46693 | 2098372.3341200002 | 37.7421076872335 | -122.41956519440399 | (37.7421076872335, -122.419565194404) | |||
| 70379 | 70379 | 224505 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2200 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008118.04648 | 2105348.76718 | 37.7613451678544 | -122.415032844197 | (37.7613451678544, -122.415032844197) | |||
| 71668 | 71668 | 224681 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1390 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6006415.878380001 | 2101496.97772 | 37.7506732449771 | -122.42064649965499 | (37.7506732449771, -122.420646499655) | |||
| 72099 | 72099 | 250802 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 283 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5986182.86321 | 2114039.35976 | 37.7839500331106 | -122.491536104007 | (37.7839500331106, -122.491536104007) | |||
| 75115 | 75115 | 218805 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 67 Marne Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5995289.12081 | 2097585.29615 | 37.739299364370005 | -122.45884033191099 | (37.73929936437, -122.458840331911) | |||
| 131453 | 131453 | 224509 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2201 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008178.36373 | 2105370.35117 | 37.76140782184 | -122.414825759103 | (37.76140782184, -122.414825759103) | |||
| 137984 | 137984 | 224483 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1500 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007282.9352400005 | 2107366.34912 | 37.766838012891704 | -122.418064187227 | (37.7668380128917, -122.418064187227) | |||
| 143728 | 143728 | 218821 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 278 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5991714.63996 | 2090365.5771400002 | 37.719269707816 | -122.47067345584101 | (37.719269707816, -122.470673455841) | |||
| 155873 | 155873 | 218816 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 170 Margaret Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 5996666.019619999 | 2089250.8609200001 | 37.716494040240796 | -122.45347805498899 | (37.7164940402408, -122.453478054989) | |||
| 160486 | 160486 | 224508 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2201 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6008177.844880001 | 2105327.1946400004 | 37.761289294789 | -122.414824499172 | (37.761289294789, -122.414824499172) | |||
| 165442 | 165442 | 224493 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 232 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999538.9593 | 2106236.29263 | 37.7632962596403 | -122.444768001354 | (37.7632962596403, -122.444768001354) | |||
| 166637 | 166637 | 224506 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2404 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008170.5791 | 2104405.7281 | 37.758758750933204 | -122.414784412782 | (37.7587587509332, -122.414784412782) | |||
| 171712 | 171712 | 224488 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 24 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998533.31147 | 2106291.41144 | 37.763390161444896 | -122.44825016102502 | (37.7633901614449, -122.448250161025) | |||
| 178436 | 178436 | 126616 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2660 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6000233.00854 | 2118542.38093 | 37.797125207219295 | -122.443251440404 | (37.7971252072193, -122.443251440404) | |||
| 186397 | 186397 | 218803 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2370 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992349.88043 | 2099344.31841 | 37.7439598068059 | -122.46913081273199 | (37.7439598068059, -122.469130812732) | |||
| 187354 | 187354 | 218829 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 833 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5990502.9727 | 2100388.60646 | 37.746720259628 | -122.475593168284 | (37.746720259628, -122.475593168284) | |||
| 187775 | 187775 | 250901 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 262 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986843.4258 | 2114179.11857 | 37.784372351133 | -122.489261109739 | (37.784372351133, -122.489261109739) | |||
| 543 | 543 | 224593 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3131 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 13 | Width 3ft | Permit Number 18870 | 6005970.19181 | 2106649.76485 | 37.7647964691065 | -122.42255383310801 | (37.7647964691065, -122.422553833108) | |
| 547 | 547 | 224594 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3133 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 14 | Width 3ft | Permit Number 18871 | 6005947.45622 | 2106648.2222599997 | 37.7647909508601 | -122.42263236011001 | (37.7647909508601, -122.42263236011) | |
| 1492 | 1492 | 224530 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3055 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6008605.155040001 | 2102119.10209 | 37.752504601916 | -122.413119756879 | (37.752504601916, -122.413119756879) | |||
| 1508 | 1508 | 224531 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3077 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008520.36157 | 2102113.23947 | 37.752483743936 | -122.413412573453 | (37.752483743936, -122.413412573453) | |||
| 1961 | 1961 | 224699 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 3ft | 6007526.74961 | 2102095.6735900003 | 37.7523796734842 | -122.416847415286 | (37.7523796734842, -122.416847415286) | |||
| 1962 | 1962 | 224700 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007513.40637 | 2102105.84325 | 37.7524068465217 | -122.416894278962 | (37.7524068465217, -122.416894278962) | |||
| 1970 | 1970 | 224702 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3236 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 6007468.557569999 | 2102099.5649099997 | 37.752387084812604 | -122.417048929078 | (37.7523870848126, -122.417048929078) | |||
| 2011 | 2011 | 224701 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3230 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6007503.74003 | 2102097.0446900004 | 37.7523821439458 | -122.416927083514 | (37.7523821439458, -122.416927083514) | |||
| 2012 | 2012 | 224703 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 3236 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6007440.93162 | 2102096.08231 | 37.7523759682811 | -122.417144217627 | (37.7523759682811, -122.417144217627) | |||
| 2123 | 2123 | 128055 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 449 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780354 | 6008758.87824 | 2121765.85838 | 37.8064585449799 | -122.413977880988 | (37.8064585449799, -122.413977880988) | |
| 4385 | 4385 | 224618 | Planning Code 138.1 required 4 | Ficus microcarpa :: Chinese Banyan 94 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | ||
| 24881 | 24881 | 224536 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | |||
| 24936 | 24936 | 250316 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995936.88043 | 2115877.7469599997 | 37.7895629358285 | -122.457924081037 | (37.7895629358285, -122.457924081037) | |||
| 25222 | 25222 | 224646 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 9 Heyman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006447.484730001 | 2098360.83948 | 37.7420639010279 | -122.420314636308 | (37.7420639010279, -122.420314636308) | |||
| 25306 | 25306 | 224560 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3103 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008678.9898 | 2105047.11608 | 37.7605484090025 | -122.41307143989799 | (37.7605484090025, -122.413071439898) | |||
| 25653 | 25653 | 224561 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3105 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008657.355280001 | 2105044.9077 | 37.7605411307748 | -122.413146107923 | (37.7605411307748, -122.413146107923) | |||
| 25991 | 25991 | 251008 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3878 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995662.214869999 | 2115838.76904 | 37.7894401289022 | -122.45887156539499 | (37.7894401289022, -122.458871565395) | |||
| 26257 | 26257 | 226491 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2450 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008819.815769999 | 2104185.8103 | 37.7581913641506 | -122.412523500065 | (37.7581913641506, -122.412523500065) | |||
| 26601 | 26601 | 224669 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 800 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6009345.52709 | 2104457.09364 | 37.758965736194504 | -122.410724513338 | (37.7589657361945, -122.410724513338) | |||
| 26758 | 26758 | 224495 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 142 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005480.01407 | 2096145.7478200002 | 37.7359271935727 | -122.42350240381501 | (37.7359271935727, -122.423502403815) | |||
| 27084 | 27084 | 224623 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999023.60773 | 2105026.39376 | 37.759944756159996 | -122.44646337809601 | (37.75994475616, -122.446463378096) | |||
| 27122 | 27122 | 224482 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 36 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005327.69113 | 2105769.4037900004 | 37.7623429387058 | -122.424713446172 | (37.7623429387058, -122.424713446172) | |||
| 27818 | 27818 | 224481 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 77 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005108.87913 | 2105720.69975 | 37.762196848333396 | -122.42546676957599 | (37.7621968483334, -122.425466769576) | |||
| 29802 | 29802 | 224567 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007896.19994 | 2105583.80933 | 37.7619780702545 | -122.41581676433701 | (37.7619780702545, -122.415816764337) | |||
| 30653 | 30653 | 226472 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3101 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008660.80856 | 2105087.18769 | 37.7606574158171 | -122.41313715427799 | (37.7606574158171, -122.413137154278) | |||
| 31192 | 31192 | 224609 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3556 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005809.7038900005 | 2102588.37341 | 37.753635783583796 | -122.422820259951 | (37.7536357835838, -122.422820259951) | |||
| 31299 | 31299 | 176423 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 538 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009799.11271 | 2092612.1001799998 | 37.726467385945 | -122.408320334118 | (37.726467385945, -122.408320334118) | |||
| 31380 | 31380 | 224632 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 667 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007654.90569 | 2096244.9671 | 37.736322146140104 | -122.41598994138599 | (37.7363221461401, -122.415989941386) | |||
| 31967 | 31967 | 224626 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 601 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999843.00884 | 2107568.58853 | 37.7669717582745 | -122.443812120926 | (37.7669717582745, -122.443812120926) | |||
| 32232 | 32232 | 224696 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3164 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007892.65304 | 2102118.31873 | 37.752462426418205 | -122.415583660969 | (37.7524624264182, -122.415583660969) | |||
| 32870 | 32870 | 224543 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3257 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6006596.438630001 | 2103760.0556900003 | 37.7568973116766 | -122.420182701267 | (37.7568973116766, -122.420182701267) | |||
| 33319 | 33319 | 218811 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 75 Williar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997101.63162 | 2090622.46989 | 37.7202851197392 | -122.45207127696999 | (37.7202851197392, -122.45207127697) | |||
| 33348 | 33348 | 224580 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2701 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008616.559830001 | 2106802.76672 | 37.765365516923396 | -122.413411521233 | (37.7653655169234, -122.413411521233) | |||
| 33417 | 33417 | 224524 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 145 Bartlett St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006710.95301 | 2102956.09091 | 37.754696261449 | -122.419729623734 | (37.754696261449, -122.419729623734) | |||
| 33898 | 33898 | 224685 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3513 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006366.00015 | 2101408.94489 | 37.7504287157262 | -122.420812733918 | (37.7504287157262, -122.420812733918) | |||
| 33917 | 33917 | 224641 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 14 Powers Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006763.87284 | 2099814.11824 | 37.7460721011655 | -122.41932373541901 | (37.7460721011655, -122.419323735419) | |||
| 34568 | 34568 | 224517 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6007852.876569999 | 2105322.21505 | 37.76125735715679 | -122.41594807794701 | (37.7612573571568, -122.415948077947) | |||
| 34585 | 34585 | 224513 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1115 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008070.04378 | 2101397.41005 | 37.7504929435022 | -122.41491919326 | (37.7504929435022, -122.41491919326) | |||
| 35607 | 35607 | 224556 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3361 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007831.17362 | 2104415.66296 | 37.7587669536521 | -122.415958939967 | (37.7587669536521, -122.415958939967) | |||
| 35969 | 35969 | 224619 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1324 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999058.149540001 | 2104997.17372 | 37.75986649804889 | -122.446341813123 | (37.7598664980489, -122.446341813123) | |||
| 36252 | 36252 | 224597 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3379 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005839.7237599995 | 2103719.1603099997 | 37.7567423557945 | -122.422796801149 | (37.7567423557945, -122.422796801149) | |||
| 36458 | 36458 | 224550 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3381 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007700.023440001 | 2104409.2187799998 | 37.7587418850474 | -122.41641206247499 | (37.7587418850474, -122.416412062475) | |||
| 36658 | 36658 | 224538 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2925 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008618.6240300005 | 2103873.92813 | 37.7573237135349 | -122.413197256868 | (37.7573237135349, -122.413197256868) | |||
| 37859 | 37859 | 224591 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3117 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006001.0018 | 2106651.39278 | 37.7648026771212 | -122.42244738485701 | (37.7648026771212, -122.422447384857) | |||
| 38008 | 38008 | 226494 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2300 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008770.52865 | 2104997.0899900002 | 37.7604161870861 | -122.412751310945 | (37.7604161870861, -122.412751310945) | |||
| 38032 | 38032 | 224519 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 439 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007848.492430001 | 2105359.1644 | 37.7613585650588 | -122.415965857533 | (37.7613585650588, -122.415965857533) | |||
| 38567 | 38567 | 176431 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 146 Britton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008376.30406 | 2087394.4749 | 37.7120611046958 | -122.41287021121401 | (37.7120611046958, -122.412870211214) | |||
| 39926 | 39926 | 224569 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3235 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007968.16087 | 2105588.52083 | 37.7619950521511 | -122.415568212409 | (37.7619950521511, -122.415568212409) | |||
| 40147 | 40147 | 250314 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 3828 Jackson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995896.25125 | 2115871.75264 | 37.789544142705395 | -122.45806421881201 | (37.7895441427054, -122.458064218812) | |||
| 40410 | 40410 | 199435 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1711 Oakdale Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6014455.52547 | 2095885.24717 | 37.735714433762 | -122.392452028664 | (37.735714433762, -122.392452028664) |
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");