Street_Tree_List

Data source: data.sfgov.org

220 rows where qSiteInfo = 4 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: DBH, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
165900	165900	204094	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1 Sargent St	1	: 4	Tree 1	Private 1			12	Width 3ft		5993976.27625	2089155.91875	37.7160788007751	-122.462768183016	(37.7160788007751, -122.462768183016)
181990	181990	204052	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	109 Louisburg St	1	: 4	Tree 1	Private 1			4	Width 3ft		5997885.310880001	2091050.18574	37.721504387299795	-122.449393169677	(37.7215043872998, -122.449393169677)
173204	173204	201501	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1099 Innes Ave	1	: 4	Tree 1	Private 1			10	Width 2ft		6018217.02471	2095179.1389799998	37.733983766719	-122.379397893394	(37.733983766719, -122.379397893394)
185929	185929	201502	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1099 Innes Ave	2	: 4	Tree 1	Private 1			11	Width 2ft		6018234.7860900005	2095166.37786	37.733949706701004	-122.37933560007299	(37.733949706701, -122.379335600073)
31818	31818	175337	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	4	: 4	Tree 1	Private 1			14	Width 3ft		5994455.45704	2086824.9295299998	37.7097060419823	-122.46094307188801	(37.7097060419823, -122.460943071888)
39699	39699	175336	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	3	: 4	Tree 1	Private 1			9	Width 3ft		5994472.9026	2086825.04671	37.709707367568996	-122.460882785837	(37.709707367569, -122.460882785837)
166302	166302	175335	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	2	: 4	Tree 1	Private 1			10	Width 3ft		5994496.623790001	2086824.0668400002	37.7097060419715	-122.46080073078699	(37.7097060419715, -122.460800730787)
186035	186035	175334	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 De Long St	1	: 4	Tree 1	Private 1			12	Width 3ft		5994510.66891	2086823.77253	37.709706041981704	-122.460752167376	(37.7097060419817, -122.460752167376)
59462	59462	204053	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	114 Majestic Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		5997084.51167	2089384.1805200002	37.7168840852152	-122.452041160489	(37.7168840852152, -122.452041160489)
184910	184910	204054	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	116 Majestic Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5997034.58686	2089315.10144	37.7166915502611	-122.45220874374901	(37.7166915502611, -122.452208743749)
28877	28877	188060	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1241 Evans Ave	2	: 4	Tree 1	Private 1			1	Width 4ft		6017512.496169999	2097088.9484700002	37.7391888439962	-122.381966489387	(37.7391888439962, -122.381966489387)
157677	157677	188059	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1241 Evans Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		6017496.48371	2097099.74121	37.73921759440329	-122.38202260437599	(37.7392175944033, -122.382022604376)
184366	184366	188061	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1241 Evans Ave	4	: 4	Tree 1	Private 1			3	Width 3ft		6017553.88932	2097055.79305	37.739100091683895	-122.381821063598	(37.7391000916839, -122.381821063598)
137269	137269	219847	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1391 Clayton St	1	: 4	Tree 1	Private 1			2	Width 3ft		5999007.4175	2104658.45695	37.7589335683475	-122.446492901049	(37.7589335683475, -122.446492901049)
161220	161220	219845	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1395 Clayton St	1	: 4	Tree 1	Private 1			2	Width 3ft		5999065.80316	2104568.48584	37.7586898646717	-122.44628450473999	(37.7586898646717, -122.44628450474)
37923	37923	219846	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1397 Clayton St	1	: 4	Tree 1	Private 1			2	Width 3ft		5999123.67326	2104550.2809900003	37.7586431835444	-122.446083054815	(37.7586431835444, -122.446083054815)
133469	133469	250983	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	145 Seal Rock Dr	1	: 4	Tree 1	Private 1			1	Width 3ft		5981179.0028800005	2112933.49353	37.780619963167204	-122.508765181767	(37.7806199631672, -122.508765181767)
42095	42095	188048	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1500 22nd St	6	: 4	Tree 1	Private 1			8	Width 3ft		6013469.80822	2103846.3555900003	37.7575191604874	-122.396417902174	(37.7575191604874, -122.396417902174)
75579	75579	188047	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1500 22nd St	5	: 4	Tree 1	Private 1			7	Width 3ft		6013488.543409999	2103846.93228	37.7575217865193	-122.396353148306	(37.7575217865193, -122.396353148306)
164787	164787	188046	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1500 22nd St	3	: 4	Tree 1	Private 1			8	Width 3ft		6013506.07902	2103847.53296	37.75752441163671	-122.396292544776	(37.7575244116367, -122.396292544776)
51346	51346	187526	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	2	: 4	Tree 1	Private 1			7	Width 1ft		6012506.68997	2087960.4481099998	37.713846134852794	-122.398634006175	(37.7138461348528, -122.398634006175)
54859	54859	187528	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	4	: 4	Tree 1	Private 1			6	Width 1ft		6012472.93884	2087982.00491	37.7139034450734	-122.398752175284	(37.7139034450734, -122.398752175284)
157675	157675	187525	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	1	: 4	Tree 1	Private 1			5	Width 1ft		6012522.296569999	2087951.2705599999	37.7138218046169	-122.398579419997	(37.7138218046169, -122.398579419997)
181502	181502	187527	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	151 Mary Teresa St	3	: 4	Tree 1	Private 1			5	Width 1ft		6012489.4847099995	2087971.9174	37.713876668655296	-122.398694278718	(37.7138766686553, -122.398694278718)
27118	27118	219852	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	160 Saint Germain Ave	1	: 4	Tree 1	Private 1			3	Width 3ft		5997608.48937	2104144.50247	37.7574423754904	-122.451293958747	(37.7574423754904, -122.451293958747)
156443	156443	219853	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	160 Saint Germain Ave	2	: 4	Tree 1	Private 1			3	Width 3ft		5997587.19645	2104142.8709299997	37.7574366764665	-122.45136748012	(37.7574366764665, -122.45136748012)
24574	24574	250326	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 27th Ave	1	: 4	Tree 1	Private 1			2	Width 3ft		5987393.53331	2114913.8058	37.786421687562104	-122.487411939018	(37.7864216875621, -122.487411939018)
155050	155050	250327	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 27th Ave	2	: 4	Tree 1	Private 1			2	Width 3ft		5987392.49904	2114897.88557	37.7863779148594	-122.487414347421	(37.7863779148594, -122.487414347421)
39264	39264	204069	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	8	: 4	Tree 1	Private 1			1	Width 2ft		5991925.79364	2089647.35065	37.7173098413624	-122.469891319037	(37.7173098413624, -122.469891319037)
39356	39356	204071	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	10	: 4	Tree 1	Private 1			1	Width 2ft		5991926.528080001	2089611.9892799999	37.7172127901068	-122.469886207299	(37.7172127901068, -122.469886207299)
69075	69075	204067	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	6	: 4	Tree 1	Private 1			1	Width 2ft		5991926.95794	2089679.2355799999	37.717397456914796	-122.469889614813	(37.7173974569148, -122.469889614813)
134590	134590	204065	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	4	: 4	Tree 1	Private 1			1	Width 2ft		5991927.94965	2089726.34257	37.71752685855721	-122.469889614814	(37.7175268585572, -122.469889614814)
162914	162914	204064	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	3	: 4	Tree 1	Private 1			1	Width 2ft		5991927.921680001	2089748.4341799999	37.717587515118	-122.46989131904499	(37.717587515118, -122.469891319045)
165588	165588	204070	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	9	: 4	Tree 1	Private 1			1	Width 2ft		5991926.35575	2089627.2113400002	37.7172545762149	-122.469887910622	(37.7172545762149, -122.469887910622)
165761	165761	204063	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	2	: 4	Tree 1	Private 1			1	Width 2ft		5991928.61684	2089804.8745400002	37.71774252677329	-122.469893023248	(37.7177425267733, -122.469893023248)
184601	184601	204062	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	1	: 4	Tree 1	Private 1			1	Width 2ft		5991928.03433	2089824.0323400002	37.71779509575	-122.469896430779	(37.71779509575, -122.469896430779)
188232	188232	204068	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	7	: 4	Tree 1	Private 1			1	Width 2ft		5991927.09954	2089662.54158	37.7173516274427	-122.46988791059499	(37.7173516274427, -122.469887910595)
188378	188378	204066	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	161 Byxbee St	5	: 4	Tree 1	Private 1			2	Width 2ft		5991927.82266	2089696.89032	37.7174459825143	-122.469887910592	(37.7174459825143, -122.469887910592)
159002	159002	188063	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1630 La Salle Ave	1	: 4	Tree 1	Private 1			5	Width 3ft		6015422.30134	2096277.6142	37.7368454337733	-122.38913686859101	(37.7368454337733, -122.389136868591)
178282	178282	188064	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1630 La Salle Ave	2	: 4	Tree 1	Private 1			8	Width 3ft		6015400.35958	2096292.57482	37.7368852962249	-122.389213775914	(37.7368852962249, -122.389213775914)
164810	164810	188062	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1649 La Salle Ave	1	: 4	Tree 1	Private 1			1	Width 5ft		6015099.661859999	2096448.66175	37.737297204609106	-122.390264331527	(37.7372972046091, -122.390264331527)
73826	73826	188066	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1766 Revere Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		6014246.7994	2095052.7708599998	37.7334170310536	-122.39311545041599	(37.7334170310536, -122.393115450416)
154404	154404	175342	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	3	: 4	Tree 1	Private 1			11	Width 3ft		5994489.11096	2086733.7148099998	37.7094575242209	-122.46082015254801	(37.7094575242209, -122.460820152548)
187124	187124	175340	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	1	: 4	Tree 1	Private 1			4	Width 3ft		5994510.0494800005	2086755.6303299998	37.7095189038466	-122.460749373209	(37.7095189038466, -122.460749373209)
187533	187533	175341	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Rhine St	2	: 4	Tree 1	Private 1			7	Width 3ft		5994500.0272699995	2086747.2122099998	37.709495213017	-122.460783401753	(37.709495213017, -122.460783401753)
168242	168242	204091	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	18 Sargent St	2	: 4	Tree 1	Private 1			11	Width 3ft		5993976.66026	2089192.4471099998	37.7161791210507	-122.462769504124	(37.7161791210507, -122.462769504124)
150929	150929	187505	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	5	: 4	Tree 1	Private 1			9	Width 3ft		6004874.161669999	2086793.27995	37.710213148986504	-122.42493188792	(37.7102131489865, -122.42493188792)
153430	153430	187509	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	9	: 4	Tree 1	Private 1			5	Width 3ft		6004937.85944	2086722.41778	37.7100221743453	-122.424706697651	(37.7100221743453, -122.424706697651)
162385	162385	187507	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	7	: 4	Tree 1	Private 1			4	Width 3ft		6004913.95724	2086749.2623400001	37.7100945337938	-122.424791216847	(37.7100945337938, -122.424791216847)
162646	162646	187512	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	12	: 4	Tree 1	Private 1			4	Width 3ft		6004972.0075900005	2086680.68467	37.7099095126929	-122.424585708258	(37.7099095126929, -122.424585708258)
164843	164843	187510	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	10	: 4	Tree 1	Private 1			5	Width 3ft		6004948.81965	2086709.68307	37.709987826555704	-122.424667911703	(37.7099878265557, -122.424667911703)
169545	169545	187506	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	6	: 4	Tree 1	Private 1			9	Width 3ft		6004893.16086	2086772.3737400002	37.7101568181467	-122.424864736445	(37.7101568181467, -122.424864736445)
170289	170289	187511	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	1888 Geneva Ave	11	: 4	Tree 1	Private 1			5	Width 3ft		6004958.741090001	2086695.30162	37.7099488984891	-122.42463259891599	(37.7099488984891, -122.424632598916)
34312	34312	219850	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Aquavista Way	1	: 4	Tree 1	Private 1			4	Width 3ft		5997954.10401	2101824.32027	37.751091514263294	-122.449931477763	(37.7510915142633, -122.449931477763)
159265	159265	219851	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Aquavista Way	2	: 4	Tree 1	Private 1			3	Width 3ft		5997982.15762	2101832.44705	37.75111543354561	-122.449835051543	(37.7511154335456, -122.449835051543)
73954	73954	188039	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2 Madera St	4	: 4	Tree 1	Private 1			12	Width 3ft		6012947.35937	2103279.6507900003	37.7559340253584	-122.398184994452	(37.7559340253584, -122.398184994452)
64315	64315	247204	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	20 Alpine Ter	1	: 4	Tree 1	Private 1			4	Width 3ft		6001601.5903199995	2108602.69661	37.7699113137874	-122.437803549804	(37.7699113137874, -122.437803549804)
45622	45622	204092	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	20 Sargent St	1	: 4	Tree 1	Private 1			4	Width 3ft		5993952.38646	2089201.3292900003	37.71620211130279	-122.46285404939199	(37.7162021113028, -122.462854049392)
33928	33928	219839	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	1	: 4	Tree 1	Private 1			2	Width 3ft		5999574.1233	2100571.41335	37.7477438976585	-122.444239278237	(37.7477438976585, -122.444239278237)
55041	55041	219842	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	7	: 4	Tree 1	Private 1			6	Width 3ft		5999537.02176	2100424.88588	37.747339451848795	-122.44435704444099	(37.7473394518488, -122.444357044441)
130029	130029	219841	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	6	: 4	Tree 1	Private 1			5	Width 3ft		5999547.8979	2100446.48985	37.747399391666995	-122.44432098793999	(37.747399391667, -122.44432098794)
162335	162335	219843	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	8	: 4	Tree 1	Private 1			4	Width 3ft		5999523.61181	2100409.78432	37.747297221497	-122.444402329811	(37.747297221497, -122.444402329811)
166169	166169	219840	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	200 Portola Dr	4	: 4	Tree 1	Private 1			4	Width 3ft		5999567.441790001	2100499.89651	37.7475471484975	-122.444257243986	(37.7475471484975, -122.444257243986)
24687	24687	188070	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	2	: 4	Tree 1	Private 1			2	Width 4ft		6012192.04216	2096531.53608	37.737363051155796	-122.400323196466	(37.7373630511558, -122.400323196466)
30679	30679	188074	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	13	: 4	Tree 1	Private 1			4	Width 4ft		6012318.61445	2096437.2512599998	37.7371112221076	-122.399878955661	(37.7371112221076, -122.399878955661)
37689	37689	188071	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	3	: 4	Tree 1	Private 1			5	Width 4ft		6012207.53103	2096519.7102400002	37.7373314435832	-122.400268813564	(37.7373314435832, -122.400268813564)
43025	43025	188072	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	5	: 4	Tree 1	Private 1			5	Width 4ft		6012236.0848900005	2096497.99437	37.737273408537504	-122.400168564334	(37.7372734085375, -122.400168564334)
130621	130621	188075	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	15	: 4	Tree 1	Private 1			5	Width 4ft		6012333.35727	2096426.0066099998	37.7370811685632	-122.39982719337799	(37.7370811685632, -122.399827193378)
135372	135372	188073	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	10	: 4	Tree 1	Private 1			3	Width 4ft		6012282.35335	2096466.63669	37.7371898866961	-122.40000639049299	(37.7371898866961, -122.400006390493)
148168	148168	188078	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	28	: 4	Tree 1	Private 1			1	Width 3ft		6012505.18891	2096292.6832	37.7367246682956	-122.399223733893	(37.7367246682956, -122.399223733893)
152438	152438	188076	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	17	: 4	Tree 1	Private 1			6	Width 4ft		6012348.2973	2096415.13527	37.737052151020706	-122.39977477549499	(37.7370521510207, -122.399774775495)
154655	154655	188079	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	29	: 4	Tree 1	Private 1			1	Width 3ft		6012534.30778	2096270.76721	37.73666611435429	-122.399121518759	(37.7366661143543, -122.399121518759)
167783	167783	188077	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	20	: 4	Tree 1	Private 1			2	Width 4ft		6012366.41561	2096402.12355	37.7370174335949	-122.3997112186	(37.7370174335949, -122.3997112186)
168216	168216	188069	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2001 Revere Ave	1	: 4	Tree 1	Private 1			5	Width 4ft		6012175.97702	2096542.9963200002	37.7373936227068	-122.40037954618799	(37.7373936227068, -122.400379546188)
70182	70182	204056	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	201 Lakeview Ave	1	: 4	Tree 1	Private 1			8	Width 3ft		5997069.70996	2089426.6640700002	37.7169998873021	-122.452095385989	(37.7169998873021, -122.452095385989)
132631	132631	204077	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	207 Arch St	1	: 4	Tree 1	Private 1			1	Width 3ft		5992694.39377	2088603.9622	37.7144893470695	-122.46715883152599	(37.7144893470695, -122.467158831526)
67849	67849	204096	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	21 Sargent St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993896.88715	2089161.0094599999	37.7160882058709	-122.46304295648599	(37.7160882058709, -122.463042956486)
34857	34857	204074	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	3	: 4	Tree 1	Private 1			8	Width 3ft		5992726.806	2088618.3095900002	37.714530612473105	-122.46704784529699	(37.7145306124731, -122.467047845297)
41338	41338	204076	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	5	: 4	Tree 1	Private 1			9	Width 3ft		5992727.09649	2088647.4013599998	37.7146105082406	-122.467048955052	(37.7146105082406, -122.467048955052)
160390	160390	204073	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	2	: 4	Tree 1	Private 1			6	Width 3ft		5992727.7538	2088602.30188	37.7144867138609	-122.467043406235	(37.7144867138609, -122.467043406235)
180927	180927	204075	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	4	: 4	Tree 1	Private 1			4	Width 3ft		5992726.79414	2088633.01861	37.7145709992182	-122.46704895504101	(37.7145709992182, -122.467048955041)
187147	187147	204072	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	216 Arch St	1	: 4	Tree 1	Private 1			3	Width 3ft		5992726.8230099995	2088588.5716900001	37.714448960336206	-122.46704562576299	(37.7144489603362, -122.467045625763)
135812	135812	188057	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2177 Jerrold Ave	3	: 4	Tree 1	Private 1			5	Width 3ft		6012331.191980001	2099204.96166	37.7447114700542	-122.400029778274	(37.7447114700542, -122.400029778274)
165696	165696	204093	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	22 Sargent St	1	: 4	Tree 1	Private 1			5	Width 3ft		5993932.401430001	2089196.0396599998	37.716186436122605	-122.462922743188	(37.7161864361226, -122.462922743188)
45577	45577	247774	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	222 30th St	1	: 4	Tree 1	Private 1			7	Width 3ft		6005147.38191	2098466.01095	37.7422793318144	-122.424817464458	(37.7422793318144, -122.424817464458)
157604	157604	204080	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	225 Victoria St	1	: 4	Tree 1	Private 1			9	Width 3ft		5993216.93955	2088773.98493	37.714986338524206	-122.465365061769	(37.7149863385242, -122.465365061769)
160643	160643	247775	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	226 30th St	1	: 4	Tree 1	Private 1			12	Width 3ft		6005119.5309	2098464.40515	37.7422733495371	-122.42491365056999	(37.7422733495371, -122.42491365057)
34235	34235	188054	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	226 Missouri St	1	: 4	Tree 1	Private 1			4	Width 3ft		6013429.19635	2105999.0041	37.7634276020221	-122.39670926094999	(37.7634276020221, -122.39670926095)
180941	180941	204061	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	238 Byxbee St	1	: 4	Tree 1	Private 1			8	Width 3ft		5991965.696690001	2090114.3483099998	37.718594409584206	-122.469787374509	(37.7185944095842, -122.469787374509)
177587	177587	204095	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	24 Sargent St	1	: 4	Tree 1	Private 1			5	Width 3ft		5993902.945830001	2089194.7546400002	37.7161812110757	-122.463024461917	(37.7161812110757, -122.463024461917)
158544	158544	250490	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	246 El Camino Del Mar	1	: 4	Tree 1	Private 1			7	Width 3ft		5987788.79254	2115350.25129	37.787643084702	-122.486076508742	(37.787643084702, -122.486076508742)
177462	177462	204058	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	247 Monticello St	1	: 4	Tree 1	Private 1			1	Width 3ft		5991672.76031	2090179.42511	37.718756158047206	-122.470804664228	(37.7187561580472, -122.470804664228)
152452	152452	175339	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	248 Wilson St	3	: 4	Tree 1	Private 1			8	Width 3ft		5994341.375580001	2086670.8513099998	37.709276414241295	-122.46132619294399	(37.7092764142413, -122.461326192944)
159671	159671	175338	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	248 Wilson St	1	: 4	Tree 1	Private 1			10	Width 3ft		5994374.45478	2086640.5688599998	37.709195169503005	-122.461209673184	(37.709195169503, -122.461209673184)
50731	50731	204059	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	254 Monticello St	1	: 4	Tree 1	Private 1			9	Width 3ft		5991705.974830001	2090211.6163	37.71884646795999	-122.470692199481	(37.71884646796, -122.470692199481)
189122	189122	204102	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2690 Ocean Ave	1	: 4	Tree 1	Private 1			7	Width 3ft		5990691.67687	2095162.7954	37.7323824608655	-122.474559334655	(37.7323824608655, -122.474559334655)
185827	185827	204097	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	27 Sargent St	1	: 4	Tree 1	Private 1			7	Width 3ft		5993869.3414900005	2089159.6844099998	37.716082980832205	-122.46313807056002	(37.7160829808322, -122.46313807056)
64842	64842	218249	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	2715 14th Ave	2	: 4	Tree 1	Private 1			3	Width 4ft		5992216.53189	2097263.0156400003	37.7382373720581	-122.46944042685699	(37.7382373720581, -122.469440426857)
146772	146772	247782	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	274 30th St	1	: 4	Tree 1	Private 1			6	Width 3ft		6004804.71628	2098445.98307	37.7422049794818	-122.426000872448	(37.7422049794818, -122.426000872448)
46219	46219	246939	Undocumented 2	Arbutus 'Marina' :: Hybrid Strawberry Tree 12	289 Frederick St	1	: 4	Tree 1	Private 1			3	Width 3ft		5998674.663240001	2107589.15907	37.7669615293729	-122.44785470843901	(37.7669615293729, -122.447854708439)

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