Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71 | 71 | 251206 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 270 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005145.0 | 2094297.0 | 37.7308320294825 | -122.424529217878 | (37.7308320294825, -122.424529217878) | ||||
| 1749 | 1749 | 251678 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1841 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989656.0 | 2102823.0 | 37.7533553254519 | -122.478699889248 | (37.7533553254519, -122.478699889248) | ||||
| 3396 | 3396 | 253424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993083.0 | 2114893.0 | 37.7866947153523 | -122.46772647285 | (37.7866947153523, -122.46772647285) | ||||
| 3822 | 3822 | 253559 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5993184.39566 | 2099612.1282900004 | 37.7447433294416 | -122.46626473273199 | (37.7447433294416, -122.466264732732) | ||||
| 4704 | 4704 | 253666 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 578 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993791.71774 | 2111566.05198 | 37.7776007134003 | -122.465032776868 | (37.7776007134003, -122.465032776868) | ||||
| 17860 | 17860 | 101958 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200X Ripley St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/2013 12:00:00 AM | 3x3 | Permit Number 770180 | 6009339.0 | 2099105.0 | 37.744269714821 | -122.410369184032 | (37.744269714821, -122.410369184032) | ||
| 18032 | 18032 | 99798 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 723-725 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001735.0 | 2102034.0 | 37.7518828570558 | -122.43687178091899 | (37.7518828570558, -122.436871780919) | ||||
| 18366 | 18366 | 92323 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2595 27th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2009 12:00:00 AM | 3x3 | Permit Number 52755 | 5987970.2 | 2097662.1 | 37.739086838436606 | -122.484151218827 | (37.7390868384366, -122.484151218827) | |
| 18402 | 18402 | 48402 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 706 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | Permit Number 53935 | 6012689.64928807 | 2104214.1545054 | 37.7584856101735 | -122.399141839868 | (37.7584856101735, -122.399141839868) | |||
| 18633 | 18633 | 41286 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 494 14th St | 1 | 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) | ||
| 18879 | 18879 | 94134 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 18 Nebraska St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53498 | 6009291.0 | 2097948.0 | 37.7410901551317 | -122.41045347697501 | (37.7410901551317, -122.410453476975) | |||
| 19061 | 19061 | 50930 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2287 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47426 | 5991460.4982554 | 2099833.27531374 | 37.745250926286396 | -122.47224169859699 | (37.7452509262864, -122.472241698597) | ||
| 20033 | 20033 | 239534 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007215.03698 | 2097696.74866 | 37.7402836768401 | -122.417613619697 | (37.7402836768401, -122.417613619697) | ||||
| 20479 | 20479 | 73501 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1045 Diamond St | 2 | 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) | |
| 20494 | 20494 | 97050 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1841 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2011 12:00:00 AM | 4x4 | Permit Number 768113 | 5989656.1 | 2102823.3 | 37.7533561549786 | -122.478699565369 | (37.7533561549786, -122.478699565369) | ||
| 20977 | 20977 | 55153 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3933 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2009 12:00:00 AM | 3x3 | Permit Number 52132 | 6003602.67369464 | 2101839.43403285 | 37.7514545976895 | -122.43039922507201 | (37.7514545976895, -122.430399225072) | ||
| 21236 | 21236 | 92078 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1151 Sutter St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2009 12:00:00 AM | 3x3 | Permit Number 52192 | 6007083.0 | 2115004.0 | 37.7877979108835 | -122.41929759225799 | (37.7877979108835, -122.419297592258) | |||
| 22246 | 22246 | 239535 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 5 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6007214.411780001 | 2097683.0452099997 | 37.7402460150284 | -122.417614810389 | (37.7402460150284, -122.417614810389) | ||||
| 24421 | 24421 | 47030 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Waller St | 1 | 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) | ||
| 34900 | 34900 | 60775 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 709 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53493 | 6001812.90268629 | 2102029.53608066 | 37.751875027523205 | -122.436602063487 | (37.7518750275232, -122.436602063487) | ||
| 42740 | 42740 | 96157 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 539 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767790 | 6006264.3 | 2096224.2 | 37.736186842338206 | -122.42079637851499 | (37.7361868423382, -122.420796378515) | |
| 45606 | 45606 | 95570 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 564 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767361 | 6001501.0 | 2101469.0 | 37.7503181999041 | -122.437640524789 | (37.7503181999041, -122.437640524789) | |
| 50079 | 50079 | 91569 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Girard St | 4 | 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) | ||
| 51253 | 51253 | 51883 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 209 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48099 | 6006849.08815448 | 2097918.82782797 | 37.740872857816 | -122.418894673949 | (37.740872857816, -122.418894673949) | |||
| 53183 | 53183 | 53644 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4051 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52604 | 6002653.10802153 | 2105292.31520624 | 37.7608815491861 | -122.43392971771699 | (37.7608815491861, -122.433929717717) | |
| 54620 | 54620 | 121637 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 298x Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000311.0 | 2091736.0 | 37.7235259352509 | -122.44105742466101 | (37.7235259352509, -122.441057424661) | ||||
| 63655 | 63655 | 91136 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2009 12:00:00 AM | 3x3 | Permit Number 52024 | 6005604.0 | 2107874.4 | 37.768138360101204 | -122.423907486341 | (37.7681383601012, -122.423907486341) | ||
| 76816 | 76816 | 104448 | Private 5 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 77311 | 77311 | 51859 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2701 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1982 12:00:00 AM | Permit Number 48081 | 6008321.98610065 | 2102690.0223994 | 37.754056319335106 | -122.414139393949 | (37.7540563193351, -122.414139393949) | |||
| 77358 | 77358 | 47252 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1001 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767654 | 6013117.42744406 | 2089558.25653077 | 37.718267407089 | -122.39663499597201 | (37.718267407089, -122.396634995972) | |
| 77613 | 77613 | 94798 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2495@Ulloa 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | Permit Number 767295 | 5989187.3 | 2098380.9 | 37.741131264018 | -122.479995678002 | (37.741131264018, -122.479995678002) | ||
| 77900 | 77900 | 99712 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Paloma Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992094.2 | 2093835.6 | 37.7288194775612 | -122.469613947177 | (37.7288194775612, -122.469613947177) | |||||
| 78088 | 78088 | 93220 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1675 Post St | 2 | 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) | ||
| 78144 | 78144 | 87131 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 20 De Montfort Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 3x3 | Permit Number 50083 | 5995245.2 | 2091924.0 | 37.7237522965749 | -122.45858247555599 | (37.7237522965749, -122.458582475556) | |||
| 78152 | 78152 | 93720 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2329 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/24/2010 12:00:00 AM | 3x3 | Permit Number 53311 | 5991400.2 | 2099543.1 | 37.7444506897731 | -122.472429047351 | (37.7444506897731, -122.472429047351) | ||
| 78531 | 78531 | 104869 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 Holladay Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | ||||
| 78980 | 78980 | 92273 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 526 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52721 | 5994919.0 | 2098257.0 | 37.7411224151431 | -122.4601686872 | (37.7411224151431, -122.4601686872) | ||
| 79204 | 79204 | 95400 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 227 Valley St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767274 | 6004277.7 | 2099178.3 | 37.744185954454295 | -122.42787530142701 | (37.7441859544543, -122.427875301427) | ||
| 79436 | 79436 | 49639 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46495 | 5996531.16368383 | 2094439.5259582 | 37.7307331551513 | -122.454318757944 | (37.7307331551513, -122.454318757944) | ||
| 79923 | 79923 | 88562 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 626 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2008 12:00:00 AM | 3x3 | Permit Number 51508 | 5991243.0 | 2100466.0 | 37.746975634994 | -122.473039896118 | (37.746975634994, -122.473039896118) | ||
| 80030 | 80030 | 84222 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1099 Sunnydale Ave | 2 | 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) | ||
| 80136 | 80136 | 98460 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 UPPER TER | 3 | 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) | ||
| 80158 | 80158 | 51463 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 187 Ellsworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47778 | 6008133.81898598 | 2097762.9616442 | 37.740517140615104 | -122.414441512607 | (37.7405171406151, -122.414441512607) | ||
| 80315 | 80315 | 88754 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 990 Polk St | 11 | 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) | ||
| 80414 | 80414 | 82641 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2902 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52206 | 6010042.71011314 | 2101659.66288347 | 37.7513236811165 | -122.40811602659299 | (37.7513236811165, -122.408116026593) | ||
| 81030 | 81030 | 87909 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 545 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50932 | 6009866.9 | 2098955.7 | 37.7438893484496 | -122.40853328112101 | (37.7438893484496, -122.408533281121) | ||
| 81130 | 81130 | 47147 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 138 Aptos Ave | 2 | 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) | ||
| 81135 | 81135 | 82980 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 535-537 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52398 | 6004842.87299878 | 2110699.22399126 | 37.7758516433121 | -122.426741337783 | (37.7758516433121, -122.426741337783) | ||
| 81215 | 81215 | 53899 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1057 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2009 12:00:00 AM | Permit Number 52970 | 6011224.04910165 | 2089865.72837227 | 37.7190061040508 | -122.403201256455 | (37.7190061040508, -122.403201256455) | |||
| 81266 | 81266 | 94150 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1623 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53548 | 5992425.1 | 2104390.5 | 37.7578196641788 | -122.469237930006 | (37.7578196641788, -122.469237930006) | ||
| 81369 | 81369 | 48567 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 482 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45986 | 5994053.29361641 | 2089800.73897296 | 37.7178537586229 | -122.462548722634 | (37.7178537586229, -122.462548722634) | ||
| 81381 | 81381 | 87021 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 220 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49952 | 6004869.0 | 2103995.0 | 37.75744492838471 | -122.42617355859801 | (37.7574449283847, -122.426173558598) | ||
| 81489 | 81489 | 73075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 212-214 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2010 12:00:00 AM | 3x3 | Permit Number 53964 | 6005141.46475823 | 2099927.4876788002 | 37.7462918791242 | -122.424941880524 | (37.7462918791242, -122.424941880524) | ||
| 81508 | 81508 | 88416 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 5 | 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) | ||
| 81517 | 81517 | 51461 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 183 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47776 | 6008135.26284138 | 2097779.77752109 | 37.7405633944217 | -122.41443770987699 | (37.7405633944217, -122.414437709877) | ||
| 81535 | 81535 | 68227 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Irving St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32021 | 5993616.93785931 | 2106672.28749806 | 37.764153656105 | -122.465281833175 | (37.764153656105, -122.465281833175) | ||
| 81577 | 81577 | 98458 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 3 | 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) | ||
| 81641 | 81641 | 89366 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340 Benton Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2008 12:00:00 AM | 3x3 | Permit Number 51946 | 6006673.6 | 2095420.1 | 37.7340020224619 | -122.419324232824 | (37.7340020224619, -122.419324232824) | |||
| 81645 | 81645 | 104364 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Stillman St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013954.4 | 2112927.1 | 37.782479818597395 | -122.39537811084 | (37.7824798185974, -122.39537811084) | ||||
| 81667 | 81667 | 44392 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X ATHENS ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2001 12:00:00 AM | Permit Number 43750 | 6001492.0 | 2087581.0 | 37.7121844315022 | -122.436677650137 | (37.7121844315022, -122.436677650137) | |||
| 81799 | 81799 | 104075 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 340X Juanita Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2x3 | 5995047.73702 | 2097534.72021 | 37.7391466176195 | -122.45967126156602 | (37.7391466176195, -122.459671261566) | |||
| 81895 | 81895 | 50838 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 202 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2012 12:00:00 AM | Permit Number 769141 | 5994277.69303186 | 2105335.48637483 | 37.7605212305047 | -122.462899497742 | (37.7605212305047, -122.462899497742) | |||
| 81992 | 81992 | 91135 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 480 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2009 12:00:00 AM | 3x3 | Permit Number 52024 | 6005604.0 | 2107874.4 | 37.768138360101204 | -122.423907486341 | (37.7681383601012, -122.423907486341) | ||
| 82487 | 82487 | 104995 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2220 Castro St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/2013 12:00:00 AM | 3X3 | Permit Number 771144 | 6002644.3 | 2099031.5 | 37.7436903366208 | -122.433512747881 | (37.7436903366208, -122.433512747881) | |||
| 82632 | 82632 | 95924 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 528 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767621 | 5989176.7 | 2111724.7 | 37.7777691275223 | -122.48100911356899 | (37.7777691275223, -122.481009113569) | |
| 83069 | 83069 | 47033 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 22 Waller St | 4 | 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) | ||
| 83350 | 83350 | 87229 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2575X Judah St | 5 | 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) | ||
| 83580 | 83580 | 92310 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2591 26th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3x3 | 5988279.0 | 2097698.2 | 37.7392039339278 | -122.48308618722099 | (37.7392039339278, -122.483086187221) | ||
| 83669 | 83669 | 71675 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 42 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/1995 12:00:00 AM | 3x3 | Permit Number 53154 | 5993159.72787163 | 2098850.29163097 | 37.742650095600204 | -122.46629467245 | (37.7426500956002, -122.46629467245) | ||
| 83718 | 83718 | 55747 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 220 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/16/2014 12:00:00 AM | Permit Number 773163 | 6008245.8646592 | 2097574.24301154 | 37.7400052545437 | -122.41404075354099 | (37.7400052545437, -122.414040753541) | ||
| 83745 | 83745 | 96156 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 379 Highland Ave | 2 | 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) | |
| 83828 | 83828 | 47387 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 267 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45303 | 5996211.43551686 | 2091650.78184942 | 37.7230575891461 | -122.45522264671601 | (37.7230575891461, -122.455222646716) | |||
| 83891 | 83891 | 36249 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 134 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1978 12:00:00 AM | Permit Number 39267 | 6002197.13789926 | 2096205.20394281 | 37.735904603360794 | -122.43485684800899 | (37.7359046033608, -122.434856848009) | |||
| 84033 | 84033 | 48563 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 53 Byxbee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45982 | 5991907.82184104 | 2088893.56567496 | 37.715239092234704 | -122.469898587444 | (37.7152390922347, -122.469898587444) | ||
| 84101 | 84101 | 96120 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 234 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093.0 | 2096944.0 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | |
| 84184 | 84184 | 57273 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2472 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52713 | 5991743.85511271 | 2098609.03350443 | 37.7419058666539 | -122.471172731297 | (37.7419058666539, -122.471172731297) | ||
| 84277 | 84277 | 47152 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 74 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45122 | 5993774.80015181 | 2093239.20333738 | 37.7272789074004 | -122.46376077487899 | (37.7272789074004, -122.463760774879) | ||
| 84340 | 84340 | 47009 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 463 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | Permit Number 45007 | 6003641.69340393 | 2109907.77842423 | 37.7736105432433 | -122.430840029306 | (37.7736105432433, -122.430840029306) | ||
| 84657 | 84657 | 95618 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2791 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767383 | 6008097.0 | 2106797.0 | 37.7653204974455 | -122.41520815513 | (37.7653204974455, -122.41520815513) | |
| 84725 | 84725 | 92305 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2001 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52751 | 5989074.6 | 2101678.0 | 37.750177685111495 | -122.48062665529699 | (37.7501776851115, -122.480626655297) | |
| 84751 | 84751 | 82096 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1363 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52338 | 6004802.97001971 | 2120513.88344233 | 37.802797975517294 | -122.42757877147899 | (37.8027979755173, -122.427578771479) | ||
| 84761 | 84761 | 91566 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Girard St | 1 | 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) | ||
| 84842 | 84842 | 64782 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 158 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53736 | 5999914.43925974 | 2109028.32439413 | 37.7709839002497 | -122.443669932593 | (37.7709839002497, -122.443669932593) | |
| 84903 | 84903 | 95588 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2153 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767378 | 6000457.0 | 2120611.0 | 37.802817854966 | -122.442624981194 | (37.802817854966, -122.442624981194) | |
| 84979 | 84979 | 47977 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2455 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45711 | 5992012.3429777 | 2098733.73104635 | 37.7422637805034 | -122.47025347441999 | (37.7422637805034, -122.47025347442) | ||
| 85190 | 85190 | 94875 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 44 Ledyard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53944 | 6011618.0 | 2095077.0 | 37.7333371742049 | -122.40220570440799 | (37.7333371742049, -122.402205704408) | ||
| 85208 | 85208 | 92533 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 349 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/2009 12:00:00 AM | 3x3 | Permit Number 52878 | 6000209.0 | 2110074.0 | 37.7738718573556 | -122.44272613757099 | (37.7738718573556, -122.442726137571) | ||
| 85362 | 85362 | 87022 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 569 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49956 | 5985016.5 | 2111999.9 | 37.7782820363511 | -122.49542076869 | (37.7782820363511, -122.49542076869) | ||
| 85694 | 85694 | 62011 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3023 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2009 12:00:00 AM | 3x3 | Permit Number 52648 | 6009281.09498335 | 2104489.36080538 | 37.759050721712 | -122.410949629734 | (37.759050721712, -122.410949629734) | ||
| 85956 | 85956 | 112887 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2015 12:00:00 AM | Permit Number 774322 | 5993235.7 | 2110443.8 | 37.7744872348519 | -122.46687460915399 | (37.7744872348519, -122.466874609154) | |||
| 86371 | 86371 | 67729 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1475 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2014 12:00:00 AM | 3x3 | Permit Number 771981 | 5991458.91301226 | 2105384.63302746 | 37.760493412232 | -122.472651855625 | (37.760493412232, -122.472651855625) | |
| 86418 | 86418 | 96362 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1432 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2011 12:00:00 AM | Permit Number 767816 | 5989066.4 | 2105558.5 | 37.760832022681896 | -122.480939093689 | (37.7608320226819, -122.480939093689) | ||||
| 86434 | 86434 | 108081 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 626 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010239.318530001 | 2105432.7215400003 | 37.761694663220894 | -122.40770213976101 | (37.7616946632209, -122.407702139761) | |||||
| 86566 | 86566 | 82374 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 758 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52210 | 6010116.01173649 | 2104758.25368083 | 37.759835823401204 | -122.408081042327 | (37.7598358234012, -122.408081042327) | ||
| 86567 | 86567 | 97558 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 324 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2011 12:00:00 AM | Permit Number 768235 | 5991924.2 | 2097789.3 | 37.7396655169148 | -122.470489475237 | (37.7396655169148, -122.470489475237) | |||
| 86778 | 86778 | 82919 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 863 Meade Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52463 | 6013030.57044013 | 2089280.70970627 | 37.717500484481704 | -122.396915777424 | (37.7175004844817, -122.396915777424) | ||
| 86942 | 86942 | 95442 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2536 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/03/2011 12:00:00 AM | 3x3 | Permit Number 767304 | 5986467.3 | 2097980.9 | 37.7398745611118 | -122.489370926882 | (37.7398745611118, -122.489370926882) | |
| 86970 | 86970 | 52174 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1X Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2005 12:00:00 AM | Permit Number 48366 | 6005910.85537193 | 2107243.06588365 | 37.766422185477 | -122.422801230733 | (37.766422185477, -122.422801230733) | |||
| 87051 | 87051 | 95735 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767482 | 6002113.5 | 2089738.7 | 37.7181442990561 | -122.43468376004999 | (37.7181442990561, -122.43468376005) | |
| 87118 | 87118 | 92493 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1942 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52863 | 5986947.0 | 2097598.0 | 37.7388512102115 | -122.48768422414699 | (37.7388512102115, -122.487684224147) |
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");