Street_Tree_List

Data source: data.sfgov.org

149 rows where qSiteInfo = 9 and qSpecies = 32

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
2003	2003	127110	Significant Tree 6	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3201 Laguna St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 6ft		6003718.35126	2119752.0994	37.8006449063974	-122.431277695812	(37.8006449063974, -122.431277695812)
23441	23441	218859	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	1251 Funston Ave	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 5ft		5992039.2755	2106763.98784	37.7643143326521	-122.470745140778	(37.7643143326521, -122.470745140778)
24293	24293	225524	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2 Belcher St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		6003760.51975	2108247.79044	37.769059353622495	-122.43031053521999	(37.7690593536225, -122.43031053522)
26543	26543	127899	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	935 Chestnut St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		6007367.6196099995	2120526.83407	37.802978263103206	-122.418704671783	(37.8029782631032, -122.418704671783)
27378	27378	127365	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2235 Washington St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6003987.50394	2116614.7159	37.792045705887205	-122.43012237546999	(37.7920457058872, -122.43012237547)
27494	27494	124707	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3801 Jackson St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		5995983.26459	2115827.44118	37.7894274745237	-122.457759956145	(37.7894274745237, -122.457759956145)
27785	27785	126716	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2350 Green St	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 3ft		6001651.6937	2118053.9111099998	37.7958647911841	-122.43830743725	(37.7958647911841, -122.43830743725)
27960	27960	246686	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 4ft		6004961.87116	2097597.9446799997	37.7398853392354	-122.425397143159	(37.7398853392354, -122.425397143159)
28702	28702	126649	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2810 Pierce St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 4ft		6001592.47468	2118081.3261700002	37.7959366973881	-122.438514310994	(37.7959366973881, -122.438514310994)
29897	29897	124710	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3801 Jackson St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5996010.5045	2115832.83525	37.7894438500217	-122.45766610015801	(37.7894438500217, -122.457666100158)
34131	34131	123093	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	619 11th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 3ft		5992509.288919999	2111212.18975	37.776555073530396	-122.46944332614099	(37.7765550735304, -122.469443326141)
34764	34764	246821	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	198 Brewster St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10			6010041.69314	2098721.17607	37.7432551843714	-122.407912349468	(37.7432551843714, -122.407912349468)
34828	34828	218916	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	544 Judson Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 8ft		5996794.9301	2093643.7566799999	37.728563285644604	-122.453349451027	(37.7285632856446, -122.453349451027)
35305	35305	176450	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	306 Niagara Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 8ft		5998817.229619999	2090113.0618900002	37.718984525607	-122.446104420884	(37.718984525607, -122.446104420884)
37114	37114	127399	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3836 Buchanan St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 4ft		6003521.77735	2118150.4944700003	37.79623617162579	-122.43184349979299	(37.7962361716258, -122.431843499793)
39465	39465	189705	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	500 Wisconsin St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 9ft		6012637.736959999	2105122.26077	37.7609761769225	-122.39938512804399	(37.7609761769225, -122.399385128044)
39949	39949	192040	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 06th St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 4ft		6012673.25756	2109734.64435	37.7736427295523	-122.39958612111299	(37.7736427295523, -122.399586121113)
41170	41170	126717	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2350 Green St	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 3ft		6001632.11762	2118051.74254	37.7958577234076	-122.438375018588	(37.7958577234076, -122.438375018588)
41195	41195	225526	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	151 Beaver St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 3ft		6001905.194180001	2106784.92015	37.764937406352	-122.436623258876	(37.764937406352, -122.436623258876)
41309	41309	126650	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2810 Pierce St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 4ft		6001595.3403900005	2118060.27385	37.7958790562312	-122.438502885998	(37.7958790562312, -122.438502885998)
43269	43269	126992	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3298 Lyon St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			5998988.15912	2120165.48755	37.8015107592616	-122.447675811712	(37.8015107592616, -122.447675811712)
44286	44286	189792	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	651 Missouri St	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			6013593.88297	2104014.53961	37.7579878610588	-122.396000584357	(37.7579878610588, -122.396000584357)
44857	44857	127291	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2753 Fillmore St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		6002569.81395	2117569.5165	37.7945869462828	-122.43509591055201	(37.7945869462828, -122.435095910552)
46427	46427	127265	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2580 Broadway	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 4ft		6001231.20835	2117298.68712	37.7937672187265	-122.43970822125799	(37.7937672187265, -122.439708221258)
47156	47156	225401	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	345 Collingwood St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6002123.72913	2103815.97401	37.7567978169833	-122.435654978601	(37.7567978169833, -122.435654978601)
47757	47757	224869	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	177 Grand View Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9			6000809.5300199995	2103340.43751	37.7554173756181	-122.440165852995	(37.7554173756181, -122.440165852995)
48224	48224	127671	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	750 Bush St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6009877.6122	2115797.99155	37.7901350152555	-122.409684781938	(37.7901350152555, -122.409684781938)
49211	49211	218959	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	113 Stillings Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6000075.97071	2095686.0154799998	37.7343583730463	-122.44215328546998	(37.7343583730463, -122.44215328547)
50664	50664	126965	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	48 Parker Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 8ft		5996871.90335	2114255.83844	37.7851632832987	-122.454571800557	(37.7851632832987, -122.454571800557)
51221	51221	127744	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	46 Reed St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 2ft		6008191.9222	2117150.88378	37.7937551192486	-122.415612981577	(37.7937551192486, -122.415612981577)
52468	52468	127747	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	46 Reed St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 2ft		6008186.6142	2117184.56186	37.7938472925823	-122.415633733414	(37.7938472925823, -122.415633733414)
52929	52929	127253	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2655 Pierce St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6001595.65286	2117587.37126	37.7945806069538	-122.43846790596399	(37.7945806069538, -122.438467905964)
54157	54157	127240	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2615 Divisadero St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6000641.46855	2117380.03846	37.793957003573205	-122.441754609691	(37.7939570035732, -122.441754609691)
54533	54533	124708	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3801 Jackson St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		5995991.22091	2115828.85342	37.7894318092241	-122.45773253057301	(37.7894318092241, -122.457732530573)
54606	54606	192036	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 06th St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 4ft		6012574.5089	2109846.27928	37.773943748832004	-122.39993555088199	(37.773943748832, -122.399935550882)
54704	54704	127692	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	751 Powell St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 5ft		6010024.77623	2116366.9958099998	37.7917056092738	-122.40921577291	(37.7917056092738, -122.40921577291)
55087	55087	189729	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	637 Carolina St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6012414.42962	2104988.39193	37.76059615402	-122.400148053514	(37.76059615402, -122.400148053514)
55098	55098	126991	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3298 Lyon St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9			5998990.01518	2120153.31147	37.8014774331087	-122.447668511913	(37.8014774331087, -122.447668511913)
55552	55552	126964	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	48 Parker Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 8ft		5996871.72113	2114270.32352	37.7852030450262	-122.45457347777901	(37.7852030450262, -122.454573477779)
56318	56318	127217	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2864 Broadway	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 4ft		5999928.92975	2117120.95639	37.7932050075467	-122.444201430254	(37.7932050075467, -122.444201430254)
56341	56341	127215	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2864 Broadway	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		5999937.99418	2117121.61309	37.7932073277938	-122.44417011406	(37.7932073277938, -122.44417011406)
57299	57299	124231	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	57 Paramount Ter	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 4ft		5996432.1568599995	2110970.79674	37.7761181964123	-122.455855620254	(37.7761181964123, -122.455855620254)
57660	57660	127825	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2700 Van Ness Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 3ft		6005766.26844	2119704.14831	37.800629089132705	-122.42418764134399	(37.8006290891327, -122.424187641344)
57789	57789	127258	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2647 Pierce St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6001605.02948	2117535.84758	37.7944396697143	-122.438431768512	(37.7944396697143, -122.438431768512)
58333	58333	127698	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	751 Powell St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 5ft		6010051.434780001	2116188.24535	37.7912162971438	-122.409110915531	(37.7912162971438, -122.409110915531)
58828	58828	124711	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3801 Jackson St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5996022.33056	2115833.99098	37.7894477026869	-122.45762526722	(37.7894477026869, -122.45762526722)
59872	59872	127218	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2864 Broadway	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		5999923.49955	2117118.25276	37.793197274296496	-122.44422002466001	(37.7931972742965, -122.44422002466)
60620	60620	123106	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	506 11th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 3ft		5992547.059330001	2111971.24469	37.7786414152368	-122.46936793233499	(37.7786414152368, -122.469367932335)
60678	60678	127694	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	751 Powell St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 5ft		6010034.64257	2116302.89641	37.7915301605493	-122.40917711015	(37.7915301605493, -122.40917711015)
60834	60834	246682	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 4ft		6005028.19634	2097600.03774	37.7398948333787	-122.42516796712799	(37.7398948333787, -122.425167967128)
61345	61345	127826	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2700 Van Ness Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 3ft		6005760.08809	2119744.40343	37.800739270458	-122.42421189246402	(37.800739270458, -122.424211892464)
61572	61572	127252	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2655 Pierce St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6001595.82653	2117595.75482	37.7946036359023	-122.438467905989	(37.7946036359023, -122.438467905989)
61852	61852	127255	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2651 Pierce St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		6001599.28415	2117567.5021900004	37.794526258221396	-122.43845391703199	(37.7945262582214, -122.438453917032)
62251	62251	127366	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2235 Washington St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 4ft		6004007.74008	2116617.82275	37.7920553826002	-122.430052579965	(37.7920553826002, -122.430052579965)
62676	62676	127226	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2801 Green St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		5999573.292169999	2117700.66189	37.7947764298502	-122.44547365800501	(37.7947764298502, -122.445473658005)
62695	62695	127239	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	25 Normandie Ter	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6000903.5108	2117368.04112	37.7939389892431	-122.44084705885099	(37.7939389892431, -122.440847058851)
64822	64822	176448	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	843 Cayuga Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 6ft		6001153.28465	2092061.4502700001	37.724467487066	-122.43816910622401	(37.724467487066, -122.438169106224)
65814	65814	225400	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	345 Collingwood St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6002127.76148	2103805.74761	37.7567699667845	-122.435640301668	(37.7567699667845, -122.435640301668)
65984	65984	192038	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 06th St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 4ft		6012638.65405	2109775.29171	37.7737524090692	-122.399708675313	(37.7737524090692, -122.399708675313)
66514	66514	127216	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2864 Broadway	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		5999932.8876	2117120.8741599997	37.7932050075595	-122.444187729973	(37.7932050075595, -122.444187729973)
68082	68082	127695	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	751 Powell St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 5ft		6010039.16596	2116275.66028	37.7914556301243	-122.40915953648899	(37.7914556301243, -122.409159536489)
69154	69154	127266	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2580 Broadway	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 4ft		6001222.07409	2117296.86345	37.7937616914949	-122.43973969574101	(37.7937616914949, -122.439739695741)
69232	69232	126956	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	250 Laurel St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 2ft		5998094.8526099995	2115625.78698	37.7889948655654	-122.450439589331	(37.7889948655654, -122.450439589331)
70043	70043	126946	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3498 Clay St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		5998158.551519999	2115540.98098	37.7887656562476	-122.450213085179	(37.7887656562476, -122.450213085179)
72077	72077	225348	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	5407 Diamond Heights Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6002089.89728	2098106.21858	37.7411182594017	-122.435363562302	(37.7411182594017, -122.435363562302)
72249	72249	127256	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2651 Pierce St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 4ft		6001600.43669	2117558.08465	37.7945004656696	-122.438449254053	(37.7945004656696, -122.438449254053)
72351	72351	127398	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3836 Buchanan St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 4ft		6003523.3274	2118136.98545	37.7961991672041	-122.431837171252	(37.7961991672041, -122.431837171252)
73610	73610	192051	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	311 Townsend St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			31	Width 8ft		6013302.41922	2110215.29688	37.7749975429264	-122.39744345487499	(37.7749975429264, -122.397443454875)
73685	73685	127828	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2700 Van Ness Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 3ft		6005757.99202	2119756.0775599997	37.8007712062878	-122.42421997648	(37.8007712062878, -122.42421997648)
74376	74376	126947	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3498 Clay St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		5998113.25689	2115534.62169	37.788745603166795	-122.450369338791	(37.7887456031668, -122.450369338791)
74412	74412	126993	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	3298 Lyon St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			5998985.37551	2120178.1493599997	37.8015453660859	-122.447686356233	(37.8015453660859, -122.447686356233)
74833	74833	176447	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	843 Cayuga Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 6ft		6001152.60647	2092059.5558	37.7244622467113	-122.438171314947	(37.7244622467113, -122.438171314947)
74835	74835	127257	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2647 Pierce St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 4ft		6001603.96724	2117549.62436	37.7944774367401	-122.438436431502	(37.7944774367401, -122.438436431502)
76629	76629	128296	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Lombard St	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 6ft		6011760.219769999	2120791.0173	37.8039499778675	-122.403522505873	(37.8039499778675, -122.403522505873)
83066	83066	127251	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2655 Pierce St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6001594.68789	2117605.8428599997	37.7946312702617	-122.43847256894699	(37.7946312702617, -122.438472568947)
120443	120443	189728	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	637 Carolina St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9			6012419.4097	2104985.42263	37.760588278655895	-122.400130621033	(37.7605882786559, -122.400130621033)
125559	125559	123631	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	237 Arguello Blvd	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 1ft		5995484.070780001	2114686.29497	37.7862655050608	-122.459404422881	(37.7862655050608, -122.459404422881)
126750	126750	127238	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	25 Normandie Ter	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 3ft		6000900.39799	2117384.35202	37.793983597423	-122.44085900006901	(37.793983597423, -122.440859000069)
127240	127240	246683	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 4ft		6005013.28889	2097598.95016	37.7398910049652	-122.425219433535	(37.7398910049652, -122.425219433535)
135281	135281	127823	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2700 Van Ness Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 3ft		6005769.69398	2119681.3968599997	37.8005668128703	-122.424174168599	(37.8005668128703, -122.424174168599)
136417	136417	127261	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2629 Pierce St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6001609.65655	2117482.74466	37.7942941261243	-122.43841195195401	(37.7942941261243, -122.438411951954)
136917	136917	128294	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	101 Lombard St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 5ft		6011739.96085	2120785.45853	37.8039335832322	-122.403592222228	(37.8039335832322, -122.403592222228)
137517	137517	126966	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	32 Parker Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 8ft		5996866.787930001	2114389.9756	37.7855312948716	-122.45459919211099	(37.7855312948716, -122.454599192111)
137541	137541	127219	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2864 Broadway	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 4ft		5999916.98549	2117117.82475	37.793195727460706	-122.44424253287599	(37.7931957274607, -122.444242532876)
137639	137639	128324	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	149 Union St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6			6012167.10136	2119825.45961	37.801321509546796	-122.40204653673901	(37.8013215095468, -122.402046536739)
137813	137813	127746	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	46 Reed St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 2ft		6008189.08245	2117173.8020099998	37.7938178874318	-122.415624430828	(37.7938178874318, -122.415624430828)
138052	138052	192035	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 06th St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 4ft		6012559.04741	2109863.50424	37.7739901826422	-122.39999024496201	(37.7739901826422, -122.399990244962)
146363	146363	126648	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2810 Pierce St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 4ft		6001589.38632	2118103.90056	37.7959985050844	-122.438526615527	(37.7959985050844, -122.438526615527)
146749	146749	128323	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	149 Union St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5			6012158.21016	2119822.6074	37.8013131818191	-122.402077103775	(37.8013131818191, -122.402077103775)
147841	147841	246680	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 4ft		6005184.39895	2097607.58215	37.7399243716053	-122.42462841978201	(37.7399243716053, -122.424628419782)
148862	148862	176463	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	300 Gaven St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 4ft		6008926.06204	2094862.35921	37.7325971892913	-122.41149735652	(37.7325971892913, -122.41149735652)
149676	149676	127250	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	2655 Pierce St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6001594.22985	2117616.2525299997	37.7946598264468	-122.438474900003	(37.7946598264468, -122.438474900003)
150493	150493	224868	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	175 Grand View Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		6000828.74292	2103376.29787	37.7555169332749	-122.440101980424	(37.7555169332749, -122.440101980424)
151817	151817	192039	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 06th St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 4ft		6012655.18553	2109753.0885799997	37.7736923658464	-122.399649930699	(37.7736923658464, -122.399649930699)
152152	152152	246681	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 4ft		6005137.38612	2097606.83226	37.7399196573536	-122.42479091738701	(37.7399196573536, -122.424790917387)
152165	152165	176453	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	140 Madison St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 2ft		6005488.1147	2093033.7267	37.7273827303155	-122.42325324845801	(37.7273827303155, -122.423253248458)
152345	152345	246678	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	65 Randall St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 4ft		6005222.8012	2097609.38503	37.7399314906489	-122.424495768869	(37.7399314906489, -122.424495768869)
153112	153112	127696	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	751 Powell St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 5ft		6010042.923140001	2116244.05578	37.79136906228221	-122.409144305564	(37.7913690622822, -122.409144305564)
153548	153548	192037	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	650 06th St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 4ft		6012622.90154	2109796.15222	37.7738088091574	-122.39976463112801	(37.7738088091574, -122.399764631128)
153949	153949	246676	Undocumented 2	Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32	25 Randall St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6005260.167640001	2097612.18333	37.739941284250996	-122.42436677011601	(37.739941284251, -122.424366770116)

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