Street_Tree_List

Data source: data.sfgov.org

1,824 rows where qSpecies = 47 sorted by PlotSize

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: qSiteInfo, qCaretaker, qCareAssistant, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize ▼	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
272	272	251264	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
277	277	251265	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	4	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
293	293	251262	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
300	300	251263	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3630x 19th Ave	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1					Permit Number 779147
549	549	251321	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	100X Monument Way	1	Unaccepted Street : Yard 14	Tree 1	Private 1
682	682	251365	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	138x Gladeview Way	2	Sidewalk: Property side : Yard 9	Tree 1	Private 1
712	712	251366	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	138x Gladeview Way	3	Sidewalk: Property side : Yard 9	Tree 1	Private 1
713	713	251364	Private 5	Cupressus macrocarpa :: Monterey Cypress 47	138x Gladeview Way	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1
731	731	251375	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	3	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
747	747	251378	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	6	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
749	749	251374	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	2	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
757	757	251377	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	5	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
763	763	251373	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	1	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
764	764	251379	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	7	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
785	785	251376	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	401 Portola Dr	4	Median : Yard 3	Tree 1	DPW 2						5998962.0	2100210.0	37.7467166026546	-122.446329965078	(37.7467166026546, -122.446329965078)
1098	1098	251438	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2501X Santiago St	1	Median : Yard 3	Tree 1	DPW 2
1600	1600	251625	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	76R Amber Dr	3	Back Yard : Yard 13	Tree 1	Private 1						5999293.0	2100015.0	37.746200078593205	-122.44517138727	(37.7462000785932, -122.44517138727)
1604	1604	251632	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	14R Amethyst Way	1	Back Yard : Yard 13	Tree 1	Private 1						5999202.0	2100044.0	37.746274510978395	-122.445488137723	(37.7462745109784, -122.445488137723)
1605	1605	251634	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	14R Amethyst Way	3	Back Yard : Yard 13	Tree 1	Private 1						5999202.0	2100044.0	37.746274510978395	-122.445488137723	(37.7462745109784, -122.445488137723)
1608	1608	251603	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	44R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999509.0	2100035.0	37.746267320465705	-122.444425925791	(37.7462673204657, -122.444425925791)
1609	1609	251630	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	8R Amethyst Way	2	Back Yard : Yard 13	Tree 1	Private 1						5999237.0	2100032.0	37.7462435599048	-122.44536624972099	(37.7462435599048, -122.445366249721)
1613	1613	251616	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	64R Amber Dr	3	Back Yard : Yard 13	Tree 1	Private 1						5999367.0	2100045.0	37.746286674920704	-122.44491766156601	(37.7462866749207, -122.444917661566)
1618	1618	251611	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	56R Amber Dr	4	Back Yard : Yard 13	Tree 1	Private 1						5999423.0	2100048.0	37.7462981080439	-122.44472423658002	(37.7462981080439, -122.44472423658)
1619	1619	251617	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	64R Amber Dr	4	Back Yard : Yard 13	Tree 1	Private 1						5999367.0	2100045.0	37.746286674920704	-122.44491766156601	(37.7462866749207, -122.444917661566)
1623	1623	251613	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	60R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999394.0	2100048.0	37.7462964530913	-122.444824514752	(37.7462964530913, -122.444824514752)
1624	1624	251624	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	76R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999293.0	2100015.0	37.746200078593205	-122.44517138727	(37.7462000785932, -122.44517138727)
1625	1625	251623	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	76R Amber Dr	1	Back Yard : Yard 13	Tree 1	Private 1						5999293.0	2100015.0	37.746200078593205	-122.44517138727	(37.7462000785932, -122.44517138727)
1626	1626	251635	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	18R Amethyst Way	1	Back Yard : Yard 13	Tree 1	Private 1						5999176.0	2100050.0	37.746289501198795	-122.445578473632	(37.7462895011988, -122.445578473632)
1628	1628	251629	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	8R Amethyst Way	1	Back Yard : Yard 13	Tree 1	Private 1						5999237.0	2100032.0	37.7462435599048	-122.44536624972099	(37.7462435599048, -122.445366249721)
1629	1629	251631	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	8R Amethyst Way	3	Back Yard : Yard 13	Tree 1	Private 1						5999237.0	2100032.0	37.7462435599048	-122.44536624972099	(37.7462435599048, -122.445366249721)
1631	1631	251621	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	72R Amber Dr	4	Back Yard : Yard 13	Tree 1	Private 1						5999318.0	2100030.0	37.746242691915	-122.445086018875	(37.746242691915, -122.445086018875)
1632	1632	251628	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	2R Amethyst Way	3	Back Yard : Yard 13	Tree 1	Private 1						5999263.0	2100016.0	37.746201111936706	-122.44527519504999	(37.7462011119367, -122.44527519505)
1637	1637	251619	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	72R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999318.0	2100030.0	37.746242691915	-122.445086018875	(37.746242691915, -122.445086018875)
1638	1638	251620	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	72R Amber Dr	3	Back Yard : Yard 13	Tree 1	Private 1						5999318.0	2100030.0	37.746242691915	-122.445086018875	(37.746242691915, -122.445086018875)
1639	1639	251615	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	64R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999367.0	2100045.0	37.746286674920704	-122.44491766156601	(37.7462866749207, -122.444917661566)
1640	1640	251622	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	72R Amber Dr	5	Back Yard : Yard 13	Tree 1	Private 1						5999318.0	2100030.0	37.746242691915	-122.445086018875	(37.746242691915, -122.445086018875)
1641	1641	251627	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2R Amethyst Way	2	Back Yard : Yard 13	Tree 1	Private 1						5999263.0	2100016.0	37.746201111936706	-122.44527519504999	(37.7462011119367, -122.44527519505)
1643	1643	251614	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	64R Amber Dr	1	Back Yard : Yard 13	Tree 1	Private 1						5999367.0	2100045.0	37.746286674920704	-122.44491766156601	(37.7462866749207, -122.444917661566)
1645	1645	251626	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	2R Amethyst Way	1	Back Yard : Yard 13	Tree 1	Private 1						5999263.0	2100016.0	37.746201111936706	-122.44527519504999	(37.7462011119367, -122.44527519505)
1646	1646	251633	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	14R Amethyst Way	2	Back Yard : Yard 13	Tree 1	Private 1						5999202.0	2100044.0	37.746274510978395	-122.445488137723	(37.7462745109784, -122.445488137723)
1650	1650	251608	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	56R Amber Dr	1	Back Yard : Yard 13	Tree 1	Private 1						5999423.0	2100048.0	37.7462981080439	-122.44472423658002	(37.7462981080439, -122.44472423658)
1651	1651	251609	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	56R Amber Dr	2	Back Yard : Yard 13	Tree 1	Private 1						5999423.0	2100048.0	37.7462981080439	-122.44472423658002	(37.7462981080439, -122.44472423658)
1652	1652	251618	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	72R Amber Dr	1	Back Yard : Yard 13	Tree 1	Private 1						5999318.0	2100030.0	37.746242691915	-122.445086018875	(37.746242691915, -122.445086018875)
1654	1654	251610	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	56R Amber Dr	3	Back Yard : Yard 13	Tree 1	Private 1						5999423.0	2100048.0	37.7462981080439	-122.44472423658002	(37.7462981080439, -122.44472423658)
1820	1820	251716	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3929 19th St	1	Front Yard : Yard 7	Tree 1	Private 1						6003450.0	2104734.0	37.75939373993371	-122.431133769968	(37.7593937399337, -122.431133769968)
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)
2186	2186	252924	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	700 Sanchez St	1	Front Yard : Yard 7	Tree 1	DPW 2						6003672.0	2104202.0	37.757945572264	-122.430328029181	(37.757945572264, -122.430328029181)
3044	3044	253288	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	650 Peru Ave	4	Front Yard : Yard 7	Tree 1	Private 1						6005101.95698	2092563.1940099997	37.7260689503102	-122.42455474103201	(37.7260689503102, -122.424554741032)
3046	3046	253289	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	650 Peru Ave	5	Front Yard : Yard 7	Tree 1	Private 1						6005101.95698	2092563.1940099997	37.7260689503102	-122.42455474103201	(37.7260689503102, -122.424554741032)
3049	3049	253290	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	650 Peru Ave	6	Front Yard : Yard 7	Tree 1	Private 1						6005101.95698	2092563.1940099997	37.7260689503102	-122.42455474103201	(37.7260689503102, -122.424554741032)
3050	3050	253291	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	650 Peru Ave	7	Front Yard : Yard 7	Tree 1	Private 1						6005101.95698	2092563.1940099997	37.7260689503102	-122.42455474103201	(37.7260689503102, -122.424554741032)
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)
5089	5089	253778	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	90 Cuesta Ct	2	Front Yard : Yard 7	Tree 1	DPW 2						5999757.0	2101744.0	37.750973968576496	-122.443691128062	(37.7509739685765, -122.443691128062)
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)
5095	5095	253779	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	90 Cuesta Ct	3	Front Yard : Yard 7	Tree 1	DPW 2						5999757.0	2101744.0	37.750973968576496	-122.443691128062	(37.7509739685765, -122.443691128062)
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)
5100	5100	253781	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	90 Cuesta Ct	5	Front Yard : Yard 7	Tree 1	DPW 2						5999757.0	2101744.0	37.750973968576496	-122.443691128062	(37.7509739685765, -122.443691128062)
5105	5105	253777	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	90 Cuesta Ct	1	Front Yard : Yard 7	Tree 1	DPW 2						5999757.0	2101744.0	37.750973968576496	-122.443691128062	(37.7509739685765, -122.443691128062)
5107	5107	253780	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	90 Cuesta Ct	4	Front Yard : Yard 7	Tree 1	DPW 2						5999757.0	2101744.0	37.750973968576496	-122.443691128062	(37.7509739685765, -122.443691128062)
7834	7834	119605	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	299x Avalon Ave	1	Front Yard : Yard 7	Tree 1	Private 1
9640	9640	114128	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	21	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
9648	9648	114133	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	26	Sidewalk: Property side : Yard 9	Tree 1	Private 1			28			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
9649	9649	114125	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	18	Sidewalk: Property side : Yard 9	Tree 1	Private 1			18			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
9650	9650	114131	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	24	Sidewalk: Property side : Yard 9	Tree 1	Private 1			30			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
9662	9662	114130	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	23	Sidewalk: Property side : Yard 9	Tree 1	Private 1			24			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
9664	9664	114135	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			28			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
9666	9666	114127	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	20	Sidewalk: Property side : Yard 9	Tree 1	Private 1			36			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
9669	9669	114126	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	19	Sidewalk: Property side : Yard 9	Tree 1	Private 1			36			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
9671	9671	114132	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	25	Sidewalk: Property side : Yard 9	Tree 1	Private 1			36			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)
9673	9673	114129	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200X JUNIPERO SERRA BLVD	22	Sidewalk: Property side : Yard 9	Tree 1	Private 1			36			5991123.0	2089585.0	37.7170922039834	-122.47266163030399	(37.7170922039834, -122.472661630304)

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