Street_Tree_List

Data source: data.sfgov.org

138 rows where PlotSize = "Width 3ft" and qSpecies = 30

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
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)
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)
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)
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)
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)
27806	27806	129444	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1338 Clay St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008418.059880001	2116953.62618	37.793226207275794	-122.414816555443	(37.7932262072758, -122.414816555443)
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)
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)
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)
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)
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)
37043	37043	191271	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014227.23158	2110805.88928	37.776670625478395	-122.394285663563	(37.7766706254784, -122.394285663563)
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)
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)
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)
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)
43921	43921	227634	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3238 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008149.92124	2100968.79152	37.7493205414166	-122.414612642259	(37.7493205414166, -122.414612642259)
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)
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)
46075	46075	191248	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	611 San Bruno Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010994.55519	2105384.5641	37.7616046825239	-122.405086676019	(37.7616046825239, -122.405086676019)
46359	46359	129457	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	822 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010137.05679	2118184.23209	37.7967015887668	-122.408955554965	(37.7967015887668, -122.408955554965)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
56287	56287	227611	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	66 Balmy St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		6008811.16325	2101739.4503099998	37.751473726132005	-122.412380510571	(37.751473726132, -122.412380510571)
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)
56561	56561	191262	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	690 Wisconsin St	5	: 4	Tree 1	Private 1			15	Width 3ft		6012676.19431	2104276.36771	37.7586556841436	-122.399192740559	(37.7586556841436, -122.399192740559)
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)
58227	58227	227613	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	210 Holladay Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010812.412330001	2099853.77151	37.746408165199796	-122.405327133143	(37.7464081651998, -122.405327133143)
59034	59034	129459	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	458 Jackson St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6011895.81451	2118092.21584	37.7965472956624	-122.402863344166	(37.7965472956624, -122.402863344166)
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)
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)
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)
62414	62414	191272	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014208.1321	2110827.64494	37.776729299941394	-122.394353258399	(37.7767292999414, -122.394353258399)
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)
64332	64332	227614	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	210 Holladay Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6010810.25772	2099834.79777	37.746355946971605	-122.405333247626	(37.7463559469716, -122.405333247626)
64750	64750	129447	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1190 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008246.65377	2115911.69756	37.7903556945065	-122.41533583927799	(37.7903556945065, -122.415335839278)
64764	64764	191274	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014170.53603	2110866.45323	37.7768337688053	-122.394486033405	(37.7768337688053, -122.394486033405)
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)
66909	66909	129449	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	884 Union St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6008727.37725	2119383.41122	37.799915172210206	-122.41391825502899	(37.7999151722102, -122.413918255029)
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)
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)
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)
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)
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)
71984	71984	191276	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014137.59227	2110902.38763	37.776930605110394	-122.394602513603	(37.7769306051104, -122.394602513603)
72025	72025	191277	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6014120.49796	2110919.7593900003	37.7769773536703	-122.394662865301	(37.7769773536703, -122.394662865301)
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)
74170	74170	129446	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1329 Washington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6008344.2402	2117236.00141	37.7939973921104	-122.415091973713	(37.7939973921104, -122.415091973713)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
131733	131733	191263	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	728 Wisconsin St	2	: 4	Tree 1	Private 1			13	Width 3ft		6012693.0382199995	2104091.70249	37.7581495726586	-122.399121524154	(37.7581495726586, -122.399121524154)
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)
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)
137572	137572	129440	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	754 Post St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008519.418319999	2114901.84945	37.7875982238142	-122.414320608106	(37.7875982238142, -122.414320608106)
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)
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)
148096	148096	176961	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	41 Teddy Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6011207.15899	2087778.71194	37.7132746363936	-122.403112916852	(37.7132746363936, -122.403112916852)
148228	148228	129462	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	584 Washington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6011873.80865	2117764.68671	37.7956467505394	-122.402916441935	(37.7956467505394, -122.402916441935)
148356	148356	129461	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	468 Jackson St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6011829.8803199995	2118083.5136599997	37.796519719768895	-122.403090879839	(37.7965197197689, -122.403090879839)
148459	148459	129460	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	468 Jackson St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6011856.71365	2118087.11906	37.7965311177706	-122.402998283841	(37.7965311177706, -122.402998283841)
150569	150569	129445	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	24 Priest St	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008315.59279	2117230.60537	37.793980966003	-122.415190714801	(37.793980966003, -122.415190714801)
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)
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)
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)
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)
152929	152929	227636	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3232 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008200.59079	2100972.6589	37.749334006979396	-122.414437698959	(37.7493340069794, -122.414437698959)
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)
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)
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)
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)
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)
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)
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)
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)
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)
158779	158779	227635	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	3234 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008177.73099	2100971.3435400003	37.7493291110692	-122.41451665582198	(37.7493291110692, -122.414516655822)
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)
162297	162297	191270	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6014244.47605	2110787.29844	37.7766205377503	-122.39422470752899	(37.7766205377503, -122.394224707529)
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)

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