Street_Tree_List

Data source: data.sfgov.org

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

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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
100469	100469	110542	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	996 SOUTH VAN NESS AVE	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						6007549.0	2103894.0	37.757318718735704	-122.41689786927	(37.7573187187357, -122.41689786927)
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)
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)
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)
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)
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)
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)
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)
172680	172680	123050	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	556 Funston Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 4ft		5991924.6758	2111674.3031099997	37.777790108366794	-122.471499333549	(37.7777901083668, -122.471499333549)
72975	72975	123369	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	798 04th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 4ft		5994770.34918	2110278.58603	37.7741220545159	-122.461554020375	(37.7741220545159, -122.461554020375)
32429	32429	124059	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	401 Funston Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 3ft		5991855.82446	2112441.44184	37.7798924782755	-122.471793433921	(37.7798924782755, -122.471793433921)
156092	156092	124060	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	401 Funston Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 3ft		5991866.07443	2112179.49753	37.7791738439371	-122.471738880123	(37.7791738439371, -122.471738880123)
172178	172178	124402	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3966 Washington St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5995735.18889	2115521.97935	37.7885745043372	-122.45859614302	(37.7885745043372, -122.45859614302)
134578	134578	124403	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3966 Washington St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 6ft		5995714.3392199995	2115519.8747099997	37.7885675272609	-122.45866812682101	(37.7885675272609, -122.458668126821)
178176	178176	124623	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	824 Euclid Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 4ft		5995732.73354	2113830.84167	37.7839309537886	-122.458482173763	(37.7839309537886, -122.458482173763)
37811	37811	126171	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2901 Divisadero St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 6ft		6000513.1495	2118370.5778099997	37.7966694514978	-122.44226974674801	(37.7966694514978, -122.442269746748)
45672	45672	126172	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2901 Divisadero St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		6000514.61681	2118336.13924	37.7965749759056	-122.44226219603901	(37.7965749759056, -122.442262196039)
56986	56986	126173	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2901 Divisadero St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			34	Width 6ft		6000518.259380001	2118317.0827099998	37.7965228593064	-122.442248223283	(37.7965228593064, -122.442248223283)
75034	75034	126174	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2901 Divisadero St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		6000528.458380001	2118255.9071	37.7963554684918	-122.44220853889601	(37.7963554684918, -122.442208538896)
126175	126175	126240	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	700 Van Ness Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		6006641.75911	2112973.7932700003	37.7821986007353	-122.42068002636002	(37.7821986007353, -122.42068002636)
166964	166964	140841	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	128 JORDAN AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 0ft		5996252.84	2113531.7423	37.7831395829214	-122.456661169882	(37.7831395829214, -122.456661169882)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
44749	44749	189399	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	599 Wisconsin St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		6012714.75151	2104751.09963	37.759961342364	-122.399092713458	(37.759961342364, -122.399092713458)
35172	35172	189400	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	599 Wisconsin St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		6012714.679959999	2104758.8232299997	37.7599825456822	-122.399093503057	(37.7599825456822, -122.399093503057)
67387	67387	189401	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	599 Wisconsin St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		6012714.85505	2104767.4503900004	37.760006243721705	-122.39909350306499	(37.7600062437217, -122.399093503065)
53083	53083	189428	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1300 19th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 4ft		6013707.60664	2105261.31352	37.761417556983794	-122.39569463232401	(37.7614175569838, -122.395694632324)
156271	156271	201455	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018178.0225	2096034.8800400002	37.73633131204021	-122.379592166743	(37.7363313120402, -122.379592166743)
158582	158582	201456	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018152.99448	2096035.88358	37.736332687111	-122.379678769657	(37.736332687111, -122.379678769657)
61641	61641	201457	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		6018132.65618	2096036.7926	37.736334061269005	-122.37974915152	(37.736334061269, -122.37974915152)
167624	167624	201458	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018111.7846800005	2096036.1618400002	37.7363311780414	-122.37982126995001	(37.7363311780414, -122.37982126995)
154309	154309	201459	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Catalina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6018080.74427	2096037.10445	37.736332053971296	-122.379928656194	(37.7363320539713, -122.379928656194)
172918	172918	201460	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		6017973.047069999	2096042.30781	37.7363403996791	-122.380301375718	(37.7363403996791, -122.380301375718)
186199	186199	201461	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017953.45292	2096043.24066	37.7363418799584	-122.380369186391	(37.7363418799584, -122.380369186391)
186851	186851	201462	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6017931.88164	2096043.5768799998	37.736341612873	-122.380443791448	(37.736341612873, -122.380443791448)
50508	50508	201463	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6017910.1596099995	2096044.43658	37.736342774794004	-122.380518954089	(37.736342774794, -122.380518954089)
178359	178359	201464	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		6017881.76944	2096045.3386099997	37.7363436849175	-122.380617174457	(37.7363436849175, -122.380617174457)
32205	32205	201465	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	221 Catalina St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		6017857.702409999	2096046.34832	37.736345129211294	-122.380700455256	(37.7363451292113, -122.380700455256)
24903	24903	201466	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	301 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017699.909990001	2096021.8364	37.7362691149141	-122.38124431128	(37.7362691149141, -122.38124431128)
129658	129658	201467	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	301 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		6017657.01116	2096011.92919	37.7362395434261	-122.381391943098	(37.7362395434261, -122.381391943098)
180128	180128	201468	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	300 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017677.66407	2095970.41595	37.7361266964906	-122.381317651001	(37.7361266964906, -122.381317651001)
36013	36013	201469	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	300 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017698.8541	2095974.10398	37.7361379928748	-122.381244644042	(37.7361379928748, -122.381244644042)
182337	182337	201470	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	300 Catalina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017720.50763	2095978.01132	37.7361499169812	-122.381170049779	(37.7361499169812, -122.381170049779)
44546	44546	201472	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017871.79142	2095999.43852	37.7362171017244	-122.38064848344601	(37.7362171017244, -122.380648483446)
83012	83012	201473	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017891.6083	2095998.1068	37.736214538679	-122.380579875087	(37.736214538679, -122.380579875087)
183263	183263	201474	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017913.7738	2095996.98532	37.73621268247221	-122.380503161112	(37.7362126824722, -122.380503161112)
165445	165445	201475	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017932.44765	2095996.0751900002	37.73621121387271	-122.38043853402	(37.7362112138727, -122.38043853402)
59368	59368	201476	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017960.44466	2095995.0605900001	37.736209972812	-122.38034166533899	(37.736209972812, -122.380341665339)
62552	62552	201477	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	200 Catalina St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		6017976.131469999	2095993.98649	37.7362078890842	-122.380287354394	(37.7362078890842, -122.380287354394)
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)
155343	155343	205494	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1651 08th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 6ft		5993684.29468	2104301.26828	37.757647339060796	-122.464876665145	(37.7576473390608, -122.464876665145)
185555	185555	205495	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1651 08th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 6ft		5993684.89778	2104284.67686	37.757601818089206	-122.464873374503	(37.7576018180892, -122.464873374503)
165310	165310	205496	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1651 08th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5993684.9556	2104264.78094	37.7575471923763	-122.464871729673	(37.7575471923763, -122.464871729673)
45201	45201	205498	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	339 Ortega St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 4ft		5992906.69703	2102511.7445400003	37.7526889062749	-122.467435765149	(37.7526889062749, -122.467435765149)

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