Exporting data

CSV

GET /api/export/<wrua> returns the monthly reallocation rows for one WRUA as CSV.

Columns include:

• month, WRUA_NAME, band_id, elev_min, elev_max
• Areas: area_deficit_ha, area_optimal_ha, area_surplus_ha
• Volumes (Mm³): vol_surplus_Mm3, vol_deficit_net_Mm3, vol_deficit_gross_Mm3
• Efficiencies: Ec, Ea, E
• Reallocation flows: inflow_surplus_Mm3, total_available_Mm3, deficit_met_*, unmet_deficit_*, surplus_transferred_down_Mm3

band_id is the watershed polygon identifier for the sub-watershed.

PDF report

GET /api/report/<wrua> renders a 10-page IWMI-branded PDF (~1.3 MB) with:

1. Cover (WRUA name, area, sub-watershed count, elevation range, sub-basin)
2. Introduction to SWAG-DSS
3. Methodology, 3 scenarios
4. WRUA assessment (maps, water balance summary, monthly table)
5. Intervention requirements (priority sites table, scenario comparison)
6. Conclusions, recommendations
7. Data sources

The Priority Sites table is 6 columns: Watershed (WS id), Elev (m), Deficit (m³), Ponds, Built, Priority. Each WS id is the watershed hydro_id, traceable to the source GeoPackage.