Street_Tree_List

Data source: data.sfgov.org

119 rows where DBH = 2 and qSpecies = 51 sorted by qCareAssistant

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant ▼	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
2988	2988	118173	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3221 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		11/13/2008 12:00:00 AM	2	Width 3ft		5985542.20124	2111089.15517	37.7758121588594	-122.49353507754299	(37.7758121588594, -122.493535077543)
4081	4081	102392	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	30X Harriet St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6010436.41014	2111752.09711	37.7790572463352	-122.40746601596202	(37.7790572463352, -122.407466015962)
6520	6520	121576	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3553-3555 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5997856.717119999	2115116.32362	37.787582382260396	-122.451226746117	(37.7875823822604, -122.451226746117)
8183	8183	112515	Section 143 8	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2646 Greenwich St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6000218.93903	2118886.7143900003	37.7980698532985	-122.443324869154	(37.7980698532985, -122.443324869154)
9705	9705	110500	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900X JESSIE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6007667.0	2110717.0	37.7760597176113	-122.416973193872	(37.7760597176113, -122.416973193872)
9707	9707	110499	Section 143 8	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900X JESSIE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6007667.0	2110717.0	37.7760597176113	-122.416973193872	(37.7760597176113, -122.416973193872)
9708	9708	110501	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	900X JESSIE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		6007667.0	2110717.0	37.7760597176113	-122.416973193872	(37.7760597176113, -122.416973193872)
22997	22997	12121	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400X La Salle Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3X3		6016540.00349	2094984.34395	37.733356269266295	-122.38518235797899	(37.7333562692663, -122.385182357979)
23088	23088	29	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	742 14th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3X3		6003854.77769	2107764.13441	37.7677366901162	-122.42994999788799	(37.7677366901162, -122.429949997888)
24232	24232	72017	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	464 Tehama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/08/2008 12:00:00 AM	2	3x3	Permit Number 51206	6010897.54847	2112072.46722	37.7799627080392	-122.40589331753701	(37.7799627080392, -122.405893317537)
24235	24235	217813	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	198 Lee Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996579.91933	2091952.01212	37.7239058307663	-122.453970623549	(37.7239058307663, -122.453970623549)
25481	25481	198281	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017868.75025	2099595.89007	37.7460920687928	-122.380908946009	(37.7460920687928, -122.380908946009)
26433	26433	198400	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	89 Harriet St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010709.70909	2111519.6014400003	37.7784341609423	-122.406504172125	(37.7784341609423, -122.406504172125)
27257	27257	198403	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	85 Harriet St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010625.154180001	2111610.62913	37.778679370990204	-122.406803097794	(37.7786793709902, -122.406803097794)
27624	27624	94226	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	625 03rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/22/2010 12:00:00 AM	2	3x3	Permit Number 53569	6014463.046680001	2111873.47872	37.779615090399204	-122.393544638372	(37.7796150903992, -122.393544638372)
28847	28847	198338	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	474 Natoma St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010471.529619999	2112264.21742	37.7804653742171	-122.40738063611299	(37.7804653742171, -122.407380636113)
29317	29317	217810	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	198 Lee Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996576.41484	2091837.9853700001	37.7235925393546	-122.453974506819	(37.7235925393546, -122.453974506819)
35027	35027	242906	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2641 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010204.149619999	2104543.2646	37.759250446279005	-122.407761055636	(37.759250446279, -122.407761055636)
35682	35682	198337	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	474 Natoma St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010500.52756	2112291.4654599996	37.7805418139019	-122.407282239501	(37.7805418139019, -122.407282239501)
37463	37463	101234	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	251 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	3x3		5994788.53914	2111424.28345	37.7772688824616	-122.46157417945801	(37.7772688824616, -122.461574179458)
37498	37498	198311	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	75 Lansing St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014300.67476	2114126.83927	37.7857932808859	-122.394264166169	(37.7857932808859, -122.394264166169)
38555	38555	198390	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011047.1046400005	2113083.17782	37.7827462455888	-122.405447134184	(37.7827462455888, -122.405447134184)
38574	38574	219441	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	147 Stillings Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 8ft		5999786.27103	2095740.5208700001	37.734491517651	-122.443158781469	(37.734491517651, -122.443158781469)
40939	40939	198418	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1062 Key Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6013212.31335	2089895.25282	37.7191980120665	-122.396330620284	(37.7191980120665, -122.396330620284)
41510	41510	198346	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	522 Minna St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6010010.37374	2112093.20065	37.7799699808627	-122.40896392853901	(37.7799699808627, -122.408963928539)
43543	43543	58803	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2246 Filbert St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/29/2013 12:00:00 AM	2		Permit Number 769648	6002177.82636	2118813.48385	37.7979802907265	-122.436541316255	(37.7979802907265, -122.436541316255)
49855	49855	242329	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	107 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6005095.8624599995	2099583.89393	37.745345873425705	-122.42507512473699	(37.7453458734257, -122.425075124737)
50950	50950	246860	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1198 Oak St	4	: 4	Tree 1	Private 1			2	Width 4ft		6001322.98115	2109744.38173	37.773030249875795	-122.43884907734301	(37.7730302498758, -122.438849077343)
52843	52843	123809	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2151 Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5991938.472709999	2111997.6444599996	37.7786787136504	-122.47147517248699	(37.7786787136504, -122.471475172487)
55397	55397	242344	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	147 Moffitt St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6002611.74141	2096837.65353	37.7376646954683	-122.43346858283199	(37.7376646954683, -122.433468582832)
55610	55610	198286	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017773.62926	2099591.7423799997	37.7460754295565	-122.381237577149	(37.7460754295565, -122.381237577149)
57375	57375	198392	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011000.014830001	2113040.11829	37.7826253811877	-122.40560701207899	(37.7826253811877, -122.405607012079)
57427	57427	56140	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	788 Carolina St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/22/2010 12:00:00 AM	2	3x3	Permit Number 53594	6012400.21766	2104278.3607900003	37.7586457727003	-122.400147339446	(37.7586457727003, -122.400147339446)
59401	59401	217811	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	198 Lee Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996578.30824	2091874.8605099998	37.7236938983276	-122.453970623552	(37.7236938983276, -122.453970623552)
59710	59710	53541	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	312 04th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		03/06/2008 12:00:00 AM	2	3x3	Permit Number 50291	5994656.27049	2113349.39489	37.782547108504	-122.462171384858	(37.782547108504, -122.462171384858)
59791	59791	198356	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	583 Natoma St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009794.87498	2111587.46362	37.7785692724036	-122.40967373196199	(37.7785692724036, -122.409673731962)
61657	61657	219437	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2207 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990996.77172	2100343.44313	37.746624866753294	-122.473882383471	(37.7466248667533, -122.473882383471)
62572	62572	96922	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3208 Pierce St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/09/2011 12:00:00 AM	2	3x3	Permit Number 767943	6001392.66231	2119445.8775400002	37.799672028811	-122.43930355514	(37.799672028811, -122.43930355514)
63331	63331	123716	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	227 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5994853.672809999	2111423.99152	37.777271829773	-122.461348841581	(37.777271829773, -122.461348841581)
65432	65432	198288	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017733.321719999	2099589.8795	37.7460680892801	-122.3813768273	(37.7460680892801, -122.3813768273)
65501	65501	198341	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	446 Tehama St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011001.22504	2112170.1942	37.78023684118379	-122.40554153692699	(37.7802368411838, -122.405541536927)
67039	67039	120355	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2270 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5988402.72558	2114696.23379	37.78588309898829	-122.48390447116999	(37.7858830989883, -122.48390447117)
70304	70304	120354	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2270 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5988430.28754	2114697.53592	37.7858882787477	-122.483809211099	(37.7858882787477, -122.483809211099)
71414	71414	41629	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	433 Locust St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/09/2008 12:00:00 AM	2	3x3	Permit Number 51282	5997644.2427199995	2114968.05541	37.78716310932511	-122.45195116082701	(37.7871631093251, -122.451951160827)
73875	73875	198295	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017570.97457	2099580.31165	37.746032853833206	-122.38193754289101	(37.7460328538332, -122.381937542891)
94140	94140	198358	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	585 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009840.111719999	2111636.50785	37.77870647115171	-122.40952070242399	(37.7787064711517, -122.409520702424)
97698	97698	9253	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	6500X Geary Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		03/12/2011 12:00:00 AM	2	2X3		5986722.32109	2112597.81428	37.7800234720171	-122.489563763122	(37.7800234720171, -122.489563763122)
99040	99040	106014	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	5235 DIAMOND HEIGHTS BLVD	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3x3		6001081.8	2099374.5	37.7445433581402	-122.43894005993	(37.7445433581402, -122.43894005993)
114038	114038	106017	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	5235 DIAMOND HEIGHTS BLVD	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3x3		6001081.8	2099374.5	37.7445433581402	-122.43894005993	(37.7445433581402, -122.43894005993)
118113	118113	198335	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	474 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010531.27107	2112320.8566799997	37.7806242358615	-122.407177955016	(37.7806242358615, -122.407177955016)
118958	118958	106013	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	5235 DIAMOND HEIGHTS BLVD	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		05/16/2016 12:00:00 AM	2	3x3		6001081.8	2099374.5	37.7445433581402	-122.43894005993	(37.7445433581402, -122.43894005993)
121282	121282	198393	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010986.3468	2113026.7242099997	37.782587839895704	-122.40565335414401	(37.7825878398957, -122.405653354144)
130611	130611	198343	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	482 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010728.24226	2111905.72777	37.7794954104221	-122.40646727384501	(37.7794954104221, -122.406467273845)
130929	130929	198360	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	511 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6010317.43719	2112088.63821	37.77997464925679	-122.407901331877	(37.7799746492568, -122.407901331877)
133181	133181	242915	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	111 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6005066.82423	2099579.80768	37.7453330131246	-122.425175243547	(37.7453330131246, -122.425175243547)
133474	133474	59489	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1029 Rhode Island St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/02/2008 12:00:00 AM	2	3x3	Permit Number 51129	6011954.00169	2103318.43549	37.75598513922839	-122.401623098137	(37.7559851392284, -122.401623098137)
133977	133977	198351	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	579 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009664.57809	2111726.37194	37.778943379569704	-122.410134290082	(37.7789433795697, -122.410134290082)
134851	134851	198350	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	582 Minna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009649.44136	2111748.76797	37.779004025349	-122.410188235924	(37.779004025349, -122.410188235924)
135389	135389	123802	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2000 Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5992440.56126	2112076.14549	37.7789232893494	-122.469743985984	(37.7789232893494, -122.469743985984)
135478	135478	198359	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	573 Natoma St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009917.75188	2111704.28637	37.7788969251014	-122.409256897985	(37.7788969251014, -122.409256897985)
137125	137125	198391	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011033.457280001	2113070.7839	37.7827114517206	-122.405493475357	(37.7827114517206, -122.405493475357)
137321	137321	217812	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	198 Lee Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5996576.30659	2091913.4949400001	37.723799864560704	-122.453980331735	(37.7237998645607, -122.453980331735)
137959	137959	198404	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	83 Harriet St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010593.58852	2111640.0452900003	37.778758374645	-122.40691436999799	(37.778758374645, -122.406914369998)
144778	144778	106016	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	5285 DIAMOND HEIGHTS BLVD	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			2	3x3		6001339.5	2099171.1	37.7439995285584	-122.438034420154	(37.7439995285584, -122.438034420154)
146618	146618	97960	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2280X McKinnon Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2011 12:00:00 AM	2	3x3	Permit Number 768057	6011686.23984	2098718.09501	37.7433386585668	-122.40222568708401	(37.7433386585668, -122.402225687084)
146787	146787	198410	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	17 Washburn St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6008351.381440001	2110501.05222	37.7755052498045	-122.41459044430599	(37.7755052498045, -122.414590444306)
147190	147190	218159	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1400 Portola Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993095.853519999	2097590.7626	37.7391880606825	-122.46642400716001	(37.7391880606825, -122.46642400716)
147691	147691	198299	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	20	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017490.49598	2099601.17912	37.746085707003004	-122.38221728150499	(37.746085707003, -122.382217281505)
150257	150257	198412	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	230 09th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008892.8761599995	2110114.82247	37.7744751609416	-122.412689967265	(37.7744751609416, -122.412689967265)
151131	151131	97958	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2280X McKinnon Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2011 12:00:00 AM	2	3x3	Permit Number 768057	6011714.55105	2098696.24817	37.7432802520847	-122.402126258043	(37.7432802520847, -122.402126258043)
152803	152803	198382	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011448.39911	2113467.1712	37.7838230308611	-122.404085850185	(37.7838230308611, -122.404085850185)
152817	152817	198384	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011417.757619999	2113442.45107	37.783753443101	-122.404190118502	(37.783753443101, -122.404190118502)
153150	153150	198339	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	474 Natoma St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010463.35799	2112256.87928	37.780444768040496	-122.40740838828	(37.7804447680405, -122.40740838828)
157353	157353	136943	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1771 Washington St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6006301.75363	2116945.84778	37.7930857115761	-122.42213857116	(37.7930857115761, -122.42213857116)
159247	159247	96923	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3208 Pierce St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/09/2011 12:00:00 AM	2	3x3	Permit Number 767943	6001389.811290001	2119472.57497	37.7997451706686	-122.439315335361	(37.7997451706686, -122.439315335361)
159480	159480	198394	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010970.67722	2113013.70432	37.782551214095	-122.40570664706001	(37.782551214095, -122.40570664706)
159839	159839	198423	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1195 La Salle Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6017270.50645	2094483.4459099998	37.7320212859403	-122.38262193865299	(37.7320212859403, -122.382621938653)
163510	163510	248272	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	155 Lundy's Ln	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006707.09266	2098676.55719	37.742945416513	-122.419439385544	(37.742945416513, -122.419439385544)
163821	163821	198349	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	582 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009676.44757	2111773.36743	37.7790730833855	-122.410096547333	(37.7790730833855, -122.410096547333)
164548	164548	198347	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	550 Minna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009974.66156	2112054.4958599997	37.77986170610271	-122.40908474167401	(37.7798617061027, -122.409084741674)
165359	165359	198352	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	535 Minna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009949.72437	2111999.26449	37.779708656768996	-122.409167112381	(37.779708656769, -122.409167112381)
165549	165549	198399	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	89 Harriet St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010752.17544	2111476.66266	37.7783186367246	-122.406354238056	(37.7783186367246, -122.406354238056)
165778	165778	198314	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	578 02nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014710.85995	2112833.85129	37.7822658223454	-122.39275454260401	(37.7822658223454, -122.392754542604)
166233	166233	218782	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1434 14th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		5991822.86644	2105659.6117	37.7612694917142	-122.47141315629999	(37.7612694917142, -122.4714131563)
166466	166466	242334	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	206 28th St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004464.328980001	2099597.23068	37.7453467979142	-122.427259814498	(37.7453467979142, -122.427259814498)
166579	166579	198389	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6011138.46827	2113179.02511	37.78301452774279	-122.40513780428499	(37.7830145277428, -122.405137804285)
168366	168366	217730	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1200x Arguello Blvd	1	Median : Cutout 11	Tree 1	DPW 2			2	Width 2ft		5995796.25486	2107257.89675	37.765887025696394	-122.45778663137101	(37.7658870256964, -122.457786631371)
169666	169666	219436	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1001 Ortega St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5990892.67595	2102441.87183	37.752380574612204	-122.474395438619	(37.7523805746122, -122.474395438619)
169970	169970	198413	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	234 09th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008929.92421	2110078.39089	37.774377207666795	-122.412559234629	(37.7743772076668, -122.412559234629)
171220	171220	198312	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	81 Lansing St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6014325.56305	2114147.83058	37.7858523015842	-122.394179529164	(37.7858523015842, -122.394179529164)
171813	171813	249416	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	650 Turk St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006834.06276	2112935.18598	37.7821034308803	-122.42001200005899	(37.7821034308803, -122.420012000059)
172019	172019	198298	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	500 Amador St	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 8ft		6017519.7761	2099586.1475400003	37.7460460504973	-122.38211498813601	(37.7460460504973, -122.382114988136)
175261	175261	198355	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	538 Natoma St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6010114.138119999	2111927.58164	37.7795210419915	-122.40859327295401	(37.7795210419915, -122.408593272954)
175810	175810	246512	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	50 Laguna St	1	: 4	Tree 1	Private 1			2	Width 3ft		6005254.0996199995	2109149.02764	37.7716184212706	-122.425208466318	(37.7716184212706, -122.425208466318)
176058	176058	198395	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	120 Minna St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010955.650090001	2112999.3376599997	37.7825109262834	-122.40575762241998	(37.7825109262834, -122.40575762242)
176339	176339	198348	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	550 Minna St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009856.94052	2111939.21808	37.779538585085795	-122.409483854493	(37.7795385850858, -122.409483854493)
176442	176442	97961	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2280X McKinnon Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/06/2011 12:00:00 AM	2	3x3	Permit Number 768057	6011645.30787	2098748.77937	37.743420626377294	-122.402369377168	(37.7434206263773, -122.402369377168)
176772	176772	120687	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	2040 Balboa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5989191.37637	2111280.32009	37.776549837038495	-122.48092579961501	(37.7765498370385, -122.480925799615)
176956	176956	198345	Undocumented 2	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	451 Tehama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 2ft		6010996.3869	2112125.34769	37.7801134326192	-122.405555114895	(37.7801134326192, -122.405555114895)
178966	178966	96921	Permitted Site 1	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	3208 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/09/2011 12:00:00 AM	2	3x3	Permit Number 767943	6001394.57427	2119432.51874	37.799635457872704	-122.43929598102501	(37.7996354578727, -122.439295981025)

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