Street_Tree_List

Data source: data.sfgov.org

142 rows where DBH = 1 and qSpecies = 49

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

Link	rowid ▼	TreeID	qLegalStatus	qSpecies	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location
23709	23709	223384	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1 Cumberland St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6005565.506580001	2104580.7732	37.759092667419	-122.42380640884701	(37.759092667419, -122.423806408847)
23816	23816	224059	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3628 16th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6002696.79261	2106527.84926	37.76427650537521	-122.43386694650499	(37.7642765053752, -122.433866946505)
26240	26240	207694	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1650 Portola Dr	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5991855.32533	2096348.4574	37.7357053452243	-122.470622695389	(37.7357053452243, -122.470622695389)
27771	27771	245044	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	155 Baker St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6000750.251	2109577.8851	37.7725404908768	-122.440818271359	(37.7725404908768, -122.440818271359)
28353	28353	207561	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1471 12th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		5992400.09167	2105443.1565799997	37.7607085377924	-122.469401040143	(37.7607085377924, -122.469401040143)
28370	28370	207590	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	434 Hearst Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 1ft		5998520.921569999	2094401.97974	37.7307439689499	-122.447437181086	(37.7307439689499, -122.447437181086)
28441	28441	189265	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2203 Newcomb Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		6011972.28331	2098093.92114	37.7416407727111	-122.40119276536001	(37.7416407727111, -122.40119276536)
28626	28626	114447	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	367 Bay Shore Blvd	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	4x4		6010564.675559999	2098126.12029	37.741650555529496	-122.40606209151699	(37.7416505555295, -122.406062091517)
28661	28661	189257	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2231 Newcomb Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		6011833.55798	2098197.58892	37.7419176820557	-122.40167971856	(37.7419176820557, -122.40167971856)
28700	28700	189264	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2207 Newcomb Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		6011951.89121	2098108.4509400004	37.741679530779294	-122.401264295606	(37.7416795307793, -122.401264295606)
31314	31314	52821	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	2850@ ANZA Anza St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/19/2016 12:00:00 AM	1		Permit Number 775537	5989762.54787	2111977.16007	37.7784963508186	-122.479000957003	(37.7784963508186, -122.479000957003)
32230	32230	126541	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1301 Columbus Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6007346.83481	2121683.4961099997	37.80615299312171	-122.41885867979299	(37.8061529931217, -122.418858679793)
32536	32536	142259	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	566 FELL ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6004708.2263	2110563.0976	37.7754702599594	-122.427197416812	(37.7754702599594, -122.427197416812)
32606	32606	122015	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1799 Cabrillo St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5990132.5051	2110630.3352900003	37.7748198185001	-122.477622678128	(37.7748198185001, -122.477622678128)
33044	33044	223662	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	29 Highland Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005138.6788800005	2096702.2357599998	37.737435912447296	-122.42472211206001	(37.7374359124473, -122.42472211206)
35224	35224	191095	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1951 23rd St	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6012592.465340001	2102823.04083	37.7546604998905	-122.39938028876499	(37.7546604998905, -122.399380288765)
35707	35707	140730	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1801 GROVE ST	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5998825.1945	2110385.2461	37.7746474756927	-122.44753533622699	(37.7746474756927, -122.447535336227)
36121	36121	189263	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2211 Newcomb Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		6011935.60653	2098120.24236	37.7417109989595	-122.401321431357	(37.7417109989595, -122.401321431357)
36353	36353	95920	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	701 15th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	1	3x3	Permit Number 767618	5991287.86259	2110556.38381	37.7746837464675	-122.47362070061001	(37.7746837464675, -122.47362070061)
38118	38118	176257	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	13 Santa Ysabel Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6000825.3698	2093157.80225	37.7274591636907	-122.43938121158199	(37.7274591636907, -122.439381211582)
38621	38621	224043	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	393 Douglass St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6001164.85207	2104167.0832	37.7577073670178	-122.438996283747	(37.7577073670178, -122.438996283747)
39194	39194	126540	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1926 Taylor St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6008669.99624	2119504.05364	37.800243203509005	-122.414125355424	(37.800243203509, -122.414125355424)
40355	40355	207621	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	259 Bright St	1	: 4	Tree 1	Private 1			1	Width 3ft		5993736.2843	2088924.46634	37.7154294623887	-122.463580914754	(37.7154294623887, -122.463580914754)
40539	40539	189270	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	59 Robblee Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		6012477.87962	2095853.3507	37.735516831132	-122.39928732315	(37.735516831132, -122.39928732315)
40579	40579	223499	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	255 Bartlett St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6006746.2446	2102306.01848	37.752913299731	-122.41956145679801	(37.752913299731, -122.419561456798)
43055	43055	126514	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	54 Casa Way	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6001509.62012	2121629.4389400003	37.8056741643903	-122.439055417799	(37.8056741643903, -122.439055417799)
43534	43534	100356	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	566 Fell St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/08/2012 12:00:00 AM	1		Permit Number 769115	6004695.2	2110571.1	37.775491495930204	-122.427243048056	(37.7754914959302, -122.427243048056)
44256	44256	207681	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2655 16th Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5991411.6864	2097337.95206	37.738396582641	-122.47222861836399	(37.738396582641, -122.472228618364)
45757	45757	37990	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	650 Texas St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	04/12/2002 12:00:00 AM	1		Permit Number 44744	6013820.84604	2104031.24845	37.758046364659	-122.395216814417	(37.758046364659, -122.395216814417)
47485	47485	223436	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	222 29th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6005015.068419999	2099039.9459	37.7438477521768	-122.425315796791	(37.7438477521768, -122.425315796791)
47689	47689	189251	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	120 Loomis St	1	: 4	Tree 1	Private 1			1	Width 4ft		6010844.92077	2097998.29295	37.7413152397136	-122.405084094075	(37.7413152397136, -122.405084094075)
49473	49473	223593	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	930 Florida St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6009378.63549	2103724.24958	37.756955368323	-122.41055825836	(37.756955368323, -122.41055825836)
50068	50068	223492	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1810 Harrison St	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6008606.400769999	2107919.47331	37.7684311637055	-122.413525645189	(37.7684311637055, -122.413525645189)
50142	50142	207671	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1734 18th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5990626.77188	2103577.88918	37.7554843697179	-122.475397903889	(37.7554843697179, -122.475397903889)
50797	50797	122165	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	631 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5991266.5557699995	2111104.42075	37.776187272392	-122.473734392293	(37.776187272392, -122.473734392293)
50803	50803	207557	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	438 Judah St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		5993090.30731	2105981.36839	37.7622261896015	-122.46705304515801	(37.7622261896015, -122.467053045158)
51570	51570	47404	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	522 08th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	11/26/2013 12:00:00 AM	1		Permit Number 771051	5993469.13316	2111905.11444	37.778513081590496	-122.46617334261101	(37.7785130815905, -122.466173342611)
51743	51743	54985	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	610 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		09/12/1972 12:00:00 AM	1		Permit Number 10863	5990982.11543	2111201.05221	37.776436117959896	-122.474725393074	(37.7764361179599, -122.474725393074)
51942	51942	200114	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1566 Yosemite Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6014762.2628	2092586.3302	37.7266733037648	-122.39116099243	(37.7266733037648, -122.39116099243)
53129	53129	126549	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2113 Jones St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6008108.43544	2119716.18601	37.8007941084157	-122.416083612992	(37.8007941084157, -122.416083612992)
53569	53569	119433	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	715 32nd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		5985978.78842	2110984.8920299998	37.7755514115766	-122.492017154699	(37.7755514115766, -122.492017154699)
53881	53881	200108	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1538 Yosemite Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6014848.2148	2092517.9747	37.7264903827113	-122.390859081597	(37.7264903827113, -122.390859081597)
55687	55687	223463	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3 Carl St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5998590.56714	2107229.1515599997	37.7659682326767	-122.448119657713	(37.7659682326767, -122.448119657713)
56646	56646	139858	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	702 McAllister St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6005734.4525	2112096.2581	37.779737926574995	-122.4237564888	(37.779737926575, -122.4237564888)
56816	56816	207586	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1917 08th Ave	1	Sidewalk: Curb side : Yard 2	Tree 1	Private 1			1	Width 6ft		5993746.75792	2102455.0649099997	37.7525817412531	-122.464526593251	(37.7525817412531, -122.464526593251)
57646	57646	65832	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	2205 North Point St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	05/07/1990 12:00:00 AM	1		Permit Number 28822	6000136.86621	2120563.93301	37.802670367617104	-122.443729421089	(37.8026703676171, -122.443729421089)
58142	58142	189258	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2231 Newcomb Ave	2	: 4	Tree 1	Private 1			1	Width 3ft		6011848.21009	2098186.58426	37.741888283226	-122.40162828271299	(37.741888283226, -122.401628282713)
58627	58627	223512	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3351 18th St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6007094.154130001	2105540.45939	37.7618139197035	-122.418587660093	(37.7618139197035, -122.418587660093)
60546	60546	200100	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1528 Yosemite Ave	5	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6015024.8562	2092385.3244	37.7261359509126	-122.390239170909	(37.7261359509126, -122.390239170909)
61582	61582	189260	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2223 Newcomb Ave	1	: 4	Tree 1	Private 1			1	Width 3ft		6011881.3428	2098161.01193	37.7418199158556	-122.401511923044	(37.7418199158556, -122.401511923044)
62140	62140	52647	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	850@ FULTON 45th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/20/2016 12:00:00 AM	1		Permit Number 774180	5982028.38924	2109948.2493	37.7724733883273	-122.505605444469	(37.7724733883273, -122.505605444469)
64477	64477	200096	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1528 Yosemite Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6015074.2617	2092350.8083	37.726043916849896	-122.390065967336	(37.7260439168499, -122.390065967336)
66334	66334	123098	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	575 11th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5992506.57833	2111546.13645	37.777471844019	-122.469477017446	(37.777471844019, -122.469477017446)
66621	66621	74233	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2400 Mariposa St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	03/23/1996 12:00:00 AM	1			6010292.05063	2106000.6973900003	37.7632571481177	-122.407559806245	(37.7632571481177, -122.407559806245)
68381	68381	176237	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2014 Bay Shore Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6012237.04254	2088170.85532	37.7144088442801	-122.39958077733401	(37.7144088442801, -122.399580777334)
70300	70300	223643	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3274 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6008366.19883	2104488.5025299997	37.758997020002106	-122.41411372356701	(37.7589970200021, -122.414113723567)
70731	70731	189252	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	120 Loomis St	2	: 4	Tree 1	Private 1			1	Width 4ft		6010838.98568	2097984.0880299998	37.74127590426679	-122.40510361565	(37.7412759042668, -122.40510361565)
70924	70924	223398	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3624 20th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6006084.7339699995	2104359.22358	37.75851364160071	-122.42199493234101	(37.7585136416007, -122.421994932341)
71881	71881	223447	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1261 Sanchez St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6003898.74209	2100909.80549	37.7489188214426	-122.429309101453	(37.7489188214426, -122.429309101453)
72700	72700	207696	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1518 07th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5994014.568	2105145.1879	37.7599835610189	-122.463795707001	(37.7599835610189, -122.463795707001)
74078	74078	207703	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	161 Joost Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 5ft		6000991.68804	2094917.7837900002	37.7323011315777	-122.438932323977	(37.7323011315777, -122.438932323977)
75082	75082	141434	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	511 HAYES ST	4	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6005350.2266	2110949.2548	37.7765668387099	-122.425004063889	(37.7765668387099, -122.425004063889)
76323	76323	52820	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	2850@ ANZA Anza St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		01/19/2016 12:00:00 AM	1		Permit Number 775537	5989777.027869999	2111978.2933900002	37.778500303461	-122.478950948669	(37.778500303461, -122.478950948669)
91184	91184	6737	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	1300X Fairfax Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/30/2012 12:00:00 AM	1	3x3		6017621.9936242	2096730.3826429	37.7382103402349	-122.381562963191	(37.7382103402349, -122.381562963191)
100883	100883	123088	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	681 11th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5992531.98412	2110836.6046700003	37.77552513003	-122.469337473167	(37.77552513003, -122.469337473167)
101792	101792	90334	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	1751 Balboa St	3	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/28/2008 12:00:00 AM	1	3x3		5990179.8300830005	2111264.66899	37.7765642703859	-122.47750534597799	(37.7765642703859, -122.477505345978)
102243	102243	111193	Section 143 8	Eriobotrya deflexa :: Bronze Loquat 49	890x JARBOE AVE	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		11/30/2015 12:00:00 AM	1	3x3	Permit Number 774267	6009115.0	2096842.0	37.738043451743295	-122.41098392432899	(37.7380434517433, -122.410983924329)
102788	102788	6738	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	1300X Fairfax Ave	8	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		08/19/2016 12:00:00 AM	1	3x3		6017621.9936242	2096730.3826429	37.7382103402349	-122.381562963191	(37.7382103402349, -122.381562963191)
104747	104747	90336	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	1751 Balboa St	5	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/22/2013 12:00:00 AM	1	3x3		5990179.8300830005	2111264.66899	37.7765642703859	-122.47750534597799	(37.7765642703859, -122.477505345978)
116818	116818	113391	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	2151 15TH AVE	1	Front Yard : Yard 7	Tree 1	Private 1	FUF 1	12/10/2015 12:00:00 AM	1		Permit Number 776062	5991602.0	2100781.0	37.7478613219593	-122.47182147099899	(37.7478613219593, -122.471821470999)
127566	127566	90335	DPW Maintained 3	Eriobotrya deflexa :: Bronze Loquat 49	1751 Balboa St	4	Sidewalk: Curb side : Cutout 1	Tree 1	DPW 2		02/28/2008 12:00:00 AM	1	3x3		5990179.8300830005	2111264.66899	37.7765642703859	-122.47750534597799	(37.7765642703859, -122.477505345978)
128626	128626	63429	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	174 23rd Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/24/1987 12:00:00 AM	1		Permit Number 24014	5988702.91741	2114182.56462	37.7844901800735	-122.482828244548	(37.7844901800735, -122.482828244548)
130201	130201	30935	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	1093 Plymouth Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	01/25/2016 12:00:00 AM	1		Permit Number 775227	5995910.73733	2091157.41519	37.721685664556496	-122.45622643891501	(37.7216856645565, -122.456226438915)
131157	131157	56328	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	770 16th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		07/25/1973 12:00:00 AM	1		Permit Number 12464	5991021.310959999	2110150.29677	37.7735533016924	-122.47451310498	(37.7735533016924, -122.47451310498)
131168	131168	246060	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	627 Clayton St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		5998490.4423	2108448.6979	37.7693110734878	-122.44855380708799	(37.7693110734878, -122.448553807088)
131203	131203	223464	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1 Carl St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		5998616.14306	2107232.00709	37.76597753526261	-122.448031401823	(37.7659775352626, -122.448031401823)
131221	131221	200109	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1550 Yosemite Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6014832.6487	2092528.8033	37.7265192521755	-122.390913649883	(37.7265192521755, -122.390913649883)
131233	131233	200110	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1550 Yosemite Ave	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6014819.7897	2092537.6015	37.7265426967552	-122.390958717949	(37.7265426967552, -122.390958717949)
131313	131313	200101	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1528 Yosemite Ave	6	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6015012.674	2092395.4762	37.726163150008794	-122.39028199338001	(37.7261631500088, -122.39028199338)
132540	132540	207572	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1640 09th Ave	3	Front Yard : Yard 7	Tree 1	Private 1			1	Width 6ft		5993421.18819	2104299.1531	37.757626357879296	-122.465786433692	(37.7576263578793, -122.465786433692)
132555	132555	191060	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	236 Clara St	0	: 4	Tree 1	Private 1			1	Width 2ft		6011653.22625	2111699.06795	37.7789796735174	-122.40325280096901	(37.7789796735174, -122.403252800969)
132755	132755	200102	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1528 Yosemite Ave	7	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6014998.4615	2092408.3352	37.726197669899996	-122.39033202363899	(37.7261976699, -122.390332023639)
133166	133166	52801	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	25@ TEXAS Sierra St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		05/25/2006 12:00:00 AM	1		Permit Number 48835	6013622.0459199995	2104108.3558099996	37.758247026792795	-122.395909758227	(37.7582470267928, -122.395909758227)
134321	134321	176238	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	2018 Bay Shore Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6012153.04029	2088061.68652	37.7141044057814	-122.399863463036	(37.7141044057814, -122.399863463036)
134388	134388	191066	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	374 06th St	1	: 4	Tree 1	Private 1			1	Width 3ft		6011926.00282	2111797.31864	37.7792646776498	-122.40231606173	(37.7792646776498, -122.40231606173)
134877	134877	189253	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	120 Loomis St	3	: 4	Tree 1	Private 1			1	Width 4ft		6010832.24307	2097967.49844	37.74122997588171	-122.405125761461	(37.7412299758817, -122.405125761461)
135706	135706	100357	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	566 Fell St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		08/08/2012 12:00:00 AM	1		Permit Number 769115	6004695.2	2110571.1	37.775491495930204	-122.427243048056	(37.7754914959302, -122.427243048056)
136174	136174	207704	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	658 Monterey Blvd	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		5997711.57572	2094740.62548	37.7316275258898	-122.450259604396	(37.7316275258898, -122.450259604396)
138256	138256	142260	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	566 FELL ST	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 0ft		6004691.5283	2110560.7676	37.7754629180406	-122.427255013183	(37.7754629180406, -122.427255013183)
146443	146443	191058	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	215 05th St	1	: 4	Tree 1	Private 1			1	Width 5ft		6011781.36835	2111952.66121	37.7796831376017	-122.402827343412	(37.7796831376017, -122.402827343412)
146578	146578	176256	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	13 Santa Ysabel Ave	3	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 4ft		6000782.5530199995	2093188.1019	37.7275399228115	-122.43953140015101	(37.7275399228115, -122.439531400151)
146667	146667	223482	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	4044 Folsom St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6008350.8721199995	2096284.49377	37.736469782444104	-122.41358648255199	(37.7364697824441, -122.413586482552)
146710	146710	95919	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	701 15th Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1	FUF 1	07/29/2011 12:00:00 AM	1	3x3	Permit Number 767618	5991285.79782	2110589.4314599996	37.7747743667319	-122.47363025420799	(37.7747743667319, -122.473630254208)
147438	147438	224077	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	4333 17th St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6000578.703869999	2105764.82815	37.762061014736	-122.44113804889	(37.762061014736, -122.44113804889)
147544	147544	176231	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	670 Paris St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 2ft		6001253.10056	2089784.4863200001	37.7182211342895	-122.437661063033	(37.7182211342895, -122.437661063033)
147728	147728	98581	Permitted Site 1	Eriobotrya deflexa :: Bronze Loquat 49	1631 Pierce St	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1		02/29/2012 12:00:00 AM	1	3x3	Permit Number 768675	6002072.225	2114201.455	37.7853108490024	-122.436576438141	(37.7853108490024, -122.436576438141)
147800	147800	176248	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3500 San Bruno Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6012084.62968	2089393.6592	37.717757921362704	-122.40019340899099	(37.7177579213627, -122.400193408991)
147928	147928	176249	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3502 San Bruno Ave	1	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	Width 3ft		6012088.82637	2089370.3173	37.717694063212704	-122.400177264384	(37.7176940632127, -122.400177264384)
148128	148128	111743	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	1737 Balboa St	2	Sidewalk: Curb side : Cutout 1	Tree 1	Private 1			1	3x3		5990130.37359	2111254.12016	37.7765324362559	-122.477675657167	(37.7765324362559, -122.477675657167)
150194	150194	246625	Undocumented 2	Eriobotrya deflexa :: Bronze Loquat 49	3300 Harrison St	3	Side Yard : Yard 17	Tree 1	Private 1			1			6009033.3388	2099395.8346	37.7450511430894	-122.411446641942	(37.7450511430894, -122.411446641942)

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