Street_Tree_List

Data source: data.sfgov.org

198 rows where PlotSize = "Width 3ft" and qSpecies = 20

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, qSiteInfo, DBH

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
2817	2817	253222	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	148 Felton St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				Width 3ft		6010428.10303	2093767.62468	37.729675416078294	-122.406227307752	(37.7296754160783, -122.406227307752)
2839	2839	253221	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	148 Felton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				Width 3ft		6010428.10303	2093767.62468	37.729675416078294	-122.406227307752	(37.7296754160783, -122.406227307752)
4156	4156	213178	Permitted Site 1	Callistemon viminalis :: Weeping Bottlebrush 20	629 Grafton Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/06/2017 08:23:00 AM	3	Width 3ft	Permit Number 20774	5994856.22066	2090552.89382	37.7199652039099	-122.45982783161502	(37.7199652039099, -122.459827831615)
4212	4212	204652	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	324 Howth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/10/2017 03:45:00 PM	3	Width 3ft		5997137.29551	2090290.56774	37.719375836806705	-122.45192406695601	(37.7193758368067, -122.451924066956)
23457	23457	221362	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1301 Douglass St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6001384.01408	2099859.31671	37.7458917403255	-122.437929785824	(37.7458917403255, -122.437929785824)
24046	24046	222589	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	4384 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6000100.50643	2105785.88471	37.762091580878604	-122.44279345615601	(37.7620915808786, -122.442793456156)
24143	24143	221342	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	211 27th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6005048.208	2100165.37235	37.7469397877337	-122.425281276331	(37.7469397877337, -122.425281276331)
24896	24896	204623	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1880 08th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5993786.05175	2102711.73048	37.7532887441949	-122.46440934321801	(37.7532887441949, -122.464409343218)
25248	25248	188298	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1022 Minna St	3	: 4	Tree 1	Private 1			10	Width 3ft		6007537.97287	2109701.89036	37.7732652094644	-122.41734758044	(37.7732652094644, -122.41734758044)
25555	25555	175783	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	771 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6006465.53434	2093625.53998	37.729062833884605	-122.419916279827	(37.7290628338846, -122.419916279827)
25966	25966	204670	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	380 Monterey Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5999483.78605	2094717.6896400002	37.7316658109241	-122.44413109610001	(37.7316658109241, -122.4441310961)
26495	26495	188354	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1341 Hudson Ave	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6017148.15295	2095467.55143	37.73471668451	-122.383113415457	(37.73471668451, -122.383113415457)
27078	27078	188288	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	106 Langton St	4	: 4	Tree 1	Private 1			3	Width 3ft		6010227.812000001	2110667.04277	37.7760662630739	-122.40811110056299	(37.7760662630739, -122.408111100563)
27101	27101	124082	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	3220 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5993384.863369999	2110069.41246	37.773467874758296	-122.466331413768	(37.7734678747583, -122.466331413768)
27115	27115	175782	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	769 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006531.05237	2093633.80708	37.729089224484795	-122.419690364741	(37.7290892244848, -122.419690364741)
27371	27371	222562	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	190 Precita Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6007642.65731	2100277.00661	37.747392543349704	-122.416317784757	(37.7473925433497, -122.416317784757)
28362	28362	222576	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	471 Noe St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003000.71138	2105505.41806	37.7614863982993	-122.432742735495	(37.7614863982993, -122.432742735495)
28372	28372	204655	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	452 Victoria St	1	: 4	Tree 1	Private 1			5	Width 3ft		5993265.60688	2090192.2995	37.7188834957636	-122.46529981143298	(37.7188834957636, -122.465299811433)
28539	28539	188302	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	90 Kissling St	3	: 4	Tree 1	Private 1			7	Width 3ft		6008239.71976	2109507.11568	37.7727698610843	-122.414906347362	(37.7727698610843, -122.414906347362)
29109	29109	222592	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	352 Hermann St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6003592.38415	2108668.4276900003	37.7702047958459	-122.43092212997699	(37.7702047958459, -122.430922129977)
29365	29365	222548	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	191 Bocana St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6007220.93745	2097850.24968	37.740705488567706	-122.417604094958	(37.7407054885677, -122.417604094958)
30747	30747	188322	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	800 Wisconsin St	5	: 4	Tree 1	Private 1			3	Width 3ft		6012715.86863	2103660.87857	37.75696789675921	-122.39901232755399	(37.7569678967592, -122.399012327554)
31017	31017	222574	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	382 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6003928.91308	2102165.887	37.752369435600706	-122.429294326484	(37.7523694356007, -122.429294326484)
31738	31738	221360	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	184 Graystone Ter	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5999311.904680001	2104005.96159	37.757159364222495	-122.44539292943399	(37.7571593642225, -122.445392929434)
31785	31785	124081	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	3220 Fulton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5993396.8995199995	2110067.15404	37.7734623682136	-122.46628961516399	(37.7734623682136, -122.466289615164)
32947	32947	222552	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	188 Bocana St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6007202.63127	2097897.94559	37.740835420825206	-122.417670770702	(37.7408354208252, -122.417670770702)
34214	34214	188320	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	800 Wisconsin St	3	: 4	Tree 1	Private 1			4	Width 3ft		6012714.93717	2103702.00953	37.7570807814757	-122.399018435778	(37.7570807814757, -122.399018435778)
34236	34236	188300	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	90 Kissling St	1	: 4	Tree 1	Private 1			7	Width 3ft		6008269.7706	2109537.20803	37.7728541761188	-122.41480452791001	(37.7728541761188, -122.41480452791)
34992	34992	222570	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	4308 25th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6001844.3062	2101201.08908	37.7496020939667	-122.43643417821698	(37.7496020939667, -122.436434178217)
35460	35460	188321	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	800 Wisconsin St	4	: 4	Tree 1	Private 1			4	Width 3ft		6012714.29279	2103681.1367599997	37.757023433506	-122.399019199302	(37.757023433506, -122.399019199302)
37998	37998	221341	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	217 27th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6005002.96321	2100161.85612	37.7469275767478	-122.42543747867201	(37.7469275767478, -122.425437478672)
38265	38265	222573	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	3917 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6003673.95782	2101843.15091	37.7514688410299	-122.43015298120301	(37.7514688410299, -122.430152981203)
38282	38282	188358	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1334 Hudson Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6017132.819619999	2095655.66164	37.7352323503922	-122.383179517428	(37.7352323503922, -122.383179517428)
38724	38724	204643	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	290 Miramar Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5995381.41136	2092014.7979700002	37.7240094335681	-122.458118187113	(37.7240094335681, -122.458118187113)
38900	38900	222499	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	301 Webster St	4	: 4	Tree 1	Private 1			3	Width 3ft		6004137.32896	2109855.92191	37.7734962273111	-122.429121852705	(37.7734962273111, -122.429121852705)
39326	39326	221354	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	2979 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6008383.52326	2103860.65415	37.7572740646699	-122.41400939143601	(37.7572740646699, -122.414009391436)
39974	39974	188355	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1339 Hudson Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6017230.94644	2095282.0098400002	37.7342117988404	-122.38281425956998	(37.7342117988404, -122.38281425957)
40334	40334	222553	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	184 Bocana St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6007213.79342	2097921.72013	37.740901328538996	-122.417633860722	(37.740901328539, -122.417633860722)
41275	41275	188305	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	635 Tennessee St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6015454.10981	2106058.18427	37.7637025904139	-122.389709812266	(37.7637025904139, -122.389709812266)
41982	41982	188330	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	214 Texas St	1	: 4	Tree 1	Private 1			13	Width 3ft		6013707.236830001	2106019.4851599997	37.763499309471506	-122.395749036807	(37.7634993094715, -122.395749036807)
43337	43337	204651	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	27 Majestic Ave	1	: 4	Tree 1	Private 1			6	Width 3ft		5997399.75585	2089775.82239	37.7179774953307	-122.45097974552401	(37.7179774953307, -122.450979745524)
44147	44147	188289	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	40 Sheridan St	1	: 4	Tree 1	Private 1			5	Width 3ft		6009413.38466	2109546.86827	37.772944891630104	-122.41084930056101	(37.7729448916301, -122.410849300561)
44455	44455	222555	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	121 Coleridge St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6006651.1877	2098952.76416	37.743700669854796	-122.419652282953	(37.7437006698548, -122.419652282953)
45314	45314	221329	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	92 Peralta Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6010301.696169999	2100286.438	37.7475676053645	-122.407123632349	(37.7475676053645, -122.407123632349)
45351	45351	188353	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1341 Hudson Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6017129.66281	2095538.6901900002	37.7349109956364	-122.38318229272899	(37.7349109956364, -122.383182292729)
45511	45511	221338	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	117 Valley St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6005011.955130001	2099285.1526	37.7445208578632	-122.425344007646	(37.7445208578632, -122.425344007646)
45649	45649	221353	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	3181 23rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6007743.59292	2102655.4048200003	37.7539287629281	-122.41613717119199	(37.7539287629281, -122.416137171192)
46013	46013	221321	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	76 Oakwood St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6005240.58146	2105045.63355	37.7603507164348	-122.424963229285	(37.7603507164348, -122.424963229285)
46539	46539	221335	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1641 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6010542.34793	2100138.1982400003	37.7471740359465	-122.406281026071	(37.7471740359465, -122.406281026071)
47784	47784	221322	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	76 Oakwood St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6005240.85494	2105024.4327599998	37.760292519512205	-122.42496077502899	(37.7602925195122, -122.424960775029)
49781	49781	222588	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	4380 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6000121.81513	2105788.1369	37.762098979601	-122.44271991951	(37.762098979601, -122.44271991951)
50129	50129	175762	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	223 Woolsey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6011080.3120099995	2091995.56752	37.7248461762995	-122.403847893187	(37.7248461762995, -122.403847893187)
50304	50304	221348	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	225 Bennington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6007116.4311	2096880.25923	37.7380362287807	-122.41789669659401	(37.7380362287807, -122.417896696594)
50847	50847	222571	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	593 Jersey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6001358.40825	2101420.45569	37.7501768003212	-122.43813013861099	(37.7501768003212, -122.438130138611)
51006	51006	221351	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	85 Sycamore St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006363.61838	2105832.54053	37.7625747506491	-122.421135037456	(37.7625747506491, -122.421135037456)
51832	51832	222565	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	111 Precita Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6007123.52166	2100080.2988	37.7468232221335	-122.418098981082	(37.7468232221335, -122.418098981082)
52367	52367	175777	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	281 Vienna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6004127.09808	2091752.9850700002	37.7237891931904	-122.42786706372601	(37.7237891931904, -122.427867063726)
52591	52591	222563	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	184 Precita Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6007620.90266	2100266.50742	37.747362491591296	-122.41639226749201	(37.7473624915913, -122.416392267492)
52936	52936	222568	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	34 Saint Marys Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6004529.9479	2095570.0555900002	37.734292801673796	-122.426746177496	(37.7342928016738, -122.426746177496)
53435	53435	222583	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	193 Diamond St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6001753.50389	2104887.2031	37.7597181171131	-122.43701204208	(37.7597181171131, -122.43701204208)
53675	53675	222572	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	524 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6002965.6945400005	2102138.50273	37.7522396670301	-122.432623334298	(37.7522396670301, -122.432623334298)
53683	53683	125881	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	2101 Chestnut St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001760.22052	2119747.88013	37.8005221579273	-122.438053316704	(37.8005221579273, -122.438053316704)
53807	53807	188319	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	800 Wisconsin St	2	: 4	Tree 1	Private 1			3	Width 3ft		6012713.14067	2103722.27252	37.7571363191045	-122.39902607101001	(37.7571363191045, -122.39902607101)
54041	54041	188299	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1022 Minna St	4	: 4	Tree 1	Private 1			4	Width 3ft		6007530.7890099995	2109693.3141	37.7732412569071	-122.41737182255501	(37.7732412569071, -122.417371822555)
54422	54422	204645	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	111 Ashton Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5994132.807630001	2090689.3393400002	37.7202982210683	-122.462338293601	(37.7202982210683, -122.462338293601)
54979	54979	221358	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	100 Berkeley Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6000996.09085	2097469.1732900003	37.73930690338871	-122.439099895546	(37.7393069033887, -122.439099895546)
55473	55473	222549	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	199 Bocana St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6007198.14969	2097813.68298	37.740603802237295	-122.417680295405	(37.7406038022373, -122.417680295405)
56301	56301	204608	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1563 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5990535.7174	2104763.29262	37.7587338945762	-122.47579935676399	(37.7587338945762, -122.475799356764)
59363	59363	222560	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1409 Shotwell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6008015.99739	2099911.75152	37.7464106212529	-122.415000947938	(37.7464106212529, -122.415000947938)
60373	60373	188307	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	635 Tennessee St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6015454.50593	2106102.86687	37.763825301131895	-122.389711563256	(37.7638253011319, -122.389711563256)
60381	60381	188345	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	2055 Silver Ave	8	: 4	Tree 1	Private 1			5	Width 3ft		6012515.97712	2096106.6824400001	37.73621455036071	-122.399173381754	(37.7362145503607, -122.399173381754)
60672	60672	204624	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1830 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5993464.78312	2103004.20884	37.7540732902536	-122.465541593278	(37.7540732902536, -122.465541593278)
61402	61402	222561	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	380 Tompkins Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6008138.86201	2096500.51335	37.7370510178737	-122.414334773354	(37.7370510178737, -122.414334773354)
61407	61407	222582	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	193 Diamond St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001750.8913900005	2104845.17495	37.759602569523395	-122.437018068443	(37.7596025695234, -122.437018068443)
61563	61563	247044	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	596 Valley St	3	: 4	Tree 1	Private 1			3	Width 3ft		6002079.830030001	2099170.11996	37.74403891207071	-122.43547446040199	(37.7440389120707, -122.435474460402)
61670	61670	222577	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	4016 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6002861.59805	2105354.01605	37.7610627942241	-122.433213052158	(37.7610627942241, -122.433213052158)
62206	62206	188301	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	90 Kissling St	2	: 4	Tree 1	Private 1			7	Width 3ft		6008261.50029	2109526.90873	37.772825431974894	-122.41483240691002	(37.7728254319749, -122.41483240691)
64374	64374	222581	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	193 Diamond St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6001755.3451	2104807.77266	37.7595001250595	-122.436999987566	(37.7595001250595, -122.436999987566)
65031	65031	204644	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	150 Ashton Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5994179.89282	2090937.7889	37.7209831150476	-122.46219354590099	(37.7209831150476, -122.462193545901)
65637	65637	222567	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	115 College Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004467.78746	2096013.76695	37.735507618486096	-122.42699267809601	(37.7355076184861, -122.426992678096)
65817	65817	188323	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	800 Wisconsin St	6	: 4	Tree 1	Private 1			3	Width 3ft		6012718.59247	2103642.7954599997	37.7569183962771	-122.399001638237	(37.7569183962771, -122.399001638237)
68007	68007	188285	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	106 Langton St	1	: 4	Tree 1	Private 1			6	Width 3ft		6010183.94442	2110713.51419	37.776191406445705	-122.40826612929199	(37.7761914064457, -122.408266129292)
68091	68091	204660	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	25 Vista Verde Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5999210.558230001	2096011.88167	37.7352037663304	-122.445168706887	(37.7352037663304, -122.445168706887)
69023	69023	221356	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	2517 Harrison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008902.61993	2103693.2247900004	37.7568434827621	-122.412202312603	(37.7568434827621, -122.412202312603)
69764	69764	222544	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	2885 Diamond St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6002432.22505	2095435.0142400002	37.733803183770796	-122.433989022279	(37.7338031837708, -122.433989022279)
70747	70747	222579	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	195 Hartford St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6002709.09948	2104829.71069	37.7596145259996	-122.43370300460501	(37.7596145259996, -122.433703004605)
71277	71277	175764	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	325 Wayland St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6010619.0390099995	2092334.0476400002	37.7257497917057	-122.40546629512698	(37.7257497917057, -122.405466295127)
71455	71455	175779	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	302 Silver Ave	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003783.14523	2093465.1437900001	37.728470936062706	-122.429178076504	(37.7284709360627, -122.429178076504)
71778	71778	222542	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	4384 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6000744.165990001	2102309.32238	37.7525824616182	-122.44031795801399	(37.7525824616182, -122.440317958014)
71804	71804	188313	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	299 Arkansas St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6012940.76459	2105761.15041	37.7627473116745	-122.39838191001199	(37.7627473116745, -122.398381910012)
73411	73411	188359	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	1334 Hudson Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6017127.7114699995	2095678.22784	37.735294030402706	-122.383198748549	(37.7352940304027, -122.383198748549)
73488	73488	222587	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	2022 15th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6004007.1473900005	2107186.69928	37.7661598206327	-122.429381787342	(37.7661598206327, -122.429381787342)
73593	73593	222551	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	192 Bocana St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6007190.09246	2097874.19927	37.740769513115794	-122.4177124426	(37.7407695131158, -122.4177124426)
75566	75566	188350	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	2 Dukes Ct	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6016183.298880001	2096350.88685	37.7370887822104	-122.386510848195	(37.7370887822104, -122.386510848195)
75863	75863	221326	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	384 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6005468.19863	2101476.92488	37.7505647282985	-122.423922233444	(37.7505647282985, -122.423922233444)
76796	76796	222569	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	4366 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001499.852999999	2101184.60004	37.749537240249296	-122.43762412605601	(37.7495372402493, -122.437624126056)
97932	97932	175756	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	837 Paris St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6000844.62416	2089035.80235	37.7161421822999	-122.439019362161	(37.7161421822999, -122.439019362161)
129616	129616	188290	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	40 Sheridan St	2	: 4	Tree 1	Private 1			7	Width 3ft		6009398.69382	2109531.26602	37.7729012277415	-122.410899015985	(37.7729012277415, -122.410899015985)
129952	129952	222505	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	3632 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6005354.298280001	2105491.7389599998	37.7615820394108	-122.424601669449	(37.7615820394108, -122.424601669449)
131404	131404	247045	Undocumented 2	Callistemon viminalis :: Weeping Bottlebrush 20	596 Valley St	4	: 4	Tree 1	Private 1			7	Width 3ft		6002079.02681	2099155.53035	37.7439988068049	-122.435476194275	(37.7439988068049, -122.435476194275)

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