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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 99034 | 99034 | 106992 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2012 12:00:00 AM | 6004025.8 | 2114231.4 | 37.785503891427005 | -122.42981979958701 | (37.785503891427, -122.429819799587) | ||||
| 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) | ||
| 103508 | 103508 | 106991 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1701X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2014 12:00:00 AM | 6004025.8 | 2114231.4 | 37.785503891427005 | -122.42981979958701 | (37.785503891427, -122.429819799587) | ||||
| 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) | |||
| 158887 | 158887 | 121620 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300x Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 3x3 | 6011700.392659999 | 2102280.30315 | 37.7531205008135 | -122.402427173876 | (37.7531205008135, -122.402427173876) | |||
| 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) | ||||
| 87590 | 87590 | 91928 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 2 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 98111 | 98111 | 91929 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 2 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 22030 | 22030 | 4104 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3330 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3X3 | 6007482.20732 | 2100611.45835 | 37.7483018487579 | -122.416896303343 | (37.7483018487579, -122.416896303343) | ||
| 22114 | 22114 | 10208 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1286 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/1991 12:00:00 AM | 3 | 2X2 | 6005769.15445 | 2101526.21369 | 37.750717050048706 | -122.422885005752 | (37.7507170500487, -122.422885005752) | ||
| 22261 | 22261 | 4054 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2957 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/1999 12:00:00 AM | 3 | 3X3 | 6009770.62771 | 2100537.88813 | 37.7482282977114 | -122.40897778170799 | (37.7482282977114, -122.408977781708) | ||
| 22982 | 22982 | 106990 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1737-1795 Post St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2014 02:15:00 PM | 3 | 6003734.5 | 2114103.2 | 37.785135386369795 | -122.43081845921101 | (37.7851353863698, -122.430818459211) | |||
| 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) | |||
| 38785 | 38785 | 136006 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1237x Robert C Levy Tunl | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007669.82361 | 2118117.1353700003 | 37.7963788445653 | -122.417488005977 | (37.7963788445653, -122.417488005977) | ||||
| 51558 | 51558 | 91889 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1112 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5992343.82828 | 2106622.674723 | 37.7639439315835 | -122.46968149954701 | (37.7639439315835, -122.469681499547) | ||
| 53189 | 53189 | 91930 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1201X IRVING ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5992070.0 | 2106573.0 | 37.7637917074669 | -122.470624962715 | (37.7637917074669, -122.470624962715) | ||
| 54134 | 54134 | 91923 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1427 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991353.957672 | 2106548.744029 | 37.763683675450004 | -122.473099740894 | (37.76368367545, -122.473099740894) | ||
| 54621 | 54621 | 4034 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2150 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1995 12:00:00 AM | 3 | 3X3 | 6012617.955900401 | 2100994.1740901 | 37.749640248492604 | -122.39916376626199 | (37.7496402484926, -122.399163766262) | ||
| 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) | |
| 65800 | 65800 | 91919 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1445 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991297.838563 | 2106546.8216959997 | 37.7636751478808 | -122.47329369732799 | (37.7636751478808, -122.473293697328) | ||
| 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) | ||
| 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) | ||
| 77709 | 77709 | 91916 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1555 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5990949.753071 | 2106534.898314 | 37.763622247809295 | -122.47449673434299 | (37.7636222478093, -122.474496734343) | ||
| 79188 | 79188 | 103042 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | |||
| 79576 | 79576 | 89676 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2543 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990695.40247 | 2111954.91498 | 37.778489399756204 | -122.47577226813999 | (37.7784893997562, -122.47577226814) | ||
| 79666 | 79666 | 86376 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988009.291975 | 2106160.192246 | 37.7624226008214 | -122.484639253233 | (37.7624226008214, -122.484639253233) | ||
| 80455 | 80455 | 91941 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 925 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5992928.667696 | 2106602.6844200003 | 37.7639228286278 | -122.467657278128 | (37.7639228286278, -122.467657278128) | ||
| 80485 | 80485 | 23868 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1495X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/2011 12:00:00 AM | 3 | 3X3 | 6003590.023580001 | 2113875.44534 | 37.7845018426272 | -122.43130203900499 | (37.7845018426272, -122.431302039005) | ||
| 80522 | 80522 | 90634 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3040 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5986072.775219999 | 2110484.3905599997 | 37.774182669931996 | -122.49165518484101 | (37.774182669932, -122.491655184841) | ||
| 80642 | 80642 | 26729 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 80739 | 80739 | 86034 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1284 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987415.003943 | 2106546.656914 | 37.763449099217404 | -122.486723028948 | (37.7634490992174, -122.486723028948) | ||
| 81177 | 81177 | 91970 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1350 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993350.61101 | 2106290.929173 | 37.763091183898 | -122.466175257659 | (37.763091183898, -122.466175257659) | ||
| 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) | ||
| 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) | ||
| 81475 | 81475 | 91983 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1239 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993284.406043 | 2107051.954484 | 37.7651769393996 | -122.46645955171999 | (37.7651769393996, -122.46645955172) | ||
| 81586 | 81586 | 85943 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1538 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988095.160504 | 2104827.59989 | 37.7587686653948 | -122.484244534442 | (37.7587686653948, -122.484244534442) | ||
| 82772 | 82772 | 85934 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1630 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988116.725594 | 2104200.7569 | 37.7570487799795 | -122.484123984508 | (37.7570487799795, -122.484123984508) | ||
| 83265 | 83265 | 91984 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1243 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993285.31415 | 2107025.55813 | 37.7651045143653 | -122.466454492146 | (37.7651045143653, -122.466454492146) | ||
| 83935 | 83935 | 91902 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1516 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2008 12:00:00 AM | 3 | 3x3 | 5991061.448475 | 2106578.7477680002 | 37.7637491175921 | -122.474113618488 | (37.7637491175921, -122.474113618488) | ||
| 84020 | 84020 | 85942 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1542 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988096.057532 | 2104801.525596 | 37.758697124688894 | -122.48423951990299 | (37.7586971246889, -122.484239519903) | ||
| 84264 | 84264 | 91966 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1376 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5993356.433228 | 2106121.691358 | 37.76262683713129 | -122.466142821616 | (37.7626268371313, -122.466142821616) | ||
| 84503 | 84503 | 86007 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987522.322672 | 2103422.5340299997 | 37.7548773659795 | -122.48612250342899 | (37.7548773659795, -122.486122503429) | ||
| 84609 | 84609 | 91947 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 827 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993232.703908999 | 2106613.098951 | 37.7639689741056 | -122.466606473793 | (37.7639689741056, -122.466606473793) | ||
| 84650 | 84650 | 85958 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988039.866297 | 2106434.861495 | 37.7631785479619 | -122.48455365718 | (37.7631785479619, -122.48455365718) | ||
| 84697 | 84697 | 91953 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 701 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2014 12:00:00 AM | 3 | 3x3 | 5993618.512619 | 2106626.3144610003 | 37.7640275170127 | -122.465273046982 | (37.7640275170127, -122.465273046982) | ||
| 84875 | 84875 | 4071 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3148 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6008736.4549488 | 2100618.4445096003 | 37.748391502035204 | -122.41255962658701 | (37.7483915020352, -122.412559626587) | |||
| 84968 | 84968 | 86321 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1723 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988408.134093 | 2103583.601964 | 37.7553712008265 | -122.483070961912 | (37.7553712008265, -122.483070961912) | ||
| 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) | ||
| 85360 | 85360 | 91951 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 751 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993470.629208 | 2106621.248866 | 37.764005078882796 | -122.46578415986299 | (37.7640050788828, -122.465784159863) | ||
| 86154 | 86154 | 91926 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1401 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991435.018606 | 2106551.520732 | 37.7636959924857 | -122.472819581527 | (37.7636959924857, -122.472819581527) | ||
| 86457 | 86457 | 91921 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1437 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/2009 12:00:00 AM | 3 | 3x3 | 5991322.7803879995 | 2106547.676066 | 37.763678937950296 | -122.473207494478 | (37.7636789379503, -122.473207494478) | ||
| 86947 | 86947 | 91880 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 840 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2008 12:00:00 AM | 3 | 3x3 | 5993189.659614 | 2106651.6479599997 | 37.7640723354625 | -122.466758152363 | (37.7640723354625, -122.466758152363) | ||
| 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) | ||
| 87144 | 87144 | 91948 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 823 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2009 12:00:00 AM | 3 | 3x3 | 5993244.611031 | 2106613.506821 | 37.763970781134795 | -122.466565320592 | (37.7639707811348, -122.466565320592) |
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");