Street_Tree_List

Data source: data.sfgov.org

121 rows where qSiteInfo = 2 and qSpecies = 66 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: SiteOrder, DBH, PlotSize

Link	rowid ▲	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
188058	188058	206537	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	401 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994067.3294	2101503.80633	37.7499883024325	-122.46334898679	(37.7499883024325, -122.46334898679)
187736	187736	206608	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2 Sola Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5994960.813709999	2100721.5804	37.7478919422595	-122.460202627649	(37.7478919422595, -122.460202627649)
186378	186378	206627	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	40 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994076.75455	2101874.6545700002	37.751007100296604	-122.463343302157	(37.7510071002966, -122.463343302157)
185968	185968	206624	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	80 Ventura Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994298.51296	2101800.2527099997	37.7508155851791	-122.46257104893	(37.7508155851791, -122.46257104893)
184549	184549	206626	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	40 Ventura Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994084.99265	2101862.2244599997	37.750973444992205	-122.46331391231199	(37.7509734449922, -122.463313912312)
182763	182763	206550	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	308 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5994328.73662	2100761.78102	37.7479659456765	-122.46239122047199	(37.7479659456765, -122.462391220472)
181807	181807	206656	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	45 Alton Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994277.8238699995	2101540.85875	37.75010216378529	-122.46262377888	(37.7501021637853, -122.46262377888)
179119	179119	206587	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	348 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994044.71238	2099771.06427	37.745229328484704	-122.46330147648099	(37.7452293284847, -122.463301476481)
177772	177772	206633	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	145 Castenada Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994552.3071099995	2100925.23177	37.7484276117632	-122.461629977659	(37.7484276117632, -122.461629977659)
176273	176273	206546	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	265 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5994442.894180001	2100449.8026	37.747115904674004	-122.46197385141399	(37.747115904674, -122.461973851414)
175120	175120	206659	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	41 Alton Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5994198.61036	2101541.1054	37.750098278721	-122.462897719553	(37.750098278721, -122.462897719553)
174659	174659	206543	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	347 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994159.12368	2101087.0695700003	37.7488493371331	-122.463001327749	(37.7488493371331, -122.463001327749)
174439	174439	206625	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	80 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5994283.13326	2101793.571	37.7507963531822	-122.46262374828999	(37.7507963531822, -122.46262374829)
172567	172567	206643	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	196 Castenada Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994392.211730001	2100761.6142700003	37.74796914278121	-122.462171715751	(37.7479691427812, -122.462171715751)
171736	171736	206609	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	44 Sola Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994867.729069999	2100768.79557	37.7480162285692	-122.46052792862601	(37.7480162285692, -122.460527928626)
171384	171384	206647	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Castenada Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994503.49405	2100867.53113	37.748266370491	-122.461794587759	(37.748266370491, -122.461794587759)
170709	170709	206644	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994467.924	2100831.48615	37.748165352368105	-122.46191497372	(37.7481653523681, -122.46191497372)
170563	170563	206605	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 Magellan Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5995038.86988	2100730.57279	37.7479211225827	-122.459933366148	(37.7479211225827, -122.459933366148)
168564	168564	206601	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5995052.26314	2100785.00395	37.7480713471357	-122.45989099549601	(37.7480713471357, -122.459890995496)
167733	167733	206503	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1957 10th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5993135.46016	2102179.05998	37.751788644440495	-122.46662048837	(37.7517886444405, -122.46662048837)
165477	165477	206591	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	101 Montalvo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5993709.625030001	2099698.37793	37.745010439781296	-122.464454865994	(37.7450104397813, -122.464454865994)
165454	165454	206630	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	81 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994323.8061	2101846.4166200003	37.7509437961254	-122.46248693172701	(37.7509437961254, -122.462486931727)
164769	164769	206602	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 Magellan Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5995047.859019999	2100763.4476	37.7480119055303	-122.45990466338101	(37.7480119055303, -122.459904663381)
164232	164232	206634	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	145 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994552.462069999	2100915.6770099998	37.748401385725	-122.461628749166	(37.748401385725, -122.461628749166)
162090	162090	206642	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	196 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994408.53923	2100777.89876	37.7480147959636	-122.46211643714899	(37.7480147959636, -122.462116437149)
161837	161837	206649	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Castenada Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994518.46873	2100904.0082799997	37.7483673895631	-122.461745450587	(37.7483673895631, -122.461745450587)
158121	158121	206588	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	348 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994058.29292	2099782.40477	37.7452612490171	-122.463255340382	(37.7452612490171, -122.463255340382)
157297	157297	206589	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	340 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5994086.716030001	2099812.2565200003	37.7453448518007	-122.463159224416	(37.7453448518007, -122.463159224416)
157129	157129	206655	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	45 Alton Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994255.40167	2101538.8525799997	37.7500953640099	-122.462701170033	(37.7500953640099, -122.462701170033)
156496	156496	206639	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	175 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994510.39425	2100823.8744099997	37.748146897381794	-122.461767562235	(37.7481468973818, -122.461767562235)
154984	154984	206629	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	81 Ventura Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994298.95446	2101835.26425	37.7509117433916	-122.46257206157101	(37.7509117433916, -122.462572061571)
153873	153873	206585	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	368 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993961.3420400005	2099692.54098	37.745008919941	-122.463584056983	(37.745008919941, -122.463584056983)
153258	153258	206575	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	120 Montalvo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5993692.18131	2099632.63233	37.744828913423	-122.464510409921	(37.744828913423, -122.464510409921)
152678	152678	206603	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 Magellan Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5995045.25769	2100752.48094	37.7479816442318	-122.459912864313	(37.7479816442318, -122.459912864313)
151744	151744	218121	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	45 Lopez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5994024.91011	2100655.57636	37.7476568343048	-122.463434125583	(37.7476568343048, -122.463434125583)
151567	151567	206554	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	47 Sotelo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5993895.61602	2101166.1129900003	37.749051188161296	-122.46391826663401	(37.7490511881613, -122.463918266634)
150435	150435	206545	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	265 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5994446.422040001	2100465.35227	37.747158803252	-122.461962779858	(37.747158803252, -122.461962779858)
148911	148911	206583	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Dorantes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5993643.85712	2099778.24608	37.7452259461282	-122.464688076401	(37.7452259461282, -122.464688076401)
148350	148350	206542	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	351 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994154.36407	2101104.3868400003	37.748896611800106	-122.46301904261999	(37.7488966118001, -122.46301904262)
137122	137122	206507	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1985 10th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5993144.62205	2101960.97627	37.751190371338	-122.46657295558599	(37.751190371338, -122.466572955586)
137065	137065	182595	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	955 Rivera St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5990177.9035	2100379.6188	37.746676731738894	-122.4767165565	(37.7466767317389, -122.4767165565)
134876	134876	206558	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	517 Laguna Honda Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5995506.851369999	2100151.8642599997	37.7463590370584	-122.458273237436	(37.7463590370584, -122.458273237436)
134479	134479	206645	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994475.58114	2100840.87711	37.748191578392294	-122.461889176638	(37.7481915783923, -122.461889176638)
133979	133979	206590	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	340 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994099.18491	2099823.6206900002	37.745376773231	-122.463116933812	(37.745376773231, -122.463116933812)
133199	133199	206579	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	275 Dorantes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993299.1056	2099684.88554	37.744949720257004	-122.46587337656601	(37.744949720257, -122.465873376566)
130265	130265	206637	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	159 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994549.87925	2100894.15199	37.7483421347836	-122.461636120028	(37.7483421347836, -122.461636120028)
126753	126753	206613	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	432 Dewey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5995024.84981	2100327.10403	37.746812492318604	-122.459952623323	(37.7468124923186, -122.459952623323)
122539	122539	190926	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1303 Rhode Island St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 7ft		6012003.88758	2102215.75937	37.7529602155494	-122.40137308660401	(37.7529602155494, -122.401373086604)
114401	114401	206552	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	308 Pacheco St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5994313.1172	2100803.87721	37.7480806317257	-122.462448284279	(37.7480806317257, -122.462448284279)
76722	76722	206547	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	120 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5993889.308780001	2099967.60077	37.7457600139093	-122.463853094571	(37.7457600139093, -122.463853094571)
76418	76418	206650	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Castenada Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994518.14401	2100922.4103	37.748417898168995	-122.461747907542	(37.748417898169, -122.461747907542)
75436	75436	206640	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	175 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994518.44354	2100835.0258299997	37.7481779797266	-122.46174053670201	(37.7481779797266, -122.461740536702)
74950	74950	206661	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	390 Pacheco St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994161.93741	2101486.33597	37.7499457833913	-122.463020562465	(37.7499457833913, -122.463020562465)
74465	74465	206646	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Castenada Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994489.718859999	2100854.37735	37.7482294605322	-122.46184126797701	(37.7482294605322, -122.461841267977)
74247	74247	206636	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	159 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994544.936980001	2100878.69027	37.7482993963164	-122.461652089281	(37.7482993963164, -122.461652089281)
72889	72889	206577	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	215 Dorantes Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5993636.2641900005	2099712.16168	37.745044057332294	-122.464709533316	(37.7450440573323, -122.464709533316)
72855	72855	206620	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2105 09th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5993657.1596800005	2101227.85905	37.7492069822304	-122.464747327347	(37.7492069822304, -122.464747327347)
72564	72564	206631	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	89 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994365.2652199995	2101880.85976	37.7510407556506	-122.462346061026	(37.7510407556506, -122.462346061026)
69850	69850	206611	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	49 Sola Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994869.30829	2100730.97603	37.7479124764813	-122.460519727717	(37.7479124764813, -122.460519727717)
69565	69565	206610	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	49 Sola Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5994851.290519999	2100738.8321	37.7479330107067	-122.46058260112	(37.7479330107067, -122.46058260112)
68999	68999	206663	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	390 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994181.82756	2101452.31219	37.7498535084399	-122.46294931367399	(37.7498535084399, -122.462949313674)
68099	68099	206662	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	390 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994173.63187	2101468.0491400003	37.749896246027106	-122.462978796147	(37.7498962460271, -122.462978796147)
67067	67067	206660	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	41 Alton Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994227.712619999	2101539.78712	37.750096335277796	-122.462796987411	(37.7500963352778, -122.462796987411)
66581	66581	206606	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 Magellan Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5995035.92285	2100721.97488	37.747897345392	-122.459942934033	(37.747897345392, -122.459942934033)
66445	66445	206538	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	399 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994103.277319999	2101446.93652	37.749834223367294	-122.463220551898	(37.7498342233673, -122.463220551898)
66424	66424	206580	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	275 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993286.92729	2099684.15258	37.7449470052046	-122.46591543334401	(37.7449470052046, -122.465915433344)
64527	64527	206668	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	15 Sotelo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993998.36893	2100916.3469700003	37.7483713150869	-122.46354482495501	(37.7483713150869, -122.463544824955)
63202	63202	206604	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 Magellan Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5995043.01031	2100739.53906	37.747945979831	-122.45991969824	(37.747945979831, -122.45991969824)
62866	62866	206570	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	4 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5993230.1067699995	2099675.67045	37.7449204374235	-122.46611129043	(37.7449204374235, -122.46611129043)
61321	61321	206667	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	15 Sotelo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993986.73582	2100929.3593	37.74840637335971	-122.46358599590499	(37.7484063733597, -122.463585995905)
59046	59046	206654	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	45 Alton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994247.90783	2101537.24109	37.7500905076701	-122.46272696707399	(37.7500905076701, -122.462726967074)
58785	58785	206665	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	11 Santa Rita Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5993870.76921	2100887.71242	37.748285339014295	-122.463983980089	(37.7482853390143, -122.463983980089)
58009	58009	206641	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	196 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994436.73351	2100801.00946	37.748079875384796	-122.462020618849	(37.7480798753848, -122.462020618849)
57787	57787	206540	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	387 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994134.95664	2101369.7507	37.7496241156629	-122.46310540451401	(37.7496241156629, -122.463105404514)
56319	56319	206573	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	51 Cortes Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993216.90415	2099626.41246	37.7447844257663	-122.466153363383	(37.7447844257663, -122.466153363383)
56263	56263	206670	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	15 Sotelo Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994011.71818	2100897.82655	37.7483212318599	-122.463497320046	(37.7483212318599, -122.463497320046)
56091	56091	206541	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	375 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994147.31458	2101302.53521	37.7494402708691	-122.463057794403	(37.7494402708691, -122.463057794403)
55162	55162	206635	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	145 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994551.94388	2100907.9053700003	37.7483800169362	-122.461629977657	(37.7483800169362, -122.461629977657)
54773	54773	206638	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	167 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994538.83302	2100858.6540099997	37.7482440304446	-122.46167174395	(37.7482440304446, -122.46167174395)
53756	53756	206652	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994516.45103	2100943.3174900003	37.74847520657389	-122.4617552775	(37.7484752065739, -122.4617552775)
52949	52949	206549	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	308 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994338.43004	2100748.81738	37.7479309089808	-122.462356761175	(37.7479309089808, -122.462356761175)
51397	51397	206539	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	393 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994118.07071	2101419.5251	37.749759810788	-122.46316740736499	(37.749759810788, -122.463167407365)
51395	51395	206653	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	150 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5994496.6283	2101014.48441	37.748669471824	-122.46182898323	(37.748669471824, -122.46182898323)
49506	49506	206607	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2 Sola Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5994975.69537	2100714.97086	37.7478746501056	-122.460150689128	(37.7478746501056, -122.460150689128)
49358	49358	206666	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	15 Sotelo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5993976.53914	2100938.08553	37.74842974584271	-122.46362188875901	(37.7484297458427, -122.463621888759)
47868	47868	206574	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	120 Montalvo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5993698.095930001	2099619.5133	37.744793232835605	-122.464489006068	(37.7447932328356, -122.464489006068)
46146	46146	206555	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	47 Sotelo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5993893.29504	2101174.89341	37.74907516320621	-122.463926929805	(37.7490751632062, -122.463926929805)
45428	45428	206576	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	100 Montalvo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5993684.51151	2099645.64672	37.744864205510204	-122.46453787523501	(37.7448642055102, -122.464537875235)
44510	44510	218322	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	420 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5993190.15092	2099959.3697	37.745697098249394	-122.466270063011	(37.7456970982494, -122.466270063011)
44246	44246	206584	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5993659.8453	2099783.1011200002	37.745240198571295	-122.464633144905	(37.7452401985713, -122.464633144905)
43524	43524	206628	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	20 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5994037.30563	2101977.91794	37.7512883623694	-122.463487212563	(37.7512883623694, -122.463487212563)
42406	42406	182596	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	945 Rivera St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5990197.9307	2100380.5725	37.746680511997496	-122.47664737488998	(37.7466805119975, -122.47664737489)
41542	41542	206581	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	190 Dorantes Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5993591.13879	2099773.66773	37.745210335700605	-122.46487003355301	(37.7452103357006, -122.464870033553)
40559	40559	206571	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	51 Cortes Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5993219.180819999	2099666.63445	37.7448949964991	-122.466148413523	(37.7448949964991, -122.466148413523)
40135	40135	206582	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	190 Dorantes Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5993610.53275	2099775.23813	37.745215765798996	-122.464803087101	(37.745215765799, -122.464803087101)
39798	39798	206669	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	15 Sotelo Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994007.62455	2100906.4247	37.74834460433671	-122.463512099503	(37.7483446043367, -122.463512099503)
39280	39280	206536	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	401 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994052.44062	2101520.15999	37.7500323476354	-122.463401659183	(37.7500323476354, -122.463401659183)
39199	39199	206623	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1964 08th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993824.3832	2102096.20379	37.7516008749812	-122.464232103026	(37.7516008749812, -122.464232103026)
35264	35264	206544	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	337 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5994178.74316	2101030.22278	37.7486943803622	-122.462929360401	(37.7486943803622, -122.462929360401)
34122	34122	206658	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	41 Alton Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994157.02115	2101539.85513	37.7500924502117	-122.463041445619	(37.7500924502117, -122.463041445619)

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