Street_Tree_List

Data source: data.sfgov.org

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

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
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)
25615	25615	178137	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	8	: 4	Tree 1	Private 1			5	Width 0ft		5992316.61451	2087859.0919400002	37.712422298533895	-122.46841041712901	(37.7124222985339, -122.468410417129)
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)
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)
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)
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)
29859	29859	178135	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	6	: 4	Tree 1	Private 1			5	Width 0ft		5992385.6999699995	2087851.7958799999	37.7124062555186	-122.46817110840401	(37.7124062555186, -122.468171108404)
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)
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)
33800	33800	178161	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	16	: 4	Tree 1	Private 1			6	Width 0ft		5993106.56964	2087853.50799	37.7124525633948	-122.46567970845899	(37.7124525633948, -122.465679708459)
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)
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)
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)
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)
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)
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)
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)
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)
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)
38392	38392	178159	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	14	: 4	Tree 1	Private 1			5	Width 0ft		5993218.97583	2087844.63687	37.7124346884772	-122.465290557432	(37.7124346884772, -122.465290557432)
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)
40640	40640	178151	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	4	: 4	Tree 1	Private 1			3	Width 0ft		5993597.52442	2087641.3827799999	37.7118984245322	-122.46396744335199	(37.7118984245322, -122.463967443352)
40730	40730	178130	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	1	: 4	Tree 1	Private 1			7	Width 0ft		5992655.54446	2087848.4586	37.7124126730818	-122.4672382093	(37.7124126730818, -122.4672382093)
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)
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)
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)
44889	44889	178131	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	2	: 4	Tree 1	Private 1			5	Width 0ft		5992618.59421	2087849.2354599999	37.7124126730667	-122.46736597596501	(37.7124126730667, -122.467365975965)
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)
45126	45126	200542	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	18	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6016191.4179	2095647.8311	37.735158782265394	-122.38643377144	(37.7351587822654, -122.38643377144)
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)
45572	45572	200536	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	12	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6016175.6148	2095666.5235	37.7352092330314	-122.38648971191002	(37.7352092330314, -122.38648971191)
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)
50141	50141	178167	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	22	: 4	Tree 1	Private 1			5	Width 0ft		5992858.09731	2087851.4953400001	37.7124327018762	-122.466538351485	(37.7124327018762, -122.466538351485)
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)
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)
52015	52015	200528	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	4	Median : Cutout 11	Tree 1	DPW 2			19	Width 0ft		6016143.3115	2095696.7293	37.7352903838014	-122.38660350279801	(37.7352903838014, -122.386603502798)
52632	52632	178132	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	3	: 4	Tree 1	Private 1			6	Width 0ft		5992585.12632	2087848.18621	37.7124078599039	-122.467481573927	(37.7124078599039, -122.467481573927)
53065	53065	200527	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1400x La Salle Ave	3	Median : Cutout 11	Tree 1	DPW 2			15	Width 0ft		6016132.8234	2095707.6369	37.7353197532414	-122.386640524716	(37.7353197532414, -122.386640524716)
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)
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)
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)
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)
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)
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)
60960	60960	139214	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1350x GEARY BLVD	8	Median : Cutout 11	Tree 1	DPW 2			29	Width 0ft		6004809.3749	2114055.503	37.78506526335679	-122.427096327106	(37.7850652633568, -122.427096327106)
62236	62236	139330	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1350x GEARY BLVD	4	Median : Cutout 11	Tree 1	DPW 2			31	Width 0ft		6005126.2471	2114101.4827	37.7852094256692	-122.42600332266599	(37.7852094256692, -122.426003322666)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
70800	70800	139359	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1350x GEARY BLVD	9	Median : Cutout 11	Tree 1	DPW 2			28	Width 0ft		6004685.2851	2114039.9918	37.7850156556233	-122.42752453341801	(37.7850156556233, -122.427524533418)
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)
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)
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)
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)
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)
75963	75963	178152	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	7	: 4	Tree 1	Private 1			5	Width 0ft		5993523.09133	2087729.02455	37.7121347780763	-122.46423106162399	(37.7121347780763, -122.464231061624)
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)
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)
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)
130721	130721	178158	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	13	: 4	Tree 1	Private 1			5	Width 0ft		5993255.20411	2087840.2590599998	37.7124247572585	-122.465165024673	(37.7124247572585, -122.465165024673)
130784	130784	178165	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	20	: 4	Tree 1	Private 1			5	Width 0ft		5992928.58802	2087852.90738	37.7124406464989	-122.466294818667	(37.7124406464989, -122.466294818667)
131295	131295	139356	DPW Maintained 3	Pinus canariensis :: Canary Island Pine 71	1350x GEARY BLVD	5	Median : Cutout 11	Tree 1	DPW 2			24	Width 0ft		6005063.0942	2114090.4032	37.785175434752105	-122.42622102328698	(37.7851754347521, -122.426221023287)
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)
134128	134128	178133	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	4	: 4	Tree 1	Private 1			6	Width 0ft		5992553.46677	2087849.4362400002	37.7124094643071	-122.467591088862	(37.7124094643071, -122.467591088862)
134503	134503	178140	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	11	: 4	Tree 1	Private 1			6	Width 0ft		5992153.764330001	2087899.9141099998	37.712524978625005	-122.46897624088301	(37.712524978625, -122.468976240883)
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)
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)
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)
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)
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)
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)
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)
146720	146720	178155	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	10	: 4	Tree 1	Private 1			6	Width 0ft		5993366.44396	2087810.43567	37.71234928345479	-122.46477838452499	(37.7123492834548, -122.464778384525)
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)
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)
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)
150293	150293	178166	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	21	: 4	Tree 1	Private 1			5	Width 0ft		5992891.51235	2087851.5166099998	37.7124346884767	-122.466422861421	(37.7124346884767, -122.466422861421)
151728	151728	200146	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	6101 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 0ft		6013586.8559	2091305.2042	37.7230902914135	-122.395134667477	(37.7230902914135, -122.395134667477)
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)
152650	152650	178139	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	10	: 4	Tree 1	Private 1			6	Width 0ft		5992188.74587	2087889.2446599999	37.7124977039766	-122.468854559004	(37.7124977039766, -122.468854559004)
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)
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)
155336	155336	178160	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	10 Brotherhood Way	15	: 4	Tree 1	Private 1			6	Width 0ft		5993144.356269999	2087854.16093	37.712456535710395	-122.465549154771	(37.7124565357104, -122.465549154771)
156194	156194	178141	Undocumented 2	Pinus canariensis :: Canary Island Pine 71	20 Brotherhood Way	12	: 4	Tree 1	Private 1			5	Width 0ft		5992021.87667	2087934.24208	37.7126116138994	-122.46943457854401	(37.7126116138994, -122.469434578544)
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)
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)
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)
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)
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)

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