Street_Tree_List

Data source: data.sfgov.org

120 rows where SiteOrder = 2 and qSpecies = 70

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
267	267	175151	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	285 Santa Rosa Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/03/2017 12:00:00 AM	3	Width 3ft	Permit Number 779495	6000727.04119	2093604.3094	37.728679573387495	-122.43975313162399	(37.7286795733875, -122.439753131624)
8590	8590	102757	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2807 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	3x3		6002051.958459999	2117801.7316900003	37.795195129895895	-122.436904386043	(37.7951951298959, -122.436904386043)
10269	10269	91500	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	125 Mason St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/13/2017 12:00:00 AM	3	3x3	Permit Number 52121	6009901.41754	2113830.53604	37.784734187987	-122.40946350553999	(37.784734187987, -122.40946350554)
22656	22656	17785	DPW Maintained 3	Afrocarpus gracilior :: Fern Pine 70	1798X Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6005398.04469	2115519.90556	37.7891194189645	-122.42516394985701	(37.7891194189645, -122.425163949857)
22660	22660	28058	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	399X Fern St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/28/2003 12:00:00 AM	7	3X3		6005467.0390099995	2114965.36006	37.7876006726807	-122.424885768876	(37.7876006726807, -122.424885768876)
22801	22801	7123	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	300X Fern St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/02/1990 12:00:00 AM	9	3x3		6005797.9204	2115035.94869	37.7878131752727	-122.42374600408701	(37.7878131752727, -122.423746004087)
24159	24159	33290	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	166 Sproule Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/14/1996 12:00:00 AM	8		Permit Number 37451	6009219.4283	2116994.47406	37.7933833601996	-122.41204664625499	(37.7933833601996, -122.412046646255)
26400	26400	203471	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	410 Faxon Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 1ft		5994790.95036	2091337.27547	37.7221151744519	-122.460110243003	(37.7221151744519, -122.460110243003)
27556	27556	220598	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1 Sycamore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006787.43083	2105854.6831099996	37.7626594317184	-122.41967079188801	(37.7626594317184, -122.419670791888)
30036	30036	92979	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	147 Mason St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/04/2010 12:00:00 AM	5		Permit Number 53131	6009891.19153	2113906.4761	37.78494212831	-122.40950424575001	(37.78494212831, -122.40950424575)
30833	30833	220633	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	18 Kronquist Ct	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 1ft		6002213.10405	2100169.21088	37.7467897493647	-122.435085071929	(37.7467897493647, -122.435085071929)
31581	31581	70151	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	846 Geary St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/08/1993 12:00:00 AM	7			6007647.41454	2114440.4952	37.786282435643	-122.41730487074699	(37.786282435643, -122.417304870747)
33494	33494	175166	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	218 Congdon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6004672.7463	2094000.25869	37.7299905627997	-122.426140758388	(37.7299905627997, -122.426140758388)
34959	34959	104356	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	1671 Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/25/2013 12:00:00 AM	3		Permit Number 770626	6004967.00865	2119154.82266	37.7990756208885	-122.426914264396	(37.7990756208885, -122.426914264396)
35258	35258	120266	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	100 24th Ave	2	Side Yard : Yard 17	Tree 1	Private 1			5			5988365.77159	2115120.59325	37.78704611790379	-122.48406345051399	(37.7870461179038, -122.484063450514)
36428	36428	203476	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2357 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5991292.10233	2099373.67062	37.743979223173106	-122.472790471621	(37.7439792231731, -122.472790471621)
39363	39363	249821	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	281 Kearny St	2	Front Yard : Yard 7	Tree 1	Private 1			14	Width 0ft		6010901.8759699995	2120623.17353	37.8034411387496	-122.406481040676	(37.8034411387496, -122.406481040676)
39883	39883	203492	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	23 Melrose Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 10ft		5999946.35958	2095464.23555	37.7337420298607	-122.442585473564	(37.7337420298607, -122.442585473564)
40929	40929	249550	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	380 Fern St	2	: 4	Tree 1	Private 1			7	Width 2ft		6005507.2276099995	2114996.10092	37.7876873493358	-122.424748911848	(37.7876873493358, -122.424748911848)
41144	41144	175153	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	783 Cayuga Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 10ft		6001323.552619999	2092431.0494099997	37.7254920046417	-122.43760697060101	(37.7254920046417, -122.437606970601)
41677	41677	249947	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	305 Filbert St	2	Front Yard : Yard 7	Tree 1	Private 1			7	Width 0ft		6011342.9125	2120054.18632	37.8019035022036	-122.40491472295	(37.8019035022036, -122.40491472295)
43229	43229	220599	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	714 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010100.45141	2104938.60727	37.7603301624296	-122.408147577953	(37.7603301624296, -122.408147577953)
43774	43774	203480	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	90 Manor Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5993659.30191	2093497.00296	37.7279801058879	-122.464178756148	(37.7279801058879, -122.464178756148)
43884	43884	189176	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1 Anthony St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 5ft		6012661.31608	2115304.6540900003	37.7889360247231	-122.40001866534901	(37.7889360247231, -122.400018665349)
44032	44032	220657	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	505 Tompkins Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008343.07833	2096482.99595	37.737014388512996	-122.41362746465799	(37.737014388513, -122.413627464658)
45739	45739	249986	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	228 Filbert St	2	Front Yard : Yard 7	Tree 1	Private 1			4	Width 0ft		6011589.33259	2120106.08083	37.802059763014	-122.404065643309	(37.802059763014, -122.404065643309)
46216	46216	189159	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	109 Kissling St	2	: 4	Tree 1	Private 1			2	Width 3ft		6008170.01676	2109410.076	37.7724994960939	-122.415140588393	(37.7724994960939, -122.415140588393)
47152	47152	125475	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	150 Sproule Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6009249.92549	2116801.2629400003	37.7928545606515	-122.41192746357599	(37.7928545606515, -122.411927463576)
47594	47594	220635	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	628 Chenery St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6002826.10631	2095715.4099400002	37.7345954316319	-122.432647280541	(37.7345954316319, -122.432647280541)
47631	47631	221761	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	4441 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001542.762080001	2104063.39418	37.75744415704379	-122.437681892224	(37.7574441570438, -122.437681892224)
49294	49294	221759	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	4515 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001360.92884	2104054.05926	37.7574081850601	-122.438310074049	(37.7574081850601, -122.438310074049)
51784	51784	125483	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1471 Washington St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6007681.40554	2117137.6606799997	37.793690101870205	-122.417378482047	(37.7936901018702, -122.417378482047)
55076	55076	125501	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1115 Filbert St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		6007553.747280001	2119514.62481	37.8002094690578	-122.417988773678	(37.8002094690578, -122.417988773678)
55188	55188	203461	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	409 Hearst Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5998653.32929	2094365.51359	37.7306514071182	-122.446976805539	(37.7306514071182, -122.446976805539)
55787	55787	189171	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	672 Missouri St	2	: 4	Tree 1	Private 1			4	Width 1ft		6013547.271380001	2103937.2716200002	37.7577731065529	-122.396156373043	(37.7577731065529, -122.396156373043)
56962	56962	220618	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	237 Murray St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 10ft		6005720.296519999	2095375.55283	37.7338259689755	-122.422616936749	(37.7338259689755, -122.422616936749)
60506	60506	203484	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	101 Los Palmos Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5998423.23469	2096036.13552	37.7352253905456	-122.447892505138	(37.7352253905456, -122.447892505138)
63824	63824	220654	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	580 Ogden Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008103.73158	2096079.3451	37.735892608341	-122.414426443037	(37.735892608341, -122.414426443037)
64600	64600	203500	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	77 Staples Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5999471.94159	2093749.5809	37.729006934723	-122.444102506626	(37.729006934723, -122.444102506626)
67476	67476	99401	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	2200X Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/09/2012 12:00:00 AM	12	3x3	Permit Number 768917	6014766.6	2092880.6	37.7274815503989	-122.391166558925	(37.7274815503989, -122.391166558925)
70578	70578	70577	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	201 11th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/07/2008 12:00:00 AM	3	4x4	Permit Number 50063	5992415.28352	2114057.951	37.7843633240791	-122.469975767472	(37.7843633240791, -122.469975767472)
70754	70754	249984	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	226 Filbert St	2	Front Yard : Yard 7	Tree 1	Private 1			10	Width 0ft		6011604.5053	2120111.99388	37.8020768465317	-122.404013554575	(37.8020768465317, -122.404013554575)
73300	73300	125461	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1845 Green St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 4ft		6004195.45414	2118342.0241799997	37.7968002290978	-122.42952610606399	(37.7968002290978, -122.429526106064)
76694	76694	125491	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1207 Chestnut St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6005994.09185	2120329.4714599997	37.8023589278732	-122.42344375814599	(37.8023589278732, -122.423443758146)
77178	77178	220638	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	222 Parnassus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 7ft		5997115.15152	2106725.56313	37.7645010544003	-122.453186433611	(37.7645010544003, -122.453186433611)
77902	77902	96256	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	192@ Congdon Ney St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/18/2011 12:00:00 AM		3x3	Permit Number 58762	6004645.0	2094034.0	37.73008164064579	-122.42623908205	(37.7300816406458, -122.42623908205)
84013	84013	92416	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	1507 37th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2009 12:00:00 AM		3x3	Permit Number 52808	5984617.9	2104898.8	37.758761083263	-122.49627557459499	(37.758761083263, -122.496275574595)
87495	87495	51467	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	450X Tompkins Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/20/2004 12:00:00 AM			Permit Number 47780	6008359.74436357	2096491.87705801	37.7370397099418	-122.41357047046199	(37.7370397099418, -122.413570470462)
89567	89567	33006	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	255 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/03/2002 12:00:00 AM			Permit Number 45106	6012763.62735273	2113645.89457982	37.7843871619555	-122.399548173715	(37.7843871619555, -122.399548173715)
92107	92107	30608	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	40 12th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/30/1995 12:00:00 AM			Permit Number 34571	6006862.94085785	2109917.12606637	37.773818193258	-122.41969788695299	(37.773818193258, -122.419697886953)
92549	92549	27666	DPW Maintained 3	Afrocarpus gracilior :: Fern Pine 70	300 Austin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6005803.78776	2115397.87528	37.7888072668978	-122.42375144816299	(37.7888072668978, -122.423751448163)
92731	92731	32134	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	842 Washington St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/15/1995 12:00:00 AM			Permit Number 35494	6010631.11006318	2117599.53652258	37.795123819025704	-122.407204773258	(37.7951238190257, -122.407204773258)
93613	93613	30702	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	361 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/31/1995 12:00:00 AM			Permit Number 34614	6005271.42565012	2110238.90565505	37.7746119412537	-122.425226100731	(37.7746119412537, -122.425226100731)
94446	94446	27669	DPW Maintained 3	Afrocarpus gracilior :: Fern Pine 70	310 Austin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6005758.15165	2115391.49838	37.7887871812497	-122.423908889223	(37.7887871812497, -122.423908889223)
94467	94467	42095	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	45 Stoneman St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/21/2000 12:00:00 AM			Permit Number 42400	6008105.01217426	2099392.98476779	37.744991204982	-122.414656438734	(37.744991204982, -122.414656438734)
95859	95859	42786	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	269 Lily St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/26/2000 12:00:00 AM			Permit Number 42753	6005259.26650222	2110063.08095744	37.774128482391205	-122.425255647592	(37.7741284823912, -122.425255647592)
96760	96760	32142	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	163X Hickory St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/15/1995 12:00:00 AM			Permit Number 35497	6006158.88889094	2110709.34290145	37.775953744351895	-122.422189614353	(37.7759537443519, -122.422189614353)
99946	99946	38942	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	157 Lunado Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/03/1998 12:00:00 AM			Permit Number 40741	5991578.31713669	2092588.28918632	37.72536484280229	-122.471306529261	(37.7253648428023, -122.471306529261)
100078	100078	94131	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	101 Montcalm St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/11/2010 12:00:00 AM		3x3	Permit Number 53497	6010479.0	2099916.0	37.746560384348705	-122.406484424587	(37.7465603843487, -122.406484424587)
100438	100438	97940	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	491 Greenwich St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6010516.0	2120277.0	37.802469036850205	-122.407791962119	(37.8024690368502, -122.407791962119)
104718	104718	32136	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	858 Washington St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/15/1995 12:00:00 AM			Permit Number 35495	6010580.68586277	2117592.53204935	37.7951017643418	-122.40737875552	(37.7951017643418, -122.40737875552)
108145	108145	33367	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	89 Manor Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/14/1996 12:00:00 AM			Permit Number 37498	5993623.03189123	2093524.69495183	37.728054050760896	-122.464306151281	(37.7280540507609, -122.464306151281)
112653	112653	31949	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	1677 Bush St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/26/1995 12:00:00 AM			Permit Number 35359	6005487.56868066	2115128.64858681	37.7880501818667	-122.424826361466	(37.7880501818667, -122.424826361466)
113313	113313	38937	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	144 Lunado Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/02/1998 12:00:00 AM			Permit Number 40738	5991631.60246352	2092606.92529954	37.725419095146606	-122.471123685701	(37.7254190951466, -122.471123685701)
115405	115405	24518	DPW Maintained 3	Afrocarpus gracilior :: Fern Pine 70	365 Austin St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6005518.5465766	2115307.531712	37.788543099973396	-122.424731913891	(37.7885430999734, -122.424731913891)
118540	118540	33368	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	90 Manor Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/14/1996 12:00:00 AM			Permit Number 37499	5993674.94282707	2093510.9416498002	37.7280192795988	-122.464125696941	(37.7280192795988, -122.464125696941)
119097	119097	8435	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	1730 Geary Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/28/1997 12:00:00 AM	13	3X3		6003010.73492	2113853.74303	37.784409407274	-122.433304626878	(37.784409407274, -122.433304626878)
121616	121616	45290	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	600 Gates St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/12/2001 12:00:00 AM			Permit Number 44129	6008139.59757362	2096081.06824752	37.7358993545079	-122.414302561575	(37.7358993545079, -122.414302561575)
121657	121657	92783	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	527 Bryant St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/15/2009 12:00:00 AM		3x3	Permit Number 52999	6013573.0	2112256.0	37.780615911778604	-122.396650538079	(37.7806159117786, -122.396650538079)
126893	126893	203457	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	89 Manor Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		5993628.67358	2093513.96157	37.7280249047113	-122.464285869009	(37.7280249047113, -122.464285869009)
127638	127638	34191	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	2701 Lake St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/14/1997 12:00:00 AM			Permit Number 38079	5987120.3446635	2114449.05125045	37.785129669395104	-122.488322923297	(37.7851296693951, -122.488322923297)
130796	130796	248093	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	8 Brewster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6010450.13728	2099873.13293	37.746441065995604	-122.40658120898199	(37.7464410659956, -122.406581208982)
132705	132705	125527	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	29 Miller Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6010066.41664	2116970.44466	37.7933648665474	-122.409114296086	(37.7933648665474, -122.409114296086)
133342	133342	220645	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	816 Crescent Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008216.9228300005	2095637.5252200002	37.7346858251821	-122.414003848906	(37.7346858251821, -122.414003848906)
136527	136527	125466	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1177 California St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 4ft		6008683.65979	2116266.52541	37.7913545166392	-122.413848933479	(37.7913545166392, -122.413848933479)
136884	136884	125446	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	3615 Buchanan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003103.6015800005	2120772.6345599997	37.8034121715947	-122.433477951057	(37.8034121715947, -122.433477951057)
137603	137603	117918	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	731 41st Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		5983185.43658	2110793.02592	37.774860926834606	-122.501665678898	(37.7748609268346, -122.501665678898)
138603	138603	51460	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	816 Crescent Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/20/2004 12:00:00 AM			Permit Number 47775	6008159.08468648	2095638.69714743	37.7346857944121	-122.414203898561	(37.7346857944121, -122.414203898561)
139087	139087	24505	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	360X Fern St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3X3		6005509.85054	2114996.70292	37.787689150419	-122.424739879851	(37.787689150419, -122.424739879851)
140160	140160	17102	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	1711 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		5998685.53291	2109300.56616	37.771661239802	-122.44794034143601	(37.771661239802, -122.447940341436)
142093	142093	49037	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	1190 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/07/2003 12:00:00 AM	10		Permit Number 46211	6003822.41781324	2101344.45239948	37.75010793907921	-122.429604025448	(37.7501079390792, -122.429604025448)
143853	143853	32707	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	1005 Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/29/1996 12:00:00 AM			Permit Number 37107	6007675.42771265	2115829.29953352	37.7900973284958	-122.41730640574801	(37.7900973284958, -122.417306405748)
143899	143899	96060	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	101 Montcalm St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/03/2011 12:00:00 AM		3x3	Permit Number 767687	6010479.0	2099916.0	37.746560384348705	-122.406484424587	(37.7465603843487, -122.406484424587)
145080	145080	33365	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	65 Manor Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/14/1996 12:00:00 AM			Permit Number 37497	5993537.09779252	2093371.5770822	37.7276286729381	-122.46459211219299	(37.7276286729381, -122.464592112193)
147861	147861	220661	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	40 Leese St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005456.84136	2096363.09768	37.7365226796806	-122.423597969391	(37.7365226796806, -122.423597969391)
148997	148997	125441	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	3517 Divisadero St	2	: 4	Tree 1	Private 1			4	Width 2ft		6000221.62171	2120363.5906700003	37.8021251149445	-122.443421726125	(37.8021251149445, -122.443421726125)
150229	150229	125458	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2371 Broadway	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6002284.26434	2117368.32549	37.794018309436396	-122.436069543591	(37.7940183094364, -122.436069543591)
151194	151194	220621	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	714 Duncan St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6001868.87894	2099747.43156	37.745612090735506	-122.43624518748999	(37.7456120907355, -122.43624518749)
151252	151252	125507	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	7 Fallon Pl	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6008925.22265	2118571.08085	37.7976958234636	-122.41317615966801	(37.7976958234636, -122.413176159668)
151339	151339	189154	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2 Shipley St	2	: 4	Tree 1	Private 1			7	Width 3ft		6012314.00092	2112536.43535	37.781315772258104	-122.401025754031	(37.7813157722581, -122.401025754031)
153001	153001	92753	Permitted Site 1	Afrocarpus gracilior :: Fern Pine 70	3356 Baker St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/07/2009 12:00:00 AM	4	3x3	Permit Number 52980	5999299.39389	2120397.7877700003	37.802166375831106	-122.446615526285	(37.8021663758311, -122.446615526285)
154615	154615	249823	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	285 Kearny St	2	Front Yard : Yard 7	Tree 1	Private 1			14	Width 0ft		6010881.14413	2120640.5408	37.8034876651725	-122.406554008974	(37.8034876651725, -122.406554008974)
155006	155006	221772	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	71 Miguel St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6003850.95701	2097297.26656	37.7389969178725	-122.429216785123	(37.7389969178725, -122.429216785123)
156031	156031	220594	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1 14th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6008571.39642	2107977.23283	37.768587792328894	-122.413650808341	(37.7685877923289, -122.413650808341)
157223	157223	123467	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	708 02nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5995387.69315	2110690.84094	37.775289512367	-122.45944839629601	(37.775289512367, -122.459448396296)
157432	157432	220650	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	45 Stoneman St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		6008081.1542	2099392.86215	37.744989527842996	-122.41473892687999	(37.744989527843, -122.41473892688)
159347	159347	220623	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	58 Fountain St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6000335.70641	2101336.8621	37.7498890559574	-122.44166069529699	(37.7498890559574, -122.441660695297)
160402	160402	203463	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	112 Baden St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 6ft		6000775.43585	2094454.02267	37.731015444602896	-122.43964672024099	(37.7310154446029, -122.439646720241)
161472	161472	203494	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	363 Joost Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5999675.09138	2094930.6164	37.732261369848	-122.443485006944	(37.732261369848, -122.443485006944)
161599	161599	125530	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	11 Miller Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010077.8438099995	2116891.68093	37.7931492405824	-122.40906919691002	(37.7931492405824, -122.40906919691)

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