Street_Tree_List

Data source: data.sfgov.org

3,888 rows where qSpecies = 22 sorted by qSiteInfo 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

- 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, qCaretaker, qCareAssistant

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo ▲	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
123296	123296	177517	Undocumented 2	Maytenus boaria :: Mayten 22	654 Peru Ave	5	Side Yard : Yard 17	Tree 1	Private 1			3			6005174.05368	2092521.73439	37.7259591826438	-122.424302559431	(37.7259591826438, -122.424302559431)
131384	131384	248174	Undocumented 2	Maytenus boaria :: Mayten 22	218 Esmeralda Ave	3	Side Yard : Yard 17	Tree 1	Private 1			18			6007322.63795	2098720.65313	37.7431011449024	-122.41731411847401	(37.7431011449024, -122.417314118474)
79581	79581	117011	Undocumented 2	Maytenus boaria :: Mayten 22	457X CASTRO ST	1	Back Yard : Cutout 16	Tree 1	MTA 6	Private 3		27	3x6		6002348.0	2105584.0	37.7616651256499	-122.435005811888	(37.7616651256499, -122.435005811888)
89465	89465	114506	Undocumented 2	Maytenus boaria :: Mayten 22	10 LOMBARD ST	1	Back Yard : Cutout 16	Tree 1	Port 9				4x4		6011932.0	2120995.0	37.8045196580749	-122.402942401468	(37.8045196580749, -122.402942401468)
125405	125405	114508	Undocumented 2	Maytenus boaria :: Mayten 22	10 LOMBARD ST	3	Back Yard : Cutout 16	Tree 1	Port 9				4x4		6011932.0	2120995.0	37.8045196580749	-122.402942401468	(37.8045196580749, -122.402942401468)
3501	3501	247943	Planning Code 138.1 required 4	Maytenus boaria :: Mayten 22	29 Joy St	6	Unaccepted Street : Yard 14	Tree 1	DPW 2			2		Permit Number 775404	6010304.2598	2098903.51059	37.7437705318851	-122.407017307297	(37.7437705318851, -122.407017307297)
27928	27928	231945	Undocumented 2	Maytenus boaria :: Mayten 22	33 Penny Ln	4	Back Yard : Yard 13	Tree 1	Private 1			2	Width 2ft		6002666.1416	2096136.6991599998	37.7357431221521	-122.433230424364	(37.7357431221521, -122.433230424364)
43309	43309	231938	Undocumented 2	Maytenus boaria :: Mayten 22	1 Penny Ln	1	Back Yard : Yard 13	Tree 1	Private 1			4	Width 2ft		6002328.37989	2096518.1207400002	37.7367712513805	-122.43442545876499	(37.7367712513805, -122.434425458765)
47848	47848	209611	Undocumented 2	Maytenus boaria :: Mayten 22	77 Ralston St	1	Back Yard : Yard 13	Tree 1	Private 1			13			5992168.85342	2088365.8404	37.7138051716457	-122.468957974754	(37.7138051716457, -122.468957974754)
62808	62808	231942	Undocumented 2	Maytenus boaria :: Mayten 22	31 Penny Ln	5	Back Yard : Yard 13	Tree 1	Private 1			5	Width 2ft		6002659.32372	2096145.42523	37.735766695166504	-122.433254619725	(37.7357666951665, -122.433254619725)
132003	132003	231941	Undocumented 2	Maytenus boaria :: Mayten 22	31 Penny Ln	3	Back Yard : Yard 13	Tree 1	Private 1			4	Width 2ft		6002655.75902	2096147.9144099997	37.7357733276597	-122.43326712208	(37.7357733276597, -122.43326712208)
149582	149582	231939	Undocumented 2	Maytenus boaria :: Mayten 22	1 Penny Ln	2	Back Yard : Yard 13	Tree 1	Private 1			5	Width 2ft		6002331.25514	2096517.0119	37.7367683699712	-122.434415438526	(37.7367683699712, -122.434415438526)
155248	155248	231944	Undocumented 2	Maytenus boaria :: Mayten 22	33 Penny Ln	3	Back Yard : Yard 13	Tree 1	Private 1			9	Width 2ft		6002664.28784	2096138.10096	37.7357468660117	-122.43323693366001	(37.7357468660117, -122.43323693366)
155846	155846	231943	Undocumented 2	Maytenus boaria :: Mayten 22	33 Penny Ln	2	Back Yard : Yard 13	Tree 1	Private 1			1	Width 2ft		6002661.77062	2096140.53935	37.7357534184718	-122.43324581083901	(37.7357534184718, -122.433245810839)
184761	184761	231940	Undocumented 2	Maytenus boaria :: Mayten 22	31 Penny Ln	1	Back Yard : Yard 13	Tree 1	Private 1			5	Width 2ft		6002651.97591	2096151.4784799998	37.735782899162395	-122.433280456348	(37.7357828991624, -122.433280456348)
43528	43528	209215	DPW Maintained 3	Maytenus boaria :: Mayten 22	99x Castenada Ave	25	Median : Cutout 11	Tree 1	DPW 2			15	Width 5ft		5993821.14503	2100240.07202	37.746504222711295	-122.46410856948	(37.7465042227113, -122.46410856948)
44102	44102	209213	DPW Maintained 3	Maytenus boaria :: Mayten 22	99x San Marcos Ave	23	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		5993777.82606	2100247.64237	37.7465225122089	-122.46425891004101	(37.7465225122089, -122.464258910041)
53156	53156	209769	DPW Maintained 3	Maytenus boaria :: Mayten 22	100x Pacheco St	2	Median : Cutout 11	Tree 1	DPW 2			2	Width 3ft		5994792.885	2099741.94773	37.745192456276705	-122.460712331024	(37.7451924562767, -122.460712331024)
60137	60137	209212	DPW Maintained 3	Maytenus boaria :: Mayten 22	99x San Marcos Ave	22	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		5993771.94389	2100232.96399	37.746481870051106	-122.4642781843	(37.7464818700511, -122.4642781843)
75541	75541	209208	DPW Maintained 3	Maytenus boaria :: Mayten 22	99x San Marcos Ave	18	Median : Cutout 11	Tree 1	DPW 2			3	Width 5ft		5993802.83706	2100253.03783	37.7465387683529	-122.46417281704399	(37.7465387683529, -122.464172817044)
106244	106244	459	DPW Maintained 3	Maytenus boaria :: Mayten 22	760x 23rd Ave	23	Median : Cutout 11	Tree 1	DPW 2			12			5988830.89675	2110023.4193700003	37.773077776353	-122.48208068722602	(37.773077776353, -122.482080687226)
123719	123719	209209	DPW Maintained 3	Maytenus boaria :: Mayten 22	99x San Marcos Ave	19	Median : Cutout 11	Tree 1	DPW 2			3	Width 5ft		5993795.21392	2100243.94669	37.746513367011	-122.464198516942	(37.746513367011, -122.464198516942)
134453	134453	209214	DPW Maintained 3	Maytenus boaria :: Mayten 22	99x Castenada Ave	24	Median : Cutout 11	Tree 1	DPW 2			8	Width 5ft		5993812.322269999	2100226.93547	37.746467644571	-122.464138123878	(37.746467644571, -122.464138123878)
134537	134537	209762	DPW Maintained 3	Maytenus boaria :: Mayten 22	1200x Plymouth Ave	2	Median : Cutout 11	Tree 1	DPW 2			7	Width 3ft		5995809.026930001	2092599.65126	37.72563986216979	-122.456682272862	(37.7256398621698, -122.456682272862)
134757	134757	209210	DPW Maintained 3	Maytenus boaria :: Mayten 22	99x San Marcos Ave	20	Median : Cutout 11	Tree 1	DPW 2			1	Width 5ft		5993788.41941	2100238.90873	37.746499142429705	-122.464221645739	(37.7464991424297, -122.464221645739)
152005	152005	209768	DPW Maintained 3	Maytenus boaria :: Mayten 22	100x Pacheco St	1	Median : Cutout 11	Tree 1	DPW 2			2	Width 3ft		5994733.37028	2099685.92288	37.7450352017206	-122.460914061546	(37.7450352017206, -122.460914061546)
157795	157795	209207	DPW Maintained 3	Maytenus boaria :: Mayten 22	99x San Marcos Ave	17	Median : Cutout 11	Tree 1	DPW 2			3	Width 5ft		5993815.86849	2100254.24474	37.7465428332992	-122.46412784372801	(37.7465428332992, -122.464127843728)
161466	161466	193529	DPW Maintained 3	Maytenus boaria :: Mayten 22	2x Garlington Ct	5	Median : Cutout 11	Tree 1	DPW 2			6	Width 6ft		6016723.20154	2094502.11588	37.732042299514106	-122.38451540818001	(37.7320422995141, -122.38451540818)
178018	178018	209211	DPW Maintained 3	Maytenus boaria :: Mayten 22	99x San Marcos Ave	21	Median : Cutout 11	Tree 1	DPW 2			2	Width 5ft		5993782.2667	2100229.04683	37.7464717095186	-122.46424220511601	(37.7464717095186, -122.464242205116)
4327	4327	103839	DPW Maintained 3	Maytenus boaria :: Mayten 22	1552 Polk St	1	Sidewalk: Curb side : Pot 10	Tree 1	DPW 2		11/01/2009 12:00:00 AM	3	3x3		6006685.2576	2116316.1212	37.791378262309706	-122.420766896	(37.7913782623097, -122.420766896)
25173	25173	140670	Undocumented 2	Maytenus boaria :: Mayten 22	40 COLE ST	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 0ft		5997774.3514	2110415.6204	37.7746707659902	-122.451172585534	(37.7746707659902, -122.451172585534)
33890	33890	231844	Undocumented 2	Maytenus boaria :: Mayten 22	96 Museum Way	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			11	Width 3ft		6000872.22935	2106652.07973	37.764513903924104	-122.44018648793501	(37.7645139039241, -122.440186487935)
39973	39973	131171	Undocumented 2	Maytenus boaria :: Mayten 22	1028 Chestnut St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		6006900.3516	2120517.59651	37.802926579956704	-122.420321008927	(37.8029265799567, -122.420321008927)
46561	46561	131183	Undocumented 2	Maytenus boaria :: Mayten 22	504 Commercial St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 5ft		6012392.07307	2117339.05892	37.7945070037376	-122.401093222084	(37.7945070037376, -122.401093222084)
51159	51159	231682	Undocumented 2	Maytenus boaria :: Mayten 22	141 Elsie St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			9	Width 5ft		6007132.37905	2098439.10695	37.7423173758515	-122.417952030056	(37.7423173758515, -122.417952030056)
59455	59455	131090	Undocumented 2	Maytenus boaria :: Mayten 22	1651 North Point St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			13	Width 4ft		6002849.6651	2120943.5541	37.8038670612875	-122.434368934585	(37.8038670612875, -122.434368934585)
59844	59844	250237	Undocumented 2	Maytenus boaria :: Mayten 22	523 Commercial St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 0ft		6012474.90226	2117332.79898	37.7944944357317	-122.400806180977	(37.7944944357317, -122.400806180977)
62892	62892	131172	Undocumented 2	Maytenus boaria :: Mayten 22	1028 Chestnut St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 4ft		6006879.14909	2120515.3465299997	37.8029192073136	-122.42039422091999	(37.8029192073136, -122.42039422092)
72701	72701	131185	Undocumented 2	Maytenus boaria :: Mayten 22	504 Commercial St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 5ft		6012367.16594	2117335.57564	37.7944960499984	-122.401179159505	(37.7944960499984, -122.401179159505)
73011	73011	244935	Undocumented 2	Maytenus boaria :: Mayten 22	290 Page St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 0ft		6005183.8966	2109935.4965	37.7737739081682	-122.42550728374701	(37.7737739081682, -122.425507283747)
73537	73537	250236	Undocumented 2	Maytenus boaria :: Mayten 22	520 Commercial St	7	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 0ft		6012472.9903	2117349.79933	37.794541008002895	-122.400813991574	(37.7945410080029, -122.400813991574)
75268	75268	231771	Undocumented 2	Maytenus boaria :: Mayten 22	2123 Castro St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 8ft		6002709.35623	2099334.27137	37.744525367058394	-122.43330942979901	(37.7445253670584, -122.433309429799)
75798	75798	209607	Undocumented 2	Maytenus boaria :: Mayten 22	488 Arch St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 6ft		5992758.831730001	2090447.2277099998	37.719554228122504	-122.46707004236099	(37.7195542281225, -122.467070042361)
75844	75844	250239	Undocumented 2	Maytenus boaria :: Mayten 22	523 Commercial St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 0ft		6012493.23475	2117334.36425	37.7944997561019	-122.400742857909	(37.7944997561019, -122.400742857909)
131519	131519	131182	Undocumented 2	Maytenus boaria :: Mayten 22	504 Commercial St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 5ft		6012408.13843	2117341.1258	37.7945135750949	-122.401037778889	(37.7945135750949, -122.401037778889)
136763	136763	231925	Undocumented 2	Maytenus boaria :: Mayten 22	125 Moffitt St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			3	Width 3ft		6002717.16903	2096703.03689	37.737301050095205	-122.433094454065	(37.7373010500952, -122.433094454065)
137641	137641	250240	Undocumented 2	Maytenus boaria :: Mayten 22	523 Commercial St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			8	Width 0ft		6012509.92284	2117337.5567099997	37.794509452601105	-122.40068533906201	(37.7945094526011, -122.400685339062)
150348	150348	131178	Undocumented 2	Maytenus boaria :: Mayten 22	505 Commercial St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 5ft		6012368.62422	2117315.33506	37.7944405555417	-122.401172690686	(37.7944405555417, -122.401172690686)
155461	155461	131181	Undocumented 2	Maytenus boaria :: Mayten 22	505 Commercial St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 5ft		6012409.58027	2117320.08736	37.7944558889799	-122.401031310972	(37.7944558889799, -122.401031310972)
155709	155709	131184	Undocumented 2	Maytenus boaria :: Mayten 22	504 Commercial St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 5ft		6012380.30044	2117337.96833	37.794503352491	-122.40113388043301	(37.794503352491, -122.401133880433)
156877	156877	250238	Undocumented 2	Maytenus boaria :: Mayten 22	523 Commercial St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 0ft		6012482.15733	2117334.58927	37.7944997561041	-122.400781203214	(37.7944997561041, -122.400781203214)
156945	156945	250242	Undocumented 2	Maytenus boaria :: Mayten 22	523 Commercial St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 0ft		6012536.17343	2117342.3206700003	37.7945239973486	-122.400594842992	(37.7945239973486, -122.400594842992)
158973	158973	131177	Undocumented 2	Maytenus boaria :: Mayten 22	505 Commercial St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 5ft		6012356.862380001	2117314.77617	37.794438364791205	-122.401213349039	(37.7944383647912, -122.401213349039)
159208	159208	131180	Undocumented 2	Maytenus boaria :: Mayten 22	505 Commercial St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 5ft		6012394.326669999	2117318.5359	37.794450778130205	-122.401083981553	(37.7944507781302, -122.401083981553)
159643	159643	250241	Undocumented 2	Maytenus boaria :: Mayten 22	523 Commercial St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			5	Width 0ft		6012522.17079	2117340.39818	37.7945179377025	-122.400643159068	(37.7945179377025, -122.400643159068)
161819	161819	209556	Undocumented 2	Maytenus boaria :: Mayten 22	992 Waithman Way	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			7	Width 4ft		5996028.8528	2098497.23395	37.741845813638	-122.456348606399	(37.741845813638, -122.456348606399)
165068	165068	250233	Undocumented 2	Maytenus boaria :: Mayten 22	520 Commercial St	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			8	Width 0ft		6012521.31946	2117354.65914	37.794557047424796	-122.400647107095	(37.7945570474248, -122.400647107095)
169217	169217	250232	Undocumented 2	Maytenus boaria :: Mayten 22	520 Commercial St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			9	Width 0ft		6012525.89293	2117355.21508	37.794558828975	-122.400631321282	(37.794558828975, -122.400631321282)
169447	169447	231770	Undocumented 2	Maytenus boaria :: Mayten 22	2127 Castro St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 8ft		6002711.64432	2099292.5474900003	37.7444109328282	-122.433298537219	(37.7444109328282, -122.433298537219)
169486	169486	231937	Undocumented 2	Maytenus boaria :: Mayten 22	289 Randall St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			8	Width 3ft		6003768.435219999	2097853.76766	37.740520270493796	-122.429541784839	(37.7405202704938, -122.429541784839)
169948	169948	182141	Undocumented 2	Maytenus boaria :: Mayten 22	1414 25th Ave	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			2	Width 0ft		5988378.9203	2105649.8128	37.761042756843	-122.48332344606001	(37.761042756843, -122.48332344606)
170813	170813	231934	Undocumented 2	Maytenus boaria :: Mayten 22	125 Randall St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			11	Width 3ft		6004720.88088	2097540.11743	37.739712940109705	-122.42622627133801	(37.7397129401097, -122.426226271338)
175764	175764	250230	Undocumented 2	Maytenus boaria :: Mayten 22	520 Commercial St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			12	Width 0ft		6012537.64619	2117356.2743599997	37.7945623929982	-122.400590727701	(37.7945623929982, -122.400590727701)
175818	175818	182134	Undocumented 2	Maytenus boaria :: Mayten 22	1434 25th Ave	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			13	Width 0ft		5988383.0453	2105547.1446	37.7607610979396	-122.483301653477	(37.7607610979396, -122.483301653477)
180902	180902	250231	Undocumented 2	Maytenus boaria :: Mayten 22	520 Commercial St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			13	Width 0ft		6012532.440909999	2117356.70467	37.7945632842246	-122.400608768988	(37.7945632842246, -122.400608768988)
184358	184358	131179	Undocumented 2	Maytenus boaria :: Mayten 22	505 Commercial St	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 5ft		6012381.19757	2117316.40905	37.7944442058913	-122.40112926060101	(37.7944442058913, -122.401129260601)
186459	186459	250234	Undocumented 2	Maytenus boaria :: Mayten 22	520 Commercial St	5	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			8	Width 0ft		6012500.45193	2117354.10926	37.79455437373571	-122.400719273201	(37.7945543737357, -122.400719273201)
188464	188464	250235	Undocumented 2	Maytenus boaria :: Mayten 22	520 Commercial St	6	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			11	Width 0ft		6012481.472999999	2117350.27619	37.7945427904834	-122.40078467369601	(37.7945427904834, -122.400784673696)
5061	5061	253757	Undocumented 2	Maytenus boaria :: Mayten 22	330 Twin Peaks Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x6	Permit Number 780692	5998725.10706	2103975.38052	37.75704188115579	-122.44742009249201	(37.7570418811558, -122.447420092492)
5072	5072	253758	Undocumented 2	Maytenus boaria :: Mayten 22	330 Twin Peaks Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x6	Permit Number 780692	5998725.10706	2103975.38052	37.75704188115579	-122.44742009249201	(37.7570418811558, -122.447420092492)
5078	5078	253759	Undocumented 2	Maytenus boaria :: Mayten 22	330 Twin Peaks Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x6	Permit Number 780692	5998725.10706	2103975.38052	37.75704188115579	-122.44742009249201	(37.7570418811558, -122.447420092492)
23410	23410	184354	Undocumented 2	Maytenus boaria :: Mayten 22	1251 Sunset Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 0ft		5984645.6432	2106661.7256	37.7636032084053	-122.496309703367	(37.7636032084053, -122.496309703367)
23510	23510	209272	Undocumented 2	Maytenus boaria :: Mayten 22	843 Detroit St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 5ft		5999418.82606	2095617.22879	37.7341320280635	-122.444420298265	(37.7341320280635, -122.444420298265)
23984	23984	209244	Undocumented 2	Maytenus boaria :: Mayten 22	775 Ulloa St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 3ft		5993691.11569	2098103.1453400003	37.740629265622104	-122.46440306685801	(37.7406292656221, -122.464403066858)
24117	24117	231843	Undocumented 2	Maytenus boaria :: Mayten 22	481 Duboce Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		6003596.22484	2108318.99367	37.769245552863495	-122.430883903372	(37.7692455528635, -122.430883903372)
24474	24474	193517	Undocumented 2	Maytenus boaria :: Mayten 22	1600 Bay Shore Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 6ft		6011952.06769	2091431.9694299998	37.7233473149134	-122.400794740685	(37.7233473149134, -122.400794740685)
24511	24511	231737	Undocumented 2	Maytenus boaria :: Mayten 22	1301 Douglass St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 4ft		6001392.41312	2099896.6008200003	37.745994591279796	-122.437903413209	(37.7459945912798, -122.437903413209)
24797	24797	120177	Undocumented 2	Maytenus boaria :: Mayten 22	130 26th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 2ft		5987747.51554	2115102.62556	37.786960769727294	-122.486201131854	(37.7869607697273, -122.486201131854)
25520	25520	185142	Undocumented 2	Maytenus boaria :: Mayten 22	2513 33rd Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 0ft		5986108.0169	2098114.3936	37.7402201189445	-122.49062297943001	(37.7402201189445, -122.49062297943)
26834	26834	209313	Undocumented 2	Maytenus boaria :: Mayten 22	1826 17th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 6ft		5990960.58685	2102941.94344	37.7537575742797	-122.474197079625	(37.7537575742797, -122.474197079625)
27030	27030	185143	Undocumented 2	Maytenus boaria :: Mayten 22	2515 33rd Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 0ft		5986108.0169	2098100.5968	37.7401822366116	-122.490621964597	(37.7401822366116, -122.490621964597)
27903	27903	231769	Undocumented 2	Maytenus boaria :: Mayten 22	4189 26th St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 4ft		6002709.32864	2100612.54197	37.7480351970786	-122.43340085217399	(37.7480351970786, -122.433400852174)
28001	28001	231739	Undocumented 2	Maytenus boaria :: Mayten 22	1125 Douglass St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 6ft		6001361.831259999	2100439.6299099997	37.7474838811735	-122.438048052091	(37.7474838811735, -122.438048052091)
31133	31133	193520	Undocumented 2	Maytenus boaria :: Mayten 22	1600 Bay Shore Blvd	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 6ft		6011963.497280001	2091396.5487400002	37.7232506944377	-122.40075274327101	(37.7232506944377, -122.400752743271)
31939	31939	209228	Undocumented 2	Maytenus boaria :: Mayten 22	56 Evelyn Way	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		5998514.63023	2098457.8445099997	37.74188004722	-122.44775080166201	(37.74188004722, -122.447750801662)
33187	33187	131119	Undocumented 2	Maytenus boaria :: Mayten 22	2628 Broderick St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 4ft		6000183.00251	2117622.17381	37.7945957101685	-122.443358342831	(37.7945957101685, -122.443358342831)
37895	37895	131120	Undocumented 2	Maytenus boaria :: Mayten 22	2628 Broderick St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 4ft		6000180.43791	2117639.7288599997	37.794643765458495	-122.443368478199	(37.7946437654585, -122.443368478199)
38380	38380	209308	Undocumented 2	Maytenus boaria :: Mayten 22	1639 17th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 6ft		5990857.84677	2104245.01196	37.757329504260895	-122.47464747089799	(37.7573295042609, -122.474647470898)
38792	38792	209609	Undocumented 2	Maytenus boaria :: Mayten 22	562 Bright St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			5993802.84348	2090885.4872	37.7208177899974	-122.463493089652	(37.7208177899974, -122.463493089652)
40745	40745	209268	Undocumented 2	Maytenus boaria :: Mayten 22	32 Melrose Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11			5999881.425980001	2095527.25505	37.733911365001795	-122.442814491289	(37.7339113650018, -122.442814491289)
43105	43105	123507	Undocumented 2	Maytenus boaria :: Mayten 22	2630 Fulton St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			5995207.28646	2110317.68378	37.7742545467647	-122.460045421131	(37.7742545467647, -122.460045421131)
43459	43459	209229	Undocumented 2	Maytenus boaria :: Mayten 22	33 Vista Verde Ct	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		5999182.21514	2096030.8365200001	37.735254194030205	-122.445268061295	(37.7352541940302, -122.445268061295)
44434	44434	131140	Undocumented 2	Maytenus boaria :: Mayten 22	2600 Webster St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 4ft		6003103.94403	2117640.65389	37.7948125861925	-122.433252839042	(37.7948125861925, -122.433252839042)
44561	44561	209311	Undocumented 2	Maytenus boaria :: Mayten 22	1832 17th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 6ft		5990964.740730001	2102918.21669	37.7536926674944	-122.474180983568	(37.7536926674944, -122.474180983568)
45839	45839	131081	Undocumented 2	Maytenus boaria :: Mayten 22	5 Emerson St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 1ft		5998643.89609	2113680.41304	37.783684787975105	-122.44839982888901	(37.7836847879751, -122.448399828889)
46948	46948	231738	Undocumented 2	Maytenus boaria :: Mayten 22	1301 Douglass St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		6001390.706780001	2099947.28717	37.7461336669543	-122.43791294333799	(37.7461336669543, -122.437912943338)
48168	48168	209368	Undocumented 2	Maytenus boaria :: Mayten 22	951 Noriega St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 5ft		5991004.55512	2103118.24834	37.7542442082052	-122.474057891556	(37.7542442082052, -122.474057891556)
48975	48975	209610	Undocumented 2	Maytenus boaria :: Mayten 22	562 Bright St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			5993801.59682	2090894.0331	37.720841183149	-122.463498018815	(37.720841183149, -122.463498018815)
51597	51597	209223	Undocumented 2	Maytenus boaria :: Mayten 22	130 Brentwood Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 3ft		5995706.7736599995	2095617.4090900002	37.7339200254769	-122.457253962012	(37.7339200254769, -122.457253962012)
52096	52096	131138	Undocumented 2	Maytenus boaria :: Mayten 22	2600 Webster St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		6003109.50461	2117608.6290700003	37.7947249697315	-122.433231309294	(37.7947249697315, -122.433231309294)

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