Street_Tree_List

Data source: data.sfgov.org

138 rows where PlotSize = "Width 3ft" and qSpecies = 30 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: SiteOrder, qSiteInfo, DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
51341	51341	117943	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	6300 Fulton St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5983766.08421	2109717.4045599997	37.7719416683068	-122.499577617773	(37.7719416683068, -122.499577617773)
131020	131020	117942	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	6300 Fulton St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5983781.64788	2109717.73118	37.7719434782971	-122.499523806885	(37.7719434782971, -122.499523806885)
54202	54202	117939	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	6300 Fulton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5983833.6821099995	2109720.9042700003	37.7719552435785	-122.49934405400101	(37.7719552435785, -122.499344054001)
136118	136118	250773	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	259 32nd Ave	1	: 4	Tree 1	Private 1			14	Width 3ft		5985865.92055	2114194.89594	37.7843585636424	-122.492644052605	(37.7843585636424, -122.492644052605)
178480	178480	119541	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	823 30th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5986627.47166	2110288.5169900004	37.773677258601	-122.48972200943399	(37.773677258601, -122.489722009434)
45357	45357	120682	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2917 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5989597.69972	2111917.78775	37.7783237566214	-122.479566877639	(37.7783237566214, -122.479566877639)
74868	74868	121865	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	574 18th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5990352.3789099995	2111462.4285	37.7771172745488	-122.476922909403	(37.7771172745488, -122.476922909403)
187174	187174	122008	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2650 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990390.42893	2112003.07059	37.7786039357458	-122.476830795247	(37.7786039357458, -122.476830795247)
109199	109199	122009	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2629 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990447.70869	2111948.34575	37.77845699894	-122.476628645569	(37.77845699894, -122.476628645569)
49816	49816	207050	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1287 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990781.88485	2106644.27108	37.7639128285243	-122.475085316637	(37.7639128285243, -122.475085316637)
77081	77081	207086	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2167 18th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990677.28316	2100628.1103	37.747387978366106	-122.475007906598	(37.7473879783661, -122.475007906598)
147671	147671	207068	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	539 Vicente St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5991225.79939	2097692.69128	37.739359846476205	-122.472897178881	(37.7393598464762, -122.472897178881)
175198	175198	207091	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	520 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5991320.331130001	2097065.30066	37.7376426638631	-122.47252460501998	(37.7376426638631, -122.47252460502)
170832	170832	207092	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2655 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991411.795390001	2097355.25398	37.738444095618	-122.4722295024	(37.738444095618, -122.4722295024)
59171	59171	207090	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1400 Ulloa St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5991605.432	2098443.60055	37.741443622419894	-122.47163929621	(37.7414436224199, -122.47163929621)
59463	59463	207089	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1400 Ulloa St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991620.77866	2098444.2951599997	37.7414464175195	-122.471586283874	(37.7414464175195, -122.471586283874)
164375	164375	207088	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1400 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991634.58199	2098444.51298	37.7414478141662	-122.47153857305	(37.7414478141662, -122.47153857305)
62582	62582	207087	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1400 Ulloa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991668.56365	2098444.306	37.7414492117217	-122.471421062245	(37.7414492117217, -122.471421062245)
156929	156929	217749	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	445 West Portal Ave	1	: 4	Tree 1	Private 1			2	Width 3ft		5991783.05973	2096405.3403	37.7358573522267	-122.470876685538	(37.7358573522267, -122.470876685538)
168739	168739	207051	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1264 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5992092.816880001	2106815.43538	37.764458690039	-122.47056370526899	(37.764458690039, -122.470563705269)
168777	168777	207093	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2469 14th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992014.45058	2098646.31177	37.742023871309	-122.47023982251801	(37.742023871309, -122.470239822518)
41237	41237	207083	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1959 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992235.15443	2102157.44312	37.7516772939722	-122.469732265856	(37.7516772939722, -122.469732265856)
36363	36363	207082	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1963 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992234.50744	2102126.7079	37.7515928656239	-122.46973226583799	(37.7515928656239, -122.469732265838)
183459	183459	207081	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1967 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5992237.024130001	2102091.85973	37.751497327037605	-122.46972102612601	(37.7514973270376, -122.469721026126)
184598	184598	207080	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1648 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5992494.37113	2104224.8500200002	37.75736883521821	-122.46898630879299	(37.7573688352182, -122.468986308793)
34205	34205	207067	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	319 San Benito Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992889.43355	2094705.1306900003	37.731252923187796	-122.466927982745	(37.7312529231878, -122.466927982745)
178142	178142	207065	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Taraval St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993024.9505900005	2099189.6741400003	37.743574176615894	-122.46678535477301	(37.7435741766159, -122.466785354773)
67199	67199	207064	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Taraval St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993028.0499599995	2099189.22218	37.743573114522206	-122.466774605159	(37.7435731145222, -122.466774605159)
186485	186485	207063	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Taraval St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993031.18209	2099190.3171200003	37.7435763017135	-122.46676385469401	(37.7435763017135, -122.466763854694)
52098	52098	207062	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Taraval St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993034.65386	2099189.08337	37.7435731145127	-122.46675176060499	(37.7435731145127, -122.466751760605)
183793	183793	207061	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Taraval St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993037.74509	2099188.24411	37.7435709885186	-122.466741010989	(37.7435709885186, -122.466741010989)
69772	69772	207085	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2091 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5993168.90781	2101284.1521799997	37.749333387335895	-122.466439786693	(37.7493333873359, -122.466439786693)
155887	155887	207084	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2093 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5993169.3721900005	2101262.29203	37.7492733917544	-122.46643659227101	(37.7492733917544, -122.466436592271)
25932	25932	207066	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	71 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5993124.54928	2098622.04482	37.7420213577054	-122.46639972369101	(37.7420213577054, -122.466399723691)
46688	46688	207094	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	115 Kenwood Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5994559.61163	2093655.1393099998	37.728466159762505	-122.46107783977101	(37.7284661597625, -122.461077839771)
183467	183467	207095	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1565 Plymouth Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5995634.15192	2094407.3594099998	37.730593351393296	-122.457417521726	(37.7305933513933, -122.457417521726)
52608	52608	207096	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	447 Lansdale Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5996040.3151	2096410.52388	37.7361168767915	-122.456158138087	(37.7361168767915, -122.456158138087)
26269	26269	207097	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	451 Lansdale Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5996075.95126	2096408.69413	37.7361138982453	-122.45603479789301	(37.7361138982453, -122.456034797893)
162331	162331	129397	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3729 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5997011.377730001	2114998.8497200003	37.7872113930486	-122.45414294896099	(37.7872113930486, -122.454142948961)
165795	165795	129398	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3729 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5997021.62902	2114999.75252	37.787214459718705	-122.454107547129	(37.7872144597187, -122.454107547129)
162702	162702	129396	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3570 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5997759.42615	2115150.05593	37.7876694312425	-122.451565786028	(37.7876694312425, -122.451565786028)
76698	76698	227631	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	75 Clarendon Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997896.0946	2104612.71078	37.758744422037395	-122.450333060142	(37.7587444220374, -122.450333060142)
56432	56432	227632	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	71 Clarendon Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5997905.871119999	2104612.50701	37.758744422044295	-122.450299233916	(37.7587444220443, -122.450299233916)
133580	133580	129395	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3383 Clay St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5998662.1100699995	2115556.58452	37.7888373034598	-122.44847197610399	(37.7888373034598, -122.448471976104)
27723	27723	129402	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3000 Lyon St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5999090.32735	2119096.86414	37.7985824452762	-122.44724531075	(37.7985824452762, -122.44724531075)
65976	65976	129416	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	218 Presidio Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5999044.58564	2115840.24858	37.789638031029206	-122.44716909230301	(37.7896380310292, -122.447169092303)
31281	31281	227616	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	246 Downey St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5999006.659659999	2106731.5709599997	37.764625778676	-122.44664468051	(37.764625778676, -122.44664468051)
152769	152769	129415	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1914 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5999481.122280001	2115602.98861	37.7890115102163	-122.44564165674	(37.7890115102163, -122.44564165674)
186402	186402	227647	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	144 Danvers St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5999980.75729	2104959.09552	37.7598145945821	-122.44314823869499	(37.7598145945821, -122.443148238695)
70505	70505	227648	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	154 Danvers St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5999992.54639	2104934.00184	37.7597463657249	-122.443105663906	(37.7597463657249, -122.443105663906)
76313	76313	227649	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	154 Danvers St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5999999.59495	2104920.93401	37.7597108865789	-122.44308034798901	(37.7597108865789, -122.443080347989)
74636	74636	227650	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	154 Danvers St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6000006.33119	2104908.8667200003	37.759678136855996	-122.443056184107	(37.759678136856, -122.443056184107)
75243	75243	129405	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3545 Scott St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6000706.97602	2120551.39476	37.8026684412687	-122.44175565829399	(37.8026684412687, -122.441755658294)
28468	28468	129406	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3545 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6000708.230719999	2120533.5731200003	37.8026195792908	-122.44175003663099	(37.8026195792908, -122.441750036631)
74708	74708	129392	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	31 Casa Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001624.74168	2121508.73342	37.80534928880979	-122.438648369353	(37.8053492888098, -122.438648369353)
55487	55487	129414	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2501 Jackson St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001550.43955	2116611.49961	37.791898545338896	-122.438554394686	(37.7918985453389, -122.438554394686)
37486	37486	227656	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	148 Buena Vista Ter	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6001371.492269999	2107387.94373	37.7665628167523	-122.43851240444799	(37.7665628167523, -122.438512404448)
162971	162971	227657	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	117 States St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6001570.048769999	2106180.8326	37.7632596788053	-122.437739171852	(37.7632596788053, -122.437739171852)
186507	186507	227658	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	111 States St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6001589.01566	2106181.9491	37.763263822894295	-122.437673651738	(37.7632638228943, -122.437673651738)
186363	186363	129407	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2033 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001882.3909599995	2115581.31929	37.789088813243396	-122.437332045161	(37.7890888132434, -122.437332045161)
152338	152338	227651	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	4118 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6001694.86954	2103534.27623	37.75599997444	-122.43711796243	(37.75599997444, -122.43711796243)
49437	49437	227622	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	521 Clipper St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			62	Width 3ft		6001670.93131	2100857.28025	37.748648223551	-122.43700910221001	(37.748648223551, -122.43700910221)
165161	165161	227641	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	582 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6001827.41036	2102469.65818	37.753084321989	-122.436583393722	(37.753084321989, -122.436583393722)
53384	53384	227624	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	4283 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6002006.21213	2101168.55205	37.749521953590396	-122.43587197511499	(37.7495219535904, -122.435871975115)
151159	151159	227625	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	4283 25th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6002039.82763	2101169.8407900003	37.749527401673	-122.435755824069	(37.749527401673, -122.435755824069)
157251	157251	227646	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	4082 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002634.29607	2102415.94957	37.7529826707309	-122.43378918933	(37.7529826707309, -122.43378918933)
154729	154729	176975	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	248 London St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002517.77047	2092300.43042	37.7252011818667	-122.43346933824301	(37.7252011818667, -122.433469338243)
129683	129683	227642	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3801 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6002972.163319999	2103558.74094	37.756139670625295	-122.432702408096	(37.7561396706253, -122.432702408096)
163312	163312	227643	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3801 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6002989.53011	2103560.80368	37.7561463193257	-122.432642495251	(37.7561463193257, -122.432642495251)
147603	147603	129408	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2199 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003263.17406	2116138.42129	37.7906968721156	-122.432594525436	(37.7906968721156, -122.432594525436)
179940	179940	227644	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3801 21st St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6003004.720380001	2103560.48994	37.756146319318496	-122.43258993978901	(37.7561463193185, -122.432589939789)
55145	55145	129409	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2199 Webster St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6003265.25593	2116107.39334	37.7906117953446	-122.43258510502399	(37.7906117953446, -122.432585105024)
183006	183006	129410	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2199 Webster St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6003271.2174	2116075.89812	37.7905256555748	-122.43256222807301	(37.7905256555748, -122.432562228073)
40498	40498	129411	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2111 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003275.408009999	2116033.9816799997	37.790410801365105	-122.43254473354901	(37.7904108013651, -122.432544733549)
157755	157755	129412	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2111 Webster St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003281.29754	2115999.00202	37.790315090121005	-122.432521856625	(37.790315090121, -122.432521856625)
56261	56261	227645	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3801 21st St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6003027.84051	2103561.52563	37.7561504741859	-122.432510056589	(37.7561504741859, -122.432510056589)
26349	26349	129413	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2111 Webster St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003291.44456	2115944.18125	37.79016514166771	-122.43248283141399	(37.7901651416677, -122.432482831414)
62411	62411	176924	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	525 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6002840.55904	2090695.62	37.720813038882206	-122.43223893347799	(37.7208130388822, -122.432238933478)
71664	71664	227629	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	62 Natick St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003056.07384	2095532.6693400003	37.7341067067448	-122.431839162348	(37.7341067067448, -122.431839162348)
23366	23366	227653	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3750 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003384.06107	2103624.93542	37.7563447763019	-122.43128265198901	(37.7563447763019, -122.431282651989)
72449	72449	227655	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2 Belcher St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6003762.03013	2108315.13286	37.769244345078704	-122.430310116133	(37.7692443450787, -122.430310116133)
57506	57506	227659	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	248 Fillmore St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6003786.3248	2109251.28052	37.771816154325	-122.430292880621	(37.771816154325, -122.430292880621)
157583	157583	227652	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3875 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003788.823369999	2104769.57077	37.759510603063795	-122.42996449048799	(37.7595106030638, -122.429964490488)
156333	156333	129391	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1851 Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004117.78483	2119036.12679	37.798701658520706	-122.42984439412399	(37.7987016585207, -122.429844394124)
55800	55800	227661	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	8 Addison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6003680.16981	2096890.8857099998	37.7378714190205	-122.42977831104099	(37.7378714190205, -122.429778311041)
150746	150746	176967	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Craut St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004019.42662	2094104.5358400003	37.7302399367234	-122.428406793639	(37.7302399367234, -122.428406793639)
28952	28952	176968	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Craut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004019.9865	2094083.3714700001	37.7301818557853	-122.428403350153	(37.7301818557853, -122.428403350153)
59805	59805	176969	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	134 Craut St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004020.786	2094067.71187	37.7301389032718	-122.428399470475	(37.7301389032718, -122.428399470475)
157316	157316	176970	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	146 Trumbull St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004341.61716	2094290.0126599998	37.7307674412459	-122.42730614487301	(37.7307674412459, -122.427306144873)
174454	174454	227588	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	435 Oak St	1	: 4	Tree 1	Private 1			3	Width 3ft		6004887.16184	2110182.76224	37.77443606920671	-122.42655134748001	(37.7744360692067, -122.42655134748)
45275	45275	227654	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	210 Liberty St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004930.05045	2104005.07306	37.7574760371124	-122.42596313868201	(37.7574760371124, -122.425963138682)
182098	182098	227599	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3542 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6005268.27661	2106072.0060799997	37.7631704570704	-122.424940469222	(37.7631704570704, -122.424940469222)
47927	47927	227620	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	55 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005907.97007	2102264.4901400004	37.752752018913796	-122.422457421298	(37.7527520189138, -122.422457421298)
187479	187479	227589	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	23 27th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006036.6609	2100222.07218	37.7471512660344	-122.42186731675	(37.7471512660344, -122.42186731675)
158100	158100	227666	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	46 Gough St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6006306.62249	2109592.20963	37.772894696857705	-122.421599203664	(37.7728946968577, -122.421599203664)
69926	69926	227665	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	46 Gough St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6006330.78292	2109566.87483	37.7728264958779	-122.421513830121	(37.7728264958779, -122.421513830121)
162454	162454	227640	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1098 22nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6006270.9018	2103197.69782	37.7553348592182	-122.421268598461	(37.7553348592182, -122.421268598461)
54446	54446	129451	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1147 Filbert St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			9	Width 3ft		6007395.89235	2119499.90916	37.80016017810029	-122.418533970572	(37.8001601781003, -122.418533970572)
162168	162168	176971	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	20 Tulane St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6007468.11752	2093808.15267	37.7296206815304	-122.416463191631	(37.7296206815304, -122.416463191631)
42869	42869	129448	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1190 Pine St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008230.449580001	2115909.44994	37.79034861235171	-122.415391745646	(37.7903486123517, -122.415391745646)

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