Street_Tree_List

Data source: data.sfgov.org

818 rows where qSpecies = 30 sorted by SiteOrder descending

Search:

- remove filter - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by TreeID Sort by qLegalStatus Sort by qSpecies Sort by qAddress Sort by SiteOrder Sort by qSiteInfo Sort by PlantType Sort by qCaretaker Sort by qCareAssistant Sort by PlantDate Sort by DBH Sort by PlotSize Sort by PermitNotes Sort by XCoord Sort by YCoord Sort by Latitude Sort by Longitude Sort by Location

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize

Link	rowid	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder ▲	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
74356	74356	186817	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1200 Sunset Blvd	110	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5984826.8059	2106810.865	37.7640233139964	-122.49569412937599	(37.7640233139964, -122.495694129376)
44798	44798	227608	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1201 San Jose Ave	73	Front Yard : Yard 7	Tree 1	Private 1			3			6004572.06439	2096162.43718	37.7359217292935	-122.426642736581	(37.7359217292935, -122.426642736581)
71134	71134	187130	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2600 Sunset Blvd	66	Sidewalk: Property side : Yard 9	Tree 1	Private 1			1	Width 0ft		5985156.874	2097417.7557	37.73825173359629	-122.49386027578899	(37.7382517335963, -122.493860275789)
184382	184382	227607	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1201 San Jose Ave	61	Front Yard : Yard 7	Tree 1	Private 1			2			6004513.177130001	2096122.0643	37.735807545078295	-122.426843458979	(37.7358075450783, -122.426843458979)
54300	54300	227606	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1201 San Jose Ave	60	Front Yard : Yard 7	Tree 1	Private 1			3			6004509.90475	2096122.13365	37.7358075504724	-122.426854777822	(37.7358075504724, -122.426854777822)
36009	36009	186909	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2700 Sunset Blvd	58	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985192.0104	2096702.7177	37.7362904860675	-122.49368611859501	(37.7362904860675, -122.493686118595)
165842	165842	227605	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1201 San Jose Ave	58	Front Yard : Yard 7	Tree 1	Private 1			2			6004504.61589	2096121.06345	37.735804312902204	-122.426872987299	(37.7358043129022, -122.426872987299)
159621	159621	186908	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2700 Sunset Blvd	57	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985188.8014	2096694.9245	37.736268900285	-122.493696639188	(37.736268900285, -122.493696639188)
166757	166757	227604	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1201 San Jose Ave	57	Front Yard : Yard 7	Tree 1	Private 1			4			6004502.9106	2096117.99556	37.7357957927473	-122.426878664735	(37.7357957927473, -122.426878664735)
26504	26504	227603	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1201 San Jose Ave	55	Front Yard : Yard 7	Tree 1	Private 1			2			6004504.07862	2096101.1879099999	37.735749708773795	-122.42687342978998	(37.7357497087738, -122.42687342979)
184269	184269	227602	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1201 San Jose Ave	54	Front Yard : Yard 7	Tree 1	Private 1			1			6004494.61967	2096104.27773	37.735757657887994	-122.426906353066	(37.735757657888, -122.426906353066)
161451	161451	227601	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1100 San Jose Ave	48	Sidewalk: Property side : Yard 9	Tree 1	Private 1			13			6004769.19859	2096667.0685	37.7373184762576	-122.425997076417	(37.7373184762576, -122.425997076417)
43531	43531	191264	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	801 Arkansas St	30	Sidewalk: Property side : Yard 9	Tree 1	Private 1			19			6013055.03201	2103799.19748	37.7573665842245	-122.39784906707399	(37.7573665842245, -122.397849067074)
60646	60646	191259	DPW Maintained 3	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	900x Carolina St	27	Median : Yard 3	Tree 1	DPW 2			17			6012470.08805	2103421.28043	37.7562963136528	-122.39984551077299	(37.7562963136528, -122.399845510773)
89862	89862	99399	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1590 Yosemite Ave	22	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/09/2012 12:00:00 AM		3x3	Permit Number 768917	6014911.1	2092490.7	37.726418980855996	-122.390639783135	(37.726418980856, -122.390639783135)
113044	113044	99398	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1590 Yosemite Ave	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/09/2012 12:00:00 AM		3x3	Permit Number 768917	6014911.1	2092490.7	37.726418980855996	-122.390639783135	(37.726418980856, -122.390639783135)
150569	150569	129445	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	24 Priest St	21	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			9	Width 3ft		6008315.59279	2117230.60537	37.793980966003	-122.415190714801	(37.793980966003, -122.415190714801)
115661	115661	99395	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1590 Yosemite Ave	18	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/09/2012 12:00:00 AM		3x3	Permit Number 768917	6014911.1	2092490.7	37.726418980855996	-122.390639783135	(37.726418980856, -122.390639783135)
102408	102408	101353	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	600 Chestnut St	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/1993 12:00:00 AM			Permit Number 32655	6008949.0	2120797.0	37.8038089789489	-122.41325137117902	(37.8038089789489, -122.413251371179)
142142	142142	99394	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1590 Yosemite Ave	17	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/09/2012 12:00:00 AM		3x3	Permit Number 768917	6014911.1	2092490.7	37.726418980855996	-122.390639783135	(37.726418980856, -122.390639783135)
89315	89315	99393	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1590 Yosemite Ave	16	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/09/2012 12:00:00 AM		3x3	Permit Number 768917	6014911.1	2092490.7	37.726418980855996	-122.390639783135	(37.726418980856, -122.390639783135)
34951	34951	191312	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	15	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 5ft		6015149.38015	2107824.64473	37.768536003056504	-122.390887249657	(37.7685360030565, -122.390887249657)
41440	41440	191311	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6015151.76995	2107799.07376	37.76846592338129	-122.39087719613501	(37.7684659233813, -122.390877196135)
92502	92502	101350	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	600 Chestnut St	14	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/1993 12:00:00 AM			Permit Number 32655	6008949.0	2120797.0	37.8038089789489	-122.41325137117902	(37.8038089789489, -122.413251371179)
131490	131490	191310	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	13	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015152.46863	2107768.27489	37.7683813952045	-122.390872626697	(37.7683813952045, -122.390872626697)
157008	157008	187077	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2600 Sunset Blvd	13	Sidewalk: Property side : Yard 9	Tree 1	Private 1			2	Width 0ft		5985155.4633	2096938.6014	37.736936021545	-122.493829852855	(37.736936021545, -122.493829852855)
28130	28130	191253	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	654 Minnesota St	12	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 10ft		6015148.44265	2105367.15882	37.7617882296504	-122.39071873558599	(37.7617882296504, -122.390718735586)
182608	182608	191309	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	12	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015155.3814900005	2107742.43002	37.768310592479	-122.390860744836	(37.768310592479, -122.390860744836)
42249	42249	105036	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1550 04th St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	6x6	Permit Number 771181	6015089.32821	2107914.09587	37.7687782840212	-122.39110121906201	(37.7687782840212, -122.391101219062)
56989	56989	191308	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			5	Width 5ft		6015156.6298	2107712.6724	37.768228953839895	-122.390854347073	(37.7682289538399, -122.390854347073)
97235	97235	4548	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	66 Cleary Ct	11	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	3X3		6004823.98553	2113713.43923	37.784126867550995	-122.427021407244	(37.784126867551, -122.427021407244)
29379	29379	105035	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1550 04th St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	6x6		6015087.4436800005	2107939.01173	37.768846592924	-122.391109479333	(37.768846592924, -122.391109479333)
56239	56239	191252	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	654 Minnesota St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			3	Width 10ft		6015147.22099	2105373.94992	37.761806808764796	-122.390723435452	(37.7618068087648, -122.390723435452)
64448	64448	200105	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1528 Yosemite Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6014949.7328	2092444.2049	37.7262934578304	-122.39050298275801	(37.7262934578304, -122.390502982758)
67462	67462	191307	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015158.98774	2107685.52339	37.76815453943829	-122.390844293528	(37.7681545394383, -122.390844293528)
114337	114337	99387	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1590 Yosemite Ave	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/09/2012 12:00:00 AM		3x3	Permit Number 768917	6014911.1	2092490.7	37.726418980855996	-122.390639783135	(37.726418980856, -122.390639783135)
119172	119172	4547	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	66 Cleary Ct	10	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	3X3		6004823.98553	2113713.43923	37.784126867550995	-122.427021407244	(37.784126867551, -122.427021407244)
162520	162520	227662	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	32 Harry St	10	Sidewalk: Property side : Yard 9	Tree 1	Private 1			4	Width 10ft		6003182.99622	2097643.55659	37.7399099141156	-122.43155100069099	(37.7399099141156, -122.431551000691)
52001	52001	200104	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1528 Yosemite Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6014963.9454	2092431.3459	37.726258938018	-122.39045295200899	(37.726258938018, -122.390452952009)
57630	57630	191251	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	654 Minnesota St	9	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 10ft		6015148.84129	2105378.48456	37.7618193498029	-122.39071814833599	(37.7618193498029, -122.390718148336)
83610	83610	105034	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1550 04th St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				6x6		6015094.5	2108059.1	37.7691767205026	-122.391093466638	(37.7691767205026, -122.391093466638)
97837	97837	4519	DPW Maintained 3	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	20X Cleary Ct	9	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		01/29/2015 11:31:00 AM	12	3x3		6004999.51904	2113885.82273	37.7846101140023	-122.42642640211099	(37.7846101140023, -122.426426402111)
110341	110341	99386	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1590 Yosemite Ave	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/09/2012 12:00:00 AM		3x3	Permit Number 768917	6014911.1	2092490.7	37.726418980855996	-122.390639783135	(37.726418980856, -122.390639783135)
137511	137511	191306	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015160.53731	2107657.60104	37.7680779567607	-122.39083698203899	(37.7680779567607, -122.390836982039)
162169	162169	101345	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	600 Chestnut St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/01/1993 12:00:00 AM	22		Permit Number 32655	6008773.8267	2120774.1665	37.803736447762795	-122.413855954453	(37.8037364477628, -122.413855954453)
169237	169237	191278	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6014098.280590001	2110942.62046	37.777038889768896	-122.39474132397801	(37.7770388897689, -122.394741323978)
172150	172150	94214	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	465 Missouri St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/22/2010 12:00:00 AM	3	3x3	Permit Number 53589	6013545.016969999	2104957.62874	37.7605746593094	-122.396235681545	(37.7605746593094, -122.396235681545)
177608	177608	191346	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1550 04th St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015085.76507	2107965.02098	37.768917915461294	-122.391117103785	(37.7689179154613, -122.391117103785)
181554	181554	191329	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1507 04th St	9	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6015112.65717	2108516.8034	37.7704344808868	-122.39106265703501	(37.7704344808868, -122.391062657035)
24380	24380	129424	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2129 Vallejo St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			18	Width 4ft		6003346.86179	2117886.37825	37.7955010594853	-122.43242986946699	(37.7955010594853, -122.432429869467)
36838	36838	191250	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	654 Minnesota St	8	Sidewalk: Property side : Yard 9	Tree 1	Private 1			5	Width 10ft		6015147.38841	2105382.23529	37.7618295678896	-122.390723435432	(37.7618295678896, -122.390723435432)
37197	37197	191320	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1505 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6015132.04881	2108165.57051	37.769471148715894	-122.39097102870701	(37.7694711487159, -122.390971028707)
51582	51582	191305	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015162.58842	2107628.3532	37.767997762404	-122.390827843133	(37.767997762404, -122.390827843133)
55487	55487	129414	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2501 Jackson St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 3ft		6001550.43955	2116611.49961	37.791898545338896	-122.438554394686	(37.7918985453389, -122.438554394686)
58087	58087	191328	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1507 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6015112.5325	2108491.8646	37.770365997518894	-122.391061344907	(37.7703659975189, -122.391061344907)
61696	61696	4545	DPW Maintained 3	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	66 Cleary Ct	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6004823.98553	2113713.43923	37.784126867550995	-122.427021407244	(37.784126867551, -122.427021407244)
71788	71788	191354	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1750 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015105.755890001	2107627.1199	37.7679912225533	-122.39102433602899	(37.7679912225533, -122.391024336029)
72025	72025	191277	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			7	Width 3ft		6014120.49796	2110919.7593900003	37.7769773536703	-122.394662865301	(37.7769773536703, -122.394662865301)
87087	87087	4518	DPW Maintained 3	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	20X Cleary Ct	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6004999.51904	2113885.82273	37.7846101140023	-122.42642640211099	(37.7846101140023, -122.426426402111)
100937	100937	105033	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1550 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				6x6		6015094.5	2108059.1	37.7691767205026	-122.391093466638	(37.7691767205026, -122.391093466638)
108977	108977	99385	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1590 Yosemite Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/09/2012 12:00:00 AM		3x3	Permit Number 768917	6014911.1	2092490.7	37.726418980855996	-122.390639783135	(37.726418980856, -122.390639783135)
120116	120116	102568	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1655X 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6015154.2	2107704.9	37.768207477714896	-122.39086220831899	(37.7682074777149, -122.390862208319)
136667	136667	191345	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1550 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015084.02733	2107988.1043	37.7689812007549	-122.391124728238	(37.7689812007549, -122.391124728238)
173859	173859	191343	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1450 04th St	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6015066.17772	2108313.11356	37.769872614151396	-122.39120919074499	(37.7698726141514, -122.391209190745)
176268	176268	200103	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1528 Yosemite Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6014982.2186	2092417.8102	37.72622278535071	-122.390388836652	(37.7262227853507, -122.390388836652)
28179	28179	227598	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	501 14th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6005393.4683	2107800.6400599997	37.7679239451627	-122.424630446843	(37.7679239451627, -122.424630446843)
53688	53688	191342	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1450 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6015064.99922	2108338.84414	37.769943199256794	-122.391215066031	(37.7699431992568, -122.391215066031)
53758	53758	191344	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1550 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015083.2703599995	2108014.27768	37.769053025099105	-122.39112917626998	(37.7690530250991, -122.39112917627)
61026	61026	191297	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	740 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 2ft		6014617.26494	2110308.92783	37.7753277532976	-122.39290163570101	(37.7753277532976, -122.392901635701)
68001	68001	191319	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1505 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015133.57873	2108141.42692	37.7694049406179	-122.390964049067	(37.7694049406179, -122.390964049067)
71984	71984	191276	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	659 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 3ft		6014137.59227	2110902.38763	37.776930605110394	-122.394602513603	(37.7769306051104, -122.394602513603)
75466	75466	129435	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2201 Clay St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 4ft		6004184.0136	2116319.13373	37.7912452400168	-122.429421362005	(37.7912452400168, -122.429421362005)
76125	76125	191361	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1780 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6015122.97696	2107297.48765	37.767087080134395	-122.39094172878401	(37.7670870801344, -122.390941728784)
102467	102467	105032	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1550 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				6x6		6015094.5	2108059.1	37.7691767205026	-122.391093466638	(37.7691767205026, -122.391093466638)
121400	121400	102560	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1755X 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6015173.7	2107354.9	37.767247536270204	-122.390770296702	(37.7672475362702, -122.390770296702)
136784	136784	129423	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2129 Vallejo St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			12	Width 4ft		6003338.49011	2117887.74598	37.795504340202896	-122.432458934629	(37.7955043402029, -122.432458934629)
138646	138646	4517	DPW Maintained 3	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	20X Cleary Ct	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			6	3X3		6004999.51904	2113885.82273	37.7846101140023	-122.42642640211099	(37.7846101140023, -122.426426402111)
144534	144534	102567	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1655X 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/28/2013 12:00:00 AM		3x3	Permit Number 769962	6015154.2	2107704.9	37.768207477714896	-122.39086220831899	(37.7682074777149, -122.390862208319)
164417	164417	191304	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015169.51274	2107473.76779	37.767573688899496	-122.390793087953	(37.7675736888995, -122.390793087953)
170159	170159	191353	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1750 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 5ft		6015102.637619999	2107654.6219599997	37.768066564148505	-122.39103704433501	(37.7680665641485, -122.391037044335)
172600	172600	191327	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1507 04th St	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6015115.08625	2108468.00525	37.770300626710295	-122.391050843517	(37.7703006267103, -122.391050843517)
187273	187273	176963	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	83 Badger St	7	Sidewalk: Property side : Yard 9	Tree 1	Private 1			15	Width 2ft		6002428.97482	2094295.2581	37.7306734890866	-122.43391881851299	(37.7306734890866, -122.433918818513)
7985	7985	1718	DPW Maintained 3	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	555 Battery St	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2			20	9x6		6012538.2564900005	2117884.3369	37.7960123609319	-122.400625729299	(37.7960123609319, -122.400625729299)
22918	22918	191269	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	538 Delancey St	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			8			6015147.69888	2113724.07494	37.7847344271845	-122.391305511737	(37.7847344271845, -122.391305511737)
26349	26349	129413	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2111 Webster St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 3ft		6003291.44456	2115944.18125	37.79016514166771	-122.43248283141399	(37.7901651416677, -122.432482831414)
31053	31053	191303	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	601 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015172.36775	2107445.68773	37.7674967456035	-122.39078125017099	(37.7674967456035, -122.390781250171)
39185	39185	191296	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	740 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 2ft		6014597.305819999	2110326.98215	37.7753762177666	-122.392971942918	(37.7753762177666, -122.392971942918)
55302	55302	191326	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1507 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6015116.04644	2108440.3990700003	37.7702248795025	-122.39104559238501	(37.7702248795025, -122.391045592385)
58900	58900	191352	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1750 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	Width 5ft		6015101.55033	2107682.6315900004	37.768143412117894	-122.391042763138	(37.7681434121179, -122.391042763138)
59332	59332	200004	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1450 Griffith St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			2	Width 0ft		6017626.5562	2092285.3405	37.7260053809224	-122.38123820192101	(37.7260053809224, -122.381238201921)
62074	62074	94211	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	465 Missouri St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		06/22/2010 12:00:00 AM	3	3x3	Permit Number 53589	6013546.79092	2104912.40006	37.760450569952205	-122.39622637625799	(37.7604505699522, -122.396226376258)
62886	62886	227610	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	400 Prospect Ave	6	Sidewalk: Property side : Yard 9	Tree 1	Private 1			25			6006250.04952	2097648.9456700003	37.7400980729811	-122.420946773391	(37.7400980729811, -122.420946773391)
66308	66308	105031	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1550 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			4	6x6		6015081.19497	2108038.83155	37.7691203294602	-122.391138071471	(37.7691203294602, -122.391138071471)
70045	70045	191341	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1450 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			3	Width 5ft		6015063.13507	2108364.25056	37.770012856238395	-122.391223290338	(37.7700128562384, -122.391223290338)
74191	74191	191290	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	720 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	Width 2ft		6014418.027919999	2110488.47672	37.7758096856109	-122.393603417186	(37.7758096856109, -122.393603417186)
77958	77958	31771	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	2000 Ulloa St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	06/19/1995 12:00:00 AM			Permit Number 35250	5989839.49734774	2098377.72398218	37.74116041508079	-122.477740406961	(37.7411604150808, -122.477740406961)
79949	79949	4516	Permitted Site 1	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	20X Cleary Ct	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			6	3X3		6004999.51904	2113885.82273	37.7846101140023	-122.42642640211099	(37.7846101140023, -122.426426402111)
82821	82821	102559	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1755X 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6015173.7	2107354.9	37.767247536270204	-122.390770296702	(37.7672475362702, -122.390770296702)
111006	111006	102566	Undocumented 2	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	1655X 04th St	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1				3x3		6015154.2	2107704.9	37.768207477714896	-122.39086220831899	(37.7682074777149, -122.390862208319)
121552	121552	4543	DPW Maintained 3	Laurus nobilis :: Sweet Bay: Grecian Laurel 30	66 Cleary Ct	6	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		09/21/1994 12:00:00 AM	12	3X3		6004823.98553	2113713.43923	37.784126867550995	-122.427021407244	(37.784126867551, -122.427021407244)

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