Street_Tree_List

Data source: data.sfgov.org

437 rows where qSiteInfo = 2 and qSpecies = 16 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, DBH, PlotSize

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
127835	127835	114387	Significant Tree 6	Prunus cerasifera :: Cherry Plum 16	417x ARBALLO DR	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			5988152.0	2090574.0	37.7196353223366	-122.483003277928	(37.7196353223366, -122.483003277928)
162710	162710	118025	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	455 37th Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5984366.92897	2112698.04941	37.7801608967117	-122.49771940229799	(37.7801608967117, -122.497719402298)
154522	154522	118420	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	5501 Anza St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5981593.2087199995	2111630.13422	37.7770657300516	-122.507235548964	(37.7770657300516, -122.507235548964)
161072	161072	119574	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	341 30th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5986512.996119999	2113510.70001	37.782517772266004	-122.490355077371	(37.782517772266, -122.490355077371)
131356	131356	120335	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	30 West Clay St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		5988814.20904	2115019.72522	37.7867952605979	-122.48250458154399	(37.7867952605979, -122.482504581544)
130710	130710	120411	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	695 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5988788.14465	2110619.93187	37.7747131475769	-122.48227228258301	(37.7747131475769, -122.482272282583)
63358	63358	120753	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2 20th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5989606.296159999	2114986.48675	37.78675004409779	-122.47976174378599	(37.7867500440978, -122.479761743786)
182103	182103	120755	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	25 20th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		5989558.707669999	2114980.4396	37.7867306756372	-122.479925944143	(37.7867306756372, -122.479925944143)
71627	71627	121889	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	10 17th Ave	0	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5990520.54715	2115002.72082	37.78684768786071	-122.47659987163799	(37.7868476878607, -122.476599871638)
55246	55246	121965	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	20 15th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			5991180.37033	2114963.80683	37.7867790889821	-122.474314218886	(37.7867790889821, -122.474314218886)
184803	184803	121966	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	26 15th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3			5991179.292640001	2114937.5267	37.7867068686376	-122.47431602898001	(37.7867068686376, -122.47431602898)
151376	151376	122064	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	5 17th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 5ft		5990491.562030001	2115003.9867599998	37.7868494825782	-122.476700244886	(37.7868494825782, -122.476700244886)
155673	155673	123046	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	568 Funston Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991931.70255	2111579.415	37.7775299779826	-122.471468109911	(37.7775299779826, -122.471468109911)
152681	152681	123169	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	633 10th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5992829.67841	2111161.4649900002	37.7764343073951	-122.468331325004	(37.7764343073951, -122.468331325004)
35879	35879	123334	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	733 04th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5994711.90932	2110573.33992	37.7749280066394	-122.46177754908301	(37.7749280066394, -122.461777549083)
43964	43964	123532	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	3 05th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5994221.03215	2115580.18797	37.7886471906725	-122.46383908202299	(37.7886471906725, -122.463839082023)
149532	149532	123932	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1 08th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5993304.79465	2114951.8615900003	37.7868691371328	-122.46696340370801	(37.7868691371328, -122.466963403708)
131128	131128	123933	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1 08th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			5993312.90228	2114946.82765	37.7868557832667	-122.466934987319	(37.7868557832667, -122.466934987319)
166198	166198	124014	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	104 Funston Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5991818.088169999	2114740.92009	37.786204028457604	-122.47209163415	(37.7862040284576, -122.47209163415)
132406	132406	124015	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	104 Funston Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5991819.02656	2114698.83579	37.7860885309356	-122.472085318982	(37.7860885309356, -122.472085318982)
49004	49004	124299	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	187 Jordan Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5996214.57241	2113056.07533	37.781831330658605	-122.45675914666501	(37.7818313306586, -122.456759146665)
65675	65675	124300	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	187 Jordan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5996217.69868	2113070.62367	37.7818714560424	-122.456749383788	(37.7818714560424, -122.456749383788)
36318	36318	124301	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	187 Jordan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5996218.11326	2113072.44391	37.7818764777425	-122.45674808122699	(37.7818764777425, -122.456748081227)
151448	151448	124375	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	47 Jordan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		5996174.19455	2114219.10461	37.785022380649295	-122.456982983471	(37.7850223806493, -122.456982983471)
163017	163017	124376	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	47 Jordan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		5996174.194730001	2114204.4263400002	37.784982078053005	-122.456981920781	(37.784982078053, -122.456981920781)
179547	179547	124386	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	7 Jordan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 4ft		5996164.23011	2114462.1144	37.785689048323604	-122.457035040859	(37.7856890483236, -122.457035040859)
76574	76574	124586	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	3991 Washington St	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		5995636.20396	2115462.0086	37.7884041514593	-122.458934269795	(37.7884041514593, -122.458934269795)
60070	60070	124587	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	3991 Washington St	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		5995618.65925	2115459.66963	37.7883967207528	-122.458994801868	(37.7883967207528, -122.458994801868)
62016	62016	124588	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	3991 Washington St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 6ft		5995581.59623	2115458.0775	37.788390218589	-122.459122917803	(37.788390218589, -122.459122917803)
60101	60101	135697	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	10 Walnut St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5998449.317000001	2116481.46771	37.7913646187353	-122.449274868335	(37.7913646187353, -122.449274868335)
172696	172696	135698	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	10 Walnut St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 4ft		5998453.121780001	2116461.2064400003	37.7913092042995	-122.449260243563	(37.7913092042995, -122.449260243563)
168486	168486	135749	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2552 Baker St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5999681.87601	2117658.6923	37.7946673906374	-122.44509492561501	(37.7946673906374, -122.445094925615)
183347	183347	135750	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2552 Baker St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		5999680.47825	2117673.08537	37.794706830417	-122.445100797276	(37.794706830417, -122.445100797276)
38964	38964	135751	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2555 Baker St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5999628.20983	2117689.38066	37.7947485895329	-122.445282824544	(37.7947485895329, -122.445282824544)
52911	52911	135752	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2555 Baker St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5999630.51606	2117664.2662	37.794679763523	-122.445273038144	(37.794679763523, -122.445273038144)
74736	74736	135753	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2551 Baker St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5999632.98032	2117646.75281	37.794631817056796	-122.44526325172501	(37.7946318170568, -122.445263251725)
54014	54014	135817	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1083 Lombard St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		6007203.659469999	2120166.57987	37.8019798636266	-122.419246489941	(37.8019798636266, -122.419246489941)
39787	39787	135818	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1071 Lombard St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		6007217.26018	2120160.1793299997	37.801963055314495	-122.419198970666	(37.8019630553145, -122.419198970666)
71521	71521	135838	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1177 Greenwich St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6007200.951230001	2119822.58623	37.801035191466205	-122.41923144609301	(37.8010351914662, -122.419231446093)
165955	165955	135839	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1177 Greenwich St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			6007217.01278	2119823.01799	37.8010372815012	-122.419175896763	(37.8010372815012, -122.419175896763)
136919	136919	135840	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1177 Greenwich St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6007238.199519999	2119824.8673400003	37.8010435524736	-122.419102712642	(37.8010435524736, -122.419102712642)
58342	58342	135841	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1177 Greenwich St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			6007250.45092	2119825.88461	37.801047035553005	-122.41906038964	(37.801047035553, -122.41906038964)
155473	155473	135842	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1177 Greenwich St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			6007263.48219	2119827.6474	37.801052609542396	-122.419015420851	(37.8010526095424, -122.419015420851)
69090	69090	135843	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1175 Greenwich St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 10ft		6007285.978759999	2119831.2458099998	37.8010637566478	-122.418937828239	(37.8010637566478, -122.418937828239)
63220	63220	135844	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1155 Greenwich St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 6ft		6007360.5897	2119841.38777	37.801095804879395	-122.418680361323	(37.8010958048794, -122.418680361323)
135672	135672	140783	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	68 JORDAN AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		5996232.7039	2114068.31	37.7846116986517	-122.45676965113998	(37.7846116986517, -122.45676965114)
158568	158568	140785	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	68 JORDAN AVE	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5996229.6581	2114087.2617	37.784663560073795	-122.456781559648	(37.7846635600738, -122.456781559648)
31633	31633	140803	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	90 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5996555.8967	2113946.8166	37.7842966621812	-122.455642734536	(37.7842966621812, -122.455642734536)
29110	29110	140804	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	90 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5996555.8967	2113971.183	37.784363565831704	-122.45564449638	(37.7843635658317, -122.45564449638)
172084	172084	140810	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	94 Commonwealth Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5996557.9272	2113885.2238	37.78412766126	-122.455631256243	(37.78412766126, -122.455631256243)
187306	187306	140811	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	92 Commonwealth Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5996557.5888	2113916.3587	37.784213129993795	-122.455634678211	(37.7842131299938, -122.455634678211)
44976	44976	140824	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	98 JORDAN AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5996239.98	2113878.2862	37.784090361774794	-122.456730730831	(37.7840903617748, -122.456730730831)
29767	29767	140858	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	101 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5996504.4566	2113783.0205	37.7838439696062	-122.455808853694	(37.7838439696062, -122.455808853694)
175963	175963	140859	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	101 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5996507.8408	2113753.2393	37.783762392571795	-122.45579499216998	(37.7837623925718, -122.45579499217)
46765	46765	140864	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	111 COMMONWEALTH AVE	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5996511.5635	2113696.0461	37.7836055688965	-122.455777977423	(37.7836055688965, -122.455777977423)
25231	25231	140921	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	150 COMMONWEALTH AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5996579.2478	2113360.6701	37.7826885995813	-122.455519569028	(37.7826885995813, -122.455519569028)
36354	36354	141245	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	26 JORDAN AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5996219.8439	2114337.017	37.7853487578742	-122.456833583241	(37.7853487578742, -122.456833583241)
170084	170084	141266	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	56 JORDAN AVE	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5996229.9965	2114143.7781	37.78481875844879	-122.45678447779699	(37.7848187584488, -122.456784477797)
66594	66594	178716	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	551 Lisbon St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 6ft		6001935.516559999	2090267.4815	37.719586109087295	-122.435336775094	(37.7195861090873, -122.435336775094)
134948	134948	178732	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	100 Morse St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 1ft		6000912.22914	2087974.06631	37.713230738679705	-122.43870965184601	(37.7132307386797, -122.438709651846)
149450	149450	178733	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	100 Morse St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 1ft		6000880.0864	2087963.6418299999	37.713200286736495	-122.438820001354	(37.7132002867365, -122.438820001354)
59060	59060	178841	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	856 Prague St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		6002067.276880001	2086921.00065	37.710404894347704	-122.434642162998	(37.7104048943477, -122.434642162998)
137051	137051	178842	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	856 Prague St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		6002039.2106099995	2086908.72872	37.7103696049432	-122.434738288839	(37.7103696049432, -122.434738288839)
158576	158576	181897	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2346 29th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5987356.2384	2099265.0635	37.7434523865632	-122.48639164593399	(37.7434523865632, -122.486391645934)
67394	67394	182513	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1573 34th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5985578.9968	2104511.5721	37.757754115031794	-122.492923184352	(37.7577541150318, -122.492923184352)
39106	39106	182579	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2458 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5989241.8181	2098602.0912	37.741741764812396	-122.479823358011	(37.7417417648124, -122.479823358011)
167016	167016	182588	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2481 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5988271.6694	2098431.5306	37.7412170409985	-122.483165270692	(37.7412170409985, -122.483165270692)
184402	184402	182590	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2485 26th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5988273.6999	2098412.9174	37.7411660521999	-122.48315688603998	(37.7411660521999, -122.48315688604)
152759	152759	182593	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2491 26th Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5988274.3768	2098375.691	37.7410638776679	-122.483151817617	(37.7410638776679, -122.483151817617)
50209	50209	182801	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1771 33rd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5985937.2360000005	2103186.122	37.7541357363912	-122.49158669787799	(37.7541357363912, -122.491586697878)
48434	48434	182802	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1771 33rd Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5985936.734	2103180.0986	37.7541191684466	-122.491587990539	(37.7541191684466, -122.491587990539)
186339	186339	183428	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2430 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5989548.6064	2098792.6969999997	37.742282937054	-122.478776534673	(37.742282937054, -122.478776534673)
71493	71493	183429	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2430 22nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5989548.1117	2098806.5483	37.7423209403934	-122.478779257985	(37.7423209403934, -122.478779257985)
46931	46931	183520	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2563 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 0ft		5987980.9372	2097853.3266	37.739612521668896	-122.484128114644	(37.7396125216689, -122.484128114644)
76118	76118	183529	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2590 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5988341.8215	2097699.5391	37.739211266220295	-122.482869079468	(37.7392112662203, -122.482869079468)
24610	24610	183977	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1693 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5985918.7806	2103713.7918	37.7555834944248	-122.49168936146002	(37.7555834944248, -122.49168936146)
159371	159371	184131	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1642 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5985330.3253	2104026.0743	37.7564065269094	-122.49374740508001	(37.7564065269094, -122.49374740508)
154941	154941	184141	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1647 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5985907.4128	2104010.0255	37.756396206392104	-122.49175048083599	(37.7563962063921, -122.491750480836)
86116	86116	185234	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2530 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5986160.02	2098006.6727	37.739927383563	-122.49043525338301	(37.739927383563, -122.490435253383)
186616	186616	196131	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1441 Rhode Island St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			6012036.935319999	2101652.28346	37.751414877192104	-122.40121920810499	(37.7514148771921, -122.401219208105)
49691	49691	196149	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	502 Missouri St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 8ft		6013503.97316	2104707.95515	37.759886826325705	-122.39636013421301	(37.7598868263257, -122.396360134213)
186895	186895	196150	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	502 Missouri St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 8ft		6013505.49575	2104693.9882799997	37.7598485610787	-122.396353889321	(37.7598485610787, -122.396353889321)
173598	173598	196263	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1059 Jamestown Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6			6013674.30393	2089830.73604	37.7190465590346	-122.394729166931	(37.7190465590346, -122.394729166931)
135040	135040	196264	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1121 Jamestown Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			6013209.07716	2090182.42282	37.7199863433675	-122.39636192385599	(37.7199863433675, -122.396361923856)
174870	174870	196265	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1121 Jamestown Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			6013225.87785	2090169.90622	37.7199529101853	-122.39630297241999	(37.7199529101853, -122.39630297242)
132021	132021	196266	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1121 Jamestown Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			6013242.639359999	2090155.46784	37.71991419797	-122.39624402185	(37.71991419797, -122.39624402185)
32935	32935	196267	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1121 Jamestown Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6013259.78096	2090144.7382099999	37.719885690359604	-122.396184017281	(37.7198856903596, -122.396184017281)
175920	175920	196268	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1121 Jamestown Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			6013281.01333	2090127.7740900002	37.719840291665896	-122.396109435604	(37.7198402916659, -122.396109435604)
47186	47186	200490	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1088 Jamestown Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		6013545.6611	2089994.9439	37.7194902878281	-122.39518533478001	(37.7194902878281, -122.39518533478)
56624	56624	200791	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1582 McKinnon Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		6015463.9227	2095899.7229	37.735810128216706	-122.388966588384	(37.7358101282167, -122.388966588384)
183824	183824	201243	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	105 Orsi Cir	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6012828.52235	2093195.2061299998	37.7282376510311	-122.39788860758001	(37.7282376510311, -122.39788860758)
174449	174449	201244	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	105 Orsi Cir	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6012833.80846	2093200.62135	37.728252814508295	-122.397870712864	(37.7282528145083, -122.397870712864)
53209	53209	201245	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	105 Orsi Cir	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6012837.41647	2093205.33465	37.7282659571993	-122.397858570225	(37.7282659571993, -122.397858570225)
130306	130306	201246	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		6012841.59753	2093210.9566799998	37.7282816269891	-122.397844510228	(37.7282816269891, -122.397844510228)
184790	184790	201247	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6012845.77859	2093216.5787099998	37.7282972967771	-122.39783045022399	(37.7282972967771, -122.397830450224)
156973	156973	201248	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6012850.340340001	2093222.7449	37.728314481915795	-122.39781511229799	(37.7283144819158, -122.397815112298)
72388	72388	201250	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6012872.658430001	2093256.71698	37.7284090051552	-122.397740339042	(37.7284090051552, -122.397740339042)
46406	46406	201251	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 2ft		6012888.0536400005	2093268.37063	37.72844186100129	-122.397687933748	(37.7284418610013, -122.397687933748)
179203	179203	201252	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6012895.76259	2093265.63698	37.7284347842355	-122.39766109168801	(37.7284347842355, -122.397661091688)
60718	60718	201254	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		6012906.67074	2093256.5794099998	37.7284105214187	-122.397622746406	(37.7284105214187, -122.397622746406)

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