Street_Tree_List

Data source: data.sfgov.org

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

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
2513	2513	138183	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	1865 Buchanan St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/26/2012 12:00:00 AM	2	Width 0ft		6003936.4381	2114774.6580000003	37.7869904804487	-122.43016773530199	(37.7869904804487, -122.430167735302)
2541	2541	138182	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	1865 Buchanan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/26/2012 12:00:00 AM	2	Width 0ft		6003933.6106	2114790.6807	37.7870343146011	-122.43017866131201	(37.7870343146011, -122.430178661312)
2544	2544	138181	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	1865 Buchanan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/26/2012 12:00:00 AM	2	Width 0ft		6003932.1968	2114801.9909	37.7870652894849	-122.43018435992599	(37.7870652894849, -122.430184359926)
2550	2550	138186	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	1865 Buchanan St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	Width 0ft		6003941.622	2114719.9923	37.786840675810396	-122.43014589889499	(37.7868406758104, -122.430145898895)
5466	5466	21688	Permitted Site 1	Prunus serrulata :: Ornamental Cherry 35	1881 Sutter St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/19/1992 12:00:00 AM	2	4x4		6003696.9634	2114537.7544	37.7863264365495	-122.430979349218	(37.7863264365495, -122.430979349218)
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)
23661	23661	142764	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	400 FILBERT ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6010752.149	2120007.2027	37.801741456909596	-122.40695573845899	(37.8017414569096, -122.406955738459)
24060	24060	182205	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1651 26th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5988079.8655	2104054.0379	37.756643783163206	-122.484240699303	(37.7566437831632, -122.484240699303)
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)
24995	24995	181628	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1290 26th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5988037.8386	2106538.091	37.7634618698416	-122.48456824258498	(37.7634618698416, -122.484568242585)
25020	25020	182555	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2535 Judah St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986616.8854	2105696.0047	37.761066882292	-122.489420874881	(37.761066882292, -122.489420874881)
25201	25201	183343	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1220 41st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5983371.791	2106830.4783	37.7639918518381	-122.500727966306	(37.7639918518381, -122.500727966306)
25957	25957	247414	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	971 Page St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6001933.8006	2109433.5045	37.772211390909	-122.436713922993	(37.772211390909, -122.436713922993)
26050	26050	110340	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	564 Grove St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	4x4		6005097.2691	2111307.8756	37.7775372317236	-122.42590465122801	(37.7775372317236, -122.425904651228)
27485	27485	139129	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1580 WEBSTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6003642.6576	2114125.3602	37.785191028716795	-122.431137787396	(37.7851910287168, -122.431137787396)
27579	27579	237973	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	47 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6005397.275719999	2103411.57149	37.7558728147995	-122.42430507393601	(37.7558728147995, -122.424305073936)
28653	28653	140315	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2112 HAYES ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5997699.8421	2109926.1659	37.7733225841329	-122.45139501771901	(37.7733225841329, -122.451395017719)
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)
30442	30442	142001	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	762 FULTON ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004249.2696	2111539.4607	37.7781251474871	-122.42885467932301	(37.7781251474871, -122.428854679323)
31626	31626	106986	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	1737-1795 Post St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/01/2012 12:00:00 AM	2			6003814.6942	2114193.6153	37.7853881873399	-122.430547466156	(37.7853881873399, -122.430547466156)
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)
36214	36214	139413	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1500 GEARY BLVD	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004104.3504	2114027.1131	37.7849474186562	-122.429533464104	(37.7849474186562, -122.429533464104)
37082	37082	182550	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1408 31st Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986517.6568	2105641.9803	37.760912753017394	-122.48976008582899	(37.7609127530174, -122.489760085829)
37893	37893	138796	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1821 Broderick St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6000490.0431	2114976.5028	37.7873488929161	-122.44210594501499	(37.7873488929161, -122.442105945015)
38266	38266	214432	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1493 06th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5994264.26348	2105375.95517	37.7606315737945	-122.462948880198	(37.7606315737945, -122.462948880198)
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)
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)
41047	41047	139143	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1500 GEARY BLVD	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004425.4721	2114070.1832	37.7850838549959	-122.428425556733	(37.7850838549959, -122.428425556733)
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)
42824	42824	139130	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1580 WEBSTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6003638.5353	2114149.4067	37.7852568207566	-122.43115376623501	(37.7852568207566, -122.431153766235)
43762	43762	137653	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	822 LYON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6000014.8214	2111796.2307	37.7785895928112	-122.44352156987499	(37.7785895928112, -122.443521569875)
43907	43907	139147	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1500 GEARY BLVD	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004351.7938	2114062.4276	37.785058390527794	-122.428679907469	(37.7850583905278, -122.428679907469)
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)
44471	44471	182556	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2535 Judah St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986624.9706	2105696.7397	37.7610693723866	-122.48939296609501	(37.7610693723866, -122.489392966095)
45174	45174	184179	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1607 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5981558.7987	2104123.9871	37.7564539963073	-122.50679770031401	(37.7564539963073, -122.506797700314)
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)
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)
49526	49526	244925	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	223 Lily St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6005441.8933	2110105.3671	37.77425490559	-122.424626917474	(37.77425490559, -122.424626917474)
49823	49823	140314	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2112 HAYES ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5997724.0097	2109929.7362	37.7733337710941	-122.451311676612	(37.7733337710941, -122.451311676612)
50827	50827	247304	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	247 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6002738.4372	2109472.2087	37.772363358196394	-122.433933385595	(37.7723633581964, -122.433933385595)
51079	51079	182554	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	2535 Judah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986607.6975	2105696.3722	37.7610673549786	-122.489452678447	(37.7610673549786, -122.489452678447)
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)
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)
52419	52419	139419	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1675 POST ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004207.4112	2114251.7374	37.785570015468295	-122.42919292902201	(37.7855700154683, -122.429192929022)
52490	52490	246224	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1382 Masonic Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5999585.4723	2107870.9	37.767787136682294	-122.444724628037	(37.7677871366823, -122.444724628037)
52851	52851	142766	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	730 LARKIN ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6007514.5827	2113866.0765	37.7846977477095	-122.417723705816	(37.7846977477095, -122.417723705816)
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)
54244	54244	196406	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1021 Minnesota St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		6015301.01099	2103753.62638	37.7573662793475	-122.390078334671	(37.7573662793475, -122.390078334671)
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)
55286	55286	186809	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1200 Sunset Blvd	118	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984810.136	2106955.7691	37.7644202036906	-122.495762474243	(37.7644202036906, -122.495762474243)
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)
56529	56529	244325	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	463 Fillmore St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6003635.8441	2109959.3175	37.773751725465296	-122.430863941782	(37.7737517254653, -122.430863941782)
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)
59335	59335	139409	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1500 GEARY BLVD	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004207.1311	2114038.5263	37.7849845753314	-122.42917868992501	(37.7849845753314, -122.429178689925)
60303	60303	244983	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	299 Rose St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6005200.9141	2109719.1317	37.7731807843789	-122.425433016756	(37.7731807843789, -122.425433016756)
60558	60558	72752	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1542 26th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/01/1999 12:00:00 AM	2			5988097.7754	2104798.077	37.758687755802995	-122.484233325891	(37.758687755803, -122.484233325891)
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)
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)
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)
62539	62539	183257	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1343 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5981497.12	2105917.3408	37.7613744008584	-122.50714403834999	(37.7613744008584, -122.50714403835)
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)
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)
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)
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)
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)
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)
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)
65283	65283	139134	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1825 POST ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6003440.8714	2114149.8668	37.7852468810092	-122.43183765526001	(37.7852468810092, -122.43183765526)
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)
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)
66712	66712	137904	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1715 OCTAVIA ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004837.4134	2115278.925	37.7884260599365	-122.427086493089	(37.7884260599365, -122.427086493089)
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)
68183	68183	186811	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1200 Sunset Blvd	116	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984818.3107	2106920.8907	37.7643249161453	-122.495731627712	(37.7643249161453, -122.495731627712)
68270	68270	140310	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	155 COLE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5997792.3931	2109979.17	37.7734734188761	-122.45107869561501	(37.7734734188761, -122.451078695615)
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)
68892	68892	248602	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	462 Frederick St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5997486.7154	2107468.2888	37.7665616787282	-122.451954890142	(37.7665616787282, -122.451954890142)
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)
69173	69173	247371	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	485 Scott St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6002156.5991	2110137.258	37.774156382291295	-122.435993611299	(37.7741563822913, -122.435993611299)
69243	69243	244108	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1950 Page St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5997159.4208	2108812.5222	37.7702338463195	-122.453183989334	(37.7702338463195, -122.453183989334)
70069	70069	118023	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	455 37th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5984366.09559	2112727.46699	37.780241619998	-122.49772445801202	(37.780241619998, -122.497724458012)
70764	70764	143340	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1796 UNION ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004433.9519	2118779.1956	37.798014090515	-122.42873202906	(37.798014090515, -122.42873202906)
71583	71583	196423	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	5 Langton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6009782.26955	2111161.68642	37.777399481947796	-122.409687278471	(37.7773994819478, -122.409687278471)
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)
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)
74048	74048	182548	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1408 31st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5986518.7594	2105601.9213	37.760802826429796	-122.489753326371	(37.7608028264298, -122.489753326371)
74536	74536	196375	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	135 Shipley St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6012200.498790001	2112422.5734200003	37.7809968015951	-122.401410413864	(37.7809968015951, -122.401410413864)
75178	75178	141139	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1915 Geary Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6002239.2415	2113631.2046	37.7837545758984	-122.43595779441002	(37.7837545758984, -122.43595779441)
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)
75849	75849	135904	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1488 Vallejo St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006436.02999	2118364.9643599996	37.7969898223834	-122.421774812465	(37.7969898223834, -122.421774812465)
75953	75953	182379	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1539 21st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5989606.4529	2104860.602	37.758947159826704	-122.47902026167401	(37.7589471598267, -122.479020261674)
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)
76990	76990	182137	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1499 24th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5988663.091	2105183.6812	37.759779419906	-122.482306481553	(37.759779419906, -122.482306481553)
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)
110833	110833	16607	DPW Maintained 3	Prunus serrulata :: Ornamental Cherry 35	107 Noe St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3X3		6002880.641859099	2107642.9841193003	37.7673488254303	-122.433310753696	(37.7673488254303, -122.433310753696)
118168	118168	135902	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	8 Marion Pl	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			6008341.98532	2119430.34352	37.8000223848775	-122.415255184482	(37.8000223848775, -122.415255184482)
123423	123423	114660	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1603 Laguna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6004469.8992	2114403.3025	37.786001031208	-122.428295602978	(37.786001031208, -122.428295602978)
130060	130060	138271	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1500 GEARY BLVD	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004488.6249	2114080.7087	37.785116328832295	-122.428207818239	(37.7851163288323, -122.428207818239)
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)
131500	131500	110341	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	564 Grove St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	4x4		6005076.8079	2111304.1554	37.777525860611796	-122.42597516851801	(37.7775258606118, -122.425975168518)
131732	131732	137957	Undocumented 2	Prunus serrulata :: Ornamental Cherry 35	1615 SUTTER ST	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004849.7424	2114694.4909	37.7868220473623	-122.427002194935	(37.7868220473623, -122.427002194935)

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