Street_Tree_List

Data source: data.sfgov.org

180 rows where qCaretaker = 9 and qSpecies = 100 sorted by PlotSize

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: qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▼	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
44570	44570	27941	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	699 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24			6012787.5534626	2119857.700218	37.801444644335106	-122.399901749617	(37.8014446443351, -122.399901749617)
77513	77513	27958	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
79708	79708	27959	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
82090	82090	27775	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
87650	87650	27777	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
90111	90111	27847	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
91142	91142	28372	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9			18			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
92133	92133	27942	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	699 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24			6012787.5534626	2119857.700218	37.801444644335106	-122.399901749617	(37.8014446443351, -122.399901749617)
92364	92364	27782	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
92652	92652	27780	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
93856	93856	27960	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
96124	96124	27767	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/10/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
99547	99547	27845	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
100132	100132	27778	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
100729	100729	27843	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
101121	101121	27717	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		09/11/2000 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
101242	101242	27788	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9			14			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
105556	105556	27842	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
105677	105677	27827	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
110061	110061	27844	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
111571	111571	27784	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	20			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
112720	112720	27781	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
115875	115875	27841	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
118074	118074	27961	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
118319	118319	27846	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	280 The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		07/15/1994 12:00:00 AM	36			6013933.6105332	2118392.9536833	37.797486624670704	-122.395833154489	(37.7974866246707, -122.395833154489)
120022	120022	27940	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	699 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24			6012787.5534626	2119857.700218	37.801444644335106	-122.399901749617	(37.8014446443351, -122.399901749617)
120310	120310	27785	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9			18			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
121752	121752	27776	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
125860	125860	27766	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
127099	127099	27943	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	699 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24			6012787.5534626	2119857.700218	37.801444644335106	-122.399901749617	(37.8014446443351, -122.399901749617)
139415	139415	27774	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	299X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/10/2000 12:00:00 AM	26			6013785.1217042	2118375.8431165	37.797431381421	-122.39634576874799	(37.797431381421, -122.396345768748)
140643	140643	27786	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9			14			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
140710	140710	27962	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	307X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	18			6013768.7522982005	2118400.6344275	37.7974985415834	-122.396404150152	(37.7974985415834, -122.396404150152)
140893	140893	27783	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
144544	144544	27779	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	399X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	24			6013580.156802201	2118681.7167588	37.7982598302065	-122.397076463892	(37.7982598302065, -122.397076463892)
145407	145407	27787	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	199X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9			14			6014015.4653372	2118064.3876984	37.796589013389394	-122.39552688195299	(37.7965890133894, -122.395526881953)
724	724	25734	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	16	10		6013899.49111	2118360.1858599996	37.7973947538281	-122.395948920127	(37.7973947538281, -122.395948920127)
1312	1312	25735	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	16	10		6013816.07307	2118422.78251	37.7975619881486	-122.396241959692	(37.7975619881486, -122.396241959692)
4067	4067	25799	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012220.09673	2120843.1378	37.8041187644177	-122.401934728525	(37.8041187644177, -122.401934728525)
5785	5785	25798	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1100X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012871.9305	2119823.23547	37.801354716114	-122.39960734420201	(37.801354716114, -122.399607344202)
6093	6093	26031	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	450X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6014122.12078	2117941.0950599997	37.7962564126589	-122.39514918719999	(37.7962564126589, -122.3951491872)
6748	6748	26030	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	450X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6014150.34723	2117905.1373099997	37.796159250800294	-122.395048997307	(37.7961592508003, -122.395048997307)
7108	7108	25783	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6013938.98446	2118296.9177	37.7972232315271	-122.39580782638599	(37.7972232315271, -122.395807826386)
7340	7340	25782	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	36	10		6013997.3565	2118221.08563	37.7970182616509	-122.395600527244	(37.7970182616509, -122.395600527244)
8987	8987	25784	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6013869.26975	2118339.24702	37.797335579338004	-122.396052026484	(37.797335579338, -122.396052026484)
19785	19785	25785	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6013445.7547399	2119056.6213273997	37.7992817461076	-122.39756784649201	(37.7992817461076, -122.397567846492)
69372	69372	25749	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011423.5148387	2121491.4283584	37.805854321699	-122.40473704035801	(37.805854321699, -122.404737040358)
78155	78155	25795	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	9	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012764.87501	2119980.6770099998	37.80178104459689	-122.39998886869199	(37.8017810445969, -122.399988868692)
78230	78230	27930	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	10		6012635.1983488	2120084.4698961005	37.8020588041016	-122.400444907677	(37.8020588041016, -122.400444907677)
78576	78576	25731	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	501X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	16	10		6013387.7643744005	2119020.8269614	37.799180234142106	-122.39776600258999	(37.7991802341421, -122.39776600259)
80104	80104	25796	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	10	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012816.959009999	2119901.25001	37.80156586089179	-122.399803052325	(37.8015658608918, -122.399803052325)
81176	81176	27963	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1101X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/05/2001 12:00:00 AM	36	10		6012183.0853805	2120808.9629681	37.8040228629879	-122.402060405747	(37.8040228629879, -122.402060405747)
81328	81328	25745	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	10	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
86291	86291	25738	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
86502	86502	25797	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	11	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012870.34401	2119824.4270099998	37.801357899362394	-122.399612917904	(37.8013578993624, -122.399612917904)
87172	87172	26029	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	499X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6013385.9217822	2119009.0450001	37.7991477810775	-122.397771551765	(37.7991477810775, -122.397771551765)
89841	89841	25748	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011423.5148387	2121491.4283584	37.805854321699	-122.40473704035801	(37.805854321699, -122.404737040358)
91779	91779	26017	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	899X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6012483.6012207	2120310.1113668997	37.8026699057947	-122.40098537237499	(37.8026699057947, -122.400985372375)
92465	92465	26024	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	899X The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6012483.6012207	2120310.1113668997	37.8026699057947	-122.40098537237499	(37.8026699057947, -122.400985372375)
95434	95434	27933	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	10		6012635.1983488	2120084.4698961005	37.8020588041016	-122.400444907677	(37.8020588041016, -122.400444907677)
96132	96132	25786	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	500X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6013445.7547399	2119056.6213273997	37.7992817461076	-122.39756784649201	(37.7992817461076, -122.397567846492)
98209	98209	25737	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
101160	101160	25742	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
101776	101776	25752	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011423.5148387	2121491.4283584	37.805854321699	-122.40473704035801	(37.805854321699, -122.404737040358)
103830	103830	27697	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1100X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9			36	10		6012224.999683401	2120852.6389045	37.8041451257683	-122.401918429695	(37.8041451257683, -122.401918429695)
104498	104498	25741	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
105106	105106	25746	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1101X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012183.0853805	2120808.9629681	37.8040228629879	-122.402060405747	(37.8040228629879, -122.402060405747)
107210	107210	25790	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012501.85401	2120373.90601	37.8028460885889	-122.400926692934	(37.8028460885889, -122.400926692934)
107397	107397	25804	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011529.7175275	2121574.5346243	37.8060884463757	-122.404375360949	(37.8060884463757, -122.404375360949)
108921	108921	25793	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012660.709009999	2120133.02101	37.802193536328	-122.40036004021499	(37.802193536328, -122.400360040215)
109799	109799	25803	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011529.7175275	2121574.5346243	37.8060884463757	-122.404375360949	(37.8060884463757, -122.404375360949)
111083	111083	25747	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1101X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012183.0853805	2120808.9629681	37.8040228629879	-122.402060405747	(37.8040228629879, -122.402060405747)
112637	112637	25732	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	501X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	16	10		6013387.7643744005	2119020.8269614	37.799180234142106	-122.39776600258999	(37.7991802341421, -122.39776600259)
112807	112807	25802	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011529.7175275	2121574.5346243	37.8060884463757	-122.404375360949	(37.8060884463757, -122.404375360949)
112942	112942	25754	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011423.5148387	2121491.4283584	37.805854321699	-122.40473704035801	(37.805854321699, -122.404737040358)
113256	113256	25744	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	9	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
113720	113720	25743	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
114962	114962	27698	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	11	Median : Cutout 11	Tree 1	Port 9			24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
115229	115229	27932	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	10		6012635.1983488	2120084.4698961005	37.8020588041016	-122.400444907677	(37.8020588041016, -122.400444907677)
116990	116990	25800	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011529.7175275	2121574.5346243	37.8060884463757	-122.404375360949	(37.8060884463757, -122.404375360949)
117219	117219	25750	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1301X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011423.5148387	2121491.4283584	37.805854321699	-122.40473704035801	(37.805854321699, -122.404737040358)
118856	118856	25739	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
118985	118985	25791	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012561.75001	2120285.36501	37.802606317276	-122.40071319691499	(37.802606317276, -122.400713196915)
119199	119199	27935	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	10		6012635.1983488	2120084.4698961005	37.8020588041016	-122.400444907677	(37.8020588041016, -122.400444907677)
119621	119621	26019	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	899X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6012483.6012207	2120310.1113668997	37.8026699057947	-122.40098537237499	(37.8026699057947, -122.400985372375)
120030	120030	25794	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	8	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012712.79201	2120057.50001	37.8019890781012	-122.40017449968501	(37.8019890781012, -122.400174499685)
120825	120825	25789	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012378.15701	2120553.5940099997	37.8033325675946	-122.40136738582899	(37.8033325675946, -122.401367385829)
123015	123015	25788	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012327.37501	2120629.11501	37.8035370964877	-122.401548430804	(37.8035370964877, -122.401548430804)
123638	123638	27929	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	10		6012635.1983488	2120084.4698961005	37.8020588041016	-122.400444907677	(37.8020588041016, -122.400444907677)
124202	124202	25733	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	501X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	16	10		6013387.7643744005	2119020.8269614	37.799180234142106	-122.39776600258999	(37.7991802341421, -122.39776600259)
124284	124284	26018	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	899X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6012483.6012207	2120310.1113668997	37.8026699057947	-122.40098537237499	(37.8026699057947, -122.400985372375)
126250	126250	26096	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	499X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6013385.9217822	2119009.0450001	37.7991477810775	-122.397771551765	(37.7991477810775, -122.397771551765)
126593	126593	26022	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	899X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6012483.6012207	2120310.1113668997	37.8026699057947	-122.40098537237499	(37.8026699057947, -122.400985372375)
127804	127804	25792	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012611.22901	2120208.54201	37.802398139421705	-122.400536574048	(37.8023981394217, -122.400536574048)
127945	127945	25787	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	800X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6012271.38601	2120709.8440099997	37.803755634424206	-122.401747862284	(37.8037556344242, -122.401747862284)
128206	128206	27931	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	799 The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		02/01/2001 12:00:00 AM	24	10		6012635.1983488	2120084.4698961005	37.8020588041016	-122.400444907677	(37.8020588041016, -122.400444907677)
128307	128307	25736	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	801X The Embarcadero	1	Median : Cutout 11	Tree 1	Port 9		08/15/1996 12:00:00 AM	24	10		6012632.1664062	2120088.9827256002	37.802071026160604	-122.400455716884	(37.8020710261606, -122.400455716884)
128560	128560	26023	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	899X The Embarcadero	7	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6012483.6012207	2120310.1113668997	37.8026699057947	-122.40098537237499	(37.8026699057947, -122.400985372375)
140237	140237	26020	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	899X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		12/01/2000 12:00:00 AM	36	10		6012483.6012207	2120310.1113668997	37.8026699057947	-122.40098537237499	(37.8026699057947, -122.400985372375)
140551	140551	25801	Permitted Site 1	Phoenix canariensis :: Canary Island Date Palm 100	1300X The Embarcadero	3	Median : Cutout 11	Tree 1	Port 9		08/30/1996 12:00:00 AM	36	10		6011529.7175275	2121574.5346243	37.8060884463757	-122.404375360949	(37.8060884463757, -122.404375360949)

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