Street_Tree_List

Data source: data.sfgov.org

244 rows where DBH = 2 and qSpecies = 35 sorted by Location

Search:

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

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

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

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

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

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

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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location ▼
188289	188289	178905	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	320 Hanover St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5999575.27021	2086527.1037599999	37.7091815546459	-122.443226763913	(37.7091815546459, -122.443226763913)
58079	58079	178920	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	263 Flournoy St	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			5993797.37837	2086767.25523	37.7095097928145	-122.463213309645	(37.7095097928145, -122.463213309645)
66305	66305	54661	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	345 Peninsula Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/27/1972 12:00:00 AM	2		Permit Number 10485	6012308.35839	2086909.49761	37.71094938168571	-122.399245788885	(37.7109493816857, -122.399245788885)
170429	170429	178896	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	424 Blanken Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6012763.5947	2086999.9849599998	37.711223202768295	-122.397678716599	(37.7112232027683, -122.397678716599)
10559	10559	26794	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	186 Leland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/09/1999 12:00:00 AM	2	3x3		6010044.3489	2087538.0893	37.7125489295627	-122.407115057358	(37.7125489295627, -122.407115057358)
68678	68678	217554	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	258 Broad St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5994397.0077	2088113.6647	37.7132412415717	-122.461238438183	(37.7132412415717, -122.461238438183)
63894	63894	178877	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	812 Naples St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002023.11476	2088969.20619	37.71602630823671	-122.434941181287	(37.7160263082367, -122.434941181287)
132838	132838	178906	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	109 Delta St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009976.781880001	2089389.92306	37.7176299046612	-122.40747906690399	(37.7176299046612, -122.407479066904)
146368	146368	178879	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	683 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6002292.149780001	2089824.9266099997	37.718391198782	-122.434072405644	(37.718391198782, -122.434072405644)
29059	29059	214419	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	479 Ramsell St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 10ft		5992969.97647	2090349.4269700001	37.7192978763685	-122.466333093823	(37.7192978763685, -122.466333093823)
68046	68046	71314	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	530 Athens St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/26/2012 12:00:00 AM	2		Permit Number 769252	6003477.6405	2090266.5364299999	37.7196709718096	-122.43000614527399	(37.7196709718096, -122.430006145274)
55503	55503	178889	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	487 Vienna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6003437.2188	2090630.2109400001	37.720667252470996	-122.430171799494	(37.720667252471, -122.430171799494)
153169	153169	214417	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	182 Jules Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5994480.563080001	2091128.3543599998	37.7215236696771	-122.461168031889	(37.7215236696771, -122.461168031889)
138713	138713	178892	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	334 Paris St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002432.46703	2091647.79412	37.723404349001605	-122.43371759969901	(37.7234043490016, -122.433717599699)
157657	157657	178938	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	721 Excelsior Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004184.355719999	2091630.4786	37.7234560564279	-122.427660409419	(37.7234560564279, -122.427660409419)
53425	53425	214415	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	20 De Montfort Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995229.56815	2091906.8040099998	37.7237041820879	-122.458635267605	(37.7237041820879, -122.458635267605)
155831	155831	178936	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	275 Edinburgh St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003706.73664	2092066.2006299999	37.7246254242075	-122.429342507659	(37.7246254242075, -122.429342507659)
42734	42734	178927	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	169 Otsego Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000613.31177	2092308.08767	37.7251139719271	-122.440053391844	(37.7251139719271, -122.440053391844)
171275	171275	199981	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	1200x Shafter Ave	1	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6017028.9443	2092601.7798	37.7268412531355	-122.38332614590799	(37.7268412531355, -122.383326145908)
64489	64489	178947	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	33 Athens St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			6005285.02544	2093071.08332	37.727473839721206	-122.42395798417101	(37.7274738397212, -122.423957984171)
156664	156664	51809	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	1465 Van Dyke Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/12/2005 12:00:00 AM	2	3x3	Permit Number 48055	6015110.437000001	2092946.715	37.7276821641004	-122.389982519172	(37.7276821641004, -122.389982519172)
172828	172828	30770	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	1662 Wallace Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/24/2008 12:00:00 AM	2		Permit Number 51077	6014463.7744	2093152.8983	37.7282124168861	-122.39223247286101	(37.7282124168861, -122.392232472861)
44205	44205	178924	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	88 San Gabriel Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6000939.255030001	2093544.2007900001	37.7285266059143	-122.43901519111	(37.7285266059143, -122.43901519111)
64942	64942	178939	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	231 Craut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004063.80175	2093818.77342	37.72945780800921	-122.42823302485701	(37.7294578080092, -122.428233024857)
63020	63020	178940	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	231 Craut St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004061.97855	2093834.65882	37.729501322606	-122.428240459522	(37.729501322606, -122.428240459522)
60771	60771	178944	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	202 Ney St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004727.85531	2094036.3293599999	37.7300927194874	-122.425952806385	(37.7300927194874, -122.425952806385)
50603	50603	43244	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	148 Girard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/24/2009 12:00:00 AM	2	3x3	Permit Number 52907	6010526.7074	2094001.3390799998	37.7303226617554	-122.405902877341	(37.7303226617554, -122.405902877341)
157170	157170	178964	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	129 Girard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010537.280619999	2094115.27956	37.7306361096482	-122.40587434723	(37.7306361096482, -122.40587434723)
134091	134091	31134	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	154 Hearst Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/21/1995 12:00:00 AM	2		Permit Number 34849	6000371.52521	2094373.11197	37.730770284917895	-122.441037301429	(37.7307702849179, -122.441037301429)
136002	136002	96277	Significant Tree 6	Prunus serrulata :: Ornamental Cherry 35	55@ Alemany Trumbull St	5	Back Yard : Yard 13	Tree 1	Private 1			2			6003933.28624	2094328.99121	37.7308513660015	-122.428720586902	(37.7308513660015, -122.428720586902)
168767	168767	96276	Significant Tree 6	Prunus serrulata :: Ornamental Cherry 35	55@ Alemany Trumbull St	4	Back Yard : Yard 13	Tree 1	Private 1			2			6003946.78636	2094329.77315	37.730854277083104	-122.428673970523	(37.7308542770831, -122.428673970523)
67319	67319	214469	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	519 Mangels Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		5997971.240119999	2095245.6025	37.7330289295305	-122.44939826792499	(37.7330289295305, -122.449398267925)
38906	38906	237981	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	100 Rousseau St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6003493.73736	2095146.1048599998	37.7330700888164	-122.43029845283002	(37.7330700888164, -122.43029845283)
24350	24350	214468	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	623 Gennessee St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 10ft		5997445.526980001	2095470.2100900002	37.7336155617911	-122.451231980178	(37.7336155617911, -122.451231980178)
71704	71704	238004	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	569 Laidley St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6003031.46134	2095960.14105	37.735279051283705	-122.431954769317	(37.7352790512837, -122.431954769317)
188651	188651	185046	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2767 34th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985833.5409	2096575.126	37.7359776633696	-122.491458724203	(37.7359776633696, -122.491458724203)
188866	188866	238006	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	120 Surrey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6002226.03876	2096243.0070099998	37.7360100427193	-122.434759628851	(37.7360100427193, -122.434759628851)
52167	52167	214406	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	200x Terrace Dr	10	Median : Yard 3	Tree 1	DPW 2			2			5993802.78615	2096495.7432	37.736222176613104	-122.463900308969	(37.7362221766131, -122.463900308969)
66160	66160	214405	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	200x Terrace Dr	9	Median : Yard 3	Tree 1	DPW 2			2			5993807.85396	2096495.9519200001	37.73622304175571	-122.46388280274701	(37.7362230417557, -122.463882802747)
75493	75493	237987	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	114 Park St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005526.563490001	2096388.0227	37.736595053504296	-122.423358681381	(37.7365950535043, -122.423358681381)
177308	177308	237986	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	114 Park St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005505.73076	2096390.28542	37.7366000906246	-122.42343086995899	(37.7366000906246, -122.423430869959)
54862	54862	183412	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2350 Wawona St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5985653.7417	2097035.0769	37.7372300576086	-122.492114208587	(37.7372300576086, -122.492114208587)
153072	153072	183411	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2350 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5985672.7267	2097039.7501	37.737243998747	-122.49204891364201	(37.737243998747, -122.492048913642)
167724	167724	183420	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1210 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5989168.5817	2096994.6461	37.737323883205704	-122.479958976444	(37.7373238832057, -122.479958976444)
153200	153200	183419	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1206 Wawona St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5989183.8607	2096995.3104	37.73732659489539	-122.479906199072	(37.7373265948954, -122.479906199072)
183069	183069	237990	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	31 Highland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6005158.74512	2096696.1692	37.7374203883407	-122.424652302187	(37.7374203883407, -122.424652302187)
70235	70235	79414	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2635 37th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2009 12:00:00 AM	2	3x3	Permit Number 52810	5984897.7294	2097238.629	37.7377447344094	-122.49474305383	(37.7377447344094, -122.49474305383)
63440	63440	183376	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2651 24th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5988932.0896	2097296.9043	37.738140062837296	-122.480798751822	(37.7381400628373, -122.480798751822)
77365	77365	183602	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2647 24th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5988930.4288	2097323.4764	37.7382129263906	-122.48080643881	(37.7382129263906, -122.48080643881)
156144	156144	183594	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2635 24th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988927.7716	2097397.2142	37.738415236787	-122.48082102296999	(37.738415236787, -122.48082102297)
63868	63868	183586	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2618 26th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5988349.8428	2097449.4724	37.738525115109994	-122.482823024231	(37.73852511511, -122.482823024231)
32270	32270	183579	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2610 24th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5988968.1029	2097542.0935	37.7388153818785	-122.480692181856	(37.7388153818785, -122.480692181856)
146393	146393	81679	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	1942 Vicente St	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1	FUF 1	07/31/2009 12:00:00 AM	2	3x3	Permit Number 52863	5986874.2463	2097598.6809	37.738848836056	-122.487935819213	(37.738848836056, -122.487935819213)
168850	168850	92321	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2591 26th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/28/2009 12:00:00 AM	2	3x3	Permit Number 52754	5988296.7898	2097687.1554	37.739174643542796	-122.483023869558	(37.7391746435428, -122.483023869558)
136442	136442	92293	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2551 21st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/27/2009 12:00:00 AM	2	3x3	Permit Number 52738	5989840.1836	2097983.4983	37.7400780132426	-122.47770922434799	(37.7400780132426, -122.477709224348)
179446	179446	92292	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2551 21st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/27/2009 12:00:00 AM	2	3x3	Permit Number 52738	5989839.8453	2098004.8092	37.7401365078293	-122.47771195140801	(37.7401365078293, -122.477711951408)
57315	57315	92291	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2541 21st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/27/2009 12:00:00 AM	2	3x3	Permit Number 52737	5989837.8157	2098042.3571	37.7402394868641	-122.47772171282601	(37.7402394868641, -122.477721712826)
63491	63491	182127	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2636 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5987775.8815	2098311.0525	37.7408573756578	-122.484870670835	(37.7408573756578, -122.484870670835)
60519	60519	92488	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2432 Ulloa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/31/2009 12:00:00 AM	2	3x3	Permit Number 52859	5988420.575	2098331.0194	37.740949727843706	-122.482643050711	(37.7409497278437, -122.482643050711)
41505	41505	92486	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2416 Ulloa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/30/2009 12:00:00 AM	2	3x3	Permit Number 52857	5988503.8268	2098336.0957	37.7409685091415	-122.48235557195801	(37.7409685091415, -122.482355571958)
39866	39866	182572	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2212 Ulloa St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5989118.5154	2098355.8518	37.7410584915124	-122.48023167480301	(37.7410584915124, -122.480231674803)
172286	172286	182571	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2208 Ulloa St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5989133.5167	2098356.5835	37.7410613722493	-122.480179859895	(37.7410613722493, -122.480179859895)
135632	135632	183177	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2450 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5983968.3342	2098473.4815	37.741080860242896	-122.498047537544	(37.7410808602429, -122.498047537544)
60980	60980	70441	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2443 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/11/1994 12:00:00 AM	2			5982992.9824	2098498.3633	37.741091945342795	-122.501421735716	(37.7410919453428, -122.501421735716)
136125	136125	183176	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2446 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5983967.9959	2098507.985	37.7411755776416	-122.498051254673	(37.7411755776416, -122.498051254673)
167371	167371	182567	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2483 24th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5988893.0118	2098438.9759	37.74127362251029	-122.48101746001001	(37.7412736225103, -122.48101746001)
47048	47048	247783	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	274 30th St	2	: 4	Tree 1	Private 1			2	Width 3ft		6004785.28168	2098443.27058	37.7421964332069	-122.42606787825198	(37.7421964332069, -122.426067878252)
171254	171254	214398	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	201 Granville Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		5994265.55246	2098714.72698	37.742341611687294	-122.46246124889	(37.7423416116873, -122.46246124889)
173783	173783	214446	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	500 Magellan Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5993157.34712	2099454.9185599997	37.744310110719205	-122.46634683724	(37.7443101107192, -122.46634683724)
69989	69989	92394	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2290 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2009 12:00:00 AM	2	3x3	Permit Number 52799	5985787.8059	2099633.6824	37.7443729686632	-122.491841945332	(37.7443729686632, -122.491841945332)
137052	137052	92395	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2290 34th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2009 12:00:00 AM	2	3x3	Permit Number 52799	5985787.8059	2099646.4846	37.7444081200554	-122.491842887636	(37.7444081200554, -122.491842887636)
52716	52716	92396	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2290 34th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2009 12:00:00 AM	2	3x3	Permit Number 52799	5985787.3792	2099657.153	37.7444373876676	-122.491845148303	(37.7444373876676, -122.491845148303)
67347	67347	92397	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2290 34th Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2009 12:00:00 AM	2	3x3	Permit Number 52799	5985786.098999999	2099670.3819	37.7444736358369	-122.491850548624	(37.7444736358369, -122.491850548624)
57263	57263	65499	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	1520 Santiago St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/22/1995 12:00:00 AM	2		Permit Number 28383	5988131.2403	2099681.6905	37.7446414773793	-122.48374245837299	(37.7446414773793, -122.483742458373)
165087	165087	71211	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2267 25th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/22/1995 12:00:00 AM	2			5988532.3745	2099906.1549	37.7452811395366	-122.48237187504	(37.7452811395366, -122.48237187504)
180505	180505	79189	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2266 25th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		2			5988574.1949	2099905.7282	37.745282400553	-122.482227237552	(37.745282400553, -122.482227237552)
71684	71684	183874	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2253 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5987600.3776	2099940.7208	37.7453217895816	-122.485597059998	(37.7453217895816, -122.485597059998)
164468	164468	183845	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2237 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5987595.6835	2100038.0171	37.745588665836	-122.48562043042	(37.745588665836, -122.48562043042)
62988	62988	92393	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2223 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2009 12:00:00 AM	2	3x3	Permit Number 52798	5985729.7695	2100081.3311	37.745598698912204	-122.49207557319401	(37.7455986989122, -122.492075573194)
136120	136120	183843	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2242 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988571.2077	2100055.5134	37.745693497424796	-122.48224853862699	(37.7456934974248, -122.482248538627)
180063	180063	83723	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2215 33rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		2			5986042.1421	2100161.1312	37.7458360633129	-122.491001322638	(37.7458360633129, -122.491001322638)
151451	151451	95446	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2205 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/01/2011 12:00:00 AM	2	3x3	Permit Number 767308	5985726.3556	2100168.8125	37.7458386996409	-122.49209381774901	(37.7458386996409, -122.492093817749)
136915	136915	95445	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2201 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/01/2011 12:00:00 AM	2	3x3	Permit Number 767307	5985726.3556	2100198.6842	37.7459207192562	-122.492096016775	(37.7459207192562, -122.492096016775)
136725	136725	92333	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2182 31st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/28/2009 12:00:00 AM	2	3x3	Permit Number 52765	5986695.3951	2100425.9019	37.7466011963621	-122.488761954977	(37.7466011963621, -122.488761954977)
76643	76643	184445	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2143 42nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5983233.2456	2100550.728	37.746741282577894	-122.500742738194	(37.7467412825779, -122.500742738194)
186044	186044	185736	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2119 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5987568.4406	2100856.1259	37.7478333870661	-122.485774665371	(37.7478333870661, -122.485774665371)
48917	48917	238000	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	4222 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002358.11456	2100643.50025	37.7481002693112	-122.43461754857799	(37.7481002693112, -122.434617548578)
133665	133665	183938	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1813 Quintara St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5987797.5686	2100976.6866	37.7481777632633	-122.48499120550801	(37.7481777632633, -122.484991205508)
130753	130753	183940	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1809 Quintara St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5987813.0153	2100978.3126	37.7481831275412	-122.484937911261	(37.7481831275412, -122.484937911261)
69155	69155	214404	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	66 Sotelo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993883.93649	2101380.3383299997	37.7496387233569	-122.46397420265801	(37.7496387233569, -122.463974202658)
147047	147047	92304	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	2001 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/27/2009 12:00:00 AM	2	3x3	Permit Number 52751	5989091.9697	2101683.9526	37.7501950388707	-122.480567026206	(37.7501950388707, -122.480567026206)
51937	51937	185812	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1915 Pacheco St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5989026.5354	2101700.9269	37.7502378427058	-122.480794541981	(37.7502378427058, -122.480794541981)
60645	60645	185813	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1913 Pacheco St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5989045.9651	2101702.9368	37.750244490673	-122.480727500746	(37.750244490673, -122.480727500746)
2000	2000	237999	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	4302 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/27/2012 12:00:00 AM	2	Width 4ft	Permit Number 769743	6001218.46057	2101752.36044	37.7510801711245	-122.438637864349	(37.7510801711245, -122.438637864349)
27593	27593	82193	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	1941 23rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/29/2007 12:00:00 AM	2	3x3	Permit Number 49858	5989080.382	2102109.5053	37.7513628201965	-122.48063824575	(37.7513628201965, -122.48063824575)
163621	163621	82790	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	1941 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/29/2007 12:00:00 AM	2	3x3	Permit Number 49858	5989079.3347	2102124.6913	37.7514044560494	-122.48064297897699	(37.7514044560494, -122.480642978977)
26520	26520	45041	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	1874 25th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/30/2001 12:00:00 AM	2		Permit Number 43928	5988487.5162	2102559.2618	37.752563256460206	-122.48272137554702	(37.7525632564602, -122.482721375547)
66440	66440	182858	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1826 32nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986304.0542	2102796.2301	37.7530866298604	-122.49028948878201	(37.7530866298604, -122.490289488782)
135868	135868	51044	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	1842 20th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2004 12:00:00 AM	2		Permit Number 47517	5990031.9781	2102811.2855	37.7533449836368	-122.477398836512	(37.7533449836368, -122.477398836512)
106345	106345	39515	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	62 Vicksburg St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/28/1998 12:00:00 AM	2		Permit Number 40966	6004070.08669275	2102696.50176505	37.75383437046089	-122.428843949963	(37.7538343704609, -122.428843949963)

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