Street_Tree_List

Data source: data.sfgov.org

116 rows where DBH = 2 and qSpecies = 6

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, PlantDate, PlotSize, PermitNotes

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
1475	1475	187957	Undocumented 2	Acer rubrum :: Red Maple 6	81 Lansing St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014291.0	2114089.0	37.78568884516871	-122.39429498812099	(37.7856888451687, -122.394294988121)
2522	2522	141925	DPW Maintained 3	Acer rubrum :: Red Maple 6	900 MCALLISTER ST	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/23/2013 12:00:00 AM	2	Width 0ft		6004344.9249	2111897.598	37.7791139177501	-122.42854930773399	(37.7791139177501, -122.428549307734)
2536	2536	141924	Undocumented 2	Acer rubrum :: Red Maple 6	900 MCALLISTER ST	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004374.9759	2111902.445	37.7791289269844	-122.428445694629	(37.7791289269844, -122.428445694629)
2719	2719	141993	Permitted Site 1	Acer rubrum :: Red Maple 6	818 Webster St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/21/2008 12:00:00 AM	2	Width 0ft		6003993.152000001	2111582.4748	37.778228754000004	-122.429743751351	(37.778228754, -122.429743751351)
9126	9126	2365	Permitted Site 1	Acer rubrum :: Red Maple 6	2500 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3X3		6009712.991769	2102766.5035063997	37.7543443518018	-122.409334337085	(37.7543443518018, -122.409334337085)
25058	25058	141590	DPW Maintained 3	Acer rubrum :: Red Maple 6	700x DIVISADERO ST	6	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6001558.8965	2111018.1096	37.776541006446706	-122.438124278141	(37.7765410064467, -122.438124278141)
26030	26030	118375	Planning Code 138.1 required 4	Acer rubrum :: Red Maple 6	340 Fremont St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	4x6		6014712.487269999	2114662.02755	37.7872856671566	-122.392876855803	(37.7872856671566, -122.392876855803)
28247	28247	187919	Undocumented 2	Acer rubrum :: Red Maple 6	48 Minna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6013100.51395	2115046.75094	37.7882523600964	-122.398480985606	(37.7882523600964, -122.398480985606)
29587	29587	139865	Undocumented 2	Acer rubrum :: Red Maple 6	752 MCALLISTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6005530.836	2112064.5728	37.7796394301742	-122.42445863354601	(37.7796394301742, -122.424458633546)
30101	30101	189093	Undocumented 2	Acer rubrum :: Red Maple 6	1444 Galvez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016095.6448	2097530.53643	37.74032300780279	-122.38689615645399	(37.7403230078028, -122.386896156454)
32646	32646	203423	Undocumented 2	Acer rubrum :: Red Maple 6	10 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993355.35449	2097236.83517	37.7382312350687	-122.465501072513	(37.7382312350687, -122.465501072513)
32741	32741	220423	Undocumented 2	Acer rubrum :: Red Maple 6	1525 Bryant St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009450.02537	2107605.87811	37.7676174373262	-122.41058546376699	(37.7676174373262, -122.410585463767)
33720	33720	42228	Permitted Site 1	Acer rubrum :: Red Maple 6	66 Lansing St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/23/2000 12:00:00 AM	2		Permit Number 42484	6014289.84402	2114150.2532200003	37.7858569681792	-122.394303277683	(37.7858569681792, -122.394303277683)
34143	34143	88173	Permitted Site 1	Acer rubrum :: Red Maple 6	360 Clementina St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM	2	3x3	Permit Number 51186	6011687.76515	2112550.16033	37.781318504386604	-122.40319320113001	(37.7813185043866, -122.40319320113)
35502	35502	203417	Undocumented 2	Acer rubrum :: Red Maple 6	57 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993769.4905900005	2096990.17002	37.7375778308529	-122.46405130512	(37.7375778308529, -122.46405130512)
35513	35513	220479	Undocumented 2	Acer rubrum :: Red Maple 6	211 Prentiss St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6008820.53272	2097501.66791	37.7398382390396	-122.41204865353501	(37.7398382390396, -122.412048653535)
35576	35576	175135	Undocumented 2	Acer rubrum :: Red Maple 6	144 Santa Ynez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6000350.62933	2092307.6786599997	37.7250978911274	-122.440961425642	(37.7250978911274, -122.440961425642)
37536	37536	220503	Undocumented 2	Acer rubrum :: Red Maple 6	203 States St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6001063.95053	2106312.4258	37.7635922112288	-122.43949902816799	(37.7635922112288, -122.439499028168)
37847	37847	187948	Undocumented 2	Acer rubrum :: Red Maple 6	302 Main St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			6015252.9594	2115128.97629	37.788597806797796	-122.391039570534	(37.7885978067978, -122.391039570534)
38184	38184	187958	Undocumented 2	Acer rubrum :: Red Maple 6	43 Lansing St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014361.38404	2114182.65198	37.7859499041048	-122.394058036143	(37.7859499041048, -122.394058036143)
38415	38415	187922	Undocumented 2	Acer rubrum :: Red Maple 6	48 Minna St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6013074.697930001	2115022.06537	37.7881831410762	-122.398568572402	(37.7881831410762, -122.398568572402)
38969	38969	203414	Undocumented 2	Acer rubrum :: Red Maple 6	95 Yerba Buena Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5993945.5640199995	2096868.34313	37.7372534705646	-122.463433702031	(37.7372534705646, -122.463433702031)
40467	40467	88171	Permitted Site 1	Acer rubrum :: Red Maple 6	360 Clementina St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM	2	3x3	Permit Number 51186	6011722.12263	2112583.0098200003	37.78141062014	-122.40307665168899	(37.78141062014, -122.403076651689)
41174	41174	189076	Undocumented 2	Acer rubrum :: Red Maple 6	1047 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010179.59918	2108995.88933	37.7714749641405	-122.408159994002	(37.7714749641405, -122.408159994002)
41685	41685	187956	Undocumented 2	Acer rubrum :: Red Maple 6	390 Fremont St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014829.80215	2114536.3127599997	37.78694699864871	-122.392462171218	(37.7869469986487, -122.392462171218)
42234	42234	187869	Undocumented 2	Acer rubrum :: Red Maple 6	1600 Indiana St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 7ft		6015103.96021	2100930.78351	37.749604420516896	-122.390562573713	(37.7496044205169, -122.390562573713)
43028	43028	141617	DPW Maintained 3	Acer rubrum :: Red Maple 6	700x DIVISADERO ST	2	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6001580.3173	2110897.2965	37.776210502271105	-122.43804152155	(37.7762105022711, -122.43804152155)
43633	43633	203422	Undocumented 2	Acer rubrum :: Red Maple 6	9 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993354.866669999	2097295.22775	37.738391538344004	-122.465506999949	(37.738391538344, -122.465506999949)
45699	45699	189101	Undocumented 2	Acer rubrum :: Red Maple 6	1444 Galvez Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6015952.01721	2097639.0008900003	37.7406128754775	-122.387400332559	(37.7406128754775, -122.387400332559)
47746	47746	189082	Undocumented 2	Acer rubrum :: Red Maple 6	320 Clementina St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011829.14154	2112689.69375	37.7817095251229	-122.402713920937	(37.7817095251229, -122.402713920937)
49093	49093	189078	Undocumented 2	Acer rubrum :: Red Maple 6	1047 Bryant St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010207.59565	2109022.90661	37.771550714911896	-122.40806505798	(37.7715507149119, -122.40806505798)
49948	49948	189079	Undocumented 2	Acer rubrum :: Red Maple 6	1047 Bryant St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010221.55971	2109034.74016	37.771583988945	-122.40801758996099	(37.771583988945, -122.408017589961)
51610	51610	247891	DPW Maintained 3	Acer rubrum :: Red Maple 6	300x Divisadero St	5	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6001766.9155	2109631.5958	37.7727458146843	-122.43730537854401	(37.7727458146843, -122.437305378544)
54872	54872	189096	Undocumented 2	Acer rubrum :: Red Maple 6	1444 Galvez Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016030.46802	2097581.7763799997	37.74046009325421	-122.38712508694599	(37.7404600932542, -122.387125086946)
55303	55303	50676	Permitted Site 1	Acer rubrum :: Red Maple 6	320 Clementina St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/17/2009 12:00:00 AM	2	3x3	Permit Number 53102	6011983.41914	2112836.30852	37.7821207077455	-122.402190501114	(37.7821207077455, -122.402190501114)
56593	56593	187961	Undocumented 2	Acer rubrum :: Red Maple 6	43 Lansing St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014406.4892	2114229.47192	37.7860809677	-122.393905262033	(37.7860809677, -122.393905262033)
57164	57164	187920	Undocumented 2	Acer rubrum :: Red Maple 6	48 Minna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6013088.63275	2115034.82195	37.7882189439825	-122.398521255459	(37.7882189439825, -122.398521255459)
57750	57750	187952	Undocumented 2	Acer rubrum :: Red Maple 6	350 Fremont St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014738.2491	2114633.8383299997	37.7872096969197	-122.39278575178601	(37.7872096969197, -122.392785751786)
61423	61423	189092	Undocumented 2	Acer rubrum :: Red Maple 6	1442 Galvez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016181.26551	2097468.2132900003	37.7401566215255	-122.386595766675	(37.7401566215255, -122.386595766675)
61724	61724	187953	Undocumented 2	Acer rubrum :: Red Maple 6	350 Fremont St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014758.29255	2114615.93494	37.787161651545205	-122.392715152285	(37.7871616515452, -122.392715152285)
63219	63219	189073	Undocumented 2	Acer rubrum :: Red Maple 6	1111 Bryant St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009955.51496	2108774.3382900003	37.770854086583796	-122.40891948225	(37.7708540865838, -122.40891948225)
63718	63718	203407	Undocumented 2	Acer rubrum :: Red Maple 6	1945 08th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5993759.21038	2102270.66076	37.7520761325235	-122.46447014280899	(37.7520761325235, -122.464470142809)
64702	64702	220472	Undocumented 2	Acer rubrum :: Red Maple 6	100 Alemany Blvd	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009413.9185	2095926.46105	37.735546336994794	-122.409885800206	(37.7355463369948, -122.409885800206)
64781	64781	220404	Undocumented 2	Acer rubrum :: Red Maple 6	1728 Bryant St	1	: 4	Tree 1	Private 1			2	Width 3ft		6009447.09485	2106640.63695	37.7649669427944	-122.41052743231899	(37.7649669427944, -122.410527432319)
66651	66651	220485	Undocumented 2	Acer rubrum :: Red Maple 6	2855 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009088.3091	2103314.09635	37.7558128992489	-122.41153334289899	(37.7558128992489, -122.411533342899)
67378	67378	141946	Undocumented 2	Acer rubrum :: Red Maple 6	1101 GOLDEN GATE AVE	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004240.9751	2112176.1634	37.779872906242204	-122.42892877801201	(37.7798729062422, -122.428928778012)
68972	68972	203416	Undocumented 2	Acer rubrum :: Red Maple 6	75 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993822.50089	2096951.1599400002	37.7374737738828	-122.463865194036	(37.7374737738828, -122.463865194036)
69432	69432	220483	Undocumented 2	Acer rubrum :: Red Maple 6	3135 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008148.36276	2102088.69137	37.7523954467163	-122.41469727478399	(37.7523954467163, -122.414697274784)
69713	69713	50679	Permitted Site 1	Acer rubrum :: Red Maple 6	320 Clementina St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/07/2004 12:00:00 AM	2		Permit Number 47253	6011906.20035	2112760.01525	37.781906913717705	-122.40245227846	(37.7819069137177, -122.40245227846)
70375	70375	220478	Undocumented 2	Acer rubrum :: Red Maple 6	211 Prentiss St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6008820.95976	2097493.32849	37.7398153647742	-122.41204658780599	(37.7398153647742, -122.412046587806)
70381	70381	187935	Undocumented 2	Acer rubrum :: Red Maple 6	111 Spear St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6015174.64356	2115822.5435099998	37.790497836842796	-122.391359037593	(37.7904978368428, -122.391359037593)
72520	72520	220489	Undocumented 2	Acer rubrum :: Red Maple 6	3347 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006044.722580001	2103141.37502	37.755167455821706	-122.422046794428	(37.7551674558217, -122.422046794428)
74171	74171	203427	Undocumented 2	Acer rubrum :: Red Maple 6	101 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5994083.74487	2096763.2179299998	37.7369727831569	-122.462948326201	(37.7369727831569, -122.462948326201)
75843	75843	50681	Permitted Site 1	Acer rubrum :: Red Maple 6	320 Clementina St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/07/2004 12:00:00 AM	2		Permit Number 47253	6011867.27865	2112722.46624	37.7818016399861	-122.402584289042	(37.7818016399861, -122.402584289042)
76056	76056	189074	Undocumented 2	Acer rubrum :: Red Maple 6	1111 Bryant St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009972.167330001	2108791.01573	37.770900811749	-122.40886305789101	(37.770900811749, -122.408863057891)
76766	76766	50680	Permitted Site 1	Acer rubrum :: Red Maple 6	320 Clementina St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/07/2004 12:00:00 AM	2		Permit Number 47253	6011881.28809	2112735.18958	37.7818373574415	-122.40253671761002	(37.7818373574415, -122.40253671761)
76989	76989	88169	Permitted Site 1	Acer rubrum :: Red Maple 6	360 Clementina St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM	2	3x3	Permit Number 51186	6011742.09911	2112601.7739	37.781463257472794	-122.403008862566	(37.7814632574728, -122.403008862566)
104454	104454	8231	DPW Maintained 3	Acer rubrum :: Red Maple 6	1500X Galvez Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/16/2008 12:00:00 AM	2	3x3		6016396.247314	2097296.3974116	37.739696749128896	-122.385840466933	(37.7396967491289, -122.385840466933)
113409	113409	104203	Permitted Site 1	Acer rubrum :: Red Maple 6	3135 24th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/30/2015 12:00:00 AM	2	3x3	Permit Number 770708	6008143.9	2102068.3	37.7523392058798	-122.41471126484	(37.7523392058798, -122.41471126484)
118100	118100	141592	DPW Maintained 3	Acer rubrum :: Red Maple 6	700x DIVISADERO ST	8	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6001554.6124	2111065.2353	37.776670158115294	-122.438142474688	(37.7766701581153, -122.438142474688)
122330	122330	104202	Permitted Site 1	Acer rubrum :: Red Maple 6	3135 24th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/30/2015 12:00:00 AM	2	3x3	Permit Number 770708	6008143.9	2102068.3	37.7523392058798	-122.41471126484	(37.7523392058798, -122.41471126484)
130360	130360	203420	Undocumented 2	Acer rubrum :: Red Maple 6	15 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993455.07316	2097218.01136	37.7381853004145	-122.465154930655	(37.7381853004145, -122.465154930655)
130777	130777	203419	Undocumented 2	Acer rubrum :: Red Maple 6	35 Yerba Buena Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993568.7451	2097128.9038799999	37.7379471878035	-122.464755443717	(37.7379471878035, -122.464755443717)
131469	131469	139862	Undocumented 2	Acer rubrum :: Red Maple 6	716 MCALLISTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6005633.1637	2112080.6752	37.7796894214359	-122.424105782878	(37.7796894214359, -122.424105782878)
131506	131506	137746	DPW Maintained 3	Acer rubrum :: Red Maple 6	1100x DIVISADERO ST	8	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6001366.2242	2112424.9338	37.78039283031271	-122.43889162608299	(37.7803928303127, -122.438891626083)
132785	132785	203421	Undocumented 2	Acer rubrum :: Red Maple 6	11 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5993401.40723	2097258.40143	37.738293106632	-122.46534341236799	(37.738293106632, -122.465343412368)
132940	132940	220482	Undocumented 2	Acer rubrum :: Red Maple 6	3135 24th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008165.93149	2102089.85128	37.7523996186474	-122.41463660112	(37.7523996186474, -122.41463660112)
133287	133287	141982	Undocumented 2	Acer rubrum :: Red Maple 6	961 Buchanan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6004375.3351	2111847.7501	37.7789787686216	-122.42844055250099	(37.7789787686216, -122.428440552501)
135416	135416	141317	DPW Maintained 3	Acer rubrum :: Red Maple 6	1300x DIVISADERO ST	2	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6001294.3096	2112929.1823	37.781773276597	-122.439176563192	(37.781773276597, -122.439176563192)
136065	136065	189095	Undocumented 2	Acer rubrum :: Red Maple 6	1444 Galvez Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016045.1574	2097570.04683	37.740428699728795	-122.387073478453	(37.7404286997288, -122.387073478453)
136169	136169	187963	Undocumented 2	Acer rubrum :: Red Maple 6	887 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011307.83557	2110065.72968	37.7744756087874	-122.404332658345	(37.7744756087874, -122.404332658345)
137243	137243	247890	DPW Maintained 3	Acer rubrum :: Red Maple 6	300x Divisadero St	6	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6001764.2019	2109653.3044	37.772805266826	-122.43731631988899	(37.772805266826, -122.437316319889)
137715	137715	88170	Permitted Site 1	Acer rubrum :: Red Maple 6	360 Clementina St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM	2	3x3	Permit Number 51186	6011731.581680001	2112591.71808	37.781435059217	-122.403044540485	(37.781435059217, -122.403044540485)
137784	137784	220453	Undocumented 2	Acer rubrum :: Red Maple 6	2125 Bryant St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009603.845	2104860.4986799997	37.7600878751631	-122.409859601148	(37.7600878751631, -122.409859601148)
147976	147976	203424	Undocumented 2	Acer rubrum :: Red Maple 6	135 Yerba Buena Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5994267.45762	2096626.89262	37.7366090478713	-122.462303269505	(37.7366090478713, -122.462303269505)
150271	150271	187954	Undocumented 2	Acer rubrum :: Red Maple 6	350 Fremont St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014772.69279	2114599.27503	37.7871167070277	-122.392664164317	(37.7871167070277, -122.392664164317)
151063	151063	187960	Undocumented 2	Acer rubrum :: Red Maple 6	43 Lansing St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014392.0374	2114215.18935	37.7860409478825	-122.393954261603	(37.7860409478825, -122.393954261603)
152242	152242	187955	Undocumented 2	Acer rubrum :: Red Maple 6	374 Fremont St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014803.465419999	2114565.3500200002	37.7870252657357	-122.392555322966	(37.7870252657357, -122.392555322966)
152475	152475	220471	Undocumented 2	Acer rubrum :: Red Maple 6	100 Alemany Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009494.822380001	2095997.42417	37.735745720287106	-122.4096110906	(37.7357457202871, -122.4096110906)
152580	152580	220480	Undocumented 2	Acer rubrum :: Red Maple 6	211 Prentiss St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6008820.1543	2097512.38681	37.739867649565	-122.412050719273	(37.739867649565, -122.412050719273)
153460	153460	175132	Undocumented 2	Acer rubrum :: Red Maple 6	3209 San Bruno Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011889.98271	2090759.5366599998	37.7214974885945	-122.400962135093	(37.7214974885945, -122.400962135093)
155871	155871	203426	Undocumented 2	Acer rubrum :: Red Maple 6	135 Yerba Buena Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5994229.44749	2096660.50029	37.7366991374492	-122.462437122787	(37.7366991374492, -122.462437122787)
156609	156609	187959	Undocumented 2	Acer rubrum :: Red Maple 6	43 Lansing St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014377.78304	2114198.9625	37.7859956004712	-122.39400244187	(37.7859956004712, -122.39400244187)
158413	158413	244889	DPW Maintained 3	Acer rubrum :: Red Maple 6	300x Divisadero St	4	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6001777.0914	2109578.0026	37.7725992395847	-122.437266340921	(37.7725992395847, -122.437266340921)
159298	159298	141318	DPW Maintained 3	Acer rubrum :: Red Maple 6	1300x DIVISADERO ST	3	Median : Cutout 11	Tree 1	DPW 2			2	Width 0ft		6001293.2943	2112947.457	37.781823396493394	-122.439181385856	(37.7818233964934, -122.439181385856)
160113	160113	203408	Undocumented 2	Acer rubrum :: Red Maple 6	1945 08th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5993769.17892	2102256.91781	37.7520389725334	-122.464434672649	(37.7520389725334, -122.464434672649)
160744	160744	57791	Permitted Site 1	Acer rubrum :: Red Maple 6	360 Clementina St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/08/1977 12:00:00 AM	2		Permit Number 16718	6011755.44922	2112615.88032	37.781502735900105	-122.402963669841	(37.7815027359001, -122.402963669841)
161235	161235	139864	Undocumented 2	Acer rubrum :: Red Maple 6	716 MCALLISTER ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6005563.5601	2112069.7671	37.779655540357105	-122.424345796171	(37.7796555403571, -122.424345796171)
161595	161595	220484	Undocumented 2	Acer rubrum :: Red Maple 6	3135 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008130.03653	2102087.80047	37.752391970833294	-122.41476058704399	(37.7523919708333, -122.414760587044)
161655	161655	189075	Undocumented 2	Acer rubrum :: Red Maple 6	1111 Bryant St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009987.72673	2108804.8794	37.7709397497056	-122.408810215546	(37.7709397497056, -122.408810215546)
161699	161699	203411	Undocumented 2	Acer rubrum :: Red Maple 6	1945 08th Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5993801.541669999	2102222.78745	37.751947124766104	-122.46432028066201	(37.7519471247661, -122.464320280662)
161993	161993	189077	Undocumented 2	Acer rubrum :: Red Maple 6	1047 Bryant St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010192.31636	2109010.06883	37.7715146098343	-122.408117004595	(37.7715146098343, -122.408117004595)
162583	162583	203415	Undocumented 2	Acer rubrum :: Red Maple 6	95 Yerba Buena Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5993910.70196	2096889.9014700002	37.7373106557719	-122.463555799377	(37.7373106557719, -122.463555799377)
162619	162619	189094	Undocumented 2	Acer rubrum :: Red Maple 6	1444 Galvez Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016058.30905	2097557.96705	37.7403962593718	-122.387027162495	(37.7403962593718, -122.387027162495)
162816	162816	220428	Undocumented 2	Acer rubrum :: Red Maple 6	1401 Bryant St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009431.86283	2107936.52181	37.7685242902996	-122.410671638589	(37.7685242902996, -122.410671638589)
163119	163119	189086	Undocumented 2	Acer rubrum :: Red Maple 6	350 Tehama St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011640.52015	2112779.45353	37.781945451451605	-122.403372782229	(37.7819454514516, -122.403372782229)
165085	165085	189090	Undocumented 2	Acer rubrum :: Red Maple 6	1433 Galvez Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6016367.14346	2097329.17086	37.7397851277689	-122.385943380483	(37.7397851277689, -122.385943380483)
165831	165831	139861	Undocumented 2	Acer rubrum :: Red Maple 6	710 McAllister St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6005666.4072	2112084.3112	37.779701281894205	-122.42399103767299	(37.7797012818942, -122.423991037673)
166947	166947	189083	Undocumented 2	Acer rubrum :: Red Maple 6	320 Clementina St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011822.07431	2112680.25228	37.7816832064575	-122.402737706174	(37.7816832064575, -122.402737706174)
167105	167105	189081	Undocumented 2	Acer rubrum :: Red Maple 6	320 Clementina St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011852.23142	2112709.4214	37.781764981806795	-122.4026354281	(37.7817649818068, -122.4026354281)

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