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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
104270 | 104270 | 75029 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
104340 | 104340 | 74892 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.713456663779795 | -122.40566649087499 | (37.7134566637798, -122.405666490875) | |
100092 | 100092 | 112520 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 146x ARLETA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010471.0 | 2087928.0 | 37.7136434126305 | -122.40566785728501 | (37.7136434126305, -122.405667857285) | ||||
111595 | 111595 | 112521 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 146x ARLETA AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010471.0 | 2087928.0 | 37.7136434126305 | -122.40566785728501 | (37.7136434126305, -122.405667857285) | ||||
4501 | 4501 | 162764 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 919 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 10:56:00 AM | 3 | Width 0ft | 5995008.1104 | 2090049.4028900003 | 37.7185914714977 | -122.459266363268 | (37.7185914714977, -122.459266363268) | ||
4474 | 4474 | 162754 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 997x Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2017 11:43:00 AM | 3 | Width 0ft | 5995095.0 | 2090528.0 | 37.719910580533295 | -122.45900065774599 | (37.7199105805333, -122.459000657746) | ||
4152 | 4152 | 216685 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.8719900001 | 37.720244788744104 | -122.46233566126101 | (37.7202447887441, -122.462335661261) | ||
105773 | 105773 | 102005 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1703 CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624.0 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | |
120000 | 120000 | 102006 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1703 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624.0 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | |
87337 | 87337 | 117270 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 481 JERSEY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6002050.0 | 2101440.0 | 37.750269772538296 | -122.435739974128 | (37.7502697725383, -122.435739974128) | |||
78461 | 78461 | 113802 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 806 SHOTWELL ST | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007931.0 | 2103220.0 | 37.755489548438 | -122.41552904166201 | (37.755489548438, -122.415529041662) | |||||
97623 | 97623 | 100396 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 500X Oak Park Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/18/2012 12:00:00 AM | 3 | 3x9 | Permit Number 769101 | 5994983.3 | 2103652.8 | 37.755941622135296 | -122.460337221652 | (37.7559416221353, -122.460337221652) | |
112828 | 112828 | 99931 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 801X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2012 12:00:00 AM | 3x3 | Permit Number 768924 | 6003100.6 | 2103580.4 | 37.756206424442205 | -122.432259777723 | (37.7562064244422, -122.432259777723) | ||
78961 | 78961 | 121107 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1391 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608.0 | 2106030.0 | 37.7623895873424 | -122.46526608917601 | (37.7623895873424, -122.465266089176) | ||
110276 | 110276 | 121108 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1391 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608.0 | 2106030.0 | 37.7623895873424 | -122.46526608917601 | (37.7623895873424, -122.465266089176) | ||
122604 | 122604 | 116372 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1306 10TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x8 | 5993057.0 | 2106542.0 | 37.7637636140689 | -122.46720900630899 | (37.7637636140689, -122.467209006309) | ||||
84703 | 84703 | 100649 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 50 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003141.0 | 2108015.0 | 37.76838505717971 | -122.432436785894 | (37.7683850571797, -122.432436785894) | ||||
120569 | 120569 | 113398 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 603 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998367.0 | 2108846.0 | 37.7703949048055 | -122.44900941031099 | (37.7703949048055, -122.449009410311) | ||||
143509 | 143509 | 113397 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 603 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998367.0 | 2108846.0 | 37.7703949048055 | -122.44900941031099 | (37.7703949048055, -122.449009410311) | ||||
19726 | 19726 | 116259 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
66020 | 66020 | 116255 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
90305 | 90305 | 116261 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
96610 | 96610 | 116253 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
98226 | 98226 | 116254 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
107711 | 107711 | 116260 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
142521 | 142521 | 116257 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
142800 | 142800 | 116256 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
143334 | 143334 | 116258 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 155 LAGUNA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7x6 | 6005176.0 | 2109399.0 | 37.772300372561496 | -122.425496410637 | (37.7723003725615, -122.425496410637) | ||||
81022 | 81022 | 116243 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
81344 | 81344 | 116244 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
85348 | 85348 | 116248 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
86226 | 86226 | 116252 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
92554 | 92554 | 116250 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
100241 | 100241 | 116246 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
102114 | 102114 | 116238 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
102168 | 102168 | 116240 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
104602 | 104602 | 116251 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
107993 | 107993 | 116249 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
108883 | 108883 | 116245 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
113421 | 113421 | 116242 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
114164 | 114164 | 116239 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
119717 | 119717 | 116247 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229 HAIGHT ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
126761 | 126761 | 116241 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 229x HAIGHT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005035.0 | 2109517.0 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | ||||
2783 | 2783 | 252852 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | ||||
2784 | 2784 | 252854 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | ||||
2788 | 2788 | 252853 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 6010166.0 | 2110701.0 | 37.776156040570996 | -122.408327321329 | (37.776156040571, -122.408327321329) | ||||
107040 | 107040 | 119284 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 651 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2016 12:00:00 AM | 3 | 3x3 | 5987187.0 | 2111505.0 | 37.777050030999604 | -122.487875935939 | (37.7770500309996, -122.487875935939) | ||
142331 | 142331 | 119283 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 651 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2016 12:00:00 AM | 3 | 3x3 | 5987187.0 | 2111505.0 | 37.777050030999604 | -122.487875935939 | (37.7770500309996, -122.487875935939) | ||
9791 | 9791 | 116717 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 690X 03RD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 5 | 3x3 | 6014548.0 | 2111604.0 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | ||
140431 | 140431 | 107849 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1300x ANZA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5994625.0 | 2112199.0 | 37.7793866324847 | -122.46219610899901 | (37.7793866324847, -122.462196108999) | |||
3762 | 3762 | 139362 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2869 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999793.3033 | 2114332.6333 | 37.7855412639984 | -122.44447021936199 | (37.7855412639984, -122.444470219362) | |||
79381 | 79381 | 114695 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 799x TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009121.0 | 2115613.0 | 37.7895846457112 | -122.41228952949498 | (37.7895846457112, -122.412289529495) | ||||
82486 | 82486 | 114696 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 799x TAYLOR ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009121.0 | 2115613.0 | 37.7895846457112 | -122.41228952949498 | (37.7895846457112, -122.412289529495) | ||||
141591 | 141591 | 118312 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2410 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002301.0 | 2116562.0 | 37.7918052987456 | -122.435953913571 | (37.7918052987456, -122.435953913571) | ||||
560 | 560 | 131782 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | ||
94824 | 94824 | 111178 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2109 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006363.0 | 2118096.0 | 37.7962471953974 | -122.42200839754801 | (37.7962471953974, -122.422008397548) | ||||
141724 | 141724 | 121042 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2101 Polk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006363.0 | 2118098.0 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | ||||
34237 | 34237 | 143019 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 410 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6010368.5125 | 2120644.4743 | 37.8034697728784 | -122.408328278578 | (37.8034697728784, -122.408328278578) |
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");