Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87143 | 87143 | 94697 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2443 Clement St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53831 | 5987960.0 | 2113267.0 | 37.7819330460656 | -122.485331246452 | (37.7819330460656, -122.485331246452) | ||
| 87202 | 87202 | 94153 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2039 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53543 | 5990940.5 | 2101530.8 | 37.749881780304605 | -122.474163585532 | (37.7498817803046, -122.474163585532) | ||
| 87255 | 87255 | 84692 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2595 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52755 | 5987984.46067049 | 2097655.73005422 | 37.739070178519704 | -122.48410144552601 | (37.7390701785197, -122.484101445526) | |
| 87465 | 87465 | 51286 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1026 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767263 | 6004381.40328388 | 2102911.72608688 | 37.7544429415209 | -122.42778267914301 | (37.7544429415209, -122.427782679143) | |
| 87629 | 87629 | 47521 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 250 Santa Rosa Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45392 | 6000921.51016478 | 2093527.18016994 | 37.728478861528004 | -122.43907531656299 | (37.728478861528, -122.439075316563) | ||
| 88443 | 88443 | 108083 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 626 Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010239.318530001 | 2105432.7215400003 | 37.761694663220894 | -122.40770213976101 | (37.7616946632209, -122.407702139761) | |||||
| 88581 | 88581 | 94959 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1059 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/09/2010 12:00:00 AM | 6018613.9 | 2096078.3 | 37.7364745658864 | -122.37808815314199 | (37.7364745658864, -122.378088153142) | ||||
| 88615 | 88615 | 100034 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | |||
| 88769 | 88769 | 94176 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 207 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53592 | 6000068.3 | 2105615.8 | 37.7616227342332 | -122.442892631099 | (37.7616227342332, -122.442892631099) | ||
| 89010 | 89010 | 88756 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 990 Polk St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284.0 | 37.785814090273796 | -122.41966893082501 | (37.7858140902738, -122.419668930825) | ||
| 89023 | 89023 | 46848 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 198 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44916 | 6004181.50847912 | 2092412.60436793 | 37.72560343989 | -122.42772595157301 | (37.72560343989, -122.427725951573) | ||
| 89155 | 89155 | 113309 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 COLONIAL WAY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 6000472.0 | 2093592.0 | 37.728631254327105 | -122.440633939625 | (37.7286312543271, -122.440633939625) | ||||
| 89200 | 89200 | 50859 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 265 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | Permit Number 47374 | 6001990.14047863 | 2094209.80770193 | 37.730413948640205 | -122.43542982359101 | (37.7304139486402, -122.435429823591) | |||
| 89229 | 89229 | 48455 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 583 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | Permit Number 45823 | 5999806.95358347 | 2104023.79131082 | 37.7572365678724 | -122.443682145846 | (37.7572365678724, -122.443682145846) | |||
| 89312 | 89312 | 53751 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4363 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767253 | 6000874.04006576 | 2101684.94422923 | 37.750875463266894 | -122.439824069935 | (37.7508754632669, -122.439824069935) | |
| 89378 | 89378 | 46154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 466 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2008 12:00:00 AM | 3x3 | Permit Number 51922 | 5997486.25604709 | 2107473.80664401 | 37.766576803009 | -122.45195687708201 | (37.766576803009, -122.451956877082) | ||
| 89858 | 89858 | 98456 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2012 12:00:00 AM | 3x3 | Permit Number 768632 | 5999564.1 | 2106366.8 | 37.763656035019395 | -122.444690429241 | (37.7636560350194, -122.444690429241) | ||
| 90053 | 90053 | 103112 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 539 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2013 12:00:00 AM | 3x3 | Permit Number 770029 | 5994732.2 | 2092139.3 | 37.7243139617339 | -122.460371410138 | (37.7243139617339, -122.460371410138) | ||
| 90054 | 90054 | 99710 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 90260 | 90260 | 50908 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2319 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53523 | 5991020.39994254 | 2099616.05827912 | 37.74462902470871 | -122.47374762598999 | (37.7446290247087, -122.47374762599) | ||
| 90359 | 90359 | 98459 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 UPPER TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2012 12:00:00 AM | 3x3 | Permit Number 768632 | 5999573.7 | 2106360.6 | 37.7636395591816 | -122.444656780294 | (37.7636395591816, -122.444656780294) | ||
| 90430 | 90430 | 94142 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1846 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53560 | 5993183.4 | 2102902.4 | 37.753777516232 | -122.466507276779 | (37.753777516232, -122.466507276779) | ||
| 90494 | 90494 | 88757 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 990 Polk St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284.0 | 37.785814090273796 | -122.41966893082501 | (37.7858140902738, -122.419668930825) | ||
| 90500 | 90500 | 41285 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52403 | 6005499.65147882 | 2107857.73967205 | 37.7680867232876 | -122.424267232407 | (37.7680867232876, -122.424267232407) | ||
| 90593 | 90593 | 50487 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 247 Louisburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | Permit Number 47123 | 5997593.4002378 | 2090478.75871424 | 37.719918679369606 | -122.45036104889799 | (37.7199186793696, -122.450361048898) | ||
| 90695 | 90695 | 82798 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1925 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49857 | 5989069.54890365 | 2102231.72490285 | 37.7516977731236 | -122.480684653834 | (37.7516977731236, -122.480684653834) | ||
| 90978 | 90978 | 47146 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 138 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/2002 12:00:00 AM | Permit Number 45119 | 5992930.24436849 | 2094060.37682206 | 37.7294849440246 | -122.466740042815 | (37.7294849440246, -122.466740042815) | ||
| 91031 | 91031 | 51966 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 624 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2005 12:00:00 AM | Permit Number 48186 | 6004986.46742486 | 2111098.21623731 | 37.7769552960255 | -122.42627302081699 | (37.7769552960255, -122.426273020817) | ||
| 91148 | 91148 | 94157 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1552 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53538 | 5993733.5 | 2104914.7 | 37.7593345004852 | -122.464751039907 | (37.7593345004852, -122.464751039907) | ||
| 91201 | 91201 | 121395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4098x 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002425.0 | 2104765.0 | 37.7594207214866 | -122.434680934086 | (37.7594207214866, -122.434680934086) | ||||
| 91235 | 91235 | 47701 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 105 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45497 | 6003509.82655426 | 2097791.42406059 | 37.7403344433628 | -122.430431505695 | (37.7403344433628, -122.430431505695) | ||
| 91417 | 91417 | 95421 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52610 | 6002863.5 | 2105624.8 | 37.7618064095 | -122.433225823053 | (37.7618064095, -122.433225823053) | |
| 91518 | 91518 | 69086 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1466 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53819 | 5992143.8934222 | 2105465.60262386 | 37.7607553597545 | -122.47028874127399 | (37.7607553597545, -122.470288741274) | |
| 91612 | 91612 | 104867 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 Holladay Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | ||||
| 92195 | 92195 | 64642 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3690 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2008 12:00:00 AM | 3x3 | Permit Number 50908 | 6003788.87789947 | 2103653.29299463 | 37.756445572701004 | -122.429884677586 | (37.756445572701, -122.429884677586) | ||
| 92213 | 92213 | 99888 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5646 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2012 12:00:00 AM | 3x3 | Permit Number 767758 | 5998305.1 | 2087181.1 | 37.710904770255105 | -122.44766369700199 | (37.7109047702551, -122.447663697002) | ||
| 92239 | 92239 | 89369 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 360 Benton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2008 12:00:00 AM | 3x3 | Permit Number 51947 | 6006757.2 | 2095391.9 | 37.7339292995254 | -122.419033201721 | (37.7339292995254, -122.419033201721) | ||
| 92397 | 92397 | 87232 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575X Judah St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2007 12:00:00 AM | 3x3 | Permit Number 50266 | 5986663.0 | 2105714.0 | 37.7611189843543 | -122.4892627097 | (37.7611189843543, -122.4892627097) | ||
| 92610 | 92610 | 95406 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 395 Valley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767278 | 6003403.3 | 2099172.9 | 37.7441216223731 | -122.430898399301 | (37.7441216223731, -122.430898399301) | |
| 93353 | 93353 | 85071 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 501 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009818.0 | 2105945.0 | 37.7630776692381 | -122.409195467269 | (37.7630776692381, -122.409195467269) | |||||
| 93504 | 93504 | 84211 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50699 | 6008536.64493866 | 2086928.58742632 | 37.710790872531796 | -122.412283117187 | (37.7107908725318, -122.412283117187) | ||
| 93623 | 93623 | 94948 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Pomona St | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 04/04/2009 12:00:00 AM | 6014124.7 | 2094445.3 | 37.7317422564721 | -122.39349508644399 | (37.7317422564721, -122.393495086444) | ||||
| 93756 | 93756 | 51447 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 326 Bocana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2004 12:00:00 AM | Permit Number 47765 | 6006818.05257651 | 2097195.51767411 | 37.7388850615796 | -122.41895069494 | (37.7388850615796, -122.41895069494) | ||
| 93785 | 93785 | 93907 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 733 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2010 12:00:00 AM | 3x3 | Permit Number 53380 | 5987516.1 | 2110955.9 | 37.7755615483313 | -122.486697161376 | (37.7755615483313, -122.486697161376) | ||
| 93874 | 93874 | 121638 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 298x Otsego Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000311.0 | 2091736.0 | 37.7235259352509 | -122.44105742466101 | (37.7235259352509, -122.441057424661) | ||||
| 94162 | 94162 | 93219 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1675 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2010 12:00:00 AM | 3x3 | Permit Number 53212 | 6004290.0 | 2108739.0 | 37.7704380729677 | -122.42851411253 | (37.7704380729677, -122.42851411253) | ||
| 94175 | 94175 | 84667 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4045 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6002887.32453677 | 2101799.94982156 | 37.7513056360956 | -122.432870165781 | (37.7513056360956, -122.432870165781) | ||
| 94217 | 94217 | 94954 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1725 Monterey Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53987 | 5992718.5 | 2095334.0 | 37.7329697745731 | -122.46756464142901 | (37.7329697745731, -122.467564641429) | ||
| 94281 | 94281 | 96080 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 3x3 | Permit Number 767704 | 5983278.4 | 2110433.5 | 37.7738792326413 | -122.501317504516 | (37.7738792326413, -122.501317504516) | |
| 94352 | 94352 | 84881 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2126 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2010 12:00:00 AM | Permit Number 53205 | 5997689.0 | 2109922.0 | 37.773310524808004 | -122.451432221326 | (37.773310524808, -122.451432221326) | |||
| 94527 | 94527 | 96396 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2011 12:00:00 AM | 3x3 | Permit Number 767136 | 6015449.8 | 2105317.4 | 37.7616683177051 | -122.389672976331 | (37.7616683177051, -122.389672976331) | ||
| 94676 | 94676 | 50929 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2261 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47425 | 5991475.24491559 | 2099916.59093812 | 37.745480542950794 | -122.472196779655 | (37.7454805429508, -122.472196779655) | ||
| 95000 | 95000 | 36601 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1436 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | Permit Number 46996 | 6009536.9669184005 | 2100854.59683239 | 37.749084817998096 | -122.40980812962 | (37.7490848179981, -122.40980812962) | ||
| 95051 | 95051 | 47019 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 380 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2002 12:00:00 AM | Permit Number 45014 | 6004716.89647578 | 2110040.09694572 | 37.7740347181094 | -122.427130164093 | (37.7740347181094, -122.427130164093) | ||
| 95679 | 95679 | 47032 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | Permit Number 45025 | 6005541.3 | 2109365.2 | 37.772228199123504 | -122.424230399247 | (37.7722281991235, -122.424230399247) | ||
| 95776 | 95776 | 47315 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1420 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/2002 12:00:00 AM | Permit Number 45244 | 6010384.18455371 | 2100995.83638931 | 37.7495200736312 | -122.406888381765 | (37.7495200736312, -122.406888381765) | ||
| 95793 | 95793 | 112568 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 455 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2015 12:00:00 AM | 3x3 | 6005755.8 | 2107791.7 | 37.767919854309795 | -122.423376545374 | (37.7679198543098, -122.423376545374) | |||
| 95840 | 95840 | 51935 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 329 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2005 12:00:00 AM | Permit Number 48161 | 6009200.27838208 | 2121477.92859384 | 37.805692742557 | -122.412429964781 | (37.805692742557, -122.412429964781) | |||
| 95961 | 95961 | 92265 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2472 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52713 | 5991763.7 | 2098612.3 | 37.7419159834623 | -122.471104352673 | (37.7419159834623, -122.471104352673) | ||
| 95982 | 95982 | 82672 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 69 Jennings Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52500 | 6012954.77206528 | 2089215.57064421 | 37.7173174061263 | -122.397173214353 | (37.7173174061263, -122.397173214353) | ||
| 95983 | 95983 | 96151 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 430 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767786 | 6008221.0 | 2096832.0 | 37.7379658214485 | -122.41407422867701 | (37.7379658214485, -122.414074228677) | |
| 96074 | 96074 | 91570 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Girard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2009 12:00:00 AM | 3x3 | Permit Number 52142 | 6010768.0 | 2093361.0 | 37.7285779166605 | -122.405023621917 | (37.7285779166605, -122.405023621917) | ||
| 96153 | 96153 | 50932 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1215 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47428 | 5990544.32078517 | 2103795.24406769 | 37.7560763890307 | -122.475698913277 | (37.7560763890307, -122.475698913277) | ||
| 96235 | 96235 | 115195 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 288 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 777365 | 6002703.4 | 2104224.0 | 37.7579510666244 | -122.43367942577 | (37.7579510666244, -122.43367942577) | |||
| 96242 | 96242 | 51018 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 47 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | Permit Number 47496 | 5994712.98780425 | 2094856.14173949 | 37.7317726449069 | -122.46063461048901 | (37.7317726449069, -122.460634610489) | |||
| 96244 | 96244 | 40667 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 101 Maynard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767516 | 6004070.62612566 | 2093782.39936272 | 37.72935831911229 | -122.428206841061 | (37.7293583191123, -122.428206841061) | |
| 96360 | 96360 | 88743 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 313 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51678 | 6004494.0 | 2099843.0 | 37.746023301829 | -122.42717471976299 | (37.746023301829, -122.427174719763) | ||
| 96717 | 96717 | 48493 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 688(REVISED) Powhattan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2002 12:00:00 AM | Permit Number 45836 | 6008651.5358149 | 2098064.55146278 | 37.7413743105027 | -122.412672757895 | (37.7413743105027, -122.412672757895) | |||
| 96866 | 96866 | 46685 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1563 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2016 12:00:00 AM | Permit Number 776034 | 5992114.70084954 | 2104801.75310053 | 37.758930915917 | -122.470341358559 | (37.758930915917, -122.470341358559) | ||
| 97124 | 97124 | 71983 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767446 | 6001962.16426713 | 2101054.16463509 | 37.74920537061129 | -122.436016109621 | (37.7492053706113, -122.436016109621) | |
| 97370 | 97370 | 95680 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 Holyoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767431 | 6009606.0 | 2092917.0 | 37.7272937607735 | -122.40900942327801 | (37.7272937607735, -122.409009423278) | |
| 97381 | 97381 | 88421 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
| 97414 | 97414 | 47585 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 36 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | Permit Number 45431 | 6002613.66741283 | 2105688.06420999 | 37.7619659419506 | -122.43409441617399 | (37.7619659419506, -122.434094416174) | |||
| 97621 | 97621 | 98306 | Section 143 8 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 155 Terrace Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993776.0 | 2096639.0 | 37.7366139805049 | -122.46400331489299 | (37.7366139805049, -122.464003314893) | ||||||
| 97699 | 97699 | 63969 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 418 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767269 | 6002421.30681458 | 2101530.33007139 | 37.7505388815759 | -122.434462430338 | (37.7505388815759, -122.434462430338) | |
| 97753 | 97753 | 87227 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575X Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2007 12:00:00 AM | 3x3 | Permit Number 50266 | 5986663.0 | 2105714.0 | 37.7611189843543 | -122.4892627097 | (37.7611189843543, -122.4892627097) | ||
| 98064 | 98064 | 96155 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 379 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767789 | 6007353.2 | 2096549.6 | 37.737141633664606 | -122.417054644548 | (37.7371416336646, -122.417054644548) | |
| 98084 | 98084 | 94145 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1705 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53555 | 5992755.0 | 2103821.2 | 37.756275572456204 | -122.468055597969 | (37.7562755724562, -122.468055597969) | ||
| 98304 | 98304 | 83400 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 549 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50789 | 6003023.85694272 | 2105066.6601053 | 37.7602829872233 | -122.432631342556 | (37.7602829872233, -122.432631342556) | ||
| 98586 | 98586 | 50893 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2321 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47403 | 5991236.43569631 | 2099609.01496649 | 37.7446221954518 | -122.473000110832 | (37.7446221954518, -122.473000110832) | ||
| 98755 | 98755 | 47002 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 133 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | Permit Number 45001 | 6004750.78049806 | 2108920.69040717 | 37.77096301566829 | -122.426933212426 | (37.7709630156683, -122.426933212426) | ||
| 99034 | 99034 | 106992 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 6004025.8 | 2114231.4 | 37.785503891427005 | -122.42981979958701 | (37.785503891427, -122.429819799587) | ||||
| 99097 | 99097 | 87228 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575X Judah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2007 12:00:00 AM | 3x3 | Permit Number 50266 | 5986663.0 | 2105714.0 | 37.7611189843543 | -122.4892627097 | (37.7611189843543, -122.4892627097) | ||
| 99132 | 99132 | 51392 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Rausch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | Permit Number 47720 | 6009581.33332398 | 2110978.5612901 | 37.77688540137029 | -122.410369452214 | (37.7768854013703, -122.410369452214) | ||
| 99134 | 99134 | 92496 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1268 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53913 | 5993659.7 | 2106862.4 | 37.7646781211284 | -122.465147741843 | (37.7646781211284, -122.465147741843) | |
| 99333 | 99333 | 89368 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 360 Benton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2008 12:00:00 AM | 3x3 | Permit Number 51947 | 6006757.2 | 2095391.9 | 37.7339292995254 | -122.419033201721 | (37.7339292995254, -122.419033201721) | ||
| 99565 | 99565 | 47149 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 34 Fairfield Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45121 | 5993906.40512515 | 2092988.79754864 | 37.726598936949294 | -122.463287657843 | (37.7265989369493, -122.463287657843) | ||
| 100137 | 100137 | 51393 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 12 Rausch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | Permit Number 47720 | 6009581.33332398 | 2110978.5612901 | 37.77688540137029 | -122.410369452214 | (37.7768854013703, -122.410369452214) | ||
| 100166 | 100166 | 95402 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 300 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767275 | 6003789.7 | 2099328.3 | 37.7445702007996 | -122.42957339435199 | (37.7445702007996, -122.429573394352) | |
| 100337 | 100337 | 32947 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37265 | 6012942.48941846 | 2105645.52533205 | 37.762429926839204 | -122.39836783116002 | (37.7624299268392, -122.39836783116) | ||
| 100441 | 100441 | 94956 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53988 | 5994700.9 | 2092261.1 | 37.7246465945991 | -122.46048843061199 | (37.7246465945991, -122.460488430612) | |
| 100494 | 100494 | 97562 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 182 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2012 12:00:00 AM | Permit Number 768967 | 5994515.7 | 2091119.6 | 37.7215016543215 | -122.461045939781 | (37.7215016543215, -122.461045939781) | |||
| 100544 | 100544 | 50892 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2295 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47402 | 5991242.68773323 | 2099812.30269928 | 37.745180733096795 | -122.47299331417801 | (37.7451807330968, -122.472993314178) | ||
| 100552 | 100552 | 99740 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2770 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2012 12:00:00 AM | 3x3 | Permit Number 768985 | 6000934.0 | 2116568.0 | 37.7917440216798 | -122.440684150501 | (37.7917440216798, -122.440684150501) | ||
| 100630 | 100630 | 51056 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 54 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | Permit Number 47525 | 5995348.66359825 | 2096127.81684648 | 37.7353009064396 | -122.45852898439699 | (37.7353009064396, -122.458528984397) | |||
| 100806 | 100806 | 91567 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2009 12:00:00 AM | 3x3 | Permit Number 52142 | 6010768.0 | 2093361.0 | 37.7285779166605 | -122.405023621917 | (37.7285779166605, -122.405023621917) | ||
| 100922 | 100922 | 104446 | Private 5 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 100940 | 100940 | 47001 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 127 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | Permit Number 45001 | 6004764.4 | 2108902.6 | 37.770914113875605 | -122.426884813577 | (37.7709141138756, -122.426884813577) | ||
| 101259 | 101259 | 65547 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340X Juanita Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1990 12:00:00 AM | Permit Number 770105 | 5994976.11327418 | 2097601.99657825 | 37.7393272229464 | -122.459923774546 | (37.7393272229464, -122.459923774546) | ||
| 101286 | 101286 | 93749 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 455 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2010 12:00:00 AM | 3x3 | Permit Number 53324 | 6003563.0 | 2100087.0 | 37.7466405761834 | -122.43041139941002 | (37.7466405761834, -122.43041139941) |
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");