Ecological modelling of nitrate pollution in small river basins by spreadsheets and GIS

With the increasing importance and awareness of water quality in the small basins, the modelling system is developed for monitoring and predictions of surface water pollution. The compartment model deals with basin characteristics extended by land cover attributes. The parameters of the model are estimated by experimental data of water quality together with land cover types that serve as nutrient detention media or transformers. The study examines methodology to determine the potential areas of nitrate pollution from point and non-point sources by remote sensing techniques. Classification of water, agricultural, forest and urban areas is processed with satellite images (LANDSAT 7). Whereas the agricultural and urban areas act as sources of pollution, forest zones operate as sinks. The nitrate levels are decreased downstream, if the proportion of the forest inside contribution zones increases. The modelling system is used to simulate amounts of nitrates in each compartment of the stream during the monitored period of one year. The number of compartments and their lengths are estimated on the basis of morphology of the basin. Simulation of the dynamic model is carried out with the TabSim. Geographic information system (GIS) and remote sensing tools are used to manage and estimate nitrate inflows from point and non-point sources of pollution. The article presents the spatial and time variation of the nitrate (NO₃⁻) within the basin of the stream Rakovnický (the west part of Bohemia, the whole area of 368 km²). It is shown that the model approach extended by the GIS and remote sensing can support decision-making process for better management practices in the basins.