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
601	83308	1	14	1773-1775 Quesada Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF		8			6014316.33002	2095278.14651	37.7340397288572	-122.392890824075	(37.7340397288572, -122.392890824075)	10	3	8	58	1
1285	87820	1	14	201 Tocoloma Ave	2	Sidewalk: Curb side : Cutout	Tree	2		06/05/2008 12:00:00 AM	3	3x3	Permit Number 50703	6012799.77687	2087560.2805	37.7127636784815	-122.39759293299	(37.7127636784815, -122.39759293299)	10	3	8	309	1
2528	200777	1	14	1630 McKinnon Ave	3	Sidewalk: Curb side : Cutout	Tree	2			1	Width 0ft		6015219	2096207	37.736640269463	-122.389834845939	(37.736640269463, -122.389834845939)	10	3	8	58	1
2967	39994	1	14	863 Innes Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	01/27/1999 12:00:00 AM	12	3x3	Permit Number 41252	6019434.68731	2094262.5096	37.7315339577268	-122.375124503897	(37.7315339577268, -122.375124503897)	10	3	8	58	1
3938	12945	7	14	25 Lillian St	1	Sidewalk: Curb side : Cutout	Tree	2		02/10/1998 12:00:00 AM	6	3X3		6017779.2478327	2094371.10413	37.7317409092053	-122.380855284503	(37.7317409092053, -122.380855284503)	10	3	8	58	1
5624	11306	1	14	1201X Ingalls St	5	Sidewalk: Curb side : Cutout	Tree	1		03/27/1998 12:00:00 AM	24	3X3		6017591.0151778	2093928.8426978	37.7305161553992	-122.381475305815	(37.7305161553992, -122.381475305815)	10	3	8	58	1
6201	83161	1	14	1773-1775 Quesada Ave	2	Sidewalk: Curb side : Cutout	Tree	2	FUF		4			6014330.67048	2095268.08039	37.734012885882	-122.392840540274	(37.734012885882, -122.392840540274)	10	3	8	58	1
7603	201401	1	14	1051 Ingalls St	13	Sidewalk: Curb side : Cutout	Tree	2			3	Width 3ft		6018098.35359	2094705.94126	37.7326779133429	-122.379775314593	(37.7326779133429, -122.379775314593)	10	3	8	58	1
7752	61207	1	14	150 Elmira St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	11/17/1983 12:00:00 AM	22		Permit Number 21075	6011185.01302	2095858.21511	37.7354580478592	-122.403757619234	(37.7354580478592, -122.403757619234)	10	3	8	58	1
9001	188218	1	14	11 Rosie Lee Ln	2	Sidewalk: Property side : Yard	Tree	2			6	Width 3ft		6018038.29112	2094428.2288	37.7319120561012	-122.379963677596	(37.7319120561012, -122.379963677596)	10	3	8	58	1

trees

Custom SQL query returning 101 rows (hide)

Query parameters