Street_Tree_List

Data source: data.sfgov.org

3,645 rows where qSpecies = 41 sorted by TreeID 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, qSiteInfo, qCaretaker, qCareAssistant

Link	rowid	TreeID ▲	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
4701	4701	253665	Undocumented 2	Olea europaea :: Olive Tree 41	715 Buena Vista Ave	3	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		5999814.0	2107879.0	37.767822415683796	-122.443934762725	(37.7678224156838, -122.443934762725)
4707	4707	253664	Undocumented 2	Olea europaea :: Olive Tree 41	715 Buena Vista Ave	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		5999814.0	2107879.0	37.767822415683796	-122.443934762725	(37.7678224156838, -122.443934762725)
4708	4708	253663	Undocumented 2	Olea europaea :: Olive Tree 41	715 Buena Vista Ave	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		5999814.0	2107879.0	37.767822415683796	-122.443934762725	(37.7678224156838, -122.443934762725)
4698	4698	253662	Undocumented 2	Olea europaea :: Olive Tree 41	715 Buena Vista Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5999814.0	2107879.0	37.767822415683796	-122.443934762725	(37.7678224156838, -122.443934762725)
4710	4710	253661	Undocumented 2	Olea europaea :: Olive Tree 41	715 Buena Vista Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5999814.0	2107879.0	37.767822415683796	-122.443934762725	(37.7678224156838, -122.443934762725)
3750	3750	253551	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	19	Back Yard : Yard 13	Tree 1	DPW 2		09/22/2017 04:40:00 PM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3837	3837	253550	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	18	Back Yard : Yard 13	Tree 1	DPW 2		09/27/2017 11:43:00 AM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3841	3841	253549	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	17	Back Yard : Yard 13	Tree 1	DPW 2		09/27/2017 11:46:00 AM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3758	3758	253548	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	16	Back Yard : Yard 13	Tree 1	DPW 2		09/22/2017 04:31:00 PM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3842	3842	253547	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	15	Back Yard : Yard 13	Tree 1	DPW 2		09/27/2017 11:40:00 AM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3840	3840	253546	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	14	Back Yard : Yard 13	Tree 1	DPW 2		09/27/2017 11:50:00 AM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
3402	3402	253446	Permitted Site 1	Olea europaea :: Olive Tree 41	1339 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/21/1992 12:00:00 AM		3x3		6002186.0	2113207.0	37.7825867929513	-122.43611162356399	(37.7825867929513, -122.436111623564)
2596	2596	253141	Undocumented 2	Olea europaea :: Olive Tree 41	40 Brady St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				Width 2ft		6006614.59932	2109591.90022	37.7729112084036	-122.42053385147	(37.7729112084036, -122.42053385147)
2597	2597	253140	Undocumented 2	Olea europaea :: Olive Tree 41	40 Brady St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				Width 2ft		6006614.59932	2109591.90022	37.7729112084036	-122.42053385147	(37.7729112084036, -122.42053385147)
2602	2602	253139	Undocumented 2	Olea europaea :: Olive Tree 41	40 Brady St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				Width 2ft		6006614.59932	2109591.90022	37.7729112084036	-122.42053385147	(37.7729112084036, -122.42053385147)
2605	2605	253138	Undocumented 2	Olea europaea :: Olive Tree 41	40 Brady St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				Width 2ft		6006614.59932	2109591.90022	37.7729112084036	-122.42053385147	(37.7729112084036, -122.42053385147)
2604	2604	253137	Undocumented 2	Olea europaea :: Olive Tree 41	40 Brady St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				Width 2ft		6006614.59932	2109591.90022	37.7729112084036	-122.42053385147	(37.7729112084036, -122.42053385147)
2199	2199	252934	Undocumented 2	Olea europaea :: Olive Tree 41	78 Edgar Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5997141.0	2091229.0	37.7219527643602	-122.451978930217	(37.7219527643602, -122.451978930217)
2201	2201	252933	Undocumented 2	Olea europaea :: Olive Tree 41	72 Edgar Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5997141.0	2091205.0	37.7218868659906	-122.45197719957199	(37.7218868659906, -122.451977199572)
2198	2198	252932	Undocumented 2	Olea europaea :: Olive Tree 41	66 Edgar Ave		Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5997141.0	2091179.0	37.7218154760893	-122.451975324711	(37.7218154760893, -122.451975324711)
1717	1717	251661	Significant Tree 6	Olea europaea :: Olive Tree 41	3200X Van Ness Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				6x6		6005628.0	2121390.0	37.8052501972152	-122.424786108187	(37.8052501972152, -122.424786108187)
1693	1693	251659	Significant Tree 6	Olea europaea :: Olive Tree 41	1050 North Point St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				6x6		6005628.0	2121390.0	37.8052501972152	-122.424786108187	(37.8052501972152, -122.424786108187)
1702	1702	251658	Significant Tree 6	Olea europaea :: Olive Tree 41	1050 North Point St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				6x6		6005628.0	2121390.0	37.8052501972152	-122.424786108187	(37.8052501972152, -122.424786108187)
1557	1557	251590	Undocumented 2	Olea europaea :: Olive Tree 41	340x Vicente St	3	Front Yard : Yard 7	Tree 1	Private 1				3x3		5991910.0	2097743.0	37.739537567792894	-122.47053520105601	(37.7395375677929, -122.470535201056)
67444	67444	251068	Undocumented 2	Olea europaea :: Olive Tree 41	5200 Geary Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		5990659.5951	2112735.5073	37.7806306145781	-122.475953161409	(37.7806306145781, -122.475953161409)
150461	150461	251053	Undocumented 2	Olea europaea :: Olive Tree 41	6037 Geary Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5988236.6482	2112545.9544	37.779969371083396	-122.484321284188	(37.7799693710834, -122.484321284188)
53280	53280	251033	Undocumented 2	Olea europaea :: Olive Tree 41	5055 Geary Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 5ft		5991301.1722	2112656.9502	37.780452097292105	-122.473727928995	(37.7804520972921, -122.473727928995)
31652	31652	251030	Undocumented 2	Olea europaea :: Olive Tree 41	5045 Geary Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991324.1691	2112656.9502	37.7804534291646	-122.47364837269899	(37.7804534291646, -122.473648372699)
65061	65061	251021	Undocumented 2	Olea europaea :: Olive Tree 41	5001 Geary Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5991446.6722	2112660.0459	37.7804690230051	-122.473224806894	(37.7804690230051, -122.473224806894)
173191	173191	250895	Undocumented 2	Olea europaea :: Olive Tree 41	249 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5986794.29101	2114259.16671	37.784589272119206	-122.489436984737	(37.7845892721192, -122.489436984737)
58998	58998	250889	Undocumented 2	Olea europaea :: Olive Tree 41	188 29th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986829.80655	2114505.49591	37.7852676945878	-122.489332232591	(37.7852676945878, -122.489332232591)
186040	186040	250888	Undocumented 2	Olea europaea :: Olive Tree 41	188 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986832.35186	2114485.1833200003	37.7852120706333	-122.489321932679	(37.7852120706333, -122.489321932679)
131266	131266	250766	Undocumented 2	Olea europaea :: Olive Tree 41	242 32nd Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		5985905.94434	2114279.52557	37.7845932723154	-122.49251182078699	(37.7845932723154, -122.492511820787)
38421	38421	250732	Undocumented 2	Olea europaea :: Olive Tree 41	2800 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986742.130530001	2114466.27416	37.785154884529796	-122.48963267541401	(37.7851548845298, -122.489632675414)
54382	54382	250729	Undocumented 2	Olea europaea :: Olive Tree 41	2750 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986868.92128	2114466.01828	37.7851615835723	-122.48919400591998	(37.7851615835723, -122.48919400592)
162806	162806	250728	Undocumented 2	Olea europaea :: Olive Tree 41	2750 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986892.252230001	2114468.57233	37.7851699580643	-122.489113477	(37.7851699580643, -122.489113477)
174028	174028	250679	Undocumented 2	Olea europaea :: Olive Tree 41	738 El Camino Del Mar	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986277.67302	2114856.6587400003	37.7861996404479	-122.491268273323	(37.7861996404479, -122.491268273323)
185484	185484	250678	Undocumented 2	Olea europaea :: Olive Tree 41	738 El Camino Del Mar	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986293.8358	2114857.16147	37.7862019651938	-122.49121239213301	(37.7862019651938, -122.491212392133)
60030	60030	250487	Undocumented 2	Olea europaea :: Olive Tree 41	222 El Camino Del Mar	1	: 4	Tree 1	Private 1			6	Width 3ft		5987893.38095	2115356.6041900003	37.7876666226671	-122.485715124257	(37.7876666226671, -122.485715124257)
54952	54952	250476	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5986724.14595	2115502.52724	37.7879990867237	-122.48977113143101	(37.7879990867237, -122.489771131431)
164345	164345	250475	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5986728.53503	2115508.4583	37.788015627964896	-122.489756382558	(37.7880156279649, -122.489756382558)
160144	160144	250474	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5986733.97839	2115515.13403	37.7880342754081	-122.48973804088999	(37.7880342754081, -122.48973804089)
44693	44693	250473	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5986741.47622	2115523.3100799997	37.7880571622447	-122.489712701583	(37.7880571622447, -122.489712701583)
146872	146872	250472	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986745.83672	2115531.55252	37.788080048191105	-122.48969822161101	(37.7880800481911, -122.489698221611)
76806	76806	250471	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986750.2083	2115540.3158400003	37.7881043649685	-122.489683741616	(37.7881043649685, -122.489683741616)
37721	37721	250470	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986758.26234	2115550.04275	37.7881315424801	-122.489656591996	(37.7881315424801, -122.489656591996)
186082	186082	250468	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986773.71453	2115563.2588299997	37.7881687321606	-122.489604103052	(37.7881687321606, -122.489604103052)
149001	149001	250467	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986778.63125	2115573.05245	37.7881959096583	-122.48958781273701	(37.7881959096583, -122.489587812737)
161527	161527	250126	Undocumented 2	Olea europaea :: Olive Tree 41	1730 Pine St	2	: 4	Tree 1	Private 1			10	Width 3ft		6005603.2664	2115542.36715	37.7891926840386	-122.424455506243	(37.7891926840386, -122.424455506243)
54728	54728	250097	Undocumented 2	Olea europaea :: Olive Tree 41	1701 Pine St	3	: 4	Tree 1	Private 1			4	Width 3ft		6005753.0625599995	2115514.84991	37.789125586518395	-122.423935271799	(37.7891255865184, -122.423935271799)
163050	163050	250096	Undocumented 2	Olea europaea :: Olive Tree 41	1701 Pine St	1	: 4	Tree 1	Private 1			7	Width 3ft		6005700.6097099995	2115508.13842	37.789104197049	-122.42411627476002	(37.789104197049, -122.42411627476)
26842	26842	249462	Undocumented 2	Olea europaea :: Olive Tree 41	201 Olive St	7	: 4	Tree 1	Private 1			9	Width 4ft		6006460.85988	2113718.34687	37.784232765583	-122.42135874831499	(37.784232765583, -122.421358748315)
163484	163484	249461	Undocumented 2	Olea europaea :: Olive Tree 41	201 Olive St	6	: 4	Tree 1	Private 1			9	Width 4ft		6006433.55883	2113714.71473	37.784221253347894	-122.42145294241001	(37.7842212533479, -122.42145294241)
33560	33560	249460	Undocumented 2	Olea europaea :: Olive Tree 41	201 Olive St	5	: 4	Tree 1	Private 1			11	Width 4ft		6006400.35451	2113710.6450799997	37.7842082068819	-122.421567528645	(37.7842082068819, -122.421567528645)
162609	162609	249459	Undocumented 2	Olea europaea :: Olive Tree 41	201 Olive St	4	: 4	Tree 1	Private 1			8	Width 4ft		6006372.75274	2113706.04085	37.784194008402	-122.42166269399598	(37.784194008402, -122.421662693996)
176809	176809	249458	Undocumented 2	Olea europaea :: Olive Tree 41	201 Olive St	3	: 4	Tree 1	Private 1			8	Width 4ft		6006350.21001	2113701.7523	37.7841809619115	-122.421740379236	(37.7841809619115, -122.421740379236)
41569	41569	249457	Undocumented 2	Olea europaea :: Olive Tree 41	201 Olive St	2	: 4	Tree 1	Private 1			11	Width 4ft		6006319.82833	2113698.46294	37.784170216831896	-122.42184525546101	(37.7841702168319, -122.421845255461)
171513	171513	249456	Undocumented 2	Olea europaea :: Olive Tree 41	201 Olive St	1	: 4	Tree 1	Private 1			4	Width 4ft		6006295.7266	2113694.91688	37.784159120994	-122.421928386997	(37.784159120994, -122.421928386997)
33233	33233	249455	Undocumented 2	Olea europaea :: Olive Tree 41	251 Olive St	5	: 4	Tree 1	Private 1			9	Width 3ft		6006189.184780001	2113676.83316	37.7841034583637	-122.42229569890699	(37.7841034583637, -122.422295698907)
162713	162713	249454	Undocumented 2	Olea europaea :: Olive Tree 41	251 Olive St	4	: 4	Tree 1	Private 1			6	Width 3ft		6006170.8585	2113675.59	37.784099011196204	-122.422359012976	(37.7840990111962, -122.422359012976)
75119	75119	249453	Undocumented 2	Olea europaea :: Olive Tree 41	251 Olive St	3	: 4	Tree 1	Private 1			7	Width 3ft		6006151.02275	2113672.37502	37.784089064710706	-122.422427409114	(37.7840890647107, -122.422427409114)
49065	49065	249452	Undocumented 2	Olea europaea :: Olive Tree 41	251 Olive St	2	: 4	Tree 1	Private 1			7	Width 3ft		6006131.50296	2113669.15355	37.7840791181899	-122.42249471166299	(37.7840791181899, -122.422494711663)
50682	50682	249451	Undocumented 2	Olea europaea :: Olive Tree 41	251 Olive St	1	: 4	Tree 1	Private 1			5	Width 3ft		6006114.5159	2113666.03761	37.7840696042744	-122.422553259352	(37.7840696042744, -122.422553259352)
62642	62642	249450	Undocumented 2	Olea europaea :: Olive Tree 41	250 Olive St	2	: 4	Tree 1	Private 1			7	Width 3ft		6006131.652509999	2113691.8301	37.7841413908581	-122.42249580613701	(37.7841413908581, -122.422495806137)
29734	29734	249449	Undocumented 2	Olea europaea :: Olive Tree 41	250 Olive St	1	: 4	Tree 1	Private 1			8	Width 3ft		6006158.32839	2113696.95162	37.7841569581316	-122.422403881033	(37.7841569581316, -122.422403881033)
129559	129559	249448	Undocumented 2	Olea europaea :: Olive Tree 41	238 Olive St	2	: 4	Tree 1	Private 1			3	Width 3ft		6006176.73504	2113699.88088	37.7841660394729	-122.42234040870599	(37.7841660394729, -122.422340408706)
153731	153731	249447	Undocumented 2	Olea europaea :: Olive Tree 41	238 Olive St	1	: 4	Tree 1	Private 1			3	Width 3ft		6006223.8532	2113706.94532	37.7841880944532	-122.422177898507	(37.7841880944532, -122.422177898507)
130908	130908	248487	Undocumented 2	Olea europaea :: Olive Tree 41	151 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5998252.1159	2107895.1263	37.767777476874706	-122.449338273179	(37.7677774768747, -122.449338273179)
162487	162487	248480	Undocumented 2	Olea europaea :: Olive Tree 41	762 Clayton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5998613.8452	2107871.6571	37.767733721044294	-122.448085410228	(37.7677337210443, -122.448085410228)
61073	61073	248370	Undocumented 2	Olea europaea :: Olive Tree 41	107 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5998216.6849	2108153.1367	37.768483881038705	-122.449479417032	(37.7684838810387, -122.449479417032)
68731	68731	248355	Undocumented 2	Olea europaea :: Olive Tree 41	1467 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5998719.5325	2108289.864	37.768888052170205	-122.447749962507	(37.7688880521702, -122.447749962507)
62381	62381	248225	Undocumented 2	Olea europaea :: Olive Tree 41	71 Fair Ave	2	Side Yard : Yard 17	Tree 1	Private 1			23			6007150.64932	2099361.50355	37.744851098794996	-122.417954229804	(37.744851098795, -122.417954229804)
76093	76093	248224	Undocumented 2	Olea europaea :: Olive Tree 41	71 Fair Ave	1	Side Yard : Yard 17	Tree 1	Private 1			11			6007158.82795	2099359.7804799997	37.7448468279249	-122.41792582744199	(37.7448468279249, -122.417925827442)
174254	174254	248082	Undocumented 2	Olea europaea :: Olive Tree 41	1612 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010391.11225	2100221.52912	37.7473943833415	-122.406809861601	(37.7473943833415, -122.406809861601)
149595	149595	248080	Undocumented 2	Olea europaea :: Olive Tree 41	1628 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010474.0554599995	2100144.37677	37.7471871804634	-122.4065176125	(37.7471871804634, -122.4065176125)
157055	157055	247964	Undocumented 2	Olea europaea :: Olive Tree 41	14 Joy St	5	Front Yard : Yard 7	Tree 1	Private 1			1			6010353.4746900005	2098911.2198799998	37.7437944538423	-122.40684767629601	(37.7437944538423, -122.406847676296)
68746	68746	247778	Undocumented 2	Olea europaea :: Olive Tree 41	250 30th St	1	: 4	Tree 1	Private 1			13	Width 3ft		6004957.69836	2098452.79483	37.7422323278575	-122.42547239214	(37.7422323278575, -122.42547239214)
31843	31843	247696	Undocumented 2	Olea europaea :: Olive Tree 41	66 Central Ave	1	: 4	Tree 1	Private 1			3	Width 4ft		5999969.16959	2108614.08966	37.769849637370896	-122.443450859673	(37.7698496373709, -122.443450859673)
109903	109903	247670	Undocumented 2	Olea europaea :: Olive Tree 41	170 Divisadero St	1	: 4	Tree 1	Private 1			4	Width 4ft		6001927.47375	2108582.2733299998	37.7698737616969	-122.43667486556801	(37.7698737616969, -122.436674865568)
29418	29418	247623	Undocumented 2	Olea europaea :: Olive Tree 41	261 Bradford St	1	: 4	Tree 1	Private 1			3	Width 4ft		6009541.508359999	2097060.7150400002	37.738667903594205	-122.409524699022	(37.7386679035942, -122.409524699022)
2576	2576	247475	Permitted Site 1	Olea europaea :: Olive Tree 41	330 Scott St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/02/1998 12:00:00 AM	11	Width 0ft	Permit Number 38697	6002266.1755	2109683.5253	37.7729167694499	-122.435582100921	(37.7729167694499, -122.435582100921)
72605	72605	247409	Undocumented 2	Olea europaea :: Olive Tree 41	990 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6001845.9485	2109464.3715	37.772291150933	-122.43702002071998	(37.772291150933, -122.43702002072)
24011	24011	247408	Undocumented 2	Olea europaea :: Olive Tree 41	990 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6001866.3003	2109465.7283	37.7722960331347	-122.436949719287	(37.7722960331347, -122.436949719287)
131330	131330	247407	Undocumented 2	Olea europaea :: Olive Tree 41	978 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6001900.8985	2109471.8338	37.772314763733505	-122.43683047834499	(37.7723147637335, -122.436830478345)
46893	46893	247406	Undocumented 2	Olea europaea :: Olive Tree 41	978 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6001915.1447	2109474.5474	37.7723230242624	-122.43678139381201	(37.7723230242624, -122.436781393812)
177653	177653	247396	Undocumented 2	Olea europaea :: Olive Tree 41	315 Scott St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6002214.656	2109699.0961	37.7729565966924	-122.43576142699699	(37.7729565966924, -122.435761426997)
164265	164265	247239	Undocumented 2	Olea europaea :: Olive Tree 41	923 Buena Vista Ave West	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 1ft		6000025.84088	2108639.91315	37.7699237738831	-122.443256690652	(37.7699237738831, -122.443256690652)
148909	148909	247160	Undocumented 2	Olea europaea :: Olive Tree 41	3998 17th St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			8	Width 3ft		6002420.24757	2105915.11638	37.7625783928991	-122.43477961627899	(37.7625783928991, -122.434779616279)
146899	146899	247159	Undocumented 2	Olea europaea :: Olive Tree 41	3998 17th St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 3ft		6002431.63894	2105915.71015	37.7625806699736	-122.434740260168	(37.7625806699736, -122.434740260168)
157175	157175	247158	Undocumented 2	Olea europaea :: Olive Tree 41	3998 17th St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6002441.05995	2105914.9624900003	37.7625791519331	-122.43470762288	(37.7625791519331, -122.43470762288)
130341	130341	247057	Undocumented 2	Olea europaea :: Olive Tree 41	5399 Diamond Heights Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			6002040.3049	2098349.1442299997	37.741782460002206	-122.43555240912201	(37.7417824600022, -122.435552409122)
176093	176093	247041	Undocumented 2	Olea europaea :: Olive Tree 41	595 Valley St	1	Front Yard : Yard 7	Tree 1	Private 1			2			6002155.11446	2099145.78965	37.7439763821952	-122.43521240422501	(37.7439763821952, -122.435212404225)
77279	77279	246979	Undocumented 2	Olea europaea :: Olive Tree 41	16 Clipper St	1	: 4	Tree 1	Private 1			8	Width 4ft		6005040.7561800005	2101085.41279	37.7494655858732	-122.425372506247	(37.7494655858732, -122.425372506247)
71061	71061	246756	Undocumented 2	Olea europaea :: Olive Tree 41	1838 Alabama St	3	Front Yard : Yard 7	Tree 1	Private 1			2			6009319.49474	2098935.33423	37.7438027564037	-122.410424651497	(37.7438027564037, -122.410424651497)
32457	32457	246727	Undocumented 2	Olea europaea :: Olive Tree 41	159 Ripley St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6008928.07801	2099130.49875	37.7443166847779	-122.41179187100401	(37.7443166847779, -122.411791871004)
58363	58363	246726	Undocumented 2	Olea europaea :: Olive Tree 41	159 Ripley St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6008943.04853	2099131.53117	37.7443203594052	-122.41174017886001	(37.7443203594052, -122.41174017886)
24257	24257	246725	Undocumented 2	Olea europaea :: Olive Tree 41	159 Ripley St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6008962.35356	2099130.96939	37.744319899838295	-122.411673386218	(37.7443198998383, -122.411673386218)
188553	188553	246628	Undocumented 2	Olea europaea :: Olive Tree 41	3300 Harrison St	6	Side Yard : Yard 17	Tree 1	Private 1			7			6009031.72375	2099369.08818	37.7449776127301	-122.411450337281	(37.7449776127301, -122.411450337281)
59005	59005	246627	Undocumented 2	Olea europaea :: Olive Tree 41	3300 Harrison St	5	Side Yard : Yard 17	Tree 1	Private 1			6			6009025.0688	2099378.58818	37.7450033243595	-122.411474020021	(37.7450033243595, -122.411474020021)
45831	45831	246626	Undocumented 2	Olea europaea :: Olive Tree 41	3300 Harrison St	4	Side Yard : Yard 17	Tree 1	Private 1			8			6009022.37721	2099388.9393599997	37.7450315954447	-122.411484058261	(37.7450315954447, -122.411484058261)

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