Street_Tree_List

Data source: data.sfgov.org

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

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
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)
26865	26865	200267	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	860x Jamestown Ave	4	Median : Cutout 11	Tree 1	DPW 2			1	Width 5ft		6014763.4294300005	2089103.4873400002	37.7171101711671	-122.39091365107001	(37.7171101711671, -122.39091365107)
34340	34340	200271	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	920x Jamestown Ave	2	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014518.22002	2089293.0618599998	37.7176170965211	-122.391774477626	(37.7176170965211, -122.391774477626)
39056	39056	200272	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	920x Jamestown Ave	3	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014501.14248	2089299.14768	37.7176328589541	-122.39183393271401	(37.7176328589541, -122.391833932714)
49142	49142	200274	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	920x Jamestown Ave	11	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014408.1626699995	2089360.68754	37.7177966731557	-122.392159625791	(37.7177966731557, -122.392159625791)
50356	50356	200269	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	860x Jamestown Ave	11	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014632.09061	2089229.7896900002	37.7174496841459	-122.39137645477501	(37.7174496841459, -122.391376454775)
51688	51688	200270	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	860x Jamestown Ave	12	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014621.84489	2089234.87823	37.717463087626705	-122.39141222532	(37.7174630876267, -122.39141222532)
63521	63521	200266	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	860x Jamestown Ave	3	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014773.14657	2089094.60205	37.7170863130726	-122.39087944264999	(37.7170863130726, -122.39087944265)
73104	73104	200264	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	828x Jamestown Ave	6	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014856.837309999	2088987.16565	37.716795957049996	-122.390582658263	(37.71679595705, -122.390582658263)
134358	134358	200263	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	828x Jamestown Ave	2	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014881.06262	2088948.3619	37.7166907534629	-122.39049621274799	(37.7166907534629, -122.390496212748)
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)
151014	151014	200268	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	860x Jamestown Ave	10	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014637.958740001	2089223.7051900001	37.7174333029868	-122.39135574608801	(37.7174333029868, -122.391355746088)
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)
157992	157992	200265	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	860x Jamestown Ave	2	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		6014784.79531	2089078.0954900002	37.7170416356268	-122.390838025257	(37.7170416356268, -122.390838025257)
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)
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)
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)
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)
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)
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
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)
18937	18937	2410	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2753 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/04/2003 12:00:00 AM	3	3x3		6009844.62689	2101286.4895200003	37.7502879367387	-122.40877469949	(37.7502879367387, -122.40877469949)
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)
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)
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)
20543	20543	2353	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2413 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/03/2013 12:00:00 AM	3	4X4		6009731.35926	2103287.7886799998	37.7557767132463	-122.409307601761	(37.7557767132463, -122.409307601761)
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)
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)
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)
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)
82870	82870	4675	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	700X Columbus Ave	2	Median : Cutout 11	Tree 1	DPW 2		04/06/2013 12:00:00 AM	3	3x3		6009477.5527626	2119836.3917306997	37.8012010470299	-122.41135437342	(37.8012010470299, -122.41135437342)
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)
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)
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)
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)
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)
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)
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)
123013	123013	10137	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	900 Guerrero St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	4x4		6005656.6056289	2103722.2710656	37.7567405635363	-122.423430312617	(37.7567405635363, -122.423430312617)
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)
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)
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)
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)
164766	164766	200273	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	920x Jamestown Ave	10	Median : Cutout 11	Tree 1	DPW 2			3	Width 5ft		6014418.93045	2089354.50359	37.7177802911084	-122.392121973844	(37.7177802911084, -122.392121973844)
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)
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)
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)
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)
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)
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)
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)
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)
5646	5646	4679	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	700X Columbus Ave	6	Median : Cutout 11	Tree 1	DPW 2		08/19/2006 12:00:00 AM	6	3x3		6009212.7257	2120043.2180000003	37.801754083871295	-122.412285420728	(37.8017540838713, -122.412285420728)
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)
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)
6383	6383	4717	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	4	Median : Cutout 11	Tree 1	DPW 2		08/19/2006 12:00:00 AM	6	3		6008242.0329	2120925.0825	37.804120945419	-122.415706953629	(37.804120945419, -122.415706953629)
8454	8454	4715	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	2	Median : Cutout 11	Tree 1	DPW 2		08/19/2006 12:00:00 AM	6	3		6008330.3273	2120843.4941	37.803901887177204	-122.415395624015	(37.8039018871772, -122.415395624015)
10217	10217	2412	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2770 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/18/1996 12:00:00 AM	6	3X3		6009783.25197	2101219.12721	37.7500995368852	-122.40898218658998	(37.7500995368852, -122.40898218659)
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
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)
21060	21060	2380	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2566 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3x3		6009717.08187	2102390.53262	37.7533122488659	-122.409293662278	(37.7533122488659, -122.409293662278)
22378	22378	26756	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1399 Post St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6005569.26951	2114444.1495	37.7861753317646	-122.424494982868	(37.7861753317646, -122.424494982868)
22416	22416	26753	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1399 Post St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6005527.1532	2114438.07435	37.7861562724304	-122.424640262031	(37.7861562724304, -122.424640262031)
22571	22571	26752	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1399 Post St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6005515.49515	2114435.63395	37.7861489132884	-122.424680422175	(37.7861489132884, -122.424680422175)
22634	22634	26754	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1399 Post St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6005539.86656	2114440.61457	37.7861639652384	-122.424596457885	(37.7861639652384, -122.424596457885)
22794	22794	26757	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1399 Post St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6005593.49204	2114448.7926	37.786189448429205	-122.42441150958099	(37.7861894484292, -122.424411509581)
22804	22804	26755	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1399 Post St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6005555.38127	2114442.5721400003	37.7861702164197	-122.424542920326	(37.7861702164197, -122.424542920326)
82308	82308	26759	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1399 Post St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6005482.1110222	2114431.1702313	37.786134771520096	-122.42479560486	(37.7861347715201, -122.42479560486)
82790	82790	28267	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	20X Peter Yorke Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6005597.7326569	2114202.21171	37.785512637883	-122.42437929334999	(37.785512637883, -122.42437929335)
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)
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)
140171	140171	26758	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1399 Post St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6005482.1110222	2114431.1702313	37.786134771520096	-122.42479560486	(37.7861347715201, -122.42479560486)
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)
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)
1597	1597	4669	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	600X Columbus Ave	4	Median : Cutout 11	Tree 1	DPW 2		06/25/2014 12:00:00 AM	8	3	Permit Number 769286	6009537.0943	2119751.1708	37.8009703907309	-122.411142309711	(37.8009703907309, -122.411142309711)
3829	3829	4634	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	500X Columbus Ave	1	Median : Cutout 11	Tree 1	DPW 2		08/19/2006 12:00:00 AM	8	3		6010031.5482	2119295.5915	37.799747198685004	-122.40939911161502	(37.799747198685, -122.409399111615)
7156	7156	13002	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	359 Lombard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/23/1995 12:00:00 AM	8	3X3		6010611.1408	2120633.1017	37.8034521300977	-122.40748784681101	(37.8034521300977, -122.407487846811)
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)
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)
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)
45194	45194	142722	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100x COLUMBUS AVE	2	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		6008044.6283	2121108.5348	37.804613560274504	-122.416403090609	(37.8046135602745, -122.416403090609)
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)
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)
6589	6589	4667	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	600X Columbus Ave	2	Median : Cutout 11	Tree 1	DPW 2		10/03/2012 12:00:00 AM	12	3	Permit Number 769286	6009690.8519	2119608.7257	37.80058789320879	-122.410600176031	(37.8005878932088, -122.410600176031)
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)
17519	17519	2314	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2253 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6009680.74998	2104241.2199	37.7583917852794	-122.409549914219	(37.7583917852794, -122.409549914219)
18776	18776	2310	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2227 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6009672.2386	2104377.81978	37.758766380788	-122.409588991562	(37.758766380788, -122.409588991562)
20799	20799	2336	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2350 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x4		6009647.84885	2103642.0545799998	37.7567447686625	-122.40962141212201	(37.7567447686625, -122.409621412122)
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)
21126	21126	2414	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2786 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6009786.496590001	2101143.3199400003	37.749891568653496	-122.408965618395	(37.7498915686535, -122.408965618395)
21155	21155	2419	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2822 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6009803.315230001	2100866.84766	37.7491333789981	-122.408887954717	(37.7491333789981, -122.408887954717)

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