Street_Tree_List

Data source: data.sfgov.org

846 rows where PlotSize = "Width 0ft" and qSpecies = 59 sorted by TreeID

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, qSiteInfo, qCaretaker, PlantDate, DBH, PermitNotes

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
155154	155154	137517	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	11 Seymour St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6001642.6038	2112140.9289	37.779628745329	-122.437915153636	(37.779628745329, -122.437915153636)
174213	174213	137519	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	11 Seymour St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6001649.8446	2112101.8284	37.7795217969961	-122.437887303264	(37.7795217969961, -122.437887303264)
164772	164772	137520	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	11 Seymour St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6001651.2928	2112086.3813	37.779479465517504	-122.437881186624	(37.7794794655175, -122.437881186624)
60794	60794	137528	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300 Pierce St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6002263.2838	2113153.4253	37.7824440807926	-122.435840420812	(37.7824440807926, -122.435840420812)
23633	23633	137529	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300 Pierce St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6002258.0131	2113181.285	37.7825202770743	-122.43586064910801	(37.7825202770743, -122.435860649108)
49750	49750	137532	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1300 Pierce St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6002250.4834	2113262.6052	37.7827431340216	-122.435892519009	(37.7827431340216, -122.435892519009)
74307	74307	137574	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1135 STEINER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		6002846.9387	2112168.7066	37.7797734277366	-122.43375082949801	(37.7797734277366, -122.433750829498)
29669	29669	137591	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1235 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6002786.4345	2112612.3356	37.7809880882364	-122.433991859956	(37.7809880882364, -122.433991859956)
284	284	137592	Permitted Site 1	Ficus retusa nitida :: Banyan Fig 59	1125 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/16/1990 12:00:00 AM	18	Width 0ft		6002857.6038	2112094.871	37.7795712988398	-122.433708655697	(37.7795712988398, -122.433708655697)
186307	186307	137638	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	807 LYON ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		5999975.5644	2111759.3427	37.778486068888796	-122.443654723767	(37.7784860688888, -122.443654723767)
148225	148225	137640	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1319 McAllister St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6002813.9379	2111632.5778	37.778299479553105	-122.433826662886	(37.7782994795531, -122.433826662886)
38684	38684	137659	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1334 MCALLISTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6002765.4317	2111672.0138	37.778405008308795	-122.43399728327101	(37.7784050083088, -122.433997283271)
179539	179539	137688	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1836 MCALLISTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6000295.9538	2111331.2873	37.777329005815794	-122.44251563792801	(37.7773290058158, -122.442515637928)
55859	55859	137798	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1900 Laguna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6004365.9463	2115528.293	37.7890840898669	-122.428735478435	(37.7890840898669, -122.428735478435)
41357	41357	137799	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1900 Laguna St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6004356.41	2115593.3639	37.789262218427	-122.42877311351002	(37.789262218427, -122.42877311351)
148475	148475	137800	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1900 Laguna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6004352.4834	2115615.8021	37.7893236058288	-122.42878829933001	(37.7893236058288, -122.42878829933)
37033	37033	137820	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	18 ORBEN PL	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003172.6736	2115287.4039	37.7883550625506	-122.432846830068	(37.7883550625506, -122.432846830068)
160336	160336	137858	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	22 Orben Pl	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6003153.1523	2115433.6928	37.7887556274538	-122.43292482586	(37.7887556274538, -122.43292482586)
189110	189110	137859	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	20 Orben Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6003149.2963	2115462.6131	37.7888348165279	-122.43294023402599	(37.7888348165279, -122.432940234026)
152198	152198	137875	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1905 LAGUNA ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6004335.4283	2115401.5843	37.7887344524597	-122.428832029994	(37.7887344524597, -122.428832029994)
124097	124097	137887	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	38 ORBEN PL	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 0ft		6003163.7564	2115374.8880000003	37.788594765883005	-122.432883934493	(37.788594765883, -122.432883934493)
45906	45906	137896	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1832 LAGUNA ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6004416.1912	2115174.8872	37.788116570049404	-122.428536436558	(37.7881165700494, -122.428536436558)
61072	61072	137911	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	30 ORBEN PL	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003169.7815	2115326.4464	37.788462099298	-122.432859626542	(37.788462099298, -122.432859626542)
170286	170286	137919	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1963 PINE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6004551.2938	2115340.9969	37.788580310137	-122.428080846949	(37.788580310137, -122.428080846949)
176087	176087	137986	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1826 WEBSTER ST	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4	Width 0ft		6003453.629	2115096.2902	37.7878462437049	-122.431861119013	(37.7878462437049, -122.431861119013)
48511	48511	137987	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1815 LAGUNA ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6004374.8136	2115107.5838	37.7879294301748	-122.42867479630699	(37.7879294301748, -122.428674796307)
151410	151410	138001	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1685 SUTTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6004515.7645	2114645.0665	37.7866674497361	-122.42815415721701	(37.7866674497361, -122.428154157217)
72708	72708	138006	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1781 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6004101.4738	2114584.9413	37.786478912061	-122.429583213622	(37.786478912061, -122.429583213622)
175350	175350	138007	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1803 Sutter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003877.7864	2114559.3667	37.7863960226531	-122.43035529070801	(37.7863960226531, -122.430355290708)
188446	188446	138009	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1803 Sutter St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6003935.4192	2114568.0116	37.7864230237501	-122.430156512807	(37.7864230237501, -122.430156512807)
41015	41015	138010	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1401 Gough St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6005424.6122	2114535.8430000003	37.7864189291949	-122.42500198582199	(37.7864189291949, -122.425001985822)
56971	56971	138011	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1401 Gough St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6005427.9087	2114512.7674	37.786355755539105	-122.424988938346	(37.7863557555391, -122.424988938346)
162965	162965	138040	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1 Wilmot St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003385.4026	2115029.2516	37.7876583048425	-122.432092380369	(37.7876583048425, -122.432092380369)
51707	51707	138041	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1 Wilmot St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003396.2249	2115029.767	37.7876603335628	-122.43205497415701	(37.7876603335628, -122.432054974157)
1470	1470	138091	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1890 Sutter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		04/09/1990 12:00:00 AM	15	Width 0ft		6003632.0	2114586.0	37.7864552256154	-122.43120755079399	(37.7864552256154, -122.431207550794)
1477	1477	138092	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1890 Sutter St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	Width 0ft		6003632.0	2114586.0	37.7864552256154	-122.43120755079399	(37.7864552256154, -122.431207550794)
1448	1448	138093	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1890 Sutter St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	Width 0ft		6003632.0	2114586.0	37.7864552256154	-122.43120755079399	(37.7864552256154, -122.431207550794)
34859	34859	138109	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1600 SUTTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6004876.0712	2114750.6655	37.7869777775164	-122.426915105637	(37.7869777775164, -122.426915105637)
40269	40269	138110	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1600 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6004839.6037	2114746.6136	37.786964589964796	-122.42704098629801	(37.7869645899648, -122.427040986298)
378	378	138112	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1698 Sutter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	Width 0ft		6004508.5013	2114699.1479	37.7868155327596	-122.428183141793	(37.7868155327596, -122.428183141793)
3338	3338	138120	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1970 SUTTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003157.8417	2114507.235	37.7862120754355	-122.432842389477	(37.7862120754355, -122.432842389477)
53173	53173	138121	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1980 Sutter St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003117.6649	2114503.0787	37.7861983845046	-122.43298109352	(37.7861983845046, -122.43298109352)
131804	131804	138123	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1850 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003035.9259	2114580.1998	37.786405502849604	-122.433269401448	(37.7864055028496, -122.433269401448)
50702	50702	138124	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1850 FILLMORE ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6003031.7696	2114609.7551	37.7864864184254	-122.433285893848	(37.7864864184254, -122.433285893848)
135249	135249	138125	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1850 FILLMORE ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	Width 0ft		6003026.6898	2114633.7688	37.7865520657788	-122.433305185236	(37.7865520657788, -122.433305185236)
48419	48419	138126	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1850 FILLMORE ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	Width 0ft		6003024.8426	2114663.3242	37.78663311261921	-122.433313688795	(37.7866331126192, -122.433313688795)
150951	150951	138127	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	1850 FILLMORE ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	Width 0ft		6003021.61	2114689.1851	37.78670393670271	-122.433326721425	(37.7867039367027, -122.433326721425)
49378	49378	138130	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2145 Bush St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6003041.4675	2114785.2401	37.786968805880704	-122.433264885414	(37.7869688058807, -122.433264885414)
56306	56306	138131	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2135 Bush St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6003060.8632	2114789.3963	37.7869813180356	-122.433198077825	(37.7869813180356, -122.433198077825)
58650	58650	138132	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2131 Bush St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6003095.0366	2114792.1671	37.786990864454296	-122.433080043725	(37.7869908644543, -122.433080043725)
161583	161583	138179	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	42 ORBEN PL	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6003161.3464	2115384.5281	37.7886210984548	-122.432892961694	(37.7886210984548, -122.432892961694)
68640	68640	138180	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	42 ORBEN PL	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003159.9004	2115394.1683	37.788647485977	-122.432898653615	(37.788647485977, -122.432898653615)
186	186	138359	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	Width 0ft		6002861.592	2114464.6761	37.7860784126894	-122.43386429175101	(37.7860784126894, -122.433864291751)
231	231	138360	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	Width 0ft		6002847.7164	2114462.1983	37.7860708218731	-122.433912120385	(37.7860708218731, -122.433912120385)
221	221	138361	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	Width 0ft		6002830.8674	2114461.7028	37.78606850519029	-122.433970377911	(37.7860685051903, -122.433970377911)
199	199	138362	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	Width 0ft		6002806.585	2114457.2427	37.78605488083279	-122.434054069465	(37.7860548808328, -122.434054069465)
220	220	138363	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	Width 0ft		6002798.656	2114455.2605	37.7860489882217	-122.434081359893	(37.7860489882217, -122.434081359893)
216	216	138364	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	Width 0ft		6002783.7892	2114453.2783	37.7860427018539	-122.43413265320801	(37.7860427018539, -122.434132653208)
195	195	138365	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			19	Width 0ft		6002748.6045	2114451.296	37.78603526200121	-122.43425424087799	(37.7860352620012, -122.434254240878)
217	217	138366	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	Width 0ft		6002708.9598	2114445.3493	37.7860166836287	-122.43439097535801	(37.7860166836287, -122.434390975358)
201	201	138367	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			15	Width 0ft		6002691.6152	2114444.3582	37.7860129777854	-122.434450912019	(37.7860129777854, -122.434450912019)
188	188	138368	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			13	Width 0ft		6002679.2262	2114443.3671	37.786009553218996	-122.434493703661	(37.786009553219, -122.434493703661)
192	192	138369	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	Width 0ft		6002665.8461	2114439.4026	37.78599790817471	-122.434539711553	(37.7859979081747, -122.434539711553)
211	211	138370	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			16	Width 0ft		6002647.5104	2114436.9248	37.7859900638921	-122.434602970779	(37.7859900638921, -122.434602970779)
230	230	138371	DPW Maintained 3	Ficus retusa nitida :: Banyan Fig 59	2060 SUTTER ST	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			17	Width 0ft		6002611.3346	2114434.4469999997	37.785981206770394	-122.434727951803	(37.7859812067704, -122.434727951803)
54426	54426	138372	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1801 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6002563.7609	2114481.5252	37.7861077705586	-122.434895911649	(37.7861077705586, -122.434895911649)
56313	56313	138373	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1801 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6002557.3186	2114515.2232	37.786199930917796	-122.43492061108101	(37.7861999309178, -122.434920611081)
162133	162133	138374	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1801 Steiner St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 0ft		6002553.8497	2114553.8768	37.786305866911796	-122.43493537792601	(37.7863058669118, -122.434935377926)
61462	61462	138417	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2158 SUTTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6002253.1064	2114381.7326	37.785816122555794	-122.435963548588	(37.7858161225558, -122.435963548588)
68638	68638	138418	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1819 STEINER ST	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			14	Width 0ft		6002514.5891	2114496.0302	37.7861448056429	-122.435067070541	(37.7861448056429, -122.435067070541)
168674	168674	138419	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1819 STEINER ST	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			14	Width 0ft		6002518.3631	2114471.7689	37.7860784045808	-122.435052277699	(37.7860784045808, -122.435052277699)
24601	24601	138420	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1819 STEINER ST	3	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			14	Width 0ft		6002521.5979	2114452.899	37.786026776312596	-122.435039736101	(37.7860267763126, -122.435039736101)
167934	167934	138421	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1819 STEINER ST	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			13	Width 0ft		6002523.7545	2114441.5771	37.7859958117094	-122.435031464821	(37.7859958117094, -122.435031464821)
61363	61363	138465	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1870 Scott St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6001534.446	2114897.4717	37.7871913575616	-122.43848687191401	(37.7871913575616, -122.438486871914)
181399	181399	138471	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1749 FILLMORE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6003013.5126	2114407.0987	37.785928939577104	-122.433334571847	(37.7859289395771, -122.433334571847)
183195	183195	138472	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1749 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6003013.5126	2114389.5238	37.785880683353	-122.433333315539	(37.785880683353, -122.433333315539)
131793	131793	138473	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1749 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003016.4418	2114370.4842	37.7858285716099	-122.433321820329	(37.7858285716099, -122.433321820329)
45631	45631	138474	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1749 FILLMORE ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003020.1032	2114355.1062	37.7857865552298	-122.433308053669	(37.7857865552298, -122.433308053669)
157308	157308	138475	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1749 FILLMORE ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6003020.8355	2114339.7281	37.7857443724045	-122.433304420865	(37.7857443724045, -122.433304420865)
147790	147790	138486	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1910 STEINER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6002505.7805	2114896.8038	37.7872447276766	-122.435126221094	(37.7872447276766, -122.435126221094)
38762	38762	138500	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2416 BUSH ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 0ft		6001920.8461	2114683.7924	37.7866266207317	-122.437134708687	(37.7866266207317, -122.437134708687)
24575	24575	138501	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1799 Steiner St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6002528.8099	2114345.6813	37.7857327932764	-122.435007113669	(37.7857327932764, -122.435007113669)
176578	176578	138502	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1799 Steiner St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6002532.1465	2114322.3247	37.7856688514425	-122.43499389896499	(37.7856688514425, -122.434993898965)
64988	64988	138503	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1799 Steiner St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6002537.1515	2114272.2749	37.7855317115931	-122.43497300238899	(37.7855317115931, -122.434973002389)
154399	154399	138504	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2199 SUTTER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 0ft		6002136.009	2114306.6228	37.785603237384294	-122.436363294657	(37.7856032373843, -122.436363294657)
179477	179477	138505	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2199 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 0ft		6002149.3229	2114310.859	37.7856156253984	-122.43631753578	(37.7856156253984, -122.43631753578)
29940	29940	138506	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1701 FILLMORE ST	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003039.875	2114221.8295	37.7854217327846	-122.43323012236999	(37.7854217327846, -122.43323012237)
29770	29770	138507	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1701 FILLMORE ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003042.8042	2114198.3962	37.785357557038296	-122.433218313249	(37.7853575570383, -122.433218313249)
136533	136533	138537	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1700 FILLMORE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6003095.1947	2114174.7238	37.7852955304758	-122.433035366169	(37.7852955304758, -122.433035366169)
76808	76808	138539	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1700 FILLMORE ST	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 0ft		6003089.8085	2114203.6138	37.785374549591204	-122.433056065597	(37.7853745495912, -122.433056065597)
50378	50378	138584	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2702 Pine St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 0ft		6000961.2488	2114897.5694	37.787159004284895	-122.440470012407	(37.7871590042849, -122.440470012407)
72664	72664	138585	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	2702 Pine St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6000941.2065	2114893.5609	37.7871468567375	-122.440539066616	(37.7871468567375, -122.440539066616)
172173	172173	138587	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1732 BAKER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6000059.0615	2114952.3738	37.7872580704829	-122.44359531261298	(37.7872580704829, -122.443595312613)
51773	51773	138588	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1732 BAKER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		6000056.8342	2114968.7073	37.7873027909955	-122.443604192363	(37.7873027909955, -122.443604192363)
69909	69909	138607	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	512 PRESIDIO AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 0ft		5999174.9019	2114851.0194	37.786929312495204	-122.446647009525	(37.7869293124952, -122.446647009525)
39160	39160	138608	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	500 PRESIDIO AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5999173.5218	2114868.2702	37.78697659984	-122.44665302598801	(37.78697659984, -122.446653025988)
45943	45943	138610	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1716 BAKER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6000062.7737	2114910.7976	37.7871441247685	-122.443579481437	(37.7871441247685, -122.443579481437)
72831	72831	138611	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1711 BAKER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		6000013.0072	2114911.1445	37.7871422388637	-122.443751687038	(37.7871422388637, -122.443751687038)
76379	76379	138626	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1707 BAKER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 0ft		6000016.9472	2114873.7147	37.7870396910965	-122.443735365508	(37.7870396910965, -122.443735365508)
38980	38980	138629	Undocumented 2	Ficus retusa nitida :: Banyan Fig 59	1705 BAKER ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 0ft		6000022.8572	2114841.5382	37.7869516798811	-122.443712605837	(37.7869516798811, -122.443712605837)

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