Street_Tree_List

Data source: data.sfgov.org

269 rows where PlotSize = "Width 3ft" and qSpecies = 142

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, DBH

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
3088	3088	245344	Permitted Site 1	Syagrus romanzoffianum :: Queen Palm 142	1005 Noe St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/22/2002 12:00:00 AM	16	Width 3ft	Permit Number 45840	6003175.28861	2102361.95423	37.752865096051394	-122.431914479684	(37.7528650960514, -122.431914479684)
4182	4182	253620	Significant Tree 6	Syagrus romanzoffianum :: Queen Palm 142	1120 South Van Ness Ave	3	Front Yard : Cutout 8	Tree 1	Private 1				Width 3ft		6007603.98274	2103104.1444200003	37.755153048679205	-122.41665176419201	(37.7551530486792, -122.416651764192)
23543	23543	245283	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	399 San Jose Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6006236.70804	2100879.7389700003	37.748968348918794	-122.42122226179501	(37.7489683489188, -122.421222261795)
23764	23764	197793	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	66 Ceres St	1	: 4	Tree 1	Private 1			16	Width 3ft		6013832.07065	2093815.87712	37.7299977259065	-122.394462716674	(37.7299977259065, -122.394462716674)
23877	23877	215142	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	600 Portola Dr	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		5997147.4382	2099712.0801	37.745245634987995	-122.452568576882	(37.745245634988, -122.452568576882)
24349	24349	245242	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	882 York St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6009904.77367	2104105.1123200003	37.7580306148353	-122.40876553542401	(37.7580306148353, -122.408765535424)
25139	25139	245353	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	40 Pond St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6003161.02626	2106276.4725200003	37.7636126186575	-122.432243341071	(37.7636126186575, -122.432243341071)
26192	26192	136529	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	3601 Broderick St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5999666.6912	2120931.30198	37.8036522357126	-122.44538288853501	(37.8036522357126, -122.445382888535)
26301	26301	245318	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	45 Mirabel Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6007552.12465	2099948.94937	37.7464866805288	-122.41660760567301	(37.7464866805288, -122.416607605673)
26394	26394	245339	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	4230 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6001657.3727	2101778.0038900003	37.751175540640205	-122.437121899671	(37.7511755406402, -122.437121899671)
26574	26574	245297	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1536 Noe St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6003292.09068	2099305.46316	37.7444793082671	-122.431292397034	(37.7444793082671, -122.431292397034)
27268	27268	197791	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	340 Arkansas St	2	: 4	Tree 1	Private 1			14	Width 3ft		6012898.99071	2105404.50767	37.7617657223333	-122.39850136517	(37.7617657223333, -122.39850136517)
27780	27780	245345	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	466 Hill St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6003300.1227	2103327.9706099997	37.755524624263394	-122.431551739942	(37.7555246242634, -122.431551739942)
29624	29624	240962	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	95 Eagle St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5999817.7202	2104451.34743	37.75841114588761	-122.443675625443	(37.7584111458876, -122.443675625443)
29925	29925	136559	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1200 Mason St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6009435.38581	2117472.07438	37.794706848389	-122.41133317000099	(37.794706848389, -122.411333170001)
30892	30892	245269	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	207 Bennington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6007122.3181	2096929.8532099999	37.7381727341921	-122.41787985679701	(37.7381727341921, -122.417879856797)
32166	32166	240984	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	426 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6002286.66719	2105716.35154	37.7620250481505	-122.43522740403499	(37.7620250481505, -122.435227404035)
32897	32897	245304	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	371 Laidley St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			28	Width 3ft		6003869.89796	2096618.9998400002	37.737135624318	-122.429102948069	(37.737135624318, -122.429102948069)
33031	33031	240871	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	2913 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007129.38723	2101389.6911299997	37.750418847457205	-122.418171515021	(37.7504188474572, -122.418171515021)
34314	34314	245253	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1090 Hampshire St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6010233.17575	2102878.70236	37.754681555732496	-122.40754330998001	(37.7546815557325, -122.40754330998)
35276	35276	240965	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	95 Eagle St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5999852.336490001	2104454.38191	37.7584214521011	-122.443556125313	(37.7584214521011, -122.443556125313)
35304	35304	179615	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	30 Holyoke St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6009248.62763	2094075.2429099998	37.7304540239162	-122.410326608297	(37.7304540239162, -122.410326608297)
37077	37077	240957	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	590 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6002338.79793	2104771.43525	37.759433496969294	-122.434979523002	(37.7594334969693, -122.434979523002)
37309	37309	245257	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	941 Church St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6004404.53207	2103435.24181	37.75588170099729	-122.42773999222601	(37.7558817009973, -122.427739992226)
37312	37312	197799	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	633 06th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			22	Width 3ft		6012559.41823	2109925.0175900003	37.77415910498579	-122.399993282875	(37.7741591049858, -122.399993282875)
37442	37442	179589	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	40 Bishop St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6010901.30709	2089684.5565099998	37.718490613421004	-122.404304111153	(37.718490613421, -122.404304111153)
37699	37699	240979	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	339 Cumberland St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6003404.476869999	2104454.46479	37.7586236232896	-122.431271257566	(37.7586236232896, -122.431271257566)
38357	38357	245351	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	3869 23rd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6003988.81275	2102446.15047	37.7531423642278	-122.429107164961	(37.7531423642278, -122.429107164961)
38857	38857	179580	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	210 Tocoloma Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6012727.00999	2087491.1806	37.7125698916572	-122.397839596325	(37.7125698916572, -122.397839596325)
38899	38899	197776	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1555 Mariposa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6012588.49637	2106082.79155	37.763610837098796	-122.399622872805	(37.7636108370988, -122.399622872805)
39037	39037	245258	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	268 29th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6004814.12133	2099029.08337	37.743806571309904	-122.42600985217699	(37.7438065713099, -122.426009852177)
39059	39059	240964	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	95 Eagle St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5999841.6611	2104454.60365	37.7584214521056	-122.443593061365	(37.7584214521056, -122.443593061365)
40231	40231	197798	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	444 Brannan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6013857.661619999	2111727.99067	37.779181957127705	-122.39562874528099	(37.7791819571277, -122.395628745281)
40303	40303	240858	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	99 Albion St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6005816.06228	2106764.13272	37.7651017997331	-122.42309505770399	(37.7651017997331, -122.423095057704)
40438	40438	118241	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	3550 Cabrillo St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5984541.487269999	2110427.39121	37.7739365547576	-122.496947894082	(37.7739365547576, -122.496947894082)
40883	40883	179592	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	33 Bishop St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6010924.14414	2089655.49375	37.7184120891289	-122.40422312811899	(37.7184120891289, -122.404223128119)
41069	41069	215167	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	616 Los Palmos Dr	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5996095.52716	2095987.5218099998	37.734958585052	-122.455936678249	(37.734958585052, -122.455936678249)
41775	41775	245240	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	812 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6009884.83098	2104450.7237	37.7589784688124	-122.408858889543	(37.7589784688124, -122.408858889543)
42202	42202	245346	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	465 Hill St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6003311.78535	2103285.69521	37.7554092070775	-122.43150838902399	(37.7554092070775, -122.431508389024)
42560	42560	245363	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	511 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6002381.78952	2105193.34277	37.760594394034904	-122.43486100945299	(37.7605943940349, -122.434861009453)
42647	42647	215146	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	143 De Montfort Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		5994847.73331	2091874.74645	37.723594206678	-122.459952875147	(37.723594206678, -122.459952875147)
42831	42831	215172	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	24 Arroyo Way	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		5998696.48615	2097465.41857	37.739165476004295	-122.447050603021	(37.7391654760043, -122.447050603021)
42955	42955	179583	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	299 Lathrop Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6012138.538380001	2086862.1031	37.71080977991289	-122.399829404828	(37.7108097799129, -122.399829404828)
44000	44000	245293	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	466 Clipper St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6002148.62366	2100924.94892	37.7488611659112	-122.435362089216	(37.7488611659112, -122.435362089216)
44214	44214	240863	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1706 Dolores St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 3ft		6005261.4426	2098375.64329	37.742037644429104	-122.42441665100401	(37.7420376444291, -122.424416651004)
44351	44351	245245	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	833 York St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6009947.06016	2104112.82939	37.7580541725802	-122.40861983445299	(37.7580541725802, -122.408619834453)
44604	44604	215143	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	600 Portola Dr	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 3ft		5997162.83414	2099722.45046	37.7452749915648	-122.452516088848	(37.7452749915648, -122.452516088848)
44665	44665	197758	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1221 Harrison St	4	: 4	Tree 1	Private 1			7	Width 3ft		6009958.32307	2109652.80645	37.773266313822205	-122.408971760735	(37.7732663138222, -122.408971760735)
44805	44805	215135	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	151 Garcia Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		5994656.8422	2099309.30963	37.7439967122691	-122.461151386338	(37.7439967122691, -122.461151386338)
45085	45085	245234	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	53 Dearborn St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6005838.114019999	2105765.07661	37.7623598720354	-122.422947773934	(37.7623598720354, -122.422947773934)
45123	45123	240878	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	3659 18th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6005159.4538	2105434.8452	37.7614148167731	-122.4252715088	(37.7614148167731, -122.4252715088)
45846	45846	215163	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	240 Manor Dr	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		5993891.801519999	2094104.36583	37.7296611735131	-122.463419061951	(37.7296611735131, -122.463419061951)
46445	46445	215164	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	240 Manor Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5993888.626019999	2094081.3696400002	37.7295978486555	-122.46342837174801	(37.7295978486555, -122.463428371748)
46716	46716	245340	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	4228 24th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6001671.27062	2101779.53299	37.7511805291699	-122.43707394872601	(37.7511805291699, -122.437073948726)
47752	47752	245357	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	31 Hancock St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6004081.16198	2105083.00593	37.760387772986896	-122.428975785716	(37.7603877729869, -122.428975785716)
48296	48296	245292	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	63 Homestead St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6000997.37048	2101302.44067	37.7498322196812	-122.43937016790301	(37.7498322196812, -122.439370167903)
48728	48728	245300	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	380 Laidley St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6003816.90225	2096620.0014099998	37.73713537429771	-122.42928624967699	(37.7371353742977, -122.429286249677)
49209	49209	245320	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	81 Santa Marina St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6006143.55393	2097608.69482	37.739981549619	-122.421312134673	(37.739981549619, -122.421312134673)
49490	49490	245362	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	407 Castro St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6002351.10882	2105711.87815	37.762016424547795	-122.435004205785	(37.7620164245478, -122.435004205785)
49744	49744	136530	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	3719 Scott St	2	: 4	Tree 1	Private 1			5	Width 3ft		6000612.037330001	2121116.27495	37.804214041307795	-122.442124765264	(37.8042140413078, -122.442124765264)
49791	49791	245281	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	3057 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6008365.239469999	2106190.88278	37.7636713111025	-122.414237487376	(37.7636713111025, -122.414237487376)
50644	50644	240867	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1706 Dolores St	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 3ft		6005262.928730001	2098348.03342	37.741961917912604	-122.424409549065	(37.7419619179126, -122.424409549065)
52269	52269	245298	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	4308 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6001127.124890001	2103336.48165	37.7554245899866	-122.43906723216601	(37.7554245899866, -122.439067232166)
52299	52299	197792	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	228 Connecticut St	2	: 4	Tree 1	Private 1			11	Width 3ft		6013148.353080001	2105968.0458	37.7633269624894	-122.397678442332	(37.7633269624894, -122.397678442332)
52444	52444	179581	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	238 Tocoloma Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6012679.41908	2087343.6153900002	37.7121620563027	-122.397993741039	(37.7121620563027, -122.397993741039)
52803	52803	197790	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	340 Arkansas St	1	: 4	Tree 1	Private 1			14	Width 3ft		6012898.48867	2105422.76056	37.7618158127736	-122.398504382391	(37.7618158127736, -122.398504382391)
52931	52931	179578	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	334 Prague St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6003779.11215	2089222.9943900001	37.716822702879895	-122.428889707996	(37.7168227028799, -122.428889707996)
52995	52995	197794	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	74 Ceres St	1	: 4	Tree 1	Private 1			17	Width 3ft		6013828.41074	2093793.76095	37.7299367959446	-122.394473821531	(37.7299367959446, -122.394473821531)
53059	53059	215170	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	634 Los Palmos Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5995982.01885	2096037.45526	37.735089174709394	-122.45633272349	(37.7350891747094, -122.45633272349)
53434	53434	215174	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	120 Bella Vista Way	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 3ft		5998431.33624	2097088.3182	37.7381148960726	-122.447940224956	(37.7381148960726, -122.447940224956)
53880	53880	197786	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1361 De Haro St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6012312.79275	2102115.8245099997	37.75270304633371	-122.40029780859899	(37.7527030463337, -122.400297808599)
53950	53950	240999	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	4216 17th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6000932.6284	2105832.90843	37.7622680998129	-122.439918845188	(37.7622680998129, -122.439918845188)
54026	54026	245256	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1069 Church St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6004447.76038	2102694.3827400003	37.7538499211567	-122.427537715797	(37.7538499211567, -122.427537715797)
54552	54552	245235	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	53 Dearborn St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6005837.96271	2105774.1752400002	37.762384846192205	-122.42294894395901	(37.7623848461922, -122.422948943959)
54891	54891	245311	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	20 Bronte St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6009348.5743	2097305.27728	37.7393286058425	-122.41020903812901	(37.7393286058425, -122.410209038129)
55542	55542	245247	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	68 Fair Oaks St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6005363.23318	2103328.32031	37.7556423041547	-122.424416883035	(37.7556423041547, -122.424416883035)
55639	55639	136525	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	135 Alhambra St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001630.4941	2120312.9240099997	37.8020662408156	-122.438542729569	(37.8020662408156, -122.438542729569)
56994	56994	215147	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	484 Faxon Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		5994798.24088	2091767.0172599999	37.7232955616299	-122.460116159654	(37.7232955616299, -122.460116159654)
57057	57057	240872	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	2913 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6007128.77683	2101405.53479	37.750462316192795	-122.41817474896999	(37.7504623161928, -122.41817474897)
57138	57138	245328	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	491 Bartlett St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6006823.984540001	2100907.35055	37.7490772550231	-122.419193411063	(37.7490772550231, -122.419193411063)
57237	57237	245266	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	318 27th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6004388.49214	2100174.16519	37.7469266378516	-122.427563141445	(37.7469266378516, -122.427563141445)
57741	57741	197755	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1221 Harrison St	1	: 4	Tree 1	Private 1			9	Width 3ft		6009884.52157	2109578.01203	37.773056811347104	-122.409221772263	(37.7730568113471, -122.409221772263)
58237	58237	240966	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	35 Yukon St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6000257.57162	2104733.0469400003	37.7592097006798	-122.442174649757	(37.7592097006798, -122.442174649757)
58457	58457	245238	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	3690 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6005055.83253	2105475.95262	37.761521833391	-122.425632817714	(37.761521833391, -122.425632817714)
58757	58757	245337	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	17 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6005775.45761	2099622.8344099997	37.7454911615972	-122.42272795985201	(37.7454911615972, -122.422727959852)
59107	59107	240874	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	3398 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6007232.87313	2100916.28761	37.7491248129683	-122.417780100367	(37.7491248129683, -122.417780100367)
59111	59111	215169	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	634 Los Palmos Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5996017.99501	2096027.04258	37.7350626492231	-122.456207589133	(37.7350626492231, -122.456207589133)
59571	59571	197783	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1695 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6012618.013259999	2105616.47326	37.762332075798795	-122.399488041942	(37.7623320757988, -122.399488041942)
59588	59588	245338	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	86 Milton St	1	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			6	Width 3ft		6003724.51998	2095305.9819900002	37.7335221447376	-122.429511974121	(37.7335221447376, -122.429511974121)
59952	59952	245236	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	53 Dearborn St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6005838.901959999	2105786.95682	37.7624199943988	-122.422946603908	(37.7624199943988, -122.422946603908)
60131	60131	240990	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	5 Beaver St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6002802.39539	2106779.35324	37.7649730662735	-122.43351967151699	(37.7649730662735, -122.433519671517)
60347	60347	245244	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	833 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6009944.72353	2104090.22905	37.7579919862624	-122.408626321254	(37.7579919862624, -122.408626321254)
60667	60667	179616	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	40 Holyoke St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6009268.033430001	2094013.4604599997	37.730285470282396	-122.410255158964	(37.7302854702824, -122.410255158964)
60775	60775	245308	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	621 Anderson St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6007813.446769999	2096012.18951	37.7356919021641	-122.41542532274401	(37.7356919021641, -122.415425322744)
60817	60817	240853	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	2801 Mariposa St	5	: 4	Tree 1	Private 1			13	Width 3ft		6009171.61206	2105893.21544	37.7628992467128	-122.41142745404	(37.7628992467128, -122.41142745404)
60828	60828	197771	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	398 Pennsylvania Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6014310.79788	2105214.47052	37.7613224716698	-122.393605150155	(37.7613224716698, -122.393605150155)
61011	61011	245289	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	4331 26th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6001724.43086	2100566.12065	37.7478518091225	-122.436803261779	(37.7478518091225, -122.436803261779)
61397	61397	240854	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	1072 Potrero Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6010485.0248	2102978.73078	37.7549703055524	-122.40667939245	(37.7549703055524, -122.40667939245)
61441	61441	245334	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	2824 22nd St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6009272.555790001	2103369.32738	37.7559748842511	-122.410900056516	(37.7559748842511, -122.410900056516)
61583	61583	241000	Undocumented 2	Syagrus romanzoffianum :: Queen Palm 142	4216 17th St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 3ft		6000915.57041	2105830.5674799997	37.7622607011037	-122.43997767434799	(37.7622607011037, -122.439977674348)

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