Street_Tree_List

Data source: data.sfgov.org

272 rows where qLegalStatus = 3 and qSpecies = 36 sorted by DBH

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: qSiteInfo, qCaretaker, PlantDate, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▼	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
143072	143072	97216	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	300X Claremont Blvd	3	Back Yard : Cutout 16	Tree 1	DPW for City Agency 10						5993486.0	2098110.3	37.7406370848463	-122.465112792055	(37.7406370848463, -122.465112792055)
7223	7223	10658	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	957 Hayes St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2007 12:00:00 AM	3	3x3		6003278.1745	2110658.3168	37.7756507331964	-122.43215110447599	(37.7756507331964, -122.432151104476)
7523	7523	87408	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	2400X Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2		04/18/2008 12:00:00 AM	3	3x3		6005843.02152	2118712.53051	37.7979106921903	-122.42385149366501	(37.7979106921903, -122.423851493665)
15190	15190	3701	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/12/2000 12:00:00 AM	3	3X3		6016463.92851	2099311.9747200003	37.745234858406	-122.385746898422	(37.745234858406, -122.385746898422)
15631	15631	3715	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/07/1996 12:00:00 AM	3	3X3		6016713.472019999	2099127.09165	37.744741012786896	-122.38487113321699	(37.7447410127869, -122.384871133217)
20112	20112	29963	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	500X Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3x3		5991394.8537099995	2093447.95886	37.7277146673841	-122.47200336878099	(37.7277146673841, -122.472003368781)
37403	37403	11269	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1176X Ingalls St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/03/1990 12:00:00 AM	3	3x3		6017716.362196	2093961.1645628002	37.7306118245585	-122.381044204671	(37.7306118245585, -122.381044204671)
1068	1068	11520	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/01/2017 12:00:00 AM	6	3X3		6018495.90717	2096693.85175	37.738158246093	-122.378538834904	(37.738158246093, -122.378538834904)
16854	16854	11488	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/05/1993 12:00:00 AM	6	4X4		6018872.157000001	2097296.32677	37.7398332567899	-122.377279727371	(37.7398332567899, -122.377279727371)
81124	81124	11506	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
181793	181793	206291	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	500x Junipero Serra Blvd	38	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		5991445.95006	2094262.4550299998	37.7299540269465	-122.471886066612	(37.7299540269465, -122.471886066612)
16927	16927	24534	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	128 Cortland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/11/1996 12:00:00 AM	8	3X3		6006387.02802	2097608.2195099997	37.7399939683457	-122.420470266705	(37.7399939683457, -122.420470266705)
70249	70249	176386	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	10x Mansell St	10	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6011666.66331	2090722.9963200002	37.7213846965192	-122.40173152668501	(37.7213846965192, -122.401731526685)
106493	106493	10804	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1139X Hudson Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			10	3X4		6017540.26401	2094828.3880099999	37.7329833277332	-122.38171330076901	(37.7329833277332, -122.381713300769)
152285	152285	199383	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	400x Cargo Way	6	Median : Yard 3	Tree 1	DPW 2			10			6017000.482369999	2098965.68052	37.7443136810333	-122.38386746011801	(37.7443136810333, -122.383867460118)
3087	3087	19650	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	49	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
5896	5896	19680	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	79	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
5976	5976	19649	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	48	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
6914	6914	19672	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	71	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7002	7002	5239	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1100 Divisadero St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6001407.3425	2112393.2913	37.780308287354295	-122.438747110907	(37.7803082873543, -122.438747110907)
7103	7103	19675	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	74	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7153	7153	19677	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	76	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7446	7446	19683	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	82	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
9546	9546	19678	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	77	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
9875	9875	19651	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	50	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
10475	10475	19661	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	60	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
12748	12748	19671	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	70	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
13431	13431	11527	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6018609.30332	2096848.22468	37.738588373848295	-122.378157476493	(37.7385883738483, -122.378157476493)
13958	13958	3709	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016611.7626	2099202.9223	37.7449436021699	-122.38522811100201	(37.7449436021699, -122.385228111002)
14057	14057	19674	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	73	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
14511	14511	11548	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6018882.85871	2097216.8887400003	37.7396157251883	-122.377237214629	(37.7396157251883, -122.377237214629)
14867	14867	3710	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/01/1990 12:00:00 AM	12	3X3		6016627.8913900005	2099188.4950200003	37.7449048800496	-122.385171335	(37.7449048800496, -122.385171335)
15289	15289	22103	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	3550 03rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015999.32561	2099148.4464	37.7447601233736	-122.387342025935	(37.7447601233736, -122.387342025935)
15456	15456	3728	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	33	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6017021.23739	2098897.913	37.744128752548704	-122.383790975489	(37.7441287525487, -122.383790975489)
15508	15508	11512	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6018400.60741	2096569.54507	37.7378116707805	-122.378859707612	(37.7378116707805, -122.378859707612)
15758	15758	22102	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	3550 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016009.792669999	2099202.98145	37.744910445068896	-122.387309635952	(37.7449104450689, -122.387309635952)
16000	16000	3730	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	35	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6017054.36564	2098871.4939599996	37.744058042453496	-122.383674585207	(37.7440580424535, -122.383674585207)
16120	16120	19653	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	52	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
16584	16584	3719	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016852.7534	2099021.2782	37.744458173299996	-122.38438215201799	(37.7444581733, -122.384382152018)
16643	16643	3702	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/14/1990 12:00:00 AM	12	3X3		6016478.46508	2099300.03196	37.7452028704157	-122.385695800734	(37.7452028704157, -122.385695800734)
16711	16711	11513	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6018414.43418	2096589.52395	37.7378672911411	-122.378813288221	(37.7378672911411, -122.378813288221)
17573	17573	16029	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	146 Monterey Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6001109.44487	2094693.26414	37.7316913516547	-122.43850913181002	(37.7316913516547, -122.43850913181)
19938	19938	16038	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	163 Monterey Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000989.84379	2094618.6563099998	37.7314796917131	-122.43891727113301	(37.7314796917131, -122.438917271133)
21443	21443	4396	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1005 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6004431.4266800005	2103008.65854	37.754711924921295	-122.427616590837	(37.7547119249213, -122.427616590837)
21637	21637	4817	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	51 Cortland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6005995.99863	2097868.77885	37.7406873618291	-122.42184079032499	(37.7406873618291, -122.421840790325)
81374	81374	6123	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	199X Elk St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000815.0314327	2096222.3312360002	37.7358730629277	-122.439636554407	(37.7358730629277, -122.439636554407)
83509	83509	11417	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	721X Mendell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6016212.49704	2096975.20091	37.7388046385926	-122.386453413297	(37.7388046385926, -122.386453413297)
84321	84321	6121	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	199X Elk St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000815.0314327	2096222.3312360002	37.7358730629277	-122.439636554407	(37.7358730629277, -122.439636554407)
92387	92387	6315	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1829 Ellis St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6002129.29202	2112924.84308	37.781808839600394	-122.43628760910102	(37.7818088396004, -122.436287609101)
93664	93664	6117	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	199X Elk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000815.0314327	2096222.3312360002	37.7358730629277	-122.439636554407	(37.7358730629277, -122.439636554407)
94164	94164	11508	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
98031	98031	16026	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	134 Monterey Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6001180.6151014995	2094696.8372785	37.7317052108344	-122.438263338431	(37.7317052108344, -122.438263338431)
103050	103050	6118	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	199X Elk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000815.0314327	2096222.3312360002	37.7358730629277	-122.439636554407	(37.7358730629277, -122.439636554407)
104769	104769	11500	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
107337	107337	10662	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	966 Hayes St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6003229.58025	2110778.15442	37.7759770223646	-122.43232776456199	(37.7759770223646, -122.432327764562)
115125	115125	22101	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	3550 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015976.463219999	2099134.576	37.744720771915496	-122.38742011299999	(37.7447207719155, -122.387420113)
118199	118199	16470	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	9X Newhall St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6018697.204870099	2097076.1109207	37.73921894851821	-122.37786936428301	(37.7392189485182, -122.377869364283)
118292	118292	11478	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	10X Jennings St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6012892.419875	2089345.335603	37.7176702433836	-122.397397833393	(37.7176702433836, -122.397397833393)
121890	121890	11558	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	830X Mendell St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015923.7081699995	2096663.9429799998	37.7379339970425	-122.387430211254	(37.7379339970425, -122.387430211254)
123070	123070	11559	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	830X Mendell St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015912.14045	2096650.33898	37.737896002535294	-122.387469258127	(37.7378960025353, -122.387469258127)
123191	123191	11510	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
123575	123575	11966	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1009X Mendell St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6015728.77645	2096327.58352	37.736999624078	-122.38808072579599	(37.736999624078, -122.388080725796)
124037	124037	10826	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1139X Hudson Ave	33	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/29/1990 12:00:00 AM	12	3X4		6017834.53501	2094620.0550099998	37.732427530713004	-122.380681442077	(37.732427530713, -122.380681442077)
129014	129014	11507	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
138869	138869	11509	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
144147	144147	11973	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1020X Mendell St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015669.55392	2096331.84807	37.7370080523218	-122.388285783946	(37.7370080523218, -122.388285783946)
145856	145856	6120	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	199X Elk St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6000815.0314327	2096222.3312360002	37.7358730629277	-122.439636554407	(37.7358730629277, -122.439636554407)
792	792	199372	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	2 Newhall St	2	: 4	Tree 1	DPW 2		11/12/2014 12:00:00 AM	15	Width 3ft	Permit Number 774049	6018530.30847	2097200.55685	37.7395514542225	-122.37845506126499	(37.7395514542225, -122.378455061265)
162071	162071	176385	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	10x Mansell St	9	Median : Cutout 11	Tree 1	DPW 2			15	Width 0ft		6011675.69162	2090725.79104	37.7213928740681	-122.401700514484	(37.7213928740681, -122.401700514484)
2569	2569	139637	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1780 Turk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	Width 0ft		6001520.6292	2112190.4921	37.7797578963919	-122.438340667374	(37.7797578963919, -122.438340667374)
23051	23051	10656	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	940 Hayes St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	3X3		6003283.9904	2110703.7361	37.7757757730917	-122.432134230107	(37.7757757730917, -122.432134230107)
3849	3849	10659	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	957 Hayes St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	5x5		6003302.5458	2110662.7479	37.775664281642	-122.43206711469601	(37.775664281642, -122.432067114696)
4862	4862	19656	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	55	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60ST
5348	5348	26872	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	969 Hayes St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003227.2163	2110650.5623	37.7756265519671	-122.432326827371	(37.7756265519671, -122.432326827371)
6238	6238	8189	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1279 Fulton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6001660.1742	2111123.4233	37.7768359307235	-122.437781474603	(37.7768359307235, -122.437781474603)
6636	6636	2588	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1710 Bush St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/12/1999 12:00:00 AM	18	3		6005206.687000001	2115142.0135	37.788071009916	-122.42579911500499	(37.788071009916, -122.425799115005)
6681	6681	10654	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	930 Hayes St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6003365.9666	2110715.3678	37.7758123582585	-122.431851484644	(37.7758123582585, -122.431851484644)
8867	8867	10653	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	930 Hayes St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6003401.4158	2110719.799	37.775826534714106	-122.43172917338	(37.7758265347141, -122.43172917338)
13473	13473	11540	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018782.49291	2097080.98118	37.7392370206652	-122.37757481115	(37.7392370206652, -122.37757481115)
13507	13507	11536	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018721.15121	2096997.58655	37.739004655647	-122.377781119206	(37.739004655647, -122.377781119206)
13546	13546	11531	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018661.768080001	2096921.7146599998	37.7387930541475	-122.37798117610501	(37.7387930541475, -122.377981176105)
13576	13576	3696	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6016376.57655	2099377.09307	37.7454088259626	-122.386053488085	(37.7454088259626, -122.386053488085)
13610	13610	11963	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1009X Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6015687.60896	2096283.0567700001	37.736875081728705	-122.38821995489599	(37.7368750817287, -122.388219954896)
13810	13810	11546	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	36	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018856.19666	2097185.73418	37.7395287121888	-122.37732724037701	(37.7395287121888, -122.377327240377)
13853	13853	11518	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018467.96004	2096661.77747	37.7380686358665	-122.37863323672899	(37.7380686358665, -122.378633236729)
13907	13907	3714	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6016696.4691699995	2099138.87958	37.744772439592204	-122.384930747455	(37.7447724395922, -122.384930747455)
13998	13998	11516	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018445.80461	2096632.24283	37.737986318204605	-122.378707789643	(37.7379863182046, -122.378707789643)
14283	14283	11524	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018572.85172	2096797.82035	37.7384479645089	-122.378280011831	(37.7384479645089, -122.378280011831)
14535	14535	3713	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6016679.4743	2099151.07612	37.7448049887681	-122.384990362612	(37.7448049887681, -122.384990362612)
14593	14593	3718	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6016837.584419999	2099032.41565	37.7444879156766	-122.384435379316	(37.7444879156766, -122.384435379316)
14596	14596	3733	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017103.99643	2098828.8007400003	37.743943558756705	-122.38349999984501	(37.7439435587567, -122.383499999845)
14617	14617	11525	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018584.76615	2096814.86638	37.7384954262103	-122.37824000008499	(37.7384954262103, -122.378240000085)
14633	14633	11522	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018545.03968	2096763.4476400001	37.738352050906	-122.37837378772801	(37.738352050906, -122.378373787728)
14692	14692	3717	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6016818.97287	2099045.87092	37.7445238319196	-122.384500671891	(37.7445238319196, -122.384500671891)
14711	14711	11538	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018744.95776	2097030.5986900001	37.7390966122121	-122.377701096637	(37.7390966122121, -122.377701096637)
14717	14717	3720	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6016885.74999	2098998.54038	37.7443975643918	-122.38426647223999	(37.7443975643918, -122.38426647224)
14729	14729	19657	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	56	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60ST
14775	14775	11542	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	32	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018808.16459	2097116.8368799998	37.739336887696396	-122.377488536484	(37.7393368876964, -122.377488536484)
14940	14940	26805	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1491 McKinnon Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6015969.8239	2095448.3954	37.734598903014295	-122.38718600253901	(37.7345989030143, -122.387186002539)
14990	14990	3727	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	401X Cargo Way	32	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017002.99503	2098909.3169299997	37.7441590569979	-122.383854848043	(37.7441590569979, -122.383854848043)

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