- In exportable tabular format, show the points/lines contained within each polygon and their attributes, i.e. the result of a one-to-many spatial join between the polygons and points.
- Optional for the user, a table like in #1 but aggregated by some summary field of the points/lines (specified by the user via drop-downs menus or whatever), like the tabular part of a Dissolve operation in desktop ArcGIS, on some specific dissolve field. So for each polygon, they could read the total length of the lines it contains, etc.
The report table doesn't have to show up in the browser (though that would be quite desirable), but does have to be exportable to some common format like CSV or preferably Excel.
Does anyone know the best/quickest way to accomplish this?
- Reading table attribute values directly via a queryTask & printing them out (à la this ESRI sample), but in a more complex tabular format, e.g. dynamically filling a nice-looking HTML table with the attribute values, then exporting the table as CSV (which cursory Googling suggests might be possible in one way or another).
- Making use of a dgrid at least for display, but somehow linked to the above table manipulations. I don't know much about dgrid. Then export this, which appears to be possible with the Exporter plug-in for Dojox EnhancedGrid.
Is there any easier way to do this or other possibilities?
Any warnings about the viability of the above?
I just want to scope out a smart method before striking out blindly.