The development of a data structure for the storage of preliminary site investigation data

The investigation of a contaminated site requires both the collection of qualitative information and quantitative data, which then need to be evaluated and assessed in terms of the effect on the environment, human health, construction materials and other sensitive targets. Hence, multi-stage investigations are usually undertaken on potentially contaminated sites to provide data for the risk assessment process. Addressing the complex parameters involved in the risk assessment process comprehensively and successfully requires expertise and knowledge from a number of disciplines ranging from geotechnical engineers to chemists. To assist with this process at the preliminary stage of the investigation, a prototype knowledge-based system(ATTIC: Assessment Tool for The Investigation of Contaminated Land) and database have been developed to capture the wealth of knowledge required and enforce a structured approach to the investigation. This paper describes the development of the database component of the system which allows the storage of preliminary site investigation data. The design process and the implementation of the data structure are discussed. The data structure developed has the ability to store all aspects of preliminary site investigation information, ranging from historical data relating to the site to data relating to vegetation and fauna. Details of the database tables with examples are also presented within the paper. The data structure was implemented using Microsoft Access Relational Database Management System. With the preliminary investigation data stored in such a manner it also allows data to be passed to other software, hence making data available for the knowledge-based system, to use within its rules.