Street_Tree_List

Data source: data.sfgov.org

396 rows where qSpecies = 38 sorted by qSiteInfo 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, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo ▲	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
29234	29234	186513	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1400 Lower Great Hwy	14	unknown : Yard 19	Tree 1	Private 1			5	Width 0ft		5980894.1374	2105147.1675	37.759224194224	-122.509172270667	(37.759224194224, -122.509172270667)
33000	33000	138260	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2600 GEARY BLVD	28	unknown : Yard 19	Tree 1	Private 1			2	Width 0ft		5999060.2181	2113180.9681	37.7823372358083	-122.446923566676	(37.7823372358083, -122.446923566676)
50995	50995	186509	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1400 Lower Great Hwy	10	unknown : Yard 19	Tree 1	Private 1			7	Width 0ft		5980901.3856	2105130.6001	37.759179132228	-122.509145973072	(37.759179132228, -122.509145973072)
59085	59085	185502	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2400 Sunset Blvd	56	unknown : Yard 19	Tree 1	Private 1			8	Width 0ft		5985117.0889	2098738.1726	37.7418749156753	-122.494095121998	(37.7418749156753, -122.494095121998)
65093	65093	185504	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2400 Sunset Blvd	58	unknown : Yard 19	Tree 1	Private 1			6	Width 0ft		5985115.0968	2098786.6474	37.7420078978362	-122.49410558184499	(37.7420078978362, -122.494105581845)
66913	66913	186510	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1400 Lower Great Hwy	11	unknown : Yard 19	Tree 1	Private 1			5	Width 0ft		5980902.4211	2105136.8129	37.759196251841395	-122.509142853237	(37.7591962518414, -122.509142853237)
128729	128729	105136	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	175X ESMERALDA AVE	2	unknown : Yard 19	Tree 1	DPW 2						6007213.0	2098808.0	37.7433348108676	-122.41769940776301	(37.7433348108676, -122.417699407763)
164558	164558	138264	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2600 GEARY BLVD	32	unknown : Yard 19	Tree 1	Private 1			1	Width 0ft		5999039.2359	2113177.9223	37.7823276740968	-122.44699593627199	(37.7823276740968, -122.446995936272)
182655	182655	186512	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1400 Lower Great Hwy	13	unknown : Yard 19	Tree 1	Private 1			5	Width 0ft		5980899.8324	2105147.1675	37.7592245299801	-122.509152574968	(37.7592245299801, -122.509152574968)
33669	33669	247869	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	394 Mayflower St	1	Side Yard : Yard 17	Tree 1	Private 1			9			6009720.84865	2098403.35069	37.7423645372013	-122.408999330354	(37.7423645372013, -122.408999330354)
35370	35370	248189	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	216 Esmeralda Ave	8	Side Yard : Yard 17	Tree 1	Private 1			11			6007400.67054	2098728.2959	37.7431265201804	-122.417044843446	(37.7431265201804, -122.417044843446)
123417	123417	247871	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	394 Mayflower St	3	Side Yard : Yard 17	Tree 1	Private 1			18			6009746.3542	2098404.30325	37.742368581453704	-122.40891120669201	(37.7423685814537, -122.408911206692)
188108	188108	247870	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	394 Mayflower St	2	Side Yard : Yard 17	Tree 1	Private 1			10			6009721.06953	2098395.0417	37.74234173489771	-122.40899798048099	(37.7423417348977, -122.408997980481)
94398	94398	116654	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	199x Esmeralda Ave	9	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
95215	95215	116655	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	199x Esmeralda Ave	9	Unaccepted Street : Yard 14	Tree 1	DPW 2						6007213.11808	2098808.04206	37.7433349329997	-122.417699002452	(37.7433349329997, -122.417699002452)
95391	95391	113478	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	100x ESMERALDA AVE	5	Unaccepted Street : Yard 14	Tree 1	DPW 2			8			6006917.0	2098966.0	37.7437519821991	-122.418734104398	(37.7437519821991, -122.418734104398)
95944	95944	116681	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	100 Esmeralda Ave	20	Unaccepted Street : Yard 14	Tree 1	DPW 2						6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
31147	31147	207112	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	59 Ralston St	4	Back Yard : Yard 13	Tree 1	Private 1			12			5992171.746719999	2088295.8735200001	37.7136132266511	-122.46894288591899	(37.7136132266511, -122.468942885919)
59360	59360	207117	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	41 Ralston St	9	Back Yard : Yard 13	Tree 1	Private 1			19			5992170.67066	2088214.0686700002	37.7133885481037	-122.46894065558399	(37.7133885481037, -122.468940655584)
60662	60662	207115	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	47 Ralston St	8	Back Yard : Yard 13	Tree 1	Private 1			8			5992168.43399	2088239.2563900002	37.7134575782774	-122.468950218099	(37.7134575782774, -122.468950218099)
68946	68946	207113	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	53 Ralston St	1	Back Yard : Yard 13	Tree 1	Private 1			5			5992170.39113	2088282.9530900002	37.7135776719473	-122.468946631596	(37.7135776719473, -122.468946631596)
71643	71643	207108	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	89 Ralston St	3	Back Yard : Yard 13	Tree 1	Private 1			13			5992168.92954	2088415.8272900002	37.7139424279717	-122.468961347182	(37.7139424279717, -122.468961347182)
136701	136701	207107	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	89 Ralston St	2	Back Yard : Yard 13	Tree 1	Private 1			11			5992169.5585900005	2088419.4087099999	37.7139522980308	-122.46895943344299	(37.7139522980308, -122.468959433443)
153486	153486	207109	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	75 Ralston St	2	Back Yard : Yard 13	Tree 1	Private 1			14			5992170.77084	2088338.0326	37.713728928924105	-122.46894932506599	(37.7137289289241, -122.468949325066)
162496	162496	207110	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	59 Ralston St	1	Back Yard : Yard 13	Tree 1	Private 1			7			5992170.63195	2088310.84387	37.7136542672107	-122.468947827707	(37.7136542672107, -122.468947827707)
164753	164753	207116	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	47 Ralston St	9	Back Yard : Yard 13	Tree 1	Private 1			8			5992178.8337	2088240.4151599999	37.7134613608383	-122.46891435762801	(37.7134613608383, -122.468914357628)
171720	171720	207111	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	59 Ralston St	2	Back Yard : Yard 13	Tree 1	Private 1			11			5992171.5605	2088305.6585	37.713640083085	-122.468944241206	(37.713640083085, -122.468944241206)
188129	188129	207114	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	53 Ralston St	2	Back Yard : Yard 13	Tree 1	Private 1			23			5992175.21623	2088282.1627599997	37.7135757806697	-122.468929896991	(37.7135757806697, -122.468929896991)
12496	12496	24276	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	350X Winding Way	14	Median : Cutout 11	Tree 1	DPW 2			6	8		6000825.35085	2086800.6303	37.710003801206796	-122.438925891137	(37.7100038012068, -122.438925891137)
18415	18415	13417	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	400 Marietta Dr	1	Median : Cutout 11	Tree 1	DPW 2			70	5		5999553.15658	2097034.9165400001	37.7380323275191	-122.444057708717	(37.7380323275191, -122.444057708717)
21000	21000	29586	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	500X Junipero Serra Blvd	21	Median : Cutout 11	Tree 1	DPW 2			9	3X3		5991342.7865	2093687.81781	37.7283702470744	-122.47220084100901	(37.7283702470744, -122.472200841009)
21489	21489	29601	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	900X Junipero Serra Blvd	10	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	3	3X3		5991172.090009999	2091066.888	37.7211639453471	-122.472599932234	(37.7211639453471, -122.472599932234)
21749	21749	29627	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	900X Junipero Serra Blvd	36	Median : Cutout 11	Tree 1	DPW 2		03/09/2013 12:00:00 AM	12	3X3		5991152.87782	2090760.03066	37.7203202787275	-122.472643981031	(37.7203202787275, -122.472643981031)
30866	30866	200618	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	59	Median : Cutout 11	Tree 1	DPW 2			3	Width 0ft		6016445.2081	2095088.6176	37.733637339432	-122.38551735943399	(37.733637339432, -122.385517359434)
38728	38728	200604	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	61	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6016455.981000001	2095075.886	37.7336029770488	-122.385479227084	(37.7336029770488, -122.385479227084)
72294	72294	200614	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	55	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6016432.4764	2095111.6325	37.73369982930821	-122.385562980445	(37.7336998293082, -122.385562980445)
76333	76333	200612	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	53	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6016428.558999999	2095128.7713	37.7337466722751	-122.385577718213	(37.7337466722751, -122.385577718213)
76733	76733	200616	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	57	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6016436.8835	2095099.8803	37.7336678039609	-122.385546924914	(37.7336678039609, -122.385546924914)
102052	102052	23670	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	317 Virginia Ave	1	Median : Cutout 11	Tree 1	DPW 2			3	12		6006937.941544901	2098264.8464559	37.7418279505329	-122.41861198258002	(37.7418279505329, -122.41861198258)
137132	137132	200619	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1400x La Salle Ave	60	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6016453.0429	2095085.1899	37.733628361140106	-122.38549003320101	(37.7336283611401, -122.385490033201)
143078	143078	121420	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	1155x Prague St	1	Median : Cutout 11	Tree 1	DPW 2				3x3		6000780.0	2086820.0	37.7100544057225	-122.439084019343	(37.7100544057225, -122.439084019343)
3544	3544	253465	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	98X Marston Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1		09/12/2017 12:00:00 AM	3	3x3		5998793.0	2093251.0	37.7275991927727	-122.446413796362	(37.7275991927727, -122.446413796362)
3561	3561	253462	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	98X Marston Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1		09/12/2017 12:00:00 AM	3	3x3		5998793.0	2093251.0	37.7275991927727	-122.446413796362	(37.7275991927727, -122.446413796362)
3567	3567	253463	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	98X Marston Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1		09/12/2017 12:00:00 AM	3	3x3		5998793.0	2093251.0	37.7275991927727	-122.446413796362	(37.7275991927727, -122.446413796362)
3585	3585	253464	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	98X Marston Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1		09/12/2017 12:00:00 AM	3	3x3		5998793.0	2093251.0	37.7275991927727	-122.446413796362	(37.7275991927727, -122.446413796362)
24102	24102	186759	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 0ft		5984850.1974	2106711.7495	37.7637525404811	-122.495605915184	(37.7637525404811, -122.495605915184)
34046	34046	186310	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1800 Sunset Blvd	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 0ft		5984966.7705	2102775.9332	37.7529527085207	-122.49491251324899	(37.7529527085207, -122.494912513249)
36675	36675	186762	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984853.5932	2106716.1156	37.7637647274179	-122.49559449238701	(37.7637647274179, -122.495594492387)
44625	44625	186760	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 0ft		5984860.8701	2106711.7495	37.7637531654529	-122.495569002148	(37.7637531654529, -122.495569002148)
45882	45882	186748	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 0ft		5984868.1469	2106676.3356	37.7636563549354	-122.495541222153	(37.7636563549354, -122.495541222153)
50007	50007	186756	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 0ft		5984857.4742	2106702.5322	37.7637276584797	-122.495580067458	(37.7637276584797, -122.495580067458)
51787	51787	217831	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22			5991381.66969	2095739.8250799999	37.734006793868	-122.472215938837	(37.734006793868, -122.472215938837)
66007	66007	186752	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984851.1676	2106688.9488	37.7636899929755	-122.49560087776399	(37.7636899929755, -122.495600877764)
70133	70133	186750	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984851.1676	2106678.2761	37.763660688738206	-122.49560009051399	(37.7636606887382, -122.495600090514)
73459	73459	186747	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984869.1172	2106666.6331	37.76362977141179	-122.495537150576	(37.7636297714118, -122.495537150576)
133677	133677	185961	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2001 Sunset Blvd	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 0ft		5984861.3455	2101337.8929	37.74899807274279	-122.495171051634	(37.7489980727428, -122.495171051634)
137835	137835	129468	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1151 Lombard St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11			6006718.96895	2120094.36111	37.8017542606157	-122.420918621021	(37.8017542606157, -122.420918621021)
151432	151432	186745	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984852.3804	2106661.5394	37.763614805479	-122.495594661337	(37.763614805479, -122.495594661337)
152713	152713	129469	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1085 Vallejo St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6008359.28826	2118585.88506	37.7977046844857	-122.415135501808	(37.7977046844857, -122.415135501808)
156319	156319	186749	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984860.385	2106678.2761	37.7636612284897	-122.495568210877	(37.7636612284897, -122.495568210877)
160044	160044	186041	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1900 Sunset Blvd	36	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 0ft		5984992.0482	2102149.6578	37.7512346080754	-122.494778929254	(37.7512346080754, -122.494778929254)
164300	164300	186000	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1883 47th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5981612.0444	2102288.7145	37.7514179925848	-122.506477461595	(37.7514179925848, -122.506477461595)
171541	171541	186059	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1901 Sunset Blvd	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984803.9529	2102180.8195	37.751309157700604	-122.495431671777	(37.7513091577006, -122.495431671777)
178737	178737	186058	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1901 Sunset Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984794.5256	2102183.7824	37.7513167410032	-122.495464490464	(37.7513167410032, -122.495464490464)
184000	184000	186754	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1200 Sunset Blvd	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 0ft		5984863.7808	2106693.8	37.763704051609004	-122.49555761110202	(37.763704051609, -122.495557611102)
188419	188419	129470	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	45 MacOndray Ln	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10			6008463.14234	2119145.61201	37.799247391416394	-122.414815771241	(37.7992473914164, -122.414815771241)
24900	24900	249938	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	339 Filbert St	3	Front Yard : Yard 7	Tree 1	Private 1			8	Width 0ft		6011244.68883	2120032.5219400004	37.8018385261831	-122.405253098256	(37.8018385261831, -122.405253098256)
37269	37269	227675	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	104	Front Yard : Yard 7	Tree 1	Private 1			27			6005040.407269999	2096975.5643799999	37.7381808604543	-122.425081325568	(37.7381808604543, -122.425081325568)
49267	49267	191398	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2100 Alameda St	4	Front Yard : Yard 7	Tree 1	Private 1			14			6010740.07849	2107915.77093	37.768540573414896	-122.406145147482	(37.7685405734149, -122.406145147482)
53270	53270	207125	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	4	Front Yard : Yard 7	Tree 1	Private 1			13	Width 0ft		5991332.892440001	2095658.5010099998	37.733780675521395	-122.47237864866001	(37.7337806755214, -122.47237864866)
54994	54994	191408	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Tulare St	5	Front Yard : Yard 7	Tree 1	Private 1			3			6016232.34971	2100308.61772	37.747958617113596	-122.38661714986	(37.7479586171136, -122.38661714986)
60545	60545	207126	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	3	Front Yard : Yard 7	Tree 1	Private 1			13	Width 0ft		5991329.52565	2095655.7745299998	37.733772994434204	-122.472390089849	(37.7337729944342, -122.472390089849)
72105	72105	191406	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Tulare St	8	Front Yard : Yard 7	Tree 1	Private 1			5			6016222.17813	2100305.9500599997	37.74795072915779	-122.386652137081	(37.7479507291578, -122.386652137081)
72315	72315	207127	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	2	Front Yard : Yard 7	Tree 1	Private 1			4	Width 0ft		5991327.69264	2095651.06492	37.7337599569436	-122.472396083831	(37.7337599569436, -122.472396083831)
74734	74734	227671	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	60	Front Yard : Yard 7	Tree 1	Private 1			10			6005087.18528	2097058.7145599998	37.738411814457706	-122.42492550452101	(37.7384118144577, -122.424925504521)
84781	84781	101254	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	3700X Cesar Chavez St	1	Front Yard : Yard 7	Tree 1	DPW 2						6005840.6	2100555.6	37.74805599841039	-122.422568977073	(37.7480559984104, -122.422568977073)
129429	129429	100423	Significant Tree 6	Leptospermum laevigatum :: Australian Tea Tree 38	155 Winston Dr	1	Front Yard : Yard 7	Tree 1	Private 1						5990788.0	2093142.6	37.7268410933597	-122.474078979965	(37.7268410933597, -122.474078979965)
132758	132758	191401	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2100 Alameda St	7	Front Yard : Yard 7	Tree 1	Private 1			8			6010711.19096	2107913.74245	37.768533387842396	-122.406244924566	(37.7685333878424, -122.406244924566)
136797	136797	191395	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2100 Alameda St	1	Front Yard : Yard 7	Tree 1	Private 1			22			6010771.29847	2107917.19939	37.7685462418407	-122.406037260315	(37.7685462418407, -122.406037260315)
148496	148496	227674	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	83	Front Yard : Yard 7	Tree 1	Private 1			15			6005065.1015800005	2097012.05309	37.7382824451638	-122.42499854026899	(37.7382824451638, -122.424998540269)
150156	150156	191402	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2100 Alameda St	8	Front Yard : Yard 7	Tree 1	Private 1			7			6010700.42675	2107913.45144	37.7685319866755	-122.406282136733	(37.7685319866755, -122.406282136733)
150938	150938	227672	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	62	Front Yard : Yard 7	Tree 1	Private 1			15			6005095.2123	2097053.48648	37.7383979127325	-122.42489737911801	(37.7383979127325, -122.424897379118)
154023	154023	207128	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	1	Front Yard : Yard 7	Tree 1	Private 1			15	Width 0ft		5991324.62806	2095649.6189400002	37.7337558092758	-122.472406573513	(37.7337558092758, -122.472406573513)
154704	154704	191400	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2100 Alameda St	6	Front Yard : Yard 7	Tree 1	Private 1			18			6010721.657430001	2107914.21049	37.76853525842721	-122.406208754734	(37.7685352584272, -122.406208754734)
158536	158536	207119	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	10	Front Yard : Yard 7	Tree 1	Private 1			25	Width 0ft		5991353.65823	2095688.25461	37.733863573243205	-122.47230902406099	(37.7338635732432, -122.472309024061)
159748	159748	191397	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2100 Alameda St	3	Front Yard : Yard 7	Tree 1	Private 1			9			6010751.13717	2107916.6697400003	37.768543659889005	-122.406106959582	(37.768543659889, -122.406106959582)
162968	162968	191403	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2100 Alameda St	9	Front Yard : Yard 7	Tree 1	Private 1			5			6010692.2016199995	2107913.0668	37.7685304704432	-122.40631055979601	(37.7685304704432, -122.406310559796)
169634	169634	191405	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Tulare St	9	Front Yard : Yard 7	Tree 1	Private 1			8			6016216.75475	2100305.37684	37.7479488549636	-122.386670851103	(37.7479488549636, -122.386670851103)
171831	171831	191396	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2100 Alameda St	2	Front Yard : Yard 7	Tree 1	Private 1			6			6010761.0499599995	2107917.30957	37.7685459711594	-122.40607271698799	(37.7685459711594, -122.406072716988)
172620	172620	191407	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Tulare St	7	Front Yard : Yard 7	Tree 1	Private 1			12			6016225.71134	2100306.15132	37.747951477381	-122.386639933312	(37.747951477381, -122.386639933312)
174722	174722	207118	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	12	Front Yard : Yard 7	Tree 1	Private 1			27	Width 0ft		5991361.11034	2095702.06647	37.7339019284143	-122.472284266614	(37.7339019284143, -122.472284266614)
177899	177899	191399	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2100 Alameda St	5	Front Yard : Yard 7	Tree 1	Private 1			5			6010727.66479	2107914.7241700003	37.7685370048986	-122.406188011877	(37.7685370048986, -122.406188011877)
178085	178085	227673	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	1000 San Jose Ave	64	Front Yard : Yard 7	Tree 1	Private 1			12			6005078.09924	2097049.5351099998	37.738386096529204	-122.424956266738	(37.7383860965292, -122.424956266738)
178438	178438	207120	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	9	Front Yard : Yard 7	Tree 1	Private 1			21	Width 0ft		5991349.86178	2095682.72956	37.7338481831293	-122.472321746778	(37.7338481831293, -122.472321746778)
179845	179845	207123	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	6	Front Yard : Yard 7	Tree 1	Private 1			21	Width 0ft		5991338.6165	2095665.48618	37.733800186326604	-122.472359368113	(37.7338001863266, -122.472359368113)
180846	180846	207121	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	8	Front Yard : Yard 7	Tree 1	Private 1			20	Width 0ft		5991346.9817	2095677.27593	37.733833042151105	-122.47233130655898	(37.7338330421511, -122.472331306559)
184814	184814	207122	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	7	Front Yard : Yard 7	Tree 1	Private 1			12	Width 0ft		5991343.33969	2095670.4637	37.7338141267018	-122.47234340152399	(37.7338141267018, -122.472343401524)
185104	185104	191404	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Tulare St	14	Front Yard : Yard 7	Tree 1	Private 1			20			6016173.59275	2100299.3088	37.7479298037296	-122.3868196817	(37.7479298037296, -122.3868196817)
188736	188736	207124	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	2 Cranleigh Dr	5	Front Yard : Yard 7	Tree 1	Private 1			9	Width 0ft		5991335.55729	2095661.67857	37.7337895545331	-122.472369667134	(37.7337895545331, -122.472369667134)
24466	24466	207106	Undocumented 2	Leptospermum laevigatum :: Australian Tea Tree 38	100 Tara St	2	: 4	Tree 1	Private 1			20	Width 0ft		5998100.60654	2090923.0946	37.7211677377768	-122.448639805789	(37.7211677377768, -122.448639805789)

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