trees

Custom SQL query returning 42 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 "Fire Prevention Districts" = :p0 and "qLegalStatus_id" = :p1 and ([Supervisor Districts] > :p3 or ([Supervisor Districts] = :p3 and ((rowid > :p2)))) order by [Supervisor Districts], rowid limit 101

Query parameters

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	PlantDate	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
93105	253487	2	116	1x Gordon St	5	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
95654	253488	2	116	1x Gordon St	6	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
98537	196590	2	44	43 Lafayette St	2	:	Tree	2		10	Width 3ft	Permit Number 772992	6007565.69447	2109618.27361	37.7730371773558	-122.417245760983	(37.7730371773558, -122.417245760983)	8	2	9	28853	19
99698	113643	2	11	1400 MISSION ST	5	Sidewalk: Curb side : Cutout	Tree	2	02/09/2016 12:00:00 AM	3	4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
105665	253493	2	116	1x Gordon St	11	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
106809	29017	2	162	120 10th St	1	Sidewalk: Curb side : Cutout	Tree	2	04/09/2014 12:00:00 AM	6	3x3	Permit Number 770901	6008044.5664857	2110308.5131992	37.7749593412658	-122.415638158484	(37.7749593412658, -122.415638158484)	8	2	9	28853	34
107192	201696	2	11	342 08th St	4	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009973.11931	2109904.86997	37.773959250457	-122.408938366227	(37.773959250457, -122.408938366227)	8	2	9	28853	34
112760	196591	2	44	43 Lafayette St	3	:	Tree	2		13	Width 3ft	Permit Number 772992	6007555.65106	2109624.06249	37.7730525072055	-122.417280912782	(37.7730525072055, -122.417280912782)	8	2	9	28853	19
115603	251289	2	11	33 08th St	3	Sidewalk: Curb side : Cutout	Tree	2	04/05/2017 12:00:00 AM	3	Width 3ft	Permit Number 771124	6008734.11613	2111298.92197	37.7777175065003	-122.413322904728	(37.7777175065003, -122.413322904728)	8	2	9	28853	34
117291	113647	2	11	1400 MISSION ST	4	Sidewalk: Curb side : Cutout	Tree	2	02/09/2016 12:00:00 AM	3	4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
121557	113652	2	162	98X 10TH ST	4	Sidewalk: Curb side : Cutout	Tree	2			4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
121637	253479	2	140	1222 Harrison St	5	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009984	2109753	37.7735428603255	-122.408890010762	(37.7735428603255, -122.408890010762)	8	2	9	28853	34
124821	113644	2	11	1400 MISSION ST	1	Sidewalk: Curb side : Cutout	Tree	2	02/09/2016 12:00:00 AM	3	4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
128863	253475	2	140	1222 Harrison St	1	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009984	2109753	37.7735428603255	-122.408890010762	(37.7735428603255, -122.408890010762)	8	2	9	28853	34
129348	251179	2	51	1043 Minna St	2	Sidewalk: Property side : Cutout	Tree	2			3x3		6007668	2109797	37.7735336727503	-122.41690453761	(37.7735336727503, -122.41690453761)	8	2	9	28853	19
130377	113654	2	162	98X 10TH ST	6	Sidewalk: Curb side : Cutout	Tree	2			4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
134197	201699	2	11	342 08th St	7	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6010014.86815	2109861.25987	37.7738418457656	-122.408790872027	(37.7738418457656, -122.408790872027)	8	2	9	28853	34
135281	253476	2	140	1222 Harrison St	2	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009984	2109753	37.7735428603255	-122.408890010762	(37.7735428603255, -122.408890010762)	8	2	9	28853	34
137539	113649	2	162	98X 10TH ST	1	Sidewalk: Curb side : Cutout	Tree	2			4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
138609	251178	2	51	1043 Minna St	1	Sidewalk: Property side : Cutout	Tree	2			3x3		6007668	2109797	37.7735336727503	-122.41690453761	(37.7735336727503, -122.41690453761)	8	2	9	28853	19
139476	113655	2	1	901X JESSIE ST	1	Sidewalk: Curb side : Cutout	Tree	2	02/09/2016 12:00:00 AM	3	3x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
152719	113648	2	11	1400 MISSION ST	6	Sidewalk: Curb side : Cutout	Tree	2	02/09/2016 12:00:00 AM	3	4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
154892	113645	2	11	1400 MISSION ST	2	Sidewalk: Curb side : Cutout	Tree	2	02/09/2016 12:00:00 AM	3	4x6	Permit Number 773574	6007947	2110424	37.7752709556829	-122.415983842901	(37.7752709556829, -122.415983842901)	8	2	9	28853	34
158086	15247	2	11	1401X Mission St	2	Sidewalk: Curb side : Cutout	Tree	2	12/29/2016 12:00:00 AM	3	3X3	Permit Number 770901	6007902.55668	2110326.57547	37.7750009522643	-122.416130681693	(37.7750009522643, -122.416130681693)	8	2	9	28853	34
158927	251290	2	11	33 08th St	4	Sidewalk: Curb side : Cutout	Tree	2	04/05/2017 12:00:00 AM	3	Width 3ft	Permit Number 771124	6008734.11613	2111298.92197	37.7777175065003	-122.413322904728	(37.7777175065003, -122.413322904728)	8	2	9	28853	34
159122	253486	2	116	1x Gordon St	4	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
159283	192594	2	11	1321 Mission St	1	Sidewalk: Curb side : Cutout	Tree	2	11/09/1995 12:00:00 AM	2	Width 4ft	Permit Number 770747	6008274.3646	2110675.08431	37.7759787734355	-122.414869184668	(37.7759787734355, -122.414869184668)	8	2	9	28853	34
162521	192596	2	11	1335 Mission St	3	Sidewalk: Curb side : Cutout	Tree	2	03/07/1995 12:00:00 AM	3	Width 4ft	Permit Number 770747	6008295.90964	2110693.56586	37.7760307299718	-122.414795962779	(37.7760307299718, -122.414795962779)	8	2	9	28853	34
164004	201690	2	11	324 08th St	3	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009863.47645	2110020.43216	37.7742704149776	-122.409325797764	(37.7742704149776, -122.409325797764)	8	2	9	28853	34
168133	121551	2	11	1125 Mission St	2	Sidewalk: Curb side : Cutout	Tree	2	01/23/2017 12:00:00 AM	3	3x3	Permit Number 778243	6009293.51408	2111653.12836	37.7787214646499	-122.411412777974	(37.7787214646499, -122.411412777974)	8	2	9	28853	34
169960	192564	2	11	33 08th St	2	Sidewalk: Curb side : Cutout	Tree	2	04/05/2017 12:00:00 AM	3	Width 3ft	Permit Number 771124	6008734.11613	2111298.92197	37.7777175065003	-122.413322904728	(37.7777175065003, -122.413322904728)	8	2	9	28853	34
169973	253496	2	116	1x Gordon St	14	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
171171	253477	2	140	1222 Harrison St	3	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009984	2109753	37.7735428603255	-122.408890010762	(37.7735428603255, -122.408890010762)	8	2	9	28853	34
175654	201688	2	11	324 08th St	1	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x6	Permit Number 772214	6009806.99553	2110077.79875	37.7744247656342	-122.409525226004	(37.7744247656342, -122.409525226004)	8	2	9	28853	34
176162	121550	2	11	1125 Mission St	1	Sidewalk: Curb side : Cutout	Tree	2	01/23/2017 12:00:00 AM	3	3x3	Permit Number 778243	6009252.51421	2111618.01515	37.7786227523886	-122.411552131552	(37.7786227523886, -122.411552131552)	8	2	9	28853	34
176904	190611	2	22	9 Washburn St	1	Sidewalk: Curb side : Cutout	Tree	2	02/07/2018 12:00:00 AM	3	Width 3ft	Permit Number 775218	6008250.0486	2110605.54207	37.7757864606069	-122.41494837717	(37.7757864606069, -122.41494837717)	8	2	9	28853	34
177182	15246	2	11	1401X Mission St	1	Sidewalk: Curb side : Cutout	Tree	2	12/29/2016 12:00:00 AM	3	3x3	Permit Number 770901	6007883.54199	2110310.54573	37.7749558692557	-122.416195322271	(37.7749558692557, -122.416195322271)	8	2	9	28853	34
181014	253484	2	116	1x Gordon St	2	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34
181676	196592	2	44	43 Lafayette St	4	:	Tree	2		8	Width 3ft	Permit Number 772992	6007533.59843	2109642.31042	37.7731013709756	-122.417358489209	(37.7731013709756, -122.417358489209)	8	2	9	28853	19
182348	173697	2	11	1401X Mission St	4	Sidewalk: Curb side : Cutout	Tree	2	12/29/2016 12:00:00 AM	3	3X3	Permit Number 770901	6007975.5805432	2110395.7628537	37.775195030009	-122.415882976003	(37.775195030009, -122.415882976003)	8	2	9	28853	34
190069	15235	2	11	1321 Mission St	1	Sidewalk: Curb side : Cutout	Tree	2	01/27/2015 12:00:00 AM	3	3X3	Permit Number 770747	6008256.52807	2110680.03106	37.7759913537931	-122.414931236282	(37.7759913537931, -122.414931236282)	8	2	9	28853	34
190324	253494	2	116	1x Gordon St	12	Sidewalk: Curb side : Cutout	Tree	2	09/12/2017 12:00:00 AM	3	3x3	Permit Number 772214	6009763	2109812	37.7736924789578	-122.409658650953	(37.7736924789578, -122.409658650953)	8	2	9	28853	34