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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3094 | 3094 | 253300 | Undocumented 2 | Tristania conferta :: 79 | 844 33rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5985769.0 | 2110141.0 | 37.773222058846 | -122.492680686455 | (37.773222058846, -122.492680686455) | ||||
| 8882 | 8882 | 99306 | Permitted Site 1 | Tristania conferta :: 79 | 1345 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2012 12:00:00 AM | 3x3 | Permit Number 768843 | 6003605.0174 | 2112439.8748 | 37.780560974986 | -122.43114766452 | (37.780560974986, -122.43114766452) | ||
| 85477 | 85477 | 49069 | Permitted Site 1 | Tristania conferta :: 79 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 776020 | 5995836.31315767 | 2092013.47244835 | 37.724031921729704 | -122.45654557668001 | (37.7240319217297, -122.45654557668) | ||
| 98092 | 98092 | 115300 | Permitted Site 1 | Tristania conferta :: 79 | 177 Lomita Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | |||
| 99519 | 99519 | 115299 | Permitted Site 1 | Tristania conferta :: 79 | 177 Lomita Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | |||
| 108387 | 108387 | 114594 | Permitted Site 1 | Tristania conferta :: 79 | 2584 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.78500729421621 | -122.442863075731 | (37.7850072942162, -122.442863075731) | |||
| 114827 | 114827 | 114595 | Permitted Site 1 | Tristania conferta :: 79 | 2584 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 775079 | 6000253.6 | 2114128.6 | 37.78500729421621 | -122.442863075731 | (37.7850072942162, -122.442863075731) | |||
| 70474 | 70474 | 103963 | Permitted Site 1 | Tristania conferta :: 79 | 2534 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2015 12:00:00 AM | 0 | Permit Number 773267 | 6000467.0 | 2114127.0 | 37.7850150648369 | -122.442124666784 | (37.7850150648369, -122.442124666784) | ||
| 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) | |||
| 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) | |||
| 21334 | 21334 | 10471 | DPW Maintained 3 | Tristania conferta :: 79 | 1628 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2011 12:00:00 AM | 1 | 3x3 | 5998338.8079 | 2108630.4441 | 37.769801430915706 | -122.44909139548 | (37.7698014309157, -122.44909139548) | ||
| 22844 | 22844 | 141842 | Undocumented 2 | Tristania conferta :: 79 | 1268 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004263.4746 | 2112800.275 | 37.7815878353953 | -122.42889544965401 | (37.7815878353953, -122.428895449654) | |||
| 23211 | 23211 | 10510 | DPW Maintained 3 | Tristania conferta :: 79 | 1793 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/1992 12:00:00 AM | 1 | 5997601.0333 | 2108476.5582 | 37.7693366759731 | -122.451632224006 | (37.7693366759731, -122.451632224006) | |||
| 23333 | 23333 | 10480 | DPW Maintained 3 | Tristania conferta :: 79 | 1665 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/1992 12:00:00 AM | 1 | 3X3 | 5998086.3169 | 2108545.149 | 37.7695527882164 | -122.44995860301701 | (37.7695527882164, -122.449958603017) | ||
| 29655 | 29655 | 22495 | DPW Maintained 3 | Tristania conferta :: 79 | 6315 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/2011 12:00:00 AM | 1 | 3x3 | 6013233.044 | 2090405.2973 | 37.7205996457096 | -122.396294690849 | (37.7205996457096, -122.396294690849) | ||
| 46012 | 46012 | 200909 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015806.4577 | 2098231.0621 | 37.7422304915422 | -122.38794492958598 | (37.7422304915422, -122.387944929586) | |||
| 54568 | 54568 | 140188 | Undocumented 2 | Tristania conferta :: 79 | 294 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997403.6344 | 2109575.9167 | 37.772343924669 | -122.452394356341 | (37.772343924669, -122.452394356341) | |||
| 56800 | 56800 | 143430 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010708.6813 | 2116911.5375 | 37.7932390808025 | -122.406887849913 | (37.7932390808025, -122.406887849913) | |||
| 58587 | 58587 | 200519 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 62 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016469.2023 | 2095054.3401 | 37.7335445478075 | -122.38543201583401 | (37.7335445478075, -122.385432015834) | |||
| 62042 | 62042 | 199712 | Undocumented 2 | Tristania conferta :: 79 | 1510 Wallace Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015224.5084 | 2092584.2998 | 37.726693369942396 | -122.389562869076 | (37.7266933699424, -122.389562869076) | |||
| 68582 | 68582 | 53100 | Permitted Site 1 | Tristania conferta :: 79 | 560@ PINE Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 1 | Permit Number 767803 | 5999200.432999999 | 2114690.2424 | 37.7864893192828 | -122.446547106561 | (37.7864893192828, -122.446547106561) | ||
| 70495 | 70495 | 199819 | Undocumented 2 | Tristania conferta :: 79 | 2225 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015792.5909 | 2091976.5907 | 37.7250562032851 | -122.387556629575 | (37.7250562032851, -122.387556629575) | |||
| 70894 | 70894 | 200763 | Undocumented 2 | Tristania conferta :: 79 | 5299 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014413.6169 | 2093574.8725 | 37.7293682877316 | -122.392435373742 | (37.7293682877316, -122.392435373742) | |||
| 76028 | 76028 | 141362 | Undocumented 2 | Tristania conferta :: 79 | 1116 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6002077.2497 | 2110193.7413 | 37.774306963236796 | -122.436272137566 | (37.7743069632368, -122.436272137566) | |||
| 123425 | 123425 | 200225 | Undocumented 2 | Tristania conferta :: 79 | 3098 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014353.5321 | 2090113.0139 | 37.7198593794464 | -122.392401052747 | (37.7198593794464, -122.392401052747) | |||
| 147212 | 147212 | 51915 | Permitted Site 1 | Tristania conferta :: 79 | 1738 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50190 | 6004018.6596 | 2119764.7731 | 37.8006967192313 | -122.430239410546 | (37.8006967192313, -122.430239410546) | |
| 151205 | 151205 | 200143 | Undocumented 2 | Tristania conferta :: 79 | 6215 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6013445.5739 | 2090955.2697 | 37.7221215837156 | -122.395598549244 | (37.7221215837156, -122.395598549244) | |||
| 156891 | 156891 | 137780 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001115.5375 | 2111737.5615 | 37.7784912146937 | -122.439709572654 | (37.7784912146937, -122.439709572654) | |||
| 160132 | 160132 | 96027 | Permitted Site 1 | Tristania conferta :: 79 | 724 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 1 | 3x3 | Permit Number 773631 | 6007519.56601 | 2113828.09623 | 37.7845937435516 | -122.41770377222001 | (37.7845937435516, -122.41770377222) |
| 160708 | 160708 | 140352 | Undocumented 2 | Tristania conferta :: 79 | 1314 ELLIS ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004399.7686 | 2113290.1868 | 37.7829407248934 | -122.428458867439 | (37.7829407248934, -122.428458867439) | |||
| 164839 | 164839 | 68142 | Permitted Site 1 | Tristania conferta :: 79 | 2532 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | 1 | Permit Number 31896 | 6000452.2737 | 2114128.7986 | 37.785019164077 | -122.442175744115 | (37.785019164077, -122.442175744115) | |
| 171007 | 171007 | 200910 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015813.5433 | 2098253.2638 | 37.74229184539389 | -122.387921978414 | (37.7422918453939, -122.387921978414) | |||
| 175295 | 175295 | 142498 | Undocumented 2 | Tristania conferta :: 79 | 535 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6009947.0726 | 2119329.9097 | 37.79983669458289 | -122.409693853229 | (37.7998366945829, -122.409693853229) | |||
| 177451 | 177451 | 143428 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010669.142000001 | 2116906.4357 | 37.793222859977604 | -122.407024299384 | (37.7932228599776, -122.407024299384) | |||
| 182734 | 182734 | 143433 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010770.5411 | 2116920.4657 | 37.7932670566772 | -122.406674439368 | (37.7932670566772, -122.406674439368) | |||
| 187133 | 187133 | 143427 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010650.0101 | 2116903.247 | 37.793213033950295 | -122.407090272453 | (37.7932130339503, -122.407090272453) | |||
| 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) | ||
| 9586 | 9586 | 115011 | Undocumented 2 | Tristania conferta :: 79 | 1600 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6001663.1427 | 2114000.6718 | 37.784736294492795 | -122.437977348952 | (37.7847362944928, -122.437977348952) | |||
| 9849 | 9849 | 106206 | DPW Maintained 3 | Tristania conferta :: 79 | 1600X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 5x5 | 6003113.3747 | 2114020.7176 | 37.784873699559 | -122.432961462333 | (37.784873699559, -122.432961462333) | |||
| 23200 | 23200 | 22221 | DPW Maintained 3 | Tristania conferta :: 79 | 4301 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1997 12:00:00 AM | 2 | 3x3 | 6015398.3252 | 2096867.7861 | 37.7384645963363 | -122.389260963878 | (37.7384645963363, -122.389260963878) | ||
| 23303 | 23303 | 22490 | DPW Maintained 3 | Tristania conferta :: 79 | 6300 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 6013127.1033 | 2090369.4903 | 37.7204954312128 | -122.396658388199 | (37.7204954312128, -122.396658388199) | ||||
| 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) | |||
| 29400 | 29400 | 141784 | Undocumented 2 | Tristania conferta :: 79 | 1380 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003871.6154 | 2112872.0612 | 37.7817627549494 | -122.43025621822599 | (37.7817627549494, -122.430256218226) | |||
| 30173 | 30173 | 199711 | Undocumented 2 | Tristania conferta :: 79 | 1510 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015245.4888 | 2092572.1176 | 37.7266610833371 | -122.389489489481 | (37.7266610833371, -122.389489489481) | |||
| 30969 | 30969 | 140095 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005831.7882 | 2111608.4162 | 37.77840392585679 | -122.423385071553 | (37.7784039258568, -122.423385071553) | |||
| 39705 | 39705 | 137779 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001099.2377 | 2111735.524 | 37.7784846924631 | -122.439765813586 | (37.7784846924631, -122.439765813586) | |||
| 40049 | 40049 | 140097 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005837.56 | 2111570.1127 | 37.7782990795293 | -122.42336238105301 | (37.7782990795293, -122.423362381053) | |||
| 41688 | 41688 | 143431 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010731.6396 | 2116914.7262 | 37.7932491208157 | -122.40680863713301 | (37.7932491208157, -122.406808637133) | |||
| 44265 | 44265 | 199765 | Undocumented 2 | Tristania conferta :: 79 | 2010 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6016065.7481 | 2092407.7615 | 37.726255239445 | -122.386642398454 | (37.726255239445, -122.386642398454) | |||
| 49458 | 49458 | 142626 | Undocumented 2 | Tristania conferta :: 79 | 735 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6009290.0663 | 2119929.1695 | 37.8014452745633 | -122.412009721134 | (37.8014452745633, -122.412009721134) | |||
| 49502 | 49502 | 200163 | Undocumented 2 | Tristania conferta :: 79 | 1200 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014648.9326 | 2090536.3198 | 37.721038093310796 | -122.39140952495899 | (37.7210380933108, -122.391409524959) | |||
| 53947 | 53947 | 142158 | Undocumented 2 | Tristania conferta :: 79 | 1401 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001026.1857 | 2110695.1979 | 37.7756240617542 | -122.439943915036 | (37.7756240617542, -122.439943915036) | |||
| 62156 | 62156 | 51913 | Permitted Site 1 | Tristania conferta :: 79 | 1734 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50189 | 6004067.1338 | 2119771.0279 | 37.8007166387692 | -122.43007211626801 | (37.8007166387692, -122.430072116268) | |
| 64856 | 64856 | 139755 | Undocumented 2 | Tristania conferta :: 79 | 1151 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005560.6004 | 2113546.3461 | 37.7837096962291 | -122.42446109226499 | (37.7837096962291, -122.424461092265) | |||
| 66323 | 66323 | 200509 | Undocumented 2 | Tristania conferta :: 79 | 5999 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6013721.597 | 2091689.1509 | 37.7241520241375 | -122.39469576540199 | (37.7241520241375, -122.394695765402) | |||
| 67296 | 67296 | 140186 | Undocumented 2 | Tristania conferta :: 79 | 2098 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997442.3009 | 2109546.1708 | 37.7722644652587 | -122.45225845928302 | (37.7722644652587, -122.452258459283) | |||
| 67395 | 67395 | 143429 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010687.6362 | 2116910.2621 | 37.7932344012545 | -122.406960577759 | (37.7932344012545, -122.406960577759) | |||
| 68894 | 68894 | 137924 | Undocumented 2 | Tristania conferta :: 79 | 1901 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003382.682999999 | 2115264.2206 | 37.78830331594779 | -122.432118575792 | (37.7883033159478, -122.432118575792) | |||
| 71623 | 71623 | 199816 | Undocumented 2 | Tristania conferta :: 79 | 2222 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015734.8816 | 2091975.4915 | 37.72504998848329 | -122.387756049526 | (37.7250499884833, -122.387756049526) | |||
| 73293 | 73293 | 137778 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001070.034 | 2111731.4491 | 37.7784718415014 | -122.43986654775298 | (37.7784718415014, -122.439866547753) | |||
| 75080 | 75080 | 139733 | Undocumented 2 | Tristania conferta :: 79 | 1181 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005538.6858 | 2113694.4096 | 37.784115004469 | -122.42454744419399 | (37.784115004469, -122.424547444194) | |||
| 75175 | 75175 | 113554 | Undocumented 2 | Tristania conferta :: 79 | 400X Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6007659.5152 | 2112834.4553 | 37.781873320553295 | -122.41714916120002 | (37.7818733205533, -122.4171491612) | |||
| 132522 | 132522 | 141862 | Undocumented 2 | Tristania conferta :: 79 | 1150 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004492.6811 | 2112607.5904 | 37.7810717419138 | -122.428088768812 | (37.7810717419138, -122.428088768812) | |||
| 149612 | 149612 | 141846 | Undocumented 2 | Tristania conferta :: 79 | 1273 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004395.0795 | 2112899.1361 | 37.781866731536 | -122.42844720804399 | (37.781866731536, -122.428447208044) | |||
| 152647 | 152647 | 200243 | Undocumented 2 | Tristania conferta :: 79 | 3099 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6014440.6296 | 2090158.0853 | 37.719987972824896 | -122.39210313506099 | (37.7199879728249, -122.392103135061) | |||
| 153307 | 153307 | 50650 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2012 12:00:00 AM | 2 | Permit Number 768661 | 6012184.2732 | 2112660.7106 | 37.7816497657614 | -122.401483287822 | (37.7816497657614, -122.401483287822) | ||
| 153665 | 153665 | 140099 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005844.3812 | 2111525.5128 | 37.7781770040399 | -122.423335612643 | (37.7781770040399, -122.423335612643) | |||
| 154567 | 154567 | 89052 | Permitted Site 1 | Tristania conferta :: 79 | 2420 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767132 | 6000895.8744 | 2114188.3074 | 37.7852078310557 | -122.440645300245 | (37.7852078310557, -122.440645300245) | |
| 161724 | 161724 | 141773 | Undocumented 2 | Tristania conferta :: 79 | 1310 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003760.0771 | 2113253.4803 | 37.7828037182207 | -122.43066931421998 | (37.7828037182207, -122.43066931422) | |||
| 171370 | 171370 | 89051 | Permitted Site 1 | Tristania conferta :: 79 | 2420 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767132 | 6000933.3562 | 2114194.3706 | 37.7852266134024 | -122.440516060128 | (37.7852266134024, -122.440516060128) | |
| 171611 | 171611 | 94414 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53653 | 6013808.0998 | 2092150.7804 | 37.7254243749067 | -122.394429043825 | (37.7254243749067, -122.394429043825) | |
| 172364 | 172364 | 245185 | Undocumented 2 | Tristania conferta :: 79 | 1134 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001109.3879 | 2109363.1674 | 37.77197137649289 | -122.43956058787501 | (37.7719713764929, -122.439560587875) | |||
| 176512 | 176512 | 143432 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010753.9601 | 2116917.9148 | 37.793259124815705 | -122.406731631165 | (37.7932591248157, -122.406731631165) | |||
| 182384 | 182384 | 246258 | Undocumented 2 | Tristania conferta :: 79 | 258 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002882.0144 | 2106736.0778 | 37.764858759447996 | -122.433241197137 | (37.764858759448, -122.433241197137) | |||
| 182627 | 182627 | 200520 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 63 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6016476.5475 | 2095041.1188 | 37.7335086511389 | -122.38540570010599 | (37.7335086511389, -122.385405700106) | |||
| 184769 | 184769 | 199885 | Undocumented 2 | Tristania conferta :: 79 | 1624 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6016716.7638 | 2093277.2481 | 37.728678698833605 | -122.384452383066 | (37.7286786988336, -122.384452383066) | |||
| 187341 | 187341 | 138720 | Undocumented 2 | Tristania conferta :: 79 | 2921 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999959.1608 | 2114707.5789 | 37.7865802293131 | -122.44392335178699 | (37.7865802293131, -122.443923351787) | |||
| 189058 | 189058 | 200839 | Undocumented 2 | Tristania conferta :: 79 | 1499 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6012131.3311 | 2106987.3608 | 37.7660690877931 | -122.40126764344 | (37.7660690877931, -122.40126764344) | |||
| 739 | 739 | 13244 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2012 12:00:00 AM | 3 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.44006524578501 | (37.7992300540772, -122.440065245785) | ||
| 979 | 979 | 200925 | Undocumented 2 | Tristania conferta :: 79 | 4100 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | Width 0ft | 6015478.3928 | 2097437.2349 | 37.7400326248174 | -122.389023874228 | (37.7400326248174, -122.389023874228) | ||
| 984 | 984 | 24262 | DPW Maintained 3 | Tristania conferta :: 79 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | ||
| 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) | ||
| 2361 | 2361 | 12987 | Permitted Site 1 | Tristania conferta :: 79 | 318 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6010766.7048 | 2120702.1725 | 37.8036504876245 | -122.406954379692 | (37.8036504876245, -122.406954379692) | ||
| 2471 | 2471 | 7042 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2009 12:00:00 AM | 3 | 3X3 | 6001153.5455 | 2110065.6201 | 37.7739026486508 | -122.43945820683099 | (37.7739026486508, -122.439458206831) | ||
| 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) | ||
| 2847 | 2847 | 7089 | Permitted Site 1 | Tristania conferta :: 79 | 1874 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2009 12:00:00 AM | 3 | 3x3 | 5998459.5467 | 2109686.5004 | 37.7727079965007 | -122.448749840415 | (37.7727079965007, -122.448749840415) | ||
| 2872 | 2872 | 7051 | Permitted Site 1 | Tristania conferta :: 79 | 1350 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6000969.3144 | 2110039.798 | 37.773821261144 | -122.440093639062 | (37.773821261144, -122.440093639062) | ||
| 2968 | 2968 | 7092 | Permitted Site 1 | Tristania conferta :: 79 | 1926 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 5998180.0393 | 2109648.8744 | 37.7725886979314 | -122.449713970747 | (37.7725886979314, -122.449713970747) | ||
| 3080 | 3080 | 28823 | Permitted Site 1 | Tristania conferta :: 79 | 1054 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002356.6442 | 2110231.7539 | 37.77442720694221 | -122.435308381556 | (37.7744272069422, -122.435308381556) | ||
| 3260 | 3260 | 42633 | DPW Maintained 3 | Tristania conferta :: 79 | 1651 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:56:00 PM | 3 | 5x5 | Permit Number 45045 | 6005048.16251 | 2118816.23898 | 37.7981505449739 | -122.426609321383 | (37.7981505449739, -122.426609321383) |
| 3588 | 3588 | 24306 | Permitted Site 1 | Tristania conferta :: 79 | 1513 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1994 12:00:00 AM | 3 | 6002219.6394 | 2111892.3425 | 37.7789789862822 | -122.435901149592 | (37.7789789862822, -122.435901149592) | |||
| 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) | ||
| 4200 | 4200 | 28075 | Permitted Site 1 | Tristania conferta :: 79 | 915 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008651.5543 | 2120512.2278 | 37.8030103621977 | -122.41426054224199 | (37.8030103621977, -122.414260542242) | ||
| 4388 | 4388 | 251703 | Undocumented 2 | Tristania conferta :: 79 | 123 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 10:45:00 AM | 3 | 3x3 | 6004216.0 | 2094352.0 | 37.7309305395323 | -122.42774483827299 | (37.7309305395323, -122.427744838273) | ||
| 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) | ||
| 5258 | 5258 | 7076 | Permitted Site 1 | Tristania conferta :: 79 | 1712 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3 | 3x3 | 5999133.3592 | 2109779.0297 | 37.7730005664352 | -122.44642571608499 | (37.7730005664352, -122.446425716085) | ||
| 5310 | 5310 | 6936 | DPW Maintained 3 | Tristania conferta :: 79 | 528 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6004857.7315 | 2110586.3971 | 37.775542688283 | -122.426681902022 | (37.775542688283, -122.426681902022) | ||
| 5315 | 5315 | 18239 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2000 12:00:00 AM | 3 | 4X4 | 6003687.2504 | 2114237.8837 | 37.7855025167716 | -122.43099154386499 | (37.7855025167716, -122.430991543865) | ||
| 5743 | 5743 | 12280 | Permitted Site 1 | Tristania conferta :: 79 | 741 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1997 12:00:00 AM | 3 | 3X3 | 6004879.1558 | 2111501.6218 | 37.7780568825374 | -122.42667297875201 | (37.7780568825374, -122.426672978752) |
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");