Street_Tree_List

Data source: data.sfgov.org

170 rows where PlotSize = "Width 3ft" and qSpecies = 66 sorted by Latitude

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
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)
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)
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)
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)
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)
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)
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)
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)
188288	188288	206675	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	300 Yerba Buena Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5995199.651459999	2095433.83543	37.733386838132	-122.458993938825	(37.733386838132, -122.458993938825)
183187	183187	206695	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	140 Hamerton Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001321.914580001	2095363.51303	37.7335437842173	-122.437822570471	(37.7335437842173, -122.437822570471)
157023	157023	206694	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	125 Chilton Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001630.15209	2095380.35715	37.733607556928	-122.43675811218999	(37.733607556928, -122.43675811219)
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)
179932	179932	206676	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	240 Yerba Buena Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5994971.50428	2095856.22795	37.7345335069973	-122.459813287749	(37.7345335069973, -122.459813287749)
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)
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)
177940	177940	206677	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	228 Yerba Buena Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		5994904.4684	2095946.32835	37.7347770452256	-122.46005157662901	(37.7347770452256, -122.460051576629)
165826	165826	206688	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	629 Los Palmos Dr	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5996101.05251	2095948.39142	37.7348514596286	-122.455914747394	(37.7348514596286, -122.455914747394)
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)
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)
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)
188155	188155	206686	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	629 Los Palmos Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5996075.5527099995	2095969.20127	37.7349071348466	-122.456004412496	(37.7349071348466, -122.456004412496)
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)
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)
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)
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)
160214	160214	206681	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	657 Los Palmos Dr	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5995960.60425	2096012.63655	37.735019799206	-122.45640496693399	(37.735019799206, -122.456404966934)
167831	167831	206678	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	657 Los Palmos Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995925.9256	2096013.7330599998	37.7350208190394	-122.456524941888	(37.7350208190394, -122.456524941888)
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)
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)
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)
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)
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)
174269	174269	223032	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	281 Richland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6006256.18709	2096109.4549	37.735871320489395	-122.42081628443898	(37.7358713204894, -122.420816284439)
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)
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)
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)
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)
168058	168058	223039	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	543 Moultrie St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6007708.387180001	2096815.6091900002	37.7378920108046	-122.41584542843201	(37.7378920108046, -122.415845428432)
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)
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)
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)
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)
149027	149027	206693	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	609 Rockdale Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5997804.54909	2098010.1173	37.740610086694396	-122.45017375511999	(37.7406100866944, -122.45017375512)
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)
150656	150656	247816	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	550 30th St	1	: 4	Tree 1	Private 1			5	Width 3ft		6003030.78831	2098349.34835	37.741839226995204	-122.43212766126899	(37.7418392269952, -122.432127661269)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
158851	158851	223045	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	13 Stoneman St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6008341.10325	2099446.02772	37.745150110794896	-122.413843827126	(37.7451501107949, -122.413843827126)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
132280	132280	223046	Undocumented 2	Crataegus laevigata :: English Hawthorn 66	77 28th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6005471.50149	2099604.5609999998	37.7454238329391	-122.423777694396	(37.7454238329391, -122.423777694396)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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