Street_Tree_List

Data source: data.sfgov.org

151 rows where qSiteInfo = 2 and qSpecies = 103 sorted by SiteOrder

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, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▼	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
43077	43077	191722	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	1100 25th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			6014479.640380001	2101959.5389	37.752394509601494	-122.392793471535	(37.7523945096015, -122.392793471535)
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)
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)
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)
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)
51382	51382	207780	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	250 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 10ft		5993075.61435	2096444.65306	37.7360399631594	-122.46641070800501	(37.7360399631594, -122.466410708005)
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)
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)
53478	53478	207782	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	260 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 10ft		5993076.07579	2096352.6988099997	37.7357875063795	-122.466402431535	(37.7357875063795, -122.466402431535)
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)
55842	55842	207761	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	345 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5993145.033430001	2095739.54752	37.7341079244482	-122.46611947693701	(37.7341079244482, -122.466119476937)
60450	60450	207766	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	14 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5993184.09693	2097461.91411	37.7388393665447	-122.46610954301799	(37.7388393665447, -122.466109543018)
60463	60463	207807	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	25 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 10ft		5993231.15579	2097483.74028	37.7389020106052	-122.46594842230199	(37.7389020106052, -122.465948422302)
61081	61081	208914	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	45 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 10ft		5991964.75621	2096031.6123	37.7348416956868	-122.470221288386	(37.7348416956868, -122.470221288386)
61439	61439	208913	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	25 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			52	Width 10ft		5991855.18446	2096027.3519599999	37.7348236624713	-122.470599802253	(37.7348236624713, -122.470599802253)
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)
64951	64951	208942	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5992406.13159	2095989.66706	37.7347520323855	-122.468692262863	(37.7347520323855, -122.468692262863)
65901	65901	208933	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	405 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 10ft		5992936.60702	2096064.2661700002	37.7349874937845	-122.466863664131	(37.7349874937845, -122.466863664131)
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)
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)
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)
72305	72305	208950	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	440 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 10ft		5992985.54967	2096006.72468	37.734832323836706	-122.46669027215599	(37.7348323238367, -122.466690272156)
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)
73538	73538	207772	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	60 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 10ft		5993256.95856	2097201.9739	37.7381298392237	-122.46583874187	(37.7381298392237, -122.46583874187)
74311	74311	208919	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 10ft		5992247.91507	2096042.0705099998	37.734886777797996	-122.469243079632	(37.734886777798, -122.469243079632)
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)
75518	75518	191738	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	920 Vermont St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39			6011311.04969	2104026.1978700003	37.757892599481	-122.40389645386699	(37.757892599481, -122.403896453867)
76551	76551	224247	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	527 Powhattan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			46			6008745.222630001	2098103.60695	37.74148680607821	-122.412351580256	(37.7414868060782, -122.412351580256)
76666	76666	207779	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	126 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 10ft		5993175.19587	2096740.86685	37.7368590378112	-122.46608793591001	(37.7368590378112, -122.46608793591)
76936	76936	208937	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	64 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 10ft		5991925.34536	2095973.96809	37.734681140613105	-122.47035334753201	(37.7346811406131, -122.470353347532)
76953	76953	208935	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	3 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 10ft		5991812.79149	2095969.62922	37.7346627188958	-122.47074216493401	(37.7346627188958, -122.470742164934)
77267	77267	207777	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	118 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			34	Width 10ft		5993220.0955300005	2096827.0991599998	37.737098400464795	-122.465938963216	(37.7370984004648, -122.465938963216)
92772	92772	114075	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	24 HIGUERA AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26			5987903.0	2090420.0	37.7191979850677	-122.483852684784	(37.7191979850677, -122.483852684784)
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)
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)
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)
130507	130507	207805	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	35 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 10ft		5993257.8737699995	2097404.51842	37.738686028527	-122.46585029007099	(37.738686028527, -122.465850290071)
131911	131911	207759	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	315 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 10ft		5993145.97421	2095838.45755	37.7343795610583	-122.46612340966999	(37.7343795610583, -122.46612340967)
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)
137042	137042	207787	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	292 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 10ft		5993086.25016	2096104.5741400002	37.7351068050182	-122.466349227661	(37.7351068050182, -122.466349227661)
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)
147322	147322	207803	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	55 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5993318.6344099995	2097122.65017	37.737915593714106	-122.465619738075	(37.7379155937141, -122.465619738075)
149306	149306	207808	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	15 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 10ft		5993219.0538800005	2097526.21938	37.7390179494069	-122.46599335061899	(37.7390179494069, -122.465993350619)
153159	153159	207790	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	265 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39	Width 10ft		5993131.48438	2096255.5032900001	37.735523828762005	-122.466203802777	(37.735523828762, -122.466203802777)
153757	153757	207801	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	75 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5993316.85986	2097021.89165	37.737638833663794	-122.465618555459	(37.7376388336638, -122.465618555459)
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)
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)
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)
157431	157431	207769	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	40 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40	Width 10ft		5993228.66009	2097329.84492	37.7384793085579	-122.46594587182899	(37.7384793085579, -122.465945871829)
157860	157860	208927	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	301 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 10ft		5992731.01578	2096057.52147	37.7349571065737	-122.46757396937299	(37.7349571065737, -122.467573969373)
158211	158211	208916	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	47 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40	Width 10ft		5992082.23886	2096035.7065400002	37.7348597288875	-122.469815411761	(37.7348597288875, -122.469815411761)
158456	158456	207762	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	355 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 10ft		5993165.17049	2095669.26931	37.7339161197195	-122.46604475226499	(37.7339161197195, -122.466044752265)
159777	159777	208923	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	201 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5992447.89906	2096049.02744	37.734917433899	-122.468552177239	(37.734917433899, -122.468552177239)
160736	160736	207773	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	80 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			58	Width 10ft		5993272.22832	2097088.94625	37.7378203744176	-122.465777737259	(37.7378203744176, -122.465777737259)
162142	162142	207781	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	256 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 10ft		5993074.748819999	2096403.4667	37.7359268257591	-122.466410707985	(37.7359268257591, -122.466410707985)
162672	162672	207760	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	333 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 10ft		5993144.47081	2095802.99513	37.734282103340796	-122.46612603120501	(37.7342821033408, -122.466126031205)
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)
164844	164844	208930	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	435 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			55	Width 10ft		5993068.37064	2096069.711	37.735010047856704	-122.466408510055	(37.7350100478567, -122.466408510055)
165081	165081	207774	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	98 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 10ft		5993269.03182	2097018.73215	37.7376273996789	-122.465783688974	(37.7376273996789, -122.465783688974)
165361	165361	207798	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5993265.61107	2096796.17632	37.7370161196856	-122.465779350629	(37.7370161196856, -122.465779350629)
165620	165620	207802	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	65 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 10ft		5993322.83202	2097078.2937	37.7377940440554	-122.465602003431	(37.7377940440554, -122.465602003431)
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)
167226	167226	208947	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	340 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 10ft		5992761.11825	2096003.55707	37.734810671779705	-122.467465972472	(37.7348106717797, -122.467465972472)
167382	167382	207793	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	215 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38	Width 10ft		5993139.697869999	2096516.18073	37.7362400578338	-122.466194343712	(37.7362400578338, -122.466194343712)
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)
173563	173563	208921	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	135 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30	Width 10ft		5992336.36345	2096045.4635	37.7349012047205	-122.46893753225001	(37.7349012047205, -122.46893753225)
175986	175986	207763	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	290 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			36	Width 10ft		5993266.97338	2095443.21542	37.7333013044925	-122.46567637377599	(37.7333013044925, -122.465676373776)
176352	176352	208925	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	235 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 10ft		5992554.16067	2096052.7030900002	37.734933663950294	-122.46818506409599	(37.7349336639503, -122.468185064096)
178890	178890	207796	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	145 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45	Width 10ft		5993217.29355	2096710.01575	37.736776757040204	-122.465940145823	(37.7367767570402, -122.465940145823)
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)
180635	180635	208944	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	234 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5992497.26068	2095992.6782799999	37.73476556447329	-122.468377420108	(37.7347655644733, -122.468377420108)
181003	181003	191736	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Helena St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			57			6010895.577219999	2096228.10312	37.7364575084979	-122.40478434551399	(37.7364575084979, -122.404784345514)
181129	181129	207771	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	50 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 10ft		5993253.43088	2097238.9026200003	37.7382310327445	-122.465853621172	(37.7382310327445, -122.465853621172)
185411	185411	208939	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	100 Saint Francis Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 10ft		5992155.70572	2095974.23732	37.7346951961161	-122.469556940308	(37.7346951961161, -122.469556940308)
188685	188685	207791	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	255 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 10ft		5993127.95212	2096331.51719	37.7357323401679	-122.466221537416	(37.7357323401679, -122.466221537416)
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)
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)
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)
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)
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)
49984	49984	208918	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 10ft		5992207.01448	2096041.6179	37.7348831715052	-122.46938445304899	(37.7348831715052, -122.469384453049)

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