Street_Tree_List

Data source: data.sfgov.org

396 rows where qSpecies = 38 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

- 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, qSiteInfo, qCaretaker, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
103	103	117428	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/14/2016 12:00:00 AM	3		Permit Number 776915
122863	122863	50817	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/18/2004 12:00:00 AM			Permit Number 47340	5995605.94135709	2094497.43585496	37.7308390591092	-122.457521563876	(37.7308390591092, -122.457521563876)
40186	40186	218289	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1 Woodacre Dr	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28			5991265.0261699995	2095485.2551900002	37.7333010580894	-122.472600653515	(37.7333010580894, -122.472600653515)
53381	53381	217850	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1 Woodacre Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			5991375.86862	2095660.38148	37.7337883260711	-122.47223020566999	(37.7337883260711, -122.47223020567)
55201	55201	218280	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1 Woodacre Dr	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30			5991369.16642	2095649.3447099999	37.7337576340075	-122.47225257269301	(37.7337576340075, -122.472252572693)
136052	136052	218293	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1 Woodacre Dr	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22			5991192.67429	2095369.91493	37.7329801745819	-122.47284238406799	(37.7329801745819, -122.472842384068)
171868	171868	218294	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1 Woodacre Dr	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			5991183.55146	2095353.09261	37.7329334566034	-122.472872697534	(37.7329334566034, -122.472872697534)
95944	95944	116681	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	100 Esmeralda Ave	20	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
122500	122500	115975	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	100 SAN JOSE AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	3x3		6006168.0	2102576.0	37.7536220187283	-122.421580311855	(37.7536220187283, -122.421580311855)
24466	24466	207106	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	100 Tara St	2	: 4	Tree 1	Private 1			20	Width 0ft		5998100.60654	2090923.0946	37.7211677377768	-122.448639805789	(37.7211677377768, -122.448639805789)
37269	37269	227675	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	104	Front Yard : Yard 7	Tree 1	Private 1			27			6005040.407269999	2096975.5643799999	37.7381808604543	-122.425081325568	(37.7381808604543, -122.425081325568)
74734	74734	227671	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	60	Front Yard : Yard 7	Tree 1	Private 1			10			6005087.18528	2097058.7145599998	37.738411814457706	-122.42492550452101	(37.7384118144577, -122.424925504521)
148496	148496	227674	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	83	Front Yard : Yard 7	Tree 1	Private 1			15			6005065.1015800005	2097012.05309	37.7382824451638	-122.42499854026899	(37.7382824451638, -122.424998540269)
150938	150938	227672	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	62	Front Yard : Yard 7	Tree 1	Private 1			15			6005095.2123	2097053.48648	37.7383979127325	-122.42489737911801	(37.7383979127325, -122.424897379118)
178085	178085	227673	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	64	Front Yard : Yard 7	Tree 1	Private 1			12			6005078.09924	2097049.5351099998	37.738386096529204	-122.424956266738	(37.7383860965292, -122.424956266738)
101609	101609	43632	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1001 Portola Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/02/2008 12:00:00 AM		3x3	Permit Number 50556	5996213.47474732	2098545.79305022	37.7419897418411	-122.455713757113	(37.7419897418411, -122.455713757113)
32798	32798	227686	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1001 Shrader St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5997629.48637	2107046.8431599997	37.7654126728718	-122.45143067278299	(37.7654126728718, -122.451430672783)
77293	77293	227685	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1001 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		5997626.030809999	2107071.20572	37.765479368391	-122.45144438204599	(37.765479368391, -122.451444382046)
44170	44170	227687	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1003 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5997630.84664	2107024.34604	37.7653509793933	-122.45142434518401	(37.7653509793933, -122.451424345184)
95391	95391	113478	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	100x ESMERALDA AVE	5	Unaccepted Street : Yard 14	Tree 1	DPW 2			8			6006917.0	2098966.0	37.7437519821991	-122.418734104398	(37.7437519821991, -122.418734104398)
1699	1699	237552	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	102 Hancock St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/30/2017 12:00:00 AM	3	Width 3ft	Permit Number 779869	6003566.97457	2105097.88602	37.7603995118464	-122.430755182518	(37.7603995118464, -122.430755182518)
1709	1709	237551	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	102 Hancock St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/30/2017 12:00:00 AM	3	Width 3ft	Permit Number 779869	6003586.068	2105101.14828	37.760409550968205	-122.430689380017	(37.7604095509682, -122.430689380017)
43299	43299	129476	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1077 Front St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			6012591.305319999	2120127.94056	37.8021757161919	-122.4005998549	(37.8021757161919, -122.4005998549)
74619	74619	129475	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1077 Front St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			6012586.0999300005	2120128.51859	37.8021770130129	-122.40061790879999	(37.8021770130129, -122.4006179088)
152713	152713	129469	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1085 Vallejo St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6008359.28826	2118585.88506	37.7977046844857	-122.415135501808	(37.7977046844857, -122.415135501808)
26252	26252	227697	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	109 Fillmore St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6003800.52049	2108768.8119	37.7704922173631	-122.430209350707	(37.7704922173631, -122.430209350707)
132469	132469	129472	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	11 Filbert St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6012528.94679	2120206.6635	37.8023883923599	-122.400821180758	(37.8023883923599, -122.400821180758)
137937	137937	129474	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	11 Filbert St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			6012536.27851	2120200.91706	37.8023730229664	-122.400795405292	(37.8023730229664, -122.400795405292)
147602	147602	129471	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	11 Filbert St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			6012526.59847	2120207.76193	37.8023912773999	-122.40082938436701	(37.8023912773999, -122.400829384367)
174070	174070	129473	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	11 Filbert St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			6012532.2991	2120205.0438900003	37.8023841322847	-122.400809466192	(37.8023841322847, -122.400809466192)
171814	171814	129480	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	11 Greenwich St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			6012320.77236	2120522.45554	37.8032438670795	-122.401563778859	(37.8032438670795, -122.401563778859)
175563	175563	129481	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	11 Greenwich St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6012317.54236	2120532.7765200003	37.8032720257522	-122.401575682271	(37.8032720257522, -122.401575682271)
176379	176379	129482	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	11 Greenwich St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6012315.37501	2120537.75286	37.803285568636	-122.401583532467	(37.803285568636, -122.401583532467)
96489	96489	50428	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	11 Lee Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/06/2003 12:00:00 AM			Permit Number 47081	5996479.47890892	2089951.8399168998	37.7184080697361	-122.454173429085	(37.7184080697361, -122.454173429085)
93390	93390	33301	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1120 Taylor St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/14/1996 12:00:00 AM			Permit Number 37453	6009052.27411403	2116787.86536385	37.7928066833324	-122.412610401728	(37.7928066833324, -122.412610401728)
144076	144076	889	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1136X Alemany Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	3X3		6003353.033430001	2094335.58352	37.7308366096666	-122.43072708407401	(37.7308366096666, -122.430727084074)
11074	11074	882	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1138X Alemany Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/26/2016 12:00:00 AM	28	3x3		6003576.60001	2094409.9739299999	37.7310535326811	-122.429959483056	(37.7310535326811, -122.429959483056)
119851	119851	34725	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	114 Sutro Heights Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/28/1997 12:00:00 AM			Permit Number 38379	5981286.97907127	2111325.91865707	37.776212402307	-122.508272287748	(37.776212402307, -122.508272287748)
11146	11146	890	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1146 Alemany Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	4X4		6003547.94647	2094400.70663	37.7310264639915	-122.430057882374	(37.7310264639915, -122.430057882374)
137835	137835	129468	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1151 Lombard St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11			6006718.96895	2120094.36111	37.8017542606157	-122.420918621021	(37.8017542606157, -122.420918621021)
143078	143078	121420	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1155x Prague St	1	Median : Cutout 11	Tree 1	DPW 2				3x3		6000780.0	2086820.0	37.7100544057225	-122.439084019343	(37.7100544057225, -122.439084019343)
90495	90495	49718	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1195 Fitzgerald Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/03/2003 12:00:00 AM			Permit Number 46529	6014698.72785663	2090465.4227663002	37.7208461876659	-122.39123244275801	(37.7208461876659, -122.391232442758)
39739	39739	129479	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	12 Filbert St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10			6012506.1322099995	2120230.97584	37.8024538756	-122.400901840066	(37.8024538756, -122.400901840066)
64529	64529	129477	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	12 Filbert St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			6012514.7758	2120236.23138	37.8024687881724	-122.40087229823901	(37.8024687881724, -122.400872298239)
152532	152532	129478	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	12 Filbert St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			6012509.68294	2120230.66756	37.80245322719529	-122.400889531035	(37.8024532271953, -122.400889531035)
43545	43545	129484	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	12 Greenwich St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			6012303.2887699995	2120555.11364	37.8033325627054	-122.401626578498	(37.8033325627054, -122.401626578498)
53774	53774	129486	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	12 Greenwich St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			6012297.60436	2120565.6201	37.803361093695	-122.40164698862199	(37.803361093695, -122.401646988622)
166033	166033	129485	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	12 Greenwich St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10			6012301.33061	2120559.21941	37.803343726885	-122.40163364357099	(37.803343726885, -122.401633643571)
186348	186348	129483	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	12 Greenwich St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			6012307.75016	2120551.4086599997	37.8033226386787	-122.401610879045	(37.8033226386787, -122.401610879045)
24102	24102	186759	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 0ft		5984850.1974	2106711.7495	37.7637525404811	-122.495605915184	(37.7637525404811, -122.495605915184)
36675	36675	186762	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984853.5932	2106716.1156	37.7637647274179	-122.49559449238701	(37.7637647274179, -122.495594492387)
44625	44625	186760	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 0ft		5984860.8701	2106711.7495	37.7637531654529	-122.495569002148	(37.7637531654529, -122.495569002148)
45882	45882	186748	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 0ft		5984868.1469	2106676.3356	37.7636563549354	-122.495541222153	(37.7636563549354, -122.495541222153)
50007	50007	186756	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 0ft		5984857.4742	2106702.5322	37.7637276584797	-122.495580067458	(37.7637276584797, -122.495580067458)
66007	66007	186752	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984851.1676	2106688.9488	37.7636899929755	-122.49560087776399	(37.7636899929755, -122.495600877764)
70133	70133	186750	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984851.1676	2106678.2761	37.763660688738206	-122.49560009051399	(37.7636606887382, -122.495600090514)
73459	73459	186747	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984869.1172	2106666.6331	37.76362977141179	-122.495537150576	(37.7636297714118, -122.495537150576)
151432	151432	186745	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984852.3804	2106661.5394	37.763614805479	-122.495594661337	(37.763614805479, -122.495594661337)
156319	156319	186749	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984860.385	2106678.2761	37.7636612284897	-122.495568210877	(37.7636612284897, -122.495568210877)
184000	184000	186754	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 0ft		5984863.7808	2106693.8	37.763704051609004	-122.49555761110202	(37.763704051609, -122.495557611102)
12047	12047	909	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1217 Alemany Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			45	3X3		6003163.68633	2094174.8948400002	37.7303846655151	-122.431370220756	(37.7303846655151, -122.431370220756)
120269	120269	85386	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1239 48th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 49657	5981144.8	2106623.2	37.7632917298848	-122.508414943002	(37.7632917298848, -122.508414943002)
127237	127237	50114	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1252 Ulloa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2003 12:00:00 AM			Permit Number 46839	5992244.12505327	2098460.15223335	37.7415260004029	-122.469432140867	(37.7415260004029, -122.469432140867)
41740	41740	183278	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1255 42nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5983028.2339	2106536.9311	37.7631656789881	-122.50189448779601	(37.7631656789881, -122.501894487796)
154916	154916	37082	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1268 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/15/2002 12:00:00 AM	6		Permit Number 44549	5982146.28824129	2106471.58463776	37.762934408685396	-122.504939947841	(37.7629344086854, -122.504939947841)
9386	9386	926	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1278 Alemany Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	3x3		6002807.701830001	2094157.47604	37.7303166558715	-122.432599664217	(37.7303166558715, -122.432599664217)
172032	172032	176987	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1278 Alemany Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	Width 5ft		6002815.8897	2094148.3870700002	37.7302921639516	-122.43257070868799	(37.7302921639516, -122.432570708688)
84780	84780	33391	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	129 Pinehurst Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/14/1996 12:00:00 AM			Permit Number 37510	5993545.21642202	2093774.31911417	37.7287349718633	-122.464593277929	(37.7287349718633, -122.464593277929)
52773	52773	183252	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1300 La Playa	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5980914.4873	2106074.2169999997	37.761770805091096	-122.50917073482799	(37.7617708050911, -122.509170734828)
93638	93638	31942	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1300 La Playa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/01/1998 12:00:00 AM			Permit Number 39715	5980916.9213303	2106151.77480086	37.761983899941	-122.50916807626999	(37.761983899941, -122.50916807627)
31036	31036	181438	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1319 48th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5981181.6009	2106068.5638	37.761771027502	-122.508246492496	(37.761771027502, -122.508246492496)
37042	37042	207101	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1325 18th Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5990477.30542	2106226.48097	37.7627480320102	-122.476108237903	(37.7627480320102, -122.476108237903)
69434	69434	207099	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1325 18th Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5990478.55232	2106260.78747	37.7628423007597	-122.476106431162	(37.7628423007597, -122.476106431162)
161309	161309	207102	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1325 18th Ave	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990480.890819999	2106148.89617	37.7625352128593	-122.476090170539	(37.7625352128593, -122.476090170539)
174088	174088	207100	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1325 18th Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990476.61635	2106239.9997799997	37.762785111079396	-122.476111608564	(37.7627851110794, -122.476111608564)
40391	40391	129467	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1331 Greenwich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 4ft		6006504.317480001	2119710.78815	37.8006889650949	-122.42163415671301	(37.8006889650949, -122.421634156713)
167106	167106	47850	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1342 41st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/14/2002 12:00:00 AM	7		Permit Number 45609	5983405.04544412	2106002.56953842	37.7617206013965	-122.50055173019501	(37.7617206013965, -122.500551730195)
46923	46923	50575	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1347 41st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/06/2003 12:00:00 AM	0		Permit Number 47190	5983353.97136461	2105974.76120709	37.7616412492229	-122.50072631562	(37.7616412492229, -122.50072631562)
103188	103188	32605	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1370 36th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/23/1996 12:00:00 AM			Permit Number 37071	5984960.54583105	2105873.44387063	37.7614572492102	-122.49516243722	(37.7614572492102, -122.49516243722)
155355	155355	32594	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1379 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/22/1996 12:00:00 AM	1		Permit Number 37062	5985531.05347187	2105840.85496484	37.76140115330671	-122.49318691517	(37.7614011533067, -122.49318691517)
29234	29234	186513	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1400 Lower Great Hwy	14	unknown : Yard 19	Tree 1	Private 1			5	Width 0ft		5980894.1374	2105147.1675	37.759224194224	-122.509172270667	(37.759224194224, -122.509172270667)
50995	50995	186509	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1400 Lower Great Hwy	10	unknown : Yard 19	Tree 1	Private 1			7	Width 0ft		5980901.3856	2105130.6001	37.759179132228	-122.509145973072	(37.759179132228, -122.509145973072)
66913	66913	186510	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1400 Lower Great Hwy	11	unknown : Yard 19	Tree 1	Private 1			5	Width 0ft		5980902.4211	2105136.8129	37.759196251841395	-122.509142853237	(37.7591962518414, -122.509142853237)
182655	182655	186512	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1400 Lower Great Hwy	13	unknown : Yard 19	Tree 1	Private 1			5	Width 0ft		5980899.8324	2105147.1675	37.7592245299801	-122.509152574968	(37.7592245299801, -122.509152574968)
30866	30866	200618	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	59	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		6016445.2081	2095088.6176	37.733637339432	-122.38551735943399	(37.733637339432, -122.385517359434)
38728	38728	200604	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	61	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6016455.981000001	2095075.886	37.7336029770488	-122.385479227084	(37.7336029770488, -122.385479227084)
72294	72294	200614	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	55	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6016432.4764	2095111.6325	37.73369982930821	-122.385562980445	(37.7336998293082, -122.385562980445)
76333	76333	200612	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	53	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6016428.558999999	2095128.7713	37.7337466722751	-122.385577718213	(37.7337466722751, -122.385577718213)
76733	76733	200616	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	57	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6016436.8835	2095099.8803	37.7336678039609	-122.385546924914	(37.7336678039609, -122.385546924914)
137132	137132	200619	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	60	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6016453.0429	2095085.1899	37.733628361140106	-122.38549003320101	(37.7336283611401, -122.385490033201)
130969	130969	250332	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	141 27th Ave	1	: 4	Tree 1	Private 1			4	Width 3ft		5987387.77846	2115003.34197	37.786667192588894	-122.487438428541	(37.7866671925889, -122.487438428541)
99862	99862	67131	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1439 06th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/29/1992 12:00:00 AM			Permit Number 30551	5994253.6761319	2105720.38065143	37.761576666998295	-122.463010486718	(37.7615766669983, -122.463010486718)
130724	130724	227681	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	145 Alma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		5997959.25406	2106183.4369900003	37.7630608557823	-122.450227846644	(37.7630608557823, -122.450227846644)
109767	109767	47881	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1454 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/02/2008 12:00:00 AM		3x3	Permit Number 50547	5982810.24276317	2105223.95269531	37.759547805419004	-122.50255124802099	(37.759547805419, -122.502551248021)
133901	133901	51414	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1531 25th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/14/2004 12:00:00 AM	0		Permit Number 47738	5988357.88494646	2104888.81015522	37.7589520258954	-122.48334041038	(37.7589520258954, -122.48334041038)
185081	185081	227680	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1541 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 2ft		6003988.609540001	2099295.3111900003	37.7444908816604	-122.428883253577	(37.7444908816604, -122.428883253577)
57032	57032	30756	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1547 Thomas Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/31/1995 12:00:00 AM	1		Permit Number 34637	6015015.9888	2093715.5638	37.729788030208795	-122.390362726863	(37.7297880302088, -122.390362726863)
129429	129429	100423	Significant Tree 6	Leptospermum laevigatum :: Australian Tea Tree 38	155 Winston Dr	1	Front Yard : Yard 7	Tree 1	Private 1						5990788.0	2093142.6	37.7268410933597	-122.474078979965	(37.7268410933597, -122.474078979965)
23861	23861	184307	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1553 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5982166.1739	2104530.0154	37.7576045827244	-122.50472730219	(37.7576045827244, -122.50472730219)
94127	94127	30765	Permitted Site 1	Leptospermum laevigatum :: Australian Tea Tree 38	1593 Underwood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/31/1995 12:00:00 AM			Permit Number 34646	6014616.43299999	2093667.83534348	37.729634805621096	-122.391740711397	(37.7296348056211, -122.391740711397)

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