Street_Tree_List

Data source: data.sfgov.org

287 rows where SiteOrder = 2 and qSpecies = 54 sorted by Longitude

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, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
1391	1391	251531	Permitted Site 1	:: 54	2100X 20th St	2	Sidewalk: Curb side : Cutout 1	Landscaping 2	Private 1		05/15/2017 12:00:00 AM	3	4x11
5236	5236	253833	Permitted Site 1	:: 54	607 Eddy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	DPW 4			3x3
56605	56605	183337	Undocumented 2	:: 54	4709 Lincoln Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5981120.829	2106873.2612	37.7639769129553	-122.50851641382499	(37.7639769129553, -122.508516413825)
41978	41978	184524	Undocumented 2	:: 54	1984 Lower Great Hwy	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5981181.0558	2101584.0989	37.7494579320564	-122.50791555821199	(37.7494579320564, -122.507915558212)
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)
150982	150982	184531	Undocumented 2	:: 54	4043 Ortega St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5981413.5516	2102117.7901	37.7509369936281	-122.507151182389	(37.7509369936281, -122.507151182389)
129782	129782	183637	Undocumented 2	:: 54	1478 47th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5981569.3227	2105033.4266	37.758951677708204	-122.506828758953	(37.7589516777082, -122.506828758953)
188648	188648	182915	Undocumented 2	:: 54	2711 47th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5981812.2124	2096648.8938	37.7359443944789	-122.505367292654	(37.7359443944789, -122.505367292654)
24313	24313	184893	Undocumented 2	:: 54	1786 46th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5981952.8719	2102926.7078	37.753189803786896	-122.505346142178	(37.7531898037869, -122.505346142178)
170815	170815	183268	Undocumented 2	:: 54	1254 45th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5982139.2748	2106566.1909	37.763193757767	-122.504971215621	(37.763193757767, -122.504971215621)
149711	149711	183631	Undocumented 2	:: 54	1451 45th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5982139.8696	2105211.8354	37.7594751192783	-122.50486879402	(37.7594751192783, -122.50486879402)
134100	134100	183108	Undocumented 2	:: 54	3454 Santiago St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5982137.4358	2099478.9461	37.7437340718642	-122.504452485254	(37.7437340718642, -122.504452485254)
102427	102427	184466	Undocumented 2	:: 54	2183 45th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5982310.877	2100256.4702	37.745879137546204	-122.503910352906	(37.7458791375462, -122.503910352906)
147560	147560	183654	Undocumented 2	:: 54	4000 Kirkham St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5982417.4167	2104930.2746	37.7587183575205	-122.503888061559	(37.7587183575205, -122.503888061559)
84556	84556	115963	Undocumented 2	:: 54	847 43RD AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/07/2016 12:00:00 AM	3	3x3		5982585.0	2109998.0	37.7726427311472	-122.50368379034599	(37.7726427311472, -122.503683790346)
162629	162629	183334	Undocumented 2	:: 54	1211 43rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5982706.9565	2106844.4908	37.7639912720976	-122.503028431048	(37.7639912720976, -122.503028431048)
39530	39530	184555	Undocumented 2	:: 54	3601 Moraga St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5983107.8094	2103539.071	37.754939075681705	-122.50139749571501	(37.7549390756817, -122.501397495715)
178183	178183	184327	Undocumented 2	:: 54	1566 42nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983143.5077	2104481.5092	37.7575288427339	-122.50134375171899	(37.7575288427339, -122.501343751719)
162421	162421	184690	Undocumented 2	:: 54	3545 Lawton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5983184.2215	2104221.535	37.75681741760479	-122.501183720782	(37.7568174176048, -122.501183720782)
33271	33271	184161	Undocumented 2	:: 54	3540 Lawton St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983209.359	2104274.4825	37.7569642726582	-122.501100703383	(37.7569642726582, -122.501100703383)
135081	135081	183325	Undocumented 2	:: 54	3945 Lincoln Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5983437.8062	2106951.4607	37.764327910588	-122.50050858895	(37.764327910588, -122.50050858895)
39826	39826	183322	Undocumented 2	:: 54	3927 Lincoln Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5983510.9139	2106953.643	37.764338193887504	-122.50025589533001	(37.7643381938875, -122.50025589533)
113500	113500	109261	Permitted Site 1	:: 54	3338X Ortega St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1			3x3		5983663.54917	2102222.75157	37.7513574508855	-122.499378353213	(37.7513574508855, -122.499378353213)
158214	158214	183340	Undocumented 2	:: 54	1219 39th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5983949.2875	2106832.797	37.7640321055392	-122.498730779597	(37.7640321055392, -122.498730779597)
132956	132956	184218	Undocumented 2	:: 54	3441 Kirkham St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984096.8823	2104933.319	37.758825328706	-122.49808001485	(37.758825328706, -122.49808001485)
67072	67072	183201	Undocumented 2	:: 54	3850 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5984019.7512	2098181.555	37.7402823237858	-122.497848207912	(37.7402823237858, -122.497848207912)
166779	166779	183677	Undocumented 2	:: 54	3712 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984214.5724	2106350.8178	37.7627242820393	-122.497777660273	(37.7627242820393, -122.497777660273)
47495	47495	184900	DPW Maintained 3	:: 54	3100x Noriega St	2	Median : Cutout 11	Tree 1	DPW 2			0	Width 0ft		5984148.1689	2102921.2035	37.7533036269678	-122.49775407488501	(37.7533036269678, -122.497754074885)
160820	160820	184200	Undocumented 2	:: 54	1466 38th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984360.2753	2105208.7663	37.759597069474395	-122.497189426429	(37.7595970694744, -122.497189426429)
41261	41261	184673	Undocumented 2	:: 54	1683 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984368.1401	2103732.6021	37.755544395128105	-122.49705326703999	(37.7555443951281, -122.49705326704)
151161	151161	184714	Undocumented 2	:: 54	1626 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984397.9613	2104100.06	37.756555079860895	-122.496977258127	(37.7565550798609, -122.496977258127)
188070	188070	184620	DPW Maintained 3	:: 54	3000x Noriega St	2	Median : Cutout 11	Tree 1	DPW 2			0	Width 0ft		5984460.1938	2102931.6946	37.753350719104795	-122.496675818993	(37.7533507191048, -122.496675818993)
38023	38023	183701	Undocumented 2	:: 54	1349 37th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984598.3295	2105986.1027	37.7617453659671	-122.49642348771098	(37.7617453659671, -122.496423487711)
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)
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)
178406	178406	181590	Undocumented 2	:: 54	1651 37th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984667.3631	2103944.5517	37.7561438801895	-122.496034112265	(37.7561438801895, -122.496034112265)
55211	55211	181592	Undocumented 2	:: 54	1659 37th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984670.7327	2103886.5941	37.7559849420617	-122.49601818364201	(37.7559849420617, -122.496018183642)
25460	25460	181596	Undocumented 2	:: 54	1683 37th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984674.4393	2103735.9717	37.7555715918184	-122.495994253801	(37.7555715918184, -122.495994253801)
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)
29815	29815	181758	Undocumented 2	:: 54	1230 36th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984924.8270000005	2106814.5562	37.764039188732205	-122.495355380579	(37.7640391887322, -122.495355380579)
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)
74019	74019	182270	Undocumented 2	:: 54	1468 Kirkham St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984979.6145	2105227.4255	37.759684579371	-122.49504884998699	(37.759684579371, -122.495048849987)
187803	187803	182417	Undocumented 2	:: 54	1544 36th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984999.4264	2104687.6498	37.758203665254996	-122.494940531373	(37.758203665255, -122.494940531373)
70168	70168	184101	Undocumented 2	:: 54	1614 36th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985015.3679	2104189.9056	37.756837930957	-122.494848701043	(37.756837930957, -122.494848701043)
48483	48483	184128	Undocumented 2	:: 54	1638 36th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985018.0427	2104046.1353	37.756443334108894	-122.494828850894	(37.7564433341089, -122.494828850894)
46079	46079	181712	Undocumented 2	:: 54	3401 Lincoln Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985144.052	2107009.2181	37.764586509150895	-122.494611508714	(37.7645865091509, -122.494611508714)
170057	170057	181617	Undocumented 2	:: 54	1251 35th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985198.7047	2106674.5469	37.7636707944731	-122.494397810738	(37.7636707944731, -122.494397810738)
167154	167154	181693	Undocumented 2	:: 54	1367 35th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985223.881	2105891.4732	37.761522166301106	-122.494253012254	(37.7615221663011, -122.494253012254)
109430	109430	181696	Undocumented 2	:: 54	1375 35th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985223.881	2105845.6432	37.7613963299035	-122.49424963408701	(37.7613963299035, -122.494249634087)
72820	72820	182667	Undocumented 2	:: 54	2850 Ortega St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985151.905	2102302.8402	37.7516645607705	-122.494237424527	(37.7516645607705, -122.494237424527)
67226	67226	182349	Undocumented 2	:: 54	3125 Kirkham St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985217.5678	2104973.2387	37.759000580496	-122.494207164319	(37.759000580496, -122.494207164319)
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)
31222	31222	182419	Undocumented 2	:: 54	1548 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985308.8008	2104684.9478	37.7582143519431	-122.493870396795	(37.7582143519431, -122.493870396795)
182077	182077	182223	Undocumented 2	:: 54	2850 Lawton St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985346.1154	2104348.9791	37.7572940580172	-122.493716591749	(37.7572940580172, -122.493716591749)
166191	166191	183990	Undocumented 2	:: 54	1678 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985337.0123	2103802.0601	37.75579183696671	-122.493707772777	(37.7557918369667, -122.493707772777)
163575	163575	183992	Undocumented 2	:: 54	1686 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985337.681	2103759.2633	37.7556743678806	-122.493702306752	(37.7556743678806, -122.493702306752)
170143	170143	182289	Undocumented 2	:: 54	3030 Kirkham St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985424.4891	2105033.1948	37.7591773096727	-122.493495960874	(37.7591773096727, -122.493495960874)
151826	151826	182337	Undocumented 2	:: 54	3031 Kirkham St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985436.2432	2104978.1104	37.7590267507534	-122.49345125158301	(37.7590267507534, -122.493451251583)
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)
39979	39979	185836	Undocumented 2	:: 54	2000 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985432.8989	2101036.5759	37.748204183826395	-122.4931724505	(37.7482041838264, -122.4931724505)
187015	187015	183723	Undocumented 2	:: 54	2251 35th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985430.1991	2099886.7383	37.7450468837647	-122.493097094872	(37.7450468837647, -122.493097094872)
180171	180171	183754	Undocumented 2	:: 54	2275 35th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985433.1862	2099734.3927	37.7446287586395	-122.49307554574	(37.7446287586395, -122.49307554574)
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)
157164	157164	183870	Undocumented 2	:: 54	2238 35th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985467.7521	2099978.9139	37.745302169251104	-122.49297403363501	(37.7453021692511, -122.492974033635)
28907	28907	182325	Undocumented 2	:: 54	1500 34th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985611.7191	2104963.9168	37.758998042021105	-122.492843336234	(37.7589980420211, -122.492843336234)
127121	127121	184118	Undocumented 2	:: 54	1631 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985595.7989	2104096.2877	37.756614841261204	-122.492834488892	(37.7566148412612, -122.492834488892)
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)
73039	73039	182430	Undocumented 2	:: 54	1550 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985619.2686	2104668.8016	37.7581881787974	-122.492795490293	(37.7581881787974, -122.492795490293)
33938	33938	182209	Undocumented 2	:: 54	1590 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985630.9934	2104420.723	37.75750770910879	-122.492736670044	(37.7575077091088, -122.492736670044)
151241	151241	182321	Undocumented 2	:: 54	2945 Kirkham St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985646.7454	2104986.0725	37.759060923629704	-122.492723832324	(37.7590609236297, -122.492723832324)
62817	62817	184099	Undocumented 2	:: 54	1614 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985632.5774	2104212.6414	37.7569364670777	-122.49271586677	(37.7569364670777, -122.49271586677)
70621	70621	182331	Undocumented 2	:: 54	2926 Kirkham St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985669.6203	2105041.6476	37.7592148550316	-122.49264881426501	(37.7592148550316, -122.492648814265)
149971	149971	183987	Undocumented 2	:: 54	1678 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985646.62	2103816.1028	37.7558485024467	-122.49263809911501	(37.7558485024467, -122.492638099115)
46565	46565	185847	Undocumented 2	:: 54	2011 34th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985684.8846	2101427.5121	37.749292323144495	-122.492329887495	(37.7492923231445, -122.492329887495)
170682	170682	181751	Undocumented 2	:: 54	1215 33rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985811.8134	2106917.8782	37.764374776294396	-122.49229520775299	(37.7643747762944, -122.492295207753)
49452	49452	183775	Undocumented 2	:: 54	2283 34th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985743.8519	2099689.1584	37.744522721672794	-122.49199801053699	(37.7445227216728, -122.491998010537)
38904	38904	182360	Undocumented 2	:: 54	1507 33rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985877.3228	2104935.7779	37.7589363086434	-122.491922694782	(37.7589363086434, -122.491922694782)
49553	49553	182385	Undocumented 2	:: 54	1539 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985884.186000001	2104731.9425	37.75837703407	-122.491883952425	(37.75837703407, -122.491883952425)
132740	132740	182477	Undocumented 2	:: 54	1559 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985888.9902	2104607.7196	37.7580362330577	-122.49185819240401	(37.7580362330577, -122.491858192404)
37240	37240	182497	Undocumented 2	:: 54	1567 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985891.0491	2104555.5597	37.7578931366951	-122.491847232012	(37.7578931366951, -122.491847232012)
148450	148450	182539	Undocumented 2	:: 54	1583 33rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985893.7944	2104453.9852	37.757614401574	-122.491830260053	(37.757614401574, -122.491830260053)
44907	44907	182397	Undocumented 2	:: 54	1522 33rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985924.4899	2104853.8684	37.7587141646	-122.49175354130301	(37.7587141646, -122.491753541303)
166512	166512	183970	Undocumented 2	:: 54	1659 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985911.4249	2103935.7999	37.756192637786704	-122.49173114183998	(37.7561926377867, -122.49173114184)
136466	136466	182503	Undocumented 2	:: 54	1570 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985933.7674	2104553.51	37.757890005503704	-122.49169934538901	(37.7578900055037, -122.491699345389)
74054	74054	185122	Undocumented 2	:: 54	2850 34th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985897.3509	2095993.4067	37.734384144878	-122.49119531195299	(37.734384144878, -122.491195311953)
52163	52163	183819	Undocumented 2	:: 54	2201 33rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986040.0084	2100206.7922	37.7459613114508	-122.49101206010599	(37.7459613114508, -122.491012060106)
163278	163278	183838	Undocumented 2	:: 54	2210 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986083.109	2100170.5194	37.7458642341294	-122.49086035754101	(37.7458642341294, -122.490860357541)
178783	178783	182395	Undocumented 2	:: 54	1523 32nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986191.7973	2104845.1708	37.758705902690004	-122.490828442707	(37.75870590269, -122.490828442707)
49318	49318	182390	Undocumented 2	:: 54	1543 32nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986194.4001	2104722.3341	37.7583687789891	-122.490810402719	(37.7583687789891, -122.490810402719)
178130	178130	182483	Undocumented 2	:: 54	1555 32nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986198.1756	2104640.4864	37.75814426828779	-122.49079132320699	(37.7581442682878, -122.490791323207)
176590	176590	182501	Undocumented 2	:: 54	1571 32nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986201.2632	2104545.9513	37.757884881279104	-122.490773689302	(37.7578848812791, -122.490773689302)
149387	149387	183787	Undocumented 2	:: 54	2294 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986100.6052	2099683.6108	37.744528336251605	-122.49076403880501	(37.7445283362516, -122.490764038805)
36590	36590	182200	Undocumented 2	:: 54	1591 32nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986205.3811	2104418.9832	37.757536502339704	-122.490750106029	(37.7575365023397, -122.490750106029)
182895	182895	182662	Undocumented 2	:: 54	2500 Ortega St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986210.6491	2102339.3676	37.751826754324796	-122.490578887559	(37.7518267543248, -122.490578887559)
62756	62756	183745	Undocumented 2	:: 54	2267 32nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986363.4761	2099812.4858	37.7448975449574	-122.489864573201	(37.7448975449574, -122.489864573201)
154538	154538	183782	Undocumented 2	:: 54	2295 32nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986367.7435	2099662.7006	37.744486524158795	-122.489838803613	(37.7444865241588, -122.489838803613)
34634	34634	183835	Undocumented 2	:: 54	2210 32nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986395.4815	2100173.9333	37.7458918514691	-122.489780482903	(37.7458918514691, -122.489780482903)
179024	179024	183804	Undocumented 2	:: 54	2222 32nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986395.9083	2100109.0691	37.745713776729204	-122.489774237646	(37.7457137767292, -122.489774237646)
165658	165658	183857	Undocumented 2	:: 54	2238 32nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986401.0291	2099997.2636	37.7454070878517	-122.489748309986	(37.7454070878517, -122.489748309986)
146666	146666	185754	Undocumented 2	:: 54	2150 Rivera St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986421.0907	2100305.9425	37.7462558084738	-122.489701637323	(37.7462558084738, -122.489701637323)

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