Street_Tree_List

Data source: data.sfgov.org

119 rows where DBH = 2 and qSpecies = 51 sorted by Longitude

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: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
58110	58110	96111	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	458 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/28/2011 12:00:00 AM	2	3x3	Permit Number 767766	5981315.73412	2112558.6605700003	37.7795988416807	-122.508264340954	(37.7795988416807, -122.508264340954)
2988	2988	118173	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3221 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/13/2008 12:00:00 AM	2	Width 3ft		5985542.20124	2111089.15517	37.7758121588594	-122.49353507754299	(37.7758121588594, -122.493535077543)
97698	97698	9253	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	6500X Geary Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2	2X3		5986722.32109	2112597.81428	37.7800234720171	-122.489563763122	(37.7800234720171, -122.489563763122)
67039	67039	120355	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2270 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5988402.72558	2114696.23379	37.78588309898829	-122.48390447116999	(37.7858830989883, -122.48390447117)
70304	70304	120354	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2270 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5988430.28754	2114697.53592	37.7858882787477	-122.483809211099	(37.7858882787477, -122.483809211099)
176772	176772	120687	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2040 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5989191.37637	2111280.32009	37.776549837038495	-122.48092579961501	(37.7765498370385, -122.480925799615)
169666	169666	219436	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1001 Ortega St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990892.67595	2102441.87183	37.752380574612204	-122.474395438619	(37.7523805746122, -122.474395438619)
181696	181696	218773	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1831 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5990912.15705	2102928.22984	37.7537171146574	-122.474363558528	(37.7537171146574, -122.474363558528)
61657	61657	219437	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2207 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990996.77172	2100343.44313	37.746624866753294	-122.473882383471	(37.7466248667533, -122.473882383471)
52843	52843	123809	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2151 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991938.472709999	2111997.6444599996	37.7786787136504	-122.47147517248699	(37.7786787136504, -122.471475172487)
36175	36175	52474	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	576 Funston Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/27/2005 12:00:00 AM	2	3x3	Permit Number 48585	5991932.93207	2111539.52731	37.777420528381796	-122.471460949443	(37.7774205283818, -122.471460949443)
166233	166233	218782	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1434 14th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5991822.86644	2105659.6117	37.7612694917142	-122.47141315629999	(37.7612694917142, -122.4714131563)
29877	29877	102353	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	662 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/10/2009 12:00:00 AM	2	3x3	Permit Number 52560	5992263.7285400005	2110921.14049	37.775741736970204	-122.470271582701	(37.7757417369702, -122.470271582701)
135389	135389	123802	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2000 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992440.56126	2112076.14549	37.7789232893494	-122.469743985984	(37.7789232893494, -122.469743985984)
184260	184260	218161	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400 Portola Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993069.62325	2097569.10976	37.7391270938355	-122.466513125474	(37.7391270938355, -122.466513125474)
147190	147190	218159	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400 Portola Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993095.853519999	2097590.7626	37.7391880606825	-122.46642400716001	(37.7391880606825, -122.46642400716)
59710	59710	53541	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	312 04th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/06/2008 12:00:00 AM	2	3x3	Permit Number 50291	5994656.27049	2113349.39489	37.782547108504	-122.462171384858	(37.782547108504, -122.462171384858)
37463	37463	101234	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	251 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5994788.53914	2111424.28345	37.7772688824616	-122.46157417945801	(37.7772688824616, -122.461574179458)
63331	63331	123716	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	227 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5994853.672809999	2111423.99152	37.777271829773	-122.461348841581	(37.777271829773, -122.461348841581)
168366	168366	217730	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1200x Arguello Blvd	1	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		5995796.25486	2107257.89675	37.765887025696394	-122.45778663137101	(37.7658870256964, -122.457786631371)
137321	137321	217812	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	198 Lee Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996576.30659	2091913.4949400001	37.723799864560704	-122.453980331735	(37.7237998645607, -122.453980331735)
29317	29317	217810	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	198 Lee Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996576.41484	2091837.9853700001	37.7235925393546	-122.453974506819	(37.7235925393546, -122.453974506819)
59401	59401	217811	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	198 Lee Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996578.30824	2091874.8605099998	37.7236938983276	-122.453970623552	(37.7236938983276, -122.453970623552)
24235	24235	217813	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	198 Lee Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996579.91933	2091952.01212	37.7239058307663	-122.453970623549	(37.7239058307663, -122.453970623549)
71414	71414	41629	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	433 Locust St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/09/2008 12:00:00 AM	2	3x3	Permit Number 51282	5997644.2427199995	2114968.05541	37.78716310932511	-122.45195116082701	(37.7871631093251, -122.451951160827)
6520	6520	121576	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3553-3555 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5997856.717119999	2115116.32362	37.787582382260396	-122.451226746117	(37.7875823822604, -122.451226746117)
186958	186958	136934	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	685 Marina Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5999739.15861	2121538.2964	37.805323015109	-122.445175778246	(37.805323015109, -122.445175778246)
8183	8183	112515	Section 143 8	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2646 Greenwich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6000218.93903	2118886.7143900003	37.7980698532985	-122.443324869154	(37.7980698532985, -122.443324869154)
38574	38574	219441	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	147 Stillings Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 8ft		5999786.27103	2095740.5208700001	37.734491517651	-122.443158781469	(37.734491517651, -122.443158781469)
159247	159247	96923	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3208 Pierce St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/09/2011 12:00:00 AM	2	3x3	Permit Number 767943	6001389.811290001	2119472.57497	37.7997451706686	-122.439315335361	(37.7997451706686, -122.439315335361)
62572	62572	96922	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3208 Pierce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/09/2011 12:00:00 AM	2	3x3	Permit Number 767943	6001392.66231	2119445.8775400002	37.799672028811	-122.43930355514	(37.799672028811, -122.43930355514)
178966	178966	96921	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3208 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/09/2011 12:00:00 AM	2	3x3	Permit Number 767943	6001394.57427	2119432.51874	37.799635457872704	-122.43929598102501	(37.7996354578727, -122.439295981025)
99040	99040	106014	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	5235 DIAMOND HEIGHTS BLVD	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3x3		6001081.8	2099374.5	37.7445433581402	-122.43894005993	(37.7445433581402, -122.43894005993)
114038	114038	106017	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	5235 DIAMOND HEIGHTS BLVD	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3x3		6001081.8	2099374.5	37.7445433581402	-122.43894005993	(37.7445433581402, -122.43894005993)
118958	118958	106013	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	5235 DIAMOND HEIGHTS BLVD	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/16/2016 12:00:00 AM	2	3x3		6001081.8	2099374.5	37.7445433581402	-122.43894005993	(37.7445433581402, -122.43894005993)
50950	50950	246860	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1198 Oak St	4	: 4	Tree 1	Private 1			2	Width 4ft		6001322.98115	2109744.38173	37.773030249875795	-122.43884907734301	(37.7730302498758, -122.438849077343)
144778	144778	106016	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	5285 DIAMOND HEIGHTS BLVD	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3x3		6001339.5	2099171.1	37.7439995285584	-122.438034420154	(37.7439995285584, -122.438034420154)
43543	43543	58803	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2246 Filbert St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/29/2013 12:00:00 AM	2		Permit Number 769648	6002177.82636	2118813.48385	37.7979802907265	-122.436541316255	(37.7979802907265, -122.436541316255)
55397	55397	242344	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	147 Moffitt St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6002611.74141	2096837.65353	37.7376646954683	-122.43346858283199	(37.7376646954683, -122.433468582832)
23088	23088	29	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	742 14th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3X3		6003854.77769	2107764.13441	37.7677366901162	-122.42994999788799	(37.7677366901162, -122.429949997888)
166466	166466	242334	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	206 28th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004464.328980001	2099597.23068	37.7453467979142	-122.427259814498	(37.7453467979142, -122.427259814498)
175810	175810	246512	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	50 Laguna St	1	: 4	Tree 1	Private 1			2	Width 3ft		6005254.0996199995	2109149.02764	37.7716184212706	-122.425208466318	(37.7716184212706, -122.425208466318)
133181	133181	242915	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	111 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6005066.82423	2099579.80768	37.7453330131246	-122.425175243547	(37.7453330131246, -122.425175243547)
49855	49855	242329	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	107 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6005095.8624599995	2099583.89393	37.745345873425705	-122.42507512473699	(37.7453458734257, -122.425075124737)
179035	179035	136942	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1771 Washington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6006278.23872	2116942.55045	37.793075331599496	-122.42221969987699	(37.7930753315995, -122.422219699877)
157353	157353	136943	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1771 Washington St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6006301.75363	2116945.84778	37.7930857115761	-122.42213857116	(37.7930857115761, -122.42213857116)
171813	171813	249416	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	650 Turk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006834.06276	2112935.18598	37.7821034308803	-122.42001200005899	(37.7821034308803, -122.420012000059)
163510	163510	248272	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	155 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006707.09266	2098676.55719	37.742945416513	-122.419439385544	(37.742945416513, -122.419439385544)
9705	9705	110500	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900X JESSIE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6007667.0	2110717.0	37.7760597176113	-122.416973193872	(37.7760597176113, -122.416973193872)
9707	9707	110499	Section 143 8	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900X JESSIE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6007667.0	2110717.0	37.7760597176113	-122.416973193872	(37.7760597176113, -122.416973193872)
9708	9708	110501	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900X JESSIE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6007667.0	2110717.0	37.7760597176113	-122.416973193872	(37.7760597176113, -122.416973193872)
146787	146787	198410	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	17 Washburn St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6008351.381440001	2110501.05222	37.7755052498045	-122.41459044430599	(37.7755052498045, -122.414590444306)
186938	186938	180457	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	599 University St	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008281.899180001	2092268.5986400002	37.725439126312104	-122.413541011012	(37.7254391263121, -122.413541011012)
127454	127454	45234	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	501-599 UNIVERSITY ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/05/2001 12:00:00 AM	2		Permit Number 44059	6008503.0	2091469.0	37.7232560104732	-122.41272018028201	(37.7232560104732, -122.412720180282)
150257	150257	198412	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	230 09th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008892.8761599995	2110114.82247	37.7744751609416	-122.412689967265	(37.7744751609416, -122.412689967265)
169970	169970	198413	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	234 09th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008929.92421	2110078.39089	37.774377207666795	-122.412559234629	(37.7743772076668, -122.412559234629)
181768	181768	44347	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	638 Minna St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/14/2001 12:00:00 AM	2		Permit Number 43729	6009245.86368	2111366.87268	37.7779328014898	-122.411557389874	(37.7779328014898, -122.411557389874)
134851	134851	198350	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	582 Minna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009649.44136	2111748.76797	37.779004025349	-122.410188235924	(37.779004025349, -122.410188235924)
133977	133977	198351	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	579 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009664.57809	2111726.37194	37.778943379569704	-122.410134290082	(37.7789433795697, -122.410134290082)
163821	163821	198349	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	582 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009676.44757	2111773.36743	37.7790730833855	-122.410096547333	(37.7790730833855, -122.410096547333)
59791	59791	198356	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	583 Natoma St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009794.87498	2111587.46362	37.7785692724036	-122.40967373196199	(37.7785692724036, -122.409673731962)
94140	94140	198358	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	585 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009840.111719999	2111636.50785	37.77870647115171	-122.40952070242399	(37.7787064711517, -122.409520702424)
176339	176339	198348	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	550 Minna St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009856.94052	2111939.21808	37.779538585085795	-122.409483854493	(37.7795385850858, -122.409483854493)
135478	135478	198359	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	573 Natoma St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009917.75188	2111704.28637	37.7788969251014	-122.409256897985	(37.7788969251014, -122.409256897985)
15219	15219	74369	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	535 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/09/2002 12:00:00 AM	2	8x4		6009942.57894	2111988.4402900003	37.7796785357608	-122.40919106762101	(37.7796785357608, -122.409191067621)
165359	165359	198352	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	535 Minna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009949.72437	2111999.26449	37.779708656768996	-122.409167112381	(37.779708656769, -122.409167112381)
164548	164548	198347	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	550 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009974.66156	2112054.4958599997	37.77986170610271	-122.40908474167401	(37.7798617061027, -122.409084741674)
41510	41510	198346	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	522 Minna St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6010010.37374	2112093.20065	37.7799699808627	-122.40896392853901	(37.7799699808627, -122.408963928539)
189003	189003	198354	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	529 Minna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010061.1102599995	2112105.44077	37.7800064312917	-122.408789271213	(37.7800064312917, -122.408789271213)
130338	130338	42241	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	543 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM	2		Permit Number 42490	6010082.05945	2111861.68437	37.7793383069574	-122.408699597131	(37.7793383069574, -122.408699597131)
175261	175261	198355	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	538 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6010114.138119999	2111927.58164	37.7795210419915	-122.40859327295401	(37.7795210419915, -122.408593272954)
30575	30575	42240	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	532 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM	2		Permit Number 42489	6010157.096530001	2111965.88499	37.7796286197948	-122.408447363381	(37.7796286197948, -122.408447363381)
130929	130929	198360	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	511 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010317.43719	2112088.63821	37.77997464925679	-122.407901331877	(37.7799746492568, -122.407901331877)
35027	35027	242906	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2641 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010204.149619999	2104543.2646	37.759250446279005	-122.407761055636	(37.759250446279, -122.407761055636)
4081	4081	102392	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	30X Harriet St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6010436.41014	2111752.09711	37.7790572463352	-122.40746601596202	(37.7790572463352, -122.407466015962)
153150	153150	198339	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	474 Natoma St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010463.35799	2112256.87928	37.780444768040496	-122.40740838828	(37.7804447680405, -122.40740838828)
28847	28847	198338	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	474 Natoma St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010471.529619999	2112264.21742	37.7804653742171	-122.40738063611299	(37.7804653742171, -122.407380636113)
35682	35682	198337	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	474 Natoma St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010500.52756	2112291.4654599996	37.7805418139019	-122.407282239501	(37.7805418139019, -122.407282239501)
188175	188175	198336	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	474 Natoma St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010520.61484	2112310.90634	37.7805963181954	-122.407214118563	(37.7805963181954, -122.407214118563)
118113	118113	198335	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	474 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010531.27107	2112320.8566799997	37.7806242358615	-122.407177955016	(37.7806242358615, -122.407177955016)
137959	137959	198404	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	83 Harriet St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010593.58852	2111640.0452900003	37.778758374645	-122.40691436999799	(37.778758374645, -122.406914369998)
27257	27257	198403	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	85 Harriet St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010625.154180001	2111610.62913	37.778679370990204	-122.406803097794	(37.7786793709902, -122.406803097794)
26433	26433	198400	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	89 Harriet St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010709.70909	2111519.6014400003	37.7784341609423	-122.406504172125	(37.7784341609423, -122.406504172125)
130611	130611	198343	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	482 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010728.24226	2111905.72777	37.7794954104221	-122.40646727384501	(37.7794954104221, -122.406467273845)
165549	165549	198399	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	89 Harriet St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010752.17544	2111476.66266	37.7783186367246	-122.406354238056	(37.7783186367246, -122.406354238056)
185690	185690	136955	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	700 Grant Ave	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 3ft		6010930.30149	2117074.44992	37.793698797424796	-122.406132508429	(37.7936987974248, -122.406132508429)
24232	24232	72017	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	464 Tehama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM	2	3x3	Permit Number 51206	6010897.54847	2112072.46722	37.7799627080392	-122.40589331753701	(37.7799627080392, -122.405893317537)
176058	176058	198395	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010955.650090001	2112999.3376599997	37.7825109262834	-122.40575762241998	(37.7825109262834, -122.40575762242)
159480	159480	198394	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010970.67722	2113013.70432	37.782551214095	-122.40570664706001	(37.782551214095, -122.40570664706)
121282	121282	198393	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010986.3468	2113026.7242099997	37.782587839895704	-122.40565335414401	(37.7825878398957, -122.405653354144)
57375	57375	198392	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011000.014830001	2113040.11829	37.7826253811877	-122.40560701207899	(37.7826253811877, -122.405607012079)
176956	176956	198345	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	451 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010996.3869	2112125.34769	37.7801134326192	-122.405555114895	(37.7801134326192, -122.405555114895)
65501	65501	198341	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	446 Tehama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011001.22504	2112170.1942	37.78023684118379	-122.40554153692699	(37.7802368411838, -122.405541536927)
137125	137125	198391	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011033.457280001	2113070.7839	37.7827114517206	-122.405493475357	(37.7827114517206, -122.405493475357)
38555	38555	198390	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011047.1046400005	2113083.17782	37.7827462455888	-122.405447134184	(37.7827462455888, -122.405447134184)
166579	166579	198389	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011138.46827	2113179.02511	37.78301452774279	-122.40513780428499	(37.7830145277428, -122.405137804285)
152817	152817	198384	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011417.757619999	2113442.45107	37.783753443101	-122.404190118502	(37.783753443101, -122.404190118502)
152803	152803	198382	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011448.39911	2113467.1712	37.7838230308611	-122.404085850185	(37.7838230308611, -122.404085850185)
176442	176442	97961	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2280X McKinnon Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2011 12:00:00 AM	2	3x3	Permit Number 768057	6011645.30787	2098748.77937	37.743420626377294	-122.402369377168	(37.7434206263773, -122.402369377168)
146618	146618	97960	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2280X McKinnon Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2011 12:00:00 AM	2	3x3	Permit Number 768057	6011686.23984	2098718.09501	37.7433386585668	-122.40222568708401	(37.7433386585668, -122.402225687084)

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