Street_Tree_List

Data source: data.sfgov.org

262 rows where qSiteInfo = 4 and qSpecies = 15 sorted by rowid 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

- 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
188683	188683	195062	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1176 Harrison St	3	: 4	Tree 1	Private 1			7	Width 3ft		6010220.876209999	2109998.84251	37.7742311523704	-122.4080879583	(37.7742311523704, -122.4080879583)
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)
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)
188205	188205	195055	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	403 06th St	1	: 4	Tree 1	Private 1			23	Width 3ft		6011430.17139	2111003.8876099996	37.7770584095405	-122.403975506976	(37.7770584095405, -122.403975506976)
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)
187081	187081	247767	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	845 Waller St	1	: 4	Tree 1	Private 1			2	Width 3ft		6001661.0774	2108697.38351	37.7701746829316	-122.43760456761801	(37.7701746829316, -122.437604567618)
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)
185870	185870	234554	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	599 Buchanan St	6	: 4	Tree 1	Private 1			13	Width 6ft		6004538.62423	2110463.96667	37.775188478000395	-122.427777046086	(37.7751884780004, -122.427777046086)
183875	183875	234559	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	41 Octavia St	2	: 4	Tree 1	Private 1			9	Width 4ft		6005645.06544	2109465.49728	37.7725094497894	-122.423878598329	(37.7725094497894, -122.423878598329)
183424	183424	249587	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Ofarrell St	1	: 4	Tree 1	Private 1			7	Width 4ft		6006408.398130001	2113920.93025	37.784786051887295	-122.42155464044399	(37.7847860518873, -122.421554640444)
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)
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)
181560	181560	247706	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	840 Waller St	2	: 4	Tree 1	Private 1			10	Width 3ft		6001673.91079	2108749.22683	37.7703177614782	-122.437563890355	(37.7703177614782, -122.437563890355)
180701	180701	247712	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	876 Waller St	1	: 4	Tree 1	Private 1			17	Width 3ft		6001514.06581	2108723.89481	37.7702391166779	-122.438114977827	(37.7702391166779, -122.438114977827)
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)
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)
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)
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)
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)
178691	178691	247249	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1100 Waller St	4	: 4	Tree 1	Private 1			8	Width 3ft		6000067.79858	2108524.98288	37.7696105966925	-122.44310330496799	(37.7696105966925, -122.443103304968)
178490	178490	247772	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	801 Waller St	2	: 4	Tree 1	Private 1			6	Width 3ft		6001787.28968	2108713.82842	37.770227011787206	-122.43716917881599	(37.7702270117872, -122.437169178816)
177729	177729	247703	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	800 Waller St	5	: 4	Tree 1	Private 1			8	Width 4ft		6001741.79294	2108758.83097	37.7703479913065	-122.437329774362	(37.7703479913065, -122.437329774362)
177313	177313	247771	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	801 Waller St	1	: 4	Tree 1	Private 1			11	Width 3ft		6001750.77286	2108707.14029	37.770206572012604	-122.437295011077	(37.7702065720126, -122.437295011077)
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)
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)
174626	174626	247171	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	145 Buena Vista Ave East	2	: 4	Tree 1	Private 1			3	Width 4ft		6001359.13409	2108491.08392	37.7695910634178	-122.438634200521	(37.7695910634178, -122.438634200521)
174303	174303	250051	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1338 Franklin St	1	: 4	Tree 1	Private 1			6	Width 4ft		6005935.36197	2114756.97743	37.787054946975005	-122.42325064312	(37.787054946975, -122.42325064312)
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)
173951	173951	195061	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1140 Harrison St	4	: 4	Tree 1	Private 1			6	Width 3ft		6010383.576719999	2110052.37077	37.7743872369211	-122.407528919945	(37.7743872369211, -122.407528919945)
173513	173513	247745	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	863 Waller St	1	: 4	Tree 1	Private 1			8	Width 3ft		6001479.43571	2108670.8025	37.770091368856704	-122.43823095889799	(37.7700913688567, -122.438230958898)
173310	173310	195052	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	425 07th St	5	: 4	Tree 1	Private 1			13	Width 3ft		6010992.552	2110249.5776299997	37.7749627895434	-122.405436240713	(37.7749627895434, -122.405436240713)
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)
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)
171879	171879	249508	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1301 Van Ness Ave	3	: 4	Tree 1	Private 1			5	Width 1ft		6006312.75742	2115008.90991	37.7877679825424	-122.421962840029	(37.7877679825424, -122.421962840029)
171797	171797	133602	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	650 Hayes St	2	: 4	Tree 1	Private 1			12	Width 3ft		6004721.40466	2110909.40027	37.776421867615106	-122.42717650218701	(37.7764218676151, -122.427176502187)
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)
170441	170441	247719	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	12 Broderick St	1	: 4	Tree 1	Private 1			2	Width 3ft		6001402.47389	2108783.9506599996	37.770397668045995	-122.438505276404	(37.770397668046, -122.438505276404)
169967	169967	195040	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	465 06th St	2	: 4	Tree 1	Private 1			21	Width 3ft		6011693.31763	2110831.4269999997	37.7765995709415	-122.403053063343	(37.7765995709415, -122.403053063343)
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)
169245	169245	195066	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Harrison St	2	: 4	Tree 1	Private 1			10	Width 3ft		6008855.0352	2108588.8508599997	37.7702830764251	-122.412712965653	(37.7702830764251, -122.412712965653)
169165	169165	250006	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1 Starr King Way	1	: 4	Tree 1	Private 1			11	Width 3ft		6005940.10765	2113829.6095	37.784508891608	-122.423168280499	(37.784508891608, -122.423168280499)
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)
167190	167190	247697	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	72 Central Ave	1	: 4	Tree 1	Private 1			14	Width 4ft		5999967.70775	2108632.64756	37.7699005093291	-122.443457249359	(37.7699005093291, -122.443457249359)
166885	166885	195030	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	603 02nd St	2	: 4	Tree 1	Private 1			5	Width 3ft		6013857.48339	2113730.79868	37.78468119992	-122.395769734682	(37.78468119992, -122.395769734682)
165857	165857	195065	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1501 Harrison St	1	: 4	Tree 1	Private 1			7	Width 3ft		6008838.8659	2108569.8741200003	37.7702300631845	-122.4127675536	(37.7702300631845, -122.4127675536)
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)
165556	165556	249592	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Ofarrell St	6	: 4	Tree 1	Private 1			14	Width 4ft		6006270.409519999	2113900.7211	37.784722780981205	-122.42203060035601	(37.7847227809812, -122.422030600356)
165214	165214	247749	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	855 Waller St	2	: 4	Tree 1	Private 1			15	Width 3ft		6001558.5234199995	2108681.81075	37.770126092582295	-122.437958184647	(37.7701260925823, -122.437958184647)
165149	165149	247752	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	855 Waller St	3	: 4	Tree 1	Private 1			16	Width 3ft		6001574.75698	2108684.32997	37.7701339328771	-122.43790221351699	(37.7701339328771, -122.437902213517)
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)
164895	164895	195060	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1140 Harrison St	3	: 4	Tree 1	Private 1			6	Width 3ft		6010394.3995199995	2110162.2966	37.774689673525295	-122.407499233317	(37.7746896735253, -122.407499233317)
164825	164825	249591	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1000 Ofarrell St	5	: 4	Tree 1	Private 1			13	Width 4ft		6006303.7767199995	2113904.77053	37.7847357815627	-122.42191544845899	(37.7847357815627, -122.421915448459)
164666	164666	247248	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1100 Waller St	3	: 4	Tree 1	Private 1			9	Width 3ft		6000080.03929	2108527.4495	37.7696180673454	-122.44306114207899	(37.7696180673454, -122.443061142079)
164631	164631	247698	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	72 Central Ave	2	: 4	Tree 1	Private 1			14	Width 4ft		5999964.75678	2108649.39664	37.7699463297988	-122.443468659961	(37.7699463297988, -122.443468659961)
164356	164356	247202	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	891 Waller St	1	: 4	Tree 1	Private 1			18	Width 3ft		6001374.79144	2108658.38233	37.7700513139486	-122.43859203131001	(37.7700513139486, -122.43859203131)
164193	164193	247731	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	11 Broderick St	1	: 4	Tree 1	Private 1			21	Width 4ft		6001350.29365	2108820.89519	37.7704961402128	-122.438688415235	(37.7704961402128, -122.438688415235)
162202	162202	247710	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	860 Waller St	1	: 4	Tree 1	Private 1			15	Width 3ft		6001576.30193	2108733.6194	37.7702693572646	-122.437900400492	(37.7702693572646, -122.437900400492)
162188	162188	250058	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1353 Sutter St	3	: 4	Tree 1	Private 1			7	Width 4ft		6006105.43659	2114867.54502	37.787368134979	-122.422670082173	(37.787368134979, -122.422670082173)
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)
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)
160175	160175	250975	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	7010 California St	4	: 4	Tree 1	Private 1			2	Width 4ft		5985704.58491	2113917.1556700002	37.7835865343301	-122.49318174196699	(37.7835865343301, -122.493181741967)
158835	158835	249509	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1301 Van Ness Ave	4	: 4	Tree 1	Private 1			10	Width 1ft		6006315.507780001	2114994.81245	37.7877294295172	-122.421952322466	(37.7877294295172, -122.421952322466)
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)
158487	158487	234532	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	115 Valencia St	1	: 4	Tree 1	Private 1			11	Width 4ft		6006067.08782	2109011.03469	37.7712854203131	-122.42238648187599	(37.7712854203131, -122.422386481876)
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)
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)
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)
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)
157696	157696	247743	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	883 Waller St	1	: 4	Tree 1	Private 1			11	Width 3ft		6001420.60312	2108663.3046	37.770067435201604	-122.438433922403	(37.7700674352016, -122.438433922403)
157499	157499	247720	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	20 Broderick St	1	: 4	Tree 1	Private 1			22	Width 3ft		6001398.92288	2108803.93033	37.7704523252547	-122.43851899106701	(37.7704523252547, -122.438518991067)
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)
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)
156339	156339	195039	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	256 Shipley St	1	: 4	Tree 1	Private 1			14	Width 3ft		6011367.6736	2111629.5656	37.778772884306	-122.404235754578	(37.778772884306, -122.404235754578)
156309	156309	247707	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	844 Waller St	1	: 4	Tree 1	Private 1			22	Width 4ft		6001658.86841	2108747.25181	37.7703114833095	-122.43761578035699	(37.7703114833095, -122.437615780357)
156291	156291	250976	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	7010 California St	5	: 4	Tree 1	Private 1			2	Width 4ft		5985685.129819999	2113916.728	37.783584222178995	-122.49324901662399	(37.783584222179, -122.493249016624)
156139	156139	249405	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	430 Turk St	1	: 4	Tree 1	Private 1			8	Width 4ft		6007893.3915800005	2113084.10787	37.7825719605735	-122.416357743418	(37.7825719605735, -122.416357743418)
154970	154970	249492	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1875 California St	1	: 4	Tree 1	Private 1			12	Width 3ft		6005380.01047	2115808.93616	37.789912005885704	-122.425246921306	(37.7899120058857, -122.425246921306)
154296	154296	247250	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1100 Waller St	5	: 4	Tree 1	Private 1			9	Width 3ft		6000056.43283	2108524.17276	37.769607724246896	-122.443142560388	(37.7696077242469, -122.443142560388)
154270	154270	247747	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	863 Waller St	3	: 4	Tree 1	Private 1			7	Width 3ft		6001518.0666	2108676.73344	37.770109850805	-122.438097760312	(37.770109850805, -122.438097760312)
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)
153497	153497	247732	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	9 Broderick St	1	: 4	Tree 1	Private 1			16	Width 4ft		6001355.46469	2108797.19066	37.7704313476463	-122.438668829817	(37.7704313476463, -122.438668829817)
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)
153163	153163	247751	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	855 Waller St	2	: 4	Tree 1	Private 1			14	Width 3ft		6001558.5234199995	2108681.81075	37.770126092582295	-122.437958184647	(37.7701260925823, -122.437958184647)
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)
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)
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)
151468	151468	247699	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	800 Waller St	1	: 4	Tree 1	Private 1			8	Width 4ft		6001818.73975	2108768.05732	37.7703776985995	-122.437064276515	(37.7703776985995, -122.437064276515)
151107	151107	247246	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1100 Waller St	1	: 4	Tree 1	Private 1			11	Width 3ft		6000111.42711	2108530.98327	37.7696295597745	-122.44295282683001	(37.7696295597745, -122.44295282683)
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)
150896	150896	195064	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	1440 Harrison St	26	: 4	Tree 1	Private 1			9	Width 3ft		6009063.73826	2108894.43058	37.7711338386885	-122.412012658165	(37.7711338386885, -122.412012658165)
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)
150651	150651	195050	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	425 07th St	2	: 4	Tree 1	Private 1			8	Width 3ft		6011036.4161	2110204.08205	37.7748403216601	-122.405281300087	(37.7748403216601, -122.405281300087)
150360	150360	247748	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	855 Waller St	1	: 4	Tree 1	Private 1			15	Width 3ft		6001543.73976	2108680.07706	37.770120491585104	-122.438009196863	(37.7701204915851, -122.438009196863)
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)
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)
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)
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)
148609	148609	247750	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	855 Waller St	3	: 4	Tree 1	Private 1			15	Width 3ft		6001558.5234199995	2108681.81075	37.770126092582295	-122.437958184647	(37.7701260925823, -122.437958184647)
148001	148001	234557	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	47 Octavia St	5	: 4	Tree 1	Private 1			7	Width 4ft		6005640.14618	2109500.72386	37.7726058957745	-122.423898119925	(37.7726058957745, -122.423898119925)
147823	147823	247734	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	3 Broderick St	1	: 4	Tree 1	Private 1			18	Width 4ft		6001363.94167	2108750.8641	37.7703046286772	-122.438636188023	(37.7703046286772, -122.438636188023)

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