Street_Tree_List

Data source: data.sfgov.org

302 rows where qSiteInfo = 19 sorted by DBH 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, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▲	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
34443	34443	186561	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	32	unknown : Yard 19	Tree 1	Private 1			85	Width 0ft		5984740.943	2104715.6846	37.758265506246296	-122.495836533834	(37.7582655062463, -122.495836533834)
72947	72947	186547	Undocumented 2	Pinus radiata :: Monterey Pine 3	1501 Sunset Blvd	18	unknown : Yard 19	Tree 1	Private 1			49	Width 0ft		5984724.5081	2104844.7562	37.7586189383832	-122.495902893491	(37.7586189383832, -122.495902893491)
137771	137771	181360	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	49	unknown : Yard 19	Tree 1	Private 1			47	Width 0ft		5985113.1047	2098629.2701	37.7415756656355	-122.494100873291	(37.7415756656355, -122.494100873291)
162312	162312	185412	Undocumented 2	Pinus radiata :: Monterey Pine 3	2300 Sunset Blvd	28	unknown : Yard 19	Tree 1	Private 1			47	Width 0ft		5985078.1422	2099185.3906	37.7431005765205	-122.494262741341	(37.7431005765205, -122.494262741341)
172749	172749	186574	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	45	unknown : Yard 19	Tree 1	Private 1			46	Width 0ft		5984720.0068	2104642.8266	37.7580642323025	-122.495903564638	(37.7580642323025, -122.495903564638)
182172	182172	185464	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	16	unknown : Yard 19	Tree 1	Private 1			46	Width 0ft		5985103.8081	2098378.9273	37.740887747752105	-122.494114570537	(37.7408877477521, -122.494114570537)
136486	136486	186550	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	21	unknown : Yard 19	Tree 1	Private 1			42	Width 0ft		5984736.7558	2104791.4736	37.7584733565115	-122.49585660551	(37.7584733565115, -122.49585660551)
25247	25247	185431	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2300 Sunset Blvd	47	unknown : Yard 19	Tree 1	Private 1			40	Width 0ft		5985098.6365	2099386.335	37.743653514796705	-122.49420668637899	(37.7436535147967, -122.494206686379)
134120	134120	185507	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	61	unknown : Yard 19	Tree 1	Private 1			40	Width 0ft		5985116.4249	2098801.2563	37.7420480876484	-122.494102066238	(37.7420480876484, -122.494102066238)
172640	172640	185503	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	57	unknown : Yard 19	Tree 1	Private 1			40	Width 0ft		5985131.0337	2098785.3193	37.7420051837622	-122.49405038008001	(37.7420051837622, -122.49405038008)
45919	45919	185477	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	29	unknown : Yard 19	Tree 1	Private 1			38	Width 0ft		5985132.3618	2098455.9558	37.741100918055295	-122.494021519499	(37.7411009180553, -122.494021519499)
185674	185674	185392	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2300 Sunset Blvd	3	unknown : Yard 19	Tree 1	Private 1			38	Width 0ft		5985108.1339	2098944.4572	37.7424407935289	-122.494141285581	(37.7424407935289, -122.494141285581)
67760	67760	186557	Undocumented 2	Pinus radiata :: Monterey Pine 3	1501 Sunset Blvd	28	unknown : Yard 19	Tree 1	Private 1			36	Width 0ft		5984754.7609	2104747.5076	37.758353692586	-122.49579109362101	(37.758353692586, -122.495791093621)
60510	60510	181353	Undocumented 2	Pinus radiata :: Monterey Pine 3	2300 Sunset Blvd	15	unknown : Yard 19	Tree 1	Private 1			34	Width 0ft		5985103.1353	2099041.4304	37.7427067632535	-122.49416571483	(37.7427067632535, -122.49416571483)
29764	29764	185497	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	51	unknown : Yard 19	Tree 1	Private 1			33	Width 0ft		5985111.7766	2098651.8474	37.7416375791026	-122.494107128969	(37.7416375791026, -122.494107128969)
131653	131653	185498	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	52	unknown : Yard 19	Tree 1	Private 1			33	Width 0ft		5985102.48	2098665.7923	37.74167532404589	-122.494140300571	(37.7416753240459, -122.494140300571)
24212	24212	181351	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2300 Sunset Blvd	5	unknown : Yard 19	Tree 1	Private 1			32	Width 0ft		5985090.6387	2098949.4558	37.7424534945744	-122.49420214621	(37.7424534945744, -122.49420214621)
34013	34013	185453	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	3	unknown : Yard 19	Tree 1	Private 1			32	Width 0ft		5985125.7214	2098256.744	37.740553547520705	-122.494029800854	(37.7405535475207, -122.494029800854)
35563	35563	186575	Undocumented 2	Pinus radiata :: Monterey Pine 3	1501 Sunset Blvd	46	unknown : Yard 19	Tree 1	Private 1			30	Width 0ft		5984766.4852	2104638.2207	37.75805430778821	-122.49574248511298	(37.7580543077882, -122.495742485113)
78014	78014	107210	Undocumented 2	Pinus radiata :: Monterey Pine 3	603 PERALTA AVE	1	unknown : Yard 19	Tree 1	Private 1			30			6009839.9	2098688.7	37.7431547125392	-122.40860781001498	(37.7431547125392, -122.408607810015)
111345	111345	114949	Property Tree 7	Pinus radiata :: Monterey Pine 3	1X WOODACRE DR	1	unknown : Yard 19	Tree 1	DPW 2			30	30x100		5991187.0	2095315.0	37.732829063550795	-122.47285799850201	(37.7328290635508, -122.472857998502)
157058	157058	185451	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	1	unknown : Yard 19	Tree 1	Private 1			30	Width 0ft		5985130.3697	2098228.1903	37.740475418723506	-122.49401162519399	(37.7404754187235, -122.494011625194)
183931	183931	185393	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2300 Sunset Blvd	6	unknown : Yard 19	Tree 1	Private 1			30	Width 0ft		5985089.6389999995	2098965.9512	37.742498727988895	-122.49420681837499	(37.7424987279889, -122.494206818375)
58500	58500	186538	Undocumented 2	Pinus radiata :: Monterey Pine 3	1501 Sunset Blvd	9	unknown : Yard 19	Tree 1	Private 1			29	Width 0ft		5984747.9566	2104882.4413	37.7587237844572	-122.495824579043	(37.7587237844572, -122.495824579043)
150480	150480	186577	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	48	unknown : Yard 19	Tree 1	Private 1			29	Width 0ft		5984764.3916	2104600.9543	37.75795186201471	-122.495746976697	(37.7579518620147, -122.495746976697)
180431	180431	185459	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	9	unknown : Yard 19	Tree 1	Private 1			28	Width 0ft		5985114.4327	2098335.7647	37.7407698565631	-122.494074654765	(37.7407698565631, -122.494074654765)
181515	181515	185432	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2300 Sunset Blvd	48	unknown : Yard 19	Tree 1	Private 1			28	Width 0ft		5985081.6412	2099386.335	37.7436525202566	-122.49426545113899	(37.7436525202566, -122.494265451139)
38441	38441	185474	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	26	unknown : Yard 19	Tree 1	Private 1			27	Width 0ft		5985113.1047	2098438.0268	37.7410505630538	-122.494086781525	(37.7410505630538, -122.494086781525)
175132	175132	185488	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	41	unknown : Yard 19	Tree 1	Private 1			27	Width 0ft		5985122.4012	2098536.3046	37.741320951397704	-122.494061879541	(37.7413209513977, -122.494061879541)
49960	49960	105135	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	175X ESMERALDA AVE	1	unknown : Yard 19	Tree 1	DPW 2			26			6007213.0	2098808.0	37.7433348108676	-122.41769940776301	(37.7433348108676, -122.417699407763)
52764	52764	185481	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	34	unknown : Yard 19	Tree 1	Private 1			26	Width 0ft		5985135.017999999	2098495.7982	37.741210469977105	-122.49401527111799	(37.7412104699771, -122.494015271118)
178107	178107	186569	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	40	unknown : Yard 19	Tree 1	Private 1			26	Width 0ft		5984763.5541	2104672.9747	37.7581495609485	-122.49575518551701	(37.7581495609485, -122.495755185517)
45810	45810	185494	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	47	unknown : Yard 19	Tree 1	Private 1			25	Width 0ft		5985136.346	2098616.6534	37.74154238350489	-122.494019584309	(37.7415423835049, -122.494019584309)
76180	76180	185454	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	4	unknown : Yard 19	Tree 1	Private 1			25	Width 0ft		5985131.0337	2098272.681	37.7405976170701	-122.494012607503	(37.7405976170701, -122.494012607503)
139638	139638	105139	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	175X ESMERALDA AVE	4	unknown : Yard 19	Tree 1	DPW 2			25			6007213.0	2098808.0	37.7433348108676	-122.41769940776301	(37.7433348108676, -122.417699407763)
143716	143716	105138	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	175X ESMERALDA AVE	4	unknown : Yard 19	Tree 1	DPW 2			25			6007213.0	2098808.0	37.7433348108676	-122.41769940776301	(37.7433348108676, -122.417699407763)
149629	149629	181352	Undocumented 2	Pinus radiata :: Monterey Pine 3	2300 Sunset Blvd	13	unknown : Yard 19	Tree 1	Private 1			25	Width 0ft		5985091.6384	2099018.9366	37.7426443285892	-122.494203809651	(37.7426443285892, -122.494203809651)
178149	178149	181354	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2300 Sunset Blvd	19	unknown : Yard 19	Tree 1	Private 1			25	Width 0ft		5985076.1427	2099074.9211	37.742797140118796	-122.494261514147	(37.7427971401188, -122.494261514147)
182857	182857	181357	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	12	unknown : Yard 19	Tree 1	Private 1			25	Width 0ft		5985137.6741	2098360.3342	37.740838677714294	-122.49399610623999	(37.7408386777143, -122.49399610624)
53374	53374	185417	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2300 Sunset Blvd	33	unknown : Yard 19	Tree 1	Private 1			24	Width 0ft		5985081.6412	2099246.8736	37.7432695969748	-122.49425517376801	(37.7432695969748, -122.494255173768)
145561	145561	105665	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	317X DORADO TER	2	unknown : Yard 19	Tree 1	Private 1			24			5994307.4	2093021.4	37.7267115488018	-122.461903806308	(37.7267115488018, -122.461903806308)
38464	38464	185405	Undocumented 2	Pinus radiata :: Monterey Pine 3	2300 Sunset Blvd	20	unknown : Yard 19	Tree 1	Private 1			23	Width 0ft		5985107.634	2099090.4168	37.7428415299236	-122.494153769583	(37.7428415299236, -122.494153769583)
147019	147019	186536	Undocumented 2	Pinus radiata :: Monterey Pine 3	1501 Sunset Blvd	7	unknown : Yard 19	Tree 1	Private 1			23	Width 0ft		5984741.2571	2104889.1409	37.758741787333705	-122.495848242848	(37.7587417873337, -122.495848242848)
39945	39945	181359	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	31	unknown : Yard 19	Tree 1	Private 1			22	Width 0ft		5985110.4485	2098473.2209	37.741147041149	-122.494098558838	(37.741147041149, -122.494098558838)
68374	68374	185458	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	8	unknown : Yard 19	Tree 1	Private 1			22	Width 0ft		5985125.7214	2098330.4524	37.7407559309555	-122.49403523184401	(37.7407559309555, -122.494035231844)
105735	105735	105666	Undocumented 2	Eucalyptus Spp :: Eucalyptus 40	317X DORADO TER	3	unknown : Yard 19	Tree 1	Private 1			22			5994307.4	2093021.4	37.7267115488018	-122.461903806308	(37.7267115488018, -122.461903806308)
172365	172365	186543	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	14	unknown : Yard 19	Tree 1	Private 1			21	Width 0ft		5984724.0894	2104873.2294	37.7586970933352	-122.495906441969	(37.7586970933352, -122.495906441969)
57083	57083	185434	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2300 Sunset Blvd	50	unknown : Yard 19	Tree 1	Private 1			20	Width 0ft		5985080.6415	2099410.3284	37.7437183411386	-122.494270675975	(37.7437183411386, -122.494270675975)
24279	24279	138266	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2600 GEARY BLVD	34	unknown : Yard 19	Tree 1	Private 1			19	Width 0ft		5999024.6838	2113178.2607	37.7823277718518	-122.44704630425699	(37.7823277718518, -122.447046304257)
34361	34361	185493	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	46	unknown : Yard 19	Tree 1	Private 1			19	Width 0ft		5985113.7687	2098601.3804	37.741499126889295	-122.49409652237499	(37.7414991268893, -122.494096522375)
40115	40115	185505	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	59	unknown : Yard 19	Tree 1	Private 1			19	Width 0ft		5985087.8712	2098781.9991	37.7419935417222	-122.49419937536501	(37.7419935417222, -122.494199375365)
53561	53561	138259	Undocumented 2	Myoporum laetum :: Myoporum 1	2600 GEARY BLVD	27	unknown : Yard 19	Tree 1	Private 1			19	Width 0ft		5999063.9407	2113176.2302	37.782324439437204	-122.44691034713499	(37.7823244394372, -122.446910347135)
37856	37856	185490	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	43	unknown : Yard 19	Tree 1	Private 1			18	Width 0ft		5985127.7135	2098570.8346	37.741416072315204	-122.49404605602501	(37.7414160723152, -122.494046056025)
109114	109114	105137	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	175X ESMERALDA AVE	3	unknown : Yard 19	Tree 1	DPW 2			18			6007213.0	2098808.0	37.7433348108676	-122.41769940776301	(37.7433348108676, -122.417699407763)
67056	67056	138263	Undocumented 2	Myoporum laetum :: Myoporum 1	2600 GEARY BLVD	31	unknown : Yard 19	Tree 1	Private 1			17	Width 0ft		5999038.5591	2113167.7696	37.7822997587534	-122.44699754685101	(37.7822997587534, -122.446997546851)
162935	162935	185479	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	32	unknown : Yard 19	Tree 1	Private 1			17	Width 0ft		5985115.7608	2098477.2051	37.741158291534504	-122.494080484656	(37.7411582915345, -122.494080484656)
57913	57913	185415	Undocumented 2	Pinus radiata :: Monterey Pine 3	2300 Sunset Blvd	31	unknown : Yard 19	Tree 1	Private 1			16	Width 0ft		5985091.6384	2099216.8819	37.743187832897	-122.494218396427	(37.743187832897, -122.494218396427)
135953	135953	185480	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	33	unknown : Yard 19	Tree 1	Private 1			16	Width 0ft		5985125.7214	2098482.5174	37.7411734605092	-122.49404643640601	(37.7411734605092, -122.494046436406)
24948	24948	186573	Undocumented 2	Myoporum laetum :: Myoporum 1	1501 Sunset Blvd	44	unknown : Yard 19	Tree 1	Private 1			15	Width 0ft		5984743.4554	2104652.876	37.758093198452	-122.49582321186399	(37.758093198452, -122.495823211864)
131395	131395	183037	Undocumented 2	Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8	2523 43rd Ave	1	unknown : Yard 19	Tree 1	Private 1			15	Width 0ft		5983009.062000001	2097931.9719	37.7395377337872	-122.50132425344299	(37.7395377337872, -122.501324253443)
137933	137933	185406	Undocumented 2	Pinus radiata :: Monterey Pine 3	2300 Sunset Blvd	21	unknown : Yard 19	Tree 1	Private 1			15	Width 0ft		5985111.1331	2099102.9134	37.742876046964604	-122.494142591708	(37.7428760469646, -122.494142591708)
166154	166154	186488	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1400 Lower Great Hwy	34	unknown : Yard 19	Tree 1	Private 1			15	Width 0ft		5980888.4423	2105382.2174	37.7598692379346	-122.50920942183998	(37.7598692379346, -122.50920942184)
41370	41370	186537	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1501 Sunset Blvd	8	unknown : Yard 19	Tree 1	Private 1			14	Width 0ft		5984743.3507	2104891.2345	37.7587476583889	-122.49584115676501	(37.7587476583889, -122.495841156765)
157249	157249	200733	Undocumented 2	Schinus molle :: California Pepper 138	1462 Oakdale Ave	3	unknown : Yard 19	Tree 1	Private 1			14	Width 0ft		6015790.512	2094948.0194	37.7332150397253	-122.387771048105	(37.7332150397253, -122.387771048105)
66692	66692	185457	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2400 Sunset Blvd	7	unknown : Yard 19	Tree 1	Private 1			13	Width 0ft		5985129.0416	2098307.8751	37.740694134038	-122.494022088477	(37.740694134038, -122.494022088477)
34066	34066	185473	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	25	unknown : Yard 19	Tree 1	Private 1			12	Width 0ft		5985104.4721	2098432.7145	37.741035471775206	-122.494116238038	(37.7410354717752, -122.494116238038)
65848	65848	186549	Undocumented 2	Pinus radiata :: Monterey Pine 3	1501 Sunset Blvd	20	unknown : Yard 19	Tree 1	Private 1			12	Width 0ft		5984751.8298	2104797.3357	37.7584903350171	-122.495804906083	(37.7584903350171, -122.495804906083)
85276	85276	105668	Undocumented 2	Eucalyptus sideroxylon :: Red Ironbark 36	301X DORADO TER	2	unknown : Yard 19	Tree 1	Private 1			12			5994306.4	2092922.0	37.726438562961896	-122.461900058607	(37.7264385629619, -122.461900058607)
98700	98700	105140	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	125X ESMERALDA AVE	1	unknown : Yard 19	Tree 1	DPW 2			12			6007213.0	2098808.0	37.7433348108676	-122.41769940776301	(37.7433348108676, -122.417699407763)
148409	148409	186553	Undocumented 2	Myoporum laetum :: Myoporum 1	1501 Sunset Blvd	24	unknown : Yard 19	Tree 1	Private 1			12	Width 0ft		5984733.406	2104758.3944	37.7583823340555	-122.495865750271	(37.7583823340555, -122.495865750271)
41710	41710	185491	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	44	unknown : Yard 19	Tree 1	Private 1			11	Width 0ft		5985120.4091	2098579.4672	37.7414393477039	-122.494071947824	(37.7414393477039, -122.494071947824)
64302	64302	181358	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	14	unknown : Yard 19	Tree 1	Private 1			11	Width 0ft		5985132.3618	2098384.2396	37.7409040046765	-122.49401623531	(37.7409040046765, -122.49401623531)
137444	137444	142738	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	333 BAY ST	3	unknown : Yard 19	Tree 1	Private 1			11	Width 0ft		6009098.7568	2121462.5595	37.805644845194	-122.412780209055	(37.805644845194, -122.412780209055)
182621	182621	200227	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1079 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			11	Width 0ft		6013668.3894	2090192.8153	37.7200404277679	-122.39477495490499	(37.7200404277679, -122.394774954905)
183109	183109	186548	Undocumented 2	Pinus radiata :: Monterey Pine 3	1501 Sunset Blvd	19	unknown : Yard 19	Tree 1	Private 1			11	Width 0ft		5984713.0979	2104804.2446	37.7585070365446	-122.49593936599	(37.7585070365446, -122.49593936599)
73057	73057	185408	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2300 Sunset Blvd	23	unknown : Yard 19	Tree 1	Private 1			10	Width 0ft		5985102.6354	2099127.4066	37.742942801420796	-122.49417377884599	(37.7429428014208, -122.494173778846)
116266	116266	105664	Undocumented 2	Tree(s) :: 17	317X DORADO TER	1	unknown : Yard 19	Tree 1	Private 1			10			5994307.4	2093021.4	37.7267115488018	-122.461903806308	(37.7267115488018, -122.461903806308)
162943	162943	185411	Undocumented 2	Rhamnus alaternus :: Italian Buckthorn 45	2300 Sunset Blvd	26	unknown : Yard 19	Tree 1	Private 1			10	Width 0ft		5985100.1361	2099184.3909	37.7430991186582	-122.49418661978599	(37.7430991186582, -122.494186619786)
176494	176494	186562	Undocumented 2	Myoporum laetum :: Myoporum 1	1501 Sunset Blvd	33	unknown : Yard 19	Tree 1	Private 1			10	Width 0ft		5984757.692000001	2104711.0786	37.758253840349205	-122.495778269581	(37.7582538403492, -122.495778269581)
52894	52894	186485	Undocumented 2	Myoporum laetum :: Myoporum 1	1400 Lower Great Hwy	25	unknown : Yard 19	Tree 1	Private 1			9	Width 0ft		5980894.6551	2105298.8627	37.7596407361809	-122.50918174518299	(37.7596407361809, -122.509181745183)
53419	53419	186531	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	1501 Sunset Blvd	2	unknown : Yard 19	Tree 1	Private 1			9	Width 0ft		5984751.3064	2104919.289	37.7588251541556	-122.49581571217699	(37.7588251541556, -122.495815712177)
130262	130262	200159	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1043 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			9	Width 0ft		6013947.408	2089985.5634	37.719486864857004	-122.39379597620301	(37.719486864857, -122.393795976203)
146760	146760	186517	Undocumented 2	Pinus halepensis :: Allepo Pine 164	1400 Lower Great Hwy	3	unknown : Yard 19	Tree 1	Private 1			9	Width 0ft		5980906.8218	2104997.2844	37.7588134060814	-122.509117272676	(37.7588134060814, -122.509117272676)
162494	162494	186583	Undocumented 2	Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193	1501 Sunset Blvd	54	unknown : Yard 19	Tree 1	Private 1			9	Width 0ft		5984720.8443	2104581.693	37.757896425499794	-122.49589615853	(37.7578964254998, -122.49589615853)
183984	183984	200230	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1079 Ingerson Ave	4	unknown : Yard 19	Tree 1	Private 1			9	Width 0ft		6013720.7054	2090151.9015	37.7199309952824	-122.394591251483	(37.7199309952824, -122.394591251483)
30516	30516	185495	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	48	unknown : Yard 19	Tree 1	Private 1			8	Width 0ft		5985112.4406	2098617.3174	37.74154280788321	-122.494102288748	(37.7415428078832, -122.494102288748)
58408	58408	186491	Undocumented 2	Myoporum laetum :: Myoporum 1	1400 Lower Great Hwy	21	unknown : Yard 19	Tree 1	Private 1			8	Width 0ft		5980895.1728	2105273.4939	37.759571111269004	-122.509178070846	(37.759571111269, -122.509178070846)
59085	59085	185502	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2400 Sunset Blvd	56	unknown : Yard 19	Tree 1	Private 1			8	Width 0ft		5985117.0889	2098738.1726	37.7418749156753	-122.494095121998	(37.7418749156753, -122.494095121998)
132393	132393	185426	Undocumented 2	Pinus radiata :: Monterey Pine 3	2300 Sunset Blvd	42	unknown : Yard 19	Tree 1	Private 1			8	Width 0ft		5985086.6398	2099317.3541	37.7434634098799	-122.49424308404801	(37.7434634098799, -122.494243084048)
137300	137300	142638	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	333 BAY ST	2	unknown : Yard 19	Tree 1	Private 1			8	Width 0ft		6009068.3546	2121458.9525	37.8056332348144	-122.41288516543301	(37.8056332348144, -122.412885165433)
149365	149365	185409	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2300 Sunset Blvd	24	unknown : Yard 19	Tree 1	Private 1			8	Width 0ft		5985081.6412	2099150.9001	37.7430060796886	-122.494248101225	(37.7430060796886, -122.494248101225)
170252	170252	185410	Undocumented 2	Pinus pinea :: Italian Stone Pine 143	2300 Sunset Blvd	25	unknown : Yard 19	Tree 1	Private 1			8	Width 0ft		5985099.6362	2099155.3989	37.7430194852088	-122.494186211855	(37.7430194852088, -122.494186211855)
48984	48984	200734	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1434 Oakdale Ave	1	unknown : Yard 19	Tree 1	Private 1			7	Width 0ft		6015941.8417	2094834.993	37.7329130736504	-122.387239974213	(37.7329130736504, -122.387239974213)
50995	50995	186509	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1400 Lower Great Hwy	10	unknown : Yard 19	Tree 1	Private 1			7	Width 0ft		5980901.3856	2105130.6001	37.759179132228	-122.509145973072	(37.759179132228, -122.509145973072)
51431	51431	186843	Undocumented 2	Myoporum laetum :: Myoporum 1	1400 Lower Great Hwy	33	unknown : Yard 19	Tree 1	Private 1			7	Width 0ft		5980882.2296	2105351.6713	37.759785000838704	-122.509228639712	(37.7597850008387, -122.509228639712)
55679	55679	200228	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1079 Ingerson Ave	2	unknown : Yard 19	Tree 1	Private 1			7	Width 0ft		6013685.1573	2090181.4131	37.7200100518893	-122.394716195485	(37.7200100518893, -122.394716195485)
133868	133868	185475	Undocumented 2	Pinus radiata :: Monterey Pine 3	2400 Sunset Blvd	27	unknown : Yard 19	Tree 1	Private 1			7	Width 0ft		5985123.7293	2098442.675	37.7410639474436	-122.494050388555	(37.7410639474436, -122.494050388555)
150157	150157	186541	Undocumented 2	Acacia melanoxylon :: Blackwood Acacia 5	1501 Sunset Blvd	12	unknown : Yard 19	Tree 1	Private 1			7	Width 0ft		5984745.863	2104876.5792	37.7587075661518	-122.49583138713601	(37.7587075661518, -122.495831387136)
153024	153024	186626	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1300 Lower Great Hwy	2	unknown : Yard 19	Tree 1	Private 1			7	Width 0ft		5980879.19	2105650.5288	37.7606053983358	-122.509261346313	(37.7606053983358, -122.509261346313)
26814	26814	185398	Undocumented 2	Myoporum laetum :: Myoporum 1	2300 Sunset Blvd	11	unknown : Yard 19	Tree 1	Private 1			6	Width 0ft		5985116.1317	2099019.9363	37.7426485067542	-122.49411919382099	(37.7426485067542, -122.494119193821)

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