Street_Tree_List

Data source: data.sfgov.org

2,124 rows where qSpecies = 3 sorted by Location

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, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▼
3	3	119263	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Lakeshore Dr	1	Median : Yard 3	Tree 1	DPW 2				10x30
437	437	20292	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
556	556	20399	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	44	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
1620	1620	251543	Undocumented 2	Pinus radiata :: Monterey Pine 3	0X Bay Shore Blvd Off Ramp		Side Yard : Yard 17	Tree 1	Private 1
1841	1841	20401	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	46	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
2042	2042	20405	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	50	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
2700	2700	20053	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY53	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
3537	3537	102838	Undocumented 2	Pinus radiata :: Monterey Pine 3	1101X Portola Dr	1	Sidewalk: Property side : Yard 9	Tree 1	DPW 2
4187	4187	20426	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
4260	4260	20045	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY52	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10
4482	4482	20388	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	34	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
4528	4528	19968	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY43	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	15
5282	5282	20344	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	40
5456	5456	20311	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
6219	6219	20290	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6407	6407	20308	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
6784	6784	20408	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	53	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
7028	7028	20295	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
7080	7080	20425	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
7092	7092	19853	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY29	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
7096	7096	20070	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY55	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
7176	7176	19977	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY45	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	30ST
7292	7292	20433	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
7424	7424	20416	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
7658	7658	20289	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
7810	7810	119607	Significant Tree 6	Pinus radiata :: Monterey Pine 3	299x Avalon Ave	3	Front Yard : Yard 7	Tree 1	Private 1
8078	8078	20329	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
8128	8128	87100	Permitted Site 1	Pinus radiata :: Monterey Pine 3	700 Connecticut St	1	Front Yard : Yard 7	Tree 1	Rec/Park 3				3x3	Permit Number 50056
8485	8485	20457	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
8592	8592	121500	Private 5	Pinus radiata :: Monterey Pine 3	251X Pennsylvania Ave	1	Back Yard : Yard 13	Tree 1	DPW 2
9506	9506	20420	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
9521	9521	20394	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	39	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
9593	9593	94859	Permitted Site 1	Pinus radiata :: Monterey Pine 3		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Permit Number 53932
9600	9600	20367	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
9694	9694	173632	Undocumented 2	Pinus radiata :: Monterey Pine 3	3300X Market St	1	Side Yard : Yard 17	Tree 1	Private 1
9843	9843	20458	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
9855	9855	20400	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	45	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
10567	10567	20323	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
10850	10850	20451	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
10974	10974	20418	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
11124	11124	20380	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
11130	11130	20306	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
11214	11214	20374	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
11595	11595	20431	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	30
11765	11765	20396	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	41	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
12711	12711	19749	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY15	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
12855	12855	20286	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13180	13180	20069	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY55	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	40ST
13202	13202	20284	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13357	13357	20454	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
13388	13388	20313	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13426	13426	20293	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
13476	13476	20287	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13681	13681	19775	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY18	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	50ST
13746	13746	20338	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
13748	13748	20343	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	29	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
14111	14111	20421	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14252	14252	20285	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14683	14683	20337	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
14835	14835	20387	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	33	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
14837	14837	94862	Permitted Site 1	Pinus radiata :: Monterey Pine 3		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Permit Number 53932
14905	14905	20283	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
15072	15072	20052	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY53	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
15202	15202	20339	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
15238	15238	20432	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	30
15347	15347	20288	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
15632	15632	20427	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
16056	16056	20402	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	47	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
16063	16063	20307	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
16202	16202	20435	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
16297	16297	19969	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY43	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	15
16394	16394	20368	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
16828	16828	20461	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
19583	19583	119914	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	400X Brotherhood Way	1	Front Yard : Yard 7	Tree 1	DPW 2				100x100
185502	185502	122532	Undocumented 2	Pinus radiata :: Monterey Pine 3	1900X Castro St	1	Unaccepted Street : Yard 14	Tree 1	Private 1
147452	147452	178266	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	12x Canyon Dr	13	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		6002746.13562	2086151.65676	37.7083309587667	-122.43224097763901	(37.7083309587667, -122.432240977639)
150864	150864	178273	Undocumented 2	Pinus radiata :: Monterey Pine 3	98 San Diego Ave	2	Front Yard : Yard 7	Tree 1	Private 1			17			5992768.65673	2086361.85687	37.708337348457896	-122.46673926632499	(37.7083373484579, -122.466739266325)
180884	180884	178265	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	12x Canyon Dr	11	Median : Cutout 11	Tree 1	DPW 2			25	Width 0ft		6002756.140790001	2086182.07734	37.7084150543766	-122.43220856967501	(37.7084150543766, -122.432208569675)
95665	95665	106062	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	140X CANYON DR	2	Median : Yard 3	Tree 1	DPW 2			30			6002713.0	2086188.2	37.708429419739794	-122.432358106226	(37.7084294197398, -122.432358106226)
108704	108704	106057	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	140X CANYON DR	1	Median : Yard 3	Tree 1	DPW 2			18			6002713.0	2086188.2	37.708429419739794	-122.432358106226	(37.7084294197398, -122.432358106226)
151982	151982	178264	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	12x Canyon Dr	10	Median : Cutout 11	Tree 1	DPW 2			34	Width 0ft		6002759.723230001	2086192.08797	37.708442744517896	-122.432196902771	(37.7084427445179, -122.432196902771)
159960	159960	178246	Undocumented 2	Pinus radiata :: Monterey Pine 3	334 Schwerin St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			59	Width 8ft		6008498.73338	2086169.5102900001	37.7087044750874	-122.412360530312	(37.7087044750874, -122.412360530312)
11659	11659	106061	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	12X Canyon Dr	1	Median : Yard 3	Tree 1	DPW 2			40			6003256.93175	2086330.4794599998	37.7088509162175	-122.430488359046	(37.7088509162175, -122.430488359046)
184172	184172	178271	Undocumented 2	Pinus radiata :: Monterey Pine 3	35 Tomaso Ct	2	Side Yard : Yard 17	Tree 1	Private 1			17	Width 3ft		6009176.170940001	2086260.2904299998	37.7089917311415	-122.41002561149901	(37.7089917311415, -122.410025611499)
176645	176645	178270	Undocumented 2	Pinus radiata :: Monterey Pine 3	35 Tomaso Ct	1	Side Yard : Yard 17	Tree 1	Private 1			14	Width 3ft		6009167.93697	2086263.08528	37.7089989437285	-122.41005426658701	(37.7089989437285, -122.410054266587)
30008	30008	178244	Undocumented 2	Pinus radiata :: Monterey Pine 3	62 Tomaso Ct	4	Front Yard : Yard 7	Tree 1	Private 1			17	Width 8ft		6009170.0421	2086265.24197	37.7090049835504	-122.410047143074	(37.7090049835504, -122.410047143074)
37802	37802	178243	Undocumented 2	Pinus radiata :: Monterey Pine 3	62 Tomaso Ct	3	Front Yard : Yard 7	Tree 1	Private 1			26	Width 8ft		6009152.06447	2086268.0035	37.7090115585089	-122.410109471469	(37.7090115585089, -122.410109471469)
132971	132971	178242	Undocumented 2	Pinus radiata :: Monterey Pine 3	62 Tomaso Ct	2	Front Yard : Yard 7	Tree 1	Private 1			17	Width 8ft		6009144.65272	2086270.07017	37.709016817728	-122.41013523347401	(37.709016817728, -122.410135233474)
84245	84245	113122	Undocumented 2	Pinus radiata :: Monterey Pine 3	1x TOMASO CT	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
85460	85460	113113	Undocumented 2	Pinus radiata :: Monterey Pine 3	1x TOMASO CT	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
126278	126278	113114	Undocumented 2	Pinus radiata :: Monterey Pine 3	1x TOMASO CT	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
25780	25780	178245	Undocumented 2	Pinus radiata :: Monterey Pine 3	62 Tomaso Ct	8	Front Yard : Yard 7	Tree 1	Private 1			39	Width 8ft		6009206.68729	2086340.63676	37.7092140561483	-122.409925810128	(37.7092140561483, -122.409925810128)
176020	176020	178272	Undocumented 2	Pinus radiata :: Monterey Pine 3	35 Tomaso Ct	10	Side Yard : Yard 17	Tree 1	Private 1			22	Width 3ft		6009218.69223	2086367.8804	37.709289534449894	-122.409886240875	(37.7092895344499, -122.409886240875)
166770	166770	106909	Undocumented 2	Pinus radiata :: Monterey Pine 3	254 Winding Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			51	6x6		6001705.95388	2086562.81591	37.709400878615796	-122.435865357921	(37.7094008786158, -122.435865357921)
11192	11192	24264	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	350X Winding Way	2	Median : Cutout 11	Tree 1	DPW 2			24	8		6001155.71614	2086583.0952599999	37.709425288929296	-122.437768517615	(37.7094252889293, -122.437768517615)
35157	35157	178267	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	350x Winding Way	7	Median : Cutout 11	Tree 1	DPW 2			20	Width 0ft		6001101.515319999	2086589.4198900003	37.7094395728456	-122.437956296952	(37.7094395728456, -122.437956296952)
118868	118868	104135	Undocumented 2	Pinus radiata :: Monterey Pine 3	254 WINDING WAY	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			60	6x9		6001720.0	2086577.0	37.7094406229145	-122.435817826478	(37.7094406229145, -122.435817826478)
81918	81918	102229	Undocumented 2	Pinus radiata :: Monterey Pine 3	254 WINDING WAY	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			45	6x9		6001720.0	2086577.5	37.709441995804795	-122.435817862229	(37.7094419958048, -122.435817862229)
142086	142086	110077	Undocumented 2	Pinus radiata :: Monterey Pine 3	4099x ALEMANY BLVD		Median : Cutout 11	Tree 1	Private 1			48			5991599.0	2086829.0	37.7095524384103	-122.470815701049	(37.7095524384103, -122.470815701049)
13003	13003	24273	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	350X Winding Way	11	Median : Cutout 11	Tree 1	DPW 2			12	8		6000864.27338	2086762.8945799998	37.7099024017335	-122.43878866537399	(37.7099024017335, -122.438788665374)

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