Street_Tree_List

Data source: data.sfgov.org

1,117 rows where qSpecies = 52 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, qCaretaker, qCareAssistant, DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
54362	54362	229782	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	52	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		6011435.782240001	2102697.98371	37.7542525844934	-122.40337163559201	(37.7542525844934, -122.403371635592)
61898	61898	229781	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	51	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011437.0323	2102686.7718700003	37.754221869065795	-122.40336652384799	(37.7542218690658, -122.403366523848)
71654	71654	229780	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	50	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		6011438.150669999	2102669.0861400003	37.7541733704045	-122.40336141212099	(37.7541733704045, -122.403361412121)
136900	136900	229779	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011439.173280001	2102646.69218	37.75411193863	-122.403356300366	(37.75411193863, -122.403356300366)
24100	24100	229778	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011440.8047	2102625.1691799997	37.754052932322395	-122.40334914446301	(37.7540529323224, -122.403349144463)
31243	31243	229777	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	47	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011441.00674	2102606.02985	37.7540003912143	-122.403347099413	(37.7540003912143, -122.403347099413)
154565	154565	229776	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6011441.50409	2102586.88485	37.7539478510307	-122.40334403271002	(37.7539478510307, -122.40334403271)
179268	179268	229775	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	45	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011442.57459	2102566.84517	37.7538928862632	-122.40333892097799	(37.7538928862632, -122.403338920978)
136124	136124	229774	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	44	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011445.35286	2102545.22023	37.7538336641006	-122.403327791844	(37.7538336641006, -122.403327791844)
35984	35984	229773	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	43	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011446.65854	2102520.5438599996	37.7537659811344	-122.403321540662	(37.7537659811344, -122.403321540662)
149742	149742	229772	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	42	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011446.86383	2102500.86077	37.7537119471592	-122.403319446151	(37.7537119471592, -122.403319446151)
72129	72129	229771	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	41	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011447.677180001	2102483.4305	37.7536641328931	-122.403315407293	(37.7536641328931, -122.403315407293)
35475	35475	229770	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011448.51225	2102466.33912	37.753617250356996	-122.403311317166	(37.753617250357, -122.403311317166)
37674	37674	229769	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011449.91996	2102448.3530599996	37.7535679432079	-122.403305183785	(37.7535679432079, -122.403305183785)
38097	38097	190683	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1301 Minnesota St	39	Front Yard : Yard 7	Tree 1	Private 1			4			6015372.42654	2102509.7647599997	37.7539548603504	-122.389744472134	(37.7539548603504, -122.389744472134)
140184	140184	229768	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	38	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011450.10406	2102428.33109	37.7535129775571	-122.40330313873301	(37.7535129775571, -122.403303138733)
180024	180024	229767	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	37	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011451.55336	2102410.70185	37.7534646524788	-122.40329688663799	(37.7534646524788, -122.403296886638)
146597	146597	229766	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	36	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6011452.91917	2102390.65584	37.7534096868171	-122.403290753279	(37.7534096868171, -122.403290753279)
27865	27865	229765	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011453.422780001	2102371.80516	37.753357955114396	-122.40328768569401	(37.7533579551144, -122.403287685694)
171101	171101	229764	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	34	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011452.97986	2102350.02958	37.753298139414	-122.403287685686	(37.753298139414, -122.403287685686)
130489	130489	229763	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		6011453.21392	2102329.36922	37.753241423671795	-122.403285422977	(37.7532414236718, -122.403285422977)
103871	103871	34311	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		32	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
147848	147848	229762	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011454.29465	2102314.61303	37.7532009667707	-122.403280647606	(37.7532009667707, -122.403280647606)
30489	30489	229761	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6011456.4035	2102287.48645	37.753126600912296	-122.40327144663401	(37.7531266009123, -122.403271446634)
82566	82566	34320	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		31	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
119702	119702	111096	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	67 SAINT CHARLES AVE	31	Sidewalk: Curb side : Cutout 1	Tree 1	DPW for City Agency 10	DPW 4		15			5992079.0	2088073.0	37.712995910736204	-122.46924723728901	(37.7129959107362, -122.469247237289)
82875	82875	34319	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		30	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
181303	181303	229760	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011458.91565	2102265.65077	37.753066785227105	-122.40326122314501	(37.7530667852271, -122.403261223145)
33460	33460	229759	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	29	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		6011459.21947	2102251.51401	37.753027985753	-122.403259178089	(37.753027985753, -122.403259178089)
95285	95285	34307	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		29	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
178416	178416	129103	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1306x Montgomery St	29	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		6011435.37643	2120050.37627	37.8018982087863	-122.40459448426901	(37.8018982087863, -122.404594484269)
24885	24885	229758	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011460.45759	2102239.71319	37.7529956524374	-122.40325406633801	(37.7529956524374, -122.403254066338)
111513	111513	34317	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		28	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
122063	122063	34322	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		27	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
120370	120370	34316	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
158462	158462	229757	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6011461.99954	2102213.77594	37.752924520553	-122.40324690953301	(37.752924520553, -122.403246909533)
120587	120587	34315	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
41876	41876	229756	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011464.1555699995	2102190.87321	37.7528617550894	-122.40323784257299	(37.7528617550894, -122.403237842573)
84473	84473	34314	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
100479	100479	34313	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
180443	180443	229755	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011464.24481	2102169.9708	37.7528043666378	-122.40323606370701	(37.7528043666378, -122.403236063707)
45346	45346	121804	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	22	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
61430	61430	229754	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011464.93054	2102145.24186	37.7527365046859	-122.403231952908	(37.7527365046859, -122.403231952908)
89554	89554	34312	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
27981	27981	229753	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6011465.791619999	2102125.84808	37.7526833017063	-122.40322761098899	(37.7526833017063, -122.403227610989)
84849	84849	121803	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	21	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
101333	101333	34335	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
59146	59146	229752	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6011465.52618	2102102.51804	37.7526192277045	-122.403226887931	(37.7526192277045, -122.403226887931)
143681	143681	34310	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
146000	146000	121757	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	20	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
97349	97349	121756	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	19	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
99217	99217	34321	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
169635	169635	229751	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1201 Vermont St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		6011465.75975	2102083.1370200003	37.7525660247145	-122.40322471696999	(37.7525660247145, -122.40322471697)
90523	90523	121755	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	18	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
125334	125334	34309	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
126208	126208	37739	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)
110558	110558	37732	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)
113793	113793	121754	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	17	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
123693	123693	34308	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
96982	96982	34318	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
106013	106013	37733	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)
116581	116581	121753	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	16	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
86087	86087	37734	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)
114934	114934	34324	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
118602	118602	121752	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	15	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
46593	46593	229810	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1801 Bryant St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		6009529.11729	2106277.27866	37.7639738421376	-122.41021807989999	(37.7639738421376, -122.4102180799)
83237	83237	121751	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	14	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
114212	114212	34337	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
121224	121224	37735	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)
19620	19620	34336	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
101254	101254	37736	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)
105288	105288	36063	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1401 Bryant St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/1998 12:00:00 AM			Permit Number 39185	6009421.20140012	2108121.84074464	37.7690325354797	-122.410721604896	(37.7690325354797, -122.410721604896)
138519	138519	121750	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	13	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
18620	18620	121737	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	12	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
18708	18708	121749	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	12	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
109016	109016	37738	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)
120485	120485	34334	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
128156	128156	36052	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1401 Bryant St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/1998 12:00:00 AM			Permit Number 39185	6009421.20140012	2108121.84074464	37.7690325354797	-122.410721604896	(37.7690325354797, -122.410721604896)
141588	141588	111063	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1851 Bryant St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				4x4		6009528.24804625	2106163.95855958	37.7636626423221	-122.410213085123	(37.7636626423221, -122.410213085123)
182421	182421	229809	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	1801 Bryant St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6009528.66718	2106237.67868	37.7638650844166	-122.410216840643	(37.7638650844166, -122.410216840643)
84526	84526	111062	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1851 Bryant St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				4x4		6009528.24804625	2106163.95855958	37.7636626423221	-122.410213085123	(37.7636626423221, -122.410213085123)
87306	87306	121748	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	11	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
87634	87634	37731	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)
88761	88761	121736	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	11	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
115033	115033	36051	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1401 Bryant St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/1998 12:00:00 AM			Permit Number 39185	6009421.20140012	2108121.84074464	37.7690325354797	-122.410721604896	(37.7690325354797, -122.410721604896)
121018	121018	34333	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
1126	1126	38276	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	651 Texas St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/27/1998 12:00:00 AM	3		Permit Number 40367	6013924.79961	2103962.8321	37.757864288826795	-122.394852504434	(37.7578642888268, -122.394852504434)
81952	81952	37747	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)
104093	104093	36053	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1401 Bryant St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/1998 12:00:00 AM			Permit Number 39185	6009421.20140012	2108121.84074464	37.7690325354797	-122.410721604896	(37.7690325354797, -122.410721604896)
123543	123543	121747	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1201x Vermont St	10	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011405.0	2102539.0	37.753814330877205	-122.403466904543	(37.7538143308772, -122.403466904543)
143487	143487	34332	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
145396	145396	121735	DPW Maintained 3	Jacaranda mimosifolia :: Jacaranda 52	1301 Vermont St	10	Front Yard : Yard 7	Tree 1	DPW 2				3x3		6011430.0	2102074.0	37.75253893927721	-122.403347738299	(37.7525389392772, -122.403347738299)
162409	162409	226436	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	106 Bartlett St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6006661.6983199995	2103152.67554	37.755233262826295	-122.419913909217	(37.7552332628263, -122.419913909217)
1119	1119	38280	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	651 Texas St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/27/1998 12:00:00 AM	12		Permit Number 40367	6013876.1493	2104054.9950099997	37.758114643000795	-122.395027213942	(37.7581146430008, -122.395027213942)
78162	78162	44003	Planning Code 138.1 required 4	Jacaranda mimosifolia :: Jacaranda 52	2701X 17th St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2016 12:00:00 AM		3x3	Permit Number 775718	6009464.30573862	2106385.10315991	37.7642662704227	-122.41044985886299	(37.7642662704227, -122.410449858863)
89707	89707	36054	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1401 Bryant St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/28/1998 12:00:00 AM			Permit Number 39185	6009421.20140012	2108121.84074464	37.7690325354797	-122.410721604896	(37.7690325354797, -122.410721604896)
106016	106016	226435	Undocumented 2	Jacaranda mimosifolia :: Jacaranda 52	106 Bartlett St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6006660.81941	2103136.07502	37.75518763210621	-122.419915770819	(37.7551876321062, -122.419915770819)
111061	111061	34331	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52		9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/14/1997 12:00:00 AM			Permit Number 38095	6011565.66175485	2101164.33215433	37.7500487659499	-122.40281462336901	(37.7500487659499, -122.402814623369)
114853	114853	38274	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	645 Texas St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/27/1998 12:00:00 AM			Permit Number 40367	6014125.41454299	2103884.52035605	37.75766041435771	-122.394153206319	(37.7576604143577, -122.394153206319)
122271	122271	37741	Permitted Site 1	Jacaranda mimosifolia :: Jacaranda 52	1266 Florida St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/01/1998 12:00:00 AM			Permit Number 40095	6009484.78268632	2101799.61949938	37.751676715706	-122.41005529072599	(37.751676715706, -122.410055290726)

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