Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 360 | 360 | 6307 | DPW Maintained 3 | Tristania conferta :: 79 | 1804 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6002139.3488 | 2112974.3616 | 37.781945376326 | -122.436256362281 | (37.781945376326, -122.436256362281) | |||
| 466 | 466 | 1665 | DPW Maintained 3 | Tristania conferta :: 79 | 1400X Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6000409.8977 | 2109962.9335 | 37.7735783473195 | -122.44202322778901 | (37.7735783473195, -122.442023227789) | ||
| 687 | 687 | 13252 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001005.1632 | 2119265.163 | 37.7991537757264 | -122.440631471061 | (37.7991537757264, -122.440631471061) | |||
| 700 | 700 | 6319 | DPW Maintained 3 | Tristania conferta :: 79 | 1860 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001987.058999999 | 2112951.3489 | 37.781873535447396 | -122.436781566115 | (37.7818735354474, -122.436781566115) | |||
| 739 | 739 | 13244 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2012 12:00:00 AM | 3 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.44006524578501 | (37.7992300540772, -122.440065245785) | ||
| 823 | 823 | 13156 | Permitted Site 1 | Tristania conferta :: 79 | 1875 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003411.9498 | 2119598.2407 | 37.800205081624604 | -122.432326975222 | (37.8002050816246, -122.432326975222) | |||
| 877 | 877 | 6322 | DPW Maintained 3 | Tristania conferta :: 79 | 1864 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001909.5604 | 2112942.2115 | 37.7818440417219 | -122.43704902046998 | (37.7818440417219, -122.43704902047) | |||
| 880 | 880 | 246102 | DPW Maintained 3 | Tristania conferta :: 79 | 1764 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 5997188.4287 | 2108119.9769 | 37.768333957535795 | -122.453033652641 | (37.7683339575358, -122.453033652641) | |||
| 978 | 978 | 200822 | DPW Maintained 3 | Tristania conferta :: 79 | 5266 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6014368.9731 | 2093728.9009999998 | 37.7297887395904 | -122.392600482998 | (37.7297887395904, -122.392600482998) | |||
| 979 | 979 | 200925 | Undocumented 2 | Tristania conferta :: 79 | 4100 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | Width 0ft | 6015478.3928 | 2097437.2349 | 37.7400326248174 | -122.389023874228 | (37.7400326248174, -122.389023874228) | ||
| 984 | 984 | 24262 | DPW Maintained 3 | Tristania conferta :: 79 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | ||
| 986 | 986 | 200823 | DPW Maintained 3 | Tristania conferta :: 79 | 5286 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/1998 12:00:00 AM | 4 | Width 0ft | 6014347.7859 | 2093662.4762 | 37.7296051738385 | -122.392669085224 | (37.7296051738385, -122.392669085224) | ||
| 990 | 990 | 13179 | DPW Maintained 3 | Tristania conferta :: 79 | 1976 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6002902.1538 | 2119607.7128 | 37.8002021701058 | -122.434091743886 | (37.8002021701058, -122.434091743886) | ||
| 1017 | 1017 | 6253 | Permitted Site 1 | Tristania conferta :: 79 | 1315 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2004 12:00:00 AM | 9 | 3X3 | 6004522.7205 | 2113262.2432 | 37.782870955582794 | -122.428031512738 | (37.7828709555828, -122.428031512738) | ||
| 1020 | 1020 | 10701 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001704.3359 | 2110485.9297 | 37.7750880443133 | -122.43758304169201 | (37.7750880443133, -122.437583041692) | |||
| 1088 | 1088 | 7067 | DPW Maintained 3 | Tristania conferta :: 79 | 1600 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/2016 12:00:00 AM | 3 | 3x3 | 5999719.0796 | 2109864.829 | 37.773269585855104 | -122.444405811275 | (37.7732695858551, -122.444405811275) | ||
| 1195 | 1195 | 12282 | DPW Maintained 3 | Tristania conferta :: 79 | 745 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x10 | 6004875.3929 | 2111529.8441 | 37.7781341613075 | -122.42668800624901 | (37.7781341613075, -122.426688006249) | |||
| 1242 | 1242 | 138398 | DPW Maintained 3 | Tristania conferta :: 79 | 2445 PINE ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 6002388.1124 | 2115043.7135 | 37.787641421844896 | -122.435543840756 | (37.7876414218449, -122.435543840756) | |||
| 1247 | 1247 | 13128 | DPW Maintained 3 | Tristania conferta :: 79 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.42985071173901 | (37.8007374433085, -122.429850711739) | |||
| 1263 | 1263 | 138399 | DPW Maintained 3 | Tristania conferta :: 79 | 2445 PINE ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6002411.2137 | 2115044.4135 | 37.7876446559027 | -122.435463964972 | (37.7876446559027, -122.435463964972) | |||
| 1346 | 1346 | 21675 | Permitted Site 1 | Tristania conferta :: 79 | 1788 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004079.3213 | 2114634.9946 | 37.7866150915141 | -122.42966342693899 | (37.7866150915141, -122.429663426939) | |||
| 1424 | 1424 | 13099 | Permitted Site 1 | Tristania conferta :: 79 | 1501 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1995 12:00:00 AM | 6 | 3X3 | 6005022.5453 | 2119823.4113 | 37.800914533929294 | -122.4267697277 | (37.8009145339293, -122.4267697277) | ||
| 1505 | 1505 | 8187 | DPW Maintained 3 | Tristania conferta :: 79 | 1255 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001743.6158 | 2111134.8252 | 37.7768719817661 | -122.43749364217301 | (37.7768719817661, -122.437493642173) | |||
| 1530 | 1530 | 13180 | Permitted Site 1 | Tristania conferta :: 79 | 1990 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 15 | 3X3 | 6002882.226 | 2119605.2218 | 37.8001941994801 | -122.434160523596 | (37.8001941994801, -122.434160523596) | ||
| 1927 | 1927 | 10692 | DPW Maintained 3 | Tristania conferta :: 79 | 1249 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001880.3859 | 2110463.9678 | 37.7750377503654 | -122.43697247440201 | (37.7750377503654, -122.436972474402) | |||
| 1978 | 1978 | 141844 | DPW Maintained 3 | Tristania conferta :: 79 | 1295 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 09:40:00 AM | 8 | Width 0ft | 6004339.0372 | 2112890.3204 | 37.781839354336 | -122.428640459804 | (37.781839354336, -122.428640459804) | ||
| 1999 | 1999 | 141841 | DPW Maintained 3 | Tristania conferta :: 79 | 1297 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6004290.5512 | 2112882.1345 | 37.781814133771704 | -122.42880761506001 | (37.7818141337717, -122.42880761506) | |||
| 2008 | 2008 | 6077 | DPW Maintained 3 | Tristania conferta :: 79 | 1966 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2007 12:00:00 AM | 18 | 4X4 | 6001073.8278 | 2112479.7581 | 37.7805267238289 | -122.43990709148198 | (37.7805267238289, -122.439907091482) | ||
| 2017 | 2017 | 13264 | DPW Maintained 3 | Tristania conferta :: 79 | 2460 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 19 | 3X3 | 6000672.0217 | 2119297.5934 | 37.7992238445501 | -122.441786579885 | (37.7992238445501, -122.441786579885) | ||
| 2329 | 2329 | 6184 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005484.2824 | 2113445.6337 | 37.7834288547985 | -122.424717956993 | (37.7834288547985, -122.424717956993) | |||
| 2361 | 2361 | 12987 | Permitted Site 1 | Tristania conferta :: 79 | 318 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6010766.7048 | 2120702.1725 | 37.8036504876245 | -122.406954379692 | (37.8036504876245, -122.406954379692) | ||
| 2471 | 2471 | 7042 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2009 12:00:00 AM | 3 | 3X3 | 6001153.5455 | 2110065.6201 | 37.7739026486508 | -122.43945820683099 | (37.7739026486508, -122.439458206831) | ||
| 2481 | 2481 | 12266 | DPW Maintained 3 | Tristania conferta :: 79 | 649 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 16 | 3X3 | 6004915.2268 | 2111219.2684 | 37.7772836485499 | -122.426528085844 | (37.7772836485499, -122.426528085844) | ||
| 2578 | 2578 | 21604 | Permitted Site 1 | Tristania conferta :: 79 | 1521 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005122.6686 | 2114733.0427 | 37.7869433299583 | -122.426060678785 | (37.7869433299583, -122.426060678785) | |||
| 2624 | 2624 | 13174 | Permitted Site 1 | Tristania conferta :: 79 | 1950 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 14 | 3X3 | 6003011.134 | 2119622.0359 | 37.80024768199421 | -122.43371565452 | (37.8002476819942, -122.43371565452) | ||
| 2645 | 2645 | 13092 | Permitted Site 1 | Tristania conferta :: 79 | 1447 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2005 12:00:00 AM | 8 | 3x3 | 6005407.9937 | 2119875.0129 | 37.8010780038521 | -122.42543958631501 | (37.8010780038521, -122.425439586315) | ||
| 2670 | 2670 | 246001 | DPW Maintained 3 | Tristania conferta :: 79 | 1437 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 3 | Width 0ft | 5999214.6581 | 2108701.4088 | 37.7700463362513 | -122.446066968815 | (37.7700463362513, -122.446066968815) | ||
| 2701 | 2701 | 141995 | DPW Maintained 3 | Tristania conferta :: 79 | 818 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/1999 12:00:00 AM | 5 | Width 0ft | 6003983.7554 | 2111636.8614 | 37.778377554053 | -122.42978013780301 | (37.778377554053, -122.429780137803) | ||
| 2704 | 2704 | 7043 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 12 | 3X3 | 6001130.7028 | 2110062.144 | 37.773891804124 | -122.43953697407801 | (37.773891804124, -122.439536974078) | ||
| 2710 | 2710 | 141992 | DPW Maintained 3 | Tristania conferta :: 79 | 818 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2005 12:00:00 AM | 9 | Width 0ft | 6003994.291 | 2111559.6951 | 37.778166271074205 | -122.429738185966 | (37.7781662710742, -122.429738185966) | ||
| 2729 | 2729 | 141998 | DPW Maintained 3 | Tristania conferta :: 79 | 818 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1990 12:00:00 AM | 13 | Width 0ft | 6003974.6435 | 2111716.5903 | 37.778595953895795 | -122.42981734758699 | (37.7785959538958, -122.429817347587) | ||
| 2795 | 2795 | 6186 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005445.8524 | 2113436.2606 | 37.783400948036 | -122.42485024282301 | (37.783400948036, -122.424850242823) | |||
| 2847 | 2847 | 7089 | Permitted Site 1 | Tristania conferta :: 79 | 1874 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2009 12:00:00 AM | 3 | 3x3 | 5998459.5467 | 2109686.5004 | 37.7727079965007 | -122.448749840415 | (37.7727079965007, -122.448749840415) | ||
| 2872 | 2872 | 7051 | Permitted Site 1 | Tristania conferta :: 79 | 1350 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6000969.3144 | 2110039.798 | 37.773821261144 | -122.440093639062 | (37.773821261144, -122.440093639062) | ||
| 2936 | 2936 | 246076 | Permitted Site 1 | Tristania conferta :: 79 | 1215 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 11 | Width 0ft | Permit Number 17670 | 5999867.5576 | 2108450.6663 | 37.769395122673394 | -122.443790589358 | (37.7693951226734, -122.443790589358) | |
| 2965 | 2965 | 6183 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005506.7779 | 2113443.7591 | 37.78342497809621 | -122.424639997895 | (37.7834249780962, -122.424639997895) | |||
| 2968 | 2968 | 7092 | Permitted Site 1 | Tristania conferta :: 79 | 1926 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 5998180.0393 | 2109648.8744 | 37.7725886979314 | -122.449713970747 | (37.7725886979314, -122.449713970747) | ||
| 2972 | 2972 | 246077 | Permitted Site 1 | Tristania conferta :: 79 | 1221 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 6 | Width 0ft | Permit Number 17671 | 5999841.5143 | 2108446.1238 | 37.769381164613 | -122.443880345259 | (37.769381164613, -122.443880345259) | |
| 2981 | 2981 | 245990 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 11 | Width 0ft | Permit Number 53135 | 5999824.4044 | 2108487.46 | 37.76949368743671 | -122.44394249781901 | (37.7694936874367, -122.443942497819) | |
| 2995 | 2995 | 245989 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 14 | Width 0ft | Permit Number 53135 | 5999854.6873 | 2108493.8194 | 37.7695128761205 | -122.443838207787 | (37.7695128761205, -122.443838207787) | |
| 3047 | 3047 | 246310 | DPW Maintained 3 | Tristania conferta :: 79 | 1601 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2012 10:05:00 AM | 2 | Width 0ft | 6007075.5388 | 2109348.1328 | 37.7722678469563 | -122.41892211112301 | (37.7722678469563, -122.418922111123) | ||
| 3074 | 3074 | 199930 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016497.9258 | 2092921.8231 | 37.727690668221506 | -122.385184171361 | (37.7276906682215, -122.385184171361) | ||
| 3080 | 3080 | 28823 | Permitted Site 1 | Tristania conferta :: 79 | 1054 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002356.6442 | 2110231.7539 | 37.77442720694221 | -122.435308381556 | (37.7744272069422, -122.435308381556) | ||
| 3081 | 3081 | 199928 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/27/2008 12:00:00 AM | 4 | Width 0ft | 6016476.4427 | 2092884.9162 | 37.727588140695204 | -122.385255868852 | (37.7275881406952, -122.385255868852) | ||
| 3082 | 3082 | 199927 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 5 | Width 0ft | 6016464.324 | 2092869.4925 | 37.7275451198245 | -122.385296689415 | (37.7275451198245, -122.385296689415) | ||
| 3094 | 3094 | 253300 | Undocumented 2 | Tristania conferta :: 79 | 844 33rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5985769.0 | 2110141.0 | 37.773222058846 | -122.492680686455 | (37.773222058846, -122.492680686455) | ||||
| 3105 | 3105 | 199929 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | ||
| 3108 | 3108 | 6223 | DPW Maintained 3 | Tristania conferta :: 79 | 1220 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/1997 12:00:00 AM | 12 | 3X4 | 6005122.7706 | 2113389.4093 | 37.78325405223279 | -122.425964643575 | (37.7832540522328, -122.425964643575) | ||
| 3181 | 3181 | 18082 | DPW Maintained 3 | Tristania conferta :: 79 | 2970 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/17/2009 12:00:00 AM | 6 | 3X3 | 5999722.7619 | 2114728.5921 | 37.786624438592604 | -122.44474274230801 | (37.7866244385926, -122.444742742308) | ||
| 3260 | 3260 | 42633 | DPW Maintained 3 | Tristania conferta :: 79 | 1651 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:56:00 PM | 3 | 5x5 | Permit Number 45045 | 6005048.16251 | 2118816.23898 | 37.7981505449739 | -122.426609321383 | (37.7981505449739, -122.426609321383) |
| 3288 | 3288 | 13145 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 8 | 3X3 | 6003646.5026 | 2119634.2054 | 37.8003171280845 | -122.431517900376 | (37.8003171280845, -122.431517900376) | ||
| 3350 | 3350 | 21605 | Permitted Site 1 | Tristania conferta :: 79 | 1521 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005164.0288 | 2114740.1913 | 37.7869652957353 | -122.425918090858 | (37.7869652957353, -122.425918090858) | |||
| 3372 | 3372 | 101650 | Undocumented 2 | Tristania conferta :: 79 | 3X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5998828.7375 | 2112398.5369 | 37.780175655731796 | -122.447668041416 | (37.7801756557318, -122.447668041416) | |||
| 3504 | 3504 | 7057 | DPW Maintained 3 | Tristania conferta :: 79 | 1390 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/1990 12:00:00 AM | 12 | 3X3 | 6000831.7617 | 2110022.9142 | 37.7737670706815 | -122.44056824359899 | (37.7737670706815, -122.440568243599) | ||
| 3588 | 3588 | 24306 | Permitted Site 1 | Tristania conferta :: 79 | 1513 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1994 12:00:00 AM | 3 | 6002219.6394 | 2111892.3425 | 37.7789789862822 | -122.435901149592 | (37.7789789862822, -122.435901149592) | |||
| 3599 | 3599 | 12345 | DPW Maintained 3 | Tristania conferta :: 79 | 1200 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/27/1992 12:00:00 AM | 6 | 4X4 | 6004709.3369 | 2113084.1368 | 37.782392475782 | -122.42737320580099 | (37.782392475782, -122.427373205801) | ||
| 3641 | 3641 | 13162 | Permitted Site 1 | Tristania conferta :: 79 | 1901 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/1997 12:00:00 AM | 6 | 3X3 | 6003171.1793 | 2119566.6116 | 37.8001045813382 | -122.433157873196 | (37.8001045813382, -122.433157873196) | ||
| 3666 | 3666 | 21602 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005338.1501 | 2114762.148 | 37.7870354220648 | -122.425317233161 | (37.7870354220648, -122.425317233161) | |||
| 3704 | 3704 | 6903 | Permitted Site 1 | Tristania conferta :: 79 | 333 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3X3 | 6005734.9676 | 2110651.7554 | 37.775771702887894 | -122.42365197493 | (37.7757717028879, -122.42365197493) | ||
| 3752 | 3752 | 7102 | DPW Maintained 3 | Tristania conferta :: 79 | 2080 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 5997497.5881 | 2109552.6978 | 37.7722855537803 | -122.45206768793001 | (37.7722855537803, -122.45206768793) | |||
| 3764 | 3764 | 24423 | Permitted Site 1 | Tristania conferta :: 79 | 1707 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3x3 | 6005275.9761 | 2115602.2731 | 37.7893386830183 | -122.425592156658 | (37.7893386830183, -122.425592156658) | ||
| 3926 | 3926 | 13242 | DPW Maintained 3 | Tristania conferta :: 79 | 2353 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001124.6106 | 2119280.6018 | 37.7992029678306 | -122.440219251047 | (37.7992029678306, -122.440219251047) | |||
| 3985 | 3985 | 12338 | DPW Maintained 3 | Tristania conferta :: 79 | 1151X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1997 12:00:00 AM | 12 | 3X3 | 6004696.7001 | 2112810.35 | 37.7816400103646 | -122.427397413482 | (37.7816400103646, -122.427397413482) | ||
| 4172 | 4172 | 6318 | DPW Maintained 3 | Tristania conferta :: 79 | 1860 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002006.0106 | 2112955.7484 | 37.7818866924078 | -122.436716317501 | (37.7818866924078, -122.436716317501) | |||
| 4181 | 4181 | 21599 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x3 | 6005255.9404 | 2114750.4037 | 37.7869985302762 | -122.425600824408 | (37.7869985302762, -122.425600824408) | |||
| 4200 | 4200 | 28075 | Permitted Site 1 | Tristania conferta :: 79 | 915 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008651.5543 | 2120512.2278 | 37.8030103621977 | -122.41426054224199 | (37.8030103621977, -122.414260542242) | ||
| 4388 | 4388 | 251703 | Undocumented 2 | Tristania conferta :: 79 | 123 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:45:00 AM | 3 | 3x3 | 6004216.0 | 2094352.0 | 37.7309305395323 | -122.42774483827299 | (37.7309305395323, -122.427744838273) | ||
| 4438 | 4438 | 6185 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005465.536 | 2113438.1352 | 37.783407206982005 | -122.424782278636 | (37.783407206982, -122.424782278636) | |||
| 4445 | 4445 | 13100 | DPW Maintained 3 | Tristania conferta :: 79 | 1501 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/12/2017 12:00:00 AM | 8 | 3X3 | 6005075.7106 | 2119828.8842 | 37.800932566852005 | -122.42658614308701 | (37.800932566852, -122.426586143087) | ||
| 4457 | 4457 | 13208 | Permitted Site 1 | Tristania conferta :: 79 | 2199 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 6 | 3X3 | 6001971.1512 | 2119400.3389 | 37.7995798943259 | -122.437298513288 | (37.7995798943259, -122.437298513288) | ||
| 4588 | 4588 | 200921 | Permitted Site 1 | Tristania conferta :: 79 | 4040 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/18/2008 12:00:00 AM | 5 | Width 0ft | 6015547.5959 | 2097647.2059 | 37.7406129979736 | -122.388799250904 | (37.7406129979736, -122.388799250904) | |
| 4634 | 4634 | 13151 | Permitted Site 1 | Tristania conferta :: 79 | 1850 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 6 | 3x3 | 6003502.6435 | 2119692.0618 | 37.8004678320559 | -122.43201984317899 | (37.8004678320559, -122.432019843179) | ||
| 4663 | 4663 | 17684 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002398.395 | 2112227.2208 | 37.7799086308334 | -122.435306723377 | (37.7799086308334, -122.435306723377) | |||
| 4690 | 4690 | 253527 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:54:00 AM | 3 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | ||
| 4692 | 4692 | 6906 | DPW Maintained 3 | Tristania conferta :: 79 | 333 Fell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:59:00 AM | 3 | 3X3 | 6005816.7808 | 2110662.8487 | 37.7758067801978 | -122.423369750882 | (37.7758067801978, -122.423369750882) | ||
| 4812 | 4812 | 24261 | DPW Maintained 3 | Tristania conferta :: 79 | 600X Willow St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004538.0187 | 2113122.6754 | 37.7824886025731 | -122.427968638693 | (37.7824886025731, -122.427968638693) | ||
| 4813 | 4813 | 14801 | DPW Maintained 3 | Tristania conferta :: 79 | 1140 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1994 12:00:00 AM | 12 | 4X4 | 6003706.6875 | 2111805.6833 | 37.7788254036612 | -122.430750669342 | (37.7788254036612, -122.430750669342) | ||
| 4874 | 4874 | 14465 | Permitted Site 1 | Tristania conferta :: 79 | 161 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1994 12:00:00 AM | 50 | 3X3 | 5998884.4079 | 2112430.1793 | 37.7802657190757 | -122.447477731101 | (37.7802657190757, -122.447477731101) | ||
| 5039 | 5039 | 13231 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6001312.3137 | 2119307.4165 | 37.7992872786644 | -122.43957165866001 | (37.7992872786644, -122.43957165866) | |||
| 5258 | 5258 | 7076 | Permitted Site 1 | Tristania conferta :: 79 | 1712 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3 | 3x3 | 5999133.3592 | 2109779.0297 | 37.7730005664352 | -122.44642571608499 | (37.7730005664352, -122.446425716085) | ||
| 5298 | 5298 | 13176 | Permitted Site 1 | Tristania conferta :: 79 | 1964 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6002959.4463 | 2119614.5629 | 37.800224230069205 | -122.43389397959601 | (37.8002242300692, -122.433893979596) | |||
| 5304 | 5304 | 5192 | DPW Maintained 3 | Tristania conferta :: 79 | 553 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/27/1992 12:00:00 AM | 6 | 3X3 | 6001623.3101 | 2110351.6501 | 37.7747147390438 | -122.437853707483 | (37.7747147390438, -122.437853707483) | ||
| 5310 | 5310 | 6936 | DPW Maintained 3 | Tristania conferta :: 79 | 528 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6004857.7315 | 2110586.3971 | 37.775542688283 | -122.426681902022 | (37.775542688283, -122.426681902022) | ||
| 5315 | 5315 | 18239 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2000 12:00:00 AM | 3 | 4X4 | 6003687.2504 | 2114237.8837 | 37.7855025167716 | -122.43099154386499 | (37.7855025167716, -122.430991543865) | ||
| 5351 | 5351 | 13158 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6003428.3685 | 2119684.2434 | 37.8004421536411 | -122.432276305709 | (37.8004421536411, -122.432276305709) | |||
| 5368 | 5368 | 13177 | Permitted Site 1 | Tristania conferta :: 79 | 1970 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1995 12:00:00 AM | 35 | 3x3 | 6002925.1953 | 2119612.0719999997 | 37.8002154469875 | -122.434012323171 | (37.8002154469875, -122.434012323171) | ||
| 5369 | 5369 | 12368 | DPW Maintained 3 | Tristania conferta :: 79 | 1325 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 18 | 3X3 | 6004615.632999999 | 2113432.0006 | 37.7833423233744 | -122.42772217323 | (37.7833423233744, -122.42772217323) | ||
| 5416 | 5416 | 9589 | DPW Maintained 3 | Tristania conferta :: 79 | 1320 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/1997 12:00:00 AM | 6 | 3X3 | 6003248.1509 | 2112093.2525 | 37.779589007656604 | -122.432357471075 | (37.7795890076566, -122.432357471075) | ||
| 5419 | 5419 | 10640 | DPW Maintained 3 | Tristania conferta :: 79 | 879 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/1992 12:00:00 AM | 12 | 3X3 | 6003664.2022 | 2110709.9334 | 37.7758143385689 | -122.430819424449 | (37.7758143385689, -122.430819424449) | ||
| 5463 | 5463 | 10657 | DPW Maintained 3 | Tristania conferta :: 79 | 945 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/1990 12:00:00 AM | 6 | 6003325.2554 | 2110665.5174 | 37.7756731734805 | -122.43198875443701 | (37.7756731734805, -122.431988754437) |
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");