Street_Tree_List

Data source: data.sfgov.org

3,645 rows where qSpecies = 41 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, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
6162	6162	35284	Permitted Site 1	Olea europaea :: Olive Tree 41		3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/17/1998 12:00:00 AM			Permit Number 38758
8735	8735	35281	Permitted Site 1	Olea europaea :: Olive Tree 41		5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/17/1998 12:00:00 AM			Permit Number 38758
11312	11312	35280	Permitted Site 1	Olea europaea :: Olive Tree 41		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/17/1998 12:00:00 AM			Permit Number 38758
13846	13846	35283	Permitted Site 1	Olea europaea :: Olive Tree 41		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/17/1998 12:00:00 AM			Permit Number 38758
16213	16213	35285	Permitted Site 1	Olea europaea :: Olive Tree 41		4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/17/1998 12:00:00 AM			Permit Number 38758
3486	3486	39483	Permitted Site 1	Olea europaea :: Olive Tree 41	0 19th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/1998 12:00:00 AM			Permit Number 40941
6472	6472	39482	Permitted Site 1	Olea europaea :: Olive Tree 41	0 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/1998 12:00:00 AM			Permit Number 40941
16886	16886	39481	Permitted Site 1	Olea europaea :: Olive Tree 41	0 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/1998 12:00:00 AM			Permit Number 40941
29723	29723	177927	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			5988959.91996	2089504.3338	37.716745265857	-122.48013237763	(37.716745265857, -122.48013237763)
61160	61160	177926	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5988935.7978	2089543.3512799998	37.7168509964648	-122.480218609114	(37.7168509964648, -122.480218609114)
61899	61899	177929	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5988839.75679	2089455.3276	37.7166037242653	-122.48054413220699	(37.7166037242653, -122.480544132207)
69696	69696	177930	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5988862.76325	2089422.54432	37.7165150466091	-122.480462212988	(37.7165150466091, -122.480462212988)
70010	70010	177934	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			5988635.61259	2089280.10032	37.7161107276166	-122.481236924063	(37.7161107276166, -122.481236924063)
131812	131812	177931	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5988808.760919999	2089375.86435	37.716383736599205	-122.480645454328	(37.7163837365992, -122.480645454328)
135710	135710	177932	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5988789.67714	2089358.2569799998	37.7163342819918	-122.480710128176	(37.7163342819918, -122.480710128176)
146613	146613	177923	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			5988561.02848	2089156.81478	37.715767879956104	-122.481485695422	(37.7157678799561, -122.481485695422)
148235	148235	177933	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			5988685.34824	2089320.7162799998	37.7162251402652	-122.481067988213	(37.7162251402652, -122.481067988213)
178623	178623	177928	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			5988855.6313	2089468.65527	37.716641241284705	-122.480490237638	(37.7166412412847, -122.480490237638)
67404	67404	177922	Undocumented 2	Olea europaea :: Olive Tree 41	0 Cambon Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		5990625.846609999	2089245.25322	37.7161305522573	-122.474355255986	(37.7161305522573, -122.474355255986)
72659	72659	177921	Undocumented 2	Olea europaea :: Olive Tree 41	0 Cambon Dr	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		5990636.51581	2089256.00468	37.7161606912434	-122.47431916261499	(37.7161606912434, -122.474319162615)
135205	135205	177925	Undocumented 2	Olea europaea :: Olive Tree 41	0 Crespi Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28			5989826.52584	2090074.03315	37.71835983492971	-122.477178590321	(37.7183598349297, -122.477178590321)
184101	184101	177924	Undocumented 2	Olea europaea :: Olive Tree 41	0 Crespi Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5989730.82285	2090240.32639	37.718810881792	-122.47752153959	(37.718810881792, -122.47752153959)
11662	11662	102569	Significant Tree 6	Olea europaea :: Olive Tree 41	0 Diaz Ave	1	Front Yard : Yard 7	Tree 1	Private 1		02/04/2013 12:00:00 AM	2		Permit Number 769785	5990053.95839	2089992.8197400002	37.7181500356804	-122.476386530439	(37.7181500356804, -122.476386530439)
69468	69468	177945	Undocumented 2	Olea europaea :: Olive Tree 41	0 Diaz Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			5990273.00331	2089979.48461	37.718126121809604	-122.47562842082701	(37.7181261218096, -122.475628420827)
183286	183286	177914	Undocumented 2	Olea europaea :: Olive Tree 41	0 Font Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			5989849.3669300005	2089820.74775	37.7176657012986	-122.477081140675	(37.7176657012986, -122.477081140675)
25292	25292	177947	Undocumented 2	Olea europaea :: Olive Tree 41	0 Fuente Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989601.96089	2090504.09134	37.7195276360688	-122.477986231896	(37.7195276360688, -122.477986231896)
32094	32094	177949	Undocumented 2	Olea europaea :: Olive Tree 41	0 Fuente Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989559.04866	2090448.7873900002	37.7193732944219	-122.47813052091101	(37.7193732944219, -122.478130520911)
62097	62097	177948	Undocumented 2	Olea europaea :: Olive Tree 41	0 Fuente Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			5989566.53985	2090511.4530000002	37.7195457933774	-122.47810920609601	(37.7195457933774, -122.478109206096)
123716	123716	177946	Undocumented 2	Olea europaea :: Olive Tree 41	0 Fuente Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			5989610.43005	2090657.9013200002	37.7199504514394	-122.477968195982	(37.7199504514394, -122.477968195982)
27126	27126	177939	Undocumented 2	Olea europaea :: Olive Tree 41	0 Garces Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			5989472.35628	2089125.29207	37.7157342731997	-122.478333458321	(37.7157342731997, -122.478333458321)
51889	51889	177940	Undocumented 2	Olea europaea :: Olive Tree 41	0 Garces Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5989427.62768	2089128.0215200002	37.7157391708956	-122.478488258642	(37.7157391708956, -122.478488258642)
149147	149147	177935	Undocumented 2	Olea europaea :: Olive Tree 41	0 Garces Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5989493.36658	2088932.77712	37.715206894553795	-122.47824676997699	(37.7152068945538, -122.478246769977)
172901	172901	177937	Undocumented 2	Olea europaea :: Olive Tree 41	0 Garces Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			5989487.39768	2088989.39507	37.7153620069155	-122.47827153820299	(37.7153620069155, -122.478271538203)
176036	176036	177936	Undocumented 2	Olea europaea :: Olive Tree 41	0 Garces Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			5989491.06081	2088964.9371200001	37.715295064093205	-122.478257089699	(37.7152950640932, -122.478257089699)
184364	184364	177938	Undocumented 2	Olea europaea :: Olive Tree 41	0 Garces Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			5989480.9198900005	2089050.18574	37.71552854698071	-122.478298370392	(37.7155285469807, -122.478298370392)
29240	29240	177953	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5989426.93386	2089569.48868	37.7169512897353	-122.47852292122101	(37.7169512897353, -122.478522921221)
45156	45156	177964	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5988925.38088	2089008.91353	37.715382958419106	-122.48021552173901	(37.7153829584191, -122.480215521739)
51581	51581	177959	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5989083.70402	2089208.46347	37.71594007136579	-122.47968288565201	(37.7159400713658, -122.479682885652)
58315	58315	177961	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5989118.28423	2089183.8613200001	37.7158745287534	-122.479561562622	(37.7158745287534, -122.479561562622)
64301	64301	177951	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			5989499.70601	2089731.63068	37.7174007160611	-122.478283234789	(37.7174007160611, -122.478283234789)
65659	65659	177955	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			5989333.41698	2089519.4632700002	37.7168085025868	-122.478842503398	(37.7168085025868, -122.478842503398)
67763	67763	177962	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			5989078.7127	2089134.3997099998	37.7157364207672	-122.479694721656	(37.7157364207672, -122.479694721656)
70016	70016	177950	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5989537.87078	2089714.6263700002	37.7173562418745	-122.47815007578801	(37.7173562418745, -122.478150075788)
72252	72252	177954	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			5989416.48515	2089561.1846099999	37.716927882190596	-122.478558430025	(37.7169278821906, -122.478558430025)
100885	100885	177956	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			5989293.3686	2089406.92644	37.7164971788871	-122.47897270272301	(37.7164971788871, -122.478972702723)
130538	130538	177963	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			5988967.059330001	2088996.0962599998	37.7153501871281	-122.48007052675501	(37.7153501871281, -122.480070526755)
146359	146359	177952	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5989400.28977	2089605.00468	37.7170472609007	-122.47861761173901	(37.7170472609007, -122.478617611739)
173704	173704	177960	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			5989129.76935	2089200.6687	37.7159213447791	-122.47952309413701	(37.7159213447791, -122.479523094137)
174720	174720	177957	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989199.228490001	2089287.00846	37.7161624467126	-122.479289326156	(37.7161624467126, -122.479289326156)
175833	175833	177958	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5989169.01716	2089315.78059	37.7162396930894	-122.479395853531	(37.7162396930894, -122.479395853531)
61440	61440	177943	Undocumented 2	Olea europaea :: Olive Tree 41	0 Josepha Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			5989687.380890001	2089641.08495	37.7171629928544	-122.477627922194	(37.7171629928544, -122.477627922194)
61872	61872	177944	Undocumented 2	Olea europaea :: Olive Tree 41	0 Josepha Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			5989684.83075	2089660.83958	37.717217086174	-122.477638179862	(37.717217086174, -122.477638179862)
136472	136472	177941	Undocumented 2	Olea europaea :: Olive Tree 41	0 Josepha Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			5989724.378719999	2089308.8326299998	37.7162528573591	-122.47747576951599	(37.7162528573591, -122.477475769516)
149588	149588	177942	Undocumented 2	Olea europaea :: Olive Tree 41	0 Josepha Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			5989710.75871	2089436.6850700001	37.7166031181237	-122.477532185763	(37.7166031181237, -122.477532185763)
24979	24979	177920	Undocumented 2	Olea europaea :: Olive Tree 41	0 Juan Bautista Cir	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989764.376630001	2089755.55448	37.7174817656499	-122.477370148614	(37.7174817656499, -122.477370148614)
52939	52939	177917	Undocumented 2	Olea europaea :: Olive Tree 41	0 Juan Bautista Cir	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989687.39355	2089722.5642099997	37.717386715401204	-122.477633830752	(37.7173867154012, -122.477633830752)
58703	58703	177916	Undocumented 2	Olea europaea :: Olive Tree 41	0 Juan Bautista Cir	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989586.18825	2089731.4345	37.717405197378504	-122.477984294746	(37.7174051973785, -122.477984294746)
129714	129714	177918	Undocumented 2	Olea europaea :: Olive Tree 41	0 Juan Bautista Cir	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5989709.79651	2089731.70675	37.7174131186015	-122.477557062834	(37.7174131186015, -122.477557062834)
157607	157607	177915	Undocumented 2	Olea europaea :: Olive Tree 41	0 Juan Bautista Cir	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			5989561.17412	2089735.8094900001	37.7174157581119	-122.47807107572399	(37.7174157581119, -122.478071075724)
159324	159324	177919	Undocumented 2	Olea europaea :: Olive Tree 41	0 Juan Bautista Cir	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			5989736.060409999	2089740.7673799999	37.7174395208859	-122.47746694353901	(37.7174395208859, -122.477466943539)
186931	186931	232435	Undocumented 2	Olea europaea :: Olive Tree 41	1 Church St	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 6ft		6004121.39652	2108664.33355	37.7702235143292	-122.42909198802201	(37.7702235143292, -122.429091988022)
135821	135821	233227	Undocumented 2	Olea europaea :: Olive Tree 41	1 Holly Park Cir	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6006435.78425	2096959.1175799998	37.7382144267543	-122.420255629995	(37.7382144267543, -122.420255629995)
58538	58538	210822	Undocumented 2	Olea europaea :: Olive Tree 41	1 Ventura Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994075.12889	2102034.61648	37.7514462212671	-122.463360530485	(37.7514462212671, -122.463360530485)
67850	67850	210823	Undocumented 2	Olea europaea :: Olive Tree 41	1 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994071.60304	2101964.35734	37.7512531044495	-122.46336762522101	(37.7512531044495, -122.463367625221)
128002	128002	107077	Undocumented 2	Olea europaea :: Olive Tree 41	10 BRADY ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	3x4		6006482.0	2109752.0	37.773343330406796	-122.421003898549	(37.7733433304068, -122.421003898549)
31671	31671	232963	Undocumented 2	Olea europaea :: Olive Tree 41	10 Carmel St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 4ft		5998915.09351	2105421.46828	37.761023333779	-122.446867103551	(37.761023333779, -122.446867103551)
45481	45481	232964	Undocumented 2	Olea europaea :: Olive Tree 41	10 Carmel St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 4ft		5998893.42724	2105419.84777	37.7610176464756	-122.446941920852	(37.7610176464756, -122.446941920852)
178742	178742	232962	Undocumented 2	Olea europaea :: Olive Tree 41	10 Carmel St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 4ft		5998932.6102599995	2105423.58947	37.7610301587293	-122.446806673598	(37.7610301587293, -122.446806673598)
185998	185998	232961	Undocumented 2	Olea europaea :: Olive Tree 41	10 Carmel St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		5998954.69213	2105425.20137	37.7610358460469	-122.446730418281	(37.7610358460469, -122.446730418281)
122562	122562	65473	Permitted Site 1	Olea europaea :: Olive Tree 41	10 De Montfort Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/24/1990 12:00:00 AM			Permit Number 29345	5995326.58257059	2091913.57647422	37.7237283530048	-122.45830039747	(37.7237283530048, -122.45830039747)
74805	74805	210756	Undocumented 2	Olea europaea :: Olive Tree 41	10 Judah St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5994500.79193	2106024.87293	37.7624269551699	-122.462177903984	(37.7624269551699, -122.462177903984)
166067	166067	210755	Undocumented 2	Olea europaea :: Olive Tree 41	10 Judah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5994519.49208	2106024.97078	37.762428300536	-122.46211323464199	(37.762428300536, -122.462113234642)
30422	30422	233781	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		6000622.86001	2106032.19557	37.762797654817604	-122.44100451216299	(37.7627976548176, -122.441004512163)
33801	33801	233782	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6000620.83206	2106027.61812	37.762784970763896	-122.441011197703	(37.7627849707639, -122.441011197703)
51108	51108	233783	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		6000623.49703	2106025.6379400003	37.7627796854658	-122.441001838469	(37.7627796854658, -122.441001838469)
60421	60421	233779	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		6000624.58928	2106041.01354	37.762821965281	-122.44099916388001	(37.762821965281, -122.44099916388)
129801	129801	233780	Undocumented 2	Olea europaea :: Olive Tree 41	10 Saturn St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		6000618.75311	2106039.2097	37.7628166799724	-122.44101921967501	(37.7628166799724, -122.441019219675)
57078	57078	232867	Undocumented 2	Olea europaea :: Olive Tree 41	100 Alemany Blvd	28	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6009311.71143	2095856.6182400002	37.735348835078796	-122.410234240737	(37.7353488350788, -122.410234240737)
74856	74856	232866	Undocumented 2	Olea europaea :: Olive Tree 41	100 Alemany Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6009630.05174	2096202.69692	37.736316931874	-122.409158028324	(37.736316931874, -122.409158028324)
78335	78335	47594	Permitted Site 1	Olea europaea :: Olive Tree 41	100 Alemany Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/20/2002 12:00:00 AM			Permit Number 45435	6009710.93340167	2096438.06354235	37.7369677288425	-122.408894986555	(37.7369677288425, -122.408894986555)
79024	79024	47597	Permitted Site 1	Olea europaea :: Olive Tree 41	100 Alemany Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/04/2003 12:00:00 AM			Permit Number 45435	6009710.93340167	2096438.06354235	37.7369677288425	-122.408894986555	(37.7369677288425, -122.408894986555)
103660	103660	47593	Permitted Site 1	Olea europaea :: Olive Tree 41	100 Alemany Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/20/2002 12:00:00 AM			Permit Number 45435	6009710.93340167	2096438.06354235	37.7369677288425	-122.408894986555	(37.7369677288425, -122.408894986555)
139060	139060	47595	Permitted Site 1	Olea europaea :: Olive Tree 41	100 Alemany Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/20/2002 12:00:00 AM			Permit Number 45435	6009710.93340167	2096438.06354235	37.7369677288425	-122.408894986555	(37.7369677288425, -122.408894986555)
29676	29676	194152	Undocumented 2	Olea europaea :: Olive Tree 41	100 Carolina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		6012254.865130001	2106816.35106	37.7656064246163	-122.400828345673	(37.7656064246163, -122.400828345673)
137723	137723	194151	Undocumented 2	Olea europaea :: Olive Tree 41	100 Carolina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		6012252.37464	2106853.87297	37.7657093124668	-122.400839596166	(37.7657093124668, -122.400839596166)
146894	146894	194153	Undocumented 2	Olea europaea :: Olive Tree 41	100 Carolina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		6012257.457909999	2106772.39506	37.765485875897	-122.400816289341	(37.765485875897, -122.400816289341)
177165	177165	194150	Undocumented 2	Olea europaea :: Olive Tree 41	100 Carolina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		6012249.4838	2106891.9100200003	37.765813592442605	-122.400852267621	(37.7658135924426, -122.400852267621)
40108	40108	232434	Undocumented 2	Olea europaea :: Olive Tree 41	100 Church St	1	: 4	Tree 1	Private 1			6	Width 3ft		6004077.27006	2108309.3730900004	37.7692463811546	-122.429219306844	(37.7692463811546, -122.429219306844)
75787	75787	232433	Undocumented 2	Olea europaea :: Olive Tree 41	100 Church St	2	: 4	Tree 1	Private 1			7	Width 3ft		6004078.2597199995	2108290.75217	37.7691953086514	-122.429214555715	(37.7691953086514, -122.429214555715)
99915	99915	113323	Permitted Site 1	Olea europaea :: Olive Tree 41	100 Church St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		12			6004079.74050315	2108375.213269	37.7694273021614	-122.42921545709	(37.7694273021614, -122.42921545709)
123392	123392	113322	Permitted Site 1	Olea europaea :: Olive Tree 41	100 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1					6004079.74050315	2108375.213269	37.7694273021614	-122.42921545709	(37.7694273021614, -122.42921545709)
185707	185707	232432	Undocumented 2	Olea europaea :: Olive Tree 41	100 Church St	3	: 4	Tree 1	Private 1			15	Width 4ft		6004078.65513	2108269.95494	37.7691382268875	-122.429211704867	(37.7691382268875, -122.429211704867)
99111	99111	88512	Permitted Site 1	Olea europaea :: Olive Tree 41	100 Eastwood Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/21/2008 12:00:00 AM		3x3	Permit Number 51445	5995638.0	2093313.0	37.7275887253261	-122.457325078591	(37.7275887253261, -122.457325078591)
104694	104694	88513	Permitted Site 1	Olea europaea :: Olive Tree 41	100 Eastwood Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/21/2008 12:00:00 AM		3x3	Permit Number 51445	5995638.0	2093313.0	37.7275887253261	-122.457325078591	(37.7275887253261, -122.457325078591)
66805	66805	210831	Undocumented 2	Olea europaea :: Olive Tree 41	100 El Verano Way	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5994495.152530001	2094669.90963	37.7312487620154	-122.461374210478	(37.7312487620154, -122.461374210478)
182313	182313	210832	Undocumented 2	Olea europaea :: Olive Tree 41	100 El Verano Way	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 3ft		5994491.87078	2094685.88565	37.731292439379395	-122.461386713728	(37.7312924393794, -122.461386713728)
147033	147033	210600	Undocumented 2	Olea europaea :: Olive Tree 41	100 Hugo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 2ft		5995427.38447	2107071.96	37.765355293446795	-122.459049004307	(37.7653552934468, -122.459049004307)
159616	159616	210601	Undocumented 2	Olea europaea :: Olive Tree 41	100 Hugo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 2ft		5995408.81164	2107071.42488	37.7653527564515	-122.45911320421999	(37.7653527564515, -122.45911320422)
136958	136958	210681	Undocumented 2	Olea europaea :: Olive Tree 41	100 Malta Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3			5999441.24065	2096192.06642	37.735711675549	-122.444384101443	(37.735711675549, -122.444384101443)
37993	37993	210661	Undocumented 2	Olea europaea :: Olive Tree 41	100 Maywood Dr	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		5994208.63776	2095900.82229	37.734612051092704	-122.462453985083	(37.7346120510927, -122.462453985083)

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