Street_Tree_List

Data source: data.sfgov.org

170 rows where qSiteInfo = 11 and qSpecies = 46 sorted by Latitude

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, qAddress, SiteOrder, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude ▼	Longitude	Location
188835	188835	200601	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6016439.2859	2094833.5580000002	37.7329366690371	-122.385520065311	(37.7329366690371, -122.385520065311)
43571	43571	200600	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	6	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6016471.5892	2094834.3971	37.7329407602926	-122.385408441845	(37.7329407602926, -122.385408441845)
59826	59826	200635	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	9	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6016404.4653	2094836.0752	37.7329416541175	-122.385640625637	(37.7329416541175, -122.385640625637)
14093	14093	97435	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	4	Median : Cutout 11	Tree 1	DPW 2		09/30/2011 12:00:00 AM	3			6016490.8874	2094837.7533	37.732951043415206	-122.385341956131	(37.7329510434152, -122.385341956131)
46120	46120	200598	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	3	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6016502.2145	2094839.4314	37.732956277793896	-122.385302911931	(37.7329562777939, -122.385302911931)
173743	173743	200597	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	2	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6016514.3807	2094844.0461	37.732969621897794	-122.38526117126301	(37.7329696218978, -122.385261171263)
15940	15940	97233	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300X Newcomb Ave	13	Median : Cutout 11	Tree 1	DPW 2			6	15x200		6016357.8982	2094854.1147	37.7329886101989	-122.385802878589	(37.7329886101989, -122.385802878589)
115097	115097	97234	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1380X Newcomb Ave	14	Median : Cutout 11	Tree 1	DPW 2			8	15x200		6016360.63733	2094893.94179	37.7330981190079	-122.38579618360501	(37.7330981190079, -122.385796183605)
141737	141737	97434		Ulmus parvifolia :: Chinese Elm 46	1380x Newcomb Ave	5	Median : Cutout 11	Tree 1	DPW 2		09/30/2011 12:00:00 AM	3			6016360.63733	2094893.94179	37.7330981190079	-122.38579618360501	(37.7330981190079, -122.385796183605)
13974	13974	97229	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1301X Newcomb Ave	9	Median : Cutout 11	Tree 1	DPW 2			28	15x200		6016636.9425099995	2094930.8404400002	37.7332147213866	-122.38484348356701	(37.7332147213866, -122.384843483567)
16597	16597	97225	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1301X Newcomb Ave	5	Median : Cutout 11	Tree 1	DPW 2		09/30/2011 12:00:00 AM	3	15x200		6016649.85073	2094946.9135099999	37.7332595687675	-122.38479997523599	(37.7332595687675, -122.384799975236)
15023	15023	97221	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1301X Newcomb Ave	1	Median : Cutout 11	Tree 1	DPW 2			5	15x200		6016689.53805	2094986.8063299998	37.733371301443	-122.38466554190701	(37.733371301443, -122.384665541907)
36550	36550	18546	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1700X Quesada Ave	1	Median : Cutout 11	Tree 1	DPW 2			9	19		6014682.66084	2095048.92479	37.7334306737717	-122.391608273909	(37.7334306737717, -122.391608273909)
120892	120892	3749	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	934 Carolina St	3	Median : Cutout 11	Tree 1	DPW 2			3	18		6012421.507139799	2103592.6632765	37.756764184951	-122.40002555654199	(37.756764184951, -122.400025556542)
28092	28092	246547	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	20x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			3	Width 4ft		6005744.74711	2109415.26549	37.772377152311705	-122.42353021715599	(37.7723771523117, -122.423530217156)
78159	78159	109162	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	51x OCTAVIA ST	1	Median : Cutout 11	Tree 1	DPW 2			6	3x20		6005650.4	2109419.7	37.772384002649005	-122.42385688843399	(37.772384002649, -122.423856888434)
99764	99764	109166	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	51x OCTAVIA ST	5	Median : Cutout 11	Tree 1	DPW 2				3x20		6005650.4	2109419.7	37.772384002649005	-122.42385688843399	(37.772384002649, -122.423856888434)
143024	143024	109165	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	51x OCTAVIA ST	4	Median : Cutout 11	Tree 1	DPW 2				3x20		6005650.4	2109419.7	37.772384002649005	-122.42385688843399	(37.772384002649, -122.423856888434)
164702	164702	246548	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	20x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			6	Width 6ft		6005741.17746	2109432.24964	37.772423585213794	-122.423543772638	(37.7724235852138, -122.423543772638)
66611	66611	244468	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005635.3174	2109670.3256	37.7730713086411	-122.423926885709	(37.7730713086411, -122.423926885709)
149269	149269	244421	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005693.2117	2109673.0661	37.773082101669296	-122.423726816669	(37.7730821016693, -122.423726816669)
68766	68766	244467	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005631.8918	2109690.1946	37.7731256707262	-122.423940148458	(37.7731256707262, -122.423940148458)
25504	25504	244422	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005691.1562	2109690.8797	37.773130897486205	-122.423735193743	(37.7731308974862, -122.423735193743)
73396	73396	244466	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005631.2066	2109707.3231	37.7731726627699	-122.423943736898	(37.7731726627699, -122.423943736898)
62865	62865	244423	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005687.7306	2109711.4339	37.7731871409862	-122.423748505092	(37.7731871409862, -122.423748505092)
34532	34532	244424	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005686.3603	2109729.9326	37.7732378565997	-122.42375456071301	(37.7732378565997, -122.423754560713)
174364	174364	244465	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005629.1512	2109732.6732	37.773242151986	-122.423952649806	(37.773242151986, -122.423952649806)
152904	152904	244425	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005682.2494	2109755.2828	37.7733072300695	-122.423770583723	(37.7733072300695, -122.423770583723)
155187	155187	244456	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005624.3552	2109760.7639	37.773319011501705	-122.42397123777799	(37.7733190115017, -122.423971237778)
22362	22362	244426	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005680.8792	2109772.4112	37.773354183173396	-122.423776541571	(37.7733541831734, -122.423776541571)
161664	161664	244455	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005622.2998	2109777.2072	37.7733640447919	-122.423979517231	(37.7733640447919, -122.423979517231)
45981	45981	244376	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005617.5038	2109799.1317	37.7734239734056	-122.423997666684	(37.7734239734056, -122.423997666684)
76593	76593	244327	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005673.3426	2109802.5573	37.773436531636	-122.42380475570499	(37.773436531636, -122.423804755705)
28574	28574	244375	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005617.5038	2109823.1115	37.773489816144796	-122.423999372272	(37.7734898161448, -122.423999372272)
68449	68449	244328	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005669.917	2109835.444	37.7735266371926	-122.423818944241	(37.7735266371926, -122.423818944241)
187415	187415	244374	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005614.0781	2109847.0914	37.7735554657504	-122.42401292788901	(37.7735554657504, -122.424012927889)
157190	157190	244329	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005667.8615	2109858.0536	37.773588601656996	-122.423827662517	(37.773588601657, -122.423827662517)
176821	176821	244373	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005612.0227	2109867.6455	37.7736117862994	-122.424021499783	(37.7736117862994, -122.424021499783)
69750	69750	244330	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005665.121	2109878.6077	37.7736448835433	-122.42383860414199	(37.7736448835433, -122.423838604142)
56950	56950	244345	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005607.2268	2109894.3659	37.773684883292105	-122.424039990106	(37.7736848832921, -122.424039990106)
136512	136512	244331	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005661.6953	2109906.0133	37.7737199393103	-122.423852403284	(37.7737199393103, -122.423852403284)
129691	129691	244344	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005605.8565	2109917.6606	37.773748767543104	-122.424046387097	(37.7737487675431, -122.424046387097)
25458	25458	244288	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005589.8116	2110006.6495	37.7739922036556	-122.42410821881201	(37.7739922036556, -122.424108218812)
32047	32047	244254	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005646.3317	2110018.1063	37.774026852262104	-122.423913520847	(37.7740268522621, -122.423913520847)
67382	67382	244287	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005585.9927	2110033.3819999998	37.7740653890161	-122.424123330561	(37.7740653890161, -122.424123330561)
186972	186972	244255	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005643.2766	2110040.2561	37.7740874977816	-122.423925664351	(37.7740874977816, -122.423925664351)
77107	77107	244284	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005583.7013	2110055.5318	37.774126077633206	-122.42413283246701	(37.7741260776332, -122.424132832467)
173527	173527	244256	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005639.4577	2110060.8783	37.7741439057581	-122.423940341347	(37.7741439057581, -122.423940341347)
149777	149777	244283	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005579.1186	2110077.6816	37.7741866368779	-122.424150260413	(37.7741866368779, -122.424150260413)
156415	156415	244257	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005636.4025	2110083.7918	37.7742066482035	-122.42395253955699	(37.7742066482035, -122.423952539557)
138143	138143	244478	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005577.5911	2110096.7762	37.7742389797832	-122.424156902562	(37.7742389797832, -122.424156902562)
132653	132653	244258	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005634.1112	2110100.5951	37.7742526566427	-122.42396166072399	(37.7742526566427, -122.423961660724)
158186	158186	244477	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005574.5359	2110115.107	37.77428913922	-122.424168774988	(37.77428913922, -122.424168774988)
51603	51603	244259	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005631.8198	2110120.4535	37.7743070536408	-122.423970999545	(37.7743070536408, -122.423970999545)
38215	38215	244396	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005626.4733	2110143.3671	37.7743696669954	-122.42399112385799	(37.7743696669954, -122.423991123858)
29250	29250	244237	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005569.1894	2110157.879	37.774406278899995	-122.42419031206998	(37.7744062789, -122.42419031207)
33227	33227	244397	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005625.7095	2110167.0444	37.7744346360097	-122.423995450078	(37.7744346360097, -122.423995450078)
161575	161575	244236	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005567.6618	2110181.5564	37.774471205054496	-122.42419728060601	(37.7744712050545, -122.424197280606)
69418	69418	244398	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6005622.6544	2110184.6115	37.7744826985313	-122.42400726776	(37.7744826985313, -122.42400726776)
62806	62806	244235	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005565.3705	2110205.2337	37.774536087812	-122.424206890938	(37.774536087812, -122.424206890938)
147182	147182	244399	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005618.8355	2110208.2889	37.7745474953334	-122.424022162207	(37.7745474953334, -122.424022162207)
155394	155394	244400	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005615.7803	2110234.2576	37.774618626605296	-122.42403457786301	(37.7746186266053, -122.424034577863)
52888	52888	244411	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6005560.024	2110238.8403	37.7746280615118	-122.424227776164	(37.7746280615118, -122.424227776164)
162148	162148	244410	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005558.4964	2110254.116	37.7746699186287	-122.424234147092	(37.7746699186287, -122.424234147092)
164108	164108	244401	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005612.7252	2110260.2263	37.7746897578806	-122.424046993197	(37.7746897578806, -122.424046993197)
69759	69759	244364	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6005534.4686	2110345.8041	37.774920315184396	-122.424323786781	(37.7749203151844, -122.424323786781)
172378	172378	244353	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005598.6806	2110351.942	37.7749407940225	-122.424102100187	(37.7749407940225, -122.424102100187)
170608	170608	244363	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6005533.5243	2110362.3292	37.7749656357807	-122.42432822890801	(37.7749656357807, -122.424328228908)
184309	184309	244362	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005532.1079	2110378.8544	37.7750109299929	-122.42433430414499	(37.7750109299929, -122.424334304145)
57681	57681	244354	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		6005594.4313	2110381.2151	37.7750209309426	-122.424118881689	(37.7750209309426, -122.424118881689)
176025	176025	244355	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6005591.5984	2110402.9339	37.7750804055544	-122.42413022622601	(37.7750804055544, -122.424130226226)
51495	51495	244361	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005527.8586	2110404.3503	37.7750806956038	-122.424350817202	(37.7750806956038, -122.424350817202)
29153	29153	244356	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005588.2934	2110426.5412	37.775145038872104	-122.424143338216	(37.7751450388721, -122.424143338216)
174240	174240	244360	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005525.0257	2110428.4298	37.7751466521023	-122.424362329876	(37.7751466521023, -122.424362329876)
60342	60342	244357	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005584.9883	2110453.4536	37.7752187471852	-122.424156685679	(37.7752187471852, -122.424156685679)
34812	34812	244359	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005522.1928	2110456.2865	37.7752229798737	-122.42437411128701	(37.7752229798737, -122.424374111287)
66723	66723	244358	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	6	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005582.6276	2110470.923	37.775266580631	-122.42416609455	(37.775266580631, -122.42416609455)
169025	169025	244305	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	7	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005579.7947	2110490.7532	37.775320869598204	-122.424177304818	(37.7753208695982, -122.424177304818)
27441	27441	244317	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005516.527000001	2110492.6418	37.775322482765205	-122.42439629699699	(37.7753224827652, -122.424396296997)
31383	31383	244306	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6005576.9618	2110512.9441	37.7753816404734	-122.42418868303001	(37.7753816404734, -122.42418868303)
137760	137760	244316	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005509.917	2110533.7186	37.7754348964248	-122.424422084884	(37.7754348964248, -122.424422084884)
131483	131483	244307	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005574.129	2110533.2464	37.775437225714995	-122.424199926569	(37.775437225715, -122.424199926569)
182189	182189	244315	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	3	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005508.5005	2110550.2437	37.7754801903482	-122.42442816055599	(37.7754801903482, -122.424428160556)
166112	166112	244308	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	10	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005570.3518	2110556.8538	37.7755018326332	-122.424214672145	(37.7755018326332, -122.424214672145)
137478	137478	244312	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005504.7234	2110575.2675	37.7755486863335	-122.424443006762	(37.7755486863335, -122.424443006762)
55243	55243	244309	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	11	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005567.5189	2110582.8218	37.7755729745028	-122.42422631910499	(37.7755729745028, -122.424226319105)
29392	29392	244311	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	1	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005501.4183	2110598.8748	37.7756133196055	-122.424456119453	(37.7756133196055, -122.424456119453)
42949	42949	244310	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	12	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005563.2696	2110605.957	37.77563625821271	-122.424242664251	(37.7756362582127, -122.424242664251)
81045	81045	109169	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	6	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
83700	83700	109168	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	7	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
97204	97204	109171	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	4	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
99403	99403	109164	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	11	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
116938	116938	109163	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	12	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
121401	121401	109167	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	8	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
126070	126070	109170	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	5	Median : Cutout 11	Tree 1	DPW 2				3x20		2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
144933	144933	119701	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	6x Octavia St Frontage West	3	Median : Cutout 11	Tree 1	DPW 2						2109337.0	6005692.0	47.2698908128932	-138.283860688311	(47.2698908128932, -138.283860688311)
1192	1192	119753	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	8	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1196	1196	119750	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	5	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1202	1202	119754	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	9	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1204	1204	119749	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	4	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)

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