Street_Tree_List

Data source: data.sfgov.org

326 rows where DBH = 3 and qSpecies = 48 sorted by PlantDate

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, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate ▼	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
22862	22862	176910	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1390 Silver Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6009561.38521	2094361.93193	37.7312587382014	-122.409265579153	(37.7312587382014, -122.409265579153)
22870	22870	176911	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1390 Silver Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6009574.07755	2094366.6897	37.731272513113296	-122.409222034865	(37.7312725131133, -122.409222034865)
22875	22875	176912	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1390 Silver Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6009589.47798	2094371.19963	37.7312857592085	-122.409169110679	(37.7312857592085, -122.409169110679)
22876	22876	176913	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1390 Silver Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6009673.25426	2094402.8730900001	37.7313774208194	-122.40888171341999	(37.7313774208194, -122.40888171342)
24383	24383	116552	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	1041x Naples St	8	Median : Yard 3	Tree 1	DPW 2			3	3x3		6001598.03525	2088202.06693	37.7138957693564	-122.436355582838	(37.7138957693564, -122.436355582838)
25454	25454	227130	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	200 Portola Dr	2	: 4	Tree 1	Private 1			3	Width 3ft		5999573.3022300005	2100550.7346900003	37.747687072210105	-122.44424063169599	(37.7476870722101, -122.444240631696)
26381	26381	251002	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	250 Point Lobos Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5981992.43445	2112670.6708	37.7799462432625	-122.50593169049299	(37.7799462432625, -122.505931690493)
26506	26506	191237	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1600 Newhall St	6	: 4	Tree 1	Private 1			3	Width 2ft		6014127.4828	2095367.51286	37.7342746191851	-122.39354998485001	(37.7342746191851, -122.39354998485)
27395	27395	227153	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	105 Manchester St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6008266.03922	2099383.96222	37.7449754768472	-122.41409899629299	(37.7449754768472, -122.414098996293)
30112	30112	207019	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	234 Staples Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 1ft		5998513.62611	2093807.4558	37.7291111292533	-122.447419626323	(37.7291111292533, -122.447419626323)
30642	30642	176917	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	1002x Naples St	9	Median : Yard 3	Tree 1	DPW 2			3			6001514.03799	2088123.65893	37.7136757052349	-122.436640299224	(37.7136757052349, -122.436640299224)
33605	33605	227093	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	31	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 9ft		6009184.481319999	2095791.0539799999	37.7351616771725	-122.41066949551201	(37.7351616771725, -122.410669495512)
35687	35687	191236	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1600 Newhall St	4	: 4	Tree 1	Private 1			3	Width 2ft		6014135.07988	2095376.9884099998	37.734301059229104	-122.39352438203998	(37.7343010592291, -122.39352438204)
35773	35773	121884	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	50 18th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5990230.5783400005	2114834.8193200002	37.78636985483121	-122.477590808601	(37.7863698548312, -122.477590808601)
37096	37096	207011	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	16 Circular Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6001351.22893	2094512.68179	37.731209264673296	-122.437660309391	(37.7312092646733, -122.437660309391)
37870	37870	247053	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	507 Valley St	1	: 4	Tree 1	Private 1			3	Width 2ft		6002585.442419999	2099146.1836099997	37.744001891474	-122.43372445791599	(37.744001891474, -122.433724457916)
38391	38391	251001	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	232 Point Lobos Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5982033.34511	2112665.09757	37.7799333487875	-122.505789751407	(37.7799333487875, -122.505789751407)
40870	40870	129385	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	722 Mason St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6009662.68842	2115877.38276	37.7903409582254	-122.41043401253	(37.7903409582254, -122.41043401253)
41022	41022	191235	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1600 Newhall St	2	: 4	Tree 1	Private 1			3	Width 2ft		6014141.54444	2095385.83675	37.7343257141509	-122.393502650848	(37.7343257141509, -122.393502650848)
44260	44260	116540	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	1002x Naples St	3	Median : Yard 3	Tree 1	DPW 2			3	3x3		6001555.506159999	2088195.95431	37.713876568835396	-122.43650214175399	(37.7138765688354, -122.436502141754)
45140	45140	191227	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	201 Texas St	1	: 4	Tree 1	Private 1			3	Width 3ft		6013759.687999999	2106121.42545	37.763782132758706	-122.39557476618201	(37.7637821327587, -122.395574766182)
48320	48320	140696	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	162 Shrader St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5997358.0622	2109907.9029	37.7732528619693	-122.452575957146	(37.7732528619693, -122.452575957146)
48322	48322	251000	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	226 Point Lobos Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5982074.747269999	2112660.45291	37.7799230326473	-122.505646180935	(37.7799230326473, -122.505646180935)
48842	48842	207037	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	2642 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5990833.84583	2097410.6031	37.738562605571104	-122.47423178898501	(37.7385626055711, -122.474231788985)
49520	49520	129379	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1765 Jackson St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6005697.11148	2117184.40611	37.793706610722	-122.424247645012	(37.793706610722, -122.424247645012)
50608	50608	227132	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	200 Portola Dr	5	: 4	Tree 1	Private 1			3	Width 3ft		5999561.91472	2100471.96222	37.747470132350394	-122.444274349099	(37.7474701323504, -122.444274349099)
50864	50864	191241	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1620 Newhall St	2	: 4	Tree 1	Private 1			3	Width 2ft		6014082.94285	2095307.88657	37.7341084226719	-122.39369980292601	(37.7341084226719, -122.393699802926)
52110	52110	227151	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	48 Fair Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6006822.59734	2099508.6280900002	37.7452366012942	-122.419099008325	(37.7452366012942, -122.419099008325)
58507	58507	191240	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1620 Newhall St	1	: 4	Tree 1	Private 1			3	Width 2ft		6014102.75792	2095335.27393	37.734184723832996	-122.393633211698	(37.734184723833, -122.393633211698)
60263	60263	247309	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	220 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		6002790.9139	2109368.8454	37.7720825259473	-122.43374447503099	(37.7720825259473, -122.433744475031)
62607	62607	207043	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	73 Keystone Way	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5994097.83418	2093287.06293	37.7274289275879	-122.46264752636999	(37.7274289275879, -122.46264752637)
64011	64011	176891	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	128 Craut St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004014.42285	2094241.1944400002	37.730614887467205	-122.428433829062	(37.7306148874672, -122.428433829062)
65132	65132	191233	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	2055 Silver Ave	6	: 4	Tree 1	Private 1			3	Width 3ft		6012545.7197199995	2096123.8065400003	37.7362632270542	-122.399071750278	(37.7362632270542, -122.399071750278)
65576	65576	176919	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	140 Seville St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6001505.61042	2087336.29034	37.71151328628479	-122.436613103724	(37.7115132862848, -122.436613103724)
70054	70054	184494	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1875 38th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5984410.615	2102424.5695	37.7519553887834	-122.496809845733	(37.7519553887834, -122.496809845733)
72347	72347	191244	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1620 Newhall St	5	: 4	Tree 1	Private 1			3	Width 2ft		6014050.660540001	2095263.98772	37.733986091481206	-122.39380834209801	(37.7339860914812, -122.393808342098)
72880	72880	248155	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	235 Rutledge St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6010048.23979	2099492.4434599997	37.7453732829604	-122.40794409015	(37.7453732829604, -122.40794409015)
74077	74077	227120	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	799 Duncan St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 4ft		6001486.2339699995	2099669.55813	37.7453765205103	-122.43756273743	(37.7453765205103, -122.43756273743)
75835	75835	176894	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	68 La Grande Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6005238.00808	2092009.9005900002	37.724557410279296	-122.42404509073201	(37.7245574102793, -122.424045090732)
77857	77857	84000	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	440X Santiago St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		3	3x3	Permit Number 771053	5991504.89622125	2099785.75892313	37.7451230278663	-122.47208471659799	(37.7451230278663, -122.472084716598)
130556	130556	227131	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	200 Portola Dr	3	: 4	Tree 1	Private 1			3	Width 3ft		5999574.512619999	2100531.90957	37.7476354520323	-122.44423509368	(37.7476354520323, -122.44423509368)
131222	131222	247385	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	355 Scott St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		6002203.8017	2109776.7723	37.7731692596784	-122.435804531936	(37.7731692596784, -122.435804531936)
133925	133925	227125	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	483 Clipper St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6002044.61682	2100877.8681799998	37.7487259861351	-122.435718376327	(37.7487259861351, -122.435718376327)
134386	134386	206992	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	633 Judah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992553.594409999	2105897.35752	37.761964523762	-122.468903201544	(37.761964523762, -122.468903201544)
134651	134651	207001	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	404 Santiago St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5991538.30054	2099790.96979	37.7451392685705	-122.47196959112301	(37.7451392685705, -122.471969591123)
134827	134827	206996	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1607 09th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		5993365.5475	2104527.17443	37.758249235518605	-122.465995428957	(37.7582492355186, -122.465995428957)
135130	135130	207012	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	16 Circular Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6001339.26796	2094505.8060299999	37.731189705325	-122.43770116826799	(37.731189705325, -122.437701168268)
136694	136694	227083	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	770 Treat Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6008514.3452699995	2104071.33726	37.75785989922729	-122.41357185686	(37.7578598992273, -122.41357185686)
144399	144399	104731	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	440X Santiago St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		3	3x3	Permit Number 771053	5991576.41061	2099773.5479200003	37.7450936377729	-122.471836544912	(37.7450936377729, -122.471836544912)
145537	145537	104730	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	440X Santiago St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1		3	3x3	Permit Number 771053	5991576.41061	2099773.5479200003	37.7450936377729	-122.471836544912	(37.7450936377729, -122.471836544912)
146422	146422	116546	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	1041x Naples St	2	Median : Yard 3	Tree 1	DPW 2			3	3x3		6001545.434780001	2088113.86518	37.7136505979649	-122.43653108014401	(37.7136505979649, -122.436531080144)
146673	146673	207006	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	243 Vicente St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992316.05801	2097825.5684599997	37.739787751096294	-122.469137249186	(37.7397877510963, -122.469137249186)
147620	147620	123462	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	620 02nd Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5995351.08305	2111296.01241	37.776949048100796	-122.459618879478	(37.7769490481008, -122.459618879478)
149356	149356	207000	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	404 Santiago St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5991556.482030001	2099793.0654	37.7451460746357	-122.471906875997	(37.7451460746357, -122.471906875997)
149388	149388	206993	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	615 Judah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992617.51095	2105899.8146900004	37.7619749630815	-122.468682319958	(37.7619749630815, -122.468682319958)
149989	149989	227160	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	236 Bosworth St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003812.10722	2095285.7669	37.7334715974377	-122.42920771908301	(37.7334715974377, -122.429207719083)
150094	150094	227148	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	401 Banks St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6008617.6421300005	2096897.82478	37.7381688320284	-122.412707488766	(37.7381688320284, -122.412707488766)
151249	151249	191219	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	318 Utah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6010580.39617	2106780.39752	37.7654141639451	-122.40661745795299	(37.7654141639451, -122.406617457953)
152382	152382	250789	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	285 32nd Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5985873.63674	2113998.18517	37.7838189038641	-122.492602865457	(37.7838189038641, -122.492602865457)
152401	152401	176892	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	128 Craut St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6004016.19178	2094155.9191400001	37.7303808407035	-122.428421637873	(37.7303808407035, -122.428421637873)
152707	152707	191242	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1620 Newhall St	3	: 4	Tree 1	Private 1			3	Width 2ft		6014072.32553	2095292.84785	37.734066539429996	-122.39373545834299	(37.73406653943, -122.393735458343)
153529	153529	183672	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1254 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 0ft		5984312.3195	2106638.1262	37.7635188796404	-122.497460805156	(37.7635188796404, -122.497460805156)
153555	153555	207048	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	658 Joost Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		5997718.79866	2095007.66028	37.7323611532403	-122.450253874818	(37.7323611532403, -122.450253874818)
156295	156295	116548	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	1002x Naples St	4	Median : Yard 3	Tree 1	DPW 2			3	3x3		6001544.87474	2088178.1549900002	37.713827091712396	-122.436537614614	(37.7138270917124, -122.436537614614)
158635	158635	116539	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	1002x Naples St	2	Median : Yard 3	Tree 1	DPW 2			3	3x3		6001567.487380001	2088213.7256900002	37.7139260459311	-122.436462001442	(37.7139260459311, -122.436462001442)
159032	159032	191243	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1620 Newhall St	4	: 4	Tree 1	Private 1			3	Width 2ft		6014061.56884	2095278.41625	37.734026315459104	-122.39377163804899	(37.7340263154591, -122.393771638049)
161119	161119	207025	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	85 Williar Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5997075.91635	2090573.81293	37.72015004606371	-122.45215665681299	(37.7201500460637, -122.452156656813)
162586	162586	183640	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1484 47th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5981572.1323	2104991.2828	37.7588361283195	-122.506815916291	(37.7588361283195, -122.506815916291)
162655	162655	207032	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	1672 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992498.79373	2104084.7245	37.7569843426628	-122.468960816591	(37.7569843426628, -122.468960816591)
163816	163816	227581	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	4330 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6000546.38941	2105812.04672	37.7621888245883	-122.441253199888	(37.7621888245883, -122.441253199888)
166285	166285	251003	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	250 Point Lobos Ave	2	: 4	Tree 1	Private 1			3	Width 3ft		5981957.64195	2112675.6435700003	37.7799578490271	-122.506052420011	(37.7799578490271, -122.506052420011)
166777	166777	207015	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	409 Edna St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 1ft		5998751.39592	2094165.7682599998	37.7301085556677	-122.44662340974101	(37.7301085556677, -122.446623409741)
167579	167579	191218	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	477 Vermont St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		6011234.32907	2106146.16371	37.763709265180395	-122.40431099816901	(37.7637092651804, -122.404310998169)
169727	169727	227134	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	200 Portola Dr	10	: 4	Tree 1	Private 1			3	Width 3ft		5999484.90108	2100375.94772	37.747202105595	-122.44453375672501	(37.747202105595, -122.444533756725)
171469	171469	227092	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	100 Alemany Blvd	30	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 9ft		6009197.49082	2095788.0482299998	37.7351541534232	-122.410624304588	(37.7351541534232, -122.410624304588)
179772	179772	176916	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	380 Rolph St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6001888.93185	2087835.8979599997	37.7129068748214	-122.43532396063601	(37.7129068748214, -122.435323960636)
182444	182444	227104	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	35 Carmel St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 4ft		5998773.50017	2105374.28879	37.76088570063521	-122.44735341554701	(37.7608857006352, -122.447353415547)
186541	186541	206994	Undocumented 2	Lagunaria patersonii :: Primrose Tree 48	607 Judah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		5992653.289	2105901.13559	37.761980656709	-122.468558674846	(37.761980656709, -122.468558674846)
11161	11161	27102	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	669 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/05/2009 12:00:00 AM	3	3X3		6005822.11431	2093583.57584	37.7289113394767	-122.422137656546	(37.7289113394767, -122.422137656546)
13144	13144	108829	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	545 Lathrop Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/06/2015 12:00:00 AM	3		Permit Number 773819	6012931.90275	2086607.7470099998	37.7101555653976	-122.397069513169	(37.7101555653976, -122.397069513169)
80279	80279	108768	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	500X Lathrop Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 773822	6012750.2	2086624.6	37.7101917236901	-122.397698699654	(37.7101917236901, -122.397698699654)
103563	103563	108764	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	500X Lathrop Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 773822	6012750.2	2086624.6	37.7101917236901	-122.397698699654	(37.7101917236901, -122.397698699654)
103975	103975	108778	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	500X Lathrop Ave	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 773822	6012750.2	2086624.6	37.7101917236901	-122.397698699654	(37.7101917236901, -122.397698699654)
115794	115794	108772	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	500X Lathrop Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 773822	6012750.2	2086624.6	37.7101917236901	-122.397698699654	(37.7101917236901, -122.397698699654)
127494	127494	108775	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	500X Lathrop Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 773822	6012750.2	2086624.6	37.7101917236901	-122.397698699654	(37.7101917236901, -122.397698699654)
140964	140964	108825	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	146-150X Gillette Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/06/2015 12:00:00 AM	3		Permit Number 773819	6013072.89275	2086799.9167400002	37.7106910734067	-122.39659568235001	(37.7106910734067, -122.39659568235)
12272	12272	27179	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	231 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/27/2009 12:00:00 AM	3	2X3		6002801.57598	2093850.9514400002	37.729474661304295	-122.432598955494	(37.7294746613043, -122.432598955494)
141540	141540	115381	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1657X York St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/28/2016 12:00:00 AM	3		Permit Number 775521	6010720.61658	2099977.2132599996	37.7467419766429	-122.405653246985	(37.7467419766429, -122.405653246985)
10726	10726	26985	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1353 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/29/2009 12:00:00 AM	3	3X3		6009441.55287	2094364.79553	37.731259886623896	-122.409680064978	(37.7312598866239, -122.409680064978)
12688	12688	27048	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	896 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/29/2009 12:00:00 AM	3	3X3		6007189.55023	2093517.44233	37.7288067843062	-122.417405636178	(37.7288067843062, -122.417405636178)
103181	103181	27003	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1380X Silver Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/29/2009 12:00:00 AM	3	3X3		6009629.1666	2094382.2025400002	37.7313181942464	-122.409032675373	(37.7313181942464, -122.409032675373)
107556	107556	109136	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	635 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/29/2015 12:00:00 AM	3	3x3	Permit Number 773405	5984096.474359999	2111505.41074	37.7768703987748	-122.49856689090299	(37.7768703987748, -122.498566890903)
10655	10655	26983	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	1395 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/30/2009 12:00:00 AM	3	3X3		6009622.935740001	2094432.5688200002	37.731456140283704	-122.409057769215	(37.7314561402837, -122.409057769215)
11229	11229	27181	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	225 Silver Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/30/2009 12:00:00 AM	3	2X3		6002702.00816	2093915.39197	37.7296459533895	-122.432947772843	(37.7296459533895, -122.432947772843)
12093	12093	27089	DPW Maintained 3	Lagunaria patersonii :: Primrose Tree 48	725 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/30/2009 12:00:00 AM	3	2X3		6006167.96193	2093597.45552	37.728968950933	-122.420943019604	(37.728968950933, -122.420943019604)
120335	120335	27286	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	682 Silver Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/30/2009 12:00:00 AM	3	3X3		6005885.56477	2093523.1174	37.7287489124796	-122.421914010506	(37.7287489124796, -122.421914010506)
19613	19613	109184	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	5 Santa Rosa Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/30/2015 12:00:00 AM	3	3x3	Permit Number 774827	6002270.0	2092514.4	37.7257746335194	-122.434341145327	(37.7257746335194, -122.434341145327)
115928	115928	109183	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	5 Santa Rosa Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/30/2015 12:00:00 AM	3	3x3	Permit Number 774827	6002270.0	2092514.4	37.7257746335194	-122.434341145327	(37.7257746335194, -122.434341145327)
122176	122176	109275	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1437 38th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/05/2015 12:00:00 AM	3	3x3	Permit Number 773660	5984291.9	2105367.5	37.7600289003771	-122.4974376175	(37.7600289003771, -122.4974376175)
124642	124642	109265	Permitted Site 1	Lagunaria patersonii :: Primrose Tree 48	1970 42nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	02/05/2015 12:00:00 AM	3	3x3	Permit Number 773567	5983260.0	2101732.7	37.7499882212347	-122.50073761576701	(37.7499882212347, -122.500737615767)

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