This STP table contains the results of the Rainfall-Runoff Module. The data is input for the Balancing and Allocation Sub-Module.
In the Rainfall-Runoff Module, monthly groundwater recharge had been calculated and stored in raster tables of 2km x 2km size. For balancing purposes, long-term annual averages had been calculated and then adjusted to groundwater safe yield (excluding, for instance, spring flow which will appear as baseflow). Than, the values were summed-up for the balancing units of each balancing layer and stored to table STP_GROUNDWATER. The field name GW_CELL_ID stems from an earlier consideration and contains now the code for the balancing unit.
The table structure follows the concept of the other STP tables. For every balancing unit, 12 monthly values (water volumes) for 8 planning horizons and 3 scenarios can be stored. The table's field list will contain fields for the unique identifier (WEP), the scenario, the water year, the month, the water volume (GROUNDWATER) and the salinity.
Because groundwater safe yield is a long-term average, all monthly values for a cell and a scenario are identical. Figures for mining of fossil groundwater are contained in table STP_ADDITIONAL_RESOURCES.
Example of table data for STP_GROUNDWATER
| GW_CELL_ID | SCENARIO | YEAR | MONTH | GROUNDWATER | SALINITY |
|---|---|---|---|---|---|
| BA | 1 | 2005 | 1 | 1234135 | 1 |
| BA | 1 | 2005 | 2 | 1234135 | 1 |
| BA | 1 | 2005 | 3 | 1234135 | 1 |
| ... |