Street_Tree_List

Data source: data.sfgov.org

846 rows where PlotSize = "Width 0ft" and qSpecies = 59 sorted by DBH

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, PlantDate, DBH, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH ▼	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
954	954	251405	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	540 LOMBARD ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/21/2016 12:08:00 PM		Width 0ft		6009678.016	2120549.6995	37.8031708545804	-122.410711083519	(37.8031708545804, -122.410711083519)
70528	70528	143389	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1800 UNION ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6004330.7069	2118766.2088	37.7979725882879	-122.42908836006399	(37.7979725882879, -122.429088360064)
147790	147790	138486	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1910 STEINER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6002505.7805	2114896.8038	37.7872447276766	-122.435126221094	(37.7872447276766, -122.435126221094)
149998	149998	248465	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	772 Stanyan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5997147.6982	2107925.2578	37.767796974534605	-122.45316047633601	(37.7677969745346, -122.453160476336)
184932	184932	142820	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1754 POLK ST	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 0ft		6006598.3556	2116937.7026	37.793080071640894	-122.42111173056101	(37.7930800716409, -122.421111730561)
37099	37099	141488	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5996896.3984	2111514.1702	37.7776367906711	-122.454288950996	(37.7776367906711, -122.454288950996)
58484	58484	138743	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2965 Bush St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5999307.6319	2114263.2516	37.7853230365302	-122.446145501349	(37.7853230365302, -122.446145501349)
58556	58556	143036	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	502 Lombard St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6009910.3575	2120582.9753	37.8032752457109	-122.409909406146	(37.8032752457109, -122.409909406146)
68249	68249	138745	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2965 Bush St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5999354.2167	2114269.6942	37.7853433864461	-122.445984796208	(37.7853433864461, -122.445984796208)
96109	96109	141490	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5996921.6348	2111517.4619	37.7776472759958	-122.454201888036	(37.7776472759958, -122.454201888036)
164399	164399	141486	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		5996862.6584	2111508.4097	37.77761903893	-122.454405252217	(37.77761903893, -122.454405252217)
172803	172803	143014	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	488 LOMBARD ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6010067.5326	2120604.4864	37.8033431173057	-122.409367013095	(37.8033431173057, -122.409367013095)
64636	64636	246098	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5997112.7214	2108174.1833	37.7684784553517	-122.45329942957198	(37.7684784553517, -122.453299429572)
74307	74307	137574	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1135 STEINER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		6002846.9387	2112168.7066	37.7797734277366	-122.43375082949801	(37.7797734277366, -122.433750829498)
137714	137714	138741	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2965 Bush St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5999272.4455	2114257.3047	37.7853046984356	-122.446266807223	(37.7853046984356, -122.446266807223)
186639	186639	138707	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2874 BUSH ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5999741.1485	2114383.1871	37.7856770956012	-122.44465429395099	(37.7856770956012, -122.444654293951)
23838	23838	140159	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	251 ASHBURY ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5998783.859	2109828.5826	37.77311665794689	-122.44763824308501	(37.7731166579469, -122.447638243085)
24233	24233	140776	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	77 TERRA VISTA AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		6000147.5673	2112813.1036	37.7813892348129	-122.443135402805	(37.7813892348129, -122.443135402805)
39439	39439	181853	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2318 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5986420.3329	2099445.95	37.7438944556176	-122.48964102637699	(37.7438944556176, -122.489641026377)
44905	44905	182129	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2650 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5987716.6576	2098310.3756	37.740852067466506	-122.485075392772	(37.7408520674665, -122.485075392772)
58272	58272	181891	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2362 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5985808.0433	2099163.7908	37.7430839555722	-122.491737385137	(37.7430839555722, -122.491737385137)
60986	60986	248611	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	862 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5997689.6108	2107534.9111	37.7667562259025	-122.45125791953001	(37.7667562259025, -122.45125791953)
148571	148571	183823	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2235 27th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5987905.9224	2100064.0482	37.7456782117444	-122.48454959408501	(37.7456782117444, -122.484549594085)
149439	149439	140593	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	950 STEINER ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		6002965.1287	2111621.7183	37.7782782403601	-122.43330286230899	(37.7782782403601, -122.433302862309)
149550	149550	138744	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2965 Bush St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5999334.3934	2114268.2075	37.7853381723766	-122.44605327160801	(37.7853381723766, -122.446053271608)
157088	157088	184487	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1862 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5983833.6059	2102475.6712	37.75206187373821	-122.498808969569	(37.7520618737382, -122.498808969569)
159251	159251	183822	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2235 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5987905.4957	2100075.9969	37.7457109948541	-122.484551945811	(37.7457109948541, -122.484551945811)
176087	176087	137986	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1826 WEBSTER ST	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 0ft		6003453.629	2115096.2902	37.7878462437049	-122.431861119013	(37.7878462437049, -122.431861119013)
180137	180137	138742	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2965 Bush St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5999291.2776	2114261.7649	37.7853180204784	-122.446201975075	(37.7853180204784, -122.446201975075)
183473	183473	184489	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1866 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5983834.6211	2102450.9664	37.7519941007524	-122.49880363397499	(37.7519941007524, -122.498803633975)
24010	24010	248469	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	145 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5998248.1791	2107933.2828	37.7678820197346	-122.449354639507	(37.7678820197346, -122.449354639507)
24338	24338	142592	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6008300.8769	2120835.2204	37.803877514381	-122.415496953155	(37.803877514381, -122.415496953155)
29701	29701	138739	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 PRESIDIO AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5999270.4631	2114185.9407	37.7851086382869	-122.446268530298	(37.7851086382869, -122.446268530298)
36580	36580	142827	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1714 POLK ST	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 0ft		6006619.3625	2116773.8493	37.7926313555217	-122.421027406021	(37.7926313555217, -122.421027406021)
39156	39156	248312	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1375 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5999157.272000001	2108349.6728	37.769077281031606	-122.44624016016199	(37.7690772810316, -122.446240160162)
40459	40459	138740	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 PRESIDIO AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5999265.5073	2114223.1094	37.7852104108131	-122.44628835045299	(37.7852104108131, -122.446288350453)
47229	47229	246151	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1622 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5997783.0336	2108202.195	37.7685937659628	-122.450982909765	(37.7685937659628, -122.450982909765)
60326	60326	187453	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	4621 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6002078.4831	2091980.9842	37.724299121454	-122.43496507260201	(37.724299121454, -122.434965072602)
67589	67589	181728	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2755 29th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5987089.3098	2107026.595	37.7647478839827	-122.487884750055	(37.7647478839827, -122.487884750055)
71966	71966	182128	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2650 Ulloa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5987739.3319	2098310.7141	37.7408543176455	-122.48499701931601	(37.7408543176455, -122.484997019316)
73100	73100	141695	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	392 EWING TER	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5998748.3741	2112341.6402	37.78001483889879	-122.44794195643499	(37.7800148388988, -122.447941956435)
74499	74499	199975	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1233 Shafter Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6016858.7319	2092693.7716	37.7270844364031	-122.38392097441299	(37.7270844364031, -122.383920974413)
124097	124097	137887	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	38 ORBEN PL	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6003163.7564	2115374.8880000003	37.788594765883005	-122.432883934493	(37.788594765883, -122.432883934493)
132506	132506	143556	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	848 KEARNY ST	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 0ft		6011275.0549	2117918.4465	37.796035485985705	-122.40499907891301	(37.7960354859857, -122.404999078913)
134800	134800	140932	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	5 COOK ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5997447.8074	2113631.9151	37.783483168451	-122.452534319363	(37.783483168451, -122.452534319363)
134981	134981	182109	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2443 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5987643.897000001	2098649.745	37.741779647708995	-122.48535186527599	(37.741779647709, -122.485351865276)
163000	163000	143333	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1718 UNION ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6004746.2843	2118826.5974	37.7981619155795	-122.42765464763201	(37.7981619155795, -122.427654647632)
169665	169665	143557	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	848 KEARNY ST	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 0ft		6011271.7921	2117938.489	37.7960903354635	-122.405011780806	(37.7960903354635, -122.405011780806)
188134	188134	181943	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1635 Taraval St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5988119.3796	2098941.1939	37.7426075787892	-122.483729187458	(37.7426075787892, -122.483729187458)
26537	26537	199734	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6014741.5822	2092253.0007	37.725756899909	-122.391209195431	(37.725756899909, -122.391209195431)
31071	31071	247300	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	815 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6002551.3233	2109517.7945	37.772477905220796	-122.434583889381	(37.7724779052208, -122.434583889381)
34969	34969	140050	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	501 FULTON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6005278.6254	2111629.2967	37.778430022863496	-122.425300156764	(37.7784300228635, -122.425300156764)
41163	41163	181854	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2318 32nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5986419.9945	2099457.4563	37.7439260290789	-122.48964304245001	(37.7439260290789, -122.48964304245)
47412	47412	141681	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2340 TURK BLVD	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5998731.3741	2111830.7737	37.77861116004	-122.447963975147	(37.77861116004, -122.447963975147)
47603	47603	142594	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008329.6499	2120808.0026	37.8038043983711	-122.41539545409401	(37.8038043983711, -122.415395454094)
50203	50203	247450	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	917 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6002601.5894	2109867.0536	37.773439737619704	-122.43443498999599	(37.7734397376197, -122.434434989996)
59398	59398	141694	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	392 EWING TER	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5998733.647999999	2112339.0414	37.780006861514	-122.44799271326	(37.780006861514, -122.44799271326)
63167	63167	142150	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	20 Stanyan Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5996389.5624	2112799.0591	37.7811356783284	-122.456135178495	(37.7811356783284, -122.456135178495)
63234	63234	142593	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008314.0969	2120822.0003	37.8038419583694	-122.415450267897	(37.8038419583694, -122.415450267897)
65445	65445	199741	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2396 Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6014513.885	2092478.0086	37.7263620876399	-122.392012061617	(37.7263620876399, -122.392012061617)
71272	71272	199749	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1555 Yosemite Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6014744.6664	2092522.7122	37.7264976449454	-122.39121737809799	(37.7264976449454, -122.391217378098)
72787	72787	141678	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2340 TURK BLVD	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5998817.5652	2111841.8183	37.7786464120147	-122.44766660351101	(37.7786464120147, -122.447666603511)
73758	73758	199726	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2300 Jennings St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6015013.7839	2092118.9829	37.725404016033295	-122.390258847729	(37.7254040160333, -122.390258847729)
76520	76520	141343	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	462 BRODERICK ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6001184.3335	2110341.7185	37.7746624976237	-122.43937150108499	(37.7746624976237, -122.439371501085)
130403	130403	143498	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	857 Kearny St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6011217.723999999	2117930.0991	37.796064276257205	-122.40519827705499	(37.7960642762572, -122.405198277055)
130431	130431	142597	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008368.5325	2120773.0083	37.8037104981311	-122.41525841948	(37.8037104981311, -122.41525841948)
137944	137944	141075	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	189 COMMONWEALTH AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5996533.8993	2113075.3805	37.7819026676704	-122.45565582670099	(37.7819026676704, -122.455655826701)
152688	152688	141696	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	392 EWING TER	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5998768.2977	2112343.8058	37.7800219238864	-122.447873187985	(37.7800219238864, -122.447873187985)
153096	153096	199728	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2300 Jennings St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6014985.6871	2092077.3996	37.725288278052	-122.390353072543	(37.725288278052, -122.390353072543)
156337	156337	143497	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	867 Kearny St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6011217.2579	2117938.9551	37.796088566637394	-122.40520051378999	(37.7960885666374, -122.40520051379)
156752	156752	142993	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008349.8689	2120789.339	37.803754289201606	-122.415324162836	(37.8037542892016, -122.415324162836)
163560	163560	199757	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1555 Yosemite Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6015056.6652	2092285.8367	37.7258645418149	-122.39012226093901	(37.7258645418149, -122.390122260939)
163737	163737	143168	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	189 Bay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6009887.869	2121571.9902	37.8059895743176	-122.410057091761	(37.8059895743176, -122.410057091761)
164164	164164	142598	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008376.308999999	2120765.2318	37.8036895828586	-122.415230957587	(37.8036895828586, -122.415230957587)
167035	167035	142595	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008339.7594	2120798.6708	37.803779343791795	-122.415359808453	(37.8037793437918, -122.415359808453)
167676	167676	142591	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008291.5451	2120841.4416	37.8038940717069	-122.41552968724	(37.8038940717069, -122.41552968724)
168080	168080	141679	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2340 TURK BLVD	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5998783.9983	2111836.4043	37.778629628102	-122.44778233403	(37.778629628102, -122.44778233403)
168944	168944	140051	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	501 FULTON ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6005299.4561	2111632.5014	37.7784399990073	-122.42522832358	(37.7784399990073, -122.42522832358)
170427	170427	199732	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6014820.4695	2092191.1459	37.7255914365754	-122.390932164611	(37.7255914365754, -122.390932164611)
170986	170986	141341	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	448 BRODERICK ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6001191.7822	2110294.5435	37.7745333908239	-122.43934235241699	(37.7745333908239, -122.439342352417)
173501	173501	142596	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6008359.2007	2120780.7848	37.8037313259866	-122.415291263605	(37.8037313259866, -122.415291263605)
180418	180418	143162	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	175 Bay St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6009943.6415	2121579.1756	37.8060124294215	-122.409864588833	(37.8060124294215, -122.409864588833)
185077	185077	244147	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	405 Rose St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		6004529.1957	2109628.6007	37.772894233589795	-122.42775012801701	(37.7728942335898, -122.427750128017)
26624	26624	141693	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	392 EWING TER	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5998717.1894	2112334.7102	37.7799940283513	-122.448049338774	(37.7799940283513, -122.448049338774)
29172	29172	138854	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	519 Ivy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6004884.6976	2111071.1642	37.776875264769295	-122.42662314727501	(37.7768752647693, -122.426623147275)
34800	34800	140777	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	77 TERRA VISTA AVE	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6000158.3968	2112814.4573	37.7813935692054	-122.44309803536699	(37.7813935692054, -122.443098035367)
36187	36187	143482	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	601 CALIFORNIA ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6010529.9358	2116279.9602	37.7914949183295	-122.407461776619	(37.7914949183295, -122.407461776619)
36681	36681	199730	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6014897.5638	2092133.7733	37.725438180339	-122.390661646389	(37.725438180339, -122.390661646389)
39267	39267	141082	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	188 Commonwealth Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5996586.3547	2113042.2151	37.7818146143415	-122.455471958556	(37.7818146143415, -122.455471958556)
39425	39425	142599	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	365 COLUMBUS AVE	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6008384.0855	2120756.6777	37.8036665324855	-122.415203440632	(37.8036665324855, -122.415203440632)
43832	43832	138987	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	661 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6003459.8516	2110684.9037	37.7757340330654	-122.43152453742701	(37.7757340330654, -122.431524537427)
44212	44212	184648	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1691 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5983748.1287	2103659.9866	37.755308660398505	-122.49919205978998	(37.7553086603985, -122.49919205979)
47388	47388	199743	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2392 Keith St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6014556.9144	2092538.9669	37.7265318557922	-122.391867570434	(37.7265318557922, -122.391867570434)
51389	51389	141496	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5997041.2335	2111532.8232	37.77769631160189	-122.45378926737101	(37.7776963116019, -122.453789267371)
54416	54416	143548	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2237 UNION ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6002268.9185	2118432.4796	37.7969393283412	-122.4361988317	(37.7969393283412, -122.4361988317)
59370	59370	141680	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2340 TURK BLVD	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5998758.0111	2111834.2387	37.7786221965848	-122.447872077437	(37.7786221965848, -122.447872077437)
62193	62193	141692	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	392 EWING TER	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5998708.9601	2112320.4172	37.7799543130642	-122.44807677808001	(37.7799543130642, -122.44807677808)
67728	67728	141494	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2901 TURK BLVD	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5996978.1424	2111525.1425	37.7776716051006	-122.45400696498899	(37.7776716051006, -122.454006964989)
130998	130998	141652	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1444 GROVE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6000879.6247	2110722.6324	37.7756910458411	-122.440452872246	(37.7756910458411, -122.440452872246)
135005	135005	247389	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	219 Scott St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6002278.4252	2109251.0163	37.771729902717794	-122.43550878138001	(37.7717299027178, -122.43550878138)

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