Earth-Science Data Manager (ESDAT) is designed to meet the needs of Contaminated / Industrial Site, Groundwater, and Landfill Investigations, as well as general environmental data management.
ESdat Desktop is a comprehensive environmental database system; used to validate, import, ad-hoc analyse and report a broad spectrum of Environmental Data. It can be customised, and is suitable for use by a scientific or engineering userbase.
Importing Environmental Data:
Import laboratory data
ESdat can receive laboratory data in a “ready to use” format that imports directly into ESdat. Just ask your laboratory for the ESdat format.
Importing laboratory data directly into ESdat removes transcription time and typographic errors, and increases the ability to effectively check the data using the QA tools that ESdat provides.
The optional "Laboratory Initiated Upload" Server Upgrade means laboratory reports can be automatically uploaded by the lab, and users receive an email with a link to review the laboratory report directly in the browser.
Electronic data exchange with the lab doesn't need to be limited to just receiving the results in ESdat format. You can exchange all data with the laboratory electronically, including electronic Chain of Custody (COC) - Requires LSPECS.
Continuously recording logger data can be uploaded into ESdat from logger files, or a link can be set up to import data automatically (requires ESdat Data Services Server Upgrade).
An easy to use import template is provided for logger data formats that are not recognized.
Time series logger data can be graphed against other logger data, or chemistry or water level data.
Import Historical Data
Data in historical datasets can be imported into ESdat directly from spreadsheets, or from a variety of other database formats.
Historical data, if stored in a spreadsheet, is generally the most complex to import. It is often inconsistent and needs cleaning.
The ability to import data straight from Excel, means this process can be handled relatively easily. Tutorials are available to help users understand this process.
Import Data Assistance
ESdat distributors are often highly experienced and efficient at importing data from other systems, or from spreadsheets. You may find that it can be done cheaper and more accurately than doing it in-house.
Import Field Notes
Re-writing field notes when back in the office isn't ideal, however in some instances users may not have access to a Tablet, or field staff may prefer to use paper.
Field Notes can be imported into ESdat from Excel spreadsheets (among other mechanisms).
Field Notes included in these categories includes: Location survey details, Groundwater Levels, Field Chemistry (pH, EC etc..), Borehole Log data, general comments, scan of original field documents.
Electronic data collection on Tablets is available either using the ESdat Field Portal or PLog
Data Analysis and Reporting:
ESdat provides for comparison against Environmental Standards and for data analysis, reporting and integration with other software
View your data on Exceedance Tables, Trend Graphs, Maps; as statistics and more.
Environmental GIS with data labelling
ESdat has an internal environmental focussed GIS, providing chemical and geological labels and point coloring at the click of a button. Features Include:
Chemistry-Specific Data Labels showing compounds across or down, verses depth or date.
Exceedances of specific guidelines highlighted
Attribute or result coloring (or max / min / average at each point)
ESdat has it's own in-built GIS and can export to ArcView/ArcMap, MapInfo, Google Earth, DXF, and Surfer if desired.
This internal GIS is designed to allow users to easily see where their data is located and easily view their data as logical labels. This kind of ease of use and label output, particularly for timeseries or depthseries chemical labels, isn't available in generic GIS packages.
Trend Analysis and Graphs
ESdat Desktop: Mann Kendall and Linear Regression trend graphs can be produced for any time-series data. Features of graphs include:
ESdat is a specialist environmental database system; used to validate, import, analyse and report your data. View your data on Exceedance Tables, Trend Graphs, Maps; as statistics and more.
Formatted Chemistry Tables
Chemistry Tables are produced and exported to Excel. Users are able to specify:
compound orientation & grouping,
environmental standards to be included,
- other settings
Chemical Quality Assurance
ESdat is able to produce a Chemical Quality Assurance Report summarising the following QA checks and flagging any potential issues:
Field Duplicates and Triplicates (RPD values)
Field Blanks, Trip Blanks, Rinsates
Lab Duplicates (RPD values)
Inorganic Logic Checks (Ionic Balance, TDS>Na+Cl,COD>BOD etc..)
Lab Control Samples/Reference Materials
gINT and WinLog ESdat can export data to either of these bore logging packages, meaning all your data is centrally stored.
ArcView, MapInfo, Surfer and Google Earth are GIS and mapping applications. ESdat has internal mapping functionality, and can also export to these packages.
EVS (Environmental Visualisation System) is a 3D visualisation and modelling package.
ProUCL ;provides many calculations useful for contaminated sites, including 95 percentile calculations using a variety of data distributions (ie normal, log-normal, non-parametric).
Excel can receive a direct data dump, or graphs or formatted tables can be exported.