Functional Requirements

The following are typical Functional Requirements delivered by ESdat Online, ESdat Server and ESdat Desktop (when used in conjunction with ESdat Server).

  ESdat
Desktop
ESdat
Server
ESdat
Online

Permissions

   
User Configurable Permissions Groundwater Database Environmental Data Environmental Data
Create, Read, Update and Delete Permissions
can be set per user at the Project and/or Site Level
Environmental Data Environmental Data Environmental Data
Windows Authentication Login available Water Management Software Environmental Data
Password Login available Water Management Software Environmental Data Environmental Data
     

Data Import

Automated import of laboratory / logger and other data
(webservice or email)
  Groundwater Database Groundwater Database
Manual Import of laboratory, logger and Field data Groundwater Database Groundwater Database Groundwater Database
Can import directly from Excel (with customisable forms) Groundwater Database Groundwater Database
Web service API for automated uploads and data integration  
       

Tablet or Phone Interfaces

Configurable.   Environmental Data Environmental Data
Workflow completion of field tasks.   Environmental Data Environmental Data
Online Entry of field data, comments and photographs.
example
  Environmental Data Environmental Data
Offline Entry of field data, comments and photographs.  
Locations search for specific or nearby locations while in the field.   Environmental Data Environmental Data
View previous field results, photographs or documents relevant to a location while in the field. example   Environmental Data Environmental Data
     

Validation & QA

Reject invalid values during import Water Management Software Water Management Software Water Management Software
Sophisticated error reporting in clear english Water Management Software Water Management Software Water Management Software
Performs QA of Laboratory Results
(duplicates, blanks, spikes, ionic balance etc)
Water Management Software Water Management Software Water Management Software
Flag data quality with a quality qualifier
Signoff of data acceptance Water Management Software Water Management Software Water Management Software
     

Audit trail of changes to the data

Tracks and records edits and deletions      
Lock data for changing after acceptance signoff   Water Management Software Water Management Software
     

Data Processing

Reconcile results reported in different units
ie mg/L and ug/L
Environmental Data Environmental Data Environmental Data
Reconcile results reported with different names
ie Lead and Lead (Pb)
Water Management Software Water Management Software Environmental Data
Reconcile different methods of reporting
ie Nitrate(as NO3) and Nitrate(as N)
Water Management Software Water Management Software Environmental Data
Customisable data processing Water Management Software Water Management Software
     

Spatial functionality

Ad-hoc data querying and reporting Dust Deposition Sampling Environmental Data Environmental Data
Embedded GIS Dust Deposition Sampling Environmental Data Environmental Data
GIS can Tabluate Chemistry Results as a label for each location. example Environmental Data
Reads Open Geoscience Consortium WFS/WMS layers Environmental Data Environmental Data Environmental Data
Serves ESdat data in Open Geoscience Consortium WFS layers   Environmental Data
Public and/or client Interface for map based presentation of results. example   Environmental Data
     

Reporting

   
Ad-hoc data querying and reporting Dust Deposition Sampling Environmental Data Environmental Data
Chemistry Tables highlighting non-compliance with Environmental Standards (with export to Excel)
Environmental Data Environmental Data
Graphs
Trend Analysis (Manne Kendall and Linear Regression) Environmental Data
Geo-chemical conversions and graphs (eg mEq and Piper diagrams) Water Management Software
Pivot Tables
Customisable reports using standard reporting software (ie SQL Server Reporting Services or Crystal Reports)  
     

Regulatory Compliance

Regulatory environmental standards are provided and maintained Environmental Data Environmental Data
Exceedance levels can be set for a whole site or individual Locations Site Only Environmental Data
Store original documents (calibration, lab certificate etc) Environmental Data Environmental Data
     

Notifications

   
Email or Dashboard   Environmental Data
Compliance Exceedances   Environmental Data
Workflow milestones incl:
  • Monitoring is due
  • Monitoring Started & completed
  • Laboratory Report Overdue
  • Laboratory Report Received
  •   Environmental Data Environmental Data
         

    Data Access

       
    Has a Webservice API for data sharing Groundwater Database Groundwater Database
    Direct database access available Groundwater Database Groundwater Database
    Database can be extended as required Groundwater Database Groundwater Database
         

    Integrates with Other Applications

    Excel Environmental Data Environmental Data
    Surfer
    ArcView Environmental Data Environmental Data
    MapInfo Environmental Data Environmental Data Environmental Data
    ESlog Environmental Data Environmental Data Environmental Data
    gINT Environmental Data
    ProUCL Environmental Data Environmental Data Environmental Data
    Google Earth Environmental Data Environmental Data Environmental Data
    Modflow / FeFlow (via .grd file)
    EVS / MVS

     

    ESdat can also be customized to accommodate any specialist data not accommodated in the standard system.  For example, it has been customized to manage lease and landholder contact tracking amongst others.

    = Available as optional extension