Street_Tree_List

Data source: data.sfgov.org

548 rows where qSpecies = 40 sorted by XCoord

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
1707	1707	19767	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY16	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30ST
1811	1811	19991	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
1842	1842	19990	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40
2751	2751	19916	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
5450	5450	19643	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	42	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
5580	5580	19952	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY39	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
5629	5629	19629	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
5638	5638	19734	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY14	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
6130	6130	19637	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	36	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
6465	6465	20050	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY52	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10
6552	6552	19622	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
6727	6727	20046	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY52	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	10
6840	6840	19703	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY13	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
6859	6859	19881	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
7127	7127	19877	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	25ST
8000	8000	19575	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	100ST
8376	8376	17629	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	150 Phelps St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10M
8874	8874	19879	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
8891	8891	19873	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	25ST
9101	9101	19626	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
9670	9670	19824	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY25	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
10584	10584	19572	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
10624	10624	19574	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
10757	10757	19823	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY25	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
10946	10946	19995	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
11109	11109	19996	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
11188	11188	19822	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY25	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
11496	11496	19573	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
11523	11523	19635	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	34	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
11623	11623	19765	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY16	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30ST
12152	12152	19571	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
12720	12720	19640	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	39	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
12830	12830	19619	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
12952	12952	19628	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
13122	13122	19636	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	35	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
13156	13156	20391	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	262X Sunset Blvd	37	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13560	13560	20028	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY49	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10
13632	13632	19618	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
13773	13773	19987	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40
13883	13883	19639	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
14157	14157	17628	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	150 Phelps St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10M
14188	14188	19617	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
14653	14653	19921	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY37	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3
15445	15445	19918	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
15768	15768	19884	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	25ST
15790	15790	87061	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40			unknown : Yard 19	Tree 1	Private 1				3x3	Permit Number 50003
15852	15852	19567	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
15947	15947	19630	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	29	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
16203	16203	19623	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
16222	16222	19870	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	25ST
16278	16278	19770	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY16	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30ST
16313	16313	19876	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
16376	16376	19641	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	40	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
16486	16486	19701	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY12	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
16953	16953	19917	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
119576	119576	68317	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	1999X 48th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/09/1993 12:00:00 AM			Permit Number 32130	5981353.71840295	2101490.23529545	37.7492103807501	-122.50731153380801	(37.7492103807501, -122.507311533808)
121834	121834	69022	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	2094 48th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/05/1994 12:00:00 AM			Permit Number 33026	5981407.07152231	2100831.13487358	37.7474038185251	-122.507078153918	(37.7474038185251, -122.507078153918)
93083	93083	34702	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	546 46th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/28/1997 12:00:00 AM			Permit Number 38359	5981647.34162822	2112027.92469202	37.7781611337001	-122.50707780583099	(37.7781611337001, -122.507077805831)
50313	50313	69180	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	1310 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/26/1994 12:00:00 AM	8		Permit Number 33219	5982156.72464205	2106168.22486515	37.7621020835294	-122.504881372035	(37.7621020835294, -122.504881372035)
152160	152160	51577	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	584 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/08/2005 12:00:00 AM	28		Permit Number 47871	5982583.51771	2111812.9357	37.7776259284617	-122.50382336032	(37.7776259284617, -122.50382336032)
165342	165342	62644	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	1255 42nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/03/2008 12:00:00 AM	1	3x3	Permit Number 50627	5983022.3246657	2106594.48040873	37.763323345885404	-122.50191918393699	(37.7633233458854, -122.501919183937)
182351	182351	181588	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	1227 37th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5984569.5881	2106811.9615	37.764011258359105	-122.496583837339	(37.7640112583591, -122.496583837339)
166229	166229	183716	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	1231 37th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5984571.0948	2106790.8677	37.7639534289968	-122.49657706948	(37.7639534289968, -122.49657706948)
85692	85692	63202	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	7 Shore View Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/18/1986 12:00:00 AM			Permit Number 23744	5984650.094069201	2112837.90974399	37.78056150785579	-122.496750144554	(37.7805615078558, -122.496750144554)
99896	99896	20988	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	2002X Sunset Blvd	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			200	40		5984887.616570599	2101567.3225095	37.7496295616808	-122.49509712324499	(37.7496295616808, -122.495097123245)
41295	41295	187029	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	2501 Sunset Blvd	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			38	Width 0ft		5984947.4301	2097843.1311	37.7394074439231	-122.49461576933999	(37.7394074439231, -122.49461576934)
43878	43878	187030	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	2501 Sunset Blvd	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5984957.5185	2097843.1311	37.7394080343891	-122.49458088860901	(37.7394080343891, -122.494580888609)
182619	182619	187037	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	2501 Sunset Blvd	56	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 0ft		5984959.5362	2097794.0341	37.7392733453171	-122.49457029390899	(37.7392733453171, -122.494570293909)
72098	72098	187038	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	2501 Sunset Blvd	57	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984961.8902	2097789.6624	37.7392614795793	-122.494561832752	(37.7392614795793, -122.494561832752)
131781	131781	187031	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	2501 Sunset Blvd	50	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 0ft		5984966.2618	2097842.7948	37.7394076227298	-122.494550633787	(37.7394076227298, -122.494550633787)
28658	28658	187032	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	2501 Sunset Blvd	51	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 0ft		5984967.607000001	2097835.0603	37.73938646460329	-122.494545412715	(37.7393864646033, -122.494545412715)
111909	111909	60551	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	539 35th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/18/1982 12:00:00 AM			Permit Number 20161	5985003.93496372	2112200.51497155	37.7788321315722	-122.49547903508801	(37.7788321315722, -122.495479035088)
126005	126005	60557	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	646 35th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/18/1982 12:00:00 AM			Permit Number 20167	5985081.30797731	2111459.74994128	37.776802733932	-122.495156735304	(37.776802733932, -122.495156735304)
19129	19129	12492	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	307 Lake Merced Blvd	37	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			36	90M		5985224.7663097	2094165.6248746999	37.7293262181041	-122.49338600271003	(37.7293262181041, -122.49338600271)
77867	77867	12494	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	307 Lake Merced Blvd	39	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			12	90M		5985224.7663097	2094165.6248746999	37.7293262181041	-122.49338600271003	(37.7293262181041, -122.49338600271)
78081	78081	12493	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	307 Lake Merced Blvd	38	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			18	90M		5985224.7663097	2094165.6248746999	37.7293262181041	-122.49338600271003	(37.7293262181041, -122.49338600271)
82877	82877	12490	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	307 Lake Merced Blvd	35	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			24	90M		5985224.7663097	2094165.6248746999	37.7293262181041	-122.49338600271003	(37.7293262181041, -122.49338600271)
96574	96574	12496	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	307 Lake Merced Blvd	41	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			24	90M		5985224.7663097	2094165.6248746999	37.7293262181041	-122.49338600271003	(37.7293262181041, -122.49338600271)
107551	107551	12488	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	307 Lake Merced Blvd	33	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			24	90M		5985224.7663097	2094165.6248746999	37.7293262181041	-122.49338600271003	(37.7293262181041, -122.49338600271)
108276	108276	12495	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	307 Lake Merced Blvd	40	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			18	90M		5985224.7663097	2094165.6248746999	37.7293262181041	-122.49338600271003	(37.7293262181041, -122.49338600271)
170536	170536	32593	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	1375 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/22/1996 12:00:00 AM	1		Permit Number 37061	5985530.158172799	2105866.8789552	37.7614725555795	-122.49319192882099	(37.7614725555795, -122.493191928821)
36977	36977	186970	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1650x Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5986025.4295	2095869.2083	37.734050611594604	-122.49074337328301	(37.7340506115946, -122.490743373283)
104967	104967	108502	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	2300 33RD AVE	1	Back Yard : Yard 13	Tree 1	Private 1			32			5986128.8	2099536.7	37.7441266056665	-122.49065574130199	(37.7441266056665, -122.490655741302)
53330	53330	186974	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1600x Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5986249.0864	2095869.2083	37.7340636742344	-122.489970132524	(37.7340636742344, -122.489970132524)
69668	69668	66337	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	1230 31st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/10/1990 12:00:00 AM	12		Permit Number 29458	5986478.94641131	2106871.16119587	37.7642854833106	-122.489984375656	(37.7642854833106, -122.489984375656)
94515	94515	107708	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	1798X 31st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986575.46002	2103344.33269	37.7546074174257	-122.489391225039	(37.7546074174257, -122.489391225039)
100492	100492	107709	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	1798X 31st Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986575.46002	2103344.33269	37.7546074174257	-122.489391225039	(37.7546074174257, -122.489391225039)
120953	120953	107712	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	1798X 31st Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986575.46002	2103344.33269	37.7546074174257	-122.489391225039	(37.7546074174257, -122.489391225039)
139574	139574	107711	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	1798X 31st Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5986575.46002	2103344.33269	37.7546074174257	-122.489391225039	(37.7546074174257, -122.489391225039)
81453	81453	114249	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	499x 24TH AVE	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		5988415.0	2112957.0	37.78110836988721	-122.483734439284	(37.7811083698872, -122.483734439284)
132300	132300	185059	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Sloat Blvd	3	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		5988840.8776	2095965.7184	37.7344796690595	-122.481016672562	(37.7344796690595, -122.481016672562)
58856	58856	185127	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Sloat Blvd	2	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5989015.4133	2095969.6432	37.734500589899504	-122.480413539116	(37.7345005898995, -122.480413539116)
98498	98498	109631	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	390 BUCKINGHAM WAY		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				9x9		5989374.0	2093588.0	37.7279820381776	-122.478999652651	(37.7279820381776, -122.478999652651)
117345	117345	51287	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	726 21st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/09/1993 12:00:00 AM			Permit Number 47659	5989465.45229129	2110387.70383509	37.774114887360504	-122.479912367003	(37.7741148873605, -122.479912367003)
77778	77778	64888	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	2418 22nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/01/1989 12:00:00 AM			Permit Number 25914	5989547.06003251	2098884.34921412	37.742534500381105	-122.478788583135	(37.7425345003811, -122.478788583135)
131175	131175	218283	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	2x Sloat Blvd	8	Median : Yard 3	Tree 1	DPW 2			10			5990775.7158	2095986.69925	37.7346495609245	-122.474328895956	(37.7346495609245, -122.474328895956)
147460	147460	217803	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	2x Sloat Blvd	3	Median : Yard 3	Tree 1	DPW 2			34			5991018.47185	2095992.29774	37.734678993934494	-122.473490022742	(37.7346789939345, -122.473490022742)
185691	185691	217802	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	2x Sloat Blvd	2	Median : Yard 3	Tree 1	DPW 2			15			5991046.80022	2095992.48375	37.734681145124505	-122.47339209648001	(37.7346811451245, -122.47339209648)
88646	88646	69470	Permitted Site 1	Eucalyptus Spp :: Eucalyptus 40	1570 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/16/1994 12:00:00 AM			Permit Number 33586	5991155.36555461	2104799.07062441	37.75886803765071	-122.47365896033001	(37.7588680376507, -122.47365896033)
99337	99337	29918	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	810 Junipero Serra Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14			5991252.04535388	2092080.81829703	37.7239525748811	-122.472397431071	(37.7239525748811, -122.472397431071)

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