Street_Tree_List

Data source: data.sfgov.org

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

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
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)
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)
26518	26518	206504	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1959 10th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5993136.05327	2102151.01657	37.7517116786758	-122.46661639913602	(37.7517116786758, -122.466616399136)
28309	28309	206505	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1965 10th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5993138.76599	2102124.2403700002	37.7516383146611	-122.46660507218701	(37.7516383146611, -122.466605072187)
33381	33381	206506	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1985 10th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5993143.71774	2101970.98373	37.7512177970674	-122.46657681008301	(37.7512177970674, -122.466576810083)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
29329	29329	206551	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	308 Pacheco St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994320.14066	2100781.15308	37.74801864146029	-122.462422349606	(37.7480186414603, -122.462422349606)
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)
33057	33057	206553	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	352 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 3ft		5994206.928780001	2101186.05332	37.74912387497	-122.462843199074	(37.74912387497, -122.462843199074)
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)
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)
27341	27341	206556	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	32 Sotelo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5993935.86279	2101082.16601	37.7488230103837	-122.463773001819	(37.7488230103837, -122.463773001819)
24031	24031	206557	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	517 Laguna Honda Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5995503.23656	2100160.4413400004	37.7463823798599	-122.458286357642	(37.7463823798599, -122.458286357642)
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)
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)
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)
23989	23989	206572	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	51 Cortes Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5993215.16949	2099646.04946	37.7448382439064	-122.466160788211	(37.7448382439064, -122.466160788211)
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)
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)
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)
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)
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)
33279	33279	206578	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	275 Dorantes Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993312.03833	2099686.0969	37.7449537923783	-122.46582874591199	(37.7449537923783, -122.465828745912)
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)
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)
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)
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)
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)
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)
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)
34016	34016	206586	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	360 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5993997.55659	2099722.78299	37.745094043463396	-122.46346102880699	(37.7450940434634, -122.463461028807)
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)
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)
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)
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)
30002	30002	206592	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	101 Montalvo Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5993721.8716	2099672.6551599996	37.744940517497	-122.464410652624	(37.744940517497, -122.464410652624)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
27805	27805	206612	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	49 Sola Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5994889.66342	2100721.49656	37.7478876192364	-122.460448654307	(37.7478876192364, -122.460448654307)
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)
25120	25120	206614	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	432 Dewey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5995034.15561	2100336.79731	37.7468396428317	-122.45992114704399	(37.7468396428317, -122.459921147044)
539	539	206615	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	198 Vasquez Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft	Permit Number 779324	5994758.52704	2099346.29484	37.7441041156281	-122.460802465585	(37.7441041156281, -122.460802465585)
553	553	206616	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	198 Vasquez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft	Permit Number 779324	5994742.56026	2099334.6803900003	37.7440713065495	-122.460856833195	(37.7440713065495, -122.460856833195)
565	565	206617	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	198 Garcia Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5994686.63181	2099351.09779	37.7441131663853	-122.461051409618	(37.7441131663853, -122.461051409618)
571	571	206618	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	198 Garcia Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft	Permit Number 779324	5994673.79551	2099409.87557	37.7442738167873	-122.461100053935	(37.7442738167873, -122.461100053935)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
24597	24597	206648	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	180 Castenada Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994513.85188	2100887.12446	37.748320765087	-122.46176019139799	(37.748320765087, -122.461760191398)
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)
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)
29674	29674	206651	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 Castenada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994510.63767	2100971.03236	37.7485509699531	-122.461777389118	(37.7485509699531, -122.461777389118)

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