Street_Tree_List

Data source: data.sfgov.org

262 rows where qSiteInfo = 4 and qSpecies = 15 sorted by Latitude

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude ▼	Longitude	Location
72189	72189	178591	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	67 Belle Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		5991713.92465	2086485.44715	37.70861577046671	-122.470393502266	(37.7086157704667, -122.470393502266)
137765	137765	178592	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	67 Belle Ave	2	: 4	Tree 1	Private 1			9	Width 3ft		5991724.32675	2086485.2281099998	37.7086157704725	-122.470357535671	(37.7086157704725, -122.470357535671)
156719	156719	178517	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	328 Schwerin St	1	: 4	Tree 1	Private 1			19	Width 4ft		6008541.04755	2086224.10569	37.708856757315395	-122.41221814244801	(37.7088567573154, -122.412218142448)
76451	76451	178516	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	322 Schwerin St	1	: 4	Tree 1	Private 1			17	Width 4ft		6008552.66413	2086251.2184400002	37.70893185520271	-122.41217990870001	(37.7089318552027, -122.4121799087)
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)
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)
150256	150256	178521	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	90 Kelloch Ave	1	: 4	Tree 1	Private 1			10	Width 3ft		6008137.560430001	2086303.76828	37.7090528454867	-122.413618285264	(37.7090528454867, -122.413618285264)
168228	168228	178515	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	304 Schwerin St	1	: 4	Tree 1	Private 1			22	Width 5ft		6008576.98547	2086321.37555	37.709125856931706	-122.41210080521601	(37.7091258569317, -122.412100805216)
65428	65428	212741	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	142 Vernon St	1	: 4	Tree 1	Private 1			13	Width 3ft		5992469.93504	2088840.59445	37.7151261228375	-122.467951845594	(37.7151261228375, -122.467951845594)
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)
157864	157864	178596	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	1	: 4	Tree 1	Private 1			10	Width 0ft		5989485.56542	2093493.23297	37.7277283101093	-122.47860704468799	(37.7277283101093, -122.478607044688)
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)
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)
188240	188240	178599	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	200 Winston Dr	5	: 4	Tree 1	Private 1			9	Width 0ft		5989481.37307	2093611.3212099997	37.7280523070507	-122.47863016983999	(37.7280523070507, -122.47863016984)
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)
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)
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)
147636	147636	201625	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	401 Galvez Ave	7	: 4	Tree 1	Private 1			11	Width 3ft		6021338.5629	2093518.11855	37.729594575111	-122.368490962388	(37.729594575111, -122.368490962388)
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)
148977	148977	178594	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3353 19th Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		5990562.4926	2094408.14654	37.7303029000397	-122.474950884197	(37.7303029000397, -122.474950884197)
172141	172141	195245	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1808 Newhall St	2	: 4	Tree 1	Private 1			3	Width 2ft		6013672.6153	2094756.94757	37.7325728473411	-122.395079867451	(37.7325728473411, -122.395079867451)
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)
182793	182793	195244	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2251 Silver Ave	1	: 4	Tree 1	Private 1			10	Width 3ft		6012880.317530001	2096318.78099	37.7368172265255	-122.397928572554	(37.7368172265255, -122.397928572554)
135377	135377	218253	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2751 14th Ave	4	: 4	Tree 1	Private 1			16	Width 3ft		5992274.63868	2097193.69767	37.73805040029939	-122.46923448031299	(37.7380504002994, -122.469234480313)
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)
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)
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)
170538	170538	195246	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1638 Kirkwood Ave	1	: 4	Tree 1	Private 1			9	Width 3ft		6014988.0451	2096950.5651	37.7386691365775	-122.390685308687	(37.7386691365775, -122.390685308687)
188513	188513	195243	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1638 Kirkwood Ave	1	: 4	Tree 1	Private 1			13	Width 3ft		6014980.6206	2096956.55885	37.7386851822676	-122.39071139803801	(37.7386851822676, -122.390711398038)
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)
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)
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)
152018	152018	195218	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Davidson Ave	7	: 4	Tree 1	Private 1			8	Width 4ft		6014967.27978	2099336.85287	37.7452202372225	-122.390923837661	(37.7452202372225, -122.390923837661)
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)
151814	151814	195216	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Davidson Ave	5	: 4	Tree 1	Private 1			7	Width 4ft		6014904.95641	2099386.15345	37.745352147978295	-122.391142788429	(37.7453521479783, -122.391142788429)
187595	187595	195199	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	201 Rankin St	2	: 4	Tree 1	Private 1			7	Width 4ft		6014703.6451	2099406.06072	37.745395635597795	-122.39184028732402	(37.7453956355978, -122.391840287324)
150937	150937	195200	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	201 Rankin St	3	: 4	Tree 1	Private 1			7	Width 4ft		6014718.61079	2099424.0915	37.7454459751497	-122.391789798485	(37.7454459751497, -122.391789798485)
165813	165813	195215	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Davidson Ave	4	: 4	Tree 1	Private 1			9	Width 4ft		6014851.78372	2099427.0803799997	37.745461573889706	-122.391329512854	(37.7454615738897, -122.391329512854)
72179	72179	195214	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Davidson Ave	3	: 4	Tree 1	Private 1			9	Width 4ft		6014827.69575	2099442.30699	37.7455020460878	-122.39141387017901	(37.7455020460878, -122.391413870179)
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)
103662	103662	195213	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Davidson Ave	2	: 4	Tree 1	Private 1			9	Width 4ft		6014805.02726	2099459.96171	37.7455492640952	-122.391493488936	(37.7455492640952, -122.391493488936)
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)
172970	172970	195212	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Davidson Ave	1	: 4	Tree 1	Private 1			9	Width 4ft		6014785.575230001	2099474.00299	37.7455867388307	-122.391561733092	(37.7455867388307, -122.391561733092)
161428	161428	246999	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	19 Clipper St	1	: 4	Tree 1	Private 1			9	Width 3ft		6004994.24506	2101041.79465	37.7493431926393	-122.425530239251	(37.7493431926393, -122.425530239251)
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)
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)
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)
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)
158738	158738	195157	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1186 Rhode Island St	1	: 4	Tree 1	Private 1			17	Width 4ft		6011914.58494	2102915.14043	37.7548755799578	-122.40173106894899	(37.7548755799578, -122.401731068949)
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)
181658	181658	195171	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	859 Wisconsin St	2	: 4	Tree 1	Private 1			12	Width 3ft		6012782.23298	2103496.30105	37.7565197007355	-122.39877126340001	(37.7565197007355, -122.3987712634)
66973	66973	195161	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1013 Rhode Island St	1	: 4	Tree 1	Private 1			17	Width 3ft		6011938.22182	2103514.77234	37.756523356495	-122.401691470003	(37.756523356495, -122.401691470003)
175514	175514	195172	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2002 22nd St	1	: 4	Tree 1	Private 1			16	Width 4ft		6012112.428230001	2103766.85721	37.7572252458601	-122.401106711003	(37.7572252458601, -122.401106711003)
153275	153275	238673	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	85 Saint Germain Ave	1	: 4	Tree 1	Private 1			6	Width 6ft		5998049.304830001	2104134.89853	37.757441236042	-122.44976875802799	(37.757441236042, -122.449768758028)
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)
69388	69388	195163	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	787 Wisconsin St	1	: 4	Tree 1	Private 1			14	Width 6ft		6012760.9648400005	2103859.57999	37.757516000268396	-122.398870312036	(37.7575160002684, -122.398870312036)
178856	178856	195156	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	951 Rhode Island St	1	: 4	Tree 1	Private 1			13	Width 3ft		6011915.13007	2103988.2051	37.757822009889296	-122.40180460739401	(37.7578220098893, -122.401804607394)
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)
64356	64356	195168	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	7	: 4	Tree 1	Private 1			17	Width 3ft		6012685.0522300005	2104255.6823299997	37.75859938027771	-122.39916065365101	(37.7585993802777, -122.399160653651)
150685	150685	195167	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	6	: 4	Tree 1	Private 1			8	Width 3ft		6012684.54271	2104264.03024	37.758622273411	-122.39916300178601	(37.758622273411, -122.399163001786)
64582	64582	195166	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	4	: 4	Tree 1	Private 1			12	Width 3ft		6012684.0082	2104282.2929599998	37.7586723890431	-122.39916613231199	(37.7586723890431, -122.399166132312)
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)
173988	173988	195164	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	690 Wisconsin St	1	: 4	Tree 1	Private 1			13	Width 3ft		6012683.27529	2104298.87784	37.7587178866378	-122.39916983123001	(37.7587178866378, -122.39916983123)
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)
134240	134240	195154	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	747 Rhode Island St	2	: 4	Tree 1	Private 1			13	Width 3ft		6011864.87444	2104893.13154	37.7603039328007	-122.40204202933	(37.7603039328007, -122.40204202933)
152201	152201	195181	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	469 Mississippi St	1	: 4	Tree 1	Private 1			11	Width 3ft		6014105.50369	2104939.78373	37.7605568320595	-122.39429594912399	(37.7605568320595, -122.394295949124)
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)
134060	134060	195179	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1566 19th St	2	: 4	Tree 1	Private 1			3	Width 3ft		6013002.55406	2105221.11715	37.7612679412857	-122.39813031208901	(37.7612679412857, -122.398130312089)
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)
133140	133140	195177	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	394 19th St	1	: 4	Tree 1	Private 1			6	Width 3ft		6013172.75141	2105230.87083	37.761304201040794	-122.397542351521	(37.7613042010408, -122.397542351521)
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)
180192	180192	195173	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	325 Texas St	1	: 4	Tree 1	Private 1			19	Width 4ft		6013788.90541	2105559.59246	37.7622410877705	-122.39543434873501	(37.7622410877705, -122.395434348735)
179171	179171	234562	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2901 Mariposa St	2	: 4	Tree 1	Private 1			14	Width 4ft		6008881.39711	2105875.2176200002	37.762833546753896	-122.41242993819401	(37.7628335467539, -122.412429938194)
133592	133592	234563	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	2901 Mariposa St	3	: 4	Tree 1	Private 1			19	Width 4ft		6008912.29955	2105878.19903	37.7628434671624	-122.41232326782699	(37.7628434671624, -122.412323267827)
158068	158068	195176	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	233 Missouri St	1	: 4	Tree 1	Private 1			6	Width 4ft		6013486.810959999	2105983.66021	37.763388677563704	-122.39650891357401	(37.7633886775637, -122.396508913574)
74222	74222	234548	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	474 Valencia St	3	: 4	Tree 1	Private 1			12	Width 3ft		6006115.99825	2106946.0186	37.765618136498205	-122.42207057339701	(37.7656181364982, -122.422070573397)
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)
165125	165125	217738	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	695 Frederick St	1	: 4	Tree 1	Private 1			7	Width 3ft		5996202.71792	2107242.52671	37.765868166002605	-122.456379657289	(37.7658681660026, -122.456379657289)
72313	72313	246910	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	459 Frederick St	1	: 4	Tree 1	Private 1			16	Width 4ft		5997543.65725	2107430.78495	37.7664619640604	-122.451755233613	(37.7664619640604, -122.451755233613)
169809	169809	246913	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	455 Frederick St	1	: 4	Tree 1	Private 1			14	Width 4ft		5997595.30029	2107440.49216	37.7664915751467	-122.451577310862	(37.7664915751467, -122.451577310862)
148734	148734	246916	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	449 Frederick St	1	: 4	Tree 1	Private 1			14	Width 4ft		5997647.003169999	2107445.44015	37.7665081217855	-122.451398837702	(37.7665081217855, -122.451398837702)
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)
131513	131513	234545	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	390 Valencia St	2	: 4	Tree 1	Private 1			4	Width 4ft		6006091.71874	2107360.04302	37.766753580050796	-122.422183968027	(37.7667535800508, -122.422183968027)
64246	64246	234544	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	390 Valencia St	1	: 4	Tree 1	Private 1			8	Width 4ft		6006090.12973	2107380.69438	37.7668101941596	-122.42219093149099	(37.7668101941596, -122.422190931491)
178924	178924	234543	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	380 Valencia St	4	: 4	Tree 1	Private 1			9	Width 4ft		6006089.37981	2107400.18313	37.7668636633447	-122.422194910079	(37.7668636633447, -122.422194910079)
158024	158024	234542	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	380 Valencia St	3	: 4	Tree 1	Private 1			8	Width 4ft		6006089.011419999	2107424.24621	37.7669297140741	-122.422197894039	(37.7669297140741, -122.422197894039)
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)
157447	157447	234540	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	380 Valencia St	1	: 4	Tree 1	Private 1			6	Width 4ft		6006085.83395	2107465.54893	37.7670429423165	-122.42221181913	(37.7670429423165, -122.42221181913)
179385	179385	234539	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	370 Valencia St	1	: 4	Tree 1	Private 1			7	Width 4ft		6006083.09138	2107528.0342900003	37.767214357586	-122.422225745128	(37.767214357586, -122.422225745128)
174902	174902	234538	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	360 Valencia St	3	: 4	Tree 1	Private 1			8	Width 4ft		6006081.901819999	2107554.11839	37.767285911232904	-122.42223171304701	(37.7672859112329, -122.422231713047)
154220	154220	234537	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	330 Valencia St	3	: 4	Tree 1	Private 1			10	Width 4ft		6006075.06564	2107641.31556	37.7675249483461	-122.422261554326	(37.7675249483461, -122.422261554326)
67161	67161	234536	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	330 Valencia St	2	: 4	Tree 1	Private 1			4	Width 4ft		6006075.19571	2107661.64535	37.767580776455496	-122.422262548987	(37.7675807764555, -122.422262548987)
147366	147366	234535	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	250 Valencia St	8	: 4	Tree 1	Private 1			13	Width 4ft		6006048.66097	2108127.33487	37.7688579522691	-122.42238742164899	(37.7688579522691, -122.422387421649)
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)
149578	149578	247227	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	754 Duboce Ave	3	: 4	Tree 1	Private 1			13	Width 4ft		6002088.83354	2108298.92928	37.7691049375705	-122.43609644770201	(37.7691049375705, -122.436096447702)
161294	161294	247226	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	754 Duboce Ave	2	: 4	Tree 1	Private 1			5	Width 4ft		6002102.7276	2108299.74329	37.7691079619876	-122.43604844728998	(37.7691079619876, -122.43604844729)
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)
131284	131284	247165	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	181 Buena Vista Ave East	2	: 4	Tree 1	Private 1			5	Width 3ft		6001459.73052	2108348.46373	37.769205185885895	-122.43827602303101	(37.7692051858859, -122.438276023031)
158143	158143	234561	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	600 Duboce Ave	4	: 4	Tree 1	Private 1			4	Width 5ft		6002820.93135	2108336.92419	37.7692508273841	-122.433566882319	(37.7692508273841, -122.433566882319)
186752	186752	247166	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	171 Buena Vista Ave East	1	: 4	Tree 1	Private 1			1	Width 3ft		6001433.83719	2108386.8451400003	37.769309098957294	-122.43836833663099	(37.7693090989573, -122.438368336631)

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