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
16673	71598	1	14	126 Wilson St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF		9			5994743.91592	2086305.62835	37.7082967566677	-122.459908520573	(37.7082967566677, -122.459908520573)	9	8	6	28861	25
187058	53003	1	14	88@ GENEVA Pasadena St	1	Sidewalk: Curb side : Cutout	Tree	2		08/21/2006 12:00:00 AM	4		Permit Number 48983	6006543.04417	2086136.95976	37.708505157469	-122.419117357192	(37.708505157469, -122.419117357192)	9	7	8	309	39
1769	251583	4	14	75 Rice St	1	Sidewalk: Curb side : Cutout	Tree	2		09/30/1995 12:00:00 AM		3x3		5995352	2086409	37.7086155444167	-122.457814401925	(37.7086155444167, -122.457814401925)	9	7	6	28861	25
59333	73959	4	14	75 Rice St	2	Sidewalk: Curb side : Cutout	Tree	2		09/30/1995 12:00:00 AM	4	2x4	Permit Number 773591	5995358.56494273	2086411.36688337	37.7086224204841	-122.457791883945	(37.7086224204841, -122.457791883945)	9	7	6	28861	25
190879	71596	4	14	75 Rice St	3	Sidewalk: Curb side : Cutout	Tree	2		09/30/1995 12:00:00 AM	12	2x3		5995358.56494273	2086411.36688337	37.7086224204841	-122.457791883945	(37.7086224204841, -122.457791883945)	9	7	6	28861	25
26619	115723	7	14	147 Baltimore Way	1	Sidewalk: Curb side : Cutout	Tree	2		02/23/2016 12:00:00 AM	3		Permit Number 775898	6002684.2	2086288.6	37.7087034632659	-122.432464808573	(37.7087034632659, -122.432464808573)	9	7	6	28861	5
65816	25774	1	14	2027 Geneva Ave	1	Sidewalk: Curb side : Cutout	Tree	2		02/07/1997 12:00:00 AM	16	2x3		6005967.11892	2086230.65451	37.7087299735811	-122.421114477163	(37.7087299735811, -122.421114477163)	9	7	8	309	39
13437	71606	1	14	182 Wilson St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF		13			5994495.51543	2086527.6412	37.708892062899	-122.460783093263	(37.708892062899, -122.460783093263)	9	8	6	28861	25
128847	25775	1	14	1965 Geneva Ave	1	Sidewalk: Curb side : Cutout	Tree	1		02/07/1997 12:00:00 AM	16	2X3		6005734.23372	2086319.0681	37.708959607374	-122.42192563688	(37.708959607374, -122.42192563688)	9	7	8	309	39
149613	44388	1	14	375 Chicago Way	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	03/22/2001 12:00:00 AM	11		Permit Number 43748	6002261.2315	2086392.26553	37.7089641120841	-122.433934046742	(37.7089641120841, -122.433934046742)	9	7	6	28861	5

trees

Custom SQL query returning 101 rows (hide)

Query parameters