User's Functional Requirements

The following are typical Functional Requirements for a medium or large implementation.

  Supported
ESdat Desktop ESdat Desktop with Server Upgrade

Database

   
Relational database structure Groundwater Database Groundwater Database
Database can be extended as required Groundwater Database Groundwater Database
Central enterprise (SQL Server) database  
     

Permissions

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

Data Import

   
Automated import of laboratory / logger and other data
(webservice or email)
  Groundwater Database
Manual Import of laboratory / logger and other data 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.  
Workflow completion of field tasks.  
Online Entry of field data, comments and photographs.
example
 
Offline Entry of field data, comments and photographs.  
Locations search for specific or nearby locations.  
View previous field data, photographs or documents relevant to a location. example  
     

Validation & QA

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

Data Processing

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

Spatial functionality

   
Ad-hoc data querying and reporting Dust Deposition Sampling Environmental Data
Embedded GIS (reduce other software costs) and integration with ArcView and MapInfo Dust Deposition Sampling Environmental Data
GIS can Tabluate Chemistry Results as a label for each location. example
Reads Open Geoscience Consortium WFS/WMS layers 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  
     

Reporting

   
Ad-hoc data querying and reporting Dust Deposition Sampling Environmental Data
Chemistry Tables highlighting non-compliance with Environmental Standards (with export to Excel)
example
Environmental Data
Graphs Environmental Data
Trend Analysis (Manne Kendall and Linear Regression) Environmental Data Environmental Data
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, an individual Location, or a recurring Monitoring Program Site Level 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
         

    Integrates with Other Applications

       
    Has a webservice API   Environmental Data
    Other applications can read directly (ie ODBC) Environmental Data Environmental Data
    Excel Environmental Data
    Surfer Environmental Data
    ArcView Environmental Data
    MapInfo Environmental Data Environmental Data
    gINT Environmental Data Environmental Data
    WinLog Environmental Data Environmental Data
    ProUCL Environmental Data Environmental Data
    Google Earth 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

     

    • Contact
    • 100% of environmental professionals saved time when using Esdat Environmental Data Software. Over 50% of professionals achieved time savings of at least 40%.
    • © 2017