Street_Tree_List

Data source: data.sfgov.org

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

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)
1013	1013	223102	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	247 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		04/27/2017 12:00:00 AM	3	Width 3ft	Permit Number 779888	6004283.79281	2099537.35517	37.74517218196571	-122.42787981341101	(37.7451721819657, -122.427879813411)
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)
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)
25265	25265	223034	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	578 Moultrie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6007664.494030001	2096661.03983	37.7374651296141	-122.41598624606199	(37.7374651296141, -122.415986246062)
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)
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)
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)
29986	29986	206673	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	370 Yerba Buena Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995261.57654	2095226.1050200001	37.7328200206111	-122.45876481406201	(37.7328200206111, -122.458764814062)
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)
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)
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)
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)
34880	34880	206682	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	647 Los Palmos Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5995986.285069999	2096009.4987	37.7350126577011	-122.45631595293699	(37.7350126577011, -122.456315952937)
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)
39350	39350	223040	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	567 Moultrie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6007699.61186	2096703.5074099998	37.7375837106174	-122.41586783322799	(37.7375837106174, -122.415867833228)
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)
40226	40226	223024	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	979 York St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6009975.926030001	2103539.78877	37.756482348291996	-122.40847958248399	(37.756482348292, -122.408479582484)
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)
42708	42708	206685	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	641 Los Palmos Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5996053.59921	2095980.96691	37.734938180348	-122.45608116333099	(37.734938180348, -122.456081163331)
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)
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)
46262	46262	223026	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	114 Chattanooga St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6004706.47094	2102901.67728	37.7544337331488	-122.42665779482799	(37.7544337331488, -122.426657794828)
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)
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)
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)
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)
50876	50876	206684	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	647 Los Palmos Dr	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5996011.49185	2096001.54035	37.7349922529962	-122.456228229446	(37.7349922529962, -122.456228229446)
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)
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)
52114	52114	223023	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	330 Lexington St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6006515.400219999	2104174.73701	37.7580313639845	-122.420492397202	(37.7580313639845, -122.420492397202)
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)
55439	55439	223036	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	2743 Harrison St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6008969.13541	2102480.10351	37.7535162573804	-122.411886554326	(37.7535162573804, -122.411886554326)
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)
58097	58097	206689	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	616 Los Palmos Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5996145.20311	2095954.15677	37.734869823774	-122.45576252094901	(37.734869823774, -122.455762520949)
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)
61039	61039	206671	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	370 Yerba Buena Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995266.43425	2095204.88442	37.732762033223	-122.45874648408899	(37.732762033223, -122.458746484089)
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)
61636	61636	223021	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	109 Tiffany Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6006234.71683	2099501.18451	37.7451830394575	-122.421131274692	(37.7451830394575, -122.421131274692)
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)
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)
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)
63545	63545	223038	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	10 Lippard Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6002089.19721	2096067.16423	37.7355194490575	-122.435220170783	(37.7355194490575, -122.435220170783)
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)
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)
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)
66473	66473	206691	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	582 Los Palmos Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5996439.41867	2095873.6949599998	37.734665775709296	-122.45473950971599	(37.7346657757093, -122.454739509716)
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)
66828	66828	206680	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	657 Los Palmos Dr	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5995948.68471	2096013.6289400002	37.73502183977529	-122.456446248507	(37.7350218397753, -122.456446248507)
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)
69773	69773	223051	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	24 Buena Vista Ter	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001422.87059	2107990.68113	37.7682207070445	-122.438377882942	(37.7682207070445, -122.438377882942)
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)
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)
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)
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)
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)
73565	73565	223025	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	380 Fair Oaks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6005467.6636	2101500.58617	37.750629666539396	-122.423925765973	(37.7506296665394, -122.423925765973)
74097	74097	223041	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	410 Cortland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6007256.618290001	2097259.39898	37.7390851512711	-122.41743886071899	(37.7390851512711, -122.417438860719)
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)
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)
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)
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)
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)
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)
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)
115431	115431	223053	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	701 Church St	13	Front Yard : Yard 7	Tree 1	Private 1			4	Width 3ft		6004342.543869999	2104435.23189	37.7586239308804	-122.42802562498998	(37.7586239308804, -122.42802562499)
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)
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)
129639	129639	223056	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	191 Randall St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6004346.640459999	2097517.13802	37.739628683514496	-122.427518598925	(37.7396286835145, -122.427518598925)
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)
130622	130622	223035	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	99 Manchester St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008263.26696	2099462.20339	37.7451901540099	-122.414114116572	(37.7451901540099, -122.414114116572)

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