Street_Tree_List

Data source: data.sfgov.org

60,345 rows where qLegalStatus = 1 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)

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 ▼
8	8	122650	Permitted Site 1	Acer rubrum :: Red Maple 6	300x Hickory St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2016 12:00:00 AM	3	3x3
10	10	122670	Permitted Site 1	Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8	301x Hickory St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2016 12:00:00 AM	3	3X3
11	11	122658	Permitted Site 1	Acer rubrum :: Red Maple 6	300x Hickory St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2016 12:00:00 AM	3	3x3
12	12	122660	Permitted Site 1	Acer rubrum :: Red Maple 6	300x Hickory St	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2016 12:00:00 AM	3	3x3
13	13	122648	Permitted Site 1	Acer rubrum :: Red Maple 6	300x Hickory St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2016 12:00:00 AM	3	3x3
16	16	122649	Permitted Site 1	Acer rubrum :: Red Maple 6	300x Hickory St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2016 12:00:00 AM	3	3x3
51	51	60867	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/1983 12:00:00 AM			Permit Number 20649
57	57	44642	Permitted Site 1	Tree(s) :: 17		60	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
59	59	44994	Permitted Site 1	Tree(s) :: 17		106	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
84	84	36641	Permitted Site 1	Robinia x ambigua :: Locust 33		13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/20/1998 12:00:00 AM			Permit Number 39461
103	103	117428	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/14/2016 12:00:00 AM	3		Permit Number 776915
151	151	36617	Permitted Site 1	Robinia x ambigua :: Locust 33		8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/20/1998 12:00:00 AM			Permit Number 39461
169	169	251221	Permitted Site 1	Tree(s) :: 17	2401X Washington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/28/2017 12:00:00 AM	3	3x3	Permit Number 778039
172	172	48332	Permitted Site 1	Tree(s) :: 17		142	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
204	204	61453	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/22/1984 12:00:00 AM			Permit Number 21392
235	235	45975	Permitted Site 1	Tree(s) :: 17		132	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
279	279	48153	Permitted Site 1	Tree(s) :: 17		263	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
308	308	46059	Permitted Site 1	Tree(s) :: 17		101	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
316	316	67789	Permitted Site 1	Tree(s) :: 17	7 4384 St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/17/1992 12:00:00 AM			Permit Number 31429
320	320	48259	Permitted Site 1	Tree(s) :: 17		123	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
321	321	65143	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/26/1989 12:00:00 AM			Permit Number 27118
381	381	122664	Permitted Site 1	Lophostemon confertus :: Brisbane Box 11	401x Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2016 12:00:00 AM	3	3X3
424	424	122666	Permitted Site 1	Lophostemon confertus :: Brisbane Box 11	401x Laguna St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/10/2016 12:00:00 AM	3	3X3
444	444	44838	Permitted Site 1	Tree(s) :: 17		12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
467	467	85277	Permitted Site 1	Arbutus unedo :: Strawberry Tree 61	801 Holladay Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/24/2007 12:00:00 AM			Permit Number 49566
509	509	38234	Permitted Site 1	Geijera parviflora :: Australian Willow 68	0 16th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/21/1998 12:00:00 AM			Permit Number 40352
515	515	48129	Permitted Site 1	Tree(s) :: 17		297	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
536	536	45913	Permitted Site 1	Tree(s) :: 17		59	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
580	580	48268	Permitted Site 1	Tree(s) :: 17		132	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
617	617	57850	Permitted Site 1	Tree(s) :: 17	1700 S. Amaylett Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/14/1977 12:00:00 AM			Permit Number 16791
632	632	44905	Permitted Site 1	Tree(s) :: 17		139	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
633	633	48204	Permitted Site 1	Tree(s) :: 17		47	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
675	675	47038	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	716 Walter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/02/2002 12:00:00 AM			Permit Number 45030
689	689	48269	Permitted Site 1	Tree(s) :: 17		120	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
726	726	44958	Permitted Site 1	Tree(s) :: 17		82	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
729	729	48266	Permitted Site 1	Tree(s) :: 17		130	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
793	793	65876	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/25/1990 12:00:00 AM			Permit Number 28874
809	809	46145	Permitted Site 1	Tree(s) :: 17		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2001 12:00:00 AM			Permit Number 44490
814	814	44650	Permitted Site 1	Tree(s) :: 17		70	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
864	864	37366	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	125 Street	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/15/1998 12:00:00 AM			Permit Number 39871
921	921	30278	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 128
937	937	45898	Permitted Site 1	Tree(s) :: 17		26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
952	952	48321	Permitted Site 1	Tree(s) :: 17		187	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
953	953	46022	Permitted Site 1	Tree(s) :: 17		215	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
1010	1010	45949	Permitted Site 1	Tree(s) :: 17		146	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
1015	1015	48313	Permitted Site 1	Tree(s) :: 17		179	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
1038	1038	57888	Permitted Site 1	Tree(s) :: 17	2382 Fost St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/04/1977 12:00:00 AM			Permit Number 16841
1067	1067	48140	Permitted Site 1	Tree(s) :: 17		250	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
1086	1086	48227	Permitted Site 1	Tree(s) :: 17		9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
1113	1113	45845	Permitted Site 1	Tree(s) :: 17		81	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
1130	1130	251459	Permitted Site 1	Acer rubrum 'Armstrong' :: Armstrong Red Maple 87	651 Texas St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/03/2017 12:00:00 AM	3	3x3
1131	1131	251458	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	651 Texas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/03/2017 12:00:00 AM	3	3x3
1225	1225	44628	Permitted Site 1	Tree(s) :: 17		156	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
1389	1389	251532	Permitted Site 1	:: 54	2100X 20th St	4	Sidewalk: Curb side : Cutout 1	Landscaping 2	Private 1		05/15/2017 12:00:00 AM	3	4x11
1391	1391	251531	Permitted Site 1	:: 54	2100X 20th St	2	Sidewalk: Curb side : Cutout 1	Landscaping 2	Private 1		05/15/2017 12:00:00 AM	3	4x11
1418	1418	48339	Permitted Site 1	Tree(s) :: 17		156	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
1499	1499	44884	Permitted Site 1	Tree(s) :: 17		157	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
1511	1511	45972	Permitted Site 1	Tree(s) :: 17		119	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
1526	1526	44588	Permitted Site 1	Tree(s) :: 17		116	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
1532	1532	44561	Permitted Site 1	Tree(s) :: 17		14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
1765	1765	45968	Permitted Site 1	Tree(s) :: 17		155	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
1804	1804	44554	Permitted Site 1	Tree(s) :: 17		41	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
1826	1826	31896	Permitted Site 1	Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106	1525 Houston St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/26/1995 12:00:00 AM			Permit Number 35325
1828	1828	35192	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
1869	1869	35202	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
1885	1885	30481	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/05/1956 12:00:00 AM			Permit Number 147
1959	1959	48104	Permitted Site 1	Tree(s) :: 17		213	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
1973	1973	66343	Permitted Site 1	Tree(s) :: 17		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/10/1990 12:00:00 AM			Permit Number 29464
1981	1981	35702	Permitted Site 1	Liriodendron tulipifera :: Tulip Tree 85		15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/10/1998 12:00:00 AM			Permit Number 38993
2019	2019	48201	Permitted Site 1	Tree(s) :: 17		44	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
2023	2023	35053	Permitted Site 1	Tree(s) :: 17	700 Peninsula Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/22/1998 12:00:00 AM			Permit Number 38613
2080	2080	34119	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 37980
2086	2086	45988	Permitted Site 1	Tree(s) :: 17		223	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
2115	2115	44893	Permitted Site 1	Tree(s) :: 17		127	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
2154	2154	45014	Permitted Site 1	Tree(s) :: 17		86	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
2193	2193	46043	Permitted Site 1	Tree(s) :: 17		174	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
2195	2195	44993	Permitted Site 1	Tree(s) :: 17		105	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
2304	2304	44646	Permitted Site 1	Tree(s) :: 17		66	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
2357	2357	39974	Permitted Site 1	Magnolia grandiflora :: Southern Magnolia 21	0 Steiner St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 41235
2366	2366	44966	Permitted Site 1	Tree(s) :: 17		79	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
2404	2404	67784	Permitted Site 1	Tree(s) :: 17	1030 South Park	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/17/1992 12:00:00 AM			Permit Number 31421
2434	2434	48283	Permitted Site 1	Tree(s) :: 17		93	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/17/2002 12:00:00 AM			Permit Number 45761
2538	2538	39950	Permitted Site 1	Quercus agrifolia :: Coast Live Oak 180	0 Ervine St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/25/1999 12:00:00 AM			Permit Number 41215
2618	2618	55203	Permitted Site 1	Tree(s) :: 17	40 Dalmar St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/29/1972 12:00:00 AM			Permit Number 11116
2627	2627	44896	Permitted Site 1	Tree(s) :: 17		130	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
2630	2630	44978	Permitted Site 1	Tree(s) :: 17		50	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
2673	2673	46063	Permitted Site 1	Tree(s) :: 17		105	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
2699	2699	36646	Permitted Site 1	Robinia x ambigua :: Locust 33		18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/20/1998 12:00:00 AM			Permit Number 39461
2726	2726	46033	Permitted Site 1	Tree(s) :: 17		213	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
2842	2842	36843	Permitted Site 1	Melaleuca linariifolia :: Flaxleaf Paperbark 155		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/26/1998 12:00:00 AM			Permit Number 39538
2860	2860	44877	Permitted Site 1	Tree(s) :: 17		150	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
2904	2904	44678	Permitted Site 1	Tree(s) :: 17		98	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835
2945	2945	44998	Permitted Site 1	Tree(s) :: 17		110	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
2960	2960	44920	Permitted Site 1	Tree(s) :: 17		182	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/25/2001 12:00:00 AM			Permit Number 43922
2992	2992	43017	Permitted Site 1	Geijera parviflora :: Australian Willow 68		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/2000 12:00:00 AM			Permit Number 42880
3013	3013	39333	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	0 21st St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/21/1998 12:00:00 AM			Permit Number 40897
3027	3027	45855	Permitted Site 1	Tree(s) :: 17		79	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2001 12:00:00 AM			Permit Number 44451
3062	3062	34116	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 37979
3077	3077	35211	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12		8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/10/1998 12:00:00 AM			Permit Number 38712
3090	3090	44576	Permitted Site 1	Tree(s) :: 17		140	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/29/2001 12:00:00 AM			Permit Number 43835

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