Street_Tree_List

Data source: data.sfgov.org

178 rows where PlotSize = "Width 3ft" and qSpecies = 27 sorted by XCoord

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, SiteOrder, qSiteInfo, qCaretaker, DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
165009	165009	117857	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	600 39th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5983829.36907	2111677.06691	37.777326048802294	-122.499503563368	(37.7773260488023, -122.499503563368)
67977	67977	117858	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	600 39th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5983830.55841	2111665.32715	37.777293884605704	-122.499498581311	(37.7772938846057, -122.499498581311)
25168	25168	118098	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	3619 Balboa St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5984331.597680001	2111046.0676700003	37.7756229611607	-122.497719616092	(37.7756229611607, -122.497719616092)
34662	34662	117967	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	4545 Anza St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5984550.3085	2111733.18458	37.7775224048599	-122.497013781042	(37.7775224048599, -122.497013781042)
117656	117656	117966	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	4545 Anza St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5984567.33243	2111733.70358	37.7775248274666	-122.496954928801	(37.7775248274666, -122.496954928801)
71533	71533	117965	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	4545 Anza St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5984581.6879	2111733.75019	37.7775257966351	-122.496905272636	(37.7775257966351, -122.496905272636)
173249	173249	117964	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	4545 Anza St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5984595.13139	2111732.58098	37.7775233740539	-122.496858681509	(37.7775233740539, -122.496858681509)
63394	63394	119482	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	426 33rd Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5985642.69106	2113025.08426	37.781133543390204	-122.49333012331499	(37.7811335433902, -122.493330123315)
176931	176931	119480	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	426 33rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5985643.02597	2112973.39807	37.7809916475781	-122.493325155639	(37.7809916475781, -122.493325155639)
149892	149892	119481	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	426 33rd Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5985644.19758	2112999.51907	37.781063436855604	-122.493323027528	(37.7810634368556, -122.493323027528)
38348	38348	119479	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	426 33rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5985644.21808	2112952.33317	37.7809338791525	-122.493319479205	(37.7809338791525, -122.493319479205)
159331	159331	120006	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	658 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5986941.43179	2111450.92852	37.7768872385676	-122.488721446125	(37.7768872385676, -122.488721446125)
62758	62758	207140	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1682 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5990920.30999	2103955.3917900003	37.7565379030086	-122.474410316087	(37.7565379030086, -122.474410316087)
153744	153744	207155	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	606 Santiago St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990983.67458	2099779.50243	37.7450756729987	-122.473886535662	(37.7450756729987, -122.473886535662)
188027	188027	207154	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	606 Santiago St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5990999.639880001	2099781.66866	37.745082545627106	-122.47383148903299	(37.7450825456271, -122.473831489033)
51759	51759	207273	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	2486 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5991107.555	2098499.64463	37.741568687546604	-122.473364852413	(37.7415686875466, -122.473364852413)
137737	137737	207316	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	540 Vicente St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5991234.77071	2097748.67502	37.739514082899795	-122.47287024148899	(37.7395140828998, -122.472870241489)
58029	58029	207272	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	855 Ortega St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991341.884190001	2102447.3188400003	37.7524215459225	-122.472842415544	(37.7524215459225, -122.472842415544)
59067	59067	207271	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	855 Ortega St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5991354.98649	2102448.1922400002	37.752424702544296	-122.47279716974899	(37.7524247025443, -122.472797169749)
131369	131369	207156	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	2426 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991402.6198	2098893.19012	37.7426663442825	-122.472373311184	(37.7426663442825, -122.472373311184)
131761	131761	207244	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	246 Monticello St	1	: 4	Tree 1	Private 1			4	Width 3ft		5991705.04474	2090167.4544799998	37.7187251566245	-122.47069219949199	(37.7187251566245, -122.470692199492)
158423	158423	207267	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	800 Shields St	1	: 4	Tree 1	Private 1			4	Width 3ft		5991908.73686	2089873.18907	37.71792895264	-122.469966710089	(37.71792895264, -122.469966710089)
157438	157438	177007	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	216 Saint Charles Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		5992028.26989	2086999.54978	37.710045543251205	-122.469344489883	(37.7100455432512, -122.469344489883)
43733	43733	207159	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	345 San Fernando Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5992101.70168	2094641.4985900002	37.7310327079752	-122.469646658486	(37.7310327079752, -122.469646658486)
166192	166192	207245	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	495 Ralston St	3	: 4	Tree 1	Private 1			4	Width 3ft		5992206.61176	2091125.8340200002	37.7213856246322	-122.469028209083	(37.7213856246322, -122.469028209083)
187054	187054	207246	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	495 Ralston St	2	: 4	Tree 1	Private 1			4	Width 3ft		5992206.82998	2091154.32928	37.7214638782474	-122.469029527495	(37.7214638782474, -122.469029527495)
156004	156004	207247	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	495 Ralston St	1	: 4	Tree 1	Private 1			4	Width 3ft		5992207.674790001	2091176.35111	37.721524393612	-122.46902820910299	(37.721524393612, -122.469028209103)
154647	154647	207152	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	731 Judah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5992245.611880001	2105887.84431	37.761920604463796	-122.469967690366	(37.7619206044638, -122.469967690366)
135470	135470	207277	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	236 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5992402.86272	2097663.9953099997	37.7393491274725	-122.46882536342	(37.7393491274725, -122.46882536342)
133706	133706	207160	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	384 Santa Ana Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5992464.42361	2094258.2447	37.7300013456858	-122.46836480621799	(37.7300013456858, -122.468364806218)
74830	74830	207158	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	237 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5992472.8250400005	2097675.82148	37.739385640835295	-122.468584327098	(37.7393856408353, -122.468584327098)
34491	34491	207157	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	237 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5992487.55481	2097691.20205	37.7394287228632	-122.468534517269	(37.7394287228632, -122.468534517269)
59113	59113	207317	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	2146 12th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5992616.43475	2100823.70057	37.748037210643396	-122.46831674014	(37.7480372106434, -122.46831674014)
176364	176364	207259	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	531 Arch St	1	: 4	Tree 1	Private 1			5	Width 3ft		5992719.90357	2090700.8696700002	37.720248420215	-122.467223034109	(37.720248420215, -122.467223034109)
137140	137140	207254	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	559 Arch St	1	: 4	Tree 1	Private 1			6	Width 3ft		5992720.910730001	2090888.5643799999	37.720763842354	-122.467233192875	(37.720763842354, -122.467233192875)
62400	62400	207257	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	545 Arch St	2	: 4	Tree 1	Private 1			8	Width 3ft		5992721.30272	2090787.38196	37.7204860426843	-122.467224484748	(37.7204860426843, -122.467224484748)
134488	134488	207256	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	545 Arch St	1	: 4	Tree 1	Private 1			6	Width 3ft		5992721.58386	2090800.7544	37.720522776379596	-122.467224484746	(37.7205227763796, -122.467224484746)
39672	39672	207255	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	551 Arch St	1	: 4	Tree 1	Private 1			6	Width 3ft		5992722.91506	2090824.1387	37.72058706082171	-122.467221582632	(37.7205870608217, -122.467221582632)
48128	48128	207250	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	571 Arch St	1	: 4	Tree 1	Private 1			5	Width 3ft		5992722.93824	2090965.0292099998	37.7209739131985	-122.467231741345	(37.7209739131985, -122.467231741345)
138093	138093	207251	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	567 Arch St	1	: 4	Tree 1	Private 1			2	Width 3ft		5992723.294480001	2090942.0276900001	37.720910777190795	-122.46722883836	(37.7209107771908, -122.46722883836)
178299	178299	207249	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	581 Arch St	1	: 4	Tree 1	Private 1			7	Width 3ft		5992725.89958	2091026.00542	37.7211415099655	-122.467225936253	(37.7211415099655, -122.467225936253)
174314	174314	207252	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	560 Arch St	1	: 4	Tree 1	Private 1			6	Width 3ft		5992752.3271699995	2090925.11248	37.7208660080514	-122.467127252727	(37.7208660080514, -122.467127252727)
186952	186952	207258	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	532 Arch St	1	: 4	Tree 1	Private 1			7	Width 3ft		5992753.93277	2090721.89417	37.7203081126976	-122.46710693523998	(37.7203081126976, -122.46710693524)
171030	171030	207253	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	556 Arch St	1	: 4	Tree 1	Private 1			6	Width 3ft		5992754.265459999	2090897.47883	37.7207902446595	-122.46711854461	(37.7207902446595, -122.46711854461)
24738	24738	207248	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	574 Arch St	1	: 4	Tree 1	Private 1			6	Width 3ft		5992756.55156	2091026.1972	37.7211438059241	-122.46711999608401	(37.7211438059241, -122.467119996084)
59680	59680	207153	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	37 Cragmont Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992857.79641	2101696.45596	37.750447510654396	-122.467545586773	(37.7504475106544, -122.467545586773)
136074	136074	207276	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	350 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5992917.36629	2099685.98724	37.7449307166945	-122.467193430259	(37.7449307166945, -122.467193430259)
51445	51445	207262	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	510 Ramsell St	2	: 4	Tree 1	Private 1			4	Width 3ft		5993010.6580300005	2090589.3329599998	37.7199589473287	-122.466209899286	(37.7199589473287, -122.466209899286)
56032	56032	207275	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	315 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5993069.797230001	2099663.50314	37.7448777789813	-122.46666472241999	(37.7448777789813, -122.46666472242)
163785	163785	207274	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	315 Dorantes Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5993100.15501	2099667.06703	37.7448893164068	-122.466560010732	(37.7448893164068, -122.466560010732)
156794	156794	207268	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	321 Shields St	1	: 4	Tree 1	Private 1			4	Width 3ft		5993118.56975	2089825.8623400002	37.7178688671261	-122.46578144695299	(37.7178688671261, -122.465781446953)
46658	46658	207264	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	319 Victoria St	1	: 4	Tree 1	Private 1			5	Width 3ft		5993222.99582	2089325.40947	37.716500767187	-122.465384161548	(37.716500767187, -122.465384161548)
173504	173504	207289	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	81 Pinehurst Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5993404.50324	2093508.25253	37.727996305369395	-122.465060411924	(37.7279963053694, -122.465060411924)
31710	31710	207290	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	81 Pinehurst Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5993410.050430001	2093515.91328	37.7280176597738	-122.465041791443	(37.7280176597738, -122.465041791443)
54556	54556	207281	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	595 Darien Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5993428.290469999	2094922.6798	37.731881346040794	-122.46508086700001	(37.7318813460408, -122.465080867)
70124	70124	207280	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	595 Darien Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5993435.14458	2094919.26873	37.731872375313294	-122.46505692344299	(37.7318723753133, -122.465056923443)
59419	59419	207291	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	135 Pinehurst Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5993593.95913	2093848.0757900001	37.7289402994475	-122.464430125662	(37.7289402994475, -122.464430125662)
153631	153631	207288	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	80 Manor Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5993609.88258	2093413.56437	37.7277481554518	-122.46434354343599	(37.7277481554518, -122.464343543436)
155331	155331	207287	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	80 Manor Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5993617.196719999	2093428.42881	37.7277893911619	-122.464319337265	(37.7277893911619, -122.464319337265)
54753	54753	207286	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	80 Manor Dr	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5993623.31026	2093437.41863	37.7278144273955	-122.464298855206	(37.7278144273955, -122.464298855206)
179484	179484	207285	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	84 Manor Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5993629.18842	2093448.0222200002	37.7278438810755	-122.464279303953	(37.7278438810755, -122.464279303953)
130898	130898	207284	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	84 Manor Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5993637.22552	2093458.84875	37.727874071330106	-122.464252305417	(37.7278740713301, -122.464252305417)
130433	130433	207283	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	84 Manor Dr	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5993642.59329	2093470.80397	37.7279072068291	-122.464234616632	(37.7279072068291, -122.464234616632)
70570	70570	207314	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1570 07th Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5994021.19813	2104903.51705	37.759320377550395	-122.46375523571999	(37.7593203775504, -122.46375523572)
154080	154080	207315	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1570 07th Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5994029.69886	2104725.63145	37.7588324395785	-122.463712925326	(37.7588324395785, -122.463712925326)
150633	150633	207151	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	223 Kirkham St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5994241.91079	2105279.16697	37.760364530923205	-122.46301916490299	(37.7603645309232, -122.463019164903)
42942	42942	207270	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1439 06th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5994256.24514	2105719.06013	37.7615731891695	-122.463001505824	(37.7615731891695, -122.463001505824)
69145	69145	207269	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1477 06th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5994263.394830001	2105452.9722599997	37.760842992730105	-122.462957472303	(37.7608429927301, -122.462957472303)
61063	61063	207293	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	965 Darien Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5994659.04342	2093888.37752	37.729112296585996	-122.460750997386	(37.729112296586, -122.460750997386)
131611	131611	207292	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	965 Darien Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5994659.45419	2093917.36528	37.729191913559205	-122.460751677241	(37.7291919135592, -122.460751677241)
185209	185209	207231	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	250 Faxon Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5994770.3606900005	2090247.29491	37.7191211640843	-122.46010248996099	(37.7191211640843, -122.460102489961)
43666	43666	207282	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	163 Westwood Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5995118.51339	2093829.85755	37.7289780403896	-122.459158347475	(37.7289780403896, -122.459158347475)
56436	56436	207226	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	224 Miramar Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5995369.52282	2091446.6873400002	37.722448854419795	-122.45811818710399	(37.7224488544198, -122.458118187104)
163615	163615	207164	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	501 Laguna Honda Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5995446.92636	2100264.89737	37.7466659540754	-122.45848863046001	(37.7466659540754, -122.45848863046)
37320	37320	207230	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	437 Holloway Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5995450.98225	2091203.60917	37.7217860999295	-122.457819021351	(37.7217860999295, -122.457819021351)
67812	67812	207165	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	501 Laguna Honda Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995466.11989	2100230.17484	37.746571717707205	-122.458419748693	(37.7465717177072, -122.458419748693)
178122	178122	207321	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	20 Woodside Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5995570.24881	2100282.2016	37.746720553705	-122.458063448969	(37.746720553705, -122.458063448969)
177980	177980	207320	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	20 Woodside Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5995605.62076	2100279.71012	37.746715745033	-122.45794095682699	(37.746715745033, -122.457940956827)
133848	133848	207319	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	20 Woodside Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5995627.90301	2100275.99182	37.7467068156796	-122.45786363851299	(37.7467068156796, -122.457863638513)
175015	175015	207318	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	20 Woodside Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 3ft		5995646.386969999	2100270.85159	37.746693763801204	-122.457799351359	(37.7466937638012, -122.457799351359)
42681	42681	207330	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	345 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5995685.60702	2098472.19978	37.7417573653183	-122.45753361969601	(37.7417573653183, -122.457533619696)
183022	183022	207329	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	307 Ulloa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5995854.78749	2098571.2519	37.7420390545738	-122.45695581607401	(37.7420390545738, -122.456955816074)
63518	63518	207294	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	1414 Plymouth Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5995890.4022699995	2093395.3891200002	37.727829439763106	-122.456458481978	(37.7278294397631, -122.456458481978)
61510	61510	207295	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	217 Colon Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5996039.75572	2094297.6973299999	37.7303155346371	-122.45600737215	(37.7303155346371, -122.45600737215)
74649	74649	207296	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	217 Colon Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5996041.08515	2094289.8634799998	37.7302941010767	-122.456002210028	(37.7302941010767, -122.456002210028)
184253	184253	207297	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	217 Colon Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5996046.36344	2094274.51279	37.730252254734104	-122.455982853036	(37.7302522547341, -122.455982853036)
76051	76051	207298	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	111 Valdez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5996286.51947	2094316.70178	37.73038187671379	-122.45515565391099	(37.7303818767138, -122.455155653911)
53847	53847	207299	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	111 Valdez Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5996293.5704	2094296.85345	37.7303277824929	-122.455129844261	(37.7303277824929, -122.455129844261)
62171	62171	207300	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	145 Hazelwood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5996448.99813	2094535.9636799998	37.730993237639105	-122.45460977981199	(37.7309932376391, -122.454609779812)
28926	28926	207301	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	145 Hazelwood Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5996452.48883	2094524.36789	37.7309615985977	-122.454596874545	(37.7309615985977, -122.454596874545)
155074	155074	207225	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	272 Lee Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5996551.89898	2091549.3096	37.7227984982343	-122.454038414459	(37.7227984982343, -122.454038414459)
37568	37568	207302	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	65 Hazelwood Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5996572.7806400005	2094082.116	37.72975417960021	-122.45414907781799	(37.7297541796002, -122.454149077818)
58147	58147	207303	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	59 Hazelwood Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5996585.5854400005	2094033.89672	37.7296225152507	-122.45410132920601	(37.7296225152507, -122.454101329206)
42179	42179	207304	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	53 Hazelwood Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5996585.7495	2094006.0145	37.72954596675461	-122.454098749052	(37.7295459667546, -122.454098749052)
147662	147662	207305	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	45 Hazelwood Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5996586.90838	2093990.0061299999	37.7295020780524	-122.454093586973	(37.7295020780524, -122.454093586973)
149202	149202	207311	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	40 Hazelwood Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5996623.9577	2093958.7514099998	37.729418384438894	-122.453963248219	(37.7294183844389, -122.453963248219)
166261	166261	207306	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	40 Hazelwood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5996625.80083	2093939.75542	37.7293663316726	-122.453955505049	(37.7293663316726, -122.453955505049)
56956	56956	207310	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	40 Hazelwood Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5996630.650640001	2093957.49673	37.7294153231391	-122.453940019643	(37.7294153231391, -122.453940019643)
32289	32289	207308	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	40 Hazelwood Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5996630.86084	2093949.68597	37.7293938887121	-122.453938729108	(37.7293938887121, -122.453938729108)
149640	149640	207307	Undocumented 2	Leptospermum scoparium :: New Zealand Tea Tree 27	40 Hazelwood Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5996632.29133	2093946.6824400001	37.7293857237559	-122.453933566973	(37.7293857237559, -122.453933566973)

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