Street_Tree_List

Data source: data.sfgov.org

343 rows where qSpecies = 90 sorted by PlantDate 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, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate ▲	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
17893	17893	5475	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	601 Dolores St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/30/2008 12:00:00 AM	3	4X4		6005004.3744	2104794.07494	37.759646650682996	-122.425762254445	(37.759646650683, -122.425762254445)
9788	9788	115347	Planning Code 138.1 required 4	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	398X HARRISON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/2016 12:00:00 AM	3	4x4	Permit Number 773314	6014854.0	2114630.0	37.7872055860551	-122.392385006805	(37.7872055860551, -122.392385006805)
9806	9806	115346	Planning Code 138.1 required 4	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	398X HARRISON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/2016 12:00:00 AM	3	4x4	Permit Number 773314	6014854.0	2114630.0	37.7872055860551	-122.392385006805	(37.7872055860551, -122.392385006805)
9079	9079	6769	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1275 Fairfax Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2007 12:00:00 AM	3	3x3		6017217.4089567	2096970.3613046003	37.738846926957706	-122.382978527185	(37.7388469269577, -122.382978527185)
118815	118815	11953	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1436 Kirkwood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/27/2007 12:00:00 AM	6	3X4		6015854.7568499	2096315.1604746997	37.7369724919298	-122.38764428476802	(37.7369724919298, -122.387644284768)
86924	86924	108507	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	796 19th Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/23/2014 12:00:00 AM	3	3x3	Permit Number 773790	5990094.5666	2109953.25495	37.772958540137	-122.477704410848	(37.772958540137, -122.477704410848)
87986	87986	91094	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
114805	114805	91093	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
123957	123957	91091	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
126063	126063	91095	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
139405	139405	91090	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
143561	143561	91089	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
145490	145490	91092	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	3417X 18th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/22/2008 12:00:00 AM	3	3x3	Permit Number 51985	6006736.0	2105525.0	37.761751301646704	-122.41982527826299	(37.7617513016467, -122.419825278263)
18023	18023	108392	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1382 San Bruno Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/19/2014 12:00:00 AM	3	3x3	Permit Number 773801	6011141.7607	2101910.8917	37.7520749768049	-122.40433304488701	(37.7520749768049, -122.404333044887)
17773	17773	18420	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	924 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2013 12:00:00 AM	3	3x3		6010442.48956	2103839.41038	37.7573311599314	-122.406887149344	(37.7573311599314, -122.406887149344)
85651	85651	18391	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	874 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2013 12:00:00 AM	3	4x4		6010420.6643105	2104143.6455038004	37.7581653002339	-122.406984073056	(37.7581653002339, -122.406984073056)
98187	98187	434	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	890X Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2013 12:00:00 AM	3	3x3		6010425.429178201	2104052.7086425	37.7579158746071	-122.406961184613	(37.7579158746071, -122.406961184613)
113842	113842	6746	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1300X Fairfax Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2007 12:00:00 AM	3	3x3		6017621.9936242	2096730.3826429	37.7382103402349	-122.381562963191	(37.7382103402349, -122.381562963191)
120504	120504	17177	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1601 Octavia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/14/2007 12:00:00 AM	3	4X4		6004921.1693652	2114736.5058391998	37.7869414485048	-122.426758067349	(37.7869414485048, -122.426758067349)
124075	124075	50261	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	31 Highland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/14/2002 12:00:00 AM			Permit Number 46967	6005053.32023027	2096760.11488265	37.737590014135	-122.425021354004	(37.737590014135, -122.425021354004)
83349	83349	93300	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	589X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/12/2008 12:00:00 AM	3	3x3		6004575.9	2105667.0	37.7620192734995	-122.427306317148	(37.7620192734995, -122.427306317148)
115779	115779	5577	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1041 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/11/2010 12:00:00 AM	3	3x3		6005148.8764838	2102292.2742932	37.752785456150605	-122.42508448290899	(37.7527854561506, -122.425084482909)
113204	113204	114762	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	27X Highland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/07/2015 12:00:00 AM			Permit Number 46967	6005096.96871	2096699.6024099998	37.7374263260205	-122.424866136467	(37.7374263260205, -122.424866136467)
127668	127668	87026	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	863 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/07/2007 12:00:00 AM		3x3	Permit Number 49970	6004379.0	2103877.0	37.757093220538394	-122.427859766577	(37.7570932205384, -122.427859766577)
14910	14910	17426	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1869 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/05/2015 01:06:00 PM	3	3X3		6013447.639169999	2096284.8118900002	37.736755533926	-122.39596469871401	(37.736755533926, -122.395964698714)
77688	77688	93269	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1730 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004618.0	2098811.0	37.743196678206296	-122.42667246707799	(37.7431966782063, -122.426672467078)
81232	81232	93286	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1283 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004502.0	2101425.0	37.7503675600759	-122.427259727267	(37.7503675600759, -122.427259727267)
84828	84828	93291	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1065 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004445.0	2102697.0	37.753856951407705	-122.42754744828301	(37.7538569514077, -122.427547448283)
84975	84975	93277	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1565 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004670.9	2099777.3	37.7458529070189	-122.426558345234	(37.7458529070189, -122.426558345234)
85134	85134	93273	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1679 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004706.9	2099119.3	37.7440482251279	-122.42638702061701	(37.7440482251279, -122.426387020617)
87716	87716	93293	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1049 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004440.0	2102791.0	37.7541147705659	-122.42757143594	(37.7541147705659, -122.42757143594)
88852	88852	93281	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1465 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004562.0	2100365.0	37.747460438671105	-122.426976756198	(37.7474604386711, -122.426976756198)
90042	90042	93288	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1259 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004494.0	2101568.0	37.7507597523824	-122.42729757712601	(37.7507597523824, -122.427297577126)
97539	97539	93284	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1347 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004523.0	2101050.0	37.7493390847523	-122.427160399995	(37.7493390847523, -122.427160399995)
98869	98869	93275	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1607 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004606.0	2099539.0	37.7451949208192	-122.42676579302	(37.7451949208192, -122.42676579302)
100513	100513	93282	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1383 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004535.0	2100841.0	37.748765897796204	-122.42710401922199	(37.7487658977962, -122.427104019222)
101720	101720	93272	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1689 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004632.0	2099057.0	37.7438729293821	-122.42664157265	(37.7438729293821, -122.42664157265)
108745	108745	93276	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1603 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004604.0	2099562.0	37.7452579604553	-122.426774346316	(37.7452579604553, -122.426774346316)
109604	109604	93274	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1613 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004607.0	2099503.0	37.7450961296299	-122.426759771954	(37.7450961296299, -122.426759771954)
110080	110080	93283	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1377 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004533.0	2100877.0	37.7488646323576	-122.427113499044	(37.7488646323576, -122.427113499044)
110579	110579	93290	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1071 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004519.0	2102665.5	37.7537746450798	-122.427289295317	(37.7537746450798, -122.427289295317)
113436	113436	93287	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1279 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004501.0	2101449.0	37.750433401942104	-122.427264894728	(37.7504334019421, -122.427264894728)
113657	113657	93285	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1289 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004504.0	2101389.0	37.7502688255514	-122.427250247058	(37.7502688255514, -122.427250247058)
113846	113846	93294	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1037 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004436.0	2102861.0	37.7543067479004	-122.427590255736	(37.7543067479004, -122.427590255736)
114160	114160	93292	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1059 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004443.0	2102732.0	37.7539529400822	-122.42755685810499	(37.7539529400822, -122.427556858105)
114770	114770	93280	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1485 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004568.0	2100246.0	37.7471340314151	-122.42694753458099	(37.7471340314151, -122.426947534581)
125597	125597	93271	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1699X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004711.0	2099043.6	37.7438406020251	-122.426367454995	(37.7438406020251, -122.426367454995)
143516	143516	93278	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1559 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004592.0	2099818.0	37.74596019909129	-122.426834068489	(37.7459601990913, -122.426834068489)
144320	144320	93289	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1159 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004476.0	2102138.0	37.752323821507396	-122.427400423827	(37.7523238215074, -122.427400423827)
145306	145306	93295	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1019 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004430.0	2102966.0	37.7545947138847	-122.427618485613	(37.7545947138847, -122.427618485613)
145750	145750	93279	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1557 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2008 12:00:00 AM	3	3x3		6004591.0	2099830.0	37.745993091787795	-122.426838380811	(37.7459930917878, -122.426838380811)
85581	85581	93267	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1550 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004563.0	2099865.0	37.746087610537295	-122.426937693393	(37.7460876105373, -122.426937693393)
85944	85944	93266	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1440 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004482.7	2100527.8	37.747902965476	-122.42726256538602	(37.747902965476, -122.427262565386)
91448	91448	93260	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1250X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004401.7	2101569.1	37.750757552311704	-122.427616837084	(37.7507575523117, -122.427616837084)
92614	92614	93258	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1180X Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004390.8	2101994.4	37.7519247103798	-122.42768482883699	(37.7519247103798, -122.427684828837)
100755	100755	93259	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1234 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004459.0	2101704.0	37.7511311972424	-122.42742829765899	(37.7511311972424, -122.427428297659)
102730	102730	93257	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1180X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004390.8	2101994.4	37.7519247103798	-122.42768482883699	(37.7519247103798, -122.427684828837)
103768	103768	93261	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1252 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004465.0	2101602.0	37.750851468343896	-122.427400283526	(37.7508514683439, -122.427400283526)
124501	124501	93263	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1326 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004490.0	2101167.0	37.749658473374204	-122.42728284799401	(37.7496584733742, -122.427282847994)
126091	126091	93264	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1326 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004490.0	2101167.0	37.749658473374204	-122.42728284799401	(37.7496584733742, -122.427282847994)
139844	139844	93265	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1400X Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/02/2008 12:00:00 AM	3	3x3		6004448.1	2100692.1	37.748352138422796	-122.42739391326401	(37.7483521384228, -122.427393913264)
18377	18377	93250	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1050 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004388.0	2102776.0	37.754070642695496	-122.42775019598	(37.7540706426955, -122.42775019598)
83075	83075	93252	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
94013	94013	93253	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
102183	102183	93254	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
106002	106002	93256	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1120 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3	Owner Michael Freethy signed agreement on 12/26/09 to maintain curb cut added within 4' of tree after tree was planted	6004410.0	2102371.0	37.7529598520175	-122.427645261537	(37.7529598520175, -122.427645261537)
106888	106888	93251	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1060 CHURCH ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004371.0	2102721.0	37.753918663927706	-122.42780506745899	(37.7539186639277, -122.427805067459)
114784	114784	93255	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1070 Church St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/01/2008 12:00:00 AM	3	3x3		6004394.0	2102659.0	37.753749727529396	-122.427721110855	(37.7537497275294, -122.427721110855)
82006	82006	32722	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	644 Hyde St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/30/2011 12:00:00 AM	3	3x3	Permit Number 768334	6007901.48303797	2114768.35798987	37.7871969578975	-122.416449089052	(37.7871969578975, -122.416449089052)
138637	138637	94896	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1375 Keith St		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/23/2010 12:00:00 AM		3x3	Permit Number 53955	6016208.4	2094705.0	37.7325708970962	-122.386309345138	(37.7325708970962, -122.386309345138)
21685	21685	18423	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	952 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/20/2013 12:00:00 AM	3	3x3		6010455.30853	2103703.2834799998	37.75695810316021	-122.406833222372	(37.7569581031602, -122.406833222372)
144520	144520	52671	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1234@ LINCOLN 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/10/2010 12:00:00 AM		3x3	Permit Number 53911	5993637.83557736	2107090.14039952	37.7653021756316	-122.46523990796699	(37.7653021756316, -122.465239907967)
78052	78052	103838	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
82685	82685	103874	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1331 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006716.3	2115545.2	37.7892632533111	-122.42060474068998	(37.7892632533111, -122.42060474069)
84499	84499	103835	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
99080	99080	103792	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
103470	103470	103793	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
104380	104380	103834	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
107651	107651	103837	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
114055	114055	103794	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
125341	125341	103817	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1100 Polk St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006925.9	2114751.5	37.787095758933894	-122.41982320605	(37.7870957589339, -122.41982320605)
141455	141455	103836	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	900X O'Farrell St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006751.076230001	2113939.67696	37.78485684194221	-122.420370415446	(37.7848568419422, -122.420370415446)
142798	142798	103791	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1214 Polk St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/2009 12:00:00 AM	3	3x3		6006878.4	2115091.6	37.7880269138329	-122.420011690177	(37.7880269138329, -122.420011690177)
4892	4892	21646	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1660 Sutter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/31/2017 01:25:00 PM	3	3X4		6004679.2621	2114722.8807	37.7868903572795	-122.427594040592	(37.7868903572795, -122.427594040592)
4901	4901	18480	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1298 Potrero Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/31/2017 01:20:00 PM	3	3x3		6010561.39126	2101710.28558	37.751491708090896	-122.406325925618	(37.7514917080909, -122.406325925618)
112161	112161	32720	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	644 Hyde St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/29/1996 12:00:00 AM	3	3x3	Permit Number 37113	6007901.48303797	2114768.35798987	37.7871969578975	-122.416449089052	(37.7871969578975, -122.416449089052)
115718	115718	32721	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	644 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/29/1996 12:00:00 AM	3	3x3	Permit Number 37113	6007901.48303797	2114768.35798987	37.7871969578975	-122.416449089052	(37.7871969578975, -122.416449089052)
50163	50163	17385	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1649 Palou Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/28/1996 12:00:00 AM	12	6x5		6014583.05525	2095408.96107	37.7344137306531	-122.39197780950899	(37.7344137306531, -122.391977809509)
1590	1590	5343	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	180 Dolores St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/24/2014 02:20:00 PM	3	3X3		6004776.7961099995	2107352.0132	37.7666572770255	-122.426731495165	(37.7666572770255, -122.426731495165)
91750	91750	94689	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	218 Roanoke St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/22/2010 12:00:00 AM		3x3	Permit Number 53815	6003547.0	2096007.0	37.73543692838779	-122.43017570506201	(37.7354369283878, -122.430175705062)
114281	114281	26918	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2000X Bay Shore Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/19/2010 12:00:00 AM	3	3X3		6012375.8565272	2088505.2474916999	37.7153347551878	-122.399124435859	(37.7153347551878, -122.399124435859)
127346	127346	94638	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2000X Bay Shore Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/19/2010 12:00:00 AM	3	3x3		6012318.2	2088514.6	37.715357222040005	-122.399324379639	(37.71535722204, -122.399324379639)
122456	122456	3904	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	84 Castro St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/13/2014 11:00:00 AM	3	2X2		6002180.9408165	2107753.3024618	37.7676120130603	-122.435738811724	(37.7676120130603, -122.435738811724)
53287	53287	78624	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1325 Kansas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/07/2000 12:00:00 AM	2			6011733.68356	2102177.51534	37.7528401263726	-122.402304820204	(37.7528401263726, -122.402304820204)
62190	62190	79630	Undocumented 2	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	1331 Kansas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/05/2002 12:00:00 AM	2			6011736.35903	2102141.72528	37.752742004040606	-122.402293051689	(37.7527420040406, -122.402293051689)
61066	61066	67550	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	890 Rhode Island St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/05/1992 12:00:00 AM	8		Permit Number 31097	6011842.0519199995	2104248.01189	37.7585313034009	-122.402075608207	(37.7585313034009, -122.402075608207)
127402	127402	13061	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	583 Lombard St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/01/2013 12:00:00 AM	12	2X2		6009566.8887098	2120490.1657189	37.8030011583731	-122.411091436508	(37.8030011583731, -122.411091436508)
44178	44178	91424	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
91361	91361	91421	DPW Maintained 3	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102; tree 1 on Sanchez (DPW-maintained); maintenance agreement through 4/8/2012	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)
120630	120630	91426	Permitted Site 1	Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90	2112 15th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/26/2008 12:00:00 AM		3x3	Permit Number 52102	6003571.0	2107157.0	37.7660535712373	-122.430888215554	(37.7660535712373, -122.430888215554)

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