Street_Tree_List

Data source: data.sfgov.org

446 rows where qSpecies = 103 sorted by PlotSize 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, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▲	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
24218	24218	208954	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	600 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 8ft		5993495.97502	2095994.9515900002	37.7348294415148	-122.464924714122	(37.7348294415148, -122.464924714122)
33873	33873	208955	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	630 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 8ft		5993530.979180001	2095998.56422	37.7348413791301	-122.464803955838	(37.7348413791301, -122.464803955838)
69718	69718	208957	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	625 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5993588.443419999	2096129.23717	37.73520348755321	-122.46461476908001	(37.7352034875532, -122.46461476908)
70660	70660	208956	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	630 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 8ft		5993584.21489	2095997.1565599998	37.7348405832115	-122.464619800786	(37.7348405832115, -122.464619800786)
155663	155663	208953	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	502 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 8ft		5993239.50835	2095986.2551799999	37.734790772481	-122.46581076936701	(37.734790772481, -122.465810769367)
170955	170955	208959	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	601 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 8ft		5993493.92403	2096119.04846	37.7351700624345	-122.46494081468	(37.7351700624345, -122.46494081468)
171833	171833	208958	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	625 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5993531.51586	2096121.15742	37.7351780205546	-122.464811000239	(37.7351780205546, -122.464811000239)
184880	184880	208960	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	601 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 8ft		5993401.29019	2096115.48675	37.735154941244396	-122.465260822223	(37.7351549412444, -122.465260822223)
29038	29038	208963	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	90 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 6ft		5993939.166669999	2096822.57013	37.7371274206966	-122.463452499655	(37.7371274206966, -122.463452499655)
36761	36761	208976	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	100 Yerba Buena Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		5994151.01662	2096664.6627200001	37.7367060496466	-122.462708592139	(37.7367060496466, -122.462708592139)
44792	44792	208974	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	130 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 6ft		5994229.97779	2096604.2011400003	37.7365445844613	-122.462431207033	(37.7365445844613, -122.462431207033)
47668	47668	208973	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	136 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 6ft		5994259.725980001	2096572.0955299998	37.7364581434207	-122.46232602774799	(37.7364581434207, -122.462326027748)
52363	52363	208968	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	34 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5993576.11533	2097077.3704400002	37.737806114757795	-122.46472622025298	(37.7378061147578, -122.464726220253)
65175	65175	208929	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	501 Saint Francis Blvd	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			34	Width 6ft		5993145.62708	2096072.03007	37.735020873007	-122.466141577798	(37.735020873007, -122.466141577798)
66396	66396	208966	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	44 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 6ft		5993666.080159999	2097016.89785	37.7376452584166	-122.46441078125099	(37.7376452584166, -122.464410781251)
75990	75990	208962	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	90 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 6ft		5993970.2453	2096804.3744	37.7370792503013	-122.463343727552	(37.7370792503013, -122.463343727552)
114900	114900	208965	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	56 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 6ft		5993745.43898	2096960.72106	37.7374955851482	-122.464132325055	(37.7374955851482, -122.464132325055)
154505	154505	208971	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	150 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 6ft		5994318.90627	2096521.2556599998	37.736321957275706	-122.462117732164	(37.7363219572757, -122.462117732164)
156141	156141	208964	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	60 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 6ft		5993779.53053	2096936.1958400002	37.737430209820296	-122.46401267564801	(37.7374302098203, -122.464012675648)
160755	160755	208975	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	100 Yerba Buena Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 6ft		5994177.11325	2096643.32557	37.7366489660835	-122.462616818123	(37.7366489660835, -122.462616818123)
164085	164085	208969	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	30 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 6ft		5993545.78483	2097101.19005	37.737869768775795	-122.46483281598302	(37.7378697687758, -122.464832815983)
187171	187171	208972	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	136 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 6ft		5994281.63654	2096550.25213	37.7363994284866	-122.462248690521	(37.7363994284866, -122.462248690521)
188184	188184	208970	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	20 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 6ft		5993484.40904	2097144.7715200002	37.7379858937365	-122.46504818472499	(37.7379858937365, -122.465048184725)
188785	188785	208967	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	44 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5993630.4889400005	2097044.9006700001	37.737720095508706	-122.46453586883001	(37.7377200955087, -122.46453586883)
33426	33426	224248	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	512 Clipper St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			27	Width 5ft		6001839.26935	2100907.02963	37.7487943903519	-122.43643055213998	(37.7487943903519, -122.43643055214)
64417	64417	224250	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	425 Eugenia Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			34	Width 5ft		6007149.05774	2097827.31438	37.740638468384795	-122.417851002914	(37.7406384683848, -122.417851002914)
149487	149487	208977	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	300x Marietta Dr	45	Median : Cutout 11	Tree 1	DPW 2			27	Width 5ft		5999505.82373	2097502.74743	37.7393141797969	-122.44425497048401	(37.7393141797969, -122.444254970484)
151150	151150	126581	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	556 Pine St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 5ft		6011285.65956	2116338.25251	37.7916972455684	-122.404851076143	(37.7916972455684, -122.404851076143)
29186	29186	209002	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	115 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 4ft		5994119.61861	2096725.9639	37.736872559114104	-122.462821593742	(37.7368725591141, -122.462821593742)
36907	36907	208993	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	31 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 4ft		5993535.26127	2097150.77507	37.7380053101076	-122.46487280074899	(37.7380053101076, -122.464872800749)
40168	40168	208995	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	21 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 4ft		5993486.0432	2097190.73028	37.7381121792369	-122.465045871672	(37.7381121792369, -122.465045871672)
52160	52160	208998	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	10 Yerba Buena Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 4ft		5993381.76992	2097221.25805	37.7381899876824	-122.465408610532	(37.7381899876824, -122.465408610532)
56324	56324	208990	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	51 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 4ft		5993670.13129	2097058.8329	37.7377606351295	-122.46439981849899	(37.7377606351295, -122.464399818499)
63161	63161	208994	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	21 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 4ft		5993511.280230001	2097168.00802	37.7380512447772	-122.46495696559799	(37.7380512447772, -122.464956965598)
65353	65353	207764	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1520 Monterey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5993438.38203	2095281.4007599999	37.7328668869905	-122.46507202306299	(37.7328668869905, -122.465072023063)
73251	73251	208996	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	11 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 4ft		5993421.96829	2097241.5815	37.7382481090644	-122.465271101502	(37.7382481090644, -122.465271101502)
74972	74972	208988	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	85 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 4ft		5993834.637730001	2096941.34521	37.7374475244853	-122.463822519421	(37.7374475244853, -122.463822519421)
75055	75055	208997	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	10 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 4ft		5993343.646380001	2097250.7379	37.738268733207605	-122.465542562746	(37.7382687332076, -122.465542562746)
77037	77037	208999	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	10 Yerba Buena Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 4ft		5993404.322790001	2097201.32336	37.7381365526709	-122.465329186907	(37.7381365526709, -122.465329186907)
127109	127109	208991	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	45 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 4ft		5993638.39674	2097082.374	37.73782344378579	-122.46451124811199	(37.7378234437858, -122.464511248112)
133032	133032	209000	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	135 Yerba Buena Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 4ft		5994206.5655	2096669.1829099997	37.7367216600723	-122.462516864768	(37.7367216600723, -122.462516864768)
133286	133286	209001	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	125 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 4ft		5994148.93284	2096709.76404	37.7368297666801	-122.462719067425	(37.7368297666801, -122.462719067425)
147084	147084	208989	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	55 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 4ft		5993734.999890001	2097013.08627	37.7376387653037	-122.46417221806699	(37.7376387653037, -122.464172218067)
149384	149384	207754	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1364 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		5993663.7534300005	2106217.17575	37.7629067380829	-122.46508685559999	(37.7629067380829, -122.4650868556)
165255	165255	224249	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	500x 27th St	14	Median : Cutout 11	Tree 1	DPW 2			48	Width 4ft		6002852.0087	2100065.56768	37.7465414276517	-122.432868400457	(37.7465414276517, -122.432868400457)
183947	183947	208992	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	45 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 4ft		5993607.99739	2097104.1803400002	37.7378815660919	-122.46461793558001	(37.7378815660919, -122.46461793558)
10119	10119	173856	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	118 Saint Mary's Ave	2	Sidewalk: Property side : Yard 9	Tree 1	DPW 2				Width 3ft		6003956.18287	2095944.61673	37.735288805319904	-122.42875656067	(37.7352888053199, -122.42875656067)
23367	23367	208982	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	320 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 3ft		5993096.565780001	2095876.3159599998	37.7344806601409	-122.46629697974501	(37.7344806601409, -122.466296979745)
24602	24602	208981	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	310 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 3ft		5993092.40274	2095921.0497	37.7346032476459	-122.466314622626	(37.7346032476459, -122.466314622626)
26913	26913	224258	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	355 Buena Vista Ave East	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 3ft		6001075.26018	2107893.8305599997	37.7679350014146	-122.439573286101	(37.7679350014146, -122.439573286101)
28820	28820	209004	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	156 Kensington Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5994803.6888	2098556.09355	37.7419370183784	-122.460589057359	(37.7419370183784, -122.460589057359)
32753	32753	224251	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	177 Powhattan Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 3ft		6008204.54136	2098121.72815	37.741506207147005	-122.414222358085	(37.741506207147, -122.414222358085)
35751	35751	224259	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	355 Buena Vista Ave East	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 3ft		6001093.91519	2107903.0746400002	37.767961445086605	-122.43950942341999	(37.7679614450866, -122.43950942342)
36584	36584	208984	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	354 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 3ft		5993109.71634	2095669.50335	37.7339135629453	-122.466236489538	(37.7339135629453, -122.466236489538)
36905	36905	224255	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	388 Corbett Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		5999122.55283	2104753.1321799997	37.7592000986313	-122.446101520571	(37.7592000986313, -122.446101520571)
44163	44163	224253	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	755 Sanchez St	6	Front Yard : Yard 7	Tree 1	Private 1			28	Width 3ft		6003620.8208099995	2103873.1752	37.757039798462294	-122.430481566473	(37.7570397984623, -122.430481566473)
51100	51100	209006	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	172 Kensington Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5994773.63128	2098602.47798	37.7420626491773	-122.46069634646099	(37.7420626491773, -122.460696346461)
52384	52384	208985	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	372 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			59	Width 3ft		5993126.32529	2095592.5648700001	37.7337032672843	-122.466173478533	(37.7337032672843, -122.466173478533)
53855	53855	208983	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	330 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 3ft		5993097.51511	2095800.07009	37.73427136274	-122.466288158284	(37.73427136274, -122.466288158284)
54495	54495	118438	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	5201 Anza St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5982520.38622	2111663.82262	37.7772127952946	-122.50403070229099	(37.7772127952946, -122.504030702291)
61025	61025	224257	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	355 Buena Vista Ave East	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 3ft		6001064.07525	2107884.43165	37.767908557750204	-122.439611299541	(37.7679085577502, -122.439611299541)
67133	67133	209003	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	96 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 3ft		5994450.97172	2101378.39351	37.7496660456507	-122.462013248027	(37.7496660456507, -122.462013248027)
69214	69214	208986	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	372 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 3ft		5993143.09775	2095558.09178	37.7336095804246	-122.46611298742701	(37.7336095804246, -122.466112987427)
69421	69421	224263	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	11 Germania St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6004229.44428	2108900.2308400003	37.770877346636205	-122.42873507047399	(37.7708773466362, -122.428735070474)
130326	130326	209005	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	172 Kensington Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5994782.01847	2098589.82391	37.7420283868014	-122.460666429624	(37.7420283868014, -122.460666429624)
137374	137374	224256	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	355 Buena Vista Ave East	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 3ft		6001050.217680001	2107873.3371599996	37.7678773063135	-122.439658435714	(37.7678773063135, -122.439658435714)
146709	146709	224254	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	190 Storrie St	4	Front Yard : Yard 7	Tree 1	Private 1			16	Width 3ft		6000752.12131	2105271.59361	37.760716590308704	-122.440502889194	(37.7607165903087, -122.440502889194)
151444	151444	208979	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	46 Cragmont Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		5992891.21268	2101728.13425	37.7505364203394	-122.467432335147	(37.7505364203394, -122.467432335147)
159737	159737	224252	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	177 Powhattan Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			35	Width 3ft		6008209.41115	2098117.01266	37.741493532991	-122.41420518642299	(37.741493532991, -122.414205186423)
165768	165768	208980	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	302 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5993091.73044	2095958.45065	37.7347059025462	-122.46631966423901	(37.7347059025462, -122.466319664239)
166974	166974	209007	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	172 Kensington Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 3ft		5994745.50567	2098641.39451	37.7421678860404	-122.460796414937	(37.7421678860404, -122.460796414937)
168122	168122	169607	DPW Maintained 3	Eucalyptus globulus :: Blue Gum 103	118 Saint Mary's Ave	1	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			0	Width 3ft		6003956.18287	2095944.61673	37.735288805319904	-122.42875656067	(37.7352888053199, -122.42875656067)
171841	171841	176342	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Mansell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6011455.5144	2090588.63485	37.721003982019504	-122.40245197087799	(37.7210039820195, -122.402451970878)
171861	171861	224261	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	355 Buena Vista Ave East	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 3ft		6001117.5941	2107921.40745	37.768013130033204	-122.439428835199	(37.7680131300332, -122.439428835199)
175100	175100	207765	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	356 Santa Ana Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 3ft		5992543.86147	2094436.1305	37.7304943639181	-122.46810311696998	(37.7304943639181, -122.46810311697)
175102	175102	224260	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	355 Buena Vista Ave East	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 3ft		6001102.84855	2107909.89342	37.7679806761809	-122.43947901285401	(37.7679806761809, -122.439479012854)
179310	179310	208987	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	95 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 3ft		5993980.02644	2096844.0619400002	37.7371887859367	-122.46331278907499	(37.7371887859367, -122.463312789075)
186323	186323	224264	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	11 Germania St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6004254.57068	2108904.38845	37.770890184456796	-122.42864845406	(37.7708901844568, -122.42864845406)
186405	186405	224262	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	91 Stanton St	2	: Yard 23	Tree 1	Private 1			22	Width 3ft		6000293.691000001	2103856.2070400002	37.7568041715846	-122.44198679486	(37.7568041715846, -122.44198679486)
132331	132331	208961	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1575 07th Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 2ft		5993977.82871	2104681.32491	37.75870779624321	-122.463889098911	(37.7587077962432, -122.463889098911)
3850	3850	207785	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	290 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		09/28/2017 12:00:00 AM	3	Width 10ft		5993081.87997	2096205.8056700001	37.7353845093885	-122.46637169180299	(37.7353845093885, -122.466371691803)
23922	23922	208951	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	440 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40	Width 10ft		5993021.57409	2096009.5815299999	37.734842246953896	-122.46656593187099	(37.7348422469539, -122.466565931871)
25657	25657	208945	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	234 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40	Width 10ft		5992554.30272	2095990.82137	37.73476376044329	-122.46818007286001	(37.7347637604433, -122.46818007286)
26365	26365	208940	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	100 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			37	Width 10ft		5992201.32921	2095978.5342700002	37.7347096311457	-122.469399518468	(37.7347096311457, -122.469399518468)
26956	26956	208920	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	135 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 10ft		5992288.77396	2096040.55395	37.734884974665	-122.46910170710301	(37.734884974665, -122.469101707103)
28258	28258	208938	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	66 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 10ft		5991979.81471	2095977.19537	37.7346931510662	-122.470165265142	(37.7346931510662, -122.470165265142)
29388	29388	207794	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	213 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 10ft		5993149.25155	2096563.99491	37.736371894833	-122.46616478658999	(37.736371894833, -122.46616478659)
30634	30634	207776	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	110 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 10ft		5993235.98614	2096867.2882599998	37.7372096663776	-122.46588694193001	(37.7372096663776, -122.46588694193)
30943	30943	208922	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	201 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 10ft		5992403.02946	2096048.0013299999	37.7349120244605	-122.46870723116899	(37.7349120244605, -122.468707231169)
32381	32381	207778	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	124 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 10ft		5993200.08857	2096786.31561	37.7369852648432	-122.46600517310699	(37.7369852648432, -122.466005173107)
33664	33664	207789	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	275 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 10ft		5993131.90761	2096210.54353	37.735400404893	-122.46619907325199	(37.735400404893, -122.466199073252)
34400	34400	207800	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Santa Clara Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 10ft		5993292.571380001	2096874.95335	37.737233976861205	-122.465691859205	(37.7372339768612, -122.465691859205)
40215	40215	207788	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	285 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 10ft		5993135.10109	2096167.2284099997	37.7352816566244	-122.46618488553001	(37.7352816566244, -122.46618488553)
40777	40777	207799	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 10ft		5993278.012180001	2096833.03373	37.7371180362587	-122.465739151856	(37.7371180362587, -122.465739151856)
41418	41418	207775	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	110 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 10ft		5993244.34274	2096906.29835	37.737317260394	-122.465860883191	(37.737317260394, -122.465860883191)
41832	41832	208941	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	130 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 10ft		5992287.573419999	2095984.60456	37.734731282309106	-122.469101787134	(37.7347312823091, -122.469101787134)
43824	43824	207767	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	20 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 10ft		5993205.662140001	2097402.75145	37.7386781648646	-122.466030683288	(37.7386781648646, -122.466030683288)
46031	46031	207784	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	270 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 10ft		5993081.2153199995	2096255.53806	37.735521023771604	-122.466377603044	(37.7355210237716, -122.466377603044)
46778	46778	209043	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	690 Mangels Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			54	Width 10ft		5996832.93686	2095303.5906200001	37.7331229707542	-122.453337845278	(37.7331229707542, -122.453337845278)
47715	47715	207770	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	40 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 10ft		5993240.61068	2097284.1687	37.738354582507895	-122.465901234858	(37.7383545825079, -122.465901234858)

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