Street_Tree_List

Data source: data.sfgov.org

222 rows where PlotSize = "Width 3ft" and qSpecies = 97 sorted by TreeID

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, qSiteInfo, qCaretaker, DBH, PermitNotes

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
33051	33051	123914	Undocumented 2	Ceratonia siliqua :: Carob 97	389 09th Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993078.53663	2112857.8084299997	37.7811063777719	-122.467593853963	(37.7811063777719, -122.467593853963)
51566	51566	124321	Undocumented 2	Ceratonia siliqua :: Carob 97	115 Jordan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5996193.40211	2113658.2283900003	37.783483467186706	-122.45687595100901	(37.7834834671867, -122.456875951009)
32711	32711	124322	Undocumented 2	Ceratonia siliqua :: Carob 97	115 Jordan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5996192.87314	2113669.7360400003	37.7835150337529	-122.456878613619	(37.7835150337529, -122.456878613619)
71217	71217	125968	Undocumented 2	Ceratonia siliqua :: Carob 97	2810 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6001336.417830001	2115647.62359	37.7892398148051	-122.43922579254101	(37.7892398148051, -122.439225792541)
71848	71848	125969	Undocumented 2	Ceratonia siliqua :: Carob 97	2672 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6002023.76351	2115741.9503	37.7895379005066	-122.43685441882	(37.7895379005066, -122.43685441882)
58420	58420	125975	Undocumented 2	Ceratonia siliqua :: Carob 97	633 Beach St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6007035.474780001	2121873.14157	37.806656174619704	-122.41994966175601	(37.8066561746197, -122.419949661756)
182201	182201	125976	Undocumented 2	Ceratonia siliqua :: Carob 97	633 Beach St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6007074.37921	2121877.42075	37.8066701158897	-122.419815329109	(37.8066701158897, -122.419815329109)
174828	174828	125988	Undocumented 2	Ceratonia siliqua :: Carob 97	2361 Taylor St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008319.39655	2121673.00017	37.806178887323	-122.41549221341101	(37.806178887323, -122.415492213411)
160878	160878	125989	Undocumented 2	Ceratonia siliqua :: Carob 97	2361 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008326.45195	2121634.40634	37.8060733149832	-122.41546506288	(37.8060733149832, -122.41546506288)
57395	57395	125990	Undocumented 2	Ceratonia siliqua :: Carob 97	2361 Taylor St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008335.581590001	2121584.4344900004	37.8059366180507	-122.415429928145	(37.8059366180507, -122.415429928145)
25271	25271	125991	Undocumented 2	Ceratonia siliqua :: Carob 97	2361 Taylor St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6008338.82398	2121554.9566599997	37.805855861614795	-122.41541661910699	(37.8058558616148, -122.415416619107)
174972	174972	125992	Undocumented 2	Ceratonia siliqua :: Carob 97	2361 Taylor St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008341.11218	2121531.47257	37.8057915088426	-122.41540703681801	(37.8057915088426, -122.415407036818)
137305	137305	125993	Undocumented 2	Ceratonia siliqua :: Carob 97	2361 Taylor St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008342.4716300005	2121500.19485	37.8057057045282	-122.415400116539	(37.8057057045282, -122.415400116539)
188434	188434	125994	Undocumented 2	Ceratonia siliqua :: Carob 97	2361 Taylor St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6008347.52133	2121476.34798	37.805640510859206	-122.41538095198901	(37.8056405108592, -122.415380951989)
67946	67946	125995	Undocumented 2	Ceratonia siliqua :: Carob 97	2361 Taylor St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6008349.66203	2121453.17315	37.8055769989413	-122.41537190211201	(37.8055769989413, -122.415371902112)
26761	26761	175842	Undocumented 2	Ceratonia siliqua :: Carob 97	234 Vienna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6004274.97667	2092050.6197400002	37.724614796925	-122.427377064513	(37.724614796925, -122.427377064513)
176670	176670	175843	Undocumented 2	Ceratonia siliqua :: Carob 97	154 Vienna St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6004555.98826	2092507.33419	37.7258847232758	-122.42643814711501	(37.7258847232758, -122.426438147115)
185704	185704	188476	Undocumented 2	Ceratonia siliqua :: Carob 97	499 San Bruno Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		6010896.57818	2106030.2080599996	37.763371997828706	-122.405471012994	(37.7633719978287, -122.405471012994)
52630	52630	188477	Undocumented 2	Ceratonia siliqua :: Carob 97	499 San Bruno Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			16	Width 3ft		6010894.54885	2106022.4243799997	37.76335051213071	-122.40547748360301	(37.7633505121307, -122.405477483603)
119840	119840	188478	Undocumented 2	Ceratonia siliqua :: Carob 97	499 San Bruno Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		6010892.5271	2106015.01328	37.76333004987679	-122.40548395423401	(37.7633300498768, -122.405483954234)
30923	30923	188479	Undocumented 2	Ceratonia siliqua :: Carob 97	2208 Mariposa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6010817.79084	2106032.71885	37.763374486260204	-122.40574369103201	(37.7633744862602, -122.405743691032)
3247	3247	188481	Permitted Site 1	Ceratonia siliqua :: Carob 97	1570 Burke Ave	10	: 4	Tree 1	Private 1		08/24/2017 12:00:00 AM	3	Width 3ft		6016299.33242	2099120.87091	37.744701017238796	-122.38630272799999	(37.7447010172388, -122.386302728)
53695	53695	188483	Undocumented 2	Ceratonia siliqua :: Carob 97	1525 Burke Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6016580.588769999	2098830.3730200003	37.7439189335051	-122.38530995020399	(37.7439189335051, -122.385309950204)
54211	54211	188484	Undocumented 2	Ceratonia siliqua :: Carob 97	1525 Burke Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6016633.990259999	2098788.07165	37.743805736753394	-122.38512235163	(37.7438057367534, -122.38512235163)
156358	156358	188485	Undocumented 2	Ceratonia siliqua :: Carob 97	1525 Burke Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		6016660.6215	2098754.7402	37.7437156885266	-122.385027944407	(37.7437156885266, -122.385027944407)
179366	179366	188486	Undocumented 2	Ceratonia siliqua :: Carob 97	1525 Burke Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6016667.7961	2098739.5766	37.7436744492327	-122.385002079878	(37.7436744492327, -122.385002079878)
43136	43136	188487	Undocumented 2	Ceratonia siliqua :: Carob 97	1525 Burke Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6016679.39003	2098723.9070200003	37.74363206505979	-122.384960899022	(37.7436320650598, -122.384960899022)
3206	3206	189833	DPW Maintained 3	Ceratonia siliqua :: Carob 97	1570 Burke Ave	2	: 4	Tree 1	DPW 2		02/12/2016 12:00:00 AM	14	Width 3ft		6016585.78665	2098909.19771	37.7441356575455	-122.385297468507	(37.7441356575455, -122.385297468507)
132013	132013	189839	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	1	: 4	Tree 1	Private 1			1	Width 3ft		6017074.26086	2098217.41845	37.7422631836031	-122.38356026519699	(37.7422631836031, -122.383560265197)
160768	160768	189840	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	2	: 4	Tree 1	Private 1			3	Width 3ft		6017094.37686	2098212.93845	37.7422519942486	-122.383490397763	(37.7422519942486, -122.383490397763)
38544	38544	189841	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	3	: 4	Tree 1	Private 1			1	Width 3ft		6017113.188630001	2098207.21128	37.742237308295294	-122.38342495321899	(37.7422373082953, -122.383424953219)
147716	147716	189842	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	4	: 4	Tree 1	Private 1			7	Width 3ft		6017136.0861599995	2098201.14709	37.7422219227174	-122.383345357813	(37.7422219227174, -122.383345357813)
157640	157640	189843	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	5	: 4	Tree 1	Private 1			1	Width 3ft		6017155.58292	2098191.33075	37.742196046505	-122.38327726024599	(37.742196046505, -122.383277260246)
184302	184302	189844	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6017173.06513	2098183.08322	37.742174366561606	-122.383216237654	(37.7421743665616, -122.383216237654)
32657	32657	189845	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	7	: 4	Tree 1	Private 1			6	Width 3ft		6017192.34248	2098175.05438	37.7421533862633	-122.383149023221	(37.7421533862633, -122.383149023221)
131320	131320	189846	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	8	: 4	Tree 1	Private 1			1	Width 3ft		6017214.17115	2098166.7194	37.7421317063069	-122.383072965771	(37.7421317063069, -122.383072965771)
60830	60830	189847	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	9	: 4	Tree 1	Private 1			1	Width 3ft		6017231.39271	2098158.2223400003	37.7421093266962	-122.383012827183	(37.7421093266962, -122.383012827183)
131495	131495	189850	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	14	: 4	Tree 1	Private 1			9	Width 3ft		6017345.725190001	2098082.05897	37.7419065142755	-122.382612199015	(37.7419065142755, -122.382612199015)
137584	137584	189851	Undocumented 2	Ceratonia siliqua :: Carob 97	101 Newhall St	15	: 4	Tree 1	Private 1			12	Width 3ft		6017359.84801	2098072.09609	37.741879938402704	-122.38256267332198	(37.7418799384027, -122.382562673322)
33099	33099	189852	Undocumented 2	Ceratonia siliqua :: Carob 97	100 Newhall St	2	: 4	Tree 1	Private 1			8	Width 3ft		6017365.88907	2098130.81013	37.7420414890213	-122.38254586948999	(37.7420414890213, -122.38254586949)
179431	179431	189853	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	1	: 4	Tree 1	Private 1			8	Width 3ft		6017352.03209	2098141.27696	37.742069463331106	-122.382594511142	(37.7420694633311, -122.382594511142)
173588	173588	189854	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	4	: 4	Tree 1	Private 1			10	Width 3ft		6017283.71117	2098187.47887	37.742192549946104	-122.38283396012599	(37.7421925499461, -122.382833960126)
158918	158918	189855	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	5	: 4	Tree 1	Private 1			9	Width 3ft		6017245.40272	2098209.38961	37.7422505957884	-122.382967944715	(37.7422505957884, -122.382967944715)
156617	156617	189856	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	6	: 4	Tree 1	Private 1			6	Width 3ft		6017223.11391	2098220.2806700002	37.742279268865104	-122.383045771154	(37.7422792688651, -122.383045771154)
162643	162643	189859	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	9	: 4	Tree 1	Private 1			7	Width 3ft		6017171.36242	2098242.65136	37.7423378345214	-122.38322627048001	(37.7423378345214, -122.38322627048)
135439	135439	189860	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	10	: 4	Tree 1	Private 1			7	Width 3ft		6017146.31011	2098252.64566	37.74236389238379	-122.38331359014299	(37.7423638923838, -122.383313590143)
49848	49848	189861	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	11	: 4	Tree 1	Private 1			8	Width 3ft		6017125.66493	2098258.40905	37.742378576526	-122.38338537673799	(37.742378576526, -122.383385376738)
156633	156633	189862	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	12	: 4	Tree 1	Private 1			7	Width 3ft		6017103.28687	2098264.2675900003	37.7423934261135	-122.383463161819	(37.7423934261135, -122.383463161819)
67535	67535	189863	Undocumented 2	Ceratonia siliqua :: Carob 97	102 Newhall St	13	: 4	Tree 1	Private 1			9	Width 3ft		6017087.002669999	2098268.01639	37.742402819541795	-122.383519729148	(37.7424028195418, -122.383519729148)
46617	46617	189864	Undocumented 2	Ceratonia siliqua :: Carob 97	501 Newhall St	1	: 4	Tree 1	Private 1			16	Width 3ft		6015974.53489	2097767.4819400003	37.7409669053009	-122.387331434622	(37.7409669053009, -122.387331434622)
182504	182504	189867	Undocumented 2	Ceratonia siliqua :: Carob 97	401 Newhall St	2	: 4	Tree 1	Private 1			16	Width 3ft		6016089.46635	2097928.7080599996	37.7414159637784	-122.38694528191999	(37.7414159637784, -122.38694528192)
130575	130575	189868	Undocumented 2	Ceratonia siliqua :: Carob 97	401 Newhall St	3	: 4	Tree 1	Private 1			7	Width 3ft		6016117.80915	2097961.55377	37.7415077207098	-122.38684957154899	(37.7415077207098, -122.386849571549)
69864	69864	189869	Undocumented 2	Ceratonia siliqua :: Carob 97	401 Newhall St	4	: 4	Tree 1	Private 1			13	Width 3ft		6016127.95859	2097976.0947	37.7415482090816	-122.38681549176	(37.7415482090816, -122.38681549176)
39389	39389	189870	Undocumented 2	Ceratonia siliqua :: Carob 97	401 Newhall St	5	: 4	Tree 1	Private 1			13	Width 3ft		6016138.74056	2097991.9117	37.741592236291396	-122.386779313807	(37.7415922362914, -122.386779313807)
165750	165750	189871	Undocumented 2	Ceratonia siliqua :: Carob 97	400 Newhall St	9	: 4	Tree 1	Private 1			7	Width 3ft		6016028.58203	2097927.48174	37.741409225160396	-122.387155715173	(37.7414092251604, -122.387155715173)
163194	163194	189875	Undocumented 2	Ceratonia siliqua :: Carob 97	400 Newhall St	15	: 4	Tree 1	Private 1			12	Width 3ft		6015903.72942	2097762.72481	37.740949921590904	-122.387575924289	(37.7409499215909, -122.387575924289)
62858	62858	189876	Undocumented 2	Ceratonia siliqua :: Carob 97	375 Newhall St	8	: 4	Tree 1	Private 1			8	Width 3ft		6016406.62692	2098319.91707	37.7425077002596	-122.385875902556	(37.7425077002596, -122.385875902556)
167349	167349	189877	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	2	: 4	Tree 1	Private 1			7	Width 3ft		6016448.8562900005	2098333.07564	37.7425461678608	-122.38573080145099	(37.7425461678608, -122.385730801451)
181190	181190	189878	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	3	: 4	Tree 1	Private 1			7	Width 3ft		6016474.87335	2098336.17477	37.742556117060104	-122.38564105721399	(37.7425561170601, -122.385641057214)
157879	157879	189879	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	4	: 4	Tree 1	Private 1			8	Width 3ft		6016498.145380001	2098335.4641	37.7425554533749	-122.385560539098	(37.7425554533749, -122.385560539098)
74473	74473	189880	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	5	: 4	Tree 1	Private 1			7	Width 3ft		6016536.79452	2098327.4391099997	37.742535556771	-122.385426341355	(37.742535556771, -122.385426341355)
135246	135246	189881	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	6	: 4	Tree 1	Private 1			10	Width 3ft		6016559.498980001	2098322.6337200003	37.7425236182725	-122.385347500499	(37.7425236182725, -122.385347500499)
130083	130083	189882	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	7	: 4	Tree 1	Private 1			9	Width 3ft		6016580.99088	2098317.85278	37.742511679775205	-122.385272854085	(37.7425116797752, -122.385272854085)
135669	135669	189883	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	9	: 4	Tree 1	Private 1			8	Width 3ft		6016619.88237	2098309.8227	37.7424917822737	-122.38513781816201	(37.7424917822737, -122.385137818162)
74900	74900	189884	Undocumented 2	Ceratonia siliqua :: Carob 97	325 Newhall St	12	: 4	Tree 1	Private 1			8	Width 3ft		6016685.38219	2098298.11667	37.7424632629752	-122.384910521712	(37.7424632629752, -122.384910521712)
156493	156493	189885	Undocumented 2	Ceratonia siliqua :: Carob 97	201 Newhall St	6	: 4	Tree 1	Private 1			3	Width 3ft		6016834.26905	2098267.19561	37.7423865939792	-122.38439355723601	(37.7423865939792, -122.384393557236)
170703	170703	189886	Undocumented 2	Ceratonia siliqua :: Carob 97	201 Newhall St	7	: 4	Tree 1	Private 1			6	Width 3ft		6016892.13311	2098254.09694	37.7423538271607	-122.384192566831	(37.7423538271607, -122.384192566831)
132365	132365	189887	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	1	: 4	Tree 1	Private 1			10	Width 3ft		6016910.34518	2098303.24769	37.742489792067104	-122.384133016442	(37.7424897920671, -122.384133016442)
38692	38692	189888	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	2	: 4	Tree 1	Private 1			6	Width 3ft		6016891.26784	2098307.49665	37.7425004040788	-122.384199276697	(37.7425004040788, -122.384199276697)
65891	65891	189889	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	3	: 4	Tree 1	Private 1			7	Width 3ft		6016866.9099	2098314.50918	37.7425183122785	-122.38428398832501	(37.7425183122785, -122.384283988325)
27659	27659	189891	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	5	: 4	Tree 1	Private 1			4	Width 3ft		6016826.79146	2098321.83879	37.7425362195639	-122.384423217764	(37.7425362195639, -122.384423217764)
166172	166172	189893	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	7	: 4	Tree 1	Private 1			10	Width 3ft		6016784.24817	2098329.2173099997	37.7425541268854	-122.384570835175	(37.7425541268854, -122.384570835175)
54002	54002	189894	Undocumented 2	Ceratonia siliqua :: Carob 97	200 Newhall St	8	: 4	Tree 1	Private 1			10	Width 3ft		6016764.20599	2098333.7275	37.742565402576794	-122.384640449909	(37.7425654025768, -122.384640449909)
66110	66110	189895	Undocumented 2	Ceratonia siliqua :: Carob 97	220 Newhall St	2	: 4	Tree 1	Private 1			9	Width 3ft		6016704.91422	2098345.41637	37.7425942186412	-122.384846279543	(37.7425942186412, -122.384846279543)
165324	165324	189897	Undocumented 2	Ceratonia siliqua :: Carob 97	220 Newhall St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6016662.64586	2098353.63161	37.742614438102706	-122.384993004817	(37.7426144381027, -122.384993004817)
74466	74466	189898	Undocumented 2	Ceratonia siliqua :: Carob 97	220 Newhall St	5	: 4	Tree 1	Private 1			10	Width 3ft		6016641.64949	2098357.6793299997	37.7426243909147	-122.385065886799	(37.7426243909147, -122.385065886799)
173621	173621	189899	Undocumented 2	Ceratonia siliqua :: Carob 97	300 Newhall St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6016506.94741	2098386.01279	37.7426947367801	-122.385533625971	(37.7426947367801, -122.385533625971)
130592	130592	189900	Undocumented 2	Ceratonia siliqua :: Carob 97	300 Newhall St	8	: 4	Tree 1	Private 1			10	Width 3ft		6016469.439569999	2098386.38148	37.7426936737758	-122.38566334421199	(37.7426936737758, -122.385663344212)
165480	165480	189901	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			7	Width 3ft		6016452.46192	2098385.2163400003	37.742689535099395	-122.385721967406	(37.7426895350994, -122.385721967406)
55275	55275	189902	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	Width 3ft		6016433.67399	2098382.99048	37.7426823836985	-122.385786776164	(37.7426823836985, -122.385786776164)
155880	155880	189903	Undocumented 2	Ceratonia siliqua :: Carob 97	350 Newhall St	3	: 4	Tree 1	Private 1			11	Width 3ft		6016414.85135	2098379.02943	37.742670465863796	-122.38585158400801	(37.7426704658638, -122.385851584008)
168386	168386	189904	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			11	Width 3ft		6016400.23461	2098374.6941	37.742657753052505	-122.38590182282499	(37.7426577530525, -122.385901822825)
77182	77182	189905	Undocumented 2	Ceratonia siliqua :: Carob 97	350 Newhall St	6	: 4	Tree 1	Private 1			12	Width 3ft		6016340.3864	2098339.29531	37.7425572430226	-122.386106295385	(37.7425572430226, -122.386106295385)
168105	168105	189908	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			8	Width 3ft		6016294.30511	2098287.7036099997	37.7424130322313	-122.38626203636998	(37.7424130322313, -122.38626203637)
163101	163101	189909	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			9	Width 3ft		6016264.27306	2098246.63974	37.7422986168968	-122.386363016745	(37.7422986168968, -122.386363016745)
26487	26487	189910	DPW Maintained 3	Ceratonia siliqua :: Carob 97	350 Newhall St	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			14	Width 3ft		6016250.22154	2098227.10108	37.742244189916704	-122.386410241063	(37.7422441899167, -122.386410241063)
166137	166137	189911	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	7	: 4	Tree 1	Private 1			5	Width 3ft		6013879.72064	2094387.8060700002	37.73157077506371	-122.394338012196	(37.7315707750637, -122.394338012196)
67550	67550	189912	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	8	: 4	Tree 1	Private 1			4	Width 3ft		6013884.75868	2094408.4745200002	37.7316278064595	-122.394322041155	(37.7316278064595, -122.394322041155)
72242	72242	189913	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	9	: 4	Tree 1	Private 1			6	Width 3ft		6013888.27035	2094422.90108	37.731667614051	-122.39431091023	(37.731667614051, -122.39431091023)
173975	173975	189914	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	11	: 4	Tree 1	Private 1			5	Width 3ft		6013894.185819999	2094452.33408	37.7317487598799	-122.394292519091	(37.7317487598799, -122.394292519091)
74016	74016	189915	Undocumented 2	Ceratonia siliqua :: Carob 97	1 Flora St	13	: 4	Tree 1	Private 1			5	Width 3ft		6013899.07383	2094479.41823	37.7318233991302	-122.394277515688	(37.7318233991302, -122.394277515688)
31280	31280	189919	Undocumented 2	Ceratonia siliqua :: Carob 97	338 Mission St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6013770.13743	2116011.13859	37.7909376251249	-122.396231800058	(37.7909376251249, -122.396231800058)
178915	178915	189920	Undocumented 2	Ceratonia siliqua :: Carob 97	338 Mission St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6013751.034659999	2115995.6768400003	37.790894107822794	-122.396296811166	(37.7908941078228, -122.396296811166)
53404	53404	189942	Undocumented 2	Ceratonia siliqua :: Carob 97	160 Spear St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6014651.73587	2116280.65037	37.7917266570015	-122.39320034911199	(37.7917266570015, -122.393200349112)
58573	58573	189943	Undocumented 2	Ceratonia siliqua :: Carob 97	160 Spear St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6014663.902869999	2116268.03372	37.7916926905231	-122.39315736781299	(37.7916926905231, -122.393157367813)
170749	170749	189944	Undocumented 2	Ceratonia siliqua :: Carob 97	162 Spear St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6014676.15778	2116259.76194	37.791670658917106	-122.393114386531	(37.7916706589171, -122.393114386531)
55327	55327	189949	Undocumented 2	Ceratonia siliqua :: Carob 97	120 Howard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6014767.16396	2116087.91405	37.791203859513004	-122.392787475772	(37.791203859513, -122.392787475772)
96732	96732	189953	Undocumented 2	Ceratonia siliqua :: Carob 97	120 Howard St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6014700.62775	2116023.46282	37.7910231956157	-122.39301317951201	(37.7910231956157, -122.393013179512)
35349	35349	189956	Undocumented 2	Ceratonia siliqua :: Carob 97	572 07th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6011467.9689	2109652.48068	37.773349868946205	-122.403749639528	(37.7733498689462, -122.403749639528)
166259	166259	189957	Undocumented 2	Ceratonia siliqua :: Carob 97	572 07th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		6011483.58307	2109635.35024	37.773303704933895	-122.40369442207701	(37.7733037049339, -122.403694422077)

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