Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 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, qCaretaker, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▲	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
869	869	124177	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	8X Almaden Ct	1	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			10	Width 9ft		5995876.0	2112606.0	37.7805760973259	-122.457897862346	(37.7805760973259, -122.457897862346)
67961	67961	206836	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100x Idora Ave	14	Median : Yard 3	Tree 1	DPW 2			66	Width 9ft		5995604.17085	2099350.4744700002	37.7441642119029	-122.45787873812799	(37.7441642119029, -122.457878738128)
157593	157593	124179	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	8X Almaden Ct	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 9ft		5995876.0	2112606.0	37.7805760973259	-122.457897862346	(37.7805760973259, -122.457897862346)
176054	176054	223701	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 9ft		6004786.9856	2096684.12369	37.7373663112035	-122.425936792158	(37.7373663112035, -122.425936792158)
187642	187642	206837	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100x Idora Ave	25	Median : Yard 3	Tree 1	DPW 2			63	Width 9ft		5995840.17489	2099294.03492	37.7440227989188	-122.45705861128401	(37.7440227989188, -122.457058611284)
24519	24519	206820	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	2	Median : Yard 3	Tree 1	DPW 2			28	Width 8ft		5994214.91647	2101031.13143	37.7486989587999	-122.462804340247	(37.7486989587999, -122.462804340247)
25946	25946	126425	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1306x Montgomery St	27	Median : Yard 3	Tree 1	DPW 2			13	Width 8ft		6011438.821769999	2120037.4711599997	37.8018629670555	-122.40458165273701	(37.8018629670555, -122.404581652737)
28285	28285	206831	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	38	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		5994089.87141	2101545.69318	37.7501046117408	-122.463274075037	(37.7501046117408, -122.463274075037)
37578	37578	206829	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	21	Median : Yard 3	Tree 1	DPW 2			7	Width 8ft		5994178.99702	2101301.67665	37.749439738457	-122.46294817423599	(37.749439738457, -122.462948174236)
39759	39759	126424	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1306x Montgomery St	26	Median : Yard 3	Tree 1	DPW 2			15	Width 8ft		6011439.456040001	2120033.94187	37.801853311934096	-122.404579209268	(37.8018533119341, -122.404579209268)
45853	45853	206826	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	15	Median : Yard 3	Tree 1	DPW 2			9	Width 8ft		5994179.978069999	2101226.44078	37.7492332163602	-122.462939324011	(37.7492332163602, -122.462939324011)
47222	47222	206821	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	9	Median : Yard 3	Tree 1	DPW 2			3	Width 8ft		5994174.99878	2101175.06788	37.7490918726007	-122.46295281564501	(37.7490918726007, -122.462952815645)
50688	50688	206828	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	19	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		5994181.13078	2101275.53768	37.749368090385104	-122.462938899523	(37.7493680903851, -122.462938899523)
50746	50746	223761	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	5735 Diamond Heights Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 8ft		6000717.96732	2097049.4600400003	37.738138639977706	-122.44003143312901	(37.7381386399777, -122.440031433129)
68367	68367	206830	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	22	Median : Yard 3	Tree 1	DPW 2			12	Width 8ft		5994177.36915	2101334.5495700003	37.7495299053841	-122.46295618809602	(37.7495299053841, -122.462956188096)
68489	68489	176113	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Santa Barbara Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		5993424.30452	2086604.0814	37.709040256765	-122.464490865868	(37.709040256765, -122.464490865868)
102681	102681	206832	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	41	Median : Yard 3	Tree 1	DPW 2			52	Width 8ft		5994051.70376	2101574.41752	37.750181282555	-122.463408144182	(37.750181282555, -122.463408144182)
133767	133767	206824	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	13	Median : Yard 3	Tree 1	DPW 2			11	Width 8ft		5994175.40211	2101215.70395	37.7492034721717	-122.462954368764	(37.7492034721717, -122.462954368764)
135958	135958	206827	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	17	Median : Yard 3	Tree 1	DPW 2			4	Width 8ft		5994178.983990001	2101248.80101	37.7492945546186	-122.462944383584	(37.7492945546186, -122.462944383584)
153334	153334	206825	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	14	Median : Yard 3	Tree 1	DPW 2			10	Width 8ft		5994178.17156	2101219.86742	37.749215063525895	-122.462945094061	(37.7492150635259, -122.462945094061)
154424	154424	206823	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	12	Median : Yard 3	Tree 1	DPW 2			3	Width 8ft		5994172.44276	2101206.5296099996	37.7491781113008	-122.46296393663401	(37.7491781113008, -122.462963936634)
164069	164069	206833	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	43	Median : Yard 3	Tree 1	DPW 2			38	Width 8ft		5994013.170390001	2101597.32245	37.7502419535254	-122.463543055991	(37.7502419535254, -122.463543055991)
179404	179404	223742	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	921 Alvarado St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			42	Width 8ft		6000348.4325	2102535.54442	37.753181072867	-122.441702702621	(37.753181072867, -122.441702702621)
180749	180749	206822	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	11	Median : Yard 3	Tree 1	DPW 2			5	Width 8ft		5994175.83574	2101201.51334	37.7491645333344	-122.462951839858	(37.7491645333344, -122.462951839858)
182008	182008	223760	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	5735 Diamond Heights Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 8ft		6000715.37701	2097028.89046	37.7380820132743	-122.44003891457899	(37.7380820132743, -122.440038914579)
183568	183568	176102	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	62 Tomaso Ct	5	Front Yard : Yard 7	Tree 1	Private 1			20	Width 8ft		6009173.04361	2086270.9274900001	37.709020763061396	-122.41003717048099	(37.7090207630614, -122.410037170481)
39035	39035	126426	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	3130 Lyon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 7ft		5999057.94156	2119543.59601	37.7998072004939	-122.44738954670099	(37.7998072004939, -122.447389546701)
52668	52668	126427	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	3130 Lyon St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 7ft		5999056.00761	2119563.15995	37.799860807300895	-122.447397647786	(37.7998608073009, -122.447397647786)
155412	155412	223726	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	107 Elsie St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			32	Width 7ft		6007259.15325	2098682.1985299997	37.742991985195104	-122.41753090725	(37.7429919851951, -122.41753090725)
186743	186743	223811	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	80 Digby St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			49	Width 7ft		6002713.41805	2097728.02904	37.7401152293236	-122.433180638776	(37.7401152293236, -122.433180638776)
47379	47379	223759	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	5745 Diamond Heights Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 6ft		6000735.245519999	2096973.3806900003	37.737930727526795	-122.439966240358	(37.7379307275268, -122.439966240358)
50693	50693	176103	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	50 Kelloch Ave	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			14	Width 6ft		6008313.99103	2086238.6229700001	37.7088838754685	-122.413003909814	(37.7088838754685, -122.413003909814)
147594	147594	206851	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	3800 19th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26	Width 6ft		5990535.05203	2090576.85379	37.7197815380709	-122.47476621738899	(37.7197815380709, -122.474766217389)
173594	173594	118511	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	8131 Geary Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 6ft		5981763.277969999	2112328.08269	37.7789921064061	-122.506699014872	(37.7789921064061, -122.506699014872)
24694	24694	206882	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	355 Parnassus Ave	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 5ft		5996132.622880001	2106470.43448	37.7637441750665	-122.456566260324	(37.7637441750665, -122.456566260324)
25920	25920	205918	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	506 Congo St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			33	Width 5ft		6000129.127169999	2095289.54923	37.7332727986918	-122.441941059826	(37.7332727986918, -122.441941059826)
30477	30477	206884	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	355 Parnassus Ave	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 5ft		5996099.70651	2106459.36925	37.7637119028988	-122.456679306927	(37.7637119028988, -122.456679306927)
34630	34630	205915	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	506 Congo St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		6000129.85009	2095267.01455	37.7332109649183	-122.44193694363199	(37.7332109649183, -122.441936943632)
36089	36089	206844	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	488 Ralston St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		5992249.47453	2091186.11142	37.72155360809921	-122.46888442997299	(37.7215536080992, -122.468884429973)
37975	37975	206886	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	355 Parnassus Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 5ft		5996058.56562	2106445.76375	37.76367218344	-122.456820615576	(37.76367218344, -122.456820615576)
44939	44939	223816	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Ohlone Way	1	Back Yard : Yard 13	Tree 1	Private 1			45	Width 5ft		6002135.08017	2096585.1811900001	37.7369444095655	-122.435098574335	(37.7369444095655, -122.435098574335)
51731	51731	206885	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	355 Parnassus Ave	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			28	Width 5ft		5996145.42285	2106474.68713	37.76375658663	-122.45652229698601	(37.76375658663, -122.456522296986)
55002	55002	206883	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	355 Parnassus Ave	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 5ft		5996116.5996	2106463.98861	37.7637255564024	-122.45662121339599	(37.7637255564024, -122.456621213396)
61768	61768	206845	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	401 Victoria St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 5ft		5993220.45249	2089938.0951	37.7181829076919	-122.465437434707	(37.7181829076919, -122.465437434707)
68886	68886	206881	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	355 Parnassus Ave	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 5ft		5996153.64709	2106477.2277900004	37.76376403479561	-122.456494035775	(37.7637640347956, -122.456494035775)
73236	73236	205917	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	506 Congo St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			34	Width 5ft		6000128.91533	2095279.34221	37.7332447605271	-122.441941059855	(37.7332447605271, -122.441941059855)
131737	131737	223810	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	62 Digby St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			42	Width 5ft		6002815.82616	2097712.3092099996	37.7400778751	-122.432825430853	(37.7400778751, -122.432825430853)
132247	132247	206880	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	355 Parnassus Ave	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26	Width 5ft		5996174.6335	2106482.2136	37.7637789293792	-122.456421811215	(37.7637789293792, -122.456421811215)
155152	155152	190988	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	119 Lindsay Cir	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 5ft		6016552.3921	2095641.6616099998	37.7351618174613	-122.385185311358	(37.7351618174613, -122.385185311358)
160056	160056	205906	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	20 Mangels Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			35	Width 5ft		6001210.67203	2095218.5824	37.7331395119639	-122.438196788261	(37.7331395119639, -122.438196788261)
162464	162464	206887	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	355 Parnassus Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 5ft		5996038.42979	2106438.04795	37.7636498416029	-122.456889700613	(37.7636498416029, -122.456889700613)
171054	171054	206834	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	375 Casitas Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 5ft		5995064.96816	2095832.8748700002	37.7344747596986	-122.45948846344	(37.7344747596986, -122.45948846344)
174210	174210	205916	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	506 Congo St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 5ft		6000130.425	2095272.3934400002	37.73322576685489	-122.44193534195401	(37.7332257668549, -122.441935341954)
175707	175707	206835	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	375 Casitas Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 5ft		5995050.15142	2095828.17097	37.7344609919799	-122.459539348883	(37.7344609919799, -122.459539348883)
185031	185031	190987	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	100 Topeka Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		6012468.98817	2095242.94143	37.7338402790006	-122.39927522817	(37.7338402790006, -122.39927522817)
26807	26807	223746	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	591 27th St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 4ft		6002725.9014	2100031.26808	37.7464400956267	-122.43330201489599	(37.7464400956267, -122.433302014896)
35574	35574	206878	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	15 Belmont Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		5996722.9126	2106147.11856	37.762890304760205	-122.454501283825	(37.7628903047602, -122.454501283825)
41645	41645	206879	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	15 Belmont Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		5996709.23846	2106155.1061299997	37.7629114523342	-122.45454915471599	(37.7629114523342, -122.454549154716)
45479	45479	206804	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	66 Aerial Way	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 4ft		5992257.723230001	2102553.22068	37.7527653009777	-122.46968303065901	(37.7527653009777, -122.469683030659)
49800	49800	206806	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	175 Garcia Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			44	Width 4ft		5994639.44486	2099406.32417	37.7442620887181	-122.461218572898	(37.7442620887181, -122.461218572898)
53358	53358	250696	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	877 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5985597.38635	2114946.90963	37.786407669826495	-122.493628505377	(37.7864076698265, -122.493628505377)
61811	61811	223751	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	3900 22nd St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		6002420.17211	2102985.85951	37.7545353547237	-122.43457041690901	(37.7545353547237, -122.434570416909)
105567	105567	126413	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2601 Vallejo St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6001029.975	2117557.6331599997	37.7944667608931	-122.440423085162	(37.7944667608931, -122.440423085162)
137094	137094	223733	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	799 Duncan St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6001506.768759999	2099670.7244	37.7453808903115	-122.43749181510401	(37.7453808903115, -122.437491815104)
146504	146504	223801	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2541 Diamond St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		6002300.3655199995	2097102.16795	37.73837331985921	-122.434564064986	(37.7383733198592, -122.434564064986)
156012	156012	223745	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	591 27th St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			8	Width 4ft		6002706.0311900005	2100029.7354	37.746434759975	-122.433370614261	(37.746434759975, -122.433370614261)
157404	157404	126412	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1900 Jefferson St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 4ft		6000088.69563	2121303.7240299997	37.804698887418105	-122.443949299933	(37.8046988874181, -122.443949299933)
168655	168655	223734	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	4379 Cesar Chavez St	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 4ft		6001460.85322	2100259.68732	37.7469954324125	-122.43769275603901	(37.7469954324125, -122.437692756039)
172549	172549	223727	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	295 Coso Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 4ft		6007771.677	2099478.1901599998	37.745206426340204	-122.415815087109	(37.7452064263402, -122.415815087109)
174433	174433	223744	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	591 27th St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 4ft		6002700.253169999	2100030.0951900003	37.746435420069396	-122.433390619685	(37.7464354200694, -122.433390619685)
176606	176606	250697	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	877 El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5985607.20317	2114948.81702	37.7864134812469	-122.493594682746	(37.7864134812469, -122.493594682746)
180025	180025	250698	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	877 El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5985618.29441	2114950.69693	37.78641929175679	-122.49355644897601	(37.7864192917568, -122.493556448976)
184103	184103	223730	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	425 Burnett Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 4ft		5999661.00739	2103457.53905	37.7556734530948	-122.444146194814	(37.7556734530948, -122.444146194814)
185428	185428	205905	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	125 Hamerton Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			51	Width 4ft		6001385.86644	2095459.79202	37.7338117803923	-122.437608363645	(37.7338117803923, -122.437608363645)
484	484	205880	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	44 Mendosa Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			43	Width 3ft		5993348.04769	2101170.42115	37.7490314462559	-122.46581205990499	(37.7490314462559, -122.465812059905)
5088	5088	206891	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1675x 15th Ave	1	Sidewalk: Property side : Cutout 5	Tree 1	DPW 2			24	Width 3ft		5991393.559640001	2103864.47578	37.756315678748706	-122.472767037095	(37.7563156787487, -122.472767037095)
24024	24024	206902	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	901 Monterey Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5996057.83075	2094626.65779	37.7312198182223	-122.45596865725	(37.7312198182223, -122.45596865725)
24438	24438	118836	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	600 46th Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 3ft		5981651.25866	2111619.12831	37.77703893001029	-122.50703392298401	(37.7770389300103, -122.507033922984)
26075	26075	206897	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Pizarro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5995088.9482	2093956.7124599998	37.729324653504	-122.459269738418	(37.729324653504, -122.459269738418)
26174	26174	206899	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	901 Monterey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5996026.341440001	2094620.2534900003	37.731200426151794	-122.456077057924	(37.7312004261518, -122.456077057924)
27038	27038	119401	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	3150 Cabrillo St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		5985750.26334	2110481.7384	37.774156534172505	-122.492770599571	(37.7741565341725, -122.492770599571)
27465	27465	118640	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	495 45th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		5981891.5492	2112442.21245	37.7793130253265	-122.50626374607401	(37.7793130253265, -122.506263746074)
28508	28508	206910	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	901 Valdez Ave	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5996121.33012	2094628.67592	37.7312290039204	-122.455749275714	(37.7312290039204, -122.455749275714)
30768	30768	223720	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Crescent Ave	3	Side Yard : Yard 17	Tree 1	Private 1			15	Width 3ft		6005295.72226	2095902.89747	37.7352499770995	-122.424122309196	(37.7352499770995, -122.424122309196)
31803	31803	223794	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	701 Church St	30	Front Yard : Yard 7	Tree 1	Private 1			21	Width 3ft		6004330.71364	2104618.42618	37.7591262696742	-122.42807959421002	(37.7591262696742, -122.42807959421)
36835	36835	205892	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	25 Stanford Heights Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		5997819.94601	2095725.4811900002	37.734337906251504	-122.44995590246	(37.7343379062515, -122.44995590246)
37595	37595	205891	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	25 Stanford Heights Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		5997820.03941	2095729.96315	37.73435021798711	-122.44995590246201	(37.7343502179871, -122.449955902462)
38550	38550	205889	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	25 Stanford Heights Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		5997824.88709	2095746.51675	37.734395947598	-122.449940335175	(37.734395947598, -122.449940335175)
39316	39316	206908	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	901 Monterey Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5996107.30709	2094636.40332	37.7312494167135	-122.455798313936	(37.7312494167135, -122.455798313936)
40530	40530	205896	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	88 Cresta Vista Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5995555.85476	2096185.3340599998	37.73547073996521	-122.457816813517	(37.7354707399652, -122.457816813517)
40580	40580	223723	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2900 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010018.43827	2101654.33057	37.751307680712294	-122.40819958573499	(37.7513076807123, -122.408199585735)
41442	41442	205894	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1110 Teresita Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 3ft		5998252.60091	2095669.89095	37.7342100154709	-122.44845607881099	(37.7342100154709, -122.448456078811)
41855	41855	205878	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2270x 09th Ave	1	Median : Cutout 11	Tree 1	DPW 2			29	Width 3ft		5993161.62229	2100566.3961	37.747362192108795	-122.46641282052	(37.7473621921088, -122.46641282052)
43049	43049	223777	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	615 Sanchez St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			32	Width 3ft		6003689.83416	2104690.60407	37.7592881728241	-122.430301210155	(37.7592881728241, -122.430301210155)
43231	43231	206900	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	901 Monterey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5996039.46255	2094622.9528599998	37.731208591101705	-122.45603189126699	(37.7312085911017, -122.456031891267)
43379	43379	223787	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	4404 20th St	9	: Yard 23	Tree 1	Private 1			44	Width 3ft		6003650.35726	2104229.2336	37.75801912330729	-122.430404821951	(37.7580191233073, -122.430404821951)
46806	46806	206904	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	901 Monterey Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5996071.34052	2094630.09255	37.73123002464121	-122.45592220005301	(37.7312300246412, -122.455922200053)
48614	48614	206903	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	901 Monterey Blvd	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5996066.09368	2094629.08698	37.7312269624471	-122.455940266542	(37.7312269624471, -122.455940266542)
49990	49990	206893	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	380 Santa Clara Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 3ft		5993147.429930001	2095452.0093599998	37.7333185543917	-122.46609030381799	(37.7333185543917, -122.466090303818)
50259	50259	205901	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	36 Edgehill Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39	Width 3ft		5994699.39555	2098973.9610599997	37.7430783776592	-122.460979946789	(37.7430783776592, -122.460979946789)

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