Street_Tree_List

Data source: data.sfgov.org

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

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
35602	35602	217547	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	102 Broad St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5995842.2441	2088093.8487	37.713269899907104	-122.45624180431801	(37.7132698999071, -122.456241804318)
65375	65375	200196	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1124 Fitzgerald Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 0ft		6015063.1024	2090263.455	37.720311838731	-122.38995879887301	(37.720311838731, -122.389958798873)
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)
176045	176045	199858	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2513 Keith St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6014132.4385	2092038.2943	37.7251335354362	-122.393299957721	(37.7251335354362, -122.393299957721)
162336	162336	217617	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1830 Ocean Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5994396.9504	2092455.3654	37.7251625099423	-122.46155321589701	(37.7251625099423, -122.461553215897)
68835	68835	199857	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2511 Keith St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6014147.0563	2092057.1756	37.725186191812	-122.39325074575198	(37.725186191812, -122.393250745752)
184834	184834	217619	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1830 Ocean Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5994357.3344	2092471.2741	37.7252039110132	-122.461691316268	(37.7252039110132, -122.461691316268)
24837	24837	217620	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1830 Ocean Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5994327.7005	2092483.4396	37.7252356086447	-122.461794638623	(37.7252356086447, -122.461794638623)
148525	148525	199856	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2509 Keith St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6014162.2831	2092076.0569	37.725238881999395	-122.393199428445	(37.7252388819994, -122.393199428445)
180017	180017	217621	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1830 Ocean Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5994307.7366	2092494.0455	37.725263580598	-122.461864420033	(37.725263580598, -122.461864420033)
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)
68785	68785	199855	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2507 Keith St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6014175.0737	2092094.9381	37.7252914365514	-122.393156532831	(37.7252914365514, -122.393156532831)
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)
58026	58026	199854	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2505 Keith St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6014200.0457	2092143.0549	37.7254249428706	-122.393073571548	(37.7254249428706, -122.393073571548)
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)
73307	73307	199853	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2503 Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6014209.1818	2092155.2364	37.7254588983374	-122.39304284056499	(37.7254588983374, -122.393042840565)
174955	174955	199852	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2501 Keith St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6014213.4453	2092166.8088	37.7254909106612	-122.393028911239	(37.7254909106612, -122.393028911239)
170725	170725	199724	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2300 Jennings St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6015054.2433	2092170.6809999999	37.7255482128528	-122.390122592124	(37.7255482128528, -122.390122592124)
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)
173135	173135	199722	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2300 Jennings St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6015093.5789	2092222.3792	37.72569234746	-122.38999022091998	(37.72569234746, -122.38999022092)
133602	133602	199721	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2300 Jennings St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6015103.6937	2092236.9895	37.7257330254006	-122.389956274684	(37.7257330254006, -122.389956274684)
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)
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)
97930	97930	199735	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6014648.3519	2092320.2341	37.7259363350419	-122.391536186534	(37.7259363350419, -122.391536186534)
74755	74755	199769	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1197 Thomas Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6016909.41	2092306.5247	37.726023933628895	-122.383718829233	(37.7260239336289, -122.383718829233)
69184	69184	199738	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6014531.8139	2092406.2929	37.7261661660829	-122.39194506905001	(37.7261661660829, -122.39194506905)
67341	67341	199739	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1500 Armstrong Ave	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6014497.7489	2092432.2899	37.7262356573725	-122.392064648003	(37.7262356573725, -122.392064648003)
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)
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)
175898	175898	199982	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1081 Quesada Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6018036.5838	2092513.2332	37.7266537566215	-122.379836574534	(37.7266537566215, -122.379836574534)
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)
53527	53527	200684	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1618 Oakdale Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6015017.6376	2095531.4827	37.7347742678836	-122.39048386170401	(37.7347742678836, -122.390483861704)
169564	169564	200689	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	4705 03rd St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6015031.9275	2095672.1834	37.73516139610629	-122.39044428404699	(37.7351613961063, -122.390444284047)
4557	4557	245383	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	3720 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	Width 0ft		6005268.7499	2096538.92	37.7369948294896	-122.42426078327499	(37.7369948294896, -122.424260783275)
4602	4602	245382	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	3720 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			13	Width 0ft		6005277.267000001	2096556.8057	37.7370444205252	-122.42423260748899	(37.7370444205252, -122.424232607489)
67059	67059	185225	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2519 34th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5985800.5083	2098072.0747	37.7400859553966	-122.491683090969	(37.7400859553966, -122.491683090969)
154252	154252	245378	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	3550 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6005581.5521	2097815.7311	37.7405183234498	-122.42327002037099	(37.7405183234498, -122.423270020371)
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)
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)
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)
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)
29051	29051	181932	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2378 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 0ft		5985195.246	2099024.2764	37.74266505256279	-122.49384596323	(37.7426650525628, -122.49384596323)
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)
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)
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)
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)
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)
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)
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)
60650	60650	245421	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2895 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6009555.5127	2102167.7354	37.752691443997996	-122.40983667839501	(37.752691443998, -122.409836678395)
168438	168438	245420	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2855 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6009712.0846	2102179.2059	37.7527317128259	-122.409296032004	(37.7527317128259, -122.409296032004)
133730	133730	245419	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2839 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6009862.9212	2102186.0881	37.7527590594841	-122.408774895147	(37.7527590594841, -122.408774895147)
188438	188438	245412	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2802 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6009963.8161	2102233.787	37.7528956807716	-122.408429345015	(37.7528956807716, -122.408429345015)
1775	1775	245411	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2794 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	Width 0ft		6010069.4683	2102240.5937	37.7529202865107	-122.408064458251	(37.7529202865107, -122.408064458251)
1904	1904	245410	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2782 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6010125.3081	2102244.3008	37.752933591707794	-122.40787161420401	(37.7529335917078, -122.407871614204)
39668	39668	245409	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2778 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 0ft		6010163.1606	2102247.1684	37.7529435845832	-122.40774091468	(37.7529435845832, -122.40774091468)
130123	130123	245414	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2736 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 0ft		6010338.0852	2102254.0506	37.752972272430206	-122.40713647446998	(37.7529722724302, -122.40713647447)
137830	137830	245413	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2726 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 0ft		6010382.82	2102257.4918	37.7529842245941	-122.406982014782	(37.7529842245941, -122.406982014782)
181828	181828	245472	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2700 24th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6010432.7166	2102259.7859	37.7529933156944	-122.406809623625	(37.7529933156944, -122.406809623625)
130725	130725	245471	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2700 24th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 0ft		6010463.1133	2102261.5065	37.7529997408326	-122.406704626743	(37.7529997408326, -122.406704626743)
177119	177119	245470	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2700 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 0ft		6010486.0542	2102262.08	37.753002599060295	-122.40662533272899	(37.7530025990603, -122.406625332729)
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)
43401	43401	182246	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1455 33rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5985863.116	2105312.6885	37.759970370515106	-122.491999577939	(37.7599703705151, -122.491999577939)
879	879	246305	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2135 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	Width 0ft		6006876.9266	2105933.3644	37.762880513109295	-122.41936683944401	(37.7628805131093, -122.419366839444)
72332	72332	182039	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1323 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5988935.747	2106319.8798	37.7629149697028	-122.481446720354	(37.7629149697028, -122.481446720354)
55161	55161	246282	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2125 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6006871.6187	2105950.8046	37.762928100871896	-122.41938643496401	(37.7629281008719, -122.419386434964)
228	228	246283	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2125 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	Width 0ft		6006872.377	2105970.5198	37.7629822769131	-122.419385210964	(37.7629822769131, -122.419385210964)
187140	187140	183273	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1251 40th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5983646.3542	2106625.2038	37.7634443416971	-122.49976317535801	(37.7634443416971, -122.499763175358)
58145	58145	183272	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1251 40th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5983645.262999999	2106639.9345	37.7634847239936	-122.49976803825199	(37.7634847239936, -122.499768038252)
40899	40899	181727	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2755 29th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5987094.0342	2107004.1542	37.76468654333279	-122.487866760897	(37.7646865433328, -122.487866760897)
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)
163380	163380	245439	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2940 16th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 0ft		6007210.058999999	2106771.9452	37.7652018171161	-122.418274106734	(37.7652018171161, -122.418274106734)
146420	146420	245460	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2940 16th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 0ft		6007306.1163	2106778.6027	37.7652255036159	-122.41794233876101	(37.7652255036159, -122.417942338761)
157627	157627	245462	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2886 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6007544.8329	2106792.8686	37.7652781065022	-122.41711768386001	(37.7652781065022, -122.41711768386)
63246	63246	245461	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2886 16th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6007563.8542	2106794.7707	37.7652843992631	-122.417052028294	(37.7652843992631, -122.417052028294)
57912	57912	200832	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2000 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		6010535.924	2106957.4024	37.7658976908793	-122.406783753376	(37.7658976908793, -122.406783753376)
48254	48254	248610	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	872 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5997691.4278	2107516.4386	37.7667056091614	-122.4512503025	(37.7667056091614, -122.4512503025)
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)
154058	154058	248533	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	174 Belvedere St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5998320.7066	2107735.9897	37.7673444513971	-122.449089561777	(37.7673444513971, -122.449089561777)
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)
41329	41329	248473	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	758 Clayton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		5998609.6056	2107900.123	37.7678116388378	-122.448102124294	(37.7678116388378, -122.448102124294)
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)
183087	183087	248411	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1737 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		5997411.4623	2108107.5609	37.76831264578671	-122.45226130839701	(37.7683126457867, -122.452261308397)
177880	177880	248404	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1713 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5997468.9999	2108115.1317	37.768336729240296	-122.452062838629	(37.7683367292403, -122.452062838629)
150865	150865	246100	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5997118.778	2108135.4212	37.7683723717283	-122.453275681682	(37.7683723717283, -122.453275681682)
43725	43725	246164	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1756 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		5997323.9447	2108138.6009	37.768392859677896	-122.452566262235	(37.7683928596779, -122.452566262235)
155231	155231	246099	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5997115.1441	2108154.4994	37.7684245472814	-122.453289628456	(37.7684245472814, -122.453289628456)
73071	73071	248407	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	39 Delmar St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5999275.3753	2108109.8322	37.7684254834855	-122.445814398115	(37.7684254834855, -122.445814398115)
52969	52969	248377	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	701 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		5997902.4997	2108143.1434	37.7684384639657	-122.45056543049401	(37.7684384639657, -122.450565430494)
183850	183850	248348	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	706 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5997944.2901	2108144.5061	37.7684445974615	-122.45042098016701	(37.7684445974615, -122.450420980167)
153054	153054	246152	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1720 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5997446.2877	2108155.2565	37.7684456006596	-122.45214429305	(37.7684456006596, -122.45214429305)
39575	39575	246153	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1720 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5997461.1263	2108156.7707	37.7684506082583	-122.45209307718099	(37.7684506082583, -122.452093077181)
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)
77095	77095	248383	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1621 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5997789.5444	2108160.7074	37.7684802243505	-122.450957397559	(37.7684802243505, -122.450957397559)
131399	131399	248376	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	701 Cole St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		5997900.3799	2108160.4046	37.7684857374838	-122.45057400725	(37.7684857374838, -122.45057400725)
74916	74916	248371	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1609 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5997803.1717	2108162.5244	37.7684859935016	-122.45091039318199	(37.7684859935016, -122.450910393182)
172810	172810	246165	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1700 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		5997526.8402	2108168.581	37.7684868003121	-122.45186663191299	(37.7684868003121, -122.451866631913)
147110	147110	248373	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1609 Waller St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		5997837.6943	2108167.0669	37.768500442306106	-122.45079131066002	(37.7685004423061, -122.45079131066)
180852	180852	246097	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	700 Stanyan St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		5997110.2988	2108193.2616	37.7685307006045	-122.45330918662901	(37.7685307006045, -122.453309186629)

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