Street_Tree_List

Data source: data.sfgov.org

184 rows where qCaretaker = 2 and qSpecies = 62 sorted by XCoord

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
1529	1529	251578	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	6	Median : Cutout 11	Tree 1	DPW 2
6803	6803	19590	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	100 STAIRWAY4	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
7231	7231	19588	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	100 STAIRWAY4	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
7407	7407	19591	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	100 STAIRWAY4	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
12970	12970	19589	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	100 STAIRWAY4	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
16521	16521	19806	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	100 STAIRWAY23	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60ST
112719	112719	21073	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2192X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60		5984923.321673	2100279.0596028	37.7460944336033	-122.494878681905	(37.7460944336033, -122.494878681905)
115970	115970	21074	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2192X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60		5984923.321673	2100279.0596028	37.7460944336033	-122.494878681905	(37.7460944336033, -122.494878681905)
140920	140920	21075	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2192X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60		5984923.321673	2100279.0596028	37.7460944336033	-122.494878681905	(37.7460944336033, -122.494878681905)
127535	127535	12849	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2412 Lake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/02/2010 12:00:00 AM	12	3X3		5987958.93678	2114680.36581	37.7858136848869	-122.48543867329501	(37.7858136848869, -122.485438673295)
109022	109022	29640	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1110X Junipero Serra Blvd	13	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
110556	110556	29641	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1110X Junipero Serra Blvd	14	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
144121	144121	29639	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1110X Junipero Serra Blvd	12	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991107.8990450995	2089843.5367701	37.717801208369	-122.47273266668002	(37.717801208369, -122.47273266668)
30755	30755	208080	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000x Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991162.63824	2089810.37082	37.7177133113937	-122.472541042839	(37.7177133113937, -122.472541042839)
65001	65001	208083	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000x Junipero Serra Blvd	46	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991231.056580001	2090980.0304	37.720928868853896	-122.472389775075	(37.7209288688539, -122.472389775075)
33216	33216	208082	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000x Junipero Serra Blvd	45	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991232.009819999	2090962.1201799999	37.720879746979705	-122.47238517505	(37.7208797469797, -122.47238517505)
42602	42602	208081	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000x Junipero Serra Blvd	43	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991233.74878	2090918.35178	37.720759670396106	-122.47237597496999	(37.7207596703961, -122.47237597497)
88746	88746	11784	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	810X Junipero Serra Blvd	16	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	6X6		5991252.992504	2092079.9575241	37.7239502662313	-122.472394094235	(37.7239502662313, -122.472394094235)
18117	18117	11765	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800X Junipero Serra Blvd	3	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991272.34511	2091581.45548	37.7225826231682	-122.47229087392	(37.7225826231682, -122.47229087392)
20128	20128	11766	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800X Junipero Serra Blvd	4	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	6X6		5991273.54078	2091606.60865	37.72265175674929	-122.47228857348101	(37.7226517567493, -122.472288573481)
21942	21942	11767	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800X Junipero Serra Blvd	5	Median : Cutout 11	Tree 1	DPW 2		03/30/2006 12:00:00 AM	3	3X3		5991276.05264	2091631.0711599998	37.7227190701221	-122.472281672976	(37.7227190701221, -122.472281672976)
91557	91557	29978	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	610X Junipero Serra Blvd	5	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3x3		5991336.00972369	2093444.32433125	37.7277012826104	-122.47220652658001	(37.7277012826104, -122.47220652658)
101082	101082	29979	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	610X Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3x3		5991336.00972369	2093444.32433125	37.7277012826104	-122.47220652658001	(37.7277012826104, -122.47220652658)
140520	140520	29589	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	610X Junipero Serra Blvd	3	Median : Cutout 11	Tree 1	DPW 2		04/01/2007 12:00:00 AM	3	3X3		5991336.987432401	2093443.9543843998	37.7277003234109	-122.472203119704	(37.7277003234109, -122.472203119704)
38457	38457	208084	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800x Junipero Serra Blvd	53	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991354.011469999	2092835.9648	37.726031920722605	-122.47209997035	(37.7260319207226, -122.47209997035)
25223	25223	208086	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800x Junipero Serra Blvd	56	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		5991357.47228	2092905.4597099999	37.7262229367261	-122.472093069866	(37.7262229367261, -122.472093069866)
150230	150230	208085	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800x Junipero Serra Blvd	55	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		5991358.2999	2092881.5903900003	37.726157445407296	-122.47208846980301	(37.7261574454073, -122.472088469803)
19955	19955	29580	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	500X Junipero Serra Blvd	2	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991386.6913	2093344.7747799999	37.7274308773069	-122.47202406848	(37.7274308773069, -122.47202406848)
19813	19813	29581	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	500X Junipero Serra Blvd	3	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991390.5187800005	2093368.54568	37.7274963677541	-122.47201256884199	(37.7274963677541, -122.472012568842)
90967	90967	208087	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	500x Junipero Serra Blvd	5	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991392.30049	2093421.51137	37.7276419014288	-122.472010268365	(37.7276419014288, -122.472010268365)
105098	105098	30048	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1400X Junipero Serra Blvd	29	Median : Cutout 11	Tree 1	DPW 2			3	3X3		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
105889	105889	30047	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1400X Junipero Serra Blvd	28	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
146267	146267	30049	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1400X Junipero Serra Blvd	30	Median : Cutout 11	Tree 1	DPW 2			3	6X6		5991408.898027	2088383.098472	37.7138086207581	-122.47158589282199	(37.7138086207581, -122.471585892822)
66612	66612	208088	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	500x Junipero Serra Blvd	40	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991446.48536	2094319.42031	37.7301104703116	-122.471888366152	(37.7301104703116, -122.471888366152)
68520	68520	208089	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	500x Junipero Serra Blvd	42	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		5991450.70341	2094361.7324599999	37.730226892943705	-122.471876866532	(37.7302268929437, -122.471876866532)
147762	147762	208136	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	255x San Marcos Ave	5	Median : Cutout 11	Tree 1	DPW 2			5	Width 5ft		5993099.62509	2100246.71576	37.746480853819	-122.466603967821	(37.746480853819, -122.466603967821)
187159	187159	208135	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	15x San Marcos Ave	21	Median : Cutout 11	Tree 1	DPW 2			5	Width 5ft		5993326.71612	2100337.0457	37.7467419791719	-122.465825280839	(37.7467419791719, -122.465825280839)
7804	7804	1666	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1400X Fell St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6000356.4682	2109956.4177	37.7735574116821	-122.44220758007401	(37.7735574116821, -122.442207580074)
551	551	1664	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1400X Fell St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6000454.8566	2109968.1462	37.7735952220186	-122.441868082855	(37.7735952220186, -122.441868082855)
8492	8492	1663	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1400X Fell St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6000501.7702	2109972.7072	37.773610418483	-122.44170612948601	(37.773610418483, -122.441706129486)
8814	8814	1661	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1400X Fell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6000589.0817	2109986.3904	37.773652963463796	-122.441405088647	(37.7736529634638, -122.441405088647)
6547	6547	1660	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1400X Fell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6000641.8596	2109991.603	37.7736702824704	-122.441222896356	(37.7736702824704, -122.441222896356)
5931	5931	22784	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1880 Turk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6001016.5841	2112130.2222	37.7795637284835	-122.440080052813	(37.7795637284835, -122.440080052813)
20957	20957	4302	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	4378 Cesar Chavez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6001457.95867	2100305.5079	37.747121080269295	-122.437706046203	(37.7471210802693, -122.437706046203)
17242	17242	4298	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	4350 Cesar Chavez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6001589.80492	2100313.4171	37.7471502929454	-122.437250699681	(37.7471502929454, -122.437250699681)
21192	21192	3896	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	60 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	5X5		6002168.7084800005	2107927.71258	37.7680902055206	-122.435793601904	(37.7680902055206, -122.435793601904)
139460	139460	2739	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2290X Bush St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/12/1992 12:00:00 AM	8	3x3		6002556.047619999	2114770.51181	37.7869008162884	-122.434943272404	(37.7869008162884, -122.434943272404)
134560	134560	138492	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2290 Bush St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/12/1992 12:00:00 AM	6	Width 0ft		6002608.3612	2114780.8430000003	37.7869321532521	-122.434763018716	(37.7869321532521, -122.434763018716)
35927	35927	117079	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1520 Fillmore St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			4	5x5		6003184.5706	2113558.6463	37.7836090062437	-122.43268212910499	(37.7836090062437, -122.432682129105)
84104	84104	117076	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1538 FILLMORE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			7	5x5		6003192.0	2113651.0	37.7838630075842	-122.43266302547701	(37.7838630075842, -122.432663025477)
88844	88844	117077	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1538 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	5x5		6003192.0	2113651.0	37.7838630075842	-122.43266302547701	(37.7838630075842, -122.432663025477)
151845	151845	117080	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1520 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	5x5		6003203.0	2113571.0	37.7836439715484	-122.432619253214	(37.7836439715484, -122.432619253214)
122689	122689	117081	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1526 FILLMORE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				5x5		6003241.0	2113609.0	37.7837504649041	-122.432490502891	(37.7837504649041, -122.432490502891)
116982	116982	23926	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1700X Webster St	8	Median : Cutout 11	Tree 1	DPW 2			30	12x1		6003454.884490401	2114845.825423	37.7871586020093	-122.43183888463899	(37.7871586020093, -122.431838884639)
125350	125350	23923	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1700X Webster St	5	Median : Cutout 11	Tree 1	DPW 2			30	12x1		6003454.884490401	2114845.825423	37.7871586020093	-122.43183888463899	(37.7871586020093, -122.431838884639)
7162	7162	23924	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1700X Webster St	6	Median : Cutout 11	Tree 1	DPW 2			20	12x1		6003487.1069	2114786.6255	37.7869978805436	-122.43172317383998	(37.7869978805436, -122.43172317384)
90522	90522	19141	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	41 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6003499.5609963	2108090.4356538	37.76861251084271	-122.43120194209	(37.7686125108427, -122.43120194209)
106174	106174	19140	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	41 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6003499.5609963	2108090.4356538	37.76861251084271	-122.43120194209	(37.7686125108427, -122.43120194209)
87847	87847	19146	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	45 Sanchez St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003500.9045907995	2108066.1860563997	37.76854600349329	-122.431195563592	(37.7685460034933, -122.431195563592)
146177	146177	19145	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	45 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6003500.9045907995	2108066.1860563997	37.76854600349329	-122.431195563592	(37.7685460034933, -122.431195563592)
1473	1473	23922	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1700X Webster St	4	Median : Cutout 11	Tree 1	DPW 2		04/21/2008 12:00:00 AM	3	12x1		6003506.5026	2114704.4246	37.786773277055204	-122.431650198179	(37.7867732770552, -122.431650198179)
21559	21559	19144	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	45 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6003508.29583	2108036.92775	37.768466086156394	-122.431167909289	(37.7684660861564, -122.431167909289)
68782	68782	137952	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1700x WEBSTER ST	3	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6003511.8133	2114663.5551	37.786661360752895	-122.431628905483	(37.7866613607529, -122.431628905483)
108719	108719	19149	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	49 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6003514.43662	2108031.11939	37.7684504857975	-122.431146254215	(37.7684504857975, -122.431146254215)
7311	7311	23920	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1700X Webster St	2	Median : Cutout 11	Tree 1	DPW 2			20	12x12		6003521.972999999	2114612.7568	37.786522457310205	-122.43159012740699	(37.7865224573102, -122.431590127407)
7873	7873	28650	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1600X Webster St	12	Median : Cutout 11	Tree 1	DPW 2			8	6		6003539.955	2114426.6147	37.786012377283896	-122.431514620567	(37.7860123772839, -122.431514620567)
8006	8006	23900	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1600X Webster St	3	Median : Cutout 11	Tree 1	DPW 2			20	6		6003566.3311	2114312.7691	37.7857012808729	-122.43141523648701	(37.7857012808729, -122.431415236487)
80400	80400	28651	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1600X Webster St	13	Median : Cutout 11	Tree 1	DPW 2			12	6		6003605.147696201	2114190.7261663	37.785368381567004	-122.431272227533	(37.785368381567, -122.431272227533)
94348	94348	23879	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1500X Webster St	2	Median : Cutout 11	Tree 1	DPW 2			20	4		6003644.6262703	2113904.6308207	37.7845850728987	-122.43111521625299	(37.7845850728987, -122.431115216253)
139971	139971	23878	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1500X Webster St	1	Median : Cutout 11	Tree 1	DPW 2			25	4		6003644.6262703	2113904.6308207	37.7845850728987	-122.43111521625299	(37.7845850728987, -122.431115216253)
7438	7438	23859	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1400X Webster St	4	Median : Cutout 11	Tree 1	DPW 2			25	3X3		6003649.3852	2113669.4444	37.783939579713504	-122.431081960003	(37.7839395797135, -122.431081960003)
6075	6075	23828	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1200X Webster St	7	Median : Cutout 11	Tree 1	DPW 2			20	20		6003742.203	2113074.035	37.78230999365589	-122.430718341656	(37.7823099936559, -122.430718341656)
5117	5117	23827	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1200X Webster St	6	Median : Cutout 11	Tree 1	DPW 2			20	20		6003747.0158	2113043.0957	37.7822253147353	-122.430699482992	(37.7822253147353, -122.430699482992)
7386	7386	23826	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1200X Webster St	5	Median : Cutout 11	Tree 1	DPW 2			20	20		6003751.8286	2113008.0312	37.78212930904171	-122.43068032991002	(37.7821293090417, -122.43068032991)
3859	3859	23825	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1200X Webster St	4	Median : Cutout 11	Tree 1	DPW 2			30	20		6003756.6414	2112968.1539	37.782020088596504	-122.43066083333599	(37.7820200885965, -122.430660833336)
8699	8699	23824	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1200X Webster St	3	Median : Cutout 11	Tree 1	DPW 2			20	20		6003763.5168	2112936.527	37.78193363853529	-122.430634790088	(37.7819336385353, -122.430634790088)
6800	6800	23823	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1200X Webster St	2	Median : Cutout 11	Tree 1	DPW 2			20	20		6003765.5794	2112902.15	37.781839364726	-122.430625200646	(37.781839364726, -122.430625200646)
5279	5279	23791	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100X Webster St	6	Median : Cutout 11	Tree 1	DPW 2			3	20		6003783.4554	2112735.7654	37.7813835268154	-122.430551482109	(37.7813835268154, -122.430551482109)
2139	2139	23790	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100X Webster St	5	Median : Cutout 11	Tree 1	DPW 2			20	20		6003786.8931	2112715.8268	37.7813289751352	-122.43053816621901	(37.7813289751352, -122.430538166219)
223	223	23789	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100X Webster St	4	Median : Cutout 11	Tree 1	DPW 2			20	20		6003791.7059	2112684.1999	37.7812424081927	-122.43051925893299	(37.7812424081927, -122.430519258933)
7642	7642	23788	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100X Webster St	3	Median : Cutout 11	Tree 1	DPW 2			20	20		6003799.2688	2112646.3852	37.7811390068769	-122.43049039607	(37.7811390068769, -122.43049039607)
1722	1722	23787	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100X Webster St	2	Median : Cutout 11	Tree 1	DPW 2		04/21/2008 12:00:00 AM	3	20		6003801.3315	2112607.883	37.781033406276705	-122.430480512141	(37.7810334062767, -122.430480512141)
150090	150090	140685	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000x WEBSTER ST	1	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6003852.8969	2112257.5815	37.7800744864318	-122.43027712243799	(37.7800744864318, -122.430277122438)
6949	6949	23761	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	900X Webster St	7	Median : Cutout 11	Tree 1	DPW 2			25	20		6003883.1487	2112042.3815	37.7794853141392	-122.430157111124	(37.7794853141392, -122.430157111124)
8513	8513	23760	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	900X Webster St	6	Median : Cutout 11	Tree 1	DPW 2			25	20		6003885.2113	2112011.4423	37.7794004795956	-122.430147767922	(37.7794004795956, -122.430147767922)
8475	8475	23759	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	900X Webster St	5	Median : Cutout 11	Tree 1	DPW 2			25	20		6003889.3366	2111985.3157	37.7793289760816	-122.430131632423	(37.7793289760816, -122.430131632423)
2284	2284	23758	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	900X Webster St	4	Median : Cutout 11	Tree 1	DPW 2			25	20		6003894.1493	2111953.6889	37.7792424093118	-122.43011272647199	(37.7792424093118, -122.430112726472)
1958	1958	23757	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	900X Webster St	3	Median : Cutout 11	Tree 1	DPW 2			25	20		6003900.3372	2111922.0621	37.7791559204238	-122.43008906318701	(37.7791559204238, -122.430089063187)
168874	168874	140496	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	900x WEBSTER ST	2	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		6003908.5877	2111892.4979	37.779075211733996	-122.430058411766	(37.779075211734, -122.430058411766)
7325	7325	23732	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800X Webster St	7	Median : Cutout 11	Tree 1	DPW 2			12	20		6003928.5263	2111708.2372	37.7785704067109	-122.429976288631	(37.7785704067109, -122.429976288631)
6262	6262	23731	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800X Webster St	6	Median : Cutout 11	Tree 1	DPW 2			6	20		6003929.9014	2111682.7982	37.7785006353915	-122.429969716521	(37.7785006353915, -122.429969716521)
41327	41327	140552	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800x WEBSTER ST	5	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6003932.6516	2111661.4845	37.7784422689986	-122.429958681781	(37.7784422689986, -122.429958681781)
125018	125018	23756	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	900X Webster St	2	Median : Cutout 11	Tree 1	DPW 2			25	20		6003937.3073429	2111811.4900601003	37.7788544107823	-122.42995327885001	(37.7788544107823, -122.42995327885)
890	890	23729	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800X Webster St	4	Median : Cutout 11	Tree 1	DPW 2		04/21/2008 12:00:00 AM	3	6		6003943.6522	2111620.2321	37.7783296231018	-122.42991768322901	(37.7783296231018, -122.429917683229)
70273	70273	140551	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800x WEBSTER ST	3	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		6003947.0899	2111598.2308	37.778269407656495	-122.42990422118	(37.7782694076565, -122.42990422118)
6398	6398	23727	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	800X Webster St	2	Median : Cutout 11	Tree 1	DPW 2		04/21/2008 12:00:00 AM	3	6		6003949.8401	2111575.542	37.7782072655707	-122.429893088415	(37.7782072655707, -122.429893088415)
2297	2297	23709	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	700X Webster St	4	Median : Cutout 11	Tree 1	DPW 2			16	20		6003970.4427	2111382.6873	37.7776789009548	-122.429808057223	(37.7776789009548, -122.429808057223)
8325	8325	23708	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	700X Webster St	3	Median : Cutout 11	Tree 1	DPW 2			20			6003978.3577	2111349.4443	37.77758807209621	-122.429778304865	(37.7775880720962, -122.429778304865)
179520	179520	140602	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	700x WEBSTER ST	2	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		6003984.6897	2111298.7883	37.7774493417916	-122.429752786414	(37.7774493417916, -122.429752786414)
122592	122592	12943	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	725X Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			90			6005046.7981655	2104134.69405	37.7578385432445	-122.425568603003	(37.7578385432445, -122.425568603003)

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