Climate variables aggregated by epiweek

[claudia-codeco]

It would be very useful for Infodengue to have tables with climate statistics already aggregated by epiweek and by municipality, health region or state.

Variables:

• average min temperature
• average mean temperature
• average max temperature
• average min humidity
• average mean humidity
• average max humidity
• mean daily temperature amplitude
• week mm precipitation

@fccoelho , could you help me to specify this issue?

[fccoelho]

@luabida I think you can just add a new endpoint /api//datastore/climate/weekly (or adding a weekly aggregation parameter to the existing endpoint) that points to a view that does the aggregation directly in the database (this is preferable to doing it on the Python side).

Since the weekly aggregation has to be by Epiweek, we should first add an epiweek column to the climate table