Street_Tree_List

Data source: data.sfgov.org

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

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
33693	33693	118440	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	5201 Anza St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5982501.27886	2111662.63166	37.7772084016294	-122.504096711396	(37.7772084016294, -122.504096711396)
164496	164496	119006	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	599 43rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 4ft		5982537.41596	2111769.70858	37.7775045285794	-122.50397963664801	(37.7775045285794, -122.503979636648)
148935	148935	117774	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3749 Clement St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 5ft		5983871.99763	2113113.23064	37.7812718378682	-122.49946225972602	(37.7812718378682, -122.499462259726)
178409	178409	117974	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	428 38th Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5984093.087730001	2112943.61137	37.7808190819455	-122.498684874737	(37.7808190819455, -122.498684874737)
67841	67841	117977	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	428 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5984094.5727	2112925.96733	37.7807707236381	-122.4986784338	(37.7807707236381, -122.4986784338)
31258	31258	118000	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	7 Shore View Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5984651.74201	2112846.53753	37.7805852938125	-122.49674508055	(37.7805852938125, -122.49674508055)
42507	42507	118050	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	451 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		5984672.88957	2112829.17852	37.7805388700497	-122.496670640749	(37.7805388700497, -122.496670640749)
150736	150736	118051	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	451 36th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 8ft		5984674.55731	2112758.40863	37.7803446541387	-122.496659647186	(37.7803446541387, -122.496659647186)
34752	34752	183980	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1692 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 0ft		5985341.0245	2103687.7125	37.7554781047189	-122.493685471877	(37.7554781047189, -122.493685471877)
162939	162939	183979	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 Moraga St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 0ft		5985375.7968	2103670.995	37.755434237268894	-122.49356398857901	(37.7554342372689, -122.493563988579)
38426	38426	250669	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	710 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5986459.66252	2114899.76935	37.786328641889604	-122.49064181907801	(37.7863286418896, -122.490641819078)
185329	185329	250877	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	111 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5986466.719269999	2114758.04628	37.785939923445795	-122.49060697393999	(37.7859399234458, -122.49060697394)
153657	153657	250878	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	111 30th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5986467.64007	2114737.19206	37.785882717559794	-122.490602253393	(37.7858827175598, -122.490602253393)
64763	64763	250863	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	182 30th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		5986521.03472	2114531.78517	37.785321848163	-122.490402408767	(37.785321848163, -122.490402408767)
60705	60705	250862	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	182 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 4ft		5986521.14274	2114515.47743	37.7852770781159	-122.49040083493401	(37.7852770781159, -122.490400834934)
164039	164039	250747	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 Lake St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5986546.42612	2114480.8056900003	37.7851833561615	-122.490310811904	(37.7851833561615, -122.490310811904)
26629	26629	250746	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		5986565.35449	2114477.9632599996	37.7851766571216	-122.490245117336	(37.7851766571216, -122.490245117336)
23683	23683	250745	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2850 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 4ft		5986584.92122	2114476.3273400003	37.7851733080538	-122.490177303062	(37.7851733080538, -122.490177303062)
70113	70113	250663	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5986609.275330001	2114999.44135	37.7866110505914	-122.49013153834801	(37.7866110505914, -122.490131538348)
69453	69453	250744	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2840 Lake St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5986605.68633	2114473.44554	37.785166608101	-122.490105251155	(37.785166608101, -122.490105251155)
52214	52214	250662	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5986620.51071	2115008.0910900002	37.7866354563952	-122.490093303661	(37.7866354563952, -122.490093303661)
158270	158270	250661	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5986629.196690001	2115016.79506	37.786659862212794	-122.490063893129	(37.7866598622128, -122.490063893129)
152428	152428	250743	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2840 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5986628.9132900005	2114471.1216	37.7851615835861	-122.490024723187	(37.7851615835861, -122.490024723187)
160281	160281	250742	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2840 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 4ft		5986642.93068	2114467.77379	37.7851532099925	-122.489975981713	(37.7851532099925, -122.489975981713)
70937	70937	250741	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2820 Lake St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5986676.6053	2114467.05765	37.785153209986895	-122.489859426897	(37.7851532099869, -122.489859426897)
46109	46109	250740	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2820 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5986687.60002	2114465.60377	37.785149860023	-122.48982128213899	(37.785149860023, -122.489821282139)
168078	168078	250739	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2820 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 4ft		5986710.27993	2114466.3415599996	37.785153210004	-122.48974287205	(37.785153210004, -122.48974287205)
132020	132020	250879	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	123 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5986776.16352	2114759.61772	37.7859623084516	-122.489536511807	(37.7859623084516, -122.489536511807)
58359	58359	250880	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	123 29th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5986777.36802	2114746.25153	37.7859256790604	-122.489531361397	(37.7859256790604, -122.489531361397)
137115	137115	250622	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	122 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 4ft		5987113.07989	2115137.65362	37.7870199498697	-122.48839868145001	(37.7870199498697, -122.48839868145)
68348	68348	250621	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	122 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5987113.38286	2115127.17746	37.7869912030255	-122.48839686305	(37.7869912030255, -122.48839686305)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
63740	63740	122144	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	25 15th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 8ft		5991132.251759999	2114855.8727599997	37.7864799443229	-122.47447281643299	(37.7864799443229, -122.474472816433)
136307	136307	122145	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	31 15th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5991133.61704	2114833.40571	37.78641833516821	-122.47446645276199	(37.7864183351682, -122.474466452762)
43190	43190	122146	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	31 15th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 8ft		5991133.9927199995	2114818.51521	37.7863774717716	-122.47446406594999	(37.7863774717716, -122.47446406595)
9497	9497	122159	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	547 15th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5991246.192840001	2111684.05416	37.7777776077222	-122.473847129053	(37.7777776077222, -122.473847129053)
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)
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)
69029	69029	122205	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400 14th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 3ft		5991599.89413	2112284.80032	37.7794475722452	-122.472667377899	(37.7794475722452, -122.472667377899)
97684	97684	122204	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	400 14th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 3ft		5991601.17725	2112249.41578	37.7793504902729	-122.472660358473	(37.7793504902729, -122.472660358473)
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)
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)
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)
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)
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)
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)
149240	149240	205508	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 Quintara St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 5ft		5991536.67412	2101158.90463	37.7488951701835	-122.472074903552	(37.7488951701835, -122.472074903552)
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)
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)
186225	186225	205509	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	620 Quintara St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			37	Width 5ft		5991579.20091	2101160.0898599997	37.748900885378795	-122.471927933649	(37.7489008853788, -122.471927933649)
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)
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)
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)
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)

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