Street_Tree_List

Data source: data.sfgov.org

60,345 rows where qLegalStatus = 1 sorted by XCoord

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)

These facets timed out: qLegalStatus

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
3117	3117	38667	Permitted Site 1	Lophostemon confertus :: Brisbane Box 11	850 Brewster St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/01/1998 12:00:00 AM			Permit Number 40586
3118	3118	48324	Permitted Site 1	Tree(s) :: 17		176	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
3134	3134	44852	Permitted Site 1	Tree(s) :: 17		37	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
3168	3168	33093	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15		9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/05/1996 12:00:00 AM			Permit Number 37336
3177	3177	46976	Permitted Site 1	Metrosideros excelsa :: New Zealand Xmas Tree 2	94122 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/01/2002 12:00:00 AM			Permit Number 44996
3178	3178	48242	Permitted Site 1	Tree(s) :: 17		26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
3193	3193	48299	Permitted Site 1	Tree(s) :: 17		133	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
3212	3212	34102	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37975
3227	3227	48059	Permitted Site 1	Tree(s) :: 17		230	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
3264	3264	253390	Permitted Site 1	Acer rubrum :: Red Maple 6	2529x Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/29/2017 12:00:00 AM	3	3x3
3266	3266	44618	Permitted Site 1	Tree(s) :: 17		182	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
3274	3274	253391	Permitted Site 1	Acer palmatum :: Japanese Maple 175	2529x Lyon St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/29/2017 12:00:00 AM	3	3x3
3285	3285	44952	Permitted Site 1	Tree(s) :: 17		65	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
3297	3297	44585	Permitted Site 1	Tree(s) :: 17		139	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
3322	3322	44559	Permitted Site 1	Tree(s) :: 17		16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
3393	3393	33932	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/25/1997 12:00:00 AM			Permit Number 37893
3395	3395	46141	Permitted Site 1	Lophostemon confertus :: Brisbane Box 11		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2001 12:00:00 AM			Permit Number 44490
3408	3408	44959	Permitted Site 1	Tree(s) :: 17		72	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
3420	3420	35199	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
3444	3444	48277	Permitted Site 1	Tree(s) :: 17		87	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
3448	3448	48107	Permitted Site 1	Tree(s) :: 17		202	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
3458	3458	44636	Permitted Site 1	Tree(s) :: 17		164	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
3465	3465	39926	Permitted Site 1	Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58	0 Arleta Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/25/1999 12:00:00 AM			Permit Number 41198
3486	3486	39483	Permitted Site 1	Olea europaea :: Olive Tree 41	0 19th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/1998 12:00:00 AM			Permit Number 40941
3539	3539	46147	Permitted Site 1	Lophostemon confertus :: Brisbane Box 11		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2001 12:00:00 AM			Permit Number 44490
3543	3543	44857	Permitted Site 1	Tree(s) :: 17		31	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
3545	3545	43015	Permitted Site 1	Geijera parviflora :: Australian Willow 68		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/2000 12:00:00 AM			Permit Number 42880
3571	3571	39975	Permitted Site 1	Acacia melanoxylon :: Blackwood Acacia 5	0 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 41235
3614	3614	46882	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/26/2002 12:00:00 AM			Permit Number 44940
3622	3622	34463	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Ralston Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/15/1997 12:00:00 AM			Permit Number 38201
3636	3636	64705	Permitted Site 1	Tree(s) :: 17	252 Walker Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/19/1988 12:00:00 AM			Permit Number 25649
3663	3663	36860	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
3668	3668	43018	Permitted Site 1	Geijera parviflora :: Australian Willow 68		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/2000 12:00:00 AM			Permit Number 42880
3695	3695	57738	Permitted Site 1	Tree(s) :: 17	1999 So. Bascom Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/1976 12:00:00 AM			Permit Number 16656
3744	3744	46296	Permitted Site 1	Robinia x ambigua :: Locust 33		13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/31/2002 12:00:00 AM			Permit Number 44564
3751	3751	45854	Permitted Site 1	Tree(s) :: 17		71	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
3765	3765	45857	Permitted Site 1	Tree(s) :: 17		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
3821	3821	46195	Permitted Site 1	Magnolia grandiflora :: Southern Magnolia 21		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/31/2001 12:00:00 AM			Permit Number 44518
3838	3838	48141	Permitted Site 1	Tree(s) :: 17		251	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
3864	3864	44703	Permitted Site 1	Tree(s) :: 17		40	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
3875	3875	48176	Permitted Site 1	Tree(s) :: 17		57	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
3909	3909	48174	Permitted Site 1	Tree(s) :: 17		67	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
3965	3965	253596	Permitted Site 1	Tree(s) :: 17	198X Brussels St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/04/2017 12:00:00 AM	3	3x3	Permit Number 780230
4009	4009	34002	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 37940
4038	4038	45886	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
4053	4053	45907	Permitted Site 1	Tree(s) :: 17		62	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
4084	4084	45961	Permitted Site 1	Tree(s) :: 17		162	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
4133	4133	48248	Permitted Site 1	Tree(s) :: 17		112	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
4171	4171	39901	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/03/2002 12:00:00 AM			Permit Number 41185
4256	4256	44534	Permitted Site 1	Tree(s) :: 17		35	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
4347	4347	45877	Permitted Site 1	Tree(s) :: 17		31	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
4351	4351	36746	Permitted Site 1	Prunus cerasifera :: Cherry Plum 16	5555 Woodward St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39516
4378	4378	45905	Permitted Site 1	Tree(s) :: 17		35	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
4435	4435	34068	Permitted Site 1	Geijera parviflora :: Australian Willow 68	955 Kennedy Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/1997 12:00:00 AM			Permit Number 37965
4441	4441	35439	Permitted Site 1	Lophostemon confertus :: Brisbane Box 11	757 Peninsula Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/16/1998 12:00:00 AM			Permit Number 38882
4443	4443	67752	Permitted Site 1	Tree(s) :: 17	2281 Gates St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/04/1992 12:00:00 AM			Permit Number 31376
4492	4492	44688	Permitted Site 1	Tree(s) :: 17		108	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
4519	4519	46000	Permitted Site 1	Tree(s) :: 17		118	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
4531	4531	48083	Permitted Site 1	Tree(s) :: 17		193	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
4552	4552	97357	Permitted Site 1	Tree(s) :: 17		7	Unaccepted Street : Yard 14	Tree 1	Private 1
4555	4555	253633	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	1907 Judah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/21/2016 12:00:00 AM		3x3	Permit Number 777409
4576	4576	60252	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/23/1982 12:00:00 AM			Permit Number 19804
4629	4629	34972	Permitted Site 1	Melaleuca linariifolia :: Flaxleaf Paperbark 155		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/18/1997 12:00:00 AM			Permit Number 38555
4714	4714	44605	Permitted Site 1	Tree(s) :: 17		148	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
4741	4741	48244	Permitted Site 1	Tree(s) :: 17		122	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
4774	4774	44595	Permitted Site 1	Tree(s) :: 17		150	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
4823	4823	45930	Permitted Site 1	Tree(s) :: 17		41	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
4831	4831	44933	Permitted Site 1	Tree(s) :: 17		166	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
4834	4834	50011	Permitted Site 1	Ginkgo biloba :: Maidenhair Tree 44	99@ 20TH ST Tennessee St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/25/2003 12:00:00 AM			Permit Number 46742
4913	4913	97358	Permitted Site 1	Tree(s) :: 17		8	Unaccepted Street : Yard 14	Tree 1	Private 1
4975	4975	47475	Permitted Site 1	Lophostemon confertus :: Brisbane Box 11		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/14/2002 12:00:00 AM			Permit Number 45375
4991	4991	35276	Permitted Site 1	Tree(s) :: 17		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/17/1998 12:00:00 AM			Permit Number 38758
5018	5018	44607	Permitted Site 1	Tree(s) :: 17		171	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
5109	5109	36635	Permitted Site 1	Magnolia grandiflora :: Southern Magnolia 21		10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/20/1998 12:00:00 AM			Permit Number 39461
5121	5121	45851	Permitted Site 1	Tree(s) :: 17		74	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
5128	5128	44995	Permitted Site 1	Tree(s) :: 17		107	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
5147	5147	48270	Permitted Site 1	Tree(s) :: 17		94	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
5156	5156	44926	Permitted Site 1	Tree(s) :: 17		199	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
5203	5203	46584	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	2790 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/05/2002 12:00:00 AM			Permit Number 44712
5208	5208	48263	Permitted Site 1	Tree(s) :: 17		127	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
5216	5216	253831	Permitted Site 1	:: 54	651X Polk St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	DPW 4			3x3
5230	5230	253826	Permitted Site 1	:: 54	701 Ellis St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	DPW 4			3x3
5236	5236	253833	Permitted Site 1	:: 54	607 Eddy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	DPW 4			3x3
5239	5239	253830	Permitted Site 1	:: 54	651X Polk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	DPW 4			3x3
5259	5259	42922	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/2000 12:00:00 AM			Permit Number 42829
5261	5261	44583	Permitted Site 1	Tree(s) :: 17		147	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
5262	5262	30644	Permitted Site 1	Tree(s) :: 17	1597 Houston St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/30/1995 12:00:00 AM			Permit Number 34586
5268	5268	44602	Permitted Site 1	Tree(s) :: 17		130	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
5270	5270	30482	Permitted Site 1	Tree(s) :: 17		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/05/1956 12:00:00 AM			Permit Number 147
5272	5272	65265	Permitted Site 1	Tree(s) :: 17	2884 Florida St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/14/1989 12:00:00 AM			Permit Number 28066
5277	5277	46045	Permitted Site 1	Tree(s) :: 17		172	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
5286	5286	48241	Permitted Site 1	Tree(s) :: 17		25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
5302	5302	35167	Permitted Site 1	Prunus cerasifera :: Cherry Plum 16	240 Walter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/02/1998 12:00:00 AM			Permit Number 38700
5321	5321	36650	Permitted Site 1	Tree(s) :: 17		9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/20/1998 12:00:00 AM			Permit Number 39461
5325	5325	40088	Permitted Site 1	Prunus spp :: Cherry 84		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/09/1999 12:00:00 AM			Permit Number 41311
5326	5326	38231	Permitted Site 1	Geijera parviflora :: Australian Willow 68	0 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/21/1998 12:00:00 AM			Permit Number 40352
5328	5328	63329	Permitted Site 1	Tree(s) :: 17	225 Bessie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/02/1987 12:00:00 AM			Permit Number 23902
5335	5335	43483	Permitted Site 1	Melaleuca linariifolia :: Flaxleaf Paperbark 155		7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/19/2000 12:00:00 AM			Permit Number 43169
5340	5340	30595	Permitted Site 1	Acacia baileyana :: Bailey's Acacia 42	265 Walter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/26/1995 12:00:00 AM			Permit Number 34562
5355	5355	48328	Permitted Site 1	Tree(s) :: 17		138	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761

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