Street_Tree_List

Data source: data.sfgov.org

136 rows where SiteOrder = 2 and qSpecies = 97 sorted by Longitude

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
150091	150091	206006	Undocumented 2	Ceratonia siliqua :: Carob 97	600 Vicente St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 3ft		5991049.3393	2097743.54574	37.7394892625221	-122.473511002145	(37.7394892625221, -122.473511002145)
101854	101854	114592	Undocumented 2	Ceratonia siliqua :: Carob 97	70 LOMITA AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3x3		5991433.0	2104626.0	37.7584089066312	-122.472686161822	(37.7584089066312, -122.472686161822)
186595	186595	206002	Undocumented 2	Ceratonia siliqua :: Carob 97	1593 15th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5991725.37276	2104496.31776	37.758069753342205	-122.47166556633199	(37.7580697533422, -122.471665566332)
187567	187567	218314	Undocumented 2	Ceratonia siliqua :: Carob 97	437 Castenada Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5993129.70143	2099920.62697	37.7455872325622	-122.466476271275	(37.7455872325622, -122.466476271275)
45186	45186	205991	Undocumented 2	Ceratonia siliqua :: Carob 97	452 Kenwood Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5993388.91946	2093682.37508	37.72847350453279	-122.465126926677	(37.7284735045328, -122.465126926677)
176560	176560	205994	Undocumented 2	Ceratonia siliqua :: Carob 97	334 Pacheco St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5994253.11993	2101023.44894	37.7486800649323	-122.462671676761	(37.7486800649323, -122.462671676761)
119338	119338	113383	Undocumented 2	Ceratonia siliqua :: Carob 97	146 CASTENADA AVE	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	3x3		5994461.0	2101055.0	37.7487786662853	-122.46195512222401	(37.7487786662853, -122.461955122224)
66533	66533	206019	Undocumented 2	Ceratonia siliqua :: Carob 97	99 Merced Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		5994816.51833	2099704.78199	37.745091768175605	-122.460627918846	(37.7450917681756, -122.460627918846)
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)
43464	43464	206016	Undocumented 2	Ceratonia siliqua :: Carob 97	1500 Plymouth Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995893.6658	2094152.61505	37.7299087874515	-122.45650193453899	(37.7299087874515, -122.456501934539)
151522	151522	206017	Undocumented 2	Ceratonia siliqua :: Carob 97	59 Hazelwood Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5996580.0039099995	2094034.75678	37.72962455671671	-122.454120687124	(37.7296245567167, -122.454120687124)
162230	162230	225060	Undocumented 2	Ceratonia siliqua :: Carob 97	243 Parnassus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		5997087.67897	2106671.87912	37.76435207719771	-122.453277577199	(37.7643520771977, -122.453277577199)
177491	177491	222921	Undocumented 2	Ceratonia siliqua :: Carob 97	957 Cole St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	Width 4ft		5998078.46928	2106885.24351	37.7649946607859	-122.44986610424601	(37.7649946607859, -122.449866104246)
71127	71127	222923	Undocumented 2	Ceratonia siliqua :: Carob 97	88 Parnassus Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 4ft		5998162.74598	2106870.63901	37.764959382183704	-122.449573561064	(37.7649593821837, -122.449573561064)
35726	35726	222928	Undocumented 2	Ceratonia siliqua :: Carob 97	912 Clayton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		5998758.16977	2106859.07637	37.764961679071796	-122.447513315894	(37.7649616790718, -122.447513315894)
92019	92019	94581	Permitted Site 1	Ceratonia siliqua :: Carob 97	1025 Clayton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				4x4		5998825.0	2106371.0	37.763625362932	-122.44724703752199	(37.763625362932, -122.447247037522)
23379	23379	222925	Undocumented 2	Ceratonia siliqua :: Carob 97	1025 Clayton St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		5998825.08997	2106348.09575	37.763562478748604	-122.44724507779499	(37.7635624787486, -122.447245077795)
45915	45915	205996	Undocumented 2	Ceratonia siliqua :: Carob 97	30 Molimo Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		5998822.4881	2096514.65172	37.736562095172296	-122.446546561796	(37.7365620951723, -122.446546561796)
20488	20488	82142	Permitted Site 1	Ceratonia siliqua :: Carob 97	30 Molimo Dr	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/25/2007 12:00:00 AM		3x3	Permit Number 49838	5998889.06181671	2096571.98929044	37.736723332936	-122.446320512355	(37.736723332936, -122.446320512355)
161602	161602	225042	Undocumented 2	Ceratonia siliqua :: Carob 97	979 Ashbury St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		5999193.16537	2106656.55415	37.764430453131105	-122.44599421345801	(37.7644304531311, -122.445994213458)
142096	142096	10409	DPW Maintained 3	Ceratonia siliqua :: Carob 97	1398 HAIGHT ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	3x3		5999436.0	2108778.0	37.7702692735678	-122.445306860847	(37.7702692735678, -122.445306860847)
65381	65381	138240	Undocumented 2	Ceratonia siliqua :: Carob 97	1509 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		5999643.6372	2114098.2225	37.7848890921049	-122.444971161243	(37.7848890921049, -122.444971161243)
175276	175276	139007	Undocumented 2	Ceratonia siliqua :: Carob 97	1504 Lyon St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			14	Width 0ft		5999691.7088	2114071.461	37.78481835543629	-122.444802925313	(37.7848183554363, -122.444802925313)
89436	89436	110184	Undocumented 2	Ceratonia siliqua :: Carob 97	1500x LYON ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5999718.0	2114083.0	37.7848515388794	-122.444712796347	(37.7848515388794, -122.444712796347)
175525	175525	139056	Undocumented 2	Ceratonia siliqua :: Carob 97	2693 SUTTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 0ft		5999748.2433	2113980.0087	37.7845704772917	-122.44460075979201	(37.7845704772917, -122.444600759792)
4380	4380	106727	Undocumented 2	Ceratonia siliqua :: Carob 97	2809 Bush St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	3x3		6000017.8025	2114366.8285	37.785647962066996	-122.443695977864	(37.785647962067, -122.443695977864)
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)
116782	116782	4389	DPW Maintained 3	Ceratonia siliqua :: Carob 97	56 Chilton Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		06/09/2008 12:00:00 AM	30	3x3		6001657.8215553	2095631.9001159	37.7342998083721	-122.436680450501	(37.7342998083721, -122.436680450501)
35568	35568	225084	Undocumented 2	Ceratonia siliqua :: Carob 97	3784 22nd St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6003185.26448	2103031.00379	37.7547027131682	-122.43192775097401	(37.7547027131682, -122.431927750974)
42092	42092	115843	Undocumented 2	Ceratonia siliqua :: Carob 97	1500 Bay St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	3x3		6003556.384769999	2120742.54729	37.80335523820229	-122.431908928161	(37.8033552382023, -122.431908928161)
161217	161217	140579	Undocumented 2	Ceratonia siliqua :: Carob 97	949 FILLMORE ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 0ft		6003399.7999	2111643.4846	37.7783626547096	-122.43180072975201	(37.7783626547096, -122.431800729752)
3418	3418	18865	DPW Maintained 3	Ceratonia siliqua :: Carob 97	2230 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6003863.26827	2115999.97726	37.7903507527417	-122.43050834919501	(37.7903507527417, -122.430508349195)
7048	7048	18853	Permitted Site 1	Ceratonia siliqua :: Carob 97	2222 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3X3		6004009.33777	2116018.08762	37.7904087527096	-122.430004251319	(37.7904087527096, -122.430004251319)
1160	1160	18860	DPW Maintained 3	Ceratonia siliqua :: Carob 97	2212 Sacramento St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6004055.90045	2116026.39415	37.7904341972353	-122.429843740294	(37.7904341972353, -122.429843740294)
188742	188742	246420	Undocumented 2	Ceratonia siliqua :: Carob 97	400 Duncan St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		6003851.19686	2099854.61267	37.7460188154337	-122.42939827552401	(37.7460188154337, -122.429398275524)
30270	30270	225097	Undocumented 2	Ceratonia siliqua :: Carob 97	290 Waller St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17	Width 3ft		6004333.63591	2109116.4123400003	37.7714768248196	-122.42839007973998	(37.7714768248196, -122.42839007974)
103487	103487	50383	Permitted Site 1	Ceratonia siliqua :: Carob 97	296 Liberty St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/01/2003 12:00:00 AM			Permit Number 47041	6004379.7762802	2103977.8532583998	37.75737018369129	-122.427864268021	(37.7573701836913, -122.427864268021)
33581	33581	222905	Undocumented 2	Ceratonia siliqua :: Carob 97	363 Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6004739.789609999	2109820.49268	37.7734330328342	-122.427035328438	(37.7734330328342, -122.427035328438)
78776	78776	85052	Permitted Site 1	Ceratonia siliqua :: Carob 97	355x Page St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3		06/27/2007 12:00:00 AM			Permit Number 49332	6004826.8	2109751.4	37.7732482408903	-122.426729425627	(37.7732482408903, -122.426729425627)
1440	1440	222893	DPW Maintained 3	Ceratonia siliqua :: Carob 97	301 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	Width 4ft		6004914.2278	2106488.73534	37.7642946914815	-122.426194676362	(37.7642946914815, -122.426194676362)
140463	140463	5384	DPW Maintained 3	Ceratonia siliqua :: Carob 97	325X Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			90	4X4		6004919.4864142	2106495.5645768	37.7643137401636	-122.426176974515	(37.7643137401636, -122.426176974515)
125039	125039	438	DPW Maintained 3	Ceratonia siliqua :: Carob 97	792X Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			80	6		6004975.0011312	2103729.1085203	37.7567208435744	-122.425788038834	(37.7567208435744, -122.425788038834)
21055	21055	5523	DPW Maintained 3	Ceratonia siliqua :: Carob 97	865 Dolores St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			50	3X3		6005084.41522	2103351.40166	37.755689931362795	-122.425382766602	(37.7556899313628, -122.425382766602)
127740	127740	14687	DPW Maintained 3	Ceratonia siliqua :: Carob 97	775 McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	4x4		6005346.74925	2111820.94662	37.7789600951073	-122.425078130411	(37.7789600951073, -122.425078130411)
8392	8392	23566	Permitted Site 1	Ceratonia siliqua :: Carob 97	2958 Van Ness Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/09/2005 12:00:00 AM	6			6005632.06356	2120580.6858200002	37.8030282582004	-122.424714436346	(37.8030282582004, -122.424714436346)
39112	39112	140022	Undocumented 2	Ceratonia siliqua :: Carob 97	775 MCALLISTER ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 0ft		6005467.685	2112000.1843	37.7794590687234	-122.424672518677	(37.7794590687234, -122.424672518677)
102458	102458	22886	DPW Maintained 3	Ceratonia siliqua :: Carob 97	95X Valencia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			30	3x3		6006042.93395	2109155.55847	37.771680885423606	-122.422480302267	(37.7716808854236, -122.422480302267)
167348	167348	225101	Undocumented 2	Ceratonia siliqua :: Carob 97	75 Valencia St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 5ft		6006050.3801	2109334.27291	37.7721720124675	-122.42246724636601	(37.7721720124675, -122.422467246366)
564	564	222895	Permitted Site 1	Ceratonia siliqua :: Carob 97	3080 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft	Permit Number 27054	6006273.18784	2106724.0940099997	37.765017648370105	-122.42151112584801	(37.7650176483701, -122.421511125848)
112036	112036	101042	Permitted Site 1	Ceratonia siliqua :: Carob 97	655 Beach St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1					Permit Number 47845	6006837.0	2121873.0	37.8066446021589	-122.42063651284501	(37.8066446021589, -122.420636512845)
7418	7418	11180	DPW Maintained 3	Ceratonia siliqua :: Carob 97	2750X Hyde St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6006892.18437	2121805.14198	37.806461391357004	-122.420440716763	(37.806461391357, -122.420440716763)
54617	54617	125973	Undocumented 2	Ceratonia siliqua :: Carob 97	633 Beach St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6006932.43872	2121860.17562	37.8066147680158	-122.420305317544	(37.8066147680158, -122.420305317544)
167049	167049	248271	Undocumented 2	Ceratonia siliqua :: Carob 97	157 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006700.68835	2098666.52237	37.7429175024299	-122.419460818167	(37.7429175024299, -122.419460818167)
126258	126258	111887	Undocumented 2	Ceratonia siliqua :: Carob 97	140 LUNDYS LN	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3x12		6006709.0	2098750.0	37.7431471814186	-122.41943799965	(37.7431471814186, -122.41943799965)
50402	50402	248264	Undocumented 2	Ceratonia siliqua :: Carob 97	140 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6006711.60121	2098736.3727599997	37.743109910586	-122.419428038785	(37.743109910586, -122.419428038785)
45389	45389	248262	Undocumented 2	Ceratonia siliqua :: Carob 97	136 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 3ft		6006723.28629	2098755.01317	37.743161751109	-122.41938895693	(37.743161751109, -122.41938895693)
46452	46452	248275	Undocumented 2	Ceratonia siliqua :: Carob 97	137 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6006752.53211	2098758.7700799997	37.743173713897	-122.41928809889299	(37.743173713897, -122.419288098893)
66722	66722	248258	Undocumented 2	Ceratonia siliqua :: Carob 97	120 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			15	Width 3ft		6006769.1868199995	2098841.93634	37.7434030077589	-122.41923640944201	(37.7434030077589, -122.419236409442)
45296	45296	248254	Undocumented 2	Ceratonia siliqua :: Carob 97	112 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 3ft		6006798.65634	2098892.16282	37.7435425780247	-122.419138073069	(37.7435425780247, -122.419138073069)
113525	113525	113693	Undocumented 2	Ceratonia siliqua :: Carob 97	112 LUNDYS LN	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x5		6006814.0	2098928.0	37.7436418429474	-122.419087559811	(37.7436418429474, -122.419087559811)
85788	85788	57557	Permitted Site 1	Ceratonia siliqua :: Carob 97	88 LUNDYS LN	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		10/26/1976 12:00:00 AM	8	3x3	Permit Number 16422	6006885.0	2099070.0	37.744035741100504	-122.418852127392	(37.7440357411005, -122.418852127392)
32338	32338	248196	Undocumented 2	Ceratonia siliqua :: Carob 97	99 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6006902.26536	2099037.70953	37.7439480508589	-122.41879013796101	(37.7439480508589, -122.418790137961)
65155	65155	248201	Undocumented 2	Ceratonia siliqua :: Carob 97	53 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6006949.2101	2099121.02775	37.7441794671077	-122.41863372066601	(37.7441794671077, -122.418633720666)
149968	149968	248204	Undocumented 2	Ceratonia siliqua :: Carob 97	47 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6006982.897919999	2099182.4975099997	37.744350145854796	-122.418521593214	(37.7443501458548, -122.418521593214)
172679	172679	248207	Undocumented 2	Ceratonia siliqua :: Carob 97	39 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		6007026.812390001	2099268.29908	37.7445882098712	-122.41837582837601	(37.7445882098712, -122.418375828376)
150639	150639	248209	Undocumented 2	Ceratonia siliqua :: Carob 97	37 Lundy's Ln	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6007043.43628	2099296.21325	37.7446657917085	-122.418320324941	(37.7446657917085, -122.418320324941)
138752	138752	48532	Permitted Site 1	Ceratonia siliqua :: Carob 97	500(REVISED) Capp St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/22/2002 12:00:00 AM			Permit Number 45857	6007225.9541014	2104383.62172477	37.7586449307205	-122.41804980128	(37.7586449307205, -122.41804980128)
120289	120289	96855	Undocumented 2	Ceratonia siliqua :: Carob 97	600 Eugenia Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3x3		6007257.0	2097738.0	37.740399305054005	-122.41747145076599	(37.740399305054, -122.417471450766)
67137	67137	125997	Undocumented 2	Ceratonia siliqua :: Carob 97	2510 Jones St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6007910.60432	2121475.9089200003	37.8056147389887	-122.416892938958	(37.8056147389887, -122.416892938958)
159567	159567	51299	Permitted Site 1	Ceratonia siliqua :: Carob 97	300X Golden Gate Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	09/07/2004 12:00:00 AM	10		Permit Number 47670	6008033.00976	2112757.64367	37.781683418708404	-122.415851598691	(37.7816834187084, -122.415851598691)
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)
90047	90047	21787	Permitted Site 1	Ceratonia siliqua :: Carob 97	2585 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	4X4		6008331.30284	2121636.25204	37.806078655460894	-122.41544840628201	(37.8060786554609, -122.415448406282)
4810	4810	188468	Undocumented 2	Ceratonia siliqua :: Carob 97	255 12th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			17	Width 5ft		6008096.35172	2108912.02487	37.7711278249234	-122.415360138963	(37.7711278249234, -122.415360138963)
86378	86378	21780	Permitted Site 1	Ceratonia siliqua :: Carob 97	2535 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	4X4		6008357.89402	2121452.8869	37.805576675639	-122.41534339379	(37.805576675639, -122.41534339379)
188551	188551	125981	Undocumented 2	Ceratonia siliqua :: Carob 97	2362 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			19	Width 6ft		6008384.91577	2121552.17509	37.8058508146246	-122.415256913874	(37.8058508146246, -122.415256913874)
174929	174929	125978	Undocumented 2	Ceratonia siliqua :: Carob 97	2360 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 4ft		6008392.85025	2121496.40648	37.8056981340166	-122.415225505068	(37.8056981340166, -122.415225505068)
88377	88377	21777	Permitted Site 1	Ceratonia siliqua :: Carob 97	2500X Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		12/15/1992 12:00:00 AM	3	3x3		6008409.452819999	2121407.87429	37.8054559800011	-122.415161778523	(37.8054559800011, -122.415161778523)
97576	97576	21793	DPW Maintained 3	Ceratonia siliqua :: Carob 97	2598 Taylor St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	4X4		6008439.13676	2121624.27905	37.8060518410095	-122.41507438015499	(37.8060518410095, -122.415074380155)
125918	125918	103687	Undocumented 2	Ceratonia siliqua :: Carob 97	903 SHOTWELL ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			24	3x3		6008052.0	2102672.0	37.7539916655216	-122.41507179826799	(37.7539916655216, -122.415071798268)
112758	112758	21782	Permitted Site 1	Ceratonia siliqua :: Carob 97	2550 TAYLOR ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	5x5		6008458.6	2121488.8	37.8056809434427	-122.414997429015	(37.8056809434427, -122.414997429015)
84282	84282	105450	Undocumented 2	Ceratonia siliqua :: Carob 97	890 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						6009082.7	2103985.1	37.7576550089679	-122.411600148106	(37.7576550089679, -122.411600148106)
152050	152050	225080	Undocumented 2	Ceratonia siliqua :: Carob 97	2823 21st St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		6009082.12028	2103902.9950900003	37.7574295349581	-122.411596352099	(37.7574295349581, -122.411596352099)
74205	74205	225045	Undocumented 2	Ceratonia siliqua :: Carob 97	881 Alabama St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6009145.122330001	2103987.25914	37.7576644387915	-122.411384417877	(37.7576644387915, -122.411384417877)
74533	74533	222898	Undocumented 2	Ceratonia siliqua :: Carob 97	2771 22nd St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21	Width 6ft		6009527.7031	2103333.9306400004	37.7558919964247	-122.410015170384	(37.7558919964247, -122.410015170384)
14483	14483	7418	DPW Maintained 3	Ceratonia siliqua :: Carob 97	1090 Folsom St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	3X3		6010342.8854	2110986.7114	37.77695044101711	-122.407735574616	(37.7769504410171, -122.407735574616)
109877	109877	103340	Undocumented 2	Ceratonia siliqua :: Carob 97	590X 09th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	3x3	Permit Number 772809	6010323.0	2108639.0	37.7705030566796	-122.407638793146	(37.7705030566796, -122.407638793146)
138105	138105	222902	Undocumented 2	Ceratonia siliqua :: Carob 97	2500 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6010304.7702	2105067.63235	37.760695874438	-122.407450027813	(37.760695874438, -122.407450027813)
58491	58491	189959	Undocumented 2	Ceratonia siliqua :: Carob 97	562 09th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 3ft		6010397.618480001	2108539.03358	37.7702327485634	-122.40737363758998	(37.7702327485634, -122.40737363759)
117686	117686	47317	Permitted Site 1	Ceratonia siliqua :: Carob 97	2524 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/10/2002 12:00:00 AM			Permit Number 45245	6010338.92838604	2105074.55283943	37.7607167883884	-122.407332377331	(37.7607167883884, -122.407332377331)
85487	85487	115558	Undocumented 2	Ceratonia siliqua :: Carob 97	2500x 19TH ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6010357.0	2105131.0	37.7608727909959	-122.407273854716	(37.7608727909959, -122.407273854716)
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)
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)
82964	82964	13332	DPW Maintained 3	Ceratonia siliqua :: Carob 97	145 Mansell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6011384.17484	2090567.17856	37.7209410845847	-122.402697063866	(37.7209410845847, -122.402697063866)
161942	161942	188480	Undocumented 2	Ceratonia siliqua :: Carob 97	209 Arkansas St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 4ft		6012920.54855	2106035.89651	37.7635005775036	-122.398471110175	(37.7635005775036, -122.398471110175)
79194	79194	97180	Undocumented 2	Ceratonia siliqua :: Carob 97	10X Fremont St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	3x3		6013222.5	2116242.1	37.7915413037038	-122.398142826086	(37.7915413037038, -122.398142826086)
42568	42568	189927	Undocumented 2	Ceratonia siliqua :: Carob 97	43 Fremont St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 5ft		6013321.30985	2116211.3881900003	37.7914624793694	-122.39779878780001	(37.7914624793694, -122.3977987878)
96123	96123	119742	Undocumented 2	Ceratonia siliqua :: Carob 97	15X Fremont St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6013411.0	2116073.0	37.7910874921548	-122.39747874956998	(37.7910874921548, -122.39747874957)
175776	175776	85255	Permitted Site 1	Ceratonia siliqua :: Carob 97	45 Fremont St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6		Permit Number 49553	6013503.0525	2116024.16318	37.7909585226636	-122.39715682295	(37.7909585226636, -122.39715682295)
148488	148488	189918	Undocumented 2	Ceratonia siliqua :: Carob 97	338 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 5ft		6013810.73123	2116050.81938	37.7910488379738	-122.396094128247	(37.7910488379738, -122.396094128247)
98026	98026	15122	DPW Maintained 3	Ceratonia siliqua :: Carob 97	300 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			8	2X2		6013811.40838	2116056.32171	37.791063983762896	-122.396092171091	(37.7910639837629, -122.396092171091)

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