Street_Tree_List

Data source: data.sfgov.org

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

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
143047	143047	115869	Undocumented 2	:: 54	84X Cordova St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					on Athens St frontage	6001679.7	2087642.4	37.712363687575795	-122.43603329568501	(37.7123636875758, -122.436033295685)
174834	174834	217555	Undocumented 2	:: 54	240 Broad St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5994537.6064	2088112.0778	37.713244974869	-122.46075236939899	(37.713244974869, -122.460752369399)
69253	69253	217580	Undocumented 2	:: 54	646 Randolph St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5992252.7325	2088559.8349	37.714342679649	-122.468682167409	(37.714342679649, -122.468682167409)
98945	98945	116341	Undocumented 2	:: 54	201X Bright St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3						5993755.0695	2088847.02637	37.715217913096104	-122.463510368547	(37.7152179130961, -122.463510368547)
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)
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)
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)
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)
168399	168399	200213	Undocumented 2	:: 54	1101 Ingerson Ave	2	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013590.5861	2090251.1677	37.7201963256026	-122.395047981349	(37.7201963256026, -122.395047981349)
172283	172283	200182	Undocumented 2	:: 54	1175 Ingerson Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6013359.1884	2090422.8715	37.720654919465396	-122.395859877099	(37.7206549194654, -122.395859877099)
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)
145496	145496	108795	Undocumented 2	:: 54	501-599 University St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6008503.45306	2091469.8325200002	37.7232583218261	-122.412718672961	(37.7232583218261, -122.412718672961)
68850	68850	200507	Undocumented 2	:: 54	1510 Carroll Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6014614.4494	2091644.4715	37.724078943993	-122.39160616116199	(37.724078943993, -122.391606161162)
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)
100878	100878	108803	Undocumented 2	:: 54	401-499 University St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6008323.152369999	2092121.01007	37.7250361958168	-122.413387969207	(37.7250361958168, -122.413387969207)
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)
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)
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)
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)
99672	99672	121127	Undocumented 2	:: 54	201 Bemis St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/09/2016 12:00:00 AM	3	3x3		6003216.0	2096386.0	37.7364588227531	-122.431347141396	(37.7364588227531, -122.431347141396)
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)
155025	155025	245380	Undocumented 2	:: 54	3620 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6005334.5439	2097112.3285	37.7385729952273	-122.424074069598	(37.7385729952273, -122.424074069598)
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)
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)
88816	88816	115002	Undocumented 2	:: 54	46 Wawona St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5993155.2	2098864.2	37.742688023212295	-122.46631133896999	(37.7426880232123, -122.46631133897)
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)
169536	169536	182098	Undocumented 2	:: 54	2388 22nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5989538.5514	2099099.4061	37.7431244964895	-122.478833728629	(37.7431244964895, -122.478833728629)
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)
177066	177066	245469	Undocumented 2	:: 54	3290 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6006288.2664	2099127.398	37.744159724830105	-122.42091957583901	(37.7441597248301, -122.420919575839)
171332	171332	183776	Undocumented 2	:: 54	2042 Santiago St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986449.4639	2099625.7878	37.744389942778604	-122.489553521138	(37.7443899427786, -122.489553521138)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
134920	134920	183732	Undocumented 2	:: 54	2271 27th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987913.177	2099840.0105	37.7450634861193	-122.48450807922501	(37.7450634861193, -122.484508079225)
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)
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)
184961	184961	183873	Undocumented 2	:: 54	2254 27th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987953.2904	2099959.924	37.7453950726433	-122.484378169146	(37.7453950726433, -122.484378169146)
165969	165969	183868	Undocumented 2	:: 54	2249 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987599.9509	2099967.6053	37.7453955824067	-122.485600508093	(37.7453955824067, -122.485600508093)
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)
148625	148625	183871	Undocumented 2	:: 54	2250 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987641.7713	2099976.5668	37.7454226248865	-122.485456559249	(37.7454226248865, -122.485456559249)
186268	186268	183859	Undocumented 2	:: 54	2247 27th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987908.9096	2099989.7957	37.745474508042996	-122.484533819529	(37.745474508043, -122.484533819529)
183828	183828	183865	Undocumented 2	:: 54	2254 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988574.1949	2099980.8342	37.745488621810395	-122.48223273912	(37.7454886218104, -122.48223273912)
153855	153855	183852	Undocumented 2	:: 54	2235 31st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5986665.607000001	2100023.7214	37.7454951781993	-122.488835399051	(37.7454951781993, -122.488835399051)
178713	178713	183855	Undocumented 2	:: 54	2241 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987598.6707	2100013.2663	37.7455208807753	-122.48560828516199	(37.7455208807753, -122.485608285162)
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)
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)
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)
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)
69809	69809	184382	Undocumented 2	:: 54	2239 25th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988528.1071	2100061.9145	37.745708566036	-122.48239804127199	(37.745708566036, -122.482398041272)
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)
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)
95693	95693	117514	Undocumented 2	:: 54	1445 DIAMOND ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6002056.0	2099801.0	37.7457698069611	-122.435601983861	(37.7457698069611, -122.435601983861)
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)
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)
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)
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)
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)
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)
136599	136599	183829	Undocumented 2	:: 54	2214 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987634.5167	2100198.0441	37.746030319963396	-122.485497894293	(37.7460303199634, -122.485497894293)
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)
69579	69579	184381	Undocumented 2	:: 54	2215 26th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988213.6008	2100208.2858	37.746092162627605	-122.48349627318501	(37.7460921626276, -122.483496273185)
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)
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)
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)
173141	173141	183809	Undocumented 2	:: 54	1821 Rivera St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987542.5546	2100287.4458	37.746270434871604	-122.485822443688	(37.7462704348716, -122.485822443688)
136245	136245	183801	Undocumented 2	:: 54	1721 Rivera St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987792.41	2100296.1939	37.7463090111499	-122.48495912648701	(37.7463090111499, -122.484959126487)
134837	134837	183962	Undocumented 2	:: 54	2158 22nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5989481.017000001	2100669.2180000003	37.7474314478739	-122.479147472521	(37.7474314478739, -122.479147472521)
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)
153685	153685	183945	Undocumented 2	:: 54	2138 21st Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989786.353999999	2100805.0363	37.747822097258	-122.478101577584	(37.747822097258, -122.478101577584)
146905	146905	183933	Undocumented 2	:: 54	2101 24th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5988807.8595	2100920.7983	37.7480831036806	-122.481493600776	(37.7480831036806, -122.481493600776)
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)
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)
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)
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)
99142	99142	116319	Undocumented 2	:: 54	1451 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3						6010547.7	2101110.8	37.749844886729996	-122.406331036849	(37.74984488673, -122.406331036849)
183852	183852	185806	Undocumented 2	:: 54	1655 21st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5989757.0236	2101653.2343	37.7501493233055	-122.478265008437	(37.7501493233055, -122.478265008437)
124407	124407	116322	Undocumented 2	:: 54	1400X Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3						6010648.284969999	2101378.4314900003	37.7505853701643	-122.40600205927099	(37.7505853701643, -122.406002059271)
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)
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)
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)
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)
70103	70103	185778	Undocumented 2	:: 54	2401 Ortega St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986535.257	2102294.0415	37.751721256531404	-122.48945303146799	(37.7517212565314, -122.489453031468)
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)
134104	134104	182649	Undocumented 2	:: 54	2102 Ortega St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5987471.7058	2102382.0329	37.7520174808531	-122.48622116783001	(37.7520174808531, -122.48622116783)
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)
88179	88179	105438	Undocumented 2	:: 54	1116 Castro St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6002483.0	2102334.0	37.75274907025911	-122.43430654109899	(37.7527490702591, -122.434306541099)
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)

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