Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13159 | 13159 | 24265 | DPW Maintained 3 | Ilex aquifolium :: European Holly 277 | 300X Winding Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6001546.70936 | 2086492.80474 | 37.7091995959417 | -122.43641072479299 | (37.7091995959417, -122.436410724793) | |||
25153 | 25153 | 219212 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1501 15th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5991536.71945 | 2105150.6616 | 37.759855492149704 | -122.47236570472 | (37.7598554921497, -122.47236570472) | ||||
26406 | 26406 | 176582 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 73 Rome St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 5999180.63064 | 2089309.9318 | 37.716800059761 | -122.444790591436 | (37.716800059761, -122.444790591436) | |||
28551 | 28551 | 129092 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1900 Jefferson St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6000026.03415 | 2121296.93022 | 37.804676658877 | -122.44416565702299 | (37.804676658877, -122.444165657023) | |||
33067 | 33067 | 123327 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 799 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5994722.27154 | 2110327.13092 | 37.774252578490895 | -122.46172384868 | (37.7742525784909, -122.46172384868) | |||
36347 | 36347 | 31116 | Permitted Site 1 | Ilex aquifolium :: European Holly 277 | 450 Edna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34839 | 5998791.95138 | 2094335.49695 | 37.7305769072785 | -122.44649541105 | (37.7305769072785, -122.44649541105) | |
38116 | 38116 | 187373 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2200 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985059.3798 | 2099964.1519 | 37.7452377461236 | -122.494385008531 | (37.7452377461236, -122.494385008531) | |||
41613 | 41613 | 228518 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 481 Collingwood St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 8ft | 6002169.605269999 | 2103070.00392 | 37.7547521677948 | -122.435442960743 | (37.7547521677948, -122.435442960743) | |||
44543 | 44543 | 187350 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2200 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985075.63 | 2099747.1439 | 37.7446428520051 | -122.494312826072 | (37.7446428520051, -122.494312826072) | |||
46432 | 46432 | 219218 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 236 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996554.196830001 | 2096190.9864599998 | 37.7355435643808 | -122.454365596805 | (37.7355435643808, -122.454365596805) | |||
50274 | 50274 | 129093 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2300 Buchanan St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 4ft | 6003774.233990001 | 2116329.43103 | 37.791250305001604 | -122.430839922948 | (37.7912503050016, -122.430839922948) | |||
53273 | 53273 | 219211 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1500 15th Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 5991550.42376 | 2105114.9224099996 | 37.759758154937295 | -122.472315703333 | (37.7597581549373, -122.472315703333) | ||||
56520 | 56520 | 186904 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2700 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985178.7162 | 2096676.5876 | 37.7362179620334 | -122.49373015657301 | (37.7362179620334, -122.493730156573) | |||
56737 | 56737 | 31119 | Permitted Site 1 | Ilex aquifolium :: European Holly 277 | 450 Edna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 3 | Permit Number 34839 | 5998792.289480001 | 2094318.72363 | 37.730530870996795 | -122.446493035923 | (37.7305308709968, -122.446493035923) | |
60182 | 60182 | 186649 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1401 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984709.2247 | 2105588.4095 | 37.7606599076515 | -122.49601061117399 | (37.7606599076515, -122.496010611174) | |||
61467 | 61467 | 35135 | Permitted Site 1 | Ilex aquifolium :: European Holly 277 | 955 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 3 | Permit Number 38665 | 6001284.487919999 | 2088716.26043 | 37.7152898093492 | -122.437476116536 | (37.7152898093492, -122.437476116536) | |
68166 | 68166 | 185130 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2234 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5985857.4199 | 2097290.435 | 37.7379431071995 | -122.49142879945299 | (37.7379431071995, -122.491428799453) | |||
68524 | 68524 | 187352 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2200 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985089.5104 | 2099749.8522 | 37.744651100545 | -122.49426503067 | (37.744651100545, -122.49426503067) | |||
71800 | 71800 | 228515 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 401 College Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6005446.976009999 | 2095265.13245 | 37.733507355381704 | -122.423554041084 | (37.7335073553817, -122.423554041084) | ||||
72684 | 72684 | 219223 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 40 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999838.93392 | 2095529.37705 | 37.733914768954705 | -122.44296155113399 | (37.7339147689547, -122.442961551134) | ||||
73111 | 73111 | 219221 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 637 Detroit St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5999418.99501 | 2095214.0147799999 | 37.7330249068638 | -122.444390746559 | (37.7330249068638, -122.444390746559) | |||
75901 | 75901 | 219219 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 794 Myra Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5997010.11331 | 2098064.42835 | 37.7407137173719 | -122.452924513261 | (37.7407137173719, -122.452924513261) | |||
77065 | 77065 | 186877 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2700 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985187.8846 | 2096422.1638 | 37.7355199185041 | -122.49367971605801 | (37.7355199185041, -122.493679716058) | |||
84472 | 84472 | 101657 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 320 Santa Ana Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992576.9 | 2094712.8 | 37.7312559376124 | -122.46800901581001 | (37.7312559376124, -122.46800901581) | |||||
112949 | 112949 | 102366 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 3500 Ocean Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769587 | 5988245.5 | 2095259.3 | 37.7325053993107 | -122.483023305965 | (37.7325053993107, -122.483023305965) | ||||
116424 | 116424 | 176581 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 73 Rome St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 5999177.5283699995 | 2089304.00543 | 37.7167836102589 | -122.444800888669 | (37.7167836102589, -122.444800888669) | |||
129784 | 129784 | 187250 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2401 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984969.0816 | 2098484.8841 | 37.7411707921202 | -122.494588207182 | (37.7411707921202, -122.494588207182) | |||
130756 | 130756 | 187349 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2200 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985068.182 | 2099744.774 | 37.7446359090366 | -122.494338404757 | (37.7446359090366, -122.494338404757) | |||
130813 | 130813 | 187351 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2200 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985081.7238 | 2099746.1282 | 37.744640419780296 | -122.494291680367 | (37.7446404197803, -122.494291680367) | |||
131537 | 131537 | 228517 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1455 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003317.07377 | 2099786.4177200003 | 37.7458013134871 | -122.43124033439501 | (37.7458013134871, -122.431240334395) | |||
134624 | 134624 | 219213 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 469 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5993686.15649 | 2101835.46425 | 37.75087698278529 | -122.46469117276199 | (37.7508769827853, -122.464691172762) | |||
141435 | 141435 | 104808 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 08th Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5993673.5 | 2104163.7 | 37.7572689897716 | -122.46490400670099 | (37.7572689897716, -122.464904006701) | |||||
142961 | 142961 | 104761 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
144810 | 144810 | 104762 | Significant Tree 6 | Ilex aquifolium :: European Holly 277 | 1665 18TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 9x9 | 5990543.2 | 2104073.0 | 37.756838968238 | -122.475723071248 | (37.756838968238, -122.475723071248) | ||||
148624 | 148624 | 219220 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 339 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5995728.61032 | 2098498.49614 | 37.7418320387208 | -122.457386831458 | (37.7418320387208, -122.457386831458) | |||
149954 | 149954 | 228522 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 310 Liberty St | 56 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003800.93288 | 2103921.01523 | 37.757181357156 | -122.429862082891 | (37.757181357156, -122.429862082891) | |||
153662 | 153662 | 249608 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2280 Golden Gate Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 5998619.056030001 | 2111460.79154 | 37.7775888638845 | -122.44832587496401 | (37.7775888638845, -122.448325874964) | |||
155039 | 155039 | 187118 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2600 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985152.642000001 | 2097311.0158 | 37.7379584068097 | -122.49386704382799 | (37.7379584068097, -122.493867043828) | |||
155349 | 155349 | 219222 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 637 Detroit St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5999422.43072 | 2095182.75429 | 37.7329392689295 | -122.444376622689 | (37.7329392689295, -122.444376622689) | |||
157171 | 157171 | 228516 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 592 Duncan St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6002757.83463 | 2099794.05926 | 37.7457905872828 | -122.43317464749501 | (37.7457905872828, -122.433174647495) | ||||
159352 | 159352 | 185625 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2100 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985035.9868 | 2100295.8961 | 37.7461472565236 | -122.494490347109 | (37.7461472565236, -122.494490347109) | |||
160938 | 160938 | 228520 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 310 Liberty St | 33 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6003938.215559999 | 2103926.08687 | 37.757203055998396 | -122.429387668006 | (37.7572030559984, -122.429387668006) | |||
161320 | 161320 | 187338 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2200 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985073.9372 | 2099688.9139 | 37.7444828691431 | -122.49431438801001 | (37.7444828691431, -122.49431438801) | |||
164858 | 164858 | 219214 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 1062 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5995950.83208 | 2090962.8280900002 | 37.72115367597579 | -122.45607378170601 | (37.7211536759758, -122.456073781706) | |||
165205 | 165205 | 190676 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2101 22nd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6011856.35209 | 2103704.31604 | 37.7570392328013 | -122.401987930592 | (37.7570392328013, -122.401987930592) | |||
166263 | 166263 | 219217 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 480 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5993017.759980001 | 2090453.6161599997 | 37.7195867116451 | -122.46617549302401 | (37.7195867116451, -122.466175493024) | |||
166915 | 166915 | 186857 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2700 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985213.3270000005 | 2096310.5382 | 37.735214912745704 | -122.49358353093099 | (37.7352149127457, -122.493583530931) | |||
168791 | 168791 | 219216 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 295 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5991929.69954 | 2090465.1199400001 | 37.7195554620061 | -122.46993732656901 | (37.7195554620061, -122.469937326569) | |||
169884 | 169884 | 187100 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2600 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985160.6358 | 2097204.2758 | 37.737665795033 | -122.493831541979 | (37.737665795033, -122.493831541979) | |||
171686 | 171686 | 176580 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 201 Rome St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5998646.1517 | 2088835.03297 | 37.715465580043706 | -122.44660386659099 | (37.7154655800437, -122.446603866591) | |||
175269 | 175269 | 219224 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 40 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5999832.51294 | 2095529.9233900001 | 37.7339159029868 | -122.442983789566 | (37.7339159029868, -122.442983789566) | ||||
177225 | 177225 | 187356 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2200 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985052.9474 | 2099788.1079 | 37.7447540006126 | -122.494394275911 | (37.7447540006126, -122.494394275911) | |||
181241 | 181241 | 228519 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 310 Liberty St | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6003946.927 | 2103927.0362400003 | 37.7572061559445 | -122.42935760817 | (37.7572061559445, -122.42935760817) | |||
181454 | 181454 | 176583 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 955 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001286.22668 | 2088718.58133 | 37.715296280877794 | -122.43747027273399 | (37.7152962808778, -122.437470272734) | |||
183633 | 183633 | 219215 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 446 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 5994049.54462 | 2089400.1465099999 | 37.7167536115793 | -122.462532639778 | (37.7167536115793, -122.462532639778) | |||
184498 | 184498 | 228514 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 200 Kingston St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006246.808619999 | 2098039.50803 | 37.7411702869721 | -122.420985702322 | (37.7411702869721, -122.420985702322) | ||||
184822 | 184822 | 186959 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 2800 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985201.4594 | 2096118.1669 | 37.734686018108604 | -122.49361039067101 | (37.7346860181086, -122.493610390671) | |||
187821 | 187821 | 54669 | Permitted Site 1 | Ilex aquifolium :: European Holly 277 | 287 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1993 12:00:00 AM | 20 | Permit Number 31959 | 6012184.41034 | 2087347.4133099997 | 37.7121449026495 | -122.399704913465 | (37.7121449026495, -122.399704913465) | ||
188345 | 188345 | 228521 | Undocumented 2 | Ilex aquifolium :: European Holly 277 | 310 Liberty St | 55 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003807.77119 | 2103922.75586 | 37.757186523762 | -122.429838557529 | (37.757186523762, -122.429838557529) |
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");