Street_Tree_List

Data source: data.sfgov.org

220 rows where qSiteInfo = 4 and qSpecies = 12 sorted by YCoord

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: DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord ▼	Latitude	Longitude	Location
159671	159671	175338	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	248 Wilson St	1	: 4	Tree 1	Private 1			10	Width 3ft		5994374.45478	2086640.5688599998	37.709195169503005	-122.461209673184	(37.709195169503, -122.461209673184)
152452	152452	175339	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	248 Wilson St	3	: 4	Tree 1	Private 1			8	Width 3ft		5994341.375580001	2086670.8513099998	37.709276414241295	-122.46132619294399	(37.7092764142413, -122.461326192944)
162646	162646	187512	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	12	: 4	Tree 1	Private 1			4	Width 3ft		6004972.0075900005	2086680.68467	37.7099095126929	-122.424585708258	(37.7099095126929, -122.424585708258)
170289	170289	187511	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	11	: 4	Tree 1	Private 1			5	Width 3ft		6004958.741090001	2086695.30162	37.7099488984891	-122.42463259891599	(37.7099488984891, -122.424632598916)
164843	164843	187510	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	10	: 4	Tree 1	Private 1			5	Width 3ft		6004948.81965	2086709.68307	37.709987826555704	-122.424667911703	(37.7099878265557, -122.424667911703)
153430	153430	187509	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	9	: 4	Tree 1	Private 1			5	Width 3ft		6004937.85944	2086722.41778	37.7100221743453	-122.424706697651	(37.7100221743453, -122.424706697651)
154404	154404	175342	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	3	: 4	Tree 1	Private 1			11	Width 3ft		5994489.11096	2086733.7148099998	37.7094575242209	-122.46082015254801	(37.7094575242209, -122.460820152548)
187533	187533	175341	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	2	: 4	Tree 1	Private 1			7	Width 3ft		5994500.0272699995	2086747.2122099998	37.709495213017	-122.460783401753	(37.709495213017, -122.460783401753)
162385	162385	187507	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	7	: 4	Tree 1	Private 1			4	Width 3ft		6004913.95724	2086749.2623400001	37.7100945337938	-122.424791216847	(37.7100945337938, -122.424791216847)
187124	187124	175340	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	1	: 4	Tree 1	Private 1			4	Width 3ft		5994510.0494800005	2086755.6303299998	37.7095189038466	-122.460749373209	(37.7095189038466, -122.460749373209)
169545	169545	187506	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	6	: 4	Tree 1	Private 1			9	Width 3ft		6004893.16086	2086772.3737400002	37.7101568181467	-122.424864736445	(37.7101568181467, -122.424864736445)
150929	150929	187505	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	5	: 4	Tree 1	Private 1			9	Width 3ft		6004874.161669999	2086793.27995	37.710213148986504	-122.42493188792	(37.7102131489865, -122.42493188792)
186035	186035	175334	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	1	: 4	Tree 1	Private 1			12	Width 3ft		5994510.66891	2086823.77253	37.709706041981704	-122.460752167376	(37.7097060419817, -122.460752167376)
166302	166302	175335	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	2	: 4	Tree 1	Private 1			10	Width 3ft		5994496.623790001	2086824.0668400002	37.7097060419715	-122.46080073078699	(37.7097060419715, -122.460800730787)
31818	31818	175337	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	4	: 4	Tree 1	Private 1			14	Width 3ft		5994455.45704	2086824.9295299998	37.7097060419823	-122.46094307188801	(37.7097060419823, -122.460943071888)
39699	39699	175336	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	3	: 4	Tree 1	Private 1			9	Width 3ft		5994472.9026	2086825.04671	37.709707367568996	-122.460882785837	(37.709707367569, -122.460882785837)
157675	157675	187525	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	1	: 4	Tree 1	Private 1			5	Width 1ft		6012522.296569999	2087951.2705599999	37.7138218046169	-122.398579419997	(37.7138218046169, -122.398579419997)
51346	51346	187526	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	2	: 4	Tree 1	Private 1			7	Width 1ft		6012506.68997	2087960.4481099998	37.713846134852794	-122.398634006175	(37.7138461348528, -122.398634006175)
181502	181502	187527	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	3	: 4	Tree 1	Private 1			5	Width 1ft		6012489.4847099995	2087971.9174	37.713876668655296	-122.398694278718	(37.7138766686553, -122.398694278718)
54859	54859	187528	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	4	: 4	Tree 1	Private 1			6	Width 1ft		6012472.93884	2087982.00491	37.7139034450734	-122.398752175284	(37.7139034450734, -122.398752175284)
187147	187147	204072	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	1	: 4	Tree 1	Private 1			3	Width 3ft		5992726.8230099995	2088588.5716900001	37.714448960336206	-122.46704562576299	(37.7144489603362, -122.467045625763)
160390	160390	204073	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	2	: 4	Tree 1	Private 1			6	Width 3ft		5992727.7538	2088602.30188	37.7144867138609	-122.467043406235	(37.7144867138609, -122.467043406235)
132631	132631	204077	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	207 Arch St	1	: 4	Tree 1	Private 1			1	Width 3ft		5992694.39377	2088603.9622	37.7144893470695	-122.46715883152599	(37.7144893470695, -122.467158831526)
34857	34857	204074	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	3	: 4	Tree 1	Private 1			8	Width 3ft		5992726.806	2088618.3095900002	37.714530612473105	-122.46704784529699	(37.7145306124731, -122.467047845297)
180927	180927	204075	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	4	: 4	Tree 1	Private 1			4	Width 3ft		5992726.79414	2088633.01861	37.7145709992182	-122.46704895504101	(37.7145709992182, -122.467048955041)
41338	41338	204076	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	5	: 4	Tree 1	Private 1			9	Width 3ft		5992727.09649	2088647.4013599998	37.7146105082406	-122.467048955052	(37.7146105082406, -122.467048955052)
157604	157604	204080	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	225 Victoria St	1	: 4	Tree 1	Private 1			9	Width 3ft		5993216.93955	2088773.98493	37.714986338524206	-122.465365061769	(37.7149863385242, -122.465365061769)
188457	188457	204057	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	60 Monticello St	1	: 4	Tree 1	Private 1			1	Width 3ft		5991692.74622	2089138.75635	37.7158998914375	-122.47065982389299	(37.7158998914375, -122.470659823893)
165900	165900	204094	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Sargent St	1	: 4	Tree 1	Private 1			12	Width 3ft		5993976.27625	2089155.91875	37.7160788007751	-122.462768183016	(37.7160788007751, -122.462768183016)
185827	185827	204097	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	27 Sargent St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993869.3414900005	2089159.6844099998	37.716082980832205	-122.46313807056002	(37.7160829808322, -122.46313807056)
67849	67849	204096	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	21 Sargent St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993896.88715	2089161.0094599999	37.7160882058709	-122.46304295648599	(37.7160882058709, -122.463042956486)
68566	68566	204098	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	33 Sargent St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993844.91578	2089161.3386400002	37.7160861158451	-122.46322261673201	(37.7160861158451, -122.463222616732)
150288	150288	204099	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	45 Sargent St	1	: 4	Tree 1	Private 1			9	Width 3ft		5993811.31376	2089162.80485	37.716088205875394	-122.46333886672	(37.7160882058754, -122.46333886672)
168242	168242	204091	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Sargent St	2	: 4	Tree 1	Private 1			11	Width 3ft		5993976.66026	2089192.4471099998	37.7161791210507	-122.462769504124	(37.7161791210507, -122.462769504124)
177587	177587	204095	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	24 Sargent St	1	: 4	Tree 1	Private 1			5	Width 3ft		5993902.945830001	2089194.7546400002	37.7161812110757	-122.463024461917	(37.7161812110757, -122.463024461917)
165696	165696	204093	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	22 Sargent St	1	: 4	Tree 1	Private 1			5	Width 3ft		5993932.401430001	2089196.0396599998	37.716186436122605	-122.462922743188	(37.7161864361226, -122.462922743188)
45622	45622	204092	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	20 Sargent St	1	: 4	Tree 1	Private 1			4	Width 3ft		5993952.38646	2089201.3292900003	37.71620211130279	-122.46285404939199	(37.7162021113028, -122.462854049392)
184910	184910	204054	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	116 Majestic Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5997034.58686	2089315.10144	37.7166915502611	-122.45220874374901	(37.7166915502611, -122.452208743749)
59462	59462	204053	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 Majestic Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		5997084.51167	2089384.1805200002	37.7168840852152	-122.452041160489	(37.7168840852152, -122.452041160489)
70182	70182	204056	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Lakeview Ave	1	: 4	Tree 1	Private 1			8	Width 3ft		5997069.70996	2089426.6640700002	37.7169998873021	-122.452095385989	(37.7169998873021, -122.452095385989)
39356	39356	204071	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	10	: 4	Tree 1	Private 1			1	Width 2ft		5991926.528080001	2089611.9892799999	37.7172127901068	-122.469886207299	(37.7172127901068, -122.469886207299)
165588	165588	204070	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	9	: 4	Tree 1	Private 1			1	Width 2ft		5991926.35575	2089627.2113400002	37.7172545762149	-122.469887910622	(37.7172545762149, -122.469887910622)
39264	39264	204069	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	8	: 4	Tree 1	Private 1			1	Width 2ft		5991925.79364	2089647.35065	37.7173098413624	-122.469891319037	(37.7173098413624, -122.469891319037)
188232	188232	204068	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	7	: 4	Tree 1	Private 1			1	Width 2ft		5991927.09954	2089662.54158	37.7173516274427	-122.46988791059499	(37.7173516274427, -122.469887910595)
69075	69075	204067	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	6	: 4	Tree 1	Private 1			1	Width 2ft		5991926.95794	2089679.2355799999	37.717397456914796	-122.469889614813	(37.7173974569148, -122.469889614813)
188378	188378	204066	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	5	: 4	Tree 1	Private 1			2	Width 2ft		5991927.82266	2089696.89032	37.7174459825143	-122.469887910592	(37.7174459825143, -122.469887910592)
134590	134590	204065	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	4	: 4	Tree 1	Private 1			1	Width 2ft		5991927.94965	2089726.34257	37.71752685855721	-122.469889614814	(37.7175268585572, -122.469889614814)
162914	162914	204064	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	3	: 4	Tree 1	Private 1			1	Width 2ft		5991927.921680001	2089748.4341799999	37.717587515118	-122.46989131904499	(37.717587515118, -122.469891319045)
32964	32964	204055	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	66 Margaret Ave	1	: 4	Tree 1	Private 1			10	Width 3ft		5997041.30119	2089782.6592599999	37.71797573986029	-122.45221925324199	(37.7179757398603, -122.452219253242)
165761	165761	204063	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	2	: 4	Tree 1	Private 1			1	Width 2ft		5991928.61684	2089804.8745400002	37.71774252677329	-122.469893023248	(37.7177425267733, -122.469893023248)
184601	184601	204062	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	1	: 4	Tree 1	Private 1			1	Width 2ft		5991928.03433	2089824.0323400002	37.71779509575	-122.469896430779	(37.71779509575, -122.469896430779)
180941	180941	204061	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	238 Byxbee St	1	: 4	Tree 1	Private 1			8	Width 3ft		5991965.696690001	2090114.3483099998	37.718594409584206	-122.469787374509	(37.7185944095842, -122.469787374509)
177462	177462	204058	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	247 Monticello St	1	: 4	Tree 1	Private 1			1	Width 3ft		5991672.76031	2090179.42511	37.718756158047206	-122.470804664228	(37.7187561580472, -122.470804664228)
50731	50731	204059	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	254 Monticello St	1	: 4	Tree 1	Private 1			9	Width 3ft		5991705.974830001	2090211.6163	37.71884646795999	-122.470692199481	(37.71884646796, -122.470692199481)
41648	41648	204157	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	109	: 4	Tree 1	Private 1			2	Width 0ft		5991141.76494	2090345.5990099998	37.7191817082419	-122.47265219366899	(37.7191817082419, -122.472652193669)
25562	25562	204156	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	106	: 4	Tree 1	Private 1			3	Width 0ft		5991140.12525	2090380.53407	37.719277536403496	-122.472660407165	(37.7192775364035, -122.472660407165)
69170	69170	204084	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	681 Head St	4	: 4	Tree 1	Private 1			7	Width 3ft		5993496.99915	2090384.7018099998	37.7194251277541	-122.46451394876699	(37.7194251277541, -122.464513948767)
177536	177536	204083	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	681 Head St	3	: 4	Tree 1	Private 1			7	Width 3ft		5993496.80112	2090400.5748599998	37.719468699905	-122.464515785199	(37.719468699905, -122.464515785199)
169556	169556	204082	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	681 Head St	2	: 4	Tree 1	Private 1			5	Width 3ft		5993496.5476	2090413.80426	37.7195050100316	-122.464517621588	(37.7195050100316, -122.464517621588)
161329	161329	204155	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	103	: 4	Tree 1	Private 1			1	Width 0ft		5991146.25454	2090417.6717700001	37.7193798621823	-122.47264192698	(37.7193798621823, -122.47264192698)
170158	170158	204081	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	681 Head St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993497.95379	2090430.17226	37.71955003367329	-122.464513948782	(37.7195500336733, -122.464513948782)
27724	27724	204090	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	520 Garfield St	1	: 4	Tree 1	Private 1			5	Width 3ft		5992622.63923	2090513.2598299999	37.7197276740608	-122.46754560564501	(37.7197276740608, -122.467545605645)
67179	67179	204154	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	96	: 4	Tree 1	Private 1			3	Width 0ft		5991156.52869	2090538.7202700002	37.7197128262716	-122.47261523421001	(37.7197128262716, -122.47261523421)
172323	172323	204078	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	516 Ramsell St	1	: 4	Tree 1	Private 1			1	Width 3ft		5993011.249	2090617.45713	37.7200362035765	-122.466209899293	(37.7200362035765, -122.466209899293)
38548	38548	204079	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	517 Victoria St	1	: 4	Tree 1	Private 1			10	Width 3ft		5993238.7635699995	2090626.4258	37.7200739535406	-122.46542411665001	(37.7200739535406, -122.46542411665)
182072	182072	204153	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	52	: 4	Tree 1	Private 1			1	Width 0ft		5991161.67549	2090655.1387900002	37.720032780762104	-122.47260592714198	(37.7200327807621, -122.472605927142)
173476	173476	202039	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	350 Salinas Ave	2	: 4	Tree 1	Private 1			1	Width 3ft		6012297.61112	2090750.98182	37.721496728686	-122.39955246577601	(37.721496728686, -122.399552465776)
175436	175436	204152	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	900 Junipero Serra Blvd	37	: 4	Tree 1	Private 1			1	Width 0ft		5991169.92245	2090751.38969	37.7202975393725	-122.472584434247	(37.7202975393725, -122.472584434247)
64961	64961	202040	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	350 Salinas Ave	3	: 4	Tree 1	Private 1			1	Width 3ft		6012278.04252	2090758.61512	37.7215165973918	-122.399620645181	(37.7215165973918, -122.399620645181)
175236	175236	204088	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	554 Bright St	1	: 4	Tree 1	Private 1			4	Width 3ft		5993796.400719999	2090834.18687	37.720676560449704	-122.463511639061	(37.7206765604497, -122.463511639061)
49371	49371	204089	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	558 Bright St	1	: 4	Tree 1	Private 1			6	Width 3ft		5993794.816819999	2090859.7407	37.7207466338444	-122.463518967621	(37.7207466338444, -122.463518967621)
152925	152925	204085	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	763 Head St	1	: 4	Tree 1	Private 1			11	Width 3ft		5993502.27941	2090889.21428	37.7208107015456	-122.46453231021401	(37.7208107015456, -122.464532310214)
108622	108622	204086	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	779 Head St	2	: 4	Tree 1	Private 1			8	Width 3ft		5993504.875109999	2090987.54432	37.7210808416867	-122.464530473824	(37.7210808416867, -122.464530473824)
69693	69693	204087	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	783 Head St	1	: 4	Tree 1	Private 1			12	Width 3ft		5993505.41903	2091013.45112	37.72115200684679	-122.464530473801	(37.7211520068468, -122.464530473801)
181990	181990	204052	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	109 Louisburg St	1	: 4	Tree 1	Private 1			4	Width 3ft		5997885.310880001	2091050.18574	37.721504387299795	-122.449393169677	(37.7215043872998, -122.449393169677)
44167	44167	204151	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	161	: 4	Tree 1	Private 1			6	Width 0ft		5991207.7087199995	2091371.2859599998	37.722001808625706	-122.47249899053499	(37.7220018086257, -122.472498990535)
164915	164915	204051	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	8 Geneva Ave	2	: 4	Tree 1	Private 1			9	Width 3ft		5997395.095430001	2091381.8849099998	37.722387101563	-122.45111161040701	(37.722387101563, -122.451111610407)
151687	151687	204050	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	8 Geneva Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997375.66754	2091389.92574	37.7224080674645	-122.45117934737499	(37.7224080674645, -122.451179347375)
130653	130653	204150	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	158	: 4	Tree 1	Private 1			7	Width 0ft		5991209.7349	2091396.16713	37.722070243443206	-122.47249379964799	(37.7220702434432, -122.472493799648)
30953	30953	204049	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	6 Geneva Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997346.16193	2091404.9638200002	37.7224476691055	-122.451282424964	(37.7224476691055, -122.451282424964)
187413	187413	204048	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	4 Geneva Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997298.98464	2091430.55111	37.7225152243894	-122.451447349841	(37.7225152243894, -122.451447349841)
177342	177342	204149	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	154	: 4	Tree 1	Private 1			6	Width 0ft		5991212.71454	2091446.3716400003	37.722208265075004	-122.47248715816299	(37.722208265075, -122.472487158163)
152085	152085	204148	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	148	: 4	Tree 1	Private 1			5	Width 0ft		5991212.9902099995	2091479.34405	37.7222988151126	-122.472488607883	(37.7222988151126, -122.472488607883)
32909	32909	204147	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	143	: 4	Tree 1	Private 1			8	Width 0ft		5991215.11855	2091556.56269	37.7225109615814	-122.47248687756	(37.7225109615814, -122.47248687756)
44766	44766	204146	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	136	: 4	Tree 1	Private 1			7	Width 0ft		5991223.21581	2091608.2334599998	37.7226533053988	-122.472462652551	(37.7226533053988, -122.472462652551)
63674	63674	204145	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	135	: 4	Tree 1	Private 1			5	Width 0ft		5991223.03412	2091647.11797	37.722760062121104	-122.472466114031	(37.7227600621211, -122.472466114031)
44251	44251	204144	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	131	: 4	Tree 1	Private 1			3	Width 0ft		5991226.84892	2091709.3466	37.7229311473308	-122.47245746165599	(37.7229311473308, -122.472457461656)
167990	167990	204143	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	127	: 4	Tree 1	Private 1			4	Width 0ft		5991229.50143	2091740.19596	37.7230160055595	-122.47245054047801	(37.7230160055595, -122.472450540478)
26935	26935	204142	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	126	: 4	Tree 1	Private 1			3	Width 0ft		5991215.491640001	2091740.4912900003	37.7230160055721	-122.47249899053001	(37.7230160055721, -122.47249899053)
171798	171798	204141	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	122	: 4	Tree 1	Private 1			5	Width 0ft		5991228.41386	2091783.5857799998	37.723135080309	-122.472457461666	(37.723135080309, -122.472457461666)
186048	186048	204140	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	121	: 4	Tree 1	Private 1			3	Width 0ft		5991218.48026	2091787.2847	37.7231446616675	-122.472492069365	(37.7231446616675, -122.472492069365)
167615	167615	204139	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	120	: 4	Tree 1	Private 1			2	Width 0ft		5991219.21165	2091798.23539	37.7231747718824	-122.47249033908501	(37.7231747718824, -122.472490339085)
152667	152667	204138	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	118	: 4	Tree 1	Private 1			3	Width 0ft		5991222.04967	2091814.1267099997	37.723218569775796	-122.47248168668001	(37.7232185697758, -122.47248168668)
61374	61374	204137	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	117	: 4	Tree 1	Private 1			2	Width 0ft		5991221.343090001	2091828.09873	37.7232568925832	-122.472485147293	(37.7232568925832, -122.472485147293)
183959	183959	204136	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	115	: 4	Tree 1	Private 1			2	Width 0ft		5991237.83729	2091850.68057	37.7233198514003	-122.472429776026	(37.7233198514003, -122.472429776026)
41931	41931	204135	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	114	: 4	Tree 1	Private 1			1	Width 0ft		5991224.97526	2091857.93043	37.72333901327	-122.47247476549299	(37.72333901327, -122.472474765493)
167766	167766	204134	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	112	: 4	Tree 1	Private 1			1	Width 0ft		5991228.00205	2091882.78985	37.7234074462669	-122.472466114014	(37.7234074462669, -122.472466114014)
162792	162792	204133	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	111	: 4	Tree 1	Private 1			4	Width 0ft		5991241.7215	2091892.4700799999	37.723434819851704	-122.47241939423401	(37.7234348198517, -122.472419394234)
70012	70012	204132	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	110	: 4	Tree 1	Private 1			1	Width 0ft		5991228.632230001	2091912.6848400002	37.7234895669738	-122.47246611402001	(37.7234895669738, -122.47246611402)
134489	134489	204131	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	700 Junipero Serra Blvd	107	: 4	Tree 1	Private 1			2	Width 0ft		5991246.04706	2091955.1858	37.723607272029604	-122.472409011575	(37.7236072720296, -122.472409011575)

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