Street_Tree_List

Data source: data.sfgov.org

170 rows where PlotSize = "Width 3ft" 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, qSiteInfo, DBH, PermitNotes

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
131438	131438	126378	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1976 Green St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6003585.79025	2118315.11213	37.7966917978451	-122.431633760802	(37.7966917978451, -122.431633760802)
186978	186978	190925	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	651 Kansas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6011562.1933699995	2105343.91486	37.761524784975	-122.40312057635	(37.761524784975, -122.40312057635)
61905	61905	190927	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1050 Wisconsin St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 3ft		6012767.00645	2102579.68997	37.7540020378723	-122.39875959738	(37.7540020378723, -122.39875959738)
72707	72707	190928	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1778 Quesada Ave	1	: 4	Tree 1	Private 1			4	Width 3ft		6014320.53257	2095360.07162	37.73426491189	-122.39288202418301	(37.73426491189, -122.392882024183)
51810	51810	206519	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2280 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5991734.05463	2099933.45812	37.7455418303067	-122.471303093689	(37.7455418303067, -122.471303093689)
66610	66610	206520	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2290 15th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5991725.72943	2099875.90905	37.7453833337792	-122.47132768833099	(37.7453833337792, -122.471327688331)
62392	62392	206521	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2290 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5991723.002619999	2099864.63418	37.7453522181485	-122.471336295754	(37.7453522181485, -122.471336295754)
153437	153437	206522	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2204 17th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5991046.63721	2100321.91518	37.7465686447317	-122.47370838535801	(37.7465686447317, -122.473708385358)
132461	132461	206523	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2690 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5991790.63989	2097130.86053	37.737849885658	-122.470903312649	(37.737849885658, -122.470903312649)
74719	74719	206524	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	35 Madrone Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992940.67499	2098878.9332	37.742716096581894	-122.467054169341	(37.7427160965819, -122.467054169341)
26843	26843	206525	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	35 Madrone Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5992946.5083	2098897.01812	37.7427660898953	-122.46703531413	(37.7427660898953, -122.46703531413)
50429	50429	206526	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	35 Madrone Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5992953.91132	2098913.47299	37.742811698104205	-122.467010912843	(37.7428116981042, -122.467010912843)
132226	132226	206527	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	13 Madrone Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992983.90563	2098997.49136	37.7430441224891	-122.46691330850099	(37.7430441224891, -122.466913308501)
50360	50360	206528	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	13 Madrone Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992986.65204	2099006.05822	37.7430678034305	-122.466904434898	(37.7430678034305, -122.466904434898)
148248	148248	206529	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	13 Madrone Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992989.732419999	2099015.25675	37.7430932380525	-122.466894452432	(37.7430932380525, -122.466894452432)
70255	70255	206531	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 San Aleso Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5993348.57217	2094559.38972	37.730879244086296	-122.46533008801399	(37.7308792440863, -122.465330088014)
166442	166442	206532	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	160 San Aleso Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5993345.963169999	2094536.94274	37.730817459756	-122.46533747775	(37.730817459756, -122.46533747775)
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)
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)
181759	181759	206559	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	355 Yerba Buena Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 3ft		5995306.63453	2095221.10602	37.7328088843117	-122.458608676455	(37.7328088843117, -122.458608676455)
30299	30299	206560	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	355 Yerba Buena Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 3ft		5995304.48103	2095229.25095	37.7328311245367	-122.458616711016	(37.7328311245367, -122.458616711016)
30345	30345	206561	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	355 Yerba Buena Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 3ft		5995302.34368	2095238.1668900002	37.732855482695	-122.458624745542	(37.732855482695, -122.458624745542)
64939	64939	206563	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2047 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5993157.06576	2101533.95115	37.750018588	-122.466498890138	(37.750018588, -122.466498890138)
189037	189037	206564	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2044 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5993156.7665	2101574.66751	37.7501303674196	-122.46650288401399	(37.7501303674196, -122.466502884014)
75089	75089	206565	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2679 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5991740.0000599995	2097213.7223099996	37.7380744742606	-122.471084432514	(37.7380744742606, -122.471084432514)
186945	186945	206566	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2679 15th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5991741.264830001	2097200.972	37.738039538296206	-122.471079130991	(37.7380395382962, -122.471079130991)
185359	185359	206567	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2523 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5991381.7608900005	2098233.80223	37.74085462674589	-122.472397375252	(37.7408546267459, -122.472397375252)
75714	75714	206568	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2515 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5991380.56657	2098286.2467799997	37.7409985569439	-122.472405327055	(37.7409985569439, -122.472405327055)
171063	171063	206569	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2435 14th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5992009.07535	2098867.5883299997	37.7426311295378	-122.47027451837099	(37.7426311295378, -122.470274518371)
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)
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)
175013	175013	206619	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	181 Lawton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5994070.38957	2104649.5630900003	37.758625920162295	-122.463566678468	(37.7586259201623, -122.463566678468)
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)
132401	132401	206621	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1912 10th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5993175.256709999	2102431.1044799997	37.7524829903015	-122.46650118519301	(37.7524829903015, -122.466501185193)
49647	49647	206622	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1912 10th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5993175.38418	2102417.55667	37.752445798858396	-122.466499759777	(37.7524457988584, -122.466499759777)
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)
70281	70281	206632	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	99 Castenada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5994454.48924	2101216.21265	37.749220940594604	-122.46198932515	(37.7492209405946, -122.46198932515)
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)
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)

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