Street_Tree_List

Data source: data.sfgov.org

1,501 rows where qSpecies = 62 sorted by TreeID 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

Link	rowid	TreeID ▲	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
1513	1513	251580	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	788 Harrison St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6012749.64869	2112405.5203400003	37.78098060211779	-122.39950942241998	(37.7809806021178, -122.39950942242)
1529	1529	251578	DPW Maintained 3	Liquidambar styraciflua :: American Sweet Gum 62	1000X Columbus Ave	6	Median : Cutout 11	Tree 1	DPW 2
131133	131133	250130	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1377 Post St	2	: 4	Tree 1	Private 1			8	Width 4ft		6005624.52501	2114452.88232	37.786202430153395	-122.42430443452601	(37.7862024301534, -122.424304434526)
150255	150255	250129	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1377 Post St	1	: 4	Tree 1	Private 1			8	Width 4ft		6005609.22184	2114451.0225400003	37.786196459532704	-122.42435724721201	(37.7861964595327, -122.424357247212)
46247	46247	250029	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1398 Gough St	2	: 4	Tree 1	Private 1			7	Width 4ft		6005499.34318	2114400.53474	37.7860516273342	-122.424733805923	(37.7860516273342, -122.424733805923)
129549	129549	250027	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1388 Gough St	2	: 4	Tree 1	Private 1			6	Width 4ft		6005504.43903	2114371.51964	37.7859722468757	-122.424714110791	(37.7859722468757, -122.424714110791)
37080	37080	250025	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	2 Peter Yorke Way	4	: 4	Tree 1	Private 1			10	Width 4ft		6005592.08729	2114239.19437	37.7856138643192	-122.424401456086	(37.7856138643192, -122.424401456086)
41550	41550	250024	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	2 Peter Yorke Way	3	: 4	Tree 1	Private 1			8	Width 3ft		6005604.615069999	2114246.3062	37.785634099068496	-122.42435861956301	(37.7856340990685, -122.424358619563)
51658	51658	250023	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	2 Peter Yorke Way	2	: 4	Tree 1	Private 1			7	Width 3ft		6005617.72798	2114253.53243	37.785654680956505	-122.424313766772	(37.7856546809565, -122.424313766772)
55138	55138	250022	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	2 Peter Yorke Way	1	: 4	Tree 1	Private 1			7	Width 3ft		6005626.62253	2114259.1773	37.785670682612704	-122.424283395778	(37.7856706826127, -122.424283395778)
162304	162304	249548	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1398 Gough St	3	: 4	Tree 1	Private 1			7	Width 4ft		6005498.68778	2114410.1852	37.78607808808621	-122.424736760212	(37.7860780880862, -122.424736760212)
153816	153816	248617	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	448 Frederick St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5997580.2895	2107483.1274	37.7666077810146	-122.45163230595699	(37.7666077810146, -122.451632305957)
1457	1457	248600	Permitted Site 1	Liquidambar styraciflua :: American Sweet Gum 62	840 Stanyan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/10/1979 12:00:00 AM	12	Width 0ft	Permit Number 17869	5997201.7532	2107543.996	37.7667532252023	-122.452945984051	(37.7667532252023, -122.452945984051)
150640	150640	248598	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	833 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5997636.9186	2107601.8364	37.7669369685535	-122.45144499969801	(37.7669369685535, -122.451444999698)
32527	32527	248574	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	332 Frederick St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5998368.8565	2107590.9345	37.7669489203591	-122.448912568843	(37.7669489203591, -122.448912568843)
163023	163023	248573	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	186 Belvedere St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5998328.5802	2107663.0078	37.7671445119353	-122.449057070143	(37.7671445119353, -122.449057070143)
55782	55782	248572	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	196 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5998334.1825	2107625.9113	37.767042974765396	-122.449035020083	(37.7670429747654, -122.449035020083)
71173	71173	248546	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	274 Frederick St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5998737.3995	2107643.324	37.7671138382275	-122.44764161406	(37.7671138382275, -122.44764161406)
164056	164056	248509	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	784 Ashbury St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5999110.4849	2107801.0979	37.767568360809705	-122.44636252424	(37.7675683608097, -122.44636252424)
74121	74121	248502	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	160 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5998304.9595	2107828.0497	37.767596324135205	-122.44915066144699	(37.7675963241352, -122.449150661447)
177099	177099	248491	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	761 Clayton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5998570.692000001	2107873.0198	37.767734995757706	-122.44823476937701	(37.7677349957577, -122.448234769377)
133746	133746	248490	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	761 Clayton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5998568.8751	2107887.5556	37.7677748035101	-122.448242100604	(37.7677748035101, -122.448242100604)
34401	34401	248476	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	757 Clayton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5998566.1496	2107908.4508	37.767832020618	-122.44825303255101	(37.767832020618, -122.448253032551)
151190	151190	248471	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	753 Clayton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5998562.8185	2107931.7687	37.7678958552223	-122.448266233683	(37.7678958552223, -122.448266233683)
23897	23897	248466	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	144 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5998292.5435	2107918.5956	37.7678442300261	-122.449200130602	(37.7678442300261, -122.449200130602)
29318	29318	248428	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	130 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5998278.3106	2108020.0433	37.768121965532295	-122.449256670048	(37.7681219655323, -122.449256670048)
131041	131041	248408	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	737 Ashbury St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		5999027.964	2108082.5775	37.7683365192661	-122.44666820698	(37.7683365192661, -122.44666820698)
150434	150434	248367	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	714 Ashbury St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5999062.3351	2108141.4778	37.768500207911	-122.446553559197	(37.768500207911, -122.446553559197)
67648	67648	248339	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	105 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5998213.3537	2108180.6942	37.76855935635471	-122.4494929252	(37.7685593563547, -122.4494929252)
150442	150442	248323	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	106 Belvedere St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5998260.7465	2108151.4712	37.768481828451705	-122.449326892475	(37.7684818284517, -122.449326892475)
152889	152889	248322	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	110 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		5998263.1691	2108132.3929	37.7684295828689	-122.449317138225	(37.7684295828689, -122.449317138225)
163363	163363	247405	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	904 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6002202.1057	2109513.8943	37.772447365636296	-122.435791586631	(37.7724473656363, -122.435791586631)
30061	30061	247344	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	213 Pierce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6002764.9406	2109273.4332	37.771819073738705	-122.43382749783899	(37.7718190737387, -122.433827497839)
174221	174221	247343	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	215 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6002761.7602	2109295.1659999997	37.771878566171	-122.43384005268601	(37.771878566171, -122.433840052686)
187943	187943	247318	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	225 Pierce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6002751.6889	2109356.6539	37.7720468252571	-122.433879285742	(37.7720468252571, -122.433879285742)
37835	37835	247317	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	225 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6002750.0987	2109384.7475	37.7721238731083	-122.433886794778	(37.7721238731083, -122.433886794778)
147506	147506	247313	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	235 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6002747.4483	2109401.7096	37.7721702964431	-122.433897175351	(37.7721702964431, -122.433897175351)
28215	28215	247280	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	520 Ashbury St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5998954.6357	2108912.2879	37.7706105046931	-122.446981556392	(37.7706105046931, -122.446981556392)
29643	29643	246620	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	171 Ripley St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 5ft		6009078.777530001	2099136.29589	37.744341055486295	-122.411271191437	(37.7443410554863, -122.411271191437)
74914	74914	246619	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	171 Ripley St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 5ft		6009083.01922	2099139.1845299997	37.7443492249476	-122.411256728527	(37.7443492249476, -122.411256728527)
54764	54764	246617	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	179 Ripley St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		6009150.0999300005	2099139.59949	37.7443541262592	-122.411024805947	(37.7443541262592, -122.411024805947)
26172	26172	246467	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	244 Duncan St	1	: 4	Tree 1	Private 1			8	Width 4ft		6004891.34106	2099910.0636400003	37.7462299051934	-122.42580553881099	(37.7462299051934, -122.425805538811)
183591	183591	246071	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	7 Central Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5999960.6775	2108354.2152	37.769135603145706	-122.44346156363399	(37.7691356031457, -122.443461563634)
146987	146987	246070	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	7 Central Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5999958.8605	2108368.4482	37.769174579766606	-122.443468871034	(37.7691745797666, -122.443468871034)
181051	181051	246069	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	5 Central Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5999956.4379	2108386.6179	37.769224331039	-122.44347855599301	(37.769224331039, -122.443478555993)
26456	26456	246068	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	5 Central Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5999954.0153	2108402.9707	37.7692690935594	-122.443488110434	(37.7692690935594, -122.443488110434)
165136	165136	246067	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	3 Central Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5999950.6842	2108423.8659	37.7693262765559	-122.44350113367399	(37.7693262765559, -122.443501133674)
186967	186967	246066	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1 Central Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5999949.17	2108444.1555	37.7693819003429	-122.443507828871	(37.7693819003429, -122.443507828871)
52705	52705	245961	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	826 Stanyan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5997192.3655	2107614.858	37.7669472561331	-122.452983569947	(37.7669472561331, -122.452983569947)
171735	171735	245960	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	826 Stanyan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5997194.7881	2107596.3855	37.7668966742107	-122.45297385706002	(37.7668966742107, -122.45297385706)
40953	40953	245956	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	753 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5997593.1598	2107917.3843	37.76780087666	-122.45161911748	(37.76780087666, -122.45161911748)
70572	70572	245932	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	18 Beulah St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5997864.0404	2107868.4774	37.7676820998331	-122.450678651711	(37.7676820998331, -122.450678651711)
165952	165952	245931	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	10 Beulah St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5997879.1818	2107870.9	37.767689618362496	-122.450626454426	(37.7676896183625, -122.450626454426)
66990	66990	245930	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	8 Beulah St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5997897.9572	2107873.0198	37.7676965134568	-122.45056166580099	(37.7676965134568, -122.450561665801)
150146	150146	245178	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1216 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6000704.3825	2109304.0037	37.7717858689809	-122.44095728321301	(37.7717858689809, -122.440957283213)
169822	169822	245064	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	32 Lyon St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6000392.6081	2109071.4254	37.771129505386604	-122.44201903158998	(37.7711295053866, -122.44201903159)
170693	170693	244123	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1755 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5998171.5107	2108905.8328	37.7705480081413	-122.449689917353	(37.7705480081413, -122.449689917353)
61996	61996	244034	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1925 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5997320.7945	2108781.1554	37.770156968781706	-122.45262353747101	(37.7701569687817, -122.452623537471)
133588	133588	244028	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	505 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5997955.1459	2108804.2678	37.77025675577271	-122.450430998709	(37.7702567557727, -122.450430998709)
187714	187714	228024	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	4977 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5997519.34069	2105604.1197599997	37.7614450124062	-122.451707557883	(37.7614450124062, -122.451707557883)
73010	73010	228023	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	4983 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5997504.72256	2105600.12187	37.761433198010295	-122.451757827265	(37.7614331980103, -122.451757827265)
176760	176760	228022	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	651 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		5998670.61902	2105427.9358599996	37.7610271226231	-122.44771309667802	(37.7610271226231, -122.447713096678)
25393	25393	228021	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1054 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5998157.054409999	2106607.36365	37.7642361689933	-122.44957427424102	(37.7642361689933, -122.449574274241)
63311	63311	228020	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1112 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5998182.13932	2106442.54702	37.7637850591596	-122.449475636595	(37.7637850591596, -122.449475636595)
183153	183153	228019	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1118 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		5998187.56387	2106423.37848	37.7637327374956	-122.44945549358299	(37.7637327374956, -122.449455493583)
177956	177956	228018	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1118 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 4ft		5998188.96847	2106410.92165	37.7636986145324	-122.44944973792101	(37.7636986145324, -122.449449737921)
63354	63354	228017	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1136 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 4ft		5998195.21077	2106351.13938	37.7635348245821	-122.44942384014601	(37.7635348245821, -122.449423840146)
74460	74460	228016	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1208 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		5998218.953980001	2106172.93012	37.7630468650329	-122.449328879841	(37.7630468650329, -122.449328879841)
36840	36840	228015	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1224 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		5998227.909	2106103.56312	37.7628569129495	-122.44929290966199	(37.7628569129495, -122.449292909662)
77149	77149	228014	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1236 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5998231.861819999	2106073.6543400004	37.7627750170686	-122.44927708336901	(37.7627750170686, -122.449277083369)
26610	26610	228013	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1343 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5998231.8221	2105759.10992	37.76191135493279	-122.449254558076	(37.7619113549328, -122.449254558076)
33815	33815	228012	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1317 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5998216.16813	2105874.44581	37.762227142891504	-122.449317008786	(37.7622271428915, -122.449317008786)
153751	153751	228011	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1317 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5998213.13693	2105892.48984	37.7622765138731	-122.44932879261002	(37.7622765138731, -122.44932879261)
162310	162310	228010	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1241 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		5998195.31145	2106018.04873	37.7626202473408	-122.449399490988	(37.7626202473408, -122.449399490988)
58341	58341	228009	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	109 Alma St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 2ft		5998119.85145	2106206.2133	37.7631325830122	-122.44967403874399	(37.7631325830122, -122.449674038744)
42186	42186	228008	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1149 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5998158.99229	2106286.14081	37.7633542830094	-122.449544423956	(37.7633542830094, -122.449544423956)
56359	56359	228007	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1139 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		5998149.3046699995	2106328.0712900003	37.763468859326295	-122.44958095170901	(37.7634688593263, -122.449580951709)
67771	67771	228006	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1057 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		5998117.27341	2106573.00208	37.76413954493321	-122.449709388403	(37.7641395449332, -122.449709388403)
178240	178240	228005	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1051 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		5998115.625990001	2106592.03461	37.7641917091996	-122.44971645795401	(37.7641917091996, -122.449716457954)
135564	135564	228004	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1039 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		5998111.03938	2106633.51885	37.7643053520281	-122.449735311348	(37.7643053520281, -122.449735311348)
159772	159772	228003	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1039 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5998107.95915	2106649.18866	37.7643482011369	-122.44974709425199	(37.7643482011369, -122.449747094252)
146691	146691	228002	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1033 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		5998104.33903	2106671.65488	37.764409680579	-122.449761234305	(37.764409680579, -122.449761234305)
169034	169034	228001	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1027 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5998100.634380001	2106690.05164	37.764459981474204	-122.44977537345899	(37.7644599814742, -122.449775373459)
179466	179466	228000	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1229 Stanyan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			26	Width 5ft		5997430.92734	2105573.7354599996	37.761356520915896	-122.452011149197	(37.7613565209159, -122.452011149197)
156293	156293	227999	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1227 Stanyan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 6ft		5997427.0236	2105612.47787	37.7614626741762	-122.452027445805	(37.7614626741762, -122.452027445805)
63959	63959	227998	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1187 Stanyan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5997369.80314	2106003.7248299997	37.7625336615227	-122.45225357855101	(37.7625336615227, -122.452253578551)
136755	136755	227997	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1183 Stanyan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 4ft		5997362.1332	2106037.84673	37.7626269122233	-122.452282568209	(37.7626269122233, -122.452282568209)
150996	150996	227996	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	189 Chattanooga St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		6004766.62368	2102596.11028	37.753598118175205	-122.426428015339	(37.7535981181752, -122.426428015339)
29224	29224	227995	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	321 Chattanooga St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		6004807.15163	2101805.7755	37.7514303338561	-122.426231597132	(37.7514303338561, -122.426231597132)
150669	150669	227994	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1306 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 5ft		6003859.6662099995	2100626.63224	37.748139081362794	-122.42942403481001	(37.7481390813628, -122.42942403481)
35886	35886	227993	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1415 Sanchez St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		6003948.06248	2100010.3566900003	37.7464519361185	-122.42907442965901	(37.7464519361185, -122.429074429659)
47874	47874	227992	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1415 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6003949.35051	2099995.18612	37.7464103541603	-122.429068894324	(37.7464103541603, -122.429068894324)
51349	51349	227991	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1419 Sanchez St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 4ft		6003954.54323	2099918.21821	37.7461993120526	-122.429045451712	(37.7461993120526, -122.429045451712)
174749	174749	227990	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	1504 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6003927.19996	2099465.05045	37.744953470419	-122.42910769558901	(37.744953470419, -122.429107695589)
184736	184736	227989	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	419 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6003146.12885	2099470.64592	37.744924588703604	-122.431808894759	(37.7449245887036, -122.431808894759)
75102	75102	227988	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	312 28th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		6003841.41785	2099558.26389	37.7452045566614	-122.429410960447	(37.7452045566614, -122.429410960447)
147761	147761	227987	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	312 28th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6003864.381	2099559.4457400003	37.74520910181629	-122.429331642062	(37.7452091018163, -122.429331642062)
50500	50500	227986	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	312 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6003891.46294	2099561.3900200003	37.7452159735461	-122.42923813594999	(37.7452159735461, -122.42923813595)
162441	162441	227985	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	222 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 6ft		6004405.37253	2099591.374	37.7453273824517	-122.427463259139	(37.7453273824517, -122.427463259139)
174037	174037	227984	Undocumented 2	Liquidambar styraciflua :: American Sweet Gum 62	151 Day St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6004984.7941	2098700.56967	37.7429141920365	-122.425396332001	(37.7429141920365, -122.425396332001)

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