Street_Tree_List

Data source: data.sfgov.org

272 rows where qLegalStatus = 3 and qSpecies = 36 sorted by qAddress

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: qSiteInfo, qCaretaker, PlantDate, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
16854	16854	11488	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/05/1993 12:00:00 AM	6	4X4		6018872.157000001	2097296.32677	37.7398332567899	-122.377279727371	(37.7398332567899, -122.377279727371)
81124	81124	11506	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
91987	91987	11505	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
94164	94164	11508	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
98320	98320	11502	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
104769	104769	11500	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
107854	107854	11501	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
123191	123191	11510	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
126552	126552	11503	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
129014	129014	11507	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
138869	138869	11509	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 Jennings St	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6018974.640384	2097432.5118216	37.7402128389975	-122.376934824049	(37.7402128389975, -122.376934824049)
3087	3087	19650	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	49	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
4862	4862	19656	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	55	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60ST
5896	5896	19680	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	79	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
5976	5976	19649	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	48	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
6914	6914	19672	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	71	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7103	7103	19675	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	74	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7153	7153	19677	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	76	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
7446	7446	19683	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	82	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
9546	9546	19678	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	77	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
9875	9875	19651	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	50	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
10475	10475	19661	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	60	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
12748	12748	19671	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	70	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
14057	14057	19674	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	73	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
14729	14729	19657	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	56	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60ST
15686	15686	19660	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	59	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60ST
16120	16120	19653	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100 STAIRWAY5	52	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60ST
21443	21443	4396	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1005 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6004431.4266800005	2103008.65854	37.754711924921295	-122.427616590837	(37.7547119249213, -122.427616590837)
13610	13610	11963	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1009X Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6015687.60896	2096283.0567700001	37.736875081728705	-122.38821995489599	(37.7368750817287, -122.388219954896)
23178	23178	11964	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1009X Mendell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			28	3X3		6015715.011390001	2096321.03931	37.7369808923559	-122.38812786163	(37.7369808923559, -122.38812786163)
123575	123575	11966	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1009X Mendell St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3x3		6015728.77645	2096327.58352	37.736999624078	-122.38808072579599	(37.736999624078, -122.388080725796)
54771	54771	176387	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100x Mansell St	4	Median : Cutout 11	Tree 1	DPW 2			32	Width 0ft		6011480.82156	2090667.2216900003	37.7212211781905	-122.402370013862	(37.7212211781905, -122.402370013862)
67100	67100	176388	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	100x Mansell St	8	Median : Cutout 11	Tree 1	DPW 2			32	Width 0ft		6011438.192840001	2090648.2271599998	37.7211666433202	-122.40251603501001	(37.7211666433202, -122.40251603501)
3956	3956	15038	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1017 Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3X3		6015648.0	2096190.0	37.7366173719863	-122.388350408836	(37.7366173719863, -122.388350408836)
97379	97379	15039	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1017 Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6015648.596419999	2096190.1744099997	37.736617883929604	-122.388348358907	(37.7366178839296, -122.388348358907)
1068	1068	11520	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/01/2017 12:00:00 AM	6	3X3		6018495.90717	2096693.85175	37.738158246093	-122.378538834904	(37.738158246093, -122.378538834904)
13431	13431	11527	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6018609.30332	2096848.22468	37.738588373848295	-122.378157476493	(37.7385883738483, -122.378157476493)
13473	13473	11540	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018782.49291	2097080.98118	37.7392370206652	-122.37757481115	(37.7392370206652, -122.37757481115)
13507	13507	11536	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018721.15121	2096997.58655	37.739004655647	-122.377781119206	(37.739004655647, -122.377781119206)
13546	13546	11531	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018661.768080001	2096921.7146599998	37.7387930541475	-122.37798117610501	(37.7387930541475, -122.377981176105)
13810	13810	11546	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	36	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018856.19666	2097185.73418	37.7395287121888	-122.37732724037701	(37.7395287121888, -122.377327240377)
13853	13853	11518	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018467.96004	2096661.77747	37.7380686358665	-122.37863323672899	(37.7380686358665, -122.378633236729)
13998	13998	11516	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018445.80461	2096632.24283	37.737986318204605	-122.378707789643	(37.7379863182046, -122.378707789643)
14283	14283	11524	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018572.85172	2096797.82035	37.7384479645089	-122.378280011831	(37.7384479645089, -122.378280011831)
14511	14511	11548	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6018882.85871	2097216.8887400003	37.7396157251883	-122.377237214629	(37.7396157251883, -122.377237214629)
14617	14617	11525	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018584.76615	2096814.86638	37.7384954262103	-122.37824000008499	(37.7384954262103, -122.378240000085)
14633	14633	11522	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018545.03968	2096763.4476400001	37.738352050906	-122.37837378772801	(37.738352050906, -122.378373787728)
14711	14711	11538	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	28	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018744.95776	2097030.5986900001	37.7390966122121	-122.377701096637	(37.7390966122121, -122.377701096637)
14775	14775	11542	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	32	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018808.16459	2097116.8368799998	37.739336887696396	-122.377488536484	(37.7393368876964, -122.377488536484)
15014	15014	11529	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018637.527419999	2096885.1095	37.7386912077413	-122.37806244962401	(37.7386912077413, -122.378062449624)
15019	15019	11534	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018698.318659999	2096968.53923	37.7389236393092	-122.37785804901002	(37.7389236393092, -122.37785804901)
15231	15231	11541	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	31	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018795.49875	2097098.36536	37.7392854707446	-122.377531048337	(37.7392854707446, -122.377531048337)
15479	15479	11521	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018533.508280001	2096747.4741099998	37.738307555143706	-122.378412549408	(37.7383075551437, -122.378412549408)
15508	15508	11512	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6018400.60741	2096569.54507	37.7378116707805	-122.378859707612	(37.7378116707805, -122.378859707612)
15591	15591	11533	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018685.57005	2096950.68125	37.738873902319	-122.377900889128	(37.738873902319, -122.377900889128)
15661	15661	11532	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018674.73047	2096936.9392900001	37.738835572289794	-122.377937414197	(37.7388355722898, -122.377937414197)
15740	15740	11517	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018459.10272	2096646.1554299998	37.738025252555	-122.37866277678499	(37.738025252555, -122.378662776785)
15806	15806	11530	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018648.41512	2096905.05742	37.7387465808009	-122.37802618897	(37.7387465808009, -122.37802618897)
15917	15917	11515	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018435.759869999	2096618.26492	37.7379473838671	-122.378741549297	(37.7379473838671, -122.378741549297)
15985	15985	11549	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	39	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018893.31945	2097233.60379	37.7396621976446	-122.37720220492399	(37.7396621976446, -122.377202204924)
16379	16379	11537	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	27	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018733.38325	2097012.4655799998	37.7390461845215	-122.37773985832399	(37.7390461845215, -122.377739858324)
16384	16384	11539	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	29	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018768.44621	2097065.7782599998	37.739194502529294	-122.37762232410601	(37.7391945025293, -122.377622324106)
16472	16472	11547	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	37	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018868.04549	2097199.54045	37.7395672742039	-122.377287229525	(37.7395672742039, -122.377287229525)
16711	16711	11513	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6018414.43418	2096589.52395	37.7378672911411	-122.378813288221	(37.7378672911411, -122.378813288221)
16734	16734	11519	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018482.73466	2096678.8993400002	37.7381164636019	-122.378583341463	(37.7381164636019, -122.378583341463)
16820	16820	11511	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	5		6018385.91854	2096547.1526	37.7377493756286	-122.378908940096	(37.7377493756286, -122.378908940096)
23085	23085	11553	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	43	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		12/23/1997 12:00:00 AM	29	3X3		6018940.8378099995	2097294.9489700003	37.7398332568108	-122.377042159778	(37.7398332568108, -122.377042159778)
23241	23241	11550	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	40	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			21	3X3		6018907.35155	2097248.08652	37.7397027373041	-122.37715469195601	(37.7397027373041, -122.377154691956)
97811	97811	11555	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	45	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018780.12501	2097120.54601	37.7393455274029	-122.377585743327	(37.7393455274029, -122.377585743327)
110882	110882	11545	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	35	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018711.11401	2097026.79601	37.7390843059742	-122.377817850373	(37.7390843059742, -122.377817850373)
118205	118205	11552	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	42	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018755.385009999	2097093.20201	37.7392690830796	-122.377669387059	(37.7392690830796, -122.377669387059)
140492	140492	11523	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	101X Jennings St	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6018517.10401	2096771.58701	37.7383728601739	-122.378470941616	(37.7383728601739, -122.378470941616)
144147	144147	11973	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1020X Mendell St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6015669.55392	2096331.84807	37.7370080523218	-122.388285783946	(37.7370080523218, -122.388285783946)
23270	23270	11971	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1022X Mendell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			21	3X3		6015641.62594	2096289.89853	37.736891319872896	-122.388379417299	(37.7368913198729, -122.388379417299)
103086	103086	11230	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1050X Ingalls St	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/13/1990 12:00:00 AM	45	3X4		6018085.661882901	2094069.8743192002	37.7309306978843	-122.379775016493	(37.7309306978843, -122.379775016493)
128599	128599	11231	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1050X Ingalls St	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/02/1990 12:00:00 AM	50	3X4		6018085.661882901	2094069.8743192002	37.7309306978843	-122.379775016493	(37.7309306978843, -122.379775016493)
18348	18348	16020	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	107 Monterey Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3x3		6001336.16248	2094611.17288	37.731478841871706	-122.437719447913	(37.7314788418717, -122.437719447913)
17259	17259	4834	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	108 Cortland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	5x5		6006318.50135	2097642.9115299997	37.7400853628581	-122.420709666225	(37.7400853628581, -122.420709666225)
22196	22196	4409	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1097 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	4x4		6004456.37766	2102543.07479	37.753434952361495	-122.427497136583	(37.7534349523615, -122.427497136583)
83866	83866	11477	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	10X Jennings St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6012892.419875	2089345.335603	37.7176702433836	-122.397397833393	(37.7176702433836, -122.397397833393)
112318	112318	11486	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	10X Jennings St	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6012892.419875	2089345.335603	37.7176702433836	-122.397397833393	(37.7176702433836, -122.397397833393)
118292	118292	11478	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	10X Jennings St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6012892.419875	2089345.335603	37.7176702433836	-122.397397833393	(37.7176702433836, -122.397397833393)
124892	124892	11481	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	10X Jennings St	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6012892.419875	2089345.335603	37.7176702433836	-122.397397833393	(37.7176702433836, -122.397397833393)
70249	70249	176386	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	10x Mansell St	10	Median : Cutout 11	Tree 1	DPW 2			8	Width 0ft		6011666.66331	2090722.9963200002	37.7213846965192	-122.40173152668501	(37.7213846965192, -122.401731526685)
162071	162071	176385	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	10x Mansell St	9	Median : Cutout 11	Tree 1	DPW 2			15	Width 0ft		6011675.69162	2090725.79104	37.7213928740681	-122.401700514484	(37.7213928740681, -122.401700514484)
7002	7002	5239	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1100 Divisadero St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6001407.3425	2112393.2913	37.780308287354295	-122.438747110907	(37.7803082873543, -122.438747110907)
17697	17697	4413	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1108 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			28	6x9		6004403.04195	2102416.52833	37.753084468576205	-122.427672567341	(37.7530844685762, -122.427672567341)
106493	106493	10804	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1139X Hudson Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			10	3X4		6017540.26401	2094828.3880099999	37.7329833277332	-122.38171330076901	(37.7329833277332, -122.381713300769)
124037	124037	10826	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1139X Hudson Ave	33	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/29/1990 12:00:00 AM	12	3X4		6017834.53501	2094620.0550099998	37.732427530713004	-122.380681442077	(37.732427530713, -122.380681442077)
19540	19540	4835	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	115 Cortland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3x3		6006362.63783	2097667.32197	37.7401548759573	-122.420558792379	(37.7401548759573, -122.420558792379)
37403	37403	11269	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1176X Ingalls St	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/03/1990 12:00:00 AM	3	3x3		6017716.362196	2093961.1645628002	37.7306118245585	-122.381044204671	(37.7306118245585, -122.381044204671)
85383	85383	11265	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1176X Ingalls St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/02/1992 12:00:00 AM	20	3X3		6017716.362196	2093961.1645628002	37.7306118245585	-122.381044204671	(37.7306118245585, -122.381044204671)
19096	19096	4431	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1195 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6004486.69317	2101949.49973	37.7518068485257	-122.427350018309	(37.7518068485257, -122.427350018309)
129383	129383	4430	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1195 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	3X3		6004484.1301445	2101944.4411304	37.751792813836104	-122.427358521283	(37.7517928138361, -122.427358521283)
111415	111415	11292	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1199X Ingalls St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/13/1990 12:00:00 AM	30	3X3		6017612.0195749	2093925.7037957	37.730508696225705	-122.38140247160801	(37.7305086962257, -122.381402471608)
85513	85513	11303	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1201X Ingalls St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/03/1993 12:00:00 AM	40	3X3		6017591.0151778	2093928.8426978001	37.7305161553992	-122.38147530581499	(37.7305161553992, -122.381475305815)
96922	96922	11305	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1201X Ingalls St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/03/1993 12:00:00 AM	40	3X3		6017591.0151778	2093928.8426978001	37.7305161553992	-122.38147530581499	(37.7305161553992, -122.381475305815)
7531	7531	8183	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1216 Fulton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			100	3X3		6001748.9425	2111188.325	37.777019181607706	-122.437479047598	(37.7770191816077, -122.437479047598)
95268	95268	11318	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1216X Ingalls St	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/10/1990 12:00:00 AM	60	3X3		6017561.7867095005	2093983.7658262001	37.7306653497809	-122.38158017208	(37.7306653497809, -122.38158017208)
101060	101060	11326	DPW Maintained 3	Eucalyptus sideroxylon :: Red Ironbark 36	1223 Ingalls St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/03/1993 12:00:00 AM	50	3X3		6017540.6929483	2093936.3628531997	37.730534025837706	-122.38164980170299	(37.7305340258377, -122.381649801703)

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