Street_Tree_List

Data source: data.sfgov.org

156 rows where PlotSize = "Width 0ft" and qSpecies = 71 sorted by XCoord

Search:

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

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

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

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

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

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

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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
185501	185501	184347	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1251 Sunset Blvd	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984658.9334	2106421.3632	37.7629440193232	-122.49624600189699	(37.7629440193232, -122.496246001897)
64531	64531	184348	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1251 Sunset Blvd	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984683.9949	2106431.9954	37.762974680362206	-122.496160108596	(37.7629746803622, -122.496160108596)
70507	70507	184801	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1301 Sunset Blvd	62	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984720.8276	2105758.3732	37.7611272600096	-122.49598302148998	(37.7611272600096, -122.49598302149)
74141	74141	186421	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1601 Sunset Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984727.9626	2104153.7573	37.756721849906	-122.495839973726	(37.756721849906, -122.495839973726)
44224	44224	186691	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1401 Sunset Blvd	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984728.0673	2105259.502	37.7597579231437	-122.49592118002701	(37.7597579231437, -122.495921180027)
69007	69007	186699	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1401 Sunset Blvd	56	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984730.9983	2105175.3386	37.759527005597604	-122.495904834542	(37.7595270055976, -122.495904834542)
69894	69894	186685	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1401 Sunset Blvd	42	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984734.6622	2105357.4834	37.7600273389586	-122.495905599978	(37.7600273389586, -122.495905599978)
170936	170936	186435	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1601 Sunset Blvd	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984740.5243	2104016.8346	37.7563466338471	-122.495786431621	(37.7563466338471, -122.495786431621)
177987	177987	186620	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1501 Sunset Blvd	91	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984755.0749	2104355.2681	37.7572767304033	-122.495761074715	(37.7572767304033, -122.495761074715)
91520	91520	186238	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1701 Sunset Blvd	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984762.5292	2103340.0793	37.7544897398871	-122.49566041616501	(37.7544897398871, -122.495660416165)
36257	36257	186440	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1601 Sunset Blvd	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984767.7413	2103960.7256	37.7561941679911	-122.495688168642	(37.7561941679911, -122.495688168642)
70815	70815	186456	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1601 Sunset Blvd	44	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984777.372	2103875.7247	37.755961343063895	-122.49564859346701	(37.7559613430639, -122.495648593467)
28596	28596	186468	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1601 Sunset Blvd	56	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984781.1405	2103769.7876	37.755670689824704	-122.495627747424	(37.7556706898247, -122.495627747424)
161248	161248	186247	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1701 Sunset Blvd	58	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984819.3113	2103171.6078	37.754030488698895	-122.49545162726801	(37.7540304886989, -122.495451627268)
44219	44219	186081	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1901 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984821.8866	2101948.8735	37.7506733477582	-122.49535255189899	(37.7506733477582, -122.495352551899)
169644	169644	185964	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2001 Sunset Blvd	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984823.122	2101326.4259	37.7489643495953	-122.495302381208	(37.7489643495953, -122.495302381208)
68825	68825	185954	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2001 Sunset Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984829.7049	2101412.004	37.749199709057706	-122.495285928093	(37.7491997090577, -122.495285928093)
25884	25884	186251	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1701 Sunset Blvd	62	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984830.2927	2103110.5403	37.7538634572036	-122.495409148018	(37.7538634572036, -122.495409148018)
175688	175688	185676	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2101 Sunset Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984839.348999999	2100771.308	37.747441097621206	-122.495205338122	(37.7474410976212, -122.495205338122)
49925	49925	186380	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1801 Sunset Blvd	47	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984843.2782	2102467.9478	37.7520998356184	-122.495316855331	(37.7520998356184, -122.495316855331)
72881	72881	186381	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1801 Sunset Blvd	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984844.8943	2102435.3563	37.75201044294921	-122.495308863381	(37.7520104429492, -122.495308863381)
74910	74910	186080	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1901 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984851.2986	2101988.3321	37.7507834123081	-122.49525375381599	(37.7507834123081, -122.495253753816)
37001	37001	185960	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2001 Sunset Blvd	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984855.8243	2101346.8117	37.7490222380818	-122.49519080130301	(37.7490222380818, -122.495190801303)
55771	55771	186733	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1250 Sunset Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984855.8629	2106397.0571	37.7628888152225	-122.49556310804701	(37.7628888152225, -122.495563108047)
187908	187908	181540	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1300 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984863.0454	2105869.1102	37.7614396414651	-122.49549932614799	(37.7614396414651, -122.495499326148)
174927	174927	181557	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1300 Sunset Blvd	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984875.8554	2106073.5142	37.76200162774529	-122.495470098326	(37.7620016277453, -122.495470098326)
179757	179757	185955	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2001 Sunset Blvd	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984875.9978	2101408.1817	37.7491919243755	-122.49512556709298	(37.7491919243755, -122.495125567093)
136097	136097	185539	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2201 Sunset Blvd	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984878.3804	2100042.8891	37.7454433428019	-122.495016669314	(37.7454433428019, -122.495016669314)
37263	37263	185562	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2201 Sunset Blvd	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984881.299	2099768.8111	37.7446909699364	-122.494986371806	(37.7446909699364, -122.494986371806)
156327	156327	185563	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2201 Sunset Blvd	47	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984887.6667	2099768.5458	37.7446906142612	-122.49496433430599	(37.7446906142612, -122.494964334306)
174392	174392	181538	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1300 Sunset Blvd	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984897.5768	2105857.4141	37.761409549185	-122.495379035532	(37.761409549185, -122.495379035532)
136877	136877	181519	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1400 Sunset Blvd	79	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984899.8047	2105606.7824	37.76072151501489	-122.49535284581002	(37.7607215150149, -122.49535284581)
174832	174832	185700	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2101 Sunset Blvd	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984899.9898	2100515.832	37.7467431803198	-122.494976814737	(37.7467431803198, -122.494976814737)
72624	72624	185709	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2101 Sunset Blvd	41	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984908.4893	2100423.9717	37.7464914545154	-122.49494065264601	(37.7464914545154, -122.494940652646)
166214	166214	181513	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1400 Sunset Blvd	73	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984909.8299	2105563.3396	37.7606028201969	-122.49531496977501	(37.7606028201969, -122.495314969775)
54231	54231	181385	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1500 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984917.5854	2104501.8427	37.7576886993488	-122.495209866912	(37.7576886993488, -122.495209866912)
177368	177368	181473	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1400 Sunset Blvd	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984918.4628	2105275.6702	37.759813465723795	-122.49526389807	(37.7598134657238, -122.49526389807)
171858	171858	185535	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2201 Sunset Blvd	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984921.0973	2100070.748	37.745522336384795	-122.49487101697099	(37.7455223363848, -122.494871016971)
183135	183135	186167	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1700 Sunset Blvd	52	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984926.5892	2103481.0156	37.7548863180592	-122.49510345420799	(37.7548863180592, -122.495103454208)
64562	64562	181379	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1500 Sunset Blvd	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984933.4588	2104463.134	37.7575833453331	-122.495152116603	(37.7575833453331, -122.495152116603)
185213	185213	187193	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2301 Sunset Blvd	55	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984945.2043	2099085.395	37.7428182353231	-122.49471502746701	(37.7428182353231, -122.494715027467)
170555	170555	181384	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1500 Sunset Blvd	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984945.4334	2104486.2478	37.75764751046	-122.49511240858	(37.75764751046, -122.49511240858)
170060	170060	185310	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2601 Sunset Blvd	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984962.2385	2097256.121	37.737796538483295	-122.494521307154	(37.7377965384833, -122.494521307154)
164480	164480	185307	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2601 Sunset Blvd	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984973.1253	2097316.8359	37.7379638824881	-122.494488141215	(37.7379638824881, -122.494488141215)
67079	67079	186038	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1900 Sunset Blvd	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984981.8854	2102120.1374	37.7511529582795	-122.494811896529	(37.7511529582795, -122.494811896529)
153955	153955	185290	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2601 Sunset Blvd	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984983.8028	2097379.2257	37.738135813056005	-122.494455822202	(37.738135813056, -122.494455822202)
135334	135334	184982	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2701 Sunset Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984985.373	2096691.7859999998	37.7362483795762	-122.494399733702	(37.7362483795762, -122.494399733702)
179683	179683	185932	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2000 Sunset Blvd	75	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984999.1426	2101513.5873	37.7494885480173	-122.494707506851	(37.7494885480173, -122.494707506851)
38117	38117	185308	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2601 Sunset Blvd	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985001.1798	2097292.5499	37.737898841519105	-122.494389354717	(37.7378988415191, -122.494389354717)
45298	45298	186040	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1900 Sunset Blvd	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985014.7934	2102133.6877	37.7511920899125	-122.49469909773998	(37.7511920899125, -122.49469909774)
179595	179595	185906	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2000 Sunset Blvd	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5985026.2976	2101345.2263	37.7490278641469	-122.49460119526	(37.7490278641469, -122.49460119526)
69760	69760	185902	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2000 Sunset Blvd	45	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5985031.1855	2101301.2352	37.7489073626901	-122.494581050501	(37.7489073626901, -122.494581050501)
183666	183666	187385	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2200 Sunset Blvd	71	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985037.3743	2100116.159	37.7456538284953	-122.49447230207399	(37.7456538284953, -122.494472302074)
30200	30200	185930	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2000 Sunset Blvd	73	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985039.332	2101497.8374	37.7494476553955	-122.494567371863	(37.7494476553955, -122.494567371863)
157592	157592	185023	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2701 Sunset Blvd	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985046.0879999995	2096329.59	37.735257439095705	-122.49416313243499	(37.7352574390957, -122.494163132435)
172467	172467	187388	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2200 Sunset Blvd	74	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985049.5619	2100144.9354	37.7457335539505	-122.49443228067	(37.7457335539505, -122.49443228067)
163106	163106	185033	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2701 Sunset Blvd	59	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985049.8565	2096299.4419	37.7351748809707	-122.494147882197	(37.7351748809707, -122.494147882197)
54265	54265	185439	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2300 Sunset Blvd	57	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985094.1378	2099479.3093	37.74390853380999	-122.494229093058	(37.74390853381, -122.494229093058)
28677	28677	187129	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2600 Sunset Blvd	65	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 0ft		5985149.8207	2097410.2322	37.738230663406604	-122.493884107972	(37.7382306634066, -122.493884107972)
53718	53718	187133	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2600 Sunset Blvd	69	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5985163.4571	2097445.4987	37.738328293602294	-122.493839558913	(37.7383282936023, -122.493839558913)
147538	147538	186878	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2700 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985170.4646	2096439.5838	37.7355667300556	-122.493741225987	(37.7355667300556, -122.493741225987)
137509	137509	187121	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2600 Sunset Blvd	57	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985174.7424	2097328.4139	37.7380074703554	-122.493791914706	(37.7380074703554, -122.493791914706)
160627	160627	186893	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2700 Sunset Blvd	42	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985181.9251	2096557.8565	37.7358921458374	-122.493710315825	(37.7358921458374, -122.493710315825)
115433	115433	186889	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2700 Sunset Blvd	38	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985183.3004	2096502.846	37.7357411821318	-122.49370150858101	(37.7357411821318, -122.493701508581)
35365	35365	186855	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2700 Sunset Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985186.2801	2096278.9071	37.735126479902895	-122.49367471051	(37.7351264799029, -122.49367471051)
173075	173075	186890	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2700 Sunset Blvd	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985200.262	2096503.3044	37.7357434330648	-122.493642900348	(37.7357434330648, -122.493642900348)
159660	159660	186880	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2700 Sunset Blvd	29	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5985201.1788	2096460.2128	37.73562516865071	-122.49363655642	(37.7356251686507, -122.49363655642)
39074	39074	186875	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2700 Sunset Blvd	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5985206.2214	2096387.7822	37.7354265885186	-122.493613787113	(37.7354265885186, -122.493613787113)
63231	63231	185118	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	2850 35th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 0ft		5985615.0479	2096000.8357	37.734388044102204	-122.49217185843099	(37.7343880441022, -122.492171858431)
44904	44904	211027	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	157	: 4	Tree 1	Private 1			4	Width 0ft		5991179.7136	2091396.7999900002	37.7220702434165	-122.47259762098	(37.7220702434165, -122.47259762098)
146741	146741	211030	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	165	: 4	Tree 1	Private 1			4	Width 0ft		5991183.72988	2091349.85826	37.7219415855123	-122.47258031712099	(37.7219415855123, -122.472580317121)
172927	172927	211028	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	160	: 4	Tree 1	Private 1			4	Width 0ft		5991184.3391	2091378.75733	37.722020970475505	-122.472580317131	(37.7220209704755, -122.472580317131)
183116	183116	211029	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	162	: 4	Tree 1	Private 1			5	Width 0ft		5991185.525	2091363.77787	37.721979909226704	-122.472575126241	(37.7219799092267, -122.472575126241)
137218	137218	211026	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	138	: 4	Tree 1	Private 1			4	Width 0ft		5991196.61305	2091604.8062200001	37.7226423552448	-122.472554361808	(37.7226423552448, -122.472554361808)
162875	162875	211022	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	80	: 4	Tree 1	Private 1			3	Width 0ft		5991230.5084	2092239.13983	37.7243860399747	-122.47248341699101	(37.7243860399747, -122.472483416991)
29067	29067	211025	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	95	: 4	Tree 1	Private 1			6	Width 0ft		5991234.71561	2092082.53367	37.723956281843705	-122.472457461651	(37.7239562818437, -122.472457461651)
41068	41068	211024	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	94	: 4	Tree 1	Private 1			6	Width 0ft		5991236.61569	2092101.4351299999	37.7240082905392	-122.472452270761	(37.7240082905392, -122.472452270761)
116918	116918	211018	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	55	: 4	Tree 1	Private 1			3	Width 0ft		5991237.26366	2092440.87353	37.7249403415953	-122.472474765495	(37.7249403415953, -122.472474765495)
156892	156892	211023	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	83	: 4	Tree 1	Private 1			5	Width 0ft		5991239.95465	2092188.59606	37.7242478060794	-122.472447079879	(37.7242478060794, -122.472447079879)
35161	35161	211021	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	78	: 4	Tree 1	Private 1			6	Width 0ft		5991241.40021	2092233.4270099998	37.7243709844069	-122.472445349599	(37.7243709844069, -122.472445349599)
54409	54409	211016	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	46	: 4	Tree 1	Private 1			3	Width 0ft		5991242.43895	2092472.66575	37.7250279346749	-122.472459191965	(37.7250279346749, -122.472459191965)
132551	132551	211019	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	71	: 4	Tree 1	Private 1			3	Width 0ft		5991242.8983	2092280.74938	37.724501006592895	-122.472443619273	(37.7245010065929, -122.472443619273)
133473	133473	211020	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	74	: 4	Tree 1	Private 1			4	Width 0ft		5991248.48231	2092260.69315	37.7244462603628	-122.472422854829	(37.7244462603628, -122.472422854829)
33005	33005	211017	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	700 Junipero Serra Blvd	49	: 4	Tree 1	Private 1			5	Width 0ft		5991258.9422	2092457.39845	37.724986969654495	-122.47240103009399	(37.7249869696545, -122.472401030094)
152330	152330	211015	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	500 Junipero Serra Blvd	78	: 4	Tree 1	Private 1			3	Width 0ft		5991307.93934	2093199.2311	37.727026693213794	-122.47228570643101	(37.7270266932138, -122.472285706431)
168152	168152	211014	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	500 Junipero Serra Blvd	53	: 4	Tree 1	Private 1			3	Width 0ft		5991322.30761	2093384.4785900002	37.7275361681597	-122.4722495339	(37.7275361681597, -122.4722495339)
1103	1103	211013	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	500 Junipero Serra Blvd	44	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5991332.59313	2093509.69784	37.727880584217	-122.47222310103399	(37.727880584217, -122.472223101034)
50538	50538	211012	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	500 Junipero Serra Blvd	35	: 4	Tree 1	Private 1			3	Width 0ft		5991334.380059999	2093575.3838	37.7280610448729	-122.47222170976102	(37.7280610448729, -122.472221709761)
156453	156453	211011	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	500 Junipero Serra Blvd	34	: 4	Tree 1	Private 1			3	Width 0ft		5991335.35345	2093583.37833	37.728083052188104	-122.47221892726499	(37.7280830521881, -122.472218927265)
148698	148698	211010	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	500 Junipero Serra Blvd	27	: 4	Tree 1	Private 1			3	Width 0ft		5991339.1010300005	2093646.61822	37.728256910008895	-122.47221057976601	(37.7282569100089, -122.472210579766)
37669	37669	211009	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	500 Junipero Serra Blvd	25	: 4	Tree 1	Private 1			4	Width 0ft		5991341.559830001	2093667.8062200001	37.728315229259	-122.472203623507	(37.728315229259, -122.472203623507)
36495	36495	178150	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	21	: 4	Tree 1	Private 1			4	Width 0ft		5991622.99627	2087995.81221	37.71275761073721	-122.47081770347401	(37.7127576107372, -122.470817703474)
63973	63973	178149	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	20	: 4	Tree 1	Private 1			4	Width 0ft		5991654.66793	2087995.1451599998	37.712757610756	-122.470708188538	(37.712757610756, -122.470708188538)
150068	150068	178148	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	19	: 4	Tree 1	Private 1			5	Width 0ft		5991783.61367	2087988.3395200002	37.712746380014295	-122.47026201958299	(37.7127463800143, -122.470262019583)
62726	62726	178147	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	18	: 4	Tree 1	Private 1			4	Width 0ft		5991814.6494	2087985.34878	37.712739962461	-122.47015453351999	(37.712739962461, -122.47015453352)
176067	176067	178146	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	17	: 4	Tree 1	Private 1			4	Width 0ft		5991839.8077	2087981.8975	37.712731940507105	-122.47006732805	(37.7127319405071, -122.47006732805)
161339	161339	178145	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	16	: 4	Tree 1	Private 1			4	Width 0ft		5991905.80045	2087967.0692099999	37.71269504040679	-122.469838159212	(37.7126950404068, -122.469838159212)
176986	176986	178144	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	15	: 4	Tree 1	Private 1			4	Width 0ft		5991934.88004	2087954.77106	37.712662953501294	-122.46973675705799	(37.7126629535013, -122.469736757058)
170901	170901	178143	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	14	: 4	Tree 1	Private 1			5	Width 0ft		5991964.10718	2087949.4813	37.7126501183836	-122.46963535489999	(37.7126501183836, -122.4696353549)
50188	50188	178142	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	13	: 4	Tree 1	Private 1			5	Width 0ft		5991993.89623	2087943.0111099998	37.7126340744777	-122.469531924782	(37.7126340744777, -122.469531924782)

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