Street_Tree_List

Data source: data.sfgov.org

153 rows where qSpecies = 274 sorted by rowid 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, PlantDate, DBH, PlotSize, PermitNotes

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
188961	188961	203619	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	624 Congo St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 2ft		6000138.382019999	2095835.3347200002	37.7347719253748	-122.441948223841	(37.7347719253748, -122.441948223841)
187046	187046	203611	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	146 Quintara St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5992953.888809999	2101207.94105	37.7491117215315	-122.467177780245	(37.7491117215315, -122.467177780245)
184134	184134	221954	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	10 Mateo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6003651.78928	2096634.4220599998	37.737165621192204	-122.42985814834101	(37.7371656211922, -122.429858148341)
183483	183483	99289	Significant Tree 6	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	845 Marina Blvd	2	Front Yard : Yard 7	Tree 1	Private 1		06/05/2012 12:00:00 AM	1		Permit Number 768788	5998887.79124	2121333.18312	37.8047111982366	-122.448107254257	(37.8047111982366, -122.448107254257)
182579	182579	189230	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1919 22nd St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 3ft		6012335.96177	2103730.27512	37.7571372669841	-122.400331070924	(37.7571372669841, -122.400331070924)
182032	182032	121978	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	200 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5991208.0697800005	2113958.75361	37.7840210969883	-122.474145024774	(37.7840210969883, -122.474145024774)
181110	181110	203599	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	200 Minerva St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5994990.6649400005	2089034.05641	37.715802567698105	-122.459253178313	(37.7158025676981, -122.459253178313)
180671	180671	221948	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	633 Capp St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 3ft		6007312.78593	2103619.1206099996	37.75655067338779	-122.417695309584	(37.7565506733878, -122.417695309584)
180257	180257	189221	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1310 Indiana St	14	: Yard 23	Tree 1	Private 1			1			6015010.96324	2102373.3642599997	37.7535602828051	-122.39098497537901	(37.7535602828051, -122.390984975379)
179068	179068	175218	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	93 Morse St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6001014.57653	2087970.42853	37.713226572126295	-122.43835564452101	(37.7132265721263, -122.438355644521)
178785	178785	125565	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1907 Baker St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		5999924.7797300005	2115560.6496599996	37.7889205779801	-122.44410362179501	(37.7889205779801, -122.444103621795)
177938	177938	70277	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	481 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/06/2012 12:00:00 AM	2		Permit Number 768624	5985297.751569999	2112660.9809	37.78011363845471	-122.49449657583901	(37.7801136384547, -122.494496575839)
177821	177821	175217	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1601 San Jose Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1			6001607.87231	2094169.8653099998	37.7302825582951	-122.436748518241	(37.7302825582951, -122.436748518241)
177619	177619	203602	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	601 Capitol Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5995030.39824	2089062.5673099998	37.7158831361758	-122.45911790587799	(37.7158831361758, -122.459117905878)
177564	177564	221940	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	168 Tiffany Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		6006049.87669	2099255.63478	37.7444983936957	-122.421752983209	(37.7444983936957, -122.421752983209)
176692	176692	203607	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	2007 15th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991582.5756	2101730.87003	37.750468294886296	-122.471957859468	(37.7504682948863, -122.471957859468)
176518	176518	189232	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1919 22nd St	7	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 3ft		6012390.797040001	2103733.87239	37.7571502019395	-122.40014168090799	(37.7571502019395, -122.400141680908)
174756	174756	203615	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	240 Colon Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5996037.383230001	2094398.48179	37.7305921283128	-122.45602285758899	(37.7305921283128, -122.456022857589)
174263	174263	221950	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	31 29th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006097.6775	2099053.5817299997	37.7439462971915	-122.421573349947	(37.7439462971915, -122.421573349947)
171871	171871	175222	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	300 Gaven St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 5ft		6008975.9211800005	2094875.47718	37.7326360049484	-122.411325907078	(37.7326360049484, -122.411325907078)
169684	169684	81047	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	961 Prague St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/22/2003 12:00:00 AM	2			6001634.7016900005	2086773.55642	37.7099754779527	-122.436126687404	(37.7099754779527, -122.436126687404)
169286	169286	221958	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	779 Crescent Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008100.58194	2095693.3071	37.7348324551576	-122.414410025905	(37.7348324551576, -122.414410025905)
168407	168407	189237	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1700 Bancroft Ave	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 10ft		6013775.5681	2092627.0535099998	37.726730316242296	-122.394574839671	(37.7267303162423, -122.394574839671)
168365	168365	221947	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	689 Ogden Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6007672.8407	2096154.7937900003	37.7360755583335	-122.41592154886101	(37.7360755583335, -122.415921548861)
165489	165489	125564	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	165 Marina Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 7ft		6002712.8181	2121563.83713	37.805562426341	-122.434886887435	(37.805562426341, -122.434886887435)
163497	163497	108895	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	666 26th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/20/2016 12:00:00 AM	1	3x3	Permit Number 774994	5987872.85836	2111424.89012	37.7768700551182	-122.48549748779399	(37.7768700551182, -122.485497487794)
161097	161097	125566	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	2809 Buchanan St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		6003481.18787	2118079.55095	37.7960390779962	-122.431978879228	(37.7960390779962, -122.431978879228)
160726	160726	37181	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	2519 Pacific Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/08/1998 12:00:00 AM	7		Permit Number 39755	6001865.38269	2116985.0366700003	37.792942091651796	-122.437491453568	(37.7929420916518, -122.437491453568)
160500	160500	189234	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1919 22nd St	9	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 3ft		6012405.15003	2103734.72302	37.757153337862206	-122.400092102164	(37.7571533378622, -122.400092102164)
159774	159774	175225	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	762 Prague St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002385.00148	2087111.8293299999	37.7109469004454	-122.43355766966299	(37.7109469004454, -122.433557669663)
159483	159483	221944	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	375 Park St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6007244.42247	2096286.76622	37.7364138302231	-122.417412117593	(37.7364138302231, -122.417412117593)
157767	157767	125567	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	2809 Buchanan St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6003482.8439	2118067.55033	37.7960062212666	-122.431972291689	(37.7960062212666, -122.431972291689)
156150	156150	203608	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	2007 15th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991583.6607	2101714.46197	37.7504233054064	-122.471952911395	(37.7504233054064, -122.471952911395)
153354	153354	203597	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	50 De Montfort Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995113.8822800005	2091909.7950400002	37.723705745105796	-122.45903538769	(37.7237057451058, -122.45903538769)
150968	150968	203605	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	556 Victoria St	1	: 4	Tree 1	Private 1			2	Width 3ft		5993274.01352	2090867.72296	37.720738530042205	-122.46531978898999	(37.7207385300422, -122.46531978899)
150529	150529	189236	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1700 Bancroft Ave	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 10ft		6013792.02021	2092615.53995	37.7266996169689	-122.39451715893499	(37.7266996169689, -122.394517158935)
150491	150491	204746	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	624 Congo St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 2ft		6000138.084559999	2095837.9726	37.734779151424796	-122.441949441533	(37.7347791514248, -122.441949441533)
150141	150141	125560	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	20 Mallorca Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001979.154630001	2119935.63772	37.8010501391173	-122.437309169106	(37.8010501391173, -122.437309169106)
149824	149824	203603	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	533 Capitol Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5995027.64484	2088883.389	37.7153909965718	-122.459114456087	(37.7153909965718, -122.459114456087)
148279	148279	221942	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	133 Ellert St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6007406.60903	2096997.58914	37.738374717426204	-122.41690171544501	(37.7383747174262, -122.416901715445)
147451	147451	203591	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1677 18th Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 3ft		5990564.22398	2103984.5948	37.7565974498416	-122.475643908062	(37.7565974498416, -122.475643908062)
146524	146524	189229	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1459 Rhode Island St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1			6012049.051519999	2101579.4163599997	37.7512154759161	-122.40117218884899	(37.7512154759161, -122.401172188849)
146428	146428	123227	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	790 09th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 6ft		5993222.74872	2110119.7569	37.7735967518389	-122.46689584772301	(37.7735967518389, -122.466895847723)
146397	146397	221963	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	4086 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6002569.41757	2102410.84038	37.7529649603686	-122.434013186153	(37.7529649603686, -122.434013186153)
145912	145912	203606	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1570 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992477.77859	2104773.12978	37.7588733092773	-122.46908359384199	(37.7588733092773, -122.469083593842)
144567	144567	109033	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	2120 Moraga St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/22/2015 12:00:00 AM	3	3x3	Permit Number 772816	5987671.1	2103767.6	37.755833493421704	-122.48563331933	(37.7558334934217, -122.48563331933)
143315	143315	101003	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	2801X Buchanan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/10/2012 12:00:00 AM		3x3	Permit Number 769246	6003500.6	2117942.3	37.795663322696704	-122.43190190430201	(37.7956633226967, -122.431901904302)
141314	141314	114969	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	200X MINERVA ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5994532.0	2089023.0	37.7157458289959	-122.460837724068	(37.7157458289959, -122.460837724068)
140457	140457	108526	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1677 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/23/2014 12:00:00 AM	3	3x3	Permit Number 773677	5990566.2613699995	2103985.48594	37.7566000147891	-122.47563692717699	(37.7566000147891, -122.475636927177)
138740	138740	69064	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1359 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/23/2014 12:00:00 AM	3		Permit Number 773642	5992377.26935607	2106205.46978928	37.7628003299421	-122.469535465436	(37.7628003299421, -122.469535465436)
137574	137574	203600	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	200 Minerva St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5994977.66041	2089033.8898200002	37.7158013626108	-122.45929811561399	(37.7158013626108, -122.459298115614)
137427	137427	118234	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	590 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5984132.17313	2111832.6704599997	37.7777710528241	-122.498467578545	(37.7777710528241, -122.498467578545)
135119	135119	175224	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	762 Prague St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002402.88459	2087125.99028	37.710986797965	-122.43349687280899	(37.710986797965, -122.433496872809)
134805	134805	121976	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	200 15th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5991206.08725	2113988.74508	37.7841033304005	-122.474154072624	(37.7841033304005, -122.474154072624)
134698	134698	221960	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	75 Coleridge St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6006819.46923	2099263.44478	37.744563206943795	-122.41909243697799	(37.7445632069438, -122.419092436978)
134131	134131	187965	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	211 Terry A Francois Blvd	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 5ft		6015662.09524	2110622.5452099997	37.776246856837794	-122.38930919937	(37.7762468568378, -122.38930919937)
133951	133951	221946	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	689 Ogden Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6007705.60833	2096151.45352	37.7360682288544	-122.415808021131	(37.7360682288544, -122.415808021131)
132702	132702	221951	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1636 Diamond St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 8ft		6002000.14888	2099232.59033	37.7442059152698	-122.435754448124	(37.7442059152698, -122.435754448124)
131651	131651	189235	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1634 Jerrold Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 5ft		6015126.7090300005	2097207.07467	37.7393811514086	-122.390223786492	(37.7393811514086, -122.390223786492)
131580	131580	175220	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	178 Allison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6000035.73488	2087742.43428	37.7125448266481	-122.441722494022	(37.7125448266481, -122.441722494022)
130779	130779	203598	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	200 Minerva St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995008.49221	2089033.0248099999	37.715800760085	-122.459191484793	(37.715800760085, -122.459191484793)
129695	129695	221943	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	237 Holly Park Cir	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6006873.22599	2096639.71242	37.737362050226395	-122.41872052504401	(37.7373620502264, -122.418720525044)
128358	128358	113268	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1034 Hollister Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/16/2015 12:00:00 AM			Permit Number 774686	6014704.8	2089850.3	37.7191575187873	-122.391168478676	(37.7191575187873, -122.391168478676)
127347	127347	117307	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	714 46th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/06/2016 12:00:00 AM	3		Permit Number 778519	5981710.1	2110853.1	37.7749391065248	-122.506773545049	(37.7749391065248, -122.506773545049)
125904	125904	36574	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	2959 25th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/05/2015 12:00:00 AM	3		Permit Number 773747	6009743.48880831	2101591.28473575	37.7511191714417	-122.409145947985	(37.7511191714417, -122.409145947985)
125614	125614	109897	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1734 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/09/2015 12:00:00 AM	3	3x3	Permit Number 775111	5987546.7	2103468.6	37.75500527135279	-122.486041582178	(37.7550052713528, -122.486041582178)
121037	121037	114971	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	431 Gennessee St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/28/2015 12:00:00 AM			Permit Number 771835	5997422.4	2094904.1	37.7320598346121	-122.45127112251998	(37.7320598346121, -122.45127112252)
120094	120094	123429	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	690 03rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		5995057.91765	2110847.9262900003	37.7757018603334	-122.460600543143	(37.7757018603334, -122.460600543143)
118943	118943	115333	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	667 03rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/26/2016 12:00:00 AM	3		Permit Number 776458	5994991.0	2111007.6	37.7761364319113	-122.460843601074	(37.7761364319113, -122.460843601074)
118438	118438	115207	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1014 Scott St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/19/2016 12:00:00 AM			Permit Number 774282	6001957.4	2112096.8	37.77952547459579	-122.436822979652	(37.7795254745958, -122.436822979652)
117203	117203	89148	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	5530 California St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/07/2008 12:00:00 AM	2	3x3	Permit Number 51801	5990364.38578	2114085.53443	37.7843202921023	-122.47707310075	(37.7843202921023, -122.47707310075)
114574	114574	117306	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	732 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/06/2016 12:00:00 AM	3		Permit Number 778516	5981405.4	2110730.6	37.7745848102238	-122.507818456039	(37.7745848102238, -122.507818456039)
112531	112531	115208	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1014 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/19/2016 12:00:00 AM			Permit Number 774282	6001957.4	2112096.8	37.77952547459579	-122.436822979652	(37.7795254745958, -122.436822979652)
110414	110414	90809	DPW Maintained 3	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	3351X Cabrillo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/04/2015 11:05:00 AM	3	3x3		5985151.309330001	2110394.17837	37.77388107713121	-122.494835999778	(37.7738810771312, -122.494835999778)
107231	107231	93572	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	757 04th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/12/2010 12:00:00 AM	14		Permit Number 53252	5994718.18671	2110428.47346	37.7745306031117	-122.46174532831002	(37.7745306031117, -122.46174532831)
106440	106440	114968	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	200X MINERVA ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5994532.0	2089023.0	37.7157458289959	-122.460837724068	(37.7157458289959, -122.460837724068)
105615	105615	36540	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	3780 Folsom St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/18/1998 12:00:00 AM			Permit Number 768357	6008402.05844785	2097287.64414787	37.7392270883895	-122.41348043394899	(37.7392270883895, -122.413480433949)
103001	103001	114970	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	200X MINERVA ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5994532.0	2089023.0	37.7157458289959	-122.460837724068	(37.7157458289959, -122.460837724068)
96731	96731	187967	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1551 Jerrold Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6015595.88641	2096776.8147900002	37.73822575820571	-122.38857153857	(37.7382257582057, -122.38857153857)
93094	93094	101004	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	2801X Buchanan St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/10/2012 12:00:00 AM		3x3	Permit Number 769246	6003500.6	2117942.3	37.795663322696704	-122.43190190430201	(37.7956633226967, -122.431901904302)
85695	85695	117322	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	590 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/07/2016 12:00:00 AM	3		Permit Number 778502	5984157.3	2111842.1	37.77779841707871	-122.49838135403	(37.7777984170787, -122.49838135403)
85328	85328	121643	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	362 Teresita Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				2x4		5997955.0	2098188.0	37.741107118117	-122.449666371295	(37.741107118117, -122.449666371295)
82748	82748	117377	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	3783 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/08/2016 12:00:00 AM	3		Permit Number 775394	6003225.8	2102971.4	37.754541353189204	-122.43178331278	(37.7545413531892, -122.43178331278)
79874	79874	115385	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	375 Park St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/28/2016 12:00:00 AM	3		Permit Number 776680	6007256.8	2096298.8	37.7364475687434	-122.41737017570298	(37.7364475687434, -122.417370175703)
79336	79336	97887	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1030 Cabrillo St	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1		11/23/2011 12:00:00 AM	1		Permit Number 768379	5992385.79681	2110712.74988	37.775176609355896	-122.469834146271	(37.7751766093559, -122.469834146271)
77285	77285	221965	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	4001 20th St	5	: Yard 23	Tree 1	Private 1			4	Width 3ft		6003646.65326	2104187.9271299997	37.7579054957544	-122.43041468480699	(37.7579054957544, -122.430414684807)
76888	76888	189225	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	101 Pennsylvania Ave	28	Front Yard : Yard 7	Tree 1	Private 1			1			6014307.08555	2106575.78079	37.765060126048496	-122.393713274773	(37.7650601260485, -122.393713274773)
76641	76641	47443	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	651 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/14/2002 12:00:00 AM	6		Permit Number 45354	5982552.26402	2111341.47096	37.776329586414796	-122.503896547887	(37.7763295864148, -122.503896547887)
75734	75734	189233	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1919 22nd St	8	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6012396.53776	2103734.18422	37.7571513782439	-122.400121849061	(37.7571513782439, -122.400121849061)
75048	75048	189224	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	101 Pennsylvania Ave	15	Front Yard : Yard 7	Tree 1	Private 1			1			6014323.89166	2106455.06011	37.7647295874116	-122.393646696144	(37.7647295874116, -122.393646696144)
74352	74352	247232	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	760 Duboce Ave	4	: 4	Tree 1	Private 1			3	Width 3ft		6002013.60886	2108293.7767	37.7690865158689	-122.43635627624701	(37.7690865158689, -122.436356276247)
72338	72338	123393	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	667 03rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5995006.92654	2111007.28114	37.7761364727826	-122.460788484161	(37.7761364727826, -122.460788484161)
71517	71517	109072	Permitted Site 1	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1570 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/23/2015 12:00:00 AM	3	3x3	Permit Number 769406	5992498.7	2104770.7	37.758867846563795	-122.469011061686	(37.7588678465638, -122.469011061686)
70699	70699	203595	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	423 Flood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		5997934.90621	2094082.1225	37.729832211087	-122.44944008101999	(37.729832211087, -122.44944008102)
70236	70236	187966	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	211 Terry A Francois Blvd	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 5ft		6015666.2407	2110622.1949	37.7762461247865	-122.38929483449499	(37.7762461247865, -122.389294834495)
70121	70121	221955	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	271 Bemis St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 4ft		6002975.66032	2096224.1614599999	37.7360008273625	-122.43216654255801	(37.7360008273625, -122.432166542558)
69497	69497	221966	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	190 Storrie St	7	Front Yard : Yard 7	Tree 1	Private 1			2	Width 3ft		6000752.80061	2105288.0619099997	37.7607618468996	-122.44050172097401	(37.7607618468996, -122.440501720974)
69004	69004	175219	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	100 Morse St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 1ft		6000840.49126	2087951.89335	37.7131657752649	-122.43895601391199	(37.7131657752649, -122.438956013912)
68151	68151	203613	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	1762 14th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5991879.53156	2103437.46302	37.755171333717	-122.471055286375	(37.755171333717, -122.471055286375)
67352	67352	187964	Undocumented 2	Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274	211 Terry A Francois Blvd	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 5ft		6015658.44742	2110621.01823	37.776242461855205	-122.38932171163401	(37.7762424618552, -122.389321711634)

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