Street_Tree_List

Data source: data.sfgov.org

254 rows where qSpecies = 105 sorted by TreeID

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
145361	145361	808	DPW Maintained 3	Pinus Spp :: Pine Spp 105	600X 39th Ave	6	Median : Cutout 11	Tree 1	DPW 2			3	6-HOA		5983831.1679936	2111715.0127262003	37.7774303425616	-122.499500145383	(37.7774303425616, -122.499500145383)
113487	113487	815	DPW Maintained 3	Pinus Spp :: Pine Spp 105	600X 39th Ave	13	Median : Cutout 11	Tree 1	DPW 2			3	6-HOA		5983831.1679936	2111715.0127262003	37.7774303425616	-122.499500145383	(37.7774303425616, -122.499500145383)
140811	140811	3760	DPW Maintained 3	Pinus Spp :: Pine Spp 105	1062X Carolina St	2	Median : Cutout 11	Tree 1	DPW 2			20			6012453.5755993	2103020.9691678	37.755196225865895	-122.39987450779499	(37.7551962258659, -122.399874507795)
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)
101960	101960	3763	DPW Maintained 3	Pinus Spp :: Pine Spp 105	1074 Carolina St	1	Median : Cutout 11	Tree 1	DPW 2			12	18		6012456.6037355	2102966.9856684	37.7550481677782	-122.39986024500799	(37.7550481677782, -122.399860245008)
103653	103653	11196	DPW Maintained 3	Pinus Spp :: Pine Spp 105	180 Idora Ave	2	Median : Cutout 11	Tree 1	DPW 2			3	8		5995389.3079719	2099438.2329619997	37.7443928282829	-122.45862803372101	(37.7443928282829, -122.458628033721)
114184	114184	11197	DPW Maintained 3	Pinus Spp :: Pine Spp 105	180 Idora Ave	3	Median : Cutout 11	Tree 1	DPW 2			3	8		5995389.3079719	2099438.2329619997	37.7443928282829	-122.45862803372101	(37.7443928282829, -122.458628033721)
144017	144017	12499	DPW Maintained 3	Pinus Spp :: Pine Spp 105	1200X Lake Merced Blvd	1	Median : Cutout 11	Tree 1	DPW 2			18	8		5987438.4549992	2087542.2692131	37.7112694082243	-122.485247377649	(37.7112694082243, -122.485247377649)
88191	88191	12503	DPW Maintained 3	Pinus Spp :: Pine Spp 105	1200X Lake Merced Blvd	5	Median : Cutout 11	Tree 1	DPW 2			12	8		5987438.4549992	2087542.2692131	37.7112694082243	-122.485247377649	(37.7112694082243, -122.485247377649)
143596	143596	13404	DPW Maintained 3	Pinus Spp :: Pine Spp 105	360 Marietta Dr	2	Median : Cutout 11	Tree 1	DPW 2			40	5x1000		5999647.998558	2097391.335153	37.7390163784819	-122.44375539278	(37.7390163784819, -122.44375539278)
127100	127100	13405	DPW Maintained 3	Pinus Spp :: Pine Spp 105	362 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			45	5		5999656.8275613	2097385.3812268004	37.7390005339934	-122.44372443861401	(37.7390005339934, -122.443724438614)
119618	119618	16689	DPW Maintained 3	Pinus Spp :: Pine Spp 105	620 Noriega St	1	Median : Cutout 11	Tree 1	DPW 2			12	2		5992122.8128645	2103567.9103998	37.7555435761415	-122.47022345479601	(37.7555435761415, -122.470223454796)
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
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
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
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
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
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
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
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
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
15872	15872	19612	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
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
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
16781	16781	19615	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
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
17136	17136	19620	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	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
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
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
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
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
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
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
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
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
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
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
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
15673	15673	19646	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	45	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
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
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
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
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
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
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
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
15774	15774	19662	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	61	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
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
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
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
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
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
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
15679	15679	19682	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY5	81	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60ST
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
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
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
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
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
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
15587	15587	19702	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY12	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
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
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
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
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
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
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
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
16581	16581	19724	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY14	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
17084	17084	19748	DPW Maintained 3	Pinus Spp :: Pine Spp 105	100 STAIRWAY15	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
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
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
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
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
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
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
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
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
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
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
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
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

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