Street_Tree_List

Data source: data.sfgov.org

630 rows where qSiteInfo = 2 and qSpecies = 54 sorted by qAddress

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, PlantType, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
42045	42045	182773	Undocumented 2	:: 54	1 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985975.4571	2103368.6441	37.754639125693004	-122.491467955558	(37.754639125693, -122.491467955558)
27474	27474	183607	Undocumented 2	:: 54	1 Quintara St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989903.61	2101103.2452	37.748647706091596	-122.477717911497	(37.7486477060916, -122.477717911497)
189029	189029	140863	Undocumented 2	:: 54	106 JORDAN AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5996246.41	2113718.2127	37.7836512118011	-122.45669690496901	(37.7836512118011, -122.456696904969)
178876	178876	200201	Undocumented 2	:: 54	1090 Ingerson Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6013694.5474	2090234.3998	37.7201560648851	-122.394687445541	(37.7201560648851, -122.394687445541)
54871	54871	200168	Undocumented 2	:: 54	1101 Gilman Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014990.039	2089901.3883	37.7193136223873	-122.390186075408	(37.7193136223873, -122.390186075408)
176452	176452	200497	Undocumented 2	:: 54	1110 Gilman Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014977.2953	2089975.1673	37.7195154981888	-122.39023527774799	(37.7195154981888, -122.390235277748)
74672	74672	140885	Undocumented 2	:: 54	112 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5996566.0494	2113683.1859999998	37.7835733852629	-122.45558854835899	(37.7835733852629, -122.455588548359)
177939	177939	200226	Undocumented 2	:: 54	1131 Fitzgerald Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6015013.4132	2090222.9153	37.720197768832605	-122.390127728915	(37.7201977688326, -122.390127728915)
75983	75983	183877	Undocumented 2	:: 54	1145 Quintara St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989814.4341	2101045.8603	37.7484849666087	-122.47802208270001	(37.7484849666087, -122.4780220827)
54059	54059	185599	Undocumented 2	:: 54	1200 Quintara St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989708.1577	2101099.3093	37.7486255543569	-122.47839348828	(37.7486255543569, -122.47839348828)
179934	179934	185601	Undocumented 2	:: 54	1200 Quintara St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989640.5487	2101098.6399	37.7486197911777	-122.478627227884	(37.7486197911777, -122.478627227884)
42137	42137	186840	Undocumented 2	:: 54	1201 36th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984884.6409	2106758.5555	37.763883073514	-122.495490239842	(37.763883073514, -122.495490239842)
176831	176831	184891	Undocumented 2	:: 54	1201 Sunset Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984723.2958	2106746.9726	37.7638418212229	-122.49604742094299	(37.7638418212229, -122.496047420943)
160327	160327	183333	Undocumented 2	:: 54	1211 43rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982706.5384	2106850.7636	37.764008470840295	-122.503030341532	(37.7640084708403, -122.503030341532)
116050	116050	111759	Permitted Site 1	:: 54	1235 47th Ave	2	Sidewalk: Curb side : Yard 2	Landscaping 2	Private 1		06/23/2015 12:00:00 AM	3	6x4		5981472.7	2106671.7	37.7634442160317	-122.50728446314301	(37.7634442160317, -122.507284463143)
70039	70039	181610	Undocumented 2	:: 54	1242 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984929.7396	2106734.1122	37.763818599731295	-122.49533245658002	(37.7638185997313, -122.49533245658)
153241	153241	183271	Undocumented 2	:: 54	1242 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982138.4385	2106630.5909	37.7633705325139	-122.504978880674	(37.7633705325139, -122.504978880674)
24606	24606	181614	Undocumented 2	:: 54	1246 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984927.2833	2106710.1633	37.7637526989564	-122.49533918573601	(37.7637526989564, -122.495339185736)
62201	62201	184810	Undocumented 2	:: 54	1250 37th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984625.0742	2106537.48	37.763260859986204	-122.49637167575001	(37.7632608599862, -122.49637167575)
168551	168551	181616	Undocumented 2	:: 54	1251 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985196.2484	2106684.3721	37.76369762797	-122.494407030493	(37.76369762797, -122.494407030493)
158614	158614	186842	Undocumented 2	:: 54	1251 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984888.6931	2106439.91	37.763008399663796	-122.49545272217699	(37.7630083996638, -122.495452722177)
169422	169422	184811	Undocumented 2	:: 54	1251 Sunset Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984734.8773	2106435.4128	37.762987043878105	-122.495984378629	(37.7629870438781, -122.495984378629)
114902	114902	183304	Undocumented 2	:: 54	1263 42nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983031.5884	2106472.5871	37.762989205720295	-122.5018781248	(37.7629892057203, -122.5018781248)
23724	23724	181665	Undocumented 2	:: 54	1275 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985511.3315	2106531.7973	37.7632971348656	-122.49330603001499	(37.7632971348656, -122.493306030015)
130942	130942	181670	Undocumented 2	:: 54	1278 36th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984935.2663	2106495.8509	37.763164724632	-122.495295769501	(37.763164724632, -122.495295769501)
67853	67853	181667	Undocumented 2	:: 54	1279 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985203.0032	2106516.7295	37.7632377236324	-122.49437130988599	(37.7632377236324, -122.494371309886)
131636	131636	181666	Undocumented 2	:: 54	1282 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985866.1245	2106507.5934	37.7632514235254	-122.49207715278901	(37.7632514235254, -122.492077152789)
129908	129908	181679	Undocumented 2	:: 54	1282 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984937.7226	2106471.2879	37.7630974253349	-122.49528546256799	(37.7630974253349, -122.495285462568)
171125	171125	181674	Undocumented 2	:: 54	1286 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985866.1245	2106482.2089	37.7631817247551	-122.492075283673	(37.7631817247551, -122.492075283673)
187636	187636	183293	Undocumented 2	:: 54	1286 42nd Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983075.6533	2106421.6609	37.76285196523921	-122.50172195396401	(37.7628519652392, -122.501721953964)
39591	39591	181680	Undocumented 2	:: 54	1290 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985868.4858	2106459.7761	37.7631202685599	-122.492065465074	(37.7631202685599, -122.492065465074)
183672	183672	200636	Undocumented 2	:: 54	1301 Quesada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6016782.3625	2093458.8747	37.729181036936396	-122.384238246013	(37.7291810369364, -122.384238246013)
49494	49494	182045	Undocumented 2	:: 54	1334 27th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987740.8439	2106201.6024	37.7625206645495	-122.485570743348	(37.7625206645495, -122.485570743348)
135049	135049	182043	Undocumented 2	:: 54	1354 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988055.225	2106072.8198	37.7621853748408	-122.48447398103	(37.7621853748408, -122.48447398103)
61348	61348	182050	Undocumented 2	:: 54	1354 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987434.16	2106064.4759	37.762126279391495	-122.486621368216	(37.7621262793915, -122.486621368216)
176810	176810	182055	Undocumented 2	:: 54	1358 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987435.6115	2106037.3813	37.76205196967079	-122.486614358562	(37.7620519696708, -122.486614358562)
55449	55449	183888	Undocumented 2	:: 54	1390 Quintara St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5988941.521000001	2101013.106	37.7483443270077	-122.48103816738501	(37.7483443270077, -122.481038167385)
65435	65435	183890	Undocumented 2	:: 54	1390 Quintara St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5988977.7676	2101017.0459	37.748357251925604	-122.480913117409	(37.7483572519256, -122.480913117409)
133057	133057	183886	Undocumented 2	:: 54	1390 Quintara St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5988900.5466	2101013.106	37.7483419450285	-122.48117985419901	(37.7483419450285, -122.481179854199)
167807	167807	183887	Undocumented 2	:: 54	1390 Quintara St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5988922.6098	2101013.894	37.748345391297	-122.481103618778	(37.748345391297, -122.481103618778)
169919	169919	183889	Undocumented 2	:: 54	1390 Quintara St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5988959.6443	2101014.682	37.748349707800706	-122.480975613562	(37.7483497078007, -122.480975613562)
178904	178904	183885	Undocumented 2	:: 54	1390 Quintara St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988878.4835	2101013.894	37.7483428259954	-122.481256204658	(37.7483428259954, -122.481256204658)
159736	159736	182495	Undocumented 2	:: 54	1400 Lawton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989908.6148	2104504.8472	37.7579878947596	-122.477949247809	(37.7579878947596, -122.477949247809)
163269	163269	182498	Undocumented 2	:: 54	1400 Lawton St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989876.9695	2104503.8264	37.7579832551541	-122.478058614852	(37.7579832551541, -122.478058614852)
129662	129662	200808	Undocumented 2	:: 54	1401 Oakdale Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6016065.8568	2094678.3259	37.732489764259896	-122.386800296411	(37.7324897642599, -122.386800296411)
77134	77134	186639	Undocumented 2	:: 54	1401 Sunset Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984754.4469	2105410.0332	37.7601727847523	-122.495841051742	(37.7601727847523, -122.495841051742)
183358	183358	182230	Undocumented 2	:: 54	1423 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986783.0013	2105561.4949	37.7607072513694	-122.48883647166402	(37.7607072513694, -122.488836471664)
170096	170096	182240	Undocumented 2	:: 54	1427 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985548.7085	2105482.2958	37.7604176820805	-122.49309944026001	(37.7604176820805, -122.49309944026)
181424	181424	182239	Undocumented 2	:: 54	1434 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985592.8101	2105449.5872	37.7603304525285	-122.492944506053	(37.7603304525285, -122.492944506053)
51444	51444	182242	Undocumented 2	:: 54	1434 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985282.2615	2105425.6988	37.760246695704296	-122.49401677245301	(37.7602466957043, -122.494016772453)
130242	130242	182243	Undocumented 2	:: 54	1434 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985284.8341	2105439.6643	37.760285191609704	-122.49400890443701	(37.7602851916097, -122.494008904437)
66774	66774	182249	Undocumented 2	:: 54	1439 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985551.6486	2105407.6907	37.760213009140394	-122.49308377605301	(37.7602130091404, -122.493083776053)
82852	82852	182257	Undocumented 2	:: 54	1439 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985240.365	2105399.9729	37.760173608006795	-122.494159774452	(37.7601736080068, -122.494159774452)
178124	178124	140889	Undocumented 2	:: 54	145 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5996520.3624	2113408.7259	37.7828171689042	-122.455726761043	(37.7828171689042, -122.455726761043)
64173	64173	182244	Undocumented 2	:: 54	1451 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985553.1187	2105344.1109	37.76003852263371	-122.49307400807	(37.7600385226337, -122.49307400807)
177991	177991	182247	Undocumented 2	:: 54	1454 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985597.5878	2105309.9322	37.759947278047	-122.49291769541	(37.759947278047, -122.49291769541)
153742	153742	182259	Undocumented 2	:: 54	1458 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985599.4253	2105281.2662	37.759868676617295	-122.49290922894899	(37.7598686766173, -122.492909228949)
183796	183796	182261	Undocumented 2	:: 54	1458 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984977.3774	2105263.7356	37.759784145824796	-122.495059264357	(37.7597841458248, -122.495059264357)
125059	125059	182262	Undocumented 2	:: 54	1470 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986846.581	2105248.3737	37.75985121691	-122.488593566259	(37.75985121691, -122.488593566259)
26866	26866	182267	Undocumented 2	:: 54	1474 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986846.9486	2105227.058	37.7597927113016	-122.48859072822201	(37.7597927113016, -122.488590728222)
56730	56730	182273	Undocumented 2	:: 54	1476 Kirkham St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984979.982000001	2105177.4437	37.759547364784005	-122.49504389343001	(37.759547364784, -122.49504389343)
176960	176960	182283	Undocumented 2	:: 54	1480 Kirkham St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984982.9221	2105136.6498	37.759435528213295	-122.49503071720501	(37.7594355282133, -122.495030717205)
64214	64214	182021	Undocumented 2	:: 54	1482 23rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989015.4194	2105269.3195	37.7600350476288	-122.481094235982	(37.7600350476288, -122.481094235982)
172444	172444	182022	Undocumented 2	:: 54	1485 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988969.589	2105248.6669	37.7599756768116	-122.481251227094	(37.7599756768116, -122.481251227094)
135256	135256	182297	Undocumented 2	:: 54	1487 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985250.2879	2105109.27	37.7593759993104	-122.494104030349	(37.7593759993104, -122.494104030349)
170755	170755	182299	Undocumented 2	:: 54	1488 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984983.3631	2105103.503	37.7593445421458	-122.495026747872	(37.7593445421458, -122.495026747872)
173957	173957	182333	Undocumented 2	:: 54	1492 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984985.2048	2105079.0997	37.759277645293004	-122.495018579042	(37.759277645293, -122.495018579042)
38295	38295	182332	Undocumented 2	:: 54	1494 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985606.7756	2105058.9207	37.759258607335795	-122.49286743066601	(37.7592586073358, -122.492867430666)
64379	64379	182272	Undocumented 2	:: 54	1494 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985296.227000001	2105059.6558	37.7592424604916	-122.493941496366	(37.7592424604916, -122.493941496366)
80892	80892	104890	Undocumented 2	:: 54	150 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1					empty	5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
160359	160359	182300	Undocumented 2	:: 54	1500 30th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986856.0433	2104995.7847	37.759158228979395	-122.488542276378	(37.7591582289794, -122.488542276378)
24402	24402	182453	Undocumented 2	:: 54	1500 31st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986555.3586	2104541.3333	37.7578928802813	-122.489548755928	(37.7578928802813, -122.489548755928)
59859	59859	182338	Undocumented 2	:: 54	1500 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985300.2446	2104944.7863	37.7589272957976	-122.493919136306	(37.7589272957976, -122.493919136306)
131747	131747	182358	Undocumented 2	:: 54	1500 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984989.5192	2104937.1307	37.758888090491396	-122.49499318974199	(37.7588880904914, -122.494993189742)
188435	188435	186529	Undocumented 2	:: 54	1500 37th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984686.823	2104775.4574	37.7584264560006	-122.496028111274	(37.7584264560006, -122.496028111274)
42573	42573	182319	Undocumented 2	:: 54	1501 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985874.6235	2104973.8958	37.7590408120895	-122.491934836437	(37.7590408120895, -122.491934836437)
23835	23835	182329	Undocumented 2	:: 54	1501 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985565.7361	2104954.3084	37.75896897093661	-122.493001657059	(37.7589689709366, -122.493001657059)
174948	174948	200699	Undocumented 2	:: 54	1501 Lane St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6015860.7307	2095472.4329	37.734658863200295	-122.38756485421699	(37.7346588632003, -122.387564854217)
40764	40764	186526	Undocumented 2	:: 54	1501 Sunset Blvd	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984782.9201	2104548.9278	37.7578100967767	-122.495679060793	(37.7578100967767, -122.495679060793)
52083	52083	182365	Undocumented 2	:: 54	1505 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985565.9373	2104941.1837	37.7589329459117	-122.492999994431	(37.7589329459117, -122.492999994431)
76068	76068	182366	Undocumented 2	:: 54	1505 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985564.5863	2104923.1706	37.75888340791779	-122.49300333987	(37.7588834079178, -122.49300333987)
57670	57670	184229	Undocumented 2	:: 54	1505 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984635.1684	2104924.59	37.7588329069479	-122.496217756229	(37.7588329069479, -122.496217756229)
167915	167915	182369	Undocumented 2	:: 54	1506 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985301.1453	2104914.1641	37.7588432684324	-122.493913764581	(37.7588432684324, -122.493913764581)
148435	148435	182359	Undocumented 2	:: 54	1507 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985875.7832	2104950.7021	37.758977196383	-122.491929118122	(37.758977196383, -122.491929118122)
153448	153448	182334	Undocumented 2	:: 54	1507 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985257.4301	2104914.9526	37.758842875608	-122.494065007935	(37.758842875608, -122.494065007935)
153357	153357	182370	Undocumented 2	:: 54	1510 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985922.1706	2104913.0124	37.7588764221419	-122.491765916351	(37.7588764221419, -122.491765916351)
159364	159364	182280	Undocumented 2	:: 54	1511 20th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989906.0628	2105040.7763	37.7594592646002	-122.477997253629	(37.7594592646002, -122.477997253629)
178140	178140	184288	Undocumented 2	:: 54	1514 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983440.9844	2104806.182	37.7584377683924	-122.500338977609	(37.7584377683924, -122.500338977609)
64351	64351	184376	Undocumented 2	:: 54	1519 Rivera St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988462.8161	2100320.0913	37.746413652985204	-122.482642720881	(37.7464136529852, -122.482642720881)
181267	181267	182396	Undocumented 2	:: 54	1522 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985925.6496	2104840.5319999997	37.7586776143061	-122.491748548818	(37.7586776143061, -122.491748548818)
41142	41142	182408	Undocumented 2	:: 54	1523 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985878.6824	2104848.6498	37.7586971584144	-122.49191157818301	(37.7586971584144, -122.491911578183)
60397	60397	184231	Undocumented 2	:: 54	1523 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983398.5095	2104764.9295	37.758322007374204	-122.500482822231	(37.7583220073742, -122.500482822231)
39413	39413	182439	Undocumented 2	:: 54	1524 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984994.4728	2104793.4765	37.758493945986	-122.494965465844	(37.758493945986, -122.494965465844)
170205	170205	182427	Undocumented 2	:: 54	1526 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985304.2975	2104805.6353	37.758545462882296	-122.493894864934	(37.7585454628823, -122.493894864934)
163297	163297	184262	Undocumented 2	:: 54	1526 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983444.9569	2104728.5661	37.7582248901335	-122.50031950085199	(37.7582248901335, -122.500319500852)
40047	40047	182426	Undocumented 2	:: 54	1527 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985880.4219	2104826.6158	37.758636760808294	-122.49190394010901	(37.7586367608083, -122.491903940109)
32483	32483	182444	Undocumented 2	:: 54	1530 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985615.2362	2104790.3432	37.758521662620296	-122.49281838798099	(37.7585216626203, -122.492818387981)
175461	175461	182445	Undocumented 2	:: 54	1530 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985616.5233	2104773.8077	37.7584763359765	-122.492812718757	(37.7584763359765, -122.492812718757)
169896	169896	182442	Undocumented 2	:: 54	1531 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985882.8133	2104801.2603	37.7585672813824	-122.491893802983	(37.7585672813824, -122.491893802983)
70922	70922	182399	Undocumented 2	:: 54	1534 26th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988097.2897	2104845.6767	37.7588184233818	-122.48423849651199	(37.7588184233818, -122.484238496512)

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