Street_Tree_List

Data source: data.sfgov.org

352 rows where qSpecies = 71 sorted by SiteOrder 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: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
110779	110779	98279	Permitted Site 1	Pinus canariensis :: Canary Island Pine 71	900 Brotherhood Way	501	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		02/07/2012 12:00:00 AM			Permit Number 768594	5988860.9	2088745.5	37.7146559434524	-122.48041912379101	(37.7146559434524, -122.480419123791)
92410	92410	98278	Permitted Site 1	Pinus canariensis :: Canary Island Pine 71	900 Brotherhood Way	500	Sidewalk: Curb side : Yard 2	Tree 1	Private 1		02/07/2012 12:00:00 AM			Permit Number 768594	5988860.9	2088745.5	37.7146559434524	-122.48041912379101	(37.7146559434524, -122.480419123791)
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)
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)
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)
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)
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)
9686	9686	173637	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1155 Market St	99	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6008672.0	2111900.0	37.779364436223	-122.4135803097	(37.779364436223, -122.4135803097)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
14276	14276	19667	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	100 STAIRWAY5	66	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7433	7433	19666	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	100 STAIRWAY5	65	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60ST
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)
11943	11943	19664	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	100 STAIRWAY5	63	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
11841	11841	19663	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	100 STAIRWAY5	62	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
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)
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)
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)
58287	58287	200617	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	58	Median : Cutout 11	Tree 1	DPW 2			18	Width 0ft		6016444.7184	2095097.4319	37.7336615146436	-122.385519666546	(37.7336615146436, -122.385519666546)
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)
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)
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)
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)
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)
164960	164960	200615	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	56	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6016438.8423	2095106.2461	37.7336853915549	-122.38554059619301	(37.7336853915549, -122.385540596193)
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)
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)
136924	136924	200613	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	54	Median : Cutout 11	Tree 1	DPW 2			15	Width 0ft		6016431.4971	2095119.9571	37.733722632810604	-122.38556694616501	(37.7337226328106, -122.385566946165)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
169856	169856	200573	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	43	Median : Cutout 11	Tree 1	DPW 2			17	Width 0ft		6016335.7649	2095440.4518	37.734597349697104	-122.385920256211	(37.7345973496971, -122.385920256211)
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)
153781	153781	200572	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	42	Median : Cutout 11	Tree 1	DPW 2			18	Width 0ft		6016330.8681	2095450.735	37.73462531430871	-122.385937902813	(37.7346253143087, -122.385937902813)
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)
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)
137881	137881	200571	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	41	Median : Cutout 11	Tree 1	DPW 2			17	Width 0ft		6016326.461	2095462.4873	37.7346573398722	-122.385953958726	(37.7346573398722, -122.385953958726)
165671	165671	200567	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	39	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6016322.0539	2095480.6054	37.7347068446432	-122.38597045824699	(37.7347068446432, -122.385970458247)
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)
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)
100574	100574	111558	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	900x BOSWORTH ST	36	Front Yard : Yard 7	Tree 1	DPW 2			15			6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
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)
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)
66847	66847	200559	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	35	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6016309.6626	2095501.1365	37.7347625331555	-122.38601473032	(37.7347625331555, -122.38601473032)
115460	115460	111557	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	900x BOSWORTH ST	35	Front Yard : Yard 7	Tree 1	DPW 2			12			6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
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)
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)
9646	9646	114139	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1200X JUNIPERO SERRA BLVD	34	Sidewalk: Property side : Yard 9	Tree 1	Private 1			36			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
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)
158905	158905	200558	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	34	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6016305.3951	2095506.8264	37.734777920300004	-122.38602988117901	(37.7347779203, -122.386029881179)
9672	9672	114137	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1200X JUNIPERO SERRA BLVD	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
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)
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)
111551	111551	111555	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	900x BOSWORTH ST	33	Front Yard : Yard 7	Tree 1	DPW 2			24			6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
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)
184099	184099	200557	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	33	Median : Cutout 11	Tree 1	DPW 2			17	Width 0ft		6016298.6383	2095516.7839	37.734804887646796	-122.386053935891	(37.7348048876468, -122.386053935891)
9654	9654	114138	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	1200X JUNIPERO SERRA BLVD	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1		02/16/2016 12:00:00 AM	3			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
140665	140665	111554	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	900x BOSWORTH ST	32	Front Yard : Yard 7	Tree 1	DPW 2			26			6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
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)
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)
126284	126284	111553	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	900x BOSWORTH ST	31	Front Yard : Yard 7	Tree 1	DPW 2			12			6001649.0	2095572.0	37.734134835145895	-122.436706663072	(37.7341348351459, -122.436706663072)
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)
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)
84253	84253	21431	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	2692X Sunset Blvd	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60		5985040.0664617	2096882.0619327	37.7367740271268	-122.494224659054	(37.7367740271268, -122.494224659054)
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)
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)
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)
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)
117137	117137	21429	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	2692X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60		5985040.0664617	2096882.0619327	37.7367740271268	-122.494224659054	(37.7367740271268, -122.494224659054)
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)
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)
156435	156435	178169	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	24	: 4	Tree 1	Private 1			6	Width 0ft		5992786.910569999	2087851.5448200002	37.7124287295635	-122.466784396099	(37.7124287295635, -122.466784396099)
34685	34685	200547	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	23	Median : Cutout 11	Tree 1	DPW 2			5	Width 0ft		6016201.7309	2095635.0286	37.7351242000527	-122.386397222999	(37.7351242000527, -122.386397222999)
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)

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