Street_Tree_List

Data source: data.sfgov.org

102 rows where SiteOrder = 2 and qSpecies = 66

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, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
9865	9865	122387	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	198 Vasquez Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Permit Number 779324	5994732.0	2099337.0	37.7440770679838	-122.460893516037	(37.7440770679838, -122.460893516037)
17038	17038	115537	Planning Code 138.1 required 4	Crataegus laevigata :: English Hawthorn 66	99X Lech Walesa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/08/2016 12:00:00 AM	3	3x10	Permit Number 770842	6007116.502280001	2111387.72892	37.7778703965252	-122.41892509804701	(37.7778703965252, -122.418925098047)
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)
25180	25180	126376	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	122 Cervantes Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6001336.2876	2121154.5777	37.8043604581295	-122.43962119477399	(37.8043604581295, -122.439621194774)
25343	25343	183040	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2562 21st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 0ft		5989885.4338	2097934.2198	37.739945333152	-122.477549168466	(37.739945333152, -122.477549168466)
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)
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)
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)
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)
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)
34651	34651	31752	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	2642 21st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/1995 12:00:00 AM	7		Permit Number 35239	5989905.4007	2097381.577	37.738429077279896	-122.47743975125601	(37.7384290772799, -122.477439751256)
36687	36687	206698	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	860 Teresita Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 10ft		5998920.6207	2095542.64427	37.7338987978865	-122.446137381059	(37.7338987978865, -122.446137381059)
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)
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)
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)
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)
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)
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)
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)
51326	51326	94076	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	629 Los Palmos Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/02/2010 12:00:00 AM		2x4	Permit Number 53465	5996116.0	2095941.0	37.734832022473	-122.45586253488399	(37.734832022473, -122.455862534884)
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)
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)
57368	57368	206595	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	135 Magellan Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 4ft		5995084.10326	2100870.93077	37.7483091116899	-122.45978711747601	(37.7483091116899, -122.459787117476)
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)
57958	57958	183317	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1209 41st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5983329.0993	2106834.4338	37.7640002060456	-122.50087591440399	(37.7640002060456, -122.500875914404)
58192	58192	31751	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	2546 21st Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/1995 12:00:00 AM	9		Permit Number 35238	5989883.0648	2098033.3774	37.7402174568148	-122.477564605136	(37.7402174568148, -122.477564605136)
58539	58539	206598	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	150 Magellan Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 4ft		5995052.00135	2100847.98673	37.74824426696271	-122.45989646247601	(37.7482442669627, -122.459896462476)
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)
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)
66433	66433	95111	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	649 Cayuga Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/28/2010 12:00:00 AM	3	3x3	Permit Number 54039	6001701.74477	2093288.67335	37.727868340851295	-122.43636094730101	(37.7278683408513, -122.436360947301)
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)
66495	66495	206683	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	647 Los Palmos Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5995995.17419	2096006.3401799998	37.7350044954584	-122.45628499197399	(37.7350044954584, -122.456284991974)
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)
67024	67024	206497	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1616 08th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		5993722.387569999	2104477.6450099996	37.7581338201448	-122.464757733396	(37.7581338201448, -122.464757733396)
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)
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)
72284	72284	206690	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	616 Los Palmos Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5996131.5818	2095962.98776	37.7348932897948	-122.45581025245001	(37.7348932897948, -122.45581025245)
74880	74880	41229	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	3618 Webster St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/30/1999 12:00:00 AM	5	3x3	Permit Number 41935	6002621.77288	2121066.97203	37.8041929962699	-122.435166401228	(37.8041929962699, -122.435166401228)
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)
76521	76521	223030	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	125 Belgrave Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 2ft		5997950.67072	2104889.0935	37.759506423000204	-122.450164233094	(37.7595064230002, -122.450164233094)
77448	77448	45122	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	201 Buena Vista Ave East	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/14/2001 12:00:00 AM			Permit Number 43980	6001449.9	2108254.9	37.7689477239633	-122.438303322299	(37.7689477239633, -122.438303322299)
77548	77548	51448	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	326 Bocana St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/19/2004 12:00:00 AM			Permit Number 47765	6006818.05257651	2097195.51767411	37.7388850615796	-122.41895069494	(37.7388850615796, -122.41895069494)
80996	80996	116196	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	3751 CLAY ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5996888.0	2115293.0	37.7880119756846	-122.454591065245	(37.7880119756846, -122.454591065245)
81114	81114	41708	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	203 Surrey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/2000 12:00:00 AM			Permit Number 42156	6002096.90165519	2096076.31860804	37.7355450223799	-122.43519418820401	(37.7355450223799, -122.435194188204)
84031	84031	40752	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	54 Cerritos Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	08/13/1999 12:00:00 AM			Permit Number 41722	5992568.54395141	2093000.42735623	37.726553703659995	-122.46791340088001	(37.72655370366, -122.46791340088)
87649	87649	121661	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	860 Teresita Blvd	2	Sidewalk: Property side : Cutout 5	Tree 1	Private 1				3x3		5998939.0	2095554.0	37.7339310276146	-122.44607465500401	(37.7339310276146, -122.446074655004)
91434	91434	51948	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	1506 Willard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 48172	5996897.19536074	2106034.05471344	37.7625898542367	-122.453890338129	(37.7625898542367, -122.453890338129)
96209	96209	82955	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	660X Clementina St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/11/2005 12:00:00 AM	3	3x3		6009636.0	2110586.0	37.7758105844997	-122.41015262108601	(37.7758105844997, -122.410152621086)
96973	96973	43489	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	731 Banks St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/19/2000 12:00:00 AM			Permit Number 43170	6008504.61569086	2095547.09041526	37.734453664768296	-122.413002801242	(37.7344536647683, -122.413002801242)
107733	107733	84504	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	650X Clementina St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	10/14/2006 12:00:00 AM	3	3x3		6009485.16866501	2110503.49163991	37.775575580460206	-122.410668559049	(37.7755755804602, -122.410668559049)
107937	107937	39659	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	311 Grafton Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/29/1998 12:00:00 AM			Permit Number 41051	5995887.27205834	2090529.96858098	37.7199614976995	-122.45626220721901	(37.7199614976995, -122.456262207219)
113070	113070	51536	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	4138 20th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/18/2005 12:00:00 AM			Permit Number 47837	6002788.00139397	2104180.95255656	37.7578376687282	-122.43338376260901	(37.7578376687282, -122.433383762609)
117825	117825	41697	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	1 Mizpah St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/2000 12:00:00 AM			Permit Number 42148	6001073.51924875	2096662.39464483	37.7370960833617	-122.43877438618	(37.7370960833617, -122.43877438618)
119316	119316	206672	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	370 Yerba Buena Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995263.98331	2095214.4393900002	37.732788127968995	-122.458755649049	(37.732788127969, -122.458755649049)
121572	121572	42999	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	201 Rose St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/05/2000 12:00:00 AM			Permit Number 42873	6005609.30796774	2109736.9244771	37.7732527046739	-122.424021592666	(37.7732527046739, -122.424021592666)
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)
126743	126743	223043	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	4107 Ogden Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6008381.78974	2096055.8705400003	37.735843768863795	-122.413463422917	(37.7358437688638, -122.413463422917)
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)
129441	129441	94071	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	616 Los Palmos Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/02/2010 12:00:00 AM		2x4	Permit Number 53462	5996098.0	2095984.0	37.734949056945204	-122.455927874303	(37.7349490569452, -122.455927874303)
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)
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)
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)
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)
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)
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)
138305	138305	39661	Permitted Site 1	Crataegus laevigata :: English Hawthorn 66	316 Grafton Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	12/29/1998 12:00:00 AM			Permit Number 41052	5995871.10695115	2090582.25350935	37.7201041317861	-122.456321862645	(37.7201041317861, -122.456321862645)
139071	139071	122405	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	340 Magellan Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x6		5994085.0	2099826.0	37.74538248907739	-122.46316615516001	(37.7453824890774, -122.46316615516)
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)
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)
151039	151039	206692	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	582 Los Palmos Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5996416.06092	2095880.8714400001	37.7346841407625	-122.45482078325199	(37.7346841407625, -122.454820783252)
151724	151724	206687	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	629 Los Palmos Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5996087.4467400005	2095957.96527	37.7348769661929	-122.45596247889	(37.7348769661929, -122.45596247889)
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)
152052	152052	223044	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	13 Stoneman St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6008324.57166	2099444.87133	37.7451460071793	-122.413900908902	(37.7451460071793, -122.413900908902)
153105	153105	206509	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1023 Lawton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		5990938.9472	2104480.79856	37.75798161076639	-122.47438420248501	(37.7579816107664, -122.474384202485)
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)
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)
155591	155591	206679	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	657 Los Palmos Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5995939.36036	2096013.8239	37.7350218397738	-122.456478499997	(37.7350218397738, -122.456478499997)
156749	156749	126384	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1120 Greenwich St	2	Front Yard : Yard 7	Tree 1	Private 1			4			6007500.24433	2119896.2377400002	37.8012542708165	-122.418200985801	(37.8012542708165, -122.418200985801)
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)
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)
157581	157581	206499	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	245 Lawton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		5993488.07663	2104571.6485200003	37.7583784177465	-122.46557490416001	(37.7583784177465, -122.46557490416)
158004	158004	223037	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	203 Surrey St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6002071.560219999	2096098.27883	37.7356038810064	-122.435283373351	(37.7356038810064, -122.435283373351)
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)
162977	162977	223033	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	281 Richland Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6006248.27078	2096110.4955099998	37.735873731571395	-122.420843728155	(37.7358737315714, -122.420843728155)
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)
165652	165652	206674	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	300 Yerba Buena Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5995208.64941	2095407.77696	37.7333158051714	-122.458960944512	(37.7333158051714, -122.458960944512)
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)
171923	171923	206534	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	665 Miramar Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		5995362.10243	2093779.40423	37.7288535085691	-122.45831259717501	(37.7288535085691, -122.458312597175)
173302	173302	183679	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	3627 Irving St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5984438.7811	2106305.4338	37.7626128114068	-122.49699886391899	(37.7626128114068, -122.496998863919)
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)
175342	175342	200074	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1500 Van Dyke Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		6014921.0644	2093162.4986	37.728264158228896	-122.39065226097	(37.7282641582289, -122.39065226097)
175387	175387	126379	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1136 Havens St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7	Width 7ft		6007507.74968	2119357.27743	37.7997748437807	-122.418136782297	(37.7997748437807, -122.418136782297)
176247	176247	206515	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	1019 Lawton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		5991033.61709	2104484.17502	37.7579963659675	-122.47405704351601	(37.7579963659675, -122.474057043516)
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)
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)
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)
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)
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)

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