Street_Tree_List

Data source: data.sfgov.org

184 rows where qCaretaker = 2 and qSpecies = 62 sorted by rowid descending

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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
141952	141952	26685	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	610X Columbus Ave	6	Median : Cutout 11	Tree 1	DPW 2		01/27/1999 12:00:00 AM	20	3		6009783.7006387	2119558.1544154	37.800454241984404	-122.41027530758998	(37.8004542419844, -122.41027530759)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
104820	104820	2417	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	2818 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6009805.0388946	2100942.8610594	37.7493421915499	-122.408887356555	(37.7493421915499, -122.408887356555)
103617	103617	15137	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	780X Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6011914.84635	2114325.58433	37.7862060830296	-122.40253249015801	(37.7862060830296, -122.402532490158)
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)
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)
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)
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)
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)
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)
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)
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)
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)
85181	85181	4670	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	610X Columbus Ave	5	Median : Cutout 11	Tree 1	DPW 2		02/13/2003 12:00:00 AM	12	3		6009783.7006387	2119558.1544154	37.800454241984404	-122.41027530758998	(37.8004542419844, -122.41027530759)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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