Street_Tree_List

Data source: data.sfgov.org

2,400 rows where qLegalStatus = 3 and qSpecies = 15 sorted by PlotSize

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: qSiteInfo, qCaretaker, qCareAssistant, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▼	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
1023	1023	24311	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2639 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20			6006902.669840001	2121389.92308	37.8053218972443	-122.420374939461	(37.8053218972443, -122.420374939461)
3500	3500	13943	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1101 Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12		Permit Number 780155	6008953.3362	2112197.3558	37.780196698058894	-122.412628072717	(37.7801966980589, -122.412628072717)
5428	5428	24310	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2639 Hyde St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40			6006900.22287	2121405.53505	37.80536462583971	-122.420384516339	(37.8053646258397, -122.420384516339)
6950	6950	29570	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	928 Van Ness Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18			6006592.43621	2113707.60063	37.7842106764279	-122.42090277673701	(37.7842106764279, -122.420902776737)
10449	10449	98333	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	12X Canyon Dr	2	Median : Cutout 11	Tree 1	DPW 2			99			6003235.70781	2086338.01389	37.708870401808205	-122.43056224915199	(37.7088704018082, -122.430562249152)
11923	11923	87592	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	3039 19th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60			5990542.943940001	2094954.8149599999	37.731802780363104	-122.475058356779	(37.7318027803631, -122.475058356779)
15375	15375	28533	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	225 06th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			9			6010671.46792	2111896.6043700003	37.7794671834059	-122.40666303828999	(37.7794671834059, -122.40666303829)
16342	16342	13654	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	601 Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/10/1989 12:00:00 AM	25			6012250.572430001	2115370.08775	37.7890927810573	-122.401444392055	(37.7890927810573, -122.401444392055)
16776	16776	28527	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	275 06th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6			6010877.47547	2111683.2187	37.7788927999036	-122.405935331161	(37.7788927999036, -122.405935331161)
17511	17511	23000	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	741 Valencia St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/23/1994 12:00:00 AM	8			6006275.77922	2105260.31314	37.7609985961381	-122.421398202488	(37.7609985961381, -122.421398202488)
19646	19646	28217	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
20866	20866	28204	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
23009	23009	20248	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1837 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			21			6002502.1889	2114589.3013	37.786400200224705	-122.435116645364	(37.7864002002247, -122.435116645364)
23076	23076	24000	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	301 West Portal Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			10			5992329.4255	2097111.1167	37.7378268194972	-122.469039048495	(37.7378268194972, -122.469039048495)
23184	23184	23371	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1407 Van Ness Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/11/1989 12:00:00 AM	10			6006265.90478	2115346.54354	37.788692398380206	-122.422148937624	(37.7886923983802, -122.422148937624)
23193	23193	22935	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	360 Valencia St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/23/1994 12:00:00 AM	7			6006080.52288	2107591.71484	37.7673890643751	-122.422239154029	(37.7673890643751, -122.422239154029)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
77378	77378	113565	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
80237	80237	113567	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	29	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
80509	80509	110645	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	9	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
81219	81219	117257	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1570 31ST AVE	5	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4						5986686.8	2104596.0	37.7580506528461	-122.489098201432	(37.7580506528461, -122.489098201432)
82651	82651	13956	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1121 Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/10/1989 12:00:00 AM	12			6008871.8575552	2112133.2368395003	37.780016069429294	-122.41290541103201	(37.7800160694293, -122.412905411032)
82803	82803	102580	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	6	Median : Cutout 11	Tree 1	DPW 2		03/12/2013 12:00:00 AM			Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
82862	82862	113568	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
86421	86421	28199	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
87826	87826	28203	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
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)
90513	90513	102577	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	3	Median : Cutout 11	Tree 1	DPW 2		03/12/2013 12:00:00 AM			Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
90883	90883	110015	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	34 Maple St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						5996616.0	2116061.2	37.7901056424074	-122.455587678197	(37.7901056424074, -122.455587678197)
91146	91146	14114	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1551X Market St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6006862.6374	2110209.5058003003	37.7746209809445	-122.419719686331	(37.7746209809445, -122.419719686331)
92788	92788	28195	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
92877	92877	110644	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	8	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
96648	96648	8376	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1301X Geary Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24			6005507.71189	2114109.8093	37.7852538400076	-122.42468416339199	(37.7852538400076, -122.424684163392)
96778	96778	110017	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	34 Maple St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						5996616.0	2116061.2	37.7901056424074	-122.455587678197	(37.7901056424074, -122.455587678197)
98042	98042	110643	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	7	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
98483	98483	28211	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
98816	98816	102575	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	1	Median : Cutout 11	Tree 1	DPW 2					Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
98970	98970	28196	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
100040	100040	28197	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
102665	102665	102582	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	8	Median : Cutout 11	Tree 1	DPW 2					Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
103293	103293	102578	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	4	Median : Cutout 11	Tree 1	DPW 2		03/12/2013 12:00:00 AM			Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
104719	104719	95263	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2245 Jones St	1	Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	DPW for City Agency 2					6007968.5	2120121.7	37.801899679212	-122.416596591624	(37.801899679212, -122.416596591624)
105736	105736	110016	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	34 Maple St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						5996616.0	2116061.2	37.7901056424074	-122.455587678197	(37.7901056424074, -122.455587678197)
108048	108048	28209	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
108994	108994	28212	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
109302	109302	113562	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
111541	111541	13719	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	755X Market St	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6011317.3735797005	2114463.3908616	37.786551093642395	-122.404609305043	(37.7865510936424, -122.404609305043)
114785	114785	110640	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	4	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
114999	114999	28205	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
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)
116005	116005	95264	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2245 Jones St	2	Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	DPW for City Agency 2					6007968.5	2120121.7	37.801899679212	-122.416596591624	(37.801899679212, -122.416596591624)
116119	116119	110641	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	5	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
118377	118377	110639	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	3	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
120593	120593	102581	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	7	Median : Cutout 11	Tree 1	DPW 2					Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
120920	120920	95266	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2245 Jones St	5	Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	DPW for City Agency 2					6007968.5	2120121.7	37.801899679212	-122.416596591624	(37.801899679212, -122.416596591624)
121576	121576	102579	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	5	Median : Cutout 11	Tree 1	DPW 2		03/12/2013 12:00:00 AM			Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
122909	122909	28201	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/30/2014 01:34:00 PM	3			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
123340	123340	113566	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
123657	123657	28200	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/30/2014 01:37:00 PM	3			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
124135	124135	28207	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
125752	125752	113563	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
125810	125810	28213	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
125964	125964	110638	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	2	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
126015	126015	113564	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
126935	126935	28206	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
127094	127094	28210	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
127838	127838	28198	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
127842	127842	110014	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	34 Maple St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						5996616.0	2116061.2	37.7901056424074	-122.455587678197	(37.7901056424074, -122.455587678197)
128153	128153	110637	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	1	Median : Cutout 11	Tree 1	DPW 2			1			6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
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)
140524	140524	107868	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	830X Harrison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4						6012494.965419999	2112152.38808	37.7802713603069	-122.400372718325	(37.7802713603069, -122.400372718325)
140564	140564	28202	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
141562	141562	13958	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1123X Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6008859.4083565	2112121.3173335	37.7799826424976	-122.412947635568	(37.7799826424976, -122.412947635568)
142960	142960	113569	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	31	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2						6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
143508	143508	95265	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2245 Jones St	3	Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	DPW for City Agency 2					6007968.5	2120121.7	37.801899679212	-122.416596591624	(37.801899679212, -122.416596591624)
145206	145206	102576	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	2	Median : Cutout 11	Tree 1	DPW 2					Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
145640	145640	28215	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
146178	146178	28216	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/23/2014 11:00:00 PM	12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
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)
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)
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)
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)

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