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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
163 | 163 | 29943 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 242 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:23:00 PM | 3 | 3x3 | 5994593.32204167 | 2088106.90572275 | 37.7132339790874 | -122.460559423837 | (37.7132339790874, -122.460559423837) | ||
628 | 628 | 251337 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
629 | 629 | 251338 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
2333 | 2333 | 253025 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1754 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2017 12:00:00 AM | 3 | 5993444.58369 | 2103545.63859 | 37.7555587516047 | -122.465650780273 | (37.7555587516047, -122.465650780273) | |||
2988 | 2988 | 118173 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3221 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/2008 12:00:00 AM | 2 | Width 3ft | 5985542.20124 | 2111089.15517 | 37.7758121588594 | -122.49353507754299 | (37.7758121588594, -122.493535077543) | ||
4745 | 4745 | 253432 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:09:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
4788 | 4788 | 253430 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:04:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
4805 | 4805 | 253431 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:07:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
9732 | 9732 | 106018 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5285 DIAMOND HEIGHTS BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2016 07:34:00 AM | 3 | 3x3 | 6001339.5 | 2099171.1 | 37.7439995285584 | -122.438034420154 | (37.7439995285584, -122.438034420154) | ||
11259 | 11259 | 25305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 12 | 3X3 | 5999583.38871 | 2091602.23425 | 37.7231171747905 | -122.443563033915 | (37.7231171747905, -122.443563033915) | ||
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) | |||
11707 | 11707 | 28306 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000533.35164 | 2093598.6883900003 | 37.7286531126447 | -122.440422323457 | (37.7286531126447, -122.440422323457) | |||
11724 | 11724 | 25307 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 355 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 6 | 3X3 | 5999438.14042 | 2091535.09661 | 37.7229245454182 | -122.444060305044 | (37.7229245454182, -122.444060305044) | ||
12474 | 12474 | 28305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000543.0489 | 2093613.5897099997 | 37.7286945803894 | -122.440389867794 | (37.7286945803894, -122.440389867794) | |||
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) | ||
14420 | 14420 | 27150 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1735 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011122.20395 | 2095139.1072200001 | 37.73348002049129 | -122.403924187157 | (37.7334800204913, -122.403924187157) | |||
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) | ||
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) | |||
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) | |
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) | ||
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) | ||
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) | ||
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) | ||
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) | |||
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) | ||
19508 | 19508 | 90355 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 745 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993230.153419999 | 2111367.69142 | 37.777023672198794 | -122.46696097646699 | (37.7770236721988, -122.466960976467) | ||
19807 | 19807 | 93394 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3077 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996268.61185 | 2111428.40102 | 37.777365269924296 | -122.456454460594 | (37.7773652699243, -122.456454460594) | ||
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) | |||
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) | ||
20752 | 20752 | 27680 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 06:28:00 AM | 3 | 3x3 | 6005461.15776 | 2107102.0666400003 | 37.7660096518439 | -122.42434662439501 | (37.7660096518439, -122.424346624395) | ||
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) | ||
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) | ||
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) | ||
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) | ||
22160 | 22160 | 24821 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 12 | 3x3 | 6007884.87342 | 2094945.99869 | 37.7327683887373 | -122.41510292745701 | (37.7327683887373, -122.415102927457) | ||
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) | ||
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) | ||
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) | |||
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) | ||||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | ||
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) | ||
69274 | 69274 | 25308 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 279X Ocean Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2011 12:00:00 AM | 3 | 3x3 | 6000039.97311 | 2091577.8604700002 | 37.7230762793257 | -122.44198296803499 | (37.7230762793257, -122.441982968035) | ||
78025 | 78025 | 90206 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2200 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988691.79386 | 2111261.40523 | 37.7764688498652 | -122.482652592467 | (37.7764688498652, -122.482652592467) | ||
78212 | 78212 | 93369 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
78430 | 78430 | 90143 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 342 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5994483.16529 | 2111468.25725 | 37.7773720407512 | -122.462633748637 | (37.7773720407512, -122.462633748637) | ||
78532 | 78532 | 90359 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 641 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993550.82948 | 2111377.87735 | 37.7770701435768 | -122.46585240779699 | (37.7770701435768, -122.465852407797) | ||
78607 | 78607 | 89592 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4617 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984322.41803 | 2111726.32769 | 37.777490220874 | -122.497801611618 | (37.777490220874, -122.497801611618) | ||
78696 | 78696 | 89608 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4215 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985569.57732 | 2111771.09823 | 37.7776861810077 | -122.493490635217 | (37.7776861810077, -122.493490635217) | ||
78777 | 78777 | 25313 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 131 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/1998 12:00:00 AM | 3 | 3X3 | 6000709.1204 | 2091674.68705 | 37.723380252154605 | -122.439676803494 | (37.7233802521546, -122.439676803494) | ||
79018 | 79018 | 23248 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 780X Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 3 | 4X4 | 6006390.8680300005 | 2112872.55343 | 37.78190647743279 | -122.421540805947 | (37.7819064774328, -122.421540805947) | ||
79386 | 79386 | 89701 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992461.7466589995 | 2112025.799575 | 37.7787862776475 | -122.469667031742 | (37.7787862776475, -122.469667031742) | ||
79745 | 79745 | 89696 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2101 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992083.25787 | 2112006.9207200003 | 37.778712558544996 | -122.470974985133 | (37.778712558545, -122.470974985133) | ||
79807 | 79807 | 90353 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 833 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992966.98928 | 2111358.80702 | 37.7769840852214 | -122.467870688698 | (37.7769840852214, -122.467870688698) | ||
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) | ||
81338 | 81338 | 29886 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1332 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005784.3311963 | 2101201.415557 | 37.7498260853424 | -122.422809442933 | (37.7498260853424, -122.422809442933) | |||
81699 | 81699 | 90315 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2223 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2013 12:00:00 AM | 3 | 3x3 | 5988645.63956 | 2111200.47975 | 37.776298880204 | -122.48280778540399 | (37.776298880204, -122.482807785404) | ||
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) | |
82258 | 82258 | 40838 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 301 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2001 12:00:00 AM | 3 | 3x3 | Permit Number 44013 | 6005924.40984 | 2110798.1609400003 | 37.776184388733 | -122.423007053797 | (37.776184388733, -122.423007053797) | |
83003 | 83003 | 22765 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1674 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 6 | 4X4 | 6002010.254376 | 2112254.96617 | 37.7799627627699 | -122.436651458736 | (37.7799627627699, -122.436651458736) | ||
83556 | 83556 | 90922 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4601 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5984359.943030001 | 2111727.94801 | 37.777496869554206 | -122.497671921843 | (37.7774968695542, -122.497671921843) | ||
83604 | 83604 | 93385 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3156 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5995879.45321 | 2111435.47315 | 37.7773623389565 | -122.457801190599 | (37.7773623389565, -122.457801190599) | ||
83727 | 83727 | 89413 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2040 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992290.09129 | 2112070.56721 | 37.778899274659096 | -122.47026411052099 | (37.7788992746591, -122.470264110521) | ||
83975 | 83975 | 90374 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 341 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5994576.425455 | 2111424.277156 | 37.77725665365 | -122.462307943077 | (37.77725665365, -122.462307943077) | ||
84148 | 84148 | 89695 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2155 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992032.589849 | 2112010.420559 | 37.7787192375961 | -122.47115051893299 | (37.7787192375961, -122.471150518933) | ||
84204 | 84204 | 89610 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4201X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2015 07:01:00 AM | 3 | 3x3 | 5985601.86481 | 2111772.70436 | 37.7776924796275 | -122.49337906174401 | (37.7776924796275, -122.493379061744) | ||
84485 | 84485 | 89706 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1945X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992682.1024279995 | 2112033.696052 | 37.7788206927431 | -122.46890531620701 | (37.7788206927431, -122.468905316207) | ||
85182 | 85182 | 90139 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 236 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5994897.044563 | 2111475.9309630003 | 37.7774169377561 | -122.46120257165899 | (37.7774169377561, -122.461202571659) | ||
85717 | 85717 | 89409 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2020 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992384.83285 | 2112073.6126 | 37.7789131134856 | -122.46993658655899 | (37.7789131134856, -122.469936586559) | ||
85816 | 85816 | 93373 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
85908 | 85908 | 89598 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4417 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984943.344959999 | 2111748.4465099997 | 37.777587333707 | -122.49565528309999 | (37.777587333707, -122.4956552831) | ||
86128 | 86128 | 89417 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2130 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992009.84673 | 2112059.57009 | 37.7788528732841 | -122.471232777372 | (37.7788528732841, -122.471232777372) | ||
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) | ||
86328 | 86328 | 89697 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2101 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992123.80409 | 2112006.3291599997 | 37.7787132792189 | -122.470834678186 | (37.7787132792189, -122.470834678186) | ||
87722 | 87722 | 89704 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992461.7466589995 | 2112025.799575 | 37.7787862776475 | -122.469667031742 | (37.7787862776475, -122.469667031742) | ||
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) | ||
87987 | 87987 | 90154 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 638 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775919 | 5993572.64081 | 2111433.85169 | 37.7772250922406 | -122.465781024081 | (37.7772250922406, -122.465781024081) | |
88106 | 88106 | 89406 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2016 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992454.35988 | 2112065.560542 | 37.778895023507204 | -122.469695480685 | (37.7788950235072, -122.469695480685) | ||
88778 | 88778 | 90363 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 543 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993861.50158 | 2111388.2205 | 37.7771164594528 | -122.464778455731 | (37.7771164594528, -122.464778455731) | ||
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) | ||
89088 | 89088 | 93359 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
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) | ||
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) | ||
89845 | 89845 | 90210 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2326 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5988313.82257 | 2111246.42734 | 37.77640572777071 | -122.483958988115 | (37.7764057277707, -122.483958988115) | ||
90058 | 90058 | 90371 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 399X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5994452.72009 | 2111411.69669 | 37.7772149871382 | -122.462734963613 | (37.7772149871382, -122.462734963613) | ||
90093 | 90093 | 26175 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1780X Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/1997 12:00:00 AM | 3 | 4X4 | 6001669.86946 | 2112366.9914599997 | 37.78025100635529 | -122.437837026039 | (37.7802510063553, -122.437837026039) | ||
90518 | 90518 | 27611 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1785 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6001483.34096 | 2112120.46472 | 37.7795634979855 | -122.438464644811 | (37.7795634979855, -122.438464644811) | ||
90937 | 90937 | 90360 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 641 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993581.05405 | 2111379.84926 | 37.7770773013831 | -122.46574799571998 | (37.7770773013831, -122.46574799572) | ||
91662 | 91662 | 89403 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1920 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992698.73667 | 2112085.38755 | 37.77896358458921 | -122.468851534899 | (37.7789635845892, -122.468851534899) | ||
91755 | 91755 | 93388 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3155 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5995895.97504 | 2111374.7132900003 | 37.777196457569104 | -122.457739638948 | (37.7771964575691, -122.457739638948) | ||
92071 | 92071 | 89399 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5993250.39877 | 2112105.36057 | 37.7790502810604 | -122.466944583124 | (37.7790502810604, -122.466944583124) | ||
92130 | 92130 | 90148 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 560 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993848.25237 | 2111446.61829 | 37.777276040241794 | -122.464828530497 | (37.7772760402418, -122.464828530497) | ||
92169 | 92169 | 86485 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2016 10:49:00 AM | 3 | 3x3 | 5987816.321957 | 2103904.0922479997 | 37.7562167246282 | -122.48514111531401 | (37.7562167246282, -122.485141115314) | ||
92194 | 92194 | 26649 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1686 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/1998 12:00:00 AM | 6 | 4X4 | 6001954.59403 | 2112257.165987 | 37.7799656396512 | -122.43684416995899 | (37.7799656396512, -122.436844169959) | ||
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) |
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");