Street_Tree_List

Data source: data.sfgov.org

630 rows where qSiteInfo = 2 and qSpecies = 54 sorted by XCoord

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: SiteOrder, DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord ▼	YCoord	Latitude	Longitude	Location
167206	167206	184171	Undocumented 2	:: 54	4230 Lawton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981117.7231	2104203.7543	37.7566470308009	-122.50832898893499	(37.7566470308009, -122.508328988935)
26507	26507	184509	Undocumented 2	:: 54	1886 Lower Great Hwy	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981125.5546	2102268.3878	37.751333525850896	-122.50815826243401	(37.7513335258509, -122.508158262434)
49859	49859	184504	Undocumented 2	:: 54	1878 Lower Great Hwy	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981125.892999999	2102290.0468	37.751393015279	-122.50815869964501	(37.751393015279, -122.508158699645)
179798	179798	184537	Undocumented 2	:: 54	1920 Lower Great Hwy	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981149.921	2101972.2688	37.750521902570604	-122.50805202692601	(37.7505219025706, -122.508052026926)
185376	185376	184529	Undocumented 2	:: 54	1996 Lower Great Hwy	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981188.5011	2101512.3535	37.7492613780766	-122.50788448891899	(37.7492613780766, -122.507884488919)
171774	171774	184177	Undocumented 2	:: 54	1605 48th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981248.1823	2104131.4737	37.7564562562261	-122.507872457928	(37.7564562562261, -122.507872457928)
24275	24275	184454	Undocumented 2	:: 54	2153 48th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981374.6331	2100381.1786	37.7461664541179	-122.507156946857	(37.7461664541179, -122.507156946857)
173511	173511	184452	Undocumented 2	:: 54	2142 48th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981413.7208	2100483.5512	37.746449842726896	-122.507029381635	(37.7464498427269, -122.507029381635)
131217	131217	184172	Undocumented 2	:: 54	4145 Lawton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981416.401000001	2104160.656	37.7565462922692	-122.507292873512	(37.7565462922692, -122.507292873512)
164146	164146	184474	Undocumented 2	:: 54	2186 48th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981423.3658	2100215.0135	37.745713081334	-122.506976114504	(37.745713081334, -122.506976114504)
55807	55807	184469	Undocumented 2	:: 54	2182 48th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981423.7042	2100234.3036	37.74576606648579	-122.506976375045	(37.7457660664858, -122.506976375045)
137303	137303	184371	Undocumented 2	:: 54	2282 48th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981448.1763	2099546.5215	37.7438790499345	-122.506840749339	(37.7438790499345, -122.506840749339)
116050	116050	111759	Permitted Site 1	:: 54	1235 47th Ave	2	Sidewalk: Curb side : Yard 2	Landscaping 2	Private 1		06/23/2015 12:00:00 AM	3	6x4		5981472.7	2106671.7	37.7634442160317	-122.50728446314301	(37.7634442160317, -122.507284463143)
135799	135799	183114	Undocumented 2	:: 54	3650 Santiago St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981483.4357	2099456.1026	37.7436328611158	-122.506712127755	(37.7436328611158, -122.506712127755)
95413	95413	118419	Undocumented 2	:: 54	5507 Anza St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 3ft		5981562.4785	2111629.449	37.7770620385939	-122.507341801673	(37.7770620385939, -122.507341801673)
73677	73677	184188	Undocumented 2	:: 54	1659 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981571.3272	2103786.0218	37.7555267773851	-122.506729307239	(37.7555267773851, -122.506729307239)
54992	54992	184123	Undocumented 2	:: 54	1566 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981590.4236	2104415.5069999998	37.7572562892484	-122.50670995310101	(37.7572562892484, -122.506709953101)
36998	36998	184372	Undocumented 2	:: 54	2263 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981709.435	2099687.8805	37.7442825640676	-122.50594787141	(37.7442825640676, -122.50594787141)
168574	168574	184154	Undocumented 2	:: 54	4036 Lawton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981710.2029	2104227.1296	37.756746110874296	-122.506281748334	(37.7567461108743, -122.506281748334)
36154	36154	184467	Undocumented 2	:: 54	2182 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981733.5294	2100249.3634	37.7458256579494	-122.50590617914699	(37.7458256579494, -122.505906179147)
149169	149169	184505	Undocumented 2	:: 54	3940 Ortega St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981746.2202	2102187.1666	37.751147069673706	-122.506005945548	(37.7511470696737, -122.506005945548)
158169	158169	183195	Undocumented 2	:: 54	2467 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981757.2189	2098306.9914	37.740493837912396	-122.505680301686	(37.7404938379124, -122.505680301686)
178952	178952	183207	Undocumented 2	:: 54	2487 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981762.9721	2098176.699	37.7401364295663	-122.505650753582	(37.7401364295663, -122.505650753582)
147904	147904	183186	Undocumented 2	:: 54	2446 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981797.1527	2098421.378	37.740810262110294	-122.505550705456	(37.7408102621103, -122.505550705456)
181678	181678	182929	Undocumented 2	:: 54	2635 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981797.6603	2097141.2975	37.737295543609996	-122.50545409100799	(37.73729554361, -122.505454091008)
137654	137654	182938	Undocumented 2	:: 54	2657 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981803.7519	2096965.6566	37.7368136403966	-122.505420015001	(37.7368136403966, -122.505420015001)
35754	35754	182933	Undocumented 2	:: 54	2646 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981845.0394	2097064.8142	37.7370883295038	-122.505284615423	(37.7370883295038, -122.505284615423)
180164	180164	183139	Undocumented 2	:: 54	3539 Santiago St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981846.5394	2099413.7013	37.7435378134359	-122.505453483048	(37.7435378134359, -122.505453483048)
147162	147162	182943	Undocumented 2	:: 54	2674 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981850.1157	2096894.2496	37.7366203046104	-122.505254426993	(37.7366203046104, -122.505254426993)
154543	154543	182944	Undocumented 2	:: 54	2678 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981851.131	2096866.8374	37.7365450979685	-122.50524888568701	(37.7365450979685, -122.505248885687)
187265	187265	183138	Undocumented 2	:: 54	3521 Santiago St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981925.3562	2099416.4074	37.7435498815044	-122.50518115930201	(37.7435498815044, -122.505181159302)
131228	131228	184727	Undocumented 2	:: 54	3941 Lawton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981943.3641	2104178.2266	37.756625560975706	-122.505471780608	(37.7566255609757, -122.505471780608)
123820	123820	184470	Undocumented 2	:: 54	2159 46th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981994.4526	2100401.9916	37.7462600872151	-122.50501526782601	(37.7462600872151, -122.505015267826)
151546	151546	182946	Undocumented 2	:: 54	3500 Wawona St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982068.7362	2096751.2664	37.7362405734928	-122.504487984804	(37.7362405734928, -122.504487984804)
49826	49826	183146	Undocumented 2	:: 54	2314 46th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982075.842999999	2099327.1639	37.743313697016895	-122.504654211145	(37.7433136970169, -122.504654211145)
153241	153241	183271	Undocumented 2	:: 54	1242 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982138.4385	2106630.5909	37.7633705325139	-122.504978880674	(37.7633705325139, -122.504978880674)
163149	163149	184728	Undocumented 2	:: 54	1622 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982226.4788	2104040.1069	37.7562629800448	-122.504482451968	(37.7562629800448, -122.504482451968)
187448	187448	184439	Undocumented 2	:: 54	2131 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982299.7091	2100588.462	37.7467900380649	-122.503973554813	(37.7467900380649, -122.503973554813)
39023	39023	184457	Undocumented 2	:: 54	2151 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982303.7701	2100458.8464	37.746434388466	-122.503949913871	(37.746434388466, -122.503949913871)
134863	134863	184462	Undocumented 2	:: 54	2155 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982305.1238	2100432.4495	37.7463619895169	-122.50394327821199	(37.7463619895169, -122.503943278212)
170209	170209	184473	Undocumented 2	:: 54	2191 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982313.2459	2100207.399	37.7457445409505	-122.503898527906	(37.7457445409505, -122.503898527906)
52297	52297	184468	Undocumented 2	:: 54	2186 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982356.9023	2100241.9181	37.7458418878069	-122.50375012897499	(37.7458418878069, -122.503750128975)
23417	23417	183167	Undocumented 2	:: 54	2422 45th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982411.0498	2098597.3573	37.741329561902596	-122.50344114283101	(37.7413295619026, -122.503441142831)
137163	137163	184290	Undocumented 2	:: 54	1535 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982472.3445	2104651.9336	37.757957341688396	-122.503677486302	(37.7579573416884, -122.503677486302)
170384	170384	184150	Undocumented 2	:: 54	1585 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982480.9001	2104357.3743	37.75714906821929	-122.503626084685	(37.7571490682193, -122.503626084685)
36620	36620	184152	Undocumented 2	:: 54	1585 44th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982483.9557	2104316.7349	37.7570376635662	-122.503612507973	(37.7570376635662, -122.503612507973)
172398	172398	184642	Undocumented 2	:: 54	1650 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982542.5956	2103869.9019	37.7558142337398	-122.50337662716001	(37.7558142337398, -122.50337662716)
174225	174225	184482	Undocumented 2	:: 54	2019 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982585.5063	2101354.8182	37.748911041069796	-122.503042038753	(37.7489110410698, -122.503042038753)
64935	64935	184387	Undocumented 2	:: 54	2027 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982586.1831	2101310.4849	37.7487893539542	-122.503036416733	(37.7487893539542, -122.503036416733)
161086	161086	184460	Undocumented 2	:: 54	2179 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982619.5177	2100295.7271	37.7460050700863	-122.502846039592	(37.7460050700863, -122.502846039592)
36129	36129	184472	Undocumented 2	:: 54	2191 44th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982622.5635	2100219.2438	37.7457952471339	-122.50282984708001	(37.7457952471339, -122.50282984708)
164529	164529	183341	Undocumented 2	:: 54	4211 Lincoln Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982665.5566	2106923.9454	37.7642069983045	-122.50317750172199	(37.7642069983045, -122.503177501722)
160327	160327	183333	Undocumented 2	:: 54	1211 43rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982706.5384	2106850.7636	37.764008470840295	-122.503030341532	(37.7640084708403, -122.503030341532)
53752	53752	183103	Undocumented 2	:: 54	3244 Santiago St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982756.3936	2099499.1864	37.7438260327489	-122.502313810049	(37.7438260327489, -122.502313810049)
42457	42457	184588	Undocumented 2	:: 54	1723 43rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982824.9397	2103383.4877	37.7544952710451	-122.502364209058	(37.7544952710451, -122.502364209058)
34873	34873	184590	Undocumented 2	:: 54	1727 43rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982826.6318	2103356.0755	37.7544201042603	-122.502356328834	(37.7544201042603, -122.502356328834)
39779	39779	183215	Undocumented 2	:: 54	3318 Rivera St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982838.8142	2100183.1408	37.7457088250993	-122.50207942434601	(37.7457088250993, -122.502079424346)
48108	48108	184440	Undocumented 2	:: 54	2123 43rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982918.0057	2100651.7469	37.7470001399255	-122.50184026169599	(37.7470001399255, -122.501840261696)
114902	114902	183304	Undocumented 2	:: 54	1263 42nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983031.5884	2106472.5871	37.762989205720295	-122.5018781248	(37.7629892057203, -122.5018781248)
187636	187636	183293	Undocumented 2	:: 54	1286 42nd Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983075.6533	2106421.6609	37.76285196523921	-122.50172195396401	(37.7628519652392, -122.501721953964)
187627	187627	184329	Undocumented 2	:: 54	1571 42nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983101.4912	2104441.3261	37.757416043664996	-122.501486086821	(37.757416043665, -122.501486086821)
178183	178183	184327	Undocumented 2	:: 54	1566 42nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983143.5077	2104481.5092	37.7575288427339	-122.50134375171899	(37.7575288427339, -122.501343751719)
34425	34425	184635	Undocumented 2	:: 54	1646 42nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983160.6342	2103926.3557	37.7560055530367	-122.50124346024299	(37.7560055530367, -122.501243460243)
58153	58153	184163	Undocumented 2	:: 54	3544 Lawton St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983184.3019	2104274.4825	37.756962801278206	-122.501187358865	(37.7569628012782, -122.501187358865)
40717	40717	184162	Undocumented 2	:: 54	3542 Lawton St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983197.136	2104275.0936	37.7569652328272	-122.501143019632	(37.7569652328272, -122.501143019632)
33271	33271	184161	Undocumented 2	:: 54	3540 Lawton St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983209.359	2104274.4825	37.7569642726582	-122.501100703383	(37.7569642726582, -122.501100703383)
182702	182702	184160	Undocumented 2	:: 54	3538 Lawton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983222.1931	2104276.0104	37.75696922144979	-122.50105643194999	(37.7569692214498, -122.50105643195)
165614	165614	184687	Undocumented 2	:: 54	3525 Lawton St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983292.0496	2104225.2416	37.756833926206	-122.50081109145799	(37.756833926206, -122.500811091458)
60397	60397	184231	Undocumented 2	:: 54	1523 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983398.5095	2104764.9295	37.758322007374204	-122.500482822231	(37.7583220073742, -122.500482822231)
168394	168394	184302	Undocumented 2	:: 54	1555 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983405.8433	2104564.4726	37.7577720395933	-122.50044263805	(37.7577720395933, -122.50044263805)
74645	74645	184293	Undocumented 2	:: 54	1547 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983406.1489	2104611.5311	37.757901266946504	-122.500445060495	(37.7579012669465, -122.500445060495)
39214	39214	184146	Undocumented 2	:: 54	1583 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983412.2604	2104390.9064	37.757295852249	-122.500407612857	(37.757295852249, -122.500407612857)
180018	180018	184711	Undocumented 2	:: 54	1619 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983422.7912	2104108.9895	37.756522405688294	-122.500350351105	(37.7565224056883, -122.500350351105)
178140	178140	184288	Undocumented 2	:: 54	1514 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983440.9844	2104806.182	37.7584377683924	-122.500338977609	(37.7584377683924, -122.500338977609)
163297	163297	184262	Undocumented 2	:: 54	1526 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983444.9569	2104728.5661	37.7582248901335	-122.50031950085199	(37.7582248901335, -122.500319500852)
147093	147093	184276	Undocumented 2	:: 54	1534 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983446.4847	2104680.2853	37.7580924143073	-122.500310647666	(37.7580924143073, -122.500310647666)
127201	127201	184591	Undocumented 2	:: 54	1751 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983451.02	2103228.4905	37.754106458672794	-122.500187636281	(37.7541064586728, -122.500187636281)
150325	150325	184602	Undocumented 2	:: 54	1763 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983454.4042	2103150.315	37.7538920091964	-122.500170154172	(37.7538920091964, -122.500170154172)
157623	157623	184139	Undocumented 2	:: 54	1582 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983456.1103	2104379.7529	37.757267801737	-122.500255140579	(37.757267801737, -122.500255140579)
153222	153222	184710	Undocumented 2	:: 54	1622 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983465.9224	2104108.6525	37.7565240119929	-122.50020116553301	(37.7565240119929, -122.500201165533)
46818	46818	184716	Undocumented 2	:: 54	1626 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983467.6072	2104060.8038	37.7563927317594	-122.500191801751	(37.7563927317594, -122.500191801751)
130835	130835	184724	Undocumented 2	:: 54	1638 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983469.292	2103986.335	37.756188360185	-122.50018047011801	(37.756188360185, -122.500180470118)
29939	29939	184629	Undocumented 2	:: 54	1646 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983471.6508	2103927.0296	37.7560256626113	-122.500167928609	(37.7560256626113, -122.500167928609)
59566	59566	184641	Undocumented 2	:: 54	1654 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983473.6725	2103876.1482	37.7558860751921	-122.500157175669	(37.7558860751921, -122.500157175669)
165021	165021	184664	Undocumented 2	:: 54	1666 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983476.0313	2103802.0164	37.7556826684626	-122.50014353825199	(37.7556826684626, -122.500143538252)
156926	156926	184568	Undocumented 2	:: 54	1710 41st Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983487.5696	2103476.8921	37.7547906452428	-122.50007960245199	(37.7547906452428, -122.500079602452)
65019	65019	184544	Undocumented 2	:: 54	3425 Moraga St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983632.4928	2103556.7404	37.755018390843894	-122.499584326949	(37.7550183908439, -122.499584326949)
179131	179131	184543	Undocumented 2	:: 54	3419 Moraga St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983659.9786	2103558.2129	37.7550240466182	-122.499489383511	(37.7550240466182, -122.499489383511)
59703	59703	184637	Undocumented 2	:: 54	1651 40th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983740.0416	2103911.0239	37.7559974642917	-122.49923857586201	(37.7559974642917, -122.499238575862)
26576	26576	184709	Undocumented 2	:: 54	1618 40th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983775.4227	2104111.6852	37.7565504997112	-122.499131044219	(37.7565504997112, -122.499131044219)
31225	31225	184643	Undocumented 2	:: 54	3324 Moraga St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5983935.3115	2103621.2359	37.7552132408568	-122.49854187345801	(37.7552132408568, -122.498541873458)
28244	28244	184686	Undocumented 2	:: 54	1606 39th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984083.9121	2104208.225	37.7568336628482	-122.498071323375	(37.7568336628482, -122.498071323375)
174451	174451	184706	Undocumented 2	:: 54	1614 39th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984085.5969	2104145.8869	37.7566625986032	-122.49806089331999	(37.7566625986032, -122.49806089332)
31766	31766	184717	Undocumented 2	:: 54	1630 39th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984088.6295	2104052.5482	37.756406494372705	-122.498043512944	(37.7564064943727, -122.498043512944)
49703	49703	184647	Undocumented 2	:: 54	1690 39th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984101.4341	2103682.9001	37.75539229440621	-122.497971934799	(37.7553922944062, -122.497971934799)
64618	64618	184699	Undocumented 2	:: 54	1611 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984351.7975	2104194.0726	37.7568105070294	-122.497143845948	(37.7568105070294, -122.497143845948)
41261	41261	184673	Undocumented 2	:: 54	1683 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984368.1401	2103732.6021	37.755544395128105	-122.49705326703999	(37.7555443951281, -122.49705326704)
75802	75802	184644	Undocumented 2	:: 54	1687 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984368.4771	2103700.5906	37.7554565201918	-122.497049738891	(37.7554565201918, -122.497049738891)
185311	185311	184600	Undocumented 2	:: 54	1767 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984384.3874	2103165.544	37.7539883630109	-122.496955228039	(37.7539883630109, -122.496955228039)
172754	172754	184732	Undocumented 2	:: 54	1574 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984385.8307	2104461.7895	37.757547577458	-122.49704590841299	(37.757547577458, -122.497045908413)

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