Street_Tree_List

Data source: data.sfgov.org

129 rows where qSiteInfo = 9 and qSpecies = 60 sorted by qAddress

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
89582	89582	99611	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Entrada Ct	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1						5992743.0	2092489.0	37.7251595224946	-122.46727314778099	(37.7251595224946, -122.467273147781)
167099	167099	126287	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1 Florence St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21			6008482.5431699995	2118328.02028	37.797003577504604	-122.41469074658998	(37.7970035775046, -122.41469074659)
23588	23588	142397	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997908.5687	2114561.3906	37.7860616516624	-122.45100731899299	(37.7860616516624, -122.451007318993)
24862	24862	142424	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	39	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 0ft		5997593.3287	2114514.5192	37.78591490273521	-122.452094576108	(37.7859149027352, -122.452094576108)
25216	25216	142438	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	53	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997453.3913	2114497.9365	37.7858613541886	-122.452577521257	(37.7858613541886, -122.452577521257)
25943	25943	142412	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	27	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5997733.6046	2114534.6553	37.7859782253852	-122.45161071556002	(37.7859782253852, -122.45161071556)
28742	28742	142387	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5998077.7796	2114584.0649	37.7861335951467	-122.450423532667	(37.7861335951467, -122.450423532667)
29049	29049	142409	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 0ft		5997773.8768	2114540.7469	37.7859972575145	-122.45147182494699	(37.7859972575145, -122.451471824947)
32552	32552	142395	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 0ft		5997933.9503	2114564.4364	37.7860714676838	-122.45091972560499	(37.7860714676838, -122.450919725605)
32757	32757	142398	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5997898.7544	2114559.3601	37.7860555145741	-122.451041127193	(37.7860555145741, -122.451041127193)
37218	37218	142400	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997877.4339	2114556.6527	37.7860468601303	-122.451114694716	(37.7860468601303, -122.451114694716)
38226	38226	142419	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	34	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 0ft		5997648.4915	2114525.3487	37.7859477973415	-122.451904510544	(37.7859477973415, -122.451904510544)
38991	38991	142434	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	49	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5997490.7869	2114502.336	37.7858755765928	-122.45244846114599	(37.7858755765928, -122.452448461146)
39124	39124	142417	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	32	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5997674.55	2114528.3945	37.785957652798	-122.451814575532	(37.785957652798, -122.451814575532)
40238	40238	142386	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 0ft		5998114.6675	2114591.1717	37.786155219669396	-122.450296423393	(37.7861552196694, -122.450296423393)
41642	41642	142427	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	42	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 0ft		5997563.2092	2114510.7965	37.7859029558443	-122.45219851203998	(37.7859029558443, -122.45219851204)
42502	42502	142415	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5997700.27	2114531.1019	37.785966559642794	-122.451725787187	(37.7859665596428, -122.451725787187)
45228	45228	142439	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	54	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5997443.9155	2114497.5981	37.7858598821031	-122.45261028028901	(37.7858598821031, -122.452610280289)
46803	46803	142392	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			37	Width 0ft		5997992.4973	2114571.2048	37.7860934034035	-122.450717657836	(37.7860934034035, -122.450717657836)
49835	49835	142396	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 0ft		5997922.444	2114562.4059	37.7860652337565	-122.450959387654	(37.7860652337565, -122.450959387654)
51820	51820	142425	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	40	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10	Width 0ft		5997580.8071	2114513.5039	37.7859113977237	-122.45213782389	(37.7859113977237, -122.45213782389)
52759	52759	142449	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	64	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 0ft		5997336.6358	2114481.6923	37.785810061623295	-122.452980287706	(37.7858100616233, -122.452980287706)
60448	60448	142435	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	50	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 0ft		5997482.3264	2114500.9823	37.7858713749679	-122.452477634253	(37.7858713749679, -122.452477634253)
62029	62029	142422	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	37	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 0ft		5997618.0335	2114520.9492	37.7859339729155	-122.452009568816	(37.7859339729155, -122.452009568816)
63642	63642	142411	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 0ft		5997746.1262	2114536.3474	37.785983588517205	-122.45156751655	(37.7859835885172, -122.45156751655)
64888	64888	142430	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	45	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997534.1049	2114507.4123	37.7858919964517	-122.452298960079	(37.7858919964517, -122.452298960079)
67815	67815	142414	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	29	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 0ft		5997709.7458	2114531.1019	37.7859671023257	-122.451693003671	(37.7859671023257, -122.451693003671)
67964	67964	142402	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 0ft		5997856.7901	2114554.2838	37.7860391738166	-122.45118594545299	(37.7860391738166, -122.451185945453)
69592	69592	142408	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 0ft		5997793.8437	2114545.4848	37.7860114098886	-122.451403087084	(37.7860114098886, -122.451403087084)
73277	73277	142420	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	35	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 0ft		5997641.3846	2114523.995	37.785943673381205	-122.45192900064899	(37.7859436733812, -122.451929000649)
73453	73453	142447	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	62	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5997374.2006	2114486.4302	37.7858252233209	-122.45285066681299	(37.7858252233209, -122.452850666813)
74139	74139	142401	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997867.6196	2114554.9606	37.7860416521682	-122.45114852731301	(37.7860416521682, -122.451148527313)
74824	74824	142399	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5997888.9402	2114558.0064	37.786051235795796	-122.45107498386601	(37.7860512357958, -122.451074983866)
75796	75796	142393	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5997963.0546	2114567.8206	37.786082425901206	-122.45081927712	(37.7860824259012, -122.45081927712)
120871	120871	142441	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	56	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5997429.025	2114493.8755	37.78584880764029	-122.452661528246	(37.7858488076403, -122.452661528246)
133275	133275	142433	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997499.5859	2114503.0128	37.7858779390155	-122.45241806806101	(37.7858779390155, -122.452418068061)
134598	134598	142390	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5998035.1384	2114578.3117	37.7861153578155	-122.450570644279	(37.7861153578155, -122.450570644279)
136328	136328	142418	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	33	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 0ft		5997662.3668	2114527.0408	37.785953238114	-122.451856628165	(37.785953238114, -122.451856628165)
146892	146892	142389	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 0ft		5998056.7974	2114581.3575	37.7861249604509	-122.450495929916	(37.7861249604509, -122.450495929916)
148651	148651	142446	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	61	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997383.6764	2114487.7839	37.785829483217896	-122.45281798111	(37.7858294832179, -122.45281798111)
149196	149196	142410	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997761.6936	2114540.07	37.7859947012667	-122.45151392645799	(37.7859947012667, -122.451513926458)
149712	149712	142432	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	47	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 0ft		5997511.0923	2114504.0281	37.785881385969	-122.45237833260401	(37.785881385969, -122.452378332604)
150003	150003	142416	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	31	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 0ft		5997686.3947	2114529.7482	37.78596204808029	-122.451773694005	(37.7859620480803, -122.451773694005)
153762	153762	142436	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	51	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 0ft		5997474.8811	2114498.9518	37.7858653731869	-122.45250324620599	(37.7858653731869, -122.452503246206)
154222	154222	142437	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	52	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 0ft		5997464.7285	2114499.2902	37.7858657206584	-122.452538395628	(37.7858657206584, -122.452538395628)
155157	155157	142431	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	46	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5997523.9523	2114506.3971	37.785888627357004	-122.452334011803	(37.785888627357, -122.452334011803)
157168	157168	142428	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	43	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 0ft		5997554.4102	2114510.1197	37.785900593478296	-122.45222890514201	(37.7859005934783, -122.452228905142)
163868	163868	142445	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	60	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 0ft		5997392.137	2114489.8144	37.7858355432461	-122.452788856559	(37.7858355432461, -122.452788856559)
165410	165410	142403	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			29	Width 0ft		5997842.5764	2114549.5458	37.7860253507043	-122.451234778957	(37.7860253507043, -122.451234778957)
169112	169112	142405	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997821.9327	2114548.5306	37.7860213812263	-122.451306126982	(37.7860213812263, -122.451306126982)
170692	170692	142443	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	58	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 0ft		5997409.7349	2114492.5218	37.785843985429395	-122.452728168531	(37.7858439854294, -122.452728168531)
173468	173468	142407	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 0ft		5997811.1032	2114546.5	37.7860151856477	-122.45134344743201	(37.7860151856477, -122.451343447432)
175064	175064	142388	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30	Width 0ft		5998066.9501	2114582.3728	37.7861283292793	-122.450460877658	(37.7861283292793, -122.450460877658)
177480	177480	142413	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 0ft		5997716.1759	2114533.1324	37.7859730457909	-122.451670903916	(37.7859730457909, -122.451670903916)
178738	178738	142394	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5997948.164	2114566.1285	37.7860769274284	-122.45087067230699	(37.7860769274284, -122.450870672307)
182006	182006	142450	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	65	Sidewalk: Property side : Yard 9	Tree 1	Private 1			28	Width 0ft		5997309.2236	2114478.6465	37.7858001276963	-122.45307490578199	(37.7858001276963, -122.453074905782)
182289	182289	142429	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	44	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 0ft		5997546.2881	2114509.7813	37.785899199038404	-122.45225698079399	(37.7858991990384, -122.452256980794)
183413	183413	142423	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	38	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26	Width 0ft		5997605.1735	2114516.8881	37.7859220855908	-122.45205376754801	(37.7859220855908, -122.452053767548)
184696	184696	142391	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 0ft		5998019.9094	2114574.9275	37.7861051940215	-122.450623088237	(37.7861051940215, -122.450623088237)
185549	185549	142444	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	10 MAYFAIR DR	59	Sidewalk: Property side : Yard 9	Tree 1	Private 1			17	Width 0ft		5997400.5975	2114491.1681	37.785839744948	-122.45275968348301	(37.785839744948, -122.452759683483)
26476	26476	212215	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11			6001146.22542	2095720.4454400002	37.73451384602821	-122.438455541186	(37.7345138460282, -122.438455541186)
37614	37614	212222	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	15	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6000900.61271	2095850.79313	37.734857776454504	-122.43931404390699	(37.7348577764545, -122.439314043907)
39680	39680	212217	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6			6001121.36826	2095728.58105	37.734534770568	-122.438542063178	(37.734534770568, -122.438542063178)
52706	52706	212226	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11			6000822.65215	2095879.57602	37.734932370740296	-122.439585642776	(37.7349323707403, -122.439585642776)
129617	129617	212219	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9			6001099.22416	2095737.89591	37.7345590873286	-122.43861928975299	(37.7345590873286, -122.438619289753)
179112	179112	212223	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1120 Bosworth St	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23			6000871.267080001	2095862.2026400003	37.7348874342912	-122.439416319315	(37.7348874342912, -122.439416319315)
150282	150282	189465	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	119 Augusta St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			9	Width 5ft		6011093.8491400005	2095438.52571	37.73430057630279	-122.40404328257601	(37.7343005763028, -122.404043282576)
1438	1438	251533	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1201X Pierce St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				3x3		6002292.0	2112799.0	37.7814725496882	-122.43571571002899	(37.7814725496882, -122.435715710029)
150323	150323	217785	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	124 Sloat Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			33			5991003.2864	2096055.6883900003	37.7348521691816	-122.473547145886	(37.7348521691816, -122.473547145886)
146615	146615	126274	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1240 Lombard St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24	Width 6ft		6006421.51674	2120105.21307	37.80176728640121	-122.421948716173	(37.8017672864012, -122.421948716173)
137112	137112	212158	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1340 Monterey Blvd	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 10ft		5993891.68041	2094668.0264299999	37.731208840201504	-122.463460369625	(37.7312088402015, -122.463460369625)
169516	169516	126304	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	150 Lombard St	14	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 3ft		6011511.53944	2120807.30084	37.803980794943705	-122.40438423177	(37.8039807949437, -122.40438423177)
29344	29344	212243	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	160 Marston Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			5998464.243	2093227.24787	37.7275151923546	-122.447548599	(37.7275151923546, -122.447548599)
60091	60091	189420	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	1751 22nd St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 3ft		6012859.34416	2103757.23618	37.757240467778296	-122.39852289312	(37.7572404677783, -122.39852289312)
38674	38674	217832	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Cranleigh Dr	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25	Width 7ft		5991396.48191	2095769.3933599999	37.7340888381105	-122.472166883492	(37.7340888381105, -122.472166883492)
165664	165664	217833	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Cranleigh Dr	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			50	Width 7ft		5991415.837069999	2095795.00823	37.734160290163295	-122.47210183374399	(37.7341602901633, -122.472101833744)
185495	185495	201722	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Lindsay Cir	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26			6016307.52162	2095597.12385	37.735025976661795	-122.386028821491	(37.7350259766618, -122.386028821491)
44314	44314	126179	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2 Marina Blvd	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			6003111.16889	2121419.1431	37.8051877435806	-122.43349799333201	(37.8051877435806, -122.433497993332)
174775	174775	206424	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	215 Baden St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16	Width 3ft		6000727.34044	2094799.13402	37.7319603029265	-122.439837728124	(37.7319603029265, -122.439837728124)
57355	57355	187371	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	2200 Sunset Blvd	56	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 0ft		5985087.8176	2099932.3285	37.745152031922295	-122.494284331613	(37.7451520319223, -122.494284331613)
58549	58549	212240	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	298 Staples Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10			5998225.68329	2093821.9579599998	37.7291344900407	-122.448416107518	(37.7291344900407, -122.448416107518)
59466	59466	212242	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	298 Staples Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12			5998209.43788	2093823.68596	37.729138305887496	-122.44847239338002	(37.7291383058875, -122.44847239338)
162764	162764	212241	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	298 Staples Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6			5998218.66289	2093822.9829099998	37.729136902922605	-122.448440451292	(37.7291369029226, -122.448440451292)
100050	100050	112184	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	301x CORBETT AVE	6	Sidewalk: Property side : Yard 9	Tree 1	DPW 2				3x3		5999677.0	2105220.0	37.760513648972996	-122.444217531177	(37.760513648973, -122.444217531177)
120666	120666	112186	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	301x CORBETT AVE	4	Sidewalk: Property side : Yard 9	Tree 1	DPW 2				3x3		5999677.0	2105220.0	37.760513648972996	-122.444217531177	(37.760513648973, -122.444217531177)
146135	146135	112185	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	301x CORBETT AVE	5	Sidewalk: Property side : Yard 9	Tree 1	DPW 2				3x3		5999677.0	2105220.0	37.760513648972996	-122.444217531177	(37.760513648973, -122.444217531177)
29142	29142	126167	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	430 Euclid Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19	Width 4ft		5997207.981819999	2113880.64934	37.784152383258295	-122.453381982209	(37.7841523832583, -122.453381982209)
32697	32697	126166	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	430 Euclid Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26	Width 4ft		5997218.88994	2113880.19727	37.784151767235606	-122.453344211568	(37.7841517672356, -122.453344211568)
154795	154795	126169	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	430 Euclid Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 6ft		5997183.22677	2113882.1582400003	37.7841551073202	-122.453467734347	(37.7841551073202, -122.453467734347)
167629	167629	126168	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	430 Euclid Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 7ft		5997192.90233	2113882.62114	37.7841569329389	-122.45343429398199	(37.7841569329389, -122.453434293982)
26390	26390	175993	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23	Width 5ft		5998911.6853	2090582.5176799998	37.720278936911605	-122.445811669969	(37.7202789369116, -122.445811669969)
38880	38880	175995	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 5ft		5998981.8742	2090546.54145	37.7201841618528	-122.44556646533	(37.7201841618528, -122.44556646533)
65217	65217	175989	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			27	Width 5ft		5998751.66703	2090666.1171099998	37.7204993436547	-122.446370809093	(37.7204993436547, -122.446370809093)
134505	134505	175990	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 5ft		5998767.87796	2090657.4852099998	37.7204765683114	-122.44631415267901	(37.7204765683114, -122.446314152679)
136147	136147	175994	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	16	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 5ft		5998943.08892	2090567.9508599997	37.7202407328088	-122.44570207140801	(37.7202407328088, -122.445702071408)
158283	158283	175992	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21	Width 5ft		5998869.40884	2090603.9997900003	37.7203355078481	-122.445959349454	(37.7203355078481, -122.445959349454)
170569	170569	175991	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	500 Geneva Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			14	Width 5ft		5998793.1265199995	2090644.11661	37.720441303198704	-122.44622591568998	(37.7204413031987, -122.44622591569)
167278	167278	126170	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	51 Collins St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25			5998098.55352	2114264.17782	37.78525645845	-122.4503285932	(37.78525645845, -122.4503285932)
36645	36645	248794	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	5175 Diamond Heights Blvd	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19			6000769.8942	2099922.22188	37.7460295209503	-122.440057831812	(37.7460295209503, -122.440057831812)
38559	38559	248795	Undocumented 2	Corymbia ficifolia :: Red Flowering Gum 60	5175 Diamond Heights Blvd	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			16			6000777.48804	2099988.6184	37.746212262280395	-122.440036333505	(37.7462122622804, -122.440036333505)

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