Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23088 | 23088 | 29 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 742 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6003854.77769 | 2107764.13441 | 37.7677366901162 | -122.42994999788799 | (37.7677366901162, -122.429949997888) | |||
118517 | 118517 | 431 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
128353 | 128353 | 432 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 30 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
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) | ||
154 | 154 | 830 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1384 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:15:00 PM | 3 | 5.5x6.5 | 5981549.5887 | 2105676.5499 | 37.7607163481902 | -122.506944712409 | (37.7607163481902, -122.506944712409) | ||
22063 | 22063 | 855 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 378 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1995 12:00:00 AM | 6 | 3X3 | 6008306.24694 | 2095178.0824099998 | 37.7334293112951 | -122.41366253820401 | (37.7334293112951, -122.413662538204) | ||
20785 | 20785 | 856 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2001 12:00:00 AM | 8 | 3x3 | 6008178.91279 | 2095102.6011299998 | 37.7332149048351 | -122.414097431452 | (37.7332149048351, -122.414097431452) | ||
17386 | 17386 | 857 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 09:50:00 AM | 3 | 3x3 | 6008157.97396 | 2095088.68273 | 37.7331755118234 | -122.41416883853701 | (37.7331755118234, -122.414168838537) | ||
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) | ||
12419 | 12419 | 981 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1604 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2003 12:00:00 AM | 6 | 3X3 | 6001745.7594099995 | 2092854.52102 | 37.7266787581039 | -122.436177732017 | (37.7266787581039, -122.436177732017) | ||
111383 | 111383 | 1199 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
141065 | 141065 | 1200 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
87032 | 87032 | 1201 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
95862 | 95862 | 1202 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
125579 | 125579 | 1467 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5995559.29766 | 2114744.3111900003 | 37.786429126950104 | -122.45914836167401 | (37.7864291269501, -122.459148361674) | |||
23242 | 23242 | 1673 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 5994963.861330001 | 2111486.70203 | 37.7774503572538 | -122.460972213003 | (37.7774503572538, -122.460972213003) | ||||
119701 | 119701 | 1677 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 302 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/25/2002 12:00:00 AM | 3 | 3X3 | 5994635.149619999 | 2111475.19089 | 37.777399830436 | -122.46210849201599 | (37.777399830436, -122.462108492016) | ||
23024 | 23024 | 2316 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2263 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009682.41451 | 2104184.36513 | 37.7582357681755 | -122.409540144857 | (37.7582357681755, -122.409540144857) | ||||
15078 | 15078 | 2525 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1570 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:24:00 PM | 3 | 3X3 | 6016567.66909 | 2098923.0431 | 37.7441726718323 | -122.385361080243 | (37.7441726718323, -122.385361080243) | ||
16215 | 16215 | 2527 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1570 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 02:21:00 PM | 3 | 3X3 | 6016536.91868 | 2098947.33995 | 37.7442376847211 | -122.38546910231001 | (37.7442376847211, -122.38546910231) | ||
17358 | 17358 | 4165 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3770 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 12:00:00 AM | 3 | 3X3 | Permit Number 774303 | 6005421.09901 | 2100523.30385 | 37.747943645176704 | -122.424017300779 | (37.7479436451767, -122.424017300779) | |
78480 | 78480 | 5014 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5313 Diamond Heights Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 3 | 3 | 6001578.667721 | 2098979.6063858 | 37.7434873306528 | -122.437193725781 | (37.7434873306528, -122.437193725781) | ||
80001 | 80001 | 5015 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5313 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1997 12:00:00 AM | 3 | 2 | 6001578.667721 | 2098979.6063858 | 37.7434873306528 | -122.437193725781 | (37.7434873306528, -122.437193725781) | ||
88812 | 88812 | 5035 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5343 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 3 | 3X3 | 6001794.1836781 | 2098779.6603168 | 37.742950574320204 | -122.43643421934401 | (37.7429505743202, -122.436434219344) | ||
97045 | 97045 | 5037 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5355 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1997 12:00:00 AM | 3 | 3X3 | 6001868.9723963 | 2098685.9233744 | 37.7426974440588 | -122.436168914431 | (37.7426974440588, -122.436168914431) | ||
89081 | 89081 | 5038 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5361 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 3 | 3X3 | 6001904.577984599 | 2098640.1233312 | 37.7425737107311 | -122.43604252412399 | (37.7425737107311, -122.436042524124) | ||
110102 | 110102 | 5039 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5367 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 3 | 3X3 | 6001935.2122711 | 2098586.2052626 | 37.7424274046596 | -122.435932742747 | (37.7424274046596, -122.435932742747) | ||
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) | |||
54781 | 54781 | 6305 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1797X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1997 12:00:00 AM | 9 | 3X3 | 6002532.11938 | 2112833.28187 | 37.781580315205396 | -122.434887466275 | (37.7815803152054, -122.434887466275) | ||
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) | ||
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) | ||
23334 | 23334 | 8279 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1601 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6015771.79311 | 2097687.24817 | 37.740735369454605 | -122.388026849781 | (37.7407353694546, -122.388026849781) | |||
142012 | 142012 | 8890 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4300 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1996 12:00:00 AM | 3 | 3X3 | 5993676.36815 | 2112846.77323 | 37.7811105766569 | -122.46552487036199 | (37.7811105766569, -122.465524870362) | ||
87763 | 87763 | 8934 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4630 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2002 12:00:00 AM | 3 | 2X2 | 5992661.51426 | 2112807.7475 | 37.7809448378746 | -122.46903288589701 | (37.7809448378746, -122.469032885897) | ||
144382 | 144382 | 9239 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6406 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/1996 12:00:00 AM | 3 | 3X3 | 5987099.50219 | 2112606.70022 | 37.780069883306396 | -122.488259594393 | (37.7800698833064, -122.488259594393) | ||
97698 | 97698 | 9253 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6500X Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 2X3 | 5986722.32109 | 2112597.81428 | 37.7800234720171 | -122.489563763122 | (37.7800234720171, -122.489563763122) | ||
138537 | 138537 | 10053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 425 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X2 | 6005568.8374122 | 2106507.5213951 | 37.7643832516565 | -122.42393189992501 | (37.7643832516565, -122.423931899925) | ||
20425 | 20425 | 10057 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 439 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2016 06:50:00 AM | 3 | 3X3 | 6005566.67326 | 2106440.43668 | 37.7641989307536 | -122.423934614407 | (37.7641989307536, -122.423934614407) | ||
19486 | 19486 | 10095 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 727 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 05:21:00 AM | 3 | 2X2 | 6005664.2360000005 | 2104708.85405 | 37.759449920391 | -122.423474060781 | (37.759449920391, -122.423474060781) | ||
16928 | 16928 | 10096 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 737 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | 3 | 3x3 | 6005665.871 | 2104659.8313700003 | 37.7593154078879 | -122.42346492097602 | (37.7593154078879, -122.423464920976) | ||
21922 | 21922 | 10107 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 799X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2014 06:59:00 AM | 3 | 3x4 | 6005682.50344 | 2104371.2203900004 | 37.7585238884792 | -122.423386880525 | (37.7585238884792, -122.423386880525) | ||
21046 | 21046 | 10125 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 876 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2015 02:57:00 PM | 3 | 3x3 | 6005640.441980001 | 2103866.83654 | 37.757136594295396 | -122.423496489872 | (37.7571365942954, -122.423496489872) | ||
18818 | 18818 | 10127 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 892 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6005646.424 | 2103793.6441599997 | 37.7569359627397 | -122.42347059841002 | (37.7569359627397, -122.42347059841) | |||
22211 | 22211 | 10150 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 966 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/2012 12:00:00 AM | 3 | 3x3 | 6005669.65476 | 2103355.68664 | 37.7557347445795 | -122.423359124725 | (37.7557347445795, -122.423359124725) | ||
17728 | 17728 | 10153 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 978 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2016 06:51:00 AM | 3 | 3x4 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | ||
92901 | 92901 | 10154 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 986 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3x3 | 6005675.0599084 | 2103229.8800101 | 37.755389613891 | -122.423331489083 | (37.755389613891, -122.423331489083) | ||
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) | ||
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) | ||
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) | ||
85469 | 85469 | 10201 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1233 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X3 | 6005829.840660599 | 2101789.0505836997 | 37.7514421637243 | -122.422693823491 | (37.7514421637243, -122.422693823491) | ||
21694 | 21694 | 10206 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1274 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2010 12:00:00 AM | 3 | 2X2 | 6005768.7769 | 2101585.68354 | 37.7508803192719 | -122.422890537479 | (37.7508803192719, -122.422890537479) | ||
9186 | 9186 | 10962 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1431 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | ||
117525 | 117525 | 12095 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1261X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | ||
144194 | 144194 | 12106 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1281X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6017033.141005999 | 2094557.4754692002 | 37.732211440602605 | -122.383447721977 | (37.7322114406026, -122.383447721977) | ||
22997 | 22997 | 12121 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6016540.00349 | 2094984.34395 | 37.733356269266295 | -122.38518235797899 | (37.7333562692663, -122.385182357979) | |||
15469 | 15469 | 12131 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016434.11275 | 2095220.18267 | 37.7339979769066 | -122.38556488553499 | (37.7339979769066, -122.385564885535) | |||
16106 | 16106 | 12141 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016374.05041 | 2095443.42618 | 37.7346076354195 | -122.38578809634899 | (37.7346076354195, -122.385788096349) | |||
16692 | 16692 | 12234 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1570 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 6 | 3X3 | 6015728.02305 | 2096056.7839799998 | 37.7362560216982 | -122.38806443872 | (37.7362560216982, -122.38806443872) | ||
14268 | 14268 | 12235 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1574 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/1997 12:00:00 AM | 6 | 3X3 | 6015715.635319999 | 2096065.54177 | 37.736279382483204 | -122.38810787958201 | (37.7362793824832, -122.388107879582) | ||
89527 | 89527 | 12448 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1989X Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/31/2006 12:00:00 AM | 3 | 3X3 | 6004432.626396201 | 2115327.1853143997 | 37.7885356724235 | -122.428490433403 | (37.7885356724235, -122.428490433403) | ||
92244 | 92244 | 12608 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5993288.45121 | 2114872.37286 | 37.786649939560796 | -122.46701416661199 | (37.7866499395608, -122.467014166612) | |||
78031 | 78031 | 12721 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1535 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5990655.40582 | 2114718.61196 | 37.7860754253896 | -122.476112538286 | (37.7860754253896, -122.476112538286) | ||
110986 | 110986 | 12738 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1630 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/2013 12:00:00 AM | 100 | 4x4 | 5990343.3046 | 2114764.5197400004 | 37.7861833727245 | -122.47719566934299 | (37.7861833727245, -122.477195669343) | ||
128148 | 128148 | 12774 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1842 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1997 12:00:00 AM | 20 | 6 | 5989637.59951 | 2114741.75598 | 37.7860799008728 | -122.479635529609 | (37.7860799008728, -122.479635529609) | ||
128791 | 128791 | 12775 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1842 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 6 | 5989652.1071 | 2114741.09637 | 37.786078932501 | -122.47958528952 | (37.786078932501, -122.47958528952) | ||
108155 | 108155 | 12781 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1914 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1997 12:00:00 AM | 40 | 3X3 | 5989486.1909300005 | 2114733.67338 | 37.786048911885096 | -122.48015876501101 | (37.7860489118851, -122.480158765011) | ||
22225 | 22225 | 15638 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3620 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774763 | 6005333.2664 | 2097101.2564 | 37.7385425216055 | -122.42407769940901 | (37.7385425216055, -122.424077699409) | |
78080 | 78080 | 15703 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4260 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2009 12:00:00 AM | 3 | 3X3 | 6003241.43292 | 2093747.9611099998 | 37.7292168076411 | -122.431070980005 | (37.7292168076411, -122.431070980005) | ||
13082 | 13082 | 15846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5256 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 6 | 3x3 | Permit Number 775938 | 5999899.043409999 | 2088666.4410599999 | 37.7150741519211 | -122.442261231071 | (37.7150741519211, -122.442261231071) | |
125649 | 125649 | 15854 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5319 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999668.720480001 | 2088318.36983 | 37.714105297270606 | -122.443032341019 | (37.7141052972706, -122.443032341019) | ||
142815 | 142815 | 15859 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5367 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999657.0 | 2088324.0 | 37.7141200881786 | -122.44307325545601 | (37.7141200881786, -122.443073255456) | ||
79600 | 79600 | 15934 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5775 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997641.29025 | 2086713.63365 | 37.7095832536665 | -122.449924299561 | (37.7095832536665, -122.449924299561) | ||
96152 | 96152 | 15940 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5810X MISSION ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/20/1998 12:00:00 AM | 6 | 3X3 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | ||
9415 | 9415 | 15943 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5810X MISSION ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | |||
84568 | 84568 | 15970 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5919X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1995 12:00:00 AM | 6 | 3X3 | 5996671.773019999 | 2086351.2464599998 | 37.708532699460896 | -122.45324895592199 | (37.7085326994609, -122.453248955922) | ||
108782 | 108782 | 15977 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5937 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1995 12:00:00 AM | 6 | 3X3 | 5996505.5077599995 | 2086284.06053 | 37.7083386912237 | -122.453818737586 | (37.7083386912237, -122.453818737586) | ||
81738 | 81738 | 16859 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 150 Oak St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2012 12:00:00 AM | 3 | 4X4 | Permit Number 768229 | 6006257.87931 | 2110498.54999 | 37.7753805408795 | -122.421832203671 | (37.7753805408795, -122.421832203671) | |
18695 | 18695 | 16874 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 269 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/21/2015 08:43:00 AM | 3 | 3X3 | 6005705.9301 | 2110300.3269 | 37.7748051262311 | -122.423727430112 | (37.7748051262311, -122.423727430112) | ||
21052 | 21052 | 16925 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 512 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 25 | 6004419.62206 | 2110173.45228 | 37.7743840640969 | -122.42816799305099 | (37.7743840640969, -122.428167993051) | ||||
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) | ||
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) | ||
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) | ||
143672 | 143672 | 18582 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993482.998785401 | 2088541.1278418999 | 37.7143623091404 | -122.46442855867399 | (37.7143623091404, -122.464428558674) | ||
145771 | 145771 | 18583 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993482.998785401 | 2088541.1278418999 | 37.7143623091404 | -122.46442855867399 | (37.7143623091404, -122.464428558674) | ||
88818 | 88818 | 18610 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 615 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778725 | 5992407.5548851 | 2088503.1314627 | 37.7141959284164 | -122.468142922603 | (37.7141959284164, -122.468142922603) | |
86323 | 86323 | 21844 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 217X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2000 12:00:00 AM | 3 | 3X3 | 5994893.74214 | 2111425.45184 | 37.777278145464294 | -122.461210335739 | (37.7772781454643, -122.461210335739) | ||
47439 | 47439 | 21845 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 211X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994919.338930001 | 2111427.06219 | 37.7772840400997 | -122.461121905578 | (37.7772840400997, -122.461121905578) | |||
13984 | 13984 | 21894 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2068 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2003 12:00:00 AM | 3 | 2X3 | 6015677.89854 | 2105976.47682 | 37.7634906462863 | -122.388930084758 | (37.7634906462863, -122.388930084758) | ||
14801 | 14801 | 22531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6619 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2015 08:00:00 AM | 3 | 3X3 | 6012836.07271 | 2089639.80613 | 37.7184756630977 | -122.397613243265 | (37.7184756630977, -122.397613243265) | ||
111482 | 111482 | 22572 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 790X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 3 | 4X4 | 6006221.944519999 | 2112852.52787 | 37.7818419658886 | -122.422123780993 | (37.7818419658886, -122.422123780993) | ||
108601 | 108601 | 22587 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 801 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1997 12:00:00 AM | 6 | 4x4 | 6006166.11327 | 2112793.0062543997 | 37.781675384913605 | -122.422312701127 | (37.7816753849136, -122.422312701127) | ||
104635 | 104635 | 22590 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 801 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/1997 12:00:00 AM | 6 | 4x4 | 6006166.11327 | 2112793.0062543997 | 37.781675384913605 | -122.422312701127 | (37.7816753849136, -122.422312701127) | ||
127549 | 127549 | 22596 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 810X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1997 12:00:00 AM | 3 | 4x4 | 6006111.721580001 | 2112834.13473 | 37.7817852453704 | -122.42250379427601 | (37.7817852453704, -122.422503794276) | ||
90153 | 90153 | 22597 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 810X Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1997 12:00:00 AM | 3 | 4x4 | 6006111.721580001 | 2112834.13473 | 37.7817852453704 | -122.42250379427601 | (37.7817852453704, -122.422503794276) | ||
89102 | 89102 | 22603 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 888 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1997 12:00:00 AM | 6 | 4X4 | 6005725.0 | 2112755.0 | 37.781546136890796 | -122.423836042859 | (37.7815461368908, -122.423836042859) | ||
100477 | 100477 | 22696 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1390 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1997 12:00:00 AM | 6 | 3X3 | 6003467.66311 | 2112468.72246 | 37.780632399020796 | -122.431624898149 | (37.7806323990208, -122.431624898149) | ||
144092 | 144092 | 22698 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1390 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1997 12:00:00 AM | 6 | 3X3 | 6003367.49805 | 2112454.4444 | 37.7805875170515 | -122.43197039694701 | (37.7805875170515, -122.431970396947) | ||
89793 | 89793 | 22701 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003258.39673 | 2112440.37761 | 37.7805427074609 | -122.432346825159 | (37.7805427074609, -122.432346825159) | ||
89638 | 89638 | 22703 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1410 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003133.70477 | 2112422.88036 | 37.7804875932729 | -122.432776943127 | (37.7804875932729, -122.432776943127) | ||
88088 | 88088 | 22706 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1420 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003033.98605 | 2112410.1866099997 | 37.7804470833639 | -122.433121009687 | (37.7804470833639, -122.433121009687) |
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");