Street_Tree_List

Data source: data.sfgov.org

1,136 rows where qCaretaker = 1 and qSpecies = 59 sorted by YCoord

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, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord ▼	Latitude	Longitude	Location
22132	22132	28299	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	100 Broad St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3X3		5995861.9776	2088092.909	37.713268452474104	-122.45617353106701	(37.7132684524741, -122.456173531067)
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)
68178	68178	32290	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1400 Egbert Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/15/1996 12:00:00 AM	13		Permit Number 36872	6014301.1518	2091179.5011	37.7227848326743	-122.392656680249	(37.7227848326743, -122.392656680249)
177466	177466	32291	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1400 Egbert Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/15/1996 12:00:00 AM	7		Permit Number 36872	6014236.59	2091225.7906	37.722908348540294	-122.39288309530001	(37.7229083485403, -122.3928830953)
12618	12618	15750	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	4625 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	4X4		6002067.6674	2091962.7327	37.7242483928285	-122.43500115616301	(37.7242483928285, -122.435001156163)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
176490	176490	38608	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1570 Revere Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/09/2003 12:00:00 AM	6		Permit Number 45423	6015284.7491	2094285.2369	37.7313671428977	-122.38947335260099	(37.7313671428977, -122.389473352601)
61042	61042	38609	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1570 Revere Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/15/2002 12:00:00 AM	6		Permit Number 45423	6015273.2073	2094293.4811	37.7313891398709	-122.38951383063	(37.7313891398709, -122.38951383063)
185441	185441	38610	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1570 Revere Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/15/2002 12:00:00 AM	6		Permit Number 45423	6015263.8639	2094301.7253	37.7314112587254	-122.38954670833701	(37.7314112587254, -122.389546708337)
37094	37094	38611	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1570 Revere Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/17/1998 12:00:00 AM	6		Permit Number 40556	6015254.5205	2094308.8703	37.7314303593885	-122.389579509324	(37.7314303593885, -122.389579509324)
15892	15892	97244	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300X Keith St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3		6016216.2447	2094842.5281	37.7329489559822	-122.38629180873501	(37.7329489559822, -122.386291808735)
13740	13740	97243	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300X Keith St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3		6016226.9194	2094855.7145	37.7329857540551	-122.38625582218701	(37.7329857540551, -122.386255822187)
16688	16688	97242	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300X Keith St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3		6016235.0824	2094868.9009	37.7330224130953	-122.386228519291	(37.7330224130953, -122.386228519291)
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)
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)
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)
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)
31784	31784	98024	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1639 Taraval St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3x3		5988098.058999999	2098940.517	37.742604479099	-122.483802857352	(37.742604479099, -122.483802857352)
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)
20080	20080	38646	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	209 29th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/22/1998 12:00:00 AM			Permit Number 40570	6005214.92856016	2099001.03793316	37.7437522091261	-122.42462195934401	(37.7437522091261, -122.424621959344)
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)
32530	32530	97312	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	926 Taraval St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/19/1984 12:00:00 AM	10	3x3		5990212.18	2099077.2394	37.7431027248159	-122.476502906842	(37.7431027248159, -122.476502906842)
164818	164818	87369	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	926 Taraval St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/11/2008 12:00:00 AM	10	3x3	Permit Number 50349	5990243.3148	2099080.9621	37.7431147521003	-122.476395524083	(37.7431147521003, -122.476395524083)
74885	74885	97311	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	926 Taraval St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/19/1984 12:00:00 AM	7	3x3		5990303.3847	2099082.1466	37.7431214880079	-122.47618790715099	(37.7431214880079, -122.476187907151)
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)
133205	133205	62731	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2307 35th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/20/1993 12:00:00 AM	10		Permit Number 32015	5985442.2939	2099497.5593	37.7439790107491	-122.49302661105	(37.7439790107491, -122.49302661105)
110431	110431	113408	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1450 SANCHEZ ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6003890.0	2099760.0	37.74576122776671	-122.429257354108	(37.7457612277667, -122.429257354108)
78346	78346	113409	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	401x DUNCAN ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6003916.0	2099815.0	37.745913716911	-122.429171370863	(37.745913716911, -122.429171370863)
116559	116559	113410	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	401x DUNCAN ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6003916.0	2099815.0	37.745913716911	-122.429171370863	(37.745913716911, -122.429171370863)
92442	92442	37059	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1450 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/01/1998 12:00:00 AM		3x3	Permit Number 39663	6003906.83973736	2099821.31146391	37.745930528166596	-122.429203495744	(37.7459305281666, -122.429203495744)
111616	111616	37061	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1450 Sanchez St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/01/1998 12:00:00 AM		3x3	Permit Number 39663	6003906.83973736	2099821.31146391	37.745930528166596	-122.429203495744	(37.7459305281666, -122.429203495744)
139908	139908	37062	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1450 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/01/1998 12:00:00 AM		3x3	Permit Number 39663	6003906.83973736	2099821.31146391	37.745930528166596	-122.429203495744	(37.7459305281666, -122.429203495744)
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)
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)
17142	17142	545	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2878 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6009558.0762	2102211.8871	37.7528128183786	-122.40983092966101	(37.7528128183786, -122.409830929661)
17565	17565	542	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2870 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6009603.0598	2102213.6628	37.7528202149244	-122.40967549279199	(37.7528202149244, -122.409675492792)
21990	21990	528	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2836 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6009819.9871	2102225.5005	37.7528648722833	-122.408926150195	(37.7528648722833, -122.408926150195)
19393	19393	527	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2836 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6009841.2951	2102226.6843	37.7528693162895	-122.408852546362	(37.7528693162895, -122.408852546362)
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)
22172	22172	489	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2730 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3X3		6010359.8791	2102254.6242	37.7529750670361	-122.40706114707301	(37.7529750670361, -122.407061147073)
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)
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)
134348	134348	97114	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1345 Noriega St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7		Permit Number 18860	5989801.9904	2103085.8445	37.7540855022306	-122.47821424615101	(37.7540855022306, -122.478214246151)
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)
18161	18161	107661	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1312 CLAYTON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	3x3		5999086.9	2105066.2	37.7600576690463	-122.446247345124	(37.7600576690463, -122.446247345124)
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)
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)
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)
165135	165135	101264	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2000 Irving St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11		Permit Number 20727	5989453.6006	2106533.1127	37.7635305455459	-122.479671267422	(37.7635305455459, -122.479671267422)
26993	26993	101263	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2000 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12		Permit Number 20727	5989478.8752	2106534.6445	37.76353621964879	-122.479583963683	(37.7635362196488, -122.479583963683)
171803	171803	60926	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	2000 Irving St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/13/1983 12:00:00 AM	13		Permit Number 20727	5989507.2134	2106536.1763	37.7635420716385	-122.479486064031	(37.7635420716385, -122.479486064031)
157150	157150	43881	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1245 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/03/2000 12:00:00 AM	3		Permit Number 43494	5981473.1113	2106617.2091	37.7632946239394	-122.507278997702	(37.7632946239394, -122.507278997702)
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)

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