Street_Tree_List

Data source: data.sfgov.org

254 rows where qSpecies = 105

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PermitNotes

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
697	697	251362	Undocumented 2	Pinus Spp :: Pine Spp 105	1300X Stanyan St	1	Unaccepted Street : Yard 14	Tree 1	Private 1				3x3		5997565.0	2104877.0	37.7594511396077	-122.451497194349	(37.7594511396077, -122.451497194349)
812	812	19648	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	47	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
1052	1052	187279	DPW Maintained 3	Pinus Spp :: Pine Spp 105	2401 Sunset Blvd	62	Median : Yard 3	Tree 1	DPW 2			4	Width 0ft		5984952.4466	2098301.7622	37.7406670151021	-122.494632227246	(37.7406670151021, -122.494632227246)
1221	1221	19739	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
1378	1378	19687	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	86	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
1393	1393	19861	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY30	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	30ST
2077	2077	19994	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY46	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
2510	2510	19722	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY13	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
3176	3176	19993	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY46	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
4353	4353	20010	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY47	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
4922	4922	253717	Significant Tree 6	Pinus Spp :: Pine Spp 105	4101 Balboa St	1	Back Yard : Yard 13	Tree 1	Private 1						5982822.0	2110967.0	37.7753172554615	-122.50293574331002	(37.7753172554615, -122.50293574331)
5308	5308	19644	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	43	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
5387	5387	19659	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	58	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60ST
5459	5459	19727	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	40ST
5491	5491	19654	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	53	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
5726	5726	19857	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY30	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	30ST
5788	5788	19610	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
5861	5861	19728	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	40ST
5905	5905	19989	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY46	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40
5963	5963	19716	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY13	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
5975	5975	19717	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY13	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
6263	6263	19679	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	78	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
6288	6288	19736	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
6376	6376	19732	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
6511	6511	19865	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY30	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
6668	6668	19738	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
6687	6687	20012	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY47	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	100ST
6806	6806	19743	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY15	-8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	1OST
6907	6907	19603	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
7097	7097	19984	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY46	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	40
7220	7220	19937	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY38	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
7321	7321	19676	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	75	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7322	7322	19681	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	80	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7622	7622	19686	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	85	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7785	7785	19757	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY15	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	20ST
7790	7790	19614	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
7815	7815	19733	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
7954	7954	19613	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
7972	7972	19791	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY19	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	20ST
7996	7996	19970	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY44	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	15
8061	8061	19756	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY15	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	20ST
8420	8420	19606	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
8424	8424	19999	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY46	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
8525	8525	19604	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
8541	8541	19645	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	44	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	30
8666	8666	19642	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	41	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
8806	8806	19624	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
9020	9020	19631	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
9501	9501	19981	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY46	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	40
9507	9507	20011	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY47	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	100ST
9536	9536	19616	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
9543	9543	19690	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	89	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
9568	9568	19704	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY13	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
9612	9612	19684	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	83	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
9616	9616	19685	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	84	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
9690	9690	19750	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY15	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
9901	9901	3761	DPW Maintained 3	Pinus Spp :: Pine Spp 105	1074 Carolina St	1	Median : Cutout 11	Tree 1	DPW 2			12	18		6012458.0	2102979.0	37.755081234351394	-122.39985625989401	(37.7550812343514, -122.399856259894)
10196	10196	173897	Undocumented 2	Pinus Spp :: Pine Spp 105	90x Knollview Way	1	Back Yard : Yard 13	Tree 1	Private 1				3x3		5997593.0	2101480.0	37.7501254274205	-122.451155378281	(37.7501254274205, -122.451155378281)
10253	10253	19673	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	72	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
10305	10305	19688	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	87	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
10342	10342	19625	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
10395	10395	19621	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
10477	10477	20009	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY47	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
10508	10508	19634	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	33	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
10617	10617	19585	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY4	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
10720	10720	19638	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	37	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
10871	10871	19847	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY26	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	30
11056	11056	19730	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
11187	11187	19608	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
11204	11204	19669	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	68	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
11361	11361	19726	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	40ST
11448	11448	19992	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY46	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
11615	11615	19744	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY15	-7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	1OST
11781	11781	19715	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY13	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
11922	11922	19647	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	46	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
11985	11985	19607	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
12001	12001	19689	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	88	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
12046	12046	19609	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
12146	12146	19652	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	51	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
12302	12302	19670	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	69	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
12373	12373	19737	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
12436	12436	19632	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	31	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
12468	12468	19723	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	40ST
12572	12572	19627	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
12593	12593	19725	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
12736	12736	19814	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY24	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
13174	13174	19731	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
13582	13582	19735	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
13598	13598	19611	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
13868	13868	19858	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY30	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	30ST
13915	13915	19633	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	32	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
14263	14263	19658	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	57	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
14612	14612	19719	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY13	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
14712	14712	19997	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY46	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
14871	14871	19860	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY30	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	30ST
14976	14976	19859	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY30	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	30ST
15129	15129	19763	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY16	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30ST
15183	15183	19718	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY13	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
15518	15518	19867	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY30	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
15579	15579	19655	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	54	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST

Next page

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");