trees

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

Query parameters

This data as json, CSV

rowid	TreeID	qLegalStatus_id	qSpecies_id	qAddress	SiteOrder	qSiteInfo	PlantType	qCaretaker_id	qCareAssistant	DBH	PlotSize	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
135904	116578	6	62	2699x OCEAN AVE	1	Sidewalk: Property side : Cutout	Tree	3	DPW	11	3x3	5990602	2095184	37.7324354869182	-122.47487091251	(37.7324354869182, -122.47487091251)	1	8	4	64	40
136506	173630	6	62	2699x OCEAN AVE	2	Sidewalk: Property side : Cutout	Tree	3	DPW		3x3	5990602	2095184	37.7324354869182	-122.47487091251	(37.7324354869182, -122.47487091251)	1	8	4	64	40
145371	116609	4	101	1325x 08TH AVE	4	Sidewalk: Property side : Cutout	Tree	3			3x3	5993613	2106469	37.7635952548206	-122.465280685608	(37.7635952548206, -122.465280685608)	1	8	11	56	12
145690	116607	4	101	1325x 08TH AVE	2	Sidewalk: Curb side : Cutout	Tree	3			3x3	5993613	2106469	37.7635952548206	-122.465280685608	(37.7635952548206, -122.465280685608)	1	8	11	56	12
153596	116608	4	101	1325x 08TH AVE	3	Sidewalk: Curb side : Cutout	Tree	3			3x3	5993613	2106469	37.7635952548206	-122.465280685608	(37.7635952548206, -122.465280685608)	1	8	11	56	12
160410	116604	4	101	1325x 08TH AVE	1	Front Yard : Yard	Tree	3				5993613	2106469	37.7635952548206	-122.465280685608	(37.7635952548206, -122.465280685608)	1	8	11	56	12
161563	116580	6	66	3000x 19TH AVE	3	Sidewalk: Property side : Cutout	Landscaping	3	DPW		3x3	5990602	2095184	37.7324354869182	-122.47487091251	(37.7324354869182, -122.47487091251)	1	8	4	64	40