Street_Tree_List

Data source: data.sfgov.org

213 rows where qSiteInfo = 2 and qSpecies = 41

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, SiteOrder, qCaretaker, DBH, PlotSize

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
23652	23652	210826	Undocumented 2	Olea europaea :: Olive Tree 41	62 Castenada Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5994426.39557	2101510.85772	37.7500283438364	-122.462107837801	(37.7500283438364, -122.462107837801)
24498	24498	210813	Undocumented 2	Olea europaea :: Olive Tree 41	486 Dewey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994698.943	2100017.50065	37.745943650072704	-122.46105713288401	(37.7459436500727, -122.461057132884)
24808	24808	210655	Undocumented 2	Olea europaea :: Olive Tree 41	302 Westgate Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		5993736.1298400005	2094686.96853	37.731251887161605	-122.463999505972	(37.7312518871616, -122.463999505972)
24979	24979	177920	Undocumented 2	Olea europaea :: Olive Tree 41	0 Juan Bautista Cir	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989764.376630001	2089755.55448	37.7174817656499	-122.477370148614	(37.7174817656499, -122.477370148614)
25292	25292	177947	Undocumented 2	Olea europaea :: Olive Tree 41	0 Fuente Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989601.96089	2090504.09134	37.7195276360688	-122.477986231896	(37.7195276360688, -122.477986231896)
26176	26176	210849	Undocumented 2	Olea europaea :: Olive Tree 41	32 Valletta Ct	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5999399.23324	2096649.47402	37.73696521176579	-122.444562201393	(37.7369652117658, -122.444562201393)
26226	26226	233777	Undocumented 2	Olea europaea :: Olive Tree 41	25 Temple St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5999970.72676	2105847.0932	37.7622522447563	-122.44324670907	(37.7622522447563, -122.44324670907)
26536	26536	123055	Undocumented 2	Olea europaea :: Olive Tree 41	522 Funston Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5991918.10118	2111871.69425	37.7783317102386	-122.47153646454399	(37.7783317102386, -122.471536464544)
27126	27126	177939	Undocumented 2	Olea europaea :: Olive Tree 41	0 Garces Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			5989472.35628	2089125.29207	37.7157342731997	-122.478333458321	(37.7157342731997, -122.478333458321)
28204	28204	210663	Undocumented 2	Olea europaea :: Olive Tree 41	2050 09th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5993512.164580001	2101452.6365900002	37.7498158034608	-122.46526504366301	(37.7498158034608, -122.465265043663)
28798	28798	194222	Undocumented 2	Olea europaea :: Olive Tree 41	1080 Key Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		6012957.45228	2090084.12895	37.719702442702605	-122.39722482158399	(37.7197024427026, -122.397224821584)
28973	28973	194221	Undocumented 2	Olea europaea :: Olive Tree 41	1080 Key Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6012968.460940001	2090076.8184	37.719682982271706	-122.397186255957	(37.7196829822717, -122.397186255957)
29240	29240	177953	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5989426.93386	2089569.48868	37.7169512897353	-122.47852292122101	(37.7169512897353, -122.478522921221)
29252	29252	210843	Undocumented 2	Olea europaea :: Olive Tree 41	32 Malta Dr	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5999589.7002	2096031.76487	37.735279994668005	-122.443859307484	(37.735279994668, -122.443859307484)
29360	29360	131865	Undocumented 2	Olea europaea :: Olive Tree 41	555 Marina Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		6000313.878190001	2121622.81545	37.8055878690403	-122.443192967399	(37.8055878690403, -122.443192967399)
29676	29676	194152	Undocumented 2	Olea europaea :: Olive Tree 41	100 Carolina St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		6012254.865130001	2106816.35106	37.7656064246163	-122.400828345673	(37.7656064246163, -122.400828345673)
29723	29723	177927	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			5988959.91996	2089504.3338	37.716745265857	-122.48013237763	(37.716745265857, -122.48013237763)
30641	30641	182105	Undocumented 2	Olea europaea :: Olive Tree 41	2438 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 0ft		5987689.5839	2098673.5022	37.741847540223496	-122.48519563979201	(37.7418475402235, -122.485195639792)
30993	30993	246520	Undocumented 2	Olea europaea :: Olive Tree 41	155 Laguna St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		6005167.3236	2109440.76034	37.772414546119705	-122.42552939567601	(37.7724145461197, -122.425529395676)
31096	31096	218413	Undocumented 2	Olea europaea :: Olive Tree 41	205 Castenada Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5994318.3495	2100641.87853	37.7476361256044	-122.462418442952	(37.7476361256044, -122.462418442952)
31749	31749	124071	Undocumented 2	Olea europaea :: Olive Tree 41	501 Funston Ave	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5991891.710659999	2111428.07377	37.777112122582004	-122.47159542274599	(37.777112122582, -122.471595422746)
31828	31828	194191	Undocumented 2	Olea europaea :: Olive Tree 41	1120 19th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		6014209.54825	2105284.76713	37.7615098643081	-122.39396025377899	(37.7615098643081, -122.393960253779)
32094	32094	177949	Undocumented 2	Olea europaea :: Olive Tree 41	0 Fuente Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			5989559.04866	2090448.7873900002	37.7193732944219	-122.47813052091101	(37.7193732944219, -122.478130520911)
32377	32377	210840	Undocumented 2	Olea europaea :: Olive Tree 41	32 Malta Dr	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5999647.66435	2095993.4021	37.735177965674	-122.44365614971599	(37.735177965674, -122.443656149716)
33527	33527	210846	Undocumented 2	Olea europaea :: Olive Tree 41	32 Valletta Ct	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5999371.806059999	2096444.1801	37.7363999581985	-122.44464227791401	(37.7363999581985, -122.444642277914)
33763	33763	194216	Undocumented 2	Olea europaea :: Olive Tree 41	1121 Jamestown Ave	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6013384.67345	2090050.6938099999	37.719634411689206	-122.39574571828399	(37.7196344116892, -122.395745718284)
34104	34104	120838	Undocumented 2	Olea europaea :: Olive Tree 41	55 19th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 7ft		5989873.67504	2114823.8325	37.7863189706432	-122.47882478569299	(37.7863189706432, -122.478824785693)
34612	34612	210654	Undocumented 2	Olea europaea :: Olive Tree 41	302 Westgate Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		5993718.29601	2094664.2964	37.7311886072667	-122.46405951503901	(37.7311886072667, -122.464059515039)
35189	35189	246522	Undocumented 2	Olea europaea :: Olive Tree 41	155 Laguna St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 6ft		6005173.7301199995	2109399.79549	37.7723024285329	-122.425504318986	(37.7723024285329, -122.425504318986)
37184	37184	182357	Undocumented 2	Olea europaea :: Olive Tree 41	3141 Kirkham St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		5985082.5718	2104968.549	37.7589798033254	-122.494673691497	(37.7589798033254, -122.494673691497)
37589	37589	185786	Undocumented 2	Olea europaea :: Olive Tree 41	1951 30th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5986905.4302	2101977.7771	37.7508744830486	-122.48814970268499	(37.7508744830486, -122.488149702685)
37721	37721	250470	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986758.26234	2115550.04275	37.7881315424801	-122.489656591996	(37.7881315424801, -122.489656591996)
38421	38421	250732	Undocumented 2	Olea europaea :: Olive Tree 41	2800 Lake St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986742.130530001	2114466.27416	37.785154884529796	-122.48963267541401	(37.7851548845298, -122.489632675414)
38683	38683	183749	Undocumented 2	Olea europaea :: Olive Tree 41	2275 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5987605.0718	2099820.1671	37.7449910546775	-122.485571982913	(37.7449910546775, -122.485571982913)
38995	38995	177874	Undocumented 2	Olea europaea :: Olive Tree 41	1222 Naples St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 8ft		6001049.49395	2087346.60283	37.711515671269495	-122.43819029695801	(37.7115156712695, -122.438190296958)
39325	39325	233085	Undocumented 2	Olea europaea :: Olive Tree 41	1455 Diamond St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		6002030.01324	2099761.6809	37.745660369933894	-122.43568902963699	(37.7456603699339, -122.435689029637)
39449	39449	194139	Undocumented 2	Olea europaea :: Olive Tree 41	770 Illinois St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			6015990.605380001	2105494.8516	37.7621855348578	-122.387814914632	(37.7621855348578, -122.387814914632)
39645	39645	120839	Undocumented 2	Olea europaea :: Olive Tree 41	55 19th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 7ft		5989874.45589	2114802.5830900003	37.7862606710831	-122.47882052946899	(37.7862606710831, -122.478820529469)
39661	39661	210815	Undocumented 2	Olea europaea :: Olive Tree 41	472 Dewey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994764.41105	2100081.22837	37.746122397545	-122.460835372654	(37.746122397545, -122.460835372654)
41532	41532	194188	Undocumented 2	Olea europaea :: Olive Tree 41	1100 19th St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		6014234.44538	2105287.05965	37.7615175427279	-122.39387430468099	(37.7615175427279, -122.393874304681)
42250	42250	194138	Undocumented 2	Olea europaea :: Olive Tree 41	770 Illinois St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6015994.24024	2105456.78042	37.7620812009176	-122.387799686412	(37.7620812009176, -122.387799686412)
43471	43471	232438	Undocumented 2	Olea europaea :: Olive Tree 41	550 Florida St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 7ft		6009220.36399	2105639.7439	37.762206006125396	-122.41124093103399	(37.7622060061254, -122.411240931034)
43906	43906	218171	Undocumented 2	Olea europaea :: Olive Tree 41	1434 Portola Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5992907.9663	2097391.6140400004	37.738630405454394	-122.46705915605101	(37.7386304054544, -122.467059156051)
44378	44378	131889	Undocumented 2	Olea europaea :: Olive Tree 41	2201 Broderick St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		6000326.53123	2116196.17656	37.79068847962821	-122.442759272949	(37.7906884796282, -122.442759272949)
44380	44380	233707	Undocumented 2	Olea europaea :: Olive Tree 41	579 Noe St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		6003034.8173400005	2104877.0487599997	37.7597629815939	-122.43257989167101	(37.7597629815939, -122.432579891671)
44693	44693	250473	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5986741.47622	2115523.3100799997	37.7880571622447	-122.489712701583	(37.7880571622447, -122.489712701583)
44710	44710	123056	Undocumented 2	Olea europaea :: Olive Tree 41	522 Funston Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5991919.36993	2111862.43638	37.7783063640541	-122.471531400723	(37.7783063640541, -122.471531400723)
45127	45127	218408	Undocumented 2	Olea europaea :: Olive Tree 41	215 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5994247.35816	2100538.43681	37.747348012494896	-122.462656422482	(37.7473480124949, -122.462656422482)
45156	45156	177964	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5988925.38088	2089008.91353	37.715382958419106	-122.48021552173901	(37.7153829584191, -122.480215521739)
45536	45536	210814	Undocumented 2	Olea europaea :: Olive Tree 41	486 Dewey Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5994715.84856	2100034.4512099996	37.7459911648725	-122.46099990453199	(37.7459911648725, -122.460999904532)
45691	45691	246525	Undocumented 2	Olea europaea :: Olive Tree 41	155 Laguna St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6005186.06731	2109316.74693	37.772075094331605	-122.425455732201	(37.7720750943316, -122.425455732201)
45888	45888	210810	Undocumented 2	Olea europaea :: Olive Tree 41	481 Dewey Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994793.05822	2100026.653	37.7459741955468	-122.460732360732	(37.7459741955468, -122.460732360732)
48587	48587	131797	Undocumented 2	Olea europaea :: Olive Tree 41	3510 Baker St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5999228.200069999	2120906.6891	37.8035596145482	-122.446898531266	(37.8035596145482, -122.446898531266)
48986	48986	131800	Undocumented 2	Olea europaea :: Olive Tree 41	3646 Baker St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5999162.81759	2121382.5362400003	37.8048624264288	-122.44715905583901	(37.8048624264288, -122.447159055839)
48999	48999	132016	Undocumented 2	Olea europaea :: Olive Tree 41	955 Green St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10			6008442.208	2118980.08343	37.798791714829896	-122.414876489872	(37.7987917148299, -122.414876489872)
49545	49545	210845	Undocumented 2	Olea europaea :: Olive Tree 41	32 Valletta Ct	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5999377.40008	2096424.41723	37.736346013246205	-122.44462151709601	(37.7363460132462, -122.444621517096)
50235	50235	131850	Undocumented 2	Olea europaea :: Olive Tree 41	3601 Baker St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		5999143.57978	2121190.63067	37.8043344065648	-122.447211810097	(37.8043344065648, -122.447211810097)
51140	51140	232437	Undocumented 2	Olea europaea :: Olive Tree 41	550 Florida St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 7ft		6009218.18097	2105675.07688	37.762302899984796	-122.41125097736901	(37.7623028999848, -122.411250977369)
51465	51465	131866	Undocumented 2	Olea europaea :: Olive Tree 41	555 Marina Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		6000334.74544	2121624.79375	37.805594490755	-122.443120895728	(37.805594490755, -122.443120895728)
51581	51581	177959	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5989083.70402	2089208.46347	37.71594007136579	-122.47968288565201	(37.7159400713658, -122.479682885652)
51889	51889	177940	Undocumented 2	Olea europaea :: Olive Tree 41	0 Garces Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5989427.62768	2089128.0215200002	37.7157391708956	-122.478488258642	(37.7157391708956, -122.478488258642)
52939	52939	177917	Undocumented 2	Olea europaea :: Olive Tree 41	0 Juan Bautista Cir	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989687.39355	2089722.5642099997	37.717386715401204	-122.477633830752	(37.7173867154012, -122.477633830752)
54382	54382	250729	Undocumented 2	Olea europaea :: Olive Tree 41	2750 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986868.92128	2114466.01828	37.7851615835723	-122.48919400591998	(37.7851615835723, -122.48919400592)
54952	54952	250476	Undocumented 2	Olea europaea :: Olive Tree 41	330 Seacliff Ave	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5986724.14595	2115502.52724	37.7879990867237	-122.48977113143101	(37.7879990867237, -122.489771131431)
55142	55142	182410	Undocumented 2	Olea europaea :: Olive Tree 41	1522 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985613.4353	2104824.559	37.7586155044304	-122.492827136387	(37.7586155044304, -122.492827136387)
56589	56589	233778	Undocumented 2	Olea europaea :: Olive Tree 41	25 Temple St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5999970.8706	2105854.0194900003	37.7622712708343	-122.443246709075	(37.7622712708343, -122.443246709075)
58133	58133	210850	Undocumented 2	Olea europaea :: Olive Tree 41	32 Valletta Ct	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5999400.785619999	2096662.25477	37.737000393259	-122.444557752446	(37.737000393259, -122.444557752446)
58315	58315	177961	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			5989118.28423	2089183.8613200001	37.7158745287534	-122.479561562622	(37.7158745287534, -122.479561562622)
58538	58538	210822	Undocumented 2	Olea europaea :: Olive Tree 41	1 Ventura Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994075.12889	2102034.61648	37.7514462212671	-122.463360530485	(37.7514462212671, -122.463360530485)
58703	58703	177916	Undocumented 2	Olea europaea :: Olive Tree 41	0 Juan Bautista Cir	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5989586.18825	2089731.4345	37.717405197378504	-122.477984294746	(37.7174051973785, -122.477984294746)
58998	58998	250889	Undocumented 2	Olea europaea :: Olive Tree 41	188 29th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986829.80655	2114505.49591	37.7852676945878	-122.489332232591	(37.7852676945878, -122.489332232591)
61160	61160	177926	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5988935.7978	2089543.3512799998	37.7168509964648	-122.480218609114	(37.7168509964648, -122.480218609114)
61235	61235	232868	Undocumented 2	Olea europaea :: Olive Tree 41	301 Putnam St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 9ft		6009077.45417	2095862.97856	37.735353165298	-122.41104460722401	(37.735353165298, -122.411044607224)
61440	61440	177943	Undocumented 2	Olea europaea :: Olive Tree 41	0 Josepha Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			5989687.380890001	2089641.08495	37.7171629928544	-122.477627922194	(37.7171629928544, -122.477627922194)
61872	61872	177944	Undocumented 2	Olea europaea :: Olive Tree 41	0 Josepha Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			5989684.83075	2089660.83958	37.717217086174	-122.477638179862	(37.717217086174, -122.477638179862)
61899	61899	177929	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5988839.75679	2089455.3276	37.7166037242653	-122.48054413220699	(37.7166037242653, -122.480544132207)
61983	61983	210816	Undocumented 2	Olea europaea :: Olive Tree 41	428 Dewey Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5995051.91359	2100354.96632	37.7468905516536	-122.45986105795299	(37.7468905516536, -122.459861057953)
62097	62097	177948	Undocumented 2	Olea europaea :: Olive Tree 41	0 Fuente Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			5989566.53985	2090511.4530000002	37.7195457933774	-122.47810920609601	(37.7195457933774, -122.478109206096)
62340	62340	181906	Undocumented 2	Olea europaea :: Olive Tree 41	2376 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15	Width 0ft		5986433.5314	2099099.0676	37.7429427799231	-122.48956988669701	(37.7429427799231, -122.489569886697)
62349	62349	131793	Undocumented 2	Olea europaea :: Olive Tree 41	3456 Baker St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5999257.06785	2120699.792	37.8029931801649	-122.446783737307	(37.8029931801649, -122.446783737307)
63848	63848	177912	Undocumented 2	Olea europaea :: Olive Tree 41	19 Rhine St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994504.97936	2086701.6160799998	37.709370301666496	-122.460762984428	(37.7093703016665, -122.460762984428)
64301	64301	177951	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			5989499.70601	2089731.63068	37.7174007160611	-122.478283234789	(37.7174007160611, -122.478283234789)
64619	64619	210660	Undocumented 2	Olea europaea :: Olive Tree 41	181 San Pablo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5994349.85178	2096588.9165400001	37.7365095190008	-122.462015646523	(37.7365095190008, -122.462015646523)
65267	65267	194219	Undocumented 2	Olea europaea :: Olive Tree 41	1121 Jamestown Ave	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			6013415.40609	2090027.00023	37.7195710634281	-122.395637826651	(37.7195710634281, -122.395637826651)
65552	65552	232439	Undocumented 2	Olea europaea :: Olive Tree 41	550 Florida St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 7ft		6009231.6785699995	2105511.08607	37.761853375653	-122.41119270939801	(37.761853375653, -122.411192709398)
65659	65659	177955	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			5989333.41698	2089519.4632700002	37.7168085025868	-122.478842503398	(37.7168085025868, -122.478842503398)
65746	65746	182411	Undocumented 2	Olea europaea :: Olive Tree 41	1522 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5985613.8208	2104844.1281	37.7586692583075	-122.49282724454201	(37.7586692583075, -122.492827244542)
65963	65963	232871	Undocumented 2	Olea europaea :: Olive Tree 41	301 Putnam St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 9ft		6009080.3789099995	2095903.22512	37.7354638376772	-122.411037337111	(37.7354638376772, -122.411037337111)
67732	67732	210844	Undocumented 2	Olea europaea :: Olive Tree 41	32 Malta Dr	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5999579.90155	2096034.95813	37.7352882036818	-122.443893414261	(37.7352882036818, -122.443893414261)
67763	67763	177962	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			5989078.7127	2089134.3997099998	37.7157364207672	-122.479694721656	(37.7157364207672, -122.479694721656)
67850	67850	210823	Undocumented 2	Olea europaea :: Olive Tree 41	1 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5994071.60304	2101964.35734	37.7512531044495	-122.46336762522101	(37.7512531044495, -122.463367625221)
69294	69294	117750	Undocumented 2	Olea europaea :: Olive Tree 41	415 39th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5983735.533369999	2113025.8643	37.781023947902604	-122.49992789155701	(37.7810239479026, -122.499927891557)
69468	69468	177945	Undocumented 2	Olea europaea :: Olive Tree 41	0 Diaz Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			5990273.00331	2089979.48461	37.718126121809604	-122.47562842082701	(37.7181261218096, -122.475628420827)
69631	69631	117751	Undocumented 2	Olea europaea :: Olive Tree 41	415 39th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5983734.82883	2113014.83015	37.7809936100018	-122.499929513006	(37.7809936100018, -122.499929513006)
69696	69696	177930	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5988862.76325	2089422.54432	37.7165150466091	-122.480462212988	(37.7165150466091, -122.480462212988)
69991	69991	210828	Undocumented 2	Olea europaea :: Olive Tree 41	62 Castenada Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 3ft		5994428.98345	2101481.79617	37.7499486971881	-122.462096781546	(37.7499486971881, -122.462096781546)
70010	70010	177934	Undocumented 2	Olea europaea :: Olive Tree 41	0 Bucareli Dr	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			5988635.61259	2089280.10032	37.7161107276166	-122.481236924063	(37.7161107276166, -122.481236924063)
70016	70016	177950	Undocumented 2	Olea europaea :: Olive Tree 41	0 Grijalva Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16			5989537.87078	2089714.6263700002	37.7173562418745	-122.47815007578801	(37.7173562418745, -122.478150075788)
70084	70084	182044	Undocumented 2	Olea europaea :: Olive Tree 41	1334 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 0ft		5987739.7617	2106184.8282	37.7624745441388	-122.485573255158	(37.7624745441388, -122.485573255158)
70820	70820	194182	Undocumented 2	Olea europaea :: Olive Tree 41	1100 19th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		6014281.16459	2105289.06186	37.7615256366132	-122.393712861061	(37.7615256366132, -122.393712861061)

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