Street_Tree_List

Data source: data.sfgov.org

262 rows where qSiteInfo = 4 and qSpecies = 15

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

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
730	730	195047	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	360 06th St	2	: 4	Tree 1	DPW 2		03/26/2005 12:00:00 AM	3	Width 3ft	Permit Number 42039	6011214.59355	2111232.18316	37.777673209496605	-122.404737337955	(37.7776732094966, -122.404737337955)
748	748	195045	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	312 06th St	1	: 4	Tree 1	DPW 2			10	Width 3ft		6010980.17572	2111476.79231	37.7783317443601	-122.40556550564501	(37.7783317443601, -122.405565505645)
761	761	195041	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	402 06th St	1	: 4	Tree 1	DPW 2			28	Width 3ft		6011480.36813	2111044.01847	37.777171403968296	-122.40380468436199	(37.7771714039683, -122.403804684362)
1168	1168	218199	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	819 Ulloa St	1	: 4	Tree 1	DPW 2			13	Width 3ft		5993346.67502	2098141.32486	37.740714236277	-122.46559677389799	(37.740714236277, -122.465596773898)
23411	23411	195158	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1188 Rhode Island St	1	: 4	Tree 1	Private 1			14	Width 4ft		6011916.5871	2102892.02207	37.7548122137394	-122.401722520004	(37.7548122137394, -122.401722520004)
23518	23518	247709	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	848 Waller St	1	: 4	Tree 1	Private 1			16	Width 4ft		6001610.36211	2108740.78692	37.7702909742819	-122.437783100124	(37.7702909742819, -122.437783100124)
23741	23741	234546	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	390 Valencia St	3	: 4	Tree 1	Private 1			8	Width 4ft		6006093.30748	2107339.39133	37.7666969650198	-122.422177005484	(37.7666969650198, -122.422177005484)
24318	24318	195049	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	425 07th St	1	: 4	Tree 1	Private 1			8	Width 3ft		6011046.10585	2110191.14121	37.7748053308349	-122.405246869567	(37.7748053308349, -122.405246869567)
24505	24505	195054	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	820 Bryant St	1	: 4	Tree 1	Private 1			18	Width 3ft		6011686.5663	2110516.6477900003	37.775734882702295	-122.403054272047	(37.7757348827023, -122.403054272047)
26286	26286	247164	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	181 Buena Vista Ave East	1	: 4	Tree 1	Private 1			4	Width 3ft		6001468.5616	2108335.5699400003	37.76917028501371	-122.438244553041	(37.7691702850137, -122.438244553041)
26445	26445	195159	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1190 Rhode Island St	1	: 4	Tree 1	Private 1			9	Width 4ft		6011918.3427099995	2102871.98584	37.7547572966145	-122.40171504034201	(37.7547572966145, -122.401715040342)
26551	26551	247735	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3 Broderick St	1	: 4	Tree 1	Private 1			20	Width 4ft		6001364.01922	2108734.36535	37.770259331626896	-122.43863473741199	(37.7702593316269, -122.438634737412)
26680	26680	234541	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	380 Valencia St	2	: 4	Tree 1	Private 1			6	Width 4ft		6006086.8772	2107446.3407400004	37.766990260030106	-122.422206845872	(37.7669902600301, -122.422206845872)
26845	26845	195029	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	603 02nd St	1	: 4	Tree 1	Private 1			5	Width 3ft		6013830.29257	2113762.02506	37.7847654277311	-122.39586599541599	(37.7847654277311, -122.395865995416)
27339	27339	178600	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	6	: 4	Tree 1	Private 1			6	Width 0ft		5989476.93903	2093627.59215	37.7280967254778	-122.478646687712	(37.7280967254778, -122.478646687712)
27627	27627	195043	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	377 06th St	1	: 4	Tree 1	Private 1			12	Width 3ft		6011353.00653	2111183.55828	37.777547432096206	-122.404255094506	(37.7775474320962, -122.404255094506)
28526	28526	218250	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2751 14th Ave	1	: 4	Tree 1	Private 1			14	Width 3ft		5992235.80201	2097238.62713	37.738171520993	-122.469372026199	(37.738171520993, -122.469372026199)
28563	28563	236251	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	95 McCoppin St	3	: 4	Tree 1	Private 1			3	Width 3ft		6006130.65343	2109099.12846	37.77153089025921	-122.42217286498501	(37.7715308902592, -122.422172864985)
29027	29027	218251	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2751 14th Ave	2	: 4	Tree 1	Private 1			11	Width 3ft		5992250.04874	2097220.76826	37.738123308341706	-122.46932146901301	(37.7381233083417, -122.469321469013)
29514	29514	247770	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	827 Waller St	1	: 4	Tree 1	Private 1			10	Width 3ft		6001730.80568	2108705.46895	37.77020084782	-122.437363957589	(37.77020084782, -122.437363957589)
29631	29631	250970	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	6932 California St	1	: 4	Tree 1	Private 1			9	Width 4ft		5985996.4910699995	2113927.35673	37.7836316119485	-122.49217262437	(37.7836316119485, -122.49217262437)
30229	30229	247702	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	800 Waller St	4	: 4	Tree 1	Private 1			7	Width 4ft		6001763.91466	2108760.8160200003	37.770354699327	-122.43725339763701	(37.770354699327, -122.437253397637)
30598	30598	247170	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	145 Buena Vista Ave East	1	: 4	Tree 1	Private 1			3	Width 4ft		6001370.95103	2108474.04291	37.7695449452612	-122.438592105046	(37.7695449452612, -122.438592105046)
30749	30749	247700	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	800 Waller St	2	: 4	Tree 1	Private 1			10	Width 4ft		6001801.87342	2108765.96342	37.7703709905579	-122.43712246712099	(37.7703709905579, -122.437122467121)
31067	31067	249497	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1765 California St	2	: 4	Tree 1	Private 1			9	Width 3ft		6005893.50071	2115878.2456799997	37.7901313082605	-122.423475218205	(37.7901313082605, -122.423475218205)
31149	31149	247701	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	800 Waller St	3	: 4	Tree 1	Private 1			11	Width 4ft		6001785.70024	2108763.50636	37.770363324741794	-122.43717823411001	(37.7703633247418, -122.43717823411)
31305	31305	247769	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	845 Waller St	3	: 4	Tree 1	Private 1			10	Width 3ft		6001717.5162	2108703.54506	37.7701948097837	-122.437409787932	(37.7701948097837, -122.437409787932)
32042	32042	247704	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	824 Waller St	1	: 4	Tree 1	Private 1			16	Width 5ft		6001711.33695	2108752.8722599996	37.7703298987379	-122.43743469466101	(37.7703298987379, -122.437434694661)
32108	32108	247728	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Broderick St	5	: 4	Tree 1	Private 1			25	Width 6ft		6001337.82386	2108917.42217	37.7707604698615	-122.43873846612101	(37.7707604698615, -122.438738466121)
32371	32371	201999	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Paul Ave	2	: 4	Tree 1	Private 1			4	Width 3ft		6012837.45496	2091269.25359	37.7229498748073	-122.397722694373	(37.7229498748073, -122.397722694373)
32634	32634	195160	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1190 Rhode Island St	2	: 4	Tree 1	Private 1			13	Width 4ft		6011919.16564	2102851.6607	37.754701534158	-122.401710765865	(37.754701534158, -122.401710765865)
32756	32756	195051	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	425 07th St	3	: 4	Tree 1	Private 1			7	Width 3ft		6011026.68286	2110214.90007	37.7748694812702	-122.40531573155701	(37.7748694812702, -122.405315731557)
33230	33230	201628	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	401 Galvez Ave	12	: 4	Tree 1	Private 1			13	Width 3ft		6021496.8135400005	2093398.7623299998	37.729275520830996	-122.36793562924	(37.729275520831, -122.36793562924)
33444	33444	236255	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	155 Valencia St	1	: 4	Tree 1	Private 1			13	Width 4ft		6006074.21753	2108882.3797400002	37.7709325668056	-122.42235267724399	(37.7709325668056, -122.422352677244)
33448	33448	250973	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	7010 California St	2	: 4	Tree 1	Private 1			2	Width 4ft		5985735.07087	2113919.4528200002	37.7835946246316	-122.493076443038	(37.7835946246316, -122.493076443038)
33901	33901	195058	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1118 Harrison St	1	: 4	Tree 1	Private 1			8	Width 3ft		6010609.31709	2110367.7626099996	37.7752658628632	-122.406770269844	(37.7752658628632, -122.406770269844)
33958	33958	247718	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Broderick St	2	: 4	Tree 1	Private 1			15	Width 3ft		6001406.2939	2108761.0042	37.7703348800695	-122.438490418696	(37.7703348800695, -122.438490418696)
34435	34435	247717	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2 Broderick St	1	: 4	Tree 1	Private 1			14	Width 3ft		6001409.94207	2108737.73214	37.770271188299	-122.43847613207399	(37.770271188299, -122.438476132074)
34448	34448	195201	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	201 Rankin St	4	: 4	Tree 1	Private 1			7	Width 4ft		6014735.86247	2099450.505	37.745519458775	-122.391731990932	(37.745519458775, -122.391731990932)
34606	34606	178520	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	74 Kelloch Ave	2	: 4	Tree 1	Private 1			10	Width 3ft		6008160.20585	2086291.9091900003	37.7090215544595	-122.413539180899	(37.7090215544595, -122.413539180899)
34947	34947	247768	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	845 Waller St	2	: 4	Tree 1	Private 1			10	Width 3ft		6001677.287330001	2108698.14738	37.7701777019594	-122.437548552425	(37.7701777019594, -122.437548552425)
34963	34963	195198	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	201 Rankin St	1	: 4	Tree 1	Private 1			12	Width 4ft		6014650.6097	2099336.7503299997	37.745202379392204	-122.392018830619	(37.7452023793922, -122.392018830619)
35225	35225	195038	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	400 02nd St	5	: 4	Tree 1	Private 1			10	Width 0ft		6014100.3392	2113471.11724	37.7839816811421	-122.394911334515	(37.7839816811421, -122.394911334515)
35398	35398	234531	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	145 Valencia St	2	: 4	Tree 1	Private 1			10	Width 4ft		6006070.04124	2108984.02475	37.771211424088705	-122.422374346422	(37.7712114240887, -122.422374346422)
35440	35440	195056	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	403 06th St	3	: 4	Tree 1	Private 1			37	Width 3ft		6011448.2097	2110981.26163	37.7769972916145	-122.403911513916	(37.7769972916145, -122.403911513916)
35767	35767	234556	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	389 Webster St	2	: 4	Tree 1	Private 1			12	Width 3ft		6004113.19649	2110015.3109999998	37.773932504618394	-122.42921669790199	(37.7739325046184, -122.429216697902)
36059	36059	218252	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2751 14th Ave	3	: 4	Tree 1	Private 1			8	Width 3ft		5992261.85147	2097209.38473	37.738092734087296	-122.469279833118	(37.7380927340873, -122.469279833118)
36451	36451	178598	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	4	: 4	Tree 1	Private 1			4	Width 0ft		5989486.74208	2093594.0787	37.728005275220795	-122.478610348783	(37.7280052752208, -122.478610348783)
36471	36471	249578	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1075 Ofarrell St	1	: 4	Tree 1	Private 1			3	Width 4ft		6006167.298690001	2113834.65662	37.7845355682182	-122.42238263454901	(37.7845355682182, -122.422382634549)
37327	37327	195182	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	469 Mississippi St	2	: 4	Tree 1	Private 1			12	Width 3ft		6014105.1082	2104950.4449299998	37.760586083411496	-122.39429806340901	(37.7605860834115, -122.394298063409)
38428	38428	234555	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	389 Webster St	1	: 4	Tree 1	Private 1			13	Width 4ft		6004106.69081	2110050.7121099997	37.774029339102604	-122.42924172694799	(37.7740293391026, -122.429241726948)
38717	38717	195183	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	332 Mississippi St	1	: 4	Tree 1	Private 1			12	Width 4ft		6014016.45391	2105493.17389	37.7620713704081	-122.39464268723499	(37.7620713704081, -122.394642687235)
38838	38838	250972	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	7010 California St	1	: 4	Tree 1	Private 1			3	Width 4ft		5985754.51701	2113919.45983	37.78359578115	-122.493009168333	(37.78359578115, -122.493009168333)
39172	39172	249503	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1701 California St	2	: 4	Tree 1	Private 1			11	Width 4ft		6006124.55833	2115911.6764700003	37.7902361395269	-122.42267815269	(37.7902361395269, -122.42267815269)
39835	39835	249406	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	430 Turk St	2	: 4	Tree 1	Private 1			7	Width 4ft		6007876.35705	2113080.52014	37.7825611516116	-122.416416421504	(37.7825611516116, -122.416416421504)
40505	40505	247725	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Broderick St	2	: 4	Tree 1	Private 1			19	Width 5ft		6001330.00617	2108965.19653	37.770891201597706	-122.43876893155701	(37.7708912015977, -122.438768931557)
41040	41040	133604	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	680 Hayes St	2	: 4	Tree 1	Private 1			12	Width 3ft		6004598.25031	2110892.9208299997	37.776369653876	-122.42760135363599	(37.776369653876, -122.427601353636)
41308	41308	249579	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1075 Ofarrell St	2	: 4	Tree 1	Private 1			13	Width 4ft		6006196.8635599995	2113838.7840400003	37.7845485688079	-122.42228064334	(37.7845485688079, -122.42228064334)
42190	42190	247167	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	165 Buena Vista Ave East	1	: 4	Tree 1	Private 1			2	Width 5ft		6001410.43001	2108421.56043	37.7694030871159	-122.43845178832301	(37.7694030871159, -122.438451788323)
42914	42914	195153	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	747 Rhode Island St	1	: 4	Tree 1	Private 1			16	Width 3ft		6011866.39234	2104881.06105	37.7602708746342	-122.402035931016	(37.7602708746342, -122.402035931016)
44065	44065	195063	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1440 Harrison St	25	: 4	Tree 1	Private 1			12	Width 3ft		6009088.88483	2108916.86222	37.7711968415799	-122.41192726035901	(37.7711968415799, -122.411927260359)
44707	44707	178595	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3353 19th Ave	7	: 4	Tree 1	Private 1			4	Width 3ft		5990558.26669	2094238.61672	37.729837169035896	-122.474953123505	(37.7298371690359, -122.474953123505)
45448	45448	195069	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1532 Bryant St	1	: 4	Tree 1	Private 1			13	Width 3ft		6008781.51623	2108669.00103	37.7704990234538	-122.412972936267	(37.7704990234538, -122.412972936267)
45803	45803	178597	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	2	: 4	Tree 1	Private 1			11	Width 0ft		5989487.40549	2093535.0648700001	37.727843276732	-122.47860374149201	(37.727843276732, -122.478603741492)
45940	45940	249496	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1765 California St	1	: 4	Tree 1	Private 1			11	Width 3ft		6005857.5459	2115873.8651400004	37.7901172509642	-122.423599307579	(37.7901172509642, -122.423599307579)
46205	46205	247708	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	844 Waller St	2	: 4	Tree 1	Private 1			14	Width 4ft		6001638.27967	2108743.56239	37.770300182441396	-122.43768673235901	(37.7703001824414, -122.437686732359)
47110	47110	249491	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1899 California St	1	: 4	Tree 1	Private 1			9	Width 3ft		6005331.84329	2115802.8856200003	37.7898926713456	-122.42541314481899	(37.7898926713456, -122.425413144819)
48043	48043	195174	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2200 23rd St	2	: 4	Tree 1	Private 1			18	Width 4ft		6011890.90332	2102824.4567400003	37.75462526086329	-122.401806593102	(37.7546252608633, -122.401806593102)
48663	48663	247726	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	49 Broderick St	3	: 4	Tree 1	Private 1			20	Width 5ft		6001333.54559	2108953.84659	37.770860238851	-122.438755875203	(37.770860238851, -122.438755875203)
48811	48811	249561	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1336 Post St	1	: 4	Tree 1	Private 1			9	Width 4ft		6005719.13803	2114518.05825	37.7863867291032	-122.423981734369	(37.7863867291032, -122.423981734369)
48949	48949	195178	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1512 19th St	2	: 4	Tree 1	Private 1			9	Width 3ft		6013083.6982	2105226.1685599997	37.761286330631705	-122.39785002128201	(37.7612863306317, -122.397850021282)
50017	50017	234534	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	250 Valencia St	7	: 4	Tree 1	Private 1			3	Width 4ft		6006047.6437099995	2108148.24766	37.7689153164221	-122.42239242639499	(37.7689153164221, -122.422392426395)
50634	50634	195217	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Davidson Ave	6	: 4	Tree 1	Private 1			7	Width 4ft		6014951.137519999	2099351.9188	37.7452607094218	-122.390980708107	(37.7452607094218, -122.390980708107)
50863	50863	201629	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	401 Galvez Ave	13	: 4	Tree 1	Private 1			6	Width 3ft		6021522.6239599995	2093379.49172	37.7292240220626	-122.36784506930599	(37.7292240220626, -122.367845069306)
51866	51866	195042	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	402 06th St	2	: 4	Tree 1	Private 1			26	Width 3ft		6011470.44747	2111056.37562	37.7772047796221	-122.403839873012	(37.7772047796221, -122.403839873012)
53264	53264	195162	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	795 Wisconsin St	1	: 4	Tree 1	Private 1			11	Width 3ft		6012759.21465	2103840.23662	37.757462790085505	-122.398875007375	(37.7574627900855, -122.398875007375)
53391	53391	247744	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	883 Waller St	2	: 4	Tree 1	Private 1			10	Width 3ft		6001433.04575	2108666.05227	37.7700756873626	-122.43839108048701	(37.7700756873626, -122.438391080487)
53811	53811	236253	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	95 McCoppin St	5	: 4	Tree 1	Private 1			11	Width 3ft		6006170.16969	2109101.8157599997	37.771540497736	-122.42203636681002	(37.771540497736, -122.42203636681)
54031	54031	195048	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	972 Harrison St	1	: 4	Tree 1	Private 1			6	Width 3ft		6011557.47777	2111276.51423	37.7778140909953	-122.403554297789	(37.7778140909953, -122.403554297789)
54039	54039	217737	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	715 Frederick St	2	: 4	Tree 1	Private 1			6	Width 3ft		5996153.98558	2107236.09361	37.7658477046389	-122.45654774598499	(37.7658477046389, -122.456547745985)
54189	54189	195202	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	201 Rankin St	5	: 4	Tree 1	Private 1			8	Width 4ft		6014746.50414	2099463.9870599997	37.7455570684194	-122.391696135872	(37.7455570684194, -122.391696135872)
54355	54355	195037	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	712 Harrison St	8	: 4	Tree 1	Private 1			7	Width 3ft		6013186.23723	2112830.2440400003	37.782171121043795	-122.398028840679	(37.7821711210438, -122.398028840679)
54412	54412	195169	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	8	: 4	Tree 1	Private 1			13	Width 3ft		6012684.972080001	2104240.58685	37.7585579269363	-122.39915987123699	(37.7585579269363, -122.399159871237)
54768	54768	249510	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1301 Van Ness Ave	5	: 4	Tree 1	Private 1			7	Width 1ft		6006317.71181	2114977.4898599996	37.7876819902699	-122.421943465924	(37.7876819902699, -122.421943465924)
55191	55191	133603	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	662 Hayes St	2	: 4	Tree 1	Private 1			11	Width 3ft		6004673.73333	2110903.67068	37.776403439601395	-122.427341002593	(37.7764034396014, -122.427341002593)
55403	55403	250969	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	6924 California St	3	: 4	Tree 1	Private 1			8	Width 4ft		5986098.00978	2113930.24714	37.7836454821978	-122.49182162619199	(37.7836454821978, -122.491821626192)
56289	56289	195170	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	859 Wisconsin St	1	: 4	Tree 1	Private 1			10	Width 3ft		6012783.82646	2103478.80555	37.756471750696	-122.39876452475599	(37.756471750696, -122.398764524756)
56426	56426	250971	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	7002 California St	1	: 4	Tree 1	Private 1			10	Width 4ft		5985825.16294	2113921.74383	37.783606183626105	-122.492764932276	(37.7836061836261, -122.492764932276)
56850	56850	249576	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1099 Ofarrell St	2	: 4	Tree 1	Private 1			2	Width 4ft		6006111.66082	2113826.64553	37.784510433048	-122.422574553491	(37.784510433048, -122.422574553491)
57677	57677	247175	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	123 Buena Vista Ave East	1	: 4	Tree 1	Private 1			1	Width 4ft		6001310.87705	2108552.6778700002	37.7697574397749	-122.438805533953	(37.7697574397749, -122.438805533953)
57690	57690	195191	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Industrial St	8	: 4	Tree 1	Private 1			18	Width 4ft		6011603.00952	2097270.79889	37.7393600461416	-122.402411733411	(37.7393600461416, -122.402411733411)
58185	58185	234552	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	599 Buchanan St	1	: 4	Tree 1	Private 1			17	Width 5ft		6004546.97055	2110414.43601	37.775052951057	-122.42774464441999	(37.775052951057, -122.42774464442)
58618	58618	247713	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	880 Waller St	1	: 4	Tree 1	Private 1			13	Width 3ft		6001495.04463	2108722.80835	37.7702350517434	-122.438180694009	(37.7702350517434, -122.438180694009)
59189	59189	195165	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	2	: 4	Tree 1	Private 1			18	Width 3ft		6012683.25425	2104289.74415	37.758692806358	-122.39916926286301	(37.758692806358, -122.399169262863)
60565	60565	195067	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Bryant St	3	: 4	Tree 1	Private 1			8	Width 3ft		6008874.83792	2108609.10047	37.7703397885684	-122.412645899583	(37.7703397885684, -122.412645899583)
60947	60947	249585	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1001 Ofarrell St	7	: 4	Tree 1	Private 1			15	Width 4ft		6006400.946280001	2113866.78963	37.7846369748603	-122.421576574896	(37.7846369748603, -122.421576574896)
62440	62440	178519	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	74 Kelloch Ave	1	: 4	Tree 1	Private 1			11	Width 3ft		6008207.90106	2086273.84024	37.7089746188665	-122.413373061735	(37.7089746188665, -122.413373061735)
62547	62547	195059	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1118 Harrison St	2	: 4	Tree 1	Private 1			8	Width 3ft		6010590.86916	2110351.5216200002	37.775220236657795	-122.406832940881	(37.7752202366578, -122.406832940881)
62830	62830	218177	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2800 15th Ave	1	: 4	Tree 1	Private 1			12	Width 3ft		5991929.371230001	2096655.3503299998	37.736552277270704	-122.470389035343	(37.7365522772707, -122.470389035343)
63212	63212	250055	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1338 Franklin St	5	: 4	Tree 1	Private 1			7	Width 4ft		6005925.95493	2114827.43297	37.7872478695325	-122.423288199717	(37.7872478695325, -122.423288199717)

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