Street_Tree_List

Data source: data.sfgov.org

116 rows where qSiteInfo = 4 and qSpecies = 44

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

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
24599	24599	225999	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	700 Duboce Ave	3	: 4	Tree 1	Private 1			1	Width 3ft		6002335.19401	2108315.06979	37.7691632487104	-122.435245457027	(37.7691632487104, -122.435245457027)
24622	24622	247221	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	187 Divisadero St	1	: 4	Tree 1	Private 1			1	Width 3ft		6001849.330080001	2108668.89946	37.770107174421796	-122.436951364836	(37.7701071744218, -122.436951364836)
26377	26377	225990	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2 Pearl St	2	: 4	Tree 1	Private 1			7	Width 2ft		6005601.0883599995	2108893.1022200002	37.7709353079426	-122.42399000814	(37.7709353079426, -122.42399000814)
26671	26671	190388	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	700 Rhode Island St	2	: 4	Tree 1	Private 1			2	Width 3ft		6011799.90498	2105067.41512	37.7607788503881	-122.402278983608	(37.7607788503881, -122.402278983608)
28109	28109	190386	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	767 Rhode Island St	3	: 4	Tree 1	Private 1			6	Width 3ft		6011868.88552	2104842.63412	37.7601655019667	-122.40202460676201	(37.7601655019667, -122.402024606762)
29498	29498	190455	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1751 Newhall St	2	: 4	Tree 1	Private 1			3	Width 3ft		6013882.7499	2094972.5307	37.7331764776989	-122.39436846503901	(37.7331764776989, -122.394368465039)
31173	31173	225996	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	47 Octavia St	4	: 4	Tree 1	Private 1			1	Width 4ft		6005638.67194	2109514.80428	37.7726444739859	-122.423904220905	(37.7726444739859, -122.423904220905)
32001	32001	190434	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	33	: 4	Tree 1	Private 1			2	Width 3ft		6017509.45239	2097206.48557	37.739511409230104	-122.381985187163	(37.7395114092301, -122.381985187163)
32400	32400	192428	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	480 Bryant St	1	: 4	Tree 1	Private 1			1	Width 3ft		6014110.58587	2112833.82618	37.782232395453796	-122.39483123728	(37.7822323954538, -122.39483123728)
33767	33767	190391	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	571 Texas St	2	: 4	Tree 1	Private 1			1	Width 6ft		6013851.28196	2104449.17868	37.75919560292179	-122.395140827087	(37.7591956029218, -122.395140827087)
35117	35117	190404	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	11	: 4	Tree 1	Private 1			1	Width 3ft		6012224.99422	2100912.98992	37.74939542707129	-122.40051694820801	(37.7493954270713, -122.400516948208)
35280	35280	190389	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	707 Wisconsin St	1	: 4	Tree 1	Private 1			8	Width 3ft		6012743.008909999	2104201.32754	37.7584533636396	-122.398956396938	(37.7584533636396, -122.398956396938)
36209	36209	190444	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1301 Evans Ave	7	: 4	Tree 1	Private 1			1	Width 3ft		6017091.55638	2097401.29734	37.7400232358798	-122.383443661803	(37.7400232358798, -122.383443661803)
37346	37346	190445	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1201 Evans Ave	3	: 4	Tree 1	Private 1			1	Width 3ft		6017686.12557	2096959.12409	37.738841959282205	-122.381357125839	(37.7388419592822, -122.381357125839)
37437	37437	190397	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	8	: 4	Tree 1	Private 1			4	Width 3ft		6012152.10777	2100910.4709400004	37.7493844454379	-122.400768815931	(37.7493844454379, -122.400768815931)
39757	39757	202047	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	55 Exeter St	1	: 4	Tree 1	Private 1			1	Width 3ft		6012547.51313	2090916.47332	37.721965061416796	-122.398700225048	(37.7219650614168, -122.398700225048)
39849	39849	190429	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	27	: 4	Tree 1	Private 1			2	Width 3ft		6017626.76379	2097120.54655	37.7392819157251	-122.381573596257	(37.7392819157251, -122.381573596257)
39886	39886	190442	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1355 Evans Ave	3	: 4	Tree 1	Private 1			4	Width 3ft		6016877.61035	2097560.61603	37.740448866128204	-122.384194498593	(37.7404488661282, -122.384194498593)
39953	39953	246990	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	78 Clipper St	1	: 4	Tree 1	Private 1			1	Width 4ft		6004670.61163	2101066.74727	37.7493934152835	-122.426651147943	(37.7493934152835, -122.426651147943)
40843	40843	192425	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	187 Clara St	6	: 4	Tree 1	Private 1			1	Width 2ft		6011952.39777	2111919.37561	37.779601291212394	-122.402233334018	(37.7796012912124, -122.402233334018)
42115	42115	192437	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	106 Langton St	2	: 4	Tree 1	Private 1			1	Width 3ft		6010237.3697	2110691.53515	37.7761340485805	-122.40807976548099	(37.7761340485805, -122.408079765481)
42788	42788	246481	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	330 Duncan St	1	: 4	Tree 1	Private 1			10	Width 5ft		6004176.06205	2099871.25195	37.74608289033021	-122.42827612036301	(37.7460828903302, -122.428276120363)
44896	44896	190421	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	17	: 4	Tree 1	Private 1			3	Width 3ft		6017813.9736	2096980.8190099997	37.7389085864479	-122.38091659022899	(37.7389085864479, -122.380916590229)
45841	45841	190426	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	24	: 4	Tree 1	Private 1			2	Width 3ft		6017676.692919999	2097082.9618400002	37.7391814722423	-122.381398348955	(37.7391814722423, -122.381398348955)
46420	46420	190420	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	16	: 4	Tree 1	Private 1			6	Width 3ft		6017827.78919	2096970.1308799998	37.7388800015007	-122.380868079005	(37.7388800015007, -122.380868079005)
49397	49397	192435	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	382 07th St	2	: 4	Tree 1	Private 1			7	Width 3ft		6010717.744530001	2110532.78766	37.7757250495103	-122.406406823243	(37.7757250495103, -122.406406823243)
49434	49434	247805	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	488 30th St	2	: 4	Tree 1	Private 1			1	Width 3ft		6003450.91279	2098365.25645	37.741906717527705	-122.43067614380199	(37.7419067175277, -122.430676143802)
50394	50394	190425	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	23	: 4	Tree 1	Private 1			1	Width 3ft		6017693.17965	2097070.35958	37.739147779140396	-122.38134046861299	(37.7391477791404, -122.381340468613)
50600	50600	219079	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2674 Ocean Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		5990725.25402	2095140.06488	37.7323219940584	-122.474441593613	(37.7323219940584, -122.474441593613)
51729	51729	176543	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	100 Panama St	6	: 4	Tree 1	Private 1			1	Width 3ft		5992283.95996	2086838.07777	37.709616952417704	-122.468449043003	(37.7096169524177, -122.468449043003)
52901	52901	190422	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	18	: 4	Tree 1	Private 1			5	Width 3ft		6017797.18223	2096994.0322599998	37.7389439406012	-122.38097556597299	(37.7389439406012, -122.380975565973)
53438	53438	190407	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	13	: 4	Tree 1	Private 1			4	Width 3ft		6012292.256030001	2100918.21603	37.74941352772171	-122.40028472078998	(37.7494135277217, -122.40028472079)
54832	54832	225987	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	79 Elgin Park	1	: 4	Tree 1	Private 1			8	Width 3ft		6005841.38866	2108630.33046	37.7702273634261	-122.42314012092501	(37.7702273634261, -122.423140120925)
55193	55193	190435	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	35	: 4	Tree 1	Private 1			1	Width 3ft		6017477.19545	2097232.60183	37.7395813377956	-122.38209853501499	(37.7395813377956, -122.382098535015)
55951	55951	190427	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	25	: 4	Tree 1	Private 1			3	Width 3ft		6017659.5138	2097095.8095900002	37.7392158011555	-122.38145864041401	(37.7392158011555, -122.381458640414)
56337	56337	219078	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	23 Bright St	1	: 4	Tree 1	Private 1			1	Width 3ft		5993714.36027	2087390.3486099998	37.7112158768855	-122.463545422096	(37.7112158768855, -122.463545422096)
56917	56917	250996	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	453 44th Ave	1	: 4	Tree 1	Private 1			2	Width 3ft		5982195.03644	2112765.4035099996	37.780218274692004	-122.505237834779	(37.780218274692, -122.505237834779)
58117	58117	192434	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	382 07th St	1	: 4	Tree 1	Private 1			10	Width 3ft		6010729.70482	2110519.81747	37.7756901054455	-122.40636453531401	(37.7756901054455, -122.406364535314)
59854	59854	201603	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	565 Innes Ave	1	: 4	Tree 1	Private 1			2	Width 3ft		6021043.02716	2093075.23068	37.7283622799705	-122.369482082752	(37.7283622799705, -122.369482082752)
60465	60465	176542	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	100 Panama St	5	: 4	Tree 1	Private 1			1	Width 3ft		5992312.69836	2086838.42699	37.7096195712459	-122.468349744347	(37.7096195712459, -122.468349744347)
60594	60594	219076	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	105 Majestic Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		5997099.54595	2089348.6148	37.7167872911766	-122.45198663009701	(37.7167872911766, -122.451986630097)
60979	60979	190447	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1201 Evans Ave	5	: 4	Tree 1	Private 1			3	Width 3ft		6017726.41303	2096927.8119	37.7387582063175	-122.381215652579	(37.7387582063175, -122.381215652579)
61134	61134	225997	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	700 Duboce Ave	1	: 4	Tree 1	Private 1			4	Width 3ft		6002375.20249	2108318.05124	37.7691737069397	-122.43510728337601	(37.7691737069397, -122.435107283376)
61401	61401	190428	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	26	: 4	Tree 1	Private 1			1	Width 3ft		6017641.63274	2097108.43991	37.7392494942632	-122.38152134383101	(37.7392494942632, -122.381521343831)
61948	61948	225994	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	47 Octavia St	2	: 4	Tree 1	Private 1			3	Width 4ft		6005633.11959	2109553.55666	37.772750565219795	-122.423926183265	(37.7727505652198, -122.423926183265)
62332	62332	190453	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1501 Evans Ave	5	: 4	Tree 1	Private 1			1	Width 3ft		6016075.66534	2098156.64839	37.7420410771473	-122.387008895444	(37.7420410771473, -122.387008895444)
63628	63628	225989	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2 Pearl St	1	: 4	Tree 1	Private 1			5	Width 2ft		6005599.73755	2108949.27442	37.771089467040504	-122.42399867580299	(37.7710894670405, -122.423998675803)
64045	64045	190405	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	12	: 4	Tree 1	Private 1			4	Width 3ft		6012259.88232	2100916.2126599997	37.749406221625	-122.40039652989401	(37.749406221625, -122.400396529894)
64690	64690	192441	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	10 McLea Ct	5	: 4	Tree 1	Private 1			2	Width 3ft		6010051.802130001	2109236.00979	37.7721271227961	-122.408618994484	(37.7721271227961, -122.408618994484)
66224	66224	190400	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	9	: 4	Tree 1	Private 1			2	Width 3ft		6012170.1171	2100910.58495	37.7493857629599	-122.400706546863	(37.7493857629599, -122.400706546863)
67777	67777	190451	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1498 Evans Ave	8	: 4	Tree 1	Private 1			3	Width 3ft		6016356.86171	2098066.94132	37.741810326373404	-122.38603034673599	(37.7418103263734, -122.386030346736)
68764	68764	202048	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	55 Exeter St	2	: 4	Tree 1	Private 1			1	Width 3ft		6012550.84641	2090927.25992	37.7219948649522	-122.39868945925501	(37.7219948649522, -122.398689459255)
69038	69038	190440	DPW Maintained 3	Ginkgo biloba :: Maidenhair Tree 44	1350 Evans Ave	7	: 4	Tree 1	DPW 2		03/30/2004 12:00:00 AM	4	Width 3ft		6016842.64833	2097703.08966	37.740838136776794	-122.384325304974	(37.7408381367768, -122.384325304974)
69188	69188	190402	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	10	: 4	Tree 1	Private 1			1	Width 3ft		6012204.22169	2100912.2871	37.74939233879871	-122.40058873120199	(37.7493923387987, -122.400588731202)
69600	69600	250770	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	247 32nd Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5985863.4711	2114256.40781	37.7845273142332	-122.492657058592	(37.7845273142332, -122.492657058592)
70479	70479	225985	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	291 Duboce Ave	2	: 4	Tree 1	Private 1			3	Width 3ft		6005037.67201	2108401.42033	37.7695534429634	-122.42590387697399	(37.7695534429634, -122.425903876974)
71710	71710	190409	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	14	: 4	Tree 1	Private 1			4	Width 3ft		6012317.265430001	2100919.43782	37.749418277035296	-122.400198322911	(37.7494182770353, -122.400198322911)
130458	130458	247223	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	161 Divisadero St	1	: 4	Tree 1	Private 1			1	Width 3ft		6001877.39877	2108558.68003	37.7698061344742	-122.436846384277	(37.7698061344742, -122.436846384277)
131953	131953	192429	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	271 Clara St	1	: 4	Tree 1	Private 1			1	Width 3ft		6011461.32034	2111421.96775	37.7782081010676	-122.403897179615	(37.7782081010676, -122.403897179615)
132784	132784	176541	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	213 Saint Charles Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		5992061.3412	2087065.5070200001	37.7102285570869	-122.46923498750601	(37.7102285570869, -122.469234987506)
134076	134076	192431	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	340 06th St	2	: 4	Tree 1	Private 1			7	Width 3ft		6011135.533430001	2111313.5874900003	37.7778923077093	-122.40501656845699	(37.7778923077093, -122.405016568457)
134820	134820	219075	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	56 Majestic Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		5997267.3367	2089660.30758	37.7176527366739	-122.45142913134899	(37.7176527366739, -122.451429131349)
136432	136432	190449	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1498 Evans Ave	3	: 4	Tree 1	Private 1			2	Width 4ft		6016446.96027	2097998.11216	37.7416263215051	-122.385714016492	(37.7416263215051, -122.385714016492)
136926	136926	190457	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	38 Bridgeview Dr	1	: 4	Tree 1	Private 1			1	Width 3ft		6013965.07757	2095502.46045	37.7346361322527	-122.39412092036801	(37.7346361322527, -122.394120920368)
137848	137848	190417	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	9	: 4	Tree 1	Private 1			2	Width 3ft		6017947.81444	2096878.1348700002	37.738634022532295	-122.380446690882	(37.7386340225323, -122.380446690882)
138035	138035	190456	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1709 Revere Ave	5	: 4	Tree 1	Private 1			3	Width 5ft		6014599.96347	2094732.12435	37.7325562135041	-122.391872039683	(37.7325562135041, -122.391872039683)
139029	139029	190448	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1498 Evans Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		6016474.94651	2097978.89323	37.7415750988015	-122.38561590947201	(37.7415750988015, -122.385615909472)
147177	147177	190419	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	15	: 4	Tree 1	Private 1			1	Width 3ft		6017844.32202	2096957.74462	37.7388469037738	-122.380810054756	(37.7388469037738, -122.380810054756)
147828	147828	247222	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	187 Divisadero St	2	: 4	Tree 1	Private 1			1	Width 3ft		6001857.53471	2108690.91436	37.7701680882111	-122.436924561446	(37.7701680882111, -122.436924561446)
148505	148505	190387	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	700 Rhode Island St	1	: 4	Tree 1	Private 1			3	Width 3ft		6011798.73597	2105084.69836	37.7608262410664	-122.40228424192499	(37.7608262410664, -122.402284241925)
149010	149010	190411	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	15	: 4	Tree 1	Private 1			4	Width 3ft		6012337.1891	2100920.23068	37.7494215649704	-122.400129481597	(37.7494215649704, -122.400129481597)
149878	149878	246427	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	464 Duncan St	1	: 4	Tree 1	Private 1			7	Width 3ft		6003499.77628	2099836.70737	37.74594974928	-122.430612163326	(37.74594974928, -122.430612163326)
149928	149928	190395	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	7	: 4	Tree 1	Private 1			5	Width 3ft		6012031.32912	2100905.9879099997	37.749365398695396	-122.40118615893299	(37.7493653986954, -122.401186158933)
150195	150195	190393	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	2323 Cesar Chavez St	6	: 4	Tree 1	Private 1			4	Width 3ft		6012003.952769999	2100904.2897799998	37.7493592086764	-122.40128070823401	(37.7493592086764, -122.401280708234)
150793	150793	190418	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	13	: 4	Tree 1	Private 1			4	Width 3ft		6017880.91866	2096930.7090099999	37.7387746891043	-122.38068164054701	(37.7387746891043, -122.380681640547)
151983	151983	225992	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	73 Webster St	2	: 4	Tree 1	Private 1			1	Width 4ft		6004280.102030001	2108876.58802	37.770815296119	-122.428558158527	(37.770815296119, -122.428558158527)
152514	152514	225991	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	99 Laussat St	2	: 4	Tree 1	Private 1			1	Width 3ft		6004313.0789	2109253.9397400003	37.7718532783246	-122.428470991768	(37.7718532783246, -122.428470991768)
152582	152582	190450	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1498 Evans Ave	7	: 4	Tree 1	Private 1			2	Width 3ft		6016372.9615	2098053.57634	37.7417745198736	-122.385973747016	(37.7417745198736, -122.385973747016)
153592	153592	225998	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	700 Duboce Ave	2	: 4	Tree 1	Private 1			5	Width 3ft		6002353.91965	2108316.37553	37.769167897315995	-122.435180779574	(37.769167897316, -122.435180779574)
154899	154899	192442	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	10 McLea Ct	6	: 4	Tree 1	Private 1			2	Width 3ft		6010037.847630001	2109199.90386	37.7720272027263	-122.408664716903	(37.7720272027263, -122.408664716903)
155923	155923	192440	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	10 McLea Ct	3	: 4	Tree 1	Private 1			2	Width 3ft		6010071.610859999	2109254.18785	37.772178144932205	-122.40855175667801	(37.7721781449322, -122.408551756678)
156263	156263	202050	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	55 Exeter St	4	: 4	Tree 1	Private 1			1	Width 3ft		6012561.58184	2090957.5364599999	37.7220785963245	-122.398654472931	(37.7220785963245, -122.398654472931)
157330	157330	190424	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	22	: 4	Tree 1	Private 1			1	Width 3ft		6017710.59589	2097057.73864	37.7391140860314	-122.38127937316901	(37.7391140860314, -122.381279373169)
157548	157548	190446	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1201 Evans Ave	4	: 4	Tree 1	Private 1			4	Width 3ft		6017708.20702	2096943.20124	37.7387994573363	-122.38127967082899	(37.7387994573363, -122.381279670829)
158224	158224	190433	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	32	: 4	Tree 1	Private 1			3	Width 3ft		6017527.816819999	2097194.77168	37.739480259397205	-122.381920875742	(37.7394802593972, -122.381920875742)
158666	158666	190443	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1355 Evans Ave	4	: 4	Tree 1	Private 1			4	Width 3ft		6016894.71914	2097547.52452	37.74041386541771	-122.384134431075	(37.7404138654177, -122.384134431075)
159340	159340	192443	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	12 McLea Ct	1	: 4	Tree 1	Private 1			3	Width 3ft		6009970.155809999	2109159.47449	37.7719124015539	-122.408896016247	(37.7719124015539, -122.408896016247)
160649	160649	190415	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1799 Indiana St	2	: 4	Tree 1	Private 1			1	Width 5ft		6015204.21504	2100274.26045	37.747807307062295	-122.390170025934	(37.7478073070623, -122.390170025934)
161043	161043	176544	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	100 Panama St	7	: 4	Tree 1	Private 1			1	Width 3ft		5992259.97775	2086836.1982	37.7096104062721	-122.46853179230499	(37.7096104062721, -122.468531792305)
161256	161256	190452	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1501 Evans Ave	3	: 4	Tree 1	Private 1			1	Width 3ft		6016023.90854	2098196.6321900003	37.7421479984362	-122.387190643943	(37.7421479984362, -122.387190643943)
161792	161792	192438	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	106 Langton St	5	: 4	Tree 1	Private 1			1	Width 3ft		6010203.33587	2110729.26042	37.7762357277411	-122.408200159505	(37.7762357277411, -122.408200159505)
163748	163748	219074	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	250 Tara St	2	: 4	Tree 1	Private 1			8	Width 3ft		5997774.99858	2090348.2012599998	37.7195705903952	-122.449723925911	(37.7195705903952, -122.449723925911)
164173	164173	190423	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	21	: 4	Tree 1	Private 1			2	Width 3ft		6017743.92086	2097032.31488	37.739046117095704	-122.381162382138	(37.7390461170957, -122.381162382138)
164889	164889	190441	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1355 Evans Ave	1	: 4	Tree 1	Private 1			7	Width 3ft		6016833.46344	2097593.1444200003	37.74053574152661	-122.384349407722	(37.7405357415266, -122.384349407722)
165295	165295	225988	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	51 Elgin Park	1	: 4	Tree 1	Private 1			3	Width 3ft		6005833.50158	2108775.5715	37.7706257154391	-122.42317772788401	(37.7706257154391, -122.423177727884)
166438	166438	192444	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	12 McLea Ct	2	: 4	Tree 1	Private 1			3	Width 3ft		6009959.06964	2109149.63533	37.7718847645088	-122.408933669953	(37.7718847645088, -122.408933669953)
169026	169026	192426	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	356 05th St	1	: 4	Tree 1	Private 1			7	Width 2ft		6011912.12832	2111911.11842	37.77957637100361	-122.402372063443	(37.7795763710036, -122.402372063443)
169774	169774	192439	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	8 McLea Ct	1	: 4	Tree 1	Private 1			3	Width 3ft		6010092.24423	2109274.67228	37.772235545969	-122.408481828984	(37.772235545969, -122.408481828984)
169860	169860	190431	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	1300 Evans Ave	29	: 4	Tree 1	Private 1			2	Width 3ft		6017575.221969999	2097158.85814	37.7393842657625	-122.381754470602	(37.7393842657625, -122.381754470602)
170349	170349	192432	Undocumented 2	Ginkgo biloba :: Maidenhair Tree 44	950 Harrison St	7	: 4	Tree 1	Private 1			7	Width 3ft		6011668.99845	2111377.71615	37.7780981967176	-122.40317562746799	(37.7780981967176, -122.403175627468)

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