To create a user-friendly but multi-functional central data base to store, and make available for analysis, all data collected/collated in Workpackages 5, 6, 7, 8 and 9.
The database will be developed in a single Member State, the United Kingdom, under the direction of a technical sub-committee comprising Germany, The Netherlands, Austria and Sweden. The database will be developed in MS ACCESS with particular attention being paid to the development of user-friendly front-end access, a simple menu of preprogrammed queries and clear, relevant date output forms. These will include simple verification forms for data-input validation.
The database will be designed to hold the results of all the sampling programmes comprising the current proposal. It will comprise a spatially-referenced relational set of data comprising locational information, biological data comprising species names, abundances and functional roles and traits, relevant index values for each taxon (e.g. Saprobien values, Biological Monitoring Working Party scores, Mean Trophic Rank and Trophic Diatom Index values etc.), environmental information for site characterisation and prediction purposes, River Habitat Survey information, the parameter from the AQEM site protocol, information on the laboratories and personnel responsible for significant stages in the data acquisition processes and meta-data fields, including audit information.
Taxon entry will be facilitated by uniformly accepted taxonomic codes, that may be cross-translated to other coding systems in common European usage (see Workpackage 13).
|
Overview | |