trees

Custom SQL query returning 2 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 "SiteOrder" = :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	DBH	PlotSize	PermitNotes	XCoord	YCoord	Latitude	Longitude	Location	Fire Prevention Districts	Police Districts	Supervisor Districts	Zip Codes	Neighborhoods (old)
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
126015	109285	7	65	1530 Sloat Blvd	4	Sidewalk: Curb side : Cutout	Tree	2	FUF	02/05/2015 12:00:00 AM	3	3x3	Permit Number 773632	5986383.9	2095952.1	37.7342991443311	-122.489510139546	(37.7342991443311, -122.489510139546)	1	8	3	64	35