Street_Tree_List

Data source: data.sfgov.org

267 rows where qCaretaker = 2 and qSpecies = 40

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

- 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, PlantDate, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
109	109	9895	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1800X Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6005051.0377	2115464.4068	37.7889474242075	-122.426360597873	(37.7889474242075, -122.426360597873)
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
1842	1842	19990	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40
2751	2751	19916	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
5450	5450	19643	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	42	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
5580	5580	19952	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY39	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
5629	5629	19629	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
5638	5638	19734	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY14	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
6130	6130	19637	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	36	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
6465	6465	20050	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY52	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10
6552	6552	19622	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
6727	6727	20046	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY52	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	10
6840	6840	19703	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY13	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
6859	6859	19881	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
7127	7127	19877	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	25ST
8000	8000	19575	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	100ST
8376	8376	17629	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	150 Phelps St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10M
8874	8874	19879	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
8891	8891	19873	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	25ST
9101	9101	19626	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
9670	9670	19824	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY25	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
10110	10110	17260	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	29 Osceola Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/27/2017 12:00:00 AM	18	3X3		6017247.640204701	2094279.3298336002	37.73145956022589	-122.382686794637	(37.7314595602259, -122.382686794637)
10584	10584	19572	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
10624	10624	19574	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
10757	10757	19823	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY25	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
10946	10946	19995	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
11109	11109	19996	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
11188	11188	19822	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY25	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
11496	11496	19573	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
11523	11523	19635	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	34	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
11623	11623	19765	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY16	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30ST
12152	12152	19571	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
12720	12720	19640	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	39	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
12830	12830	19619	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
12952	12952	19628	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
13122	13122	19636	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	35	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
13156	13156	20391	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	262X Sunset Blvd	37	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13560	13560	20028	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY49	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10
13632	13632	19618	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
13773	13773	19987	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40
13854	13854	11422	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	803X Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6016040.90005	2096755.8649799998	37.738192886184	-122.38703142706001	(37.738192886184, -122.38703142706)
13883	13883	19639	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
14157	14157	17628	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	150 Phelps St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10M
14188	14188	19617	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
14354	14354	17473	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	2050X Palou Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/17/1992 12:00:00 AM	12	3X3		6012341.587169999	2097177.38743	37.73914476102	-122.39985148498	(37.73914476102, -122.39985148498)
14387	14387	22148	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	3800 03rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3x3		6015737.9632	2098284.4406	37.7423732631069	-122.388185488874	(37.7423732631069, -122.388185488874)
14502	14502	17475	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	2050X Palou Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6012301.79777	2097206.74854	37.7392231621197	-122.399991120917	(37.7392231621197, -122.399991120917)
14653	14653	19921	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY37	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3
15242	15242	22432	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	6000 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6013579.8961	2091555.5712	37.7237773618259	-122.39517625529	(37.7237773618259, -122.39517625529)
15445	15445	19918	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
15768	15768	19884	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	25ST
15852	15852	19567	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
15947	15947	19630	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	29	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
16203	16203	19623	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
16222	16222	19870	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	25ST
16278	16278	19770	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY16	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30ST
16313	16313	19876	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
16376	16376	19641	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	40	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
16486	16486	19701	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY12	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
16953	16953	19917	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
23642	23642	176313	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	500x Mansell St	18	Median : Cutout 11	Tree 1	DPW 2			38	Width 0ft		6010259.13784	2090270.57035	37.7200637812891	-122.40656510840799	(37.7200637812891, -122.406565108408)
24910	24910	113499	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	200x Mansell St	5	Median : Cutout 11	Tree 1	DPW 2			19	3x3		6011193.56936	2090563.5306400002	37.7209204242214	-122.403355677147	(37.7209204242214, -122.403355677147)
28478	28478	176327	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	31	Median : Cutout 11	Tree 1	DPW 2			46	Width 0ft		6009212.31958	2089948.46975	37.7191207387124	-122.41016088932699	(37.7191207387124, -122.410160889327)
28724	28724	199407	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	301x Cashmere St	7	Median : Yard 3	Tree 1	DPW 2			18			6016184.136419999	2096191.07332	37.736650012889	-122.386496812495	(37.736650012889, -122.386496812495)
30294	30294	176308	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	300x Mansell St	12	Median : Cutout 11	Tree 1	DPW 2			23	Width 0ft		6010842.734619999	2090461.59096	37.7206209176161	-122.404561241708	(37.7206209176161, -122.404561241708)
30521	30521	17266	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	40 Osceola Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017197.543092299	2094354.669125	37.7316636592684	-122.382865232677	(37.7316636592684, -122.382865232677)
36490	36490	176307	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	300x Mansell St	7	Median : Cutout 11	Tree 1	DPW 2			14	Width 0ft		6010889.97096	2090468.7148799999	37.7206431182563	-122.404398460825	(37.7206431182563, -122.404398460825)
36977	36977	186970	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1650x Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5986025.4295	2095869.2083	37.734050611594604	-122.49074337328301	(37.7340506115946, -122.490743373283)
37371	37371	176317	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	600x Mansell St	5	Median : Cutout 11	Tree 1	DPW 2			20	Width 0ft		6009952.88344	2090194.2340000002	37.7198370388417	-122.40761835123199	(37.7198370388417, -122.407618351232)
40506	40506	176323	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	23	Median : Cutout 11	Tree 1	DPW 2			31	Width 0ft		6009342.20287	2090002.90208	37.719277477945	-122.40971577078399	(37.719277477945, -122.409715770784)
42868	42868	176330	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	35	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6009184.10476	2089961.98667	37.7191562718235	-122.41025937136801	(37.7191562718235, -122.410259371368)
44683	44683	176302	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100x Mansell St	2	Median : Cutout 11	Tree 1	DPW 2			18	Width 0ft		6011513.54745	2090660.92357	37.721205711656204	-122.40225644658301	(37.7212057116562, -122.402256446583)
46745	46745	176303	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	200x Mansell St	16	Median : Cutout 11	Tree 1	DPW 2			23	Width 0ft		6011115.33526	2090539.9745900002	37.7208513742667	-122.40362445389799	(37.7208513742667, -122.403624453898)
49638	49638	25447	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1261X La Salle Ave	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017141.6501925	2094501.7221284	37.732064349457005	-122.383068698568	(37.732064349457, -122.383068698568)
50131	50131	199404	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	299x Cashmere St	24	Median : Yard 3	Tree 1	DPW 2			31			6016629.65755	2096008.94769	37.7361745853726	-122.38494375437	(37.7361745853726, -122.38494375437)
53330	53330	186974	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1600x Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5986249.0864	2095869.2083	37.7340636742344	-122.489970132524	(37.7340636742344, -122.489970132524)
55441	55441	199405	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	301x Cashmere St	4	Median : Yard 3	Tree 1	DPW 2			25			6016273.90453	2096214.7321400002	37.736719944173004	-122.386188091409	(37.736719944173, -122.386188091409)
56266	56266	9287	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	13X George Ct	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017208.549763201	2094048.0250586998	37.7308222832509	-122.38280584856301	(37.7308222832509, -122.382805848563)
58856	58856	185127	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Sloat Blvd	2	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5989015.4133	2095969.6432	37.734500589899504	-122.480413539116	(37.7345005898995, -122.480413539116)
62350	62350	176309	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	300x Mansell St	21	Median : Cutout 11	Tree 1	DPW 2			24	Width 0ft		6010760.4946	2090426.07331	37.720518796898	-122.404843021812	(37.720518796898, -122.404843021812)
62801	62801	176326	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	26	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		6009300.414580001	2090007.1642099998	37.719286839006706	-122.40986051846701	(37.7192868390067, -122.409860518467)
64522	64522	176312	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	500x Mansell St	15	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6010340.9019	2090322.69069	37.720211467072296	-122.406286146812	(37.7202114670723, -122.406286146812)
64735	64735	176318	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	600x Mansell St	6	Median : Cutout 11	Tree 1	DPW 2			24	Width 0ft		6009900.75619	2090162.07565	37.71974582058	-122.40779627129	(37.71974582058, -122.40779627129)
66989	66989	176322	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	11	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		6009482.932019999	2090051.6391099999	37.7194191850237	-122.40923275838699	(37.7194191850237, -122.409232758387)
70430	70430	176306	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	300x Mansell St	5	Median : Cutout 11	Tree 1	DPW 2			17	Width 0ft		6010916.0273400005	2090472.38873	37.7206546619672	-122.40430865004299	(37.7206546619672, -122.404308650043)
71073	71073	199399	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	299x Cashmere St	14	Median : Yard 3	Tree 1	DPW 2			22			6016725.29246	2095937.31293	37.7359831799735	-122.38460811386999	(37.7359831799735, -122.38460811387)
72173	72173	176321	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	10	Median : Cutout 11	Tree 1	DPW 2			20	Width 0ft		6009491.13352	2090035.22052	37.7193745624679	-122.409203250746	(37.7193745624679, -122.409203250746)
73572	73572	176297	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	10x Mansell St	5	Median : Cutout 11	Tree 1	DPW 2			22	Width 0ft		6011769.33402	2090739.1089	37.7214346673524	-122.401377752274	(37.7214346673524, -122.401377752274)
73620	73620	176316	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	600x Mansell St	4	Median : Cutout 11	Tree 1	DPW 2			20	Width 0ft		6009975.17316	2090196.6271099998	37.7198448575227	-122.40754147176001	(37.7198448575227, -122.40754147176)
75997	75997	176325	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	25	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6009306.38792	2090008.2878700001	37.7192902591068	-122.40983995006701	(37.7192902591068, -122.409839950067)
76398	76398	17253	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	15 Osceola Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6017345.102761	2094248.0837328997	37.7313791485056	-122.382347671583	(37.7313791485056, -122.382347671583)
77295	77295	113498	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	200x Mansell St	4	Median : Cutout 11	Tree 1	DPW 2			23	3x3		6011210.15679	2090562.2005	37.7209176983622	-122.403298245537	(37.7209176983622, -122.403298245537)
77566	77566	106463	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	3500X MISSION ST	3	Median : Cutout 11	Tree 1	DPW 2			28			6005565.6	2097823.9	37.7405398531137	-122.42332575716001	(37.7405398531137, -122.42332575716)
77748	77748	11361	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1350X Ingalls St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			80	3X3		6017253.696644001	2093959.2156363998	37.7305809242894	-122.382643589629	(37.7305809242894, -122.382643589629)
78038	78038	11356	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1339 Ingalls St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			90	3X3		6017292.9099838	2093920.0801467	37.7304756321775	-122.382505299944	(37.7304756321775, -122.382505299944)
79746	79746	23414	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1800X VAN NESS AVE	2	Median : Cutout 11	Tree 1	DPW 2			30	9		6006192.0	2116736.0	37.7925033310543	-122.422503407712	(37.7925033310543, -122.422503407712)
80454	80454	12087	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1261X La Salle Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6017141.6501925	2094501.7221284	37.732064349457005	-122.383068698568	(37.732064349457, -122.383068698568)
80713	80713	12013	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1230X La Salle Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			45	3X3		6017323.1168478	2094452.6646717	37.7319396729967	-122.382437910438	(37.7319396729967, -122.382437910438)
81197	81197	11295	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1199X Ingalls St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	3X3		6017612.0195749	2093925.7037957	37.730508696225705	-122.38140247160801	(37.7305086962257, -122.381402471608)

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