Street_Tree_List

Data source: data.sfgov.org

556 rows where qSiteInfo = 9 and qSpecies = 47 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, PlotSize, PermitNotes

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
188957	188957	186755	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200 Sunset Blvd	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 0ft		5984869.1172	2106699.1363	37.763719016073104	-122.495539548031	(37.7637190160731, -122.495539548031)
188106	188106	205877	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1337 Portola Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 3ft		5993571.02759	2097763.88788	37.7396908266808	-122.464793651423	(37.7396908266808, -122.464793651423)
187759	187759	187201	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2301 Sunset Blvd	63	Sidewalk: Property side : Yard 9	Tree 1	Private 1			50	Width 0ft		5984911.8709	2099008.3578	37.742604760863294	-122.494824604589	(37.7426047608633, -122.494824604589)
187491	187491	185577	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2201 Sunset Blvd	61	Sidewalk: Property side : Yard 9	Tree 1	Private 1			43	Width 0ft		5984876.2578	2099639.0685	37.7443344368575	-122.4949942382	(37.7443344368575, -122.4949942382)
187359	187359	186164	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1700 Sunset Blvd	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984969.5188	2103423.199	37.754730082816295	-122.49495073100701	(37.7547300828163, -122.494950731007)
186923	186923	186140	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1700 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984976.0967	2103251.4805	37.7542589762797	-122.494915322593	(37.7542589762797, -122.494915322593)
186893	186893	187048	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2501 Sunset Blvd	67	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984981.0582	2097651.451	37.738883110049706	-122.494485373526	(37.7388831100497, -122.494485373526)
186814	186814	187163	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2301 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			45	Width 0ft		5984895.2042	2099383.9139	37.743634960627496	-122.494909916988	(37.7436349606275, -122.494909916988)
186777	186777	185153	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2500 Sunset Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985133.3579	2097569.1313	37.7386659945279	-122.49395273452299	(37.7386659945279, -122.493952734523)
186743	186743	223811	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	80 Digby St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			49	Width 7ft		6002713.41805	2097728.02904	37.7401152293236	-122.433180638776	(37.7401152293236, -122.433180638776)
186593	186593	185679	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2101 Sunset Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			44	Width 0ft		5984848.3389	2100716.8784	37.747292175118496	-122.49517023896601	(37.7472921751185, -122.495170238966)
186424	186424	184800	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	61	Sidewalk: Property side : Yard 9	Tree 1	Private 1			64	Width 0ft		5984686.2732	2105775.8403	37.76117319587821	-122.496103817218	(37.7611731958782, -122.496103817218)
186330	186330	186414	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984773.6035	2104227.8714	37.7569280195247	-122.49568759978001	(37.7569280195247, -122.49568759978)
186276	186276	186413	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1601 Sunset Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			64	Width 0ft		5984739.2681	2104238.7582	37.75695590087879	-122.495807145737	(37.7569559008788, -122.495807145737)
186232	186232	205900	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	106 Miraloma Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		5994506.11445	2097146.60332	37.7380497842769	-122.461515803309	(37.7380497842769, -122.461515803309)
186173	186173	186341	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984771.9036	2102828.9064	37.7530867492181	-122.49559029679199	(37.7530867492181, -122.495590296792)
186166	186166	181496	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1400 Sunset Blvd	56	Sidewalk: Property side : Yard 9	Tree 1	Private 1			34	Width 0ft		5984867.2226	2105416.0239	37.7601958376586	-122.495451461713	(37.7601958376586, -122.495451461713)
185755	185755	205895	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	110 Cresta Vista Dr	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 3ft		5995734.854669999	2096206.24435	37.7355384364582	-122.457199459482	(37.7355384364582, -122.457199459482)
185648	185648	185953	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2001 Sunset Blvd	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			69	Width 0ft		5984818.0255	2101428.1429	37.7492433382305	-122.49532750509199	(37.7492433382305, -122.495327505092)
185428	185428	205905	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	125 Hamerton Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			51	Width 4ft		6001385.86644	2095459.79202	37.7338117803923	-122.437608363645	(37.7338117803923, -122.437608363645)
185332	185332	185887	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2000 Sunset Blvd	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			56	Width 0ft		5985024.6397	2101148.4339	37.748487428935	-122.494592422422	(37.748487428935, -122.494592422422)
185047	185047	185699	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2101 Sunset Blvd	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			49	Width 0ft		5984860.4343	2100518.1203	37.7467471477001	-122.495113760419	(37.7467471477001, -122.495113760419)
185031	185031	190987	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	100 Topeka Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		6012468.98817	2095242.94143	37.7338402790006	-122.39927522817	(37.7338402790006, -122.39927522817)
184882	184882	223774	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	615 Sanchez St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			53	Width 3ft		6003694.6697	2104650.23962	37.759177615567296	-122.43028160673201	(37.7591776155673, -122.430281606732)
184682	184682	223747	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	526 Duncan St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			31	Width 3ft		6003046.91412	2099810.87444	37.7458531522163	-122.432176253431	(37.7458531522163, -122.432176253431)
184555	184555	186200	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			70	Width 0ft		5984778.3318	2103452.7061	37.754799907325605	-122.49561407416701	(37.7547999073256, -122.495614074167)
184501	184501	181442	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1400 Sunset Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984907.8806	2105046.76	37.7591843225176	-122.495283614644	(37.7591843225176, -122.495283614644)
184471	184471	187407	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2100 Sunset Blvd	60	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985024.7009	2100846.8762	37.747659437344204	-122.49456998306101	(37.7476594373442, -122.494569983061)
184027	184027	185994	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2001 Sunset Blvd	53	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5984830.686000001	2100989.8439	37.7480406303286	-122.49525140725001	(37.7480406303286, -122.49525140725)
183983	183983	186607	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 Sunset Blvd	78	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984762.1933	2104423.9388	37.757465697935096	-122.495741522143	(37.7574656979351, -122.495741522143)
183860	183860	186109	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	55	Sidewalk: Property side : Yard 9	Tree 1	Private 1			57	Width 0ft		5984840.4659	2101628.7594	37.7497954900583	-122.495264699643	(37.7497954900583, -122.495264699643)
183726	183726	205911	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	198 Mangels Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			51			6000172.88009	2095259.68329	37.733193286925996	-122.441787651691	(37.733193286926, -122.441787651691)
183704	183704	186061	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 0ft		5984814.7269	2102156.8472	37.751243967202896	-122.495392646831	(37.7512439672029, -122.495392646831)
183650	183650	185948	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2001 Sunset Blvd	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 0ft		5984838.4114	2101503.1034	37.74945035282	-122.495262538639	(37.74945035282, -122.495262538639)
183624	183624	205888	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	300 Hazelwood Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 3ft		5996225.80911	2095294.3314200002	37.733062728758505	-122.455436166843	(37.7330627287585, -122.455436166843)
183441	183441	185627	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2100 Sunset Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			87	Width 0ft		5985046.4186	2100324.9202	37.7462275593372	-122.494456414967	(37.7462275593372, -122.494456414967)
183409	183409	186360	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984814.757999999	2102602.0458	37.7524663619043	-122.495425370042	(37.7524663619043, -122.495425370042)
182493	182493	185683	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2101 Sunset Blvd	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			54	Width 0ft		5984892.471	2100629.5948	37.7470551018081	-122.49501120069999	(37.7470551018081, -122.4950112007)
182419	182419	187231	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2401 Sunset Blvd	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984940.0793	2098640.1078	37.7415952970055	-122.49469992638001	(37.7415952970055, -122.49469992638)
182159	182159	181511	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1400 Sunset Blvd	71	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 0ft		5984874.1846	2105548.3017	37.7605594432249	-122.495437139743	(37.7605594432249, -122.495437139743)
182008	182008	223760	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	5735 Diamond Heights Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 8ft		6000715.37701	2097028.89046	37.7380820132743	-122.44003891457899	(37.7380820132743, -122.440038914579)
181646	181646	187045	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2501 Sunset Blvd	64	Sidewalk: Property side : Yard 9	Tree 1	Private 1			61	Width 0ft		5984969.2884	2097687.4331	37.7389812183872	-122.494528719258	(37.7389812183872, -122.494528719258)
181209	181209	223741	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	600 Alvarado St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			57	Width 10ft		6002372.47353	2102685.98683	37.753709268083895	-122.434713928899	(37.7537092680839, -122.434713928899)
180949	180949	205903	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	110 Kensington Way	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 3ft		5994961.52752	2098342.73028	37.7413602552605	-122.460027852509	(37.7413602552605, -122.460027852509)
180925	180925	186084	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5984861.6365	2101880.8765	37.7504889739788	-122.49521008166	(37.7504889739788, -122.49521008166)
180824	180824	223748	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	460 Beacon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			31			6002280.901380001	2098490.25327	37.742183574702395	-122.43473059513799	(37.7421835747024, -122.434730595138)
180772	180772	186089	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			72	Width 0ft		5984838.8917	2101823.6441	37.750330497842995	-122.49528451351001	(37.750330497843, -122.49528451351)
180706	180706	184052	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1600 Sunset Blvd	53	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 0ft		5984937.3498	2103855.5949	37.7559154391845	-122.49509386136101	(37.7559154391845, -122.495093861361)
180433	180433	126428	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 North Point St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		6002587.87385	2120898.67704	37.803728977572604	-122.43527166598	(37.8037289775726, -122.43527166598)
180182	180182	186931	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2800 Sunset Blvd	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			28	Width 0ft		5985210.3719	2095929.9944	37.7341698678439	-122.49356571698799	(37.7341698678439, -122.493565716988)
180115	180115	187140	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2301 Sunset Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984921.9385	2099490.838	37.7439301101756	-122.494825359501	(37.7439301101756, -122.494825359501)
179874	179874	186060	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			90	Width 0ft		5984837.0831	2102159.5408	37.7512526720721	-122.49531553640101	(37.7512526720721, -122.495315536401)
179404	179404	223742	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	921 Alvarado St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			42	Width 8ft		6000348.4325	2102535.54442	37.753181072867	-122.441702702621	(37.753181072867, -122.441702702621)
178626	178626	223814	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	47 Harry St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			33	Width 10ft		6003303.1448800005	2097708.7253900003	37.740095661872	-122.43114022723499	(37.740095661872, -122.431140227235)
178161	178161	186708	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1401 Sunset Blvd	65	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984718.4366	2105053.49	37.7591917076208	-122.49593928954901	(37.7591917076208, -122.495939289549)
177404	177404	181475	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1400 Sunset Blvd	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 0ft		5984869.4504	2105277.3411	37.75981518382329	-122.49543352861299	(37.7598151838233, -122.495433528613)
176897	176897	186982	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2501 Sunset Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			35	Width 0ft		5984958.5274	2098137.713	37.7402169360885	-122.49459911154499	(37.7402169360885, -122.494599111545)
176454	176454	184779	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			55	Width 0ft		5984701.0822	2105928.8672	37.7615942322964	-122.496063889935	(37.7615942322964, -122.496063889935)
176055	176055	186244	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1701 Sunset Blvd	55	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984769.2252	2103216.605	37.754151105704295	-122.495628153173	(37.7541511057043, -122.495628153173)
176054	176054	223701	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 9ft		6004786.9856	2096684.12369	37.7373663112035	-122.425936792158	(37.7373663112035, -122.425936792158)
175707	175707	206835	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	375 Casitas Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 5ft		5995050.15142	2095828.17097	37.7344609919799	-122.459539348883	(37.7344609919799, -122.459539348883)
175698	175698	205893	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1110 Teresita Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 3ft		5998235.76076	2095666.83858	37.734200671531504	-122.448514080556	(37.7342006715315, -122.448514080556)
175582	175582	187210	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2301 Sunset Blvd	72	Sidewalk: Property side : Yard 9	Tree 1	Private 1			40	Width 0ft		5984940.3895	2098925.3948	37.742378636211	-122.494719881886	(37.742378636211, -122.494719881886)
175546	175546	185684	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2101 Sunset Blvd	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			34	Width 0ft		5984861.742000001	2100618.807	37.7470236824891	-122.495116662039	(37.7470236824891, -122.495116662039)
175401	175401	185622	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2100 Sunset Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5985035.4121	2100280.3783	37.7461046152286	-122.494491190588	(37.7461046152286, -122.494491190588)
175190	175190	186383	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1801 Sunset Blvd	50	Sidewalk: Property side : Yard 9	Tree 1	Private 1			47	Width 0ft		5984821.7301	2102416.5017	37.751957317115895	-122.49538757696999	(37.7519573171159, -122.49538757697)
175066	175066	186302	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1800 Sunset Blvd	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 0ft		5984990.1286	2102749.3532	37.7528810944721	-122.49482977812	(37.7528810944721, -122.49482977812)
174966	174966	185935	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2000 Sunset Blvd	78	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985034.4441	2101527.1648	37.7495278943342	-122.494586435864	(37.7495278943342, -122.494586435864)
174648	174648	223764	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	126 Bradford St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6009530.67949	2097860.55808	37.7408634922583	-122.40961857835899	(37.7408634922583, -122.409618578359)
174210	174210	205916	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	506 Congo St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 5ft		6000130.425	2095272.3934400002	37.73322576685489	-122.44193534195401	(37.7332257668549, -122.441935341954)
174207	174207	184747	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			54	Width 0ft		5984699.9431	2106151.5726	37.7622056521899	-122.496084260471	(37.7622056521899, -122.496084260471)
174021	174021	206805	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	68 Aerial Way	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 2ft		5992337.85259	2102586.3377799997	37.752860862941205	-122.469408341716	(37.7528608629412, -122.469408341716)
172875	172875	223813	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	80 Digby St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			46	Width 10ft		6002637.262130001	2097732.72749	37.740123809771	-122.43344429032301	(37.740123809771, -122.433444290323)
172674	172674	223806	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	177 Moffitt St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		6002417.80157	2097060.2548599998	37.7382649020917	-122.434155033533	(37.7382649020917, -122.434155033533)
172394	172394	185209	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2500 Sunset Blvd	62	Sidewalk: Property side : Yard 9	Tree 1	Private 1			38	Width 0ft		5985139.3342	2098053.216	37.73999551086	-122.493967737883	(37.73999551086, -122.493967737883)
172361	172361	186738	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200 Sunset Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 0ft		5984873.2407	2106599.9288	37.7634468615844	-122.495517968799	(37.7634468615844, -122.495517968799)
171960	171960	205890	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	25 Stanford Heights Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		5997823.46765	2095740.1408099998	37.7343783595712	-122.449944783251	(37.7343783595712, -122.449944783251)
171921	171921	184062	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1600 Sunset Blvd	63	Sidewalk: Property side : Yard 9	Tree 1	Private 1			55	Width 0ft		5984941.4086	2103928.0299	37.7561145632567	-122.49508516598499	(37.7561145632567, -122.495085165985)
171399	171399	184735	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1301 Sunset Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			99	Width 0ft		5984680.1977	2106291.6891	37.7625892162308	-122.496162889393	(37.7625892162308, -122.496162889393)
171054	171054	206834	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	375 Casitas Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 5ft		5995064.96816	2095832.8748700002	37.7344747596986	-122.45948846344	(37.7344747596986, -122.45948846344)
170927	170927	181465	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1400 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 0ft		5984920.1337	2105218.8604	37.7596575796755	-122.495253929823	(37.7596575796755, -122.495253929823)
170557	170557	223763	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	126 Bradford St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		6009530.79254	2097866.09723	37.740878707894296	-122.409618578334	(37.7408787078943, -122.409618578334)
169563	169563	223779	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	731 Noe St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 3ft		6003094.682440001	2103994.83983	37.7573440418231	-122.43230984055201	(37.7573440418231, -122.432309840552)
168711	168711	187185	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2301 Sunset Blvd	47	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 0ft		5984955.2043	2099180.2099	37.7430791567104	-122.49468743945299	(37.7430791567104, -122.494687439453)
168655	168655	223734	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	4379 Cesar Chavez St	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 4ft		6001460.85322	2100259.68732	37.7469954324125	-122.43769275603901	(37.7469954324125, -122.437692756039)
168086	168086	187007	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2501 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 0ft		5984985.2617	2098061.8817	37.740010288446705	-122.494501087771	(37.7400102884467, -122.494501087771)
168039	168039	184986	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2701 Sunset Blvd	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5985020.5458	2096630.2336	37.7360814314996	-122.494273593011	(37.7360814314996, -122.494273593011)
168002	168002	118630	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	349 Point Lobos Ave	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			5981637.79887	2112651.0038099997	37.7798713628306	-122.507157052361	(37.7798713628306, -122.507157052361)
167901	167901	185517	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2201 Sunset Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			56	Width 0ft		5984884.6253	2100174.2165	37.745804297711395	-122.495004757586	(37.7458042977114, -122.495004757586)
167760	167760	181426	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1500 Sunset Blvd	59	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984929.045	2104818.9637	37.7585600964022	-122.495193620608	(37.7585600964022, -122.495193620608)
167665	167665	186108	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1901 Sunset Blvd	54	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984809.6117	2101640.7232	37.749826532853206	-122.495372275422	(37.7498265328532, -122.495372275422)
167561	167561	186155	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1700 Sunset Blvd	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			99	Width 0ft		5984957.7478	2103324.5301	37.7544584761874	-122.494984162752	(37.7544584761874, -122.494984162752)
167310	167310	186295	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1800 Sunset Blvd	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			36	Width 0ft		5984980.8659	2102682.5007	37.752696993700106	-122.49485688111099	(37.7526969937001, -122.494856881111)
167290	167290	185908	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2000 Sunset Blvd	51	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 0ft		5985025.7545	2101367.4934	37.7490889717309	-122.49460471461799	(37.7490889717309, -122.494604714618)
167101	167101	121995	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	598 15th Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		5991309.97219	2111418.90918	37.777053286089604	-122.473607150419	(37.7770532860896, -122.473607150419)
166696	166696	223775	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	615 Sanchez St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 3ft		6003692.3051	2104663.83541	37.7592148124283	-122.43029075463998	(37.7592148124283, -122.43029075464)
166681	166681	185521	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2201 Sunset Blvd	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984914.3316	2100160.6922	37.7457689026555	-122.494901041959	(37.7457689026555, -122.494901041959)
166548	166548	206841	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	246 Thrift St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17			5994549.17298	2089660.24802	37.7174965486989	-122.46082452325199	(37.7174965486989, -122.460824523252)
166337	166337	186697	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1401 Sunset Blvd	54	Sidewalk: Property side : Yard 9	Tree 1	Private 1			61	Width 0ft		5984719.6928	2105196.6935	37.75958497805411	-122.495945509363	(37.7595849780541, -122.495945509363)
166336	166336	185565	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2201 Sunset Blvd	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			63	Width 0ft		5984901.9941	2099754.2184	37.7446521138241	-122.494913737481	(37.7446521138241, -122.494913737481)

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