Summary report API

[giohappy]

The reports API should acccept a set of parameters to generate reports with dynamic configuration.

The API should accept a set of parameters to define

1. the elements to be included (rows in the report table):

• Rank (order, family ,genus, species…or natural area)
• Reservation (one or several)
• Watershed (one or several)
• County (one or several)
• Quad (one or several)
• Global Status (G-rank) (one or several)
• State Status (one or several)
• CM Status (one or several)
• Observer (string or blank)
• Observation Date Range (from date, from date - to date, to date, or blank)

2. the field (columns of the report table):
   • DB ID
   • Genus
   • Species
   • Common name
   • Natural Area Description (if natural area is chosen instead of taxonomic rank)
   • Observation Date
   • Observer name
   • Site description
   • Reservation
   • Watershed
   • Global Status (G-Rank)
   • Federal Status (N-Rank??)
   • State Status (S-Rank)
   • CM Status (CM-Rank)
   • Latitude
   • Longitude
   • Count (in case of repeated rows we just set the count. 1 in case of single row)

Output example:

[ricardogsilva]

While implementing this I've stumbled upon the Location.reservation and Location.watershed attributes, which we currently allow to have multiple values. IMHO it seems strange that a single occurrence would be located in multiple reservations and watersheds. Perhaps we should ask the client if this is correct?

[giohappy]

Probably you're right but I would leave it as it is. AFAIU, In some circustances, an occurence can comprise multiple obervations.