ESdat is a fully robust and extensible environmental database system:
|
|
Edition |
|
Standard |
SQL Server Upgrade |
Database |
|
|
|
Relational database structure |
 |
|
Configurable database
(Standard uses MS Access, or upgrade to SQL Server) |
|
|
|
Other applications can read directly |
|
|
|
Multi-User Access |
|
|
|
Can be extended and customized |
|
|
|
Separate Access database for each project/site |
|
|
|
Central enterprise database |
|
|
|
|
|
|
Data Import |
|
|
|
Auto import of laboratory, field and logger data |
|
|
|
Manual entry option, customizable forms |
|
|
|
Imports directly from Excel |
|
|
|
Web
entry option, customizable forms |
|
 |
|
|
|
|
Permissions
|
|
|
|
User Configurable Permissions |
|
|
|
Read Only, Read/Write & Power User permission options |
|
|
|
Windows Authentication login |
|
|
|
Password login |
|
|
|
|
|
|
Validation & QA
|
|
|
|
Reject invalid values during import |
|
|
|
Create custom validation |
|
|
|
QA of Sample results (duplicates, blanks, spikes, ionic balance etc) |
|
|
|
QA Flag data quality |
|
|
|
Signoff of data acceptance |
|
|
|
|
|
|
Change Tracking
|
|
|
|
Tracks and records edits and deletions |
|
|
|
Lock data for changing after acceptance signoff |
|
|
|
|
|
|
Regulatory Compliance
|
|
|
|
Library of pre-compiled environmental standards |
|
|
|
Add site-specific trigger levels |
|
|
|
Store original documents (calibration, lab certificate etc) |
|
|
|
|
|
|
Outputs
|
|
|
|
Internal GIS (reduce other software costs) |
|
|
|
GIS - CAD style attribute and chemical labeling |
|
|
|
Report ready Chemistry Exceedance Tables |
|
|
|
Time series graphs |
|
|
|
Manne Kendall and Linear Regression Trend Analysis |
|
|
|
Pivot Tables |
|
|
|
Standardize different units & apply conversion on output |
|
|
|
View using different unit profiles for the same data |
|
|
|
Standardize different parameter naming conformant with CAS, US National
Institute of Standards & US EPA where available. |
|
|
|
|
|
|
Integrates with External Applications
|
|
|
|
Excel |
|
|
|
Surfer |
|
|
|
ArcView |
|
|
|
MapInfo |
|
|
|
gINT |
|
|
|
WinLog |
|
|
|
ProUCL |
|
|
|
Google Earth |
|
|
|
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.