ESdat Desktop

ESdat Desktop is a powerful importing, analysis and reporting tool; used to validate, import, analyze and report a broad spectrum of Environmental Data.

Responsive image

ESdat Desktop is for Power Users to upload their own historical data, effectively interrogate the raw data being used within the database, and automatically launch and send data to other Desktop Applications.

ESdat Desktop is able to upload bulk data to ESdat Server directly from Excel or other data sources.

The import includes validation and error reporting. The example below shows historical chemistry in a "Cross-Tab" layout being validated and has flagged an unrecognised location.

ESdat historical chemistry upload

The uploaded data can be interrogated and reported in either of ESdat Desktop or the ESdat Web Interface.

ESdat Desktop is able to filter data using SQL-type filters, and apply bulk data edits similar to how users are used to being able to do in Excel.

Users can view, filter and edit grids of data from multiple sites or projects, enabling detailed interrogation of large volumes of data.

ESdat historical chemistry upload

ESdat Desktop is able to launch and populate data into the following applications on your PC.

Excel

A direct data dump, graphs or formatted tables can be exported.

ArcView, MapInfo and Google Earth

ArcView, MapInfo and Google Earth are GIS and mapping applications. ESdat has internal mapping functionality, and can also export to these packages.See MapInfo Discover PPT

Surfer

ESdat users are able to filter for required data, specify a gridding method (eg Krigging) and ESdat will open Surfer showing the data already contoured.

EVS

EVS (Environmental Visualization System) is a 3D visualization and modelling package. See video. See paper

ESlog

ESlog is a bore logging application produced by the ESdat developers. It is free to use and bore logging data in ESdat can be automatically presented as logs. Read more.

ProUCL

ProUCL provides many calculations useful for contaminated sites, including 95 percentile calculations using a variety of data distributions (ie normal, log-normal, non-parametric).



ESdat Desktop provides a comprehensive range of analysis functions, replicating or extending those available through the ESdat Web Interface.

An inbuilt GIS, provides chemical and geological labels and point/attribute 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)
  • Moveable labels

ESdat has it's own in-built GIS and can export to ArcView/ArcMap, MapInfo, Google Earth, DXF, and Surfer if desired. 

Environmental GIS, ESdat Maps/Spatial Analysis with export to ArcGIS, MapInfo, and Surfer

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.

Click here to see video

Mann Kendall and Linear Regression trend graphs can be produced for any time-series data.  Features of graphs include:

Trends
  • Mann Kendal or Linear Regression trends can be produced and annotated on the graph
    (TUp, TDn & LH = Trending Up, Trending Down,Last value Highest)
  • Environmental guidelines / Action Levels can be included.
  • Produced in Excel and can be saved and opened directly in Excel and update live from the database.
  • Templates can be customized.

ESdat Mann Kendall Trend Analysis and Graphs

Chemistry Tables are produced and exported to Excel.  Users are able to specify:

  • compound orientation & grouping,
  • environmental standards to be included,
  • exceedance formatting,
  • statistics,
  • templates,
  • other settings.

Formatted Chemistry Tables

Formatted Chemistry Tables

Click here to see video

ESdat is able to produce a Chemical Quality Assurance Report summarizing the following QA checks and flagging any potential issues.

Field QA
  • Field Duplicates and Triplicates (RPD values)
  • Field Blanks, Trip Blanks, Rinsates
  • Trip Spikes
Lab QA
  • Lab Duplicates (RPD values)
  • Holding Times
  • Inorganic Logic Checks (Ionic Balance, TDS>Na+Cl,COD>BOD etc..)
  • Lab Control Samples/Reference Materials
  • Matrix Spikes
  • Surrogates