Street_Tree_List

Data source: data.sfgov.org

221 rows where qSiteInfo = 2 and qSpecies = 12 sorted by qAddress

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
53867	53867	204800	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	0 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5991281.57381	2102416.71556	37.752334025717296	-122.473048745206	(37.7523340257173, -122.473048745206)
2702	2702	175365	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	18	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 5ft		5993296.25394	2087788.76232	37.712285726578	-122.465019407322	(37.712285726578, -122.465019407322)
2703	2703	175367	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	23	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993394.31846	2087754.15211	37.7121963492565	-122.464677958129	(37.7121963492565, -122.464677958129)
2705	2705	175366	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993316.47827	2087783.2739799998	37.7122718230516	-122.464949108223	(37.7122718230516, -122.464949108223)
2708	2708	175370	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	26	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993448.13741	2087722.6413599998	37.712112930839	-122.464489658971	(37.712112930839, -122.464489658971)
2709	2709	175364	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993263.021319999	2087797.41727	37.7123075747038	-122.465134896479	(37.7123075747038, -122.465134896479)
2716	2716	175362	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5993185.52762	2087808.44828	37.7123333942447	-122.46540353654	(37.7123333942447, -122.46540353654)
2720	2720	175369	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	25	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993431.63462	2087732.39125	37.7121387503812	-122.46454740445101	(37.7121387503812, -122.464547404451)
2721	2721	175371	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	27	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993471.88559	2087712.01586	37.712085124705204	-122.464406808033	(37.7120851247052, -122.464406808033)
2722	2722	175368	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Brotherhood Way	24	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993415.10175	2087740.6954	37.7121605985029	-122.464605149022	(37.7121605985029, -122.464605149022)
27670	27670	175373	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	10 Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5991419.90979	2088711.03664	37.714709696259	-122.47157171488001	(37.714709696259, -122.47157171488)
50475	50475	175375	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	10 Junipero Serra Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5991400.23386	2088781.3625299998	37.714901655675995	-122.471644844135	(37.714901655676, -122.471644844135)
33835	33835	188022	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1001 17th St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		6014182.1741	2106635.38485	37.7652168437069	-122.394149489126	(37.7652168437069, -122.394149489126)
43219	43219	188023	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1001 17th St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 2ft		6014199.363390001	2106636.17997	37.765219982328794	-122.39409009070101	(37.7652199823288, -122.394090090701)
181866	181866	188021	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1001 17th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		6014166.75536	2106634.96887	37.7652148445035	-122.394202790137	(37.7652148445035, -122.394202790137)
32910	32910	219662	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	101 Carmel St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5998188.58572	2105343.5098200003	37.7607677482651	-122.449374149901	(37.7607677482651, -122.449374149901)
177173	177173	219663	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	101 Carmel St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		5998207.34442	2105345.19067	37.760773436477706	-122.449309393328	(37.7607734364777, -122.449309393328)
136217	136217	204944	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	101 Santa Paula Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5994019.05211	2097121.33108	37.7379523463344	-122.463197973519	(37.7379523463344, -122.463197973519)
165557	165557	204945	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	101 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 6ft		5994007.17215	2097079.9143	37.737837941769	-122.463236043629	(37.737837941769, -122.463236043629)
170049	170049	204946	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	101 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994008.44212	2097065.4765599999	37.7377983724866	-122.463230605425	(37.7377983724866, -122.463230605425)
187833	187833	204943	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	101 Santa Paula Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5994032.70638	2097142.34763	37.7380108391394	-122.46315228886101	(37.7380108391394, -122.463152288861)
33853	33853	250615	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	107 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5987080.3378099995	2115303.7693	37.787474145255295	-122.488524173771	(37.7874741452553, -122.488524173771)
133973	133973	250614	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	107 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5987083.69063	2115313.12063	37.7875000169526	-122.48851326139999	(37.7875000169526, -122.4885132614)
187900	187900	250616	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	107 28th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5987080.55182	2115289.10715	37.7874338997015	-122.488522355317	(37.7874338997015, -122.488522355317)
53202	53202	204856	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	107 Noriega St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5993700.38714	2103218.6773	37.7546757514867	-122.464742397259	(37.7546757514867, -122.464742397259)
133358	133358	250617	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	108 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5987120.23284	2115251.6203799997	37.7873332871477	-122.48838231292	(37.7873332871477, -122.48838231292)
163301	163301	250618	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	108 28th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5987122.80154	2115273.55204	37.787393655047104	-122.488375038274	(37.7873936550471, -122.488375038274)
129213	129213	204947	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	111 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994012.76503	2097046.5891200001	37.737746761309296	-122.463214289036	(37.7377467613093, -122.463214289036)
148357	148357	204948	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	111 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5994014.61795	2097029.94632	37.737701171061396	-122.463206675372	(37.7377011710614, -122.463206675372)
57567	57567	188053	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1133 19th St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		6014102.5404900005	2105239.77863	37.7613803880171	-122.39432720234	(37.7613803880171, -122.39432720234)
9934	9934	102961	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	4	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9935	9935	102960	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9936	9936	102965	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	9	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9937	9937	102966	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	10	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9939	9939	102963	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9940	9940	102969	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	12	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9941	9941	102968	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	11	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9943	9943	102967	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	13	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9944	9944	11821	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2	3		5991432.171815401	2088660.0347764	37.7145703669544	-122.47152561846501	(37.7145703669544, -122.471525618465)
9945	9945	102971	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	18	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
9947	9947	11824	Permitted Site 1	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	14	Sidewalk: Curb side : Yard 2	Tree 1	PUC 13		03/13/2013 12:00:00 AM	2	3		5991432.171815401	2088660.0347764	37.7145703669544	-122.47152561846501	(37.7145703669544, -122.471525618465)
91005	91005	102964	DPW Maintained 3	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1299X Junipero Serra Blvd	8	Sidewalk: Curb side : Yard 2	Tree 1	DPW 2		03/09/2013 12:00:00 AM	2			5991413.8	2088806.6	37.714971736494	-122.471599792301	(37.714971736494, -122.471599792301)
30300	30300	219757	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1335 Douglass St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 2ft		6001386.79678	2099806.89214	37.7457479531147	-122.43791640932601	(37.7457479531147, -122.437916409326)
171665	171665	219756	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1335 Douglass St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 2ft		6001388.58619	2099788.88641	37.7456986154004	-122.43790893236601	(37.7456986154004, -122.437908932366)
147087	147087	204950	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	135 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5994024.2821	2096935.7591799998	37.73744311331011	-122.463166429792	(37.7374431133101, -122.463166429792)
170680	170680	204949	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	135 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		5994022.774119999	2096956.70637	37.737500542219	-122.46317316303002	(37.737500542219, -122.46317316303)
42548	42548	204951	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	145 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		5994031.745019999	2096886.09513	37.7373071780787	-122.463137024673	(37.7373071780787, -122.463137024673)
45706	45706	183641	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1484 47th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 0ft		5981572.5337	2105003.3239	37.7588692133791	-122.50681542120701	(37.7588692133791, -122.506815421207)
157133	157133	175298	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1498 Geneva Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		6002915.8546400005	2087711.61866	37.712623896842295	-122.431765713815	(37.7126238968423, -122.431765713815)
188784	188784	184377	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1521 Rivera St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5988408.1936	2100317.5308	37.7464034445307	-122.48283140934299	(37.7464034445307, -122.482831409343)
36519	36519	204953	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	155 Santa Paula Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994037.68152	2096854.65097	37.737221182201	-122.463114218756	(37.737221182201, -122.463114218756)
42315	42315	204952	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	155 Santa Paula Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		5994033.93494	2096871.02037	37.7372659126841	-122.463128359687	(37.7372659126841, -122.463128359687)
42937	42937	204954	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	155 Santa Paula Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 6ft		5994039.534469999	2096838.00818	37.7371755919718	-122.463106605104	(37.7371755919718, -122.463106605104)
150936	150936	125586	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1570 Greenwich St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		6005351.57668	2119600.69848	37.800321618997295	-122.425615279117	(37.8003216189973, -122.425615279117)
130249	130249	246809	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Brewster St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 8ft		6010252.11367	2098972.92466	37.7439582096165	-122.407202509188	(37.7439582096165, -122.407202509188)
70348	70348	175268	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	17 Curtis St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 4ft		6000541.31656	2088471.1421	37.7145744894882	-122.440027270142	(37.7145744894882, -122.440027270142)
182404	182404	182722	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1723 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5985925.1892	2103477.2512	37.754934393373496	-122.49164978734801	(37.7549343933735, -122.491649787348)
71573	71573	204816	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1801 08th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5993723.6347	2103184.07069	37.7545820709068	-122.46465948875	(37.7545820709068, -122.46465948875)
185571	185571	204815	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1801 08th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5993723.97604	2103200.32785	37.75462672856371	-122.46465948875601	(37.7546267285637, -122.464659488756)
130647	130647	204779	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1811 17th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 2ft		5990906.362980001	2103054.34687	37.754063063173	-122.4743927982	(37.754063063173, -122.4743927982)
1878	1878	251764	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1				Width 6ft		6001178.343719999	2087386.3168	37.7116320444605	-122.43774780171302	(37.7116320444605, -122.437747801713)
65186	65186	175545	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6001219.37593	2087363.7539	37.7115724247979	-122.437604368864	(37.7115724247979, -122.437604368864)
134460	134460	175544	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	187 Seville St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6001192.72242	2087375.86302	37.7116041582787	-122.437697356964	(37.7116041582787, -122.437697356964)
56647	56647	175274	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	19 Brunswick St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		6001024.26555	2087488.4047299998	37.7119035929554	-122.438287644984	(37.7119035929554, -122.438287644984)
57453	57453	175343	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	19 Rhine St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5994542.86208	2086742.78517	37.709485521912605	-122.460635037876	(37.7094855219126, -122.460635037876)
137855	137855	250452	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	190 Seacliff Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5987230.75462	2115760.09761	37.7887358671233	-122.48803731227301	(37.7887358671233, -122.488037312273)
177411	177411	250451	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	190 Seacliff Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5987248.64548	2115760.65458	37.788738440071	-122.48797545423099	(37.788738440071, -122.487975454231)
70311	70311	204799	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1908 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 3ft		5991285.361819999	2102398.09072	37.7522831060881	-122.473034287704	(37.7522831060881, -122.473034287704)
168337	168337	204795	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1964 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5991296.36687	2102036.80057	37.7512917348225	-122.47296988727501	(37.7512917348225, -122.472969887275)
178095	178095	204796	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1964 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5991297.713880001	2102046.6126	37.7513187540815	-122.472965944645	(37.7513187540815, -122.472965944645)
25309	25309	184952	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	16	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983556.4384	2101472.9274	37.749292356781794	-122.49969333533701	(37.7492923567818, -122.499693335337)
41231	41231	184943	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983564.899	2101252.9532	37.7486888648876	-122.49964782319401	(37.7486888648876, -122.499647823194)
70157	70157	184950	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983557.7921	2101427.5789	37.749167921775296	-122.499685303057	(37.7491679217753, -122.499685303057)
129935	129935	184951	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	15	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983556.4384	2101452.6221	37.7492366040439	-122.49969183478001	(37.7492366040439, -122.49969183478)
134243	134243	184946	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983561.8532	2101319.6223	37.7488717410938	-122.49966328209801	(37.7488717410938, -122.499663282098)
147983	147983	184948	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5983561.1763	2101354.4797	37.7489674101607	-122.49966819869101	(37.7489674101607, -122.499668198691)
154638	154638	184947	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983560.8379	2101339.2508	37.7489255759542	-122.49966824346701	(37.7489255759542, -122.499668243467)
184799	184799	184945	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983563.2069	2101296.9480000003	37.7488095631642	-122.49965692549101	(37.7488095631642, -122.499656925491)
186739	186739	184949	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983558.4689	2101406.2583	37.749109421016605	-122.499681387134	(37.7491094210166, -122.499681387134)
188944	188944	184944	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1990 41st Ave	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 0ft		5983563.2069	2101275.9659	37.748751952115505	-122.49965537495702	(37.7487519521155, -122.499655374957)
26486	26486	204793	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1998 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 2ft		5991300.85589	2101853.1475400003	37.7507877313777	-122.47294097314399	(37.7507877313777, -122.472940973144)
32069	32069	204794	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1998 16th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 2ft		5991301.04243	2101880.01512	37.750861513549104	-122.47294228706998	(37.7508615135491, -122.47294228707)
28433	28433	175352	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993139.4707	2087896.7194400001	37.7125731094281	-122.46556913053301	(37.7125731094281, -122.465569130533)
30613	30613	175346	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993589.7174	2087738.26685	37.712163995237105	-122.464001454798	(37.7121639952371, -122.464001454798)
35642	35642	175347	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993550.997219999	2087766.5420799998	37.712239400706395	-122.464137333384	(37.7122394007064, -122.464137333384)
54006	54006	175353	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5992903.53374	2087894.08049	37.712552252365796	-122.466384403718	(37.7125522523658, -122.466384403718)
77205	77205	175350	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993275.80872	2087878.6636599998	37.7125313952921	-122.46509659705099	(37.7125313952921, -122.465096597051)
129800	129800	175351	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	10	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993236.647480001	2087885.91358	37.7125490435751	-122.465232475607	(37.7125490435751, -122.465232475607)
146365	146365	204101	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993659.00835	2087684.8091799999	37.712021206289	-122.46375808926099	(37.712021206289, -122.463758089261)
152811	152811	175355	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 5ft		5992860.6815599995	2087893.2281099998	37.7125474391986	-122.46653245101001	(37.7125474391986, -122.46653245101)
165131	165131	175348	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5993488.42633	2087804.6670900001	37.7123404763923	-122.464356361476	(37.7123404763923, -122.464356361476)
171715	171715	175349	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5993438.390819999	2087824.9996200001	37.7123934203956	-122.4645307733	(37.7123934203956, -122.4645307733)
175356	175356	175345	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 5ft		5993607.01879	2087723.8804799998	37.7121254907785	-122.463940612974	(37.7121254907785, -122.463940612974)
178179	178179	204100	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993729.19042	2087617.8937400002	37.7118415163357	-122.46351066868	(37.7118415163357, -122.46351066868)
185937	185937	175354	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 5ft		5992875.91855	2087892.32357	37.712545834802604	-122.46647972197901	(37.7125458348026, -122.466479721979)
188007	188007	175344	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Brotherhood Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 5ft		5993634.16802	2087703.44428	37.7120709424008	-122.463845295648	(37.7120709424008, -122.463845295648)
23530	23530	222049	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Treat Ave	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 6ft		6008976.23011	2107818.47181	37.768174596097104	-122.41223929451401	(37.7681745960971, -122.412239294514)
31119	31119	222045	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Treat Ave	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		6008941.81103	2107754.9472	37.7679982408485	-122.412353856457	(37.7679982408485, -122.412353856457)
57565	57565	222041	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Treat Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 6ft		6008915.69571	2107685.46644	37.767805997273605	-122.41243927496599	(37.7678059972736, -122.412439274966)
68418	68418	222043	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Treat Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 6ft		6008927.7427199995	2107720.51685	37.7679029136253	-122.412400083419	(37.7679029136253, -122.412400083419)

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