Project: Environmental data management support for a site requiring remediation
Client: EDSR Ltd
Services: Geographical Information Systems, environmental data management and reporting services
Summary: ESI provided support to EDSR Ltd in setting up an environmental data management project using EQuIS 5 Professional and EnviroInsite. Data was migrated from legacy spreadsheets into EQuIS 5. The analysis and reporting included 2D and 3D chemical concentrations spatial plots, geochemical cross-sections and site plans with timeseries chemical plots, charts, statistics and cross-tab data. The client was able to deliver the figures efficiently, on-time and with confidence in the data
Remediation sites are notorious for collecting large amounts of geological and chemical data. Critical financial decisions are often made upon the data collected from the site. It is imperative to have confidence in the process of collection, processing, analysing and reporting of data.
In recognition of this, EDSR Ltd contacted ESI to request support for setting up an environmental data management system for a large remediation project in Portugal.
As the data was supplied in crosstab format, it firstly had to be transformed into a flat file format suitable for input into an EQuIS 5 Professional database. The data included well construction information, geology logs and chemistry data. As part of the quality assurance and quality control process, the data had to pass through the EQuIS Electronic Data Processor (EDP) for verification and validation.
Once the data was successfully imported into the EQuIS 5 Professional database then a series of spatial groups were developed to zone the site into areas of concern. In addition, chemical groups were developed to consistently report chemical data from different laboratories.
The data was reported using a combination of EnviroInsite and EQuIS 5 Professional. EnviroInsite was used for spatial plots of contaminants over time, geological cross sections and 2D and 3D concentration plots. EQuIS 5 Professional was used for reporting charts and crosstab reports. Remote assistance was provided throughout the project with the use of web-based desktop sharing tools.