Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60 sorted by rowid descending

Search:

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

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

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

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

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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
189144	189144	121399	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	349X Cargo Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2
189087	189087	124257	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	300 Lake St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		5994687.94836	2114935.07302	37.78690277595771	-122.462176828634	(37.7869027759577, -122.462176828634)
189033	189033	249723	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2500 Broderick St	7	Front Yard : Yard 7	Tree 1	Private 1			15			6000201.87433	2117349.10426	37.7938470092862	-122.443273421624	(37.7938470092862, -122.443273421624)
188997	188997	142210	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	419 CENTRAL AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			26	Width 0ft		5999721.1207	2110069.3739	37.7738313306649	-122.444413453632	(37.7738313306649, -122.444413453632)
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)
188939	188939	212143	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	650x Miramar Ave	1	Median : Yard 3	Tree 1	DPW 2			3			5995395.28868	2093711.39383	37.7286686754144	-122.45819295046199	(37.7286686754144, -122.458192950462)
188914	188914	189521	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Acacia Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6018061.54589	2096217.07965	37.7368251711525	-122.380007535722	(37.7368251711525, -122.380007535722)
188895	188895	212106	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	4	Median : Yard 3	Tree 1	DPW 2			33	Width 10ft		5993007.603759999	2095365.5409099997	37.733073065562	-122.466567434662	(37.733073065562, -122.466567434662)
188804	188804	212067	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	61 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 6ft		5994377.39833	2097689.28912	37.7395324551634	-122.46200017816601	(37.7395324551634, -122.462000178166)
188789	188789	1301	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	4000X Alemany Blvd	9	Median : Cutout 11	Tree 1	DPW 2			32	10		5991772.09471	2087046.42932	37.7101594558675	-122.470233284447	(37.7101594558675, -122.470233284447)
188731	188731	176060	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1649 Alemany Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			27	Width 4ft		6001691.02561	2092534.5573200001	37.7257971005447	-122.436344055337	(37.7257971005447, -122.436344055337)
188642	188642	205515	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	309 San Fernando Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		5992123.70166	2094884.2371200002	37.7317004788946	-122.469588265482	(37.7317004788946, -122.469588265482)
188595	188595	206427	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	324 Monterey Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 5ft		5999911.90535	2094711.55517	37.731673381408896	-122.44265056648099	(37.7316733814089, -122.442650566481)
188559	188559	183674	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1271 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 0ft		5984268.7246	2106531.5004	37.7632235599314	-122.49760371081301	(37.7632235599314, -122.497603710813)
188426	188426	248776	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	3	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6002998.16884	2095083.8511700002	37.73287107152721	-122.43200731937999	(37.7328710715272, -122.43200731938)
188269	188269	244551	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1544 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		5999025.8241	2109069.656	37.771046664383995	-122.44674664069599	(37.771046664384, -122.446746640696)
188127	188127	212250	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1025 Junipero Serra Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		5991227.31888	2090046.52791	37.718365484458104	-122.47233467902201	(37.7183654844581, -122.472334679022)
188124	188124	212252	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1025 Junipero Serra Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		5991236.45499	2090182.46315	37.7187392579978	-122.47231300356701	(37.7187392579978, -122.472313003567)
188018	188018	248731	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2200 Folsom St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 4ft		6008113.59753	2105476.94115	37.761696854037105	-122.41505730396001	(37.7616968540371, -122.41505730396)
187934	187934	248698	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	833 Clayton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 4ft		5998642.47639	2107361.06094	37.766333389793296	-122.447949612988	(37.7663333897933, -122.447949612988)
187924	187924	248831	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	11 Eugenia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			33	Width 4ft		6006083.69333	2098358.08886	37.7420358421864	-122.42157231843001	(37.7420358421864, -122.42157231843)
187903	187903	199744	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2390 Keith St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6014576.6362	2092566.7568	37.726609256128995	-122.39180133468099	(37.726609256129, -122.391801334681)
187878	187878	137527	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1300 Pierce St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6002268.7428	2113135.9189	37.7823963227446	-122.435820282125	(37.7823963227446, -122.435820282125)
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)
187796	187796	212200	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	820 Bosworth St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6001696.91365	2095566.3144	37.7341219466514	-122.43654060398899	(37.7341219466514, -122.436540603989)
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)
187741	187741	248647	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2x Lyell St	1	Median : Yard 3	Tree 1	DPW 2			23			6002988.020959999	2095088.4577900001	37.73288314494071	-122.432042732011	(37.7328831449407, -122.432042732011)
187653	187653	212256	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	951 Junipero Serra Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 4ft		5991256.60801	2090543.58608	37.7197319791141	-122.472269653524	(37.7197319791141, -122.472269653524)
187615	187615	248705	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	307 Richland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			31	Width 3ft		6006497.3648	2096085.76853	37.7358198738733	-122.41998075582501	(37.7358198738733, -122.419980755825)
187602	187602	212146	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	650x Miramar Ave	4	Median : Yard 3	Tree 1	DPW 2			4			5995392.59413	2093841.41892	37.7290255380777	-122.458211672548	(37.7290255380777, -122.458211672548)
187553	187553	126258	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1202 Leavenworth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 5ft		6008097.7267	2116633.2366	37.7923284923066	-122.415902234109	(37.7923284923066, -122.415902234109)
187544	187544	248755	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1348 South Van Ness Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6007677.32831	2101801.47516	37.751580339863	-122.416305852527	(37.751580339863, -122.416305852527)
187503	187503	138383	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2578 PINE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 0ft		6001548.7627	2114977.9096	37.7874130337151	-122.43844310456801	(37.7874130337151, -122.438443104568)
187455	187455	248745	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2179 Folsom St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6008160.24503	2105677.60418	37.762250449719	-122.414910171272	(37.762250449719, -122.414910171272)
187440	187440	122225	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	735 14th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		5991619.05994	2110400.0991	37.774273806299	-122.472463637281	(37.774273806299, -122.472463637281)
187342	187342	65766	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	1937 Filbert St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/22/1992 12:00:00 AM	15		Permit Number 28729	6003642.45675	2118972.66599	37.7985004828598	-122.431484647806	(37.7985004828598, -122.431484647806)
187332	187332	222948	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	347 Hermann St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 3ft		6003592.17521	2108620.37819	37.770072851809	-122.430919422987	(37.770072851809, -122.430919422987)
187292	187292	248763	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3267 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6008400.19488	2104444.36554	37.7588777393334	-122.413993026465	(37.7588777393334, -122.413993026465)
187276	187276	140641	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	450 STANYAN ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		5996853.4928	2110047.6172	37.7736075584134	-122.454331414869	(37.7736075584134, -122.454331414869)
187259	187259	92861	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	2245 Larkin St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/12/2009 12:00:00 AM	11	3x3		6006750.866719999	2118980.24307	37.7986969721415	-122.42072910149099	(37.7986969721415, -122.420729101491)
187245	187245	222141	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	731 Duboce Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 3ft		6001982.44217	2108239.02454	37.768934409012104	-122.43646016051399	(37.7689344090121, -122.436460160514)
187195	187195	140152	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	260 Ashbury St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		5998830.617000001	2109809.4195	37.773066713132	-122.447475122199	(37.773066713132, -122.447475122199)
187183	187183	138823	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	628 IVY ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			33	Width 0ft		6004357.247	2111017.4097	37.7766978348647	-122.428443926863	(37.7766978348647, -122.428443926863)
187169	187169	248642	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	101 14th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6007785.694209999	2107933.31633	37.7684230563089	-122.416365384082	(37.7684230563089, -122.416365384082)
187138	187138	126262	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1540 Larkin St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			18	Width 3ft		6007118.63275	2116680.9805400004	37.7924044922289	-122.419293317642	(37.7924044922289, -122.419293317642)
187129	187129	248760	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2989 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6008348.54161	2103274.24588	37.7556619561402	-122.41408888699699	(37.7556619561402, -122.414088886997)
187076	187076	245832	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1550 Bryant St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		6009391.00904	2107592.36955	37.7675770370677	-122.41078864040001	(37.7675770370677, -122.4107886404)
187011	187011	245171	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1438 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		5999694.2786	2109163.5730000003	37.7713426994775	-122.444441193706	(37.7713426994775, -122.444441193706)
186969	186969	206365	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1540 Portola Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		5992315.21522	2096811.3530599999	37.7370029230323	-122.46906637001601	(37.7370029230323, -122.469066370016)
186942	186942	124151	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	950 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5996109.01256	2112263.6321400004	37.7796494301654	-122.457066993925	(37.7796494301654, -122.457066993925)
186932	186932	206415	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	82 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5994311.20143	2101804.36406	37.7508276046147	-122.46252746956999	(37.7508276046147, -122.46252746957)
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)
186766	186766	189517	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	131 Acacia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6018151.686369999	2096212.97966	37.7368188857736	-122.37969559237301	(37.7368188857736, -122.379695592373)
186690	186690	212295	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1000x Junipero Serra Blvd	6	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5991170.53267	2089939.6813400001	37.7180688232854	-122.472523177809	(37.7180688232854, -122.472523177809)
186680	186680	189507	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	12 Ironwood Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6018046.04082	2096060.30667	37.736393848204706	-122.380050253535	(37.7363938482047, -122.380050253535)
186654	186654	247262	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1551 Page St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 0ft		5999278.3283	2109062.3927	37.771041142259	-122.445872701357	(37.771041142259, -122.445872701357)
186650	186650	141645	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	540 BAKER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6000636.238	2110849.6046	37.7760258178517	-122.44130391752199	(37.7760258178517, -122.441303917522)
186556	186556	248661	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	76 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 8ft		6005366.58408	2103276.4881700003	37.7555001744107	-122.42440160805401	(37.7555001744107, -122.424401608054)
186547	186547	248870	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3101 19th St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6008540.540569999	2105084.00095	37.7606419133052	-122.413552882963	(37.7606419133052, -122.413552882963)
186474	186474	244547	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1500 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			34	Width 0ft		5999310.1583	2109110.031	37.7711737623699	-122.44576602732201	(37.7711737623699, -122.445766027322)
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)
186367	186367	141189	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1777 ELLIS ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			36	Width 0ft		6002361.0151	2112955.7484	37.7819068611147	-122.43548816808399	(37.7819068611147, -122.435488168084)
186334	186334	212214	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	920 Bosworth St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13			6001218.32955	2095696.7085799999	37.734452771280395	-122.438204553905	(37.7344527712804, -122.438204553905)
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)
186223	186223	212016	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	20 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 8ft		5992330.06493	2096504.04396	37.736159987583605	-122.468992670593	(37.7361599875836, -122.468992670593)
186221	186221	113186	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2400 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			43	6x6		6002287.420609999	2116502.02806	37.7916398598304	-122.435996604952	(37.7916398598304, -122.435996604952)
186200	186200	54788	Permitted Site 1	Corymbia ficifolia :: Red Flowering Gum 60	266 Tocoloma Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/02/1972 12:00:00 AM	17		Permit Number 10637	6012648.47164	2087248.62221	37.711899500144796	-122.398094045129	(37.7118995001448, -122.398094045129)
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)
186146	186146	212139	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	602x Miramar Ave	4	Median : Yard 3	Tree 1	DPW 2			6			5995385.05875	2093507.2159099998	37.728107464286204	-122.45821354403999	(37.7281074642862, -122.45821354404)
186046	186046	126220	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2342 Sacramento St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 4ft		6003406.142519999	2115933.5087599996	37.7901423411526	-122.432085223173	(37.7901423411526, -122.432085223173)
186012	186012	248844	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	38 Winfield St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6007344.42201	2099271.5920599997	37.7446151256805	-122.417277828134	(37.7446151256805, -122.417277828134)
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)
185881	185881	176018	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	26 Ervine St	12	Front Yard : Yard 7	Tree 1	Private 1			13			6009605.36223	2089158.99044	37.7169750147514	-122.40874661906	(37.7169750147514, -122.40874661906)
185637	185637	189403	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1900 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 4ft		6012367.68824	2104717.66867	37.7598502014559	-122.400290696781	(37.7598502014559, -122.400290696781)
185624	185624	212116	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		5992083.71687	2095423.23256	37.7331781144806	-122.469765726035	(37.7331781144806, -122.469765726035)
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)
185549	185549	142444	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	59	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5997400.5975	2114491.1681	37.785839744948	-122.45275968348301	(37.785839744948, -122.452759683483)
185495	185495	201722	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Lindsay Cir	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26			6016307.52162	2095597.12385	37.735025976661795	-122.386028821491	(37.7350259766618, -122.386028821491)
185493	185493	212000	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	115 San Leandro Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 6ft		5992393.22124	2095853.15196	37.7343764502974	-122.468726967677	(37.7343764502974, -122.468726967677)
185470	185470	248849	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	118 Eugenia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6006395.15145	2098160.97297	37.7415121633446	-122.420481404813	(37.7415121633446, -122.420481404813)
185431	185431	126246	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	675 Golden Gate Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		6006387.81901	2112474.0909599997	37.780812224756	-122.42152304635401	(37.780812224756, -122.421523046354)
185345	185345	137809	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2075 Buchanan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6003822.7218	2115574.5572	37.7891803601554	-122.430618267705	(37.7891803601554, -122.430618267705)
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)
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)
185325	185325	126164	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3406 Clay St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 4ft		5998411.11322	2115565.1236400004	37.788846395584706	-122.44934100180599	(37.7888463955847, -122.449341001806)
185269	185269	248643	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3531 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 5ft		6005315.03381	2106026.76175	37.7630488678445	-122.424775532659	(37.7630488678445, -122.424775532659)
185260	185260	122092	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	701 16th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 6ft		5990960.29001	2110539.25119	37.774617728690295	-122.474752577866	(37.7746177286903, -122.474752577866)
185173	185173	142612	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2424 JONES ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6008004.2032	2120805.2808	37.8037786279563	-122.41652149146799	(37.8037786279563, -122.416521491468)
185151	185151	126337	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	505 Sansome St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6012234.063019999	2117586.0477299998	37.795176360156205	-122.401657328144	(37.7951763601562, -122.401657328144)
185132	185132	245030	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1420 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			28	Width 0ft		5999791.0013	2109177.5330000003	37.77138654837189	-122.444107629833	(37.7713865483719, -122.444107629833)
184975	184975	108614	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1847 GRANT AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	3x3		6010358.9	2120872.9	37.804096435092504	-122.408377664827	(37.8040964350925, -122.408377664827)
184965	184965	212201	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	820 Bosworth St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 4ft		6001684.04904	2095564.31513	37.7341157260662	-122.43658493785101	(37.7341157260662, -122.436584937851)
184942	184942	126185	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	3235 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			32	Width 5ft		6004573.695180001	2120676.94649	37.803232733462295	-122.42838380878099	(37.8032327334623, -122.428383808781)
184928	184928	126322	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	100 California St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6013251.8904099995	2116966.13143	37.793530960534504	-122.398091951502	(37.7935309605345, -122.398091951502)
184906	184906	246124	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1523 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5998327.5203	2108278.8108	37.7688352898731	-122.44910510347499	(37.7688352898731, -122.449105103475)
184883	184883	123911	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	255 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 4ft		5992734.8806	2113749.59926	37.783535144259204	-122.46884763621999	(37.7835351442592, -122.46884763622)
184826	184826	117915	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	831 41st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		5983218.794509999	2110128.25948	37.7730376298846	-122.501501101241	(37.7730376298846, -122.501501101241)
184823	184823	248539	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	107 Beulah St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5997585.1348	2107785.048	37.767437055413204	-122.451637327839	(37.7674370554132, -122.451637327839)
184762	184762	189468	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	155 Brannan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 6ft		6015625.99151	2113330.08143	37.783679142911794	-122.38962323631701	(37.7836791429118, -122.389623236317)
184696	184696	142391	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5998019.9094	2114574.9275	37.7861051940215	-122.450623088237	(37.7861051940215, -122.450623088237)

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