Environmental Data Management for Site Holders

Many site-holders engage a variety of consultants, laboratories, and in-house staff to collect, manage and report their environmental data.

Unfortunately this often results in data being trapped in various pdf reports, GIS layers, emails, excel workbooks, or even in hard copy. This data becomes increasingly difficult and time consuming to manage and retrieve as more data is collected and as legislative reporting requirements become more rigorous.

Organizations increasingly need professional staff to be able to quickly analyze their data using flexible and relevant mapping, graphing, statistical and Excel based tools, that can manage non-detects, exceedances, and complex datasets.

This means all environmental data needs to be consolidated into a single system which has tools to seamlessly manage, analyze and report the data. Data needs to be audited, reliable, and easily available. Key aspects of requirements are included below.

Efficient and Accurate Data Receipt and Consolidation

Most organizations receive the majority of their environmental data from consistent sources on an ongoing basis. If this data is being manually retyped into another format (such as spreadsheets) it is inevitable that errors will creep in, and that significant time will be invested to enter, check, and recheck the data.

In addition staff should have the ability to easily perform QA checks on the data during the receipt process. These might include:

Any data management system should automate all of these tasks, eliminating the time and the need to manually manipulate data. In a recent survey, most users of the ESdat system saved over 40% of their office time working with their data (see ESdat User Survey)

Combining new data.

Traditionally, whenever additional data is received it is necessary to update two or three copies of existing data, such as tables, graphs, maps or statistics. This is error prone and the multiple copies of the data lead to possible inconsistencies.

Data management Systems should eliminates this problem by combining all data into a single database; from which outputs are easily re-generated. ESdat also allows Excel files can be automatically updated from the database.

Sharing data among users/organizations

Within any single team there is typically a variety of methods used to manage environmental data, which reflects the Microsoft Excel or Access skill level for each individual.

Sharing data between team members is usually time consuming and imperfect as people need to learn how to find and use data managed by others.

If all team members access data from a consistent system, then data can be easily shared. Availability of automated tools to produce Tables, Graphs, Maps, and statistics means staff can easily and quickly analyze new datasets.

Regulatory and Standards Compliance

Many site holders have a regulatory obligation to be able to access and report their environmental data quickly, easily, accurately, and demonstrate an audit process to confirm the accuracy of that data. ISO 14001 also requires organizations to have systems in place to manage their data. Copying and pasting data in Excel is not consistent with those obligations.

A data management system should store a complete audit trail of the data, including Certified Laboratory Documentation, Calibration, or other certificates, as well as automate imports and track edits and deletions. Reports should be available using ad-hoc, or recurring data filters. ESdat provides all of this functionality.

Functionality Requirements

Standard GIS systems are not able to easily provide the outputs that environmental professionals require. Below are an example of some outputs often needed, that are difficult to generate from within a standard GIS based system.

chemistry exceedance tables
Formatted Chemistry Exceedance Tables

Multiple parameter trigger level graphs
Graphs with multiple parameters and trigger levels

time-series or depth data with flagged exceedances
Maps with time-series or depth data, and exceedances flagged

attribute colouring and range of values on map
Maps with attribute coloring and range of values at each point


Implementation Time

Often when organizations find they have a data management issue it needs to be resolved immediately.

ESdat can be installed, operational and users trained within days if necessary. You can immediately start requesting your laboratory files in ESdat format from most leading laboratories.

If some integration or customization work is requested (typically not required) users can start using the software immediately and customization can come on-line as available.

Business Case

Ultimately there needs to be a business case to purchase any environmental database system. In developing your business case it is often necessary to consider:

More Information about ESdat

This document was prepared by EarthScience Information Systems, and Australian Company that develops the ESdat software. ESdat is used for environmental data management by many of Australia’s leading site holders and consultants, and is supported by all major laboratories. For more information please see:

ESdat Web Site , Current Users , PDF Brochure , Purchase

Environmental Datamanagement