Street_Tree_List

Data source: data.sfgov.org

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

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord ▼	Latitude	Longitude	Location
129	129	20398	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	43	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
272	272	251264	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
277	277	251265	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
293	293	251262	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
300	300	251263	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
549	549	251321	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	100X Monument Way	1	Unaccepted Street : Yard 14	Tree 1	Private 1
618	618	20377	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
682	682	251365	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	138x Gladeview Way	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1
712	712	251366	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	138x Gladeview Way	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1
713	713	251364	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	138x Gladeview Way	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1
886	886	19568	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
1098	1098	251438	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2501X Santiago St	1	Median : Yard 3	Tree 1	DPW 2
1898	1898	20392	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
5557	5557	20407	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	52	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
5855	5855	19776	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY18	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	50ST
6006	6006	20312	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	101X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
6023	6023	19905	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
6115	6115	20296	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6147	6147	19906	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
6357	6357	20291	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
6360	6360	20424	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6399	6399	20412	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6517	6517	19907	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
6533	6533	19565	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	-11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	100ST
6834	6834	19955	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	2ST
6952	6952	19935	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
7006	7006	20417	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
7548	7548	20317	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	101X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
7732	7732	19948	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	25ST
7834	7834	119605	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	299x Avalon Ave	1	Front Yard : Yard 7	Tree 1	Private 1
7886	7886	19945	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	25ST
7938	7938	19700	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY11	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	40ST
8196	8196	20297	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
8406	8406	20373	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
8739	8739	20365	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
8750	8750	20413	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
8903	8903	19566	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	-9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	100ST
9072	9072	19804	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY22	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	20
9473	9473	20455	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	495X Sunset Blvd	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
9584	9584	20422	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
10571	10571	19570	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
10674	10674	19936	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
10701	10701	20452	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	495X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
10705	10705	19569	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
10816	10816	19910	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
10949	10949	19933	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
11220	11220	19950	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
11591	11591	20428	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	40
11826	11826	20419	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
12151	12151	19869	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY33	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	25ST
12480	12480	20434	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
12812	12812	19953	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
13158	13158	19753	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY15	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
13184	13184	20013	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY47	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	100ST
14158	14158	20429	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	30
14206	14206	19813	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY24	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
14400	14400	19934	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
14425	14425	19694	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY7	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	12ST
14506	14506	20366	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
14521	14521	20280	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
14597	14597	20303	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	50X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14923	14923	20430	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	30
14992	14992	19932	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
15767	15767	19699	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY11	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	40ST
15771	15771	19908	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
15978	15978	19943	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
16086	16086	20423	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
16424	16424	19949	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	25ST
16454	16454	20294	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
16608	16608	19951	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
16721	16721	19947	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	25ST
16878	16878	19909	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
17092	17092	19978	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY45	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	30ST
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)
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)
66895	66895	176112	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	35 Tomaso Ct	4	Side Yard : Yard 17	Tree 1	Private 1			15	Width 3ft		6009187.4096	2086275.4475900002	37.7090339795175	-122.409987838189	(37.7090339795175, -122.409987838189)
168435	168435	176111	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	520 Carter St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			64			6005239.18473	2086329.3019599998	37.7089597755375	-122.423637326411	(37.7089597755375, -122.423637326411)
183973	183973	176110	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	520 Carter St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			47			6005248.37143	2086351.63031	37.709021603021604	-122.423607162245	(37.7090216030216, -122.423607162245)
24565	24565	176109	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	520 Carter St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			6005252.95246	2086362.20208	37.7090508894465	-122.42359208063299	(37.7090508894465, -122.423592080633)
172551	172551	176108	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	520 Carter St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			6005255.13814	2086372.0334299998	37.7090780076251	-122.4235852251	(37.7090780076251, -122.4235852251)
92932	92932	86903	Permitted Site 1	Cupressus macrocarpa :: Monterey Cypress 47	233 Drake St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/30/2007 12:00:00 AM		3x3	Permit Number 49863	6001780.0	2086418.0	37.7090074518569	-122.435599089406	(37.7090074518569, -122.435599089406)
62380	62380	176134	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	800 John Muir Dr	2	: 4	Tree 1	Private 1			16	Width 0ft		5987222.73644	2086464.9299599999	37.7082987351809	-122.48591391940901	(37.7082987351809, -122.485913919409)
48038	48038	176133	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	800 John Muir Dr	1	: 4	Tree 1	Private 1			10	Width 0ft		5987205.94604	2086467.2590400001	37.708304151783295	-122.48597211903099	(37.7083041517833, -122.485972119031)
160483	160483	176136	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	800 John Muir Dr	4	: 4	Tree 1	Private 1			11	Width 0ft		5987247.74108	2086476.2363	37.7083312366754	-122.48582833093599	(37.7083312366754, -122.485828330936)
59353	59353	176135	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	800 John Muir Dr	3	: 4	Tree 1	Private 1			13	Width 0ft		5987227.516530001	2086480.11804	37.7083407164149	-122.485898513129	(37.7083407164149, -122.485898513129)
161785	161785	176137	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	800 John Muir Dr	5	: 4	Tree 1	Private 1			11	Width 0ft		5987255.345	2086484.45942	37.708354258405	-122.485802654386	(37.708354258405, -122.485802654386)
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)
999	999	251422	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	480x De Long St		Front Yard : Yard 7	Tree 1	Private 1				3x3		5992963.0	2086633.0	37.709093057147996	-122.466087289133	(37.709093057148, -122.466087289133)
77993	77993	12500	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1200X Lake Merced Blvd	2	Median : Cutout 11	Tree 1	DPW 2			6	8		5987438.4549992	2087542.2692131	37.7112694082243	-122.485247377649	(37.7112694082243, -122.485247377649)
90329	90329	12501	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1200X Lake Merced Blvd	3	Median : Cutout 11	Tree 1	DPW 2			6	8		5987438.4549992	2087542.2692131	37.7112694082243	-122.485247377649	(37.7112694082243, -122.485247377649)
91431	91431	12502	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1200X Lake Merced Blvd	4	Median : Cutout 11	Tree 1	DPW 2			12	8		5987438.4549992	2087542.2692131	37.7112694082243	-122.485247377649	(37.7112694082243, -122.485247377649)
156086	156086	206846	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Brotherhood Way	1	: 4	Tree 1	Private 1			25	Width 0ft		5993694.0595	2087568.4676400002	37.7117037797802	-122.463628505047	(37.7117037797802, -122.463628505047)
136019	136019	206848	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Brotherhood Way	3	: 4	Tree 1	Private 1			11	Width 0ft		5993673.9414	2087579.0167599998	37.7117315859181	-122.46369880328001	(37.7117315859181, -122.46369880328)
137802	137802	206847	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Brotherhood Way	2	: 4	Tree 1	Private 1			16	Width 0ft		5993688.70591	2087590.2808700001	37.711763365253894	-122.463648590504	(37.7117633652539, -122.463648590504)
141985	141985	111287	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	450 ROLPH ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x3		6002226.0	2087613.0	37.7123139824471	-122.434143019741	(37.7123139824471, -122.434143019741)
110973	110973	106962	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	218 SADOWA ST	3	Sidewalk: Property side : Cutout 5	Tree 1	Private 1			22			5994814.0	2087793.9	37.7123872323548	-122.459774032106	(37.7123872323548, -122.459774032106)
22920	22920	251148	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	625 Brotherhood Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5991521.0	2087959.0	37.7126506341802	-122.471167551627	(37.7126506341802, -122.471167551627)
22923	22923	251152	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	625 Brotherhood Way	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5991521.0	2087959.0	37.7126506341802	-122.471167551627	(37.7126506341802, -122.471167551627)
22924	22924	251154	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	625 Brotherhood Way	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5991521.0	2087959.0	37.7126506341802	-122.471167551627	(37.7126506341802, -122.471167551627)
22925	22925	251150	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	625 Brotherhood Way	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5991521.0	2087959.0	37.7126506341802	-122.471167551627	(37.7126506341802, -122.471167551627)

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