Street_Tree_List

Data source: data.sfgov.org

1,296 rows where DBH = 0 and qSpecies = 54 sorted by Latitude

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: SiteOrder, qSiteInfo, qCaretaker, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude ▼	Longitude	Location
28625	28625	217557	Undocumented 2	:: 54	111 Broad St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5995778.3452	2088036.9975	37.7131101315221	-122.456458551068	(37.7131101315221, -122.456458551068)
174834	174834	217555	Undocumented 2	:: 54	240 Broad St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5994537.6064	2088112.0778	37.713244974869	-122.46075236939899	(37.713244974869, -122.460752369399)
69253	69253	217580	Undocumented 2	:: 54	646 Randolph St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5992252.7325	2088559.8349	37.714342679649	-122.468682167409	(37.714342679649, -122.468682167409)
74439	74439	187452	Undocumented 2	:: 54	5098 Mission St	4	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6000296.2838	2089278.8073	37.7167782039769	-122.440932105905	(37.7167782039769, -122.440932105905)
147303	147303	187451	Undocumented 2	:: 54	5098 Mission St	3	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6000310.9137	2089292.2181	37.7168158602419	-122.440882499178	(37.7168158602419, -122.440882499178)
57456	57456	200234	Undocumented 2	:: 54	2895 Hawes St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6014768.3667	2089489.9029	37.718171466543104	-122.390923576462	(37.7181714665431, -122.390923576462)
165416	165416	200238	Undocumented 2	:: 54	917 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014595.9922	2089500.6344	37.7181913669776	-122.391520156023	(37.7181913669776, -122.391520156023)
177805	177805	200235	Undocumented 2	:: 54	923 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014534.9569	2089547.5847	37.7183168953073	-122.39173441165	(37.7183168953073, -122.39173441165)
73420	73420	200232	Undocumented 2	:: 54	923 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014491.3602	2089577.767	37.7183973497527	-122.391887217647	(37.7183973497527, -122.391887217647)
33211	33211	200211	Undocumented 2	:: 54	974 Jamestown Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014078.3317	2089599.8969999999	37.7184351760665	-122.39331644356001	(37.7184351760665, -122.39331644356)
176910	176910	200204	Undocumented 2	:: 54	2 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014372.6432	2089670.326	37.71864490712711	-122.392304046142	(37.7186449071271, -122.392304046142)
177358	177358	200205	Undocumented 2	:: 54	1003 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014813.9755	2089679.7161	37.71869518696921	-122.39077918277701	(37.7186951869692, -122.390779182777)
182449	182449	200194	Undocumented 2	:: 54	1011 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014781.1104	2089713.2519999999	37.718785446443206	-122.390895127615	(37.7187854464432, -122.390895127615)
147039	147039	200193	Undocumented 2	:: 54	975 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014303.5592	2089724.6542	37.7187902452961	-122.392546641558	(37.7187902452961, -122.392546641558)
179207	179207	200191	Undocumented 2	:: 54	981 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014255.2675	2089757.5194	37.7188778046353	-122.39271586587799	(37.7188778046353, -122.392715865878)
179075	179075	200190	Undocumented 2	:: 54	1027 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014706.6607	2089771.6044	37.7189415394071	-122.391156549139	(37.7189415394071, -122.391156549139)
55366	55366	200178	Undocumented 2	:: 54	3201 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014218.378	2089782.3359	37.7189438969212	-122.39284511455	(37.7189438969212, -122.39284511455)
43519	43519	200180	Undocumented 2	:: 54	1031 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014690.5634	2089785.0188	37.7189774793874	-122.391213128817	(37.7189774793874, -122.391213128817)
28513	28513	200177	Undocumented 2	:: 54	1041 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014650.3204	2089811.8475	37.7190489123065	-122.39135410876001	(37.7190489123065, -122.39135410876)
29863	29863	200176	Undocumented 2	:: 54	1047 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014610.748	2089844.7127	37.7191369573176	-122.391493192738	(37.7191369573176, -122.391493192738)
37581	37581	200170	Undocumented 2	:: 54	1001 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014099.661	2089867.5171	37.71917119290661	-122.393261433304	(37.7191711929066, -122.393261433304)
177846	177846	200172	Undocumented 2	:: 54	1053 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014576.5414	2089866.8464	37.7191958334242	-122.391612979464	(37.7191958334242, -122.391612979464)
186420	186420	200171	Undocumented 2	:: 54	1059 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014549.7127	2089886.9679	37.7192495938582	-122.391707122944	(37.7192495938582, -122.391707122944)
150420	150420	200167	Undocumented 2	:: 54	1019 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014049.3571	2089910.4430000002	37.7192862641022	-122.393438318502	(37.7192862641022, -122.393438318502)
133594	133594	200166	Undocumented 2	:: 54	1023 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014031.9185	2089919.1624	37.7193092369184	-122.393499207549	(37.7193092369184, -122.393499207549)
54871	54871	200168	Undocumented 2	:: 54	1101 Gilman Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014990.039	2089901.3883	37.7193136223873	-122.390186075408	(37.7193136223873, -122.390186075408)
144780	144780	200169	Undocumented 2	:: 54	1061 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014525.5668	2089911.1138	37.719314553356206	-122.391792274296	(37.7193145533562, -122.391792274296)
30792	30792	200164	Undocumented 2	:: 54	1027 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014014.4798	2089939.2839	37.7193635176037	-122.393560894555	(37.7193635176037, -122.393560894555)
156632	156632	200165	Undocumented 2	:: 54	1071 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014485.3238	2089939.2839	37.7193896687982	-122.39193334918501	(37.7193896687982, -122.391933349185)
74346	74346	200162	Undocumented 2	:: 54	1035 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013970.2124	2089969.4662	37.7194439323961	-122.393716023061	(37.7194439323961, -122.393716023061)
188973	188973	200161	Undocumented 2	:: 54	1083 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014425.6299	2089982.8806	37.7195060625081	-122.392142737787	(37.7195060625081, -122.392142737787)
176452	176452	200497	Undocumented 2	:: 54	1110 Gilman Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014977.2953	2089975.1673	37.7195154981888	-122.39023527774799	(37.7195154981888, -122.390235277748)
58301	58301	200156	Undocumented 2	:: 54	1047 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013914.5428	2090009.7093	37.7195513382693	-122.39391126933	(37.7195513382693, -122.39391126933)
52467	52467	200157	Undocumented 2	:: 54	1091 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014392.094	2090006.3557	37.7195686584119	-122.39226030100401	(37.7195686584119, -122.392260301004)
44928	44928	200155	Undocumented 2	:: 54	1091 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014363.9238	2090021.1115	37.719607610680704	-122.39235870744899	(37.7196076106807, -122.392358707449)
61127	61127	200498	Undocumented 2	:: 54	1055 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013869.6047	2090039.2209	37.7196298737115	-122.394068670065	(37.7196298737115, -122.394068670065)
29647	29647	200249	Undocumented 2	:: 54	1067 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013803.2037	2090093.549	37.7197753570889	-122.394301997885	(37.7197753570889, -122.394301997885)
39813	39813	200248	Undocumented 2	:: 54	1107 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014274.7183	2090092.8783	37.719799714154504	-122.392672078819	(37.7197997141545, -122.392672078819)
168550	168550	200246	Undocumented 2	:: 54	1071 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013781.7407	2090110.9877	37.719822047209	-122.394377408818	(37.719822047209, -122.394377408818)
28131	28131	200245	Undocumented 2	:: 54	1075 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013768.3263	2090118.3656	37.71984155975311	-122.394424294358	(37.7198415597531, -122.394424294358)
171950	171950	200244	Undocumented 2	:: 54	1123 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014193.5615	2090152.5722	37.7199591140845	-122.39295678576201	(37.7199591140845, -122.392956785762)
157610	157610	200239	Undocumented 2	:: 54	1131 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6014148.6234	2090188.791	37.7200560674381	-122.39311465541401	(37.7200560674381, -122.393114655414)
181617	181617	200202	Undocumented 2	:: 54	1090 Ingerson Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6013720.7054	2090215.6197	37.72010595277	-122.394595711042	(37.72010595277, -122.394595711042)
178876	178876	200201	Undocumented 2	:: 54	1090 Ingerson Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6013694.5474	2090234.3998	37.7201560648851	-122.394687445541	(37.7201560648851, -122.394687445541)
168399	168399	200213	Undocumented 2	:: 54	1101 Ingerson Ave	2	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013590.5861	2090251.1677	37.7201963256026	-122.395047981349	(37.7201963256026, -122.395047981349)
177939	177939	200226	Undocumented 2	:: 54	1131 Fitzgerald Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6015013.4132	2090222.9153	37.720197768832605	-122.390127728915	(37.7201977688326, -122.390127728915)
131768	131768	200212	Undocumented 2	:: 54	1101 Ingerson Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013545.647999999	2090276.655	37.720263809593604	-122.395205102903	(37.7202638095936, -122.395205102903)
172283	172283	200182	Undocumented 2	:: 54	1175 Ingerson Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6013359.1884	2090422.8715	37.720654919465396	-122.395859877099	(37.7206549194654, -122.395859877099)
40807	40807	200183	Undocumented 2	:: 54	1197 Hollister Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6013828.6909	2090422.2008	37.7206791862384	-122.39423689451401	(37.7206791862384, -122.394236894514)
185802	185802	200181	Undocumented 2	:: 54	1175 Ingerson Ave	1	Sidewalk: Property side : Yard 9	Tree 1	Private 1			0	Width 0ft		6013299.4945	2090456.4074	37.7207436812319	-122.396068570714	(37.7207436812319, -122.396068570714)
68850	68850	200507	Undocumented 2	:: 54	1510 Carroll Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6014614.4494	2091644.4715	37.724078943993	-122.39160616116199	(37.724078943993, -122.391606161162)
47025	47025	200502	Undocumented 2	:: 54	1500 Armstrong Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6014797.5113	2092210.0981	37.7256422016088	-122.39101285389098	(37.7256422016088, -122.391012853891)
182050	182050	200501	Undocumented 2	:: 54	1550 Armstrong Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6014687.5837	2092287.487	37.7258485955534	-122.39139827547399	(37.7258485955534, -122.391398275474)
135877	135877	199650	Undocumented 2	:: 54	0	1	: 4	Tree 1	Private 1			0	Width 0ft		6014963.58685	2093280.8179400002	37.728591398452394	-122.390513521988	(37.7285913984524, -122.390513521988)
183672	183672	200636	Undocumented 2	:: 54	1301 Quesada Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6016782.3625	2093458.8747	37.729181036936396	-122.384238246013	(37.7291810369364, -122.384238246013)
36680	36680	200762	Undocumented 2	:: 54	1999 Lane St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014632.1803	2093750.8421	37.7298635995705	-122.39169207228201	(37.7298635995705, -122.391692072282)
158995	158995	200766	Undocumented 2	:: 54	1901 Lane St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6014720.1223	2093871.3227	37.7301992962685	-122.39139646330901	(37.7301992962685, -122.391396463309)
154317	154317	200577	Undocumented 2	:: 54	1701 Keith St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6015592.5071	2093926.7262	37.7303998031535	-122.38838435336201	(37.7303998031535, -122.388384353362)
129662	129662	200808	Undocumented 2	:: 54	1401 Oakdale Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6016065.8568	2094678.3259	37.732489764259896	-122.386800296411	(37.7324897642599, -122.386800296411)
74359	74359	200626	Undocumented 2	:: 54	1370 Newcomb Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6016343.0854	2094895.2737	37.7331008048792	-122.38585695867201	(37.7331008048792, -122.385856958672)
187469	187469	200742	Undocumented 2	:: 54	1454 Oakdale Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6015834.4667	2094922.2745	37.733146784173606	-122.38761728786601	(37.7331467841736, -122.387617287866)
173333	173333	200730	Undocumented 2	:: 54	1466 Oakdale Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6015770.4184	2094966.2292	37.733263927070006	-122.387841787924	(37.73326392707, -122.387841787924)
135055	135055	200729	Undocumented 2	:: 54	1481 Oakdale Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6015678.7414	2094969.3688	37.7332674687178	-122.38815896225799	(37.7332674687178, -122.388158962258)
42125	42125	200722	Undocumented 2	:: 54	1476 Oakdale Ave	1	unknown : Yard 19	Tree 1	Private 1			0	Width 0ft		6015747.1852	2094980.6714	37.7333022953684	-122.387923119588	(37.7333022953684, -122.387923119588)
173497	173497	200570	Undocumented 2	:: 54	1445 La Salle Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6016341.8296	2095299.657	37.7342110910182	-122.38588947759399	(37.7342110910182, -122.385889477594)
74054	74054	185122	Undocumented 2	:: 54	2850 34th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985897.3509	2095993.4067	37.734384144878	-122.49119531195299	(37.734384144878, -122.491195311953)
183233	183233	186926	Undocumented 2	:: 54	2800 Sunset Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985157.2666	2096011.7096	37.734391129301	-122.493755335707	(37.734391129301, -122.493755335707)
33122	33122	185071	Undocumented 2	:: 54	2800 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984981.8139	2096034.5991	37.7344437114318	-122.49436361071899	(37.7344437114318, -122.494363610719)
58562	58562	185072	Undocumented 2	:: 54	2801 Sunset Blvd	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985073.9331	2096042.9736	37.73447209618271	-122.494045746017	(37.7344720961827, -122.494045746017)
33065	33065	185060	DPW Maintained 3	:: 54	10x El Mirasol Pl	1	Median : Cutout 11	Tree 1	DPW 2			0	Width 0ft		5987413.8008	2096060.1353	37.7346558528299	-122.485957413668	(37.7346558528299, -122.485957413668)
174948	174948	200699	Undocumented 2	:: 54	1501 Lane St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		6015860.7307	2095472.4329	37.734658863200295	-122.38756485421699	(37.7346588632003, -122.387564854217)
69532	69532	184973	Undocumented 2	:: 54	2701 Sunset Blvd	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5985060.7433	2096318.9125	37.7352289790934	-122.494111677716	(37.7352289790934, -122.494111677716)
30889	30889	245370	Undocumented 2	:: 54	3943 Mission St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6005173.0525	2095986.3930000002	37.7354723102432	-122.42455236124201	(37.7354723102432, -122.424552361242)
132272	132272	185049	Undocumented 2	:: 54	2731 41st Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5983672.3577	2096556.9514	37.7358012305935	-122.49892933938999	(37.7358012305935, -122.49892933939)
133705	133705	184974	Undocumented 2	:: 54	2700 37th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5984964.6462	2096531.6242	37.735807405046	-122.494459590864	(37.735807405046, -122.494459590864)
188648	188648	182915	Undocumented 2	:: 54	2711 47th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5981812.2124	2096648.8938	37.7359443944789	-122.505367292654	(37.7359443944789, -122.505367292654)
151546	151546	182946	Undocumented 2	:: 54	3500 Wawona St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5982068.7362	2096751.2664	37.7362405734928	-122.504487984804	(37.7362405734928, -122.504487984804)
29214	29214	182945	Undocumented 2	:: 54	2691 47th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5981809.5051	2096798.8146	37.7363558765881	-122.50538776138	(37.7363558765881, -122.50538776138)
154543	154543	182944	Undocumented 2	:: 54	2678 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981851.131	2096866.8374	37.7365450979685	-122.50524888568701	(37.7365450979685, -122.505248885687)
147162	147162	182943	Undocumented 2	:: 54	2674 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981850.1157	2096894.2496	37.7366203046104	-122.505254426993	(37.7366203046104, -122.505254426993)
137654	137654	182938	Undocumented 2	:: 54	2657 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981803.7519	2096965.6566	37.7368136403966	-122.505420015001	(37.7368136403966, -122.505420015001)
35754	35754	182933	Undocumented 2	:: 54	2646 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981845.0394	2097064.8142	37.7370883295038	-122.505284615423	(37.7370883295038, -122.505284615423)
48113	48113	185273	Undocumented 2	:: 54	2601 Sunset Blvd	6	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985037.6088	2097007.6084	37.7371186003252	-122.494242407159	(37.7371186003252, -122.494242407159)
74865	74865	182936	Undocumented 2	:: 54	2643 46th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5982105.6241	2097104.0711	37.737211448275794	-122.50438657908998	(37.7372114482758, -122.50438657909)
181678	181678	182929	Undocumented 2	:: 54	2635 47th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5981797.6603	2097141.2975	37.737295543609996	-122.50545409100799	(37.73729554361, -122.505454091008)
67752	67752	185275	Undocumented 2	:: 54	2600 37th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5984941.5117	2097207.3396	37.7376613847371	-122.494589373511	(37.7376613847371, -122.494589373511)
40189	40189	183398	Undocumented 2	:: 54	2676 23rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989291.1458	2097146.7716	37.7377487006662	-122.479546347444	(37.7377487006662, -122.479546347444)
41622	41622	183384	Undocumented 2	:: 54	2659 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5989243.3159	2097242.4314	37.7380085792734	-122.479718714161	(37.7380085792734, -122.479718714161)
34204	34204	183601	Undocumented 2	:: 54	2647 22nd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989550.5846	2097326.397	37.7382569723881	-122.47866248497401	(37.7382569723881, -122.478662484974)
41764	41764	183600	Undocumented 2	:: 54	2639 22nd Ave	2	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5989549.7171	2097348.9516	37.738318851123	-122.47866713334	(37.738318851123, -122.47866713334)
51779	51779	183592	Undocumented 2	:: 54	2626 26th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988353.2202	2097405.0036	37.738403211903204	-122.482808088928	(37.7384032119032, -122.482808088928)
29089	29089	183590	Undocumented 2	:: 54	2630 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5989282.842	2097424.4506	37.7385106529577	-122.47959536842899	(37.7385106529577, -122.479595368429)
155025	155025	245380	Undocumented 2	:: 54	3620 Mission St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		6005334.5439	2097112.3285	37.7385729952273	-122.424074069598	(37.7385729952273, -122.424074069598)
171810	171810	183571	Undocumented 2	:: 54	1950 Vicente St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986841.6497	2097598.0157	37.7388451080573	-122.48804847269699	(37.7388451080573, -122.488048472697)
69546	69546	183561	Undocumented 2	:: 54	1842 Vicente St	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5987180.92	2097610.4334	37.7388989899745	-122.486876361154	(37.7388989899745, -122.486876361154)
176431	176431	183053	Undocumented 2	:: 54	2601 19th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5990456.6898	2097547.4037	37.738916368412106	-122.47554578609	(37.7389163684121, -122.47554578609)
151024	151024	185250	Undocumented 2	:: 54	2582 33rd Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5986168.5104	2097675.5504	37.7390187057813	-122.49038154463301	(37.7390187057813, -122.490381544633)
130550	130550	183044	Undocumented 2	:: 54	2538 Lower Great Hwy	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			0	Width 0ft		5981509.8326	2097796.9898	37.739078951665704	-122.50649783936599	(37.7390789516657, -122.506497839366)
181628	181628	183542	Undocumented 2	:: 54	2598 27th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5988033.5951	2097670.443	37.7391134369583	-122.483932641735	(37.7391134369583, -122.483932641735)
167902	167902	185253	Undocumented 2	:: 54	2566 35th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			0	Width 0ft		5985543.2782	2097747.3201	37.739179229362705	-122.4925485642	(37.7391792293627, -122.4925485642)

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