Street_Tree_List

Data source: data.sfgov.org

340 rows where qSiteInfo = 2 and qSpecies = 60 sorted by Location

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▼
47892	47892	176012	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	460 Peninsula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 4ft		6012147.1719	2086483.56891	37.709770881279205	-122.399773002936	(37.7097708812792, -122.399773002936)
67584	67584	176011	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	114 Gillette Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		6013066.75306	2086848.56663	37.7108243147535	-122.39662031080499	(37.7108243147535, -122.396620310805)
175808	175808	206308	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	222 Sadowa St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5994765.8705	2087778.7663099999	37.712342910867	-122.459939285491	(37.712342910867, -122.459939285491)
23485	23485	206309	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	226 Sadowa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		5994744.569130001	2087779.6169999999	37.712344021541796	-122.46001297051599	(37.7123440215418, -122.460012970516)
79797	79797	114240	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 60	99x FONT BLVD	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990948.0	2088640.0	37.71448733391829	-122.473197635313	(37.7144873339183, -122.473197635313)
105245	105245	114225	Significant Tree 6	Corymbia ficifolia :: Red Flowering Gum 60	99x FONT BLVD	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			48			5990948.0	2088640.0	37.71448733391829	-122.473197635313	(37.7144873339183, -122.473197635313)
161995	161995	176044	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21			5990534.22824	2089263.3063400001	37.7161748133009	-122.47467324639099	(37.7161748133009, -122.474673246391)
179359	179359	176053	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			5989219.15665	2089312.55172	37.7162337395604	-122.479222313162	(37.7162337395604, -122.479222313162)
55378	55378	176054	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5989245.31981	2089315.2477799999	37.7162426617475	-122.47913207879101	(37.7162426617475, -122.479132078791)
62427	62427	176057	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989281.98257	2089351.5172299999	37.7163443777799	-122.479008007435	(37.7163443777799, -122.479008007435)
154485	154485	176056	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5989277.7182599995	2089365.90518	37.7163836358725	-122.47902379861401	(37.7163836358725, -122.479023798614)
187875	187875	176055	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5989270.85841	2089380.9981799999	37.716424679123705	-122.479048612712	(37.7164246791237, -122.479048612712)
173612	173612	176050	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989206.756130001	2089405.10082	37.7164871361381	-122.47927194136999	(37.7164871361381, -122.47927194137)
160065	160065	176051	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			5989218.52603	2089406.1518400002	37.7164907055632	-122.479231336085	(37.7164907055632, -122.479231336085)
40789	40789	176052	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			5989234.209980001	2089407.1197400002	37.716494274064495	-122.47917719598	(37.7164942740645, -122.47917719598)
40567	40567	176049	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989054.79394	2089564.29309	37.716915411303	-122.479808833919	(37.716915411303, -122.479808833919)
184066	184066	176047	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5988958.7133	2089588.42281	37.7169760831658	-122.480142699133	(37.7169760831658, -122.480142699133)
38217	38217	176045	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20			5990157.58815	2089581.85402	37.7170276349961	-122.475998332672	(37.7170276349961, -122.475998332672)
69208	69208	176048	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989010.93647	2089619.81285	37.7170653066825	-122.479964486788	(37.7170653066825, -122.479964486788)
166239	166239	176046	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5990073.98867	2089647.08481	37.7172018948419	-122.47629205486	(37.7172018948419, -122.47629205486)
73344	73344	176058	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Crespi Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			5989854.78687	2090110.33741	37.7184611570226	-122.47708355628599	(37.7184611570226, -122.477083556286)
185959	185959	176042	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			5989234.3289	2090278.8910299998	37.7188879474116	-122.47924052173599	(37.7188879474116, -122.479240521736)
65336	65336	176043	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			5989267.954919999	2090414.23117	37.7192615104927	-122.47913418591499	(37.7192615104927, -122.479134185915)
163843	163843	176041	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20			5989102.080019999	2090436.91452	37.71931415859461	-122.479709205217	(37.7193141585946, -122.479709205217)
153599	153599	176040	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			5989182.3515099995	2090508.47222	37.719515300969206	-122.479436972335	(37.7195153009692, -122.479436972335)
85205	85205	104946	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	532 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
86917	86917	104944	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	532 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
88948	88948	104951	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
95555	95555	104945	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	532 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
109251	109251	104950	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
112803	112803	104952	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	600 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
146250	146250	104914	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	614 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
71511	71511	104957	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	759 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
90415	90415	104958	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	759 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
94825	94825	104959	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	759 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
98987	98987	104915	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	701 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
105850	105850	104948	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	535 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
122291	122291	104956	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	759 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
144026	144026	104949	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	535 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
26380	26380	206314	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3698 19th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 3ft		5990493.86406	2091288.56287	37.721733327719	-122.47496051233699	(37.721733327719, -122.474960512337)
37837	37837	212265	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		5991309.65497	2091334.85858	37.7219076882615	-122.472143937306	(37.7219076882615, -122.472143937306)
51329	51329	212266	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5991321.10084	2091550.66305	37.722500896380794	-122.472120094478	(37.7225008963808, -122.472120094478)
156698	156698	212267	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 3ft		5991324.60743	2091598.04396	37.7226311955691	-122.472111425016	(37.7226311955691, -122.472111425016)
62310	62310	212268	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991336.52605	2091747.02554	37.7230409518531	-122.47208107919201	(37.7230409518531, -122.472081079192)
162121	162121	212269	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5991336.99959	2091769.4940900002	37.7231026723341	-122.47208107919501	(37.7231026723341, -122.472081079195)
155854	155854	212270	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5991340.77769	2091800.00989	37.723186679801294	-122.47207024236201	(37.7231866798013, -122.472070242362)
187793	187793	212271	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	20	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		5991347.76496	2091893.5227299999	37.7234438472491	-122.47205290164699	(37.7234438472491, -122.472052901647)
176519	176519	212272	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	851 Junipero Serra Blvd	21	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5991349.46561	2091914.7165299999	37.7235021385885	-122.4720485669	(37.7235021385885, -122.4720485669)
178383	178383	212273	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 3ft		5991365.36013	2092192.86214	37.7242667772795	-122.472013886343	(37.7242667772795, -122.472013886343)
136395	136395	212274	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5991367.86309	2092252.1264400003	37.724429647187705	-122.472009551601	(37.7244296471877, -122.472009551601)
175135	175135	212275	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 3ft		5991369.83991	2092286.4262	37.7245239402122	-122.47200521689	(37.7245239402122, -122.47200521689)
54224	54224	212276	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5991374.36791	2092352.51618	37.724705668918205	-122.471994379137	(37.7247056689182, -122.471994379137)
35214	35214	206315	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3646 19th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5990563.4574	2092379.2095700002	37.72473200467321	-122.474799514783	(37.7247320046732, -122.474799514783)
163014	163014	212277	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991382.2904199995	2092479.8113099998	37.725055648191	-122.471976265919	(37.725055648191, -122.471976265919)
30863	30863	212278	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	21	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991401.80678	2092732.18805	37.725749741332706	-122.47192718629	(37.7257497413327, -122.47192718629)
154093	154093	212279	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		5991402.240809999	2092752.78363	37.7258063167904	-122.4719271863	(37.7258063167904, -122.4719271863)
185333	185333	212280	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	24	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5991403.39821	2092807.7044099998	37.725957182569296	-122.471927186316	(37.7259571825693, -122.471927186316)
179527	179527	212281	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	26	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 3ft		5991407.58411	2092857.5665	37.726094333681104	-122.47191634855801	(37.7260943336811, -122.471916348558)
159831	159831	212282	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	30	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5991411.32325	2092975.49462	37.7264183513201	-122.471912013829	(37.7264183513201, -122.471912013829)
147406	147406	212283	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	751 Junipero Serra Blvd	31	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991413.76911	2093002.29122	37.726492069641	-122.47190551083	(37.726492069641, -122.47190551083)
50060	50060	206316	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3578 19th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		5990600.84966	2093024.2495	37.726505289668204	-122.47471731316601	(37.7265052896682, -122.474717313166)
149912	149912	206317	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3578 19th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 3ft		5990608.28598	2093089.7399	37.7266855407931	-122.474696384147	(37.7266855407931, -122.474696384147)
154269	154269	212284	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5991427.0234	2093184.95308	37.726994380560896	-122.471872998563	(37.7269943805609, -122.471872998563)
167785	167785	212285	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991430.26688	2093219.84913	37.7270903840969	-122.471864328184	(37.7270903840969, -122.471864328184)
70215	70215	212286	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		5991449.46468	2093506.02846	37.7278772720107	-122.47181880990101	(37.7278772720107, -122.471818809901)
155041	155041	212287	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5991452.02	2093567.7865099998	37.728046992061	-122.471814475179	(37.728046992061, -122.471814475179)
37176	37176	212288	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5991464.21777	2093759.8319	37.728575006528295	-122.471786297603	(37.7285750065283, -122.471786297603)
154943	154943	206369	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Hazelwood Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 3ft		5996628.41622	2093653.8461099998	37.728581442980705	-122.45392582384301	(37.7285814429807, -122.453925823843)
32481	32481	212289	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	20	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5991466.68956	2093787.8758599998	37.7286521512557	-122.47177979551901	(37.7286521512557, -122.471779795519)
73816	73816	212290	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	551 Junipero Serra Blvd	21	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5991468.4297400005	2093810.9403799998	37.7287155813527	-122.471775459876	(37.7287155813527, -122.471775459876)
61517	61517	201542	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	601 Innes Ave	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28			6020585.50312	2093400.1960900002	37.7292294638519	-122.37108624845699	(37.7292294638519, -122.371086248457)
186413	186413	212291	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	501 Junipero Serra Blvd	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 3ft		5991484.87009	2094085.3091099998	37.7294698805282	-122.47173861197099	(37.7294698805282, -122.471738611971)
36702	36702	212005	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			49	Width 8ft		5991983.8699	2094464.4262700002	37.73053970054001	-122.470041130814	(37.73053970054, -122.470041130814)
130028	130028	212006	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 8ft		5992010.735830001	2094513.66947	37.7306764631302	-122.46995183623501	(37.7306764631302, -122.469951836235)
35345	35345	212007	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 8ft		5992022.6744800005	2094535.4646599998	37.7307369974034	-122.469912149146	(37.7307369974034, -122.469912149146)
52822	52822	212008	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5992037.66207	2094565.76948	37.730821073223	-122.469862540745	(37.730821073223, -122.469862540745)
37267	37267	212009	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 8ft		5992050.07919	2094590.8204299998	37.730890574625896	-122.469821436321	(37.7308905746259, -122.469821436321)
28487	28487	212010	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 8ft		5992076.0582	2094714.7951200001	37.7312324797943	-122.46974064571998	(37.7312324797943, -122.46974064572)
135601	135601	212011	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	302 San Fernando Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 8ft		5992086.28317	2094888.90865	37.731711143057396	-122.469717967521	(37.7317111430574, -122.469717967521)
175675	175675	206420	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1400 Monterey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5993578.268619999	2095109.23905	37.7324022387669	-122.464575906676	(37.7324022387669, -122.464575906676)
28874	28874	218292	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39			5991223.38049	2095418.74528	37.73311602796429	-122.472739784911	(37.7331160279643, -122.472739784911)
153594	153594	218291	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5991233.57986	2095433.30624	37.7331565991011	-122.472705584612	(37.7331565991011, -122.472705584612)
58398	58398	218290	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			34			5991251.16534	2095467.63693	37.733251880466	-122.472647289653	(37.733251880466, -122.472647289653)
136436	136436	205517	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	195 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 6ft		5992410.736190001	2095460.08324	37.733298193757896	-122.468637822402	(37.7332981937579, -122.468637822402)
130516	130516	205518	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	195 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5992409.14272	2095474.46563	37.733337592154996	-122.468644377549	(37.733337592155, -122.468644377549)
162685	162685	205519	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	185 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 6ft		5992407.8827599995	2095504.6997900002	37.733420534815394	-122.468650932689	(37.7334205348154, -122.468650932689)
55064	55064	205520	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	185 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		5992406.58336	2095533.04722	37.733498294707104	-122.46865748696199	(37.7334982947071, -122.468657486962)
70360	70360	205521	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	175 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 6ft		5992404.60311	2095547.05978	37.7335366552975	-122.468665352434	(37.7335366552975, -122.468665352434)
152918	152918	211991	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	175 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 6ft		5992403.27169	2095573.8973	37.733610267501895	-122.468671907605	(37.7336102675019, -122.468671907605)
53311	53311	211992	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	163 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 6ft		5992401.19029	2095601.1282400002	37.7336849166126	-122.468681084285	(37.7336849166126, -122.468681084285)
151782	151782	218282	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5991361.16684	2095634.8342900001	37.7337173290882	-122.47227917194901	(37.7337173290882, -122.472279171949)
27171	27171	211993	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	163 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 6ft		5992397.64836	2095631.03278	37.7337668223846	-122.468695504899	(37.7337668223846, -122.468695504899)
188959	188959	217849	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Woodacre Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33			5991387.06493	2095679.62189	37.7338418033391	-122.47219289908001	(37.7338418033391, -122.47219289908)
168582	168582	211994	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	155 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5992403.615809999	2095680.37248	37.7339026415898	-122.468678462736	(37.7339026415898, -122.468678462736)
91050	91050	97402	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	2 Stanford Heights Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5997807.0	2095590.8	37.7339673631019	-122.449990957178	(37.7339673631019, -122.449990957178)
109801	109801	97401	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	2 Stanford Heights Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5997807.0	2095590.8	37.7339673631019	-122.449990957178	(37.7339673631019, -122.449990957178)
154648	154648	211995	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	139 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5992400.12386	2095730.66617	37.7340405337493	-122.46869419369101	(37.7340405337493, -122.468694193691)
155689	155689	211996	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	135 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		5992399.479180001	2095754.0907599998	37.7341048145672	-122.468698126425	(37.7341048145672, -122.468698126425)
135766	135766	211997	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	135 San Leandro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5992398.43952	2095776.76806	37.7341670206952	-122.468703370368	(37.7341670206952, -122.468703370368)
157128	157128	212004	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	135 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		5992880.81315	2095779.08404	37.7342012344874	-122.467035834859	(37.7342012344874, -122.467035834859)

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