Street_Tree_List

Data source: data.sfgov.org

2,349 rows where qCaretaker = 2 and qSpecies = 15 sorted by rowid descending

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, PermitNotes

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
189069	189069	195235	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200x Evans Ave	30	Median : Yard 3	Tree 1	DPW 2			9			6017260.82922	2097339.16357	37.7398619829554	-122.382854057268	(37.7398619829554, -122.382854057268)
187227	187227	112536	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	400 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	3x3		6011560.169980001	2118732.349	37.7982861996168	-122.404069826985	(37.7982861996168, -122.404069826985)
186361	186361	195681	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	10	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6015351.95562	2111719.9418200003	37.779242863700794	-122.390458762259	(37.7792428637008, -122.390458762259)
184668	184668	135610	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	21	Median : Yard 3	Tree 1	DPW 2			7			6014284.458430001	2117732.9706900003	37.7956939784573	-122.39457288004499	(37.7956939784573, -122.394572880045)
183960	183960	96523	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1975 Post St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			5	3x3		6002780.8098	2114056.2532	37.78495240250329	-122.43411456903799	(37.7849524025033, -122.434114569038)
182030	182030	195476	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	12	Median : Yard 3	Tree 1	DPW 2			8			6014549.96512	2117428.46755	37.7948726411219	-122.39363284927299	(37.7948726411219, -122.393632849273)
181577	181577	195680	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	9	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015377.63395	2111744.49968	37.779311718508	-122.390371645854	(37.779311718508, -122.390371645854)
181413	181413	195720	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	4	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6014817.65208	2111211.59026	37.7778173905846	-122.39227159046001	(37.7778173905846, -122.39227159046)
180517	180517	135598	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	6	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013629.78784	2117826.7467900002	37.7959150479945	-122.396844751899	(37.7959150479945, -122.396844751899)
180077	180077	135605	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	16	Median : Yard 3	Tree 1	DPW 2			7			6014374.07873	2117690.91849	37.795583494923704	-122.39425982964899	(37.7955834949237, -122.394259829649)
180074	180074	195732	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	16	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6014536.11101	2110945.78626	37.7770719155794	-122.39322694208401	(37.7770719155794, -122.393226942084)
179408	179408	195734	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	18	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6014485.12564	2110898.06022	37.776938038003294	-122.39339997704398	(37.7769380380033, -122.393399977044)
179167	179167	135588	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	8	Median : Yard 3	Tree 1	DPW 2			10	Width 7ft		6013703.14985	2117288.7562700002	37.794441936008894	-122.39655317280899	(37.7944419360089, -122.396553172809)
178958	178958	195733	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	17	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6014512.42504	2110924.16677	37.777011237428205	-122.39330736664301	(37.7770112374282, -122.393307366643)
178884	178884	135615	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	26	Median : Yard 3	Tree 1	DPW 2			7			6014281.27914	2117801.86987	37.795882982666505	-122.394588708116	(37.7958829826665, -122.394588708116)
178029	178029	143294	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1020 MARKET ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			10	Width 0ft		6009546.6679	2112867.3159	37.782069531742	-122.410622782887	(37.782069531742, -122.410622782887)
177428	177428	135583	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	3	Median : Yard 3	Tree 1	DPW 2			10	Width 7ft		6013725.73224	2117134.30218	37.794019098152205	-122.396464202864	(37.7940190981522, -122.396464202864)
177228	177228	112550	Undocumented 2	Platanus x hispanica :: Sycamore: London Plane 15	490 Broadway	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			4	5x5		6011203.88674	2118681.82927	37.798127571795796	-122.405299121068	(37.7981275717958, -122.405299121068)
176932	176932	195722	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	6	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014782.12024	2111178.98534	37.7777258917748	-122.392392227319	(37.7777258917748, -122.392392227319)
176793	176793	195736	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	20	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6014449.17675	2110862.30677	37.7768378696968	-122.393521833393	(37.7768378696968, -122.393521833393)
175988	175988	135608	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	19	Median : Yard 3	Tree 1	DPW 2			6			6014300.48384	2117708.60482	37.7956279664036	-122.394515721817	(37.7956279664036, -122.394515721817)
175056	175056	195675	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	4	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015482.36105	2111843.26089	37.7795887033991	-122.390016249049	(37.7795887033991, -122.390016249049)
174361	174361	23315	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1001 Van Ness Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/10/2012 12:00:00 AM	6	4X4		6006450.1649	2113981.54342	37.7849548357273	-122.42141444692	(37.7849548357273, -122.42141444692)
173646	173646	195240	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400x Evans Ave	16	Median : Yard 3	Tree 1	DPW 2			10			6016376.5567	2097988.3018	37.7415954882544	-122.385956766892	(37.7415954882544, -122.385956766892)
173405	173405	195719	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	3	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6014846.74684	2111239.41443	37.7778954049955	-122.39217288717501	(37.7778954049955, -122.392172887175)
172202	172202	195721	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	5	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6014799.00222	2111195.13044	37.777771160036295	-122.39233495579599	(37.7777711600363, -122.392334955796)
171564	171564	135597	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	5	Median : Yard 3	Tree 1	DPW 2			3	Width 7ft		6013633.10727	2117805.98643	37.7958582297137	-122.39683180976299	(37.7958582297137, -122.396831809763)
171079	171079	13656	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	615 Market St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/28/1993 12:00:00 AM	9	4X4		6012175.96734	2115295.69733	37.7888843595854	-122.401697286828	(37.7888843595854, -122.401697286828)
170418	170418	195682	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	11	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6015332.35887	2111698.96547	37.7791841802313	-122.39052508997	(37.7791841802313, -122.39052508997)
170260	170260	195684	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	13	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6015289.74436	2111657.65185	37.779068378153	-122.39066962450799	(37.779068378153, -122.390669624508)
169353	169353	135315	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	33x Battery St	5	Median : Yard 3	Tree 1	DPW 2			6			6012858.7007	2116094.65173	37.7911161756167	-122.399391219139	(37.7911161756167, -122.399391219139)
169337	169337	135313	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	33x Battery St	3	Median : Yard 3	Tree 1	DPW 2			10			6012855.39905	2116098.8702	37.7911275745228	-122.39940293909099	(37.7911275745228, -122.399402939091)
169311	169311	140331	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400x WEBSTER ST	5	Median : Cutout 11	Tree 1	DPW 2			4	Width 0ft		6003635.6344	2113717.5722	37.784070947370296	-122.431132969012	(37.7840709473703, -122.431132969012)
168848	168848	135596	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	4	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013635.89834	2117779.6494400003	37.7957860699142	-122.396820304724	(37.7957860699142, -122.396820304724)
162147	162147	195469	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			4			6014561.45275	2117330.54944	37.7946044192093	-122.393586243706	(37.7946044192093, -122.393586243706)
162122	162122	195236	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200x Evans Ave	31	Median : Yard 3	Tree 1	DPW 2			9			6017248.0064199995	2097338.05613	37.7398582336715	-122.382898316528	(37.7398582336715, -122.382898316528)
161476	161476	195473	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			8			6014525.02119	2117376.33329	37.794728106566	-122.393715508675	(37.794728106566, -122.393715508675)
161211	161211	248618	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1801x Market St	2	Median : Cutout 11	Tree 1	DPW 2			6	Width 0ft		6005754.9275	2109142.5728	37.771628978383795	-122.42347561219299	(37.7716289783838, -122.423475612193)
160641	160641	135614	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	25	Median : Yard 3	Tree 1	DPW 2			7			6014250.33461	2117779.72028	37.7958204447077	-122.394694230949	(37.7958204447077, -122.394694230949)
157165	157165	140495	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	900x WEBSTER ST	1	Median : Cutout 11	Tree 1	DPW 2			18	Width 0ft		6003907.9001	2111864.9963	37.778999660215796	-122.430058828065	(37.7789996602158, -122.430058828065)
155002	155002	195465	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			5			6014600.5066599995	2117288.76118	37.794491848365205	-122.39344818519899	(37.7944918483652, -122.393448185199)
154568	154568	195723	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	7	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014750.92686	2111151.90526	37.777649803738896	-122.392498242106	(37.7776498037389, -122.392498242106)
154428	154428	195674	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	3	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015508.64587	2111869.51632	37.779662252656294	-122.389927152313	(37.7796622526563, -122.389927152313)
154315	154315	195475	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			6			6014508.20753	2117399.45004	37.7947906454237	-122.39377530549999	(37.7947906454237, -122.3937753055)
154299	154299	135611	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	22	Median : Yard 3	Tree 1	DPW 2			7			6014316.69875	2117756.35966	37.795759991389204	-122.39446296041001	(37.7957599913892, -122.39446296041)
153591	153591	135582	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	2	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013728.8853	2117108.6329200002	37.7939487918665	-122.396451492763	(37.7939487918665, -122.396451492763)
153173	153173	195468	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			6			6014618.49962	2117336.48086	37.7946238751469	-122.39338926790701	(37.7946238751469, -122.393389267907)
151440	151440	195724	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	8	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6014732.91022	2111131.92484	37.7775939414569	-122.39255917029	(37.7775939414569, -122.39255917029)
151097	151097	195727	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	11	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6014667.91656	2111070.80187	37.777422501882896	-122.392779729899	(37.7774225018829, -122.392779729899)
150630	150630	134466	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	540 Van Ness Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			10	Width 4ft		6006768.70743	2112410.0394200003	37.7806578237339	-122.420200818125	(37.7806578237339, -122.420200818125)
150266	150266	135599	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	7	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013626.9255	2117849.56722	37.7959775481806	-122.39685625692499	(37.7959775481806, -122.396856256925)
150043	150043	135601	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	160x Drumm St	9	Median : Yard 3	Tree 1	DPW 2			2	Width 7ft		6013619.0965	2117904.14877	37.7961269804374	-122.396887175602	(37.7961269804374, -122.396887175602)
150007	150007	195771	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	7	Median : Yard 3	Tree 1	DPW 2			9	Width 8ft		6013983.076169999	2110410.9582599998	37.7755726593879	-122.39510260590201	(37.7755726593879, -122.395102605902)
149614	149614	195238	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1200x Evans Ave	33	Median : Yard 3	Tree 1	DPW 2			8			6017232.2408	2097349.7546	37.7398894842228	-122.382953641924	(37.7398894842228, -122.382953641924)
148507	148507	195232	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1300x Evans Ave	3	Median : Yard 3	Tree 1	DPW 2			16	Width 8ft		6017081.8167	2097473.87775	37.740221988756105	-122.383482389326	(37.7402219887561, -122.383482389326)
148173	148173	195726	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	10	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014684.461	2111087.65497	37.777469695597	-122.39272367606002	(37.777469695597, -122.39272367606)
147917	147917	135592	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	150x Drumm St	7	Median : Yard 3	Tree 1	DPW 2			6	Width 7ft		6013656.57361	2117641.2066	37.7954070893311	-122.39673905365801	(37.7954070893311, -122.396739053658)
147541	147541	123635	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	275 Arguello Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			11	Width 4ft		5995505.19535	2114515.2214	37.7857969976505	-122.459318944574	(37.7857969976505, -122.459318944574)
147288	147288	135613	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	24	Median : Yard 3	Tree 1	DPW 2			7			6014299.10816	2117778.7327400004	37.7958204447215	-122.39452539493799	(37.7958204447215, -122.394525394938)
147121	147121	135609	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	450x The Embarcadero	20	Median : Yard 3	Tree 1	DPW 2			7			6014337.09374	2117734.43585	37.7957009275062	-122.394390853653	(37.7957009275062, -122.394390853653)
146587	146587	135587	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	22x Drumm St	7	Median : Yard 3	Tree 1	DPW 2			9	Width 7ft		6013707.40444	2117263.065	37.794371630605795	-122.39653664955699	(37.7943716306058, -122.396536649557)
146547	146547	195767	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700x King St	3	Median : Yard 3	Tree 1	DPW 2			9	Width 8ft		6014073.23663	2110496.61551	37.7758128682948	-122.39479671682	(37.7758128682948, -122.39479671682)
146296	146296	14390	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2389 Market St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6002409.820088901	2105964.8893714002	37.762714465430896	-122.434819240654	(37.7627144654309, -122.434819240654)
146295	146295	13842	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	980X Market St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	4x4		6009765.9093461	2113096.5020018998	37.7827111116947	-122.40988048733699	(37.7827111116947, -122.409880487337)
146235	146235	14110	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1551X Market St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6006862.6374	2110209.5058003003	37.7746209809445	-122.419719686331	(37.7746209809445, -122.419719686331)
146178	146178	28216	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/23/2014 11:00:00 PM	12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
146153	146153	21546	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1375 Sutter St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6006020.8957726	2114853.8467566003	37.7873257529217	-122.422961602266	(37.7873257529217, -122.422961602266)
146108	146108	4520	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	37X Cleary Ct	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6005067.314179	2113761.703735	37.784273146185	-122.42618301414	(37.784273146185, -122.42618301414)
146092	146092	13645	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	590 Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	4x4		6012116.841628	2115339.7303771	37.789001964373895	-122.401904951476	(37.7890019643739, -122.401904951476)
146072	146072	27263	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1700 Van Ness Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			5	3X3		6006197.87083	2116294.50102	37.7912914162893	-122.422451709557	(37.7912914162893, -122.422451709557)
145965	145965	13820	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	955 Market St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			40	4X4		6009976.4804108	2113186.4182692003	37.782969799261	-122.40915834456499	(37.782969799261, -122.409158344565)
145938	145938	19047	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	121 Sagamore St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			35	3x3		5995696.4497884	2087392.1121528998	37.711334724785296	-122.456694997796	(37.7113347247853, -122.456694997796)
145703	145703	14074	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1411 Market St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x4		6007538.3610865995	2110874.6036794996	37.776485222705396	-122.41742936300899	(37.7764852227054, -122.417429363009)
145641	145641	23209	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	595X Van Ness Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			10	3X3		6006669.9178	2112533.82047	37.7809921295165	-122.42055136861201	(37.7809921295165, -122.420551368612)
145640	145640	28215	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	300X King St	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12			6014268.596778099	2110706.0699128	37.776398843196894	-122.394135578218	(37.7763988431969, -122.394135578218)
145618	145618	14276	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2109 Market St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6004121.525318701	2107579.7231854	37.7672454443494	-122.42901420077801	(37.7672454443494, -122.429014200778)
145544	145544	12358	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1275X Ellis St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6004793.254930001	2113295.54963	37.7829777087487	-122.427097949165	(37.7829777087487, -122.427097949165)
145473	145473	13498	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	215 Market St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6013729.1406446	2116782.463481	37.793053221420706	-122.396427736192	(37.7930532214207, -122.396427736192)
145427	145427	19118	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	4 Sanchez St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6003441.17868	2108283.19965	37.7691384851489	-122.431417644172	(37.7691384851489, -122.431417644172)
145405	145405	709	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	6710X California St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			65	5		5986789.82302	2113953.9673099997	37.783751021306	-122.489429993159	(37.783751021306, -122.489429993159)
145382	145382	5859	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	940X Eddy St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6005929.97927	2113157.1145599997	37.7826618143501	-122.423155503238	(37.7826618143501, -122.423155503238)
145281	145281	6608	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1400X Evans Ave	3	Median : Cutout 11	Tree 1	DPW 2		09/14/2006 12:00:00 AM	3	15		6016747.6410828	2097755.6169144	37.740977112201705	-122.384657465748	(37.7409771122017, -122.384657465748)
145251	145251	3057	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2725 California St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			95	3X3		6001337.5504485	2115252.7303216998	37.7881556043161	-122.43919355883301	(37.7881556043161, -122.439193558833)
145206	145206	102576	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2X Drumm St	2	Median : Cutout 11	Tree 1	DPW 2					Permit Number 769964	6013786.1	2116863.1	37.7932777999137	-122.396236306259	(37.7932777999137, -122.396236306259)
145181	145181	8415	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1625X Geary Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6003997.4163	2113895.15466	37.7845790386871	-122.42989400585199	(37.7845790386871, -122.429894005852)
145155	145155	21548	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1388 Sutter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6005949.897274501	2114894.45723	37.7874332527308	-122.42321013030899	(37.7874332527308, -122.423210130309)
144963	144963	14086	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1446 Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x4		6007247.0030555995	2110690.1488305	37.775962356378	-122.418424173854	(37.775962356378, -122.418424173854)
144918	144918	8425	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1655X Geary Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6003848.78784	2113876.66113	37.7845198420875	-122.430406890027	(37.7845198420875, -122.430406890027)
144890	144890	14169	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1772 Market St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4x4		6005793.4463267	2109308.0506928	37.7720855149155	-122.423354138678	(37.7720855149155, -122.423354138678)
144882	144882	14132	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1642X Market St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x4		6006458.8907635	2109942.5653128	37.773865274364	-122.421097370447	(37.773865274364, -122.421097370447)
144854	144854	13891	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1040X Market St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4x4		6009374.5541469	2112722.6337709	37.7816626179849	-122.41120799711099	(37.7816626179849, -122.411207997111)
144686	144686	12392	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1401X Geary Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3X3		6004991.530730001	2114023.54424	37.78498781146379	-122.426463848599	(37.7849878114638, -122.426463848599)
144678	144678	27398	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	2300X Hyde St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			70	3		6007121.016846401	2120187.7710471	37.802033394640105	-122.41953397743299	(37.8020333946401, -122.419533977433)
144667	144667	8285	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	610X Newhall St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015822.450130301	2097648.8409317	37.7406327174215	-122.387849016164	(37.7406327174215, -122.387849016164)
144488	144488	9968	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	700X Grove St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4x4		6004451.137509	2111214.2198121003	37.777243539690005	-122.428133160819	(37.77724353969, -122.428133160819)
144310	144310	24619	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	926 Divisadero St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/14/2013 12:00:00 AM	3	3X3		6001579.15015	2111647.55622	37.778270460106	-122.438099315048	(37.778270460106, -122.438099315048)
144291	144291	2906	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	1700 California St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			25	4X4		6006020.781359999	2115977.5515	37.790411160442	-122.42304189793998	(37.790411160442, -122.42304189794)
144233	144233	13668	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	659 Market St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			35	4X4		6011826.7061705	2114950.5402843	37.787917143841206	-122.402881404209	(37.7879171438412, -122.402881404209)
144231	144231	24165	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	110X Whitney Young Cir	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6016346.0952597	2096044.1423308998	37.736255534298	-122.38592660691401	(37.736255534298, -122.385926606914)
144203	144203	13547	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	444 Market St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		10/31/2014 01:38:00 PM	3	4x4		6013042.633150199	2116223.6547442	37.7914806373756	-122.39876387205099	(37.7914806373756, -122.398763872051)

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