Street_Tree_List

Data source: data.sfgov.org

141 rows where PlotSize = "Width 3ft" and qSpecies = 42 sorted by XCoord

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
32938	32938	203645	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2450 17th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5991098.28096	2098726.3101	37.7421905156936	-122.473413447294	(37.7421905156936, -122.473413447294)
152749	152749	203644	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2450 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5991098.76282	2098712.81343	37.742153485208796	-122.47341079698799	(37.7421534852088, -122.473410796988)
56688	56688	122010	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1342 Cabrillo St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5991362.52356	2110673.50037	37.775009640229605	-122.473370979732	(37.7750096402296, -122.473370979732)
169675	169675	203643	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	2479 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5991370.41192	2098543.97685	37.7417056300124	-122.47245922253201	(37.7417056300124, -122.472459222532)
165659	165659	203641	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	608 Garfield St	1	: 4	Tree 1	Private 1			9	Width 3ft		5992400.09934	2090515.7050700001	37.7197215370907	-122.468315017932	(37.7197215370907, -122.468315017932)
2852	2852	215287	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	335 Noriega St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft	Permit Number 780412	5992944.71929	2103190.50616	37.7545548052666	-122.46735363008301	(37.7545548052666, -122.467353630083)
179662	179662	203222	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	120 Taraval St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5993081.79545	2099194.6713799997	37.7435911783029	-122.466589164064	(37.7435911783029, -122.466589164064)
62851	62851	203648	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1907 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5993437.25696	2102479.71785	37.7526315852957	-122.46559868313	(37.7526315852957, -122.46559868313)
149197	149197	203647	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	70 Manor Dr	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		5993596.72892	2093377.0999599998	37.7276472749004	-122.46438636913099	(37.7276472749004, -122.464386369131)
151268	151268	203651	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1390 Monterey Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		5993846.97887	2094818.6059299998	37.731619718855704	-122.46362583408701	(37.7316197188557, -122.463625834087)
157925	157925	203650	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1390 Monterey Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		5993848.38247	2094813.0241599998	37.7316044735649	-122.46362057664699	(37.7316044735649, -122.463620576647)
178200	178200	203649	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1390 Monterey Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		5993852.26622	2094804.8663700002	37.731582298063394	-122.46360655802201	(37.7315822980634, -122.463606558022)
62900	62900	203646	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	45 Dorantes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994072.18954	2100047.28757	37.745989350944	-122.463226505408	(37.745989350944, -122.463226505408)
133071	133071	203620	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	358 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994207.97815	2101247.70705	37.7492932209146	-122.46284404261101	(37.7492932209146, -122.462844042611)
27343	27343	203223	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	25 Upland Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5994463.96401	2093754.2883099997	37.7287328942013	-122.461415680898	(37.7287328942013, -122.461415680898)
173115	173115	203638	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	750 Grafton Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5994537.11563	2090599.0913099998	37.720073694513104	-122.46093420637101	(37.7200736945131, -122.460934206371)
59298	59298	203625	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	15 Teresita Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5997311.4729	2099621.76413	37.7450070466421	-122.45199486067499	(37.7450070466421, -122.451994860675)
43667	43667	203624	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	15 Teresita Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5997319.6106	2099609.0427	37.7449725828299	-122.45196580449199	(37.7449725828299, -122.451965804492)
93809	93809	203623	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	15 Teresita Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5997330.81089	2099592.0734900003	37.744926631064	-122.45192585212	(37.744926631064, -122.45192585212)
151042	151042	203622	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	15 Teresita Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5997339.998380001	2099579.33016	37.7448921672303	-122.45189316446002	(37.7448921672303, -122.45189316446)
76199	76199	220046	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	170 Saint Germain Ave	1	: 4	Tree 1	Private 1			6	Width 3ft		5997546.7288	2104141.22433	37.7574298380281	-122.451507313917	(37.7574298380281, -122.451507313917)
58064	58064	220047	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1201 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5997716.00381	2106428.96316	37.7637210849721	-122.451086869165	(37.7637210849721, -122.451086869165)
132310	132310	203658	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	531 Foerster St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5998103.1876300005	2095162.16833	37.732807386054795	-122.448936084745	(37.7328073860548, -122.448936084745)
53663	53663	220045	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	160 Marview Way	1	: 4	Tree 1	Private 1			5	Width 3ft		5998323.68704	2103258.27383	37.755049936933	-122.448756699664	(37.755049936933, -122.448756699664)
179419	179419	203660	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	634 Edna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5998582.52704	2094910.5588200002	37.732143927389295	-122.44726079165399	(37.7321439273893, -122.447260791654)
166210	166210	203659	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	628 Edna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5998583.28764	2094893.18321	37.7320962615306	-122.44725691200199	(37.7320962615306, -122.447256912002)
53649	53649	219989	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	936 Clayton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5998793.85425	2106724.38466	37.7645938887298	-122.447380197361	(37.7645938887298, -122.447380197361)
170961	170961	219988	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	936 Clayton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5998797.49873	2106712.69483	37.7645619996538	-122.447366750686	(37.7645619996538, -122.447366750686)
47237	47237	220016	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	70 Quartz Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5998965.77386	2099787.09557	37.74555562500829	-122.44628649854201	(37.7455556250083, -122.446286498542)
67963	67963	220015	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	70 Quartz Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5998973.5201	2099794.49518	37.745576384946	-122.44626024553601	(37.745576384946, -122.446260245536)
154734	154734	203652	DPW Maintained 3	Acacia baileyana :: Bailey's Acacia 42	400x Marietta Dr	38	Median : Cutout 11	Tree 1	DPW 2			6	Width 3ft		5999131.48243	2096996.51385	37.737902818863795	-122.445512879233	(37.7379028188638, -122.445512879233)
185230	185230	219990	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	151 Delmar St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5999384.54447	2107324.60583	37.766275682101	-122.445380326357	(37.766275682101, -122.445380326357)
186973	186973	220091	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3076 Merritt St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6000057.55788	2105416.72092	37.7610754998513	-122.442915486985	(37.7610754998513, -122.442915486985)
148974	148974	174958	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	60 Onondaga Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6000890.31977	2091107.65045	37.7218336102096	-122.439009814053	(37.7218336102096, -122.439009814053)
33288	33288	220075	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	311 Douglass St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6001146.06945	2104525.9934099996	37.758691778412704	-122.43908696419201	(37.7586917784127, -122.439086964192)
185200	185200	220017	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	78 Berkeley Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6001185.230140001	2097348.08527	37.7389851844145	-122.438437264296	(37.7389851844145, -122.438437264296)
45390	45390	220087	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	69 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001718.50654	2105457.8427	37.7612829653482	-122.437173938027	(37.7612829653482, -122.437173938027)
188143	188143	220086	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	77 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6001721.7342	2105412.03314	37.761157366929204	-122.43715949493601	(37.7611573669292, -122.437159494936)
172135	172135	220019	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4326 Cesar Chavez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6001759.60763	2100322.6693	37.747185348536895	-122.436664198694	(37.7471853485369, -122.436664198694)
38287	38287	220026	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	685 Alvarado St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6001902.38031	2102621.8344	37.753506421492	-122.436335023459	(37.753506421492, -122.436335023459)
130349	130349	220027	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	685 Alvarado St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001922.66093	2102622.7782400004	37.7535101653675	-122.43626495635701	(37.7535101653675, -122.436264956357)
129705	129705	220028	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	685 Alvarado St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001938.58535	2102624.90259	37.7535169030985	-122.436210038379	(37.7535169030985, -122.436210038379)
173012	173012	220020	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1334 Diamond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001963.20475	2100104.97494	37.7465991794258	-122.435944602583	(37.7465991794258, -122.435944602583)
33357	33357	220021	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1334 Diamond St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001964.613530001	2100084.23013	37.7465422991033	-122.435938247064	(37.7465422991033, -122.435938247064)
188982	188982	220022	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1334 Diamond St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6001965.3710900005	2100066.86744	37.746494668288996	-122.435934385359	(37.746494668289, -122.435934385359)
157166	157166	220088	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	18 Divisadero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6001975.9163	2107746.07495	37.767580520153	-122.43644744680701	(37.767580520153, -122.436447446807)
162456	162456	220024	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4273 25th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6002125.33793	2101175.24323	37.749547092337	-122.435460513693	(37.749547092337, -122.435460513693)
44341	44341	220066	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1109 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6002537.114630001	2102291.1496200003	37.7526344847082	-122.434116340213	(37.7526344847082, -122.434116340213)
42523	42523	220064	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4086 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6002590.76073	2102413.7777400003	37.7529742368948	-122.43393958746701	(37.7529742368948, -122.433939587467)
162807	162807	220072	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	60 Hartford St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6002632.838880001	2105513.14285	37.7614867382526	-122.434015605341	(37.7614867382526, -122.434015605341)
49170	49170	220036	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1711 Castro St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6002636.29383	2100481.40221	37.747670974341396	-122.43364403244	(37.7476709743414, -122.43364403244)
188075	188075	220035	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1711 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6002636.34581	2100467.82106	37.7476336866458	-122.433642882219	(37.7476336866458, -122.433642882219)
67640	67640	220077	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4160 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6002637.75275	2104169.9909900003	37.7577990456928	-122.433902601035	(37.7577990456928, -122.433902601035)
45254	45254	220074	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	148 Hartford St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002660.22221	2105037.36162	37.7601819118789	-122.43388688897	(37.7601819118789, -122.43388688897)
53450	53450	220065	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	561 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002722.15364	2102085.17478	37.7520794267235	-122.43346172547501	(37.7520794267235, -122.433461725475)
34367	34367	220083	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4133 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6002828.79114	2104135.9049299997	37.7577162927799	-122.43323947601401	(37.7577162927799, -122.433239476014)
170794	170794	220080	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	517 Liberty St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6002959.284990001	2103850.36087	37.756939658960206	-122.432767777111	(37.7569396589602, -122.432767777111)
40035	40035	220081	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	780 Noe St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6003049.24321	2103668.76893	37.756446152387795	-122.432443698342	(37.7564461523878, -122.432443698342)
133605	133605	220082	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	780 Noe St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6003052.51993	2103630.15774	37.7563403210743	-122.43242960863701	(37.7563403210743, -122.432429608637)
63361	63361	220063	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	930 Noe St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003095.90411	2102839.48353	37.75417177772871	-122.432223106309	(37.7541717777287, -122.432223106309)
47075	47075	220067	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3781 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003185.70208	2103572.60316	37.756189841101296	-122.431964909158	(37.7561898411013, -122.431964909158)
68889	68889	220068	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3749 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003417.1638	2103582.09113	37.756229011985	-122.43116511330601	(37.756229011985, -122.431165113306)
183611	183611	220078	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4021 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003547.22001	2104169.9563599997	37.7578505193113	-122.430757284236	(37.7578505193113, -122.430757284236)
52495	52495	220079	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	4021 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6003566.56829	2104171.42308	37.7578556427516	-122.43069047448799	(37.7578556427516, -122.430690474488)
75192	75192	220070	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	410 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6003569.73703	2105814.1279	37.762366296795996	-122.43079674288	(37.762366296796, -122.43079674288)
28541	28541	220690	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	330 Valley St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003721.786040001	2099258.64688	37.7443751038286	-122.42980326002	(37.7443751038286, -122.42980326002)
59933	59933	220069	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1047 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6003827.33604	2102174.6628400004	37.7523877808826	-122.42964622220501	(37.7523877808826, -122.429646222205)
153239	153239	220071	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3854 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003950.57262	2104825.46317	37.7596732292507	-122.429409067394	(37.7596732292507, -122.429409067394)
55582	55582	220093	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1754 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6003963.29373	2098007.80301	37.7409542473406	-122.428879018678	(37.7409542473406, -122.428879018678)
177028	177028	220692	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3951 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6004169.986740001	2100702.91409	37.7483660981244	-122.42835639293999	(37.7483660981244, -122.42835639294)
175791	175791	220665	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	215 Webster St	1	: 4	Tree 1	Private 1			7	Width 3ft		6004174.507619999	2109590.46036	37.7727694393	-122.42897431622801	(37.7727694393, -122.428974316228)
152179	152179	220084	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3580 21st St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004538.52309	2103691.84305	37.7565938462521	-122.427294885373	(37.7565938462521, -122.427294885373)
136845	136845	124750	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	566 Linden St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6004650.035	2110687.35997	37.775808163060205	-122.42740756863	(37.7758081630602, -122.42740756863)
152034	152034	124751	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	566 Linden St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6004689.62752	2110692.77739	37.775825277144705	-122.427270993988	(37.7758252771447, -122.427270993988)
135419	135419	220693	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3897 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6004694.52758	2100732.52355	37.7484770663623	-122.426544650217	(37.7484770663623, -122.426544650217)
148095	148095	220085	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	223 Liberty St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004732.04309	2103949.70152	37.757312807464	-122.42664398483299	(37.757312807464, -122.426643984833)
154694	154694	220683	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	364 Page St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004832.893569999	2109879.94078	37.7736015271323	-122.426717502624	(37.7736015271323, -122.426717502624)
68651	68651	220688	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	434 Hickory St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6004866.02058	2110397.15298	37.7750235387365	-122.426639749043	(37.7750235387365, -122.426639749043)
53685	53685	220687	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	430 Hickory St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6004894.475319999	2110399.44382	37.775031437471704	-122.426541481018	(37.7750314374717, -122.426541481018)
44479	44479	220686	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	430 Hickory St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6004903.16789	2110400.7033700002	37.775035387294295	-122.426511501216	(37.7750353872943, -122.426511501216)
146931	146931	220695	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3706 23rd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6004965.60953	2102543.32238	37.7534644213631	-122.425736121051	(37.7534644213631, -122.425736121051)
26472	26472	220689	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	119 Valley St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6004994.550369999	2099284.37518	37.744517739909	-122.42540413451401	(37.744517739909, -122.425404134514)
136911	136911	220680	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	54 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6005359.13512	2103393.3623900004	37.7558206631137	-122.424435681558	(37.7558206631137, -122.424435681558)
31819	31819	220062	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	430 College Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 3ft		6005376.5701	2095055.5296099999	37.7329278583224	-122.423782556133	(37.7329278583224, -122.423782556133)
50057	50057	220672	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	25 Cumberland St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005444.88154	2104573.79472	37.759066695887	-122.42422309172701	(37.759066695887, -122.424223091727)
45531	45531	220666	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	1 Dorland St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6005487.19676	2105743.72088	37.7622814268651	-122.42415994852199	(37.7622814268651, -122.424159948522)
152597	152597	220675	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3681 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6005766.61271	2104299.30973	37.758331185361	-122.423090881238	(37.758331185361, -122.423090881238)
187340	187340	220676	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3681 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6005782.66085	2104298.9799099998	37.7583311853523	-122.423035356192	(37.7583311853523, -122.423035356192)
53977	53977	220014	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	60 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6005833.61465	2102298.65201	37.7528416246662	-122.422716983617	(37.7528416246662, -122.422716983617)
155839	155839	220013	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	58 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6005865.660759999	2102301.94093	37.7528524632741	-122.42260639578998	(37.7528524632741, -122.42260639579)
47618	47618	220674	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3548 19th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6005923.11971	2104936.6524900002	37.760090010159104	-122.42259489975201	(37.7600900101591, -122.422594899752)
152367	152367	219998	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	60 Santa Marina St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6005981.24616	2097649.7003900004	37.7400849896219	-122.421876240696	(37.7400849896219, -122.421876240696)
47962	47962	219999	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	62 Santa Marina St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6005999.49716	2097639.92479	37.740059177277004	-122.421812441905	(37.740059177277, -122.421812441905)
158356	158356	220012	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	30 Elizabeth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6006012.224219999	2102309.19405	37.7528806462302	-122.42210006667601	(37.7528806462302, -122.422100066676)
162065	162065	220000	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	62 Santa Marina St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6006013.90538	2097631.08265	37.7400357112669	-122.421761996217	(37.7400357112669, -122.421761996217)
147911	147911	220060	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3505 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6006048.59787	2101976.73727	37.751969847944295	-122.42195066499599	(37.7519698479443, -122.421950664996)
43321	43321	220677	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3625 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6006108.91147	2104316.6789599997	37.758398187543996	-122.42190829343399	(37.758398187544, -122.421908293434)
176834	176834	220059	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3505 24th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6006111.03304	2101975.99077	37.75197131922489	-122.42173470182101	(37.7519713192249, -122.421734701821)
33878	33878	220678	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	3607 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6006149.55219	2104320.61277	37.758411280773394	-122.421768019002	(37.7584112807734, -122.421768019002)
58771	58771	220011	Undocumented 2	Acacia baileyana :: Bailey's Acacia 42	110 San Jose Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6006153.26604	2102345.16587	37.7529873705964	-122.421614871629	(37.7529873705964, -122.421614871629)

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