Street_Tree_List

Data source: data.sfgov.org

135 rows where SiteOrder = 2 and qSpecies = 94 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, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude ▼	Longitude	Location
87790	87790	32047	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	501 Tunnel Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/13/1999 12:00:00 AM			Permit Number 35428	6012610.0	2086139.0	37.7088505533644	-122.398149216451	(37.7088505533644, -122.398149216451)
157131	157131	176402	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	332 Ellington Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 2ft		5998803.89987	2087884.3075400002	37.7128641138726	-122.44599027982201	(37.7128641138726, -122.445990279822)
25064	25064	176406	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	75 Dichiera Ct	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 2ft		5998546.73235	2087959.10708	37.71305480791771	-122.446884509935	(37.7130548079177, -122.446884509935)
156993	156993	218813	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	317 Plymouth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5995878.91715	2088155.78665	37.7134420721779	-122.45611952571801	(37.7134420721779, -122.456119525718)
149042	149042	176415	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	850 Lisbon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 2ft		6001011.08243	2088875.9268	37.715712669668605	-122.43843255632099	(37.7157126696686, -122.438432556321)
181204	181204	176413	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	816 Lisbon St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6001088.39895	2089005.3588599998	37.7160724587542	-122.43817458219999	(37.7160724587542, -122.4381745822)
187298	187298	111610	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	301x Ward St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	9x3		6011193.26322	2089621.79675	37.71833459814221	-122.403290521257	(37.7183345981422, -122.403290521257)
11475	11475	13369	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	900 Mansell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	3X50		6009189.31279	2090017.3428599997	37.71930856033371	-122.410245275395	(37.7193085603337, -122.410245275395)
152250	152250	176426	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3338 San Bruno Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6011984.529	2089984.5422	37.719374784604895	-122.40058089900299	(37.7193747846049, -122.400580899003)
178907	178907	176419	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	638 Madrid St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 2ft		6002178.18938	2090229.77829	37.719496363045295	-122.43449524976002	(37.7194963630453, -122.43449524976)
48220	48220	218820	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	205 Beverly St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 5ft		5991411.7286	2090565.37313	37.7198007772708	-122.471735048829	(37.7198007772708, -122.471735048829)
33319	33319	218811	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	75 Williar Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5997101.63162	2090622.46989	37.7202851197392	-122.45207127696999	(37.7202851197392, -122.45207127697)
31299	31299	176423	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	538 Bacon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6009799.11271	2092612.1001799998	37.726467385945	-122.408320334118	(37.726467385945, -122.408320334118)
47472	47472	218808	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	379 Flood Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5			5998237.66884	2094066.68072	37.7298071263007	-122.448392288972	(37.7298071263007, -122.448392288972)
72056	72056	199433	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	1400 Newhall St	2	: 4	Tree 1	Private 1			9	Width 3ft		6014453.55095	2095806.16281	37.7354971746608	-122.39245332546601	(37.7354971746608, -122.392453325466)
137655	137655	199434	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	1711 Oakdale Ave	2	: 4	Tree 1	Private 1			6	Width 3ft		6014431.27107	2095902.0652700001	37.7357592658851	-122.39253706224501	(37.7357592658851, -122.392537062245)
14200	14200	26002	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	1711 Oakdale Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3X3		6014429.78226	2095903.68978	37.7357636437757	-122.392542323281	(37.7357636437757, -122.392542323281)
56084	56084	224631	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	667 Moultrie St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6007655.79797	2096256.88725	37.73635492642521	-122.415987700275	(37.7363549264252, -122.415987700275)
44217	44217	224657	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	710 Eugenia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6007803.71411	2097712.0639400003	37.740358836792495	-122.415579287554	(37.7403588367925, -122.415579287554)
121898	121898	33589	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	180 Bonview St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/27/1996 12:00:00 AM			Permit Number 37696	6007052.84530249	2097996.95756942	37.7410988557538	-122.41819569379	(37.7410988557538, -122.41819569379)
173739	173739	224639	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	150 Kingston St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6006112.4253	2098109.96948	37.7413561822494	-122.42145535528601	(37.7413561822494, -122.421455355286)
182314	182314	218832	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	1550 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5991196.18997	2098425.25378	37.7413695614616	-122.473052962144	(37.7413695614616, -122.473052962144)
137425	137425	218836	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	1550 17th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5991107.229069999	2098459.95547	37.741459692423796	-122.473363085249	(37.7414596924238, -122.473363085249)
135639	135639	224644	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	7 Heyman Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 3ft		6006402.40696	2098386.74463	37.7421324905292	-122.42047233962099	(37.7421324905292, -122.420472339621)
106430	106430	98025	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	1633 Taraval St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5988173.0	2098960.0	37.742662336498604	-122.48354516443199	(37.7426623364986, -122.483545164432)
103906	103906	48039	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	3350 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/11/2002 12:00:00 AM			Permit Number 45759	6006080.4837518	2098740.43590211	37.7430854999808	-122.42161056574	(37.7430854999808, -122.42161056574)
186397	186397	218803	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	2370 Funston Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		5992349.88043	2099344.31841	37.7439598068059	-122.46913081273199	(37.7439598068059, -122.469130812732)
122027	122027	224650	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	24 Prospect Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6007190.04837	2099393.66184	37.744941615564706	-122.417820274	(37.7449416155647, -122.417820274)
103877	103877	121142	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	100x Rutledge St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	9x6		6010389.0	2099533.0	37.7455037145463	-122.406768648836	(37.7455037145463, -122.406768648836)
33917	33917	224641	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	14 Powers Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006763.87284	2099814.11824	37.7460721011655	-122.41932373541901	(37.7460721011655, -122.419323735419)
187354	187354	218829	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	833 Rivera St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		5990502.9727	2100388.60646	37.746720259628	-122.475593168284	(37.746720259628, -122.475593168284)
16970	16970	23100	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	1406 Valencia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			27	3X3		6006427.47457	2101357.7543900004	37.7502916230775	-122.42059651712098	(37.7502916230775, -122.420596517121)
33898	33898	224685	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3513 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6006366.00015	2101408.94489	37.7504287157262	-122.420812733918	(37.7504287157262, -122.420812733918)
65026	65026	224689	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3514 25th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6006377.96332	2101451.22022	37.7505454684046	-122.420774365244	(37.7505454684046, -122.420774365244)
71668	71668	224681	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	1390 Valencia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6006415.878380001	2101496.97772	37.7506732449771	-122.42064649965499	(37.7506732449771, -122.420646499655)
20707	20707	24450	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	1384 Valencia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3X3		6006415.18821	2101529.37673	37.7507621663522	-122.42065118602301	(37.7507621663522, -122.420651186023)
107771	107771	116773	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	400 Vicksburg St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1					6004132.01414207	2101578.81224199	37.7507689616906	-122.42855012672399	(37.7507689616906, -122.428550126724)
164944	164944	224679	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	904 Capp St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			25	Width 3ft		6007366.7394199995	2101988.35955	37.752076011999605	-122.417393153575	(37.7520760119996, -122.417393153575)
152736	152736	224534	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3175 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6007849.05039	2102074.8141	37.752340521521	-122.41573136650601	(37.752340521521, -122.415731366506)
2012	2012	224703	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	3236 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	Width 3ft		6007440.93162	2102096.08231	37.7523759682811	-122.417144217627	(37.7523759682811, -122.417144217627)
157050	157050	224532	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3143 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			21	Width 3ft		6008098.46786	2102085.91434	37.7523850181574	-122.41486962353301	(37.7523850181574, -122.414869623533)
1962	1962	224700	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	3230 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	Width 3ft		6007513.40637	2102105.84325	37.7524068465217	-122.416894278962	(37.7524068465217, -122.416894278962)
19855	19855	602	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	3085 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	5x5		6008423.83472	2102105.59165	37.7524573245683	-122.413745839724	(37.7524573245683, -122.413745839724)
18516	18516	580	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	3013 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6008848.9981	2102129.16474	37.7525459176681	-122.412277214445	(37.7525459176681, -122.412277214445)
179949	179949	224528	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	281 Bartlett St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6006752.8545699995	2102173.9944599997	37.7525511643191	-122.41952923228901	(37.7525511643191, -122.419529232289)
19625	19625	571	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	2970 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		07/30/2015 12:00:00 AM	12	3x3		6009054.006130001	2102184.0831400002	37.752708212935794	-122.411572138748	(37.7527082129358, -122.411572138748)
177800	177800	224612	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	525 Burnett Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 2ft		5999484.75601	2102435.63345	37.752857494093206	-122.444682277976	(37.7528574940932, -122.444682277976)
46243	46243	224511	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	1117 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 4ft		6009227.24206	2102557.50534	37.7537432624556	-122.410999428875	(37.7537432624556, -122.410999428875)
20215	20215	24447	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	1156 Valencia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			25	3X3		6006347.0218400005	2102851.3253900004	37.754388091646	-122.420980760555	(37.754388091646, -122.420980760555)
49218	49218	224525	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	145 Bartlett St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6006711.819209999	2102941.19607	37.7546554124388	-122.419725571382	(37.7546554124388, -122.419725571382)
150231	150231	224709	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3278 22nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			23	Width 3ft		6006609.601919999	2103216.71936	37.755406177257704	-122.42009861917299	(37.7554061772577, -122.420098619173)
119749	119749	107384	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	73 HILL ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				9x6		6005896.4	2103362.0	37.7557648742481	-122.422575414787	(37.7557648742481, -122.422575414787)
163095	163095	224546	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3287 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6006409.4351	2103750.6223	37.7568608711517	-122.420828760756	(37.7568608711517, -122.420828760756)
32870	32870	224543	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3257 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		6006596.438630001	2103760.0556900003	37.7568973116766	-122.420182701267	(37.7568973116766, -122.420182701267)
151532	151532	199431	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	695 Arkansas St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 10ft		6013045.4631900005	2103845.54885	37.7574933220764	-122.39788541140499	(37.7574933220764, -122.397885411405)
41825	41825	226490	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	2450 Harrison St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		6008822.75268	2104167.00903	37.758139904958206	-122.412512013916	(37.7581399049582, -122.412512013916)
141164	141164	63515	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	3379 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/08/1987 12:00:00 AM			Permit Number 24124	6007714.38800344	2104402.20456648	37.758723433411	-122.416361886265	(37.758723433411, -122.416361886265)
68273	68273	224547	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3381 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6007651.432	2104404.91293	37.758727329511	-122.416579809432	(37.758727329511, -122.416579809432)
35607	35607	224556	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3361 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6007831.17362	2104415.66296	37.7587669536521	-122.415958939967	(37.7587669536521, -122.415958939967)
155012	155012	224558	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3349 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6007935.385009999	2104420.8922200003	37.7587871703981	-122.415598898179	(37.7587871703981, -122.415598898179)
26601	26601	224669	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	800 Florida St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 3ft		6009345.52709	2104457.09364	37.758965736194504	-122.410724513338	(37.7589657361945, -122.410724513338)
141964	141964	114015	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	800x ALABAMA ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6009320.0	2104474.0	37.7590107259363	-122.410813992367	(37.7590107259363, -122.410813992367)
185146	185146	224624	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	1323 Clayton St	2	: 4	Tree 1	Private 1			15	Width 3ft		5999021.66534	2105005.43313	37.7598870925388	-122.446468587874	(37.7598870925388, -122.446468587874)
55616	55616	226483	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3470 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6006409.05576	2104966.19294	37.7601985241524	-122.420916373596	(37.7601985241524, -122.420916373596)
175285	175285	226493	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	2300 Harrison St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6008772.32666	2104949.6501700003	37.7602860290962	-122.41274173856002	(37.7602860290962, -122.41274173856)
178689	178689	226475	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3160 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6008399.696219999	2105072.76604	37.760603155239295	-122.41403920664301	(37.7606031552393, -122.414039206643)
47182	47182	224514	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	439 Shotwell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6007856.97968	2105196.19408	37.760911563330296	-122.415924962689	(37.7609115633303, -122.415924962689)
122713	122713	60714	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	21 Oakwood St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/23/1989 12:00:00 AM			Permit Number 20367	6005264.975818	2105333.47768938	37.761142446432096	-122.424899339668	(37.7611424464321, -122.424899339668)
184726	184726	224575	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3143 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6008614.79517	2105624.76629	37.7621309001374	-122.413334311737	(37.7621309001374, -122.413334311737)
154231	154231	226486	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3120 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		6008522.957719999	2105665.90861	37.7622387108737	-122.41365485348801	(37.7622387108737, -122.413654853488)
104854	104854	92018	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	4182 17th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6001163.0	2105841.0	37.7623034284238	-122.439122658321	(37.7623034284238, -122.439122658321)
157746	157746	112160	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	1328 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	3x3		6013587.23518	2105720.84823	37.7626726418425	-122.396143156607	(37.7626726418425, -122.396143156607)
165442	165442	224493	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	232 Upper Ter	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		5999538.9593	2106236.29263	37.7632962596403	-122.444768001354	(37.7632962596403, -122.444768001354)
53817	53817	224489	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	24 Alma St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		5998519.39636	2106289.8820599997	37.763385166627295	-122.44829817853399	(37.7633851666273, -122.448298178534)
141220	141220	34143	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	400 Treat Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/13/1997 12:00:00 AM			Permit Number 37990	6008524.65557539	2106230.12436926	37.7637880127631	-122.41368889061701	(37.7637880127631, -122.413688890617)
124911	124911	101249	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	734 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5993518.0	2106670.0	37.764141669108	-122.46562386166799	(37.764141669108, -122.465623861668)
37859	37859	224591	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	3117 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6006001.0018	2106651.39278	37.7648026771212	-122.42244738485701	(37.7648026771212, -122.422447384857)
19766	19766	5379	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	299 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			60	4X4		6004899.9834	2106715.40982	37.764916280383	-122.426260083162	(37.764916280383, -122.426260083162)
32026	32026	224492	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	60 Parnassus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 4ft		5998346.422619999	2106894.64873	37.7650358128629	-122.448940002185	(37.7650358128629, -122.448940002185)
84518	84518	101285	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	1236 09th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Permit Number 11316	5993350.8	2107040.7	37.7651498684815	-122.466229094974	(37.7651498684815, -122.466229094974)
129826	129826	224588	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	2765 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6008276.684169999	2106776.8374099997	37.7652752322039	-122.414585240843	(37.7652752322039, -122.414585240843)
106386	106386	116389	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	2701 16TH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6008575.9	2106772.6	37.7652804030783	-122.413550020856	(37.7652804030783, -122.413550020856)
43555	43555	224584	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	2701 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6008542.99689	2106795.22797	37.76534068665	-122.41366542593799	(37.76534068665, -122.413665425938)
83043	83043	108962	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	2395x 15TH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1					6001858.0	2107008.0	37.7655472468341	-122.436802461881	(37.7655472468341, -122.436802461881)
125826	125826	104403	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	2362 15th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		18	3x3	Permit Number 24809	6002031.0	2107070.0	37.7657273142687	-122.436208531898	(37.7657273142687, -122.436208531898)
128320	128320	121150	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	1918 15th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		24			6004687.86766006	2107227.29036829	37.766309789844996	-122.42703019928601	(37.766309789845, -122.427030199286)
31967	31967	224626	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	601 Buena Vista Ave West	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5999843.00884	2107568.58853	37.7669717582745	-122.443812120926	(37.7669717582745, -122.443812120926)
4239	4239	244052	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	401 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		5997900.6668	2109181.4943	37.771289404865	-122.450646641766	(37.771289404865, -122.450646641766)
124771	124771	105685	Property Tree 7	Ficus microcarpa :: Chinese Banyan 94	635 08TH ST	2	Front Yard : Pot 30	Tree 1	Private 1			8			6011418.5	2109097.9	37.7718243537934	-122.40388172759701	(37.7718243537934, -122.403881727597)
91896	91896	33764	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	1580 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/23/1996 12:00:00 AM			Permit Number 37815	6007223.30298499	2109757.94023834	37.7734013999863	-122.418440043785	(37.7734013999863, -122.418440043785)
78322	78322	33615	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	312 Lily St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/02/1996 12:00:00 AM			Permit Number 37724	6005030.32834442	2110083.71933458	37.7741722139784	-122.42604905489999	(37.7741722139784, -122.4260490549)
108270	108270	33611	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	310 Lily St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/02/1996 12:00:00 AM			Permit Number 37722	6005039.5469288	2110085.00234602	37.774176257824394	-122.42601725751001	(37.7741762578244, -122.42601725751)
111715	111715	33610	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	308 Lily St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/02/1996 12:00:00 AM			Permit Number 37721	6005048.76551317	2110086.28535746	37.774180301661794	-122.42598546011699	(37.7741803016618, -122.425985460117)
95737	95737	98531	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	701X 14th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5991613.7	2110635.6	37.77492011755329	-122.472499350726	(37.7749201175533, -122.472499350726)
143551	143551	111900	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	650X Fillmore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/05/2016 12:00:00 AM	3			6003603.61647971	2110556.18401653	37.7753887478808	-122.43101802993601	(37.7753887478808, -122.431018029936)
79998	79998	115675	Undocumented 2	Ficus microcarpa :: Chinese Banyan 94	650 23rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5988846.1	2110886.2	37.7754476168018	-122.482091316315	(37.7754476168018, -122.482091316315)
112402	112402	115026	DPW Maintained 3	Ficus microcarpa :: Chinese Banyan 94	1009 HARRISON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				3x10		6011058.0	2110680.0	37.776148288994705	-122.405240157274	(37.7761482889947, -122.405240157274)
123497	123497	33634	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	416 Linden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/03/1996 12:00:00 AM			Permit Number 37730	6005394.17412308	2110828.6660173	37.7762382136369	-122.424843455434	(37.7762382136369, -122.424843455434)
106522	106522	33651	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	284 Linden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/03/1996 12:00:00 AM			Permit Number 37742	6006036.93235026	2110918.36759919	37.776520795938	-122.422626351394	(37.776520795938, -122.422626351394)
85365	85365	30533	Permitted Site 1	Ficus microcarpa :: Chinese Banyan 94	1020 Harrison St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/25/1995 12:00:00 AM			Permit Number 34535	6011195.92412392	2110919.1949505	37.776812772940005	-122.404779881684	(37.77681277294, -122.404779881684)

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