Street_Tree_List

Data source: data.sfgov.org

264 rows where PlotSize = "Width 10ft" and qSiteInfo = 3 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: qSpecies, SiteOrder

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude ▼	Longitude	Location
131420	131420	194026	DPW Maintained 3	Morus alba :: White Mulberry 112	1100x Bay Shore Blvd	7	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6011390.96705	2093942.9768299998	37.730210708757504	-122.40291089314199	(37.7302107087575, -122.402910893142)
38839	38839	194025	DPW Maintained 3	Morus alba :: White Mulberry 112	1100x Bay Shore Blvd	6	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6011395.816869999	2093961.4424599998	37.730261682333605	-122.402895424807	(37.7302616823336, -122.402895424807)
150276	150276	194024	DPW Maintained 3	Morus alba :: White Mulberry 112	1100x Bay Shore Blvd	5	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6011380.0136	2093972.7166799998	37.7302917565413	-122.4029508518	(37.7302917565413, -122.4029508518)
38678	38678	194023	DPW Maintained 3	Morus alba :: White Mulberry 112	1100x Bay Shore Blvd	4	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6011366.79301	2093982.63877	37.730318262277606	-122.402997255042	(37.7303182622776, -122.402997255042)
76907	76907	180414	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1104x Alemany Blvd	4	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003758.53299	2094425.58203	37.73110669070989	-122.42933162228	(37.7311066907099, -122.42933162228)
180303	180303	180413	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1104x Alemany Blvd	3	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003786.93346	2094435.4492400002	37.731135391684	-122.42923414026001	(37.731135391684, -122.42923414026)
183887	183887	180412	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1104x Alemany Blvd	2	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003814.30975	2094445.54262	37.7311646556118	-122.42914021505501	(37.7311646556118, -122.429140215055)
31521	31521	175079	DPW Maintained 3	Acacia stenophylla :: Shoestring Acacia 109	1104x Alemany Blvd	1	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003837.73065	2094453.4628599999	37.7311877286109	-122.42905980937599	(37.7311877286109, -122.429059809376)
135595	135595	248774	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	1	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6003001.138169999	2095064.3103599998	37.7328175852443	-122.43199565878	(37.7328175852443, -122.43199565878)
63738	63738	248650	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2x Lyell St	4	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6002998.47059	2095072.4374099998	37.732839749044	-122.432005461406	(37.732839749044, -122.432005461406)
53230	53230	248775	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	2	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6002997.286669999	2095073.79392	37.732843406592295	-122.432009651347	(37.7328434065923, -122.432009651347)
188426	188426	248776	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	3	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6002998.16884	2095083.8511700002	37.73287107152721	-122.43200731937999	(37.7328710715272, -122.43200731938)
163293	163293	248777	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	4	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6002988.77776	2095086.3960799999	37.7328775268597	-122.43203996838699	(37.7328775268597, -122.432039968387)
152002	152002	212105	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			27	Width 10ft		5993074.71475	2095363.2347400002	37.7330706059279	-122.466335248575	(37.7330706059279, -122.466335248575)
188895	188895	212106	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	4	Median : Yard 3	Tree 1	DPW 2			33	Width 10ft		5993007.603759999	2095365.5409099997	37.733073065562	-122.466567434662	(37.733073065562, -122.466567434662)
157513	157513	212104	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			30	Width 10ft		5993129.9763400005	2095367.74637	37.733086182185	-122.46614452395201	(37.733086182185, -122.466144523952)
70498	70498	212107	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1701x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			29	Width 10ft		5992822.82885	2095375.69454	37.7330902803915	-122.46720698303601	(37.7330902803915, -122.467206983036)
70013	70013	212108	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1701x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			27	Width 10ft		5992762.96057	2095380.2374200001	37.7330992978931	-122.46741429204201	(37.7330992978931, -122.467414292042)
160424	160424	212109	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1701x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			33	Width 10ft		5992703.672809999	2095383.87275	37.7331058566417	-122.467619528126	(37.7331058566417, -122.467619528126)
71118	71118	212103	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			32	Width 10ft		5993196.79522	2095380.0761799999	37.7331238916354	-122.46591441082899	(37.7331238916354, -122.465914410829)
68230	68230	212110	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1802x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		5992575.24541	2095393.14196	37.733123891637504	-122.468064206012	(37.7331238916375, -122.468064206012)
29486	29486	212111	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1802x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			24	Width 10ft		5992507.56631	2095396.9538900002	37.7331304494932	-122.46829846591801	(37.7331304494932, -122.468298465918)
66298	66298	212112	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1802x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			29	Width 10ft		5992444.9445	2095398.86833	37.7331320889801	-122.468515103605	(37.7331320889801, -122.468515103605)
156264	156264	212113	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1902x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		5992332.7127	2095408.39507	37.7331517634298	-122.46890380855899	(37.7331517634298, -122.468903808559)
26820	26820	212114	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1902x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			36	Width 10ft		5992265.63325	2095412.1953200002	37.7331583221951	-122.46913599464399	(37.7331583221951, -122.469135994644)
182257	182257	212115	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1902x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		5992194.67664	2095416.97281	37.7331673397011	-122.46938165614401	(37.7331673397011, -122.469381656144)
185624	185624	212116	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		5992083.71687	2095423.23256	37.7331781144806	-122.469765726035	(37.7331781144806, -122.469765726035)
157149	157149	212117	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		5992028.07396	2095428.94715	37.7331905889564	-122.469958512768	(37.7331905889564, -122.469958512768)
159138	159138	212118	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			34	Width 10ft		5991962.73959	2095431.83723	37.733194747433295	-122.470184599654	(37.7331947474333, -122.470184599654)
136852	136852	212119	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2101x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			30	Width 10ft		5991843.73604	2095437.8769099999	37.7332044502098	-122.47059646305	(37.7332044502098, -122.47059646305)
75936	75936	212120	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2101x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			35	Width 10ft		5991781.48453	2095442.7217400002	37.7332141530016	-122.47081203417	(37.7332141530016, -122.47081203417)
42114	42114	212121	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2101x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			44	Width 10ft		5991706.53339	2095446.31972	37.7332196973367	-122.47107142020398	(37.7332196973367, -122.471071420204)
23395	23395	208305	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	600x Bosworth St	6	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6002233.89157	2095386.08451	37.7336575763338	-122.43467122191299	(37.7336575763338, -122.434671221913)
83067	83067	208306	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	600x Bosworth St	7	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6002214.21615	2095390.4279	37.733668385273205	-122.434739555986	(37.7336683852732, -122.434739555986)
44978	44978	211007	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	600x Bosworth St	8	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		6002197.80666	2095393.39137	37.7336755906519	-122.43479650017001	(37.7336755906519, -122.43479650017)
73883	73883	208307	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	700x Bosworth St	1	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6002108.77199	2095420.81947	37.7337458465985	-122.435106279748	(37.7337458465985, -122.435106279748)
33946	33946	211008	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	700x Bosworth St	2	Median : Yard 3	Tree 1	DPW 2			33	Width 10ft		6002060.330030001	2095430.49234	37.7337696552405	-122.435274449372	(37.7337696552405, -122.435274449372)
59293	59293	209131	DPW Maintained 3	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	900x Bosworth St	17	Median : Yard 3	Tree 1	DPW 2			28	Width 10ft		6001087.056530001	2095697.8346	37.734448396084396	-122.43865848761699	(37.7344483960844, -122.438658487617)
33183	33183	209132	DPW Maintained 3	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	900x Bosworth St	18	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6001073.50305	2095703.1639599998	37.7344622582302	-122.438705728106	(37.7344622582302, -122.438705728106)
135614	135614	228079	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	200x College Ave	2	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6005184.54917	2095907.6304	37.73525669503871	-122.4245070122	(37.7352566950387, -122.4245070122)
170554	170554	228078	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	200x College Ave	1	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6005173.9664	2095916.21021	37.7352796556316	-122.424544210856	(37.7352796556316, -122.424544210856)
69875	69875	244858	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	431x Precita Ave	3	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6009361.35634	2100204.6117700003	37.747290259852	-122.41036950684601	(37.747290259852, -122.410369506846)
68157	68157	231583	DPW Maintained 3	Maytenus boaria :: Mayten 22	431x Precita Ave	4	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6009377.24569	2100204.6551900003	37.7472912697843	-122.410314565485	(37.7472912697843, -122.410314565485)
75281	75281	231584	DPW Maintained 3	Maytenus boaria :: Mayten 22	431x Precita Ave	5	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6009387.39069	2100212.91077	37.7473145064694	-122.410280067473	(37.7473145064694, -122.410280067473)
31857	31857	231585	DPW Maintained 3	Maytenus boaria :: Mayten 22	431x Precita Ave	6	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6009398.516009999	2100214.89152	37.747320568797896	-122.41024173659201	(37.7473205687979, -122.410241736592)
135572	135572	221334	DPW Maintained 3	Callistemon viminalis :: Weeping Bottlebrush 20	90x Peralta Ave	1	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6010340.53234	2100283.1811900004	37.747560836176	-122.406989109071	(37.747560836176, -122.406989109071)
59692	59692	234516	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	90x Peralta Ave	2	Median : Yard 3	Tree 1	DPW 2			15	Width 10ft		6010366.95066	2100295.32111	37.7475956480377	-122.406898611185	(37.7475956480377, -122.406898611185)
183989	183989	223863	DPW Maintained 3	Cussonia spicata :: Cabbage tree 325	3700x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6005802.979169999	2100534.20381	37.7479951268836	-122.422697548374	(37.7479951268836, -122.422697548374)
136109	136109	223862	DPW Maintained 3	Cussonia spicata :: Cabbage tree 325	3700x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6005812.2615	2100535.54919	37.7479993446903	-122.42266554600401	(37.7479993446903, -122.422665546004)
68185	68185	221319	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	19	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6005944.18408	2100538.31841	37.7480143903463	-122.42220955912599	(37.7480143903463, -122.422209559126)
155732	155732	221318	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	18	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6005963.52235	2100538.85266	37.7480169480361	-122.42214272601002	(37.7480169480361, -122.42214272601)
24175	24175	221317	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	17	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6005983.198059999	2100540.62132	37.74802291412821	-122.422074813715	(37.7480229141282, -122.422074813715)
61802	61802	222823	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	16	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6006010.36461	2100542.85713	37.7480305853438	-122.42198103152	(37.7480305853438, -122.42198103152)
157582	157582	222822	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	15	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006028.774680001	2100543.7206599996	37.7480339946844	-122.42191743145399	(37.7480339946844, -122.421917431454)
165397	165397	222821	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	14	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006053.42295	2100544.76657	37.748038256564705	-122.421832272848	(37.7480382565647, -122.421832272848)
171532	171532	222820	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	13	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6006079.97911	2100547.63598	37.748047632887705	-122.421740646313	(37.7480476328877, -122.421740646313)
178654	178654	222819	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	12	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006102.45265	2100549.0367799997	37.7480527464562	-122.42166303303001	(37.7480527464562, -122.42166303303)
30314	30314	222818	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	11	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6006120.27144	2100551.46467	37.7480604176603	-122.42160158864701	(37.7480604176603, -122.421601588647)
158171	158171	222817	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	10	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6006145.22502	2100552.1939	37.7480638269962	-122.421515351753	(37.7480638269962, -122.421515351753)
176447	176447	221316	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6006164.906830001	2100554.27339	37.748070646539	-122.421447440342	(37.748070646539, -122.421447440342)
53646	53646	221315	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006188.08632	2100559.69525	37.7480868406308	-122.42136767137501	(37.7480868406308, -122.421367671375)
26272	26272	221314	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	7	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006208.09255	2100562.38879	37.7480953644201	-122.421298681694	(37.7480953644201, -122.421298681694)
130302	130302	222816	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	6	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6006226.8204	2100563.5564200003	37.748099626297204	-122.421234004258	(37.7480996262972, -122.421234004258)
48340	48340	222814	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	4	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006266.09505	2100563.37105	37.748101331408	-122.42109818053801	(37.748101331408, -122.421098180538)
153800	153800	222815	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	5	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6006246.77566	2100563.7677	37.7481013314143	-122.42116501457	(37.7481013314143, -122.42116501457)
62517	62517	221313	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	3	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006298.52695	2100563.9468900003	37.7481047407526	-122.42098607287599	(37.7481047407526, -122.420986072876)
52352	52352	221312	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006319.7284699995	2100564.13231	37.748106444967206	-122.420912771811	(37.7481064449672, -122.420912771811)
164068	164068	221311	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006340.93025	2100564.31807	37.7481081500844	-122.42083946986799	(37.7481081500844, -122.420839469868)
178642	178642	221310	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	18	Median : Yard 3	Tree 1	DPW 2			15	Width 10ft		6006690.61046	2100560.2464400004	37.748116673857396	-122.419629996836	(37.7481166738574, -122.419629996836)
62655	62655	221308	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	16	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6006729.87847	2100559.75105	37.7481175255011	-122.41949417401699	(37.7481175255011, -122.419494174017)
164285	164285	221309	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	17	Median : Yard 3	Tree 1	DPW 2			15	Width 10ft		6006710.87077	2100560.14098	37.748117525522105	-122.41955992977199	(37.7481175255221, -122.419559929772)
45519	45519	222813	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	15	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6006748.5872	2100559.98827	37.748119230616105	-122.419429496578	(37.7481192306161, -122.419429496578)
71273	71273	222812	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	14	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6006765.73797	2100560.2571400004	37.748120934852	-122.419370208764	(37.748120934852, -122.419370208764)
186445	186445	222811	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	13	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6006785.0700900005	2100560.48159	37.748122639944704	-122.419303374748	(37.7481226399447, -122.419303374748)
60997	60997	221307	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	12	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6006805.947430001	2100560.05338	37.748122639966795	-122.41923115111099	(37.7481226399668, -122.419231151111)
55805	55805	221306	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	11	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6006829.97888	2100561.42314	37.7481277543884	-122.419148148164	(37.7481277543884, -122.419148148164)
37406	37406	222810	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6006867.8232	2100561.0017	37.7481287283566	-122.41901725364599	(37.7481287283566, -122.419017253646)
177771	177771	221305	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	10	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6006848.39499	2100562.5972700003	37.7481320153776	-122.419084549026	(37.7481320153776, -122.419084549026)
178690	178690	222809	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6006905.75522	2100562.66292	37.748135425630394	-122.418886203547	(37.7481354256304, -122.418886203547)
80208	80208	222808	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	7	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6006921.0363300005	2100562.97022	37.7481371298399	-122.41883338366699	(37.7481371298399, -122.418833383667)
47288	47288	222807	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	6	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6006935.06482	2100562.99304	37.7481379823795	-122.41878487513901	(37.7481379823795, -122.418784875139)
119114	119114	222806	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	5	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6006951.5861	2100562.96476	37.748138834942296	-122.418727742984	(37.7481388349423, -122.418727742984)
75185	75185	222805	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	4	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6006981.21986	2100563.9092900003	37.7481430968362	-122.41862533719299	(37.7481430968362, -122.418625337193)
174200	174200	221304	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	3	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006999.9222099995	2100563.83599	37.7481439484975	-122.418560659758	(37.7481439484975, -122.418560659758)
133406	133406	221302	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6007028.6086800005	2100564.17932	37.7481465061591	-122.418461487031	(37.7481465061591, -122.418461487031)
32767	32767	221303	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6007015.521380001	2100564.44765	37.7481465061704	-122.4185067616	(37.7481465061704, -122.4185067616)
149219	149219	220706	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	11	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6007309.307569999	2100568.57948	37.748174386036	-122.417491149123	(37.748174386036, -122.417491149123)
67786	67786	220709	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6007353.87086	2100568.68035	37.7481771703365	-122.41733705747	(37.7481771703365, -122.41733705747)
152431	152431	220710	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	10	Median : Yard 3	Tree 1	DPW 2			15	Width 10ft		6007335.71167	2100569.3305200003	37.748177933862	-122.41739989758999	(37.748177933862, -122.41739989759)
151226	151226	222831	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6007377.19749	2100569.29044	37.7481801578885	-122.417256437759	(37.7481801578885, -122.417256437759)
153216	153216	222828	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	5	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6007445.92362	2100568.5836	37.7481820833534	-122.417018734321	(37.7481820833534, -122.417018734321)
155021	155021	222830	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	7	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6007397.542119999	2100569.68358	37.7481823819289	-122.417186114357	(37.7481823819289, -122.417186114357)
167079	167079	222829	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	6	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6007416.24383	2100569.3004099997	37.748182381931294	-122.417121417131	(37.7481823819313, -122.417121417131)
182508	182508	222827	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	4	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6007469.113419999	2100569.02723	37.748184605929204	-122.41693857595399	(37.7481846059292, -122.416938575954)
162339	162339	220708	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	3	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6007490.2712	2100569.40378	37.7481868299661	-122.416865439509	(37.7481868299661, -122.416865439509)
168563	168563	220707	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6007513.03873	2100568.93739	37.7481868299766	-122.416786676871	(37.7481868299766, -122.416786676871)
184455	184455	220705	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6007530.958190001	2100569.16609	37.748188465819794	-122.416724727984	(37.7481884658198, -122.416724727984)
134004	134004	220704	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3250x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6007823.26067	2100571.91799	37.748212457945	-122.415714147211	(37.748212457945, -122.415714147211)
159604	159604	220714	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3250x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6007851.34371	2100572.1206099996	37.748214592933394	-122.415617050982	(37.7482145929334, -122.415617050982)
48674	48674	222834	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3250x Cesar Chavez St	6	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6007896.6136300005	2100571.958	37.7482166910443	-122.415460497013	(37.7482166910443, -122.415460497013)

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