During
the development of the Nile basin DSS, a number of consultation meetings and
workshops were held to identify the key indicators that stakeholders in the
Nile Basin are most interested in. This was part of a consultancy called 'Data
Compilation and Pilot Application of the Nile Basin Decision Support System'.
Based upon the discussions between the stakeholders, the consultant identified
a number of key indicators that can be used in the DSS to evaluate scenarios
and undertake MCA and CBA. These indicators were divided into the following
three categories:
- Social indicators
- Environmental indicators
- Economic indicators
A scripting library was developed for the calculation of the above indicators. The scripts are organized into the following eight storages:
· BaseUtils: Generic scripts for common mathematical calculations, interpolation, lookups etc.
· SpreadsheetUtils: Scripts for accessing DSS spreadsheets and retrieving arrays and/or lookup values from the spreadsheets.
· IndicatorUtils: Supporting scripts for calculating environmental, social and economic indicators and calculation of ecologically relevant time series statistics.
· NBIScripts: Scripts for calculation of food production indicators (Developed by NBI)
· RasterUtils: Scripts for raster processing, mainly for flood damage calculations.
· Environmental Indicators: Scripts for calculation of environmental indicators.
· Social Indicators: Scripts for calculation of social indicators.
· Economic Indicators Scripts for calculation of economic indicators.
Figure 1 shows the dependencies between the above script storages.
Figure 1: Script Storages and Dependencies
In the following section, definition of the scripts that are used to calculate the DDS indicators is given.
Scripts Definition
In this section, for each predefined script, the following is presented:
1. script sub-category
2. script name
3. a description of what the script does
Social Indicators
|
Sub-category
|
NB-DSS Script name
|
Description
|
|
Water Availability
|
SO1_WaterAvailability
|
Calculates the change in availability of water for riparian users: domestic consumption, subsistence agriculture and livestock
|
|
Community Health and Safety
|
SO2_MalariaEndemicity
|
Calculates the susceptibility of irrigation scheme areas to malaria based on WHO malaria incidence map for Africa
|
|
SO3_PestDiseasePrevalence
|
Calculates the prevalence of diseases resulting from pest species
|
|
|
SO4_UrbanPollution
|
Calculates the water pollution downstream major urban areas
|
|
|
SO5_HouseholdsFlooded
|
Calculates the No households within the 100 year flood line
|
|
|
SO6_DrowningRisk
|
Calculates the drowning risk due to conveyance of water in an open canal
|
|
|
Food security and Livelihoods
|
SO7_FormalIrrigation
|
Calculates the footprint area due to establishment of new irrigation schemes
|
|
SO81_RecessionAgricFloodPlain
|
Calculates the impact on Recession agriculture due to floodplain inundation
|
|
|
SO82_RecessionAgricBank
|
Calculates the impact on Recession agriculture due bank instability
|
|
|
SO91_FishProductionDam
|
Calculates the change in fish productivity in a dam, lake, or wetland
|
|
|
SO92_FishProductionRiver
|
Calculates the change in fish productivity along a river reach
|
|
|
SO10_ProductiveLandUse
|
Calculates the productive land use for crops, grazing inundated by dam or lost due to establishment of an irrigation scheme or a canal
|
|
|
SO11_LossNaturalResources
|
Calculates the change loss of access to natural resources due to inundation by dam or establishment of an irrigation scheme or a canal
|
|
|
Displacement
|
SO12_PhysicalDisplacement
|
Calculates the physical displacement of population due to inundation by a dam, establishment of an irrigation scheme or construction of a canal
|
|
SO13_EconomicDisplacement
|
Calculates the economic displacement due to disruption of access to natural resources (cattle, people, wildlife) as a result of a canal and/or a dam construction
|
Environmental Indicators
|
Sub-Category
|
NB-DSS Script Name
|
Description
|
|
Footprint Areas
|
EN1_EnvSensitiveAreas
|
Calculates the extent of Environmentally Sensitive Area within a dam, irrigation scheme or canal footprint
|
|
EN11_EnvSensitiveRating
|
Calculates the impact rating on environmentally sensitive area within a dam, irrigation scheme or canal footprint
|
|
|
EN12_HotspotRating
|
Determines the wetlands of international importance (Ramsar Sites) and Important Bird Areas (IBAs) that fall outside of protected areas, but within primary impact zones.
|
|
|
EN2_Carbon
|
Calculates the area of woody biomass and biomass carbon within dam footprint
|
|
|
EN3_FishProduction
|
Estimates fish production from a dam, lake or a wetland
|
|
|
Downstream Areas
|
EN4_FloodPlainInundation
|
Calculates the floodplain area inundated compared to a baseline
|
|
EN42_WetlandArea
|
Calculates the wetland area inundated compared to a baseline
|
|
|
EN5_EcoStressRating
|
Determines ecological stress rating from changes in key flow components and flow variability compared to baseline.
|
|
|
EN6_WetDuration
|
Calculates the wet season duration based on median monthly flows
|
|
|
EN7_BlackFlyRating
|
Determines black fly rating from HP operation, changes in low flows and variability compared to baseline.
|
|
|
EN8_BankStability
|
Calculates bank stability rating downstream of impoundment based on standard deviation of flows and predefined sinuosity
|
|
|
EN9_RecoveryDistance
|
Estimates recovery distance based on median discharge from impoundment and distance to downstream tributary
|
|
|
EN10_WetSeasonShift
|
Calculates number of weeks delay in the onset of wet season compared to a baseline
|
|
|
Water Quality
|
EN11_PhytoPlankton
|
Estimated the phytoplankton growth potential based on empirical relationship with retention time
|
|
EN12_AquaticMacrophyte
|
Estimates aquatic macrophyte growth potential based on empirical relationship with nitrate concentration in irrigation scheme return flow
|
Economic Indicators
|
Category
|
NB-DSS Script Name
|
Description
|
|
Navigation
|
EC1_Navigation
|
Calculates number of days above baseline flow threshold or change relative to baseline
|
|
Energy
|
EC21_AverageEnergy
|
Calculates average energy generated at specific hydropower node over a specified period
|
|
EC22_AverageEnergy_System
|
Calculates system wide average annual energy
|
|
|
Water conservation
|
EC31_EvapLoss
|
Calculates average annual evaporation from a dam, a wetland or a lake
|
|
EC32_EvapLoss_System
|
Calculates system wide average annual evaporation
|
|
|
Floods
|
Flood Damage
|
Calculates flood damage based on damage-depth relationships for different land use types
|
|
Food production
|
EC51_FoodProductionSingle
|
Calculates food production of new irrigation schemes
|
|
EC51_FoodProduction
|
Calculates the potential reduction in crop yield of existing irrigation schemes due to upstream developments
|
|
|
EC51_ProductionIncomeSingle
|
Calculates actual crop income of new irrigation schemes
|
|
|
EC51_ProductionIncome
|
Calculates change in crop income of existing irrigation schemes due to upstream developments
|