Street_Tree_List

Data source: data.sfgov.org

8,305 rows where qSpecies = 11 sorted by PlotSize 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

- 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, PlantType, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▲	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
28868	28868	208175	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	1000x Lawton St	3	Median : Yard 3	Tree 1	DPW 2			1	Width 9ft		5991060.8036	2104516.28775	37.758086113802904	-122.473965364836	(37.7580861138029, -122.473965364836)
30071	30071	228915	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	902 Duboce Ave	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 9ft		6002590.6451900005	2108266.76384	37.76904511557	-122.434358412533	(37.76904511557, -122.434358412533)
44924	44924	217728	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	100x Lincoln Way	3	Median : Yard 3	Tree 1	DPW 2			10	Width 9ft		5995225.13962	2107407.04812	37.766263730121004	-122.45977279128901	(37.766263730121, -122.459772791289)
56547	56547	129893	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	400 Cherry St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 9ft		5996283.0892	2114624.04425	37.78614048933979	-122.45663553961701	(37.7861404893398, -122.456635539617)
60935	60935	228916	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	902 Duboce Ave	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 9ft		6002616.34038	2108266.2326700003	37.76904511557179	-122.434269496565	(37.7690451155718, -122.434269496565)
149322	149322	123178	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	755 10th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 9ft		5992851.1981	2110319.1636799998	37.77412281782561	-122.46819559495	(37.7741228178256, -122.46819559495)
163006	163006	228912	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	902 Duboce Ave	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 9ft		6002507.65455	2108261.418	37.769025726184395	-122.43464508941999	(37.7690257261844, -122.43464508942)
167492	167492	228917	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	902 Duboce Ave	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 9ft		6002641.22231	2108269.24913	37.7690548102697	-122.434183647259	(37.7690548102697, -122.434183647259)
26925	26925	208266	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	950x Portola Dr	4	Median : Yard 3	Tree 1	DPW 2			5	Width 8ft		5996189.57852	2098600.11131	37.7421375150253	-122.455800307749	(37.7421375150253, -122.455800307749)
28552	28552	208205	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	50 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5992824.24376	2096416.8452299999	37.7359491019705	-122.467277768674	(37.7359491019705, -122.467277768674)
28602	28602	208207	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	75 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		5992862.536169999	2096286.0615700001	37.7355922132098	-122.46713587181999	(37.7355922132098, -122.46713587182)
30416	30416	200396	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	1002 Harrison St	2	: 4	Tree 1	Private 1			2	Width 8ft		6011347.2117	2110977.9345299997	37.776982513081606	-122.404260664891	(37.7769825130816, -122.404260664891)
33038	33038	217725	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	150x Lincoln Way	2	Median : Yard 3	Tree 1	DPW 2			8	Width 8ft		5995229.4341400005	2107380.1669099997	37.766190168267	-122.45975599017099	(37.766190168267, -122.459755990171)
33840	33840	208206	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	50 San Benito Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5992824.47991	2096396.07045	37.735892073256394	-122.46727544212	(37.7358920732564, -122.46727544212)
37068	37068	208271	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	950x Portola Dr	9	Median : Yard 3	Tree 1	DPW 2			4	Width 8ft		5996099.48169	2098476.66946	37.7417934029459	-122.456102909823	(37.7417934029459, -122.456102909823)
51701	51701	208264	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	950x Portola Dr	1	Median : Yard 3	Tree 1	DPW 2			4	Width 8ft		5996224.40551	2098673.0355	37.742339745598706	-122.45568515764299	(37.7423397455987, -122.455685157643)
55150	55150	208267	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	950x Portola Dr	5	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		5996171.153059999	2098570.8040400003	37.742055987003496	-122.455861898701	(37.7420559870035, -122.455861898701)
61325	61325	200397	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	1002 Harrison St	3	: 4	Tree 1	Private 1			2	Width 8ft		6011329.81075	2110961.2977	37.7769358598445	-122.404319689205	(37.7769358598445, -122.404319689205)
62625	62625	208269	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	950x Portola Dr	7	Median : Yard 3	Tree 1	DPW 2			4	Width 8ft		5996138.33351	2098519.81732	37.741914106361705	-122.455971692433	(37.7419141063617, -122.455971692433)
70576	70576	208265	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	950x Portola Dr	3	Median : Yard 3	Tree 1	DPW 2			3	Width 8ft		5996197.71475	2098618.83624	37.7421893960176	-122.455773528635	(37.7421893960176, -122.455773528635)
133573	133573	208204	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	20 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		5992810.89937	2096694.1655	37.7367097836138	-122.467344063976	(37.7367097836138, -122.467344063976)
135340	135340	208309	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	700x Bosworth St	4	Median : Yard 3	Tree 1	DPW 2			1	Width 8ft		6002006.71588	2095443.8659400002	37.7338033312475	-122.43546076552799	(37.7338033312475, -122.435460765528)
135346	135346	217726	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	150x Lincoln Way	3	Median : Yard 3	Tree 1	DPW 2			9	Width 8ft		5995207.72446	2107378.38914	37.766184038496796	-122.459830950441	(37.7661840384968, -122.459830950441)
157160	157160	201047	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	953 Indiana St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 8ft		6014994.68358	2104372.25303	37.759047900964	-122.39118098533599	(37.759047900964, -122.391180985336)
157890	157890	208203	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	8 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 8ft		5992810.2704300005	2096776.2518200001	37.736935135758294	-122.467352205537	(37.7369351357583, -122.467352205537)
158855	158855	208270	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	950x Portola Dr	8	Median : Yard 3	Tree 1	DPW 2			3	Width 8ft		5996116.90771	2098495.20016	37.7418452839221	-122.456043996142	(37.7418452839221, -122.456043996142)
166299	166299	192724	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	900 Kirkwood Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 8ft		6019533.42418	2093575.80573	37.729653833243	-122.37473558218001	(37.729653833243, -122.37473558218)
174960	174960	200449	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	1150x Tennessee St	2	Median : Yard 3	Tree 1	DPW 2			6	Width 8ft		6015546.9238599995	2103710.0991	37.7572603985698	-122.389224824085	(37.7572603985698, -122.389224824085)
175864	175864	200451	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	1000 Indiana St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			11	Width 8ft		6014956.18254	2103836.3549900004	37.757574303320204	-122.391276680392	(37.7575743033202, -122.391276680392)
175996	175996	208272	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	950x Portola Dr	10	Median : Yard 3	Tree 1	DPW 2			3	Width 8ft		5996077.78984	2098457.8421099996	37.741740462546	-122.456176551714	(37.741740462546, -122.456176551714)
177610	177610	208268	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	950x Portola Dr	6	Median : Yard 3	Tree 1	DPW 2			4	Width 8ft		5996154.347999999	2098544.9334299997	37.741983988173	-122.455918135114	(37.741983988173, -122.455918135114)
182339	182339	208308	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	700x Bosworth St	3	Median : Yard 3	Tree 1	DPW 2			1	Width 8ft		6002022.61443	2095440.5497	37.733795128547	-122.435405562425	(37.733795128547, -122.435405562425)
182544	182544	200450	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	1000 Indiana St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			16	Width 8ft		6014955.45065	2103853.5745099997	37.7576215438129	-122.391280415259	(37.7576215438129, -122.391280415259)
186293	186293	208310	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	700x Bosworth St	5	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		6001987.84098	2095447.80908	37.733813086200705	-122.43552630359301	(37.7338130862007, -122.435526303593)
25385	25385	228907	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	902 Duboce Ave	4	Back Yard : Yard 13	Tree 1	Private 1			11	Width 7ft		6002320.43591	2108252.4902	37.7689905824786	-122.435292027503	(37.7689905824786, -122.435292027503)
24332	24332	246923	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	411 Frederick St	1	: 4	Tree 1	Private 1			15	Width 6ft		5997906.77047	2107481.56832	37.7666221917918	-122.450502958247	(37.7666221917918, -122.450502958247)
27744	27744	208259	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	7 San Lorenzo Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993794.93642	2097790.46819	37.7397767164315	-122.464021405387	(37.7397767164315, -122.464021405387)
28421	28421	208250	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	55 San Lorenzo Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5993729.31252	2097594.20118	37.739234034035704	-122.464234058156	(37.7392340340357, -122.464234058156)
29961	29961	202350	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	395 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 6ft		6014856.64051	2115212.62768	37.78880549442071	-122.392416638537	(37.7888054944207, -122.392416638537)
29990	29990	202485	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	299 Bryant St	41	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 6ft		6015591.97779	2114203.68942	37.7860759863606	-122.389801952302	(37.7860759863606, -122.389801952302)
32649	32649	208251	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	45 San Lorenzo Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5993740.8112	2097632.42389	37.7393396468031	-122.464197075333	(37.7393396468031, -122.464197075333)
35222	35222	208196	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	177 Lomita Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 6ft		5991318.16001	2104277.79248	37.7574461724167	-122.473057932675	(37.7574461724167, -122.473057932675)
35281	35281	202423	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	120 Brannan St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 6ft		6015884.51567	2113657.67287	37.784592966545794	-122.388751709641	(37.7845929665458, -122.388751709641)
35372	35372	208240	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	50 Santa Monica Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5993613.576230001	2097402.8316599997	37.7387019096556	-122.46462032687401	(37.7387019096556, -122.464620326874)
37427	37427	208258	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	7 San Lorenzo Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993787.50997	2097777.8421099996	37.73974162036821	-122.46404616639	(37.7397416203682, -122.46404616639)
38074	38074	208243	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	56 Santa Monica Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5993682.57508	2097363.5104900002	37.738597921062606	-122.464378909273	(37.7385979210626, -122.464378909273)
39421	39421	208201	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	109 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5992876.1385699995	2095935.5062799999	37.73463046111671	-122.467063364902	(37.7346304611167, -122.467063364902)
40496	40496	202428	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	120 Brannan St	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 6ft		6015665.9659	2113447.78913	37.7840045581087	-122.389493161996	(37.7840045581087, -122.389493161996)
43835	43835	208247	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	65 San Lorenzo Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5993716.65368	2097514.87622	37.73901549787529	-122.46427206890301	(37.7390154978753, -122.464272068903)
44663	44663	202354	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	395 Folsom St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6014956.09306	2115317.40015	37.789098697692296	-122.392079873898	(37.7890986976923, -122.392079873898)
45714	45714	208464	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	262 Joost Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 6ft		6000330.97278	2094966.8200299998	37.7323981594491	-122.44122007874701	(37.7323981594491, -122.441220078747)
46335	46335	228902	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	121 Scott St	1	: 4	Tree 1	Private 1			14	Width 6ft		6002319.8368	2108939.8536900003	37.7708778790509	-122.435343274489	(37.7708778790509, -122.435343274489)
46790	46790	202351	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	395 Folsom St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6014874.62958	2115231.05656	37.7888570948136	-122.39235568787501	(37.7888570948136, -122.392355687875)
48058	48058	246924	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	401 Frederick St	1	: 4	Tree 1	Private 1			11	Width 6ft		5997929.70146	2107483.7518599997	37.7666294996706	-122.45042380174101	(37.7666294996706, -122.450423801741)
49261	49261	202483	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	299 Bryant St	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 6ft		6015577.75199	2114193.56391	37.786047395123	-122.38985046265199	(37.786047395123, -122.389850462652)
51675	51675	201070	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	1251 Mariposa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 6ft		6013524.95	2106139.60488	37.763818989687294	-122.39638793316001	(37.7638189896873, -122.39638793316)
52661	52661	208253	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	35 San Lorenzo Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5993753.67803	2097679.19793	37.7394688182264	-122.46415598261001	(37.7394688182264, -122.46415598261)
54608	54608	202349	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	395 Folsom St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 6ft		6014839.41975	2115196.8067900003	37.7887610976021	-122.39247511334601	(37.7887610976021, -122.392475113346)
56300	56300	202486	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	299 Bryant St	42	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 6ft		6015605.55295	2114216.90424	37.7861130240416	-122.389755908832	(37.7861130240416, -122.389755908832)
58194	58194	208238	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	40 Santa Monica Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5993582.08345	2097417.10318	37.738739280082996	-122.464730249215	(37.738739280083, -122.464730249215)
60016	60016	130255	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	2320 Leavenworth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 6ft		6007588.34652	2120300.03904	37.8023679660663	-122.41792475362699	(37.8023679660663, -122.417924753627)
60312	60312	208228	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	2 Santa Monica Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5993354.700230001	2097384.8935700003	37.7386377286364	-122.46551408750601	(37.7386377286364, -122.465514087506)
63767	63767	208257	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	15 San Lorenzo Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993769.83021	2097726.7906299997	37.7396004268184	-122.464103589926	(37.7396004268184, -122.464103589926)
63804	63804	208242	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	56 Santa Monica Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5993655.56825	2097379.1672099996	37.738639353724295	-122.46447342173201	(37.7386393537243, -122.464473421732)
66399	66399	177169	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	30 Morse St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		6001283.266009999	2088090.37173	37.7135711887396	-122.43743554722799	(37.7135711887396, -122.437435547228)
66499	66499	192634	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	2x Garlington Ct	6	Median : Cutout 11	Tree 1	DPW 2			16	Width 6ft		6016723.45145	2094514.5247400003	37.732076385599704	-122.38451540818001	(37.7320763855997, -122.38451540818)
67632	67632	208230	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	18 Santa Monica Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5993408.84143	2097416.3242200003	37.738727151826794	-122.46532917701799	(37.7387271518268, -122.465329177018)
69515	69515	208248	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	65 San Lorenzo Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5993720.3367	2097534.6228	37.739069929337	-122.464260768027	(37.739069929337, -122.464260768027)
69602	69602	208236	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	30 Santa Monica Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993530.698369999	2097432.0885400004	37.738777463500796	-122.464909001172	(37.7387774635008, -122.464909001172)
69814	69814	202426	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	120 Brannan St	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 6ft		6015680.38434	2113465.2753	37.784053370599	-122.38944450058001	(37.784053370599, -122.38944450058)
70163	70163	208304	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	600x Bosworth St	5	Median : Cutout 11	Tree 1	DPW 2			9	Width 6ft		6002256.900219999	2095383.64067	37.7336521723072	-122.43459149970501	(37.7336521723072, -122.434591499705)
71679	71679	228951	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	118 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 6ft		6005386.85226	2102866.95811	37.7543768447429	-122.424302388563	(37.7543768447429, -122.424302388563)
71943	71943	202422	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	120 Brannan St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 6ft		6015901.40825	2113673.21446	37.7846365764686	-122.388694351787	(37.7846365764686, -122.388694351787)
72239	72239	208252	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	35 San Lorenzo Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5993745.99761	2097653.0262	37.739396514526	-122.46418063844101	(37.739396514526, -122.464180638441)
74347	74347	208237	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	40 Santa Monica Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5993560.861280001	2097425.24155	37.7387604024696	-122.46480421573601	(37.7387604024696, -122.464804215736)
76790	76790	202352	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	395 Folsom St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 6ft		6014910.84304	2115264.5164	37.7889509786636	-122.392232734374	(37.7889509786636, -122.392232734374)
123306	123306	208198	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	155 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5992885.77964	2095618.5015900002	37.7337606017701	-122.467006993572	(37.7337606017701, -122.467006993572)
132232	132232	208254	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	35 San Lorenzo Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993757.51512	2097692.13582	37.739504563592206	-122.46414365472499	(37.7395045635922, -122.464143654725)
135423	135423	202353	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	395 Folsom St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 6ft		6014932.149680001	2115285.12705	37.789008753801205	-122.39216045766099	(37.7890087538012, -122.392160457661)
136337	136337	192633	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	2x Garlington Ct	4	Median : Cutout 11	Tree 1	DPW 2			17	Width 6ft		6016736.26235	2094477.0250400002	37.7319741272952	-122.384468506713	(37.7319741272952, -122.384468506713)
137683	137683	208255	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	35 San Lorenzo Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5993760.417780001	2097703.02233	37.73953462252361	-122.464134408774	(37.7395346225236, -122.464134408774)
137694	137694	208235	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	30 Santa Monica Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993511.134	2097434.2746099997	37.7387823378375	-122.464976803755	(37.7387823378375, -122.464976803755)
148955	148955	208303	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	600x Bosworth St	4	Median : Cutout 11	Tree 1	DPW 2			2	Width 6ft		6002276.071219999	2095379.68472	37.7336423984691	-122.434524937286	(37.7336423984691, -122.434524937286)
150576	150576	208301	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	600x Bosworth St	2	Median : Cutout 11	Tree 1	DPW 2			2	Width 6ft		6002317.80033	2095368.99319	37.7336154107143	-122.434379903628	(37.7336154107143, -122.434379903628)
150644	150644	208256	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	35 San Lorenzo Way	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5993762.65186	2097710.37243	37.7395549328226	-122.46412721779801	(37.7395549328226, -122.464127217798)
152863	152863	192632	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	2x Garlington Ct	3	Median : Cutout 11	Tree 1	DPW 2			13	Width 6ft		6016758.25797	2094440.43595	37.73187487720529	-122.384389914969	(37.7318748772053, -122.384389914969)
152909	152909	129862	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	3630 Divisadero St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 6ft		6000214.38483	2120902.15861	37.8036034654848	-122.443485478179	(37.8036034654848, -122.443485478179)
153165	153165	208249	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	65 San Lorenzo Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5993722.3546	2097545.82364	37.7391008003548	-122.464254604065	(37.7391008003548, -122.464254604065)
153612	153612	208231	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	18 Santa Monica Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5993425.010919999	2097422.17694	37.738744154419706	-122.465273696018	(37.7387441544197, -122.465273696018)
154395	154395	208241	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	50 Santa Monica Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5993632.94814	2097391.47717	37.7386718498284	-122.46455252427401	(37.7386718498284, -122.464552524274)
154578	154578	228998	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	2953 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 6ft		6009706.73596	2101591.75349	37.751118399502	-122.409273076799	(37.751118399502, -122.409273076799)
156091	156091	208244	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	75 San Lorenzo Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993706.62967	2097419.51827	37.738753090981	-122.464299805789	(37.738753090981, -122.464299805789)
158107	158107	208197	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	171 San Benito Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5992886.8811800005	2095580.71887	37.7336569234134	-122.46700043933201	(37.7336569234134, -122.467000439332)
158555	158555	192631	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	2 Garlington Ct	1	: 4	Tree 1	Private 1			15	Width 6ft		6016783.64783	2094408.52472	37.7317886592161	-122.38429991441002	(37.7317886592161, -122.38429991441)
159492	159492	208246	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	75 San Lorenzo Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5993711.81296	2097482.43127	37.7389261331305	-122.464286450858	(37.7389261331305, -122.464286450858)
159936	159936	208227	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	2 Santa Monica Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5993339.02056	2097373.97973	37.7386068576137	-122.46556750724	(37.7386068576137, -122.46556750724)
162127	162127	202427	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	120 Brannan St	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 6ft		6015675.3599	2113457.5655099996	37.7840319226843	-122.38946134487101	(37.7840319226843, -122.389461344871)
167805	167805	208233	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	24 Santa Monica Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5993476.65157	2097433.51929	37.7387782755959	-122.465095972005	(37.7387782755959, -122.465095972005)
168027	168027	228984	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	2689 Bryant St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 6ft		6009821.741769999	2101696.3293	37.7514119840826	-122.408882750359	(37.7514119840826, -122.408882750359)
168958	168958	229009	Undocumented 2	Lophostemon confertus :: Brisbane Box 11	3444 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 6ft		6005442.13834	2103155.40419	37.7551719722291	-122.424131707109	(37.7551719722291, -122.424131707109)

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