Street_Tree_List

Data source: data.sfgov.org

181 rows where qLegalStatus = 3 and qSpecies = 62 sorted by qAddress

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, PlantDate, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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
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
1529	1529	251578	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	6	Median : Cutout 11	Tree 1	DPW 2
1851	1851	4718	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	5	Median : Cutout 11	Tree 1	DPW 2			80	3		6008205.1504	2120957.4944	37.804207866952204	-122.415836885075	(37.8042078669522, -122.415836885075)
5299	5299	4716	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	3	Median : Cutout 11	Tree 1	DPW 2			70	3		6008306.8566	2120868.0824	37.803968081269204	-122.415478587922	(37.8039680812692, -122.415478587922)
6099	6099	4714	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	1	Median : Cutout 11	Tree 1	DPW 2			80	3		6008373.9156	2120808.2881	37.8038076701269	-122.415242289828	(37.8038076701269, -122.415242289828)
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)
124851	124851	4719	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	6	Median : Cutout 11	Tree 1	DPW 2			70	3		6008486.129587	2120728.7244	37.803595514004	-122.41484833114401	(37.803595514004, -122.414848331144)
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)
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)
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)
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)
7054	7054	4734	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100X Columbus Ave	5	Median : Cutout 11	Tree 1	DPW 2			60	3x3		6007950.0877	2121194.0464	37.80484303663339	-122.416736319981	(37.8048430366334, -122.416736319981)
8565	8565	4733	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100X Columbus Ave	4	Median : Cutout 11	Tree 1	DPW 2			20	3x3		6007980.3619	2121165.8966	37.80476744709579	-122.416629557244	(37.8047674470958, -122.416629557244)
8587	8587	4732	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100X Columbus Ave	3	Median : Cutout 11	Tree 1	DPW 2			14	3x3		6008014.3541	2121137.2157	37.8046906082857	-122.41650989053801	(37.8046906082857, -122.416509890538)
87462	87462	4736	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100X Columbus Ave	7	Median : Cutout 11	Tree 1	DPW 2			60	3x3		6008154.5819477	2121037.0963081	37.804423590750396	-122.41601752221001	(37.8044235907504, -122.41601752221)
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)
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)
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)
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)
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)
36379	36379	142721	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1100x COLUMBUS AVE	1	Median : Cutout 11	Tree 1	DPW 2			17	Width 0ft		6008079.1516	2121077.7294	37.804530917755706	-122.416281435895	(37.8045309177557, -122.416281435895)
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)
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)
1594	1594	4731	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1175X Columbus Ave	2	Median : Cutout 11	Tree 1	DPW 2			14	3x3		6007886.219880001	2121257.05551	37.8050124513131	-122.416961809043	(37.8050124513131, -122.416961809043)
7655	7655	4730	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1175X Columbus Ave	1	Median : Cutout 11	Tree 1	DPW 2			100	3x3		6007911.57425	2121225.41132	37.8049269905411	-122.41687182377	(37.8049269905411, -122.41687182377)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
82063	82063	21900	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2065 03rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015783.090580001	2106025.2302	37.7636303426542	-122.388569659247	(37.7636303426542, -122.388569659247)
114646	114646	21898	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2065 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6015783.090580001	2106025.2302	37.7636303426542	-122.388569659247	(37.7636303426542, -122.388569659247)
139049	139049	21899	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2065 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015783.090580001	2106025.2302	37.7636303426542	-122.388569659247	(37.7636303426542, -122.388569659247)
82286	82286	28268	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	20X Peter Yorke Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6005597.7326569	2114202.21171	37.785512637883	-122.42437929334999	(37.785512637883, -122.42437929335)
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)
117723	117723	28270	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	20X Peter Yorke Way	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6005597.7326569	2114202.21171	37.785512637883	-122.42437929334999	(37.785512637883, -122.42437929335)
142691	142691	28269	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	20X Peter Yorke Way	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6005597.7326569	2114202.21171	37.785512637883	-122.42437929334999	(37.785512637883, -122.42437929335)
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)
21487	21487	2309	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2213 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6009668.22468	2104416.43849	37.7588721941234	-122.409605599315	(37.7588721941234, -122.409605599315)
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)
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)
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)
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)
21137	21137	2330	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2312 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6009640.84961	2103785.73358	37.7571388866594	-122.409655759023	(37.7571388866594, -122.409655759023)
20167	20167	2332	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2318 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	6X6		6009643.236190001	2103731.69198	37.7569906343237	-122.409643691024	(37.7569906343237, -122.409643691024)
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)
112335	112335	2341	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2372 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6009654.94661	2103556.3659	37.756509884537	-122.409590817662	(37.756509884537, -122.409590817662)
17542	17542	2343	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2385 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			23	3X3		6009722.48016	2103476.08894	37.7562932460395	-122.40935159661501	(37.7562932460395, -122.409351596615)
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)
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)
21374	21374	2362	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2473 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6009749.23862	2102948.41566	37.7548458726476	-122.40922182173	(37.7548458726476, -122.40922182173)
19206	19206	2364	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2483 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6009753.556480001	2102901.70574	37.754717859559996	-122.40920359338499	(37.75471785956, -122.409203593385)
80959	80959	27484	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2509 Bryant St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6009754.968576999	2102712.0209772997	37.754197106715296	-122.40918532566099	(37.7541971067153, -122.409185325661)
119180	119180	2371	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2520 BRYANT ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6009678.5	2102633.3	37.753976672205894	-122.40944421875601	(37.7539766722059, -122.409444218756)
123006	123006	2373	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2530 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6009713.5161975	2102600.278568	37.7538879646488	-122.409320793751	(37.7538879646488, -122.409320793751)
17278	17278	2375	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2547 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6009774.35605	2102523.0562	37.753679337750604	-122.409104945855	(37.7536793377506, -122.409104945855)
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)

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