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
56177	39988	7	14	702 Innes Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	01/27/1999 12:00:00 AM			Permit Number 41246	6020313.39222717	2093680.55714076	37.7299843378677	-122.372046361907	(37.7299843378677, -122.372046361907)	10	3	8	58	1
54777	201528	1	14	700 Innes Ave	1	:	Tree	2			10	Width 3ft		6020307.12095	2093692.07813	37.7300156278056	-122.372068839601	(37.7300156278056, -122.372068839601)	10	3	8	58	1
33543	39990	1	14	714 Innes Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	01/27/1999 12:00:00 AM	10		Permit Number 41248	6020251.60512	2093735.09311	37.7301306888693	-122.372263742486	(37.7301306888693, -122.372263742486)	10	3	8	58	1
117678	201530	1	14	724 Innes Ave	2	:	Tree	2			11	Width 3ft		6020205.16729	2093768.90388	37.7302209753954	-122.372426624989	(37.7302209753954, -122.372426624989)	10	3	8	58	1
72991	39992	1	14	744 Innes Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	01/27/1999 12:00:00 AM	10		Permit Number 41250	6020175.81777	2093790.38567	37.7302783476475	-122.372529577584	(37.7302783476475, -122.372529577584)	10	3	8	58	1
135791	201656	1	14	748 Innes Ave	1	:	Tree	2			5	Width 3ft		6020105.93205	2093842.33716	37.7304171562079	-122.372774779541	(37.7304171562079, -122.372774779541)	10	3	8	58	1
104328	201657	1	14	748 Innes Ave	2	:	Tree	2			5	Width 3ft		6020084.79381	2093857.53228	37.7304577174311	-122.372848909746	(37.7304577174311, -122.372848909746)	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
39634	40006	1	14	930 Innes Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	02/03/1999 12:00:00 AM	12		Permit Number 41259	6019126.39744	2094573.62219	37.7323712445238	-122.376211900284	(37.7323712445238, -122.376211900284)	10	3	8	58	1
38925	201502	1	14	1099 Innes Ave	2	:	Tree	2			11	Width 2ft		6018234.78609	2095166.37786	37.733949706701	-122.379335600073	(37.733949706701, -122.379335600073)	10	3	8	58	1

trees

Custom SQL query returning 101 rows (hide)

Query parameters