Street_Tree_List

Data source: data.sfgov.org

195 rows where qSpecies = 72 sorted by SiteOrder descending

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

- 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, PlantDate, DBH, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
187588	187588	196333	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	801 Arkansas St	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6013061.90076	2103711.9152599997	37.757127308803604	-122.397819189808	(37.7571273088036, -122.397819189808)
138178	138178	214355	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	811 Congo St	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			7			6000531.25655	2095885.67636	37.734932531704004	-122.440593534571	(37.734932531704, -122.440593534571)
169509	169509	196332	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	801 Arkansas St	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			6013061.70024	2103702.02862	37.7571001510787	-122.39781918981001	(37.7571001510787, -122.39781918981)
46953	46953	214356	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	811 Congo St	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6000533.92821	2095885.0481	37.7349309587854	-122.44058425268	(37.7349309587854, -122.44058425268)
164953	164953	196331	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	801 Arkansas St	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			6013062.01072	2103694.01523	37.757078165347096	-122.397817553962	(37.7570781653471, -122.397817553962)
175815	175815	237928	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	310 Liberty St	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		6004144.43295	2103938.76991	37.75724955362679	-122.428675392374	(37.7572495536268, -122.428675392374)
137327	137327	214332	DPW Maintained 3	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100x Idora Ave	18	Median : Yard 3	Tree 1	DPW 2			9	Width 9ft		5995718.21124	2099321.8453599997	37.7440921546362	-122.457482343055	(37.7440921546362, -122.457482343055)
62511	62511	202088	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1 Gould St	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6012849.75876	2091137.38485	37.722588475066	-122.397670917693	(37.722588475066, -122.397670917693)
174532	174532	214331	DPW Maintained 3	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100x Idora Ave	13	Median : Yard 3	Tree 1	DPW 2			2	Width 9ft		5995540.56521	2099364.9270200003	37.7442002405496	-122.458099716827	(37.7442002405496, -122.458099716827)
38489	38489	214330	DPW Maintained 3	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100x Idora Ave	12	Median : Yard 3	Tree 1	DPW 2			10	Width 9ft		5995527.4625	2099368.48178	37.7442092481691	-122.458145280077	(37.7442092481691, -122.458145280077)
71736	71736	214350	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100 Vista Verde Ct	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		5999173.543740001	2096088.2498400002	37.735411342443	-122.445302168061	(37.735411342443, -122.445302168061)
51364	51364	214329	DPW Maintained 3	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100x Idora Ave	11	Median : Yard 3	Tree 1	DPW 2			11	Width 9ft		5995487.46893	2099377.84768	37.744232666505106	-122.45828424602301	(37.7442326665051, -122.458284246023)
69505	69505	196330	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	582 Rhode Island St	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			6011759.958869999	2105639.7656	37.7623481673595	-122.40245738661801	(37.7623481673595, -122.402457386618)
181167	181167	214351	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100 Vista Verde Ct	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 3ft		5999187.72445	2096110.16457	37.735472324573706	-122.445254715344	(37.7354723245737, -122.445254715344)
57881	57881	214317	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	20 Belmont Ave	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			21			5996726.67758	2106195.56131	37.763023532129004	-122.454491761784	(37.763023532129, -122.454491761784)
154466	154466	214328	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100 Vista Verde Ct	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 10ft		5999189.95231	2096066.10598	37.735351477276296	-122.44524384613001	(37.7353514772763, -122.44524384613)
66220	66220	196329	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	582 Rhode Island St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6011758.91837	2105646.20338	37.7623657859795	-122.402461438042	(37.7623657859795, -122.402461438042)
130582	130582	214327	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	100 Vista Verde Ct	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 10ft		5999204.10164	2096073.9362400002	37.7353737849692	-122.44519548960501	(37.7353737849692, -122.445195489605)
42697	42697	214340	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	10 Granada Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5995647.3178900005	2089997.48145	37.7184856365862	-122.457053144299	(37.7184856365862, -122.457053144299)
155852	155852	237881	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	400 Prospect Ave	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2			6006228.09651	2097633.90585	37.7400555395259	-122.42102161048	(37.7400555395259, -122.42102161048)
180365	180365	196328	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	582 Rhode Island St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6011759.42256	2105649.40128	37.7623745948457	-122.402459919101	(37.7623745948457, -122.402459919101)
67614	67614	214345	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	498 Vernon St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 10ft		5992504.20594	2091177.71285	37.7215452614802	-122.46800328954599	(37.7215452614802, -122.468003289546)
71993	71993	237925	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	37 Seward St	7	Front Yard : Yard 7	Tree 1	Private 1			14	Width 3ft		6000968.93807	2104244.5163	37.7579088304528	-122.439679384512	(37.7579088304528, -122.439679384512)
125300	125300	196327	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	582 Rhode Island St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3			6011756.69483	2105652.08155	37.7623818019909	-122.402469541836	(37.7623818019909, -122.402469541836)
174607	174607	237938	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	272 Corbett Ave	7	Side Yard : Yard 17	Tree 1	Private 1			4	Width 3ft		5999643.14509	2105335.6231299997	37.7608291899369	-122.44434292871	(37.7608291899369, -122.44434292871)
184895	184895	237880	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	400 Prospect Ave	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6006230.938630001	2097643.52174	37.7400821028175	-122.42101246614901	(37.7400821028175, -122.421012466149)
23870	23870	214333	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	312 Hearst Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 10ft		5999316.02125	2094400.93218	37.7307864969836	-122.44468833131901	(37.7307864969836, -122.444688331319)
56881	56881	237937	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	272 Corbett Ave	6	Side Yard : Yard 17	Tree 1	Private 1			4	Width 3ft		5999630.47363	2105335.88644	37.7608291899486	-122.44438677244301	(37.7608291899486, -122.444386772443)
169138	169138	139121	Permitted Site 1	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1501 LAGUNA ST	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		6004511.3378	2114128.6273	37.785249186429	-122.428132654809	(37.785249186429, -122.428132654809)
178991	178991	237875	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	200 Kingston St	6	Front Yard : Yard 7	Tree 1	Private 1			3			6006243.1676199995	2098035.54696	37.7411592055212	-122.420998010444	(37.7411592055212, -122.420998010444)
186159	186159	196326	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	582 Rhode Island St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5			6011758.077269999	2105655.2615900002	37.7623906108466	-122.40246498408001	(37.7623906108466, -122.40246498408)
24177	24177	237873	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1200 San Jose Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			11	Width 4ft		6004198.3369	2096122.91618	37.7357920776323	-122.427932046027	(37.7357920776323, -122.427932046027)
32082	32082	214339	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	10 Granada Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995645.61653	2089973.7563200002	37.7184203952771	-122.45705730996401	(37.7184203952771, -122.457057309964)
46954	46954	237909	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	3911 21st St	5	Side Yard : Yard 17	Tree 1	Private 1			17			6002350.80679	2103530.36749	37.7560265053261	-122.43484923730499	(37.7560265053261, -122.434849237305)
60249	60249	196325	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	582 Rhode Island St	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6011758.16915	2105659.78061	37.7624030241958	-122.402464984075	(37.7624030241958, -122.402464984075)
60540	60540	135872	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2550 Pierce St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6001695.18556	2117280.97246	37.7937449767048	-122.43810155185601	(37.7937449767048, -122.438101551856)
66579	66579	237936	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	272 Corbett Ave	5	Side Yard : Yard 17	Tree 1	Private 1			4	Width 3ft		5999637.58135	2105322.06296	37.7607916396321	-122.444361196632	(37.7607916396321, -122.444361196632)
71198	71198	214353	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	50 Garcia Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 3ft		5995149.72336	2099349.67966	37.74413591023829	-122.45945004977399	(37.7441359102383, -122.459450049774)
165180	165180	214347	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	649 Parnassus Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		5995088.00725	2106121.15655	37.762725118180704	-122.460153932955	(37.7627251181807, -122.460153932955)
166052	166052	135874	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	941 Vallejo St	5	Front Yard : Yard 7	Tree 1	Private 1			14			6008901.53322	2118681.17119	37.7979967743805	-122.413265921012	(37.7979967743805, -122.413265921012)
186984	186984	113952	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1416 Powell St	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	3x3		6009764.02998	2118627.67395	37.7978982689348	-122.410277642896	(37.7978982689348, -122.410277642896)
25440	25440	237908	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	3911 21st St	4	Side Yard : Yard 17	Tree 1	Private 1			18			6002345.78312	2103531.79558	37.7560301412935	-122.43486671293002	(37.7560301412935, -122.43486671293)
28893	28893	237879	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	400 Prospect Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			10			6006275.052019999	2097644.49058	37.74008724961789	-122.420860008587	(37.7400872496179, -122.420860008587)
37563	37563	178857	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	701 Delta St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			12	Width 3ft		6009291.72599	2087274.3379400002	37.711782574777004	-122.409697761866	(37.711782574777, -122.409697761866)
55556	55556	214319	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	109 Edgewood Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		5996574.94596	2106340.51258	37.7634128279669	-122.455027021201	(37.7634128279669, -122.455027021201)
59899	59899	237911	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	414 Collingwood St	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			6002101.71196	2103425.3535700003	37.7557240165608	-122.435703175975	(37.7557240165608, -122.435703175975)
67839	67839	135863	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	8 Kimball Pl	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 4ft		6007998.64807	2116497.60836	37.7919505198577	-122.416235439221	(37.7919505198577, -122.416235439221)
130531	130531	237915	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1295 Stanyan St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			11	Width 4ft		5997519.793	2104903.6211900003	37.7595216458395	-122.451655461936	(37.7595216458395, -122.451655461936)
137397	137397	214320	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1518 05th Ave	4	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			4			5994627.9467	2105254.67875	37.7603195216609	-122.46168228042801	(37.7603195216609, -122.461682280428)
166087	166087	237935	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	272 Corbett Ave	4	Side Yard : Yard 17	Tree 1	Private 1			6	Width 3ft		5999636.03267	2105332.26436	37.7608195617885	-122.444367285948	(37.7608195617885, -122.444367285948)
171158	171158	135864	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2451 Steiner St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 4ft		6002234.27154	2116544.43758	37.791753285928294	-122.43618353624201	(37.7917532859283, -122.436183536242)
182972	182972	135871	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2550 Pierce St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		6001702.83254	2117214.86813	37.7935639062924	-122.43807035526001	(37.7935639062924, -122.43807035526)
186227	186227	214352	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	50 Garcia Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5995162.00455	2099364.3275	37.744176835692	-122.459408645009	(37.744176835692, -122.459408645009)
8282	8282	27415	DPW Maintained 3	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2300 Van Ness Ave	3	Median : Cutout 11	Tree 1	DPW 2			12	9		6005889.8891	2118381.22689	37.7970036620469	-122.423665750374	(37.7970036620469, -122.423665750374)
26673	26673	237878	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	400 Prospect Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			6006265.8389800005	2097650.58343	37.7401034599156	-122.420892296036	(37.7401034599156, -122.420892296036)
37992	37992	87842	Permitted Site 1	Prunus domestica 'Mariposa' :: Mariposa Plum 72	150 Golden Gate Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/06/2008 12:00:00 AM	5	3x3	Permit Number 50723	6008797.68605	2112863.51271	37.7820170689709	-122.41321365958099	(37.7820170689709, -122.413213659581)
39041	39041	214326	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	121 Miraloma Dr	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 2ft		5994581.43196	2096914.1717599998	37.7374159195969	-122.461238551316	(37.7374159195969, -122.461238551316)
47303	47303	237934	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	101 Lower Ter	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		6000443.264219999	2106174.87839	37.76317919578	-122.441635909067	(37.76317919578, -122.441635909067)
53560	53560	135870	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2550 Pierce St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6001706.98139	2117190.01379	37.7934958986807	-122.438054218747	(37.7934958986807, -122.438054218747)
62151	62151	214338	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	10 Granada Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995645.44763	2089954.0994900002	37.7183664125644	-122.4570564727	(37.7183664125644, -122.4570564727)
64453	64453	214316	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1898 08th Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 3ft		5993790.06824	2102612.96107	37.7530177802481	-122.464388282898	(37.7530177802481, -122.464388282898)
138151	138151	237906	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	3937 21st St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			22	Width 3ft		6002245.415080001	2103514.00804	37.755975601915104	-122.43521254633	(37.7559756019151, -122.43521254633)
147966	147966	183564	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2595 30th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5987057.6296	2097628.3948	37.738941118307295	-122.487303955513	(37.7389411183073, -122.487303955513)
153128	153128	200001	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1450 Griffith St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6017674.9346	2092354.0887	37.7261968206849	-122.381075736801	(37.7261968206849, -122.381075736801)
162501	162501	237907	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	3911 21st St	3	Side Yard : Yard 17	Tree 1	Private 1			12			6002340.71018	2103530.84091	37.75602723197329	-122.43488418855301	(37.7560272319733, -122.434884188553)
179437	179437	237912	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	3974 22nd St	3	: 4	Tree 1	Private 1			20			6002002.928859999	2102961.58207	37.7544449998516	-122.436011614667	(37.7544449998516, -122.436011614667)
285	285	98003	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1904 Filbert St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	4x12		6003782.57859	2119037.12075	37.7986853996597	-122.431004385541	(37.7986853996597, -122.431004385541)
6012	6012	27414	DPW Maintained 3	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2300 Van Ness Ave	2	Median : Cutout 11	Tree 1	DPW 2			12	9		6005892.4011	2118361.12861	37.7969486190501	-122.42365562852801	(37.7969486190501, -122.423655628528)
16525	16525	18547	Landmark tree 9	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1700X Quesada Ave	2	Median : Cutout 11	Tree 1	DPW 2			30	19		6014668.27449	2095058.7142299998	37.733456755021	-122.391658696189	(37.733456755021, -122.391658696189)
28361	28361	214344	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	498 Vernon St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 10ft		5992505.71978	2091140.82125	37.7214440535804	-122.467995374584	(37.7214440535804, -122.467995374584)
29047	29047	214358	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	550 Joost Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4			5998446.87478	2095010.46619	37.7324104972266	-122.447736959314	(37.7324104972266, -122.447736959314)
29426	29426	117740	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	475 39th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5983746.49746	2112674.00016	37.7800584750229	-122.499863945897	(37.7800584750229, -122.499863945897)
30466	30466	214357	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	61 Stillings Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13	Width 6ft		6000162.633219999	2095683.1648400002	37.7343554844182	-122.441853461362	(37.7343554844182, -122.441853461362)
32673	32673	178855	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1101 Girard St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6011864.77985	2089786.97938	37.718825637867205	-122.400980956107	(37.7188256378672, -122.400980956107)
33055	33055	237896	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	3337 26th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			10	Width 3ft		6007507.329580001	2100885.13303	37.749054710817205	-122.416828817304	(37.7490547108172, -122.416828817304)
35669	35669	237903	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	4120 26th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6003087.27911	2100682.5975099998	37.748248988421395	-122.432098917134	(37.7482489884214, -122.432098917134)
36891	36891	135862	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	8 Kimball Pl	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 4ft		6008000.712730001	2116486.83875	37.791921065252204	-122.416227532369	(37.7919210652522, -122.416227532369)
37189	37189	196334	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	185 Hampshire St	2	Sidewalk: Curb side : Pot 10	Tree 1	Private 1			8	Width 5ft		6010020.7902	2107448.7072099997	37.767217864928206	-122.408600163592	(37.7672178649282, -122.408600163592)
38247	38247	237913	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	256 Bemis St	2	Front Yard : Yard 7	Tree 1	Private 1			8			6003021.95871	2096302.8591099998	37.736219537998	-122.432012088491	(37.736219537998, -122.432012088491)
42845	42845	214337	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	10 Granada Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		5995645.82098	2089943.6870099998	37.7183378437938	-122.457054429431	(37.7183378437938, -122.457054429431)
45763	45763	237933	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	101 Lower Ter	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		6000440.92976	2106173.77589	37.7631760355812	-122.441643904037	(37.7631760355812, -122.441643904037)
46324	46324	135861	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	5 Dicha Aly	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		5998316.32407	2113776.61007	37.783930185978704	-122.44954003254999	(37.7839301859787, -122.44954003255)
47411	47411	237892	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	61 Elsie St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6007463.8743	2099061.8151700003	37.7440458449445	-122.416849925291	(37.7440458449445, -122.416849925291)
50181	50181	237877	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	400 Prospect Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5			6006273.45555	2097651.54951	37.7401065418729	-122.420866029569	(37.7401065418729, -122.420866029569)
50511	50511	237941	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	84 Potomac St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			16	Width 3ft		6003101.59687	2108830.30244	37.770621443648	-122.43263132298901	(37.770621443648, -122.432631322989)
51929	51929	237924	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	47 Seward St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 3ft		6000838.40395	2104323.1770900004	37.7581173832271	-122.440136465844	(37.7581173832271, -122.440136465844)
56030	56030	214314	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1630 09th Ave	2	Front Yard : Yard 7	Tree 1	Private 1			10	Width 6ft		5993419.49404	2104375.41426	37.7578356535119	-122.465797833501	(37.7578356535119, -122.465797833501)
58805	58805	237927	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	4780 19th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			8	Width 3ft		5999842.984730001	2104684.3807599996	37.75905243893521	-122.44360498998999	(37.7590524389352, -122.44360498999)
62287	62287	214325	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	121 Miraloma Dr	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 2ft		5994585.09435	2096884.89716	37.7373357495539	-122.461223767378	(37.7373357495539, -122.461223767378)
65313	65313	183563	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2593 30th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5987056.9644	2097643.917	37.738983699378096	-122.487307395263	(37.7389836993781, -122.487307395263)
70609	70609	237916	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1295 Stanyan St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		5997518.24966	2104934.77487	37.7596070976188	-122.451663046815	(37.7596070976188, -122.451663046815)
73967	73967	181900	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2374 28th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5987672.3244	2099143.5701	37.7431372169369	-122.485289801059	(37.7431372169369, -122.485289801059)
74881	74881	237899	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	401 Capp St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6007240.84354	2104941.30252	37.760177031272995	-122.418037841569	(37.760177031273, -122.418037841569)
75667	75667	123051	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	544 Funston Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5991925.368290001	2111718.74321	37.777912168825004	-122.47150017707199	(37.777912168825, -122.471500177072)
76982	76982	135865	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2518 Jackson St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001998.80283	2116724.02313	37.792233000491294	-122.437011118472	(37.7922330004913, -122.437011118472)
135434	135434	214312	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	1616 09th Ave	2	Front Yard : Yard 7	Tree 1	Private 1			8	Width 6ft		5993417.09067	2104452.78428	37.758047952866605	-122.465811766705	(37.7580479528666, -122.465811766705)
147995	147995	135868	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	2881 Vallejo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		5999820.06951	2117394.7311	37.7939505095535	-122.444597778561	(37.7939505095535, -122.444597778561)
153868	153868	214322	DPW Maintained 3	Prunus domestica 'Mariposa' :: Mariposa Plum 72	350x Kensington Way	2	Median : Cutout 11	Tree 1	DPW 2			12	Width 6ft		5994251.85903	2099042.92229	37.7432419652355	-122.462532396964	(37.7432419652355, -122.462532396964)
164027	164027	237931	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	18 Temple St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5999994.62286	2105880.85812	37.7623463174434	-122.443166486857	(37.7623463174434, -122.443166486857)
165498	165498	237910	Undocumented 2	Prunus domestica 'Mariposa' :: Mariposa Plum 72	414 Collingwood St	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			26			6002101.86364	2103432.6858200002	37.755744157774295	-122.435703175979	(37.7557441577743, -122.435703175979)

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