Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 5483 | 5483 | 17683 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002401.1721 | 2112213.0575 | 37.7798698996827 | -122.43529610278401 | (37.7798698996827, -122.435296102784) | |||
| 5517 | 5517 | 10700 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001738.9392 | 2110489.0192 | 37.775098494652795 | -122.437463562764 | (37.7750984946528, -122.437463562764) | |||
| 5527 | 5527 | 23775 | DPW Maintained 3 | Tristania conferta :: 79 | 1000 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 8 | 3X3 | 6003905.7295 | 2112204.2911 | 37.7799311566149 | -122.43009054793801 | (37.7799311566149, -122.430090547938) | ||
| 5607 | 5607 | 6200 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005257.1287 | 2113359.2082 | 37.783178719822295 | -122.42549766781099 | (37.7831787198223, -122.425497667811) | |||
| 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) | |||
| 5670 | 5670 | 10699 | DPW Maintained 3 | Tristania conferta :: 79 | 1275 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001777.3475 | 2110450.1636 | 37.774993990438205 | -122.43732791737 | (37.7749939904382, -122.43732791737) | |||
| 5834 | 5834 | 6999 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002754.2205 | 2110289.0229 | 37.774607023478 | -122.433937185692 | (37.774607023478, -122.433937185692) | ||
| 5898 | 5898 | 14455 | DPW Maintained 3 | Tristania conferta :: 79 | 125 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998862.4105 | 2112574.347 | 37.780660309110296 | -122.447564210548 | (37.7806603091103, -122.447564210548) | |||
| 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) | ||
| 5939 | 5939 | 10696 | DPW Maintained 3 | Tristania conferta :: 79 | 1257 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001848.8335 | 2110459.5307 | 37.7750237737687 | -122.43708130308998 | (37.7750237737687, -122.43708130309) | |||
| 5940 | 5940 | 6997 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002869.8876 | 2110306.5014 | 37.7746615784305 | -122.433538320063 | (37.7746615784305, -122.433538320063) | ||
| 5950 | 5950 | 6955 | DPW Maintained 3 | Tristania conferta :: 79 | 612 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004444.1451 | 2110522.7405 | 37.7753445115637 | -122.428108060089 | (37.7753445115637, -122.428108060089) | ||
| 5959 | 5959 | 23753 | DPW Maintained 3 | Tristania conferta :: 79 | 900X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 25 | 4x4 | 6003923.4316 | 2112087.5817 | 37.7796117041387 | -122.43002098071501 | (37.7796117041387, -122.430020980715) | ||
| 6020 | 6020 | 13137 | DPW Maintained 3 | Tristania conferta :: 79 | 1769 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6003915.4564 | 2119670.1702 | 37.8004311181643 | -122.430589781889 | (37.8004311181643, -122.430589781889) | ||
| 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) | ||
| 6104 | 6104 | 18099 | DPW Maintained 3 | Tristania conferta :: 79 | 3019 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999451.351 | 2114633.9478 | 37.786349077981 | -122.445674946059 | (37.786349077981, -122.445674946059) | |||
| 6125 | 6125 | 6977 | DPW Maintained 3 | Tristania conferta :: 79 | 748 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/1990 12:00:00 AM | 12 | 3X3 | 6003831.4789 | 2110436.0515 | 37.775071802393896 | -122.43022122824699 | (37.7750718023939, -122.430221228247) | ||
| 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) | |||
| 6193 | 6193 | 5895 | DPW Maintained 3 | Tristania conferta :: 79 | 1148 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3x3 | 6004928.6171 | 2113019.6018 | 37.7822276779046 | -122.426609995389 | (37.7822276779046, -122.426609995389) | ||
| 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) | |||
| 6425 | 6425 | 17834 | DPW Maintained 3 | Tristania conferta :: 79 | 2005 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 6 | 3X3 | 6004202.6696 | 2115296.0495 | 37.7884371655847 | -122.429283827501 | (37.7884371655847, -122.429283827501) | ||
| 6471 | 6471 | 14471 | DPW Maintained 3 | Tristania conferta :: 79 | 227 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5998914.8659 | 2112201.4062 | 37.77963930788229 | -122.447355892513 | (37.7796393078823, -122.447355892513) | |||
| 6482 | 6482 | 6194 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005201.2129999995 | 2113404.3918 | 37.7832996233389 | -122.42569433072799 | (37.7832996233389, -122.425694330728) | |||
| 6525 | 6525 | 6233 | DPW Maintained 3 | Tristania conferta :: 79 | 1250 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/1997 12:00:00 AM | 6 | 3X3 | 6004966.7765 | 2113370.4911 | 37.783193290288 | -122.42650297364901 | (37.783193290288, -122.426502973649) | ||
| 6570 | 6570 | 5899 | DPW Maintained 3 | Tristania conferta :: 79 | 1180 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6004803.0167 | 2113001.5597 | 37.7821710372677 | -122.42704323134701 | (37.7821710372677, -122.427043231347) | ||
| 6587 | 6587 | 5904 | DPW Maintained 3 | Tristania conferta :: 79 | 1256 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004447.9733 | 2112952.6596 | 37.782016686789 | -122.428268035802 | (37.782016686789, -122.428268035802) | ||
| 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) | |||
| 6593 | 6593 | 7059 | DPW Maintained 3 | Tristania conferta :: 79 | 1516 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6000148.3323 | 2109926.5898 | 37.773463647588 | -122.44292540854099 | (37.773463647588, -122.442925408541) | ||
| 6605 | 6605 | 9632 | DPW Maintained 3 | Tristania conferta :: 79 | 1455 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002597.6566 | 2111945.8131 | 37.7791472697919 | -122.434597262323 | (37.7791472697919, -122.434597262323) | |||
| 6633 | 6633 | 17842 | DPW Maintained 3 | Tristania conferta :: 79 | 2031 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004091.8528 | 2115280.5278 | 37.7883882726819 | -122.42966612859699 | (37.7883882726819, -122.429666128597) | |||
| 6685 | 6685 | 6188 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005406.4851 | 2113431.574 | 37.783385856152 | -122.42498610479299 | (37.783385856152, -122.424986104793) | |||
| 6702 | 6702 | 10686 | DPW Maintained 3 | Tristania conferta :: 79 | 1179 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002229.5074 | 2110511.8739 | 37.775189125797205 | -122.435768217131 | (37.7751891257972, -122.435768217131) | |||
| 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) | ||
| 6733 | 6733 | 12339 | DPW Maintained 3 | Tristania conferta :: 79 | 1199 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 12 | 3X3 | 6004687.2548 | 2112907.9517 | 37.7819074662565 | -122.42743704493999 | (37.7819074662565, -122.42743704494) | ||
| 6776 | 6776 | 14454 | DPW Maintained 3 | Tristania conferta :: 79 | 109 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1994 12:00:00 AM | 60 | 3X3 | 5998851.581 | 2112620.0339 | 37.7807851345871 | -122.447604964541 | (37.7807851345871, -122.447604964541) | ||
| 6823 | 6823 | 28076 | DPW Maintained 3 | Tristania conferta :: 79 | 915 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/2003 12:00:00 AM | 25 | 3X3 | 6008674.8876 | 2120493.8068 | 37.8029610933815 | -122.41417849255801 | (37.8029610933815, -122.414178492558) | ||
| 6841 | 6841 | 14479 | DPW Maintained 3 | Tristania conferta :: 79 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5998992.7029 | 2112117.3083 | 37.7794128442998 | -122.44708056796001 | (37.7794128442998, -122.44708056796) | |||
| 6856 | 6856 | 26449 | DPW Maintained 3 | Tristania conferta :: 79 | 1096 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2004 12:00:00 AM | 3 | 3X3 | 6005161.0819 | 2113052.9102 | 37.7823322739768 | -122.425808142175 | (37.7823322739768, -122.425808142175) | ||
| 6937 | 6937 | 13290 | DPW Maintained 3 | Tristania conferta :: 79 | 2665 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1997 12:00:00 AM | 6 | 3X3 | 5999641.675 | 2119108.3375 | 37.7986454362464 | -122.445338306635 | (37.7986454362464, -122.445338306635) | ||
| 6946 | 6946 | 18103 | DPW Maintained 3 | Tristania conferta :: 79 | 3042 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999290.1369 | 2114664.7113 | 37.7864243409392 | -122.446234917327 | (37.7864243409392, -122.446234917327) | |||
| 6977 | 6977 | 17681 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1990 12:00:00 AM | 12 | 4X4 | 6002407.8372 | 2112172.5118 | 37.779758949887096 | -122.43527014428601 | (37.7797589498871, -122.435270144286) | ||
| 6979 | 6979 | 6191 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005268.6997 | 2113412.8277 | 37.7833265994852 | -122.42546145392201 | (37.7833265994852, -122.425461453922) | |||
| 6992 | 6992 | 7000 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002725.4323 | 2110284.3962 | 37.77459268596171 | -122.434036438862 | (37.7745926859617, -122.434036438862) | ||
| 7068 | 7068 | 6193 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005219.9593 | 2113402.5172 | 37.783295535433204 | -122.425629342465 | (37.7832955354332, -122.425629342465) | |||
| 7117 | 7117 | 7106 | DPW Maintained 3 | Tristania conferta :: 79 | 2136 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997200.5381 | 2109511.6187 | 37.7721557413798 | -122.453092239143 | (37.7721557413798, -122.453092239143) | |||
| 7125 | 7125 | 18238 | DPW Maintained 3 | Tristania conferta :: 79 | 1790X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2000 12:00:00 AM | 3 | 4X4 | 6003705.6129 | 2114238.8254 | 37.7855061428919 | -122.430928082284 | (37.7855061428919, -122.430928082284) | ||
| 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) | |||
| 7203 | 7203 | 8199 | DPW Maintained 3 | Tristania conferta :: 79 | 1310X Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2011 12:00:00 AM | 3 | 3x3 | 6001414.7162 | 2111141.806 | 37.7768724447291 | -122.438631903562 | (37.7768724447291, -122.438631903562) | ||
| 7255 | 7255 | 9753 | DPW Maintained 3 | Tristania conferta :: 79 | 725 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/1990 12:00:00 AM | 16 | 4x4 | 6005752.1131 | 2112212.6104 | 37.780058398475106 | -122.423703668106 | (37.7800583984751, -122.423703668106) |
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");