Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 5654 | 5654 | 6078 | DPW Maintained 3 | Tristania conferta :: 79 | 1966 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001057.2451 | 2112477.7276 | 37.7805202046224 | -122.439964313123 | (37.7805202046224, -122.439964313123) | |||
| 5930 | 5930 | 12366 | DPW Maintained 3 | Tristania conferta :: 79 | 1314X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/1990 12:00:00 AM | 6 | 3X3 | 6004530.405 | 2113308.3501 | 37.782997988422 | -122.42800821421899 | (37.782997988422, -122.428008214219) | ||
| 6025 | 6025 | 9561 | Permitted Site 1 | Tristania conferta :: 79 | 1201 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003758.3426 | 2112108.0173 | 37.7796584641609 | -122.430593553118 | (37.7796584641609, -122.430593553118) | |||
| 6095 | 6095 | 12343 | DPW Maintained 3 | Tristania conferta :: 79 | 1200 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 6 | 4X4 | 6004715.5822 | 2113048.0527 | 37.7822937509983 | -122.42734902850401 | (37.7822937509983, -122.427349028504) | ||
| 6139 | 6139 | 13094 | Permitted Site 1 | Tristania conferta :: 79 | 1450 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1995 12:00:00 AM | 12 | 3X3 | 6005349.3555 | 2119944.5969 | 37.801265750478 | -122.425647455227 | (37.801265750478, -122.425647455227) | ||
| 6179 | 6179 | 9633 | DPW Maintained 3 | Tristania conferta :: 79 | 1455 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002619.654 | 2111947.8436 | 37.779154093768796 | -122.434521309627 | (37.7791540937688, -122.434521309627) | |||
| 6191 | 6191 | 13159 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003407.2588 | 2119680.3342 | 37.8004302230496 | -122.43234907433599 | (37.8004302230496, -122.432349074336) | |||
| 6253 | 6253 | 13146 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 6 | 3x3 | 6003666.0486 | 2119638.1147 | 37.800328969814 | -122.43145054275101 | (37.800328969814, -122.431450542751) | ||
| 6333 | 6333 | 6317 | DPW Maintained 3 | Tristania conferta :: 79 | 1830 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002046.2828 | 2112962.5168 | 37.781907565329206 | -122.436577479183 | (37.7819075653292, -122.436577479183) | |||
| 6345 | 6345 | 13106 | Permitted Site 1 | Tristania conferta :: 79 | 1557 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6004949.0522 | 2119813.2474 | 37.8008824710059 | -122.427023320732 | (37.8008824710059, -122.427023320732) | ||
| 6590 | 6590 | 21597 | DPW Maintained 3 | Tristania conferta :: 79 | 1515 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005206.9209 | 2114744.2763 | 37.7869789360246 | -122.42576998467301 | (37.7869789360246, -122.425769984673) | |||
| 6717 | 6717 | 6998 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002824.6489 | 2110299.3044 | 37.774639250423604 | -122.43369429514999 | (37.7746392504236, -122.43369429515) | ||
| 6826 | 6826 | 13243 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001148.9876 | 2119284.6646 | 37.799215511035705 | -122.440135189953 | (37.7992155110357, -122.440135189953) | |||
| 6887 | 6887 | 13251 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000984.848999999 | 2119261.9127 | 37.7991436944439 | -122.44070153167699 | (37.7991436944439, -122.440701531677) | |||
| 7143 | 7143 | 13163 | DPW Maintained 3 | Tristania conferta :: 79 | 1901 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003225.9808 | 2119572.2163 | 37.8001230789015 | -122.43296863968 | (37.8001230789015, -122.43296863968) | |||
| 7459 | 7459 | 7015 | Permitted Site 1 | Tristania conferta :: 79 | 1050 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002372.7109 | 2110234.5481 | 37.7744357915241 | -122.435253003778 | (37.7744357915241, -122.435253003778) | ||
| 7519 | 7519 | 14445 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5998940.7552 | 2112468.0825 | 37.7803730113246 | -122.44728552935801 | (37.7803730113246, -122.447285529358) | |||
| 7522 | 7522 | 13182 | DPW Maintained 3 | Tristania conferta :: 79 | 2001 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6002733.3901 | 2119504.96 | 37.7999104584024 | -122.434668379841 | (37.7999104584024, -122.434668379841) | |||
| 7530 | 7530 | 6981 | DPW Maintained 3 | Tristania conferta :: 79 | 802 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003535.9112 | 2110394.3354 | 37.77494051486671 | -122.431240682973 | (37.7749405148667, -122.431240682973) | |||
| 7536 | 7536 | 6323 | DPW Maintained 3 | Tristania conferta :: 79 | 1864 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001889.2551 | 2112939.5041 | 37.7818354537074 | -122.437119073338 | (37.7818354537074, -122.437119073338) | |||
| 7818 | 7818 | 6321 | DPW Maintained 3 | Tristania conferta :: 79 | 1862 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001938.3263 | 2112944.9189 | 37.781853110577 | -122.43694969789301 | (37.781853110577, -122.436949697893) | |||
| 7978 | 7978 | 18236 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 3 | 4X4 | 6003740.4545 | 2114242.5919999997 | 37.7855184591156 | -122.43080780955201 | (37.7855184591156, -122.430807809552) | ||
| 8200 | 8200 | 17682 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 12 | 4X4 | 6002406.1709 | 2112191.9515 | 37.7798122317892 | -122.43527729963002 | (37.7798122317892, -122.43527729963) | ||
| 8409 | 8409 | 14468 | DPW Maintained 3 | Tristania conferta :: 79 | 211 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 2X3 | 5998906.7438 | 2112277.8895 | 37.779848847108795 | -122.447389496791 | (37.7798488471088, -122.447389496791) | |||
| 8483 | 8483 | 21607 | DPW Maintained 3 | Tristania conferta :: 79 | 1525 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005102.2438 | 2114726.9152 | 37.7869253509843 | -122.426130907603 | (37.7869253509843, -122.426130907603) | |||
| 8600 | 8600 | 12267 | DPW Maintained 3 | Tristania conferta :: 79 | 649 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6004918.0391 | 2111202.3941 | 37.7772374748382 | -122.42651715535101 | (37.7772374748382, -122.426517155351) | ||
| 8775 | 8775 | 9640 | Permitted Site 1 | Tristania conferta :: 79 | 1475 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2002 12:00:00 AM | 3 | 3X3 | 6002575.9976 | 2111942.0905 | 37.779135818895 | -122.434671923313 | (37.779135818895, -122.434671923313) | ||
| 9049 | 9049 | 26865 | Permitted Site 1 | Tristania conferta :: 79 | 639 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004491.8585 | 2110789.0984 | 37.7760785645134 | -122.427961992802 | (37.7760785645134, -122.427961992802) | |||
| 9169 | 9169 | 7068 | Permitted Site 1 | Tristania conferta :: 79 | 1600 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 5999680.2623 | 2109860.1441 | 37.7732545074631 | -122.444539748344 | (37.7732545074631, -122.444539748344) | |||
| 9173 | 9173 | 21676 | Permitted Site 1 | Tristania conferta :: 79 | 1788 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004058.6995 | 2114630.6202 | 37.7866019128099 | -122.42973446123199 | (37.7866019128099, -122.429734461232) | |||
| 9229 | 9229 | 10682 | Permitted Site 1 | Tristania conferta :: 79 | 1145 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002385.9834 | 2110534.2276 | 37.7752593905207 | -122.43522853143 | (37.7752593905207, -122.43522853143) | |||
| 9532 | 9532 | 2443 | DPW Maintained 3 | Tristania conferta :: 79 | 1296X Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/22/1990 12:00:00 AM | 12 | 3X3 | 6004305.6638 | 2112931.8799 | 37.7819515776166 | -122.42875887985501 | (37.7819515776166, -122.428758879855) | ||
| 9607 | 9607 | 6248 | DPW Maintained 3 | Tristania conferta :: 79 | 1310X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004578.6077 | 2113315.336 | 37.783019896919605 | -122.427841950596 | (37.7830198969196, -122.427841950596) | |||
| 13604 | 13604 | 28836 | Permitted Site 1 | Tristania conferta :: 79 | 1501 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016976.7304 | 2093554.8023 | 37.729455180200794 | -122.383572968876 | (37.7294551802008, -122.383572968876) | ||
| 13617 | 13617 | 29430 | Permitted Site 1 | Tristania conferta :: 79 | 2401X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015434.0318 | 2091490.2952 | 37.7237010652846 | -122.388762207738 | (37.7237010652846, -122.388762207738) | ||
| 13658 | 13658 | 29560 | DPW Maintained 3 | Tristania conferta :: 79 | 3100X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 16 | 3X3 | 6014251.2078 | 2089975.3633 | 37.7194757354442 | -122.39274513029 | (37.7194757354442, -122.39274513029) | ||
| 13702 | 13702 | 22191 | Permitted Site 1 | Tristania conferta :: 79 | 4011 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 6015646.0862 | 2097696.0967 | 37.7407527004376 | -122.38846211797701 | (37.7407527004376, -122.388462117977) | |||
| 13783 | 13783 | 29532 | DPW Maintained 3 | Tristania conferta :: 79 | 2302X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015618.3638 | 2091811.707 | 37.7245938134403 | -122.388147417672 | (37.7245938134403, -122.388147417672) | ||
| 14182 | 14182 | 22366 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6014240.2849 | 2093075.8071 | 37.7279883280139 | -122.39299969922199 | (37.7279883280139, -122.392999699222) | |||
| 14292 | 14292 | 22494 | DPW Maintained 3 | Tristania conferta :: 79 | 6315 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6013237.8961 | 2090421.2401 | 37.7206436914379 | -122.39627903536699 | (37.7206436914379, -122.396279035367) | |||
| 14830 | 14830 | 29396 | Permitted Site 1 | Tristania conferta :: 79 | 3001 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014489.3554 | 2090228.1287 | 37.720183003403704 | -122.39193960073999 | (37.7201830034037, -122.39193960074) | ||
| 14832 | 14832 | 22358 | DPW Maintained 3 | Tristania conferta :: 79 | 5307 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6014347.5545 | 2093363.6036 | 37.7287845172254 | -122.392648986246 | (37.7287845172254, -122.392648986246) | |||
| 14949 | 14949 | 22438 | DPW Maintained 3 | Tristania conferta :: 79 | 6025 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6013608.4406 | 2091403.3166 | 37.72336088868371 | -122.395066921688 | (37.7233608886837, -122.395066921688) | |||
| 15171 | 15171 | 22197 | DPW Maintained 3 | Tristania conferta :: 79 | 4049 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015613.0199 | 2097583.199 | 37.740440874048204 | -122.388568571109 | (37.7404408740482, -122.388568571109) | |||
| 15301 | 15301 | 25475 | DPW Maintained 3 | Tristania conferta :: 79 | 1130 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/1997 12:00:00 AM | 6 | 3X3 | 6015469.9566 | 2096062.899 | 37.73625851112371 | -122.388957115588 | (37.7362585111237, -122.388957115588) | ||
| 15437 | 15437 | 28833 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016963.5397 | 2093616.3588 | 37.729623473146894 | -122.383622854715 | (37.7296234731469, -122.383622854715) | ||
| 15567 | 15567 | 22419 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/19/2000 12:00:00 AM | 3 | 3x3 | 6013854.3759 | 2092034.5068 | 37.7251076834032 | -122.394260933329 | (37.7251076834032, -122.394260933329) | ||
| 15654 | 15654 | 22460 | DPW Maintained 3 | Tristania conferta :: 79 | 6150 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013503.2659 | 2091352.4289 | 37.7232153120582 | -122.39542693034402 | (37.7232153120582, -122.395426930344) | |||
| 15670 | 15670 | 29518 | DPW Maintained 3 | Tristania conferta :: 79 | 2002X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6016118.5109 | 2092491.8522 | 37.7264890568376 | -122.38646585917401 | (37.7264890568376, -122.386465859174) | ||
| 15696 | 15696 | 29409 | Permitted Site 1 | Tristania conferta :: 79 | 2715X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014989.3241 | 2090898.8532 | 37.7220524249966 | -122.39025819753901 | (37.7220524249966, -122.390258197539) | ||
| 15952 | 15952 | 87520 | Permitted Site 1 | Tristania conferta :: 79 | 5299 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014418.8496 | 2093596.4572 | 37.7294278455371 | -122.39241879281201 | (37.7294278455371, -122.392418792812) | |||
| 16179 | 16179 | 30024 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013452.1791 | 2091216.0368 | 37.7228379652128 | -122.39559397744 | (37.7228379652128, -122.39559397744) | |||
| 16334 | 16334 | 22388 | Permitted Site 1 | Tristania conferta :: 79 | 5600 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2010 12:00:00 AM | 9 | 3X3 | Permit Number 53445 | 6014004.2537 | 2092658.7566 | 37.7268300775798 | -122.393786492489 | (37.7268300775798, -122.393786492489) | |
| 16346 | 16346 | 29504 | Permitted Site 1 | Tristania conferta :: 79 | 1800X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016442.8409 | 2092919.0689 | 37.7276800583286 | -122.38537441062401 | (37.7276800583286, -122.385374410624) | ||
| 16740 | 16740 | 29382 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014237.1991 | 2089885.2205 | 37.7192274430768 | -122.39278725067498 | (37.7192274430768, -122.392787250675) | ||
| 16769 | 16769 | 29493 | Permitted Site 1 | Tristania conferta :: 79 | 1700X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016630.1295 | 2093166.4001 | 37.728369541019894 | -122.384744167276 | (37.7283695410199, -122.384744167276) | ||
| 16817 | 16817 | 22393 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6013906.4177 | 2092399.467 | 37.726112683263295 | -122.39410656725799 | (37.7261126832633, -122.394106567258) | ||
| 16856 | 16856 | 22379 | DPW Maintained 3 | Tristania conferta :: 79 | 5545 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6014134.9775 | 2092764.4635 | 37.72712759108239 | -122.39334197422 | (37.7271275910824, -122.39334197422) | ||
| 17108 | 17108 | 9664 | DPW Maintained 3 | Tristania conferta :: 79 | 115 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006036.6387 | 2110130.4049 | 37.7743572242045 | -122.422571361821 | (37.7743572242045, -122.422571361821) | ||
| 17230 | 17230 | 15283 | DPW Maintained 3 | Tristania conferta :: 79 | 1600 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007077.8589 | 2109462.9776 | 37.7725833140899 | -122.41892223244699 | (37.7725833140899, -122.418922232447) | ||
| 17781 | 17781 | 24500 | DPW Maintained 3 | Tristania conferta :: 79 | 829X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/1995 12:00:00 AM | 12 | 3X3 | 6003428.9402 | 2110326.2031 | 37.774747377761294 | -122.43160585304399 | (37.7747473777613, -122.431605853044) | ||
| 18723 | 18723 | 6970 | DPW Maintained 3 | Tristania conferta :: 79 | 735 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/1995 12:00:00 AM | 12 | 3X3 | 6003863.6109 | 2110389.5025 | 37.7749458101955 | -122.430106755206 | (37.7749458101955, -122.430106755206) | ||
| 19294 | 19294 | 9654 | DPW Maintained 3 | Tristania conferta :: 79 | 95 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 3 | 3X3 | 6006063.7461 | 2109945.4115 | 37.7738508061395 | -122.422464444627 | (37.7738508061395, -122.422464444627) | ||
| 21162 | 21162 | 24502 | DPW Maintained 3 | Tristania conferta :: 79 | 901 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003065.2332 | 2110278.53 | 37.7745958573502 | -122.432860582365 | (37.7745958573502, -122.432860582365) | ||
| 21220 | 21220 | 25224 | DPW Maintained 3 | Tristania conferta :: 79 | 1951 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5993865.4444 | 2092626.4035 | 37.7256015312656 | -122.463402969615 | (37.7256015312656, -122.463402969615) | |||
| 22202 | 22202 | 2173 | DPW Maintained 3 | Tristania conferta :: 79 | 1010X Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6001288.5645 | 2109046.8136 | 37.77111294397879 | -122.438918128915 | (37.7711129439788, -122.438918128915) | |||
| 23346 | 23346 | 9596 | DPW Maintained 3 | Tristania conferta :: 79 | 1340 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 11 | 3X3 | 6003149.1044 | 2112077.4625 | 37.7795400355594 | -122.432698986969 | (37.7795400355594, -122.432698986969) | ||
| 23565 | 23565 | 140557 | Undocumented 2 | Tristania conferta :: 79 | 1175 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003583.5208 | 2111740.6921 | 37.7786399751241 | -122.43117211119 | (37.7786399751241, -122.43117211119) | |||
| 23809 | 23809 | 139263 | Undocumented 2 | Tristania conferta :: 79 | 760 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004028.8382 | 2111306.0158 | 37.7774716865894 | -122.42960057778 | (37.7774716865894, -122.42960057778) | |||
| 24026 | 24026 | 140096 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005837.0353 | 2111584.8045 | 37.7783393900211 | -122.42336524088002 | (37.7783393900211, -122.42336524088) | |||
| 26024 | 26024 | 245425 | Undocumented 2 | Tristania conferta :: 79 | 2500 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009073.1901 | 2106875.611 | 37.7655911583595 | -122.411837285128 | (37.7655911583595, -122.411837285128) | |||
| 26584 | 26584 | 137902 | Undocumented 2 | Tristania conferta :: 79 | 404 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005251.6199 | 2115313.5756 | 37.788544615646 | -122.425655870363 | (37.788544615646, -122.425655870363) | |||
| 26798 | 26798 | 199951 | Undocumented 2 | Tristania conferta :: 79 | 1899 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016408.6882 | 2092795.6787 | 37.7273393636102 | -122.38548388280701 | (37.7273393636102, -122.385483882807) | |||
| 28177 | 28177 | 244436 | Undocumented 2 | Tristania conferta :: 79 | 404 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004598.6589 | 2109671.3511 | 37.7730155449031 | -122.42751289271999 | (37.7730155449031, -122.42751289272) | |||
| 28652 | 28652 | 35644 | Permitted Site 1 | Tristania conferta :: 79 | 635 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1998 12:00:00 AM | 9 | Permit Number 38976 | 6004498.2203 | 2110755.6153 | 37.7759869880383 | -122.427937599156 | (37.7759869880383, -122.427937599156) | ||
| 28713 | 28713 | 199660 | Undocumented 2 | Tristania conferta :: 79 | 2799 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014919.1748 | 2090797.1689 | 37.7217693287026 | -122.390493586774 | (37.7217693287026, -122.390493586774) | |||
| 29166 | 29166 | 137923 | Undocumented 2 | Tristania conferta :: 79 | 1901 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003379.2097 | 2115283.9028 | 37.788357161353105 | -122.432131998946 | (37.7883571613531, -122.432131998946) | |||
| 29984 | 29984 | 140324 | Undocumented 2 | Tristania conferta :: 79 | 1465 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004553.8078 | 2113880.8448 | 37.784571240321604 | -122.42796805864799 | (37.7845712403216, -122.427968058648) | |||
| 30044 | 30044 | 140524 | Undocumented 2 | Tristania conferta :: 79 | 1140 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003674.0233 | 2111802.6448 | 37.778815210032 | -122.430863450741 | (37.778815210032, -122.430863450741) | |||
| 30896 | 30896 | 138911 | Undocumented 2 | Tristania conferta :: 79 | 723 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004266.8521 | 2110794.1209 | 37.776079623036 | -122.428740708053 | (37.776079623036, -122.428740708053) | |||
| 30915 | 30915 | 142286 | Undocumented 2 | Tristania conferta :: 79 | 1670 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999804.9802 | 2110571.1381 | 37.7752138319513 | -122.444159433615 | (37.7752138319513, -122.444159433615) | |||
| 31623 | 31623 | 92117 | Permitted Site 1 | Tristania conferta :: 79 | 2012 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52450 | 6004206.4384 | 2115352.2396 | 37.788591662793 | -122.42927479639401 | (37.788591662793, -122.429274796394) | |
| 31667 | 31667 | 199657 | Undocumented 2 | Tristania conferta :: 79 | 1395 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015062.4933 | 2090889.5822 | 37.7220310269415 | -122.39000462027599 | (37.7220310269415, -122.390004620276) | |||
| 32015 | 32015 | 184222 | Undocumented 2 | Tristania conferta :: 79 | 3521 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983907.1382 | 2104926.4256 | 37.7587952746185 | -122.49873571831999 | (37.7587952746185, -122.49873571832) | |||
| 32291 | 32291 | 140132 | Undocumented 2 | Tristania conferta :: 79 | 501 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005852.7764 | 2111465.1717 | 37.778011795869006 | -122.42330228001002 | (37.778011795869, -122.42330228001) |
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");