Street_Tree_List

Data source: data.sfgov.org

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

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
3639	3639	253517	Permitted Site 1	:: 54	559 24th Ave	2	Sidewalk: Property side : Cutout 5	Landscaping 2	Private 1		09/15/2017 12:00:00 AM	3	2x4.5		5988391.0	2112180.0	37.7789735494402	-122.483760479148	(37.7789735494402, -122.483760479148)
5228	5228	253828	Permitted Site 1	:: 54	825 Polk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	DPW 4			3x3		6007000.12586	2113749.24795	37.7843480014325	-122.419495267967	(37.7843480014325, -122.419495267967)
5236	5236	253833	Permitted Site 1	:: 54	607 Eddy St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	DPW 4			3x3
10104	10104	173847	Permitted Site 1	:: 54	450 Toland St	2	Sidewalk: Curb side : Cutout 1	Landscaping 2	Private 1		01/27/2017 12:00:00 AM	3	11.85x4		6012768.71675	2099101.44192	37.74445161113729	-122.39850962968201	(37.7444516111373, -122.398509629682)
10128	10128	173868	Permitted Site 1	:: 54	808 Capitol Ave	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1		01/31/2017 12:00:00 AM	3			5995075.959430001	2089664.9067799998	37.717539636984206	-122.45900401383601	(37.7175396369842, -122.459004013836)
20483	20483	109769	Permitted Site 1	:: 54	2502X Bush St	2	Sidewalk: Property side : Cutout 5	Landscaping 2	Private 1				1.5x12.75		6001313.62368	2114572.17699	37.786285618589204	-122.43922754338101	(37.7862856185892, -122.439227543381)
20493	20493	31189	Permitted Site 1	:: 54	744 Shields St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/21/1995 12:00:00 AM			Permit Number 34885	5992088.16257343	2089881.74957895	37.7179628280945	-122.469347142572	(37.7179628280945, -122.469347142572)
30528	30528	36517	Permitted Site 1	:: 54	430 Crescent Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/18/1998 12:00:00 AM			Permit Number 39394	6007460.82693634	2095697.00770714	37.7348066562255	-122.416622148824	(37.7348066562255, -122.416622148824)
42994	42994	109343	Permitted Site 1	:: 54	3211 Baker St	2	Sidewalk: Property side : Yard 9	Landscaping 2	Private 1		02/11/2015 12:00:00 AM	3	4x13		5999315.1	2119860.5	37.8006920253414	-122.446522498385	(37.8006920253414, -122.446522498385)
77581	77581	33407	Permitted Site 1	:: 54	100 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/19/1996 12:00:00 AM			Permit Number 37523	5996457.34152631	2099451.4193202	37.7444903608651	-122.454935970247	(37.7444903608651, -122.454935970247)
78529	78529	43025	Permitted Site 1	:: 54	430 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/05/2000 12:00:00 AM			Permit Number 42886	6004125.6708626	2110297.9605007	37.774709297051004	-122.429193705112	(37.774709297051, -122.429193705112)
81163	81163	104152	Permitted Site 1	:: 54	525X Church St	2	Sidewalk: Property side : Cutout 5	Landscaping 2	SFUSD 4	DPW 4			2x68		6004243.11162	2105844.84418	37.7624887647889	-122.428469979895	(37.7624887647889, -122.428469979895)
81650	81650	45785	Permitted Site 1	:: 54	355 Granada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/16/2001 12:00:00 AM			Permit Number 44424	5995605.92038879	2092277.61806963	37.7247439722696	-122.457361104262	(37.7247439722696, -122.457361104262)
85364	85364	115892	Permitted Site 1	:: 54	1900X Kirkham St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/02/2016 12:00:00 AM	3			5988841.66469	2105121.6083400003	37.75961937033	-122.48168434385401	(37.75961937033, -122.481684343854)
86204	86204	33463	Permitted Site 1	:: 54	20 Coleridge St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/20/1996 12:00:00 AM			Permit Number 37562	6006978.38557579	2099649.65289984	37.7456325955283	-122.418570316182	(37.7456325955283, -122.418570316182)
89497	89497	30705	Permitted Site 1	:: 54	371 Oak St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/31/1995 12:00:00 AM			Permit Number 34615	6005225.74804899	2110232.43831944	37.7745916029272	-122.425383648395	(37.7745916029272, -122.425383648395)
91070	91070	105360	Permitted Site 1	:: 54	850 Guerrero St	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				12x2.75		6005583.5	2103975.8	37.7574325683666	-122.423701164602	(37.7574325683666, -122.423701164602)
91154	91154	109365	Permitted Site 1	:: 54	1205 Filbert St	2	Sidewalk: Curb side : Cutout 1	Landscaping 2	Private 1	FUF 1	02/11/2015 12:00:00 AM	3	4.5x16		6007075.4	2119431.2	37.7999534721279	-122.419638123127	(37.7999534721279, -122.419638123127)
92236	92236	43021	Permitted Site 1	:: 54	537 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/2000 12:00:00 AM			Permit Number 42882	6003129.08838274	2110095.37711913	37.7740965863099	-122.432626609315	(37.7740965863099, -122.432626609315)
94877	94877	42090	Permitted Site 1	:: 54	25 Stoneman St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/21/2000 12:00:00 AM			Permit Number 42397	6008240.69863747	2099401.70748619	37.7450227780609	-122.414187874949	(37.7450227780609, -122.414187874949)
97786	97786	109767	Permitted Site 1	:: 54	1801 Scott St	2	Sidewalk: Property side : Cutout 5	Landscaping 2	Private 1				11.75x1.5+3.6x3.6		6001511.7	2114646.3	37.786500410729104	-122.43854756475099	(37.7865004107291, -122.438547564751)
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)
113603	113603	104154	Permitted Site 1	:: 54	525X Church St	2	Sidewalk: Curb side : Cutout 1	Landscaping 2	SFUSD 4	DPW 4			5x17		6004243.11162	2105844.84418	37.7624887647889	-122.428469979895	(37.7624887647889, -122.428469979895)
114951	114951	33208	Permitted Site 1	:: 54	80 Ulloa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/06/1996 12:00:00 AM			Permit Number 37408	5996508.84910838	2099508.74034148	37.74465070488021	-122.454762009134	(37.7446507048802, -122.454762009134)
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)
118010	118010	109755	Permitted Site 1	:: 54	601 Steiner St	2	Sidewalk: Property side : Cutout 5	Landscaping 2	Private 1				1x12		6003025.4	2110381.6	37.774876602731204	-122.433005738531	(37.7748766027312, -122.433005738531)
118536	118536	36929	Permitted Site 1	:: 54	901 Elizabeth St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/27/1998 12:00:00 AM			Permit Number 39571	6000612.32634681	2101962.60570598	37.751622953989205	-122.440749012812	(37.7516229539892, -122.440749012812)
120864	120864	37457	Permitted Site 1	:: 54	442 Holladay Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/1998 12:00:00 AM			Permit Number 39929	6010236.40979486	2098631.79989851	37.743020676259704	-122.40723276795299	(37.7430206762597, -122.407232767953)
122806	122806	105040	Permitted Site 1	:: 54	2660 Harrison St	2	Sidewalk: Property side : Cutout 5	Landscaping 2	Private 1				2x7		6008868.4	2102978.1	37.7548779915591	-122.412270115586	(37.7548779915591, -122.412270115586)
123158	123158	36526	Permitted Site 1	:: 54	619 Eugenia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/18/1998 12:00:00 AM			Permit Number 39400	6007328.0	2097732.0	37.74038682503829	-122.41722553506399	(37.7403868250383, -122.417225535064)
125946	125946	109370	Permitted Site 1	:: 54	2061 Hyde St	2	Sidewalk: Curb side : Cutout 1	Landscaping 2	Private 1	FUF 1	02/11/2015 12:00:00 AM	3	13x6		6007159.6	2119443.7	37.799992536546505	-122.41934764587201	(37.7999925365465, -122.419347645872)
126302	126302	109534	Permitted Site 1	:: 54	1234 Filbert St	2	Sidewalk: Property side : Cutout 5	Landscaping 2	Private 1	FUF 1	02/23/2015 12:00:00 AM	3	1.5x2.6		6007007.9	2119506.8	37.800157248198296	-122.419877066677	(37.8001572481983, -122.419877066677)
127642	127642	36507	Permitted Site 1	:: 54	584 Anderson St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/29/2003 12:00:00 AM			Permit Number 39385	6007790.43718065	2096197.35426509	37.736199030760105	-122.41551798135401	(37.7361990307601, -122.415517981354)
129313	129313	117320	Permitted Site 1	:: 54	1935 09th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/07/2016 12:00:00 AM	3		Permit Number 778503	5993426.4	2102307.1	37.7521569948021	-122.465623688401	(37.7521569948021, -122.465623688401)
140860	140860	109571	Permitted Site 1	:: 54	400 Brazil Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1			3x3		6003029.6	2091527.8	37.7231087370031	-122.43164485974701	(37.7231087370031, -122.431644859747)
142578	142578	105065	Permitted Site 1	:: 54	3177 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6006744.0	2099801.7	37.7460368842113	-122.419391572433	(37.7460368842113, -122.419391572433)
145190	145190	33509	Permitted Site 1	:: 54	24 Coleridge St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/25/1996 12:00:00 AM			Permit Number 37605	6006962.93911675	2099621.40648906	37.745554167617	-122.418621725138	(37.745554167617, -122.418621725138)
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)
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)
24732	24732	141579	Undocumented 2	:: 54	500 BAKER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6000650.2876	2110740.0178	37.7757257205697	-122.44124745176501	(37.7757257205697, -122.441247451765)
25062	25062	247418	Undocumented 2	:: 54	1001 Fell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6002608.194	2110213.5869	37.7743916070028	-122.43443692499599	(37.7743916070028, -122.434436924996)
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)
26700	26700	183825	Undocumented 2	:: 54	2233 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987596.9637	2100067.0354	37.745668416958	-122.48561813299	(37.745668416958, -122.48561813299)
27363	27363	141421	Undocumented 2	:: 54	550 IVY ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6004561.2684	2111044.0972	37.7767826552211	-122.42774005835501	(37.7767826552211, -122.427740058355)
28027	28027	140087	Undocumented 2	:: 54	1210 Scott St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6001853.1286	2112643.6389	37.781021029267706	-122.43722286326	(37.7810210292677, -122.43722286326)
28319	28319	139084	Undocumented 2	:: 54	2512 Post St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6000122.7854	2113741.6890000002	37.7839374779531	-122.443287851631	(37.7839374779531, -122.443287851631)
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)
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)
31070	31070	138278	Undocumented 2	:: 54	2181 Post St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6001737.3169	2113910.2795	37.784492318138106	-122.437714255164	(37.7844923181381, -122.437714255164)
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)
32319	32319	138821	Undocumented 2	:: 54	745 BUCHANAN ST	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6004449.5065	2111116.3546	37.776974733592205	-122.428131826933	(37.7769747335922, -122.428131826933)
32403	32403	182450	Undocumented 2	:: 54	1566 26th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988103.6039	2104651.3921	37.75828533821571	-122.484202411136	(37.7582853382157, -122.484202411136)
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)
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)
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)
34038	34038	140392	Undocumented 2	:: 54	1460 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6002728.4059	2113323.2276	37.782936725289204	-122.434243446651	(37.7829367252892, -122.434243446651)
34444	34444	139926	Undocumented 2	:: 54	1001 TURK ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6005215.378	2112666.1069	37.78127327564229	-122.425592763682	(37.7812732756423, -122.425592763682)
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)
34796	34796	138319	Undocumented 2	:: 54	1915 PIERCE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6001944.4165	2115111.5373	37.7878024384193	-122.437083797069	(37.7878024384193, -122.437083797069)
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)
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)
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)
38433	38433	181714	Undocumented 2	:: 54	1215 29th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987051.5149	2106949.2334	37.764533265698	-122.488009786224	(37.764533265698, -122.488009786224)
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)
39107	39107	139604	Undocumented 2	:: 54	1173 SCOTT ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6001838.238	2112425.6952	37.7804217645564	-122.437258767268	(37.7804217645564, -122.437258767268)
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)
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)
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)
40775	40775	138003	Undocumented 2	:: 54	1670 Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6004492.797	2114606.7181	37.7865608551259	-122.428230885205	(37.7865608551259, -122.428230885205)
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)
41266	41266	140561	Undocumented 2	:: 54	50 FRIENDSHIP CT	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6003695.7169	2111697.8997	37.7785288350927	-122.43078092716401	(37.7785288350927, -122.430780927164)
41764	41764	183600	Undocumented 2	:: 54	2639 22nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989549.7171	2097348.9516	37.738318851123	-122.47866713334	(37.738318851123, -122.47866713334)
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)
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)
42563	42563	139441	Undocumented 2	:: 54	501 GROVE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6005361.8674	2111299.9206	37.7775303390293	-122.424988750303	(37.7775303390293, -122.424988750303)
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)
44995	44995	183721	Undocumented 2	:: 54	2263 27th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987911.8967	2099894.633	37.7452133904635	-122.484516511954	(37.7452133904635, -122.484516511954)
46023	46023	183740	Undocumented 2	:: 54	2280 31st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986718.9493	2099755.7296	37.7447624573869	-122.48863125822099	(37.7447624573869, -122.488631258221)
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)
46209	46209	183847	Undocumented 2	:: 54	2227 27th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987904.6422	2100116.537	37.7458222575023	-122.484557870143	(37.7458222575023, -122.484557870143)
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)
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)
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)
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)
49493	49493	141641	Undocumented 2	:: 54	529 MASONIC AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5999097.1169	2110918.0537	37.776125964947205	-122.44663304885401	(37.7761259649472, -122.446633048854)
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)
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)
49578	49578	139026	Undocumented 2	:: 54	2501 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6000502.7639999995	2114090.3506	37.784916473139894	-122.44199830353001	(37.7849164731399, -122.44199830353)
50662	50662	244093	Undocumented 2	:: 54	1850 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5997702.1482	2108887.2246	37.7704700507783	-122.451312096124	(37.7704700507783, -122.451312096124)
51535	51535	183816	Undocumented 2	:: 54	2135 Rivera St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5986457.7853	2100251.173	37.746107568513104	-122.48957072678002	(37.7461075685131, -122.48957072678)
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)
53710	53710	183768	Undocumented 2	:: 54	2295 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987606.9921	2099698.5467	37.744657229257	-122.48555641926501	(37.744657229257, -122.485556419265)
53720	53720	139988	Undocumented 2	:: 54	420 FULTON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6005784.2761	2111750.2147	37.7787905883012	-122.423559517841	(37.7787905883012, -122.423559517841)
53862	53862	182038	Undocumented 2	:: 54	1319 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987384.8091	2106266.2339	37.76267737440389	-122.48680686823499	(37.7626773744039, -122.486806868235)
54235	54235	143063	Undocumented 2	:: 54	454 GREENWICH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6010670.2258	2120340.5284	37.802652102828105	-122.407262742811	(37.8026521028281, -122.407262742811)
54387	54387	246177	Undocumented 2	:: 54	1588 Waller St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5998014.6979	2108233.0836	37.7686918380665	-122.450183832466	(37.7686918380665, -122.450183832466)
54716	54716	248525	Undocumented 2	:: 54	216 Frederick St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5998893.6593	2107664.8248	37.7671818031991	-122.44710268466999	(37.7671818031991, -122.44710268467)
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)
55350	55350	183772	Undocumented 2	:: 54	2287 31st Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986678.1958	2099700.8937	37.7446095144634	-122.488768144161	(37.7446095144634, -122.488768144161)

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