Street_Tree_List

Data source: data.sfgov.org

107 rows where qSiteInfo = 3 and qSpecies = 15

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, qCaretaker, DBH, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
22808	22808	195725	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	9	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6014714.95739	2111115.10019	37.7775467477219	-122.39262009845	(37.7775467477219, -122.39262009845)
23423	23423	195472	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	8	Median : Yard 3	Tree 1	DPW 2			7			6014582.56054	2117381.49578	37.7947454787808	-122.39351677468099	(37.7947454787808, -122.393516774681)
26183	26183	195467	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			8			6014580.603680001	2117309.91593	37.7945488285163	-122.393518533752	(37.7945488285163, -122.393518533752)
26428	26428	195683	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	12	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6015319.49651	2111685.54707	37.7791466227626	-122.390568648644	(37.7791466227626, -122.390568648644)
27106	27106	195241	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400x Evans Ave	17	Median : Yard 3	Tree 1	DPW 2			5			6016370.1217	2098002.92096	37.7416352733631	-122.38598003597299	(37.7416352733631, -122.385980035973)
27830	27830	195766	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	2	Median : Yard 3	Tree 1	DPW 2			8	Width 8ft		6014104.3852699995	2110532.00713	37.7759117775522	-122.394691443959	(37.7759117775522, -122.394691443959)
27977	27977	195679	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	8	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015392.54447	2111760.15634	37.779355535273105	-122.390321157906	(37.7793555352731, -122.390321157906)
28194	28194	195471	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	7	Median : Yard 3	Tree 1	DPW 2			7			6014542.5915	2117352.94839	37.794664873444795	-122.393653075045	(37.7946648734448, -122.393653075045)
28390	28390	195474	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	10	Median : Yard 3	Tree 1	DPW 2			7			6014565.75221	2117404.86556	37.794808712796396	-122.393576570627	(37.7948087127964, -122.393576570627)
30288	30288	195777	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	18	Median : Yard 3	Tree 1	DPW 2			13	Width 8ft		6013688.74919	2110125.02195	37.774771170975704	-122.396100718491	(37.7747711709757, -122.396100718491)
31536	31536	135595	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	3	Median : Yard 3	Tree 1	DPW 2			3	Width 7ft		6013640.01114	2117757.01067	37.7957241381178	-122.39680448565001	(37.7957241381178, -122.39680448565)
31865	31865	195466	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			8			6014635.8418	2117314.36588	37.794564116081204	-122.393327712917	(37.7945641160812, -122.393327712917)
32361	32361	195685	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	14	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015271.08065	2111640.36137	37.7790198669015	-122.390732981757	(37.7790198669015, -122.390732981757)
32926	32926	195231	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1300x Evans Ave	1	Median : Yard 3	Tree 1	DPW 2			11	Width 7ft		6017124.15925	2097442.52392	37.7401382376012	-122.38333380241001	(37.7401382376012, -122.38333380241)
34980	34980	195728	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	12	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014648.54809	2111053.65479	37.7773743440827	-122.39284553241501	(37.7773743440827, -122.392845532415)
35206	35206	195775	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	12	Median : Yard 3	Tree 1	DPW 2			7	Width 8ft		6013821.82406	2110259.84157	37.7751487585315	-122.395649829891	(37.7751487585315, -122.395649829891)
35659	35659	135604	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	15	Median : Yard 3	Tree 1	DPW 2			7			6014333.85609	2117662.37655	37.7955028896086	-122.394397008632	(37.7955028896086, -122.394397008632)
36397	36397	195772	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	9	Median : Yard 3	Tree 1	DPW 2			10	Width 8ft		6013930.44742	2110363.9939599996	37.7754407791936	-122.395281372244	(37.7754407791936, -122.395281372244)
36505	36505	135612	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	23	Median : Yard 3	Tree 1	DPW 2			8			6014267.8224	2117757.0986900004	37.7957593033995	-122.39463213458201	(37.7957593033995, -122.394632134582)
38029	38029	135591	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	150x Drumm St	6	Median : Yard 3	Tree 1	DPW 2			6	Width 7ft		6013668.97989	2117535.62616	37.7951178808501	-122.39668872043	(37.7951178808501, -122.39668872043)
38423	38423	135585	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	5	Median : Yard 3	Tree 1	DPW 2			7	Width 7ft		6013716.425530001	2117200.6985	37.7942008889087	-122.396501061571	(37.7942008889087, -122.396501061571)
38581	38581	195678	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	7	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015414.68674	2111779.65655	37.779410306669796	-122.39024592062	(37.7794103066698, -122.39024592062)
41025	41025	135586	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	6	Median : Yard 3	Tree 1	DPW 2			9	Width 7ft		6013710.78377	2117230.4416	37.794282242493	-122.39652266870701	(37.794282242493, -122.396522668707)
41103	41103	195768	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	4	Median : Yard 3	Tree 1	DPW 2			7	Width 8ft		6014054.2182599995	2110478.98946	37.775763413678	-122.394861271956	(37.775763413678, -122.394861271956)
44024	44024	135602	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			7			6014349.4143900005	2117640.04464	37.7954424362789	-122.39434160947901	(37.7954424362789, -122.394341609479)
44028	44028	135590	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	150x Drumm St	5	Median : Yard 3	Tree 1	DPW 2			8	Width 7ft		6013675.90495	2117467.1976	37.7949303775801	-122.396659959189	(37.7949303775801, -122.396659959189)
44208	44208	135607	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	18	Median : Yard 3	Tree 1	DPW 2			8			6014352.16969	2117713.37896	37.7956439482691	-122.394337212703	(37.7956439482691, -122.394337212703)
45105	45105	195677	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	6	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6015444.73624	2111808.1158	37.779490116104	-122.39014395459	(37.779490116104, -122.39014395459)
48350	48350	135606	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	17	Median : Yard 3	Tree 1	DPW 2			7			6014317.5714300005	2117686.49478	37.795568207348104	-122.394455046367	(37.7955682073481, -122.394455046367)
48494	48494	195774	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	11	Median : Yard 3	Tree 1	DPW 2			7	Width 8ft		6013840.56716	2110278.0449099997	37.7751997833822	-122.39558626849701	(37.7751997833822, -122.395586268497)
48962	48962	195770	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	6	Median : Yard 3	Tree 1	DPW 2			8	Width 8ft		6014000.92339	2110427.4645700003	37.7756189744596	-122.395042023971	(37.7756189744596, -122.395042023971)
49237	49237	195730	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	14	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6014584.98378	2110993.5551299998	37.777205793145704	-122.393061217713	(37.7772057931457, -122.393061217713)
49952	49952	135593	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	1	Median : Yard 3	Tree 1	DPW 2			7	Width 7ft		6013643.30781	2117724.86941	37.795636069300606	-122.396790824061	(37.7956360693006, -122.396790824061)
53516	53516	135600	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	8	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013623.6813	2117874.05106	37.7960445944406	-122.39686919997	(37.7960445944406, -122.39686919997)
55905	55905	195769	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	5	Median : Yard 3	Tree 1	DPW 2			8	Width 8ft		6014035.25222	2110463.93544	37.77572102415021	-122.394925826163	(37.7757210241502, -122.394925826163)
56412	56412	195676	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	5	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6015463.68033	2111825.11578	37.7795378449375	-122.39007960629401	(37.7795378449375, -122.390079606294)
56543	56543	135603	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	14	Median : Yard 3	Tree 1	DPW 2			8			6014389.6268	2117668.08045	37.795521651247704	-122.39420443049299	(37.7955216512477, -122.394204430493)
64015	64015	195776	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	13	Median : Yard 3	Tree 1	DPW 2			7	Width 8ft		6013789.3208	2110228.4798	37.7750608381088	-122.39576006878299	(37.7750608381088, -122.395760068783)
66276	66276	195735	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	19	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6014466.4540800005	2110880.54838	37.7768889170254	-122.393463342353	(37.7768889170254, -122.393463342353)
66951	66951	195729	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	13	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6014619.82632	2111026.87564	37.7772992192097	-122.392943017131	(37.7772992192097, -122.392943017131)
67353	67353	195773	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	10	Median : Yard 3	Tree 1	DPW 2			8	Width 8ft		6013858.15082	2110295.7002	37.7752492388859	-122.39552667940599	(37.7752492388859, -122.395526679406)
67913	67913	135584	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	4	Median : Yard 3	Tree 1	DPW 2			10	Width 7ft		6013720.96572	2117170.97741	37.7941195344513	-122.39648326760201	(37.7941195344513, -122.396483267602)
68228	68228	135316	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	33x Battery St	6	Median : Yard 3	Tree 1	DPW 2			9			6012845.19135	2116083.76895	37.7910855411081	-122.399437196994	(37.7910855411081, -122.399437196994)
70561	70561	195242	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400x Evans Ave	18	Median : Yard 3	Tree 1	DPW 2			11			6016348.05088	2098008.79915	37.7416501921989	-122.38605675982099	(37.7416501921989, -122.386056759821)
70908	70908	195237	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200x Evans Ave	32	Median : Yard 3	Tree 1	DPW 2			9			6017245.0547	2097350.40694	37.7398919834226	-122.38290938175699	(37.7398919834226, -122.382909381757)
71743	71743	195234	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200x Evans Ave	5	Median : Yard 3	Tree 1	DPW 2			16			6017566.91027	2097112.20997	37.7392557202661	-122.38177996546999	(37.7392557202661, -122.38177996547)
76154	76154	195239	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200x Evans Ave	34	Median : Yard 3	Tree 1	DPW 2			9			6017229.97011	2097361.8640799997	37.739922608954394	-122.38296233565	(37.7399226089544, -122.38296233565)
89300	89300	195233	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1300x Evans Ave	5	Median : Yard 3	Tree 1	DPW 2			8			6017040.627309999	2097503.91536	37.740302189387	-122.383626897758	(37.740302189387, -122.383626897758)
109545	109545	111090	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	28x HIGUERA AVE	1	Median : Yard 3	Tree 1	Private 1		06/04/2015 12:00:00 AM	3		Permit Number 777485	5987903.0	2090420.0	37.7191979850677	-122.483852684784	(37.7191979850677, -122.483852684784)
115435	115435	135314	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	33x Battery St	4	Median : Yard 3	Tree 1	DPW 2			10			6012837.6857	2116086.25661	37.7910919532935	-122.399463341174	(37.7910919532935, -122.399463341174)
129785	129785	135594	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	2	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013641.29963	2117738.5675	37.7956735692465	-122.396798733574	(37.7956735692465, -122.396798733574)
133285	133285	195673	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	2	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6015527.8527	2111885.3712299997	37.779706851835	-122.38986181478201	(37.779706851835, -122.389861814782)
133666	133666	135589	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	150x Drumm St	1	Median : Yard 3	Tree 1	DPW 2			7	Width 7ft		6013690.1191300005	2117409.79568	37.79477355652	-122.396606749907	(37.79477355652, -122.396606749907)
133769	133769	195718	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	2	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6014865.41791	2111256.9262	37.7779445250517	-122.392109521844	(37.7779445250517, -122.392109521844)
137170	137170	195470	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			7			6014599.87195	2117357.86297	37.7946815504669	-122.393455219683	(37.7946815504669, -122.393455219683)
138097	138097	195731	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	15	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6014552.634330001	2110961.58768	37.777116220658996	-122.39317088824801	(37.777116220659, -122.393170888248)
146547	146547	195767	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	3	Median : Yard 3	Tree 1	DPW 2			9	Width 8ft		6014073.23663	2110496.61551	37.7758128682948	-122.39479671682	(37.7758128682948, -122.39479671682)
146587	146587	135587	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	7	Median : Yard 3	Tree 1	DPW 2			9	Width 7ft		6013707.40444	2117263.065	37.794371630605795	-122.39653664955699	(37.7943716306058, -122.396536649557)
147121	147121	135609	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	20	Median : Yard 3	Tree 1	DPW 2			7			6014337.09374	2117734.43585	37.7957009275062	-122.394390853653	(37.7957009275062, -122.394390853653)
147288	147288	135613	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	24	Median : Yard 3	Tree 1	DPW 2			7			6014299.10816	2117778.7327400004	37.7958204447215	-122.39452539493799	(37.7958204447215, -122.394525394938)
147917	147917	135592	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	150x Drumm St	7	Median : Yard 3	Tree 1	DPW 2			6	Width 7ft		6013656.57361	2117641.2066	37.7954070893311	-122.39673905365801	(37.7954070893311, -122.396739053658)
148173	148173	195726	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	10	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014684.461	2111087.65497	37.777469695597	-122.39272367606002	(37.777469695597, -122.39272367606)
148507	148507	195232	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1300x Evans Ave	3	Median : Yard 3	Tree 1	DPW 2			16	Width 8ft		6017081.8167	2097473.87775	37.740221988756105	-122.383482389326	(37.7402219887561, -122.383482389326)
149614	149614	195238	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200x Evans Ave	33	Median : Yard 3	Tree 1	DPW 2			8			6017232.2408	2097349.7546	37.7398894842228	-122.382953641924	(37.7398894842228, -122.382953641924)
150007	150007	195771	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	7	Median : Yard 3	Tree 1	DPW 2			9	Width 8ft		6013983.076169999	2110410.9582599998	37.7755726593879	-122.39510260590201	(37.7755726593879, -122.395102605902)
150043	150043	135601	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	9	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013619.0965	2117904.14877	37.7961269804374	-122.396887175602	(37.7961269804374, -122.396887175602)
150266	150266	135599	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	7	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013626.9255	2117849.56722	37.7959775481806	-122.39685625692499	(37.7959775481806, -122.396856256925)
151097	151097	195727	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	11	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6014667.91656	2111070.80187	37.777422501882896	-122.392779729899	(37.7774225018829, -122.392779729899)
151440	151440	195724	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	8	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6014732.91022	2111131.92484	37.7775939414569	-122.39255917029	(37.7775939414569, -122.39255917029)
153173	153173	195468	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			6			6014618.49962	2117336.48086	37.7946238751469	-122.39338926790701	(37.7946238751469, -122.393389267907)
153591	153591	135582	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	2	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013728.8853	2117108.6329200002	37.7939487918665	-122.396451492763	(37.7939487918665, -122.396451492763)
154299	154299	135611	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	22	Median : Yard 3	Tree 1	DPW 2			7			6014316.69875	2117756.35966	37.795759991389204	-122.39446296041001	(37.7957599913892, -122.39446296041)
154315	154315	195475	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			6			6014508.20753	2117399.45004	37.7947906454237	-122.39377530549999	(37.7947906454237, -122.3937753055)
154428	154428	195674	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	3	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015508.64587	2111869.51632	37.779662252656294	-122.389927152313	(37.7796622526563, -122.389927152313)
154568	154568	195723	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	7	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014750.92686	2111151.90526	37.777649803738896	-122.392498242106	(37.7776498037389, -122.392498242106)
155002	155002	195465	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			5			6014600.5066599995	2117288.76118	37.794491848365205	-122.39344818519899	(37.7944918483652, -122.393448185199)
160641	160641	135614	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	25	Median : Yard 3	Tree 1	DPW 2			7			6014250.33461	2117779.72028	37.7958204447077	-122.394694230949	(37.7958204447077, -122.394694230949)
161476	161476	195473	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			8			6014525.02119	2117376.33329	37.794728106566	-122.393715508675	(37.794728106566, -122.393715508675)
162122	162122	195236	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200x Evans Ave	31	Median : Yard 3	Tree 1	DPW 2			9			6017248.0064199995	2097338.05613	37.7398582336715	-122.382898316528	(37.7398582336715, -122.382898316528)
162147	162147	195469	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			4			6014561.45275	2117330.54944	37.7946044192093	-122.393586243706	(37.7946044192093, -122.393586243706)
168848	168848	135596	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	4	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013635.89834	2117779.6494400003	37.7957860699142	-122.396820304724	(37.7957860699142, -122.396820304724)
169337	169337	135313	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	33x Battery St	3	Median : Yard 3	Tree 1	DPW 2			10			6012855.39905	2116098.8702	37.7911275745228	-122.39940293909099	(37.7911275745228, -122.399402939091)
169353	169353	135315	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	33x Battery St	5	Median : Yard 3	Tree 1	DPW 2			6			6012858.7007	2116094.65173	37.7911161756167	-122.399391219139	(37.7911161756167, -122.399391219139)
170260	170260	195684	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	13	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6015289.74436	2111657.65185	37.779068378153	-122.39066962450799	(37.779068378153, -122.390669624508)
170418	170418	195682	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	11	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6015332.35887	2111698.96547	37.7791841802313	-122.39052508997	(37.7791841802313, -122.39052508997)
171564	171564	135597	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	5	Median : Yard 3	Tree 1	DPW 2			3	Width 7ft		6013633.10727	2117805.98643	37.7958582297137	-122.39683180976299	(37.7958582297137, -122.396831809763)
172202	172202	195721	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	5	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6014799.00222	2111195.13044	37.777771160036295	-122.39233495579599	(37.7777711600363, -122.392334955796)
173405	173405	195719	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	3	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6014846.74684	2111239.41443	37.7778954049955	-122.39217288717501	(37.7778954049955, -122.392172887175)
173646	173646	195240	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400x Evans Ave	16	Median : Yard 3	Tree 1	DPW 2			10			6016376.5567	2097988.3018	37.7415954882544	-122.385956766892	(37.7415954882544, -122.385956766892)
175056	175056	195675	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	4	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015482.36105	2111843.26089	37.7795887033991	-122.390016249049	(37.7795887033991, -122.390016249049)
175988	175988	135608	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	19	Median : Yard 3	Tree 1	DPW 2			6			6014300.48384	2117708.60482	37.7956279664036	-122.394515721817	(37.7956279664036, -122.394515721817)
176793	176793	195736	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	20	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6014449.17675	2110862.30677	37.7768378696968	-122.393521833393	(37.7768378696968, -122.393521833393)
176932	176932	195722	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	6	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014782.12024	2111178.98534	37.7777258917748	-122.392392227319	(37.7777258917748, -122.392392227319)
177428	177428	135583	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	3	Median : Yard 3	Tree 1	DPW 2			10	Width 7ft		6013725.73224	2117134.30218	37.794019098152205	-122.396464202864	(37.7940190981522, -122.396464202864)
178884	178884	135615	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	26	Median : Yard 3	Tree 1	DPW 2			7			6014281.27914	2117801.86987	37.795882982666505	-122.394588708116	(37.7958829826665, -122.394588708116)
178958	178958	195733	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	17	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6014512.42504	2110924.16677	37.777011237428205	-122.39330736664301	(37.7770112374282, -122.393307366643)
179167	179167	135588	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	8	Median : Yard 3	Tree 1	DPW 2			10	Width 7ft		6013703.14985	2117288.7562700002	37.794441936008894	-122.39655317280899	(37.7944419360089, -122.396553172809)
179408	179408	195734	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	18	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6014485.12564	2110898.06022	37.776938038003294	-122.39339997704398	(37.7769380380033, -122.393399977044)
180074	180074	195732	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	16	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6014536.11101	2110945.78626	37.7770719155794	-122.39322694208401	(37.7770719155794, -122.393226942084)
180077	180077	135605	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	16	Median : Yard 3	Tree 1	DPW 2			7			6014374.07873	2117690.91849	37.795583494923704	-122.39425982964899	(37.7955834949237, -122.394259829649)

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