Street_Tree_List

Data source: data.sfgov.org

136 rows where qSiteInfo = 7 and qSpecies = 47 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: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude ▼	Longitude	Location
7834	7834	119605	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	299x Avalon Ave	1	Front Yard : Yard 7	Tree 1	Private 1
183568	183568	176102	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	62 Tomaso Ct	5	Front Yard : Yard 7	Tree 1	Private 1			20	Width 8ft		6009173.04361	2086270.9274900001	37.709020763061396	-122.41003717048099	(37.7090207630614, -122.410037170481)
999	999	251422	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	480x De Long St		Front Yard : Yard 7	Tree 1	Private 1				3x3		5992963.0	2086633.0	37.709093057147996	-122.466087289133	(37.709093057148, -122.466087289133)
88589	88589	114269	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	800x BROTHERHOOD WAY	10	Front Yard : Yard 7	Tree 1	Private 1			38			5990271.0	2088582.0	37.7142888575797	-122.475533361779	(37.7142888575797, -122.475533361779)
91685	91685	114268	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	800x BROTHERHOOD WAY	9	Front Yard : Yard 7	Tree 1	Private 1			30			5990271.0	2088582.0	37.7142888575797	-122.475533361779	(37.7142888575797, -122.475533361779)
114769	114769	114267	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	800x BROTHERHOOD WAY	8	Front Yard : Yard 7	Tree 1	Private 1			50			5990271.0	2088582.0	37.7142888575797	-122.475533361779	(37.7142888575797, -122.475533361779)
41942	41942	176158	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	825 Brotherhood Way	2	Front Yard : Yard 7	Tree 1	Private 1			27	Width 0ft		5989484.91598	2088634.67131	37.7143878792713	-122.47825419477199	(37.7143878792713, -122.478254194772)
168599	168599	176157	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	999 Brotherhood Way	2	Front Yard : Yard 7	Tree 1	Private 1			25	Width 0ft		5988327.5004199995	2088688.82584	37.714469318273004	-122.482258598878	(37.714469318273, -122.482258598878)
160062	160062	176162	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	301 Naglee Ave	1	Front Yard : Yard 7	Tree 1	Private 1			30	Width 10ft		5997669.17463	2088536.7397200002	37.7145906808916	-122.449959233558	(37.7145906808916, -122.449959233558)
115560	115560	109453	Permitted Site 1	Cupressus macrocarpa :: Monterey Cypress 47	951 GILMAN AVE	1	Front Yard : Yard 7	Tree 1	Rec/Park 3		03/24/2015 12:00:00 AM	3		Permit Number 774986	6015934.0	2089205.0	37.717453787650705	-122.38687458595501	(37.7174537876507, -122.386874585955)
117533	117533	105764	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1X GONZALEZ DR	1	Front Yard : Yard 7	Tree 1	Private 1						5990111.8	2090190.8	37.718696994740704	-122.476201051717	(37.7186969947407, -122.476201051717)
143237	143237	104888	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	146 Gonzalez Dr	1	Front Yard : Yard 7	Tree 1	Private 1						5990401.0	2090562.0	37.719732984351396	-122.475228499286	(37.7197329843514, -122.475228499286)
98711	98711	105649	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	3 Gonzalez Dr	1	Front Yard : Yard 7	Tree 1	Private 1						5990274.6	2090665.2	37.7200090188364	-122.475672946469	(37.7200090188364, -122.475672946469)
89354	89354	111589	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	730X Lake Merced Blvd	5	Front Yard : Yard 7	Tree 1	DPW for City Agency 10	DPW 4				Permit Number 774260	5987577.495069999	2091187.90071	37.7212874908284	-122.485034126397	(37.7212874908284, -122.485034126397)
92075	92075	111588	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	730X Lake Merced Blvd	4	Front Yard : Yard 7	Tree 1	DPW for City Agency 10	DPW 4		48			5987577.495069999	2091187.90071	37.7212874908284	-122.485034126397	(37.7212874908284, -122.485034126397)
108351	108351	106363	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	101 URBANO DR	1	Front Yard : Yard 7	Tree 1	Private 1			80			5993535.8	2092458.1	37.7251204132224	-122.464530299025	(37.7251204132224, -122.464530299025)
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)
4923	4923	253718	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	227 Madison St	1	Front Yard : Yard 7	Tree 1	Private 1				3x3		6005690.0	2092595.0	37.726189474375204	-122.422524168298	(37.7261894743752, -122.422524168298)
78509	78509	102745	Property Tree 7	Cupressus macrocarpa :: Monterey Cypress 47	222 Moncada Way	1	Front Yard : Yard 7	Tree 1	Private 1						5992354.0	2093377.4	37.727576385896604	-122.468682482409	(37.7275763858966, -122.468682482409)
62231	62231	176114	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	10 Zoo Rd	1	Front Yard : Yard 7	Tree 1	Private 1			24	Width 10ft		5982696.49512	2094384.4536	37.729778850703894	-122.502142508582	(37.7297788507039, -122.502142508582)
131626	131626	206850	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Cranleigh Dr	11	Front Yard : Yard 7	Tree 1	Private 1			13	Width 0ft		5991355.50473	2095693.7152900002	37.733878673758504	-122.472303038149	(37.7338786737585, -122.472303038149)
58790	58790	205909	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	14 Martha Ave	1	Front Yard : Yard 7	Tree 1	Private 1			56			6000896.43949	2095509.3176099998	37.733919926568106	-122.43930400388399	(37.7339199265681, -122.439304003884)
170501	170501	205908	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	22 Martha Ave	1	Front Yard : Yard 7	Tree 1	Private 1			50			6000855.4988	2095527.0411599998	37.733966261424	-122.43944681802799	(37.733966261424, -122.439446818028)
179027	179027	205907	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	30 Martha Ave	1	Front Yard : Yard 7	Tree 1	Private 1			34			6000842.20104	2095534.19328	37.7339851426839	-122.439493304878	(37.7339851426839, -122.439493304878)
178194	178194	217837	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Cranleigh Dr	27	Front Yard : Yard 7	Tree 1	Private 1			1			5991408.51822	2095817.51986	37.7342216778764	-122.472128777417	(37.7342216778764, -122.472128777417)
60460	60460	217838	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Cranleigh Dr	28	Front Yard : Yard 7	Tree 1	Private 1			1			5991394.82586	2095823.8530599999	37.7342382748577	-122.47217657729799	(37.7342382748577, -122.472176577298)
161565	161565	206849	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Cranleigh Dr	14	Front Yard : Yard 7	Tree 1	Private 1			3	Width 0ft		5991370.13316	2095847.8474599998	37.7343027283865	-122.47226369552601	(37.7343027283865, -122.472263695526)
31808	31808	217840	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Cranleigh Dr	30	Front Yard : Yard 7	Tree 1	Private 1			1			5991415.56175	2095863.71205	37.7343489175724	-122.47210779175501	(37.7343489175724, -122.472107791755)
159135	159135	217841	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Cranleigh Dr	31	Front Yard : Yard 7	Tree 1	Private 1			1			5991404.95504	2095888.4488	37.7344162246301	-122.472146264739	(37.7344162246301, -122.472146264739)
124189	124189	113065	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2X Cranleigh Dr	6	Front Yard : Yard 7	Tree 1	DPW 2		08/18/2016 09:51:00 AM	3			5991370.3	2095943.7	37.734565924896394	-122.472270103664	(37.7345659248964, -122.472270103664)
138302	138302	113064	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	2X Cranleigh Dr	5	Front Yard : Yard 7	Tree 1	DPW 2		08/18/2016 09:54:00 AM	3			5991370.3	2095943.7	37.734565924896394	-122.472270103664	(37.7345659248964, -122.472270103664)
150471	150471	201721	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Lindsay Cir	2	Front Yard : Yard 7	Tree 1	Private 1			26			6016317.40109	2095614.0815400002	37.7350730858367	-122.385995846031	(37.7350730858367, -122.385995846031)
71400	71400	223722	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	201 College Ave	1	Front Yard : Yard 7	Tree 1	Private 1			13	Width 2ft		6005269.83523	2095874.10119	37.735169447301104	-122.424209762894	(37.7351694473011, -122.424209762894)
126172	126172	223721	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	201 College Ave	2	Front Yard : Yard 7	Tree 1	Private 1			18	Width 2ft		6005265.6215699995	2095876.8454099998	37.7351767443941	-122.424224526166	(37.7351767443941, -122.424224526166)
131336	131336	223709	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 San Jose Ave	12	Front Yard : Yard 7	Tree 1	Private 1			24			6004249.02504	2095933.99045	37.7352761977326	-122.42774334037901	(37.7352761977326, -122.427743340379)
46888	46888	223710	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 San Jose Ave	13	Front Yard : Yard 7	Tree 1	Private 1			67			6004258.36813	2095937.1689	37.735285453551604	-122.427711264267	(37.7352854535516, -122.427711264267)
153445	153445	223711	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 San Jose Ave	43	Front Yard : Yard 7	Tree 1	Private 1			27			6004453.96026	2096061.62765	37.7356382512944	-122.42704389176201	(37.7356382512944, -122.427043891762)
53546	53546	223712	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 San Jose Ave	75	Front Yard : Yard 7	Tree 1	Private 1			59			6004557.86024	2096180.22234	37.7359697602838	-122.426693112116	(37.7359697602838, -122.426693112116)
77269	77269	223713	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 San Jose Ave	81	Front Yard : Yard 7	Tree 1	Private 1			52			6004590.4575	2096203.6023099998	37.7360357993049	-122.426582074619	(37.7360357993049, -122.426582074619)
30126	30126	223714	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1201 San Jose Ave	82	Front Yard : Yard 7	Tree 1	Private 1			34			6004606.42672	2096213.68372	37.736064383369396	-122.42652758019699	(37.7360643833694, -122.426527580197)
35196	35196	223693	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1501 San Jose Ave	2	Front Yard : Yard 7	Tree 1	Private 1			50			6004632.33856	2096219.1037400002	37.736080730338394	-122.426438378246	(37.7360807303384, -122.426438378246)
53725	53725	223707	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1200 San Jose Ave	1	Front Yard : Yard 7	Tree 1	Private 1			37			6004449.31264	2096325.41802	37.7363622972844	-122.42707874320699	(37.7363622972844, -122.427078743207)
34710	34710	223715	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1101 San Jose Ave	10	Front Yard : Yard 7	Tree 1	Private 1			17			6004750.57812	2096360.89303	37.736476735096296	-122.426039666491	(37.7364767350963, -122.426039666491)
47893	47893	223716	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1101 San Jose Ave	12	Front Yard : Yard 7	Tree 1	Private 1			18			6004761.80581	2096370.25265	37.7365030690611	-122.42600151366399	(37.7365030690611, -122.426001513664)
152844	152844	223706	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	80	Front Yard : Yard 7	Tree 1	Private 1			4			6004536.52923	2096375.8684900003	37.736505754442504	-122.42678079059999	(37.7365057544425, -122.4267807906)
181738	181738	223705	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	79	Front Yard : Yard 7	Tree 1	Private 1			50			6004537.44257	2096386.8120900001	37.7365358547364	-122.426778411906	(37.7365358547364, -122.426778411906)
137317	137317	223704	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	78	Front Yard : Yard 7	Tree 1	Private 1			40			6004560.21701	2096406.8969299998	37.7365922907993	-122.426701100777	(37.7365922907993, -122.426701100777)
49562	49562	223703	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	77	Front Yard : Yard 7	Tree 1	Private 1			18			6004573.37155	2096423.41392	37.7366383864359	-122.426656795699	(37.7366383864359, -122.426656795699)
159461	159461	223702	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	76	Front Yard : Yard 7	Tree 1	Private 1			26			6004596.80195	2096429.4382	37.7366562523786	-122.426576215516	(37.7366562523786, -122.426576215516)
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)
33033	33033	223700	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	37	Front Yard : Yard 7	Tree 1	Private 1			32			6004786.16622	2096652.60405	37.7372797190785	-122.42593738210199	(37.7372797190785, -122.425937382102)
137779	137779	223717	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1101 San Jose Ave	58	Front Yard : Yard 7	Tree 1	Private 1			55			6005027.45143	2096662.24212	37.737319816266705	-122.425103832873	(37.7373198162667, -122.425103832873)
166767	166767	223718	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1101 San Jose Ave	59	Front Yard : Yard 7	Tree 1	Private 1			4			6005036.8773300005	2096676.581	37.7373597200698	-122.42507226308999	(37.7373597200698, -122.42507226309)
132735	132735	223694	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1001 San Jose Ave	8	Front Yard : Yard 7	Tree 1	Private 1			65			6005104.45792	2096735.8383799999	37.7375262448502	-122.424842819945	(37.7375262448502, -122.424842819945)
25090	25090	223699	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	2	Front Yard : Yard 7	Tree 1	Private 1			72			6004901.063490001	2096745.81285	37.737542142145706	-122.425546760699	(37.7375421421457, -122.425546760699)
58052	58052	223695	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1001 San Jose Ave	10	Front Yard : Yard 7	Tree 1	Private 1			37			6005104.91543	2096758.07935	37.73758733938811	-122.42484281995701	(37.7375873393881, -122.424842819957)
152523	152523	223698	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1100 San Jose Ave	1	Front Yard : Yard 7	Tree 1	Private 1			151			6004903.42732	2096771.39372	37.7376125150086	-122.42554040785801	(37.7376125150086, -122.425540407858)
35718	35718	223696	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1001 San Jose Ave	13	Front Yard : Yard 7	Tree 1	Private 1			23			6005111.39586	2096784.72517	37.7376608688401	-122.42482230911999	(37.7376608688401, -122.42482230912)
116468	116468	103351	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	15X Highland Ave	1	Front Yard : Yard 7	Tree 1	DPW 2			18			6004989.3	2096795.8	37.73768438084971	-122.42524524109	(37.7376843808497, -122.42524524109)
145393	145393	98880	Property Tree 7	Cupressus macrocarpa :: Monterey Cypress 47	101 Lansdale Ave	1	Front Yard : Yard 7	Tree 1	Private 1			11			5994747.9	2097283.1	37.738438484278895	-122.460689725403	(37.7384384842789, -122.460689725403)
146111	146111	223697	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1001 San Jose Ave	50	Front Yard : Yard 7	Tree 1	Private 1			50			6005304.12461	2097202.65687	37.738819299062904	-122.424185667341	(37.7388192990629, -122.424185667341)
120332	120332	103422	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	1365 Portola Dr	1	Front Yard : Yard 7	Tree 1	Private 1					Permit Number 769779	5993416.2	2097683.7	37.7394617231066	-122.46532315146601	(37.7394617231066, -122.465323151466)
10256	10256	173933	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	190 Beacon St	1	Front Yard : Yard 7	Tree 1	Private 1						6003193.0	2097540.0	37.739626138558705	-122.43150902083299	(37.7396261385587, -122.431509020833)
144598	144598	99662	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	1337 Portola Dr	1	Front Yard : Yard 7	Tree 1	Private 1						5993559.3	2097744.3	37.7396363671104	-122.46483277796801	(37.7396363671104, -122.464832777968)
102194	102194	101037	DPW Maintained 3	Cupressus macrocarpa :: Monterey Cypress 47	1010X Portola Dr	11	Front Yard : Yard 7	Tree 1	DPW 2						5995923.3	2098391.5	37.7415494342357	-122.45670592621	(37.7415494342357, -122.45670592621)
46071	46071	223740	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1760 Diamond St	6	Front Yard : Yard 7	Tree 1	Private 1			18			6002036.21609	2098593.82428	37.742454062002395	-122.43558404729299	(37.7424540620024, -122.435584047293)
170171	170171	223739	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1760 Diamond St	5	Front Yard : Yard 7	Tree 1	Private 1			25			6002032.6649400005	2098618.50085	37.7425216163939	-122.43559809108	(37.7425216163939, -122.43559809108)
170407	170407	223738	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1760 Diamond St	4	Front Yard : Yard 7	Tree 1	Private 1			40			6002028.666809999	2098687.0013900003	37.742709475762894	-122.43561681495899	(37.7427094757629, -122.435616814959)
176669	176669	223743	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	65 Zircon Pl	2	Front Yard : Yard 7	Tree 1	Private 1			45			6002363.70914	2098682.85125	37.7427171047157	-122.434458039421	(37.7427171047157, -122.434458039421)
185302	185302	223737	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1760 Diamond St	3	Front Yard : Yard 7	Tree 1	Private 1			23			6002025.38373	2098740.99425	37.7428575410441	-122.43563202880699	(37.7428575410441, -122.435632028807)
122020	122020	223736	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1760 Diamond St	2	Front Yard : Yard 7	Tree 1	Private 1			38			6002022.64455	2098766.1332	37.7429264111321	-122.435643298224	(37.7429264111321, -122.435643298224)
49820	49820	223735	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	1760 Diamond St	1	Front Yard : Yard 7	Tree 1	Private 1			34			6002021.50784	2098799.04405	37.7430167120556	-122.43564958267	(37.7430167120556, -122.43564958267)
122936	122936	107159	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	1000 ESMERALDA AVE		Front Yard : Yard 7	Tree 1	Private 1						6009839.0	2098688.0	37.7431527400861	-122.408610872619	(37.7431527400861, -122.408610872619)
148628	148628	248051	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	25 Rutledge St	1	Front Yard : Yard 7	Tree 1	Private 1			24			6010607.1512400005	2099382.29757	37.745102122072396	-122.406003697633	(37.7451021220724, -122.406003697633)
71003	71003	223708	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	220 Coso Ave	1	Front Yard : Yard 7	Tree 1	Private 1			17			6007533.84485	2099558.41005	37.7454133189685	-122.416643154074	(37.7454133189685, -122.416643154074)
148452	148452	247988	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	124 Mullen Ave	2	Front Yard : Yard 7	Tree 1	Private 1			29	Width 10ft		6009878.9446	2099816.70211	37.746254146420796	-122.40855235741199	(37.7462541464208, -122.408552357412)
25672	25672	247989	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	130 Mullen Ave	1	Front Yard : Yard 7	Tree 1	Private 1			15	Width 10ft		6009899.29934	2099821.3308900003	37.7462679959733	-122.40848229933901	(37.7462679959733, -122.408482299339)
65231	65231	247990	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	130 Mullen Ave	2	Front Yard : Yard 7	Tree 1	Private 1			21	Width 10ft		6009904.82703	2099823.3195700003	37.7462737660155	-122.40846332542499	(37.7462737660155, -122.408463325425)
34768	34768	247991	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	130 Mullen Ave	3	Front Yard : Yard 7	Tree 1	Private 1			25	Width 10ft		6009914.62518	2099827.74346	37.7462864617583	-122.408429756449	(37.7462864617583, -122.408429756449)
90230	90230	98140	Property Tree 7	Cupressus macrocarpa :: Monterey Cypress 47	315 San Marcos Ave		Front Yard : Yard 7	Tree 1	Private 1						5992920.8	2100212.1	37.746375486546704	-122.467219803339	(37.7463754865467, -122.467219803339)
2848	2848	253255	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	270 Castenada Ave	2	Front Yard : Yard 7	Tree 1	Private 1				10x10		5994049.0	2100330.0	37.746764271907	-122.46332720271201	(37.746764271907, -122.463327202712)
131402	131402	190979	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Tulare St	26	Front Yard : Yard 7	Tree 1	Private 1			10			6016095.64833	2100226.2738200002	37.747724948962606	-122.387084119257	(37.7477249489626, -122.387084119257)
159881	159881	190980	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Tulare St	25	Front Yard : Yard 7	Tree 1	Private 1			13			6016106.6833	2100234.37898	37.747747815104205	-122.387046525793	(37.7477478151042, -122.387046525793)
76851	76851	190981	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Tulare St	24	Front Yard : Yard 7	Tree 1	Private 1			17			6016079.678669999	2100249.91321	37.7477889734994	-122.38714099058998	(37.7477889734994, -122.38714099059)
157706	157706	190985	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Tulare St	17	Front Yard : Yard 7	Tree 1	Private 1			13			6016130.05616	2100249.9564799997	37.747791881903	-122.386966789196	(37.747791881903, -122.386966789196)
24493	24493	190983	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Tulare St	20	Front Yard : Yard 7	Tree 1	Private 1			15			6016115.94828	2100251.3725900003	37.7477949890666	-122.387015672733	(37.7477949890666, -122.387015672733)
167641	167641	190982	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Tulare St	23	Front Yard : Yard 7	Tree 1	Private 1			34			6016087.28584	2100258.68622	37.7478134836207	-122.387115296958	(37.7478134836207, -122.387115296958)
24654	24654	190986	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Tulare St	16	Front Yard : Yard 7	Tree 1	Private 1			23			6016149.69105	2100259.24355	37.747818469462	-122.38689953970601	(37.747818469462, -122.386899539706)
158990	158990	190984	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	2 Tulare St	19	Front Yard : Yard 7	Tree 1	Private 1			17			6016127.79585	2100261.1881	37.747822596447705	-122.38697538852502	(37.7478225964477, -122.386975388525)
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)
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)
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)
135200	135200	223752	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	3944 22nd St	8	Front Yard : Yard 7	Tree 1	Private 1			16			6002172.64124	2102975.1005599997	37.754491758314295	-122.435425673069	(37.7544917583143, -122.435425673069)
139692	139692	99826	Significant Tree 6	Cupressus macrocarpa :: Monterey Cypress 47	1 Cascade Walk	1	Front Yard : Yard 7	Tree 1	Private 1						5992183.1	2103187.3	37.7545020044945	-122.469987253468	(37.7545020044945, -122.469987253468)
145874	145874	100769	Undocumented 2	Cupressus macrocarpa :: Monterey Cypress 47	3701 21st St		Front Yard : Yard 7	Tree 1	Private 1			55		Street tree w/in RoW	6003717.0	2103606.0	37.7563116466144	-122.43012988292	(37.7563116466144, -122.43012988292)

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