Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 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, qCareAssistant, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress ▼	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
40050	40050	176160	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	0 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			5990378.89561	2089837.21304	37.7177416175535	-122.47525201947701	(37.7177416175535, -122.475252019477)
175601	175601	176161	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	0 Gonzalez Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			5990361.86615	2090050.7376	37.718326916127204	-122.475326462647	(37.7183269161272, -122.475326462647)
183376	183376	176159	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	0 Serrano Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2			5989661.71527	2090692.2421799998	37.720047719404	-122.477793431626	(37.720047719404, -122.477793431626)
130707	130707	190965	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 24th St	17	: Yard 23	Tree 1	Private 1			6			6017293.94065	2102634.4333599997	37.754403540203796	-122.38310803210899	(37.7544035402038, -122.383108032109)
164784	164784	246716	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Bonview St	22	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			45			6007832.06726	2099366.51815	37.744903194719704	-122.415598362177	(37.7449031947197, -122.415598362177)
166002	166002	246711	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Bonview St	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			15			6007747.55824	2099198.25056	37.7444364187148	-122.415878666471	(37.7444364187148, -122.415878666471)
139692	139692	99826	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	1 Cascade Walk	1	Front Yard : Yard 7	Tree 1	Private 1						5992183.1	2103187.3	37.7545020044945	-122.469987253468	(37.7545020044945, -122.469987253468)
44565	44565	201717	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Hawkins Ln	2	Side Yard : Yard 17	Tree 1	Private 1			24			6017089.1408	2095350.86435	37.7343930239173	-122.38330932287201	(37.7343930239173, -122.383309322872)
51235	51235	201716	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Hawkins Ln	1	Side Yard : Yard 17	Tree 1	Private 1			17			6017085.9132900005	2095352.6498	37.7343977480421	-122.38332060578001	(37.7343977480421, -122.38332060578)
55847	55847	201720	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Hawkins Ln	5	Side Yard : Yard 17	Tree 1	Private 1			17			6017109.38533	2095355.2358400002	37.734406145933704	-122.383239634411	(37.7344061459337, -122.383239634411)
58146	58146	201718	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Hawkins Ln	3	Side Yard : Yard 17	Tree 1	Private 1			14			6017093.28201	2095356.3247099998	37.7344082458391	-122.38329538517401	(37.7344082458391, -122.383295385174)
65706	65706	201723	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Hawkins Ln	6	Side Yard : Yard 17	Tree 1	Private 1			10			6017160.60225	2095378.34378	37.734472425960895	-122.383064166774	(37.7344724259609, -122.383064166774)
146514	146514	201719	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Hawkins Ln	4	Side Yard : Yard 17	Tree 1	Private 1			15			6017095.79964	2095357.4210400002	37.7344113952763	-122.38328675710501	(37.7344113952763, -122.383286757105)
167728	167728	201724	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Hawkins Ln	7	Side Yard : Yard 17	Tree 1	Private 1			28			6017165.24184	2095383.9343	37.7344880327856	-122.383048514986	(37.7344880327856, -122.383048514986)
4884	4884	253710	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	4	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
4891	4891	253709	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	3	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
4893	4893	253707	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	1	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
4898	4898	253711	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	5	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
4906	4906	253708	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Monument Way	2	Unaccepted Street : Yard 14	Tree 1	Private 1				10x10		5999088.0	2105836.0	37.7621714109075	-122.446298918118	(37.7621714109075, -122.446298918118)
44939	44939	223816	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Ohlone Way	1	Back Yard : Yard 13	Tree 1	Private 1			45	Width 5ft		6002135.08017	2096585.1811900001	37.7369444095655	-122.435098574335	(37.7369444095655, -122.435098574335)
26075	26075	206897	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Pizarro Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5995088.9482	2093956.7124599998	37.729324653504	-122.459269738418	(37.729324653504, -122.459269738418)
76009	76009	206898	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Pizarro Way	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5995090.77505	2093954.0978400002	37.7293175794217	-122.459263233611	(37.7293175794217, -122.459263233611)
130353	130353	206896	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Pizarro Way	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5995094.72754	2093951.90742	37.729311792297395	-122.459249411033	(37.7293117922974, -122.459249411033)
182357	182357	206895	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Pizarro Way	9	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5995113.71049	2093937.45787	37.729273208687204	-122.459182739799	(37.7292732086872, -122.459182739799)
68489	68489	176113	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Santa Barbara Ave	5	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 8ft		5993424.30452	2086604.0814	37.709040256765	-122.464490865868	(37.709040256765, -122.464490865868)
49019	49019	217851	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Woodacre Dr	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			5991372.3988	2095655.7532099998	37.7337754172003	-122.47224186449301	(37.7337754172003, -122.472241864493)
51562	51562	218296	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Woodacre Dr	20	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			38			5991178.95125	2095337.5178200002	37.732890425845106	-122.47288746619499	(37.7328904258451, -122.472887466195)
65855	65855	217846	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Woodacre Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			54			5991427.317980001	2095733.50913	37.733992093541396	-122.47205765993601	(37.7339920935414, -122.472057659936)
136840	136840	217847	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Woodacre Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			33			5991420.07679	2095725.93853	37.7339708875491	-122.472082143088	(37.7339708875491, -122.472082143088)
175849	175849	218295	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1 Woodacre Dr	19	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			40			5991182.782880001	2095348.63112	37.7329211619833	-122.47287502947701	(37.7329211619833, -122.472875029477)
136019	136019	206848	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Brotherhood Way	3	: 4	Tree 1	Private 1			11	Width 0ft		5993673.9414	2087579.0167599998	37.7117315859181	-122.46369880328001	(37.7117315859181, -122.46369880328)
137802	137802	206847	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Brotherhood Way	2	: 4	Tree 1	Private 1			16	Width 0ft		5993688.70591	2087590.2808700001	37.711763365253894	-122.463648590504	(37.7117633652539, -122.463648590504)
156086	156086	206846	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Brotherhood Way	1	: 4	Tree 1	Private 1			25	Width 0ft		5993694.0595	2087568.4676400002	37.7117037797802	-122.463628505047	(37.7117037797802, -122.463628505047)
30768	30768	223720	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Crescent Ave	3	Side Yard : Yard 17	Tree 1	Private 1			15	Width 3ft		6005295.72226	2095902.89747	37.7352499770995	-122.424122309196	(37.7352499770995, -122.424122309196)
67552	67552	223719	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Crescent Ave	4	Side Yard : Yard 17	Tree 1	Private 1			6	Width 3ft		6005300.64092	2095902.62438	37.735249504969104	-122.424105284154	(37.7352495049691, -122.424105284154)
35639	35639	176145	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	6	: 4	Tree 1	Private 1			41	Width 0ft		5987592.83524	2090286.1257900002	37.7188123395933	-122.484914976763	(37.7188123395933, -122.484914976763)
38808	38808	176142	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	2	: 4	Tree 1	Private 1			38	Width 0ft		5987571.34971	2089706.0579	37.7172183686082	-122.48494670935	(37.7172183686082, -122.48494670935)
44967	44967	176143	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	4	: 4	Tree 1	Private 1			60	Width 0ft		5987585.53383	2089941.9294099999	37.7178668382624	-122.48491497676201	(37.7178668382624, -122.484914976762)
45769	45769	176148	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	9	: 4	Tree 1	Private 1			34	Width 0ft		5987583.49684	2090495.06547	37.7193854910228	-122.484962576086	(37.7193854910228, -122.484962576086)
46715	46715	176139	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	2	: 4	Tree 1	Private 1			10	Width 0ft		5987453.25598	2088569.38174	37.714090463565796	-122.485271539962	(37.7140904635658, -122.485271539962)
49614	49614	176138	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	1	: 4	Tree 1	Private 1			16	Width 0ft		5987453.76086	2088540.35852	37.714010802520704	-122.485267666593	(37.7140108025207, -122.485267666593)
67783	67783	176150	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	11	: 4	Tree 1	Private 1			36	Width 0ft		5987592.48981	2090630.47985	37.7197578283347	-122.484941420412	(37.7197578283347, -122.484941420412)
71082	71082	176144	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	5	: 4	Tree 1	Private 1			39	Width 0ft		5987593.26623	2090234.31177	37.7186700965335	-122.484909687836	(37.7186700965335, -122.484909687836)
72073	72073	176140	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	3	: 4	Tree 1	Private 1			15	Width 0ft		5987455.898580001	2088588.29538	37.7141425496068	-122.48526379321501	(37.7141425496068, -122.485263793215)
136102	136102	176147	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	8	: 4	Tree 1	Private 1			40	Width 0ft		5987595.02111	2090461.3006400003	37.7192934526127	-122.484920265678	(37.7192934526127, -122.484920265678)
149666	149666	176149	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	10	: 4	Tree 1	Private 1			58	Width 0ft		5987588.89275	2090533.04242	37.7194900803794	-122.48494670933998	(37.7194900803794, -122.48494670934)
171157	171157	176146	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	7	: 4	Tree 1	Private 1			40	Width 0ft		5987590.810219999	2090334.9259400002	37.7189462144818	-122.48492555458999	(37.7189462144818, -122.48492555459)
174101	174101	176141	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	1	: 4	Tree 1	Private 1			48	Width 0ft		5987562.65817	2089512.7313599999	37.7166870365437	-122.484962576069	(37.7166870365437, -122.484962576069)
184095	184095	176151	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Lake Merced Blvd	12	: 4	Tree 1	Private 1			28	Width 0ft		5987601.77319	2090779.60025	37.7201678157831	-122.484920265686	(37.7201678157831, -122.484920265686)
119121	119121	176115	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Skyline Blvd	1	: 4	Tree 1	Private 1			8	Width 0ft		5982387.31367	2092831.90061	37.7254977881756	-122.503096467121	(37.7254977881756, -122.503096467121)
178699	178699	176116	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Skyline Blvd	2	: 4	Tree 1	Private 1			9	Width 0ft		5982365.02042	2092827.7229400002	37.725485007020296	-122.503173222486	(37.7254850070203, -122.503173222486)
60160	60160	223790	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Storrie St	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			6	Width 3ft		6000695.90206	2105313.46128	37.7608283472609	-122.44070032905701	(37.7608283472609, -122.440700329057)
62231	62231	176114	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Zoo Rd	1	Front Yard : Yard 7	Tree 1	Private 1			24	Width 10ft		5982696.49512	2094384.4536	37.729778850703894	-122.502142508582	(37.7297788507039, -122.502142508582)
113837	113837	116669	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 Esmeralda Ave	6	Unaccepted Street : Yard 14	Tree 1	DPW 2			20			6006917.389830001	2098966.37493	37.7437530336215	-122.41873278303999	(37.7437530336215, -122.41873278304)
131331	131331	206802	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	100 Judah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			13	Width 1ft		5994234.49251	2106025.56842	37.762413528276205	-122.463098978843	(37.7624135282762, -122.463098978843)
110956	110956	118356	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	100 RACCOON DR	2	Back Yard : Cutout 16	Tree 1	Private 1			48			5998776.0	2103987.0	37.7570766935068	-122.44724492231701	(37.7570766935068, -122.447244922317)
5091	5091	253769	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	100 Raccoon Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5998692.0	2104165.0	37.7575606372552	-122.44754823773899	(37.7575606372552, -122.447548237739)
5096	5096	253768	Property Tree 7	Cupressus macrocarpa :: Monterey Cypress 47	100 Raccoon Dr	1	Back Yard : Yard 13	Tree 1	Private 1						5998692.0	2104165.0	37.7575606372552	-122.44754823773899	(37.7575606372552, -122.447548237739)
886	886	19568	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
6533	6533	19565	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	-11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	100ST
8903	8903	19566	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	-9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	100ST
10571	10571	19570	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
10705	10705	19569	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY1	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	100ST
7938	7938	19700	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY11	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	40ST
15767	15767	19699	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY11	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	40ST
13158	13158	19753	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY15	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
5855	5855	19776	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY18	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	50ST
9072	9072	19804	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY22	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	20
14206	14206	19813	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY24	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
12151	12151	19869	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY33	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	25ST
6023	6023	19905	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
6147	6147	19906	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
6517	6517	19907	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
10816	10816	19910	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
15771	15771	19908	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	120ST
16878	16878	19909	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY35	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	120ST
6952	6952	19935	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
10674	10674	19936	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
10949	10949	19933	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
14400	14400	19934	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
14992	14992	19932	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
15978	15978	19943	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY38	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10ST
6834	6834	19955	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	2ST
7732	7732	19948	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	25ST
7886	7886	19945	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	25ST
11220	11220	19950	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
12812	12812	19953	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
16424	16424	19949	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	25ST
16608	16608	19951	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	25ST
16721	16721	19947	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY39	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	25ST
17092	17092	19978	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY45	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	30ST
13184	13184	20013	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY47	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	100ST
14425	14425	19694	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	100 STAIRWAY7	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	12ST
42268	42268	53726	Permitted Site 1	Cupressus macrocarpa :: Monterey Cypress 47	100 Topeka Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/07/1972 12:00:00 AM	8		Permit Number 9405	6012451.87174	2095251.14558	37.733861851932296	-122.399334980939	(37.7338618519323, -122.399334980939)
185031	185031	190987	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	100 Topeka Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8	Width 5ft		6012468.98817	2095242.94143	37.7338402790006	-122.39927522817	(37.7338402790006, -122.39927522817)
123752	123752	95982	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	100 Vasquez Ave	1	Back Yard : Yard 13	Tree 1	Private 1						5995122.4	2099706.3	37.7451135296363	-122.459570350972	(37.7451135296363, -122.459570350972)
122936	122936	107159	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	1000 ESMERALDA AVE		Front Yard : Yard 7	Tree 1	Private 1						6009839.0	2098688.0	37.7431527400861	-122.408610872619	(37.7431527400861, -122.408610872619)
1822	1822	251717	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1000X San Jose Ave	1	Front Yard : Yard 7	Tree 1	DPW 2						6004710.0	2096486.0	37.736817957153605	-122.426188866367	(37.7368179571536, -122.426188866367)
50101	50101	121189	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	1000x Duncan St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Permit Number 775289	5999834.0	2099740.0	37.7454758595085	-122.44328093408899	(37.7454758595085, -122.443280934089)
145554	145554	121180	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	1000x Duncan St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5999834.0	2099740.0	37.7454758595085	-122.44328093408899	(37.7454758595085, -122.443280934089)

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