Street_Tree_List

Data source: data.sfgov.org

287 rows where SiteOrder = 2 and qSpecies = 54

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
3275	3275	253378	Planning Code 138.1 required 4	:: 54	2 Alpine Ter	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6001556.0	2108661.0	37.7700688079313	-122.43796542225	(37.7700688079313, -122.43796542225)
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)
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)
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)
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)
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)
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)
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)
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)
55863	55863	142256	Undocumented 2	:: 54	436 FELL ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6005308.392999999	2110647.6947	37.7757364649691	-122.42512731628099	(37.7757364649691, -122.425127316281)
55957	55957	183949	Undocumented 2	:: 54	2142 22nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5989476.9277	2100753.7305	37.7476632594841	-122.47916779409701	(37.7476632594841, -122.479167794097)
56509	56509	139696	Undocumented 2	:: 54	345 Saint Joseph's Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6000314.3725	2113207.1569999997	37.7824807138402	-122.442586640867	(37.7824807138402, -122.442586640867)
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)
56662	56662	183853	Undocumented 2	:: 54	2240 27th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987950.3032	2100034.1765	37.7455987763683	-122.484393943258	(37.7455987763683, -122.484393943258)
57456	57456	200234	Undocumented 2	:: 54	2895 Hawes St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6014768.3667	2089489.9029	37.718171466543104	-122.390923576462	(37.7181714665431, -122.390923576462)
57505	57505	142224	Undocumented 2	:: 54	633 HAYES ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6004805.4597	2110871.2494	37.7763218676751	-122.426883014235	(37.7763218676751, -122.426883014235)
57686	57686	137730	Undocumented 2	:: 54	618 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6000121.5934	2111015.3224	37.7764515064845	-122.443096107731	(37.7764515064845, -122.443096107731)
58859	58859	244341	Undocumented 2	:: 54	442 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6003210.2759	2109856.6606	37.7734457335057	-122.432328715157	(37.7734457335057, -122.432328715157)
58903	58903	142118	Undocumented 2	:: 54	29 HEMWAY TER	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5998613.9988	2110907.9465	37.776070604872	-122.448303549007	(37.776070604872, -122.448303549007)
59014	59014	139029	Undocumented 2	:: 54	1535 Broderick St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6000616.8967	2114052.0744	37.784817879809204	-122.441600694473	(37.7848178798092, -122.441600694473)
59985	59985	183761	Undocumented 2	:: 54	2030 Santiago St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986517.3154	2099627.4947	37.744398590483705	-122.489319033453	(37.7443985904837, -122.489319033453)
61201	61201	183850	Undocumented 2	:: 54	2222 31st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986707.0006	2100119.7376	37.745761228597296	-122.488699324618	(37.7457612285973, -122.488699324618)
61221	61221	182424	Undocumented 2	:: 54	1539 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988364.431	2104819.4483	37.758761957997606	-122.48331268682301	(37.7587619579976, -122.483312686823)
61870	61870	183840	Undocumented 2	:: 54	2215 31st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986663.0466	2100148.329	37.745837167832896	-122.488853410496	(37.7458371678329, -122.488853410496)
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)
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)
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)
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)
64617	64617	139991	Undocumented 2	:: 54	430 FULTON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6005660.0116	2111735.9709	37.7787444634633	-122.423988384849	(37.7787444634633, -122.423988384849)
65876	65876	183811	Undocumented 2	:: 54	2206 27th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987942.6219	2100258.2142	37.7462134771309	-122.48443693293001	(37.7462134771309, -122.48443693293)
66691	66691	142129	Undocumented 2	:: 54	10 HEMWAY TER	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5998655.1761	2110837.1975	37.775878700373895	-122.448156010928	(37.7758787003739, -122.448156010928)
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)
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)
68603	68603	142716	DPW Maintained 3	:: 54	1120 COLUMBUS AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6008073.8404	2121121.2819	37.804650203273	-122.416302902461	(37.804650203273, -122.416302902461)
68711	68711	182018	Undocumented 2	:: 54	1467 23rd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5988965.6747	2105331.3888	37.7602025812324	-122.481270822304	(37.7602025812324, -122.481270822304)

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