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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13821 | 13821 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600X Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.8363700002 | 37.735069048787 | -122.39100428831499 | (37.735069048787, -122.391004288315) | |||
| 129364 | 129364 | 8097 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 762 Fulton St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12/04/2010 12:00:00 AM | 3 | 3X3 | 6004143.8911021 | 2111521.3201229 | 37.7780693729621 | -122.42921792780001 | (37.7780693729621, -122.4292179278) | ||
| 57041 | 57041 | 98796 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950@Washington Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 03/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768771 | 6010177.18626 | 2117200.01626 | 37.7940014192822 | -122.40874722700701 | (37.7940014192822, -122.408747227007) | |
| 101061 | 101061 | 113808 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4101x 25TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 5 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
| 105585 | 105585 | 113819 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4101x 25TH ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 7 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | ||
| 83650 | 83650 | 4016 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/27/2000 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.38278818869301 | (37.7506230149756, -122.382788188693) | ||
| 119175 | 119175 | 108830 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | FUF 1 | 3x3 | 6003763.1265 | 2093992.4287599998 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | ||||
| 80326 | 80326 | 91975 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1320X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993343.893066 | 2106486.203602 | 37.763626968645504 | -122.46621268437 | (37.7636269686455, -122.46621268437) | ||
| 117803 | 117803 | 91976 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1320X 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993343.893066 | 2106486.203602 | 37.763626968645504 | -122.46621268437 | (37.7636269686455, -122.46621268437) | ||
| 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) | ||||
| 101459 | 101459 | 98790 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950x CLAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | Permit Number 768771 | 6010160.0 | 2117472.0 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | ||
| 103824 | 103824 | 94947 | 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) | ||||
| 114698 | 114698 | 94946 | 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) | ||||
| 119959 | 119959 | 100985 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257168998 | (37.8045319114054, -122.41088257169) | |
| 120907 | 120907 | 78998 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450X Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 6 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 32170 | 32170 | 111793 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 55X Sherman St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6010868.84129 | 2110834.34163 | 37.7765614981606 | -122.405905386452 | (37.7765614981606, -122.405905386452) | |||
| 38128 | 38128 | 88409 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | |
| 44141 | 44141 | 88407 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | |
| 66520 | 66520 | 100031 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | |
| 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) | ||||
| 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) | |||
| 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) | ||||
| 112616 | 112616 | 100037 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 5 | 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) | |||
| 116126 | 116126 | 100035 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 3 | 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) | |||
| 120980 | 120980 | 100033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 1 | 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) | |||
| 124487 | 124487 | 100032 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411.0 | 2117399.5 | 37.794506209154704 | -122.411412418869 | (37.7945062091547, -122.411412418869) | ||
| 144094 | 144094 | 100036 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199@Washington Mason St | 4 | 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) | |||
| 145655 | 145655 | 8486 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1900X Geary Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6002632.592264799 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | ||
| 182553 | 182553 | 88408 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.794287243625604 | -122.411401815264 | (37.7942872436256, -122.411401815264) | |
| 131 | 131 | 237033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 7 | : 4 | Tree 1 | DPW 2 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | |||
| 135 | 135 | 237030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.773250861665204 | -122.423617927146 | (37.7732508616652, -122.423617927146) | |||
| 1311 | 1311 | 237352 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3186 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 4x4 | 6008549.69387 | 2100618.49329 | 37.7483811527756 | -122.413205447889 | (37.7483811527756, -122.413205447889) | |||
| 2141 | 2141 | 18982 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2920 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000616.67404 | 2115546.70514 | 37.7889217363036 | -122.44170876675699 | (37.7889217363036, -122.441708766757) | |||
| 4125 | 4125 | 135979 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006900.63841 | 2115164.21663 | 37.788227554109504 | -122.419939904112 | (37.7882275541095, -122.419939904112) | ||
| 4128 | 4128 | 135978 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 99 Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 4 | Width 4ft | 6006877.42 | 2115159.3392 | 37.788212853775896 | -122.420019889812 | (37.7882128537759, -122.420019889812) | ||
| 4328 | 4328 | 28085 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.786854268374796 | -122.43420010239201 | (37.7868542683748, -122.434200102392) | |||
| 4329 | 4329 | 239457 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | |
| 4404 | 4404 | 239458 | Planning Code 138.1 required 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 165 Sussex St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001977.4736 | 2096494.97635 | 37.7366877772239 | -122.435637038029 | (37.7366877772239, -122.435637038029) | |
| 4797 | 4797 | 214559 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1342 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | Width 3ft | 5991532.56497 | 2106606.32246 | 37.7638521099028 | -122.472486197695 | (37.7638521099028, -122.472486197695) | ||
| 4821 | 4821 | 214558 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1340 Irving St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 4 | Width 3ft | 5991564.93185 | 2106609.34919 | 37.7638622938456 | -122.472374472204 | (37.7638622938456, -122.472374472204) | ||
| 5494 | 5494 | 87738 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | ||
| 6617 | 6617 | 103761 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 106X Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.575019999 | 2115508.13748 | 37.7891597571573 | -122.42070841348101 | (37.7891597571573, -122.420708413481) | ||
| 7138 | 7138 | 29119 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 509 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6008381.9659 | 2113792.89597 | 37.7845455839642 | -122.414717657915 | (37.7845455839642, -122.414717657915) | ||
| 7662 | 7662 | 88451 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/07/2008 12:00:00 AM | 3 | 5x12 | 6005480.84439 | 2121378.35155 | 37.805209901088396 | -122.425294529632 | (37.8052099010884, -122.425294529632) | ||
| 7952 | 7952 | 17354 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005542.87933 | 2117567.08542 | 37.7947486417029 | -122.424808539584 | (37.7947486417029, -122.424808539584) | |||
| 8626 | 8626 | 87739 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3200X Van Ness Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005433.618530001 | 2121623.41722 | 37.8058801199389 | -122.42547541206699 | (37.8058801199389, -122.425475412067) | ||
| 8858 | 8858 | 21651 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1689 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/31/2013 12:00:00 AM | 3 | 4X4 | 6004532.1578 | 2114645.7829 | 37.7866703442988 | -122.428097491401 | (37.7866703442988, -122.428097491401) | ||
| 8875 | 8875 | 2624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1822 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004615.6699 | 2115060.0567 | 37.7878125608959 | -122.427838089219 | (37.7878125608959, -122.427838089219) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 13686 | 13686 | 27731 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015524.1696 | 2101161.19501 | 37.7502603851148 | -122.38912554882 | (37.7502603851148, -122.38912554882) | ||
| 13815 | 13815 | 27724 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015353.113480001 | 2101161.82636 | 37.750252634763996 | -122.389717121075 | (37.750252634764, -122.389717121075) | ||
| 14286 | 14286 | 27729 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015622.7491 | 2101166.85438 | 37.75028138877779 | -122.38878504659999 | (37.7502813887778, -122.3887850466) | ||
| 15485 | 15485 | 111661 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1398x Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/25/2015 01:32:00 PM | 3 | 3x3 | 6011721.86925 | 2101900.7924099998 | 37.7520796461774 | -122.402326221379 | (37.7520796461774, -122.402326221379) | ||
| 15791 | 15791 | 27728 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200 Cesar Chavez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015202.17288 | 2101166.08495 | 37.750255956855 | -122.390239385253 | (37.750255956855, -122.390239385253) | ||
| 16042 | 16042 | 4051 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2550 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6011835.74556 | 2100958.0718 | 37.749497496525 | -122.401866156092 | (37.749497496525, -122.401866156092) | ||
| 16131 | 16131 | 4050 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2550 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6011878.426080001 | 2100960.1838700003 | 37.7495056776496 | -122.40171871317101 | (37.7495056776496, -122.401718713171) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 17633 | 17633 | 23053 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1074 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/16/1992 12:00:00 AM | 18 | 3X3 | 6006318.63458 | 2103360.59062 | 37.7557848161263 | -122.421115089604 | (37.7557848161263, -122.421115089604) | ||
| 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) | ||
| 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) | ||
| 18070 | 18070 | 4052 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 3X3 | 6010072.48365 | 2100637.4543 | 37.7485185889697 | -122.407940988391 | (37.7485185889697, -122.407940988391) | ||
| 18298 | 18298 | 10022 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/2003 12:00:00 AM | 3 | 2x2 | 6005445.78054 | 2107378.48496 | 37.766767762334794 | -122.42441947400499 | (37.7667677623348, -122.424419474005) | ||
| 18418 | 18418 | 27508 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1325 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 12 | 3X3 | 6005854.22427 | 2101278.43596 | 37.750041509014004 | -122.42257322160299 | (37.750041509014, -122.422573221603) | ||
| 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) | ||
| 18694 | 18694 | 10178 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1086 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/2001 12:00:00 AM | 16 | 2X2 | 6005705.19862 | 2102704.3683 | 37.7539483816144 | -122.423189907382 | (37.7539483816144, -122.423189907382) | ||
| 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) | ||
| 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) | ||
| 19279 | 19279 | 91934 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1115 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992339.241228 | 2106582.494136 | 37.7638333412086 | -122.46969443927 | (37.7638333412086, -122.46969443927) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 20572 | 20572 | 27519 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1212 Guerrero St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2000 12:00:00 AM | 8 | 3X3 | 6005760.41969 | 2101697.87743 | 37.751187906306896 | -122.42292741057 | (37.7511879063069, -122.42292741057) | ||
| 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) | ||
| 20721 | 20721 | 10215 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1335 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/24/2000 12:00:00 AM | 6 | 3X3 | 6005858.33864 | 2101181.45988 | 37.749775467064 | -122.42255210370199 | (37.749775467064, -122.422552103702) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 20906 | 20906 | 89402 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1914 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992725.997880001 | 2112086.29643 | 37.7789676550624 | -122.468757294436 | (37.7789676550624, -122.468757294436) | ||
| 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) | |||
| 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) |
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");