Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82272 | 82272 | 27 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 740 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2008 12:00:00 AM | 3 | 3X3 | 6003877.1873918 | 2107766.1695161 | 37.767743547109106 | -122.429872630659 | (37.7677435471091, -122.429872630659) | ||
| 93563 | 93563 | 1338 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 141 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5999313.5622646 | 2099540.0406869 | 37.744897128473895 | -122.44506614647499 | (37.7448971284739, -122.445066146475) | |||
| 6513 | 6513 | 2467 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1848 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1989 12:00:00 AM | 12 | 4X4 | 6003976.525 | 2114838.4 | 37.7871677703016 | -122.430033592456 | (37.7871677703016, -122.430033592456) | ||
| 8099 | 8099 | 2468 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1860 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 3 | 4X4 | 6003974.6503 | 2114875.8941 | 37.787270613481205 | -122.430042754186 | (37.7872706134812, -122.430042754186) | ||
| 6896 | 6896 | 2469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 7 | 5x5 | 6003922.3005 | 2114887.2882 | 37.7872989338532 | -122.43022468652201 | (37.7872989338532, -122.430224686522) | ||
| 5336 | 5336 | 2470 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/1998 12:00:00 AM | 7 | 5x5 | 6003922.7717 | 2114866.5529 | 37.787242026635 | -122.43022157640499 | (37.787242026635, -122.430221576405) | ||
| 22376 | 22376 | 2581 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1671 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1990 12:00:00 AM | 12 | 4X4 | 6005533.42791 | 2115131.9638 | 37.7880618747142 | -122.42466793237699 | (37.7880618747142, -122.424667932377) | ||
| 96619 | 96619 | 2639 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6004357.24991 | 2114951.14345 | 37.787498890276396 | -122.42872440700899 | (37.7874988902764, -122.428724407009) | |||
| 98972 | 98972 | 2640 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1909 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 6 | 4X4 | 6004357.24991 | 2114951.14345 | 37.787498890276396 | -122.42872440700899 | (37.7874988902764, -122.428724407009) | ||
| 7618 | 7618 | 2643 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1911 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6004268.353999999 | 2114955.8815 | 37.7875068682146 | -122.429032306872 | (37.7875068682146, -122.429032306872) | |||
| 7538 | 7538 | 2644 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1911 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6004293.9749 | 2114957.7562 | 37.787513465908496 | -122.42894379742201 | (37.7875134659085, -122.428943797422) | |||
| 6599 | 6599 | 2653 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1971 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1992 12:00:00 AM | 3 | 4X4 | 6004104.0049 | 2114930.2605 | 37.78742721503939 | -122.42959909363199 | (37.7874272150394, -122.429599093632) | ||
| 2113 | 2113 | 2684 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2100 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6003399.8502 | 2114890.5748 | 37.787278352566105 | -122.432032487909 | (37.7872783525661, -122.432032487909) | |||
| 18253 | 18253 | 4301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4374 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001502.87912 | 2100307.76951 | 37.7471298441855 | -122.43755087718 | (37.7471298441855, -122.43755087718) | |||
| 20053 | 20053 | 5099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2621 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002328.495730001 | 2096416.0838900001 | 37.736491088285796 | -122.434417765086 | (37.7364910882858, -122.434417765086) | |||
| 17693 | 17693 | 5140 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2922 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2011 12:00:00 AM | 3 | 3x3 | 6002319.208819999 | 2095185.9682200002 | 37.7331129460068 | -122.43436195314399 | (37.7331129460068, -122.434361953144) | ||
| 122521 | 122521 | 10018 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 205 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/1993 12:00:00 AM | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.767291517220706 | -122.42420766586201 | (37.7672915172207, -122.424207665862) | ||
| 127019 | 127019 | 10019 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 205 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.767291517220706 | -122.42420766586201 | (37.7672915172207, -122.424207665862) | |||
| 143257 | 143257 | 10045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 375 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2007 12:00:00 AM | 6 | 2X2 | 6005552.9439989 | 2106809.2959801997 | 37.7652109557568 | -122.424008332395 | (37.7652109557568, -122.424008332395) | ||
| 21684 | 21684 | 10064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 512 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1991 12:00:00 AM | 30 | 3X3 | 6005527.25593 | 2105966.68025 | 37.762895882361 | -122.42403725491 | (37.762895882361, -122.42403725491) | ||
| 21103 | 21103 | 10099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | 30 | 2x2 | 6005606.10854 | 2104557.89173 | 37.7590321322447 | -122.423664360924 | (37.7590321322447, -122.423664360924) | ||
| 17729 | 17729 | 10111 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 817 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005691.67507 | 2104204.22323 | 37.758065870971706 | -122.423343289458 | (37.7580658709717, -122.423343289458) | |||
| 19048 | 19048 | 10142 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 915 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005723.61297 | 2103645.6305400003 | 37.7565339082426 | -122.42319312877599 | (37.7565339082426, -122.423193128776) | |||
| 18974 | 18974 | 10193 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1170 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x2 | 6005736.259869999 | 2102154.58599 | 37.752440559408896 | -122.42304341594699 | (37.7524405594089, -122.423043415947) | |||
| 21320 | 21320 | 10210 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1306 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1992 12:00:00 AM | 18 | 2X2 | 6005782.73241 | 2101317.8159 | 37.7501456037461 | -122.42282324301901 | (37.7501456037461, -122.422823243019) | ||
| 2078 | 2078 | 12419 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1691 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/1997 12:00:00 AM | 3 | 4X4 | 6004453.7544 | 2114557.5752 | 37.786423711867705 | -122.42836245915599 | (37.7864237118677, -122.428362459156) | ||
| 111468 | 111468 | 12764 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1806 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 6 | 2X2 | 5989816.9164 | 2114746.4277 | 37.7861031429404 | -122.47901548994699 | (37.7861031429404, -122.479015489947) | ||
| 1181 | 1181 | 12891 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2005 12:00:00 AM | 3 | 3X3 | 6006369.20019 | 2113010.28335 | 37.7822834283719 | -122.421625551994 | (37.7822834283719, -122.421625551994) | ||
| 5916 | 5916 | 12892 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006398.20739 | 2113019.98592 | 37.7823117048675 | -122.421525889114 | (37.7823117048675, -122.421525889114) | ||
| 6904 | 6904 | 12893 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006421.0816 | 2113018.78056 | 37.7823096849762 | -122.421446668727 | (37.7823096849762, -122.421446668727) | ||
| 830 | 830 | 12894 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006443.29256 | 2113021.2667 | 37.7823177635948 | -122.421370005133 | (37.7823177635948, -122.421370005133) | ||
| 91375 | 91375 | 13073 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 645X Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 81488 | 81488 | 13074 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 645X Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | |||
| 21476 | 21476 | 16622 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 133 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002888.88219 | 2107504.60291 | 37.766969331884 | -122.433272362446 | (37.766969331884, -122.433272362446) | |||
| 22170 | 22170 | 17373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5999390.9816 | 2109231.8772 | 37.771512935512796 | -122.44549522045601 | (37.7715129355128, -122.445495220456) | |||
| 14318 | 14318 | 17462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2022 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6012632.03621 | 2096963.3752099997 | 37.7385733165067 | -122.398832221241 | (37.7385733165067, -122.398832221241) | |||
| 17951 | 17951 | 22845 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1997 12:00:00 AM | 16 | 1X1 | 5999785.45831 | 2099029.41993 | 37.7435220087408 | -122.44339775201401 | (37.7435220087408, -122.443397752014) | ||
| 139335 | 139335 | 22846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 1X1 | 5999247.2741693 | 2099079.9876616 | 37.7436301498813 | -122.44526228700501 | (37.7436301498813, -122.445262287005) | |||
| 19854 | 19854 | 22847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 1X1 | 5999792.57079 | 2099032.92975 | 37.7435320514679 | -122.44337341096 | (37.7435320514679, -122.44337341096) | |||
| 18701 | 18701 | 22848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 1X1 | 5999801.2823 | 2099039.75864 | 37.743551298748 | -122.44334377921601 | (37.743551298748, -122.443343779216) | |||
| 123650 | 123650 | 24288 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 340 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6001280.10777 | 2086581.3596299998 | 37.709427595658795 | -122.43733847618401 | (37.7094275956588, -122.437338476184) | |||
| 21899 | 21899 | 24817 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2015 12:00:00 AM | 4 | 3x3 | 6007985.05958 | 2094993.5090299998 | 37.7329044714678 | -122.41475991886101 | (37.7329044714678, -122.414759918861) | ||
| 18880 | 18880 | 25589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6009160.7320011 | 2097455.9675674997 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | |||
| 16805 | 16805 | 25996 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6014137.90687 | 2096120.20835 | 37.7363419456235 | -122.39356660700899 | (37.7363419456235, -122.393566607009) | ||
| 13588 | 13588 | 26008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1625 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014811.10476 | 2095618.3620200001 | 37.7350013613099 | -122.391203993568 | (37.7350013613099, -122.391203993568) | |||
| 12256 | 12256 | 26978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 532 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004762.815690001 | 2093485.8585299999 | 37.7285832245248 | -122.42579277741001 | (37.7285832245248, -122.42579277741) | |||
| 11578 | 11578 | 27091 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 717 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006120.2550800005 | 2093595.10299 | 37.7289598021321 | -122.42110777902398 | (37.7289598021321, -122.421107779024) | |||
| 11228 | 11228 | 27092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 717 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006103.20931 | 2093594.9436599999 | 37.728958403708894 | -122.42116669629699 | (37.7289584037089, -122.421166696297) | |||
| 11708 | 11708 | 27702 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1140 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2000 12:00:00 AM | 6 | 2X3 | 6008343.29575 | 2093842.41085 | 37.729763925549506 | -122.41344002075701 | (37.7297639255495, -122.413440020757) | ||
| 270 | 270 | 28098 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 639 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 3 | 3X3 | 6001577.9698 | 2110674.4978 | 37.7755986195101 | -122.438033679217 | (37.7755986195101, -122.438033679217) | ||
| 19941 | 19941 | 28386 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2749 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 9 | 3X3 | 6009842.67473 | 2101317.3868299997 | 37.750372664569504 | -122.408783629764 | (37.7503726645695, -122.408783629764) | ||
| 18134 | 18134 | 28387 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1271 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2003 12:00:00 AM | 3 | 3X3 | 6004513.78886 | 2101505.14883 | 37.7505882968197 | -122.427224669004 | (37.7505882968197, -122.427224669004) | ||
| 113023 | 113023 | 28841 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 366 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2005 12:00:00 AM | 12 | 3X3 | 5995586.0711199995 | 2114021.88834 | 37.784447087073396 | -122.45900340593398 | (37.7844470870734, -122.459003405934) | ||
| 105963 | 105963 | 28850 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 88514 | 88514 | 28851 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 123223 | 123223 | 28852 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 141442 | 141442 | 28853 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 139447 | 139447 | 28854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 90239 | 90239 | 28855 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 999X Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003293.83169 | 2111352.42992 | 37.7775574834057 | -122.432146522449 | (37.7775574834057, -122.432146522449) | |||
| 142523 | 142523 | 30301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 48196 | 5990498.42551573 | 2114680.4203788997 | 37.7859614580277 | -122.47665285108299 | (37.7859614580277, -122.476652851083) | |||
| 184905 | 184905 | 30305 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2004 12:00:00 AM | 9 | Permit Number 7 | 5996194.44946 | 2113622.43964 | 37.7833852609546 | -122.456869738263 | (37.7833852609546, -122.456869738263) | ||
| 170334 | 170334 | 30308 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2004 12:00:00 AM | 12 | Permit Number 7 | 5996193.65871 | 2113633.69704 | 37.7834161253698 | -122.456873288412 | (37.7834161253698, -122.456873288412) | ||
| 42301 | 42301 | 30496 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2460 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1985 12:00:00 AM | 5 | Permit Number 22043 | 6001850.15003 | 2117377.4559 | 37.7940187069382 | -122.43757227473999 | (37.7940187069382, -122.43757227474) | ||
| 92514 | 92514 | 30573 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 164 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | Permit Number 34550 | 6004481.83420946 | 2108792.73976924 | 37.7705964833806 | -122.42785438691001 | (37.7705964833806, -122.42785438691) | ||
| 162119 | 162119 | 30574 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 6 | Permit Number 34551 | 6004467.68034 | 2108789.06417 | 37.7705855903724 | -122.427903083363 | (37.7705855903724, -122.427903083363) | |
| 52581 | 52581 | 30766 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1595 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34647 | 6014606.5276 | 2093671.0453 | 37.729643069645704 | -122.391775180038 | (37.7296430696457, -122.391775180038) | |
| 25423 | 25423 | 30768 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.727837721051294 | -122.391915390574 | (37.7278377210513, -122.391915390574) | |
| 73597 | 73597 | 30774 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 548 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 4 | 4.5x12 | Permit Number 34652 | 6014028.90307 | 2112230.33243 | 37.7805707972354 | -122.39507154151501 | (37.7805707972354, -122.395071541515) |
| 114586 | 114586 | 30860 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 30 Reddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34700 | 6013611.1313561 | 2094054.73303175 | 37.7306412906978 | -122.395243261567 | (37.7306412906978, -122.395243261567) | |||
| 85298 | 85298 | 30861 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 30 Reddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | Permit Number 34700 | 6013611.1313561 | 2094054.73303175 | 37.7306412906978 | -122.395243261567 | (37.7306412906978, -122.395243261567) | |||
| 6855 | 6855 | 30870 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1922 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | 22 | 3x3 | Permit Number 770521 | 6001989.3306 | 2115172.0478 | 37.787971137606895 | -122.436932736614 | (37.7879711376069, -122.436932736614) | |
| 169350 | 169350 | 30871 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1922 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | 9 | 3x3 | Permit Number 34705 | 6001987.0249 | 2115189.9174 | 37.788020071895794 | -122.436941993701 | (37.7880200718958, -122.436941993701) | |
| 119263 | 119263 | 31008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 127132 | 127132 | 31009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 97225 | 97225 | 31025 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34790 | 6006888.66873478 | 2096851.20330239 | 37.7379436268141 | -122.41868212584299 | (37.7379436268141, -122.418682125843) | |||
| 83938 | 83938 | 31026 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34790 | 6006888.66873478 | 2096851.20330239 | 37.7379436268141 | -122.41868212584299 | (37.7379436268141, -122.418682125843) | |||
| 129018 | 129018 | 31027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25 Newman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34790 | 6006888.66873478 | 2096851.20330239 | 37.7379436268141 | -122.41868212584299 | (37.7379436268141, -122.418682125843) | |||
| 100665 | 100665 | 31028 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 45 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34791 | 6006941.23220098 | 2096843.72202515 | 37.737926044164794 | -122.418499857351 | (37.7379260441648, -122.418499857351) | |||
| 113429 | 113429 | 31029 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 45 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34791 | 6006941.23220098 | 2096843.72202515 | 37.737926044164794 | -122.418499857351 | (37.7379260441648, -122.418499857351) | |||
| 126110 | 126110 | 31030 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 52 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34792 | 6006952.41167603 | 2096789.60681619 | 37.737778085142295 | -122.418457368251 | (37.7377780851423, -122.418457368251) | |||
| 141227 | 141227 | 31031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 59 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34793 | 6006978.02662143 | 2096838.48513192 | 37.7379137361446 | -122.418372269478 | (37.7379137361446, -122.418372269478) | |||
| 138357 | 138357 | 31032 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 88 Newman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34794 | 6007048.99704691 | 2096775.85996902 | 37.7377457761671 | -122.418122450801 | (37.7377457761671, -122.418122450801) | |||
| 64613 | 64613 | 31046 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 146 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34803 | 6000734.07095 | 2088520.9414400002 | 37.714722198640004 | -122.439364601993 | (37.71472219864, -122.439364601993) | |
| 144651 | 144651 | 31047 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 146 Rolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34803 | 6000718.58674958 | 2088518.12227815 | 37.7147135766514 | -122.43941791967501 | (37.7147135766514, -122.439417919675) | |||
| 178309 | 178309 | 31056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Toyon Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34808 | 6003244.645880001 | 2086572.31488 | 37.7095142480656 | -122.430548065039 | (37.7095142480656, -122.430548065039) | |
| 116648 | 116648 | 31063 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1446 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34813 | 5991504.54040303 | 2105570.76324803 | 37.7610071175252 | -122.47250762303001 | (37.7610071175252, -122.47250762303) | |||
| 81400 | 81400 | 31064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1446 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34813 | 5991504.54040303 | 2105570.76324803 | 37.7610071175252 | -122.47250762303001 | (37.7610071175252, -122.47250762303) | |||
| 113164 | 113164 | 31065 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1446 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34813 | 5991504.54040303 | 2105570.76324803 | 37.7610071175252 | -122.47250762303001 | (37.7610071175252, -122.47250762303) | |||
| 143600 | 143600 | 31066 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1446 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34813 | 5991504.54040303 | 2105570.76324803 | 37.7610071175252 | -122.47250762303001 | (37.7610071175252, -122.47250762303) | |||
| 92264 | 92264 | 31067 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1450 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34814 | 6007710.23060996 | 2107394.98126032 | 37.7669406704491 | -122.41658826699499 | (37.7669406704491, -122.416588266995) | |||
| 96508 | 96508 | 31080 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34818 | 6005439.37562614 | 2108486.56772635 | 37.769809930745 | -122.42452045534901 | (37.769809930745, -122.424520455349) | ||
| 79541 | 79541 | 31081 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34818 | 6005439.37562614 | 2108486.56772635 | 37.769809930745 | -122.42452045534901 | (37.769809930745, -122.424520455349) | ||
| 123857 | 123857 | 31090 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 109007 | 109007 | 31091 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 78060 | 78060 | 31092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 187669 | 187669 | 31093 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34826 | 6007741.23443 | 2107311.13584 | 37.7667121941381 | -122.416475089665 | (37.7667121941381, -122.416475089665) | |
| 17368 | 17368 | 31107 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 237 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | 12 | 2x9 | Permit Number 34836 | 5998741.10559 | 2093696.6729599999 | 37.7288199422639 | -122.44662524706101 | (37.7288199422639, -122.446625247061) | |
| 156886 | 156886 | 31200 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 580 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34891 | 6002645.8184400005 | 2102709.5548400003 | 37.7537894947999 | -122.433770326052 | (37.7537894947999, -122.433770326052) | ||
| 26128 | 26128 | 31225 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2491 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34912 | 5987341.6863 | 2098360.1236 | 37.740966813188 | -122.486375538404 | (37.740966813188, -122.486375538404) | |
| 31859 | 31859 | 31232 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2551 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34918 | 5991386.50478 | 2098046.67038 | 37.7403410850744 | -122.472367334291 | (37.7403410850744, -122.472367334291) |
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");