Street_Tree_List

Data source: data.sfgov.org

3,645 rows where qSpecies = 41 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, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
156868	156868	185356	Undocumented 2	Olea europaea :: Olive Tree 41	2601 Sunset Blvd	81	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5985014.265	2096945.9513	37.736947940348294	-122.49431857261001	(37.7369479403483, -122.49431857261)
89905	89905	3554	DPW Maintained 3	Olea europaea :: Olive Tree 41	201X Cargo Way	64	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/11/2006 12:00:00 AM	3	3X3		6016626.76696	2099218.04074	37.7449859443431	-122.38517728139	(37.7449859443431, -122.38517728139)
123831	123831	232470	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	63	Front Yard : Yard 7	Tree 1	Private 1			19	Width 5ft		6003561.98483	2095678.7252200001	37.734536409124395	-122.43010048596399	(37.7345364091244, -122.430100485964)
168303	168303	187200	Undocumented 2	Olea europaea :: Olive Tree 41	2301 Sunset Blvd	62	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984910.7598	2099021.3208	37.7426402887161	-122.49482940193998	(37.7426402887161, -122.49482940194)
4990	4990	3550	DPW Maintained 3	Olea europaea :: Olive Tree 41	201X Cargo Way	60	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/16/1990 12:00:00 AM	6	3X3		6018708.52549	2097590.55589	37.7406321362531	-122.377865918974	(37.7406321362531, -122.377865918974)
178109	178109	194137	Undocumented 2	Olea europaea :: Olive Tree 41	1301 Minnesota St	52	Front Yard : Yard 7	Tree 1	Private 1			7			6015362.68251	2102417.32718	37.7537005059858	-122.389771713504	(37.7537005059858, -122.389771713504)
153941	153941	194136	Undocumented 2	Olea europaea :: Olive Tree 41	1301 Minnesota St	51	Front Yard : Yard 7	Tree 1	Private 1			9			6015363.679269999	2102425.5673	37.753723186885296	-122.389768841963	(37.7537231868853, -122.389768841963)
65224	65224	194135	Undocumented 2	Olea europaea :: Olive Tree 41	1301 Minnesota St	50	Front Yard : Yard 7	Tree 1	Private 1			7			6015359.62578	2102424.0826	37.753718885432704	-122.38978275627	(37.7537188854327, -122.38978275627)
37321	37321	194134	Undocumented 2	Olea europaea :: Olive Tree 41	1301 Minnesota St	48	Front Yard : Yard 7	Tree 1	Private 1			5			6015354.20873	2102436.4215599997	37.753752465207704	-122.389802351607	(37.7537524652077, -122.389802351607)
57533	57533	194133	Undocumented 2	Olea europaea :: Olive Tree 41	1301 Minnesota St	47	Front Yard : Yard 7	Tree 1	Private 1			4			6015360.93697	2102437.8741900004	37.7537568269303	-122.38977918508199	(37.7537568269303, -122.389779185082)
55984	55984	194132	Undocumented 2	Olea europaea :: Olive Tree 41	1301 Minnesota St	46	Front Yard : Yard 7	Tree 1	Private 1			5			6015356.8182	2102444.39788	37.7537745112003	-122.389793884481	(37.7537745112003, -122.389793884481)
71773	71773	194149	Undocumented 2	Olea europaea :: Olive Tree 41	101 Pennsylvania Ave	40	Front Yard : Yard 7	Tree 1	Private 1			1			6014236.41284	2106693.2411599997	37.765378718967	-122.393965939285	(37.765378718967, -122.393965939285)
26951	26951	184920	Undocumented 2	Olea europaea :: Olive Tree 41	1990 41st Ave	39	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5983531.5644	2102137.5878	37.7511158704708	-122.499828470359	(37.7511158704708, -122.499828470359)
59223	59223	184039	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984935.4051	2103815.5297	37.755805317385004	-122.4950976324	(37.755805317385, -122.4950976324)
25527	25527	184919	Undocumented 2	Olea europaea :: Olive Tree 41	1990 41st Ave	38	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5983531.226	2102116.9441	37.7510591687413	-122.499828114856	(37.7510591687413, -122.499828114856)
185004	185004	186299	Undocumented 2	Olea europaea :: Olive Tree 41	1800 Sunset Blvd	37	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5985021.1385	2102711.497	37.7527789669048	-122.49471975093701	(37.7527789669048, -122.494719750937)
167786	167786	184036	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	36	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984928.8265	2103810.0952	37.7557900106144	-122.49511998225799	(37.7557900106144, -122.495119982258)
173503	173503	184034	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	34	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984925.6803	2103804.9468	37.7557756903402	-122.49513048303801	(37.7557756903402, -122.495130483038)
28601	28601	232469	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	33	Front Yard : Yard 7	Tree 1	Private 1			10			6003464.52997	2095634.55653	37.7344096119087	-122.43043426935301	(37.7344096119087, -122.430434269353)
182150	182150	232459	Undocumented 2	Olea europaea :: Olive Tree 41	1201 San Jose Ave	33	Front Yard : Yard 7	Tree 1	Private 1			1			6004401.596369999	2096010.3452700002	37.7354944802799	-122.427221282156	(37.7354944802799, -122.427221282156)
153006	153006	194148	Undocumented 2	Olea europaea :: Olive Tree 41	101 Pennsylvania Ave	32	Front Yard : Yard 7	Tree 1	Private 1			1			6014289.98871	2106632.9609	37.7652161800146	-122.393776411647	(37.7652161800146, -122.393776411647)
179976	179976	232468	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	32	Front Yard : Yard 7	Tree 1	Private 1			16			6003479.361880001	2095639.31415	37.7344235154206	-122.43038332994101	(37.7344235154206, -122.430383329941)
16403	16403	3726	DPW Maintained 3	Olea europaea :: Olive Tree 41	401X Cargo Way	31	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6016987.22702	2098921.28419	37.744191044988	-122.38391020401899	(37.744191044988, -122.383910204019)
147099	147099	184031	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984927.2534	2103793.0767	37.755743190427204	-122.495124167563	(37.7557431904272, -122.495124167563)
61669	61669	232458	Undocumented 2	Olea europaea :: Olive Tree 41	1201 San Jose Ave	30	Front Yard : Yard 7	Tree 1	Private 1			1			6004370.47722	2095993.8986799999	37.735447561742795	-122.427327701639	(37.7354475617428, -122.427327701639)
115042	115042	20880	DPW Maintained 3	Olea europaea :: Olive Tree 41	1892X Sunset Blvd	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60		5984852.8466778	2102317.5089788004	37.7516873322231	-122.49527267334	(37.7516873322231, -122.49527267334)
167809	167809	232467	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	30	Front Yard : Yard 7	Tree 1	Private 1			11			6003496.7451	2095646.5964799998	37.7344444957064	-122.43032374986299	(37.7344444957064, -122.430323749863)
57078	57078	232867	Undocumented 2	Olea europaea :: Olive Tree 41	100 Alemany Blvd	28	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6009311.71143	2095856.6182400002	37.735348835078796	-122.410234240737	(37.7353488350788, -122.410234240737)
115084	115084	20877	DPW Maintained 3	Olea europaea :: Olive Tree 41	1892X Sunset Blvd	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60		5984852.8466778	2102317.5089788004	37.7516873322231	-122.49527267334	(37.7516873322231, -122.49527267334)
137954	137954	184027	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984931.8298	2103786.2121	37.7557246100571	-122.495107834969	(37.7557246100571, -122.495107834969)
179104	179104	187244	Undocumented 2	Olea europaea :: Olive Tree 41	2401 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984957.2356	2098537.5785	37.7413147833906	-122.494633049632	(37.7413147833906, -122.494633049632)
103970	103970	20876	DPW Maintained 3	Olea europaea :: Olive Tree 41	1892X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60		5984852.8466778	2102317.5089788004	37.7516873322231	-122.49527267334	(37.7516873322231, -122.49527267334)
133852	133852	184026	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984920.3345	2103785.5463	37.7557221089671	-122.495147539697	(37.7557221089671, -122.495147539697)
39133	39133	184025	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984931.5337	2103784.5063	37.7557199090675	-122.495108733182	(37.7557199090675, -122.495108733182)
73714	73714	184906	Undocumented 2	Olea europaea :: Olive Tree 41	1990 41st Ave	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5983545.4397	2101789.6902	37.7501614543488	-122.49975477788901	(37.7501614543488, -122.499754777889)
76535	76535	187242	Undocumented 2	Olea europaea :: Olive Tree 41	2401 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984947.0235	2098562.0875	37.7413814807711	-122.494670165431	(37.7413814807711, -122.494670165431)
106760	106760	99309	DPW Maintained 3	Olea europaea :: Olive Tree 41	1902X 41st Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW for City Agency 10	SFUSD 6		6	3X3		5983703.9	2101544.3	37.7494969779561	-122.49918869137501	(37.7494969779561, -122.499188691375)
168934	168934	232466	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	23	Front Yard : Yard 7	Tree 1	Private 1			12			6003503.44574	2095655.81053	37.7344701749411	-122.430301240716	(37.7344701749411, -122.430301240716)
99349	99349	29238	DPW Maintained 3	Olea europaea :: Olive Tree 41	1902X 41st Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		5983534.517682901	2102185.1808128003	37.7512467209802	-122.499821775189	(37.7512467209802, -122.499821775189)
37029	37029	184963	Undocumented 2	Olea europaea :: Olive Tree 41	1990 41st Ave	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 0ft		5983546.455	2101707.1153	37.7499347861229	-122.499745164476	(37.7499347861229, -122.499745164476)
48789	48789	194147	Undocumented 2	Olea europaea :: Olive Tree 41	101 Pennsylvania Ave	21	Front Yard : Yard 7	Tree 1	Private 1			1			6014318.41099	2106520.5018700003	37.7649089715932	-122.393670233204	(37.7649089715932, -122.393670233204)
60804	60804	184962	Undocumented 2	Olea europaea :: Olive Tree 41	1990 41st Ave	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		5983548.4855	2101665.8278	37.7498215412297	-122.49973509178899	(37.7498215412297, -122.499735091789)
3750	3750	253551	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	19	Back Yard : Yard 13	Tree 1	DPW 2		09/22/2017 04:40:00 PM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
149190	149190	194177	Undocumented 2	Olea europaea :: Olive Tree 41	651 Missouri St	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			6013615.77637	2103967.79396	37.7578607257013	-122.395921591509	(37.7578607257013, -122.395921591509)
3837	3837	253550	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	18	Back Yard : Yard 13	Tree 1	DPW 2		09/27/2017 11:43:00 AM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
65267	65267	194219	Undocumented 2	Olea europaea :: Olive Tree 41	1121 Jamestown Ave	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			6013415.40609	2090027.00023	37.7195710634281	-122.395637826651	(37.7195710634281, -122.395637826651)
129649	129649	232457	Undocumented 2	Olea europaea :: Olive Tree 41	1201 San Jose Ave	18	Front Yard : Yard 7	Tree 1	Private 1			1			6004298.74095	2095904.57797	37.7351982498932	-122.427569359364	(37.7351982498932, -122.427569359364)
130267	130267	184018	Undocumented 2	Olea europaea :: Olive Tree 41	1600 Sunset Blvd	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984912.6418	2103753.8138	37.7556345299307	-122.495171803184	(37.7556345299307, -122.495171803184)
3841	3841	253549	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	17	Back Yard : Yard 13	Tree 1	DPW 2		09/27/2017 11:46:00 AM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
36744	36744	210684	Undocumented 2	Olea europaea :: Olive Tree 41	451 Hearst Ave	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		5998462.57436	2094368.3946599998	37.730648417782504	-122.44763647896299	(37.7306484177825, -122.447636478963)
67732	67732	210844	Undocumented 2	Olea europaea :: Olive Tree 41	32 Malta Dr	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5999579.90155	2096034.95813	37.7352882036818	-122.443893414261	(37.7352882036818, -122.443893414261)
180974	180974	194218	Undocumented 2	Olea europaea :: Olive Tree 41	1121 Jamestown Ave	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			30			6013410.02884	2090031.5953	37.7195833814573	-122.39565673576901	(37.7195833814573, -122.395656735769)
3758	3758	253548	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	16	Back Yard : Yard 13	Tree 1	DPW 2		09/22/2017 04:31:00 PM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
29252	29252	210843	Undocumented 2	Olea europaea :: Olive Tree 41	32 Malta Dr	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5999589.7002	2096031.76487	37.735279994668005	-122.443859307484	(37.735279994668, -122.443859307484)
49893	49893	210597	Undocumented 2	Olea europaea :: Olive Tree 41	1598 10th Ave	16	: 4	Tree 1	Private 1			5	Width 2ft		5993106.74835	2104720.89396	37.7587662054039	-122.466904544628	(37.7587662054039, -122.466904544628)
92082	92082	29233	DPW Maintained 3	Olea europaea :: Olive Tree 41	1902 41st Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		5983534.517682901	2102185.1808128003	37.7512467209802	-122.499821775189	(37.7512467209802, -122.499821775189)
136889	136889	194217	Undocumented 2	Olea europaea :: Olive Tree 41	1121 Jamestown Ave	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27			6013395.77535	2090042.77857	37.719613295602606	-122.39570678843398	(37.7196132956026, -122.395706788434)
158562	158562	232465	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	16	Front Yard : Yard 7	Tree 1	Private 1			13			6003573.73733	2095685.05632	37.7345544585066	-122.430060305156	(37.7345544585066, -122.430060305156)
3842	3842	253547	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	15	Back Yard : Yard 13	Tree 1	DPW 2		09/27/2017 11:40:00 AM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
36474	36474	232464	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	15	Front Yard : Yard 7	Tree 1	Private 1			14			6003586.39232	2095695.85827	37.7345848349269	-122.430017322941	(37.7345848349269, -122.430017322941)
3840	3840	253546	DPW Maintained 3	Olea europaea :: Olive Tree 41	1000 Cayuga Ave	14	Back Yard : Yard 13	Tree 1	DPW 2		09/27/2017 11:50:00 AM	3	3x3		6000652.979169999	2091201.14277	37.7220768117153	-122.43983693715201	(37.7220768117153, -122.439836937152)
33763	33763	194216	Undocumented 2	Olea europaea :: Olive Tree 41	1121 Jamestown Ave	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6013384.67345	2090050.6938099999	37.719634411689206	-122.39574571828399	(37.7196344116892, -122.395745718284)
68866	68866	232463	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	14	Front Yard : Yard 7	Tree 1	Private 1			11			6003597.18569	2095706.1719400003	37.7346137651955	-122.42998074211701	(37.7346137651955, -122.429980742117)
70188	70188	194167	DPW Maintained 3	Olea europaea :: Olive Tree 41	1300x De Haro St	14	Median : Yard 3	Tree 1	DPW 2			1			6012274.0442699995	2102163.00717	37.7528304388731	-122.40043512247802	(37.7528304388731, -122.400435122478)
113375	113375	30002	DPW Maintained 3	Olea europaea :: Olive Tree 41	610X San Jose Ave	14	Median : Cutout 11	Tree 1	DPW 2		03/24/2007 12:00:00 AM	3	3x3		6006030.83928578	2099887.5672939997	37.74623246341729	-122.42186369026399	(37.7462324634173, -122.421863690264)
160594	160594	194176	Undocumented 2	Olea europaea :: Olive Tree 41	651 Missouri St	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6013621.312469999	2103918.9432599996	37.7577269002821	-122.395899022122	(37.7577269002821, -122.395899022122)
179648	179648	210842	Undocumented 2	Olea europaea :: Olive Tree 41	32 Malta Dr	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5999613.75632	2096012.89951	37.7352295669793	-122.44377478199699	(37.7352295669793, -122.443774781997)
186931	186931	232435	Undocumented 2	Olea europaea :: Olive Tree 41	1 Church St	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 6ft		6004121.39652	2108664.33355	37.7702235143292	-122.42909198802201	(37.7702235143292, -122.429091988022)
36608	36608	107488	DPW Maintained 3	Olea europaea :: Olive Tree 41	1306x Montgomery St	13	Median : Cutout 11	Tree 1	DPW 2			6			6011453.59321	2119920.31769	37.80154211772779	-122.40452228489599	(37.8015421177278, -122.404522284896)
49287	49287	232462	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	13	Front Yard : Yard 7	Tree 1	Private 1			18			6003605.59401	2095716.2711599998	37.734641971550396	-122.42995239189501	(37.7346419715504, -122.429952391895)
64423	64423	182460	Undocumented 2	Olea europaea :: Olive Tree 41	1599 30th Ave	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5986822.0861	2104434.0624	37.757613911918796	-122.488618428263	(37.7576139119188, -122.488618428263)
152568	152568	210596	Undocumented 2	Olea europaea :: Olive Tree 41	1598 10th Ave	13	: 4	Tree 1	Private 1			8	Width 2ft		5993107.01633	2104712.4635099997	37.758743073052294	-122.466903004965	(37.7587430730523, -122.466903004965)
155863	155863	210841	Undocumented 2	Olea europaea :: Olive Tree 41	32 Malta Dr	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5999622.52898	2096001.61235	37.735199075468394	-122.443743641175	(37.7351990754684, -122.443743641175)
13811	13811	3566	Permitted Site 1	Olea europaea :: Olive Tree 41	101X Cargo Way	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2006 12:00:00 AM	3	3X3		6018911.95106	2097439.80241	37.740229404572396	-122.377152086609	(37.7402294045724, -122.377152086609)
15044	15044	3707	DPW Maintained 3	Olea europaea :: Olive Tree 41	401X Cargo Way	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/07/1996 12:00:00 AM	3	3X3		6016577.539609999	2099225.88923	37.7450047713688	-122.385348049088	(37.7450047713688, -122.385348049088)
15839	15839	18557	DPW Maintained 3	Olea europaea :: Olive Tree 41	1700X Quesada Ave	12	Median : Cutout 11	Tree 1	DPW 2			12	19		6014589.42489	2095117.7447900001	37.733614463738604	-122.391935430178	(37.7336144637386, -122.391935430178)
32377	32377	210840	Undocumented 2	Olea europaea :: Olive Tree 41	32 Malta Dr	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5999647.66435	2095993.4021	37.735177965674	-122.44365614971599	(37.735177965674, -122.443656149716)
34673	34673	232461	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	12	Front Yard : Yard 7	Tree 1	Private 1			11			6003612.68018	2095726.39764	37.7346701778724	-122.42992861471501	(37.7346701778724, -122.429928614715)
84743	84743	116631	Undocumented 2	Olea europaea :: Olive Tree 41	5732X GEARY BLVD	12	Front Yard : Cutout 8	Tree 1	MTA 6	DPW 4			3x3		5989254.0	2112678.0	37.780391116482	-122.480811519646	(37.780391116482, -122.480811519646)
98276	98276	41884	Permitted Site 1	Olea europaea :: Olive Tree 41	401 Duboce Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/20/2000 12:00:00 AM			Permit Number 42258	6004099.97108515	2108358.83625404	37.7693834800973	-122.429144312501	(37.7693834800973, -122.429144312501)
109195	109195	87103	Permitted Site 1	Olea europaea :: Olive Tree 41	2150 Post St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/02/2001 12:00:00 AM		3x3	Permit Number 43711	6001880.0	2113982.0	37.78469735624329	-122.437225758313	(37.7846973562433, -122.437225758313)
114354	114354	21248	DPW Maintained 3	Olea europaea :: Olive Tree 41	2401X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60		5985051.1945321	2098862.1753589	37.7422115377949	-122.49433209823401	(37.7422115377949, -122.494332098234)
146110	146110	121354	DPW Maintained 3	Olea europaea :: Olive Tree 41	399X Cargo Way	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3x3		6017829.0	2098352.0	37.7426744040176	-122.380959936377	(37.7426744040176, -122.380959936377)
152462	152462	233605	Undocumented 2	Olea europaea :: Olive Tree 41	199 Franconia St	12	: Yard 23	Tree 1	Private 1			9	Width 3ft		6010122.88511	2099649.32748	37.745808231063705	-122.407697037414	(37.7458082310637, -122.407697037414)
171012	171012	210859	Undocumented 2	Olea europaea :: Olive Tree 41	300 Mangels Ave	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			5999336.203480001	2095262.51223	37.7331533453405	-122.444680462235	(37.7331533453405, -122.444680462235)
12969	12969	76641	DPW Maintained 3	Olea europaea :: Olive Tree 41	148X Paris St	11	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2	05/08/1992 12:00:00 AM	10	3x3		6002952.722159999	2092480.7640200001	37.7257210052939	-122.43197862653	(37.7257210052939, -122.43197862653)
16144	16144	3565	Permitted Site 1	Olea europaea :: Olive Tree 41	101X Cargo Way	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/11/2006 12:00:00 AM	3	3X3		6018894.06666	2097453.02118	37.740264715549	-122.37721484129601	(37.740264715549, -122.377214841296)
31749	31749	124071	Undocumented 2	Olea europaea :: Olive Tree 41	501 Funston Ave	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5991891.710659999	2111428.07377	37.777112122582004	-122.47159542274599	(37.777112122582, -122.471595422746)
32896	32896	232460	Undocumented 2	Olea europaea :: Olive Tree 41	1300 San Jose Ave	11	Front Yard : Yard 7	Tree 1	Private 1			9			6003616.28584	2095734.4889200001	37.734692598886	-122.429916725697	(37.734692598886, -122.429916725697)
45011	45011	124669	Undocumented 2	Olea europaea :: Olive Tree 41	199 Arguello Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 5ft		5995485.80344	2114975.19112	37.7870588356326	-122.459419358244	(37.7870588356326, -122.459419358244)
48974	48974	210669	Undocumented 2	Olea europaea :: Olive Tree 41	220 Ulloa St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5996141.13831	2099000.15799	37.743233164483	-122.455996712494	(37.743233164483, -122.455996712494)
54053	54053	183697	Undocumented 2	Olea europaea :: Olive Tree 41	1341 42nd Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5983052.2798	2105821.6343	37.7612030896009	-122.50175839766099	(37.7612030896009, -122.501758397661)
63808	63808	210595	Undocumented 2	Olea europaea :: Olive Tree 41	1598 10th Ave	11	: 4	Tree 1	Private 1			6	Width 2ft		5993107.35573	2104707.43103	37.7587292747629	-122.466901465326	(37.7587292747629, -122.466901465326)
84280	84280	3576	Permitted Site 1	Olea europaea :: Olive Tree 41	100X Cargo Way	11	Sidewalk: Curb side : Cutout 1	Tree 1	Port 9		03/01/2006 12:00:00 AM	3	3x3		6018980.3390981	2097500.2540781004	37.740399159699294	-122.376919818221	(37.7403991596993, -122.376919818221)
93033	93033	1454	DPW Maintained 3	Olea europaea :: Olive Tree 41	151X ARGUELLO BLVD	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	3X5		5995497.0	2115135.0	37.7874982714485	-122.459392198652	(37.7874982714485, -122.459392198652)
101078	101078	30018	DPW Maintained 3	Olea europaea :: Olive Tree 41	710X San Jose Ave	11	Median : Cutout 11	Tree 1	DPW 2		03/24/2007 12:00:00 AM	3	3x3		6005718.76576524	2099005.5772577	37.7437931149581	-122.42288013057501	(37.7437931149581, -122.422880130575)
105087	105087	813	DPW Maintained 3	Olea europaea :: Olive Tree 41	600X 39th Ave	11	Median : Cutout 11	Tree 1	DPW 2			3	6-HOA		5983831.1679936	2111715.0127262003	37.7774303425616	-122.499500145383	(37.7774303425616, -122.499500145383)
107753	107753	110934	Permitted Site 1	Olea europaea :: Olive Tree 41	2 Connecticut St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6013092.21392497	2107061.02739926	37.7663249213263	-122.397949287209	(37.7663249213263, -122.397949287209)
124339	124339	116630	Undocumented 2	Olea europaea :: Olive Tree 41	5732X GEARY BLVD	11	Front Yard : Cutout 8	Tree 1	MTA 6	DPW 4			3x3		5989254.0	2112678.0	37.780391116482	-122.480811519646	(37.780391116482, -122.480811519646)
138926	138926	87102	Permitted Site 1	Olea europaea :: Olive Tree 41	2150 Post St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/02/2001 12:00:00 AM		3x3	Permit Number 43711	6001880.0	2113982.0	37.78469735624329	-122.437225758313	(37.7846973562433, -122.437225758313)

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