Street_Tree_List

Data source: data.sfgov.org

155 rows where qSiteInfo = 2 and qSpecies = 28

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

- 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: DBH

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
3041	3041	182178	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1799X Lawton St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5988865.0	2104441.0	37.7577519603078	-122.48155379203999	(37.7577519603078, -122.48155379204)
25079	25079	204442	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2395 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5991351.20232	2099149.48654	37.743367092409294	-122.472569777984	(37.7433670924093, -122.472569777984)
25836	25836	222165	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	953 Elizabeth St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 4ft		6000303.115259999	2101951.8939	37.7515759277946	-122.441817532557	(37.7515759277946, -122.441817532557)
25851	25851	118062	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	440 36th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5984715.49156	2112889.6967	37.780707531386795	-122.49652772957899	(37.7807075313868, -122.496527729579)
26267	26267	204461	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	376 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		5993925.03451	2099657.87207	37.7449116357803	-122.46370708514	(37.7449116357803, -122.46370708514)
27562	27562	204441	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2391 16th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5991348.1208	2099203.10843	37.7435141459709	-122.47258434161199	(37.7435141459709, -122.472584341612)
28772	28772	175741	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	262 Chicago Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 6ft		6002753.09913	2086743.14922	37.709955463542	-122.432259125067	(37.709955463542, -122.432259125067)
29157	29157	175654	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	0 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			5989491.89044	2089216.44658	37.7159856948481	-122.478272601196	(37.7159856948481, -122.478272601196)
29194	29194	188256	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1039 Jamestown Ave	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6013789.26124	2089763.6189299999	37.7188686596462	-122.39432710432301	(37.7188686596462, -122.394327104323)
32526	32526	204462	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	370 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5993936.392419999	2099669.25948	37.74494355720479	-122.463668638206	(37.7449435572048, -122.463668638206)
32575	32575	204488	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	10 Linares Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5993862.27446	2102337.63255	37.7522659605301	-122.464118595998	(37.7522659605301, -122.464118595998)
33718	33718	205774	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	367 Kensington Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 5ft		5994104.037819999	2099097.57437	37.743383512235496	-122.46304748455401	(37.7433835122355, -122.463047484554)
34280	34280	188251	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1039 Jamestown Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			6013763.34518	2089782.1261	37.718918036018295	-122.394417981716	(37.7189180360183, -122.394417981716)
35855	35855	218427	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	81 Lopez Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5993972.34889	2100426.1588	37.74702388334379	-122.46359923032301	(37.7470238833438, -122.463599230323)
36051	36051	204490	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	50 Linares Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			2	Width 3ft		5994003.40527	2102191.9627099996	37.751874121403496	-122.463619975902	(37.7518741214035, -122.463619975902)
36617	36617	175739	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	275 Chicago Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 6ft		6002794.41849	2086722.1369599998	37.709900111181604	-122.432114818072	(37.7099001111816, -122.432114818072)
36632	36632	188878	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	800 Vermont St	17	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			6011299.1950199995	2104323.40019	37.7587079887048	-122.403958366804	(37.7587079887048, -122.403958366804)
36921	36921	175655	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	0 Gonzalez Dr	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			5989994.06268	2089291.6225400001	37.7162212479866	-122.476542364932	(37.7162212479866, -122.476542364932)
37680	37680	175596	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	861 Lisbon St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 6ft		6001043.54225	2088836.75005	37.715606945381	-122.438317555522	(37.715606945381, -122.438317555522)
37841	37841	175646	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	275 De Long St	8	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 10ft		5993722.898680001	2086804.1045099997	37.7096066812751	-122.46347339448799	(37.7096066812751, -122.463473394488)
38307	38307	183532	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2571 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 0ft		5987672.2406	2097791.749	37.7394254680034	-122.485190924064	(37.7394254680034, -122.485190924064)
38447	38447	140861	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	102 Jordan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 0ft		5996245.7331	2113752.0549	37.7837440946001	-122.456701695076	(37.7837440946001, -122.456701695076)
39065	39065	181927	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2431 32nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 0ft		5986398.5047	2098678.2401	37.7417852550403	-122.48966005728902	(37.7417852550403, -122.489660057289)
40895	40895	123901	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1 10th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5992691.28495	2114901.15699	37.7866944866565	-122.469082295037	(37.7866944866565, -122.469082295037)
41791	41791	188253	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1039 Jamestown Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			6013773.56946	2089775.5723	37.718900608948395	-122.394382181502	(37.7189006089484, -122.394382181502)
42385	42385	205834	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	125 Ashton Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994133.07445	2090738.36189	37.720432840576294	-122.462340925011	(37.7204328405763, -122.462340925011)
42513	42513	205744	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	21 Sotelo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5993907.26286	2101064.51841	37.748772906454	-122.463870618755	(37.748772906454, -122.463870618755)
43038	43038	188885	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	861 Vermont St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6011299.70234	2104367.2853200003	37.7588285158534	-122.40395970050501	(37.7588285158534, -122.403959700505)
43151	43151	218426	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	81 Lopez Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 0ft		5993972.09439	2100414.03135	37.74699056977129	-122.46359923033998	(37.7469905697713, -122.46359923034)
44524	44524	188894	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	613 Wisconsin St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		6012726.06776	2104548.45782	37.75940556313879	-122.399039352197	(37.7594055631388, -122.399039352197)
44701	44701	175656	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	0 Gonzalez Dr	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			5990014.1272599995	2089314.5953099998	37.716285489253	-122.476474690052	(37.716285489253, -122.476474690052)
44809	44809	205739	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	32 Mesa Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 4ft		5993618.940280001	2100774.85979	37.7479609580525	-122.464846596315	(37.7479609580525, -122.464846596315)
45150	45150	188881	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	875 Vermont St	11	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6011300.937609999	2104283.5706	37.7585987228662	-122.40394953724899	(37.7585987228662, -122.403949537249)
45761	45761	205748	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	80 Sotelo Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5993792.60369	2101417.1534599997	37.7497345443361	-122.46429270473999	(37.7497345443361, -122.46429270474)
46261	46261	220871	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1543 Cole St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 2ft		5998317.5553	2105142.97668	37.7602245109746	-122.448913658336	(37.7602245109746, -122.448913658336)
47833	47833	205738	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	369 Pacheco St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 3ft		5994146.67179	2101256.63547	37.7493142048085	-122.463056687317	(37.7493142048085, -122.463056687317)
48313	48313	188250	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1039 Jamestown Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			17			6013748.16101	2089779.7890700002	37.7189107748964	-122.39447030426099	(37.7189107748964, -122.394470304261)
48756	48756	185233	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2526 34th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9	Width 0ft		5985848.001	2098017.6836	37.739939387502	-122.49151488036999	(37.739939387502, -122.49151488037)
48950	48950	175604	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	243 Curtis St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 2ft		6000875.03048	2087235.17223	37.711199783509	-122.43878530732201	(37.711199783509, -122.438785307322)
51145	51145	250738	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2801 Lake St	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 4ft		5986770.52108	2114418.70237	37.7850259235546	-122.489530954893	(37.7850259235546, -122.489530954893)
51348	51348	118064	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	422 36th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5984714.3913900005	2112995.82117	37.7809988539809	-122.496539369065	(37.7809988539809, -122.496539369065)
52285	52285	222278	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	21 Mirabel Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 3ft		6007380.86566	2099870.5580599997	37.7462618023452	-122.417194247838	(37.7462618023452, -122.417194247838)
52293	52293	183524	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2563 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5987671.006	2097842.0589	37.739563533837206	-122.48519888317301	(37.7395635338372, -122.485198883173)
52770	52770	175645	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	275 De Long St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 10ft		5993719.51846	2086804.6578900001	37.7096080059695	-122.46348511715799	(37.7096080059695, -122.463485117158)
53937	53937	175653	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	0 Gonzalez Dr	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			5988966.88544	2089648.46014	37.7171414055178	-122.480118843736	(37.7171414055178, -122.480118843736)
54344	54344	175642	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	275 De Long St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 10ft		5993719.3869	2086798.3884400001	37.709590783961	-122.463485117168	(37.709590783961, -122.463485117168)
54758	54758	183609	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1150 Quintara St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 0ft		5989796.6853	2101103.1583	37.7486412616545	-122.478087645581	(37.7486412616545, -122.478087645581)
55506	55506	222277	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	19 Mirabel Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		6007363.727080001	2099862.09475	37.746237599797	-122.417252911486	(37.746237599797, -122.417252911486)
55853	55853	117982	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	82 Shore View Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 5ft		5984203.12595	2112857.2788400003	37.780588490902204	-122.498297826626	(37.7805884909022, -122.498297826626)
56139	56139	204460	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	376 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5993909.76368	2099645.4597099996	37.744876674610296	-122.46375898770901	(37.7448766746103, -122.463758987709)
56161	56161	204456	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	396 Magellan Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 3ft		5993813.888619999	2099553.91261	37.74461978417229	-122.464083858782	(37.7446197841723, -122.464083858782)
56400	56400	175657	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	0 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			5990127.49163	2089397.98883	37.716521041479204	-122.476088939347	(37.7165210414792, -122.476088939347)
56612	56612	188254	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1039 Jamestown Ave	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8			6013780.02718	2089753.4923900003	37.718840340875204	-122.39435831441001	(37.7188403408752, -122.39435831441)
57179	57179	204485	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	74 Ventura Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5994266.92973	2101789.53339	37.7507843337414	-122.462679488264	(37.7507843337414, -122.462679488264)
57656	57656	250734	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2801 Lake St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 4ft		5986725.81276	2114419.04313	37.7850242490072	-122.489685654482	(37.7850242490072, -122.489685654482)
57926	57926	175606	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	243 Curtis St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 2ft		6000866.493969999	2087267.4309	37.7112878729966	-122.43881712171499	(37.7112878729966, -122.438817121715)
58838	58838	188880	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	875 Vermont St	7	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			9			6011314.3865	2104282.5433099996	37.758596653528706	-122.40390295235599	(37.7585966535287, -122.403902952356)
59217	59217	204486	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	74 Ventura Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5994244.88576	2101786.49347	37.750774717299706	-122.46275549719499	(37.7507747172997, -122.462755497195)
59505	59505	220993	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1201 Diamond St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			13	Width 4ft		6001989.83823	2100489.19033	37.747655657099706	-122.435879993478	(37.7476556570997, -122.435879993478)
60286	60286	188255	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1039 Jamestown Ave	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4			6013785.156280001	2089757.61987	37.718851959233	-122.394340873848	(37.718851959233, -122.394340873848)
60472	60472	204494	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2200 Mesa Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 3ft		5993641.992219999	2100733.77083	37.7478494672755	-122.464763900938	(37.7478494672755, -122.464763900938)
60989	60989	205742	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2 Mesa Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5993680.893019999	2100753.24241	37.747905173987796	-122.464630798584	(37.7479051739878, -122.464630798584)
61498	61498	104897	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	303 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
61838	61838	123902	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1 10th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5992691.42698	2114893.08742	37.786672338047296	-122.469081216144	(37.7866723380473, -122.469081216144)
64910	64910	220816	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	100 Alemany Blvd	27	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		6009324.41886	2095855.6736400002	37.735346953705104	-122.410190239591	(37.7353469537051, -122.410190239591)
64991	64991	106213	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1646 35th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			5985329.6566	2104002.0012	37.7563403897038	-122.493747943766	(37.7563403897038, -122.493747943766)
65107	65107	204465	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	350 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994010.10708	2099738.02045	37.7451366047831	-122.463418737312	(37.7451366047831, -122.463418737312)
65781	65781	175630	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	75 South Hill Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 4ft		6002944.13194	2087144.13507	37.7110673133896	-122.43162748893101	(37.7110673133896, -122.431627488931)
65937	65937	204484	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2 Castenada Ave	13	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			3	Width 3ft		5994414.70614	2101778.8462	37.750763499154	-122.46216769308998	(37.750763499154, -122.46216769309)
66504	66504	250735	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2801 Lake St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5986736.846390001	2114419.4183900002	37.785025923551295	-122.48964750974301	(37.7850259235513, -122.489647509743)
66588	66588	204487	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	10 Linares Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 3ft		5993872.61201	2102327.49327	37.7522387164587	-122.464082111418	(37.7522387164587, -122.464082111418)
66936	66936	188884	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	861 Vermont St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7			6011309.015240001	2104361.95853	37.7588144099776	-122.40392711715799	(37.7588144099776, -122.403927117158)
67037	67037	175746	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	52 Baltimore Way	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6002987.27121	2086606.3933299999	37.7095932364015	-122.43144002615401	(37.7095932364015, -122.431440026154)
67255	67255	188883	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	861 Vermont St	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5			6011316.75844	2104356.6633599997	37.75880030321861	-122.403899964826	(37.7588003032186, -122.403899964826)
67442	67442	204466	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	350 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			5	Width 3ft		5994033.29677	2099756.91004	37.7451898068672	-122.463339922497	(37.7451898068672, -122.463339922497)
67742	67742	205745	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	33 Sotelo Ave	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 4ft		5993901.20926	2101134.1872400003	37.7489638504989	-122.463896608242	(37.7489638504989, -122.463896608242)
69657	69657	250736	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2801 Lake St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			4	Width 4ft		5986749.69109	2114418.5354	37.7850242490246	-122.48960300679899	(37.7850242490246, -122.489603006799)
70293	70293	117983	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	82 Shore View Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			6	Width 5ft		5984187.509869999	2112858.34	37.7805904888414	-122.498351927647	(37.7805904888414, -122.498351927647)
71678	71678	118556	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	8100 Geary Blvd	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 3ft		5981834.606430001	2112394.66752	37.7791791285364	-122.506457204565	(37.7791791285364, -122.506457204565)
74411	74411	123904	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	1 10th Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 4ft		5992691.51284	2114864.9761799998	37.786595157288204	-122.469078872446	(37.7865951572882, -122.469078872446)
74650	74650	175744	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	46 Baltimore Way	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			12	Width 6ft		6003028.75595	2086646.47615	37.709705646261796	-122.431299507078	(37.7097056462618, -122.431299507078)
76508	76508	125805	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	349 Marina Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11			6001675.8593	2121806.39816	37.8061695046764	-122.43849281089399	(37.8061695046764, -122.438492810894)
76783	76783	222163	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	976 Elizabeth St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			18	Width 4ft		6000221.60157	2101988.12675	37.7516707693994	-122.442102016907	(37.7516707693994, -122.442102016907)
77035	77035	204457	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	396 Magellan Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5993837.1599	2099576.6757	37.744683627061896	-122.464005043996	(37.7446836270619, -122.464005043996)
82965	82965	104918	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	719 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990421.0	2090607.0	37.719857702396	-122.47516265050699	(37.719857702396, -122.475162650507)
84395	84395	104895	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	300 Gonzalez Dr		Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
85192	85192	175643	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	275 De Long St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			11	Width 10ft		5993719.91168	2086800.3072400002	37.7095960827685	-122.463483442609	(37.7095960827685, -122.463483442609)
87111	87111	104901	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	314 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
88216	88216	104923	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	767 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990385.0	2090588.0	37.7198034465129	-122.47528570222	(37.7198034465129, -122.47528570222)
91465	91465	104905	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	419 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
94459	94459	104902	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	332 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
95153	95153	104907	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	432 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
107401	107401	104896	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	302 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
109481	109481	104917	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	702 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
120486	120486	104903	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	411 Gonzalez Dr	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1						5990435.0	2090585.0	37.7197981072685	-122.47511265272199	(37.7197981072685, -122.475112652722)
121247	121247	218213	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	51 Taraval St	5	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			10	Width 3ft		5993565.03218	2099177.62428	37.743572245754706	-122.464917025812	(37.7435722457547, -122.464917025812)
130442	130442	183531	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2570 28th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			7	Width 0ft		5987717.9633	2097796.8849	37.739442233222206	-122.485033213759	(37.7394422332222, -122.485033213759)
130834	130834	205741	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	2 Mesa Ave	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5993661.85009	2100760.81292	37.7479248628426	-122.464697197315	(37.7479248628426, -122.464697197315)
131152	131152	204459	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	380 Magellan Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			14	Width 3ft		5993896.06713	2099628.58544	37.7448295528569	-122.463805122909	(37.7448295528569, -122.463805122909)
131278	131278	117746	Undocumented 2	Callistemon citrinus :: Lemon Bottlebrush 28	433 39th Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			8	Width 4ft		5983739.045419999	2112883.08497	37.7806321236335	-122.49990518483	(37.7806321236335, -122.49990518483)

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