Street_Tree_List

Data source: data.sfgov.org

1,640 rows where qSpecies = 50 sorted by SiteOrder 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, PlantType, qCaretaker, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
22321	22321	3630	Private 5	Melaleuca quinquenervia :: Cajeput 50	100X Cargo Way	66	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9			12	3X3		6017698.24794	2098446.68655	37.7429271764597	-122.381418626885	(37.7429271764597, -122.381418626885)
134932	134932	202258	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	50	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 9ft		6013221.11687	2093370.23706	37.7287401067524	-122.396543647186	(37.7287401067524, -122.396543647186)
161620	161620	202257	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 6ft		6013220.214430001	2093360.4433	37.7287131648642	-122.39654608076	(37.7287131648642, -122.39654608076)
42368	42368	202256	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		6013218.75497	2093350.94152	37.7286869936936	-122.39655046045701	(37.7286869936936, -122.396550460457)
41936	41936	202255	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	47	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 2ft		6013211.70344	2093322.48938	37.728608477487604	-122.396572844555	(37.7286084774876, -122.396572844555)
185762	185762	202254	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 2ft		6013211.29686	2093316.3299599998	37.7285915423502	-122.39657381854401	(37.7285915423502, -122.396573818544)
60370	60370	202253	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	45	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 2ft		6013211.002830001	2093308.76677	37.7285707590106	-122.396574305077	(37.7285707590106, -122.396574305077)
15112	15112	11554	DPW Maintained 3	Melaleuca quinquenervia :: Cajeput 50	101X Jennings St	44	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/23/1997 12:00:00 AM	3	3X3		6018972.44427	2097338.24769	37.7399538873755	-122.37693587968398	(37.7399538873755, -122.376935879684)
75305	75305	202252	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	44	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6013209.67836	2093298.98157	37.728543817137705	-122.396578198225	(37.7285438171377, -122.396578198225)
29584	29584	202251	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	43	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6013208.3513	2093289.05623	37.728516490324395	-122.396582090505	(37.7285164903244, -122.396582090505)
65503	65503	193622	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	602 Arthur Ave	43	Front Yard : Yard 7	Tree 1	Private 1			13	Width 9ft		6015925.13403	2099837.38031	37.746647684362394	-122.387646625393	(37.7466476843624, -122.387646625393)
44645	44645	202250	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	42	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 2ft		6013206.90035	2093279.9745	37.7284914729969	-122.39658647018999	(37.7284914729969, -122.39658647019)
70455	70455	193621	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	602 Arthur Ave	42	Front Yard : Yard 7	Tree 1	Private 1			9			6015879.35493	2099868.12062	37.746729555018895	-122.38780707073799	(37.7467295550189, -122.387807070738)
49369	49369	193620	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	602 Arthur Ave	41	Front Yard : Yard 7	Tree 1	Private 1			11			6015868.84489	2099868.33266	37.7467295550179	-122.387843428526	(37.7467295550179, -122.387843428526)
75865	75865	202249	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	41	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6013205.71087	2093269.90652	37.7284637621797	-122.396589876845	(37.7284637621797, -122.396589876845)
31449	31449	202248	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 2ft		6013204.66207	2093259.83536	37.72843605046	-122.396592796933	(37.72843605046, -122.396592796933)
45556	45556	184921	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1990 41st Ave	40	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5983531.9028	2102160.6005	37.7511790768162	-122.499829000947	(37.7511790768162, -122.499829000947)
188576	188576	202247	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6013203.9034	2093250.1788700002	37.728409493486296	-122.39659474307501	(37.7284094934863, -122.396594743075)
172298	172298	202246	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	38	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6013202.20801	2093242.92412	37.728389479068	-122.39660009581499	(37.728389479068, -122.396600095815)
154852	154852	202245	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	37	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6013200.83525	2093230.7571400001	37.728355994623996	-122.396603988992	(37.728355994624, -122.396603988992)
50225	50225	184917	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1990 41st Ave	36	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5983534.6102	2102074.9798	37.750944145009896	-122.49981331071999	(37.7509441450099, -122.49981331072)
46580	46580	210158	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	35	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 1ft		5997951.60652	2093516.59605	37.728280364337394	-122.449341616922	(37.7282803643374, -122.449341616922)
49456	49456	202243	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6013198.7947	2093213.4173	37.7283082693961	-122.39660982829399	(37.7283082693961, -122.396609828294)
66696	66696	210157	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	34	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 1ft		5997918.462	2093517.28656	37.728280364343	-122.44945624813101	(37.728280364343, -122.449456248131)
168123	168123	202242	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	34	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6013197.3579400005	2093205.03586	37.7282851757099	-122.396614207973	(37.7282851757099, -122.396614207973)
26099	26099	202241	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 2ft		6013196.57345	2093194.11858	37.728255155426	-122.396616155019	(37.728255155426, -122.396616155019)
72603	72603	184914	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1990 41st Ave	33	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5983535.9639	2102008.3107	37.750761169592295	-122.49980370235201	(37.7507611695923, -122.499803702352)
78194	78194	11543	DPW Maintained 3	Melaleuca quinquenervia :: Cajeput 50	101X Jennings St	33	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/23/1997 12:00:00 AM	3	3X3		6018704.60401	2097015.07701	37.7390517691962	-122.377839546083	(37.7390517691962, -122.377839546083)
187866	187866	210156	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	33	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 1ft		5997905.64065	2093516.80298	37.7282783030945	-122.449500537045	(37.7282783030945, -122.449500537045)
150759	150759	202240	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6013194.80989	2093183.5011900002	37.728225904088895	-122.396621507785	(37.7282259040889, -122.396621507785)
182942	182942	210155	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	32	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 1ft		5997888.33072	2093517.91432	37.728280364321996	-122.449560457971	(37.728280364322, -122.449560457971)
75390	75390	202239	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6013193.35893	2093174.4194599998	37.7282008867581	-122.396625887476	(37.7282008867581, -122.396625887476)
93692	93692	27580	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1299X Illinois St	31	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		02/12/2003 12:00:00 AM	12	3X3		6016181.753398	2103053.032112	37.7554914042846	-122.386983490089	(37.7554914042846, -122.386983490089)
159571	159571	210154	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	31	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 1ft		5997874.00276	2093517.46215	37.7282783030866	-122.44960995753401	(37.7282783030866, -122.449609957534)
77275	77275	210153	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	30	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 1ft		5997858.44021	2093518.03664	37.7282789901646	-122.449663799055	(37.7282789901646, -122.449663799055)
118360	118360	27579	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1299X Illinois St	30	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		02/12/2003 12:00:00 AM	12	3X3		6016181.753398	2103053.032112	37.7554914042846	-122.386983490089	(37.7554914042846, -122.386983490089)
78499	78499	27578	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1299X Illinois St	29	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		02/12/2003 12:00:00 AM	12	3X3		6016181.753398	2103053.032112	37.7554914042846	-122.386983490089	(37.7554914042846, -122.386983490089)
159963	159963	210152	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	29	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 1ft		5997843.86106	2093517.59005	37.728276929836	-122.44971416738701	(37.728276929836, -122.449714167387)
37227	37227	184909	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1990 41st Ave	28	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5983540.025	2101883.0946	37.750417599209996	-122.4997804049	(37.75041759921, -122.4997804049)
60161	60161	202236	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6013189.66424	2093144.91801	37.728119676166294	-122.396636593026	(37.7281196761663, -122.396636593026)
91928	91928	210151	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	28	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 1ft		5997831.33005	2093517.4322400002	37.7282757795895	-122.449757476045	(37.7282757795895, -122.449757476045)
115540	115540	27577	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1299X Illinois St	28	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		02/12/2003 12:00:00 AM	12	3X3		6016181.753398	2103053.032112	37.7554914042846	-122.386983490089	(37.7554914042846, -122.386983490089)
34092	34092	193607	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	2001 25th St	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 6ft		6012652.93364	2101843.19483	37.7519734254466	-122.39910239827101	(37.7519734254466, -122.399102398271)
72535	72535	131232	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1403 The Embarcadero	27	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			34	Width 10ft		6009815.0933300005	2122512.40886	37.8085676494355	-122.410375388423	(37.8085676494355, -122.410375388423)
100667	100667	27576	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1299X Illinois St	27	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		02/12/2003 12:00:00 AM	12	3X3		6016181.753398	2103053.032112	37.7554914042846	-122.386983490089	(37.7554914042846, -122.386983490089)
122153	122153	210150	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	27	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 1ft		5997817.44041	2093518.24047	37.728277204110704	-122.44980555111	(37.7282772041107, -122.44980555111)
170594	170594	202235	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6013188.17067	2093133.73442	37.7280888851842	-122.39664097272801	(37.7280888851842, -122.396640972728)
62847	62847	202234	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6013186.88595	2093125.91095	37.7280673320297	-122.396644865872	(37.7280673320297, -122.396644865872)
102836	102836	27575	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1299X Illinois St	26	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		02/12/2003 12:00:00 AM	12	3x3		6016181.753398	2103053.032112	37.7554914042846	-122.386983490089	(37.7554914042846, -122.386983490089)
146588	146588	210149	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 1ft		5997801.99624	2093518.3657799999	37.7282766645304	-122.44985895103201	(37.7282766645304, -122.449858951032)
27092	27092	210148	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	351 Judson Ave	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 1ft		5997785.60202	2093518.5538	37.7282762427524	-122.44991563981701	(37.7282762427524, -122.449915639817)
47951	47951	202233	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 2ft		6013185.992269999	2093116.5375599999	37.728041544874294	-122.39664729856001	(37.7280415448743, -122.39664729856)
121250	121250	193606	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	2001 25th St	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 8ft		6012631.43152	2101842.51338	37.7519703560546	-122.399176708358	(37.7519703560546, -122.399176708358)
42017	42017	202232	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6013184.92926	2093105.76578	37.7280119086008	-122.396650218641	(37.7280119086008, -122.396650218641)
98384	98384	29239	DPW Maintained 3	Melaleuca quinquenervia :: Cajeput 50	1902X 41st Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		5983534.517682901	2102185.1808128003	37.7512467209802	-122.499821775189	(37.7512467209802, -122.499821775189)
95096	95096	41399	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1250 Sunnydale Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2000 12:00:00 AM			Permit Number 42021	6008204.54210993	2087109.47599829	37.711268913870896	-122.41344372896201	(37.7112689138709, -122.413443728962)
103651	103651	27572	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1299X Illinois St	23	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		02/12/2003 12:00:00 AM	12	3X3		6016181.753398	2103053.032112	37.7554914042846	-122.386983490089	(37.7554914042846, -122.386983490089)
152057	152057	193605	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	2001 25th St	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 8ft		6012610.5609800005	2101841.33996	37.7519659709715	-122.39924879979799	(37.7519659709715, -122.399248799798)
161082	161082	193591	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	500 24th St	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6016298.28126	2102605.60806	37.754269323574796	-122.38654930051901	(37.7542693235748, -122.386549300519)
178625	178625	202231	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 2ft		6013182.918409999	2093096.83525	37.727987275271396	-122.396656544473	(37.7279872752714, -122.396656544473)
19640	19640	41394	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1250 Sunnydale Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2000 12:00:00 AM			Permit Number 42021	6008204.54210993	2087109.47599829	37.711268913870896	-122.41344372896201	(37.7112689138709, -122.413443728962)
47102	47102	193590	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	500 24th St	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6016328.74179	2102605.6460599997	37.7542711141303	-122.386443962031	(37.7542711141303, -122.386443962031)
80286	80286	42489	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	50 Phelan Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM			Permit Number 42614	5997100.11501	2092938.9930099999	37.7266456600516	-122.45224358332099	(37.7266456600516, -122.452243583321)
174758	174758	202230	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6013182.01879	2093087.1816200002	37.727960718302896	-122.396658978052	(37.7279607183029, -122.396658978052)
185041	185041	193617	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	2 Tulare St	22	Front Yard : Yard 7	Tree 1	Private 1			12			6016111.33567	2100275.95351	37.7478622277646	-122.387033337217	(37.7478622277646, -122.387033337217)
86742	86742	42490	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	50 Phelan Ave	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM			Permit Number 42614	5997102.28501	2092919.46201	37.726592156863205	-122.452234673085	(37.7265921568632, -122.452234673085)
103239	103239	461	DPW Maintained 3	Melaleuca quinquenervia :: Cajeput 50	760x 23rd Ave	21	Median : Cutout 11	Tree 1	DPW 2		05/19/2015 10:10:00 AM	3	8x100		5988827.12869	2110042.5268099997	37.7731300209347	-122.48209512132799	(37.7731300209347, -122.482095121328)
111491	111491	41396	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1250 Sunnydale Ave	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2000 12:00:00 AM			Permit Number 42021	6008204.54210993	2087109.47599829	37.711268913870896	-122.41344372896201	(37.7112689138709, -122.413443728962)
178196	178196	193589	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	500 24th St	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6016358.92133	2102607.97328	37.754279174755794	-122.386339754876	(37.7542791747558, -122.386339754876)
180423	180423	202229	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6013180.4101	2093077.2619900003	37.7279333914885	-122.39666384428001	(37.7279333914885, -122.39666384428)
30716	30716	193588	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	500 24th St	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6016388.406359999	2102608.3572299997	37.754281861036404	-122.38623781404199	(37.7542818610364, -122.386237814042)
54110	54110	202228	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6013179.65142	2093067.6055	37.7279068345108	-122.396665790418	(37.7279068345108, -122.396665790418)
67001	67001	193742	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	65 Whitney Young Cir	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 4ft		6017172.8387400005	2094938.0801099997	37.73326422544871	-122.382991229966	(37.7332642254487, -122.382991229966)
89194	89194	99308	DPW Maintained 3	Melaleuca quinquenervia :: Cajeput 50	1902X 41st Ave	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW for City Agency 10	SFUSD 6		6	3X3		5983703.9	2101544.3	37.7494969779561	-122.49918869137501	(37.7494969779561, -122.499188691375)
95366	95366	41392	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1250 Sunnydale Ave	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2000 12:00:00 AM			Permit Number 42021	6008204.54210993	2087109.47599829	37.711268913870896	-122.41344372896201	(37.7112689138709, -122.413443728962)
100749	100749	42491	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	50 Phelan Ave	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM			Permit Number 42614	5997099.03001	2092901.0150099997	37.7265413193022	-122.452244594961	(37.7265413193022, -122.452244594961)
131764	131764	460	DPW Maintained 3	Melaleuca quinquenervia :: Cajeput 50	760x 23rd Ave	20	Median : Cutout 11	Tree 1	DPW 2			1			5988827.36485	2110053.67584	37.773160646819	-122.482095121354	(37.773160646819, -122.482095121354)
75880	75880	202227	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 2ft		6013178.67077	2093060.8969999999	37.7278883597585	-122.39666871048901	(37.7278883597585, -122.396668710489)
107035	107035	41391	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1250 Sunnydale Ave	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2000 12:00:00 AM			Permit Number 42021	6008204.54210993	2087109.47599829	37.711268913870896	-122.41344372896201	(37.7112689138709, -122.413443728962)
123397	123397	27568	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1299X Illinois St	19	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		12/10/1999 12:00:00 AM	12	3X3		6016181.753398	2103053.032112	37.7554914042846	-122.386983490089	(37.7554914042846, -122.386983490089)
145130	145130	42487	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	50 Phelan Ave	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM			Permit Number 42614	5997102.28501	2092882.5690099997	37.7264908574219	-122.452232012211	(37.7264908574219, -122.452232012211)
146284	146284	41004	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1200 Illinois St	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/19/1999 12:00:00 AM			Permit Number 41817	6016113.76612701	2103352.32554079	37.7563094360414	-122.38723948899599	(37.7563094360414, -122.387239488996)
172004	172004	193587	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	500 24th St	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6016422.18056	2102610.28551	37.754289025026104	-122.38612114768499	(37.7542890250261, -122.386121147685)
33969	33969	232135	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	4185 25th St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6003143.3737699995	2101224.11027	37.749739035528606	-122.43194360511299	(37.7497390355286, -122.431943605113)
60912	60912	42493	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	50 Phelan Ave	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM			Permit Number 42614	5997102.28501	2092861.9530099998	37.726434250767205	-122.45223052530301	(37.7264342507672, -122.452230525303)
78585	78585	41003	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1200 Illinois St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/19/1999 12:00:00 AM			Permit Number 41817	6016113.76612701	2103352.32554079	37.7563094360414	-122.38723948899599	(37.7563094360414, -122.387239488996)
87201	87201	11504	DPW Maintained 3	Melaleuca quinquenervia :: Cajeput 50	100 Jennings St	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/12/1998 12:00:00 AM	3	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
109826	109826	37384	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	755 Morse St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/15/1998 12:00:00 AM	5	3x3	Permit Number 39872	5998400.39464019	2087052.25152553	37.7105564274343	-122.447325069993	(37.7105564274343, -122.447325069993)
113199	113199	27567	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1299X Illinois St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		12/10/1999 12:00:00 AM	12	3X3		6016181.753398	2103053.032112	37.7554914042846	-122.386983490089	(37.7554914042846, -122.386983490089)
145483	145483	41390	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1250 Sunnydale Ave	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2000 12:00:00 AM			Permit Number 42021	6008204.54210993	2087109.47599829	37.711268913870896	-122.41344372896201	(37.7112689138709, -122.413443728962)
177282	177282	193741	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	65 Whitney Young Cir	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6017141.893080001	2094930.29985	37.7332411524543	-122.383097677329	(37.7332411524543, -122.383097677329)
181398	181398	193586	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	500 24th St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6016448.1037800005	2102612.69862	37.75429708564229	-122.386031666023	(37.7542970856423, -122.386031666023)
185328	185328	202226	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	1 Kalmanovitz St	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 2ft		6013177.60207	2093049.8453	37.7278579545638	-122.396671630611	(37.7278579545638, -122.396671630611)
54497	54497	193604	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	2001 25th St	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 8ft		6012551.652419999	2101838.54345	37.7519550091186	-122.39945231908001	(37.7519550091186, -122.39945231908)
92091	92091	42492	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	50 Phelan Ave	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM			Permit Number 42614	5997101.20001	2092826.1460099998	37.7263358710664	-122.45223169353999	(37.7263358710664, -122.45223169354)
95606	95606	41001	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1200 Illinois St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/19/1999 12:00:00 AM			Permit Number 41817	6016113.76612701	2103352.32554079	37.7563094360414	-122.38723948899599	(37.7563094360414, -122.387239488996)
113269	113269	41401	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	1250 Sunnydale Ave	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/28/2000 12:00:00 AM			Permit Number 42021	6008204.54210993	2087109.47599829	37.711268913870896	-122.41344372896201	(37.7112689138709, -122.413443728962)
122106	122106	39845	Permitted Site 1	Melaleuca quinquenervia :: Cajeput 50	3151 Ortega St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/1999 12:00:00 AM			Permit Number 41160	5984281.43555925	2102217.56111428	37.751379430941896	-122.49724128025	(37.7513794309419, -122.49724128025)
122613	122613	29234	DPW Maintained 3	Melaleuca quinquenervia :: Cajeput 50	1902X 41st Ave	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		5983534.517682901	2102185.1808128003	37.7512467209802	-122.499821775189	(37.7512467209802, -122.499821775189)
148578	148578	193740	Undocumented 2	Melaleuca quinquenervia :: Cajeput 50	65 Whitney Young Cir	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6017126.30838	2094926.52531	37.733229927126395	-122.383151295797	(37.7332299271264, -122.383151295797)

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