Street_Tree_List

Data source: data.sfgov.org

281 rows where qSiteInfo = 4 and qSpecies = 16 sorted by TreeID

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: SiteOrder, DBH, PlotSize

Link	rowid	TreeID ▼	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
179239	179239	178758	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	3092 25th Ave	1	: 4	Tree 1	Private 1			3	Width 2ft		5988865.41335	2094809.6423099998	37.7313068078649	-122.480847233437	(37.7313068078649, -122.480847233437)
173510	173510	178759	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	3092 25th Ave	2	: 4	Tree 1	Private 1			3	Width 2ft		5988865.63691	2094820.20281	37.731335817282705	-122.480847233436	(37.7313358172827, -122.480847233436)
53509	53509	178760	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	3077 25th Ave	1	: 4	Tree 1	Private 1			4	Width 2ft		5988826.827409999	2094817.3494900002	37.7313257268874	-122.48098119462601	(37.7313257268874, -122.480981194626)
149184	149184	178761	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	3025 25th Ave	1	: 4	Tree 1	Private 1			3	Width 2ft		5988853.53072	2095119.96102	37.7321581726532	-122.480911025024	(37.7321581726532, -122.480911025024)
40286	40286	178844	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	52 Tomaso Ct	1	: 4	Tree 1	Private 1			16	Width 2ft		6009171.05644	2086338.49099	37.7092061672978	-122.410048805012	(37.7092061672978, -122.410048805012)
74997	74997	187551	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2441 19th Ave	1	: 4	Tree 1	Private 1			7	Width 3ft		5990426.260480001	2098774.7795	37.7422846621229	-122.475740599546	(37.7422846621229, -122.475740599546)
26565	26565	196129	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	537 Rhode Island St	2	: 4	Tree 1	Private 1			7	Width 3ft		6011814.46291	2105877.37979	37.763003645435205	-122.402285583717	(37.7630036454352, -122.402285583717)
60693	60693	196132	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1333 Rhode Island St	1	: 4	Tree 1	Private 1			9	Width 3ft		6012008.04219	2102176.90375	37.7528537582936	-122.401355988713	(37.7528537582936, -122.401355988713)
59533	59533	196133	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1007 Rhode Island St	1	: 4	Tree 1	Private 1			11	Width 3ft		6011938.93616	2103592.2223099996	37.7567360569294	-122.401694443163	(37.7567360569294, -122.401694443163)
76842	76842	196134	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1028 Wisconsin St	1	: 4	Tree 1	Private 1			2	Width 3ft		6012770.44441	2102683.83354	37.7542881850521	-122.398755016246	(37.7542881850521, -122.398755016246)
131443	131443	196135	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	893 Wisconsin St	2	: 4	Tree 1	Private 1			4	Width 3ft		6012789.32627	2103379.45901	37.756199273206704	-122.39873853257	(37.7561992732067, -122.39873853257)
150589	150589	196136	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	893 Wisconsin St	3	: 4	Tree 1	Private 1			6	Width 3ft		6012789.6073900005	2103393.313	37.756237328904206	-122.39873853257299	(37.7562373289042, -122.398738532573)
149351	149351	196139	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1601 Arkansas St	1	: 4	Tree 1	Private 1			11	Width 3ft		6012892.7022400005	2105610.51534	37.76233102358479	-122.39853757097299	(37.7623310235848, -122.398537570973)
72754	72754	196140	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1601 Arkansas St	2	: 4	Tree 1	Private 1			11	Width 3ft		6012891.95779	2105595.3281900003	37.762289281552	-122.398539080015	(37.762289281552, -122.398539080015)
77233	77233	196141	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1601 Arkansas St	3	: 4	Tree 1	Private 1			3	Width 3ft		6012893.04995	2105563.16463	37.762201028365	-122.39853304556601	(37.762201028365, -122.398533045566)
53375	53375	196142	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	310 Arkansas St	2	: 4	Tree 1	Private 1			11	Width 3ft		6012893.1643900005	2105525.8086200003	37.762098463386	-122.39853002833799	(37.762098463386, -122.398530028338)
67412	67412	196143	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	320 Arkansas St	1	: 4	Tree 1	Private 1			11	Width 3ft		6012893.50786	2105499.74083	37.7620269061246	-122.398527011124	(37.7620269061246, -122.398527011124)
40635	40635	196144	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	354 Arkansas St	2	: 4	Tree 1	Private 1			4	Width 3ft		6012902.24063	2105349.71395	37.7616154519153	-122.39848627993901	(37.7616154519153, -122.398486279939)
29237	29237	196145	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	356 Arkansas St	1	: 4	Tree 1	Private 1			4	Width 3ft		6012905.6272599995	2105323.15012	37.7615427021613	-122.398472702866	(37.7615427021613, -122.398472702866)
59969	59969	196146	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	356 Arkansas St	2	: 4	Tree 1	Private 1			5	Width 3ft		6012905.17801	2105301.00747	37.7614818782994	-122.39847270286998	(37.7614818782994, -122.39847270287)
63064	63064	196147	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	358 Arkansas St	2	: 4	Tree 1	Private 1			4	Width 3ft		6012905.746230001	2105264.51054	37.7613816974298	-122.398468176592	(37.7613816974298, -122.398468176592)
148377	148377	196148	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	358 Arkansas St	3	: 4	Tree 1	Private 1			11	Width 3ft		6012907.03197	2105241.89839	37.7613196810762	-122.39846214301399	(37.7613196810762, -122.398462143014)
168245	168245	196151	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	502 Missouri St	3	: 4	Tree 1	Private 1			7	Width 5ft		6013517.53008	2104664.07423	37.7597670932918	-122.396310171496	(37.7597670932918, -122.396310171496)
184595	184595	196152	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	648 Missouri St	1	: 4	Tree 1	Private 1			2	Width 3ft		6013554.341519999	2104016.61461	37.757991358542206	-122.39613748186301	(37.7579913585422, -122.396137481863)
42699	42699	196153	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	672 Missouri St	1	: 4	Tree 1	Private 1			7	Width 3ft		6013557.16695	2103938.65044	37.7577774430852	-122.39612224644699	(37.7577774430852, -122.396122246447)
161423	161423	196154	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1317 19th St	2	: 4	Tree 1	Private 1			3	Width 6ft		6013683.78692	2105210.99248	37.7612780613652	-122.395773489354	(37.7612780613652, -122.395773489354)
163092	163092	196155	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	418 Mississippi St	1	: 4	Tree 1	Private 1			8	Width 3ft		6014037.44823	2105136.58178	37.761093413462504	-122.39454510449801	(37.7610934134625, -122.394545104498)
57340	57340	196156	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	418 Mississippi St	2	: 4	Tree 1	Private 1			7	Width 3ft		6014038.63136	2105124.6384	37.7610606853181	-122.39454017618999	(37.7610606853181, -122.39454017619)
73795	73795	196157	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	422 Mississippi St	1	: 4	Tree 1	Private 1			12	Width 3ft		6014037.08737	2105100.22653	37.760993569807205	-122.394543806767	(37.7609935698072, -122.394543806767)
35009	35009	196179	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1998 Carroll Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		6012048.7693	2093556.75708	37.7291869385061	-122.40060964941401	(37.7291869385061, -122.400609649414)
175123	175123	196180	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2555 Phelps St	2	: 4	Tree 1	Private 1			6	Width 3ft		6012050.36585	2093618.4926900002	37.729356540763504	-122.400608465023	(37.7293565407635, -122.400608465023)
178450	178450	196181	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2545 Phelps St	1	: 4	Tree 1	Private 1			4	Width 3ft		6012082.65235	2093663.0206099998	37.729480605840294	-122.400499973489	(37.7294806058403, -122.400499973489)
152506	152506	196182	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	2525 Phelps St	2	: 4	Tree 1	Private 1			7	Width 3ft		6012152.25247	2093753.56625	37.7297331066907	-122.400265714517	(37.7297331066907, -122.400265714517)
160253	160253	196183	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	52 Robblee Ave	1	: 4	Tree 1	Private 1			4	Width 3ft		6012510.53762	2095915.5862200002	37.735689536940896	-122.399178778585	(37.7356895369409, -122.399178778585)
51943	51943	196184	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	160 Venus St	1	: 4	Tree 1	Private 1			6	Width 2ft		6012817.540030001	2094120.4485	37.730777564924004	-122.397991454042	(37.730777564924, -122.397991454042)
48720	48720	196185	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	199 Venus St	1	: 4	Tree 1	Private 1			7	Width 3ft		6012826.455709999	2093927.0961	37.730247155583896	-122.39794707250601	(37.7302471555839, -122.397947072506)
33949	33949	196186	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	199 Venus St	2	: 4	Tree 1	Private 1			7	Width 3ft		6012832.08257	2093948.98425	37.7303075693197	-122.397929154401	(37.7303075693197, -122.397929154401)
70546	70546	196187	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	199 Venus St	3	: 4	Tree 1	Private 1			8	Width 3ft		6012834.92194	2093967.94092	37.7303597785684	-122.397920667513	(37.7303597785684, -122.397920667513)
40068	40068	196188	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	88 Neptune St	1	: 4	Tree 1	Private 1			6	Width 3ft		6013049.10875	2093942.96421	37.7303031239855	-122.39717843815001	(37.7303031239855, -122.39717843815)
54699	54699	196189	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	49 Lucy St	2	: 4	Tree 1	Private 1			8	Width 4ft		6014162.436290001	2093869.58355	37.7301635528011	-122.393324350359	(37.7301635528011, -122.393324350359)
162602	162602	196190	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	39 Ceres St	1	: 4	Tree 1	Private 1			3	Width 3ft		6013905.10394	2093942.74194	37.7303501306396	-122.39421910833	(37.7303501306396, -122.39421910833)
71980	71980	196271	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	10 Cashmere St	1	: 4	Tree 1	Private 1			31			6017110.310380001	2095865.5402400002	37.7358073912904	-122.383271945238	(37.7358073912904, -122.383271945238)
71671	71671	196299	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	25 Stillman St	1	: 4	Tree 1	Private 1			5	Width 3ft		6014168.1975	2113125.45849	37.783036354289706	-122.394652354018	(37.7830363542897, -122.394652354018)
48192	48192	196300	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	25 Stillman St	2	: 4	Tree 1	Private 1			6	Width 3ft		6014184.739519999	2113142.03031	37.783082776381605	-122.3945962858	(37.7830827763816, -122.3945962858)
58251	58251	196301	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	246 Shipley St	1	: 4	Tree 1	Private 1			1	Width 3ft		6011446.6125	2111705.38284	37.778985471447704	-122.403968009318	(37.7789854714477, -122.403968009318)
48234	48234	196302	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	271 Shipley St	1	: 4	Tree 1	Private 1			1	Width 5ft		6011407.60626	2111629.45684	37.7787748169373	-122.404097603449	(37.7787748169373, -122.404097603449)
60157	60157	196303	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	249 Shipley St	1	: 4	Tree 1	Private 1			1	Width 5ft		6011469.591109999	2111688.37468	37.7789400547713	-122.403887319468	(37.7789400547713, -122.403887319468)
67673	67673	196304	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	249 Shipley St	2	: 4	Tree 1	Private 1			1	Width 5ft		6011481.859569999	2111700.79426	37.7789748414544	-122.403845751896	(37.7789748414544, -122.403845751896)
135530	135530	196305	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	218 Clara St	1	: 4	Tree 1	Private 1			1	Width 3ft		6011726.31972	2111713.41774	37.7790231566266	-122.40300094945	(37.7790231566266, -122.40300094945)
180896	180896	196306	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	218 Clara St	2	: 4	Tree 1	Private 1			1	Width 3ft		6011621.39145	2111749.7942	37.779117178052005	-122.40336650048	(37.779117178052, -122.40336650048)
149017	149017	196307	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	261 Clara St	1	: 4	Tree 1	Private 1			1	Width 3ft		6011514.4747	2111469.71481	37.7783421728992	-122.403716658713	(37.7783421728992, -122.403716658713)
156472	156472	196308	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	928 Clara St	1	: 4	Tree 1	Private 1			1	Width 3ft		6011682.43832	2111628.83367	37.7787884578701	-122.403146802398	(37.7787884578701, -122.403146802398)
74531	74531	196309	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	928 Clara St	2	: 4	Tree 1	Private 1			1	Width 3ft		6011709.8853	2111655.22921	37.77886246666711	-122.403053709087	(37.7788624666671, -122.403053709087)
35195	35195	196310	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	928 Clara St	3	: 4	Tree 1	Private 1			1	Width 3ft		6011726.41935	2111671.91567	37.778909207118204	-122.402997684908	(37.7789092071182, -122.402997684908)
183776	183776	196311	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	960 Harrison St	1	: 4	Tree 1	Private 1			1	Width 3ft		6011645.79902	2111357.16189	37.7780404638396	-122.403254436838	(37.7780404638396, -122.403254436838)
50719	50719	196312	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	175 Langton St	2	: 4	Tree 1	Private 1			4	Width 3ft		6010488.38064	2110422.4509900003	37.775409257068205	-122.407192474555	(37.7754092570682, -122.407192474555)
64835	64835	196313	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	175 Langton St	3	: 4	Tree 1	Private 1			4	Width 3ft		6010484.67452	2110427.749	37.775423596760994	-122.407205668504	(37.775423596761, -122.407205668504)
74813	74813	196314	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	268 Dore St	1	: 4	Tree 1	Private 1			7	Width 3ft		6009764.735169999	2108922.28563	37.7712496273027	-122.40958984051001	(37.7712496273027, -122.40958984051)
153177	153177	196315	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	268 Dore St	2	: 4	Tree 1	Private 1			7	Width 3ft		6009754.977519999	2108933.21891	37.7712791007824	-122.40962436457899	(37.7712791007824, -122.409624364579)
57064	57064	196316	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	333 11th St	5	: 4	Tree 1	Private 1			4	Width 3ft		6008680.78872	2109012.7716900003	37.7714372825214	-122.41334566929399	(37.7714372825214, -122.413345669294)
32713	32713	196317	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	333 11th St	6	: 4	Tree 1	Private 1			4	Width 3ft		6008676.43803	2109018.47977	37.7714527113022	-122.413361122339	(37.7714527113022, -122.413361122339)
165508	165508	196318	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	323 11th St	1	: 4	Tree 1	Private 1			4	Width 3ft		6008553.79261	2109149.29537	37.7718050135221	-122.413794615322	(37.7718050135221, -122.413794615322)
33781	33781	196319	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	83 Lafayette St	1	: 4	Tree 1	Private 1			10	Width 3ft		6007736.57644	2109492.64153	37.7727018336483	-122.416645755806	(37.7727018336483, -122.416645755806)
149317	149317	201255	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	75 Orsi Cir	10	: 4	Tree 1	Private 1			5	Width 2ft		6012912.12482	2093252.0507900002	37.7283983904589	-122.39760357376801	(37.7283983904589, -122.397603573768)
169332	169332	201256	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	71 Orsi Cir	1	: 4	Tree 1	Private 1			6	Width 2ft		6012919.58919	2093246.3766599998	37.72838322609871	-122.39757737111401	(37.7283832260987, -122.397577371114)
63258	63258	201257	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	65 Orsi Cir	1	: 4	Tree 1	Private 1			6	Width 2ft		6012943.60818	2093227.4806	37.728332678797706	-122.397493011087	(37.7283326787977, -122.397493011087)
170856	170856	201258	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	61 Orsi Cir	1	: 4	Tree 1	Private 1			5	Width 2ft		6012951.26118	2093221.98705	37.7283180207512	-122.397466169032	(37.7283180207512, -122.397466169032)
180525	180525	201259	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	49 Orsi Cir	1	: 4	Tree 1	Private 1			6	Width 2ft		6012982.74833	2093197.6009	37.7282528145074	-122.39735560639099	(37.7282528145074, -122.397355606391)
62850	62850	201260	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	45 Orsi Cir	1	: 4	Tree 1	Private 1			5	Width 2ft		6013004.45823	2093183.3541299999	37.7282149044906	-122.397279555225	(37.7282149044906, -122.397279555225)
173055	173055	201261	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	35 Orsi Cir	1	: 4	Tree 1	Private 1			4	Width 2ft		6013013.71474	2093174.88263	37.7281921588255	-122.397246961083	(37.7281921588255, -122.397246961083)
63746	63746	201262	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	31 Orsi Cir	1	: 4	Tree 1	Private 1			5	Width 2ft		6013038.336490001	2093158.36768	37.728148182884	-122.397160684615	(37.728148182884, -122.397160684615)
58745	58745	201263	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	25 Orsi Cir	1	: 4	Tree 1	Private 1			6	Width 2ft		6013048.513180001	2093149.69314	37.7281249309054	-122.39712489518999	(37.7281249309054, -122.39712489519)
149249	149249	201264	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	19 Orsi Cir	1	: 4	Tree 1	Private 1			4	Width 2ft		6013069.60933	2093132.51342	37.7280789332913	-122.397050760481	(37.7280789332913, -122.397050760481)
181642	181642	201265	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	15 Orsi Cir	1	: 4	Tree 1	Private 1			7	Width 2ft		6013080.9244	2093125.28837	37.728059724652	-122.397011137269	(37.728059724652, -122.397011137269)
137378	137378	201266	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	5 Orsi Cir	1	: 4	Tree 1	Private 1			7	Width 2ft		6013111.336569999	2093102.5811299998	37.7279990680861	-122.39690440933501	(37.7279990680861, -122.396904409335)
148432	148432	201284	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	54 Lydia Ave	1	: 4	Tree 1	Private 1			3	Width 2ft		6012733.71959	2092930.63877	37.727505923041896	-122.39819779269301	(37.7275059230419, -122.398197792693)
175473	175473	201311	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	5 Lydia Ave	1	: 4	Tree 1	Private 1			4	Width 2ft		6012959.91196	2092716.8460099997	37.7269314882778	-122.39740085216101	(37.7269314882778, -122.397400852161)
170981	170981	201332	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	89 Bitting Ave	1	: 4	Tree 1	Private 1			10	Width 2ft		6012542.673690001	2092777.7052099998	37.7270753555347	-122.39884751510701	(37.7270753555347, -122.398847515107)
181845	181845	201407	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	201 Harbor Rd	2	: 4	Tree 1	Private 1			4	Width 4ft		6018140.985830001	2094924.5554099998	37.733280536449705	-122.379643105252	(37.7332805364497, -122.379643105252)
130448	130448	201904	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1797 Yosemite Ave	1	: 4	Tree 1	Private 1			2	Width 3ft		6013567.70299	2093393.69523	37.7288238003734	-122.395347110876	(37.7288238003734, -122.395347110876)
173931	173931	201905	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1797 Yosemite Ave	2	: 4	Tree 1	Private 1			2	Width 3ft		6013584.00079	2093382.5672099998	37.728794151521	-122.395289988656	(37.728794151521, -122.395289988656)
168510	168510	201941	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	7	: 4	Tree 1	Private 1			2	Width 3ft		6013681.12245	2092335.8479	37.7259254733716	-122.394880951809	(37.7259254733716, -122.394880951809)
185938	185938	201942	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	8	: 4	Tree 1	Private 1			2	Width 3ft		6013661.36989	2092347.25444	37.7259556950922	-122.394950034125	(37.7259556950922, -122.394950034125)
73494	73494	201943	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	9	: 4	Tree 1	Private 1			2	Width 3ft		6013641.01292	2092357.4486099998	37.7259825542392	-122.39502112103999	(37.7259825542392, -122.39502112104)
147663	147663	201944	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	10	: 4	Tree 1	Private 1			2	Width 3ft		6013619.17874	2092369.08927	37.726013302964894	-122.395097415939	(37.7260133029649, -122.395097415939)
130580	130580	201945	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	12	: 4	Tree 1	Private 1			2	Width 3ft		6013588.62557	2092382.18651	37.72604756622879	-122.395203954116	(37.7260475662288, -122.395203954116)
75679	75679	201946	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	15	: 4	Tree 1	Private 1			2	Width 3ft		6013528.35075	2092407.54642	37.7261138471553	-122.395414097787	(37.7261138471553, -122.395414097787)
134420	134420	201947	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	16	: 4	Tree 1	Private 1			2	Width 3ft		6013508.30345	2092417.8690400003	37.7261410759436	-122.39548412349801	(37.7261410759436, -122.395484123498)
69176	69176	201948	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	17	: 4	Tree 1	Private 1			2	Width 3ft		6013493.80219	2092427.9191599998	37.726167864948394	-122.39553495768801	(37.7261678649484, -122.395534957688)
24067	24067	201949	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	18	: 4	Tree 1	Private 1			2	Width 3ft		6013468.57071	2092447.06427	37.7262190300648	-122.395623522912	(37.7262190300648, -122.395623522912)
156186	156186	201950	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	19	: 4	Tree 1	Private 1			2	Width 3ft		6013454.07417	2092462.86765	37.726261616558205	-122.39567474381599	(37.7262616165582, -122.395674743816)
54190	54190	201951	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	21	: 4	Tree 1	Private 1			2	Width 3ft		6013437.11385	2092477.4793	37.7263007937235	-122.39573439853999	(37.7263007937235, -122.39573439854)
159357	159357	201952	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1650 Carroll Ave	25	: 4	Tree 1	Private 1			2	Width 2ft		6013392.01965	2092548.68574	37.726493803536	-122.395895275553	(37.726493803536, -122.395895275553)
52347	52347	201970	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	21	: 4	Tree 1	Private 1			3	Width 3ft		6013765.00423	2092206.62002	37.725575303453496	-122.39458193081998	(37.7255753034535, -122.39458193082)
185885	185885	201972	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	19	: 4	Tree 1	Private 1			3	Width 3ft		6013746.1142	2092220.9433400002	37.725613582194796	-122.39464823513501	(37.7256135821948, -122.394648235135)
187589	187589	201974	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	17	: 4	Tree 1	Private 1			4	Width 3ft		6013727.10603	2092236.0738	37.725654070573704	-122.39471500442	(37.7256540705737, -122.39471500442)
130792	130792	201976	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	15	: 4	Tree 1	Private 1			5	Width 3ft		6013710.28394	2092247.91618	37.725685652057706	-122.394773986446	(37.7256856520577, -122.394773986446)
165875	165875	201977	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	14	: 4	Tree 1	Private 1			5	Width 4ft		6013690.4115699995	2092261.6964099999	37.7257223848541	-122.394843648839	(37.7257223848541, -122.394843648839)
56024	56024	201979	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	12	: 4	Tree 1	Private 1			3	Width 3ft		6013673.656359999	2092275.41387	37.7257591185834	-122.39490253103901	(37.7257591185834, -122.394902531039)
150209	150209	201982	Undocumented 2	Prunus cerasifera :: Cherry Plum 16	1651 Carroll Ave	9	: 4	Tree 1	Private 1			2	Width 3ft		6013638.14457	2092296.9483299998	37.7258162731896	-122.395026801165	(37.7258162731896, -122.395026801165)

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