Street_Tree_List

Data source: data.sfgov.org

11,394 rows where qSpecies = 15 sorted by qSiteInfo descending

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

- 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: qCaretaker, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo ▲	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
137300	137300	142638	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	333 BAY ST	2	unknown : Yard 19	Tree 1	Private 1			8	Width 0ft		6009068.3546	2121458.9525	37.8056332348144	-122.41288516543301	(37.8056332348144, -122.412885165433)
137444	137444	142738	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	333 BAY ST	3	unknown : Yard 19	Tree 1	Private 1			11	Width 0ft		6009098.7568	2121462.5595	37.805644845194	-122.412780209055	(37.805644845194, -122.412780209055)
25897	25897	134510	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	9	Side Yard : Yard 17	Tree 1	Private 1			18	Width 4ft		6008017.687530001	2112101.62184	37.7798812789472	-122.415858138542	(37.7798812789472, -122.415858138542)
26079	26079	134508	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	7	Side Yard : Yard 17	Tree 1	Private 1			17	Width 4ft		6008055.00417	2112104.50717	37.7798912991906	-122.41572924771499	(37.7798912991906, -122.415729247715)
32078	32078	195081	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	23	Side Yard : Yard 17	Tree 1	Private 1			9	Width 4ft		6014990.50186	2103171.25593	37.7557499880963	-122.391111501888	(37.7557499880963, -122.391111501888)
40126	40126	134511	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	10	Side Yard : Yard 17	Tree 1	Private 1			21	Width 4ft		6008018.559330001	2112114.37672	37.7799163498009	-122.41585602603399	(37.7799163498009, -122.415856026034)
41420	41420	195079	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	21	Side Yard : Yard 17	Tree 1	Private 1			9	Width 4ft		6014986.69812	2103234.99475	37.755924790211395	-122.391129111534	(37.7559247902114, -122.391129111534)
43990	43990	134521	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	20	Side Yard : Yard 17	Tree 1	Private 1			14	Width 4ft		6007806.05941	2112087.1007	37.7798295076742	-122.416589227122	(37.7798295076742, -122.416589227122)
44987	44987	134512	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	11	Side Yard : Yard 17	Tree 1	Private 1			13	Width 4ft		6007952.73516	2112091.3955099997	37.7798495481525	-122.416082113806	(37.7798495481525, -122.416082113806)
47340	47340	195222	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	900 Phelps St	6	Side Yard : Yard 17	Tree 1	Private 1			12	Width 7ft		6014590.36228	2097114.26531	37.739096551976	-122.392071762927	(37.739096551976, -122.392071762927)
48783	48783	195082	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	24	Side Yard : Yard 17	Tree 1	Private 1			9	Width 4ft		6014993.20082	2103136.83485	37.755655624926895	-122.39109976213899	(37.7556556249269, -122.391099762139)
57595	57595	134520	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	19	Side Yard : Yard 17	Tree 1	Private 1			18	Width 4ft		6007809.423690001	2112072.4347	37.779789427567	-122.41657654936199	(37.779789427567, -122.416576549362)
60593	60593	134509	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	8	Side Yard : Yard 17	Tree 1	Private 1			28	Width 4ft		6008051.61488	2112117.95752	37.7799280400987	-122.415741925456	(37.7799280400987, -122.415741925456)
62669	62669	195221	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	900 Phelps St	5	Side Yard : Yard 17	Tree 1	Private 1			9	Width 7ft		6014598.7472	2097125.5339900001	37.739127958984106	-122.392043559277	(37.7391279589841, -122.392043559277)
66598	66598	134503	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	2	Side Yard : Yard 17	Tree 1	Private 1			3	Width 4ft		6008163.02923	2112130.27379	37.7799681201757	-122.41535736455799	(37.7799681201757, -122.415357364558)
70214	70214	134516	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	15	Side Yard : Yard 17	Tree 1	Private 1			7	Width 4ft		6007879.23543	2112081.34439	37.7798178173801	-122.416335670458	(37.7798178173801, -122.416335670458)
70475	70475	134506	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	5	Side Yard : Yard 17	Tree 1	Private 1			22	Width 4ft		6008094.26451	2112112.8267900003	37.779916349808396	-122.41559401757699	(37.7799163498084, -122.415594017577)
73716	73716	134514	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	13	Side Yard : Yard 17	Tree 1	Private 1			15	Width 4ft		6007916.55212	2112084.22953	37.779827837626705	-122.41620677962	(37.7798278376267, -122.41620677962)
77273	77273	195083	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	25	Side Yard : Yard 17	Tree 1	Private 1			10	Width 4ft		6014995.62835	2103102.9826	37.755562808578404	-122.391089000875	(37.7555628085784, -122.391089000875)
137288	137288	134517	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	16	Side Yard : Yard 17	Tree 1	Private 1			7	Width 4ft		6007880.14491	2112095.92317	37.7798578983531	-122.41633355704599	(37.7798578983531, -122.416333557046)
137329	137329	134502	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	1	Side Yard : Yard 17	Tree 1	Private 1			27	Width 4ft		6008165.1975300005	2112116.84845	37.779931379274004	-122.415348912733	(37.779931379274, -122.415348912733)
138148	138148	134518	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	17	Side Yard : Yard 17	Tree 1	Private 1			6	Width 4ft		6007848.65925	2112079.5377	37.7798111372171	-122.41644131921801	(37.7798111372171, -122.416441319218)
147962	147962	195223	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	900 Phelps St	7	Side Yard : Yard 17	Tree 1	Private 1			10	Width 7ft		6014580.60262	2097100.86929	37.7390592273959	-122.392104571083	(37.7390592273959, -122.392104571083)
153139	153139	134513	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	12	Side Yard : Yard 17	Tree 1	Private 1			29	Width 4ft		6007949.93141	2112103.61743	37.779882948971206	-122.416092679044	(37.7798829489712, -122.416092679044)
164267	164267	134504	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	3	Side Yard : Yard 17	Tree 1	Private 1			19	Width 4ft		6008127.86822	2112113.3553299997	37.7799196898886	-122.41547780446999	(37.7799196898886, -122.41547780447)
166163	166163	195224	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	900 Phelps St	8	Side Yard : Yard 17	Tree 1	Private 1			12	Width 7ft		6014570.35716	2097088.14635	37.7390237239721	-122.392139105952	(37.7390237239721, -122.392139105952)
172984	172984	134507	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	6	Side Yard : Yard 17	Tree 1	Private 1			24	Width 4ft		6008088.37088	2112123.28694	37.779944739586	-122.415615147138	(37.779944739586, -122.415615147138)
176180	176180	195080	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	22	Side Yard : Yard 17	Tree 1	Private 1			9	Width 4ft		6014988.8599	2103201.99322	37.755834295018204	-122.39111932871201	(37.7558342950182, -122.391119328712)
177126	177126	134515	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	14	Side Yard : Yard 17	Tree 1	Private 1			18	Width 4ft		6007920.47696	2112096.9218900003	37.7798629084902	-122.416194101002	(37.7798629084902, -122.416194101002)
177530	177530	134505	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	4	Side Yard : Yard 17	Tree 1	Private 1			24	Width 4ft		6008123.85605	2112126.20986	37.7799547598338	-122.41549259472299	(37.7799547598338, -122.415492594723)
177540	177540	134519	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	100 Fulton St	18	Side Yard : Yard 17	Tree 1	Private 1			24	Width 4ft		6007845.81845	2112089.93571	37.779839527901295	-122.416451883555	(37.7798395279013, -122.416451883555)
182626	182626	195078	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Indiana St	20	Side Yard : Yard 17	Tree 1	Private 1			11	Width 4ft		6014987.06432	2103267.10016	37.7560129651346	-122.391130089079	(37.7560129651346, -122.391130089079)
43848	43848	99190	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	1155@Greenwich Battery St	3	Unaccepted Street : Yard 14	Tree 1	Private 1		04/24/2012 12:00:00 AM	13	Park	Permit Number 768770	6012236.89935	2120056.2938	37.801959219714	-122.401821238566	(37.801959219714, -122.401821238566)
28538	28538	212784	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	739 Foerster St	1	Back Yard : Yard 13	Tree 1	Private 1			17	Width 3ft		5998105.0801800005	2095806.61255	37.734576984727795	-122.448975948078	(37.7345769847278, -122.448975948078)
68601	68601	212785	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	743 Foerster St	1	Back Yard : Yard 13	Tree 1	Private 1			12	Width 3ft		5998104.46417	2095821.7845	37.734618608054795	-122.448979170379	(37.7346186080548, -122.448979170379)
103678	103678	108035	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	945 Market St		unknown : Cutout 12	Tree 1	DPW 2				3x3	Permit Number 774370	6010085.9126699995	2113154.0076	37.782886937251796	-122.408777465126	(37.7828869372518, -122.408777465126)
248	248	23733	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	800X Webster St	8	Median : Cutout 11	Tree 1	DPW 2			35	20		6003923.026000001	2111743.9893	37.7786682616238	-122.429997867276	(37.7786682616238, -122.429997867276)
1901	1901	23857	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Webster St	2	Median : Cutout 11	Tree 1	DPW 2			20	3X3		6003664.511	2113605.5032	37.7837648703142	-122.431025065183	(37.7837648703142, -122.431025065183)
5624	5624	23856	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Webster St	1	Median : Cutout 11	Tree 1	DPW 2			25	3X3		6003669.3238	2113580.0643	37.7836952941839	-122.4310065985	(37.7836952941839, -122.4310065985)
5634	5634	23786	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1100X Webster St	1	Median : Cutout 11	Tree 1	DPW 2			35	8X8		6003813.7072	2112544.6294	37.780860428691895	-122.43043318397301	(37.7808604286919, -122.430433183973)
5919	5919	28639	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1300 Webster St	1	Median : Cutout 11	Tree 1	DPW 2			30	20		6003713.3264	2113228.0439	37.7827312275464	-122.43082923608401	(37.7827312275464, -122.430829236084)
6248	6248	23822	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Webster St	1	Median : Cutout 11	Tree 1	DPW 2			60	20		6003768.3296	2112880.8363	37.7817809984294	-122.430614164895	(37.7817809984294, -122.430614164895)
7299	7299	23726	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	800X Webster St	1	Median : Cutout 11	Tree 1	DPW 2			25	6		6003954.9966	2111561.7912	37.778169801288904	-122.42987426911101	(37.7781698012889, -122.429874269111)
7490	7490	23861	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Webster St	6	Median : Cutout 11	Tree 1	DPW 2			12	3X3		6003632.8842	2113765.0125	37.784201050677794	-122.43114587096201	(37.7842010506778, -122.431145870962)
8386	8386	23762	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	900X Webster St	8	Median : Cutout 11	Tree 1	DPW 2			30	20		6003876.9608	2112076.071	37.7795774666707	-122.430180921789	(37.7795774666707, -122.430180921789)
8710	8710	23858	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Webster St	3	Median : Cutout 11	Tree 1	DPW 2			20	3X3		6003660.3858	2113644.0055	37.7838703542221	-122.43104208573999	(37.7838703542221, -122.43104208574)
8968	8968	23829	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Webster St	8	Median : Cutout 11	Tree 1	DPW 2			35	20		6003737.3903	2113105.6618	37.782396560281	-122.430737249093	(37.782396560281, -122.430737249093)
10449	10449	98333	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	12X Canyon Dr	2	Median : Cutout 11	Tree 1	DPW 2			99			6003235.70781	2086338.01389	37.708870401808205	-122.43056224915199	(37.7088704018082, -122.430562249152)
10756	10756	110237	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200X Winston Dr	3	Median : Cutout 11	Tree 1	DPW 2			11	6x18		5989487.1744800005	2093569.3277200002	37.7279373404144	-122.47860704469	(37.7279373404144, -122.47860704469)
13421	13421	6561	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1350X Evans Ave	1	Median : Cutout 11	Tree 1	DPW 2			12	4		6016932.91962	2097582.94738	37.740513241395604	-122.384004813584	(37.7405132413956, -122.384004813584)
13446	13446	6607	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Evans Ave	2	Median : Cutout 11	Tree 1	DPW 2		09/14/2006 12:00:00 AM	3	15		6016551.319490001	2097860.71449	37.741254829556105	-122.38534360193898	(37.7412548295561, -122.385343601939)
13615	13615	6529	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	21	Median : Cutout 11	Tree 1	DPW 2			12	15		6017368.28124	2097249.13872	37.7396207290066	-122.382476267371	(37.7396207290066, -122.382476267371)
13624	13624	6521	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	13	Median : Cutout 11	Tree 1	DPW 2			9	15		6017462.61912	2097188.96881	37.739460725233606	-122.38214589961599	(37.7394607252336, -122.382145899616)
13896	13896	6519	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	11	Median : Cutout 11	Tree 1	DPW 2			9	15		6017483.589869999	2097174.66185	37.739422599379104	-122.38207239623699	(37.7394225993791, -122.382072396237)
13967	13967	6617	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Evans Ave	12	Median : Cutout 11	Tree 1	DPW 2			12	15		6016412.3999	2097961.86068	37.741524869881104	-122.38583098952101	(37.7415248698811, -122.385830989521)
14278	14278	6523	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	15	Median : Cutout 11	Tree 1	DPW 2			9	15		6017441.22819	2097205.1052900003	37.739503851329495	-122.382220983128	(37.7395038513295, -122.382220983128)
14296	14296	6512	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	4	Median : Cutout 11	Tree 1	DPW 2			12	15		6017582.68074	2097100.7392400003	37.7392250947568	-122.381724640105	(37.7392250947568, -122.381724640105)
14456	14456	6537	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	29	Median : Cutout 11	Tree 1	DPW 2			9	15		6017269.15486	2097321.24148	37.7398132324937	-122.38282402351999	(37.7398132324937, -122.38282402352)
14481	14481	6524	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	16	Median : Cutout 11	Tree 1	DPW 2			18	15		6017425.7364	2097207.6932200002	37.7395101016101	-122.382274727523	(37.7395101016101, -122.382274727523)
14571	14571	6615	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Evans Ave	10	Median : Cutout 11	Tree 1	DPW 2			12	15		6016429.61259	2097949.5600400004	37.7414920473285	-122.385770616219	(37.7414920473285, -122.385770616219)
14619	14619	6528	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	20	Median : Cutout 11	Tree 1	DPW 2			12	15		6017381.090340001	2097249.5639299997	37.739622604108796	-122.382432008146	(37.7396226041088, -122.382432008146)
14699	14699	6616	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Evans Ave	11	Median : Cutout 11	Tree 1	DPW 2			12	15		6016425.355719999	2097963.9541599997	37.741531335091295	-122.385786338186	(37.7415313350913, -122.385786338186)
14858	14858	6530	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	22	Median : Cutout 11	Tree 1	DPW 2			12	15		6017366.22044	2097260.33377	37.7396513545281	-122.38248417152799	(37.7396513545281, -122.382484171528)
15027	15027	6531	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	23	Median : Cutout 11	Tree 1	DPW 2			12	15		6017348.91467	2097263.64113	37.7396594798919	-122.38254423812599	(37.7396594798919, -122.382544238126)
15109	15109	6526	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	18	Median : Cutout 11	Tree 1	DPW 2		09/14/2006 12:00:00 AM	3	15		6017409.27613	2097218.95029	37.7395401020909	-122.382332423519	(37.7395401020909, -122.382332423519)
15150	15150	6612	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Evans Ave	7	Median : Cutout 11	Tree 1	DPW 2			18	15		6016472.61883	2097917.5413	37.7414065100921	-122.385619683024	(37.7414065100921, -122.385619683024)
15309	15309	6525	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	17	Median : Cutout 11	Tree 1	DPW 2		09/14/2006 12:00:00 AM	3	15		6017423.67126	2097218.66072	37.7395401020993	-122.382282630765	(37.7395401020993, -122.382282630765)
15501	15501	6536	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	28	Median : Cutout 11	Tree 1	DPW 2			9	15		6017286.0724599995	2097321.35634	37.739814482555204	-122.382765536994	(37.7398144825552, -122.382765536994)
15734	15734	6522	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	14	Median : Cutout 11	Tree 1	DPW 2			12	15		6017447.32839	2097190.1869	37.7394632253474	-122.382198853519	(37.7394632253474, -122.382198853519)
15818	15818	6516	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	8	Median : Cutout 11	Tree 1	DPW 2			9	15		6017508.57687	2097144.1126599999	37.7393400973684	-122.38198387686899	(37.7393400973684, -122.381983876869)
15982	15982	6527	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	19	Median : Cutout 11	Tree 1	DPW 2			3	15		6017405.21421	2097232.9171599997	37.7395782279507	-122.382347439479	(37.7395782279507, -122.382347439479)
16031	16031	6586	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1300X Evans Ave	6	Median : Cutout 11	Tree 1	DPW 2			3	15		6017026.1395	2097501.4027299997	37.740294489412	-122.38367681643	(37.740294489412, -122.38367681643)
16058	16058	6562	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1350X Evans Ave	2	Median : Cutout 11	Tree 1	DPW 2			18	4		6016920.77309	2097581.3708900004	37.7405082411515	-122.384046702218	(37.7405082411515, -122.384046702218)
16076	16076	6613	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Evans Ave	8	Median : Cutout 11	Tree 1	DPW 2			12	15		6016450.58483	2097934.2856900003	37.741451267574206	-122.385697036412	(37.7414512675742, -122.385697036412)
16465	16465	6535	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	27	Median : Cutout 11	Tree 1	DPW 2			9	15		6017290.8428	2097308.51335	37.739779481837296	-122.382748149519	(37.7397794818373, -122.382748149519)
16655	16655	6515	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	7	Median : Cutout 11	Tree 1	DPW 2			6	15		6017527.69247	2097139.8588	37.7393294727638	-122.38191748711999	(37.7393294727638, -122.38191748712)
16774	16774	6564	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1350X Evans Ave	4	Median : Cutout 11	Tree 1	DPW 2			12	15		6016897.83831	2097600.27015	37.740558866707794	-122.384127318327	(37.7405588667078, -122.384127318327)
16850	16850	6563	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1350X Evans Ave	3	Median : Cutout 11	Tree 1	DPW 2			9	4		6016917.30927	2097594.07629	37.7405429361116	-122.384059563412	(37.7405429361116, -122.384059563412)
18484	18484	12450	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200X Lake Merced Blvd	1	Median : Cutout 11	Tree 1	DPW 2			3	6		5983914.9541303	2094860.2401332	37.7311567434968	-122.497965345854	(37.7311567434968, -122.497965345854)
28151	28151	140415	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1100x WEBSTER ST	7	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6003782.7679	2112770.1424	37.7814778785376	-122.430556314217	(37.7814778785376, -122.430556314217)
66037	66037	121471	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	102X King St	1	Median : Cutout 11	Tree 1	Port 9			9	3x3		6015546.21298	2111901.81315	37.779753015830394	-122.38979944679701	(37.7797530158304, -122.389799446797)
80509	80509	110645	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	9	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
81080	81080	6509	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	1	Median : Cutout 11	Tree 1	DPW 2			12	15		6017579.3120099995	2097108.75601	37.739246921189	-122.38173684520201	(37.739246921189, -122.381736845202)
81615	81615	6533	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	25	Median : Cutout 11	Tree 1	DPW 2			9	15		6017399.15501	2097229.47901	37.7395684527942	-122.382368150642	(37.7395684527942, -122.382368150642)
82803	82803	102580	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	6	Median : Cutout 11	Tree 1	DPW 2		03/12/2013 12:00:00 AM			Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
84036	84036	27864	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	5	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
84807	84807	6518	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	10	Median : Cutout 11	Tree 1	DPW 2			9	15		6017386.15401	2097259.19601	37.739649331573794	-122.38241516995899	(37.7396493315738, -122.382415169959)
84810	84810	12452	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200X Lake Merced Blvd	3	Median : Cutout 11	Tree 1	DPW 2			3	6		5983914.9541303	2094860.2401332	37.7311567434968	-122.497965345854	(37.7311567434968, -122.497965345854)
86558	86558	6582	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1350X Evans Ave	2	Median : Cutout 11	Tree 1	DPW 2			9	15		6017038.350166599	2097565.1506974	37.740470203399504	-122.383639033462	(37.7404702033995, -122.383639033462)
87354	87354	6619	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Evans Ave	14	Median : Cutout 11	Tree 1	DPW 2			12	15		6016747.6410828	2097755.6169144	37.740977112201705	-122.384657465748	(37.7409771122017, -122.384657465748)
88290	88290	6520	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	12	Median : Cutout 11	Tree 1	DPW 2			9	15		6017343.43601	2097287.05501	37.739723467052	-122.382564809911	(37.739723467052, -122.382564809911)
89385	89385	27863	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	4	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
90241	90241	27861	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	2	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
90513	90513	102577	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	3	Median : Cutout 11	Tree 1	DPW 2		03/12/2013 12:00:00 AM			Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
92233	92233	111089	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	10x HIGUERA AVE	1	Median : Cutout 11	Tree 1	Private 1		08/30/2016 12:00:00 AM	3	3x3	Permit Number 777485	5988057.0	2090190.0	37.7185754269376	-122.483303520979	(37.7185754269376, -122.483303520979)
92877	92877	110644	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	8	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
94947	94947	27865	Permitted Site 1	Platanus x hispanica :: Sycamore: London Plane 15	900X The Embarcadero	6	Median : Cutout 11	Tree 1	Port 9		12/20/2000 12:00:00 AM	24			6012583.0764321	2120386.2715161997	37.8028845715493	-122.400646489089	(37.8028845715493, -122.400646489089)
96408	96408	6618	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Evans Ave	13	Median : Cutout 11	Tree 1	DPW 2			12	15		6016747.6410828	2097755.6169144	37.740977112201705	-122.384657465748	(37.7409771122017, -122.384657465748)
98042	98042	110643	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	200x DRUMM ST	7	Median : Cutout 11	Tree 1	DPW 2						6013666.0	2117675.0	37.7955004026749	-122.396708806749	(37.7955004026749, -122.396708806749)
98126	98126	6534	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200X Evans Ave	26	Median : Cutout 11	Tree 1	DPW 2			9	15		6017423.300009999	2097212.76401	37.7395238904111	-122.38228350426901	(37.7395238904111, -122.382283504269)

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