Street_Tree_List

Data source: data.sfgov.org

25,937 rows where qCaretaker = 2 sorted by Longitude

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: 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
104	104	251210	DPW Maintained 3	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1170 Ingalls St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/02/1992 12:00:00 AM
124	124	20281	DPW Maintained 3	Metrosideros excelsa :: New Zealand Xmas Tree 2	20X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
129	129	20398	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	43	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
255	255	19810	DPW Maintained 3	Araucaria heterophylla :: Norfolk Island Pine 24	100 STAIRWAY24	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
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
501	501	251171	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	201X Cargo Way	37	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2017 11:21:00 AM	3
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
613	613	20019	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	100 STAIRWAY48	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
618	618	20377	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
639	639	20004	DPW Maintained 3	Prunus blireiana :: Flowering Plum 102	100 STAIRWAY46	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	2
738	738	20446	DPW Maintained 3	Metrosideros excelsa :: New Zealand Xmas Tree 2	495X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	15
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
838	838	19815	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY24	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	100ST
870	870	117001	DPW Maintained 3	:: 54	1X Bernal Heights Blvd	1	Front Yard : Yard 7	Tree 1	DPW 2
874	874	19854	DPW Maintained 3	Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114	100 STAIRWAY29	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	100ST
886	886	19568	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
1050	1050	19708	DPW Maintained 3	Melaleuca spp :: Melaleuca spp 130	100 STAIRWAY13	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
1070	1070	19942	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	100 STAIRWAY38	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	10ST
1098	1098	251438	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2501X Santiago St	1	Median : Yard 3	Tree 1	DPW 2
1109	1109	20024	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	100 STAIRWAY48	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
1177	1177	251471	DPW Maintained 3	Brugmansia spp :: Angel trumpet 137	2423 Market St	1	Front Yard : Yard 7	Tree 1	DPW 2
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
1271	1271	19821	DPW Maintained 3	Acacia longifolia :: Golden Wattle 140	100 STAIRWAY25	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	10ST
1350	1350	19971	DPW Maintained 3	Schinus molle :: California Pepper 138	100 STAIRWAY44	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	15
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
1434	1434	20063	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	100 STAIRWAY54	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	15ST
1497	1497	20382	DPW Maintained 3	Metrosideros excelsa :: New Zealand Xmas Tree 2	262X Sunset Blvd	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
1529	1529	251578	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	6	Median : Cutout 11	Tree 1	DPW 2
1647	1647	20023	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	100 STAIRWAY48	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
1665	1665	251650	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	101X Vicente St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x3
1707	1707	19767	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY16	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30ST
1811	1811	19991	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
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
1842	1842	19990	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40
1867	1867	19782	DPW Maintained 3	Magnolia x soulangiana 'Rustica Rubra' :: Chinese Magnolia 157	100 STAIRWAY19	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	50ST
1887	1887	20008	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	100 STAIRWAY46	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	2
1898	1898	20392	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
1954	1954	20331	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	101X Sunset Blvd	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
1982	1982	118349	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	100X Guerrero St	4	Median : Cutout 11	Tree 1	DPW 2		07/15/2016 06:43:00 AM	3
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
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
2168	2168	118346	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	100X Guerrero St	1	Median : Cutout 11	Tree 1	DPW 2		07/15/2016 05:47:00 AM	3
2439	2439	19802	DPW Maintained 3	Acacia spp :: Acacia Spp 176	100 STAIRWAY22	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	20
2489	2489	119760	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	101X Octavia St Frontage West	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				4x4
2490	2490	119764	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	101X Octavia St Frontage West	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				4x4
2492	2492	119762	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	101X Octavia St Frontage West	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				4x4
2496	2496	119765	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	101X Octavia St Frontage West	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				4x4
2501	2501	119761	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	101X Octavia St Frontage West	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				4x4
2508	2508	119759	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	101X Octavia St Frontage West	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				4x4
2509	2509	119763	DPW Maintained 3	Pyrus calleryana :: Ornamental Pear 9	101X Octavia St Frontage West	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				4x4
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
2551	2551	20356	DPW Maintained 3	Acacia decurrens :: Acacia: Silver Wattle 181	262X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
2559	2559	19580	DPW Maintained 3	Metrosideros excelsa :: New Zealand Xmas Tree 2	100 STAIRWAY4	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	8
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
2751	2751	19916	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
2766	2766	118353	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	100X Guerrero St	8	Median : Cutout 11	Tree 1	DPW 2		07/15/2016 05:58:00 AM	3
2790	2790	20006	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	100 STAIRWAY46	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	2
3007	3007	253279	Undocumented 2	Pyrus calleryana :: Ornamental Pear 9	201X Laguna Honda Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	DPW 2				10x10	ROW IS 10' tree is street tree
3019	3019	20034	DPW Maintained 3	Prunus cerasifera :: Cherry Plum 16	100 STAIRWAY51	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	ST
3026	3026	19742	DPW Maintained 3	Melaleuca spp :: Melaleuca spp 130	100 STAIRWAY15	-9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	1OST
3087	3087	19650	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	49	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
3111	3111	118355	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	100X Guerrero St	10	Median : Cutout 11	Tree 1	DPW 2		07/15/2016 06:48:00 AM	3
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
3394	3394	118348	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	100X Guerrero St	3	Median : Cutout 11	Tree 1	DPW 2		07/15/2016 06:19:00 AM	3
3403	3403	19880	DPW Maintained 3	Syzygium paniculatum :: Brush Cherry 198	100 STAIRWAY33	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	25ST
3537	3537	102838	Undocumented 2	Pinus radiata :: Monterey Pine 3	1101X Portola Dr	1	Sidewalk: Property side : Yard 9	Tree 1	DPW 2
3586	3586	253468	DPW Maintained 3	Salix lasiolepis :: Arroyo willow 213	801X Alemany Blvd	1	Side Yard : Yard 17	Tree 1	DPW 2
3716	3716	20054	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	100 STAIRWAY54	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	15ST
3723	3723	253167	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1X Brotherhood Way	1	Front Yard : Yard 7	Tree 1	DPW 2
3819	3819	19829	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	100 STAIRWAY25	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60X
3857	3857	19783	DPW Maintained 3	Prunus blireiana :: Flowering Plum 102	100 STAIRWAY19	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	50ST
3884	3884	20320	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	101X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
3951	3951	20035	DPW Maintained 3	Prunus cerasifera :: Cherry Plum 16	100 STAIRWAY51	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	ST
3979	3979	19911	DPW Maintained 3	Cupressocyparis leylandii :: Leyland Cypress 34	100 STAIRWAY35	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
4106	4106	20001	DPW Maintained 3	Syzygium paniculatum :: Brush Cherry 198	100 STAIRWAY46	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	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
4215	4215	118354	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	100X Guerrero St	9	Median : Cutout 11	Tree 1	DPW 2		07/15/2016 06:05:00 AM	3
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
4277	4277	19665	DPW Maintained 3	Cedrus atlantica Glauca :: Blue Atlas Cedar 203	100 STAIRWAY5	64	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60ST
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
4374	4374	118351	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	100X Guerrero St	6	Median : Cutout 11	Tree 1	DPW 2		07/15/2016 06:32:00 AM	3
4452	4452	19593	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY4	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
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
4862	4862	19656	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	55	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60ST
4995	4995	20353	DPW Maintained 3	Acacia decurrens :: Acacia: Silver Wattle 181	262X Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
5082	5082	19803	DPW Maintained 3	Acacia spp :: Acacia Spp 176	100 STAIRWAY22	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	20
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
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
5341	5341	19786	DPW Maintained 3	Maytenus boaria :: Mayten 22	100 STAIRWAY19	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	50ST
5363	5363	20357	DPW Maintained 3	Acacia decurrens :: Acacia: Silver Wattle 181	262X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
5366	5366	19799	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	100 STAIRWAY21	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	40ST
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
5429	5429	118350	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	100X Guerrero St	5	Median : Cutout 11	Tree 1	DPW 2		07/15/2016 05:53:00 AM	3
5450	5450	19643	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	42	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
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
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
5490	5490	20325	DPW Maintained 3	Acer spp :: Maple 158	101X Sunset Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60

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