Street_Tree_List

Data source: data.sfgov.org

1,505 rows where qSiteInfo = 3 sorted by SiteOrder descending

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
76485	76485	197585	DPW Maintained 3	Sequoia sempervirens :: Coast Redwood 116	900x Carolina St	75	Median : Yard 3	Tree 1	DPW 2			27			6012517.30691	2102783.51804	37.7545477896502	-122.399637433715	(37.7545477896502, -122.399637433715)
35348	35348	194039	DPW Maintained 3	Myoporum laetum :: Myoporum 1	900x Carolina St	74	Median : Yard 3	Tree 1	DPW 2			38			6012510.33858	2102789.20195	37.754563007990896	-122.399661931254	(37.7545630079909, -122.399661931254)
32869	32869	189966	DPW Maintained 3	Cercis canadensis :: Eastern Redbud 299	900x Carolina St	73	Median : Yard 3	Tree 1	DPW 2			1			6012515.82864	2102790.5172099997	37.754566925442795	-122.39964303739201	(37.7545669254428, -122.399643037392)
26840	26840	194523	DPW Maintained 3	Pinus thunbergii :: Japanese Black Pine 306	900x Carolina St	72	Median : Yard 3	Tree 1	DPW 2			3			6012512.869530001	2102814.17539	37.7546317206991	-122.399654931846	(37.7546317206991, -122.399654931846)
56546	56546	190677	DPW Maintained 3	Ilex spp :: Holly Species 163	900x Carolina St	71	Median : Yard 3	Tree 1	DPW 2			7			6012520.45276	2102813.85342	37.7546312593522	-122.39962868423201	(37.7546312593522, -122.399628684232)
61087	61087	190918	DPW Maintained 3	Cotoneaster SPP :: Cotoneaster 234	900x Carolina St	70	Median : Yard 3	Tree 1	DPW 2			21			6012519.44645	2102822.4393700003	37.754654778405296	-122.399632767143	(37.7546547784053, -122.399632767143)
46296	46296	194557	DPW Maintained 3	Pittosporum crassifolium :: Karo Tree 108	900x Carolina St	69	Median : Yard 3	Tree 1	DPW 2			11			6012516.26815	2102828.89594	37.7546723295715	-122.39964421193301	(37.7546723295715, -122.399644211933)
63254	63254	190917	DPW Maintained 3	Cotoneaster SPP :: Cotoneaster 234	900x Carolina St	68	Median : Yard 3	Tree 1	DPW 2			8			6012519.74637	2102837.21301	37.7546953603194	-122.399632767155	(37.7546953603194, -122.399632767155)
24818	24818	191371	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	900x Carolina St	66	Median : Yard 3	Tree 1	DPW 2			13			6012518.79145	2102845.53786	37.7547181653131	-122.39963665401699	(37.7547181653131, -122.399636654017)
49522	49522	193547	DPW Maintained 3	Melaleuca nesophila :: Pink Melaleuca 93	900x Carolina St	65	Median : Yard 3	Tree 1	DPW 2			11			6012516.839980001	2102871.66546	37.7547897972265	-122.39964523714501	(37.7547897972265, -122.399645237145)
157954	157954	194432	DPW Maintained 3	Pinus Spp :: Pine Spp 105	900x Carolina St	64	Median : Yard 3	Tree 1	DPW 2			17			6012507.9331	2102881.1831400003	37.754815434199	-122.39967670801599	(37.754815434199, -122.399676708016)
27702	27702	191370	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	900x Carolina St	63	Median : Yard 3	Tree 1	DPW 2			15			6012517.15762	2102887.31193	37.75483277672829	-122.399645237162	(37.7548327767283, -122.399645237162)
1052	1052	187279	DPW Maintained 3	Pinus Spp :: Pine Spp 105	2401 Sunset Blvd	62	Median : Yard 3	Tree 1	DPW 2			4	Width 0ft		5984952.4466	2098301.7622	37.7406670151021	-122.494632227246	(37.7406670151021, -122.494632227246)
38640	38640	191369	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	900x Carolina St	62	Median : Yard 3	Tree 1	DPW 2			15			6012514.91638	2102899.16549	37.7548651990855	-122.399653820263	(37.7548651990855, -122.399653820263)
184948	184948	190916	DPW Maintained 3	Cotoneaster SPP :: Cotoneaster 234	900x Carolina St	61	Median : Yard 3	Tree 1	DPW 2			12			6012503.648130001	2102901.04205	37.754869723572895	-122.39969292101601	(37.7548697235729, -122.399692921016)
76494	76494	233314	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	5200x Diamond Heights Blvd	60	Median : Yard 3	Tree 1	DPW 2			23			6001944.7696	2098445.7713	37.742042348782	-122.43588965038299	(37.742042348782, -122.435889650383)
131762	131762	191368	DPW Maintained 3	Leptospermum laevigatum :: Australian Tea Tree 38	900x Carolina St	60	Median : Yard 3	Tree 1	DPW 2			25			6012502.16132	2102909.3105599997	37.7548923442165	-122.399698643387	(37.7548923442165, -122.399698643387)
147407	147407	188588	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	900x Carolina St	57	Median : Yard 3	Tree 1	DPW 2			13			6012513.0739	2102944.23906	37.754988858573	-122.399663356681	(37.754988858573, -122.399663356681)
40612	40612	193546	DPW Maintained 3	Melaleuca nesophila :: Pink Melaleuca 93	900x Carolina St	56	Median : Yard 3	Tree 1	DPW 2			14			6012511.31155	2102952.5131599996	37.7550114792069	-122.39967003234699	(37.7550114792069, -122.399670032347)
64773	64773	199615	DPW Maintained 3	Yucca gloriosa :: Spanish Dagger 224	1700x Quesada Ave	56	Median : Yard 3	Tree 1	DPW 2			20			6014226.56708	2095397.2747900002	37.734361844424704	-122.393209497917	(37.7343618444247, -122.393209497917)
60406	60406	194760	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	1700x Quesada Ave	55	Median : Yard 3	Tree 1	DPW 2			6			6014240.46002	2095410.02862	37.734397635636796	-122.393162357259	(37.7343976356368, -122.393162357259)
63150	63150	188587	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	900x Carolina St	55	Median : Yard 3	Tree 1	DPW 2			16			6012500.08207	2102956.31087	37.7550212809088	-122.399709133985	(37.7550212809088, -122.399709133985)
146893	146893	188542	DPW Maintained 3	Acacia longifolia :: Golden Wattle 140	900x Carolina St	54	Median : Yard 3	Tree 1	DPW 2			16			6012509.86374	2102962.70315	37.75503937799	-122.39967575475401	(37.75503937799, -122.399675754754)
149667	149667	199513	DPW Maintained 3	Yucca elephantipes :: Giant Yucca 211	1700x Quesada Ave	54	Median : Yard 3	Tree 1	DPW 2			22			6014249.11151	2095406.32317	37.7343879418434	-122.39313218680901	(37.7343879418434, -122.393132186809)
63803	63803	199614	DPW Maintained 3	Yucca gloriosa :: Spanish Dagger 224	1700x Quesada Ave	53	Median : Yard 3	Tree 1	DPW 2			16			6014257.65945	2095401.98638	37.734376508759496	-122.39310233021601	(37.7343765087595, -122.393102330216)
64729	64729	194038	DPW Maintained 3	Myoporum laetum :: Myoporum 1	900x Carolina St	53	Median : Yard 3	Tree 1	DPW 2			7			6012502.8583	2102970.8089	37.7550612440971	-122.39970055084	(37.7550612440971, -122.39970055084)
25922	25922	197195	DPW Maintained 3	Quercus agrifolia :: Coast Live Oak 180	1700x Quesada Ave	52	Median : Yard 3	Tree 1	DPW 2			5			6014229.96459	2095381.0032900001	37.734317354963395	-122.393196613328	(37.7343173549634, -122.393196613328)
133957	133957	197354	DPW Maintained 3	Rhamnus californica :: Coffeeberry Tree 232	900x Carolina St	52	Median : Yard 3	Tree 1	DPW 2			3			6012496.37101	2102977.25667	37.755078586631996	-122.39972343860701	(37.755078586632, -122.399723438607)
175803	175803	129354	DPW Maintained 3	Juniperus chinensis :: Juniper 19	1306x Montgomery St	52	Median : Yard 3	Tree 1	DPW 2			14	Width 8ft		6011388.89614	2120338.61388	37.8026870410416	-122.40477563290199	(37.8026870410416, -122.404775632902)
34339	34339	194442	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	900x Carolina St	51	Median : Yard 3	Tree 1	DPW 2			24			6012500.2858	2102979.92319	37.7550861265451	-122.39971008726499	(37.7550861265451, -122.399710087265)
72616	72616	188650	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	1700x Quesada Ave	51	Median : Yard 3	Tree 1	DPW 2			8			6014234.97615	2095377.1002900002	37.734306916536	-122.39317901359699	(37.734306916536, -122.393179013597)
75147	75147	129353	DPW Maintained 3	Juniperus chinensis :: Juniper 19	1306x Montgomery St	51	Median : Yard 3	Tree 1	DPW 2			6	Width 8ft		6011391.406830001	2120329.06369	37.8026609588854	-122.404766271855	(37.8026609588854, -122.404766271855)
59430	59430	201075	DPW Maintained 3	Lophostemon confertus :: Brisbane Box 11	900x Carolina St	50	Median : Yard 3	Tree 1	DPW 2			10			6012500.47255	2103002.7121099997	37.755148710357396	-122.39971104145599	(37.7551487103574, -122.399711041456)
69580	69580	188649	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	1700x Quesada Ave	50	Median : Yard 3	Tree 1	DPW 2			3	Width 7ft		6014280.17751	2095342.33163	37.734213959905205	-122.393020304839	(37.7342139599052, -122.393020304839)
133038	133038	125868	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	1306x Montgomery St	50	Median : Yard 3	Tree 1	DPW 2			9	Width 8ft		6011397.07627	2120306.83138	37.80260023127779	-122.404745086537	(37.8026002312778, -122.404745086537)
54350	54350	194294	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	49	Median : Yard 3	Tree 1	DPW 2			27			6014297.19865	2095334.47415	37.7341933303645	-122.392960907318	(37.7341933303645, -122.392960907318)
131510	131510	125867	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	1306x Montgomery St	49	Median : Yard 3	Tree 1	DPW 2			7	Width 8ft		6011400.22925	2120293.8654	37.802564806093294	-122.40473326224199	(37.8025648060933, -122.404733262242)
34583	34583	197479	DPW Maintained 3	Schefflera species :: Umbrella tree 386	1700x Quesada Ave	48	Median : Yard 3	Tree 1	DPW 2			4			6014300.68484	2095327.0716	37.734173198123706	-122.392948336615	(37.7341731981237, -122.392948336615)
62551	62551	223750	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	5200x Diamond Heights Blvd	48	Median : Yard 3	Tree 1	DPW 2			49			6001781.7092699995	2098716.14984	37.7427754806136	-122.436472807673	(37.7427754806136, -122.436472807673)
73337	73337	125866	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	1306x Montgomery St	48	Median : Yard 3	Tree 1	DPW 2			6	Width 8ft		6011400.87154	2120290.44992	37.802555463919	-122.40473079899401	(37.802555463919, -122.404730798994)
135280	135280	190915	DPW Maintained 3	Cotoneaster SPP :: Cotoneaster 234	900x Carolina St	48	Median : Yard 3	Tree 1	DPW 2			10			6012505.66859	2103014.14021	37.7551803790787	-122.399693874288	(37.7551803790787, -122.399693874288)
27563	27563	197474	DPW Maintained 3	Salix matsudana 'Tortuosa' :: Corkscrew Willow 228	1700x Quesada Ave	47	Median : Yard 3	Tree 1	DPW 2			9			6014305.55494	2095325.1628400001	37.7341682275767	-122.392931365507	(37.7341682275767, -122.392931365507)
47847	47847	125865	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	1306x Montgomery St	47	Median : Yard 3	Tree 1	DPW 2			8	Width 8ft		6011401.82838	2120281.49833	37.8025309385205	-122.404726857271	(37.8025309385205, -122.404726857271)
27594	27594	194293	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	46	Median : Yard 3	Tree 1	DPW 2			28			6014318.796490001	2095319.19207	37.7341525685742	-122.392885167337	(37.7341525685742, -122.392885167337)
131755	131755	125864	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	1306x Montgomery St	46	Median : Yard 3	Tree 1	DPW 2			11	Width 8ft		6011404.31889	2120270.9561400004	37.8025021314422	-122.404717496217	(37.8025021314422, -122.404717496217)
60973	60973	211136	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	335x Pacheco St	45	Median : Yard 3	Tree 1	DPW 2			40	Width 8ft		5993981.68965	2101619.35066	37.750300623474295	-122.463653516122	(37.7503006234743, -122.463653516122)
146596	146596	188586	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	900x Carolina St	45	Median : Yard 3	Tree 1	DPW 2			18			6012501.01622	2103043.06832	37.755259550009896	-122.399711994725	(37.7552595500099, -122.399711994725)
163136	163136	129352	DPW Maintained 3	Juniperus chinensis :: Juniper 19	1306x Montgomery St	45	Median : Yard 3	Tree 1	DPW 2			3	Width 8ft		6011406.69978	2120255.02893	37.8024585322873	-122.404708135188	(37.8024585322873, -122.404708135188)
25391	25391	132190	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306x Montgomery St	44	Median : Yard 3	Tree 1	DPW 2			15	Width 8ft		6011409.46246	2120250.86119	37.802447243101	-122.40469828132	(37.802447243101, -122.40469828132)
57952	57952	211135	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	335x Pacheco St	44	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		5993997.61305	2101611.2464400004	37.750279288862295	-122.463597864272	(37.7502792888623, -122.463597864272)
63255	63255	191046	DPW Maintained 3	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	900x Carolina St	44	Median : Yard 3	Tree 1	DPW 2			6			6012503.19406	2103068.83729	37.7553304273806	-122.399706272322	(37.7553304273806, -122.399706272322)
70532	70532	190081	DPW Maintained 3	Citrus spp :: Lemon: Orange: Lime 278	1700x Quesada Ave	44	Median : Yard 3	Tree 1	DPW 2			4			6014340.94145	2095303.98967	37.734112055908604	-122.392807541432	(37.7341120559086, -122.392807541432)
150369	150369	232589	DPW Maintained 3	Metrosideros excelsa :: New Zealand Xmas Tree 2	5200x Diamond Heights Blvd	44	Median : Yard 3	Tree 1	DPW 2			18			6001728.28871	2098778.49055	37.7429436178674	-122.436661981881	(37.7429436178674, -122.436661981881)
27134	27134	194292	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	43	Median : Yard 3	Tree 1	DPW 2			38			6014354.24031	2095291.86255	37.734079495961396	-122.392760714642	(37.7340794959614, -122.392760714642)
31535	31535	194476	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	900x Carolina St	43	Median : Yard 3	Tree 1	DPW 2			22			6012491.75598	2103075.9348299997	37.755349278054	-122.39974632722799	(37.755349278054, -122.399746327228)
56827	56827	132189	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306x Montgomery St	43	Median : Yard 3	Tree 1	DPW 2			12	Width 8ft		6011411.367980001	2120233.14388	37.802398702198204	-122.404690439238	(37.8023987021982, -122.404690439238)
76417	76417	210902	DPW Maintained 3	Persea indica :: Indian Bay 214	200x Terrace Dr	43	Median : Yard 3	Tree 1	DPW 2			9			5993874.816459999	2096520.07215	37.736293128612296	-122.463653037673	(37.7362931286123, -122.463653037673)
164069	164069	206833	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	43	Median : Yard 3	Tree 1	DPW 2			38	Width 8ft		5994013.170390001	2101597.32245	37.7502419535254	-122.463543055991	(37.7502419535254, -122.463543055991)
166635	166635	232588	DPW Maintained 3	Metrosideros excelsa :: New Zealand Xmas Tree 2	5200x Diamond Heights Blvd	43	Median : Yard 3	Tree 1	DPW 2			59			6001719.64568	2098775.96763	37.742936199339795	-122.436691686488	(37.7429361993398, -122.436691686488)
32653	32653	194410	DPW Maintained 3	Photinia fraseri :: Photinia: Chinese photinia 104	1700x Quesada Ave	42	Median : Yard 3	Tree 1	DPW 2			2			6014359.990180001	2095279.52622	37.7340459422739	-122.39273997266899	(37.7340459422739, -122.392739972669)
60923	60923	132188	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306x Montgomery St	42	Median : Yard 3	Tree 1	DPW 2			17	Width 8ft		6011420.08981	2120201.09522	37.802311191872896	-122.404657999787	(37.8023111918729, -122.404657999787)
134096	134096	211134	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	335x Pacheco St	42	Median : Yard 3	Tree 1	DPW 2			5	Width 8ft		5994034.9226400005	2101588.12447	37.7502179515095	-122.463467168477	(37.7502179515095, -122.463467168477)
162994	162994	188866	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	900x Carolina St	42	Median : Yard 3	Tree 1	DPW 2			9			6012505.62203	2103079.77232	37.7553605879327	-122.39969864337499	(37.7553605879327, -122.399698643375)
177543	177543	214300	DPW Maintained 3	Prunus cerasifera :: Cherry Plum 16	200x Terrace Dr	42	Median : Yard 3	Tree 1	DPW 2			17			5993888.01583	2096515.6983900003	37.7362818799091	-122.46360708499701	(37.7362818799091, -122.463607084997)
187030	187030	240286	DPW Maintained 3	Quercus agrifolia :: Coast Live Oak 180	5200x Diamond Heights Blvd	42	Median : Yard 3	Tree 1	DPW 2			2			6001709.51148	2098788.78469	37.742970816043204	-122.436727644972	(37.7429708160432, -122.436727644972)
30436	30436	203829	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	200x Terrace Dr	41	Median : Yard 3	Tree 1	DPW 2			18			5993865.8273	2096513.9581	37.7362758229773	-122.463683673072	(37.7362758229773, -122.463683673072)
36478	36478	133192	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	1306x Montgomery St	41	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		6011420.83782	2120184.50099	37.8022656699768	-122.404654242423	(37.8022656699768, -122.404654242423)
54354	54354	194291	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	41	Median : Yard 3	Tree 1	DPW 2			38			6014364.32912	2095287.3135099998	37.7340675655682	-122.39272551607701	(37.7340675655682, -122.392725516077)
102681	102681	206832	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	41	Median : Yard 3	Tree 1	DPW 2			52	Width 8ft		5994051.70376	2101574.41752	37.750181282555	-122.463408144182	(37.750181282555, -122.463408144182)
137392	137392	233313	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	5200x Diamond Heights Blvd	41	Median : Yard 3	Tree 1	DPW 2			31			6001700.69582	2098799.77338	37.743000487396294	-122.436758913492	(37.7430004873963, -122.436758913492)
150115	150115	188865	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	900x Carolina St	41	Median : Yard 3	Tree 1	DPW 2			12			6012505.22674	2103087.46941	37.7553817004262	-122.39970055083401	(37.7553817004262, -122.399700550834)
45589	45589	191045	DPW Maintained 3	Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197	900x Carolina St	40	Median : Yard 3	Tree 1	DPW 2			7			6012497.15794	2103097.51934	37.755408845542895	-122.399729160991	(37.7554088455429, -122.399729160991)
46004	46004	212540	DPW Maintained 3	Prunus cerasifera :: Cherry Plum 16	200x Terrace Dr	40	Median : Yard 3	Tree 1	DPW 2			4			5993897.21452	2096501.63961	37.7362438080119	-122.46357426156	(37.7362438080119, -122.46357426156)
56747	56747	132187	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	1306x Montgomery St	40	Median : Yard 3	Tree 1	DPW 2			14	Width 8ft		6011421.2833	2120182.68985	37.8022607219264	-122.404652573264	(37.8022607219264, -122.404652573264)
70141	70141	194290	DPW Maintained 3	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	40	Median : Yard 3	Tree 1	DPW 2			27			6014381.3022300005	2095272.57767	37.7340280466394	-122.39266580380101	(37.7340280466394, -122.392665803801)
73708	73708	211133	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	335x Pacheco St	40	Median : Yard 3	Tree 1	DPW 2			6	Width 8ft		5994061.05133	2101566.69435	37.750160615241704	-122.46337525958	(37.7501606152417, -122.46337525958)
28399	28399	211132	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	335x Pacheco St	39	Median : Yard 3	Tree 1	DPW 2			13	Width 8ft		5994073.5471	2101557.9336599996	37.750137280527	-122.463331413139	(37.750137280527, -122.463331413139)
50134	50134	191700	DPW Maintained 3	Eriobotrya japonica :: Edible Loquat 190	1700x Quesada Ave	39	Median : Yard 3	Tree 1	DPW 2			3			6014384.30677	2095263.8272900002	37.7340041867507	-122.39265480417801	(37.7340041867507, -122.392654804178)
55258	55258	212539	DPW Maintained 3	Prunus cerasifera :: Cherry Plum 16	200x Terrace Dr	39	Median : Yard 3	Tree 1	DPW 2			7			5993900.48922	2096491.80191	37.736216984813105	-122.463562225914	(37.7362169848131, -122.463562225914)
154652	154652	129351	DPW Maintained 3	Juniperus chinensis :: Juniper 19	1306x Montgomery St	39	Median : Yard 3	Tree 1	DPW 2			1	Width 8ft		6011425.67929	2120161.57643	37.8022029953207	-122.404635873741	(37.8022029953207, -122.404635873741)
175195	175195	194441	DPW Maintained 3	Pinus pinea :: Italian Stone Pine 143	900x Carolina St	39	Median : Yard 3	Tree 1	DPW 2			18			6012501.46554	2103105.9446900003	37.7554322198433	-122.399714855461	(37.7554322198433, -122.399714855461)
26942	26942	129350	DPW Maintained 3	Juniperus chinensis :: Juniper 19	1306x Montgomery St	38	Median : Yard 3	Tree 1	DPW 2			1	Width 8ft		6011425.50986	2120159.17711	37.8021963979046	-122.404636291051	(37.8021963979046, -122.404636291051)
28285	28285	206831	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	335x Pacheco St	38	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		5994089.87141	2101545.69318	37.7501046117408	-122.463274075037	(37.7501046117408, -122.463274075037)
58702	58702	194289	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	38	Median : Yard 3	Tree 1	DPW 2			48			6014396.14271	2095264.76436	37.734007417094	-122.39261394888901	(37.734007417094, -122.392613948889)
165194	165194	212538	DPW Maintained 3	Prunus cerasifera :: Cherry Plum 16	200x Terrace Dr	38	Median : Yard 3	Tree 1	DPW 2			6			5993893.90506	2096479.6500900001	37.736183239558	-122.463584108238	(37.736183239558, -122.463584108238)
25644	25644	126371	DPW Maintained 3	Cotoneaster SPP :: Cotoneaster 234	1306x Montgomery St	37	Median : Yard 3	Tree 1	DPW 2			4	Width 8ft		6011427.3089	2120158.66	37.8021950785935	-122.404630029046	(37.8021950785935, -122.404630029046)
35608	35608	194288	Landmark tree 9	Phoenix canariensis :: Canary Island Date Palm 100	1700x Quesada Ave	37	Median : Yard 3	Tree 1	DPW 2			34			6014411.93404	2095259.01392	37.733992504551296	-122.392558950849	(37.7339925045513, -122.392558950849)
56595	56595	211131	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	335x Pacheco St	37	Median : Yard 3	Tree 1	DPW 2			5	Width 8ft		5994094.61365	2101539.2804900003	37.7500872773246	-122.463257210957	(37.7500872773246, -122.463257210957)
180177	180177	211656	DPW Maintained 3	Pittosporum undulatum :: Victorian Box 26	200x Terrace Dr	37	Median : Yard 3	Tree 1	DPW 2			15			5993885.28493	2096476.0493	37.7361728559925	-122.463613650077	(37.7361728559925, -122.463613650077)
30631	30631	205755	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	200x Terrace Dr	36	Median : Yard 3	Tree 1	DPW 2			5			5993878.86602	2096471.7721400002	37.7361607421118	-122.463635532375	(37.7361607421118, -122.463635532375)
74110	74110	188585	DPW Maintained 3	Acacia melanoxylon :: Blackwood Acacia 5	900x Carolina St	36	Median : Yard 3	Tree 1	DPW 2			10			6012499.61765	2103177.92943	37.755629771207	-122.39972630024799	(37.755629771207, -122.399726300248)
130411	130411	136579	DPW Maintained 3	Syringa :: Lilac Tree 422	1306x Montgomery St	36	Median : Yard 3	Tree 1	DPW 2			22	Width 8ft		6011426.53654	2120156.27295	37.8021884811707	-122.404632533662	(37.8021884811707, -122.404632533662)
158355	158355	188005	DPW Maintained 3	Araucaria columnaris :: Coral reef araucaria 185	1700x Quesada Ave	36	Median : Yard 3	Tree 1	DPW 2			1			6014418.79198	2095243.03437	37.733949008825896	-122.39253412326799	(37.7339490088259, -122.392534123268)
173233	173233	211130	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	335x Pacheco St	36	Median : Yard 3	Tree 1	DPW 2			48	Width 8ft		5994106.02259	2101525.20056	37.7500492746747	-122.46321673696	(37.7500492746747, -122.46321673696)
29552	29552	211129	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	335x Pacheco St	35	Median : Yard 3	Tree 1	DPW 2			25	Width 8ft		5994111.36343	2101512.4621099997	37.7500146058056	-122.463197343983	(37.7500146058056, -122.463197343983)
46065	46065	205754	DPW Maintained 3	Callistemon citrinus :: Lemon Bottlebrush 28	200x Terrace Dr	35	Median : Yard 3	Tree 1	DPW 2			5			5993872.8693	2096472.5281599998	37.7361624724174	-122.46365632018	(37.7361624724174, -122.46365632018)
74497	74497	190073	DPW Maintained 3	Citrus spp :: Lemon: Orange: Lime 278	1700x Quesada Ave	35	Median : Yard 3	Tree 1	DPW 2			1			6014423.28579	2095240.49948	37.7339422980969	-122.392518409417	(37.7339422980969, -122.392518409417)
75923	75923	226602	DPW Maintained 3	Leptospermum scoparium :: New Zealand Tea Tree 27	5200x Diamond Heights Blvd	35	Median : Yard 3	Tree 1	DPW 2			11			6001604.7772	2098884.15576	37.7432267298424	-122.437096613431	(37.7432267298424, -122.437096613431)
166630	166630	189402	DPW Maintained 3	Corymbia ficifolia :: Red Flowering Gum 60	900x Carolina St	35	Median : Yard 3	Tree 1	DPW 2			31			6012483.079	2103205.45107	37.755704417647294	-122.399785428875	(37.7557044176473, -122.399785428875)
188999	188999	129349	DPW Maintained 3	Juniperus chinensis :: Juniper 19	1306x Montgomery St	35	Median : Yard 3	Tree 1	DPW 2			2	Width 8ft		6011426.64663	2120143.89656	37.8021545047788	-122.40463128093398	(37.8021545047788, -122.404631280934)

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