trees

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	qCareAssistant	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
530	35187	7	14		17	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
871	259735	1	14	100x Florida St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	06/09/2018 12:00:00 AM	3
1259	34123	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37981
2108	35196	7	14		5	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
2267	46716	7	14		3	Sidewalk: Curb side : Cutout	Tree	2		04/24/2002 12:00:00 AM			Permit Number 44843
2483	34134	7	14		5	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37986
2566	35200	7	14		3	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
2583	34124	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37982
2961	35202	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
3005	109931	7	14	2822 Moraga Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	03/12/2015 12:00:00 AM	3	3x3	Permit Number 775171
3130	34137	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37987
3632	34115	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37978
3795	35211	7	14		8	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
3829	35184	7	14		6	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
3908	36856	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
3983	34122	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37981
4027	46718	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		04/24/2002 12:00:00 AM			Permit Number 44843
4338	259737	1	14	100x Florida St	3	Sidewalk: Curb side : Cutout	Tree	1	FUF	06/09/2018 12:00:00 AM	3
4864	47038	7	14	716 Walter St	1	Sidewalk: Curb side : Cutout	Tree	2		05/02/2002 12:00:00 AM			Permit Number 45030
5168	35201	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
5297	35195	7	14		9	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
5998	36865	7	14		10	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
6031	34117	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37979
6187	85268	7	14	1000 Edinburgh St	2	Sidewalk: Curb side : Cutout	Tree	2		07/24/2007 12:00:00 AM			Permit Number 49560
6405	34118	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37979
6689	259736	1	14	100x Florida St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF	06/09/2018 12:00:00 AM	3
6696	36862	7	14		7	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
7861	34464	7	14	1521 Ralston Ave	3	Sidewalk: Curb side : Cutout	Tree	2		07/15/1997 12:00:00 AM			Permit Number 38201
8052	34462	7	14	1521 Ralston Ave	1	Sidewalk: Curb side : Cutout	Tree	2		07/15/1997 12:00:00 AM			Permit Number 38201
8248	36860	7	14		5	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
8338	34101	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37975
8522	34103	7	14		4	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37975
8698	260238	1	14	1401x Quintara St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	10/20/2018 12:00:00 AM	3
8724	258144	1	14	1000 Woolsey St	2	Sidewalk: Curb side : Cutout	Tree	1	FUF		3
8853	34116	7	14		3	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37979
9048	35190	7	14		14	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
9202	36861	7	14		6	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
9209	46152	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		12/27/2001 12:00:00 AM			Permit Number 44491
9782	34132	7	14		3	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37986
9838	34102	7	14		3	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37975
10067	88529	7	14			Sidewalk: Curb side : Cutout	Tree	2		07/21/2008 12:00:00 AM		3x3	Permit Number 51479
10288	34120	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37980
10337	36866	7	14		12	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
10342	251266	1	14	10x Paloma Ave	1	Sidewalk: Curb side : Cutout	Tree	2
10774	34136	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37986
10816	36858	7	14		3	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
10831	35192	7	14		12	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
11187	36874	7	14		11	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
11279	34466	7	14	1521 Ralston Ave	5	Sidewalk: Curb side : Cutout	Tree	2		07/15/1997 12:00:00 AM			Permit Number 38201
11508	36864	7	14		9	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
12097	46717	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		04/24/2002 12:00:00 AM			Permit Number 44843
12347	46713	7	14		5	Sidewalk: Curb side : Cutout	Tree	2		04/24/2002 12:00:00 AM			Permit Number 44843
12428	46715	7	14		4	Sidewalk: Curb side : Cutout	Tree	2		04/24/2002 12:00:00 AM			Permit Number 44843
12477	50776	7	14		1	Sidewalk: Curb side : Cutout	Tree	2					Permit Number 47304
12490	47039	7	14	771 Walter St	1	Sidewalk: Curb side : Cutout	Tree	2		05/02/2002 12:00:00 AM			Permit Number 45031
12680	34135	7	14		4	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37986
12730	34138	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37987
12866	85267	7	14	1000 Edinburgh St	1	Sidewalk: Curb side : Cutout	Tree	2		07/24/2007 12:00:00 AM			Permit Number 49560
13038	34133	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37986
13270	50775	7	14		2	Sidewalk: Curb side : Cutout	Tree	2					Permit Number 47304
13633	35194	7	14		10	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
13814	34461	7	14	1521 Ralston Ave	6	Sidewalk: Curb side : Cutout	Tree	2		07/15/1997 12:00:00 AM			Permit Number 38201
13994	34100	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37975
14350	258500	1	14	1177 Brussels St	2	Sidewalk: Curb side : Cutout	Tree	1
14417	34463	7	14	1521 Ralston Ave	2	Sidewalk: Curb side : Cutout	Tree	2		07/15/1997 12:00:00 AM			Permit Number 38201
14536	35191	7	14		13	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
14711	258145	1	14	1000 Woolsey St	3	Sidewalk: Curb side : Cutout	Tree	1	FUF		3
14758	34114	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37978
15142	34465	7	14	1521 Ralston Ave	4	Sidewalk: Curb side : Cutout	Tree	2		07/15/1997 12:00:00 AM			Permit Number 38201
15233	109923	4	14	214 state st	1	Sidewalk: Curb side : Cutout	Tree	2				3x3
15407	35199	7	14		4	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
15727	35188	7	14		16	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
15763	35185	7	14		19	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
15777	35189	7	14		15	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
15800	35182	7	14		7	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
16219	46153	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		12/27/2001 12:00:00 AM			Permit Number 44491
16509	34121	7	14		2	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37980
16822	258142	1	14	1000 Woolsey St	1	Sidewalk: Curb side : Cutout	Tree	1	FUF		3
16839	36857	7	14		1	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
17208	50777	7	14		3	Sidewalk: Curb side : Cutout	Tree	2					Permit Number 47304
17254	46714	7	14		6	Sidewalk: Curb side : Cutout	Tree	2		04/24/2002 12:00:00 AM			Permit Number 44843
17346	85269	7	14	1000 Edinburgh St	3	Sidewalk: Curb side : Cutout	Tree	2		07/24/2007 12:00:00 AM			Permit Number 49560
17460	253167	1	14	1X Brotherhood Way	1	Front Yard : Yard	Tree	1
17594	254853	7	14	799 Avalon Ave		Sidewalk: Curb side : Cutout	Tree	2	FUF	03/29/2018 12:00:00 AM	3	3x3	Permit Number 781645
17825	35193	7	14		11	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
18801	34119	7	14		3	Sidewalk: Curb side : Cutout	Tree	2		07/05/1997 12:00:00 AM			Permit Number 37980
19047	35186	7	14		18	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM			Permit Number 38712
19117	36863	7	14		8	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
19130	85270	7	14	1000 Edinburgh St	4	Sidewalk: Curb side : Cutout	Tree	2		07/24/2007 12:00:00 AM			Permit Number 49560
19248	47040	7	14	771 Walter St	2	Sidewalk: Curb side : Cutout	Tree	2		05/02/2002 12:00:00 AM			Permit Number 45031
19488	36859	7	14		4	Sidewalk: Curb side : Cutout	Tree	2		05/26/1998 12:00:00 AM			Permit Number 39538
44233	118482	1	14	8349 Geary Blvd	4	Sidewalk: Property side : Yard	Tree	2			1			5981039.36975	2112282.68151	37.7788247951526	-122.509199886896	(37.7788247951526, -122.509199886896)	11	6	2	55	26
115772	34719	1	14	726 48th Ave	1	Sidewalk: Curb side : Cutout	Tree	1	FUF	03/29/2018 12:00:00 AM	3		Permit Number 3834	5981068.63905	2110748.84496	37.7746150589051	-122.508984712533	(37.7746150589051, -122.508984712533)	11	6	2	55	26
120966	118481	1	14	8349 Geary Blvd	4	Sidewalk: Property side : Yard	Tree	2			6			5981086.35352	2112282.54001	37.7788271765554	-122.509037343924	(37.7788271765554, -122.509037343924)	11	6	2	55	26
115275	118954	1	14	758 48th Ave	1	Sidewalk: Property side : Yard	Tree	2			1	Width 4ft		5981087.55218	2110537.58401	37.7740361134392	-122.50890360005	(37.7740361134392, -122.50890360005)	11	6	2	55	26
172924	250983	1	14	145 Seal Rock Dr	1	:	Tree	2			1	Width 3ft		5981179.00288	2112933.49353	37.7806199631672	-122.508765181767	(37.7806199631672, -122.508765181767)	11	6	2	55	26
176726	115240	1	14	507 47th Ave	1	Sidewalk: Curb side : Cutout	Tree	2		01/20/2016 12:00:00 AM			Permit Number 775523	5981264.2	2112246.8	37.7787395279518	-122.508419460029	(37.7787395279518, -122.508419460029)	11	6	2	55	26
44505	34717	1	14	527 47th Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	07/28/1997 12:00:00 AM	16		Permit Number 38372	5981286.01571	2112124.00365	37.7784036511937	-122.508334874866	(37.7784036511937, -122.508334874866)	11	6	2	55	26
52677	184495	1	14	1863 48th Ave	1	Sidewalk: Curb side : Cutout	Tree	2			1	Width 0ft		5981306.2719	2102404.095	37.7517167869353	-122.507543400741	(37.7517167869353, -122.507543400741)	1	8	3	56	35
191599	47836	7	14	506 47th Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	06/14/2002 12:00:00 AM			Permit Number 45598	5981328.87768988	2112285.52839896	37.7788496761933	-122.508198593969	(37.7788496761933, -122.508198593969)	11	6	2	55	26
161610	117380	1	14	823 47th Ave	1	Sidewalk: Curb side : Cutout	Tree	2		06/08/2016 12:00:00 AM	3		Permit Number 778551	5981342	2110110.3	37.7728779129239	-122.507991719286	(37.7728779129239, -122.507991719286)	11	6	2	55	26

trees

Custom SQL query returning 101 rows (hide)

Query parameters