Street_Tree_List

Data source: data.sfgov.org

422 rows where SiteOrder = 2 and qSpecies = 46 sorted by Latitude

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: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude ▼	Longitude	Location
13945	13945	46285	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/31/2002 12:00:00 AM			Permit Number 44564
85950	85950	1325	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	4051X Alemany Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	3X3		5991764.76245	2086963.37686	37.709930989883496	-122.47025258193399	(37.7099309898835, -122.470252581934)
78358	78358	1208	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3141 Alemany Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			25	3x3		5995992.87885	2086942.4061599998	37.7101169521706	-122.455637985173	(37.7101169521706, -122.455637985173)
97919	97919	11876	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	1501X Junipero Serra Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	PUC 13			12	3X3		5991566.1252788	2087212.7603742	37.7106042506249	-122.470957258061	(37.7106042506249, -122.470957258061)
150445	150445	180561	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1134 Naples St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 8ft		6001348.51244	2087850.78247	37.712917038962495	-122.437192888562	(37.7129170389625, -122.437192888562)
137877	137877	180559	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	192 Dublin St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 5ft		6004156.4754099995	2089333.3612	37.717147098249605	-122.427593206665	(37.7171470982496, -122.427593206665)
96603	96603	17627	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1135 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/27/2005 12:00:00 AM	3	3X3		6004380.712681401	2089954.6929998002	37.718865821274	-122.42686234984801	(37.718865821274, -122.426862349848)
124040	124040	17622	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	1100 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			40	3X3		6004279.363726401	2089959.3319014	37.7188728276872	-122.427213003456	(37.7188728276872, -122.427213003456)
11325	11325	17624	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1101 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3X3		6004341.89656	2089971.87372	37.7189108009657	-122.426997744874	(37.7189108009657, -122.426997744874)
65179	65179	180513	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1027 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6004235.638830001	2090036.93621	37.719083439333204	-122.427369668478	(37.7190834393332, -122.427369668478)
11239	11239	17609	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	1000X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			40	3X3		6004106.27078	2090068.65464	37.7191632136975	-122.42781910286999	(37.7191632136975, -122.42781910287)
117397	117397	17619	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1049X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3x3		6004182.578886599	2090079.2106526	37.7191965146646	-122.427556086461	(37.7191965146646, -122.427556086461)
173144	173144	180516	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1023 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6004155.91588	2090090.6053799998	37.7192262939354	-122.427649061763	(37.7192262939354, -122.427649061763)
142590	142590	17612	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	1001X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6004077.225620099	2090145.4202003002	37.7193723519994	-122.427924968089	(37.7193723519994, -122.427924968089)
174369	174369	180519	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	919 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 5ft		6003897.75198	2090254.30542	37.719661171900796	-122.42855309895701	(37.7196611719008, -122.428553098957)
109093	109093	17600	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	901X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	3x3		6003845.6513541	2090290.9535450002	37.719758851010496	-122.42873580329399	(37.7197588510105, -122.428735803294)
12769	12769	17578	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	801X Persia Ave	2	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			18	3x3		6003799.63122	2090323.6743700001	37.7198460905006	-122.428897210135	(37.7198460905006, -122.428897210135)
135438	135438	180544	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	790 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	Width 3ft		6003493.29821	2090458.5118900002	37.72019898087729	-122.429965709077	(37.7201989808773, -122.429965709077)
74127	74127	180522	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	703 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6003548.0155	2090475.44462	37.7202485730803	-122.42977777681699	(37.7202485730803, -122.429777776817)
11718	11718	17568	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	700X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	3x3		6003419.6169300005	2090505.6702299998	37.720324294201	-122.430223763218	(37.720324294201, -122.430223763218)
96131	96131	17570	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	749X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3x3		6003493.5133628	2090512.2555079	37.720346561187796	-122.42996879704799	(37.7203465611878, -122.429968797048)
36663	36663	180526	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	701 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6003462.66428	2090526.46403	37.7203838275255	-122.43007644527701	(37.7203838275255, -122.430076445277)
105421	105421	17564	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	701X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	4.5x8		6003386.5742173	2090579.4616613	37.7205250375642	-122.430343243034	(37.7205250375642, -122.430343243034)
11358	11358	17550	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	600 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	3x3		6003170.84982	2090661.1447	37.7207370992233	-122.431094760237	(37.7207370992233, -122.431094760237)
5180	5180	17545	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	543 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			50	3X3		6003118.2023599995	2090743.3942599997	37.7209599548222	-122.431282614218	(37.7209599548222, -122.431282614218)
102436	102436	17547	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	548X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			35	3X3		6003010.146575901	2090756.9744765	37.72099111878529	-122.431657099656	(37.7209911187853, -122.431657099656)
11249	11249	17536	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	501X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3x3		6003012.06568	2090814.03767	37.72114791043521	-122.431654537837	(37.7211479104352, -122.431654537837)
182674	182674	180529	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	403 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 2ft		6002841.07955	2090920.68428	37.7214310448921	-122.432253199447	(37.7214310448921, -122.432253199447)
138568	138568	17533	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	445X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3X3		6002799.2909021	2090948.5412154999	37.7215051643266	-122.432399639747	(37.7215051643266, -122.432399639747)
92145	92145	13322	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	435X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3X3		6002777.3722738	2090962.3160143998	37.72154174394979	-122.432476389775	(37.7215417439498, -122.432476389775)
165946	165946	180532	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	401 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		6002770.13876	2090966.12434	37.721551790572704	-122.432501665928	(37.7215517905727, -122.432501665928)
139825	139825	122420	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2200 San Jose Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	MTA 6				3x3		5998886.0	2091075.0	37.7216297132481	-122.44593585753599	(37.7216297132481, -122.445935857536)
177758	177758	180558	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	391 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6002652.4584800005	2091031.88145	37.7217256708875	-122.432913149844	(37.7217256708875, -122.432913149844)
146259	146259	17527	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	349X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	3x3		6002621.9363	2091050.61782	37.7217753855301	-122.43301999486201	(37.7217753855301, -122.433019994862)
11871	11871	17518	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002537.724219999	2091058.53445	37.72179234573429	-122.433311659211	(37.7217923457343, -122.433311659211)
13173	13173	17514	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	245X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002400.99383	2091189.1997099998	37.7221433654964	-122.433793634664	(37.7221433654964, -122.433793634664)
176925	176925	180548	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	200 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6002299.71139	2091209.35662	37.722192964028295	-122.434145183247	(37.7221929640283, -122.434145183247)
141190	141190	17484	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	220X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3X3		6002262.892318901	2091226.5881509997	37.7222381881928	-122.434273689054	(37.7222381881928, -122.434273689054)
169145	169145	180554	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	201 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002324.53042	2091240.40597	37.722279627184	-122.434061608377	(37.722279627184, -122.434061608377)
11596	11596	17497	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	2X2		6002079.41309	2091392.13948	37.7226823390961	-122.43491976573401	(37.7226823390961, -122.434919765734)
87102	87102	17494	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	98X Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	3X3		6001936.09269	2091434.7408900002	37.722791174441106	-122.43541823832199	(37.7227911744411, -122.435418238322)
28496	28496	180552	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	90 Persia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6001906.70426	2091457.0894099998	37.722850869347205	-122.435521425698	(37.7228508693472, -122.435521425698)
152982	152982	198514	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1601 Bay Shore Blvd	2	: 4	Tree 1	Private 1			6	Width 3ft		6012038.03347	2091375.16372	37.723196132582395	-122.400493582929	(37.7231961325824, -122.400493582929)
144247	144247	113083	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	501x BURROWS ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6009864.0	2093047.0	37.7276651627155	-122.408126678641	(37.7276651627155, -122.408126678641)
162881	162881	180573	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	515 Burrows St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6009834.242740001	2093058.41578	37.7276948418209	-122.408230355163	(37.7276948418209, -122.408230355163)
153607	153607	201907	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1751 Yosemite Ave	2	: 4	Tree 1	Private 1			5	Width 3ft		6013751.60826	2093257.56774	37.7284602485269	-122.394701804167	(37.7284602485269, -122.394701804167)
59286	59286	46632	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	1478 Underwood Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/12/2002 12:00:00 AM	9	3x3	Permit Number 44753	6015248.4747	2093270.3779	37.728578532365496	-122.389527911332	(37.7285785323655, -122.389527911332)
114136	114136	107048	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1478 UNDERWOOD AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6015262.9	2093276.2	37.7285953185109	-122.389478448264	(37.7285953185109, -122.389478448264)
102460	102460	11630	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	400X Junipero Serra Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	4x4		5991380.578	2094219.03	37.7298310098579	-122.47210889946501	(37.7298310098579, -122.472108899465)
150723	150723	215523	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	80 Northwood Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5995460.486769999	2094242.81923	37.7301315873058	-122.458006001202	(37.7301315873058, -122.458006001202)
15899	15899	22327	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	5155 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6014617.6908	2094280.6281	37.7313174804906	-122.39177919347401	(37.7313174804906, -122.391779193474)
172464	172464	200745	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	5101 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6014683.7532	2094550.1103	37.7320610911002	-122.391569635286	(37.7320610911002, -122.391569635286)
77382	77382	22315	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	5115X 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	3X3		6014716.40109	2094586.27231	37.7321621967642	-122.391459290654	(37.7321621967642, -122.391459290654)
160596	160596	200755	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	5099 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6014751.1238	2094745.6812	37.7326018284177	-122.391350385093	(37.7326018284177, -122.391350385093)
173743	173743	200597	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1300x Newcomb Ave	2	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6016514.3807	2094844.0461	37.732969621897794	-122.38526117126301	(37.7329696218978, -122.385261171263)
111469	111469	16439	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1395 Newcomb Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6016285.996927	2094866.0167389999	37.733017311739104	-122.386052291775	(37.7330173117391, -122.386052291775)
187497	187497	200580	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1330 Newcomb Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6016475.5774	2094870.1567	37.7330391696694	-122.38539714453199	(37.7330391696694, -122.385397144532)
149386	149386	200631	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1354 Newcomb Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6016389.5518	2094874.5522	37.733046479064704	-122.385694866729	(37.7330464790647, -122.385694866729)
166427	166427	200628	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1362 Newcomb Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6016361.9231	2094886.4828	37.7330777092621	-122.385791218603	(37.7330777092621, -122.385791218603)
128748	128748	32533	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	70 Porter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/15/1996 12:00:00 AM			Permit Number 37034	6006985.4956632005	2095516.38069521	37.7342839493681	-122.418252734879	(37.7342839493681, -122.418252734879)
133254	133254	215479	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	85 Santa Ana Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992627.2877	2096233.3886799999	37.7354340044744	-122.467945378584	(37.7354340044744, -122.467945378584)
74578	74578	215514	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	299 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993902.7407599995	2096288.82132	37.7356597801802	-122.463539714991	(37.7356597801802, -122.463539714991)
47189	47189	215569	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	262 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993829.85654	2096316.71457	37.735732168414	-122.46379372579901	(37.735732168414, -122.463793725799)
169344	169344	242599	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	145 Surrey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6002203.4241	2096143.2897299998	37.735734958102604	-122.434830687885	(37.7357349581026, -122.434830687885)
167961	167961	215565	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	250 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993953.18487	2096333.32123	37.7357848722665	-122.46336853982099	(37.7357848722665, -122.463368539821)
135165	135165	215563	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	244 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993985.88408	2096348.3750200002	37.735828090088894	-122.463256578734	(37.7358280900889, -122.463256578734)
170224	170224	215559	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	240 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994067.05947	2096413.8540400001	37.7360125554181	-122.46298067483102	(37.7360125554181, -122.462980674831)
181522	181522	215506	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	255 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994105.35353	2096421.48762	37.7360357210632	-122.46284883151199	(37.7360357210632, -122.462848831512)
185782	185782	215556	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	230 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5994083.61734	2096486.4471099998	37.736212831753896	-122.46292869311701	(37.7362128317539, -122.462928693117)
64525	64525	215554	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	224 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5994072.66196	2096533.8959299999	37.736342483419705	-122.462970011551	(37.7363424834197, -122.462970011551)
31013	31013	198560	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1708 Newcomb Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		6014655.2828	2096153.01044	37.7364607478562	-122.39178010106899	(37.7364607478562, -122.391780101069)
171175	171175	215501	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	225 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994092.6368	2096583.0249700001	37.7364785301452	-122.462904513945	(37.7364785301452, -122.462904513945)
76234	76234	198526	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1700 Newcomb Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 7ft		6014646.0524	2096160.0564599999	37.736479582376	-122.391812507248	(37.736479582376, -122.391812507248)
154868	154868	198522	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1725 Newcomb Ave	2	: 4	Tree 1	Private 1			3	Width 7ft		6014552.77288	2096169.8984700001	37.736501427800896	-122.392135704718	(37.7365014278009, -122.392135704718)
34416	34416	198529	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1722 Newcomb Ave	2	: 4	Tree 1	Private 1			7	Width 7ft		6014569.28946	2096208.9031099998	37.73660944358	-122.392081326305	(37.73660944358, -122.392081326305)
158886	158886	198521	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1737 Newcomb Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 7ft		6014485.10287	2096211.0948599998	37.7366107871579	-122.39237255107099	(37.7366107871579, -122.392372551071)
27525	27525	215551	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	212 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5994048.13405	2096632.6874900002	37.7366123276804	-122.46306197983401	(37.7366123276804, -122.463061979834)
133047	133047	215548	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	200 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5994023.18881	2096729.95205	37.736877955053295	-122.463155280903	(37.7368779550533, -122.463155280903)
153660	153660	198544	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1700 Newcomb Ave	2	: 4	Tree 1	Private 1			4	Width 0ft		6014356.36657	2096313.21091	37.7368840272751	-122.392824793156	(37.7368840272751, -122.392824793156)
58767	58767	198517	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1763 Newcomb Ave	2	: 4	Tree 1	Private 1			5	Width 7ft		6014346.73951	2096322.78373	37.736909777547204	-122.392858747949	(37.7369097775472, -122.392858747949)
135251	135251	198533	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1762 Newcomb Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 7ft		6014374.32844	2096361.3025900002	37.737017074781896	-122.392766053934	(37.7370170747819, -122.392766053934)
69100	69100	242618	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	501 Tompkins Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007915.14616	2096519.82077	37.7370914621948	-122.415109628301	(37.7370914621948, -122.415109628301)
39846	39846	215499	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	95 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993991.18061	2097202.58443	37.738173842158105	-122.463300232714	(37.7381738421581, -122.463300232714)
164646	164646	215541	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	90 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5993946.31928	2097307.1562900003	37.73845838583971	-122.463462926386	(37.7384583858397, -122.463462926386)
120433	120433	215497	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	73 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993976.24019	2097340.1859999998	37.738550801067	-122.46336187137	(37.738550801067, -122.46336187137)
33083	33083	215539	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	70 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5993947.30597	2097439.0269400002	37.73882052663561	-122.463469082233	(37.7388205266356, -122.463469082233)
38137	38137	215538	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	66 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5993953.054409999	2097475.42453	37.7389207965449	-122.46345184763099	(37.7389207965449, -122.463451847631)
157065	157065	215536	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	56 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5993957.82429	2097516.0973	37.739032748648796	-122.463438306534	(37.7390327486488, -122.463438306534)
29756	29756	215492	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	51 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993992.82093	2097521.50716	37.7390496190449	-122.463317697564	(37.7390496190449, -122.463317697564)
178117	178117	215490	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	45 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5994002.63682	2097564.4991099997	37.739168229725706	-122.46328687779601	(37.7391682297257, -122.463286877796)
134609	134609	215533	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	42 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5993973.161169999	2097585.26638	37.7392235533179	-122.463390297139	(37.7392235533179, -122.463390297139)
64606	64606	215486	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	25 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5994053.65956	2097702.19422	37.739549245488796	-122.46312045374901	(37.7395492454888, -122.463120453749)
28099	28099	215484	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	21 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994076.92667	2097749.04597	37.739679229001496	-122.46304340523001	(37.7396792290015, -122.46304340523)
37359	37359	215483	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	15 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994103.6572	2097790.09327	37.7397934743851	-122.46295396047199	(37.7397934743851, -122.462953960472)
71554	71554	215528	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994077.87758	2097807.84952	37.7398407436586	-122.46304438280501	(37.7398407436586, -122.463044382805)
35801	35801	215481	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994138.58821	2097841.54459	37.739936758872204	-122.462836916405	(37.7399367588722, -122.462836916405)
154584	154584	183426	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2419 22nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 0ft		5989497.0526	2098869.9717	37.742492119648205	-122.478960440771	(37.7424921196482, -122.478960440771)
20914	20914	4566	Permitted Site 1	Ulmus parvifolia :: Chinese Elm 46	106X Virginia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/2016 12:00:00 AM	12	3X3		6006479.71302	2098542.22808	37.742563769401606	-122.42021607152901	(37.7425637694016, -122.420216071529)
63727	63727	242438	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	155 Day St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6004951.724880001	2098699.71043	37.742909964332206	-122.425510615143	(37.7429099643322, -122.425510615143)
20550	20550	7661	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3340 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	3x3		6008464.3828	2099163.3028700002	37.7443807335859	-122.413397555653	(37.7443807335859, -122.413397555653)

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