Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11150 | 11150 | 28262 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3624 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 12 | 3x3 | 6012194.4874599995 | 2088681.14992 | 37.715807638979705 | -122.399763675165 | (37.7158076389797, -122.399763675165) | ||
| 23228 | 23228 | 28259 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3562 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2004 12:00:00 AM | 10 | 3x3 | 6012127.60331 | 2089140.68412 | 37.717065698801 | -122.400027111788 | (37.717065698801, -122.400027111788) | ||
| 18995 | 18995 | 19331 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/05/2000 12:00:00 AM | 6 | 3x3 | 5993203.76699 | 2089824.45321 | 37.7178699121392 | -122.465486857851 | (37.7178699121392, -122.465486857851) | ||
| 21015 | 21015 | 19321 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 120 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/2010 12:00:00 AM | 3 | 3X3 | 5993639.27417 | 2089852.22483 | 37.7179712747243 | -122.46398352863001 | (37.7179712747243, -122.46398352863) | ||
| 97015 | 97015 | 10703 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130X Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5993684.4832438 | 2089860.5757616002 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | |||
| 11481 | 11481 | 28255 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3476 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2003 12:00:00 AM | 6 | 3x3 | 6012058.005419999 | 2089554.66958 | 37.7181985388057 | -122.400296740219 | (37.7181985388057, -122.400296740219) | ||
| 114369 | 114369 | 28253 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3432 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 3 | 3X3 | 6012031.1541281 | 2089723.1062284 | 37.718659534499295 | -122.40040137877199 | (37.7186595344993, -122.400401378772) | ||
| 93800 | 93800 | 22521 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6600 03rd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/20/1992 12:00:00 AM | 3 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | ||
| 142091 | 142091 | 22527 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6600 03rd St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | |||
| 12903 | 12903 | 28302 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6012014.9954 | 2089805.7813099998 | 37.7188856424495 | -122.40046303743799 | (37.7188856424495, -122.400463037438) | |||
| 12009 | 12009 | 28254 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 8 | 3X3 | 6012011.64722 | 2089824.91922 | 37.7189380045612 | -122.400475954423 | (37.7189380045612, -122.400475954423) | ||
| 12793 | 12793 | 13368 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 900 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X50 | 6009218.46856 | 2090025.7710400003 | 37.719333336630896 | -122.410145089137 | (37.7193333366309, -122.410145089137) | |||
| 10377 | 10377 | 28246 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3326 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2002 12:00:00 AM | 3 | 2X3 | 6011947.80562 | 2090200.17318 | 37.7199648154144 | -122.400722979282 | (37.7199648154144, -122.400722979282) | ||
| 12568 | 12568 | 28244 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3260 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2003 12:00:00 AM | 12 | 2X3 | 6011894.92216 | 2090508.59301 | 37.7208087239121 | -122.40092743836 | (37.7208087239121, -122.40092743836) | ||
| 12039 | 12039 | 28243 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3230 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2004 12:00:00 AM | 8 | 2X3 | 6011870.75873 | 2090643.72462 | 37.7211784199346 | -122.401020454343 | (37.7211784199346, -122.401020454343) | ||
| 12282 | 12282 | 17504 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002139.261969999 | 2091310.46109 | 37.7224614665061 | -122.43470704369 | (37.7224614665061, -122.43470704369) | |||
| 11924 | 11924 | 27095 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 711 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006067.91108 | 2093593.9714799998 | 37.7289537443201 | -122.421288656069 | (37.7289537443201, -122.421288656069) | |||
| 11602 | 11602 | 27093 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 711 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006091.0826900005 | 2093593.66537 | 37.7289542101608 | -122.421208528251 | (37.7289542101608, -122.421208528251) | |||
| 78561 | 78561 | 14625 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 15 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 12 | 3X4 | 6017974.7726653 | 2094204.2737729999 | 37.7312936151853 | -122.380167719121 | (37.7312936151853, -122.380167719121) | ||
| 102400 | 102400 | 6398 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4X Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/1998 12:00:00 AM | 12 | 3X3 | 6018041.9202743 | 2094226.9871977002 | 37.7313596862419 | -122.379937152762 | (37.7313596862419, -122.379937152762) | ||
| 88204 | 88204 | 14623 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837711999 | 37.7313920698281 | -122.38002451510201 | (37.7313920698281, -122.380024515102) | ||
| 145234 | 145234 | 14624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018000.3078284 | 2094247.4364445 | 37.7314135402286 | -122.38008243669701 | (37.7314135402286, -122.380082436697) | ||
| 97122 | 97122 | 16435 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1299X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 6016431.7799349995 | 2094795.0104810002 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | ||
| 101983 | 101983 | 16450 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1395 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
| 107698 | 107698 | 16451 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1395 Newcomb Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/2009 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
| 19447 | 19447 | 2552 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 59 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1999 12:00:00 AM | 25 | 3X3 | 6001211.45267 | 2095788.41504 | 37.7347041848314 | -122.43823489701799 | (37.7347041848314, -122.438234897018) | ||
| 126105 | 126105 | 86220 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2663 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988937.695499 | 2097215.793619 | 37.7379176798007 | -122.480773433176 | (37.7379176798007, -122.480773433176) | ||
| 124769 | 124769 | 86219 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2643 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988933.146151001 | 2097346.5203529997 | 37.7382763570454 | -122.48079873027201 | (37.7382763570454, -122.480798730272) | ||
| 11292 | 11292 | 86217 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2621 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2013 12:00:00 AM | 3 | 3x3 | 5988925.7787 | 2097455.0086 | 37.7385738093546 | -122.48083214346799 | (37.7385738093546, -122.480832143468) | ||
| 120189 | 120189 | 86101 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2600X 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988963.56832 | 2097622.4377 | 37.7390357226089 | -122.48071374038 | (37.7390357226089, -122.48071374038) | ||
| 143250 | 143250 | 86436 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2574 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.00444 | 2097787.2202669997 | 37.7394336348182 | -122.48396744726001 | (37.7394336348182, -122.48396744726) | ||
| 20569 | 20569 | 26702 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 140 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1998 12:00:00 AM | 30 | 3X3 | 6006456.60108 | 2097572.163 | 37.739898885722 | -122.42022715296899 | (37.739898885722, -122.420227152969) | ||
| 88119 | 88119 | 86581 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2547 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987979.82634 | 2097967.749244 | 37.7399266315394 | -122.48414034443701 | (37.7399266315394, -122.484140344437) | ||
| 100006 | 100006 | 86109 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2548 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988950.841471 | 2097988.149582 | 37.7400391325334 | -122.480784510326 | (37.7400391325334, -122.480784510326) | ||
| 106625 | 106625 | 86214 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2491 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2015 04:31:00 PM | 3 | 3x3 | 5988896.775501 | 2098391.645558 | 37.7411438845393 | -122.48100098197399 | (37.7411438845393, -122.481000981974) | ||
| 145745 | 145745 | 86213 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2487 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988895.867106 | 2098417.748537 | 37.74121550369679 | -122.481006033613 | (37.7412155036968, -122.481006033613) | ||
| 97679 | 97679 | 86443 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2450 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.37774 | 2098622.10748 | 37.741724349066 | -122.484127634313 | (37.741724349066, -122.484127634313) | |
| 95889 | 95889 | 9346 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1999 12:00:00 AM | 20 | 2X2 | 6000803.9441694 | 2098478.3891844 | 37.742067037249 | -122.43983659070601 | (37.742067037249, -122.439836590706) | ||
| 21630 | 21630 | 26477 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 112 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2001 12:00:00 AM | 8 | 3x3 | 6001287.0278199995 | 2098748.5722 | 37.742836382684295 | -122.438185594392 | (37.7428363826843, -122.438185594392) | ||
| 88699 | 88699 | 86200 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988870.37374 | 2099150.307919 | 37.743225438056605 | -122.481147807758 | (37.7432254380566, -122.481147807758) | ||
| 21590 | 21590 | 22829 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999388.64339 | 2099036.75019 | 37.743519498737896 | -122.44477036118299 | (37.7435194987379, -122.444770361183) | |||
| 79774 | 79774 | 84648 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301X 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/21/2006 12:00:00 AM | 10 | 3x3 | 6004302.0 | 2098976.0 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | ||
| 82005 | 82005 | 52014 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 301X 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2005 12:00:00 AM | 9 | 3x3 | Permit Number 48233 | 6004302.0 | 2098976.0 | 37.7436318598049 | -122.427776865938 | (37.7436318598049, -122.427776865938) | |
| 166035 | 166035 | 214700 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200x Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5994642.56982 | 2099211.09063 | 37.7437262061113 | -122.461193618499 | (37.7437262061113, -122.461193618499) | |||
| 110120 | 110120 | 101655 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200X Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994672.4771300005 | 2099264.801 | 37.7438754024487 | -122.461094099214 | (37.7438754024487, -122.461094099214) | |||
| 108715 | 108715 | 26900 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 Amber Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/1999 12:00:00 AM | 30 | 3X3 | 5999908.8159045 | 2099289.8400101 | 37.7442440939699 | -122.44298991141001 | (37.7442440939699, -122.44298991141) | ||
| 19906 | 19906 | 1353 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999905.46078 | 2099295.02318 | 37.7442581344216 | -122.44300188482401 | (37.7442581344216, -122.443001884824) | |||
| 140305 | 140305 | 86249 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2266 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988574.227066 | 2099899.242089 | 37.7452645932744 | -122.482226651217 | (37.7452645932744, -122.482226651217) | ||
| 81410 | 81410 | 85988 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2258 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987642.054438 | 2099919.450203 | 37.7452658143921 | -122.48545138958299 | (37.7452658143921, -122.485451389583) | ||
| 138413 | 138413 | 86332 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2263 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988533.319976 | 2099923.8448349996 | 37.745329766428 | -122.482369901671 | (37.745329766428, -122.482369901671) | ||
| 107372 | 107372 | 86078 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2253 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987600.724922 | 2099957.1059939996 | 37.7453667992034 | -122.485597061296 | (37.7453667992034, -122.485597061296) | ||
| 138906 | 138906 | 86075 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2241 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987598.017854 | 2100035.189447 | 37.7455810378659 | -122.48561215120199 | (37.7455810378659, -122.485612151202) | ||
| 112294 | 112294 | 86074 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2237 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987597.115499 | 2100061.217249 | 37.74565245070821 | -122.48561718118499 | (37.7456524507082, -122.485617181185) | ||
| 125543 | 125543 | 86250 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2242 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988568.6306529995 | 2100055.451314 | 37.7456931770541 | -122.48225744501998 | (37.7456931770541, -122.48225744502) | ||
| 81351 | 81351 | 85991 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2222 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987633.933236 | 2100153.700526 | 37.7459085303186 | -122.48549665823 | (37.7459085303186, -122.48549665823) | ||
| 24090 | 24090 | 238060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Montezuma St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6007260.48935 | 2099759.47356 | 37.7459500163869 | -122.417602623671 | (37.7459500163869, -122.417602623671) | |||
| 17328 | 17328 | 1375 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 57 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/1999 12:00:00 AM | 3 | 1X1 | 5998969.3690599995 | 2100010.78272 | 37.7461700211271 | -122.446290155185 | (37.7461700211271, -122.446290155185) | ||
| 21078 | 21078 | 1362 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 17 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1X1 | 5999159.03773 | 2100010.23642 | 37.7461793516141 | -122.445634267927 | (37.7461793516141, -122.445634267927) | |||
| 20735 | 20735 | 1373 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 49 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/24/1999 12:00:00 AM | 3 | 1X1 | 5999002.70945 | 2100014.0540299998 | 37.7461809074259 | -122.446175104021 | (37.7461809074259, -122.446175104021) | ||
| 20923 | 20923 | 1370 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999037.99816 | 2100015.3023099997 | 37.7461863501203 | -122.446053170314 | (37.7461863501203, -122.446053170314) | |||
| 37982 | 37982 | 237111 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Coso Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6007125.29232 | 2099860.06971 | 37.7462186223039 | -122.418077248072 | (37.7462186223039, -122.418077248072) | ||||
| 17135 | 17135 | 4290 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4319 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001811.82225 | 2100290.20269 | 37.7470991700926 | -122.43648132156099 | (37.7470991700926, -122.436481321561) | ||
| 22002 | 22002 | 4306 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4390 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001409.31695 | 2100304.12131 | 37.747114507137205 | -122.437874145675 | (37.7471145071372, -122.437874145675) | ||
| 19895 | 19895 | 4295 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4342 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2003 12:00:00 AM | 3 | 3X3 | 6001671.89746 | 2100317.83526 | 37.7471670905043 | -122.436967147015 | (37.7471670905043, -122.436967147015) | ||
| 21277 | 21277 | 4291 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4324 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001780.20994 | 2100324.37087 | 37.7471911914402 | -122.43659307941999 | (37.7471911914402, -122.43659307942) | ||
| 21715 | 21715 | 4289 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4318 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001802.38664 | 2100324.70976 | 37.747193382168604 | -122.43651641850799 | (37.7471933821686, -122.436516418508) | ||
| 20787 | 20787 | 4288 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4314 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001830.459 | 2100325.99082 | 37.7471984948291 | -122.436419438314 | (37.7471984948291, -122.436419438314) | ||
| 20836 | 20836 | 4276 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4221 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1995 12:00:00 AM | 3 | 3x3 | 6002451.40883 | 2100314.3802 | 37.7472018789671 | -122.434271414787 | (37.7472018789671, -122.434271414787) | ||
| 17823 | 17823 | 24441 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4162 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1995 12:00:00 AM | 3 | 3X3 | 6002908.04263 | 2100385.0344599998 | 37.747421786581995 | -122.432697458221 | (37.747421786582, -122.432697458221) | ||
| 19154 | 19154 | 4234 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4013X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/1995 12:00:00 AM | 3 | 3x3 | 6003806.79862 | 2100387.84018 | 37.7474804205949 | -122.429589821227 | (37.7474804205949, -122.429589821227) | ||
| 18600 | 18600 | 4218 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3955 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1998 12:00:00 AM | 3 | 3X3 | 6004198.47443 | 2100405.87482 | 37.747552109146206 | -122.42823671656099 | (37.7475521091462, -122.428236716561) | ||
| 87057 | 87057 | 4219 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3957 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004180.2435918 | 2100406.5432146 | 37.7475529128468 | -122.428299805317 | (37.7475529128468, -122.428299805317) | ||
| 17528 | 17528 | 4246 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4038 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/1995 12:00:00 AM | 3 | 3X3 | 6003621.03642 | 2100422.76167 | 37.747565786929 | -122.43023466569599 | (37.747565786929, -122.430234665696) | ||
| 92706 | 92706 | 4122 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3435 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6006760.09222 | 2100373.98133 | 37.7476091457032 | -122.419376518884 | (37.7476091457032, -122.419376518884) | ||
| 95273 | 95273 | 4120 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3435 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6006760.09222 | 2100373.98133 | 37.7476091457032 | -122.419376518884 | (37.7476091457032, -122.419376518884) | ||
| 139120 | 139120 | 4124 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3435 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6006760.09222 | 2100373.98133 | 37.7476091457032 | -122.419376518884 | (37.7476091457032, -122.419376518884) | ||
| 113062 | 113062 | 4198 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3885X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 6 | 3X3 | 6004619.1213 | 2100435.76727 | 37.7476579790206 | -122.42678427332199 | (37.7476579790206, -122.426784273322) | ||
| 77667 | 77667 | 4142 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3615-3623X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | ||
| 85319 | 85319 | 4145 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3615-3623X Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | ||
| 101626 | 101626 | 4147 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3555X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | ||
| 106070 | 106070 | 4144 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3615-3623X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | ||
| 117365 | 117365 | 4143 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3615-3623X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | ||
| 129347 | 129347 | 4146 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3615-3623X Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | ||
| 21356 | 21356 | 4210 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3932 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2004 12:00:00 AM | 3 | 3X3 | 6004303.84786 | 2100460.14425 | 37.7477070821197 | -122.427876208032 | (37.7477070821197, -122.427876208032) | ||
| 17098 | 17098 | 4184 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3835 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 12 | 3X3 | 6004944.66483 | 2100451.1135299997 | 37.7477185170056 | -122.425659653475 | (37.7477185170056, -122.425659653475) | ||
| 17744 | 17744 | 4206 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3920 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/1995 12:00:00 AM | 3 | 3X3 | 6004377.17948 | 2100465.22503 | 37.7477251809744 | -122.427622993127 | (37.7477251809744, -122.427622993127) | ||
| 19308 | 19308 | 4173 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3807X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1995 12:00:00 AM | 6 | 3X3 | 6005111.29038 | 2100461.84082 | 37.7477573856943 | -122.42508423394301 | (37.7477573856943, -122.425084233943) | ||
| 22029 | 22029 | 25409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3763-3767 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 6 | 3x3 | 6005453.81691 | 2100480.39517 | 37.7478276749239 | -122.42390111285 | (37.7478276749239, -122.42390111285) | ||
| 23069 | 23069 | 4182 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3830 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6004950.59619 | 2100495.54046 | 37.747840838281796 | -122.42564230465 | (37.7478408382818, -122.42564230465) | |||
| 17088 | 17088 | 4158 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3739-3737 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/1989 12:00:00 AM | 12 | 3X3 | 6005577.7811900005 | 2100485.8259400004 | 37.74784958418571 | -122.423472835916 | (37.7478495841857, -122.423472835916) | ||
| 101052 | 101052 | 4160 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3739 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2003 12:00:00 AM | 3 | 4X4 | 6005605.475964599 | 2100485.3064168 | 37.7478497208127 | -122.42337703166099 | (37.7478497208127, -122.423377031661) | ||
| 107942 | 107942 | 4178 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3814 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/19/2016 05:09:00 AM | 3 | 3X3 | 6005093.430499299 | 2100505.6463058 | 37.747876656567605 | -122.42514910902901 | (37.7478766565676, -122.425149109029) | ||
| 77375 | 77375 | 86070 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2115 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987568.946045 | 2100884.101082 | 37.7479102288924 | -122.485774970523 | (37.7479102288924, -122.485774970523) | ||
| 141034 | 141034 | 4148 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3631 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3X3 | She would like to be kept in the loop on what happens with this. | 6006082.4281665 | 2100506.5376626 | 37.7479349243864 | -122.421729258843 | (37.7479349243864, -122.421729258843) | |
| 109978 | 109978 | 4156 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3728 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1997 12:00:00 AM | 12 | 3X3 | 6005666.336308599 | 2100538.647271 | 37.747999617329796 | -122.423170370206 | (37.7479996173298, -122.423170370206) | ||
| 20828 | 20828 | 4100 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3321 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/2000 12:00:00 AM | 3 | 3x3 | 6007597.59872 | 2100526.27366 | 37.748074440783796 | -122.416491248692 | (37.7480744407838, -122.416491248692) | ||
| 119100 | 119100 | 4093 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3265 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6007971.46841 | 2100526.65506 | 37.7480965064251 | -122.415198444297 | (37.7480965064251, -122.415198444297) | ||
| 17463 | 17463 | 4063 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3053 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/1995 12:00:00 AM | 3 | 3X3 | 6009245.443659999 | 2100538.36575 | 37.7482001758998 | -122.410793893342 | (37.7482001758998, -122.410793893342) | ||
| 20594 | 20594 | 4060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3017 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 3 | 3X3 | 6009461.72254 | 2100536.5932400003 | 37.7482074334345 | -122.410045879537 | (37.7482074334345, -122.410045879537) | ||
| 17532 | 17532 | 24463 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3550 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/1995 12:00:00 AM | 3 | 3x3 | 6006349.89396 | 2100605.1669900003 | 37.7482208171583 | -122.420811373242 | (37.7482208171583, -122.420811373242) |
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");