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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17941 | 17941 | 495 | Permitted Site 1 | Tristania conferta :: 79 | 2749X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2010 12:00:00 AM | 3 | 3X3 | 6010480.319 | 2102220.7863 | 37.752888894824295 | -122.406642256485 | (37.7528888948243, -122.406642256485) | ||
| 17851 | 17851 | 526 | Permitted Site 1 | Tristania conferta :: 79 | 2830 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009862.6031 | 2102227.8681 | 37.7528737602498 | -122.40877894251899 | (37.7528737602498, -122.408778942519) | |||
| 6645 | 6645 | 1662 | Permitted Site 1 | Tristania conferta :: 79 | 1400X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000535.6523 | 2109979.223 | 37.7736302396696 | -122.441589394177 | (37.7736302396696, -122.441589394177) | ||
| 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) | ||
| 7083 | 7083 | 1667 | Permitted Site 1 | Tristania conferta :: 79 | 1400X Fell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000310.2061 | 2109949.902 | 37.773536884549706 | -122.44236713923901 | (37.7735368845497, -122.442367139239) | ||
| 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) | |||
| 19234 | 19234 | 2174 | DPW Maintained 3 | Tristania conferta :: 79 | 1012X Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6001267.8248 | 2109041.6287 | 37.7710975275243 | -122.43898949646601 | (37.7710975275243, -122.438989496466) | |||
| 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) | ||
| 9443 | 9443 | 4536 | Permitted Site 1 | Tristania conferta :: 79 | 65 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1991 12:00:00 AM | 12 | 3X3 | 6004897.6525 | 2113656.6857 | 37.783975201758 | -122.426762502798 | (37.783975201758, -122.426762502798) | ||
| 8081 | 8081 | 4614 | Permitted Site 1 | Tristania conferta :: 79 | 347 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1991 12:00:00 AM | 30 | 3x3 | 6010525.6854 | 2118803.2675 | 37.7984230708943 | -122.407654474652 | (37.7984230708943, -122.407654474652) | ||
| 21622 | 21622 | 5142 | DPW Maintained 3 | Tristania conferta :: 79 | 205 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2X3 | 6001837.0393 | 2108819.6023 | 37.7705202684803 | -122.437004669282 | (37.7705202684803, -122.437004669282) | |||
| 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) | ||
| 8487 | 8487 | 5215 | DPW Maintained 3 | Tristania conferta :: 79 | 846 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1990 12:00:00 AM | 18 | 3X3 | 6001547.7869 | 2111374.9525 | 37.7775201753497 | -122.43818827840599 | (37.7775201753497, -122.438188278406) | ||
| 8481 | 8481 | 5881 | Permitted Site 1 | Tristania conferta :: 79 | 1106 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005104.874 | 2113043.8892 | 37.7823043280422 | -122.426001954403 | (37.7823043280422, -122.426001954403) | ||
| 8929 | 8929 | 5882 | DPW Maintained 3 | Tristania conferta :: 79 | 1112 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005074.3413 | 2113041.8074 | 37.782296886294496 | -122.42610743581699 | (37.7822968862945, -122.426107435817) | ||
| 7268 | 7268 | 5883 | Permitted Site 1 | Tristania conferta :: 79 | 1118 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005049.3601 | 2113036.9499 | 37.7822821368488 | -122.426193513801 | (37.7822821368488, -122.426193513801) | ||
| 7361 | 7361 | 5891 | Permitted Site 1 | Tristania conferta :: 79 | 1124 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 12 | 3X3 | 6005026.4605 | 2113033.4803 | 37.7822713158313 | -122.426272489182 | (37.7822713158313, -122.426272489182) | ||
| 8947 | 8947 | 5892 | DPW Maintained 3 | Tristania conferta :: 79 | 1130 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6004999.3975 | 2113030.0107 | 37.7822602594178 | -122.426365868057 | (37.7822602594178, -122.426365868057) | ||
| 8445 | 8445 | 5893 | DPW Maintained 3 | Tristania conferta :: 79 | 1136 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1998 12:00:00 AM | 3 | 3X3 | 6004974.4162 | 2113025.1532 | 37.7822455097776 | -122.42645194629401 | (37.7822455097776, -122.426451946294) | ||
| 6001 | 6001 | 5894 | Permitted Site 1 | Tristania conferta :: 79 | 1142 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 3 | 3X3 | 6004948.741 | 2113023.7653 | 37.7822402475105 | -122.42654067221599 | (37.7822402475105, -122.426540672216) | ||
| 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) | ||
| 7450 | 7450 | 5896 | DPW Maintained 3 | Tristania conferta :: 79 | 1160 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 3 | 3x3 | 6004888.3695 | 2113012.6625 | 37.7822063488626 | -122.426748739826 | (37.7822063488626, -122.426748739826) | ||
| 5631 | 5631 | 5897 | Permitted Site 1 | Tristania conferta :: 79 | 1168 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6004857.8368 | 2113009.1929 | 37.782195095891396 | -122.42685412216001 | (37.7821950958914, -122.42685412216) | ||
| 7208 | 7208 | 5898 | Permitted Site 1 | Tristania conferta :: 79 | 1174 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 3 | 3X3 | 6004835.6312 | 2113008.499 | 37.782191935057504 | -122.42693089417101 | (37.7821919350575, -122.426930894171) | ||
| 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) | ||
| 8724 | 8724 | 5903 | DPW Maintained 3 | Tristania conferta :: 79 | 1240 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2008 12:00:00 AM | 6 | 3X3 | 6004495.1999 | 2112958.3268 | 37.7820349196083 | -122.42810505731 | (37.7820349196083, -122.42810505731) | ||
| 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) | ||
| 8781 | 8781 | 5985 | Permitted Site 1 | Tristania conferta :: 79 | 1632 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | 12 | 4X4 | 6002675.1551 | 2112702.5242 | 37.7812294076413 | -122.434383280063 | (37.7812294076413, -122.434383280063) | ||
| 7540 | 7540 | 6040 | DPW Maintained 3 | Tristania conferta :: 79 | 1819 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/18/1997 12:00:00 AM | 12 | 4X4 | 6001713.6698 | 2112519.6828 | 37.7806727486492 | -122.43769643941002 | (37.7806727486492, -122.43769643941) | ||
| 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) | ||
| 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) | |||
| 7516 | 7516 | 6182 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005530.6795 | 2113448.9143 | 37.7834404828465 | -122.424557674459 | (37.7834404828465, -122.424557674459) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 8442 | 8442 | 6187 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005423.3129 | 2113433.3911 | 37.783391795987 | -122.424928016493 | (37.783391795987, -122.424928016493) | |||
| 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) | |||
| 8695 | 8695 | 6189 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005309.0043 | 2113417.5143 | 37.7833417448711 | -122.425322349467 | (37.7833417448711, -122.425322349467) | |||
| 7430 | 7430 | 6190 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005292.1326 | 2113413.765 | 37.783330497018 | -122.425380452026 | (37.783330497018, -122.425380452026) | |||
| 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) | |||
| 7364 | 7364 | 6192 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005245.2668 | 2113409.0784 | 37.7833149808402 | -122.425542255616 | (37.7833149808402, -122.425542255616) | |||
| 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) | |||
| 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) | |||
| 8926 | 8926 | 6195 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005185.2786 | 2113401.5799 | 37.7832910021365 | -122.425749257253 | (37.7832910021365, -122.425749257253) | |||
| 8764 | 8764 | 6196 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005120.1943 | 2113340.5958 | 37.7831198768419 | -122.42597008062401 | (37.7831198768419, -122.425970080624) | |||
| 7599 | 7599 | 6198 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005211.2623 | 2113352.5609 | 37.7831578763581 | -122.425655873927 | (37.7831578763581, -122.425655873927) | |||
| 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) | |||
| 8818 | 8818 | 6201 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005283.7179 | 2113361.2024 | 37.783185697693604 | -122.42540582178002 | (37.7831856976936, -122.42540582178) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 8453 | 8453 | 6306 | DPW Maintained 3 | Tristania conferta :: 79 | 1804 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6002160.6694 | 2112978.761 | 37.7819586673159 | -122.436182917866 | (37.7819586673159, -122.436182917866) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 8060 | 8060 | 6320 | DPW Maintained 3 | Tristania conferta :: 79 | 1862 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001964.3848 | 2112948.6415 | 37.78186481295621 | -122.436859814321 | (37.7818648129562, -122.436859814321) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 18106 | 18106 | 6900 | Permitted Site 1 | Tristania conferta :: 79 | 333 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6005641.7144 | 2110639.9688 | 37.77573407541011 | -122.42397372326799 | (37.7757340754101, -122.423973723268) | |||
| 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) | ||
| 18909 | 18909 | 6905 | Permitted Site 1 | Tristania conferta :: 79 | 333 Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6005791.8208 | 2110660.0754 | 37.775797756638205 | -122.42345589675699 | (37.7757977566382, -122.423455896757) | |||
| 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) | ||
| 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) | ||
| 17250 | 17250 | 6951 | DPW Maintained 3 | Tristania conferta :: 79 | 603 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/1990 12:00:00 AM | 6 | 3x3 | 6004469.2574 | 2110472.8506 | 37.775208946886295 | -122.42801763482099 | (37.7752089468863, -122.428017634821) | ||
| 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) | ||
| 17659 | 17659 | 6961 | Permitted Site 1 | Tristania conferta :: 79 | 675 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6004210.2657 | 2110437.8608 | 37.775098217514206 | -122.42891105054301 | (37.7750982175142, -122.428911050543) | ||
| 17826 | 17826 | 6965 | Permitted Site 1 | Tristania conferta :: 79 | 701 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2000 12:00:00 AM | 6 | 3x3 | 6004021.294 | 2110411.403 | 37.775014872978396 | -122.42956285796998 | (37.7750148729784, -122.42956285797) | ||
| 19483 | 19483 | 6969 | DPW Maintained 3 | Tristania conferta :: 79 | 735 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003809.8332 | 2110380.499 | 37.774918042861295 | -122.43029214121701 | (37.7749180428613, -122.430292141217) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 20810 | 20810 | 6984 | Permitted Site 1 | Tristania conferta :: 79 | 815 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2008 12:00:00 AM | 6 | 3X3 | 6003507.9341 | 2110337.394 | 37.7747825823251 | -122.43133339614799 | (37.7747825823251, -122.431333396148) | ||
| 17129 | 17129 | 6985 | DPW Maintained 3 | Tristania conferta :: 79 | 819 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6003479.628 | 2110333.4443 | 37.7747701331995 | -122.43143103071199 | (37.7747701331995, -122.431431030712) | ||
| 20595 | 20595 | 6987 | DPW Maintained 3 | Tristania conferta :: 79 | 829X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/24/1995 12:00:00 AM | 12 | 3X3 | 6003407.8751 | 2110323.57 | 37.77473895391171 | -122.43167853345601 | (37.7747389539117, -122.431678533456) | ||
| 23349 | 23349 | 6988 | DPW Maintained 3 | Tristania conferta :: 79 | 843 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/1990 12:00:00 AM | 11 | 3X3 | 6003376.2775 | 2110319.6203 | 37.7747263179186 | -122.431787553866 | (37.7747263179186, -122.431787553866) | ||
| 18951 | 18951 | 6992 | DPW Maintained 3 | Tristania conferta :: 79 | 859 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003319.0069 | 2110312.3792 | 37.7747031890375 | -122.431985147215 | (37.7747031890375, -122.431985147215) | |||
| 21357 | 21357 | 6993 | Permitted Site 1 | Tristania conferta :: 79 | 861 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003293.0047 | 2110308.1004 | 37.7746899663633 | -122.43207478841002 | (37.7746899663633, -122.43207478841) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 18778 | 18778 | 7005 | DPW Maintained 3 | Tristania conferta :: 79 | 1001 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1999 12:00:00 AM | 3 | 3X3 | 6002577.0261 | 2110209.591 | 37.7743788659974 | -122.43454445471201 | (37.7743788659974, -122.434544454712) | ||
| 9005 | 9005 | 7012 | Permitted Site 1 | Tristania conferta :: 79 | 1030 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002476.0968 | 2110247.1221 | 37.774476187107 | -122.43489627219601 | (37.774476187107, -122.434896272196) | ||
| 8597 | 8597 | 7014 | Permitted Site 1 | Tristania conferta :: 79 | 1050 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2008 12:00:00 AM | 3 | 3X3 | 6002429.2937 | 2110241.5336 | 37.774458185014296 | -122.43505777310101 | (37.7744581850143, -122.435057773101) | ||
| 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) | ||
| 19534 | 19534 | 7027 | Permitted Site 1 | Tristania conferta :: 79 | 1147 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6001937.5196 | 2110120.432 | 37.774097734077394 | -122.43675024004101 | (37.7740977340774, -122.436750240041) | ||
| 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) | ||
| 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) | ||
| 5503 | 5503 | 7044 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2010 12:00:00 AM | 12 | 3X3 | 6001092.4662 | 2110057.6748 | 37.7738773565747 | -122.439668919992 | (37.7738773565747, -122.439668919992) | ||
| 5826 | 5826 | 7045 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2010 12:00:00 AM | 12 | 3X3 | 6001075.5825 | 2110054.6953 | 37.7738682146278 | -122.43972710968599 | (37.7738682146278, -122.439727109686) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 6988 | 6988 | 7064 | Permitted Site 1 | Tristania conferta :: 79 | 1564 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999951.2096 | 2109897.9532 | 37.7733737782492 | -122.44360522471099 | (37.7733737782492, -122.443605224711) | |||
| 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) | ||
| 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) |
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");