Street_Tree_List

Data source: data.sfgov.org

422 rows where SiteOrder = 2 and qSpecies = 46 sorted by qLegalStatus descending

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
3293	3293	253393	Planning Code 138.1 required 4	Ulmus parvifolia :: Chinese Elm 46	115 Steuart St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/30/2017 12:00:00 AM	3	3x3	Permit Number 771767	6014754.163380001	2116767.09226	37.793068003154104	-122.392879995147	(37.7930680031541, -122.392879995147)
10157	10157	173899	Planning Code 138.1 required 4	Ulmus parvifolia :: Chinese Elm 46	1762 12th Ave	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3	Permit Number 779465	5992511.90241	2103608.89481	37.7556785957656	-122.468880856653	(37.7556785957656, -122.468880856653)
107374	107374	103379	Planning Code 138.1 required 4	Ulmus parvifolia :: Chinese Elm 46	2712 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/21/2013 12:00:00 AM	4	3x3	Permit Number 770136	6000520.0	2117210.0	37.793483200790895	-122.44216269001001	(37.7934832007909, -122.44216269001)
127	127	18052	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2840 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6000317.799	2114808.7133	37.7868783690408	-122.442689819484	(37.7868783690408, -122.442689819484)
1187	1187	119794	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2110122.0	6005581.0	47.2699969117914	-138.280716869623	(47.2699969117914, -138.280716869623)
1213	1213	119747	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2109793.0	6005627.0	47.2699510709683	-138.28203408065	(47.2699510709683, -138.28203408065)
1219	1219	119829	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2						2110475.0	6005532.0	47.2700470263222	-138.279303834774	(47.2700470263222, -138.279303834774)
1243	1243	242621	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3274 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	Width 3ft		6008442.97152	2099602.35151	37.745585061615294	-122.413502636934	(37.7455850616153, -122.413502636934)
6069	6069	17933	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2418 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6002186.7609	2115068.0006	37.7876966699691	-122.43624221533301	(37.7876966699691, -122.436242215333)
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)
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)
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)
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)
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)
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)
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)
13679	13679	100568	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	868 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	3x3		6011788.1802	2112369.4793	37.780828003664	-122.40283310111	(37.780828003664, -122.40283310111)
15618	15618	49607	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1245 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/13/2003 12:00:00 AM	3	3x3	Permit Number 46474	6009479.3313	2110073.508	37.7743946188288	-122.41065838012199	(37.7743946188288, -122.410658380122)
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)
16241	16241	91032	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1051X Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/18/2008 12:00:00 AM	3	3x3		6010616.6864	2111159.8673	37.777441210433395	-122.40680061468099	(37.7774412104334, -122.406800614681)
16370	16370	85856	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1530 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/21/2007 12:00:00 AM	3	3x3		6008268.3583	2108979.6799	37.7713232557148	-122.414769948978	(37.7713232557148, -122.414769948978)
16950	16950	25174	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3062 Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			100	3X3		6000130.8652	2105433.23803	37.761125030928895	-122.44266313540199	(37.7611250309289, -122.442663135402)
17173	17173	7598	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3106 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			45	3X3		6008393.64019	2100437.22493	37.7478746680801	-122.41373225995702	(37.7478746680801, -122.413732259957)
19913	19913	7629	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3255 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	3x3		6008486.89529	2099750.51965	37.7459943646489	-122.413361231161	(37.7459943646489, -122.413361231161)
20513	20513	16674	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	244 Noe St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6002862.1511	2106861.28307	37.7652014158426	-122.43331884659099	(37.7652014158426, -122.433318846591)
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)
21218	21218	7609	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3201X Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	3x3		6008465.56489	2100101.76306	37.7469576033137	-122.413459825618	(37.7469576033137, -122.413459825618)
21656	21656	7544	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2872 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	3x3		6008318.08385	2101730.76273	37.751422189596	-122.414085029817	(37.751422189596, -122.414085029817)
21769	21769	16666	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	221 Noe St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/04/2011 12:00:00 AM	3	3x3		6002922.68979	2106990.55693	37.765559804667795	-122.433118695273	(37.7655598046678, -122.433118695273)
25504	25504	244422	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005691.1562	2109690.8797	37.773130897486205	-122.423735193743	(37.7731308974862, -122.423735193743)
26492	26492	242374	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2x McCoppin St	2	Median : Yard 3	Tree 1	DPW 2			5	Width 9ft		6006546.0037	2109148.1970900004	37.771689039651896	-122.42073962714899	(37.7716890396519, -122.420739627149)
52888	52888	244411	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	201x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			1	Width 0ft		6005560.024	2110238.8403	37.7746280615118	-122.424227776164	(37.7746280615118, -122.424227776164)
56950	56950	244345	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	101x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6005607.2268	2109894.3659	37.773684883292105	-122.424039990106	(37.7736848832921, -122.424039990106)
57681	57681	244354	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	300x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		6005594.4313	2110381.2151	37.7750209309426	-122.424118881689	(37.7750209309426, -122.424118881689)
75290	75290	16679	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	248 Noe St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6002873.990875499	2106855.8321643	37.765187120656705	-122.433277506161	(37.7651871206567, -122.433277506161)
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)
85133	85133	104447	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2490X Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2	Rec/Park 7			3x3		6008214.39649	2104163.7525299997	37.7580968032353	-122.41461574816002	(37.7580968032353, -122.41461574816)
85447	85447	14839	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1315X McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2011 12:00:00 AM	5	3x3		6002861.06587	2111639.14836	37.7783201948721	-122.43366409969101	(37.7783201948721, -122.433664099691)
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)
85972	85972	119818	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	302x Octavia St Frontage East	2	Median : Cutout 11	Tree 1	DPW 2						2110484.0	6005595.0	47.27021880585	-138.279315979183	(47.27021880585, -138.279315979183)
87740	87740	18003	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2676 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6001111.9740699995	2114914.60088	37.7872143495752	-122.439949758664	(37.7872143495752, -122.439949758664)
89821	89821	7582	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3000X Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3x3		6008378.51714	2100951.63552	37.7492862752884	-122.41382093686701	(37.7492862752884, -122.413820936867)
90709	90709	7638	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3274 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			22	3X3		6008420.15681	2099616.94183	37.7456238423258	-122.413582558723	(37.7456238423258, -122.413582558723)
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)
93922	93922	119676	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2x Octavia St Frontage East	2	Median : Cutout 11	Tree 1	DPW 2						2109501.0	6005733.0	47.2700833275765	-138.283252028036	(47.2700833275765, -138.283252028036)
95054	95054	7535	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2840 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/10/2011 12:00:00 AM	18	5x5		6008283.0	2101875.0	37.7518162620418	-122.414216558168	(37.7518162620418, -122.414216558168)
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)
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)
97327	97327	20254	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2408X Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6002391.32422	2115095.8714799997	37.787784816749294	-122.43553646124799	(37.7877848167493, -122.435536461248)
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)
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)
102857	102857	23807	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1375X Eddy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6003874.72998	2112813.9385599997	37.7816033410836	-122.430241295334	(37.7816033410836, -122.430241295334)
104156	104156	103744	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2011 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/11/2014 12:00:00 AM	3	3x3		6008128.1	2106710.2	37.7650839125599	-122.415094442696	(37.7650839125599, -122.415094442696)
104484	104484	5323	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	2689X Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6001088.8002445	2114863.0175008997	37.78707139571671	-122.44002623476001	(37.7870713957167, -122.44002623476)
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)
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)
109476	109476	19301	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	100X Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		5995247.10654	2111496.409	37.7774933045144	-122.459993084378	(37.7774933045144, -122.459993084378)
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)
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)
128093	128093	119709	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	102x Octavia St Frontage East	2	Median : Cutout 11	Tree 1	DPW 2						2109802.0	6005691.0	47.2701255040516	-138.282046982267	(47.2701255040516, -138.282046982267)
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)
135988	135988	242371	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	90x McCoppin St	2	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6006102.65154	2109126.4322	37.771604280331005	-122.42227166541001	(37.771604280331, -122.42227166541)
137478	137478	244312	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	301x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005504.7234	2110575.2675	37.7755486863335	-122.424443006762	(37.7755486863335, -122.424443006762)
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)
140858	140858	18525	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3104X Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	6x8		6008391.22062	2100547.0534	37.748176096662604	-122.413748394121	(37.7481760966626, -122.413748394121)
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)
141612	141612	7593	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	3065 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/28/1992 12:00:00 AM	6	3X3		6008718.17	2100791.65733	37.748866079627206	-122.41263509881	(37.7488660796272, -122.41263509881)
144022	144022	14865	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1399 McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/10/2011 12:00:00 AM	3	3x3		6002569.68984	2111577.93891	37.7781355917554	-122.434667698155	(37.7781355917554, -122.434667698155)
144605	144605	119782	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	202x Octavia St Frontage East	2	Median : Cutout 11	Tree 1	DPW 2						2110143.0	6005643.0	47.270172161735	-138.280681481725	(47.270172161735, -138.280681481725)
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)
164702	164702	246548	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	20x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			6	Width 6ft		6005741.17746	2109432.24964	37.772423585213794	-122.423543772638	(37.7724235852138, -122.423543772638)
166774	166774	242781	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	95x McCoppin St	2	Median : Yard 3	Tree 1	DPW 2			4	Width 9ft		6006152.38517	2109124.27435	37.771601160584	-122.42209948031099	(37.771601160584, -122.422099480311)
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)
185473	185473	242779	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	1x McCoppin St	2	Median : Yard 3	Tree 1	DPW 2			4	Width 9ft		6006556.42632	2109149.52189	37.77169326466979	-122.420703668659	(37.7716932646698, -122.420703668659)
186972	186972	244255	DPW Maintained 3	Ulmus parvifolia :: Chinese Elm 46	200x Octavia St	2	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6005643.2766	2110040.2561	37.7740874977816	-122.423925664351	(37.7740874977816, -122.423925664351)
865	865	142552	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	401 FRANCISCO ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		6009334.5084	2121154.0569	37.804811003675105	-122.411942539139	(37.8048110036751, -122.411942539139)
1166	1166	251466	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	129 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6008072.0	2112894.0	37.782060012266896	-122.415726368353	(37.7820600122669, -122.415726368353)
2753	2753	198672	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	193 Russ St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/02/2017 12:00:00 AM	3	Width 4ft		6010593.523440001	2111314.08538	37.777863361242105	-122.406891615375	(37.7778633612421, -122.406891615375)
3378	3378	242510	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2808 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6008305.34942	2102000.42568	37.75216190805129	-122.41414814334	(37.7521619080513, -122.41414814334)
8832	8832	101524	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2326 Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	3x3		6001795.96309	2118760.54126	37.7978132173675	-122.437858876082	(37.7978132173675, -122.437858876082)
10054	10054	173830	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1801 Broderick St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6000494.0	2114864.0	37.7870402148899	-122.442084176412	(37.7870402148899, -122.442084176412)
13721	13721	98856	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	149 09th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	3x3		6008586.80061	2110533.83683	37.7756084919722	-122.413778389761	(37.7756084919722, -122.413778389761)
14834	14834	74054	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	194X Russ St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/10/1998 12:00:00 AM	5	5x5		6010549.99954	2111279.17691	37.7777650752333	-122.407039719318	(37.7777650752333, -122.407039719318)
15420	15420	98859	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	145 09th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3x3		6008542.44899	2110581.95524	37.775738122962295	-122.413935218038	(37.7757381229623, -122.413935218038)
18487	18487	115018	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	4311 17TH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	3x3		6000722.0	2105756.0	37.7620449359843	-122.440641810954	(37.7620449359843, -122.440641810954)
23752	23752	242656	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	502 Diamond St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6001805.42394	2102865.73386	37.75417060141171	-122.436687776224	(37.7541706014117, -122.436687776224)
24472	24472	242424	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	209 Fair Oaks St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6005453.21466	2102408.07888	37.7531206159404	-122.424040259559	(37.7531206159404, -122.424040259559)
25132	25132	242416	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	3652 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6005376.79468	2101978.6432	37.7519371701822	-122.424273995163	(37.7519371701822, -122.424273995163)
25433	25433	137020	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2201 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		6002995.15639	2117477.21245	37.7943576461387	-122.433617572612	(37.7943576461387, -122.433617572612)
26126	26126	121876	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	198 18th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 5ft		5990258.7771	2114125.11195	37.7844228334992	-122.477441359496	(37.7844228334992, -122.477441359496)
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)
28071	28071	198653	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	1670 Owen St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 8ft		6014062.16151	2107274.8882299997	37.7669661078202	-122.39460937273701	(37.7669661078202, -122.394609372737)
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)
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)
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)
30582	30582	137004	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2009 Divisadero St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 5ft		6000928.49211	2115336.76015	37.7883630432624	-122.440614856585	(37.7883630432624, -122.440614856585)
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)
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)
33088	33088	198470	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	704 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6015369.36264	2105816.80106	37.7630351046092	-122.38998606601601	(37.7630351046092, -122.389986066016)
33491	33491	105218	Undocumented 2	Ulmus parvifolia :: Chinese Elm 46	2100 Baker St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/07/2014 12:00:00 AM	2	3x3	Permit Number 772439	5999896.69925	2116138.83336	37.790506517101996	-122.44424234131701	(37.790506517102, -122.444242341317)

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