Street_Tree_List

Data source: data.sfgov.org

548 rows where qSpecies = 40 sorted by qLegalStatus 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
46601	46601	84938	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	145 Guerrero St	1	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 49347	6005480.0	2108218.0	37.769074802262395	-122.42436083172	(37.7690748022624, -122.42436083172)
49634	49634	112391	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	2201X LYON ST	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x12		5999307.0	2116423.0	37.7912531030346	-122.446303107227	(37.7912531030346, -122.446303107227)
80719	80719	116576	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	2500x OCEAN AVE	1	Sidewalk: Property side : Yard 9	Tree 1	MTA 6	DPW 4		30	10X10		5991377.0	2094742.0	37.7312667472315	-122.472159374256	(37.7312667472315, -122.472159374256)
81453	81453	114249	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	499x 24TH AVE	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		5988415.0	2112957.0	37.78110836988721	-122.483734439284	(37.7811083698872, -122.483734439284)
85476	85476	112374	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	1247 Bosworth St	1	Front Yard : Yard 7	Tree 1	Private 1				20x20	Permit Number 775819	6000424.1100699995	2096055.79143	37.735393525896704	-122.44097617665199	(37.7353935258967, -122.440976176652)
107396	107396	112485	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	1275 Columbus Ave	5	Front Yard : Yard 7	Tree 1	Private 1		08/03/2015 12:00:00 AM				6007539.6	2121483.9	37.8056158049656	-122.418177422209	(37.8056158049656, -122.418177422209)
108486	108486	107550	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	198X Jennings St	3	Front Yard : Yard 7	Tree 1	DPW 2						6018784.70414	2097136.12526	37.739388557233205	-122.377570991407	(37.7393885572332, -122.377570991407)
112521	112521	98951	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	401 Grove St	11	Front Yard : Yard 7	Tree 1	Private 1						6005778.2	2111279.0	37.7774964045324	-122.423547027313	(37.7774964045324, -122.423547027313)
117944	117944	104432	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	1601X PORTOLA DR	1	Front Yard : Yard 7	Tree 1	Private 1			14			5991823.0	2096240.0	37.73540567927029	-122.47072655808	(37.7354056792703, -122.47072655808)
122611	122611	112487	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	1275 Columbus Ave	7	Front Yard : Yard 7	Tree 1	Private 1						6007539.6	2121483.9	37.8056158049656	-122.418177422209	(37.8056158049656, -122.418177422209)
122658	122658	112488	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	1275 Columbus Ave	8	Front Yard : Yard 7	Tree 1	Private 1						6007539.6	2121483.9	37.8056158049656	-122.418177422209	(37.8056158049656, -122.418177422209)
124450	124450	112484	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	1275 Columbus Ave	4	Front Yard : Yard 7	Tree 1	Private 1		08/03/2015 12:00:00 AM				6007539.6	2121483.9	37.8056158049656	-122.418177422209	(37.8056158049656, -122.418177422209)
126530	126530	98952	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	302 Ivy St	18	Front Yard : Yard 7	Tree 1	Private 1						6005888.5	2111234.3	37.7773798943726	-122.42316228433	(37.7773798943726, -122.42316228433)
139051	139051	112390	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	2201X LYON ST	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x12		5999307.0	2116423.0	37.7912531030346	-122.446303107227	(37.7912531030346, -122.446303107227)
140157	140157	6099	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	500X 08th St	1	Sidewalk: Property side : Cutout 5	Tree 1	Private 1			18	18		6010526.812454099	2109340.6023904	37.772440902057795	-122.406983260044	(37.7724409020578, -122.406983260044)
140881	140881	107539	Significant Tree 6	Eucalyptus Spp :: Eucalyptus 40	198X JENNINGS ST	1	Front Yard : Yard 7	Tree 1	DPW 2						6018784.0	2097136.0	37.739388174499	-122.377573417349	(37.739388174499, -122.377573417349)
109	109	9895	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1800X Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6005051.0377	2115464.4068	37.7889474242075	-122.426360597873	(37.7889474242075, -122.426360597873)
1707	1707	19767	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY16	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30ST
1811	1811	19991	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
1842	1842	19990	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40
2751	2751	19916	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
5450	5450	19643	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	42	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
5580	5580	19952	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY39	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
5629	5629	19629	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
5638	5638	19734	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY14	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
6130	6130	19637	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	36	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
6465	6465	20050	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY52	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10
6552	6552	19622	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
6727	6727	20046	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY52	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	10
6840	6840	19703	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY13	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40ST
6859	6859	19881	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
7127	7127	19877	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	25ST
8000	8000	19575	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	100ST
8376	8376	17629	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	150 Phelps St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10M
8874	8874	19879	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
8891	8891	19873	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	25ST
9101	9101	19626	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
9670	9670	19824	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY25	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
10110	10110	17260	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	29 Osceola Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/27/2017 12:00:00 AM	18	3X3		6017247.640204701	2094279.3298336002	37.73145956022589	-122.382686794637	(37.7314595602259, -122.382686794637)
10584	10584	19572	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
10624	10624	19574	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
10757	10757	19823	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY25	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
10946	10946	19995	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
11109	11109	19996	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	40
11188	11188	19822	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY25	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
11496	11496	19573	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
11523	11523	19635	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	34	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
11623	11623	19765	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY16	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30ST
12152	12152	19571	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
12720	12720	19640	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	39	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
12830	12830	19619	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
12952	12952	19628	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
13122	13122	19636	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	35	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
13156	13156	20391	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	262X Sunset Blvd	37	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13560	13560	20028	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY49	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10
13632	13632	19618	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
13773	13773	19987	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY46	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40
13854	13854	11422	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	803X Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6016040.90005	2096755.8649799998	37.738192886184	-122.38703142706001	(37.738192886184, -122.38703142706)
13883	13883	19639	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
14157	14157	17628	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	150 Phelps St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10M
14188	14188	19617	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
14354	14354	17473	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	2050X Palou Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/17/1992 12:00:00 AM	12	3X3		6012341.587169999	2097177.38743	37.73914476102	-122.39985148498	(37.73914476102, -122.39985148498)
14387	14387	22148	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	3800 03rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3x3		6015737.9632	2098284.4406	37.7423732631069	-122.388185488874	(37.7423732631069, -122.388185488874)
14502	14502	17475	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	2050X Palou Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6012301.79777	2097206.74854	37.7392231621197	-122.399991120917	(37.7392231621197, -122.399991120917)
14653	14653	19921	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY37	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3
15242	15242	22432	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	6000 03rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6013579.8961	2091555.5712	37.7237773618259	-122.39517625529	(37.7237773618259, -122.39517625529)
15445	15445	19918	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
15768	15768	19884	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	25ST
15852	15852	19567	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY1	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
15947	15947	19630	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	29	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
16203	16203	19623	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
16222	16222	19870	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	25ST
16278	16278	19770	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY16	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30ST
16313	16313	19876	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY33	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
16376	16376	19641	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY5	40	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
16486	16486	19701	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY12	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
16953	16953	19917	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100 STAIRWAY35	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
23642	23642	176313	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	500x Mansell St	18	Median : Cutout 11	Tree 1	DPW 2			38	Width 0ft		6010259.13784	2090270.57035	37.7200637812891	-122.40656510840799	(37.7200637812891, -122.406565108408)
24910	24910	113499	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	200x Mansell St	5	Median : Cutout 11	Tree 1	DPW 2			19	3x3		6011193.56936	2090563.5306400002	37.7209204242214	-122.403355677147	(37.7209204242214, -122.403355677147)
28478	28478	176327	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	31	Median : Cutout 11	Tree 1	DPW 2			46	Width 0ft		6009212.31958	2089948.46975	37.7191207387124	-122.41016088932699	(37.7191207387124, -122.410160889327)
28724	28724	199407	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	301x Cashmere St	7	Median : Yard 3	Tree 1	DPW 2			18			6016184.136419999	2096191.07332	37.736650012889	-122.386496812495	(37.736650012889, -122.386496812495)
30294	30294	176308	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	300x Mansell St	12	Median : Cutout 11	Tree 1	DPW 2			23	Width 0ft		6010842.734619999	2090461.59096	37.7206209176161	-122.404561241708	(37.7206209176161, -122.404561241708)
30521	30521	17266	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	40 Osceola Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017197.543092299	2094354.669125	37.7316636592684	-122.382865232677	(37.7316636592684, -122.382865232677)
36490	36490	176307	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	300x Mansell St	7	Median : Cutout 11	Tree 1	DPW 2			14	Width 0ft		6010889.97096	2090468.7148799999	37.7206431182563	-122.404398460825	(37.7206431182563, -122.404398460825)
36977	36977	186970	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1650x Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5986025.4295	2095869.2083	37.734050611594604	-122.49074337328301	(37.7340506115946, -122.490743373283)
37371	37371	176317	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	600x Mansell St	5	Median : Cutout 11	Tree 1	DPW 2			20	Width 0ft		6009952.88344	2090194.2340000002	37.7198370388417	-122.40761835123199	(37.7198370388417, -122.407618351232)
40506	40506	176323	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	23	Median : Cutout 11	Tree 1	DPW 2			31	Width 0ft		6009342.20287	2090002.90208	37.719277477945	-122.40971577078399	(37.719277477945, -122.409715770784)
42868	42868	176330	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	35	Median : Cutout 11	Tree 1	DPW 2			7	Width 0ft		6009184.10476	2089961.98667	37.7191562718235	-122.41025937136801	(37.7191562718235, -122.410259371368)
44683	44683	176302	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	100x Mansell St	2	Median : Cutout 11	Tree 1	DPW 2			18	Width 0ft		6011513.54745	2090660.92357	37.721205711656204	-122.40225644658301	(37.7212057116562, -122.402256446583)
46745	46745	176303	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	200x Mansell St	16	Median : Cutout 11	Tree 1	DPW 2			23	Width 0ft		6011115.33526	2090539.9745900002	37.7208513742667	-122.40362445389799	(37.7208513742667, -122.403624453898)
49638	49638	25447	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1261X La Salle Ave	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017141.6501925	2094501.7221284	37.732064349457005	-122.383068698568	(37.732064349457, -122.383068698568)
50131	50131	199404	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	299x Cashmere St	24	Median : Yard 3	Tree 1	DPW 2			31			6016629.65755	2096008.94769	37.7361745853726	-122.38494375437	(37.7361745853726, -122.38494375437)
53330	53330	186974	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	1600x Sloat Blvd	1	Median : Cutout 11	Tree 1	DPW 2			9	Width 0ft		5986249.0864	2095869.2083	37.7340636742344	-122.489970132524	(37.7340636742344, -122.489970132524)
55441	55441	199405	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	301x Cashmere St	4	Median : Yard 3	Tree 1	DPW 2			25			6016273.90453	2096214.7321400002	37.736719944173004	-122.386188091409	(37.736719944173, -122.386188091409)
56266	56266	9287	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	13X George Ct	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6017208.549763201	2094048.0250586998	37.7308222832509	-122.38280584856301	(37.7308222832509, -122.382805848563)
58856	58856	185127	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Sloat Blvd	2	Median : Cutout 11	Tree 1	DPW 2			10	Width 0ft		5989015.4133	2095969.6432	37.734500589899504	-122.480413539116	(37.7345005898995, -122.480413539116)
62350	62350	176309	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	300x Mansell St	21	Median : Cutout 11	Tree 1	DPW 2			24	Width 0ft		6010760.4946	2090426.07331	37.720518796898	-122.404843021812	(37.720518796898, -122.404843021812)
62801	62801	176326	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	700x Mansell St	26	Median : Cutout 11	Tree 1	DPW 2			11	Width 0ft		6009300.414580001	2090007.1642099998	37.719286839006706	-122.40986051846701	(37.7192868390067, -122.409860518467)
64522	64522	176312	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	500x Mansell St	15	Median : Cutout 11	Tree 1	DPW 2			13	Width 0ft		6010340.9019	2090322.69069	37.720211467072296	-122.406286146812	(37.7202114670723, -122.406286146812)
64735	64735	176318	DPW Maintained 3	Eucalyptus Spp :: Eucalyptus 40	600x Mansell St	6	Median : Cutout 11	Tree 1	DPW 2			24	Width 0ft		6009900.75619	2090162.07565	37.71974582058	-122.40779627129	(37.71974582058, -122.40779627129)

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