Street_Tree_List

Data source: data.sfgov.org

2,124 rows where qSpecies = 3 sorted by Longitude

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

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude ▼	Location
3	3	119263	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Lakeshore Dr	1	Median : Yard 3	Tree 1	DPW 2				10x30
437	437	20292	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	13	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
556	556	20399	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	44	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
1620	1620	251543	Undocumented 2	Pinus radiata :: Monterey Pine 3	0X Bay Shore Blvd Off Ramp		Side Yard : Yard 17	Tree 1	Private 1
1841	1841	20401	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	46	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
2042	2042	20405	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	50	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
2700	2700	20053	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY53	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
3537	3537	102838	Undocumented 2	Pinus radiata :: Monterey Pine 3	1101X Portola Dr	1	Sidewalk: Property side : Yard 9	Tree 1	DPW 2
4187	4187	20426	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	15	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
4260	4260	20045	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY52	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	10
4482	4482	20388	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	34	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
4528	4528	19968	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY43	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	15
5282	5282	20344	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	30	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	40
5456	5456	20311	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	12	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
6219	6219	20290	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
6407	6407	20308	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
6784	6784	20408	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	53	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
7028	7028	20295	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
7080	7080	20425	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
7092	7092	19853	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY29	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	100ST
7096	7096	20070	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY55	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	40ST
7176	7176	19977	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY45	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	30ST
7292	7292	20433	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
7424	7424	20416	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
7658	7658	20289	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
7810	7810	119607	Significant Tree 6	Pinus radiata :: Monterey Pine 3	299x Avalon Ave	3	Front Yard : Yard 7	Tree 1	Private 1
8078	8078	20329	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
8128	8128	87100	Permitted Site 1	Pinus radiata :: Monterey Pine 3	700 Connecticut St	1	Front Yard : Yard 7	Tree 1	Rec/Park 3				3x3	Permit Number 50056
8485	8485	20457	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
8592	8592	121500	Private 5	Pinus radiata :: Monterey Pine 3	251X Pennsylvania Ave	1	Back Yard : Yard 13	Tree 1	DPW 2
9506	9506	20420	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
9521	9521	20394	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	39	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
9593	9593	94859	Permitted Site 1	Pinus radiata :: Monterey Pine 3		1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Permit Number 53932
9600	9600	20367	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	17	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
9694	9694	173632	Undocumented 2	Pinus radiata :: Monterey Pine 3	3300X Market St	1	Side Yard : Yard 17	Tree 1	Private 1
9843	9843	20458	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	23	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
9855	9855	20400	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	45	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
10567	10567	20323	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	11	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
10850	10850	20451	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
10974	10974	20418	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
11124	11124	20380	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
11130	11130	20306	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
11214	11214	20374	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	22	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			18	60
11595	11595	20431	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	30
11765	11765	20396	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	41	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
12711	12711	19749	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY15	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	10ST
12855	12855	20286	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13180	13180	20069	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY55	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	40ST
13202	13202	20284	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13357	13357	20454	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	19	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
13388	13388	20313	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13426	13426	20293	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	14	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	60
13476	13476	20287	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
13681	13681	19775	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY18	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	50ST
13746	13746	20338	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	25	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
13748	13748	20343	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	29	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
14111	14111	20421	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	10	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14252	14252	20285	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
14683	14683	20337	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	24	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
14835	14835	20387	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	33	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			24	60
14837	14837	94862	Permitted Site 1	Pinus radiata :: Monterey Pine 3		2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3	Permit Number 53932
14905	14905	20283	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			36	60
15072	15072	20052	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY53	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	30
15202	15202	20339	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	101X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	40
15238	15238	20432	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			42	30
15347	15347	20288	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	20X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
15632	15632	20427	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	453X Sunset Blvd	16	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	60
16056	16056	20402	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	47	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
16063	16063	20307	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Sunset Blvd	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			48	60
16202	16202	20435	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	485X Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	30
16297	16297	19969	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	100 STAIRWAY43	2	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	15
16394	16394	20368	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	262X Sunset Blvd	18	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			3	60
16828	16828	20461	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	495X Sunset Blvd	26	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	60
19583	19583	119914	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	400X Brotherhood Way	1	Front Yard : Yard 7	Tree 1	DPW 2				100x100
185502	185502	122532	Undocumented 2	Pinus radiata :: Monterey Pine 3	1900X Castro St	1	Unaccepted Street : Yard 14	Tree 1	Private 1
175941	175941	118463	Undocumented 2	Pinus radiata :: Monterey Pine 3	545 Point Lobos Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			21			5981101.15577	2112608.26384	37.7797223901441	-122.509010330711	(37.7797223901441, -122.509010330711)
162205	162205	118464	Undocumented 2	Pinus radiata :: Monterey Pine 3	501 Point Lobos Ave	1	Front Yard : Yard 7	Tree 1	Private 1			22			5981239.04477	2112631.92257	37.779795477814105	-122.508535077879	(37.7797954778141, -122.508535077879)
149914	149914	118489	Undocumented 2	Pinus radiata :: Monterey Pine 3	8301 Geary Blvd	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			35			5981241.64042	2112313.06401	37.778920139734	-122.508502421445	(37.778920139734, -122.508502421445)
62679	62679	184390	Undocumented 2	Pinus radiata :: Monterey Pine 3	2001 48th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 0ft		5981341.9754	2101226.7255	37.748486165253	-122.507332592891	(37.748486165253, -122.507332592891)
131480	131480	118634	Undocumented 2	Pinus radiata :: Monterey Pine 3	349 Point Lobos Ave	3	Side Yard : Yard 17	Tree 1	Private 1			16			5981640.48035	2112637.4972099997	37.779834435634896	-122.507146773829	(37.7798344356349, -122.507146773829)
131223	131223	118635	Undocumented 2	Pinus radiata :: Monterey Pine 3	349 Point Lobos Ave	1	Side Yard : Yard 17	Tree 1	Private 1			29			5981642.90919	2112624.80307	37.779799724333294	-122.50713742957399	(37.7797997243333, -122.507137429574)
119332	119332	120526	Property Tree 7	Pinus radiata :: Monterey Pine 3	1439 47th Ave	1	Back Yard : Yard 13	Tree 1	Private 1			20	3x3		5981489.0	2105275.0	37.759610238830206	-122.50712446853998	(37.7596102388302, -122.50712446854)
42200	42200	118839	Undocumented 2	Pinus radiata :: Monterey Pine 3	600 46th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			36	Width 5ft		5981667.64941	2111553.97712	37.7768610093184	-122.506972389283	(37.7768610093184, -122.506972389283)
29280	29280	184503	Undocumented 2	Pinus radiata :: Monterey Pine 3	1963 47th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18	Width 0ft		5981636.5852	2101719.8576	37.7498575164936	-122.506350418514	(37.7498575164936, -122.506350418514)
166513	166513	184502	Undocumented 2	Pinus radiata :: Monterey Pine 3	1963 47th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			20	Width 0ft		5981638.5485	2101729.1831	37.7498832372827	-122.506344320901	(37.7498832372827, -122.506344320901)
2399	2399	253072	Undocumented 2	Pinus radiata :: Monterey Pine 3	1350 46th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1				5x10	Permit Number 780489	5981849.666569999	2105897.22193	37.761339917853896	-122.50592325662	(37.7613399178539, -122.50592325662)
74227	74227	96113	Permitted Site 1	Pinus radiata :: Monterey Pine 3	229 Point Lobos Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/28/2011 12:00:00 AM	4	3x3	Permit Number 767768	5982054.02521	2112599.84865	37.779755411650704	-122.505713372558	(37.7797554116507, -122.505713372558)
34344	34344	55599	Permitted Site 1	Pinus radiata :: Monterey Pine 3	642 43rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/08/1973 12:00:00 AM	12		Permit Number 11573	5982597.2205300005	2111395.81021	37.776481429538705	-122.503745058688	(37.7764814295387, -122.503745058688)
118007	118007	24741	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	50X Point Lobos Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			12	12x12		5982629.2221800005	2112591.8659099997	37.7797673297653	-122.503722956534	(37.7797673297653, -122.503722956534)
119142	119142	116069	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	4150X CLEMENT ST	3	Front Yard : Yard 7	Tree 1	DPW 2				3x3		5983115.0	2113126.0	37.7812624555251	-122.502082001527	(37.7812624555251, -122.502082001527)
143181	143181	116070	DPW Maintained 3	Pinus radiata :: Monterey Pine 3	4150X CLEMENT ST	4	Front Yard : Yard 7	Tree 1	DPW 2				3x3		5983115.0	2113126.0	37.7812624555251	-122.502082001527	(37.7812624555251, -122.502082001527)
26867	26867	117975	Undocumented 2	Pinus radiata :: Monterey Pine 3	428 38th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		5984094.18326	2112936.79035	37.7808004176611	-122.49868058079399	(37.7808004176611, -122.498680580794)
44986	44986	117976	Undocumented 2	Pinus radiata :: Monterey Pine 3	428 38th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5984094.3285	2112929.06261	37.780779208054206	-122.498679507315	(37.7807792080542, -122.498679507315)
68420	68420	117978	Undocumented 2	Pinus radiata :: Monterey Pine 3	428 38th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 4ft		5984094.13719	2112920.1060200003	37.780754604644606	-122.49867950730301	(37.7807546046446, -122.498679507303)
92687	92687	105834	Undocumented 2	Pinus radiata :: Monterey Pine 3	3031 QUINTARA ST	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			22			5984010.9	2100823.5	37.747535864547	-122.498073868906	(37.747535864547, -122.498073868906)
38211	38211	118052	Undocumented 2	Pinus radiata :: Monterey Pine 3	451 36th Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			37	Width 8ft		5984675.38114	2112718.18403	37.7802342573005	-122.496653827903	(37.7802342573005, -122.496653827903)
149391	149391	63257	Permitted Site 1	Pinus radiata :: Monterey Pine 3	465 36th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/23/1987 12:00:00 AM	38		Permit Number 23810	5984679.75149	2112668.94882	37.780099327718794	-122.49663507465799	(37.7800993277188, -122.496635074658)
160061	160061	184357	Undocumented 2	Pinus radiata :: Monterey Pine 3	1251 Sunset Blvd	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1			47	Width 0ft		5984669.1858	2106580.4656	37.763381470366504	-122.49622228231001	(37.7633814703665, -122.49622228231)
66190	66190	20482	Permitted Site 1	Pinus radiata :: Monterey Pine 3	1204 Sunset Blvd	3	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3			42	40		5984687.760267501	2107238.1673169	37.7651884221731	-122.496206568741	(37.7651884221731, -122.496206568741)
78201	78201	20481	Permitted Site 1	Pinus radiata :: Monterey Pine 3	1204 Sunset Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Rec/Park 3			48	40		5984687.760267501	2107238.1673169	37.7651884221731	-122.496206568741	(37.7651884221731, -122.496206568741)

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