Street_Tree_List

Data source: data.sfgov.org

174 rows where qSiteInfo = 9 and qSpecies = 1 sorted by rowid descending

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qCaretaker, DBH, PlotSize

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
189002	189002	186741	Undocumented 2	Myoporum laetum :: Myoporum 1	1200 Sunset Blvd	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 0ft		5984866.449	2106632.432	37.7635357085517	-122.495543856208	(37.7635357085517, -122.495543856208)
188122	188122	184539	Undocumented 2	Myoporum laetum :: Myoporum 1	1939 47th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5981627.7505	2101868.0843	37.7502639852004	-122.50639195948	(37.7502639852004, -122.50639195948)
187019	187019	232344	Undocumented 2	Myoporum laetum :: Myoporum 1	685 29th St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6002211.07877	2098832.45348	37.7431192122771	-122.434996487813	(37.7431192122771, -122.434996487813)
186750	186750	232347	Undocumented 2	Myoporum laetum :: Myoporum 1	683 29th St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6002236.903630001	2098838.13664	37.743136283220004	-122.434907598826	(37.74313628322, -122.434907598826)
186324	186324	194062	Undocumented 2	Myoporum laetum :: Myoporum 1	570 Barneveld Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			6010992.45281	2097208.4358099997	37.7391547075314	-122.404518390821	(37.7391547075314, -122.404518390821)
185068	185068	194059	Undocumented 2	Myoporum laetum :: Myoporum 1	540 Barneveld Ave	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 10ft		6011016.84858	2097513.47253	37.7399936365049	-122.404455506617	(37.7399936365049, -122.404455506617)
184453	184453	131714	Undocumented 2	Myoporum laetum :: Myoporum 1	3250 Pacific Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		5998496.90584	2116567.36238	37.791603184595104	-122.44911640329398	(37.7916031845951, -122.449116403294)
182170	182170	185694	Undocumented 2	Myoporum laetum :: Myoporum 1	2101 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984861.0881	2100529.8889	37.7467794993444	-122.495112367353	(37.7467794993444, -122.495112367353)
182075	182075	186798	Undocumented 2	Myoporum laetum :: Myoporum 1	1200 Sunset Blvd	76	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984847.2394	2106906.9776	37.7642884087703	-122.495630546663	(37.7642884087703, -122.495630546663)
181863	181863	131761	Undocumented 2	Myoporum laetum :: Myoporum 1	24 Priest St	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 10ft		6008326.19973	2117161.77492	37.7937925706325	-122.415149139144	(37.7937925706325, -122.415149139144)
181337	181337	186724	Undocumented 2	Myoporum laetum :: Myoporum 1	1300 Sunset Blvd	58	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5984849.7405	2106204.9407	37.762360958924106	-122.49557011228998	(37.7623609589241, -122.49557011229)
180900	180900	232341	Undocumented 2	Myoporum laetum :: Myoporum 1	689 29th St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25			6002137.6004	2098831.04756	37.7431111795389	-122.435250455448	(37.7431111795389, -122.435250455448)
180202	180202	232328	Undocumented 2	Myoporum laetum :: Myoporum 1	1801 Diamond St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 6ft		6002075.48932	2098744.22684	37.742869262806295	-122.435459009147	(37.7428692628063, -122.435459009147)
180143	180143	194090	Undocumented 2	Myoporum laetum :: Myoporum 1	1 Apparel Way	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14			6011245.93679	2097821.82718	37.740853112271	-122.403685100604	(37.740853112271, -122.403685100604)
179582	179582	131713	Undocumented 2	Myoporum laetum :: Myoporum 1	3250 Pacific Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 3ft		5998501.34187	2116568.43338	37.791606378991	-122.449101131933	(37.791606378991, -122.449101131933)
179465	179465	118837	Undocumented 2	Myoporum laetum :: Myoporum 1	600 46th Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 5ft		5981666.867000001	2111590.99028	37.776962590483606	-122.506977842076	(37.7769625904836, -122.506977842076)
177097	177097	181430	Undocumented 2	Myoporum laetum :: Myoporum 1	1500 Sunset Blvd	63	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984894.5136	2104851.8242	37.7586483004402	-122.495315467353	(37.7586483004402, -122.495315467353)
174939	174939	194054	Undocumented 2	Myoporum laetum :: Myoporum 1	540 Barneveld Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 10ft		6011124.462719999	2097851.3870099997	37.7409274907204	-122.40410719471599	(37.7409274907204, -122.404107194716)
173881	173881	232322	Undocumented 2	Myoporum laetum :: Myoporum 1	1430 Douglass St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 6ft		6001368.29061	2099487.1068599997	37.7448688460173	-122.437957499335	(37.7448688460173, -122.437957499335)
172806	172806	232342	Undocumented 2	Myoporum laetum :: Myoporum 1	687 29th St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25			6002180.92651	2098835.3599099996	37.74312548054821	-122.435100953944	(37.7431254805482, -122.435100953944)
171452	171452	187152	Undocumented 2	Myoporum laetum :: Myoporum 1	2301 Sunset Blvd	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 0ft		5984930.5747	2099438.914	37.7437880464665	-122.494791670453	(37.7437880464665, -122.494791670453)
168081	168081	185107	Undocumented 2	Myoporum laetum :: Myoporum 1	2801 Sunset Blvd	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 0ft		5985026.6173	2095934.5241	37.73417155402829	-122.49420133916	(37.7341715540283, -122.49420133916)
167388	167388	194082	Undocumented 2	Myoporum laetum :: Myoporum 1	495 Barneveld Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 9ft		6011088.380890001	2097569.3881900003	37.7401511662306	-122.404212110497	(37.7401511662306, -122.404212110497)
163978	163978	232291	Undocumented 2	Myoporum laetum :: Myoporum 1	1100 San Jose Ave	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 9ft		6004778.102000001	2096680.6709599998	37.737356328728104	-122.42596726120001	(37.7373563287281, -122.4259672612)
162140	162140	194055	Undocumented 2	Myoporum laetum :: Myoporum 1	540 Barneveld Ave	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 10ft		6011079.14067	2097742.4698	37.740625894958704	-122.404256238443	(37.7406258949587, -122.404256238443)
162072	162072	210516	Undocumented 2	Myoporum laetum :: Myoporum 1	212 Staples Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			32			5998671.88838	2093815.67028	37.7291427269309	-122.44687309392401	(37.7291427269309, -122.446873093924)
161967	161967	186844	Undocumented 2	Myoporum laetum :: Myoporum 1	2034 Lower Great Hwy	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5981219.1453	2101186.094	37.7483673667876	-122.507754314909	(37.7483673667876, -122.507754314909)
161375	161375	194060	Undocumented 2	Myoporum laetum :: Myoporum 1	570 Barneveld Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 10ft		6010992.958459999	2097279.69333	37.73935039371229	-122.404521657152	(37.7393503937123, -122.404521657152)
160287	160287	248281	Undocumented 2	Myoporum laetum :: Myoporum 1	105 Lundy's Ln	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 5ft		6006851.95643	2098931.00797	37.7436522395523	-122.418956528726	(37.7436522395523, -122.418956528726)
160197	160197	232329	Undocumented 2	Myoporum laetum :: Myoporum 1	1801 Diamond St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 6ft		6002075.1191	2098772.01072	37.7429455298129	-122.435462276374	(37.7429455298129, -122.435462276374)
159667	159667	232337	Undocumented 2	Myoporum laetum :: Myoporum 1	691 29th St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13			6002080.83526	2098827.25693	37.743097547618	-122.43544646269501	(37.743097547618, -122.435446462695)
159389	159389	210517	Undocumented 2	Myoporum laetum :: Myoporum 1	212 Staples Ave	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7			5998717.163269999	2093815.2255099998	37.7291440921051	-122.44671654353998	(37.7291440921051, -122.44671654354)
158431	158431	194084	Undocumented 2	Myoporum laetum :: Myoporum 1	465 Barneveld Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6011118.05101	2097667.49352	37.740422200320204	-122.404116425355	(37.7404222003202, -122.404116425355)
157512	157512	232412	Undocumented 2	Myoporum laetum :: Myoporum 1	339 Addison St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		6002143.31914	2097691.88801	37.7399836378403	-122.435149221483	(37.7399836378403, -122.435149221483)
156154	156154	232331	Undocumented 2	Myoporum laetum :: Myoporum 1	1801 Diamond St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 6ft		6002072.189119999	2098811.70513	37.7430543549658	-122.43547524639999	(37.7430543549658, -122.4354752464)
154952	154952	232405	Undocumented 2	Myoporum laetum :: Myoporum 1	3121 Castro St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 2ft		6002909.5481	2095741.7320400001	37.734672437875	-122.432360673818	(37.734672437875, -122.432360673818)
154803	154803	184534	Undocumented 2	Myoporum laetum :: Myoporum 1	1906 47th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5981676.8437	2102069.7342	37.7508205493518	-122.506237145813	(37.7508205493518, -122.506237145813)
152167	152167	184536	Undocumented 2	Myoporum laetum :: Myoporum 1	1918 47th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 0ft		5981680.2279	2102012.5409	37.7506637118715	-122.50622120268801	(37.7506637118715, -122.506221202688)
152113	152113	194080	Undocumented 2	Myoporum laetum :: Myoporum 1	495 Barneveld Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			6011079.10015	2097495.1748	37.739946873549	-122.404238977744	(37.739946873549, -122.404238977744)
151495	151495	194058	Undocumented 2	Myoporum laetum :: Myoporum 1	540 Barneveld Ave	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 10ft		6011019.935319999	2097525.87575	37.7400278655929	-122.40444570672199	(37.7400278655929, -122.404445706722)
150906	150906	184983	Undocumented 2	Myoporum laetum :: Myoporum 1	2701 Sunset Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 0ft		5985011.3339	2096668.7562	37.7361866651853	-122.49430828045601	(37.7361866651853, -122.494308280456)
150167	150167	210559	Undocumented 2	Myoporum laetum :: Myoporum 1	140 Hernandez Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 3ft		5995558.80371	2099639.21584	37.744954417407705	-122.45805649901699	(37.7449544174077, -122.458056499017)
149963	149963	187179	Undocumented 2	Myoporum laetum :: Myoporum 1	2301 Sunset Blvd	41	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 0ft		5984914.0932	2099227.6174	37.7432069184805	-122.494833083055	(37.7432069184805, -122.494833083055)
149768	149768	232345	Undocumented 2	Myoporum laetum :: Myoporum 1	685 29th St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6002209.7238	2098837.9673099997	37.743134275029	-122.435001567189	(37.743134275029, -122.435001567189)
148347	148347	194063	Undocumented 2	Myoporum laetum :: Myoporum 1	1 Flower St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 4ft		6010838.1657	2098339.02807	37.7422504473898	-122.40513143798599	(37.7422504473898, -122.405131437986)
146470	146470	185630	Undocumented 2	Myoporum laetum :: Myoporum 1	2100 Sunset Blvd	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 0ft		5985046.8517	2100330.1165	37.74624185231129	-122.494455300367	(37.7462418523113, -122.494455300367)
141460	141460	110877	Undocumented 2	Myoporum laetum :: Myoporum 1	800 INDIANA ST	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6014913.4	2104437.2	37.7592217202179	-122.391466645187	(37.7592217202179, -122.391466645187)
138402	138402	113117	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
137429	137429	187354	Undocumented 2	Myoporum laetum :: Myoporum 1	2200 Sunset Blvd	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5985070.2132	2099768.1337	37.7447001673089	-122.49433310291401	(37.7447001673089, -122.494333102914)
136974	136974	185882	Undocumented 2	Myoporum laetum :: Myoporum 1	2000 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5985026.8493	2101115.2901	37.7483965544335	-122.494582338742	(37.7483965544335, -122.494582338742)
136891	136891	187355	Undocumented 2	Myoporum laetum :: Myoporum 1	2200 Sunset Blvd	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5985062.7652	2099776.5974	37.744722970464395	-122.494359480034	(37.7447229704644, -122.494359480034)
135456	135456	131715	Undocumented 2	Myoporum laetum :: Myoporum 1	3250 Pacific Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5998491.43186	2116566.313	37.791599990194705	-122.449135267491	(37.7915999901947, -122.449135267491)
135025	135025	210515	Undocumented 2	Myoporum laetum :: Myoporum 1	443 Gennessee St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7			5997431.02942	2094954.3994200001	37.732198438912604	-122.451244915116	(37.7321984389126, -122.451244915116)
133947	133947	210553	Undocumented 2	Myoporum laetum :: Myoporum 1	6 Locksley Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 3ft		5994306.7966	2105015.90747	37.75964542581129	-122.462775658193	(37.7596454258113, -122.462775658193)
133386	133386	181383	Undocumented 2	Myoporum laetum :: Myoporum 1	1500 Sunset Blvd	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 0ft		5984896.421	2104481.2352	37.757630877743395	-122.495281541299	(37.7576308777434, -122.495281541299)
133296	133296	232406	Undocumented 2	Myoporum laetum :: Myoporum 1	391 Beacon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 3ft		6002373.90725	2098189.51858	37.7413631070215	-122.43438751368099	(37.7413631070215, -122.434387513681)
132239	132239	232348	Undocumented 2	Myoporum laetum :: Myoporum 1	683 29th St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23			6002262.62266	2098838.70205	37.743139295941894	-122.43481870982599	(37.7431392959419, -122.434818709826)
131528	131528	186676	Undocumented 2	Myoporum laetum :: Myoporum 1	1401 Sunset Blvd	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984702.3158	2105448.5558	37.76027550382771	-122.496024187798	(37.7602755038277, -122.496024187798)
130847	130847	232339	Undocumented 2	Myoporum laetum :: Myoporum 1	691 29th St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13			6002094.37196	2098830.5273700003	37.7431072962705	-122.435399890387	(37.7431072962705, -122.435399890387)
130581	130581	187395	Undocumented 2	Myoporum laetum :: Myoporum 1	2100 Sunset Blvd	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5985039.3656	2100676.2331	37.7471917561772	-122.494506696584	(37.7471917561772, -122.494506696584)
129592	129592	186830	Undocumented 2	Myoporum laetum :: Myoporum 1	1200 Sunset Blvd	93	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5984826.8059	2106580.9981	37.7633921640535	-122.49567717299999	(37.7633921640535, -122.495677173)
127458	127458	112008	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
125466	125466	110020		Myoporum laetum :: Myoporum 1	1490X Douglass St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				9x9		6001386.81709	2099547.0285	37.745034430207795	-122.437897729467	(37.7450344302078, -122.437897729467)
123490	123490	194051	Undocumented 2	Myoporum laetum :: Myoporum 1	1598 Bay Shore Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 5ft		6011883.611959999	2091657.73213	37.7239633945918	-122.401047236139	(37.7239633945918, -122.401047236139)
122028	122028	186674	Undocumented 2	Myoporum laetum :: Myoporum 1	1401 Sunset Blvd	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5984709.4341	2105459.8614	37.760306962768205	-122.49600040337201	(37.7603069627682, -122.496000403372)
121815	121815	112772	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
121140	121140	112006	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
120329	120329	113129	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
120273	120273	113891	Undocumented 2	Myoporum laetum :: Myoporum 1	1x STORRIE ST	3	Sidewalk: Property side : Yard 9	Tree 1	DPW 2			12			6000722.0	2105303.0	37.76080110933629	-122.440609317727	(37.7608011093363, -122.440609317727)
120079	120079	186675	Undocumented 2	Myoporum laetum :: Myoporum 1	1401 Sunset Blvd	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984701.897000001	2105453.5805	37.760289275720204	-122.496026006908	(37.7602892757202, -122.496026006908)
119719	119719	85507	Permitted Site 1	Myoporum laetum :: Myoporum 1	1 Nebraska St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 49678	6009335.0	2098038.0	37.7413397420659	-122.410307693317	(37.7413397420659, -122.410307693317)
117949	117949	98373	Undocumented 2	Myoporum laetum :: Myoporum 1	701@ de Soto Urbano Dr	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5993201.0	2091808.0	37.7233160913053	-122.46564044909799	(37.7233160913053, -122.465640449098)
117009	117009	112004	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
115212	115212	112774	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
113702	113702	112010	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
112482	112482	112773	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
111811	111811	112770	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
111205	111205	112771	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
109839	109839	113123	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
109788	109788	113131	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
107866	107866	112769	Significant Tree 6	Myoporum laetum :: Myoporum 1	1X HOWTH ST	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		5998027.0	2091524.0	37.722813474972206	-122.44893750468901	(37.7228134749722, -122.448937504689)
106681	106681	97654	Permitted Site 1	Myoporum laetum :: Myoporum 1	2331 47th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5981707.8	2099208.6	37.7429664967596	-122.505917998204	(37.7429664967596, -122.505917998204)
105502	105502	98375	Undocumented 2	Myoporum laetum :: Myoporum 1	106 De Soto St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5993231.0	2091825.0	37.7233644995117	-122.465537980019	(37.7233644995117, -122.465537980019)
100041	100041	113128	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
99055	99055	98374	Undocumented 2	Myoporum laetum :: Myoporum 1	106 De Soto St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5993231.0	2091825.0	37.7233644995117	-122.465537980019	(37.7233644995117, -122.465537980019)
95977	95977	112005	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
95231	95231	113127	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
94966	94966	113130	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
93993	93993	112012	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
90475	90475	112007	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
88545	88545	113118	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
84128	84128	112015	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
82981	82981	110866	Undocumented 2	Myoporum laetum :: Myoporum 1	800 INDIANA ST	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6014913.4	2104437.2	37.7592217202179	-122.391466645187	(37.7592217202179, -122.391466645187)
82974	82974	113119	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
82492	82492	112009	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
81845	81845	113126	Undocumented 2	Myoporum laetum :: Myoporum 1	1x TOMASO CT	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1						6009323.0	2086334.0	37.70920235104	-122.40952334552	(37.70920235104, -122.40952334552)
81019	81019	112013	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
80283	80283	112014	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
78648	78648	112011	Undocumented 2	Myoporum laetum :: Myoporum 1	115 Red Rock Way		Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6000032.1	2099934.7	37.7460217534147	-122.442609914587	(37.7460217534147, -122.442609914587)
77363	77363	185742	Undocumented 2	Myoporum laetum :: Myoporum 1	2120 Lower Great Hwy	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 0ft		5981267.7362	2100613.3105	37.7467975267188	-122.507543797463	(37.7467975267188, -122.507543797463)

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