Street_Tree_List

Data source: data.sfgov.org

6,837 rows where qSpecies = 37 sorted by SiteOrder 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

- 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: qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
134524	134524	180080	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	54	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000250.536280001	2090007.01678	37.7187750968802	-122.441142448362	(37.7187750968802, -122.441142448362)
43625	43625	180079	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	53	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000270.676519999	2090025.31664	37.71882649133779	-122.44107414397699	(37.7188264913378, -122.441074143977)
159126	159126	180078	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	51	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000292.29675	2090045.26571	37.7188824984081	-122.44100084202101	(37.7188824984081, -122.441000842021)
92247	92247	10776	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1120X Hudson Ave	50	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2		10/26/2011 12:00:00 AM	3	3x4		6017909.652863	2094654.0666341	37.73252506519629	-122.380424102302	(37.7325250651963, -122.380424102302)
51011	51011	180077	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	49	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000313.69602	2090066.17904	37.718941140487104	-122.44092837286199	(37.7189411404871, -122.440928372862)
166549	166549	180076	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	48	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000336.55563	2090087.7823400002	37.7190017601923	-122.440850905243	(37.7190017601923, -122.440850905243)
55694	55694	180075	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	47	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000353.03268	2090103.7584400002	37.7190465653394	-122.44079509604401	(37.7190465653394, -122.440795096044)
64280	64280	180074	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	46	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000367.52322	2090116.8961	37.719083463616	-122.44074594986401	(37.719083463616, -122.440745949864)
113326	113326	10773	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1120X Hudson Ave	46	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/06/2014 12:00:00 AM	3	3x4		6017909.652863	2094654.0666341	37.73252506519629	-122.380424102302	(37.7325250651963, -122.380424102302)
134500	134500	180073	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	45	Median : Cutout 11	Tree 1	DPW 2			4	Width 2ft		6000381.06487	2090130.7736900002	37.719122339514605	-122.44070013662201	(37.7191223395146, -122.440700136622)
181268	181268	180072	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	44	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000400.98899	2090150.2778599998	37.719177028168296	-122.440632664989	(37.7191770281683, -122.440632664989)
33919	33919	180071	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	43	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000421.866669999	2090169.28245	37.719230399348795	-122.440561861357	(37.7192303993488, -122.440561861357)
177174	177174	180070	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	41	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000442.5181599995	2090189.01132	37.7192857463155	-122.440491891393	(37.7192857463155, -122.440491891393)
49881	49881	180069	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	39	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000467.5949099995	2090212.96823	37.719352954453605	-122.440406927962	(37.7193529544536, -122.440406927962)
177704	177704	180068	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	38	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000492.17507	2090236.21555	37.71941818588179	-122.440323630039	(37.7194181858818, -122.440323630039)
158230	158230	180067	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	37	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000510.614080001	2090253.83095	37.7194676036275	-122.440261155949	(37.7194676036275, -122.440261155949)
185396	185396	180066	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	36	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000525.601009999	2090267.6783099999	37.7195064786158	-122.440210344258	(37.7195064786158, -122.440210344258)
9380	9380	12155	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	1400X La Salle Ave	35	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2006 12:00:00 AM	3	3X3		6016212.874009999	2095683.59001	37.7352581567374	-122.38636208157301	(37.7352581567374, -122.386362081573)
164187	164187	180357	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	35	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999341.076309999	2091752.71105	37.7235165268451	-122.444411466031	(37.7235165268451, -122.444411466031)
132991	132991	198232	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1195 La Salle Ave	34	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017137.151430001	2094557.735	37.7322179011369	-122.383088149026	(37.7322179011369, -122.383088149026)
149228	149228	180065	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	34	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000553.61296	2090293.7338400001	37.7195796159879	-122.440115384832	(37.7195796159879, -122.440115384832)
169933	169933	180356	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	34	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999377.8425199995	2091805.58177	37.723663795345296	-122.444288169859	(37.7236637953453, -122.444288169859)
68749	68749	185181	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	2500 Sunset Blvd	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 0ft		5985173.8643	2097833.419	37.739394027632606	-122.493832155461	(37.7393940276326, -122.493832155461)
171350	171350	180355	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	33	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5999392.39561	2091826.25637	37.7237213933189	-122.44423934748501	(37.7237213933189, -122.444239347485)
46125	46125	198231	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1195 La Salle Ave	32	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017152.36813	2094550.1406599998	37.732197889407395	-122.38303501258001	(37.7321978894074, -122.38303501258)
65498	65498	180064	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	32	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000583.15456	2090323.8373900002	37.7196639553094	-122.44001542788601	(37.7196639553094, -122.440015427886)
153426	153426	180354	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	32	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999408.912140001	2091849.27395	37.723785536569295	-122.44418390605699	(37.7237855365693, -122.444183906057)
176679	176679	180039	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	32	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6001024.8340300005	2091089.76883	37.7217921640611	-122.43854355335199	(37.7217921640611, -122.438543553352)
14023	14023	12151	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	1400X La Salle Ave	31	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/03/2000 12:00:00 AM	6	3X3		6016216.53352	2095682.69567	37.735255903626104	-122.386349366854	(37.7352559036261, -122.386349366854)
46043	46043	180353	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	31	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999435.7952	2091887.33185	37.723891568433	-122.44409370946899	(37.723891568433, -122.444093709469)
160948	160948	185179	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	2500 Sunset Blvd	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5985165.2317	2097818.1461	37.7393515872788	-122.49386087752701	(37.7393515872788, -122.493860877527)
187581	187581	180063	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	31	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000614.24594	2090358.9478799999	37.7197621306905	-122.439910472497	(37.7197621306905, -122.439910472497)
45088	45088	198230	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1195 La Salle Ave	30	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017163.23576	2094544.6383099998	37.7321833815383	-122.38299705756201	(37.7321833815383, -122.382997057562)
112713	112713	12048	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1250X La Salle Ave	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/2006 12:00:00 AM	3	3X3		6017218.4556902	2094518.6413490002	37.7321150500381	-122.38280433953301	(37.7321150500381, -122.382804339533)
131878	131878	180038	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	30	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6001039.13004	2091116.8282599999	37.7218672763459	-122.438496073645	(37.7218672763459, -122.438496073645)
169011	169011	180352	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	30	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5999449.4457	2091910.6474400002	37.723956366384	-122.44404819656799	(37.723956366384, -122.444048196568)
28953	28953	180351	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	29	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999465.90272	2091930.8056400002	37.724012654949206	-122.443992755163	(37.7240126549492, -122.443992755163)
29276	29276	180062	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	29	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000649.61116	2090402.60873	37.7198840266041	-122.439791356397	(37.7198840266041, -122.439791356397)
47302	47302	185177	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	2500 Sunset Blvd	29	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 0ft		5985174.5283	2097805.5293	37.7393174888485	-122.49382780495	(37.7393174888485, -122.49382780495)
184447	184447	180037	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	29	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6001052.1769900005	2091141.7538400001	37.7219364584926	-122.438452758712	(37.7219364584926, -122.438452758712)
15788	15788	12148	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	1400X La Salle Ave	28	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6016263.135559999	2095630.9008799999	37.735116265005296	-122.38618463531701	(37.7351162650053, -122.386184635317)
42646	42646	180350	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	28	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5999481.21796	2091953.60977	37.724076143470796	-122.44394145063801	(37.7240761434708, -122.443941450638)
43357	43357	180061	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	28	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000666.70399	2090425.0511	37.7199466212073	-122.43973388071001	(37.7199466212073, -122.43973388071)
23262	23262	12147	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1400X La Salle Ave	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/1992 12:00:00 AM	2	3X3		6016278.18677	2095613.26708	37.7350686791819	-122.38613136847499	(37.7350686791819, -122.386131368475)
59485	59485	180349	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	27	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999494.33024	2091974.07592	37.7241330867549	-122.44389759340099	(37.7241330867549, -122.443897593401)
59645	59645	121791	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1501x Illinois St	27	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6016249.369659999	2101966.17171	37.752510857603504	-122.38667386380699	(37.7525108576035, -122.386673863807)
62404	62404	180036	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	27	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6001074.7596	2091184.9588099997	37.7220563740814	-122.43837779032101	(37.7220563740814, -122.438377790321)
117964	117964	26533	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1200X La Salle Ave	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/2006 12:00:00 AM	3	3X3		6017464.4799176	2094331.6246005	37.731615128467496	-122.381940767084	(37.7316151284675, -122.381940767084)
183918	183918	180060	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	27	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000687.072369999	2090454.3849400003	37.7200283246365	-122.439665576299	(37.7200283246365, -122.439665576299)
16569	16569	12146	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1400X La Salle Ave	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/03/2016 08:19:00 AM	3	3X3		6016292.37085	2095595.08218	37.735019532132505	-122.386081061301	(37.7350195321325, -122.386081061301)
33036	33036	180348	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999510.53335	2091993.5241	37.7241874112135	-122.443842978489	(37.7241874112135, -122.443842978489)
34075	34075	198202	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1196 La Salle Ave	26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017386.73333	2094343.85008	37.731644403447106	-122.38221040528	(37.7316444034471, -122.38221040528)
57797	57797	121790	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1501x Illinois St	26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6016249.74624	2101942.17011	37.7524449750798	-122.386670887967	(37.7524449750798, -122.386670887967)
101882	101882	88685	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	601 25th St	26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2008 12:00:00 AM		3x3	Permit Number 51637	6016776.9	2102119.9	37.7529621548081	-122.384860265748	(37.7529621548081, -122.384860265748)
176650	176650	180059	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	26	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000706.97869	2090484.68802	37.7201126630403	-122.439598938365	(37.7201126630403, -122.439598938365)
185409	185409	180035	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	26	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6001087.26718	2091207.92549	37.722120146807896	-122.43833619936399	(37.7221201468079, -122.438336199364)
30468	30468	180034	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	25	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6001097.83369	2091228.63345	37.7221776071819	-122.43830115639601	(37.7221776071819, -122.438301156396)
33314	33314	180058	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	25	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6000718.4568	2090503.6472599998	37.7201653741024	-122.43956062093599	(37.7201653741024, -122.439560620936)
50436	50436	198220	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1189 La Salle Ave	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017527.033969999	2094259.97838	37.7314218563182	-122.38171952203501	(37.7314218563182, -122.381719522035)
90977	90977	36211	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	1455 Yosemite Ave	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/05/1998 12:00:00 AM			Permit Number 39262	6015374.49012429	2092056.56629028	37.7252526334632	-122.389007552668	(37.7252526334632, -122.389007552668)
101128	101128	88684	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	601 25th St	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2008 12:00:00 AM		3x3	Permit Number 51637	6016776.9	2102119.9	37.7529621548081	-122.384860265748	(37.7529621548081, -122.384860265748)
111656	111656	11998	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1200X La Salle Ave	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/2006 12:00:00 AM	3	3X3		6017464.4799176	2094331.6246005	37.731615128467496	-122.381940767084	(37.7316151284675, -122.381940767084)
163800	163800	121789	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1501x Illinois St	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6016253.07311	2101915.10952	37.7523708565434	-122.38665749616301	(37.7523708565434, -122.386657496163)
169679	169679	180347	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5999525.409630001	2092018.2442599998	37.7242561356068	-122.44379332872101	(37.7242561356068, -122.443793328721)
184132	184132	198229	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1195 La Salle Ave	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017254.927490001	2094491.22957	37.732041797678704	-122.38267634045401	(37.7320417976787, -122.382676340454)
39693	39693	198201	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1196 La Salle Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017349.13992	2094376.34522	37.731731552271796	-122.38234263442101	(37.7317315522718, -122.382342634421)
46615	46615	180033	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	24	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6001110.15786	2091253.57403	37.722246789330896	-122.43826034064699	(37.7222467893309, -122.438260340647)
47519	47519	121788	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1501x Illinois St	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6016251.70345	2101889.85791	37.75230144507611	-122.386660472017	(37.7523014450761, -122.386660472017)
51994	51994	180057	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	24	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000730.46127	2090524.7556599998	37.7202240162157	-122.439520637988	(37.7202240162157, -122.439520637988)
62432	62432	218769	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5999558.6619	2092063.3212599999	37.7243818032662	-122.443681617625	(37.7243818032662, -122.443681617625)
64074	64074	198219	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1189 La Salle Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017539.02456	2094243.4713299999	37.73137719328629	-122.381676920275	(37.7313771932863, -122.381676920275)
79293	79293	36208	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	1455 Yosemite Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/05/1998 12:00:00 AM			Permit Number 39262	6015374.49012429	2092056.56629028	37.7252526334632	-122.389007552668	(37.7252526334632, -122.389007552668)
117263	117263	11997	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1200X La Salle Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/10/2007 12:00:00 AM	3	3X3		6017464.4799176	2094331.6246005	37.731615128467496	-122.381940767084	(37.7316151284675, -122.381940767084)
141518	141518	88683	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	601 25th St	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2008 12:00:00 AM		3x3	Permit Number 51637	6016776.9	2102119.9	37.7529621548081	-122.384860265748	(37.7529621548081, -122.384860265748)
14039	14039	12143	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1400X La Salle Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/02/2015 10:50:00 AM	3	3X3		6016355.37955	2095493.80594	37.734744934934895	-122.385856158845	(37.7347449349349, -122.385856158845)
18717	18717	12041	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1250X La Salle Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/2006 12:00:00 AM	3	3X3		6017218.4556902	2094518.6413490002	37.7321150500381	-122.38280433953301	(37.7321150500381, -122.382804339533)
36438	36438	198228	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1195 La Salle Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017291.3126300005	2094471.7306099997	37.731990267431605	-122.382549191609	(37.7319902674316, -122.382549191609)
37415	37415	198218	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1189 La Salle Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6017554.24593	2094216.62614	37.7313043221245	-122.38162243033999	(37.7313043221245, -122.38162243034)
45858	45858	121787	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1501x Illinois St	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6016254.17853	2101863.2429	37.7522285028495	-122.38665005696699	(37.7522285028495, -122.386650056967)
56209	56209	180346	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999574.72961	2092087.77825	37.7244498729372	-122.443627830084	(37.7244498729372, -122.443627830084)
57669	57669	180056	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1900x Alemany Blvd	23	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		6000745.033480001	2090553.4894299998	37.7203037419912	-122.439472325501	(37.7203037419912, -122.439472325501)
87278	87278	36215	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	1455 Yosemite Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/05/1998 12:00:00 AM			Permit Number 39262	6015374.49012429	2092056.56629028	37.7252526334632	-122.389007552668	(37.7252526334632, -122.389007552668)
87367	87367	88682	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	601 25th St	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2008 12:00:00 AM		3x3	Permit Number 51637	6016776.9	2102119.9	37.7529621548081	-122.384860265748	(37.7529621548081, -122.384860265748)
94343	94343	11996	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1200X La Salle Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/2006 12:00:00 AM	3	3X3		6017464.4799176	2094331.6246005	37.731615128467496	-122.381940767084	(37.7316151284675, -122.381940767084)
113718	113718	10816	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1139X Hudson Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/26/2016 12:00:00 AM	3	3X4		6017660.0560099995	2094705.99201	37.7326538662851	-122.381290636609	(37.7326538662851, -122.381290636609)
170774	170774	180032	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	23	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6001123.43555	2091278.0147099998	37.722314653084396	-122.438216192941	(37.7223146530844, -122.438216192941)
179780	179780	180159	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	23	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 2ft		6002542.18491	2090728.5143	37.7208864370415	-122.43327267002199	(37.7208864370415, -122.433272670022)
29679	29679	121786	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1501x Illinois St	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6016255.4069300005	2101838.7957200003	37.752161444010795	-122.38664410433998	(37.7521614440108, -122.38664410434)
46925	46925	180031	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	22	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6001136.72316	2091302.93534	37.7223838352188	-122.438172045228	(37.7223838352188, -122.438172045228)
56812	56812	180158	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		6002520.13209	2090692.25327	37.7207856212475	-122.433346310091	(37.7207856212475, -122.433346310091)
65830	65830	198227	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1195 La Salle Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 3ft		6017315.6556400005	2094453.93145	37.7319427391711	-122.38246379378401	(37.7319427391711, -122.382463793784)
77166	77166	77218	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	499X Hearst Ave	22	Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	DPW for City Agency 2	05/15/1999 12:00:00 AM	3	6x50		5998132.77434913	2094246.31790382	37.730294369809705	-122.44876785322901	(37.7302943698097, -122.448767853229)
111470	111470	36207	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	1455 Yosemite Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/05/1998 12:00:00 AM			Permit Number 39262	6015374.49012429	2092056.56629028	37.7252526334632	-122.389007552668	(37.7252526334632, -122.389007552668)
112380	112380	12040	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1250X La Salle Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/05/2011 12:00:00 AM	0	3x3		6017218.4556902	2094518.6413490002	37.7321150500381	-122.38280433953301	(37.7321150500381, -122.382804339533)
116237	116237	88681	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	601 25th St	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/05/2008 12:00:00 AM		3x3	Permit Number 51637	6016776.9	2102119.9	37.7529621548081	-122.384860265748	(37.7529621548081, -122.384860265748)
138238	138238	30544	Permitted Site 1	Tristaniopsis laurina :: Swamp Myrtle 37	401 Tunnel Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/25/1995 12:00:00 AM	10		Permit Number 34540	6011720.93771	2086611.92604	37.7100995538248	-122.401255168406	(37.7100995538248, -122.401255168406)
152702	152702	180345	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1900 San Jose Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999591.211180001	2092109.1279	37.72450943414721	-122.44357238867599	(37.7245094341472, -122.443572388676)
42531	42531	180157	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	579 Madrid St	21	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 2ft		6002506.03817	2090671.0585599998	37.720726625705105	-122.433393514622	(37.7207266257051, -122.433393514622)
51587	51587	121785	Undocumented 2	Tristaniopsis laurina :: Swamp Myrtle 37	1501x Illinois St	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3x3		6016256.95276	2101808.77188	37.7520790904017	-122.38663666516099	(37.7520790904017, -122.386636665161)
52126	52126	180030	DPW Maintained 3	Tristaniopsis laurina :: Swamp Myrtle 37	1800x Alemany Blvd	21	Median : Cutout 11	Tree 1	DPW 2			3	Width 2ft		6001150.53734	2091330.00448	37.72245894660539	-122.438126231036	(37.7224589466054, -122.438126231036)

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