Data Management

CSV and Raster Upload Workflows

Step-by-step instructions for uploading GeoTIFF raster files and processing CSV data for price, malnutrition, and other modules.


GeoTIFF Raster Upload

For spatial modules (rainfall, temperature), data is uploaded as GeoTIFF files:

  1. Navigate to the module's main page (e.g., Forecast Rainfall → Weekly → Total).
  2. Click the Upload button.
  3. Select the GeoTIFF file(s) for the forecast date.
  4. Submit the form. The server calculates zonal statistics for each IGAD region/country/admin unit and stores the values in the database.

Uploaded raster files are stored under media/geodata/ and referenced by their file path in the database.

CSV Upload for Prices and Malnutrition

Use the management commands with the relevant CSV file:

# WFP food prices
python manage.py process_wfp_food_csv --country KE --year 2024

# WFP food prices (clear existing data first)
python manage.py process_wfp_food_csv --country ET --year 2024 --clear

# Malnutrition admissions
python manage.py process_sam_admission
python manage.py process_gam_admission

Bulk Delete

To remove erroneous data imports:

python manage.py bulk_delete_food_prices
python manage.py bulk_delete_livestock_prices
python manage.py water_bulk_delete