trees

Custom SQL query returning 40 rows (hide)

select 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)] from trees where "DBH" = :p0 and "qLegalStatus_id" = :p1 and "qSpecies_id" = :p2 and (PlotSize > :p4 or (PlotSize = :p4 and ((rowid > :p3)))) order by PlotSize, rowid limit 101

Query parameters

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	qCareAssistant	PlantDate	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
176909	68818	7	65	122 Detroit St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	11/30/1993 12:00:00 AM		Permit Number 32765	5999442.86322085	2093551.99082798	37.7284627395009	-122.444188839651	(37.7284627395009, -122.444188839651)	9	7	4	63	40
178793	64789	7	65	214 Pierce St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	01/10/1989 12:00:00 AM		Permit Number 25785	6002808.76039687	2109284.75060862	37.7718526350484	-122.433676731328	(37.7718526350484, -122.433676731328)	15	5	11	29492	9
183603	67515	7	65	179 Staples Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	09/22/1992 12:00:00 AM		Permit Number 31051	5998906.63498153	2093763.92891486	37.7290140653184	-122.446057838601	(37.7290140653184, -122.446057838601)	9	7	4	28861	40
185506	63233	7	65	200x ESMERALDA AVE	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	01/13/1987 12:00:00 AM		Permit Number 23781	6007093	2098828	37.7433829729046	-122.41811575542	(37.7433829729046, -122.41811575542)	2	7	7	28859	2
187355	115291	7	65	1811 17th Ave	1	Sidewalk: Curb side : Cutout	Tree	2		01/22/2016 12:00:00 AM		Permit Number 775894	5990908.2	2103066.5	37.7540965389008	-122.474387332213	(37.7540965389008, -122.474387332213)	1	8	4	56	12
188694	65036	7	65	69 Scott St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	12/15/1992 12:00:00 AM		Permit Number 31412	6002360.88534811	2108648.78551282	37.7700810087641	-122.435180464659	(37.7700810087641, -122.435180464659)	15	5	5	29492	9
193961	63264	7	65	474 Elizabeth St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	06/19/1999 12:00:00 AM		Permit Number 23819	6003326.56560874	2102164.81247283	37.7523323660448	-122.431377264225	(37.7523323660448, -122.431377264225)	2	4	5	28862	22
754	34739	7	65	581 Capp St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	07/28/1997 12:00:00 AM	3x3	Permit Number 38389	6007302.61875581	2103939.58827334	37.7574300317864	-122.417753185833	(37.7574300317864, -122.417753185833)	2	4	7	28859	19
3472	95121	7	65	68 Lamartine St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	12/28/2010 12:00:00 AM	3x3	Permit Number 54048	6002661	2094358	37.7308589285589	-122.433121153797	(37.7308589285589, -122.433121153797)	9	7	5	28861	25
21373	109405	7	65	112 ORTEGA ST	1	Sidewalk: Curb side : Cutout	Tree	2		12/29/2015 12:00:00 AM	3x3	Permit Number 775093	5993662.3	2102610.6	37.7530039316177	-122.46482995514	(37.7530039316177, -122.46482995514)	1	8	4	56	12
48996	94666	7	65	115 Cuvier St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	10/22/2010 12:00:00 AM	3x3	Permit Number 53803	6004020	2095225	37.7333165119994	-122.428484644893	(37.7333165119994, -122.428484644893)	9	7	5	28861	25
71957	95120	7	65	67 Lamartine St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	12/28/2010 12:00:00 AM	3x3	Permit Number 54047	6002640	2094338	37.7308028218422	-122.433192325631	(37.7308028218422, -122.433192325631)	9	7	5	28861	25
72547	102082	7	65	577 04th Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	07/09/2009 12:00:00 AM	3x3	Permit Number 52510	5994678.1	2111611.2	37.7777757479831	-122.461969778855	(37.7777757479831, -122.461969778855)	11	6	2	54	11
73034	94147	7	65	1838 11th Ave	1	Sidewalk: Curb side : Cutout	Tree	2		06/15/2010 12:00:00 AM	3x3	Permit Number 53552	5992870.9	2102941.4	37.7538665624087	-122.467590799812	(37.7538665624087, -122.467590799812)	1	8	4	56	12
76736	94821	7	65	1435 15th Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	11/10/2010 12:00:00 AM	3x3	Permit Number 53901	5991436.1	2105639	37.7611905159112	-122.472749301819	(37.7611905159112, -122.472749301819)	1	8	4	56	12
90858	81824	7	65	465 Teresita Blvd	1	Sidewalk: Curb side : Cutout	Tree	2		10/25/2007 12:00:00 AM	3x3	Permit Number 49841	5998560.4175518	2097716.54493852	37.7398472336872	-122.447539136623	(37.7398472336872, -122.447539136623)	9	7	4	59	40
93872	102475	7	65	581 Capp St	2	Sidewalk: Curb side : Cutout	Tree	2			3x3	Permit Number 38389	6007298	2103932	37.7574089362149	-122.417768621509	(37.7574089362149, -122.417768621509)	2	4	7	28859	19
95563	38954	7	65	293 Joost Ave	1	Sidewalk: Curb side : Cutout	Tree	2		04/30/2008 12:00:00 AM	3x3	Permit Number 50374	6000154.66929043	2094929.77821336	37.73228640687	-122.441826941763	(37.73228640687, -122.441826941763)	9	7	4	63	40
98528	87814	7	65	2000 10th Ave	5	Sidewalk: Curb side : Cutout	Tree	2		06/03/2008 12:00:00 AM	3x3	Permit Number 777426	5993220.6	2101817.5	37.750800806475	-122.466299791721	(37.750800806475, -122.466299791721)	1	8	4	29491	40
101694	94830	7	65	1537 06th Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	11/10/2010 12:00:00 AM	3x3	Permit Number 53908	5994260.8	2105105.8	37.7598895981479	-122.462941258172	(37.7598895981479, -122.462941258172)	1	5	4	56	12
110235	87815	7	65	2000 10th Ave	4	Sidewalk: Curb side : Cutout	Tree	2		06/03/2008 12:00:00 AM	3x3	Permit Number 777426	5993220.6	2101817.5	37.750800806475	-122.466299791721	(37.750800806475, -122.466299791721)	1	8	4	29491	40
110639	83535	7	65	1779 48th Ave		Sidewalk: Curb side : Cutout	Tree	2		01/24/2008 12:00:00 AM	3x3	Permit Number 50180	5981283.63190284	2102973.80068941	37.7532797037627	-122.507663961783	(37.7532797037627, -122.507663961783)	1	8	3	56	35
115535	94829	7	65	1531 06th Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	11/10/2010 12:00:00 AM	3x3	Permit Number 53907	5994259.9	2105131.8	37.75996093558	-122.462946257172	(37.75996093558, -122.462946257172)	1	5	4	56	12
122464	94832	7	65	1212 08th Ave	1	Sidewalk: Curb side : Cutout	Tree	2			3x3		5993646.6	2107243.8	37.7657245899289	-122.465220756233	(37.7657245899289, -122.465220756233)	11	8	11	56	12
124672	94831	7	65	1541 06th Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	11/10/2010 12:00:00 AM	3x3	Permit Number 53909	5994261.6	2105082.3	37.759825119308	-122.462936786411	(37.759825119308, -122.462936786411)	1	5	4	56	12
133428	94661	7	65	246 Chenery St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	10/22/2010 12:00:00 AM	3x3	Permit Number 53798	6004650	2096961	37.7381188082759	-122.426430123703	(37.7381188082759, -122.426430123703)	2	7	5	63	7
149788	105062	7	65	530 07th Ave		Sidewalk: Curb side : Cutout	Tree	2			3x3	Permit Number 771082	5993803.2	2111872	37.7784414265163	-122.465015282122	(37.7784414265163, -122.465015282122)	11	6	2	54	11
152810	94662	7	65	252 Chenery St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	10/22/2010 12:00:00 AM	3x3	Permit Number 53799	6004605	2096922	37.7380091791898	-122.426582934947	(37.7380091791898, -122.426582934947)	2	7	5	63	7
156296	87374	7	65	149 Staples Ave	2	Sidewalk: Curb side : Cutout	Tree	2			3x3	Permit Number 50353	5999085.2	2093741.7	37.7289632252792	-122.445438930282	(37.7289632252792, -122.445438930282)	9	7	4	28861	40
157166	106344	7	65	2428 14th Ave	1	Median : Cutout	Tree	2		04/18/2014 12:00:00 AM	3x3		5992079	2098890.7	37.7426986307713	-122.470034423922	(37.7426986307713, -122.470034423922)	1	8	4	29491	40
158268	81935	7	65	23 Gaviota Way	1	Sidewalk: Curb side : Cutout	Tree	2		10/25/2007 12:00:00 AM	3x3	Permit Number 49833	5998498.7012246	2097562.09988585	37.7394196374476	-122.447741409302	(37.7394196374476, -122.447741409302)	9	7	4	59	40
166768	83830	7	65	4429 Kirkham St	1	Sidewalk: Curb side : Cutout	Tree	2		01/28/2008 12:00:00 AM	3x3	Permit Number 50197	5981144.78735824	2104834.04535283	37.7583792247877	-122.50828217567	(37.7583792247877, -122.50828217567)	1	8	3	56	35
173139	98032	7	65	132 Clement St	1	Sidewalk: Curb side : Cutout	Tree	2			3x3		5995145	2113574	37.783191941507	-122.460496884135	(37.783191941507, -122.460496884135)	11	6	2	54	11
178764	83799	7	65	1200 45th Ave	1	Sidewalk: Curb side : Cutout	Tree	2		01/23/2008 12:00:00 AM	3x3	Permit Number 53146	5982135.42302083	2106787.40938389	37.7638009337056	-122.505000931873	(37.7638009337056, -122.505000931873)	1	8	3	56	35
185739	106345	7	65	2428 14th Ave	2	Median : Cutout	Tree	2		04/18/2014 12:00:00 AM	3x3		5992079	2098890.7	37.7426986307713	-122.470034423922	(37.7426986307713, -122.470034423922)	1	8	4	29491	40
186665	87813	7	65	2000 10th Ave	3	Sidewalk: Curb side : Cutout	Tree	2		06/03/2008 12:00:00 AM	3x3	Permit Number 777426	5993220.6	2101817.5	37.750800806475	-122.466299791721	(37.750800806475, -122.466299791721)	1	8	4	29491	40
188754	94833	7	65	1208 08th Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	11/10/2010 12:00:00 AM	3x3	Permit Number 53910	5993657.5	2107252.8	37.7657499301273	-122.465183709555	(37.7657499301273, -122.465183709555)	11	8	11	56	12
188964	96074	7	65	439 39th Ave	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	07/28/2011 12:00:00 AM	3x3	Permit Number 767700	5983724.3	2112865.2	37.7805821513852	-122.499954873055	(37.7805821513852, -122.499954873055)	11	6	2	55	26
83501	66304	7	65	400 Congo St	1	Sidewalk: Curb side : Cutout	Tree	2	FUF	12/07/1990 12:00:00 AM	3x50	Permit Number 29418	6000123.45614997	2094964.38431909	37.732379648564	-122.44193733537	(37.732379648564, -122.44193733537)	9	7	5	63	40
142834	33539	7	65	253 BOCANA ST	1	Sidewalk: Curb side : Cutout	Tree	2		08/06/2015 12:00:00 AM	4x4	Permit Number 775951	6007035	2097463	37.7396317225537	-122.418219548801	(37.7396317225537, -122.418219548801)	2	7	7	28859	2