Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129794 | 129794 | 123883 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992072.431890001 | 2114857.09467 | 37.7865377268901 | -122.471220147048 | (37.7865377268901, -122.471220147048) | |||
172853 | 172853 | 123882 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992074.12323 | 2114872.38939 | 37.7865798197895 | -122.47121541022601 | (37.7865798197895, -122.471215410226) | |||
175777 | 175777 | 68446 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 6 | Permit Number 32303 | 5992072.75481 | 2114889.3953400003 | 37.7866264342674 | -122.47122138404801 | (37.7866264342674, -122.471221384048) | ||
136729 | 136729 | 136918 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001921.35919 | 2120601.2758299997 | 37.8028745199931 | -122.437556861278 | (37.8028745199931, -122.437556861278) | |||
103263 | 103263 | 30665 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 McCoppin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
142462 | 142462 | 30666 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 McCoppin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
13358 | 13358 | 79034 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Moss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2002 12:00:00 AM | 1 | 2.5x4 | 6010138.62156 | 2111398.24518 | 37.7780689795412 | -122.40847122506399 | (37.7780689795412, -122.408471225064) | ||
79555 | 79555 | 36268 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
101773 | 101773 | 36269 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
114099 | 114099 | 36271 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
119787 | 119787 | 36270 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10 Rossmoor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1998 12:00:00 AM | Permit Number 39275 | 5991227.19729214 | 2094352.63803759 | 37.730188986750605 | -122.47264888645701 | (37.7301889867506, -122.472648886457) | ||
173810 | 173810 | 75766 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009894.26848 | 2094011.0737400001 | 37.730314000377 | -122.408090001562 | (37.730314000377, -122.408090001562) | ||
104103 | 104103 | 7871 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 3 | 3X3 | 6006017.92474 | 2113680.1220400003 | 37.7841028269903 | -122.42288843164101 | (37.7841028269903, -122.422888431641) | ||
169666 | 169666 | 219436 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Ortega St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990892.67595 | 2102441.87183 | 37.752380574612204 | -122.474395438619 | (37.7523805746122, -122.474395438619) | |||
112704 | 112704 | 50819 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1009 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47342 | 6010039.41742764 | 2112370.40849241 | 37.780732755109604 | -122.40888301650601 | (37.7807327551096, -122.408883016506) | |||
164105 | 164105 | 50820 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1009 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 4 | Permit Number 47342 | 6010026.22608 | 2112350.59085 | 37.7806776016324 | -122.408927253305 | (37.7806776016324, -122.408927253305) | ||
99288 | 99288 | 90134 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995229.54942 | 2111496.31673 | 37.7774920413779 | -122.460053813186 | (37.7774920413779, -122.460053813186) | ||
64598 | 64598 | 123720 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | Width 3ft | 5995264.25203 | 2111440.07761 | 37.7773396195467 | -122.459929691175 | (37.7773396195467, -122.459929691175) | ||
89034 | 89034 | 90380 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995315.581431 | 2111451.352271 | 37.7773735286818 | -122.459752944165 | (37.7773735286818, -122.459752944165) | ||
130711 | 130711 | 75004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | 5997965.54363 | 2116098.57851 | 37.7902856238171 | -122.450921084564 | (37.7902856238171, -122.450921084564) | ||
32694 | 32694 | 104489 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101X Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6012893.40207 | 2106545.4722700003 | 37.7648982471715 | -122.398600762736 | (37.7648982471715, -122.398600762736) | |||
63498 | 63498 | 136937 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1020 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009944.47498 | 2116838.4179700003 | 37.792995521282 | -122.409526902355 | (37.792995521282, -122.409526902355) | |||
133474 | 133474 | 59489 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1029 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51129 | 6011954.00169 | 2103318.43549 | 37.75598513922839 | -122.401623098137 | (37.7559851392284, -122.401623098137) | |
77909 | 77909 | 41779 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1033 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42192 | 6009731.77420403 | 2117422.91465756 | 37.79458848646429 | -122.410304149551 | (37.7945884864643, -122.410304149551) | ||
93527 | 93527 | 41780 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1033 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42192 | 6009731.77420403 | 2117422.91465756 | 37.79458848646429 | -122.410304149551 | (37.7945884864643, -122.410304149551) | ||
176191 | 176191 | 242339 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1035 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001342.6727 | 2100671.2124799998 | 37.748118662255294 | -122.438130887736 | (37.7481186622553, -122.438130887736) | |||
136548 | 136548 | 53053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1042 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2006 12:00:00 AM | 5 | 3x3 | Permit Number 49030 | 6015494.75997 | 2104280.44649 | 37.7588235587865 | -122.38944505814501 | (37.7588235587865, -122.389445058145) | |
22422 | 22422 | 7875 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2014 02:38:00 PM | 3 | 4X4 | 6006070.45315 | 2113764.9909599996 | 37.7843388199314 | -122.422712735214 | (37.7843388199314, -122.422712735214) | ||
58664 | 58664 | 242887 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005696.3409 | 2102856.44643 | 37.754365453022 | -122.423231349069 | (37.754365453022, -122.423231349069) | |||
40310 | 40310 | 242898 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.25969 | 2103043.9270599997 | 37.755120337650105 | -122.408474577742 | (37.7551203376501, -122.408474577742) | |||
56748 | 56748 | 242899 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.68817 | 2103026.2265 | 37.7550717598627 | -122.408471847423 | (37.7550717598627, -122.408471847423) | |||
147392 | 147392 | 242900 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009967.375580001 | 2103010.90025 | 37.7550296598983 | -122.408471847422 | (37.7550296598983, -122.408471847422) | |||
21230 | 21230 | 28488 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1056 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 12 | 3X3 | 6005699.27295 | 2102829.0400099996 | 37.754290366819 | -122.423219261259 | (37.754290366819, -122.423219261259) | ||
118685 | 118685 | 47248 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1060 Key Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2011 12:00:00 AM | Permit Number 767222 | 6013087.98009516 | 2089992.50143255 | 37.7194581178311 | -122.39676721011699 | (37.7194581178311, -122.396767210117) | ||
111580 | 111580 | 51380 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1061 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | Permit Number 47711 | 6010569.99694283 | 2111124.83155789 | 37.7773423979358 | -122.40695965967501 | (37.7773423979358, -122.406959659675) | ||
138968 | 138968 | 51379 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1061 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2005 12:00:00 AM | Permit Number 47711 | 6010569.99694283 | 2111124.83155789 | 37.7773423979358 | -122.40695965967501 | (37.7773423979358, -122.406959659675) | ||
40939 | 40939 | 198418 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013212.31335 | 2089895.25282 | 37.7191980120665 | -122.396330620284 | (37.7191980120665, -122.396330620284) | |||
180988 | 180988 | 198416 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013254.09143 | 2089864.5252900003 | 37.7191159651107 | -122.396184055957 | (37.7191159651107, -122.396184055957) | |||
186062 | 186062 | 198417 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1062 Key Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013234.80615 | 2089878.55725 | 37.719153420980604 | -122.39625170116301 | (37.7191534209806, -122.396251701163) | |||
20345 | 20345 | 5583 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1069 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005153.43733 | 2102137.63056 | 37.752361098006894 | -122.42505770847299 | (37.7523610980069, -122.425057708473) | |||
49855 | 49855 | 242329 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 107 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005095.8624599995 | 2099583.89393 | 37.745345873425705 | -122.42507512473699 | (37.7453458734257, -122.425075124737) | |||
177030 | 177030 | 124216 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 107 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5996487.33444 | 2112259.12921 | 37.7796587851836 | -122.45575789701401 | (37.7796587851836, -122.455757897014) | |||
94498 | 94498 | 90379 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995291.794305 | 2111450.466195 | 37.7773697278094 | -122.459835166842 | (37.7773697278094, -122.459835166842) | ||
128337 | 128337 | 90378 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995235.890819999 | 2111438.83153 | 37.777334567000295 | -122.460027710853 | (37.7773345670003, -122.460027710853) | ||
91430 | 91430 | 51896 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48107 | 5995812.81263218 | 2088671.52692975 | 37.7148543797151 | -122.45638527464199 | (37.7148543797151, -122.456385274642) | |||
102622 | 102622 | 51895 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 109 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48107 | 5995812.81263218 | 2088671.52692975 | 37.7148543797151 | -122.45638527464199 | (37.7148543797151, -122.456385274642) | |||
86022 | 86022 | 17243 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 6 | 3X34 | 5993969.30173 | 2088537.74626 | 37.7143810447114 | -122.462747471174 | (37.7143810447114, -122.462747471174) | ||
143729 | 143729 | 45539 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 11 Middlefield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | Permit Number 44294 | 5987258.11223173 | 2095792.07894073 | 37.7339107660531 | -122.48647600029699 | (37.7339107660531, -122.486476000297) | ||
166295 | 166295 | 242330 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 110 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005175.96727 | 2099631.57497 | 37.745481319400795 | -122.424801526695 | (37.7454813194008, -122.424801526695) | |||
35758 | 35758 | 242888 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005717.8738400005 | 2102519.39452 | 37.753441201753205 | -122.423132926343 | (37.7534412017532, -122.423132926343) | |||
42751 | 42751 | 108789 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
82210 | 82210 | 108786 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
84872 | 84872 | 108785 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
99997 | 99997 | 108787 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
142924 | 142924 | 108788 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1100-1198X Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.136580001 | 2087632.54285 | 37.7127552255458 | -122.41039559568199 | (37.7127552255458, -122.410395595682) | |
97962 | 97962 | 87717 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1107 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5996451.82773 | 2091748.4966099998 | 37.7233396801105 | -122.45439871889799 | (37.7233396801105, -122.454398718898) | |||
58391 | 58391 | 182082 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1109 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2017 12:00:00 AM | 3 | Width 0ft | 5989746.1732 | 2098995.6798 | 37.7428517447762 | -122.47810825386001 | (37.7428517447762, -122.47810825386) | ||
92825 | 92825 | 25288 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 110X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1996 12:00:00 AM | 10 | 3x3 | 6000890.43944 | 2091777.01619 | 37.7236715433472 | -122.43905734896299 | (37.7236715433472, -122.439057348963) | ||
62677 | 62677 | 50483 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2003 12:00:00 AM | 5 | Permit Number 47118 | 5987691.11202 | 2115193.54019 | 37.787207107765 | -122.48640295005501 | (37.787207107765, -122.486402950055) | ||
133181 | 133181 | 242915 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005066.82423 | 2099579.80768 | 37.7453330131246 | -122.425175243547 | (37.7453330131246, -122.425175243547) | |||
45566 | 45566 | 123719 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995199.7628 | 2111434.37432 | 37.777320250731705 | -122.460152365551 | (37.7773202507317, -122.460152365551) | |||
83744 | 83744 | 94664 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 111 Cuvier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53801 | 6004018.0 | 2095241.0 | 37.7333603312135 | -122.428492699505 | (37.7333603312135, -122.428492699505) | |
127224 | 127224 | 475 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1110X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 06:40:00 PM | 3 | 3x3 | 6005715.8108342 | 2102491.4524088 | 37.753364362762 | -122.42313807467801 | (37.753364362762, -122.423138074678) | ||
91118 | 91118 | 81458 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1111 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49734 | 5989787.55086775 | 2099004.4958045 | 37.742878352926795 | -122.47796582741002 | (37.7428783529268, -122.47796582741) | ||
28936 | 28936 | 49804 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1112SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46599 | 6014208.95643 | 2105755.12489 | 37.7628013312333 | -122.39399522840799 | (37.7628013312333, -122.393995228408) | |
114649 | 114649 | 42200 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1114 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42473 | 6009999.06556855 | 2108898.91506749 | 37.7711985850094 | -122.408777629275 | (37.7711985850094, -122.408777629275) | ||
120533 | 120533 | 42199 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1114 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42473 | 6009999.06556855 | 2108898.91506749 | 37.7711985850094 | -122.408777629275 | (37.7711985850094, -122.408777629275) | ||
121461 | 121461 | 42201 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1114 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42473 | 6009999.06556855 | 2108898.91506749 | 37.7711985850094 | -122.408777629275 | (37.7711985850094, -122.408777629275) | ||
67427 | 67427 | 31660 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1120 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1995 12:00:00 AM | 11 | Permit Number 35168 | 6009328.60385 | 2117080.0959 | 37.7936245817471 | -122.411674942066 | (37.7936245817471, -122.411674942066) | ||
18648 | 18648 | 10186 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1130 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2015 04:47:00 AM | 3 | 4x5 | 6005723.69305 | 2102361.07491 | 37.753006821117296 | -122.423101549889 | (37.7530068211173, -122.423101549889) | ||
11646 | 11646 | 27701 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1136 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2000 12:00:00 AM | 6 | 6008329.0437900005 | 2093834.9235 | 37.729742566663106 | -122.413488762206 | (37.7297425666631, -122.413488762206) | |||
42392 | 42392 | 180477 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008049.06665 | 2092073.68164 | 37.724890849229 | -122.41433210953899 | (37.724890849229, -122.414332109539) | |||
159712 | 159712 | 180474 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008093.7443 | 2092086.4118 | 37.724928313173706 | -122.414178563806 | (37.7249283131737, -122.414178563806) | |||
179785 | 179785 | 180475 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008076.47647 | 2092081.3673900003 | 37.724913492352 | -122.414237900184 | (37.724913492352, -122.414237900184) | |||
187971 | 187971 | 180476 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1138 Bacon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008061.923909999 | 2092076.5671299999 | 37.724899494409705 | -122.41428786739999 | (37.7248994944097, -122.4142878674) | |||
18209 | 18209 | 10188 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1148 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/05/2016 12:00:00 AM | 3 | 2x4 | 6005734.612380001 | 2102244.83146 | 37.75268825965679 | -122.423055527089 | (37.7526882596568, -122.423055527089) | ||
39535 | 39535 | 136939 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1149 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008985.04879 | 2116923.16762 | 37.7931744171228 | -122.412852575501 | (37.7931744171228, -122.412852575501) | |||
105379 | 105379 | 33347 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 115 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53998 | 5994561.49853007 | 2093647.4167141998 | 37.728445063974796 | -122.461070757188 | (37.7284450639748, -122.461070757188) | |
108794 | 108794 | 28590 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | ||
117573 | 117573 | 28588 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
119764 | 119764 | 28589 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Ocean Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 6 | 3X3 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | ||
144482 | 144482 | 98742 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
145720 | 145720 | 98741 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1150 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Housing Authority 20 | DPW for City Agency 2 | 03/21/2012 12:00:00 AM | 3 | 4X4 | 6002360.0 | 2112467.0 | 37.780564823652504 | -122.43545670615299 | (37.7805648236525, -122.435456706153) | |
132171 | 132171 | 242912 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1154 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004415.185819999 | 2102148.8561 | 37.7523501901347 | -122.427611502469 | (37.7523501901347, -122.427611502469) | |||
118573 | 118573 | 120668 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1154 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5998951.0 | 2105925.0 | 37.76240795737721 | -122.44677915122601 | (37.7624079573772, -122.446779151226) | |||
28712 | 28712 | 82088 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 9 | 3x3 | Permit Number 50668 | 5996122.25454 | 2115757.75082 | 37.789244107281604 | -122.45727402588001 | (37.7892441072816, -122.45727402588) | |
38984 | 38984 | 82050 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 116 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50668 | 5996119.951719999 | 2115777.79007 | 37.78929899740071 | -122.457283443584 | (37.7892989974007, -122.457283443584) | |
21836 | 21836 | 10190 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1160 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2015 09:38:00 AM | 3 | 2x2 | 6005734.23383 | 2102203.6860700003 | 37.7525752625596 | -122.42305391193001 | (37.7525752625596, -122.42305391193) | ||
14663 | 14663 | 28516 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6010207.243969999 | 2112381.64795 | 37.7807730152091 | -122.40830321374901 | (37.7807730152091, -122.408303213749) | |||
126876 | 126876 | 50286 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 46994 | 6001812.465231299 | 2096668.95095007 | 37.737156097415706 | -122.436219989049 | (37.7371560974157, -122.436219989049) | ||
183009 | 183009 | 52766 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 Trenton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2006 12:00:00 AM | 4 | Permit Number 48808 | 6010071.7871900005 | 2117939.89762 | 37.7960270495675 | -122.409164153622 | (37.7960270495675, -122.409164153622) | ||
12988 | 12988 | 904 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1179 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2016 12:00:00 AM | 3 | 2X2 | 6003419.3756099995 | 2094263.29224 | 37.7306418725253 | -122.430492572378 | (37.7306418725253, -122.430492572378) | ||
56229 | 56229 | 83159 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 118 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52389 | 6013682.79491 | 2106471.12708 | 37.7647380590444 | -122.395865223811 | (37.7647380590444, -122.395865223811) | |
142871 | 142871 | 50812 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1185 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47335 | 6006411.34126945 | 2102697.72604522 | 37.7539699686496 | -122.42074742340598 | (37.7539699686496, -122.420747423406) | ||||
77376 | 77376 | 49717 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
83435 | 83435 | 49719 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
87176 | 87176 | 49716 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
159839 | 159839 | 198423 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195 La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017270.50645 | 2094483.4459099998 | 37.7320212859403 | -122.38262193865299 | (37.7320212859403, -122.382621938653) | |||
81038 | 81038 | 17707 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2012 12:00:00 AM | 3 | 4x4 | 6002295.810192 | 2112602.9289849997 | 37.78093440458979 | -122.435688496636 | (37.7809344045898, -122.435688496636) | ||
98332 | 98332 | 17706 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1195X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2012 12:00:00 AM | 3 | 4x4 | 6002295.810192 | 2112602.9289849997 | 37.78093440458979 | -122.435688496636 | (37.7809344045898, -122.435688496636) |
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");