Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 71510 | 71510 | 77210 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 72481 | 72481 | 42343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 76344 | 76344 | 77198 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 3 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 86065 | 86065 | 42350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 90442 | 90442 | 42345 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 91332 | 91332 | 77217 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 92098 | 92098 | 42366 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 92789 | 92789 | 77219 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 93542 | 93542 | 42354 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 93801 | 93801 | 77212 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 94089 | 94089 | 42360 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 100102 | 100102 | 42349 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 100207 | 100207 | 77211 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 8 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 103741 | 103741 | 77204 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 6 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 105224 | 105224 | 42352 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 109486 | 109486 | 77207 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 111991 | 111991 | 42361 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 114618 | 114618 | 42365 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 114830 | 114830 | 96210 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 201X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/28/2012 12:00:00 AM | 3 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.43696480408701 | (37.759113460692, -122.436964804087) | |
| 120818 | 120818 | 42357 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 121322 | 121322 | 42347 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 121470 | 121470 | 42369 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 122117 | 122117 | 42367 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Foerster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 123050 | 123050 | 77206 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 123438 | 123438 | 42348 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 139199 | 139199 | 77209 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 499X Hearst Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/15/1999 12:00:00 AM | 5 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) | |
| 140146 | 140146 | 42356 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 3x3 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 144409 | 144409 | 42358 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380X Flood Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2000 12:00:00 AM | 5 | 4x4 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.730294369809705 | -122.44876785322901 | (37.7302943698097, -122.448767853229) |
| 8730 | 8730 | 97454 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.805910669901294 | -122.41950228141899 | (37.8059106699013, -122.419502281419) | |
| 10158 | 10158 | 44811 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2700x Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | Permit Number 43905 | 5986360.0 | 2105036.0 | 37.7592396918496 | -122.490260766294 | (37.7592396918496, -122.490260766294) | ||
| 11666 | 11666 | 108844 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 420 Woolsey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010500.63404 | 2091864.14228 | 37.724452908148606 | -122.405842528314 | (37.7244529081486, -122.405842528314) | |
| 12766 | 12766 | 31651 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3530 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/2016 12:00:00 AM | 3 | Permit Number 778640 | 5981977.0239 | 2096750.5895 | 37.736233320022 | -122.50480501648701 | (37.736233320022, -122.504805016487) | |
| 15178 | 15178 | 67715 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 472 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31328 | 6013692.95356 | 2112582.14451 | 37.781518105329795 | -122.39625842359399 | (37.7815181053298, -122.396258423594) |
| 17983 | 17983 | 35807 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.762580870322104 | -122.42044317973499 | (37.7625808703221, -122.420443179735) | ||
| 18393 | 18393 | 65663 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 28583 | 5998824.47448758 | 2095859.96140736 | 37.7347645844735 | -122.44649260756701 | (37.7347645844735, -122.446492607567) | ||
| 18895 | 18895 | 37776 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 449 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.72880870980371 | -122.409003606238 | (37.7288087098037, -122.409003606238) | ||
| 20395 | 20395 | 43502 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 401 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.73830646369329 | -122.413905114955 | (37.7383064636933, -122.413905114955) | ||
| 23971 | 23971 | 78224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6009704.84764 | 2090538.9392099997 | 37.7207696402774 | -122.40850003035101 | (37.7207696402774, -122.408500030351) | ||
| 24798 | 24798 | 45088 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1900 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 2 | Permit Number 43969 | 5988077.6041 | 2102404.3375 | 37.752114018434206 | -122.484127544226 | (37.7521140184342, -122.484127544226) | |
| 27024 | 27024 | 38346 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.50417542529499 | (37.7518433707941, -122.504175425295) | |
| 29473 | 29473 | 47215 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.4762699995 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | |
| 30025 | 30025 | 73382 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 502 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/1993 12:00:00 AM | 6 | 6001158.1468 | 2110520.1446 | 37.7751509205215 | -122.439474878934 | (37.7751509205215, -122.439474878934) | ||
| 30881 | 30881 | 79593 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2407 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2002 12:00:00 AM | 3 | 5988231.6107 | 2107115.9609 | 37.7650598247176 | -122.48394043153401 | (37.7650598247176, -122.483940431534) | ||
| 33255 | 33255 | 66536 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 555 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32084 | 6008859.29808 | 2093449.63302 | 37.7287144005277 | -122.41162839584999 | (37.7287144005277, -122.41162839585) | |
| 34509 | 34509 | 32604 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1327 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 6 | Permit Number 37070 | 5985214.1986 | 2106157.4162 | 37.7622518049359 | -122.49430610263501 | (37.7622518049359, -122.494306102635) | |
| 35753 | 35753 | 42874 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2366 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 5 | Permit Number 42798 | 5986118.9683 | 2099141.5396 | 37.7430410269224 | -122.49066066829901 | (37.7430410269224, -122.490660668299) | |
| 36235 | 36235 | 43548 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1857 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 4 | Permit Number 43212 | 6000253.363 | 2111274.4996 | 37.777170653454796 | -122.442658894423 | (37.7771706534548, -122.442658894423) | |
| 38289 | 38289 | 44471 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 133 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 7 | Permit Number 43785 | 6006112.385480001 | 2093200.59482 | 37.7278761253611 | -122.42110698399799 | (37.7278761253611, -122.421106983998) | |
| 41008 | 41008 | 72911 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1970 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | 5 | 6001491.2891 | 2115220.1537 | 37.7880749043224 | -122.438659315373 | (37.7880749043224, -122.438659315373) | ||
| 41049 | 41049 | 43165 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 243 Madison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 42974 | 6005684.86708 | 2092551.5835900002 | 37.7260699728301 | -122.42253882881201 | (37.7260699728301, -122.422538828812) | |
| 41651 | 41651 | 47841 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | Permit Number 45602 | 5981838.80851 | 2110330.1740900003 | 37.773510883288395 | -122.506289537608 | (37.7735108832884, -122.506289537608) | |
| 42310 | 42310 | 42884 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2514 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42805 | 5985844.8171 | 2098079.769 | 37.7401096713575 | -122.49153045761899 | (37.7401096713575, -122.491530457619) | |
| 43429 | 43429 | 31131 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34846 | 5997461.35333 | 2093947.48586 | 37.7294354301769 | -122.45106749418001 | (37.7294354301769, -122.45106749418) | |
| 44034 | 44034 | 38344 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1858 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 2 | Permit Number 40411 | 5982279.7422 | 2102452.6585 | 37.7519074266581 | -122.504180665511 | (37.7519074266581, -122.504180665511) | |
| 44174 | 44174 | 42994 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500 Yale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.723036105202205 | -122.415997529963 | (37.7230361052022, -122.415997529963) | ||
| 45611 | 45611 | 43621 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2095 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.49332687468599 | (37.7480118028434, -122.493326874686) | ||
| 46550 | 46550 | 43782 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 125 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 4 | Permit Number 43412 | 5989265.293980001 | 2114516.2308400003 | 37.7854390383616 | -122.480907074228 | (37.7854390383616, -122.480907074228) | |
| 46613 | 46613 | 70168 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5129 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 6 | 5982718.93125 | 2111668.1719299997 | 37.7772364107813 | -122.50334420523399 | (37.7772364107813, -122.503344205234) | ||
| 47881 | 47881 | 78378 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 5 | 6001605.25452 | 2090913.7229900002 | 37.7213417817901 | -122.436524599656 | (37.7213417817901, -122.436524599656) | ||
| 48074 | 48074 | 69362 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3521 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33456 | 6002627.22111 | 2120704.3070900002 | 37.8031975232214 | -122.435121592481 | (37.8031975232214, -122.435121592481) | |
| 49036 | 49036 | 65607 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 182 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767458 | 6004579.16944 | 2093759.75788 | 37.7293249116129 | -122.42644714752501 | (37.7293249116129, -122.426447147525) |
| 50065 | 50065 | 47679 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 327 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 6 | Permit Number 45466 | 6013233.56276 | 2105528.8113599997 | 37.762125666091 | -122.397352923703 | (37.762125666091, -122.397352923703) | |
| 52190 | 52190 | 42235 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 479 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010547.8419 | 2112298.97398 | 37.780565078461706 | -122.407119085392 | (37.7805650784617, -122.407119085392) | |
| 52921 | 52921 | 66871 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 350 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30181 | 6001115.30809688 | 2104289.68730442 | 37.7580411890038 | -122.43917641405001 | (37.7580411890038, -122.43917641405) | ||
| 53271 | 53271 | 74480 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4045 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1994 12:00:00 AM | 5 | 5982259.5223 | 2104870.2558 | 37.7585442772343 | -122.504429677037 | (37.7585442772343, -122.504429677037) | ||
| 53443 | 53443 | 42672 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42700 | 6008565.6692 | 2121051.5528 | 37.80448638863479 | -122.414595938174 | (37.8044863886348, -122.414595938174) | |
| 54044 | 54044 | 78489 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3345 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 5 | 5988664.39778 | 2095197.91873 | 37.7323612287764 | -122.481570599508 | (37.7323612287764, -122.481570599508) | ||
| 54593 | 54593 | 42885 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2546 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 4 | Permit Number 42806 | 5985850.2562 | 2097897.6252 | 37.7396098709906 | -122.491498248106 | (37.7396098709906, -122.491498248106) | |
| 55998 | 55998 | 31018 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | Permit Number 43762 | 6002296.8403 | 2087180.6482 | 37.711130859472604 | -122.433867290956 | (37.7111308594726, -122.433867290956) | |
| 58826 | 58826 | 38560 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1539 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 7 | Permit Number 40525 | 6015686.9214 | 2095659.8019 | 37.7351637119843 | -122.388178849076 | (37.7351637119843, -122.388178849076) | |
| 58880 | 58880 | 43337 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 451 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 8 | Permit Number 43094 | 6003321.30466 | 2090952.47585 | 37.7215455546665 | -122.430595462026 | (37.7215455546665, -122.430595462026) | |
| 59437 | 59437 | 70396 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 309 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 7 | 6005777.21829 | 2092245.9631400001 | 37.72523601532679 | -122.422197872442 | (37.7252360153268, -122.422197872442) | ||
| 59747 | 59747 | 34645 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1514 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38324 | 5987781.2369 | 2104967.961 | 37.7591357755256 | -122.48534051269199 | (37.7591357755256, -122.485340512692) | |
| 60167 | 60167 | 32490 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 26 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36996 | 5999294.82707 | 2105565.3001 | 37.76143994650629 | -122.44556411809799 | (37.7614399465063, -122.445564118098) | |
| 61476 | 61476 | 69162 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1201 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33199 | 5982705.2838 | 2106882.9636 | 37.7640968091015 | -122.503037064776 | (37.7640968091015, -122.503037064776) | |
| 62048 | 62048 | 37093 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3 | Permit Number 39693 | 5981559.2885 | 2105362.1483 | 37.7598536626334 | -122.506887844351 | (37.7598536626334, -122.506887844351) | |
| 62120 | 62120 | 78400 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 735 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5986604.8504 | 2110908.2290000003 | 37.7753774919681 | -122.48984584488701 | (37.7753774919681, -122.489845844887) | ||
| 62783 | 62783 | 68276 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 543 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32083 | 6008845.70964 | 2093488.4538 | 37.7288202318587 | -122.411678113946 | (37.7288202318587, -122.411678113946) | |
| 63488 | 63488 | 33246 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2455 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 3 | Permit Number 37427 | 5987953.5529 | 2098598.711 | 37.7416575568292 | -122.484277448664 | (37.7416575568292, -122.484277448664) | |
| 64104 | 64104 | 31621 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 263 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 5 | Permit Number 45471 | 6004202.65828 | 2091873.5770299998 | 37.7241245863632 | -122.42761445225099 | (37.7241245863632, -122.427614452251) | |
| 64490 | 64490 | 67678 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1566 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 11 | Permit Number 31282 | 6014784.0524 | 2093614.4352 | 37.7294974829563 | -122.391157497644 | (37.7294974829563, -122.391157497644) | |
| 65842 | 65842 | 31005 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34779 | 6000594.89127 | 2088305.62905 | 37.71412307747921 | -122.439830234972 | (37.7141230774792, -122.439830234972) | |
| 65966 | 65966 | 38554 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1791 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | 6 | Permit Number 40521 | 6014548.21389 | 2096859.31136 | 37.738394160770795 | -122.392199668106 | (37.7383941607708, -122.392199668106) | |
| 65967 | 65967 | 69012 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2170 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 3 | Permit Number 33015 | 5982352.1644 | 2100332.9535 | 37.746091567164896 | -122.503773252601 | (37.7460915671649, -122.503773252601) | |
| 66172 | 66172 | 73153 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1970 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1999 12:00:00 AM | 5 | 6001494.4295 | 2115195.887 | 37.7880084528635 | -122.438646710686 | (37.7880084528635, -122.438646710686) | ||
| 66354 | 66354 | 32060 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3641 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 4 | Permit Number 35437 | 6004597.15155 | 2105983.21796 | 37.7628887345501 | -122.42725534218201 | (37.7628887345501, -122.427255342182) | |
| 66408 | 66408 | 78070 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 818 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | 6011825.3920599995 | 2104537.71061 | 37.7593258220597 | -122.402153592937 | (37.7593258220597, -122.402153592937) | ||
| 66759 | 66759 | 78797 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 85 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 1 | 6001030.801469999 | 2087976.50512 | 37.713244179940794 | -122.43830000075899 | (37.7132441799408, -122.438300000759) | ||
| 67406 | 67406 | 69044 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1994 12:00:00 AM | 2 | Permit Number 33051 | 5984041.3218 | 2105444.0326 | 37.760224347253704 | -122.498309886187 | (37.7602243472537, -122.498309886187) | |
| 69334 | 69334 | 38559 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1538 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 9 | Permit Number 40524 | 6015720.042 | 2095709.5571 | 37.735302164763496 | -122.38806780916799 | (37.7353021647635, -122.388067809168) | |
| 69346 | 69346 | 69027 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3830 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1994 12:00:00 AM | 0 | Permit Number 33031 | 5981593.45716069 | 2100816.99566217 | 37.747375971680796 | -122.50643260796801 | (37.7473759716808, -122.506432607968) | |
| 69433 | 69433 | 65697 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 20 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/1990 12:00:00 AM | 12 | Permit Number 28626 | 6000103.70653 | 2088525.9220900002 | 37.714699980888795 | -122.44154375196501 | (37.7146999808888, -122.441543751965) | |
| 69680 | 69680 | 43164 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 243 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 7 | Permit Number 42974 | 6005687.812469999 | 2092539.3514599998 | 37.726036552238604 | -122.42252777796001 | (37.7260365522386, -122.42252777796) | |
| 70129 | 70129 | 60817 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1150 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/1983 12:00:00 AM | 3 | Permit Number 20495 | 5989806.3915 | 2101102.4889 | 37.7486399870467 | -122.478054033081 | (37.7486399870467, -122.478054033081) | |
| 70843 | 70843 | 65434 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/1999 12:00:00 AM | Permit Number 33170 | 6008638.12512872 | 2114173.69680574 | 37.785605560242 | -122.41385837708 | (37.785605560242, -122.41385837708) | ||
| 72277 | 72277 | 39921 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1938 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 4 | Permit Number 41195 | 6001498.9973 | 2115128.5111 | 37.7878237158389 | -122.43862607738998 | (37.7878237158389, -122.43862607739) | |
| 73804 | 73804 | 74038 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1501 25th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 3 | 6014092.75077 | 2101968.0918900003 | 37.752396498007606 | -122.394132008099 | (37.7523964980076, -122.394132008099) | ||
| 76504 | 76504 | 30814 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 145 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | 8 | Permit Number 34676 | 6001106.90976 | 2094917.71442 | 37.7323074960919 | -122.438533971982 | (37.7323074960919, -122.438533971982) | |
| 76729 | 76729 | 43046 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2223 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 0 | Permit Number 42900 | 5984177.60639634 | 2100035.08697595 | 37.7453808710845 | -122.497439220864 | (37.7453808710845, -122.497439220864) | |
| 77897 | 77897 | 105128 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1835 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.752249639902296 | -122.506499383522 | (37.7522496399023, -122.506499383522) |
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");