Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 sorted by qSiteInfo

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
129	129	20398	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	43	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
484	484	205880	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	44 Mendosa Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			43	Width 3ft		5993348.04769	2101170.42115	37.7490314462559	-122.46581205990499	(37.7490314462559, -122.465812059905)
618	618	20377	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
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
961	961	251408	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	75 Christmas Tree Point Rd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		5998776.0	2103023.0	37.75442978774979	-122.447175546291	(37.7544297877498, -122.447175546291)
1898	1898	20392	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	38	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
2144	2144	252907	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	25 Point Lobos Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2				10x10		5982783.76519	2112486.06679	37.7794859217892	-122.50318049806101	(37.7794859217892, -122.503180498061)
2151	2151	252916	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	101 Gold Mine Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6001472.0	2098865.0	37.7431665844065	-122.437554349716	(37.7431665844065, -122.437554349716)
3112	3112	253318	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3113	3113	253332	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	27	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3115	3115	253329	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	24	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3116	3116	253328	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	23	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3119	3119	253313	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3120	3120	253308	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3121	3121	253303	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3122	3122	253323	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3123	3123	253306	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3125	3125	253309	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3127	3127	253316	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3128	3128	253330	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	25	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3129	3129	253317	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3130	3130	253319	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3131	3131	253310	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3133	3133	253333	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	28	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3135	3135	253335	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	30	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3136	3136	253320	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3139	3139	253322	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	20	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3140	3140	253334	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	29	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3141	3141	253311	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3143	3143	253336	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	31	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3145	3145	253304	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3146	3146	253314	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3148	3148	253327	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3150	3150	253331	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	26	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3151	3151	253312	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3152	3152	253307	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3153	3153	253315	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3155	3155	253305	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3156	3156	253321	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Euclid Ave	19	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1						5999085.0	2114289.0	37.7853810185166	-122.446917590697	(37.7853810185166, -122.446917590697)
3981	3981	18927	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2691 Sacramento St	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6001960.28459	2115686.06098	37.7893808348161	-122.437070045665	(37.7893808348161, -122.437070045665)
5557	5557	20407	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	52	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
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
6006	6006	20312	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	101X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
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
6115	6115	20296	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
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
6357	6357	20291	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
6360	6360	20424	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6399	6399	20412	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
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
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
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
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
7006	7006	20417	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
7193	7193	110906	Permitted Site 1	Cupressus macrocarpa :: Monterey Cypress 47	2891 Vallejo St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/08/2015 12:00:00 AM	3	3x10	Permit Number 775210	5999784.0596900005	2117390.4095799997	37.7939365889551	-122.44472206489799	(37.7939365889551, -122.444722064898)
7419	7419	97731	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1150 Francisco St	9	Sidewalk: Curb side : Cutout 1	Tree 1	SFUSD 4	DPW for City Agency 2		3	3x3	Permit Number 50638	6005778.11415	2120709.05822	37.803388983478605	-122.42421815984501	(37.8033889834786, -122.424218159845)
7548	7548	20317	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	101X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
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
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
8196	8196	20297	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
8406	8406	20373	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	21	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
8584	8584	2988	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2266X California St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			35	3X3		6003528.90719	2115622.95537	37.7892965998021	-122.431638286196	(37.7892965998021, -122.431638286196)
8739	8739	20365	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
8750	8750	20413	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
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
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
9172	9172	173599	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	100X Warren Dr	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			20	3x3		5995367.0	2102770.0	37.7535397418859	-122.458946354326	(37.7535397418859, -122.458946354326)
9473	9473	20455	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	495X Sunset Blvd	20	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
9584	9584	20422	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
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
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
10701	10701	20452	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	495X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
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
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
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
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
11591	11591	20428	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	40
11826	11826	20419	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
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
12480	12480	20434	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
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
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
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
13273	13273	20881	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1892X Sunset Blvd	31	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/21/2017 10:23:00 AM	3	60		5984852.8466778	2102317.5089788004	37.7516873322231	-122.49527267334	(37.7516873322231, -122.49527267334)
13276	13276	20799	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1792X Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/21/2017 10:19:00 AM	3			5984829.6375693	2102999.3844439	37.7535582155387	-122.49540321629601	(37.7535582155387, -122.495403216296)
13278	13278	20803	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1792X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/21/2017 10:15:00 AM	3	60		5984829.6375693	2102999.3844439	37.7535582155387	-122.49540321629601	(37.7535582155387, -122.495403216296)
14158	14158	20429	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	30
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
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
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
14506	14506	20366	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	262X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
14521	14521	20280	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	20X Sunset Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
14597	14597	20303	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	50X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14923	14923	20430	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	485X Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	30
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
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
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
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
16086	16086	20423	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	453X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60

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