Street_Tree_List

Data source: data.sfgov.org

416 rows where qSpecies = 143 sorted by TreeID

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, qCareAssistant, PlantDate, PermitNotes

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
92718	92718	1321	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	4050X Alemany Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			75	TR		5991740.4279021	2087082.0100679002	37.710255321179204	-122.470345319704	(37.7102553211792, -122.470345319704)
78878	78878	2044	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	700X Bosworth St	1	Front Yard : Cutout 8	Tree 1	DPW 2			36		Permit Number 772999	6002154.6210393	2095431.8532492002	37.733778746199796	-122.43494855504801	(37.7337787461998, -122.434948555048)
112836	112836	2272	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	750X Brotherhood Way	6	Median : Cutout 11	Tree 1	DPW 2			20	14M		5991074.042616099	2088106.2478104	37.71302907778821	-122.47272309171998	(37.7130290777882, -122.47272309172)
107203	107203	2273	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	750X Brotherhood Way	7	Median : Cutout 11	Tree 1	DPW 2			35	14M		5991074.042616099	2088106.2478104	37.71302907778821	-122.47272309171998	(37.7130290777882, -122.47272309172)
143021	143021	12967	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	99X Lippard Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3X3		6001957.7757889	2095598.483465	37.734225095766796	-122.43564102376301	(37.7342250957668, -122.435641023763)
112623	112623	12968	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	99X Lippard Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	4X4		6001957.7757889	2095598.483465	37.734225095766796	-122.43564102376301	(37.7342250957668, -122.435641023763)
34310	34310	12969	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	99X Lippard Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	3X4		6001957.7757889	2095598.483465	37.734225095766796	-122.43564102376301	(37.7342250957668, -122.435641023763)
106673	106673	12970	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	99X Lippard Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	5X4		6001957.7757889	2095598.483465	37.734225095766796	-122.43564102376301	(37.7342250957668, -122.435641023763)
117342	117342	12974	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	84 Lippard Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6001901.0890899	2095580.5218873	37.734172557472604	-122.43583572272101	(37.7341725574726, -122.435835722721)
129462	129462	13401	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	344 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			70	5		5999579.163416	2097433.156503	37.739127283554204	-122.443996396446	(37.7391272835542, -122.443996396446)
3445	3445	16362	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306X Montgomery St	14	Median : Cutout 11	Tree 1	DPW 2			18	8		6011452.97865	2119928.00722	37.801563196957204	-122.40452495315901	(37.8015631969572, -122.404524953159)
82763	82763	16363	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1300X Montgomery St	16	Median : Cutout 11	Tree 1	DPW 2			12	8		6011500.916866099	2119743.0722499	37.8010580895294	-122.404346040012	(37.8010580895294, -122.404346040012)
119369	119369	16364	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1300X Montgomery St	17	Median : Cutout 11	Tree 1	DPW 2			12	8		6011500.916866099	2119743.0722499	37.8010580895294	-122.404346040012	(37.8010580895294, -122.404346040012)
86861	86861	16368	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1400X Montgomery St	1	Median : Cutout 11	Tree 1	DPW 2			26	8		6011455.2971485	2120087.0441833	37.8020000032358	-122.404528131508	(37.8020000032358, -122.404528131508)
69279	69279	16369	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1400X Montgomery St	2	Median : Cutout 11	Tree 1	DPW 2			18	8		6011455.2971485	2120087.0441833	37.8020000032358	-122.404528131508	(37.8020000032358, -122.404528131508)
110694	110694	16370	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1400X Montgomery St	3	Median : Cutout 11	Tree 1	DPW 2			18	8		6011455.2971485	2120087.0441833	37.8020000032358	-122.404528131508	(37.8020000032358, -122.404528131508)
80175	80175	16371	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1400X Montgomery St	4	Median : Cutout 11	Tree 1	DPW 2			18	8		6011455.2971485	2120087.0441833	37.8020000032358	-122.404528131508	(37.8020000032358, -122.404528131508)
99481	99481	16372	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1400X Montgomery St	5	Median : Cutout 11	Tree 1	DPW 2			12	8		6011455.2971485	2120087.0441833	37.8020000032358	-122.404528131508	(37.8020000032358, -122.404528131508)
128229	128229	16373	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1400X Montgomery St	6	Median : Cutout 11	Tree 1	DPW 2			18	8		6011455.2971485	2120087.0441833	37.8020000032358	-122.404528131508	(37.8020000032358, -122.404528131508)
112248	112248	16374	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1400X Montgomery St	7	Median : Cutout 11	Tree 1	DPW 2			12	8		6011455.2971485	2120087.0441833	37.8020000032358	-122.404528131508	(37.8020000032358, -122.404528131508)
114376	114376	18112	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1102X Portola Dr	1	Median : Cutout 11	Tree 1	DPW 2			24	10		5995262.3028257005	2098061.6496673	37.7406057719366	-122.458967536918	(37.7406057719366, -122.458967536918)
145419	145419	18113	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1102X PORTOLA DR	2	Median : Cutout 11	Tree 1	DPW 2			24	10		5995249.0	2098057.0	37.7405922403942	-122.45901319608299	(37.7405922403942, -122.459013196083)
16804	16804	19778	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	100 STAIRWAY18	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	50ST
6719	6719	20066	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	100 STAIRWAY54	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	15ST
9550	9550	20300	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	50X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
7578	7578	20324	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
8763	8763	20326	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
7875	7875	20330	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
7348	7348	20335	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
16994	16994	20336	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
6436	6436	20340	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
13143	13143	20345	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	31	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	40
9561	9561	20346	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	101X Sunset Blvd	32	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	40
5922	5922	20397	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	262X Sunset Blvd	42	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
10180	10180	20460	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	495X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
96752	96752	20511	Permitted Site 1	Pinus pinea :: Italian Stone Pine 143	1211X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3			24	60		5984783.690159501	2107169.3790132	37.7650051676015	-122.49586970049101	(37.7650051676015, -122.495869700491)
128747	128747	20512	Permitted Site 1	Pinus pinea :: Italian Stone Pine 143	1211X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3			24	60		5984783.690159501	2107169.3790132	37.7650051676015	-122.49586970049101	(37.7650051676015, -122.495869700491)
82062	82062	20767	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1692X Sunset Blvd	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60		5984807.486919099	2103677.7923597	37.755419639160706	-122.495529849669	(37.7554196391607, -122.495529849669)
96565	96565	20978	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	2002X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40		5984887.616570599	2101567.3225095	37.7496295616808	-122.49509712324499	(37.7496295616808, -122.495097123245)
22325	22325	21131	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	2292X Sunset Blvd	4	Median : Cutout 11	Tree 1	DPW 2			0	60		5984947.8628076	2099601.6268993	37.7442358239277	-122.49474388696001	(37.7442358239277, -122.49474388696)
128359	128359	21135	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	2292X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			5984947.8628076	2099601.6268993	37.7442358239277	-122.49474388696001	(37.7442358239277, -122.49474388696)
114196	114196	21312	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	2501X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60		5985074.890734901	2098188.1189419	37.740362147215	-122.494200494189	(37.740362147215, -122.494200494189)
110317	110317	22454	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	6155X 03rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	40M		6013523.9988031	2091160.9249677	37.722690633869	-122.395341851189	(37.722690633869, -122.395341851189)
7603	7603	23579	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	3100X Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2			42	3x3		6005511.92719	2121098.1181099997	37.804442208310206	-122.425167011149	(37.8044422083102, -122.425167011149)
6953	6953	23580	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	3100X Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			24	9		6005507.77084	2121129.71298	37.8045287248816	-122.42518364411501	(37.8045287248816, -122.425183644115)
83211	83211	23673	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	319 Virginia Ave	2	Median : Cutout 11	Tree 1	DPW 2			12	12		6006936.2458165	2098250.5638735	37.741788638281996	-122.418616833275	(37.741788638282, -122.418616833275)
128561	128561	24283	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	300X Winding Way	21	Median : Cutout 11	Tree 1	DPW 2			6	8		6001646.2933309	2086550.8578367	37.7093646550959	-122.436070699117	(37.7093646550959, -122.436070699117)
97677	97677	24742	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	50X Point Lobos Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	12x12		5982568.6363699995	2112600.93828	37.779788677407105	-122.50393321801701	(37.7797886774071, -122.503933218017)
21066	21066	30050	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	900X Junipero Serra Blvd	1	Median : Cutout 11	Tree 1	DPW 2			3	3X3		5991182.4145599995	2091161.54655	37.7214244519661	-122.472571141372	(37.7214244519661, -122.472571141372)
159704	159704	38524	Permitted Site 1	Pinus pinea :: Italian Stone Pine 143	3031 Steiner St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/15/1998 12:00:00 AM	4		Permit Number 40508	6001948.5977	2118592.4425	37.7973603403586	-122.43731867582599	(37.7973603403586, -122.437318675826)
152465	152465	54486	Permitted Site 1	Pinus pinea :: Italian Stone Pine 143	535 39th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/11/1972 12:00:00 AM	8		Permit Number 10278	5983764.831730001	2112189.27219	37.7787286289905	-122.499764682948	(37.7787286289905, -122.499764682948)
112766	112766	92207	Permitted Site 1	Pinus pinea :: Italian Stone Pine 143	300X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1		07/16/2009 12:00:00 AM		2x2	Permit Number 52642	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
100266	100266	92210	Permitted Site 1	Pinus pinea :: Italian Stone Pine 143	300x Miramar Ave	4	Median : Cutout 11	Tree 1	Private 1		07/16/2009 12:00:00 AM		2x2	Permit Number 52642	5995384.3	2092126.4	37.724316032008204	-122.45811627477501	(37.7243160320082, -122.458116274775)
138508	138508	96480	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	1101 Eucalyptus Dr		Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	FUF 1				In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City	5988077.2	2094728.1	37.731037066667795	-122.483566221845	(37.7310370666678, -122.483566221845)
97749	97749	96481	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	1101 Eucalyptus Dr		Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	FUF 1				In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City	5988077.2	2094728.1	37.731037066667795	-122.483566221845	(37.7310370666678, -122.483566221845)
109217	109217	96482	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	1101 Eucalyptus Dr		Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	FUF 1				In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City	5988077.2	2094728.1	37.731037066667795	-122.483566221845	(37.7310370666678, -122.483566221845)
86907	86907	96483	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	1101 Eucalyptus Dr		Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	FUF 1				In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City	5988077.2	2094728.1	37.731037066667795	-122.483566221845	(37.7310370666678, -122.483566221845)
81160	81160	96570	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	1101 Eucalyptus Dr		Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	FUF 1				In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City	5988077.2	2094728.1	37.731037066667795	-122.483566221845	(37.7310370666678, -122.483566221845)
113578	113578	96571	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	1101 Eucalyptus Dr		Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	FUF 1				In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City	5988077.2	2094728.1	37.731037066667795	-122.483566221845	(37.7310370666678, -122.483566221845)
58967	58967	96572	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	1101 Eucalyptus Dr		Sidewalk: Property side : Cutout 5	Tree 1	SFUSD 4	FUF 1				In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City	5988077.2	2094728.1	37.731037066667795	-122.483566221845	(37.7310370666678, -122.483566221845)
93919	93919	96976	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	390X Filbert St	1	Median : Yard 3	Tree 1	Rec/Park 3			28			6010951.1	2119992.4	37.8017119430502	-122.406266229116	(37.8017119430502, -122.406266229116)
120510	120510	97485	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	500X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
90036	90036	97489	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	500X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
126256	126256	97490	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	500X Miramar Ave	7	Median : Cutout 11	Tree 1	Private 1			12	15x280		5995423.2	2092691.6	37.7258701708071	-122.45802268806801	(37.7258701708071, -122.458022688068)
75150	75150	97534	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	203 Surrey St	1	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 768282	6002070.0	2096079.6	37.73555250464221	-122.435287431957	(37.7355525046422, -122.435287431957)
128311	128311	98265	Property Tree 7	Pinus pinea :: Italian Stone Pine 143	755 O'Farrell St		Back Yard : Yard 13	Tree 1	Private 1					Backyard tree; not significant	6007700.0	2113968.3	37.784988860902295	-122.417089467607	(37.7849888609023, -122.417089467607)
107888	107888	98601	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	301 Twin Peaks Blvd	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1			24	3x3		5998661.2	2104103.7	37.757390562446	-122.447650343479	(37.757390562446, -122.447650343479)
87158	87158	98835	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1100X Portola Dr	1	Front Yard : Yard 7	Tree 1	DPW 2						5995262.0	2098056.7	37.7405921639667	-122.458968225676	(37.7405921639667, -122.458968225676)
97197	97197	98836	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1101X Portola Dr	6	Sidewalk: Property side : Yard 9	Tree 1	DPW 2						5994967.957909999	2097979.30417	37.740362747150996	-122.459979297607	(37.740362747151, -122.459979297607)
6592	6592	98837	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1101X Portola Dr	9	Sidewalk: Property side : Yard 9	Tree 1	DPW 2
14567	14567	98839	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1101X Portola Dr	4	Sidewalk: Property side : Yard 9	Tree 1	DPW 2
128319	128319	99451	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	400X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995388.7	2092398.7	37.7250639553871	-122.45812076272101	(37.7250639553871, -122.458120762721)
145354	145354	99455	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	400X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995388.7	2092398.7	37.7250639553871	-122.45812076272101	(37.7250639553871, -122.458120762721)
120095	120095	99457	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	550X Miramar Ave	1	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
142707	142707	99458	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	550X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
126291	126291	99460	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	550X Miramar Ave	7	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995413.0	2092983.7	37.7266716211667	-122.45807907885799	(37.7266716211667, -122.458079078858)
112364	112364	99472	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	600X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
80646	80646	99473	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	600X Miramar Ave	2	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995435.2	2093399.0	37.727813210556704	-122.458032376835	(37.7278132105567, -122.458032376835)
99445	99445	99474	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	650X Miramar Ave	5	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
101015	101015	99477	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	650X Miramar Ave	6	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995425.4	2093662.3	37.728535605791	-122.45808530293199	(37.728535605791, -122.458085302932)
114163	114163	99486	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	700X Miramar Ave	3	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
88472	88472	99487	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	700X Miramar Ave	4	Median : Cutout 11	Tree 1	Private 1			30	15x280		5995446.3	2094052.9	37.7296092999141	-122.458041307204	(37.7296092999141, -122.458041307204)
145927	145927	99774	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	4330 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				8x6		6001764.0	2100607.0	37.7479663028981	-122.436669359529	(37.7479663028981, -122.436669359529)
109239	109239	100845	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1 Estero Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5992057.7	2091642.6	37.7227959320346	-122.469580550695	(37.7227959320346, -122.469580550695)
120808	120808	101027	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1010X Portola Dr	1	Front Yard : Yard 7	Tree 1	DPW 2						5995923.3	2098391.5	37.7415494342357	-122.45670592621	(37.7415494342357, -122.45670592621)
140599	140599	101028	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1010X Portola Dr	2	Front Yard : Yard 7	Tree 1	DPW 2						5995923.3	2098391.5	37.7415494342357	-122.45670592621	(37.7415494342357, -122.45670592621)
129469	129469	101030	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1010X Portola Dr	4	Median : Yard 3	Tree 1	DPW 2			40			5995923.3	2098391.5	37.7415494342357	-122.45670592621	(37.7415494342357, -122.45670592621)
129360	129360	101032	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1010X Portola Dr	6	Front Yard : Yard 7	Tree 1	DPW 2						5995923.3	2098391.5	37.7415494342357	-122.45670592621	(37.7415494342357, -122.45670592621)
111337	111337	101035	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1010X Portola Dr	9	Front Yard : Yard 7	Tree 1	DPW 2		09/03/2014 12:00:00 AM	3			5995923.3	2098391.5	37.7415494342357	-122.45670592621	(37.7415494342357, -122.45670592621)
9596	9596	102839	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1101X Portola Dr	2	Sidewalk: Property side : Yard 9	Tree 1	DPW 2
77640	77640	105838	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	39X Bonview St	1	Front Yard : Yard 7	Tree 1	DPW 2			15			6007716.90579	2099172.4114099997	37.7443637468546	-122.415982827151	(37.7443637468546, -122.415982827151)
121646	121646	107347	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1126X PORTOLA DR	1	Median : Cutout 11	Tree 1	DPW 2			68			5994964.0	2098019.0	37.7404715144277	-122.459995857341	(37.7404715144277, -122.459995857341)
7555	7555	107448	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1111x Chestnut St	1	Unaccepted Street : Yard 14	Tree 1	Private 1			50			6006408.68895	2120404.8626200003	37.80258932431129	-122.42201440535801	(37.8025893243113, -122.422014405358)
26646	26646	107449	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1130x CHESTNUT ST	1	Unaccepted Street : Yard 14	Tree 1	Private 1			60			6006351.9	2120450.9	37.802712528214705	-122.42221419659701	(37.8027125282147, -122.422214196597)
8668	8668	107450	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1140x Chestnut St	1	Unaccepted Street : Yard 14	Tree 1	Private 1			60			6006380.05181	2120425.48408	37.802644330436394	-122.42211497023399	(37.8026443304364, -122.422114970234)
160604	160604	107487	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306x Montgomery St	12	Median : Cutout 11	Tree 1	DPW 2			23			6011454.1798	2119912.99001	37.801522030487	-122.40451973891001	(37.801522030487, -122.40451973891)
37436	37436	107492	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306x Montgomery St	21	Median : Cutout 11	Tree 1	DPW 2			26			6011443.89272	2119983.46704	37.80171496831821	-122.404560301033	(37.8017149683182, -122.404560301033)
102335	102335	108605	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1140x CHESTNUT ST	2	Unaccepted Street : Yard 14	Tree 1	Private 1						6006369.1	2120452.7	37.802718440704204	-122.42215480373899	(37.8027184407042, -122.422154803739)
81729	81729	109625	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	312x FILBERT ST	1	Unaccepted Street : Yard 14	Tree 1	Private 1			14			6011362.9	2120079.8	37.801974948341	-122.40484736081001	(37.801974948341, -122.40484736081)
88665	88665	109838	Significant Tree 6	Pinus pinea :: Italian Stone Pine 143	200x MONTCALM ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			30	3x3		6009924.0	2099647.0	37.745790704819704	-122.408384592716	(37.7457907048197, -122.408384592716)

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