Street_Tree_List

Data source: data.sfgov.org

101 rows where qSiteInfo = 2 and qSpecies = 39 sorted by qSiteInfo

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, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo ▼	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
22882	22882	176369	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5990491.08034	2089186.3269	37.7159609464097	-122.47481676917101	(37.7159609464097, -122.474816769171)
24101	24101	141230	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	16 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 0ft		5996536.7759	2114447.1732	37.7856694107907	-122.45574506618999	(37.7856694107907, -122.45574506619)
26599	26599	176373	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Higuera Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5987816.39494	2090204.8052400001	37.7186020727071	-122.484136269073	(37.7186020727071, -122.484136269073)
28355	28355	209122	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	90 Terrace Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 8ft		5993231.35441	2096936.94625	37.7374006626082	-122.465908015739	(37.7374006626082, -122.465908015739)
29057	29057	209157	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	521 Dewey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 4ft		5994454.52173	2099702.14157	37.7450636850368	-122.46187943880501	(37.7450636850368, -122.461879438805)
29776	29776	209070	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	10 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 8ft		5992811.17187	2096755.1283099998	37.7368771879369	-122.467347553363	(37.7368771879369, -122.467347553363)
30600	30600	209174	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	130 Vasquez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5995008.0039099995	2099582.10642	37.744765946497395	-122.45995691488399	(37.7447659464974, -122.459956914884)
31873	31873	209098	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	65 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 10ft		5993139.75731	2097020.83026	37.7376257026686	-122.46623080131201	(37.7376257026686, -122.466230801312)
34858	34858	209121	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	90 Terrace Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5993204.42935	2096950.74721	37.7374370033165	-122.466002110005	(37.7374370033165, -122.466002110005)
35071	35071	176378	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Crespi Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			5989827.05129	2090325.18948	37.7190494782331	-122.477195118066	(37.7190494782331, -122.477195118066)
36237	36237	141232	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	16 COMMONWEALTH AVE	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 0ft		5996537.7911	2114467.1401	37.785724292831205	-122.45574299774201	(37.7857242928312, -122.455742997742)
36449	36449	176377	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Crespi Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989839.20092	2090334.4554299999	37.7190756251255	-122.47715379871201	(37.7190756251255, -122.477153798712)
36881	36881	223951	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	340 Hill St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 3ft		6004063.3586099995	2103367.27048	37.7556757625498	-122.42891503560101	(37.7556757625498, -122.428915035601)
39210	39210	183101	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	2247 44th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 0ft		5982633.8386	2099812.9726	37.7446804014496	-122.502760792038	(37.7446804014496, -122.502760792038)
44468	44468	176364	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Font Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5988874.21496	2090711.48965	37.720054833031504	-122.480516928613	(37.7200548330315, -122.480516928613)
44548	44548	209097	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	75 Terrace Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 10ft		5993169.259380001	2097009.2167200001	37.73759551693	-122.46612795573401	(37.73759551693, -122.466127955734)
45086	45086	209100	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	45 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 10ft		5993050.40784	2097059.35291	37.737726320615295	-122.466542521627	(37.7377263206153, -122.466542521627)
46492	46492	209168	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	380 Santa Clara Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		5993162.82145	2095507.94879	37.7334730381415	-122.466041155002	(37.7334730381415, -122.466041155002)
46808	46808	209073	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	44 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5992818.00248	2096487.9953	37.736144101953705	-122.467304518983	(37.7361441019537, -122.467304518983)
47117	47117	191814	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1301 Iowa St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 9ft		6014800.46205	2101999.0803099996	37.752520895829704	-122.391686773025	(37.7525208958297, -122.391686773025)
49945	49945	209129	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1301 Monterey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 2ft		5993935.3367099995	2094440.81242	37.7305874815164	-122.463292961705	(37.7305874815164, -122.463292961705)
53277	53277	209085	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	59 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 8ft		5992858.20265	2096383.97186	37.7358608002304	-122.467157970863	(37.7358608002304, -122.467157970863)
53417	53417	176367	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Font Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989068.70923	2090618.6052	37.7198110969962	-122.479837842465	(37.7198110969962, -122.479837842465)
53581	53581	209118	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	76 Terrace Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 8ft		5993106.35008	2096996.92574	37.737558139292496	-122.466344568258	(37.7375581392925, -122.466344568258)
56328	56328	209096	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	75 Terrace Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 10ft		5993182.75005	2097001.00828	37.737573756928704	-122.466080716148	(37.7375737569287, -122.466080716148)
57010	57010	209173	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	130 Vasquez Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5995020.213380001	2099592.15125	37.7447942292845	-122.459915424663	(37.7447942292845, -122.459915424663)
62098	62098	209094	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	75 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 10ft		5993230.22388	2096977.09272	37.7375108295553	-122.46591484071999	(37.7375108295553, -122.46591484072)
63819	63819	209077	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	80 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 8ft		5992829.98097	2096209.69662	37.7353806548989	-122.467242875858	(37.7353806548989, -122.467242875858)
65700	65700	209116	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	70 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 8ft		5993046.10779	2097021.5110900002	37.7376221683219	-122.46655463910601	(37.7376221683219, -122.466554639106)
65993	65993	176371	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Higuera Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25			5988051.57077	2090189.21329	37.7185729508586	-122.483322229739	(37.7185729508586, -122.483322229739)
68765	68765	209115	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	60 Terrace Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 8ft		5992995.34172	2097045.2669	37.737684466160204	-122.46673188647101	(37.7376844661602, -122.466731886471)
69020	69020	223950	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	340 Hill St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 3ft		6004077.1812	2103371.12291	37.755687122789205	-122.428867507344	(37.7556871227892, -122.428867507344)
69206	69206	209103	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	15 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 10ft		5992879.73609	2097124.3206200001	37.7378948553616	-122.467137333221	(37.7378948553616, -122.467137333221)
70613	70613	209087	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	55 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		5992856.63194	2096437.26886	37.736007049788704	-122.467167275266	(37.7360070497887, -122.467167275266)
70717	70717	209114	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	60 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 8ft		5992971.46744	2097053.64685	37.7377060975485	-122.46681503960801	(37.7377060975485, -122.466815039608)
71372	71372	209061	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	171 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5992890.94183	2095521.3505	37.733494147032204	-122.466982085951	(37.7334941470322, -122.466982085951)
71655	71655	176365	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5988916.46599	2090663.1949	37.719924683163	-122.48036734976999	(37.719924683163, -122.48036734977)
73304	73304	209065	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	121 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 6ft		5992878.20521	2095835.4004	37.734355714635	-122.467048944268	(37.734355714635, -122.467048944268)
73442	73442	209080	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	98 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 8ft		5992832.63855	2096096.07642	37.73506883564	-122.467225429034	(37.73506883564, -122.467225429034)
75369	75369	176363	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1			5988462.773440001	2091307.9607099998	37.7216686718604	-122.48198279658399	(37.7216686718604, -122.481982796584)
77191	77191	246720	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	75 Stoneman St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20			6007960.82991	2099365.47292	37.744907561828796	-122.4151530494	(37.7449075618288, -122.4151530494)
77198	77198	209113	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	50 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 8ft		5992942.6051900005	2097065.59795	37.7377372464705	-122.466915698004	(37.7377372464705, -122.466915698004)
105824	105824	97405	Permitted Site 1	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	2@Melrose Stanford Heights Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5997807.0	2095590.8	37.7339673631019	-122.449990957178	(37.7339673631019, -122.449990957178)
106017	106017	209076	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	72 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			29	Width 8ft		5992829.94539	2096272.0071299998	37.7355517419246	-122.46724752805599	(37.7355517419246, -122.467247528056)
122538	122538	209074	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	50 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 8ft		5992822.11698	2096443.68963	37.7360226871991	-122.46728707303998	(37.7360226871991, -122.46728707304)
129927	129927	118433	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	5428 Anza St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5981776.05342	2111693.4588	37.7772503684982	-122.506607740669	(37.7772503684982, -122.506607740669)
130515	130515	209153	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	2055 15th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5991594.695280001	2101440.3078900003	37.7496711879902	-122.471894774741	(37.7496711879902, -122.471894774741)
131243	131243	209059	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	185 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 6ft		5992893.88579	2095426.8889	37.733234948915	-122.466965042926	(37.733234948915, -122.466965042926)
131441	131441	209109	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	20 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 8ft		5992839.23365	2097100.85906	37.7378280977834	-122.467275663335	(37.7378280977834, -122.467275663335)
134202	134202	209072	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	40 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			26	Width 8ft		5992817.92295	2096532.21615	37.7362655167426	-122.46730800837601	(37.7362655167426, -122.467308008376)
134654	134654	176370	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Serrano Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			5989286.45825	2090675.21625	37.7199791847779	-122.47908930795299	(37.7199791847779, -122.479089307953)
134960	134960	176366	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Font Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5989001.162169999	2090698.46083	37.720026436042104	-122.48007716733801	(37.7200264360421, -122.480077167338)
135360	135360	209091	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	11 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 8ft		5992847.612919999	2096680.3290099998	37.73667391147	-122.467216124638	(37.73667391147, -122.467216124638)
135536	135536	209099	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	65 Terrace Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 10ft		5993121.532430001	2097029.1529400002	37.7376475031269	-122.466294417565	(37.7376475031269, -122.466294417565)
135618	135618	209130	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1301 Monterey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 2ft		5993944.42117	2094433.5464700002	37.7305680543596	-122.463261028572	(37.7305680543596, -122.463261028572)
136145	136145	176368	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Font Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5990356.63176	2089404.5642	37.7165523801656	-122.475297405564	(37.7165523801656, -122.475297405564)
147746	147746	209090	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	27 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			28	Width 8ft		5992850.22267	2096580.44618	37.7363998088905	-122.467199841512	(37.7363998088905, -122.467199841512)
147886	147886	209120	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	90 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 8ft		5993178.7234	2096962.31698	37.737467287994	-122.466091827272	(37.737467287994, -122.466091827272)
147984	147984	247210	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	800 Duboce Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		6001850.29311	2108285.87334	37.769055534222105	-122.4369206089	(37.7690555342221, -122.4369206089)
148257	148257	209089	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	35 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 8ft		5992853.3988	2096539.5102400002	37.736287592393104	-122.46718588491899	(37.7362875923931, -122.467185884919)
149743	149743	209111	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	40 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 8ft		5992898.316380001	2097081.33965	37.737777912909706	-122.46706996861799	(37.7377779129097, -122.467069968618)
150063	150063	209112	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	40 Terrace Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 8ft		5992916.53006	2097074.65439	37.7377606081685	-122.467006509758	(37.7377606081685, -122.467006509758)
150560	150560	209119	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	80 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 8ft		5993141.78233	2096981.37016	37.7375174719512	-122.46622093306999	(37.7375174719512, -122.46622093307)
151804	151804	176362	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Font Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24			5988643.66331	2091104.1894200002	37.721119686105204	-122.481342600695	(37.7211196861052, -122.481342600695)
152016	152016	176376	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Higuera Ave	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5988039.38583	2090061.01718	37.718220247544295	-122.48335495517901	(37.7182202475443, -122.483354955179)
152368	152368	209081	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	95 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 8ft		5992864.70303	2096101.09713	37.7350844721621	-122.467114936514	(37.7350844721621, -122.467114936514)
155497	155497	246721	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	75 Stoneman St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10			6007902.05533	2099361.90416	37.7448944596047	-122.41535602906299	(37.7448944596047, -122.415356029063)
155857	155857	176374	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Higuera Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			5987703.71079	2090081.0974	37.7182558409022	-122.484516698486	(37.7182558409022, -122.484516698486)
156147	156147	124032	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	101 Funston Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 3ft		5991771.96751	2114630.64517	37.7858985750562	-122.47224315657199	(37.7858985750562, -122.472243156572)
156481	156481	141231	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	16 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 0ft		5996537.4527	2114457.3259	37.7856973262365	-122.455743458825	(37.7856973262365, -122.455743458825)
157441	157441	209095	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	75 Terrace Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 10ft		5993204.45765	2096991.37603	37.737548561523106	-122.466004963577	(37.7375485615231, -122.466004963577)
159744	159744	209075	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	58 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 8ft		5992824.51894	2096365.9199400002	37.7358092897541	-122.46727311557501	(37.7358092897541, -122.467273115575)
160135	160135	209110	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	30 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			27	Width 8ft		5992861.57264	2097094.7172	37.7378125233288	-122.467197980806	(37.7378125233288, -122.467197980806)
162663	162663	246718	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	75 Stoneman St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			6007936.82718	2099363.37967	37.7449004652897	-122.41523589851101	(37.7449004652897, -122.415235898511)
164032	164032	176372	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Higuera Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19			5987824.6755800005	2090204.62965	37.718602072697	-122.484107633763	(37.718602072697, -122.484107633763)
165292	165292	209104	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	15 Terrace Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			19	Width 10ft		5992865.41263	2097128.59177	37.737905756055795	-122.467187166468	(37.7379057560558, -122.467187166468)
165772	165772	176375	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	0 Higuera Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5987721.45465	2090080.7210900001	37.7182558409234	-122.48445533866399	(37.7182558409234, -122.484455338664)
167601	167601	209102	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	33 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 10ft		5992948.52969	2097099.97143	37.737831969365295	-122.466897712478	(37.7378319693653, -122.466897712478)
170822	170822	209082	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	95 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 8ft		5992865.0004	2096131.2408900002	37.7351672565617	-122.46711609932301	(37.7351672565617, -122.467116099323)
172164	172164	209062	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	155 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 6ft		5992885.28528	2095649.09727	37.73384458135	-122.467010926309	(37.73384458135, -122.467010926309)
172578	172578	209093	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	9 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 8ft		5992843.15987	2096772.54539	37.7369268574781	-122.46723822367599	(37.7369268574781, -122.467238223676)
173514	173514	209064	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	145 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 6ft		5992884.00475	2095714.4482099998	37.7340239448325	-122.46702010298901	(37.7340239448325, -122.467020102989)
175539	175539	223937	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	104 Appleton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6005739.63861	2096990.5696	37.738261535936104	-122.42266479414101	(37.7382615359361, -122.422664794141)
175778	175778	247211	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	800 Duboce Ave	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		6001837.76454	2108286.1140099997	37.769055482952105	-122.43696396161998	(37.7690554829521, -122.43696396162)
175917	175917	247206	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	800 Duboce Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		6001887.4156	2108287.94496	37.7690633322277	-122.436792352994	(37.7690633322277, -122.436792352994)
176514	176514	185800	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	2840 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5986119.1838	2101655.0773	37.7499425361402	-122.490844835828	(37.7499425361402, -122.490844835828)
177383	177383	209086	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	55 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 8ft		5992858.25535	2096418.47498	37.73595554020729	-122.46716029650601	(37.7359555402073, -122.467160296506)
178638	178638	209079	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	98 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22	Width 8ft		5992829.37061	2096132.65975	37.7351690956763	-122.467239386499	(37.7351690956763, -122.467239386499)
178853	178853	209108	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	10 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			25	Width 8ft		5992797.09947	2097113.71953	37.737860977008204	-122.46742227533701	(37.7378609770082, -122.467422275337)
178895	178895	246717	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	75 Stoneman St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22			6007910.84481	2099371.86455	37.744922302618605	-122.415326341557	(37.7449223026186, -122.415326341557)
180485	180485	209092	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	9 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 8ft		5992848.76038	2096734.90848	37.7368238392542	-122.46721612464898	(37.7368238392542, -122.467216124649)
181723	181723	209078	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	90 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20	Width 8ft		5992828.68908	2096180.2439	37.735299710516294	-122.467245201527	(37.7352997105163, -122.467245201527)
183367	183367	209083	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	77 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			23	Width 8ft		5992864.37636	2096243.2311	37.7354747176693	-122.46712639658399	(37.7354747176693, -122.467126396584)
183623	183623	209084	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	65 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 8ft		5992862.39854	2096311.52421	37.735662119307605	-122.46713819837	(37.7356621193076, -122.46713819837)
184109	184109	209117	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	76 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 8ft		5993090.00755	2097002.31121	37.7375719834621	-122.466401462951	(37.7375719834621, -122.466401462951)
184431	184431	209060	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	183 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 6ft		5992891.23985	2095499.4437900002	37.7334340138624	-122.46697946353599	(37.7334340138624, -122.466979463536)
184993	184993	209088	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	45 San Benito Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 8ft		5992854.12284	2096493.9359099998	37.736162498488	-122.46718006902901	(37.736162498488, -122.467180069029)
185066	185066	209063	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	145 San Benito Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		5992885.628190001	2095683.4514799998	37.7339389292425	-122.46701223754299	(37.7339389292425, -122.467012237543)
185135	185135	209101	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	39 Terrace Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			24	Width 10ft		5992993.86879	2097083.139	37.73778836844421	-122.466739731251	(37.7377883684442, -122.466739731251)
186370	186370	209169	Undocumented 2	Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39	1515 Monterey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			41	Width 3ft		5993415.21245	2095219.88028	37.7326966309271	-122.465147658735	(37.7326966309271, -122.465147658735)

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