Street_Tree_List

Data source: data.sfgov.org

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

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
113956	113956	114069	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	2 HIGUERA AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40			5988091.0	2090188.0	37.7185719141165	-122.483185851801	(37.7185719141165, -122.483185851801)
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)
138466	138466	114076	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	24 HIGUERA AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5987903.0	2090420.0	37.7191979850677	-122.483852684784	(37.7191979850677, -122.483852684784)
54108	54108	176348	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	0 Fuente Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26			5989603.79735	2090546.09261	37.7196430676648	-122.47798295295799	(37.7196430676648, -122.477982952958)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
152307	152307	208936	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	3 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 10ft		5991855.38456	2095971.03212	37.7346690339426	-122.470595009771	(37.7346690339426, -122.470595009771)
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)
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)
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)
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)
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)
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)
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)
131518	131518	208943	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			39	Width 10ft		5992457.65692	2095992.19703	37.7347619554908	-122.46851430770701	(37.7347619554908, -122.468514307707)
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)
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)
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)
173362	173362	208948	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	340 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			32	Width 10ft		5992820.42769	2095999.6816200002	37.734803454707496	-122.46726063928499	(37.7348034547075, -122.467260639285)
71759	71759	208946	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	300 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 10ft		5992719.83793	2096001.79663	37.7348034547201	-122.467608563598	(37.7348034547201, -122.467608563598)
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)
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)
153452	153452	208949	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	402 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 10ft		5992933.736169999	2096006.17085	37.7348278128415	-122.46686936763099	(37.7348278128415, -122.466869367631)
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)
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)
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)
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)
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)
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)
62096	62096	208915	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	47 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 10ft		5992029.43062	2096033.53444	37.734850712276796	-122.469997828452	(37.7348507122768, -122.469997828452)
165006	165006	208952	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	440 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 10ft		5993062.868430001	2096011.9995	37.734851268974296	-122.466423339872	(37.7348512689743, -122.466423339872)
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)
137770	137770	208917	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	101 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 10ft		5992152.90186	2096040.12972	37.734875958047496	-122.46957142927499	(37.7348759580475, -122.469571429275)
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)
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)
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)
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)
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)
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)
181826	181826	208924	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	235 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 10ft		5992506.66791	2096052.3886900002	37.7349300576612	-122.468349238953	(37.7349300576612, -122.468349238953)
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)
62516	62516	208926	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	301 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			43	Width 10ft		5992668.30531	2096054.89965	37.7349462868375	-122.467790589077	(37.7349462868375, -122.467790589077)
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)
150553	150553	208928	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	335 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			44	Width 10ft		5992778.536119999	2096059.1494200001	37.7349643200549	-122.467409794552	(37.7349643200549, -122.467409794552)
135413	135413	208934	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	405 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33	Width 10ft		5992888.064180001	2096062.32962	37.734979374706505	-122.467031351742	(37.7349793747065, -122.467031351742)
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)
50349	50349	208932	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	435 Saint Francis Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			47	Width 10ft		5992980.53983	2096066.6285400002	37.734996515770604	-122.4667119458	(37.7349965157706, -122.4667119458)
76846	76846	208931	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	435 Saint Francis Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 10ft		5993027.44059	2096068.9282799999	37.735005536864904	-122.46654996171101	(37.7350055368649, -122.466549961711)
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)
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)
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)
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)
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)
68451	68451	207786	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	290 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			31	Width 10ft		5993081.96122	2096160.8531	37.735261085532706	-122.46636814486999	(37.7352610855327, -122.46636814487)
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)
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)
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)
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)
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)
148956	148956	207783	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	260 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 10ft		5993078.05201	2096316.5606	37.7356883939084	-122.466392973362	(37.7356883939084, -122.466392973362)
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)
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)
130074	130074	207792	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	255 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 10ft		5993127.3071800005	2096365.9249099998	37.7358267779692	-122.46622626692499	(37.7358267779692, -122.466226266925)
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)
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)
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)
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)
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)
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)
66266	66266	191737	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	200 Helena St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6010885.73151	2096220.33708	37.736435634280895	-122.40481783988199	(37.7364356342809, -122.404817839882)
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)
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)
133823	133823	207795	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	213 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35	Width 10ft		5993167.32945	2096610.60875	37.7365009277821	-122.466105670558	(37.7365009277821, -122.466105670558)
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)
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)
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)
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)
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)
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)
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)
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)
74106	74106	207797	Undocumented 2	Eucalyptus globulus :: Blue Gum 103	145 Santa Clara Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			42	Width 10ft		5993240.654130001	2096747.6644599999	37.7368814785997	-122.465862113458	(37.7368814785997, -122.465862113458)
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)
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)
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)
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)
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)
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)

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