Street_Tree_List

Data source: data.sfgov.org

713 rows where qLegalStatus = 3 and qSpecies = 3

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSiteInfo, qCaretaker, PlantDate, PermitNotes

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
3	3	119263	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Lakeshore Dr	1	Median : Yard 3	Tree 1	DPW 2				10x30
437	437	20292	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
455	455	234501	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	2423 Market St	2	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2			12	Width 8ft		6002117.5892	2105782.84009	37.7621980066439	-122.435816935712	(37.7621980066439, -122.435816935712)
556	556	20399	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	44	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
1272	1272	251489	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	31	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1282	1282	251482	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	1	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1283	1283	251493	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	35	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1286	1286	251492	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	34	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1288	1288	251487	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	29	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1290	1290	251486	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	28	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1295	1295	251491	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	33	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1298	1298	251490	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	32	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1299	1299	251494	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	36	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1316	1316	251488	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	30	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1322	1322	251483	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	8	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1332	1332	251484	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	7	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1338	1338	251485	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900 Bosworth St	6	Front Yard : Yard 7	Tree 1	DPW 2						6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
1347	1347	251504	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	620x Noriega St	1	Median : Cutout 11	Tree 1	DPW 2				3x3		5992030.0	2103590.0	37.7555988620986	-122.470546036282	(37.7555988620986, -122.470546036282)
1547	1547	251582	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	691x Ulloa St	1	Back Yard : Cutout 16	Tree 1	DPW 2				3x3		5994175.0	2098101.0	37.7406512558576	-122.462729837498	(37.7406512558576, -122.462729837498)
1841	1841	20401	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	46	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
2042	2042	20405	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	50	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
2268	2268	4983	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	5300 Diamond Heights Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/10/2017 12:00:00 AM	3	3X3	Permit Number 780192	6001475.6363	2098933.58975	37.7433551224547	-122.43754668724199	(37.7433551224547, -122.437546687242)
2700	2700	20053	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY53	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
3319	3319	4982	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	5300 Diamond Heights Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/31/2017 12:00:00 AM	3	3X3	Permit Number 780192	6001462.73007	2098944.10019	37.743383247851604	-122.437592066128	(37.7433832478516, -122.437592066128)
4187	4187	20426	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
4260	4260	20045	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY52	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10
4482	4482	20388	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	34	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
4528	4528	19968	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY43	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	15
5104	5104	253785	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	1675X 15th Ave	1	Median : Cutout 11	Tree 1	DPW 2				3x3		5991390.0	2103897.0	37.7564047756354	-122.47278171886002	(37.7564047756354, -122.47278171886)
5106	5106	253787	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	1675X 15th Ave	3	Median : Cutout 11	Tree 1	DPW 2				3x3		5991390.0	2103897.0	37.7564047756354	-122.47278171886002	(37.7564047756354, -122.47278171886)
5282	5282	20344	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	40
5456	5456	20311	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
6219	6219	20290	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6407	6407	20308	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
6784	6784	20408	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	53	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
7028	7028	20295	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
7080	7080	20425	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
7092	7092	19853	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY29	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
7096	7096	20070	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY55	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
7176	7176	19977	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY45	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	30ST
7292	7292	20433	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
7424	7424	20416	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
7658	7658	20289	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
8078	8078	20329	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
8485	8485	20457	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
9506	9506	20420	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
9521	9521	20394	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	39	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
9600	9600	20367	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
9843	9843	20458	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
9855	9855	20400	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	45	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
9890	9890	3755	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	1050 Carolina St	1	Median : Cutout 11	Tree 1	DPW 2			12	18		6012450.5971046	2103074.0676917997	37.7553418567665	-122.39988853682199	(37.7553418567665, -122.399888536822)
9909	9909	173722	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	928 Carolina St	1	Median : Cutout 11	Tree 1	DPW 2			17	3x3		6012423.0	2103596.0	37.7567734300957	-122.400020627969	(37.7567734300957, -122.400020627969)
10388	10388	2288	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	800X Brotherhood Way	3	Median : Cutout 11	Tree 1	DPW 2		08/30/2016 12:00:00 AM	3	14M	Permit Number 777532	5989397.47374	2088680.9253	37.714509804868605	-122.47855980688699	(37.7145098048686, -122.478559806887)
10567	10567	20323	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
10721	10721	2286	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	800X Brotherhood Way	1	Median : Cutout 11	Tree 1	DPW 2		08/30/2016 12:00:00 AM	3	14M	Permit Number 777532	5989102.32398	2088689.12288	37.714515172905294	-122.4795805509	(37.7145151729053, -122.4795805509)
10850	10850	20451	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
10974	10974	20418	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
11124	11124	20380	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
11126	11126	2292	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	800X Brotherhood Way	7	Median : Cutout 11	Tree 1	DPW 2			45	14M		5989842.77121	2088680.7511900002	37.7145351702246	-122.477020683771	(37.7145351702246, -122.477020683771)
11130	11130	20306	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
11192	11192	24264	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	350X Winding Way	2	Median : Cutout 11	Tree 1	DPW 2			24	8		6001155.71614	2086583.0952599999	37.709425288929296	-122.437768517615	(37.7094252889293, -122.437768517615)
11214	11214	20374	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
11595	11595	20431	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	30
11659	11659	106061	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	12X Canyon Dr	1	Median : Yard 3	Tree 1	DPW 2			40			6003256.93175	2086330.4794599998	37.7088509162175	-122.430488359046	(37.7088509162175, -122.430488359046)
11765	11765	20396	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	41	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
12513	12513	2291	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	800X Brotherhood Way	6	Median : Cutout 11	Tree 1	DPW 2			24	14M		5989707.10535	2088681.30853	37.714528829127495	-122.477489635265	(37.7145288291275, -122.477489635265)
12711	12711	19749	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY15	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
12855	12855	20286	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
12984	12984	2293	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	800X Brotherhood Way	8	Median : Cutout 11	Tree 1	DPW 2			30	14M		5990043.7756199995	2088644.1713900003	37.71444639007029	-122.476323268498	(37.7144463900703, -122.476323268498)
13003	13003	24273	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	350X Winding Way	11	Median : Cutout 11	Tree 1	DPW 2			12	8		6000864.27338	2086762.8945799998	37.7099024017335	-122.43878866537399	(37.7099024017335, -122.438788665374)
13180	13180	20069	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY55	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	40ST
13202	13202	20284	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13213	13213	2294	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	800X Brotherhood Way	9	Median : Cutout 11	Tree 1	DPW 2			45	14M		5990137.079530001	2088614.4864299998	37.714370293032204	-122.475998609661	(37.7143702930322, -122.475998609661)
13357	13357	20454	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
13388	13388	20313	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13426	13426	20293	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
13476	13476	20287	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13681	13681	19775	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY18	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	50ST
13746	13746	20338	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
13748	13748	20343	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	29	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
14111	14111	20421	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14252	14252	20285	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14683	14683	20337	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
14835	14835	20387	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	33	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
14905	14905	20283	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
15072	15072	20052	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY53	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
15202	15202	20339	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
15238	15238	20432	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	30
15347	15347	20288	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
15632	15632	20427	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
16056	16056	20402	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	47	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
16063	16063	20307	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
16202	16202	20435	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
16297	16297	19969	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY43	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	15
16394	16394	20368	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
16828	16828	20461	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
17834	17834	16381	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	1000 Moraga St	3	Median : Cutout 11	Tree 1	DPW 2			24	12		5991038.119519999	2103837.44782	37.7562208847883	-122.47399428791799	(37.7562208847883, -122.473994287918)
18375	18375	11190	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	140 Idora Ave	1	Median : Cutout 11	Tree 1	DPW 2			24	8		5995683.115039401	2099368.7198886	37.7442188444672	-122.457607088025	(37.7442188444672, -122.457607088025)
18836	18836	30076	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	410X Brotherhood Way	11	Median : Cutout 11	Tree 1	DPW 2		03/10/2007 12:00:00 AM	6	M		5993748.152574	2087576.478532	37.7117288925291	-122.463442127126	(37.7117288925291, -122.463442127126)
19113	19113	4974	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	5200X Diamond Heights Blvd	10	Median : Cutout 11	Tree 1	DPW 2			12	12		6000911.31432	2099444.9687099997	37.7447271470412	-122.43953461434201	(37.7447271470412, -122.439534614342)

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