Street_Tree_List

Data source: data.sfgov.org

170 rows where PlotSize = "Width 3ft" and qSpecies = 70

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, SiteOrder, qSiteInfo, qCaretaker, DBH

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
267	267	175151	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	285 Santa Rosa Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/03/2017 12:00:00 AM	3	Width 3ft	Permit Number 779495	6000727.04119	2093604.3094	37.728679573387495	-122.43975313162399	(37.7286795733875, -122.439753131624)
271	271	175152	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	285 Santa Rosa Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/03/2017 12:00:00 AM	3	Width 3ft	Permit Number 779495	6000750.8705	2093589.3929700002	37.728639972642604	-122.43966968351002	(37.7286399726426, -122.43966968351)
1099	1099	250070	DPW Maintained 3	Afrocarpus gracilior :: Fern Pine 70	399 Austin St	1	: 4	Tree 1	DPW 2			2	Width 3ft		6005393.47416	2115303.0126799997	37.788523627097	-122.425164323999	(37.788523627097, -122.425164323999)
2582	2582	253132	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	522 Avalon Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				Width 3ft		6004047.94044	2092448.5749599999	37.7256946506667	-122.428190247706	(37.7256946506667, -122.428190247706)
24227	24227	203475	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2357 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5991280.398630001	2099387.14513	37.7440155431828	-122.472831922275	(37.7440155431828, -122.472831922275)
24295	24295	249534	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	201 Myrtle St	3	: 4	Tree 1	Private 1			7	Width 3ft		6006252.357009999	2114034.72493	37.785089704362704	-122.422102579373	(37.7850897043627, -122.422102579373)
24633	24633	220637	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	79 Bemis St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003700.73164	2096802.6587900002	37.7376303323698	-122.429700927958	(37.7376303323698, -122.429700927958)
25088	25088	189157	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2 Shipley St	5	: 4	Tree 1	Private 1			7	Width 3ft		6012230.29612	2112453.73281	37.78108402055079	-122.40130951984501	(37.7810840205508, -122.401309519845)
27160	27160	203449	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1474 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5992141.42239	2105406.9692	37.7605942249661	-122.47029301742901	(37.7605942249661, -122.470293017429)
27258	27258	220664	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1192 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6003819.11819	2101351.9934400003	37.7501284581809	-122.429615973494	(37.7501284581809, -122.429615973494)
27386	27386	220596	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	452 Shotwell St	1	: 4	Tree 1	Private 1			4	Width 3ft		6007814.59662	2105186.38117	37.7608822364448	-122.416070852512	(37.7608822364448, -122.416070852512)
27524	27524	189155	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2 Shipley St	3	: 4	Tree 1	Private 1			5	Width 3ft		6012260.87565	2112478.52323	37.7811537953404	-122.40120547186899	(37.7811537953404, -122.401205471869)
27556	27556	220598	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1 Sycamore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006787.43083	2105854.6831099996	37.7626594317184	-122.41967079188801	(37.7626594317184, -122.419670791888)
28571	28571	203474	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	663 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5991409.42461	2097303.39162	37.7383015575699	-122.472233919881	(37.7383015575699, -122.472233919881)
31097	31097	123452	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	735 02nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5995332.97895	2110593.9249	37.7750202604257	-122.459630642924	(37.7750202604257, -122.459630642924)
31567	31567	203453	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2658 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5991457.8354	2097316.5348	37.738340446961104	-122.47206749851001	(37.7383404469611, -122.47206749851)
31786	31786	221763	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	3816 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6002948.3546400005	2103602.92928	37.7562596509731	-122.432787903054	(37.7562596509731, -122.432787903054)
32542	32542	221762	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	4407 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001705.956180001	2104074.38405	37.7574836102927	-122.43711828977399	(37.7574836102927, -122.437118289774)
33240	33240	189153	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2 Shipley St	1	: 4	Tree 1	Private 1			6	Width 3ft		6012332.534469999	2112551.48713	37.781358134807796	-122.400962694499	(37.7813581348078, -122.400962694499)
33358	33358	220588	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1285 Hampshire St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6010337.44954	2101779.52105	37.7516692837277	-122.40710522684499	(37.7516692837277, -122.407105226845)
33494	33494	175166	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	218 Congdon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6004672.7463	2094000.25869	37.7299905627997	-122.426140758388	(37.7299905627997, -122.426140758388)
33827	33827	203454	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	5 Madrone Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5993011.06637	2099068.7919400004	37.743241463417796	-122.466824576891	(37.7432414634178, -122.466824576891)
33829	33829	189162	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	109 Kissling St	5	: 4	Tree 1	Private 1			2	Width 3ft		6008137.74771	2109383.99653	37.7724260745213	-122.41525036411998	(37.7724260745213, -122.41525036412)
33859	33859	220622	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	58 Fountain St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 3ft		6000334.98133	2101342.05017	37.7499032598351	-122.441663574927	(37.7499032598351, -122.441663574927)
35121	35121	125494	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1207 Chestnut St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6006034.74479	2120336.40198	37.8023802517163	-122.423303571803	(37.8023802517163, -122.423303571803)
36428	36428	203476	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2357 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5991292.10233	2099373.67062	37.743979223173106	-122.472790471621	(37.7439792231731, -122.472790471621)
36512	36512	175167	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	218 Congdon St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6004673.57343	2093985.3797	37.7299497551534	-122.426136840057	(37.7299497551534, -122.426136840057)
36697	36697	220597	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	452 Shotwell St	3	: 4	Tree 1	Private 1			4	Width 3ft		6007815.2262	2105168.52935	37.7608332548635	-122.416067410784	(37.7608332548635, -122.416067410784)
37791	37791	220646	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	816 Crescent Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6008205.0189	2095636.66757	37.7346828016745	-122.41404494431801	(37.7346828016745, -122.414044944318)
38814	38814	221775	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	21 Addison St	14	Back Yard : Yard 13	Tree 1	Private 1			10	Width 3ft		6003667.46569	2096848.61536	37.737754634878	-122.429819221204	(37.737754634878, -122.429819221204)
38930	38930	220655	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	580 Ogden Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008083.69599	2096082.2563599998	37.735899476465704	-122.41449592016599	(37.7358994764657, -122.414495920166)
40602	40602	203478	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2453 Funston Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5992323.79318	2098755.04508	37.74234030496479	-122.469178135975	(37.7423403049648, -122.469178135975)
41684	41684	203490	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	29 Joost Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001874.24208	2094906.2061700001	37.7323195164307	-122.43588030914302	(37.7323195164307, -122.435880309143)
43229	43229	220599	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	714 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010100.45141	2104938.60727	37.7603301624296	-122.408147577953	(37.7603301624296, -122.408147577953)
43603	43603	249538	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	201 Myrtle St	7	: 4	Tree 1	Private 1			4	Width 3ft		6006360.10871	2114050.0114700003	37.785137754239294	-122.421730877876	(37.7851377542393, -122.421730877876)
43774	43774	203480	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	90 Manor Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5993659.30191	2093497.00296	37.7279801058879	-122.464178756148	(37.7279801058879, -122.464178756148)
43939	43939	203498	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	234 Flood Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5999190.87551	2094097.9228400001	37.72994736206179	-122.445099202768	(37.7299473620618, -122.445099202768)
43952	43952	221766	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	712 Waller St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6002158.80169	2108813.78872	37.770522589268204	-122.43589127638799	(37.7705225892682, -122.435891276388)
44032	44032	220657	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	505 Tompkins Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008343.07833	2096482.99595	37.737014388512996	-122.41362746465799	(37.737014388513, -122.413627464658)
44557	44557	119343	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	462 32nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5985960.41468	2112779.42827	37.7804776215792	-122.49221287963199	(37.7804776215792, -122.492212879632)
44628	44628	220614	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2979 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6008369.0064199995	2103859.12249	37.757269043737395	-122.414059488154	(37.7572690437374, -122.414059488154)
45984	45984	125495	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1207 Chestnut St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6006051.2199	2120336.9264	37.802382621428706	-122.423246597049	(37.8023826214287, -122.423246597049)
46074	46074	221767	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	287 Hermann St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		6003902.82897	2108654.79623	37.770184952298	-122.429847331292	(37.770184952298, -122.429847331292)
46216	46216	189159	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	109 Kissling St	2	: 4	Tree 1	Private 1			2	Width 3ft		6008170.01676	2109410.076	37.7724994960939	-122.415140588393	(37.7724994960939, -122.415140588393)
47631	47631	221761	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	4441 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001542.762080001	2104063.39418	37.75744415704379	-122.437681892224	(37.7574441570438, -122.437681892224)
48809	48809	125436	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	3157 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6001892.570830001	2119015.7946	37.798519569189	-122.437542875929	(37.798519569189, -122.437542875929)
48836	48836	203495	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	363 Joost Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5999677.596390001	2094931.24105	37.732263227850204	-122.443476391437	(37.7322632278502, -122.443476391437)
48850	48850	246960	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2177 15th St	1	: 4	Tree 1	Private 1			2	Width 3ft		6003038.46952	2107086.92585	37.7658309772437	-122.432725124067	(37.7658309772437, -122.432725124067)
49140	49140	175171	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	399 Vienna St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6003766.2619199995	2091125.7997700002	37.7220466613948	-122.429069717203	(37.7220466613948, -122.429069717203)
49294	49294	221759	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	4515 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001360.92884	2104054.05926	37.7574081850601	-122.438310074049	(37.7574081850601, -122.438310074049)
49324	49324	175168	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	218 Congdon St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6004674.59943	2093952.62434	37.7298598742113	-122.426130962075	(37.7298598742113, -122.426130962075)
49575	49575	123145	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	562 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5992857.65671	2111637.4840599997	37.7777429430313	-122.468269178657	(37.7777429430313, -122.468269178657)
50288	50288	220659	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	998 Alabama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6009137.788819999	2103468.55533	37.756239784053996	-122.41137313676799	(37.756239784054, -122.411373136768)
50982	50982	220615	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	3117 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6009011.326230001	2104478.69915	37.75900631630999	-122.411881867955	(37.75900631631, -122.411881867955)
51714	51714	125450	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	44 Normandie Ter	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		6000949.24806	2117425.20451	37.79409854965171	-122.44069290604999	(37.7940985496517, -122.44069290605)
51784	51784	125483	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1471 Washington St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6007681.40554	2117137.6606799997	37.793690101870205	-122.417378482047	(37.7936901018702, -122.417378482047)
52304	52304	220625	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	665 Elizabeth St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		6002079.843669999	2102040.673	37.751920772823794	-122.43567974235	(37.7519207728238, -122.43567974235)
52592	52592	220600	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	75 Montcalm St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6010666.22738	2100038.82593	37.7469081100366	-122.405845659758	(37.7469081100366, -122.405845659758)
52909	52909	175174	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	399 Vienna St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		6003793.29108	2091173.5648599998	37.722179343787396	-122.428979687879	(37.7221793437874, -122.428979687879)
53916	53916	220624	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	665 Elizabeth St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6002066.32428	2102040.31203	37.7519190137697	-122.435726468425	(37.7519190137697, -122.435726468425)
54200	54200	125490	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1322 Pine St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6007597.86895	2115819.15526	37.7900651109764	-122.417574034214	(37.7900651109764, -122.417574034214)
54829	54829	221760	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	4515 20th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001372.8328	2104055.08022	37.7574116654297	-122.43826897865101	(37.7574116654297, -122.438268978651)
55795	55795	189170	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	360 Texas St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			10	Width 3ft		6013732.7365	2105419.1930299997	37.761852457439495	-122.395618779897	(37.7618524574395, -122.395618779897)
56342	56342	125442	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	3719 Scott St	1	: 4	Tree 1	Private 1			1	Width 3ft		6000612.64349	2121133.3219999997	37.8042608824853	-122.442123892024	(37.8042608824853, -122.442123892024)
57215	57215	175165	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	218 Congdon St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6004671.92277	2094015.32561	37.730031886663	-122.42614467765	(37.730031886663, -122.42614467765)
57484	57484	221751	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	4000 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003801.92979	2101310.951	37.750014791971104	-122.429672485102	(37.7500147919711, -122.429672485102)
58297	58297	220644	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	16 Bronte St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 3ft		6009354.03531	2097334.2588400003	37.7394084890188	-122.410192201918	(37.7394084890188, -122.410192201918)
58639	58639	203477	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2331 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5990713.76496	2099522.32344	37.7443538888309	-122.47480105801701	(37.7443538888309, -122.474801058017)
59975	59975	220649	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	41 Stoneman St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6008103.651880001	2099402.16609	37.7450163384242	-122.414661792014	(37.7450163384242, -122.414661792014)
60321	60321	203473	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	128 Howth St	1	: 4	Tree 1	Private 1			10	Width 3ft		5997584.72507	2091125.26044	37.7216933258806	-122.450437617121	(37.7216933258806, -122.450437617121)
60506	60506	203484	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	101 Los Palmos Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5998423.23469	2096036.13552	37.7352253905456	-122.447892505138	(37.7352253905456, -122.447892505138)
63274	63274	203472	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	126 Howth St	1	: 4	Tree 1	Private 1			5	Width 3ft		5997592.47815	2091138.0222	37.721728810427706	-122.450411736413	(37.7217288104277, -122.450411736413)
63403	63403	221758	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	4515 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001348.5727699995	2104052.2530799997	37.757402522937	-122.438352676761	(37.757402522937, -122.438352676761)
63596	63596	220634	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	628 Chenery St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6002844.7092	2095716.3109400002	37.7345989605548	-122.432583028494	(37.7345989605548, -122.432583028494)
63824	63824	220654	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	580 Ogden Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6008103.73158	2096079.3451	37.735892608341	-122.414426443037	(37.735892608341, -122.414426443037)
64600	64600	203500	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	77 Staples Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5999471.94159	2093749.5809	37.729006934723	-122.444102506626	(37.729006934723, -122.444102506626)
64810	64810	220647	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	157 Bonview St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6007230.99534	2098247.75396	37.7417975128515	-122.41759748493999	(37.7417975128515, -122.41759748494)
66877	66877	220656	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	505 Tompkins Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008322.74158	2096484.8015599998	37.737018204322	-122.41369790583	(37.737018204322, -122.41369790583)
67177	67177	249537	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	201 Myrtle St	6	: 4	Tree 1	Private 1			5	Width 3ft		6006345.87488	2114047.3209700002	37.7851295641198	-122.421779931396	(37.7851295641198, -122.421779931396)
68669	68669	203481	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	90 Manor Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5993650.092119999	2093481.6421299998	37.7279373979817	-122.464209479697	(37.7279373979817, -122.464209479697)
70634	70634	189160	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	109 Kissling St	3	: 4	Tree 1	Private 1			2	Width 3ft		6008158.83722	2109400.5814099996	37.772472797918	-122.415178587445	(37.772472797918, -122.415178587445)
71919	71919	125496	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1207 Chestnut St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 3ft		6006063.84143	2120339.6871599997	37.802390914060204	-122.42320311664899	(37.8023909140602, -122.423203116649)
73487	73487	125479	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1133 Clay St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6009244.74147	2117035.03683	37.793496155866706	-122.411961928316	(37.7934961558667, -122.411961928316)
75445	75445	220658	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	172 Precita Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6007553.6507	2100235.86656	37.7472745765577	-122.416622650424	(37.7472745765577, -122.416622650424)
76694	76694	125491	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1207 Chestnut St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6005994.09185	2120329.4714599997	37.8023589278732	-122.42344375814599	(37.8023589278732, -122.423443758146)
76778	76778	189168	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	606 Kansas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6011490.76938	2105489.27118	37.7619199120061	-122.40337783013001	(37.7619199120061, -122.40337783013)
126745	126745	220651	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	45 Stoneman St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		6008064.96703	2099392.46104	37.74498751697679	-122.41479487098101	(37.7449875169768, -122.414794870981)
130236	130236	189156	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	2 Shipley St	4	: 4	Tree 1	Private 1			5	Width 3ft		6012246.95244	2112466.10025	37.7811189079475	-122.401252766302	(37.7811189079475, -122.401252766302)
132055	132055	189161	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	109 Kissling St	4	: 4	Tree 1	Private 1			2	Width 3ft		6008149.50016	2109391.65635	37.7724477670719	-122.41521025345699	(37.7724477670719, -122.415210253457)
132131	132131	220639	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1202 Stanyan St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5997451.780119999	2105807.14899	37.7619986098677	-122.451955868771	(37.7619986098677, -122.451955868771)
132173	132173	203487	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	828 Foerster St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5998282.181969999	2096469.8668799999	37.736408249925	-122.44841139867201	(37.736408249925, -122.448411398672)
132179	132179	220641	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	859 Moultrie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007571.590369999	2095340.9683400001	37.7338352787826	-122.416213992189	(37.7338352787826, -122.416213992189)
132641	132641	250079	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	399 Austin St	5	: 4	Tree 1	Private 1			13	Width 3ft		6005448.26526	2115310.78255	37.7885480563034	-122.42497530809099	(37.7885480563034, -122.424975308091)
132705	132705	125527	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	29 Miller Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6010066.41664	2116970.44466	37.7933648665474	-122.409114296086	(37.7933648665474, -122.409114296086)
133342	133342	220645	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	816 Crescent Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008216.9228300005	2095637.5252200002	37.7346858251821	-122.414003848906	(37.7346858251821, -122.414003848906)
134317	134317	125539	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	31 Spofford St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			1	Width 3ft		6010570.5264	2117382.56278	37.794524670939204	-122.407399099212	(37.7945246709392, -122.407399099212)
136680	136680	203485	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	101 Los Palmos Dr	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		5998424.41404	2096025.6755	37.7351967372311	-122.447887674883	(37.7351967372311, -122.447887674883)
136884	136884	125446	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	3615 Buchanan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003103.6015800005	2120772.6345599997	37.8034121715947	-122.433477951057	(37.8034121715947, -122.433477951057)
136912	136912	250078	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	399 Austin St	4	: 4	Tree 1	Private 1			8	Width 3ft		6005435.52045	2115308.45101	37.78854093456471	-122.425019237271	(37.7885409345647, -122.425019237271)
137147	137147	220593	Undocumented 2	Afrocarpus gracilior :: Fern Pine 70	1 14th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6008525.9203	2107974.98193	37.768579058113104	-122.413807947778	(37.7685790581131, -122.413807947778)

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