Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16947 | 16947 | 29712 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594X Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005909.34325 | 2099821.5035900003 | 37.7460442149832 | -122.422279116311 | (37.7460442149832, -122.422279116311) | |||
17074 | 17074 | 29980 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1622X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005918.535069999 | 2099515.50587 | 37.7452045332674 | -122.422225595834 | (37.7452045332674, -122.422225595834) | ||
17267 | 17267 | 29992 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005877.58141 | 2099371.3233 | 37.7448063305595 | -122.42235696431601 | (37.7448063305595, -122.422356964316) | ||
17337 | 17337 | 30016 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005691.5289199995 | 2098774.02454 | 37.7431557868143 | -122.422957855325 | (37.7431557868143, -122.422957855325) | ||
17567 | 17567 | 30007 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005678.3438 | 2098731.5578099997 | 37.7430384387857 | -122.42300042833 | (37.7430384387857, -122.42300042833) | ||
17655 | 17655 | 30017 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005697.924 | 2098794.2110900003 | 37.743211575362004 | -122.42293717722201 | (37.743211575362, -122.422937177222) | ||
17852 | 17852 | 29994 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005883.229830001 | 2099389.42314 | 37.744856347235896 | -122.422338718883 | (37.7448563472359, -122.422338718883) | ||
18460 | 18460 | 29998 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005888.8207 | 2099404.7215 | 37.7448986684345 | -122.42232047341601 | (37.7448986684345, -122.422320473416) | ||
18498 | 18498 | 30012 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 738X San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005734.30948 | 2098905.3013 | 37.743518656953 | -122.422819258997 | (37.743518656953, -122.422819258997) | ||
18873 | 18873 | 29989 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005863.98756 | 2099326.06351 | 37.74468129061479 | -122.42240075410801 | (37.7446812906148, -122.422400754108) | ||
18978 | 18978 | 15065 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1X Minerva St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996005.0253 | 2089004.0026599998 | 37.7157783129984 | -122.45574493019501 | (37.7157783129984, -122.455744930195) | |||
19193 | 19193 | 30011 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 795X San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/02/2013 12:00:00 AM | 3 | 3x3 | 6005625.43803 | 2098570.80228 | 37.7425940549807 | -122.423171938039 | (37.7425940549807, -122.423171938039) | ||
19921 | 19921 | 29988 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005860.9876 | 2099317.01753 | 37.7446562831756 | -122.42241048477501 | (37.7446562831756, -122.422410484775) | ||
19973 | 19973 | 29997 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005888.0743 | 2099402.63475 | 37.7448928965893 | -122.422322906097 | (37.7448928965893, -122.422322906097) | ||
20201 | 20201 | 30009 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005685.14822 | 2098754.53828 | 37.7431019219116 | -122.422978533436 | (37.7431019219116, -122.422978533436) | ||
20445 | 20445 | 29981 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1622X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005920.83177 | 2099524.56663 | 37.7452295416039 | -122.422218297841 | (37.7452295416039, -122.422218297841) | ||
20506 | 20506 | 29709 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005913.75363 | 2099762.2133 | 37.745881666108204 | -122.422259654058 | (37.7458816661082, -122.422259654058) | |||
20584 | 20584 | 29990 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005867.00191 | 2099335.81011 | 37.7447082226084 | -122.422391023449 | (37.7447082226084, -122.422391023449) | ||
20690 | 20690 | 29987 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 688X San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005801.21502 | 2099130.13322 | 37.7441397692444 | -122.42260388936 | (37.7441397692444, -122.42260388936) | ||
20739 | 20739 | 29982 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1622X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005921.74385 | 2099534.70656 | 37.7452574349955 | -122.422215864289 | (37.7452574349955, -122.422215864289) | ||
20960 | 20960 | 29713 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594X Guerrero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005909.200119999 | 2099831.66519 | 37.7460721083515 | -122.422280333079 | (37.7460721083515, -122.422280333079) | |||
21484 | 21484 | 30010 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005675.35784 | 2098723.21181 | 37.7430153540666 | -122.423010159912 | (37.7430153540666, -122.423010159912) | ||
21551 | 21551 | 30008 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750X San Jose Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005682.80795 | 2098743.3766799998 | 37.743071142629795 | -122.422985832334 | (37.7430711426298, -122.422985832334) | ||
21719 | 21719 | 29996 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005885.11752 | 2099395.68964 | 37.7448736601053 | -122.422332636749 | (37.7448736601053, -122.422332636749) | ||
21854 | 21854 | 30013 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 738X San Jose Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005738.10231 | 2098921.33618 | 37.7435628991021 | -122.42280728365101 | (37.7435628991021, -122.422807283651) | ||
22277 | 22277 | 29993 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681X San Jose Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005880.60295 | 2099381.4202099997 | 37.7448342248263 | -122.422347233647 | (37.7448342248263, -122.422347233647) | ||
22281 | 22281 | 29985 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 688X San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005799.980169999 | 2099121.4011 | 37.744115723156796 | -122.422607538818 | (37.7441157231568, -122.422607538818) | ||
29945 | 29945 | 205329 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 0ft | 5996217.253769999 | 2089002.70313 | 37.715786922192294 | -122.455011281241 | (37.7157869221923, -122.455011281241) | |||
39663 | 39663 | 189307 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1510x 22nd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6013533.7803 | 2103828.56548 | 37.757473872449296 | -122.396195412608 | (37.7574738724493, -122.396195412608) | |||
46886 | 46886 | 175915 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 350x Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6000968.48443 | 2086648.8804900001 | 37.7095952724697 | -122.43842033004299 | (37.7095952724697, -122.438420330043) | |||
53588 | 53588 | 5008 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5300 Diamond Heights Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
54360 | 54360 | 205288 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100x Casitas Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 4ft | 5995094.0197 | 2097032.76312 | 37.73777102860689 | -122.459474894452 | (37.7377710286069, -122.459474894452) | |||
60555 | 60555 | 245665 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681x San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005853.52339 | 2099296.15265 | 37.744598571882 | -122.42243481233 | (37.744598571882, -122.42243481233) | |||
74580 | 74580 | 245662 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750x San Jose Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005689.97131 | 2098766.69991 | 37.743135587148 | -122.422962720654 | (37.743135587148, -122.422962720654) | |||
83652 | 83652 | 29661 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 198X Cashmere St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806341998 | 37.736789378374795 | -122.386594949018 | (37.7367893783748, -122.386594949018) | ||
84169 | 84169 | 24382 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1450 Holloway Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 5X5 | 5990869.899656599 | 2091172.9547398 | 37.7214376817414 | -122.47365223988199 | (37.7214376817414, -122.473652239882) | |||
89216 | 89216 | 122588 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2500X Lyon St | 8 | Median : Cutout 11 | Tree 1 | Private 1 | 13 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
90701 | 90701 | 4979 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5200X Diamond Heights Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
91798 | 91798 | 29656 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 190X Cashmere St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016261.8205744 | 2096260.7089353001 | 37.7368455183428 | -122.386233075665 | (37.7368455183428, -122.386233075665) | ||
92390 | 92390 | 29660 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 198X Cashmere St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806341998 | 37.736789378374795 | -122.386594949018 | (37.7367893783748, -122.386594949018) | ||
97678 | 97678 | 29662 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 198X Cashmere St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806341998 | 37.736789378374795 | -122.386594949018 | (37.7367893783748, -122.386594949018) | ||
98125 | 98125 | 102273 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100X Casitas Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6x14 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
105709 | 105709 | 122583 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2500X Lyon St | 3 | Median : Cutout 11 | Tree 1 | Private 1 | 20 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
116777 | 116777 | 5007 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5300 Diamond Heights Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
119712 | 119712 | 122589 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2500X Lyon St | 9 | Median : Cutout 11 | Tree 1 | Private 1 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | ||||
129000 | 129000 | 5006 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5300 Diamond Heights Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
139909 | 139909 | 27694 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 600X El Camino Del Mar | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
140574 | 140574 | 29658 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 198X Cashmere St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806341998 | 37.736789378374795 | -122.386594949018 | (37.7367893783748, -122.386594949018) | ||
145480 | 145480 | 29659 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 198X Cashmere St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 3X3 | 6016156.786904 | 2096242.3806341998 | 37.736789378374795 | -122.386594949018 | (37.7367893783748, -122.386594949018) | ||
147815 | 147815 | 245663 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 750x San Jose Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005696.33761 | 2098785.48588 | 37.7431875283974 | -122.422942042552 | (37.7431875283974, -122.422942042552) | |||
150311 | 150311 | 245672 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594x Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 6005912.3551 | 2099779.75668 | 37.7459297573535 | -122.422265736192 | (37.7459297573535, -122.422265736192) | |||
158532 | 158532 | 205332 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5996356.8338 | 2088999.78722 | 37.7157869222184 | -122.454528620522 | (37.7157869222184, -122.454528620522) | |||
167470 | 167470 | 205331 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5996300.3893099995 | 2089001.53161 | 37.715788474438206 | -122.45472384354099 | (37.7157884744382, -122.454723843541) | |||
167691 | 167691 | 245666 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 681x San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005857.27695 | 2099307.6356900004 | 37.744630313449 | -122.422422649005 | (37.744630313449, -122.422422649005) | |||
173817 | 173817 | 245664 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 738x San Jose Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005721.51625 | 2098863.78747 | 37.743403947541296 | -122.42286054508001 | (37.7434039475413, -122.42286054508) | |||
175826 | 175826 | 205330 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1x Minerva St | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5996263.21296 | 2089001.7429400003 | 37.715786922213 | -122.45485235667 | (37.715786922213, -122.45485235667) | |||
177475 | 177475 | 126129 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2800x Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6005644.09156 | 2120125.76706 | 37.8017798472085 | -122.424640432904 | (37.8017798472085, -122.424640432904) | |||
182784 | 182784 | 245673 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1594x Guerrero St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005908.33244 | 2099840.7906299997 | 37.7460971157901 | -122.422283981647 | (37.7460971157901, -122.422283981647) |
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");