Street_Tree_List

Data source: data.sfgov.org

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

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
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)
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)
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)
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)
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)
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)
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)
27743	27743	206657	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	41 Alton Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994149.03126	2101531.53277	37.7500691388799	-122.463068471138	(37.7500691388799, -122.463068471138)
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)
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)
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)
29530	29530	218122	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	45 Lopez Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5994032.10421	2100668.86964	37.7476937487685	-122.463410213512	(37.7476937487685, -122.463410213512)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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