Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99121 | 99121 | 102169 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 235 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.758662980429996 | -122.435726513037 | (37.75866298043, -122.435726513037) |
| 117367 | 117367 | 102168 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 235 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769763 | 6002117.1 | 2104495.4 | 37.758662980429996 | -122.435726513037 | (37.75866298043, -122.435726513037) |
| 5893 | 5893 | 46201 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 9250 | 9250 | 46200 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 77627 | 77627 | 1693 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 3 | 3X3 | 6017694.7378197 | 2093654.8040294999 | 37.7297694248505 | -122.38109767205201 | (37.7297694248505, -122.381097672052) | ||
| 97591 | 97591 | 1700 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 43 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1996 12:00:00 AM | 6 | 3X3 | 6017768.2322395 | 2093598.2442303002 | 37.7296181792492 | -122.380839660676 | (37.7296181792492, -122.380839660676) | ||
| 22963 | 22963 | 108630 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1469-1471 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772871 | 6002136.635290001 | 2111543.9635799997 | 37.778017709796295 | -122.436163356374 | (37.7780177097963, -122.436163356374) |
| 126432 | 126432 | 26478 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 120 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/30/2009 12:00:00 AM | 3 | 3X3 | 6001175.6711954 | 2098684.4538551 | 37.7426539948984 | -122.438566040387 | (37.7426539948984, -122.438566040387) | ||
| 146854 | 146854 | 68934 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 691 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32918 | 5992842.27322 | 2110813.31617 | 37.77547911209629 | -122.46826242331001 | (37.7754791120963, -122.46826242331) | |
| 160765 | 160765 | 68930 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 768 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32914 | 5993218.422259999 | 2110247.19429 | 37.7739464110699 | -122.466920079783 | (37.7739464110699, -122.466920079783) | |
| 8083 | 8083 | 7308 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1919 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2011 12:00:00 AM | 3 | 3x3 | 6002923.2911 | 2115026.9363 | 37.787625737445204 | -122.433691029207 | (37.7876257374452, -122.433691029207) | ||
| 3763 | 3763 | 18277 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1950 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002776.9831 | 2114109.0569 | 37.7850971709049 | -122.434131584258 | (37.7850971709049, -122.434131584258) | ||
| 85840 | 85840 | 18272 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1950 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002831.4981407 | 2114113.4681378 | 37.78511237688 | -122.433943294941 | (37.78511237688, -122.433943294941) | ||
| 127653 | 127653 | 18256 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1850 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 12 | 4X4 | 6003320.917844 | 2114181.6927542 | 37.785327466465795 | -122.432254931219 | (37.7853274664658, -122.432254931219) | ||
| 102568 | 102568 | 46138 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44488 | 5998167.19673673 | 2106203.84420023 | 37.763128786615 | -122.449510117352 | (37.763128786615, -122.449510117352) | ||
| 89430 | 89430 | 16558 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 500X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/1997 12:00:00 AM | 3 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | ||
| 99184 | 99184 | 16557 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 500X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/1997 12:00:00 AM | 3 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | ||
| 85640 | 85640 | 108404 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 181-199 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007385.0 | 2107936.0 | 37.7684078844101 | -122.41775154293998 | (37.7684078844101, -122.41775154294) |
| 90141 | 90141 | 91691 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301-307 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007391.9619889995 | 2107907.789584 | 37.7683308170236 | -122.41772546217501 | (37.7683308170236, -122.417725462175) |
| 113552 | 113552 | 108403 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301-307 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773735 | 6007391.32185 | 2107918.98153 | 37.768361511451296 | -122.417728469751 | (37.7683615114513, -122.417728469751) |
| 129414 | 129414 | 107809 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 174 14TH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773719 | 6007550.6 | 2107982.4 | 37.76854460553329 | -122.417182034417 | (37.7685446055333, -122.417182034417) | ||
| 103412 | 103412 | 7310 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1930 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2011 12:00:00 AM | 10 | 3x3 | 6002973.84302 | 2114998.5825 | 37.7875507533927 | -122.433514102581 | (37.7875507533927, -122.433514102581) | ||
| 21163 | 21163 | 5709 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1606 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/1991 12:00:00 AM | 3 | 4X4 | 6005243.993869999 | 2098945.2281 | 37.7436006094864 | -122.424517489316 | (37.7436006094864, -122.424517489316) | ||
| 87927 | 87927 | 101047 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774347 | 6012043.0 | 2119296.0 | 37.799860814363 | -122.40243873444099 | (37.799860814363, -122.402438734441) | |
| 87274 | 87274 | 102063 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 284 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769726 | 6006232.8 | 2098354.9 | 37.742035492788204 | -122.42105652774099 | (37.7420354927882, -122.421056527741) |
| 104090 | 104090 | 87073 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 110241 | 110241 | 87072 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 395 Byxbee St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 123067 | 123067 | 34975 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | Permit Number 38557 | 6012788.97638306 | 2118225.73375032 | 37.79696373512979 | -122.399782167941 | (37.7969637351298, -122.399782167941) | |||
| 14424 | 14424 | 6845 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 595X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1992 12:00:00 AM | 6 | 3x3 | 6015936.9719 | 2097716.00593 | 37.7408234823092 | -122.38745772460899 | (37.7408234823092, -122.387457724609) | ||
| 87673 | 87673 | 6645 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 495X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1992 12:00:00 AM | 6 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | ||
| 77830 | 77830 | 8119 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 850X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | ||
| 94770 | 94770 | 8084 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 755X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6004115.11785 | 2111289.80956 | 37.7774320731857 | -122.429300951982 | (37.7774320731857, -122.429300951982) | ||
| 140172 | 140172 | 8112 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 810 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 1 | 3X3 | 6003674.72306 | 2111615.24723 | 37.778300702455894 | -122.430847652747 | (37.7783007024559, -122.430847652747) | ||
| 109406 | 109406 | 63194 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 420 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 23734 | 5984095.68800959 | 2112985.55374836 | 37.78093439601071 | -122.498678978522 | (37.7809343960107, -122.498678978522) | ||
| 137742 | 137742 | 102622 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 719 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/2014 12:00:00 AM | 1 | Permit Number 772854 | 5992851.12865 | 2110544.54919 | 37.774741661803006 | -122.46821223444401 | (37.774741661803, -122.468212234444) | ||
| 62974 | 62974 | 66344 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 628 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/1990 12:00:00 AM | 9 | Permit Number 29465 | 6000112.1176 | 2111075.8999 | 37.7766172965815 | -122.44313323876601 | (37.7766172965815, -122.443133238766) | ||
| 16542 | 16542 | 6847 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 595X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2002 12:00:00 AM | 3 | 3x3 | 6015962.97666 | 2097752.7883599997 | 37.7409259196071 | -122.38737037433701 | (37.7409259196071, -122.387370374337) | ||
| 102409 | 102409 | 70248 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1248 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53999 | 6008664.66375358 | 2101270.88121733 | 37.750178918205705 | -122.41285400071199 | (37.7501789182057, -122.412854000712) | |
| 115644 | 115644 | 66409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 498 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | Permit Number 29536 | 6008002.73389598 | 2096551.32437781 | 37.7371828859896 | -122.414809025919 | (37.7371828859896, -122.414809025919) | ||
| 118366 | 118366 | 67075 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | Permit Number 30469 | 6007674.59209912 | 2096541.81182002 | 37.7371383234242 | -122.41594289157601 | (37.7371383234242, -122.415942891576) | ||
| 80705 | 80705 | 62440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 32 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22603 | 5999780.61180369 | 2105360.37553229 | 37.7609049960466 | -122.443869272306 | (37.7609049960466, -122.443869272306) | ||
| 90049 | 90049 | 62441 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 26 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22604 | 5999768.9190223 | 2105384.80396899 | 37.76097140351521 | -122.44391146753901 | (37.7609714035152, -122.443911467539) | ||
| 74292 | 74292 | 54817 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1414 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49953 | 6015568.3491 | 2093032.3958 | 37.7279428116622 | -122.388405474303 | (37.7279428116622, -122.388405474303) | |
| 145984 | 145984 | 48987 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 466 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2002 12:00:00 AM | Permit Number 46174 | 6003488.63823047 | 2100126.88002521 | 37.7467458648752 | -122.43067137990101 | (37.7467458648752, -122.430671379901) | ||
| 123953 | 123953 | 1701 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 46 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2015 02:11:00 PM | 3 | 3X3 | 6017792.761566999 | 2093643.6318374001 | 37.7297441585391 | -122.38075801318199 | (37.7297441585391, -122.380758013182) | ||
| 18749 | 18749 | 10444 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1508 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1999 12:00:00 AM | 6 | 3x3 | 5998873.5099 | 2108710.5533 | 37.770051957545704 | -122.447247648975 | (37.7700519575457, -122.447247648975) | ||
| 109231 | 109231 | 33691 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 625 Ivy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37764 | 6004364.86581498 | 2110979.96495009 | 37.776595451912996 | -122.428414901604 | (37.776595451913, -122.428414901604) | |||
| 114543 | 114543 | 33690 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 625 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37764 | 6004364.86581498 | 2110979.96495009 | 37.776595451912996 | -122.428414901604 | (37.776595451913, -122.428414901604) | |||
| 177162 | 177162 | 33638 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 434 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | 7 | Permit Number 37733 | 6005306.206 | 2110803.5701 | 37.7761643373284 | -122.42514597541701 | (37.7761643373284, -122.425145975417) | |
| 14222 | 14222 | 16526 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 375 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016351.58796 | 2098272.95822 | 37.7423757148758 | -122.386062939968 | (37.7423757148758, -122.386062939968) | ||
| 14937 | 14937 | 16560 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 702X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 12 | 3X3 | 6015615.61867 | 2097370.07413 | 37.7398558207833 | -122.38854471268299 | (37.7398558207833, -122.388544712683) | ||
| 88473 | 88473 | 1698 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 39 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 12 | 3X3 | 6017750.796090401 | 2093602.6298867 | 37.72962925906 | -122.380900244658 | (37.72962925906, -122.380900244658) | ||
| 129195 | 129195 | 16492 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016524.668196499 | 2098330.497802 | 37.7425432844059 | -122.385468484111 | (37.7425432844059, -122.385468484111) | ||
| 84224 | 84224 | 1689 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 03:07:00 PM | 3 | 3X3 | 6017662.008057199 | 2093645.2163419998 | 37.729741292224205 | -122.381210157278 | (37.7297412922242, -122.381210157278) | ||
| 85689 | 85689 | 41239 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 86534 | 86534 | 41236 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 86559 | 86559 | 41238 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 114125 | 114125 | 41237 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 124509 | 124509 | 41240 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 103247 | 103247 | 68832 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32783 | 5999773.2281789 | 2094096.14609893 | 37.7299757052964 | -122.443085818741 | (37.7299757052964, -122.443085818741) | ||
| 18926 | 18926 | 15619 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3517 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005685.7885 | 2097881.8817 | 37.7407058402708 | -122.422914311238 | (37.7407058402708, -122.422914311238) | ||
| 21028 | 21028 | 15622 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3535 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/2001 12:00:00 AM | 6 | 3X3 | 6005607.2671 | 2097740.6765 | 37.7403136916677 | -122.423175774097 | (37.7403136916677, -122.423175774097) | ||
| 161261 | 161261 | 48960 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2038 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | 10 | Permit Number 46146 | 6003159.19812 | 2118949.28174 | 37.7984088743259 | -122.433155199676 | (37.7984088743259, -122.433155199676) | ||
| 17939 | 17939 | 26869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 3 | 3X3 | 6001564.842 | 2095930.60071 | 37.7351146866797 | -122.437023288105 | (37.7351146866797, -122.437023288105) | ||
| 123903 | 123903 | 33529 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 171 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37639 | 6007349.55714183 | 2098075.84761469 | 37.7413321670111 | -122.41717535773701 | (37.7413321670111, -122.417175357737) | |||
| 89683 | 89683 | 59918 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 942 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1981 12:00:00 AM | Permit Number 19387 | 6009922.90971034 | 2103712.90059838 | 37.7569547053635 | -122.40867514442101 | (37.7569547053635, -122.408675144421) | ||
| 58943 | 58943 | 116918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 108702 | 108702 | 116920 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 109779 | 109779 | 116919 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 110363 | 110363 | 116922 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900x 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 121953 | 121953 | 116921 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1390x TENNESSEE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 93295 | 93295 | 104872 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1753 Noe St | 1 | Hanging basket : Yard 27 | Tree 1 | Private 1 | 11/22/2013 12:00:00 AM | Permit Number 770054 | 6003434.1 | 2098036.1 | 37.7410019772539 | -122.430710793678 | (37.7410019772539, -122.430710793678) | |||
| 78938 | 78938 | 59900 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 938 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19367 | 6009921.67857589 | 2103735.23260959 | 37.7570159551008 | -122.408680977559 | (37.7570159551008, -122.408680977559) | ||
| 90171 | 90171 | 59898 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 956 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | 9x6 | Permit Number 19365. I marked for a basin expansion. 9'x 6'. SB | 6009927.21867861 | 2103634.73860088 | 37.756740331390205 | -122.40865472852501 | (37.7567403313902, -122.408654728525) | |
| 101178 | 101178 | 59895 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 980 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19362 | 6009934.60548185 | 2103500.74659623 | 37.756372833099 | -122.408619730116 | (37.756372833099, -122.408619730116) | ||
| 125532 | 125532 | 59905 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 925 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19373 | 6009969.290768799 | 2103816.25695251 | 37.7572410963252 | -122.40852203113998 | (37.7572410963252, -122.40852203114) | ||
| 125861 | 125861 | 59896 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 906 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19363 | 6009911.82950519 | 2103913.88861057 | 37.7575059527221 | -122.408727642987 | (37.7575059527221, -122.408727642987) | ||
| 116657 | 116657 | 24469 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 50X Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/20/2000 12:00:00 AM | 6 | 3x3 | 6006161.54315 | 2109606.56692 | 37.7729259368552 | -122.42210207116699 | (37.7729259368552, -122.422102071167) | ||
| 78280 | 78280 | 33439 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 193 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37541 | 6006477.65745838 | 2098616.29315883 | 37.74276701964221 | -122.420228434519 | (37.7427670196422, -122.420228434519) | |||
| 81623 | 81623 | 33440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 197 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37542 | 6006467.34357413 | 2098597.19964294 | 37.7427140119749 | -122.420262742218 | (37.7427140119749, -122.420262742218) | ||
| 81749 | 81749 | 33436 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 131 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37539 | 6006637.52258219 | 2098912.24250349 | 37.743588636726706 | -122.419696659188 | (37.7435886367267, -122.419696659188) | |||
| 97467 | 97467 | 33438 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 193 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37541 | 6006477.65745838 | 2098616.29315883 | 37.74276701964221 | -122.420228434519 | (37.7427670196422, -122.420228434519) | |||
| 165345 | 165345 | 52196 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2013 12:00:00 AM | 2 | Permit Number 770878 | 6007126.92706 | 2119460.55943 | 37.800036988073295 | -122.419461903656 | (37.8000369880733, -122.419461903656) | ||
| 85202 | 85202 | 29137 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 90x Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6009115.3969879 | 2112842.7343051997 | 37.781977847913204 | -122.41211305193501 | (37.7819778479132, -122.412113051935) | ||
| 115333 | 115333 | 30525 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.41362414398701 | (37.7811193385199, -122.413624143987) | |
| 115748 | 115748 | 15637 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3620 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1999 12:00:00 AM | 3 | 3X3 | 6005316.03868 | 2097071.29075 | 37.7384592699819 | -122.42413513415899 | (37.7384592699819, -122.424135134159) | ||
| 117572 | 117572 | 39160 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 356 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40828 | 6006509.97250889 | 2104030.01619194 | 37.7576336883039 | -122.42050089600201 | (37.7576336883039, -122.420500896002) | ||
| 55755 | 55755 | 48872 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2002 12:00:00 AM | 6 | 3x3 | Permit Number 46081 | 6011751.8076 | 2120847.07255 | 37.8041034220013 | -122.403555563145 | (37.8041034220013, -122.403555563145) | |
| 82778 | 82778 | 18650 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 75 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017333.617127299 | 2096134.4813376998 | 37.736558188021704 | -122.38251858534201 | (37.7365581880217, -122.382518585342) | ||
| 88760 | 88760 | 18652 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 80 Reuel Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 6017340.7956251 | 2096041.6846083999 | 37.7363037832445 | -122.38248731128701 | (37.7363037832445, -122.382487311287) | |||
| 125389 | 125389 | 18655 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 85 Reuel Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | ||
| 130889 | 130889 | 68778 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2020 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1993 12:00:00 AM | 14 | 3x3 | Permit Number 32708 | 6006907.41923 | 2118207.98167 | 37.796585358595294 | -122.420132542485 | (37.7965853585953, -122.420132542485) | |
| 66931 | 66931 | 38591 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1615 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | Permit Number 40546 | 6015135.7246 | 2094671.1157 | 37.7324184244611 | -122.390015508372 | (37.7324184244611, -122.390015508372) | |
| 93857 | 93857 | 8232 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1500X Galvez Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/1992 12:00:00 AM | 6 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.739696749128896 | -122.385840466933 | (37.7396967491289, -122.385840466933) | ||
| 124181 | 124181 | 67694 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3330 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1992 12:00:00 AM | 6 | 3x3 | Permit Number 31302 | 5998887.34453115 | 2115637.9553757 | 37.7890736016783 | -122.447698559552 | (37.7890736016783, -122.447698559552) | |
| 125432 | 125432 | 8257 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1525 GALVEZ AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/1992 12:00:00 AM | 6 | 3x3 | 6016246.0 | 2097351.0 | 37.739838361172204 | -122.38636376878901 | (37.7398383611722, -122.386363768789) | ||
| 18932 | 18932 | 30938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1106 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 8 | 3x3 | Permit Number 772469 | 5995956.71997 | 2091289.90864 | 37.722052099618104 | -122.456077064214 | (37.7220520996181, -122.456077064214) | |
| 95623 | 95623 | 67035 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4212 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/09/1996 12:00:00 AM | Permit Number 30409 4212-4216 25th ST | 6002474.90568284 | 2101241.03339883 | 37.749747583750704 | -122.434256401684 | (37.7497475837507, -122.434256401684) | ||
| 43027 | 43027 | 94791 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 4 | Permit Number 53892 | 5997983.38903 | 2116351.46746 | 37.79098101110971 | -122.450877583428 | (37.7909810111097, -122.450877583428) | ||
| 53523 | 53523 | 48812 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.053730001 | 2102353.10418 | 37.753474456898104 | -122.392864530587 | (37.7534744568981, -122.392864530587) |
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");