Street_Tree_List

Data source: data.sfgov.org

264 rows where PlotSize = "Width 10ft" and qSiteInfo = 3 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: qSpecies, SiteOrder

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
188895	188895	212106	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	4	Median : Yard 3	Tree 1	DPW 2			33	Width 10ft		5993007.603759999	2095365.5409099997	37.733073065562	-122.466567434662	(37.733073065562, -122.466567434662)
188426	188426	248776	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	3	Median : Yard 3	Tree 1	DPW 2			18	Width 10ft		6002998.16884	2095083.8511700002	37.73287107152721	-122.43200731937999	(37.7328710715272, -122.43200731938)
188330	188330	243923	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Bartlett St	2	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6006672.06961	2103729.13284	37.7568166658685	-122.419918946309	(37.7568166658685, -122.419918946309)
188244	188244	224100	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	2x Gough St	4	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006621.45587	2109260.75005	37.772002335561794	-122.42048662356899	(37.7720023355618, -122.420486623569)
187052	187052	251050	DPW Maintained 3	Pinus Spp :: Pine Spp 105	5800x Geary Blvd	1	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		5988878.2157	2112618.8979	37.780206989324796	-122.48210718666901	(37.7802069893248, -122.482107186669)
186566	186566	132093	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012902.31977	2119848.32419	37.8014252975988	-122.39950394556699	(37.8014252975988, -122.399503945567)
186445	186445	222811	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	13	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6006785.0700900005	2100560.48159	37.748122639944704	-122.419303374748	(37.7481226399447, -122.419303374748)
186361	186361	195681	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	10	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6015351.95562	2111719.9418200003	37.779242863700794	-122.390458762259	(37.7792428637008, -122.390458762259)
185868	185868	132133	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	500x The Embarcadero	13	Median : Yard 3	Tree 1	DPW 2			27	Width 10ft		6013516.34459	2118862.0699	37.7987514845508	-122.39730992891	(37.7987514845508, -122.39730992891)
185624	185624	212116	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		5992083.71687	2095423.23256	37.7331781144806	-122.469765726035	(37.7331781144806, -122.469765726035)
184455	184455	220705	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6007530.958190001	2100569.16609	37.748188465819794	-122.416724727984	(37.7481884658198, -122.416724727984)
183989	183989	223863	DPW Maintained 3	Cussonia spicata :: Cabbage tree 325	3700x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6005802.979169999	2100534.20381	37.7479951268836	-122.422697548374	(37.7479951268836, -122.422697548374)
183887	183887	180412	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1104x Alemany Blvd	2	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003814.30975	2094445.54262	37.7311646556118	-122.42914021505501	(37.7311646556118, -122.429140215055)
182508	182508	222827	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	4	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6007469.113419999	2100569.02723	37.748184605929204	-122.41693857595399	(37.7481846059292, -122.416938575954)
182470	182470	132107	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	3	Median : Yard 3	Tree 1	DPW 2			22	Width 10ft		6011604.73213	2121437.1460700002	37.805715402812204	-122.40410608402901	(37.8057154028122, -122.404106084029)
182257	182257	212115	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1902x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		5992194.67664	2095416.97281	37.7331673397011	-122.46938165614401	(37.7331673397011, -122.469381656144)
181994	181994	132108	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6011532.668269999	2121506.48507	37.8059017639302	-122.404360356561	(37.8059017639302, -122.404360356561)
181577	181577	195680	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	9	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015377.63395	2111744.49968	37.779311718508	-122.390371645854	(37.779311718508, -122.390371645854)
181413	181413	195720	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	4	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6014817.65208	2111211.59026	37.7778173905846	-122.39227159046001	(37.7778173905846, -122.39227159046)
180303	180303	180413	DPW Maintained 3	Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51	1104x Alemany Blvd	3	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6003786.93346	2094435.4492400002	37.731135391684	-122.42923414026001	(37.731135391684, -122.42923414026)
180074	180074	195732	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	16	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6014536.11101	2110945.78626	37.7770719155794	-122.39322694208401	(37.7770719155794, -122.393226942084)
179442	179442	220713	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3250x Cesar Chavez St	7	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6007871.6853	2100572.46831	37.7482166910568	-122.415546734794	(37.7482166910568, -122.415546734794)
179408	179408	195734	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	18	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6014485.12564	2110898.06022	37.776938038003294	-122.39339997704398	(37.7769380380033, -122.393399977044)
178958	178958	195733	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	17	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6014512.42504	2110924.16677	37.777011237428205	-122.39330736664301	(37.7770112374282, -122.393307366643)
178806	178806	220724	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3100x Cesar Chavez St	10	Median : Yard 3	Tree 1	DPW 2			15	Width 10ft		6008766.0875	2100575.56898	37.7482754383741	-122.412454127271	(37.7482754383741, -122.412454127271)
178690	178690	222809	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3400x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6006905.75522	2100562.66292	37.748135425630394	-122.418886203547	(37.7481354256304, -122.418886203547)
178654	178654	222819	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	12	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006102.45265	2100549.0367799997	37.7480527464562	-122.42166303303001	(37.7480527464562, -122.42166303303)
178642	178642	221310	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	18	Median : Yard 3	Tree 1	DPW 2			15	Width 10ft		6006690.61046	2100560.2464400004	37.748116673857396	-122.419629996836	(37.7481166738574, -122.419629996836)
178472	178472	251037	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	5317x Geary Blvd	11	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5990398.0172	2112670.1794	37.780436072061896	-122.476853300249	(37.7804360720619, -122.476853300249)
177771	177771	221305	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	10	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6006848.39499	2100562.5972700003	37.7481320153776	-122.419084549026	(37.7481320153776, -122.419084549026)
177575	177575	220725	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3100x Cesar Chavez St	11	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6008748.821819999	2100575.53964	37.748274388864495	-122.412513829653	(37.7482743888645, -122.412513829653)
177459	177459	132104	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			19	Width 10ft		6012041.8343	2121038.82925	37.8046461349625	-122.402565391602	(37.8046461349625, -122.402565391602)
177329	177329	251092	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	6100x Geary Blvd	2	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5988013.9609	2112592.2358	37.780083477756705	-122.485095046206	(37.7800834777567, -122.485095046206)
177115	177115	220728	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3100x Cesar Chavez St	17	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6008622.10298	2100574.90672	37.7482655386311	-122.412951976664	(37.7482655386311, -122.412951976664)
177078	177078	220712	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3250x Cesar Chavez St	3	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6007959.12606	2100570.6784200002	37.748216691058005	-122.415244239723	(37.748216691058, -122.415244239723)
176932	176932	195722	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	6	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014782.12024	2111178.98534	37.7777258917748	-122.392392227319	(37.7777258917748, -122.392392227319)
176923	176923	132084	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1200x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012274.61558	2120706.35336	37.8037462301721	-122.401736440606	(37.8037462301721, -122.401736440606)
176793	176793	195736	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	20	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6014449.17675	2110862.30677	37.7768378696968	-122.393521833393	(37.7768378696968, -122.393521833393)
176711	176711	251042	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	5500x Geary Blvd	1	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5989852.8157	2112655.9311	37.7803653089721	-122.47873834484899	(37.7803653089721, -122.478738344849)
176447	176447	221316	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6006164.906830001	2100554.27339	37.748070646539	-122.421447440342	(37.748070646539, -122.421447440342)
176286	176286	132079	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	11	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		6012611.87531	2120208.19637	37.8023972264213	-122.40053431322399	(37.8023972264213, -122.400534313224)
175283	175283	251074	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	5000x Geary Blvd	8	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5991352.6942	2112710.2412	37.7806014035471	-122.473553580301	(37.7806014035471, -122.473553580301)
175056	175056	195675	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	4	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015482.36105	2111843.26089	37.7795887033991	-122.390016249049	(37.7795887033991, -122.390016249049)
174200	174200	221304	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	3	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006999.9222099995	2100563.83599	37.7481439484975	-122.418560659758	(37.7481439484975, -122.418560659758)
173405	173405	195719	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	3	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6014846.74684	2111239.41443	37.7778954049955	-122.39217288717501	(37.7778954049955, -122.392172887175)
173206	173206	251070	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	5200x Geary Blvd	3	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5990754.7634	2112689.2674	37.7805091701663	-122.47562055473499	(37.7805091701663, -122.475620554735)
172638	172638	251071	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	5200x Geary Blvd	4	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5990727.8797	2112689.8051	37.7805090880033	-122.47571359647101	(37.7805090880033, -122.475713596471)
172202	172202	195721	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	5	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6014799.00222	2111195.13044	37.777771160036295	-122.39233495579599	(37.7777711600363, -122.392334955796)
172077	172077	243922	DPW Maintained 3	Washingtonia robusta :: Mexican Fan Palm 75	1x Bartlett St	3	Median : Yard 3	Tree 1	DPW 2			12	Width 10ft		6006671.30131	2103734.09431	37.756830245634	-122.419921955443	(37.756830245634, -122.419921955443)
171532	171532	222820	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	13	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6006079.97911	2100547.63598	37.748047632887705	-122.421740646313	(37.7480476328877, -122.421740646313)
170554	170554	228078	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	200x College Ave	1	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6005173.9664	2095916.21021	37.7352796556316	-122.424544210856	(37.7352796556316, -122.424544210856)
170512	170512	220717	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3050x Cesar Chavez St	3	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6009231.95113	2100579.80545	37.74831320359171	-122.410843476569	(37.7483132035917, -122.410843476569)
170418	170418	195682	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	11	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6015332.35887	2111698.96547	37.7791841802313	-122.39052508997	(37.7791841802313, -122.39052508997)
170260	170260	195684	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	13	Median : Yard 3	Tree 1	DPW 2			8	Width 10ft		6015289.74436	2111657.65185	37.779068378153	-122.39066962450799	(37.779068378153, -122.390669624508)
168768	168768	222841	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3100x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6008807.15459	2100576.2579200002	37.7482796346101	-122.412312166586	(37.7482796346101, -122.412312166586)
168748	168748	132110	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	9	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6011374.63029	2121626.67271	37.8062229369941	-122.404915741893	(37.8062229369941, -122.404915741893)
168563	168563	220707	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	2	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6007513.03873	2100568.93739	37.7481868299766	-122.416786676871	(37.7481868299766, -122.416786676871)
168474	168474	132105	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1400x The Embarcadero	4	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6012001.46692	2121074.30881	37.8047412994387	-122.402707584299	(37.8047412994387, -122.402707584299)
167752	167752	222836	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3050x Cesar Chavez St	5	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6009193.154069999	2100577.54159	37.7483048120374	-122.410977476444	(37.7483048120374, -122.410977476444)
167379	167379	251026	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5000x Geary Blvd	5	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		5991422.3485	2112710.0201	37.780604829996	-122.47331259909599	(37.780604829996, -122.473312599096)
167079	167079	222829	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	6	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6007416.24383	2100569.3004099997	37.748182381931294	-122.417121417131	(37.7481823819313, -122.417121417131)
166867	166867	132106	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	1	Median : Yard 3	Tree 1	DPW 2			20	Width 10ft		6011673.52168	2121373.1691	37.8055435810345	-122.40386352159099	(37.8055435810345, -122.403863521591)
166322	166322	251051	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	5900x Geary Blvd	5	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5988530.6021	2112606.8245	37.780153615018705	-122.48330884168699	(37.7801536150187, -122.483308841687)
166206	166206	222826	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3200x Cesar Chavez St	6	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6008154.70095	2100571.67515	37.7482304174003	-122.414568016118	(37.7482304174003, -122.414568016118)
166069	166069	220702	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3200x Cesar Chavez St	9	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6008108.227030001	2100572.1230099997	37.7482290360599	-122.414728753735	(37.7482290360599, -122.414728753735)
165397	165397	222821	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	14	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006053.42295	2100544.76657	37.748038256564705	-122.421832272848	(37.7480382565647, -122.421832272848)
164285	164285	221309	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3400x Cesar Chavez St	17	Median : Yard 3	Tree 1	DPW 2			15	Width 10ft		6006710.87077	2100560.14098	37.748117525522105	-122.41955992977199	(37.7481175255221, -122.419559929772)
164266	164266	132076	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1100x The Embarcadero	5	Median : Yard 3	Tree 1	DPW 2			25	Width 10ft		6012766.891340001	2119978.53875	37.8017752858665	-122.399981740966	(37.8017752858665, -122.399981740966)
164068	164068	221311	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			14	Width 10ft		6006340.93025	2100564.31807	37.7481081500844	-122.42083946986799	(37.7481081500844, -122.420839469868)
163293	163293	248777	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	10x Lyell St	4	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6002988.77776	2095086.3960799999	37.7328775268597	-122.43203996838699	(37.7328775268597, -122.432039968387)
162339	162339	220708	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	3	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6007490.2712	2100569.40378	37.7481868299661	-122.416865439509	(37.7481868299661, -122.416865439509)
161196	161196	222825	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3200x Cesar Chavez St	5	Median : Yard 3	Tree 1	DPW 2			3	Width 10ft		6008183.00365	2100572.10257	37.748233181035104	-122.414470176157	(37.7482331810351, -122.414470176157)
160424	160424	212109	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1701x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			33	Width 10ft		5992703.672809999	2095383.87275	37.7331058566417	-122.467619528126	(37.7331058566417, -122.467619528126)
159604	159604	220714	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3250x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6007851.34371	2100572.1206099996	37.748214592933394	-122.415617050982	(37.7482145929334, -122.415617050982)
159138	159138	212118	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			34	Width 10ft		5991962.73959	2095431.83723	37.733194747433295	-122.470184599654	(37.7331947474333, -122.470184599654)
158644	158644	224101	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	2x Gough St	5	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006607.58912	2109275.93798	37.7720432565284	-122.42053566810101	(37.7720432565284, -122.420535668101)
158594	158594	251036	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	5317x Geary Blvd	10	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5990401.2433	2112674.4808	37.780448069653296	-122.47684245414699	(37.7804480696533, -122.476842454147)
158486	158486	221320	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3200x Cesar Chavez St	1	Median : Yard 3	Tree 1	DPW 2			13	Width 10ft		6008271.26847	2100572.43199	37.7482390437115	-122.414164981352	(37.7482390437115, -122.414164981352)
158171	158171	222817	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	10	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6006145.22502	2100552.1939	37.7480638269962	-122.421515351753	(37.7480638269962, -122.421515351753)
157626	157626	251106	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	6300x Geary Blvd	1	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5987426.0529	2112570.9396	37.779990741259	-122.48712729528201	(37.779990741259, -122.487127295282)
157582	157582	222822	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	15	Median : Yard 3	Tree 1	DPW 2			2	Width 10ft		6006028.774680001	2100543.7206599996	37.7480339946844	-122.42191743145399	(37.7480339946844, -122.421917431454)
157513	157513	212104	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			30	Width 10ft		5993129.9763400005	2095367.74637	37.733086182185	-122.46614452395201	(37.733086182185, -122.466144523952)
157149	157149	212117	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	2001x Monterey Blvd	2	Median : Yard 3	Tree 1	DPW 2			21	Width 10ft		5992028.07396	2095428.94715	37.7331905889564	-122.469958512768	(37.7331905889564, -122.469958512768)
156264	156264	212113	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1902x Monterey Blvd	1	Median : Yard 3	Tree 1	DPW 2			26	Width 10ft		5992332.7127	2095408.39507	37.7331517634298	-122.46890380855899	(37.7331517634298, -122.468903808559)
155732	155732	221318	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3500x Cesar Chavez St	18	Median : Yard 3	Tree 1	DPW 2			10	Width 10ft		6005963.52235	2100538.85266	37.7480169480361	-122.42214272601002	(37.7480169480361, -122.42214272601)
155474	155474	132089	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1500x The Embarcadero	6	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6011437.6783	2121540.455	37.805989728403894	-122.404691478852	(37.8059897284039, -122.404691478852)
155128	155128	220723	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3100x Cesar Chavez St	3	Median : Yard 3	Tree 1	DPW 2			11	Width 10ft		6008940.31084	2100577.35759	37.7482901252064	-122.41185179192101	(37.7482901252064, -122.411851791921)
155021	155021	222830	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	7	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6007397.542119999	2100569.68358	37.7481823819289	-122.417186114357	(37.7481823819289, -122.417186114357)
154568	154568	195723	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	7	Median : Yard 3	Tree 1	DPW 2			6	Width 10ft		6014750.92686	2111151.90526	37.777649803738896	-122.392498242106	(37.7776498037389, -122.392498242106)
154428	154428	195674	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	102x King St	3	Median : Yard 3	Tree 1	DPW 2			9	Width 10ft		6015508.64587	2111869.51632	37.779662252656294	-122.389927152313	(37.7796622526563, -122.389927152313)
153800	153800	222815	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3500x Cesar Chavez St	5	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		6006246.77566	2100563.7677	37.7481013314143	-122.42116501457	(37.7481013314143, -122.42116501457)
153490	153490	132085	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1300x The Embarcadero	2	Median : Yard 3	Tree 1	DPW 2			23	Width 10ft		6012153.585109999	2120867.04559	37.8041806971541	-122.402166580042	(37.8041806971541, -122.402166580042)
153216	153216	222828	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	5	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6007445.92362	2100568.5836	37.7481820833534	-122.417018734321	(37.7481820833534, -122.417018734321)
152431	152431	220710	DPW Maintained 3	Brahea edulis :: Guadalupe Palm 115	3300x Cesar Chavez St	10	Median : Yard 3	Tree 1	DPW 2			15	Width 10ft		6007335.71167	2100569.3305200003	37.748177933862	-122.41739989758999	(37.748177933862, -122.41739989759)
152127	152127	251023	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	5000x Geary Blvd	2	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5991490.4549	2112712.2313	37.780614844759995	-122.473077150172	(37.78061484476, -122.473077150172)
152002	152002	212105	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	1602x Monterey Blvd	3	Median : Yard 3	Tree 1	DPW 2			27	Width 10ft		5993074.71475	2095363.2347400002	37.7330706059279	-122.466335248575	(37.7330706059279, -122.466335248575)
151880	151880	251078	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	5100x Geary Blvd	1	Median : Yard 3	Tree 1	DPW 2			1	Width 10ft		5991099.7276	2112702.723	37.7805661077577	-122.474428154783	(37.7805661077577, -122.474428154783)
151440	151440	195724	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	8	Median : Yard 3	Tree 1	DPW 2			5	Width 10ft		6014732.91022	2111131.92484	37.7775939414569	-122.39255917029	(37.7775939414569, -122.39255917029)
151226	151226	222831	DPW Maintained 3	Ceiba speciosa :: Silk floss 335	3300x Cesar Chavez St	8	Median : Yard 3	Tree 1	DPW 2			4	Width 10ft		6007377.19749	2100569.29044	37.7481801578885	-122.417256437759	(37.7481801578885, -122.417256437759)
151097	151097	195727	DPW Maintained 3	Platanus x hispanica :: Sycamore: London Plane 15	250x King St	11	Median : Yard 3	Tree 1	DPW 2			7	Width 10ft		6014667.91656	2111070.80187	37.777422501882896	-122.392779729899	(37.7774225018829, -122.392779729899)

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