Street_Tree_List

Data source: data.sfgov.org

331 rows where qSpecies = 116 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

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
14101	14101	96173	Permitted Site 1	Sequoia sempervirens :: Coast Redwood 116			Unaccepted Street : Cutout 20	Tree 1	Private 1		04/04/2011 12:00:00 AM		3x3	Permit Number 767806
38586	38586	246713	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1 Bonview St	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			20			6007763.89494	2099225.75212	37.7445128502976	-122.415824124379	(37.7445128502976, -122.415824124379)
106519	106519	105769	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1 Gonzalez Dr	1	Front Yard : Yard 7	Tree 1	Private 1		02/24/2014 12:00:00 AM			Permit Number 772589	5990111.8	2090190.8	37.718696994740704	-122.476201051717	(37.7186969947407, -122.476201051717)
57311	57311	197586	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1 Jack Balestreri Way	1	Front Yard : Yard 7	Tree 1	Private 1			45	Width 10ft		6012374.628719999	2104733.59825	37.7598943275787	-122.400267811735	(37.7598943275787, -122.400267811735)
157277	157277	197589	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1 Jack Balestreri Way	5	Front Yard : Yard 7	Tree 1	Private 1			3			6012441.30894	2104748.70907	37.7599395365119	-122.40003825707	(37.7599395365119, -122.40003825707)
169778	169778	197588	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1 Jack Balestreri Way	4	Front Yard : Yard 7	Tree 1	Private 1			9			6012433.89716	2104751.224	37.7599460287107	-122.400064067605	(37.7599460287107, -122.400064067605)
174597	174597	197587	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1 Jack Balestreri Way	3	Front Yard : Yard 7	Tree 1	Private 1			12			6012433.76366	2104761.3607799998	37.7599738546281	-122.400065241211	(37.7599738546281, -122.400065241211)
163684	163684	120263	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	100 24th Ave	5	Side Yard : Yard 17	Tree 1	Private 1			8			5988364.34066	2115176.21089	37.7871987447814	-122.484072481257	(37.7871987447814, -122.484072481257)
838	838	19815	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY24	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	100ST
7290	7290	19816	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY24	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	100ST
15735	15735	19811	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY24	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	100ST
4452	4452	19593	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY4	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
6387	6387	19592	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY4	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
10060	10060	19578	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY4	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	8
7219	7219	20014	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY47	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
12451	12451	20015	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY47	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
5737	5737	20074	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	100 STAIRWAY55	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	27X
31261	31261	215028	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	100 Terrace Dr	23	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5993755.12546	2096561.9752	37.7364012864951	-122.464069896803	(37.7364012864951, -122.464069896803)
54404	54404	215029	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	100 Terrace Dr	24	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5993749.23334	2096552.6449799999	37.736375328444296	-122.464089591065	(37.7363753284443, -122.464089591065)
60028	60028	215024	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	100 Terrace Dr	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5993634.34816	2096702.85203	37.7367811376468	-122.46449769711201	(37.7367811376468, -122.464497697112)
60441	60441	215023	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	100 Terrace Dr	12	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5993620.60867	2096711.6491200002	37.736804500228	-122.464545838734	(37.736804500228, -122.464545838734)
135178	135178	215025	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	100 Terrace Dr	14	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10			5993646.76934	2096691.5619299999	37.7367508538673	-122.464453932502	(37.7367508538673, -122.464453932502)
164614	164614	215027	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	100 Terrace Dr	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14			5993761.26762	2096568.1489799998	37.7364185921533	-122.464049108976	(37.7364185921533, -122.464049108976)
168319	168319	215026	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	100 Terrace Dr	21	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13			5993767.12006	2096575.58918	37.7364393583851	-122.46402941471901	(37.7364393583851, -122.464029414719)
175766	175766	215022	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	100 Terrace Dr	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12			5993608.12799	2096720.10438	37.7368269967784	-122.464589603347	(37.7368269967784, -122.464589603347)
58796	58796	240619	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	104 Saturn St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		6000003.92034	2105982.96119	37.762627197305605	-122.443141663776	(37.7626271973056, -122.443141663776)
57707	57707	120269	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	107 24th Ave	2	Front Yard : Yard 7	Tree 1	Private 1			15			5988324.11159	2115191.8605299997	37.78723937201521	-122.48421281158701	(37.7872393720152, -122.484212811587)
73560	73560	120270	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	107 24th Ave	3	Front Yard : Yard 7	Tree 1	Private 1			11			5988338.64874	2115186.1535400003	37.7872245486486	-122.48416209809099	(37.7872245486486, -122.484162098091)
162555	162555	120268	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	107 24th Ave	1	Front Yard : Yard 7	Tree 1	Private 1			15			5988313.3781	2115206.48473	37.7872789009445	-122.48425101963899	(37.7872789009445, -122.484251019639)
88274	88274	3774	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	1098 Carolina St	7	Median : Cutout 11	Tree 1	DPW 2			12	18		6012462.6103665	2102859.9036449	37.754754478768	-122.39983195341699	(37.754754478768, -122.399831953417)
111685	111685	107343	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	110 JULIAN AVE	2	Back Yard : Yard 13	Tree 1	Private 1			15			6006340.8	2107214.1	37.7663669011591	-122.421312071366	(37.7663669011591, -122.421312071366)
61564	61564	136429	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1101 Greenwich St	11	Front Yard : Yard 7	Tree 1	Private 1			14			6007562.303180001	2119880.18015	37.801213673635004	-122.41798509543301	(37.801213673635, -122.417985095433)
176998	176998	136430	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1101 Greenwich St	15	Front Yard : Yard 7	Tree 1	Private 1			20			6007579.05475	2119893.16835	37.8012502787406	-122.417928048762	(37.8012502787406, -122.417928048762)
153412	153412	179499	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1151 Felton St	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 2ft		6007548.787880001	2092831.16716	37.7269426263769	-122.416115141404	(37.7269426263769, -122.416115141404)
166697	166697	136434	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	12 Greenwich St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18			6012298.4076	2120549.33954	37.8033164360554	-122.401643063984	(37.8033164360554, -122.401643063984)
40236	40236	120278	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	8	Front Yard : Yard 7	Tree 1	Private 1			14			5988337.84774	2115148.37916	37.7871207843354	-122.48416209808799	(37.7871207843354, -122.484162098088)
40443	40443	120276	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	6	Front Yard : Yard 7	Tree 1	Private 1			13			5988325.261	2115160.84311	37.787154273948204	-122.484206559328	(37.7871542739482, -122.484206559328)
40766	40766	120272	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	2	Front Yard : Yard 7	Tree 1	Private 1			13			5988314.622169999	2115170.4665900003	37.7871800778407	-122.48424407294901	(37.7871800778407, -122.484244072949)
50596	50596	120279	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	9	Front Yard : Yard 7	Tree 1	Private 1			14			5988331.03377	2115139.5257599996	37.787096078694205	-122.484185023117	(37.7870960786942, -122.484185023117)
62319	62319	120275	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	5	Front Yard : Yard 7	Tree 1	Private 1			11			5988318.18285	2115148.99603	37.78712133312521	-122.48423017871299	(37.7871213331252, -122.484230178713)
70268	70268	120281	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	11	Front Yard : Yard 7	Tree 1	Private 1			15			5988339.230269999	2115128.3543599998	37.7870658824376	-122.484155845816	(37.7870658824376, -122.484155845816)
72927	72927	120273	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	3	Front Yard : Yard 7	Tree 1	Private 1			16			5988307.3728	2115160.02273	37.787150979882796	-122.484268387653	(37.7871509798828, -122.484268387653)
134244	134244	120280	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	10	Front Yard : Yard 7	Tree 1	Private 1			15			5988322.2380099995	2115131.91384	37.7870746664109	-122.48421489568199	(37.7870746664109, -122.484214895682)
136684	136684	120271	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	1	Front Yard : Yard 7	Tree 1	Private 1			16			5988306.39603	2115180.23903	37.7872064312039	-122.48427325023998	(37.7872064312039, -122.48427325024)
148033	148033	120277	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	7	Front Yard : Yard 7	Tree 1	Private 1			3			5988335.64695	2115158.2234400003	37.787147685785705	-122.484170434457	(37.7871476857857, -122.484170434457)
155040	155040	120274	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	129 24th Ave	4	Front Yard : Yard 7	Tree 1	Private 1			9			5988307.12698	2115148.43075	37.7871191372985	-122.484268387654	(37.7871191372985, -122.484268387654)
24557	24557	136431	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	13 MacOndray Ln	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			23			6008632.90068	2119166.6230200003	37.799314619318	-122.414229834152	(37.799314619318, -122.414229834152)
161479	161479	136432	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	13 MacOndray Ln	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15			6008638.14667	2119166.05389	37.799313351297606	-122.414211640849	(37.7993133512976, -122.414211640849)
60921	60921	240596	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 San Jose Ave	8	Front Yard : Yard 7	Tree 1	Private 1			20			6003644.77453	2095717.8337299998	37.7346484808287	-122.429817043043	(37.7346484808287, -122.429817043043)
151692	151692	240595	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 San Jose Ave	7	Front Yard : Yard 7	Tree 1	Private 1			27			6003654.00301	2095729.23304	37.7346803033401	-122.429785949874	(37.7346803033401, -122.429785949874)
29043	29043	181547	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984881.425	2105994.983	37.761786329172104	-122.495445043427	(37.7617863291721, -122.495445043427)
44071	44071	181543	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984893.6781	2105927.5909	37.761602006776	-122.49539769507	(37.761602006776, -122.49539769507)
63429	63429	181539	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	17	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984878.0833	2105873.5659	37.761452756110394	-122.4954476457	(37.7614527561104, -122.4954476457)
64589	64589	186730	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	65	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984855.0036	2106288.7736	37.7625914487693	-122.495558092973	(37.7625914487693, -122.495558092973)
69472	69472	181545	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984885.3237	2105962.1224	37.7616963314413	-122.495429135957	(37.7616963314413, -122.495429135957)
73907	73907	186731	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	66	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984870.0408	2106303.059	37.7626315529982	-122.495507139178	(37.7626315529982, -122.495507139178)
160179	160179	186729	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	64	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984871.1686	2106270.3529	37.762541817251794	-122.49550082623999	(37.7625418172518, -122.49550082624)
162708	162708	186727	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	61	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 0ft		5984865.5297	2106265.0899	37.762527036338604	-122.49551994066002	(37.7625270363386, -122.49551994066)
167471	167471	181542	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984868.615	2105905.3126	37.7615393692586	-122.495482733656	(37.7615393692586, -122.495482733656)
167499	167499	186728	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	63	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984834.3273	2106260.9546	37.7625138548261	-122.49562755174401	(37.7625138548261, -122.495627551744)
168787	168787	181548	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984846.3366	2105995.5399	37.761785803641	-122.495566439468	(37.761785803641, -122.495566439468)
185835	185835	186726	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1300 Sunset Blvd	60	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 0ft		5984877.9354	2106257.1953	37.7625060863994	-122.49547645222201	(37.7625060863994, -122.495476452222)
106535	106535	113163	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	1300X STANYAN ST	2	Front Yard : Yard 7	Tree 1	Private 1			40	3x3		5997565.0	2104877.0	37.7594511396077	-122.451497194349	(37.7594511396077, -122.451497194349)
112251	112251	113162	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	1300X STANYAN ST	1	Front Yard : Yard 7	Tree 1	Private 1			40	3x3		5997565.0	2104877.0	37.7594511396077	-122.451497194349	(37.7594511396077, -122.451497194349)
1817	1817	251719	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	1301 Clayton St	1	Side Yard : Yard 17	Tree 1	Private 1						5999055.0	2105304.0	37.7607087868046	-122.446374778866	(37.7607087868046, -122.446374778866)
26484	26484	184736	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1301 Sunset Blvd	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984658.5537	2106283.3352	37.762565010947704	-122.49623713063801	(37.7625650109477, -122.496237130638)
35177	35177	184804	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1301 Sunset Blvd	65	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984679.0585	2105723.8188	37.7610299368102	-122.496124931271	(37.7610299368102, -122.496124931271)
51589	51589	184745	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1301 Sunset Blvd	11	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984671.0844	2106181.5705	37.7622863276384	-122.496186283596	(37.7622863276384, -122.496186283596)
55573	55573	184741	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1301 Sunset Blvd	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984704.12	2106224.4787	37.76240607654479	-122.496075193313	(37.7624060765448, -122.496075193313)
124987	124987	98548	Property Tree 7	Sequoia sempervirens :: Coast Redwood 116	132 Hamerton Ave	1	Front Yard : Yard 7	Tree 1	Private 1						6001332.8	2095440.7	37.7337563407686	-122.437790462907	(37.7337563407686, -122.437790462907)
60930	60930	52819	Permitted Site 1	Sequoia sempervirens :: Coast Redwood 116	1327@ JUDAH 28th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4		Permit Number 48844	5987385.2929	2106232.8495	37.7625857382219	-122.48680274332399	(37.7625857382219, -122.486802743324)
183468	183468	187562	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	136 Alpha St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 2ft		6010924.81275	2088138.49847	37.714246765754105	-122.40411411319401	(37.7142467657541, -122.404114113194)
30220	30220	181484	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1400 Sunset Blvd	44	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984898.4123	2105356.9862	37.7600355628364	-122.49533923888201	(37.7600355628364, -122.495339238882)
55401	55401	181491	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1400 Sunset Blvd	51	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984894.5136	2105385.9481	37.760114855862604	-122.49535485835699	(37.7601148558626, -122.495354858357)
105322	105322	181478	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1400 Sunset Blvd	38	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984917.9059	2105334.1509	37.759974004815795	-122.495270136852	(37.7599740048158, -122.495270136852)
44202	44202	186673	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1401 Sunset Blvd	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984739.5822	2105465.3048	37.7603236745559	-122.495896538326	(37.7603236745559, -122.495896538326)
74058	74058	186679	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1401 Sunset Blvd	36	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984735.2903	2105403.2290000003	37.760152980386	-122.495906802394	(37.760152980386, -122.495906802394)
156845	156845	186677	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1401 Sunset Blvd	34	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984721.4724	2105427.5149	37.760218853394605	-122.49595638286101	(37.7602188533946, -122.495956382861)
177279	177279	186668	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1401 Sunset Blvd	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984695.4068	2105524.4495	37.7604834820457	-122.49605368158001	(37.7604834820457, -122.49605368158)
183935	183935	186666	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1401 Sunset Blvd	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984702.5251	2105541.6172	37.76053103667871	-122.49603032958001	(37.7605310366787, -122.49603032958)
102307	102307	99256	Property Tree 7	Sequoia sempervirens :: Coast Redwood 116	1466 York St		Back Yard : Yard 13	Tree 1	Private 1						6010099.0	2100741.0	37.7488043872035	-122.407856595429	(37.7488043872035, -122.407856595429)
137793	137793	53580	Permitted Site 1	Sequoia sempervirens :: Coast Redwood 116	148 06th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/15/1973 12:00:00 AM	34		Permit Number 12426	5993993.6857199995	2114568.59854	37.7858565385613	-122.46455217907699	(37.7858565385613, -122.464552179077)
41346	41346	181435	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1500 Sunset Blvd	68	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984924.5894	2104933.1403	37.7588733327201	-122.495217449651	(37.7588733327201, -122.495217449651)
48439	48439	181387	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1500 Sunset Blvd	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984939.8638	2104520.2223	37.757740468934294	-122.495134175513	(37.7577404689343, -122.495134175513)
64455	64455	181395	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1500 Sunset Blvd	28	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984933.1803	2104579.26	37.7579021787746	-122.495161642957	(37.7579021787746, -122.495161642957)
136288	136288	181391	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1500 Sunset Blvd	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984921.4841	2104558.6525	37.757844911537	-122.495200573085	(37.757844911537, -122.495200573085)
184520	184520	181386	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1500 Sunset Blvd	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984899.2058	2104514.6528	37.757722796238106	-122.495274374844	(37.7577227962381, -122.495274374844)
47580	47580	186579	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1501 Sunset Blvd	50	unknown : Yard 19	Tree 1	Private 1			1	Width 0ft		5984739.2681	2104595.0921	37.7579342947119	-122.495833430643	(37.7579342947119, -122.495833430643)
75550	75550	186581	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1501 Sunset Blvd	52	unknown : Yard 19	Tree 1	Private 1			2	Width 0ft		5984771.5099	2104576.6683	37.75788559627829	-122.495720567601	(37.7578855962783, -122.495720567601)
162095	162095	184091	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1600 Sunset Blvd	94	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984954.5787	2104192.9608	37.756842761121895	-122.495059154794	(37.7568427611219, -122.495059154794)
36125	36125	186472	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1601 Sunset Blvd	60	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984790.3524	2103740.0582	37.755589600564704	-122.495593697553	(37.7555896005647, -122.495593697553)
163436	163436	186481	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1601 Sunset Blvd	69	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984737.1745	2103681.0182	37.7554243789331	-122.495773245735	(37.7554243789331, -122.495773245735)
172139	172139	186477	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	1601 Sunset Blvd	65	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5984748.0613	2103717.4471	37.7555250401648	-122.49573828341299	(37.7555250401648, -122.495738283413)
102600	102600	106362	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	1645 WEBSTER ST	1	Front Yard : Yard 7	Tree 1	Private 1			12			6003301.2	2114333.7	37.7857437219688	-122.432334009178	(37.7857437219688, -122.432334009178)
125999	125999	106361	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	1645 WEBSTER ST	2	Front Yard : Yard 7	Tree 1	Private 1			30			6003301.2	2114333.7	37.7857437219688	-122.432334009178	(37.7857437219688, -122.432334009178)
22599	22599	2580	Permitted Site 1	Sequoia sempervirens :: Coast Redwood 116	1668 Bush St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	4X4		6005450.60125	2115176.6463599997	37.7881798837348	-122.424957678647	(37.7881798837348, -122.424957678647)
46422	46422	248058	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	17 Rutledge St	4	Side Yard : Yard 17	Tree 1	Private 1			5			6010687.47782	2099346.1468700003	37.7450073524216	-122.405723395139	(37.7450073524216, -122.405723395139)
114761	114761	112559	Significant Tree 6	Sequoia sempervirens :: Coast Redwood 116	1735x GRANT AVE	1	Back Yard : Yard 13	Tree 1	Private 1						6010373.0	2120454.0	37.8029470287696	-122.40829930674299	(37.8029470287696, -122.408299306743)
38662	38662	215039	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	179 Ashton Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			32			5994134.23715	2091156.84385	37.721581958319504	-122.462367242757	(37.7215819583195, -122.462367242757)
65505	65505	248066	Undocumented 2	Sequoia sempervirens :: Coast Redwood 116	18 Rutledge St	8	Side Yard : Yard 17	Tree 1	Private 1			7			6010646.65948	2099397.14706	37.7451451051559	-122.405868130216	(37.7451451051559, -122.405868130216)

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