I'm trying to figure out how to query a point feature class and group that data by a field on the FC that corrisponds to a polygon feature class and show a summary of the points as the lable of the polygons. I have a query that filters the points using various inputs like geometry and attributes and the result set can be quite large. So I don't want to return all the data back to me and group it in Action Script of my widget. What I'd like to do is have the server do the spatial and attribute query and return it grouped by an attribute. An example would be give me all the parking tickets that intersect with a drawn polygon and return the counts grouped by the police precincts so I could show the totals for each precinct as polygons.
My thought was to take my users drawn polygon, for limiting the area to search, and using that to return a set of polygons from the precinct layer and then query the ticket service for the same bounding area to return the totals by precinct and then update the returned precinct features with the values from the ticket service query. I was thinking that if there ins't a way to group or summarize in the REST query I could always use a web service but I'm not sure how to implement the spatial part of that so that only the tickets that fall under the users drawn shape would be used.
